File "faculty_attendance.php"
Full path: /var/www/krbed.in/application618/views/faculty_attendance.php
File size: 17.83 KiB (18261 bytes)
MIME-type: text/html
Charset: utf-8
<style>
.absent {
color: red;
}
.od {
color: chocolate;
}
.week-off {
color: blue;
}
.holiday {
color: orange;
}
.present {
color: green;
}
.faculty-attendance-table table {
border-spacing: 1px !important;
}
.faculty-attendance-table th {
padding: 5px;
background-color: #032555;
color: #fff;
}
.faculty-attendance-table td {
padding: 10px;
text-align: center;
color: #545454;
font-size: 16px;
border: 1px solid black;
}
.faculty-attendance-table tr:nth-child(even) {
background-color: #D1E4FF;
}
.faculty-attendance-table tr:nth-child(odd) {
background-color: #D1E4FF;
}
.td-left {
text-align: left !important;
}
table thead {
padding: 5px;
background-color: #032555;
color: #fff;
}
.table-scroll {
position: relative;
margin: auto;
overflow: hidden;
}
.table-wrap {
width: 100%;
overflow: auto;
}
.table-scroll table {
width: 100%;
margin: auto;
//border-collapse: collapse;
border-spacing: 0;
}
.table-scroll th,
.table-scroll td {
padding: 5px 10px;
border: 1px solid white;
white-space: nowrap;
vertical-align: center;
text-align: center;
}
.clone {
position: absolute;
top: 0;
left: 0px;
pointer-events: none;
}
.clone th,
.clone td {
visibility: hidden
}
.clone td {
border-color: transparent;
background: #F4F4F4;
}
.clone th {
border-color: white !important;
}
.clone tbody th {
visibility: visible;
color: red;
}
.clone .fixed-side {
border: 1px solid black;
visibility: visible;
}
.table-scroll td {
border: 1px solid black;
}
.mtb-30 {
margin-top: 30px;
margin-bottom: 30px;
}
</style>
<div class="">
<h2 class="hpad">
</h2>
<h5 class="blue"><strong></strong></h5>
<p class="stext">
</p>
<div class="">
<h2 class="hpad">Faculty Attendance Details
</h2>
<h5 class="blue"><strong></strong></h5>
<div class="row">
</div>
</div>
</div>
<?php
$c_year = date("Y");
$c_m = date("m");
?>
<div class="row">
<form class="clearfix" method="post" id="" action="#">
<?php
$this->db->from('month_list');
$month_list = $this->db->get()->result_array();
?>
<div class="col1" style="width:10%; margin-top: 6px;">
<label for="cat">Select Month</label>
</div>
<div class="col1" style="width:25%;">
<div class="input-select">
<select name="select_month" id="select_month" class="postform" style=" width: 230px;" />
<option value="">Select Month </option>
<?php foreach ($month_list as $row) { ?>
<option value="<?php echo $row['month_list_id'] ?>" <?php if ($c_m == $row['month_list_id']) {
echo 'selected';
} ?>><?php echo ucwords($row['month_name']) ?> </option>
<?php } ?>
</select>
</div> <!-- /.retouch-select -->
</div> <!-- /.full-row -->
<div class="col1" style="width:8%; margin-top: 6px;">
<label for="cat">Select Year</label>
</div>
<div class="col1" style="width:25%;">
<?php
$this->db->from('financial_year');
$year_list = $this->db->get()->result_array(); ?>
<div class="input-select">
<select name="select_year" id="select_year" class="postform" style=" width: 230px;">
<?php foreach ($year_list as $row) { ?>
<option value="<?php echo $row['financial_from_year'] ?>" <?php if ($c_year == $row['financial_from_year']) {
echo 'selected';
} ?>><?php echo ucwords($row['financial_from_year']) ?> </option>
<?php } ?>
</select>
</div> <!-- /.retouch-select -->
</div> <!-- /.full-row -->
<div class="col1" style="width:25%;">
<div class="submit_field">
<input class="mainBtn" type="button" name="" id="search" value="Search" />
</div> <!-- /.submit-field -->
</div> <!-- /.full-row -->
</form>
</div>
<?php
$previous_week = strtotime("-1 week +1 day");
$monthfirstday = strtotime(date('Y-m-01'));
$monthendday = strtotime(date("Y-m-t"));
$end_week = strtotime("last Saturday");
$start_week_now = date("Y-m-d", $monthfirstday);
$end_week = strtotime("last Saturday");
$end_week_now = date("Y-m-d", $monthendday);
$start_week_next = date("Y-m-d", $monthfirstday);
$end_week_next = date("Y-m-d", $monthendday);
$start_week_another = date("Y-m-d", $monthfirstday);
$end_week_another = date("Y-m-d", $monthendday);
$start_week_next_another = date("Y-m-d", $monthfirstday);
$end_week_next_another = date("Y-m-d", $monthendday);
$start_week = date("Y-m-d", $monthfirstday);
$end_week = date("Y-m-d", $monthendday);
// $start_week = new DateTime($start_week);
// $end_week = new DateTime($monthendday);
// $month_id = date("m");
// $year_id = date("Y");
// $dateDiff=date_diff($start_week,$end_week);
// $dateDiff = $dateDiff->format("%a");
$CI = &get_instance();
$CI->load->model('Home_model');
$facultyDetails = $CI->Home_model->get_faculty_name();
?>
<div id="basetable">
<div id="table-scroll" class="table-scroll mtb-30">
<div class="table-wrap ">
<table class="main-table">
<thead>
<tr>
<th width="1%" class="fixed-side" rowspan="2">S.No </th>
<th class="td-left fixed-side" rowspan="2">Faculty Name</th>
<th width="6%" rowspan="2" class="fixed-side">Time</th>
<?php
for ($i = strtotime($start_week_now); $i <= strtotime($end_week_now); $i = strtotime($start_week_now)) {
if ($i <= strtotime($end_week_now))
?>
<th style="width:3%;"><?php echo date("D", strtotime($start_week_now)) ?></th>
<?php
$start_week_now = date("Y-m-d", strtotime("+1 day", strtotime($start_week_now)));
}
?>
</tr>
<tr>
<?php
for ($j = strtotime($start_week_next); $j <= strtotime($end_week_next); $j = strtotime($start_week_next)) {
if ($j <= strtotime($end_week_next))
?>
<th style="width:3%;"><?php echo date("d", strtotime($start_week_next)) ?></th>
<?php
$start_week_next = date("Y-m-d", strtotime("+1 day", strtotime($start_week_next)));
}
?>
</tr>
</thead>
<tbody>
<?php
$n = 1;
$totrow = count($facultyDetails);
foreach ($facultyDetails as $fd) {
$facultyName = ucwords($fd['faculty_name']);
$faculty_details_id = ucwords($fd['faculty_details_id']);
?>
<tr>
<td rowspan="2" class="fixed-side"><?php echo $n ?></td>
<td rowspan="2" class="td-left fixed-side"><?php echo $facultyName ?></td>
<td class="fixed-side">In</td>
<?php
$end_week = strtotime("last Saturday");
$start_week_another = date("Y-m-d", $monthfirstday);
$start_week_anotherth = date("Y-m-d", $monthendday);
$end_week_another = date("Y-m-d", $end_week);
for ($k = strtotime($start_week_another); $k <= strtotime($start_week_anotherth); $k = strtotime($start_week_another)) {
$start_week_another = date("Y-m-d", strtotime($start_week_another));
$CI = &get_instance();
$CI->load->model('Home_model');
$getFacultyByDate = $CI->Home_model->getFacultyDetailsByDate($faculty_details_id, $start_week_another);
$present_statuss = '';
$present_status_namee = "-";
$in_time = '';
$class_name = '';
if (!empty($getFacultyByDate)) {
$in_time = date('H:i', strtotime($getFacultyByDate['in_time']));
$in_timee = date('H:i:s', strtotime($getFacultyByDate['in_time']));
$out_time = date('H:i:s a', strtotime($getFacultyByDate['out_time']));
$out_timee = date('H:i:s', strtotime($getFacultyByDate['out_time']));
$present_statuss = $getFacultyByDate['present_status'];
$attendance_date = $getFacultyByDate['attendance_date'];
$faculty_attendance_id = $getFacultyByDate['faculty_attendance_id'];
$days_names = date('d', strtotime($attendance_date));
if ($present_statuss == 1) {
$present_status_namee = 'Present';
$class_name = "present";
} else if ($present_statuss == 2) {
$present_status_namee = 'Absent';
$class_name = "absent";
} else if ($present_statuss == 3) {
$present_status_namee = 'Week-off';
$class_name = "week-off";
} else if ($present_statuss == 4) {
$present_status_namee = 'OD';
$class_name = "od";
} else {
$present_status_namee = 'Holiday';
$class_name = "holiday";
}
}
$intimee = ($present_statuss == 1) ? $in_time : $present_status_namee;
if ($k <= strtotime($end_week_another)) { ?>
<?php if ($present_statuss != 1) { ?>
<td rowspan="2" class="<?php echo $class_name ?>"> <?php echo $intimee; ?></td>
<?php
} else { ?>
<td class="present "><?php echo $intimee; ?></td>
<?php
}
} else { ?>
<td rowspan="2">-</td>
<?php
}
$start_week_another = date("Y-m-d", strtotime("+1 day", strtotime($start_week_another)));
}
?>
</tr>
<tr>
<td class="fixed-side">Out</td>
<?php
$previous_week = strtotime("-1 week +1 day");
$start_week = strtotime("last sunday midnight", $previous_week);
$end_week = strtotime("last Saturday");
$start_week_next_another = date("Y-m-d", $monthfirstday);
$end_week_next_another = date("Y-m-d", $end_week);
for ($p = strtotime($start_week_next_another); $p <= strtotime($end_week_next_another); $p = strtotime($start_week_next_another)) {
$start_week_next_another = date("Y-m-d", strtotime($start_week_next_another));
$CI = &get_instance();
$CI->load->model('Home_model');
$getFacultyByDatee = $CI->Home_model->getFacultyDetailsByDate($faculty_details_id, $start_week_next_another);
$present_status = '';
$out_timee = '';
$present_status_name = "-";
if (!empty($getFacultyByDatee)) {
$in_time = date('H:i:s a', strtotime($getFacultyByDatee['in_time']));
$in_timee = date('H:i:s', strtotime($getFacultyByDatee['in_time']));
$out_time = date('H:i:s a', strtotime($getFacultyByDatee['out_time']));
$out_timee = date('H:i', strtotime($getFacultyByDatee['out_time']));
$present_status = $getFacultyByDatee['present_status'];
$attendance_date = $getFacultyByDatee['attendance_date'];
$faculty_attendance_id = $getFacultyByDatee['faculty_attendance_id'];
$days_names = date('d', strtotime($attendance_date));
$present_status_name = '';
if ($present_status == 1) {
$present_status_name = 'Present';
} else if ($present_status == 2) {
$present_status_name = 'Absent';
} else if ($present_status == 3) {
$present_status_name = 'Week-off';
} else if ($present_status == 4) {
$present_status_name = 'OD';
} else {
$present_status_name = 'Holiday';
}
}
$out_timee = ($present_status == 1) ? $out_timee : $present_status_name;
if ($p <= strtotime($end_week_next_another)) {
if ($present_status == 1) { ?>
<td class="present"> <?php echo $out_timee ?> </td>
<?php
}
} else { ?>
<td class="present"> <?php echo $out_timee ?> </td>
<?php
}
$start_week_next_another = date("Y-m-d", strtotime("+1 day", strtotime($start_week_next_another)));
} ?>
</tr>
<?php
$n++;
}
?>
</tbody>
</table>
</div>
</div>
</div>
<div id="basetableSec">
</div>
<script>
$('#search').click(function() {
$("#axloader").show();
var month_id = $('#select_month').val();
var year_id = $('#select_year').val();
if (month_id == '') {
technoNotify("", "Please select month", "warning")
} else if (year_id == '') {
technoNotify("", "Please select year", "warning")
} else {
$.ajax({
type: 'post',
url: base_url + 'additional/getAttendance',
data: {
month_id: month_id,
year_id: year_id
},
success: function(results) {
$("#axloader").hide();
$('#basetable').hide();
$('#basetableSec').html(results);
$(".main-table").clone(true).appendTo('#table-scrolll').addClass('clone');
},
error: function() {
//callback();
}
})
}
})
function getLastWeek() {
var today = new Date();
var lastWeek = new Date(today.getFullYear(), today.getMonth(), today.getDate() - 7);
return lastWeek;
}
var lastWeek = getLastWeek();
var lastWeekMonth = lastWeek.getMonth() + 1;
var lastWeekDay = lastWeek.getDate();
var lastWeekYear = lastWeek.getFullYear();
var lastWeekDisplay = lastWeekMonth + "/" + lastWeekDay + "/" + lastWeekYear;
var lastWeekDisplayPadded = ("00" + lastWeekMonth.toString()).slice(-2) + "/" + ("00" + lastWeekDay.toString()).slice(-2) + "/" + ("0000" + lastWeekYear.toString()).slice(-4);
console.log(lastWeekDisplay);
console.log(lastWeekDisplayPadded);
jQuery(document).ready(function() {
jQuery(".main-table").clone(true).appendTo('#table-scroll').addClass('clone');
});
</script>