|
|
<?php
|
|
|
class criteriaModel extends ModelBase{
|
|
|
public $tableName = 'sis_criteria';
|
|
|
public $id = array('key'=>'idcriteria','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 dolist($type, $category, $idapplication){
|
|
|
$query = "SELECT sc.*, sdg.name_field, sdg.ordering FROM ".$this->tableName." AS sc"
|
|
|
." INNER JOIN sis_data_general AS sdg"
|
|
|
." ON sc.iddata_general = sdg.iddata_general"
|
|
|
." WHERE sc.type = ".$type." AND sdg.idcategory = ".$category
|
|
|
." AND sc.idapplication = ".$idapplication." ORDER BY sdg.ordering";
|
|
|
$result = $this->db->prepare($query);
|
|
|
$result->execute();
|
|
|
$num_rows = $result->rowCount();
|
|
|
return array($result, $num_rows);
|
|
|
}
|
|
|
}
|
|
|
?>
|
|
|
|
