<?php
/**
 * eSales Media oxVoucher for Contao Open Source CMS
 *
 * Copyright (c) 2015 eSales Media
 *
 * @author  Benjamin Roth [benjamin@esales-media.de]
 * @license proprietary
 */

$GLOBALS['TL_DCA']['tl_module']['palettes']['oxvoucher_search'] = '{title_legend},name,headline,type;{protected_legend:hide},protected;{expert_legend:hide},guests,cssID,space';
$GLOBALS['TL_DCA']['tl_module']['palettes']['oxvoucher_details'] = '{title_legend},name,headline,type;{protected_legend:hide},protected;{expert_legend:hide},guests,cssID,space';
$GLOBALS['TL_DCA']['tl_module']['palettes']['oxticket_select'] = '{title_legend},name,headline,type;{oxticket_legend},oxticket_category;{protected_legend:hide},protected;{expert_legend:hide},guests,cssID,space';
$GLOBALS['TL_DCA']['tl_module']['palettes']['oxticket_details'] = '{title_legend},name,headline,type;{protected_legend:hide},protected;{expert_legend:hide},guests,cssID,space';

$GLOBALS['TL_DCA']['tl_module']['fields']['oxticket_category'] = array
(
	'label' => &$GLOBALS['TL_LANG']['tl_module']['oxticket_category'],
	'exclude' => true,
	'inputType' => 'select',
	'options_callback' => array('tl_module_oxvoucher', 'getOxCategories'),
	'eval' => array('chosen' => true, 'mandatory'=>true),
	'sql' => "varchar(32) NOT NULL default ''"
);

class tl_module_oxvoucher extends \Backend {

	public function getOxCategories()
	{
		$oxDB = \Voucher::getOxDbInstance();
		$arrCategories = array();

		$objResult = $oxDB->execute("SELECT OXID, OXTITLE FROM oxcategories WHERE OXACTIVE = '1' ORDER BY OXTITLE");

		if ($objResult->numRows)
		{
			while ($objResult->next())
			{
				$arrCategories[$objResult->OXID] = $objResult->OXTITLE;
			}
		}
		return $arrCategories;
	}
}