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

Free Space:

4.1 TB

🔧 Quick Actions

✏️ Editing: product_stock.php

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

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

$this->document->setTitle('Stock Management');

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

$this->getList();
	}

protected function getList() {
		
		if (isset($this->request->get['filter_name'])) {
			$filter_name = $this->request->get['filter_name'];
		} else {
			$filter_name = 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_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'], 'SSL')
		);

$data['breadcrumbs'][] = array(
			'text' => 'Stock view',
			'href' => $this->url->link('catalog/product_stock', 'token=' . $this->session->data['token'] . $url, 'SSL')
		);
		
		$data['export'] = $this->url->link('catalog/product_stock/export', 'token=' . $this->session->data['token'] . $url, 'SSL');
		
		$data['products'] = array();

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

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

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

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

/*
         echo "<pre>";
		 print_r($results);
		 echo "</pre>";
*/

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);
			}
			$this->load->model('catalog/productstock');
			$stock_result = $this->model_catalog_productstock->getProductOptionStock($result['product_id']);
			
			if(empty($filter_quantity)){
				$filter_qty = '100000';
			}else{
				$filter_qty = $filter_quantity;
			}
			
			if(isset($stock_result) && !empty($stock_result)){
				foreach ($stock_result as $stock_result) {
					$deliverd_stock_result = $this->model_catalog_productstock->getOptionProductDelivered($stock_result['product_option_value_id']);
					$tobedeliverd_stock_result = $this->model_catalog_productstock->getOptionProductToBeDeliver($stock_result['product_option_value_id']);
				
					$total_stock = $stock_result['quantity'] + $deliverd_stock_result['total'];
					if($stock_result['quantity'] < $filter_qty){
						$data['products'][] = array(
							'product_id' 	=> $result['product_id'],
							'image'			=>  $image,
							'name'			=>  $result['name'],
							'sku'			=>  $result['sku'],
							'size'			=>  $stock_result['name'],
							'quantity'		=>  $stock_result['quantity'],
							'deliverd'		=>  $deliverd_stock_result['total'],
							'tobe_deliverd'	=>  $tobedeliverd_stock_result['total'],
							'total_stock' 	=> 	$total_stock,
							'status'     	=> ($result['status']) ? $this->language->get('text_enabled') : $this->language->get('text_disabled'),
						);
					}
				}
			}else{
				
				$deliverd_stock_result = $this->model_catalog_productstock->getProductDelivered($result['product_id']);
				$tobedeliverd_stock_result = $this->model_catalog_productstock->getProductToBeDeliver($result['product_id']);
				
				$total_stock = $result['quantity'] + $deliverd_stock_result['total'];
					
				$data['products'][] = array(
					'product_id' 	=> $result['product_id'],
					'image'			=>  $image,
					'name'			=>  $result['name'],
					'sku'			=>  $result['sku'],
					'size'			=>  '',
					'quantity'		=>  $result['quantity'],
					'deliverd'		=>  $deliverd_stock_result['total'],
					'tobe_deliverd'	=>  $tobedeliverd_stock_result['total'],
					'total_stock' 	=> 	$total_stock,
					'status'     	=> ($result['status']) ? $this->language->get('text_enabled') : $this->language->get('text_disabled'),
				);
			}
			
		}
		
		$config_qty = $this->config->get('config_product_qty_limit');
		
		if (isset($config_qty) && !empty($config_qty)) {
			$data['config_product_qty_limit'] = $config_qty;
		} else {
			$data['config_product_qty_limit'] = 50;
		}
		
		
		$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_name'] = $this->language->get('column_name');
		$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_quantity'] = $this->language->get('entry_quantity');
		$data['entry_status'] = $this->language->get('entry_status');

$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_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'];
		}

$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_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_stock', 'token=' . $this->session->data['token'] . $url . '&page={page}', 'SSL');

$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_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_stock_list.tpl', $data));
	}

