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 | 契約者電話番号 | 開始時刻 | 開始日 |
|---|---|---|---|---|---|
| 2011 | CAF1190290455 | 91764531 | 432390910 | 911115 | 20230416 |
| 2012 | CAF1190290455 | 91764531 | 432390910 | 1512115 | 20230416 |
| 2013 | CAF1190290455 | 91764531 | 432390910 | 2113110 | 20230416 |
| 2014 | CAF1190290455 | 91764531 | 432390910 | 314105 | 20230417 |
| 2015 | CAF1190290455 | 91764531 | 432390910 | 806370 | 20230417 |
| 2016 | CAF1190290455 | 91764531 | 432390910 | 934235 | 20230417 |
| 2017 | CAF1190290455 | 91764531 | 432390910 | 1009565 | 20230417 |
| 2018 | CAF1190290455 | 91764531 | 432390910 | 1403215 | 20230417 |
| 2019 | CAF1190290455 | 91764531 | 432390910 | 1407370 | 20230417 |
| 2020 | CAF1190290455 | 91764531 | 432390910 | 1811040 | 20230417 |
---From_DB_List--