<?php
class applicationTestModel extends ModelBase{
    public $tableName = 'sis_appl_test';
    public $id = array('key'=>'idappl_test','value'=>'');

    public function addItem($datos){
        $this->setFieldArray($datos);
        list($resultado,$id,$mensaje) = $this->insert();
        return array ($resultado,$id,$mensaje);
    }

    public function DeleteItem(){
        list($resultado,$mensaje) = $this->delete();
        return array ($resultado,$mensaje);
    }

    public function UpdateItem($datos){
        $this->setFieldArray($datos);
        list($resultado,$mensaje) = $this->update();
        return array ($resultado,$mensaje);
    }

    public function getApplicationTest($number){
        $query = "SELECT spt.* FROM ".$this->tableName." AS spt"
                ." INNER JOIN sis_tests AS st ON spt.idtest = st.idtest"
                ." WHERE st.ordering = ".$number;
        $result = $this->db->prepare($query);
        $result->execute();
        return $result;
    }

    public function getApplicationTestbyID($id){
        $query = "SELECT * FROM ".$this->tableName
                ." WHERE idappl_test = ".$id;
        $result = $this->db->prepare($query);
        $result->execute();
        return $result;
    }

    public function getApplicationTestChecked($id, $idapplication){
        $query = "SELECT * FROM ".$this->tableName
                ." WHERE idtest = ".$id." AND idapplication = ".$idapplication;
        $result = $this->db->prepare($query);
        $result->execute();
        return $result;
    }
    public function info($id){
        $this->setQuery("Select *
                        From sis_appl_test
                        Where idappl_test =".$id);
        $consulta = $this->loadObjectList();
        return $consulta;
    }
    public function Getappl_test($id, $form){
        $this->setQuery("Select *
                        From sis_appl_test
                        Where idappl_test =".$id." and idtest=".$form);
        $consulta = $this->loadObjectList();
        return $consulta;
    }
}
?>