echo "<td>USD " . number_format($ln_bck_lndr_amt, 2) . "</td>"; echo '</tr>'; echo '<tr>'; echo "<td>{$desc17}</td>"; echo "<td>USD " . number_format($ln_bid_lndr_amt, 2) . "</td>"; echo '</tr>'; echo '<tr>'; echo "<td>{$desc3}</td>"; echo "<td>USD " . number_format($ln_snt_lndr_amt, 2) . "</td>"; echo '</tr>'; echo '<tr>'; echo "<td>{$desc7}</td>"; echo "<td>USD\t" . number_format($ln_bck_amt, 2); foreach ($bCountries as $bcont) { if ($bcont['ln_bck_amt_total'] != 0) { echo "<br/>" . $bcont['Currency'] . " " . number_format(round_local($bcont['ln_bck_amt_total']), 0) . " (" . $bcont['name'] . ")"; } } echo "</td>"; echo '</tr>'; /*echo'<tr>'; echo"<td>$desc18</td>"; echo"<td> USD ".number_format($feeByAnonymous, 2)."</td>"; echo '</tr>'; */ ?> </tbody> </table> <!-- </div> --> <br/>
<tr> <td colspan="2"><br/><strong><?php echo $lang['loanstatn']['repay_due'] . " " . date("M d, Y", time()); ?> :</strong>  <?php echo $tmpcurr . " " . number_format($schedule['due'], 0, '', ','); ?> </td> </tr> <tr> <td colspan="2"><strong><?php echo $lang['loanstatn']['totrepay_due'] . " " . date("M d, Y", time()); ?> :</strong>  <?php if ($show_localcurrency) { echo $tmpcurr . " " . number_format(round_local($schedule['amtPaidTillShow']), 0, '.', ','); } else { echo $tmpcurr . " " . number_format($schedule['amtPaidTillShow'], 0, '', ','); } ?> </td> </tr> <?php if ($brw2['active'] == LOAN_ACTIVE && $session->userlevel == LENDER_LEVEL && $database->isLenderInThisLoan($ld, $session->userid)) { $totalForgivenLenders = $database->totalForgivenLendersThisLoan($ld); if ($totalForgivenLenders > 0) { if ($totalForgivenLenders == 1) { $strText1 = convertNumber2word($totalForgivenLenders) . " lender has forgiven this loan."; } else { $strText1 = convertNumber2word($totalForgivenLenders) . " lenders have forgiven this loan."; }
<td><strong><?php echo $lang['loanstatn']['repay_due'] . " " . date("M d, Y ", time()); ?> :</strong></td> <td><?php echo number_format(round_local($schedule['due']), 0, '.', ',') . " " . $tmpcurr; ?> </td> </tr> <tr> <td><strong><?php echo $lang['loanstatn']['totrepay_due'] . " " . date("M d, Y ", time()); ?> :</strong></td> <td><?php echo number_format(round_local($schedule['amtPaidTillShow']), 0, '.', ',') . "</b> " . $tmpcurr; ?> </td> </tr>--> </tbody> </table> <?php echo $schedule['schedule']; ?> </div><!-- /bid-table --> </div><!-- /row --> <?php } } else { echo "No Transaction Yet"; }
function getAuthLoanAmount($userid, $loanid = 0, $native = true) { global $db; if ($loanid == 0) { $q = "SELECT reqdamt FROM loanapplic WHERE borrowerid={$userid} AND adminDelete = 0 ORDER BY loanid DESC "; } else { $q = "SELECT reqdamt FROM loanapplic WHERE borrowerid={$userid} AND adminDelete = 0 AND loanid = {$loanid}"; } $result = $db->getOne($q); if (empty($result)) { return 0; } if ($native) { $rate = $this->getAuthorisedRate($userid, $loanid); // changed dby Mohit $amt = round_local($result * $rate); return $amt; } else { return $result; } }
function generateScheduleTable($ud, $ld, $displyall = 0, $disburseRate = 0) { global $database; $path = getEditablePath('loanstatn.php'); include FULL_PATH . "editables/" . $path; $schedule = $database->getSchedulefromDB($ud, $ld); $actualSchedule = $database->getRepaySchedulefromDB($ud, $ld); $gracePeriod = $database->gerGracePeriod($ld); $UserCurrency = $database->getUserCurrency($ud); if (!empty($disburseRate)) { $CurrencyRate = $disburseRate; } else { $CurrencyRate = $database->getCurrentRate($ud); } $rtnArray = array(); if (empty($schedule)) { $rtnArray['schedule'] = ''; $rtnArray['due'] = 0; $rtnArray['amtPaidTillShow'] = 0; } else { if ($displyall) { $tmpcurr = $UserCurrency; } else { $tmpcurr = 'USD'; } $text = "<table width = 100% class='zebra-striped'>\r\n\t\t\t<tr>\r\n\t\t\t\t<th>" . $lang['loanstatn']['date'] . "</th>\r\n\t\t\t\t<th>" . $lang['loanstatn']['due_amount'] . "</th>\r\n\t\t\t\t<th>" . $lang['loanstatn']['datepaid'] . "</th>\r\n\t\t\t\t<th>" . $lang['loanstatn']['paid_amount'] . " <a style='cursor:pointer' class='tt'><img src='library/tooltips/help.png' style='border-style:none;' /><span class='tooltip'><span class='top'></span><span class='middle'>" . $lang['loanstatn']['paidAmt_tooltip'] . "</span><span class='bottom'></span></span></a></th>\r\n\t\t\t</tr>"; $printSchedule = array(); $paidBalance = 0; $totalDueAmt = 0; $totalDueAmtUsd = 0; $totalPaidAmt = 0; $totalPaidAmtUsd = 0; $amtDueTill = 0; $amtPaidTill = 0; $amtDueTillUsd = 0; for ($i = 0, $j = 0; $i < count($schedule); $i++) { $totalDueAmt += $schedule[$i]['amount']; $printSchedule[$i]['dueAmt'] = $schedule[$i]['amount']; $printSchedule[$i]['dueDate'] = $schedule[$i]['duedate']; if ($schedule[$i]['duedate'] < time()) { $amtDueTill += $schedule[$i]['amount']; } $inst = 0; $inst = $schedule[$i]['amount']; while ($paidBalance > 0) { if ($inst > 0) { if ($inst <= $paidBalance) { $printSchedule[$i]['sub'][][$actualSchedule[$j - 1]['paiddate']] = $inst; $paidBalance = number_format($paidBalance - $inst, 6, '.', ''); $inst = 0; break; } else { $printSchedule[$i]['sub'][][$actualSchedule[$j - 1]['paiddate']] = $paidBalance; $inst = number_format($inst - $paidBalance, 6, '.', ''); $paidBalance = 0; } } else { break; } } if ($paidBalance == 0) { for ($k = 0; $j < count($actualSchedule); $j++) { if ($inst > 0) { if ($inst <= $actualSchedule[$j]['paidamt']) { $printSchedule[$i]['sub'][][$actualSchedule[$j]['paiddate']] = $inst; /*Pranjal Change 26 Jan When there are 2 small payments on the same date the schedule does not show correct data Example loain id 206*/ //$printSchedule[$i]['sub'][$actualSchedule[$j]['paiddate']]+=$inst; $paidBalance = number_format($actualSchedule[$j]['paidamt'] - $inst, 6, '.', ''); $j++; break; } else { $printSchedule[$i]['sub'][][$actualSchedule[$j]['paiddate']] = $actualSchedule[$j]['paidamt']; $inst = number_format($inst - $actualSchedule[$j]['paidamt'], 6, '.', ''); } } else { break; } } } if ($i == count($schedule) - 1 && $paidBalance > 0) { if (isset($printSchedule[$i]['sub'])) { $pos = count($printSchedule[$i]['sub']) - 1; $printSchedule[$i]['sub'][$pos][$actualSchedule[count($actualSchedule) - 1]['paiddate']] += $paidBalance; } else { $printSchedule[$i]['sub'][0][$actualSchedule[count($actualSchedule) - 1]['paiddate']] = $paidBalance; } } } $totalDueAmtUsd += convertToDollar($totalDueAmt, $CurrencyRate); $amtDueTillUsd += convertToDollar($amtDueTill, $CurrencyRate); for ($i = 0; $i < count($printSchedule); $i++) { if ($i < $gracePeriod) { continue; } $text = $text . "<tr> "; $text = $text . "<td style='text-align:left; width:20%'>" . date('M d, Y', $printSchedule[$i]['dueDate']) . "</td>"; if ($displyall) { $text = $text . "<td style='text-align:left; width:20%'>" . number_format(round_local($printSchedule[$i]['dueAmt']), 0, '.', ',') . "</td>"; } else { $text = $text . "<td style='text-align:left; width:20%'>" . number_format(convertToDollar($printSchedule[$i]['dueAmt'], $CurrencyRate), 2, '.', ',') . "</td>"; } if (isset($printSchedule[$i]['sub'])) { $j = 0; foreach ($printSchedule[$i]['sub'] as $sub) { foreach ($sub as $key => $value) { $totalPaidAmt += $value; if ($key < time()) { $amtPaidTill += $value; } if ($j > 0) { $text = $text . "<tr> "; $text = $text . "<td style='text-align:left; width:20%'> </td>"; $text = $text . "<td style='text-align:left; width:20%'> </td>"; } $text = $text . "<td style='text-align:left; width:20%'>" . date('M d, Y', $key) . "</td>"; if ($displyall) { $amtPaidShow = number_format(round_local($value), 0, '.', ','); $text = $text . "<td style='text-align:left; width:20%'>" . $amtPaidShow . "</td>"; } else { $amtPaidShow = convertToDollar($value, $CurrencyRate); } if (count($printSchedule[$i]['sub']) > 1) { if ($j % 2 == 0) { $amtPaidShow = round_up($amtPaidShow, 2); } else { $amtPaidShow = round_down($amtPaidShow, 2); } } if (!$displyall) { $text = $text . "<td style='text-align:left; width:20%'>" . number_format($amtPaidShow, 2, '.', ',') . "</td>"; } $text = $text . " </tr>"; if ($j > 0) { $text = $text . "</tr> "; } $j++; } } } else { $text = $text . "<td style='text-align:left; width:20%'> </td>"; $text = $text . "<td style='text-align:left; width:20%'> </td>"; $text = $text . " </tr>"; } } $totalPaidAmtUsd = convertToDollar($totalPaidAmt, $CurrencyRate); $amtPaidTillUsd = convertToDollar($amtPaidTill, $CurrencyRate); $text = $text . "<tfoot>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t<th>" . $lang['loanstatn']['tot_amount'] . "</th>"; if ($displyall) { $text = $text . "<th>" . number_format(round_local($totalDueAmt), 0, '.', ',') . "</th>"; } else { $text = $text . "<th>" . number_format($totalDueAmtUsd, 2, '.', ',') . "</th>"; } $text = $text . "<th>" . $lang['loanstatn']['tot_paid_amount'] . "</th>"; if ($displyall) { $text = $text . "<th>" . number_format($totalPaidAmt, 0, '.', ',') . "</th>"; // round_local($totalPaidAmt) } else { $text = $text . "<th>" . number_format($totalPaidAmtUsd, 2, '.', ',') . "</th>"; } $text = $text . "</tr></tfoot>"; $text = $text . "</table>"; $rtnArray['schedule'] = $text; if ($displyall) { $due = $amtDueTill - $amtPaidTill; $amtPaidTillShow = $amtPaidTill; $amtRemaining = $totalDueAmt - $totalPaidAmt; } else { $due = $amtDueTillUsd - $amtPaidTillUsd; $amtPaidTillShow = $amtPaidTillUsd; $amtRemaining = $totalDueAmtUsd - $totalPaidAmtUsd; } if ($due < 0) { $due = 0; } if ($amtRemaining < 0) { $amtRemaining = 0; } $rtnArray['amtPaidTillShow'] = $amtPaidTillShow; $rtnArray['amtRemaining'] = $amtRemaining; $rtnArray['due'] = $due; } return $rtnArray; }
if (!empty($note)) { $editlink = "<a href='javascript:void(0)' onclick='editnotes({$userid})'>edit</a>"; } $navigate_away_ids[] = 'note' . $userid; $navigate_away_ids_values[] = ''; echo "<td><div id ='editdiv{$userid}'>{$note}</div><div id='editlink{$userid}'>{$editlink}</div><br/>\n\t\t\t\t\t\t\t<textarea name='note' id='note{$userid}' col='6' row='6' style='height: 80px' ></textarea>\n\t\t\t\t\t\t\t\t\t<input type='hidden' name='borrowerid' id='borrower{$userid}' value='{$userid}'>\n\t\t\t\t\t\t\t\t\t<input type='hidden' name='loanid' id='loan{$userid}' value='{$loanid}'>\n\n\t\t\t\t\t\t\t\t</td>"; echo "<input name='isedit' type = 'hidden' value='0' id = 'isedit{$userid}'>"; echo '</tr>'; } else { if ($assignedto == 0) { if ($dueamt <= 0 || $dueamtUSD < $repayThresholdAmt && $row['totpaidamt'] > 0) { continue; } $dueamtTot += $dueamt; $dueamtToSort = number_format(round_local($dueamt), 2, '.', ''); $dueamt = number_format(round_local($dueamt), 0, '.', ','); $bcity = $row['city']; $address = $row['Paddress']; echo "<tr id='rowid{$userid}' >"; echo "<td>Member Name:<br/><br/>{$bname}<br/><br/><br/>Member Telephone:<br/><br/>{$brwrnumbr}</td>"; echo "<td><span style='display:none'>{$bcity}</span>{$bcity}<br/><br/>{$address}</td>"; echo "<td><span style='display:none'>{$dueamtToSort}</span>Amount Past Due:<br/><br/> {$currency} {$dueamt}</td>"; echo "<td><span style='display:none'>{$duedatetosort}</span>Past Due Since:<br/><br/>{$duedate}<br/><br/><br/><a href=index.php?p=37&l={$loanid}&u={$userid}>View Repayment Schedule</a></td>"; //echo "<td>$brwrnumbr</td>"; echo "<td><div>Community Leader Name:<br/><br/></div>"; ?> <?php $navigate_away_ids[] = 'refname' . $userid; $navigate_away_ids_values[] = ''; ?> <input type='text' readonly="readonly" style='width: 100px;' id="<?php
<tfoot> <tr> <th><?php echo $lang['loanstatn']['tot_amount']; ?> </th> <th><?php echo number_format(round_local($amtDue), 0, '.', ','); ?> </th> <th><?php echo $lang['loanstatn']['tot_paid_amount']; ?> </th> <th><?php echo number_format(round_local($amtPaid), 0, '.', ','); ?> </th> </tr> </tfoot> </table> <form method="post" action="updateprocess.php" onsubmit="disablemultiplesubmit();"> <?php $_SESSION['value_array'] = $form->values; $_SESSION['error_array'] = $form->getErrorArray(); ?> <table class="detail"> <tbody> <tr style='display:none'> <td> <input type='hidden' name='original_period' value='<?php
$country = "US"; } elseif ($row['txn_type'] == DONATION && isset($row['txn_sub_type']) && $row['txn_sub_type'] == DONATE_BY_ADMIN) { $txnamtinus = number_format($row['amount'], 2); $desc = "Expired Lender Account Converted to Donation"; $country = "US"; } } logger('trhistory display txn description end'); /*Txn description and country stuff end */ //if($row['userlevel']==LENDER_LEVEL) if ($userLevel == LENDER_LEVEL) { $txnamtinus = number_format($row['amount'], 2); $txnid = "<a href='index.php?p=16&u={$userid}' target='_blank'>" . $row['id'] . "</a>"; } else { if ($userLevel == BORROWER_LEVEL) { $txnamt = number_format(round_local($row['amount']), 0); $txnamt = $txnamt . " (" . $row['currency'] . ")"; $txnamtinus = number_format($row['amount'] / $row['conversionrate'], 2); $loanid = $row['loanid']; $txnid = "<a href='index.php?p=37&l={$loanid}&u={$userid}' target='_blank'>" . $row['id'] . "</a>"; } else { if ($userLevel == null || $userLevel == "") { $txnamtinus = number_format($row['amount'], 2); $txnid = $row['id']; } else { $txnid = $row['id']; } } } if ($row['txn_type'] == FEE) { $loanid = $row['loanid'];
<td><strong><?php echo $lang['loanstatn']['tot_int_and_fee']; ?> :</strong></td> <td><?php echo number_format(round_local($totFee), 0, '.', ',') . " " . $tmpcurr . " (" . number_format($totIntr, 0, '.', ',') . "% " . $lang['loanstatn']['intrst_rate_text'] . ' ' . $period . ' ' . $periodText . ")"; ?> </td> </tr> <tr> <td><strong><?php echo $lang['loanstatn']['tot_repay_due_orig']; ?> :</strong></td> <td><?php echo number_format(round_local($amtTotal), 0, '.', ',') . " " . $tmpcurr; ?> </td> </tr> <tr><td colspan=2><br/></td></tr> <tr> <td colspan=2><strong><?php echo $lang['loanstatn']['org_repay_schedule']; ?> :</strong></td> </tr> </tbody> </table> <?php echo $schedule['schedule'];
<td><a href="javascript:void(0)">fake name</a></td> <td><span style="display:none">24000.00</span>24,000</td> <td><span style="display:none">1338124710</span>May 27, 2012</td><td>779595532</td><td> <div>Name</div> <input type="text" style="width: 100px;" value="fake" > <div>Telephone number</div> <input type="text" style="width: 100px;" value="99999999"> </td><td><input style="width: 70px;" name="exdate" type="text" value="07/31/2012"><span style="display:none">1343692800</span></td><td><textarea name="note" id="note188" col="6" row="6" style="height: 80px">fake row content in textarea</textarea> </td><td> <span></span> </td> </tr> </tbody> </table> <strong>Total Amount Overdue <?php echo number_format(round_local($dueamtTot), 0, '.', ',') . " (" . $currency . ")"; ?> </strong><br/><br/> <strong>Recommendation Forms are no longer accepted from the following Community Leaders:</strong><br /><br /> <strong>Kenya:</strong><br /><br /> Elias Konde, tel. 0720588318<br /> Pst. John Opiyo, tel. 0720823379<br /> Pst. George Ombati, tel. 0778420402 or 0778640604<br /> Euphraim Kasinga, tel. 0716771316, 0728723251 or 0771885224<br /> Muguu Tupu Foundation, tel. 0705693769<br /> nicholas opondo, 0719772097<br /> Rev. Livingstone Kipkemei, tel. 0723993844<br /> George Kamunge, tel. 0771271963<br /> Pastor Charles Maingi, tel. 0789277834<br />
echo $lang['referral']['commission_amount']; ?> </strong></th> <th><strong><?php echo $lang['referral']['payment_date']; ?> </strong></th> </tr> </thead> <tbody> <?php $set = $database->getPaidCommissions($session->userid); foreach ($set as $row) { $applicant_id = $row['applicant_id']; $referrer_id = $row['referrer_id']; $paid_amt = number_format(round_local($row['paid_amt']), 0, '.', ','); $paid_date = date('d M Y', $row['paid_date']); $applicant_name = $database->getNameById($applicant_id); $referrer_name = $database->getNameById($referrer_id); $currency = $database->getUserCurrency($referrer_id); $refurl = getUserProfileUrl($referrer_id); $aplcurl = getUserProfileUrl($applicant_id); echo "<tr align='center'>"; echo "<td><a href='{$aplcurl}'>{$applicant_name}</a></td>"; echo "<td><a href='{$refurl}'>{$referrer_name}</a></td>"; echo "<td>{$paid_amt} ({$currency})</td>"; echo "<td>{$paid_date}</td>"; echo "</tr>"; } if (empty($set)) { echo "<tr align='center'><td colspan=5>No Data</td></tr>";