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 | 契約者電話番号 | 開始時刻 | 開始日 |
|---|---|---|---|---|---|
| 2071 | CAF1190290455 | 91764531 | 432390910 | 1605445 | 20230424 |
| 2072 | CAF1190290455 | 91764531 | 432390910 | 1614120 | 20230424 |
| 2073 | CAF1190290455 | 91764531 | 432390910 | 1827500 | 20230424 |
| 2074 | CAF1190290455 | 91764531 | 432390910 | 2117250 | 20230424 |
| 2075 | CAF1190290455 | 91764531 | 432390910 | 318250 | 20230425 |
| 2076 | CAF1190290455 | 91764531 | 432390910 | 515110 | 20230425 |
| 2077 | CAF1190290455 | 91764531 | 432390910 | 810225 | 20230425 |
| 2078 | CAF1190290455 | 91764531 | 432390910 | 1052420 | 20230425 |
| 2079 | CAF1190290455 | 91764531 | 432390910 | 1115210 | 20230425 |
| 2080 | CAF1190290455 | 91764531 | 432390910 | 1411220 | 20230425 |
---From_DB_List--