2-;R$?1祧WgբxakL!\ҷjs%تq~,cH0RZhosd *,6{@)13L넑^<}؏5(8n${[Dy8>)M2h)\ݩ=1pr;V} z#@aGօ\4c˄iEbqhN&.'8Zc JP,'yAy8 4 ~۪y5VrD51nx#j>JWEQMlx+lbpmMk|!SL gش $gSijDv)0@-b=R%=-# {NP}t|[µa_qe([ 'e.C^E@T `_Ρt'쯀]h1Jݾ$t3K;9%m6`6NSL!`Y0r&9M{> EaH&S Ź32MsscH&2K#?;.6I[PMIvsjgq:qVԐ5>CeeNPXvt`uuϳ r[KmPB0 AEV b+~U;ꈬ$_2.s}.eÙo_xmڤxKXd5kK||TWmaM 볽qrjū9E`~g[޸5ata^rnԫP3 :`3K kWVD4[kX7׋5=ug sUt ^p0)I2^B/B|$r 02x846-Gj,N\G| B,06TXEL`r OJ gqor[zsXP'eqB40,ߗnrAQޢ+G^ ^`5`bvTpPD3otBO韛Ft0GKVz@l屇p {zTFPnsq >ZL^۳En0v"Wf>6C(tE3jvuU?xY qm,JwX8j;Nd^Vo:t {6ْI}\Q7//HfX|nx|R-%]P#;D ͖XƋ Q\؍,5ZOj}l{ӫAy0￧vAg8ޞT1100U+<DJ~gX+_ڿ#J::V(Qޮ\kK#-еD,A|+&@+kgTA4s2Ƕ[V/奄0@\ P~0 dLTߣ /^p)&0 PG_+IOEG N+WepX6̘7N3cSC&Az,r%QBR ˿\C$h]"WOu+2l~Z |– (7C#ua߉s/el/%`gov+jF;6YH^ HضJ\ [\=%B]*F/v"Dc 7Y ;Bܹ&ꝇ/γ1SyB*C HtR ?^NW^b)LvĻnP? cZXF + Q.,B$RPf;<[GK67#'Kʚ%t -%se6sAekE>7Mvk>Mԇ_[6.< 3՗wsf9oV8dv/GlRdh/302"G!D}F\/e\Ky@cOGjH؋.js6ZD^*b;ť+\#|j,oUs^r;bjs3}o]iٹOE0GxF#ToCc4$T|=cn@݉fX@NulJ ~A%ҭK#%kmhEHXyڐijs1>=+ԥ0^S5ǬӤO#?3H>~A~}5fx s#T&JY*;HIcZ-kC"}ml^KOnPϻvOML~* c3G~yKTkuPœ^!1 Tn48d@CpE$aNvlMᵶ(m#,q|`㄂ZC3ZoۄEKy;OHF>(C_lT)PAta B~\ UidOض!.<$OG5EJ@E~QHuP,97ep̙zQ$@|8ƙX7qs;u(1O[u1 dEBIz}#\t+NyKQq$\!隊tX>Î9x-xbSkH8`|{}~ehjuK:.ꕪ~9v|jxΥ|9 _9Uq%B@):VPO] uɽKd|,O7b5v[D[]\ܦ6TfObeT6-:h̖э.k5jT|ևT}.aIg%HV7>{͆)k⪲;7W !\ W8nG3L[8BZXfϪҕi(shc/.04o/TeNFZK^/d4Fhs-?N&\'*  GVe3 BK.{I[PMIvsjvf? 'U-!sۆv`nN&(ZY;=~Ӣe~]e۷թ `,J.E6lXF dJ5 )IHӿm2ǖq-TtcϸN~'Dz)icurkm5Ҟ#h1!^ѝ':W lM*G$}G^R>hTX҃`WϊrW)6Gd2U 1ğV,yAj~N! tEٟ5C,Ň"娴/ ZF  sYf^C;PԴ'ihnHEM#0M}GJk9ϙl*ٽcPaqA[iU3Nf2KHJzb,MZ63J]5B!;3KZZVx-uuw6!QnePhBr<]4Ǭi3Y_Û+A; $PreAddress= $_POST['PreAddress']; $admClass= $_POST['admClass']; $cClass= $_POST['cClass']; $section_= $_POST['section_']; $dob = date('Y-m-d',strtotime($_POST['dob'])); $admDate = date('Y-m-d',strtotime($_POST['admDate'])); if (isset($_POST['Status'])) $Status= 0; else $Status= 1; $genderID= $_POST['genderID']; $GProfession= $_POST['GProfession']; $NIC2= $_POST['NIC2']; $bloodGroup= $_POST['bloodGroup']; $t_line= $_POST['t_line']; $sides= $_POST['sides']; $machineid= $_POST['machineid']; $entry1= $_POST['entry1']; $exit1= $_POST['exit1']; $remarks= $_POST['remarks']; $curRecord=$stdName."".$fname."".$ResPhone."".$PreAddress."".$admClass."".$dob; if($stdID==""){ if(canSave($conn,"admission")=="0"){ if(!isset($_SESSION['preRecord']) or $_SESSION['preRecord']!=$curRecord){ $stdID=getName($conn,"select isnull(max(ID),0)+1 from student where schoolID='".$_SESSION['schoolID']."'"); $query="insert into student (nic,entry1,exit1,machineid,t_line,mName,SMSNo,NIC2,GProfession,genderID,type,Status,ID,preaddress,ResPhone,name,fname "; $query.=",reqClass,fitclass,currentclass,section_,birthdate,admDate,admissionDate,religionID,CountryID)"; $query.=" values('$remarks','$entry1','$exit1','$machineid','$t_line','$sides','$bloodGroup','$NIC2','$GProfession','$genderID','Student','$Status','$stdID','$PreAddress','$ResPhone','$stdName','$fname','$admClass','$cClass','$admClass','$section_'"; $query.=",'$dob','$admDate','$admDate',0,2)"; $cur= odbc_exec( $conn, $query ); $_SESSION['preRecord']=$stdName."".$fname."".$ResPhone."".$PreAddress."".$admClass."".$dob; } } }else{ if(canUpdate($conn,"admission")=="0"){ $query="update student set entry1='$entry1',exit1='$exit1',machineid='$machineid',t_line='$t_line',mName='$sides',preaddress='$PreAddress',ResPhone='$ResPhone',name='$stdName',fname='$fname' "; $query.=",nic='$remarks',SMSNo='$bloodGroup',NIC2='$NIC2',Status='$Status',fitclass='$cClass',currentclass='$admClass',section_='$section_'"; $query.=",GProfession='$GProfession',genderID='$genderID',birthdate='$dob',admDate='$admDate',admissionDate='$admDate' where ID='$stdID'"; $cur= odbc_exec( $conn, $query ); } } /* if($isAllowed==true){ $machineid2=getName($conn,"select empName from Employee where machineid='$machineid' and status=0"); if($machineid2=="") $machineid2=getName($conn,"select Name from student where machineid='$machineid' and status=0 and ID<>'$stdID'"); if($machineid2!=""){ $machineid=null; echo ""; }else{ $cur= odbc_exec( $conn, "update Leaves set machineid='$machineid' where stdID='$stdID'" ); } $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) values ('$stdID','$machineid','$entry1','$exit1') "; //echo $query; $cur= odbc_exec( $conn, $query ); } //echo ""; } */ echo "Record Updated Successfully"; } $remarks=$stdID= "";$ResPhone= "";$fname= "";$PreAddress= "";$stdName= "";$fName= "";$mOccupation= ""; $admClass=null;$Status=null;$genderID=null;$GProfession=null;$NIC2=null; $bloodGroup= null;$cClass= null;//$_POST['cClass']; if(isset($_POST['find'])){ $stdName= $_POST['stdName']; } $date = date('Y-m-d',time()); $admDate = date('Y-m-d',time()); $dob = date('Y-m-d',time()); if (isset($_GET['showid'])) { $ID = $_GET['showid']; $isImage=getName($conn,"select MOccupation from student where ID='$ID'"); if(file_exists("ClassPhotos/$isImage")){ }else{ $isImage=getName($conn,"select 1 from student where ID='$ID' and img is null "); if($isImage==""){ $isImage=getName($conn,"select isnull(max(ID),0)+1 from feeHeads "); $query="insert into feeHeads (ID,headID,headType) values('$isImage','$ID','showStudentImage')"; $cur= odbc_exec( $conn,$query); //echo $query; sleep(2); } } $query = "select * from student where ID='$ID'"; //echo $query; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { $stdName= odbc_result( $cur, 'name' ); $ID= odbc_result( $cur, 'ID' ); $stdID= odbc_result( $cur, 'ID' ); $fname= odbc_result( $cur, 'fname' ); $dob = date('Y-m-d',strtotime(odbc_result( $cur, 'birthdate'))); $cClass= odbc_result( $cur, 'fitclass' ); $admClass= odbc_result( $cur, 'currentclass' ); $admDate= date('Y-m-d',strtotime(odbc_result( $cur, 'admDate'))); $admissionDate= date('Y-m-d',strtotime(odbc_result( $cur, 'admissionDate'))); $section_= odbc_result( $cur, 'section_' ); $ResPhone= odbc_result( $cur, 'ResPhone' ); $PreAddress= odbc_result( $cur, 'PreAddress' ); $Status= odbc_result( $cur, 'Status' ); $genderID= odbc_result( $cur, "genderID" ); $GProfession= odbc_result( $cur, "GProfession" ); $NIC2= odbc_result( $cur, "NIC2" ); $bloodGroup= odbc_result( $cur, "SMSNo" ); $t_line= odbc_result( $cur, "t_line" ); $sides= odbc_result( $cur, "mName" ); $mOccupation= odbc_result( $cur, "mOccupation" ); $machineid= odbc_result( $cur, "machineid" ); $entry1= odbc_result( $cur, "entry1" ); $exit1= odbc_result( $cur, "exit1" ); $remarks= odbc_result( $cur, "nic" ); } } //if($stdID=="") $stdID=getName($conn,"select max(ID)+1 from student"); echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; //echo ""; //echo " "; echo "
Admission Date"; if($Status==0) echo " Active"; else echo " Active"; echo "
Student Name"; if($genderID=='1') echo "MaleFemale"; else echo "MaleFemale"; echo "
Father Name"; echo "
Contacts"; echo "
Address"; echo "
Birth Date Blood Group: "; //echo "
Class"; echo "
Admitted Class +"; echo "
Current Class "; echo ""; echo "
F/G Profession"; echo "
F/G NIC"; echo "
Transport"; echo " "; echo "
Timing"; echo " "; echo "
Remarks"; echo "
"; echo "
"; echo"		"; echo "
"; echo "
"; ?> "; if($ID>0){ if($mOccupation!=""){ echo"$mOccupation"; echo "

"; } echo "
"; echo "
"; echo "
"; echo ""; echo "
"; echo ""; echo "
"; echo ""; echo "
"; echo "
"; } echo "
"; $stdID= ""; $stdName= ""; if(isset($_POST['find'])){ $stdName= $_POST['stdName']; } if ($stdName!="") $query= "select ID,name,fname,classfit,sectionname,preaddress,resphone,Status,Balance,mOccupation,ID from studentview where ID like'%$stdName%' or name like'%$stdName%' or fname like'%$stdName%' or resphone like'%$stdName%' or preaddress like'%$stdName%' order by name"; else $query= "select top 100 ID,name,fname,classfit,sectionname,preaddress,resphone,Status,Balance,mOccupation from studentview order by ID desc"; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
S.#IDStudent NameFather NameClassSecStatusBalanceComentsFeeCardFeeOldBirthSLCForm"; //$date= date("d-m-Y", strtotime(odbc_result( $cur, 1 ))); $ID=odbc_result( $cur, 'id'); $id= odbc_result( $cur,'id'); $name= odbc_result( $cur, 2 ); $fname= odbc_result( $cur, 3 ); $class= odbc_result( $cur, 4 ); $section_= odbc_result( $cur, 5 ); $address= odbc_result( $cur, 6 ); $resphone= odbc_result( $cur,7); $Balance= odbc_result( $cur,9); if (odbc_result( $cur,8)=="0") $Status="Enrolled" ; else $Status="Struck Off" ; echo "
$cnt".odbc_result($cur,'ID')."$name$fname$class$section_$Status$Balance"; echo "Coments" ; echo "feecard"; echo "feeOld"; echo "Birthslc" ; echo "adm" ; $cnt+=1; } echo "
"; if ($cnt==1) echo "No Record Found"; odbc_close($conn); /* drop VIEW dbo.Expenses_View1; CREATE VIEW dbo.Expenses_View1 AS SELECT dbo.Expenses.Vno, dbo.Expenses.date1, dbo.Expenses.date2, dbo.Expenses.Remarks, dbo.Expenses.Afghani, dbo.Expenses.PakRs, dbo.Expenses.Dollors, dbo.Expenses.Type, dbo.Expenses.VehicleNo, dbo.Expenses.UserID, dbo.Expenses.ChequeNo, dbo.Expenses.schoolID, dbo.FeeHeads.Description, dbo.FeeHeads.headID, dbo.FeeHeads.headType, dbo.FeeHeads.headName FROM dbo.Expenses INNER JOIN dbo.FeeHeads ON dbo.Expenses.Type = dbo.FeeHeads.ID */ ?>