<?php
/*********************
 *********************

 User Registration Model
 Creation 02 may 2019
 Aernout Guillaume
 http://Codes.Solutions
 (Most features could be betters,
 Google map api should be use)
 *********************
 *********************/
if (!defined('BASEPATH'))
    exit('No direct script access allowed');

class Users_model extends CI_Model {

  function __construct() {
      parent::__construct(array('no_cache'=>1));
      //$this->_ci =& get_instance();
      //$this->load->model('crud_model');
      $this->load->database();
  }
  ////////////////////////////////
  ////////////////////////////////
  //     Verification funcitons
  ////////////////////////////////
  ////////////////////////////////
  function check_email_format($email){
     return filter_var($email, FILTER_VALIDATE_EMAIL) !== false;
    //return (!preg_match("/^([a-z0-9\+_\-]+)(\.[a-z0-9\+_\-]+)*@([a-z0-9\-]+\.)+[a-z]{2,6}$/ix", $mail)) ? FALSE : TRUE;
  }

  function email_exist($mail){
    $this->db->select('*');
    $this->db->from('user');
    $this->db->where('email',$mail);
    $queryresult = $this->db->get()->result_array();
    $queryresult = array_filter($queryresult);
    //return $queryresult;
    if(!empty($queryresult)){
      return true;
    }
    else{
      return false;//email doesnt exist
    }
  }
  function check_pass($password){
    // Validate password strength
    $uppercase = preg_match('@[A-Z]@', $password);
    $lowercase = preg_match('@[a-z]@', $password);
    $number    = preg_match('@[0-9]@', $password);
    $specialChars = preg_match('@[^\w]@', $password);

    if(($uppercase || $number || $specialChars) && strlen($password) > 5) {
      return true;// 'Password should be at least 8 characters in length and should include at least one upper case letter, one number, and one special character.';
    }else{
      return false; //'Strong password.';
    }
  }
  function check_name($name){
    $notInNames = "![0-9!@#$%^&*()_+={}|\\\\;\"\n\r\t\[\]<>?/]!";
    if (!preg_match($notInNames,$name)|| strlen($name) < 3) {//preg_match("/^[a-zA-Z ]*$/",$name)
        return true;
    }
    return false;
  }
  function check_phone($number){
    //should use regex by country (symphony lib)
    $numbersOnly = preg_replace("[^0-9]", "", $number);
    $numberOfDigits = strlen($numbersOnly);
    if ($numberOfDigits > 7 && $numberOfDigits < 14) {
        return true;
    } else {
        return false;
    }
  }
  function check_dob($dob){
    /*
    if(!checkdate($dob)){
      return "false chk";
    }
    */
    $minAge = (date('Y') - 3).'/'.date('m/d');
    if(strtotime($strDateOfBirth) > strtotime($strSystemMaxDate))
    {
        return false;
    }
    return true;
  }
  function check_address($line1,$line2,$country,$state,$postcode){
    //should use google Api
    $countryCode = array(
    array('4', 'AFG', 'AF', 'Afghanistan'),
    array('710', 'ZAF', 'ZA', 'Afrique du Sud'),
    array('248', 'ALA', 'AX', 'Aland'),
    array('8', 'ALB', 'AL', 'Albanie'),
    array('12', 'DZA', 'DZ', 'Algérie'),
    array('276', 'DEU', 'DE', 'Allemagne'),
    array('20', 'AND', 'AD', 'Andorre'),
    array('24', 'AGO', 'AO', 'Angola'),
    array('660', 'AIA', 'AI', 'Anguilla'),
    array('10', 'ATA', 'AQ', 'Antarctique'),
    array('28', 'ATG', 'AG', 'Antigua-et-Barbuda'),
    array('682', 'SAU', 'SA', 'Arabie saoudite'),
    array('32', 'ARG', 'AR', 'Argentine'),
    array('51', 'ARM', 'AM', 'Arménie'),
    array('533', 'ABW', 'AW', 'Aruba'),
    array('36', 'AUS', 'AU', 'Australie'),
    array('40', 'AUT', 'AT', 'Autriche'),
    array('31', 'AZE', 'AZ', 'Azerbaïdjan'),
    array('44', 'BHS', 'BS', 'Bahamas'),
    array('48', 'BHR', 'BH', 'Bahreïn'),
    array('50', 'BGD', 'BD', 'Bangladesh'),
    array('52', 'BRB', 'BB', 'Barbade'),
    array('112', 'BLR', 'BY', 'Biélorussie'),
    array('56', 'BEL', 'BE', 'Belgique'),
    array('84', 'BLZ', 'BZ', 'Belize'),
    array('204', 'BEN', 'BJ', 'Bénin'),
    array('60', 'BMU', 'BM', 'Bermudes'),
    array('64', 'BTN', 'BT', 'Bhoutan'),
    array('68', 'BOL', 'BO', 'Bolivie'),
    array('535', 'BES', 'BQ', 'Bonaire', ' Saint-Eustache et Saba'),
    array('70', 'BIH', 'BA', 'Bosnie-Herzégovine'),
    array('72', 'BWA', 'BW', 'Botswana'),
    array('74', 'BVT', 'BV', 'Île Bouvet'),
    array('76', 'BRA', 'BR', 'Brésil'),
    array('96', 'BRN', 'BN', 'Brunei'),
    array('100', 'BGR', 'BG', 'Bulgarie'),
    array('854', 'BFA', 'BF', 'Burkina Faso'),
    array('108', 'BDI', 'BI', 'Burundi'),
    array('136', 'CYM', 'KY', 'Îles Caïmans'),
    array('116', 'KHM', 'KH', 'Cambodge'),
    array('120', 'CMR', 'CM', 'Cameroun'),
    array('124', 'CAN', 'CA', 'Canada'),
    array('132', 'CPV', 'CV', 'Cap-Vert'),
    array('140', 'CAF', 'CF', 'République centrafricaine'),
    array('152', 'CHL', 'CL', 'Chili'),
    array('156', 'CHN', 'CN', 'Chine'),
    array('162', 'CXR', 'CX', 'Île Christmas'),
    array('196', 'CYP', 'CY', 'Chypre'),
    array('166', 'CCK', 'CC', 'Îles Cocos'),
    array('170', 'COL', 'CO', 'Colombie'),
    array('174', 'COM', 'KM', 'Comores'),
    array('178', 'COG', 'CG', 'République du Congo'),
    array('180', 'COD', 'CD', 'République démocratique du Congo'),
    array('184', 'COK', 'CK', 'Îles Cook'),
    array('410', 'KOR', 'KR', 'Corée du Sud'),
    array('408', 'PRK', 'KP', 'Corée du Nord'),
    array('188', 'CRI', 'CR', 'Costa Rica'),
    array('384', 'CIV', 'CI', 'Côte d\'Ivoire'),
    array('191', 'HRV', 'HR', 'Croatie'),
    array('192', 'CUB', 'CU', 'Cuba'),
    array('531', 'CUW', 'CW', 'Curaçao'),
    array('208', 'DNK', 'DK', 'Danemark'),
    array('262', 'DJI', 'DJ', 'Djibouti'),
    array('214', 'DOM', 'DO', 'République dominicaine'),
    array('212', 'DMA', 'DM', 'Dominique'),
    array('818', 'EGY', 'EG', 'Égypte'),
    array('222', 'SLV', 'SV', 'Salvador'),
    array('784', 'ARE', 'AE', 'Émirats arabes unis'),
    array('218', 'ECU', 'EC', 'Équateur'),
    array('232', 'ERI', 'ER', 'Érythrée'),
    array('724', 'ESP', 'ES', 'Espagne'),
    array('233', 'EST', 'EE', 'Estonie'),
    array('840', 'USA', 'US', 'États-Unis'),
    array('231', 'ETH', 'ET', 'Éthiopie'),
    array('238', 'FLK', 'FK', 'Îles Malouines'),
    array('234', 'FRO', 'FO', 'Îles Féroé'),
    array('242', 'FJI', 'FJ', 'Fidji'),
    array('246', 'FIN', 'FI', 'Finlande'),
    array('250', 'FRA', 'FR', 'France'),
    array('266', 'GAB', 'GA', 'Gabon'),
    array('270', 'GMB', 'GM', 'Gambie'),
    array('268', 'GEO', 'GE', 'Géorgie'),
    array('239', 'SGS', 'GS', 'Géorgie du Sud-et-les Îles Sandwich du Sud'),
    array('288', 'GHA', 'GH', 'Ghana'),
    array('292', 'GIB', 'GI', 'Gibraltar'),
    array('300', 'GRC', 'GR', 'Grèce'),
    array('308', 'GRD', 'GD', 'Grenade'),
    array('304', 'GRL', 'GL', 'Groenland'),
    array('312', 'GLP', 'GP', 'Guadeloupe'),
    array('316', 'GUM', 'GU', 'Guam'),
    array('320', 'GTM', 'GT', 'Guatemala'),
    array('831', 'GGY', 'GG', 'Guernesey'),
    array('324', 'GIN', 'GN', 'Guinée'),
    array('624', 'GNB', 'GW', 'Guinée-Bissau'),
    array('226', 'GNQ', 'GQ', 'Guinée équatoriale'),
    array('328', 'GUY', 'GY', 'Guyana'),
    array('254', 'GUF', 'GF', 'Guyane'),
    array('332', 'HTI', 'HT', 'Haïti'),
    array('334', 'HMD', 'HM', 'Îles Heard-et-MacDonald'),
    array('340', 'HND', 'HN', 'Honduras'),
    array('344', 'HKG', 'HK', 'Hong Kong'),
    array('348', 'HUN', 'HU', 'Hongrie'),
    array('833', 'IMN', 'IM', 'Île de Man'),
    array('581', 'UMI', 'UM', 'Îles mineures éloignées des États-Unis'),
    array('92', 'VGB', 'VG', 'Îles Vierges britanniques'),
    array('850', 'VIR', 'VI', 'Îles Vierges des États-Unis'),
    array('356', 'IND', 'IN', 'Inde'),
    array('360', 'IDN', 'ID', 'Indonésie'),
    array('364', 'IRN', 'IR', 'Iran'),
    array('368', 'IRQ', 'IQ', 'Irak'),
    array('372', 'IRL', 'IE', 'Irlande'),
    array('352', 'ISL', 'IS', 'Islande'),
    array('376', 'ISR', 'IL', 'Israël'),
    array('380', 'ITA', 'IT', 'Italie'),
    array('388', 'JAM', 'JM', 'Jamaïque'),
    array('392', 'JPN', 'JP', 'Japon'),
    array('832', 'JEY', 'JE', 'Jersey'),
    array('400', 'JOR', 'JO', 'Jordanie'),
    array('398', 'KAZ', 'KZ', 'Kazakhstan'),
    array('404', 'KEN', 'KE', 'Kenya'),
    array('417', 'KGZ', 'KG', 'Kirghizistan'),
    array('296', 'KIR', 'KI', 'Kiribati'),
    array('414', 'KWT', 'KW', 'Koweït'),
    array('418', 'LAO', 'LA', 'Laos'),
    array('426', 'LSO', 'LS', 'Lesotho'),
    array('428', 'LVA', 'LV', 'Lettonie'),
    array('422', 'LBN', 'LB', 'Liban'),
    array('430', 'LBR', 'LR', 'Liberia'),
    array('434', 'LBY', 'LY', 'Libye'),
    array('438', 'LIE', 'LI', 'Liechtenstein'),
    array('440', 'LTU', 'LT', 'Lituanie'),
    array('442', 'LUX', 'LU', 'Luxembourg'),
    array('446', 'MAC', 'MO', 'Macao'),
    array('807', 'MKD', 'MK', 'Macédoine'),
    array('450', 'MDG', 'MG', 'Madagascar'),
    array('458', 'MYS', 'MY', 'Malaisie'),
    array('454', 'MWI', 'MW', 'Malawi'),
    array('462', 'MDV', 'MV', 'Maldives'),
    array('466', 'MLI', 'ML', 'Mali'),
    array('470', 'MLT', 'MT', 'Malte'),
    array('580', 'MNP', 'MP', 'Îles Mariannes du Nord'),
    array('504', 'MAR', 'MA', 'Maroc'),
    array('584', 'MHL', 'MH', 'Marshall'),
    array('474', 'MTQ', 'MQ', 'Martinique'),
    array('480', 'MUS', 'MU', 'Maurice'),
    array('478', 'MRT', 'MR', 'Mauritanie'),
    array('175', 'MYT', 'YT', 'Mayotte'),
    array('484', 'MEX', 'MX', 'Mexique'),
    array('583', 'FSM', 'FM', 'Micronésie'),
    array('498', 'MDA', 'MD', 'Moldavie'),
    array('492', 'MCO', 'MC', 'Monaco'),
    array('496', 'MNG', 'MN', 'Mongolie'),
    array('499', 'MNE', 'ME', 'Monténégro'),
    array('500', 'MSR', 'MS', 'Montserrat'),
    array('508', 'MOZ', 'MZ', 'Mozambique'),
    array('104', 'MMR', 'MM', 'Birmanie'),
    array('516', 'NAM', 'NA', 'Namibie'),
    array('520', 'NRU', 'NR', 'Nauru'),
    array('524', 'NPL', 'NP', 'Népal'),
    array('558', 'NIC', 'NI', 'Nicaragua'),
    array('562', 'NER', 'NE', 'Niger'),
    array('566', 'NGA', 'NG', 'Nigeria'),
    array('570', 'NIU', 'NU', 'Niue'),
    array('574', 'NFK', 'NF', 'Île Norfolk'),
    array('578', 'NOR', 'NO', 'Norvège'),
    array('540', 'NCL', 'NC', 'Nouvelle-Calédonie'),
    array('554', 'NZL', 'NZ', 'Nouvelle-Zélande'),
    array('86', 'IOT', 'IO', 'Territoire britannique de l\'océan Indien'),
    array('512', 'OMN', 'OM', 'Oman'),
    array('800', 'UGA', 'UG', 'Ouganda'),
    array('860', 'UZB', 'UZ', 'Ouzbékistan'),
    array('586', 'PAK', 'PK', 'Pakistan'),
    array('585', 'PLW', 'PW', 'Palaos'),
    array('275', 'PSE', 'PS', 'Autorité Palestinienne'),
    array('591', 'PAN', 'PA', 'Panama'),
    array('598', 'PNG', 'PG', 'Papouasie-Nouvelle-Guinée'),
    array('600', 'PRY', 'PY', 'Paraguay'),
    array('528', 'NLD', 'NL', 'Pays-Bas'),
    array('604', 'PER', 'PE', 'Pérou'),
    array('608', 'PHL', 'PH', 'Philippines'),
    array('612', 'PCN', 'PN', 'Îles Pitcairn'),
    array('616', 'POL', 'PL', 'Pologne'),
    array('258', 'PYF', 'PF', 'Polynésie française'),
    array('630', 'PRI', 'PR', 'Porto Rico'),
    array('620', 'PRT', 'PT', 'Portugal'),
    array('634', 'QAT', 'QA', 'Qatar'),
    array('638', 'REU', 'RE', 'La Réunion'),
    array('642', 'ROU', 'RO', 'Roumanie'),
    array('826', 'GBR', 'GB', 'Royaume-Uni'),
    array('643', 'RUS', 'RU', 'Russie'),
    array('646', 'RWA', 'RW', 'Rwanda'),
    array('732', 'ESH', 'EH', 'Sahara occidental'),
    array('652', 'BLM', 'BL', 'Saint-Barthélemy'),
    array('659', 'KNA', 'KN', 'Saint-Christophe-et-Niévès'),
    array('674', 'SMR', 'SM', 'Saint-Marin'),
    array('663', 'MAF', 'MF', 'Saint-Martin (Antilles françaises)'),
    array('534', 'SXM', 'SX', 'Saint-Martin'),
    array('666', 'SPM', 'PM', 'Saint-Pierre-et-Miquelon'),
    array('336', 'VAT', 'VA', 'Saint-Siège (État de la Cité du Vatican)'),
    array('670', 'VCT', 'VC', 'Saint-Vincent-et-les-Grenadines'),
    array('654', 'SHN', 'SH', 'Sainte-Hélène', ' Ascension et Tristan da Cunha'),
    array('662', 'LCA', 'LC', 'Sainte-Lucie'),
    array('90', 'SLB', 'SB', 'Salomon'),
    array('882', 'WSM', 'WS', 'Samoa'),
    array('16', 'ASM', 'AS', 'Samoa américaines'),
    array('678', 'STP', 'ST', 'Sao Tomé-et-Principe'),
    array('686', 'SEN', 'SN', 'Sénégal'),
    array('688', 'SRB', 'RS', 'Serbie'),
    array('690', 'SYC', 'SC', 'Seychelles'),
    array('694', 'SLE', 'SL', 'Sierra Leone'),
    array('702', 'SGP', 'SG', 'Singapour'),
    array('703', 'SVK', 'SK', 'Slovaquie'),
    array('705', 'SVN', 'SI', 'Slovénie'),
    array('706', 'SOM', 'SO', 'Somalie'),
    array('729', 'SDN', 'SD', 'Soudan'),
    array('728', 'SSD', 'SS', 'Soudan du Sud'),
    array('144', 'LKA', 'LK', 'Sri Lanka'),
    array('752', 'SWE', 'SE', 'Suède'),
    array('756', 'CHE', 'CH', 'Suisse'),
    array('740', 'SUR', 'SR', 'Suriname'),
    array('744', 'SJM', 'SJ', 'Svalbard et Île Jan Mayen'),
    array('748', 'SWZ', 'SZ', 'Swaziland'),
    array('760', 'SYR', 'SY', 'Syrie'),
    array('762', 'TJK', 'TJ', 'Tadjikistan'),
    array('158', 'TWN', 'TW', 'Taïwan / (République de Chine (Taïwan))'),
    array('834', 'TZA', 'TZ', 'Tanzanie'),
    array('148', 'TCD', 'TD', 'Tchad'),
    array('203', 'CZE', 'CZ', 'République tchèque'),
    array('260', 'ATF', 'TF', 'Terres australes et antarctiques françaises'),
    array('764', 'THA', 'TH', 'Thaïlande'),
    array('626', 'TLS', 'TL', 'Timor oriental'),
    array('768', 'TGO', 'TG', 'Togo'),
    array('772', 'TKL', 'TK', 'Tokelau'),
    array('776', 'TON', 'TO', 'Tonga'),
    array('780', 'TTO', 'TT', 'Trinité-et-Tobago'),
    array('788', 'TUN', 'TN', 'Tunisie'),
    array('795', 'TKM', 'TM', 'Turkménistan'),
    array('796', 'TCA', 'TC', 'Îles Turques-et-Caïques'),
    array('792', 'TUR', 'TR', 'Turquie'),
    array('798', 'TUV', 'TV', 'Tuvalu'),
    array('804', 'UKR', 'UA', 'Ukraine'),
    array('858', 'URY', 'UY', 'Uruguay'),
    array('548', 'VUT', 'VU', 'Vanuatu'),
    array('862', 'VEN', 'VE', 'Venezuela'),
    array('704', 'VNM', 'VN', 'Viêt Nam'),
    array('876', 'WLF', 'WF', 'Wallis-et-Futuna'),
    array('887', 'YEM', 'YE', 'Yémen'),
    array('894', 'ZMB', 'ZM', 'Zambie'),
    array('716', 'ZWE', 'ZW', 'Zimbabwe')
    );


    if(strlen($line1) < 3){return false;}
    //if(!in_array($country,$countryCode)){return false;}
    if(strlen($postcode) < 4 || strlen($postcode) > 6){return false;}
    return $line1;
  }
  ////////////////////////////////
  ////////////////////////////////
  //     Creation funcitons
  ////////////////////////////////
  ////////////////////////////////
  function create_user($mail,$pass,$name1,$name2,$phone,$perm,$lang){
    $pass = password_hash($pass,PASSWORD_DEFAULT);

    $userSql = array(
      'role_id' => "$perm",
      'email' => "$mail",
      'password' => "$pass",
      'first_name' => "$name1",
      'phone' => "$phone",
      'last_name' => "$name2",
      'is_active' => '1',
      'is_final' => '1',
      'lang' => "$lang"
    );

    $this->db->insert('user', $userSql);
    $id = $this->db->insert_id();
    return $id;
  }
  function create_user_address($l1,$l2,$country,$state,$location,$code){
    $addressSql = array(
      'line_1' => "$l1",
      'line_2' => "$l2",
      'location_id' => '4',
      'postcode' => "$code",
      'location' => "$location",
      'country' => "$country"
    );//location_id = 4 pour bxl
    //return $addressSql;
    $this->db->insert('address', $addressSql);
    $id = $this->db->insert_id();
    return $id;
  }
  function create_student($id,$addressId,$comment,$dob,$parent){
    $sql = array(
      'student_id' => "$id",
      'residential_address_id' => "$addressId",
      'admin_comment' => "$comment",
      'dob' => "$dob",
      'parent_id' => "$parent"
    );
    $this->db->insert('student', $sql);
    //$id = $this->db->insert_id();
    return true;
  }
  function create_group($id,$addressId,$comment,$age,$number){
    $sql = array(
      'ID' => '',
      'group_id' => "$id",
      'invoice_address_id' => "$addressId",
      'number' => "$number",
      'dob' => "$age",
      'admin_comment' => "$comment",
      'creation' => ""
    );
    //return $sql;
    //$sql = $this->db->get_compiled_insert('group', $sql);
    //return $sql;
    $this->db->insert('group', $sql);
    //$id = $this->db->insert_id();
    return true;
  }
  function create_parent($id,$addressId,$comment,$dob){
    $sql = array(
      'parent_id' => "$id",
      'residential_address_id' => "$addressId",
      'admin_comment' => "$comment",
      'dob' => "$dob"
    );
    $this->db->insert('parent', $sql);
    //$id = $this->db->insert_id();
    return true;
  }
  function create_teacher($id,$addressId,$comment,$dob,$rate){
    $sql = array(
      'teacher_id' => "$id",
      'address_id' => "$addressId",
      'admin_comment' => "$comment",
      'rate' => "$rate",
      'dob' => "$dob"
    );
    $this->db->insert('teacher', $sql);
    //$id = $this->db->insert_id();
    return true;
  }
  function create_teacher_lang($id,$lan){
      $sql = array(
        'teacher_id' => "$id",
        'course_language_id' => "$lan"
          );
      $this->db->insert('teacher_course_language', $sql);
      return true;
  }
  ////////////////////////////////
  ////////////////////////////////
  //     Update funcitons
  ////////////////////////////////
  ////////////////////////////////
  function update_user($id,$mail,$pass,$name1,$name2,$phone,$lang){
  $userSql;
    //if email changed check email_exist
    if(($this->crud_model->get_user_email($id) != $mail) && ($this->email_exist($mail))){
      return false;
    }
    //try to keep the password
    if($pass != ""){
      //return $pass;
        if($name1 != "" && $name2 != ""){
         $pass = password_hash($pass,PASSWORD_DEFAULT);
         $userSql = array(
          'email' => "$mail",
          'password' => "$pass",
          'first_name' => "$name1",
          'phone' => "$phone",
          'last_name' => "$name2",
          'lang' => "$lang"
        );
      }else{
        $pass = password_hash($pass,PASSWORD_DEFAULT);
        $userSql = array(
         'email' => "$mail",
         'password' => "$pass",
         'phone' => "$phone",
         'lang' => "$lang"
       );
      }
    }
    else{
      if($name1 != "" && $name2 != ""){
        $userSql = array(
         'email' => "$mail",
         'first_name' => "$name1",
         'phone' => "$phone",
         'last_name' => "$name2",
          'lang' => "$lang"
         );
      }
      else{
        $userSql = array(
         'email' => "$mail",
         'phone' => "$phone",
         'lang' => "$lang",
         );
      }

    }
    //return $userSql;
    $this->db->set($userSql);
    $this->db->where('user_id',$id);
    $this->db->update('user');

    return true;
  }
  function update_user_address($id,$l1,$l2,$country,$state,$location,$code){
    $addressSql = array(
      'line_1' => "$l1",
      'line_2' => "$l2",
      'location_id' => '4',
      'postcode' => "$code",
      'location' => "$location",
      'country' => "$country"
    );//location_id = 4 pour bxl
    $this->db->set($addressSql);
    $this->db->where('address_id',$id);
    $this->db->update('address');
    return true;
  }
  function update_student($id,$comment,$dob,$parent){
    $sql = array(
      'admin_comment' => "$comment",
      'dob' => "$dob",
      'parent_id' => "$parent"
    );
    $this->db->set($sql);
    $this->db->where('student_id',$id);
    $this->db->update('student');
    return true;
  }
  function update_group($id,$comment,$dob,$size){
    $sql = array(
      'admin_comment' => "$comment",
      'dob' => "$dob",
      'number' => "$size"
    );
    $this->db->set($sql);
    $this->db->where('group_id',$id);
    $this->db->update('group');
    return true;
  }
  function update_parent($id,$comment,$dob){
    $sql = array(
      'admin_comment' => "$comment",
      'dob' => "$dob"
    );
    $this->db->set($sql);
    $this->db->where('parent_id',$id);
    $this->db->update('parent');
    return true;
  }

