$sql = "SELECT * FROM {$tbn} where id='{$id}'"; $field = array('weight', 'estimate', 'additional_instructions', 'finger_size', 'repair_type', 'loose_stones', 'stone_information', 'due_back_date', 'customer_due_date', 'max_price', 'items_to_return', 'wax_cad_est_req', 'job_status', 'chase_job', 'price', 'uk_cust'); $content .= '<div class="container">' . NewRecordSticky($sql, $field, 'add_details') . '</div>'; } elseif ($sc == 'add_inv_details') { $sql = "SELECT * FROM {$tbn} where id='{$id}'"; $field = array('inv_desc', 'inv_metal', 'inv_price'); $content .= '<div class="container">' . NewRecordSticky($sql, $field, 'add_details') . '</div>'; } } if ($cmd == '[JOBS]' | $cmd == '[HOLD]' | $cmd == '[URGENT]') { $content .= '<div class="container-fluid"><div class="row"><div class="col-md-4">'; $field = array('name', 'job_location', 'repair_type', 'due_back_date'); if ($cmd == '[HOLD]') { $field[] = 'chase_job'; } $sql = JobsList($cmd, $sc); $row_count = mysqli_num_rows(mysqli_query($con, $sql)); $total_pages = ceil($row_count / 30); if ($cmd == '[JOBS]') { $sql .= " order by {$order_by} limit {$start_from}, 30"; } $content .= DisplayTable($sql, $field, 'jobs', $row_count) . Paginate($total_pages) . '</div>'; if ($id != '') { $content .= '<div class="col-md-4">' . JobDetails() . '</div><div class="col-md-4">' . JobNote() . EditJob() . '</div></div></div>'; } } if ($cmd == '[EDIT_JOB]') { $content .= '<div class="container"><div class="pull-right"><a href="?cmd=[DETAIL]&id=' . $_REQUEST['id'] . '" class="btn btn-info">BACK TO JOB</a></div>'; $sql = "SELECT * from {$tbn} where id ='{$id}'"; $field = array('name', 'job_location', 'weight', 'repair_type', 'estimate', 'additional_instructions', 'loose_stones', 'stone_information', 'finger_size', 'date_sent_from_uk', 'date_received_thailand', 'date_sent_from_thailand', 'date_received_back_uk', 'due_back_date', 'customer_due_date', 'max_price', 'photo', 'photo2', 'items_to_return', 'wax_cad_est_req', 'active', 'job_status', 'chase_job', 'uk_cust', 'price', 'urgent', 'cost'); $content .= EditRecordSticky($sql, $field, 'edit_job', 'id', $id) . '<hr ><div class="pull-right"> ' . DeleteRecordForm($id, 'delete_job') . '</div><div class="clearfix"></div><hr ></div>';
$field = array('weight', 'estimate', 'additional_instructions', 'finger_size', 'repair_type', 'loose_stones', 'stone_information', 'due_back_date', 'customer_due_date', 'max_price', 'items_to_return', 'wax_cad_est_req', 'job_status', 'chase_job', 'price', 'uk_cust'); $content .= '<div class="container">' . NewRecordSticky($sql, $field, 'add_details') . '</div>'; } elseif ($sc == 'add_inv_details') { $sql = "SELECT * FROM mmb_bespoke_job where id='{$id}'"; $field = array('inv_desc', 'inv_metal', 'inv_price'); $content .= '<div class="container">' . NewRecordSticky($sql, $field, 'add_details') . '</div>'; } } //Display tables for mmb_bespoke_job if ($cmd == '[JOBS]' | $cmd == '[HOLD]' | $cmd == '[URGENT]') { $content .= '<div class="container-fluid"><div class="row"><div class="col-md-4">'; $field = array('name', 'job_location', 'repair_type', 'due_back_date'); if ($cmd == '[HOLD]') { $field[] = 'chase_job'; } $sql = JobsList(); $row_count = mysqli_num_rows(mysqli_query($con, $sql)); $total_pages = ceil($row_count / 30); #Jobs page is paginated but still needs total of all jobs if ($cmd == '[JOBS]') { $sql .= " order by {$order_by} limit {$start_from}, 30"; } $content .= DisplayTable($sql, $field, 'jobs', $row_count) . Paginate($total_pages) . '</div>'; //Display record details, notes and editable fields if ($id != '') { $content .= '<div class="col-md-4">' . JobDetails() . '</div><div class="col-md-4">' . JobNote() . EditJob() . '</div></div></div>'; } } //Sticky form to edit mmb_bespoke_job record, creates note for changes made. if ($cmd == '[EDIT_JOB]') { $content .= '<div class="container"><div class="pull-right"><a href="?cmd=[DETAIL]&id=' . $_REQUEST['id'] . '" class="btn btn-info">BACK TO JOB</a></div>';