請求データ１作成

会議テーブル・椅子を使用した場合の請求データ作成
WHERE
checklist_records.item LIKE ‘利用器具%’
AND checklist_records.status = ‘YES’
AND checklist_records.reason IS NOT NULL
AND checklist_records.reason REGEXP ‘^[0-9]{1,3}$’
AND k_yoyaku.record = ‘完’
AND k_yoyaku.date BETWEEN ‘$firstDayOfLastMonth’ AND ‘$lastDayOfLastMonth’
AND (checklist_records.invoice_number IS NULL OR checklist_records.invoice_number = ”)