function SignLetter() { $LetterID = $_POST["LetterID"]; $obj = new OFC_letters($LetterID); $result = false; if ($obj->SignerPersonID == $_SESSION["USER"]["PersonID"]) { $PersonObj = new BSC_persons($obj->SignerPersonID); $obj->IsSigned = "YES"; $obj->SignPostID = $PersonObj->PostID; $result = $obj->EditLetter(); } echo Response::createObjectiveResponse($result, ""); 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; }
$content .= "<br><b> رونوشت خارج از سازمان : " . $LetterObj->OuterCopies . "</b><br>"; } //.............................................................................. $imageslist = array(); $doc = DMS_documents::SelectAll("ObjectType='letter' AND ObjectID=?", array($LetterID)); if (count($doc) > 0) { $images = DMS_DocFiles::selectAll("DocumentID=?", array($doc[0]["DocumentID"])); foreach ($images as $img) { $imageslist[] = array("url" => "/office/dms/ShowFile.php?RowID=" . $img["RowID"] . "&DocumentID=" . $img["DocumentID"] . "&ObjectID=" . $LetterID, "fileType" => $img["FileType"]); } } $imageslist = json_encode($imageslist); //.............................................................................. $editable = false; if ($LetterObj->LetterType == "OUTCOME" && $LetterObj->IsSigned == "NO") { $dt = OFC_letters::SelectReceivedLetters(" AND l.LetterID=:lid", array(":lid" => $LetterID)); if ($dt->rowCount() > 0) { $editable = true; } } $signing = false; if ($LetterObj->LetterType == "OUTCOME" && $LetterObj->IsSigned == "NO" && $LetterObj->SignerPersonID == $_SESSION["USER"]["PersonID"]) { $signing = true; } ?> <script> LetterInfo.prototype = { TabID : '<?php echo $_REQUEST["ExtTabID"]; ?>
<?php //----------------------------- // Programmer : SH.Jafarkhani // Date : 1394.10 //----------------------------- require_once 'header.inc.php'; require_once inc_dataReader; require_once 'letter/letter.class.php'; require_once 'workflow/wfm.class.php'; $dt = OFC_letters::SelectReceivedLetters(" AND s.IsSeen='NO'"); $NewReceived = $dt->rowCount(); $dt = OFC_letters::SelectDraftLetters(); $DraftCount = count($dt); $dt = WFM_FlowRows::SelectReceivedForms(); $ReceiveForms = is_array($dt) ? count($dt) : $dt->rowCount(); $Messages = OFC_MessageReceivers::GetNewMessageReceiveCount(); ?> <script> OfficeStartPage.prototype = { TabID : '<?php echo $_REQUEST["ExtTabID"]; ?> ', address_prefix : "<?php echo $js_prefix_address; ?> ", get : function(elementID){