/**
* [getAgenyByDataId description]
* @param [type] $data_id [description]
* @return [type] [description]
*/
public function getAgenyByDataId($data_id)
{
$rs = DB::select(DB::raw('
select ad.agency_id,a.tname
from agency_data ad inner join agency a on (ad.agency_id = a.id)
where ad.data_id = :data_id '), array('data_id' => $data_id));
foreach ($rs as $key => $value) {
$arr_agency[] = $value->agency_id;
}
$user = new Usernhc();
$rs_useragency = $user->getUserByAgencyId($arr_agency);
// var_dump($rs_useragency);
// var_dump($rs);exit;
return $rs_useragency;
}
