Example #1
0
 function addJobTitEmpStat()
 {
     $arrFieldList[0] = "'" . $this->getJobTitId() . "'";
     $arrFieldList[1] = "'" . $this->getEmpStatId() . "'";
     $tableName = 'HS_HR_JOBTIT_EMPSTAT';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
 }
Example #2
0
 function addRepUserGroup()
 {
     $arrFieldList[0] = "'" . $this->getUserGroupID() . "'";
     $arrFieldList[1] = "'" . $this->getRepCode() . "'";
     $tableName = 'HS_HR_EMPREP_USERGROUP';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
     echo $message2;
 }
 /**
  * Add new project
  *
  * Deleted will be overwritten to NOT_DELETED
  */
 public function addProject()
 {
     if ($this->_isDuplicateName()) {
         throw new ProjectsException("Duplicate name", 1);
     }
     $this->projectID = UniqueIDGenerator::getInstance()->getNextID(self::TABLE_NAME, self::PROJECT_DB_FIELD_PROJECT_ID);
     $arrRecord[0] = "'" . $this->getProjectId() . "'";
     $arrRecord[1] = "'" . $this->getCustomerId() . "'";
     $arrRecord[2] = "'" . $this->getProjectName() . "'";
     $arrRecord[3] = "'" . $this->getProjectDescription() . "'";
     $arrRecord[4] = self::PROJECT_NOT_DELETED;
     $tableName = self::TABLE_NAME;
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrRecord;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     if ($message2 && mysql_affected_rows() > 0) {
         return true;
     }
     return false;
 }
 function addEmpStat()
 {
     $tableName = 'HS_HR_EMPSTAT';
     $this->empStatId = UniqueIDGenerator::getInstance()->getNextID($tableName, 'ESTAT_CODE', 'EST');
     $arrFieldList[0] = "'" . $this->getEmpStatId() . "'";
     $arrFieldList[1] = "'" . $this->getEmpStatName() . "'";
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
 }
 function addEmpPic()
 {
     $dbConnection = new DMLFunctions();
     $this->_escapeFields();
     $arrFieldList[0] = "'" . $this->getEmpId() . "'";
     $arrFieldList[1] = "'" . $this->getEmpPicture() . "'";
     $arrFieldList[2] = "'" . $this->getEmpFilename() . "'";
     $arrFieldList[3] = "'" . $this->getEmpPicType() . "'";
     $arrFieldList[4] = "'" . $this->getEmpPicSize() . "'";
     $tableName = 'HS_HR_EMP_PICTURE';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     /* We pass false to $quoteCorrect field, since it can corrupt the picture binary data */
     $sqlQString = $sql_builder->addNewRecordFeature1(false);
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
 }
 function addMembershipInfo()
 {
     if ($this->_isDuplicateName()) {
         throw new MembershipInfoException("Duplicate name", 1);
     }
     $tableName = 'hs_hr_membership';
     $this->membershipId = UniqueIDGenerator::getInstance()->getNextID($tableName, 'membship_code', 'MME');
     $arrFieldList[0] = "'" . $this->getMembershipInfoId() . "'";
     $arrFieldList[1] = "'" . $this->getMembershipTypeId() . "'";
     $arrFieldList[2] = "'" . $this->getMembershipInfoDesc() . "'";
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
 }
Example #7
0
 function addEmpSkill()
 {
     $this->getEmpId();
     $arrFieldList[0] = "'" . $this->getEmpId() . "'";
     $arrFieldList[1] = "'" . $this->getEmpSkillCode() . "'";
     $arrFieldList[2] = "'" . $this->getEmpYearsOfExp() . "'";
     $arrFieldList[3] = "'" . $this->getEmpComments() . "'";
     $tableName = 'HS_HR_EMP_SKILL';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
 }
Example #8
0
 function addEducation()
 {
     $tableName = 'hs_hr_education';
     $this->eduId = UniqueIDGenerator::getInstance()->getNextID($tableName, 'edu_code', 'EDU');
     $arrFieldList[0] = "'" . $this->getEduId() . "'";
     $arrFieldList[1] = "'" . $this->getEduUni() . "'";
     $arrFieldList[2] = "'" . $this->getEduDeg() . "'";
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
     echo $message2;
 }
