<?php

class DBwords extends CI_Model {

    function __construct() {
        // Call the Model constructor
        parent::__construct();

        $this->load->library('Myword');
    }

    /*
     * Gets all names from ddbb that starts with ($startswith) in the language ($language)
     */

    function getDBNamesLike($startswith, $user)
    {
        // Expansion language
        $languageExp = $this->session->userdata('ulangabbr');
        //Interface language
        $languageInt = $this->session->userdata('uinterfacelangauge');
        
        $output = array();
        
        $this->db->limit(6);// limit up to 6
        
        $this->db->where_in('Pictograms.ID_PUser', array('1',$user));
        $this->db->where('PictogramsLanguage.languageid', $languageInt);
        //$this->db->or_where_in('Pictograms.ID_PUser', array('1',$user)); //Get all default and own user pictos
        $this->db->select('nameid as id, PictogramsLanguage.pictotext as text, imgPicto, Pictograms.ID_PUser');// rename the field like we want
        
        //$this->db->from('Name'. $language);// select the table name+language
        $this->db->join('Pictograms', 'Name' . $languageExp . '.nameid = Pictograms.pictoid', 'left'); // Join the tables name with the picto associate
        $this->db->join('PictogramsLanguage', 'PictogramsLanguage.pictoid = Pictograms.pictoid', 'left');
        $this->db->like('PictogramsLanguage.pictotext', $startswith, 'after');// select only the names that start with $startswith
        $this->db->order_by('PictogramsLanguage.pictotext', 'asc'); // order the names 
        $query = $this->db->get('Name'. $languageExp);// execute de query
              
        if ($query->num_rows() > 0) {
            $output = $query->result_array();
        }
        return $output;
    }

   /*
     * Gets all verbs from ddbb that starts with ($startswith) in the language ($language)
     */
    
    function getDBVerbsLike($startswith, $user)
    {
        // Expansion language
        $languageExp = $this->session->userdata('ulangabbr');
        //Interface language
        $languageInt = $this->session->userdata('uinterfacelangauge');
        
        $output = array();
      
        $this->db->limit(6);
        $this->db->where_in('Pictograms.ID_PUser', array('1',$user));
        $this->db->where('PictogramsLanguage.languageid', $languageInt); //Get all default and own user pictos
        $this->db->select('verbid as id, PictogramsLanguage.pictotext as text, imgPicto');
        $this->db->from('Verb'.$languageExp);
        $this->db->join('Pictograms', 'Verb'.$languageExp.'.verbid = Pictograms.pictoid', 'left');
        $this->db->join('PictogramsLanguage', 'PictogramsLanguage.pictoid = Pictograms.pictoid', 'left');
        $this->db->where('actiu', '1');
        $this->db->like('PictogramsLanguage.pictotext', $startswith, 'after');
        $this->db->order_by('PictogramsLanguage.pictotext', 'asc');
        $query = $this->db->get();

        if ($query->num_rows() > 0) {
            $output = $query->result_array();
        }
        
        return $output;
    }

    /*
     * Gets all adjectius from ddbb that starts with ($startswith) in the language ($language)
     */
    function getDBAdjLike($startswith, $user)
    {
        // Expansion language
        $languageExp = $this->session->userdata('ulangabbr');
        //Interface language
        $languageInt = $this->session->userdata('uinterfacelangauge');
        
        $output = array();
        
        $this->db->limit(6);
        $this->db->where_in('Pictograms.ID_PUser', array('1',$user));
        $this->db->where('PictogramsLanguage.languageid', $languageInt);//Get all default and own user pictos
        $this->db->select('adjid as id,PictogramsLanguage.pictotext as text, imgPicto');
        $this->db->from('Adjective'.$languageExp);
        $this->db->join('Pictograms', 'Adjective'.$languageExp.'.adjid = Pictograms.pictoid', 'left');
        $this->db->join('PictogramsLanguage', 'PictogramsLanguage.pictoid = Pictograms.pictoid', 'left');
        $this->db->like('PictogramsLanguage.pictotext', $startswith, 'after');
        $this->db->order_by('PictogramsLanguage.pictotext', 'asc');
        $query = $this->db->get();

        if ($query->num_rows() > 0) {
            $output = $query->result_array();
        }
        return $output;
    }
    
