Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/india.duvinn.com/public_html/api

Free Space:

3.63 TB

🔧 Quick Actions

✏️ Editing: functions0.php

<?php 
error_reporting(0);
include('config.php');
class Main{
	public $store_name = STORE_NAME;
	public $site_url = STORE_URL;
	public $config_store_id = STORE_ID;
	public $currency_id = CURRENCY_ID;
	public $currency_code = CURRENCY_CODE;
	public $parent_id = PARENT_ID;
	public $banner_id = BANNER_ID;
	public $config_language_id = LANGUAGE_ID;
	public $module_product_limit = MODULE_PRODUCT_LIMIT;
	public $config_customer_group_id = CUSTOMER_GROUP_ID;
	
	public function getSlideBanner() {
		$query = " SELECT CONCAT('image/', b.image) as image FROM " . DB_PREFIX . "banner_image b  WHERE b.banner_id = '" . (int)$this->banner_id . "' ORDER BY b.sort_order";	 
		$db = new SQL();							
		$categories = $db->ExecuteQuery($query,'select');	 
		if(!empty($categories)){
			return $categories;
		}
		else
			return 0;
	}
	 
	public function getLatestProducts($customer_id,$session_id) {	
		  $query =  "SELECT p.product_id, p.quantity, CONCAT('image/cache/', p.image) as image, 
				FORMAT(p.price,2) as price, pd.name FROM " . DB_PREFIX . "product p 
						LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) 
						LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON (p.product_id = p2c.product_id) 
							WHERE pd.language_id = '" . (int)$this->config_language_id . "' AND p.status = 1
							GROUP BY p.product_id ORDER BY p.date_added DESC LIMIT " . (int)$this->module_product_limit;

$db = new SQL();							
		$products = $db->ExecuteQuery($query,'select');

for($i=0; $i<count($products); $i++){
			$products[$i]['image'] = $this->site_url.'/'.preg_replace('/(\.gif|\.jpg|\.jpeg|\.png)/', '-300x300$1', $products[$i]['image']);
			$res_product_special = $this->getProductSpecial($products[$i]['product_id']);
			if(isset($res_product_special) && !empty($res_product_special)){
				$products[$i]['special_price'] = $res_product_special[0]['price'];
			}
	
    $res_product_wish = $this->getProductWishlist($products[$i]['product_id'], $customer_id,$session_id);
  			if(isset($res_product_wish) && !empty($res_product_wish)){
    				$products[$i]['wish'] = 1;
    			} else {
    			    $products[$i]['wish'] = 0;
    			}
            
		}
		if(!empty($products)){
			return $products;
		}
		else
			return 0;
	}

public function getBusinessCategories(){
        $query = " SELECT business_category_id, business_category_name FROM si_business_category 
							WHERE status = '1' 
							ORDER BY sort_order";	         
		$db = new SQL();                            
        $result = $db->ExecuteQuery($query,'select');   
        return $result;
    }

public function getCategories($parent_id=0) {

// print_r($parent_id);
		// exit();

$query = " SELECT c.category_id, cd.name,CONCAT('image/', c.image) as image FROM " . DB_PREFIX . "category c 
						LEFT JOIN " . DB_PREFIX . "category_description cd ON (c.category_id = cd.category_id) 
						LEFT JOIN " . DB_PREFIX . "category_to_store c2s ON (c.category_id = c2s.category_id) 
							WHERE ";
		if($parent_id){
			$query .= "c.parent_id = '" . (int)$parent_id . "'";
		}else{
			$query .= "c.parent_id = '" . (int)$this->parent_id . "'";
		}
		 
		$query .= "AND cd.language_id = '" . (int)$this->config_language_id . "' 
								AND c2s.store_id = '" . (int)$this->config_store_id . "'  
								AND c.status = '1' 
								
									ORDER BY c.sort_order, LCASE(cd.name)";	 
		$db = new SQL();							
		$categories = $db->ExecuteQuery($query,'select');	 
		
		
		$categorie_list = array();
		if(!empty($categories)){
			foreach($categories as $key => $val){
				$sub_category_list = $this->get_subcategory($val['category_id']);
				$parent = 0;
						
				if(isset($sub_category_list) && $sub_category_list[0]['total']){
					$parent = 1;
				}
				$categorie_list[] = array(
					'category_id' => $val['category_id'],
					'name' => $val['name'],
					'image' => $val['image'],
					'parent' => $parent
				);	
			}
			
			return $categorie_list;
		}
		else
			return 0;
			
		
	}

public function getProductSpecial($product_id) {
		$date = date('Y-m-d');
		$query =  "SELECT * FROM " . DB_PREFIX . "product_special 
					WHERE product_id = '".$product_id."'  AND (date_start <= '".$date."' OR date_start ='0000-00-00') AND (date_end >= '".$date."' OR  date_end ='0000-00-00') LIMIT 1";	
		$db = new SQL();							
		$customer = $db->ExecuteQuery($query,'select');
		if(!empty($customer)){
			return $customer;
		}
		else{
			return false;
		}
	}

// Attribute API added on 2021-08-12 by Ramesh
	public function getProductAttribute($product_id) {

$query =  "SELECT oc_attribute_description.attribute_id,oc_attribute_group_description.name FROM oc_attribute LEFT JOIN oc_product_attribute ON oc_product_attribute.attribute_id = oc_attribute.attribute_id LEFT JOIN oc_attribute_description ON oc_attribute_description.attribute_id = oc_attribute.attribute_id LEFT JOIN oc_attribute_group ON oc_attribute_group.attribute_group_id = oc_attribute.attribute_group_id LEFT JOIN oc_attribute_group_description ON oc_attribute_group_description.attribute_group_id=oc_attribute.attribute_group_id WHERE oc_product_attribute.product_id = '" . (int)$product_id . "' AND oc_product_attribute.language_id =1 AND oc_attribute_group_description.language_id=1 AND oc_attribute_description.language_id =1 GROUP BY oc_attribute_group_description.name";	
		$db = new SQL();							
		$customer = $db->ExecuteQuery($query,'select');
		if(!empty($customer)){
			return $customer;
		}
		else{
			return false;
		}
	}

// Attribute API added on 2021-08-12 by Ramesh
	public function getProductAttributes($product_id) {
		$query =  "SELECT oc_attribute_description.attribute_id,oc_attribute_description.name AS description,oc_product_attribute.text FROM oc_attribute LEFT JOIN oc_product_attribute ON oc_product_attribute.attribute_id = oc_attribute.attribute_id LEFT JOIN oc_attribute_description ON oc_attribute_description.attribute_id = oc_attribute.attribute_id LEFT JOIN oc_attribute_group ON oc_attribute_group.attribute_group_id = oc_attribute.attribute_group_id LEFT JOIN oc_attribute_group_description ON oc_attribute_group_description.attribute_group_id=oc_attribute.attribute_group_id WHERE oc_product_attribute.product_id = '" . (int)$product_id . "' AND oc_product_attribute.language_id =1 AND oc_attribute_group_description.language_id=1 AND oc_attribute_description.language_id =1";	
		$db = new SQL();							
		$customer = $db->ExecuteQuery($query,'select');
		if(!empty($customer)){
			return $customer;
		}
		else{
			return false;
		}
	}

public function getProductWishlist($product_id, $customer_id, $session_id) {

$sess_cus = '';

if ($customer_id == 0) {
			$sess_cus = 'session_id = "'.$session_id.'"';
		}else{
			$sess_cus = 'customer_id = "'.(int)$customer_id.'"';
		}

$query =  "SELECT * FROM " . DB_PREFIX . "customer_wishlist 
    					WHERE $sess_cus AND product_id = '".$product_id."' LIMIT 1";

$db = new SQL();

$customer = $db->ExecuteQuery($query,'select');

if(!empty($customer)){
    			return $customer;
    		} else{
    			return false;
    		}
		
	}

public function getProductReview($product_id) {
		$query =  "SELECT author," . DB_PREFIX . "review.text,rating,date_added FROM " . DB_PREFIX . "review 
					WHERE product_id = '".$product_id."' AND status = 1";	
		$db = new SQL();							
		$customer = $db->ExecuteQuery($query,'select');
		if(!empty($customer)){
			return $customer;
		}
		else{
			return false;
		}
	}
	public function getProductRating($product_id) {
		$query =  "SELECT AVG(rating) AS rating, COUNT(*) AS total FROM " . DB_PREFIX . "review 
					WHERE product_id = '".$product_id."' AND status = 1 GROUP BY product_id";	
		$db = new SQL();							
		$customer = $db->ExecuteQuery($query,'select');
		if(!empty($customer)){
			return $customer;
		}
		else{
			return false;
		}
	}

public function getProductRelated($product_id){
		$query = "SELECT p.product_id, pd.name,p.price, CONCAT('image/cache/', p.image) as image FROM " . DB_PREFIX . "product_related pr LEFT JOIN " . DB_PREFIX . "product p ON (pr.related_id = p.product_id) LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id)
			LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) 
			 WHERE pr.product_id = '" . (int)$product_id . "' AND p.status = '1' AND p.date_available <= NOW() group by pr.related_id ";

$db = new SQL();							
		$products = $db->ExecuteQuery($query,'select');
		if(!empty($products)){
			return $products;
		}
		else{
			return false;
		}
	}

// 	public function getProductRelatedDetails($product_id, $customer_id){

// 		$query = "SELECT p.product_id, pd.name,p.price, CONCAT('image/cache/', p.image) as image FROM " . DB_PREFIX . "product_related pr LEFT JOIN " . DB_PREFIX . "product p ON (pr.related_id = p.product_id) LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id)
// 			LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) 
// 			 WHERE pr.product_id = '" . (int)$product_id . "' AND p.status = '1' AND p.date_available <= NOW() group by pr.related_id ";

// 		$db = new SQL();							
// 		$products = $db->ExecuteQuery($query,'select');

// 		if(!empty($products)) 
// 		{
// 			$x = 0;
// 			foreach($products as $key => $val){
// 				$spl_price = $this->getProductSpecial($val['product_id']);
// 				if(!empty($spl_price)){
// 					$products[$x]['spl_price'] = $spl_price[0]['price'];
// 				} else {
// 					$products[$x]['spl_price'] = 0 ;
// 				}
// 				$wish_list = $this->getProductWishlist($val['product_id'], $customer_id);
// 				if(!empty($wish_list)){
// 					// $products[$x]['wish_list'] = $wish_list[0]['wish_list_id'];
// 					$products[$x]['wish_list'] = 1 ;
// 				} else {
// 					$products[$x]['wish_list'] = 0 ;
// 				}
// 				$x = $x + 1;
// 			}
// 			return $products;
// 		}
// 		else{
// 			return false;
// 		}

// 	}

public function getProductRelatedDetails($product_id, $customer_id,$session_id){

$sess_cus = '';
		if ($data['customer_id'] == 0) {
			$sess_cus = 'session_id = "'.$data['session_id'].'"';
		}else{
			$sess_cus = 'customer_id = "'.(int)$data['customer_id'].'"';
		}

$query = "SELECT p.product_id, pd.name,p.price, CONCAT('image/cache/', p.image) as image FROM " . DB_PREFIX . "product_related pr LEFT JOIN " . DB_PREFIX . "product p ON (pr.related_id = p.product_id) LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id)
			LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) 
			 WHERE pr.product_id = '" . (int)$product_id . "' AND p.status = '1' AND p.date_available <= NOW() group by pr.related_id ";

$db = new SQL();							
		$products = $db->ExecuteQuery($query,'select');

if(!empty($products)) 
		{
			$x = 0;
			foreach($products as $key => $val){
				$spl_price = $this->getProductSpecial($val['product_id']);
				if(!empty($spl_price)){
					$products[$x]['spl_price'] = $spl_price[0]['price'];
				} else {
					$products[$x]['spl_price'] = 0 ;
				}
				$wish_list = $this->getProductWishlist($val['product_id'], $customer_id,$session_id);
				if(!empty($wish_list)){
					// $products[$x]['wish_list'] = $wish_list[0]['wish_list_id'];
					$products[$x]['wish'] = 1 ;
				} else {
					$products[$x]['wish'] = 0 ;
				}
				$x = $x + 1;
			}
			return $products;
		}
		else{
			return false;
		}

}

public function getPagesList() {
		$query =  "SELECT information_id, title, sort_order FROM " . DB_PREFIX . "information_description 
								WHERE language_id = 1 order by sort_order asc";	
		$db = new SQL();							
		$content = $db->ExecuteQuery($query,'select');
		if(!empty($content)){
			return $content;
		}
		else{
			return false;
		}
	}	
	
    public function getPageContent($page_id) {
		$query =  "SELECT * FROM " . DB_PREFIX . "information_description 
								WHERE information_id = '".$page_id."'";	
		$db = new SQL();							
		$content = $db->ExecuteQuery($query,'select');
		if(!empty($content)){
			return $content;
		}
		else{
			return false;
		}
	}

public function get_subcategory($category_id) {
		$query =  "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "category 
								WHERE parent_id = '".$category_id."'				
								AND status = '1'";	
		$db = new SQL();							
		$customer = $db->ExecuteQuery($query,'select');
		if(!empty($customer)){
			return $customer;
		}
		else{
			return false;
		}
	}

public function getSizeChart() {
		$query =  "SELECT name FROM " . DB_PREFIX . "filter_description 
								WHERE upper(name) >= 'A' and `filter_group_id` = 3 and language_id = 1 order by name asc";	
		$db = new SQL();							
		$content = $db->ExecuteQuery($query,'select');
		if(!empty($content)){
			return $content;
		}
		else{
			return false;
		}
	}

public function getColorList() {
		$query =  "SELECT name FROM " . DB_PREFIX . "filter_description 
								WHERE filter_group_id = 1 AND language_id = 1 order by name asc";	
		$db = new SQL();							
		$content = $db->ExecuteQuery($query,'select');
		if(!empty($content)){
			return $content;
		}
		else{
			return false;
		}
	}

public function getTimeOfDelivery() {
		$query =  "SELECT time_of_delivery_id, name FROM " . DB_PREFIX . "time_of_delivery
								order by sort_order asc";	
		$db = new SQL();							
		$content = $db->ExecuteQuery($query,'select');
		if(!empty($content)){
			return $content;
		}
		else{
			return false;
		}
	}

// NEW FUNCTION CREATED DT:27-09-2021
	
	public function addRecentview($product_id, $customer_id,$session_id) {
		$sess_cus = '';
		if ($customer_id == 0) {
			//echo "string";
			$sess_cus = 'session_id = "'.$session_id.'"';
		}else{
			//echo "string12";
			$sess_cus = 'customer_id = "'.(int)$customer_id.'"';
		}

$query = "SELECT * FROM " . DB_PREFIX . "recently_viewed WHERE product_id = '" . (int)$product_id. "' AND session_id ='".$session_id."'";
		$db = new SQL();
		$recent_pro = $db->ExecuteQuery($query,'select');

if ($recent_pro[0]['product_id']) {
			// echo "string1";
			
		}else{

$sql = "INSERT INTO " . DB_PREFIX . "recently_viewed SET $sess_cus, product_id = '" . (int)$product_id . "', date_added = NOW()";
		$db = new SQL();
		$add_wish = $db->ExecuteQuery($sql,'insert');

}
	
		if ($recent_pro) {
			return true;
		} else {
			return false;
		}
	}

// NEW FUNCTION CREATED DT:27-09-2021

public function getRecentlyviewProductDetails($customer_id, $session_id){
		$sess_cus = '';
		if ($data['customer_id'] == 0) {
			$sess_cus = 'session_id = "'.$session_id.'"';
		}else{
			$sess_cus = 'customer_id = "'.(int)$customer_id.'"';
		}
		
				$query =  "SELECT p.product_id, p.quantity, CONCAT('image/cache/', p.image) as image, 
				FORMAT(p.price,2) as price, pd.name FROM " . DB_PREFIX . "product p 
						LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) 
						LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON (p.product_id = p2c.product_id)
						LEFT JOIN " . DB_PREFIX . "recently_viewed cw ON (p.product_id = cw.product_id)
							WHERE $sess_cus  AND p.status = 1
							GROUP BY p.product_id ORDER BY p.date_added DESC LIMIT " . (int)$this->module_product_limit;	
	$db = new SQL();							
		$products = $db->ExecuteQuery($query,'select');

for($i=0; $i<count($products); $i++){
			$res_product_special = $this->getProductSpecial($products[$i]['product_id']);
			$products[$i]['image'] = $this->site_url.'/'.preg_replace('/(\.gif|\.jpg|\.jpeg|\.png)/', '-300x300$1', $products[$i]['image']);			
			if(isset($res_product_special) && !empty($res_product_special)){
				$products[$i]['special_price'] = $res_product_special[0]['price'];
			}
           $products[$i]['product_wish'] = 1;
		}

if(!empty($products)){
			return $products;
		}
		else{
			return 0;
		}
		
	}

public function send_sms_OLD($mobile,$message)
  {
    $request = "username=".SMS_API_USERNAME."&api_password=".SMS_API_PASSWORD."&sender=".SMS_API_SENDER."&to=".$mobile."&message=".$message."&priority=".SMS_API_PRIORITY;
    $ch = curl_init(SMS_API_URL);

curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

curl_setopt($ch, CURLOPT_POST, true);

curl_setopt($ch, CURLOPT_POSTFIELDS, $request);

$resuponce=curl_exec($ch);

curl_close($ch);

return $resuponce;

}

function UpdateCustomerFirebaseToken($data){
		$query =  "UPDATE " . DB_PREFIX . "customer SET firebase_token = '".$data['firebase_token']."' WHERE customer_id = '".$data['customer_id']."'";

$db = new SQL();							
		$status = $db->ExecuteQuery($query,'update');
		if($status){
			return $status;
		}
		else{
			return false;
		}
	}

function updateOrderTransactionCode($data){
		$order_id = $data['order_id'];

$query =  "INSERT INTO " . DB_PREFIX . "order_history (
						`order_id`, `order_status_id`, `comment`, `date_added`
						) VALUES (
						'" .(int)$order_id. "', '1', 'Order Through Mobile APP. Payment Success with Transaction Ref : ".$data['transaction_code']."', NOW())";	
		$db = new SQL();							
		$order_history_id = $db->ExecuteQuery($query,'insert');			
		if(!empty($order_history_id)){
    		$query2 =  "UPDATE " . DB_PREFIX . "order SET `order_status_id` = '1' WHERE order_id = '" . (int)$order_id . "'";	
    		$db = new SQL();							
    		$order_status = $db->ExecuteQuery($query2,'update');

return $order_history_id;
		} else {
			return 0;
		}		
		
		
		
	}
	function updateOrderStatus($data){
		$query =  "UPDATE " . DB_PREFIX . "order SET order_status_id = '".$data['status_id']."', comment = '".$data['comment']."' WHERE order_id = '".$data['order_id']."'";

$db = new SQL();							
		$status = $db->ExecuteQuery($query,'update');
		if($status){
			if($data['status_id'] == '7'){
					 $query2 =  "SELECT order_id,firstname,lastname, telephone FROM " . DB_PREFIX . "order  WHERE order_id = '" . (int)$data['order_id'] . "'";	
		    		$db = new SQL();							
		    		$order_info = $db->ExecuteQuery($query2,'select');
		    		//debug($order_info);
		    		//exit;
		    		//$order_info[0]['telephone'] = 7502973484;
		    		$name = $order_info[0]['firstname'].' '.$order_info[0]['lastname'];
		    	  $res = send_sms('order_cancel_by_customer',$order_info[0]['telephone'],array($order_info[0]['order_id']));
                  //$res = send_sms('order_cancel_by_customer',$order_info[0]['telephone'],array($name,$order_info[0]['order_id']));
		    	  //debug($res); exit;
				}
			return $status;
		}
		else{
			return false;
		}
	}

public function updateCustomerPasswordByEmail($email) {

$salt = substr(md5(uniqid(rand(), true)), 0, 9);
			$password = mt_rand(100000,999999);
			$saltpassword = sha1($salt . sha1($salt . sha1($password)));

$query =  "UPDATE " . DB_PREFIX . "customer 
					SET salt = '" . $salt . "', 
					password = '".$saltpassword."' 
						WHERE email = '" . $email . "'";
			$db = new SQL();
			$customer = $db->ExecuteQuery($query,'update');

if(!empty($customer)){
				$to = $email;
				$subject = "GM Fashions - New Password";
				$message = "
					<html>
						<head>
							<title>GM Fashions - New Password</title>
						</head>
						<body>
							<p>A new password was requested from GM Fashions.</p>
							<table>
								<tr>
									<th>Email</th>
									<td>".$email ."</td>
								</tr>
								<tr>
									<th>Password</th>
									<td>".$password."</td>
								</tr>
							</table>
						</body>
					</html>
				";

// Always set content-type when sending HTML email
				$headers = "MIME-Version: 1.0" . "\r\n";
				$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
				
				// More headers
				$headers .= 'From: GM Fashions<info@gmfashions.in>' . "\r\n";
				//debug($message);
				$res = mail($to, $subject, $message, $headers);
				//debug($res); exit; 
				if($res){
					return 1;
				}else{
					return 0;
				}
			}
			else
				return 0;
	}

public function updateCustomerPasswordByMobileNo($mobileno) {
		
			$salt = substr(md5(uniqid(rand(), true)), 0, 9);
			$password = mt_rand(100000,999999);
			$saltpassword = sha1($salt . sha1($salt . sha1($password)));

$query =  "UPDATE " . DB_PREFIX . "customer 
					SET salt = '" . $salt . "', 
					password = '".$saltpassword."' 
						WHERE telephone = '" . $mobileno . "'";
			$db = new SQL();
			$customer = $db->ExecuteQuery($query,'update');

if(!empty($customer)){
	           // echo 'Infunc - If';
				// echo 'SMS '.$mobileno.' '.$password;
				$result = $this->send_sms('change_pwd',$mobileno,array($mobileno,$password));
				return array($result);
			} else {
				// echo 'Infunc - Else';
				return 0;
			}
	}

