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 | 契約者電話番号 | 開始時刻 | 開始日 |
|---|---|---|---|---|---|
| 2481 | CAF1268158823 | 91764531 | 433097820 | 1253320 | 20230419 |
| 2482 | CAF1268158823 | 91764531 | 433097820 | 1310475 | 20230419 |
| 2483 | CAF1268158823 | 91764531 | 433097820 | 1527320 | 20230419 |
| 2484 | CAF1268158823 | 91764531 | 433097820 | 1554205 | 20230419 |
| 2485 | CAF1268158823 | 91764531 | 433097820 | 1755540 | 20230419 |
| 2486 | CAF1268158823 | 91764531 | 433097820 | 1805070 | 20230419 |
| 2487 | CAF1268158823 | 91764531 | 433097820 | 6065 | 20230420 |
| 2488 | CAF1268158823 | 91764531 | 433097820 | 607055 | 20230420 |
| 2489 | CAF1268158823 | 91764531 | 433097820 | 755530 | 20230420 |
| 2490 | CAF1268158823 | 91764531 | 433097820 | 929490 | 20230420 |
---From_DB_List--