<?php
session_start();
include('inc/connection.php');
if(!isset($_SESSION['user_id']))
{
    header('Location: login.php');
}
$menu=3;


require_once("dbcontroller.php");
$db_handle = new DBController();
$query ="SELECT * FROM superquote_categorias ";
$results = $db_handle->runQuery($query);


?>


<!DOCTYPE html>

<html lang="en">
<!--<![endif]-->
<!-- BEGIN HEAD -->
<head>
<?php
foreach($results as $cat) {
	$parent = $cat["parent"];
	$cat_desc = "";
		$chk_prod ="SELECT * FROM productos where categoria_id ='".$cat["id"]."' LIMIT 1";
		$chk_prod_q = $db_handle->runQuery($chk_prod);
		if ($chk_prod_q != ""){
		
	while ($parent > 0){
		
		$query ="SELECT * FROM superquote_categorias where id ='".$parent."'";
		$sub_cat = $db_handle->runQuery($query);
		foreach($sub_cat as $subcat) {
		$parent = $subcat["parent"];
		$cat_desc = $subcat["desc"]."/".$cat_desc;
		}
		
	}
	$cat_desc = $cat_desc.$cat['desc'];

$options .='<option value="'. $cat["id"].'">'.$cat_desc.'</option>';

}}
?>

<script src="https://code.jquery.com/jquery-2.1.1.min.js" type="text/javascript"></script>
<script>
function getProducts(val, val2) {
	$.ajax({
	type: "POST",
	url: "get_product.php",
	data:'categoria_id='+val,
	success: function(data){
		$("#product-list_"+val2).html(data);
		$("#product-list_"+val2).show();
		$("#product-list_"+val2).prop('disabled', false);
		$("#cant_"+val2).show();
		$("#cant_"+val2).prop('disabled', false);
	}
	});
	
	
}

function selectCountry(val) {
$("#search-box").val(val);
$("#suggesstion-box").hide();
}


function getProductPrice(val1,val2) {
			
			producto_viejo = $("#prod_price_"+val2).val();
			if (producto_viejo > 0){
			total = $("#TOTAL").val();
			$("#prod_price_"+val2).val("0");
			$("#TOTAL").val(parseFloat(total) - parseFloat(producto_viejo));
			
			total = parseFloat($("#TOTAL").val());
	
	
			document.getElementById("div_total").innerHTML = "U$S " + parseFloat(total).toFixed(2);
			}
	$.ajax({
	type: "POST",
	url: "get_product_data.php",
	data:'id='+val1+'&row_num='+val2,
	dataType: 'json',
	success: function(data){
	
	
		$("#prod_price_"+val2).val(data[0]["precio"]);
		$("#price_unit"+val2).val(data[0]["precio"]);
		total = parseFloat($("#TOTAL").val()) + parseFloat(data[0]["precio"]);
				$("#TOTAL").val(parseFloat(total));
		
			
			document.getElementById("div_total").innerHTML = "U$S " + parseFloat(total).toFixed(2);
			
		
		//  document.getElementById("div_stotal").innerHTML = "U$S " + parseFloat(parseFloat(total) + parseFloat(data[0]["precio"])).toFixed(2);
		
	}
	});
	
	
}

function setCantidad(val1,val2) {
	producto_viejo = $("#prod_price_"+val2).val();
	//cant_viejo = $("#cant_"+val2).val();
			if (producto_viejo > 0){
			total = $("#TOTAL").val();
			$("#prod_price_"+val2).val("0");
			$("#TOTAL").val(parseFloat(total) - parseFloat(producto_viejo));
			total = parseFloat($("#TOTAL").val());
	
	
		

			document.getElementById("div_total").innerHTML = "U$S " + parseFloat(total).toFixed(2);
			}
	
	
	
	total = $("#TOTAL").val();
	
	//$("#TOTAL").val(parseFloat(total) - parseFloat(producto_viejo));
	
	total = $("#TOTAL").val();

	
	
	price_unit = $("#price_unit"+val2).val();
	precio_total = price_unit * val1;
	
	
	$("#prod_price_"+val2).val(parseFloat(precio_total).toFixed(2));
	$("#TOTAL").val(parseFloat(total) + parseFloat(precio_total));
	

	document.getElementById("div_total").innerHTML = "U$S " + parseFloat(total).toFixed(2);
	
		
		
}


