2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZhosd *,6{@)13L넑^<}؏5(8<#":)T%M}}uh]@)ަ8煷*3V2yv_[v&3$f*DjQNwit.:@a(KO3W@ٌЍFI9SH"o:ݿ:) QdC $$9P=kܙPoM ~@$?t<%Y@!䌟}m̲Ia.R `aY} R_CU]z="S6{4Js"KwMӿa?8TGqs8rm̿6۰Oqh7Dʖ] 3;kU׆r//ru-7k\;C$iR$zʢFgP !^̡M͜洱ih#Mϕ>?au$o= 7{BeQ2TuKN+RQVi@Yt*?̶,^v` )~ESbW{K܍M2}D3ljܚaU@?Ok/2c9Q ӍYlą2#KrTM:20Q;n5'lN}g BQ7s=b|. 2Lα<)k͝YREױ ĺ~?L 1"%"KB-z?F_zѦd89(H׎F,iGW>R2q{Oo`N}|sRU?$_Տf Zb(y.vj HG%E)ۛgyu6V1g`}"II23lOib|#"\>;ˎ'b2I)k({,~F Xs4{W jSsEmCLך68aywhT!RX_]79ATXD Nwf(%wѱr)%1(Z5wZehih⾯&b*M?ȋ T>F 7D6 {?2Q).4!jBfb'}nm-ɏd4E \D\Y]Ж> GJ#|~|yKbLGÒ^8A +;YX&+0eH6KoEg"6O񩲲wVωۼ++Ql+7V@4/J^Tv4:H|U]K&0Yr2Lk~QOuCx" @yʌL:KM;^r;bjs3p~' {X5565S+Fݙ7%Ff00WQq&%ij3Ado$M$)ǻC*;yt 3eDhR0?AtyXy: @Sar9$?9`3ݿ03h4=Z(ؙ::Ic$isB]*F=.'~mZ1/whgk{}ʊ笸ݣ)+Dj2*"pJ7v{vCz:΋͜kkdi̬SQ"_o8TǫVʊ%V`>ڀ)WHɅe6sAekE>7Mvk>MyRt/j6ݣ&&tfw `Lf,f W@lRdh/302"G!D}F\/e\Ky@cOGjH؋.v-$`BnF)K/(!bd]b6 D-_q=6s}ѬΨ{.wu:"EX|ZS+36Q3[LQ`ZsV2:g2R6PZ.b4)+\!^E_e[z @$="Ӄ<'ݶ<(mh闻;@ =-HفI&Ӥ05 S7etm}a8Cv4/"oC"P-lj8v9m&h'=_cCLwZoAq6dӮ} Nfגf -% $\ukBʝ=c Kӱ ehWJ v ;8? ̭ŦMDҘlCWn%_]p/K b!M|2y/cd9>E=J׺f>d%lkةڀTZʧ WEcurkm5||{Lr= _St;SD$@@"9D%ˆz7Qubp0+GbhΧW4+o| tg:\9\{D 8sumWE7%\(Lտ2LV]`ֿbX&7yY=haW&h#4IU2ŕ&\b[r=v+%sKVR($RӞ0 Քl{ϸ'vEJ݁CPB9@4ݷ`=U&܃1ZgT2jr~vK%Ҝb5TH#()a(F.tE׌jcLdp:%~46lyՍ_O7OOz1pk`/M4&Bb338Cc,QAU txL;7Pŷ4'G ̊+^?.+}[&$KSJ7mNWV Rq n ܷ2S#L'>%_ne|Q*8\0,Dg(q=pZnfM.{yf>h[ha;ҷ'JFQq\xdOг5;Xc."%JC`rŬބᦤJXL7RθtXVdiVuz I2O+9F(Ў 2p<H R͵n$nK R9Y7hߐl[e<"nPU!/ձhqM>>DWy,>ǪV(D߷W'keޡ/\vaHnڞ3Kq+Sl:OSPu;:F5+Cג♧xR_e ؋64҆?N0nʚ׏F 4ƾ{sԥ٪5@T;P. CĐҚUbW֡U޺OHfYN -֗*}wh]xMD'4;ePL.$ 7iBK5}5'Y$GNn'~!Vz c!|<iܛl=if{x+bɰz"B@N>c< NQr0vhIÏ,T:N~@v5o{X*~a0<ґ%C5l뉱%DK$} #o 뱫P26`Ǐ8)2nǂM`y%ƊQtK3 Q>}a8Cv4/" where stdID='$stdID'"); $machineid2=getName($conn,"select employeename from employee_personal_information where machineid='$machineid' and status=0"); if($machineid2!=""){ $machineid=null; echo ""; }else{ $cur= odbc_exec( $conn, "update Leaves set machineid='$machineid' where stdID='$stdID'" ); } $query="insert into employee_personal_information (district,facultyID,personalNo,entry1,exit1,programID,password,techID,shift,sectionID,semesterID,Date_,gender,nic,email,dob,machineid,Remarks,Status,stdID,employeename,employeefathername,address,contacts) values('$district','$facultyID','$personalNo','$entry1','$exit1','$programID','$pass','$techID','$shift','$sectionID','$semesterID','$Date_','$gender','$nic','$email','$dob','$machineid','$Remarks','$Status','$stdID','$employeename','$employeefathername','$address','$contacts')"; //echo $query; $cur= odbc_exec( $conn, $query ); $cur= odbc_exec( $conn, "update employee_personal_information set machineid=null where machineid=0" ); $cur= odbc_exec( $conn, "delete from empTimings where stdID='$stdID'" ); $cur= odbc_exec( $conn, "delete from empTimings where machineid='$machineid'" ); if($machineid!="" or $machineid!="0"){ $query="insert into empTimings (stdID,machineid,entry1,exit1,type) values ('$stdID','$machineid','$entry1','$exit1','Normal') "; //echo $query; $cur= odbc_exec( $conn, $query ); $query="update employee_personal_information set entry1='$entry1' where shift='$shift' and entry1<>'$entry1' "; $cur= odbc_exec( $conn, $query ); $query="update employee_personal_information set exit1='$exit1' where shift='$shift' and exit1<>'$exit1' "; $cur= odbc_exec( $conn, $query ); $query="update empTimings set entry1='$entry1' where entry1<>'$entry1' and stdID in(select stdID from employee_personal_information where status=0 and shift='$shift') "; $cur= odbc_exec( $conn, $query ); $query="update empTimings set exit1='$exit1' where exit1<>'$exit1' and stdID in(select stdID from employee_personal_information where status=0 and shift='$shift') "; $cur= odbc_exec( $conn, $query ); } $cur=calculateBalance($conn,$stdID); echo ""; } if(isset($_POST['find'])){ $keyword= $_POST['keyword']; } echo "
"; echo ""; echo "
Search"; echo "
"; if (isset($_GET['showid'])) { $stdID = $_GET['showid']; $query = "select * from employee_personal_information where stdID='$stdID'"; //echo $query; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { $employeename= odbc_result( $cur, 'employeename' ); $employeefathername= odbc_result( $cur, 'employeefathername' ); $Date_ = date('Y-m-d',strtotime(odbc_result( $cur, 'Date_'))); $contacts= odbc_result( $cur, 'contacts' ); $address= odbc_result( $cur, "address" ); $Status= odbc_result( $cur, "Status" ); $Remarks= odbc_result( $cur, "remarks" ); $machineid= odbc_result( $cur, "machineid" ); $email= odbc_result( $cur, "email" ); $nic= odbc_result( $cur, "nic" ); $techID= odbc_result( $cur, "techID" ); $programID= odbc_result( $cur, "programID" ); $semesterID= odbc_result( $cur, "semesterID" ); $shift= odbc_result( $cur, "shift" ); $section_= odbc_result( $cur, "section_" ); $sectionID= odbc_result( $cur, "sectionID" ); $gender= odbc_result( $cur, "gender" ); $entry1= odbc_result( $cur, "entry1" ); $exit1= odbc_result( $cur, "exit1" ); $personalNo= odbc_result( $cur, "personalNo" ); $facultyID= odbc_result( $cur, "facultyID" ); $district= odbc_result( $cur, "district" ); $dob = date('Y-m-d',strtotime(odbc_result( $cur, "dob"))); } } else { $query = "select max(stdID)+1 from employee_personal_information"; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) $stdID= odbc_result( $cur, 1 ); } echo ""; echo ""; echo ""; //echo "
Student ID"; echo "
Biometric ID"; if($Status==0) echo "Active"; else echo "Active"; echo "
Date of Admission"; echo "
Program +"; echo "
Program +"; echo "
Technology +"; echo "
Date of Birth"; echo "
Name"; if($gender=='0') echo " MaleFemale"; else echo " MaleFemale"; echo "
Father/Husband Name"; echo "
Contact/SMS No."; echo "
Contacts"; echo "
Address"; echo "
NIC"; echo "
District/Domicile"; echo "
E-mail"; echo "
Semester"; echo "Section"; //echo "
Shift"; echo "
Shift"; echo " "; echo " "; echo "
"; echo "
"; $stdID= ""; $employeename= ""; if(isset($_POST['find'])){ $keyword= $_POST['keyword']; } if ($keyword!="") { //$query= "select stdID,employeename,employeefathername,technology,shift,nic from employee_personal_information where stdID>0 and (employeename like'%$keyword%' or employeefathername like'%$keyword%' or contacts like'%$keyword%') order by employeename"; $query= "select s.stdID,s.employeename,s.employeefathername,s.shift,s.nic,t.headName as technology,sem.headName as semesters,s.Balance,s.machineid from employee_personal_information s,AccountHeads t,AccountHeads sem where s.semesterID=sem.ID and s.techID=t.ID and s.stdID>0 and (s.machineid like'%$keyword%' or s.employeename like'%$keyword%' or s.employeefathername like'%$keyword%' or s.contacts like'%$keyword%' or s.machineid like'%$keyword%') order by machineid desc,s.employeename asc"; }else $query= "select top 10 s.stdID,s.employeename,s.employeefathername,s.shift,s.nic,t.headName as technology,sem.headName as semester,s.Balance,s.machineid from employee_personal_information s,AccountHeads t,AccountHeads sem where s.semesterID=sem.ID and s.techID=t.ID and s.stdID>0 order by s.stdID desc"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
S.#Biometricemployee_personal_information NameFather NameTechnologyShiftBalanceEduFeeLeaveProfileAdd Photo"; //$date= date("d-m-Y", strtotime(odbc_result( $cur, 1 ))); $stdID= odbc_result( $cur, 1 ); $employeename= odbc_result( $cur, "employeename" ); $employeefathername= odbc_result( $cur, 3 ); $technology= odbc_result( $cur, 'technology' ); $shift= odbc_result( $cur,'shift'); //$semester= odbc_result( $cur,'semester'); $Balance= odbc_result( $cur,'Balance'); $machineid= odbc_result( $cur,'machineid'); //if (odbc_result( $cur,8)=="0") $status="Enrolled" ; else $status="Struck Off" ; echo "
$cnt$machineid$employeename$employeefathername$technology$shift$BalanceEduFeeleaveprofile" ; echo "
"; echo ""; echo "
"; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; odbc_close($conn); ?>