PHP SQLQBuilder::deleteRecord Examples

Example #1

File: EmpPhoto.php Project: noikiy/owaspbwa

 function delEmpPic($arrList)
 {
     $tableName = 'HS_HR_EMP_PICTURE';
     $arrFieldList[0] = 'EMP_NUMBER';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_delete = 'true';
     $sql_builder->arr_delete = $arrFieldList;
     $sqlQString = $sql_builder->deleteRecord($arrList);
     //echo $sqlQString;
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
 }

Example #2

File: EmpRepUserGroups.php Project: noikiy/owaspbwa

 function delRepUserGroup($arrList)
 {
     $tableName = 'HS_HR_EMPREP_USERGROUP';
     $arrFieldList1[0] = 'USERG_ID';
     $arrFieldList1[1] = 'REP_CODE';
     $sql_builder1 = new SQLQBuilder();
     $sql_builder1->table_name = $tableName;
     $sql_builder1->flg_delete = 'true';
     $sql_builder1->arr_delete = $arrFieldList1;
     $sqlDelString = $sql_builder1->deleteRecord($arrList);
     //echo $sqlQString;
     $dbConnection1 = new DMLFunctions();
     $message2 = $dbConnection1->executeQuery($sqlDelString);
     //Calling the addData() function
 }

Example #3

File: SalCurDet.php Project: googlecode-mirror/pucit-orangehrm

 function delSalCurDet($arrList)
 {
     $tableName = 'HS_PR_SALARY_CURRENCY_DETAIL';
     $arrFieldList1[0] = 'SAL_GRD_CODE';
     $arrFieldList1[1] = 'CURRENCY_ID';
     $sql_builder1 = new SQLQBuilder();
     $sql_builder1->table_name = $tableName;
     $sql_builder1->flg_delete = 'true';
     $sql_builder1->arr_delete = $arrFieldList1;
     $sqlDelString = $sql_builder1->deleteRecord($arrList);
     //echo $sqlQString;
     $dbConnection1 = new DMLFunctions();
     $message2 = $dbConnection1->executeQuery($sqlDelString);
     //Calling the addData() function
 }

Example #4

File: JobTitEmpStat.php Project: noikiy/owaspbwa

 function delJobTitEmpStat($arrList)
 {
     $tableName = 'HS_HR_JOBTIT_EMPSTAT';
     $arrFieldList[0] = 'JOBTIT_CODE';
     $arrFieldList[1] = 'ESTAT_CODE';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_delete = 'true';
     $sql_builder->arr_delete = $arrFieldList;
     $sqlQString = $sql_builder->deleteRecord($arrList);
     //echo $sqlQString;
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
 }

Example #5

File: EmpBasSalary.php Project: noikiy/owaspbwa

 function delEmpBasSal($arrList)
 {
     $tableName = 'hs_hr_emp_basicsalary';
     $arrFieldList[0] = 'EMP_NUMBER';
     $arrFieldList[1] = 'SAL_GRD_CODE';
     $arrFieldList[2] = 'CURRENCY_ID';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_delete = 'true';
     $sql_builder->arr_delete = $arrFieldList;
     $sqlQString = $sql_builder->deleteRecord($arrList);
     //echo $sqlQString;
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
 }

Example #6

File: Education.php Project: noikiy/owaspbwa

 function delEducation($arrList)
 {
     $tableName = 'HS_HR_EDUCATION';
     $arrFieldList[0] = 'EDU_CODE';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_delete = 'true';
     $sql_builder->arr_delete = $arrFieldList;
     $sqlQString = $sql_builder->deleteRecord($arrList);
     //echo $sqlQString;
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
 }

Example #7

File: TimeEvent.php Project: noikiy/owaspbwa

 public function deleteTimeEvent()
 {
     $tableName = self::TIME_EVENT_DB_TABLE_TIME_EVENT;
     $arrFieldList[0] = self::TIME_EVENT_DB_FIELD_TIME_EVENT_ID;
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_delete = 'true';
     $sql_builder->arr_delete = $arrFieldList;
     $arrList = array(array($this->getTimeEventId()));
     $sqlQString = $sql_builder->deleteRecord($arrList);
     //echo $sqlQString;
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
 }

Example #8

File: EmpLang.php Project: noikiy/owaspbwa

 function delEmpLang($arrList)
 {
     $tableName = 'HS_HR_EMP_LANGUAGE';
     $arrFieldList[0] = 'EMP_NUMBER';
     $arrFieldList[1] = 'LANG_CODE';
     $arrFieldList[2] = 'ELANG_TYPE';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_delete = 'true';
     $sql_builder->arr_delete = $arrFieldList;
     $sqlQString = $sql_builder->deleteRecord($arrList);
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
 }

Example #9

File: SalaryGrades.php Project: noikiy/owaspbwa

 function delSalaryGrades($arrList)
 {
     $tableName = 'HS_PR_SALARY_GRADE';
     $arrFieldList[0] = 'SAL_GRD_CODE';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_delete = 'true';
     $sql_builder->arr_delete = $arrFieldList;
     $sqlQString = $sql_builder->deleteRecord($arrList);
     //echo $sqlQString;
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
 }

Example #10

File: LanguageInfo.php Project: noikiy/owaspbwa

 function delLanguageInfo($arrList)
 {
     $tableName = 'HS_HR_LANGUAGE';
     $arrFieldList[0] = 'LANG_CODE';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_delete = 'true';
     $sql_builder->arr_delete = $arrFieldList;
     $sqlQString = $sql_builder->deleteRecord($arrList);
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
 }

