<?php

/* <summary>
	 Class contains methods related to state module
	 <author>
	 Beatle Buddy 2017.
	 </author>
	 Version 1.0
   </summary>
*/
 
class include_orderprocess
{
	/*
	<summary>
		Default constructor
	</summary>	
	*/
	
	function __CONSTRUCT(){
	
	}
	
	//  Method to fetch all user info.
	public function FetchAllUserInfo(){
		global $objDB;
		
		
	}
	
	
	
	public function fetchProductInfo($prodid){
		global $objDB;
		$SQL = "SELECT * FROM beatle_products WHERE productid = ".$prodid;
		return $rsProducts = $objDB->sql_query($SQL);
	}
	
	public function setOrderData(){
		global $objDB;
		
		
		$_REQUEST['acn'] = 'FetchAllUserInfo';
		
		
		$SQL = "SELECT * FROM states WHERE ID = '".$_POST['state']."'";	
		$rsState = $objDB->sql_query($SQL);	

		$SQL = "SELECT * FROM cities WHERE ID = '".$_POST['city']."'";	
		$rsCity = $objDB->sql_query($SQL);	
		
		
		
		$SQL = "INSERT INTO beatle_order SET
			productid = '".$_POST['proid']."',
			productname = '".$_POST['prodname']."',
			prod_image = '".$_POST['prodimage']."',
			quantity	=	1,
			userid = '".$_SESSION['UserInfo']['UserID']."',
			username = '".$_POST['name']."',
			phoneno = '".$_POST['contact_number']."', 
			email = '".$_POST['email']."', 
			address = '".$_POST['address']."', 
			pincode = '".$_POST['pincode']."', 
			state = '".$rsState[0]['name']."', 
			city = '".$rsCity[0]['name']."', 
			status = 'ordered', 
			created_date = '".date("Y-m-d H:i:s")."', 
			isreturn = 'N' ";
		$rsData = $objDB->sql_query($SQL);

		$id = mysqli_insert_id($objDB->CONN);
		$uid = str_pad($id, 5, "0", STR_PAD_LEFT);  //00002
		
		
		

		$SQL = "UPDATE beatle_order SET orderuid = '".$uid."' WHERE orderid = ".$id;
		$rsUPDATE = $objDB->sql_query($SQL);


		$this->proid = $_POST['proid'];
		$rsProduct = $this->fetchProductInfo($_POST['proid']);
		$stk = $rsProduct[0]['stock'] - 1;
		$SQL = "UPDATE beatle_products SET stock = ".$stk." WHERE productid = ".$_POST['proid'];
		$rsProducts = $objDB->sql_query($SQL);


		$rsPoint = $this->fetchProductInfo($_POST['proid']);
		

		$SQL = "INSERT INTO beatle_points SET 
		Amount = '".$rsPoint[0]['points']."', 
		AddedDate = '".date("Y-m-d H:i:s")."',
		OrderID = ".$id.",
		UserID = '".$_SESSION['UserInfo']['UserID']."',
		UserType = '".$_SESSION['UserInfo']['UType']."',
		IsRedeem = 'Y' ";
		$objDB->sql_query($SQL);
		
		ReturnPostFormData($this->DataArr,"profilenew.html","Thank you for ordered, <br /> Your order has been placed successfuly.",1);
		exit;
		
	}
	

	public function setPasswordData(){}
	
	protected function UploadUserProfileImage(){}
	
	protected function uploadprofileimage(){}
	
	
	public function resize($width, $height,$filename){}
	
	public function ChekcImageExtention($ImgName,$ExtArr){}
	
	public function fetchTotalBonus(){
		global $objDB;
		
		$SQL = "SELECT SUM(Amount) AS Amount FROM beatle_points WHERE UserID = '".$_SESSION['UserInfo']['UserID']."' AND IsReDeem = 'N' ";
		$rsAmount1 = $objDB->sql_query($SQL);
		$SQL = "SELECT SUM(Amount) AS Amount FROM beatle_points WHERE UserID = '".$_SESSION['UserInfo']['UserID']."' AND IsReDeem = 'Y' ";
		$rsAmount2 = $objDB->sql_query($SQL);
		
		return $amount = $rsAmount1[0]['Amount'] - $rsAmount2[0]['Amount'];
	}
	
	public function fetchCustomerVisit(){}
	
	public function FetchOrganizationName($id){}
	
	public function FetchBranchName($id){}
	
	public function FetchIndustryName($id){}
	
	
	public function FetchWebProfileImage(){}
	
	protected function removeprofileimage(){}
	
	public function __DESTRUCT()	{
		global $objDB;
		unset($objDB->objModel);
		unset($objDB->objController);
	}
	
} ///// class include_login completed  /////
?>