Exemplo n.º 1
0
    $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);
Exemplo n.º 2
0
    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 />
Exemplo n.º 3
0
    $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);
Exemplo n.º 4
0
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);
}