function tmp_trhistory($date3, $date4)
{
global $database, $form;
traceCalls(__METHOD__, __LINE__);
$path = getEditablePath('error.php');
include_once "editables/" . $path;
$date = fixdate;
if (empty($date3)) {
$form->setError("fromdate", $lang['error']['empty_fromdate']);
}
if (empty($date4)) {
$form->setError("todate", $lang['error']['empty_todate']);
}
if ($form->num_errors > 0) {
return 0;
}
$result1 = datecompare($date, $date3);
$result2 = datecompare($date3, $date4);
if (!$result1) {
$form->setError("fromdate", $lang['error']['invalid_fromdate']);
} else {
if (!$result2) {
$form->setError("todate", $lang['error']['lower_fromdate']);
}
}
if ($form->num_errors > 0) {
return 0;
} else {
$_SESSION['date1'] = $date3;
$_SESSION['date2'] = $date4;
return 1;
}
}
function getLenderDataForCompletedLoan($lenderid, $loanid)
{
global $db;
traceCalls(__METHOD__, __LINE__);
$qq = "SELECT l.active AS Loan_State, sum(lb.givenamount) AS AMT, l.summary, l.tr_summary FROM ! as l join ! as b on l.borrowerid = b.userid join ! as lb on l.loanid=lb.loanid WHERE lb.lenderid =? and l.loanid=? and lb.active =? and (l.active =? OR l.active =? OR l.loanid IN(select loan_id from ! where lender_id=?)) group by l.loanid";
$result = $db->getAll($qq, array('loanapplic', 'borrowers', 'loanbids', $lenderid, $loanid, 1, LOAN_REPAID, LOAN_DEFAULTED, 'forgiven_loans', $lenderid));
return $result;
}
function getTextResponseLength($userid)
{
global $db;
traceCalls(__METHOD__, __LINE__);
$q = "SELECT length(reffered_by) FROM ! WHERE userid = ? AND reffered_by IS NOT NULL";
$result = $db->getOne($q, array('borrowers', $userid));
return $result;
}
