<?php

/**
 * Description of Slide
 *
 * @author janusz
 */
class Banner_Model_Bannerslides extends Rtn_Model {

	const NAME = 'bannerslides';
	
	public function getActiveItems() {
		
		return R::find(self::NAME, 'WHERE `active` = \'1\' AND `is_available` = \'1\' ORDER BY `order` ASC');
        }

	public function getInactiveItems() {
		
		return R::find(self::NAME, 'WHERE `active` = \'0\' AND `is_available` = \'1\' ORDER BY `order` ASC');
        }

	public function getSlideUrl($slide_id) {
		
		return R::findOne(self::NAME, 'WHERE `id` = ?', [$slide_id]);
        }
	
	public function createSlideRow($filename, $link = null, $slogan = null, $alt=  null) {
		$bean = R::dispense(self::NAME);
		$bean->extension = Eppe_Tools::getFileExtension($filename);
		$bean->active = 0;
		$bean->order = 99;
		$bean->created = date('Y-m-d H:i:s');
		
		if($link)
			$bean->url = $link;
		
		if($slogan)
			$bean->slogan = $slogan;
		
		if($alt)
			$bean->alt = $alt;
		return R::store($bean);
        }
	
}