public function add() {
		$this->document->setTitle('Stock Management');
		$this->load->model('catalog/product');
		$this->load->language('catalog/product');
		
		if (isset($this->request->get['filter_name'])) {
			$filter_name = $this->request->get['filter_name'];
		} else {
			$filter_name = 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_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'], 'SSL')
		);

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

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

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

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

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

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

foreach ($results as $result) {
			
			$this->load->model('catalog/productstock');
			$stock_result = $this->model_catalog_productstock->getProductOptionStock($result['product_id']);
			
			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);
			}
			if(empty($filter_quantity)){
				$filter_qty = '100000';
			}else{
				$filter_qty = $filter_quantity;
			}
			
			if(isset($stock_result) && !empty($stock_result)){
				foreach ($stock_result as $stock_result) {
					if( $stock_result['quantity'] < $filter_qty ){
						$data['products'][] = array(
							'product_id' 				=> $result['product_id'],
							'product_option_value_id' 	=> $stock_result['product_option_value_id'],
							'option_id' 				=> $stock_result['option_id'],
							'option_value_id' 			=> $stock_result['option_value_id'],
							'image'						=>  $image,
							'name'						=>  $result['name'],
							'sku'						=>  $result['sku'],
							'size'						=>  $stock_result['name'],
							'quantity'					=>  $stock_result['quantity'],
							'total_stock' 				=> $stock_result['quantity'],
							'status'     				=> ($result['status']) ? $this->language->get('text_enabled') : $this->language->get('text_disabled'),
						);
					}
				}
			}else{
				$deliverd_stock_result = $this->model_catalog_productstock->getProductDelivered($result['product_id']);
				$tobedeliverd_stock_result = $this->model_catalog_productstock->getProductToBeDeliver($result['product_id']);
				
				$total_stock = $result['quantity'] + $deliverd_stock_result['total'];
					
				$data['products'][] = array(
					'product_id' 	=> $result['product_id'],
					'product_option_value_id' 	=> '',
					'option_id' 				=> '',
					'option_value_id' 			=> '',
					'image'						=>  $image,
					'name'						=>  $result['name'],
					'sku'						=>  $result['sku'],
					'size'						=>  '',
					'quantity'					=>  $result['quantity'],
					'total_stock' 				=> $total_stock,
					'status'     				=> ($result['status']) ? $this->language->get('text_enabled') : $this->language->get('text_disabled'),
				);	
			}	
			}
		$config_qty = $this->config->get('config_product_qty_limit');
		
		if (isset($config_qty) && !empty($config_qty)) {
			$data['config_product_qty_limit'] = $config_qty;
		} else {
			$data['config_product_qty_limit'] = 50;
		}
		
		$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['entry_name'] = $this->language->get('entry_name');
		$data['entry_quantity'] = $this->language->get('entry_quantity');
		$data['entry_status'] = $this->language->get('entry_status');

$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_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'];
		}

$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_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_stock/add', 'token=' . $this->session->data['token'] . $url . '&page={page}', 'SSL');

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

$data['filter_name'] = $filter_name;
		$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_stock_add.tpl', $data));
	}

public function export(){
		$this->load->model('catalog/product');
		if (isset($this->request->get['filter_name'])) {
			$filter_name = $this->request->get['filter_name'];
		} else {
			$filter_name = 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;
		}

$stock_list = array();

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

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

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

$results = $this->model_catalog_product->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);
			}
			$this->load->model('catalog/productstock');
			$stock_result = $this->model_catalog_productstock->getProductOptionStock($result['product_id']);
			
			if(empty($filter_quantity)){
				$filter_qty = '100000';
			}else{
				$filter_qty = $filter_quantity;
			}
			
						
			if(isset($stock_result) && !empty($stock_result)){
				foreach ($stock_result as $stock_result) {
					if($stock_result['quantity'] < $filter_qty){
						$stock_list[] = array(
							$result['product_id'],
							$result['name'],
							$result['sku'],
							$stock_result['name'],
							//$stock_result['quantity'],
							$stock_result['quantity'],
							($result['status']) ? $this->language->get('text_enabled') : $this->language->get('text_disabled'),
						);
					}
				}
			}else{				
				$stock_list[] = array(
					$result['product_id'],
					$result['name'],
					$result['sku'],
					$result['quantity'],
					($result['status']) ? $this->language->get('text_enabled') : $this->language->get('text_disabled'),
				);
			}
			
		}
		 
		
		
		$stock = array();
		$stock_column = array('Product Id','Product Name','SKU', 'Quantity',  'Status');
            
        $stock[0]=   $stock_column;   
        
        foreach($stock_list as $stock_row)
        {
            $stock[]=   $stock_row;            
        }     
        require_once(DIR_SYSTEM . 'library/excel_xml.php');
        $xls = new Excel_XML('UTF-8', false, 'Orders List');
        
        $xls->addArray($stock);
        //~ echo '<pre>';
		//~ print_r($stock);
		//~ echo '</pre>';
		//~ exit;
        $xls->generateXML('stocklist_'.date('Y-m-d_H:i:s'));	
        
	}
	
	public function addOptionStock() {
		$this->load->model('catalog/productstock');
		$res = $this->model_catalog_productstock->addProductOptionStock($_POST);
		if($res !=''){
			$res = $res;
		}else{
			$res = 'fail';
		}
		echo json_encode($res);
	}
	
	public function removeOptionStock() {
		$this->load->model('catalog/productstock');
		$res = $this->model_catalog_productstock->removeProductOptionStock($_POST);
		if($res !=''){
			$res = $res;
		}else{
			$res = 'fail';
		}
		echo json_encode($res);
	}
	
	
	public function addProductStock() {
		$this->load->model('catalog/productstock');
		$res = $this->model_catalog_productstock->addProductStock($_POST);
		if($res !=''){
			$res = $res;
		}else{
			$res = 'fail';
		}
		echo json_encode($res);
	}
	
	public function removeProductStock() {
		$this->load->model('catalog/productstock');
		$res = $this->model_catalog_productstock->removeProductStock($_POST);
		if($res !=''){
			$res = $res;
		}else{
			$res = 'fail';
		}
		echo json_encode($res);
	}

}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: product_stock.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation