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/sigmagrocery/admin/controller/catalog

Free Space:

4.1 TB

🔧 Quick Actions

✏️ Editing: product_catalog.php

<?php
class ControllerCatalogProductcatalog extends Controller {
	private $error = array();

public function index() {
		$this->load->language('catalog/product');

$this->document->setTitle($this->language->get('heading_title'));

$this->load->model('catalog/product');
		
		$this->getList();
	}

function getList() {
		
		$this->load->language('catalog/product');
		
		$this->load->model('catalog/externalcustomer');
		
		if (isset($this->request->get['filter_name'])) {
			$filter_name = $this->request->get['filter_name'];
		} else {
			$filter_name = null;
		}

if (isset($this->request->get['filter_category'])) {
			$filter_category = $this->request->get['filter_category'];
		} else {
			$filter_category = null;
		}

if (isset($this->request->get['filter_price'])) {
			$filter_price = $this->request->get['filter_price'];
		} else {
			$filter_price = null;
		}

if (isset($this->request->get['filter_quantity'])) {
			$filter_quantity = $this->request->get['filter_quantity'];
		} else {
			$filter_quantity = null;
		}

if (isset($this->request->get['filter_status'])) {
			$filter_status = $this->request->get['filter_status'];
		} else {
			$filter_status = null;
		}

if (isset($this->request->get['sort'])) {
			$sort = $this->request->get['sort'];
		} else {
			$sort = 'pd.name';
		}

if (isset($this->request->get['order'])) {
			$order = $this->request->get['order'];
		} else {
			$order = 'ASC';
		}

if (isset($this->request->get['page'])) {
			$page = $this->request->get['page'];
		} else {
			$page = 1;
		}

$url = '';

if (isset($this->request->get['filter_name'])) {
			$url .= '&filter_name=' . urlencode(html_entity_decode($this->request->get['filter_name'], ENT_QUOTES, 'UTF-8'));
		}

if (isset($this->request->get['filter_category'])) {
			$url .= '&filter_category=' . urlencode(html_entity_decode($this->request->get['filter_category'], ENT_QUOTES, 'UTF-8'));
		}

if (isset($this->request->get['filter_price'])) {
			$url .= '&filter_price=' . $this->request->get['filter_price'];
		}

if (isset($this->request->get['filter_quantity'])) {
			$url .= '&filter_quantity=' . $this->request->get['filter_quantity'];
		}

if (isset($this->request->get['filter_status'])) {
			$url .= '&filter_status=' . $this->request->get['filter_status'];
		}

if (isset($this->request->get['sort'])) {
			$url .= '&sort=' . $this->request->get['sort'];
		}

if (isset($this->request->get['order'])) {
			$url .= '&order=' . $this->request->get['order'];
		}

if (isset($this->request->get['page'])) {
			$url .= '&page=' . $this->request->get['page'];
		}

$data['breadcrumbs'] = array();

$data['breadcrumbs'][] = array(
			'text' => $this->language->get('text_home'),
			'href' => $this->url->link('common/dashboard', 'token=' . $this->session->data['token'], true)
		);

$data['breadcrumbs'][] = array(
			'text' => $this->language->get('heading_title'),
			'href' => $this->url->link('catalog/product_catalog', 'token=' . $this->session->data['token'] . $url, true)
		);

$data['update'] = $this->url->link('catalog/product_catalog/createProductCatalog', 'token=' . $this->session->data['token'] . $url, true);
		//$data['copy'] = $this->url->link('catalog/product/copy', 'token=' . $this->session->data['token'] . $url, true);
		
		$data['mail_action'] = $this->url->link('catalog/product_catalog/sendProductCatalog', 'token=' . $this->session->data['token'] , true);
		
		$data['products'] = array();

$filter_data = array(
			'filter_name'	  => $filter_name,
			'filter_category' => $filter_category,
			'filter_price'	  => $filter_price,
			'filter_quantity' => $filter_quantity,
			'filter_status'   => $filter_status,
			'sort'            => $sort,
			'order'           => $order,
			'start'           => ($page - 1) * $this->config->get('config_limit_admin'),
			'limit'           => 1000
		);

$this->load->model('tool/image');
		$this->load->model('catalog/productcatalog');

$product_total = $this->model_catalog_productcatalog->getTotalProducts($filter_data);

$results = $this->model_catalog_productcatalog->getProducts($filter_data);
		
		foreach ($results as $result) {
			if (is_file(DIR_IMAGE . $result['image'])) {
				$image = $this->model_tool_image->resize($result['image'], 40, 40);
			} else {
				$image = $this->model_tool_image->resize('no_image.png', 40, 40);
			}

$special = false;

$product_specials = $this->model_catalog_product->getProductSpecials($result['product_id']);

foreach ($product_specials  as $product_special) {
				if (($product_special['date_start'] == '0000-00-00' || strtotime($product_special['date_start']) < time()) && ($product_special['date_end'] == '0000-00-00' || strtotime($product_special['date_end']) > time())) {
					$special = $product_special['price'];

break;
				}
			}

$data['products'][] = array(
				'product_id' => $result['product_id'],
				'image'      => $image,
				'name'       => $result['name'],
				'model'      => $result['model'],
				'price'      => $result['price'],
				'special'    => $special,
				'quantity'   => $result['quantity'],
				'status'     => ($result['status']) ? $this->language->get('text_enabled') : $this->language->get('text_disabled'),
				'edit'       => $this->url->link('catalog/product_catalog/edit', 'token=' . $this->session->data['token'] . '&product_id=' . $result['product_id'] . $url, true)
			);
		}
		
		
		$data['religion'] = $this->model_catalog_externalcustomer->getReligion();			
		
		$data['city'] = $this->model_catalog_externalcustomer->getCity();	
		
		$this->load->model('customer/customer_group');
		
		$data['customer_groups'] = $this->model_customer_customer_group->getCustomerGroups();
		
		$data['heading_title'] = $this->language->get('heading_title');

$data['text_list'] = $this->language->get('text_list');
		$data['text_enabled'] = $this->language->get('text_enabled');
		$data['text_disabled'] = $this->language->get('text_disabled');
		$data['text_no_results'] = $this->language->get('text_no_results');
		$data['text_confirm'] = $this->language->get('text_confirm');

$data['column_image'] = $this->language->get('column_image');
		$data['column_name'] = $this->language->get('column_name');
		$data['column_model'] = $this->language->get('column_model');
		$data['column_price'] = $this->language->get('column_price');
		$data['column_quantity'] = $this->language->get('column_quantity');
		$data['column_status'] = $this->language->get('column_status');
		$data['column_action'] = $this->language->get('column_action');

$data['entry_name'] = $this->language->get('entry_name');
		$data['entry_model'] = $this->language->get('entry_model');
		$data['entry_price'] = $this->language->get('entry_price');
		$data['entry_quantity'] = $this->language->get('entry_quantity');
		$data['entry_status'] = $this->language->get('entry_status');
		$data['entry_category'] = $this->language->get('entry_category');

$data['button_copy'] = $this->language->get('button_copy');
		$data['button_add'] = $this->language->get('button_add');
		$data['button_edit'] = $this->language->get('button_edit');
		$data['button_delete'] = $this->language->get('button_delete');
		$data['button_filter'] = $this->language->get('button_filter');

$data['token'] = $this->session->data['token'];

if (isset($this->error['warning'])) {
			$data['error_warning'] = $this->error['warning'];
		} else {
			$data['error_warning'] = '';
		}

if (isset($this->session->data['success'])) {
			$data['success'] = $this->session->data['success'];

unset($this->session->data['success']);
		} else {
			$data['success'] = '';
		}

if (isset($this->request->post['selected'])) {
			$data['selected'] = (array)$this->request->post['selected'];
		} else {
			$data['selected'] = array();
		}

$url = '';

if (isset($this->request->get['filter_name'])) {
			$url .= '&filter_name=' . urlencode(html_entity_decode($this->request->get['filter_name'], ENT_QUOTES, 'UTF-8'));
		}

if (isset($this->request->get['filter_category'])) {
			$url .= '&filter_category=' . urlencode(html_entity_decode($this->request->get['filter_category'], ENT_QUOTES, 'UTF-8'));
		}

if (isset($this->request->get['filter_price'])) {
			$url .= '&filter_price=' . $this->request->get['filter_price'];
		}

if (isset($this->request->get['filter_quantity'])) {
			$url .= '&filter_quantity=' . $this->request->get['filter_quantity'];
		}

if (isset($this->request->get['filter_status'])) {
			$url .= '&filter_status=' . $this->request->get['filter_status'];
		}

if ($order == 'ASC') {
			$url .= '&order=DESC';
		} else {
			$url .= '&order=ASC';
		}

if (isset($this->request->get['page'])) {
			$url .= '&page=' . $this->request->get['page'];
		}

$data['sort_name'] = $this->url->link('catalog/product_catalog', 'token=' . $this->session->data['token'] . '&sort=pd.name' . $url, true);
		$data['sort_model'] = $this->url->link('catalog/product_catalog', 'token=' . $this->session->data['token'] . '&sort=p.model' . $url, true);
		$data['sort_price'] = $this->url->link('catalog/product_catalog', 'token=' . $this->session->data['token'] . '&sort=p.price' . $url, true);
		$data['sort_quantity'] = $this->url->link('catalog/product_catalog', 'token=' . $this->session->data['token'] . '&sort=p.quantity' . $url, true);
		$data['sort_status'] = $this->url->link('catalog/product_catalog', 'token=' . $this->session->data['token'] . '&sort=p.status' . $url, true);
		$data['sort_order'] = $this->url->link('catalog/product_catalog', 'token=' . $this->session->data['token'] . '&sort=p.sort_order' . $url, true);

$url = '';

if (isset($this->request->get['filter_name'])) {
			$url .= '&filter_name=' . urlencode(html_entity_decode($this->request->get['filter_name'], ENT_QUOTES, 'UTF-8'));
		}

if (isset($this->request->get['filter_category'])) {
			$url .= '&filter_category=' . urlencode(html_entity_decode($this->request->get['filter_category'], ENT_QUOTES, 'UTF-8'));
		}

if (isset($this->request->get['filter_price'])) {
			$url .= '&filter_price=' . $this->request->get['filter_price'];
		}

if (isset($this->request->get['filter_quantity'])) {
			$url .= '&filter_quantity=' . $this->request->get['filter_quantity'];
		}

if (isset($this->request->get['filter_status'])) {
			$url .= '&filter_status=' . $this->request->get['filter_status'];
		}

if (isset($this->request->get['sort'])) {
			$url .= '&sort=' . $this->request->get['sort'];
		}

if (isset($this->request->get['order'])) {
			$url .= '&order=' . $this->request->get['order'];
		}

$pagination = new Pagination();
		$pagination->total = $product_total;
		$pagination->page = $page;
		$pagination->limit = $this->config->get('config_limit_admin');
		$pagination->url = $this->url->link('catalog/product_catalog', 'token=' . $this->session->data['token'] . $url . '&page={page}', true);

$data['pagination'] = $pagination->render();

$data['results'] = sprintf($this->language->get('text_pagination'), ($product_total) ? (($page - 1) * $this->config->get('config_limit_admin')) + 1 : 0, ((($page - 1) * $this->config->get('config_limit_admin')) > ($product_total - $this->config->get('config_limit_admin'))) ? $product_total : ((($page - 1) * $this->config->get('config_limit_admin')) + $this->config->get('config_limit_admin')), $product_total, ceil($product_total / $this->config->get('config_limit_admin')));

$data['filter_name'] = $filter_name;
		$data['filter_category'] = $filter_category;
		$data['filter_price'] = $filter_price;
		$data['filter_quantity'] = $filter_quantity;
		$data['filter_status'] = $filter_status;

$data['sort'] = $sort;
		$data['order'] = $order;
		
		$data['header'] = $this->load->controller('common/header');
		$data['column_left'] = $this->load->controller('common/column_left');
		$data['footer'] = $this->load->controller('common/footer');

$this->response->setOutput($this->load->view('catalog/product_catalog_list.tpl', $data));
	}
	
