Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/demo.sigmacomputers.in/public_html/arjun_erp/application/controllers

Free Space:

4.09 TB

🔧 Quick Actions

✏️ Editing: Lead.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Lead extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->library('excel');
    $this->load->model(array('Lead_model'));
    $this->load->model(array('Customer_model'));
    $this->load->library("pagination");
    //if ($this->session->userdata['username'] == TRUE)
    if (isset($this->session->userdata['username']) && $this->session->userdata['username'] == TRUE)
        {
            //do something
        }else{
            redirect('login'); //if session is not there, redirect to login page
        } 
    date_default_timezone_set("Asia/Kolkata");
    $this->session->set_userdata('comtitle', 'Lead Management');
  }

public function checkContactNoUnique()
  {
    $val = $_POST['value'];
    $result = $this->Lead_model->checkContactNoUnique($val);
    echo count($result);
  }

public function checkEmailIdUnique()
  {
    $val = $_POST['value'];
    $result = $this->Lead_model->checkEmailIdUnique($val);
    echo count($result);
  }

public function checkContactNoUniqueEdit()
  {
    $val = $_POST['value'];
    $lid = $_POST['lid'];
    $result = $this->Lead_model->checkContactNoUniqueEdit($val,$lid);
    echo count($result);
  }

public function checkEmailIdUniqueEdit()
  {
    $val = $_POST['value'];
    $lid = $_POST['lid'];
    $result = $this->Lead_model->checkEmailIdUniqueEdit($val,$lid);
    echo count($result);
  }

