Laravel & MySQL , お知らせ機能 表示日指定ロジック

 

    // =============== お知らせ案内 取得 ============

        $sql = <<< SQL

SELECT

    annai_title,

    start_date,

    annai_test

FROM  

    informs

WHERE start_date <= CURDATE()

AND end_date >= CURDATE()

order by sentence_number desc

SQL;

        $go_index_oshirase = DB::select($sql);

        return [

            'saijou_tel' => $saijou_tel,

            'go_index_oshirase' => $go_index_oshirase

        ];