本文整理匯總了PHP中Default_Model_Employee::getEstat_emp_excel方法的典型用法代碼示例。如果您正苦於以下問題：PHP Default_Model_Employee::getEstat_emp_excel方法的具體用法？PHP Default_Model_Employee::getEstat_emp_excel怎麽用？PHP Default_Model_Employee::getEstat_emp_excel使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Default_Model_Employee的用法示例。
在下文中一共展示了Default_Model_Employee::getEstat_emp_excel方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: process_emp_excel
public static function process_emp_excel($file_name)
{
require_once 'Classes/PHPExcel.php';
require_once 'Classes/PHPExcel/IOFactory.php';
$auth = Zend_Auth::getInstance();
if ($auth->hasIdentity()) {
$loginUserId = $auth->getStorage()->read()->id;
}
$emp_model = new Default_Model_Employee();
$usersModel = new Default_Model_Usermanagement();
$identity_code_model = new Default_Model_Identitycodes();
$objReader = PHPExcel_IOFactory::createReaderForFile($file_name);
$objPHPExcel = $objReader->load($file_name);
//Read first sheet
$sheet = $objPHPExcel->getSheet(0);
// Get worksheet dimensions
$sizeOfWorksheet = $sheet->getHighestDataRow();
$highestColumn = $sheet->getHighestDataColumn();
if ($sizeOfWorksheet > 1) {
$arrReqHeaders = array('Prefix', 'First name', 'Last name', 'Role Type', 'Email', 'Business Unit', 'Department', 'Reporting manager', 'Job Title', 'Position', 'Employment Status', 'Date of joining', 'Date of leaving', 'Experience', 'Extension', 'Work telephone number', 'Fax');
//Get first/header from excel
$firstRow = $sheet->rangeToArray('A' . 1 . ':' . $highestColumn . 1, NULL, TRUE, TRUE);
$arrGivenHeaders = $firstRow[0];
$diffArray = array_diff_assoc($arrReqHeaders, $arrGivenHeaders);
$prefix_arr = $emp_model->getPrefix_emp_excel();
$roles_arr = $emp_model->getRoles_emp_excel();
$bu_arr = $emp_model->getBU_emp_excel();
$dep_arr = $emp_model->getDep_emp_excel();
$job_arr = $emp_model->getJobs_emp_excel();
$positions_arr = $emp_model->getPositions_emp_excel();
$users_arr = $emp_model->getUsers_emp_excel();
$emp_stat_arr = $emp_model->getEstat_emp_excel();
$dol_emp_stat_arr = $emp_model->getDOLEstat_emp_excel();
$mng_roles_arr = $emp_model->getMngRoles_emp_excel();
$emps_arr = $emp_model->getEmps_emp_excel();
$emails_arr = $emps_arr['email'];
$emp_ids_arr = $emps_arr['ids'];
$emp_depts_arr = $emp_model->getEmpsDeptWise();
$dept_bu_arr = $emp_model->getDeptBUWise();
$pos_jt_arr = $emp_model->getPosJTWise();
$identity_codes = $identity_code_model->getIdentitycodesRecord();
$emp_identity_code = isset($identity_codes[0]) ? $identity_codes[0]['employee_code'] : "";
$trDb = Zend_Db_Table::getDefaultAdapter();
// starting transaction
$trDb->beginTransaction();
try {
//start of validations
$ex_prefix_arr = array();
//$ex_fullname_arr = array();
$ex_firstname_arr = array();
$ex_lastname_arr = array();
$ex_role_arr = array();
$ex_email_arr = array();
$ex_bu_arr = array();
$ex_dep_arr = array();
$ex_rm_arr = array();
$ex_jt_arr = array();
$ex_pos_arr = array();
$ex_es_arr = array();
$ex_doj_arr = array();
$ex_dol_arr = array();
$ex_exp_arr = array();
$ex_ext_arr = array();
$ex_wn_arr = array();
$ex_fax_arr = array();
$tot_rec_cnt = 0;
$err_msg = "";
for ($i = 2; $i <= $sizeOfWorksheet; $i++) {
$rowData_org = $sheet->rangeToArray('A' . $i . ':' . $highestColumn . $i, NULL, TRUE, TRUE);
$rowData = $rowData_org[0];
$rowData_cpy = $rowData;
foreach ($rowData_cpy as $rkey => $rvalue) {
$rowData[$rkey] = trim($rvalue);
}
//start of mandatory checking
if (empty($rowData[0])) {
$err_msg = "Prefix cannot be empty at row " . $i . ".";
break;
}
/* if(empty($rowData[1]))
{
$err_msg = "Full Name cannot be empty at row ".$i.".";
break;
}*/
if (empty($rowData[1])) {
$err_msg = "First name cannot be empty at row " . $i . ".";
break;
}
if (empty($rowData[2])) {
$err_msg = "Last name cannot be empty at row " . $i . ".";
break;
}
if (empty($rowData[3])) {
$err_msg = "Role type cannot be empty at row " . $i . ".";
break;
}
if (empty($rowData[4])) {
$err_msg = "Email cannot be empty at row " . $i . ".";
break;
}
//.........這裏部分代碼省略.........