芝麻web文件管理V1.00

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

<?php

global $wpdb;

$departureid = $_GET['d'];

$user = wp_get_current_user();

$userid = $user->ID;

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

{

$uploadbox = $_POST['uploadbox'];

$uploadcomment = $_POST['uploadcomment'];

$recordid = $_POST['recordid'];

$uploadfile = '';

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

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

{

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

$uploadedfile = $_FILES['uploadfile'];

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

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

$uploadfileurl = $movefile['url'];

$uploadfile = $uploadfileurl;

}

$nt = $wpdb->update(

'kn_cargo',

array(

'uploadid' => $userid,

'uploadbox' => $uploadbox,

'uploaddate' => $todate,

'uploadcomment' => $uploadcomment,

'uploadfile' => $uploadfile

array( 'id' => $recordid ),

array(

'%s',	// value1

'%s',

'%s'	// value2

array( '%d' )

);

}

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

if($wpdb->num_rows>0)

{

<div class="col-md-12"><a onclick="printdiv();"><button type="button" name="print" class="btn btn-primary">Print Upload List</button></a> | <a href="https://disqinc.co.uk/cargo/upload-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>Upload 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="uploadboxform" id="uploadboxform_<?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->uploadid !=0){ if($val->uploadbox==1){ echo "Yes";}else{ echo "No";}  }else{?>

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

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

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

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

</select>-->

<?php } ?>

</td>

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

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

</td>

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

<td><?php if($val->uploadid!=0){ if($val->uploadprocessclose==0){ ?> <a href="https://disqinc.co.uk/cargo/update-upload-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/upload-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>Upload Reciept of Departure Date : <?php echo date("dS F, Y ",strtotime($ddates['departuredate'])); ?></h1>

<tr>

<th>Box Description : </th>

<th>No of Boxes</th>

<th>Box Label</th>

<th>Gross Weight in KGs</th>

<th>Reciever Info</th>

<th>Upload Box</th>

<th>Comments</th>

<th>UploadBy</th>

<th>Upload Date</th>

</tr>

</thead>

<tbody>

<?php

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

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

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

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

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

</tr>

<?php

}

</tbody>

</table>

</div>

function addformaction(rid)

{

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

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

return true;

}

function closeprocess(rid)

{

//alert(rid);

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

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/uploadprocessclose.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");

}

});

}

else

{

//alert("NO Action");

}

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>