$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>';
