|
|
<?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;
|
|
|
}
|
|
|
}
|
|
|
?>
|
|
|
|
