コード例 #1
0
ファイル: JobTitle.php プロジェクト: noikiy/owaspbwa
 function addJobTitles()
 {
     $tableName = 'HS_HR_JOB_TITLE';
     $this->jobId = UniqueIDGenerator::getInstance()->getNextID($tableName, 'JOBTIT_CODE', 'JOB');
     $arrRecordsList[0] = "'" . $this->getJobId() . "'";
     $arrRecordsList[1] = "'" . $this->getJobName() . "'";
     $arrRecordsList[2] = "'" . $this->getJobDesc() . "'";
     $arrRecordsList[3] = "'" . $this->getJobComm() . "'";
     $arrRecordsList[4] = "'" . $this->getJobSalGrd() . "'";
     $arrRecordsList[5] = isset($this->jobSpecId) ? $this->jobSpecId : 'null';
     $arrFieldList[0] = 'JOBTIT_CODE';
     $arrFieldList[1] = 'JOBTIT_NAME';
     $arrFieldList[2] = 'JOBTIT_DESC';
     $arrFieldList[3] = 'JOBTIT_COMM';
     $arrFieldList[4] = 'SAL_GRD_CODE';
     $arrFieldList[5] = self::DB_FIELD_JOBSPEC_ID;
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrRecordsList;
     $sql_builder->arr_insertfield = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature2();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     $jobTitleEmpStat = new JobTitEmpStat();
     $jobTitleEmpStat->setEmpStatId(EmploymentStatus::EMPLOYMENT_STATUS_ID_TERMINATED);
     $jobTitleEmpStat->setJobTitId($this->getJobId());
     $jobTitleEmpStat->addJobTitEmpStat();
     return $message2;
 }