Index of /home/htscrtms/newcrm.htshah.com/hslider
<?php
include('lib/db_connect.php');
include('lib/auth.php');
if(isset($_POST['submit']))
{
if ($_REQUEST['expenseDate'] != '') {
$expenseDate = date('Y-m-d', strtotime($_REQUEST['expenseDate']));
}
$CREATED_DT = date('Y-m-d h:i:s');
$selt="select * from `tabl_exportclaim` where voucherNo='".$_REQUEST['voucherNo']."'";
$qryt=mysqli_query($con,$selt);
$rst=mysqli_fetch_array($qryt);
if(mysqli_num_rows($qryt)=="0")
{
$insert="insert into `tabl_exportclaim` set htshahNo='".$_REQUEST['htshahNo']."',voucherNo='".$_REQUEST['voucherNo']."',expenseDate='".$expenseDate."',pkgs='".$_REQUEST['pkgs']."',faxXerox='".$_REQUEST['faxXerox']."',warai='".$_REQUEST['warai']."',localDiesel='".$_REQUEST['localDiesel']."',cmc='".$_REQUEST['cmc']."',docExpenses='".$_REQUEST['docExpenses']."',travelling='".$_REQUEST['travelling']."',extra='".$_REQUEST['extra']."',loadUnload='".$_REQUEST['loadUnload']."',total='".$_REQUEST['total']."',remarks='".$_REQUEST['remarks']."',CREATED_BY='".$_SESSION["name"]."',CREATED_DT='".$CREATED_DT."',STATUS='NEW'";
$query=mysqli_query($con,$insert) or die(mysqli_error($con));
echo "<script>alert('Export Claim Added Successfully')</script>";
// header('Location: viewexportclaim.php');
echo "<script>window.location.href='viewexportclaim.php';</script>";
}
else
{
echo "<script>alert('Sorry! Duplicate Voucher Number Found...')</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 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="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 Export Claim</h4>
</div>
</div>
</div>
<div class="widget-content widget-content-area">
<form name="exportclaimsForm" method="POST">
<table class="datatable" width="100%" cellspacing="1" cellpadding="5" border="0">
<tbody>
<tr>
<td width="150">
HTSHAH Job Number:</td>
<td width="350">
<input type="text" name="htshahNo" maxlength="5" size="10" value="" class="form-control"></td>
<td></td>
</tr>
<tr>
<td>Voucher Number:<span class="mandatory">*</span></td>
<td><input type="text" name="voucherNo" maxlength="20" size="20" value="" required class="form-control"></td>
<td></td>
</tr>
<tr>
<td>Expense Date: </td>
<td><input type="date" name="expenseDate" size="10" id="expenseDate" class="form-control"></td>
<td></td>
</tr>
<tr>
<td>LCL / FCL:</td>
<td>
<select name="pkgs" class="form-control">
<option value="">-- Select --</option>
<option value="FCL">FCL</option>
<option value="LCL">LCL</option>
</select>
</td>
<td></td>
</tr>
<tr>
<td>Fax / Xerox:</td>
<td><input type="text" name="faxXerox" maxlength="10" size="10" value="0" onChange="javascript:updateTotals(this, 'Fax/Xerox');" class="form-control"></td>
<td></td>
</tr>
<tr>
<td>Warai:</td>
<td><input type="text" name="warai" maxlength="10" size="10" value="0" onChange="javascript:updateTotals(this, 'Warai');" class="form-control"></td>
<td></td>
</tr>
<tr>
<td>Speedy CFS/Buffer:</td>
<td><input type="text" name="localDiesel" maxlength="10" size="10" value="0" onChange="javascript:updateTotals(this, 'Local Diesel');" class="form-control"></td>
<td></td>
</tr>
<tr>
<td>CMC:</td>
<td><input type="text" name="cmc" maxlength="10" size="10" value="0" onChange="javascript:updateTotals(this, 'CMC');" class="form-control"></td>
<td></td>
</tr>
<tr>
<td>Doc Expenses:</td>
<td><input type="text" name="docExpenses" maxlength="10" size="10" value="0" onChange="javascript:updateTotals(this, 'Doc Expenses');" class="form-control"></td>
<td></td>
</tr>
<tr>
<td>Scanning:</td>
<td><input type="text" name="travelling" maxlength="10" size="10" value="0" onChange="javascript:updateTotals(this, 'Travelling');" class="form-control"></td>
<td></td>
</tr>
<tr>
<td>Extra:</td>
<td><input type="text" name="extra" maxlength="10" size="10" value="0" onChange="javascript:updateTotals(this, 'Extra');" class="form-control"></td>
<td></td>
</tr>
<tr>
<td>Loading / Unloading:</td>
<td><input type="text" name="loadUnload" maxlength="10" size="10" value="0" onChange="javascript:updateTotals(this, 'Loading / Unloading');" class="form-control"></td>
<td></td>
</tr>
<tr>
<td>Total:</td>
<td><input type="text" name="total" maxlength="15" size="15" value="0" readonly="readonly" class="form-control"></td>
<td></td>
</tr>
<tr>
<td>Remarks:</td>
<td><textarea name="remarks" cols="30" rows="3" onKeyPress="return IsAlphaNumeric(event);" class="form-control"></textarea></td>
<td></td>
</tr>
<tr>
<td colspan="3">
<input name="submit" type="submit" class="btn btn-primary" value="Save">
<a href="viewexportclaim.php"><button type="button" class="btn btn-danger ml-2">Cancel</button></a></td>
</tr>
</tbody>
</table>
</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>
<script>
var objRegExp = /^[0-9]*$/;
function checkValidValues(inputString){
return objRegExp.test(inputString);
}
function updateTotals(field, name){
form = document.exportclaimsForm;
if(!checkValidValues(field.value)){
alert(name + " should be an integer.");
field.value = "0";
return;
}
form.total.value = eval(form.faxXerox.value) + eval(form.warai.value) + eval(form.localDiesel.value) + eval(form.cmc.value)
+ eval(form.docExpenses.value) + eval(form.travelling.value) + eval(form.extra.value) + eval(form.loadUnload.value);
}
function IsAlphaNumeric(e) {
var keyCode = e.keyCode == 0 ? e.charCode : e.keyCode;
var ret = ((keyCode >= 48 && keyCode <= 57) || (keyCode >= 65 && keyCode <= 90) || (keyCode >= 97 && keyCode <= 122) || (specialKeys.indexOf(e.keyCode) != -1 && e.charCode != e.keyCode));
//document.getElementById("error").style.display = ret ? "none" : "inline";
return ret;
}
</script>
</body>
</html>