Index of /home/htscrtms/newcrm.htshah.com/hslider
<?php
include('lib/db_connect.php');
include('lib/auth.php');
if(isset($_POST['submit']))
{
if ($_REQUEST['htshah_dt'] != '') {
$htshah_dt = date('Y-m-d', strtotime($_REQUEST['htshah_dt']));
}
if ($_REQUEST['edi_dt'] != '') {
$edi_dt = date('Y-m-d', strtotime($_REQUEST['edi_dt']));
}
if ($_REQUEST['thoka_dt'] != '') {
$thoka_dt = date('Y-m-d', strtotime($_REQUEST['thoka_dt']));
}
if ($_REQUEST['eta'] != '') {
$eta = date('Y-m-d', strtotime($_REQUEST['eta']));
}
if ($_REQUEST['dutyInformedDate'] != '') {
$dutyInformedDate = date('Y-m-d', strtotime($_REQUEST['dutyInformedDate']));
}
if ($_REQUEST['dutyReceivedDate'] != '') {
$dutyReceivedDate = date('Y-m-d', strtotime($_REQUEST['dutyReceivedDate']));
}
if ($_REQUEST['dutyPaidDate'] != '') {
$dutyPaidDate = date('Y-m-d', strtotime($_REQUEST['dutyPaidDate']));
}
if ($_REQUEST['arrived'] != '') {
$arrived = date('Y-m-d', strtotime($_REQUEST['arrived']));
}
if ($_REQUEST['org_Doc_Dt'] != '') {
$org_Doc_Dt = date('Y-m-d', strtotime($_REQUEST['org_Doc_Dt']));
}
if ($_REQUEST['cont_Bond_Dt'] != '') {
$cont_Bond_Dt = date('Y-m-d', strtotime($_REQUEST['cont_Bond_Dt']));
}
if ($_REQUEST['emptyLetter_Val_Dt'] != '') {
$emptyLetter_Val_Dt = date('Y-m-d', strtotime($_REQUEST['emptyLetter_Val_Dt']));
}
if ($_REQUEST['del_Pro_Dt'] != '') {
$del_Pro_Dt = date('Y-m-d', strtotime($_REQUEST['del_Pro_Dt']));
}
if ($_REQUEST['demur_Dt'] != '') {
$demur_Dt = date('Y-m-d', strtotime($_REQUEST['demur_Dt']));
}
if ($_REQUEST['detention_Dt'] != '') {
$detention_Dt = date('Y-m-d', strtotime($_REQUEST['detention_Dt']));
}
$CREATED_DT = date('Y-m-d h:i:s');
$aselquery = "select * from `tabl_importbooking` where htshah_no = '".$_REQUEST['htshah_no']."'";
$aquery_fetch = mysqli_query($con,$aselquery) or die(mysqli_error($con));
$afetchrows = mysqli_fetch_array($aquery_fetch);
if(mysqli_num_rows($aquery_fetch)=="0")
{
$insert="insert into `tabl_importbooking` set client_id='".$_REQUEST['client_id']."',htshah_no='".$_REQUEST['htshah_no']."',htshah_dt='".$htshah_dt."',htshah_no_Col='".$_REQUEST['htshah_no_Col']."',edi_no='".$_REQUEST['edi_no']."',edi_dt='".$edi_dt."',thoka_no='".$_REQUEST['thoka_no']."',thoka_dt='".$thoka_dt."',product='".$_REQUEST['product']."',product_Col='".$_REQUEST['product_Col']."',qty='".$_REQUEST['qty']."',fcl_Lcl='".$_REQUEST['fcl_Lcl']."',fcl_Lcl_Col='".$_REQUEST['fcl_Lcl_Col']."',invoice='".$_REQUEST['invoice']."',invoice_Col='".$_REQUEST['invoice_Col']."',shipping_Company='".$_REQUEST['shipping_Company']."',eta='".$eta."',eta_Col='".$_REQUEST['eta_Col']."',igm='".$_REQUEST['igm']."',igm_Col='".$_REQUEST['igm_Col']."',av='".$_REQUEST['av']."',av_Col='".$_REQUEST['av_Col']."',duty='".$_REQUEST['duty']."',dutyInformedDate='".$dutyInformedDate."',dutyReceivedDate='".$dutyReceivedDate."',dutyPaidDate='".$dutyPaidDate."',duty_Col='".$_REQUEST['duty_Col']."',rates='".$_REQUEST['rates']."',contNo='".$_REQUEST['contNo']."',location='".$_REQUEST['location']."',arrived='".$arrived."',free_Detention='".$_REQUEST['free_Detention']."',free_Detention_Col='".$_REQUEST['free_Detention_Col']."',org_Doc_Dt='".$org_Doc_Dt."',org_Doc_Dt_Col='".$_REQUEST['org_Doc_Dt_Col']."',cont_Bond_Dt='".$cont_Bond_Dt."',cont_Bond_Dt_Col='".$_REQUEST['cont_Bond_Dt_Col']."',emptyLetter_Val_Dt='".$emptyLetter_Val_Dt."',emptyLetter_Val_Dt_Col='".$_REQUEST['emptyLetter_Val_Dt_Col']."',del_Pro_Dt='".$del_Pro_Dt."',deliveryClerkId='".$_REQUEST['deliveryClerkId']."',del_Pro_Dt_Col='".$_REQUEST['del_Pro_Dt_Col']."',adv_Amt='".$_REQUEST['adv_Amt']."',adv_Amt_Col='".$_REQUEST['adv_Amt_Col']."',demur='".$_REQUEST['demur']."',demur_Dt='".$demur_Dt."',demur_Col='".$_REQUEST['demur_Col']."',detention='".$_REQUEST['detention']."',detention_Dt='".$detention_Dt."',detention_Col='".$_REQUEST['detention_Col']."',remark='".$_REQUEST['remark']."',remark_Col='".$_REQUEST['remark_Col']."',CREATED_BY='".$_SESSION["name"]."',CREATED_DT='".$CREATED_DT."',DELFLAG='N',STATUS='0'";
$query=mysqli_query($con,$insert) or die(mysqli_error($con));
echo "<script>alert('Import Booking Entry Added Successfully')</script>";
}
else
{
echo "<script>alert('Sorry! Record is not inserted. Duplicate Job No Found...')</script>";
}
// header('Location: viewbooking.php');
echo "<script>window.location.href='viewbooking.php';</script>";
}
?>
<!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"/>
<!-- 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" />
</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>Add New Import Booking Entry</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="container">
<div class="row">
<div id="flFormsGrid" class="col-lg-12 layout-spacing layout-top-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>Add New Import Booking Entry</h4>
</div>
</div>
</div>
<div class="widget-content widget-content-area">
<form id="comp_form" method="post">
<div class="table-responsive">
<table id="example" class="table dataTable" style="width: 100%;" role="grid" aria-describedby="example_info">
<tbody><tr>
<td>Select Client:<span class="mandatory">*</span></td>
<td width="500">
<select name="client_id" id="client_id" class="form-control">
<option value="-1">-- Select --</option>
<?php
$seld = "select * from `tabl_client` order by userName asc";
$qryd = mysqli_query($con, $seld);
while ($rsd = mysqli_fetch_array($qryd)) {
?>
<option value="<?php echo $rsd['id'] ?>"><?php echo $rsd['userName'] ?></option>
<?php
}
?>
</select></td>
<td></td>
<td></td>
</tr>
<tr>
<td>HTSHAH Job Number:<span class="mandatory">*</span></td>
<td><input type="text" name="htshah_no" maxlength="5" size="10" value="" onBlur="return checkJob();" class="form-control"></td>
<td><input type="date" name="htshah_dt" size="10" id="htshah_dt" class="form-control"></td>
<td><input type="checkbox" name="htshah_no_Col" value="#FFFF99"> Color</td>
</tr>
<tr>
<td>DPD YES/NO:</td>
<td><input type="text" name="edi_no" maxlength="4" size="10" value="" class="form-control"></td>
<td><input type="date" name="edi_dt" size="10" id="edi_dt" class="form-control"></td>
<td></td>
</tr>
<tr>
<td>Bill of entry number:</td>
<td><input type="text" name="thoka_no" maxlength="10" size="10" value="" class="form-control"></td>
<td><input type="date" name="thoka_dt" size="10" id="thoka_dt" class="form-control"></td>
<td></td>
</tr>
<tr>
<td>Product:</td>
<td><input type="text" name="product" maxlength="100" size="20" value="" class="form-control"></td>
<td></td>
<td><input type="checkbox" name="product_Col" value="#FFFF99"> Color</td>
</tr>
<tr>
<td>Quantity:</td>
<td><input type="text" name="qty" maxlength="20" size="20" value="" class="form-control"></td>
<td></td>
<td></td>
</tr>
<tr>
<td>LCL / FCL / Air:</td>
<td><select name="fcl_Lcl" class="form-control">
<option value="">-- Select --</option>
<option value="F">F</option>
<option value="L">L</option>
<option value="A">A</option>
</select></td>
<td></td>
<td><input type="checkbox" name="fcl_Lcl_Col" value="#FFFF99"> Color</td>
</tr>
<tr>
<td>Invoice No. and Supplier:</td>
<td><input type="text" name="invoice" maxlength="100" size="30" value="" class="form-control"></td>
<td></td>
<td><input type="checkbox" name="invoice_Col" value="#FFFF99"> Color</td>
</tr>
<tr>
<td>Shipping Company:</td>
<td><input type="text" name="shipping_Company" maxlength="100" size="30" value="" class="form-control"></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Eta:</td>
<td><input type="date" name="eta" size="10" id="eta" class="form-control"></td>
<td></td>
<td><input type="checkbox" name="eta_Col" value="#FFFF99"> Color</td>
</tr>
<tr>
<td>Goods Registration Date:</td>
<td><input type="text" name="igm" maxlength="50" size="20" value="" class="form-control"></td>
<td></td>
<td><input type="checkbox" name="igm_Col" value="#FFFF99"> Color</td>
</tr>
<tr>
<td>Cont Arrived / Scan:</td>
<td><input type="text" name="av" maxlength="50" size="20" value="" class="form-control"></td>
<td></td>
<td><input type="checkbox" name="av_Col" value="#FFFF99"> Color</td>
</tr>
<tr>
<td>Duty:</td>
<td><input type="text" name="duty" maxlength="50" size="20" value="" class="form-control">
Inform:
<input type="date" name="dutyInformedDate" size="10" id="dutyInformedDate" class="form-control">
Recd:
<input type="date" name="dutyReceivedDate" size="10" id="dutyReceivedDate" class="form-control">
Paid:
<input type="date" name="dutyPaidDate" size="10" id="dutyPaidDate" class="form-control"></td>
<td></td>
<td><input type="checkbox" name="duty_Col" value="#FFFF99"> Color</td>
</tr>
<tr>
<td>Registration date and time:</td>
<td><input type="text" name="rates" maxlength="20" size="20" value="" class="form-control"></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Cont. No.:</td>
<td><input type="text" name="contNo" maxlength="50" size="20" value="" class="form-control"></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Location:</td>
<td><input type="text" name="location" maxlength="50" size="20" value="" class="form-control"></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Arrived:</td>
<td><input type="date" name="arrived" size="10" id="arrived" class="form-control"></td>
<td></td>
<td></td>
</tr>
<tr>
<td>Customs Complete / OCC Available:</td>
<td><input type="text" name="free_Detention" maxlength="50" size="20" value="" class="form-control"></td>
<td></td>
<td><input type="checkbox" name="free_Detention_Col" value="#FFFF99"> Color</td>
</tr>
<tr>
<td>Org. docs. received date:</td>
<td><input type="date" name="org_Doc_Dt" size="10" id="org_Doc_Dt" class="form-control"></td>
<td></td>
<td><input type="checkbox" name="org_Doc_Dt_Col" value="#FFFF99"> Color</td>
</tr>
<tr>
<td>Cont. bond received date:</td>
<td><input type="date" name="cont_Bond_Dt" size="10" id="cont_Bond_Dt" class="form-control"></td>
<td></td>
<td><input type="checkbox" name="cont_Bond_Dt_Col" value="#FFFF99"> Color</td>
</tr>
<tr>
<td>Empty letter validity date:</td>
<td><input type="date" name="emptyLetter_Val_Dt" size="10" id="emptyLetter_Val_Dt" class="form-control"></td>
<td></td>
<td><input type="checkbox" name="emptyLetter_Val_Dt_Col" value="#FFFF99"> Color</td>
</tr>
<tr>
<td>Delivery Promised Date:</td>
<td><input type="date" name="del_Pro_Dt" size="10" id="del_Pro_Dt" class="form-control"></td>
<td><select name="deliveryClerkId" id="deliveryClerkId" class="form-control">
<option value="-1">Select Employee</option>
<?php
$selbins = "select * from `tabl_employees` order by id desc";
$qrybins = mysqli_query($con, $selbins);
while ($rsbins = mysqli_fetch_array($qrybins)) {
?>
<option value="<?php echo $rsbins['id']; ?>"><?php echo $rsbins['firstName']; ?></option>
<?php
}
?>
</select></td>
<td><input type="checkbox" name="del_Pro_Dt_Col" value="#FFFF99"> Color</td>
</tr>
<tr>
<td>OOC Time & Date:</td>
<td><input type="text" name="demur" maxlength="20" size="20" value="" class="form-control"></td>
<td><input type="date" name="demur_Dt" size="10" id="demur_Dt" class="form-control"></td>
<td><input type="checkbox" name="demur_Col" value="#FFFF99"> Color</td>
</tr>
<tr>
<td>Customs Complete / OCC cancel date:</td>
<td><input type="text" name="detention" maxlength="20" size="20" value="" class="form-control"></td>
<td><input type="date" name="detention_Dt" size="10" id="detention_Dt" class="form-control"></td>
<td><input type="checkbox" name="detention_Col" value="#FFFF99"> Color</td>
</tr>
<tr>
<td>Remarks:</td>
<td><textarea name="remark" cols="50" rows="3" onKeyPress="return IsAlphaNumeric(event);" class="form-control"></textarea></td>
<td></td>
<td><input type="checkbox" name="remark_Col" value="#FFFF99"> Color</td>
</tr>
<tr>
<td>Advance:</td>
<td><input type="text" name="adv_Amt" maxlength="20" size="20" value="" class="form-control"></td>
<td></td>
<td><input type="checkbox" name="adv_Amt_Col" value="#FFFF99"> Color</td>
</tr>
<tr>
<td colspan="4">
<input name="submit" type="submit" class="btn btn-primary" value="Save">
<a href="viewbooking.php"><button type="button" class="btn btn-danger ml-2">Cancel</button></a></td>
</tr>
</tbody>
</table>
</div>
</form>
</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>
</body>
</html>