<?php

/******************************************************************************************
 * Copyright (C) Smackcoders. - All Rights Reserved under Smackcoders Proprietary License
 * Unauthorized copying of this file, via any medium is strictly prohibited
 * Proprietary and confidential
 * You can contact Smackcoders at email address info@smackcoders.com.
 *******************************************************************************************/

namespace Smackcoders\WCSV;

use Smackcoders\WCSV\WC_Coupon;

if (! defined('ABSPATH'))
	exit; // Exit if accessed directly

/**
 * Class WooCommerceExport
 * @package Smackcoders\WCSV
 */
class WooCommerceExport
{

	protected static $instance = null, $mapping_instance, $export_handler, $export_instance, $post_export;
	public $totalRowCount;
	public $plugin;

	public static function getInstance()
	{
		if (null == self::$instance) {
			self::$instance = new self;
			WooCommerceExport::$export_instance = ExportExtension::getInstance();
			WooCommerceExport::$post_export = PostExport::getInstance();
		}
		return self::$instance;
	}

	/**
	 * WooCommerceExport constructor.
	 */
	public function __construct()
	{
		$this->plugin = Plugin::getInstance();
	}

	/**
	 * Export woocommerce orders
	 * @param $id
	 * @param $type
	 * @param $optional
	 * @return bool
	 */
	public function getWooComOrderData($id, $type = null, $optional = null)
	{
		$order = wc_get_order($id);
		if ($order) {
			$order_data = $order->get_data();
			$orderid = $order->get_id();
			WooCommerceExport::$export_instance->data[$id]['ORDERID'] = $orderid;
			//fetch the order data
			$date_created_object = $order_data['date_created'];
			$formatted_date_time = $date_created_object->date('m/d/Y H:i:s');
			WooCommerceExport::$export_instance->data[$id]['order_date'] = $formatted_date_time;
			$customer_note = $order_data['customer_note'];
			WooCommerceExport::$export_instance->data[$id]['customer_note'] = $customer_note;
			$billing_details = $order_data['billing'];
			$order_status = $order_data['status'];
			WooCommerceExport::$export_instance->data[$id]['order_status'] = 'wc-' . $order_status;
			$_billing_first_name  = $billing_details['first_name'];
			WooCommerceExport::$export_instance->data[$id]['_billing_first_name'] = $_billing_first_name;
			$_billing_last_name   = $billing_details['last_name'];
			WooCommerceExport::$export_instance->data[$id]['_billing_last_name'] = $_billing_last_name;
			$_billing_company     = $billing_details['company'];
			WooCommerceExport::$export_instance->data[$id]['_billing_company'] = $_billing_company;
			$_billing_address_1   = $billing_details['address_1'];
			WooCommerceExport::$export_instance->data[$id]['_billing_address_1'] = $_billing_address_1;
			$_billing_address_2   = $billing_details['address_2'];
			WooCommerceExport::$export_instance->data[$id]['_billing_address_2'] = $_billing_address_2;
			$_billing_city        = $billing_details['city'];
			WooCommerceExport::$export_instance->data[$id]['_billing_city'] = $_billing_city;
			$_billing_state       = $billing_details['state'];
			WooCommerceExport::$export_instance->data[$id]['_billing_state'] = $_billing_state;
			$_billing_postcode    = $billing_details['postcode'];
			WooCommerceExport::$export_instance->data[$id]['_billing_postcode'] = $_billing_postcode;
			$_billing_country     = $billing_details['country'];
			WooCommerceExport::$export_instance->data[$id]['_billing_country'] = $_billing_country;
			$_order_currency = $order_data['currency'];
			WooCommerceExport::$export_instance->data[$id]['_order_currency'] = $_order_currency;
			$_order_shipping_tax = $order_data['shipping_tax'];
			WooCommerceExport::$export_instance->data[$id]['_order_shipping_tax'] = $_order_shipping_tax;
			$_order_shipping = $order->get_shipping_total();
			WooCommerceExport::$export_instance->data[$id]['_order_shipping'] = $_order_shipping;
			$_order_tax = $order_data['cart_tax'];
			WooCommerceExport::$export_instance->data[$id]['_order_tax'] = $_order_tax;
			$_customer_user = $order_data['customer_id'];
			if ($_customer_user != 0) {
				$user_data = get_userdata($_customer_user);
				$user_email = $user_data->user_email;
				WooCommerceExport::$export_instance->data[$id]['_customer_user'] = $user_email;
			}
			$_billing_email = $billing_details['email'];
			WooCommerceExport::$export_instance->data[$id]['_billing_email'] = $_billing_email;

			$_billing_phone = $billing_details['phone'];
			WooCommerceExport::$export_instance->data[$id]['_billing_phone'] = $_billing_phone;

			$_shipping_first_name = $order_data['shipping']['first_name'];
			WooCommerceExport::$export_instance->data[$id]['_shipping_first_name'] = $_shipping_first_name;

			$_shipping_last_name = $order_data['shipping']['last_name'];
			WooCommerceExport::$export_instance->data[$id]['_shipping_last_name'] = $_shipping_last_name;

			$_shipping_company = $order_data['shipping']['company'];
			WooCommerceExport::$export_instance->data[$id]['_shipping_company'] = $_shipping_company;

			$_shipping_address_1 = $order_data['shipping']['address_1'];
			WooCommerceExport::$export_instance->data[$id]['_shipping_address_1'] = $_shipping_address_1;

			$_shipping_address_2 = $order_data['shipping']['address_2'];
			WooCommerceExport::$export_instance->data[$id]['_shipping_address_2'] = $_shipping_address_2;

			$_shipping_city = $order_data['shipping']['city'];
			WooCommerceExport::$export_instance->data[$id]['_shipping_city'] = $_shipping_city;

			$_shipping_state = $order_data['shipping']['state'];
			WooCommerceExport::$export_instance->data[$id]['_shipping_state'] = $_shipping_state;

			$_shipping_postcode = $order_data['shipping']['postcode'];
			WooCommerceExport::$export_instance->data[$id]['_shipping_postcode'] = $_shipping_postcode;

			$_shipping_country = $order_data['shipping']['country'];
			WooCommerceExport::$export_instance->data[$id]['_shipping_country'] = $_shipping_country;

			$_shipping_phone = $order_data['shipping']['phone'];
			WooCommerceExport::$export_instance->data[$id]['_shipping_phone'] = $_shipping_phone;

			$_order_total = $order_data['total'];
			WooCommerceExport::$export_instance->data[$id]['_order_total'] = $_order_total;

			$_cart_discount = $order_data['discount_total'];
			WooCommerceExport::$export_instance->data[$id]['_cart_discount'] = $_cart_discount;

			$_cart_discount_tax = $order_data['discount_tax'];
			WooCommerceExport::$export_instance->data[$id]['_cart_discount_tax'] = $_cart_discount_tax;

			$_payment_method = $order_data['payment_method'];
			WooCommerceExport::$export_instance->data[$id]['_payment_method'] = $_payment_method;

			$_recorded_sales = $order_data['recorded_sales'];
			if ($_recorded_sales > 0) {
				$_recorded_sales = 'yes';
			} else {
				$_recorded_sales = 'no';
			}
			WooCommerceExport::$export_instance->data[$id]['recorded_sales'] = $_recorded_sales;

			$_payment_method_title = $order_data['payment_method_title'];
			WooCommerceExport::$export_instance->data[$id]['_payment_method_title'] = $_payment_method_title;

			$_transaction_id = $order_data['transaction_id'];
			WooCommerceExport::$export_instance->data[$id]['_transaction_id'] = $_transaction_id;
			$line_items = $order->get_items();
			$mycoupon = $order->get_coupons();

			if (!empty($mycoupon)) {
				foreach ($mycoupon as $coupon) {
					$coupon_code = $coupon->get_code();
				}
			}
			if (!empty($line_items)) {
				foreach ($line_items as $item_id => $item) {
					$item_names[] = $item->get_name();
					$product_type[] = $item->get_type();
					$variation_id[] = $item->get_variation_id();
					$product_id[] = $item->get_product_id();
					$subtotal[] = $item->get_subtotal();
					$subtotal_tax[] = $item->get_subtotal_tax();
					$total[] = $item->get_total();
					$total_tax[] = $item->get_total_tax();
					$item_tax_data[] = $item->get_taxes();
					if (!empty($item_tax_data) && is_array($item_tax_data)) {
						if (!empty($item_tax_data[0]['total']) || !empty($item_tax_data[0]['subtotal'])) {
							$line_tax[] = implode(',', $item_tax_data[0]['total']);
							$line_tax[] = implode(',', $item_tax_data[0]['subtotal']);
						} else {
							$line_tax = array();
						}
					}
					$tax_class[] = $item->get_tax_class();
					$quantity[] = $item->get_quantity();
				}
				if (!empty($coupon_code)) {
					$item_names[] = $coupon_code;
					$product_type[] = 'coupon';
				}
				//itemdata
				self::$export_instance->data[$id]['item_name'] = !empty($item_names) ? implode(',', $item_names) : '';
				self::$export_instance->data[$id]['item_type'] = !empty($product_type) ? implode(',', $product_type) : '';
				self::$export_instance->data[$id]['item_variation_id'] = !empty($variation_id) ? implode(',', $variation_id) : '';
				self::$export_instance->data[$id]['item_product_id'] = !empty($product_id) ? implode(',', $product_id) : '';
				self::$export_instance->data[$id]['item_line_subtotal'] = !empty($subtotal) ? implode(',', $subtotal) : '';
				self::$export_instance->data[$id]['item_line_subtotal_tax'] = !empty($subtotal_tax) ? implode(',', $subtotal_tax) : '';
				self::$export_instance->data[$id]['item_line_total'] = !empty($total) ? implode(',', $total) : '';
				self::$export_instance->data[$id]['item_line_tax'] = !empty($total_tax) ? implode(',', $total_tax) : '';
				self::$export_instance->data[$id]['item_line_tax_data'] = !empty($line_tax) ? implode(',', $line_tax) : '';
				self::$export_instance->data[$id]['item_tax_class'] = !empty($tax_class) ? implode(',', $tax_class) : '';
				self::$export_instance->data[$id]['item_qty'] = !empty($quantity) ? implode(',', $quantity) : '';
			}
			//fee data
			$fees = $order->get_fees();
			if (!empty($fees)) {
				foreach ($fees as $fee) {
					$fee_name[] = $fee->get_name();
					$fee_type[] = $fee->get_type(); // Assuming there's a get_type() method; check the documentation
					$fee_tax_class[] = $fee->get_tax_class();
					$fee_line_total[] = $fee->get_total();
					$fee_line_tax[] = $fee->get_total_tax();
					// $fee_line_subtotal[] = $fee->get_subtotal();
					// $fee_line_subtotal_tax[] = $fee->get_subtotal_tax();
					$tax_data = $fee->get_taxes();
					if (!empty($tax_data['total'])) {
						$fee_line_tax_data[] = $tax_data['total'];
					} else {
						$fee_line_tax_data = array();
					}
				}
				//fee data
				self::$export_instance->data[$id]['fee_name'] = !empty($fee_name) ? implode(',', $fee_name) : '';
				self::$export_instance->data[$id]['fee_type'] = !empty($fee_type) ? implode(',', $fee_type) : '';
				self::$export_instance->data[$id]['fee_line_total'] = !empty($fee_line_total) ? implode(',', $fee_line_total) : '';
				self::$export_instance->data[$id]['fee_line_tax'] = !empty($fee_line_tax) ? implode(',', $fee_line_tax) : '';
				self::$export_instance->data[$id]['fee_line_tax_data'] = !empty($fee_line_tax_data) ? implode(',', $fee_line_tax_data) : '';
				self::$export_instance->data[$id]['fee_tax_class'] = !empty($fee_tax_class) ? implode(',', $fee_tax_class) : '';
			}
			//shipment data fetch
			$shipping_methods = $order->get_shipping_methods();
			if (!empty($shipping_methods)) {
				foreach ($shipping_methods as $shipping_method) {
					$shipment_name[] = $shipping_method->get_method_title();
					$shipment_method_id[] = $shipping_method->get_method_id();
					$shipment_cost[] = $shipping_method->get_total();
					$shipment_taxe_data = $shipping_method->get_taxes();
					if (!empty($shipment_taxe_data['total'])) {
						$shipment_taxes[] = $shipment_taxe_data['total'];
					} else {
						$shipment_taxes = array();
					}
				}
				// shipment data
				self::$export_instance->data[$id]['shipment_name'] = !empty($shipment_name) ? implode(',', $shipment_name) : '';
				self::$export_instance->data[$id]['shipment_method_id'] = !empty($shipment_method_id) ? implode(',', $shipment_method_id) : '';
				self::$export_instance->data[$id]['shipment_cost'] = !empty($shipment_cost) ? implode(',', $shipment_cost) : '';
				self::$export_instance->data[$id]['shipment_taxes'] = !empty($shipment_taxes) ? implode(',', $shipment_taxes) : '';
			}

			if (is_plugin_active('advanced-product-fields-for-woocommerce/advanced-product-fields-for-woocommerce.php')) {
				$this->getPPOMData($id, $product_id);
			}

			if (is_plugin_active('woo-extra-product-options/woo-extra-product-options.php')) {
				$this->getEPOData($id, $product_id);
			}
			if (is_plugin_active('woo-custom-product-addons/start.php')) {
				$this->getWCPAData($id, $product_id);
			}
			if (is_plugin_active('flexible-product-fields/flexible-product-fields.php')) {
				$this->getFPFData($id, $product_id);
			}
			if (is_plugin_active('yith-woocommerce-order-tracking-premium/init.php')) {
				self::$export_instance->data[$id]['ywot_tracking_code'] = 	$order->get_meta('ywot_tracking_code', true);
				self::$export_instance->data[$id]['ywot_tracking_postcode'] = $order->get_meta('ywot_tracking_postcode', true);
				self::$export_instance->data[$id]['ywot_carrier_id'] = $order->get_meta('ywot_carrier_id', true);
				self::$export_instance->data[$id]['ywot_pick_up_date'] =  $order->get_meta('ywot_pick_up_date', true);
				self::$export_instance->data[$id]['ywot_estimated_delivery_date'] =  $order->get_meta('ywot_estimated_delivery_date', true);
				self::$export_instance->data[$id]['ywot_picked_up'] =  $order->get_meta('ywot_picked_up', true);
			}
		}
	}


	/**
	 * Code for PPOM export
	 * @param $id
	 * @param $product_id
	 */
	public function getPPOMData($order_id, $product_ids)
	{

		global $wpdb;
		$table_name = $wpdb->prefix . 'nm_personalized';

		// Fetch all the PPOM field setups from the `wp_nm_personalized` table
		$field_setups = $wpdb->get_results("SELECT * FROM $table_name");

		if (!empty($field_setups)) {

			foreach ($field_setups as $setup) {
				$meta_data = json_decode($setup->the_meta, true);  // Unserialize the field meta data


				// Display the unserialized field data if available
				if (is_array($meta_data)) {

					foreach ($meta_data as $key => $field) {
						$pro_meta_fields[$field['title']] = $field['data_name'];
					}
				}
			}
		}

		// Get order items for the specified order ID
		$order_items = wc_get_order($order_id)->get_items();

		foreach ($order_items as $item_id => $item) {
			// Get the meta data for each order item
			$item_meta = wc_get_order_item_meta($item_id, '', false);

			foreach ($item_meta as $meta_key => $meta_value) {

				if (array_key_exists($meta_key, $pro_meta_fields)) { // Change this condition based on your actual meta key format

					self::$export_instance->data[$order_id][$meta_key] = $meta_value[0]; // Store each field key-value pair

				}
			}
		}
	}