public function lead_export()
  {
    //echo $this->input->post('filterlsource');
    $fbychange = isset($_SESSION['filterfby'])?$_SESSION['filterfby']:'all';
    $lsourcechange = isset($_SESSION['filterlsource'])?$_SESSION['filterlsource']:'all';
    $pcategorychange = isset($_SESSION['filterpcategory'])?$_SESSION['filterpcategory']:'all';
    $converted = isset($_SESSION['converted'])?$_SESSION['converted']:'0';
    $dtrange = isset($_SESSION['ldtrange'])?$_SESSION['ldtrange']:'';
    $schange = isset($_SESSION['lschange'])?$_SESSION['lschange']:'all';
    $canceled = isset($_SESSION['canceled'])?$_SESSION['canceled']:'0';
    $lsearch_change = isset($_SESSION['lsearch_change'])?$_SESSION['lsearch_change']:'';

if ($lsearch_change != '') {
        $sc = 'AND (l.lead_no LIKE "%'.$lsearch_change.'%" OR l.lead_name LIKE "%'.$lsearch_change.'%" OR au.displayname LIKE "%'.$lsearch_change.'%" OR l.contact_no LIKE "%'.$lsearch_change.'%" OR ls.lead_source LIKE "%'.$lsearch_change.'%")';
      }
      else {
        $sc = '';
      }
      if($lsourcechange!='all')
        $ls = 'AND l.lead_source='.$lsourcechange;
      else
        $ls = '';

if($pcategorychange!='all'){
        $pc = 'AND lp.product_category_id='.$pcategorychange;
      }
      else
        $pc = '';

if($fbychange!='all'){
        $fby = 'AND l.followed_by='.$fbychange;
      }
      else
        $fby = '';

if($converted==0)
      {
        $cv = ' and l.converted!=1';
      }
      else
      {
        $cv = '';
      }

if($canceled==0)
      {
        $cn = ' and l.status!=2';
      }
      else
      {
        $cn = '';
      }

if($schange == '')
        $schange='all';

if($schange == 'all')
      {
        $data['drnge'] = '';
        $lead_list = $this->db->query("SELECT l.*, au.displayname,ls.lead_source FROM lead l,admin_users au,lead_source ls,lead_product lp WHERE l.followed_by = au.id AND ls.lead_source_id = l.lead_source AND l.lead_id = lp.lead_id $cv $cn $ls $pc $fby $sc GROUP BY l.lead_id ORDER BY l.lead_id DESC")->result_array();
      }
      elseif($schange == 'today')
      {
        $lead_list = $this->db->query("SELECT l.*, au.displayname,ls.lead_source FROM lead l,admin_users au,lead_source ls,lead_product lp WHERE l.followed_by = au.id AND ls.lead_source_id = l.lead_source AND l.lead_id = lp.lead_id $cv $cn $ls $pc $fby $sc and STR_TO_DATE(l.created_on, '%Y-%m-%d') = CURDATE() GROUP BY l.lead_id ORDER BY l.lead_id DESC")->result_array();
      }
      else if($schange == 'thisweek')
      {
        $lead_list = $this->db->query("SELECT l.*, au.displayname,ls.lead_source FROM lead l,admin_users au,lead_source ls,lead_product lp WHERE l.followed_by = au.id AND ls.lead_source_id = l.lead_source AND l.lead_id = lp.lead_id $cv $cn $ls $pc $fby $sc and YEARWEEK(STR_TO_DATE(l.created_on, '%Y-%m-%d'), 1) = YEARWEEK(CURDATE(), 1) GROUP BY l.lead_id ORDER BY l.lead_id DESC")->result_array();
      }      
      else if($schange == 'thismonth')
      {
        $lead_list = $this->db->query("SELECT l.*, au.displayname,ls.lead_source FROM lead l,admin_users au,lead_source ls,lead_product lp WHERE l.followed_by = au.id AND ls.lead_source_id = l.lead_source AND l.lead_id = lp.lead_id $cv $cn $ls $pc $fby $sc and MONTH(STR_TO_DATE(l.created_on, '%Y-%m-%d')) = MONTH(CURDATE()) and YEAR(STR_TO_DATE(l.created_on, '%Y-%m-%d')) = YEAR(CURDATE()) GROUP BY l.lead_id ORDER BY l.lead_id DESC")->result_array();
      }
      else if($schange == 'thisyear')
      {
        $finstart = $_SESSION['finstart'];
        $finend = $_SESSION['finend'];

$lead_list = $this->db->query("SELECT l.*, au.displayname,ls.lead_source FROM lead l,admin_users au,lead_source ls,lead_product lp WHERE l.followed_by = au.id AND ls.lead_source_id = l.lead_source AND l.lead_id = lp.lead_id $cv $cn $ls $pc $fby $sc and STR_TO_DATE(l.created_on, '%Y-%m-%d') >= STR_TO_DATE('".$finstart."', '%Y-%m-%d') and STR_TO_DATE(l.created_on, '%Y-%m-%d') <= STR_TO_DATE('".$finend."', '%Y-%m-%d') GROUP BY l.lead_id ORDER BY l.lead_id DESC")->result_array();
      }
      else
      {
        $data['drnge'] = $dtrange;
        $dr = explode(' - ', $dtrange);

$fd = explode('/', $dr[0]);
        $td = explode('/', $dr[1]);

$fdate = $fd[2].'-'.$fd[0].'-'.$fd[1];
        $tdate = $td[2].'-'.$td[0].'-'.$td[1];

$lead_list = $this->db->query("SELECT l.*, au.displayname,ls.lead_source FROM lead l,admin_users au,lead_source ls,lead_product lp WHERE l.followed_by = au.id AND ls.lead_source_id = l.lead_source AND l.lead_id = lp.lead_id $cv $cn $ls $pc $fby $sc and STR_TO_DATE(l.created_on, '%Y-%m-%d') >= STR_TO_DATE('".$fdate."', '%Y-%m-%d') and STR_TO_DATE(l.created_on, '%Y-%m-%d') <= STR_TO_DATE('".$tdate."', '%Y-%m-%d') GROUP BY l.lead_id ORDER BY l.lead_id DESC")->result_array();
      }

$objPHPExcel = new PHPExcel();
      $activeSheet = $objPHPExcel->getActiveSheet();
      $styleArray = array(
          'font' => array(
              'bold' => true,
              'color' => array('rgb' => '000000')
          )/*,
          'alignment' => array(
              'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_CENTER,
          )*/
      );

$objPHPExcel->getActiveSheet()->setCellValue('A1', 'Lead No');
      $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
      $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Lead Name');
      $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);
      $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Lead Date');
      $objPHPExcel->getActiveSheet()->getStyle('C1')->applyFromArray($styleArray);
      $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Contact No');
      $objPHPExcel->getActiveSheet()->getStyle('D1')->applyFromArray($styleArray);
      $objPHPExcel->getActiveSheet()->setCellValue('E1', 'Lead Source');
      $objPHPExcel->getActiveSheet()->getStyle('E1')->applyFromArray($styleArray);
      $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Followed By');
      $objPHPExcel->getActiveSheet()->getStyle('F1')->applyFromArray($styleArray);
      $objPHPExcel->getActiveSheet()->setCellValue('G1', 'Status');
      $objPHPExcel->getActiveSheet()->getStyle('G1')->applyFromArray($styleArray);

