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/model/catalog

Free Space:

4.1 TB

🔧 Quick Actions

✏️ Editing: productcatalog.php

<?php
class ModelCatalogProductcatalog extends Model {
	public function updateProductPrice($product_id, $new_price) {
		$this->db->query("UPDATE " . DB_PREFIX . "product SET  price = '" . (float)$new_price. "', date_modified = NOW() WHERE product_id = '" . (int)$product_id . "'");

$this->cache->delete('product');

$this->event->trigger('post.admin.product.edit', $product_id);
	}
	
	public function getCategories() {
		
		$query = $this->db->query("SELECT * FROM " . DB_PREFIX . "category i LEFT JOIN " . DB_PREFIX . "category_description id ON (i.category_id = id.category_id)  ORDER BY id.title");

$category_data = $query->rows;
		return $category_data;
	}

public function getTotalProducts($data = array()) {
		$sql = "SELECT COUNT(DISTINCT p.product_id) AS total FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) LEFT JOIN " . DB_PREFIX . "product_to_category pc ON (p.product_id = pc.product_id)";

$sql .= " WHERE pd.language_id = '" . (int)$this->config->get('config_language_id') . "'";

if (!empty($data['filter_category'])) {
			$sql .= " AND pc.category_id LIKE '" . $this->db->escape($data['filter_category']) . "%'";
		}
		
		if (!empty($data['filter_name'])) {
			$sql .= " AND pd.name LIKE '" . $this->db->escape($data['filter_name']) . "%'";
		}

if (!empty($data['filter_model'])) {
			$sql .= " AND p.model LIKE '" . $this->db->escape($data['filter_model']) . "%'";
		}

if (isset($data['filter_price']) && !is_null($data['filter_price'])) {
			$sql .= " AND p.price LIKE '" . $this->db->escape($data['filter_price']) . "%'";
		}

if (isset($data['filter_quantity']) && !is_null($data['filter_quantity'])) {
			$sql .= " AND p.quantity = '" . (int)$data['filter_quantity'] . "'";
		}

if (isset($data['filter_status']) && !is_null($data['filter_status'])) {
			$sql .= " AND p.status = '" . (int)$data['filter_status'] . "'";
		}

$query = $this->db->query($sql);

return $query->row['total'];
	}
	
	public function getProducts($data = array()) {
		$sql = "SELECT p.product_id,p.image,p.price,pd.name,p.model,p.quantity,p.status FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) LEFT JOIN " . DB_PREFIX . "product_to_category pc ON (p.product_id = pc.product_id) WHERE pd.language_id = '" . (int)$this->config->get('config_language_id') . "'";

if (!empty($data['filter_name'])) {
			$sql .= " AND pd.name LIKE '" . $this->db->escape($data['filter_name']) . "%'";
		}
		
		if (!empty($data['filter_category'])) {
			$sql .= " AND pc.category_id LIKE '" . $this->db->escape($data['filter_category']) . "%'";
		}

if (!empty($data['filter_model'])) {
			$sql .= " AND p.model LIKE '" . $this->db->escape($data['filter_model']) . "%'";
		}

if (isset($data['filter_price']) && !is_null($data['filter_price'])) {
			$sql .= " AND p.price LIKE '" . $this->db->escape($data['filter_price']) . "%'";
		}

if (isset($data['filter_quantity']) && !is_null($data['filter_quantity'])) {
			$sql .= " AND p.quantity = '" . (int)$data['filter_quantity'] . "'";
		}

if (isset($data['filter_status']) && !is_null($data['filter_status'])) {
			$sql .= " AND p.status = '" . (int)$data['filter_status'] . "'";
		}
		
		$sql .= " GROUP BY p.product_id";

$sort_data = array(
			'pd.name',
			'p.model',
			'p.price',
			'p.quantity',
			'p.status',
			'p.sort_order'
		);

if (isset($data['sort']) && in_array($data['sort'], $sort_data)) {
			$sql .= " ORDER BY " . $data['sort'];
		} else {
			$sql .= " ORDER BY pd.name";
		}

if (isset($data['order']) && ($data['order'] == 'DESC')) {
			$sql .= " DESC";
		} else {
			$sql .= " ASC";
		}

if (isset($data['start']) || isset($data['limit'])) {
			if ($data['start'] < 0) {
				$data['start'] = 0;
			}

if ($data['limit'] < 1) {
				$data['limit'] = 20;
			}

$sql .= " LIMIT " . (int)$data['start'] . "," . (int)$data['limit'];
		}

$query = $this->db->query($sql);

return $query->rows;
	}
	
	public function getProductCategory($product_id) {
		$query = $this->db->query("SELECT p2c.*,cd.name FROM " . DB_PREFIX . "product_to_category AS p2c LEFT JOIN " . DB_PREFIX . "category_description AS cd ON p2c.category_id = cd.category_id WHERE p2c.product_id = ".$product_id);

return $query->row;
	}
	
	function getExternalCustomerEmails($data){
		$sql = "SELECT * FROM si_external_customer WHERE ";
		$filter = array();
		if(isset($data['city_id']) && !empty($data['city_id'])){
			$filter[] = " city_id = '".$data['city_id']."'";	
		}
		if(isset($data['religion_id']) && !empty($data['religion_id'])){
			$filter[] = " religion_id = '".$data['religion_id']."'";	
		}
		$filter_sql = '';
		$filter_sql = implode(' AND ',$filter);
		
		if(!empty($filter_sql)){
			$sql .= $filter_sql;	
		}		
		$query = $this->db->query($sql);

return $query->rows;
	}

return $query->rows;
	}

function SendCatalog($attachment,$to_address){
		$subject = 'Product Catalog';
		$mail = new Mail();
		$mail->protocol = $this->config->get('config_mail_protocol');
		$mail->parameter = $this->config->get('config_mail_parameter');
		$mail->smtp_hostname = $this->config->get('config_mail_smtp_hostname');
		$mail->smtp_username = $this->config->get('config_mail_smtp_username');
		$mail->smtp_password = html_entity_decode($this->config->get('config_mail_smtp_password'), ENT_QUOTES, 'UTF-8');
		$mail->smtp_port = $this->config->get('config_mail_smtp_port');
		$mail->smtp_timeout = $this->config->get('config_mail_smtp_timeout');

$mail->setFrom($this->config->get('config_email'));
		$mail->setSender(html_entity_decode($this->config->get('store_name'), ENT_QUOTES, 'UTF-8'));
		$mail->setSubject(html_entity_decode($subject, ENT_QUOTES, 'UTF-8'));
		$mail->addAttachment($attachment);
/*
		echo '<pre>';
		print_r($to_address);
		echo '</pre>';
		exit;
*/
				
		if(isset($to_address) && !empty($to_address)){
			foreach($to_address as $key => $val){
				$html = 'Hi, '.$val['name'].' <br> Please find the attached Product Catalog.';
				$mail->setTo($val['email']);
				$mail->setHtml($html);
				echo $html;
				echo '<br>';
				//$mail->send();
			}
			return true;	
		}else{
			return false;
		}
	}
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: productcatalog.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation