$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>'; } if ($cmd == '[DETAIL]') { $content .= '<div class="container-fluid"><div class="row"><div class="col-md-4">' . JobNote() . EditJob() . '</div><div class="col-md-4">' . JobDetails() . '</div><div class="col-md-4">'; include 'inc/add_pictures.php'; $content .= '</div></div></div>'; } if ($cmd == '[JOB_CARD]') { $content .= '<div class="container">'; $field = array('photo2'); $sql = "SELECT * from {$tbn} where id ='{$id}'"; $content .= DisplayRecord('job_images', $sql, $field); $field = array('name', 'weight', 'repair_type', 'additional_instructions', 'estimate', 'finger_size', 'wax_cad_est_req', 'loose_stones', 'stone_information', 'items_to_return', 'due_back_date', 'max_price'); $sql = "SELECT * from {$tbn} where id ='{$id}'"; $content .= DisplayRecord('job_card', $sql, $field); $content .= '<button onclick="printFunction()" id="print_button" class="btn btn-default pull-right">Print</button></div>'; } if ($cmd == '[PARCEL]') { $content .= '<div class="container-fluid"><div class="row"><div class="col-md-4">'; $parcel_tb = SelectTable(); $parcel_tb_rel = SelectRelTable(); //Calculate total number of parcels to work out how many pages needed for pagination $sql = "SELECT * FROM {$parcel_tb}"; $result = mysqli_query($con, $sql) or die(mysqli_error() . "Error in " . $sql); $row_count = mysqli_num_rows($result); $total_pages = ceil($row_count / 25); $field = array('name', 'tracking', 'date_sent', 'date_received'); $sql = "SELECT * FROM {$parcel_tb} ORDER BY date_entered DESC LIMIT {$start_from}, 25"; $table_name = 'parcel'; $content .= DisplayTable($sql, $field, $table_name, $row_count);
echo "</td>\n"; echo '<td>'; DisplayRecord('MoyMiss', true, ' des tirs ratés par'); echo "</td></tr></table>\n"; echo '<br />'; echo '<table border=1 align=center cellpadding=2 cellspacing=0>'; echo '<tr><th colspan=2 align=center>Divers</th></tr>'; echo '<tr align=center>'; echo "<th>Total des actions</th>"; echo "<th>Vaisseaux au même nom</th>"; echo '</tr><tr valign=top>'; echo '<td>'; DisplayRecord('TotActions'); echo "</td>\n"; echo '<td>'; DisplayRecord('Duplicate', false, 'x sous le nom'); echo "</td></tr></table>\n"; echo '<br />'; } else { // ---------------------------------------------------------------------------------------- // // MENU: TOP // // ---------------------------------------------------------------------------------------- ?> <p><font color="#dddddd"><b>Analyseur de logs de combat pour Empire Universe 2</b></font></p><br /> <h2>Saisie du log de combat</h2> <p><form method="post"> Copiez et collez le log du combat que vous venez de mener.<br />
$sql = "SELECT * from mmb_bespoke_job 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>'; } //Full mmb_bespoke_job record information with notes and pictures if ($cmd == '[DETAIL]') { $content .= '<div class="container-fluid"><div class="row"><div class="col-md-4">' . JobNote() . EditJob() . '</div><div class="col-md-4">' . JobDetails() . '</div><div class="col-md-4">'; include 'inc/add_pictures.php'; $content .= '</div></div></div>'; } //Job details for print out if ($cmd == '[JOB_CARD]') { $content .= '<div class="container">'; $field = array('photo2', 'name', 'weight', 'repair_type', 'additional_instructions', 'estimate', 'finger_size', 'wax_cad_est_req', 'loose_stones', 'stone_information', 'items_to_return', 'due_back_date', 'max_price'); $sql = "SELECT * from mmb_bespoke_job where id ='{$id}'"; $content .= DisplayRecord('job_card', $sql, $field) . '<button onclick="printFunction()" id="print_button" class="btn btn-default pull-right">Print</button></div>'; } //Full list of records from mmb_parcel and mmb_parcel_thailand if ($cmd == '[PARCEL]') { $content .= '<div class="container-fluid"><div class="row"><div class="col-md-4">'; $parcel_tb = SelectTable(); $parcel_tb_rel = SelectRelTable(); //Calculate total number of parcels to work out how many pages needed for pagination $sql = "SELECT * FROM {$parcel_tb}"; $result = mysqli_query($con, $sql) or die(mysqli_error() . "Error in " . $sql); $row_count = mysqli_num_rows($result); $total_pages = ceil($row_count / 25); $field = array('name', 'tracking', 'date_sent', 'date_received'); $sql = "SELECT * FROM {$parcel_tb} ORDER BY date_entered DESC LIMIT {$start_from}, 25"; $table_name = 'parcel'; $content .= DisplayTable($sql, $field, $table_name, $row_count);
function JobDetails() { $currentuser = unserialize($_SESSION['login']); $field = array('photo2', 'name', 'job_location', 'repair_type', 'additional_instructions', 'estimate', 'finger_size', 'wax_cad_est_req', 'job_status', 'date_received_thailand', 'date_sent_from_thailand', 'due_back_date', 'max_price', 'active', 'urgent'); //Add more fields for UK staff if ($currentuser['company'] == 'MMUK') { array_splice($field, -3, 0, 'customer_due_date'); array_splice($field, -2, 0, 'price'); $field[] = 'uk_cust'; } //Add more fields for detail view if ($_REQUEST['cmd'] == '[DETAIL]') { array_splice($field, 3, 0, 'weight'); array_splice($field, 7, 0, 'date_sent_from_uk'); array_splice($field, 12, 0, 'date_received_back_uk'); array_splice($field, 14, 0, 'cost'); } $sql = "SELECT * from mmb_bespoke_job where id ='" . $_REQUEST['id'] . "'"; $_REQUEST['cmd'] != '[DETAIL]' ? $table_name = 'job' : ($table_name = 'job_detail'); return DisplayRecord($table_name, $sql, $field); }