$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);
}
