Wduw{Aó*19üEwxLT)Z 2e;[cg6TS{* \ jCE_VtC & R6:D~=,@IL8 !ۙj>ub}r]oP0̰Mc{8 i-齗Y؞::6p[.K{,-,__ HW|" H]{dZyh`n S7zeZZ:SB|~ 6I8pOS(f(e^W O_Nww%‹遬svśF/̿ T$I%XB[+vsJA/I3{X0ȰznM; |mI݄H ɿGKUӥRU~D逝]y@=f:A07x: S F/bqɫ'jJgNr${@-kOp\nGY)vGy9eO ᓛw-+qc.zhC?'Cf\&h!g kO=3qNHSakr/ɴDAS IjۖKE0Op[ۨدY')&" Z=Mƺ͕YUr JM(!a+ {9O5V䐓cl%L']4_̎F[;=veVʮps  ZY 1?1VڼTĤO2zRHK mDD/6-33:[dps  ZY 1?1VWB?[n@ ! jQJ6ˆ7b5υ#DxIQkkٰZr}W3PEbtˤx=vVxp$bVx㴐u:I<κȺ r_kHP#W5ru:I0,\`j^DD]a2ȸށUD(if2G!2jZLB^}̡VﻟTyp;ﻟTyp;ﻟTyp;8Jw5\xԸˠW:D`ha3ݎ<-?# wo xzW6ndB,\1;Jv@R>d+%pVCPi|3}ă}n6o*{Zjg07$LC *V!<7JSde,19o$!o*ҴG߂W Pe@wNt g̶7{W#I@Ȅ_wvt l2hw;]ĭm- +"c/lFR>/xIo9pq)15 9Y^ڪc MU җ 2SY(]$,^MΔzz-|@jyr@i3[knz ۑzoS`̴ L=C `8)kh*kBPV(!utUxE_l QbyLKKC:ω mIQo#NU:L% Ͳ'0E.kU tbfj8e2Ѩ4RL lAe_>TlCILW9fpyBqK\c/ژ1G}BP`mcF]^cuWƬ[hjh,?tCQ( %CJ;V MzSdޠz9lLa-u]d'z}kV6/GSePD`B;>҅-BIRkVݭT0Qp.*-V~;7ss/`&$Lߧymǂ >H_Xry.= " and accessionNo>=".$_GET['fromno']; if(isset($_GET['tono'])) $query.= " and accessionNo<=".$_GET['tono']; $query.= " order by accessionNo "; //echo $query; $cur= odbc_exec( $conn, $query ); //odbc_set_charset(); $cnt=1;$total=0; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
Printed : ".date('d.m.y h:i A',(time()))."
#Acc#TitleAuthor"; echo "
".$cnt++; echo "".round(odbc_result( $cur, 'accessionNo')); echo "".odbc_result( $cur, 'bookName'); echo "".odbc_result( $cur, 'author'); //$total+=odbc_result( $cur, 'nos'); } echo "
"; }else{ // all stock $query= "select bookName,author,count(*) as nos from bookTable where bookID2>0 "; $query.= " group by bookName,author "; //echo $query; $cur= odbc_exec( $conn, $query ); //odbc_set_charset(); $cnt=1;$total=0; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
Printed : ".date('d.m.y h:i A',(time()))."
#TitleAuthorCopies"; echo "
".$cnt++; echo "".odbc_result( $cur, 'bookName'); echo "".odbc_result( $cur, 'author'); echo "".odbc_result( $cur, 'nos'); $total+=odbc_result( $cur, 'nos'); } echo "
".$total; echo "
"; } if ($cnt==1) echo "No Record Found"; }elseif(isset($_GET['type']) and $_GET['type']=='Issued'){ $query= "select * from [bookInOutView] where returnDate is null order by stdName "; //echo $query; $cur= odbc_exec( $conn, $query ); //odbc_set_charset(); $cnt=1;$total=0; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
ISSUED BOOKS
Printed : ".date('d.m.y h:i A',(time()))."
#DateMemberAcc#TitleAuthor"; echo "
".$cnt++; echo "".date('d.m.y',strtotime(odbc_result( $cur,'doi'))); echo "".odbc_result( $cur, 'stdName'); echo "".round(odbc_result( $cur, 'accessionNo')); echo "".odbc_result( $cur, 'bookName'); echo "".odbc_result( $cur, 'author'); //$total+=odbc_result( $cur, 'nos'); } echo "
"; if ($cnt==1) echo "No Record Found"; } ?>