2-;R$?1祧Wgբv~ar$qj8NSl"2#n\|P-j>ub}r]oP0̰Mc{8M6rS)SP_}@fw6aON4?%^:v0%@LcsĘ"TaG[*&vH)Yzf Nu0=Hy(;iΔ8Xt$/m0Z"a(ӧ8fh$͞A5fċvaxRb~/p^TШ6Po -bŮs&#d fl}ROKv  /҄^ &uj,q*{ܰK˥ٵw쫳"9uSf͡-aqYh}nc7!?$aXEKQy6 \֐,BPѴQ$w 74)tdWo]]%uxq\IV&U[BWP;rPչmTjOls~>7N`B'&@yuq^ .H%t7rt7ftgr+~Ջ s8Joxt]SSKx{{Х*&aawۉr~ 8pI(} /a%7^h唎d+Z~CsM(5>kKRs(2JҼo^qS"PyOZ1t|d4yЦ N2KVɲU-D/X7&)[ +bj\[#0mҌe'6C=i0 gm./@ { O¦ӆ Uյ<0O;`u{kh{Zw oU`tͺܪ„\(n[_(I㋿C%C _ ӄ<%M5t肖r;vsӨ;)dۗdK2mU g, ~,e&3|H[+5)F 54ɼ\-vD\!z n8yb1}~\dpocq;m$d &UjPն(4 r2P j|^ 5'愯[L94HWA4vFX9hstCw.t.#\㻾U/sM4"BLMkN\ ZH%,-Ott)__TP A"Cy|DC_o H,2md@mu1'hyHfj 0 ɉKg0hAc ۧ yd$JKIv+C9؋m@xYrB'=f PF^9IWQݧu(5-<7b!X0_XϟdYGfG\:ڋg- [⊡cRfLoo~?%} ꩧ6Y2twQ &seO@norZ3433BzBP>d͜KIDE6ыlUMW7BÀ8M>mNuQYgYy X;s &/6^o jLzlC5@vP=XCN?t*`qsAJWcH`gE|h -' „lZkD8vT =Ok  *)GT 9Ȥ<wdﭩRęA1Y$1vˡN~ӍemK2T=;mQ=mdm6M`U?Sp_ `Kp#'I?sKZwK6ZCaɅmbU^Y^Z 3 ¾1-<%M5P /'5KyۗϤȼ݂o) xr _rQ3kyS^Foޠr^.ʧJ<ƃ߆wʼ00:60͚?(AYLh|R$:2F<?62b^#h[T %ͳsHB&:^f6F2蚟v^ڹ6J]kE%LPūI: ADwm&jA잂tOp Qjl9&$ԧS h*  GVe3&¾.,DdwøGӦ3G.u03BqEغ<4D)>ɓײ@\bn_j.LMaKnmxyCFE*~; E9aLW]n[_*ynK37[ޘ?kNȸB s<@9R5m4\dɎr>G?2z@mbmUZ pQitD)B{eIW}g0 . /(>y2IVi!$!ڻ"[5@1RVD 6$*# z*1!NsE5 .Kre bD YPQ~e"|P*pi:#9tM 0ᷩzcK>X,:%F.Wf%JyJHecvvUJՖNzh[\DR;<>ʝ:UP0q5?g>-aqYh}DTF3C%|'= z_'?<d%1Bg+ Q fyb@e1dgPԌݝ 8 _;2?V` $f= ExtN^0!dXV >Hn} S~ԟLz1#*DssU>OӨa.y4KQ_1RWtz`f7Qtލ~}B8IhږI[PMIvsjq܃2r> A$uzp_heuZxI]P`,eeKRO5/9CSgny]]FcF TdmI6?A0D#F$ EgmGvD% |ɕ"!m3xm20}f vqeY2c=܉JߺW

on-levae

"; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "ON-LEAVE STUDENTS"; $date= date("d-m-Y", strtotime(odbc_result( $cur, 1 ))); $id= odbc_result( $cur, 2 ); $name1= odbc_result( $cur, 3 ); $class= odbc_result( $cur, 4 ); $section= odbc_result( $cur, 5 ); $fname1= odbc_result( $cur, 6 ); $cell= odbc_result( $cur, 7 ); echo "". $cnt++ . "$id$name1$class$section" ; } $query = "select v.date_,v.id,v.name,v.classfit,v.sectionname,v.fname,s.resphone from attendanceview v,student s where v.fname like '%$fname%' and v.name like '%$stdname%' and (v.date_ ='$from') and v.Status=3 and v.id=s.id order by v.date_,v.FitClass,v.id"; $cur= odbc_exec( $conn, $query ); $cnt=1; //echo "

sick-levae

"; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
SICK-LEAVE STUDENTS"; $date= date("d-m-Y", strtotime(odbc_result( $cur, 1 ))); $id= odbc_result( $cur, 2 ); $name1= odbc_result( $cur, 3 ); $class= odbc_result( $cur, 4 ); $section= odbc_result( $cur, 5 ); $fname1= odbc_result( $cur, 6 ); $cell= odbc_result( $cur, 7 ); echo "". $cnt++ . "$id$name1$class$section" ; } echo ""; $query = "select EmpID,EmpName,ContactNo from employee where EmpID in (select EmpID from staffattendance where Status='A' and date_ ='$from') order by EmpName"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
ABSENT STAFF
SerialDateEmp IDEmployee NameContacts"; $id= odbc_result( $cur, 1 ); $name1= odbc_result( $cur, 2 ); $cell= odbc_result( $cur, 3 ); echo "
". $cnt++ . "$from$id$name1$cell" ; } $query = "select EmpID,EmpName,ContactNo from employee where EmpID in (select EmpID from staffattendance where Status='L' and date_ ='$from') order by EmpName"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
STAFF ON-LEAVE"; $id= odbc_result( $cur, 1 ); $name1= odbc_result( $cur, 2 ); $cell= odbc_result( $cur, 3 ); echo "
". $cnt++ . "$from$id$name1$cell" ; } $query = "select EmpID,EmpName,ContactNo from employee where EmpID in (select EmpID from staffattendance where Status='S' and date_ ='$from') order by EmpName"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
STAFF SICK-LEAVE"; $id= odbc_result( $cur, 1 ); $name1= odbc_result( $cur, 2 ); $cell= odbc_result( $cur, 3 ); echo "
". $cnt++ . "$from$id$name1$cell" ; } echo "
"; odbc_close($conn); ?>