    /*
     * Gets all expressions from ddbb that starts with ($startswith) in the language ($language)
     */
    function getDBExprsLike($startswith, $user)
    {
        // Expansion language
        $languageExp = $this->session->userdata('ulangabbr');
        //Interface language
        $languageInt = $this->session->userdata('uinterfacelangauge');
        
        $output = array();
        
        $this->db->limit(6);
        $this->db->where_in('Pictograms.ID_PUser', array('1',$user));
        $this->db->where('PictogramsLanguage.languageid', $languageInt); //Get all default and own user pictos
        $this->db->select('exprid as id, PictogramsLanguage.pictotext as text, imgPicto');
        $this->db->from('Expressions'.$languageExp);
        $this->db->join('Pictograms', 'Expressions'.$languageExp.'.exprid = Pictograms.pictoid', 'left');
        $this->db->join('PictogramsLanguage', 'PictogramsLanguage.pictoid = Pictograms.pictoid', 'left');
        $this->db->like('PictogramsLanguage.pictotext', $startswith, 'after');
        $this->db->order_by('PictogramsLanguage.pictotext', 'asc');
        $query = $this->db->get();

        if ($query->num_rows() > 0) {
            $output = $query->result_array();
        }
        return $output;
    }

    /*
     * Gets all adverbs from ddbb that starts with ($startswith) in the language ($language)
     */
    function getDBAdvsLike($startswith, $user)
    {
        // Expansion language
        $languageExp = $this->session->userdata('ulangabbr');
        //Interface language
        $languageInt = $this->session->userdata('uinterfacelangauge');
        
        $output = array();
        
        $this->db->limit(6);
        $this->db->where_in('Pictograms.ID_PUser', array('1',$user));
        $this->db->where('PictogramsLanguage.languageid', $languageInt); //Get all default and own user pictos
        $this->db->select('advid as id, PictogramsLanguage.pictotext as text, imgPicto');
        $this->db->from('Adverb'.$languageExp);
        $this->db->join('Pictograms', 'Adverb'.$languageExp.'.advid = Pictograms.pictoid', 'left');
        $this->db->join('PictogramsLanguage', 'PictogramsLanguage.pictoid = Pictograms.pictoid', 'left');
        $this->db->like('PictogramsLanguage.pictotext', $startswith, 'after');
        $this->db->order_by('PictogramsLanguage.pictotext', 'asc');
        $query = $this->db->get();

        if ($query->num_rows() > 0) {
            $output = $query->result_array();
        }

        return $output;
    }

    /*
     * Gets all modifier from ddbb that starts with ($startswith) in the language ($language)
     */
    function getDBModifsLike($startswith, $user)
    {
        // Expansion language
        $languageExp = $this->session->userdata('ulangabbr');
        //Interface language
        $languageInt = $this->session->userdata('uinterfacelangauge');
        
        $output = array();
        
        $this->db->limit(6);
        $this->db->where_in('Pictograms.ID_PUser', array('1',$user));
        $this->db->where('PictogramsLanguage.languageid', $languageInt); //Get all default and own user pictos
        $this->db->select('modid as id, PictogramsLanguage.pictotext as text, imgPicto');
        $this->db->from('Modifier'.$languageExp);
        $this->db->join('Pictograms', 'Modifier'.$languageExp.'.modid = Pictograms.pictoid', 'left');
        $this->db->join('PictogramsLanguage', 'PictogramsLanguage.pictoid = Pictograms.pictoid', 'left');
        $this->db->like('PictogramsLanguage.pictotext', $startswith, 'after'); 
        $this->db->order_by('PictogramsLanguage.pictotext', 'asc');
        $query = $this->db->get();
        
        if ($query->num_rows() > 0) {
            $output = $query->result_array();
        }

        return $output;
    }


    /*
     * Gets all QuestionPart from ddbb that starts with ($startswith) in the language ($language)
     */
    function getDBQuestionPartLike($startswith, $user)
    {
        // Expansion language
        $languageExp = $this->session->userdata('ulangabbr');
        //Interface language
        $languageInt = $this->session->userdata('uinterfacelangauge');
        
        $output = array();
        
        $this->db->limit(6);
        $this->db->where_in('Pictograms.ID_PUser', array('1',$user));
        $this->db->where('PictogramsLanguage.languageid', $languageInt);  //Get all default and own user pictos
        $this->db->select('questid as id, PictogramsLanguage.pictotext as text, imgPicto');
        $this->db->from('QuestionPart'.$languageExp);
        $this->db->join('Pictograms', 'QuestionPart'.$languageExp.'.questid = Pictograms.pictoid', 'left');
        $this->db->join('PictogramsLanguage', 'PictogramsLanguage.pictoid = Pictograms.pictoid', 'left');
        $this->db->like('PictogramsLanguage.pictotext', $startswith, 'after'); 
        $this->db->order_by('PictogramsLanguage.pictotext', 'asc');
        $query = $this->db->get();

        if ($query->num_rows() > 0) {
            $output = $query->result_array();
        }

        return $output;
    }

}