EVOLUTION-NINJA

Edit File: associative_executive_logistic_list.php

<?php echo view('includes/header');?>
<script src="<?php echo base_url('public/assets/admin_dashboard/js/jquery.table2excel.js');?>"></script>
	<section class="content-header">
		
			<h1> Associate / Executive / Logistic List / Sub Associate</h1>
			
	</section> 
			<form id="land_owner" class="form-inline assoc_type_form">
    			<div class="row land_owner_a">
					<div class="form-group col-sm-12 col-md-4">
						<label class="col-sm-4">Select Type</label>
						<select class="form-control col-md-8 assoc" name="type" id="type">
							<option value="">Select</option>
							<option value="Associate">Associate</option>	
							<option value="Executives">Executive</option>
							<option value="Logistic">Logistic</option>
							<option value="Sub Associate">Sub Associate</option>
						</select>
					</div>	
					<div class="form-group col-sm-12 col-md-4">
						<label class="col-sm-4"></label>
						<button type="submit" id="cancellation_submit" style="margin-top: 0px !important" class="btn btn-primary center-block submit">Submit</button>
					</div>
    			</div>			
			</form>
	<section class="content">				
			
		<div id="menu1" class="tab-panecol-sm-12 col-md-12">
    
			<div id = "jaytab3" style="margin-top:3%;margin-left: -28px;" class="col-sm-12 grid">
			<div class="grid_div"></div><table id="list3"></table>
			  <div id="pager3"></div>
		     <div id="dialogSelectRow3" title="Warning" style="display:none">
			 <p>Please select row</p>
			</div>
			</div>
		</div>		
		<div style="display:none;"><table  border="1" style="border-spacing: 0px !important;" id="export_table" class="export_table"></table></div>
		<div style="display:none;">
		<table  border="1" style="border-spacing: 0px !important;" id="print_table" class="print_table"></table>
		</div>				
		<script src="<?php echo base_url('public/assets/admin_dashboard/js/jquery.table2excel.js');?>"></script>
			<script>
			function print_page1()
			{  
				
				var divToPrint=document.getElementById('print_table');
					newWin= window.open("");
					newWin.document.write('<html><head><title></title>');
					newWin.document.write('</head>');
					newWin.document.write(divToPrint.outerHTML);
					newWin.document.write('</html>');
					newWin.print();
					document.getElementById('print_table').style.display='';
					newWin.close();
					location.reload();
			}
			</script>

<div class="row" id="print_broker_report" style="padding-left:10px; padding-top:25px;">
						<div class="col-sm-12 col-md-9">								
							<div style="">
							   <h3><center>Brokers List</center></h3>
							    <table class="table table-striped table-hover broker_report_table" style="width:100%;" border="1">
				                    <thead>
				                      <tr class="default" style="height:40px;padding-bottom:10px;">                  
				                        <th class="col-xs-1">Sl No.</th>
				                         <th class="col-xs-2">Type</th>
				                        <th class="col-xs-2">Name</th>
				                        <th class="col-xs-3">Email</th>
				                        <th class="col-xs-2">Mobile</th>
				                      </tr>
				                    </thead>

</table>
							</div>										
					</div>
				</div>

<div class="modal fade" id="edit_modal" role="dialog">
    <div class="modal-dialog modal-lg">
      <div class="modal-content">
        <div class="modal-header">
          <button type="button" class="close" data-dismiss="modal">&times;</button>
          <h4 class="modal-title">Update broker details</h4>
        </div>

