如何使用代码点火器循环导出Excel中的多个用户出席情况

$getdateRangeVal = $this->getdaterange($from, $to);
$arrstatus = array();
$arrEmp = array();
foreach($_data as $mp) {
$empdata[] = array(
'emp_primary' => $mp->emp_primary,
'date' => $mp->date,
);          
}

foreach ($_data as $value) {            
$arrstatus[$value->emp_primary] = $value;
for($i = 0; $i<sizeof($getdateRangeVal); $i++){
$compare = array("date"=>$getdateRangeVal[$i],"emp_primary"=>$value->emp_primary);
$key = array_search($compare, $empdata);
if(strlen($key) > 0) {
$arrstatus[$value->emp_primary]->dateRange[] = array(
"status" => "P",
"getdateRangeVal" => $getdateRangeVal[$i],
"intime" => $_data[$key]->in_time,
"outtime" => $_data[$key]->out_time,
"totaltime" => $_data[$key]->total_time,
);
} else {
$arrstatus[$value->emp_primary]->dateRange[] = array(
"status"=>"A",
"getdateRangeVal"=>$getdateRangeVal[$i],
"intime" => "",
"outtime" => "",
"totaltime" => "",
);
}
}
}

$sheet->setCellValue('A5', 'EMP ID');
$sheet->setCellValue('D5', 'EMP NAME');
$sheet->setCellValue('A6', 'Days');
$sheet->setCellValue('A7', 'Status');
$sheet->setCellValue('A8', 'IN time');
$sheet->setCellValue('A9', 'Out time');
$sheet->setCellValue('A10', 'Total time');
$arr = array(
'0' => 'B',
'1' => 'C',
'2' => 'D',
'3' => 'E',
'4' => 'F',
'5' => 'G',
'6' => 'H',
'7' => 'I',
'8' => 'J',
'9' => 'K',
'10' => 'L',
'11' => 'M',
'12' => 'N',
'13' => 'O',
'14' => 'P',
'15' => 'Q',
'16' => 'R',
'17' => 'S',
'18' => 'T',
'19' => 'U',
'20' => 'V',
'21' => 'W',
'22' => 'X',
'23' => 'Y',
'24' => 'Z',
'25' => 'AA',
'26' => 'AB',
'27' => 'AC',
'28' => 'AD',
'29' => 'AE',
'30' => 'AF',
);
$i= 0;
$rowCount = 6;
$statusCount = 7;
$inCount = 8;
$outCount = 9;
$totalCount = 10;
$employeeId= $empdata[$i]['emp_primary'];
foreach($arrstatus[$employeeId]->dateRange as $val){
$sheet->setCellValue($arr[$i].$rowCount, date('j D',strtotime($val['getdateRangeVal'])));
if($val['status'] == 'P'){
$sheet->setCellValue($arr[$i].$statusCount, $val['status']);
}else{
$sheet->setCellValue($arr[$i].$statusCount, $val['status']);
}
$sheet->setCellValue($arr[$i].$inCount,$val['intime']);
$sheet->setCellValue($arr[$i].$outCount, $val['outtime']);
$sheet->setCellValue($arr[$i].$totalCount, $val['totaltime']);
$i++;
}

====

==================================这是我的数据

================================我必须这样打印

Report - Attendance Sheet
Duration - 1-Aug-18 TO 10-Aug-18
Name    Amol Auti   
Emp code    1001
Enrollment number   123456789   
Department  Development Designation Android Developer
Date    1-Aug   2-Aug   3-Aug   4-Aug   5-Aug   6-Aug   7-Aug   8-Aug   9-Aug   10-Aug
Status  A   A   A   P   P   P   A   A   A   A
In Time -   -   -   09:00:00    09:00:00    09:00:00    -   -   -   -
Out Time    -   -   -   16:00:00    16:00:00    9:00:00 -   -   -   -
Total Time  -   -   -   07:00:00.000000 07:00:00.000000 00:00:00.000000 -   -   -   -
Name    Sumit Malusare  Emp code    1002
Enrollment number   135454  
Department  Development 
Designation Web Developer
Date    1-Aug   2-Aug   3-Aug   4-Aug   5-Aug   6-Aug   7-Aug   8-Aug   9-Aug   10-Aug
Status  A   A   A   A   P   A   A   A   A   A
In Time -   -   -   -   09:00:00    -   -   -   -   -
Out Time    -   -   -   -   18:00:00    -   -   -   -   -
Total Time  -   -   -   -   09:00:00.000000 -   -   -   -   -

如果要在 excel 上导出它，则需要为此使用库。

这是一个关于如何将数据转换为Excel文件的精彩教程。

https://arjunphp.com/how-to-use-phpexcel-with-codeigniter/。

这就是我现在在我的项目中使用的。希望有帮助。

相关内容

最新更新

热门标签：