report_timing_summary.blade.php
25.6 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
<?php
if(Input::has("dllogxls"))
{
include_once(app_path().'/lib/phpexcel/PHPExcel.php');
include_once(app_path().'/lib/phpexcel/PHPExcel/Writer/Excel2007.php');
$objPHPExcel = new PHPExcel();
$colstr=PHPExcel_Cell::stringFromColumnIndex(0);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr."2", 'Agent Timing Details');
$objPHPExcel->setActiveSheetIndex(0)->mergeCells('A2:C2');
$colstr=PHPExcel_Cell::stringFromColumnIndex(4);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr."2", $client);
$objPHPExcel->setActiveSheetIndex(0)->mergeCells('D2:E2');
$colstr=PHPExcel_Cell::stringFromColumnIndex(0);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr."3", date("d-M-Y",strtotime($start_date)) . " to " . date("d-M-Y",strtotime($end_date)));
$objPHPExcel->setActiveSheetIndex(0)->mergeCells('A3:C3');
$baseRow = 4;
$reporthead=array("#", "agent_name");
$baseCol = 2;
for ($i = 0; $i < count($daySTART); $i++) {
/*array_push($reporthead, 'login');
array_push($reporthead, 'none');*/
array_push($reporthead, 'total_pause_time');
array_push($reporthead, 'total_non_pause_time');
array_push($reporthead, 'staffing_time');
array_push($reporthead, 'total_break_time');
array_push($reporthead, 'productivity');
array_push($reporthead, 'aiding_productivity');
array_push($reporthead, 'agent_inactive_time');
array_push($reporthead, 'total_attend_time');
if($type=="Hourly") { $datefield = date("d-M-Y H:i:s",strtotime($daySTART[$i])); } elseif($type=="Daily") { $datefield = date("d-M-Y",strtotime($daySTART[$i])); }elseif($type=="Monthly") { $datefield = date("M-Y",strtotime($daySTART[$i])); }
$colstr=PHPExcel_Cell::stringFromColumnIndex($baseCol);
$colstrNext=PHPExcel_Cell::stringFromColumnIndex($baseCol+7);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$baseRow, $datefield);
$objPHPExcel->setActiveSheetIndex(0)->mergeCells($colstr.$baseRow.':'.$colstrNext.$baseRow);
$baseCol = $baseCol+8;
}
$baseRow = $baseRow+1;
$highestColumn = sizeof($reporthead);
for ($head = 0; $head < $highestColumn; $head++){
$colstr=PHPExcel_Cell::stringFromColumnIndex($head);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$baseRow, $reporthead[$head]);
}
$baseRow = $baseRow+1;
if(count($reportDataArray) > 0) {
$sr = 1;
$totalDataArr = array();
foreach ($reportDataArray as $user_id => $reportROW) {
$row = $baseRow++;
$col = 0;
$colstr=PHPExcel_Cell::stringFromColumnIndex(0);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$row, $sr);
$colstr=PHPExcel_Cell::stringFromColumnIndex(1);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$row, $userList[$user_id]);
$h=2;
for ($d = 0; $d < count($daySTART); $d++) {
$day = $daySTART[$d];
$total = $inbound = $outbound = $stafftime = 0;
$waittime = $pause_time = $talk_time = $avg_talk_time = $agntinctime = $totattendtime = '00:00:00';
$login_time = $logout_time = '';
if(array_key_exists($day, $reportROW))
{
$staff_time = $reportROW[$day]['staffing_time'];
$agnt_inc_time = $reportROW[$day]['agent_inactive_time'];
$tot_attend_time = $reportROW[$day]['total_attend_time'];
// Created array for total of all columns
$totalDataArr[$day]['login'][]=$reportROW[$day]['login'];
$totalDataArr[$day]['none'][]=$reportROW[$day]['none'];
$totalDataArr[$day]['total_pause_time'][]=$reportROW[$day]['total_pause_time'];
$totalDataArr[$day]['total_non_pause_time'][]=$reportROW[$day]['total_non_pause_time'];
$totalDataArr[$day]['staffing_time'][]=$staff_time;
$totalDataArr[$day]['total_break_time'][]=$reportROW[$day]['total_break_time'];
$totalDataArr[$day]['productivity'][]=$reportROW[$day]['productivity'];
$totalDataArr[$day]['aiding_productivity'][]=$reportROW[$day]['aiding_productivity'];
$totalDataArr[$day]['agnt_inc_time'][]=$agnt_inc_time;
$totalDataArr[$day]['tot_attend_time'][]=$tot_attend_time;
$login = sprintf('%02d:%02d:%02d', ($reportROW[$day]['login']/3600),($reportROW[$day]['login']/60%60), $reportROW[$day]['login']%60);
$none= sprintf('%02d:%02d:%02d', ($reportROW[$day]['none']/3600),($reportROW[$day]['none']/60%60), $reportROW[$day]['none']%60);
$total_pause_time = sprintf('%02d:%02d:%02d', ($reportROW[$day]['total_pause_time']/3600),($reportROW[$day]['total_pause_time']/60%60), $reportROW[$day]['total_pause_time']%60);
$total_non_pause_time = sprintf('%02d:%02d:%02d', ($reportROW[$day]['total_non_pause_time']/3600),($reportROW[$day]['total_non_pause_time']/60%60), $reportROW[$day]['total_non_pause_time']%60);
$stafftime = sprintf('%02d:%02d:%02d', ($staff_time/3600),($staff_time/60%60), $staff_time%60);
$total_break_time = sprintf('%02d:%02d:%02d', ($reportROW[$day]['total_break_time']/3600),($reportROW[$day]['total_break_time']/60%60), $reportROW[$day]['total_break_time']%60);
$productivity= sprintf('%02d:%02d:%02d', ($reportROW[$day]['productivity']/3600),($reportROW[$day]['productivity']/60%60), $reportROW[$day]['productivity']%60);
$aiding_productivity = sprintf('%02d:%02d:%02d', ($reportROW[$day]['aiding_productivity']/3600),($reportROW[$day]['aiding_productivity']/60%60), $reportROW[$day]['aiding_productivity']%60);
$agntinctime = sprintf('%02d:%02d:%02d', ($agnt_inc_time/3600),($agnt_inc_time/60%60), $agnt_inc_time%60);
$totattendtime = sprintf('%02d:%02d:%02d', ($tot_attend_time/3600),($tot_attend_time/60%60), $tot_attend_time%60);
}
else {
$login = $none= $total_pause_time = $total_non_pause_time = $stafftime = $total_break_time = $productivity= $aiding_productivity = $agntinctime = $totattendtime = '0:00';
}
/*$colstr=PHPExcel_Cell::stringFromColumnIndex($h++);
$objPHPExcel->setActiveSheetIndex()->setCellValue($colstr.$row, $login);
$colstr=PHPExcel_Cell::stringFromColumnIndex($h++);
$objPHPExcel->setActiveSheetIndex()->setCellValue($colstr.$row, $none);*/
$colstr=PHPExcel_Cell::stringFromColumnIndex($h++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$row, $total_pause_time);
$colstr=PHPExcel_Cell::stringFromColumnIndex($h++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$row, $total_non_pause_time);
$colstr=PHPExcel_Cell::stringFromColumnIndex($h++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$row, $stafftime);
$colstr=PHPExcel_Cell::stringFromColumnIndex($h++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$row, $total_break_time);
$colstr=PHPExcel_Cell::stringFromColumnIndex($h++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$row, $productivity);
$colstr=PHPExcel_Cell::stringFromColumnIndex($h++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$row, $aiding_productivity);
$colstr=PHPExcel_Cell::stringFromColumnIndex($h++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$row, $agntinctime);
$colstr=PHPExcel_Cell::stringFromColumnIndex($h++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$row, $totattendtime);
}
$sr++;
}
$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$baseRow, '');
$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$baseRow, '');
for ($d = 0; $d < count($daySTART); $d++) {
$day = $daySTART[$d];
if(array_key_exists($day, $totalDataArr)) {
/*$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex()->setCellValue($colstr.$baseRow, sprintf('%02d:%02d:%02d', (array_sum($totalDataArr[$day]['login'])/3600),(array_sum($totalDataArr[$day]['login'])/60%60), array_sum($totalDataArr[$day]['login'])%60));
$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex()->setCellValue($colstr.$baseRow, sprintf('%02d:%02d:%02d', (array_sum($totalDataArr[$day]['none'])/3600),(array_sum($totalDataArr[$day]['none'])/60%60), array_sum($totalDataArr[$day]['none'])%60));*/
$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$baseRow, sprintf('%02d:%02d:%02d', (array_sum($totalDataArr[$day]['total_pause_time'])/3600),(array_sum($totalDataArr[$day]['total_pause_time'])/60%60), array_sum($totalDataArr[$day]['total_pause_time'])%60));
$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$baseRow, sprintf('%02d:%02d:%02d', (array_sum($totalDataArr[$day]['total_non_pause_time'])/3600),(array_sum($totalDataArr[$day]['total_non_pause_time'])/60%60), array_sum($totalDataArr[$day]['total_non_pause_time'])%60));
$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$baseRow, sprintf('%02d:%02d:%02d', (array_sum($totalDataArr[$day]['staffing_time'])/3600),(array_sum($totalDataArr[$day]['staffing_time'])/60%60), array_sum($totalDataArr[$day]['staffing_time'])%60));
$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$baseRow, sprintf('%02d:%02d:%02d', (array_sum($totalDataArr[$day]['total_break_time'])/3600),(array_sum($totalDataArr[$day]['total_break_time'])/60%60), array_sum($totalDataArr[$day]['total_break_time'])%60));
$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$baseRow, sprintf('%02d:%02d:%02d', (array_sum($totalDataArr[$day]['productivity'])/3600),(array_sum($totalDataArr[$day]['productivity'])/60%60), array_sum($totalDataArr[$day]['productivity'])%60));
$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$baseRow, sprintf('%02d:%02d:%02d', (array_sum($totalDataArr[$day]['aiding_productivity'])/3600),(array_sum($totalDataArr[$day]['aiding_productivity'])/60%60), array_sum($totalDataArr[$day]['aiding_productivity'])%60));
$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$baseRow, sprintf('%02d:%02d:%02d', (array_sum($totalDataArr[$day]['agnt_inc_time'])/3600),(array_sum($totalDataArr[$day]['agnt_inc_time'])/60%60), array_sum($totalDataArr[$day]['agnt_inc_time'])%60));
$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$baseRow, sprintf('%02d:%02d:%02d', (array_sum($totalDataArr[$day]['tot_attend_time'])/3600),(array_sum($totalDataArr[$day]['tot_attend_time'])/60%60), array_sum($totalDataArr[$day]['tot_attend_time'])%60));
} else {
/*$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex()->setCellValue($colstr.$baseRow, '0:00');
$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex()->setCellValue($colstr.$baseRow, '0:00');*/
$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$baseRow, '0:00');
$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex()->setCellValue($colstr.$baseRow, '0:00');
$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$baseRow, '0:00');
$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$baseRow, '0:00');
$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$baseRow, '0:00');
$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$baseRow, '0:00');
$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$baseRow, '0:00');
$colstr=PHPExcel_Cell::stringFromColumnIndex($col++);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue($colstr.$baseRow, '0:00');
}
}
}
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="AgentTiming.xls"');
header('Cache-Control: max-age=0');
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save('php://output');
return;
}
?>
<div class=innerAll>
@if(Input::get("isrptsubmit"))
<div class="row"><h4>Agent Timing</h4></div>
<div class="row"> </div>
<div class="row" id="report-filter">
<div class="col-sm-10 col-md-10 col-lg-10">
<div class="row">
<div class="col-sm-12 col-md-6 col-lg-2 text-left"><label for="startDate" class="pull-left">Start Date : </label><input class="form-control" size=10 id='startDate' name='start_date' type='text' value='{{ $start_date }}' style="width: 55%;"/>
</div>
<div class="col-sm-12 col-md-6 col-lg-2 text-left">
<select class="form-control" id="start_time" name="start_time" value="{{ $start_time }}" style="width: 60%;">
<option value="">Time</option>
@for ($i = 0; $i <= 23; $i++)
<option value="<?= date("H:i:s", strtotime("$i:00")); ?>"><?= date("h A", strtotime("$i:00")); ?></option>
@endfor
<option value="23:59:59">11:59 PM</option>
</select>
</div>
<div class="col-sm-12 col-md-6 col-lg-2 text-left"><label for="endDate" class="pull-left">End Date : </label><input class="form-control" size=10 id='endDate' name='end_date' type='text' value='{{ $end_date }}' style="width: 60%;"/></div>
<div class="col-sm-12 col-md-6 col-lg-2 text-left">
<select class="form-control" id="end_time" name="end_time" value="{{ $end_time }}" style="width: 60%;">
<option value="">Time</option>
@for ($i = 0; $i <= 24; $i++)
<option value="<?= date("H:i:s", strtotime("$i:00")); ?>"><?= date("h A", strtotime("$i:00")); ?></option>
@endfor
<option value="23:59:59">11:59 PM</option>
</select>
</div>
<div class="text-left" style="display: none;"><label for="client" class="pull-left">Client : </label><select class="form-control" id="client" name="client" value="{{ $client }}" style="width: 60%;">
@foreach ($client_list as $key => $value)
<option value="{{ $key }}">{{ $value }}</option>
@endforeach
</select></div>
<div class="col-sm-12 col-md-6 col-lg-2 text-left"><label for="type" class="pull-left">Type : </label>
<select class="form-control" id="type" name="type" value="{{ $type }}" style="width: 60%;">
@foreach ($type_list as $key => $value)
<option value="{{ $key }}">{{ $value }}</optypetion>
@endforeach
</select></div>
<div class="col-sm-12 col-md-6 col-lg-2 text-left"><input type="button" class="btn btn-green" value="SUBMIT" id="btn-report-submit" onclick="agentPerformanceReloadFun();return false;"></div>
</div>
</div>
<div class="col-sm-2 text-left">
<button class="pull-right btn btn-sm btn-default" onclick='dlreportXls();return false;' title='Download' style='margin-top:-8px'><i class='fa fa-download'></i> Download</button>
</div>
</div>
<div class="row"> </div>
<hr>
@endif
<div>
<!-- CSS style -->
<style>
#logtable.td{vertical-align:top;}#logtable.tr{height:28px;overflow-y:hidden;}
#report-filter label {margin-top: 7px; }
</style>
<!-- Script -->
<script>
function agentPerformanceReloadFun()
{
doAjax('dialer/reportTimingSummary?isrptsubmit=0&start_date='+encodeURIComponent($("#startDate").val())+'&end_date='+encodeURIComponent($("#endDate").val())+'&start_time='+encodeURIComponent($("#start_time").val())+'&end_time='+encodeURIComponent($("#end_time").val())+'&client='+encodeURIComponent($("#client").val())+'&type='+encodeURIComponent($("#type").val()),'','agenttimingsummaryreportdiv','ajax_dialer_reports','singlethis','GET');
}
function dlreportXls()
{
window.open('dialer/reportTimingSummary?dllogxls=1&start_date='+encodeURIComponent($("#startDate").val())+'&end_date='+encodeURIComponent($("#endDate").val())+'&start_time='+encodeURIComponent($("#start_time").val())+'&end_time='+encodeURIComponent($("#end_time").val())+'&client='+encodeURIComponent($("#client").val())+'&type='+encodeURIComponent($("#type").val()));return false;
}
$(document).ready(function()
{
$('#startDate').datepicker({dateFormat: 'yy-mm-dd',inline: true,changeYear: true,selectOtherMonths: true,yearRange: '<?php echo (date('Y')-70).":".(date('Y')+5); ?>'});
$('#endDate').datepicker({dateFormat: 'yy-mm-dd',inline: true,changeYear: true,selectOtherMonths: true,yearRange: '<?php echo (date('Y')-70).":".(date('Y')+5); ?>'});
});
</script>
</div>
<div id="agenttimingsummaryreportdiv" style="overflow: auto;">
<TABLE id="logtable" class="footable table table-striped table-bordered table-white table-primary footable-loaded" style="font-size:12px">
<TR class="TableHeader" >
<TD class="bgTableHeader" align="left" rowspan="2">S.No </TD>
<TD class="bgTableHeader" align="center" rowspan="2"> Agent Name </TD>
@for ($i = 0; $i < count($daySTART); $i++)
<TD class="bgTableHeader" align="center" colspan="8">@if($type=="Hourly") {{ date("d-M-Y H:i:s",strtotime($daySTART[$i])) }} @elseif($type=="Daily") {{ date("d-M-Y",strtotime($daySTART[$i])) }} @elseif($type=="Monthly") {{ date("M-Y",strtotime($daySTART[$i])) }} @endif</TD>
@endfor
</TR>
<TR class="TableHeader" >
@for ($i = 0; $i < count($daySTART); $i++)
<!-- <TD class="bgTableHeader" align="center" > LOGIN </TD>
<TD class="bgTableHeader" align="center" >NONE</TD> -->
<TD class="bgTableHeader" align="center" >Total Pause Time</TD>
<TD class="bgTableHeader" align="center" >Total NonPause Time</TD>
<TD class="bgTableHeader" align="center">Total Staffing Time</TD>
<TD class="bgTableHeader" align="center">Total Break Time</TD>
<TD class="bgTableHeader" align="center">Productivity</TD>
<TD class="bgTableHeader" align="center">Aiding to Productivity</TD>
<TD class="bgTableHeader" align="center">Not LoggedIN Time</TD>
<TD class="bgTableHeader" align="center">Agent Attendance Time</TD>
@endfor
</TR>
<TBODY>
@if(count($reportDataArray) > 0)
<?php $sr = 1; $totalDataArr = array(); ?>
@foreach ($reportDataArray as $user_id => $reportROW)
<TR > <TD align="left" >{{ $sr }}</TD>
<TD align="center" >{{ $userList[$user_id] }}</TD>
@for ($d = 0; $d < count($daySTART); $d++)
<?php $day = $daySTART[$d]; ?>
@if(array_key_exists($day, $reportROW))
<?php
$staff_time = $reportROW[$day]['staffing_time'];
$agnt_inc_time = $reportROW[$day]['agent_inactive_time'];
$tot_attend_time = $reportROW[$day]['total_attend_time'];
// Created array for total of all columns
$totalDataArr[$day]['login'][]=$reportROW[$day]['login'];
$totalDataArr[$day]['none'][]=$reportROW[$day]['none'];
$totalDataArr[$day]['total_pause_time'][]=$reportROW[$day]['total_pause_time'];
$totalDataArr[$day]['total_non_pause_time'][]=$reportROW[$day]['total_non_pause_time'];
$totalDataArr[$day]['staff_time'][]=$staff_time;
$totalDataArr[$day]['total_break_time'][]=$reportROW[$day]['total_break_time'];
$totalDataArr[$day]['productivity'][]=$reportROW[$day]['productivity'];
$totalDataArr[$day]['aiding_productivity'][]=$reportROW[$day]['aiding_productivity'];
$totalDataArr[$day]['agnt_inc_time'][]=$agnt_inc_time;
$totalDataArr[$day]['tot_attend_time'][]=$tot_attend_time;
?>
<!-- <TD class="bgTableHeader" align="center">{{ sprintf('%02d:%02d:%02d', ($reportROW[$day]['login']/3600),($reportROW[$day]['login']/60%60), $reportROW[$day]['login']%60) }}</TD>
<TD class="bgTableHeader" align="center">{{ sprintf('%02d:%02d:%02d', ($reportROW[$day]['none']/3600),($reportROW[$day]['none']/60%60), $reportROW[$day]['none']%60) }}</TD> -->
<TD class="bgTableHeader" align="center">{{ sprintf('%02d:%02d:%02d', ($reportROW[$day]['total_pause_time']/3600),($reportROW[$day]['total_pause_time']/60%60), $reportROW[$day]['total_pause_time']%60) }}</TD>
<TD class="bgTableHeader" align="center">{{ sprintf('%02d:%02d:%02d', ($reportROW[$day]['total_non_pause_time']/3600),($reportROW[$day]['total_non_pause_time']/60%60), $reportROW[$day]['total_non_pause_time']%60) }}</TD>
<TD class="bgTableHeader" align="center" >{{ sprintf('%02d:%02d:%02d', ($staff_time/3600),($staff_time/60%60), $staff_time%60) }}</TD>
<TD class="bgTableHeader" align="center">{{ sprintf('%02d:%02d:%02d', ($reportROW[$day]['total_break_time']/3600),($reportROW[$day]['total_break_time']/60%60), $reportROW[$day]['total_break_time']%60) }}</TD>
<TD class="bgTableHeader" align="center">{{ sprintf('%02d:%02d:%02d', ($reportROW[$day]['productivity']/3600),($reportROW[$day]['productivity']/60%60), $reportROW[$day]['productivity']%60) }}</TD>
<TD class="bgTableHeader" align="center">{{ sprintf('%02d:%02d:%02d', ($reportROW[$day]['aiding_productivity']/3600),($reportROW[$day]['aiding_productivity']/60%60), $reportROW[$day]['aiding_productivity']%60) }}</TD>
<TD class="bgTableHeader" align="center">{{ sprintf('%02d:%02d:%02d', ($agnt_inc_time/3600),($agnt_inc_time/60%60), $agnt_inc_time%60) }}</TD>
<TD class="bgTableHeader" align="center">{{ sprintf('%02d:%02d:%02d', ($tot_attend_time/3600),($tot_attend_time/60%60), $tot_attend_time%60) }}</TD>
@else
<!-- <TD class="bgTableHeader" align="center" >0:00</TD>
<TD class="bgTableHeader" align="center">0:00</TD> -->
<TD class="bgTableHeader" align="center">0:00</TD>
<TD class="bgTableHeader" align="center">0:00</TD>
<TD class="bgTableHeader" align="center">0:00</TD>
<TD class="bgTableHeader" align="center">0:00</TD>
<TD class="bgTableHeader" align="center">0:00</TD>
<TD class="bgTableHeader" align="center">0:00</TD>
<TD class="bgTableHeader" align="center">0:00</TD>
<TD class="bgTableHeader" align="center">0:00</TD>
@endif
@endfor
<?php $sr++; ?>
</TR>
@endforeach
<TR >
<TD align="left" ></TD>
<TD align="center" ></TD>
@for ($d = 0; $d < count($daySTART); $d++)
<?php $day = $daySTART[$d]; ?>
@if(array_key_exists($day, $totalDataArr))
<!-- <TD class="bgTableHeader" align="center" >{{ sprintf('%02d:%02d:%02d', (array_sum($totalDataArr[$day]['login'])/3600),(array_sum($totalDataArr[$day]['login'])/60%60), array_sum($totalDataArr[$day]['login'])%60) }}</TD>
<TD class="bgTableHeader" align="center" >{{ sprintf('%02d:%02d:%02d', (array_sum($totalDataArr[$day]['none'])/3600),(array_sum($totalDataArr[$day]['none'])/60%60), array_sum($totalDataArr[$day]['none'])%60) }}</TD> -->
<TD class="bgTableHeader" align="center">{{ sprintf('%02d:%02d:%02d', (array_sum($totalDataArr[$day]['total_pause_time'])/3600),(array_sum($totalDataArr[$day]['total_pause_time'])/60%60), array_sum($totalDataArr[$day]['total_pause_time'])%60) }}</TD>
<TD class="bgTableHeader" align="center">{{ sprintf('%02d:%02d:%02d', (array_sum($totalDataArr[$day]['total_non_pause_time'])/3600),(array_sum($totalDataArr[$day]['total_non_pause_time'])/60%60), array_sum($totalDataArr[$day]['total_non_pause_time'])%60) }}</TD>
<TD class="bgTableHeader" align="center">{{ sprintf('%02d:%02d:%02d', (array_sum($totalDataArr[$day]['staff_time'])/3600),(array_sum($totalDataArr[$day]['staff_time'])/60%60), array_sum($totalDataArr[$day]['staff_time'])%60) }}</TD>
<TD class="bgTableHeader" align="center">{{ sprintf('%02d:%02d:%02d', (array_sum($totalDataArr[$day]['total_break_time'])/3600),(array_sum($totalDataArr[$day]['total_break_time'])/60%60), array_sum($totalDataArr[$day]['total_break_time'])%60) }}</TD>
<TD class="bgTableHeader" align="center">{{ sprintf('%02d:%02d:%02d', (array_sum($totalDataArr[$day]['productivity'])/3600),(array_sum($totalDataArr[$day]['productivity'])/60%60), array_sum($totalDataArr[$day]['productivity'])%60) }}</TD>
<TD class="bgTableHeader" align="center">{{ sprintf('%02d:%02d:%02d', (array_sum($totalDataArr[$day]['aiding_productivity'])/3600),(array_sum($totalDataArr[$day]['aiding_productivity'])/60%60), array_sum($totalDataArr[$day]['aiding_productivity'])%60) }}</TD>
<TD class="bgTableHeader" align="center">{{ sprintf('%02d:%02d:%02d', (array_sum($totalDataArr[$day]['agnt_inc_time'])/3600),(array_sum($totalDataArr[$day]['agnt_inc_time'])/60%60), array_sum($totalDataArr[$day]['agnt_inc_time'])%60) }}</TD>
<TD class="bgTableHeader" align="center">{{ sprintf('%02d:%02d:%02d', (array_sum($totalDataArr[$day]['tot_attend_time'])/3600),(array_sum($totalDataArr[$day]['tot_attend_time'])/60%60), array_sum($totalDataArr[$day]['tot_attend_time'])%60) }}</TD>
@else
<!-- <TD class="bgTableHeader" align="center" >0:00</TD>
<TD class="bgTableHeader" align="center">0:00</TD> -->
<TD class="bgTableHeader" align="center">0:00</TD>
<TD class="bgTableHeader" align="center">0:00</TD>
<TD class="bgTableHeader" align="center">0:00</TD>
<TD class="bgTableHeader" align="center">0:00</TD>
<TD class="bgTableHeader" align="center">0:00</TD>
<TD class="bgTableHeader" align="center">0:00</TD>
<TD class="bgTableHeader" align="center">0:00</TD>
<TD class="bgTableHeader" align="center">0:00</TD>
@endif
@endfor
</TR>
@endif
</TBODY>
</TABLE>
</div>
</div>