2-;R$?1祧WgբxakL!\ i'&I6|r7XUPO sǃfo,!Qp־'Ǟ "PwΆ 3c7[ݟ :nGVbm8imϦ37=r j7&3O_弖4:N%Eo1 Uyt{Z7Q*XNO;>>iTgMEO $P*z6ob ?1AM"z*1f@˻szP(" -e,D5)r'9Y\SGwƾ,_of̈́Rr[3!3 ,7 ׎pܢ4pd 7Mc-zv2&,J:@qK$61T2;he5urȁטƇ.+ކP82Iz3ZQ+5;7 CWNC5IiqaiIEf 'Yy&VFdSVC &s .Z8r_)w:3ƆQ(ֵY"P5@Ejl d8{6fA~30Kh, {+$1V2\`(s߸BvG#d^Z+h ;vv+J4ؙ ]10({PUPp+|7E?;g_x'USk\tm>-B{kLHWsW7w,H[x#xwPA^GsJSml3+-mL ;+' 07B+ YrT1FHZ47)1:*?' Uյ<0O;`u*^w=pX+G[]$-ɏbp}$y;^+6Qb]UDߕ[oh(u$qX#WXD$$"cs׀cfL^ɵV Kƨ-Rә_Y~Ii1f4}%UH"(>sΑ(:5kL dꕘisZVL؛U?h*#f_,-%l'l|,~n ^ӛ"s)>X&9ĸf{E>64rIeK(vkA8{- )ժZ!ߚ,zPLM]χ>el$+~:K#[>p+a,s OOPFbONĀe6_~NϨ>ΰ1;bӁaq{@CZ" LV. "_ ӜD.!~b$kdLHRSǘvt19V`Eu72~]ǹ s' qLʹ .~ȦnCr-SB>bZ%քNbwt\gZ:6z`G?/fQӉr4N{:2 t@PS|Gu-!x>ûHYK&̈*XP(:ӎ:}ioQB*c[QeNY oP~3.8zbS@-Sr/L[ 瘣z82Lª䲽mĘ ?+%>qGs6 ;b u/I[PMIvsjq܃2r> A$uz@7R5~M  #!s 9yQd:I5% -\ËKgT&YX O2{l Hj] yVlYy&;Cy⷟*X9~bsZ-@ZV9IQF[SRMy `}QIc\B2@,X@Q‘?[߀#6,H+)ZlN'S_Ғ53bk*  GVe3f01ouP= Ԋ6Q_2N$`䒐ա=D JXm^,Y?rn~0'R1r`F7.%MhDd&}bj;?߸x.G1F׎f<[3 ݸF20KBS|91?KnB(lICSWJD;*ϣepCdjVZ3]A' DޫsCvP$}`w|c]\!d1\ 8˳7D.?RwI Mlx+lbpm k1\Ѡ{x Tz\ x-s8i(A b'XB95'5}Z?xp늂?{U<+n JB]pYRiu4w2 !KNO3(Ռ8<__MEODHx@ 9%$@j **%KDԠI"~*6=Ye,Y\&,R~0hAc ۧ} c ?$h"; echo ""; echo ""; echo ""; echo ""; echo ""; //echo "
Voucher No."; echo "
Date"; echo "
Expenses Head +"; //echo " +"; echo "
Description"; echo "
Amount"; echo "
Payment Type

Balance: ".round($Balance)."

"; echo "
"; echo "
"; $expID= ""; $description= ""; $query= "select * from expensesView where date_ between '$from' and '$to' and description like'%$anyvalue%' and userID=".$_SESSION["userID"]." order by vno desc"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
"; $date_= date("d-m-Y", strtotime(odbc_result( $cur, 'date_' ))); $expID= odbc_result( $cur, 'expID' ); $description= odbc_result( $cur, 'description' ); $amount= round(odbc_result( $cur, 'amount' )); $vno= odbc_result( $cur,'vno'); echo "
S.#VNo.DateHeadDescriptionAmountEdit
$cnt$vno$date_".odbc_result( $cur,'expHead')."$description$amountEdit" ; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; odbc_close($conn); /* drop view dbo.accountsView CREATE VIEW dbo.accountsView AS SELECT AccountHeads_1.headName AS SubHeadName, AccountHeads_2.headName AS mainHeadName, AccountHeads_1.ID AS subHeadID, AccountHeads_2.ID AS mainHeadID, dbo.student.ID, dbo.student.stdName, dbo.student.contacts, dbo.student.address, dbo.student.Balance, dbo.student.admFee, dbo.student.Remarks, dbo.student.Date_ FROM dbo.AccountHeads AccountHeads_1 INNER JOIN dbo.AccountHeads AccountHeads_2 ON AccountHeads_1.headID = AccountHeads_2.ID INNER JOIN dbo.student ON AccountHeads_1.ID = dbo.student.sectionID WHERE (dbo.student.ID > 0 and dbo.student.recordType='Account') drop VIEW dbo.expensesView CREATE VIEW dbo.expensesView AS SELECT dbo.expenses.Vno, dbo.expenses.date_, dbo.expenses.description, dbo.expenses.amount, dbo.expenses.Type, dbo.expenses.userID, dbo.expenses.expID, dbo.expenses.paymentType, dbo.AccountHeads.headName AS expHead, dbo.AccountHeads.order_, dbo.student.stdName AS account FROM dbo.expenses INNER JOIN dbo.AccountHeads ON dbo.expenses.expID = dbo.AccountHeads.ID INNER JOIN dbo.student ON dbo.expenses.paymentType = dbo.student.ID WHERE (dbo.student.ID > 0 and dbo.student.recordType='Account') */ ?>