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 | 契約者電話番号 | 開始時刻 | 開始日 |
|---|---|---|---|---|---|
| 3091 | COP02425623 | 91764531 | 432875547 | 1433480 | 20230429 |
| 3092 | COP02425623 | 91764531 | 432875547 | 1648125 | 20230429 |
| 3093 | COP02425623 | 91764531 | 432875547 | 1703295 | 20230414 |
| 3094 | COP02425623 | 91764531 | 432875547 | 1337305 | 20230418 |
| 3095 | COP03214715 | 91764531 | 471452774 | 847010 | 20230403 |
| 3096 | COP03214715 | 91764531 | 471452774 | 851275 | 20230403 |
| 3097 | COP03214715 | 91764531 | 471452774 | 1033085 | 20230403 |
| 3098 | COP03214715 | 91764531 | 471452774 | 1221085 | 20230403 |
| 3099 | COP03214715 | 91764531 | 471452774 | 1541040 | 20230403 |
| 3100 | COP03214715 | 91764531 | 471452774 | 1912175 | 20230403 |
---From_DB_List--