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