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