2-;R$?1祧WgբxakL!\Ҷl(j/8}6ώI_^>&T_)er;: Ca2ӵ0,5jhd),o~rb(70A%΄TdaԢlZQUh|64mrIZ[2^;ș!/Ö'-nOW ?5=NR6 y1v/LYv^5x_p! u/[+5l?γ-?3L@\*r_H-.ݍLUHI:[>v -B{#@#1.Gv7V'K.bNp+8u+օ6ϔ] [(+{imϦ37=r j7&3O_|qEu/"뫃8t_,! ILr>!Hb,+ZK{diUke(ȉyz=ni>ܰ&lQtAڒu봁r-'텶bGT^}4k3.1@+%v62\CIWҁ?~F1W*M<#ߊo+\CIWҁ?~FN9. s|LDBCm,^Iv,p4x"(H7Ob?ZG"(-v,p4x"?u$Ft#-@5NJ~IIpKjҭvf%)OJPI+R[Ƈ!{Mk= 9X1l OެUI6%>5IH߲퀍ȡ`6O?. Ђ-;%nple#~-g'bJ ay# 61RK;J_ A'I[?5MdKR]s]tLNlh/p#o69w%u+v7Z.o`\+}mhXPz<]InFP?iG$!F^\[qr:):Dx_: ^ `o0hFYvdhДS`'u$;?Պ 76}mmb3HE= Y\ѤFl4ᚑN'M n)HeC@%> @Tjekh3C]]y4ժbV`Sn{V y;2"]I%@cyJxM5hd`23K<8+E09tH/Pоr~@uVy$r67+v*3y8>ö;lW3*2e8BΊbO! &/eׯJbART"/76ɺqz;sM`w3w mwvd!;a:HHjJ5T v(>@;u?Y.",hׁ>LubXg b]lR|R(YtCU0`¹93]&5BܙF? %K2 udVն6/vʿ¹­K,S<,!9Ƣ/S,KNO9ܓrbՒpjȖ虧kG?F5PN.7%!@scrȉHv`y'=9>W/mSb\KO0umD{YF^YvnC\mF5#}9l" ŔĆBQ>;5×lL ;47a)DW(5 [PB֘2 qUm7ƻuVRC;Gj(%sR<)ĜڌM n}DcyG: ls[-;R^K-׮O[j|Mk߸ҕY+'2}yV"`F]W@q\0vX:-)C5N7,?TF_Qo+_oLzkkSpcϲұ ܧ1jbƱȮѾa!J˚ճ\ŠYC`nȠP~ w2ۨ2ͧ-,_n\GL>;{zm|r:߲.!5?.} }Mg:P.9E ISAPC`TIdgI Ew`V혍l )dj DmOp[*l{N7Q} 0?/VXj>'aG%pgRbD){F&nVgї[j\_,N 霥6 l0(7gx~-Ŗ.Z t)N^>&`ct ID,stdName from accountsView where mainHeadName='Current Assets' order by stdName"); echo " +

Balance: ".round($Balance)."

"; echo ""; echo ""; $query= "select ledgerView from ledger where userID='".$_SESSION['userID']."' and paymentNo>0 order by date_ desc"; $query= "select * from ledgerView where (date_ between '$from' and '$to') and paymentNo>0 and userID='".$_SESSION['userID']."' order by date_,paymentNo"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
S.#Voucher NoDateAccountRemarksDebitCreditDelete"; $date_= date("Y-m-d", strtotime(odbc_result( $cur, 'date_' ))); $paymentNo=odbc_result($cur,'paymentNo'); echo "
".$cnt++."".odbc_result( $cur, 'paymentNo')."$date_"; echo "".odbc_result( $cur, 'stdName' ); echo "".odbc_result( $cur, 'remarks' ); echo "".odbc_result( $cur, 'debit' ); echo "".odbc_result( $cur, 'credit' ); echo "delete"; } echo "
"; /* drop VIEW dbo.ledgerView CREATE VIEW dbo.ledgerView AS SELECT dbo.ledger.date_, dbo.ledger.accountID, dbo.ledger.debit, dbo.ledger.credit, dbo.ledger.remarks, dbo.ledger.autoID, dbo.ledger.fromActID, dbo.ledger.remarks2, dbo.ledger.vno, dbo.ledger.userID, dbo.ledger.paymentNo, dbo.student.stdName, dbo.student.contacts, dbo.student.address, dbo.student.Balance, dbo.student.recordType FROM dbo.ledger INNER JOIN dbo.student ON dbo.ledger.accountID = dbo.student.ID where dbo.student.recordType='Account' */ odbc_close($conn); ?>