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);">Consignments</a></li>
<li class="breadcrumb-item active" aria-current="page"><span>View Export Claim</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 Export Claim <a href="add_exportclaim.php" class="btn btn-info" style="float:right;">Add New Export Claim</a></h4>
</div>
<div class="col-xl-12 col-md-12 col-sm-12 col-12">
<form action="" method="POST" style="margin-top:20px;">
<div class="form-row mb-2">
<div class="form-group col-md-2">
<label>Select Status</label>
<select class="form-control" name="STATUS" required>
<option value="" selected>Select Status</option>
<option value="NEW">NEW</option>
<option value="OPEN">OPEN</option>
<option value="APPROVED">APPROVED</option>
<option value="REJECTED">REJECTED</option>
</select>
</div>
<div class="form-group col-md-2">
<label> </label>
<input name="submitfilter" class="btn btn-primary form-control" type="submit" value="SEARCH"/>
</div>
</div>
</form>
</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>Voucher No</th>
<th>HTSHAH Job</th>
<th>Client</th>
<th>Clerk Name</th>
<th>Expense Date</th>
<th>LCL / FCL</th>
<th>Fax / Xerox</th>
<th>Warai</th>
<th>Speedy CFS/Buffer</th>
<th>CMC</th>
<th>Doc Expenses</th>
<th>Extra</th>
<th>Scanning</th>
<th>Loading / Unloading</th>
<th>Total</th>
<th>Submit Date</th>
<th>Remarks</th>
<th>Status</th>
<!--<th class="no-content">Delete</th>-->
</tr>
</thead>
<tbody>
<?php $count=0;
if(isset($_POST['STATUS']) && !empty($_POST['STATUS'])){
$sel="select * from `tabl_exportclaim` where STATUS='".$_POST['STATUS']."' order by `id` desc";
}
else
{
$sel="select * from `tabl_exportclaim` order by id desc";
}
$qry=mysqli_query($con,$sel) or die(mysqli_error($con));
while($row=mysqli_fetch_array($qry))
{ $count++;
$selb="select * from `tabl_client` where id IN (select `client_id` from `tabl_exportentry` where htshah_no='".$row['htshahNo']."')";
$qryb=mysqli_query($con,$selb) or die(mysqli_error($con));
$rowb=mysqli_fetch_array($qryb);
?>
<tr>
<td><?php echo $count;?></td>
<td><a href="edit_exportclaim.php?id=<?php echo $row['id'] ?>"><?php echo $row['voucherNo']?></a></td>
<td><a href="edit_exportbooking.php?htshahNo=<?php echo $row['htshahNo'] ?>"><?php echo $row['htshahNo']?></a></td>
<td><?php echo $rowb['userName']?></td>
<td><?php echo $row["CREATED_BY"]?></td>
<td><?php echo date('d-m-Y', strtotime($row['expenseDate']));?></td>
<td><?php echo $row['pkgs']?></td>
<td><?php echo $row['faxXerox']?></td>
<td><?php echo $row['warai']?></td>
<td><?php echo $row['localDiesel']?></td>
<td><?php echo $row['cmc']?></td>
<td><?php echo $row['docExpenses']?></td>
<td><?php echo $row['extra']?></td>
<td><?php echo $row['travelling']?></td>
<td><?php echo $row['loadUnload']?></td>
<td><?php echo $row['total']?></td>
<td><?php echo date('d-m-Y', strtotime($row['CREATED_DT']));?></td>
<td><?php echo $row['remarks']?></td>
<td><?php echo $row['STATUS']?></td>
<!--<td><a onClick="delete_exportclaim(<?php echo $row['id']?>)" title="delete"><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-x-circle table-cancel"><circle cx="12" cy="12" r="10"></circle><line x1="15" y1="9" x2="9" y2="15"></line><line x1="9" y1="9" x2="15" y2="15"></line></svg></a></td>-->
</tr>
<?php
}
?>
</tbody>
<tfoot>
<tr>
<th>Sr.</th>
<th>Voucher No</th>
<th>HTSHAH Job</th>
<th>Client</th>
<th>Clerk Name</th>
<th>Expense Date</th>
<th>LCL / FCL</th>
<th>Fax / Xerox</th>
<th>Warai</th>
<th>Speedy CFS/Buffer</th>
<th>CMC</th>
<th>Doc Expenses</th>
<th>Extra</th>
<th>Scanning</th>
<th>Loading / Unloading</th>
<th>Total</th>
<th>Submit Date</th>
<th>Remarks</th>
<th>Status</th>
<!--<th></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>
function delete_exportclaim(id){
var retVal = confirm("Are you sure want to delete ?");
if( retVal == true ){
$.ajax({
url:'ajax/delete_exportclaim.php',
type:'post',
data:{'id':id},
success:function(data){
//alert(data);
if(data==1){
location.reload();
}
},
});
}else{
return false;
}
}
</script>
</body>
</html>