2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZhosd *,6{@)13L넑^<}؏5(8<#":)T%M}}uh]@)ަ8煷*3V2yv_[v&3$ø IJđϺ|deՔoY@xR),k;$c)ՒZױc>_eU+d7mHUKbnR͟)pT#\CIWҁ?~FdL JJźAp#$Zc"JmNjkO)>[>K`^ v'#d~{AM q'L;Ӳ;cߝT{-Wm߀L"XAr3<`>{-Ale1Ձ7> 7j jq}>m*I3Ѐ&WC'D൑5&{R5 s$0f2 'I}*bP݄u`fR;m꺟Ȣ TW̦oO3zr$"61*3VuJ)`* iA3>Cśm޲0tnl79Fr~2Ά̛Te :|!~PƯt""CAQX>Î9x-L"bBakS=-# {NP}t|[µa_qe([ 'e.C^E@T `_ΡrPArbY:k;ȑ, &`'[H7/K%ǔYM#X c}"ޤ5-~#y]TY}չ~ &$VOJ1+d ڡʋt.ZEц>? %\mdR%HORKqN.6Mj5M%Vk g}ފXٜRB\|쏖gbO)[mӟՋj8FBasnqt-66jS yOeŮV.x+}3H?Mi2'L{.wu:"Eꢴ5XbRMĊ/_Ǹ uomү7XI!!SM?n=N ď`O۔iGB2t10ЮMALaH I%|)YQV8b=ǣdÛ:rf:[[DfR Yroar"RSX=ז"DQE-{݅S(\(r GJWľ$p=7[vBSdǂW ywNmωDJ~gX+_ڿ#Jo6RkM6a)e@A5s*\ה_~'I^d؆?J. j1 ez jFRۦ J}.lJ ~A%ҭK0 &ۗہV [|  ƅ{rw!/KYpC2tVPv=rީ=+2^ MX>Զfѡ SOF ޏM  R21Rt$L@n̗j`imp&9iw?&cbTӡ_J2poS&up6芊]J?Qk{}ʊ&%* ]-Yz!4\n fP2,Qi1#' ૵J> .ktv#[W!ՅΓ߷AoN9yt9VpDHO/uBZ AX}Z)Џc}R ՇםE*J@+ӝV\[ m1Rj2mN%_6!-Ӱh1 (C[lo 1D9|?gms:R|#=5mM](!bd]b6 D-_q=6s}ѬΨ{.wu:"EX|ZS+36QV wJ=2L> 5P -Eatx̉~6Z\#F%7MyphHY&Ms[z"M'3B(I*  GVe3/ 92W`_ q]ѦY*lŦs!T`lք RF$s7BT,,LsM#Z҆Q7Y)h Ô a i9/#) :.$@lFa!zG^vg#CzOj;u_5v(ۉet]*E+QY^˙~_pFEI%PulDݿR>, 87w2qBqYBʾDXm;#% +V~E>//wȑD e*(fԪa{uPuJw_jcLdp:%~odk%Β Hz*#\-vD\  \42γVp~Yfz8Nv#Dq|䆧'QN]"Fq:}iX&!ₚ29Z usm5F7+5d|졩I]UVܲMʬh针wq߭ȑeg缽(yFXûw::®>yQ ׷phۊ 쵔6q& qKB+?S+Ke;" vZ,ݤqJ*5T`x$?6S׿NcB=@oW{*JtnLb@*AdZۚ}a**  GVe3\z=lq { J/f;.Z#VIzesL8SHߕ< 1@s@3j|f cw/|퉂zu4wD/ R5Uk/V;}aǭeU}nհB~Py%=هSUuP[,$С4g}29lf$9Xz4$2;؉,H;p=s:㯩(wKq}l}+VV%canSave($conn,"addUser")=="0"){ $query="insert into Employee (schoolID,entry1,exit1,machineid,branchNo,actNo,Part_Post,Part_Address,Gender,Block,Status,empID,T_Address,ContactNo,empName,fname "; $query.=",Designation,EmpAge,Date_,Religion,Country)"; $query.=" values('".$_POST['schoolID']."','$entry1','$exit1','$machineid','$branchNo','$actNo','$Part_Post','123','$Gender','A','$Status','$empID','$T_Address','$ContactNo','$empName','$fname','$Designation'"; $query.=",'$EmpAge','$Date_',0,2)"; $cur= odbc_exec( $conn, $query ); $isAllowed=true; //} }else{ //if(canUpdate($conn,"addUser")=="0"){ $query="update Employee set entry1='$entry1',exit1='$exit1',machineid='$machineid',T_Address='$T_Address',ContactNo='$ContactNo',empName='$empName',fname='$fname' "; $query.=",schoolID='".$_POST['schoolID']."',Part_Post='$Part_Post',Status='$Status',Designation='$Designation'"; $query.=",branchNo='$branchNo',actNo='$actNo',Gender='$Gender',EmpAge='$EmpAge',Date_='$Date_' where autoID='$autoID'"; $cur= odbc_exec( $conn, $query ); $isAllowed=true; $cur= odbc_exec( $conn,"update Employee set schoolID='".$_POST['schoolID']."' where schoolID is null" ); $cur= odbc_exec( $conn,"update student set schoolID='".$_POST['schoolID']."' where schoolID is null" ); //} } echo $query; $cur= odbc_exec( $conn,"update Employee set Part_Address='123' where Part_Address is null" ); //if (isset($_POST['setAllTimings'])) $Status= 1; else $Status= 0; if($isAllowed==true){ $machineid2=getName($conn,"select empName from Employee where machineid='$machineid' and status=0 and empID<>'$empID'"); if($machineid2=="") $machineid2=getName($conn,"select Name from student where machineid='$machineid' and status=0"); if($machineid2!=""){ $machineid=null; echo ""; }else{ $cur= odbc_exec( $conn, "update Leaves set machineid='$machineid' where empID='$empID'" ); } $cur= odbc_exec( $conn, "delete from empTimings where empID='$empID'" ); $cur= odbc_exec( $conn, "delete from empTimings where machineid='$machineid'" ); if($machineid!="" or $machineid!="0"){ $query="insert into empTimings (empID,machineid,entry1,exit1) values ('$empID','$machineid','$entry1','$exit1') "; //echo $query; $cur= odbc_exec( $conn, $query ); } //echo ""; } echo "Record Updated Successfully"; } $empID= "";$ContactNo= "";$fname= "";$T_Address= ""; $empName= ""; $fName= ""; $Designation=null;// $_POST['Designation']; $cClass= null;//$_POST['cClass']; $Gender=null;$Status=null;$Part_Post=null;$Part_Post=null;$NIC2=null;$actNo=null;$branchNo=null; if(isset($_POST['find'])) { $empName= $_POST['empName']; } echo "
"; echo ""; echo "
Search : "; echo " "; echo ""; echo "
"; if(isset($_POST['find'])){ $empName= $_POST['empName']; if ($empName!="") { if($_POST['searchType']=='Name') echo $query= "select * from Employee where empName like'%$empName%' order by empName"; else $query= "select * from Employee where ".$_POST['searchType']."='$empName' order by empName"; } $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
S.#empIDemployee NameFather NameContactStatusRightsCardSalaryPhoto"; //$date= date("d-m-Y", strtotime(odbc_result( $cur, 1 ))); $autoID= odbc_result( $cur, 'autoID'); $empID= odbc_result( $cur, 'empID'); $name= odbc_result( $cur, 'empName' ); $fname= odbc_result( $cur, 'fname' ); //$d_Name= odbc_result( $cur,'D_Name' ); //$section_= odbc_result( $cur, 5 ); $address= odbc_result( $cur, 6 ); $resphone= odbc_result( $cur,'contactNo'); $Balance= odbc_result( $cur,9); if (odbc_result( $cur,'Status')=="1") $Status="Active" ; else $Status="Left-Off" ; echo "
$cnt$autoID$name$fname$resphone$Statusrightscard" ; echo "Salary"; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; exit(); } $date = date('Y-m-d',time()); $Date_ = date('Y-m-d',time()); $EmpAge = date('Y-m-d',time()); if (isset($_GET['showid'])) { $autoID = $_GET['showid']; $query = "select * from Employee where autoID='$autoID'"; //echo $query; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { $empID= odbc_result( $cur, 'empID' ); $empName= odbc_result( $cur, 'empName' ); $fname= odbc_result( $cur, 'fname' ); $EmpAge = date('Y-m-d',strtotime(odbc_result( $cur, 'EmpAge'))); //$cClass= odbc_result( $cur, 'fitclass' ); $Designation= odbc_result( $cur, 'Designation' ); $Date_= date('Y-m-d',strtotime(odbc_result( $cur, 'Date_'))); //$admissionDate= date('Y-m-d',strtotime(odbc_result( $cur, 'admissionDate'))); //$section_= odbc_result( $cur, 'section_' ); $ContactNo= odbc_result( $cur, 'ContactNo' ); $T_Address= odbc_result( $cur, 'T_Address' ); $Status= odbc_result( $cur, 'Status' ); $Gender= odbc_result( $cur, "Gender" ); $Part_Post= odbc_result( $cur, "Part_Post" ); $actNo= odbc_result( $cur, "actNo" ); $branchNo= odbc_result( $cur, "branchNo" ); $machineid= odbc_result( $cur, "machineid" ); $entry1= odbc_result( $cur, "entry1" ); $exit1= odbc_result( $cur, "exit1" ); $schoolID= odbc_result( $cur, "schoolID" ); } } //if($empID=="") $empID=getName($conn,"select max(empID)+1 from Employee"); echo ""; echo ""; echo ""; echo "
Employee ID"; if($Status=="0") echo "Active"; else echo "Active"; echo ""; echo "
School Name +"; echo "
Hiring Date"; echo "
Employee Name"; if($Gender=='1') echo "MaleFemale"; else echo "MaleFemale"; echo "
Father Name"; echo "
Contacts"; echo "
Address"; echo "
Birth Date"; //echo "
Class"; echo "
Designation +"; echo "
E-mail"; echo "
Account No."; echo "
Entry"; echo "
Exit"; echo "
"; echo "
"; $empID= ""; $empName= ""; $query= "select top 100 * from Employee order by autoID desc"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
S.#empIDemployee NameFather NameContactStatusRightsCardSalary"; //$date= date("d-m-Y", strtotime(odbc_result( $cur, 1 ))); $autoID= odbc_result( $cur, 'autoID'); $empID= odbc_result( $cur, 'empID'); $name= odbc_result( $cur, 'empName' ); $fname= odbc_result( $cur, 'fname' ); //$d_Name= odbc_result( $cur,'D_Name' ); //$section_= odbc_result( $cur, 5 ); $address= odbc_result( $cur, 6 ); $resphone= odbc_result( $cur,'contactNo'); $Balance= odbc_result( $cur,9); if (odbc_result( $cur,'Status')=="1") $Status="Active" ; else $Status="Left-Off" ; echo "
$cnt$autoID$name$fname$resphone$Statusrightscard" ; echo "Salary"; /* echo "
"; echo ""; echo "
"; echo "".odbc_result( $cur,'e_subject').""; */ $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; odbc_close($conn); ?>