bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

halohalo bnmbnmbnhjkhjkhjkhjktyutyutyuytutyutyutyhgjgjghjgjghjguytutyry

<?php
error_reporting (0);
include "dbc.php"; 
page_protect();
if($_POST['submit'] == "Add Purchase Order"){
$id = mysqli_real_escape_string($link,$_POST['id']);
$purchase_order_id = mysqli_real_escape_string($link,$_POST['purchase_order_id']);
$purchase_id = mysqli_real_escape_string($link,$_POST['purchase_id']);
$purchase_date = mysqli_real_escape_string($link,$_POST['purchase_order_date']);
$vendor = explode(" - ",$_POST['vendor_name']);
$vendor_id = $vendor[0];
$vendor_name = $vendor[1];
$invoice_no = mysqli_real_escape_string($link,$_POST['invoice_no']);
$sub_total = mysqli_real_escape_string($link,$_POST['sub_total']);
$tax_total = mysqli_real_escape_string($link,$_POST['tax_total']);
$transport_total = mysqli_real_escape_string($link,$_POST['transport_total']);
$discount_total = mysqli_real_escape_string($link,$_POST['discount_total']);
$grand_total = mysqli_real_escape_string($link,$_POST['grand_total']);
$payment_status = mysqli_real_escape_string($link,$_POST['payment_status']);
if(mysqli_query($link,"INSERT INTO `purchaseorder_tbl` (`id`, `purchase_order_id`, `purchase_id`, `purchase_order_date`, `vendor_id`, `vendor_name`, `sub_total`, `tax_total`, `discount_total`, `transport_total`, `grand_total`, `payment_status`, `ip_address`, `browser`, `date`) VALUES ('$id', '$purchase_order_id', '$purchase_id', '$purchase_date', '$vendor_id', '$vendor_name', '$sub_total', '$tax_total', '$discount_total', '$transport_total', '$grand_total', '$payment_status', '$ip_address', '$browser', '$date')")){
foreach($_POST['pid'] as $pid){

list($max) = mysqli_fetch_row(mysqli_query($link,"SELECT MAX(id) AS max FROM `purchaseorderdetails_tbl`"));

$max=$max+1;
$purchaseorderdetails_id="POD".$max."";
list($product_name) = mysqli_fetch_row(mysqli_query($link,"select CONCAT(product_name_en,',',product_name) as product_name from product_tbl where product_id='$pid'"));
$qty = mysqli_real_escape_string($link,$_POST['qty'.$pid]);
$price = mysqli_real_escape_string($link,$_POST['price'.$pid]);
$sprice = mysqli_real_escape_string($link,$_POST['sprice'.$pid]);
$ltotal = mysqli_real_escape_string($link,$_POST['ltotal'.$pid]);
mysqli_query($link,"INSERT INTO `purchaseorderdetails_tbl` (`id`, `purchase_order_id`, `purchase_id`, `purchase_order_date`, `purchaseorderdetails_id`, `product_id`, `product_name`, `cost_price`, `quantity`, `line_total`, `ip_address`, `browser`, `date`) VALUES ('$id', '$purchase_order_id', '$purchase_id', '$purchase_date', '$purchaseorderdetails_id', '$pid', '$product_name', '$price', '$qty', '$ltotal', '$ip_address', '$browser', '$date')");

mysqli_query($link,"UPDATE product_tbl SET `cost_price`='$price', `selling_price`='$sprice' where product_id='$pid'");    
}
$msg[] = "Successfully Saved!";
	}
	else
	{
		$err[] = "Error in saving data!";
	}
	}
//include "update_order_status.php";
//include "back_functions.php";
?>
<?php include'header.php';?>
      <div class="main-bar">
        <h3><i class="fa fa-archive"></i>&nbsp; Purchase Order</h3>
      </div>
       
    </header>
     
  </div>
  
  <?php include'admin_admin.php';?>
  
  <div id="content">
    <div class="outer">
      <div class="inner bg-light lter">
        <style>
              .form-control.col-lg-6 {
                width: 50% !important;
              }
            </style>
        <div class="row">
          <div class="col-lg-12">
            <div class="box">
             <header>
             <?php 
                $purchase_id = $_GET['purchase_id'];

