<?php
/* Database Connection */
require_once("inc/dbconnect.php");
if(isset($_GET['saveattendance'])) {
$dosale=$_REQUEST['dosale'];
$aemp = $_POST['chk'];
$checkwheaa=mysql_query("SELECT * FROM `tbl_workingday` where `date`='$dosale'");
if($checkwheaa and mysql_num_rows($checkwheaa) <= 0 )
{
if(empty($aemp))
{
?>
<div class="alert alert-error fade in">
<button data-dismiss="alert" class="close" type="button">×</button>
<strong>Error On Selection ! </strong> There are No Employee Selected..
</div><?php
}
else
{
$N = count($aemp);
for($i=0; $i < $N; $i++)
{
$empid=$aemp[$i];
$sqlpresent="INSERT INTO `tbl_attendance` (`date`, `branchid`, `empid`, `status`) VALUES ('$dosale', '-', '$empid', 'P');";
$sqrunatte=mysql_query($sqlpresent);
}
$sqlemp="Select * FROM `tbl_employee`";
$qrypass=mysql_query($sqlemp);
$noemp=mysql_num_rows($qrypass);
$abs=$noemp-$N;
$sqlempatte="INSERT INTO `tbl_workingday` (`date`, `Branch`, `emp`, `present`, `absent`) VALUES ('$dosale', '-', '$noemp', '$N', '$abs');";
$rrun=mysql_query($sqlempatte);
}
}
if($sqlempatte){
?><div class="alert alert-success"><button class="close" data-dismiss="alert" ></button>
<strong>Saved Succesfully ! </strong>Your Content(s) Has been Saved Successfully... </div><br>
<?php header("Refresh: 0;URL= 'attendance.php'"); ?>
<?php } else { ?>
<div class="alert alert-error fade in"><button data-dismiss="alert"></button>
<strong>Saved Failed ! </strong> Your Request to Save Content(s) are Failed...</div><br>
<?php } } ?>
<div class="block block-themed block-first">
<div class="block-title"><h4>Employee Attendance</h4></div>
<div class="block-content" >
<form enctype="multipart/form-data" class="form-horizontal" name="saveattendance" method="post" action="?saveattendance">
<h4 class="sub-header">Employee Attendance</h4>
<div class="control-group">
<label class="control-label" for="general-text">Date of Attendance</label>
<div class="controls"><input type="text" id="dosale" class="input-medium" name="dosale" readonly="readonly" value="<?php echo date("Y-m-d");?>"></div>
</div>
<table class="table table-bordered table-hover">
<thead><tr><th>Present/Absent</th><th>Employee Name</th><th>Contact Number</th></tr></thead>
<tbody><?php
$sqltablefilldata="SELECT * FROM `tbl_employee` ORDER BY `supid` ASC ";
$executetabledata=mysql_query($sqltablefilldata);
$numberoftabledata=mysql_num_rows($executetabledata);
while($row = mysql_fetch_assoc($executetabledata)){ ?>
<tr>
<td><input name="chk[]" type="checkbox" class="input-themed" id="<?php echo $row['supid'];?>" value="<?php echo $row['supid']; ?>" checked="checked" /></td><td><?php echo $row['supname']; ?></td><td><?php echo $row['supphone']; ?></td>
</tr>
<?php } ?></tbody></table>