function GetRequestParts() { if (empty($_REQUEST["RequestID"])) { echo dataReader::getJsonData(array(), 0, $_GET["callback"]); die; } $RequestID = $_REQUEST["RequestID"]; $dt = LON_ReqParts::SelectAll("RequestID=?", array($RequestID)); $CostCode_commitment = 165; // 200-05 for ($i = 0; $i < count($dt); $i++) { $temp = PdoDataAccess::runquery("select ifnull(sum(CreditorAmount),0)\r\n\t\t\tfrom ACC_DocItems join ACC_docs using(DocID) where \r\n\t\t\t CostID=? AND SourceType=" . DOCTYPE_LOAN_PAYMENT . " AND \r\n\t\t\tSourceID=? AND SourceID2=? AND DocStatus in('CONFIRM','ARCHIVE')", array($CostCode_commitment, $dt[$i]["RequestID"], $dt[$i]["PartID"])); $dt[$i]["IsPaid"] = $temp[0][0] == $dt[$i]["PartAmount"] ? "YES" : "NO"; $temp = PdoDataAccess::runquery("select count(*)\r\n\t\t\tfrom ACC_DocItems join ACC_docs using(DocID) where \r\n\t\t\t CostID=? AND SourceType=" . DOCTYPE_LOAN_PAYMENT . " \r\n\t\t\t\t AND DocStatus in('CONFIRM','ARCHIVE') AND SourceID=? AND SourceID2=? ", array($CostCode_commitment, $dt[$i]["RequestID"], $dt[$i]["PartID"])); $dt[$i]["IsDocRegister"] = $temp[0][0] * 1 > 0 ? "YES" : "NO"; $dt[$i]["IsStarted"] = WFM_FlowRows::IsFlowStarted(1, $dt[$i]["PartID"]) ? "YES" : "NO"; $dt[$i]["IsEnded"] = WFM_FlowRows::IsFlowEnded(1, $dt[$i]["PartID"]) ? "YES" : "NO"; } echo dataReader::getJsonData($dt, count($dt), $_GET["callback"]); die; }