/**
* [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;
}
