/** * Display a listing of the resource. * * @return Response */ public function uploadComments() { $title = '上传评论'; $is_nav = 'uploadComments'; $sites = Site::where('status', 1)->get(); return view('site.uploadComments', array('title' => $title, 'is_nav' => $is_nav, 'sites' => $sites)); }
public function index() { $sites = Site::where('status', 1)->get(); $str = ''; foreach ($sites as $site) { $str .= "'{$site->db_name}' => [" . "<br />" . "'driver' => 'mysql'," . "<br />" . "'host' => '" . $site->db_ip . "'," . "<br />" . "'database' => '" . $site->db_name . "'," . "<br />" . "'username' => '" . $site->db_user . "'," . "<br />" . "'password' => '" . $site->db_pass . "'," . "<br />" . "'charset' => 'utf8'," . "<br />" . "'collation'=> 'utf8_unicode_ci'," . "<br />" . "'prefix' => ''," . "<br />" . "'strict' => false" . "<br />" . "]," . "<br />" . "<br />" . "<br />"; } //echo $str; }
public static function location($parameter = "") { if ($parameter == "") { return Md\Site::count(); } if ($parameter != "") { return Md\Site::where('category', $parameter)->count(); } }
public function current() { if (app()->runningInConsole()) { return null; } $id = $this->id(); $cacheKey = 'site_current_' . $id; $site = Cache::get($cacheKey); if (empty($site)) { $site = \App\Models\Site::where('id', $id)->first(); } $expiresAt = Carbon::now()->addMinutes(10); Cache::put($cacheKey, $site, $expiresAt); return $site; }
/** * Handle an incoming request. * * @param \Illuminate\Http\Request $request * @param \Closure $next * @return mixed */ public function handle($request, Closure $next) { if (env('APP_ENV') === 'testing') { return $next($request); } $authenticated = false; if (!isset($_SERVER['HTTP_X_SITE_NAME'])) { return response()->json(array('error' => 'This resource requires a site name.'), 403); } $key = $_SERVER['HTTP_X_SITE_NAME']; if ($key) { $key = Site::where('url', '=', $key)->first(); if ($key) { session(['site_id' => $key->id]); $authenticated = true; } } if (!$authenticated) { return response()->json(array('error' => 'Invalid Site'), 403); } return $next($request); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { Site::where('server_id', $id)->delete(); $code = 200; $msg = json_encode(array('msg' => $code)); return $msg; }