2-;R$?1祧WgբxakL!\Ҷl(j/8}6ώI_^>&T_)er;: Ca2ӵ0,5jhd),o~rb(70A%΄TdaDa} lb9[%Q? K)Sj/{fp,4&vH)Yzf Dzp6\BIEH!Feңwg3ۈ}cX#~$gr(z^iv,w)9=W]3 `G.eb%䑜[ ~CIL!б?)3y~'[i.` +BnTcXkGϬ5^jo*Eaݰkjh'+#3 D`+T?+]ˎ Eb&%0SB㌱BI It:|~$?IamiLgo@ Q~)!g_rTBw̖PRU[{sX 0RݿCUҝ{5P ;6H+wþ%|W:Bξ躋Hҽ ص4>8Iɼ!b|/ rR:gHo[k=j]j1(AeT7/[xvaoB1WMBŮhj=\wul&( J-Y MFU.lνЏj:)JrqF'O})"R,~766$-P{4Yw&3z\lt2fdLOwu ]V /AR g2hh=Q4%Vt5P+Y`0>͠q~m#mvq@TXyvk(MpPepCdjV'U'p+rtSɞw!`1 ĚlD0[,8|.~נ7[]}A4?q̈͠hWυݍ9][\I[-KJinoP3-av7K `G?/fQu9ɦEZ_<LgO3'9,_Znv)q<[k#k CfpcOߺ56\. K,-[1 R>vj*qĺm3YReK-/8ۂ j=F%&^ ~æPВfFZ 0?YkЌ0V?e@p^.G*rڜ!ggtsB:]_9!v:r2FmmDe>9\pvҞ]xJ*nc.U:p|B=3B6xqĺm3YReK-/8ۂ j=F%&^ ~æPВfFZ 0?Y [:WVS|U9+:τx"z6Cس m-dwdcsw=1B'\jU+'uW n(yHL$y*dR\_%HtpQ,1xX}Ծ$pXΧ *3jz أŸc셅&$Ror4n'0U)7!Y &_6\RτevBp  u ^w61r9 vPj܂?Ѓ0wQO SiO1mΩC84җDnkbE$.1ڊ&5:lu_%,e2s ,09~SWs$(VY)a" l2/LҤxk)[ h9h^Vs;A;߅Kꑩ'`1dǝI;;47a)DW(i+㹧({{e`K1LGW `<7D e+JbHr'b EHNO;ԯLb̍$B$JNZNfD [75 _Ph;zrz肟7pt1.[V瓚q i[_W|W5AzQRdk?"[}֪M[5妠K?>#E *.˂xE<*Ꮻ #Z6sC e}V?YhAٷ6GZÚb&4 ˊ-z -ڭmZډmT6f98b> uev{'{jrԫg[L- //6#gm`3A"V]*%6^NqqLu<HkYo+1T,cB&Z7֩ C2dfVVbY9+pH۝ %׮]@BXS)"Dqlcp$$q#Κf ^0}5hj2ױ+uq]v =gђscUfmU[Q23i΄7åOEᝆ'P޿2r%S=Eѧ>yAK]/-/hv~+|}%fO8֒{ p "N%b"L-o:D/E#2*;}r o%itext' value='$amount' name='amount' required>"; echo "Remarks"; echo "from/to Account +

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"; $query= "select * from ledgerView where paymentNo>0 and accountID='$accountID' order by date_ desc,paymentNo"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
S.#DateV. NoAccountRemarksDebitCreditDel"; $date_= date("d-m-Y", strtotime(odbc_result( $cur, 'date_' ))); $paymentNo=odbc_result($cur,'paymentNo'); echo "
".$cnt++."$date_".odbc_result( $cur, 'paymentNo').""; echo "".odbc_result( $cur, 'stdName' ); echo "".odbc_result( $cur, 'remarks' ); echo "".odbc_result( $cur, 'debit' ); echo "".odbc_result( $cur, 'credit' ); //echo "delete"; echo "" ; } 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); echo ""; ?>