EVOLUTION-NINJA
Edit File: potentials_list.php
<?php $this->load->view('includes/admin_header');?> <div class="main-container " id="main-container"> <!-- <div id="sidebar" class="sidebar responsive ace-save-state"> <ul class="nav nav-list"> <li class=""> <a href=""></a> </li> <li class=""> <a href=""><span class="menu-text" > LEADS </span></a> </li> <li class=""> <a href="newlead.html"><span class="menu-text" > Add New Lead </span></a> <li class=""> <a href="lead1 - edited.html"><span class="menu-text" > Lead List </span></a> </li> </ul>/.nav-list </div> --> <div class="main-content"> <div class="main-content-inner"> <div class=" page-content" style="background-color:#f0f0f0;"> <div class="row"> <div class="col-sm-10" style=""> <!-- <select> <option>All Potentials</option> <option>Closing Next Month</option> <option>Closing This Month</option> <option>My Potentials</option> <option>New Last Week</option> <option>New This Week</option> <option>Recently Created Potentials</option> <option>Recently Modified Potentials</option> <option>Unread Potentials</option> </select> --> </div> <div class="col-sm-2 sort-by"> <ul class="breadcrumb"> <li> <div class="col-sm-1 pd-7"> <div style="float:right;"> <div class="" style="padding-top:10px;"><a href="<?php echo base_url('add-potential');?>"><i class=" fa fa-plus fa-2x"></i></a></div> </div> </div> </li> <li> <button type="button" id="potentials_list" class="btn btn-sm">Export</button> </li> </ul> </div> </div> <div class="row" style="background-color:white;margin-top:10px;"> <div class="col-xs-12"> <!-- PAGE CONTENT BEGINS --> <div class="hr dotted"></div> <div> <div class="row search-page" id="search-page-1"> <div class="col-xs-12"> <div class="row"> <label><input type="radio" name="status" value="CLOSED" class="inv_st">CLOSED</label>   <label><input type="radio" name="status" value="ONGOING" class="inv_st" checked >ONGOING</label>   <div class="col-xs-12 col-sm-12"> <div class="row"> <div id="addele_more"> <div class="col-sm-12 table-responsive"> <table class="table" id="maintable"> <thead> <tr id="column_id"> <th>Sl No</th> <th>Potential/Company Name </th> <th>Description</th> <th>City</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> <tbody id="ddd"> <?php $i=1; foreach($potential_data as $value){ ?> <tr class="hoverr click-on information"> <td><?php echo $i; ?></td> <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->p_city;?></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->acc_name; ?></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><?php echo $value->user_name; ?></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> </td> </tr> <?php $i++; } ?> </tbody> </table> </div> </div> </div> </div> </div> </div> </div> </div> </div><!-- /.col --> </div><!-- /.row --> </div><!-- /.page-content --> </div> </div><!-- /.main-content --> <link rel="stylesheet" href="<?php echo base_url('admin_assets/assets/datatables/dataTables.bootstrap.css');?>"> <script src="<?php echo base_url('admin_assets/assets/js/jquery-2.1.4.min.js');?>"></script> <!-- <script src="<?php echo base_url('admin_assets/assets/js/bootstrap.min.js');?>"></script> --> <script src="<?php echo base_url('admin_assets/assets/js/jquery-ui.min.js');?>"></script> <!-- page specific plugin scripts --> <script src="<?php echo base_url('admin_assets/assets/js/tree.min.js');?>"></script> <script src="<?php echo base_url('admin_assets/assets/js/select2.min.js');?>"></script> <script src="<?php echo base_url('admin_assets/assets/js/jquery-ui.custom.min.js');?>"></script> <script src="<?php echo base_url('admin_assets/assets/js/jquery.ui.touch-punch.min.js');?>"></script> <script src="<?php echo base_url('admin_assets/assets/js/holder.min.js');?>"></script> <!-- ace scripts --> <script src="<?php echo base_url('admin_assets/assets/js/ace-elements.min.js');?>"></script> <script src="<?php echo base_url('admin_assets/assets/js/ace.min.js');?>"></script> <script src="<?php echo base_url('admin_assets/assets/js/jquery.table2excel.js');?>"></script> <script src="<?php echo base_url('admin_assets/assets/datatables/jquery.dataTables.min.js');?>"></script> <script src="<?php echo base_url('admin_assets/assets/datatables/dataTables.bootstrap.min.js');?>"></script> <!-- inline scripts related to this page --> </body> </html> <script type="text/javascript"> 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> <script type="text/javascript"> 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> <style type="text/css"> #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> <script> $('.inv_st').change(function(e){ e.preventDefault(); $('#maintable').DataTable().destroy(); var status=$("input[type=radio][name=status]:checked" ).val(); // console.log(status); $.ajax({ type : 'post', url : '<?php echo site_url("potential-status-data")?>', data : {'status':status}, success:function(response){ response=jQuery.parseJSON(response); var content=''; $.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 += ' '; 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> <script> $('#cbxShowHide').click(function(){ this.checked?$('#block').show():$('#block').hide(); }); </script> <!--<script type="text/javascript">--> <!-- $(".information").click(function(){ --> <!-- window.location.href = '';--> <!--});--> <!--</script>--> <?php $this->load->view('includes/admin_footer');?>