<div class="row" style="padding-bottom:20px; padding-top:10px;">
					<div class="col-sm-0 col-md-3"></div>
					<div class="col-sm-12 col-md-6  radio_button_class">
						
					</div>
					<div class="col-sm-0 col-md-3"></div>
				</div> 
				
				<div class="row land_owner_a">
					<div class="form-group col-sm-12 col-md-6">
						<label class="col-sm-4">Name or ID</label>
						<input type="text" class="form-control col-sm-8 name_or_id" name="name_or_id">
					</div>
					
					<div class="form-group col-sm-12 col-md-6">
						<label class="col-sm-4">Name</label>
						<input type="text" class="form-control col-sm-8 associate_name" name="associate_name" required="required">
					</div>
				</div> 
				
				<div class="row land_owner_a">
					<div class="form-group col-sm-12 col-md-6">
						<label class="col-sm-4">Address</label>
						<input type="text" class="form-control col-sm-8 address" name="address">
					</div>
					
					<div class="form-group col-sm-12 col-md-6">
						<label class="col-sm-4 ">Mail Id</label>
						 <input type="email" class="form-control col-sm-8 email" name="email" pattern="[A-Za-z0-9._%+-]{3,}@[a-zA-Z]{3,}([.]{1}[a-zA-Z]{2,}|[.]{1}[a-zA-Z]{2,}[.]{1}[a-zA-Z]{2,})">
					</div>								
				</div> 
				
				<div class="row land_owner_a">
					<div class="form-group col-sm-12 col-md-6">
						<label class="col-sm-4">Contact No</label>
						<input type="text" pattern="[6789][0-9]{9}" class="form-control col-sm-8 mobile" name="mobile" style="width: 29% !important; margin-right:10px;" required="required">
						<input type="text" class="form-control col-sm-8 col-xs-6 mobile2" pattern="^[0-9]{10}$" name="mobile2" style="width: 29% !important;">
					</div>
					
					<div class="form-group col-sm-12 col-md-6">
						<label class="col-sm-4">Reference Details</label>
						<input type="text" class="form-control col-sm-8 reference_details" name="reference_details">
					</div>													
				</div> 
				
				<div class="row land_owner_a">							
					<div class="form-group col-sm-12 col-md-6">
						<label class="col-sm-4">PAN No</label>
						<input type="text" class="form-control col-sm-8 pan_number" name="pan_number" pattern="[a-zA-Z0-9]{10}$">
					</div>
					<div class="form-group col-sm-12 col-md-6">
						<label class="col-sm-4">Adhar No</label>
						<input type="text" class="form-control col-sm-8 adhar_number" pattern="[0-9]{12}" name="adhar_number">
					</div>											
				</div>

<div class="form-group col-sm-12 col-md-6">
					<label class="col-sm-4 col-md-4">Scanned copy</label>
					 <div class="scanned_image"></div>
				</div>

</div> 
				
				<hr/>
						
				<div class="row land_owner_a for_executive" style="display:none">
					<div class="form-group col-sm-12 col-md-6">
						<label class="col-sm-4">Basic Target (Sqft)</label>
						<input type="text" class="form-control col-sm-8 basic_target" name="basic_target">
					</div>
					
					<div class="row land_owner_a" style="padding-bottom:20px; padding-top:10px;">
						<div class="col-sm-12 col-md-6">
							<label class="radio-inline"><input style="width:auto !important;" type="radio" value="incentive_in_percentage" name="incentive_type" id="incentive_in_percentage">In Percentage</label>
							<label class="radio-inline"><input style="width:auto !important;" type="radio" value="incentive_in_rs" name="incentive_type" id="incentive_in_rs">In Rupees</label>
						</div>
					</div> 
					
					<div class="form-group col-sm-12 col-md-6 incen_per" style="display:none;">
						<label class="col-sm-4 ">Incentive(%)</label>
						 <input type="number" class="form-control col-sm-12 incentive_in_percentage" name="incentive_in_percentage">
					</div>	
					
					<div class="form-group col-sm-12 col-md-6 incen_rs" style="display:none;">
						<label class="col-sm-4 ">Incentive(In Rs)</label>
						<input type="number" class="form-control col-sm-12 incentive_in_rs"  name="incentive_in_rs">
					</div>
				</div> 
				
				<div class="row land_owner_a for_logistic" style="display:none">
					<div class="form-group col-sm-12 col-md-6">
						<label class="col-sm-4">Incentive Amount (In Rs)</label>
						<input type="text" class="form-control col-sm-8 incentive_target" name="incentive_target">
					</div>
					
				</div> 
				
				<div class="row land_owner_a">
					<div class="col-sm-4 col-md-4"></div>
					<div class="col-sm-4 col-md-4">
						<button type="submit" class="btn btn-primary center-block submit">Submit</button>
					</div>
					<div class="col-sm-4 col-md-4"></div>													
				</div> 
			
			</form>

</div>

</div>
    </div>
  </div>

$('input[name=incentive_type').change(function()
{
    var value = $( 'input[name=incentive_type]:checked' ).val();
   
    if(value == "incentive_in_percentage")
    {
        $('.incen_per').show();
        $('.incen_rs').hide();
    }
    else if(value == "incentive_in_rs")
    {
        $('.incen_rs').show();
        $('.incen_per').hide();
    }
});