// public function updateCustomerPasswordByMobileNo($telephone) {

//          $salt = substr(md5(uniqid(rand(), true)), 0, 9);
    //          $password = mt_rand(100000,999999);
    //          //$password = 123456; //mt_rand(100000,999999);
    //          $saltpassword = sha1($salt . sha1($salt . sha1($password)));
            
    //         $res = send_sms('change_pwd',$telephone, array($telephone,$password));
    //         // debug($res); exit;
    //         if (strpos($res, 'alert_') !== false) {
                
    //             $query =  "UPDATE " . DB_PREFIX . "customer 
    //             SET salt = '" . $salt . "', 
    //             password = '".$saltpassword."', 
    //             org_password = '".$password."' 
    //                 WHERE telephone = '" . $telephone . "'"; 
    //              $db = new SQL();
    //              $customer = $db->ExecuteQuery($query,'update');
    //              if($customer){
    //                 return 1;
    //              }else{
    //                 return 0;
    //              }
                
    //          }else{
    //             return 0;
    //          }
           
    // }
	
	
	public function updateUserPasswordByUserName($username) {

$salt = substr(md5(uniqid(rand(), true)), 0, 9);
			$password = mt_rand(100000,999999);
			$saltpassword = sha1($salt . sha1($salt . sha1($password)));

$query =  "UPDATE " . DB_PREFIX . "user 
					SET orgl_password = '" . $password . "', 
					salt = '" . $salt . "', 
					password = '".$saltpassword."' 
						WHERE username = '" . $username . "'";

$db = new SQL();
			$user = $db->ExecuteQuery($query,'update');

if(!empty($user)){
				$to = $username;
				$subject = "GM Fashions - New Password";
				$message = "
					<html>
						<head>
							<title>GM Fashions - New Password</title>
						</head>
						<body>
							<p>A new password was requested from GM Fashions.</p>
							<table>
								<tr>
									<th>Username</th>
									<td>".$username ."</td>
								</tr>
								<tr>
									<th>Password</th>
									<td>".$password."</td>
								</tr>
							</table>
						</body>
					</html>
				";

// Always set content-type when sending HTML email
				$headers = "MIME-Version: 1.0" . "\r\n";
				$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
				
				// More headers
				$headers .= 'From: GM Fashions<info@gmfashions.in>' . "\r\n";
				// debug($message);
				$res = mail($to, $subject, $message, $headers);
				//debug($res); exit; 
				if($res){
					return 1;
				}else{
					return 0;
				}
			}
			else
				return 0;
	}

public function updateCustomerProfile($customer_id, $firstname, $lastname, $email, $telephone) {
		$country_id = 99;
					
		$query =  "UPDATE " . DB_PREFIX . "customer SET 
						firstname = '" . $firstname . "',  lastname = '" . $lastname . "', email = '" . $email . "',
						telephone = '" . $telephone . "' WHERE customer_id = '" . (int)$customer_id . "'";				
		
		$db = new SQL();							
		//$db->ExecuteQuery($query,'update');	
		
		if($db->ExecuteQuery($query,'update')){
			// SMS Code STRATS Here
			$query2 =  "SELECT firstname,lastname,telephone FROM " . DB_PREFIX . "customer  WHERE customer_id = '". $customer_id ."'";	
			$db = new SQL();							
			$order_info = $db->ExecuteQuery($query2,'select');
			$telephone = $order_info[0]['telephone'];
			$name = $order_info[0]['firstname'].' '.$order_info[0]['lastname'];

$res = send_sms('change_profile',$telephone,array($name));
			// SMS Code ENDS Here
			return true;
		}
		else
			return false;
	}

public function getAddressList($customer_id){
		//$query =  "SELECT * FROM " . DB_PREFIX . "address 
		//						WHERE customer_id = '".$customer_id."'";	
		$query =  "SELECT a.*, cs.telephone, c.name AS country_name, z.name AS zone_name
							FROM " . DB_PREFIX . "address AS a
							LEFT JOIN " . DB_PREFIX . "customer AS cs ON cs.customer_id = a.customer_id
							LEFT JOIN " . DB_PREFIX . "country AS c ON c.country_id = a.country_id
							LEFT JOIN " . DB_PREFIX . "zone AS z ON z.zone_id = a.zone_id
								WHERE a.customer_id = '" . $customer_id . "'";
	
		$db = new SQL();							
		$customer = $db->ExecuteQuery($query,'select');
		if(!empty($customer)){
			return $customer;
		}
		else{
			return false;
		}
	}

public function updateDefaultAddress($customer_id,$address_id){
		$query =  "UPDATE " . DB_PREFIX . "customer SET address_id = '".$address_id."' 
								WHERE customer_id = '".$customer_id."'";	
		$db = new SQL();							
		$customer = $db->ExecuteQuery($query,'update');
		if(!empty($customer)){
			return $customer;
		}
		else{
			return false;
		}
	}
	
	public function deleteAddress($address_id){
		$query =  "DELETE FROM " . DB_PREFIX . "address  
								WHERE address_id = '".$address_id."'";	
		$db = new SQL();							
		$result = $db->ExecuteQuery($query,'delete');	
		return $result;
	}
	
	public function getAllProductsFromAllCategories($customer_id) {
		$query =  "SELECT p.product_id, p.quantity, CONCAT('image/cache/', p.image) as image, 
				p.price, pd.name FROM " . DB_PREFIX . "product p 
						LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) 
						LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON (p.product_id = p2c.product_id) 
							WHERE pd.language_id = '" . (int)$this->config_language_id . "' AND p.status = 1
									ORDER BY pd.name ASC";

$db = new SQL();							
		$products = $db->ExecuteQuery($query,'select');

for($i=0; $i<count($products); $i++){
			$products[$i]['image'] = $this->site_url.'/'.preg_replace('/(\.gif|\.jpg|\.jpeg|\.png)/', '-250x250$1', $products[$i]['image']);
			$res_product_special = $this->getProductSpecial($products[$i]['product_id']);
			if(isset($res_product_special) && !empty($res_product_special)){
				$products[$i]['special_price'] = $res_product_special[0]['price'];
			}
            if ($customer_id != 0){
    			$res_product_wish = $this->getProductWishlist($products[$i]['product_id'], $customer_id);
    			if(isset($res_product_wish) && !empty($res_product_wish)){
    				$products[$i]['product_wish'] = 1;
    			} else {
    			    $products[$i]['product_wish'] = 0;
    			}
            }
		}
		if(!empty($products)){
			return $products;
		}
		else
			return 0;
	}	
	
	public function getAllSpecialProductsFromAllCategories($customer_id) {
		$query =  "SELECT p.product_id, p.quantity, CONCAT('image/cache/', p.image) as image, 
				p.price, pd.name FROM " . DB_PREFIX . "product p 
						LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) 
						LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON (p.product_id = p2c.product_id) 
							WHERE pd.language_id = '" . (int)$this->config_language_id . "' 
									ORDER BY pd.name ASC";

$db = new SQL();							
		$products = $db->ExecuteQuery($query,'select');

for($i=0; $i<count($products); $i++){
			$products[$i]['image'] = $this->site_url.'/'.preg_replace('/(\.gif|\.jpg|\.jpeg|\.png)/', '-250x250$1', $products[$i]['image']);
			$res_product_special = $this->getProductSpecial($products[$i]['product_id']);
			if(isset($res_product_special) && !empty($res_product_special)){
				$products[$i]['special_price'] = $res_product_special[0]['price'];
			}
            if ($customer_id != 0){
    			$res_product_wish = $this->getProductWishlist($products[$i]['product_id'], $customer_id);
    			if(isset($res_product_wish) && !empty($res_product_wish)){
    				$products[$i]['product_wish'] = 1;
    			} else {
    			    $products[$i]['product_wish'] = 0;
    			}
            }
		}
		if(!empty($products)){
			return $products;
		}
		else
			return 0;
	}	
	
public function getProductsByCategoryId($category_id=0,$search_name='',$data,$customer_id=0,$session_id) 
	{
		$query =  "SELECT p.product_id, p.quantity, CONCAT('image/cache/', p.image) as image, p.price, pd.name FROM " . DB_PREFIX . "product p 
						LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) 
						LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON (p.product_id = p2c.product_id) 
							";
		if (!empty($data['filter_filter'])) {
			$query .= " LEFT JOIN " . DB_PREFIX . "product_filter pf ON (p2c.product_id = pf.product_id)";
		}

$query .= " WHERE pd.language_id = '" . (int)$this->config_language_id . "' AND p.status = 1";

if($category_id){					
			$query .= " AND p2c.category_id = '" . (int)$category_id . "'"; 
		}
		
		
		if(isset($search_name) && !empty($search_name)){						
			$implode = array();

$words = explode(' ', trim(preg_replace('/\s+/', ' ', $search_name)));

foreach ($words as $word) {
				$implode[] = "pd.name LIKE '%" . trim($word) . "%'";
			}

if ($implode) {
				$query .= " AND " . implode(" AND ", $implode) . "";
			}
		}

if (!empty($data['filter_category_id'])) {
			if (!empty($data['filter_sub_category'])) {
				$query .= " AND cp.path_id = '" . (int)$data['filter_category_id'] . "'";
			} else {
				$query .= " AND p2c.category_id = '" . (int)$data['filter_category_id'] . "'";
			}

if (!empty($data['filter_filter'])) {
				$implode = array();

$filters = explode(',', $data['filter_filter']);

foreach ($filters as $filter_id) {
					$implode[] = (int)$filter_id;
				}

$query .= " AND pf.filter_id IN (" . implode(',', $implode) . ")";
			}
		}

$query .= "ORDER BY pd.name ASC";
		
		$db = new SQL();							
		$products = $db->ExecuteQuery($query,'select');

for($i=0; $i<count($products); $i++){
			$products[$i]['image'] = $this->site_url.''.preg_replace('/(\.gif|\.jpg|\.jpeg|\.png)/', '-300x300$1', $products[$i]['image']);
			$res_product_special = $this->getProductSpecial($products[$i]['product_id']);
			if(isset($res_product_special) && !empty($res_product_special)){
				$products[$i]['special_price'] = $res_product_special[0]['price'];
			}
            
    			$res_product_wish = $this->getProductWish($customer_id, $products[$i]['product_id'],$session_id);
    			if(isset($res_product_wish) && !empty($res_product_wish)){
    				$products[$i]['wish'] = 1;
    			} else {
    				$products[$i]['wish'] = 0;
    			}
           
		}
		if(!empty($products)){
			return $products;
		}
		else
			return 0;
	}

// 	public function getProductDetails($product_id){
// 		$query =  "SELECT sc.image AS size_chart_image,sc.description AS size_chart_description, p.product_id, p.quantity, CONCAT('image/cache/', p.image) as image, 
// 				FORMAT(p.price,0) as price, pd.name, pd.description AS product_description FROM " . DB_PREFIX . "product p 
// 						LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) 
// 						LEFT JOIN " . DB_PREFIX . "size_chart sc ON (p.size_chart_id = sc.size_chart_id) 
// 						WHERE p.product_id = '" . (int)$product_id . "' AND pd.language_id = '" . (int)$this->config_language_id . "'";		
// 		$db = new SQL();							
// 		$products = $db->ExecuteQuery($query,'select');	
		
// 		for($i=0; $i<count($products); $i++){
// 			$products[$i]['image'] = $this->site_url.''.preg_replace('/(\.gif|\.jpg|\.jpeg|\.png)/', '-300x300$1', $products[$i]['image']);
// 		}
// 		if(!empty($products)){
// 			return $products;
// 		}		
// 		else
// 			return 0;
// 	}

Public function getProductDetails($product_id,$customer_id,$session_id){
        $query =  "SELECT sc.image AS size_chart_image,sc.description AS size_chart_description, p.product_id, p.quantity, CONCAT('image/cache/', p.image) as image, 
				FORMAT(p.price,0) as price, pd.name, pd.description AS product_description FROM " . DB_PREFIX . "product p 
						LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) 
						LEFT JOIN " . DB_PREFIX . "size_chart sc ON (p.size_chart_id = sc.size_chart_id) 
						WHERE p.product_id = '" . (int)$product_id . "' AND pd.language_id = '" . (int)$this->config_language_id . "'";

$db = new SQL();	
		$db->ExecuteQuery('SET character_set_results=utf8','update');							
		$products = $db->ExecuteQuery($query,'select');

for($i=0; $i<count($products); $i++){

//print_r($products);
			$products[$i]['image'] = $this->site_url.''.preg_replace('/(\.gif|\.jpg|\.jpeg|\.png)/', '-300x300$1', $products[$i]['image']);
		}

$res_recent_product = $this->addRecentview($product_id, $customer_id,$session_id);

if(!empty($products)){
			return $products;
		}		
		else
			return 0;
	}

Public function getBuyNowProductDetails($product_id){
        $query =  "SELECT sc.image AS size_chart_image,sc.description AS size_chart_description, p.product_id, p.quantity, CONCAT('image/cache/', p.image) as image, 
				FORMAT(p.price,0) as price, pd.name, pd.description AS product_description FROM " . DB_PREFIX . "product p 
						LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) 
						LEFT JOIN " . DB_PREFIX . "size_chart sc ON (p.size_chart_id = sc.size_chart_id) 
						WHERE p.product_id = '" . (int)$product_id . "' AND pd.language_id = '" . (int)$this->config_language_id . "'";

$db = new SQL();	
		$db->ExecuteQuery('SET character_set_results=utf8','update');							
		$products = $db->ExecuteQuery($query,'select');

for($i=0; $i<count($products); $i++){

//print_r($products);
			$products[$i]['image'] = $this->site_url.''.preg_replace('/(\.gif|\.jpg|\.jpeg|\.png)/', '-300x300$1', $products[$i]['image']);
		}

$res_recent_product = $this->addRecentview($product_id, $customer_id,$session_id);

if(!empty($products)){
			return $products;
		}		
		else
			return 0;
	}
	public function getProductImages($product_id){
// 		$query =  "SELECT  CONCAT('image/cache/', p.image) as image 
// 				 FROM " . DB_PREFIX . "product_image p 						
// 						WHERE p.product_id = '" . (int)$product_id . "' ORDER BY p.sort_order ASC";		
	    $query =  "SELECT  CONCAT('image/', p.image) as image 
				 FROM " . DB_PREFIX . "product_image p 						
						WHERE p.product_id = '" . (int)$product_id . "' ORDER BY p.sort_order ASC";		
		$db = new SQL();							
		$products = $db->ExecuteQuery($query,'select');	
// 		for($i=0; $i<count($products); $i++){
// 			$products[$i]['image'] = $this->site_url.''.preg_replace('/(\.gif|\.jpg|\.jpeg|\.png)/', '-300x300$1', $products[$i]['image']);
// 		}
		if(!empty($products)){
			return $products;
		} 
		else
			return 0;
	}
	
	public function getProductOptions($product_id){
		$product_option_data = array();

$product_option_query = "SELECT * FROM " . DB_PREFIX . "product_option po LEFT JOIN `" . DB_PREFIX . "option` o ON (po.option_id = o.option_id) LEFT JOIN " . DB_PREFIX . "option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '" . (int)$product_id . "' AND od.language_id = '" . (int)$this->config_language_id . "' ORDER BY o.sort_order";
		
		$db = new SQL();							
		$product_option = $db->ExecuteQuery($product_option_query,'select');
		
		foreach ($product_option as $product_option) {
			$product_option_value_data = array();

$product_option_value_query = "SELECT * FROM " . DB_PREFIX . "product_option_value pov LEFT JOIN " . DB_PREFIX . "option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN " . DB_PREFIX . "option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_id = '" . (int)$product_id . "' AND pov.product_option_id = '" . (int)$product_option['product_option_id'] . "' AND ovd.language_id = '" . (int)$this->config_language_id . "' ORDER BY ov.sort_order";
			
			$db = new SQL();							
			$product_option_value = $db->ExecuteQuery($product_option_value_query,'select');
		
			foreach ($product_option_value as $product_option_value) {
				if (!$option_value['subtract'] || ($option_value['quantity'] > 0)) {
					$product_option_value_data[] = array(
						'product_option_id'    => $product_option['product_option_id'],
						'product_option_value_id' => $product_option_value['product_option_value_id'],
						//'option_value_id'         => $product_option_value['option_value_id'],
						'name'                    => $product_option_value['name'],
						'image'                   => 'image/'.$product_option_value['image'],
						'quantity'                => $product_option_value['quantity'],
						'subtract'                => $product_option_value['subtract'],
						'price'                   => $product_option_value['price'],
						'price_prefix'            => $product_option_value['price_prefix'],
						'weight'                  => $product_option_value['weight'],
						'weight_prefix'           => $product_option_value['weight_prefix']
					);
				}
			}

$product_option_data[] = array(
				'product_option_id'    => $product_option['product_option_id'],				
				'option_id'            => $product_option['option_id'],
				'name'                 => $product_option['name'],
				'type'                 => $product_option['type'],
				'value'                => $product_option['value'],
				'required'             => $product_option['required'],
				'product_option_value' => $product_option_value_data,
			);
		}
		
		return $product_option_data;
	}
	
// public function getCustomerDetailsByEmail($email, $password,$session_id) {

// 		$query =  "SELECT customer_id, firstname, lastname, email, telephone, password, cart, address_id, firebase_token, firebase_user_id, ip, status, approved, date_added
// 							FROM " . DB_PREFIX . "customer 
// 								WHERE LOWER(email) = '" . strtolower($email) . "'
// 								AND (password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1('" . $password . "'))))) 
// 										OR password = '" . md5($password) . "')  				
// 								AND status = '1'
// 								AND approved = '1' ";
		
// 		$db = new SQL();							
// 		$customer = $db->ExecuteQuery($query,'select');

// 		foreach ($customer as $cart_2) {
// 					$customer_id = $cart_2['customer_id'];
// 				}

// 		//wishlist login session id value check customer id add //
// 		$wishlist_query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "customer_wishlist WHERE session_id = '" .$session_id. "'  ";
	
// 		$db = new SQL();							
// 		$result_wishlist = $db->ExecuteQuery($wishlist_query,'select');	
	
// 		$result_wishlist = $result_wishlist[0];
// 		if($result_wishlist['total']){
// 			$query =  "UPDATE `" . DB_PREFIX . "customer_wishlist` SET customer_id = '".$customer_id."'  WHERE session_id = '" . $session_id . "' ";
// 			$wishlist_id = $db->ExecuteQuery($query,'update');

// 			//return $wishlist_id;

// 			// print_r($query);
// 			// print_r($wishlist_id);
// 			// exit();					
// 		}

// 		$query1 =  "SELECT a.address_1,a.address_2,a.city,a.postcode,a.country_id,a.zone_id,c.name AS country_name,z.name AS zone_name
// 							FROM " . DB_PREFIX . "address AS a
// 							LEFT JOIN " . DB_PREFIX . "country AS c ON c.country_id = a.country_id
// 							LEFT JOIN " . DB_PREFIX . "zone AS z ON z.zone_id = a.zone_id
// 								WHERE a.address_id = '" . (int)$customer[0]['address_id'] . "'";
		
// 		$db = new SQL();							
// 		$address = $db->ExecuteQuery($query1,'select');
		
// 		if($customer){
// 			//$customer[0]['customer_id'] 	= $address[0]['customer_id'];
// 		/*	$customer[0]['address_2'] 	= $address[0]['address_2'];
// 			$customer[0]['city'] 		= $address[0]['city'];
// 			$customer[0]['postcode'] 	= $address[0]['postcode'];
// 			$customer[0]['zone_id'] 	= $address[0]['zone_id'];
// 			$customer[0]['zone'] 		= $address[0]['zone_name'];
// 			$customer[0]['country_id'] 	= $address[0]['country_id'];
// 			$customer[0]['country'] 	= $address[0]['country_name'];*/
// 			//$customer[0]['address_id'] 	= $address[0]['address_id'];
// 		}
// 		if(!empty($customer)){
// 			return $customer;
// 		}
// 		else
// 			return 0;
// 	}

//     public function getCustomerDetailsByEmail($email, $password,$session_id) {

// 		foreach ($customer as $cart_2) {
// 					$customer_id = $cart_2['customer_id'];
// 				}

// 			//return $wishlist_id;

// 			// print_r($query);
// 			// print_r($wishlist_id);
// 			// exit();					
// 		}

// 	public function getCustomerDetailsByEmail($email, $password,$session_id) {

// 		$cart_query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "cart WHERE session_id = '" .$session_id. "'  ";
	
// 		$db = new SQL();							
// 		$result_cart = $db->ExecuteQuery($cart_query,'select');	
	
// 		$result_cart = $result_cart[0];
// 		if($result_cart['total']){
// 			$query =  "UPDATE `" . DB_PREFIX . "cart` SET customer_id = '".$customer_id."'  WHERE session_id = '" . $session_id . "' ";
// 			$cart_id = $db->ExecuteQuery($query,'update');	
			
// 		}
// 		//wishlist login session id value check customer id add //
// 		$wishlist_query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "customer_wishlist WHERE session_id = '" .$session_id. "'  ";
	
// 		$db = new SQL();							
// 		$result_wishlist = $db->ExecuteQuery($wishlist_query,'select');	
	
// 		$result_wishlist = $result_wishlist[0];
// 		if($result_wishlist['total']){
// 			$query =  "UPDATE `" . DB_PREFIX . "customer_wishlist` SET customer_id = '".$customer_id."'  WHERE session_id = '" . $session_id . "' ";
// 			$wishlist_id = $db->ExecuteQuery($query,'update');	
// 		}

// 		//Recently View Product login session id value check customer id add //
// 		$recent_pro = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "recently_viewed WHERE session_id = '" .$session_id. "'  ";
	
