コード例 #1
0
 function reDirect($getArr, $postArr, $object = null)
 {
     $form_creator = new FormCreator($getArr, $postArr);
     if ($_SESSION['isAdmin'] !== 'Yes') {
         trigger_error("Unauthorized access", E_USER_NOTICE);
     }
     switch ($getArr['repcode']) {
         case 'EMPDEF':
             //if ()
             $form_creator->formPath = '/templates/report/emprepinfo.php';
             $form_creator->popArr['arrAgeSim'] = array('Less Than' => '>', 'Greater Than' => '<', 'Range' => 'range');
             //$form_creator->popArr['arrEmpType']= array( 'Permanent', 'Expatriate', 'Contract', 'Temporary' , 'Others');
             $form_creator->popArr['arrSerPer'] = array('Less Than' => '>', 'Greater Than' => '<', 'Range' => 'range');
             $form_creator->popArr['arrJoiDat'] = array('Joined After' => '>', 'Joined Before' => '<', 'Joined In Between' => 'range');
             $report = new EmpReport();
             $empinfo = new EmpInfo();
             $edu = new Education();
             $jobtit = new JobTitle();
             $salgrd = new SalaryGrades();
             $empstat = new EmploymentStatus();
             $langObj = new LanguageInfo();
             $skillObj = new Skills();
             $form_creator->popArr['grdlist'] = $salgrd->getSalGrdCodes();
             $form_creator->popArr['edulist'] = $edu->getAllEducation();
             $form_creator->popArr['deslist'] = $jobtit->getJobTit();
             $form_creator->popArr['arrEmpType'] = $empstat->getEmpStat();
             $form_creator->popArr['languageList'] = $langObj->getLang();
             $form_creator->popArr['skillList'] = $skillObj->getSkillCodes();
             if ($getArr['capturemode'] == 'updatemode') {
                 $form_creator->popArr['editArr'] = $edit = $report->filterReport($getArr['id']);
                 $criteria_value = explode('|', $edit[0][2]);
                 for ($c = 0; count($criteria_value) > $c; $c++) {
                     $crit_data = explode("=", $criteria_value[$c]);
                     $criteriaChkBox[$c] = $crit_data[0];
                     for ($d = 1; count($crit_data) > $d; $d++) {
                         $crit_form_data[$crit_data[0]][$d - 1] = $crit_data[$d];
                     }
                 }
                 $form_creator->popArr['editCriteriaChk'] = $criteriaChkBox;
                 $form_creator->popArr['editCriteriaData'] = $crit_form_data;
                 $form_creator->popArr['fieldList'] = explode('|', $edit[0][3]);
             }
             if ($object != null) {
                 $form_creator->popArr['empqual'] = $empqual->getQualifications($object->TypeCode);
             }
             break;
         case 'EMPVIEW':
             $report = new EmpReport();
             $repgen = new ReportGenerator();
             $edit = $report->filterReport($getArr['id']);
             $repgen->reportId = $edit[0][0];
             /* TODO: The following actions should be moved to model class */
             $criteria = explode('|', $edit[0][2]);
             $criteriaCount = count($criteria);
             for ($c = 0; $criteriaCount > $c; $c++) {
                 $crit_value = explode("=", $criteria[$c]);
                 $repgen->setCriteria($crit_value[0], '');
                 $criteriaValueCount = count($crit_value);
                 for ($d = 1; $criteriaValueCount > $d; $d++) {
                     if ($d == count($crit_value) - 1) {
                         $repgen->setCriteria($crit_value[0], $crit_value[$d], true);
                     } else {
                         $repgen->setCriteria($crit_value[0], $crit_value[$d] . "|", true);
                     }
                 }
             }
             $field = explode('|', $edit[0][3]);
             $fieldCount = count($field);
             for ($c = 0; $fieldCount > $c; $c++) {
                 $repgen->setField($field[$c], 1);
             }
             $sqlQ = $repgen->buildReportQuery();
             $arrayDispList = $repgen->buildDisplayList($sqlQ);
             $employee = array();
             if (is_array($arrayDispList)) {
                 $employee = current($arrayDispList);
             }
             $columns = count($employee);
             $rows = count($arrayDispList);
             $objs['reportName'] = $edit[0][1];
             $objs['arrayDispList'] = $arrayDispList;
             $objs['headerNames'] = $repgen->getHeaders();
             $objs['replacements'] = array('directReportingMode' => EmpRepTo::REPORTING_MODE_DIRECT, 'indirectReportingMode' => EmpRepTo::REPORTING_MODE_INDIRECT);
             $templatePath = '/templates/report/report.php';
             $template = new TemplateMerger($objs, $templatePath, null, null);
             $template->display();
             return;
             break;
         case 'RUG':
             $form_creator->formPath = '/templates/report/repusg.php';
             $report = new EmpReport();
             $emprepgroup = new EmpRepUserGroup();
             $form_creator->popArr['report'] = $report->filterReport($getArr['id']);
             $form_creator->popArr['usgAll'] = $emprepgroup->getAllUserGroups();
             $form_creator->popArr['repUsgAss'] = $emprepgroup->getAssignedUserGroup($getArr['id']);
             $form_creator->popArr['usgUnAss'] = $emprepgroup->getUnAssUserGroups($getArr['id']);
             break;
     }
     $form_creator->display();
 }
コード例 #2
0
ファイル: RepViewController.php プロジェクト: noikiy/owaspbwa
 function reDirect($getArr, $postArr, $object = null)
 {
     $form_creator = new FormCreator($getArr, $postArr);
     if ($_SESSION['isAdmin'] !== 'Yes') {
         trigger_error("Unauthorized access", E_USER_NOTICE);
     }
     switch ($getArr['repcode']) {
         case 'EMPDEF':
             //if ()
             $form_creator->formPath = '/templates/report/emprepinfo.php';
             $form_creator->popArr['arrAgeSim'] = array('Less Than' => '>', 'Greater Than' => '<', 'Range' => 'range');
             //$form_creator->popArr['arrEmpType']= array( 'Permanent', 'Expatriate', 'Contract', 'Temporary' , 'Others');
             $form_creator->popArr['arrSerPer'] = array('Less Than' => '>', 'Greater Than' => '<', 'Range' => 'range');
             $form_creator->popArr['arrJoiDat'] = array('Joined After' => '>', 'Joined Before' => '<', 'Joined In Between' => 'range');
             $report = new EmpReport();
             $empinfo = new EmpInfo();
             $edu = new Education();
             $jobtit = new JobTitle();
             $salgrd = new SalaryGrades();
             $empstat = new EmploymentStatus();
             $langObj = new LanguageInfo();
             $skillObj = new Skills();
             $form_creator->popArr['grdlist'] = $salgrd->getSalGrdCodes();
             $form_creator->popArr['edulist'] = $edu->getAllEducation();
             $form_creator->popArr['deslist'] = $jobtit->getJobTit();
             $form_creator->popArr['arrEmpType'] = $empstat->getEmpStat();
             $form_creator->popArr['languageList'] = $langObj->getLang();
             $form_creator->popArr['skillList'] = $skillObj->getSkillCodes();
             if ($getArr['capturemode'] == 'updatemode') {
                 $form_creator->popArr['editArr'] = $edit = $report->filterReport($getArr['id']);
                 $criteria_value = explode('|', $edit[0][2]);
                 for ($c = 0; count($criteria_value) > $c; $c++) {
                     $crit_data = explode("=", $criteria_value[$c]);
                     $criteriaChkBox[$c] = $crit_data[0];
                     for ($d = 1; count($crit_data) > $d; $d++) {
                         $crit_form_data[$crit_data[0]][$d - 1] = $crit_data[$d];
                     }
                 }
                 $form_creator->popArr['editCriteriaChk'] = $criteriaChkBox;
                 $form_creator->popArr['editCriteriaData'] = $crit_form_data;
                 $form_creator->popArr['fieldList'] = explode('|', $edit[0][3]);
             }
             if ($object != null) {
                 $form_creator->popArr['empqual'] = $empqual->getQualifications($object->TypeCode);
             }
             break;
         case 'EMPVIEW':
             $report = new EmpReport();
             $repgen = new ReportGenerator();
             $form_creator->popArr['editArr'] = $edit = $report->filterReport($getArr['id']);
             $repgen->repID = $edit[0][0];
             $repgen->repName = $edit[0][1];
             $criteria = explode('|', $edit[0][2]);
             for ($c = 0; count($criteria) > $c; $c++) {
                 $crit_value = explode("=", $criteria[$c]);
                 $repgen->criteria[$crit_value[0]] = '';
                 for ($d = 1; count($crit_value) > $d; $d++) {
                     if ($d == count($crit_value) - 1) {
                         $repgen->criteria[$crit_value[0]] .= $crit_value[$d];
                     } else {
                         $repgen->criteria[$crit_value[0]] .= $crit_value[$d] . "|";
                     }
                 }
             }
             $field = explode('|', $edit[0][3]);
             $empNoField = false;
             for ($c = 0; count($field) > $c; $c++) {
                 $repgen->field[$field[$c]] = 1;
                 if ($field[$c] == 'EMPNO') {
                     $empNoField = true;
                 }
             }
             $repgen->field['EMPNO'] = 1;
             $sqlQ = $repgen->reportQueryBuilder();
             //echo $sqlQ."<br/>";
             $dbConnection = new DMLFunctions();
             $message2 = $dbConnection->executeQuery($sqlQ);
             $i = 0;
             while ($line = mysql_fetch_array($message2, MYSQL_NUM)) {
                 for ($c = 0; count($repgen->field) * 2 > $c; $c += 2) {
                     $arrayDispList[$line[0]][$c / 2][$line[$c]] = $line[$c + 1];
                 }
                 $i++;
             }
             //print_r($arrayDispList);
             if (!isset($arrayDispList)) {
                 $arrayDispList = null;
             }
             $repgen->reportDisplay($arrayDispList, $empNoField);
             return;
             break;
         case 'RUG':
             $form_creator->formPath = '/templates/report/repusg.php';
             $emprepgroup = new EmpRepUserGroup();
             $form_creator->popArr['repDet'] = $emprepgroup->getReportInfo();
             $form_creator->popArr['usgAll'] = $emprepgroup->getAllUserGroups();
             $form_creator->popArr['repUsgAss'] = $emprepgroup->getAssignedUserGroup($getArr['id']);
             $form_creator->popArr['usgUnAss'] = $emprepgroup->getUnAssUserGroups($getArr['id']);
             break;
     }
     $form_creator->display();
 }