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

Something went wrong

Page ID : 1
Content ID : 112
SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: '' The SQL being executed was: SELECT * FROM `content_announcement` INNER JOIN `content_announcement_translation` ON content_announcement.announcement_id=content_announcement_translation.announcement_translation_parent_id WHERE (`content_announcement_translation`.`announcement_translation_language` = 'Malay') AND (`content_announcement`.`announcement_portal` LIKE '%\"16\"%') AND (`content_announcement`.`announcement_status` = 'active') AND (`content_announcement`.`announcement_type` = 'popup') AND ((`content_announcement`.`announcement_start_date` = '') OR (`content_announcement`.`announcement_start_date` = '0000-00-00') OR (`content_announcement`.`announcement_start_date` IS NULL) OR (`content_announcement`.`announcement_start_date` <= '2025-12-06')) AND ((`content_announcement`.`announcement_end_date` = '') OR (`content_announcement`.`announcement_end_date` = '0000-00-00') OR (`content_announcement`.`announcement_end_date` IS NULL) OR (`content_announcement`.`announcement_end_date` >= '2025-12-06')) ORDER BY `content_announcement`.`announcement_sort`
Content :

$announcementListpopup = '';
$queryAnnouncementpopup = new \yii\db\Query(); 
$queryAnnouncementpopup->select(['*'])->from('content_announcement')
    ->innerJoin('content_announcement_translation','content_announcement.announcement_id=content_announcement_translation.announcement_translation_parent_id')
    //->where(['=','content_announcement_translation.announcement_translation_main','1'])
    ->where(['=','content_announcement_translation.announcement_translation_language',Yii::$app->language])
    ->andwhere(['LIKE','content_announcement.announcement_portal','"16"'])
    ->andwhere(['=','content_announcement.announcement_status','active'])
    ->andwhere(['=','content_announcement.announcement_type','popup'])
    ->andwhere(['OR',
        ['=','content_announcement.announcement_start_date',''],
        ['=','content_announcement.announcement_start_date','0000-00-00'],
        ['is','content_announcement.announcement_start_date',NULL],
        ['<=','content_announcement.announcement_start_date',date('Y-m-d')],
    ])
    ->andwhere(['OR',
        ['=','content_announcement.announcement_end_date',''],
        ['=','content_announcement.announcement_end_date','0000-00-00'],
        ['is','content_announcement.announcement_end_date',NULL],
        ['>=','content_announcement.announcement_end_date',date('Y-m-d')],
    ])
    ->orderBy(['content_announcement.announcement_sort' => SORT_ASC]);
$modelAnnouncementpopup = $queryAnnouncementpopup->all();

$popupdisplay = false;

if(!empty($modelAnnouncementpopup)){
    $popupdisplay = true;
    foreach($modelAnnouncementpopup as $rowAnnouncementpopup){
        $announcementImgpopup = $baseUrl.'/assets/img/default.png';
        if(!empty($rowAnnouncementpopup['announcement_img']))
            $announcementImgpopup = $baseUrl.'/admin/'.$rowAnnouncementpopup['announcement_img'];
        $announcementListpopup .= '
        <div class="item">
            <div class="entry-image clearfix">
        ';
        
        
        if (!empty($rowAnnouncementpopup['announcement_url'])) {
                $announcementListpopup .= '<a href="'.$rowAnnouncementpopup['announcement_url'].'" target="_blank">';
        }
        
         $announcementListpopup .= '
                <img class="img-fluid" src="'.$announcementImgpopup.'" alt="">
                
        ';
        
        if (!empty($rowAnnouncementpopup['announcement_url'])) {
                $announcementListpopup .= '</a>';
        }
            
         $announcementListpopup .= '    </div>
            
        </div>';
    }
}

echo '

<div class="modal-content">
            <div class="modal-header" style="padding: 10px 10px 0 10px;">
                <div class="row" style="margin:0;padding:0;display:contents;">
                    <div class="col-xs-9" style="text-align:left;width:70%;">
                        <b>PENGUMUMAN</b>
                    </div>
                    <div class="col-xs-3" style="text-align:right;width:30%;">
                        <button type="button" class="close" data-dismiss="modal" style="color:#333;visibility:visible;">×</button>
                
                    </div>
                </div>
                
                
            </div>
            <div class="modal-body" style="color:#333;visibility:visible;">
                <div style="width:100%;text-align:center;">
                    <div id="carouselannouncementpopup" class="owl-carousel blog-entry pb-2" data-nav-dots="true" data-items="1" data-md-items="1" data-sm-items="1" data-xs-items="1" data-xx-items="1" 
                data-space="0" data-nav-arrow="false" style="margin:0;background:#fff;margin-bottom:10px;width:100%;">
                    '.$announcementListpopup .'
                    </div>
                </div>
                
            </div>

<div class="modal-footer" style="padding: 10px 10px 0 10px;">
                
                <p style="width:100%;text-align:center;"><small>
                    <b>Jabatan Pendaftaran Pertubuhan Malaysia (JPPM)</b><br>
                    <a href="tel:+60388702601" style="color:#333333;"><i class="fa fa-phone" aria-hidden="true"></i>   +603.88702601</a>,
                 <a href="tel:+60388702617" style="color:#333333;"><i class="fa fa-phone" aria-hidden="true"></i>   +603.88702617</a>
                </small></p>
            </div>
        </div>
    </div>
</div>
';

if ($popupdisplay) {
    echo '
        <script>
            $( document ).ready(function() {
                $("#promosiModal").modal();
            });
        </script>
    ';
}

WELCOME TO MYCOAST NAHRIM

National Coastal
Risk Map

Digital Coast

Publications

Multimedia

Useful Links

Something went wrong

WELCOME TO MYCOAST NAHRIM

National CoastalRisk Map

Digital Coast

Publications

Multimedia

Useful Links

Something went wrong

National Coastal
Risk Map