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>Export Deleted Report</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>Export Deleted Report<?php if(isset($_SESSION['seln']) && $_SESSION['seln']!="Client"){ ?> <a href="add_exportentry.php" class="btn btn-info" style="float:right;">Add New Export 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>Shipping bill no</th>
<th>Supplier</th>
<th>PKGs</th>
<th>Shipping Co. & Cont. No.</th>
<th>Empty D.o.</th>
<th>Factory Stuffing</th>
<th>Cut off to cont. no</th>
<th>Carting</th>
<th>Exam</th>
<th>Stuffing</th>
<th>Sailing</th>
<th>Handover of S/Bill</th>
<th>Shipping Bill Rels</th>
<th>Acd/eu decl</th>
<th>Remarks</th>
<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_exportentry` where DELFLAG='Y' && client_id='".$rowcl['id']."' order by id desc";
}else{
$sel="select * from `tabl_exportentry` where DELFLAG='Y' 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_exportbooking.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['supplier_col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['supplier']?></td>
<td<?php if($row['pkgs_col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['pkgs']?></td>
<td<?php if($row['vessel_col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['vessel']?></td>
<td<?php if($row['empty_doc_recd_dt_col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['empty_doc_recd_dt']?></td>
<td<?php if($row['factory_stuffing_datetime_col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['factory_stuffing_datetime']?></td>
<td<?php if($row['cutoff_cont_no_col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['cutoff_cont_no']?></td>
<td<?php if($row['carting_col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['carting']?></td>
<td<?php if($row['exam_col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['exam']?></td>
<td<?php if($row['stuffing_col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['stuffing']?></td>
<td<?php if($row['sailing_col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['sailing']?></td>
<td<?php if($row['handover_of_sb_col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['handover_of_sb']?></td>
<td<?php if($row['shipping_bill_release_dt_col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['shipping_bill_release_dt']?></td>
<td<?php if($row['acdDeclFiled_dt_col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['acdDeclFiled_dt']?></td>
<td<?php if($row['remark_Col']=="#FFFF99"){ ?> bgcolor="#FFFF99" <?php } ?>><?php echo $row['remark']?></td>
<td><a href="expdeletedreport-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>Shipping bill no</th>
<th>Supplier</th>
<th>PKGs</th>
<th>Shipping Co. & Cont. No.</th>
<th>Empty D.o.</th>
<th>Factory Stuffing</th>
<th>Cut off to cont. no</th>
<th>Carting</th>
<th>Exam</th>
<th>Stuffing</th>
<th>Sailing</th>
<th>Handover of S/Bill</th>
<th>Shipping Bill Rels</th>
<th>Acd/eu decl</th>
<th>Remarks</th>
<th class="no-content">Mail / Excel</th>
</tr>
</tfoot>
</table>
</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();
});
</script>
</body>
</html>