$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;