{name:' ',index:' ',editable:false,align: "center",editrules:{required: true}, width:100,cellattr: function (rowId, tv, rawObject, cm, rdata) 
						{
                	     return ' onclick="fun($(this))" ';
                		},formatter:function (cellvalue, options, rowObject) {    
						return "<input type='button' value='EDIT' onclick='some_function' data-toggle='modal' data-target='#edit_modal' \>";
			}},	
			  {name:'delete',index:'delete',align: "center",editable:false,editrules:{required: true}, width:100,cellattr: function (rowId, tv, rawObject, cm, rdata) 
						{
                	     return ' onclick="fun_delete($(this))" ';
                		},formatter:function (cellvalue, options, rowObject) {    
			return "<input type='button'  value='DELETE'  \>";
			  }},
			  
	      	    ],
				 height: 'auto',
	      	  rowNum:20,
		      	rowTotal: 2000,
		      	rowList : [10,20,30,50,100,500,1000],
		      	rownumbers: true,
		      	rownumWidth: 40,
		      	pager:"#pager3", 
		      	sortname:'owner_id', 
		      	viewrecords: true,
		      	gridview: true,
		      	autowidth: true,
		      	sortorder:"asc",
		      	shrinkToFit: false,
		      	
		      	 emptyrecords: 'No records to display',
		       //  multiselect: true,
		         // multiboxonly: true,
		      	loadonce:true,
				caption:"Broker List",
			
		});

$("#list3").jqGrid("setLabel", "rn", "SL");

$("#list3").jqGrid('filterToolbar',{searchOperators : false}); //for multisearch code,remove if not required

$("#list3").jqGrid('navGrid','#pager3',
			{edit:true,add:false,del:false,search:true,refreshstate:"current"},
			{ },
	        { },
	        { }, 
			{
		    	sopt:['eq', 'ne', 'lt', 'gt', 'cn', 'bw', 'ew'],
		        closeOnEscape: true, 
		        	multipleSearch: true, 
		         	closeAfterSearch: true }
		).navButtonAdd('#pager3',
 				{ 	caption:"Print", 
					buttonicon:"ui-icon-print", 
 					onClickButton:print_page,
 					position: "last", 
					title:"", 
 					cursor: "pointer",
					id:"client_delete_new"
 				} 
		);	
 		$("#list3").navButtonAdd('#pager3',
				{ 	caption:"Export", 
					buttonicon:"", 
					onClickButton: export_page,
					position: "last", 
					title:"", 
					cursor: "pointer",
					id:"client_delete"
				} 
		);

});

function export_page() {
	
	id = jQuery("#list3").jqGrid('getDataIDs');
	var type= $('#type').val();
	
	$.ajax({
        type   : 'post',
        url    : "<?php echo site_url("get_table_details")?>?type="+type, 
        data   : {id:id},
                                  
          success:function(response){
          //response=jQuery.parseJSON(data);
          console.log(response);
         var count =1;
         
                var content = '';
                content +='<thead><tr><th>Sl No</th> <th>Type</th> <th>Name</th> <th>Associate</th> <th>Email</th> <th>Mobile</th> <th>Mobile2</th> <th>Address</th><th>Pan</th><th>Reference</th><th>Adhar.No</th></tr></thead>';
                 $.each(response,function(key,vas){

content +='<tr><td>'+count+'</td> <td>'+vas.type+'</td> <td>'+vas.name_or_id+'</td> <td>'+vas.associate_name+'</td> <td>'+vas.email+'</td><td>'+vas.mobile+'</td> <td>'+vas.mobile2+'</td><td>'+vas.address+'</td><td>'+vas.pan_number+'</td><td>'+vas.reference_details+'</td> <td>'+vas.adhar_number+'</td></tr>';
        				count++;
             
                });
                 $('.export_table').append(content);
                 
                 export_data();
          			}
				 });
				
}

