static function UpdateIsSeen($SendID)
{
$obj = new OFC_send($SendID);
if ($obj->ToPersonID != $_SESSION["USER"]["PersonID"]) {
return false;
}
$obj->IsSeen = "YES";
return $obj->EditSend();
}
require_once inc_dataReader;
require_once '../dms/dms.class.php';
$LetterID = !empty($_POST["LetterID"]) ? $_POST["LetterID"] : "";
if (empty($LetterID)) {
die;
}
$dt = OFC_send::GetAll("LetterID=?", array($LetterID));
if (count($dt) == 0) {
require_once 'NewLetter.php';
die;
}
$ForView = isset($_POST["ForView"]) && $_POST["ForView"] == "true" ? true : false;
$LetterObj = new OFC_letters($LetterID);
//..............................................................................
if (!empty($_REQUEST["SendID"])) {
OFC_send::UpdateIsSeen($_REQUEST["SendID"]);
}
//..............................................................................
$letterYear = substr(DateModules::miladi_to_shamsi($LetterObj->LetterDate), 0, 4);
$content = "<br><div style=margin-left:30px;float:left; >شماره نامه : " . "<span dir=ltr>" . $letterYear . "-" . $LetterObj->LetterID . "</span>" . "<br>تاریخ نامه : " . DateModules::miladi_to_shamsi($LetterObj->LetterDate);
if ($LetterObj->LetterType == "INCOME") {
$content .= "<br>شماره نامه وارده : " . $LetterObj->InnerLetterNo;
$content .= "<br>تاریخ نامه وارده : " . DateModules::miladi_to_shamsi($LetterObj->InnerLetterDate);
}
if ($LetterObj->RefLetterID != "") {
$refObj = new OFC_letters($LetterObj->RefLetterID);
$RefletterYear = substr(DateModules::miladi_to_shamsi($refObj->LetterDate), 0, 4);
$content .= "<br>عطف به نامه : <a href=javascript:void(0) onclick=LetterInfo.OpenRefLetter(" . $LetterObj->RefLetterID . ")>" . "<span dir=ltr>" . $RefletterYear . "-" . $LetterObj->RefLetterID . "</span></a>";
}
$content .= "</div><br><br>";
$content .= "<b><br><div align=center>بسمه تعالی</div><br>";
function DeleteSend()
{
$mode = $_POST["mode"];
$LetterID = $_POST["LetterID"];
$SendID = $_POST["SendID"];
$obj = new OFC_send($SendID);
if ($obj->ToPersonID == $_SESSION["USER"]["PersonID"]) {
$obj->IsDeleted = $mode == "1" ? "NO" : "YES";
$obj->EditSend();
}
echo Response::createObjectiveResponse(true, "");
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;
}
