Index of /home/htscrtms/newcrm.htshah.com/hslider
<?php
include('lib/db_connect.php');
include('lib/auth.php');
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, shrink-to-fit=no">
<title>HT Shah</title>
<link rel="icon" type="image/x-icon" href="assets/img/favicon.ico"/>
<link href="assets/css/loader.css" rel="stylesheet" type="text/css" />
<script src="assets/js/loader.js"></script>
<!-- BEGIN GLOBAL MANDATORY STYLES -->
<link href="https://fonts.googleapis.com/css?family=Nunito:400,600,700" rel="stylesheet">
<link href="bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
<link href="assets/css/plugins.css" rel="stylesheet" type="text/css" />
<!-- END GLOBAL MANDATORY STYLES -->
<!-- BEGIN PAGE LEVEL STYLES -->
<link rel="stylesheet" type="text/css" href="plugins/table/datatable/datatables.css">
<link rel="stylesheet" type="text/css" href="plugins/table/datatable/dt-global_style.css">
<!-- END PAGE LEVEL STYLES -->
</head>
<body>
<?php include("header.php"); ?>
<!-- BEGIN NAVBAR -->
<div class="sub-header-container">
<header class="header navbar navbar-expand-sm">
<a href="javascript:void(0);" class="sidebarCollapse" data-placement="bottom"><svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-menu"><line x1="3" y1="12" x2="21" y2="12"></line><line x1="3" y1="6" x2="21" y2="6"></line><line x1="3" y1="18" x2="21" y2="18"></line></svg></a>
<ul class="navbar-nav flex-row">
<li>
<div class="page-header">
<nav class="breadcrumb-one" aria-label="breadcrumb">
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="javascript:void(0);">Admin</a></li>
<li class="breadcrumb-item active" aria-current="page"><span>View Booking Imports</span></li>
</ol>
</nav>
</div>
</li>
</ul>
</header>
</div>
<!-- END NAVBAR -->
<!-- BEGIN MAIN CONTAINER -->
<div class="main-container" id="container">
<?php include("sidebar-wrapper.php"); ?>
<!-- BEGIN CONTENT AREA -->
<div id="content" class="main-content">
<div class="layout-px-spacing">
<div class="row layout-top-spacing">
<div class="col-xl-12 col-lg-12 col-sm-12 layout-spacing">
<div class="statbox widget box box-shadow">
<div class="widget-header">
<div class="row">
<div class="col-xl-12 col-md-12 col-sm-12 col-12">
<h4>View Booking Imports<?php if(isset($_SESSION['seln']) && $_SESSION['seln']!="Client"){ ?> <a href="add_importbooking.php" class="btn btn-info" style="float:right;">Add New Import Booking Entry</a><?php } ?></h4>
</div>
</div>
</div>
<div class="widget-content widget-content-area br-6">
<table id="zero-config" class="table dt-table-hover" style="width:100%">
<thead>
<tr>
<th>Sr.</th>
<th>HTSHAH Job</th>
<th>Client</th>
<th>Bill of entry no</th>
<th>Product</th>
<th>FCL / LCL</th>
<th>Inv. No. & Supplier</th>
<th>Eta</th>
<th>GR</th>
<th>Cont Arrived / Scan</th>
<th>Duty</th>
<th>CC / OCC</th>
<th>Org. docs</th>
<th>Delivery</th>
<th>Client Remarks</th>
<th>Cont. bond</th>
<th>Empty letter</th>
<th>Remarks</th>
<?php if(isset($_SESSION['seln']) && $_SESSION['seln']!="Client"){ ?>
<th>Move To Arrival</th>
<?php } ?>
<th class="no-content">Mail / Excel</th>
</tr>
</thead>
<tbody>
<?php $count=0;
if(isset($_SESSION['seln']) && $_SESSION['seln']=="Client"){
$selcl="select * from `tabl_client` where userName='".$_SESSION["name"]."'";
$qrycl=mysqli_query($con,$selcl) or die(mysqli_error($con));
$rowcl=mysqli_fetch_array($qrycl);
$sel="select * from `tabl_importbooking` where DELFLAG='N' && STATUS='0' && client_id='".$rowcl['id']."' order by id desc";
}else{
$sel="select * from `tabl_importbooking` where DELFLAG='N' && STATUS='0' order by id desc";
}
$qry=mysqli_query($con,$sel) or die(mysqli_error($con));
while($row=mysqli_fetch_array($qry))
{ $count++;
$selc="select * from `tabl_client` where id='".$row['client_id']."'";
$qryc=mysqli_query($con,$selc) or die(mysqli_error($con));
$rowc=mysqli_fetch_array($qryc);
?>
<tr>
<td><?php echo $count;?></td>
<td id="hoverbox"><a href="edit_importbooking.php?htshahNo=<?php echo $row['htshah_no'] ?>"><?php echo $row['htshah_no']?></a>
<div id="box" style="display: none">
<h4>Job Details</h4>
<p>Edi No: <?php echo $row['edi_no']?></p>
</div>
</td>
<td><?php echo $rowc['userName']?></td>
<td><?php echo $row['thoka_no']?></td>
<td<?php if($row['product_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['product']?></td>
<td<?php if($row['fcl_Lcl_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['fcl_Lcl']?></td>
<td<?php if($row['invoice_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['invoice']?></td>
<td<?php if($row['eta_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['eta']?></td>
<td<?php if($row['igm_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['igm']?></td>
<td<?php if($row['av_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['av']?></td>
<td<?php if($row['duty_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['duty']?></td>
<td<?php if($row['free_Detention_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['free_Detention']?></td>
<td<?php if($row['org_Doc_Dt_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['org_Doc_Dt']?></td>
<td<?php if($row['del_Pro_Dt_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['del_Pro_Dt']?></td>
<td<?php if($row['client_Remark_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['client_Remark']?></td>
<td<?php if($row['cont_Bond_Dt_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['cont_Bond_Dt']?></td>
<td<?php if($row['emptyLetter_Val_Dt_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['emptyLetter_Val_Dt']?></td>
<td<?php if($row['remark_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['remark']?></td>
<?php if(isset($_SESSION['seln']) && $_SESSION['seln']!="Client"){ ?>
<td><a onClick="changestatus_booking(<?php echo $row['id']?>)" title="Move To Arrival">Move To Arrival</a></td>
<?php } ?>
<td><a href="bookingreport-excel.php?client_id=<?php echo $row['client_id'];?>"><button type="button" class="btn btn-danger p-1">Mail / Excel</button></a></td>
</tr>
<?php
}
?>
</tbody>
<tfoot>
<tr>
<th>Sr.</th>
<th>HTSHAH Job</th>
<th>Client</th>
<th>Bill of entry no</th>
<th>Product</th>
<th>FCL / LCL</th>
<th>Inv. No. & Supplier</th>
<th>Eta</th>
<th>GR</th>
<th>Cont Arrived / Scan</th>
<th>Duty</th>
<th>CC / OCC</th>
<th>Org. docs</th>
<th>Delivery</th>
<th>Client Remarks</th>
<th>Cont. bond</th>
<th>Empty letter</th>
<th>Remarks</th>
<?php if(isset($_SESSION['seln']) && $_SESSION['seln']!="Client"){ ?>
<th>Move To Arrival</th>
<?php } ?>
<th class="no-content">Mail / Excel</th>
</tr>
</tfoot>
</table>
<a href="export-bookingreport-excel.php?seln=<?php echo $_SESSION['seln']; ?>"><button type="button" class="btn btn-info m-3">Export Data To Excel ↓</button></a>
</div>
</div>
</div>
</div>
</div>
<?php include("footer.php"); ?>
</div>
<!-- END CONTENT AREA -->
</div>
<!-- END MAIN CONTAINER -->
<!-- BEGIN GLOBAL MANDATORY SCRIPTS -->
<script src="assets/js/libs/jquery-3.1.1.min.js"></script>
<script src="bootstrap/js/popper.min.js"></script>
<script src="bootstrap/js/bootstrap.min.js"></script>
<script src="plugins/perfect-scrollbar/perfect-scrollbar.min.js"></script>
<script src="assets/js/app.js"></script>
<script>
$(document).ready(function() {
App.init();
});
</script>
<script src="assets/js/custom.js"></script>
<!-- END GLOBAL MANDATORY SCRIPTS -->
<!-- BEGIN PAGE LEVEL SCRIPTS -->
<script src="plugins/table/datatable/datatables.js"></script>
<script>
$('#zero-config').DataTable({
"dom": "<'dt--top-section'<'row'<'col-12 col-sm-6 d-flex justify-content-sm-start justify-content-center'l><'col-12 col-sm-6 d-flex justify-content-sm-end justify-content-center mt-sm-0 mt-3'f>>>" +
"<'table-responsive'tr>" +
"<'dt--bottom-section d-sm-flex justify-content-sm-between text-center'<'dt--pages-count mb-sm-0 mb-3'i><'dt--pagination'p>>",
"oLanguage": {
"oPaginate": { "sPrevious": '<svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-arrow-left"><line x1="19" y1="12" x2="5" y2="12"></line><polyline points="12 19 5 12 12 5"></polyline></svg>', "sNext": '<svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-arrow-right"><line x1="5" y1="12" x2="19" y2="12"></line><polyline points="12 5 19 12 12 19"></polyline></svg>' },
"sInfo": "Showing page _PAGE_ of _PAGES_",
"sSearch": '<svg xmlns="http://www.w3.org/2000/svg" width="24" height="24" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round" class="feather feather-search"><circle cx="11" cy="11" r="8"></circle><line x1="21" y1="21" x2="16.65" y2="16.65"></line></svg>',
"sSearchPlaceholder": "Search...",
"sLengthMenu": "Results : _MENU_",
},
"stripeClasses": [],
"lengthMenu": [50, 100, 150, 200],
"pageLength": 50
});
</script>
<!-- END PAGE LEVEL SCRIPTS -->
<script>
$("#hoverbox").hover(function(){
$("#box").show();
},function(){
$("#box").hide();
});
function changestatus_booking(id) {
var retVal = confirm("Are you sure you want to Move To Arrival ?");
if (retVal == true) {
$.ajax({
url: 'ajax/changestatus_booking.php',
type: 'post',
data: {
'id': id
},
success: function(data) {
//alert(data);
if (data == 1) {
alert('Record Moved To Arrival Successfully');
location.reload();
}
},
});
} else {
return false;
}
}
</script>
</body>
</html>