<?php
class dataMedicalModel extends ModelBase{
    public $tableName = 'sis_data_medical';

    public function dolist(){
        $query = "SELECT * FROM ".$this->tableName;
        $result = $this->db->prepare($query);
        $result->execute();
        $num_rows = $result->rowCount();
        return array($result, $num_rows);
    }

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

    public function dolistbyCategory($idcategory){
        $query = "SELECT * FROM ".$this->tableName
                ." WHERE idcategory = ".$idcategory;
        $result = $this->db->prepare($query);
        $result->execute();
        $num_rows = $result->rowCount();
        return array($result, $num_rows);
    }
    public function list_cat1(){
        $this->setQuery("Select *
                        From sis_data_medical
                        Where idcategory = 1");
        $consulta = $this->loadObjectList();
        return $consulta;
    }
    public function list_cat2(){
        $this->setQuery("Select *
                        From sis_data_medical
                        Where idcategory = 2");
        $consulta = $this->loadObjectList();
        return $consulta;
    }
}
?>