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;
}
}
