Ejemplo n.º 1
0
		<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>