E:
/
home
/
kbcomunicacao1
/
Web
/
innterage
/
views
/
Upload File
HOME
<?php require '../includes/conexao/funcao.inc.php'; require '../includes/conexao/config.php'; require '../includes/conexao/conn.php'; require '../includes/conexao/function.php'; $de = $_POST['de']; $ate = $_POST['ate']; $data1 = DateTodbDate2($de); $data2 = DateTodbDate2($ate); $ordem = $_POST['ordem']; if($ordem=='Vencimento'){$ordenar = "vigencia_final_apolice";} elseif($ordem=='Emissão'){$ordenar = "vigencia_inical_apolice";} elseif($ordem=='Cliente'){$ordenar = "razao_cliente";} elseif($ordem=='Apolice'){$ordenar = "numero_apolice";} $query = "SELECT * FROM cw_apolice, cw_cliente, cw_seguradora WHERE cw_apolice.empresa_apolice=cw_cliente.id_cliente AND cw_apolice.seguradora_apolice=cw_seguradora.id_seguradora AND cw_apolice.vigencia_final_apolice>='$data1' and cw_apolice.vigencia_final_apolice<='$data2' ORDER BY $ordenar"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>RELATÓRIO DE APÓLICES</title> <link href="../midia/bootstrap/css/bootstrap.css" rel="stylesheet"> <link href="../midia/css/font-awesome.css" rel="stylesheet"> <link href="../midia/css/footable.core.css" rel="stylesheet"> <link href="../midia/css/awesome-bootstrap-checkbox.css" rel="stylesheet"> <link href="../midia/css/chosen.css" rel="stylesheet"> <link href="../midia/css/animate.css" rel="stylesheet"> <link href="../midia/css/datepicker.css" rel="stylesheet"> <link href="../midia/css/style.css" rel="stylesheet"> <script src="../midia/js/jquery.js"></script> </head> <body class="fixed-navigation"> <div class="row wrapper border-bottom white-bg page-heading"> <div class="col-sm-4"> <h2><i class="fa fa-clipboard"></i> RELATÓRIO DE APÓLICES</h2> </div> </div> <div class="row"> <div class="col-lg-12"> <div class="wrapper wrapper-content animated fadeInUp"> <div class="ibox"> <div class="ibox-title"> <h5>RELATÓRIO DE APÓLICES - VENCIMENTO - PERÍODO: <?php echo $de; ?> até: <?php echo $ate; ?></h5> </div> <div class="ibox-content"> <div> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <?php while($res = mysqli_fetch_assoc($result)){ ?> <tr> <td width="42%" style="border-top:1px solid #000; border-left:1px solid #000; padding:5px 0 0 5px">SEGURADO: <?php echo $res['razao_cliente']; ?></td> <td style="border-top:1px solid #000; padding:5px 0 0 5px">CPF/CNPJ: <?php echo $res['cnpj_cliente']; ?></td> <td style="border-top:1px solid #000; padding:5px 0 0 5px">ATV.: </td> <td width="22%" style="border-left:1px solid #000; border-right:1px solid #000; border-top:1px solid #000; padding-left:5px">RENOVAÇÃO: <span style="float:right; padding-right:5px"><?php echo dbDateToDate2($res['vigencia_final_apolice']); ?></span></td> </tr> <tr> <td colspan="2" style="border-left:1px solid #000; padding:5px 0 0 5px">ENDEREÇO: <?php echo $res['rua_cliente']; ?>, <?php echo $res['numero_cliente']; ?> <?php echo $res['complemento_cliente']; ?> </td> <td width="16%" style="padding:5px 0 0 5px">CEP: <?php echo $res['cep_cliente']; ?></td> <td style="border-left:1px solid #000; border-right:1px solid #000"> </td> </tr> <tr> <td style="border-left:1px solid #000; padding:5px">BAIRRO: <?php echo $res['bairro_cliente']; ?></td> <td style="padding:5px 0 0 5px">CIDADE: <?php echo $res['cidade_cliente']; ?></td> <td style="padding:5px 0 0 5px">UF: <?php echo $res['estado_cliente']; ?></td> <td style="border-left:1px solid #000; border-right:1px solid #000"> </td> </tr> <tr> <td colspan="3" style="border-left:1px solid #000; padding:5px 0 0 5px">TELEFONE: <?php echo $res['tipotelefone_cliente']; ?> - <?php echo $res['telefone_cliente']; ?></td> <td style="border-left:1px solid #000; border-right:1px solid #000"> </td> </tr> <tr> <td colspan="3" style="border-left:1px solid #000; padding:5px 0 0 5px">EMAIL: <?php echo $res['site_cliente']; ?></td> <td style="border-left:1px solid #000; border-right:1px solid #000"> </td> </tr> <tr> <td colspan="3" style="border-left:1px solid #000"> </td> <td style="border-left:1px solid #000; border-right:1px solid #000"> </td> </tr> <tr> <td colspan="3" bgcolor="#CCCCCC" style="border-bottom:1px solid #000; border-left:1px solid #000"><?php echo $res['numero_apolice']; ?> - <?php echo $res['marca_automovel_apolice']; ?> - <?php echo $res['modelo_automovel_apolice']; ?> - <?php echo $res['ano_fabricacao_automovel_apolice']; ?>/<?php echo $res['ano_modelo_automovel_apolice']; ?> - <?php echo $res['placa_automovel_apolice']; ?> - <?php echo $res['chassi_automovel_apolice']; ?> - <?php echo $res['renavam_automovel_apolice']; ?> - CIA: <?php echo $res['nome_seguradora']; ?></td> <td style="border-bottom:1px solid #000; border-left:1px solid #000; border-right:1px solid #000"> </td> </tr> <tr> <td colspan="4"> </td> </tr> <?php } ?> </table> </div> </div> </div> </div> </div> </div> <!-- Mainly scripts --> <script src="../midia/bootstrap/js/bootstrap.js"></script> <script src="../midia/js/jquery.metisMenu.js"></script> <script src="../midia/js/jquery.slimscroll.min.js"></script> <script src="../midia/js/jquery.maskedinput.min.js"></script> <script src="../midia/js/footable.all.min.js"></script> <script src="../midia/js/chosen.jquery.js"></script> <!-- Flot --> <script src="../midia/js/jquery.flot.js"></script> <script src="../midia/js/jquery.flot.tooltip.min.js"></script> <script src="../midia/js/jquery.flot.spline.js"></script> <script src="../midia/js/jquery.flot.resize.js"></script> <script src="../midia/js/jquery.flot.pie.js"></script> <script src="../midia/js/jquery.flot.symbol.js"></script> <script src="../midia/js/curvedLines.js"></script> <script src="../midia/js/site.js"></script> <!-- Peity --> <script src="../midia/js/jquery.peity.min.js"></script> <script src="../midia/js/peity-demo.js"></script> <!-- Custom and plugin javascript --> <script src="../midia/js/inspinia.js"></script> <script src="../midia/js/pace.min.js"></script> <!-- jQuery UI --> <script src="../midia/js/jquery-ui.min.js"></script> <!-- Jvectormap --> <script src="../midia/js/jquery-jvectormap-2.0.2.min.js"></script> <script src="../midia/js/jquery-jvectormap-world-mill-en.js"></script> <!-- Sparkline --> <script src="../midia/js/jquery.sparkline.min.js"></script> <!-- Sparkline demo data --> <script src="../midia/js/sparkline-demo.js"></script> <!-- Data picker --> <script src="../midia/js/datepicker.js"></script> <script type="text/javascript" src="../midia/js/jquery.easyui.min.js"></script> <script type="text/javascript" src="../midia/js/cadastro.js"></script> </body> </html>