// 		$db = new SQL();							
// 		$recent_pro_result = $db->ExecuteQuery($recent_pro,'select');	
	
// 		$recent_pro_result = $recent_pro_result[0];

// 		if($recent_pro_result['total']){
// 		$query =  "UPDATE `" . DB_PREFIX . "recently_viewed` SET customer_id = '".$customer_id."'  WHERE session_id = '" . $session_id . "' ";
// 		$recent_pro_id = $db->ExecuteQuery($query,'update');	
		
// 		}
// 		$query1 =  "SELECT a.address_1,a.address_2,a.city,a.postcode,a.country_id,a.zone_id,c.name AS country_name,z.name AS zone_name
// 							FROM " . DB_PREFIX . "address AS a
// 							LEFT JOIN " . DB_PREFIX . "country AS c ON c.country_id = a.country_id
// 							LEFT JOIN " . DB_PREFIX . "zone AS z ON z.zone_id = a.zone_id
// 								WHERE a.address_id = '" . (int)$customer[0]['address_id'] . "'";
		
// 		$db = new SQL();							
// 		$address = $db->ExecuteQuery($query1,'select');
		
// 		if($customer){
// 			}
// 		if(!empty($customer)){
// 			return $customer;
// 		}
// 		else
// 			return 0;
// 	}

public function getCustomerDetailsByEmail($email, $password,$session_id) {

$query =  "SELECT customer_id, firstname, lastname, email, telephone, password, cart, address_id, firebase_token, firebase_user_id, ip, status, approved, date_added
							FROM " . DB_PREFIX . "customer 
								WHERE LOWER(email) = '" . strtolower($email) . "'
								AND (password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1('" . $password . "'))))) 
										OR password = '" . md5($password) . "')  				
								AND status = '1'
								AND approved = '1' ";
		
		$db = new SQL();							
		$customer = $db->ExecuteQuery($query,'select');
		foreach ($customer as $cart_2) {
					$customer_id = $cart_2['customer_id'];
				}

$cart_query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "cart WHERE session_id = '" .$session_id. "'  ";
	
		$db = new SQL();							
		$result_cart = $db->ExecuteQuery($cart_query,'select');	
	
		$result_cart = $result_cart[0];
		if($result_cart['total']){
			$query =  "UPDATE `" . DB_PREFIX . "cart` SET customer_id = '".$customer_id."'  WHERE session_id = '" . $session_id . "' ";
			$cart_id = $db->ExecuteQuery($query,'update');	
			
		}

//wishlist login session id value check customer id add //
		$wishlist_query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "customer_wishlist WHERE session_id = '" .$session_id. "'  ";
	
		$db = new SQL();							
		$result_wishlist = $db->ExecuteQuery($wishlist_query,'select');	
	
		$result_wishlist = $result_wishlist[0];
		if($result_wishlist['total']){
			$query =  "UPDATE `" . DB_PREFIX . "customer_wishlist` SET customer_id = '".$customer_id."'  WHERE session_id = '" . $session_id . "' ";
			$wishlist_id = $db->ExecuteQuery($query,'update');

}

$save_for_later_query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "save_for_later WHERE session_id = '" .$session_id. "'  ";
	
		$db = new SQL();							
		$result_saveforlater = $db->ExecuteQuery($save_for_later_query,'select');	
	
		$result_saveforlater = $result_saveforlater[0];
		if($result_saveforlater['total']){
			$query =  "UPDATE `" . DB_PREFIX . "save_for_later` SET customer_id = '".$customer_id."'  WHERE session_id = '" . $session_id . "' ";
		$saveforlater_id = $db->ExecuteQuery($query,'update');	
	}

//Recently View Product login session id value check customer id add //
		$recent_pro = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "recently_viewed WHERE session_id = '" .$session_id. "'  ";
	
		$db = new SQL();							
		$recent_pro_result = $db->ExecuteQuery($recent_pro,'select');	
	
		$recent_pro_result = $recent_pro_result[0];

if($recent_pro_result['total']){
		$query =  "UPDATE `" . DB_PREFIX . "recently_viewed` SET customer_id = '".$customer_id."'  WHERE session_id = '" . $session_id . "' ";
		$recent_pro_id = $db->ExecuteQuery($query,'update');	
		
		}
		$query1 =  "SELECT a.address_1,a.address_2,a.city,a.postcode,a.country_id,a.zone_id,c.name AS country_name,z.name AS zone_name
							FROM " . DB_PREFIX . "address AS a
							LEFT JOIN " . DB_PREFIX . "country AS c ON c.country_id = a.country_id
							LEFT JOIN " . DB_PREFIX . "zone AS z ON z.zone_id = a.zone_id
								WHERE a.address_id = '" . (int)$customer[0]['address_id'] . "'";
		
		$db = new SQL();							
		$address = $db->ExecuteQuery($query1,'select');
		
		if($customer){
			}
		if(!empty($customer)){
			return $customer;
		}
		else
			return 0;
	}

// public function getCustomerDetailsByMobileNo($telephone, $password,$session_id) {

// 		$query =  "SELECT customer_id, firstname, lastname, email, telephone, password, cart, address_id, ip, status, approved, date_added
// 							FROM " . DB_PREFIX . "customer 
// 								WHERE LOWER(telephone) = '" . strtolower($telephone) . "'
// 								AND (password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1('" . $password . "'))))) 
// 										OR password = '" . md5($password) . "')  				
// 								AND status = '1'
// 								AND approved = '1' ";
		
// 		$db = new SQL();							
// 		$customer = $db->ExecuteQuery($query,'select');

// 		foreach ($customer as $cart_2) {
// 					$customer_id = $cart_2['customer_id'];
// 				}
// 		//print_r($cart_2['customer_id']);
// 		//exit();

// 		$cart_query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "cart WHERE session_id = '" .$session_id. "'  ";

// 		// print_r($cart_query);
// 		// exit();
	
// 		$db = new SQL();							
// 		$result_cart = $db->ExecuteQuery($cart_query,'select');	
	
// 		$result_cart = $result_cart[0];
// 		if($result_cart['total']){
// 			$query =  "UPDATE `" . DB_PREFIX . "cart` SET customer_id = '".$customer_id."'  WHERE session_id = '" . $session_id . "' ";
// 			$cart_id = $db->ExecuteQuery($query,'update');

// 			//return $cart_id;

// 			// print_r($query);
// 			// print_r($cart_id);
// 			// exit();					
// 		}

// 			//return $wishlist_id;

// 			// print_r($query);
// 			// print_r($wishlist_id);
// 			// exit();					
// 		}

// 		$query1 =  "SELECT a.address_1,a.address_2,a.city, a.postcode,a.country_id,a.zone_id,c.name AS country_name,z.name AS zone_name
// 							FROM " . DB_PREFIX . "address AS a
// 							LEFT JOIN " . DB_PREFIX . "country AS c ON c.country_id = a.country_id
// 							LEFT JOIN " . DB_PREFIX . "zone AS z ON z.zone_id = a.zone_id
// 								WHERE a.address_id = '" . (int)$customer[0]['address_id'] . "'";
		
// 		$db = new SQL();							
// 		$address = $db->ExecuteQuery($query1,'select');
		
// 		if($customer){
// 			//$customer[0]['customer_id'] 	= $address[0]['customer_id'];
// 		/*	$customer[0]['address_2'] 	= $address[0]['address_2'];
// 			$customer[0]['city'] 		= $address[0]['city'];*/
// 			$customer[0]['postcode'] 	= $address[0]['postcode'];
// 		/*	$customer[0]['zone_id'] 	= $address[0]['zone_id'];
// 			$customer[0]['zone'] 		= $address[0]['zone_name'];
// 			$customer[0]['country_id'] 	= $address[0]['country_id'];
// 			$customer[0]['country'] 	= $address[0]['country_name'];*/
// 			//$customer[0]['address_id'] 	= $address[0]['address_id'];
// 		}
// 		if(!empty($customer)){
// 			return $customer;
// 		}
// 		else
// 			return 0;
// 	}

// 	public function getCustomerDetailsByMobileNo($telephone, $password,$session_id) {

// 	//print_r($password);

// 		foreach ($customer as $cart_2) {
// 					$customer_id = $cart_2['customer_id'];
// 				}
// 		//print_r($cart_2['customer_id']);
// 		//exit();

// 		$cart_query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "cart WHERE session_id = '" .$session_id. "'  ";

// 			//return $cart_id;

// 			// print_r($query);
// 			// print_r($cart_id);
// 			// exit();					
// 		}

// 			//return $wishlist_id;

// 			// print_r($query);
// 			// print_r($wishlist_id);
// 			// exit();					
// 		}

// 		$query1 =  "SELECT a.address_1,a.address_2,a.city, a.postcode,a.country_id,a.zone_id,c.name AS country_name,z.name AS zone_name
// 							FROM " . DB_PREFIX . "address AS a
// 							LEFT JOIN " . DB_PREFIX . "country AS c ON c.country_id = a.country_id
// 							LEFT JOIN " . DB_PREFIX . "zone AS z ON z.zone_id = a.zone_id
// 								WHERE a.address_id = '" . (int)$customer[0]['address_id'] . "'";
		
// 		$db = new SQL();							
// 		$address = $db->ExecuteQuery($query1,'select');
		
// 		if($customer){
// 			//$customer[0]['customer_id'] 	= $address[0]['customer_id'];
// 		/*	$customer[0]['address_2'] 	= $address[0]['address_2'];
// 			$customer[0]['city'] 		= $address[0]['city'];*/
// 			$customer[0]['postcode'] 	= $address[0]['postcode'];
// 		/*	$customer[0]['zone_id'] 	= $address[0]['zone_id'];
// 			$customer[0]['zone'] 		= $address[0]['zone_name'];
// 			$customer[0]['country_id'] 	= $address[0]['country_id'];
// 			$customer[0]['country'] 	= $address[0]['country_name'];*/
// 			//$customer[0]['address_id'] 	= $address[0]['address_id'];
// 		}
// 		if(!empty($customer)){
// 			return $customer;
// 		}
// 		else
// 			return 0;
// 	}

// public function getCustomerDetailsByMobileNo($telephone, $password,$session_id) {
// 		$query =  "SELECT customer_id, firstname, lastname, email, telephone, password, cart, address_id, ip, status, approved, date_added
// 							FROM " . DB_PREFIX . "customer 
// 								WHERE LOWER(telephone) = '" . strtolower($telephone) . "'
// 								AND (password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1('" . $password . "'))))) 
// 										OR password = '" . md5($password) . "')  				
// 								AND status = '1'
// 								AND approved = '1' ";
		
// 		$db = new SQL();							
// 		$customer = $db->ExecuteQuery($query,'select');

// 		foreach ($customer as $cart_2) {
// 					$customer_id = $cart_2['customer_id'];
// 				}
// 		$cart_query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "cart WHERE session_id = '" .$session_id. "'  ";
// 		$db = new SQL();							
// 		$result_cart = $db->ExecuteQuery($cart_query,'select');	
	
// 		$result_cart = $result_cart[0];
// 		if($result_cart['total']){
// 			$query =  "UPDATE `" . DB_PREFIX . "cart` SET customer_id = '".$customer_id."'  WHERE session_id = '" . $session_id . "' ";
// 			$cart_id = $db->ExecuteQuery($query,'update');

// 		}

// 		}
// 		//Recently View Product login session id value check customer id add //
// 		$recent_pro = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "recently_viewed WHERE session_id = '" .$session_id. "'  ";
	
// 		$db = new SQL();							
// 		$recent_pro_result = $db->ExecuteQuery($recent_pro,'select');	
	
// 		$recent_pro_result = $recent_pro_result[0];

// 		if($recent_pro_result['total']){
// 		$query =  "UPDATE `" . DB_PREFIX . "recently_viewed` SET customer_id = '".$customer_id."'  WHERE session_id = '" . $session_id . "' ";
// 		$recent_pro_id = $db->ExecuteQuery($query,'update');	
		
// 		}
// 		$query1 =  "SELECT a.address_1,a.address_2,a.city, a.postcode,a.country_id,a.zone_id,c.name AS country_name,z.name AS zone_name
// 							FROM " . DB_PREFIX . "address AS a
// 							LEFT JOIN " . DB_PREFIX . "country AS c ON c.country_id = a.country_id
// 							LEFT JOIN " . DB_PREFIX . "zone AS z ON z.zone_id = a.zone_id
// 								WHERE a.address_id = '" . (int)$customer[0]['address_id'] . "'";
		
// 		$db = new SQL();							
// 		$address = $db->ExecuteQuery($query1,'select');
		
// 		if($customer){
// 				$customer[0]['postcode'] 	= $address[0]['postcode'];
// 			}
// 		if(!empty($customer)){
// 			return $customer;
// 		}
// 		else
// 			return 0;
// 	}

public function getCustomerDetailsByMobileNo($telephone, $password,$session_id) {
		$query =  "SELECT customer_id, firstname, lastname, email, telephone, password, cart, address_id, ip, status, approved, date_added
							FROM " . DB_PREFIX . "customer 
								WHERE LOWER(telephone) = '" . strtolower($telephone) . "'
								AND (password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1('" . $password . "'))))) 
										OR password = '" . md5($password) . "')  				
								AND status = '1'
								AND approved = '1' ";
	$db = new SQL();							
		$customer = $db->ExecuteQuery($query,'select');

foreach ($customer as $cart_2) {
					$customer_id = $cart_2['customer_id'];
				}
				$cart_query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "cart WHERE session_id = '" .$session_id. "'  ";
		$db = new SQL();							
		$result_cart = $db->ExecuteQuery($cart_query,'select');	
	
		$result_cart = $result_cart[0];
		if($result_cart['total']){
			$query =  "UPDATE `" . DB_PREFIX . "cart` SET customer_id = '".$customer_id."'  WHERE session_id = '" . $session_id . "' ";
			$cart_id = $db->ExecuteQuery($query,'update');

}

$query1 =  "SELECT a.address_1,a.address_2,a.city, a.postcode,a.country_id,a.zone_id,c.name AS country_name,z.name AS zone_name
							FROM " . DB_PREFIX . "address AS a
							LEFT JOIN " . DB_PREFIX . "country AS c ON c.country_id = a.country_id
							LEFT JOIN " . DB_PREFIX . "zone AS z ON z.zone_id = a.zone_id
								WHERE a.address_id = '" . (int)$customer[0]['address_id'] . "'";
		
		$db = new SQL();							
		$address = $db->ExecuteQuery($query1,'select');
		
		if($customer){
				$customer[0]['postcode'] 	= $address[0]['postcode'];
				}
		if(!empty($customer)){
			return $customer;
		}
		else
			return 0;
	}

public function addCust($name, $telephone) {

// 		if(!$this->customerAlreadyExistByMobileno($telephone)){
	
			$query =  "INSERT INTO " . DB_PREFIX . "customer (
							`firstname`, `telephone`, `date_added`
							) 
								VALUES (
									'".$name."', '".$telephone."', NOW())";	
		
			$db = new SQL();							
			$customer_id = $db->ExecuteQuery($query,'insert');	
			//exit;

// File Upload
            // if(isset($file['ssn_certificate']['name'][0]) && !empty($file['ssn_certificate']['name'][0])){

$fileName = $_FILES['ssn_certificate']['name'];

$filename_orgl = $this->upload_file($_FILES['ssn_certificate']['name'],$_FILES['ssn_certificate']['tmp_name'],'ssn_certificate');
                $ssn_certificate = str_replace("../uploads", "uploads", $filename_orgl);
            // }

$query =  "UPDATE `" . DB_PREFIX . "customer` SET ssn_certificate = '".$ssn_certificate."' WHERE customer_id = '".$customer_id."' ";
    		$db->ExecuteQuery($query,'update');	
            
            return true;
//     	} else{
// 			return false;
// 		}		
	}

public function addCustomer($name, $tradename,  $user_code, $business_category_id, $email, $telephone, $password,  $address, $city, $postcode, $session_id, $user_id=0) {
        // addCustomer($_POST['name'], $_POST['tradename'], $_POST['user_code'], $_POST['business_category_id'], $_POST['email'], $_POST['telephone'], $_POST['password'], $_POST['address'], $_POST['city'], $_POST['postcode'], $_POST['session_id'], $_POST['user_id'] );	
	
// 		if(!$this->customerAlreadyExistByEmail($email)){
		if(!$this->customerAlreadyExistByMobileno($telephone)){
	
	// If the customer directly signup with USER_CODE
	        if($user_id == 0 && !empty($user_code)){
				$userqry =  "SELECT user_id FROM ".DB_PREFIX."user
				WHERE user_code = = '". $user_code ."'";
				$db = new SQL();							
				$user_info = $db->ExecuteQuery($userqry,'select');
				$user_id = $user_info[0]['user_id'];	            
	        } else {
	            $user_id=0;
	        }
	
			$salt = substr(md5(uniqid(rand(), true)), 0, 9);
			$query =  "INSERT INTO " . DB_PREFIX . "customer (
							`customer_group_id`, `store_id`, `firstname`, `tradename`, `user_code`,
							`email`, `telephone`, `fax`, `password`, 
							`salt`, `wishlist`, `newsletter`, 
							`address_id`, `custom_field`, `ip`, `status`, 
							`approved`, `safe`, `token`, ref_user_id, `date_added`
							) 
								VALUES (
									'1', '0', '".$name."', '".$tradename."', '".$user_code."', 
									'".strtolower($email)."', '".$telephone."', '', '".sha1($salt . sha1($salt . sha1($password)))."', 
									'".$salt."',  NULL, '0', 
									'0', '', '', '1', 
									'1', '', '', $user_id, NOW())";	
		
			$db = new SQL();							
			$customer_id = $db->ExecuteQuery($query,'insert');	
			//exit;

// File Upload
            $fileName = $_FILES['ssn_certificate']['name'];
            
            // if(isset($file['ssn_certificate']['name']) && !empty($file['ssn_certificate']['name'])){
            //     $filename_orgl = $this->upload_file($_FILES['ssn_certificate']['name'],$_FILES['ssn_certificate']['tmp_name'],'ssn_certificate');
            //     $ssn_certificate = str_replace("../uploads", "uploads", $filename_orgl);
            // }

if(isset($fileName) && !empty($fileName)){	            
                $filename_orgl = $this->upload_file($fileName,$_FILES['ssn_certificate']['tmp_name'],'ssn_certificate');
                $ssn_certificate = str_replace("../uploads", "uploads", $filename_orgl);
            }

$query =  "UPDATE `" . DB_PREFIX . "customer` SET ssn_certificate = '".$ssn_certificate."' WHERE customer_id = '".$customer_id."' ";
    		$db->ExecuteQuery($query,'update');

$cart_query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "cart WHERE session_id = '" .$session_id. "'  ";

$db = new SQL();							
    		$result_cart = $db->ExecuteQuery($cart_query,'select');	
    	
    		$result_cart = $result_cart[0];
    		if($result_cart['total']){
    			$query =  "UPDATE `" . DB_PREFIX . "cart` SET customer_id = '".$customer_id."'  WHERE session_id = '" . $session_id . "' ";
    			$cart_id = $db->ExecuteQuery($query,'update');	
    		}
    
    		//wishlist login session id value check customer id add //
    		$wishlist_query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "customer_wishlist WHERE session_id = '" .$session_id. "'  ";
    	
    		$db = new SQL();							
    		$result_wishlist = $db->ExecuteQuery($wishlist_query,'select');	
    	
    		$result_wishlist = $result_wishlist[0];
    		if($result_wishlist['total']){
    			$query =  "UPDATE `" . DB_PREFIX . "customer_wishlist` SET customer_id = '".$customer_id."'  WHERE session_id = '" . $session_id . "' ";
    			$wishlist_id = $db->ExecuteQuery($query,'update');	
    		}
    		$query1 =  "INSERT INTO " . DB_PREFIX . "address 
    							SET customer_id = '" . (int)$customer_id . "', firstname = '" . $firstname . "', 
    								company = '" . $tradename . "', address_1 = '" . $address. "', city = '" . $city . "', postcode = '" . $postcode . "', custom_field = ''";
    
    			$db = new SQL();							
    			$address_id = $db->ExecuteQuery($query1,'insert');
    			
    			$query2 =  "UPDATE " . DB_PREFIX . "customer SET address_id = '" . (int)$address_id . "' WHERE customer_id = '" . (int)$customer_id . "'";
    			$db = new SQL();							
    			$customer = $db->ExecuteQuery($query2,'update');
    			
    			$result['customer_id'] = $customer_id;
    			$result['address_id'] = $address_id;
    
    		
    			if(!empty($customer)){
    				// send_sms('registration_success',$telephone,array($firstname.' '.$tradename));
    				// return array($result);
    			}
    			else
    				return 0;
    		}
		else{
			
			return false;
		}		
	}

public function addAddress($customer_id, $firstname, $lastname, $email, $telephone, $address_1, $address_2, $city, $postcode, $zone_id, $country_id,$default=0) {
		if($customer_id){
			
			$query1 =  "INSERT INTO " . DB_PREFIX . "address 
							SET customer_id = '" . (int)$customer_id . "', firstname = '" . $firstname . "', 
								lastname = '" . $lastname . "', company = '', 
								address_1 = '" . $address_1 . "', address_2 = '" . $address_2 . "', 
								city = '" . $city . "', postcode = '" . $postcode . "', 
								country_id = '" . (int)$country_id . "', zone_id = '" . (int)$zone_id . "', 
								custom_field = ''";
			$db = new SQL();							
			$address_id = $db->ExecuteQuery($query1,'insert');
			$result['address_id'] = $address_id;

if($default){
				$query2 =  "UPDATE " . DB_PREFIX . "customer SET address_id = '" . (int)$address_id . "' WHERE customer_id = '" . (int)$customer_id . "'";
				$db = new SQL();							
				$customer = $db->ExecuteQuery($query2,'update');
			}
			//$result['customer_id'] = $customer_id;
			$result['address_id'] = $address_id;
	
			if(!empty($address_id)){
				return array($result);
			} else {
				return 0;
			}

} else{
			return false;
		}		
	}

