=== REF status ===
  ARTICLE_STATUS: ACTIVE (Aktif) | INACTIVE (Tidak Aktif) | ARCHIVE (Arkib)
  SPEECH_STATUS: PUBLISHED (Terbit) | DRAFT (Draf) | ARCHIVED (Arkib)
  MEDIA_STATUS: PUBLISHED (Published) | DRAFT (Draft) | ARCHIVED (Archived)
  SPEECH_CATEGORY: UCAPAN (Ucapan) | PERASMIAN (Perasmian) | MAJLIS (Majlis) | KENYATAAN (Kenyataan)
  ARTICLE_CATEGORY: (tiada)

=== TRAIT HasPublishWindow ===
  fail: /app/Models/Concerns/HasPublishWindow.php
   13: * @return array{status:string,start_date:string,start_time:string,end_date:string,end_time:string}
   15: abstract public static function publishWindowColumns(): array;
   17: public function getPublishStartAttribute(): ?Carbon
   30: public function getPublishEndAttribute(): ?Carbon
   43: public function scopePublished(Builder $query): Builder
   54: return $query->where($columns['status'], 'ACTIVE')
   55: ->where(function ($q) use ($today, $time, $startDate, $startTime) {
   56: $q->whereNull($startDate)
   57: ->orWhere($startDate, '')
   58: ->orWhere($startDate, '<', $today)
   59: ->orWhere(function ($q) use ($today, $time, $startDate, $startTime) {
   60: $q->where($startDate, $today)
   61: ->where(function ($q) use ($time, $startTime) {
   62: $q->whereNull($startTime)
   63: ->orWhere($startTime, '')
   64: ->orWhere($startTime, '<=', $time);
   68: ->where(function ($q) use ($today, $time, $endDate, $endTime) {
   69: $q->whereNull($endDate)
   70: ->orWhere($endDate, '')
   71: ->orWhere($endDate, '>', $today)
   72: ->orWhere(function ($q) use ($today, $time, $endDate, $endTime) {
   73: $q->where($endDate, $today)
   74: ->where(function ($q) use ($time, $endTime) {
   75: $q->whereNull($endTime)
   76: ->orWhere($endTime, '')
   77: ->orWhere($endTime, '>=', $time);

=== data speeches (semua baris) ===
  #12 main='1' parent=NULL lang=en status=PUBLISHED date=2026-10-22 cat=UCAPAN file=content-speech/files/TALKING POINTS - ENGAGEMENT BERSAMA MEDIA ISU JEREBU_20261022_2f3e0.pdf
      title: TALKING POINTS - ENGAGEMENT BERSAMA MEDIA ISU JEREBU
  #17 main='0' parent='12' lang=ms status=PUBLISHED date=2026-10-22 cat=UCAPAN file=content-speech/files/TEMPLATE EMEL PORTAL REDDPLUS DAN SISTEM MYSIS_20261022_30f9f.docx
      title: CAKAP POINT
  #26 main='1' parent=NULL lang=ms status=PUBLISHED date=2026-08-14 cat=PERASMIAN file=content-speech/files/contoh/teks-ucapan-bm.pdf
      title: Teks Ucapan Perasmian Seminar Perhutanan Lestari 2026
  #27 main='0' parent='26' lang=en status=PUBLISHED date=2026-08-14 cat=PERASMIAN file=content-speech/files/contoh/teks-ucapan-bi.pdf
      title: Opening Speech: Sustainable Forestry Seminar 2026
  #28 main='1' parent=NULL lang=ms status=PUBLISHED date=2026-04-09 cat=UCAPAN file=content-speech/files/contoh/teks-ucapan-bm.pdf
      title: Ucapan Aluan Mesyuarat Majlis Perhutanan Negara
  #29 main='0' parent='28' lang=en status=PUBLISHED date=2026-04-09 cat=UCAPAN file=content-speech/files/contoh/teks-ucapan-bi.pdf
      title: Welcoming Remarks: National Forestry Council Meeting
  #30 main='1' parent=NULL lang=ms status=PUBLISHED date=2025-10-21 cat=MAJLIS file=content-speech/files/contoh/teks-ucapan-bm.pdf
      title: Ucapan Majlis Apresiasi Warga NRES 2025
  #31 main='0' parent='30' lang=en status=PUBLISHED date=2025-10-21 cat=MAJLIS file=content-speech/files/contoh/teks-ucapan-bi.pdf
      title: Speech: NRES Staff Appreciation Ceremony 2025
  #32 main='1' parent=NULL lang=ms status=PUBLISHED date=2024-06-05 cat=UCAPAN file=content-speech/files/contoh/teks-ucapan-bm.pdf
      title: Teks Ucapan Simposium Geosains Kebangsaan 2024
  #33 main='0' parent='32' lang=en status=PUBLISHED date=2024-06-05 cat=UCAPAN file=content-speech/files/contoh/teks-ucapan-bi.pdf
      title: Speech Text: National Geoscience Symposium 2024
  #34 main='1' parent=NULL lang=ms status=PUBLISHED date=2026-09-05 cat=MAJLIS file=content-speech/files/contoh/teks-ucapan-bm.pdf
      title: Ucapan Perasmian Majlis Sambutan Hari Alam Sekitar Negara 2026
  #35 main='0' parent='34' lang=en status=PUBLISHED date=2026-09-05 cat=MAJLIS file=content-speech/files/contoh/teks-ucapan-bi.pdf
      title: Opening Speech: National Environment Day Celebration 2026
  #36 main='1' parent=NULL lang=ms status=PUBLISHED date=2026-02-18 cat=PERASMIAN file=content-speech/files/contoh/teks-ucapan-bm.pdf
      title: Ucapan Perasmian Karnival Hijau Peringkat Kebangsaan 2026
  #37 main='0' parent='36' lang=en status=PUBLISHED date=2026-02-18 cat=PERASMIAN file=content-speech/files/contoh/teks-ucapan-bi.pdf
      title: Opening Speech: National Green Carnival 2026
  #38 main='1' parent=NULL lang=ms status=PUBLISHED date=2025-06-11 cat=UCAPAN file=content-speech/files/contoh/teks-ucapan-bm.pdf
      title: Ucapan Penutup Kursus Kepimpinan NRES 2025
  #39 main='0' parent='38' lang=en status=PUBLISHED date=2025-06-11 cat=UCAPAN file=content-speech/files/contoh/teks-ucapan-bi.pdf
      title: Closing Speech: NRES Leadership Course 2025

=== artikel (0 baris?) ===
  content_article: 17 | translation: 31