芝麻web文件管理V1.00

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

<?php

ob_start();

global $wpdb;

define('WP_MEMORY_LIMIT', '256M');

$user = wp_get_current_user();

$userid = $user->ID;

$dp_id = $_REQUEST['did'];

$recordid = $_REQUEST['id'];

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

$rinfo = $wpdb->get_row( "SELECT * FROM kn_cargo where id = '".$recordid."' ", ARRAY_A);

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

//print_r($dtype);

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

{

$submitfile = '';

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

{

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

$uploadedfile = $_FILES['submitfile'];

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

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

$uploadfileurl = $movefile['url'];

$submitfile = $uploadfileurl;

}

$success = $wpdb->update(

'kn_cargo',

array(

'sname' => $_POST['sname'],

'sphoneno' => $_POST['sphoneno'],

'saddress' => $_POST['saddress'],

'rname' => $_POST['rname'],

'rphoneno' => $_POST['rphoneno'],

'raddress' => $_POST['raddress'],

'boxdescription' => $_POST['boxdescription'],

'noofboxes' => $_POST['noofboxes'],

'grossweight' => $_POST['grossweight'],

'contentvalue' => $_POST['contentvalue'],

'insurance' => $_POST['insurance'],

'postcode' => $_POST['postcode'],

'finaldestination' => $_POST['finaldestination'],

'packingcharges' => $_POST['packingcharges'],

'handlingcharges' => $_POST['handlingcharges'],

'totalcharges' => $_POST['totalcharges'],

'deliverytype' => $_POST['deliverytype'],

'departuredate' => $_POST['departuredate'],

'deliverydate' => $_POST['deliverydate'],

'submitcomment' => $_POST['submitcomment'],

'submitid' => $userid,

'submitdate' => date('Y-m-d H:i:s'),

'departureid' => $_POST['departureid'],

'submitfile' => $submitfile

array( 'id' => $recordid ),

array( '%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s','%s'),

array( '%d' )

);

$lastrecordid = $recordid;//$wpdb->insert_id;

if($success)

{

$label ='';

for($i=1;$i<=$_POST['noofboxes'];$i++)

{

$label.=$lastrecordid."-P".$i;

if($i<$_POST['noofboxes'])

{

$label.=",";

}

$wpdb->update(

'kn_cargo',

array(

'boxlabel' => $label	// string

array( 'id' => $lastrecordid ),

array(

'%s'	// value1

array( '%d' )

);

<div class="alert alert-success">Box has been updated successfully.<br> <h4>Ticket No is : <?php echo $lastrecordid;  ?></h4></div>

<?php

header("location:https://disqinc.co.uk/cargo/view-box/?q=$lastrecordid");

}

else

{

<div class="alert alert-info">Box has not been added. Please try again later.</div>

<?php

}

ob_end_flush();

<div class="col-md-3 col-sm-12"><label>Sender Name:</label> <span style="color:red">*</span></div>

<input type="text" class="form-control" name="sname" id="sname" placeholder="" value="<?php echo $rinfo['sname'];?>" required>

</div>

<div class="col-md-3 col-sm-12"><label>Sender Phoneno:</label> <span style="color:red">*</span></div>

<input type="text" class="form-control" name="sphoneno" id="sphoneno" placeholder="" value="<?php echo $rinfo['sphoneno'];?>" required>

</div>

<div class="col-md-3 col-sm-12"><label>Sender Address:</label> <span style="color:red">*</span></div>

<input type="text" class="form-control" name="saddress" id="saddress" placeholder="" value="<?php echo $rinfo['saddress'];?>" required>

</div>

<div class="col-md-3 col-sm-12"><label>Reciever Name:</label> <span style="color:red">*</span></div>

<input type="text" class="form-control" id="rname" name="rname" placeholder="" value="<?php echo $rinfo['rname'];?>" required>

</div>

<div class="col-md-3 col-sm-12"><label>Reciever Phoneno: </label><span style="color:red">*</span></div>

<input type="text" class="form-control" id="rphoneno" name="rphoneno" placeholder="" value="<?php echo $rinfo['rphoneno'];?>" required>

</div>

<div class="col-md-3 col-sm-12"><label>Reciever Address: </label><span style="color:red">*</span></div>

<input type="text" class="form-control" id="raddress" name="raddress" placeholder="" value="<?php echo $rinfo['raddress'];?>" required>

</div>

<div class="col-md-3 col-sm-12"><label>Final Destination: </label><span style="color:red">*</span></div>

<input type="text" class="form-control" id="finaldestination" name="finaldestination" placeholder="" value="<?php echo $rinfo['finaldestination'];?>" required>

</div>

<!--<div class="form-group">

</div>

</div>-->

<div class="col-md-3 col-sm-12"><label>Box Description:</label> <span style="color:red">*</span></div>

</div>

<div class="col-md-3 col-sm-12"><label>Number of Pieces:</label> <span style="color:red">*</span></div>

<input type="text" name="noofboxes" class="form-control" id="noofboxes" value="<?php echo $rinfo['noofboxes'];?>" required />

</div>

<div class="col-md-3 col-sm-12"><label>Gross Weight in KGs:</label> <span style="color:red">*</span></div>

<input type="text" name="grossweight" class="form-control" id="grossweight" value="<?php echo $rinfo['grossweight'];?>" required />

</div>

<div class="col-md-3 col-sm-12"><label>Content Value:</label> <span style="color:red">*</span></div>

<input type="text" name="contentvalue" class="form-control" id="contentvalue" onkeyup="calval(this.value)" value="<?php echo $rinfo['contentvalue'];?>" required />

</div>

<div class="col-md-3 col-sm-12"><label>Insurance:</label> <span style="color:red">*</span></div>

<input type="radio" name="insurance"  id="insurance_basic" <?php if($rinfo['insurance']==50){?>checked="checked" <?php }?> value="50" /> Basic cover

<input type="radio" name="insurance"  id="insurance_extra" <?php if($rinfo['insurance']!=50){?>checked="checked" <?php }?> value="" /> Extra Cover

</div>

<input type="text" name="postcode" class="form-control" id="postcode" value="<?php echo $rinfo['postcode'];?>" required />

</div>

<div class="col-md-3 col-sm-12"><label>Packing Charges(£):</label> <span style="color:red"></span></div>

</div>

<div class="col-md-3 col-sm-12"><label>Handling Charges(£):</label> <span style="color:red"></span></div>

</div>

<div class="col-md-3 col-sm-12"><label>Total Charges(£):</label> <span style="color:red"></span></div>

</div>

<!--<div class="form-group">

<div class="col-md-3 col-sm-12"><label>Box Label:</label><br /><smal>if more than one box , label separte with ,</small> <span style="color:red">*</span></div>

</div>

</div>-->

<div class="col-md-3 col-sm-12"><label>Delievery Type:</label> <span style="color:red">*</span></div>

<input type="text" class="form-control" id="deliverytype" name="deliverytype" value="<?php echo $dtype['dtype'];?>" readonly="" required>

</div>

<div class="col-md-3 col-sm-12"><label>Departure Date:</label> <span style="color:red">*</span></div>

<input type="text" class="form-control" id="departuredate" name="departuredate" value="<?php echo $rinfo['departuredate'];?>" readonly="" required>

</div>

<div class="col-md-3 col-sm-12"><label>Delievery Date:</label> <span style="color:red">*</span></div>

<input type="text" class="form-control" id="deliverydate" name="deliverydate" value="<?php echo $rinfo['deliverydate'];?>" readonly="" required>

</div>

<div class="col-md-3 col-sm-12"><label>Comment(optional):</label></div>

</div>

<div class="col-md-3 col-sm-12"><label>Upload File(optional):</label></div>

</div>

</div>

</form>

function calval(v)

{

if(!isNaN(v))

{

var t = parseFloat(v)*0.22;

document.getElementById('insurance_extra').value=t;

}

else

{

document.getElementById('contentvalue').value='';

alert("Please enter a numeric value");

}

</script>

<!--<script type="text/javascript">

var date = new Date();

date.setDate(date.getDate());

$('#deliverydate').datetimepicker({

format : 'YYYY-MM-DD HH:mm'

});

$('#departuredate').datetimepicker({

format : 'YYYY-MM-DD HH:mm'

});

</script>-->