public function serversideAction()
{
$request = $this->getRequest();
if ($request->isPost()) {
//EL MAPEO DE NUESTRA TABALA
$table_map = array(0 => 'proveedoritrade_nombre', 1 => 'proveedor_nombrecontacto', 2 => 'proveedoritrade_telefono');
$post_data = $request->getPost();
//NUESTRA QUERY
$query = new \ProveedoritradeQuery();
$query->filterByIdproveedoritrade(1, \Criteria::NOT_EQUAL);
//ORDER
if (isset($post_data['order'])) {
$order = $table_map[$post_data['order'][0]['column']];
$dir = $post_data['order'][0]['dir'];
$query->orderBy($order, $dir);
} else {
$query->orderByIdproveedoritrade(\Criteria::DESC);
}
if (!empty($post_data['search']['value'])) {
$search = $post_data['search']['value'];
$c = new \Criteria();
$c1 = $c->getNewCriterion('proveedoritrade.proveedoritrade_nombre', '%' . $search . '%', \Criteria::LIKE);
$c2 = $c->getNewCriterion('proveedoritrade.proveedoritrade_nombrecontacto', '%' . $search . '%', \Criteria::LIKE);
$c3 = $c->getNewCriterion('proveedoritrade.proveedoritrade_telefono', '%' . $search . '%', \Criteria::LIKE);
$c1->addOr($c2)->addOr($c3);
$query->addAnd($c1);
}
//EL TOTAL DE LA BUSQUEDA
$recordsFiltered = $query->count();
//LIMIT
$query->setOffset((int) $post_data['start']);
$query->setLimit((int) $post_data['length']);
//DAMOS EL FORMATO CORRECTO
$data = array();
$value = new \Proveedoritrade();
foreach ($query->find() as $value) {
$tmp['DT_RowId'] = $value->getIdproveedoritrade();
$tmp['proveedoritrade_nombre'] = $value->getProveedoritradeNombre();
$tmp['proveedor_nombrecontacto'] = $value->getProveedoritradeNombrecontacto();
$tmp['proveedoritrade_telefono'] = $value->getProveedoritradeTelefono();
$tmp['empleado_options'] = '<a data-toggle="tooltip" data-placement="left" title="Editar" href="/catalogo/proveedores/editar/' . $value->getIdproveedoritrade() . '"><i class="fa fa-pencil"></i></a><a class="delete" data-toggle="tooltip" data-placement="left" title="Eliminar" href="javascript:void(0)"><i class="fa fa-trash-o"></i></a>';
$data[] = $tmp;
}
//El arreglo que regresamos
$json_data = array("draw" => (int) $post_data['draw'], "recordsFiltered" => $recordsFiltered, "data" => $data, "page" => $post_data['url_params']['page']);
return $this->getResponse()->setContent(json_encode($json_data));
}
}
