/// EDITADOS O BORRADOS COMPRAS

$sqlEB = mysql_query("SELECT * FROM compras WHERE a_d_detcomp='$Act' AND fecha_e_detcomp LIKE '%$FechaPHP%' ORDER BY n_detcomp ASC"); 
$formatoEB =array('fontSize'=>5.5,'showLines'=>1,'shadeCol'=>array(0.96,0.96,0.96),'showHeadings'=>1,'lineCol'=>array(0.96,0.96,0.96),
		'cols'=>array(
					  'No'=>array('justification'=>'center', 'width'=>22),
					  'NotaV'=>array('justification'=>'center', 'width'=>35),
					  'Producto'=>array('justification'=>'left', 'width'=>100),
					  'PrecioU'=>array('justification'=>'center', 'width'=>35),
					  'TMV'=>array('justification'=>'center', 'width'=>30),
					  'Cant'=>array('justification'=>'center', 'width'=>30),
					  'Pago'=>array('justification'=>'left', 'width'=>60),
					  'ACuenta'=>array('justification'=>'center', 'width'=>35),
					  'STotal'=>array('justification'=>'center', 'width'=>35),
					  'Fecha_R'=>array('justification'=>'center', 'width'=>60),
					  'Total'=>array('justification'=>'center', 'width'=>40),
					  'Autor'=>array('justification'=>'center', 'width'=>40),
					  ));

$persoEB=array('fontSize'=>6,'showLines'=>0,'showHeadings'=>0,'lineCol'=>array(0.96,0.96,0.96),
		'cols'=>array(
					  '1'=>array('justification'=>'center', 'width'=>22),
					  '2'=>array('justification'=>'center', 'width'=>35),
					  '3'=>array('justification'=>'left', 'width'=>100),
					  '4'=>array('justification'=>'center', 'width'=>35),
					  '5'=>array('justification'=>'center', 'width'=>30),
					  '6'=>array('justification'=>'center', 'width'=>30),
					  '7'=>array('justification'=>'left', 'width'=>60),
					  '8'=>array('justification'=>'left', 'width'=>35),
					  '9'=>array('justification'=>'left', 'width'=>35),
					  '10'=>array('justification'=>'center', 'width'=>60),
					  '11'=>array('justification'=>'center', 'width'=>40),
					  '12'=>array('justification'=>'center', 'width'=>40)
					 ));




//para cargar desde la base de datos
	$NoEB=0;
	$NotaVEB=0;
	$ProductoEB="";
	$PrecioUEB=0;
	$TMVEB="";
	$CantEB=0;
	$PagoEB="";
	$ACuentaEB=0;
	$STotalEB=0;
	$FechaREB="";
	$TotalEB=0;
	$TotalSEB=0;	
	$AutorEB="";

while($row = mysql_fetch_array($sqlEB))
                {
				$NoEB=$NoEB+1;
				$NotaVEB=$row["n_comp_detcomp"];
				$ProductoEB=$row["producto_detcomp"];
				$PrecioUEB=$row["preciov_detcomp"];
				$TMVEB=$row["tmv_detcomp"];
				$CantEB=$row["cant_detcomp"];
				//$PagoEB=$row["pago_detcomp"];
				//$ACuentaEB=$row["acuenta2_cyd"];
				$STotalEB= $row["preciov_detcomp"]*$row["cant_detcomp"];
				$FechaREB=$row["fecha_e_detcomp"];
				//$Total= $row["preciov_detvent"]*$row["cant_detvent"];
				//$TotalEB= $ACuentaEB;
				//$TotalSEB=$TotalSEB+$TotalEB;
				$AutorEB=$row["autor_e_detcomp"];				
				
				$dataEB[] = array('No'=>$NoEB,
								'NotaV'=>$NotaVEB,
								'Producto'=>$ProductoEB,
								'PrecioU'=>$PrecioUEB,
								'TMV'=>$TMVEB,
								'Cant'=>$CantEB,
								'Pago'=>$PagoEB,
								'ACuenta'=>$ACuentaEB,
								'STotal'=>$STotalEB,
								'Fecha_R'=>$FechaREB,
								'Total'=>$TotalEB);
															
				}
				
//mysql_close($conexion);

$data1EB[]= array('1'=>'',
				'2'=>'',
				'3'=>'',
				'4'=>'',
				'5'=>'',
				'6'=>'',
				'7'=>'',
				'8'=>'',
				'9'=>'',
				'10'=>'',
				'11'=>''.$TotalSEB."  ".$TMVEB);  
 
$titlesEB = array('No'=>'<b>No</b>',
				'NotaV'=>'<b>NotaV</b>',
				'Producto'=>'<b>Producto</b>',
				'PrecioU'=>'<b>PrecioU</b>', 
				'TMV'=>'<b>TMV</b>',
				'Cant'=>'<b>Cant</b>',
				'Pago'=>'<b>Pago</b>',
				'ACuenta'=>'<b>ACuenta</b>',
				'STotal'=>'<b>STotal</b>',
				'Fecha_R'=>'<b>Fecha_R</b>',
				'Total'=>'<b>Total</b>'
				);