Example #9
0
 function addEmpPP()
 {
     $this->getEmpId();
     $arrFieldList[0] = "'" . $this->getEmpId() . "'";
     $arrFieldList[1] = "'" . $this->getEmpPPSeqNo() . "'";
     $arrFieldList[2] = "'" . $this->getEmpPPNo() . "'";
     $arrFieldList[3] = $this->getEmpPPIssDat();
     // Quotes removed to accept null values
     $arrFieldList[4] = $this->getEmpPPExpDat();
     $arrFieldList[5] = "'" . $this->getEmpPPComment() . "'";
     $arrFieldList[6] = "'" . $this->getEmppassportflag() . "'";
     $arrFieldList[7] = "'" . $this->getEmpI9Status() . "'";
     $arrFieldList[8] = $this->getEmpI9ReviewDat();
     $arrFieldList[9] = "'" . $this->getEmpNationality() . "'";
     $tableName = 'HS_HR_EMP_PASSPORT';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     //$logw = new LogFileWriter();
     //$logw->writeLogDB($sqlQString);
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
     echo $message2;
 }
Example #10
0
 /**
  *
  */
 public function addCustomer()
 {
     if ($this->_isDuplicateName()) {
         throw new CustomerException("Duplicate name", 1);
     }
     $this->customerId = UniqueIDGenerator::getInstance()->getNextID(self::TABLE_NAME, self::CUSTOMER_DB_FIELDS_ID);
     $arrRecord[0] = "'" . $this->getCustomerId() . "'";
     $arrRecord[1] = "'" . $this->getCustomerName() . "'";
     $arrRecord[2] = "'" . $this->getCustomerDescription() . "'";
     $arrRecord[3] = self::CUSTOMER_NOT_DELETED;
     $tableName = self::TABLE_NAME;
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrRecord;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
 }
 function addEthnicRace()
 {
     if ($this->_isDuplicateName()) {
         throw new EthnicaRaceException("Duplicate name", 1);
     }
     $tableName = 'hs_hr_ethnic_race';
     $this->ethnicrace = UniqueIDGenerator::getInstance()->getNextID($tableName, 'ethnic_race_code', 'ETH');
     $arrFieldList[0] = "'" . $this->getethnicrace() . "'";
     $arrFieldList[1] = "'" . $this->getethnicraceDescription() . "'";
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
 }
Example #12
0
 function addEmpJobSpec()
 {
     $this->getEmpId();
     $arrFieldList[0] = "'" . $this->getEmpId() . "'";
     $arrFieldList[1] = "'" . $this->getEmpJDCatCode() . "'";
     $arrFieldList[2] = "'" . $this->getEmpJobSpecAtt() . "'";
     $tableName = 'HS_HR_EMP_JOBSPEC';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
     echo $message2;
 }
Example #13
0
 function addEmpQual()
 {
     $this->getEmpId();
     $arrFieldList[0] = "'" . $this->getEmpQualId() . "'";
     $arrFieldList[1] = "'" . $this->getEmpId() . "'";
     $arrFieldList[2] = "'" . $this->getEmpQualInst() . "'";
     $arrFieldList[3] = "'" . $this->getEmpQualYear() . "'";
     $arrFieldList[4] = "'" . $this->getEmpQualStat() . "'";
     $arrFieldList[5] = "'" . $this->getEmpQualComment() . "'";
     $tableName = 'HS_HR_EMP_QUALIFICATION';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
     echo $message2;
 }
Example #14
0
 function addReport()
 {
     $tableName = 'HS_HR_EMPREPORT';
     $this->repID = UniqueIDGenerator::getInstance()->getNextID($tableName, 'REP_CODE', 'REP');
     $arrFieldList[0] = "'" . $this->getRepID() . "'";
     $arrFieldList[1] = "'" . $this->getRepName() . "'";
     $arrFieldList[2] = "'" . $this->getRepCriteriaDefString() . "'";
     $arrFieldList[3] = "'" . $this->getRepFieldDefString() . "'";
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
 }
Example #15
0
 function addEmpEC()
 {
     $this->getEmpId();
     $arrFieldList[0] = "'" . $this->getEmpId() . "'";
     $arrFieldList[1] = "'" . $this->getEmpECSeqNo() . "'";
     $arrFieldList[2] = "'" . $this->getEmpEConName() . "'";
     $arrFieldList[3] = "'" . $this->getEmpEConRel() . "'";
     $arrFieldList[4] = "'" . $this->getEmpEConHmTel() . "'";
     $arrFieldList[5] = "'" . $this->getEmpEConMobile() . "'";
     $arrFieldList[6] = "'" . $this->getEmpEConWorkTel() . "'";
     $tableName = 'HS_HR_EMP_EMERGENCY_CONTACTS';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     /*$logw = new LogFileWriter();
     	$logw->writeLogDB($sqlQString);*/
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
     echo $message2;
 }
Example #16
0
 function addEmpAtt()
 {
     $this->getEmpId();
     $arrFieldList[0] = "'" . $this->getEmpId() . "'";
     $arrFieldList[1] = "'" . $this->getEmpAttId() . "'";
     $arrFieldList[2] = "'" . $this->getEmpAttDesc() . "'";
     $arrFieldList[3] = "'" . $this->getEmpAttFilename() . "'";
     $arrFieldList[4] = "'" . $this->getEmpAttSize() . "'";
     $arrFieldList[5] = "'" . $this->getEmpAttachment() . "'";
     $arrFieldList[6] = "'" . $this->getEmpAttType() . "'";
     $tableName = 'HS_HR_EMP_ATTACHMENT';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1(false);
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
 }
Example #17
0
 function addSalaryGrades()
 {
     $tableName = 'HS_PR_SALARY_GRADE';
     $this->salgrdId = UniqueIDGenerator::getInstance()->getNextID($tableName, 'SAL_GRD_CODE', 'SAL');
     $arrFieldList[0] = "'" . $this->getSalGrdId() . "'";
     $arrFieldList[1] = "'" . $this->getSalGrdDesc() . "'";
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     $dbConnection = new DMLFunctions();
     $message = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     if ($message) {
         return $message;
     } else {
         $errCode = mysql_errno();
         switch ($errCode) {
             case 1062:
                 $e = new SalaryGradesException('Pay Grades cannot have duplicate names', SalaryGradesException::DUPLICATE_SALARY_GRADE);
                 break;
             default:
                 $e = new SalaryGradesException('Unknown error in when adding Pay Grades', SalaryGradesException::UNKNOWN_EXCEPTION);
                 break;
         }
         throw $e;
     }
 }
Example #18
0
 function addEmpMembership()
 {
     $this->getEmpId();
     $arrFieldList[0] = "'" . $this->getEmpId() . "'";
     $arrFieldList[1] = "'" . $this->getEmpMemCode() . "'";
     $arrFieldList[2] = "'" . $this->getEmpMemTypeCode() . "'";
     $arrFieldList[3] = "'" . $this->getEmpMemSubOwn() . "'";
     $arrFieldList[4] = "'" . $this->getEmpMemSubAmount() . "'";
     $arrFieldList[5] = $this->getEmpMemCommDat();
     // Quotes removed to accept null values
     $arrFieldList[6] = $this->getEmpMemRenDat();
     $tableName = 'HS_HR_EMP_MEMBER_DETAIL';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
     echo $message2;
 }
Example #19
0
 function addEmpLicenses()
 {
     $this->getEmpId();
     $arrFieldList[0] = "'" . $this->getEmpId() . "'";
     $arrFieldList[1] = "'" . $this->getEmpLicCode() . "'";
     $arrFieldList[2] = $this->getempLicDat();
     // Quotes removed to accept null values
     $arrFieldList[3] = $this->getempLicrenewalDat();
     $tableName = 'HS_HR_EMP_LICENSES';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     //echo $sqlQString;
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
     echo $message2;
 }
Example #20
0
 function addLocation()
 {
     $tableName = 'HS_HR_LOCATION';
     $this->locationId = UniqueIDGenerator::getInstance()->getNextID($tableName, 'LOC_CODE', 'LOC');
     $arrFieldList[0] = "'" . $this->getLocationId() . "'";
     $arrFieldList[1] = "'" . $this->getLocationName() . "'";
     $arrFieldList[2] = "'" . $this->getLocationCountry() . "'";
     $arrFieldList[3] = "'" . $this->getLocationState() . "'";
     $arrFieldList[4] = "'" . $this->getLocationCity() . "'";
     $arrFieldList[5] = "'" . $this->getLocationAddress() . "'";
     $arrFieldList[6] = "'" . $this->getLocationZIP() . "'";
     $arrFieldList[7] = "'" . $this->getLocationPhone() . "'";
     $arrFieldList[8] = "'" . $this->getLocationFax() . "'";
     $arrFieldList[9] = "'" . $this->getLocationComments() . "'";
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
     echo $message2;
 }
Example #21
0
 function addEmpDep()
 {
     //$this->getEmpId();
     $arrFieldList[0] = "'" . $this->getEmpId() . "'";
     $arrFieldList[1] = "'" . $this->getEmpDSeqNo() . "'";
     $arrFieldList[2] = "'" . mysql_real_escape_string($this->getEmpDepName()) . "'";
     $arrFieldList[3] = "'" . mysql_real_escape_string($this->getEmpDepRel()) . "'";
     $tableName = 'HS_HR_EMP_DEPENDENTS';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = "";
     $sqlQString = $sql_builder->addNewRecordFeature1();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
 }
 function addEEOJobCat()
 {
     if ($this->_isDuplicateName()) {
         throw new EEOJobCatException("Duplicate name", 1);
     }
     $tableName = 'HS_HR_EEC';
     $this->eeojobcatId = UniqueIDGenerator::getInstance()->getNextID($tableName, 'EEC_CODE', 'EEC');
     $arrFieldList[0] = "'" . $this->getEEOJobCatId() . "'";
     $arrFieldList[1] = "'" . $this->getEEOJobCatDesc() . "'";
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
 }
Example #23
0
 function addEmpEducation()
 {
     $arrFieldList[0] = "'" . $this->getEmpID() . "'";
     $arrFieldList[1] = "'" . $this->getEduCode() . "'";
     $arrFieldList[2] = "'" . $this->getEduMajor() . "'";
     $arrFieldList[3] = "'" . $this->getEduYear() . "'";
     $arrFieldList[4] = "'" . $this->getEduGPA() . "'";
     $arrFieldList[5] = $this->getEduStartDate();
     // Quotes removed to accept null values
     $arrFieldList[6] = $this->getEduEndDate();
     $tableName = 'HS_HR_EMP_EDUCATION';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
 }
Example #24
0
 function addEmpWorkExp()
 {
     $arrFieldList[0] = "'" . $this->getEmpId() . "'";
     $arrFieldList[1] = "'" . $this->getEmpExpSeqNo() . "'";
     $arrFieldList[2] = "'" . $this->getEmpExpEmployer() . "'";
     $arrFieldList[3] = "'" . $this->getEmpExpJobTitle() . "'";
     $arrFieldList[4] = $this->getEmpExpFromDate();
     // Quotes removed to allow null values
     $arrFieldList[5] = $this->getEmpExpToDate();
     $arrFieldList[6] = "'" . $this->getEmpExpComments() . "'";
     $arrFieldList[7] = "'" . $this->getEmpExpInternal() . "'";
     $tableName = 'HS_HR_EMP_WORK_EXPERIENCE';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
     echo $message2;
 }
 function addConExt()
 {
     $this->getEmpId();
     $arrFieldList[0] = "'" . $this->getEmpId() . "'";
     $arrFieldList[1] = "'" . $this->getEmpConExtId() . "'";
     $arrFieldList[2] = $this->getEmpConExtStartDat();
     // Quotes were removed to allow null values.
     $arrFieldList[3] = $this->getEmpConExtEndDat();
     $tableName = 'HS_HR_EMP_CONTRACT_EXTEND';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
     echo $message2;
 }
Example #26
0
 function addEmpChi()
 {
     $this->getEmpId();
     $arrFieldList[0] = "'" . $this->getEmpId() . "'";
     $arrFieldList[1] = "'" . $this->getEmpCSeqNo() . "'";
     $arrFieldList[2] = "'" . $this->getEmpChiName() . "'";
     $arrFieldList[3] = $this->getEmpDOB();
     // Quotes removed to accept null values
     $tableName = 'HS_HR_EMP_CHILDREN';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_insert = 'true';
     $sql_builder->arr_insert = $arrFieldList;
     $sqlQString = $sql_builder->addNewRecordFeature1();
     //$logw = new LogFileWriter();
     //$logw->writeLogDB($sqlQString.'hhh');
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
     echo $message2;
 }