EVOLUTION-NINJA

Edit File: potentials_list.php

<?php $this->load->view('includes/admin_header');?>

<!-- <div id="sidebar" class="sidebar responsive ace-save-state">

</li>

<a href=""><span class="menu-text" > LEADS </span></a>

</li>

</li>

</ul>/.nav-list

</div> -->

<!-- <select>

<option>All Potentials</option>

<option>Closing Next Month</option>

<option>Closing This Month</option>

<option>My Potentials</option>

<option>Recently Created Potentials</option>

<option>Recently Modified Potentials</option>

<option>Unread Potentials</option>

</select>		 -->

</div>

<li>

</li>

<li>

<button type="button" id="potentials_list" class="btn btn-sm">Export</button>

</li>

</ul>

</div>

<div>

<label><input type="radio" name="status" value="CLOSED" class="inv_st">CLOSED</label>&nbsp&nbsp
					<label><input type="radio" name="status" value="ONGOING" class="inv_st" checked >ONGOING</label>&nbsp&nbsp

<thead>

<th>Potential/Company Name </th>

<th>Description</th>

<th>Amount</th>

<th>Stage</th>

<th>Closing Date</th>

<th>Account Name</th>

<th>Contact Name</th>
												
												<th>Contact Number</th>
												
												<th>Address</th>
												
												<th>Email Id</th>

<th>Potential Owner</th>

<th>Action</th>

</tr>

</thead>

<?php $i=1; foreach($potential_data as $value){

<td><a href="<?php echo site_url("potential-info/$value->potential_id");?>"><?php echo $value->potential_name; ?></a></td>

<?php 
													  $this->db->from(' potential_attach_notes');
													  $this->db->where('potential_id',$value->potential_id);
													  $this->db->order_by('notes_id','DESC');
													  $query=$this->db->get();
        												$note=$query->row();
													   ?>									
													  <td><?php if($note){ echo $note->potential_notes;} ?></td>

<td><?php echo $value->amount; ?></td>

<td><?php echo $value->stage; ?></td>

<td><?php  if($value->closing_date!='0000-00-00'){ $date = new DateTime($value->closing_date); echo $date->format('d-m-Y');}  ?></td>

<td><?php echo $value->contact_name; ?></td>
													  
													   <td><?php echo $value->phone_number; ?></td>

<td><?php echo $value->p_address; ?></td>
													  
													   <td><?php echo $value->potential_email; ?></td>

<td>
													  	<span class="glyphicon glyphicon-trash" onclick='delete_lead("<?php echo $value->potential_id; ?>");' ></span><?php if($value->stage=='CLOSED'){  ?>
							
							 <button class="button1<?php echo $value->potential_id; ?>"  onclick="closed('<?php echo $value->potential_id; ?>');" readonly>Closed</button>
							<?php } else{ ?>

<button class="button1<?php echo $value->potential_id; ?>"  onclick="closed('<?php echo $value->potential_id; ?>');">Close</button>
							<?php } ?></td>

</td>

</tr>

<?php $i++; } ?>

</tbody>

</table>
									</div>

</div>

</div>

</div>

</div>

</div>

</div>

<script src="<?php echo base_url('admin_assets/assets/js/jquery-ui.min.js');?>"></script>

</body>

</html>

