예제 #1
0
파일: accrp.php 프로젝트: k9ert/ac4ngos
 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;
 }
예제 #2
0
    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");
    ?>
	   <tr>
	    <?php