Malaysia Coastal, Oceanography and Hydraulic Marine Geospatial Data Management System (MYCOAST)

Something went wrong

Page ID : 11
Content ID : 30
SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: '' The SQL being executed was: SELECT COUNT(*) FROM `content_video` INNER JOIN `content_video_translation` ON content_video.video_id=content_video_translation.video_translation_parent_id WHERE (`content_video_translation`.`video_translation_main` = '1') AND (`content_video`.`video_status` = 'active') AND ((DATE(publish_date_start) = '') OR (DATE(publish_date_start) = '0000-00-00') OR (DATE(publish_date_start) IS NULL) OR ((DATE(publish_date_start) <= '2025-12-06') AND (`publish_time_start` <= '13:05:52'))) AND ((DATE(publish_date_end) = '') OR (DATE(publish_date_end) = '0000-00-00') OR (DATE(publish_date_end) IS NULL) OR ((DATE(publish_date_end) >= '2025-12-06') AND (`publish_time_end` >= '13:05:52')))
Content :

use yii\helpers\Html;
use yii\grid\GridView;
use yii\helpers\Url;
use yii\helpers\ArrayHelper;
use yii\data\ActiveDataProvider;
use yii\widgets\ActiveForm;
use yii\widgets\ListView;
use backend\modules\contentVideo\models\ContentVideo;

$label_searching = '';
echo '<div class="col-lg-9">';

$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 = '<h4 class="mb-40">Paparan video <b>'.Yii::$app->getRequest()->getQueryParam('search_keyword').'</b></h4>';
    $query->andfilterwhere(['LIKE','video_translation_title',Yii::$app->getRequest()->getQueryParam('search_keyword')]);
}

if(!empty(Yii::$app->getRequest()->getQueryParam('source'))){
    $label_searching = '<h4 class="mb-40">Paparan video <b>'.Yii::$app->getRequest()->getQueryParam('source').'</b></h4>';
    $query->andfilterwhere(['=','video_source',Yii::$app->getRequest()->getQueryParam('source')]);
}
if(!empty(Yii::$app->getRequest()->getQueryParam('branch'))){
    $label_searching = '<h4 class="mb-40">Paparan video <b>'.\backend\modules\refdynawebv2\models\Ref::getDesc('BRANCH', Yii::$app->getRequest()->getQueryParam('branch'), 'descr').'</b></h4>';
    $query->andfilterwhere(['LIKE','video_page','"'.Yii::$app->getRequest()->getQueryParam('branch').'"']);
}

if(!empty($search_year)){
    $label_searching = '<h4 class="mb-40">Paparan video <b>'.$search_year.'</b></h4>';
    $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 = '<iframe width="100%"  height="300" src="'.$model['video_url'].'" frameborder="0"></iframe>';
            $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 '<div class="blog-entry mb-50" style="background:#ffffff;">
            <div class="blog-image-custom" style="background-size:cover;background-position:center center;background-repeat:no-repeat;
            height:300px;background-color:#dedede;background-image:url('.$videoThumbnail.')"></div>
            <div class="blog-detail" style="background:#ffffff;background:url('.Url::base(true).'/assets/portal/images/newsbg.png) no-repeat;background-size:100%;background-position:top;">
                <div class="entry-title mb-10 blog-title-custom"><a href="'.Url::base(true).'/portal-main/video-gallery-details?id='.$model['video_code'].'">'.$model['video_translation_title'].'</a></div>
                    <ul class="list list-unstyled mb-30">
                        <li> <i class="fa fa-folder-open-o"></i> '.$model['video_source'].'</li>
                        <li> <i class="fa fa-calendar-o"></i>  '.$video_date.'</li>
                    </ul>
                    <div class="entry-share clearfix">
                        <div class="entry-button">
                            <a class="button arrow button-custom" href="'.$videoUrl.'" target="_blank">
                                View Video<i class="fa fa-angle-right" aria-hidden="true"></i>
                            </a>
                        </div>
                    </div>
                </div>
            </div>';
    },
]);
echo '</div>';

Video Gallery

Something went wrong

Search

Latest Video