DYNALEARN | Forgot Password

Something went wrong

Page ID : 6
Content ID : 80
SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: '' The SQL being executed was: SELECT t2.announcement_translation_title AS announcement_title, t2.announcement_translation_content AS announcement_content, t1.announcement_url FROM content_announcement t1 INNER JOIN content_announcement_translation t2 ON t2.announcement_translation_parent_id=t1.announcement_id WHERE t2.announcement_translation_main=1 AND t1.announcement_category='public' AND t1.announcement_status='active' AND (t1.announcement_date IS NULL OR t1.announcement_date='' OR t1.announcement_date<'2025-12-11') AND (t1.announcement_end_date IS NULL OR t1.announcement_end_date='' OR t1.announcement_end_date>'2025-12-11') ORDER BY t1.announcement_sorting ASC
Content :

$listAnnouncement = '';
$queryAnnouncement = "SELECT 
        t2.announcement_translation_title AS announcement_title,  
        t2.announcement_translation_content AS announcement_content,
        t1.announcement_url
    FROM content_announcement t1
    INNER JOIN content_announcement_translation t2 ON t2.announcement_translation_parent_id=t1.announcement_id 
    WHERE 
        t2.announcement_translation_main=1 AND 
        t1.announcement_category='public' AND 
        t1.announcement_status='active' AND 
        (t1.announcement_date IS NULL OR t1.announcement_date='' OR t1.announcement_date<'".date('Y-m-d')."') AND 
        (t1.announcement_end_date IS NULL OR t1.announcement_end_date='' OR t1.announcement_end_date>'".date('Y-m-d')."')
    ORDER BY t1.announcement_sorting ASC";
    $modelAnnouncement = Yii::$app->db->createCommand($queryAnnouncement)->queryAll();
    $listAnnouncement = '<ul>';
    if(!empty($modelAnnouncement)){
        foreach($modelAnnouncement as $rowAnnouncement){
            $listAnnouncement .= '<li>'.$rowAnnouncement['announcement_content'].'</li>';            
        }
    }
    $listAnnouncement .= '</ul>';
                
echo '</div>
                            </div>
                            <div class="col-xs-12 col-md-6">
                                <div class="postit">
                                    <div class="mt-2">
                                        <h5 class="text-title text-center">Announcement</h5>
                                        <p class="text-muted text-center">Please take note to the announcement and information below;</p>
                                        '.$listAnnouncement.'
                                    </div>
                                </div>
                            </div>
                            
                        </div>
                        <div class="row align-items-center justify-content-center">
                            <div class="col-xs-12 text-center">
                                <div class="footerbg mt-2 pt-3 pb-3">© <script>document.write(new Date().getFullYear())</script> 
                                DYNALEARN</div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>';

Chat Bersama JPPM
Chatbot MYLATIHAN JPPM

Hi, Saya Chatbot JPPM. Sila kemukakan pertanyaan anda mengenai Sistem MyLatihan dan saya akan cuba mendapatkan jawapan dari gedung ilmu atas talian.

Hi, Saya Admin JPPM. Saya sedia chat dengan anda secara terus. Bagaimana saya boleh membantu anda?

Forgot Password ?

Something went wrong