芝麻web文件管理V1.00

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

<?php

global $wpdb;

$departureid = $_GET['d'];

$user = wp_get_current_user();

$userid = $user->ID;

if(isset($_POST['save']))

{

$dispatchbox = $_POST['dispatchbox'];

$dispatchcomment = $_POST['dispatchcomment'];

$recordid = $_POST['recordid'];

$dispatchfile = '';

$todate = date("Y-m-d H:i:s");

if($_FILES['dispatchfile']['name']!='')

{

if ( ! function_exists( 'wp_handle_upload' ) ) require_once( ABSPATH . 'wp-admin/includes/file.php' );

$uploadedfile = $_FILES['dispatchfile'];

$upload_overrides = array( 'test_form' => false );

$movefile = wp_handle_upload( $uploadedfile, $upload_overrides );

$uploadfileurl = $movefile['url'];

$dispatchfile = $uploadfileurl;

}

$nt = $wpdb->update(

'kn_cargo',

array(

'dispatchid' => $userid,

'dispatchbox' => $dispatchbox,

'dispatchdate' => $todate,

'dispatchcomment' => $dispatchcomment,

'dispatchfile' => $dispatchfile

array( 'id' => $recordid ),

array(

'%s',	// value1

'%s',

'%s'	// value2

array( '%d' )

);

}

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

if($wpdb->num_rows>0)

{

<div class="col-md-12"><a onclick="printdiv();"><button type="button" name="print" class="btn btn-primary">Print Dispatch Box List</button></a> | <a href="https://disqinc.co.uk/cargo/dispatch-box/"><button type="button" name="print" class="btn btn-primary">Dates List</button></a> | <a href="https://disqinc.co.uk/cargo/choose-option/" class="btn btn-primary">Main Menu</a> | <a onclick="closeprocess(<?php echo $departureid; ?>);" class="btn btn-danger">Close Process</a></div>

</div>

<tr>

<th>Ticket No:</th>

<th>Box Label</th>

<th>Reciever Info</th>

<th>DispatchBox</th>

<th>Comment(if any)</th>

<th>Upload Image</th>

<th>Action</th>

</tr>

</thead>

<tbody>

<?php

$counter = 0 ;

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

{

$counter++;

<form method="post" action="" name="dispatchboxform" id="dispatchboxform_<?php echo $val->id;?>" enctype="multipart/form-data" onsubmit="return addformaction(<?php echo $val->id;?>);">

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

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

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

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

<td><?php echo $val->rname;?> <br /> <?php echo $val->rphoneno;?> <br /> <?php echo $val->raddress;?> <br /> <?php echo $val->finaldestination;?></td>

<td>

<?php if($val->dispatchid !=0){ if($val->dispatchbox==1){ echo "Yes";}else{ echo "No";}  }else{?>

<input type="radio" name="dispatchbox" value="1"  required /> Yes

<input type="radio" name="dispatchbox" value="0"  required /> No

<!--<select name="dispatchbox" id="dispatchbox" class="form-control" onchange="updatestatus(this.id);">

<option value="">Select Option</option>

</select>-->

<?php } ?>

</td>

<td><?php if($val->dispatchid!=0){ echo $val->dispatchcomment;}else{?><textarea name="dispatchcomment" class="form-control"></textarea><?php }?></td>

<td><?php if($val->dispatchid!=0){ if($val->dispatchfile!=''){?> <a target="_blank" href="<?php echo $val->dispatchfile;?>">View Image</a> <?php }}else{?><input type="file" name="dispatchfile" /><?php }?></td>

<td><?php if($val->dispatchid!=0){ if($val->dispatchprocessclose==0){?> <a href="https://disqinc.co.uk/cargo/update-dispatch-record/?rid=<?php echo $val->id; ?>"><img src="https://disqinc.co.uk/cargo/wp-content/uploads/2019/01/editrecord.png" width="32" /></a> <?php } }else{?><button type="submit" name="save" class="btn btn-primary">Save</button><?php }?></td>

</tr>

</form>

<?php

}

</tbody>

</table>

<?php }else{?>

<div class="col-md-12"> <a href="https://disqinc.co.uk/cargo/dispatch-box/"><button type="button" name="print" class="btn btn-primary">Dates List</button></a> | <a href="https://disqinc.co.uk/cargo/choose-option/" class="btn btn-primary">Main Menu</a></div>

</div>

<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>Dispatch Reciept of Departure Date : <?php echo date("dS F, Y ",strtotime($ddates['departuredate'])); ?></h1>

<tr>

<th>Ticket No:</th>

<th>Box Description : </th>

<th>No of Boxes</th>

<th>Box Label</th>

<th>Gross Weight in KGs</th>

<th>Reciever Info</th>

<th>DispatchBox</th>

<th>Comments</th>

<th>DispatchedBy</th>

<th>Dispatch Date</th>

</tr>

</thead>

<tbody>

<?php

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

$counter2 =0 ;

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

{

$counter2++;

<tr>

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

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

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

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

<td><?php echo $val->rname;?> <br /> <?php echo $val->rphoneno;?> <br /> <?php echo $val->raddress;?> <br /> <?php echo $val->finaldestination;?></td>

<td><?php if($val->dispatchbox==1){?> <span style="color:green;">Yes</span> <?php }else{?> <span style="color:red;">No</span><?php } ?></td>

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

<td><?php if($val->dispatchid!=0){ $user_info = get_userdata($val->dispatchid); echo $user_info->user_login; }?></td>

<td><?php if($val->dispatchid!=0){ echo date("dS F, Y ",strtotime($val->dispatchdate));}?></td>

</tr>

<?php

}

</tbody>

</table>

</div>

function addformaction(rid)

{

//var actval = document.getElementById('recordid').value;

jQuery("#dispatchboxform_"+rid).attr('action', '#'+rid);

return true;

}

function closeprocess(rid)

{

//alert(rid);

if (confirm("Do You want to close process. Please check have you perform action on all boxes"))

{

jQuery.ajax({

type: 'post',

url: 'https://disqinc.co.uk/cargo/dispatchprocessclose.php/',

data: {

rid:rid,

success: function (responses) {

//alert(responses);

if(responses == "1")

{

alert("Process has been closed");

location.reload();

}

else

{

alert ("Process not close! please try again later");

}

});

}

function printdiv()

{

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

var originalContents = document.body.innerHTML;

document.body.innerHTML = printContents;

window.print();

document.body.innerHTML = originalContents;

}

function updatestatus(rid)

{/*

alert(rid);

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

jQuery.ajax({

type: 'post',

url: 'https://disqinc.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>