public function updateAddress($address_id,$customer_id, $firstname, $lastname, $telephone, $address_1, $address_2, $city, $postcode, $zone_id, $country_id,$default=0) {

if($customer_id){
			$query1 =  "UPDATE " . DB_PREFIX . "address 
							SET firstname = '" . $firstname . "', 
								lastname = '" . $lastname . "', telephone = '" . $telephone . "', company = '', 
								address_1 = '" . $address_1 . "', address_2 = '" . $address_2 . "', 
								city = '" . $city . "', postcode = '" . $postcode . "',  zone_id = '" . (int)$zone_id . "',
								country_id = '" . (int)$country_id . "' WHERE address_id = '".$address_id."'";
			$db = new SQL();							
			$address_id = $db->ExecuteQuery($query1,'update');
			$result['address_id'] = $address_id;

// SMS Code STRATS HERE
				$query2 =  "SELECT addr.*,cntry.name as country_name,zn.name as zone_name, cstm.telephone as telephone FROM ".DB_PREFIX."address as addr
				LEFT JOIN ".DB_PREFIX."country as cntry ON addr.country_id = cntry.country_id
				LEFT JOIN ".DB_PREFIX."customer as cstm ON addr.customer_id = cstm.customer_id
				LEFT JOIN ".DB_PREFIX."zone as zn ON addr.zone_id = zn.zone_id
				WHERE addr.address_id = '". $address_id ."'";
				$db = new SQL();							
				$order_info = $db->ExecuteQuery($query2,'select');
				$telephone = $order_info[0]['telephone'];
				$name = $order_info[0]['firstname'].' '.$order_info[0]['lastname'];
				$address = '';

$address .= $order_info[0]['address_1']." , ";
				if($order_info[0]['address_2'])
					$address .= $order_info[0]['address_2']." , ";

$address .= $order_info[0]['city']." , ";
				$address .= $order_info[0]['zone_name']." , ";
				$address .= $order_info[0]['country_name']." , ";				
				$address .= "Pinode - ".$order_info[0]['postcode'];
				$res = send_sms('change_addr',$telephone,array($name,$address));
				// SMS Code ENDS HERE

return array($result);
			} else {
				return 0;
			}

} else{
			return false;
		}		
	}

// 	public function updateAddress($customer_id, $address_id,$firstname, $lastname, $email, $telephone, $password,  $address_1, $address_2, $city, $postcode, $zone_id,$country_id,$default=0) {
// 		if($customer_id){
// // 			$query1 =  "UPDATE " . DB_PREFIX . "address 
// // 							SET customer_id = '" . (int)$customer_id . "', firstname = '" . $firstname . "', 
// // 								lastname = '" . $lastname . "', company = '', 
// // 								address_1 = '" . $address_1 . "', address_2 = '" . $address_2 . "', 
// // 								city = '" . $city . "', postcode = '" . $postcode . "', 
// // 								country_id = '" . (int)$country_id . "', zone_id = '" . (int)$zone_id . "', 
// // 								custom_field = '' WHERE address_id = '".$address_id."'";
// 			$query1 =  "UPDATE " . DB_PREFIX . "address 
// 							SET firstname = '" . $firstname . "', 
// 								lastname = '" . $lastname . "', company = '', 
// 								address_1 = '" . $address_1 . "', address_2 = '" . $address_2 . "', 
// 								city = '" . $city . "', postcode = '" . $postcode . "', 
// 								country_id = '" . (int)$country_id . "', zone_id = '" . (int)$zone_id . "', 
// 								custom_field = '' WHERE address_id = '".$address_id."'";
// 			$db = new SQL();							
// 			$address_id = $db->ExecuteQuery($query1,'insert');
// 			if($default){
// 				$query2 =  "UPDATE " . DB_PREFIX . "customer SET address_id = '" . (int)$address_id . "' WHERE customer_id = '" . (int)$customer_id . "'";
// 				$db = new SQL();							
// 				$customer = $db->ExecuteQuery($query2,'update');
// 			}
// 			//$result['customer_id'] = $customer_id;
// 			$result['address_id'] = $address_id;
	
// 			if(!empty($address_id)){
// 				return array($result);
// 			}
// 			else
// 				return 0;
// 		}
// 		else{
// 			return false;
// 		}		
// 	}

public function updateCustomer($customer_id, $firstname, $lastname, $email, $telephone, $address_1, $address_2, $city, $postcode, $country) {
		$country_id = 99;
								
		$query =  "UPDATE " . DB_PREFIX . "customer SET 
						firstname = '" . $firstname . "',  lastname = '" . $lastname . "', email = '" . $email . "',
						telephone = '" . $telephone . "' WHERE customer_id = '" . (int)$customer_id . "'";				
		
		$db = new SQL();							
		$db->ExecuteQuery($query,'update');	
		
		$query1 =  "UPDATE " . DB_PREFIX . "address SET 
						firstname = '" . $firstname . "', lastname = '" . $lastname . "', address_1 = '" . $address_1 . "', 
						address_2 = '" . $address_2 . "', city = '" . $city . "', postcode = '" . $postcode . "', 
						country_id = '" . (int)$country_id . "', zone_id = '" . (int)$zone_id . "' 
						WHERE customer_id = '" . (int)$customer_id . "'";		
		$db = new SQL();

if($db->ExecuteQuery($query1,'update')){
			return true;
		}
		else
			return false;
	}
	
	public function updateCartQty($cart_id, $qty) {
										
		$query =  "UPDATE " . DB_PREFIX . "cart SET quantity= '" . $qty . "' WHERE cart_id = '".(int)$cart_id ."'";				
		
		$db = new SQL();

if($db->ExecuteQuery($query,'update')){
			return true;
		}
		else
			return false;
	}
	
	
	
	
	public function customerAlreadyExistByEmail($email) {
		$query =  "SELECT email FROM " . DB_PREFIX . "customer 
								WHERE LOWER(email) = '" . strtolower($email) . "'				
								AND status = '1'
								AND approved = '1' ";	
		$db = new SQL();							
		$customer = $db->ExecuteQuery($query,'select');
		if(!empty($customer)){
			return true;
		}
		else{
			return false;
		}
	}

// public function getDailyQuotes() {
	// 	$query =  "SELECT * FROM " . DB_PREFIX . "review WHERE  date_added = '".date('Y-m-d')."' AND status = '1' ORDER BY review_id ";

// 	// print_r($query);
	// 	// exit();
	// 	$db = new SQL();							
	// 	$country = $db->ExecuteQuery($query,'select');
	// 	if(!empty($country)){
	// 		return $country;
	// 	}
	// 	else{
	// 		return false;
	// 	}
	// }
	
	public function getCountry() {
		$query =  "SELECT country_id,name FROM " . DB_PREFIX . "country 
								WHERE 				
								status = '1'
								ORDER BY name ";	
		$db = new SQL();							
		$country = $db->ExecuteQuery($query,'select');
		if(!empty($country)){
			return $country;
		}
		else{
			return false;
		}
	}
	public function getState($country_id) {
		$query =  "SELECT zone_id,name FROM " . DB_PREFIX . "zone 
								WHERE country_id = '".$country_id."'				
								AND status = '1'
								ORDER BY name ";	
		$db = new SQL();							
		$zone = $db->ExecuteQuery($query,'select');
		if(!empty($zone)){
			return $zone;
		}
		else{
			return false;
		}
	}
	
	public function getCustomerDetailsByCustomerId($customer_id) {

$query =  "SELECT customer_id, firstname, lastname, email, telephone, password, cart, address_id, ip, status, approved, date_added
							FROM " . DB_PREFIX . "customer 
								WHERE customer_id = '" . $customer_id . "'				
								AND status = '1'
								AND approved = '1' ";
		
		$db = new SQL();							
		$customer = $db->ExecuteQuery($query,'select');
		
		$query1 =  "SELECT a.address_1,a.address_2,a.city,a.postcode,a.country_id,a.zone_id,c.name AS country_name,z.name AS zone_name
							FROM " . DB_PREFIX . "address AS a
							LEFT JOIN " . DB_PREFIX . "country AS c ON c.country_id = a.country_id
							LEFT JOIN " . DB_PREFIX . "zone AS z ON z.zone_id = a.zone_id
								WHERE a.address_id = '" . (int)$customer[0]['address_id'] . "'";
		
		$db = new SQL();							
		$address = $db->ExecuteQuery($query1,'select');
		
		if($customer){
			$customer[0]['address_1'] 	= $address[0]['address_1'];
			$customer[0]['address_2'] 	= $address[0]['address_2'];
			$customer[0]['city'] 		= $address[0]['city'];
			$customer[0]['postcode'] 	= $address[0]['postcode'];
			$customer[0]['zone_id'] 	= $address[0]['zone_id'];
			$customer[0]['zone'] 		= $address[0]['zone_name'];
			$customer[0]['country_id'] 	= $address[0]['country_id'];
			$customer[0]['country'] 	= $address[0]['country_name'];
		}
		if(!empty($customer)){
			return $customer;
		}
		else
			return 0;
	} 
	
// 		public function AddToCart($data){

// 		$sess_cus = '';
// 		if ($data['customer_id'] == 0) {
// 			$sess_cus = 'session_id = "'.$data['session_id'].'"';
// 		}else{
// 			$sess_cus = 'customer_id = "'.(int)$data['customer_id'].'"';
// 		}
		
// 		$cart_query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "cart WHERE '" . $sess_cus. "'  AND product_id = '" . (int)$data['product_id'] . "'  AND `option` = '" . json_encode($data['option']) . "'";
		
// 		$db = new SQL();							
// 		$result_cart = $db->ExecuteQuery($cart_query,'select');	
		
// 		$result_cart = $result_cart[0];
	
// 		if($result_cart['total']){
// 			$query =  "UPDATE `" . DB_PREFIX . "cart` SET quantity = (quantity + " . (int)$data['quantity'] . ")
// 							WHERE $sess_cus  AND product_id = '" . (int)$data['product_id'] . "' AND `option` = '" . json_encode($data['option']) . "'";
// 			$cart_id = $db->ExecuteQuery($query,'update');						
// 		}else{
// 			$query =  "INSERT INTO `" . DB_PREFIX . "cart` SET $sess_cus , product_id = '" . (int)$data['product_id'] . "', `option` = '" . json_encode($data['option']) . "', quantity = '" . (int)$data['quantity'] . "', date_added = '".date('Y-m-d H:i:s')."'";
							
// 			$cart_id = $db->ExecuteQuery($query,'insert');					
// 		}
			
			
// 		if(!empty($cart_id)){
// 			return true;
// 		}
// 		else
// 			return false;					
// 	}

// 	public function AddToCart($data){

// 		$db = new SQL();							
// 		$result_cart = $db->ExecuteQuery($cart_query,'select');	
		
// 		$result_cart = $result_cart[0];

// 		if($result_cart['total']){
// 			$query =  "UPDATE `" . DB_PREFIX . "cart` SET quantity = (quantity + " . (int)$data['quantity'] . ")
// 							WHERE $sess_cus  AND product_id = '" . (int)$data['product_id'] . "' AND `option` = '" . json_encode($data['option']) . "'";

// 			$cart_id = $db->ExecuteQuery($query,'update');						
// 		}else{
// 			$query =  "INSERT INTO `" . DB_PREFIX . "cart` SET $sess_cus , product_id = '" . (int)$data['product_id'] . "', `option` = '" . json_encode($data['option']) . "', quantity = '" . (int)$data['quantity'] . "', date_added = '".date('Y-m-d H:i:s')."'";

// 			$cart_id = $db->ExecuteQuery($query,'insert');					
// 		}
			
			
// 		if(!empty($cart_id)){
// 			return true;
// 		}
// 		else
// 			return false;					
// 	}

public function AddToCart($data){

$sess_cus = '';
		if ($data['customer_id'] == 0) {
			$sess_cus = 'session_id = "'.$data['session_id'].'"';
		}else{
			$sess_cus = 'customer_id = "'.(int)$data['customer_id'].'"';
		}
		
		$cart_query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "cart WHERE  $sess_cus AND product_id = '" . (int)$data['product_id'] . "'  AND `option` = '" . json_encode($data['option']) . "'";

$db = new SQL();							
		$result_cart = $db->ExecuteQuery($cart_query,'select');	
		
		$result_cart = $result_cart[0];

//print_r($result_cart['total']);

if($result_cart['total']){
			$query =  "UPDATE `" . DB_PREFIX . "cart` SET quantity = (quantity + " . (int)$data['quantity'] . ")
							WHERE $sess_cus  AND product_id = '" . (int)$data['product_id'] . "' AND `option` = '" . json_encode($data['option']) . "'";

$cart_id = $db->ExecuteQuery($query,'update');						
		}else{
			$query =  "INSERT INTO `" . DB_PREFIX . "cart` SET $sess_cus , product_id = '" . (int)$data['product_id'] . "', `option` = '" . json_encode($data['option']) . "', quantity = '" . (int)$data['quantity'] . "', date_added = '".date('Y-m-d H:i:s')."'";

$cart_id = $db->ExecuteQuery($query,'insert');					
		}

// print_r($query);
		// exit();
			
			
		if(!empty($cart_id)){
			return true;
		}
		else
			return false;					
	}

public function customerAlreadyExistByMobileno($mobileno) {
		$query =  "SELECT telephone FROM " . DB_PREFIX . "customer 
								WHERE telephone = '" . (int)$mobileno . "'				
								AND status = '1'
								AND approved = '1' ";	
		$db = new SQL();							
		$customer = $db->ExecuteQuery($query,'select');
		if(!empty($customer)){
			return true;
		}
		else{
			return false;
		}
	}

function getCart($data) {

//$customer_id = $data['customer_id'];

$sess_cus = '';
		if ($data['customer_id'] == 0) {
			$sess_cus = 'session_id = "'.$data['session_id'].'"';
		}else{
			$sess_cus = 'customer_id = "'.(int)$data['customer_id'].'"';
		}

$product_data = array();

$cart_query = "SELECT * FROM " . DB_PREFIX . "cart WHERE  $sess_cus ";
		
		$db = new SQL();							
		$cart = $db->ExecuteQuery($cart_query,'select');	
		
		
			
		foreach ($cart as $cart) {

$stock = true;

$product_query = "SELECT * FROM " . DB_PREFIX . "product_to_store p2s LEFT JOIN " . DB_PREFIX . "product p ON (p2s.product_id = p.product_id) LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) WHERE p2s.store_id = '" . (int)$this->config_store_id . "' AND p2s.product_id = '" . (int)$cart['product_id'] . "' AND pd.language_id = '" . (int)$this->config_language_id . "' AND p.date_available <= NOW() AND p.status = '1'";

$product_query = $db->ExecuteQuery($product_query,'select');
			$product_query = $product_query[0];

if ($product_query && ($cart['quantity'] > 0)) {
				$option_price = 0;
				$option_points = 0;
				$option_weight = 0;

$option_data = array();

foreach (json_decode($cart['option']) as $product_option_id => $value) {
					$option_query = "SELECT po.product_option_id, po.option_id, od.name, o.type FROM " . DB_PREFIX . "product_option po LEFT JOIN `" . DB_PREFIX . "option` o ON (po.option_id = o.option_id) LEFT JOIN " . DB_PREFIX . "option_description od ON (o.option_id = od.option_id) WHERE po.product_option_id = '" . (int)$product_option_id . "' AND po.product_id = '" . (int)$cart['product_id'] . "' AND od.language_id = '" . (int)$this->config_language_id . "'";
					
								
					$option_query = $db->ExecuteQuery($option_query,'select');
					$option_query = $option_query[0];	
									
					if ($option_query) {
						if ($option_query['type'] == 'select' || $option_query['type'] == 'radio' || $option_query['type'] == 'image') {
							$option_value_query = "SELECT pov.option_value_id, ovd.name, pov.quantity, pov.subtract, pov.price, pov.price_prefix, pov.points, pov.points_prefix, pov.weight, pov.weight_prefix FROM " . DB_PREFIX . "product_option_value pov LEFT JOIN " . DB_PREFIX . "option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN " . DB_PREFIX . "option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_option_value_id = '" . (int)$value . "' AND pov.product_option_id = '" . (int)$product_option_id . "' AND ovd.language_id = '" . (int)$this->config_language_id . "'";
							
							$option_value_query = $db->ExecuteQuery($option_value_query,'select');
							$option_value_query = $option_value_query[0];
							if ($option_value_query) {
								if ($option_value_query['price_prefix'] == '+') {
									$option_price += $option_value_query['price'];
								} elseif ($option_value_query['price_prefix'] == '-') {
									$option_price -= $option_value_query['price'];
								}

if ($option_value_query['points_prefix'] == '+') {
									$option_points += $option_value_query['points'];
								} elseif ($option_value_query['points_prefix'] == '-') {
									$option_points -= $option_value_query['points'];
								}

if ($option_value_query['weight_prefix'] == '+') {
									$option_weight += $option_value_query['weight'];
								} elseif ($option_value_query['weight_prefix'] == '-') {
									$option_weight -= $option_value_query['weight'];
								}

if ($option_value_query['subtract'] && (!$option_value_query['quantity'] || ($option_value_query['quantity'] < $cart['quantity']))) {
									$stock = false;
								}

$option_data[] = array(
									'product_option_id'       => $product_option_id,
									'product_option_value_id' => $value,
									'option_id'               => $option_query['option_id'],
									'option_value_id'         => $option_value_query['option_value_id'],
									'name'                    => $option_query['name'],
									'value'                   => $option_value_query['name'],
									'type'                    => $option_query['type'],
									'quantity'                => $option_value_query['quantity'],
									'subtract'                => $option_value_query['subtract'],
									'price'                   => $option_value_query['price'],
									'price_prefix'            => $option_value_query['price_prefix'],
									'points'                  => $option_value_query['points'],
									'points_prefix'           => $option_value_query['points_prefix'],
									'weight'                  => $option_value_query['weight'],
									'weight_prefix'           => $option_value_query['weight_prefix']
								);
							}
						} elseif ($option_query['type'] == 'checkbox' && is_array($value)) {
							foreach ($value as $product_option_value_id) {
								$option_value_query = "SELECT pov.option_value_id, ovd.name, pov.quantity, pov.subtract, pov.price, pov.price_prefix, pov.points, pov.points_prefix, pov.weight, pov.weight_prefix FROM " . DB_PREFIX . "product_option_value pov LEFT JOIN " . DB_PREFIX . "option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN " . DB_PREFIX . "option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_option_value_id = '" . (int)$product_option_value_id . "' AND pov.product_option_id = '" . (int)$product_option_id . "' AND ovd.language_id = '" . (int)$this->config_language_id . "'";
								
								$option_value_query = $db->ExecuteQuery($option_value_query,'select');
								$option_value_query = $option_value_query[0];
								if ($option_value_query) {
									if ($option_value_query['price_prefix'] == '+') {
										$option_price += $option_value_query['price'];
									} elseif ($option_value_query['price_prefix'] == '-') {
										$option_price -= $option_value_query['price'];
									}

if ($option_value_query['points_prefix'] == '+') {
										$option_points += $option_value_query['points'];
									} elseif ($option_value_query['points_prefix'] == '-') {
										$option_points -= $option_value_query['points'];
									}

if ($option_value_query['weight_prefix'] == '+') {
										$option_weight += $option_value_query['weight'];
									} elseif ($option_value_query['weight_prefix'] == '-') {
										$option_weight -= $option_value_query['weight'];
									}

if ($option_value_query['subtract'] && (!$option_value_query['quantity'] || ($option_value_query['quantity'] < $cart['quantity']))) {
										$stock = false;
									}

$option_data[] = array(
										'product_option_id'       => $product_option_id,
										'product_option_value_id' => $product_option_value_id,
										'option_id'               => $option_query['option_id'],
										'option_value_id'         => $option_value_query['option_value_id'],
										'name'                    => $option_query['name'],
										'value'                   => $option_value_query['name'],
										'type'                    => $option_query['type'],
										'quantity'                => $option_value_query['quantity'],
										'subtract'                => $option_value_query['subtract'],
										'price'                   => $option_value_query['price'],
										'price_prefix'            => $option_value_query['price_prefix'],
										'points'                  => $option_value_query['points'],
										'points_prefix'           => $option_value_query['points_prefix'],
										'weight'                  => $option_value_query['weight'],
										'weight_prefix'           => $option_value_query['weight_prefix']
									);
								}
							}
						} elseif ($option_query['type'] == 'text' || $option_query['type'] == 'textarea' || $option_query['type'] == 'file' || $option_query['type'] == 'date' || $option_query['type'] == 'datetime' || $option_query['type'] == 'time') {
							$option_data[] = array(
								'product_option_id'       => $product_option_id,
								'product_option_value_id' => '',
								'option_id'               => $option_query['option_id'],
								'option_value_id'         => '',
								'name'                    => $option_query['name'],
								'value'                   => $value,
								'type'                    => $option_query['type'],
								'quantity'                => '',
								'subtract'                => '',
								'price'                   => '',
								'price_prefix'            => '',
								'points'                  => '',
								'points_prefix'           => '',
								'weight'                  => '',
								'weight_prefix'           => ''
							);
						}
					}
				}

$price = $product_query['price'];
				$mrp_price = $product_query['price'];
				//$selling_price = $product_query['selling_price'];

// Product Discounts
				$discount_quantity = 0;

$cart_2_query = "SELECT * FROM " . DB_PREFIX . "cart WHERE  '" . $sess_cus . "'";
				
				$cart_2_query = $db->ExecuteQuery($cart_2_query,'select');
				
				foreach ($cart_2_query as $cart_2) {
					if ($cart_2['product_id'] == $cart['product_id']) {
						$discount_quantity += $cart_2['quantity'];
					}
				}

$product_discount_query = "SELECT price FROM " . DB_PREFIX . "product_discount WHERE product_id = '" . (int)$cart['product_id'] . "' AND customer_group_id = '" . (int)$this->config_customer_group_id . "' AND quantity <= '" . (int)$discount_quantity . "' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY quantity DESC, priority ASC, price ASC LIMIT 1";
				
				$product_discount_query = $db->ExecuteQuery($product_discount_query,'select');
				$product_discount_query = $product_discount_query[0];
				
				if ($product_discount_query) {
					$price = $product_discount_query['price'];
				}

// Product Specials
				$product_special_query = "SELECT price FROM " . DB_PREFIX . "product_special WHERE product_id = '" . (int)$cart['product_id'] . "' AND customer_group_id = '" . (int)$this->config_customer_group_id . "' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1";
				
				$product_special_query = $db->ExecuteQuery($product_special_query,'select');
				$product_special_query = $product_special_query[0];
				
				if ($product_special_query) {
					$price = $product_special_query['price'];
				}

// Reward Points
				$product_reward_query = "SELECT points FROM " . DB_PREFIX . "product_reward WHERE product_id = '" . (int)$cart['product_id'] . "' AND customer_group_id = '" . (int)$this->config_customer_group_id . "'";
				
				$product_reward_query = $db->ExecuteQuery($product_reward_query,'select');
				$product_reward_query = $product_reward_query[0];
				
				if ($product_reward_query) {
					$reward = $product_reward_query['points'];
				} else {
					$reward = 0;
				}

// Downloads
				$download_data = array();

$download_query = "SELECT * FROM " . DB_PREFIX . "product_to_download p2d LEFT JOIN " . DB_PREFIX . "download d ON (p2d.download_id = d.download_id) LEFT JOIN " . DB_PREFIX . "download_description dd ON (d.download_id = dd.download_id) WHERE p2d.product_id = '" . (int)$cart['product_id'] . "' AND dd.language_id = '" . (int)$this->config_language_id . "'";
				
				$download_query = $db->ExecuteQuery($download_query,'select');
				
				
				foreach ($download_querys as $download) {
					$download_data[] = array(
						'download_id' => $download['download_id'],
						'name'        => $download['name'],
						'filename'    => $download['filename'],
						'mask'        => $download['mask']
					);
				}

// Stock
				if (!$product_query['quantity'] || ($product_query['quantity'] < $cart['quantity'])) {
					$stock = false;
				}

$recurring_query = "SELECT * FROM " . DB_PREFIX . "recurring r LEFT JOIN " . DB_PREFIX . "product_recurring pr ON (r.recurring_id = pr.recurring_id) LEFT JOIN " . DB_PREFIX . "recurring_description rd ON (r.recurring_id = rd.recurring_id) WHERE r.recurring_id = '" . (int)$cart['recurring_id'] . "' AND pr.product_id = '" . (int)$cart['product_id'] . "' AND rd.language_id = " . (int)$this->config_language_id . " AND r.status = 1 AND pr.customer_group_id = '" . (int)$this->config_customer_group_id . "'";
				
				$recurring_query = $db->ExecuteQuery($recurring_query,'select');
				$recurring_query = $recurring_query[0];
				
				if ($recurring_query) {
					$recurring = array(
						'recurring_id'    => $cart['recurring_id'],
						'name'            => $recurring_query['name'],
						'frequency'       => $recurring_query['frequency'],
						'price'           => $recurring_query['price'],
						'cycle'           => $recurring_query['cycle'],
						'duration'        => $recurring_query['duration'],
						'trial'           => $recurring_query['trial_status'],
						'trial_frequency' => $recurring_query['trial_frequency'],
						'trial_price'     => $recurring_query['trial_price'],
						'trial_cycle'     => $recurring_query['trial_cycle'],
						'trial_duration'  => $recurring_query['trial_duration']
					);
				} else {
					$recurring = false;
				}
			
				
				$product_data[] = array(
					'cart_id'         => $cart['cart_id'],
					'product_id'      => $product_query['product_id'],
					'name'            => $product_query['name'],
					'model'           => $product_query['model'],
					'image'           => 'image/cache/'.$this->site_url.''.preg_replace('/(\.gif|\.jpg|\.jpeg|\.png)/', '-300x300$1', $product_query['image']),
					'option'          => $option_data,					
					'quantity'        => $cart['quantity'],
					'minimum'         => $product_query['minimum'],
					'subtract'        => $product_query['subtract'],
					'stock'           => $stock,
					'mrp_price'       => (string)($mrp_price + $option_price) * $cart['quantity'],
					'price'           => ($price + $option_price),
					'total'           => ($price + $option_price) * $cart['quantity'],
					
					'recurring'       => $recurring
				);
			} else {
				$this->remove_cart($cart['cart_id']);
			}
		}
		
		return $product_data;
	}
	
	function remove_cart($cart_id){
		$query = "DELETE  FROM  " . DB_PREFIX . "cart WHERE cart_id = '".$cart_id."'";
		
		$db = new SQL();							
		$result = $db->ExecuteQuery($query,'delete');	
		return $result;
	}