function add_fields() {    
document.getElementById("presu").insertRow(-1).innerHTML = '<tr><td><select name="country" id="category-list_2" class="demoInputBox" onChange="getProducts(this.value, 2);"><option value="">Seleccione categoria</option><?php echo $options; ?></select></td><td><select name="state" id="product-list_2" onChange="getProductPrice(this.value, 2)"><option value="">Producto</option></select></td><td><input id="prod_price_2" type="text" value="" disabled></td></tr>';
}



</script>

<meta charset="utf-8"/>
<title>SuperQuote |  <?php echo $_SESSION['user_id']; ?></title>
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta content="width=device-width, initial-scale=1.0" name="viewport"/>
<meta http-equiv="Content-type" content="text/html; charset=utf-8">
<meta content="" name="description"/>
<meta content="" name="author"/>
<!-- BEGIN GLOBAL MANDATORY STYLES -->
<link href="http://fonts.googleapis.com/css?family=Open+Sans:400,300,600,700&subset=all" rel="stylesheet" type="text/css">
<link href="assets/global/plugins/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href="assets/global/plugins/simple-line-icons/simple-line-icons.min.css" rel="stylesheet" type="text/css">
<link href="assets/global/plugins/bootstrap/css/bootstrap.min.css" rel="stylesheet" type="text/css">
<link href="assets/global/plugins/uniform/css/uniform.default.css" rel="stylesheet" type="text/css">
<link href="assets/global/plugins/bootstrap-switch/css/bootstrap-switch.min.css" rel="stylesheet" type="text/css"/>
<!-- END GLOBAL MANDATORY STYLES -->
<!-- BEGIN PAGE LEVEL STYLES -->
<link rel="stylesheet" type="text/css" href="assets/global/plugins/select2/select2.css"/>
<link rel="stylesheet" type="text/css" href="assets/global/plugins/datatables/plugins/bootstrap/dataTables.bootstrap.css"/>
<link rel="stylesheet" type="text/css" href="assets/global/plugins/bootstrap-datepicker/css/datepicker.css"/>
<link rel="stylesheet" type="text/css" href="assets/global/plugins/bootstrap-datetimepicker/css/bootstrap-datetimepicker.min.css"/>
<!-- END PAGE LEVEL STYLES -->
<!-- BEGIN THEME STYLES -->
<link href="assets/global/css/components.css" id="style_components" rel="stylesheet" type="text/css"/>
<link href="assets/global/css/plugins.css" rel="stylesheet" type="text/css"/>
<link href="assets/admin/layout2/css/layout.css" rel="stylesheet" type="text/css"/>
<link id="style_color" href="assets/admin/layout2/css/themes/light.css" rel="stylesheet" type="text/css"/>
<link href="assets/admin/layout2/css/custom.css" rel="stylesheet" type="text/css"/>
<!-- END THEME STYLES -->
<link rel="shortcut icon" href="favicon.ico"/>
</head>
<!-- END HEAD -->
<!-- BEGIN BODY -->
<!-- DOC: Apply "page-header-fixed-mobile" and "page-footer-fixed-mobile" class to body element to force fixed header or footer in mobile devices -->
<!-- DOC: Apply "page-sidebar-closed" class to the body and "page-sidebar-menu-closed" class to the sidebar menu element to hide the sidebar by default -->
<!-- DOC: Apply "page-sidebar-hide" class to the body to make the sidebar completely hidden on toggle -->
<!-- DOC: Apply "page-sidebar-closed-hide-logo" class to the body element to make the logo hidden on sidebar toggle -->
<!-- DOC: Apply "page-sidebar-hide" class to body element to completely hide the sidebar on sidebar toggle -->
<!-- DOC: Apply "page-sidebar-fixed" class to have fixed sidebar -->
<!-- DOC: Apply "page-footer-fixed" class to the body element to have fixed footer -->
<!-- DOC: Apply "page-sidebar-reversed" class to put the sidebar on the right side -->
<!-- DOC: Apply "page-full-width" class to the body element to have full width page without the sidebar menu -->
<body class="page-boxed page-header-fixed page-container-bg-solid page-sidebar-closed-hide-logo ">
<!-- BEGIN HEADER -->
<div class="page-header navbar navbar-fixed-top">
	<!-- BEGIN HEADER INNER -->
	<?php include('inc/header.inc.php'); ?>
	<!-- END HEADER INNER -->
</div>
<!-- END HEADER -->
<div class="clearfix">
</div>
<div class="container">
	<!-- BEGIN CONTAINER -->
	<div class="page-container">
		<!-- BEGIN SIDEBAR -->
		<?php include('inc/sidebar.inc.php'); ?>
		<!-- END SIDEBAR -->
		<!-- BEGIN CONTENT -->
		<div class="page-content-wrapper">
			<div class="page-content">
				<!-- BEGIN SAMPLE PORTLET CONFIGURATION MODAL FORM-->
			
				<!-- END SAMPLE PORTLET CONFIGURATION MODAL FORM-->
				<!-- BEGIN STYLE CUSTOMIZER -->
	
	<!-- END STYLE CUSTOMIZER -->
				<!-- BEGIN PAGE HEADER-->
				
				
				<!-- END PAGE HEADER-->
				<!-- BEGIN PAGE CONTENT-->
				<div class="row">
					<div class="col-md-12">
						<!-- Begin: life time stats -->
						<div class="portlet light">
							
							<div class="portlet-body">
								<div class="tabbable">
						
									<div class="tab-content">
										<div class="tab-pane active" id="tab_1">
											
											
											<div class="row">
												<div class="col-md-12 col-sm-12">
													<div class="portlet box blue">
														<div class="portlet-title">
															<div class="caption">
																<i class="fa fa-cogs"></i>Crear Presupuesto
															</div>
															<div class="actions">
																
															</div>
														</div>
														<div class="portlet-body">
															<div class="table-responsive">
                                                            <form target="_blank" method="post" action="print.php">
																<table class="table table-hover table-bordered table-striped">
																<thead>
																<tr>
																	<th>
																		 Category
																	</th>
																	<th>
																		 Product
																	</th>
                                                                    <th>
																		 Quantity
																	</th>
																	<th>
																		 Price
																	</th>
																	
																</tr>
																</thead>
																<tbody>
                                                                
                                                                <?php for ($i = 1; $i < 16 ; $i++){
	
	?>
<tr>
<td width="250">
<select name="category[<?php echo $i; ?>]" id="category-list_<?php echo $i; ?>" class="demoInputBox" onChange="getProducts(this.value, <?php echo $i; ?>);">
<option value="">Select Category</option>
<?php
echo $options;
?>
</select>
</td>
<td width="250">
<select class="form-control select2me" name="product[<?php echo $i; ?>][id]" id="product-list_<?php echo $i; ?>" onChange="getProductPrice(this.value, <?php echo $i; ?>)" hidden="" disabled>
<option value="">Product</option>
</select>
</td>
<td width="20">
<input id="product[<?php echo $i; ?>][cant]" name="product[<?php echo $i; ?>][cant]"type="text" value="1" onkeyup="setCantidad(this.value, <?php echo $i; ?>)"> 


</td>
<td><input id="prod_price_<?php echo $i; ?>" type="text" value="" disabled> <input id="price_unit<?php echo $i; ?>" type="text" value="0" disabled hidden=""> </td>
</tr>

<?php } ?>
                                                                
                                                                
                                                                
                                                                
                                                                
                                                              
																
																</tbody>
																</table>
                                                                <input type="submit" value="Save to PDF">
                                                                <input id="TOTAL" type="text" value="0" disabled hidden="">
                                                                <input id="stotal" type="text" value="0" disabled hidden="">
                                                                <input id="iva" type="text" value="0" disabled hidden="">
                                                       			 <input id="cant" type="text" value="10" disabled hidden="">
                                                                </form>
															</div>
														</div>
													</div>
												</div>
											</div>
											<div class="row">
												<div class="col-md-6">
												</div>
												<div class="col-md-6">
													<div class="well">
														<div class="row static-info align-reverse">
                                                     
                                                         
                                                          
															<div class="col-md-8 name">
																  Total:
															</div>
                                                            
                                                          
															<div class="col-md-3 value" id="div_total">
																 $0,00
															</div>
														</div>
														
													</div>
												</div>
											</div>
										</div>
										
										
										
										
									</div>
								</div>
							</div>
						</div>
						<!-- End: life time stats -->
					</div>
				</div>
				<!-- END PAGE CONTENT-->
			</div>
		</div>
		<!-- END CONTENT -->
		<!-- BEGIN QUICK SIDEBAR -->
		<!--Cooming Soon...-->
		<!-- END QUICK SIDEBAR -->
	</div>
	<!-- END CONTAINER -->
	<!-- BEGIN FOOTER -->
	<div class="page-footer">
		<div class="page-footer-inner">
			 2016 &copy; SuperQuote.us
		</div>
		<div class="scroll-to-top">
			<i class="icon-arrow-up"></i>
		</div>
	</div>
	<!-- END FOOTER -->
</div>
<!-- BEGIN JAVASCRIPTS(Load javascripts at bottom, this will reduce page load time) -->
<!-- BEGIN CORE PLUGINS -->
<!--[if lt IE 9]>
<script src="assets/global/plugins/respond.min.js"></script>
<script src="assets/global/plugins/excanvas.min.js"></script> 
<![endif]-->
<script src="assets/global/plugins/jquery.min.js" type="text/javascript"></script>
<script src="assets/global/plugins/jquery-migrate.min.js" type="text/javascript"></script>
<!-- IMPORTANT! Load jquery-ui-1.10.3.custom.min.js before bootstrap.min.js to fix bootstrap tooltip conflict with jquery ui tooltip -->
<script src="assets/global/plugins/jquery-ui/jquery-ui-1.10.3.custom.min.js" type="text/javascript"></script>
<script src="assets/global/plugins/bootstrap/js/bootstrap.min.js" type="text/javascript"></script>
<script src="assets/global/plugins/bootstrap-hover-dropdown/bootstrap-hover-dropdown.min.js" type="text/javascript"></script>
<script src="assets/global/plugins/jquery-slimscroll/jquery.slimscroll.min.js" type="text/javascript"></script>
<script src="assets/global/plugins/jquery.blockui.min.js" type="text/javascript"></script>
<script src="assets/global/plugins/jquery.cokie.min.js" type="text/javascript"></script>
<script src="assets/global/plugins/uniform/jquery.uniform.min.js" type="text/javascript"></script>
<script src="assets/global/plugins/bootstrap-switch/js/bootstrap-switch.min.js" type="text/javascript"></script>
<!-- END CORE PLUGINS -->
<!-- BEGIN PAGE LEVEL PLUGINS -->
<script type="text/javascript" src="assets/global/plugins/select2/select2.min.js"></script>
<script type="text/javascript" src="assets/global/plugins/datatables/media/js/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="assets/global/plugins/datatables/plugins/bootstrap/dataTables.bootstrap.js"></script>
<script type="text/javascript" src="assets/global/plugins/bootstrap-datepicker/js/bootstrap-datepicker.js"></script>
<script type="text/javascript" src="assets/global/plugins/bootstrap-datetimepicker/js/bootstrap-datetimepicker.min.js"></script>
<!-- END PAGE LEVEL PLUGINS -->
<!-- BEGIN PAGE LEVEL SCRIPTS -->
<script src="assets/global/scripts/metronic.js" type="text/javascript"></script>
<script src="assets/admin/layout2/scripts/layout.js" type="text/javascript"></script>
<script src="assets/admin/layout2/scripts/demo.js" type="text/javascript"></script>
<script src="assets/global/scripts/datatable.js"></script>
<script src="assets/admin/pages/scripts/ecommerce-orders-view.js"></script>
<!-- END PAGE LEVEL SCRIPTS -->
<script>
        jQuery(document).ready(function() {    
           Metronic.init(); // init metronic core components
Layout.init(); // init current layout
Demo.init(); // init demo features
           EcommerceOrdersView.init();
        });
    </script>
<!-- END JAVASCRIPTS -->
</body>
<!-- END BODY -->
</html>