function GetAccountFlow() { $CostID = $_REQUEST["BaseCostID"]; $TafsiliID = $_REQUEST["TafsiliID"]; $query = "select d.*,di.*\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 " . dataReader::makeOrder(); $param = array(":c" => $_SESSION["accounting"]["CycleID"], ":b" => $_SESSION["accounting"]["BranchID"], ":cost" => $CostID, ":t" => TAFTYPE_PERSONS, ":tid" => $TafsiliID); $temp = PdoDataAccess::runquery_fetchMode($query, $param); $no = $temp->rowCount(); //------------------------------------------------ $BlockedAmount = ACC_CostBlocks::GetBlockAmount($CostID, TAFTYPE_PERSONS, $TafsiliID); //------------------------------------------------ echo dataReader::getJsonData($temp->fetchAll(), $no, $_GET["callback"], $BlockedAmount); die; }
function BlockTrigger($pdo = null) { if (!isset($this->TafsiliType) || !isset($this->TafsiliID)) { return true; } $BlockedAmount = ACC_CostBlocks::GetBlockAmount($this->CostID, $this->TafsiliType, $this->TafsiliID, $pdo); if ($BlockedAmount > 0) { $temp = PdoDataAccess::runquery("select ifnull(sum(CreditorAmount-DebtorAmount),0) remain\n\t\t\t\tfrom ACC_DocItems join ACC_docs using(DocID)\n\t\t\t\twhere CycleID=? AND CostID=? AND TafsiliType=? AND TafsiliID=? AND ItemID<>?", array($_SESSION["accounting"]["CycleID"], $this->CostID, $this->TafsiliType, $this->TafsiliID, $this->ItemID), $pdo); if ($temp[0][0] * 1 - $BlockedAmount < $this->DebtorAmount * 1) { ExceptionHandler::PushException("مبلغ وارد شده بیشتر از مبلغ قابل برداشت می باشد " . "<br>مبلغ قابل برداشت : " . ($temp[0][0] * 1 - $BlockedAmount)); return false; } } return true; }