Index of /home/htscrtms/newcrm.htshah.com/hslider
<?php
include('lib/db_connect.php');
include('lib/auth.php');
if(isset($_POST['submit']))
{
if ($_REQUEST['att_date'] != '') {
$att_date = date('Y-m-d', strtotime($_REQUEST['att_date']));
}
$selc="select * from `tabl_employees` where id='".$_SESSION["uer_id"]."'";
$qryc=mysqli_query($con,$selc) or die(mysqli_error($con));
$rowc=mysqli_fetch_array($qryc);
if(isset($_SESSION['seln']) && $_SESSION['seln']=="Superadmin"){
$clientId = $_REQUEST['clientId'];
}else{
$clientId = $rowc['id'];
}
$selt="select * from `tabl_attendance` where att_date='".$att_date."' && clientId='".$clientId."' && officeId='".$_REQUEST['officeId']."'";
$qryt=mysqli_query($con,$selt);
$rst=mysqli_fetch_array($qryt);
if(mysqli_num_rows($qryt)=="1")
{
$insert="update `tabl_attendance` set att_date='".$att_date."',att_status='".$_REQUEST['att_status']."',remarks='".$_REQUEST['remarks']."' where att_date='".$att_date."' && clientId='".$clientId."' && officeId='".$_REQUEST['officeId']."'";
}
else
{
$insert="insert into `tabl_attendance` set att_date='".$att_date."',officeId='".$_REQUEST['officeId']."',clientId='".$clientId."',att_status='".$_REQUEST['att_status']."',remarks='".$_REQUEST['remarks']."'";
}
$query=mysqli_query($con,$insert) or die(mysqli_error($con));
echo "<script>alert('Attendance Marked Successfully')</script>";
// header('Location: attendance_list.php');
echo "<script>window.location.href='attendance_list.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);">Admin</a></li>
<li class="breadcrumb-item active" aria-current="page"><span>Edit Attendance</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>Edit Attendance</h4>
</div>
</div>
</div>
<?php
$reg_sel = "select * from `tabl_attendance` where id ='".$_REQUEST["id"]."'";
$reg_quer = mysqli_query($con,$reg_sel) or die(mysqli_error($con));
$fetcharr = mysqli_fetch_array($reg_quer);
?>
<div class="widget-content widget-content-area">
<form id="comp_form" method="post">
<div class="form-row mb-2">
<div class="form-group col-md-6">
<label for="inputAddress">Attendence Date *</label>
<input type="date" class="form-control" name="att_date" id="att_date" required>
</div>
</div>
<div class="form-row mb-2">
<div class="form-group col-md-4">
<label for="compname">Select Office *</label>
<select class="form-control" name="officeId" id="officeId" required>
<option value="1" <?php if($fetcharr['officeId']=="1"){ echo "selected";}?>>Wadala</option>
<option value="3" <?php if($fetcharr['officeId']=="3"){ echo "selected";}?>>JNPT</option>
</select>
</div>
<?php if(isset($_SESSION['seln']) && $_SESSION['seln']=="Superadmin" || $_SESSION["name"]=="Vijaya Moopanar"){ ?>
<div class="form-group col-md-4">
<label for="deptnm">Employee Name</label>
<?php
$seld = "select * from `tabl_employees` where id='".$fetcharr['clientId']."'";
$qryd = mysqli_query($con, $seld);
$rsd = mysqli_fetch_array($qryd);
?>
<input type="text" class="form-control" name="clientIdnm" id="clientIdnm" value="<?php echo $rsd['firstName'] ?>" readonly>
<input type="hidden" class="form-control" name="clientId" id="clientId" value="<?php echo $rsd['id'] ?>" readonly>
</div>
<?php } ?>
<div class="form-group col-md-4">
<label for="inputEnterYourName">Select Status *</label>
<select class="form-control" name="att_status" id="att_status" required>
<option value="A">A</option>
<option value="CL">CL</option>
<option value="H">H</option>
<option value="HD">HD</option>
<option value="LM">LM</option>
<option value="P" selected="selected">P</option>
<option value="R">R</option>
<option value="UL">UL</option>
</select>
</div>
</div>
<div class="form-row mb-2">
<div class="form-group col-md-12">
<label for="inputEnterYourvalue">Remarks</label>
<textarea class="form-control" name="remarks" placeholder="Remarks"></textarea>
</div>
</div>
<!--<div class="form-row mb-2">
<div class="form-group col-md-6">
<label for="inputEnterYourvalue">Oxygen Level Above 90 *</label>
<select class="form-control" name="oxyLevel" id="oxyLevel" required>
<option value="">Select</option>
<option value="Yes">Yes</option>
<option value="No">No</option>
</select>
</div>
<div class="form-group col-md-6">
<label for="inputEnterYourvalue">Temperature Below 39 *</label>
<select class="form-control" name="tempBelow" id="tempBelow" required>
<option value="">Select</option>
<option value="Yes">Yes</option>
<option value="No">No</option>
</select>
</div>
</div>
<div class="form-row mb-2">
<div class="form-group col-md-6">
<label for="inputEnterYourName">Mask Available *</label>
<select class="form-control" name="mask" id="mask" required>
<option value="">Select</option>
<option value="Yes">Yes</option>
<option value="No">No</option>
</select>
</div>
<div class="form-group col-md-6">
<label for="inputEnterYourName">Face Shield Available *</label>
<select class="form-control" name="face" id="face" required>
<option value="">Select</option>
<option value="Yes">Yes</option>
<option value="No">No</option>
</select>
</div>
</div>-->
<div class="form-row mb-4">
<input name="submit" type="submit" class="btn btn-primary" value="Save">
<a href="attendance_list.php"><button type="button" class="btn btn-danger ml-2">Cancel</button></a>
</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>