1#@!#!123s

file_get_contents 1#@!#!123s
: / home1 / namod9jo / www / numaglobal.com / numa-application /
Filename : dealer-price-tgis.php
back
<?php
include 'db/conn.php';
include 'include/header.php';
include 'preset.php';
?>
<?php
if(isset($_SESSION['login_user'])) {  
}
else
{
    print ("<meta HTTP-EQUIV=\"refresh\" content=0;url=\"index.php\">");
}
?>
<style>
input#width, input#height, input#quantity {
    width: 220px;
}
th {
    text-align: center !important;
}
input#total, input#totalsvmscadd,input#totalchkprodmadd, input#totalchksnsradd, input#totalchkdfgradd,{
    width: 100px;
	border-color: transparent !important;
    background-color: transparent !important;
	text-align: center;
}
input#h, input#w, input#qty, input#total 
{
	width: 80px;
	border-color: transparent !important;
    background-color: transparent !important;
	text-align: center;
	color: #fff;
}
input#pname
{
	width: auto;
	border-color: transparent !important;
    background-color: transparent !important;
	color: #fff;
}
td.textright {
    text-align: right !important;
}
td.textcenter{
	text-align: center;
}

input#total1, input#total2, input#totalchksnsradd1, input#totalchksnsradd2, input#totalchkdfgradd1, input#totalchkdfgradd2, input#totalsvmscadd1, input#totalsvmscadd2, input#totalchkprodmadd1, input#totalchkprodmadd2, input#totalall, input#totalalltax,input#totalallwthtax {
    border-color: transparent !important;
    background-color: transparent !important;
    text-align: center;
	color: #fff;
}
input#totalchksnsradd1, input#totalchksnsradd2, input#totalchkdfgradd1, input#totalchkdfgradd2, input#totalsvmscadd1, input#totalsvmscadd2, input#totalchkprodmadd1, input#totalchkprodmadd2{
    display: none;
}
    button.btn a{color:#fff;}
    button.btn a:hover{text-decoration:none !important;}
    button.btn:hover a{color:#000 !important;}
span#btn a {
    color: #fff;
}   
</style>
<body>
   
    <?php include 'include/head_menu1.php'; ?>
	    
   <div class="main-container container-fluid">
         <?php include 'include/left_panel.php'; ?>
        <div class="main-content" >
          <?php include 'include/breadcrumbs.php'; ?>
           <div class="page-content">
                <div class="page-header position-relative">
                    <h1>Dealer Price
                        <small>
                            <i class="icon-double-angle-right"></i>
                            
                        </small>
                    </h1>                    
                </div> 
				<form id="search_form" name="search_form" class="form-horizontal" action="" method="post" autocomplete="off">
				<div class="control-group">
                                <label class="control-label" for="cat_id">Numa Series<span class="red">*</span></label>
                                <div class="controls">
<select name='cat_id' id='cat_id' onChange="getproductf(this.value);">
																<option value="">Select Numa Series</option>
																<option value="Tydis">Numa Tydis</option>
                                                                          </select>
                                     <label for="cat_id" class="error help-inline"></label>                                                                    
                                </div>
                            </div>
                  
				<div class="control-group">
                                <label class="control-label" for="ch">Cabinet Height<span class="red">*</span></label>
                                <div class="controls">
									<select name='ch' id='ch' onChange="getproductcw(this.value);">
																<option value="">Select Cabinet Height</option>
																
                                                                          </select>
                                     <label for="ch" class="error help-inline"></label>                                                                    
                                </div>
                            </div>
                    
                    
                    <!--div class="control-group">
                                <label class="control-label" for="cw">Cabinet Width<span class="red">*</span></label>
                                <div class="controls">
									<select name='cw' id='cw' onChange="getproductcw(this.value);">
																<option value="">Select Cabinet Width</option>
																
                                                                          </select>
                                     <label for="cw" class="error help-inline"></label>                                                                    
                                </div>
                            </div-->
                    
                     <div class="control-group">
                                <label class="control-label" for="dw">Door Width<span class="red">*</span></label>
                                <div class="controls">
									<select name='dw' id='dw' onChange="getproductdw(this.value);">
																<option value="">Select Door Width</option>
																
                                                                          </select>
                                     <label for="dw" class="error help-inline"></label>                                                                    
                                </div>
                            </div>
							
                     <!--div class="control-group">
                                <label class="control-label" for="dp" >Door Panel Dimension<span class="red">*</span></label>
                                <div class="controls">
									<select name='dp' id='dp' onChange="getproductdp(this.value);">
																<option value="">Select Door Panel Dimension</option>
																
                                                                          </select>
                                     <label for="dp" class="error help-inline"></label>                                                                    
                                </div>
                            </div-->
                    
                    
                    
                    
                    
                    
							  <div class="control-group">
                                <label class="control-label" for="ndp" >Number Of Door Panel<span class="red">*</span></label>
                                <div class="controls">
									<select name='ndp' id='ndp' onChange="getproductnp(this.value);">
																<option value="">Number Of Door Panel</option>
																
                                                                          </select>
                                     <label for="ndp" class="error help-inline"></label>                                                                    
                                </div>
                            </div>
							
							 
                    
                    
                     <div class="control-group">
                                <label class="control-label" for="fp" >Fixed Panel<span class="red">*</span></label>
                                <div class="controls">
									<select name='fp' id='fp' onChange="getproductfp(this.value);">
																<option value="">Select Fixed Panel</option>
																
                                                                          </select>
                                     <label for="fp" class="error help-inline"></label>                                                                    
                                </div>
                    </div>
							
                         <div class="control-group">
                                <label class="control-label" for="fw" >Fixed Width<span class="red">*</span></label>
                                <div class="controls">
									<select name='fw' id='fw' onChange="getproductnp(this.value);">
																<option value="">Select Fixed Width</option>
																
                                                                          </select>
                                     <label for="fw" class="error help-inline"></label>                                                                    
                                </div>
                            </div>
                         
                         
                          <!--div class="control-group">
                                <label class="control-label" for="fp" >Fixed Panel (Yes/No)<span class="red">*</span></label>
                                <div class="controls">
									<select name='fpyn' id='fpyn' >
                                        <option value="-">-</option>
																<option value="Yes">Yes</option>
																<option value="No">No</option>
                                                                          </select>
                                     <label for="fpyn" class="error help-inline"></label>                                                                    
                                </div>
                    </div-->
                    
                       <div class="control-group">
                                <label class="control-label" for="quan" >Quantity<span class="red">*</span></label>
                                <div class="controls">
									<input type="text" name='quan' id='quan' >
                                        
                                     <label for="quan" class="error help-inline"></label>                                                                    
                                </div>
                    </div>
           <strong>Note :</strong> Currently you can add only two products at a time.
							<div class="clearfix"></div>
                                                        <div class="form-actions">
                                                            <button class="btn btn-info" type="submit" id="search" name="search">
                                                                <i class="icon-ok bigger-110"></i>
                                                                Generate
                                                            </button>
                                                        </div>
														
													</form>
												<form id="submit_form" name="submit_form" class="form-horizontal" action="numatgis.php" method="post" autocomplete="off" target="_blank">					
														<div class="text-right shift">
															<button class="btn" type="submit" id="export" name="export">
                                                                <i class="icon-ok bigger-110"></i>
                                                                Export to PDF
                                                            </button>
															<span class="btn" id="btn">
                                                                <a href="reset.php" >Reset</a>
                                                            </span>
														</div>
												<div class="table-header">
                                                   Result for Dealer Price List (Prices include packing and warehouse delivery)
                                                </div>                        
												<table  class="table table-bordered">
												<div id="tabledata">
                                                    <thead>                                
                                                        <tr>
                                                            <th rowspan="2">Sr. No.</th>
                                                            <th rowspan="2">Cabinet Height
</th>
                                                            <th rowspan="2">Cabinet Width
</th>
															<!--th rowspan="2">Door Width
</th-->
                                                            <th rowspan="2">Door Panel
</th>
                                                             <th rowspan="2">Number of Door Panels
</th>
															<!--th rowspan="2">Fixed Width
</th-->	
                                                            
                                                             <th rowspan="2">Fixed Panel (Yes/No)
</th> 
															<th rowspan="2">Fixed Panel 
</th> 
                                                            
                                                           
                                                            
                                                             <th rowspan="2">Quantity (Yes/No)
</th> 
															<th rowspan="2">Dealer Price</th>
                                                        </tr>
														
                                                    </thead>
                                                    <tbody>
                                                         <?php
                                                    if(isset($_POST['search']))
                                                    {
														
                                                            
                                                
                                                       
                                                            
                                                         
                                                    
                                                        $ch=$_POST['ch'];
                                                        
                                                         
                                                        $dw=$_POST['dw'];
                                                        
					$dp= $ch*$dw;
                                                        
                                                        $ndp=$_POST['ndp'];
                                                        
                                                        $fw=$_POST['fw'];
                                                        
                                                        $fp=$ch*$fw;
                                                        
                                                        $fp="-";
                                                        
														 $fpyn=$_POST['fp'];
                                                        
                                                        if($fpyn=='Yes'){
                                                            
                                                            $fp=$ch*$fw;
                                                        }
													
														$quan=$_POST['quan'];
													$sql="SELECT `DPWITHTAX`,`Sno`,`CW` FROM `Tydis` where `CH`='$ch'  and `DW`='$dw'  and `NDP`='$ndp' and `FW`='$fw'  and `FPYN`='$fpyn'";
                                                        
                                                      print($sql);
                                                    $res=  mysqli_query($conn,$sql);
                                                        
                                                        
                                                                  
                                                        
                                                        
                                                        
                                                        
                                                       
													while($row= mysqli_fetch_array($res))
                                                    { 
														$price=$row[0];
                                                        $sno=$row[1];
                                                        $cw=$row[2];
                                                        
                                                 
$result = str_replace(',', '', $price);       
                                                        $quan=intval($quan);
                                                        
                                                        $result=intval($result);
                                                        
                                                        $price=$quan * $result; 
                                                        
                                                        
                                                        
				$sqlin="insert into tmp_product_price_tydis values('','$ch','$cw','$dw','$dp','$ndp','$fw','$fp','$fpyn','$quan','$price')";
												//	echo $sqlin; 
														$resin=  mysqli_query($conn,$sqlin);
													}
													$sqlsels="SELECT * FROM `tmp_product_price_tydis` where sno!='' limit 2";
													//echo $sqlsel."</br>";		
                                                    $ressels=  mysqli_query($conn,$sqlsels);
													$cnt=0;
													while($rowsels= mysqli_fetch_array($ressels))
                                                    {
														$cnt++;
                                                        
                                                        
                                                      
                                                        
                                                        
                                                        
                                                        
                                                        
													?>
                                                    <tr>
                                                        <td align="center"><?php print($cnt);?></td>
															
                                                         <td align="center"><input type="hidden" name="cname[]" id="cname" value="<?php print($rowsels[1]);?>"><?php print($rowsels[1]);?> </td>
                                                        <td align="center"><input type="hidden" name="build[]" id="build" value="<?php print($rowsels[2]);?>" ><?php print($rowsels[2]);?></td>
                                                       
														<td align="center"><input type="hidden" name="pname[]" id="pname" value="<?php print($rowsels[4]);?>" ><?php print($rowsels[4]);?></td>
                                                        <td align="center"><input type="hidden" name="dim[]" id="dim" value="<?php print($rowsels[5]);?>" ><?php print($rowsels[5]);?></td>                                                                                            <td align="center"><input type="hidden" name="fpyn[]" id="fpyn" value="<?php print($rowsels[8]);?>" readonly><?php print($rowsels[8]);?></td>                              
														
														<td align="center"><input type="hidden" name="w[]" id="w" value="<?php print($rowsels[7]);?>" readonly><?php print($rowsels[7]);?></td>
														
														<td align="center"><input type="hidden" name="qty[]" id="qty" value="<?php print($rowsels[9]);?>" readonly><?php print($rowsels[9]);?></td>
                                                        
                                                        
                                                        <td class="textright"><input type="hidden" name="total[]" id="total[]" value="<?php print($rowsels[10]);?>" readonly><?php print($rowsels[10]);?></td>  
                                                     </tr>
													 
													
													 <?php
													 if($rowsels[1] == "700" || $rowsels[1] == "800" || $rowsels[1] == "800") {
													 ?>
													
													<?php } ?>
													<?php } } ?>
													<tr>
                                                        <td colspan="8" class="textright"><br/> Total (INR):</td>
														<td class="textright"><input type="text" name="totalall" id="totalall" readonly></td>
                                                     </tr>
													
													</tbody>
                                                                    
												</div>							
                                                </table>	
												</form>
												
                    </div><!--/.span-->
					
                </div><!--/.row-fluid-->
				
            </div><!--/.page-content-->
			
     <?php
//include 'include/footer.php';
?>
<script type="text/javascript">
$(document).ready(function(){
    $('#cat_id').on('change',function(){
        var cat_id = $(this).val();
		//alert(cat_id);
        if(cat_id){
            $.ajax({
                type:'POST',
                url:'http://www.numaglobal.com/numa-application/getproductch.php',
                data:'cat_id='+cat_id,
                success:function(html){
                    $('#ch').html(html);
                }
            }); 
        }
        
        else{
            $('#ch').html('<option value="">Select cabinet height</option>');
        }
    });
    
     $('#ch').on('change',function(){
        var ch = $(this).val();
		//alert(cat_id);
         
      
         
        if(ch){
        $.ajax({
                type:'POST',
                url:'http://www.numaglobal.com/numa-application/getproductdw.php',
                data:'cat_id='+ch,
                success:function(html){
                    $('#dw').html(html);
                }
            }); 
        }
        
        else{
            $('#dw').html('<option value="">Select Door Width</option>');
        }
    });
    
    
 
    
    
    
       $('#dw').on('change',function(){
        var dw = $(this).val();
		
           var ch=document.search_form.ch.value;
           var dw=document.search_form.dw.value;
    //   alert(dw);
           
        if(dw){
            $.ajax({
                type:'POST',
                url:'http://www.numaglobal.com/numa-application/getproductndp.php',
            //   data:'model='+model,
                   // data:'build='+build,
                 data: {ch:ch,dw:dw},
              //    data: {model:model,build:build},
                success:function(html){
                    $('#ndp').html(html);
                }
            }); 
        }
        
        else{
            $('#ndp').html('<option value="">Number Of Door Panel</option>');
        }
    });
    
    
    
    
    
      $('#ndp').on('change',function(){
          
           
        var ndp = $(this).val();
		 
          
           var ch=document.search_form.ch.value;
       
            var dw=document.search_form.dw.value;
          
          var ndp=document.search_form.ndp.value;
          
         
          
          
         
           
        if(ndp){
            
           
                  $.ajax({
                type:'POST',
                url:'http://www.numaglobal.com/numa-application/getproductfp.php',
            //   data:'model='+model,
                   // data:'build='+build,
                 data: {ch:ch,dw:dw,ndp:ndp},
              //    data: {model:model,build:build},
                success:function(html){
                    $('#fp').html(html);
                }
            }); 
        }
        
        else{
            $('#fp').html('<option value="">Select Fixed Panel (Yes/No)</option>');
        }
    });
    
    
        $('#fp').on('change',function(){
        var fp = $(this).val();
		
           var ch=document.search_form.ch.value;
          // var cw=document.search_form.cw.value;
            
            var dw=document.search_form.dw.value;
          
        //  var dp=document.search_form.fp.value;
            
            
             var ndp=document.search_form.ndp.value;
            
            
      //   alert(build);
           
        if(fp){
            $.ajax({
                type:'POST',
                url:'http://www.numaglobal.com/numa-application/getproductfw.php',
            //   data:'model='+model,
                   // data:'build='+build,
                 data: {ch:ch,dw:dw,ndp:ndp,fp:fp},
              //    data: {model:model,build:build},
                success:function(html){ 
                    $('#fw').html(html);
                }
            }); 
        }
        
        else{
            $('#fw').html('<option value="">Select Fixed Width</option>');
        }
    });
    
    
    
    
    
});
</script> 
<script type="text/javascript">
        $(document).ready(function() {
            $('#search_form').validate({
                rules: {
					cat_id: {required: true},
                    prod_id: {required: true},
					width: {required: true, number: true, minlength: 3, maxlength: 4, range: [600, 2400]},
					height: {required: true, number: true, minlength: 3, maxlength: 4, range: [600, 2400]},
					quantity: {required: true, number: true},
                },
                highlight: function(element) {
                    $(element).closest('.control-group').removeClass('success').addClass('error');
                },
                success: function(element) {
                    element.html('<i class="icon-ok-sign"></i>').addClass('valid').closest('.control-group').removeClass('error').addClass('success');
                }
            });
        });
    </script>
	<script type="text/javascript">
function formatNumber(nStr) { // nStr is the input string
     nStr += '';
     x = nStr.split('.');
     x1 = x[0];
     x2 = x.length > 1 ? '.' + x[1] : '';
     var rgx = /(\d+)(\d{3})/;
     var z = 0;
     var len = String(x1).length;
     var num = parseInt((len/2)-1);
 
      while (rgx.test(x1))
      {
        if(z > 0)
        {
          x1 = x1.replace(rgx, '$1' + ',' + '$2');
        }
        else
        {
          x1 = x1.replace(rgx, '$1' + ',' + '$2');
          rgx = /(\d+)(\d{2})/;
        }
        z++;
        num--;
        if(num == 0)
        {
          break;
        }
      }
     return x1 + x2;
 }
	</script>
	<script type="text/javascript">	
    $(document).ready(function(){
		$("#totalall").val("0");
		$("#totalalltax").val("0");
		$("#totalallwthtax").val("0");
		var totalalla=0;
		$('input[name="total[]"]').each(function(){
		//alert($(this).val());
		//var totalval=$(this).val();
		//alert(totalval);
		totalalla += parseInt($(this).val());
		//alert(totalalla);
		$('#totalall').val(totalalla);
		//$('#totalalltax').val(totalalla);
		});
		
	});	
	</script>
	<script type="text/javascript">
    $(document).ready(function(){		
	<?php
	$sqlsel="select * from tmp_product_price_forma where sno!=''";
	$ressel=  mysqli_query($conn,$sqlsel);
	$rwcnt= mysqli_num_rows($ressel);
	//echo $rwcnt;
	?>	
	<?php
	if($rwcnt == 1)
	{ ?>
	$('#chksnsradd1').attr('checked','checked');
	$('#chkdfgradd1').attr('checked','checked');
	var snsradd1=1000;
	var dfgradd1=750;
	$('#totalchksnsradd1').val(snsradd1);
	$('#totalchkdfgradd1').val(dfgradd1);
	
	var totalchksnsradd1=$("#totalchksnsradd1").val();
	var totalchkdfgradd1=$("#totalchkdfgradd1").val();
	var total1=$("#total1").val();
	var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var totalall1= Number(totalchksnsradd1) + Number(totalchkdfgradd1) + Number(total11);
	$('#total1').val(formatNumber(totalall1)); 
	
	$('#totalall').val(formatNumber(totalall1));
	var totalalltax1=Math.round(totalall1*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall1) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
	
	<?php } ?>
	
	<?php if($rwcnt == 2){ ?>
	
	$('#chksnsradd1').attr('checked','checked');
	$('#chkdfgradd1').attr('checked','checked');
	
	$('#chksnsradd2').attr('checked','checked');
	$('#chkdfgradd2').attr('checked','checked');
	
	var snsradd1=1000;
	var dfgradd1=750;
	$('#totalchksnsradd1').val(snsradd1);
	$('#totalchkdfgradd1').val(dfgradd1);
	
	var snsradd2=1000;
	var dfgradd2=750;
	$('#totalchksnsradd2').val(snsradd2);
	$('#totalchkdfgradd2').val(dfgradd2);
	
	var totalchksnsradd1=$("#totalchksnsradd1").val();
	var totalchkdfgradd1=$("#totalchkdfgradd1").val();
	
	var totalchksnsradd2=$("#totalchksnsradd2").val();
	var totalchkdfgradd2=$("#totalchkdfgradd2").val();
	
	var total1=$("#total1").val();
	var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var total2=$("#total2").val();
	var total21=$("#total2").val();
	var total21=total21.split(',').join('');
	
	var totalall1= Number(totalchksnsradd1) + Number(totalchkdfgradd1) + Number(total11);
	$('#total1').val(formatNumber(totalall1));
	
	var totalall2= Number(totalchksnsradd2) + Number(totalchkdfgradd2) + Number(total21);
	$('#total2').val(formatNumber(totalall2));
	
	var totalall12=Number(totalall1) + Number(totalall2);
	
	$('#totalall').val(formatNumber(totalall12));
	var totalalltax1=Math.round(totalall12*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall12) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
	
	<?php } ?>
	
	//1----------------------------
	
	$("#chksnsradd1").click(function () {
	var chksnsradd1 = $('#chksnsradd1').is(':checked');
	if(chksnsradd1)	
	{
	var snsradd1=1000;
	$('#totalchksnsradd1').val(snsradd1);
	
	<?php
	if($rwcnt == 1)
	{
		?>
		
		var total1=$("#total1").val();
		var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var totalchksnsradd1=$("#totalchksnsradd1").val();
	var totalall1= Number(totalchksnsradd1) + Number(total11);
	
	$('#total1').val(formatNumber(totalall1)); 
	$('#totalall').val(formatNumber(totalall1));
	var totalalltax1=Math.round(totalall1*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall1) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	if($rwcnt == 2)
	{
		?>
		//alert("checked");
		var total1=$("#total1").val();
		var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var totalchksnsradd1=$("#totalchksnsradd1").val();
	var totalall1= Number(totalchksnsradd1) + Number(total11);
	
	//alert(totalall2);
	$('#total1').val(formatNumber(totalall1));
	var total1=$("#total1").val();
		var total11=$("#total1").val();
		var total11=total11.split(',').join('');
		var total2=$("#total2").val();
		var total21=$("#total2").val();
		var total21=total21.split(',').join('');
		var totalall2= Number(total11) + Number(total21);
	$('#totalall').val(formatNumber(totalall2));
	var totalalltax1=Math.round(totalall2*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall2) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	?>
	
	}
	else{
		var snsradd1=1000;
		$("#totalchksnsradd1").val("0");
		<?php
	if($rwcnt == 1)
	{
		?>
		var total1=$("#total1").val();
		var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var totalall1= Number(total11) - Number(snsradd1);
	
	$('#total1').val(formatNumber(totalall1));
	$('#totalall').val(formatNumber(totalall1));	
	var totalalltax1=Math.round(totalall1*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall1) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	if($rwcnt == 2)
	{
		?>
		//alert("unchecked");
		var total1=$("#total1").val();
		var total11=$("#total1").val();
	var total11=total11.split(',').join('');
		var totalall1= Number(total11) - Number(snsradd1);
		$('#total1').val(formatNumber(totalall1));
		var total1=$("#total1").val();
		var total11=$("#total1").val();
		var total11=total11.split(',').join('');
		var total2=$("#total2").val();
		var total21=$("#total2").val();
		var total21=total21.split(',').join('');
		var totalall2= Number(total11) + Number(total21);
	$('#totalall').val(formatNumber(totalall2));	
	var totalalltax1=Math.round(totalall2*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall2) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	?>
	
	}		
    });
	
	
	$("#chkdfgradd1").click(function () {
	var chkdfgradd1 = $('#chkdfgradd1').is(':checked');
	if(chkdfgradd1)	
	{
	var dfgradd1=750;
	$('#totalchkdfgradd1').val(dfgradd1);	
	<?php
	if($rwcnt == 1)
	{
		?>
		
		var total1=$("#total1").val();
		var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var totalchkdfgradd1=$("#totalchkdfgradd1").val();
	var totalall1= Number(totalchkdfgradd1) + Number(total11);
	
	$('#total1').val(formatNumber(totalall1)); 
	$('#totalall').val(formatNumber(totalall1));
	var totalalltax1=Math.round(totalall1*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall1) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	if($rwcnt == 2)
	{
		?>
		//alert("checked");
		var total1=$("#total1").val();
		var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var totalchkdfgradd1=$("#totalchkdfgradd1").val();
	var totalall1= Number(totalchkdfgradd1) + Number(total11);
	
	//alert(totalall2);
	$('#total1').val(formatNumber(totalall1));
	var total1=$("#total1").val();
		var total11=$("#total1").val();
		var total11=total11.split(',').join('');
		var total2=$("#total2").val();
		var total21=$("#total2").val();
		var total21=total21.split(',').join('');
		var totalall2= Number(total11) + Number(total21);
	$('#totalall').val(formatNumber(totalall2));
	var totalalltax1=Math.round(totalall2*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall2) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	?>
	}
	else{
		var dfgradd1=750;
		$("#totalchkdfgradd1").val("0");
	<?php
	if($rwcnt == 1)
	{
		?>
		var total1=$("#total1").val();
		var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var totalall1= Number(total11) - Number(dfgradd1);
	
	$('#total1').val(formatNumber(totalall1));
	$('#totalall').val(formatNumber(totalall1));	
	var totalalltax1=Math.round(totalall1*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall1) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	if($rwcnt == 2)
	{
		?>
		//alert("unchecked");
		var total1=$("#total1").val();
		var total11=$("#total1").val();
	var total11=total11.split(',').join('');
		var totalall1= Number(total11) - Number(dfgradd1);
		$('#total1').val(formatNumber(totalall1));
		var total1=$("#total1").val();
		var total11=$("#total1").val();
		var total11=total11.split(',').join('');
		var total2=$("#total2").val();
		var total21=$("#total2").val();
		var total21=total21.split(',').join('');
		var totalall2= Number(total11) + Number(total21);
	$('#totalall').val(formatNumber(totalall2));	
	var totalalltax1=Math.round(totalall2*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall2) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	?>
	}
	});	
	
	$("#chksvmscadd1").click(function () {
	var chksvmscadd1 = $('#chksvmscadd1').is(':checked');
	if(chksvmscadd1)	
	{
	var svmscadd1=11900;
	$('#totalsvmscadd1').val(svmscadd1);	
	<?php
	if($rwcnt == 1)
	{
		?>
		
		var total1=$("#total1").val();
		var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var totalsvmscadd1=$("#totalsvmscadd1").val();
	var totalall1= Number(totalsvmscadd1) + Number(total11);
	
	$('#total1').val(formatNumber(totalall1)); 
	$('#totalall').val(formatNumber(totalall1));
	var totalalltax1=Math.round(totalall1*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall1) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	if($rwcnt == 2)
	{
		?>
		//alert("checked");
		var total1=$("#total1").val();
		var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var totalsvmscadd1=$("#totalsvmscadd1").val();
	var totalall1= Number(totalsvmscadd1) + Number(total11);
	
	//alert(totalall2);
	$('#total1').val(formatNumber(totalall1));
	var total1=$("#total1").val();
		var total11=$("#total1").val();
		var total11=total11.split(',').join('');
		var total2=$("#total2").val();
		var total21=$("#total2").val();
		var total21=total21.split(',').join('');
		var totalall2= Number(total11) + Number(total21);
	$('#totalall').val(formatNumber(totalall2));
	var totalalltax1=Math.round(totalall2*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall2) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	?>
	}
	else{
		var svmscadd1=11900;
		$("#totalsvmscadd1").val("0");
		<?php
	if($rwcnt == 1)
	{
		?>
		var total1=$("#total1").val();
		var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var totalall1= Number(total11) - Number(svmscadd1);
	
	$('#total1').val(formatNumber(totalall1));
	$('#totalall').val(formatNumber(totalall1));	
	var totalalltax1=Math.round(totalall1*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall1) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	if($rwcnt == 2)
	{
		?>
		//alert("unchecked");
		var total1=$("#total1").val();
		var total11=$("#total1").val();
	var total11=total11.split(',').join('');
		var totalall1= Number(total11) - Number(svmscadd1);
		$('#total1').val(formatNumber(totalall1));
		var total1=$("#total1").val();
		var total11=$("#total1").val();
		var total11=total11.split(',').join('');
		var total2=$("#total2").val();
		var total21=$("#total2").val();
		var total21=total21.split(',').join('');
		var totalall2= Number(total11) + Number(total21);
	$('#totalall').val(formatNumber(totalall2));	
	var totalalltax1=Math.round(totalall2*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val();
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall2) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	?>
	}	
	});
	
	$("#chkprodmadd1").click(function () {
	var chkprodmadd1 = $('#chkprodmadd1').is(':checked');
	if(chkprodmadd1)	
	{
	var prodmadd1=6000;
	$('#totalchkprodmadd1').val(prodmadd1);	
	<?php
	if($rwcnt == 1)
	{
		?>
		
		var total1=$("#total1").val();
		var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var totalchkprodmadd1=$("#totalchkprodmadd1").val();
	var totalall1= Number(totalchkprodmadd1) + Number(total11);
	
	$('#total1').val(formatNumber(totalall1)); 
	$('#totalall').val(formatNumber(totalall1));
	var totalalltax1=Math.round(totalall1*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val();
	var totalallwthtax= Number(totalall1) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	if($rwcnt == 2)
	{
		?>
		//alert("checked");
		var total1=$("#total1").val();
		var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var totalchkprodmadd1=$("#totalchkprodmadd1").val();
	var totalall1= Number(totalchkprodmadd1) + Number(total11);
	
	//alert(totalall2);
	$('#total1').val(formatNumber(totalall1));
	var total1=$("#total1").val();
		var total11=$("#total1").val();
		var total11=total11.split(',').join('');
		var total2=$("#total2").val();
		var total21=$("#total2").val();
		var total21=total21.split(',').join('');
		var totalall2= Number(total11) + Number(total21);
	$('#totalall').val(formatNumber(totalall2));
	var totalalltax1=Math.round(totalall2*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val();
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall2) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	?>
	}
	else{
		var prodmadd1=6000;
		$("#totalchkprodmadd1").val("0");
		<?php
	if($rwcnt == 1)
	{
		?>
		var total1=$("#total1").val();
		var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var totalall1= Number(total11) - Number(prodmadd1);
	
	$('#total1').val(formatNumber(totalall1));
	$('#totalall').val(formatNumber(totalall1));	
	var totalalltax1=Math.round(totalall1*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall1) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	if($rwcnt == 2)
	{
		?>
		//alert("unchecked");
		var total1=$("#total1").val();
		var total11=$("#total1").val();
		var total11=total11.split(',').join('');
		var totalall1= Number(total11) - Number(prodmadd1);
		$('#total1').val(formatNumber(totalall1));
		var total1=$("#total1").val();
		var total11=$("#total1").val();
		var total11=total11.split(',').join('');
		var total2=$("#total2").val();
		var total21=$("#total2").val();
		var total21=total21.split(',').join('');
		var totalall2= Number(total11) + Number(total21);
	$('#totalall').val(formatNumber(totalall2));	
	var totalalltax1=Math.round(totalall2*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall2) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	?>
	}		
    });
	
	//2----------------------------
	
	$("#chksnsradd2").click(function () {
	var chksnsradd2 = $('#chksnsradd2').is(':checked');
	if(chksnsradd2)	
	{
	var snsradd2=1000;
	$('#totalchksnsradd2').val(snsradd2);
	
	<?php
	if($rwcnt == 2)
	{
		?>
		//alert("checked");
		var total2=$("#total2").val();
		var total21=$("#total2").val();
		var total21=total21.split(',').join('');
	var totalchksnsradd2=$("#totalchksnsradd2").val();
	var totalall1= Number(totalchksnsradd2) + Number(total21);
	
	//alert(totalall2);
	$('#total2').val(formatNumber(totalall1));
	var total1=$("#total1").val();
	var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var total2=$("#total2").val();
	var total21=$("#total2").val();
	var total21=total21.split(',').join('');
	var totalall2= Number(total11) + Number(total21);
	
	$('#totalall').val(formatNumber(totalall2));
	var totalalltax1=Math.round(totalall2*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall2) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	?>
	}
	else{
		var snsradd2=1000;
		$("#totalchksnsradd2").val("0");
		<?php
	if($rwcnt == 2)
	{
		?>
		//alert("unchecked");
		var total2=$("#total2").val();
		var total21=$("#total2").val();
		var total21=total21.split(',').join('');
		var totalall1= Number(total21) - Number(snsradd2);
		$('#total2').val(formatNumber(totalall1));
			var total1=$("#total1").val();
	var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var total2=$("#total2").val();
	var total21=$("#total2").val();
	var total21=total21.split(',').join('');
	var totalall2= Number(total11) + Number(total21);

	$('#totalall').val(formatNumber(totalall2));	
	var totalalltax1=Math.round(totalall2*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall2) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	?>
	}		
    });
	
	 $("#chkdfgradd2").click(function () {
	var chkdfgradd2 = $('#chkdfgradd2').is(':checked');
	if(chkdfgradd2)	
	{
	var dfgradd2=750;
	$('#totalchkdfgradd2').val(dfgradd2);	
	<?php
	if($rwcnt == 2)
	{
		?>
		//alert("checked");
		var total2=$("#total2").val();
		var total21=$("#total2").val();
		var total21=total21.split(',').join('');
	var totalchkdfgradd2=$("#totalchkdfgradd2").val();
	var totalall1= Number(totalchkdfgradd2) + Number(total21);
	
	//alert(totalchkdfgradd2);
	$('#total2').val(formatNumber(totalall1));
		var total1=$("#total1").val();
	var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var total2=$("#total2").val();
	var total21=$("#total2").val();
	var total21=total21.split(',').join('');
	var totalall2= Number(total11) + Number(total21);

	$('#totalall').val(formatNumber(totalall2));
	var totalalltax1=Math.round(totalall2*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall2) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	?>
	
	}
	else{
		var dfgradd2=750;
		$("#totalchkdfgradd2").val("0");
	<?php
	if($rwcnt == 2)
	{
		?>
		//alert("unchecked");
		var total2=$("#total2").val();
		var total21=$("#total2").val();
		var total21=total21.split(',').join('');
		var totalall1= Number(total21) - Number(dfgradd2);
		$('#total2').val(formatNumber(totalall1));
			var total1=$("#total1").val();
	var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var total2=$("#total2").val();
	var total21=$("#total2").val();
	var total21=total21.split(',').join('');
	var totalall2= Number(total11) + Number(total21);

	$('#totalall').val(formatNumber(totalall2));	
	var totalalltax1=Math.round(totalall2*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall2) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	?>
	}
	});	
	
	 $("#chksvmscadd2").click(function () {
	var chksvmscadd2 = $('#chksvmscadd2').is(':checked');
	if(chksvmscadd2)	
	{
	var svmscadd2=11900;
	$('#totalsvmscadd2').val(svmscadd2);	
	<?php
	if($rwcnt == 2)
	{
		?>
		//alert("checked");
		var total2=$("#total2").val();
		var total21=$("#total2").val();
		var total21=total21.split(',').join('');
	var totalsvmscadd2=$("#totalsvmscadd2").val();
	var totalall1= Number(totalsvmscadd2) + Number(total21);
	
	//alert(totalchkdfgradd2);
	$('#total2').val(formatNumber(totalall1));
		var total1=$("#total1").val();
	var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var total2=$("#total2").val();
	var total21=$("#total2").val();
	var total21=total21.split(',').join('');
	var totalall2= Number(total11) + Number(total21);

	$('#totalall').val(formatNumber(totalall2));
	var totalalltax1=Math.round(totalall2*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall2) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	?>
	}
	else{
		var svmscadd2=11900;
		$("#totalsvmscadd2").val("0");
		<?php
	if($rwcnt == 2)
	{
		?>
		//alert("unchecked");
		var total2=$("#total2").val();
		var total21=$("#total2").val();
		var total21=total21.split(',').join('');
		var totalall1= Number(total21) - Number(svmscadd2);
		$('#total2').val(formatNumber(totalall1));
			var total1=$("#total1").val();
	var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var total2=$("#total2").val();
	var total21=$("#total2").val();
	var total21=total21.split(',').join('');
	var totalall2= Number(total11) + Number(total21);

	$('#totalall').val(formatNumber(totalall2));	
	var totalalltax1=Math.round(totalall2*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall2) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	?>
	}	
	});
	
	$("#chkprodmadd2").click(function () {
	var chkprodmadd2 = $('#chkprodmadd2').is(':checked');
	if(chkprodmadd2)	
	{
	var prodmadd2=6000;
	$('#totalchkprodmadd2').val(prodmadd2);	
	<?php
	if($rwcnt == 2)
	{
		?>
		//alert("checked");
		var total2=$("#total2").val();
		var total21=$("#total2").val();
		var total21=total21.split(',').join('');
	var totalchkprodmadd2=$("#totalchkprodmadd2").val();
	var totalall1= Number(totalchkprodmadd2) + Number(total21);
	
	//alert(totalchkdfgradd2);
	$('#total2').val(formatNumber(totalall1));
		var total1=$("#total1").val();
	var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var total2=$("#total2").val();
	var total21=$("#total2").val();
	var total21=total21.split(',').join('');
	var totalall2= Number(total11) + Number(total21);

	$('#totalall').val(formatNumber(totalall2));
	var totalalltax1=Math.round(totalall2*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val(); 
	var totalallwthtax= Number(totalall2) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	?>
	}
	else{
		var prodmadd2=6000;
		$("#totalchkprodmadd2").val("0");
		<?php
	
	if($rwcnt == 2)
	{
		?>
		//alert("unchecked");
		var total2=$("#total2").val();
		var total21=$("#total2").val();
		var total21=total21.split(',').join('');
		var totalall1= Number(total21) - Number(prodmadd2);
		$('#total2').val(formatNumber(totalall1));
			var total1=$("#total1").val();
	var total11=$("#total1").val();
	var total11=total11.split(',').join('');
	var total2=$("#total2").val();
	var total21=$("#total2").val();
	var total21=total21.split(',').join('');
	var totalall2= Number(total11) + Number(total21);

	$('#totalall').val(formatNumber(totalall2));	
	var totalalltax1=Math.round(totalall2*12/100,0);
	$('#totalalltax').val(formatNumber(totalalltax1));
	//totalall=$("#totalall").val(); 
	//var totalalltax=$("#totalalltax").val();
	var totalallwthtax= Number(totalall2) + Number(totalalltax1); 
	$('#totalallwthtax').val(formatNumber(totalallwthtax));
		<?php
	}
	?>
	}		
    });
});		
  </script>
</body>