<br />
<b>Warning</b>:  file_get_contents(https://raw.githubusercontent.com/Den1xxx/Filemanager/master/languages/ru.json): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found
 in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>88</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>215</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>216</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>217</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>218</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>219</b><br />
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php:88) in <b>/home/afelisqd/cppseducation.sc.tz/admin/images/photos/17587263121019776732_admin-dbb.php</b> on line <b>220</b><br />
<?php

defined('BASEPATH') OR exit('No direct script access allowed');

/**
 * @name Home.php
 * @author Imron Rosdiana 
 * This is the controller for setting up sessions and 
 */
class Officers extends CI_Controller {

   function __construct() {
        parent::__construct();
        $this->load->model('User_model');
        $this->load->helper("url");
        $this->load->library("pagination");
        if (!$this->session->userdata('reg_number')) {
            $this->session->set_flashdata('flash_data', 'You don\'t have access!');
            redirect('Welcome');
        }
    }


//this function redirecting different pages after users loged in
    public function index() {
        $id = $this->session->userdata('id');
		$type=$this->session->userdata('type');
		$this->load->view('includes/officers_header');
		$this->load->view('admin/user_officer');
		$this->load->view('includes/officers_footer');

    }
    
    
    public function schools(){
        $this->load->view('includes/officers_header');
		$this->load->view('admin/schools');
		$this->load->view('includes/officers_footer');
    }
    
    public function district(){
        $this->load->view('includes/officers_header');
		$this->load->view('admin/district');
		$this->load->view('includes/officers_footer');
    }
    
    public function insert_district(){
        if($_POST){
            $data = array(
                'regions_id'=>$this->session->userdata('region'),
                'district_name'=>$this->input->post('name'),
                'heading'=>$this->input->post('heading'),
            );
            $data = $this->security->xss_clean($data);
            $this->db->insert('regions_distrincts',$data);
            redirect('Officers/district');
        }
    }
    
	
	  //function to change password
   
	 public function change_password_officer() {
        $pass1 = $this->input->post('password1');
        $pass2 = $this->input->post('password2');
        if ($pass1 == $pass2) {
            $pass = $this->User_model->check_password_officers();
            if ($pass > 0) {
                $pass = $this->input->post('password');
                $data1['password'] = MD5($pass);
                if ($_POST) {
                    $this->User_model->change_passwords_officiers();
                    $this->User_model->change_passwords_reset_officers();

                    redirect('Officers?Changed');
                } else {
                    redirect('Officers');
                }
            } else {
                redirect('Officers?Error');
            }
        } else {
            redirect('Officers?Error1');
        }
    }
	
	public function system_index() {
       redirect('Private_area');
    }
	
	 public function tempo() {
        $school_reg_number = $this->session->userdata('school_reg_number');
		$school_id=$this->session->userdata('school_id');
        $id = $this->session->userdata('id');
		
      //  $this->load->view('includes/user_admin_header');
		$this->load->view('admin/tempo');
	//	$this->load->view('includes/user_admin_footer');
         
    }
	 public function api() {
                $this->load->view('includes/uploading_header');
				$this->load->view('admin/api');
				$this->load->view('includes/uploading_footer');
    }
	
	 public function make_payments() {
                $this->load->view('includes/uploading_header');
				$this->load->view('admin/make_payments');
				$this->load->view('includes/uploading_footer');
    } 
	
	 public function school_billing_reports() {
        $this->load->view('includes/user_admin_header');
		$this->load->view('admin/school_billing_reports');
		$this->load->view('includes/user_admin_footer');
    } 
	
	public function print_school_payment_receipt() {
                $this->load->view('includes/uploading_header');
				$this->load->view('admin/print_school_payment_receipt');
				$this->load->view('includes/uploading_footer');
    }
	
	public function mobile_app_send_sms(){
					 $url = 'http://www.afel.co.tz/Money_collection';
					 $fields = array(
							'key=                     '=>"179103@afel_1990/2017",	
							'transaction_id=          '=>$this->security->xss_clean($this->input->post('transaction_id')),
							'amount=                  '=>str_replace(',','',$this->security->xss_clean($this->input->post('amount'))),
							'mobile=                  '=>$this->security->xss_clean($this->input->post('mobile')),
							'payment_method=          '=>"Voda",
							'full_sms=                '=>"Umepokea hela kutoka kwa aman",							
							
						);
					$fields_string = '';
					//url-ify the data for the POST
					foreach($fields as $key=>$value) { $fields_string .= $key.$value.'&'; }
					rtrim($fields_string, '&');

					//open connection
					$ch = curl_init();

					//set the url, number of POST vars, POST data
					curl_setopt($ch,CURLOPT_URL, $url);
					curl_setopt($ch,CURLOPT_POST, count($fields));
					curl_setopt($ch,CURLOPT_POSTFIELDS, $fields_string);

					//execute post
					$result = curl_exec($ch);

					//close connection
					curl_close($ch);

					if($result == 1){
						redirect('User_admin/api?sent');
					}
		    
	}
	
	public function app_send_sms(){
		      $this->db->where('transaction_id',$this->security->xss_clean($this->input->post('transaction_id')));
		      $count1=$this->db->count_all_results('school_payments_transactions');
			  if($count1>0){
				 redirect('User_admin/api?exists'); 
			  }else{
		     $data= array(
			 "school_id"=>$this->security->xss_clean($this->input->post('school_id')),
			 "transaction_id"=>$this->security->xss_clean($this->input->post('transaction_id')),
			 "mobile"=>$this->security->xss_clean($this->input->post('mobile')),
			 "amount"=>str_replace(',','',$this->security->xss_clean($this->input->post('amount'))),
			 "name"=>$this->security->xss_clean($this->input->post('name')),
			 "year"=>date('Y'),
			 "payment_method"=>'Voda',
			 'date_paid'=>date("l jS \of F Y ")
			 );
			$this->db->insert('school_payments_transactions',$data);
			redirect('User_admin/api?sent');
			  }
	}
	
	public function confirm(){
		
			$transaction_id=trim($this->security->xss_clean($this->input->post('transaction_id')));
			//echo $transaction_id;exit();
		              $url = 'http://www.afel.co.tz/Confirm_payments';
					  $fields = array(
							'key=                     '=>"179103@afel_1990/2017",	
							'transaction_id=          '=>trim($this->security->xss_clean($this->input->post('transaction_id'))),
							'paid_for=                '=>"afelschool",
							'payer_id=                '=>$this->session->userdata('school_id'),
							'payer_name=              '=>$this->session->userdata('school_name'),
							
						);
					$fields_string = '';
					//url-ify the data for the POST
					foreach($fields as $key=>$value) { $fields_string .= $key.$value.'&'; }
					rtrim($fields_string, '&');

					//open connection
					$ch = curl_init();

					//set the url, number of POST vars, POST data
					curl_setopt($ch,CURLOPT_URL, $url);
					curl_setopt($ch,CURLOPT_POST, count($fields));
					curl_setopt($ch,CURLOPT_POSTFIELDS, $fields_string);

					//execute post
					$result = curl_exec($ch);

					//close connection
					curl_close($ch);

					if($result == 1){
						redirect('User_admin/make_payments?status=sent&&id='.base64_encode($transaction_id));
					}else{
						redirect('User_admin/make_payments?status=error&&id='.base64_encode($transaction_id));
					}
					
					
	}
	
	/*
	public function confirm_payments(){
			  date_default_timezone_set('Africa/Dar_es_Salaam');
		      $transaction_id=$this->security->xss_clean($this->input->post('transaction_id'));
			 // echo $transaction_id;exit();
		     //check if transactions_id is used
		      $this->db->where('transaction_id',$this->security->xss_clean($this->input->post('transaction_id')));
		      $this->db->not_like('school_id','not_confirmed');
		      $count1=$this->db->count_all_results('school_payments_transactions');
			  
			  //check if transactions_id exists
			  $this->db->where('transaction_id',$this->security->xss_clean($this->input->post('transaction_id')));
		      $this->db->where('school_id','not_confirmed');
		      $count2=$this->db->count_all_results('school_payments_transactions');
			  
			  if($count1>0){
				  redirect('User_admin/make_payments?used');
			  }elseif($count2==0){
				  redirect('User_admin/make_payments?not_available');
			  }else{
				 $data= array(
				 "school_id"=>$this->session->userdata('school_id'),
				 'date_confirmed'=>date("l jS \of F Y ")
				 );
				$this->db->where('transaction_id',$this->security->xss_clean($this->input->post('transaction_id')));
				$this->db->update('school_payments_transactions',$data);
				
				
				$amount=0;
				$phone = '';
				$message = array();
				$v='';
				$smstext= '';
				$school=strtoupper($this->session->userdata('school_name'));
				
				 $this->db->where('transaction_id',$this->security->xss_clean($this->input->post('transaction_id')));
                 $n=$this->db->get('school_payments_transactions')->result();
				 foreach($n as $reg){
					 $amount=$reg->amount;
					 $smstext='Confirmed, you paid ' .$amount.' to AFELSCHOOL account '.$school.' on '.date('d/m/Y');
					 $p=trim(str_replace(' ' ,"", $reg->mobile));
					 $s=str_replace('-' ,"", $p);
					 $t=substr($s, -9);
					 $v='255'.$t;
				    //  echo trim($v).' '.$rt->class_level.'<br/>';	 
					//echo $p.' '.$s.' '.$t.' '.$v.'<br/>';
					$message[] = array(
						'from'=>"Afel-Info",
						"to"=>$v,
						"text"=>$smstext,
					);
				 }
		
					//DATABASE TO FETCH THE PHONE NUMBERS
					//$this->db->where('username','famsh05@outlook.com');	
					//JSON ENCODING
					// $postData = array("messages" => $message);
					// $postDataJson = json_encode($postData);
					//echo $postDataJson;
					// $curl = curl_init();
					// curl_setopt_array($curl, array(
					// CURLOPT_URL => "http://api.infobip.com/sms/1/text/multi",
					// CURLOPT_RETURNTRANSFER => true,
					// CURLOPT_ENCODING => "",
					// CURLOPT_MAXREDIRS => 10,
					// CURLOPT_TIMEOUT => 80,
					// CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
					// CURLOPT_CUSTOMREQUEST => "POST",
					// CURLOPT_POSTFIELDS => $postDataJson,
					// CURLOPT_HTTPHEADER => array(
						// "accept: application/json",
						// "authorization: Basic QWZlbEFkbWluOkBUZWNoRG9kMTcm",
						// "content-type: application/json"
					  // ),
					// ));
					//SMS  RESPONSE
					// $response = curl_exec($curl);
					// $err = curl_error($curl);
					// $data = $response;
				//	PRINT RESPONSE
					// curl_close($curl);
					// if($data){
					//	print_r(json_decode($response));
					// }else{
					//	print_r($err);
					// } 
				 redirect('User_admin/make_payments?status=confirmed&&id='.base64_encode($transaction_id));	
			}
	}
	*/
	 public function error_settings() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/error_settings');
		$this->load->view('includes/user_admin_footer');
    }
	
	public function general_settings() {
        $school_reg_number = $this->session->userdata('school_reg_number');
		$school_id=$this->session->userdata('school_id');
        $id = $this->session->userdata('id');
		
        $this->load->view('includes/officers_header');
		$this->load->view('admin/general_settings');
		$this->load->view('includes/officers_footer');
         
    }

	
	 public function class_settings() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/class_settings');
		$this->load->view('includes/officers_footer');
     }
	  public function school_settings() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/school_settings');
		$this->load->view('includes/officers_footer');
     }
	 
	 public function students_settings() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/students_settings');
		$this->load->view('includes/officers_footer');
     }
	 
	 public function subjects_settings() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/officer_settings/subjects_settings');
		$this->load->view('includes/officers_footer');
     }
	  public function sub_subjects() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/officer_settings/sub_subjects');
		$this->load->view('includes/officers_footer');
     }
	  public function combinations_settings() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/combinations_settings');
		$this->load->view('includes/officers_footer');
     }
    public function results_settings() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/officer_settings/results_settings');
		$this->load->view('includes/officers_footer');
     }
	  public function set_grades() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/officer_settings/set_grades');
		$this->load->view('includes/officers_footer');
     }
	public function division_settings() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/officer_settings/division_settings');
		$this->load->view('includes/officers_footer');
     }
	 public function point_settings() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/officer_settings/point_settings');
		$this->load->view('includes/officers_footer');
     }
	  public function results_calculations() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/officer_settings/results_calculations');
		$this->load->view('includes/officers_footer');
     }
	 public function evaluation_settings() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/officer_settings/evaluation_settings');
		$this->load->view('includes/officers_footer');
     }
	 public function reports_settings() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/officer_settings/reports_settings');
		$this->load->view('includes/officers_footer');
     }
     
	 
    public function accounts_settings() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/officer_settings/accounts_settings');
		$this->load->view('includes/officers_footer');
     }
	  public function income_settings() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/officer_settings/income_settings');
		$this->load->view('includes/officers_footer');
     }
	 
	  public function expenses_settings() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/expenses_settings');
		$this->load->view('includes/officers_footer');
     }
	 public function payments_types_settings() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/payments_types_settings');
		$this->load->view('includes/officers_footer');
     }
	 public function bank_accounts() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/bank_accounts');
		$this->load->view('includes/officers_footer');
     }
	 
	 public function fee_amounts() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/fee_amounts');
		$this->load->view('includes/officers_footer');
     }
	 
	  public function fees_amounts_a() {
        $this->load->view('includes/officers_header');
		$this->load->view('admin/fee_amounts_a');
		$this->load->view('includes/officers_footer');
     }
    //function to logout and destroy sessions    
    public function logout() {
		      $url='';
		       $this->db->where('school_id',$this->session->userdata('school_id'));
			   $get=$this->db->get('schools');
			   foreach($get->result() as $row){
				  $url=$row->url;
		       }
        $data = ['reg_number', 'reg_number'];
        $this->session->unset_userdata($data);
		if($url==''){
			   //redirecting to normal page
		       redirect('Welcome/login');
		   }else{
				redirect('Welcome/login/'.$url);
		       }
    }

