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)); } }
public function nuevocargoAction() { $request = $this->getRequest(); if ($request->isPost()) { $post_data = $request->getPost(); $post_files = $request->getFiles(); $auth = new \Shared\Session\AouthSession(); $auth = $auth->getData(); $entity = new \Expedientegasto(); foreach ($post_data as $key => $value) { if (\ExpedientegastoPeer::getTableMap()->hasColumn($key) && !empty($value) && $key != 'expedientegasto_fecha') { $entity->setByName($key, $value, \BasePeer::TYPE_FIELDNAME); } } //LA FECHA $expedientegasto_fecha = \DateTime::createFromFormat('d/m/Y', $post_data['expedientegasto_fecha']); $entity->setExpedientegastoFecha($expedientegasto_fecha); $entity->setIdempleado($auth['idempleado']); $entity->save(); //El comprobante if (!empty($post_files['expedientegasto_comprobante']['name'])) { $target_path = "/files/expedientesgastos/"; $target_path = $target_path . $entity->getIdexpedientegasto() . '_' . basename($post_files['expedientegasto_comprobante']['name']); if (move_uploaded_file($_FILES['expedientegasto_comprobante']['tmp_name'], $_SERVER['DOCUMENT_ROOT'] . $target_path)) { $entity->setExpedientegastoComprobante($target_path); $entity->save(); } } $this->flashMessenger()->addSuccessMessage('Registro guardado exitosamente!'); //REDIRECCIONAMOS A LA ENTIDAD QUE ACABAMOS DE CREAR return $this->redirect()->toUrl('/clientes/ver/' . $entity->getExpediente()->getIdcliente() . '/expedientes/ver/' . $entity->getIdexpediente()); } $idexpediente = $this->params()->fromQuery('id'); $moneda = $this->params()->fromQuery('moneda'); $entity = \ExpedienteQuery::create()->findPk($idexpediente); //LAS CATEGORIAS DE NUESTROS GASTOS $categoriasgasto = \CategoriagastoQuery::create()->find(); $categoriasgasto_array = array(); foreach ($categoriasgasto as $categoriagastos) { $id = $categoriagastos->getIdcategoriagasto(); $categoriasgasto_array[$id] = $categoriagastos->getCategoriagastoNombre(); } //LOS PROVEEDORES $proveedores = \ProveedoritradeQuery::create()->filterByIdproveedoritrade(1, \Criteria::NOT_EQUAL)->find(); $proveedores_array = array(); $proveedor = new \Proveedoritrade(); foreach ($proveedores as $proveedor) { $id = $proveedor->getIdproveedoritrade(); $proveedores_array[$id] = $proveedor->getProveedoritradeNombre(); } //INSTANCIAMOS NUESTRO FORMULARIO $form = new \Admin\Clientes\Form\ExpedientegastoForm($idexpediente, $categoriasgasto_array, $proveedores_array, $moneda); //Enviamos a la vista $view_model = new ViewModel(); $view_model->setTerminal(true)->setVariable('form', $form)->setVariable('entity', $entity)->setTemplate('/clientes/expedientes/modal/nuevocargo'); return $view_model; }