<?php

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

class Form_model extends CI_Model {

    function __construct() {
        parent::__construct();
        $this->load->database();
    }

    function match_lang($lang){
      $lang = ucfirst($lang);
      $this->db->like('english_name', $lang);
      $query = $this->db->get('mod772_icl_languages');
      $res = $query->result_array();
      foreach ($res as $row) {
        return $row['id'];
      }
      return "1";
    }
    function get_candidate_s(){
      ///$this->db->from('candidate_student');
      //$this->db->where('stauts','0');
      //$this->b->order_by("id", "desc")->get_where('stauts','0');
      $query = $this->db->query("SELECT * FROM `candidate_student` WHERE `status` = '0'  ORDER BY `id` DESC;");
      return $query->result_array();
    }
    function get_candidate_t(){
      $query = $this->db->query("SELECT * FROM `candidate_teacher` WHERE `status` = '0'  ORDER BY `id` DESC;");
      return $query->result_array();
    }
    function get_age($dob){
      $age = date_diff(date_create($dob), date_create('now'))->y;
      return $age;
    }
    function get_pending_s(){
      $query = $this->db->query("SELECT * FROM `candidate_student` WHERE  `status` = '1' ORDER BY `id` DESC;");
      return $query->result_array();
    }
    function get_pending_t(){
      $query = $this->db->query("SELECT * FROM `candidate_teacher` WHERE  `status` = '1' ORDER BY `id` DESC;");
      return $query->result_array();
    }
    function remove_pending_s($id){
      $this->db->delete('candidate_student',array('student_id'=>$id));
    }

    function display_pref($mor,$aft,$evn){
      try {
        $days = array('Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat');
        $morning = "";
        $afternoon = "";
        $evening = "";

        if($mor != ""){
          $morningJson = json_decode($mor);
          //return var_dump(array_keys($morningJson));

            foreach($morningJson as $key => $val){
              //return $key;
              $morning  = $morning."<span class='btn btn-default'>".$key."</span>";
            }

        }else{
            $morning = "";
        }

        if($aft != ""){
          $afternoonJson = json_decode($aft);
          foreach ($afternoonJson as $key => $value) {
            $afternoon  = $afternoon." <span class='btn btn-default'>".$key."</span>";
          }
        }else{
              $afternoon = "";
        }

        if($evn != ""){
          $eveningJson = json_decode($evn);
            foreach ($eveningJson as $key => $value) {
              $evening  = $evening."<span class='btn btn-default'>".$key."<span>";
            }
        }else{
              $evening = "";
        }

        $template ="<table class='table'><tr><th>Morning</th><th>Afternoon</th><th>evening</th></tr><tr><td>".$morning."</td><td>".$afternoon."</td><td>".$evening."</td></tr></table>";
        return $template;
      }
      catch(Exception $e){
        return "error on json:".$e;
      }
    }
}