// Flight 表格數據顯示
    function initFlightTable() {
        //先銷毀表格
        $('#dataTable').bootstrapTable('destroy');
        $('#dataTable').bootstrapTable({
             url: '/backend/home/getflightdata',
             queryParams: "queryParams",
             toolbar: "#toolbar",
             sidePagination: "server",
             striped: true, // 是否顯示行間隔色
             // search : "true",
             showRefresh: true, // 是否顯示刷新按鈕
             uniqueId: "ID",
             strictSearch: true,
             pageSize: 10,                     //每頁的記錄行數（*）
             pageList: [10, 25, 50, 100],        //可供選擇的每頁的行數（*）
             pagination: true, // 是否分頁
             sortable: true, // 是否啟用排序
             queryParams: function (params) {
             
                 var temp = {
                     rows: params.limit,                         //頁面大小
                     page: (params.offset / params.limit) + 1,   //頁碼
                     sort: params.sort,      //排序列名
                     sortOrder: params.order,//排位命令（desc肠虽，asc）
                     flightsearch :$('#flightsearch').val(),
                     week:weekday(),
                 
                     arrival:$("#arrival option:selected").val(),


                 };
                 return temp;
             },
             columns: [
                 {
                     field: 'fldSCHEDULED_DATE',
                     title: 'Date',
                     align: "center",

                 },
                 {
                     field: 'fldWEEKDAY',
                     title: 'Weekday',

                 },

                 {
                     field: 'fldARR_DEP',
                     title: 'Arrival/Departure',
                 },
                 {
                     field: 'fldA_FLIGHT_AIRLINE_ID',
                     title: ' Airline ID'
                 },

                 {
                     field: 'fldAP_ORIGIN_DEST',
                     title: 'Destination'
                 },

             ]
         });
    }
    // 獲取搜索的week
    function weekday() {
        var  ids = $('input:checkbox[name="week"]:checked');
        var data = '';
        for (var i = 0; i < ids.length; i ++) {
         
            data += ids[i].value + (i == ids.length - 1 ? '':',');
        }
      
        return data;
    }

后臺

  // 獲取 flight 的data  /// ok
    public function getflightdata(){
        $rows = Request::instance()->get('rows'); // 每頁數量棒假。分頁查詢
        $page = Request::instance()->get('page'); // 每頁顯示分頁查詢
      
        $searchs = Request::instance()->get('flightsearch'); // 取到 搜索日期

        $week = Request::instance()->get('week'); // 取到 week
    
        $arrival = Request::instance()->get('arrival'); // 取到A/D
    
        $where='1=1';
        if($searchs!==""){
            switch (strlen($searchs)){
                case "5":  // 07:00
                    $where = "date_format(`fldSCHEDULED_DATE`,'%H:%i')='$searchs'";
                    break;
                case "8": // 06:00:00
                    $where = "date_format(`fldSCHEDULED_DATE`,'%H:%i:%s')='$searchs'";
                    break;
                case "10": // 輸入的是2017-01-02 
                    $where = "date_format(`fldSCHEDULED_DATE`,'%Y-%m-%d')='$searchs'";
                    break;
                case "16": // 輸入的是2017-01-02 06:00
                    $where = "date_format(`fldSCHEDULED_DATE`,'%Y-%m-%d %H:%i')='$searchs'";
                    break;
                case "19"://2017-01-02 06:00:00
                    $where = "date_format(`fldSCHEDULED_DATE`,'%Y-%m-%d %H:%i:%s')='$searchs'";
                    break;
                default:
                    break;
            }
        }
        if($week!=""){
            $where =$where." and fldWEEKDAY IN ($week)";
        }
        if($arrival !==''){
            $where =$where." and fldARR_DEP ='$arrival'";
        }

        $data = Db::table('tblflights')->where($where)->page($page,$rows)->select();
        $count = Db::table('tblflights')->where($where)->count();
        $weekday ='';
          foreach ($data as $v){
              switch ($v['fldWEEKDAY']){
                  case "0":
                      $weekday = 'Mon';  //
                    break;
                  case "1":
                      $weekday = 'Tues';
                    break;
                  case "2":
                      $weekday = 'Wed';
                    break;
                  case "3":
                      $weekday = 'Thur';
                    break;
                  case "4":
                      $weekday = 'Fri';
                    break;
                  case "5":
                      $weekday = 'Sat'; // 周六
                    break;
                  case "6":
                      $weekday = 'sun'; //周日
                    break;
              }
              $result[]=[
                  "fldID"=>$v['fldID'],
                  "fldSCHEDULED_DATE" =>substr($v['fldSCHEDULED_DATE'],0,16),
                  "fldWEEKDAY"=>$weekday,
                  "fldARR_DEP" =>$v['fldARR_DEP'],
                  "fldA_FLIGHT_AIRLINE_ID"=>$v['fldA_FLIGHT_AIRLINE_ID'],
                  "fldAP_ORIGIN_DEST" =>$v['fldAP_ORIGIN_DEST'],
              ];
          }
        $ret = [
            'total' => $count,
            'rows' => $result,
        ];
        echo json_encode($ret);
        //echo  json_encode($result);
    }