query("file_categories", "SELECT * FROM `file_categories` ORDER BY record_id ASC");
while ($file_categories = $file_categories_res->fetch_assoc()) {
$job_card_attachments_res = $db->query("job_card_attachments", "SELECT * FROM `job_card_attachments` WHERE job_card_id = {$_GET['record_id']} AND file_category_id = {$file_categories['record_id']} ORDER BY record_id ASC");
if ($job_card_attachments_res->num_rows > 0) {
echo "
{$file_categories['name']}
";
$job_card_attachments_res = $db->query("job_card_attachments", "SELECT * FROM `job_card_attachments` WHERE job_card_id = {$_GET['record_id']} AND file_category_id = {$file_categories['record_id']} ORDER BY record_id ASC");
while ($job_card_attachments = $job_card_attachments_res->fetch_assoc()) {
// get comments for attchments total
$comments_res = $db->query("attachment_notes", "SELECT * FROM `attachment_notes` WHERE job_card_attachment_id = {$job_card_attachments['record_id']} ORDER BY record_id ASC");
$comments_amount = $comments_res->num_rows;
echo "
" . $function->get_file_categories() . "
" . $function->get_file_subcategories($job_card_attachments['file_sub_category_id']) . "
$comments_amount
";
}
}
}
?>