public function consultarUrgExternas() { $urg_importadas = Urg::lists('urg'); if (count($urg_importadas) > 0) { $urg_externas = DB::connection('sgf14')->table('tbl_ures')->whereNotIn('ures', $urg_importadas)->get(); } else { $urg_externas = DB::connection('sgf14')->table('tbl_ures')->get(); } return $urg_externas; }
private function consultarUrgExternas() { $urg_importadas = \Urg::lists('urg'); 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; }