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: Dealer.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Dealer extends CI_Controller {
  public function __construct()
  {
    parent::__construct();
    $this->load->library('excel');
    $this->load->model(array('Dealer_model','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', 'Dealer Management');
  }

public function dealer_export()
  {
    $dsearch_change = isset($_SESSION['dsearch_change'])?$_SESSION['dsearch_change']:'';

if ($dsearch_change != '') {
      $sc = 'AND (c.customer_name LIKE "%'.$dsearch_change.'%" OR cp.phone_no LIKE "%'.$dsearch_change.'%" OR c.customer_code LIKE "%'.$dsearch_change.'%")';
    }
    else {
      $sc = '';
    }

$dealer_list = $this->db->query("SELECT c.*,ct.customer_type,cc.customer_category,au.displayname FROM customer c, customer_type ct, customer_category cc,admin_users au,customer_phone cp WHERE c.customer_type = ct.customer_type_id AND cp.customer_id = c.customer_id AND c.customer_category = cc.customer_category_id AND c.created_by = au.id AND c.customer_type=2 $sc ORDER BY c.customer_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', 'Dealer Code');
    $objPHPExcel->getActiveSheet()->getStyle('A1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('B1', 'Dealer Name');
    $objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('C1', 'Contact No');
    $objPHPExcel->getActiveSheet()->getStyle('C1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('D1', 'Opening Balance');
    $objPHPExcel->getActiveSheet()->getStyle('D1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('E1', 'GST No');
    $objPHPExcel->getActiveSheet()->getStyle('E1')->applyFromArray($styleArray);
    $objPHPExcel->getActiveSheet()->setCellValue('F1', 'Discount (%)');
    $objPHPExcel->getActiveSheet()->getStyle('F1')->applyFromArray($styleArray);

$i=2; $g_settings = general_setting_details();
    foreach ($dealer_list as $u_list ) { 
      $cusDetails = $this->Customer_model->get_customer_contact_details($u_list['customer_id']);

if($u_list['crdr']=='0')
        $crdr='CR';
      else
        $crdr='DR';

$objPHPExcel->getActiveSheet()->setCellValue('A'.$i, $u_list['customer_code']);
      $objPHPExcel->getActiveSheet()->setCellValue('B'.$i, $u_list['customer_name']);
      $objPHPExcel->getActiveSheet()->setCellValue('C'.$i, $cusDetails->phone_no);
      $objPHPExcel->getActiveSheet()->setCellValue('D'.$i, $crdr.'  '.round($u_list['opening_balance'],2));
      $objPHPExcel->getActiveSheet()->setCellValue('E'.$i, $u_list['gst_no']);
      $objPHPExcel->getActiveSheet()->setCellValue('F'.$i, $u_list['discount_percentage']);

$i++;
    }

$filename='Dealer.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() . "dealer";
    $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'];
    // $this->session->set_userdata('dsearch_change', $this->input->post('d_search')!=''?$this->input->post('d_search'):$_SESSION['dsearch_change']);
    $this->session->set_userdata('dsearch_change', $this->input->post('d_search'));

$dsearch_change = isset($_SESSION['dsearch_change'])?$_SESSION['dsearch_change']:$this->input->post('l_search');

$data['dealer_list_count'] = $this->db->query("SELECT c.*,ct.customer_type,cc.customer_category,au.displayname FROM customer c, customer_type ct, customer_category cc,admin_users au,customer_phone cp WHERE c.customer_type = ct.customer_type_id AND cp.customer_id = c.customer_id AND c.customer_category = cc.customer_category_id AND c.created_by = au.id AND c.customer_type=2 $sc ORDER BY c.customer_id DESC")->result_array();

$config["total_rows"] = count($data['dealer_list_count']);

$data['dealer_list'] = $this->db->query("SELECT c.*,ct.customer_type,cc.customer_category,au.displayname FROM customer c, customer_type ct, customer_category cc,admin_users au,customer_phone cp WHERE c.customer_type = ct.customer_type_id AND c.customer_category = cc.customer_category_id AND cp.customer_id = c.customer_id AND c.created_by = au.id AND c.customer_type=2 $sc ORDER BY c.customer_id DESC Limit $page, $perpage")->result_array();

$this->pagination->initialize($config);
    $data["links"] = $this->pagination->create_links();
    $this->load->view('dealer/dealer_list',$data);
  }

public function dealer_add()
  {
    $data['state_list'] = $this->Dealer_model->get_state_list();
    $data['address_type'] = $this->Customer_model->get_address_type();
    $this->load->view('dealer/dealer_add',$data);
  }

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

public function phone_no_unique()
  {
    $val = $_POST['value'];
    $fval = substr($val, 0, 1);
    if($fval=='0')
    {
      $val = substr($val,1);
    }
    $result = $this->Dealer_model->dealer_phone_no_unique($val);
    echo count($result).'|*|'.$result->dealer_no.'|*|'.$result->dealer_name;
  }

public function create_dealer()
  {

$last_id_value = $this->Dealer_model->last_id();
    if(count($last_id_value)==0)
    {
      $data['dealer_no'] = date("Y").'/'.date('m').'/DLR001';
    }
    else
    {

$lno = $last_id_value->dealer_no;
      $exlno = substr($lno,11);
      $next_value = (int)$exlno + 1;
      $slen = strlen($next_value);
      if($slen==1)
        $nval = '00'.$next_value;
      else if($slen==2)
        $nval = '0'.$next_value;
      else
        $nval = $next_value;
      $data['dealer_no'] = date("Y").'/'.date('m').'/DLR'.$nval;
    }

$dealerName = $data['dealer_name']=$this->input->post('dealer_name');
    $data['phone_no']=$this->input->post('phone_no');
    $data['email_id']=$this->input->post('email_id');
    $data['address']=$this->input->post('address');
    $data['discount_percentage']=$this->input->post('discount_percentage');
    $data['created_on'] = date('Y-m-d H:i:s');
    $data['created_by'] = $_SESSION['user_id']; 
    $data['state_id']=$this->input->post('state_id'); 
    $data['gst_no']=$this->input->post('gst_no');   
    
    $result = $this->Dealer_model->create_dealer($data);

if ($result) {
      $last_id_value = $this->Dealer_model->last_id();
      $last_value=$last_id_value->count_val;
      $dealer_id = $last_value;

if($this->input->post('contact_person_name')!='')
      {
        $cpname = explode(",",implode(",",$this->input->post('contact_person_name')));
        $cpmno = explode(",",implode(",",$this->input->post('contact_no')));
        $cpemid = explode(",",implode(",",$this->input->post('contact_email_id')));

$subcount = count($this->input->post('contact_person_name'));      
          $data4['dealer_id'] =  $dealer_id;
        for($i=0;$i<$subcount;$i++)
        {
          if($cpname[$i] != ''){
            $data4['contact_person_name'] = $cpname[$i];
            $data4['contact_no'] = $cpmno[$i];
            $data4['contact_email_id'] = $cpemid[$i];
            //$this->db->insert('order_product',$op);
            $this->Dealer_model->create_dealer_contact_details($data4);
          }
        }
      }

if($this->input->post('address_type_id')!='')
      {
        $atid = explode(",",implode(",",$this->input->post('address_type_id')));
        $adress = explode("|",implode("|",$this->input->post('address')));
        $adress_state_id = explode("|",implode("|",$this->input->post('address_state_id')));
        $adress_pincode = explode("|",implode("|",$this->input->post('address_pincode')));

$subcount = count($this->input->post('address_type_id'));      
          $data3['dealer_id'] =  $dealer_id;
        for($i=0;$i<$subcount;$i++)
        {
          if($atid[$i] != ''){
            $data3['address_type_id'] = $atid[$i];
            $data3['address'] = $adress[$i];
            $data3['address_state_id'] = $adress_state_id[$i];
            $data3['address_pincode'] = $adress_pincode[$i];
            //$this->db->insert('order_product',$op);
            $this->Dealer_model->create_dealer_address($data3);
          }
        }
      }

$this->session->set_flashdata('add_success', 'Dealer has been created successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
    redirect('/dealer');
  }

public function dealer_view($id)
  {
    $data['dealer_list'] = $this->Dealer_model->get_dealer_view_by_id($id);
    $data['dealer_contact'] = $this->Dealer_model->get_dealer_contact_by_dealer_id($id);
    $data['dealer_address'] = $this->Dealer_model->get_dealer_address_by_dealer_id($id);
    $this->load->view('dealer/dealer_view',$data);
  }

public function dealer_edit($id)
  {
    $data['state_list'] = $this->Dealer_model->get_state_list();
    $data['address_type'] = $this->Customer_model->get_address_type();
    $data['dealer_list'] = $this->Dealer_model->get_dealer_view_by_id($id);
    $data['dealer_contact'] = $this->Dealer_model->get_dealer_contact_by_dealer_id($id);
    $data['dealer_address'] = $this->Dealer_model->get_dealer_address_by_dealer_id($id);
    $this->load->view('dealer/dealer_edit',$data);
  }

public function unique_email_edit()
  {
    $val = $_POST['value'];
    $did = $_POST['did'];
    $result = $this->Dealer_model->dealer_unique_email_edit($val,$did);
    echo count($result);
  }

public function phone_no_unique_edit()
  {
    $val = $_POST['value'];
    $did = $_POST['did'];
    $fval = substr($val, 0, 1);
    if($fval=='0')
    {
      $val = substr($val,1);
    }
    $result = $this->Dealer_model->dealer_phone_no_unique_edit($val,$did);
    echo count($result).'|*|'.$result->dealer_no.'|*|'.$result->dealer_name;
  }

public function update_dealer()
  {
    $dealer_id = $data['dealer_id'] = $this->input->post('dealer_id');
    $data['dealer_name']=$this->input->post('dealer_name');
    $data['phone_no']=$this->input->post('phone_no');
    $data['email_id']=$this->input->post('email_id');
    $data['address']=$this->input->post('address');
    $data['discount_percentage']=$this->input->post('discount_percentage');
    $data['modified_on'] = date('Y-m-d H:i:s');
    $data['modified_by'] = $_SESSION['user_id'];
    $data['state_id']=$this->input->post('state_id');   
    
    $result = $this->Dealer_model->update_dealer($data);

if ($result) {

$this->Dealer_model->delete_dealer_contact($dealer_id);
      $this->Dealer_model->delete_dealer_address($dealer_id);

$subcount = count($this->input->post('contact_person_name'));      
          $data4['dealer_id'] =  $dealer_id;
        for($i=0;$i<$subcount;$i++)
        {
          if($cpname[$i] != ''){
            $data4['contact_person_name'] = $cpname[$i];
            $data4['contact_no'] = $cpmno[$i];
            $data4['contact_email_id'] = $cpemid[$i];
            $this->Dealer_model->create_dealer_contact_details($data4);
          }
        }
      }

$this->session->set_flashdata('add_success', 'Dealer has been Updated successfully.');
    }
    else{
      $this->session->set_flashdata('add_err', 'Something went wrong');
    }
    redirect('/dealer');
  }

}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Dealer.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation