E:
/
home
/
kbcomunicacao1
/
Web
/
innterage
/
views
/
Upload File
HOME
<?php session_start(); $sessao = session_id(); session_regenerate_id(); require '../includes/conexao/funcao.inc.php'; require '../includes/conexao/config.php'; require '../includes/conexao/conn.php'; require '../includes/conexao/function.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.fantasia_cliente, cw_cliente.razao_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.chave_flw='$id'"; $result = DBExecute($query); $res = mysqli_fetch_assoc($result); $pinflw = $res['chave_flw']; $queryflw = "SELECT id_ocorrencia FROM cw_ocorrencia WHERE chave_ocorrencia='$res[chave_flw]'"; $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; } ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>GRUPO CAOM</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" style="background:#F3F3F4;"> <div class="row wrapper border-bottom white-bg page-heading"> <div class="col-sm-4"> <h2>Solicitações</h2> <ol class="breadcrumb"> <li> </ol> </div> </div> <div class="row"> <form role="form" name="uploadFlw" method="post" id="uploadFlw" enctype="multipart/form-data" > <div class="col-lg-9"> <div class="wrapper wrapper-content animated fadeInUp"> <div class="ibox"> <div class="ibox-content"> <div class="row"> <div class="col-lg-12"> <div class="form-group col-lg-12"> <div class="col-lg-6"> <label>Empresa: </label> <input type="text" name="empresa" class="form-control" value="<?php echo $res['razao_cliente']; ?>" readonly> </div> <div class="col-lg-6"> <label>Assunto: </label> <input name="assunto" type="text" class="form-control" value="<?php echo $res['assunto_flw']; ?>" readonly> </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><?php echo dbDateToDate2($res['prazo_flw']); ?></dd> </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">Ocorrências em aberto</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.termino_ocorrencia, cw_ocorrencia.horaco_ocorrencia, cw_ocorrencia.leitura_ocorrencia, cw_ocorrencia.data_lido_ocorrencia, cw_ocorrencia.hora_lido_ocorrencia, cw_ocorrencia.email_destino_ocorrencia, cw_ocorrencia.destino_ocorrencia, cw_ocorrencia.status_ocorrencia, cw_ocorrencia.para_ocorrencia, cw_ocorrencia.chave_leitura_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_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=0 AND para_ocorrencia='0'"; $linko = DBConnect(); $resulto = @mysqli_query($linko, $queryo) or die(mysqli_error($linko)); ?> <?php while($reso = mysqli_fetch_assoc($resulto)){ ?> <!-- 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']); ?></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/baixaranexo.php?arquivo=<?php echo $resanx['caminho_anexo']; ?>&id=<?php echo $id; ?>&idanexo=<?php echo $resanx['id_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); $nomederesposta = "$resresp[nome_user] $resresp[sobrenome_user]"; ?> <!--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 $nomederesposta; ?> </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){ ?> <a href="#" title="Encerrar ocorrência" onclick="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')" 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 } ?> <a href="#" onclick="window.open('resposta.php?id=<?php echo $reso['id_ocorrencia']; ?>&de=<?php echo $reso['de_ocorrencia']; ?>&idflw=<?php echo $res['id_flw']; ?>¶=<?php echo $reso['para_ocorrencia']; ?>&tipo=<?php echo $reso['destino_ocorrencia']; ?>&email=0&pin=<?php echo $pinflw; ?>&copia=0&tipoa=0&&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'); " class="btn btn-xs btn-white"><i class="fa fa-share"></i> Responder</a> </div> </div> </div> <!-- LISTA DE FLW--> <?php } ?> </div> </div> <div class="tab-pane" id="tab-2"> <div class="feed-activity-list"> <?php $queryo = "SELECT cw_ocorrencia.email_destino_ocorrencia, cw_ocorrencia.leitura_ocorrencia, cw_ocorrencia.data_lido_ocorrencia, cw_ocorrencia.hora_lido_ocorrencia, cw_ocorrencia.id_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_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 AND para_ocorrencia='0'"; $linko = DBConnect(); $resulto = @mysqli_query($linko, $queryo) or die(mysqli_error($linko)); ?> <?php while($reso = mysqli_fetch_assoc($resulto)){ ?> <!-- 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']; ?> </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="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');" 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="window.open('resposta.php?id=<?php echo $reso['id_ocorrencia']; ?>&de=<?php echo $reso['de_ocorrencia']; ?>&idflw=<<?php echo $res['id_flw']; ?>¶=<?php echo $reso['para_ocorrencia']; ?>&email=0', 'responder', 'STATUS=NO, TOOLBAR=NO, LOCATION=NO, DIRECTORIES=NO, RESISABLE=NO, SCROLLBARS=NO, TOP=200, LEFT=250, WIDTH=630, HEIGHT=300');" 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 } ?> </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 name="descricao" cols="" rows="8" disabled class="form-control"><?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]' AND destino_anexo=1"; $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 href="#" onclick="window.open('../upload/anexo2.php?chave=<?php echo $res['chave_flw']; ?>&dest=1', '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 AQUI </a> </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>