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 | 契約者電話番号 | 開始時刻 | 開始日 |
|---|---|---|---|---|---|
| 1001 | CAF1152471465 | 91764531 | 432283335 | 1114330 | 20230412 |
| 1002 | CAF1152471465 | 91764531 | 432283335 | 1122490 | 20230412 |
| 1003 | CAF1152471465 | 91764531 | 432283335 | 1122530 | 20230412 |
| 1004 | CAF1152471465 | 91764531 | 432283335 | 1125225 | 20230412 |
| 1005 | CAF1152471465 | 91764531 | 432283335 | 1145500 | 20230412 |
| 1006 | CAF1152471465 | 91764531 | 432283335 | 1154160 | 20230412 |
| 1007 | CAF1152471465 | 91764531 | 432283335 | 1204470 | 20230412 |
| 1008 | CAF1152471465 | 91764531 | 432283335 | 1205140 | 20230412 |
| 1009 | CAF1152471465 | 91764531 | 432283335 | 1217505 | 20230412 |
| 1010 | CAF1152471465 | 91764531 | 432283335 | 1308255 | 20230412 |
---From_DB_List--