<?php
	/*-------------------------
	Autor: Obed Alvarado
	Web: obedalvarado.pw
	Mail: info@obedalvarado.pw
	---------------------------*/
session_start();
$user_id=$_SESSION['user_id'];
if (isset($_POST['id'])){$id=$_POST['id'];}
if (isset($_POST['cantidad'])){$qty=intval($_POST['cantidad']);}
if (isset($_POST['precio_venta'])){floatval($unit_price=$_POST['precio_venta']);}


	/* Connect To Database*/
	require_once ("../config/db.php");//Contiene las variables de configuracion para conectar a la base de datos
	require_once ("../config/conexion.php");//Contiene funcion que conecta a la base de datos
	require_once ("../libraries/inventory.php");//Contiene funcion que controla stock en el inventario
	
if (!empty($id) and !empty($qty) and !empty($unit_price))
{
	$contarStock=contarStock($id,$user_id);	
	$unidades_tmp=$qty+$contarStock;
	$stock=get_stock($id);
	//echo var_dump($stock);
	if ($stock<$unidades_tmp){
		?>
		<script>alert('No cuenta con suficiente stock para realizar la venta');</script>
		<?php	
	} else{
	
		if(validarTablaTemporal($id, $user_id)){
			global $con;
			 $sql=mysqli_query($con, "UPDATE  product_tmp  set qty =qty+'".$qty."'  WHERE product_id='".$id."' and  user_id='".$user_id."' ");
		}else{

		add_tmp($id, $qty, $unit_price, $user_id);
		
		}
	}
}
 if (isset($_GET['cantidad'])){
		$cantidad = intval($_GET['cantidad']);
 		$product_id = intval($_GET['idproducto']);
 		//echo var_dump($product_id);
 		$stock=get_stock($product_id);
	//echo var_dump($stock);
	if ($cantidad==0) {
 			?>
 			<script>alert('Cantidad debe ser mayor a 0');</script>
 			<?php
 			$cantidad=1;
 	}

	if ($stock<$cantidad){
		?>
		<script>alert('No cuenta con suficiente stock para realizar la venta');</script>
		<?php	
	} else{
	
		if(validarTablaTemporal($product_id, $user_id)){
			global $con;
			 $sql=mysqli_query($con, "UPDATE  product_tmp  set qty ='".$cantidad."'  WHERE product_id='".$product_id."' and  user_id='".$user_id."' ");
		}
	}
}

if (isset($_POST['barcode'])){
	$barcode=mysqli_real_escape_string($con,$_POST['barcode']);
	$barcode_qty=intval($_POST['barcode_qty']);
	$product_id=get_id('products','product_id','product_code',$barcode);
	$unit_price=get_id('products','selling_price','product_id',$product_id);
	if ($product_id>0){
		$stock=get_stock($product_id);

		
		if ($stock<$barcode_qty){
			?>
			<script>alert('No cuenta con suficiente stock para realizar la venta');</script>
			<?php	
		} else{
		
			if(validarTablaTemporal($product_id, $user_id)){
				global $con;
				 $sql=mysqli_query($con, "UPDATE  product_tmp  set qty =qty+'".$barcode_qty."'  WHERE product_id='".$product_id."' and  user_id='".$user_id."' ");
			}else{

			add_tmp($product_id, $barcode_qty, $unit_price, $user_id);
			
			}
		}
	
	} else {
		echo "<script>alert('Producto no encontrado.')</script>";
	}
}
if (isset($_GET['id']))//codigo elimina un elemento de la DB
{
$id_tmp=intval($_GET['id']);	
remove_tmp($id_tmp);
}

	/*Datos de la empresa*/
		$sql_empresa=mysqli_query($con,"SELECT * FROM  business_profile, currencies where business_profile.currency_id=currencies.id and business_profile.id=1");
		$rw_empresa=mysqli_fetch_array($sql_empresa);
		$moneda=$rw_empresa["symbol"];
		
	/*Fin datos empresa*/
	$tax=floatval($_REQUEST['tax']);
	$descuento=floatval($_REQUEST['descuento']);

	if ($descuento<0) {
		echo "<script>alert('Descuento debe ser mayor a 0.')</script>";
		$descuento =0;
	}

