FavoriteController.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Http\Requests;
use App\Http\Controllers\Controller;
use DB;
use Config;
use Log;

class FavoriteController extends Controller
{
    public function add(Request $request)
    {
        $type = $request->input('type', null);
        $data_id = $request->input('data_id', null);
        $args = $request->input('data_args', '');

        if ($type === null)
            return ['errcode' => 404, 'errmsg' => 'Bad Request: type not found'];
        if ($type != 1 && $type != 2)
            return ['errcode' => 404, 'errmsg' => 'Bad Request: invaild type ' . $type];
        if ($data_id === null)
            return ['errcode' => 404, 'errmsg' => 'Bad Request: data_id not found'];
        if (!empty($args) && !json_decode($args))
            return ['errcode' => 404, 'errmsg' => 'Bad Request: invaild data_args'];

        $userId = $request->user->userId;

        $sql = "REPLACE INTO favorites(data_type,data_id,data_args,user_id,ctime) VALUES(?,?,?,?,?)";
        $data= [$type, $data_id, $args, $userId, date('Y-m-d H:i:s')];

        // $sql = "REPLACE INTO favorites(data_type,data_id,user_id,ctime) VALUES(?,?,?,?)";
        // $data= [$type, $data_id, $userId, date('Y-m-d H:i:s')];

        try {
            DB::connection('tableconfig')->insert($sql, $data);

            return ['errcode' => 0, 'errmsg' => ''];
        } catch (\Exception $e) {
            return ['errcode' => 500, 'errmsg' => 'DB::insert failed:' . $e->getMessage()];
        }
    }

    public function del(Request $request, $favorite_id)
    {
        if ($favorite_id <= 0)
            return ['errcode' => 404, 'errmsg' => 'Bad Request: invaild favorite_id' . $favorite_id];
        $userId = $request->user->userId;

        try {
            $ret = DB::connection('tableconfig')->table('favorites')
                ->where('favorite_id', $favorite_id)->where('user_id', $userId)->delete();
            if ($ret) {
                return ['errcode' => 0, 'errmsg' => ''];
            } else {
                return ['errcode' => 404, 'errmsg' => "Bad Request: not found favorite_id {$favorite_id}"];
            }
        } catch (\Exception $e) {
            return ['errcode' => 500, 'errmsg' => 'DB::insert ' . $e->getMessage()];
        }
    }

    public function getList(Request $request, $type=null)
    {
        $page = $request->input('page', 1);
        $count= $request->input('count', 20);

        $userId= $request->user->userId;

        try {
            $q = DB::connection('tableconfig')->table('favorites')
                ->where('user_id', $userId);
            if ($type !== null)
                $q->where('data_type', $type);

            $total = $q->count();
            $data = ['errcode' => 0, 'data' => ['page' => $page, 'count' => $count, 'total' => $total, 'list' => [] ] ];
            if ($total == 0)
                return $data;
            $ret = $q->skip(($page-1) * $count)->take($count)->orderBy('ctime', 'DESC')->get();
            if (!$ret)
                return $data;

            $types = [];
            foreach ($ret as $item)
                $types[$item->data_type][] = $item->data_id;

            $urls = [];
            if (isset($types[1])) {
                $table = DB::connection('tableconfig')->table('tableconfig')->whereIn('table_id', $types[1])->get();
                if ($table) {
                    foreach ($table as $item) {
                        $urls[1][$item->table_id] = ['url'=> '/database/' . $item->table_id, 'title' => $item->title];
                    }
                }
            }

            if (isset($types[2])) {
                $config = DB::connection('tableconfig')->table('config')->whereIn('config_id', $types[2])->get();
                if ($config) {
                    foreach ($config as $item) {
                        $urls[2][$item->config_id] = ['url'=> '/setting/' . $item->config_id, 'title' => $item->config_title];
                    }
                }
            }

            if (isset($types[3])) {
                $config = DB::connection('tableconfig')->table('relation_config')->whereIn('relation_id', $types[3])->get();
                if ($config) {
                    foreach ($config as $item) {
                        $urls[3][$item->config_id] = ['url'=> '/relation/' . $item->relation_id, 'title' => $item->title];
                    }
                }
            }

            $outdata = [];
            foreach ($ret as $item) {
                if (!isset($urls[$item->data_type][$item->data_id]))
                    continue;
                $arr = $urls[$item->data_type][$item->data_id];
                $item->url = $arr['url'];
                $item->title = $arr['title'];
                if (isset($item->args))
                    $item->args = json_decode($item->args);
                $outdata[] = $item;
            }

            $data['data']['list'] = $outdata;
            return $data;
        } catch (\Exception $e) {
            return ['errcode' => 500, 'errmsg' => 'DB::insert failed: ' . $e->getMessage()];
        }
    }
}