E:
/
home
/
kbcomunicacao1
/
Web
/
innterage
/
views
/
Upload File
HOME
<?php session_start(); $sessao = session_id(); require '../includes/conexao/funcao.inc.php'; require '../includes/conexao/config.php'; require '../includes/conexao/conn.php'; require '../includes/conexao/function.php'; $queryconf = "SELECT * FROM cw_config WHERE id_config='1' LIMIT 1"; $resultconf = DBExecute($queryconf); $resconf = mysqli_fetch_assoc($resultconf); $link_config = $resconf['link_config']; $link_crm = $resconf['link_crm_config']; $assunto = $_POST['assunto']; $descricao = $_POST['descricao']; //FILTRO DE BAIXADOS OU ABERTOS $filtro = $_POST['filtro']; if($filtro=='2'){$filtrar = "AND status_cliente='0'";} elseif($filtro=='3'){$filtrar = "AND status_cliente='1'";} else{$filtrar='';} //FILTRO DE BAIXADOS OU ABERTOS $todos = "" . implode("','", $_POST['cliente']) . ""; //ARRAY QUEM SELECIONA OS ITENS DA CONTA if ($todos != 'todos') { $queryData = "'" . implode("','", $_POST['cliente']) . "'"; $cliente = " AND id_cliente IN($queryData)"; }else{ $cliente = ""; } //ARRAY QUEM SELECIONA OS ITENS DA CONTA //ARRAY QUEM SELECIONA OS ITENS DO PROJETO if (!empty($_POST['hashtags'])) { $queryData3 = "'" . implode("','", $_POST['hashtags']) . "'"; $hashtags = " AND nome_hashtags_cliente IN($queryData3)"; }else{ $hashtags = ""; } //ARRAY QUEM SELECIONA OS ITENS DO PROJETO $query = "SELECT * FROM cw_cliente, cw_setor, cw_hashtags_cliente WHERE id_cliente=cliente_setor AND id_cliente=cliente_hashtags_cliente $hashtags $cliente $filtrar GROUP BY razao_cliente, nome_setor"; $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>PRÉ VISUALIZAÇÃO DO ENVIO DE E-MAIL</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> <style type="text/css"> textarea{ visibility:hidden; } </style> </head> <body class="fixed-navigation"> <form role="form" name="enviainforme" method="post" action="../includes/enviainforme.php"> <div class="row wrapper border-bottom white-bg page-heading"> <div class="col-sm-6" style="margin-top: 10px"> <ol class="breadcrumb"> <li> <button type="submit" onClick="javascript:window.close();" class="btn btn-info btn-sm"><i class="fa fa-arrow-left"></i> Voltar</button> </li> <li> <button type="submit" class="btn btn-info btn-sm"><i class="fa fa-info-circle"></i> Enviar E-mail</button> </li> <li> <button data-toggle="modal" data-target="#edit-previsualizar" type="button" class="btn btn-info btn-sm"><i class="fa fa-eye"></i> Pré Visualisar</button> </li> </ol> </div> </div> <div class="row"> <input type="hidden" name="titulo" value="<?php echo $assunto; ?>"> <div class="col-lg-12"> <div class="wrapper wrapper-content animated fadeInUp"> <div class="ibox"> <div class="ibox-content"> <div class="project-list"> <table class="footable table table-stripped" data-page-size="10000" data-filter=#filter> <tr> <td> <div class="checkbox checkbox-success"> <input name='tudo' checked="checked" onclick='verificaStatus(this)' type="checkbox" /> <label for="TODOS"> <strong>TODOS</strong> </label> </div> </td> <td></td> <td></td> <td></td> <td></td> </tr> <tbody> <?php while($res = mysqli_fetch_assoc($result)){ if($res['email_setor'] != ''){ ?> <tr> <td> <div class="checkbox checkbox-success"> <input id="idsetor[]" checked="checked" value="<?php echo $res['id_setor']; ?>" name="idsetor[]" type="checkbox" /> <label for="<?php echo $res['razao_cliente']; ?>"> <?php echo $res['codigo_cliente']; ?> - <?php echo $res['razao_cliente']; ?> </label> </div> </td> <td class="client-status"> <?php if($res['status_cliente']==0){ ?> <span class="label label-primary">Ativo</span> <?php }else{ ?> <span class="label label-danger">Inativo</span> <?php } ?> </td> <td> <?php $querys = "SELECT nome_setores FROM cw_setores WHERE setor_setores = '$res[id_setor]' ORDER BY id_setores"; $links = DBConnect(); $results = @mysqli_query($links, $querys) or die(mysqli_error($links)); while($ress = mysqli_fetch_assoc($results)){ echo" <button type='button' class='btn btn-white' > $ress[nome_setores] </button>"; } ?> </td> <td> <?php echo $res['nome_setor']; ?> </td> <td> <?php echo $res['email_setor']; ?> </td> </tr> <?php }else{ ?> <tr style="color: red; font-weight: bold"> <td> <div class="checkbox checkbox-success"> <input id="idsetor[]" disabled="" type="checkbox" /> <label for="<?php echo $res['razao_cliente']; ?>"> <?php echo $res['codigo_cliente']; ?> - <?php echo $res['razao_cliente']; ?> </label> </div> </td> </td> <td class="client-status"> <?php if($res['status_cliente']==0){ ?> <span class="label label-primary">Ativo</span> <?php }else{ ?> <span class="label label-danger">Inativo</span> <?php } ?> </td> <td> <?php $querys = "SELECT nome_setores FROM cw_setores WHERE setor_setores = '$res[id_setor]' ORDER BY id_setores"; $links = DBConnect(); $results = @mysqli_query($links, $querys) or die(mysqli_error($links)); while($ress = mysqli_fetch_assoc($results)){ echo" <button type='button' class='btn btn-white' > $ress[nome_setores] </button>"; } ?> </td> <td> <?php echo $res['nome_setor']; ?> </td> <td> E-mail não cadastrado! </td> </tr> <?php } } ?> </tbody> </table> </div> </div> </div> </div> </div> <textarea name="descricao" cols="" rows=""><?php echo $descricao; ?></textarea> </form> </div> <div id="edit-previsualizar" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> × </button> <h3 class="modal-title-site text-center" > PRÉ-VISUALIZAR </h3> </div> <div class="modal-body edit-content"> <div class="form-group login-username col-lg-12"> <div class="col-sm-12"> <h3> <?php echo $assunto; ?> </h3> <p style="text-align: justify;"> <?php echo $descricao; ?> </p> <ul class="list-unstyled project-files"> <?php $queryanx = "SELECT * FROM cw_anexo WHERE chave_anexo='$sessao'"; $linkanx = DBConnect(); $resultanx = @mysqli_query($linkanx, $queryanx) or die(mysqli_error($linkanx)); ?> <?php while($resanx = mysqli_fetch_assoc($resultanx)){ ?> <li><a href='<?php echo $link_config; ?>/upload/uploads/baixar.php?arquivo=<?php echo $resanx['caminho_anexo']; ?>'><?php if(($resanx['tipo_anexo']=="jpg") || ($resanx['tipo_anexo']=="jpge") || ($resanx['tipo_anexo']=="JPG") || ($resanx['tipo_anexo']=="JPGE") || ($resanx['tipo_anexo']=="gif") || ($resanx['tipo_anexo']=="GIF") || ($resanx['tipo_anexo']=="png")){ ?> <i class="fa fa-file-image-o"></i><?php } elseif(($resanx['tipo_anexo']=="xls") || ($resanx['tipo_anexo']=="xlsx")){ ?><i class="fa fa-file-excel-o"></i><?php }elseif(($resanx['tipo_anexo']=="doc") || ($resanx['tipo_anexo']=="docx")){ ?><i class="fa fa-file-word-o"></i><?php }elseif($resanx['tipo_anexo']=="pdf"){ ?> <i class="fa fa-file-pdf-o"></i><?php }elseif($resanx['tipo_anexo']=="zip"){ ?><i class="fa fa-file-archive-o"></i> <?php }elseif(($resanx['tipo_anexo']=="jpg") || ($resanx['tipo_anexo']=="png")){ ?><i class="fa fa-file-image-o"></i><?php }else{ ?> <i class="fa fa-file-code-o"></i> <?php } ?> <?php echo $resanx['nomearquivo_anexo']; ?></a> </li> <?php } ?> </ul> </div> </div> </div> <div> <div> <input name="button" class="btn btn-block btn-lg btn-primary btnok" value="" type="button"> </div> </div> </form> </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> <script type="text/javascript"> function verificaStatus(nome){ if(nome.form.tudo.checked == 1) { nome.form.tudo.checked = 1; marcarTodos(nome); } else { nome.form.tudo.checked = 0; desmarcarTodos(nome); } } function marcarTodos(nome){ for (i=0;i<nome.form.elements.length;i++) if(nome.form.elements[i].type == "checkbox") nome.form.elements[i].checked=1 } function desmarcarTodos(nome){ for (i=0;i<nome.form.elements.length;i++) if(nome.form.elements[i].type == "checkbox") nome.form.elements[i].checked=0 } </script> </body> </html>