function display() { $focus = new C_Reports(); global $db; global $app_strings; global $app_list_strings; global $mod_strings; global $currentModule; $ketqua = ''; $export = ''; $file_name = ''; $ss = new Sugar_Smarty(); $ss->assign("APP", $app_strings); $ss->assign("MOD", $mod_strings); $ss->assign('CURRENT_MODULE', $currentModule); $ss->assign('KY', get_select_options($app_list_strings['tinhdiem_ky_dom'], '')); $ss->assign('THANG', get_select_options($app_list_strings['tinhdiem_thang_dom'], '')); $ss->assign('DEPARTMENT', get_select_options($app_list_strings['report_deparment_dom'], 'any')); if ((isset($_REQUEST['tinhdiem']) || isset($_REQUEST['tinhdiemsales']) || isset($_REQUEST['tinhdiemtelesales']) || isset($_REQUEST['xephang']) || isset($_REQUEST['xephangsales']) || isset($_REQUEST['xephangtelesales']) || isset($_REQUEST['export'])) && $_REQUEST['nam'] != '') { ////////////////////////////////////// //Khai bao bien $ds_ketqua = array(); $rate = ''; $type_calculate = ''; $type_value = ''; $start_date = ''; $end_date = ''; $report_type = ''; $check_sale_man = $_REQUEST['check_sale_man']; $sale_man = $_REQUEST['sale_man']; $sale_man_id = $_REQUEST['sale_man_id']; $department = $_REQUEST['department']; if (isset($_REQUEST['report_type'])) { $report_type = $_REQUEST['report_type']; } if (isset($_REQUEST['export'])) { $export = 1; } $ky = $_REQUEST['ky']; $thang = $_REQUEST['thang']; $nam = $_REQUEST['nam']; if ($check_sale_man == '1') { $ss->assign('CHECK_SALE_MAN', 'checked="checked"'); } elseif ($check_sale_man == '0') { $ss->assign('CHECK_SALE_MAN', ''); } $ss->assign('SALE_MAN', $sale_man); $ss->assign('SALE_MAN_ID', $sale_man_id); $ss->assign('KY', get_select_options($app_list_strings['tinhdiem_ky_dom'], $ky)); $ss->assign('THANG', get_select_options($app_list_strings['tinhdiem_thang_dom'], $thang)); $ss->assign('DEPARTMENT', get_select_options($app_list_strings['report_deparment_dom'], $department)); $ss->assign('NAM', $nam); /////////////////////////////////////// // Tinh ngay bat dau va ngay ket thuc de cham diem if (isset($_REQUEST['xephangsales']) || isset($_REQUEST['xephangtelesales']) || isset($_REQUEST['xephang']) || $report_type == 5 || $report_type == 6 || $report_type == 7 || $report_type == 8) { foreach ($thang as $thang_unit) { $start_date[] = $nam . '-' . $thang_unit . '-01'; $end_date[] = date('Y-m-d', strtotime('-1 second', strtotime('+1 month', strtotime($thang_unit . '/01/' . $nam . ' 00:00:00')))); } } else { if ($ky == '1') { foreach ($thang as $thang_unit) { $start_date[] = $nam . '-' . $thang_unit . '-01'; $end_date[] = $nam . '-' . $thang_unit . '-16'; } } else { foreach ($thang as $thang_unit) { $start_date[] = $nam . '-' . $thang_unit . '-16'; $end_date[] = date('Y-m-d', strtotime('-1 second', strtotime('+1 month', strtotime($thang_unit . '/01/' . $nam . ' 00:00:00')))); } } } //////////////////////////////////////// // Lay ket qua if (isset($_REQUEST['tinhdiemtelesales']) || $report_type == 1 && $export == 1) { if ($report_type != 1) { $report_type = 1; } $ketqua = $focus->getDanhSachDiemCuaNhanVienTeleSale($app_strings, $mod_strings, $ds_ketqua, $start_date, $end_date, $sale_man_id, $department, null, $export, $report_type); $type_value = 1; $type_calculate = $mod_strings['LBL_TINH_DIEM_TELESALES']; } elseif (isset($_REQUEST['tinhdiemsales']) || $report_type == 2 && $export == 1) { if ($report_type != 2) { $report_type = 2; } $ketqua = $focus->getDanhSachDiemCuaNhanVienSale($app_strings, $mod_strings, $ds_ketqua, $start_date, $end_date, $sale_man_id, $department, null, $export, $report_type); $type_value = 2; $type_calculate = $mod_strings['LBL_TINH_DIEM_SALES']; } elseif (isset($_REQUEST['tinhdiem']) || ($report_type == 3 || $report_type == 4) && $export == 1) { $user = new User(); $user->retrieve($sale_man_id); if ($user->type_sale == 'telesales' || $report_type == 3) { if ($report_type != 3) { $report_type = 3; } $ketqua = $focus->getDanhSachDiemCuaNhanVienTeleSale($app_strings, $mod_strings, $ds_ketqua, $start_date, $end_date, $sale_man_id, $department, null, $export, $report_type); $type_value = 1; $type_calculate = $mod_strings['LBL_TINH_DIEM_TELESALES'] . ' ' . $user->last_name; } elseif ($user->type_sale == 'sales' || $report_type == 4) { if ($report_type != 4) { $report_type = 4; } $ketqua = $focus->getDanhSachDiemCuaNhanVienSale($app_strings, $mod_strings, $ds_ketqua, $start_date, $end_date, $sale_man_id, $department, null, $export, $report_type); $type_value = 2; $type_calculate = $mod_strings['LBL_TINH_DIEM_SALES'] . ' ' . $user->last_name; } } elseif (isset($_REQUEST['xephangtelesales']) || $report_type == 5 && $export == 1) { if ($report_type != 5) { $report_type = 5; } $ketqua = $focus->getDanhSachDiemCuaNhanVienTeleSale($app_strings, $mod_strings, $ds_ketqua, $start_date, $end_date, $sale_man_id, $department, 1, $export, $report_type); $type_value = 1; $rate = 1; $type_calculate = $mod_strings['LBL_XEP_HANG_TELESALES']; } elseif (isset($_REQUEST['xephangsales']) || $report_type == 6 && $export == 1) { if ($report_type != 6) { $report_type = 6; } $ketqua = $focus->getDanhSachDiemCuaNhanVienSale($app_strings, $mod_strings, $ds_ketqua, $start_date, $end_date, $sale_man_id, $department, 1, $export, $report_type); $type_value = 2; $rate = 1; $type_calculate = $mod_strings['LBL_XEP_HANG_SALES']; } elseif (isset($_REQUEST['xephang']) || ($report_type == 7 || $report_type == 8) && $export == 1) { $user = new User(); $user->retrieve($sale_man_id); if ($user->type_sale == 'telesales' || $report_type == 7) { if ($report_type != 7) { $report_type = 7; } $ketqua = $focus->getDanhSachDiemCuaNhanVienTeleSale($app_strings, $mod_strings, $ds_ketqua, $start_date, $end_date, $sale_man_id, $department, 1, $export, $report_type); $type_value = 1; $type_calculate = $mod_strings['LBL_XEP_HANG_TELESALES'] . ' ' . $user->last_name; } elseif ($user->type_sale == 'sales' || $report_type == 8) { if ($report_type != 8) { $report_type = 8; } $ketqua = $focus->getDanhSachDiemCuaNhanVienSale($app_strings, $mod_strings, $ds_ketqua, $start_date, $end_date, $sale_man_id, $department, 1, $export, $report_type); $type_value = 2; $type_calculate = $mod_strings['LBL_XEP_HANG_SALES'] . ' ' . $user->last_name; } $rate = 1; } ///////////////////////////////////////////// // Kiem tra ky de chinh lai end_date, chinh lai thanh ngay 15. // Tuy chinh giao dien ben ngoai cho phu hop voi loai tinh diem. if ($ky == '1' && !isset($_REQUEST['xephangtelesales']) && !isset($_REQUEST['xephangsales']) && !isset($_REQUEST['xephang']) && $report_type != 5 && $report_type != 6 && $report_type != 7 && $report_type != 8) { $end_date_temp = explode('-', $end_date); $end_date_temp[2] -= 1; $end_date = $end_date_temp[0] . '-' . $end_date_temp[1] . '-' . $end_date_temp[2]; } $file_name = $type_calculate; // $type_calculate .= $mod_strings['LBL_START_DATE'].'<font color=red>'.date('d-m-Y',strtotime($start_date)).'</font>'.$mod_strings['LBL_END_DATE'].'<font color=red>'.date('d-m-Y',strtotime($end_date)).'</font>' ; // $ss->assign('TYPE_CALCULATE',$type_calculate); $ss->assign('TYPE_VALUE', $type_value); $ss->assign('RATE', $rate); if ($ketqua == '') { $ketqua = '<tr><td colspan="16">' . $mod_strings['LBL_NODATA'] . '</td></tr>'; } //////////////////////////////////////////////// } else { /////////////////////////////////////////////// // Neu khong co du lieu $ketqua = '<tr><td colspan="16">' . $mod_strings['LBL_NODATA'] . '</td></tr>'; } /** * Kiem tra kieu du lieu : * 1. View Table * 2. File Excel */ if ($export != 1) { $ss->assign('KETQUA', $ketqua); $ss->display("modules/C_Reports/tpls/tinhdiemnhanvien.tpl"); } else { /** * Export To Excel: */ if ($report_type == 1 || $report_type == 3) { $temp = file_get_contents("modules/C_Reports/tpls/FormExport_Telesales_files/sheet001.htm"); } elseif ($report_type == 2 || $report_type == 4) { $temp = file_get_contents("modules/C_Reports/tpls/FormExport_Sales_files/sheet001.htm"); } elseif ($report_type == 5 || $report_type == 7) { $temp = file_get_contents("modules/C_Reports/tpls/FormExport_Telesales_XepHang_files/sheet001.htm"); } elseif ($report_type == 6 || $report_type == 8) { $temp = file_get_contents("modules/C_Reports/tpls/FormExport_Sales_XepHang_files/sheet001.htm"); } $temp = str_replace('{TITLE}', $mod_strings['LBL_TITLE'], $temp); $temp = str_replace('{LBL_STT}', $mod_strings['LBL_STT'], $temp); $temp = str_replace('{LBL_SALE_NAME}', $mod_strings['LBL_SALE_NAME'], $temp); $temp = str_replace('{LBL_PHONGBAN}', $mod_strings['LBL_PHONGBAN'], $temp); $temp = str_replace('{LBL_LIST}', $mod_strings['LBL_LIST'], $temp); $temp = str_replace('{LBL_LEADS}', $mod_strings['LBL_LEADS'], $temp); $temp = str_replace('{LBL_ACCOUNT}', $mod_strings['LBL_ACCOUNT'], $temp); $temp = str_replace('{LBL_SUCCESS}', $mod_strings['LBL_SUCCESS'], $temp); $temp = str_replace('{LBL_TOTAL}', $mod_strings['LBL_TOTAL'], $temp); $temp = str_replace('{LBL_QUANTITY}', $mod_strings['LBL_QUANTITY'], $temp); $temp = str_replace('{LBL_SCORE}', $mod_strings['LBL_SCORE'], $temp); $temp = str_replace('{LBL_SCORE2}', $mod_strings['LBL_SCORE2'], $temp); $temp = str_replace('{LBL_SCOREx2}', $mod_strings['LBL_SCOREx2'], $temp); $temp = str_replace('{LBL_CUSTOMERS}', $mod_strings['LBL_CUSTOMERS'], $temp); $temp = str_replace('{LBL_KHACHMOI}', $mod_strings['LBL_KHACHMOI'], $temp); $temp = str_replace('{LBL_KHACHCU}', $mod_strings['LBL_KHACHCU'], $temp); $temp = str_replace('{LBL_TYLE}', $mod_strings['LBL_TYLE'], $temp); $temp = str_replace('{LBL_RAKING}', $mod_strings['LBL_RAKING'], $temp); $temp = str_replace('{LBL_KETQUA}', $mod_strings['LBL_KETQUA'], $temp); $temp = str_replace('{TYPE_CALCULATE}', $type_calculate, $temp); $temp = str_replace('{KETQUA}', $ketqua, $temp); ob_clean(); header("Pragma: cache"); $temp = chr(255) . chr(254) . mb_convert_encoding($temp, "UTF-16LE", "UTF-8"); header("Content-type: application/x-msdownload"); header("Content-disposition: xls; filename=" . $mod_strings['LBL_FILENAME'] . "_" . $file_name . ".xls; size=" . strlen($temp)); echo $temp; exit; } }