include '../conf/db_connect.php'; connect(); $start = $_POST['start_date']; $start = strtotime($start); $end = $_POST['end_date']; $end = strtotime($end); $top1 = ''; $top = "\n<div class=box>\n<div class=box-body no-padding>\n<table class=table id=tableentry>\n<thead>\n <tr>\n <th>S/N</th>\n <th>NAME</th>\n <th>AMOUNT</th>\n <th>AMT_MNT</th>\n <th>DATE</th>\n </tr>\n</thead>\n<tbody>"; $body = ''; $result = query("SELECT * FROM payment"); $i = 0; while ($row = mysql_fetch_array($result)) { ++$i; $amount = $row['amount_pay']; $id = $row['emp_no']; $name = get_teller_name($id); $date1 = $row['date']; $date = strtotime($date1); $amt = $row['amort_loan'] + $row['amort_interest']; if ($date >= $start && $date <= $end) { $total_loan_recovered += $row['amount_pay']; $total_interest += $row['amort_interest']; $top1 = "<div class=box>\n <div class=box-body no-padding>\n <table class=table>\n <thead>\n <tr>\n <td>\n <strong><h4>LOAN RECOVERY MONTHLY REPORT</h4></strong>\n </td>\n </tr>\n </thead>\n <tr>\n <th>\n Total Loan Recovered:\n </th>\n <td>\n {$total_loan_recovered}\n </td>\n </tr>\n <tr>\n <th>\n Total Interest Recieved\n </th>\n <td>\n {$total_interest_recieved}\n </td>\n </tr>\n </table>\n </div>\n </div>"; $top1 .= $top; $body .= "<tr>\n<td>{$i}</td>\n<td>{$name}</td>\n<td>{$amount}</td>\n<td>{$amt}</td>\n<td>{$date1}</td>\n</tr>"; } } $end = "</tbody></table></div></div>"; $htm = $top1 . $body . $end; echo $htm;
<?php include 'conf/db_connect.php'; connect(); $start = $_POST['start_date']; $start = strtotime($start); $end = $_POST['end_date']; $end = strtotime($end); $top = "\n<table class=table id=tableentry>\n<thead>\n <tr>\n <th>S/N</th>\n <th>ACCT NO</th>\n <th>AMOUNT</th>\n <th>BALANCE</th>\n <th>TELLER</th>\n <th>DATE</th>\n </tr>\n</thead>\n<tbody>"; $body = ' '; $type = ''; $result = query("SELECT * FROM deposit"); $i = 0; while ($row = mysql_fetch_array($result)) { $t_id = $row['teller_id']; $name = get_teller_name($t_id); $date1 = $row['date']; ++$i; $date = strtotime($date1); $acct_no = $row['acct_no']; $bal = $row['balance']; $amount = $row['amount']; if ($date >= $start && $date <= $end) { $body .= "<tr>\n<td>{$i}</td>\n<td><a href=index.php?page=../dep_witd&id={$acct_no}> {$acct_no}</a></td>\n<td>{$amount}</td>\n<td>{$bal}</td>\n<td>{$name}</td>\n<td>{$date1}</td>\n</tr>"; } } $end = "</tbody></table>"; $htm = $top . $body . $end; echo $htm;
return $tm; } $body = ''; $start = $_POST['start_date']; $start = strtotime($start); $end = $_POST['end_date']; $end = strtotime($end); $result = query("SELECT * FROM account LEFT JOIN acct_type ON account.acct_type = acct_type.id"); $i = 0; while ($row = mysql_fetch_array($result)) { $date = $row['d_opened']; $time = strtotime($date); if ($time >= $start && $time <= $end) { ++$i; $member_id = $row['emp_id']; $name = get_teller_name($member_id); $acct_no = $row['acct_no']; $acct_type = $row['name']; $monthly = $row['save_amt']; $amt_todate = $row['amt_todate']; $date = $row['d_opened']; $balance = $row['balance']; $body .= "<tbody>\n <tr>\n <td>{$i};</td>\n <td>{$name};</td>\n <td><a href=index.php?page=../dep_witd&id={$acct_no}>{$acct_no}</a></td>\n <td>{$acct_type}</td>\n <td>{$monthly}</td>\n <td>{$amt_todate}</td>\n <td>{$balance}</td>\n <td>{$date}</td>\n\n </tr>\n </tbody>"; } } $thrift = no_accounts($start, $end)[1]; $special = no_accounts($start, $end)[2]; $total = $thrift + $special; $top = "\n<div class=box>\n<div class=box-body no-padding>\n<table class=table>\n <thead>\n <tr>\n\n <td>\n <strong><h4>ACCOUNT MONTHLY REPORT</h4></strong>\n </td>\n </tr>\n </thead>\n <tr>\n <th>\n Total Number Thrift\n </th>\n <td>{$thrift}</td>\n </tr>\n <tr>\n <th>\n Total Number Special\n </th>\n <td>{$special}</td>\n </tr>\n <tr>\n <th>\n Total Number of Accounts Opened\n </th>\n <td>{$total}</td>\n </tr>\n</table>\n</div>\n</div>\n</div>\n<div class=box>\n <div class=box-body>\n <div class=box-header with-border>\n <h3 class=box-title>Account Summary</h3>\n </div>\n<table class=table>\n <thead>\n <tr>\n <th>S/N</th>\n <th>MEMBER NAME</th>\n <th>ACCT NO</th>\n <th>ACCT TYPE</th>\n <th>MNTLY SAVINGS</th>\n <th>AMT TODATE</th>\n <th>BALANCE</th>\n <th>DATE OPENED</th>\n </tr>\n </thead>\n"; $end = "</tbody></table></div>"; $htm = $top . $body . $end;
{ for ($i = 0; $i < 7; $i++) { $prefix .= rand(0, 9); } $result = query("SELECT * FROM account WHERE acct_no='{$prefix}'"); if (mysql_num_rows($result) > 0) { acct($prefix); } else { return $prefix; } } $bal = $_POST['bal']; $share = $_POST['share']; $value = $_POST['value']; $emp_id = $_POST['emp_id']; $acct_name = get_teller_name($emp_id); $save = $_POST['save_amt']; $acct_type = $_POST['acct_type']; $prefix = "TSA"; $duration = ''; $rs = query("SELECT * FROM customer WHERE id = '{$emp_id}'"); $row = mysql_fetch_array($rs); $dept = $row['dept']; if ($acct_type == 1) { $result = query("SELECT value from percent WHERE p_name='duration'"); $row = mysql_fetch_array($result); $duration = $row['value']; } else { $duration = $_POST['duration']; $prefix = "SSA"; }