$("#bulkupload").on("change", function(){
        if(this.files[0].size > 550000){
          Swal.fire({
            title: 'Warning',
            text: "Please reduce the data in the file and ensure that no more than 6,000 rows are uploaded.",
            icon: 'warning', 
            confirmButtonColor: '#3085d6',
            cancelButtonColor: '#d33'
          })
          this.value = "";
        };
    });
   
  //  menu active class starts
    $('#menu_assign_upoload').addClass('subActive');
    $('#menu_assign_upoload').closest('.liSubMenu ').addClass('liSubMenuOpen');
    $('.liSubMenuOpen').closest('.sidebar-dropdown ').addClass('active');
    $('.liSubMenuOpen').closest('.sidebar-submenu ').slideDown(200);
    $('.liSubMenuOpen a span i').addClass('fa-minus');
    $('#menu_assign_upoload').on('click', function(){
      $(this).parent('li').addClass('liSubMenuOpen');
    })
  //  menu active class ends  
 
  $("#selectautoassign").on("click", function(){
    var thisval = $(this).is(":checked");
    if(thisval == true){
      $("#btnval").html("Upload and auto Assign")
    }
    else{
      $("#btnval").html("Upload")
    }
  })
 
  $(document).on("click", ".deleteRecords", function(){
    var thisval = $(this).is(":checked");
        Swal.fire({
          title: 'Important',
          text: "Removing all associated records linked to the respective entries in the uploads.",
          icon: 'warning', 
          confirmButtonColor: '#3085d6',
          cancelButtonColor: '#d33'
          }).then((result) => {
          if (result.isConfirmed) { 
                var userid= _ud;
                var orgid= _or;
                var thisid = $(this).attr('id')
                var filename = $(this).attr('data-id')
                var param = {userid: userid,orgid:orgid,tkn:tkn,id:thisid,filename:filename}
                var params = JSON.stringify(param);
                $.ajax({
                  type:"POST",
                  url: "Datacon/deleteExcelData",
                  data:params,
                  success:function(res){  
                    // console.log("res"+res);
                    if(res=='true'){
                        Swal.fire({
                        title: 'Success',
                        text: "Records removed successfully!",
                        icon: 'success', 
                        confirmButtonColor: '#3085d6',
                        cancelButtonColor: '#d33'
                      })
                    }
                    setTimeout(function(){
                        location.reload();
                    },1000)
                    
                    
                  }
                })
          }
        })
  })
 
//Organizationid
$(document).ready(function (e) {
  var orgid= _or;
  var userid= _ud;
  var token= tkn; 
  $("#orgid").val(orgid);
  $("#uploadby").val(userid); 

	$("#formsubmit").on('submit', function(e) { 
        // checkProgress_loop();
		e.preventDefault(); 
    $('.btnloading').show().html('<button class="btn btn-success btn-sm" disabled type="submit" type="submit" name="submit" ><span class="spinner-border spinner-border-sm" role="status" aria-hidden="true"></span> Uploading</button>');
    $('.btnsubmit').hide();
		$.ajax({ 
            type: "POST",
			url: "Bulk_tasks_uploads/excelupload",
			data:  new FormData(this), 
			contentType: false,
			cache: false,
			processData:false,
			success: function(data)
			{
			 //   alert("DATA : "+data)
            // console.log("Data: "+data);
        
		    if(data == 'true'){		       
            Swal.fire({
              title: 'Import',
              text: "Data imported successfully!",
              icon: 'success', 
              confirmButtonColor: '#3085d6',
              cancelButtonColor: '#d33'
              }).then((result) => {
              if (result.isConfirmed) { 
                location.reload();
              }
            })
		    }
	    else{
	        $('.btnloading').hide();
            $('.btnsubmit').show();
          Swal.fire({
          title: 'Error' + data,
          text: "Something went wrong",
          icon: 'warning', 
          confirmButtonColor: '#3085d6',
          cancelButtonColor: '#d33'
          })
		    }
			},	        
	   })
	})

}); 
 
$(document).ready(function(){
    $('#excelfileslist').DataTable({ 
        "processing": true, 
        "serverSide": true, 
        "order": [], 
        "ajax": {
            "url": "Bulk_tasks_uploads/getLists",
            "type": "POST"
        }, 
        "columnDefs": [{ 
            "targets": [0],
            "orderable": false
        }]
    });
});
 
  loaduploadlist();
  function loaduploadlist(){
    var userid= _ud;
    var orgid= _or;
    var param = {userid: userid,orgid:orgid,tkn:tkn}
    var params = JSON.stringify(param);
    $.ajax({
      type:"POST",
      url: "Datacon/loadlist",
      data:params,
      success:function(res){  
        // console.log("res"+res);
        var data=JSON.parse(res);
        var item='';   
            item += `<option value="">Select List</option>`;
          for(var i=0;i<data.length;i++){  
            item += `<option value="`+data[i]['id']+`">`+data[i]['name']+`</option>`;
          }   
        $('#listname').html(item);
      }
    })
  }

  function products_list(thisval){
    var userid= _ud;
    var orgid= _or;
    var thisval= thisval;
    var param = {userid: userid,thisval:thisval,orgid:orgid,tkn:tkn}
    var params = JSON.stringify(param);
    $.ajax({
      type:"POST",
      url: "Datacon/load_products_list_by_department",
      data:params,
      success:function(res){  
        // console.log("load_products_list"+res);
        var data=JSON.parse(res);
        var item='';   
            item += `<option value="">Select Products</option>`;
          for(var i=0;i<data.length;i++){  
            item += `<option value="`+data[i]['id']+`">`+data[i]['name']+`</option>`;
          }   
        $('#products').html(item);
      }
    })
  }
  load_departments_options();
  function load_departments_options(){
    var userid= _ud;
    var orgid= _or;
    var param = {userid: userid,orgid:orgid,tkn:tkn}
    var params = JSON.stringify(param);
    $.ajax({
      type:"POST",
      url: "Datacon/load_departments_options",
      data:params,
      success:function(res){  
        // console.log("res"+res);
        var data=JSON.parse(res);
        var item='';   
            item += `<option value="">Select Department</option>`;
          for(var i=0;i<data.length;i++){ 
            item += `<option value="`+data[i]['id']+`">`+data[i]['name']+`</option>`;
          }   
        $('#department').html(item); 
      }
    })
  }
  
  $(document).on('change', '#department', function(){
      var thisval = $(this).val();
      products_list(thisval);
      
  })