function SaveBlockData() { $block = new ACC_blocks(); pdoDataAccess::FillObjectByJsonData($block, $_POST['record']); if ($block->LevelID > 1) { $block->BlockCode = str_pad($block->BlockCode, 2, '0', STR_PAD_LEFT); } $newFlag = false; if ($block->BlockID == '') { $res = $block->AddBlock(); $newFlag = true; } else { $res = $block->EditBlock(); } if ($res) { PdoDataAccess::runquery("\n\t\tupdate ACC_CostCodes cc\n\t\t\tleft join ACC_blocks cb1 on cb1.BlockID = cc.Level1 \n\t\t\tleft join ACC_blocks cb2 on cb2.BlockID = cc.Level2 \n\t\t\tleft join ACC_blocks cb3 on cb3.BlockID = cc.Level3 \n\n\t\tset cc.CostCode = concat(\n\t\tcb1.BlockCode,\n\t\tifnull(concat('-',cb2.BlockCode),''),\n\t\tifnull(concat('-',cb3.BlockCode),'') )\n\n\t\twhere level" . $block->LevelID . " = " . $block->BlockID); } Response::createObjectiveResponse($res, $block->GetExceptionCount() != 0 ? $block->popExceptionDescription() : $block->BlockID); die; }
function SaveLetter($dieing = true) { $Letter = new OFC_letters(); pdoDataAccess::FillObjectByArray($Letter, $_POST); if ($Letter->RefLetterID != "") { $obj = new OFC_letters($Letter->RefLetterID); if (empty($obj->LetterID)) { Response::createObjectiveResponse(false, "شماره نامه عطف قابل بازیابی نمی باشد"); die; } } if ($Letter->LetterID == '') { $Letter->PersonID = $_SESSION["USER"]["PersonID"]; $Letter->LetterDate = PDONOW; $Letter->RegDate = PDONOW; $res = $Letter->AddLetter(); } else { $res = $Letter->EditLetter(); } if (!empty($_FILES["PageFile"]["tmp_name"])) { $st = preg_split("/\\./", $_FILES['PageFile']['name']); $extension = strtolower($st[count($st) - 1]); if (in_array($extension, array("jpg", "jpeg", "gif", "png", "pdf")) === false) { Response::createObjectiveResponse(false, "فرمت فایل ارسالی نامعتبر است"); die; } $dt = DMS_documents::SelectAll("ObjectType='letter' AND ObjectID=?", array($Letter->LetterID)); if (count($dt) == 0) { $obj = new DMS_documents(); $obj->DocType = 0; $obj->ObjectType = "letter"; $obj->ObjectID = $Letter->LetterID; $obj->AddDocument(); $DocumentID = $obj->DocumentID; } else { $DocumentID = $dt[0]["DocumentID"]; } //.............................................. $obj2 = new DMS_DocFiles(); $obj2->DocumentID = $DocumentID; $obj2->PageNo = PdoDataAccess::GetLastID("DMS_DocFiles", "PageNo", "DocumentID=?", array($DocumentID)) + 1; $obj2->FileType = $extension; $obj2->FileContent = substr(fread(fopen($_FILES['PageFile']['tmp_name'], 'r'), $_FILES['PageFile']['size']), 0, 200); $obj2->AddPage(); $fp = fopen(getenv("DOCUMENT_ROOT") . "/storage/documents/" . $obj2->RowID . "." . $extension, "w"); fwrite($fp, substr(fread(fopen($_FILES['PageFile']['tmp_name'], 'r'), $_FILES['PageFile']['size']), 200)); fclose($fp); } if ($dieing) { Response::createObjectiveResponse($res, $Letter->GetExceptionCount() != 0 ? $Letter->popExceptionDescription() : $Letter->LetterID); die; } return true; }