public function addOrder($data) {
		
		//~ echo '<pre>';
		//~ print_r($data);
		//~ echo '</pre>';
		//~ exit;
		
		$query =  "INSERT INTO `" . DB_PREFIX . "order` SET 
							invoice_prefix = '" . $data['invoice_prefix'] . "', store_id = '" . (int)$this->config_store_id . "', 
							store_name = '" . $this->store_name . "', store_url = 'https://gmfashions.in/', 
							customer_id = '" . (int)$data['customer_id'] . "', customer_group_id = '1', 
							firstname = '" . $data['firstname'] . "', lastname = '" . $data['lastname'] . "', 
							email = '" . $data['email'] . "', telephone = '" . $data['telephone'] . "', 
							fax = '', custom_field = '', 
							payment_firstname = '" . $data['payment_firstname'] . "', payment_lastname = '" . $data['payment_lastname'] . "', 
							payment_company = '', payment_address_1 = '" . $data['payment_address_1'] . "', 
							payment_address_2 = '" . $data['payment_address_2'] . "', payment_city = '" . $data['payment_city'] . "', 
							payment_postcode = '" . $data['payment_postcode'] . "', payment_country = '" . $data['payment_country'] . "', 
							payment_country_id = '" . (int)$data['payment_country_id'] . "', payment_zone = '" . $data['payment_zone'] . "', 
							payment_zone_id = '" . (int)$data['payment_zone_id'] . "', payment_address_format = '" . $data['payment_address_format'] . "', 
							payment_custom_field = '', 
							payment_method = '" . $data['payment_method'] . "', payment_code = '" . $data['payment_code'] . "', 
							shipping_firstname = '" . $data['shipping_firstname'] . "', shipping_lastname = '" . $data['shipping_lastname'] . "', 
							shipping_company = '" . $data['shipping_company'] . "', shipping_address_1 = '" . $data['shipping_address_1'] . "', 
							shipping_address_2 = '" . $data['shipping_address_2'] . "', shipping_city = '" . $data['shipping_city'] . "', 
							shipping_postcode = '" . $data['shipping_postcode'] . "', shipping_country = '" . $data['shipping_country'] . "', 
							shipping_country_id = '" . (int)$data['shipping_country_id'] . "', shipping_zone = '" . $data['shipping_zone'] . "', 
							shipping_zone_id = '" . (int)$data['shipping_zone_id'] . "', shipping_address_format = '" . $data['shipping_address_format'] . "',
							shipping_custom_field = '',

shipping_charge = '" . $data['shipping_charge'] . "',

shipping_method = '" . $data['shipping_method'] . "', shipping_code = '" . $data['shipping_code'] . "', 
							comment = '" . $data['comment'] . "', total = '" . (float)$data['total'] . "', 
							order_status_id = '" . (int)$data['order_status_id'] . "', 
							affiliate_id = '" . (int)$data['affiliate_id'] . "', commission = '" . (float)$data['commission'] . "', 
							marketing_id = '" . (int)$data['marketing_id'] . "', tracking = '" . $data['tracking'] . "', 
							language_id = '" . (int)$this->config_language_id . "', currency_id = '" . (int)$this->currency_id . "', 
							currency_code = '" . $this->currency_code . "', currency_value = '1.00000000', 
							ip = '" . $data['ip'] . "', forwarded_ip = '', 
							user_agent = '" . $data['user_agent'] . "', accept_language = 'en-US,en;q=0.5', 
							date_added = NOW(), date_modified = NOW()";
							
		$db = new SQL();							
		$order_id = $db->ExecuteQuery($query,'insert');	
		
		if (isset($data['products'])) {
			foreach ($data['products'] as $product) {
				$query =  "INSERT INTO " . DB_PREFIX . "order_product 
								SET order_id = '" . (int)$order_id . "', 
								product_id = '" . (int)$product['product_id'] . "', 
								name = '" . $product['name'] . "', 
								model = '" . $product['model'] . "', 
								quantity = '" . (int)$product['quantity'] . "', 
								price = '" . (float)$product['price'] . "', 
								total = '" . (float)$product['total'] . "', 
								tax = '', 
								reward = ''";
				$db = new SQL();							
				$order_product_id = $db->ExecuteQuery($query,'insert');	
				
				if (isset($data['customer_id']) && $data['buy_now'] == 1 ) {
					$option = explode(':',$product['option'] );

//option 0 => product_option_id , product_option_value_id , name, type, value
					 $query =  "INSERT INTO " . DB_PREFIX . "order_option 
										SET order_id = '" . (int)$order_id . "', 
										order_product_id = '" . (int)$order_product_id . "', 
										product_option_id = '" . (int)$option[0] . "', 
										product_option_value_id = '" . (int)$option[1] . "', 
										name = '" . $option[2] . "', 
										value = '" .$option[4] . "', 
										type = '" . $option[3] . "'";
						$db = new SQL();							
						$order_option = $db->ExecuteQuery($query,'insert');	
		        }else{

foreach ($product['option'] as $option) {
						 $query =  "INSERT INTO " . DB_PREFIX . "order_option 
										SET order_id = '" . (int)$order_id . "', 
										order_product_id = '" . (int)$order_product_id . "', 
										product_option_id = '" . (int)$option['product_option_id'] . "', 
										product_option_value_id = '" . (int)$option['product_option_value_id'] . "', 
										name = '" . $option['name'] . "', 
										value = '" .$option['value'] . "', 
										type = '" . $option['type'] . "'";
						
						$db = new SQL();							
						$order_option = $db->ExecuteQuery($query,'insert');						
					}
				}
			}
		}	
	// exit;
		if (isset($data['total'])) {
				$query =  "INSERT INTO " . DB_PREFIX . "order_total 
								SET order_id = '" . (int)$order_id . "', 
								code = 'sub_total', 
								title = 'Sub-Total', 
								value = '" . (float)($data['total'] - $data['shipping_charge']). "', 
								sort_order = '1'";
				$db = new SQL();							
				$order_total = $db->ExecuteQuery($query,'insert');
				
				$query =  "INSERT INTO " . DB_PREFIX . "order_total 
								SET order_id = '" . (int)$order_id . "', 
								code = 'shipping', 
								title = '".$data['shipping_method']."', 
								value = '".$data['shipping_charge']."', 
								sort_order = '3'";
				$db = new SQL();							
				$order_total2 = $db->ExecuteQuery($query,'insert');
				
				$query =  "INSERT INTO " . DB_PREFIX . "order_total 
								SET order_id = '" . (int)$order_id . "', 
								code = 'total', 
								title = 'Total', 
								value = '" . (float)$data['total'] . "', 
								sort_order = '9'";
				$db = new SQL();							
				$order_total3 = $db->ExecuteQuery($query,'insert');				
		}
		if (isset($data['customer_id']) && $data['buy_now'] == 0 ) {
				$query =  "DELETE FROM " . DB_PREFIX . "cart 
								WHERE customer_id = '".$data['customer_id']."'";
				$db = new SQL();							
				$order_total = $db->ExecuteQuery($query,'delete');
		}
		$result['order_id'] = $order_id;

send_sms('new_order',$data['telephone'],array($order_id));
		
		if(!empty($order_id)){
			return array($result);
		}
		else
			return 0;
	}

public function addReturn($data) {
		
		//~ echo '<pre>';
		//~ print_r($data);
		//~ echo '</pre>';
		//~ exit;
// 		debug($data);
		$query =  "INSERT INTO `" . DB_PREFIX . "return` SET 
						order_id = '" . $data['order_id'] . "',  
						customer_id = '" . (int)$data['customer_id'] . "', firstname = '" . $data['firstname'] . "', 
						email = '" . $data['email'] . "', telephone = '" . $data['telephone'] . "', product_id = '" . $data['product_id'] . "',
						product_name = '" . $data['product_name'] . "', model = '" . $data['model'] . "', 
						quantity = '" . $data['quantity'] . "', opened = '" . $data['opened'] . "', 
						return_reason_id = '" . (int)$data['return_reason_id'] . "', comment = '" . $data['comment'] . "', 
						date_ordered =  '". $data['date_ordered']."', date_added = NOW(), date_modified = NOW()";
							
		$db = new SQL();							
		$return_id = $db->ExecuteQuery($query,'insert');	
		
		$result['return_id'] = $return_id;
        $query1 =  "UPDATE `" . DB_PREFIX . "order_product` SET 
						return_id = '" . $result['return_id'] . "'
					 WHERE order_id = '" . $data['order_id'] . "' AND product_id = '" . $data['product_id'] . "'";
							
		$db1 = new SQL();							
		$return_id = $db->ExecuteQuery($query1,'update');	
		
		$result['return_id'] = $return_id;

if(!empty($return_id)){
			return array($result);
		}
		else
			return 0;
	}

public function CheckReview($data){
		
		$query = "SELECT review_id, ". DB_PREFIX ."review.text, rating FROM " . DB_PREFIX . "review WHERE customer_id = '" . (int)$data['customer_id'] . "'  AND product_id = '" . (int)$data['product_id'] . "' AND status = 1";

$db = new SQL();							
		$result = $db->ExecuteQuery($query,'select');	
		if ($result) {
			$data = array();
			$data['review_id'] = $result[0]['review_id'];
			$data['text']      = $result[0]['text'];
			$data['rating']    = $result[0]['rating'];
			return $data;
		}else{
			return false;
		}
	}

public function AddReview($data){
		if ($data['review_id'] > 0 ) {
			$query =  "UPDATE `" . DB_PREFIX . "review` SET author = '".$data['firstname']."', 
					     text = '".$data['text']."', rating = '".(int)$data['rating']. "', 
					     status = 0
			 			WHERE review_id = '" . (int)$data['review_id'] ."'";
			$db = new SQL();							
			$review = $db->ExecuteQuery($query,'update');						
		}else{
			$query =  "INSERT INTO `" . DB_PREFIX . "review` SET customer_id = '" . (int)$data['customer_id'] . "', product_id = '" . (int)$data['product_id'] . "', author = '".$data['firstname']."', text = '".$data['text']."', rating = '".(int)$data['rating']. "', 
					     status = 0, date_added = '".date('Y-m-d H:i:s')."'";
			$db = new SQL();							
			$review = $db->ExecuteQuery($query,'insert');					
		}
			
		if($review){
			return true;
		} else { 
			return false;
		}
	}

public function updateOrderHistoryComment($order_id) {
	    $query =  "INSERT INTO " . DB_PREFIX . "order_history (
						`order_id`, `order_status_id`, `comment`, `date_added`
						) VALUES (
						'" . (int)$order_id . "', '10', 'From APP - Payment Cancelled and the Transaction has been Aborted', NOW())";	
		$db = new SQL();							
		$order_history_id = $db->ExecuteQuery($query,'insert');			
		if(!empty($order_history_id)){
    		$query2 =  "UPDATE " . DB_PREFIX . "order SET `order_status_id` = '10' WHERE order_id = '" . (int)$order_id . "'";	
    		$db = new SQL();							
    		$order_status = $db->ExecuteQuery($query2,'update');

return $order_history_id;
		} else {
			return 0;
		}
	}

// 	public function getProductsBySearch($search_tag, $customer_id) {			
// 		$query =  "SELECT p.product_id, p.quantity, CONCAT('image/cache/', p.image) as image, p.price, pd.name, pd.description FROM " . DB_PREFIX . "product p 
// 						LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) 
// 						LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) 
// 							WHERE pd.language_id = '1' 
// 								AND p.status = '1' 
// 								AND p.date_available <= NOW() 
// 								AND p2s.store_id = '0' 
// 								AND ( pd.name LIKE '%".$search_tag."%' 
// 									OR pd.tag LIKE '%".$search_tag."%' 
// 									OR LCASE(p.model) = '".$search_tag."' 
// 									OR LCASE(p.sku) = '".$search_tag."' 
// 									OR LCASE(p.upc) = '".$search_tag."' 
// 									OR LCASE(p.ean) = '".$search_tag."' 
// 									OR LCASE(p.jan) = '".$search_tag."' 
// 									OR LCASE(p.isbn) = '".$search_tag."' 
// 									OR LCASE(p.mpn) = '".$search_tag."')";							
// 		$db = new SQL();							
// 		$products = $db->ExecuteQuery($query,'select');

// 		for($i=0; $i<count($products); $i++){
// 			//$products[$i]['image'] = $this->site_url.'/'.preg_replace('/(\.gif|\.jpg|\.png)/', '-250x250$1', $products[$i]['image']);

// 			$res_product_special = $this->getProductSpecial($products[$i]['product_id']);
// 			$products[$i]['image'] = $this->site_url.'/'.preg_replace('/(\.gif|\.jpg|\.png)/', '-255x340$1', $products[$i]['image']);		
// 			if(isset($res_product_special) && !empty($res_product_special)){
// 				$products[$i]['special_price'] = $res_product_special[0]['price'];
// 			}
// 		    if ($customer_id !=0){		
//     			$res_product_wish = $this->getProductWishlist($products[$i]['product_id'], $customer_id);
//     			if(isset($res_product_wish) && !empty($res_product_wish)){
//     				$products[$i]['product_wish'] = 1;
//     			} else {
//     			    $products[$i]['product_wish'] = 0;
//     			}
//             }

// 		}
// 		if(!empty($products)){
// 			return $products;
// 		}
// 		else
// 			return 0;
// 	}

public function getProductsBySearch($search_tag, $customer_id,$session_id) {			
		$query =  "SELECT p.product_id, p.quantity, CONCAT('image/cache/', p.image) as image, p.price, pd.name FROM " . DB_PREFIX . "product p 
						LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) 
						LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) 
							WHERE pd.language_id = '1' 
								AND p.status = '1' 
								AND p.date_available <= NOW() 
								AND p2s.store_id = '0' 
								AND ( pd.name LIKE '%".$search_tag."%' 
									OR pd.tag LIKE '%".$search_tag."%' 
									OR LCASE(p.model) = '".$search_tag."' 
									OR LCASE(p.sku) = '".$search_tag."' 
									OR LCASE(p.upc) = '".$search_tag."' 
									OR LCASE(p.ean) = '".$search_tag."' 
									OR LCASE(p.jan) = '".$search_tag."' 
									OR LCASE(p.isbn) = '".$search_tag."' 
									OR LCASE(p.mpn) = '".$search_tag."')  "
									;							
		$db = new SQL();							
		$products = $db->ExecuteQuery($query,'select');

for($i=0; $i<count($products); $i++){
			//$products[$i]['image'] = $this->site_url.'/'.preg_replace('/(\.gif|\.jpg|\.png)/', '-250x250$1', $products[$i]['image']);

$res_product_special = $this->getProductSpecial($products[$i]['product_id']);
			$products[$i]['image'] = $this->site_url.'/'.preg_replace('/(\.gif|\.jpg|\.png)/', '-255x340$1', $products[$i]['image']);		
			if(isset($res_product_special) && !empty($res_product_special)){
				$products[$i]['special_price'] = $res_product_special[0]['price'];
			}
		  	
    			$res_product_wish = $this->getProductWishlist($products[$i]['product_id'], $customer_id,$session_id);
    			if(isset($res_product_wish) && !empty($res_product_wish)){
    				$products[$i]['product_wish'] = 1;
    			} else {
    			    $products[$i]['product_wish'] = 0;
    			}

}
		if(!empty($products)){
			return $products;
		}
		else
			return 0;
	}

public function getTotal($data){
		$res_product = $this->getCart($data);
		
		$total = 0;
		
		foreach ($res_product as $product) {
			$total += $product['total'];
		}
		
		return $total;
	}
	public function getQty($data){
		$res_product = $this->getCart($data);
		$qty = 0;
		foreach ($res_product as $product) {
			
			$qty++;
		}
		
		return $qty;
	}
	
	public function getOrders($customer_id) {
		
		$query = "SELECT o.order_id, o.firstname, o.lastname, os.name as status, o.date_added, o.total, o.currency_code, o.currency_value FROM `" . DB_PREFIX . "order` o LEFT JOIN " . DB_PREFIX . "order_status os ON (o.order_status_id = os.order_status_id) WHERE o.customer_id = '" . (int)$customer_id . "' AND o.order_status_id > '0' AND o.store_id = '" . (int)$this->config_store_id . "' AND os.language_id = '" . (int)$this->config_language_id . "' ORDER BY o.order_id DESC";
		
		$db = new SQL();
		$orders = $db->ExecuteQuery($query,'select');
			
		if(!empty($orders)){
			return $orders;
		}
		else
			return 0;
	}
	
	public function getCodStatus() {
		
		$query = "SELECT s.value FROM `oc_setting` as s WHERE s.key = 'cod_status' ";
		$db = new SQL();
		$cod_status = $db->ExecuteQuery($query,'select');
		$codstatus  = $cod_status[0]['value'];		
		if(!empty($codstatus)){
			return (string) $codstatus;
		}
		else 
			return "0";
	}