	public function getEPOData($order_id, $product_ids)
	{
		global $wpdb;

		// Fetch all EPO field setups from the `wp_woocommerce_order_itemmeta` table
		$table_name = $wpdb->prefix . 'woocommerce_order_itemmeta';

		$epo_data = $wpdb->get_results($wpdb->prepare(
			"SELECT * FROM $table_name WHERE order_item_id IN (SELECT order_item_id FROM {$wpdb->prefix}woocommerce_order_items WHERE order_id = %d)",
			$order_id
		));

		$pro_meta_fields = [];

		if (!empty($epo_data)) {
			foreach ($epo_data as $data) {
				if (is_serialized($data->meta_value)) {
					$meta_data = unserialize($data->meta_value);
				} else {
					$meta_data = $data->meta_value;
				}

				if (is_array($meta_data)) {
					foreach ($meta_data as $key => $field) {
						if (isset($field['title']) && isset($field['data_name'])) {
							$pro_meta_fields[$field['title']] = $field['data_name'];
						} else {
						}
					}
				} else {
					$pro_meta_fields[$data->meta_key] = $meta_data;
				}
			}
		}


		$order_items = wc_get_order($order_id)->get_items();

		foreach ($order_items as $item_id => $item) {
			$item_meta = wc_get_order_item_meta($item_id, '', false);

			foreach ($item_meta as $meta_key => $meta_value) {
				if (array_key_exists($meta_key, $pro_meta_fields)) {
					if (is_array($meta_value) && isset($meta_value[0])) {
						self::$export_instance->data[$order_id][$meta_key] = $meta_value[0];
					} else {
					}
				}
			}
		}
	}
	public function getWCPAData($order_id, $product_ids)
	{
		global $wpdb;

		// Fetch all WCPA field setups from the `wp_woocommerce_order_itemmeta` table
		$table_name = $wpdb->prefix . 'woocommerce_order_itemmeta';

		// Fetching metadata for the given order items
		$wcpa_data = $wpdb->get_results($wpdb->prepare(
			"SELECT * FROM $table_name WHERE order_item_id IN (SELECT order_item_id FROM {$wpdb->prefix}woocommerce_order_items WHERE order_id = %d)",
			$order_id
		));

		$pro_meta_fields = [];

		if (!empty($wcpa_data)) {
			foreach ($wcpa_data as $data) {
				// Check if the meta_value is serialized, then unserialize it
				if (is_serialized($data->meta_value)) {
					$meta_data = unserialize($data->meta_value);
				} else {
					$meta_data = $data->meta_value;
				}

				// Check if the meta_data is an array
				if (is_array($meta_data)) {
					foreach ($meta_data as $key => $field) {
						if (isset($field['title']) && isset($field['data_name'])) {
							// Adjusting keys to match export requirements
							$pro_meta_fields[$field['label']] = $field['value']; // Use label and value instead of title and data_name
						}
					}
				} else {
					// If it's not an array, directly assign the meta_key to the fields
					$pro_meta_fields[$data->meta_key] = $meta_data;
				}
			}
		}

		// Fetching all order items for the given order_id
		$order_items = wc_get_order($order_id)->get_items();

		foreach ($order_items as $item_id => $item) {
			// Get item metadata for each order item
			$item_meta = wc_get_order_item_meta($item_id, '', false);

			// Loop through the item meta and check if the meta_key exists in the pro_meta_fields
			foreach ($item_meta as $meta_key => $meta_value) {
				if (array_key_exists($meta_key, $pro_meta_fields)) {
					// Adjusting keys to match export requirements
					if (is_array($meta_value) && isset($meta_value[0])) {
						self::$export_instance->data[$order_id][str_replace(' ', '-', strtolower($meta_key))] = $meta_value[0]; // Convert key format
					}
				}
			}
		}
	}
	public function getFPFData($order_id, $product_ids)
	{
		global $wpdb;

		// Fetch all FPF field setups from the `wp_woocommerce_order_itemmeta` table
		$table_name = $wpdb->prefix . 'woocommerce_order_itemmeta';

		// Fetching metadata for the given order items related to the order_id
		$fpf_data = $wpdb->get_results($wpdb->prepare(
			"SELECT * FROM $table_name WHERE order_item_id IN (SELECT order_item_id FROM {$wpdb->prefix}woocommerce_order_items WHERE order_id = %d)",
			$order_id
		));

		$fpf_meta_fields = [];

		if (!empty($fpf_data)) {
			foreach ($fpf_data as $data) {
				// Check if the meta_value is serialized, then unserialize it
				if (is_serialized($data->meta_value)) {
					$meta_data = unserialize($data->meta_value);
				} else {
					$meta_data = $data->meta_value;
				}

				// Check if the meta_data is an array
				if (is_array($meta_data)) {
					foreach ($meta_data as $key => $field) {
						if (isset($field['name']) && isset($field['value'])) {
							// Adjusting keys to match export requirements for FPF
							$fpf_meta_fields[$field['name']] = $field['value'];
						}
					}
				} else {
					// If it's not an array, directly assign the meta_key to the fields
					$fpf_meta_fields[$data->meta_key] = $meta_data;
				}
			}
		}

		// Fetching all order items for the given order_id
		$order_items = wc_get_order($order_id)->get_items();

		foreach ($order_items as $item_id => $item) {
			// Get item metadata for each order item
			$item_meta = wc_get_order_item_meta($item_id, '', false);

			// Loop through the item meta and check if the meta_key exists in the fpf_meta_fields
			foreach ($item_meta as $meta_key => $meta_value) {
				if (array_key_exists($meta_key, $fpf_meta_fields)) {
					// Adjusting keys to match export requirements
					if (is_array($meta_value) && isset($meta_value[0])) {
						self::$export_instance->data[$order_id][str_replace(' ', '-', strtolower($meta_key))] = $meta_value[0]; // Convert key format
					}
				}
			}
		}
	}

	/**
	 * Code for Woocommerce Refund and Coupons export
	 * @param $id
	 * @param $type
	 * @param $optionalType
	 */
	public function getWooComCustomerUser($id, $type, $optionalType)
	{
		// global $wpdb;
		// $parent = WooCommerceExport::$export_instance->data[$id]['post_parent'];
		// $query = $wpdb->prepare("SELECT post_id,meta_key,meta_value FROM {$wpdb->prefix}postmeta where post_id = %d", $parent);
		// $result = $wpdb->get_results($query);
		// if(!empty($result)){
		// 	foreach ($result as $key => $value) {
		// 		if($value->meta_key == '_customer_user'){
		// 			$cus_user = $value->meta_value;
		// 		}
		// 	}
		// }
		// WooCommerceExport::$export_instance->data[$id]['customer_user'] = $cus_user;
		global $wpdb;

		$parent = WooCommerceExport::$export_instance->data[$id]['post_parent'];

		$query = $wpdb->prepare("SELECT post_id,meta_key,meta_value FROM {$wpdb->prefix}postmeta where post_id = %d", $parent);
		$result = $wpdb->get_results($query);
		if (!empty($result)) {
			foreach ($result as $key => $value) {
				if ($value->meta_key == '_customer_user') {
					$cus_user = $value->meta_value;
				}
				WooCommerceExport::$export_instance->data[$id][$value->meta_key] = $value->meta_value;
			}
		}
		WooCommerceExport::$export_instance->data[$id]['customer_user'] = $cus_user;
		$query1 = $wpdb->prepare("SELECT meta_key,meta_value FROM {$wpdb->prefix}postmeta where post_id = %d", $id);
		$result1 = $wpdb->get_results($query1);
		if (!empty($result1)) {
			foreach ($result1 as $key1 => $value1) {
				if ($value1->meta_key == '_refund_amount') {
					WooCommerceExport::$export_instance->data[$id]['refund_amount'] = $value1->meta_value;
				}
			}
		}
	}
	public function getCouponsData($id, $type, $optionalType)
	{
		$coupon_id = $id;
		$c = new \WC_Coupon($coupon_id);
		$DiscountType = $c->get_discount_type();
		$CouponAmount = $c->get_amount();
		$IndividualUse = $c->get_individual_use();
		$ProductIDs = $c->get_product_ids();
		$ExcludeProductIDs = $c->get_excluded_product_ids();
		$UsageLimit = $c->get_usage_limit();
		$UsageLimitPerUser = $c->get_usage_limit_per_user();
		$LimitUsageToXItems = $c->get_limit_usage_to_x_items();
		$ExpiryDate = $c->get_date_expires();
		$FreeShipping = $c->get_free_shipping();
		$ExcludeSaleItems = $c->get_exclude_sale_items();
		$MinimumAmount = $c->get_minimum_amount();
		$MaximumAmount = $c->get_maximum_amount();
		$CustomerEmail = $c->get_email_restrictions();
		$ExcludedProductCategories = $c->get_excluded_product_categories();
		$ProductCategories = $c->get_product_categories();

		$product_Ids = array();
		$Exclude_Product_IDs = array();
		$product_cat = array();
		$exclude_cat = array();
		$cus_email =  array();
		foreach ($ProductCategories as $p_IDs) {
			$product_cat[] = $p_IDs;
		}
		foreach ($ExcludedProductCategories as $p_IDs) {
			$exclude_cat[] = $p_IDs;
		}

		foreach ($CustomerEmail as $p_IDs) {
			$cus_email[] = $p_IDs;
		}

		foreach ($ProductIDs as $p_IDs) {
			$product_Ids[] = $p_IDs;
		}
		foreach ($ExcludeProductIDs as $Exclude_PIds) {
			$Exclude_Product_IDs[] = $Exclude_PIds;
		}


		WooCommerceExport::$export_instance->data[$id]['coupon_code'] = $c->get_code();
		WooCommerceExport::$export_instance->data[$id]['description'] = $c->get_description();
		WooCommerceExport::$export_instance->data[$id]['coupon_date'] = $c->get_date_created()? $c->get_date_created()->date('Y-m-d'):'';
		WooCommerceExport::$export_instance->data[$id]['coupon_status'] = get_post_status($coupon_id);
		WooCommerceExport::$export_instance->data[$id]['COUPONID'] = $coupon_id;

		WooCommerceExport::$export_instance->data[$id]['exclude_product_categories'] = !empty($exclude_cat) ? implode(',', $exclude_cat) : '';
		WooCommerceExport::$export_instance->data[$id]['customer_email'] = !empty($cus_email) ? implode(',', $cus_email) : '';
		WooCommerceExport::$export_instance->data[$id]['product_categories'] = !empty($product_cat) ? implode(',', $product_cat) : '';
		WooCommerceExport::$export_instance->data[$id]['discount_type'] = $DiscountType;
		WooCommerceExport::$export_instance->data[$id]['coupon_amount'] = $CouponAmount;
		WooCommerceExport::$export_instance->data[$id]['individual_use'] = $IndividualUse ? 'yes' : 'no';
		WooCommerceExport::$export_instance->data[$id]['usage_limit'] = $UsageLimit;
		WooCommerceExport::$export_instance->data[$id]['usage_limit_per_user'] = $UsageLimitPerUser;
		WooCommerceExport::$export_instance->data[$id]['limit_usage_to_x_items'] = $LimitUsageToXItems;
		WooCommerceExport::$export_instance->data[$id]['expiry_date'] = $ExpiryDate ? $ExpiryDate->date('Y-m-d H:i:s') : null;
		WooCommerceExport::$export_instance->data[$id]['free_shipping'] = $FreeShipping ? 'yes' : 'no';
		WooCommerceExport::$export_instance->data[$id]['exclude_sale_items'] = $ExcludeSaleItems ? 'yes' : 'no';
		WooCommerceExport::$export_instance->data[$id]['minimum_amount'] = $MinimumAmount;
		WooCommerceExport::$export_instance->data[$id]['maximum_amount'] = $MaximumAmount;
		// Handle the product IDs and excluded product IDs with implode only if they are not empty
		WooCommerceExport::$export_instance->data[$id]['product_ids'] = !empty($product_Ids) ? implode(',', $product_Ids) : '';
		WooCommerceExport::$export_instance->data[$id]['exclude_product_ids'] = !empty($Exclude_Product_IDs) ? implode(',', $Exclude_Product_IDs) : '';
	}