  function update_teacher($id,$comment,$dob,$rate){
      $sql = array(
        'admin_comment' => "$comment",
        'rate' => "$rate",
        'dob' => "$dob"
      );

    $this->db->set($sql);
    $this->db->where('teacher_id',$id);
    $this->db->update('teacher');
    return true;
  }
  function clean_teacher_lang($id){
    $this->db->where('teacher_id', $id);
    $this->db->delete('teacher_course_language');
    return true;
  }
  function update_teacher_lang($id,$lan){
      $sql = array(
        'teacher_id' => "$id",
        'course_language_id' => "$lan"
          );
      $this->db->insert('teacher_course_language', $sql);
      return true;
  }
  ////////////////////////////////
  ////////////////////////////////
  //     Info funcitons
  ////////////////////////////////
  ////////////////////////////////
  function get_profile_address(){
    $userId = $this->session->userdata('userID');
    $userRole = $this->session->userdata('login_type');

    switch ($userRole) {
      case 'admin':
         return "0";
        break;
    case 'student':
        $query = $this->db->get_where('student', array('student_id' => $userId));
        $res = $query->result_array();
        foreach ($res as $row)
           return $row['residential_address_id'];
       break;
    case 'teacher':
        $query = $this->db->get_where('teacher', array('teacher_id' => $userId));
        $res = $query->result_array();
        foreach ($res as $row)
            return $row['residential_address_id'];
        break;
    case 'parent':
          $query = $this->db->get_where('parent', array('parent_id' => $userId));
          $res = $query->result_array();
          foreach ($res as $row)
             return $row['residential_address_id'];
          break;
      default:
        // code...
        break;
    }

  }
  ////////////////////////////////
  ////////////////////////////////
  //     Assign funcitons
  ////////////////////////////////
  ////////////////////////////////
  function checkAssigned($si,$ci,$li){

    $sql ="student_id='$si' AND course_id='$ci' AND lesson_id='$li'";
    $this->db->where($sql);
    $check = $this->db->get('course_student_new');
    $check = $check->result_array();
    if(empty($check)){
      return "false";
    }
    else{
      return "true";
    }
  }
  function checkAssignedTeacher($si,$ci,$li){

    $sql ="teacher_id='$si' AND course_id='$ci' AND lesson_id='$li'";
    $this->db->where($sql);
    $check = $this->db->get('course_teacher');
    $check = $check->result_array();
    if(empty($check)){
      return "false";
    }
    else{
      return "true";
    }
  }
}

?>