Company.php

	/**
	 * Returns back true/false for a given permission or the raw value if not 1/0 bool
	 * @param string $name
	 * @return mixed
	 */
	public function getPermission($name) {
		$companyId = $this->getId();
		$planId = $this->getPlan()->getId();

		$con = Propel::getConnection();

		$query = '
		SELECT COALESCE(
			(
			SELECT cp.value
			FROM company_permission cp
			LEFT JOIN default_permission dp
			ON cp.default_permission_id = dp.id
			WHERE cp.company_id = :companyId
			AND dp.name = :permissionName
			)
			*
			(
			SELECT pp.value
			FROM plan_permission pp
			LEFT JOIN default_permission dp
			ON pp.default_permission_id = dp.id
			WHERE pp.plan_id = :planId
			AND dp.name = :permissionName
			)
			*
			(
			SELECT dp.value
			FROM default_permission dp
			WHERE dp.name = :permissionName
			)
		) AS value';

		$stmt = $con->prepare($query);
		$stmt->bindParam(":permissionName", $name, PDO::PARAM_STR);
		$stmt->bindParam(":companyId", $companyId, PDO::PARAM_INT);
		$stmt->bindParam(":planId", $planId, PDO::PARAM_INT);
		$stmt->execute();
		$setting = $stmt->fetch(PDO::FETCH_NUM);

		if($setting[0] == 1)
			$value = true;
		elseif($setting[0] == 0)
			$value = false;
		else
			$value = $setting[0];

		return $value;
	}