$array[0] = "Nhân viên"; $array[1] = "Email đăng nhập"; $array[2] = "Giới tính"; $array[3] = "Cấp độ"; $array[4] = "Đạt thành tích"; $array[5] = "Khen thưởng"; $headerColumn = new TableHeaderColumn(null, $array); $headerColumn->setColumnWidth(0, 200); $headerColumn->setColumnWidth(1, 300); $headerColumn->setColumnWidth(4, 100); $headerColumn->setColumnWidth(5, 100); $array = array(); for ($i = 0; $i < count($evaluate); $i++) { $user = UsersBUS::GetUserByID($evaluate[$i]['iduser']); $array[$i][0] = $user['hoten']; $array[$i][1] = $user['email']; $array[$i][2] = $user['gioitinh']; $array[$i][3] = $user['level']; $array[$i][4] = $evaluate[$i]['loai']; $array[$i][5] = $evaluate[$i]['thuong']; } // generate file (constructor parameters are optional) ; $xls = new Excel_XML('UTF-8', false, 'Workflow Management'); $xls->setTableHeaderColumn($headerColumn); $xls->setTile("s57", "Thống kê đánh giá nhân viên"); $xls->setAutoData($array); $xls->getXML("Output_Report_WFM"); } else { $page = $_REQUEST['page']; echo EvaluateProcessor::load($page, -1, -1, -1, -1); }
$array[$i][4] = $business[$i]['ngaydang']; $array[$i][5] = $business[$i]['thoihantin']; switch ($business[$i]['status']) { case 0: $array[$i][6] = "Tin chờ duyệt"; break; case 1: $array[$i][6] = "Tin đã duyệt"; break; case 2: $array[$i][6] = "Tin đăng VIP"; break; case 3: $array[$i][6] = "Tin hết hạn"; break; default: $array[$i][6] = "Tin bị xóa"; break; } $array[$i][7] = $loaidv['ten']; } // generate file (constructor parameters are optional) $xls = new Excel_XML('UTF-8', false, 'Workflow Management'); $xls->setTableHeaderColumn($headerColumn); $xls->setTile("s57", "Thống kê tin VIP"); $xls->setAutoData($array); $xls->getXML("Output_Report_WFM"); } else { echo VipProcessor::loadByType($page, $loaidv, $ngayfrom, $ngayto); } }
for ($i = 0; $i < count($advertisement); $i++) { $array[$i][0] = $advertisement[$i]['chusohuu']; $array[$i][1] = $advertisement[$i]['diachi']; $array[$i][2] = $advertisement[$i]['hinhanh']; $array[$i][3] = $advertisement[$i]['ngaydang']; $array[$i][4] = $advertisement[$i]['sothang']; switch ($advertisement[$i]['status']) { case 0: $array[$i][5] = "Tin hết hạn"; break; case 1: $array[$i][5] = "Tin đang hoạt động"; break; case 2: $array[$i][5] = "Tin bị xóa"; break; default: $array[$i][5] = "Tin bị xóa"; break; } } // generate file (constructor parameters are optional) ; $xls = new Excel_XML('UTF-8', false, 'Workflow Management'); $xls->setTableHeaderColumn($headerColumn); $xls->setTile("s57", "Thống kê quảng cáo"); $xls->setAutoData($array); $xls->getXML("Output_Report_WFM"); } else { $page = $_REQUEST['page']; echo AdvertisementProcessor::load($page, -1); }
$totalItems = ThuChiBUS::countByMonth($loai, 1, 12, $nam); $business = ThuChiBUS::getAllByMonth(0, $totalItems[0], $loai, 1, 12, $nam); } $array = array(); require '../Utils/php-excel.class.php'; $array[0] = "Ngày thu"; $array[1] = "Công việc"; $array[2] = "Nhân viên thu"; $array[3] = "Số tiền"; $headerColumn = new TableHeaderColumn(null, $array); $headerColumn->setColumnWidth(0, 100); $headerColumn->setColumnWidth(1, 300); $headerColumn->setColumnWidth(2, 200); $headerColumn->setColumnWidth(3, 100); $array = array(); for ($i = 0; $i < count($business); $i++) { $user = UsersBUS::GetUserByID($business[$i]['nhanvien']); $dvTien = DonViTienBUS::selectId($business[$i]['donvi']); //$array[$i]=array(); $array[$i][0] = $business[$i]["ngay"]; $array[$i][1] = $business[$i]["congviec"]; $array[$i][2] = $user['hoten']; $array[$i][3] = $business[$i]["sotien"] . ' ' . $dvTien['ten']; } // generate file (constructor parameters are optional) ; $xls = new Excel_XML('UTF-8', false, 'Workflow Management'); $xls->setTableHeaderColumn($headerColumn); $xls->setTile("s57", "Thống kê thu chi"); $xls->setAutoData($array); $xls->getXML("Output_Report_WFM"); }
$array[$i][2] = $business[$i]['thoihantin']; switch ($business[$i]['status']) { case 0: $array[$i][3] = "Tin chờ duyệt"; break; case 1: $array[$i][3] = "Tin đã duyệt"; break; case 2: $array[$i][3] = "Tin đăng VIP"; break; case 3: $array[$i][3] = "Tin hết hạn"; break; default: $array[$i][3] = "Tin bị xóa"; break; } $array[$i][4] = $loaidv['ten']; } // load library // generate file (constructor parameters are optional) $xls = new Excel_XML('UTF-8', false, 'Workflow Management'); $xls->setTableHeaderColumn($headerColumn); $xls->setTile("s57", "Thống kê nhà"); $xls->setAutoData($array); $xls->getXML("Output_Report_WFM"); } else { echo HouseProcessor::loadByType($page, -1); } }