public function editar(Request $request, $id)
{
$data = Assuntos::find($id);
$usuarios = Usuarios::all();
$clientes = Clientes::all();
return view('sistemas.assuntos.editAssuntos', compact('data', $data, 'usuarios', $usuarios, 'clientes', $clientes));
}
public function store()
{
try {
if (Input::get('detalleorden') && Input::get('idcliente')) {
DB::beginTransaction();
$serieobj = Series::where('idsucursal', '=', Input::get('idsucursal'))->where('activa', '=', 1)->first();
$empresa = Empresas::find(Session::get('idempresa'));
$cliente = Clientes::find(Input::get('idcliente'));
$registro = new Ventas();
$registro->tipo = $serieobj->tipo;
$registro->serie = $serieobj->serie;
$registro->numero = $serieobj->actual;
$registro->nitempresa = $empresa->nit;
$registro->nitempresa = $empresa->nit;
$registro->nitcliente = $cliente->nit;
$registro->idcliente = $cliente->id;
$registro->valor = Input::get('valor');
$registro->iva = Input::get('totaliva');
$registro->total = Input::get('total');
$registro->idempresa = $empresa->id;
$registro->idsucursal = Input::get('idsucursal');
if ($registro->save()) {
$detalleordenver = json_decode(Input::get('detalleorden'));
foreach ($detalleordenver as &$productover) {
$detalleventa = new DetalleVentas();
$detalleventa->idventa = $registro->id;
$detalleventa->idproducto = $productover->idproducto;
$detalleventa->cantidad = $productover->cantidad;
$detalleventa->precio = $productover->precio;
$detalleventa->subtotal = $productover->subtotal;
$detalleventa->save();
}
DB::commit();
$respuesta['registros'] = $registro->toArray();
$respuesta['mensaje'] = 'Registro creado exitosamente';
$respuesta['resultado'] = true;
return $respuesta;
} else {
DB::rollback();
$respuesta['registros'] = array();
$respuesta['mensaje'] = 'Error al crear el registro';
$respuesta['resultado'] = false;
return $respuesta;
}
} else {
$respuesta['registros'] = array();
$respuesta['mensaje'] = 'Todos los campos son requeridos';
$respuesta['resultado'] = false;
return $respuesta;
}
} catch (\Exception $e) {
DB::rollback();
$respuesta['registros'] = array();
$respuesta['mensaje'] = 'Error general: ' . $e;
$respuesta['resultado'] = false;
return $respuesta;
}
}
public function run()
{
DB::table('clientes');
$faker = Faker::create();
$n = 123456789;
// Inserção do Cliente Default
Clientes::create(['nome' => 'Default', 'telefone' => 123456789, 'data_nasc' => $faker->date(), 'email' => $faker->email, 'cep' => $faker->randomNumber($n = null), 'endereco' => $faker->streetAddress, 'numero' => $faker->randomDigit, 'bairro' => $faker->word, 'cidade' => $faker->city, 'estado' => $faker->word, 'pais' => $faker->word, 'cpf' => $faker->randomNumber($n = null), 'identidade' => $faker->randomNumber($n = null), 'orgao_emissor' => $faker->numerify('ssp'), 'data_exp' => $faker->date(), 'num_passaporte' => $faker->randomNumber($n = null), 'data_emissao_passaporte' => $faker->date(), 'validade_passaporte' => $faker->date(), 'nome_pai' => $faker->name, 'nome_mae' => $faker->name, 'lembretes' => $faker->word, 'situacoes_id' => 1, 'categorias_id' => 1, 'pacotes_id' => 1]);
foreach (range(2, 50) as $i) {
Clientes::create(['nome' => $faker->name, 'telefone' => $faker->randomNumber($n = null), 'data_nasc' => $faker->date(), 'email' => $faker->email, 'cep' => $faker->randomNumber($n = null), 'endereco' => $faker->streetAddress, 'numero' => $faker->randomDigit, 'bairro' => $faker->word, 'cidade' => $faker->city, 'estado' => $faker->word, 'pais' => $faker->word, 'cpf' => $faker->randomNumber($n = null), 'identidade' => $faker->randomNumber($n = null), 'orgao_emissor' => $faker->numerify('ssp'), 'data_exp' => $faker->date(), 'num_passaporte' => $faker->randomNumber($n = null), 'data_emissao_passaporte' => $faker->date(), 'validade_passaporte' => $faker->date(), 'nome_pai' => $faker->name, 'nome_mae' => $faker->name, 'lembretes' => $faker->word, 'situacoes_id' => $faker->numberBetween(1, 2, 3), 'categorias_id' => $faker->numberBetween(1, 2), 'pacotes_id' => $faker->numberBetween(1, 2)]);
}
}
public function deletar(Request $request, $id)
{
$delete = Clientes::destroy($id);
if ($delete) {
$request->session()->put('msgs', 'Deletado com sucesso!');
return redirect()->back();
} else {
$request->session()->put('msgs', 'Erro ao deletar!');
return redirect()->back();
}
}
public function orcamento(Roteiros $roteiros, Extras $extras, Hoteis $hoteis, Transfers $transfers, Voos $voos, Trens $trens, Cidades $paises, Situacoes $situacoes, Categorias $categorias, Pacotes $pacotes, $id)
{
$clientes = Clientes::find($id);
$situacao = $situacoes->lists('nome', 'id');
$categoria = $categorias->lists('nome', 'id');
$pacote = $pacotes->lists('nome', 'id');
$this->paisModel = $paises;
$paises = $this->paisModel->lists('codigo_pais', 'codigo_pais');
$trem = Trens::where('orcamento', '=', 1)->orderBy('nome')->lists('nome', 'id');
$voo = Voos::where('orcamento', '=', 1)->orderBy('nome_voo')->lists('nome_voo', 'id');
$transfers = Transfers::where('orcamento', '=', 1)->orderBy('nome')->lists('nome', 'id');
$passeios = Passeios::where('orcamento', '=', 1)->orderBy('nome')->lists('nome', 'id');
$hoteis = Hoteis::where('orcamento', '=', 1)->orderBy('nome')->lists('nome', 'id');
$extras = Extras::where('orcamento', '=', 1)->orderBy('nome')->lists('nome', 'id');
$roteiros = Roteiros::where('orcamento', '=', 1)->orderBy('nome')->lists('nome', 'id');
return view('clientesOrcamento.orcamento', compact('roteiros', 'extras', 'hoteis', 'passeios', 'transfers', 'clientes', 'situacao', 'categoria', 'pacote', 'paises', 'trem', 'voo'));
}
public function editTremOrcamento($id, $idCliente)
{
$trens = Trens::find($id);
$clientes = Clientes::find($idCliente);
return view('trens.editTremOrcamento', compact('trens', 'clientes'));
}
public function destroy($id)
{
try {
DB::beginTransaction();
if (Clientes::destroy($id)) {
DB::commit();
$respuesta['registros'] = array();
$respuesta['mensaje'] = 'Registro eliminado correctamente';
$respuesta['resultado'] = true;
return $respuesta;
} else {
DB::rollback();
$respuesta['registros'] = array();
$respuesta['mensaje'] = 'Error al tratar de eliminar el registro';
$respuesta['resultado'] = false;
return $respuesta;
}
} catch (\Exception $e) {
$respuesta['registros'] = array();
$respuesta['mensaje'] = 'Error general: ' . $e;
$respuesta['resultado'] = false;
return $respuesta;
}
}
public function editTransferOrcamento($id, $idCliente)
{
$transfer = Transfers::find($id);
$clientes = Clientes::find($idCliente);
return view('transfers.editTransferOrcamento', compact('transfer', 'clientes'));
}
public function editHotelOrcamento($id, $idCliente)
{
$hotel = Hoteis::find($id);
$clientes = Clientes::find($idCliente);
return view('hoteis.editHotelOrcamento', compact('hotel', 'clientes'));
}
public function detalhes($id)
{
$obs = Observacoes::all();
$clientes = Clientes::find($id);
return view('observacoes.index', compact('obs', 'clientes'));
}
public function editPasseioOrcamento($id, $idCliente)
{
$passeios = Passeios::find($id);
$clientes = Clientes::find($idCliente);
return view('passeios.editPasseioOrcamento', compact('passeios', 'clientes'));
}
public function createDependentesCliente(Dependentes $dependentes, $id)
{
$clientes = Clientes::find($id);
$dependentes = Dependentes::where('clientes_id', '=', 1)->orderBy('nome')->lists('nome', 'id');
return view('dependentes.createDependentesCliente', compact('clientes', 'dependentes'));
}
public function getJson()
{
$clientes = Clientes::orderBy('nome')->join('cidades', 'cidades.id', '=', 'clientes.cidade')->select('clientes.nome', 'clientes.id');
if (isset($_POST['q'])) {
$q = filter_input(INPUT_POST, 'q');
$clientes->where(function ($query) use($q) {
$query->orWhere('nome', 'LIKE', '%' . $q . '%');
});
}
$clientes = $clientes->get();
return Response::json($clientes);
}
public function escolhe()
{
$clientes = Clientes::all();
return view('sistemas.clippings.newClippingsChoiceClient', compact('clientes', $clientes));
}
public function editExtraOrcamento($id, $idCliente)
{
$extras = Extras::find($id);
$clientes = Clientes::find($idCliente);
return view('extras.editExtrasOrcamento', compact('extras', 'clientes'));
}
public function pdfOrcamento($id)
{
$clientes = Clientes::find($id);
$total = 0;
$contTrem = 0;
$contVoo = 0;
$contTransfer = 0;
$contPasseio = 0;
$contHoteis = 0;
$contAdultos = 0;
$contCriancas = 0;
$contExtras = 0;
$totalHotel = 0;
$valorHotel = 0;
$contRoteiros = 0;
$valorVoosPrincipais = 0;
foreach ($clientes->voos as $v) {
if ($v->orcamento == 0 && $v->principal == 'Não') {
$total = $total + $v->valor;
$contVoo++;
}
}
foreach ($clientes->voos as $v) {
if ($v->orcamento == 0 && $v->principal == 'Sim') {
$valorVoosPrincipais = $valorVoosPrincipais + $v->valor;
$contVoo++;
}
}
foreach ($clientes->trens as $t) {
if ($t->orcamento == 0) {
$total = $total + $t->valor;
$contTrem++;
}
}
foreach ($clientes->transfers as $trans) {
if ($trans->orcamento == 0) {
$total = $total + $trans->valor;
$contTransfer++;
}
}
foreach ($clientes->passeios as $passeio) {
if ($passeio->orcamento == 0) {
$total = $total + $passeio->valor;
$contPasseio++;
}
}
foreach ($clientes->hoteis as $hotel) {
if ($hotel->orcamento == 0) {
$contHoteis++;
$contAdultos = $hotel->qtd_adultos;
$contCriancas = $hotel->qtd_criancas;
$valorHotel = $hotel->valor;
$valorHotel = $valorHotel / $hotel->qtd_adultos * $hotel->diarias + $hotel->valor_extra;
$total = $total + $valorHotel;
}
}
foreach ($clientes->extras as $extra) {
if ($extra->orcamento == 0) {
$total = $total + $extra->valor;
$contExtras++;
}
}
foreach ($clientes->roteiros as $roteiro) {
if ($roteiro->orcamento == 0) {
$contRoteiros++;
}
}
$pdf = App::make('dompdf.wrapper');
$html = '<html>
<head>
<style>
input {
line-height: normal; }
input[type="checkbox"], input[type="radio"] {
box-sizing: border-box;
padding: 0; }
input[type="number"]::-webkit-inner-spin-button, input[type="number"]::-webkit-outer-spin-button {
height: auto; }
input[type="search"] {
-webkit-appearance: textfield;
box-sizing: content-box; }
input[type="search"]::-webkit-search-cancel-button, input[type="search"]::-webkit-search-decoration {
-webkit-appearance: none; }
.row {
margin-left: -15px;
margin-right: -15px; }
.row:before, .row:after {
content: " ";
display: table; }
.row:after {
clear: both; }
.table-hover > tbody > tr:hover {
background-color: #f5f5f5; }
table col[class*="col-"] {
position: static;
float: none;
display: table-column; }
table td[class*="col-"], table th[class*="col-"] {
position: static;
float: none;
display: table-cell; }
.table > thead > tr > td.active, .table > thead > tr > th.active, .table > thead > tr.active > td, .table > thead > tr.active > th, .table > tbody > tr > td.active, .table > tbody > tr > th.active, .table > tbody > tr.active > td, .table > tbody > tr.active > th, .table > tfoot > tr > td.active, .table > tfoot > tr > th.active, .table > tfoot > tr.active > td, .table > tfoot > tr.active > th {
background-color: #f5f5f5; }
.table-hover > tbody > tr > td.active:hover, .table-hover > tbody > tr > th.active:hover, .table-hover > tbody > tr.active:hover > td, .table-hover > tbody > tr:hover > .active, .table-hover > tbody > tr.active:hover > th {
background-color: #e8e8e8; }
.table > thead > tr > td.success, .table > thead > tr > th.success, .table > thead > tr.success > td, .table > thead > tr.success > th, .table > tbody > tr > td.success, .table > tbody > tr > th.success, .table > tbody > tr.success > td, .table > tbody > tr.success > th, .table > tfoot > tr > td.success, .table > tfoot > tr > th.success, .table > tfoot > tr.success > td, .table > tfoot > tr.success > th {
background-color: #dff0d8; }
.table-hover > tbody > tr > td.success:hover, .table-hover > tbody > tr > th.success:hover, .table-hover > tbody > tr.success:hover > td, .table-hover > tbody > tr:hover > .success, .table-hover > tbody > tr.success:hover > th {
background-color: #d0e9c6; }
.table > thead > tr > td.info, .table > thead > tr > th.info, .table > thead > tr.info > td, .table > thead > tr.info > th, .table > tbody > tr > td.info, .table > tbody > tr > th.info, .table > tbody > tr.info > td, .table > tbody > tr.info > th, .table > tfoot > tr > td.info, .table > tfoot > tr > th.info, .table > tfoot > tr.info > td, .table > tfoot > tr.info > th {
background-color: #d9edf7; }
.table-hover > tbody > tr > td.info:hover, .table-hover > tbody > tr > th.info:hover, .table-hover > tbody > tr.info:hover > td, .table-hover > tbody > tr:hover > .info, .table-hover > tbody > tr.info:hover > th {
background-color: #c4e3f3; }
.table > thead > tr > td.warning, .table > thead > tr > th.warning, .table > thead > tr.warning > td, .table > thead > tr.warning > th, .table > tbody > tr > td.warning, .table > tbody > tr > th.warning, .table > tbody > tr.warning > td, .table > tbody > tr.warning > th, .table > tfoot > tr > td.warning, .table > tfoot > tr > th.warning, .table > tfoot > tr.warning > td, .table > tfoot > tr.warning > th {
background-color: #fcf8e3; }
.table-hover > tbody > tr > td.warning:hover, .table-hover > tbody > tr > th.warning:hover, .table-hover > tbody > tr.warning:hover > td, .table-hover > tbody > tr:hover > .warning, .table-hover > tbody > tr.warning:hover > th {
background-color: #faf2cc; }
.table > thead > tr > td.danger, .table > thead > tr > th.danger, .table > thead > tr.danger > td, .table > thead > tr.danger > th, .table > tbody > tr > td.danger, .table > tbody > tr > th.danger, .table > tbody > tr.danger > td, .table > tbody > tr.danger > th, .table > tfoot > tr > td.danger, .table > tfoot > tr > th.danger, .table > tfoot > tr.danger > td, .table > tfoot > tr.danger > th {
background-color: #f2dede; }
.table-hover > tbody > tr > td.danger:hover, .table-hover > tbody > tr > th.danger:hover, .table-hover > tbody > tr.danger:hover > td, .table-hover > tbody > tr:hover > .danger, .table-hover > tbody > tr.danger:hover > th {
background-color: #ebcccc; }
.table-responsive {
overflow-x: auto;
min-height: 0.01%; }
.table-responsive {
width: 100%;
margin-bottom: 15.75px;
overflow-y: hidden;
-ms-overflow-style: -ms-autohiding-scrollbar;
border: 1px solid #ddd; }
.table-responsive > .table {
margin-bottom: 0; }
.table-responsive > .table > thead > tr > th, .table-responsive > .table > thead > tr > td, .table-responsive > .table > tbody > tr > th, .table-responsive > .table > tbody > tr > td, .table-responsive > .table > tfoot > tr > th, .table-responsive > .table > tfoot > tr > td {
white-space: nowrap; }
.table-responsive > .table-bordered {
border: 0; }
.table-responsive > .table-bordered > thead > tr > th:first-child, .table-responsive > .table-bordered > thead > tr > td:first-child, .table-responsive > .table-bordered > tbody > tr > th:first-child, .table-responsive > .table-bordered > tbody > tr > td:first-child, .table-responsive > .table-bordered > tfoot > tr > th:first-child, .table-responsive > .table-bordered > tfoot > tr > td:first-child {
border-left: 0; }
.table-responsive > .table-bordered > thead > tr > th:last-child, .table-responsive > .table-bordered > thead > tr > td:last-child, .table-responsive > .table-bordered > tbody > tr > th:last-child, .table-responsive > .table-bordered > tbody > tr > td:last-child, .table-responsive > .table-bordered > tfoot > tr > th:last-child, .table-responsive > .table-bordered > tfoot > tr > td:last-child {
border-right: 0; }
.table-responsive > .table-bordered > tbody > tr:last-child > th, .table-responsive > .table-bordered > tbody > tr:last-child > td, .table-responsive > .table-bordered > tfoot > tr:last-child > th, .table-responsive > .table-bordered > tfoot > tr:last-child > td {
border-bottom: 0; }
.col-md-4 {
width: 33.33333%; }
.table {
width: 100%;
max-width: 100%;
margin-bottom: 21px;
}
.table-bordered th, .table-bordered td {
border: 1px solid #ddd !important; }
.table-bordered {
border: 1px solid #ddd; }
.table-bordered > thead > tr > th, .table-bordered > thead > tr > td, .table-bordered > tbody > tr > th, .table-bordered > tbody > tr > td, .table-bordered > tfoot > tr > th, .table-bordered > tfoot > tr > td {
border: 1px solid #ddd; }
.table-bordered > thead > tr > th, .table-bordered > thead > tr > td {
border-bottom-width: 2px;
border: 1px solid #ddd; }
.table-bordered > thead > tr > th, .table-bordered > thead > tr > td, .table-bordered > tbody > tr > th, .table-bordered > tbody > tr > td, .table-bordered > tfoot > tr > th, .table-bordered > tfoot > tr > td {
border: 1px solid #ddd; }
.table-bordered > thead > tr > th, .table-bordered > thead > tr > td {
border-bottom-width: 2px;
border: 1px solid #ddd; }
.table-bordered > thead > tr > th, .table-bordered > thead > tr > td, .table-bordered > tbody > tr > th, .table-bordered > tbody > tr > td, .table-bordered > tfoot > tr > th, .table-bordered > tfoot > tr > td {
border: 1px solid #ddd; }
.table-bordered > thead > tr > th, .table-bordered > thead > tr > td {
border-bottom-width: 2px; }
.table > thead > tr > th, .table > thead > tr > td, .table > tbody > tr > th, .table > tbody > tr > td, .table > tfoot > tr > th, .table > tfoot > tr > td {
padding: 5px;
line-height: 1.4;
vertical-align: top;
border-top: 1px solid #ddd;
font-size: 11px;
}
.table > thead > tr > th {
vertical-align: bottom;
border-bottom: 2px solid #ddd;
}
.table > caption + thead > tr:first-child > th, .table > caption + thead > tr:first-child > td, .table > colgroup + thead > tr:first-child > th, .table > colgroup + thead > tr:first-child > td, .table > thead:first-child > tr:first-child > th, .table > thead:first-child > tr:first-child > td {
border-top: 0; }
.table > tbody + tbody {
border-top: 2px solid #ddd; }
.table .table {
background-color: #fff; }
.text-right {
text-align: right;
}
.table-striped > tbody > tr:nth-of-type(odd) {
background-color: #f9f9f9; }
.table-striped.dataTable tbody tr.active:nth-child(odd) td,
.table-striped.dataTable tbody tr.active:nth-child(odd) th {
background-color: #017ebc;
}
.text-center {
text-align: center; }
body {
font-family: "Open Sans", "Helvetica Neue", Helvetica, Arial, sans-serif;
font-size: 12px;
line-height: 1.4;
color: #222222;
background-color: #fff;
}
legend {
display: block;
width: 100%;
padding: 0;
margin-bottom: 20px;
font-size: 20px;
color: #333333;
border: 0;
border-bottom: 1px solid #e5e5e5;
}
}
.logo {
position: absolute;
left: 0px;
top: -19px;
width: 165px;
height: 60px;
z-index: 5;
}
.tel {
font-size: 9px;
font-family: "Myriad Pro";
color: rgb(138, 138, 138);
line-height: 1.2;
text-align: left;
position: absolute;
left: 520px;
top: 15px;
z-index: 4;
}
.titulo {
font-size: 24px;
font-family: "Myriad Pro";
color: rgb(138, 138, 138);
line-height: 1.2;
text-align: left;
-moz-transform: matrix( 1.20826537009271,0,0,1.30665281638077,0,0);
-webkit-transform: matrix( 1.20826537009271,0,0,1.30665281638077,0,0);
-ms-transform: matrix( 1.20826537009271,0,0,1.30665281638077,0,0);
position: absolute;
left: 245.187px;
top: 13.756px;
z-index: 3;
}
.nomeCliente{
font-size: 15px;
color: rgb(138, 138, 138);
}
th{
text-align: center;
}
td{
text-align: center;
background: #fff;
}
</style>
</head>
<body>
<img src="../public/img/cabecalho.jpg" width="688" height="79">
<legend class="nomeCliente">Nome: ' . $clientes->nome . '</legend>
<legend class="nomeCliente">Nome: ';
echo $_POST['valorVoosPrincipais'];
$html .= '</legend>
<table class="table table-striped table-bordered" border="1px" cellspacing="0px">
<tr>
<th colspan="8">VOOS</th>
</tr>
<tr>
<th class="cod">ID</th>
<th class="nome">Voos</th>
<th class="pais">Pais</th>
<th class="cidade">Cidade</th>
<th>Data Ida</th>
<th>Data Volta</th>
<th>Local Embarque</th>
<th>Local Desembarque</th>
</tr>';
foreach ($clientes->voos as $v) {
if ($v->orcamento == 0) {
$html .= '
<tr>
<td>' . $v->id . '</td>
<td>' . $v->nome_voo . '</td>
<td>' . $v->cidades->codigo_pais . '</td>
<td>' . $v->cidades->nome . '</td>
<td>' . $v->data_ida . '</td>
<td>' . $v->data_volta . '</td>
<td>' . $v->hora_ida . '</td>
<td>' . $v->hora_volta . '</td>
</tr>';
}
}
'</table>';
$html .= '<table class="table table-striped table-bordered" border="1px" cellspacing="0px">
<tr>
<th colspan="7">TRENS</th>
</tr>
<tr>
<th class="cod">ID</th>
<th class="nome">Nome</th>
<th class="pais">Pais</th>
<th class="cidade">Cidade</th>
<th>Destino</th>
<th>Data Saída</th>
<th>Hora Ida</th>
</tr>';
foreach ($clientes->trens as $t) {
if ($t->orcamento == 0) {
$html .= '
<tr>
<td>' . $t->id . '</td>
<td>' . $t->nome . '</td>
<td>' . $t->cidades->codigo_pais . '</td>
<td>' . $t->cidades->nome . '</td>
<td>' . $t->destino . '</td>
<td>' . $t->data_saida . '</td>
<td>' . $t->hora_ida . '</td>
</tr>';
}
}
'</table>';
$html .= '<table class="table table-striped table-bordered" border="1px" cellspacing="0px">
<tr>
<th colspan="6">TRANSFERS</th>
</tr>
<tr>
<th class="cod">ID</th>
<th class="nome">Nome</th>
<th class="pais">Pais</th>
<th class="cidade">Cidade</th>
<th>Data Ida</th>
<th>Hora Ida</th>
</tr>';
foreach ($clientes->transfers as $transf) {
if ($transf->orcamento == 0) {
$html .= '
<tr>
<td>' . $transf->id . '</td>
<td>' . $transf->nome . '</td>
<td>' . $transf->cidades->codigo_pais . '</td>
<td>' . $transf->cidades->nome . '</td>
<td>' . $transf->data_ida . '</td>
<td>' . $transf->hora_ida . '</td>
</tr>';
}
}
'</table>';
$html .= '<table class="table table-striped table-bordered" border="1px" cellspacing="0px">
<tr>
<th colspan="8">HOSPEDAGENS</th>
</tr>
<tr>
<th class="cod">ID</th>
<th class="nome">Hotel</th>
<th class="pais">Pais</th>
<th class="cidade">Cidade</th>
<th>Checki in</th>
<th>Check out</th>
<th>Qtd. Adultos</th>
<th>Qtd. Crianças</th>
</tr>';
foreach ($clientes->hoteis as $h) {
if ($h->orcamento == 0) {
$html .= '
<tr>
<td>' . $h->id . '</td>
<td>' . $h->nome . '</td>
<td>' . $h->cidades->codigo_pais . '</td>
<td>' . $h->cidades->nome . '</td>
<td>' . $h->data_entrada . '</td>
<td>' . $h->data_saida . '</td>
<td>' . $h->qtd_adultos . '</td>
<td>' . $h->qtd_criancas . '</td>
</tr>';
}
}
'</table>';
$html .= '<table class="table table-striped table-bordered" border="1px" cellspacing="0px">
<tr>
<th colspan="7">PASSEIOS</th>
</tr>
<tr>
<th class="cod">ID</th>
<th class="nome">Nome</th>
<th class="pais">Pais</th>
<th class="cidade">Cidade</th>
<th>Empresa</th>
<th>Data Saída</th>
<th>Hora Ida</th>
</tr>';
foreach ($clientes->passeios as $p) {
if ($p->orcamento == 0) {
$html .= '
<tr>
<td>' . $p->id . '</td>
<td>' . $p->nome . '</td>
<td>' . $p->cidades->codigo_pais . '</td>
<td>' . $p->cidades->nome . '</td>
<td>' . $p->empresa_passeio . '</td>
<td>' . $p->data_ida . '</td>
<td>' . $p->hora_ida . '</td>
</tr>';
}
}
'</table>';
$html .= '
<div class ="row">
<div class="col-md-4 table-responsive">
<table class="table table-striped table-bordered" border="1px" cellspacing="0px">
<thead>
<tr>
<th colspan="2">Aereo</th>
<th>Valor</th>
</tr>
</thead>
<tbody>
<tr>
<td>
<input type="checkbox" id="2A" name="2A" value="Sim">
</td>
<td>2 Vezes</td>
<td><input name="valor6" id="valor6" class="text-center" readonly/></td>
</tr>
<tr>
<td>
<input type="checkbox" id="3A" name="3A" value="Sim">
</td>
<td>3 Vezes</td>
<td><input name="valor6" id="valor6" class="text-center" readonly/></td>
</tr>
<tr>
<td>
<input type="checkbox" id="5A" name="5A" value="Sim">
</td>
<td>5 Vezes</td>
<td><input name="valor6" id="valor6" class="text-center" readonly/></td>
</tr>
<tr>
<td>
<input type="checkbox" id="10A" name="10A" value="Sim">
</td>
<td>10 Vezes</td>
<td><input name="valor6" id="valor6" class="text-center" readonly/></td>
</tr>
<tr>
<td>
Total
</td>
<td id="valorAereo" colspan="2"><input name="valor6" id="valor6" class="text-center" readonly/></td>
</tr>
</tbody>
</table>
</div>
<div class="col-md-4">
<table class="table table-hover">
<thead>
<tr>
<th colspan="2">Pacote</th>
<th>Valor</th>
</tr>
</thead>
<tbody>
<tr>
<td>
<input type="checkbox" name="2P" id="2P" value="Sim">
</td>
<td>2 Vezes</td>
<td><input name="valor6" id="valor6" class="text-center" readonly/></td>
</tr>
<tr>
<td>
<input type="checkbox" name="3P" id="3P" value="Sim">
</td>
<td>3 Vezes</td>
<td><input name="valor6" id="valor6" class="text-center" readonly/></td>
</tr>
<tr>
<td>
<input type="checkbox" name="5P" id="5P" value="Sim">
</td>
<td>5 Vezes</td>
<td><input name="valor6" id="valor6" class="text-center" readonly/></td>
</tr>
<tr>
<td>
<input type="checkbox" name="6P" id="6P" value="Sim">
</td>
<td>6 Vezes</td>
<td><input name="valor6" id="valor6" class="text-center" readonly/></td>
</tr>
<tr>
<td>
Total
</td>
<td id="totalPaccote" colspan="2"><input name="valor6" id="valor6" class="text-center" readonly/></td>
</tr>
</tbody>
</table>
</div>
</div>';
$html .= '</body>';
$html .= '</html>';
$html .= '<script type="text/javascript">';
echo "function formatReal(mixed) {\n var int = parseInt(mixed.toFixed(2).toString().replace(/[^]+/g, ''));\n var tmp = int + '';\n tmp = tmp.replace(/([0-9]{2})\$/g, ", '$1' . ");\n\n if (tmp.length > 6)\n tmp = tmp.replace(/([0-9]{3}),([0-9]{2}\$)/g, " . '$1,$2' . ");\n\n return tmp;\n }";
echo "var valorTotal =" . $total;
echo "\$('input[name=valor]').val('R\$ '+formatReal(valorTotal));";
echo "\$('input[name=valor2]').val('R\$ '+formatReal(valorTotal / 2));";
echo "\$('input[name=valor3]').val('R\$ '+formatReal(valorTotal / 3));";
echo "\$('input[name=valor5]').val('R\$ '+formatReal(valorTotal / 5));";
echo "\$('input[name=valor6]').val('R\$ '+formatReal(valorTotal / 6));";
echo "alert('OK');";
$pdf->loadHTML($html);
return $pdf->stream();
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
Clientes::destroy($id);
Session::flash("mensaje", "Cliente eliminado correctamente!!");
return \Redirect::route('admin.cliente.index');
}
public function createRoteiroCliente(Roteiros $roteiro, $id)
{
$clientes = Clientes::find($id);
$roteiros = Roteiros::where('orcamento', '=', 1)->orderBy('nome')->lists('nome', 'id');
return view('roteiros.createRoteirosCliente', compact('clientes', 'roteiros'));
}
public function editVooOrcamento($id, $idCliente)
{
$voo = Voos::find($id);
$clientes = Clientes::find($idCliente);
return view('voos.editVooOrcamento', compact('voo', 'clientes'));
}
