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