function ResetPass() { $result = BSC_persons::ResetPass($_POST["PersonID"]); echo Response::createObjectiveResponse($result, ""); die; }
function saveStaffData() { $obj = new manage_staff(); PdoDataAccess::FillObjectByArray($obj, $_POST); if (isset($_POST["work_start_date"])) { $obj->work_start_date = DateModules::Shamsi_to_Miladi($_POST["work_start_date"]); } if (isset($_POST["ProfWorkStart"])) { $obj->ProfWorkStart = DateModules::Shamsi_to_Miladi($_POST["ProfWorkStart"]); } if (isset($_POST["retired_date"])) { $obj->retired_date = DateModules::Shamsi_to_Miladi($_POST["retired_date"]); } if (isset($_POST["last_retired_pay"])) { $obj->last_retired_pay = DateModules::Shamsi_to_Miladi($_POST["last_retired_pay"]); } if (!isset($_POST['Over25'])) { $obj->Over25 = 0; } $obj->sum_paied_pension = $obj->sum_paied_pension > 0 ? $obj->sum_paied_pension : "0"; $return = $obj->EditStaff(); $key = $obj->staff_id . "," . $obj->PersonID . "," . $obj->person_type; echo $return ? Response::createObjectiveResponse("true", $key) : Response::createObjectiveResponse(false, ExceptionHandler::GetExceptionsToString("\n")); die; }
function DontPayItem() { $obj = new manage_writ_item(); $return = $obj->DontPayItems($_POST["writ_id"], $_POST["writ_ver"], $_POST["staff_id"]); echo Response::createObjectiveResponse($return, $return ? $obj->writ_id : ExceptionHandler::popExceptionDescription()); die; }
function DeleteElement() { $obj = new PLN_Elements(); $obj->ElementID = $_POST["ElementID"]; $result = $obj->Remove(); echo Response::createObjectiveResponse($result, ""); die; }
function SavePersonalInfo() { $obj = new BSC_persons(); $obj->PersonID = $_SESSION["USER"]["PersonID"]; PdoDataAccess::FillObjectByArray($obj, $_POST); $result = $obj->EditPerson(); echo Response::createObjectiveResponse($result, ""); die; }
function DeleteMiscDoc() { $return = manage_person_misc_doc::RemoveMiscDoc($_POST['PersonID'], $_POST['row_no']); if ($return !== true) { echo $return; die; } echo Response::createObjectiveResponse("true", $_POST['PersonID']); die; }
function deleteJH() { $return = manage_person_job::RemoveJobHistory($_POST['PID'], $_POST['RowNO']); if ($return !== true) { echo $return; die; } echo Response::createObjectiveResponse("true", $_POST['PID']); die; }
function removeCC() { $result = manage_cost_centers::Remove($_POST["cid"]); if (!$result) { Response::createObjectiveResponse(false, ExceptionHandler::GetExceptionsToString()); die; } else { Response::createObjectiveResponse(true, ""); die; } }
function saveTaxHisGrid() { $obj = new manage_staff_tax(); PdoDataAccess::FillObjectByJsonData($obj, $_POST["record"]); if ($obj->tax_history_id == "") { $return = $obj->SaveStaffTaxHistory($_POST['PersonID']); } else { $return = $obj->EditStaffTaxHistory($_POST['PersonID']); } echo $return ? Response::createObjectiveResponse(true, $obj->staff_id) : Response::createObjectiveResponse(false, ExceptionHandler::GetExceptionsToString("\n")); die; }
function CreateNewStaff() { $PID = $_POST['personid']; $PT = $_POST['person_type']; $STID = $_POST['staff_id']; $res = manage_staff::Create_New_Staff($PID, $PT); if (!empty($res)) { Response::createObjectiveResponse(true, "{STID:" . $res . " ,PID:" . $PID . "}"); die; } else { Response::createObjectiveResponse(false, ExceptionHandler::ConvertExceptionsToJsObject()); die; } }
function SaveUnit() { $obj = new manage_units(); PdoDataAccess::FillObjectByArray($obj, $_POST); if (empty($_POST["ouid"])) { $obj->RegDate = date('Y-m-d'); $obj->parent_path = $_POST["parent_path"] == "" ? $obj->parent_path : $_POST["parent_path"] . "," . $obj->parent_ouid; $obj->AddUnit(); } else { $obj->ouid = $_POST["ouid"]; $obj->EditUnit(); } echo Response::createObjectiveResponse("true", $obj->ouid); die; }
function DepositeProfit() { $Tafsilis = array(); $keys = array_keys($_POST); foreach ($keys as $key) { if (strpos($key, "chk_") !== false) { $Tafsilis[] = substr($key, 4) * 1; } } if (count($Tafsilis) == 0) { echo Response::createObjectiveResponse(false, "هیچ ردیفی انتخاب نشده است"); die; } $ToDate = DateModules::shamsi_to_miladi($_POST["ToDate"]); ComputeDepositeProfit($ToDate, $Tafsilis); die; }
function WritSubTypeSave() { $obj = new manage_writ_subType($_POST['person_type'], $_POST['writ_type_id']); PdoDataAccess::FillObjectByArray($obj, $_POST); $obj->time_limited = isset($_POST['time_limited']) ? $_POST['time_limited'] : 0; $obj->req_staff_signature = isset($_POST['req_staff_signature']) ? $_POST['req_staff_signature'] : 0; $obj->automatic = isset($_POST['automatic']) ? $_POST['automatic'] : 0; $obj->edit_fields = isset($_POST['edit_fields']) ? $_POST['edit_fields'] : 0; $obj->force_writ_issue = isset($_POST['force_writ_issue']) ? $_POST['force_writ_issue'] : 0; $obj->show_in_summary_doc = isset($_POST['show_in_summary_doc']) ? $_POST['show_in_summary_doc'] : 0; if (empty($_POST["writ_subtype_id"])) { $result = $obj->AddWST(); } else { $obj->writ_subtype_id = $_POST["writ_subtype_id"]; $result = $obj->EditWST(); } echo Response::createObjectiveResponse($result == true ? "true" : "false", $obj->person_type . "-" . $obj->writ_type_id . "-" . $obj->writ_subtype_id); die; }
function removeTask() { $result = FRW_tasks::DeleteTask($_POST["TaskID"]); Response::createObjectiveResponse($result, ""); die; }
function RegisterInOutAccountDoc() { $CostID = $_REQUEST["BaseCostID"]; $BaseTafsiliID = $_REQUEST["BaseTafsiliID"]; $mode = $_POST["mode"] * 1; if ($mode < 0) { $query = "select ifnull(sum(CreditorAmount-DebtorAmount),0) remaindar\n\t\tfrom ACC_DocItems di\n\t\t\tjoin ACC_docs d using(DocID)\n\t\twhere d.CycleID=:c AND d.BranchID=:b AND \n\t\t\tdi.CostID=:cost AND di.TafsiliType = :t AND di.TafsiliID=:tid"; $param = array(":c" => $_SESSION["accounting"]["CycleID"], ":b" => $_SESSION["accounting"]["BranchID"], ":cost" => $CostID, ":t" => TAFTYPE_PERSONS, ":tid" => $BaseTafsiliID); $dt = PdoDataAccess::runquery($query, $param); //echo PdoDataAccess::GetLatestQueryString(); if ($_POST["amount"] > $dt[0][0] * 1) { echo Response::createObjectiveResponse(false, "مبلغ وارد شده بیشتر از مانده حساب می باشد"); die; } } $pdo = PdoDataAccess::getPdoObject(); $pdo->beginTransaction(); //---------------- add doc header -------------------- $obj = new ACC_docs(); $obj->RegDate = PDONOW; $obj->regPersonID = $_SESSION['USER']["PersonID"]; $obj->DocDate = PDONOW; $obj->CycleID = $_SESSION["accounting"]["CycleID"]; $obj->BranchID = $_SESSION["accounting"]["BranchID"]; $obj->DocType = $mode > 0 ? DOCTYPE_SAVING_IN : DOCTYPE_SAVING_OUT; $obj->description = $mode > 0 ? "واریز به حساب" : "برداشت از حساب"; if (!$obj->Add($pdo)) { echo Response::createObjectiveResponse(false, "خطا در ایجاد سند"); die; } //------------------------------------------------- $itemObj = new ACC_DocItems(); $itemObj->DocID = $obj->DocID; $itemObj->CostID = $CostID; $itemObj->DebtorAmount = $mode > 0 ? 0 : $_POST["amount"]; $itemObj->CreditorAmount = $mode > 0 ? $_POST["amount"] : 0; $itemObj->TafsiliType = TAFTYPE_PERSONS; $itemObj->TafsiliID = $BaseTafsiliID; $itemObj->details = $_POST["description"]; if (!$itemObj->Add($pdo)) { echo Response::createObjectiveResponse(false, ExceptionHandler::GetExceptionsToString()); die; } $itemObj = new ACC_DocItems(); $itemObj->DocID = $obj->DocID; $itemObj->CostID = $_POST["CostID"]; $itemObj->DebtorAmount = $mode > 0 ? $_POST["amount"] : 0; $itemObj->CreditorAmount = $mode > 0 ? 0 : $_POST["amount"]; if ($itemObj->CostID == COSTID_Bank) { $itemObj->TafsiliType = TAFTYPE_BANKS; $itemObj->TafsiliID = $_POST["TafsiliID"]; $itemObj->TafsiliType2 = TAFTYPE_ACCOUNTS; $itemObj->TafsiliID2 = $_POST["TafsiliID2"]; } if (!$itemObj->Add($pdo)) { echo Response::createObjectiveResponse(false, ExceptionHandler::GetExceptionsToString()); die; } $pdo->commit(); echo Response::createObjectiveResponse(true, ""); die; }
function DeleteCosts() { $obj = new WAR_costs(); $obj->CostID = $_POST["CostID"]; $result = $obj->Remove(); echo Response::createObjectiveResponse($result, ExceptionHandler::GetExceptionsToString()); die; }
function ConfirmPerson() { $PersonID = $_POST["PersonID"]; PdoDataAccess::runquery("update BSC_persons set IsConfirm='YES' where PersonID=?", array($PersonID)); //print_r(ExceptionHandler::PopAllExceptions()); echo Response::createObjectiveResponse(true, ""); die; }
function DeleteMessage() { if (!empty($_POST["SendID"])) { $obj = new OFC_MessageReceivers($_POST["SendID"]); $obj->IsDeleted = "YES"; } else { $obj = new OFC_messages($_POST["MessageID"]); $obj->IsDeleted = "YES"; } $obj->Edit(); echo Response::createObjectiveResponse(true, ""); die; }
function DelDev() { $return = manage_person_devotion::RemoveDevotion($_POST['PersonID'], $_POST['devotion_row']); if ($return !== true) { echo $return; die; } echo Response::createObjectiveResponse("true", $_POST['PersonID']); die; }
function removeSIR() { $return = manage_salary_item_report::Remove($_POST["sid"]); Response::createObjectiveResponse($return, !$return ? ExceptionHandler::popExceptionDescription() : ""); die; }
function CreateLoan() { $pdo = PdoDataAccess::getPdoObject(); $pdo->beginTransaction(); $obj = new LON_requests(); PdoDataAccess::FillObjectByArray($obj, $_POST); $obj->LoanID = 1; $obj->BranchID = $_SESSION["accounting"]["BranchID"]; $obj->ReqDate = PDONOW; $result = $obj->AddRequest($pdo); if (!$result) { $pdo->rollBack(); echo Response::createObjectiveResponse(false, "خطا در ایجاد وام"); die; } $pobj = new LON_ReqParts(); $pobj->RequestID = $obj->RequestID; PdoDataAccess::FillObjectByArray($pobj, $_POST); $pobj->PartDate = PDONOW; $pobj->PartDesc = "شرایط اولیه"; $pobj->PayInterval = 1; $pobj->FundWage = $pobj->CustomerWage; $result = $pobj->AddPart(); if (!$result) { $pdo->rollBack(); echo Response::createObjectiveResponse(false, "خطا در ایجاد شرایط وام"); die; } $pdo->commit(); echo Response::createObjectiveResponse(true, ""); die; }
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; }
function StartFlow() { $FlowID = $_REQUEST["FlowID"]; $ObjectID = $_REQUEST["ObjectID"]; $result = WFM_FlowRows::StartFlow($FlowID, $ObjectID); echo Response::createObjectiveResponse($result, ""); die; }
function DeletePlanEvents() { $obj = new PLN_PlanEvents(); $obj->EventID = $_POST["EventID"]; $result = $obj->Remove(); echo Response::createObjectiveResponse($result, ExceptionHandler::GetExceptionsToString()); die; }
function DelEmp() { $return = manage_person_employment::RemoveEmp($_POST['PersonID'], $_POST['row_no']); if ($return !== true) { echo $return; die; } echo Response::createObjectiveResponse("true", $_POST['PersonID']); die; }
function removebank() { $return = manage_bank::Remove($_POST["bid"]); Response::createObjectiveResponse($return, !$return ? ExceptionHandler::popExceptionDescription() : ""); die; }
function ImportHolidaysFromExcel() { require_once inc_phpExcelReader; $data = new Spreadsheet_Excel_Reader(); $data->setOutputEncoding('utf-8'); $data->setRowColOffset(0); $data->read($_FILES["attach"]["tmp_name"]); for ($i = 0; $i < $data->sheets[0]['numRows']; $i++) { $row = $data->sheets[0]['cells'][$i]; $obj = new ATN_holidays(); $obj->TheDate = DateModules::shamsi_to_miladi($row[0]); $obj->details = $row[1]; $result = $obj->Add(); } echo Response::createObjectiveResponse($result, ""); die; }
function Next_Corrective_Writ() { $obj = new manage_writ($_POST['writ_id'], $_POST['writ_ver'], $_POST['staff_id']); PdoDataAccess::FillObjectByArray($obj, $_POST); $ret = $obj->Next_Corrective_Writ(); if (!empty($ret->writ_id)) { echo Response::createObjectiveResponse(true, "{WID: " . $ret->writ_id . " , WVER: " . $ret->writ_ver . " , STF:" . $ret->staff_id . " }"); } else { echo Response::createResponse(false, "Stop"); } }
function Equalization_UpdateChecks() { $BankID = $_POST["BankID"]; $result = ""; require_once "phpExcelReader.php"; $data = new Spreadsheet_Excel_Reader(); $data->setOutputEncoding('utf-8'); $data->setRowColOffset(0); $data->read($_FILES["attach"]["tmp_name"]); $pdo = PdoDataAccess::getPdoObject(); $pdo->beginTransaction(); //--------------- add to equalizations ------------- $EqualObj = new ACC_equalizations(); $EqualObj->RegDate = PDONOW; $EqualObj->BankID = $BankID; $EqualObj->ImportFile = fread(fopen($_FILES["attach"]["tmp_name"], 'r'), $_FILES["attach"]["size"]); $EqualObj->Add($pdo); //----------- insert DocHeader -------------------- $obj = new ACC_docs(); $obj->RegDate = PDONOW; $obj->regPersonID = $_SESSION['USER']["PersonID"]; $obj->DocDate = PDONOW; $obj->CycleID = $_SESSION["accounting"]["CycleID"]; $obj->BranchID = $_SESSION["accounting"]["BranchID"]; $obj->DocType = DOCTYPE_EQUALCHECKS; $obj->description = "مغایرت گیری بانکی / به روز رسانی چک ها "; if (!$obj->Add($pdo)) { ExceptionHandler::PushException("خطا در ایجاد سند"); return false; } $successCount = 0; for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) { $checkNo = ""; switch ($BankID) { case "4": // اقتصاد نوین $TafsiliID = ""; $TafsiliID2 = ""; if (empty($data->sheets[0]['cells'][$i][1])) { continue; } $cellData = $data->sheets[0]['cells'][$i][1]; if (isset($cellData) && strpos(trim($cellData), "چک عادي ش.") !== false) { $arr = preg_split("/\\//", $cellData); $checkNo = $arr[2]; $checkNo = substr($checkNo, 0, strpos($checkNo, "صندوق پژوهش")); } break; } if ($checkNo == "") { continue; } //---------------- add doc items -------------------- $dt = PdoDataAccess::runquery("\r\n\t\t\tSELECT * FROM ACC_IncomeCheques \r\n\t\t\t\twhere ChequeNo=? AND ChequeStatus<>" . INCOMECHEQUE_VOSUL, array($checkNo), $pdo); if (count($dt) > 0) { $inChequeObj = new ACC_IncomeCheques($dt[0]["IncomeChequeID"]); $inChequeObj->EqualizationID = $EqualObj->EqualizationID; $inChequeObj->ChequeStatus = INCOMECHEQUE_VOSUL; $inChequeObj->Edit($pdo); $temp = $inChequeObj->GetBackPays($pdo); foreach ($temp as $row) { $BackPayObj = new LON_BackPays($row["BackPayID"]); $BackPayObj->EqualizationID = $EqualObj->EqualizationID; $BackPayObj->Edit($pdo); } ACC_IncomeCheques::AddToHistory($inChequeObj->IncomeChequeID, $inChequeObj->ChequeStatus, $pdo); RegisterOuterCheque($obj->DocID, $inChequeObj, $pdo, COSTID_Bank, $TafsiliID, $TafsiliID2); $successCount++; $result .= "شماره چک : " . $checkNo . " به روز رسانی شد <br>"; } else { $result .= "<font color=red> شماره چک : " . $checkNo . " یافت نشد </font><br>"; } } if ($successCount == 0) { $pdo->rollBack(); } else { $pdo->commit(); } echo Response::createObjectiveResponse(true, $successCount == 0 ? "هیچ چکی به روز نگردید" : $result); die; }
function DeleteTraffic() { $TrafficID = $_POST["TrafficID"]; PdoDataAccess::runquery("update ATN_traffic set IsActive='NO' where TrafficID=?", array($TrafficID)); echo Response::createObjectiveResponse(true, ""); die; }