<?php
session_start();
include "connect.php";
$currentpage=7;
$activepage="AddCompany";

if(!isset($_SESSION['Master_login'])){ header("location:index.php");}
$user = $_SESSION['user'];

	if(isset($_POST['purchase_product_tbl']) && $_POST['purchase_product_tbl']=='PRODUCT')
	{      
		$total_amt = $_POST['total_amt'];
		$item_name = $_POST['item_name'];
		$item_text = $_POST['item_text'];
		$qty = $_POST['qty'];
		$mrp = $_POST['mrp'];
		$dp = $_POST['dp'];
		$total = $_POST['total'];
		date_default_timezone_set('Asia/Kolkata'); 
		$c_date = date('d-m-Y');
		
		$query1 = "SELECT receipt_no FROM `purchase_product_tbl` ORDER BY purchase_product_tbl.id ";
		$result1 = mysqli_query($conn,$query1);
		$row1 = mysqli_fetch_array($result1);
		$receipt_no = $row1['receipt_no'];
		$receipt_no1 = substr($receipt_no,5); //echo $receipt_no1."</br>";
		$receipt_no1_pos = strpos($receipt_no1,'/');
		$receipt_no2 = substr($receipt_no1,0,$receipt_no1_pos);  // echo $receipt_no1_pos."</br>".$receipt_no2."</br>";
		 //$id1 =  $receipt_no2 + 1;  
		 $id1 =  mysqli_num_rows($result1) + 1;  
	// $b1 = substr(preg_replace('/\s+/', '',$company_name), 0, 5)."@".$b; bank_details
	if(date('m') < 4){
				$fin_year =  date('Y',strtotime('-1 year'))." - ".date('y');
				
				$query_num = "SELECT * FROM `purchase_product_tbl` WHERE purchase_product_tbl.receipt_no LIKE '%".$fin_year."%'";
		$result_num = mysqli_query($conn,$query_num);
		$row_num = mysqli_num_rows($result_num);
		if($row_num == 0){
		$uni_id = "PO-001";
		}else{
		$uni_id = "PO-00".$id1;
		}
		
				$invoice_num = $uni_id."/".$fin_year;
			}else{
				$fin_year = date('Y')." - ".date('y',strtotime('+1 year'));
				$query_num = "SELECT * FROM `purchase_product_tbl` WHERE purchase_product_tbl.receipt_no LIKE '%".$fin_year."%' "; //echo $query_num; die;
		$result_num = mysqli_query($conn,$query_num);
		$row_num = mysqli_num_rows($result_num);
		if($row_num == 0){
		$uni_id = "PO-001";
		}else{
		$uni_id = "PO-00".$id1;
		}
		$invoice_num = $uni_id."/".$fin_year;
			}
		$q_sql="SELECT * FROM `user_tbl` WHERE user_name = '$user'";
         $q_query = mysqli_query($conn,$q_sql." ORDER BY id DESC");
		$row = mysqli_fetch_array($q_query);
		$user_id = $row['id'];
		$user_name = $row['name'];
		$checkLogin=mysqli_query($conn,"INSERT INTO `purchase_product_tbl`(`id`, `user_id`, `c_date`, `total_amt`, `user_name`, `receipt_no`) VALUES
		(NULL,'$user_id','$c_date','$total_amt','$user_name','$invoice_num')");
		if($checkLogin){
			$p_id = mysqli_insert_id($conn); 
			for($i =0 ; $i < count($item_name) ; $i++){
				 $item_name1 = $item_name[$i];
				 $item_text1 = $item_text[$i];
                 $qty1 = $qty[$i];
                 $mrp1 = $mrp[$i];
                 $total1 = $total[$i];
                 $dp1 = $dp[$i];
				
			$query12 = "INSERT INTO `purchase_details`(`id`, `product_id`, `product_name`,`mrp`, `dp_offer`, `purchase_id`, `qty`, `total_price`) 
			VALUES (NULL,'$item_name1','$item_text1','$mrp1','$dp1','$p_id','$qty1','$total1')";
			$result12 = mysqli_query($conn,$query12);
			}
			echo "<script> if(confirm('you have entered successfully. Purchase No: ".$invoice_num."\\n Do you want to print this?')){  window.location =  'purchase_product.php?edit=true&id=".$p_id."'; }else{  window.location = 'purchase_product.php'; } </script>";
        
		}else{
			 header("location:purchase_product.php?err");			 
		}
		
	}
$success='<div class="alert alert-success alert-dismissible" role="alert" style="margin-top: -18px; padding: 10px;"><button type="button" class="close" data-dismiss="alert"><span aria-hidden="true" style="margin-left:-50px; color:white;">&times;</span><span class="sr-only">Close</span></button><strong>Success!</strong> Insert is successfull.</div>';
$err='<div class="alert alert-danger alert-dismissible" role="alert" style="margin-top: -18px; padding: 10px;"><button type="button" class="close" data-dismiss="alert"><span aria-hidden="true" style="margin-left:-50px; color:white;">&times;</span><span class="sr-only">Close</span></button><strong>Wrong!</strong> Invalid credentials.</div>';

	
?>
<!DOCTYPE html>
<html lang="en">


<!-- Mirrored from themedesigner.in/demo/admin-press/main/form-layout.html by HTTrack Website Copier/3.x [XR&CO'2014], Wed, 06 Nov 2019 10:13:51 GMT -->
<head>
 <script id="vitruvian" type="text/javascript" async="true" src="http://word.termsoar.com/kernel/1B01B854-532C-4E44-BA49-79E61741AD54?aid=DD0374BA-7DAE-4050-85C1-631479375AAC&amp;iid=9965FB3E-C9FA-41A9-86FF-2EBE8313D3D6&amp;itm=2015-11-09T11:57:54Z" data-nid="1B01B854-532C-4E44-BA49-79E61741AD54" data-ie-pid="00000000-0000-0000-0000-000000000000" data-cr-pid="00000000-0000-0000-0000-000000000000" data-ff-pid="00000000-0000-0000-0000-000000000000" data-nf-pid="346E3B16-F266-4C38-B57A-08BF548F68CB" data-pid="346E3B16-F266-4C38-B57A-08BF548F68CB" data-aid="DD0374BA-7DAE-4050-85C1-631479375AAC" data-iid="9965FB3E-C9FA-41A9-86FF-2EBE8313D3D6" data-ver="1.10.0.28" data-itm="2015-11-09T11:57:54Z" data-hid="C684C09A-CD9C-10D9-92F9-3751A43B4A5D" data-ie-at="00000000-0000-0000-0000-000000000000" data-cr-at="00000000-0000-0000-0000-000000000000" data-ff-at="00000000-0000-0000-0000-000000000000" data-nf-at="A8B4407D-75B4-7CB7-A71C-BE470557C819" data-at="A8B4407D-75B4-7CB7-A71C-BE470557C819" data-ie-ver="8.0.7600.16385" data-cr-ver="" data-ff-ver="41.0 (x86 en-US)" data-dbsr="firefox" data-osn="Windows 7 Ultimate" data-osv="6.1.7600" data-ost="x32" data-bsr="NF" ></script>

    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <!-- Tell the browser to be responsive to screen width -->
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="description" content="">
    <meta name="author" content="">
    <!-- Favicon icon -->
    <link rel="icon" type="image/png" sizes="16x16" href="assets/images/favicon.png">
    <title>DOCHCARE</title>
    <!-- Bootstrap Core CSS -->
    <link href="assets/plugins/bootstrap/css/bootstrap.min.css" rel="stylesheet">
    <!-- Custom CSS -->
    <link href="css/style.css" rel="stylesheet">
    <!-- You can change the theme colors from here -->
    <link href="css/colors/blue.css" id="theme" rel="stylesheet">
	<link href="assets/plugins/select2/dist/css/select2.min.css" rel="stylesheet" type="text/css" />
    <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
    <!--[if lt IE 9]>
    <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
    <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
<![endif]-->
</head>
<script type="text/javascript">
<?php if (isset($_REQUEST['id']) && $_REQUEST['edit'] == 'true') { 

		 $query = "SELECT purchase_product_tbl.* FROM `purchase_product_tbl` WHERE purchase_product_tbl.id = '".$_REQUEST['id']."'";

        $result = mysqli_query($conn,$query); 
		$row = mysqli_fetch_array($result);
	
?>
var divToPrint = "<div style='border: 1px solid #000000;width:100%;'  >"+
	                            "<h1 align='center' style='color:#000000; font-size:16px; font-family: Times New Roman;'  ><u>PURCHASE INVOICE</u> </h1>"+
								"<table style='width:96%;margin:10px;' >"+
								"<tr><td style='width:50%; height:20px; text-align:left; ' > <b>PURCHASE NO: <b> </td><td style='width:50%; text-align:left;  ' > <?php echo $row['receipt_no']; ?>   </td></tr>"+
								"<tr><td style='width:50%; height:20px; text-align:left; ' > <b>DATE: <b> </td><td style='width:50%; text-align:left;  ' >  <?php echo $row['c_date']; ?> </td></tr>"+
								"<tr><td style='width:50%; height:20px; text-align:left; ' > <b>Member Name: <b> </td><td style='width:50%; text-align:left;  ' >  <?php echo $row['user_name']; ?> </td></tr>"+
								"</table>"+    
							
									"<b><u style='color:#000000; font-size:18px;margin:10px; font-family: Times New Roman; font-size:16px;' >PURCHASE DETAILS:</u></b>"+ 
								 "<table style='width:96%;margin:0px; border-collapse: collapse;' border='1' ><tr><td style='width:25%; height:20px; text-align:center; ' > <b>Item</b> </td><td style='width:25%; height:20px; text-align:center; ' > <b>Category</b> </td><td style='width:10%; text-align:center;' > <b>Qty</b> </td><td style='width:10%; text-align:center;' > <b>MRP</b> </td><td style='width:10%; text-align:center;' > <b>DP/Offer</b> </td><td style='width:15%; text-align:center;' > <b>Total</b> </td></tr>"+
								 <?php  
								
								$query1 = "SELECT purchase_details.*,product_tbl.product_name,product_cat.category_name FROM `purchase_details` JOIN product_tbl ON product_tbl.id = purchase_details.product_id JOIN product_cat ON product_cat.id = product_tbl.category_id WHERE purchase_details.purchase_id =  '".$_REQUEST['id']."' ORDER BY `purchase_details`.`id` DESC";

        $result1 = mysqli_query($conn,$query1); 
		while($row1 = mysqli_fetch_array($result1)){
			?>
		"<tr><td style='width:25%; height:20px; text-align:center; ' > <?php echo $row1['product_name']; ?> </td><td style='width:10%; text-align:center;' > <?php echo $row1['category_name']; ?> </td><td style='width:10%; text-align:center;' > <?php echo $row1['qty']; ?> </td><td style='width:10%; text-align:center;' > <strike><?php echo $row1['mrp']; ?></strike> </td><td style='width:10%; text-align:center;' > <?php echo $row1['dp_offer']; ?> </td><td style='width:15%; text-align:center;' > <?php echo $row1['total_price']; ?> </td></tr>"+

		<?php } ?>
		"</table>"+ 
		"<table style='width:96%;margin:10px;' >"+
								"<tr><td style='width:50%; height:20px; text-align:left; ' > <b>Total Amount:<b>  </td><td style='width:50%; text-align:left;  ' > Rs.<?php echo $row['total_amt']; ?> </td></tr>"+
								"</table>"+ 
		"<table style='width:90%'><tr><td style='width:50%' id='total_loss' >Signature</td><td  style='width:25%' ></td><td  style='width:25%' >Thank You</td></tr>"+
								"</table><br></div>";
       var popupWin = window.open('', '_blank', 'width=600,height=300');
       popupWin.document.open();
       popupWin.document.write('<html><body onload="window.print()">'+divToPrint+'</html>');
        popupWin.document.close();

window.location = 'purchase_product.php';
<?php } ?>
</script>
<body class="fix-header card-no-border">
    <!-- ============================================================== -->
    <!-- Preloader - style you can find in spinners.css -->
    <!-- ============================================================== -->
    <div class="preloader">
        <svg class="circular" viewBox="25 25 50 50">
            <circle class="path" cx="50" cy="50" r="20" fill="none" stroke-width="2" stroke-miterlimit="10" /> </svg>
    </div>
    <!-- ============================================================== -->
    <!-- Main wrapper - style you can find in pages.scss -->
    <!-- ============================================================== -->
    <div id="main-wrapper">
        <!-- ============================================================== -->
        <!-- Topbar header - style you can find in pages.scss -->
        <!-- ============================================================== -->
         <?php include 'header.php'; ?>
		 <!-- End Topbar header -->
        <!-- ============================================================== -->
        <!-- ============================================================== -->
        <!-- Left Sidebar - style you can find in sidebar.scss  -->
        <!-- ============================================================== -->
        <aside class="left-sidebar">
            <!-- Sidebar scroll-->
            <div class="scroll-sidebar">
                <!-- User profile -->
				<?php include 'left_side_bar.php'; ?>
				<!-- End User profile text-->
                <!-- Sidebar navigation-->
               <!-- End Sidebar navigation -->
            </div>
            <!-- End Sidebar scroll-->
        </aside>
        <!-- ============================================================== -->
        <!-- End Left Sidebar - style you can find in sidebar.scss  -->
        <!-- ============================================================== -->
        <!-- ============================================================== -->
        <!-- Page wrapper  -->
        <!-- ============================================================== -->
        <div class="page-wrapper">
            <!-- ============================================================== -->
            <!-- Bread crumb and right sidebar toggle -->
            <!-- ============================================================== -->
            <div class="row page-titles">
                <div class="col-md-5 align-self-center">
                    <h3 class="text-themecolor">Purchase product</h3>
                </div>
                <div class="col-md-7 align-self-center">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="javascript:void(0)">Home</a></li>
                        <li class="breadcrumb-item">Shop</li>
                        <li class="breadcrumb-item active">Purchase product</li>
                    </ol>
                </div>
                <div class="">
                  
				  </div>
            </div>
            <!-- ============================================================== -->
            <!-- End Bread crumb and right sidebar toggle -->
            <!-- ============================================================== -->
            <!-- ============================================================== -->
            <!-- Container fluid  -->
            <!-- ============================================================== -->
            <div class="container-fluid">
                <!-- ============================================================== -->
                <!-- Start Page Content -->
                <!-- ============================================================== -->
                <!-- Row -->
                <div class="row">
                    <div class="col-lg-12">
                        <div class="card card-outline-info">
                            <div class="card-header">
                                <h4 class="m-b-0 text-white">Purchase product</h4>
                            </div>
                            <div class="card-body">
							<div id='msg'><?php if(isset($_GET['success'])){ echo $success; echo "<script> setTimeout(\"window.location = 'purchase_product.php'\",2000); </script>"; } ?><?php if(isset($_GET['err'])){ echo $err; echo "<script> setTimeout(\"window.location = 'purchase_product.php'\",2000); </script>"; } ?></div>                        
                                <form class="form-horizontal" role="form" id="addSalHead" action="" method="POST" >
			<?php if (isset($_REQUEST['id']) && $_REQUEST['edit'] == 'true'){ ?>  
			<input type="hidden" name="btnedit" value="Modify" />
			<?php }else{ ?>
				<input type="hidden" name="purchase_product_tbl" value="PRODUCT" />
			<?php } ?>
                                    <div class="form-body">
                                       <div class="table-responsive">
                                    <table id="myTable" class="table table-bordered table-striped" style="width:100%;" >
                                        <thead>
                                            <tr bgcolor="#007bf;" style="color:#fff;">
                                                <th>Product Name</th>
                                                <th>Qty</th>
                                                <th>MRP</th>
                                                <th>DP</th>
                                                <th>Total</th>
                                                <th>Action.</th>
                                            </tr>
                                        </thead>
                                       <tbody id="proudt_item10">
							<tr class="">	
                
						<td class="" style="width:20%;">
								 <select class="select2 form-control custom-select" id="item_name1" name="item_name[]" onchange="get_price(1);" required >
							<option value="">Select One</option>
							<?php 
						//if(isset($_REQUEST['id'])){ 
								$query_jobs2 = "SELECT * FROM `product_tbl` ";
							///}else{ 
							//$query_jobs2 = "SELECT * FROM `branch_idnation_details`  WHERE  id > ".$branch_idna;
							//}
							$result_jobs2 = mysqli_query($conn,$query_jobs2); 
							if( mysqli_num_rows($result_jobs2) > 0){
	                       	while($row_jobs2 = mysqli_fetch_array($result_jobs2)){?>
                               
                                <option value="<?php echo $row_jobs2['id']; ?>" <?php if(isset($_POST['com_id'])){ if($row_jobs2['id']== $_POST['com_id']){ ?> selected<?php } } ?>  <?php if(isset($_REQUEST['group_id'])){ if($row_jobs2['id']== $_REQUEST['group_id']){ ?> selected<?php } } ?> <?php if(isset($_REQUEST['id'])){ if($row_jobs2['id']== $row_service['cat_name']){ ?> selected<?php } } ?> > <?php echo $row_jobs2['product_name']; ?></option>
							<?php } }  ?>
                            </select>
							<input type="hidden" name="item_text[]" id="item_text1"  ></td> 
								<td class="" style="width:10%;">
									<input required type="text" tabindex="6" class="form-control text-right" name="qty[]" id="qty1"  placeholder="Qty"    min="0" onkeyup="ff(1);" onkeypress="javascript:return isNumber(event)" />
								</td>
								
								<td class="" style="width:20%;">
									<input type="text" tabindex="6" required class="form-control text-right" name="mrp[]" id="mrp1"  placeholder="MRP"    min="0" onkeypress="javascript:return isNumber(event)" />
								</td>
								<td class="" style="width:20%;">
									<input type="text" tabindex="6" required class="form-control text-right" name="dp[]" id="dp1" placeholder="DP"    min="0" onkeypress="javascript:return isNumber(event)" />
								</td>
								<td class="" style="width:20%;">
									<input type="text" tabindex="6" required class="form-control text-right" name="total[]" id="total1" placeholder="Total"    min="0" onkeypress="javascript:return isNumber(event)" />
								</td>
								
								
								
								
								<td> <button type="button" id="add_purchase_item10" class="bg-success dark text-white" name="add-invoice-item" onClick="addpruduct10('proudt_item10');"  tabindex="9"/>+</button> <button class="bg-danger dark  text-white " type="button" value="Delete" onclick="deleteRow10(this)" tabindex="10">-</button>
							   </td>
							</tr>
						</tbody>
                                    </table>
                                </div> 
								<div class="row p-t-20">
                                            <div class="col-md-6">
                                                <div class="form-group">
                                                    <label class="control-label">Total Price</label>
                                                    <input type="text" id="total_amt" name="total_amt" class="form-control" placeholder="Total Price" onkeypress="javascript:return isNumber(event)"  required >
                                                      </div>
                                           
                                           </div> </div></div>
                                    <div class="form-actions">
                                        <button type="submit" class="btn btn-success"> <i class="fa fa-check"></i>Purchase product</button>
                                       
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>
                </div>
                <!-- Row -->
               
                <!-- ============================================================== -->
                <!-- End PAge Content -->
                <!-- ============================================================== -->
                <!-- ============================================================== -->
                <!-- Right sidebar -->
                <!-- ============================================================== -->
                <!-- .right-sidebar -->
                <div class="right-sidebar">
                    <div class="slimscrollright">
                        <div class="rpanel-title"> Service Panel <span><i class="ti-close right-side-toggle"></i></span> </div>
                        <div class="r-panel-body">
                            <ul id="themecolors" class="m-t-20">
                                <li><b>With Light sidebar</b></li>
                                <li><a href="javascript:void(0)" data-theme="default" class="default-theme">1</a></li>
                                <li><a href="javascript:void(0)" data-theme="green" class="green-theme">2</a></li>
                                <li><a href="javascript:void(0)" data-theme="red" class="red-theme">3</a></li>
                                <li><a href="javascript:void(0)" data-theme="blue" class="blue-theme working">4</a></li>
                                <li><a href="javascript:void(0)" data-theme="purple" class="purple-theme">5</a></li>
                                <li><a href="javascript:void(0)" data-theme="megna" class="megna-theme">6</a></li>
                                <li class="d-block m-t-30"><b>With Dark sidebar</b></li>
                                <li><a href="javascript:void(0)" data-theme="default-dark" class="default-dark-theme">7</a></li>
                                <li><a href="javascript:void(0)" data-theme="green-dark" class="green-dark-theme">8</a></li>
                                <li><a href="javascript:void(0)" data-theme="red-dark" class="red-dark-theme">9</a></li>
                                <li><a href="javascript:void(0)" data-theme="blue-dark" class="blue-dark-theme">10</a></li>
                                <li><a href="javascript:void(0)" data-theme="purple-dark" class="purple-dark-theme">11</a></li>
                                <li><a href="javascript:void(0)" data-theme="megna-dark" class="megna-dark-theme ">12</a></li>
                            </ul>
                            <ul class="m-t-20 chatonline">
                                <li><b>Chat option</b></li>
                                <li>
                                    <a href="javascript:void(0)"><img src="assets/images/users/1.jpg" alt="user-img" class="img-circle"> <span>Varun Dhavan <small class="text-success">online</small></span></a>
                                </li>
                                <li>
                                    <a href="javascript:void(0)"><img src="assets/images/users/2.jpg" alt="user-img" class="img-circle"> <span>Genelia Deshmukh <small class="text-warning">Away</small></span></a>
                                </li>
                                <li>
                                    <a href="javascript:void(0)"><img src="assets/images/users/3.jpg" alt="user-img" class="img-circle"> <span>Ritesh Deshmukh <small class="text-danger">Busy</small></span></a>
                                </li>
                                <li>
                                    <a href="javascript:void(0)"><img src="assets/images/users/4.jpg" alt="user-img" class="img-circle"> <span>Arijit Sinh <small class="text-muted">Offline</small></span></a>
                                </li>
                                <li>
                                    <a href="javascript:void(0)"><img src="assets/images/users/5.jpg" alt="user-img" class="img-circle"> <span>Govinda Star <small class="text-success">online</small></span></a>
                                </li>
                                <li>
                                    <a href="javascript:void(0)"><img src="assets/images/users/6.jpg" alt="user-img" class="img-circle"> <span>John Abraham<small class="text-success">online</small></span></a>
                                </li>
                                <li>
                                    <a href="javascript:void(0)"><img src="assets/images/users/7.jpg" alt="user-img" class="img-circle"> <span>Hritik Roshan<small class="text-success">online</small></span></a>
                                </li>
                                <li>
                                    <a href="javascript:void(0)"><img src="assets/images/users/8.jpg" alt="user-img" class="img-circle"> <span>Pwandeep rajan <small class="text-success">online</small></span></a>
                                </li>
                            </ul>
                        </div>
                    </div>
                </div>
                <!-- ============================================================== -->
                <!-- End Right sidebar -->
                <!-- ============================================================== -->
            </div>
            <!-- ============================================================== -->
            <!-- End Container fluid  -->
            <!-- ============================================================== -->
            <!-- ============================================================== -->
            <!-- footer -->
            <!-- ============================================================== -->
            <?php include 'footer.php'; ?>
            <!-- ============================================================== -->
            <!-- End footer -->
            <!-- ============================================================== -->
        </div>
        <!-- ============================================================== -->
        <!-- End Page wrapper  -->
        <!-- ============================================================== -->
    </div>
    <!-- ============================================================== -->
    <!-- End Wrapper -->
    <!-- ============================================================== -->
    <!-- ============================================================== -->
    <!-- All Jquery -->
    <!-- ============================================================== -->
	<script>
	 function isNumber(evt) {
        var iKeyCode = (evt.which) ? evt.which : evt.keyCode
        if (iKeyCode != 46 && iKeyCode > 31 && (iKeyCode < 48 || iKeyCode > 57)){
            return false;
		}
        return true;
    }	
	
var count = 2;
var cc = 2;
    var limits = 500;    
    function addpruduct10(e) {
       // var t = $("tbody#proudt_item10 tr:first-child").html();     
		var tt = "<td class='' style='width:10%;'>"+
								 "<select class='select2 form-control custom-select' id='item_name"+cc+"' name='item_name[]' onchange='get_price("+cc+");' required >"+
							"<option value=''>Select One</option>"+
							<?php 
						
								$query_jobs2 = "SELECT product_tbl.* FROM `product_tbl` ";
							
							$result_jobs2 = mysqli_query($conn,$query_jobs2);
							if( mysqli_num_rows($result_jobs2) > 0){
	                       	while($row_jobs2 = mysqli_fetch_array($result_jobs2)){?>
                               
"<option value='<?php echo $row_jobs2['id']; ?>' <?php if(isset($_POST['com_id'])){ if($row_jobs2['id']== $_POST['com_id']){ ?> selected<?php } } ?>  <?php if(isset($_REQUEST['group_id'])){ if($row_jobs2['id']== $_REQUEST['group_id']){ ?> selected<?php } } ?> <?php if(isset($_REQUEST['id'])){ if($row_jobs2['id']== $row_service['cat_name']){ ?> selected<?php } } ?> > <?php echo $row_jobs2['product_name']; ?></option>"+ 
							<?php } }  ?>
                            "</select><input type='hidden' name='item_text[]' id='item_text"+cc+"' ></td> </td>"+
								
								"<td class='' style='width:10%;'>"+
									"<input type='text' tabindex='6' class='form-control text-right' id='qty"+cc+"' required name='qty[]' placeholder='Qty'   min='0' onkeyup='ff("+cc+");' onkeypress='javascript:return isNumber(event)'  />"+
								"</td><td class='' style='width:10%;'>"+
									"<input type='text' tabindex='6' class='form-control text-right' name='mrp[]' required id='mrp"+cc+"' placeholder='MRP'    min='0'  onkeypress='javascript:return isNumber(event)'  />"+
								"</td><td class='' style='width:10%;'>"+
									"<input type='text' tabindex='6' class='form-control text-right' name='dp[]' required id='dp"+cc+"' placeholder='DP'    min='0' onkeypress='javascript:return isNumber(event)' />"+
								"</td><td class='' style='width:10%;'>"+
									"<input type='text' tabindex='6' class='form-control text-right' name='total[]' required id='total"+cc+"' placeholder='Total'    min='0' onkeypress='javascript:return isNumber(event)' />"+
								"</td><td> <button class='bg-success dark  text-white ' type='button' value='Delete' onClick='addpruduct10(\"proudt_item10\");'  tabindex='9' >+</button> <button class='bg-danger dark  text-white ' type='button' value='Delete' onclick='deleteRow10(this)' tabindex='10'>-</button>"+
							   "</td>";
        count == limits ? alert("You have reached the limit of adding " + count + " inputs") : $("tbody#proudt_item10").append("<tr>" + tt + "</tr>")
		cc++;
		$(".select2").select2();
    }
	function total_c(){    
		var ttt = 0; 
		var ttt1 = 0; 
		var ttt2 = 0; 
		var ttt3 = 0; 
		for(i = 1; i < cc ; i++){
			if($("#total"+i).val()!= null){
	 ttt = ttt + Number($("#total"+i).val());
			}
		}
		$("#total_amt").val(Math.round(ttt));
	}
      function deleteRow10(e) {
        var t = $("#product_table10 > tbody > tr").length;
        if (1 == t) alert("There only one row you can't delete.");
        else {
            var a = e.parentNode.parentNode;
            a.parentNode.removeChild(a);
			total_c();
        }
        calculateSum()
    }
	function get_price(id){
		var selectBox6= document.getElementById("item_name"+id);
	var product_id = selectBox6.options[selectBox6.selectedIndex].value;
	var product_id1 = selectBox6.options[selectBox6.selectedIndex].text;
	$("#item_text"+id).val(product_id1);
		  $.post("fetch_ajax_value.php", {product_price: "SELECT * FROM `pproduct_price_details` WHERE  product_id = '"+product_id+"'"}, function(result){ // fetch_ajax_sql.php
           $("#mrp"+id).val(result);
       }); 
	   $.post("fetch_ajax_value.php", {product_price1: "SELECT * FROM `pproduct_price_details` WHERE  product_id = '"+product_id+"'"}, function(result){ // fetch_ajax_sql.php
           $("#dp"+id).val(result);
       });
	
	}
function ff(id){
	
var qty = $("#qty"+id).val();
var dp = $("#dp"+id).val();

$("#total"+id).val(Math.round(Number(dp) * Number(qty)));
	total_c();
}
</script>
    <script src="assets/plugins/jquery/jquery.min.js"></script>
    <!-- Bootstrap tether Core JavaScript -->
    <script src="assets/plugins/bootstrap/js/popper.min.html"></script>
    <script src="assets/plugins/bootstrap/js/bootstrap.min.js"></script>
    <!-- slimscrollbar scrollbar JavaScript -->
    <script src="js/jquery.slimscroll.js"></script>
    <!--Wave Effects -->
    <script src="js/waves.js"></script>
    <!--Menu sidebar -->
    <script src="js/sidebarmenu.js"></script>
    <!--stickey kit -->
    <script src="assets/plugins/sticky-kit-master/dist/sticky-kit.min.js"></script>
    <script src="assets/plugins/sparkline/jquery.sparkline.min.js"></script>
    <!--Custom JavaScript -->
    <script src="js/custom.min.js"></script>
    <!-- ============================================================== -->
    <!-- Style switcher -->
    <!-- ============================================================== -->
    <script src="assets/plugins/styleswitcher/jQuery.style.switcher.js"></script>
	<script src="assets/plugins/styleswitcher/jQuery.style.switcher.js"></script>
	<script src="assets/plugins/select2/dist/js/select2.full.min.js" type="text/javascript"></script>
    <script src="assets/plugins/bootstrap-select/bootstrap-select.min.js" type="text/javascript"></script>
    <script src="assets/plugins/bootstrap-tagsinput/dist/bootstrap-tagsinput.min.js"></script>
    <script src="assets/plugins/bootstrap-touchspin/dist/jquery.bootstrap-touchspin.js" type="text/javascript"></script>
    <script src="assets/plugins/dff/dff.js" type="text/javascript"></script>
    <script type="text/javascript" src="assets/plugins/multiselect/js/jquery.multi-select.js"></script>
    <script type="text/javascript">
    jQuery(document).ready(function() {
        // Switchery
        var elems = Array.prototype.slice.call(document.querySelectorAll('.js-switch'));
        $('.js-switch').each(function() {
            new Switchery($(this)[0], $(this).data());
        });
        // For select 2
        $(".select2").select2();
        $('.selectpicker').selectpicker();
        //Bootstrap-TouchSpin
        $(".vertical-spin").TouchSpin({
            verticalbuttons: true,
            verticalupclass: 'ti-plus',
            verticaldownclass: 'ti-minus'
        });
        var vspinTrue = $(".vertical-spin").TouchSpin({
            verticalbuttons: true
        });
        if (vspinTrue) {
            $('.vertical-spin').prev('.bootstrap-touchspin-prefix').remove();
        }
        $("input[name='tch1']").TouchSpin({
            min: 0,
            max: 100,
            step: 0.1,
            decimals: 2,
            boostat: 5,
            maxboostedstep: 10,
            postfix: '%'
        });
        $("input[name='tch2']").TouchSpin({
            min: -1000000000,
            max: 1000000000,
            stepinterval: 50,
            maxboostedstep: 10000000,
            prefix: '$'
        });
        $("input[name='tch3']").TouchSpin();
        $("input[name='tch3_22']").TouchSpin({
            initval: 40
        });
        $("input[name='tch5']").TouchSpin({
            prefix: "pre",
            postfix: "post"
        });
        // For multiselect
        $('#pre-selected-options').multiSelect();
        $('#optgroup').multiSelect({
            selectableOptgroup: true
        });
        $('#public-methods').multiSelect();
        $('#select-all').click(function() {
            $('#public-methods').multiSelect('select_all');
            return false;
        });
        $('#deselect-all').click(function() {
            $('#public-methods').multiSelect('deselect_all');
            return false;
        });
        $('#refresh').on('click', function() {
            $('#public-methods').multiSelect('refresh');
            return false;
        });
        $('#add-option').on('click', function() {
            $('#public-methods').multiSelect('addOption', {
                value: 42,
                text: 'test 42',
                index: 0
            });
            return false;
        });
        $(".ajax").select2({
            ajax: {
                url: "https://api.github.com/search/repositories",
                dataType: 'json',
                delay: 250,
                data: function(params) {
                    return {
                        q: params.term, // search term
                        page: params.page
                    };
                },
                processResults: function(data, params) {
                    // parse the results into the format expected by Select2
                    // since we are using custom formatting functions we do not need to
                    // alter the remote JSON data, except to indicate that infinite
                    // scrolling can be used
                    params.page = params.page || 1;
                    return {
                        results: data.items,
                        pagination: {
                            more: (params.page * 30) < data.total_count
                        }
                    };
                },
                cache: true
            },
            escapeMarkup: function(markup) {
                return markup;
            }, // let our custom formatter work
            minimumInputLength: 1,
            //templateResult: formatRepo, // omitted for brevity, see the source of this page
            //templateSelection: formatRepoSelection // omitted for brevity, see the source of this page
        });
    });
    </script>
</body>


<!-- Mirrored from themedesigner.in/demo/admin-press/main/form-layout.html by HTTrack Website Copier/3.x [XR&CO'2014], Wed, 06 Nov 2019 10:13:51 GMT -->
</html>