B!A? 6>kE[JY XRL)h@&tYs ~]fKkְwsLGY;ֳL+ZB%Ur%XiUQc^:H~7O\x  a7w}cNV`%iַLy5 .L%Ȧ p':aBZUm41zS"h4/,Y=^AOGq07@%W-dvns|Yݾ~t[m TIy:o%TgڴEYǷ|8G#:GrrY0;p?p9BFas9z oq7Q/#3A98AҜe(Q?y(@ҧqYrF4mfgB~=a!Z;5Rzb6yu;m;6 Xv>`3&߿+!!GG Oo<.<ڿ$j&,y!=Es`Fi(^#Z6 b% s-#˫G:->B)%Z!mi`^ v'#d~ˌ!@}ȩ&;\u-0ZNSe3FUaeig!Nqtܽ4#,DKDDpL;Cj> 4 ~۪y5V;ؽOHqOTWL P1I47UhS)16 b% s-#},beϭa"vTmX4Ϩ\$` Im1!{i])'a.՞#՝ ^Toe>)¶wOxkǂ?>+"3Q1sF3E C!Feңwg3ۈ}&6E|⏇P|M\޳'\#mbg58<Ķ_pq=&K$`v9ӫc!-O_ ң ciMtk `k)399DY ԫBp-q ;/Gi,QDR.}=;$+,KqN.6һtu{ƤtJN׆Oò8F1QhMBV ܑcw,H[x#xwJOB+oeWp(_9I(QhN݊rz^M(W:[ ٻje-K~ \zzEwBz8ɤ,Z .gΒ%G鶣B.K$eĘSk3 2CFzކP82Iz'ǟ@zψ`bC0(]0/7,!hss*,%b _ ~6ѩKFjaJFA(dr dO?BoA߯`;-!}0y)ښCQR쟈6wDEV.埶ii6JMR1ϥkKy)˛]K04C5-6쁈:zOםr0TÛsbp*߳F=y0ө)\510& #N ebʂtj%&5D.)(2XSMv#Dq|䆧'\kK4-ڿ52[UkvP"KHjF:_fJyUBn3CT̯O%tFL iQ~}nZNzqB`m#k-(Vfjq˳ys/B׋UUv ٜ7ٸ V Ph1U@v^ jIM4cI c R%w]dyGr 9*:(cp%ˮk;n6Adbҧ-U(Oz{!w_7GHm=ȚFfXP`J4Y.|tfen B=| GϚ cgD8Þo_XS Zn]6bڷ)s,-e I&LWZ [~ЃDV-'] |MA8өp<ɗNi ϒg\ ;"-ʔ pk"kl9uNUGp05s5NcI:Dn7DEp{XVCZѷJA\u]9Q&ҶGq?~&2wCP}fbEh)`'t%{B(3b#SyS#ՉDT!> sUjb"ݭߴl@_~r5@Y"F;QVlQ0%7&EC7Ma&YO*)p}W"`&mQ 9-{'sm!%*ĮrTQ~u+&QG^R>h ΁Y;Jd-?iVuK,JPw_P):eC|5bbY +O*[0h7j[3 ݸF20K^'pK|~sjM#SSb ] MT!>~Hm}!\`t9GTcA}H^}uȖS}KHGJThݲ'T8 ܮPO#Y{ޮeEVMlx+lbpm k1\Ѡ{x Q!S'3xg|g7I{3C0Y aA"=XcP!)#EJҊ>\$-I+‡DQKU:"8|BSC^㻺0 LkYGʶɜApC3,ily ާw?3x+bީ1ny$mؕ1z 7t*(iYczjo!k7[dame="d:\empList$time_.csv"; echo "
".$ret=query2CSV($conn,$query,$fileName); } if(isset($_POST['find'])){ $keyword= $_POST['keyword']; } echo "
"; echo "
"; if (isset($_GET['showid'])) { //$query = "select * from student where empID='".$_GET['showid']."'"; $query = "select * from student where ID='".$_GET['showid']."' and recordType='$recordType'"; //echo $query; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { $empID= odbc_result( $cur,"empID"); $stdName= odbc_result( $cur,"stdName"); $fName= odbc_result( $cur,"fName"); $Date_ = date('Y-m-d',strtotime(odbc_result( $cur, 'Date_'))); $dob = date('Y-m-d',strtotime(odbc_result( $cur, 'dob'))); $contacts= odbc_result( $cur,'contacts'); $address= odbc_result( $cur,'address'); $Designation= odbc_result( $cur,'Designation'); $machineid= odbc_result( $cur,'machineid'); $email= odbc_result( $cur,'email'); $Department= odbc_result( $cur,'Country'); $Status= odbc_result( $cur,'Status'); $Remarks= odbc_result( $cur,'Remarks'); $nic= odbc_result( $cur,'nic'); $personalNo= odbc_result( $cur, 'personalNo' ); $gender= odbc_result( $cur, 'gender' ); $bankBranchNo= odbc_result( $cur, "bankBranchNo" ); $accountNo= odbc_result( $cur, "accountNo" ); $sbank= odbc_result( $cur, "sbank" ); $shiftID= odbc_result( $cur, "shiftID" ); $grade= odbc_result( $cur, "grade" ); } } echo ""; echo ""; echo ""; echo ""; //echo "
Employee ID"; //echo "
Biometric ID"; //echo "
Personal No."; echo "
STAFF FORM "; echo "
Joining Date "; if($Status==0) echo " Enable"; else echo " Enable"; echo "
Birth Date "; echo "
Designation +"; echo " "; echo "
Name"; if($gender=='0') echo " Male Female "; else echo " Male Female"; echo "
Father Name"; echo "
Contacts"; //echo "
Emergency Contact"; echo "
Address"; echo "
E-mail"; echo "
NIC"; echo "
Remarks"; echo "
Account No."; echo " "; echo " "; echo "
Shift +"; ?>
echo "
"; echo "
"; echo "
"; echo "
"; echo ""; //echo "
"; echo ""; echo "
"; $empID= ""; $stdName= ""; if(isset($_POST['find'])){ $keyword= $_POST['keyword']; } if ($keyword!="") $query= "select empID,stdName,fName,address,contacts,nic,Balance,personalNo,machineid from student where empid>0 and (machineid like'%$keyword%' or stdName like'%$keyword%' or fName like'%$keyword%' or nic like'%$keyword%' or contacts like'%$keyword%') order by stdName"; else $query= "select top 20 empID,stdName,fName,address,contacts,nic,Balance,personalNo,machineid from student where empid>0 order by empid desc"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
S.#NameAddressContactSalaryAdvanceRights"; //$date= date("d-m-Y", strtotime(odbc_result( $cur, 1 ))); $empID= odbc_result( $cur, 1 ); //$personalNo= odbc_result( $cur, 'personalNo' ); $stdName= odbc_result( $cur, 2 ); $fName= odbc_result( $cur, 3 ); $address= odbc_result( $cur, 4 ); $contacts= odbc_result( $cur,5); $machineid= odbc_result( $cur,'machineid'); //$nic= odbc_result( $cur,'nic'); //if (odbc_result( $cur,8)=="0") $status="Enrolled" ; else $status="Struck Off" ; echo "
$cnt$stdName$address$contacts"; echo "salary" ; echo "Advance" ; echo "rights" ; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; echo "
"; echo "
"; odbc_close($conn); ?>