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 | 契約者電話番号 | 開始時刻 | 開始日 |
|---|---|---|---|---|---|
| 3311 | COP07679084 | 91764531 | 474845521 | 1509090 | 20230424 |
| 3312 | COP07679084 | 91764531 | 474845521 | 901530 | 20230428 |
| 3313 | COP09637785 | 91764531 | 477005111 | 1012585 | 20230403 |
| 3314 | COP09637785 | 91764531 | 477005111 | 1322265 | 20230404 |
| 3315 | COP09637785 | 91764531 | 477005111 | 1751200 | 20230405 |
| 3316 | COP09637785 | 91764531 | 477005111 | 1511085 | 20230410 |
| 3317 | COP09637785 | 91764531 | 477005111 | 936115 | 20230414 |
| 3318 | COP09637785 | 91764531 | 477005111 | 1548285 | 20230417 |
| 3319 | COP09637785 | 91764531 | 477005111 | 1647375 | 20230419 |
| 3320 | COP09637785 | 91764531 | 477005111 | 948300 | 20230421 |
---From_DB_List--