N]ቩWäNSl"2#n\|P-{x`vL.H{->ZL](O4zWCW$oQL ZT@aVPkpV'Rq2kn/IÀbg MpRj42<\;>Xs"hd.߱Z&ɶ7/ҰL -q d$=ݥf^:fjW LXlKQ¼].fƗA,ק9ë:@c,3B ~8ˣox &!%a7/[αtZ-UyG{^I@ 80| T3LQ[E^2@4 hhYȩ  $H]@7jic̜lB/SuB{9mQOg]uc SĬ+t{lhl5Sp6bY<,'~("[Cot3bbmbu/6O0Q9zB5Dx + ҁ.U&Q`[&[}77Uv#r Ry(+,Id~-R5[ЗX I;t (oEQ^ i Z@0^5)Lgѥ 'u[n$v$m-!k)r>~r@4[1EQt:L_RIcYGnv6Z փE}롚o}2 gBHӬ߯9APqrgh#?>Ru>-e"G(<#|v+: . vK8%y{P5 PJ}0Dop^-{WөRv,޼jI9_h' 59ڢ0LMP_U"T6\v{.ON c3q{.{c`p+4';0A=̐p#ZC9*F*;Xґ0& #UUoe!q7,Z{{k'ԜX3Y{2WUh0MT4HrxKK%-zäa # 0~Sە^u[%5mܽuU-aH߁i:kORp:JPxKL5:rsb?,[дgli:xnCҫH&PNENw5v $W(IJ3*$xGc9" IסH]Q[Vz ֧UhlgX[7\ȩv+bp`iK|@Dbp0+Gbhj{7 a(oY+҇Q%;)Y9hąjdw:M awa!k;{fcDTdy>R2q{Oo`N}EXjɉRfXsNsӅ]Ƞ*ז˹-esKPbQq_%.Ge9]%Yrlr:!n/&X%iǸ)BABhF PR{:8볽qrjū9E`~g[޸5ata^rnԫP3 :`3K kWV $uploadOk = 1; $imageFileType = pathinfo($target_file,PATHINFO_EXTENSION); // Check if image file is a actual image or fake image $check = getimagesize($_FILES["fileToUpload"]["tmp_name"]); if($check !== false) { //echo "File is an image - " . $check["mime"] . ".". $target_file; $uploadOk = 1; } else { echo "File is not an image.". $target_file; $uploadOk = 0; } // Allow certain file formats if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg" && $imageFileType != "gif") { //if($imageFileType != "jpg" ) { echo "Sorry, only JPG allowed."; $uploadOk = 0; } // Check file size if ($_FILES["fileToUpload"]["size"] > 9000000) { echo "Sorry, your file is too large."; $uploadOk = 0; } // Check if file already exists if (file_exists($target_file) and $uploadOk<>0) { //echo "Sorry, file already exists."; //$uploadOk = 0; unlink($target_file); } // Check if $uploadOk is set to 0 by an error if ($uploadOk == 0) { echo "Sorry, your file was not uploaded."; // if everything is ok, try to upload file } else { if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) { //echo "The file ". basename( $_FILES["fileToUpload"]["name"]). " has been uploaded."; //$a="$autoID-".basename($_FILES["fileToUpload"]["name"]); //$autoID=getName($conn,"select autoID from alKhidmatFormTable where autoID='$autoID' and schoolautoID='$schoolautoID'"); $a="$autoID-".basename($_FILES["fileToUpload"]["name"]); $date2 = date('Y-m-d', time()); //$cur= odbc_exec( $conn, "update alKhidmatFormTable set imgPath=null" ); $oldImg=getName($conn,"select mOccupation from alKhidmatFormTable where autoID='$autoID'"); if ($oldImg!="" and file_exists("ClassPhotos/$oldImg")) unlink("ClassPhotos/$oldImg"); $query = "update alKhidmatFormTable set mOccupation='$a' where autoID='$autoID' "; //echo $query ; $cur= odbc_exec( $conn, $query ); echo ""; }else { echo "Sorry, there was an error uploading your file."; } } } if(isset($_POST['btnDel'])){ $autoID= $_POST['autoID']; if($autoID==""){ echo "Select Record Please"; }else{ if(canDelete($conn,"alKhidmatForm")=="0"){ $cur= odbc_exec( $conn, "delete from alKhidmatFormTable where autoID='$autoID' and schoolautoID='$schoolautoID' " ); $cur= odbc_exec( $conn, "delete from alKhidmatFormTableFee where autoID='$autoID' and schoolautoID='$schoolautoID'" ); $cur= odbc_exec( $conn, "delete from alKhidmatFormTablemontlyFee where autoID='$autoID' and schoolautoID='$schoolautoID'" ); $cur= odbc_exec( $conn, "delete from alKhidmatFormTablemontlyFeeTotal where autoID='$autoID' and schoolautoID='$schoolautoID'" ); echo "Record for autoID: $autoID deleted successfully"; } } } if(isset($_POST['btnSave'])){ $autoID= $_POST['autoID']; $stdName= $_POST['stdName']; $fname= $_POST['fname']; $address= $_POST['address']; $contacts= $_POST['contacts']; //$admClass= $_POST['admClass']; $classID= $_POST['classID']; //$section_= $_POST['section_']; $dob = date('Y-m-d',strtotime($_POST['dob'])); $date_ = date('Y-m-d',strtotime($_POST['date_'])); //if (isset($_POST['Status'])) $Status= 0; else $Status= 1; //$genderautoID= $_POST['genderautoID']; $profession= $_POST['profession']; $nic= $_POST['nic']; //if(getName($conn,"select 1 from alKhidmatFormTable where autoID='$autoID' and schoolautoID='".$_SESSION['schoolautoID']."' ")==""){ if($autoID==""){ $autoID=getName($conn,"select isnull(max(autoID),0)+1 from alKhidmatFormTable"); $query="insert into alKhidmatFormTable (dob,date_,nic,autoID,address,contacts,stdName,fname,classID,profession) "; $query.=" values('$dob','$date_','$nic','$autoID','$address','$contacts','$stdName','$fname','$classID','$profession')"; $cur= odbc_exec( $conn, $query ); /* $query="insert into alKhidmatFormTable (nic,autoID,contacts,address,name,fname "; $query.=",reqClass,classID,currentclass,section_,birthdate,date_,alKhidmatFormDate,religionautoID,CountryautoID)"; $query.=" values('$remarks','$entry1','$exit1','$machineautoID','$t_line','$sautoIDes','$bloodGroup','$nic','$profession','$genderautoID','alKhidmatFormTable','$Status','$autoID','$contacts','$address','$stdName','$fname','$admClass','$classID','$admClass','$section_'"; $query.=",'$dob','$date_','$date_',0,2)"; $cur= odbc_exec( $conn, $query ); */ }else{ $query="update alKhidmatFormTable set entry1='$entry1',exit1='$exit1',machineautoID='$machineautoID',t_line='$t_line',mName='$sautoIDes',contacts='$contacts',address='$address',name='$stdName',fname='$fname' "; $query.=",nic='$remarks',SMSNo='$bloodGroup',nic='$nic',Status='$Status',classID='$classID',currentclass='$admClass',section_='$section_'"; $query.=",profession='$profession',genderautoID='$genderautoID',birthdate='$dob',date_='$date_',alKhidmatFormDate='$date_' where autoID='$autoID'"; $cur= odbc_exec( $conn, $query ); } //echo $query; echo "Record Updated Successfully"; } $remarks=$autoID= "";$address= "";$fname= "";$contacts= "";$stdName= "";$fname= "";$mOccupation= ""; $admClass=null;$Status=null;$genderautoID=null;$profession=null;$nic=null; $bloodGroup= null;$classID= null;//$_POST['classID']; $date_ = date('Y-m-d',time()); $dob = date('Y-m-d',time()); if(isset($_POST['find'])){ $stdName= $_POST['stdName']; } if (isset($_GET['showautoID'])) { $autoID = $_GET['showautoID']; $isImage=getName($conn,"select MOccupation from alKhidmatFormTable where autoID='$autoID'"); if(file_exists("ClassPhotos/$isImage")){ }else{ $isImage=getName($conn,"select 1 from alKhidmatFormTable where autoID='$autoID' and img is null "); if($isImage==""){ $isImage=getName($conn,"select isnull(max(autoID),0)+1 from feeHeads "); $query="insert into feeHeads (autoID,headautoID,headType) values('$isImage','$autoID','showalKhidmatFormTableImage')"; $cur= odbc_exec( $conn,$query); //echo $query; sleep(2); } } $query = "select * from alKhidmatFormTable where autoID='$autoID'"; //echo $query; $cur= odbc_exec( $conn, $query ); while( odbc_fetch_row( $cur ) ) { $stdName= odbc_result( $cur, 'stdName' ); $autoID= odbc_result( $cur, 'autoID' ); $autoID= odbc_result( $cur, 'autoID' ); $fname= odbc_result( $cur, 'fname' ); $dob = date('Y-m-d',strtotime(odbc_result( $cur, 'birthdate'))); $classID= odbc_result( $cur, 'classID' ); $admClass= odbc_result( $cur, 'currentclass' ); $date_= date('Y-m-d',strtotime(odbc_result( $cur, 'date_'))); $alKhidmatFormDate= date('Y-m-d',strtotime(odbc_result( $cur, 'alKhidmatFormDate'))); $section_= odbc_result( $cur, 'section_' ); $address= odbc_result( $cur, 'address' ); $contacts= odbc_result( $cur, 'contacts' ); $Status= odbc_result( $cur, 'Status' ); $genderautoID= odbc_result( $cur, "genderautoID" ); $profession= odbc_result( $cur, "profession" ); $nic= odbc_result( $cur, "nic" ); $bloodGroup= odbc_result( $cur, "SMSNo" ); $t_line= odbc_result( $cur, "t_line" ); $sautoIDes= odbc_result( $cur, "mName" ); $mOccupation= odbc_result( $cur, "mOccupation" ); $machineautoID= odbc_result( $cur, "machineautoID" ); $entry1= odbc_result( $cur, "entry1" ); $exit1= odbc_result( $cur, "exit1" ); $remarks= odbc_result( $cur, "nic" ); } } //if($autoID=="") $autoID=getName($conn,"select max(autoID)+1 from alKhidmatFormTable"); echo "
"; echo ""; echo ""; echo ""; echo "
Date"; echo "
Name"; if($genderautoID=='1') echo " Male Female"; else echo " Male Female"; echo "
Father Name"; echo "
Address"; echo "
Contacts"; echo "
Birth Date"; echo "
Class "; echo "
F/G Profession"; echo "
F/G NIC"; //echo "
Remarks"; echo "
"; echo "
"; echo"		"; //echo "
"; //echo "
"; //echo "
"; if($autoID>0){ if($mOccupation!=""){ echo"$mOccupation"; echo "

"; } echo "
"; echo "
"; echo "
"; echo ""; echo "
"; echo ""; echo "
"; echo ""; echo "
"; echo "
"; } echo "
"; $autoID= ""; $stdName= ""; if(isset($_POST['find'])){ $stdName= $_POST['stdName']; } 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.UserautoID, dbo.Expenses.ChequeNo, dbo.Expenses.schoolautoID, dbo.FeeHeads.Description, dbo.FeeHeads.headautoID, dbo.FeeHeads.headType, dbo.FeeHeads.headName FROM dbo.Expenses INNER JOIN dbo.FeeHeads ON dbo.Expenses.Type = dbo.FeeHeads.autoID */ function fillCMB($conn,$IDSelected,$qry) { //$query = "select max($fieldname) from $tablename "; $opt=""; $cur2= odbc_exec( $conn, $qry); while( odbc_fetch_row( $cur2 ) ) { $ID= odbc_result( $cur2, 1 ); $stdName= odbc_result( $cur2, 2 ); if($IDSelected=="All") $opt.=""; elseif($autoID==$IDSelected) $opt.=""; else $opt.=""; } //odbc_close($conn); return ($opt); } ?>