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); }