$i=2; 
      foreach ($lead_list as $u_list ) { 
        $res = $this->Lead_model->get_lead_followups_by_id($u_list['lead_id']);
        $fupcnt = count($res);
        $pleads = $this->Lead_model->get_lead_followups_by_pending_id($u_list['lead_id']);
        if(count($pleads)>0){
          $fcclass = 'm-badge--info';
        }else{
          $fcclass = 'm-badge--danger';
        }

if($fupcnt>0)
        {
          $lfup = $this->Lead_model->get_last_followup_by_id($u_list['lead_id']);
          if($lfup->modified_by==0)
          {
            $lfdate = $lfup->created_on;
            $lfby = $lfup->created_by;
          }
          else
          {
            $lfdate = $lfup->modified_on;
            $lfby = $lfup->modified_by;
          }
        }
        else
        {
          if($u_list['modified_by']==0)
          {
            $lfdate = $u_list['created_on'];
            $lfby = $u_list['created_by'];
          }
          else
          {
            $lfdate = $u_list['modified_on'];
            $lfby = $u_list['modified_by'];
          }
        }

$lfbydet = $this->Lead_model->get_admin_user_by_id($lfby);
        $lfbyname = $lfbydet->displayname;

$datetime1 = new DateTime(date_format(date_create($lfdate),'Y-m-d'));
        $datetime2 = new DateTime(date('Y-m-d'));
        $interval = $datetime1->diff($datetime2);

if($interval->format('%y')==0 && $interval->format('%m')==0)
        {
          $tday = $interval->format('%d').' D';
          $tclass = 'btn-info';
        }
        else if($interval->format('%y')==0 && $interval->format('%m')!=0)
        {
          $tday = $interval->format('%m').' M';
          $tclass = 'btn-warning';
        }
        else
        {
          $tday = $interval->format('%y').' Y';
          $tclass = 'btn-danger';
        }
        $g_settings = general_setting_details();

if($u_list['status']==2){
          $stage = 'Drop';
        }else if($u_list['converted']==1){
          $stage = 'Converted';
        }else{
          $stage = 'Open';
        }

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $u_list['lead_no']);
        $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $u_list['lead_name']);
        $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, date_format(date_create($u_list['created_on']),$g_settings->date_format));
        $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $u_list['contact_no']);
        $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $u_list['lead_source']);
        $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, $u_list['displayname']);
        $objPHPExcel->getActiveSheet()->setCellValue('G'.$i, $stage);

$i++;
      }

$filename='Lead.xlsx'; //save our workbook as this file name
      header('Content-Type: application/vnd.ms-excel'); //mime type
      header('Content-Disposition: attachment;filename="'.$filename.'"'); //tell browser what's the file name
      header('Cache-Control: max-age=0'); //no cache

//save it to Excel5 format (excel 2003 .XLS file), change this to 'Excel2007' (and adjust the filename extension, also the header mime type)
      //if you want to save it as .XLSX Excel 2007 format
      $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007'); 
      $objPHPExcel->setActiveSheetIndex(0);

if (ob_get_contents()) ob_end_clean();
          //force user to download the Excel file without writing it to server's HD
          $objWriter->save('php://output'); 
  }