function export_data()
	{
		$("#export_table").table2excel({
			exclude: ".noExl",
			name: "Excel Document Name",
			filename: "Broker List",
			fileext: ".xls",
			exclude_img: true,
			exclude_links: true,
			exclude_inputs: true
		});						   
	}

});
function fun(rowId)
{
	var type= $('#type').val();

if(type == "Logistic")
        {
            $('.for_logistic').show();
            $('.for_executive').hide();
        }
        else if(type == "Executives")
        {
            $('.for_executive').show();
            $('.for_logistic').hide();
        }
        
        
        $('.incen_per').hide();
        
   var id = rowId.closest('tr').attr('id');

$.ajax({          
       type   : 'post',
       url    : "<?php echo site_url("edit-broker")?>?type="+type,
       data   : {broker_id:id},

success:function(response) {
    //    response=jQuery.parseJSON(response);
			console.log(response);

if(response.result == 1) 
           {
           	$(".broker_id_pk").val(response.broker_details.broker_id);
           	$(".name_or_id").val(response.broker_details.name_or_id);
           	$(".associate_name").val(response.broker_details.associate_name);
           	$(".address").val(response.broker_details.address);
           	$(".email").val(response.broker_details.email);
           	$(".mobile").val(response.broker_details.mobile);
        	$(".mobile2").val(response.broker_details.mobile2);
           	$(".reference_details").val(response.broker_details.reference_details);
           	$(".pan_number").val(response.broker_details.pan_number);
           	$(".adhar_number").val(response.broker_details.adhar_number);
           	$(".basic_target").val(response.broker_details.basic_target);
           	if(response.broker_details.type == "Executives")
           	{
           	    if(response.broker_details.incentive_type == "incentive_in_percentage")
               	{
               	    $("#incentive_in_percentage").prop("checked", true);
               	    $('.incen_per').show();
                    $('.incen_rs').hide();
                    $('.incentive_in_percentage').val(response.broker_details.incentive_percent);
               	}
               	else if(response.broker_details.incentive_type == "incentive_in_rs")
               	{
               	    $("#incentive_in_rs").prop("checked", true);
               	    $('.incen_rs').show();
                    $('.incen_per').hide();
                    $('.incentive_in_rs').val(response.broker_details.incentive_rupees);
               	}
               	else
               	{
               	    $('.incen_per').hide();
               	    $('.incen_rs').hide();
               	}
           	}
           	else if(response.broker_details.type == "Logistic")
           	{
           	    $('.incentive_target').val(response.broker_details.incentive_target_rs);
           	}

var ext = response.broker_details.scan_copy.split('.').pop();
				if(ext == 'JPG' || ext == 'jpg' || ext == 'JPEG' || ext == 'jpeg' || ext == 'png' || ext == 'PNG')
				{
           		$(".scanned_image").html('<img src ="<?php echo base_url("broker_uploads");?>/'+response.broker_details.scan_copy+'" style="width:250px;height:350px"/>');
				}
				else if(ext == 'pdf')
				{
					$(".scanned_image").html('<embed src ="<?php echo base_url("broker_uploads");?>/'+response.broker_details.scan_copy+'" style="width:250px;height:350px"/>');
				}

var content = '';
				if(response.broker_details.type == "Executives")
                {
                	content += '<label class="radio-inline"><input type="radio" value="Executives" name="type" checked style="margin-top: 5px; !important">Executives</label>';
                }
                else
                {
                	content +='<label class="radio-inline"><input type="radio" value="Executives" name="type" style="margin-top: 5px; !important">Executives</label>';
                }

if(response.broker_details.type == "Associate")
                {
                	content += '<label class="radio-inline"><input type="radio" value="Associate" name="type" checked style="margin-top: 5px; !important">Associate</label>';
                }
                else
                {
                	content +='<label class="radio-inline"><input type="radio" value="Associate" name="type" style="margin-top: 5px; !important">Associate</label>';
                }

if(response.broker_details.type == "Logistic")
                {
                	content += '<label class="radio-inline"><input type="radio" value="Logistic" name="type" checked style="margin-top: 5px; !important">Logistic</label>';
                }
                else
                {
                	content +='<label class="radio-inline"><input type="radio" value="Logistic" name="type" style="margin-top: 5px; !important">Logistic</label>';
                }
				if(response.broker_details.type == "Sub Associate")
                {
                	content += '<label class="radio-inline"><input type="radio" value="Sub Associate" name="type" checked style="margin-top: 5px; !important">Sub Associate</label>';
                }
                else
                {
                	content +='<label class="radio-inline"><input type="radio" value="Sub Associate" name="type" style="margin-top: 5px; !important">Sub Associate</label>';
                }

$(".radio_button_class").html(content);
                
                $('input[name=type').change(function()
                {
                    var value = $( 'input[name=type]:checked' ).val();
                    if(value == "Logistic")
                    {
                        $('.for_logistic').show();
                        $('.for_executive').hide();
                    }
                    else if(value == "Executives")
                    {
                        $('.for_executive').show();
                        $('.for_logistic').hide();
                    }
                });
                
                $("#edit_modal").modal("show");
                $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
                }
            }
	            });  
}

