芝麻web文件管理V1.00

编辑当前文件:/home/disqkgca/public_html/cargo/boxlist.php

<?php

global $wpdb;

$departureid = $_GET['d'];

$user = wp_get_current_user();

$userid = $user->ID;

$myrows = $wpdb->get_results( "SELECT * FROM kn_cargo where departureid = '".$departureid."'  " );

if($wpdb->num_rows>0)

{

<div class="col-md-12"> <a href="http://bluenee.co.uk/cargo/departure-dates-list/"><button type="button" name="print" class="btn btn-primary">Departure Dates List</button></a> | <a href="http://bluenee.co.uk/cargo/choose-option/" class="btn btn-primary">Main Menu</a></div>

</div>

<tr>

<th>Box Description</th>

<th>No of Pieces</th>

<th>Gross Weight in KGs</th>

<th>Departure Date</th>

<th>Delivery Date</th>

<th>Delivery Type</th>

<th>Action</th>

</tr>

</thead>

<tbody>

<?php

$counter = 0 ; $noofpieces = 0 ; $totalweight = 0;

foreach($myrows as $key=>$val)

{

$counter++;

$dtype = $wpdb->get_row( "SELECT * FROM kn_delieverytype WHERE id = '".$val->deliverytype."' ", ARRAY_A );

$noofpieces += floatval($val->noofboxes);

$totalweight += floatval($val->grossweight);

<tr>

<td><?php echo $val->boxdescription;?></td>

<td><?php echo $val->noofboxes; ?></td>

<td><?php echo $val->grossweight; ?></td>

<td><?php echo date("dS F, Y ",strtotime($val->departuredate));?></td>

<td><?php echo date("dS F, Y ",strtotime($val->deliverydate));?></td>

<td><?php echo date("dS F, Y ",strtotime($val->submitdate));?></td>

<td><a href="http://bluenee.co.uk/cargo/edit-box/?id=<?php echo $val->id; ?>&did=<?php echo $val->departureid;?>">Edit </a> | <a href="http://bluenee.co.uk/cargo/print-reciept/?id=<?php echo $val->id; ?>">Print Reciept</a>

<?php if($userid ==1){?> <a onclick="delrecord(<?php echo $val->id ?>);" class="btn btn-danger">Delete</a> <?php } ?>

</td>

</tr>

<?php

}

<tr>

<td><strong>Total Pieces :</strong> <?php echo $noofpieces;?></td>

<td><strong>Total Weight :</strong> <?php echo $totalweight;?> KG</td>

</tr>

</tbody>

</table>

<?php }else{?>

<div class="alert alert-info">No Record exist....</div>

<?php

}

<?php

$ddates = $wpdb->get_row( "SELECT * FROM kn_departuredates where id = '".$departureid."' ", ARRAY_A);

<h1>Add Box Reciept of Departure Date : <?php echo date("dS F, Y ",strtotime($ddates['departuredate'])); ?></h1>

<tr>

<th>Box Description</th>

<th>No of Pieces</th>

<th>Gross Weight in KGs</th>

<th>Departure Date</th>

<th>Delivery Date</th>

<th>Delivery Type</th>

<th>Action</th>

</tr>

</thead>

<tbody>

<?php

$printrows = $wpdb->get_results( "SELECT * FROM kn_cargo where departureid = '".$departureid."'  " );

$counter2 =0 ;  $noofpieces = 0 ; $totalweight = 0;

foreach($printrows as $key=>$val)

{

$counter2++;

$dtype = $wpdb->get_row( "SELECT * FROM kn_delieverytype WHERE id = '".$val->deliverytype."' ", ARRAY_A );

$noofpieces += floatval($val->noofboxes);

$totalweight += floatval($val->grossweight);

<tr>

<td><?php echo $val->boxdescription;?></td>

<td><?php echo $val->noofboxes; ?></td>

<td><?php echo $val->grossweight; ?></td>

<td><?php echo date("dS F, Y ",strtotime($val->departuredate));?></td>

<td><?php echo date("dS F, Y ",strtotime($val->deliverydate));?></td>

<td><?php echo date("dS F, Y ",strtotime($val->submitdate));?></td>

<?php if($userid ==1){?> <a onclick="delrecord(<?php echo $val->id ?>);" class="btn btn-danger">Delete</a> <?php } ?>

</td>

</tr>

<?php

}

<tr>

<td><strong>Total Pieces :</strong> <?php echo $noofpieces;?></td>

<td><strong>Total Weight :</strong> <?php echo $totalweight;?> KG</td>

</tr>

</tbody>

</table>

</div>

function printdiv()

{

var printContents = document.getElementById("printarea").innerHTML;

var originalContents = document.body.innerHTML;

document.body.innerHTML = printContents;

window.print();

document.body.innerHTML = originalContents;

}

function delrecord(rid)

{

//alert(rid);

//var c = confirm("Do You want to close process. Please check have you perform action on all boxes");

if (confirm("Are you sure you want to delete the record.?")) {

jQuery.ajax({

type: 'post',

url: 'http://bluenee.co.uk/cargo/delrecord.php/',

data: {

rid:rid,

success: function (responses) {

//alert(responses);

if(responses == "1")

{

alert("Record has been deleted");

location.reload();

}

else

{

alert ("Record not delete! please try again later");

}

});

}

else

{

}

function updatestatus(rid)

{/*

alert(rid);

var s_value = jQuery('#'+rid).val();

jQuery.ajax({

type: 'post',

url: 'http://bluenee.co.uk/cargo/updateuploadstatus.php/',

data: {

rid:rid,

st:s_value

success: function (responses) {

alert(responses);

if(responses == "1")

{

location.reload();

}

else

{

alert ("Record not update! please try again later");

}

});

}

</script>