';
$search_year = Yii::$app->getRequest()->getQueryParam('search_year');
$query = new \yii\db\Query();
$query->select(['*'])->from('content_video')
->innerJoin('content_video_translation','content_video.video_id=content_video_translation.video_translation_parent_id')
->where(['=','content_video_translation.video_translation_main','1'])
->andwhere(['=','content_video.video_status','active'])
->andwhere(['OR',
['=','DATE(publish_date_start)',''],
['=','DATE(publish_date_start)','0000-00-00'],
['is','DATE(publish_date_start)',NULL],
['AND',['<=','DATE(publish_date_start)',date('Y-m-d')],['<=','publish_time_start',date('H:i:s')]],
])
->andwhere(['OR',
['=','DATE(publish_date_end)',''],
['=','DATE(publish_date_end)','0000-00-00'],
['is','DATE(publish_date_end)',NULL],
['AND',['>=','DATE(publish_date_end)',date('Y-m-d')],['>=','publish_time_end',date('H:i:s')]],
]);
if(!empty(Yii::$app->getRequest()->getQueryParam('search_keyword'))){
$label_searching = '
Paparan video '.Yii::$app->getRequest()->getQueryParam('search_keyword').'
';
$query->andfilterwhere(['LIKE','video_translation_title',Yii::$app->getRequest()->getQueryParam('search_keyword')]);
}
if(!empty(Yii::$app->getRequest()->getQueryParam('source'))){
$label_searching = '
Paparan video '.Yii::$app->getRequest()->getQueryParam('source').'
';
$query->andfilterwhere(['=','video_source',Yii::$app->getRequest()->getQueryParam('source')]);
}
if(!empty(Yii::$app->getRequest()->getQueryParam('branch'))){
$label_searching = '
Paparan video '.\backend\modules\refdynawebv2\models\Ref::getDesc('BRANCH', Yii::$app->getRequest()->getQueryParam('branch'), 'descr').'
';
$query->andfilterwhere(['LIKE','video_page','"'.Yii::$app->getRequest()->getQueryParam('branch').'"']);
}
if(!empty($search_year)){
$label_searching = '
Paparan video '.$search_year.'
';
$query->andfilterwhere(['=','YEAR(video_date)',$search_year]);
}
$query->orderBy(['content_video.video_sorting' => SORT_ASC]);
$dataProvider = new ActiveDataProvider([
'query' => $query,
//'sort' => ['defaultOrder' => ['gallery_date' => SORT_DESC]],
'pagination' => ['pageSize' => 4,'route' => 'portal-main/video-gallery-list'],
]);
echo $label_searching;
echo ListView::widget([
'summary' => '',
'emptyText' => 'Tiada rekod dijumpai.',
'dataProvider' => $dataProvider,
'itemOptions' => ['tag' => 'div','class' => 'col-lg-6 col-md-6 col-sm-6',],
'options' => ['tag' => 'div','class' => 'row',],
'itemView' => function ($model, $key, $index, $widget) {
$videoThumbnail = Url::base(true).'/assets/img/noimage.jpg';
$videoUrl = '';
if(!empty($model['video_img']))
$videoThumbnail = Url::base(true).'/'.$model['video_img'];
if($model['video_category'] == 'youtube') {
//$videoThumbnail = '
';
$videoUrl = $model['video_url'];
}
if($model['video_category'] == 'external')
$videoUrl = $model['video_external'];
if($model['video_category'] == 'upload')
$videoUrl = $baseUrl.'/'.$model['video_upload'];
$video_date = date("j", strtotime($model['video_date'])).' '.Yii::t('app', date("F", strtotime($model['video_date']))).' '.date("Y", strtotime($model['video_date']));
return '
- '.$model['video_source'].'
- '.$video_date.'
';
},
]);
echo '
';