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/tmrda_0/catalog/model/account/vendor

Free Space:

3.51 TB

🔧 Quick Actions

✏️ Editing: lts_commission_report.php

<?php
class ModelVendorLtsCommissionReport extends Model {
	public function addCommissionReport($order_id,$product) {
		$query = $this->db->query("SELECT product_id, vendor_id FROM ". DB_PREFIX ."lts_vendor_product WHERE product_id='". (int)$product['product_id'] ."'");
		if($query->row) {
			$sql1 = $this->db->query("SELECT category_id FROM ". DB_PREFIX ."lts_vendor_product_to_category WHERE product_id ='". (int)$product['product_id'] ."'");

if(!empty($sql1->row['category_id'])) {
				
				$sql2 = $this->db->query("SELECT * FROM ". DB_PREFIX ."lts_vendor_commission WHERE category_id='". (int)$sql1->row['category_id'] ."'");

if($sql2->row) {
					
					if($sql2->row['commission_type'] == 'p') {
						$commission = $this->db->escape($product['quantity']) * $product['price'] * $sql2->row['commission'] / 100;
					} else {
						$commission = $this->db->escape($product['quantity']) * $sql2->row['commission'];    
					}

$this->db->query("INSERT INTO ". DB_PREFIX ."lts_vendor_commission_report SET vendor_id='". (int)$query->row['vendor_id'] ."', product_id='". (int)$product['product_id'] ."', name='". $this->db->escape($product['name']) ."', model='". $this->db->escape($product['model'])  ."', quantity='". (int)$product['quantity'] ."', price='". (float)$product['price'] ."', commission_type= '". $sql2->row['commission_type'] ."', commission='". (float)$commission ."', status = '0',  date_added= NOW()");
				}
			}
		}
	}

}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: lts_commission_report.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation