Example #1
0
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;
}