function SaveTemplate() { $pdo = PdoDataAccess::getPdoObject(); $pdo->beginTransaction(); $CorrectContent = CNT_templates::CorrectTemplateContentItems($_POST['TemplateContent']); $obj = new CNT_templates(); $obj->TemplateContent = $CorrectContent; $obj->TemplateTitle = $_POST['TemplateTitle']; if ($_POST['TemplateID'] > 0) { $obj->TemplateID = $_POST['TemplateID']; $result = $obj->Edit($pdo); } else { $result = $obj->Add($pdo); } if (!$result) { $pdo->rollBack(); print_r(ExceptionHandler::PopAllExceptions()); //echo PdoDataAccess::GetLatestQueryString(); echo Response::createObjectiveResponse(false, ExceptionHandler::GetExceptionsToString()); die; } $pdo->commit(); echo Response::createObjectiveResponse(true, $obj->TemplateID); die; }
function save() { $obj = new manage_professor_exe_posts(); PdoDataAccess::FillObjectByArray($obj, $_POST); $postObj = new manage_posts($obj->post_id); if ($postObj->post_id == "") { echo Response::createObjectiveResponse(false, "کد پست وارد شده معتبر نمی باشد."); die; } if ($postObj->validity_start != "" && $postObj->validity_start != '0000-00-00' && DateModules::CompareDate($postObj->validity_start, str_replace("/", "-", DateModules::shamsi_to_miladi($obj->from_date))) > 0 || $postObj->validity_end != "" && $postObj->validity_end != '0000-00-00' && ($obj->to_date != "" && $obj->to_date != "0000-00-00") && DateModules::CompareDate($postObj->validity_end, str_replace("/", "-", DateModules::shamsi_to_miladi($obj->to_date))) < 0) { echo Response::createObjectiveResponse(false, "پست انتخابی از نظر تاریخ اعتبار و تاریخ های شروع و پایان وارد شده معتبر نمی باشد."); die; } if (empty($obj->row_no)) { $return = $obj->ADD(); } else { $return = $obj->Edit(); } if (!$return) { echo Response::createObjectiveResponse($return, ExceptionHandler::GetExceptionsToString()); die; } if (isset($_POST["assign_post"])) { $return = $obj->assign_post(); } else { $return = $obj->release_post(); } echo Response::createObjectiveResponse($return, ExceptionHandler::GetExceptionsToString()); die; }
function deleteParam() { $obj = new manage_salary_params(); $obj->param_id = $_POST["param_id"]; echo $obj->RemoveParam($obj->param_id) ? "true" : ExceptionHandler::GetExceptionsToString("\n"); 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 SaveBase() { $obj = new manage_bases(); PdoDataAccess::FillObjectByJsonData($obj, $_POST["record"]); // بررسی گروه های تشویقی که بیشتر از 5 برای یک نفر نباشد /*if(in_array($obj->BaseType, array(27,23,24,21,3,4,5))) { $query = "select sum(BaseValue) from bases where PersonID=? AND BaseType in(27,23,24,21,3,4,5) AND BaseStatus = 'NORMAL' "; $st = PdoDataAccess::runquery($query, array($obj->PersonID)); if(count($st) > 0 && (int)$st[0][0] + (int)$obj->BaseValue > 5) { echo Response::createObjectiveResponse(false, "OverMaxCGroup"); die(); } }*/ //---------------------------- if (empty($obj->RowID)) { $obj->RegDate = PDONOW; $return = $obj->Add(); } else { unset($obj->RegDate); $return = $obj->Edit(); } if (!$return) { echo Response::createObjectiveResponse($return, ExceptionHandler::GetExceptionsToString()); die; } echo Response::createObjectiveResponse(true, ""); die; }
function removeCC() { $result = manage_cost_centers::Remove($_POST["cid"]); if (!$result) { Response::createObjectiveResponse(false, ExceptionHandler::GetExceptionsToString()); die; } else { Response::createObjectiveResponse(true, ""); die; } }
function AddTraffic() { $obj = new ATN_traffic(); $obj->TrafficDate = PDONOW; $obj->TrafficTime = DateModules::NowTime(); $obj->IsSystemic = "YES"; $obj->PersonID = $_SESSION["USER"]["PersonID"]; $result = $obj->Add(); //print_r(ExceptionHandler::PopAllExceptions()); echo Response::createObjectiveResponse($result, ExceptionHandler::GetExceptionsToString()); 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 SaveJob() { $obj = new manage_person_job(); PdoDataAccess::FillObjectByJsonData($obj, $_POST["record"]); $obj->FromDate = DateModules::Shamsi_to_Miladi($obj->FromDate); $obj->ToDate = DateModules::Shamsi_to_Miladi($obj->ToDate); if (empty($obj->RowNO)) { $return = $obj->AddJobHistory(); } else { $return = $obj->EditJobHistory(); } echo $return ? Response::createObjectiveResponse(true, $obj->RowNO) : Response::createObjectiveResponse(false, ExceptionHandler::GetExceptionsToString("\n")); die; }
function SaveBranch() { $obj = new manage_study_branch(); PdoDataAccess::FillObjectByJsonData($obj, $_POST["record"]); if (empty($obj->sbid)) { $return = $obj->Add(); } else { $return = $obj->Edit(); } if (!$return) { echo Response::createObjectiveResponse($return, ExceptionHandler::GetExceptionsToString()); die; } echo Response::createObjectiveResponse(true, ""); die; }
function saveTaxItem() { $obj = new manage_Tax_Table_Item(); PdoDataAccess::FillObjectByJsonData($obj, $_POST["record"]); $obj->tax_table_id = $_POST["tax_table_id"]; if ($obj->row_no == "") { $return = $obj->AddTaxItem($obj->tax_table_id); } else { $return = $obj->EditTaxItem($obj->tax_table_id, $obj->row_no); } if ($return) { echo Response::createResponse(true, $obj->tax_table_id, $obj->row_no); } else { echo Response::createResponse(false, ExceptionHandler::GetExceptionsToString()); } die; }
function saveMiscDoc() { //........ Fill object .............. $obj = new manage_person_misc_doc(); $arr = get_object_vars($obj); $KeyArr = array_keys($arr); for ($i = 0; $i < count($arr); $i++) { eval("\$obj->" . $KeyArr[$i] . " = (isset(\$_POST) && isset(\$_POST['" . $KeyArr[$i] . "'])) \r\n\t\t\t? \$_POST['" . $KeyArr[$i] . "'] : '';"); } $obj->PersonID = $_POST['PersonID']; $obj->doc_date = DateModules::Shamsi_to_Miladi($obj->doc_date); //.................................... if (empty($_POST["row_no"])) { $return = $obj->AddMiscDoc(); } else { $return = $obj->EditMiscDoc(); } echo $return ? Response::createObjectiveResponse(true, $obj->row_no) : Response::createObjectiveResponse(false, ExceptionHandler::GetExceptionsToString("\n")); die; }
$AccDocObj->AddItem($ACC_UnitID, $CostCodesArray[$ACC_pt]["38"], ($r_made_kharej_Az_shomool38 + $ExtraRoozMozd), $ACC_pt); $AccDocObj->AddItem($ACC_UnitID, $CostCodesArray[$ACC_pt]["extra"], $r_jazb_omana, $ACC_pt); $ACC_pt = ImportSalary::PERSON_TYPE_Contract; $AccDocObj->AddItem($ACC_UnitID, $CostCodesArray[$ACC_pt]["salary"], $gh_hoghoogh, $ACC_pt); $AccDocObj->AddItem($ACC_UnitID, $CostCodesArray[$ACC_pt]["overtime"], $gh_ezafeKar + $OverTimeGharardadi, $ACC_pt); $AccDocObj->AddItem($ACC_UnitID, $CostCodesArray[$ACC_pt]["OrgInsurance"], round($gh_bimeh_dastgah), $ACC_pt); $AccDocObj->AddItem($ACC_UnitID, $CostCodesArray[$ACC_pt]["GovInsurance"], $gh_bimeh_dolat, $ACC_pt); $AccDocObj->AddItem($ACC_UnitID, $CostCodesArray[$ACC_pt]["27"], ($gh_made_kharej_Az_shomool27 + $ExtraGharardadi), $ACC_pt); $AccDocObj->AddItem($ACC_UnitID, $CostCodesArray[$ACC_pt]["38"], ($gh_made_kharej_Az_shomool38 + $ExtraGharardadi), $ACC_pt); $AccDocObj->AddItem($ACC_UnitID, $CostCodesArray[$ACC_pt]["extra"], $gh_jazb_omana, $ACC_pt); if(ExceptionHandler::GetExceptionCount() > 0) { echo "مرکز هزینه : " . $title . "<br><hr><br>"; echo "<span style=color:red><h3>" . ExceptionHandler::GetExceptionsToString ("<br>") . "</h3></span>"; $AccError = true; } ExceptionHandler::PopAllExceptions(); } //</editor-fold> echo '<tr> <td>علمی مشروط</td> <td>' . $mp_hoghoogh . '</td> <td>' . ($mp_ezafeKar + $OverTimeMProf) . '</td> <td>' . round($mp_bimeh_dastgah) . '</td> <td>' . $mp_bimeh_dolat . '</td> <td>' . ($mp_made_kharej_Az_shomool + $ExtraMProf) . '</td> <td>' . $mp_jazb_omana . '</td> <td>' . ($mp_sum + $ExtraMProf + $OverTimeMProf) . '</td>
function saveDevData() { $obj = new manage_person_devotion(); PdoDataAccess::FillObjectByArray($obj, $_POST); $obj->PersonID = $_POST['PersonID']; $obj->from_date = DateModules::Shamsi_to_Miladi($_POST["from_date"]); $obj->to_date = DateModules::Shamsi_to_Miladi($_POST["to_date"]); $obj->letter_date = DateModules::Shamsi_to_Miladi($_POST["letter_date"]); $obj->amount = empty($obj->amount) ? "0" : $obj->amount; $obj->continous = !empty($obj->continous) ? $obj->continous : 0; $obj->enlisted = !empty($obj->enlisted) ? $obj->enlisted : 0; if (empty($_POST["devotion_row"])) { $return = $obj->AddDevotion(); } else { $return = $obj->EditDevotion(); } echo $return ? Response::createObjectiveResponse(true, $obj->devotion_row) : Response::createObjectiveResponse(false, ExceptionHandler::GetExceptionsToString("\n")); die; }
function DeleteCosts() { $obj = new WAR_costs(); $obj->CostID = $_POST["CostID"]; $result = $obj->Remove(); echo Response::createObjectiveResponse($result, ExceptionHandler::GetExceptionsToString()); die; }
function saveDepData() { $obj = new manage_person_dependency(); PdoDataAccess::FillObjectByArray($obj, $_POST); $obj->PersonID = $_POST['PersonID']; if (empty($_POST["row_no"])) { $return = $obj->AddDependency(); } else { $return = $obj->EditDependency(); } echo $return ? Response::createObjectiveResponse(true, $obj->row_no) : Response::createObjectiveResponse(false, ExceptionHandler::GetExceptionsToString("\n")); die; }
function removeIncHistory() { $obj = new manage_staff_include_history(); PdoDataAccess::FillObjectByJsonData($obj, $_POST["record"]); $return = $obj->Remove(); if ($return) { echo Response::createResponse(true, $obj->include_history_id); } else { echo Response::createResponse(false, ExceptionHandler::GetExceptionsToString()); } die; }
function DeleteSign() { $obj = new CNT_ContractSigns(); $obj->SignID = $_POST["SignID"]; $result = $obj->Remove(); echo Response::createObjectiveResponse($result, ExceptionHandler::GetExceptionsToString()); die; }
function SavePerson() { $obj = new BSC_persons(); PdoDataAccess::FillObjectByArray($obj, $_POST); if (isset($_SESSION["USER"]["portal"])) { $obj->PersonID = $_SESSION["USER"]["PersonID"]; } if (empty($obj->PersonID)) { $hash_cost_log2 = 8; $hasher = new PasswordHash($hash_cost_log2, true); $obj->UserPass = $hasher->HashPassword(md5("123456")); } if (isset($_SESSION["USER"]["framework"])) { $obj->IsAgent = !isset($_POST["IsAgent"]) ? "NO" : "YES"; $obj->IsCustomer = !isset($_POST["IsCustomer"]) ? "NO" : "YES"; $obj->IsStaff = !isset($_POST["IsStaff"]) ? "NO" : "YES"; $obj->IsShareholder = !isset($_POST["IsShareholder"]) ? "NO" : "YES"; $obj->IsSupporter = !isset($_POST["IsSupporter"]) ? "NO" : "YES"; $obj->IsExpert = !isset($_POST["IsExpert"]) ? "NO" : "YES"; } if ($obj->PersonID > 0) { $result = $obj->EditPerson(); } else { $result = $obj->AddPerson(); } echo Response::createObjectiveResponse($result, !$result ? ExceptionHandler::GetExceptionsToString() : ""); die; }
function DeleteCosts() { $obj = new LON_costs($_POST["CostID"]); $DocRecord = $obj->GetAccDoc(); if ($DocRecord) { if ($DocRecord["DocStatus"] != "RAW") { echo Response::createObjectiveResponse(false, "سند مربوطه تایید شده و قابل حذف نمی باشد"); die; } ACC_docs::Remove($DocRecord["DocID"]); } $result = $obj->Remove(); echo Response::createObjectiveResponse($result, ExceptionHandler::GetExceptionsToString()); die; }
function SaveAccount() { $account = new ACC_accounts(); PdoDataAccess::FillObjectByJsonData($account, $_POST['record']); $account->BankID = $_POST["BankID"]; if ($account->AccountID == '') { $res = $account->InsertAccount(); } else { $res = $account->UpdateAccount(); } //print_r(ExceptionHandler::PopAllExceptions()); Response::createObjectiveResponse($res, !$res ? ExceptionHandler::GetExceptionsToString() : ""); die; }
function saveItem() { $obj = new management_extra_bylaw_items(); PdoDataAccess::FillObjectByJsonData($obj, $_POST["record"]); $return = $obj->ReplaceItem(); if (!$return) { echo Response::createObjectiveResponse($return, ExceptionHandler::GetExceptionsToString()); die; } echo Response::createObjectiveResponse(true, ""); die; }
function DeletePost() { $obj = new BSC_posts($_POST["PostID"]); $res = $obj->Remove(); echo Response::createObjectiveResponse($res, ExceptionHandler::GetExceptionsToString()); die; }
function DeletePersonShift() { $obj = new ATN_PersonShifts($_POST["RowID"]); if ($obj->FromDate < DateModules::Now()) { echo Response::createObjectiveResponse(false, "این ردیف در تردد استفاده شده و قابل حذف نمی باشد"); die; } $result = $obj->Remove(); //print_r(ExceptionHandler::PopAllExceptions()); echo Response::createObjectiveResponse($result, ExceptionHandler::GetExceptionsToString()); 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 saveEducData() { //........ Fill object .............. $obj = new manage_person_education(); PdoDataAccess::FillObjectByArray($obj, $_POST); $obj->PersonID = $_POST['PersonID']; $obj->doc_date = DateModules::Shamsi_to_Miladi($obj->doc_date); $obj->certificated = empty($obj->certificated) ? "0" : $obj->certificated; //.................................... if ($_POST['sfid'] == "-1") { $obj->sfid = PDONULL; } if (!isset($_POST['sbid'])) { $obj->sbid = PDONULL; } if ($_POST['university_id'] == "-1") { $obj->university_id = PDONULL; } if ($_POST['country_id'] == "-1") { $obj->country_id = PDONULL; } if (empty($_POST["row_no"])) { $return = $obj->AddEducation(); } else { $return = $obj->EditEducation(); } echo $return ? Response::createObjectiveResponse(true, $obj->row_no) : Response::createObjectiveResponse(false, ExceptionHandler::GetExceptionsToString("\n")); die; }
function SaveLoanCheque() { $pdo = PdoDataAccess::getPdoObject(); $pdo->beginTransaction(); $DocID = ""; $cheques = json_decode($_POST["cheques"]); foreach ($cheques as $cheque) { $obj = new ACC_IncomeCheques(); PdoDataAccess::FillObjectByJsonData($obj, $cheque); $obj->ChequeStatus = INCOMECHEQUE_NOTVOSUL; if (!$obj->Add($pdo)) { echo Response::createObjectiveResponse(false, ExceptionHandler::GetExceptionsToString()); die; } //................. add back pays ........................ $bobj = new LON_BackPays(); $bobj->PayDate = $obj->ChequeDate; $bobj->IncomeChequeID = $obj->IncomeChequeID; $bobj->RequestID = $_POST["RequestID"]; $bobj->PayAmount = $obj->ChequeAmount; $bobj->PayType = BACKPAY_PAYTYPE_CHEQUE; $bobj->Add($pdo); //....................................................... ACC_IncomeCheques::AddToHistory($obj->IncomeChequeID, $obj->ChequeStatus, $pdo); //-------------------------------------------- $DocID = RegisterOuterCheque($DocID, $obj, $pdo); if (!$DocID) { print_r(ExceptionHandler::PopAllExceptions()); echo Response::createObjectiveResponse(false, ExceptionHandler::GetExceptionsToString()); die; } } $pdo->commit(); echo Response::createObjectiveResponse(true, ""); die; }
function deleteDoc() { require_once '../../../../accountancy/import/salary/salary.class.php'; $AccDocObj = new ImportSalary($_POST["pay_year"], $_POST["pay_month"]); if (!$AccDocObj->DeleteAccDoc($_POST["PersonType"] == "contract")) { $msg = ExceptionHandler::GetExceptionsToString(); } else { $msg = " پیش سند با موفقیت حذف شد"; } echo Response::createObjectiveResponse(true, $msg); die; }
function DeletePlanEvents() { $obj = new PLN_PlanEvents(); $obj->EventID = $_POST["EventID"]; $result = $obj->Remove(); echo Response::createObjectiveResponse($result, ExceptionHandler::GetExceptionsToString()); die; }
function SaveOperation() { $obj = new NTC_operations(); PdoDataAccess::FillObjectByArray($obj, $_POST); $obj->GroupLetter = isset($_POST["GroupLetter"]) ? "YES" : "NO"; $pdo = PdoDataAccess::getPdoObject(); $pdo->beginTransaction(); if (empty($obj->OperationID)) { $obj->OperationDate = PDONOW; $result = $obj->Add($pdo); } else { $result = $obj->Edit($pdo); } require_once "phpExcelReader.php"; $data = new Spreadsheet_Excel_Reader(); $data->setOutputEncoding('utf-8'); $data->setRowColOffset(0); $data->read($_FILES["PersonFile"]["tmp_name"]); for ($i = 0; $i < $data->sheets[0]['numRows']; $i++) { if (!empty($data->sheets[0]['cells'][$i][0])) { $PersonID = $data->sheets[0]['cells'][$i][0]; $dt = PdoDataAccess::runquery("select PersonID from BSC_persons where PersonID=?", array($PersonID)); if (count($dt) > 0) { $PersonObj = new NTC_persons(); $PersonObj->OperationID = $obj->OperationID; $PersonObj->PersonID = $PersonID; for ($j = 1; $j < count($data->sheets[0]['cells'][$i]); $j++) { eval("\$PersonObj->col{$j} = '" . $data->sheets[0]['cells'][$i][$j] . "';"); } $PersonObj->Add($pdo); } } } $dt = NTC_persons::Get(" AND OperationID=?", array($obj->OperationID), $pdo); if ($dt->rowCount() == 0) { $pdo->rollBack(); echo Response::createObjectiveResponse(false, "در فایل ارسالی هیچ فرد معتبری یافت نشد"); die; } $dt = $dt->fetchAll(); //----------- create letter ------------- if ($obj->SendType == "LETTER" && $obj->GroupLetter == "YES") { $LetterObj = new OFC_letters(); $LetterObj->LetterType = "INNER"; $LetterObj->LetterTitle = $obj->title; $LetterObj->LetterDate = PDONOW; $LetterObj->RegDate = PDONOW; $LetterObj->PersonID = $_SESSION["USER"]["PersonID"]; $LetterObj->context = $obj->context; if (!$LetterObj->AddLetter($pdo)) { ExceptionHandler::PushException("خطا در ثبت نامه"); } } //--------------------------------------- foreach ($dt as $row) { $context = $obj->context; for ($i = 1; $i < 10; $i++) { $context = preg_replace("/\\[col" . $i . "\\]/", $row["col" . $i], $context); } switch ($obj->SendType) { case "SMS": break; //------------------------------------------------------------------ //------------------------------------------------------------------ case "EMAIL": $email = $row["email"]; if ($email == "") { ExceptionHandler::PushException("فاقد ایمیل"); continue; } $result = SendEmail($email, $obj->title, $context); if (!$result) { ExceptionHandler::PushException("خطا در ارسال ایمیل"); } break; //------------------------------------------------------------------ //------------------------------------------------------------------ case "LETTER": if ($obj->GroupLetter == "NO") { $LetterObj = new OFC_letters(); $LetterObj->LetterType = "INNER"; $LetterObj->LetterTitle = $obj->title; $LetterObj->LetterDate = PDONOW; $LetterObj->RegDate = PDONOW; $LetterObj->PersonID = $_SESSION["USER"]["PersonID"]; $LetterObj->context = $context; $LetterObj->AddLetter($pdo); $SendObj = new OFC_send(); $SendObj->LetterID = $LetterObj->LetterID; $SendObj->FromPersonID = $LetterObj->PersonID; $SendObj->ToPersonID = $row["PersonID"]; $SendObj->SendDate = PDONOW; $SendObj->SendType = 1; if (!$SendObj->AddSend($pdo)) { ExceptionHandler::PushException("خطا در ثبت نامه"); } } else { $Cobj = new OFC_LetterCustomers(); $Cobj->LetterID = $LetterObj->LetterID; $Cobj->PersonID = $row["PersonID"]; $Cobj->IsHide = "NO"; $Cobj->LetterTitle = $obj->title; if (!$Cobj->Add($pdo)) { ExceptionHandler::PushException("خطا در ثبت ذینفع نامه"); } } break; //------------------------------------------------------------------ } if (ExceptionHandler::GetExceptionCount() == 0) { $PObj = new NTC_persons(); $PObj->RowID = $row["RowID"]; $PObj->IsSuccess = "YES"; if ($obj->SendType == "LETTER") { $PObj->LetterID = $LetterObj->LetterID; } $PObj->Edit($pdo); } } $pdo->commit(); //print_r(ExceptionHandler::PopAllExceptions()); echo Response::createObjectiveResponse($result, ExceptionHandler::GetExceptionsToString()); die; }