eclass.unmer.ac.id

<?php
	session_start();
	require '../includes/conexao/funcao.inc.php';
	require '../includes/conexao/config.php';
	require '../includes/conexao/conn.php';
	require '../includes/conexao/function.php';
	
	date_default_timezone_set("America/Sao_Paulo");
	setlocale(LC_ALL, 'pt_BR');
	
if(isset($_POST["responsavel"]))
{
	$responsavel = $_POST['responsavel'];
}

<table class="table table-striped table-hover">
<tbody>
<?php

$query = "SELECT cw_relaciona_fw.data_relaciona_flw,
cw_relaciona_fw.horario_relaciona_flw, 
cw_relaciona_fw.msg_relaciona_flw, 
cw_relaciona_fw.ultima_relaciona_flw,
cw_relaciona_fw.timestamp,
cw_flw.id_flw,
cw_flw.tipo_flw,
cw_flw.prazo_flw,
cw_flw.img_flw,
cw_flw.assunto_flw,
cw_flw.responsavel_flw,
cw_cliente.razao_cliente,
cw_user.img_user,
cw_user.nome_user
FROM cw_relaciona_fw, cw_flw, cw_cliente, cw_user

WHERE cw_relaciona_fw.fw_relaciona_fw=cw_flw.id_flw 
AND cw_relaciona_fw.user_relaciona_fw='$_SESSION[IDCLI]' 
AND cw_flw.cliente_flw=cw_cliente.id_cliente
AND cw_user.id_user=cw_flw.responsavel_flw 
AND cw_relaciona_fw.status_relaciona_flw='0'
AND cw_flw.responsavel_flw = '$responsavel'

ORDER BY timestamp DESC";

$link   = DBConnect();
$result = @mysqli_query($link, $query) or die(mysqli_error($link));
while($res = mysqli_fetch_assoc($result)){
?>

<td class="client-avatar">
        
  <img title="Responsável <?php echo $res['nome_user']; ?>" alt="image" src="../img-perfil/img/perfil/<?php echo $res['img_user']; ?>">
  
  </td>
  <td style="border-right: none">

<?php if($res['tipo_flw']==7){ ?><i class="fa fa-square" style="color: #FF0"></i><?php } ?>
    <strong><?php echo $res['assunto_flw']; ?></strong><br />
    <small><?php echo $res['razao_cliente']; ?></small><br />
    <small><strong><?php echo limita_caracteres($res['ultima_relaciona_flw'], 40); ?></strong></small>

</td>
  <td style="border-left: none">
    <small>
    <?php if($res['msg_relaciona_flw']>0){ ?>
    <span class="label label-info pull-right"><?php echo $res['msg_relaciona_flw'] ?></span>
    <?php } ?>
    </small>
  </td>

</tr>

<?php } ?>

</tbody>

</table>