public function upload()
{
if (!OW::getUser()->isAuthorized('ivideo', 'add')) {
$this->setTemplate(OW::getPluginManager()->getPlugin('base')->getCtrlViewDir() . 'authorization_failed.html');
return;
}
$eventParams = array('pluginKey' => 'ivideo', 'action' => 'upload_video');
$credits = OW::getEventManager()->call('usercredits.check_balance', $eventParams);
if ($credits === false) {
$this->assign('authMsg', OW::getEventManager()->call('usercredits.error_message', $eventParams));
return;
} else {
$this->assign('authMsg', null);
}
$language = OW::getLanguage();
$config = OW::getConfig();
$uploadForm = new Form('uploadForm');
$uploadForm->setId('THEFORM');
$uploadForm->setEnctype('multipart/form-data');
$element = new TextField('videoName');
$element->setRequired(true);
$element->addValidator(new uploadValidator());
$element->setLabel($language->text('ivideo', 'upload_video_name'));
$uploadForm->addElement($element);
$element = new WysiwygTextarea('videoDescription');
$element->setRequired(true);
$element->setLabel($language->text('ivideo', 'upload_video_desc'));
$uploadForm->addElement($element);
$element = new Selectbox('videoCategory');
$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);
}
$uploadForm->addElement($element);
$tagService = BOL_TagService::getInstance();
$tf = new TagsField('tf');
$tf->setLabel($language->text('ivideo', 'tags_field_label'));
$uploadForm->addElement($tf);
$element = new Submit('uploadVideo');
$element->setValue($language->text('ivideo', 'user_upload_video'));
$uploadForm->addElement($element);
if (OW::getRequest()->isPost()) {
if ($uploadForm->isValid($_POST) && isset($_POST['ax-uploaded-files'])) {
$values = $uploadForm->getValues();
$fileName = OW::getSession()->get('ivideo.filename');
if (is_null($fileName)) {
OW::getFeedback()->error($language->text('ivideo', 'admin_video_not_uploaded_error'));
} else {
$video = new IVIDEO_BOL_Video();
$video->name = ucwords(UTIL_HtmlTag::stripTags($values['videoName']));
$description = UTIL_HtmlTag::stripJs($values['videoDescription']);
$description = UTIL_HtmlTag::stripTags($description, array('frame', 'style'), array(), true);
$video->description = $description;
$video->owner = OW::getuser()->getId();
$video->timestamp = time();
$video->status = $config->getValue('ivideo', 'videoApproval') == 'auto' ? 'approved' : 'pending';
$video->filename = $fileName;
$videoId = IVIDEO_BOL_Service::getInstance()->addVideo($video);
if ($videoId) {
$fullFileName = OW::getPluginManager()->getPlugin('ivideo')->getUserFilesDir() . $fileName;
$imageFileName = OW::getPluginManager()->getPlugin('ivideo')->getUserFilesDir() . $fileName . ".png";
$ffmpegPath = $config->getValue('ivideo', 'ffmpegPath');
if (!empty($ffmpegPath) && file_exists($ffmpegPath)) {
exec("{$ffmpegPath} -y -itsoffset -4 -i '{$fullFileName}' -r 1 -f image2 '{$imageFileName}'");
}
IVIDEO_BOL_VideoCategoryService::getInstance()->setVideoCategories($videoId, $values['videoCategory']);
BOL_TagService::getInstance()->updateEntityTags($video->id, 'ivideo-video', TagsField::getTags($values['tf']));
$event = new OW_Event('feed.action', array('pluginKey' => 'ivideo', 'entityType' => 'ivideo-comments', 'entityId' => $video->id, 'userId' => $video->owner));
OW::getEventManager()->trigger($event);
$this->redirect(OW::getRouter()->urlForRoute('ivideo_view_list', array('type' => 'latest')));
OW::getFeedback()->info($language->text('ivideo', 'admin_upload_video_ok'));
} else {
OW::getFeedback()->error($language->text('ivideo', 'admin_upload_video_fail'));
}
}
}
}
$this->addForm($uploadForm);
if (OW::getSession()->isKeySet('ivideo.filename')) {
OW::getSession()->delete('ivideo.filename');
}
$jsURL = OW::getPluginManager()->getPlugin('ivideo')->getStaticUrl() . 'ajaxupload' . '/';
$this->assign('filesDir', json_encode(OW::getPluginManager()->getPlugin('ivideo')->getUserFilesDir()));
$this->assign('uploadAction', json_encode(OW::getRouter()->urlFor('IVIDEO_CTRL_Upload', 'action')));
$this->assign('maxSize', $config->getValue('ivideo', 'allowedFileSize'));
$this->assign('allowedExtn', UTIL_String::arrayToDelimitedString(explode(",", $config->getValue('ivideo', 'allowedExtensions')), ",", "'", "'"));
$this->assign('allowedExtnText', UTIL_String::arrayToDelimitedString(explode(",", $config->getValue('ivideo', 'allowedExtensions')), ","));
$this->assign('flashURL', $jsURL);
$this->assign('videoApproval', $config->getValue('ivideo', 'videoApproval'));
$theme = $config->getValue('ivideo', 'theme');
OW::getDocument()->addStyleSheet($jsURL . 'css/' . $theme . '/style.css');
OW::getDocument()->addScript($jsURL . "js/ajaxupload-min.js");
$this->setPageHeading(OW::getLanguage()->text('ivideo', 'video_user_upload'));
$this->setPageTitle(OW::getLanguage()->text('ivideo', 'video_user_upload'));
$this->setPageHeadingIconClass('ow_ic_video');
}
public function batchInsertOrUpdateObjectList($tableName, $objects, $batchSize = 50)
{
if ($objects != null && is_array($objects)) {
if (count($objects) > 0) {
$columns = '';
$paramNames = array();
if (is_object($objects[0])) {
$params = get_object_vars($objects[0]);
$paramNames = array_keys($params);
$columns = UTIL_String::arrayToDelimitedString($paramNames, ',', '`', '`');
} else {
throw new InvalidArgumentException('Array of objects expected');
}
$i = 0;
$totalInsertsCount = 0;
$objectsCount = count($objects);
$batchSize = (int) $batchSize;
$inserts = array();
foreach ($objects as $obj) {
$values = '(';
foreach ($paramNames as $property) {
if ($obj->{$property} !== null) {
$values .= '\'' . $this->escapeString($obj->{$property}) . '\',';
} else {
$values .= 'NULL,';
}
}
$values = mb_substr($values, 0, mb_strlen($values) - 1);
$values .= ')';
$inserts[] = $values;
$i++;
$totalInsertsCount++;
if ($i === $batchSize || $totalInsertsCount === $objectsCount) {
$sql = "REPLACE INTO `{$tableName}` ({$columns}) VALUES" . implode(',', $inserts);
$inserts = array();
$i = 0;
$this->execute($sql)->closeCursor();
//$this->connection->query($sql)->closeCursor();
}
}
}
} else {
throw new InvalidArgumentException('Array expected');
}
}
public function calendar()
{
$language = OW::getLanguage();
$config = OW::getConfig();
if (!OW::getUser()->isAuthorized('eventx', 'view_event') && !OW::getUser()->isAuthorized('eventx')) {
$this->assign('authErrorText', $language->text('event', 'event_view_permission_error_message'));
return;
}
$eventsCount = (int) $config->getValue('eventx', 'eventsCount');
$showPast = $config->getValue('eventx', 'showPastEvents') == '1' ? true : false;
$events = $this->eventService->findPublicEvents(null, $eventsCount, $showPast);
$resultArray = array();
foreach ($events as $eventItem) {
$resultArray[$eventItem->getId()] = array('title' => addslashes(UTIL_String::truncate(strip_tags($eventItem->getTitle()), 80, "...")), 'startTimeStamp' => date("Y-m-d H:i:s", $eventItem->startTimeStamp), 'endTimeStamp' => date("Y-m-d H:i:s", $eventItem->endTimeStamp), 'endDateFlag' => $eventItem->endDateFlag, 'eventUrl' => OW::getRouter()->urlForRoute('eventx.view', array('eventId' => $eventItem->getId())));
}
$this->assign('events', $resultArray);
$this->assign('openLinksType', $config->getValue('eventx', 'openLinksType'));
$this->assign('isRTLLanguage', $config->getValue('eventx', 'isRTLLanguage'));
$this->assign('showWeekends', $config->getValue('eventx', 'showWeekends'));
$this->assign('calendarHeight', $config->getValue('eventx', 'calendarHeight'));
$this->assign('firstWeekDay', $config->getValue('eventx', 'firstWeekDay'));
$this->assign('militaryTime', (bool) OW::getConfig()->getValue('base', 'military_time') ? '1' : '0');
OW::getDocument()->addStyleSheet(OW::getPluginManager()->getPlugin("eventx")->getStaticCssUrl() . 'fullcalendar.css');
OW::getDocument()->addScript(OW::getPluginManager()->getPlugin("eventx")->getStaticJsUrl() . 'fullcalendar.min.js');
$fullMonth = $halfMonth = $fullWeek = $halfWeek = array();
for ($i = 0; $i <= 6; $i++) {
$fullWeek[] = $language->text('base', 'date_time_week_' . $i);
$halfWeek[] = $language->text('eventx', 'half_week_' . $i);
}
for ($i = 1; $i <= 12; $i++) {
$fullMonth[] = $language->text('base', 'month_' . $i);
$halfMonth[] = $language->text('base', 'date_time_month_short_' . $i);
}
$this->assign('fullWeek', UTIL_String::arrayToDelimitedString($fullWeek, ",", "'", "'"));
$this->assign('halfWeek', UTIL_String::arrayToDelimitedString($halfWeek, ",", "'", "'"));
$this->assign('fullMonth', UTIL_String::arrayToDelimitedString($fullMonth, ",", "'", "'"));
$this->assign('halfMonth', UTIL_String::arrayToDelimitedString($halfMonth, ",", "'", "'"));
$contentMenu = $this->eventService->getContentMenu();
$this->addComponent('contentMenu', $contentMenu);
if (!OW::getUser()->isAuthorized('eventx', 'add_event')) {
$this->assign('noButton', true);
}
$this->setPageTitle($language->text('eventx', 'calendar_page_title'));
$this->setPageHeading($language->text('eventx', 'calendar_page_heading'));
$this->setPageHeadingIconClass('ow_ic_calendar');
}