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/public_html/crm/crm_2020_11_03/application/modules/dm/controllers

Free Space:

4.06 TB

🔧 Quick Actions

✏️ Editing: Dm.php

<?php
if (!defined('BASEPATH'))
    exit('No direct script access allowed');
class Dm extends CI_Controller
{
    function __construct()
    {
        parent::__construct();
        $this->load->model(array(
            'dm/Dm_model','seo_keyword/Seo_keyword_model'
        ));
        $this->load->helper(array(
            'form'
        ));
        $this->load->library("Pdf");
        $session_data       = $this->session->userdata( SESSION_LOGIN . 'logged_in' );
        $data['username']   = $session_data['username'];
        $data['permission'] = $this->session->userdata(SESSION_LOGIN . 'user_permission');
        if (empty($data['permission'])) {
            redirect('home');
        } 
        $data['title'] = 'Digital Marketing Services';
        $this->load->view('common/header', $data);
       // echo $this->output->enable_profiler(TRUE); 
    }
    function hasPermission($page)
    {
        $res_permission = $this->session->userdata(SESSION_LOGIN . 'user_permission');
        if ($res_permission && !empty($res_permission)) {
            if (!in_array($page, $res_permission)) {
                redirect('access_denied', 'refresh');
            }
        } else {
            redirect('home');
        }
    }
	
	function index(){
		$this->getlist();
	}
    function getlist()
    {
        $this->hasPermission('dm_view');
        $filter_data = '';
        if ($this->input->server('REQUEST_METHOD') == 'POST') {
            $filter_data = $this->input->post();
            $reset_data  = $this->input->post('reset');
            if (isset($reset_data)) {
                $this->session->unset_userdata('filter_data');
                $filter_data = '';
            } else {
                $this->session->set_userdata('filter_data', $filter_data);
            }
        } else {
            $session_filter_data = $this->session->userdata('filter_data');
            if (isset($session_filter_data)) {
                $filter_data = $session_filter_data;
            } else {
                $filter_data = '';
            }
        }
       
        $data['filter_data'] = $filter_data;
        //$data      = array();
        $segment_3 = $this->uri->segment(3);
        $segment_4 = $this->uri->segment(4);
        $segment_5 = $this->uri->segment(5);
        // If not pagination page remove filter data from session
        if (!isset($segment_3) && $this->input->server('REQUEST_METHOD') != 'POST') {
            $this->session->unset_userdata('filter_data');
            $filter_data = '';
            $data['filter_data'] = '';
        }
        if (isset($segment_3)) {
            $page = $segment_3;
        } else {
            $page = '1';
        }
        if (isset($segment_4)) {
            $sort = $segment_4;
        } else {
            $sort = 'ref_client_id';
        }
        if (isset($segment_5)) {
            $order = $segment_5;
        } else {
            $order = 'DESC';
        }
        
         $data['page']             = $page; // No used for Redirect to same page after delete action in page 2, page 3,etc...
        
        $filter_query_data      = array();
        $data['limit'] = '';
        if(isset($_REQUEST['limit']) && !empty($_REQUEST['limit'])){
            $start                     = (($page - 1) * $_REQUEST['limit']);
            $filter_query_data['limit'] = $_REQUEST['limit'];
            $data['limit'] = '?limit='.$_REQUEST['limit'];
        }else{
            $start                     = (($page - 1) * RPP);
        }
        
        $data['start']             = $start; // Generate SNO in result table based on page number
        $filter_query_data['start']             = $start;
        $filter_query_data['sort']              = $sort;
        $filter_query_data['order']             = $order;

$table['tbl_main']           = 'approved_services';
        $table['tbl_client']         = 'client';
        $table['tbl_mobile']         = 'client_contact_numbers';
        $table['tbl_email']          = 'client_email_ids';
        $data['mainlist_count']      = $this->Common_model->getListCount($table, $filter_data);
        $data['mainlist']            = $this->Common_model->getList($table, $filter_query_data, $filter_data);
       // echo "<pre>";
       // print_r($data['mainlist']);
       // exit;
        $data['tablefields']      = $this->Common_model->getTableFields('client');
        // $data['tablefields2']      = $this->Common_model->getTableFields('client_contact_numbers');
        // $data['tablefields3']      = $this->Common_model->getTableFields('client_email_ids');
        // $data['tablefields4']      = $this->Common_model->getTableFields('approved_services');
        // $data['tablefields']       = array_merge($data['tablefields1'], $data['tablefields2'], $data['tablefields3']);
        
        $data['operations']          = $this->Common_model->getFilterOperation();
        $data['init_listing_page']   = 'dm/getlist/';
        $data['listing_page']        = $data['init_listing_page'] . $page . '/';
        $data['filter_block']      = $this->parser->parse('common/filter', $data, true);
        $this->load->view('common/menu');
        $this->load->view('dm/dm_list_view', $data);
        $this->load->view('common/footer');
    }

function getForm()
    {
        $data['category']             = $this->Common_model->getCategoryList('business_category');
        $data['data_source']          = $this->Common_model->getDropdownList('data_source');
       
        $data['area']                 = $this->Common_model->getDropdownList('area');
       
      
        $data['designation']          = $this->Common_model->getDropdownList('designation');
        $data['salutation']           = $this->Common_model->getDropdownList('salutation');
        $data['product']              = $this->Client_model->getProductList();
        $data['contact_number_block'] = $this->parser->parse('common/client_contact_number_block', $data, true);
        $data['contact_email_block']  = $this->parser->parse('common/client_contact_email_block', $data, true);
        $data['website_block']        = $this->parser->parse('common/website_block', $data, true);
        $data['product_block']        = $this->parser->parse('common/product_block', $data, true);
        $data['seo_block']            = $this->parser->parse('common/seo_block', $data, true);
        $data['facebook_block']       = $this->parser->parse('common/facebook_block', $data, true);
        $data['linkedin_block']       = $this->parser->parse('common/linkedin_block', $data, true);
        $data['twitter_block']        = $this->parser->parse('common/twitter_block', $data, true);
        $data['instagram_block']      = $this->parser->parse('common/instagram_block', $data, true);
        $data['gmb_block']            = $this->parser->parse('common/gmb_block', $data, true);
        $data['youtube_block']        = $this->parser->parse('common/youtube_block', $data, true);
        $this->load->view('common/menu');
        $this->load->view('client/client_form_view', $data);
        $this->load->view('common/footer');
    }
    function add()
    {
        $this->hasPermission('client_add');
        if ($this->input->server('REQUEST_METHOD') == 'POST') {
            // Begin Transaction
			$this->Common_model->TxnBegin();
			$data = $this->input->post();
            if (isset($data['keywords'])) {
                $keywords = $data['keywords'];
                unset($data['keywords']);
                $data['tbl_client_seo_gmb_youtube_keywords'] = $this->get_altered_keyword($keywords);
            }
            if (isset($_FILES['gmb_images'])) {
                $gmb_images = $_FILES['gmb_images'];
                $image_count = count($gmb_images['name']);

$image_details = array();
                $i=0;
                foreach ($gmb_images as $key => $value) {
                    $photo_img = '';
                    if(isset($gmb_images['name'][$i]) && !empty($gmb_images['name'][$i])){
                        $photo_img = $this->Common_model->upload_file($gmb_images['name'][$i],$gmb_images['tmp_name'][$i],'gmbimages');
                        if ($photo_img != '') {
                            $image_details[$i]['images'] = $photo_img;
                        }
                    }
                    
                    $i++;
                }
                $data['tbl_client_gmb_images'] = $image_details;
                unset($_FILES['gmb_images']);
            }
			$client_to_company = $data['client_to_company'];
			unset($data['client_to_company']);

if (isset($data['seo_target_locations'])) {
                $seo_target_locations = $data['seo_target_locations'];
                unset($data['seo_target_locations']);

$locations = explode(',', $seo_target_locations);
                foreach ($locations as $key1 => $val) {
                    $val = trim($val);
                    if ($val != '' && $val != ' ') {
                        $res[$i]['seo_target_locations_name'] = $val;
                    }
                    $i++;
                }
                $data['tbl_seo_target_locations'] = $res;
            }
			$res_id_1 = $this->Client_model->addRecord('client', $data);
			
			// Insert Company to Lead
            if(isset($client_to_company) && !empty($client_to_company)){
				foreach($client_to_company as $key => $val){
					$data_company['ref_client_id'] = $res_id_1;
					$data_company['ref_company_id'] = $val;
					$this->Common_model->addRecord('client_to_company', $data_company);
				}
			}

/*if(isset($seo_target_countries) && !empty($seo_target_countries)){
                foreach($seo_target_countries as $key => $val){
                    $data_target_countries['ref_client_id'] = $res_id_1;
                    $data_target_countries['ref_country_id'] = $val;
                    $this->Common_model->addRecord('seo_target_countries', $data_target_countries);
                }
            }*/
			
			if($res_id_1){
				$this->Common_model->TxnCommit();
				$this->Common_model->addUserActivity('client_add',$res_id_1); // Record User Activity
                $_SESSION['success_msg'] = 'Client successfully added ...';
            }else{
                $this->Common_model->TxnRollBack();
                $_SESSION['error_msg'] = 'Error occurred please try again...';
            }            
           redirect('client');           
        } 
        else {
            $this->getForm();
        }
    }
    function view()
    {
        $this->hasPermission('client_view');
        $id                      = $this->uri->segment(3);
        $data['clients']         = $this->Common_model->getDetails('client', 'client_id', $id);
        $data['client_numbers']  = $this->Common_model->getDetails('client_contact_numbers', 'ref_client_id', $id);
        $data['clients_emails']  = $this->Common_model->getDetails('client_email_ids', 'ref_client_id', $id);
        $data['clients_website'] = $this->Common_model->getDetails('client_website', 'ref_client_id', $id);
        $data['clients_product'] = $this->Common_model->getDetails('client_product', 'ref_client_id', $id);
        $data['clients_calls']   = $this->Common_model->getDetails('client_calls', 'ref_client_id', $id,'client_call_date_and_time','DESC');
        $data['clients_apps']    = $this->Common_model->getDetails('client_appointments', 'ref_client_id', $id,'appointment_process_date','DESC');
        $data['client_remark']   = $this->Common_model->getDetails('client_remark', 'ref_client_id', $id);
        $data['keyword_report']   = $this->Common_model->getDetails('seo_keyword_report', 'ref_client_id', $id);
        $data['domain_list']   = $this->Common_model->getDetails('domain_list', 'ref_client_id', $id);
        //~ echo "<pre>";
		//~ print_r($data['domain_list']);
		//~ echo "</pre>";
		//~ exit;
       
         
         // Get Employee To Company List
		$res_client_to_company = $this->Common_model->getDetails('client_to_company','ref_client_id',$id);
		$client_to_company = array();
		if(isset($res_client_to_company) && !empty( $res_client_to_company)){
			foreach($res_client_to_company as $k => $v){ 
				$client_to_company[] = $v->company_name;
			}
		}
		$data['client_to_company'] = implode('<br>',$client_to_company);
		
		//Get Keyword Position Report
		$client_calls_chart = array();
		$current_date = date('m-Y');
		$months     = array();
		$jsonmonths = array();
		$res_date        = $this->Client_model->getCallsDate($id,$current_date);
		if ( isset( $res_date ) && !empty( $res_date ) ) {
			foreach ( $res_date as $key => $val ) {
				
					$jsonmonths[]   = $this->Common_model->getDateTimeFormat($val->client_call_date_and_time);
					$mon            = $val->client_call_date_and_time;
					$res_count                                     = $this->Client_model->getClientCallsByDate( $mon,$val->ref_client_id,$current_date);
					
					if (strpos($res_count[0]->duration, 'min') !== false) {
						$str_time = str_replace(' min','',$res_count[0]->duration);
						sscanf($str_time, "%d:%d:%d", $hours, $minutes, $seconds);
						$time_seconds = isset($seconds) ? $hours * 3600 + $minutes * 60 + $seconds : $hours * 60 + $minutes;
						$dur = $time_seconds;
					}else{
						$dur = str_replace(' sec','',$res_count[0]->duration);
					}
				$client_calls_chart[] = (int) $dur;
			}
		}
		
		$months             = array_reverse( $jsonmonths );
		$chart_data         = array_reverse( $client_calls_chart );
		
		$data['calls_report'] = array(
				'months'		=> implode("', '",$months),
				'chart_data'	=> implode(',',$chart_data)
            );
		
        $this->load->view('common/menu');
        $this->load->view('client/client_details_view', $data);
        $this->load->view('common/footer');
    }

function edit()
    {
        $this->hasPermission('client_edit');
        if ($this->input->server('REQUEST_METHOD') == 'POST') {
            $id  = $this->uri->segment(3);
            // Begin Transaction
			$this->Common_model->TxnBegin();
			$data = $this->input->post();
			$client_to_company = $data['client_to_company'];

unset($data['client_to_company']);
			
            $keywords = $data['keywords'];
            unset($data['keywords']);

$data['tbl_client_seo_gmb_youtube_keywords'] = $this->get_altered_keyword($keywords);

if (isset($_FILES['gmb_images'])) {
                $gmb_images = $_FILES['gmb_images'];
                $image_count = count($gmb_images['name']);

$image_details = array();
                $i=0;
                foreach ($gmb_images as $key => $value) {
                    $photo_img = '';
                    if(isset($gmb_images['name'][$i]) && !empty($gmb_images['name'][$i])){
                        $photo_img = $this->Common_model->upload_file($gmb_images['name'][$i],$gmb_images['tmp_name'][$i],'gmbimages');
                        if ($photo_img != '') {
                            $image_details[$i]['images'] = $photo_img;
                        }
                    }
                    
                    $i++;
                }
                if (!empty($image_details)) {
                    $data['tbl_client_gmb_images'] = $image_details;
                }
                unset($_FILES['gmb_images']);
            }

// echo "<pre>";
            // print_r($data);
            // exit;

$redirect_to = $data['redirect_to'];
            unset($data['redirect_to']);

if (isset($data['seo_target_locations'])) {
                $seo_target_locations = $data['seo_target_locations'];
                unset($data['seo_target_locations']);

$res_id_1 = $this->Client_model->updateClient('client', $data, $id);
			// Insert Company to Lead
            if(isset($client_to_company) && !empty($client_to_company)){
				$this->Common_model->removeRecord('client_to_company', 'ref_client_id',$res_id_1);
				foreach($client_to_company as $key => $val){
					$data_company['ref_client_id'] = $res_id_1;
					$data_company['ref_company_id'] = $val;
					$this->Common_model->addRecord('client_to_company', $data_company);
				}
			}
			
			if($res_id_1){
				$this->Common_model->TxnCommit();
				$this->Common_model->addUserActivity('client_edit', $res_id_1); // Record User Activity
                $_SESSION['success_msg'] = 'Client successfully updated ...';
            }else{
                $this->Common_model->TxnRollBack();
                $_SESSION['error_msg'] = 'Error occurred please try again...';
            }            
            redirect('client');
        } else {
            $id                           = $this->uri->segment(3);
            $data['clients']              = $this->Common_model->getDetails('client', 'client_id', $id);
            $data['contact_numbers']      = $this->Common_model->getDetails('client_contact_numbers', 'ref_client_id', $id);
            $data['email_ids']            = $this->Common_model->getDetails('client_email_ids', 'ref_client_id', $id);
            $data['client_website']       = $this->Common_model->getDetails('client_website', 'ref_client_id', $id);
            $data['client_product']       = $this->Common_model->getDetails('client_product', 'ref_client_id', $id);
            $data['data_source']          = $this->Common_model->getDropdownList('data_source');
            $data['category']             = $this->Common_model->getCategoryList('business_category', $data['clients'][0]->ref_business_category_id);
            $data['client_seo']           = $this->Common_model->getDetails('client_seo_details', 'ref_client_id', $id);
            $data['countries']            = $this->Common_model->getDropdownList('country');

// $seo_target_countries         = $this->Common_model->getDetails('seo_target_countrie', 'ref_client_id', $id);
            // $data['seo_target_countries'] = $this->Common_model->getIDArray($seo_target_countries,'ref_country_id');

$data['seo_target_locations'] = $this->Common_model->getDetails('seo_target_locations', 'ref_client_id', $id);
            // $data['seo_target_countries'] = $this->Common_model->getIDArray($seo_target_countries,'ref_country_id');
            $data['keywords']             = $this->Common_model->getDetails('client_seo_gmb_youtube_keywords', 'ref_client_id', $id);
            $data['client_facebook']      = $this->Common_model->getDetails('client_facebook_details', 'ref_client_id', $id);
            $data['client_linkedin']      = $this->Common_model->getDetails('client_linkedin_details', 'ref_client_id', $id);
            $data['client_twitter']       = $this->Common_model->getDetails('client_twitter_details', 'ref_client_id', $id);
            $data['client_instagram']     = $this->Common_model->getDetails('client_instagram_details', 'ref_client_id', $id);
            $data['client_gmb']           = $this->Common_model->getDetails('client_gmb_details', 'ref_client_id', $id);
            $data['client_youtube']       = $this->Common_model->getDetails('client_youtube_details', 'ref_client_id', $id);
            $data['gmb_images']       = $this->Common_model->getDetails('client_gmb_images', 'ref_client_id', $id);
            $data['approved_services']       = $this->Common_model->getDetails('approved_services', 'ref_client_id', $id);

$data['designation']          = $this->Common_model->getDropdownList('designation');
            $data['salutation']           = $this->Common_model->getDropdownList('salutation');
            $data['product']              = $this->Client_model->getProductList();
            $data['contact_number_block'] = $this->parser->parse('common/client_contact_number_block', $data, true);
            $data['contact_email_block']  = $this->parser->parse('common/client_contact_email_block', $data, true);
            $data['website_block']        = $this->parser->parse('common/website_block', $data, true);
            $data['product_block']        = $this->parser->parse('common/product_block', $data, true);
            $data['seo_block']            = $this->parser->parse('common/seo_block', $data, true);
            $data['twitter_block']        = $this->parser->parse('common/twitter_block', $data, true);
            $data['facebook_block']       = $this->parser->parse('common/facebook_block', $data, true);
            $data['youtube_block']        = $this->parser->parse('common/youtube_block', $data, true);
            $data['linkedin_block']       = $this->parser->parse('common/linkedin_block', $data, true);
            $data['instagram_block']      = $this->parser->parse('common/instagram_block', $data, true);
            $data['gmb_block']            = $this->parser->parse('common/gmb_block', $data, true);
            
            $client_to_company      = $this->Common_model->getDetails('client_to_company', 'ref_client_id', $id);
            $data['client_to_company'] = $this->Common_model->getIDArray($client_to_company,'ref_company_id');
            $this->load->view('common/menu');
            $this->load->view('client/client_edit_view', $data);
            $this->load->view('common/footer');
        }
    }

function facebook_details()
    {
        // $this->hasPermission('seo_edit');
        $this->Common_model->TxnBegin();
        $id  = $this->uri->segment(3);
        if ($this->input->server('REQUEST_METHOD') == 'POST') {

}
        else
        {
            
        }
    }

$this->load->library('parser');
        $header_html = $this->parser->parse('template/pdf/pdf_header',$data);
		$footer_html = $this->parser->parse('template/pdf/pdf_footer',$data);
        $html = $this->parser->parse('template/pdf/list_tmp', $data);
        
        $file_name = 'client_list_' . date('Y-m-d _ H:i:s') . '.pdf';
        $this->Common_model->exportPdf($header_html,$footer_html,$html,$file_name,'P','I');
        
    }
    