public function insert_registration(){
		if($_POST){
			$days=0;
			$gtd=$this->db->get('trial_setting');
			foreach($gtd->result() as $rt){
			$days=$rt->days;	
			}
			  $today = date("d-M-Y",time());
			  $trialPeriod = $days;
			  $startDate = date("d-M-Y", time());
			  $getExpiryDate = strtotime('+'.$trialPeriod."days", strtotime($startDate));
			  $expiryDate = date("d-M-Y", $getExpiryDate);
						
			$email=$this->security->xss_clean($this->input->post('school_email'));
			$this->db->where('school_reg_number',$this->security->xss_clean($this->input->post('school_reg_number')));
			$countt= $this->db->count_all_results('schools');
				if($countt>0){
				 	redirect('Secondary_officers/register_schools?Error');
				}else{
					$chool_type=$this->security->xss_clean($this->input->post('school_type'));
					$istrue = true;
					while($istrue){
						$school_id= $chool_type.uniqid();
						$this->db->where('school_id',$school_id);
						$count= $this->db->count_all_results('schools');
						if($count == 0){
						 $istrue = false;
						}
					} 
					
					  $region='';
					if($this->session->userdata('group_id')==0){
						$region=$this->session->userdata('region');
					}else{
						$this->db->where('id',$this->security->xss_clean($this->input->post('district')));
						$get= $this->db->get('regions_distrincts');
						foreach($get->result() as $r){
							$region=$r->regions_id;
						}
						
					}
					 $data = array(
							'school_id' => $school_id,
							'school_name' => $this->security->xss_clean($this->input->post('school_name')),
							'school_type' => $this->security->xss_clean($this->input->post('school_type')),
							'school_email' => $this->security->xss_clean($this->input->post('school_email')),
							'school_mobile' => $this->security->xss_clean($this->input->post('school_mobile')),
							'school_address' => $this->security->xss_clean($this->input->post('school_address')),
							'school_location' => $this->security->xss_clean($this->input->post('school_location')),
							'country' => $this->security->xss_clean($this->input->post('country')),
							'school_website' =>$this->security->xss_clean($this->input->post('school_website')),
							'school_reg_number'=>$this->security->xss_clean($this->input->post('school_reg_number')),
							'full_name'=>$this->security->xss_clean($this->input->post('full_name')),
							'school_ownership'=>$this->security->xss_clean($this->input->post('school_ownership')),
							'url'=>$this->security->xss_clean($this->input->post('url')),
							'login_header'=>$this->security->xss_clean($this->input->post('login_header')),
							'region'=>$region,
							'district'=>$this->security->xss_clean($this->input->post('district')),
							'school_logo'=>'Not set',
							'school_moto'=>'Not set',
							'school_header'=>'Not set',
							'password'=>MD5('default'),
							'password_recover'=>'default',
							'type'=>'Admin',
							'year_registered'=>date('Y')
						);
						
						 $data1 = array(
							'school_id' => $school_id,
							'year' => date('Y'),
							'students' => 0,
							'amount' => 0,
							'month_started' =>date('m')
						);
						
						 $data3 = array(
							'school_id' => $school_id,
							'year' => date('Y'),
							'start_date' => $startDate,
							'expiry_date' =>$expiryDate,
							'month_started' =>date('m'),
							'days'=>$days
						);
						
				$data2= array(
				 //"source"=>'afelschool',
				 "mobile"=>$this->security->xss_clean($this->input->post('school_mobile')),
				 "reg_number"=>$school_id,
				 "school_id"=>$school_id,
				 "email"=>$this->security->xss_clean($this->input->post('school_email')),
				 "registered_year"=>date('Y'),
				 //"customer_name"=>trim($this->security->xss_clean($this->input->post('school_name'))),
				 "amount"=>0,
				 "last_update"=> date('D d, M/Y ')." ".date('H:i:s')
				);
						
						$this->db->insert('schools', $data);
						$this->db->insert('school_pyaments_required', $data1);
						$this->db->insert('trial', $data3);
				        $this->db->insert('billing_update',$data2);
					

				}
				
				$data3 = array(
					'group_id'=>$this->session->userdata('group_id'),
					'school_id'=>$school_id,
					'date_registered'=>date('M d Y'),
				);
				
				if($this->session->userdata('group_id')>0){
					
				$this->db->insert('group_schools',$data3);
				
				}
		}
		redirect('Secondary_officers/register_schools?suc');
	}
	
	
	public function insert_registration_primary(){
		if($_POST){
			$days=0;
			$gtd=$this->db->get('trial_setting');
			foreach($gtd->result() as $rt){
			$days=$rt->days;	
			}
			  $today = date("d-M-Y",time());
			  $trialPeriod = $days;
			  $startDate = date("d-M-Y", time());
			  $getExpiryDate = strtotime('+'.$trialPeriod."days", strtotime($startDate));
			  $expiryDate = date("d-M-Y", $getExpiryDate);
						
			$email=$this->security->xss_clean($this->input->post('school_email'));
			$this->db->where('school_reg_number',$this->security->xss_clean($this->input->post('school_reg_number')));
			$countt= $this->db->count_all_results('schools');
				if($countt>0){
				 	redirect('Primary_officers/register_schools?Error');
				}else{
					$chool_type=$this->security->xss_clean($this->input->post('school_type'));
					$istrue = true;
					while($istrue){
						$school_id= $chool_type.uniqid();
						$this->db->where('school_id',$school_id);
						$count= $this->db->count_all_results('schools');
						if($count == 0){
						 $istrue = false;
						}
					} 
					
					  $region='';
					if($this->session->userdata('group_id')==0){
						$region=$this->session->userdata('region');
					}else{
						$this->db->where('id',$this->security->xss_clean($this->input->post('district')));
						$get= $this->db->get('regions_distrincts');
						foreach($get->result() as $r){
							$region=$r->regions_id;
						}
						
					}
					 $data = array(
							'school_id' => $school_id,
							'school_name' => $this->security->xss_clean($this->input->post('school_name')),
							'school_type' => $this->security->xss_clean($this->input->post('school_type')),
							'school_email' => $this->security->xss_clean($this->input->post('school_email')),
							'school_mobile' => $this->security->xss_clean($this->input->post('school_mobile')),
							'school_address' => $this->security->xss_clean($this->input->post('school_address')),
							'school_location' => $this->security->xss_clean($this->input->post('school_location')),
							'country' => $this->security->xss_clean($this->input->post('country')),
							'school_website' =>$this->security->xss_clean($this->input->post('school_website')),
							'school_reg_number'=>$this->security->xss_clean($this->input->post('school_reg_number')),
							'full_name'=>$this->security->xss_clean($this->input->post('full_name')),
							'school_ownership'=>$this->security->xss_clean($this->input->post('school_ownership')),
							'url'=>$this->security->xss_clean($this->input->post('url')),
							'login_header'=>$this->security->xss_clean($this->input->post('login_header')),
							'region'=>$region,
							'district'=>$this->security->xss_clean($this->input->post('district')),
							'school_logo'=>'Not set',
							'school_moto'=>'Not set',
							'school_header'=>'Not set',
							'password'=>MD5('default'),
							'password_recover'=>'default',
							'type'=>'Admin',
							'year_registered'=>date('Y')
						);
						
						 $data1 = array(
							'school_id' => $school_id,
							'year' => date('Y'),
							'students' => 0,
							'amount' => 0,
							'month_started' =>date('m')
						);
						
						 $data3 = array(
							'school_id' => $school_id,
							'year' => date('Y'),
							'start_date' => $startDate,
							'expiry_date' =>$expiryDate,
							'month_started' =>date('m'),
							'days'=>$days
						);
						
				$data2= array(
				 //"source"=>'afelschool',
				 "mobile"=>$this->security->xss_clean($this->input->post('school_mobile')),
				 "reg_number"=>$school_id,
				 "school_id"=>$school_id,
				 "email"=>$this->security->xss_clean($this->input->post('school_email')),
				 "registered_year"=>date('Y'),
				 //"customer_name"=>trim($this->security->xss_clean($this->input->post('school_name'))),
				 "amount"=>0,
				 "last_update"=> date('D d, M/Y ')." ".date('H:i:s')
				);
						
						$this->db->insert('schools', $data);
						$this->db->insert('school_pyaments_required', $data1);
						$this->db->insert('trial', $data3);
				        $this->db->insert('billing_update',$data2);
					

				}
				
				$data3 = array(
					'group_id'=>$this->session->userdata('group_id'),
					'school_id'=>$school_id,
					'date_registered'=>date('M d Y'),
				);
				
				if($this->session->userdata('group_id')>0){
					
				$this->db->insert('group_schools',$data3);
				
				}
		}
		redirect('Primary_officers/register_schools?suc');
	}
	
}