public function index()
  {
    $config = array();
    $config["base_url"] = base_url() . "lead";
    $config["per_page"] = 10;
    $config["uri_segment"] = 2;
    $config['full_tag_open'] = '<div><ul class="pagination pagination-small pagination-centered">';
    $config['full_tag_close'] = '</ul></div>';
    $config['num_tag_open'] = '<li class="page-item">';
    $config['num_tag_close'] = '</li>';
    $config['cur_tag_open'] = '<li class="page-item active"><a class="page-link" href="#">';
    $config['cur_tag_close'] = '</a></li>';
    $config['next_tag_open'] = '<li class="page-item">';
    $config['next_tagl_close'] = '</a></li>';
    $config['prev_tag_open'] = '<li class="page-item">';
    $config['prev_tagl_close'] = '</li>';
    $config['first_tag_open'] = '<li class="page-item">';
    $config['first_tagl_close'] = '</li>';
    $config['last_tag_open'] = '<li class="page-item">';
    $config['last_tagl_close'] = '</a></li>';
    $config['attributes'] = array('class' => 'page-link');
    $page = ($this->uri->segment(2)) ? $this->uri->segment(2) : 0;
    
    $perpage = $config['per_page'];

$data['user_list'] = $this->Lead_model->get_follower_list(); 
    $data['lead_source'] = $this->Lead_model->get_lead_source(); 
    $data['lead_status'] = $this->Lead_model->get_lead_status(); 
    $data['lead_type'] = $this->Lead_model->get_lead_type(); 
    //$data['product_list'] = $this->Lead_model->get_active_products();
    $data['product_category_list'] = $this->Lead_model->get_product_category();
    //$data['lead_list'] = $this->Lead_model->get_lead_list();
    $data['state_list'] = $this->Lead_model->get_state_list();
    
    $data['overall_count'] = count($this->Lead_model->get_lead_list());    
    $yesterday = date('Y-m-d', strtotime("-1 days"));
    $today = date('Y-m-d');
    $data['today_leads'] = $this->Lead_model->lead_yesterday_count($today);
    $data['yesterday_leads'] = $this->Lead_model->lead_yesterday_count($yesterday);

$data['lead_status_lists'] = $this->Lead_model->lead_status_based_list();

$data['converted_lead'] = $this->Lead_model->converted_lead_list();

$data['cancel_lead'] = $this->Lead_model->cancel_lead_list();

if($_SERVER['REQUEST_METHOD'] == 'POST' || ((isset($_SESSION['converted']) || isset($_SESSION['canceled']) || isset($_SESSION['lschange']) || isset($_SESSION['ldtrange']) || isset($_SESSION['lsearch_change']) || isset($_SESSION['filterlsource']) || isset($_SESSION['filterpcategory']) || isset($_SESSION['filterfby']))) )
    {

$btn = $this->input->post('goButton');
      // $schange = $this->input->post('searchChange');
      // $dtrange = $this->input->post('dtrange');
      // $converted = $this->input->post('converted');
      // $canceled = $this->input->post('canceled');
      // $lsourcechange = $this->input->post('filterlsource');
      // $pcategorychange = $this->input->post('filterpcategory');
      // $fbychange = $this->input->post('filterfby');

$this->session->set_userdata('converted', $this->input->post('converted')!=''?$this->input->post('converted'):$_SESSION['converted']);
      $this->session->set_userdata('canceled', $this->input->post('canceled')!=''?$this->input->post('canceled'):$_SESSION['canceled']);
      $this->session->set_userdata('lschange', $this->input->post('searchChange')!=''?$this->input->post('searchChange'):$_SESSION['lschange']);
      $this->session->set_userdata('ldtrange', $this->input->post('dtrange')!=''?$this->input->post('dtrange'):$_SESSION['ldtrange']);
      // $this->session->set_userdata('lsearch_change', $this->input->post('l_search')!=''?$this->input->post('l_search'):$_SESSION['lsearch_change']);
      $this->session->set_userdata('lsearch_change', $this->input->post('l_search'));
      $this->session->set_userdata('filterlsource', $this->input->post('filterlsource')!=''?$this->input->post('filterlsource'):$_SESSION['filterlsource']);
      $this->session->set_userdata('filterpcategory', $this->input->post('filterpcategory')!=''?$this->input->post('filterpcategory'):$_SESSION['filterpcategory']);
      $this->session->set_userdata('filterfby', $this->input->post('filterfby')!=''?$this->input->post('filterfby'):$_SESSION['filterfby']);

$fbychange = isset($_SESSION['filterfby'])?$_SESSION['filterfby']:$this->input->post('filterfby');
      $lsourcechange = isset($_SESSION['filterlsource'])?$_SESSION['filterlsource']:$this->input->post('filterlsource');
      $pcategorychange = isset($_SESSION['filterpcategory'])?$_SESSION['filterpcategory']:$this->input->post('filterpcategory');
      $converted = isset($_SESSION['converted'])?$_SESSION['converted']:$this->input->post('converted');
      $dtrange = isset($_SESSION['ldtrange'])?$_SESSION['ldtrange']:$this->input->post('dtrange');
      $schange = isset($_SESSION['lschange'])?$_SESSION['lschange']:$this->input->post('searchChange');
      $canceled = isset($_SESSION['canceled'])?$_SESSION['canceled']:$this->input->post('canceled');
      $lsearch_change = isset($_SESSION['lsearch_change'])?$_SESSION['lsearch_change']:$this->input->post('l_search');

if($pcategorychange!='all'){
        $pc = 'AND lp.product_category_id='.$pcategorychange;
      }
      else
        $pc = '';

if($fbychange!='all'){
        $fby = 'AND l.followed_by='.$fbychange;
      }
      else
        $fby = '';

$data['lsourcechange'] = $lsourcechange;
      $data['pcategorychange'] = $pcategorychange;
      $data['fbychange'] = $fbychange;

if($converted==0)
      {
        $cv = ' and l.converted!=1';
      }
      else
      {
        $cv = '';
      }

if($canceled==0)
      {
        $cn = ' and l.status!=2';
      }
      else
      {
        $cn = '';
      }

// if($btn=='')
      // {
      //   $dtrange='';
      // }

if($schange == '')
        $schange='all';

if($schange == 'all')
      {
        $data['drnge'] = '';
        $data['lead_list_count'] = $this->db->query("SELECT l.*, au.displayname,ls.lead_source FROM lead l,admin_users au,lead_source ls,lead_product lp WHERE l.followed_by = au.id AND ls.lead_source_id = l.lead_source AND l.lead_id = lp.lead_id $cv $cn $ls $pc $fby $sc GROUP BY l.lead_id ORDER BY l.lead_id DESC")->result_array();