list($max_id) = mysqli_fetch_row(mysqli_query($link,"SELECT MAX(id) AS max FROM `purchaseorder_tbl`"));
                
            	$max_id=$max_id+1;
            	$upload_id="purOrder-".$max_id;
             ?>
                <h5><i class="halflings-icon th"></i><span class="break"></span>Add / Update Purchase Order</h5>
                <div class="toolbar"></div>
              </header>
              <div class="row">
                <div class="col-lg-12">
                  <div class="box">
                    <div id="collapse4" class="body">
                    <?php include 'msg_display.php'?>
                    <form class="form-horizontal" method="post" enctype="multipart/form-data" action="">
                    	<div class="col-sm-12 col-md-12 productlist">
                    	    <div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad">
                    			<div class="form-group">
                    				<div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad">
                    				<label for="purchase_id">Purchase Order Id</label>
                    				</div>
                    				<div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad">
                    				<input type="text" class="form-control" name="purchase_order_id" id="purchase_order_id" placeholder="" value="<?php echo $upload_id; ?>" readonly="readonly"    >
                    				</div>
                    			</div>
                    		</div>
                    	<div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad">
			<div class="form-group">
				<div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad">
				<label for="purchase_id">Purchase Id</label>
				</div>
				<div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad">
				<input type="text" class="form-control" name="purchase_id" id="purchase_id" value="<?php echo $row->purchase_id; ?>">
				</div>
			</div>
		</div>
		<div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad">
			<div class="form-group">
				<div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad">
				<label for="purchase_order_date">Purchase Order Date</label>
				</div>
				<div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad">
				<input type="date" class="form-control" name="purchase_order_date" id="purchase_order_date" placeholder="" value="<?php echo $row->purchase_order_date; ?>" required="required">
				</div>
			</div>
		</div>
		<div class="col-lg-6 col-md-6 col-sm-12 col-xs-12 no-pad">
			<div class="form-group">
				<div class="col-lg-4 col-md-4 col-sm-12 col-xs-12 no-pad">
				<label for="vendor_name">Vendor</label>
				</div>
				<div class="col-lg-8 col-md-8 col-sm-12 col-xs-12 no-pad">
				<select class="form-control" name="vendor_name" id="vendor_name" required="required">
				    <option value="">Please Select</option>
				    <?php
				    $sel1 = mysqli_query($link,"select `vendor_name`,`vendor_id` from vendor_tbl");
				    while($row1 = mysqli_fetch_object($sel1)){ ?>
				        <option value="<?php echo $row1->vendor_id." - ".$row1->vendor_name; ?>"><?php echo $row1->vendor_id." - ".$row1->vendor_name; ?></option>
				    <?php } ?>
				</select>    
				</div>
			</div>
		</div>
		
		<br>
		<br>
                <table class="table table-bordered" style="background:#fff;">
                <thead>
                    <tr>
                    
                    <td class="label1" style="width:40%;">Product</td>
                    <td class="label2">Cost Price</td>
                    <td class="label5">Selling Price</td>
                    <td class="label3">Quantity</td>
                    <td class="label4">Line Total</td>
                    </tr>
                </thead>
                <tbody class="list">        
                <?php
                    $sel_query = mysqli_query($link,"select * from product_tbl");
					$count = mysqli_num_rows($sel_query);
                    while($row = mysqli_fetch_object($sel_query)){
                    $pid = $row->product_id;
                    
					$pname = $row->product_name." - ".$row->product_name_en;
					$cat_name = $row->cat_name." - ".$row->cat_name_en;
					$subcat_name = $row->subcat_name." - ".$row->subcat_name_en;
					$childcat_name = $row->childcat_name." - ".$row->childcat_name_en;
				
					$psize = $row->size;
					$cost_price = $row->cost_price;
                    $mrp_price = $row->mrp_price;
                    $our_price = $row->selling_price;
                    $minqty = $row->minq;
                    $maxqty = $row->maxq;
                    $savings = $mrp_price - $our_price;
				?>
                <tr class="<?php echo $pid; ?>">
                    
                    <td class="pname"><input type="checkbox" name="pid[]" id="<?php echo $pid; ?>" value="<?php echo $pid; ?>" onChange="chec('<?php echo $pid; ?>')" style="display:none;"><input type="hidden"  name="proname<?php echo $pid; ?>" id="proname<?php echo $pid; ?>" value="<?php echo $pname; ?>"><?php echo $pname; ?>
                    <?php /* <br><?php echo $cat_name; ?> - <?php echo $cat_name_en; ?>
                    <br><?php echo $subcat_name; ?> - <?php echo $subcat_name_en; ?>
                    <br><?php echo $childcat_name; ?> - <?php echo $childcat_name_en; */?>
                    </td>
                    <?php /*<td height="50" class="psize"><?php echo $psize; ?></td>*/ ?>
                    <td><input type="text" style="margin:0px;" name="price<?php echo $pid; ?>" id="price<?php echo $pid; ?>" class="form-control" value="<?php echo $cost_price; ?>"></td>
                    <td><input type="text" style="margin:0px;" name="sprice<?php echo $pid; ?>" id="sprice<?php echo $pid; ?>" class="form-control" value="<?php echo $our_price; ?>"></td>
                    <td>
					<button type="button" name="minus" id="minus" class="minus btn btn-default pull-left" onclick="qminus('<?php echo $pid; ?>')">-</button> 
					<input type="text" style="margin:0px; width:60%; text-align: center;" name="qty<?php echo $pid; ?>" id="qty<?php echo $pid; ?>" class="form-control pull-left qty" value="0">
					<button type="button" name="plus" id="plus" class="plus btn btn-default pull-left" onclick="qplus('<?php echo $pid; ?>')">+</button>
                    </td>
                    <td><input type="text" style="margin:0px;" name="ltotal<?php echo $pid; ?>" id="ltotal<?php echo $pid; ?>" class="form-control ltotal" value="0.00" readonly></td>
                </tr>
                <?php        
                    }
                ?>
                <tr>
                    <td colspan="3"></td>
                    <td>Sub Total</td>
                    <td><input type="text" class="form-control" style="border:2px #d7a748 solid;" name="sub_total" id="sub_total" value="0.00" required readonly /></td>
                </tr>
                <tr>
                    <td colspan="3"></td>
                    <td>Discount Amount</td>
                    <td><input type="text" class="form-control" style="border:2px #d7a748 solid;" name="discount_total" id="discount_total" onchange="grandtotal()" value="0.00" required /></td>
                </tr>
                <tr>
                    <td colspan="3"></td>
                    <td>Transport Amount</td>
                    <td><input type="text" class="form-control" style="border:2px #d7a748 solid;" name="transport_total" id="transport_total" onchange="grandtotal()" value="0.00" required /></td>
                </tr>
                <tr>
                    <td colspan="3"></td>
                    <td>Tax Total</td>
                    <td><input type="text" class="form-control" style="border:2px #d7a748 solid;" name="tax_total" id="tax_total" value="0.00" onchange="grandtotal()" required /></td>
                </tr>
                <tr>
                    <td colspan="3"></td>
                    <td>Grand Total</td>
                    <td><input type="text" class="form-control" style="border:2px #d7a748 solid;" name="grand_total" id="grand_total" value="0.00" required readonly /></td>
                </tr>
                <tr>
                    <td colspan="5"><center><input type="submit" name="submit" id="submit" class="btn btn-success" value="Add Purchase Order"></center></td>
                </tr>
                </tbody>
                </table>
                </div>
                    </form>
                                </div>
							</div>
						</div>
					</div>
				</div>
			
			</div>

