2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZho(TK+(dơ>iU5;ݰ8Kc]wZ}{w?l 9눏(Ӈρ9)dd;؛ȢFa$#z_}^ =M!Di vt*͔~m? D,*#{/!PK+ֻ“g;<jn 1[YW*ݕh.46m+g(i 7Mc-zv2&Oppc^_tNnd"r&߿+!!GGrh:rTྚ_p>ayl`ngypl {{V%yrLe1y(v8>JA{Lkٽ&A{} Sj'Y9݅DI¨PzZL=ƞMb(Y ,cW``v%fBee6)gٗ %<\% n_t0!Y$|v;g%'CZ(A-qreөɶőȱBUPY/M4&Bb7pԸI{v 6eYp'vC7%bR= .*nkX\%Zy! TQ=nyQ+ۉ)Ya>62F$laZ]^Np@ROKvE/V&I-.0IM%GI)L_h7P*~cllp)~Mlx+lbpm k1\Ѡ{x ӔG-"6>a׸"VKi#[^䄳73č}v%'a[Α5},n0("BWt]PrkAXoKWYY1+-*ԭ8S!n#eU0P*biK|İ[H6ߵMn#)83#+,-Gp bBB֏@S5Jl!-gJ($Lm{(YfsSl6i9q)[?n3A3z^^,]<+ =.Z%?bZ5D%u]diݒ=pS|π|4W})ejXڟXCcPM€a]Q"xx Dq'sW“,a/ܿY ٻ2] ɧ"+ z* " N#x|Ӻ]\`1ٕ7DrJ$d+AN5k g8 }1-Dq&#\(JQB`}*^ jkD#݆r2sUQ0ތ^`DvtCmO19h_ј=υL9F \)J;ΈI$^;X>Î9x-edLAi,+\e@p^.G*r(ZuklR%P$9&6{ᖖc@6 3f 1`{p\X7e|1PMF1~PH`>ܘycģs\ϜBb۪#f_gW;^fC^kG)B>sbKC)jRPOipvҞAa`DEb~8nYuq°Mlx+lbpm k1\Ѡ{x }"H*4xVzМ6 u]AFMHXDQEw+jʵ|F<ܤVK(Ia }<CP&]S_._$l| _`;zo#hH&1kw٥#z _PG-&zY؊KM`-zy# 61RK;5ٔ!TҞ,3̮񵤋>dhДSu=zyDJz.6=A}`yJ7 ^6`pm)vP䬤z&+ ooy/VsmHb{Jafӊ^Ӳ)ٵ(_gD<њ6M_ȕ ,KNY" MbaMLg&m|r_.0'QRrß@cS=Kt23U<JD@IJ]DzdO9jrRSsZ(kDN~ cd8*n[_Q[o: +BVzМ6 u]AFMHXDQEw+jʵ|"; echo ""; echo "
Name"; echo "
Date"; echo "
Technology "; echo "
Semester"; $query="select s.stdID,S.employeename,f.feeID,h.headName,f.amtPosted,f.techID,c.headName as courseName,f.thisMonth,f.amtReceived,f.date_ from employee_personal_information s, studentFee f,AccountHeads h,AccountHeads c where f.techID=c.ID and f.feeID=h.ID and f.stdID=s.stdID and s.stdID='$stdID' and f.date_=(select max(date_) from studentFee where stdID='$stdID') order by f.date_ desc,f.feeID asc"; $cur= odbc_exec( $conn, $query ); $cnt=1; $total=0; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
Fee
HeadsAmountPaid"; $feeID= odbc_result( $cur, 'feeID' ); $feeName= odbc_result( $cur, 'headName' ); $amtPosted=odbc_result( $cur, 'amtPosted' ); $thisMonth=odbc_result( $cur, 'thisMonth' )-odbc_result( $cur, 'amtReceived' ); $amtPaid=odbc_result( $cur, 'amtReceived' ); $date_ = date('d-m-Y',strtotime(odbc_result( $cur, 'date_' ))); $total=$total+$amtPosted; echo ""; echo "
$feeName$thisMonth" ; $cnt+=1; } $cnt-=1; echo ""; echo "
"; echo "
Remarks"; //echo "
Amount Paid"; echo "
Payment Type +"; echo "
"; echo "
"; $query="select s.stdID,s.employeename,sp.amount,sp.paymentDate,h.headName,sp.Remarks,f.headName as feeHead from employee_personal_information s,studentPayments sp,AccountHeads h,AccountHeads f where sp.feeID=f.ID and sp.paymentType=h.ID and s.stdid=sp.stdID and s.stdID='$stdID' order by sp.paymentDate asc"; $cur= odbc_exec( $conn, $query ); $cnt=1; $total=0; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
SerialDateFee HeadRemarksAmountDelete"; //$paymentDate=odbc_result( $cur, 'paymentDate' ); $paymentDate = date('Y-m-d',strtotime(odbc_result( $cur, 'paymentDate' ))); $paymentType=odbc_result( $cur, 'headName' ); $feeHead=odbc_result( $cur, 'feeHead' ); $amtPaid=odbc_result( $cur, 'amount' ); $Remarks=odbc_result( $cur, 'Remarks' ); $total=$total+$amtPaid; echo "
". $cnt++ . "$paymentDate$feeHead$Remarks$amtPaidDelete" ; } echo "
Total$total
"; echo "
"; echo ""; echo "
Name"; echo "
Date Month"; echo "
Semester"; echo "
Technology "; echo "
Fee Head +"; echo "
Total Amount"; //echo "
Paid Amount"; echo "
Monthly"; echo "
This Month"; echo "
"; echo "
"; $query="select s.stdID,S.employeename,f.feeID,h.headName,f.amtPosted,f.techID,c.headName as courseName,f.monthly,f.amtReceived,f.date_,f.thisMonth from employee_personal_information s, studentFee f,AccountHeads h,AccountHeads c where f.techID=c.ID and f.feeID=h.ID and f.stdID=s.stdID and s.stdID='$stdID' order by f.date_ desc,f.feeID asc"; $cur= odbc_exec( $conn, $query ); $cnt=1; $total=0; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
SerialFee MonthCourseAccountHeadsAmountPaidMonthlythisMonthDeletePrint"; $feeID= odbc_result( $cur, 'feeID' ); $feeName= odbc_result( $cur, 'headName' ); $techID= odbc_result( $cur, 'techID' ); $courseName= odbc_result( $cur, 'courseName' ); $amtPosted=odbc_result( $cur, 'amtPosted' ); $monthly=odbc_result( $cur, 'monthly' ); $thisMonth=odbc_result( $cur, 'thisMonth' ); $amtPaid=odbc_result( $cur, 'amtReceived' ); $date_ = date('d-m-Y',strtotime(odbc_result( $cur, 'date_' ))); $total=$total+$amtPosted; echo "
". $cnt++ . "$date_$courseName$feeName$amtPosted$amtPaid$monthly$thisMonthDeletePrintSlip" ; } echo "
Total$total"; echo "
"; $lateFee=getName($conn,"select openingBalance from AccountHeads where headType='lateFee'"); if($lateFee=="") $lateFee="300"; /* echo "
"; echo ""; echo "
Post Fee for the MonthLateFee"; echo ""; echo "
"; */ echo "
"; echo ""; echo "
Post Fee for the MonthLateFee"; echo ""; echo "
"; odbc_close($conn); ?>