<td style="border-bottom: 2px solid black"></td> </tr> <tr> <td> <div id="lista_atualizacoes" style="width: 377px; height: 285px; overflow: auto;"> <table width="100%"> <? $total = count ( $_SESSION ['update_codigo'] ) - 1; for($i = 0; $i <= $total; $i ++) { ?> <tr> <td height="25"><b>Data</b></td> <td width="5">:</td> <td><?php echo timestamp_converte($_SESSION['update_codigo'][$i], 1); ?> </td> <td width="30"></td> <td><b>Prioridade</b></td> <td width="5">:</td> <td><?php echo strtoupper(prioridade_converte($_SESSION['update_prioridade'][$i])); ?> </td> <td width="30"></td> <td><b>Total de Arquivos</b></td> <td width="5">:</td> <td><?php echo $_SESSION['update_arquivos'][$i]; ?>
$validations = new validations ( ); $db = new db ( ); $db->connect (); $controle = $validations->validNumeric ( $_GET ['c'] ); $sql = "SELECT l.nome AS vendedor, c.txtnome AS txtnomecliente, mvm.estornado AS estorno, SUM(mvm.quant) AS quantidade, SUM(mvm.vr_total) as valortotal, mvv.vr_totalvenda FROM mv_vendas_movimento AS mvm JOIN mv_vendas AS mvv ON (mvm.controle = mvv.controle) LEFT JOIN cliente AS c ON mvm.id_cliente=c.idcliente LEFT JOIN cad_login AS l ON mvm.id_login=l.id WHERE mvm.controle='" . $controle . "' GROUP BY mvm.controle"; $query = $db->query ( $sql ); if ($db->num_rows ( $query )) { $row = $db->fetch_assoc ( $query ); $datacontrole = timestamp_converte ( $controle, 0 ); $confere_diferenca = dateDiff ( date ( 'd-m-Y', $controle ), date ( 'd-m-Y' ) ); $estornados = 0; $quantidade_produtos = ( int ) $row ['quantidade']; $sql = "SELECT SUM(mv_vendas.vr_totalvenda), SUM(quant) AS quantidade, SUM(vr_total) as valortotal FROM mv_vendas_movimento JOIN mv_vendas on (mv_vendas.controle = mv_vendas_movimento.controle) WHERE mv_vendas_movimento.controle='" . $controle . "' AND estornado=1 "; $queryestornos = $db->query ( $sql ); $rowestornos = $db->fetch_assoc ( $queryestornos ); $quantidade_produtos_estorno = ($rowestornos ['quantidade']) ? ( int ) $rowestornos ['quantidade'] : 0; ; $valor_estornos = ($rowestornos ['valortotal']) ? $rowestornos ['valortotal'] : 0; ?>
require "../../config/default.php"; } $validations = new validations ( ); $db = new db ( ); $db->connect (); $idusuario = $validations->validNumeric ( $_GET ['i'] ); $sql = "SELECT datalog FROM log_login WHERE cad_login_id=" . $idusuario . " ORDER BY datalog DESC LIMIT 100"; $query = $db->query ( $sql ); ?> <table width="100%" cellpadding="0" cellspacing="0" border="0"> <? while ( $row = $db->fetch_assoc ( $query ) ) { ?> <tr> <td height="25" align="right"><?php echo timestamp_converte($row['datalog']); ?> </td> <td width="10"></td> </tr> <tr> <td colspan="2" style="border-bottom: 1px solid #c0c0c0;"></td> </tr> <? } ?> </table>