<?php
class iterationModel extends ModelBase
{
    //JASYRC 22JUL2010
    public function getList($idproject, $datos = array("inicio" => 0, "tamanio" => 5)){
        
        $query = "SELECT si.*, CONCAT(su.lastname, ', ', su.firstname) AS user"
                ." FROM sis_iteration AS si"
                ." INNER JOIN sis_user AS su ON si.created_by = su.iduser"
                ." WHERE si.idproject = $idproject"
                ." ORDER BY si.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);
    }

    public function getCurrentIteration($idproject){
        $query = "SELECT si.*, CONCAT(su.lastname, ', ', su.firstname) AS user"
                ." FROM sis_iteration AS si"
                ." INNER JOIN sis_user AS su ON si.created_by = su.iduser"
                ." WHERE si.idproject = $idproject AND si.state = 1";
        $result = $this->db->prepare($query);
        $result->execute();
        return $result;
    }

    public function getVersion($idproject, $iteration){
        $query = "SELECT sv.*, su.firstname, su.lastname FROM sis_version AS sv"
                ." INNER JOIN sis_user AS su ON sv.created_by = su.iduser"
                ." WHERE sv.idproject = $idproject AND sv.nversion = $iteration";
        $consulta = $this->db->prepare($query);
        $consulta->execute();
        $num_filas = $consulta->rowCount();
        return $consulta;
    }

    //JASYRC 08JUL2010
    function getProject($idproject){
        $query = "SELECT * FROM sis_project"
                ." WHERE idproject = $idproject";
        $result = $this->db->prepare($query);
        $result->execute();
        return $result;
    }

    //JASYRC 06JUL2010
    function addProject($data_project, $description){
        $query = "INSERT INTO sis_project( title, num_version, code, date_start, "
                ." time_estimated, description, keywords, state, created_by ) VALUES ( '"
                . $data_project['title']."', 1, '".$data_project['code']."', '"
                . $data_project['date_start']."', '".$data_project['time_estimated']."', '"
                . $data_project['keywords']."', '".$description."', 1, "
                . $data_project['iduser'].")";
        $result = $this->db->prepare($query);
        $result->execute();
        $id = $this->db->lastInsertId();
        return array($result, $id);
    }
	
    function getIteration($id){
        $query = "SELECT si.*, CONCAT(su.lastname, ', ', su.firstname) AS user"
                ." FROM sis_iteration AS si"
                ." INNER JOIN sis_user AS su ON si.created_by = su.iduser"
                ." WHERE si.iditeration = $id";
        $result = $this->db->prepare($query);
        $result->execute();
        return $result;
    }
	
    //JASYRC 10MAY2010
    function update($project){
        $query = "UPDATE sis_project SET title = '".$project['title']."',"
                ." time_estimated = '".$project['time_estimated']."',"
                ." description = '".$project['description']."',"
                ." state = ".$project['state']." WHERE idproject = ".$project['idproject'];
        $result = $this->db->prepare($query);
        $result->execute();
        return $result;
    }
	
    //JASYRC 10MAY2010
    function delProject($project){
        $query = "UPDATE sis_project SET state = 5 WHERE idproject = $project";
        $result = $this->db->prepare($query);
        $result->execute();
        return $result;
    }

    //JASYRC 10MAY2010
    function searchProjectbyTitle($title){
        $query = "SELECT * FROM sis_project WHERE title = '$title'";
        $result = $this->db->prepare($query);
        $result->execute();
        return $result;
    }
}
?>