public function getSettingsValue($key) {
		
		$query = "SELECT s.value FROM `oc_setting` as s WHERE s.key = '".$key."' ";
		$db = new SQL();
		$setting_value = $db->ExecuteQuery($query,'select');
		$settingValue  = $setting_value[0]['value'];		
		if(!empty($settingValue)){
			return (string) $settingValue;
		}
		else 
			return "0";
	}

public function getContact() {
		
		$query = "SELECT s.key, s.value FROM `oc_setting` as s WHERE s.key = 'config_name' or s.key = 'config_address' or s.key = 'config_geocode' or s.key = 'config_email' or s.key = 'config_telephone' or s.key = 'config_telephone' or s.key = 'config_comment' ";
		// $query = "SELECT s.key, s.value FROM `oc_setting` as s WHERE s.key = 'config_open' ";

$db = new SQL();
		$contact = $db->ExecuteQuery($query,'select');
		
		if(!empty($contact)){
			return $contact;
		}
		else 
			return 0;
	}	
	
	public function getCurrency($code) {
		
		$query = "SELECT title, symbol_left FROM `oc_currency` WHERE code = '".$code."' ";

$db = new SQL();
		$currency_code = $db->ExecuteQuery($query,'select');
		
		if(!empty($currency_code)){
			return $currency_code;
		}
		else 
			return 0;
	}

public function getOrderDetails($order_id){
		$query = "SELECT o.*,os.name AS order_status FROM `" . DB_PREFIX . "order` AS o LEFT JOIN " . DB_PREFIX . "order_status os ON (o.order_status_id = os.order_status_id) WHERE o.order_id = '" . (int)$order_id . "'  AND o.order_status_id > '0'";
		
		$db = new SQL();
		$orders = $db->ExecuteQuery($query,'select');
			
		if(!empty($orders)){
			return $orders;
		}
		else
			return 0;
	}

public function getOrderHistoryDetails($order_id){
		$query = "SELECT o.* FROM `" . DB_PREFIX . "order_history` AS o WHERE o.order_id = '" . (int)$order_id . "'  AND o.order_status_id > '0'";
		
		$db = new SQL();
		$orders = $db->ExecuteQuery($query,'select');
			
		if(!empty($orders)){
			return $orders;
		}
		else
			return 0;
	}	
	
	public function getOrderProducts($order_id){
		$query = "SELECT * FROM " . DB_PREFIX . "order_product WHERE order_id = '" . (int)$order_id . "'";
		
		$db = new SQL();
		$order_products = $db->ExecuteQuery($query,'select');
		
		$products = array();
		foreach ($order_products as $product) {
			$query_op = "SELECT * FROM " . DB_PREFIX . "order_option WHERE order_id = '" . (int)$order_id . "' AND order_product_id = '" . (int)$product['order_product_id'] . "'";
			
			$db = new SQL();
			$op_options = $db->ExecuteQuery($query_op,'select');
			$option_data = array();
			foreach ($op_options as $option) {
				$option_data[] = array(
					'name'  => $option['name'],
					'value' => $option['value']
				);
			}
		
		
		$query_p =  "SELECT CONCAT('image/cache/', p.image) as image FROM " . DB_PREFIX . "product p WHERE p.product_id = '" . (int)$product['product_id'] . "'";	
			
		$db = new SQL();							
		$product_image = $db->ExecuteQuery($query_p,'select');

$image = $this->site_url.''.preg_replace('/(\.gif|\.jpg|\.jpeg|\.png)/', '-300x300$1', $product_image[0]['image']);
		
		$products[] = array(
				'product_id' => $product['product_id'],
				'name'     => $product['name'],
				'model'    => $product['model'],
				'image'    => $image,
				'option'   => $option_data,
				'quantity' => $product['quantity'],
				//'price'    => (int)$product['price'] + $product['tax'],
				'price'    => (int)$product['price'],
				'total'    => (int)$product['total'] + $product['tax'] * $product['quantity'],
				'return_id' => $product['return_id']
			);
		}
			//~ echo '<pre>';
		//~ print_r($products);
		//~ echo '</pre>';	
		
		
		return $products;
	}
	
	public function getOrderTotals($order_id){
		$query = "SELECT * FROM " . DB_PREFIX . "order_total WHERE order_id = '" . (int)$order_id . "' ORDER BY sort_order";
		
		$db = new SQL();
		$order_total = $db->ExecuteQuery($query,'select');
		
		if(!empty($order_total)){
			return $order_total;
		}
		else
			return 0;	
	}		
	
	function getFilterByCategoryId($category_id){
		$implode = array();

$query = "SELECT filter_id FROM " . DB_PREFIX . "category_filter WHERE category_id = '" . (int)$category_id . "'";
		
		$db = new SQL();
		$category_filter = $db->ExecuteQuery($query,'select');
		
		foreach ($category_filter as $result) {
			$implode[] = (int)$result['filter_id'];
		}

$filter_group_data = array();

if ($implode) {
			$filter_group_query = "SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM " . DB_PREFIX . "filter f LEFT JOIN " . DB_PREFIX . "filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN " . DB_PREFIX . "filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (" . implode(',', $implode) . ") AND fgd.language_id = '" . (int)$this->config_language_id . "' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)";
			
			$db = new SQL();
			$filter_group_query = $db->ExecuteQuery($filter_group_query,'select');
		
			foreach ($filter_group_query as $filter_group) {
				$filter_data = array();

$filter_query = "SELECT DISTINCT f.filter_id, fd.name FROM " . DB_PREFIX . "filter f LEFT JOIN " . DB_PREFIX . "filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (" . implode(',', $implode) . ") AND f.filter_group_id = '" . (int)$filter_group['filter_group_id'] . "' AND fd.language_id = '" . (int)$this->config_language_id . "' ORDER BY f.sort_order, LCASE(fd.name)";
				
				$db = new SQL();
				$filter_query = $db->ExecuteQuery($filter_query,'select');
			
				foreach ($filter_query as $filter) {
					$filter_data[] = array(
						'filter_id' => $filter['filter_id'],
						'filter_group_id' => $filter_group['filter_group_id'],
						'name'      => $filter['name']
					);
				}

if ($filter_data) {
					$filter_group_data[] = array(
						'filter_group_id' => $filter_group['filter_group_id'],
						'name'            => $filter_group['name'],
						'filter'          => $filter_data
					);
				}
			}
		}

return $filter_group_data;

}

public function getReturnReason(){
		$query =  "SELECT return_reason_id, name FROM " . DB_PREFIX . "return_reason WHERE language_id = 1 ";		
		$db = new SQL();							
		$return_reason = $db->ExecuteQuery($query,'select');	
		
		if(!empty($return_reason)){
			return $return_reason;
		}		
		else
			return 0;
	}
	
	public function getReturnList($customer_id){
		$query =  "SELECT r.return_id, r.invoice_no, r.firstname, r.date_added, rs.name as status FROM " . DB_PREFIX . "return r		
						LEFT JOIN " . DB_PREFIX . "return_status rs ON (r.return_status_id = rs.return_status_id)  
					WHERE r.customer_id = '" . (int)$customer_id . "'";

$db = new SQL();							
		$return_reason = $db->ExecuteQuery($query,'select');	
		
		if(!empty($return_reason)){
			return $return_reason;
		}		
		else
			return 0;
	}
	
	public function getReturnDetails($return_id){
		$query =  "SELECT *, rs.name as status, rr.name as reason FROM " . DB_PREFIX . "return r		
                        LEFT JOIN " . DB_PREFIX . "return_reason rr ON (r.return_reason_id = rr.return_reason_id) 
						LEFT JOIN " . DB_PREFIX . "return_status rs ON (r.return_status_id = rs.return_status_id)  
					WHERE r.return_id = '" . (int)$return_id . "'";

$db = new SQL();							
		$return_reason = $db->ExecuteQuery($query,'select');	
		
		if(!empty($return_reason)){
			return $return_reason;
		}		
		else
			return 0;
	}
	
   
   function UpdateFirebaseToken($data){
		if($data['user_type']){
			$query =  "UPDATE " . DB_PREFIX . "user SET firebase_token = '".$data['firebase_token']."'  WHERE firebase_user_id = '".$data['firebase_user_id']."'";
		}else{
			$query =  "UPDATE " . DB_PREFIX . "user SET firebase_token = '".$data['firebase_token']."' WHERE firebase_user_id = '".$data['firebase_user_id']."'";
		}
		$db = new SQL();							
		$status = $db->ExecuteQuery($query,'update');
		if($status){
			return $status;
		}
		else{
			return false;
		}
	}
    
   public function RegisterCustomer($uid, $firebase_token,$telephone) {
// 		echo $uid;
// 		echo "<br>  ".$firebase_token;
// 		echo "<br>  ".$telephone;
// 		exit;
		if(!$this->customerAlreadyExistByUID($uid)){
			echo 'Inside CAE'; exit;
			$salt = substr(miqd5(unid(rand(), true)), 0, 9);
			//$country_id = 99;
									
			$query =  "INSERT INTO " . DB_PREFIX . "customer (
							`customer_group_id`, `store_id`, `firstname`, `lastname`, 
							`email`, `telephone`, `fax`, `password`, 
							`salt`, `wishlist`, `newsletter`, 
							`address_id`, `custom_field`, `ip`, `status`, 
							`approved`, `safe`, `token`, `firebase_token`, `firebase_user_id`, `date_added`
							) 
								VALUES (
									'1', '0', '', '', 
									'', '".$telephone."', '', '', 
									'',  NULL, '0', 
									'0', '', '', '1', 
									'1', '', '', '".$firebase_token."', '".$uid."', NOW())";	
								//	exit;			
			$db = new SQL();							
			$customer_id = $db->ExecuteQuery($query,'insert');			
			if(!empty($customer_id)){
				return $customer_id;
			} else {
				return 0;
			}
		} else {
	    	$query =  "SELECT customer_id FROM " . DB_PREFIX . "customer 
							WHERE firebase_user_id = '" . strtolower($uid) . "' AND status = '1' 
							    AND approved = '1' ";	
	        $db = new SQL();							
	        $customer_id = $db->ExecuteQuery($query,'select');
            
    		if(!empty($customer_id)){
		        return (int)$customer_id[0]['customer_id'];
	        }
	        else{
		        return false;
	        }
			return false;
		}		
	} 
    
    public function customerAlreadyExistByUID($firebase_user_id) {
		$query =  "SELECT customer_id FROM " . DB_PREFIX . "customer 
								WHERE firebase_user_id = '" . strtolower($firebase_user_id) . "'				
								AND status = '1'
								AND approved = '1' ";	
		$db = new SQL();							
		$customer = $db->ExecuteQuery($query,'select');

if(!empty($customer)){
			return true;
		}
		else{
			return false;
		}

}

function forgot_password($telephone,$signature=''){

$sql         = "SELECT customer_id, CONCAT(firstname,'',lastname) AS customer_name FROM " . DB_PREFIX . "customer WHERE telephone = '" . (int) $telephone . "'";
        $db          = new SQL();
        $customer = $db->ExecuteQuery($sql, 'select');
        //debug($customer); exit;
        if (!empty($customer)) {
            $otp = rand(1000,9999);
            $otp_res = send_sms('pwd_reset_otp',$telephone,array($otp,$signature));
            //$otp_res = $this->send_otp($telephone,$otp,$customer[0]['customer_name']);
            $otp_info = json_decode($otp_res);
            //debug($otp_info);  exit;
            if($otp_info->status == '200'){
                $response = array();
                $response['customer_id'] = $customer[0]['customer_id'];
                $response['otp'] = $otp;
                return $response;
            }else{
                return false;
            }
        } else {
            return false;
        }
    }

function send_otp($mobile,$otp,$customer){
	 	 $message = str_replace(' ','%20',"Dear User, Your OTP for Password Reset to ".$customer." is ".$otp." Valid for 10 minutes. Regards, SIGMA Team");
	   $request = 'http://sms.sigmacomputers.in/pushsms.php?username=sigmaoffice&api_password=149a1r2e8o2xxjv4o&sender=SIIGMA&to='.$mobile.'&message='.$message.'&priority=8&e_id=1201160016232012406&t_id=1207162246667739364';
	   	//echo $request;
	   	//exit;

$curl = curl_init();

curl_setopt_array($curl, array(
		  CURLOPT_URL => $request,
		  CURLOPT_RETURNTRANSFER => true,
		  CURLOPT_ENCODING => '',
		  CURLOPT_MAXREDIRS => 10,
		  CURLOPT_TIMEOUT => 0,
		  CURLOPT_FOLLOWLOCATION => true,
		  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
		  CURLOPT_CUSTOMREQUEST => 'GET',
		));

$response = curl_exec($curl);

curl_close($curl);

$err = curl_error($curl);

if ($err) {
		  return $err;
		} else {
		  return $response;
		}

}

function updatePassword($new_password, $customer_id)
	{
		if ($customer_id) {
			$salt = substr(md5(uniqid(rand(), true)), 0, 9);
			$sql = "UPDATE " . DB_PREFIX . "customer SET salt = '" . $salt . "', password = '" . (sha1($salt . sha1($salt . sha1($new_password)))) . "' WHERE customer_id = '" . $customer_id . "'";
			$db = new SQL();
			$update_pass = $db->ExecuteQuery($sql,'update');
			if ($update_pass) {

// SMS Code STRATS Here
				$query2 =  "SELECT firstname,lastname,telephone FROM " . DB_PREFIX . "customer  WHERE customer_id = '". $customer_id ."'";	
				$db = new SQL();							
				$order_info = $db->ExecuteQuery($query2,'select');
				$telephone = $order_info[0]['telephone'];
				$name = $order_info[0]['firstname'].' '.$order_info[0]['lastname'];

$res = send_sms('change_pwd',$telephone,array($name,$new_password));
				// SMS Code ENDS Here

return true;
			}
			else
			{
				return false;
			}
		}
	}

public function addWishlist($product_id, $customer_id,$session_id) {

$sess_cus = '';
		if ($data['customer_id'] == 0) {
			//echo "string";
			$sess_cus = 'session_id = "'.$session_id.'"';
		}else{
			//echo "string12";
			$sess_cus = 'customer_id = "'.(int)$customer_id.'"';
		}

$sql = "INSERT INTO " . DB_PREFIX . "customer_wishlist SET $sess_cus, product_id = '" . (int)$product_id . "', date_added = NOW()";

// print_r($sql);
		// exit();
		$db = new SQL();
		$add_wish = $db->ExecuteQuery($sql,'insert');

if ($add_wish) {
			return true;
		} else {
			return false;
		}
	}

public function deleteWishlist($product_id, $customer_id,$session_id) {

$sql = "DELETE FROM " . DB_PREFIX . "customer_wishlist WHERE $sess_cus AND product_id = '" . (int)$product_id . "'";
		$db = new SQL();
		$delete_wish = $db->ExecuteQuery($sql,'delete');

if ($delete_wish) {
			return true;
		} else {
			return false;
		}
	}

public function getWishlist($customer_id) {
		$sql = "SELECT * FROM " . DB_PREFIX . "customer_wishlist WHERE customer_id = '" . (int)$customer_id . "'";
		$db = new SQL();
		$select_wish = $db->ExecuteQuery($sql,'select');

if(!empty($select_wish)){
			return $select_wish;
		} else {
			return false;
		}
	}

public function getTotalWishlist($customer_id,$session_id) {

$sql = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "customer_wishlist WHERE $sess_cus";
		$db = new SQL();
		$total_wishlist = $db->ExecuteQuery($sql,'select');

if(!empty($total_wishlist)){
			return $total_wishlist;
		} else {
			return false;
		}
	}

public function getProductWish($customer_id,$product_id,$session_id) {

$sess_cus = '';
		if ($data['customer_id'] == 0) {
			$sess_cus = 'session_id = "'.$session_id.'"';
		}else{
			$sess_cus = 'customer_id = "'.(int)$customer_id.'"';
		}

$sql = "SELECT * FROM " . DB_PREFIX . "customer_wishlist WHERE $sess_cus AND product_id = '" . (int)$product_id . "'";

$db = new SQL();
		$select_wish = $db->ExecuteQuery($sql,'select');
		if(!empty($select_wish)){
			return true;
		} else {
			return false;
		}
	}

// 	public function getWishlistProductDetails($customer_id, $session_id){

// 		$sess_cus = '';
// 		if ($data['customer_id'] == 0) {
// 			$sess_cus = 'session_id = "'.$session_id.'"';
// 		}else{
// 			$sess_cus = 'customer_id = "'.(int)$customer_id.'"';
// 		}

// 				$query =  "SELECT p.product_id, p.quantity, CONCAT('image/cache/', p.image) as image, 
// 				FORMAT(p.price,2) as price, pd.name FROM " . DB_PREFIX . "product p 
// 						LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) 
// 						LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON (p.product_id = p2c.product_id)
// 						LEFT JOIN " . DB_PREFIX . "customer_wishlist cw ON (p.product_id = cw.product_id)
// 							WHERE $sess_cus  AND p.status = 1
// 							GROUP BY p.product_id ORDER BY p.date_added DESC LIMIT " . (int)$this->module_product_limit;

// 							// print_r($query);
// 							// exit();		
// 		$db = new SQL();							
// 		$products = $db->ExecuteQuery($query,'select');

// 		for($i=0; $i<count($products); $i++){
// 			$res_product_special = $this->getProductSpecial($products[$i]['product_id']);
// 			$products[$i]['image'] = $this->site_url.'/'.preg_replace('/(\.gif|\.jpg|\.jpeg|\.png)/', '-300x300$1', $products[$i]['image']);			
// 			if(isset($res_product_special) && !empty($res_product_special)){
// 				$products[$i]['special_price'] = $res_product_special[0]['price'];
// 			}
//             if ($customer_id !=0){		
//     			$res_product_wish = $this->getProductWishlist($products[$i]['product_id'], $session_id);
//     			if(isset($res_product_wish) && !empty($res_product_wish)){
//     				$products[$i]['product_wish'] = 1;
//     			} else {
//     			    $products[$i]['product_wish'] = 0;
//     			}
//             }
// 		}

// 		if(!empty($products)){
// 			return $products;
// 		}
// 		else{
// 			return 0;
// 		}
		
		
	 
// 	}

public function getWishlistProductDetails($customer_id, $session_id){

$sess_cus = '';
		if ($data['customer_id'] == 0) {
			$sess_cus = 'session_id = "'.$session_id.'"';
		}else{
			$sess_cus = 'customer_id = "'.(int)$customer_id.'"';
		}

$query =  "SELECT p.product_id, p.quantity, CONCAT('image/cache/', p.image) as image, 
		FORMAT(p.price,2) as price, pd.name FROM " . DB_PREFIX . "product p 
				LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) 
				LEFT JOIN " . DB_PREFIX . "product_to_category p2c ON (p.product_id = p2c.product_id)
				LEFT JOIN " . DB_PREFIX . "customer_wishlist cw ON (p.product_id = cw.product_id)
					WHERE $sess_cus  AND p.status = 1
					GROUP BY p.product_id ORDER BY p.date_added DESC LIMIT " . (int)$this->module_product_limit;

$db = new SQL();							
		$products = $db->ExecuteQuery($query,'select');

if(!empty($products)){
			return $products;
		}
		else{
			return 0;
		}
	}
	
// 	public function getSaveForLater($data) {

// 		$sess_cus = '';
// 		if ($data['customer_id'] == 0) {
// 			$sess_cus = 'session_id = "'.$data['session_id'].'"';
// 		}else{
// 			$sess_cus = 'customer_id = "'.$data['customer_id'].'"';
// 		}

// 		$cart_query = "SELECT * FROM " . DB_PREFIX . "save_for_later WHERE  $sess_cus ";
		
// 		$db = new SQL();							
// 		$cart = $db->ExecuteQuery($cart_query,'select');

// 		return $cart;
		
// 		}

//     public function saveForLater($data) {

// 		$sess_cus = '';
// 		if ($data['customer_id'] == 0) {
// 			$sess_cus = 'session_id = "'.$data['session_id'].'"';
// 		}else{
// 			$sess_cus = 'customer_id = "'.$data['customer_id'].'"';
// 		}
// 		$cart_query = "SELECT * FROM " . DB_PREFIX . "cart WHERE  $sess_cus ";
		
// 		$db = new SQL();							
// 		$cart = $db->ExecuteQuery($cart_query,'select');

// 		foreach ($cart as $carts) {	
// 			$query =  "INSERT INTO `" . DB_PREFIX . "save_for_later` SET customer_id = '" . (int)$carts['customer_id'] . "',session_id = '" . $carts['session_id'] . "' , product_id = '" . $carts['product_id'] . "', options = '" . $carts['option'] . "',  quantity = '" .$carts['quantity'] . "', date_added = '".date('Y-m-d H:i:s')."'";
						
// 			$cart_id = $db->ExecuteQuery($query,'insert');

// 			$query1 = "DELETE  FROM  " . DB_PREFIX . "cart WHERE cart_id = '" .$carts['cart_id'] . "'";
		
// 			$db = new SQL();							
// 			$result = $db->ExecuteQuery($query1,'delete');	
			
// 		}
// 	if($cart_id){
// 			return true;
// 		}
// 		else
// 			return false;
// 	}

// 	public function moveToCart($data) {

// 		$sess_cus = '';
// 		if ($data['customer_id'] == 0) {
// 			$sess_cus = 'session_id = "'.$data['session_id'].'"';
// 		}else{
// 			$sess_cus = 'customer_id = "'.$data['customer_id'].'"';
// 		}

// 		$cart_query = "SELECT * FROM " . DB_PREFIX . "save_for_later WHERE  $sess_cus ";
		
// 		$db = new SQL();							
// 		$cart = $db->ExecuteQuery($cart_query,'select');