	/**
	 * Export woocommerce product and variation
	 * @param $id
	 * @param $type
	 * @param $optionalType
	 */
	public function getVariationData($id, $type, $optionalType)
	{
		global $wpdb;
		$variations_data = wc_get_product($id);
		$variation_datas = $variations_data->get_data();
		$variations[] = wc_get_product($id);
		foreach ($variations as $attr_key => $variation) {
			$parent_id = $variation->get_parent_id();
			$parent_product = wc_get_product($parent_id);
			$parent_sku = $parent_product->get_sku();
			$variation_sku = $variation->get_sku();
			$variation_id = $variation->get_id();
			$featured_image_id = $variation->get_image_id();
			$featured_image_url = wp_get_attachment_image_url($featured_image_id, 'full');
			$product_attributes = $parent_product->get_attributes();
			$attribute_name = $att_values = [];
			foreach ($product_attributes as $attribute_key => $attribute) {
				$attr_name = str_replace('pa_', '', $attribute['name']);
				$taxonomy_name = $attribute['taxonomy'];
				$attribute_options = $attribute['options'];
				$term_names = [];
				$swatch_values = [];

				foreach ($attribute_options as $term_id) {
					$term = get_term_by('id', $term_id, $taxonomy_name);

					if (!empty($term->name)) {
						$term_names[] = $term->name;

						// Retrieve swatch type and value if available
						if (is_plugin_active('woo-variation-swatches/woo-variation-swatches.php') || is_plugin_active('woo-variation-swatches-pro/woo-variation-swatches.php')) {
							$term_meta = $wpdb->get_results("SELECT meta_key,meta_value FROM {$wpdb->termmeta} WHERE term_id = $term->term_id ", ARRAY_A);
							$attri_type = $wpdb->get_results("SELECT attribute_type FROM {$wpdb->prefix}woocommerce_attribute_taxonomies where attribute_label = '$attr_name' ", ARRAY_A);
							$attri_type = !empty($attri_type[0]['attribute_type']) ? $attri_type[0]['attribute_type'] : '';
							$term_meta = end($term_meta);
							$swatch_value = '';
							$swatch_types = [
								'product_attribute_color' => 'color',
								'product_attribute_image' => 'image',
								'product_attribute_button' => 'button',
								'product_attribute_radio' => 'radio'
							];

							if (!empty($term_meta) && array_key_exists($term_meta['meta_key'], $swatch_types)) {
								$swatch_type = $swatch_types[$term_meta['meta_key']];
								$swatch_value = $term_meta['meta_value'];
							} else {
								$swatch_type = '';
								$swatch_value = '';
							}
							$swatch_values[] = !empty($swatch_value) ? $term->name . '->' . $swatch_value : '';
						}
					}
				}

				if (is_array($swatch_values) && array_filter($swatch_values)) {
					$attribute_name[] = $attr_name . '->' . $swatch_type;
					$att_values[] = implode('|', $swatch_values);
				} else {
					if (!empty($attri_type) && !empty($term_names) && !empty($swatch_type)) {
						$attribute_name[] = $attr_name . '->' . $attri_type;
						$att_values[] = implode('|', $term_names);
					} else if (!empty($term_names)) {
						$attr_name = $wpdb->get_var("SELECT attribute_label FROM {$wpdb->prefix}woocommerce_attribute_taxonomies WHERE attribute_name='$attr_name'");
						$attribute_name[] = $attr_name;
						$att_values[] = implode('|', $term_names);
					}
				}
				$is_visible[] = $attribute['is_visible'];
				$is_variation[] = $attribute['is_variation'];
				$position[] = $attribute['position'];
			}
			$attachment_meta = wp_get_attachment_metadata($featured_image_id);
			$product_caption = isset($attachment_meta['image_meta']['caption']) ? $attachment_meta['image_meta']['caption'] : '';
			$product_alt_text = get_post_meta($featured_image_id, '_wp_attachment_image_alt', true);
			$product_description = get_post_field('post_content', $featured_image_id);

			$product_title = $parent_product->get_title();
			$is_featured = get_post_meta($parent_product->get_id(), 'featured', true) ? '1' : '0';
			$downloadable = $variation->is_downloadable() ? 'yes' : 'no';
			if ($variation->is_downloadable()) {
				$download_limit = $variation->get_download_limit();
				$download_expiry = $variation->get_download_expiry();
				$downloadable_files = [];
				$download_type = [];
				$downloads = $variation->get_downloads();
				foreach ($downloads as $download) {
					$file_string = $download['name'] . ',' . $download['file'];
					$downloadable_files[] = $file_string;
				}
				$download_file_str = !empty($downloadable_files) ? implode('|', $downloadable_files) : '';
				WooCommerceExport::$export_instance->data[$id]['downloadable_files'] = $download_file_str ?? '';
				WooCommerceExport::$export_instance->data[$id]['download_limit'] = $download_limit ?? '';
				WooCommerceExport::$export_instance->data[$id]['download_expiry'] = $download_expiry ?? '';
			}
			$price  = $variation->get_price();
			$sale_price_dates_from = $variation->get_date_on_sale_from();
			$sale_price_dates_to = $variation->get_date_on_sale_to();
			$regular_price = $variation->get_regular_price();
			$sale_price = $variation->get_sale_price();
			$purchase_note = $variation->get_purchase_note();
			$default_attributes = $parent_product->get_default_attributes();
			$attribute_default = [];
			foreach ($default_attributes as $def_attribute_key => $def_attribute_value) {
				$attribute_default[] = str_replace('pa_', '', $def_attribute_key) . '|' . $def_attribute_value;
			}
			$custom_attributes = $variation->get_attributes();
			$attribute_names = [];
			foreach ($custom_attributes as $cus_attribute_key => $cus_attribute_value) {
				if (strpos($cus_attribute_value, '-') !== false) {
					$cus_attribute_value = str_replace('-', ' ', $cus_attribute_value);
				}
				$cus_attr_key = str_replace('pa_', '', $cus_attribute_key);
				$attr_name = $wpdb->get_var("SELECT attribute_label FROM {$wpdb->prefix}woocommerce_attribute_taxonomies WHERE attribute_name='$cus_attr_key'");
				$term = get_term_by('slug', $cus_attribute_value, $cus_attribute_key);
				$attribute_names[] = $attr_name . '|' . $term->name;
				//$attribute_names[] = str_replace('pa_', '', $cus_attribute_key) . '|' . $cus_attribute_value;
			}
			$tax_status = $variation->get_tax_status();
			$tax_status_mapping = array('taxable' => 1, 'shipping' => 2, 'none' => 3);
			$is_virtual = $variation->is_virtual() ? 'yes' : 'no';
			if (!$variation->is_virtual()) {
				$weight = $variation->get_weight();
				$length = $variation->get_length();
				$width = $variation->get_width();
				$height = $variation->get_height();
			}
			$manages_stock = $variation->managing_stock() ? 'yes' : 'no';
			$stock_status = $variation->get_stock_status();
			$sold_individually = $variation->get_sold_individually();
			if ($variation->managing_stock()) {
				$stock_qty = $variation->get_stock_quantity();
				$low_stock_amount = $variation->get_low_stock_amount();
				$backorders = $variation->get_backorders();
				switch ($backorders) {
					case 'no':
						$backorders_no = '1';
						break;

					case 'notify':
						$backorders_no = '2';
						break;

					case 'yes':
						$backorders_no = '3';
						break;

					default:
						$backorders_no = '';
						break;
				}
			}
			$var_description = $variation->get_description();
			$var_class_id = $variation->get_shipping_class_id();
			$shipping_class_term = get_term($var_class_id, 'product_shipping_class');
		}
		WooCommerceExport::$export_instance->data[$id]['PARENTSKU'] = $parent_sku;
		WooCommerceExport::$export_instance->data[$id]['VARIATIONSKU'] = $variation_sku;
		WooCommerceExport::$export_instance->data[$id]['VARIATIONID'] = $variation_id;
		WooCommerceExport::$export_instance->data[$id]['product_attribute_name'] = !empty($attribute_name) ? implode('|', $attribute_name) : '';
		WooCommerceExport::$export_instance->data[$id]['product_attribute_value'] = !empty($att_values) ? implode(',', $att_values) : '';
		WooCommerceExport::$export_instance->data[$id]['product_attribute_visible'] = !empty($is_visible) ? implode('|', $is_visible) : '';
		WooCommerceExport::$export_instance->data[$id]['product_attribute_variation'] = !empty($is_variation) ? implode('|', $is_variation) : '';
		WooCommerceExport::$export_instance->data[$id]['product_attribute_position'] = !empty($position) ? implode('|', $position) : '';

		WooCommerceExport::$export_instance->data[$id]['product_caption'] = $product_caption ?? '';
		WooCommerceExport::$export_instance->data[$id]['product_alt_text'] = $product_alt_text ?? '';
		WooCommerceExport::$export_instance->data[$id]['product_description'] = $product_description ?? '';

		WooCommerceExport::$export_instance->data[$id]['product_title'] = $product_title ?? '';
		WooCommerceExport::$export_instance->data[$id]['featured'] = $is_featured ?? '';

		WooCommerceExport::$export_instance->data[$id]['price'] = $price ?? '';
		WooCommerceExport::$export_instance->data[$id]['sale_price_dates_from'] = $sale_price_dates_from ? $sale_price_dates_from->date('Y-m-d H:i:s') : null;
		WooCommerceExport::$export_instance->data[$id]['sale_price_dates_to'] = $sale_price_dates_to ? $sale_price_dates_to->date('Y-m-d H:i:s') : null;
		WooCommerceExport::$export_instance->data[$id]['regular_price'] = $regular_price ?? '';
		WooCommerceExport::$export_instance->data[$id]['sale_price'] = $sale_price ?? '';
		WooCommerceExport::$export_instance->data[$id]['purchase_note'] = $purchase_note ?? '';

		WooCommerceExport::$export_instance->data[$id]['default_attributes'] = !empty($attribute_default) ? implode(',', $attribute_default) : '';
		WooCommerceExport::$export_instance->data[$id]['custom_attributes'] = !empty($attribute_names) ? implode(',', $attribute_names) : '';
		WooCommerceExport::$export_instance->data[$id]['_downloadable'] = $downloadable ?? '';

		WooCommerceExport::$export_instance->data[$id]['tax_class'] = $variation_datas['tax_class'] ?? '';
		WooCommerceExport::$export_instance->data[$id]['tax_status'] = array_key_exists($tax_status, $tax_status_mapping) ? $tax_status_mapping[$tax_status] : '';

		WooCommerceExport::$export_instance->data[$id]['weight'] = $weight ?? '';
		WooCommerceExport::$export_instance->data[$id]['length'] = $length ?? '';
		WooCommerceExport::$export_instance->data[$id]['width'] = $width ?? '';
		WooCommerceExport::$export_instance->data[$id]['height'] = $height ?? '';

		WooCommerceExport::$export_instance->data[$id]['virtual'] = $is_virtual ?? '';

		WooCommerceExport::$export_instance->data[$id]['manage_stock'] = $manages_stock ?? '';
		WooCommerceExport::$export_instance->data[$id]['_stock'] = $stock_qty ?? '';
		WooCommerceExport::$export_instance->data[$id]['_stock_status'] = $stock_status ?? '';
		WooCommerceExport::$export_instance->data[$id]['_low_stock_threshold'] = $low_stock_amount ?? '';
		WooCommerceExport::$export_instance->data[$id]['backorders'] = $backorders_no ?? '';
		WooCommerceExport::$export_instance->data[$id]['sold_individually'] = ($sold_individually > 0) ? 'yes' : 'no';
		WooCommerceExport::$export_instance->data[$id]['_thumbnail_id'] = $featured_image_url ?? '';

		WooCommerceExport::$export_instance->data[$id]['variation_description'] = $var_description ?? '';
		WooCommerceExport::$export_instance->data[$id]['variation_shipping_class'] = !is_wp_error($shipping_class_term) && $shipping_class_term ? $shipping_class_term->name : '';
	}
	public function getProductData($id, $type, $optionalType)
	{
		global $wpdb;
		$product = wc_get_product($id);
		WooCommerceExport::$export_instance->data[$id]['default_attributes'] = '';

		if (!empty($product)) {
			$booking_type = '';
			$product_type = $product->get_type();
			if ($product_type == 'variation') {
				$parent_id = $product->get_parent_id();
				$parent_product = wc_get_product($parent_id);
				$post_content = $parent_product->get_description();
				WooCommerceExport::$export_instance->data[$id]['post_content'] = $post_content ?? '';
				$parent_sku = $parent_product->get_sku();
				WooCommerceExport::$export_instance->data[$id]['parent'] = $parent_sku;
			}
			$product_datas = $product->get_data();
			$product_sku = $product->get_sku();
			WooCommerceExport::$export_instance->data[$id]['PRODUCTSKU'] = $product_sku ?? '';
			$product_attributes = $product->get_attributes();
			if ($product_type !== 'variation') {
				if (!empty($product_attributes)) {
					$count = count($product_attributes);
					$new_attr_array = array();
					foreach ($product_attributes as $attribute_key => $attribute) {
						$new_attr_array[] = $attribute;
					}
					if (is_plugin_active('jet-booking/jet-booking.php')) {
						$booking_type = trim(jet_abaf()->settings->get('apartment_post_type'));
						$jet_abaf_service_costs = '';
						$jet_abaf_service_cost_formats = '';
						$jet_abaf_guests_multipliers = '';
						$jet_abaf_everyday_services = '';
						$jet_abaf_service_coststing = '';
					}
					array_unshift($new_attr_array, "");
					unset($new_attr_array[0]);
					$att_values = [];
					$stored_id = [];
					if (!empty($new_attr_array)) {
						foreach ($new_attr_array as $attribute_key => $attribute) {
							if (is_a($attribute, 'WC_Product_Attribute')) {
								if (strpos($attribute['name'], 'pa_') !== false) {
									$attr_name = str_replace('pa_', '', $attribute['name']);
									$attr_name = $wpdb->get_var("SELECT attribute_label FROM {$wpdb->prefix}woocommerce_attribute_taxonomies WHERE attribute_name='$attr_name'");
								} else {
									$attr_name = $attribute['name'];
								}
								$swatch_values = [];

								WooCommerceExport::$export_instance->data[$id]['product_attribute_name' . $attribute_key] = $attr_name;


								$taxonomy_name = $attribute['taxonomy'];
								$attribute_options = $attribute['options'];
								$term_names = $att_values = array();
								foreach ($attribute_options as $term_key => $term_id) {
									if (is_numeric($term_id)) {
										$term = get_term_by('id', $term_id, $taxonomy_name);
										if (!empty($term->name)) {
											$term_names[] = $term->name;
											// Retrieve swatch type and value if available
											if (is_plugin_active('woo-variation-swatches/woo-variation-swatches.php') || is_plugin_active('woo-variation-swatches-pro/woo-variation-swatches.php')) {
												$term_meta = $wpdb->get_results("SELECT meta_key,meta_value FROM {$wpdb->termmeta} WHERE term_id = $term->term_id ", ARRAY_A);
												$attri_type = $wpdb->get_results("SELECT attribute_type FROM {$wpdb->prefix}woocommerce_attribute_taxonomies where attribute_label = '$attr_name' ", ARRAY_A);
												$attri_type = !empty($attri_type[0]['attribute_type']) ? $attri_type[0]['attribute_type'] : '';
												$term_meta = end($term_meta);
												$swatch_value = '';
												$swatch_types = [
													'product_attribute_color' => 'color',
													'product_attribute_image' => 'image',
													'product_attribute_button' => 'button',
													'product_attribute_radio' => 'radio'
												];

												if (!empty($term_meta) && array_key_exists($term_meta['meta_key'], $swatch_types)) {
													$swatch_type = $swatch_types[$term_meta['meta_key']];
													$swatch_value = $term_meta['meta_value'];
												} else {
													$swatch_type = '';
													$swatch_value = '';
												}
												$swatch_values[] = !empty($swatch_value) ? $term->name . '->' . $swatch_value : '';
											}
											if (is_plugin_active('jet-booking/jet-booking.php') &&  'product' == $booking_type) {

												$term_meta = $wpdb->get_results("SELECT meta_key,meta_value FROM {$wpdb->termmeta} WHERE term_id = $term->term_id ", ARRAY_A);
												if (!empty($term_meta)) {
													foreach ($term_meta as $meta) {
														switch ($meta['meta_key']) {
															case 'jet_abaf_service_cost':
																$jet_abaf_service_cost[] = $meta['meta_value'];
																break;

															case 'jet_abaf_service_cost_format':
																$jet_abaf_service_cost_format[] = $meta['meta_value'];
																break;

															case 'jet_abaf_guests_multiplier':
																$jet_abaf_guests_multiplier[] = $meta['meta_value'];
																break;

															case 'jet_abaf_everyday_service':
																$jet_abaf_everyday_service[] = $meta['meta_value'];
																break;
														}
													}
												}
											}
										}
									} else {
										$term_names[] = $term_id;
									}
								}
								if ($booking_type == 'product') {
									$jet_abaf_service_costs .=  !empty($jet_abaf_service_cost)  ? implode('|', $jet_abaf_service_cost) . ',' : '';
									$jet_abaf_service_cost_formats .=  !empty($jet_abaf_service_cost_format)  ? implode('|', $jet_abaf_service_cost_format) . ',' : '';
									$jet_abaf_guests_multipliers .=  !empty($jet_abaf_guests_multiplier)  ? implode('|', $jet_abaf_guests_multiplier) . ',' : '';
									$jet_abaf_everyday_services .=  !empty($jet_abaf_everyday_service)  ? implode('|', $jet_abaf_everyday_service) . ',' : '';

									$jet_abaf_service_cost = $jet_abaf_service_cost_format = $jet_abaf_guests_multiplier = $jet_abaf_everyday_service = [];
								}


								if (is_array($swatch_values) && array_filter($swatch_values)) {
									$attribute_name = $attr_name . '->' . $swatch_type;
									$att_values = implode(',', $swatch_values);
								} else {
									if (!empty($attri_type) && !empty($term_names) && !empty($swatch_type)) {
										$attribute_name = $attr_name . '->' . $attri_type;
										$att_values = implode(',', $term_names);
									} else if (!empty($term_names)) {
										$attr_name = $wpdb->get_var("SELECT attribute_label FROM {$wpdb->prefix}woocommerce_attribute_taxonomies WHERE attribute_name='$attr_name'");
										$attribute_name = $attr_name;
										$att_values = implode(',', $term_names);
									}
								}
								if (is_plugin_active('woo-variation-swatches/woo-variation-swatches.php') || is_plugin_active('woo-variation-swatches-pro/woo-variation-swatches.php')) {
									if(!empty($attribute_name)){
										WooCommerceExport::$export_instance->data[$id]['product_attribute_name' . $attribute_key] = $attribute_name;
									}
									WooCommerceExport::$export_instance->data[$id]['product_attribute_value' . $attribute_key]  = $att_values;
								}else{
									$att_values = implode(',', $term_names);
									WooCommerceExport::$export_instance->data[$id]['product_attribute_value' . $attribute_key]  = $att_values;
								}
								// if (!empty($term_names)) {
								// 	$att_values = implode(',', $term_names);
								// }


								WooCommerceExport::$export_instance->data[$id]['product_attribute_visible' . $attribute_key] = $attribute['is_visible'];
								$is_variation[] = $attribute['is_variation'];
								$position[] = $attribute['position'];
								$is_taxonomy[] = $attribute['is_taxonomy'];
							}
						}
					}
					WooCommerceExport::$export_instance->data[$id]['jet_abaf_service_cost'] = !empty($jet_abaf_service_costs) ? rtrim($jet_abaf_service_costs, ',') : '';
					WooCommerceExport::$export_instance->data[$id]['jet_abaf_service_cost_format'] = !empty($jet_abaf_service_cost_formats) ?  rtrim($jet_abaf_service_cost_formats, ',') : '';
					WooCommerceExport::$export_instance->data[$id]['jet_abaf_guests_multiplier'] = !empty($jet_abaf_guests_multipliers) ?  rtrim($jet_abaf_guests_multipliers, ',') : '';
					WooCommerceExport::$export_instance->data[$id]['jet_abaf_everyday_service'] = !empty($jet_abaf_everyday_services) ?  rtrim($jet_abaf_everyday_services, ',') : '';
				}
			} else {
				$default_attributes = $parent_product->get_default_attributes();
				$attribute_default = [];
				foreach ($default_attributes as $def_attribute_key => $def_attribute_value) {
					$def_attribute_label = wc_attribute_label($def_attribute_key); // Get the label of the attribute
					$defattribute_value = get_term_by('slug',$def_attribute_value,$def_attribute_key);
					if(isset($defattribute_value->name)){
						$attribute_default[] = $def_attribute_label . '|' . $defattribute_value->name;
					}
				}
				WooCommerceExport::$export_instance->data[$id]['default_attributes'] = !empty($attribute_default) ? implode(',', $attribute_default) : '';
				if (!empty($product_attributes)) {
					$i = 1;
					foreach ($product_attributes as $attribute_key => $attribute) {
						$attr_name = str_replace('pa_', '', $attribute_key);
						$attr_name = $wpdb->get_var("SELECT attribute_label FROM {$wpdb->prefix}woocommerce_attribute_taxonomies WHERE attribute_name='$attr_name'");
						$attr_value = $wpdb->get_var("SELECT name FROM {$wpdb->prefix}terms WHERE slug = '$attribute'");
						WooCommerceExport::$export_instance->data[$id]['product_attribute_name' . $i] = $attr_name;
						WooCommerceExport::$export_instance->data[$id]['product_attribute_value' . $i] = $attr_value;
						$i++;
					}
				}
			}


			$get_catalog_visibility = $product->get_catalog_visibility();
			$visibility_mapping = array('visible' => '1', 'catalog' => '2', 'search'  => '3', 'hidden'  => '4');
			WooCommerceExport::$export_instance->data[$id]['visibility'] = array_key_exists($get_catalog_visibility, $visibility_mapping) ? $visibility_mapping[$get_catalog_visibility] : '';

			$tax_status = $product->get_tax_status();
			$tax_status_mapping = array('taxable' => 1, 'shipping' => 2, 'none' => 3);
			WooCommerceExport::$export_instance->data[$id]['tax_status'] = array_key_exists($tax_status, $tax_status_mapping) ? $tax_status_mapping[$tax_status] : '';

			$product_type = $product->get_type();
			$product_type_mapping = array('simple' => 1, 'grouped' => 2, 'external' => 3, 'variable' => 4, 'subscription' => 5, 'variable-subscription' => 6, 'bundle' => 7, 'variation' => '8', 'jet_booking' => 9);
			WooCommerceExport::$export_instance->data[$id]['product_type'] = array_key_exists($product_type, $product_type_mapping) ? $product_type_mapping[$product_type] : '';

			if (has_term('featured', 'product_visibility', $id)) {
				WooCommerceExport::$export_instance->data[$id]['featured_product'] = '1';
			}
			WooCommerceExport::$export_instance->data[$id]['tax_class'] = $product_datas['tax_class'] ?? '';
			if (method_exists($product, 'get_file_paths')) {
				$file_paths = $product->get_file_paths();
				WooCommerceExport::$export_instance->data[$id]['_file_paths'] = isset($file_paths) ? $file_paths : '';
			} else {
				WooCommerceExport::$export_instance->data[$id]['_file_paths'] = '';
			}
			$edit_last = get_post_meta($id, '_edit_last', true);
			WooCommerceExport::$export_instance->data[$id]['_edit_last'] = $edit_last ?? '';
			$edit_lock = get_post_meta($id, '_edit_lock', true);
			WooCommerceExport::$export_instance->data[$id]['_edit_lock'] = $edit_lock ?? '';
			$thumbnail_id = get_post_thumbnail_id($product->get_id());
			$attachment_url = wp_get_attachment_url($thumbnail_id);
			WooCommerceExport::$export_instance->data[$id]['_thumbnail_id'] = $attachment_url ?? '';
			WooCommerceExport::$export_instance->data[$id]['manage_stock'] = $product->get_manage_stock() ? '1' : '';
			$stock_quantity = $product->get_stock_quantity();
			$stock_status = $product->get_stock_status();
			$low_stock_threshold = $product->get_low_stock_amount();
			$total_sales = $product->get_total_sales();
			WooCommerceExport::$export_instance->data[$id]['_stock'] = $stock_quantity ?? '';
			WooCommerceExport::$export_instance->data[$id]['_stock_status'] = $stock_status ?? '';
			WooCommerceExport::$export_instance->data[$id]['_low_stock_threshold'] = $low_stock_threshold ?? '';
			WooCommerceExport::$export_instance->data[$id]['_total_sales'] = $total_sales ?? '';
			$downloadable = $product->is_downloadable() ? 'yes' : 'no';
			$virtual = $product->is_virtual() ? 'yes' : 'no';
			$regular_price = $product->get_regular_price();
			$sale_price = $product->get_sale_price();
			$purchase_note = $product->get_purchase_note();

			WooCommerceExport::$export_instance->data[$id]['_downloadable'] = $downloadable ?? '';
			WooCommerceExport::$export_instance->data[$id]['_virtual'] = $virtual ?? '';
			WooCommerceExport::$export_instance->data[$id]['_regular_price'] = $regular_price ?? '';
			WooCommerceExport::$export_instance->data[$id]['_sale_price'] = $sale_price ?? '';
			WooCommerceExport::$export_instance->data[$id]['_purchase_note'] = $purchase_note ?? '';

			$weight = $product->get_weight();
			$length = $product->get_length();
			$width = $product->get_width();
			$height = $product->get_height();
			$upsell_ids = $product->get_upsell_ids();
			$upsell_product_names = [];
			foreach ($upsell_ids as $up_id) {
				$upsell_product = wc_get_product($up_id);
				$upsell_product_names[] = $upsell_product ? $upsell_product->get_name() : '';
			}
			$cross_sell_ids = $product->get_cross_sell_ids();
			$cross_sell_product_names = [];
			foreach ($cross_sell_ids as $cross_id) {
				$cross_sell_product = wc_get_product($cross_id);
				$cross_sell_product_names[] = $cross_sell_product ? $cross_sell_product->get_name() : '';
			}
			WooCommerceExport::$export_instance->data[$id]['weight'] = $weight ?? '';
			WooCommerceExport::$export_instance->data[$id]['length'] = $length ?? '';
			WooCommerceExport::$export_instance->data[$id]['width'] = $width ?? '';
			WooCommerceExport::$export_instance->data[$id]['height'] = $height ?? '';
			WooCommerceExport::$export_instance->data[$id]['upsell_ids'] = !empty($upsell_product_names) ? implode(',', $upsell_product_names) : '';
			WooCommerceExport::$export_instance->data[$id]['crosssell_ids'] = !empty($cross_sell_product_names) ? implode(',', $cross_sell_product_names) : '';

			$grouping_product_ids = []; // Initialize an array to store child product IDs
			if ($product->is_type('grouped')) {
				$children = $product->get_children();
				foreach ($children as $child_id) {
					$child = wc_get_product($child_id);
					if (!empty($child)) {
						$grouping_product_ids[] = $child_id;
					}
				}
			}
			$grouping_product_ids_string = !empty($grouping_product_ids) ? implode(',', $grouping_product_ids) : '';
			WooCommerceExport::$export_instance->data[$id]['grouping_product'] = $grouping_product_ids_string;

			$sale_price_dates_from = $product->get_date_on_sale_from();
			$sale_price_dates_to = $product->get_date_on_sale_to();
			$sold_individually = $product->get_sold_individually();
			$backorders = $product->get_backorders();
			switch ($backorders) {
				case 'no':
					$backorders_no = '1';
					break;

				case 'notify':
					$backorders_no = '2';
					break;

				case 'yes':
					$backorders_no = '3';
					break;

				default:
					$backorders_no = '';
					break;
			}
			WooCommerceExport::$export_instance->data[$id]['sale_price_dates_from'] = $sale_price_dates_from ?? '';
			WooCommerceExport::$export_instance->data[$id]['sale_price_dates_to'] = $sale_price_dates_to ?? '';
			WooCommerceExport::$export_instance->data[$id]['sold_individually'] = ($sold_individually > 0) ? 'yes' : 'no';
			WooCommerceExport::$export_instance->data[$id]['backorders'] = $backorders_no;
			// $product_url = ($product->is_type('external')) ? $product->get_product_url() : '';
			$product_url = get_permalink($id);

			$button_text = ($product->is_type('external')) ? $product->single_add_to_cart_text() : '';
			$featured = get_post_meta($product->get_id(), 'featured', true) ? '1' : '0';
			WooCommerceExport::$export_instance->data[$id]['product_url'] = $product_url;
			WooCommerceExport::$export_instance->data[$id]['button_text'] = $button_text;
			WooCommerceExport::$export_instance->data[$id]['featured'] = $featured;
			$downloadable_files = [];
			$download_type = [];
			if (($product->is_type('variable'))) {
				$download_limits = [];
				$download_expiries = [];
				$variations = $product->get_children();
				foreach ($variations as $variation_id) {
					$variation = wc_get_product($variation_id);
					// Check if the variation is downloadable
					if ($variation->is_downloadable()) {
						$downloads = $variation->get_downloads();
						foreach ($downloads as $download) {
							$file_url = $download->get_file(); // Get the file URL
							$file_name = $download->get_name(); // Get the file name
							$file_string = $file_name . ',' . $file_url;
							$downloadable_files[] = $file_string;
							if (strpos($file_url, 'http') === 0) {
								$download_type[] = 'external'; // If URL starts with http, it's an external URL
							} else {
								$download_type[] = 'file'; // Otherwise, it's a file URL
							}
						}
						$download_limit = $variation->get_download_limit(); // Default is -1 for unlimited
						$download_expiry = $variation->get_download_expiry(); // Default is -1 for no expiry
						// Store the values
						$download_limits[] = $download_limit;
						$download_expiries[] = $download_expiry;
					}
					$download_limit = !empty($download_limit) ? implode('|', $download_limits) : '';
					$download_expiry = !empty($download_expiry) ? implode('|', $download_expiries) : '';
					$download_type_str = !empty($download_type) ? implode('|', $download_type) : '';
					$download_file_str = !empty($downloadable_files) ? implode('|', $downloadable_files) : '';
				}
			} else {
				$downloads = $product->get_downloads();
				foreach ($downloads as $download) {
					$file_string = $download['name'] . ',' . $download['file'];
					$downloadable_files[] = $file_string;
					if (strpos($download['file'], 'http') === 0) {
						$download_type[] = 'external'; // If URL starts with http, it's an external URL
					} else {
						$download_type[] = 'file'; // Otherwise, it's a file URL
					}
				}
				$download_type_str = !empty($download_type) ? implode('|', $download_type) : '';
				$download_file_str = !empty($downloadable_files) ? implode('|', $downloadable_files) : '';

				$download_limit = $product->get_download_limit();
				$download_expiry = $product->get_download_expiry();
			}

			WooCommerceExport::$export_instance->data[$id]['downloadable_files'] = $download_file_str;
			WooCommerceExport::$export_instance->data[$id]['download_limit'] = ($download_limit > -1) ? $download_limit : '';
			WooCommerceExport::$export_instance->data[$id]['download_expiry'] = ($download_expiry > -1) ? $download_expiry : '';
			WooCommerceExport::$export_instance->data[$id]['download_type'] = $download_type_str;

			$subscription_period = get_post_meta($id, '_subscription_period', true);
			$subscription_period_interval = get_post_meta($id, '_subscription_period_interval', true);
			$subscription_length = get_post_meta($id, '_subscription_length', true);
			$subscription_trial_period = get_post_meta($id, '_subscription_trial_period', true);
			$subscription_trial_length = get_post_meta($id, '_subscription_trial_length', true);
			$subscription_price = get_post_meta($id, '_subscription_price', true);
			$subscription_sign_up_fee = get_post_meta($id, '_subscription_sign_up_fee', true);

			WooCommerceExport::$export_instance->data[$id]['_subscription_period'] = $subscription_period ?? '';
			WooCommerceExport::$export_instance->data[$id]['_subscription_period_interval'] = $subscription_period_interval ?? '';
			WooCommerceExport::$export_instance->data[$id]['_subscription_length'] = $subscription_length ?? '';
			WooCommerceExport::$export_instance->data[$id]['_subscription_trial_period'] = $subscription_trial_period ?? '';
			WooCommerceExport::$export_instance->data[$id]['_subscription_trial_length'] = $subscription_trial_length ?? '';
			WooCommerceExport::$export_instance->data[$id]['_subscription_price'] = $subscription_price ?? '';
			WooCommerceExport::$export_instance->data[$id]['_subscription_sign_up_fee'] = $subscription_sign_up_fee ?? '';

			if (is_plugin_active('yith-woocommerce-barcodes-premium/init.php')) {
				// Retrieve barcode details
				$barcode_protocol = get_post_meta($id, '_ywbc_barcode_protocol', true);
				$barcode_value = get_post_meta($id, '_ywbc_barcode_value', true);
				$barcode_display_value = get_post_meta($id, '_ywbc_barcode_display_value', true);
				WooCommerceExport::$export_instance->data[$id]['_ywbc_barcode_display_value'] = $barcode_display_value ?? '';
				WooCommerceExport::$export_instance->data[$id]['_ywbc_barcode_value'] = $barcode_value ?? '';
				WooCommerceExport::$export_instance->data[$id]['_ywbc_barcode_protocol'] = $barcode_protocol ?? '';
			}
		}

		if (is_plugin_active('woocommerce-chained-products/woocommerce-chained-products.php')) {
			$chained_product_detail = get_post_meta($id, '_chained_product_detail', true);
			$chained_product_manage_stock = get_post_meta($id, '_chained_product_manage_stock', true);
			$chained_output = [];
			if(!empty($chained_product_detail)){
				foreach ($chained_product_detail as $ids => $details) {
					$chained_output[] = "{$ids}|{$details['unit']}|{$details['priced_individually']}";
				}
				$_chained_product_detail = implode(",", $chained_output);
				WooCommerceExport::$export_instance->data[$id]['chained_product_detail'] = $_chained_product_detail ?? '';
				WooCommerceExport::$export_instance->data[$id]['chained_product_manage_stock'] = $chained_product_manage_stock ?? '';
			}
		}
		if (is_plugin_active('tier-pricing-table/tier-pricing-table.php')) {
			// Retrieve tiered pricing meta data
			$meta_keys = [
				'_tiered_price_rules_type',
				'_fixed_price_rules',
				'_percentage_price_rules',
				'_tiered_price_minimum_qty',
				'_administrator_tiered_price_pricing_type',
				'_administrator_tiered_price_discount',
				'_administrator_tiered_price_regular_price',
				'_administrator_tiered_price_sale_price',
				'_administrator_tiered_price_discount_type',
				'_administrator_tiered_price_rules_type',
				'_administrator_percentage_price_rules',
				'_administrator_fixed_price_rules',
				'_administrator_tiered_price_minimum_qty',
				'_editor_tiered_price_pricing_type',
				'_editor_tiered_price_discount',
				'_editor_tiered_price_regular_price',
				'_editor_tiered_price_sale_price',
				'_editor_tiered_price_discount_type',
				'_editor_tiered_price_rules_type',
				'_editor_percentage_price_rules',
				'_editor_fixed_price_rules',
				'_editor_tiered_price_minimum_qty',
			];

			$meta_data = [];
			foreach ($meta_keys as $key) {
				$meta_data[$key] = get_post_meta($id, $key, true);
			}

			// Initialize formatted arrays and process rules
			$format_rules = function ($rules) {
				$rules = maybe_unserialize($rules);
				if (is_array($rules)) {
					return implode('|', array_map(fn($key, $value) => "{$key}->{$value}", array_keys($rules), $rules));
				}
				return '';
			};

			$formatted_fixed_rules = $format_rules($meta_data['_fixed_price_rules']);
			$formatted_percentage_rules = $format_rules($meta_data['_percentage_price_rules']);
			$formatted_administrator_percentage_rules = $format_rules($meta_data['_administrator_percentage_price_rules']);
			$formatted_editor_percentage_rules = $format_rules($meta_data['_editor_percentage_price_rules']);
			$formatted_administrator_fixed_rules = $format_rules($meta_data['_administrator_fixed_price_rules']);
			$formatted_editor_fixed_rules = $format_rules($meta_data['_editor_fixed_price_rules']);


			WooCommerceExport::$export_instance->data[$id]['_fixed_price_rules'] = $formatted_fixed_rules ?? '';
			WooCommerceExport::$export_instance->data[$id]['_percentage_price_rules'] = $formatted_percentage_rules ?? '';
			WooCommerceExport::$export_instance->data[$id]['_tiered_price_rules_type'] = $meta_data['_tiered_price_rules_type'] ?? '';
			WooCommerceExport::$export_instance->data[$id]['_tiered_price_minimum_qty'] =  $meta_data['_tiered_price_minimum_qty'] ?? '';

			WooCommerceExport::$export_instance->data[$id]['_administrator_tiered_price_pricing_type'] = $meta_data['_administrator_tiered_price_pricing_type'] ?? '';
			WooCommerceExport::$export_instance->data[$id]['_administrator_tiered_price_discount'] = $meta_data['_administrator_tiered_price_discount'] ?? '';
			WooCommerceExport::$export_instance->data[$id]['_administrator_tiered_price_regular_price'] = $meta_data['_administrator_tiered_price_regular_price'] ?? '';
			WooCommerceExport::$export_instance->data[$id]['_administrator_tiered_price_sale_price'] = $meta_data['_administrator_tiered_price_sale_price'] ?? '';
			WooCommerceExport::$export_instance->data[$id]['_administrator_tiered_price_discount_type'] = $meta_data['_administrator_tiered_price_discount_type'] ?? '';
			WooCommerceExport::$export_instance->data[$id]['_administrator_tiered_price_rules_type'] = $meta_data['_administrator_tiered_price_rules_type'] ?? '';
			WooCommerceExport::$export_instance->data[$id]['_administrator_percentage_price_rules'] =  $formatted_administrator_percentage_rules;
			WooCommerceExport::$export_instance->data[$id]['_administrator_fixed_price_rules'] = $formatted_administrator_fixed_rules;
			WooCommerceExport::$export_instance->data[$id]['_administrator_tiered_price_minimum_qty'] = $meta_data['_administrator_tiered_price_minimum_qty'] ?? '';

			WooCommerceExport::$export_instance->data[$id]['_editor_tiered_price_pricing_type'] = $meta_data['_editor_tiered_price_pricing_type'] ?? '';
			WooCommerceExport::$export_instance->data[$id]['_editor_tiered_price_discount'] = $meta_data['_editor_tiered_price_discount'] ?? '';
			WooCommerceExport::$export_instance->data[$id]['_editor_tiered_price_regular_price'] = $meta_data['_editor_tiered_price_regular_price'] ?? '';
			WooCommerceExport::$export_instance->data[$id]['_editor_tiered_price_sale_price'] = $meta_data['_editor_tiered_price_sale_price'] ?? '';
			WooCommerceExport::$export_instance->data[$id]['_editor_tiered_price_discount_type'] = $meta_data['_editor_tiered_price_discount_type'] ?? '';
			WooCommerceExport::$export_instance->data[$id]['_editor_tiered_price_rules_type'] = $meta_data['_editor_tiered_price_rules_type'] ?? '';
			WooCommerceExport::$export_instance->data[$id]['_editor_percentage_price_rules'] =  $formatted_editor_percentage_rules;
			WooCommerceExport::$export_instance->data[$id]['_editor_fixed_price_rules'] = $formatted_editor_fixed_rules;
			WooCommerceExport::$export_instance->data[$id]['_editor_tiered_price_minimum_qty'] = $meta_data['_editor_tiered_price_minimum_qty'] ?? '';
		}

		// //woocommerce-product-bundles plugin
		if (is_plugin_active('woocommerce-product-bundles/woocommerce-product-bundles.php')) {
			// Get the bundle product
			$bundle_product = wc_get_product($id);

			if ($bundle_product && $bundle_product->is_type('bundle')) {
				// Initialize default values
				$bundle_items = array();
				$optional_values = array();
				$quantity_min = array();
				$quantity_max = array();
				$price_values = array();
				$discount_values = array();
				$product_values = array();
				$cart_values = array();
				$order_values = array();
				$product_price_values = array();
				$cart_price_values = array();
				$order_price_values = array();
				$thumb_values = array();
				$override_values = array();
				$description_values = array();
				$override_title_values = array();
				$override_description_values = array();

				// Get bundle settings
				$min_bundle_size = $bundle_product->get_min_bundle_size();
				$max_bundle_size = $bundle_product->get_max_bundle_size();
				$edit_in_cart = $bundle_product->get_editable_in_cart() ? 'Yes' : 'No';
				$layout = $bundle_product->get_layout(); // Assuming this method exists
				$get_mode = $bundle_product->get_group_mode();
				if ($get_mode == 'noindent') {
					$item_grouping = 'flat';
				} else if ($get_mode == 'parent') {
					$item_grouping = 'grouped';
				} else {
					$item_grouping = '';
				}
				foreach ($bundle_product->get_bundled_items() as $bundled_item) {
					// Get bundled item product
					$bundled_product = $bundled_item->get_product();
					$bundle_items[] = $bundled_product->get_name();

					// Retrieve settings for each bundled item
					$optional_values[] = method_exists($bundled_item, 'is_optional') && $bundled_item->is_optional() ? 'Yes' : 'No';
					$quantity_min[] = method_exists($bundled_item, 'get_min_quantity') ? $bundled_item->get_min_quantity() : '';
					$quantity_max[] = method_exists($bundled_item, 'get_max_quantity') ? $bundled_item->get_max_quantity() : '';
					$price_values[] = method_exists($bundled_item, 'is_priced_individually') && $bundled_item->is_priced_individually() ? 'Yes' : 'No';
					$discount_values[] = method_exists($bundled_item, 'get_discount') ? $bundled_item->get_discount() : '';
					$product_values[] = method_exists($bundled_item, 'get_single_product_visibility') && $bundled_item->get_single_product_visibility() ? 'Yes' : 'No';
					$cart_values[] = method_exists($bundled_item, 'get_cart_visibility') && $bundled_item->get_cart_visibility() ? 'Yes' : 'No';
					$order_values[] = method_exists($bundled_item, 'get_order_visibility') && $bundled_item->get_order_visibility() ? 'Yes' : 'No';
					$product_price_values[] = method_exists($bundled_item, 'get_single_product_price_visibility') && $bundled_item->get_single_product_price_visibility() ? 'Yes' : 'No';
					$cart_price_values[] = method_exists($bundled_item, 'get_cart_price_visibility') && $bundled_item->get_cart_price_visibility() ? 'Yes' : 'No';
					$order_price_values[] = method_exists($bundled_item, 'get_order_price_visibility') && $bundled_item->get_order_price_visibility() ? 'Yes' : 'No';
					$thumb_values[] = method_exists($bundled_item, 'get_hide_thumbnail') && $bundled_item->get_hide_thumbnail() ? 'Yes' : 'No';
					$override_values[] = method_exists($bundled_item, 'get_override_title') && $bundled_item->get_override_title() ? 'Yes' : 'No';
					$description_values[] = method_exists($bundled_item, 'get_override_description') && $bundled_item->get_override_description() ? 'Yes' : 'No';
					$override_title_values[] = method_exists($bundled_item, 'get_override_title_value') ? $bundled_item->get_override_title_value() : '';
					$override_description_values[] = method_exists($bundled_item, 'get_override_description_value') ? $bundled_item->get_override_description_value() : '';
				}

				// Prepare export data
				WooCommerceExport::$export_instance->data[$id]['product_bundle_items'] = implode('|', $bundle_items) ?? '';
				WooCommerceExport::$export_instance->data[$id]['optional'] = implode('|', $optional_values) ?? '';
				WooCommerceExport::$export_instance->data[$id]['quantity_min'] = implode('|', $quantity_min) ?? '';
				WooCommerceExport::$export_instance->data[$id]['quantity_max'] = implode('|', $quantity_max) ?? '';
				WooCommerceExport::$export_instance->data[$id]['priced_individually'] = implode('|', $price_values) ?? '';
				WooCommerceExport::$export_instance->data[$id]['discount'] = implode('|', $discount_values) ?? '';
				WooCommerceExport::$export_instance->data[$id]['single_product_visibility'] = implode('|', $product_values) ?? '';
				WooCommerceExport::$export_instance->data[$id]['cart_visibility'] = implode('|', $cart_values) ?? '';
				WooCommerceExport::$export_instance->data[$id]['order_visibility'] = implode('|', $order_values) ?? '';
				WooCommerceExport::$export_instance->data[$id]['single_product_price_visibility'] = implode('|', $product_price_values) ?? '';
				WooCommerceExport::$export_instance->data[$id]['cart_price_visibility'] = implode('|', $cart_price_values) ?? '';
				WooCommerceExport::$export_instance->data[$id]['order_price_visibility'] = implode('|', $order_price_values) ?? '';
				WooCommerceExport::$export_instance->data[$id]['hide_thumbnail'] = implode('|', $thumb_values) ?? '';
				WooCommerceExport::$export_instance->data[$id]['override_title'] = implode('|', $override_values) ?? '';
				WooCommerceExport::$export_instance->data[$id]['override_description'] = implode('|', $description_values) ?? '';
				WooCommerceExport::$export_instance->data[$id]['override_title_value'] = implode('|', $override_title_values) ?? '';
				WooCommerceExport::$export_instance->data[$id]['override_description_value'] = implode('|', $override_description_values) ?? '';
				WooCommerceExport::$export_instance->data[$id]['pb_sale_price'] = $bundle_product->get_sale_price() ?? '';
				WooCommerceExport::$export_instance->data[$id]['pb_regular_price'] = $bundle_product->get_regular_price() ?? '';
				WooCommerceExport::$export_instance->data[$id]['min_bundle_size'] = $min_bundle_size ?? '';
				WooCommerceExport::$export_instance->data[$id]['max_bundle_size'] = $max_bundle_size ?? '';
				WooCommerceExport::$export_instance->data[$id]['edit_in_cart'] = $edit_in_cart ?? '';
				WooCommerceExport::$export_instance->data[$id]['layout'] = $layout ?? '';
				WooCommerceExport::$export_instance->data[$id]['item_grouping'] = $item_grouping ?? '';
			}
		}
	}

