public function obtenerColumnasAction()
{
$data['success'] = false;
$this->view->disable();
if ($this->request->getPost('planilla_id') != null) {
$planilla = Planilla::findFirstByPlanilla_id($this->request->getPost('planilla_id'));
if ($planilla && $planilla->getPlanillaCabeceraid() != null) {
$columnas = $this->modelsManager->createBuilder()->columns('columna_nombre,columna_posicion')->from('Columna')->where('columna_cabeceraId=:columna_cabeceraId: AND columna_habilitado=1', array('columna_cabeceraId' => $planilla->getPlanillaCabeceraid()))->orderBy('columna_posicion ASC')->getQuery()->execute()->toArray();
if ($columnas) {
$data['success'] = true;
$retorno = array();
$claves = array();
$i = 0;
foreach ($columnas as $col) {
$retorno[] = $i;
$claves[] = array("data" => $col['columna_nombre']);
$i++;
}
$data['planilla_nombreCliente'] = $planilla->getPlanillaNombreCliente();
$data['columnas'] = $retorno;
$data['claves'] = $claves;
} else {
$data['success'] = false;
}
} else {
$data['error'] = "La planilla no se encontró, o no contiene una cabecera apropiada.";
}
} else {
$data['error'] = "Es necesario que seleccione una planilla ";
}
echo json_encode($data);
}
/**
* OK: Guarda los datos de un remito en la bd
* usado por nuevoAction
* @return bool
*/
public function guardarNuevoAction()
{
if (!$this->request->isPost()) {
return $this->dispatcher->forward(array("controller" => "remito", "action" => "index"));
}
$planilla_id = $this->request->getPost("remito_planillaId");
//Controlamos el formulario
$data = $this->request->getPost();
$remitoForm = new RemitoForm(null, array('required' => ''));
if (!$remitoForm->isValid($data, new Remito())) {
foreach ($remitoForm->getMessages() as $message) {
$this->flash->error($message);
}
return $this->dispatcher->forward(array("controller" => "remito", "action" => "nuevo", "params" => array($planilla_id)));
}
$clienteForm = new ClienteNewForm(null, array('required' => ''));
if (!$clienteForm->isValid($data, new Cliente())) {
foreach ($clienteForm->getMessages() as $message) {
$this->flash->error($message);
}
return $this->dispatcher->forward(array("controller" => "remito", "action" => "nuevo", "params" => array($planilla_id)));
}
//Controlamos que exista la planilla
$planilla = Planilla::findFirst(array('planilla_id=:planilla_id: AND planilla_finalizada=0 AND planilla_habilitado=1 AND planilla_armada=1', 'bind' => array('planilla_id' => $planilla_id)));
if (!$planilla) {
$this->flash->error('Hubo un problema, la planilla no permite agregar más remitos.');
return $this->dispatcher->forward(array("controller" => "remito", "action" => "nuevo", "params" => array($planilla_id)));
}
/*==================== Generar Ultimo Nro de Remito ===============================*/
$this->db->begin();
$nuevoRemito = new Remito();
$ultimoRemito = Remito::findFirst(array("remito_ultima = 1 AND remito_habilitado=1 AND remito_planillaId = :planilla_id:", 'bind' => array('planilla_id' => $planilla_id)));
if (!$ultimoRemito) {
$nuevoRemito->setRemitoUltima(1);
$nuevoRemito->setRemitoNroOrden(1);
} else {
$nuevoRemito->setRemitoUltima(1);
$ultimoRemito->setRemitoUltima(0);
$nuevoRemito->setRemitoNroOrden($ultimoRemito->getRemitoNroOrden() + 1);
if (!$ultimoRemito->update()) {
$this->flash->error('Hubo un problema con la conexion, intenteló nuevamente');
$this->db->rollback();
return $this->dispatcher->forward(array("controller" => "remito", "action" => "nuevo", "params" => array($planilla_id)));
}
}
/*==================== Guardando Datos del Remito ===============================*/
$nuevoRemito->setRemitoPlanillaId($planilla_id);
$nuevoRemito->setRemitoFechaCreacion(date('Y-m-d'));
$nuevoRemito->setRemitoCreadoPor($this->session->get('auth')['usuario_nick']);
$nuevoRemito->setRemitoHabilitado(1);
$nuevoRemito->setRemitoFecha($this->request->getPost('remito_fecha'));
$nuevoRemito->setRemitoNro($this->request->getPost('remito_nro'));
$nuevoRemito->setRemitoPeriodo(date('m', date(strtotime(date($this->request->getPost("remito_fecha"))))));
if ($this->request->hasFiles() && $this->request->getUploadedFiles()[0] != NULL) {
var_dump($this->request->getUploadedFiles());
$upload = $this->guardarPDF($this->request->getUploadedFiles(), $planilla->getPlanillaClienteId(), $planilla->getPlanillaFecha());
if (!$upload['success']) {
$this->flash->error($upload['mensaje']);
$this->db->rollback();
return $this->dispatcher->forward(array("controller" => "remito", "action" => "nuevo", "params" => array($planilla_id)));
}
$nuevoRemito->setRemitoPdf($upload['path']);
}
$nuevoRemito->setRemitoObservacion($this->request->getPost('remito_observacion'));
$nuevoRemito->setRemitoConformidad($this->request->getPost('remito_conformidad'));
$nuevoRemito->setRemitoNoConformidad($this->request->getPost('remito_noConformidad'));
/* ==================== ==================== ==================== ==================== */
$nuevoRemito->setRemitoTransporteId($this->request->getPost('remito_transporteId'));
$nuevoRemito->setRemitoTipoEquipoId($this->request->getPost('remito_tipoEquipoId'));
$nuevoRemito->setRemitoTipoCargaId($this->request->getPost('remito_tipoCargaId'));
$nuevoRemito->setRemitoChoferId($this->request->getPost('remito_choferId'));
/* ==================== ==================== ==================== ==================== */
$nuevoRemito->setRemitoClienteId($planilla->getPlanillaClienteId());
$nuevoRemito->setRemitoCentroCostoId($this->request->getPost('centroCosto_id'));
$nuevoRemito->setRemitoEquipoPozoId($this->request->getPost('equipoPozo_id'));
$nuevoRemito->setRemitoOperadoraId($this->request->getPost('operadora_id'));
/* ==================== ==================== ==================== ==================== */
$nuevoRemito->setRemitoViajeId($this->request->getPost('remito_viajeId'));
$nuevoRemito->setRemitoConcatenadoId($this->request->getPost('remito_concatenadoId'));
/* ==================== ==================== ==================== ==================== */
$tarifa = new Tarifa();
$tarifa->setTarifaHoraInicial($this->request->getPost("tarifa_horaInicial"));
$tarifa->setTarifaHoraFinal($this->request->getPost("tarifa_horaFinal"));
$tarifa->setTarifaHsServicio($this->request->getPost("tarifa_hsServicio"));
$tarifa->setTarifaHsHidro($this->request->getPost("tarifa_hsHidro"));
$tarifa->setTarifaHsMalacate($this->request->getPost("tarifa_hsMalacate"));
$tarifa->setTarifaHsStand($this->request->getPost("tarifa_hsStand"));
$tarifa->setTarifaKm($this->request->getPost("tarifa_km"));
if (!$tarifa->save()) {
foreach ($tarifa->getMessages() as $mensaje) {
$this->flash->error($mensaje);
}
$this->db->rollback();
return $this->dispatcher->forward(array("controller" => "remito", "action" => "nuevo", "params" => array($planilla_id)));
}
$nuevoRemito->setRemitoTarifaId($tarifa->getTarifaId());
/* ==================== ==================== ==================== ==================== */
$planilla = Planilla::findFirstByPlanilla_id($planilla_id);
$columnas = Columna::find(array("columna_cabeceraId=:cabecera_id: AND columna_habilitado = 1 AND columna_extra = 1", 'bind' => array('cabecera_id' => $planilla->getPlanillaCabeceraid())));
if (count($columnas) != 0) {
foreach ($columnas as $col) {
$contenidoExtra = new Contenidoextra();
$contenidoExtra->setContenidoExtraHabilitado(1);
$contenidoExtra->setContenidoExtraColumnaId($col->getColumnaId());
echo "<br> COl NOmbre" . $col->getColumnaClave();
echo "<br> getPOst" . $this->request->getPost($col->getColumnaClave());
$contenidoExtra->setContenidoExtraDescripcion($this->request->getPost($col->getColumnaClave()));
if (!$contenidoExtra->save()) {
foreach ($contenidoExtra->getMessages() as $mensaje) {
$this->flash->error($mensaje);
}
$this->db->rollback();
return $this->dispatcher->forward(array("controller" => "remito", "action" => "nuevo", "params" => array($planilla_id)));
}
}
}
/* ==================== ==================== ==================== ==================== */
if (!$nuevoRemito->save()) {
foreach ($nuevoRemito->getMessages() as $mensaje) {
$this->flash->error($mensaje);
}
$this->db->rollback();
return $this->dispatcher->forward(array("controller" => "remito", "action" => "nuevo", "params" => array($planilla_id)));
}
$this->db->commit();
$this->flash->success('Remito creado satisfactoriamente');
return $this->dispatcher->forward(array("controller" => "remito", "action" => "finaliza", "params" => array($planilla_id)));
}
public function verOrdenesAction($planillaId)
{
parent::importarJsSearch();
$numberPage = 1;
$orden = Orden::findByOrden_planillaId($planillaId);
if (count($orden) == 0) {
$this->flash->notice("La planilla seleccionada no contiene ordenes cargadas.");
return $this->dispatcher->forward(array("controller" => "planilla", "action" => "search"));
}
$tabla = $this->generarTablaDeOrdenes($orden);
$paginator = new Paginator(array("data" => $tabla, "limit" => 100000, "page" => $numberPage));
$this->view->page = $paginator->getPaginate();
$planilla = Planilla::findFirstByPlanilla_id($planillaId);
if ($planilla) {
$this->view->planilla = $planilla;
}
$this->view->pick('orden/search');
}
/**
* Habilitacion logica.
* @param $id
* @return bool
*/
public function habilitarAction($id)
{
$planilla = Planilla::findFirstByPlanilla_id($id);
if (!$planilla) {
$this->flash->error("La planilla no ha sido encontrada");
return $this->dispatcher->forward(array("controller" => "planilla", "action" => "index"));
}
$planilla->planilla_habilitado = 1;
if (!$planilla->update()) {
foreach ($planilla->getMessages() as $message) {
$this->flash->error($message);
}
return $this->dispatcher->forward(array("controller" => "planilla", "action" => "search"));
}
$this->flash->success("La planilla ha sido habilitada");
return $this->dispatcher->forward(array("controller" => "planilla", "action" => "search"));
}
/**
* Crea una cabecera con las columnas basicas
* @param $planilla
* @return array
*/
public function crearColumnasBasicasAction()
{
$this->view->disable();
if ($this->request->isPost()) {
$planilla = Planilla::findFirstByPlanilla_id($this->request->getPost('planilla_id', 'int'));
if (!empty($planilla) && $planilla != null) {
$data = $this->columnasBasicas($planilla);
} else {
$data['success'] = false;
$data['mensaje'] = "La planilla no se encuentra disponible.";
}
echo json_encode($data);
} else {
echo json_encode(array('success' => false, 'mensaje' => 'NO ES POST'));
}
}
