public function getFile($nFile) { $sql = 'SELECT agencia, nompax, CONVERT(Nvarchar(10), fecha, 103) as fecha, hora, CONVERT(Nvarchar(10), f_viaje, 103) as f_viaje, comag, tcomi, cambio, moneda, totventa, ajuste, (totventa+ajuste) as tot_reserva, vage,ope,totpag,totalco,ciudad,pais ,npax, (convert(varchar,(DATEADD(HOUR,48,GETDATE())),103)+" "+convert(varchar(5),(DATEADD(HOUR,48,GETDATE())),108)) AS LIMITE_PAGO, estado,(convert(varchar,(DATEADD(HOUR,48,GETDATE())),103))as fconsulta,convert(varchar(5),(DATEADD(HOUR,48,GETDATE())),108) as fhora FROM file_ WHERE num_file = "' . $nFile . '"'; //echo $sql; exit; $datos = $this->_db->consulta($sql); if ($this->_db->numRows($datos) > 0) { $objetosFile = array(); $arrayObjFile = $this->_db->fetchAll($datos); foreach ($arrayObjFile as $fileDB) { $objFile = new reservaDTO(); $objFile->setAgencia(trim($fileDB['agencia'])); $objFile->setNomPax(trim($fileDB['nompax'])); $objFile->setNpax(trim($fileDB['npax'])); $objFile->setFecha(trim($fileDB['fecha'])); $objFile->setHora(trim($fileDB['hora'])); $objFile->setFViaje(trim($fileDB['f_viaje'])); $objFile->setComag(trim($fileDB['comag'])); $objFile->setTcomi(intval(trim($fileDB['tcomi']))); $objFile->setCambio(trim($fileDB['cambio'])); $objFile->setMoneda(trim($fileDB['moneda'])); $objFile->setTotVenta(trim($fileDB['totventa'])); $objFile->setAjuste(trim($fileDB['ajuste'])); $objFile->setChora(trim($fileDB['fhora'])); $objFile->setFconsulta(trim($fileDB['fconsulta'])); $objFile->setTotPag(trim($fileDB['totpag'])); $objFile->setTotReserva(trim($fileDB['tot_reserva'])); $objFile->setVage(trim($fileDB['vage'])); $objFile->setOperador(trim($fileDB['ope'])); $objFile->setTotalco(trim($fileDB['totalco'])); $objFile->setEstado(trim($fileDB['estado'])); $objFile->setPais(trim($fileDB['pais'])); $objFile->setCiudad(trim($fileDB['ciudad'])); $sql = 'SELECT piva FROM iva'; $datos = $this->_db->consulta($sql); $iva = $this->_db->fetchAll($datos); if ($fileDB['tcomi'] == 1) { $resultado = $fileDB['comag'] * $iva[0][0]; } else { $resultado = $fileDB['comag']; } if ($fileDB['moneda'] === 'D') { $comision = round($fileDB['totventa'] * ($resultado / 100), 2); } else { $comision = round($fileDB['totventa'] * ($resultado / 100), 0); } $objFile->setComision($comision); $objFile->setHoraLimi(trim($fileDB['LIMITE_PAGO'])); $objetosFile[] = $objFile; } return $objetosFile; } else { return false; } }
public function getReservas_TEST($desde, $hasta, $tipo, $spAcceso, $cUsuario) { $sql = 'SELECT a.*, (SELECT TOP 1 cod_pak FROM det_file where num_file = A.num_file) as cod_pak, (SELECT top 1 record_c FROM det_bloq where num_file = A.num_file) as record_c FROM (SELECT agencia, num_file, nompax, totventa, estado, totpag, usuario, moneda, CONVERT(VARCHAR(10), fecha, 103) as fecha, CONVERT(VARCHAR(10), f_viaje, 103) as f_viaje, fecha as fecha2, f_viaje as f_viaje2, ROW_NUMBER() OVER '; if ($tipo == 1) { $sql .= ' (ORDER BY fecha) as row'; } elseif ($tipo == 2) { $sql .= ' (ORDER BY f_viaje) as row'; } $sql .= ' FROM file_ '; //echo $sql; exit; $datos = $this->_db->consulta($sql); if ($this->_db->numRows($datos) > 0) { $objetosReserva = array(); $arrayReservas = $this->_db->fetchAll($datos); foreach ($arrayReservas as $rDB) { $objReserva = new reservaDTO(); $objReserva->setAgencia(trim($rDB['agencia'])); $objReserva->setFile(trim($rDB['num_file'])); $objReserva->setNomPax(trim($rDB['nompax'])); $objReserva->setTotVenta(intval($rDB['totventa'])); $objReserva->setEstado(trim($rDB['estado'])); $objReserva->setTotPag(intval($rDB['totpag'])); $objReserva->setUsuario(trim($rDB['usuario'])); $objReserva->setMoneda(trim($rDB['moneda'])); $objReserva->setFecha(trim($rDB['fecha'])); $objReserva->setFViaje(trim($rDB['f_viaje'])); $objReserva->setFecha2(trim($rDB['fecha2'])); $objReserva->setFViaje2(trim($rDB['f_viaje2'])); $objReserva->setRow(trim($rDB['row'])); $objReserva->setCodPak(trim($rDB['cod_pak'])); $objReserva->setRecordC(trim($rDB['record_c'])); $objetosReserva[] = $objReserva; } return $objetosReserva; } else { return false; } }