ventas_php/modules/debug.php

<?php
	
	$empresa->AuthUser();
	exit;
	$sql = 'SHOW TABLES';
	$util->DBSelect($_SESSION["empresaId"])->setQuery($sql);		
	$tables = $util->DBSelect($_SESSION["empresaId"])->GetResult();
	
	$tablas = array();
	foreach($tables as $t){
		
		$tabla = $t['Tables_in_avantikads_nm'];
				
		$sql = 'DESCRIBE '.$tabla;
		$util->DBSelect($_SESSION["empresaId"])->setQuery($sql);		
		$campos = $util->DBSelect($_SESSION["empresaId"])->GetResult();
		
		foreach($campos as $c){
		
			if($c['Field'] == 'proveedorId'){
				if(!in_array($tabla, $tablas))
					$tablas[] = $tabla;
			}		
		}		
	}
	
	echo 'Tablas con Proveedores';
	echo '<br><br>';
	
	//Eliminar 597. Dejar 77
	//Eliminar 598. Dejar 70
	//Eliminar 536. Dejar 124
	
	foreach($tablas as $tabla){
		
		if($tabla == 'proveedor')
			continue;
		
		$sql = 'SELECT COUNT(*) FROM '.$tabla.' WHERE proveedorId = 597';
		$util->DBSelect($_SESSION["empresaId"])->setQuery($sql);		
		$total597 = $util->DBSelect($_SESSION["empresaId"])->GetSingle();
		
		$sql = 'SELECT COUNT(*) FROM '.$tabla.' WHERE proveedorId = 598';
		$util->DBSelect($_SESSION["empresaId"])->setQuery($sql);		
		$total598 = $util->DBSelect($_SESSION["empresaId"])->GetSingle();
		
		$sql = 'SELECT COUNT(*) FROM '.$tabla.' WHERE proveedorId = 536';
		$util->DBSelect($_SESSION["empresaId"])->setQuery($sql);		
		$total536 = $util->DBSelect($_SESSION["empresaId"])->GetSingle();
		
		echo $tabla.' = 597 = '.$total597.' :: 598 = '.$total598.' :: 536 = '.$total536;
		echo '<br>';
		/*
		$sql = 'UPDATE '.$tabla.' SET proveedorId = 77 WHERE proveedorId = 597';
		$util->DBSelect($_SESSION["empresaId"])->setQuery($sql);		
		$util->DBSelect($_SESSION["empresaId"])->UpdateData();

		$sql = 'UPDATE '.$tabla.' SET proveedorId = 70 WHERE proveedorId = 598';
		$util->DBSelect($_SESSION["empresaId"])->setQuery($sql);		
		$util->DBSelect($_SESSION["empresaId"])->UpdateData();
		
		$sql = 'UPDATE '.$tabla.' SET proveedorId = 124 WHERE proveedorId = 536';
		$util->DBSelect($_SESSION["empresaId"])->setQuery($sql);		
		$util->DBSelect($_SESSION["empresaId"])->UpdateData();
		*/
	}
	
	echo '<br><br>';
	echo 'Done';
	
	exit;
	exit;
	
	$sql = "SELECT *						
			FROM envio
			WHERE status = 'Pendiente'";
	$util->DBSelect($_SESSION["empresaId"])->setQuery($sql);		
	$result = $util->DBSelect($_SESSION["empresaId"])->GetResult();
	
	foreach($result as $res){
		
		echo $res['envioId'];
		echo '<br>';
		
		$envio->setEnvioId($res['envioId']);
		$info = $envio->Info();
		
		$resOrdenes = $envio->GetPedidos();
	
		$ordenes = array();
		foreach($resOrdenes as $res){
			
			$pedidoId = $res['pedidoId'];
			
			$pedido->setPedidoId($pedidoId);
			$infP = $pedido->Info();
			
			$fechaIng = date('Y-m-d',strtotime($infP['fechaOrdenCompIng']));
			
			if($fechaIng >= '2013-12-17')
				continue;
				
			echo '&nbsp;&nbsp;&nbsp; - '.$res['pedidoId'].' = '.$fechaIng;
			echo '<br>';
									
			$pedido->setSucursalId($info['sucursalId']);
			$items = $pedido->GetItemsDistSuc();
			
			$total = 0;
			$totPrendas = 0;
			$productos = array();
			foreach($items as $val){
				
				/*
				if($val['envioId'] != $envioId && $envioId >= 4791) //Local 4776, Prod = 4791
					continue;
				*/
				
				if($val['envioId'] == 0){
				echo '&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; > '.$val['productoId'];
				echo ' = '.$val['pedDistId'].' = '.$val['envioId'];
				echo '<br>';
				}
				
				$producto->setProductoId($val['productoId']);
				$infP = $producto->Info();
				
				$pedido->setProductoId($val['productoId']);
				$infPP = $pedido->GetInfoProd();
				
				if($infPP['prendasComp'] == 0)
					$val['cantidad'] = $val['prendas'];
				
				$prendas = $val['cantidad'];			
				
				$totPrendas += $prendas;
				
				$total += $prendas * $infP['costo'];
				
				//Informacion del Producto
								
				if($val['cantidad']){
					$card['codigoBarra'] = $infP['codigoBarra'];
					$card['modelo'] = $infP['modelo'];
					$card['cantidad'] = $val['cantidad'];
					$card['cajas'] = $val['cajas'];
					
					$productos[] = $card;
				}
				
			}//foreach
			
			$res['total'] = number_format($total,2);
			$res['prendas'] = $totPrendas;
			$res['productos'] = $productos;
			
			$ordenes[] = $res;
		}
				
	}//foreach
	
	exit;
	exit;
	
	$envioId = 4786;
	
	$envio->setEnvioId($envioId);
	$info = $envio->Info();
	
	echo $sucursalId = $info['sucursalId'];
	echo '<br>';
	
	$resOrdenes = $envio->GetPedidos();
	
	$productos = array();
	$idProds = array();
	foreach($resOrdenes as $res){
		
		$pedidoId = $res['pedidoId'];
		
		$pedido->setPedidoId($pedidoId);
		$infP = $pedido->Info();
		
		echo $res['pedidoId'].' = '.$infP['noPedido'];
		echo '<br>';
				
		//Obtenemos los Productos
		
		$sql = "SELECT 
					* 
				FROM 
					pedidoDistribucion
				WHERE 
					pedidoId = '".$pedidoId."'
				AND 
					sucursalId = '".$sucursalId."'
				AND
					status = 'Enviado'";
		$util->DBSelect($_SESSION["empresaId"])->setQuery($sql);	
		$productos = $util->DBSelect($_SESSION["empresaId"])->GetResult();
		
		foreach($productos as $val){
			
			$pedDistId = $val['pedDistId'];
			
			if($val['cantidad'] == 0)
				continue;
			
			$pedido->setProductoId($val['productoId']);
			$infPP = $pedido->GetInfoProd();
			
			if($infPP['prendasComp'] == 0)
				$val['cantidad'] = $val['prendas'];
			
			$val['cantPrendas'] = $val['cantidad'];
			
			echo '&nbsp;&nbsp;&nbsp;';
			echo $pedDistId.' :: '.$val['productoId'].' = '.$val['cantPrendas'].' = '.$val['envioId'];
			echo '<br>';
			
			$sql = 'UPDATE pedidoDistribucion SET envioId = '.$envioId.'
					WHERE pedDistId = '.$pedDistId;
			//$util->DBSelect($_SESSION["empresaId"])->setQuery($sql);	
			//$util->DBSelect($_SESSION["empresaId"])->UpdateData();
			//echo $sql.'<br>';
			
		}
		
	}
	
	exit;
	exit;
	
	
	$sql = "SELECT *
			FROM `pedido`
			WHERE `status` = 'OrdenCompIng'
			AND pedidoId <= 4003
			ORDER BY pedidoId DESC";
	$util->DBSelect($_SESSION["empresaId"])->setQuery($sql);
	$result = $util->DBSelect($_SESSION["empresaId"])->GetResult();
	
	foreach($result as $res){
		
		$pedidoId = $res['pedidoId'];
		
		echo $pedidoId;
		echo '<br>';
		
		$sql = "UPDATE `_pedidoProducto` SET recibido = '1'
					WHERE pedidoId = ".$pedidoId;
			//echo $sql.'<br>';
			//$util->DBSelect($_SESSION["empresaId"])->setQuery($sql);
			//$util->DBSelect($_SESSION["empresaId"])->UpdateData();
		
		$sql = "SELECT *
				FROM `pedidoProducto`
				WHERE pedidoId = ".$pedidoId;
		$util->DBSelect($_SESSION["empresaId"])->setQuery($sql);
		$productos = $util->DBSelect($_SESSION["empresaId"])->GetResult();
		
		foreach($productos as $p){
			
			$productoId = $p['productoId'];
			
			echo '&nbsp;&nbsp;&nbsp;'.$productoId.' = '.$p['recibido'];
			echo '<br>';				
		}
		
	}
	
	exit;
	
?>