eclass.unmer.ac.id

<div class="row wrapper border-bottom white-bg page-heading">
                <div class="col-sm-4">
                    <h2>Cadastro de Apólices</h2>
                    <ol class="breadcrumb">
                        <li>
                            <button data-toggle="modal" data-target="#ModalApolice" type="button"  class="btn btn-primary btn-sm">
                             <i class="fa fa-file-o"> </i> Nova apólice</button>
                        </li>
                    </ol>
                </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><?php echo $razao_cliente; ?></h5>
                            
                        </div>
                        <div class="ibox-content">
                            <div class="row m-b-sm m-t-sm">
                                <div class="col-md-1">
                                    <button type="button" id="loading-example-btn" class="btn btn-white btn-sm" ><i class="fa fa-refresh"></i> Refresh</button>
                                </div>
                                <div class="col-md-11">
                                    <div class="input-group"><input type="text" autofocus placeholder="Pesquisar" class="input-sm form-control" id="filter"> <span class="input-group-btn">
                                        <button type="button" class="btn btn-sm btn-primary"> <i class="fa fa-search"></i></button> </span></div>
                                </div>
                            </div>

<div class="project-list">
								<?php
								$query = "SELECT cw_apolice.id_apolice, cw_apolice.chave_apolice, cw_apolice.status_apolice, cw_apolice.ramo_apolice, cw_apolice.numero_apolice, cw_apolice.proposta_apolice, cw_apolice.vigencia_inical_apolice, cw_apolice.vigencia_final_apolice, cw_apolice.marca_automovel_apolice, cw_apolice.modelo_automovel_apolice, cw_apolice.cor_automovel_apolice, cw_apolice.ano_modelo_automovel_apolice, cw_apolice.ano_fabricacao_automovel_apolice, cw_apolice.placa_automovel_apolice, cw_seguradora.nome_seguradora FROM cw_apolice, cw_seguradora WHERE cw_apolice.seguradora_apolice=cw_seguradora.id_seguradora AND cw_apolice.empresa_apolice='$id'  ORDER BY cw_apolice.id_apolice DESC";
								$link   = DBConnect();
								$result = @mysqli_query($link, $query) or die(mysqli_error($link));
	
								?> 
                                <table class="footable table table-stripped" data-page-size="30" data-filter=#filter>
                                    <tbody>
                                    <?php
			 								while($res = mysqli_fetch_assoc($result)){ ?>
                                    <tr>
                                        <td class="project-status">
                                        
                                        	<?php if($res['status_apolice']=='0'){ ?>
                                            <span class="label label-primary">Novo</span>
                                            <?php }elseif($res['status_apolice']=='1'){ ?>
											<span class="label label-success">Renovação</span>
											<?php }elseif($res['status_apolice']=='2'){ ?>
											<span class="label label-info">Endossado</span>
                                            <?php }elseif($res['status_apolice']=='3'){ ?>
                                            <span class="label label-warning">Não renovado</span>
                                            <?php }elseif($res['status_apolice']=='4'){ ?>
                                            <span class="label label-danger">Cancelado</span>
                                            <?php } ?>
                                            
                                        </td>
                                        <td class="project-title">
                                            <a href="views/apolicedetails.php?id=<?php echo $res['id_apolice']; ?>">Vigência inical: <?php echo dbDateToDate2($res['vigencia_inical_apolice']); ?> | Vigência final: <?php echo dbDateToDate2($res['vigencia_final_apolice']); ?></a>
                                            <br/>
                                            
                                            <?php if($res['ramo_apolice']=='0'){ ?>
                                            <small>SEGURO: AUTOMOVÉL</small>
                                            <?php }elseif($res['ramo_apolice']=='1'){ ?>
                                            <small>SEGURO: RESIDÊNCIA</small>
                                            <?php }elseif($res['ramo_apolice']=='2'){ ?>
                                            <small>SEGURO: EMPRESÁRIAL</small>
                                            <?php }elseif($res['ramo_apolice']=='3'){ ?>
                                            <small>SEGURO: SAÚDE</small>
                                            <?php }elseif($res['ramo_apolice']=='4'){ ?>
                                            <small>SEGURO: VIDA</small>
                                            <?php }elseif($res['ramo_apolice']=='5'){ ?>
                                            <small>SEGURO: PREVIDÊNCIA</small>
                                            <?php } ?>
                                            
                                            
                                        </td>
                                        <td class="project-completion">
                                                <small><?php echo $res['nome_seguradora']; ?></small>
                                                
                                        </td>
                                        <td class="project-people">
                                        	
                                            <?php if($res['ramo_apolice']=='0'){ ?>
                                            <strong><?php echo $res['marca_automovel_apolice']; ?> <?php echo $res['modelo_automovel_apolice']; ?> <?php echo $res['ano_fabricacao_automovel_apolice']; ?> - Cor: <?php echo $res['cor_automovel_apolice']; ?> - Placa: <?php echo $res['placa_automovel_apolice']; ?></strong>
                                            
                                            <?php }elseif($res['ramo_apolice']=='1'){ ?>
                                            
                                            <?php }elseif($res['ramo_apolice']=='2'){ ?>
                                            
                                            <?php }elseif($res['ramo_apolice']=='3'){ ?>
                                            
                                            <?php }elseif($res['ramo_apolice']=='4'){ ?>
                                            
                                            <?php }elseif($res['ramo_apolice']=='5'){ ?>
                                            
                                            <?php } ?>
                                        
                                        
                                        </td>
                                        <td class="project-actions">
                                            <a href="views/apolicedetails.php?id=<?php echo $res['id_apolice']; ?>" class="btn btn-white btn-sm"><i class="fa fa-folder"></i> Visualizar </a>
                                        </td>
                                    </tr>
                                    
                                    <?php } ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>