관리-도구

편집 파일: sell_control.php

<?php
class Sellcontrol
{
	var $mysqli;
	var $dbpref;
	var $load;
	var $ip;
	function __construct($arr)
	{
		$this->mysqli = $arr['mysqli'];
		$this->dbpref = $arr['dbpref'];
		$this->load = $arr['load'];
		$this->ip = $arr['ip'];
	}
	function createProduct($product, $title, $description, $url, $price, $currency, $sheeping, $subproducts, $opproducts, $tax, $doupdate = 0)
	{
		$plugin_loader = false;
		if (isset($GLOBALS['plugin_loader'])) {
			$plugin_loader = $GLOBALS['plugin_loader'];
		}
		//create product 0 for insert 1 for update
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$table = $pref . "all_products";
		$product = $mysqli->real_escape_string($product);
		$title = $mysqli->real_escape_string($title);
		$description = $mysqli->real_escape_string($description);
		$url = $mysqli->real_escape_string($url);
		$price = $mysqli->real_escape_string($price);
		$currency = $mysqli->real_escape_string($currency);
		$sheeping = $mysqli->real_escape_string($sheeping);
		$subproducts = $mysqli->real_escape_string($subproducts);
		$opproducts = $mysqli->real_escape_string($opproducts);
		$tax = $mysqli->real_escape_string($tax);

$data_to_provide_inplugins = array(
			'product_id' => $product,
			'title' => $title,
			'description' => $description,
			'url' => $url,
			'price' => $price,
			'currency' => $currency,
			'shipping_charge' => $sheeping,
			'sub_products' => explode('@brk@', trim($subproducts, '@brk@')),
			'optional_products' => explode('@brk@', trim($opproducts, '@brk@')),
			'tax' => $tax
		);

if (strlen($product) < 1) {
			return "Please Use Unique Product Id to continue.";
		}
		if (!is_numeric($price)) {
			return "please Enter Product Price";
		}

if ($doupdate == 0) {
			$chk = $mysqli->query("select `id` from `" . $table . "` where `productid`='" . $product . "'");
			if ($chk->num_rows > 0)
				return "Product Already Exists";
			$in = $mysqli->query("insert into `" . $table . "` (`productid`,`title`,`url`,`description`,`price`,`currency`,`shipping`,`subproducts`,`opproducts`,`tax`,`createdon`) values ('" . $product . "','" . $title . "','" . $url . "','" . $description . "','" . $price . "','" . $currency . "','" . $sheeping . "','" . $subproducts . "','" . $opproducts . "','" . $tax . "','" . time() . "')");

if ($in) {
				$data_to_provide_inplugins['id'] = $mysqli->insert_id;

if (get_option("sales_notif_email_products")) {
					$sales_notif_email_products = explode(',', get_option("sales_notif_email_products"));
					if (!array_search($data_to_provide_inplugins['id'], $sales_notif_email_products)) {
						array_push($sales_notif_email_products, $data_to_provide_inplugins['id']);
					}
					update_option("sales_notif_email_products", implode(',', $sales_notif_email_products));
				}

$plugin_loader->processProduct($data_to_provide_inplugins, 'add');
			}
		} elseif (is_numeric($doupdate)) {
			$chk = $mysqli->query("select `id` from `" . $table . "` where `productid`='" . $product . "' and id not in(" . $doupdate . ")");
			if ($chk->num_rows > 0)
				return "Can not use same Product Id Multiple Times";

$u = $mysqli->query("update `" . $table . "` set `productid`='" . $product . "',`title`='" . $title . "',`url`='" . $url . "',`description`='" . $description . "',`price`='" . $price . "',`currency`='" . $currency . "',`shipping`='" . $sheeping . "',`subproducts`='" . $subproducts . "',`opproducts`='" . $opproducts . "',`tax`='" . $tax . "' where `id`='" . $doupdate . "'");

if ($u) {
				$data_to_provide_inplugins['id'] = $doupdate;
				$plugin_loader->processProduct($data_to_provide_inplugins, 'update');
			}
		}
		return 1;
	}
	function deleteProduct($id)
	{
		$plugin_loader = false;
		if (isset($GLOBALS['plugin_loader'])) {
			$plugin_loader = $GLOBALS['plugin_loader'];
		}

$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$table = $pref . "all_products";
		$id = $mysqli->real_escape_string($id);
		$del = $mysqli->query("delete from `" . $table . "` where `id`='" . $id . "'");
		if ($del) {
			$plugin_loader->processProduct($id, 'delete');
		}
	}
	function createPaymentMethod($title, $method, $tax, $credentials, $doupdate = 0)
	{
		//create product 0 for insert 1 for update
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$table = $pref . "payment_methods";
		$title = $mysqli->real_escape_string($title);
		$method = $mysqli->real_escape_string($method);
		$tax = $mysqli->real_escape_string($tax);
		$credentials = $mysqli->real_escape_string($credentials);
		if ($doupdate == 0) {
			$in = $mysqli->query("insert into `" . $table . "` (`title`,`method`,`tax`,`credentials`,`creadedon`) values ('" . $title . "','" . $method . "','" . $tax . "','" . $credentials . "','" . date('d-M-Y h:ia') . "')");
		} elseif (is_numeric($doupdate)) {
			$u = $mysqli->query("update `" . $table . "` set `title`='" . $title . "',`method`='" . $method . "',`tax`='" . $tax . "',`credentials`='" . $credentials . "',`creadedon`='" . date('d-M-Y h:ia') . "'");
		}
		return 1;
	}
	function getProductForView($last = 0)
	{
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$table = $pref . "all_products";

$totalrecord = $mysqli->query("select count(`id`) as countid from `" . $table . "`");
		$totalrecord = $totalrecord->fetch_object();
		$totalrecord = $totalrecord->countid;

$condition = 1;
		$date_between = dateBetween('createdon');
		if (strlen($date_between[0]) > 1) {
			$condition = $date_between[0];
		}
		$salescountquery = "(select count(`id`) from `" . $pref . "all_sales` where `productid`=`a`.id) as `sales_count`";
		if (isset($_POST['onpage_search']) && strlen($_POST['onpage_search']) > 0) {
			$search = $mysqli->real_escape_string($_POST['onpage_search']);
			$qry = "select `a`.*," . $salescountquery . " from `" . $table . "` as `a`  where `productid` like '%" . $search . "%' or `title` like '%" . $search . "%' or `url` like '%" . $search . "%' or `description` like '%" . $search . "%' order by `id` desc";
		} else {
			$order_by = "`a`.id desc";
			if (isset($_GET['arrange_records_order'])) {
				$order_by = base64_decode($_GET['arrange_records_order']);
			}
			if ($last == 0) {
				$qry = "select `a`.*," . $salescountquery . " from `" . $table . "` as `a` where " . $condition . " order by " . $order_by . " limit " . get_option('qfnl_max_records_per_page') . "";
			} else {
				$limitstart = ($last * get_option('qfnl_max_records_per_page')) - get_option('qfnl_max_records_per_page');
				$limitend = get_option('qfnl_max_records_per_page');

$qry = "select `a`.*," . $salescountquery . " from `" . $table . "` as `a` where " . $condition . " order by " . $order_by . " limit " . $limitstart . "," . $limitend . "";
			}
		}
		$qry = $mysqli->query($qry);
		if ($qry->num_rows > 0) {
			return array('data' => $qry, 'total' => $totalrecord);
		} else {
			return 0;
		}
	}
	function getNubmerOfTimesTheProductUsed($product_id)
	{
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$table = $pref . "quick_pagefunnel";
		$qry = $mysqli->query("select count(distinct(`id`)) as `countid` from `" . $table . "` where `product`='" . $product_id . "'");
		$count = 0;
		if ($r = $qry->fetch_object()) {
			$count = $r->countid;
		}
		return $count;
	}
	function pluginGetProducts($str)
	{
		//get all products for the plugin
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$table = $pref . "all_products";

$qry_str = "select * from `" . $table . "`" . $str;
		$arr = array();
		$qry = $mysqli->query($qry_str);
		while ($r = $qry->fetch_assoc()) {
			$r['sub_products'] = explode('@brk@', trim($r['subproducts'], '@brk@'));
			unset($r['subproducts']);

$r['optional_products'] = explode('@brk@', trim($r['opproducts'], '@brk@'));
			unset($r['opproducts']);

$r['product_id'] = $r['productid'];
			unset($r['productid']);

$r['shipping_charge'] = $r['shipping'];
			unset($r['shipping']);

array_push($arr, $r);
		}
		return $arr;
	}
	function getProduct($id, $idtype = 0)
	{
		//for product id $idtype=1
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$table = $pref . "all_products";
		$id = $mysqli->real_escape_string($id);

if ($idtype == 0) {
			$search = "`id`=" . $id;
		} else {
			$search = "`productid`='" . $id . "'";
		}
		$qry = $mysqli->query("select * from `" . $table . "` where " . $search . "");

if (isset($qry->num_rows)) {
			if ($qry->num_rows) {
				return $qry->fetch_object();
			} else {
				return 0;
			}
		} else {
			return 0;
		}
	}
	function getProductIdTitle()
	{
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$table = $pref . "all_products";
		$qry = $mysqli->query("select `id`,`productid`,`title` from `" . $table . "` order by id desc");
		if ($qry->num_rows > 0) {
			return $qry;
		} else {
			return 0;
		}
	}
	function countProductSales($id = "all")
	{
		//count product sales
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$table = $pref . "all_sales";
		$id = $mysqli->real_escape_string($id);

if (is_numeric($id)) {
			$id = " where `productid`='" . $id . "'";
		} else {
			$id = "";
		}

$qry = $mysqli->query("select count(`id`) as countid from `" . $table . "`" . $id . "");
		if ($qry) {
			if ($r = $qry->fetch_object()) {
				return $r->countid;
			}
		}
		return 0;
	}
	function getPaymentMethodDetail($id)
	{
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$table = $pref . "payment_methods";

if (is_numeric($id)) {
			$qry = $mysqli->query("select * from `" . $table . "` where id='" . $id . "'");
			if ($qry->num_rows > 0) {
				return $qry->fetch_object();
			} else {
				return 0;
			}
		} else if ($id === 'cod') {
			$arr = array(
				'id' => 'cod',
				'title' => 'Cash On Delivary',
				'method' => 'COD',
				'tax' => 0,
				'credentials' => json_encode(array()),
				'createdon' => ''
			);
			$credentials = (object) $arr;
			return $credentials;
		} else if (isset($GLOBALS['plugin_loader'])) {
			$plugin_loader = $GLOBALS['plugin_loader'];
			$id = str_replace('_ipn_', '_', $id);
			if (isset($plugin_loader->payment_methods_callbacks[$id])) {
				$arr = array(
					'id' => $id,
					'title' => $plugin_loader->payment_methods_callbacks[$id]['credentials']['title'],
					'method' => $plugin_loader->payment_methods_callbacks[$id]['credentials']['method'],
					'tax' => $plugin_loader->payment_methods_callbacks[$id]['credentials']['tax'],
					'credentials' => json_encode($plugin_loader->payment_methods_callbacks[$id]['credentials']),
					'createdon' => ''
				);
				$credentials = (object)$arr;
				return $credentials;
			} else {
				return 0;
			}
		} else {
			return 0;
		}
	}
	function getPaymentMethods()
	{
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$table = $pref . "payment_methods";

$qry = $mysqli->query("select * from `" . $table . "` order by id desc");
		if ($qry->num_rows > 0) {
			return $qry;
		} else {
			return 0;
		}
	}
	function createSaleNotification($data, $id)
	{
		$sales_notif_email_check = get_option("sales_notif_email_to_admin_check");
		if ($sales_notif_email_check == 1) {
			$senddata = "<p>Hello,</p>";
			$senddata .= "<p>I Hope you’re having a great week. <strong>" . $data['payer_name'] . "</strong> has purchased your product <strong>" . $data['product_title'] . "</strong>.</p><p> Sharing all the details with you of <strong>" . $data['payer_name'] . "</strong>.</p>";

$this_sale_link = get_option('install_url');
			$this_sale_link .= '/index.php?page=sales&sell_id=';
			$this_sale_link = $this_sale_link . cf_enc($id);

$senddata .= "<p><strong>Payment Id</strong>: " . $data['payment_id'] . "</p>";
			$senddata .= "<p><strong>Payment URL</strong>: <a href='" . $this_sale_link . "'>" . $this_sale_link . "</a></p>";

foreach ($data['shipping_data'] as $customer_detail_index => $customer_detail) {

if ($customer_detail_index == 'optional_products') {
					continue;
				}
				if (is_array($customer_detail) || is_object($customer_detail)) {
					$customer_detail = json_encode($customer_detail);
				}
				$senddata .= "<div>" . ucfirst(trim($customer_detail_index)) . ": " . $customer_detail . "</div>";
			}

$senddata .= "<p>Regards</p><p>CourseFunnels</p>";

$sequence_ob = $this->load->loadSequence();
			$smtpid = get_option("sales_notif_email_smtp");
			$sales_notif_email_admin = get_option("sales_notif_email_to_admin");
			$emails = explode(",", $sales_notif_email_admin);

$products = explode(",", get_option("sales_notif_email_products"));

if (in_array($data['product_id'], $products)) {
				foreach ($emails as $email) {
					if (filter_var($email, FILTER_VALIDATE_EMAIL)) {
						$sequence_ob->sendMail($smtpid, "", $email, "(CourseFunnels) " . $data['product_title'] . " Buying Notification", $senddata, "", "");
					}
				}
			}
		}
	}
	function createCOD($sell_id, $buyer_email)
	{
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$table = $pref . "qfnl_cod";
		$date = date('Y-m-d H:i:s');
		$ip = getIP();

$mysqli->query("insert into `" . $table . "` (`sell_id`, `status`, `buyer_email`, `signed_by`, `last_ip`, `added_on`, `updated_on`) values (" . $sell_id . ", 0, '" . $buyer_email . "', '0', '" . $ip . "', '" . $date . "', '" . $date . "')");
	}
	function getCODStat($sell_id)
	{
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$table = $pref . "qfnl_cod";
		$sell_id = $mysqli->real_escape_string($sell_id);

$qry = $mysqli->query("select * from `" . $table . "` where `sell_id`=" . $sell_id);
		if ($qry->num_rows > 0) {
			return $qry->fetch_object();
		} else {
			return false;
		}
	}
	function updateCODStat($sell_id, $shipped = 0, $paid = 0)
	{
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$sales_table = $pref . "all_sales";
		$table = $pref . "qfnl_cod";
	}
	function storeSells($data)
	{
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$table = $pref . "all_sales";

$shippingdata = array();
		foreach ($data as $index => $val) {
			if ($index == "shipping_data") {
				if (is_array($val)) {
					foreach ($val as $shippingindex => $shippingdataval) {
						if (is_array($shippingdataval)) {
							foreach ($shippingdataval as $shippingdataval_index => $shippingdataval_val) {
								$shippingdataval[$shippingdataval_index] = htmlentities($mysqli->real_escape_string($shippingdataval_val));
							}
							$shippingdata[$shippingindex] = json_encode($shippingdataval);
						} else {
							$shippingdata[$shippingindex] = htmlentities($mysqli->real_escape_string($shippingdataval));
						}
					}
				}
			} elseif (!in_array($index, array("data", "membership", 'step_sales'))) {
				$data[$index] = $mysqli->real_escape_string($val);
			}
		}
		if (isset($_GET['qfnl_is_ipn'])) {
			if (is_array($shippingdata)) {
				$tempname = "";
				$tempemail = "";
				if (isset($shippingdata['name'])) {
					$tempname = $shippingdata['name'];
					unset($shippingdata['name']);
				}
				if (isset($shippingdata['email'])) {
					$tempemail = $shippingdata['email'];
					unset($shippingdata['email']);
				}
				$shippingdata = array_merge(array('name' => $tempname, 'email' => $tempemail), $shippingdata);
			}
		}
		$shippingdata = $mysqli->real_escape_string(json_encode($shippingdata));
		$data['data'] = $mysqli->real_escape_string($data['data']);

$membershipdata = "";
		if (isset($GLOBALS['sales_membershiparray'])) {
			$membershipdata = implode(",", $GLOBALS['sales_membershiparray']);
		}
		$mysqli->query("INSERT INTO `" . $pref . "all_sales` (`productid`, `paymentmethod`, `membership`, `payment_id`, `shippingdetail`,`shipped`, `funnelid`, `pageid`, `paymentdata`, `parent`, `purchase_name`, `purchase_email`,`valid`,`exf`,`total_paid`,`step_payments`,`addedon`) VALUES ('" . $data['product_id'] . "','" . $data['payment_method'] . "','" . $membershipdata . "','" . $data['payment_id'] . "','" . $shippingdata . "','0','" . $data['funnel_id'] . "','" . $data['page_id'] . "','" . $data['payment_data'] . "','" . $data['parent_id'] . "','" . $data['payer_name'] . "','" . $data['payer_email'] . "','1','" . $data['data'] . "','" . $_SESSION['total_paid' . get_option('site_token')] . " (" . $_SESSION['payment_currency' . get_option('site_token')] . ")','" . $data['step_sales'] . "','" . time() . "')");
		$sell_id = $mysqli->insert_id;
		if ($data['payment_method'] === 'cod') {
			self::createCOD($sell_id, $data['payer_email']);
		}
		self::createSaleNotification($data, $sell_id);
	}

function getSale($id, $through_plugin = false, $modifiers = array())
	{
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$table = $pref . "all_sales";
		$cod_table = $pref . 'qfnl_cod';

$id = $mysqli->real_escape_string($id);

if ($through_plugin === false) {
			$qry = $mysqli->query("select * from `" . $table . "` where `id`=" . $id . "");
			if ($qry->num_rows) {
				$r = $qry->fetch_object();
				$r->cod_data = self::getCODStat($id);
				return $r;
			}
			return 0;
		} else {
			$arr = array();
			$qry_str = "select * from `" . $table . "`" . $through_plugin;
			$qry = $mysqli->query($qry_str);
			while ($r = $qry->fetch_assoc()) {
				//$modifiers
				$temp_sell_id = $r['id'];
				foreach ($r as $index => $val) {
					if (isset($modifiers[$index]) && $index !== $modifiers[$index]) {
						$r[$modifiers[$index]] = $val;
						unset($r[$index]);
					}

if ($index == 'shippingdetail') {
						$r['shipping_detail'] = $r['shippingdetail'];
						unset($r['shippingdetail']);
					}

if ($index == 'pageid') {
						$r['page_id'] = $r['pageid'];
						unset($r['pageid']);
					}

if ($index == 'paymentdata') {
						$r['payment_data'] = $r['paymentdata'];
						unset($r['paymentdata']);
					}

if ($index == 'addedon') {
						$r['added_on'] = $r['addedon'];
						unset($r['addedon']);
					}

if ($index === 'membership') {
						$r['membership_id'] = trim($r['membership_id']);
						$r['membership_id'] = (strlen($r['membership_id']) < 1) ? (array()) : (explode(',', trim($r['membership_id'], ',')));
					}
				}
				$r['cod_data'] = self::getCODStat($temp_sell_id);
				array_push($arr, $r);
			}
			return $arr;
		}
	}

function stepSalesCreator($credentials, $items)
	{
		//step sales creator
		$plugin_loader = false;
		if (isset($GLOBALS['plugin_loader'])) {
			$plugin_loader = $GLOBALS['plugin_loader'];
		}

$credentials = json_decode($credentials);
		$itemarr = array();

$sheepingcharge = 0;
		$tax = 0;
		$totalprice = 0;
		$productid = 0;
		$currency = "USD";
		$producttitle = "";

$allproductdetail = "";
		for ($i = 0; $i < count($items); $i++) {
			if ($i == 0) {
				$currency = $items[$i]['currency'];
				$producttitle = $items[$i]['title'];
				$productid = $items[$i]['productid'];
			}
			$allproductdetail .= $items[$i]['title'] . " (Price: " . number_format($items[$i]['price'], 2) . " " . $currency . ")<br>";
			$sheepingcharge = (float)$sheepingcharge + (float)$items[$i]['shipping'];
			$tax = (float)$tax + (float)$items[$i]['tax'];

$totalprice = (float)$totalprice + (float)$items[$i]['price'];
		}

if (isset($credentials->tax)) {
			$credentials->tax = (float) $credentials->tax;
			$tax = $tax + ($totalprice * ($credentials->tax / 100));
		}
		$totalprice = number_format((float)$totalprice, 2, '.', '');
		$sheepingcharge = number_format((float)$sheepingcharge, 2, '.', '');
		$tax = number_format((float)$tax, 2, '.', '');

$allproductdetail .= "<hr/>Total Price: " . number_format((float)$totalprice, 2, '.', '') . " " . $currency . "<br>";

$allproductdetail .= "Tax: " . number_format($tax, 2) . " " . $currency . "<br>";

$allproductdetail .= "Sheeping Charge: " . number_format((float)$sheepingcharge, 2, '.', '') . " " . $currency;

return $allproductdetail;
	}

function doPayment($funnelid, $folder, $pageid, $abtype, $productid, $paymentmethod_id, $membership, $lists, $optionalproducts = array(), $confirm_url = '', $cancel_url = '', $userdata = '')
	{
		$plugin_loader = false;
		if (isset($GLOBALS['plugin_loader'])) {
			$plugin_loader = $GLOBALS['plugin_loader'];
		}

$productsarr = array();
		$product = self::getProduct($productid);
		if (!is_object($product)) {
			return "No Product Selected";
		}
		array_push($productsarr, (array)$product);
		$extraproducts = explode("@brk@", $product->subproducts);

if (!is_array($optionalproducts)) {
			$optionalproducts = array($optionalproducts);
		}
		for ($i = 0; $i < count($optionalproducts); $i++) {
			$temp_optionalproductsob = self::getProduct($optionalproducts[$i], 1);
			if (is_object($temp_optionalproductsob)) {
				$optionalproducts[$i] = $temp_optionalproductsob->id;
			} else {
				unset($optionalproducts[$i]);
			}
		}

$products = array_unique(array_merge($extraproducts, $optionalproducts));

foreach ($products as $productt) {
			if ($productt == $productid || (!is_numeric($productt))) {
				continue;
			}
			$productdata = self::getProduct($productt);
			if (!is_object($productdata)) {
				continue;
			}
			array_push($productsarr, (array)$productdata);
		}

$payment_data = self::getPaymentMethodDetail($paymentmethod_id);
		if (!is_object($payment_data)) {
			return "Invalid Payment Method";
		}
		$method = $payment_data->method;

$membershiparr = array();
		$tempmembershiparr = explode(',', $membership);
		$membershiptext = "";

for ($i = 0; $i < count($tempmembershiparr); $i++) {
			if (is_numeric($tempmembershiparr[$i])) {
				array_push($membershiparr, $tempmembershiparr[$i]);
			}
		}
		if (count($membershiparr) > 0) {
			$membershiptext = implode("@", $membershiparr);
			$membershiptext = "@" . $membershiptext . "@";
		}

if ($method == 'COD') {
			//COD
			require_once(__DIR__ . "/payment_apis/cod/function.php");
			if ($product->price < 1) {
				$done = addToCOD($this, $payment_data->credentials, $productsarr, $product->description);
				$cod_otp = substr(str_shuffle('1234567890XCVBNMASDFGHJQWERTYUIOP@#$%^&*()+xcvbnm,ertyuiwertyui'), 0, 8);
				$_POST['verify_otp'] = 1;
				$_POST['codCustOTP'] = $cod_otp;
				$cod_order_data_arr = $_SESSION['order_form_data' . get_option('site_token')];
				$_GET['execute'] = 1;
				$_SESSION['total_paid' . get_option('site_token')] = 0;
				$email = $cod_order_data_arr['data']['email'];

$name = "";
				if (isset($cod_order_data_arr['data']['name'])) {
					$name = $cod_order_data_arr['data']['name'];
				} else if (isset($cod_order_data_arr['data']['firstname'])) {
					$name = $cod_order_data_arr['data']['firstname'];
					if (isset($cod_order_data_arr['data']['lastname'])) {
						$name .= " " . $cod_order_data_arr['data']['lastname'];
					}
				}

$all_price_detail = self::getProductsPriceDependingOnMethod($payment_data->credentials, $productsarr);
				if (is_array($all_price_detail)) {
					foreach ($all_price_detail as $all_price_detail_index => $all_price_detail_val) {
						${$all_price_detail_index} = $all_price_detail_val;
					}
				}

$arr = array(
					'payer_name' => $name,
					'payer_email' => $email,
					'payment_id' =>  'cf_cod_' . $cod_otp . '_' . time(),
					'total_paid' => $total,
					'payment_currency' => $currency,
				);
				$done = json_encode($arr);
			} else {
				require_once(__DIR__ . "/payment_apis/cod/function.php");
				$done = addToCOD($this, $payment_data->credentials, $productsarr, $product->description);
			}
			if ($done !== 0 && (isset($_GET['execute']))) {
				$paymentdata = json_decode($done);

$payer_name = $paymentdata->payer_name;
				$payer_email = $paymentdata->payer_email;
				$payment_id = $paymentdata->payment_id;
			}
		} elseif ($plugin_loader) {
			//process through plugin
			$product_detail_for_plugin = self::getProductsPriceDependingOnMethod(json_decode($payment_data->credentials), $productsarr);
			$done = $plugin_loader->processPaymentMethod($paymentmethod_id, $product_detail_for_plugin, $product->description);

if (!$done) {
				$done = 0;
			}

if ($done !== 0 && (isset($_GET['execute']))) {
				$paymentdata = (object)$done;
				$done = json_encode($done);

if (!isset($paymentdata->payer_name)) {
					throw new Exception("Missing index `payer_name` in payment confirmation data");
				} else if (!isset($paymentdata->payer_email)) {
					throw new Exception("Missing index `payer_email` in payment confirmation data");
				} else if (!isset($paymentdata->payment_id)) {
					throw new Exception("Missing index `payment_id` in payment confirmation data");
				} else if (!isset($paymentdata->total_paid)) {
					throw new Exception("Missing index `total_paid` in payment confirmation data");
				} else if (!isset($paymentdata->payment_currency)) {
					throw new Exception("Missing index `payment_currency` in payment confirmation data");
				} else if (!isset($paymentdata->ipn_tax)) {
					$_SESSION['ipn_tax' . get_option('site_token')] = 0;
				}

$payer_name = $paymentdata->payer_name;
				$payer_email = $paymentdata->payer_email;
				$payment_id = $paymentdata->payment_id;

$_SESSION['total_paid' . get_option('site_token')] = $paymentdata->total_paid;
				$_SESSION['payment_currency' . get_option('site_token')] = $paymentdata->payment_currency;
			}
		}

if ($done !== 0 && (isset($_GET['execute']))) {
			if (strpos($method, "_ipn") < 1) {
				$step_paymentdata = self::stepSalesCreator($payment_data->credentials, $productsarr);
			} else {
				$step_paymentdata = "";
			}

$arr['payer_name'] = $payer_name;
			$arr['payer_email'] = $payer_email;
			$arr['payment_id'] = $payment_id;
			$arr['total_paid'] = $_SESSION['total_paid' . get_option('site_token')];

if (!isset($userdata['name'])) {
				$userdata['name'] = $arr['payer_name'];
			} elseif (strlen($userdata['name']) < 1) {
				$userdata['name'] = $arr['payer_name'];
			}

if (!isset($userdata['email'])) {
				$userdata['email'] = $arr['payer_email'];
			} elseif (strlen($userdata['email']) < 1) {
				$userdata['email'] = $arr['payer_email'];
			}

//add to funnels optin storing function
			$productlistarr = array();
			for ($i = 0; $i < count($productsarr); $i++) {
				if (!is_numeric($productsarr[$i]['id'])) {
					continue;
				}
				array_push($productlistarr, $productsarr[$i]['id']);
			}

$leadsdataarr = array_merge($userdata, $arr);
			$leadsdataarr['product_ids'] = $productlistarr;

$funnel_ob = $this->load->loadFunnel();
			$leadsdataarr['sales_membership'] = $membershiparr;
			$funnel_ob->leadsStoreFromSavedFunnels($funnelid, $folder, $abtype, $leadsdataarr, $productsarr, 0);
			$_SESSION['current_payment_cofirmation' . get_option('site_token')] = $leadsdataarr;
			//---------------------------------

$data = array();
			$data['payment_method'] = $paymentmethod_id;
			$data['payment_id'] = $arr['payment_id'];
			$data['funnel_id'] = $funnelid;
			$data['page_id'] = $pageid;
			$data['payment_data'] = $done;
			$data['payer_name'] = $arr['payer_name'];
			$data['payer_email'] = $payer_email;
			$data['data'] = $done;
			$data['shipping_data'] = $userdata;
			$data['membership'] = $membershiptext;

$all_data_to_store = array();
			for ($i = 0; $i < count($productsarr); $i++) {
				$data['product_id'] = $productsarr[$i]['id'];
				$data['product_title'] = $productsarr[$i]['title'];
				$data['product_url'] = $productsarr[$i]['url'];

$productstempidarrsingle = $productsarr[$i];
				if ($productid != $productstempidarrsingle['id']) {
					$data['parent_id'] = $productid;
				} else {
					$data['parent_id'] = 0;
				}
				$data['step_sales'] = $step_paymentdata;

$forplugin_data = $data;
				$forplugin_data['membership'] = array();
				if (isset($GLOBALS['sales_membershiparray'])) {
					$forplugin_data['membership'] = $GLOBALS['sales_membershiparray'];
				}

array_push($all_data_to_store, $forplugin_data);
				self::storeSells($data);
			}
			$plugin_loader->triggerSales($all_data_to_store, true);

echo "<script>window.location='" . $confirm_url . "';</script>";
		} elseif (isset($_GET['execute'])) {
			if (isset($_SESSION['current_payment_cofirmation' . get_option('site_token')])) {
				unset($_SESSION['current_payment_cofirmation' . get_option('site_token')]);
			}
			$plugin_loader->triggerSales(array(), false);
			echo "<script>window.location='" . $cancel_url . "';</script>";
		}
	}
	function checkOutDetailcreate($paymentmethod_id, $productid, $optionalproducts)
	{

//counting products
		$main_products = array();
		$all_products = array($productid);
		$productsarr = array();
		$product = self::getProduct($productid);

if (!is_object($product)) {
			return die("No Product Selected");
		}
		array_push($productsarr, (array)$product);

array_push($main_products, $product->productid);

$extraproducts = explode("@brk@", $product->subproducts);

if (!is_array($optionalproducts)) {
			$optionalproducts = array($optionalproducts);
		}

for ($i = 0; $i < count($optionalproducts); $i++) {
			$temp_optionalproductsob = self::getProduct($optionalproducts[$i], 1);
			if (is_object($temp_optionalproductsob)) {
				if (array_search($temp_optionalproductsob->id, $extraproducts) === false) {
					$optionalproducts[$i] = $temp_optionalproductsob->id;
				} else {
					unset($optionalproducts[$i]);
				}
			} else {
				unset($optionalproducts[$i]);
			}
		}
		$products = $extraproducts;
		//extra products
		foreach ($products as $productt) {
			if ($productt == $productid || (!is_numeric($productt))) {
				continue;
			}
			$productdata = self::getProduct($productt);
			if (!is_object($productdata)) {
				continue;
			}
			array_push($productsarr, (array)$productdata);
			array_push($main_products, $productdata->productid);
			array_push($all_products, $productt);
		}

$products = $optionalproducts;
		//additional
		foreach ($products as $productt) {
			if ($productt == $productid || (!is_numeric($productt))) {
				continue;
			}
			$productdata = self::getProduct($productt);
			if (!is_object($productdata)) {
				continue;
			}
			array_push($productsarr, (array)$productdata);
			array_push($all_products, $productt);
		}
		$items = $productsarr;
		$all_products = array_unique($all_products);

$payment_data = self::getPaymentMethodDetail($paymentmethod_id);
		if (!is_object($payment_data)) {
			die("Invalid Payment Method");
		}
		$data = self::getProductsPriceDependingOnMethod($payment_data, $items, 1);
		if (is_array($data)) {
			$data['all_products'] = $all_products;
			$data['main_products'] = $main_products;
		}
		return $data;
	}
	function getProductsPriceDependingOnMethod($credentials, $items, $checkout_page = 0)
	{
		$plugin_loader = false;
		if (isset($GLOBALS['plugin_loader'])) {
			$plugin_loader = $GLOBALS['plugin_loader'];
		}
		$itemarr = array();
		$sheepingcharge = 0;
		$tax = 0;
		$totalprice = 0;

$currency = "USD";

$allproductdetail = "";
		for ($i = 0; $i < count($items); $i++) {
			if ($i == 0) {
				$currency = $items[$i]['currency'];
			}
			$allproductdetail .= $items[$i]['title'] . " (Price: " . number_format($items[$i]['price'], 2) . " " . $currency . ")<br>";
			$sheepingcharge = (float)$sheepingcharge + (float)$items[$i]['shipping'];
			$tax = (float)$tax + (float)$items[$i]['tax'];

$totalprice = (float)$totalprice + (float)$items[$i]['price'];
		}

if (isset($credentials->tax) && is_numeric($credentials->tax)) {
			$credentials->tax = (float)$credentials->tax;
			$tax = $tax + ($totalprice * ($credentials->tax / 100));
		}

$total = $totalprice + $tax + $sheepingcharge;
		$total = number_format((float)$total, 2, '.', '');
		$sheepingcharge = number_format((float)$sheepingcharge, 2, '.', '');
		$totalprice = number_format((float)$totalprice, 2, '.', '');
		$data = array();
		if ($checkout_page) {
			$data =  array(
				'shipping_charge' => $sheepingcharge,
				'tax_amount' => $tax,
				'subtotal_price' => $totalprice,
				'total_price' => $total,
				'payment_currency' => $currency,
			);
		} else {
			$data = compact('itemarr', 'sheepingcharge', 'tax', 'totalprice', 'currency', 'total', 'allproductdetail', 'items');
		}
		$order_session = get_requested_order();
		$data = $plugin_loader->processFilter('the_checkout_data', $data, array('payment_method' => $credentials, 'checkout_page' => $checkout_page, 'order_session' => $order_session));
		return $data;
	}
	function allProductsTeamlateCreate($html, $user_products = array())
	{
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$table = $pref . "all_products";

$all_reg = "/\{(all_products|all_courses)((\s)+where(\s)*=(\s)*((\"[^\"]*\")|('[^']*')){1}){0,1}((\s)+values(\s)*=(\s)*((\"[^\"]*\")|('[^']*')){1}){0,1}\}((.)(?!\{(all_products|all_courses)))*\{\/(all_products|all_courses)\}/i";

$init_reg = "/\{(all_products|all_courses)((\s)+where(\s)*=(\s)*((\"[^\"]*\")|('[^']*')){1}){0,1}((\s)+values(\s)*=(\s)*((\"[^\"]*\")|('[^']*')){1}){0,1}\}/i";

$end_reg = "/\{\/(all_products|all_courses)\}/i";

$where_reg = "/(?<=(where=))(\\s)*((\"[^\"]+\")|('[^']+'))/i";

$values_reg = "/(?<=(values=))(\\s)*((\"[^\"]+\")|('[^']+'))/i";

$value_each_reg = "/(('[^']*')|(\"[^\"]*\")|[0-9]+)/i";

$cb = function ($arg) use ($init_reg, $where_reg, $values_reg, $value_each_reg, $end_reg, $mysqli, $table, $user_products) {
			if (isset($arg[0])) {
				$data = $arg[0];
				$qry = "";
				$qry_args = array();
				preg_match($init_reg, $data, $arr);

if (isset($arr[0])) {
					preg_match($where_reg, $arr[0], $w_arr);
					preg_match($values_reg, $arr[0], $v_arr);

if (isset($v_arr[0])) {
						$v_arr[0] = trim($v_arr[0], '\'|"');
						preg_match_all($value_each_reg, $v_arr[0], $q_args);
						if (isset($q_args[0]) && is_array($q_args[0])) {
							$qry_args = $q_args[0];
						}
					}

if (isset($w_arr[0])) {
						$w_arr[0] = trim($w_arr[0]);
						if (strlen($w_arr[0]) > 2) {
							$w_arr[0];
							$qry = trim(trim($w_arr[0]), '\'|"');
						}
					}
				}

if (is_array($qry_args) && strlen($qry) > 0) {
					for ($i = 0; $i < count($qry_args); $i++) {
						$qry_args[$i] = trim(trim($qry_args[$i]), '\'"');
						$strr = $mysqli->real_escape_string($qry_args[$i]);
						$qry = preg_replace_callback("/(%d|%s)/i", function ($argg) use ($strr) {
							if ($argg[0] === '%d') {
								return $strr;
							} else {
								return '"' . $strr . '"';
							}
						}, $qry, 1);
					}
				}

$data = preg_replace($init_reg, '', $data);
				$data = preg_replace($end_reg, '', $data);

$new_data = "";

if (strlen($qry) > 0) {
					$currect_products = "0";
					if (is_array($user_products) && count($user_products) > 0) {
						$currect_products = implode(',', $user_products);
						$qry = str_replace('{member.products}', $currect_products, $qry);
					}
					$qry = $mysqli->query("select * from `" . $table . "` where" . $qry);
				} else {
					$qry = $mysqli->query("select * from `" . $table . "` order by id desc");
				}

if (isset($qry->num_rows) && $qry->num_rows > 0) {
					while ($r = $qry->fetch_object()) {
						$new_data .= $this->tempProducthipReplacerCb($data, $r);
					}
				}
				return $new_data;
			}
		};

$html = preg_replace_callback($all_reg, $cb, $html);
		return $html;
	}
	function productTemplatecreator($html, $productids = array())
	{
		$pregtestfordom = "/(cf-loop(?=((=['\"](products|courses))+)))+/";
		if (preg_match($pregtestfordom, $html, $arr)) {
			$html = @cfLoopCreator('products', $html);
		}
		$data = array();
		if (is_array($productids)) {
			for ($i = 0; $i < count($productids); $i++) {
				$product = self::getProduct($productids[$i]);
				if (is_object($product)) {
					array_push($data, (array)$product);
				}
			}
		}
		preg_match('/({(products|courses)})+/', $html, $arr);

if (is_array($arr)) {
			$tempRplc = function () use (&$start, &$end, &$html, &$data) {
				if (!$start || !$end) {
					return;
				}
				$end = $end + 10;
				$find = substr($html, $start, ($end - $start + 1));

$str = "";

for ($j = 0; $j < count($data); $j++) {
					$str .= self::tempProducthipReplacerCb($find, $data[$j]);
				}
				$html = str_replace($find, $str, $html);
			};
			for ($i = 0; $i < count($arr); $i++) {
				$start = strpos($html, "{products}");
				$end = strpos($html, "{/products}");
				$tempRplc();
				$start = strpos($html, "{courses}");
				$end = strpos($html, "{/courses}");
				$tempRplc();
			}
		}

if (isset($data[0])) {
			$html = self::tempProducthipReplacerCb($html, $data[0]);
		}

return $html;
	}
	function tempProducthipReplacerCb($str, $datas)
	{
		foreach ($datas as $index => $data) {
			if ($index == "id") {
				continue;
			}
			if ($index == "productid") {
				$index = "id";
			}
			if (!is_array($data)) {
				$data = $data != '' ? $data : '';
				if ($index == "show_url") {
					$str = str_replace("{course." . $index . "}", $data . "?id=" . $datas['id'], $str);
				} else {
					$str = str_replace("{product." . $index . "}", $data, $str);
					$str = str_replace("%7Bproduct." . $index . "%7D", $data, $str);
					$str = str_replace("{course." . $index . "}", $data, $str);
					$str = str_replace("%7Bcourse." . $index . "%7D", $data, $str);
					$str = str_replace("{course.date}", date("d-M-Y", time()), $str);
				}
			}
		}
		$str = str_replace("{products}", "", $str);
		$str = str_replace("{/products}", "", $str);

$str = str_replace("{courses}", "", $str);
		$str = str_replace("{/courses}", "", $str);

return $str;
	}

function visualOptisForSales($funnel_id = 'all', $pagecount = 0, $search = "", $limit = 10, $type = "all")
	{
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$table = $pref . "all_sales";
		$cod_table = $pref . 'qfnl_cod';

$cod_type = "";
		$cod_type_where = "";

if ($type == 'cod') {
			$cod_type = " `id` in (select `sell_id` from `" . $cod_table . "`)";
		} else if ($type == 'cod_shipped') {
			$cod_type = " `id` in (select `sell_id` from `" . $cod_table . "`) and `shipped`='1'";
		} else if ($type == 'cod_pending') {
			$cod_type = " `id` in (select `sell_id` from `" . $cod_table . "`) and `shipped`='0'";
		} else if ($type == 'non_cod') {
			$cod_type = " `id` not in (select `sell_id` from `" . $cod_table . "`)";
		} else if ($type == 'non_cod_shipped') {
			$cod_type = " `id` not in (select `sell_id` from `" . $cod_table . "`) and `shipped`='1'";
		} else if ($type == 'non_cod_pending') {
			$cod_type = " `id` not in (select `sell_id` from `" . $cod_table . "`) and `shipped`='0'";
		} else if ($type == 'all_shipped') {
			$cod_type = " `shipped`='1'";
		} else if ($type == 'all_pending') {
			$cod_type = " `shipped`='0'";
		}
		if (strlen($cod_type) > 1) {
			$cod_type_where = " where" . $cod_type;
			$cod_type = " and" . $cod_type;
		}

$tempdatebetween_arr = dateBetween('addedon');
		$datebetween = $tempdatebetween_arr[1];
		$datebetween_all = $tempdatebetween_arr[0];
		if (strlen($datebetween_all) > 1) {
			$datebetween_all = " where" . $datebetween_all;
		}
		$datebetween .= $cod_type;
		if (isset($_GET['sell_id'])) {
			$provided_sell_id = $mysqli->real_escape_string(cf_enc($_GET['sell_id'], 'decrypt'));
			$datebetween .= " and `id`=" . $provided_sell_id;
		}

$countsql = "select count(`id`) as totaloptins from `" . $table . "` where 1" . $datebetween;
		$baseurl = "";
		$extrafields = 0;
		$total = 0;

$total_qry = $mysqli->query($countsql);
		if ($total_qry) {
			if ($res = $total_qry->fetch_object()) {
				$total = $res->totaloptins;
			}
		}

if ($pagecount == 0) {
			$sql = "select * from `" . $table . "` where `parent`='0'" . $datebetween . " order by id desc limit " . $limit . "";
		} else {
			$pagecount = ($pagecount * 10) - 10;

$sql = "select * from `" . $table . "` where `parent`='0'" . $datebetween . " order by `id` desc limit " . $pagecount . ", " . $limit . "";
		}

if (is_numeric($funnel_id)) {
			$countsql = "select count(`id`) as totaloptins from `" . $table . "` where productid='" . $funnel_id . "'" . $datebetween;
			$total_qry = $mysqli->query($countsql);
			if ($total_qry) {
				if ($res = $total_qry->fetch_object()) {
					$total = $res->totaloptins;
				}
			}
			if ($pagecount == 0) {
				$sql = "select * from `" . $table . "` where productid='" . $funnel_id . "'" . $datebetween . " order by `id` desc limit " . $limit . "";
			} else {
				$pagecount = ($pagecount * 10) - 10;
				$sql = "select * from `" . $table . "` where productid='" . $funnel_id . "'" . $datebetween . " order by `id` desc limit " . $pagecount . ", " . $limit . "";
			}
		}

if (strlen($search) > 0) {
			$search = $mysqli->real_escape_string($search);
			if (is_numeric($funnel_id)) {
				$sql = "select * from `" . $table . "` where productid='" . $funnel_id . "' and (paymentmethod like '%" . $search . "%' or payment_id like '%" . $search . "%' or shippingdetail like '%" . $search . "%' or purchase_name like '%" . $search . "%' or purchase_email like '%" . $search . "%')" . $cod_type . " order by id desc";
			} else {
				$sql = "select * from `" . $table . "` where (paymentmethod like '%" . $search . "%' or payment_id like '%" . $search . "%' or shippingdetail like '%" . $search . "%' or purchase_name like '%" . $search . "%' or purchase_email like '%" . $search . "%')" . $cod_type . " order by id desc";
			}
		}

$qry = $mysqli->query($sql);

return array('sales' => $qry, 'total' => $total, 'extracols' => $extrafields);
	}

$id = $mysqli->real_escape_string($id);
		$qry = $mysqli->query("select `shipped` from `" . $table . "` where `id`=" . $id . "");
		$done = 0;
		if ($qry->num_rows) {
			$r = $qry->fetch_object();
			$shipped = 1;
			if ($r->shipped == '1') {
				$shipped = 0;
			}

if ($mysqli->query("update `" . $table . "` set `shipped`='" . $shipped . "' where id='" . $id . "'")) {
				++$done;
				$date = date('Y-m-d H:i:s');
				$signed_by = $_SESSION['user' . get_option('site_token')];
				$ip = getIP();

$mysqli->query("update " . $cod_table . " set `status`=" . $shipped . ",`signed_by`=" . $signed_by . ", `last_ip`='" . $ip . "' where `sell_id`=" . $id . "");
			}
		}
		return $done;
	}

