$where .= " AND " . $prefix . $key . " = :{$key}";
}
}
$whereParam[":{$key}"] = $value;
}
}
//.....................................
$where = "";
$whereParam = array();
MakeWhere($where, $whereParam);
$query = "select r.*,l.*,p.*,\r\n\t\t\t\tconcat_ws(' ',p1.fname,p1.lname,p1.CompanyName) ReqFullname,\r\n\t\t\t\tconcat_ws(' ',p2.fname,p2.lname,p2.CompanyName) LoanFullname,\r\n\t\t\t\tbi.InfoDesc StatusDesc,\r\n\t\t\t\tBranchName,\r\n\t\t\t\tTotalPayAmount,\r\n\t\t\t\tTotalInstallmentAmount\r\n\t\t\t\t\r\n\t\t\tfrom LON_requests r\r\n\t\t\tjoin LON_ReqParts p on(r.RequestID=p.RequestID AND p.IsHistory='NO')\r\n\t\t\tleft join LON_loans l using(LoanID)\r\n\t\t\tjoin BSC_branches using(BranchID)\r\n\t\t\tleft join BaseInfo bi on(bi.TypeID=5 AND bi.InfoID=StatusID)\r\n\t\t\tleft join BSC_persons p1 on(p1.PersonID=r.ReqPersonID)\r\n\t\t\tleft join BSC_persons p2 on(p2.PersonID=r.LoanPersonID)\r\n\t\t\tleft join (\r\n\t\t\t\tselect RequestID,sum(PayAmount) TotalPayAmount from LON_BackPays\r\n\t\t\t\tgroup by RequestID\t\t\t\r\n\t\t\t)t1 on(r.RequestID=t1.RequestID)\r\n\t\t\tleft join (\r\n\t\t\t\tselect RequestID,sum(InstallmentAmount) TotalInstallmentAmount \r\n\t\t\t\tfrom LON_installments\r\n\t\t\t\tgroup by RequestID\t\t\t\r\n\t\t\t)t2 on(r.RequestID=t2.RequestID)\r\n\t\t\twhere 1=1 " . $where . " \r\n\t\t\t\r\n\t\t\tgroup by r.RequestID\r\n\t\t\torder by " . $_POST["OrderBy"] . " " . $_POST["OrderByDirection"];
$dataTable = PdoDataAccess::runquery($query, $whereParam);
$query = PdoDataAccess::GetLatestQueryString();
for ($i = 0; $i < count($dataTable); $i++) {
$dt = array();
$returnArr = ComputePayments($dataTable[$i]["RequestID"], $dt);
$dataTable[$i]["remainder"] = count($returnArr) > 0 ? $returnArr[count($returnArr) - 1]["TotalRemainder"] : 0;
}
$rpg = new ReportGenerator();
$rpg->excel = !empty($_POST["excel"]);
$rpg->mysql_resource = $dataTable;
function endedRender($row, $value)
{
return $value == "YES" ? "خاتمه" : "جاری";
}
$rpg->addColumn("شماره وام", "RequestID");
$rpg->addColumn("نوع وام", "LoanDesc");
$rpg->addColumn("معرفی کننده", "ReqFullname");
$rpg->addColumn("تاریخ درخواست", "ReqDate", "dateRender");
$rpg->addColumn("مبلغ درخواست", "ReqAmount", "moneyRender");
$rpg->addColumn("مشتری", "LoanFullname");
<?php
include_once "../header.inc.php";
require_once 'request.class.php';
require_once 'request.data.php';
$temp = PdoDataAccess::runquery("select p.RequestID,PartID from LON_ReqParts p join LON_requests using(RequestID)\r\n\twhere IsEnded='YES'");
foreach ($temp as $row) {
$PartID = $row["PartID"];
$dt = array();
$returnArr = ComputePayments($PartID, $dt);
if (count($returnArr) > 0 && $returnArr[count($returnArr) - 1]["TotalRemainder"] * 1 > 0) {
PdoDataAccess::runquery("update LON_requests set IsEnded='NO', StatusID=70\r\n\t\t\twhere requestID=?", array($row["RequestID"]));
echo $row["RequestID"] . "<br>";
}
}
die;
