<?php
class groupsModel extends ModelBase{

    public $tableName = 'sis_group';
    public $id = array('key'=>'idgroup','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 getProjectswG(){
        $query = "SELECT idproject, title FROM sis_project"
                ." WHERE idproject NOT IN (SELECT idproject FROM sis_group)"
                ." ORDER BY title";
        $consulta = $this->db->prepare($query);
        $consulta->execute();
        $num_rows = $consulta->rowCount();
        return array($consulta, $num_rows);
    }
	
    //JASYRC 10MAY2010
    public function getGroups($datos = array("inicio" => 0, "tamanio" => 5)){
        $query = "SELECT * FROM sis_group WHERE state = 1 OR state = 2 ORDER BY date_create ASC";
        $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 02JUN2010
    public function getAllProjects(){
        $query = "SELECT idproject, title FROM sis_project";
        $result = $this->db->prepare($query);
        $result->execute();
        return $result;
    }
	
    //JASYRC 10MAY2010
    function addGroup($data_group, $description){
        $query = "INSERT INTO sis_group( idproject, name_group, alias, date_create, picture,"
                ."  description, state, created_by ) VALUES ( ".$data_group['idproject'].",'"
                .$data_group['name_group']."',"." '".$data_group['alias']."', '"
                .$data_group['date_create']."', '".$data_group['picture']."',"
                ." '".$description."', 1, ".$data_group['iduser'].")";
        $result = $this->db->prepare($query);
        $result->execute();
        return $result;
    }
	
    //JASYRC 10MAY2010
    function editGroup($group){
        $query = "SELECT * FROM sis_group WHERE idgroup = $group";
        $result = $this->db->prepare($query);
        $result->execute();
        return $result;
    }

    //JASYRC 02JUN2010
    function asignGroup($group){
        $query = "UPDATE sis_group SET idproject = ".$group['idproject']
                ." WHERE idgroup = ".$group['idgroup'];
        $result = $this->db->prepare($query);
        $result->execute();
        return $result;
    }
	
    //JASYRC 08JUN2010
    function delete1($group){
        //$query = "UPDATE sis_group SET state = 3 WHERE idgroup = $group";
        $query = "DELETE FROM sis_group WHERE idgroup = $group";
        $result = $this->db->prepare($query);
        $result->execute();
        return $result;
    }
	
    //JASYRC 10MAY2010
    function searchGroupbyName($name){
        $query = "SELECT * FROM sis_group WHERE LOWER(name_group) = '".strtolower($name)."'";
        $result = $this->db->prepare($query);
        $result->execute();
        $num_rows = $result->rowCount();
        return $num_rows;
    }
}
?>