/**
* PrintLabelAct::act_export()
* 报表导出
* @author Gary
* @return void
*/
function act_export()
{
$printer = intval(trim($_GET['checkUser']));
$sku = trim($_GET['sku']);
$startdate = trim($_GET['startdate']);
$enddate = trim($_GET['enddate']);
if (empty($checkUser) && empty($sku) && empty($startdate) && empty($enddate)) {
echo "请选择导出条件";
exit;
}
$lists = printLabelModel::getExportData($printer, $sku, $startdate, $enddate);
$excel = new ExportDataExcel('browser', "PrintLabelData " . $startdate . '--' . $enddate . ".xls");
$excel->initialize();
$tharr = array("打标人", "SKU", "打标数量", '打印状态', "打标时间", "贴标人员", "贴标数量");
$excel->addRow($tharr);
foreach ($lists as $list) {
$user = getUserNameById($list['printerId']);
$sku = $list['sku'];
$num = $list['printNum'];
$status = $list['status'] == 1 ? '已确认' : '未确认';
$printTime = date('Y-m-d H:i:s', $list['printTime']);
$labelUser = $list['labelUserId'] ? getUserNameById($list['labelUserId']) : '无';
$labelNum = $list['labelNum'] ? $list['labelNum'] : '无';
$tdarr = array($user, $sku, $num, $status, $printTime, $labelUser, $labelNum);
$excel->addRow($tdarr);
}
$excel->finalize();
exit;
}