</div>
	
			
		</div>
		</div>
		
	<div class="modal hide fade" id="myModal">
		<div class="modal-header">
			<button type="button" class="close" data-dismiss="modal">×</button>
			<h3>Settings</h3>
		</div>
		<div class="modal-body">
			<p>Here settings can be configured...</p>
		</div>
		<div class="modal-footer">
			<a href="#" class="btn" data-dismiss="modal">Close</a>
			<a href="#" class="btn btn-primary">Save changes</a>
		</div>
	</div>    
            </div>   
            </div>
                
                
                
                
                
                
                
        </div>
      </div>
      <div id="right" class="bg-light lter">
        <div class="alert alert-danger">
          <button type="button" class="close" data-dismiss="alert">&times;</button>
          <strong>Warning!</strong>  Best check yo self, you're not looking too good.
        </div>

<div class="well well-small dark">
          <ul class="list-unstyled">
            <li>Visitor <span class="inlinesparkline pull-right">1,4,4,7,5,9,10</span> 
            </li>
            <li>Online Visitor <span class="dynamicsparkline pull-right">Loading..</span> 
            </li>
            <li>Popularity <span class="dynamicbar pull-right">Loading..</span> 
            </li>
            <li>New Users <span class="inlinebar pull-right">1,3,4,5,3,5</span> 
            </li>
          </ul>
        </div>

<div class="well well-small dark">
          <button class="btn btn-block">Default</button>
          <button class="btn btn-primary btn-block">Primary</button>
          <button class="btn btn-info btn-block">Info</button>
          <button class="btn btn-success btn-block">Success</button>
          <button class="btn btn-danger btn-block">Danger</button>
          <button class="btn btn-warning btn-block">Warning</button>
          <button class="btn btn-inverse btn-block">Inverse</button>
          <button class="btn btn-metis-1 btn-block">btn-metis-1</button>
          <button class="btn btn-metis-2 btn-block">btn-metis-2</button>
          <button class="btn btn-metis-3 btn-block">btn-metis-3</button>
          <button class="btn btn-metis-4 btn-block">btn-metis-4</button>
          <button class="btn btn-metis-5 btn-block">btn-metis-5</button>
          <button class="btn btn-metis-6 btn-block">btn-metis-6</button>
        </div>

<div class="well well-small dark">
          <span>Default</span> <span class="pull-right"><small>20%</small> </span> 
          <div class="progress xs">
            <div class="progress-bar progress-bar-info" style="width: 20%"></div>
          </div>
          <span>Success</span> <span class="pull-right"><small>40%</small> </span> 
          <div class="progress xs">
            <div class="progress-bar progress-bar-success" style="width: 40%"></div>
          </div>
          <span>warning</span> <span class="pull-right"><small>60%</small> </span> 
          <div class="progress xs">
            <div class="progress-bar progress-bar-warning" style="width: 60%"></div>
          </div>
          <span>Danger</span> <span class="pull-right"><small>80%</small> </span> 
          <div class="progress xs">
            <div class="progress-bar progress-bar-danger" style="width: 80%"></div>
          </div>
        </div>
      </div>
    </div>
    <?php include'footer.php';?>
    <script>
    function qplus(product_id){
		var oldVal = $('#qty'+product_id).val();
		var newVal = (parseInt($('#qty'+product_id).val(),10) +1);
		if(newVal > 0){
			$("#"+product_id).prop('checked',true);
			$("."+product_id).css('background-color','#ccc');
		}
		else
		{
			$("#"+product_id).prop('checked',false);
			newVal = 0;
			$("."+product_id).css('background-color','#fff');
		}	
		$('#qty'+product_id).val(newVal);
		line_total(product_id);
		update_total();
	}
	function qminus(product_id){
		var oldVal = $('#qty'+product_id).val();
		var newVal = (parseInt($('#qty'+product_id).val(),10) -1);
		if(newVal > 0){
			$("#"+product_id).prop('checked',true);
			$("."+product_id).css('background-color','#ccc');
		}
		else
		{
			$("#"+product_id).prop('checked',false);
			newVal = 0;
			$("."+product_id).css('background-color','#fff');
		}
		$('#qty'+product_id).val(newVal);
		line_total(product_id);
		update_total();
	}
	
    function chec(pid){
    if($('#'+pid).is(":checked")){   
        $("#qty"+pid).prop('required',true);
    }
    else
    {
        $("#qty"+pid).prop('required',false);
    }
    }
    function line_total(product_id){
		var price = $('#price'+product_id).val();
		var qty = $('#qty'+product_id).val();
		var total = parseFloat(price) * parseFloat(qty);
		total = total.toFixed(2);
		$("#ltotal"+product_id).val(total);
	}
	function update_total() {
    var sum = 0;
    $(".ltotal").each(function(){
        sum += +$(this).val();
    });
	sum = sum.toFixed(2);
	//alert(sum);
    $("#sub_total").val(sum);
    grandtotal();
	}
	function grandtotal(){
	    var sub_total = parseFloat($("#sub_total").val());
	    var discount_total = parseFloat($("#discount_total").val());
	    var transport_total = parseFloat($("#transport_total").val());
	    var tax_total = parseFloat($("#tax_total").val());
	    var grand_total = sub_total + tax_total + transport_total - discount_total;
	    grand_total = grand_total.toFixed(2);
	    $("#grand_total").val(grand_total);
	}
    </script>