I:ܫc+]YF3KD $ײ >WQz'.﵁.g+x7b%ߗfwZYŠF|d5]lzQꌌWo{ v6'TŒ{SQvtJC,!_KgM'QhWj,hT'ݹ =𴋓ñLk:hwi13u#:\MPRcr Y G{+GI`m`>Xɫ AD- ; dž KxbM3,NrJPF e5iZLjH X_$9^7?Oܯ$ Z7%IZZXkX9Ė~ PkEtWK%msQ-] mdLqZK@!* |WN@1B6㰞gO dڼ:v e$HkŠFLp+gf@ͮt/s()!DcH7>3g̉1fËfyՌ$XI<#Тm1'!Gr,|bNa2fxL7>c.BB0e'8mة1~C5tZ] oRbJ߃2j]Š >?lzm ZB)OO%n+ˀ+fѦ[;WT|<jcm p \'S=iI|Pv@"w춱"չp7c߿Ι-S`/gU:i[tn}ۗ& y g<:SD}' %yJum4A]d5R7|荧@0*V Wjn'Ve9ʼ&jN 7 ~ϔהA&eRBI74w\2|Hi\/Y#5B zL9 {]}bvxc-ZcU1LI% d:ꪍ(2ْXڹ!DR.]+$-?Vd*\9eUnB3JZ#B:HoG ObXkwv=H [FU~~Ɇ6_OO/WSfϒFoVP‹8!|fRݾBS:Os 4MnD~+_`Eתu^~vׂ_~^WROA9< cںIx퇽y(t6ʹ)\GqcM> k5 9MatC>8q/{W 8{kBU X&Xkݕ 12ݙ&c\(-|Y'"]A.-0C讁y{26ӋkRq%ߴi[Z9ZJ`- FK2L?6Razbr'1f\z[D6ОXP,&#9o PлEQg>(ٟ+t(B3JZ#B:HoG ObXkwv=H [FU~~Ɇ6_OO/WSfϒFꥠ %;‡(&$Ror4n'0U! i!B8xJIbP1n6/I:6%_ WxnnSaA%O#;ٗ{Q v|'v y8MK(X 4m-^͓n8:ψeYtЭ3a q )fz4צTEя7a_e6\iĠdVN B+uL%üY &!;IEmRMUQwSjOMǰ1fڡ,ef֩"NCNK]#fYZ BIu#yva”ޘRBˆ ׂ_~^WROA9getCellByColumnAndRow($col, $row)->getValue()); $values.=",'".$str."'"; } } $stdName=str_replace("'","''",$worksheet->getCellByColumnAndRow(2, $row)->getValue()); $fname=str_replace("'","''",$worksheet->getCellByColumnAndRow(3, $row)->getValue()); $isPresent=getName($conn,"select ID from student where stdName='$stdName' and fname='$fname' and programID='$classID' and sectionID='$sectionID' and labid='".$_SESSION['labid']."' "); if($isPresent==""){ $query="insert into student($fields) values($values) "; if($classID!="" and $sectionID!=""){ odbc_exec($conn,$query); $cnt++; } echo "
".$query; } } odbc_exec($conn,"update Student set techID=programID where techID is null and recordType='Std' and labid='".$_SESSION['labid']."'"); } }else{ $output = ''; //if non excel file then } echo " $cnt Records uploaded successfully"; } //echo $output; if(isset($_POST['btnFeeSlips'])){ //$date_ = $_POST['date_']; //$batchNo = $_POST['batchNo']; $programID = $_POST['programID']; $sectionID = $_POST['sectionID']; //$session_ = $_POST['session_']; $qry=" programID='$programID'"; $dueDate =(date('Y-m-d',strtotime($_POST['dueDate']))); $dueDate=addHeadValue($conn,'dueDateFee',$dueDate); echo ""; } if(isset($_POST['btnDebitors'])){ //$date_ = $_POST['date_']; //$batchNo = $_POST['batchNo']; $programID = $_POST['programID']; $sectionID = $_POST['sectionID']; //$session_ = $_POST['session_']; $qry=" programID='$programID'"; echo ""; //echo ""; //echo ""; } if(isset($_POST['submit'])){ // upload echo "








"; //$date_ = $_POST['date_']; //$batchNo = $_POST['batchNo']; $programID = $_POST['programID']; $sectionID = $_POST['sectionID']; //$session_ = $_POST['session_']; $qry=" programID='$programID'"; //$date_= date("Y-m-d", strtotime($_POST["date_"])); $extension = end(explode(".", $_FILES["excel"]["name"])); // For getting Extension of selected file $allowed_extension = array("xls", "xlsx", "csv"); //allowed extension if(in_array($extension, $allowed_extension)) //check selected file extension is present in allowed extension array { $file = $_FILES["excel"]["tmp_name"]; // getting temporary source of excel file include("classesExcel/PHPExcel/IOFactory.php"); // Add PHPExcel Library in this code $objPHPExcel = PHPExcel_IOFactory::load($file); // create object of PHPExcel library by using load() method and in load method define path of selected file foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) { $highestRow = $worksheet->getHighestRow(); $cols=0; while(strlen($worksheet->getCellByColumnAndRow($cols,1)->getValue())>0) { $cols+=1; } $cols =11; //$fields="date_,ID,labid,programID,sectionID,batchNo,stdName,gender,fname,nic,Contacts,dob,address"; $fields="recordType,date_,ID,labid,programID,sectionID,stdName,fname,batchNo,Contacts,nic,gender,dob"; for($row=2; $row<=$highestRow; $row++) { $stdID=getName($conn,"select max(ID)+1 from student "); $values="'Std','$date_','$stdID','".$_SESSION['labid']."','$programID','$sectionID'"; for($col=0; $col<$cols; $col++) { if($col==10){ // for doa , dob $excelDate = $worksheet->getCellByColumnAndRow($col, $row)->getValue(); $date_ = \PHPExcel_Style_NumberFormat::toFormattedString($excelDate, 'YYYY-MM-DD'); if($date_=="") $date_= date("Y-m-d", time()); $values.=",'$date_'"; }elseif($col==9){ // gender $str=str_replace("'","''",$worksheet->getCellByColumnAndRow($col, $row)->getValue()); if(strtoupper($str)=="MALE") $str=1; else $str=0; $values.=",'".$str."'"; }elseif($col==0 or $col==3 or $col==4 or $col==5){ $a="do nothing"; }else{ $str=str_replace("'","''",$worksheet->getCellByColumnAndRow($col, $row)->getValue()); $values.=",'".$str."'"; } } $stdName=str_replace("'","''",$worksheet->getCellByColumnAndRow(1, $row)->getValue()); $fname=str_replace("'","''",$worksheet->getCellByColumnAndRow(2, $row)->getValue()); $isPresent=getName($conn,"select ID from student where stdName='$stdName' and fname='$fname' and labid='".$_SESSION['labid']."' "); if($isPresent==""){ $query="insert into student($fields) values($values) "; odbc_exec($conn,$query); echo "
".$query; } } } }else{ $output = ''; //if non excel file then } echo "Data uploaded successfully"; } //echo $output; if(isset($_POST['btnBulkUpdate'])){ $cnt = $_POST['cnt']; $sectionID = $_POST['sectionID']; $programID = $_POST['programID']; $query="update student set ID=ID "; if ($sectionID!="") $query.=",sectionID='$sectionID'"; if ($programID!="") $query.=",programID='$programID'"; if ($session_!="") $query.=",session_='$session_'"; if ($batchNo!="") $query.=",batchNo='$batchNo'"; $ids=""; if(isset($_POST['checkAll'])){ foreach($_POST['checkAll'] as $value) { if($ids=="") $ids=$value; else $ids.=",".$value; } } //echo "
".$ids; if(canSave($conn,"uploadStudentXls")=="0"){ if($ids!=""){ $qry=$query." where ID in($ids) "; $cur= odbc_exec( $conn, $qry ); //echo "
".$qry; } } } if(isset($_POST['btnBulkCards'])){ $cnt = $_POST['cnt']; //$batchNo = $_POST['batchNo']; //$teacherID = $_POST['teacherID']; $sectionID = $_POST['sectionID']; $programID = $_POST['programID']; //$session_ = $_POST['session_']; $query="update student set ID=ID "; if ($sectionID!="") $query.=",sectionID='$sectionID'"; if ($programID!="") $query.=",programID='$programID'"; if ($session_!="") $query.=",session_='$session_'"; if ($batchNo!="") $query.=",batchNo='$batchNo'"; $ids=""; if(isset($_POST['checkAll'])){ foreach($_POST['checkAll'] as $value) { if($ids=="") $ids=$value; else $ids.=",".$value; } } //echo "
".$ids; if($ids!=""){ echo ""; } } if(isset($_POST['btnCards2'])){ $section_ = $_POST['section_']; $fitclass = $_POST['fitclass']; $boxIds = $_POST['boxIds']; $query="update student set ID=ID "; if ($section_!="") $query.=",section_='$section_'"; if ($fitclass!="") $query.=",fitclass='$fitclass'"; if ($session_!="") $query.=",session_='$session_'"; //if ($boxIds!="") $query.=",boxIds='$boxIds'"; //echo "
".$ids; if($boxIds!=""){ echo ""; } } ?> HOME
Class
Section
Data (xls)
.

Data (xls)


xls data format
"; $query.=" order by ID "; if(!isset($_POST['submit'])) $query= "select ID,stdName,fname,personalNo,machineid,balance from student where 1=2"; //echo $query; $cur= odbc_exec( $conn, $query ); $cnt=1; while( odbc_fetch_row( $cur ) ) { if ($cnt==1) echo "
S.#Student NameFather NameContactBalance"; //$date= date("d-m-Y", strtotime(odbc_result( $cur, 1 ))); $stdID= odbc_result( $cur, 'ID' ); $stdName= odbc_result( $cur, "stdName" ); $fName= odbc_result( $cur, 'fname' ); $personalNo= odbc_result( $cur,'personalNo'); echo ""; echo "
$cnt"; echo ""; echo "$stdName$fName$personalNo"; echo "".odbc_result( $cur,'Balance'); $cnt+=1; } echo "
"; $cnt-=1; echo ""; echo ""; echo ""; //echo ""; echo ""; echo ""; //echo ""; if($cnt>0){ /* echo "
Program
"; echo "		Semester
"; echo "		Session
"; echo "		Batch No.
"; echo "		"; echo ""; //echo ""; */ echo "
"; } if ($cnt==0) echo "

No Record Found

"; ?>