public function index($start = 0)
{
$this->load->library("admin");
$this->session->set_userdata("URL_BACK", uri_string());
$items = ITEMS_POR_PAG;
$this->load->library("admin");
$items_lista = crearConsulta("SELECT p FROM " . $this->entityStr . " p");
$this->load->library('pagination');
$config['base_url'] = site_url($this->ctrlPath . "/index");
$config['total_rows'] = count($items_lista->execute());
$config['per_page'] = $items;
$config['uri_segment'] = 3;
//1->Controlador, 2->Metodo, 3 en adelante son los argumentos
$this->pagination->initialize($config);
$items_lista->setMaxResults($items)->setFirstResult($start);
$this->admin->listado($items_lista->execute());
$this->admin->campos($this->camposTabla);
$this->admin->id("id");
$this->admin->titulos($this->titulosTabla);
if ($this->accionesDefault) {
$this->acciones = array("agregar" => array("url" => $this->ctrlPath . "agregar"), "editar" => array("url" => $this->ctrlPath . "/editar", "texto" => icon("fa-pencil") . " Editar", "propiedades" => array("class" => "btn-primary")), "eliminar" => array("texto" => i("", array("class" => "glyphicon glyphicon-remove")) . " Eliminar", "url" => $this->ctrlPath . "/eliminar", "propiedades" => array("class" => "eliminar_link btn-danger")));
}
$this->admin->acciones($this->acciones);
if ($this->vistaPre !== NULL) {
$this->admin->agregarVistaPre($this->vistaPre, $this->datosPre);
}
$this->admin->titulo($this->tituloMaestro);
$this->admin->show();
}
function _buscarCliente_Proveedor($tipo)
{
$nombreRif = $_GET["term"];
$sql = "SELECT p FROM Entities\\ProveedorCliente p WHERE lower(p.nombre) like '%" . strtolower($nombreRif) . "%' OR lower(p.rif) like '%" . strtolower($nombreRif) . "%'";
$sql .= " AND p.tipo='" . $tipo . "'";
$provs_clientes = crearConsulta($sql)->execute();
$proveedores_clientes = array();
foreach ($provs_clientes as $p) {
$proveedores_clientes[] = array("name" => $p->getNombre(), "value" => $p->getRif());
}
return json_encode(array("success" => true, "results" => $proveedores_clientes));
}
public function getLastPost()
{
$sql = crearConsulta("SELECT p FROM Entities\\Post p JOIN p.forum f " . "WHERE f=" . $this->id . " ORDER BY p.creationDate DESC");
$sql->setMaxResults(1);
return $sql->getOneorNullResult();
}
function index()
{
$categories = crearConsulta("SELECT c FROM Entities\\Category c ORDER BY c.order ASC")->execute();
$this->load->view("home.php", array("categories" => $categories));
}
public function getReplies($start = 0, $maxResults = 0)
{
$query = "SELECT p FROM Entities\\Post p LEFT JOIN p.thread t WHERE ";
$query .= " t.id=" . $this->id . " OR p.id=" . $this->id . " ORDER BY p.creationDate ASC";
$sql = crearConsulta($query);
if ($start != 0) {
$sql->setFirstResult($start);
}
if ($maxResults != 0) {
$sql->setMaxResults($maxResults);
}
return $sql->getResult();
}