function fun_delete(rowId)
{
	var type= $('#type').val();
	var id = rowId.closest('tr').attr('id'); 
  var broker_id=id;
  swal({

title: "Are you sure?",
      text: "You will not be able to recover this data!",
      type: "warning",   showCancelButton: true,
      confirmButtonColor: "#DD6B55",
      confirmButtonText: "Yes, delete it!",
      cancelButtonText: "No, cancel plz!",
      closeOnConfirm: false,
      closeOnCancel: false 
      },

function(isConfirm){

if (isConfirm) {

$(".sweet-alert").hide();
          $(".sweet-overlay").hide();
         // test.attr('disabled', 'disabled');
          //test.text("Deleting...");
              $.ajax({          
                      type   : 'post',
                      url    : "<?php echo site_url("delete-broker")?>?type="+type,
                      data   : {broker_id:broker_id},

success:function(response) {
                      //response=jQuery.parseJSON(response);
							console.log(response);

if(response.result == 1) 
                          {
                             toastr["success"](response.message);
                             //BrokersList();
                             $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
                          }
                      }
                  });

} 
                      else {

$(".sweet-alert").hide();
                      $(".sweet-overlay").hide();
                  }

});

}

$('.update_form').submit(function(e){    
    e.preventDefault();
	 var type= $('#type').val();
     formdata = new FormData($(this)[0]);

// $(".submit").attr('disabled', 'disabled');
        // $(".submit").text("Updating...");

$.ajax({

type   : 'post',
            url    : "<?php echo site_url("update-broker")?>?type="+type,
            data   : formdata,
            contentType: false,
            processData: false,
                                      
              success:function(response){
              //response=jQuery.parseJSON(response);
              console.log(response);

if(response.result==1)
                {
                	$("#edit_modal").modal("hide");
                	 $("#list3").jqGrid('setGridParam',{datatype:'json'}).trigger('reloadGrid');
                    toastr["success"](response.message);
                    $('.update_form')[0].reset();
                    $(".submit").text("Submit");    
                    $(".submit").removeAttr('disabled');                
                }
                else if(response.result==2)
                {
                    toastr["error"](response.message);    
                    $(".submit").text("Submit"); 
                    $(".submit").removeAttr('disabled');                   
                }
                else 
                {
                    toastr["error"](response.message);                       
	                $(".submit").text("Submit"); 
	                $(".submit").removeAttr('disabled');                      
                }
               
            }
            
     });
         
 });

function SortedResult(brokers_list)
{
	tbody.empty();
	var table_row = [];
	
	var slno  = 1;
	var index = 1;

$.each(brokers_list,function(idx,vx){
    var row = [];
    var image = "";

row.push(slno);    
    
   	image='<img src ="<?php echo base_url("broker_uploads");?>/'+vx.scan_copy+'" style="width:80px;height:70px"/>';

row.push(vx.type);
        row.push(vx.name_or_id);
        row.push(vx.associate_name);
        row.push(vx.email);
        row.push(vx.mobile);
        row.push(vx.address);
        row.push(vx.pan_number);
        row.push(vx.reference_details);
        row.push(vx.adhar_number);
        
        var table_content = '';

table_content += '<div style="float:left;">';				               
        table_content += '<a data-toggle="tooltip" title="Edit" class="edit" broker_id="'+vx.broker_id+'" href="javascript:void(0);"><span class="glyphicon glyphicon-edit"></span></a> <a data-toggle="tooltip" title="Delete" class="delete" broker_id="'+vx.broker_id+'" href="javascript:void(0);"><span class="glyphicon glyphicon-trash"></span></a>';				
        table_content += '</div>'
        
        row.push(table_content);   
        table_row.push(row);
        slno++;
        index ++;
    
    });

datatable.clear();
    datatable.rows.add(table_row).draw();
    datatable.draw(); 
} 
</script>

$(document).ready(function(){

$("#sites_print").click(function(){
        var divToPrint=document.getElementById("print_sites_report");
		   newWin= window.open("");
		   newWin.document.write(divToPrint.outerHTML);
		   newWin.print();
		   newWin.close();	
		 });
		    
		   $("#sites_export").click(function(){
         $(".sites_table_print").table2excel({
					exclude: ".noExl",
					name: "Excel Document Name",
					filename: "Broker List",
					fileext: ".xls",
					exclude_img: true,
					exclude_links: true,
					exclude_inputs: true
				});						   
		    });		
		  
});

</script>
<style type="text/css">

.content-wrapper, .right-side {			
		//min-height:900px !important;
	}	
	
	a {
	 color: inherit; 
	}
	.checkbox input[type=checkbox], .checkbox-inline input[type=checkbox], .radio input[type=radio], .radio-inline input[type=radio] {
    position: absolute;
    margin-top: 4px\9;
	margin-left: -47px;
}
input[type=checkbox], input[type=radio] {
    margin: -8px 0 0;
    margin-top: 1px\9;
    line-height: normal;
}

.radio-inline input[type=radio] {
    margin-left: -20px;
    width: 15px !important;
    margin-top: -5px;
}

</style>

<?php echo view('includes/footer');?>