getViewInfo-----SELECT * FROM `view_list` WHERE `viewTitle` Like '%発課金List%' AND `viewType` Like '%from_DB_List%'
array(1) {
[0]=>
array(8) {
["viewID"]=>
string(2) "13"
["viewTitle"]=>
string(13) "発課金List"
["viewURL"]=>
string(0) ""
["controller"]=>
string(15) "BasicController"
["view_first"]=>
string(1) "1"
["viewType"]=>
string(12) "from_DB_List"
["viewTemplate"]=>
string(0) ""
["viewOptions"]=>
string(108) "{"sql":"SELECT * FROM hatukakin_meisai","paging":"10","count_sql":"select count(*) FROM hatukakin_meisai"
}"
}
}
----------- Result of Basic Controller
------------************List***********
| ID | フレッツID | 請求No | 契約者電話番号 | 開始時刻 | 開始日 |
|---|---|---|---|---|---|
| 2341 | CAF1268158823 | 91764531 | 433097820 | 1030190 | 20230406 |
| 2342 | CAF1268158823 | 91764531 | 433097820 | 1035095 | 20230406 |
| 2343 | CAF1268158823 | 91764531 | 433097820 | 1245115 | 20230406 |
| 2344 | CAF1268158823 | 91764531 | 433097820 | 1252050 | 20230406 |
| 2345 | CAF1268158823 | 91764531 | 433097820 | 1723080 | 20230406 |
| 2346 | CAF1268158823 | 91764531 | 433097820 | 1735370 | 20230406 |
| 2347 | CAF1268158823 | 91764531 | 433097820 | 2336365 | 20230406 |
| 2348 | CAF1268158823 | 91764531 | 433097820 | 537355 | 20230407 |
| 2349 | CAF1268158823 | 91764531 | 433097820 | 848445 | 20230407 |
| 2350 | CAF1268158823 | 91764531 | 433097820 | 908060 | 20230407 |
---From_DB_List--