<?php

/* <summary>
	 Class contains methods related to state module
	 <author>
	 Beatle Buddy 2017.
	 </author>
	 Version 1.0
   </summary>
*/
 
class include_offerprocess
{
	/*
	<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 fetchOfferInfo($offerid){
		global $objDB;
		$SQL = "SELECT * FROM beatle_offers WHERE offerid = ".$offerid;
		return $rsData = $objDB->sql_query($SQL);
	}
	
	public function GeneratePassword($length_ = 5){
			
			$alphabet = "0123456789";
			$pass = array(); //remember to declare $pass as an array
			$alphaLength = strlen($alphabet) - 1; //put the length -1 in cache
			for ($i = 0; $i < $length_; $i++) {
				$n = rand(0, $alphaLength);
				$pass[] = $alphabet[$n];
			}
			return implode($pass); //turn the array into a string
			
	}
	
	public function setOrderData(){
		global $objDB;
		
		$_REQUEST['acn'] = 'FetchAllUserInfo';
		
		$dt = date("Y-m-d H:i:s");
		$SQL = "INSERT INTO beatle_offers_apply SET
			offerid = '".$_POST['offerid']."',
			userid = '".$_SESSION['UserInfo']['UserID']."',
			orgid = '".$_POST['orgid']."',
			added_date = '".$dt."', 
			expire_time = '".date("Y-m-d H:i:s",strtotime($dt."+1 hour"))."',
			cancel = 'N',
			approved = 'N',
			tokenid = '".$this->GeneratePassword(5)."' ";
			
		$rsData = $objDB->sql_query($SQL);
		
		ReturnPostFormData($_REQUEST,"offerprocess.html?prid=".$_POST['offerid'],"Your offer request applied 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){
		global $objDB;
		$SQL = "SELECT db_Orgname FROM beatle_organization WHERE OrgId = ".$id;
		$rsOwnerInfo = $objDB->sql_query($SQL);
		return $rsOwnerInfo[0]['db_Orgname'];
	}
	
	public function FetchBranchName($id){
		global $objDB;
		$SQL = "SELECT db_branchName FROM beatle_branch WHERE branchId = ".$id;
		$rsOwnerInfo = $objDB->sql_query($SQL);
		return $rsOwnerInfo[0]['db_branchName'];
	}
	
	public function FetchIndustryName($id){
		global $objDB;
		$SQL = "SELECT db_industry FROM beatle_industry WHERE IndId = ".$id;
		$rsOwnerInfo = $objDB->sql_query($SQL);
		return $rsOwnerInfo[0]['db_industry'];
	}
	
	
	public function FetchWebProfileImage(){}
	
	protected function removeprofileimage(){}
	
	public function __DESTRUCT()	{
		global $objDB;
		unset($objDB->objModel);
		unset($objDB->objController);
	}
	
} ///// class include_login completed  /////
?>