File: /var/www/html/taxicamera/applicationold/views/admin/roster/roster_edit.php
<div class="main-content">
<div class="content-wrapper">
<div class="container-fluid"><!-- Basic form layout section start -->
<section id="basic-form-layouts">
<div class="row">
<div class="col-md-12">
<div class="card">
<div class="card-header">
<div class="page-title-wrap">
<h4 class="card-title">Roster Edit(<?= $week_no;?>)</h4>
<?php echo $this->session->flashdata('msg') ?>
<?php
$shift_array = array('H','D','N');
if(!empty($get_car_by_wk))
{
?>
<form method="post" class="set_roster_frm edt_import_form" action="<?= base_url('admin/roster/add_roster');?>">
<input type="hidden" name="week_no" value="<?= $week_no;?>">
<?php
// echo "<pre>";
// print_r($get_car_by_wk);
// echo "</pre>";
//die();
$i = 0;
foreach ($get_car_by_wk as $car) :
?>
<h1><?= $car[0]['roster']['registration_no'];?></h1>
<input type="hidden" name="car_id[]" value="<?= $car[0]['roster']['car_id'];?>">
<div class="days_of_week table-responsive custom_table_area">
<table class="table-responsive custom_table_area table">
<thead>
<?php foreach ($car as $ax) : ?>
<td><?= $ax['roster']['dayname'];?><span><?= $ax['roster']['day_date']; ?> </span></td>
<?php endforeach; ?>
</thead>
<tbody>
<?php $d = 0; foreach ($car as $ax) : ?>
<td>
<input type="hidden" name="dayname[<?= $i;?>][]" value="<?= $ax['roster']['dayname']?>">
<input type="hidden" name="day_date[<?= $i;?>][]" value="<?= $ax['roster']['day_date']; ?>">
<input type="hidden" name="roster_id_hidden[<?= $i;?>][]" value="<?= $ax['roster']['roster_id']; ?>">
<?php
if($ax['roster']['breakdown'] != 1){
// $sh = 1;
// foreach ($car[$d]['roster']['shift'] as $shift) :
?>
<label class="breakdown">
<input type="checkbox" name="breakdown[<?= $i;?>][<?= $d;?>]" class="breakdown" value="1"> Breakdown / Accident
<select name="breakdown_reason[<?= $i;?>][<?= $d;?>]">
<option value="">Select Breakdown/Accident</option>
<option value="Breakdown">BreakDown</option>
<option value="Accident">Accident</option>
</select>
</label>
<?php $sts = 0; foreach ($shift_array as $single_shift) : ?>
<label>
<a href="javascript:void(0)" class="get_dvr_detail"><i class="fa fa-eye" aria-hidden="true"></i></a>
<span class="shw_drvr_details">
</span>
<?php $checked=$set_dv=$roster_shift_id=$roster_driver_id='';
foreach ($car[$d]['roster']['shift'] as $shift)
{
if($shift['shift_name'] == $single_shift)
{
$checked= "checked";
$set_dv = " set-dv=".$shift['driver']['driver_id'];
$roster_shift_id = $shift['roster_shift_id'];
$roster_driver_id = $shift['driver']['roster_driver_id'];
}
}
?>
<input type="checkbox" name="shift_name[<?= $i;?>][<?= $d;?>][<?= $sts;?>]" value="<?= $single_shift;?>" <?=$checked?> <?=$set_dv?>><?= $single_shift;?>
<input type="hidden" name="roster_shift_id_hidden[<?= $i;?>][<?= $d;?>][<?= $sts;?>]" value="<?=$roster_shift_id?>">
<input type="hidden" name="roster_driver_id_hidden[<?= $i;?>][<?= $d;?>][<?= $sts;?>]" value="<?= $roster_driver_id;?>">
<select name="driver_id[<?= $i;?>][<?= $d;?>][<?= $sts;?>]">
<option value="">Select Driver</option>
<?php foreach ($driver_list as $driver) : ?>
<option value="<?= $driver['user_id'];?>"><?= $driver['full_name'];?></option>
<?php endforeach; ?>
</select>
</label>
<?php $sts++; endforeach; ?>
<?php //$sh++; endforeach;
} else {
echo "<div class='alert alert-danger'>".$ax['roster']['breakdown_reason']."</div>";
?>
<label class="breakdown">
<input type="checkbox" name="breakdown[<?= $i;?>][<?= $d;?>]" class="breakdown" value="1" checked> Breakdown / Accident
<select name="breakdown_reason[<?= $i;?>][<?= $d;?>]">
<option value="">Select Breakdown/Accident</option>
<option value="Breakdown">BreakDown</option>
<option value="Accident">Accident</option>
</select>
</label>
<?php } ?>
</td>
<?php $d++; endforeach; ?>
</tbody>
</table>
</div>
<?php $i++; endforeach; ?>
<input type="submit" name="" value="submit" class="btn btn-info">
</form>
<?php
}
else
{
function getStartAndEndDate($week, $year) {
$dto = new DateTime();
$dto->setISODate($year, $week);
$ret['monday'] = $dto->format('Y-m-d');
$dto->modify('+1 days');
$ret['tuesday'] = $dto->format('Y-m-d');
$dto->modify('+1 days');
$ret['wednesday'] = $dto->format('Y-m-d');
$dto->modify('+1 days');
$ret['thursday'] = $dto->format('Y-m-d');
$dto->modify('+1 days');
$ret['friday'] = $dto->format('Y-m-d');
$dto->modify('+1 days');
$ret['saturday'] = $dto->format('Y-m-d');
$dto->modify('+1 days');
$ret['sunday'] = $dto->format('Y-m-d');
return $ret;
}
$year = date('Y');
//echo $year;
$week_array = getStartAndEndDate($week_no,$year);
//print_r($week_array);
$day_array = array(
0 => array(
'day' => 'Monday',
'date' => $week_array['monday'],
),
1 => array(
'day' => 'Tuesday',
'date' => $week_array['tuesday'],
),
2 => array(
'day' => 'Wednesday',
'date' => $week_array['wednesday'],
),
3 => array(
'day' => 'Thursday',
'date' => $week_array['thursday'],
),
4 => array(
'day' => 'Friday',
'date' => $week_array['friday'],
),
5 => array(
'day' => 'Saturday',
'date' => $week_array['saturday'],
),
6 => array(
'day' => 'Sunday',
'date' => $week_array['sunday'],
),
);
?>
<form method="post" class="set_roster_frm" action="<?= base_url('admin/roster/add_roster');?>">
<input type="hidden" name="week_no" value="<?= $week_no;?>">
<?php $i = 0; foreach ($cars as $car) : ?>
<h1><?= $car['registration_no'];?></h1>
<?php if($car['accident_status'] == 0) : ?>
<input type="hidden" name="car_id[]" value="<?= $car['car_id'];?>">
<div class="days_of_week table-responsive custom_table_area">
<table class="table-responsive custom_table_area table">
<thead>
<?php foreach ($day_array as $day) : ?>
<td><?= $day['day']?><span><?= $day['date']; ?> </span></td>
<?php endforeach; ?>
</thead>
<tbody>
<?php $d = 0; foreach ($day_array as $day) : ?>
<td>
<input type="hidden" name="dayname[<?= $i;?>][]" value="<?= $day['day']?>">
<input type="hidden" name="day_date[<?= $i;?>][]" value="<?= $day['date']; ?>">
<input type="hidden" name="roster_id_hidden[<?= $i;?>][]" value="">
<?php $sts = 0; foreach ($shift_array as $single_shift) : ?>
<label>
<input type="checkbox" name="shift_name[<?= $i;?>][<?= $d;?>][<?= $sts;?>]" value="<?= $single_shift;?>">
<?= $single_shift;?>
<input type="hidden" name="roster_shift_id_hidden[<?= $i;?>][<?= $d;?>][<?= $sts;?>]" value="">
<input type="hidden" name="roster_driver_id_hidden[<?= $i;?>][<?= $d;?>][<?= $sts;?>]" value="">
<select name="driver_id[<?= $i;?>][<?= $d;?>][<?= $sts;?>]">
<option value="">Select Driver</option>
<?php foreach ($driver_list as $driver) : ?>
<option value="<?= $driver['user_id'];?>"><?= $driver['full_name'];?></option>
<?php endforeach; ?>
</select>
</label>
<?php $sts++; endforeach; ?>
</td>
<?php $d++; endforeach; ?>
</tbody>
</table>
</div>
<?php elseif ($car['accident_status'] == 1) : ?>
<div class="alert alert-danger" role="alert">
<?= $car['accident_review'];?>
</div>
<?php endif; ?>
<?php $i++; endforeach; ?>
<input type="submit" name="" value="submit" class="btn btn-info">
</form>
<?php } ?>
</div>
</div>
</div>
</div>
</div>
</section>
</div>
</div>
</div>
<style type="text/css">
.set_roster_frm select
{
display: none;
}
.set_roster_frm label {
width: 100%;
background: #ccc;
cursor: pointer;
}
</style>
<script type="text/javascript">
$('#get_week_no').change(function(){
$('#search_roster_by_wk').submit();
});
$('.set_roster_frm label input[type="checkbox"]').click(function(){
if ($(this).is(':checked'))
{
$(this).siblings('select').slideDown();
$(this).siblings('select').attr('required','required');
var val = $(this).val();
if(val == 'H')
{
$(this).parent('label').siblings('label').find('input[type="checkbox"]').attr('disabled','disabled');
}
}
else
{
$(this).siblings('select').slideUp();
$(this).siblings('select').removeAttr('required');
$('.set_roster_frm label input[type="checkbox"]').removeAttr('disabled');
}
});
$('.edt_import_form label').each(function(){
var did = $(this).children('input[type="checkbox"]').attr('set-dv');
$(this).children('select').find('option[value="'+did+'"]').css('color','green');
$(this).children('select').find('option[value="'+did+'"]').attr('selected','selected');
//$(this).append(did);
});
$('#prevwk').click(function(){
var val = $(this).val();
//alert(val);
$(this).siblings('select').val(val);
$('#search_roster_by_wk').submit();
});
$('a.get_dvr_detail').click(function(){
var details = $(this).siblings('.shw_drvr_details');
var user_id = $(this).siblings("input[type='checkbox']").attr('set-dv');
alert(user_id);
if(user_id !== undefined)
{
$.ajax({
type: "POST",
url: '<?= base_url();?>admin/roster/get_driver_details/'+user_id,
success: function(response)
{
$.alert({
type: 'green',
title: 'Driver Details',
content: response,
});
//details.html(response);
}
});
}
else
{
$.alert({
type: 'red',
title: 'No Driver Set',
content: 'No driver is set here',
});
}
});
</script>