<?php
define_class(__FILE__, 'MemberSupportRequest');

require_once('class/DB/DBObj.php');
require_once('app/SupportAccount/SupportAccount.php');

class MemberSupportRequest extends DBObj
{
	var $tableName = 'MemberSupportRequest';
	var $itemName = 'Support Request';
	
	function isAlreadyAssigned($id_member, $support_email)
	{
		if (empty($support_email)) {
			return false;
		}
		$sql = "
			SELECT 1
			FROM {$this->db->tblMember2Member} as Member2Member
			JOIN {$this->db->tblMember} as Member
				ON  Member.id = Member2Member.id_parent
				AND Member.email = ".$this->db->quote($support_email, 'text')."
			WHERE Member2Member.id_member = ".$this->db->quote($id_member, 'integer')."
		";
		$res = $this->db->queryOne($sql);
		return (bool)$res;
	}
	
	function getUniqueAccessCode()
	{
		return SupportAccount::getUniqueAccessCode();
	}
	
	function getFromDBByAccessCode($access_code)
	{
		return SupportAccount::getFromDBByAccessCode($access_code);
	}
	
	function isUniqueAccessCode($access_code)
	{
		return SupportAccount::isUniqueAccessCode($access_code);
	}
	
	function getMemberByEmail($email)
	{
		return SupportAccount::getMemberByEmail($email);
	}
	
	function isUniqueMemberEmail($name)
	{
		return SupportAccount::isUniqueMemberEmail($name);
	}
	
	function register()
	{
		return SupportAccount::register();
	}
	
	function assignMember($id_support_account, $id_member)
	{
		return SupportAccount::assignMember($id_support_account, $id_member);
	}
}