static function RemoveDependency($PersonID, $row_no) { $whereParams = array(); $whereParams[":pid"] = $PersonID; $whereParams[":rowid"] = $row_no; if (parent::delete("HRM_person_dependents", " PersonID=:pid and row_no=:rowid", $whereParams) === false) { $error = implode("", parent::popExceptionDescription()); if (strpos($error, "a foreign key constraint fails") !== false) { if (strpos($error, "person_dependent_supports") !== false) { parent::PushException("این وابسته دارای سابقه کفالت بوده و قابل حذف نمی باشد."); } else { parent::PushException("از این وابسته در جای دیگری استفاده شده و قابل حدف نمی باشد."); } } else { parent::PushException($error); } return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $row_no; $daObj->RelatedPersonType = 3; $daObj->RelatedPersonID = $PersonID; $daObj->TableName = "person_dependents"; $daObj->execute(); return true; }
function Remove() { if ($this->list_type == 9) { $tblName = "mission_list_items"; } else { $tblName = "pay_get_list_items"; } $query = " select * from " . $tblName . " where list_id = " . $this->list_id; $tmp = parent::runquery($query); $query = " select * from pay_get_lists where list_id = " . $this->list_id . " and doc_state = 3 "; $tmp2 = parent::runquery($query); if (count($tmp) > 0) { parent::PushException("این لیست شامل مجموعه ای از افراد می باشد ."); return false; } else { if (count($tmp2) > 0) { parent::PushException("این لیست تایید واحد مرکزی می باشد ."); return false; } else { $result = parent::delete("pay_get_lists", "list_id=?", array($this->list_id)); } } if (!$result) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $this->list_id; $daObj->TableName = "pay_get_lists"; $daObj->execute(); return true; }
function Remove($All = "") { $query = " select * from evaluation_lists where list_id = " . $this->list_id . " and doc_state = 3 "; $tmp2 = parent::runquery($query); if (count($tmp2) > 0) { parent::PushException("این لیست تایید واحد مرکزی می باشد ."); return false; } else { if ($All == "true") { $result = parent::delete("evaluation_list_items", "list_id=?", array($this->list_id)); } else { $result = parent::delete("evaluation_list_items", "list_id =? and ListItemID=? ", array($this->list_id, $this->ListItemID)); } } if (!$result) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $this->list_id; $daObj->SubObjectID = $this->ListItemID; $daObj->TableName = "evaluation_list_items"; $daObj->execute(); return true; }
static function RemoveFlow($FlowID) { if (!parent::delete("WFM_flows", " FlowID=?", array($FlowID))) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $FlowID; $daObj->TableName = "WFM_flows"; $daObj->execute(); return true; }
static function DeleteLoan($LoanID) { if (parent::delete("LON_loans", " LoanID=?", array($LoanID)) === false) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $LoanID; $daObj->TableName = "LON_loans"; $daObj->execute(); return true; }
static function Remove($sid) { $result = parent::delete("SalaryItemReport", "SalaryItemReportID=:SID ", array(":SID" => $sid)); if (!$result) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $sid; $daObj->TableName = "SalaryItemReport"; $daObj->execute(); return true; }
static function Remove($sid, $pt, $cid) { $result = parent::delete("CostCenterException", "SalaryItemTypeID=:SID and PersonType = :PT and CostCenterID = :CC ", array(":SID" => $sid, ":PT" => $pt, ":CC" => $cid)); if (!$result) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $sid; $daObj->SubObjectID = $cid; $daObj->TableName = "CostCenterException"; $daObj->execute(); return true; }
function RemoveTaxItem($tax_table_id, $row_no) { $result = parent::delete("tax_table_items", "tax_table_id=:tid and row_no=:rid", array(":tid" => $this->tax_table_id, ":rid" => $this->row_no)); if ($result === false) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_add; $daObj->MainObjectID = $this->tax_table_id; $daObj->SubObjectID = $this->row_no; $daObj->TableName = "tax_table_items"; $daObj->execute(); return true; }
static function Remove($sid, $pt) { $result = parent::delete("SubtractItemInfo", "SalaryItemTypeID=:SID and PersonType = :PT ", array(":SID" => $sid, ":PT" => $pt)); if (!$result) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $sid; $daObj->SubObjectID = $pt; $daObj->TableName = "SubtractItemInfo"; $daObj->execute(); return true; }
function Remove() { $result = parent::delete("HRM_person_dependent_supports", "PersonID=:pid and master_row_no=:mrno and row_no=:rno", array(":pid" => $this->PersonID, ":mrno" => $this->master_row_no, ":rno" => $this->row_no)); if ($result === false) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->RelatedPersonID = $this->PersonID; $daObj->RelatedPersonType = 3; $daObj->MainObjectID = $this->row_no; $daObj->TableName = "person_dependent_supports"; $daObj->execute(); return true; }
function RemoveTax() { if (!$this->onBeforeDelete()) { return false; } $result = parent::delete("tax_tables", "tax_table_id=:tid ", array(":tid" => $this->tax_table_id)); if ($result === false) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_add; $daObj->MainObjectID = $this->tax_table_id; $daObj->TableName = "tax_tables"; $daObj->execute(); return true; }
static function RemoveJobHistory($PersonID, $row_no) { $whereParams = array(); $whereParams[":pid"] = $PersonID; $whereParams[":rowid"] = $row_no; if (PdoDataAccess::delete("PersonJobs", " PersonID=:pid and RowNO=:rowid", $whereParams) === false) { parent::PushException(ER_PERSON_DEP_DEL); return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->RelatedPersonID = $PersonID; $daObj->MainObjectID = $row_no; $daObj->TableName = "PersonJobs"; $daObj->execute(); return true; }
function RemoveTax($tax_table_type_id, $person_type) { if (!$this->onBeforeDelete()) { return false; } $result = parent::delete("tax_table_types", "tax_table_type_id=:tid and person_type = :pt ", array(":tid" => $this->tax_table_type_id, ":pt" => $this->person_type)); if ($result === false) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->RelatedPersonType = DataAudit::PersonType_staff; $daObj->MainObjectID = $this->tax_table_type_id; $daObj->TableName = "tax_table_types"; $daObj->execute(); return true; }
function RemoveParam($param_type, $person_type) { $obj = new manage_salary_param_types($param_type, $person_type); if (!$obj->onBeforeDelete()) { return false; } $result = parent::delete("salary_param_types", "param_type=:pid and person_type = :pt ", array(":pid" => $this->param_type, ":pt" => $this->person_type)); if ($result === false) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->RelatedPersonType = DataAudit::PersonType_staff; $daObj->MainObjectID = $this->param_type; $daObj->TableName = "salary_param_types"; $daObj->execute(); return true; }
static function Remove($pid) { $res = parent::runquery(" select count(*) cn from SubtractItemInfo where arrangement = " . $pid); if ($res[0]['cn'] > 0) { parent::PushException("حذف این رکورد امکان پذیر نمی باشد."); return false; } $result = parent::delete("priority", "PriorityID=:PID ", array(":PID" => $pid)); if (!$result) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $pid; $daObj->TableName = "priority"; $daObj->execute(); return true; }
static function Remove($bid) { $res = parent::runquery(" select count(*) cn from staff where bank_id = " . $bid); if ($res[0]['cn'] > 0) { parent::PushException("حذف این رکورد امکان پذیر نمی باشد."); return false; } $result = parent::delete("banks", "bank_id=:BID ", array(":BID" => $bid)); if (!$result) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $bid; $daObj->TableName = "banks"; $daObj->execute(); return true; }
static function RemoveEducation($personID, $row_no) { $whereParams = array(); $whereParams[":pid"] = $personID; $whereParams[":rowid"] = $row_no; if (parent::delete("HRM_person_educations", " PersonID=:pid and row_no=:rowid", $whereParams) === false) { parent::PushException(ER_PERSON_DEP_DEL); return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->RelatedPersonType = 3; $daObj->RelatedPersonID = $personID; $daObj->MainObjectID = $row_no; $daObj->TableName = "person_educations"; $daObj->execute(); return true; }
static function Remove($uid, $cid) { $res = parent::runquery(" select count(*) cn from person_educations where university_id = " . $uid . " and country_id =" . $cid); if ($res[0]['cn'] > 0) { parent::PushException("حذف این رکورد به علت استفاده در اطلاعات پرسنل امکان پذیر نمی باشد."); return false; } $result = parent::delete("universities", "university_id=:UID and country_id = :CID ", array(":UID" => $uid, ":CID" => $cid)); if (!$result) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $uid; $daObj->SubObjectID = $cid; $daObj->TableName = "universities"; $daObj->execute(); return true; }
static function Remove($CostID) { $query = " select count(*) cn \r\n\t\t\t\tfrom writs \r\n\t\t\t\t where cost_center_id = " . $CostID; $res = parent::runquery($query); if ($res[0]['cn'] > 0) { parent::PushException("این مرکز هزینه در احکام ثبت گردیده است لذا حذف امکان پذیر نمی باشد."); return false; } $result = parent::delete("cost_centers", "cost_center_id=:CID ", array(":CID" => $CostID)); if ($result === false) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $CostID; $daObj->TableName = "cost_centers"; $daObj->execute(); return true; }
static function Remove($sfid, $sbid) { $res = parent::runquery(" select count(*) cn from person_educations where sfid = " . $sfid . " and sbid = " . $sbid); if ($res[0]['cn'] > 0) { parent::PushException("این رشته در اطلاعات پایه افراد ثبت شده است به همین دلیل حذف امکان پذیر نمی باشد ."); return false; } $result = parent::delete("study_branchs", "sfid=:sfid and sbid=:sbid", array(":sfid" => $sfid, ":sbid" => $sbid)); if ($result === false) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $sfid; $daObj->SubObjectID = $sbid; $daObj->TableName = "study_branchs"; $daObj->execute(); return true; }
static function remove($staff_id, $PersonID = "") { if ($staff_id != "") { $whereParam = array(":staff_id" => $staff_id); $return = PdoDataAccess::delete("staff_details", "staff_id=:staff_id", $whereParam); if ($return == "0") { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $staff_id; $daObj->TableName = "staff_details"; $daObj->execute(); return true; } if ($PersonID != "") { $query = "delete sd\n\t\t\t\t\t\tfrom staff_details sd join staff s using(staff_id) where s.PersonID=?"; PdoDataAccess::runquery($query, array($PersonID)); if (ExceptionHandler::GetExceptionCount() != 0) { return false; } return true; } }
static function Remove($row_no) { $result = parent::delete("person_subtract_flows", "row_no=:rno ", array(":rno" => $row_no)); if ($result === false) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $row_no; $daObj->TableName = "person_subtract_flows"; $daObj->execute(); return true; }
static function RemoveUnit($ouid) { $whereParams = array(); $whereParams[":ouid"] = $ouid; $db = PdoDataAccess::getPdoObject(); /*@var $db PDO*/ $db->beginTransaction(); parent::runquery("insert into org_units_history select *,'DELETE',now() from org_new_units where ouid=:ouid", $whereParams); $return = PdoDataAccess::delete("org_new_units", " ouid=:ouid", $whereParams); if ($return === false) { $db->rollBack(); return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $ouid; $daObj->TableName = "org_new_units"; $daObj->execute(); $db->commit(); return true; }
static function DeleteFolder($FolderID) { PdoDataAccess::runquery("delete from OFC_ArchiveItems where FolderID=?", array($FolderID)); if (parent::delete("OFC_archive", "FolderID=?", array($FolderID)) === false) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $FolderID; $daObj->TableName = "OFC_archive"; $daObj->execute(); return true; }
static function RemovePost($post_id) { if (!self::OnBeforeDelete($post_id)) { return false; } $whereParams = array(); $whereParams[":post_id"] = $post_id; $db = parent::getPdoObject(); /*@var $db PDO*/ $db->beginTransaction(); parent::runquery("insert into position_history select *,'DELETE',now() from position where post_id=:post_id", $whereParams); $return = parent::delete("position", " post_id=:post_id", $whereParams); if ($return == "0") { $db->rollBack(); return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $post_id; $daObj->TableName = "position"; $daObj->execute(); $db->commit(); self::OnAfterDelete(); return true; }
function RemoveParam($param_id) { $result = parent::delete("salary_params", "param_id=:pid ", array(":pid" => $this->param_id)); if ($result === false) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_add; $daObj->RelatedPersonType = DataAudit::PersonType_staff; $daObj->MainObjectID = $this->param_id; $daObj->TableName = "salary_params"; $daObj->execute(); return true; }
static function Remove($bylaw_id, $post_id) { $whereParams = array(); $whereParams[":bylaw_id"] = $bylaw_id; $whereParams[":postid"] = $post_id; if (parent::delete("managmnt_extra_bylaw_items", " bylaw_id=:bylaw_id AND post_id=:postid", $whereParams) === false) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $bylaw_id; $daObj->SubObjectID = $post_id; $daObj->TableName = "managmnt_extra_bylaw_items"; $daObj->execute(); return true; }
static function RemoveWritItem($where, $whereParam = array()) { $ret = PdoDataAccess::delete("HRM_writ_salary_items", $where, $whereParam); if ($ret) { $obj = new DataAudit(); $obj->TableName = "HRM_writ_salary_items"; $obj->ActionType = DataAudit::Action_delete; $obj->description = $where . "[" . implode(",", $whereParam) . "]"; $obj->execute(); return true; } return false; }
static function DeleteDomain($DomainID) { if (parent::delete("BSC_ActDomain", "DomainID=?", array($DomainID)) === false) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $DomainID; $daObj->TableName = "BSC_ActDomain"; $daObj->execute(); return true; }
function DeleteCheque() { $whereParams = array(); $whereParams[":ChequeBookID"] = $this->ChequeBookID; $result = parent::delete("ACC_ChequeBooks", "ChequeBookID=:ChequeBookID", $whereParams); if ($result === false) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_delete; $daObj->MainObjectID = $this->ChequeBookID; $daObj->TableName = "ACC_ChequeBooks"; $daObj->execute(); return true; }