private function consultarUrgExternas() { $urg_importadas = Urg::lists('urg')->all(); if (count($urg_importadas) > 0) { $urg_externas = \DB::connection($this->db_origen)->table('tbl_ures')->whereNotIn('ures', $urg_importadas)->get(); } else { $urg_externas = \DB::connection($this->db_origen)->table('tbl_ures')->get(); } return $urg_externas; }