public static function getInstance()
{
if (self::$classInstance === null) {
self::$classInstance = new self();
}
return self::$classInstance;
}
public function getAllVideoCategories($page, $limit)
{
$first = ($page - 1) * $limit;
$categoryDao = IVIDEO_BOL_CategoryDao::getInstance();
$videoDao = IVIDEO_BOL_VideoDao::getInstance();
$query = "\n SELECT a.categoryId, b.name, b.description, count( * ) count\n FROM " . $this->getTableName() . " AS a," . $categoryDao->getTableName() . " AS b," . $videoDao->getTableName() . " AS c " . "WHERE a.categoryId = b.id\n AND c.id = a.videoId\n AND c.status = 'approved'\n GROUP BY a.categoryId\n ORDER BY count DESC\n LIMIT ?, ?\n ";
return $this->dbo->queryForList($query, array($first, $limit));
}
public function __construct($videoId)
{
parent::__construct('videoEditForm');
$language = OW::getLanguage();
$videoIdField = new HiddenField('id');
$videoIdField->setRequired(true);
$this->addElement($videoIdField);
$titleField = new TextField('name');
$titleField->addValidator(new StringValidator(1, 128));
$titleField->setRequired(true);
$this->addElement($titleField->setLabel($language->text('ivideo', 'upload_video_name')));
$descField = new WysiwygTextarea('description');
$this->addElement($descField->setLabel($language->text('ivideo', 'upload_video_desc')));
$element = new Selectbox('category');
$element->setRequired(true);
$element->setLabel($language->text('ivideo', 'admin_video_category'));
foreach (IVIDEO_BOL_CategoryDao::getInstance()->findAll() as $category) {
$element->addOption($category->id, $category->name);
}
$this->addElement($element);
$entityTags = BOL_TagService::getInstance()->findEntityTags($videoId, 'ivideo-video');
if ($entityTags) {
$tags = array();
foreach ($entityTags as $entityTag) {
$tags[] = $entityTag->label;
}
$tagsField = new TagsField('tags', $tags);
} else {
$tagsField = new TagsField('tags');
}
$this->addElement($tagsField->setLabel($language->text('ivideo', 'tags_field_label')));
$submit = new Submit('edit');
$submit->setValue($language->text('ivideo', 'button_edit_label'));
$this->addElement($submit);
}
public function getCategoryId($category)
{
return IVIDEO_BOL_CategoryDao::getInstance()->getCategoryId($category);
}
