<?php
/************************************************************************/
/* AChecker                                                             */
/************************************************************************/
/* Copyright (c) 2008 by Greg Gay, Cindy Li                             */
/* Adaptive Technology Resource Centre / University of Toronto          */
/*                                                                      */
/* This program is free software. You can redistribute it and/or        */
/* modify it under the terms of the GNU General Public License          */
/* as published by the Free Software Foundation.                        */
/************************************************************************/

/**
* DAO for "subgroup_checks" table
* @access	public
* @author	Cindy Qi Li
* @package	DAO
*/

if (!defined('AC_INCLUDE_PATH')) exit;

require_once(AC_INCLUDE_PATH. 'classes/DAO/DAO.class.php');

class SubgroupChecksDAO extends DAO {

	/**
	* Create a new entry of subgroup_id <=> check_id relationship
	* @access  public
	* @param   $groupID : guideline subgroup id
	*          $checkID : check ID
	* @return  true : if successful
	*          false : if not successful
	* @author  Cindy Qi Li
	*/
	public function Create($subgroupID, $checkID)
	{
		$sql = "INSERT INTO ".TABLE_PREFIX."subgroup_checks
				(`subgroup_id`, `check_id`) 
				VALUES
				(".$subgroupID.",".$checkID.")";

		if (!$this->execute($sql))
		{
			$msg->addError('DB_NOT_UPDATED');
			return false;
		}
		else
		{
			return true;
		}
	}
	
	/**
	* Delete given check, identified by check ID, from given guideline
	* @access  public
	* @param   $type: "guideline", "group", "subgroup"
	*          $typeID : guideline id if type = "guideline"
	*                    group id if type = "group"
	*                    subgroup id if type = "subgroup"
	*          $checkID : check ID to delete
	* @return  true : if successful
	*          false : if unsuccessful
	* @author  Cindy Qi Li
	*/
	public function deleteChecksByTypeAndID($type, $typeID, $checkID)
	{
		if ($type == "guideline")
		{
			$sql = "DELETE FROM ".TABLE_PREFIX."subgroup_checks
			         WHERE subgroup_id in (SELECT distinct subgroup_id 
			                                 FROM ".TABLE_PREFIX."guideline_groups gg, "
			                                       .TABLE_PREFIX."guideline_subgroups gs
			                                 WHERE gg.guideline_id=".$typeID."
			                                   AND gg.group_id = gs.group_id)
			           AND check_id = ".$checkID;
		}
		
		if ($type == "group")
		{
			$sql = "DELETE FROM ".TABLE_PREFIX."subgroup_checks
			         WHERE subgroup_id in (SELECT distinct subgroup_id 
			                                 FROM ".TABLE_PREFIX."guideline_groups gg, "
			                                       .TABLE_PREFIX."guideline_subgroups gs
			                                 WHERE gg.group_id=".$typeID."
			                                   AND gg.group_id = gs.group_id)
			           AND check_id = ".$checkID;
		}
		
		if ($type == "subgroup")
		{
			$sql = "DELETE FROM ".TABLE_PREFIX."subgroup_checks
		             WHERE subgroup_id = ".$typeID."
		               AND check_id = ".$checkID;
		}
		
		return $this->execute($sql);
	}
	
	/**
	* Delete all entries with given check id
	* @access  public
	* @param   $checkID
	* @return  true : if successful
	*          false : if not successful
	* @author  Cindy Qi Li
	*/
	public function DeleteByCheckID($checkID)
	{
		$sql = "DELETE FROM ".TABLE_PREFIX."subgroup_checks
				WHERE check_id = ".$checkID;

		return $this->execute($sql);
	}
	
	/**
	* Delete all entries with given subgroup id
	* @access  public
	* @param   $subgroupID
	* @return  no returns
	*          Note that this function is called by GuidelineGroupsDAO->DeleteByGroupID, 
	*          return true or false from this function forces the caller return too.
	* @author  Cindy Qi Li
	*/
	public function DeleteBySubgroupID($subgroupID)
	{
		$sql = "DELETE FROM ".TABLE_PREFIX."subgroup_checks
				WHERE subgroup_id = ".$subgroupID;

		return $this->execute($sql);
	}
	
}
?>