Exemple #1
0
 function getActualExpenses()
 {
     $ac5 = $this->row["AC_ID5"];
     return get_credit_sum("AC_ID5={$ac5}", $this->enddate);
 }
Exemple #2
0
    beginPrettyTable("4", "From {$startdate} to {$enddate}<nbs>       Code{$ac_name}");
    printRow(array("opening Balance: " . get_opening_balance("AC_ID5={$ac_name}", $startdate_srd)), "", "1,3");
    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"] = "&nbsp;";
        } else {
            $row["DR_CR"] = "&nbsp;";
        }
        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");
    ?>