Added support to reintegrate product on cancelled orders

Code: Select all

		/*CHARGE BACK*/
		$backarr=array(7,8,11,12,13); // these are the status that requires a chargeback (change as you need, you can grab these code from order_status table (order_status_id)
		if (in_array((int)$data['order_status_id'], $backarr)) {
			$prev_st=$this->db->query("SELECT order_status_id from " . DB_PREFIX . "order where order_id= '" .  (int)$order_id . "'");
			echo $prev_st->row['order_status_id'];
			if ($this->config->get('config_stock_subtract')) {
				if (!in_array($prev_st->row['order_status_id'], $backarr)) {
					$order_product_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_product WHERE order_id = '" . (int)$order_id . "'");
					print_r($order_product_query);
					
					foreach ($order_product_query->rows as $result) {
					   $this->db->query("UPDATE " . DB_PREFIX . "product SET quantity = (quantity + " . (int)$result['quantity'] . ") WHERE product_id = '" . (int)$result['product_id'] . "'");
					}
				}
			}
		}

Code: Select all

// DEHiCKA - add CHARGE BACK
    $backarr=array(7,8,11,12,13); // these are the status that requires a chargeback (change as you need, you can grab these code from order_status table (order_status_id)
	if ($this->config->get('config_stock_subtract')) {
		$order_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "order` WHERE order_status_id > '0' AND order_id = '" . (int)$order_id . "'");

		if (in_array((int)$data['order_status_id'], $backarr) != in_array($order_query->row['order_status_id'], $backarr) && $order_query->num_rows) { // status chargeback flag has changed
			$product_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_product WHERE order_id = '" . (int)$order_id . "'");
			if (in_array((int)$data['order_status_id'], $backarr)) $charge_dir = '+'; else $charge_dir = '-';
		   		
			foreach($product_query->rows as $product) {
					$this->db->query("UPDATE `" . DB_PREFIX . "product` SET quantity = (quantity ". $charge_dir. " " . (int)$product['quantity'] . ") WHERE product_id = '" . (int)$product['product_id'] . "'");
					
					$option_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "order_option WHERE order_id = '" . (int)$order_id . "' AND order_product_id = '" . (int)$product['order_product_id'] . "'");
				
					foreach ($option_query->rows as $option) {
						$this->db->query("UPDATE " . DB_PREFIX . "product_option_value SET quantity = (quantity ". $charge_dir. " " . (int)$product['quantity'] . ") WHERE product_option_value_id = '" . (int)$option['product_option_value_id'] . "' AND subtract = '1'");
					}				
				}
			}
		}
// DEHiCKA - end

Code: Select all

// DEHiCKA - mod CHARGE BACK
		    $backarr=array(7,8,11,12,13,5); // these are the status that DOES NOT requires a chargeback on delete (change as you need, you can grab these code from order_status table (order_status_id)
			if (!in_array($order_query->row['order_status_id'], $backarr))
// DEHiCKA - end CHARGE BACK