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