2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZhoq g""o`,o6O3 qlZL](O4zWCυ^> Xx VmYElfpFthP|=eta%|9I2yխ:Ax&Pn .iK *(I>#?s@ZfX㫾kKEIߦL09:I4Gvw>a>z|Tcvc9GR|Twl'v~l+p3|=M;l5x@ R)u/Q nJ<,#JsX.̚{/!PKj3J g>4ZѠݕh.46Ϛ4d>[b ?1mR^׷ ̲lǥfCA젏]QUppfۨTHujzEcFɂwvIԠک;=LS-2F| )ugn!.Ȼ٨rx#KvG%0I=N%gSe3FUaeig!zkFSOTCH4Ĕv8ZEnG%p|O?UG9_4b=}?hZx& m8ZEnG%p<ʑѽ"…ˤ#‰`w;,Y=v^G;SDP۽Ϡ vKn?fƛI^R}̋rL.T뱺9 2ŕ&\b[r=<@U11D1-|d\\DKK׸A8`,>~Dwt;SDP۽Ϡ vK:f{ U2.>+6A+mČ{zqűU`e58S#482%xcNta6H$G7եfab A9Hws 9:)buŰ<KE҂D {-/էԩ'K57zi];Aox^&.mX>Î9x-CIQntJYٟ+sj# #-{kj,Js&sHW*_lH(F.tE׌758lֺ/[Jz 6Ll}1⬸D]Xwb'B_ `39@Gjͱ F#Wid$j(bm;tJ{d!64&9.xD¨PzZL=&Ͱh9]@%3o4:aoM d/p:Aj\[#0mҌ0NתrM^J1 bUް{1˒cM4r7}|Kjns nqೳP<ܑ@8; *  GVe3p<{B&"%Y RŰ<KE҂D {-/էaPr R9'*  GVe3p<{B&"kkt"t D vq('n9c;1-Dq&#\(JQB`}*^ԈΌ$ O,Œ9YS}1I=^I3Q+6A+mČ{&\~=#G\[w2[v gZ1ԋ$cM4r7}|Kjns nqೳP<ܑ@8; *  GVe3p<{B&"%Y RŰ<KE҂D {-/էZ͋aoQbp0+Gbh"%KcƉ!O'Ky=iLNgˍ֢OmeF`1-j45)b(e``G5naGJ--2<25ܙҁpAHvt+6A+mČ{<<醕묕{({fu4gR#4/M4&Bb.Xq z(d 4j&=s-$Ȇ4ey-#f eG`1lӸu' g%Y R8? sPwP&MnyQ+ۉ)R8F!*ӵ(FLt`<;=j['bOzՏf wLBt}\cd_vW[j}f~Ƽ"nHARm#XM0}trOIQ>1[",Q[.Y4eieөX?|Ƚ0u SEhTX҃`WϊrW1iGŲGOvf縓(c;8~B9Ou X;E:U 62DM6-nnśH@A%=6tVxsf 4~d.\mtBFNPgy$|wr% +V~E>/:y%-O,Rj\[#0mҌʚl f iz<,*^w=pX+MGohe+QH8Cib^4^^c1vJe` ' IPGuq ,X!;naD$ NNx[8@[#^L~b^pm 8"K#0 ?ObekdθvW <{ FXhQ-BVߚ<6M oQ쑘k!x۷G[d<ϒ}W0-)e_(ApC3,ilyZl?f ~%A% +V~E>/]Ͳղ+ܻL:;hM4- wa`V\TIt!,zSZ?Grd2zHw&Bh$umAeuav(߯%;"XQ4x/dzZ⭳:F2$˾hF*d,қMō &d\\DKK׸A8`,߄8ۑlZbvt{Rµ*igy 38G~8L- ~Gi2k.YWIN#ĝ ڧHCHOd06'ӆCҢ$AJI<34W:T{-Dd`L`Y[L}7@67ʏEgA-!6yu4-mڍqyM'BpFmtJNr*z~ҧ`?e}މ'ܘ;L>TZwJҰXl'"5K13/̺?ueZ95S.0JA_FBe9bp0+Gbh"%KcƉ!O'KD0Jt%myk"5l^񢖻l+$I JL%f*5L1P,ەӒL3 ݸF20y{Qs12fꎡ_;!F z7A}a xA@ ŏŬ,—=Mbndach ?z]J-h!廙|zSyZJl&L5YY ѽљ_JnǴHh9ciSVur= odbc_exec( $conn, $query ); $cur=updateFee($conn,$stdID,$date_); echo ""; } } $stdName=getName($conn,"select Name from Student where ID='$stdID' "); $classID=getName($conn,"select fitClass from Student where ID='$stdID' "); echo "
"; echo ""; echo ""; //echo "
Student Name"; echo "
Student ID"; echo ""; echo "
"; echo "
"; echo ""; echo "
Name"; echo "
Fee Month"; echo "
Payment Date"; echo "
Discount"; echo "
Amount"; echo "
Remarks"; echo "
"; echo "
"; echo "
"; echo "
"; echo ""; //echo "
Name"; echo "
Fee Month"; echo "
Fee Head +"; //echo "
Obtained Marks"; echo "
Amount"; //echo "
passingYear"; echo "
"; echo "
"; $query="select f.headID,f.Amount,h.Description,h.headType from studentFee f, feeHeads h where h.ID=f.headID and f.stdID='$stdID' order by h.order_"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
SerialFee HeadAmountDelte"; $Allowance= odbc_result( $cur, 'Description' ); $feeID= odbc_result( $cur, 'headID' ); $headType= odbc_result( $cur, 'headType' ); $Amount= odbc_result( $cur, "Amount" ); echo "
". $cnt++ . "$Allowance$Amountdelete" ; } echo "
"; echo "
"; echo "
"; $query="select f.headID,f.Amount,f.date_,h.Description,h.headType from studentMontlyFee f, feeHeads h where h.ID=f.headID and f.stdID='$stdID' order by f.date_ desc,h.order_"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
Fee Detail
SerialDateFee HeadAmountEDITDeleteSlipBank"; $Allowance= odbc_result( $cur, 'Description' ); $feeID= odbc_result( $cur, 'headID' ); $headType= odbc_result( $cur, 'headType' ); $Amount= odbc_result( $cur, "Amount" ); $date_ = date('M-Y',strtotime(odbc_result( $cur, 'date_' ))); $dueDate = date('Y-m-d',strtotime(odbc_result( $cur, 'date_' ))); //$headID= odbc_result( $cur, 6 ); echo "
". $cnt++ . "$date_$Allowance$AmountEditDeleteSlipBank" ; } echo "
"; $query="select * from studentMontlyFeeTotal where stdID='$stdID' order by date_ desc"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
Monthly Fee
SerialMonthPrevAmountPaidDiscountBalanceSlipBank"; $paid= odbc_result( $cur, 'paid' ); $discount= odbc_result( $cur, 'discount' ); $Prev= odbc_result( $cur, 'Prev' ); $Amount= odbc_result( $cur, "Amount" ); $balance=$Prev+$Amount-$Paid-$Discount; $date_ = date('M-Y',strtotime(odbc_result( $cur, 'date_' ))); $dueDate = date('Y-m-d',strtotime(odbc_result( $cur, 'date_' ))); echo "
". $cnt++ . "$date_$Prev$Amount$paid$discount$balanceSlipBank" ; } echo "
"; echo "
"; $query="select * from FeePayments where stdID='$stdID' order by date_ desc"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
Payments
SerialDateRemarksPaidDiscount"; $paid= odbc_result( $cur, 'paid' ); $discount= odbc_result( $cur, 'discount' ); $Remarks= odbc_result( $cur, 'Remarks' ); //$Amount= odbc_result( $cur, "Amount" ); $date_ = date('Y-m-d',strtotime(odbc_result( $cur, 'PaidDate' ))); echo "
". $cnt++ . "$date_$Remarks$paid$discount" ; } echo "
"; odbc_close($conn); ?>