<?php

class subgenre{

	public static function get_all_subgenres($wrapperObj, $arrange_by='', $case='')
	{
		$subgenreArr = array();
		$subgenre_query = "SELECT genre_id, orchard_id, name FROM subgenre WHERE orchard_id IS NOT NULL ORDER BY genre_id, orchard_id, name";
		$subgenre_result = $wrapperObj->executeQuery($subgenre_query, []);
		if ($subgenre_result === false) {
		    show_pdo_error($subgenre_query, $wrapperObj->getLastStatement());
		}
	
		foreach ($subgenre_result as $RowData) {
			if($case=='lowercase'){
				$RowData['name'] = strtolower($RowData['name']);
			}
			if($arrange_by=='genre'){
				$subgenreArr[$RowData['genre_id']][$RowData['orchard_id']] = $RowData['name'];
			} else {
				$subgenreArr[$RowData['orchard_id']]['genre'] = $RowData['genre_id'];
				$subgenreArr[$RowData['orchard_id']]['subgenre'] = $RowData['name'];
			}
		}
		return $subgenreArr;
	}
}