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