// echo var_dump($descuento);
?>

 <table class=" table" id="cartTable">
    <thead>
        <tr>
            <th width=""><h5><b>#</b></h5></th>
            <th width="" ><h5>PRODUCTO </h5></th>
            <th width=""><h5> CANT.</th>
            <th width="" ><h5> P. UNIT. </h5></th> 
            <th width="" ><h5> P.TOTAl</h5></th> 
            <th width="" ></th>           
            
        </tr>
    </thead>
    <tbody class="">
<?php
	$sql_taxes=mysqli_query($con,"select * from taxes where status=1");
	$sumador_total=0;
	$sql=mysqli_query($con, "select * from products, product_tmp where products.product_id=product_tmp.product_id and product_tmp.user_id='$user_id'");
	$numsProductos=1;
	$numsItems =0;
	while ($row=mysqli_fetch_array($sql))
	{
	$product_id=$row['product_id'];
	$id_tmp=$row["id_tmp"];
	$product_code=$row['product_code'];
	$qty=$row['qty'];
	$product_name=$row['product_name'];
	$unit_price=number_format($row['unit_price'],$currency_format['precision_currency'],'.','');

	$precio_total=$unit_price*$qty;
	$precio_total=number_format($precio_total,$currency_format['precision_currency'],'.','');//Precio total formateado
	$sumador_total+=$precio_total;//Sumador
	
		?>                          
                        
            <tr>
                <td width=""><?php echo $numsProductos;?></td>
                <td width=""><?php echo $product_name;?></td>
                <td  width=""class="">
                	<!-- <div class="input-group"> -->
                    <!-- <div class="input-group-btn btn-xs"> -->
                   		 <!-- </div> -->
                   		 <input style="width: 65px" class="form-control input-sm" oninput="updateCant(this.value, '<?php echo $product_id;?>')"  id="cant" type="number" value="<?php echo $qty;?>">
                    
                	<!-- </div> -->
                </td>
                <td><span class="pull-right"> <?php echo number_format($unit_price,$currency_format['precision_currency'],$currency_format['decimal_separator'],$currency_format['thousand_separator']);?> </span></td>
                <td><span class="pull-right"> <?php echo number_format($precio_total,$currency_format['precision_currency'],$currency_format['decimal_separator'],$currency_format['thousand_separator']);?> </span></td>
                
                <td><button class="btn btn-danger btn-xs" onclick="eliminar('<?php echo $id_tmp; ?>')"><i class="fa fa-times"></i></button></td>
            </tr>
                
			
		<?php
		$numsProductos++;
		$numsItems++;
	}

	$total_parcial=number_format($sumador_total,$currency_format['precision_currency'],'.','');
	$total_neto=$total_parcial;
	$total_neto=number_format($total_neto,$currency_format['precision_currency'],'.','');
	$precio_descuento =($total_neto*$descuento)/100;

	if($precio_descuento<=0 && $total_neto<=0){
		
	}else{

		if ($precio_descuento >= $total_neto) {
		echo "<script>alert('El descuento no puede ser mayor al precio ');</script>";
		$descuento =0;
		$precio_descuento =0;
		}

	}
	
	
	if($descuento >0) {
			$precio_descuento =($total_neto*$descuento)/100;
			$total_descuento = ($total_neto-$precio_descuento);
			$total_iva = ($total_descuento*$tax)/100;
			$total_compra =($total_descuento+$total_iva);
	}else{

			$total_iva=($total_neto*$tax) / 100;
			$total_iva=number_format($total_iva,$currency_format['precision_currency'],'.','');
			$total_compra=$total_neto+$total_iva;
			$total_compra=number_format($total_compra,$currency_format['precision_currency'],'.','');
	}
	
	

