/** * [queryDataNHC query data from view ] Get all data used by request data for download * @param [integet] $requestdata_id [request data id] * @return [array] [collection of data] */ public static function queryDataNHCAll($requestdata_id) { $results = RequestData::find($requestdata_id); $rs = QueryData::where('data_id', '=', $results->data_id)->where('cond_id', '=', $results->cond_id)->where('agency_code', '=', $results->agency_code)->select('table_name', 'condition', 'period', 'agency_code')->get(); $result_query = $rs[0]; if ($results->agency_code == '02005') { list($tb_name, $field, $datefield, $tele_id) = explode("-", $result_query->table_name); Config::get('nhc/site.debug_db') ? $date = Config::get('nhc/site.debug.' . $datefield) : ($date = DB::raw($result_query->condition)); $nhc_data = DB::connection('nhc_data')->table($tb_name)->where('tele_station_id', '=', $tele_id)->where('agency_id', '=', $results->agency_code)->where(DB::raw($datefield . '::date'), '=', $date)->where(DB::raw($datefield . '::date'), '<=', $result_query->period)->orderBy($field, 'DESC')->select('*')->take(100)->get(); } else { list($tb_name, $field, $datefield) = explode("-", $result_query->table_name); Config::get('nhc/site.debug_db') ? $date = Config::get('nhc/site.debug.' . $datefield) : ($date = DB::raw($result_query->condition)); //echo $date; $nhc_data = DB::connection('nhc_data')->table($tb_name)->where('agency_id', '=', $results->agency_code)->where(DB::raw($datefield . '::date'), '=', $date)->where(DB::raw($datefield . '::date'), '<=', $result_query->period)->orderBy($field, 'DESC')->select('*')->take(100)->get(); //->get(); } return $nhc_data; }