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["idflw"]))
{
	$idflw = $_POST['idflw'];
}	
	
?>

<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_flw.id_flw, cw_flw.img_flw, cw_flw.assunto_flw, cw_cliente.razao_cliente, cw_flw.destacar_flw, cw_flw.responsavel_flw, cw_flw.sub_flw, cw_flw.tsub_flw
								 
								 FROM cw_relaciona_fw, cw_flw, cw_cliente
								 
								 WHERE cw_relaciona_fw.fw_relaciona_fw=id_flw AND cw_flw.cliente_flw=cw_cliente.id_cliente AND

cw_relaciona_fw.user_relaciona_fw='$_SESSION[IDCLI]' AND cw_relaciona_fw.status_relaciona_flw='0'
								 
								 AND cw_flw.destacar_flw ='1' AND cw_flw.id_flw = '$idflw' 
								 
								 ORDER BY timestamp DESC";							
								
								
								$link   = DBConnect();
								$result = @mysqli_query($link, $query) or die(mysqli_error($link));
								
								while($res = mysqli_fetch_assoc($result)){
								$queryuser = "SELECT nome_user, img_user FROM cw_user WHERE id_user='$res[responsavel_flw]'";
								$resultuser = DBExecute($queryuser);
								$resuser = mysqli_fetch_assoc($resultuser);
								$nome_user 		= $resuser['nome_user'];
								$img_user 	= $resuser['img_user']; 
												?> 
                                                <tr class="mudavisitado irpainel" data-toggle="#<?php echo $res['id_flw'] ?>" id="<?php echo $res['id_flw'] ?>">
                                                    <td class="client-avatar">
                                                    
													<?php if($resuser['img_user']==""){ ?>
                                                    <img alt="image" src="../midia/img/profile_small.jpg">
                                                    <?php }else{ ?>
                                                    <img title="Responsável <?php echo $resuser['nome_user']; ?>" alt="image" src="../img-perfil/img/perfil/<?php echo $resuser['img_user']; ?>">
                                                    <?php } ?>
                                                    
                                                    </td>
                                                    <td>
                                                    <a style="color:#333" data-toggle="tab" href="#" class="client-link" title="<?php echo $res['assunto_flw']; ?>">
                                                    <?php if(($res['destacar_flw']==1)&&($res['responsavel_flw']==$_SESSION['IDCLI'])){echo"<i class='fa fa-thumb-tack' style='color:#00F; font-size:16px'></i>&nbsp;&nbsp;";} ?><?php if($res['sub_flw']!=0){echo"<i class='fa fa-share-alt' style='color:#690; font-size:15px'></i>&nbsp;&nbsp;";} ?><?php if($res['tsub_flw']==1){echo"<i class='fa fa-share-alt' style='color:#0000FF; font-size:15px'></i>&nbsp;&nbsp;";} ?><?php echo limita_caracteres($res['assunto_flw'], 35); ?><br />
                                                    <small style="font-size:10px; font-family:Tahoma, Geneva, sans-serif; font-weight:normal">
													<?php echo limita_caracteres($res['razao_cliente'], 35); ?><br />
                                                    </small>
                                                    <small>
													<?php echo limita_caracteres($res['ultima_relaciona_flw'], 40); ?>    
													</small>
                                                    </a>
                                                    </td>
                                                     
                                                    <td align="right">
                                                    <a style="color:#333" data-toggle="tab" href="#">
                                                    <small>
                                                    <?php if($res['msg_relaciona_flw']>0){ ?>
                                          <span class="label label-info pull-right"><?php echo $res['msg_relaciona_flw'] ?></span>
													<?php }else{} ?>
													</small><br />
                                                    <?php 
													
													$d = date("d"); 
													$m = date("m"); 
													$Y = date("Y");
													$data_banco =  dbDateToDate2($res['data_relaciona_flw']);
													$hoje 		=  date("d/m/Y");
													$ontem 		=  date("d/m/Y", mktime(0, 0, 0, $m, $d-1, $Y));
													$anteontem  =  date("d/m/Y", mktime(0, 0, 0, $m, $d-2, $Y)); 
																									 
													 
													if($data_banco==$hoje){
													echo limita_caracteres2($res['horario_relaciona_flw'], 5);
													}elseif($data_banco==$ontem){
													echo"Ontem";
													}elseif($data_banco==$anteontem){
													echo"Anteontem";
													}else{
													echo $data_banco;	
													}
													?>
													</a>
                                                    </td>
                                                    
                                                </tr>
                                                <?php } ?>
                                               
                                                
                                                </tbody>
                                        </table>