query("job_cards", "SELECT * FROM job_cards WHERE record_id = '{$_GET['record_id']}'"); $job_Card = $job_Card_res->fetch_assoc(); $job_card_no = substr($job_Card['job_card_no'], 0, 2) . "-" . substr($job_Card['job_card_no'], 2); $app = new inner_app(); $app->quick_bar("/app/job_cards"); $app->app_start(); $app_functions = new app_features(); $iframe_popup = new iframe_popup(); ?>

EDIT JOB CARD

CLIENT DETAILS

CONTACT DETAILS

query("job_card_contact_persons", "SELECT * FROM `job_card_contact_persons` WHERE job_card_id = {$_GET['record_id']} ORDER BY record_id ASC"); while ($job_card_contact_details = $job_card_contact_details_res->fetch_assoc()) { echo "
"; } ?>

OPERATION DETAILS

query("job_card_sections", "SELECT * FROM `job_card_sections` WHERE job_card_id = {$_GET['record_id']} ORDER BY record_id ASC"); ?>

JOB CARD SECTIONS


fetch_assoc()) { echo "
"; } ?>

JOB CARD ATTACHMENTS

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()) { $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 "
$comments_amount 
"; } } } ?>

ADDITIONAL DETAILS




NOTES