Example #11

File: Location.php Project: noikiy/owaspbwa

 function delLocation($arrList)
 {
     $tableName = 'HS_HR_LOCATION';
     $arrFieldList[0] = 'LOC_CODE';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_delete = 'true';
     $sql_builder->arr_delete = $arrFieldList;
     $sqlQString = $sql_builder->deleteRecord($arrList);
     $dbConnection = new DMLFunctions();
     $sqlQString1 = sprintf("SELECT * FROM `hs_hr_compstructtree` WHERE `loc_code` = '%s'", implode("' OR `loc_code` = '", $arrList[0]));
     $message1 = $dbConnection->executeQuery($sqlQString1);
     if (mysql_num_rows($message1) == 0) {
         $message2 = $dbConnection->executeQuery($sqlQString);
         //Calling the addData() function
         return true;
     }
 }

Example #12

File: EmpMembership.php Project: noikiy/owaspbwa

 function delEmpMembership($arrList)
 {
     $tableName = 'HS_HR_EMP_MEMBER_DETAIL';
     $arrFieldList[0] = 'EMP_NUMBER';
     $arrFieldList[1] = 'MEMBSHIP_CODE';
     $arrFieldList[2] = 'MEMBTYPE_CODE';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_delete = 'true';
     $sql_builder->arr_delete = $arrFieldList;
     $sqlQString = $sql_builder->deleteRecord($arrList);
     //echo $sqlQString;
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
 }

Example #13

File: Holidays.php Project: googlecode-mirror/pucit-orangehrm

 /**
  * Deletes holiday
  *
  * The object needs to be filled.
  *
  * @access public
  */
 public function delete()
 {
     $sql_builder = new SQLQBuilder();
     $arrFieldList[0] = self::HOLIDAYS_TABLE_HOLIDAY_ID;
     $arrValueList[0] = array($this->getHolidayId());
     $sql_builder->table_name = self::HOLIDAYS_TABLE;
     $sql_builder->arr_delete = $arrFieldList;
     $sql_builder->flg_delete = 'true';
     $query = $sql_builder->deleteRecord($arrValueList);
     //echo $query;
     $dbConnection = new DMLFunctions();
     $result = $dbConnection->executeQuery($query);
 }

Example #14

File: MembershipInfo.php Project: googlecode-mirror/pucit-orangehrm

 function delMembershipInfo($arrList)
 {
     $tableName = 'HS_HR_MEMBERSHIP';
     $arrFieldList[0] = 'MEMBSHIP_CODE';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $tableName;
     $sql_builder->flg_delete = 'true';
     $sql_builder->arr_delete = $arrFieldList;
     $sqlQString = $sql_builder->deleteRecord($arrList);
     //echo $sqlQString;
     $dbConnection = new DMLFunctions();
     $message2 = $dbConnection->executeQuery($sqlQString);
     //Calling the addData() function
     return $message2;
 }

Example #15

File: Workshift.php Project: noikiy/owaspbwa

 private static function _deleteWorkshifts($ids)
 {
     $tableName = self::WORKSHIFT_TABLE;
     $arrFieldList[0] = self::DB_FIELD_WORKSHIFT_ID;
     $sqlBuilder = new SQLQBuilder();
     $sqlBuilder->table_name = $tableName;
     $sqlBuilder->flg_delete = 'true';
     $sqlBuilder->arr_delete = $arrFieldList;
     $arrList[] = $ids;
     $sqlQString = $sqlBuilder->deleteRecord($arrList);
     $dbConnection = new DMLFunctions();
     $result = $dbConnection->executeQuery($sqlQString);
     if ($result) {
         return mysql_affected_rows();
     } else {
         throw new WorkshiftException("Error in SQL Query", WorkshiftException::ERROR_IN_DB_QUERY);
     }
 }

Example #16

File: CompProperty.php Project: googlecode-mirror/pucit-orangehrm

 public function deleteProperties()
 {
     $arrFieldList[0] = 'prop_id';
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = $this->TABLE_NAME;
     $sql_builder->flg_delete = 'true';
     $sql_builder->arr_delete = $arrFieldList;
     $dbConnection = new DMLFunctions();
     $sqlQString = $sql_builder->deleteRecord(array($this->deleteList));
     $message2 = $dbConnection->executeQuery($sqlQString);
     return $message2;
 }

Example #17

File: EmpDirectDebit.php Project: noikiy/owaspbwa

 /**
  * Delete the given direct debit information from the database
  *
  * @param string $empNumber Employee number
  * @param array $ddToDelete direct debit sequence numbers to delete
  */
 public function delete($empNumber, $ddToDelete)
 {
     $arrFieldList[0] = self::DB_FIELD_EMP_NUMBER;
     $arrFieldList[1] = self::DB_FIELD_SEQNO;
     $sql_builder = new SQLQBuilder();
     $sql_builder->table_name = self::TABLE_NAME;
     $sql_builder->flg_delete = 'true';
     $sql_builder->arr_delete = $arrFieldList;
     $arr[1] = $ddToDelete;
     for ($c = 0; count($arr[1]) > $c; $c++) {
         if ($arr[1][$c] != NULL) {
             $arr[0][$c] = $empNumber;
         }
     }
     $sqlQString = $sql_builder->deleteRecord($arr);
     $dbConnection = new DMLFunctions();
     $result = $dbConnection->executeQuery($sqlQString);
     return $result;
 }