芝麻web文件管理V1.00

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

<?php

global $wpdb;

$today = date("Y-m-d");

$user = wp_get_current_user();

$userid = $user->ID;

if(($userid ==1)||($userid ==16))

{

$ddates = $wpdb->get_results( "SELECT * FROM kn_departuredates  where dtype = 1 order by departuredate ASC");

<a href="https://disqinc.co.uk/cargo/add-departure-dates/" class="btn btn-primary">Add Departure Date</a>  | <a href="https://disqinc.co.uk/cargo/choose-option/" class="btn btn-primary">Main Menu</a> | | <a href="https://disqinc.co.uk/cargo/search-box/" class="btn btn-primary">Search Box</a>

<?php

}

else

{

//and createdby = '".mysqli_real_escape_string($userid)."'

$ddates = $wpdb->get_results( "SELECT * FROM kn_departuredates  where dtype = 1  order by departuredate ASC");

<?php

}

if($_REQUEST['q']==1)

{

<div class="alert alert-success">Record has been added successfully...</div>

<?php

}

<h1>Air Departure List</h1>

<tr>

<th>Departure Date</th>

<th>Delivery Date </th>

<th>Delivery Type</th>

<th>Total Boxes</th>

<th>ProcessClose</th>

<th>Action</th>

</tr>

</thead>

<tbody>

<?php

$counter = 0 ;

foreach($ddates as $key => $val)
{

$counter++;

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

$totalboxes =  $wpdb->get_row( "SELECT count(*) as total FROM  kn_cargo WHERE departureid = '".$val->id."' ", ARRAY_A );

//Date differnce calculations

$now = time();

$dpdate = strtotime($val->departuredate);

$datediff = $now - $dpdate;

$expdatedays =  round($datediff / (60 * 60 * 24));

if(($expdatedays>=31) && ($val->processclose==1))

{

}

else

{

<tr>

<td><a href="https://disqinc.co.uk/cargo/box-list/?d=<?php echo $val->id;?>"><?php echo date("dS F, Y ",strtotime($val->departuredate)); ?></a>

<?php //echo $expdatedays;?>

</td>

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

<td><?php if($val->processclose==1){ ?> <span style="color:red;"><strong>Closed</strong></span> <?php }else{ ?> <span style="color:green;"><strong>Open</strong></span> <?php }?></td>

<td><?php if($val->processclose==0){?> <a href="https://disqinc.co.uk/cargo/add-box/?did=<?php echo $val->id;?>">Add Customer</a><?php }?></td>

</tr>

<?php

}

</tbody>

</table>

<?php $ddatesair = $wpdb->get_results( "SELECT * FROM kn_departuredates  where dtype = 2 order by departuredate ASC"); ?>

<h1>Sea Departure List</h1>

<tr>

<th>Departure Date</th>

<th>Delivery Date </th>

<th>Delivery Type</th>

<th>Total Boxes</th>

<th>ProcessClose</th>

<th>Action</th>

</tr>

</thead>

<tbody>

<?php

$counter = 0 ;

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

{

$counter++;

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

$totalboxes =  $wpdb->get_row( "SELECT count(*) as total FROM  kn_cargo WHERE departureid = '".$val->id."' ", ARRAY_A );

$now = time();

$dpdate = strtotime($val->departuredate);

$datediff = $now - $dpdate;

$expdatedays =  round($datediff / (60 * 60 * 24));

if(($expdatedays>=31) && ($val->processclose==1))

{

}

else

{

<tr>

<td><a href="https://disqinc.co.uk/cargo/box-list/?d=<?php echo $val->id;?>"><?php echo date("dS F, Y ",strtotime($val->departuredate)); ?></a></td>

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

<td><?php if($val->processclose==1){ ?> <span style="color:red;"><strong>Closed</strong></span> <?php }else{ ?> <span style="color:green;"><strong>Open</strong></span> <?php }?></td>

<td><?php if($val->processclose==0){?> <a href="https://disqinc.co.uk/cargo/add-box/?did=<?php echo $val->id;?>">Add Customer</a><?php }?></td>

</tr>

<?php

}

</tbody>

</table>