	function createProductCatalog(){
		$this->load->model('catalog/productcatalog');
		$this->load->model('catalog/product');
		$this->load->model('catalog/externalcustomer');
		$this->load->language('catalog/product');
		$this->load->model('tool/image');
		if (($this->request->server['REQUEST_METHOD'] == 'POST')) {
			$product_data =$this->request->post;

$product_catalog = array();
			if(isset($product_data['selected']) && !empty($product_data['selected'])){
				foreach($product_data['selected'] as $key => $val){
					$res_product = $this->model_catalog_product->getProduct($val);

$res_category = $this->model_catalog_productcatalog->getProductCategory($res_product['product_id']);
					$category_name = '';
					if(isset($res_category['name'])){
						$category_name = $res_category['name'];
					}
					
					if (is_file(DIR_IMAGE . $res_product['image'])) {
						$image = $this->model_tool_image->resize($res_product['image'], 200, 200);
					} else {
						$image = '';
					}
					
					if(isset($res_product) && !empty($res_product)){
						$data['product_catalog'][] = (object) array(
							'name'		=> $res_product['name'],
							'category'	=> $category_name,
							'price'		=> number_format($res_product['price'],2),
							'image'		=> $image
						);				
					}	
				}
				if(isset($product_data['product_catalog_price'])){
					$data['product_catalog_price'] = 1;
				}else{
					$data['product_catalog_price'] = 0;
				}
				if(isset($product_data['product_catalog_image'])){
					$data['product_catalog_image'] = 1;
				}else{
					$data['product_catalog_image'] = 0;
				}
			}

$html = $this->load->view('mail/product_catalog.tpl', $data);
			$file_name = HTTP_CATALOG.'product_catalog/Product_Catalog_'.date('Y-m-d_H:i:s') . '.pdf';
			$file = DIR_PRODUCT_CATALOG_PDF.'Product_Catalog_'.date('Y-m-d_H:i:s') . '.pdf';
			
			$this->exportPdf($html,$file,'P','F');
			
			$_SESSION['product_catalog_file'] = $file_name;
			$_SESSION['product_catalog_attachment'] = $file;
			
			$this->session->data['success'] = $this->language->get('text_success');
			$this->response->redirect($this->url->link('catalog/product_catalog'.$url, 'token=' . $this->session->data['token'], 'SSL'));
			}
	}
	
	
	function exportPdf($html='',$file='',$orientation='',$output_type='')
    {
        require_once (DIR_SYSTEM . 'tcpdf/tcpdf.php');
        // create new PDF document
        $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
        // set document information
        $pdf->SetCreator(PDF_CREATOR);
        $pdf->SetAuthor('Sigma');
        $pdf->SetTitle('Sigma');
        $pdf->SetSubject('Sigma');
        $pdf->SetKeywords('Sigma');
        // set default header data
        $pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE , PDF_HEADER_STRING, array(
			34,
            34,
            34
        ), array(
            31,
            73,
            125
        ));
        $pdf->setFooterData(array(
            34,
            34,
            34
        ), array(
             31,
            73,
            125
        ));
        // set header and footer fonts
        $pdf->setHeaderFont(Array(
            PDF_FONT_NAME_MAIN,
            '',
            PDF_FONT_SIZE_MAIN
        ));
        $pdf->setFooterFont(Array(
            PDF_FONT_NAME_DATA,
            '',
            PDF_FONT_SIZE_DATA
        ));
        // set default monospaced font
        $pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
        // set margins
        $pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
        $pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
        $pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
        // set auto page breaks
        $pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
        // set image scale factor
        $pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
        // set some language-dependent strings (optional)
        if (@file_exists(dirname(__FILE__) . '/lang/eng.php')) {
            require_once(dirname(__FILE__) . '/lang/eng.php');
            $pdf->setLanguageArray($l);
        }
        // ---------------------------------------------------------    
        // set default font subsetting mode
        $pdf->setFontSubsetting(true);
        // Set font
        // dejavusans is a UTF-8 Unicode font, if you only need to
        // print standard ASCII chars, you can use core fonts like
        // helvetica or times to reduce file size.
        $pdf->SetFont('dejavusans', '', 8, '', true);
        // Add a page
        // This method has several options, check the source code documentation for more information.
        if($orientation == 'L'){
			$pdf->AddPage('L');
		}else{
			$pdf->AddPage();
		}
	
        // set text shadow effect
        $pdf->setTextShadow(array(
            'enabled' => true,
            'depth_w' => 0.2,
            'depth_h' => 0.2,
            'color' => array(
              196,196,196
            ),
            'opacity' => 1,
            'blend_mode' => 'Normal'
        ));
              
        $pdf->writeHTMLCell(0, 0, '', '', $html, 0, 1, 0, true, '', true);	
        if($output_type != ''){
			$output_type = $output_type;
		}else{
			$output_type = 'I';
		}
        $pdf->Output($file, $output_type);
    }

protected function validateDelete() {
		if (!$this->user->hasPermission('modify', 'catalog/product_catalog')) {
			$this->error['warning'] = $this->language->get('error_permission');
		}

return !$this->error;
	}

public function autocomplete() {
		$json = array();

if (isset($this->request->get['filter_name']) || isset($this->request->get['filter_category'])) {
			$this->load->model('catalog/product');
			$this->load->model('catalog/option');

if (isset($this->request->get['filter_name'])) {
				$filter_name = $this->request->get['filter_name'];
			} else {
				$filter_name = '';
			}

if (isset($this->request->get['filter_category'])) {
				$filter_category = $this->request->get['filter_category'];
			} else {
				$filter_category = '';
			}

if (isset($this->request->get['limit'])) {
				$limit = $this->request->get['limit'];
			} else {
				$limit = 5;
			}

$filter_data = array(
				'filter_name'  => $filter_name,
				'filter_category' => $filter_category,
				'start'        => 0,
				'limit'        => $limit
			);

$results = $this->model_catalog_product->getProducts($filter_data);

foreach ($results as $result) {
				$option_data = array();

$product_options = $this->model_catalog_product->getProductOptions($result['product_id']);

foreach ($product_options as $product_option) {
					$option_info = $this->model_catalog_option->getOption($product_option['option_id']);

if ($option_info) {
						$product_option_value_data = array();

foreach ($product_option['product_option_value'] as $product_option_value) {
							$option_value_info = $this->model_catalog_option->getOptionValue($product_option_value['option_value_id']);

if ($option_value_info) {
								$product_option_value_data[] = array(
									'product_option_value_id' => $product_option_value['product_option_value_id'],
									'option_value_id'         => $product_option_value['option_value_id'],
									'name'                    => $option_value_info['name'],
									'price'                   => (float)$product_option_value['price'] ? $this->currency->format($product_option_value['price'], $this->config->get('config_currency')) : false,
									'price_prefix'            => $product_option_value['price_prefix']
								);
							}
						}

$option_data[] = array(
							'product_option_id'    => $product_option['product_option_id'],
							'product_option_value' => $product_option_value_data,
							'option_id'            => $product_option['option_id'],
							'name'                 => $option_info['name'],
							'type'                 => $option_info['type'],
							'value'                => $product_option['value'],
							'required'             => $product_option['required']
						);
					}
				}

$json[] = array(
					'product_id' => $result['product_id'],
					'name'       => strip_tags(html_entity_decode($result['name'], ENT_QUOTES, 'UTF-8')),
					'model'      => $result['model'],
					'option'     => $option_data,
					'price'      => $result['price']
				);
			}
		}

$this->response->addHeader('Content-Type: application/json');
		$this->response->setOutput(json_encode($json));
	}

public function sendProductCatalog() {
		$this->document->setTitle($this->language->get('heading_title'));

$this->load->model('catalog/productcatalog');

if (($this->request->server['REQUEST_METHOD'] == 'POST')) {
				$data = $this->request->post;
				$mail_data = array();
				if($data['customer_type'] == 'new_customer'){
					$res_customer_email = $this->model_catalog_productcatalog->getExternalCustomerEmails($data);
							
					if(isset($res_customer_email) && !empty($res_customer_email)){
						foreach($res_customer_email as $key => $val){
							$mail_data[] = array(
								'name'	=> $val['external_customer_name'],
								'email'	=> $val['external_customer_email']
							); 
						}
					}
				}elseif($data['customer_type'] == 'old_customer'){
					if($data['to'] == 'newsletter'){
						$res_customer_email = $this->model_catalog_productcatalog->getCustomerEmails('newsletter');
					}elseif($data['to'] == 'customer_all'){
						$res_customer_email = $this->model_catalog_productcatalog->getCustomerEmails();
					}elseif($data['to'] == 'customer_group'){
						$res_customer_email = $this->model_catalog_productcatalog->getCustomerEmails('customer_group',$data['customer_group_id']);
					}
					
					if(isset($res_customer_email) && !empty($res_customer_email)){
						foreach($res_customer_email as $key => $val){
							$mail_data[] = array(
								'name'	=> $val['firstname'].' '.$val['lastname'],
								'email'	=> $val['email']
							); 
						}
					}
	
				}else{
					$res_customer_email = explode(',',$data['custom_mail_address']);
					if(isset($res_customer_email) && !empty($res_customer_email)){
						foreach($res_customer_email as $key => $val){
							$mail_data[] = array(
								'name'	=> '',
								'email'	=> $val
							); 
						}
					}
				}
								
				$res = $this->model_catalog_productcatalog->SendCatalog($data['attachment'],$mail_data);
			
				if($res){
					$this->session->data['success'] = 'Success: Mail successfully Sent!';
				}else{
					$this->session->data['success'] = 'Error: Please try again!';
				}
			
			$this->response->redirect($this->url->link('catalog/product_catalog', 'token=' .$this->session->data['token'], 'SSL'));
		}
	}

}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: product_catalog.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation