<?php
/**
* Boxmaker extension for Contao Open Source CMS
*
* Copyright (C) 2013-2014 bekanntmacher
*
* @author Yanick Witschi <yanick.witschi@terminal42.ch>
* @license commercial
*/
namespace Bekanntmacher\BoxmakerBundle\Model;
class TypeModel extends \Model
{
/**
* Table name
* @var string
*/
protected static $strTable = 'tl_boxmaker_type';
/**
* Find all ordered by sorting
* @return \Model\Collection
*/
public static function findAllOrderedBySorting()
{
$t = static::$strTable;
$arrColumns = array("$t.published=1");
return static::findBy($arrColumns, array(), array('order'=>'sorting'));
}
/**
* Find a published article by its ID
* @return TypeModel|null The model or null if there is no published article
*/
public static function findPublishedById($intId, array $arrOptions=array())
{
$t = static::$strTable;
$arrColumns = array("$t.id=? AND $t.published=1");
return static::findOneBy($arrColumns, $intId, $arrOptions);
}
}