I:ܫc+]YF3KD $ײ >W"8I Tȉyzsө9 Z'( 1yY f1!xQI5L#\J Pv38G~ 0f]jҮ?0ʼnAG ׎R]s]tLNlV6-] ܡ5G-QVwF](#$& 1J~\?"5'g Lqm˅c %Eͽ=;nFzv1 Sk~ \e4{8a/ (VMdePDv㛏 s[FpKS6(&^X4WlV i}߷Q~玬3**,e "TGOmT:F2$˾hF*x?%NK)N!| wFhȤ ߮8WGSSY6()R@sf>EU =G妺ĶwBz8ɤ,Z .餟1Nf%1(]{2dH}0ׯR\3$[& JJJ800z^[56!䈷'fX FOoŕMܯz ѯQE;U)Z7 x4=u󹬮\oA T,)Ais{Κ-@% #A?ހ]Ԅ=;@򤣎ޅs0'W9[T%cqLA8'[WT+AT7gܵeV3]2aZ>p;o!x$KPȐ]PW6J.Dc%N)i`q:F7ŷ*%>pcE20ӱ14E,~ ]AT:8 |)Cr qgXVuU."bQc#DW 1xa{#.aܯӱ14E,~_5V 5uXCI}ζicm`9n\@z^ 6w$om/AwHM*R0;Pa |tCѲ=&ҕ0`4׉͝Ržl>^C~"g58d8gՀT~ؠc5Z}Hq˜dC:GZّ{ﻟTyp;ﻟTyp;&;fF{U6awȕ>&zufcJ:Iixbs(ɃK 5"]bhPˬ@aػ;Ċj"hK #(: quHf%+Zm{2CUۈp̄ƀQT&YD*rf.X u.拢[z+>*`bn" class="main">

Account Ledger

From
To
Account Name "; echo fillCMB($conn,$accountID,"select ID,stdName from student where labid='".$_SESSION['labid']."' and recordType='Account' order by stdName"); //expenses and (status is null or status='' or status=0) //echo fillCMB($conn,$expID,"select ID,stdName from student where recordType='Account' and sectionID in(501,493,494) order by stdName"); //expenses //echo fillCMB($conn,$expID,"select ID,headName from AccountHeads where labid='".$_SESSION['labid']."' and headType='expenses' order by order_"); echo " "; ?>

=0){ $query.=" and accountID='$accountID' "; } if($mainHeadID!="") $query.=" and mainHeadID='$mainHeadID' "; if($subHeadID!="") $query.=" and subHeadID='$subHeadID' "; $query.=" order by date_,autoid "; $cur= odbc_exec( $conn, $query ); $debitTotal=$creditTotal=$balance=0; $cnt=1;$total=$totalPaid=$totalCost=$totalExp=$totalTax=0; while( odbc_fetch_row( $cur ) ) { $partyNo="";//odbc_result($cur,'partyNo'); //$partyDate=(date('d.m.y',strtotime(odbc_result($cur,'partyDate')))); if ($cnt==1) { echo "
#DateDescriptionDebitCreditBalance"; $balance=getOpeningBalance($conn,$accountID,$from); echo "
Opening".number_format(round($balance)); } echo "
". $cnt++ ; echo "".(date('d.m.y',strtotime(odbc_result($cur,'date_')))); //echo "".getHead($conn,odbc_result($cur,'section_')); //echo "".getHead($conn,odbc_result($cur,'mainHeadID')); //echo "".getHead($conn,odbc_result($cur,'subHeadID')); echo "".(odbc_result($cur,'remarks')); echo "".number_format(round(odbc_result($cur,'debit'))); echo "".number_format(round(odbc_result($cur,'credit'))); $balance+=odbc_result($cur,'debit')-odbc_result($cur,'credit'); $debitTotal+=odbc_result($cur,'debit'); $creditTotal+=odbc_result($cur,'credit'); echo "".number_format(round($balance)); /* if(odbc_result($cur,'recordType')=='Salary'){ echo ""; echo "" ; }elseif(odbc_result($cur,'recordType')=='Advance'){ echo ""; echo "" ; }elseif(odbc_result($cur,'recordType')=='invoicingVender'){ echo ""; echo "" ; }elseif(odbc_result($cur,'recordType')=='Expenses'){ echo ""; echo "" ; }elseif(odbc_result($cur,'vno')>0){ //if(odbc_result($cur,'recordType')=='receiptsOnly'){ echo ""; echo "" ; }elseif(odbc_result($cur,'paymentNo')>0){ //if(odbc_result($cur,'recordType')=='receiptsOnly'){ echo ""; echo "" ; }else{ echo ""; } */ echo ""; //echo "".(odbc_result($cur,'recordType')); //echo "".getName($conn,"select stdName from student where ID=".odbc_result($cur,'userID')); } echo "
Summary".number_format(round($debitTotal))."".number_format(round($creditTotal))."".number_format(round($balance)).""; echo "
"; ?>