<?php

/* <summary>
	 Class contains methods related to state module
	 <author>
	 Beatle Buddy 2017.
	 </author>
	 Version 1.0
   </summary>
*/
 
class include_emailer
{
	/*
	<summary>
		Default constructor
	</summary>	
	*/
	
	function __CONSTRUCT(){
	
	}
	
	protected function EditReligionData(){
		global $objDB;
			
			$str = $this->pg.".html?v=".$this->v;
			
			if ($this->CheckReligionIsExistOrNot($this->ReligionName) ){
					
			ReturnPostFormData($this->DataArr,$str."&ReligionID=".$this->ReligionID,"Religion is alreay taken, please try again with different Religion !",1);
			exit;
			}
			else
			{	
			
			// UPDATE data into user_info table
			
			$SQL = "UPDATE religion SET
				Religion_Name     = '".AddFieldAddslashes($this->ReligionName)."' ,
				IsActive  = '".AddFieldAddslashes($this->IsActive)."',
				UpdatedDate = '".date('Y-m-d H:i:s')."'
				WHERE ReligionID = ".$this->ReligionID;
				
			$Result = $objDB->sql_query($SQL);
			
			if($Result) {
				return true;
			}else{
				return false;	
			}
			
			}			
		}

	protected function InsertUserInfo(){
		global $objDB;
		
			$str = $this->pg.".html?v=".$this->v;
			
			if ($this->CheckReligionIsExistOrNot($this->ReligionName) ){
						
			// return error error value
			ReturnPostFormData($this->DataArr,$str,"Religion is alreay taken, please try again with different Religion !",1);
			exit;
			}else{
			
		// Insert data into user_info table
		
		 $SQL = "INSERT INTO religion SET
			Religion_Name  = '".AddFieldAddslashes($this->ReligionName)."' ,
			IsActive  = '".AddFieldAddslashes($this->IsActive)."',
			IsDeleted = 'N',
			AddedBy = '".$_SESSION['UserInfo']['UserID']."',
			AddedDate = '".date('Y-m-d H:i:s')."'";
			
			$Result = $objDB->sql_query($SQL);
		 	
		 	if($Result)
		 	{
				return true;
		 	} 
			else
			{
				return false;
			}	 
	
		}
	}  ///// InsertUserInfo completed  /////

	public function fetchOrganization(){
		global $objDB;
		
		//$SQL = "SELECT OrgID,BranchID,IndustryID FROM beatle_userlogin WHERE 1 = 1 AND lower(db_usertype) = '".strtolower($_SESSION['UserInfo']['UType'])."' AND userId = ".$_SESSION['UserInfo']['UserID'];
		//$rsOrg = $objDB->sql_query($SQL);

		$SQL = "SELECT OrgId,db_Orgname FROM beatle_organization WHERE OrgId = ".$_SESSION['OtherInfo']['OrgID'];
		$rsOrgInfo = $objDB->sql_query($SQL);
		return $rsOrgInfo;
	}
	
	public function FetchAllUsersData($Val=""){
	
		global $objDB;
		if($this->v == 'report') {
			$SQL = "SELECT * FROM beatle_manage_points WHERE orgid = ".$_SESSION['OtherInfo']['OrgID'] ;
			$SQL .= " ORDER BY created_date DESC ";
			$rsData = $objDB->sql_query($SQL);
		}else{
			$SQL = "SELECT * FROM beatle_purchase WHERE orgid = ".$_SESSION['OtherInfo']['OrgID'] ;
			if(!empty($this->sts) && strtolower($this->sts) != 'all')
			$SQL .= " AND status = '".$this->sts."'";
			$SQL .= " ORDER BY created_date DESC ";
			$rsData = $objDB->sql_query($SQL);
		}
		
		
		return $rsData;	
	}
	
	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 cancelemailrequest(){
		global $objDB;
		
		$SQL =	"UPDATE beatle_purchase SET status = 'cancel' WHERE purchaseid ='".$this->pid."' ";
		$rsInsert=$objDB->sql_query($SQL);
		
		$returnArr = array();
		$returnArr['acn'] = 'FetchAllUsersData';
		$returnArr['v'] = 'list';
		$returnArr['sts'] = $this->sts;
		
		ReturnPostFormData($returnArr,"emailer.html?v=list&sts=".$this->sts,"Your email request has been cancelled successfuly!",0);
		exit;		
		
		
	}
}


?>