function exportToCSV($productid = 0)
	{
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$table = $pref . "all_sales";

if ($productid !== 0) {
			$productid = $mysqli->real_escape_string($productid);
		}

if ($productid > 0) {
			$sql = "select * from `" . $table . "` where `productid`='" . $productid . "' order by `id` desc";
		} else {
			$sql = "select * from `" . $table . "` order by `id` desc";
		}

$qry = $mysqli->query($sql);

$csv_fields = array();
		$csv_fields[] = '#';
		$csv_fields[] = 'Product';
		$csv_fields[] = 'Purchase Id';
		$csv_fields[] = 'Payer Name';
		$csv_fields[] = 'Payer Email';
		$csv_fields[] = 'Payment Method';
		$csv_fields[] = 'Shipping Detail';
		$csv_fields[] = 'Shipped';
		$csv_fields[] = 'Parent Product';
		$csv_fields[] = 'Date';

$output_filename = 'sales.csv';
		$output_handle = @fopen('php://output', 'w');

header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
		header('Content-Description: File Transfer');
		header('Content-type: text/csv');
		header('Content-Disposition: attachment; filename=' . $output_filename);
		header('Expires: 0');
		header('Pragma: public');

fputcsv($output_handle, $csv_fields);

if ($qry->num_rows > 0) {
			$count = 0;
			while ($r = $qry->fetch_assoc()) {
				++$count;
				$outputrray = array($count);
				$product = self::getProduct($r['productid']);
				array_push($outputrray, "(#" . $product->productid . ")" . $product->title);
				array_push($outputrray, $r['payment_id']);
				array_push($outputrray, $r['purchase_name']);
				array_push($outputrray, $r['purchase_email']);
				$paymentmethod_link = get_option('install_url');
				$paymentmethod_link .= "/index.php?page=payment_methods&payid=" . $r['payment_id'];
				array_push($outputrray, $paymentmethod_link);

$tempshippingdetail = (array)json_decode($r['shippingdetail']);
				$shippingdetail = "";
				foreach ($tempshippingdetail as $index => $data) {
					$shippingdetail = $index . ": " . $data . "\n";
				}
				array_push($outputrray, $shippingdetail);
				$r['shipped'] = ($r['shipped'] == '1') ? 'Yes' : 'No';
				array_push($outputrray, $r['shipped']);
				$parent = "N/A";
				if ($r['parent'] != '0') {
					$parentproduct_ob = self::getSale($r['parent']);
					if ($parentproduct_ob) {
						$parentproduct_ob = self::getProduct($parentproduct_ob->productid);
						if ($parentproduct_ob) {
							$parent = "(#" . $parentproduct_ob->productid . ") " . $parentproduct_ob->title;
						}
					}
				}
				array_push($outputrray, $parent);
				array_push($outputrray, date('d-M-Y h:ia', $r['addedon']));
				fputcsv($output_handle, $outputrray);
			}
		}
		fclose($output_handle);
		die();
	}
	function cancelorConfirmSalesAndMembership($id)
	{
		$mysqli = $this->mysqli;
		$pref = $this->dbpref;
		$id = $mysqli->real_escape_string($id);
		$sales_table = $pref . "all_sales";
		$members_table = $pref . "quick_member";
		$domembership_cancel = get_option('qfnl_cancel_membership_withsales');
		$table = $pref . "all_sales";

$sales = $mysqli->query("select `membership`,`valid` from `" . $sales_table . "` where `id`=" . $id . "");

if ($r = $sales->fetch_object()) {
			$valid = ($r->valid == '1') ? '0' : '1';

$mysqli->query("update `" . $sales_table . "` set valid='" . $valid . "' where `id`=" . $id . "");
			if ($domembership_cancel == '1') {
				$verifycode = time();
				$verifycode .= substr(str_shuffle('asdfghjklqwertyuiopzxcvbnm1234567890'), 0, 5);

$mysqli->query("update `" . $members_table . "` set valid='" . $valid . "',`verifycode`='" . $verifycode . "' where `id` in(" . $r->membership . ")");
			}
		}
		return 1;
	}
}