PHP SQLQBuilder::addNewRecordFeature1方法代码示例

 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;
 }

 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;
 }

 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;
 }

 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;
 }

 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;
 }

 /**
  *
  */
 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;
 }

 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;
 }

 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;
 }

 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;
 }

 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;
 }