@include('theme_layout/header')
 @include('theme_layout/nav')
    <style>
    .text-center {
     text-align: center;
     }
    .modal-body{
     max-width: 900px;
     overflow-x: auto !important;
     }
	 
	 .scroll_dive{
     max-width: 900px;
     overflow-x: auto !important;
     }
	 
    </style>

   <div class="app-main__outer">
    <div class="app-main__inner">
      <div class="app-page-title">
       <div class="page-title-wrapper">
        <div class="page-title-heading">
        <div class="page-title-icon">
	      <i class="pe-7s-medal icon-gradient bg-tempting-azure">
	      </i>
        </div>
		
	<div>Route Return Sales Report  
	  @if(Session::has('successMessage'))
	   <div class="alert  alert-success mt-3" >
	    {{ Session::get('successMessage') }}
		</div>
		@endif
	   </div>
     </div>
							
    <div class="page-title-actions"> 
     <div class="d-inline-block dropdown">
      <div class="page-title-actions"> 
        </div> 
         <div tabindex="-1" role="menu" aria-hidden="true" class="dropdown-menu dropdown-menu-right">
           <ul class="nav flex-column">
            <li class="nav-item">
              <a class="nav-link">
               <i class="nav-link-icon lnr-inbox"></i>
               <span>
	           Inbox
               </span>
              <div class="ml-auto badge badge-pill badge-secondary">86</div>
              </a>
            </li>
			
    <li class="nav-item">
     <a class="nav-link">
      <i class="nav-link-icon lnr-book"></i>
        <span>
	       Book
        </span>
       <div class="ml-auto badge badge-pill badge-danger">5</div>
      </a>
    </li>
	
   <li class="nav-item">
    <a class="nav-link">
      <i class="nav-link-icon lnr-picture"></i>
        <span>
	     Picture
        </span>
      </a>
    </li>
	
    <li class="nav-item">
     <a disabled class="nav-link disabled">
      <i class="nav-link-icon lnr-file-empty"></i>
         <span>
	      File Disabled
         </span>
        </a>
       </li>
      </ul>
     </div>
    </div>
   </div>
  </div>        <!--page-title-wrapper-->
