function getNext()
{
if (!($this->row = mysql_fetch_array($this->result, MYSQL_ASSOC))) {
$this->finish_flag = 1;
return NULL;
}
$ac5 = $this->row["AC_ID5"];
if ($this->open_or_close_bal == "c") {
$this->balance = get_closing_balance("AC_ID5={$ac5}", $this->enddate);
} else {
$this->balance = get_opening_balance("AC_ID5={$ac5}", $this->enddate);
}
$this->sum += $this->balance;
return $this->row;
}
printRow(array("<hr>"), "", "1,6");
printRow(array("VR No", "VR Date", "Vr Type", "Particulars", "Debit", "Credit"));
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$row["VR_DT"] = conv_to_hrd($row["VR_DT"]);
if ($row["DR_CR"] == "D") {
$row["DR_CR"] = $row["AMOUNT"];
$row["AMOUNT"] = " ";
} else {
$row["DR_CR"] = " ";
}
printRow($row, "fluct");
}
printRow(array("", "", "DebitSum:", get_debit_sum("AC_ID5={$ac_name}", $enddate_srd, $startdate_srd)), "", "1,2");
printRow(array("", "", "CreditSum:", get_credit_sum("AC_ID5={$ac_name}", $enddate_srd, $startdate_srd)), "", "1,3");
printRow(array("<hr>"), "", "1,6");
printRow(array("closing Balance: " . get_closing_balance("AC_ID5={$ac_name}", $enddate_srd)), "", "1,3");
endPrettyTable();
mysql_close($db);
} else {
$ac_array = get_ac5_sc_array("5(1/2)");
?>
<table cellpadding=5 cellspacing=0 border=0 width='100%'>
<tr>
<td valign=top width='15%'>
<?php
beginPrettyTable("1");
?>
<tr>
<?php