芝麻web文件管理V1.00

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

<?php

global $wpdb;

$departureid = $_GET['d'];

$user = wp_get_current_user();

$userid = $user->ID;

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

{

$finalbox = $_POST['finalbox'];

$finalrecieptcomment = $_POST['finalrecieptcomment'];

$recordid = $_POST['recordid'];

$finalrecieptfile = '';

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

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

{

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

$uploadedfile = $_FILES['finalrecieptfile'];

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

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

$uploadfileurl = $movefile['url'];

$finalrecieptfile = $uploadfileurl;

}

$nt = $wpdb->update(

'kn_cargo',

array(

'finalrecieptid' => $userid,

'finalbox' => $finalbox,

'finalrecieptdate' => $todate,

'finalrecieptcomment' => $finalrecieptcomment,

'finalrecieptfile' => $finalrecieptfile

array( 'id' => $recordid ),

array(

'%s',	// value1

'%s',

'%s'	// value2

array( '%d' )

);

}

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

if($wpdb->num_rows>0)

{

<div class="col-md-12"><a onclick="printdiv();"><button type="button" name="print" class="btn btn-primary">Print Delivery Box List</button></a>

| <a href="https://disqinc.co.uk/cargo/final-delivery/"><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>Deliver Box</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="finalboxform" id="finalboxform_<?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->finalrecieptid !=0){ if($val->finalbox==1){ echo "Yes";}else{ echo "No";}  }else{?>

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

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

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

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

</select>-->

<?php } ?>

</td>

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

<?php if($val->submitcomment!=''){?> <strong>Box Comment :</strong> <?php echo $val->submitcomment; ?> <?php }  ?>

<?php if($val->uploadcomment!=''){?> <strong>Upload Comment :</strong> <?php echo $val->uploadcomment; ?> <?php }  ?>

<?php if($val->downloadcomment!=''){?> <strong>Download Comment :</strong> <?php echo $val->downloadcomment; ?> <?php }  ?>

<?php if($val->dispatchcomment!=''){?> <strong>Dispatch Comment :</strong> <?php echo $val->dispatchcomment; ?> <?php }  ?>

</td>

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

<td><?php if($val->finalrecieptid!=0){ if($val->processclose==0){?> <a href="https://disqinc.co.uk/cargo/update-final-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/final-delivery/"><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>Delivery 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>Deliver Box</th>

<th>Comments</th>

<th>DeliveredBy</th>

<th>Delivery Date</th>

</tr>

</thead>

<tbody>

<?php

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

$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->finalbox==1){?> <span style="color:green;">Yes</span> <?php }else{?> <span style="color:red;">No</span><?php } ?></td>

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

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

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

</tr>

<?php

}

</tbody>

</table>

</div>

function addformaction(rid)

{

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

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

return true;

}

function printdiv()

{

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

var originalContents = document.body.innerHTML;

document.body.innerHTML = printContents;

window.print();

document.body.innerHTML = originalContents;

}

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/finalprocessclose.php/',

data: {

rid:rid,

success: function (responses) {

//alert(responses);

if(responses == "1")

{

alert("Process has been closed");

location.reload();

}

else

{

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

}

});

}

</script>