function WritTypeSave() { if (empty($_POST["wstid"])) { $wtid = PdoDataAccess::GetLastID("HRM_writ_subtypes", "writ_subtype_id", " person_type=:PT", array(":PT" => $_POST['pt'])); $wtid++; $query = "insert into HRM_writ_subtypes(person_type,writ_type_id,writ_subtype_id,title,print_title,description,\r\n\t\t\temp_state , emp_mode , worktime_type)\r\n values('" . $_POST["pt"] . "',1," . $wtid . ",'" . $_POST["title"] . "','" . $_POST["print_title"] . "','',0,0,0)"; PdoDataAccess::runquery($query); $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_add; $daObj->MainObjectID = $_POST['pt'] . "-" . $wtid; $daObj->TableName = "HRM_writ_types"; $daObj->execute(); echo Response::createObjectiveResponse("true", $_POST['pt'] . "-" . $wtid); } else { $query = "update writ_types set title = '" . $_POST["title"] . "'\r\n where person_type=" . $_POST['pt'] . " and writ_type_id=" . $_POST['id']; PdoDataAccess::runquery($query); $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_update; $daObj->MainObjectID = $_POST['pt'] . "-" . $_POST['id']; $daObj->TableName = "job_category"; $daObj->execute(); echo Response::createObjectiveResponse("true", $_POST['pt'] . "-" . $_POST['id']); } die; }
function Add() { $masterID = parent::GetLastID("mission_list_items", "list_row_no", "list_id=" . $this->list_id); $this->list_row_no = $masterID + 1; $query = " select person_type from staff \r\n\t where staff_id = " . $this->staff_id; $res = parent::runquery($query); if ($res[0]['person_type'] == HR_PROFESSOR) { $this->salary_item_type_id = 42; } else { if ($res[0]['person_type'] == HR_EMPLOYEE) { $this->salary_item_type_id = 43; } else { if ($res[0]['person_type'] == HR_CONTRACT) { $this->salary_item_type_id = 643; } } } $result = parent::insert("mission_list_items", $this); if ($result === false) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_add; $daObj->MainObjectID = $this->list_id; $daObj->SubObjectID = $this->list_row_no; $daObj->TableName = "mission_list_items"; $daObj->execute(); return true; }
function AddGroup() { $InfoID = PdoDataAccess::GetLastID("BaseInfo", "InfoID", "TypeID=1"); PdoDataAccess::runquery("insert into BaseInfo(TypeID,InfoID, InfoDesc) \r\n\t\tvalues(1,?,?)", array($InfoID + 1, $_POST["GroupDesc"])); echo Response::createObjectiveResponse(true, ""); die; }
function AddTaxItem() { $this->row_no = parent::GetLastID("HRM_tax_table_items", "row_no", " tax_table_id =" . $this->tax_table_id) + 1; $result = parent::insert("HRM_tax_table_items", $this); 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 = "HRM_tax_table_items"; $daObj->execute(); return true; }
function AddList() { $lastid = parent::GetLastID("evaluation_lists", "list_id"); $this->list_id = $lastid + 1; $return = parent::insert("evaluation_lists", $this); if ($return === false) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_add; $daObj->MainObjectID = $this->list_id; $daObj->TableName = "evaluation_lists"; $daObj->execute(); return true; }
function AddWST() { $wsid = PdoDataAccess::GetLastID("writ_subtypes", "writ_subtype_id", "person_type = :PT and writ_type_id = :WTI ", array(":PT" => $this->person_type, ":WTI" => $this->writ_type_id)); $wsid++; $this->writ_subtype_id = $wsid; $return = parent::insert("writ_subtypes", $this); if ($return === false) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_add; $daObj->MainObjectID = $this->person_type . "-" . $this->writ_type_id . "-" . $this->writ_subtype_id; $daObj->TableName = "writ_subtypes"; $daObj->execute(); return true; }
function AddTax() { $tax_table_type_id = parent::GetLastID("HRM_tax_table_types", "tax_table_type_id"); $tax_table_type_id++; $this->tax_table_type_id = $tax_table_type_id; $result = parent::insert("HRM_tax_table_types", $this); if ($result === false) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_add; $daObj->MainObjectID = $this->tax_table_type_id; $daObj->TableName = "HRM_tax_table_types"; $daObj->execute(); return true; }
function Add() { $masterID = parent::GetLastID("pay_get_list_items", "list_row_no", "list_id=" . $this->list_id); $this->list_row_no = $masterID + 1; $result = parent::insert("pay_get_list_items", $this); if ($result === false) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_add; $daObj->MainObjectID = $this->list_id; $daObj->SubObjectID = $this->list_row_no; $daObj->TableName = "pay_get_list_items"; $daObj->execute(); return true; }
function Add() { $this->bank_id = parent::GetLastID("banks", "bank_id") + 1; if ($this->branch_code == 0 || $this->branch_code == null) { $this->branch_code = PDONULL; } $return = parent::insert("banks", $this); if ($return === false) { return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_add; $daObj->MainObjectID = $this->bank_id; $daObj->TableName = "banks"; $daObj->execute(); return true; }
function Add() { $pdo = parent::getPdoObject(); /*@var $pdo PDO*/ $pdo->beginTransaction(); $this->row_no = parent::GetLastID("HRM_person_dependent_supports", "row_no", "PersonID=:pid and master_row_no=:mrno", array(":pid" => $this->PersonID, ":mrno" => $this->master_row_no)) + 1; $result = parent::insert("HRM_person_dependent_supports", $this); if ($result === false) { $pdo->rollBack(); return false; } $this->row_no = parent::InsertID(); $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_add; $daObj->RelatedPersonID = $this->PersonID; $daObj->RelatedPersonType = 3; $daObj->MainObjectID = $this->row_no; $daObj->TableName = "HRM_person_dependent_supports"; $daObj->execute(); $pdo->commit(); return true; }
public static function LastID($pdo = null) { return PdoDataAccess::GetLastID(static::TableName, static::TableKey, "", array(), $pdo) + 1; }
function SaveLetter($dieing = true) { $Letter = new OFC_letters(); pdoDataAccess::FillObjectByArray($Letter, $_POST); if ($Letter->RefLetterID != "") { $obj = new OFC_letters($Letter->RefLetterID); if (empty($obj->LetterID)) { Response::createObjectiveResponse(false, "شماره نامه عطف قابل بازیابی نمی باشد"); die; } } if ($Letter->LetterID == '') { $Letter->PersonID = $_SESSION["USER"]["PersonID"]; $Letter->LetterDate = PDONOW; $Letter->RegDate = PDONOW; $res = $Letter->AddLetter(); } else { $res = $Letter->EditLetter(); } if (!empty($_FILES["PageFile"]["tmp_name"])) { $st = preg_split("/\\./", $_FILES['PageFile']['name']); $extension = strtolower($st[count($st) - 1]); if (in_array($extension, array("jpg", "jpeg", "gif", "png", "pdf")) === false) { Response::createObjectiveResponse(false, "فرمت فایل ارسالی نامعتبر است"); die; } $dt = DMS_documents::SelectAll("ObjectType='letter' AND ObjectID=?", array($Letter->LetterID)); if (count($dt) == 0) { $obj = new DMS_documents(); $obj->DocType = 0; $obj->ObjectType = "letter"; $obj->ObjectID = $Letter->LetterID; $obj->AddDocument(); $DocumentID = $obj->DocumentID; } else { $DocumentID = $dt[0]["DocumentID"]; } //.............................................. $obj2 = new DMS_DocFiles(); $obj2->DocumentID = $DocumentID; $obj2->PageNo = PdoDataAccess::GetLastID("DMS_DocFiles", "PageNo", "DocumentID=?", array($DocumentID)) + 1; $obj2->FileType = $extension; $obj2->FileContent = substr(fread(fopen($_FILES['PageFile']['tmp_name'], 'r'), $_FILES['PageFile']['size']), 0, 200); $obj2->AddPage(); $fp = fopen(getenv("DOCUMENT_ROOT") . "/storage/documents/" . $obj2->RowID . "." . $extension, "w"); fwrite($fp, substr(fread(fopen($_FILES['PageFile']['tmp_name'], 'r'), $_FILES['PageFile']['size']), 200)); fclose($fp); } if ($dieing) { Response::createObjectiveResponse($res, $Letter->GetExceptionCount() != 0 ? $Letter->popExceptionDescription() : $Letter->LetterID); die; } return true; }
function importStudent() { $dt = PdoDataAccess::runquery("select * from StudentPersonMap where StNo=?", array($_POST["StNo"])); if (count($dt) > 0) { echo Response::createObjectiveResponse(false, "Duplicate"); die; } $pdo = PdoDataAccess::getPdoObject(); $pdo->beginTransaction(); $query = "insert into \n\t\tpersons(person_type,pfname,plname,efname,elname,father_name,idcard_no,birth_date,national_code,\n\t\t\t\tsex,address1,home_phone1,mobile_phone,email,comment)\n\t\tselect " . $_POST["person_type"] . ",PFName,PLName,EFName,ELName,DadName,BCN,BirthDate,NID,\n\t\t\t\tsex,address1,PhoneNo,mobile,EMail,concat('انتقال اطلاعات دانشجو با شماره دانشجویی', StNo)\n\t\tfrom students where StNo=?"; PdoDataAccess::runquery($query, array($_POST["StNo"]), $pdo); if (ExceptionHandler::GetExceptionCount() > 0) { $pdo->rollBack(); echo Response::createObjectiveResponse(false, "1"); //print_r(ExceptionHandler::PopAllExceptions()); die; } //-------------------------------------------------------------------------- $personID = PdoDataAccess::InsertID(); $staff_id = PdoDataAccess::GetLastID("staff", "staff_id", "", array(), $pdo) + 1; PdoDataAccess::runquery("insert into staff(staff_id,PersonID,person_type) \n\t\t\tvalues({$staff_id}, {$personID}, " . $_POST["person_type"] . ")", array(), $pdo); if (ExceptionHandler::GetExceptionCount() > 0) { $pdo->rollBack(); echo Response::createObjectiveResponse(false, "2"); //print_r(ExceptionHandler::PopAllExceptions()); die; } //-------------------------------------------------------------------------- $query = "insert into StudentPersonMap\tvalues({$personID}," . $_POST["StNo"] . ")"; PdoDataAccess::runquery($query, array(), $pdo); if (ExceptionHandler::GetExceptionCount() > 0) { $pdo->rollBack(); //print_r(ExceptionHandler::PopAllExceptions()); echo Response::createObjectiveResponse(false, "5"); die; } //-------------------------------------------------------------------------- $query = "select RFID from educ.StudentSpecs where StNo=?"; $dt = PdoDataAccess::runquery($query, array($_POST["StNo"]), $pdo); if (ExceptionHandler::GetExceptionCount() > 0) { $pdo->rollBack(); echo Response::createObjectiveResponse(false, "3"); //print_r(ExceptionHandler::PopAllExceptions()); die; } if (count($dt) > 0 && $dt[0][0] != "") { $id = PdoDataAccess::GetLastID("pas.PersonSettings", "PersonSettingsID"); $query = "insert into pas.PersonSettings(PersonSettingsID,PersonID,CardStatus,CardNumber,WorkGroupID,CalendarID)\n\t\t\tvalues(" . ($id + 1) . ",{$personID},'ENABLE',NULL,0,0)"; PdoDataAccess::runquery($query, array(), $pdo); if (ExceptionHandler::GetExceptionCount() > 0) { $pdo->rollBack(); print_r(ExceptionHandler::PopAllExceptions()); echo Response::createObjectiveResponse(false, "4"); die; } } //-------------------------------------------------------------------------- $pdo->commit(); $result = ExceptionHandler::GetExceptionCount() == 0 ? "true" : "false"; echo Response::createObjectiveResponse($result, ""); die; }
static function LastID($pdo = "") { return PdoDataAccess::GetLastID("HRM_writs", "writ_id", "", array(), $pdo); }
public static function LastID() { return PdoDataAccess::GetLastID("wfm_forms", "LetterID"); }
function LastID() { return PdoDataAccess::GetLastID("HRM_salary_item_types", "salary_item_type_id"); }
public static function LastID($pdo = "") { return PdoDataAccess::GetLastID("persons", "PersonID", "", array(), $pdo); }
private static function LastID($PersonID) { $whereParam = array(); $whereParam[":PD"] = $PersonID; return parent::GetLastID("PersonJobs", "RowNO", "PersonID=:PD", $whereParam); }
private static function LastID() { return PdoDataAccess::GetLastID("salary_params", "param_id"); }
private static function LastID($PersonID) { $whereParam = array(); $whereParam[":PD"] = $PersonID; return parent::GetLastID("HRM_person_educations", "row_no", "PersonID=:PD", $whereParam); }
function SaveDocType() { $st = stripslashes(stripslashes($_POST["record"])); $data = json_decode($st); if ($data->InfoID * 1 == 0) { $pdo = PdoDataAccess::getPdoObject(); $pdo->beginTransaction(); $data->InfoID = PdoDataAccess::GetLastID("BaseInfo", "InfoID", "TypeID=?", array($data->TypeID), $pdo); $data->InfoID = $data->InfoID * 1 + 1; PdoDataAccess::runquery("insert into BaseInfo(TypeID,InfoID,InfoDesc,param1) values(?,?,?,?)", array($data->TypeID, $data->InfoID, $data->InfoDesc, $data->param1), $pdo); $pdo->commit(); } else { PdoDataAccess::runquery("update BaseInfo set InfoDesc=? where TypeID=? AND InfoID=?", array($data->InfoDesc, $data->TypeID, $data->InfoID)); } echo Response::createObjectiveResponse(ExceptionHandler::GetExceptionCount() == 0, ""); die; }
public static function LastID() { return parent::GetLastID("rp_reports", "report_id"); }
static function GetLastLocalNo() { $no = parent::GetLastID("ACC_docs", "LocalNo", "CycleID=? AND BranchID=?", array($_SESSION["accounting"]["CycleID"], $_SESSION["accounting"]["BranchID"])); return $no + 1; }
private static function LastID($PersonID) { $whereParam = array(); $whereParam[":PD"] = $PersonID; return parent::GetLastID("person_devotions", "devotion_row", "PersonID=:PD", $whereParam); }
private static function LastID($PersonID) { $whereParam = array(); $whereParam[":PD"] = $PersonID; return PdoDataAccess::GetLastID("person_employments", "row_no", "PersonID=:PD", $whereParam); }
static function Create_New_Staff($personid, $persontype) { $obj = new manage_staff($personid, $persontype); if ($persontype == 3 || $persontype == 5) { $obj->person_type = 2; } else { if ($persontype == 2) { $obj->person_type = 1; } } $old_staff_id = $obj->staff_id; $ret = $obj->AddStaff(); if ($ret == true) { //-------------------------------------------------- $qry = " select * from staff_tax_history where staff_id=" . $old_staff_id . " AND payed_tax_value IS NOT NULL "; $tmp = PdoDataAccess::runquery($qry); if (count($tmp) > 0) { $Newobj = new manage_staff_tax($old_staff_id); parent::FillObjectByArray($Newobj, $tmp[0]); $Newobj->staff_id = $obj->staff_id; $Newobj->tax_history_id = parent::GetLastID('staff_tax_history', 'tax_history_id') + 1; if (PdoDataAccess::insert("staff_tax_history", $Newobj) === false) { return false; } } //................. آزاد کردن پست سازمانی شماره شناسایی قبلی ................... $qry = " update position set staff_id= null where staff_id = " . $old_staff_id; PdoDataAccess::runquery($qry); //.................................................. $query = " update persons set person_type = " . $obj->person_type . " where personid =" . $obj->PersonID; PdoDataAccess::runquery($query); if (ExceptionHandler::GetExceptionCount() == 0) { return $obj->staff_id; } } return false; }
private static function LastID($staff_id) { $whereParam = array(); $whereParam[":staff_id"] = $staff_id; return parent::GetLastID("professor_exe_posts", "row_no", "staff_id=:staff_id", $whereParam); }
function AddPost() { $db = PdoDataAccess::getPdoObject(); /*@var $db PDO*/ $db->beginTransaction(); $this->post_id = parent::GetLastID("`position`", "post_id") + 1; $this->RegDate = PDONOW; $return = parent::insert("`position`", $this); if ($return === false) { $db->rollBack(); return false; } $daObj = new DataAudit(); $daObj->ActionType = DataAudit::Action_add; $daObj->MainObjectID = $this->post_id; $daObj->TableName = "position"; $daObj->execute(); $db->commit(); $this->OnAfterInsert(); return true; }
private static function LastID($pdo = "") { return PdoDataAccess::GetLastID("staff", "staff_id", "", array()); }