<script> $(function(){ var formObject = $('#uploadFlw'); formObject.data('original_serialized_form', formObject.serialize()); $(':submit').click(function() { window.onbeforeunload = null; }); window.onbeforeunload = function() { if (formObject.data('original_serialized_form') !== formObject.serialize()) { return "AS MUDANÇAS DESTE FORMULÁRIO NÃO FORAM SALVAS"; } }; }); $("follows").scrollTop($("follows")[0].scrollHeight); </script> <?php $id = $_REQUEST['id']; $query = "SELECT cw_flw.id_flw, cw_flw.horaa_flw, cw_flw.prazo_flw, cw_flw.user_flw, cw_flw.chave_flw, cw_flw.status_flw, cw_flw.atualizacao_flw, cw_flw.descricao_flw, cw_flw.assunto_flw, cw_flw.data_flw, cw_flw.hora_flw, cw_flw.cliente_flw, cw_cliente.id_cliente, cw_cliente.razao_cliente, cw_cliente.fantasia_cliente, cw_user.nome_user, cw_user.sobrenome_user, cw_user.img_user, cw_user.id_user FROM cw_flw, cw_cliente, cw_user WHERE cw_flw.cliente_flw=cw_cliente.id_cliente AND cw_user.id_user=cw_flw.user_flw AND cw_flw.id_flw='$id'"; $result = DBExecute($query); $res = mysqli_fetch_assoc($result); $idcliente = $res['id_cliente']; $pinflw = $res['chave_flw']; $queryflw = "SELECT id_ocorrencia FROM cw_ocorrencia WHERE chave_ocorrencia='$res[chave_flw]' AND status_ocorrencia='0' OR chave_ocorrencia='$res[chave_flw]' AND status_ocorrencia='1'"; $linkflw = DBConnect(); $resultflw = @mysqli_query($linkflw, $queryflw) or die(mysqli_error($linkflw)); $rowflw = mysqli_num_rows($resultflw); $queryflw2 = "SELECT id_ocorrencia FROM cw_ocorrencia WHERE chave_ocorrencia='$res[chave_flw]' AND status_ocorrencia='1'"; $linkflw2 = DBConnect(); $resultflw2 = @mysqli_query($linkflw2, $queryflw2) or die(mysqli_error($linkflw2)); $rowflw2 = mysqli_num_rows($resultflw2); if($rowflw>0){ $statisticas = (100-(($rowflw-$rowflw2)*100)/$rowflw); }else{ $statisticas = 0; } ?> <div class="row wrapper border-bottom white-bg page-heading"> <div class="col-sm-4"> <h2>Solicitações</h2> <ol class="breadcrumb"> <li> <?php if($rowflw==0){ ?> <button data-toggle="modal" data-target="#ModalLogin" type="button" class="btn btn-primary btn-sm"> <i class="fa fa-file-o"> </i> Nova ocorrência</button> <?php }elseif($res['status_flw']!=0){ ?> <button onclick="alert('ATENÇÃO! Solicitação encerrada!');" type="button" class="btn btn-primary btn-sm"> <i class="fa fa-file-o"> </i> Nova ocorrência</button> <?php }else{ ?> <button data-toggle="modal" data-target="#ModalLogin" type="button" class="btn btn-primary btn-sm"> <i class="fa fa-file-o"> </i> Nova ocorrência</button> <?php } ?> <a target="_blank" href="./?pag=cliente&id=<?php echo $res['id_cliente']; ?>" style="color:#FFF" class="btn btn-info btn-sm" title="Clientes" style="margin-left:45px" > <i class="fa fa-suitcase"></i> Clientes</a> </li> </ol> </div> </div> <div class="row" id="follows"> <form role="form" name="uploadFlw" method="post" id="uploadFlw" enctype="multipart/form-data" action="includes/uploadFlw.php"> <input type="hidden" name="id" id="id" value="<?php echo $res['id_flw']; ?>" /> <input type="hidden" name="chave" id="chave" value="<?php echo $res['chave_flw']; ?>" /> <div class="col-lg-9"> <div class="wrapper wrapper-content animated fadeInUp"> <div class="ibox"> <div class="ibox-content"> <div class="row"> <button type="submit" class="btn btn-primary btn-sm pull-right"> <i class="fa fa-save"> </i> Salvar</button> <div class="col-lg-12"> <div class="form-group col-lg-12"> <div class="col-lg-6"> <?php $queryc = "SELECT * FROM cw_cliente ORDER BY razao_cliente"; $linkc = DBConnect(); $resultc = @mysqli_query($linkc, $queryc) or die(mysqli_error($linkc)); ?> <label>Empresa: </label> <select data-placeholder="Selecione a empresa" name="empresa" class="chosen-select2 form-control" tabindex="2"> <option value="<?php echo $res['id_cliente']; ?>"><?php echo $res['razao_cliente']; ?></option> <option value="">Selecione</option> <?php while($resc = mysqli_fetch_assoc($resultc)){ ?> <option value="<?php echo $resc['id_cliente']; ?>"><?php echo $resc['razao_cliente']; ?></option> <?php } ?> </select> </div> <div class="col-lg-6"> <label>Assunto: </label> <input type="text" name="assunto" value="<?php echo $res['assunto_flw']; ?>" class="form-control" placeholder="Digite o assunto" required=""> </div> </div> </div> </div> <dl class="dl-horizontal"> <?php if($res['status_flw']==0){ ?> <dt>Status:</dt> <dd><span class="label label-primary">Ativo</span></dd> <?php }else{ ?> <dt>Status:</dt> <dd><span class="label label-default">Encerrado</span></dd> <?php } ?> </dl> <div class="row"> <div class="form-group col-lg-12"> <div class="col-lg-5"> <dl class="dl-horizontal"> <dt>Número da Solicitação:</dt> <dd> <?php echo $res['id_flw']; ?></dd> <dt>Criado por:</dt> <dd><?php echo $res['nome_user']; ?> <?php echo $res['sobrenome_user']; ?></dd> <dt>Prazo:</dt> <dd><a href="#" data-toggle="modal" data-target="#ModalPrazo" ><?php echo dbDateToDate2($res['prazo_flw']); ?></a></dd> <?php $querypz = "SELECT data_prazo FROM cw_prazo WHERE flw_prazo='$id' ORDER BY data_prazo DESC"; $linkpz = DBConnect(); $resultpz = @mysqli_query($linkpz, $querypz) or die(mysqli_error($linkpz)); ?> <?php while($respz = mysqli_fetch_assoc($resultpz)){ ?> <dd><?php echo dbDateToDate2($respz['data_prazo']); ?></dd> <?php } ?> </dl> </div> <div class="col-lg-7" id="cluster_info"> <dl class="dl-horizontal" > <dt>Última atualização:</dt> <dd><?php echo dbDateToDate2($res['atualizacao_flw']); ?> às <?php echo $res['horaa_flw']; ?></dd> <dt>Criado em:</dt> <dd> <?php echo dbDateToDate2($res['data_flw']); ?> às <?php echo $res['hora_flw']; ?> </dd> <dt>Participantes: </dt> <dd class="project-people"> <?php $querypa = "SELECT cw_user.nome_user, cw_user.sobrenome_user, cw_user.img_user FROM cw_ocorrencia, cw_user WHERE cw_ocorrencia.para_ocorrencia=cw_user.id_user AND cw_ocorrencia.chave_ocorrencia='$res[chave_flw]' AND cw_ocorrencia.para_ocorrencia-$res[id_user] GROUP BY cw_user.id_user"; $linkpa = DBConnect(); $resultpa = @mysqli_query($linkpa, $querypa) or die(mysqli_error($linkpa)); ?> <?php if($res['img_user']==""){ ?> <img alt="image" src="midia/img/profile_small.jpg" class="img-circle" title="<?php echo $res['nome_user']; ?> <?php echo $res['sobrenome_user']; ?>" /> <?php }else{ ?> <img alt="image" class="img-circle" src="img-perfil/img/perfil/<?php echo $res['img_user']; ?>" title="<?php echo $res['nome_user']; ?> <?php echo $res['sobrenome_user']; ?>"> <?php } ?> <?php while($respa = mysqli_fetch_assoc($resultpa)){ ?> <?php if($respa['img_user']==""){ ?> <img alt="image" src="midia/img/profile_small.jpg" class="img-circle" title="<?php echo $respa['nome_user']; ?> <?php echo $respa['sobrenome_user']; ?>" /> <?php }else{ ?> <img alt="image" class="img-circle" src="img-perfil/img/perfil/<?php echo $respa['img_user']; ?>" title="<?php echo $respa['nome_user']; ?> <?php echo $respa['sobrenome_user']; ?>"> <?php } ?> <?php } ?> </dd> </dl> </div> </div> </div> <div class="row"> <div class="col-lg-12"> <dl class=""> <dd> <div class="progress progress-striped active m-b-sm"> <div style="width: <?php echo $statisticas; ?>%;" class="progress-bar"></div> </div> <small>Solicitação completa em: <strong><?php echo formataValor2($statisticas); ?>%</strong></small> </dd> </dl> </div> </div> <div class="row m-t-sm"> <div class="col-lg-12"> <div class="panel blank-panel"> <div class="panel-heading"> <div class="panel-options"> <ul class="nav nav-tabs"> <li class="active"><a href="#tab-1" data-toggle="tab">Todas ocorrências</a></li> <li > <a href="#tab-2" data-toggle="tab">Ocorrências encerradas</a></li> </ul> </div> </div> <div class="panel-body"> <div class="tab-content"> <div class="tab-pane active" id="tab-1"> <div class="feed-activity-list"> <?php $queryo = "SELECT cw_ocorrencia.id_ocorrencia, cw_ocorrencia.cautor_ocorrencia, cw_ocorrencia.termino_ocorrencia, cw_ocorrencia.data_lido_ocorrencia, cw_ocorrencia.hora_lido_ocorrencia, cw_ocorrencia.horaco_ocorrencia, cw_ocorrencia.email_destino_ocorrencia, cw_ocorrencia.destino_ocorrencia, cw_ocorrencia.status_ocorrencia, cw_ocorrencia.para_ocorrencia, cw_ocorrencia.chave_ocorrencia, cw_ocorrencia.leitura_ocorrencia, cw_ocorrencia.de_ocorrencia, cw_ocorrencia.para_ocorrencia, cw_ocorrencia.chave_leitura_ocorrencia, cw_ocorrencia.criacao_ocorrencia, cw_ocorrencia.tipo_ocorrencia, cw_ocorrencia.horac_ocorrencia, cw_ocorrencia.assunto_ocorrencia, cw_ocorrencia.descricao_ocorrencia, cw_user.nome_user, cw_user.sobrenome_user, cw_user.img_user, cw_ocorrencia.copia_ocorrencia FROM cw_ocorrencia, cw_user WHERE cw_ocorrencia.de_ocorrencia=cw_user.id_user AND cw_ocorrencia.chave_ocorrencia='$res[chave_flw]' AND cw_ocorrencia.status_ocorrencia=0"; $linko = DBConnect(); $resulto = @mysqli_query($linko, $queryo) or die(mysqli_error($linko)); ?> <?php while($reso = mysqli_fetch_assoc($resulto)){ ?> <h6 lang='<?php echo $id; ?>'></h6> <?php if(($reso['de_ocorrencia']==$_SESSION['IDCLI']) || ($reso['para_ocorrencia']==$_SESSION['IDCLI']) || ($reso['cautor_ocorrencia']==$_SESSION['IDCLI']) ){ ?> <!-- LISTA DE FLW--> <div class="feed-element" id="<?php echo $reso['id_ocorrencia']; ?>"> <?php if($reso['img_user']==""){ ?> <a href="#" class="pull-left"><img alt="image" src="midia/img/profile_small.jpg" class="img-circle" title="<?php echo $reso['nome_user']; ?> <?php echo $reso['sobrenome_user']; ?>" /></a> <?php }else{ ?> <a href="#" class="pull-left"><img alt="image" class="img-circle" src="img-perfil/img/perfil/<?php echo $reso['img_user']; ?>" title="<?php echo $reso['nome_user']; ?> <?php echo $reso['sobrenome_user']; ?>"></a> <?php } ?> <div class="media-body "> <?php $datas = dbDateToDate2($reso['criacao_ocorrencia']); $data = DateTodbDate2($datas); ?> <small class="pull-right"><?php echo dataextenso($data); ?></small> <?php $queryuser = "SELECT nome_user, sobrenome_user FROM cw_user WHERE id_user='$reso[para_ocorrencia]'"; $resultuser = DBExecute($queryuser); $resuser = mysqli_fetch_assoc($resultuser); ?> <span style="font-size:14px"><strong><?php echo $reso['nome_user']; ?> <?php echo $reso['sobrenome_user']; ?></strong> para: <?php if($reso['para_ocorrencia']!=0){ ?> <strong><?php echo $resuser['nome_user']; ?> <?php echo $resuser['sobrenome_user']; ?></strong> <?php }else{ ?> <strong><?php echo $reso['destino_ocorrencia']; ?></strong> <?php } ?> </span><br> <small class="text-muted">Ás <?php echo $reso['horac_ocorrencia']; ?> - <?php echo dbDateToDate2($reso['criacao_ocorrencia']); ?> / <strong>Prazo: <?php echo dbDateToDate2($reso['termino_ocorrencia']); ?> às <?php echo $reso['horaco_ocorrencia']; ?></strong> <?php if($reso['cautor_ocorrencia']==$_SESSION['IDCLI']){echo"**Em cópia**";}else{} ?></small><br /> <!--descrição gerel ocorrencia--> <div class="form-group login-username col-lg-12"> <div class="well col-lg-11" style="font-size:12px"> <?php if($reso['leitura_ocorrencia']=='1'){?> <span style="float:left; margin-left:-15px; margin-top:-10px; color:#00F"> <i class="fa fa-check"></i> <small class="text-muted">Lido em <?php echo dbDateToDate2($reso['data_lido_ocorrencia']); ?> às <?php echo $reso['hora_lido_ocorrencia']; ?></small> </span> <br /> <?php }else{ } ?> <?php if($reso['copia_ocorrencia']=='1'){ ?> <p style="color:#F00">***CLIENTE EM CÓPIA***</p> <?php }else{} ?> <?php echo $reso['descricao_ocorrencia']; ?><br /><br /> <?php $queryanx = "SELECT * FROM cw_anexo WHERE ocorrencia_anexo='$reso[chave_leitura_ocorrencia]'"; $linkanx = DBConnect(); $resultanx = @mysqli_query($linkanx, $queryanx) or die(mysqli_error($linkanx)); $rowanx = mysqli_num_rows($resultanx); if($rowanx>0){echo"<fieldset><legend style='font-size:14px'><i class='fa fa-arrow-circle-down'></i> ARQUIVO(S) EM ANEXO </legend></fieldset>";}else{} ?> <?php while($resanx = mysqli_fetch_assoc($resultanx)){ ?> <li style="list-style:none"><a href="upload/uploads/baixar.php?arquivo=<?php echo $resanx['caminho_anexo']; ?>"><?php if(($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 } ?> </div> <?php $queryr = "SELECT * FROM cw_resposta WHERE chave_resposta='$reso[id_ocorrencia]'"; $linkr = DBConnect(); $resultr = @mysqli_query($linkr, $queryr) or die(mysqli_error($linkr)); ?> <?php while($resr = mysqli_fetch_assoc($resultr)){ ?> <?php $queryresp = "SELECT nome_user, sobrenome_user, img_user FROM cw_user WHERE id_user='$resr[de_resposta]'"; $resultresp = DBExecute($queryresp); $resresp = mysqli_fetch_assoc($resultresp); ?> <!--Resposta ocorrencia--> <div class="pull-right col-lg-11" style="margin-top:5px;"> <a href="#" class="pull-left" style="padding-right:5px;"> <?php if($resresp['img_user']==""){ ?> <a href="#" class="pull-left"><img alt="image" src="midia/img/profile_small.jpg" class="img-circle" title="<?php echo $resresp['nome_user']; ?> <?php echo $resresp['sobrenome_user']; ?>" /></a> <?php }else{ ?> <a href="#" class="pull-left"><img alt="image" class="img-circle" src="img-perfil/img/perfil/<?php echo $resresp['img_user']; ?>" title="<?php echo $resresp['nome_user']; ?> <?php echo $resresp['sobrenome_user']; ?>"></a> <?php } ?> </a> <?php $datas = dbDateToDate2($resr['criacao_resposta']); $data = DateTodbDate2($datas); ?> <small class="pull-right"><?php echo dataextenso($data); ?></small> <strong> <?php echo $resr['tipo_resposta']; ?> <?php echo $resresp['nome_user']; ?> <?php echo $resresp['sobrenome_user']; ?> </strong> respondeu a ocorrência <br> <small class="text-muted">Ás <?php echo $resr['horac_resposta']; ?> - <?php echo dbDateToDate2($resr['criacao_resposta']); ?></small> </div> <div class="well pull-right col-lg-11" style="font-size:12px"> <?php if($resr['lido_resposta']=='1'){?> <span style="float:left; margin-left:-15px; margin-top:-10px; color:#00F"> <i class="fa fa-check"></i> <small class="text-muted">Lido em <?php echo dbDateToDate2($resr['data_lido_resposta']); ?> às <?php echo $resr['hora_lido_resposta']; ?></small> </span> <br /> <?php }else{ } ?> <?php echo $resr['descricao_resposta']; ?><br /><br /> <?php $queryanxrr = "SELECT * FROM cw_anexo WHERE ocorrencia_anexo='$resr[caminho_resposta]'"; $linkanxrr = DBConnect(); $resultanxrr = @mysqli_query($linkanxrr, $queryanxrr) or die(mysqli_error($linkanxrr)); $rowanxrr = mysqli_num_rows($resultanxrr); if($rowanxrr>0){echo"<fieldset><legend style='font-size:14px'><i class='fa fa-arrow-circle-down'></i> ARQUIVO(S) EM ANEXO </legend></fieldset>";}else{} ?> <?php while($resanxrr = mysqli_fetch_assoc($resultanxrr)){ ?> <li style="list-style:none"><a href="upload/uploads/baixar.php?arquivo=<?php echo $resanxrr['caminho_anexo']; ?>"><?php if(($resanxrr['tipo_anexo']=="xls") || ($resanxrr['tipo_anexo']=="xlsx")){ ?><i class="fa fa-file-excel-o"></i><?php }elseif(($resanxrr['tipo_anexo']=="doc") || ($resanxrr['tipo_anexo']=="docx")){ ?><i class="fa fa-file-word-o"></i><?php }elseif($resanxrr['tipo_anexo']=="pdf"){ ?> <i class="fa fa-file-pdf-o"></i><?php }elseif($resanxrr['tipo_anexo']=="zip"){ ?><i class="fa fa-file-archive-o"></i> <?php }elseif(($resanxrr['tipo_anexo']=="jpg") || ($resanxrr['tipo_anexo']=="png")){ ?><i class="fa fa-file-image-o"></i><?php }else{ ?> <i class="fa fa-file-code-o"></i> <?php } ?> <?php echo $resanxrr['nomearquivo_anexo']; ?></a></li> <?php } ?> </div> <!--Resposta ocorrencia--> <?php } ?> </div> <!--descrição gerel ocorrencia--> <div class="actions"> <?php if($reso['status_ocorrencia']==0){ ?> <?php if(($reso['para_ocorrencia']==$_SESSION['IDCLI']) || ($reso['de_ocorrencia']==$_SESSION['IDCLI'])){ ?> <a href="#" title="Encerrar ocorrência" id="<?php echo $reso['id_ocorrencia']; ?>" class="btn btn-xs btn-white encerraocorrencia" ><i class="fa fa-check-square-o"></i>Encerrar</a> <?php }else{ ?><a href="#" onclick="alert('ACESSO NEGADO \nCONTACTE O ADMINISTRADOR');" title="Encerrar ocorrência" class="btn btn-xs btn-white" ><i class="fa fa-check-square-o"></i>Encerrar</a><?php } ?> <?php }else{ ?> <a class="btn btn-xs btn-white"><i class="fa fa-check-square-o"></i>Encerrado</a> <?php } ?> <a href="#" onclick="<?php if(($reso['para_ocorrencia']==$_SESSION['IDCLI']) || ($reso['de_ocorrencia']==$_SESSION['IDCLI']) || ($reso['cautor_ocorrencia']==$_SESSION['IDCLI'])){ ?> window.open('views/resposta.php?id=<?php echo $reso['id_ocorrencia']; ?>&de=<?php echo $reso['de_ocorrencia']; ?>&idflw=<?php echo $id; ?>&para=<?php echo $reso['para_ocorrencia']; ?>&tipo=0&email=<?php echo $reso['email_destino_ocorrencia']; ?>&pin=<?php echo $pinflw; ?>&copia=<?php echo $reso['copia_ocorrencia']; ?>&tipoa=<?php echo $reso['tipo_ocorrencia']; ?>&prazo=<?php echo dbDateToDate2($reso['termino_ocorrencia']); ?>&hora=<?php echo $reso['horaco_ocorrencia']; ?>', 'responder', 'STATUS=NO, TOOLBAR=NO, LOCATION=NO, DIRECTORIES=NO, RESISABLE=NO, SCROLLBARS=NO, TOP=80, LEFT=300, WIDTH=730, HEIGHT=580'); <?php }else{ ?> javascript:alert('ACESSO NEGADO \nCONTACTE O ADMINISTRADOR') <?php } ?>" class="btn btn-xs btn-white"><i class="fa fa-share"></i> Responder</a> </div> </div> </div> <!-- LISTA DE FLW--> <?php }else{} ?> <?php } ?> </div> </div> <div class="tab-pane" id="tab-2"> <div class="feed-activity-list"> <?php $queryo = "SELECT cw_ocorrencia.id_ocorrencia, cw_ocorrencia.leitura_ocorrencia, cw_ocorrencia.data_lido_ocorrencia, cw_ocorrencia.hora_lido_ocorrencia, cw_ocorrencia.status_ocorrencia, cw_ocorrencia.para_ocorrencia, cw_ocorrencia.chave_ocorrencia, cw_ocorrencia.de_ocorrencia, cw_ocorrencia.para_ocorrencia, cw_ocorrencia.criacao_ocorrencia, cw_ocorrencia.tipo_ocorrencia, cw_ocorrencia.horac_ocorrencia, cw_ocorrencia.assunto_ocorrencia, cw_ocorrencia.descricao_ocorrencia, cw_ocorrencia.chave_leitura_ocorrencia, cw_user.nome_user, cw_user.sobrenome_user, cw_user.img_user FROM cw_ocorrencia, cw_user WHERE cw_ocorrencia.de_ocorrencia=cw_user.id_user AND cw_ocorrencia.chave_ocorrencia='$res[chave_flw]' AND cw_ocorrencia.status_ocorrencia=1"; $linko = DBConnect(); $resulto = @mysqli_query($linko, $queryo) or die(mysqli_error($linko)); ?> <?php while($reso = mysqli_fetch_assoc($resulto)){ ?> <?php if(($reso['de_ocorrencia']==$_SESSION['IDCLI']) || ($reso['para_ocorrencia']==$_SESSION['IDCLI'])){ ?> <!-- LISTA DE FLW--> <div class="feed-element" id="<?php echo $reso['id_ocorrencia']; ?>"> <?php if($reso['img_user']==""){ ?> <a href="#" class="pull-left"><img alt="image" src="midia/img/profile_small.jpg" class="img-circle" title="<?php echo $reso['nome_user']; ?> <?php echo $reso['sobrenome_user']; ?>" /></a> <?php }else{ ?> <a href="#" class="pull-left"><img alt="image" class="img-circle" src="img-perfil/img/perfil/<?php echo $reso['img_user']; ?>" title="<?php echo $reso['nome_user']; ?> <?php echo $reso['sobrenome_user']; ?>"></a> <?php } ?> <div class="media-body "> <?php $datas = dbDateToDate2($reso['criacao_ocorrencia']); $data = DateTodbDate2($datas); ?> <small class="pull-right"><?php echo dataextenso($data); ?></small> <?php $queryuser = "SELECT nome_user, sobrenome_user FROM cw_user WHERE id_user='$reso[para_ocorrencia]'"; $resultuser = DBExecute($queryuser); $resuser = mysqli_fetch_assoc($resultuser); ?> <span style="font-size:14px"><strong><?php echo $reso['nome_user']; ?> <?php echo $reso['sobrenome_user']; ?></strong> criou uma ocorrência para <strong><?php echo $resuser['nome_user']; ?> <?php echo $resuser['sobrenome_user']; ?></strong></span><br> <small class="text-muted">Ás <?php echo $reso['horac_ocorrencia']; ?> - <?php echo dbDateToDate2($reso['criacao_ocorrencia']); ?></small> <!--descrição gerel ocorrencia--> <div class="form-group login-username col-lg-12"> <div class="well col-lg-12" style="font-size:12px"> <?php if($reso['leitura_ocorrencia']=='1'){?> <span style="float:left; margin-left:-15px; margin-top:-10px; color:#00F"> <i class="fa fa-check"></i> <small class="text-muted">Lido em <?php echo dbDateToDate2($reso['data_lido_ocorrencia']); ?> às <?php echo $reso['hora_lido_ocorrencia']; ?></small> </span> <br /> <?php }else{ } ?> <?php echo $reso['descricao_ocorrencia']; ?><br /><br /> <?php $queryanx = "SELECT * FROM cw_anexo WHERE ocorrencia_anexo='$reso[chave_leitura_ocorrencia]'"; $linkanx = DBConnect(); $resultanx = @mysqli_query($linkanx, $queryanx) or die(mysqli_error($linkanx)); $rowanx = mysqli_num_rows($resultanx); if($rowanx>0){echo"<fieldset><legend style='font-size:14px'><i class='fa fa-arrow-circle-down'></i> ARQUIVO(S) EM ANEXO </legend></fieldset>";}else{} ?> <?php while($resanx = mysqli_fetch_assoc($resultanx)){ ?> <li style="list-style:none"><a href="upload/uploads/baixar.php?arquivo=<?php echo $resanx['caminho_anexo']; ?>"><?php if(($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 } ?> </div> <?php $queryr = "SELECT * FROM cw_resposta WHERE chave_resposta='$reso[id_ocorrencia]'"; $linkr = DBConnect(); $resultr = @mysqli_query($linkr, $queryr) or die(mysqli_error($linkr)); ?> <?php while($resr = mysqli_fetch_assoc($resultr)){ ?> <?php $queryresp = "SELECT nome_user, sobrenome_user, img_user FROM cw_user WHERE id_user='$resr[de_resposta]'"; $resultresp = DBExecute($queryresp); $resresp = mysqli_fetch_assoc($resultresp); ?> <!--Resposta ocorrencia--> <div class="pull-right col-lg-11" style="margin-top:5px;"> <a href="#" class="pull-left" style="padding-right:5px;"> <?php if($resresp['img_user']==""){ ?> <a href="#" class="pull-left"><img alt="image" src="midia/img/profile_small.jpg" class="img-circle" title="<?php echo $resresp['nome_user']; ?> <?php echo $resresp['sobrenome_user']; ?>" /></a> <?php }else{ ?> <a href="#" class="pull-left"><img alt="image" class="img-circle" src="img-perfil/img/perfil/<?php echo $resresp['img_user']; ?>" title="<?php echo $resresp['nome_user']; ?> <?php echo $resresp['sobrenome_user']; ?>"></a> <?php } ?> </a> <?php $datas = dbDateToDate2($resr['criacao_resposta']); $data = DateTodbDate2($datas); ?> <small class="pull-right"><?php echo dataextenso($data); ?></small> <strong> <?php echo $resr['tipo_resposta']; ?> <?php echo $resresp['nome_user']; ?> <?php echo $resresp['sobrenome_user']; ?> </strong> respondeu a ocorrência <br> <small class="text-muted">Ás <?php echo $resr['horac_resposta']; ?> - <?php echo dbDateToDate2($resr['criacao_resposta']); ?></small> </div> <div class="well pull-right col-lg-11" style="font-size:12px"> <?php if($resr['lido_resposta']=='1'){?> <span style="float:left; margin-left:-15px; margin-top:-10px; color:#00F"> <i class="fa fa-check"></i> <small class="text-muted">Lido em <?php echo dbDateToDate2($resr['data_lido_resposta']); ?> às <?php echo $resr['hora_lido_resposta']; ?></small> </span> <br /> <?php }else{ } ?> <?php echo $resr['descricao_resposta']; ?> </div> <!--Resposta ocorrencia--> <?php } ?> </div> <!--descrição gerel ocorrencia--> <div class="actions"> <?php if($reso['status_ocorrencia']==0){ ?> <a href="#" title="Encerrar ocorrência" onclick="<?php if(($reso['para_ocorrencia']==$_SESSION['IDCLI']) || ($reso['de_ocorrencia']==$_SESSION['IDCLI'])){ ?> if (!confirm('Tem certeza que deseja encerrar??')) return false; window.open('includes/encerraocorrencia.php?id=<?php echo $reso['id_ocorrencia']; ?>&flw=<?php echo $id; ?>', 'encerraocorrencia', 'STATUS=NO, TOOLBAR=NO, LOCATION=NO, DIRECTORIES=NO, RESISABLE=NO, SCROLLBARS=YES, TOP=150, LEFT=1, WIDTH=1, HEIGHT=1');<?php }else{ ?>javascript:alert('ACESSO NEGADO \nCONTACTE O ADMINISTRADOR')<?php } ?>" class="btn btn-xs btn-white"><i class="fa fa-check-square-o"></i>Encerrar</a><?php }else{ ?> <a class="btn btn-xs btn-white"><i class="fa fa-check-square-o"></i>Encerrado</a> <?php } ?> <?php if($reso['status_ocorrencia']==0){ ?> <a href="#" onclick="<?php if(($reso['para_ocorrencia']==$_SESSION['IDCLI']) || ($reso['de_ocorrencia']==$_SESSION['IDCLI'])){ ?> window.open('views/resposta.php?id=<?php echo $reso['id_ocorrencia']; ?>&de=<?php echo $reso['de_ocorrencia']; ?>&idflw=<?php echo $id; ?>&para=<?php echo $reso['para_ocorrencia']; ?>', 'responder', 'STATUS=NO, TOOLBAR=NO, LOCATION=NO, DIRECTORIES=NO, RESISABLE=NO, SCROLLBARS=NO, TOP=200, LEFT=250, WIDTH=670, HEIGHT=280'); <?php }else{ ?> javascript:alert('ACESSO NEGADO \nCONTACTE O ADMINISTRADOR') <?php } ?>" class="btn btn-xs btn-white"><i class="fa fa-share"></i> Responder</a><?php }else{ ?> <a class="btn btn-xs btn-white"><i class="fa fa-share"></i> Responder</a> <?php } ?> </div> </div> </div> <!-- LISTA DE FLW--> <?php }else{} ?> <?php } ?> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> </div> <div class="col-lg-3"> <div class="wrapper wrapper-content project-manager"> <h4>Descrição da solicitação</h4> <textarea class="form-control" name="descricao" rows="8"><?php echo $res['descricao_flw']; ?></textarea> </form> <h5>Arquivos anexos</h5> <ul class="list-unstyled project-files"> <?php $queryanx = "SELECT * FROM cw_anexo WHERE chave_anexo='$res[chave_flw]'"; $linkanx = DBConnect(); $resultanx = @mysqli_query($linkanx, $queryanx) or die(mysqli_error($linkanx)); ?> <?php while($resanx = mysqli_fetch_assoc($resultanx)){ ?> <li><a href="upload/uploads/baixar.php?arquivo=<?php echo $resanx['caminho_anexo']; ?>"><?php if(($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 class="text-center m-t-md"> <a title="Encerrar solicitação" <?php if(($res['user_flw']==$_SESSION['IDCLI']) && ($statisticas=='100') || ($res['user_flw']==$_SESSION['IDCLI']) && ($statisticas=='0')){ ?> href="includes/encerraflw.php?id=<?php echo $id; ?>&chave=<?php echo $pinflw; ?>" onClick="return confirm('Tem certeza que deseja encerrar??')" <?php }else{ ?> onClick="javascript:alert('ACESSO NEGADO \nCONTACTE O AUTOR DA SOLICITAÇÃO')"<?php } ?> class="btn btn-xs btn-primary">Encerrar Solicitação</a> <a href="#" onclick="window.open('upload/anexo2.php?chave=<?php echo $res['chave_flw']; ?>&dest=0', 'uploadanexo', 'STATUS=NO, TOOLBAR=NO, LOCATION=NO, DIRECTORIES=NO, RESISABLE=NO, SCROLLBARS=NO, TOP=120, LEFT=350, WIDTH=630, HEIGHT=500'); " class="btn btn-xs btn-primary"> Anexar Arquivos </a> </div> </div> </div> </div> <!-- MODAL DE CADASTRO DE USER --> <!-- Modal Login start --> <div class="modal signUpContent fade" id="ModalLogin" tabindex="-1" role="dialog" > <script type="text/javascript"> function atualizarnumanexos() { var url="includes/numanexos2.php"; jQuery("#numanexos").load(url); } setInterval("atualizarnumanexos()", 2000); </script> <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> &times; </button> <h3 class="modal-title-site text-center" > CADASTRO DE OCORRÊNCIA</h3> </div> <div class="modal-body"> <div class="form-group login-username col-lg-12"> <div class="col-lg-12"> <div id="corpotodo"></div> </div> </div> <form role="form" name="ocorrencia" id="ocorrencia" method="post" action="includes/cadOcorrencia.php"> <input type="hidden" name="id" id="id" value="<?php echo $res['id_flw']; ?>" /> <input type="hidden" name="chave" id="chave" value="<?php echo $res['chave_flw']; ?>" /> <div class="form-group login-username col-lg-12"> <div class="col-lg-3"> <a href="#" onclick="window.open('upload/anexo3.php?chave=<?php echo $res['chave_flw']; ?>', 'uploadanexo', 'STATUS=NO, TOOLBAR=NO, LOCATION=NO, DIRECTORIES=NO, RESISABLE=NO, SCROLLBARS=NO, TOP=120, LEFT=350, WIDTH=630, HEIGHT=500'); " class="btn btn-xs btn-primary"><i class="fa fa-shekel"></i> Anexar Arquivos </a> <p style="margin-top:10px"><span id="numanexos"></span> <small>arquivos</small></p> </div> <div class="col-lg-5" style="float:left"> <?php $query = "SELECT * FROM cw_user WHERE id_user != '$_SESSION[IDCLI]' ORDER BY nome_user"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); ?> <select data-placeholder="Selecione a empresa" name="autor" class="form-control chosen-select" tabindex="2"> <option value="0">Copiar usuário</option> <?php while($res = mysqli_fetch_assoc($result)){ ?> <option value="<?php echo $res['id_user']; ?>"><?php echo $res['nome_user']; ?> <?php echo $res['sobrenome_user']; ?></option> <?php } ?> </select> </div> <div class="col-lg-4" style="float:right"> <i class="fa fa-envelope-o"> </i> <label>Copiar cliente: </label> <input name="copia" type="checkbox" value="1" style=" margin-left: 10px" /> <br /> <?php $queryct = "SELECT nome_contato_flw FROM cw_contato_flw WHERE chave_contato_flw='$res[chave_flw]' ORDER BY nome_contato_flw"; $linkct = DBConnect(); $resultct = @mysqli_query($linkct, $queryct) or die(mysqli_error($linkct)); ?> <?php while($resct = mysqli_fetch_assoc($resultct)){ ?> <small><i class="fa fa-user"> </i> <?php echo $resct['nome_contato_flw']; ?><br /></small> <?php } ?> </div> </div> <div class="form-group login-username col-lg-12"> <div class="col-lg-3 tipoPvt3"> <div class="radio radio-info radio-inline"> <input type="radio" name="tipo" id="radio3 cnpj" value="1" onClick="alternarDocumento3('PRIVADO')" checked="checked" /> <label for="Privado"> Privado </label> </div> <div class="radio radio-inline" style="margin-left:-0px"> <input type="radio" name="tipo" id="radio3 cpf" value="0" onClick="alternarDocumento3('PUBLICO')" /> <label for="Público"> Público </label> </div> </div> <div class="col-lg-5"> <div class="form-group" > <label>Prazo: </label> <div class="input-group date"> <span class="input-group-addon"><i class="fa fa-calendar"></i></span><input type="text" class="form-control" id="data_1" name="prazo" value="" required=""> </div> </div> </div> <div class="col-lg-4"> <label>Hora: </label> <input type="text" name="hora" class="form-control horario" required=""> </div> </div> <div class="form-group login-username col-lg-12"> <div class="col-lg-12" style="display:block" id="div_user"> <?php $query = "SELECT * FROM cw_user ORDER BY nome_user"; $link = DBConnect(); $result = @mysqli_query($link, $query) or die(mysqli_error($link)); ?> <label>Usuário: </label> <select data-placeholder="Selecione a empresa" name="para" class="form-control chosen-select3" tabindex="2"> <option value="<?php echo $_SESSION['IDCLI']; ?>">Ocorrência própria</option> <?php while($res = mysqli_fetch_assoc($result)){ ?> <option value="<?php echo $res['id_user']; ?>"><?php echo $res['nome_user']; ?> <?php echo $res['sobrenome_user']; ?></option> <?php } ?> </select> </div> <div class="col-lg-12" style="display:none" id="div_cli"> <?php $querycont = "SELECT * FROM cw_contatos WHERE empresa_contatos='$idcliente' ORDER BY nome_contatos"; $linkcont = DBConnect(); $resultcont = @mysqli_query($linkcont, $querycont) or die(mysqli_error($linkcont)); ?> <label>Contato: </label> <select data-placeholder="Selecione a contato" name="empresa" class="form-control" tabindex="2"> <option value="">Selecione...</option> <?php while($rescont = mysqli_fetch_assoc($resultcont)){ ?> <option value="<?php echo $rescont['id_contatos']; ?>"><?php echo $rescont['nome_contatos']; ?></option> <?php } ?> </select> </div> </div> <div class="form-group login-username col-lg-12"> <div class="col-lg-12"> <label>Descrição: </label> <textarea id="descricao" name="descricao" rows="3" class="summernote form-control"></textarea> </div> </div> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary" id="mandarcoisas" value="CADASTRAR" type="submit"> <input name="button" type="submit" disabled="disabled" class="btn btn-block btn-lg btn-primary" id="mandarcoisas2" value="CADASTRAR" /> </div> </div> <!--userForm--> </form> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> <!-- MODAL DE CADASTRO DE USER --> <!-- MODAL DE CADASTRO DE USER --> <!-- Modal Login start --> <div class="modal signUpContent fade" id="ModalPrazo" tabindex="-1" role="dialog" > <div class="modal-dialog"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true"> &times; </button> <h3 class="modal-title-site text-center" > ALTERAR PRAZO </h3> </div> <div class="modal-body"> <form id="cadprazo" action="includes/altprazo.php" method="post"> <input type="hidden" name="tipoprazo" value="0" /> <input type="hidden" name="idprazo" value="<?php echo $id; ?>" /> <input type="hidden" name="idocorrencia" value="" /> <input type="hidden" name="horaocorrencia" value="" /> <div class="form-group login-username col-lg-12"> <div class="col-lg-5"> <div class="form-group" > <label>Prazo: </label> <div class="input-group date"> <span class="input-group-addon"><i class="fa fa-calendar"></i></span><input type="text" class="form-control" id="data_2" name="altprazo" value="" required=""> </div> </div> </div> </div> <div> <div> <input name="submit" class="btn btn-block btn-lg btn-primary" value="ALTERAR" type="submit"> </div> </div> <!--userForm--> </form> </div> </div> <!-- /.modal-content --> </div> <!-- /.modal-dialog --> <!-- MODAL DE CADASTRO DE USER -->