function closed(lead_id){

swal({

title: "Are you sure?",
	  text: "You Close the Potential data!",
	  type: "warning",   showCancelButton: true,
	  confirmButtonColor: "#DD6B55",
	  confirmButtonText: "Yes, Close it!",
	  cancelButtonText: "No, cancel plz!",
	  closeOnConfirm: false,
	  closeOnCancel: false 
	  },
	function(isConfirm){   
	  if (isConfirm) { 
	      $(".sweet-alert").hide();
	      $(".sweet-overlay").hide();

$.ajax({
	                type   : 'post',
	                url    : '<?php echo site_url("yaskawa/close_potential")?>',
	                data   : {'id':lead_id},                        
	                  success:function(response){
	                  response=jQuery.parseJSON(response);
	                  console.log(response);

if(response)
	                    {
		                    toastr['success']("Potential Closed"); 
		                             
	                    }

}

});

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

$("#potentials_list").click(function(){

//alert();

$("#maintable").table2excel({

exclude: ".noExl",

name: "Excel Document Name",

filename: "potential-list",

fileext: ".xls",

exclude_img: true,

exclude_links: true,

exclude_inputs: true

});

</script>

function delete_lead(id)
	{
	var 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();
				$.ajax({
					
					url:"<?php echo site_url("delete-potential")?>",
					type:"POST",
					data:{id:id},
					success:function(response) {
						response=jQuery.parseJSON(response);
							console.log(response);
							if(response.result == 1) 
							{
								toastr["success"]("Deleted successfully");								
								
							}
						}

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

$('.table').dataTable();

$(".table td").hover(function() {

//$(this).prop('title', $.trim($(this).text()));

addclass();

});

function addclass(){

$('.table td').addClass("edit1");

}

</script>

#treeview-searchable .node-disabled {

display: none;

}

.hoverr:hover .addd {

display:block;

}

.addd{

display:none;

}

.add_more {

padding: 0px 7px !important;

font-size: 12px !important;

}

#block{display:none;padding-left:10px;}

.pd-7{

padding-right:7px !important;

padding-left:7px !important;

}

.pd-9{

padding:2px 9px !important;

}

</style>

$.each(response,function(key,val){
                  		var key=key+1;
          
       						content+='<tr>';														
							content+='<td>'+key+'</td>';									
							content+='<td><a href="<?php echo site_url("potential-info");?>/'+val.potential_id+'">'+val.potential_name;+'</a></td>';						 															
							content+='<td>'+val.note+'</td>';

if(val.p_city!=null){

content+='<td>'+val.p_city+'</td>';

}else{

content+='<td></td>';
							}

content+='<td>'+val.amount+'</td>';

content+='<td>'+val.stage+'</td>';

content+='<td>';
							  if(val.closing_date!='0000-00-00'){

val.closing_date;

}
							  	 content+='</td>';

if(val.acc_name!=null){

content+='<td>'+val.acc_name+'</td>';

}else{

content+='<td></td>';
							}

content+='<td>'+val.contact_name+'</td>';
							  
							content+='<td>'+val.phone_number+'</td>';

if(val.p_address!=null){

content+='<td>'+val.p_address+'</td>';

}else{

content+='<td></td>';
							}
							  
							   //content+='<td>'+val.email_id+'</td>';

if(val.acc_email!=null){

content+='<td>'+val.acc_email+'</td>';

}else{

content+='<td></td>';
							}

content+='<td>'+val.user_name+'</td>';

content+='<td><span class="glyphicon glyphicon-trash" onclick="delete_lead('+val.potential_id+');" ></span></td>';
							  
							  content += '&nbsp;&nbsp;';
							  
							  if (val.stage === 'CLOSED') {
    // If the stage is closed, show the "Closed" button
    content += '<button class="button1' + val.potential_id + '" onclick="closed(\'' + val.potential_id + '\');" readonly>Closed</button>';
} else {
    // Otherwise, show the "Close" button
    content += '<button class="button1' + val.potential_id + '" onclick="closed(\'' + val.potential_id + '\');">Close</button>';
}

content+='</td>';

content+='</tr>';

});

$('#ddd').empty();
                  	$('#ddd').append(content);
                  	datatable = $('.table').DataTable();

}

});
	});

$(".col1").click(function(){

var text = $(this).val();

var test = $(this);

if($(this).is(':checked'))
        {	
            $("#column_id").append('<th>'+text+'</th>');

}
        else
        {
            $(".column_id").empty();

$('input[name="columns[]"]:checked').each(function() {

console.log(this.value);

$(".column_id").append('<th>'+this.value+'</th>');

});

}

});

</script>

$('#cbxShowHide').click(function(){

this.checked?$('#block').show():$('#block').hide();

});

</script>

<?php $this->load->view('includes/admin_footer');?>