<?php
require_once(__DIR__ . '/../../../../vendor/autoload.php');

class rating_advisory_system{
	
	public static function get_all_ratings($video_type, $wrapperObj)
	{
		$ratingArr = array();
		$query = 'SELECT rating_advisory_system_id, system_code, type, code FROM rating_advisory_system
		    WHERE video_type = ? ORDER BY rating_advisory_system_id';
		$result = $wrapperObj->executeQuery($query, [$video_type]);
		if ($result === false) {
		    show_pdo_error($query, $wrapperObj->getLastStatement());
		}
		foreach ($result as $RowData) {
			$key = $RowData['system_code'];
			$ratingArr[$key][$RowData['type']][$RowData['rating_advisory_system_id']] = $RowData['code'];
		}
		return $ratingArr;
	}

	public static function get_rating_system($system_code)
	{
		$system_name = '';
		$rating_type = 'rating';
		
		switch ($system_code) {
			case 'us_tv_rating':
				$system_name = 'us-tv';
				break;
			case 'us_advisory_labels':
				$system_name = 'us-tv';
				$rating_type = 'advisory';
				break;
			case 'ca_tv_rating':
				$system_name = 'ca-tv';
				break;
			case 'uk_tv_rating':
				$system_name = 'uk-tv';
				break;
			case 'de_tv_rating':
				$system_name = 'de-tv';
				break;
			case 'fr_tv_rating':
				$system_name = 'fr-tv';
				break;
			case 'au_tv_rating':
				$system_name = 'au-tv';
				break;
			case 'au_advisory_labels':
				$system_name = 'au-tv';
				$rating_type = 'advisory';
				break;
			case 'us_film_rating':
				$system_name = 'mpaa';
				break;
			case 'uk_film_rating':
				$system_name = 'bbfc';
				break;
			case 'ca_film_rating':
				$system_name = 'ca-chvrs';
				break;
			case 'de_film_rating':
				$system_name = 'de-fsk';
				break;
			case 'fr_film_rating':
				$system_name = 'fr-cnc';
				break;
			case 'au_film_rating':
				$system_name = 'au-oflc';
				break;
			case 'nz_film_rating':
				$system_name = 'nz-oflc';
				break;
			case 'jp_film_rating':
				$system_name = 'jp-eirin';
				break;
			default:
				$system_name = 'invalid-system-name';
		}
		return array('system'=>$system_name, 'type'=>$rating_type);
	}
}
	
?>