$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);
}
}
