import_excel_ud.php

<?php
// TA:60:4
$page_title = "Education sector | GBV ";
$current_page = "home";

require_once 'includes/global.inc.php';

// check to see if they're logged in
if (isset($_SESSION['logged_in'])) {
    
    // get the user object from the session
    $user = unserialize($_SESSION['user']);
    
 if( !($userTools->isSuperAdmin($user->user_group) || ($userTools->isAdmin($user->user_group) &&  $userTools->judiciary($user->sector)))){
        print " You do not have permission to access this page.";
        return;
    }
    
    // include "includes/Dash_header.php";include "includes/topbar.php"; //TA:60:1
    include "includes/Dash_header.php"; // TA:60:1
    include "includes/topbar.php"; // TA:60:1
    
    $sector_id = $mode = $_GET['sector_id'];
    $sector_excel_template = "";
    $sector_url_data_enter = "";
    $sector_title = "";
    if($sector_id === '1'){
        $sector_excel_template = "Sectors/Judiciary/files/Judiciary sector data entry sheet.xlsx";
        $sector_url_data_enter = "Sectors/Judiciary/enter_data.php";
        $sector_title = "Judiciary";
    }else if($sector_id === '2'){
        $sector_excel_template = "Sectors/Health/files/Health sector data entry sheet.xlsx";
        $sector_url_data_enter = "Sectors/Health/enter_data.php";
        $sector_title = "Health";
    }else if($sector_id === '3'){
        $sector_excel_template = "Sectors/Police/files/Education sector data entry sheet.xlsx";
        $sector_url_data_enter = "Sectors/Police/enter_data.php";
        $sector_title = "Police";
    }else if($sector_id === '4'){
        $sector_excel_template = "Sectors/Prosecution/files/Education sector data entry sheet.xlsx";
        $sector_url_data_enter = "Sectors/Prosecution/enter_data.php";
        $sector_title = "Prosecution";
    }else if($sector_id === '5'){
        $sector_excel_template = "Sectors/Education/files/Education sector data entry sheet.xlsx";
        $sector_url_data_enter = "Sectors/Education/enter_data.php";
        $sector_title = "Education";
    }else{
        echo "<br><b> Wrong sector id selected.</b>";
        return;
    }
    
    ?>
    
 

<script type="text/javascript">

    function uploadData(){

        //read file content
   	 if (window.File && window.FileReader && window.FileList && window.Blob) {
	   	    var fileSelected = document.getElementById('fileToUpload');

		   	//validate file extension
	   	    if(!fileSelected.value.endsWith('.csv')){
		   	    alert("Please upload CSV file.");
		   	    return;
	   	    }
		   	
	   	         var fileExtension = /text.*/; 
	   	         var fileTobeRead = fileSelected.files[0];
	   	         if (fileTobeRead.type.match(fileExtension)) { 
	   	             var fileReader = new FileReader(); 
	   	             fileReader.onload = function (e) { 
	   	                 var fileContents = document.getElementById('filecontents'); 
	      	              var file_content = fileReader.result.split("\n").join(";");
	      	             
		      	            $.ajax({
			      	      		  type:"post",
			      	      		  url:"<?php echo $sector_url_data_enter;?>?mode=add_aggregates_csv&data=" + file_content,     
			      	      		  beforeSend: function(  ) {
			      	      			  document.getElementById("entry_form").style.visibility = "hidden";
			      	      			  $("#progress_bar").html("<img src='UI/images/data_loading_animation.gif' width=300 height=200/>");
			      	      		  }
			      	      		})
			      	      		  .done(function( data ) {
			      	      			  $("#progress_bar").html("");
			      	      			  if(data){
			      	      				  alert(data);
			      	      			  }else{
			      	      				  alert("No any data were insirted into database.");
			      	      			  }
			      	      			  document.getElementById("entry_form").style.visibility = "visible";
			      	      			  clean_form();
			      	      		  });
		      	      		  
	   	             } 
	   	             fileReader.readAsText(fileTobeRead); 
	   	         } 
	   	         else { 
	   	             alert("Please select CSV file"); 
	   	         }  
	   	} 
	   	 else { 
	   	     alert("Files are not supported by your browser"); 
	   	 } 
    }

    </script>

<div id="main-content_with_side_bar">

	<div id="content-body">
		
		<!-- TA:60:1 -->
		<div class="profile-data" align="left">

			<!-- TA:60:1 START -->

			<div id='progress_bar' align='center'style="position: absolute; top: 250px; left: 200px;"></div>
			<div id="filecontents"></div>
			
			
			<div id="entry_form">

			<h2 class="page-title-section"><?php echo $sector_title;?> sector import excel</h2>
			
			<table width="900px" border="0" cellspacing="5"
				style='font-family: Verdana, Geneva, sans-serif; font-size: 12px;'>
				<tr>
					<td>
					Under development.
					</td>
				</tr>
			</table>
			
			</div>
			<br>
			
			


			<!-- TA:60:1 END -->


			

			<br clear="all"> <br clear="all"> <br clear="all"> <br clear="all">
			<!--&nbsp;Your MD5 encrypted password: <font color="white"><?php //echo $passwd; ?></font>-->


			<br clear="all"> <br clear="all"> <br clear="all"> <br clear="all"> <br
				clear="all"> <br clear="all">
		</div>
		<br clear="all">
		</center>
	</div>
</div>
<?php
    include "includes/footer.php";
} else {
    // Redirect user back to login page if there is no valid session created
    header("Location: login.php");
}
?>