<?php

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

/*
 *  @author   : Aernout Guillaume
 *  date    : 25 juillet 2019
 *  Codes.Solutions
 *  https://codes.solutions
 */

 class Student_request extends NS_Controller {
   function __construct() {
     parent::__construct();
    $this->load->helper('generator');
     $this->load->model('crud_model');
     $this->load->model('profile_model');
     $this->load->model('security_model');
     $this->load->database();
     $this->load->library('session');

     /* cache control */
     $this->output->set_header('Last-Modified: ' . gmdate("D, d M Y H:i:s") . ' GMT');
     $this->output->set_header('Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0');
     $this->output->set_header('Pragma: no-cache');
     $this->output->set_header("Expires: Mon, 26 Jul 2010 05:00:00 GMT");
   }

   public function index() {
     //$this->load->helper('url');
     $param = $this->uri->segment(2);
     //echo $param;
     //set language to session
     $data['cur_lang'] = $this->session->userdata('current_language');
     $data['lang'] = $this->profile_model->language();
     $data['languages'] = $this->crud_model->get_languages();
     $this->load->view('frontend/student_request',$data);
   }

   public function submit(){
     $data = $this->input->post(array('address1','address2','pc','country','location','name','firstname','email','gender','phone','current_language','native_language','dob','language_to_learn','oral_production','writing_production','writing_comprehension','oral_comprehension','availibility_morning','availibility_evening','availibility_afternoon','offer','comment','contact_name','contact_firstname','contact_email','contact_phone'));
     $data = $this->security_model->clean_input($data);
     var_dump($data);

     $sql = array(
        id => '',
        learn_lng_id => $data['language_to_learn'],
        spoken => $data['oral_production'],
        written => $data['writing_production'],
        understand => $data['oral_comprehension'],
        reading => $data['writing_comprehension'],
        morning => $data['availibility_morning'],
        afternoon => $data['availibility_afternoon'],
        evening => $data['availibility_evening'],
        offer => $data['offer'],
        remark => $data['comment'],
        studentGender => $data['gender'],
        name => $data['name'],
        surname => $data['firstname'],
        email => $data['email'],
        phone => $data['phone'],
        birthdate => $data['dob'],
        spoken_lng => $data['current_language'],
        native_lng => $data['native_language'],
        school_class => '',
        parent_name => $data['contact_name'],
        parent_surname => $data['contact_firstname'],
        parent_email => $data['contact_email'],
        parent_phone => $data['contact_phone'],
        addressline1 =>$data['address1'],
        addressline2 =>$data['address2'],
        cp => $data['pc'],
        location =>$data['location'],
        country =>$data['country'],
        status => '0',
        student_id => '0'
      );
      // var_dump($sql);
      $this->db->insert('candidate_student',$sql);
      echo $this->db->insert_id();
   }

}