    function get_altered_keyword($keywords)
    {
        if (isset($keywords) && !empty($keywords)) {
            $res = array();
            $i = 0;
            $seo_keywords = explode(',', $keywords['seo']);
            $gmb_keywords = explode(',', $keywords['gmb']);
            $youtube_keywords = explode(',', $keywords['youtube']);
            if (isset($youtube_keywords) && !empty($youtube_keywords)) {
                foreach ($youtube_keywords as $key => $value) {
                    $value = trim($value);
                    if ($value != '' && $value != ' ') {
                        $res[$i]['ref_keyword_type_id'] = 2;
                        $res[$i]['client_seo_gmb_youtube_keywords_name'] = $value;
                    $i++;
                    }
                }
            }
            if (isset($gmb_keywords) && !empty($gmb_keywords)) {
                foreach ($gmb_keywords as $key => $value) {
                    $value = trim($value);
                    if ($value != '' && $value != ' ') {
                        $res[$i]['ref_keyword_type_id'] = 1;
                        $res[$i]['client_seo_gmb_youtube_keywords_name'] = $value;
                    }
                    $i++;
                }
            }
            if (isset($seo_keywords) && !empty($seo_keywords)) {
                foreach ($seo_keywords as $key => $value) {
                    $value = trim($value);
                    if ($value != '' && $value != ' ') {
                        $res[$i]['ref_keyword_type_id'] = 3;
                        $res[$i]['client_seo_gmb_youtube_keywords_name'] = $value;
                    }
                    $i++;
                }
            }
            
        }
        return $res;
        
    }

// If not pagination page remove filter data from session
        if (!isset($segment_3) && $this->input->server('REQUEST_METHOD') != 'POST') {
            $this->session->unset_userdata('filter_data');
            $filter_data         = '';
            $data['filter_data'] = '';
        }
        if (isset($segment_3)) {
            $page = $segment_3;
        } else {
            $page = '1';
        }
        if (isset($segment_4)) {
            $sort = $segment_4;
        } else {
            $sort = 'added_date';
        }
        if (isset($segment_5)) {
            $order = $segment_5;
        } else {
            $order = 'DESC';
        }
        $data['page']      = $page; // No used for Redirect to same page after delete action in page 2, page 3,etc...
        $filter_query_data = array();
        $data['limit']     = '';
        if (isset($_REQUEST['limit']) && !empty($_REQUEST['limit'])) {
            $start                      = (($page - 1) * $_REQUEST['limit']);
            $filter_query_data['limit'] = $_REQUEST['limit'];
            $data['limit']              = '?limit=' . $_REQUEST['limit'];
        } else {
            $start = (($page - 1) * RPP);
        }
        $data['start']              = $start; // Generate SNO in result table based on page number
        $filter_query_data['start'] = $start;
        $filter_query_data['sort']  = $sort;
        $filter_query_data['order'] = $order;
        //print_r($data['filter_data']['filter_data'][1]['operation']);
        //exit;
        $table                      = array();
        $table['tbl_main']          = 'seo_keyword_report';
        $data['mainlist_count']     = $this->Dm_model->getListCount($table, $filter_data, '', $client_id);
        $data['mainlist']           = $this->Dm_model->getList($table, $filter_query_data, $filter_data, '', $client_id);
        $data['tablefields']        = $this->Common_model->getTableFields('seo_keyword_report');
        $data['operations']         = $this->Common_model->getFilterOperation();
        $data['init_listing_page']  = 'dm/seo_reportlist/'.$client_id.'/';
        $data['listing_page']       = $data['init_listing_page'] . $page . '/';
        //$data['page'] = $page;
        $data['filter_block']       = $this->parser->parse('common/filter', $data, true);
        $this->load->view('common/menu');
        $this->load->view('seo_keyword/seo_keyword_report_list_view', $data);
        $this->load->view('common/footer');
    }
    
}
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: Dm.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation