<?php
class RolesModel extends ModelBase{

    public $tableName = 'sis_role';
    public $id = array('key'=>'idrole','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 getRoles($datos = array("inicio" => 0, "tamanio" => 5)){
        $query = "SELECT * FROM sis_role";
        $consulta = $this->db->prepare($query);
        $consulta->execute();
        $num_filas = $consulta->rowCount();

        $parametros = array("total" => $num_filas, "inicio" => $datos['inicio'], "pagina" =>  $datos['tamanio']);
        list($paginas,$navegador) = $this->getPager($parametros);

        $consulta = $this->db->prepare($query.' LIMIT '.$datos['inicio'].' , '.$datos['tamanio'].' ');
        $consulta->execute();

        return array($consulta,$paginas,$navegador);
    }

    //JASYRC 03JUN2010
    public function getRole($idrole){
        $query = "SELECT * FROM sis_role WHERE idrole = $idrole";
        $result = $this->db->prepare($query);
        $result->execute();
        return $result;
    }

    public function newRole(){
        $query = "SELECT sis_function.*  FROM  sis_function";
        $consulta = $this->db->prepare($query);
        $consulta->execute();
        return $consulta;
    }

    //JASYRC 26JUL2010
    function getFunctionbyCat($cat){
        $query = "SELECT * FROM sis_function"
                ." WHERE category = '$cat'";
        $result = $this->db->prepare($query);
        $result->execute();
        $num_rows = $result->rowCount();
        return array($result, $num_rows);
    }

    //JASYRC 26JUL2010
    function getFunctions($cat, $idrole){
        $query = "SELECT sf.*, srf.idrole FROM sis_rolexfunction AS srf"
                ." INNER JOIN sis_function AS sf"
                ." ON srf.idfunction = sf.idfunction"
                ." WHERE sf.category = '$cat' AND srf.idrole = $idrole";
        $result = $this->db->prepare($query);
        $result->execute();
        return $result;
    }
    
    public function addFunction($function, $idrole){
        for($i = 0; $i < count($function); $i++){
            $query = "INSERT INTO sis_rolexfunction (idrole, idfunction) VALUES ("
                    . $idrole.", ".$function[$i].")";
            $result = $this->db->prepare($query);
            $result->execute();
        }

        return $result;
    }

    public function upgrade($data_role, $functions){
        $query = "DELETE FROM sis_rolexfunction WHERE idrole = ".$data_role['idrole'];
        $result = $this->db->prepare($query);
        $result->execute();

        for($i = 0; $i < count($functions); $i++){
            $query = "INSERT INTO sis_rolexfunction (idrole, idfunction) VALUES ("
                    . $data_role['idrole'].", ".$functions[$i].")";
            $result = $this->db->prepare($query);
            $result->execute();
        }

        return $result;
    }

    public function DeleteFunction($id){
        $query = "DELETE FROM sis_rolexfunction WHERE idrole = ".$id;
        $result = $this->db->prepare($query);
        $result->execute();
        return $result;
    }
}
?>