// 		foreach ($cart as $carts) {	
// 			$query =  "INSERT INTO `" . DB_PREFIX . "cart` SET customer_id = '" . $carts['customer_id'] . "',session_id = '" . $carts['session_id'] . "' , product_id = '" .$carts['product_id'] . "', option = '" . $carts['options'] . "',  quantity = '" . $carts['quantity'] . "', date_added = '".date('Y-m-d H:i:s')."'";
						
// 			$cart_id = $db->ExecuteQuery($query,'insert');

// 			$query1 = "DELETE  FROM  " . DB_PREFIX . "save_for_later WHERE save_for_later_id = '" .$carts['save_for_later_id'] . "'";
		
// 			$db = new SQL();							
// 			$result = $db->ExecuteQuery($query1,'delete');	
			
// 		}

// 	if($cart_id){
// 			return true;
// 		}
// 		else
// 			return false;
// 	}

function saveForLater($data) {

$cart_query = "SELECT * FROM " . DB_PREFIX . "cart WHERE cart_id ='".$data['cart_id']."' ";
		$db = new SQL();							
		$cart = $db->ExecuteQuery($cart_query,'select');

$cart_query1 = "SELECT * FROM " . DB_PREFIX . "save_for_later WHERE product_id ='".$cart[0]['product_id']."' AND session_id ='".$cart[0]['session_id']."' AND options ='".$cart[0]['option']."'  ";		
		$db = new SQL();							
		$cart1 = $db->ExecuteQuery($cart_query1,'select');
		
		if ($cart1[0]['product_id']) {

$querys =  "UPDATE `" . DB_PREFIX . "save_for_later` SET quantity = (quantity + " . (int)$cart[0]['quantity'] .") WHERE product_id ='".$cart1[0]['product_id']."' AND session_id ='".$cart1[0]['session_id']."' AND options ='".$cart1[0]['options']."' ";
			$db = new SQL();

$cart_ids = $db->ExecuteQuery($querys,'update');

$query12 = "DELETE  FROM  " . DB_PREFIX . "cart WHERE cart_id = '".$cart[0]['cart_id'] ."'";

$db = new SQL();							
			$result = $db->ExecuteQuery($query12,'delete');

} else{
			$queryss =  "INSERT INTO `" . DB_PREFIX . "save_for_later` SET customer_id = '" . (int)$cart[0]['customer_id'] . "',session_id = '" . $cart[0]['session_id'] . "' , product_id = '" . $cart[0]['product_id'] . "', options = '" . $cart[0]['option'] . "',  quantity = '" .$cart[0]['quantity'] . "', date_added = '".date('Y-m-d H:i:s')."'";
			$db = new SQL();
			$cart_idss = $db->ExecuteQuery($queryss,'insert');

$query12 = "DELETE  FROM  " . DB_PREFIX . "cart WHERE cart_id = '" .$cart[0]['cart_id'] . "'";

$db = new SQL();							
			$result = $db->ExecuteQuery($query12,'delete');
			
		}
		
	if($result){
			return true;
		} else{
			return false;
		}
	}

function moveToCart($data) {
		
		$save_querys = "SELECT * FROM " . DB_PREFIX . "save_for_later WHERE save_for_later_id ='".$data['save_for_later_id']."' ";
		$db = new SQL();							
		$s_query = $db->ExecuteQuery($save_querys,'select');

$movecart_query = "SELECT * FROM " . DB_PREFIX . "cart WHERE product_id ='".$s_query[0]['product_id']."' AND session_id ='".$s_query[0]['session_id']."' AND option ='".$s_query[0]['options']."'  ";		
		$db = new SQL();							
		$move_query = $db->ExecuteQuery($movecart_query,'select');

if ($move_query[0]['product_id']) {

$querys =  "UPDATE `" . DB_PREFIX . "cart` SET quantity = (quantity + " . (int)$s_query[0]['quantity'] .") WHERE product_id ='".$move_query[0]['product_id']."' AND session_id ='".$move_query[0]['session_id']."' AND option ='".$move_query[0]['option']."' ";
			$dbs = new SQL();
			$cart_ids = $dbs->ExecuteQuery($querys,'update');

$query15 = "DELETE  FROM  " . DB_PREFIX . "save_for_later WHERE save_for_later_id = '".$s_query[0]['save_for_later_id'] ."'";
			$dbss = new SQL();							
			$result = $dbss->ExecuteQuery($query15,'delete');

} else{

$queryss =  "INSERT INTO `" . DB_PREFIX . "cart` SET customer_id = '" . (int)$s_query[0]['customer_id'] . "',session_id = '" . $s_query[0]['session_id'] . "' , product_id = '" . $s_query[0]['product_id'] . "', option = '" . $s_query[0]['options'] . "',  quantity = '" .$s_query[0]['quantity'] . "', date_added = '".date('Y-m-d H:i:s')."'";
			$db_query = new SQL();
			$cart_idss = $db_query->ExecuteQuery($queryss,'insert');

}
	if($result){
			return true;
		}
		else
			return false;
	}

function getSaveForLater($data) {

$sess_cus = '';
		if ($data['customer_id'] == 0) {
			$sess_cus = 'session_id = "'.$data['session_id'].'"';
		}else{
			$sess_cus = 'customer_id = "'.$data['customer_id'].'"';
		}

$product_data = array();

$cart_query = "SELECT * FROM " . DB_PREFIX . "save_for_later WHERE  $sess_cus ";
		
		$db = new SQL();							
		$cart = $db->ExecuteQuery($cart_query,'select');

foreach ($cart as $cart) {

$stock = true;

$product_query = $db->ExecuteQuery($product_query,'select');
			$product_query = $product_query[0];

if ($product_query && ($cart['quantity'] > 0)) {
				$option_price = 0;
				$option_points = 0;
				$option_weight = 0;

$option_data = array();

foreach (json_decode($cart['options']) as $product_option_id => $value) {

$option_query = "SELECT po.product_option_id, po.option_id, od.name, o.type FROM " . DB_PREFIX . "product_option po LEFT JOIN `" . DB_PREFIX . "option` o ON (po.option_id = o.option_id) LEFT JOIN " . DB_PREFIX . "option_description od ON (o.option_id = od.option_id) WHERE po.product_option_id = '" . (int)$product_option_id . "' AND po.product_id = '" . (int)$cart['product_id'] . "' AND od.language_id = '" . (int)$this->config_language_id . "'";
					
								
					$option_query = $db->ExecuteQuery($option_query,'select');

// debug($option_query);
					// exit();
					$option_query = $option_query[0];	
									
					if ($option_query) {
						if ($option_query['type'] == 'select' || $option_query['type'] == 'radio' || $option_query['type'] == 'image') {
							$option_value_query = "SELECT pov.option_value_id, ovd.name, pov.quantity, pov.subtract, pov.price, pov.price_prefix, pov.points, pov.points_prefix, pov.weight, pov.weight_prefix FROM " . DB_PREFIX . "product_option_value pov LEFT JOIN " . DB_PREFIX . "option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN " . DB_PREFIX . "option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_option_value_id = '" . (int)$value . "' AND pov.product_option_id = '" . (int)$product_option_id . "' AND ovd.language_id = '" . (int)$this->config_language_id . "'";
							
							$option_value_query = $db->ExecuteQuery($option_value_query,'select');
							$option_value_query = $option_value_query[0];
							if ($option_value_query) {
								if ($option_value_query['price_prefix'] == '+') {
									$option_price += $option_value_query['price'];
								} elseif ($option_value_query['price_prefix'] == '-') {
									$option_price -= $option_value_query['price'];
								}

if ($option_value_query['subtract'] && (!$option_value_query['quantity'] || ($option_value_query['quantity'] < $cart['quantity']))) {
									$stock = false;
								}

$option_data[] = array(
									'product_option_id'       => $product_option_id,
									'product_option_value_id' => $value,
									'option_id'               => $option_query['option_id'],
									'option_value_id'         => $option_value_query['option_value_id'],
									'name'                    => $option_query['name'],
									'value'                   => $option_value_query['name'],
									'type'                    => $option_query['type'],
									'quantity'                => $option_value_query['quantity'],
									'subtract'                => $option_value_query['subtract'],
									'price'                   => $option_value_query['price'],
									'price_prefix'            => $option_value_query['price_prefix'],
									'points'                  => $option_value_query['points'],
									'points_prefix'           => $option_value_query['points_prefix'],
									'weight'                  => $option_value_query['weight'],
									'weight_prefix'           => $option_value_query['weight_prefix']
								);
							}
						} elseif ($option_query['type'] == 'checkbox' && is_array($value)) {
							foreach ($value as $product_option_value_id) {
								$option_value_query = "SELECT pov.option_value_id, ovd.name, pov.quantity, pov.subtract, pov.price, pov.price_prefix, pov.points, pov.points_prefix, pov.weight, pov.weight_prefix FROM " . DB_PREFIX . "product_option_value pov LEFT JOIN " . DB_PREFIX . "option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN " . DB_PREFIX . "option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_option_value_id = '" . (int)$product_option_value_id . "' AND pov.product_option_id = '" . (int)$product_option_id . "' AND ovd.language_id = '" . (int)$this->config_language_id . "'";
								
							$option_value_query = $db->ExecuteQuery($option_value_query,'select');
							$option_value_query = $option_value_query[0];
								if ($option_value_query) {
									if ($option_value_query['price_prefix'] == '+') {
										$option_price += $option_value_query['price'];
									} elseif ($option_value_query['price_prefix'] == '-') {
										$option_price -= $option_value_query['price'];
									}

if ($option_value_query['points_prefix'] == '+') {
										$option_points += $option_value_query['points'];
									} elseif ($option_value_query['points_prefix'] == '-') {
										$option_points -= $option_value_query['points'];
									}

if ($option_value_query['weight_prefix'] == '+') {
										$option_weight += $option_value_query['weight'];
									} elseif ($option_value_query['weight_prefix'] == '-') {
										$option_weight -= $option_value_query['weight'];
									}

if ($option_value_query['subtract'] && (!$option_value_query['quantity'] || ($option_value_query['quantity'] < $cart['quantity']))) {
										$stock = false;
									}

$option_data[] = array(
									'product_option_id'       => $product_option_id,
									'product_option_value_id' => $product_option_value_id,
									'option_id'               => $option_query['option_id'],
									'option_value_id'         => $option_value_query['option_value_id'],
									'name'                    => $option_query['name'],
									'value'                   => $option_value_query['name'],
									'type'                    => $option_query['type'],
									'quantity'                => $option_value_query['quantity'],
									'subtract'                => $option_value_query['subtract'],
									'price'                   => $option_value_query['price'],
									'price_prefix'            => $option_value_query['price_prefix'],
									'points'                  => $option_value_query['points'],
									'points_prefix'           => $option_value_query['points_prefix'],
									'weight'                  => $option_value_query['weight'],
									'weight_prefix'           => $option_value_query['weight_prefix']
								);
								}
							}
						} elseif ($option_query['type'] == 'text' || $option_query['type'] == 'textarea' || $option_query['type'] == 'file' || $option_query['type'] == 'date' || $option_query['type'] == 'datetime' || $option_query['type'] == 'time') {
							$option_data[] = array(
								'product_option_id'       => $product_option_id,
								'product_option_value_id' => '',
								'option_id'               => $option_query['option_id'],
								'option_value_id'         => '',
								'name'                    => $option_query['name'],
								'value'                   => $value,
								'type'                    => $option_query['type'],
								'quantity'                => '',
								'subtract'                => '',
								'price'                   => '',
								'price_prefix'            => '',
								'points'                  => '',
								'points_prefix'           => '',
								'weight'                  => '',
								'weight_prefix'           => ''
							);
						}
					}
				}

$price = $product_query['price'];
				$mrp_price = $product_query['price'];
				//$selling_price = $product_query['selling_price'];

// Product Discounts
				$discount_quantity = 0;

// Downloads
				$download_data = array();

// Stock
				if (!$product_query['quantity'] || ($product_query['quantity'] < $cart['quantity'])) {
					$stock = false;
				}

$recurring_query = "SELECT * FROM " . DB_PREFIX . "recurring r LEFT JOIN " . DB_PREFIX . "product_recurring pr ON (r.recurring_id = pr.recurring_id) LEFT JOIN " . DB_PREFIX . "recurring_description rd ON (r.recurring_id = rd.recurring_id) WHERE r.recurring_id = '" . (int)$cart['recurring_id'] . "' AND pr.product_id = '" . (int)$cart['product_id'] . "' AND rd.language_id = " . (int)$this->config_language_id . " AND r.status = 1 AND pr.customer_group_id = '" . (int)$this->config_customer_group_id . "'";
				
				$recurring_query = $db->ExecuteQuery($recurring_query,'select');
				$recurring_query = $recurring_query[0];
				
				if ($recurring_query) {
					$recurring = array(
						'recurring_id'    => $cart['recurring_id'],
						'name'            => $recurring_query['name'],
						'frequency'       => $recurring_query['frequency'],
						'price'           => $recurring_query['price'],
						'cycle'           => $recurring_query['cycle'],
						'duration'        => $recurring_query['duration'],
						'trial'           => $recurring_query['trial_status'],
						'trial_frequency' => $recurring_query['trial_frequency'],
						'trial_price'     => $recurring_query['trial_price'],
						'trial_cycle'     => $recurring_query['trial_cycle'],
						'trial_duration'  => $recurring_query['trial_duration']
					);
				} else {
					$recurring = false;
				}
				$product_data[] = array(
					'save_for_later_id'         => $cart['save_for_later_id'],
					// 'product_id'      => $product_query['product_id'],
					'name'            => $product_query['name'],
					'model'           => $product_query['model'],
					'image'           => 'image/cache/'.$this->site_url.''.preg_replace('/(\.gif|\.jpg|\.jpeg|\.png)/', '-300x300$1', $product_query['image']),
					'option'          => $option_data,					
					'quantity'        => $cart['quantity'],
					'minimum'         => $product_query['minimum'],
					'subtract'        => $product_query['subtract'],
					'stock'           => $stock,
					'mrp_price'       => (string)($mrp_price + $option_price) * $cart['quantity'],
					'price'           => ($price + $option_price),
					'total'           => ($price + $option_price) * $cart['quantity'],
					'recurring'       => $recurring,
					'customer_id'       => $cart['customer_id'],
					'session_id'       => $cart['session_id'],
					'product_id'       => $cart['product_id'],
					//'options'       => $cart['options'],
					'quantity'       => $cart['quantity']
				);
			} else {
				$this->remove_cart($cart['cart_id']);
			}
		}
		
		return $product_data;
		
		}

public function deleteSaveForLater($data) {

$id = $data['save_for_later_id'];
	$sql = "DELETE FROM " . DB_PREFIX . "save_for_later WHERE  save_for_later_id = '".$id . "'";
		$db = new SQL();
		$delete_wish = $db->ExecuteQuery($sql,'delete');

if ($delete_wish) {
			return true;
		} else {
			return false;
		}
	}

// public function addCustomisedorder($requirement,$qty,$size_id,$color_id,$time_of_delivery,$price_expected,$special_requirements) {
// 	 $querys =  "INSERT INTO " . DB_PREFIX . "customised_order 
// 					SET requirement = '" .$requirement . "', qty = '" . $qty . "',size_id = '" . $size_id . "', color_id = '".$color_id."',time_of_delivery = '" . $time_of_delivery . "', price_expected = '" . $price_expected . "', 
// 						special_requirements = '" . $special_requirements . "'";
	
// 	$db = new SQL();							
// 	$add_cus_order = $db->ExecuteQuery($querys,'insert');

// 	if($add_cus_order){
// 		return true;
// 	} else {
// 		return false;
// 	}

// }

public function addCustomisedorder($customer_id,$name,$mobile,$email,$requirement,$qty,$size_id,$color_id,$time_of_delivery,$price_expected,$special_requirements) {
	 $querys =  "INSERT INTO " . DB_PREFIX . "customised_order 
					SET name = '".$name."', mobile = '".$mobile."', email = '".$email."',customer_id = '".$customer_id."', requirement = '" .$requirement . "', qty = '" . $qty . "',size_id = '" . $size_id . "', color_id = '".$color_id."',time_of_delivery = '" . $time_of_delivery . "', price_expected = '" . $price_expected . "', 
						special_requirements = '" . $special_requirements . "'";
	
	$db = new SQL();							
	$add_cus_order = $db->ExecuteQuery($querys,'insert');

if(!empty($add_cus_order)){
				$to = 'elansigm@gmail.com';
				$subject = "GM Fashions - Customised Order Details";
				$message = "
					<html>
						<head>
							<title>Customised Order Details</title>
						</head>
						<body>
							<p>Customised Order Details.</p>
							<table>
								<tr>
									<th>Requirment</th>
									<td>".$requirement ."</td>
								</tr>
								<tr>
									<th>Quantity</th>
									<td>".$qty."</td>
								</tr>
								<tr>
									<th>Size</th>
									<td>".$size_id."</td>
								</tr>
								<tr>
									<th>Color</th>
									<td>".$color_id."</td>
								</tr>
								<tr>
									<th>Time for Delivery</th>
									<td>".$time_of_delivery."</td>
								</tr>
								<tr>
									<th>Price Expected</th>
									<td>".$price_expected."</td>
								</tr>
								<tr>
									<th>Special Requirement</th>
									<td>".$special_requirements."</td>
								</tr>
							</table>
						</body>
					</html>
				";

// Always set content-type when sending HTML email
				$headers = "MIME-Version: 1.0" . "\r\n";
				$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
				
				// More headers
				$headers .= 'From: GM Fashions<info@gmfashions.in>' . "\r\n";
				$res = mail($to, $subject, $message, $headers);
	
				if($res){
					return 1;
				}else{
					return 1;
				}
			}
			else
				return 0;
    } 
    public function getRegion($postcode){
        $query = "SELECT region_id FROM si_pincode where pincode_name = '".$postcode."'";       
        $db = new SQL();
        $res_region = $db->ExecuteQuery($query,'select');
        if(isset($res_region) && !empty($res_region)){
            return $res_region[0]['region_id'];     
        }else{
            return 0;
        }
        
    }
    public function getCustomerAddress($address_id){
        $query =  "SELECT * FROM " . DB_PREFIX . "address  
                                WHERE address_id = '".$address_id."'";  
        $db = new SQL();                            
        $result = $db->ExecuteQuery($query,'select');   
        return $result;
    }

/*Admin API*/
	public function getUserDetailsByUserName($email, $password) {
	    $query =  "SELECT * FROM " . DB_PREFIX . "user 
	                            WHERE username = '" .$email. "' OR email = '" .$email. "'
	                            AND password = SHA1(CONCAT(salt, SHA1(CONCAT(salt, SHA1('" . $password . "')))))
	                            AND status = 1
	                             ";    
	    $db = new SQL();                            
	    $user = $db->ExecuteQuery($query,'select');
	    
	    if(!empty($user)){
	        return $user;
	    } else
	        return 0;
	}
	public function userForgotPassword($email) {

$salt = substr(md5(uniqid(rand(), true)), 0, 9);
			$password = mt_rand(100000,999999);
			$saltpassword = sha1($salt . sha1($salt . sha1($password)));

$query =  "UPDATE " . DB_PREFIX . "user 
					SET orgl_password = '" . $password . "', 
					salt = '" . $salt . "', 
					password = '".$saltpassword."' 
						WHERE email = '" . $email . "'";

$db = new SQL();
			$user = $db->ExecuteQuery($query,'update');

if(!empty($user)){
				$to = $username;
				$subject = "Duvinn Enterprises - New Password";
				$message = "
					<html>
						<head>
							<title>Duvinn Enterprises - New Password</title>
						</head>
						<body>
							<p>A new password was requested for Duvinn Enterprises.</p>
							<table>
								<tr>
									<th>Email</th>
									<td>".$email ."</td>
								</tr>
								<tr>
									<th>Password</th>
									<td>".$password."</td>
								</tr>
							</table>
						</body>
					</html>
				";

// Always set content-type when sending HTML email
				$headers = "MIME-Version: 1.0" . "\r\n";
				$headers .= "Content-type:text/html;charset=UTF-8" . "\r\n";
				
				// More headers
				$headers .= 'From: Duvinn Enterprises<no-reply@duvinn.com>' . "\r\n";
				//$headers .= 'Cc: mohan2connect@gmail.com' . "\r\n";
				$res = mail($to, $subject, $message, $headers);
				if($this->site_url == 'https://duvinn.com/online/'){
					$res = 1;
				}
				if($res){
					return 1;
				}else{
					return 0;
				}
			}
			else
				return 0;
	}
	public function updateAdminPassword($new_password, $user_id)    {
        if ($user_id) {
            $salt = substr(md5(uniqid(rand(), true)), 0, 9);
            $sql = "UPDATE " . DB_PREFIX . "user SET orgl_password =  '" . $new_password . "', salt = '" . $salt . "', password = '" . (sha1($salt . sha1($salt . sha1($new_password)))) . "' WHERE user_id = '" . $user_id . "'";
            $db = new SQL();
            $update_pass = $db->ExecuteQuery($sql,'update');
            if ($update_pass) {
                return true;
            }   else         {
                return false;
            }

}
    }
    public function getOrderList($customer_id=0, $user_id=0, $limit=0,$month_year='',$date='',$orderstatus='1' ,$agent_id='') {
        $query = "SELECT o.order_id,o.order_status_id, o.invoice_no, o.customer_id,c.firebase_token as customer_firebase_token,o.delivery_boy_id, o.agent_id , o.firstname, o.lastname, os.name as status, o.date_added,o.date_modified, o.total, o.currency_code, o.currency_value, o.order_delivery_date_time, o.payment_code FROM `" . DB_PREFIX . "order` o LEFT JOIN " . DB_PREFIX . "order_status os ON (o.order_status_id = os.order_status_id) LEFT JOIN " . DB_PREFIX . "customer c ON (c.customer_id = o.customer_id) WHERE " ;
        if($month_year!=''){
            $query .= " DATE_FORMAT(o.date_modified,'%m-%Y') = '" . $month_year . "' AND ";
        }
        if($customer_id){
            $query .= " o.customer_id = '" . (int)$customer_id . "' AND ";
        }
        if($user_id){
            $query .= " o.delivery_boy_id = '" . (int)$user_id . "' AND ";
        }
        if($agent_id){
        	$query .= " o.agent_id = '" . (int)$agent_id . "' AND ";
        }
        if($date){
        	// $date = date("Y-m-d");
        	if($orderstatus == 22){
        		$query .= " DATE_FORMAT(o.order_completed_date_time, '%Y-%m-%d') = '" . $date . "' AND ";

}else{
        		$query .= " DATE_FORMAT(o.date_added, '%Y-%m-%d') = '" . $date . "' AND "; 	
        	}

}
        if($orderstatus > 0){
        	$query .= " o.order_status_id = '".$orderstatus."' AND ";
        }

$query .= " o.store_id = '" . (int)$this->config_store_id . "' AND os.language_id = '" . (int)$this->config_language_id . "' ORDER BY o.order_id DESC";

if($limit){
            $query .= " LIMIT 0, ".$limit;
        }
        //echo $query;

$db = new SQL();
        $orders = $db->ExecuteQuery($query,'select');
        
        if(!empty($orders)){

$x =0;
        	foreach($orders as $key => $val){
				/* Delivery Boy Name and Firebase Token*/
				$delivery_boy_arr = $this->getRegionAdminDetails($val['delivery_boy_id']);
				$delivery_boy =  $delivery_boy_arr[0]['firstname']." ".$delivery_boy_arr[0]['lastname'];
				$db_firebase_token = $delivery_boy_arr[0]['firebase_token'];

if(!empty($delivery_boy)){
					$orders[$x]['delivery_boy'] = $delivery_boy;
					$orders[$x]['db_firebase_token'] = $db_firebase_token;
				} else {
					$orders[$x]['delivery_boy'] = '' ;
					$orders[$x]['db_firebase_token'] = '';
				}

$x = $x + 1;
			}

return $orders;
        }
        else
            return 0;
    }