	/**
	 * Fetch all Categories
	 * 
	 * @param string $module         The module for which categories are being fetched.
	 * @param string|null $optionalType Optional type filter for categories.
	 * @param bool $is_filter        Indicates if filters are to be applied.
	 * @param array $headers         Headers for the request.
	 * @param string|null $mode      Mode of operation (optional).
	 * @param array|null $eventExclusions Categories or events to exclude (optional).
	 * 
	 * @return array
	 */
	public function FetchTaxonomies($module, $optionalType, $is_filter, $headers, $mode = null, $eventExclusions = null)
	{

		global $wpdb;
		$terms_table = $wpdb->prefix . "terms";
		$terms_taxo_table = $wpdb->prefix . "term_taxonomy";
		$events_meta_table = $wpdb->prefix . "em_meta";
		$taxonomy = $optionalType;
		// $query = $wpdb->prepare("SELECT * FROM $terms_table t INNER JOIN $terms_taxo_table tax ON `tax`.term_id = `t`.term_id WHERE `tax`.taxonomy = %s ", $taxonomy);
		// $get_all_taxonomies =  $wpdb->get_results($query);		
		// self::$export_instance->totalRowCount = count($get_all_taxonomies);
		if ($eventExclusions['is_check'] == 'true') {
			$headers[] = 't.term_id';
			// filtered headers
			$wp_cat_fields_column_value = [
				'name',
				'slug',
				'description',
				'parent',
				't.term_id'
			];
			$filtered_headers = array_intersect($headers, $wp_cat_fields_column_value);
			$selected_columns = implode(', ', $filtered_headers);
		}

		$offset = self::$export_instance->offset;
		$limit = self::$export_instance->limit;

		$query = $wpdb->prepare(
			"SELECT COUNT(*) AS total 
			 FROM {$wpdb->prefix}terms t 
			 INNER JOIN {$wpdb->prefix}term_taxonomy tx 
			 ON t.term_id = tx.term_id 
			 WHERE tx.taxonomy = %s",
			$taxonomy
		);

		self::$export_instance->totalRowCount = (int) $wpdb->get_var($query);


		$query1 = "SELECT term_id FROM {$wpdb->prefix}term_taxonomy where taxonomy='$taxonomy'";
		$offset_limit = "order by term_id asc limit $offset, $limit";
		$query_with_offset_limit = $query1 . $offset_limit;
		$result = $wpdb->get_col($query_with_offset_limit);
		$querynew = array();

		foreach ($result as $res => $re) {
			if (isset($selected_columns) && !empty($selected_columns)) {
				// Use the dynamically selected columns based on $headers
				$querynew[] = $wpdb->get_results(" SELECT $selected_columns FROM {$wpdb->prefix}terms as t join {$wpdb->prefix}term_taxonomy as tx on t.term_id = tx.term_id where t.term_id = '$re'");
			} else {
				$querynew[] = $wpdb->get_results(" SELECT t.name, t.slug, tx.description, tx.parent, t.term_id FROM {$wpdb->prefix}terms as t join {$wpdb->prefix}term_taxonomy as tx on t.term_id = tx.term_id where t.term_id = '$re'");
			}
		}

		$new = array();
		foreach ($querynew as $qkey => $qval) {
			foreach ($qval as $qid) {
				$new[] = $qid;
			}
		}
		if (!empty($new)) {
			foreach ($new as $termKey => $termValue) {
				$termID = $termValue->term_id;
				$termMeta = get_term_meta($termID);
				if (is_plugin_active('wp-e-commerce/wp-shopping-cart.php')) {
					$wpsc_query = $wpdb->prepare("select meta_key,meta_value from {$wpdb->prefix}wpsc_meta where object_id = %d AND object_type = %s", $termID, 'wpsc_category');
					$wpsc_meta = $wpdb->get_results($wpsc_query, ARRAY_A);
					foreach ($wpsc_meta as $mk => $mv) {
						if ($mv['meta_key'] == 'image') {
							if ($mv['meta_value']) {
								$udir = wp_upload_dir();
								$img_path = $udir['baseurl'] . "/wpsc/category_images/" . $mv['meta_value'];
								self::$export_instance->data[$termID]['category_image'] = $img_path;
							} else {
								self::$export_instance->data[$termID]['category_image'] = '';
							}
						} elseif ($mv['meta_key'] == 'display_type') {
							self::$export_instance->data[$termID]['catelog_view'] = $mv['meta_value'];
						} elseif ($mv['meta_key'] == 'uses_billing_address') {
							self::$export_instance->data[$termID]['address_calculate'] = $mv['meta_value'];
						} elseif ($mv['meta_key'] == 'image_width') {
							self::$export_instance->data[$termID]['category_image_width'] = $mv['meta_value'];
						} elseif ($mv['meta_key'] == 'image_height') {
							self::$export_instance->data[$termID]['category_image_height'] = $mv['meta_value'];
						} else {
							self::$export_instance->data[$termID][$mv['meta_key']] = $mv['meta_value'];
						}
					}
				}
				//wpsc_meta data ends
				//woocommerce meta data starts
				if (is_plugin_active('woocommerce/woocommerce.php')) {
					if (isset($termMeta['thumbnail_id'][0])) {
						$thum_id = $termMeta['thumbnail_id'][0];
						self::$export_instance->data[$termID]['image'] = self::$export_instance->getAttachment($thum_id);
						if (isset($thum_id)) {
							$attachment = get_post($thum_id);
							$image_meta = wp_get_attachment_metadata($thum_id);
							$title = get_the_title($thum_id);
							$alt_text = get_post_meta($thum_id, '_wp_attachment_image_alt', true);
							$description = $attachment->post_content;
							$caption = $attachment->post_excerpt;
							$file_name = isset($image_meta['file']) ? basename($image_meta['file']) : '';
							self::$export_instance->data[$termID]['featured_image_title'] = isset($title) ? $title : '';
							self::$export_instance->data[$termID]['featured_image_alt_text'] = isset($alt_text) ? $alt_text : '';
							self::$export_instance->data[$termID]['featured_image_caption'] = isset($caption) ? $caption : '';
							self::$export_instance->data[$termID]['featured_image_description'] = isset($description) ? $description : '';
							self::$export_instance->data[$termID]['featured_file_name'] = isset($file_name) ? $file_name : '';
						}
					}
					if (!empty($termMeta['display_type'][0])) {
						self::$export_instance->data[$termID]['display_type'] = $termMeta['display_type'][0];
					}
					if (!empty($termMeta['cat_meta'][0])) {
						$cat_meta = unserialize($termMeta['cat_meta'][0]);
						self::$export_instance->data[$termID]['top_content'] = $cat_meta['cat_header'];
						self::$export_instance->data[$termID]['bottom_content'] = $cat_meta['cat_footer'];
					}
				}
				//woocommerce meta data ends
				$termName = $termValue->name ?? '';
				$termSlug = $termValue->slug ?? '';
				$termDesc = $termValue->description ?? '';
				$termParent = $termValue->parent ?? '';
				$term_Parent_name = $wpdb->get_var("SELECT name FROM {$wpdb->prefix}terms WHERE term_id = '$termParent'");
				if ($termParent == 0) {
					self::$export_instance->data[$termID]['name'] = $termName;
				} else {

					if ($optionalType == 'product_cat') {
						$termParentName = get_term_by('id', $termParent, 'product_cat');
						$termParentName = $termParentName->name;
					} else {
						$termParentName = get_term($termParent)->name;
					}

					if (empty($termParentName)) {  // term parent does not exists.So remove the parent id
						$termParent = 0;
						self::$export_instance->data[$termID]['name'] = $termName;
					} else {
						self::$export_instance->data[$termID]['name'] = $termParentName . '>' . $termName;
					}
				}
				self::$export_instance->data[$termID]['slug'] = $termSlug;
				self::$export_instance->data[$termID]['description'] = $termDesc;
				self::$export_instance->data[$termID]['TERMID'] = $termID;
				self::$export_instance->data[$termID]['parent'] = $term_Parent_name ? $term_Parent_name : '';
				self::$export_instance->getWPMLData($termID, $optionalType, $module);

				$new = WooCommerceExport::$post_export->getPostsMetaDataBasedOnRecordId($termID, $module, $optionalType);
				if (is_plugin_active('polylang/polylang.php') || is_plugin_active('polylang-pro/polylang.php') || is_plugin_active('polylang-wc/polylang-wc.php')) {
					self::$export_instance->getPolylangData($termID, $optionalType, $module);
				}
				if ($optionalType == 'event-categories') {
					$get_cat_color = $wpdb->get_var("SELECT meta_value FROM $events_meta_table WHERE meta_key = 'category-bgcolor' AND object_id = $termID ");
					$get_cat_image = $wpdb->get_var("SELECT meta_value FROM $events_meta_table WHERE meta_key = 'category-image' AND object_id = $termID ");
					self::$export_instance->data[$termID]['color'] = $get_cat_color;
					self::$export_instance->data[$termID]['image'] = $get_cat_image;
				}
				if ($optionalType == 'event-tags') {
					$get_tag_color = $wpdb->get_var("SELECT meta_value FROM $events_meta_table WHERE meta_key = 'tag-bgcolor' AND object_id = $termID ");
					$get_tag_image = $wpdb->get_var("SELECT meta_value FROM $events_meta_table WHERE meta_key = 'tag-image' AND object_id = $termID ");
					self::$export_instance->data[$termID]['color'] = $get_tag_color;
					self::$export_instance->data[$termID]['image'] = $get_tag_image;
				}
				if (is_plugin_active('wordpress-seo/wp-seo.php')) {
					$seo_yoast_taxonomies = get_option('wpseo_taxonomy_meta');
					if (isset($seo_yoast_taxonomies[$optionalType])) {
						self::$export_instance->data[$termID]['seo_title'] = $termName;

						self::$export_instance->data[$termID]['title'] = $seo_yoast_taxonomies[$optionalType][$termID]['wpseo_title'];
						self::$export_instance->data[$termID]['meta_desc'] = $seo_yoast_taxonomies[$optionalType][$termID]['wpseo_desc'];
						self::$export_instance->data[$termID]['canonical'] = $seo_yoast_taxonomies[$optionalType][$termID]['wpseo_canonical'];
						self::$export_instance->data[$termID]['bctitle'] = $seo_yoast_taxonomies[$optionalType][$termID]['wpseo_bctitle'];
						self::$export_instance->data[$termID]['meta-robots-noindex'] = $seo_yoast_taxonomies[$optionalType][$termID]['wpseo_noindex'];
						//self::$export_instance->data[ $termID ]['sitemap-include'] = $seo_yoast_taxonomies[$optionalType][$termID]['wpseo_sitemap_include'];
						self::$export_instance->data[$termID]['opengraph-title'] = $seo_yoast_taxonomies[$optionalType][$termID]['wpseo_opengraph-title'];
						self::$export_instance->data[$termID]['opengraph-description'] = $seo_yoast_taxonomies[$optionalType][$termID]['wpseo_opengraph-description'];
						self::$export_instance->data[$termID]['opengraph-image'] = $seo_yoast_taxonomies[$optionalType][$termID]['wpseo_opengraph-image'];
						self::$export_instance->data[$termID]['twitter-title'] = $seo_yoast_taxonomies[$optionalType][$termID]['wpseo_twitter-title'];
						self::$export_instance->data[$termID]['twitter-description'] = $seo_yoast_taxonomies[$optionalType][$termID]['wpseo_twitter-description'];
						self::$export_instance->data[$termID]['twitter-image'] = $seo_yoast_taxonomies[$optionalType][$termID]['wpseo_twitter-image'];
						self::$export_instance->data[$termID]['focus_keyword'] = $seo_yoast_taxonomies[$optionalType][$termID]['wpseo_focuskw'];

						if (!empty($seo_yoast_taxonomies[$optionalType][$termID]['wpseo_keywordsynonyms'])) {
							$synonyms = json_decode($seo_yoast_taxonomies[$optionalType][$termID]['wpseo_keywordsynonyms']);
							if (is_array($synonyms)) {
								self::$export_instance->data[$termID]['keywordsynonyms'] = !empty($synonyms) ? implode('|', $synonyms) : '';
							}
						}
						if (!empty($seo_yoast_taxonomies[$optionalType][$termID]['wpseo_focuskeywords'])) {
							$keywords = json_decode($seo_yoast_taxonomies[$optionalType][$termID]['wpseo_focuskeywords']);
							if (is_array($keywords)) {
								$words = array();
								foreach ($keywords as $key_word) {
									$words[] = $key_word->keyword;
								}
								if (!empty($words)) {
									self::$export_instance->data[$termID]['focuskeywords'] = implode('|', $words);
								}
							}
						}
					}
				}
			}
		}

		$result = self::$export_instance->finalDataToExport(self::$export_instance->data, $module, $optionalType);
		if (is_plugin_active('advanced-custom-fields-pro/acf.php')) {
			$result = self::$export_instance->convert_acfname_to_key($result, $optionalType, 'pro', null);
		} elseif ((is_plugin_active('advanced-custom-fields/acf.php')|| is_plugin_active('secure-custom-fields/secure-custom-fields.php')) && is_plugin_active('acf-repeater/acf-repeater.php')) {
			$result = self::$export_instance->convert_acfname_to_key($result, $optionalType, 'free');
		}
		if ($is_filter == 'filter_action') {
			return $result;
		}

		if ($mode == null)
			self::$export_instance->proceedExport($result);
		else
			return $result;
	}

	public function getCourseData($id)
	{
		global $wpdb;

		$get_section_details = $wpdb->get_results("SELECT section_id, section_name, section_description FROM {$wpdb->prefix}learnpress_sections WHERE section_course_id = $id ", ARRAY_A);
		$section_names = '';
		$section_descriptions = '';
		$get_lesson_id = '';
		$get_lesson_name = '';
		$get_lesson_description = '';
		$get_lesson_duration = '';
		$get_lesson_preview = '';
		$get_quiz_id = '';
		$get_quiz_name = '';
		$get_quiz_description = '';
		$get_quiz_meta = [];

		foreach ($get_section_details as $section_details) {
			$section_names .= $section_details['section_name'] . '|';
			$section_descriptions .= $section_details['section_description'] . '|';

			$section_id = $section_details['section_id'];
			$get_section_item_details = $wpdb->get_results("SELECT item_id, item_type FROM {$wpdb->prefix}learnpress_section_items WHERE section_id = $section_id ", ARRAY_A);

			$lesson_id = '';
			$lesson_name = '';
			$lesson_description = '';
			$quiz_id = '';
			$quiz_name = '';
			$quiz_description = '';
			$lesson_duration = '';
			$lesson_preview = '';
			$quiz_metas = [];

			foreach ($get_section_item_details as $section_item_details) {
				$section_item_id = $section_item_details['item_id'];
				if ($section_item_details['item_type'] == 'lp_lesson') {
					$lesson_id .= $section_item_id . ', ';
					$lesson_name .= $wpdb->get_var("SELECT post_title FROM {$wpdb->prefix}posts WHERE ID = $section_item_id ") . ',';
					$lesson_description .= $wpdb->get_var("SELECT post_content FROM {$wpdb->prefix}posts WHERE ID = $section_item_id ") . ',';
					$lesson_duration .= $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $section_item_id AND meta_key = '_lp_duration' ") . ',';
					$lesson_preview .= $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $section_item_id AND meta_key = '_lp_preview' ") . ',';
				} elseif ($section_item_details['item_type'] == 'lp_quiz') {
					$quiz_id .= $section_item_id . ', ';
					$quiz_name .= $wpdb->get_var("SELECT post_title FROM {$wpdb->prefix}posts WHERE ID = $section_item_id ") . ',';
					$quiz_description .= $wpdb->get_var("SELECT post_content FROM {$wpdb->prefix}posts WHERE ID = $section_item_id ") . ',';

					$quiz_meta = $wpdb->get_results("SELECT meta_key, meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $section_item_id AND meta_key LIKE '_lp_%' ", ARRAY_A);
					foreach ($quiz_meta as $quiz_meta_values) {
						$quiz_key = $quiz_meta_values['meta_key'];
						$quiz_value = $quiz_meta_values['meta_value'] . ',';

						if ($quiz_key != '_lp_hidden_questions') {
							if ($quiz_key == '_lp_retake_count') {
								$quiz_key = '_lp_quiz_retake_count';
							}
							$quiz_metas[$quiz_key] = $quiz_value;
						}
					}
				}
			}
			$get_lesson_id .= rtrim($lesson_id, ', ') . '|';
			$get_lesson_name .= rtrim($lesson_name, ',') . '|';
			$get_lesson_description .= rtrim($lesson_description, ',') . '|';
			$get_quiz_id .= rtrim($quiz_id, ', ') . '|';
			$get_quiz_name .= rtrim($quiz_name, ',') . '|';
			$get_quiz_description .= rtrim($quiz_description, ',') . '|';
			$get_lesson_duration .= rtrim($lesson_duration, ',') . '|';
			$get_lesson_preview .= rtrim($lesson_preview, ',') . '|';

			foreach ($quiz_metas as $quiz_meta_keys => $quiz_meta_values) {
				$get_quiz_meta[$quiz_meta_keys] = rtrim($quiz_meta_values, ',') . '|';
			}
		}

		$course_duration = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_duration' ");
		$course_max_students = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_max_students' ");
		$course_students = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_students' ");
		$course_featured = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_featured' ");
		$course_retake = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_retake_count' ");
		$course_passing_condition = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_passing_condition' ");
		$course_external_link_buy_course = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_external_link_buy_course' ");
		$course_result = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_course_result' ");
		$course_price = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_price' ");
		$course_sale_price = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_sale_price' ");
		$course_sale_start = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_sale_start' ");
		$course_sale_end = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_sale_end' ");
		$course_required_enroll = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_required_enroll' ");
		$course_author = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_course_author' ");
		$course_block_expire_duration = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_block_expire_duration' ");
		$course_block_finished = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_block_finished' ");
		$course_allow_course_repurchase = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_allow_course_repurchase' ");
		$course_course_repurchase_option = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_course_repurchase_option' ");
		$course_level = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_level' ");
		$course_has_finish = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_has_finish' ");
		$course_featured_review = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_featured_review' ");
		$course_regular_price = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_regular_price' ");
		$course_no_required_enroll = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_no_required_enroll' ");
		$course_requirements = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_requirements' ");
		$course_target_audiences = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_target_audiences' ");
		$course_key_features = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_key_features' ");


		WooCommerceExport::$export_instance->data[$id]['_lp_duration'] = rtrim($course_duration);
		WooCommerceExport::$export_instance->data[$id]['_lp_max_students'] = rtrim($course_max_students);
		WooCommerceExport::$export_instance->data[$id]['_lp_students'] = rtrim($course_students);
		WooCommerceExport::$export_instance->data[$id]['_lp_featured'] = rtrim($course_featured);
		WooCommerceExport::$export_instance->data[$id]['_lp_external_link_buy_course'] = rtrim($course_external_link_buy_course);
		WooCommerceExport::$export_instance->data[$id]['_lp_course_result'] = rtrim($course_result);
		WooCommerceExport::$export_instance->data[$id]['_lp_price'] = rtrim($course_price);
		WooCommerceExport::$export_instance->data[$id]['_lp_sale_price'] = rtrim($course_sale_price);
		WooCommerceExport::$export_instance->data[$id]['_lp_sale_start'] = rtrim($course_sale_start);
		WooCommerceExport::$export_instance->data[$id]['_lp_sale_end'] = rtrim($course_sale_end);
		WooCommerceExport::$export_instance->data[$id]['_lp_required_enroll'] = rtrim($course_required_enroll);
		WooCommerceExport::$export_instance->data[$id]['_lp_course_author'] = rtrim($course_author);
		WooCommerceExport::$export_instance->data[$id]['_lp_block_expire_duration'] = rtrim($course_block_expire_duration);
		WooCommerceExport::$export_instance->data[$id]['_lp_block_finished'] = rtrim($course_block_finished);
		WooCommerceExport::$export_instance->data[$id]['_lp_allow_course_repurchase'] = rtrim($course_allow_course_repurchase);
		WooCommerceExport::$export_instance->data[$id]['_lp_course_repurchase_option'] = rtrim($course_course_repurchase_option);
		WooCommerceExport::$export_instance->data[$id]['_lp_level'] = rtrim($course_level);
		WooCommerceExport::$export_instance->data[$id]['_lp_has_finish'] = rtrim($course_has_finish);
		WooCommerceExport::$export_instance->data[$id]['_lp_featured_review'] = rtrim($course_featured_review);
		WooCommerceExport::$export_instance->data[$id]['_lp_regular_price'] = rtrim($course_regular_price);
		WooCommerceExport::$export_instance->data[$id]['_lp_no_required_enroll'] = rtrim($course_no_required_enroll);
		WooCommerceExport::$export_instance->data[$id]['_lp_retake_count'] = rtrim($course_retake);
		WooCommerceExport::$export_instance->data[$id]['_lp_passing_condition'] = rtrim($course_passing_condition);
		WooCommerceExport::$export_instance->data[$id]['_lp_requirements'] = rtrim($course_requirements);
		WooCommerceExport::$export_instance->data[$id]['_lp_target_audiences'] = rtrim($course_target_audiences);
		WooCommerceExport::$export_instance->data[$id]['_lp_key_features'] = rtrim($course_key_features);
		WooCommerceExport::$export_instance->data[$id]['curriculum_description'] = rtrim($section_descriptions, '|');
		WooCommerceExport::$export_instance->data[$id]['lesson_id'] = rtrim($get_lesson_id, '|');
		WooCommerceExport::$export_instance->data[$id]['lesson_name'] = rtrim($get_lesson_name, '|');
		WooCommerceExport::$export_instance->data[$id]['lesson_description'] = rtrim($get_lesson_description, '|');
		WooCommerceExport::$export_instance->data[$id]['quiz_id'] = rtrim($get_quiz_id, '|');
		WooCommerceExport::$export_instance->data[$id]['quiz_name'] = rtrim($get_quiz_name, '|');
		WooCommerceExport::$export_instance->data[$id]['quiz_description'] = rtrim($get_quiz_description, '|');
		WooCommerceExport::$export_instance->data[$id]['_lp_lesson_duration'] = rtrim($get_lesson_duration, '|');
		WooCommerceExport::$export_instance->data[$id]['_lp_preview'] = rtrim($get_lesson_preview, '|');
		WooCommerceExport::$export_instance->data[$id]['curriculum_name'] = rtrim($section_names, '|');


		foreach ($get_quiz_meta as $get_quiz_meta_keys => $get_quiz_meta_values) {
			WooCommerceExport::$export_instance->data[$id][$get_quiz_meta_keys] = rtrim($get_quiz_meta_values, '|');
		}
	}

	public function getLessonData($id)
	{
		global $wpdb;
		$lesson_duration = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_duration' ");
		$lesson_preview = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_preview' ");


		$get_section_id = $wpdb->get_var("SELECT section_id FROM {$wpdb->prefix}learnpress_section_items WHERE item_id = $id AND item_type = 'lp_lesson' ");
		if (!empty($get_section_id)) {
			$get_section_name = $wpdb->get_var("SELECT section_name FROM {$wpdb->prefix}learnpress_sections WHERE section_id = $get_section_id ");
			$get_section_course_id = $wpdb->get_var("SELECT section_course_id FROM {$wpdb->prefix}learnpress_sections WHERE section_id = $get_section_id ");
			WooCommerceExport::$export_instance->data[$id]['curriculum_name'] = $get_section_name;
			WooCommerceExport::$export_instance->data[$id]['course_id'] = $get_section_course_id;
		}
		WooCommerceExport::$export_instance->data[$id]['_lp_preview'] = $lesson_preview;
		WooCommerceExport::$export_instance->data[$id]['_lp_lesson_duration'] = $lesson_duration;
	}

	public function getQuizData($id)
	{
		global $wpdb;
		$quiz_retake_count = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_retake_count' ");
		WooCommerceExport::$export_instance->data[$id]['_lp_quiz_retake_count'] = $quiz_retake_count;

		$quiz_duration = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_duration' ");
		$quiz_minus_skip_questions = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_minus_skip_questions' ");
		$quiz_passing_grade = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_passing_grade' ");
		$quiz_instant_check = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_instant_check' ");
		$quiz_negative_marking = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_negative_marking' ");
		$quiz_pagination = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_pagination' ");
		$quiz_show_correct_review = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_show_correct_review' ");
		$quiz_review = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_review' ");
		$quiz_hidden_questions = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_hidden_questions' ");
		$quiz_hidden_questions = unserialize($quiz_hidden_questions);
		$quiz_hidden_questions_string = '';
		foreach ($quiz_hidden_questions as $quiz_hidden_question) {
			$quiz_hidden_questions_string .= $quiz_hidden_question . '|';
		}


		WooCommerceExport::$export_instance->data[$id]['_lp_duration'] = $quiz_duration;
		WooCommerceExport::$export_instance->data[$id]['_lp_minus_skip_questions'] = $quiz_minus_skip_questions;
		WooCommerceExport::$export_instance->data[$id]['_lp_passing_grade'] = $quiz_passing_grade;
		WooCommerceExport::$export_instance->data[$id]['_lp_instant_check'] = $quiz_instant_check;
		WooCommerceExport::$export_instance->data[$id]['_lp_negative_marking'] = $quiz_negative_marking;
		WooCommerceExport::$export_instance->data[$id]['_lp_pagination'] = $quiz_pagination;
		WooCommerceExport::$export_instance->data[$id]['_lp_show_correct_review'] = $quiz_show_correct_review;
		WooCommerceExport::$export_instance->data[$id]['_lp_review'] = $quiz_review;
		$quiz_hidden_questions_string = rtrim($quiz_hidden_questions_string, '|');
		WooCommerceExport::$export_instance->data[$id]['_lp_hidden_questions'] = $quiz_hidden_questions_string;


		$get_section_id = $wpdb->get_var("SELECT section_id FROM {$wpdb->prefix}learnpress_section_items WHERE item_id = $id AND item_type = 'lp_quiz' ");
		if (!empty($get_section_id)) {
			$get_section_name = $wpdb->get_var("SELECT section_name FROM {$wpdb->prefix}learnpress_sections WHERE section_id = $get_section_id ");
			$get_section_course_id = $wpdb->get_var("SELECT section_course_id FROM {$wpdb->prefix}learnpress_sections WHERE section_id = $get_section_id ");

			WooCommerceExport::$export_instance->data[$id]['curriculum_name'] = $get_section_name;
			WooCommerceExport::$export_instance->data[$id]['course_id'] = $get_section_course_id;
		}

		$get_question_id = '';
		$get_question_title = '';
		$get_question_content = '';
		$get_question_mark = '';
		$get_question_explanation = '';
		$get_question_hint = '';
		$get_question_type = '';
		$get_option_value = '';

		$get_question_ids = $wpdb->get_results("SELECT question_id FROM {$wpdb->prefix}learnpress_quiz_questions WHERE quiz_id = $id ", ARRAY_A);
		foreach ($get_question_ids as $question_ids) {
			$question_id = $question_ids['question_id'];
			$get_question_id .= $question_id . ', ';
			$get_question_title .= $wpdb->get_var("SELECT post_title FROM {$wpdb->prefix}posts WHERE ID = $question_id ") . ',';
			$get_question_content .= $wpdb->get_var("SELECT post_content FROM {$wpdb->prefix}posts WHERE ID = $question_id ") . ',';

			$get_question_mark .= $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $question_id AND meta_key = '_lp_mark' ") . ', ';
			$get_question_explanation .= $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $question_id AND meta_key = '_lp_explanation' ") . ',';
			$get_question_hint .= $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $question_id AND meta_key = '_lp_hint' ") . ',';
			$get_question_type .= $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $question_id AND meta_key = '_lp_type' ") . ',';

			$get_question_options = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}learnpress_question_answers WHERE question_id = $question_id ", ARRAY_A);
			$option_value = '';
			foreach ($get_question_options as $question_options) {
				//$get_answer_data = unserialize($question_options['answer_data']);
				if (empty($question_options['is_true'])) {
					$question_options['is_true'] = 'no';
				}

				$option_value .= $question_options['title'] . '|' . $question_options['is_true'] . '->';
			}
			$get_option_value .=  rtrim($option_value, '->') . ',';
		}

		WooCommerceExport::$export_instance->data[$id]['question_id'] = rtrim($get_question_id, ', ');
		WooCommerceExport::$export_instance->data[$id]['question_title'] = rtrim($get_question_title, ',');
		WooCommerceExport::$export_instance->data[$id]['question_description'] = rtrim($get_question_content, ',');
		WooCommerceExport::$export_instance->data[$id]['_lp_mark'] = rtrim($get_question_mark, ', ');
		WooCommerceExport::$export_instance->data[$id]['_lp_explanation'] = rtrim($get_question_explanation, ',');
		WooCommerceExport::$export_instance->data[$id]['_lp_hint'] = rtrim($get_question_hint, ',');
		WooCommerceExport::$export_instance->data[$id]['_lp_type'] = rtrim($get_question_type, ',');
		WooCommerceExport::$export_instance->data[$id]['question_options'] = rtrim($get_option_value, ',');
	}

	public function getQuestionData($id)
	{
		global $wpdb;
		$get_quiz_id = $wpdb->get_var("SELECT quiz_id FROM {$wpdb->prefix}learnpress_quiz_questions WHERE question_id = $id ");

		$question_explanation = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_explanation' ");
		$question_hint = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_hint' ");
		$question_type = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_lp_type' ");


		$get_question_options = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}learnpress_question_answers WHERE question_id = $id ", ARRAY_A);
		$option_value = '';
		foreach ($get_question_options as $question_options) {
			//$get_answer_data = unserialize($question_options['answer_data']);
			if (empty($question_options['is_true'])) {
				$question_options['is_true'] = 'no';
			}

			$option_value .= $question_options['title'] . '|' . $question_options['is_true'] . '->';
		}

		if (!empty($get_quiz_id)) {
			$get_section_id = $wpdb->get_var("SELECT section_id FROM {$wpdb->prefix}learnpress_section_items WHERE item_id = $get_quiz_id AND item_type = 'lp_quiz' ");
			if (!empty($get_section_id)) {
				$get_section_name = $wpdb->get_var("SELECT section_name FROM {$wpdb->prefix}learnpress_sections WHERE section_id = $get_section_id ");
				$get_section_course_id = $wpdb->get_var("SELECT section_course_id FROM {$wpdb->prefix}learnpress_sections WHERE section_id = $get_section_id ");

				WooCommerceExport::$export_instance->data[$id]['curriculum_name'] = $get_section_name;
				WooCommerceExport::$export_instance->data[$id]['course_id'] = $get_section_course_id;
			}
			WooCommerceExport::$export_instance->data[$id]['quiz_id'] = $get_quiz_id;
		}

		WooCommerceExport::$export_instance->data[$id]['question_options'] = rtrim($option_value, '->');
		WooCommerceExport::$export_instance->data[$id]['_lp_explanation'] = $question_explanation;
		WooCommerceExport::$export_instance->data[$id]['_lp_hint'] = $question_hint;
		WooCommerceExport::$export_instance->data[$id]['_lp_type'] = $question_type;
	}

	public function getOrderData($id)
	{
		global $wpdb;

		$order_status = $wpdb->get_var("SELECT post_status FROM {$wpdb->prefix}posts WHERE ID = $id ");
		$order_date = $wpdb->get_var("SELECT post_date FROM {$wpdb->prefix}posts WHERE ID = $id ");
		$order_total = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_order_total' ");
		$order_subtotal = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_order_subtotal' ");
		$_billing_first_name = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_billing_first_name' ");

		$user_id = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id AND meta_key = '_user_id' ");

		$get_order_items = $wpdb->get_results("SELECT order_item_id FROM {$wpdb->prefix}learnpress_order_items WHERE order_id = $id ", ARRAY_A);
		$course_id = '';
		$item_quantity = '';
		$item_total = '';
		$item_subtotal = '';
		foreach ($get_order_items as $get_order_values) {
			$order_item_id = $get_order_values['order_item_id'];

			$course_id .= $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}learnpress_order_itemmeta WHERE learnpress_order_item_id = $order_item_id AND meta_key = '_course_id' ") . ', ';
			$item_quantity .= $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}learnpress_order_itemmeta WHERE learnpress_order_item_id = $order_item_id AND meta_key = '_quantity' ") . ', ';
			$item_total .= $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}learnpress_order_itemmeta WHERE learnpress_order_item_id = $order_item_id AND meta_key = '_subtotal' ") . ', ';
			$item_subtotal .= $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}learnpress_order_itemmeta WHERE learnpress_order_item_id = $order_item_id AND meta_key = '_total' ") . ', ';
		}

		WooCommerceExport::$export_instance->data[$id]['ORDER_ID'] = isset($id) ? $id : '';
		WooCommerceExport::$export_instance->data[$id]['order_status'] = isset($order_status) ? $order_status : '';
		WooCommerceExport::$export_instance->data[$id]['order_date'] = isset($order_date) ? $order_date : '';
		WooCommerceExport::$export_instance->data[$id]['_order_total'] = isset($order_total) ? $order_total : '';
		WooCommerceExport::$export_instance->data[$id]['_order_subtotal'] = isset($order_subtotal) ? $order_subtotal : '';
		WooCommerceExport::$export_instance->data[$id]['_billing_first_name'] = isset($_billing_first_name) ? $_billing_first_name : '';
		WooCommerceExport::$export_instance->data[$id]['user_id'] = isset($user_id) ? $user_id : '';
		WooCommerceExport::$export_instance->data[$id]['item_id'] = isset($course_id) ? rtrim($course_id, ', ') : '';
		WooCommerceExport::$export_instance->data[$id]['item_quantity'] = isset($item_quantity) ? rtrim($item_quantity, ', ') : '';
		WooCommerceExport::$export_instance->data[$id]['_item_total'] = isset($item_total) ? rtrim($item_total, ', ') : '';
		WooCommerceExport::$export_instance->data[$id]['_item_subtotal'] = isset($item_subtotal) ? rtrim($item_subtotal, ', ') : '';
	}
	public function elementor_export($id)
	{
		$elementorExport = new ElementorExport;
		$variable = $elementorExport->templateExport();
		if (!empty($variable)) {
			foreach ($variable as $key => $value) {
				if ($value['ID'] == $id) {
					WooCommerceExport::$export_instance->data[$id]['ID'] = $id;
					WooCommerceExport::$export_instance->data[$id]['Template title'] = $value['Template title'];
					WooCommerceExport::$export_instance->data[$id]['Template content'] = $value['Template content'];
					WooCommerceExport::$export_instance->data[$id]['Style'] = $value['Style'];
					WooCommerceExport::$export_instance->data[$id]['Template type'] = $value['Template type'];
					WooCommerceExport::$export_instance->data[$id]['Created time'] = $value['Created time'];
					WooCommerceExport::$export_instance->data[$id]['Created by'] = $value['Created by'];
					WooCommerceExport::$export_instance->data[$id]['Template status'] = $value['Template status'];
					WooCommerceExport::$export_instance->data[$id]['Category'] = $value['Category'];
				}
			}
		}
	}
	public function getCourseDataMasterLMS($id)
	{
		global $wpdb;
		$get_item_details = $wpdb->get_results("SELECT  item_id, item_title FROM {$wpdb->prefix}stm_lms_curriculum_log WHERE course_id = $id", ARRAY_A);
		$curicullam = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='curriculum' ");
		$curicullam_array = explode(',', $curicullam);
		foreach ($curicullam_array as &$value) {
			if (ctype_digit($value)) {
				$value = '';
			}
		}
		$curicullam = !empty($curicullam_array) ? implode(',', $curicullam_array) : '';
		$curicullam = trim($curicullam, ',');
		$curicullam_withoutId = preg_replace('/,{2,}/', ',', $curicullam);

		$faq = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='faq' ");
		$faq_array = json_decode($faq, true);
		$faq_output = '';
		foreach ($faq_array as $faq_item) {
			$faq_output .= 'question:' . $faq_item['question'] . ',answer:' . $faq_item['answer'] . ' | ';
		}
		$faq_output = rtrim($faq_output, ' | ');
		$course_files_pack = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='course_files_pack' ");
		$course_files_pack_array = json_decode($course_files_pack, true);
		$course_files_pack_output = '';
		foreach ($course_files_pack_array as $course_files_pack_item) {
			$course_files_pack_output .= 'course_files_label:' . $course_files_pack_item['course_files_label'];
		}
		$status_dates = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='status_dates' ");
		$status_dates_start = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='status_dates_start' ");
		$views = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='views'");
		$duration_info = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='duration_info'");
		$featured = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='featured'");
		$level = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='level'");
		$current_students = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='current_students'");
		$video_duration = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='video_duration'");
		$price = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='price'");
		$sale_price = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='sale_price'");
		$status = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='status'");
		$expiration_course = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='expiration_course'");
		$not_membership = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='not_membership'");
		$end_time = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='end_time'");
		$announcement = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='announcement'");
		$course_files_pack = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='course_files_pack'");

		$status_dates_end = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='status_dates_end' ");
		$status_dates_start = date('Y-m-d', $status_dates_start / 1000);
		$status_dates_end = date('Y-m-d', $status_dates_end / 1000);
		$status_dates_array = explode(',', $status_dates);
		$status_dates_formatted = array();

		foreach ($status_dates_array as $date) {
			if (!empty($date)) {
				$status_dates_formatted[] = date('Y-m-d', $date / 1000);
			}
		}
		$status_dates_formatted_str = !empty($status_dates_formatted) ? implode(',', $status_dates_formatted) : '';
		$get_lesson_id = '';
		$get_lesson_name = '';
		$get_quiz_id = '';
		$get_quiz_name = '';

		foreach ($get_item_details as $item_details) {
			$item_id = $item_details['item_id'];

			$lesson_id = '';
			$lesson_name = '';
			$quiz_id = '';
			$quiz_name = '';

			$get_section_item_details = $wpdb->get_results("SELECT distinct item_id, item_type FROM {$wpdb->prefix}stm_lms_curriculum_log WHERE item_id = $item_id ", ARRAY_A);

			foreach ($get_section_item_details as $section_item_details) {
				if ($section_item_details['item_type'] == 'stm-lessons') {
					$lesson_id .= $item_id . ', ';
					$lesson_name .= $wpdb->get_var("SELECT distinct post_title FROM {$wpdb->prefix}posts WHERE ID = $item_id ") . ',';
				} else if ($section_item_details['item_type'] == 'stm-quizzes') {
					$quiz_id .= $item_id . ', ';
					$quiz_name .= $wpdb->get_var("SELECT  distinct post_title FROM {$wpdb->prefix}posts WHERE ID = $item_id ") . ',';
				}
			}

			$get_lesson_id .= rtrim($lesson_id, ', ') . '|';
			$get_lesson_name .= rtrim($lesson_name, ',') . '|';
			$get_quiz_id .= rtrim($quiz_id, ', ') . '|';
			$get_quiz_name .= rtrim($quiz_name, ',') . '|';

			$get_lesson_id = str_replace('||', '|', $get_lesson_id);
			$get_lesson_name = str_replace('||', '|', $get_lesson_name);
			$get_quiz_id = str_replace('||', '|', $get_quiz_id);
			$get_quiz_name = str_replace('||', '|', $get_quiz_name);
		}

		WooCommerceExport::$export_instance->data[$id]['lesson_id'] = isset($get_lesson_id) ? $get_lesson_id : '';
		WooCommerceExport::$export_instance->data[$id]['lesson_name'] = isset($get_lesson_name) ? $get_lesson_name : '';
		WooCommerceExport::$export_instance->data[$id]['quiz_id'] = isset($get_quiz_id) ? $get_quiz_id : '';
		WooCommerceExport::$export_instance->data[$id]['quiz_name'] = isset($get_quiz_name) ? $get_quiz_name : '';
		WooCommerceExport::$export_instance->data[$id]['status_dates'] = isset($status_dates_formatted_str) ? $status_dates_formatted_str : '';
		WooCommerceExport::$export_instance->data[$id]['status_dates_start'] = isset($status_dates_start) ? $status_dates_start : '';
		WooCommerceExport::$export_instance->data[$id]['status_dates_end'] = isset($status_dates_end) ? $status_dates_end : '';
		WooCommerceExport::$export_instance->data[$id]['curriculum'] = isset($curicullam_withoutId) ? $curicullam_withoutId : '';
		WooCommerceExport::$export_instance->data[$id]['video_duration'] = isset($video_duration) ? $video_duration : '';
		WooCommerceExport::$export_instance->data[$id]['views'] = isset($views) ? $views : '';
		WooCommerceExport::$export_instance->data[$id]['price'] = isset($price) ? $price : '';
		WooCommerceExport::$export_instance->data[$id]['sale_price'] = isset($sale_price) ? $sale_price : '';
		WooCommerceExport::$export_instance->data[$id]['status'] = isset($status) ? $status : '';
		WooCommerceExport::$export_instance->data[$id]['expiration_course'] = isset($expiration_course) ? $expiration_course : '';
		WooCommerceExport::$export_instance->data[$id]['not_membership'] = isset($not_membership) ? $not_membership : '';
		WooCommerceExport::$export_instance->data[$id]['end_time'] = isset($end_time) ? $end_time : '';
		WooCommerceExport::$export_instance->data[$id]['announcement'] = isset($announcement) ? $announcement : '';
		WooCommerceExport::$export_instance->data[$id]['course_files_pack'] = isset($course_files_pack) ? $course_files_pack : '';
		WooCommerceExport::$export_instance->data[$id]['duration_info'] = isset($duration_info) ? $duration_info : '';
		WooCommerceExport::$export_instance->data[$id]['featured'] = isset($featured) ? $featured : '';
		WooCommerceExport::$export_instance->data[$id]['level'] = isset($level) ? $level : '';
		WooCommerceExport::$export_instance->data[$id]['current_students'] = isset($current_students) ? $current_students : '';
		WooCommerceExport::$export_instance->data[$id]['faq'] = isset($faq_output) ? $faq_output : '';
		WooCommerceExport::$export_instance->data[$id]['course_files_pack'] = isset($course_files_pack_output) ? $course_files_pack_output : '';
	}

	public function getQuestionDataMasterLMS($id)
	{
		global $wpdb;
		$type = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='type' ");
		$answers = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='answers' ");
		$question_explanation = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='question_explanation' ");
		$question = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='question' ");
		$question_hint = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='question_hint' ");
		$question_view_type = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='question_view_type' ");
		$image = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='image' ");
		$answers = unserialize($answers);
		$answers_string = '';
		foreach ($answers as $answer) {
			$answers_string .= $answer['text'] . ',' . $answer['isTrue'] . '|';
		}
		WooCommerceExport::$export_instance->data[$id]['type'] = $type;
		WooCommerceExport::$export_instance->data[$id]['answers'] = rtrim($answers_string);
		WooCommerceExport::$export_instance->data[$id]['question_explanation'] = $question_explanation;
		WooCommerceExport::$export_instance->data[$id]['question'] = $question;
		WooCommerceExport::$export_instance->data[$id]['question_hint'] = $question_hint;
		WooCommerceExport::$export_instance->data[$id]['question_view_type'] = $question_view_type;
		WooCommerceExport::$export_instance->data[$id]['image'] = $image;
	}

	public function orderDataMasterLMS($id)
	{
		global $wpdb;
		$status = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='status' ");

		WooCommerceExport::$export_instance->data[$id]['status'] = $status;
	}
	public function quizzDataMasterLMS($id)
	{
		global $wpdb;
		$duration = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='duration' ");
		$thumbnail_id = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='thumbnail_id' ");
		$lesson_excerpt = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='lesson_excerpt' ");
		$quiz_style = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='quiz_style' ");
		$correct_answer = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='correct_answer' ");
		$passing_grade = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='passing_grade' ");
		$re_take_cut = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='re_take_cut' ");
		$random_questions = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='random_questions' ");
		$questions = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='questions' ");

		WooCommerceExport::$export_instance->data[$id]['duration'] = $duration;
		WooCommerceExport::$export_instance->data[$id]['thumbnail_id'] = $thumbnail_id;
		WooCommerceExport::$export_instance->data[$id]['lesson_excerpt'] = $lesson_excerpt;
		WooCommerceExport::$export_instance->data[$id]['quiz_style'] = $quiz_style;
		WooCommerceExport::$export_instance->data[$id]['correct_answer'] = $correct_answer;
		WooCommerceExport::$export_instance->data[$id]['passing_grade'] = $passing_grade;
		WooCommerceExport::$export_instance->data[$id]['re_take_cut'] = $re_take_cut;
		WooCommerceExport::$export_instance->data[$id]['random_questions'] = $random_questions;
		WooCommerceExport::$export_instance->data[$id]['questions'] = $questions;
	}

	public function getLessonDataMasterLMS($id)
	{
		global $wpdb;
		$type = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='type'");
		$duration = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='duration' ");
		$preview = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='preview' ");
		$lesson_excerpt = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='lesson_excerpt' ");
		$_thumbnail_id = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_thumbnail_id' ");
		$video_type = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='video_type' ");
		$lesson_youtube_url = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='lesson_youtube_url' ");
		$presto_player_idx = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='presto_player_idx' ");
		$lesson_video = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='lesson_video' ");
		$lesson_video_poster = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='lesson_video_poster' ");
		$lesson_video_width = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='lesson_video_width' ");
		$lesson_shortcode = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='lesson_shortcode' ");
		$lesson_embed_ctx = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='lesson_embed_ctx' ");
		$lesson_stream_url = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='lesson_stream_url' ");
		$lesson_vimeo_url = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='lesson_vimeo_url' ");
		$lesson_ext_link_url = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='lesson_ext_link_url' ");
		$lesson_files_pack = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='lesson_files_pack' ");

		$lesson_files_pack_array = json_decode($lesson_files_pack, true);
		$lesson_files_pack_output = '';
		foreach ($lesson_files_pack_array as $lesson_files_pack_item) {
			if (!empty($lesson_files_pack_item['closed_tab'])) {
				$lesson_files_pack_output .= 'closed_tab:' . $lesson_files_pack_item['closed_tab'] . ',';
			}
			$lesson_files_pack_output .= 'lesson_files_label:' . $lesson_files_pack_item['lesson_files_label'] . ',';
			$lesson_files_pack_output = rtrim($lesson_files_pack_output, ',');
		}

		WooCommerceExport::$export_instance->data[$id]['type'] = isset($type) ? $type : '';
		WooCommerceExport::$export_instance->data[$id]['duration'] = isset($duration) ? $duration : '';
		WooCommerceExport::$export_instance->data[$id]['preview'] = isset($preview) ? $preview : '';
		WooCommerceExport::$export_instance->data[$id]['lesson_excerpt'] = isset($lesson_excerpt) ? $lesson_excerpt : '';
		WooCommerceExport::$export_instance->data[$id]['_thumbnail_id'] = isset($_thumbnail_id) ? $_thumbnail_id : '';
		WooCommerceExport::$export_instance->data[$id]['video_type'] = isset($video_type) ? $video_type : '';
		WooCommerceExport::$export_instance->data[$id]['lesson_youtube_url'] = isset($lesson_youtube_url) ? $lesson_youtube_url : '';
		WooCommerceExport::$export_instance->data[$id]['presto_player_idx'] = isset($presto_player_idx) ? $presto_player_idx : '';
		WooCommerceExport::$export_instance->data[$id]['lesson_video'] = isset($lesson_video) ? $lesson_video : '';
		WooCommerceExport::$export_instance->data[$id]['lesson_video_poster'] = isset($lesson_video_poster) ? $lesson_video_poster : '';
		WooCommerceExport::$export_instance->data[$id]['lesson_video_width'] = isset($lesson_video_width) ? $lesson_video_width : '';
		WooCommerceExport::$export_instance->data[$id]['lesson_shortcode'] = isset($lesson_shortcode) ? $lesson_shortcode : '';
		WooCommerceExport::$export_instance->data[$id]['lesson_embed_ctx'] = isset($lesson_embed_ctx) ? $lesson_embed_ctx : '';
		WooCommerceExport::$export_instance->data[$id]['lesson_stream_url'] = isset($lesson_stream_url) ? $lesson_stream_url : '';
		WooCommerceExport::$export_instance->data[$id]['lesson_vimeo_url'] = isset($lesson_vimeo_url) ? $lesson_vimeo_url : '';
		WooCommerceExport::$export_instance->data[$id]['lesson_ext_link_url'] = isset($lesson_ext_link_url) ? $lesson_ext_link_url : '';
		WooCommerceExport::$export_instance->data[$id]['lesson_files_pack'] = isset($lesson_files_pack_output) ? $lesson_files_pack_output : '';
	}

	public function getCourseDataLiferLms($id)
	{
		global $wpdb;
		$llms_instructors = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_instructors'");
		$llms_blocks_migrated = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_blocks_migrated'");
		$llms_sales_page_content_type = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_sales_page_content_type'");
		$_llms_sales_page_content_page_id = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_sales_page_content_page_id'");
		$_llms_sales_page_content_url = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_sales_page_content_url'");
		$_llms_video_embed = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_video_embed'");
		$_llms_tile_featured_video = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_tile_featured_video'");
		$_llms_audio_embed = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_audio_embed'");
		$_llms_content_restricted_message = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_content_restricted_message'");
		$_llms_enrollment_period = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_enrollment_period'");
		$_llms_enrollment_start_date = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_enrollment_start_date'");
		$_llms_enrollment_end_date = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_enrollment_end_date'");
		$_llms_enrollment_opens_message = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_enrollment_opens_message'");
		$_llms_enrollment_closed_message = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_enrollment_closed_message'");
		$_llms_time_period = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_time_period'");
		$_llms_start_date = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_start_date'");
		$_llms_end_date = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_end_date'");
		$_llms_course_opens_message = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_course_opens_message'");
		$_llms_course_closed_message = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_course_closed_message'");
		$_llms_has_prerequisite = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_has_prerequisite'");
		$_llms_prerequisite = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_prerequisite'");
		$_llms_prerequisite_track = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_prerequisite_track'");
		$_llms_enable_capacity = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_enable_capacity'");
		$_llms_capacity = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_capacity'");
		$_llms_capacity_message = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_capacity_message'");
		$_llms_reviews_enabled = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_reviews_enabled'");
		$_llms_display_reviews = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_display_reviews'");
		$_llms_num_reviews = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_num_reviews'");
		$_llms_multiple_reviews_disabled = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_multiple_reviews_disabled'");
		$_llms_post_course_difficulty = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_post_course_difficulty'");
		$_llms_length = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_length'");
		$_llms_average_grade = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_average_grade'");
		$_llms_enrolled_students = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_enrolled_students'");
		$_llms_last_data_calc_run = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_last_data_calc_run'");
		$_llms_average_progress = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_average_progress'");

		$access_plan_id = $wpdb->get_var("SELECT post_id FROM {$wpdb->prefix}postmeta WHERE meta_value = $id and meta_key='_llms_product_id'");
		if (!empty($access_plan_id)) {
			$llms_access_plan = $wpdb->get_var("SELECT post_title FROM {$wpdb->prefix}posts WHERE ID = $access_plan_id and post_type='llms_access_plan'");
			$_llms_enroll_text = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_enroll_text'");
			$_llms_sku = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $access_plan_id and meta_key='_llms_sku'");
			$_llms_trial_offer = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $access_plan_id and meta_key='_llms_trial_offer'");
			$_llms_price = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $access_plan_id and meta_key='_llms_price'");
			$_llms_on_sale = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $access_plan_id and meta_key='_llms_on_sale'");
			$_llms_is_free = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $access_plan_id and meta_key='_llms_is_free'");
			$_llms_frequency = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $access_plan_id and meta_key='_llms_frequency'");
			$_llms_checkout_redirect_type = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $access_plan_id and meta_key='_llms_checkout_redirect_type'");
			$_llms_checkout_redirect_forced = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $access_plan_id and meta_key='_llms_checkout_redirect_forced'");
			$_llms_availability = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $access_plan_id and meta_key='_llms_availability'");
			$_llms_access_expiration = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $access_plan_id and meta_key='_llms_access_expiration'");
		}

		WooCommerceExport::$export_instance->data[$id]['_llms_instructors'] = isset($llms_instructors) ? $llms_instructors : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_length'] = isset($_llms_length) ? $_llms_length : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_blocks_migrated'] = isset($llms_blocks_migrated) ? $llms_blocks_migrated : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_sales_page_content_type'] = isset($llms_sales_page_content_type) ? $llms_sales_page_content_type : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_sales_page_content_page_id'] = isset($_llms_sales_page_content_page_id) ? $_llms_sales_page_content_page_id : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_sales_page_content_url'] = isset($_llms_sales_page_content_url) ? $_llms_sales_page_content_url : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_video_embed'] = isset($_llms_video_embed) ? $_llms_video_embed : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_tile_featured_video'] = isset($_llms_tile_featured_video) ? $_llms_tile_featured_video : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_audio_embed'] = isset($_llms_audio_embed) ? $_llms_audio_embed : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_content_restricted_message'] = isset($_llms_content_restricted_message) ? $_llms_content_restricted_message : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_enrollment_period'] = isset($_llms_enrollment_period) ? $_llms_enrollment_period : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_enrollment_start_date'] = isset($_llms_enrollment_start_date) ? $_llms_enrollment_start_date : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_enrollment_end_date'] = isset($_llms_enrollment_end_date) ? $_llms_enrollment_end_date : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_enrollment_opens_message'] = isset($_llms_enrollment_opens_message) ? $_llms_enrollment_opens_message : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_enrollment_closed_message'] = isset($_llms_enrollment_closed_message) ? $_llms_enrollment_closed_message : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_time_period'] = isset($_llms_time_period) ? $_llms_time_period : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_start_date'] = isset($_llms_start_date) ? $_llms_start_date : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_end_date'] = isset($_llms_end_date) ? $_llms_end_date : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_course_opens_message'] = isset($_llms_course_opens_message) ? $_llms_course_opens_message : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_course_closed_message'] = isset($_llms_course_closed_message) ? $_llms_course_closed_message : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_has_prerequisite'] = isset($_llms_has_prerequisite) ? $_llms_has_prerequisite : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_prerequisite'] = isset($_llms_prerequisite) ? $_llms_prerequisite : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_prerequisite_track'] = isset($_llms_prerequisite_track) ? $_llms_prerequisite_track : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_enable_capacity'] = isset($_llms_enable_capacity) ? $_llms_enable_capacity : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_capacity'] = isset($_llms_capacity) ? $_llms_capacity : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_capacity_message'] = isset($_llms_capacity_message) ? $_llms_capacity_message : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_reviews_enabled'] = isset($_llms_reviews_enabled) ? $_llms_reviews_enabled : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_display_reviews'] = isset($_llms_display_reviews) ? $_llms_display_reviews : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_num_reviews'] = isset($_llms_num_reviews) ? $_llms_num_reviews : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_multiple_reviews_disabled'] = isset($_llms_multiple_reviews_disabled) ? $_llms_multiple_reviews_disabled : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_post_course_difficulty'] = isset($_llms_post_course_difficulty) ? $_llms_post_course_difficulty : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_average_grade'] = isset($_llms_average_grade) ? $_llms_average_grade : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_enrolled_students'] = isset($_llms_enrolled_students) ? $_llms_enrolled_students : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_last_data_calc_run'] = isset($_llms_last_data_calc_run) ? date("Y-m-d H:i:s", $_llms_last_data_calc_run) : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_average_progress'] = isset($_llms_average_progress) ? $_llms_average_progress : '';
		WooCommerceExport::$export_instance->data[$id]['llms_access_plan'] = isset($llms_access_plan) ? $llms_access_plan : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_enroll_text'] = isset($_llms_enroll_text) ? $_llms_enroll_text : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_sku'] = isset($_llms_sku) ? $_llms_sku : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_trial_offer'] = isset($_llms_trial_offer) ? $_llms_trial_offer : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_price'] = isset($_llms_price) ? $_llms_price : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_on_sale'] = isset($_llms_on_sale) ? $_llms_on_sale : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_is_free'] = isset($_llms_is_free) ? $_llms_is_free : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_frequency'] = isset($_llms_frequency) ? $_llms_frequency : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_checkout_redirect_type'] = isset($_llms_checkout_redirect_type) ? $_llms_checkout_redirect_type : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_checkout_redirect_forced'] = isset($_llms_checkout_redirect_forced) ? $_llms_checkout_redirect_forced : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_availability'] = isset($_llms_availability) ? $_llms_availability : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_access_expiration'] = isset($_llms_access_expiration) ? $_llms_access_expiration : '';
	}

	public function getLessonDataLifterLms($id)
	{
		global $wpdb;
		$_llms_blocks_migrated = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_blocks_migrated'");
		$_llms_video_embed = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_video_embed'");
		$_llms_audio_embed = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_audio_embed'");
		$_llms_free_lesson = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_free_lesson'");
		$_llms_has_prerequisite = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_has_prerequisite'");
		$_llms_prerequisite = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_prerequisite'");
		$_llms_drip_method = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_drip_method'");
		$_llms_days_before_available = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_days_before_available'");
		$_llms_date_available = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_date_available'");
		$_llms_time_available = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_time_available'");
		$_llms_require_passing_grade = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_require_passing_grade'");
		$_llms_reviews_enabled = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_reviews_enabled'");
		$_llms_order = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_order'");
		$_llms_parent_course = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_parent_course'");
		$_llms_parent_section = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_parent_section'");
		$_llms_parent_section_title = $wpdb->get_var("SELECT post_title FROM {$wpdb->prefix}posts WHERE ID = $_llms_parent_section and post_type='section'");
		$_llms_parent_course_title = $wpdb->get_var("SELECT post_title FROM {$wpdb->prefix}posts WHERE ID = $_llms_parent_course and post_type='course'");
		$_llms_require_assignment_passing_grade = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_require_assignment_passing_grade'");
		$_llms_points = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_points'");
		$_llms_quiz_enabled = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_quiz_enabled'");
		$_llms_random_questions = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_random_questions'");

		WooCommerceExport::$export_instance->data[$id]['_llms_blocks_migrated'] = isset($_llms_blocks_migrated) ? $_llms_blocks_migrated : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_random_questions'] = isset($_llms_random_questions) ? $_llms_random_questions : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_video_embed'] = isset($_llms_video_embed) ? $_llms_video_embed : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_audio_embed'] = isset($_llms_audio_embed) ? $_llms_audio_embed : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_free_lesson'] = isset($_llms_free_lesson) ? $_llms_free_lesson : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_has_prerequisite'] = isset($_llms_has_prerequisite) ? $_llms_has_prerequisite : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_prerequisite'] = isset($_llms_prerequisite) ? $_llms_prerequisite : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_drip_method'] = isset($_llms_drip_method) ? $_llms_drip_method : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_days_before_available'] = isset($_llms_days_before_available) ? $_llms_days_before_available : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_date_available'] = isset($_llms_date_available) ? $_llms_date_available : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_time_available'] = isset($_llms_time_available) ? $_llms_time_available : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_require_passing_grade'] = isset($_llms_require_passing_grade) ? $_llms_require_passing_grade : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_reviews_enabled'] = isset($_llms_reviews_enabled) ? $_llms_reviews_enabled : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_order'] = isset($_llms_order) ? $_llms_order : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_parent_section'] = isset($_llms_parent_section_title) ? $_llms_parent_section_title : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_require_assignment_passing_grade'] = isset($_llms_require_assignment_passing_grade) ? $_llms_require_assignment_passing_grade : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_parent_course'] = isset($_llms_parent_course_title) ? $_llms_parent_course_title : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_points'] = isset($_llms_points) ? $_llms_points : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_quiz_enabled'] = isset($_llms_quiz_enabled) ? $_llms_quiz_enabled : '';
	}

	public function getCouponDataLifterLms($id)
	{
		global $wpdb;
		$_llms_enable_trial_discount = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_enable_trial_discount'");
		$_llms_trial_amount = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_trial_amount'");
		$_llms_coupon_courses = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_coupon_courses'");
		$_llms_coupon_membership = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_coupon_membership'");
		$_llms_coupon_amount = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_coupon_amount'");
		$_llms_usage_limit = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_usage_limit'");
		$_llms_discount_type = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_discount_type'");
		$_llms_description = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_description'");
		$_llms_expiration_date = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_expiration_date'");
		$_llms_plan_type = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_plan_type'");
		$_llms_reviews_enabled = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_reviews_enabled'");
		$_llms_display_reviews = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_display_reviews'");
		$_llms_num_reviews = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_num_reviews'");
		$_llms_multiple_reviews_disabled = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_multiple_reviews_disabled'");

		$_llms_coupon_courses = unserialize($_llms_coupon_courses);
		$_llms_coupon_courses = !empty($_llms_coupon_courses) ? implode('|', $_llms_coupon_courses) : '';
		$_llms_coupon_membership = unserialize($_llms_coupon_membership);
		$_llms_coupon_membership = !empty($_llms_coupon_membership) ? implode('|', $_llms_coupon_membership) : '';

		WooCommerceExport::$export_instance->data[$id]['_llms_enable_trial_discount'] = isset($_llms_enable_trial_discount) ? $_llms_enable_trial_discount : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_trial_amount'] = isset($_llms_trial_amount) ? $_llms_trial_amount : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_coupon_courses'] = isset($_llms_coupon_courses) ? $_llms_coupon_courses : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_coupon_membership'] = isset($_llms_coupon_membership) ? $_llms_coupon_membership : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_coupon_amount'] = isset($_llms_coupon_amount) ? $_llms_coupon_amount : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_usage_limit'] = isset($_llms_usage_limit) ? $_llms_usage_limit : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_discount_type'] = isset($_llms_discount_type) ? $_llms_discount_type : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_description'] = isset($_llms_description) ? $_llms_description : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_expiration_date'] = isset($_llms_expiration_date) ? $_llms_expiration_date : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_plan_type'] = isset($_llms_plan_type) ? $_llms_plan_type : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_reviews_enabled'] = isset($_llms_reviews_enabled) ? $_llms_reviews_enabled : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_display_reviews'] = isset($_llms_display_reviews) ? $_llms_display_reviews : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_num_reviews'] = isset($_llms_num_reviews) ? $_llms_num_reviews : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_multiple_reviews_disabled'] = isset($_llms_multiple_reviews_disabled) ? $_llms_multiple_reviews_disabled : '';
	}

	public function getReviewDataLifterLms($id)
	{
		global $wpdb;
		$_llms_reviews_enabled = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_reviews_enabled'");
		$_llms_display_reviews = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_display_reviews'");
		$_llms_num_reviews = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_num_reviews'");
		$_llms_multiple_reviews_disabled = $wpdb->get_var("SELECT meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $id and meta_key='_llms_multiple_reviews_disabled'");

		WooCommerceExport::$export_instance->data[$id]['_llms_reviews_enabled'] = isset($_llms_reviews_enabled) ? $_llms_reviews_enabled : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_display_reviews'] = isset($_llms_display_reviews) ? $_llms_display_reviews : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_num_reviews'] = isset($_llms_num_reviews) ? $_llms_num_reviews : '';
		WooCommerceExport::$export_instance->data[$id]['_llms_multiple_reviews_disabled'] = isset($_llms_multiple_reviews_disabled) ? $_llms_multiple_reviews_disabled : '';
	}

	public function getMenuData($term_id)
	{
		global $wpdb;
		$term_name = get_term($term_id)->name;
		$get_object_ids = $wpdb->get_results("SELECT p.* FROM {$wpdb->prefix}posts AS p 
											LEFT JOIN {$wpdb->prefix}term_relationships AS tr ON tr.object_id = p.ID
											LEFT JOIN {$wpdb->prefix}term_taxonomy AS tt ON tt.term_taxonomy_id = tr.term_taxonomy_id
											WHERE p.post_type = 'nav_menu_item'
											AND tt.term_id = $term_id ", ARRAY_A);

		$menu_item_types = '';
		$menu_object_ids = '';
		$menu_objects = '';
		$menu_urls = '';
		foreach ($get_object_ids as $object_ids) {
			$object_id = $object_ids['ID'];

			$get_object_meta = $wpdb->get_results("SELECT meta_key , meta_value FROM {$wpdb->prefix}postmeta WHERE post_id = $object_id", ARRAY_A);
			$object_meta_key  = array_column($get_object_meta, 'meta_key');
			$object_meta_value  = array_column($get_object_meta, 'meta_value');
			$object_array = array_combine($object_meta_key, $object_meta_value);

			$menu_item_type = $object_array['_menu_item_type'];
			$menu_item_object = $object_array['_menu_item_object'];
			$menu_object_item_id = $object_array['_menu_item_object_id'];

			if ($menu_object_item_id) {

				if (($menu_item_type == 'post_type') && ($menu_item_object == 'post' || $menu_item_object == 'page')) {
					$menu_object_item_title = $wpdb->get_var("SELECT post_title FROM {$wpdb->prefix}posts WHERE ID = $menu_object_item_id AND post_type = '$menu_item_object' ");
				} elseif ($menu_item_type == 'custom' && $menu_item_object == 'custom') {
					$menu_object_item_title = $wpdb->get_var("SELECT post_title FROM {$wpdb->prefix}posts WHERE ID = $menu_object_item_id AND post_type = 'nav_menu_item' ");
				} elseif ($menu_item_type == 'taxonomy') {
					$category_data = get_term_by('id', $menu_object_item_id, $menu_item_object);
					$menu_object_item_title = $category_data->name;
				} else {
					$menu_object_item_title = $menu_object_item_id;
				}

				$menu_item_types .= $menu_item_type . ',';
				$menu_object_ids .= $menu_object_item_title . ',';
				$menu_objects .= $menu_item_object . ',';
				$menu_urls .= $object_array['_menu_item_url'] . ',';
			}


			WooCommerceExport::$export_instance->data[$term_id]['_menu_item_type'] = rtrim($menu_item_types, ',');
			WooCommerceExport::$export_instance->data[$term_id]['_menu_item_object_id'] = rtrim($menu_object_ids, ',');
			WooCommerceExport::$export_instance->data[$term_id]['_menu_item_object'] = rtrim($menu_objects, ',');
			WooCommerceExport::$export_instance->data[$term_id]['_menu_item_url'] = rtrim($menu_urls, ',');
		}
		if ($term_name)
			WooCommerceExport::$export_instance->data[$term_id]['menu_title'] = $term_name;
		$get_nav_options = get_option("nav_menu_options");
		if (!empty($get_nav_options['auto_add'])) {
			if (in_array($term_id, $get_nav_options['auto_add'])) {
				WooCommerceExport::$export_instance->data[$term_id]['menu_auto_add'] = 'yes';
			} else {
				WooCommerceExport::$export_instance->data[$term_id]['menu_auto_add'] = 'no';
			}
		} else {
			WooCommerceExport::$export_instance->data[$term_id]['menu_auto_add'] = 'no';
		}

		$get_navigation_locations = get_nav_menu_locations();
		foreach ($get_navigation_locations as $nav_keys => $nav_values) {
			if ($nav_values == $term_id) {
				WooCommerceExport::$export_instance->data[$term_id][$nav_keys] = 'yes';
			} else {
				WooCommerceExport::$export_instance->data[$term_id][$nav_keys] = 'no';
			}
		}
	}
}