</div>          <!--app-page-title-->  

  <div class="main-card mb-3 card">
   <div class="card-body">
    <!-- date filte-->
     <div class="form-row">
      <div class="col-md-4">
       <label  class="font-weight-bold " for="region" class="">Report Selection</label>
        <select class="form-control" name="report_with" id="report_with" > 
        <option value=""></option>
        <option value="1">By Volume</option>
        <option value="2">By Amount</option>
       </select> 
      </div> 

	<div class="col-md-4" id="myDatepicker4">
	 <label for="" class="font-weight-bold ml-2"> From Date</label>
		 <input type="date" class="form-control" name="fromdate" id="fromdate" value="2025-07-17" autocomplete="off">
	</div>
 
    <div class="col-md-4" id="myDatepicker5">
     <label for="" class="font-weight-bold ml-2"> To Date</label>
	  <input type="date" class="form-control" name="todate"  id="todate"  value="2025-07-17" autocomplete="off">
     </div>							   
	</div>
	</br>

   <div class="form-row">
     <div class="col-md-4">
	  <label  class="font-weight-bold ml-2" for="region" class="">Region</label>
		<select class="mb-2 form-control" name="region" id="region" > 
		 <option value=""></option>
		  <option value="0" data-value="{{$regId}}">Select All</option>
			@foreach($region as $region_name)
			<option value="{{$region_name->id}}" >{{ $region_name->region_code}}- {{$region_name->region_name}}</option>	
			@endforeach
		 </select> 
	 </div>
											
	<div class="col-md-4">
	  <label  class="font-weight-bold " for="region" class=""> Sub Region</label> 
		<select class="mb-2 form-control" name="sub_region" id="sub_region_add" > 
		 </select>
	</div>
	
	<div class="col-md-4">
	  <label  class="font-weight-bold " for="region" class="">Warehouse</label>
		<select class="mb-2 form-control" name="warehouse" id="warehouse_add" > 
		</select>
    </div>
	 
    </div>
	<br>
    <div class="form-row">
	<div class="col-md-4">
	  <label  class="font-weight-bold " for="region" class="">Route</label>
		<select class="mb-2 form-control" name="route" id="route_add" > 
		</select>
    </div>
	  <div class="col-md-4">
	   <label  class="font-weight-bold ml-2" for="region" class="">Return Type</label>
		   <select type="text" id="return_type" name="return_type" class="form-control">
            <option value=""></option>									
			<option value="1">Good Return</option>
			<option value="2">Bad Return</option>
			</select> 
	 </div>
	 
	 <div class="col-md-4">
	   <label  class="font-weight-bold ml-2" for="region" class="">Return Reason</label>
		   <select type="text" id="resion_type" name="resion" class="form-control"> 
			<option value=""></option>
		  </select>
	 </div>
	 
    </div>	
	   
	<div class="form-row">
	  <div class="col-md-12 text-center"> 
		<button id="submit" class="mt-3 btn btn-primary btn-lg">Search</button>
		  <a href="{{route('route_return_sales_report_list')}}" class="mt-3 btn btn-danger  btn-lg">Reset</a>
		</div>	
     </div>
  <br><br>

							  

   		<form id="" class="" action="{{ route('route_return_report_export') }}" method="post">
    	{{ csrf_field() }}

     	<input autocomplete="off" name="fromdate1" id="fromdate1" value="s" type="hidden">
      	<input autocomplete="off" name="todate1" id="todate1" value="s" type="hidden">
       	<input autocomplete="off" name="report_with1" id="report_with1" value="s" type="hidden">
       	<input autocomplete="off" name="region1" id="region1" value="s" type="hidden">
        <input autocomplete="off" name="subregion1" id="subregion1" value="s" type="hidden">
        <input autocomplete="off" name="warehouse1" id="warehouse1" value="s" type="hidden">
        <input autocomplete="off" name="route1" id="route1" value="s" type="hidden">
		<input autocomplete="off" name="return_type1" id="return_type1" value="s" type="hidden">
      	<input autocomplete="off" name="resion_type1" id="resion_type1" value="s" type="hidden">

        <button  id="export" style="display:none;  float:right; margin: 8px 54px 14px 65px;" class="mt-3 btn btn-primary btn-lg" >Export XLS</button>
		
        </form>
			
       <div class="container " id="report_data">	
      </div>
    </div> 
   </div>
 </div>

   <div  class="modal fade mt-5"  id="myModal_sales" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true" >
     <div class="modal-dialog mt-5 "  role="document">
       <div class="modal-content " style="width: 892px; margin-left: -72px;; margin-bottom:100px;">
        <div class="modal-header">
          <h5 class="modal-title" id="exampleModalLabel">Total Sales</h5>
          <button type="button" class="close" data-dismiss="modal" aria-label="Close">
            <span aria-hidden="true">&times;</span>
             </button>
           </div>
          <div  class="modal-body" id="sales_body_id"> 
         </div>
        </div>
     </div>
    </div >
			   
	@include('theme_layout/footer')	
    <script>
     var jq = $.noConflict();
       jq(document).ready(function(){
		$('#report_with').SumoSelect({ selectAll:true,search: true,   triggerChangeCombined : true});
		$('#return_type').SumoSelect({ selectAll:true,search: true,   triggerChangeCombined : true});
		$('#region').SumoSelect({ selectAll:true,search: true,triggerChangeCombined : true});
		$('#sub_region_add').SumoSelect({ selectAll:true,search: true,triggerChangeCombined : true});
		$('#warehouse_add').SumoSelect({ selectAll:true,search: true,triggerChangeCombined : true});
		 var all_region=0;
		 var all_sub_region=0;
		 var all_warehouse=0; 
		 var all_route=0;
        
      $("#region").change(function(){ 
	 var region_value = jq('#region').val();
    	 
	 get_warehouse(0);
	  get_route(0);
	  if(region_value == 0)
	  {
		var element = $(this).find('option:selected'); 
        var region = element.attr("data-value"); 
            all_region= region; 
			 
	  } 
	  else{
		    var region = jq('#region').val(); 
			  all_region= region;
	  } 
	    get_subregion(region); 
     });
  
     $("#sub_region_add").change(function(){
	    var sub_region_value = jq('#sub_region_add').val();
		if(sub_region_value==0)
		{
			 var element = $(this).find('option:selected'); 
        var sub_region = element.attr("data-value");
            all_sub_region=sub_region;
		}
		else{
			var sub_region = jq('#sub_region_add').val();
			  all_sub_region=sub_region;
		}
			
	    
	    get_warehouse(sub_region);
    });
	 $("#warehouse_add").change(function(){
	    var warehouse_value = jq('#warehouse_add').val();
        
        if(warehouse_value == 0){
			var element = $(this).find('option:selected'); 
        var warehouse = element.attr("data-value");
            all_warehouse=warehouse;
        }else{

            var warehouse = jq('#warehouse_add').val();
			all_warehouse=warehouse;
			
        }
	    
	    get_route(warehouse);
    });
	
	 $("#route_add").change(function(){	
	    var route_value = jq('#route_add').val();
        
        if(route_value == 0){
			var element = $(this).find('option:selected'); 
        var route = element.attr("data-value");
            all_route=route;
        }else{ 
            var route = jq('#route_add').val();
			all_route=route;
			 
        } 
    });
	 
	$("#return_type").change(function(){
	    var return_type = jq('#return_type').val();
	    get_return_type(return_type);
    });

      jq("#submit").click(function(){
	
       	var report_with = jq('#report_with').val();
        var fromdate = jq('#fromdate').val();
        var todate = jq('#todate').val();
        var report_with = jq('#report_with').val();

   
	      if(report_with=='' ||  report_with==null)
	       {
		    report_with='s';
	       }
	       var region = jq('#region').val();
		   if(region=='s' || region==null )
	       {
		    region='s';
		   }      
	    if(all_region==0)
	       {
		     all_region='s';
			  
	       }
	     
	     if(all_sub_region==0)
	       {
		     all_sub_region='s';
	       }
	     if(all_warehouse==0) 
	       {
		     all_warehouse='s';
	       }
		   if(all_route==0) 
	       {
		     all_route='s';
	       }
		   
		   
	   var return_type = jq('#return_type').val();
	   if(return_type=='' || return_type==null)
	   {
		   return_type='s';
	   }
	   var resion_type = jq('#resion_type').val();
	    if(resion_type=='' || resion_type==null)
	  {
		  resion_type='s';
	  }
	  
		jq('#fromdate1').val(fromdate);
      	jq('#todate1').val(todate);
       	jq('#region1').val(all_region);
        jq('#subregion1').val(all_sub_region);
        jq('#warehouse1').val(all_warehouse);		 
        jq('#route1').val(all_route);		 
        jq('#report_with1').val(report_with);
		jq('#return_type1').val(return_type);
      	jq('#resion_type1').val(resion_type);

	 if(report_with!='s')
	 {
	  get_report(report_with,all_region,all_sub_region,all_warehouse,all_route,return_type,resion_type,fromdate,todate);  
	 }
	 else
	 {
		 Swal.fire({
          icon: 'error',
          title: 'Report Selection Is Mandatory!!',
         })
	 }
   });
 
   function get_subregion(sub_region)
	{
	  jq.ajax({
      url: "{{ URL('get_route_return_sales_subregion/') }}"+"/" +sub_region,       
      type:"GET",
      success:function(respons)
      {
			if(respons)
			{
			  jq('#sub_region_add').html(respons);
			  $('#sub_region_add').SumoSelect({ selectAll:true,search: true,triggerChangeCombined : true});
	          $('#sub_region_add')[0].sumo.reload();  
			}
	  }
	 });
	}
	
	
	function get_return_type(return_type)
	{
	  jq.ajax({
      url: "{{ URL('get_return_type_for_route/') }}"+"/" +return_type,       
      type:"GET",
      success:function(respons)
      {
			if(respons)
			{
			  jq('#resion_type').html(respons);
			  $('#resion_type').SumoSelect({ selectAll:true,search: true,triggerChangeCombined : true});
	          $('#resion_type')[0].sumo.reload(); 
			
			 }
	      }
		});
	}
	
	function get_warehouse(warehouse)
	{
	  jq.ajax({
      url: "{{ URL('get_route_return_sales_warehouse/') }}"+"/" +warehouse,       
      type:"GET",
      success:function(respons)
      {
			if(respons)
			{
			  jq('#warehouse_add').html(respons);
			  $('#warehouse_add').SumoSelect({ selectAll:true,search: true,triggerChangeCombined : true});
	          $('#warehouse_add')[0].sumo.reload(); 
			}
	       }
		});
	}
	
	function get_route(route)
	{
	  jq.ajax({
      url: "{{ URL('get_route_return_sales/') }}"+"/" +route,       
      type:"GET",
      success:function(respons)
      {
			if(respons)
			{
			jq('#route_add').html(respons);
			$('#route_add').SumoSelect({ selectAll:true,search: true,triggerChangeCombined : true});
	          $('#route_add')[0].sumo.reload();
			}
	      }
		});
	}
	
	function get_salesman(salesman)
	{
	  jq.ajax({
      url: "{{ URL('get_company_salesman/') }}"+"/" +salesman,       
      type:"GET",
      success:function(respons)
      {
			if(respons)
			{
			jq('#salesman_add').html(respons);
			}
	     }
		}); 
	}
	
	function get_report(report_with,region,subregion,warehouse,route,return_type,resion_type,fromdate,todate)
	{
	  jq.ajax({
      url: "{{ URL('get_route_return_sales_report2/') }}"+"/" +report_with+"/"+region+"/"+subregion+"/"+warehouse+"/"+route+"/"+return_type+"/"+resion_type+"/"+fromdate+"/"+todate,      
      type:"GET",
      success:function(respons)
          {
			 if(respons){ 
				 var data = jQuery.parseJSON(respons); 
				$('#report_data').html(data.html);
				var  no_data= jq('#no_data').text();
				 if(no_data)
				   jq('#export').hide();
				 else
                   jq('#export').show();						
			  }  
			
	      }
		});
	}
	
	function get_report_pdf(report_with,region,subregion,warehouse,route,fromdate,todate)
	{
	  jq.ajax({
      url: "{{ URL('route_return_report_export/') }}"+"/" +report_with+"/"+region+"/"+subregion+"/"+warehouse+"/"+route+"/"+fromdate+"/"+todate,      
      type:"GET",
      success:function(respons)
          {
			
	       }
		});
	}
	$(document).on('click', '.region_modal', function(e) {
            e.preventDefault();
           /* $('#sales_report_modal').modal('show'); */
		      var return_type = jq('#return_type').val();
			   if(return_type=='' || return_type==null)
			   {
				   return_type='s';
			   }
			   var resion_type = jq('#resion_type').val();
				if(resion_type=='' || resion_type==null)
			  {
				  resion_type='s';
			  }
		   
            var region  = $(this).attr('data-agent-id');
			
            var fromdate = jq('#fromdate').val();
            var todate = jq('#todate').val();
              
			  
            if (fromdate != '' && todate != '' && region !='') {
                $.ajax({
                        url: "{{ URL('get_route_return_sales_report_pop2/') }}"+"/" +fromdate+"/"+todate+"/"+region+"/"+return_type+"/"+resion_type,      
                       type:"GET",
                       success: function (responce) {
                        var data = jQuery.parseJSON(responce);
				        $('#sales_body_id').html(data.html);
                        
                    }
                });
            }
            
        });
		
		
		$(document).on('click', '.sub_region_modal', function(e) {
            e.preventDefault();
			var return_type = jq('#return_type').val();
			   if(return_type=='' || return_type==null)
			   {
				   return_type='s';
			   }
			   var resion_type = jq('#resion_type').val();
				if(resion_type=='' || resion_type==null)
			  {
				  resion_type='s';
			  }
            
           /* $('#sales_report_modal').modal('show'); */
		   
            var subregion  = $(this).attr('data-agent-id');
			
            var fromdate = jq('#fromdate').val();
            var todate = jq('#todate').val();
			  
            if (fromdate != '' && todate != '' && subregion !='') {
                $.ajax({
                        url: "{{ URL('get_route_subregionreturn_sales_report_pop2/') }}"+"/" +fromdate+"/"+todate+"/"+subregion+"/"+return_type+"/"+resion_type,      
                       type:"GET",
                    success: function (responce) {
                        var data = jQuery.parseJSON(responce);
				        $('#sales_body_id').html(data.html);
                    }
                });
            }
            
        });
	
	
	$(document).on('click', '.warehouse_modal', function(e) {
            e.preventDefault();
			var return_type = jq('#return_type').val();
			   if(return_type=='' || return_type==null)
			   {
				   return_type='s';
			   }
			   var resion_type = jq('#resion_type').val();
				if(resion_type=='' || resion_type==null)
			  {
				  resion_type='s';
			  }
            
           /* $('#sales_report_modal').modal('show'); */
		   
            var warehouse  = $(this).attr('data-agent-id');
			
            var fromdate = jq('#fromdate').val();
            var todate = jq('#todate').val();
              
			  
            if (fromdate != '' && todate != '' && warehouse !='') {
                $.ajax({
                        url: "{{ URL('get_route_warehousereturn_sales_report_pop2/') }}"+"/" +fromdate+"/"+todate+"/"+warehouse+"/"+return_type+"/"+resion_type,      
                       type:"GET",
                    success: function (responce) {
                           /* var data = jQuery.parseJSON(responce); */ 
                        var data = jQuery.parseJSON(responce);
				        $('#sales_body_id').html(data.html);
                    }
                });
            }
            
        });
		
		$(document).on('click', '.route_modal', function(e) {
            e.preventDefault();
			var return_type = jq('#return_type').val();
			   if(return_type=='' || return_type==null)
			   {
				   return_type='s';
			   }
			   var resion_type = jq('#resion_type').val();
				if(resion_type=='' || resion_type==null)
			  {
				  resion_type='s';
			  }
            
           /* $('#sales_report_modal').modal('show'); */
		   
            var route  = $(this).attr('data-agent-id');
			
            var fromdate = jq('#fromdate').val();
            var todate = jq('#todate').val();
              
			  
            if (fromdate != '' && todate != '' && route !='') {
                $.ajax({
                        url: "{{ URL('get_route_routereturn_sales_report_pop2/') }}"+"/" +fromdate+"/"+todate+"/"+route+"/"+return_type+"/"+resion_type,      
                       type:"GET",
                    success: function (responce) {
                        /* var data = jQuery.parseJSON(responce);*/
                        var data = jQuery.parseJSON(responce);
				        $('#sales_body_id').html(data.html);
                    }
                });
            }
            
        });
		
		
		$(document).on('click', '.warehouse_quantity_modal', function(e) {
            e.preventDefault();
			var return_type = jq('#return_type').val();
			   if(return_type=='' || return_type==null)
			   {
				   return_type='s';
			   }
			   var resion_type = jq('#resion_type').val();
				if(resion_type=='' || resion_type==null)
			  {
				  resion_type='s';
			  }
            
           /* $('#sales_report_modal').modal('show'); */
		   
            var warehouse  = $(this).attr('data-agent-id');
			
            var fromdate = jq('#fromdate').val();
            var todate = jq('#todate').val();
			  
            if (fromdate != '' && todate != '' && warehouse !='') {
                $.ajax({
                        url: "{{ URL('get_route_warehousereturn_quantity_sales_report_pop2/') }}"+"/" +fromdate+"/"+todate+"/"+warehouse+"/"+return_type+"/"+resion_type,      
                       type:"GET",
                    success: function (responce) {
                        var data = jQuery.parseJSON(responce);
				        $('#sales_body_id').html(data.html);
                    }
                });
            }
            
        });
		$(document).on('click', '.route_quantity_modal', function(e) {
            e.preventDefault();
			var return_type = jq('#return_type').val();
			   if(return_type=='' || return_type==null)
			   {
				   return_type='s';
			   }
			   var resion_type = jq('#resion_type').val();
				if(resion_type=='' || resion_type==null)
			  {
				  resion_type='s';
			  }
            
           /* $('#sales_report_modal').modal('show'); */
		   
            var route  = $(this).attr('data-agent-id');
			
            var fromdate = jq('#fromdate').val();
            var todate = jq('#todate').val();
			  
            if (fromdate != '' && todate != '' && route !='') {
                $.ajax({
                        url: "{{ URL('get_route_routereturn_quantity_sales_report_pop2/') }}"+"/" +fromdate+"/"+todate+"/"+route+"/"+return_type+"/"+resion_type,      
                       type:"GET",
                    success: function (responce) {
                        var data = jQuery.parseJSON(responce);
				        $('#sales_body_id').html(data.html);
                    }
                });
            }
            
        });
	 
		$(document).on('click', '.sub_region_quantity_modal', function(e) {
            e.preventDefault();
            var return_type = jq('#return_type').val();
			   if(return_type=='' || return_type==null)
			   {
				   return_type='s';
			   }
			   var resion_type = jq('#resion_type').val();
				if(resion_type=='' || resion_type==null)
			  {
				  resion_type='s';
			  }
           /* $('#sales_report_modal').modal('show'); */
		   
            var subregion  = $(this).attr('data-agent-id');
			
			
            var fromdate = jq('#fromdate').val();
            var todate = jq('#todate').val();
              
			  
            if (fromdate != '' && todate != '' && subregion !='') {
                $.ajax({
                        url: "{{ URL('get_route_subregionreturn_quantity_sales_report_pop2/') }}"+"/" +fromdate+"/"+todate+"/"+subregion+"/"+return_type+"/"+resion_type,      
                       type:"GET",
                       success: function (responce) {
                        var data = jQuery.parseJSON(responce);
				        $('#sales_body_id').html(data.html);
                       
                    }
                });
            }
            
        });
		
		
		$(document).on('click', '.region_quantity_modal', function(e) {
            e.preventDefault();
			
			var return_type = jq('#return_type').val();
			   if(return_type=='' || return_type==null)
			   {
				   return_type='s';
			   }
			   var resion_type = jq('#resion_type').val();
				if(resion_type=='' || resion_type==null)
			  {
				  resion_type='s';
			  }
            
           /* $('#sales_report_modal').modal('show'); */
		   
            var region  = $(this).attr('data-agent-id');
			
            var fromdate = jq('#fromdate').val();
            var todate = jq('#todate').val();
              
			  
            if (fromdate != '' && todate != '' && region !='') {
                $.ajax({
                        url: "{{ URL('get_route_regionreturn_quntity_sales_report_pop2/') }}"+"/" +fromdate+"/"+todate+"/"+region+"/"+return_type+"/"+resion_type,      
                       type:"GET",
                    success: function (responce) {
                        var data = jQuery.parseJSON(responce);
				        $('#sales_body_id').html(data.html);
                    }
                });
            }
            
        });
		
		$(document).on('click', '.material_wise_warehouse_sales_modal', function(e) {
            e.preventDefault();
            
			var return_type = jq('#return_type').val();
			   if(return_type=='' || return_type==null)
			   {
				   return_type='s';
			   }
			   var resion_type = jq('#resion_type').val();
				if(resion_type=='' || resion_type==null)
			  {
				  resion_type='s';
			  }
           /* $('#sales_report_modal').modal('show'); */
		    var report_selection=jq('#report_with').val();
		    var slug='warehouse';
			var warehouse  = $(this).attr('data-agent-id');
            var material  = $(this).attr('data-material-id');
			
            var fromdate = jq('#fromdate').val();
            var todate = jq('#todate').val();
            if (fromdate != '' && todate != '' && warehouse !='' && material !='') {
                $.ajax({
                        url: "{{ URL('get_route_materialwise_quntity_sales_report_pop2/') }}"+"/" +fromdate+"/"+todate+"/"+warehouse+"/"+material+"/"+report_selection+"/"+slug+"/"+return_type+"/"+resion_type,      
                       type:"GET",
                       success: function (responce) {
                        var data = jQuery.parseJSON(responce);
                        $('#sales_body_id').html(data.html);
                    }
                });
            }
            
        });
		$(document).on('click', '.material_wise_route_sales_modal', function(e) {
            e.preventDefault();
            
			var return_type = jq('#return_type').val();
			   if(return_type=='' || return_type==null)
			   {
				   return_type='s';
			   }
			   var resion_type = jq('#resion_type').val();
				if(resion_type=='' || resion_type==null)
			  {
				  resion_type='s';
			  }
           /* $('#sales_report_modal').modal('show'); */
		    var report_selection=jq('#report_with').val();
		    var slug='route';
			var route  = $(this).attr('data-agent-id');
            var material  = $(this).attr('data-material-id');
			
            var fromdate = jq('#fromdate').val();
            var todate = jq('#todate').val();
            if (fromdate != '' && todate != '' && route !='' && material !='') {
                $.ajax({
                        url: "{{ URL('get_route_materialwise_quntity_sales_report_pop2/') }}"+"/" +fromdate+"/"+todate+"/"+route+"/"+material+"/"+report_selection+"/"+slug+"/"+return_type+"/"+resion_type,      
                       type:"GET",
                       success: function (responce) {
                        var data = jQuery.parseJSON(responce);
                        $('#sales_body_id').html(data.html);
                    }
                });
            }
            
        });
		
		$(document).on('click', '.material_wise_subregion_sales_modal', function(e) {
            e.preventDefault();
			
			var return_type = jq('#return_type').val();
			   if(return_type=='' || return_type==null)
			   {
				   return_type='s';
			   }
			   var resion_type = jq('#resion_type').val();
				if(resion_type=='' || resion_type==null)
			  {
				  resion_type='s';
			  }
            
           /* $('#sales_report_modal').modal('show'); */
		    var report_selection=jq('#report_with').val();
		    var slug='sub_region';
			var subregion  = $(this).attr('data-agent-id');
            var material  = $(this).attr('data-material-id');
			
            var fromdate = jq('#fromdate').val();
            var todate = jq('#todate').val();
            if (fromdate != '' && todate != '' && subregion !='' && material !='') {
                $.ajax({
                        url: "{{ URL('get_route_materialwise_quntity_sales_report_pop2/') }}"+"/" +fromdate+"/"+todate+"/"+subregion+"/"+material+"/"+report_selection+"/"+slug+"/"+return_type+"/"+resion_type,      
                       type:"GET",
                       success: function (responce) {
                        var data = jQuery.parseJSON(responce);
                        $('#sales_body_id').html(data.html);
                    }
                });
            }
            
        });
		
		$(document).on('click', '.material_wise_region_sales_modal', function(e) {
            e.preventDefault();
			var return_type = jq('#return_type').val();
			   if(return_type=='' || return_type==null)
			   {
				   return_type='s';
			   }
			   var resion_type = jq('#resion_type').val();
				if(resion_type=='' || resion_type==null)
			  {
				  resion_type='s';
			  }
           /* $('#sales_report_modal').modal('show'); */
		    var report_selection=jq('#report_with').val();
		    var slug='region';
			var region  = $(this).attr('data-agent-id');
            var material  = $(this).attr('data-material-id');
			
            var fromdate = jq('#fromdate').val();
            var todate = jq('#todate').val();
            if (fromdate != '' && todate != '' && region !='' && material !='') {
                $.ajax({
                        url: "{{ URL('get_route_materialwise_quntity_sales_report_pop2/') }}"+"/" +fromdate+"/"+todate+"/"+region+"/"+material+"/"+report_selection+"/"+slug+"/"+return_type+"/"+resion_type,      
                       type:"GET",
                       success: function (responce) {
                        var data = jQuery.parseJSON(responce);
                        $('#sales_body_id').html(data.html);
                    }
                });
            }
            
        });
   
	   });
   </script>