function ReportGenerator() { $this->criteria = array(); $this->field = array(); $sysConfObj = new sysConf(); $this->employeeIdLength = $sysConfObj->getEmployeeIdLength(); }
function Users() { $this->sql_builder = new SQLQBuilder(); $this->dbConnection = new DMLFunctions(); $tmpSysConf = new sysConf(); $this->employeeIdLength = $tmpSysConf->getEmployeeIdLength(); }
public function __construct() { $emptyMarker = ReportField::EMPTY_MARKER; $ageQuery = "IF(STRCMP(DATE_FORMAT(hs_hr_employee.`emp_birthday`, CONCAT(YEAR(hs_hr_employee.`emp_birthday`), '-%m-%d')), '0-00-00'), " . "DATE_FORMAT(hs_hr_employee.`emp_birthday`, CONCAT(YEAR(hs_hr_employee.`emp_birthday`), '-%m-%d')), " . "'{$emptyMarker}')"; $sevicePeriodQuery = "IF(STRCMP(DATE_FORMAT(hs_hr_employee.`joined_date`, CONCAT(YEAR(hs_hr_employee.`joined_date`), '-%m-%d')), '0-00-00'), " . "DATE_FORMAT(hs_hr_employee.`joined_date`, CONCAT(YEAR(hs_hr_employee.`joined_date`), '-%m-%d')), " . "'{$emptyMarker}')"; $this->selectionFieldMap = array('EMPNO' => new ReportField('emp_number'), 'EMPFIRSTNAME' => new ReportField('emp_firstname'), 'EMPLASTNAME' => new ReportField('emp_lastname'), 'ADDRESS1' => new ReportField(array('emp_street1', 'emp_street2', 'city_code', 'provin_code', 'coun_code', 'emp_zipcode'), ReportField::COMPOSITE_VALUE), 'TELENO' => new ReportField('emp_hm_telephone'), 'AGE' => new ReportField($ageQuery, ReportField::DIRECT_QUERY), 'REPORTTO' => new ReportField("{CONCAT_WS(' ', eee.`emp_firstname`, eee.`emp_lastname`)}", ReportField::MULTIPLE_REFERENCE, 'hs_hr_emp_reportto', 'erep_sub_emp_number', 'emp_number', new JoinTable('hs_hr_employee', 'emp_number', 'erep_sup_emp_number', 'hs_hr_emp_reportto', 'eee')), 'REPORTINGMETHOD' => new ReportField("{hs_hr_emp_reportto.`erep_reporting_mode`}", ReportField::MULTIPLE_REFERENCE, 'hs_hr_emp_reportto', 'erep_sub_emp_number', 'emp_number'), 'JOBTITLE' => new ReportField('jobtit_name', ReportField::SINGLE_REFERENCE, 'hs_hr_job_title', 'jobtit_code', 'job_title_code'), 'SERPIR' => new ReportField($sevicePeriodQuery, ReportField::DIRECT_QUERY), 'SUBDIVISION' => new ReportField('title', ReportField::SINGLE_REFERENCE, 'hs_hr_compstructtree', 'id', 'work_station'), 'QUL' => new ReportField("{CONCAT_WS(' - ', hs_hr_education.`edu_uni`, hs_hr_education.`edu_deg`)}", ReportField::MULTIPLE_REFERENCE, 'hs_hr_emp_education', 'emp_number', 'emp_number', new JoinTable('hs_hr_education', 'edu_code', 'edu_code', 'hs_hr_emp_education')), 'YEAROFPASSING' => new ReportField("{IF(STRCMP(YEAR(`edu_end_date`), '0'), YEAR(`edu_end_date`), '{$emptyMarker}')}", ReportField::MULTIPLE_REFERENCE, 'hs_hr_emp_education', 'emp_number', 'emp_number'), 'EMPSTATUS' => new ReportField('estat_name', ReportField::MULTIPLE_REFERENCE, 'hs_hr_empstat', 'estat_code', 'emp_status'), 'PAYGRD' => new ReportField('sal_grd_name', ReportField::MULTIPLE_REFERENCE, 'hs_hr_emp_basicsalary', 'emp_number', 'emp_number', new JoinTable('hs_pr_salary_grade', 'sal_grd_code', 'sal_grd_code', 'hs_hr_emp_basicsalary')), 'LANGUAGES' => new ReportField('lang_name', ReportField::MULTIPLE_REFERENCE, 'hs_hr_emp_language', 'emp_number', 'emp_number', new JoinTable('hs_hr_language', 'lang_code', 'lang_code', 'hs_hr_emp_language')), 'SKILLS' => new ReportField('skill_name', ReportField::MULTIPLE_REFERENCE, 'hs_hr_emp_skill', 'emp_number', 'emp_number', new JoinTable('hs_hr_skill', 'skill_code', 'skill_code', 'hs_hr_emp_skill')), 'CONTRACT' => new ReportField("{CONCAT(DATE(`econ_extend_start_date`), ' - ', DATE(`econ_extend_end_date`))}", ReportField::MULTIPLE_REFERENCE, 'hs_hr_emp_contract_extend', 'emp_number', 'emp_number'), 'WORKEXPERIENCE' => new ReportField("{CONCAT(`eexp_employer`, ' - ', `eexp_jobtit`, ' - ',(YEAR(`eexp_to_date`)-YEAR(`eexp_from_date`)), ' Years',' - ',(MONTH(`eexp_to_date`)-MONTH(`eexp_from_date`)),' Months')}", ReportField::MULTIPLE_REFERENCE, 'hs_hr_emp_work_experience', 'emp_number', 'emp_number')); $this->criteria = array(); $this->field = array(); $sysConfObj = new sysConf(); $this->employeeIdLength = $sysConfObj->getEmployeeIdLength(); }
function EmpInfo() { $sysConfObj = new sysConf(); $this->employeeIdLength = $sysConfObj->getEmployeeIdLength(); }
function Login() { $tmpSysConf = new sysConf(); $this->employeeIdLength = $tmpSysConf->getEmployeeIdLength(); }
/** * Constructor * * Serializes the object * */ public function __construct() { $confObj = new EmailConfiguration(); $this->mailType = $confObj->getMailType(); if ($this->mailType == 'smtp') { $config = array(); $authType = $confObj->getSmtpAuth(); if ($authType != EmailConfiguration::EMAILCONFIGURATION_SMTP_AUTH_NONE) { $config['auth'] = strtolower($authType); $config['username'] = trim($confObj->getSmtpUser()); $config['password'] = trim($confObj->getSmtpPass()); } $security = $confObj->getSmtpSecurity(); if ($security != EmailConfiguration::EMAILCONFIGURATION_SMTP_SECURITY_NONE) { $config['ssl'] = strtolower($security); } $config['port'] = trim($confObj->getSmtpPort()); $transport = new Zend_Mail_Transport_Smtp($confObj->getSmtpHost(), $config); } else { if ($this->mailType = 'sendmail') { $transport = new Zend_Mail_Transport_Sendmail(); } } Zend_Mail::setDefaultTransport($transport); $this->mailer = new Zend_Mail(); $this->mailer->setFrom($confObj->getMailAddress(), "OrangeHRM"); $sysConfObj = new sysConf(); $this->employeeIdLength = $sysConfObj->getEmployeeIdLength(); }