?>
</tbody>
   </table>           
 

    <hr>
   <div class="m-t-10" >
       <div class="row" >
           <div class="col-md-4"><label class="control-label">Total Item(s) </label></div>
           <div class="col-md-2">: <span id="total"><label class="control-label"><?php echo $numsItems;?></label></sapn></div>
           <?php
           	$validarDescuento =$total_neto;
           	$label="NETO:";
           
           		           	
           	// if ($descuento>0) {
           	// 		$label = "NETO(incluye descuento)";
           	// 		$validarDescuento=$total_descuento;
           		
           	// }
           ?>
           <div class="col-md-3"> <label class="control-label"><?php echo $label;?></label> </div>
           <div class="col-md-3">: <span id="price"><label class="control-label"><?php echo number_format($validarDescuento,$currency_format['precision_currency'],$currency_format['decimal_separator'],$currency_format['thousand_separator']);?></label></span></div>
           
		</div>	
	</div>

	<div class="m-t-10">
       <div class="row">
       	<div class="form-group">
           <div class="col-md-4"> <label class="control-label">Descuento(%) </label></div>
           <!-- <div class="col-md-2"></div> -->
            <div class="col-md-4"><input class="form-control input-sm" required pattern="\d+(\.\d{2})?"  type="number" id="descuento" value="<?php echo $descuento ?>" onblur="descuento(this.value)" ></div> 
            <div class="col-md-3 col-md-offset-1">: <span id="price"> <label class="control-label"><?php echo number_format($precio_descuento,$currency_format['precision_currency'],$currency_format['decimal_separator'],$currency_format['thousand_separator']);?></label></span></div>
        </div>               

		</div>	
	</div>			


	<div class="m-t-10">
       <div class="row">            
           <div class="col-md-4"><label class="control-label">IVA(%)</label> </div>
           <div class="col-md-4">
            	<select name="taxes" class="form-control input-sm" id="taxes" onchange="tax_value(this.value)">
					<?php
						foreach ($sql_taxes as $valor){
							if ($tax==$valor['value']){
								$selected="selected";
							} else{
								$selected="";
							} 
							echo '<option value="'.$valor['value'].'" '.$selected.'>'.$valor['name']." ".$valor['value'].' %</option>';
						}
					?>
			
				</select> 
			</div>
			<!-- <div class="col-md-2"></div> -->
           <div class="col-md-3 col-md-offset-1">: <span id="price"><label class="control-label"><?php echo number_format($total_iva,$currency_format['precision_currency'],$currency_format['decimal_separator'],$currency_format['thousand_separator']);?></label></span></div>
		</div>	
	</div>		

	 <div class="m-t-10">
       <div class="row">           
           <div class="col-md-3 col-md-offset-6">
           		<h3> <label class="control-label">TOTAL</label> </h3>
           	</div>
           <div class="col-md-3">
           		<h3>
           		 	<label class="control-label">
           		 		<?php echo number_format($total_compra,$currency_format['precision_currency'],$currency_format['decimal_separator'],$currency_format['thousand_separator']);?>
           		 			
           		 	</label>
           		 </h3>
           		 <!-- <input type="hidden" id="total" name="total"  value="<?php echo number_format($total_compra,$currency_format['precision_currency'],$currency_format['decimal_separator'],$currency_format['thousand_separator']);?>">
           		 <?php 
           		 	if (isset($_POST['total'])){

           		 		echo json_encode($total_compra);// number_format($total_compra,$currency_format['precision_currency'],$currency_format['decimal_separator'],$currency_format['thousand_separator']);
           		 	}	
           		  ?> -->

           	</div>

		</div>	
	</div>	
	
	 <!-- <form  method="post" name="save_sale" id="save_sale"> -->
    <div class="button-list pull-right">
       

                        
        <button  data-toggle="modal" data-target="#paymentModel"
         	value="<?php echo $total_compra;?>" 
          	onclick="modalPago(this.value);"
          	id="payButton"
          	 class="btn btn-success waves-effect waves-light">
                        <span class="btn-label"><i class="fa fa-money"></i></span>Pagar
        </button>
    </div>
	 <hr>