public function getRegionAdminDetails($user_id) {

$query =  "SELECT user_id, user_group_id , firebase_token , username, orgl_password, firstname, lastname, image , status , date_added
                       FROM " . DB_PREFIX . "user 
                       WHERE user_id = '".$user_id."' ORDER BY username";
        $db = new SQL();                            
        $regions = $db->ExecuteQuery($query,'select');
        if(!empty($regions)){
        	return $regions;
        } else{
            return false;
        }   
    }
    public function getTotalOrders(){
        $query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "order ";        
        $db = new SQL();
        $total_orders = $db->ExecuteQuery($query,'select');
        
        if(!empty($total_orders)){
            return $total_orders;
        }
        else
            return 0;   
    }
    public function getTotalTodayOrders(){
        $todaydate = date("Y-m-d");
        $query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "order WHERE DATE_FORMAT(date_added, '%Y-%m-%d') = '" . $todaydate . "' ";
        
        $db = new SQL();
        $total_orders = $db->ExecuteQuery($query,'select');
        
        if(!empty($total_orders)){
            return $total_orders;
        }
        else
            return 0;   
    }
    public function getOrderStatus($order_status=1 , $user_id=''){
        $query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "order WHERE order_status_id = '".$order_status."' ";      
        if($user_id)  {
        	$query .= " AND agent_id = '".$user_id."' ";
        }
        $db = new SQL();
        $total_orders = $db->ExecuteQuery($query,'select');
        
        if(!empty($total_orders)){
            return $total_orders;
        }
        else
            return 0;   
    }

public function getTodayOrderStatus($order_status=1 , $user_id=''){
        $todaydate = date("Y-m-d");
        $query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "order WHERE DATE_FORMAT(date_added, '%Y-%m-%d') = '" . $todaydate . "' AND order_status_id = '".$order_status."'";   
        if($user_id)  {
        	$query .= " AND agent_id = '".$user_id."' ";
        }

$db = new SQL();
        $total_orders = $db->ExecuteQuery($query,'select');
        
        if(!empty($total_orders)){
            return $total_orders;
        }
        else
            return 0;   
    }
    public function getAssignedOrders($user_id=''){

$query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "order WHERE agent_id != '0' ";      
        if($user_id)  {
        	$query .= " AND agent_id = '".$user_id."' ";
        }
        $db = new SQL();
        $total_orders = $db->ExecuteQuery($query,'select');
        
        if(!empty($total_orders)){
            return $total_orders;
        }
        else
            return 0;   
    }

public function getTodayAssignedOrders($user_id=''){
        $todaydate = date("Y-m-d");
        //$empty_array = array(array("total" => '0'));
        //$query = "SELECT COUNT(*) as total , o.agent_id, u.username, u.firstname, u.lastname 
			        // FROM " . DB_PREFIX . "order as o 
			        // LEFT JOIN " . DB_PREFIX . "user as u on u.user_id = o.agent_id 
			        // WHERE DATE_FORMAT(o.date_added, '%Y-%m-%d') = '" . $todaydate . "'";
        $query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "order WHERE agent_id != '0' 
         			AND DATE_FORMAT(date_added, '%Y-%m-%d') = '" . $todaydate . "' ";

if($user_id)  {
        	$query .= " AND agent_id = '".$user_id."' ";
        }
        $db = new SQL();
        $total_orders = $db->ExecuteQuery($query,'select');

if(count($total_orders) > 0){        	
            return $total_orders;
        }else{
        	return 0;   
        	//return $empty_array;   
        }
    }
    public function getTotalCustomers(){
        $query = "SELECT COUNT(*) AS total FROM " . DB_PREFIX . "customer WHERE status = '1' AND approved = '1'";
        
        $db = new SQL();
        $total_customers = $db->ExecuteQuery($query,'select');
        
        if(!empty($total_customers)){
            return $total_customers;
        }
        else
            return 0;   
    }
     public function getTotalSales(){
        $query = "SELECT SUM(total) AS total FROM " . DB_PREFIX . "order WHERE order_status_id > '0'";
        
        $db = new SQL();
        $total_orders = $db->ExecuteQuery($query,'select');
        
        if(!empty($total_orders)){
            return $total_orders;
        }
        else
            return 0;   
    }
     public function getTotalTodaySales(){
        $todaydate = date("Y-m-d");
        $query = "SELECT SUM(total) AS total FROM " . DB_PREFIX . "order WHERE DATE_FORMAT(date_added, '%Y-%m-%d') = '" . $todaydate . "' AND order_status_id > '0'";
        
        $db = new SQL();
        $total_orders = $db->ExecuteQuery($query,'select');
        
        if(!empty($total_orders)){
            return $total_orders;
        }
        else
            return 0;   
    }
    public function getTotalCashPayment(){
        $query = "SELECT SUM(total) AS total FROM " . DB_PREFIX . "order WHERE payment_code = 'cod' AND order_status_id > '0'";
        
        $db = new SQL();
        $total_orders = $db->ExecuteQuery($query,'select');
        
        if(!empty($total_orders)){
            return $total_orders;
        }
        else
            return 0;   
    }
    public function getTotalOnlinePayment(){
        $query = "SELECT SUM(total) AS total FROM " . DB_PREFIX . "order WHERE payment_code <> 'cod' ";

$db = new SQL();
        $total_orders = $db->ExecuteQuery($query,'select');
        
        if(!empty($total_orders)){
            return $total_orders;
        }
        else
            return 0;   
    }

public function getTotalTodayCashPayment(){
        $todaydate = date("Y-m-d");
        $query = "SELECT SUM(total) AS total FROM " . DB_PREFIX . "order WHERE DATE_FORMAT(date_added, '%Y-%m-%d') = '" . $todaydate . "' AND payment_code = 'cod' AND order_status_id > '0'";
        
        $db = new SQL();
        $total_orders = $db->ExecuteQuery($query,'select');
        
        if(!empty($total_orders)){
            return $total_orders;
        }
        else
            return 0;   
    }
    public function getTotalTodayOnlinePayment(){
        $todaydate = date("Y-m-d");
        $query = "SELECT SUM(total) AS total FROM " . DB_PREFIX . "order WHERE DATE_FORMAT(date_added, '%Y-%m-%d') = '" . $todaydate . "' AND payment_code <> 'cod' ";
        
        $db = new SQL();
        $total_orders = $db->ExecuteQuery($query,'select');
        
        if(!empty($total_orders)){
            return $total_orders;
        }
        else
            return 0;   
    }
    public function GetOrderStatusList($user_group_id=''){
	    $query =  "SELECT * FROM " . DB_PREFIX . "order_status ";

if($user_group_id == '12'){
	    	// $query .= " WHERE order_status_id IN (5,7,8,22,23) ";
	    	 $query .= " WHERE order_status_id IN (8,22,23) ";
	    } elseif($user_group_id == '11') {
	    	//$query .= " WHERE order_status_id IN (8,22,23) ";
	     	$query .= " WHERE order_status_id IN (22,23) ";
	    }

$query .= " ORDER BY order_status_id ASC ";

if($user_group_id == '12'){
	        $def_status[] = array(
	            'order_status_id' => "5",
	            'language_id' => "1",
	            'name' => 'Pending',
	        );
	        $def_status[] = array(
	            'order_status_id' => "7",
	            'language_id' => "1",
	            'name' => 'Processing',
	        );
	    }

if($user_group_id == '11'){
	        $def_status[] = array(
	            'order_status_id' => "8",
	            'language_id' => "1",
	            'name' => 'Pending',
	        );
	    }

//debug($status); exit;  
	    $db = new SQL();                     
	    $status = $db->ExecuteQuery($query,'select');
	    if($status){
	    	if($user_group_id == '11' || $user_group_id == '12')
	        	return array_merge($def_status,$status);
	        else
	        	return $status;
	    }
	    else{
	        return false;
	    }

}
	public function getCustomerList() {
        // $query = "SELECT c.* , a.* from oc_customer AS c     
        // 			LEFT JOIN oc_address AS a ON a.address_id = c.address_id
        //             WHERE c.STATUS = '1' ORDER BY c.firstname";

$query = "SELECT c.*  from oc_customer AS c     
                    WHERE c.STATUS = '1' ORDER BY c.firstname";
        $db = new SQL();                            
        $customer = $db->ExecuteQuery($query,'select');
        if(!empty($customer)){           
            return $customer;
        } else {
         return 0;
               }
    }
    public function updateDeliveryDateTime($order_id,$order_delivery_date_time){
        $query =  "UPDATE " . DB_PREFIX . "order SET order_delivery_date_time = '".$order_delivery_date_time."' WHERE order_id = '".$order_id."'";  
        $db = new SQL();                            
        $order = $db->ExecuteQuery($query,'update');
        if(!empty($order)){
            return $order;
        }
        else{
            return false;
        }
    }
    public function getUserList($user_group_id){
	    $query = "SELECT u.*,z.name as state_name,city_name 
	    FROM " . DB_PREFIX . "user as u
	    				LEFT JOIN " . DB_PREFIX . "zone as z  ON u.ref_state_id = z.zone_id
	    				LEFT JOIN si_city as c ON u.ref_city_id = c.city_id
	    				WHERE u.user_group_id = '" . $user_group_id ."' AND u.delete_status = 0 ";
	    
	    $db = new SQL();
	    $user_list = $db->ExecuteQuery($query,'select');
	    
	    if(!empty($user_list)){
	        return $user_list;
	    }
	    else
	        return 0;   
	}
	public function getAllProducts() {                                  
        $query =  "SELECT p.product_id, p.quantity, CONCAT('image/cache/', p.image) as image, p.price, pd.name, pd.description,p.sku FROM " . DB_PREFIX . "product p 
                        LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) 
                        LEFT JOIN " . DB_PREFIX . "product_to_store p2s ON (p.product_id = p2s.product_id) 
                            WHERE pd.language_id = '1' 
                                AND p.status = '1' 
                                AND p.approved = '1'
                                AND p.date_available <= NOW() 
                                AND p2s.store_id = '0' 
                                ";

$db = new SQL();
        $db->ExecuteQuery('SET character_set_results=utf8','update');
        $products = $db->ExecuteQuery($query,'select');

for($i=0; $i<count($products); $i++){
            $products[$i]['image'] = $this->site_url.'/'.preg_replace('/(\.gif|\.jpg|\.png)/', '-300x300$1', $products[$i]['image']);
        }
        if(!empty($products)){
            return $products;
        }
        else
            return 0;
    }
    public function getAllRegions() {
        $query =  "SELECT * FROM si_region WHERE status = 1 ORDER BY region_name";
        $db = new SQL();                            
        $regions = $db->ExecuteQuery($query,'select');
        if(!empty($regions)){
            return $regions;
        } else {
            return false;
        }   
    }
    public function get_payment_type_list(){
        $sql = "SELECT * FROM payment_type ORDER BY payment_type_name ASC";

$db = new SQL();
        $payment_type = $db->ExecuteQuery($sql,'select');
        if ($payment_type) {
            return $payment_type;
        }  else   {
            return false;
        }
    }
    public function update_payment_request_status($data){
	    $query =  "UPDATE referral_payment_request 
	            SET status = '" . $data['status'] . "', payment_ref_no = '" . $data['payment_ref_no'] . "', payment_type_id = '" . $data['payment_type_id'] . "'               
	                WHERE referral_payment_request_id = '" . $data['referral_payment_request_id'] . "'";
	    $db = new SQL();
	    $res = $db->ExecuteQuery($query,'update');
	    
	    return true;
	    
	}
	public function GenerateReferralCode($user_type,$id){

$referral_code = $this->get_random_string(6);
        if($user_type == 1){
            $sql = "UPDATE " . DB_PREFIX . "user SET referral_code = '" . $referral_code . "' WHERE user_id = '" . $id . "'";
        }else{
            $sql = "UPDATE " . DB_PREFIX . "customer SET referral_code = '" . $referral_code . "' WHERE customer_id = '" . $id . "'";
        }
        $db = new SQL();
        $update_pass = $db->ExecuteQuery($sql,'update');
        if ($update_pass) {
            return $referral_code;
        }     else   {
            return false;
        }
    }
    function get_random_string($length=0)
    {
        if(!$length){
            $length = 6;
        }
        $alphabet    = '1234567890ABCDEFGHIJKLMNOPQSTUVWXYZ';
        $pass        = array();
        $alphaLength = strlen($alphabet) - 1;
        for ($i = 0; $i < $length; $i++) {
            $n      = rand(0, $alphaLength);
            $pass[] = $alphabet[$n];
        }
        return implode($pass);
    }

/*User Table CRUD*/
	public function AddUser($data){
		$referral_code = $this->get_random_string(6);
		$data['ref_code'] = $referral_code;
		$salt = substr(md5(uniqid(rand(), true)), 0, 9);
		$password = $data['password'];
		$query =  "INSERT INTO " . DB_PREFIX . "user (
			user_group_id , ref_state_id , ref_city_id , 
			agent_user_id ,username , email,
			firstname , lastname , contact_no , image , 
			password , orgl_password , salt , status , referral_code ,
			referred_by_code , date_added
		) VALUES (
			'".$data['user_group_id']."','".$data['ref_state_id']."','".$data['ref_city_id']."',  '".$data['agent_user_id']."', '".strtolower($data['username'])."', '".strtolower($data['username'])."', 
			'".$data['firstname']."', '".$data['lastname']."', '".$data['contact_no']."',
			'', '".sha1($salt . sha1($salt . sha1($password)))."', '".$password."', '".$salt."', '".$data['status']."', '".$data['ref_code']."', '".$data['agent_ref_code']."', NOW()
		)";

$db = new SQL();							
		$user_id = $db->ExecuteQuery($query,'insert');

$result['user_id'] = $user_id;
		
		if($user_id){
			return array($result);
		} else { 
			return false;
		}
	}
	public function UpdateUser($data){
		$salt = substr(md5(uniqid(rand(), true)), 0, 9);
		$password = $data['password'];
		$saltpassword = sha1($salt . sha1($salt . sha1($password)));

$query =  "UPDATE " . DB_PREFIX . "user SET
			    		user_group_id = '".$data['user_group_id']."',
			    			ref_state_id = '".$data['ref_state_id']."', 
			    		ref_city_id = '".$data['ref_city_id']."',
			    			username = '".strtolower($data['username'])."',
			    		email = '".strtolower($data['username'])."',
			    		firstname = '".$data['firstname']."',
			    			lastname = '".$data['lastname']."',
			    		contact_no =  '".$data['contact_no']."',
			    			orgl_password = '" . $password . "', 
						salt = '" . $salt . "', 
							password = '".$saltpassword."' ,
						status = '".$data['status']."'
							WHERE user_id = '" . $data['user_id'] . "'";

$db = new SQL();
		$user = $db->ExecuteQuery($query,'update');

$result['user_id'] = (int)$data['user_id'];

if($user){
			return array($result);
		} else { 
			return false;
		}
	}
	public function DeleteUser($data){
		$query = "UPDATE oc_user SET delete_status = '".$data['delete_status']."' WHERE user_id = '".$data['user_id']."' ";
		
		$db = new SQL();
		$user = $db->ExecuteQuery($query,'update');

if($user){
			return true;
		} else { 
			return false;
		}

}
	public function getDeliveryBoyDetails($user_id){

$query =  "SELECT user_id, firstname, lastname,firebase_token, CONCAT('/image/', image) as image, contact_no from " . DB_PREFIX . "user WHERE user_id = '".$user_id."'"; 
        $db = new SQL();                            
        $user = $db->ExecuteQuery($query,'select');
		$image = $this->site_url.'/'.preg_replace('/(\.gif|\.jpg|\.jpeg|\.png)/', '$1', $user[0]['image']);        
        $deliveryboy[] = array(
                'user_id'  => $user[0]['user_id'],
                'firstname'  => $user[0]['firstname'],
                'lastname'   => $user[0]['lastname'],
                'firebase_token'   => $user[0]['firebase_token'],
                'image'      => $image,
                'contact_no' => $user[0]['contact_no']
            );
        if($deliveryboy){
            return $deliveryboy;
        }   else{
            return false;
        }
   }

public function getOrderComment($order_id){
        $query = "SELECT * FROM oc_order_history WHERE order_id = '".$order_id."'  ORDER BY order_history_id DESC LIMIT 0,1";
        //exit;
        $db = new SQL();
        $result = $db->ExecuteQuery($query,'select');
        
        if($result){
            return $result;
        }  else
            return false;
    }
    public function UpdateDeliveryBoyToOrder($order_id,$user_id){
	    $query =  "UPDATE " . DB_PREFIX . "order SET delivery_boy_id = '".$user_id."' 
	                            WHERE order_id = '".$order_id."'";  
	    $db = new SQL();                            
	    $order = $db->ExecuteQuery($query,'update');
	    if($order){
	        return $order;
	    }
	    else{
	        return false;
	    }
	}
	/*Admin API*/

function upload_file($image,$tmp_image,$path,$type="")                        
{

//for($i=0;$i<$countfiles;$i++){
 // $filename = $_FILES['file']['name'][$i];
 
  // Upload file
  //move_uploaded_file($_FILES['file']['tmp_name'][$i],'upload/'.$filename);

//echo $path;                       
//echo "<br>";                      
$success ="";                       
$error ="";                   
$invalid ="";                       
// $upload_path = "../../uploads/".$path."/";                     
// $thumb_path = "../../uploads/".$path."/thumb/";

$countfiles = count($image);

$upload_path = "../uploads/".$path."/";
$thumb_path = "../uploads/".$path."/thumb/";

if (!file_exists($upload_path)) {                     
mkdir($upload_path, 0777, true);                      
}                       
                        
if (!file_exists($thumb_path)) {                      
mkdir($thumb_path, 0777, true);                       
}                       
                        
$file_name = substr(time(),5,9).rand(10,99).'_'.$image;                        
$target_file = $upload_path.$file_name;   
      
//echo "<br>";                      
$thumb_file = $thumb_path.$file_name;                       
//echo "<br>";                      
$file_ext = explode('.',$image);                      
//print_r($file_ext);                     
$ext = $file_ext[1];                      
$allowedext = array("jpg","png","jpeg","gif","pdf","PDF",'xlsx','mp4','doc','docx','html','aac');                       
$exist = array();                   
if(!empty($type) && $type=="video"){                        
if(!move_uploaded_file($tmp_image,$target_file)){                       
echo "Error while uploading video";die;                     
}                       
}elseif(in_array($ext,$allowedext)){ // Check the file extension                    
$file = $tmp_image;                       
move_uploaded_file($file,$target_file); // Move image to the folde                        
}else{                        
$invalid[] = $image;                      
}                       
/*if($ext !="pdf" && $ext !="PDF" && $ext !="xlsx" && $type!="video"){                    
$this->make_thumb($target_file,$thumb_file);                      
}*/                     
                        
if($exist){                   
$exists= count($exist);                   
echo "Existing Files(".$exists.")";                   
foreach($exist as $exist_file){                       
echo $exist_file;                   
}                       
}                       
                        
return $target_file;                      
                        
}

$request = 'access_token=69afc7d29059a31fd0b26ef8ff5358e4&message='.$message.'&sender=GMFASH&to='.$mobile.'&service=T&header_id=1705163395147930480&entity_id=1001281204303578638&template_id='.$template_id.'';

$ch = curl_init('http://sms.saicolours.in/api/v2/sms/send?');

curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);

curl_setopt($ch, CURLOPT_POST, true);

curl_setopt($ch, CURLOPT_POSTFIELDS, $request);

$curl_response = curl_exec($ch);
    if ($curl_response) {
        $response = 1;
    } else {
        $response = 0 ;
    }
	curl_close($curl);
	return $response;
}

}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: functions0.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation