// +---------------------------------------------------------------------- namespace app\admin\service\users; use app\admin\service\Service; use app\admin\model\users\UsersComment as UsersCommentModel; use app\common\models\goods\Goods as GoodsModel; use app\common\models\users\Users as UsersModel; use think\facade\Session; class Comment extends Service { /** * 获取评论数据 * @param $data * @return array * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException */ public static function getList($data){ $condition = []; $key = $data["key"]??[]; if(isset($key["cat_id"]) && $key["cat_id"] != '-1'){ $filed = $key["cat_id"] == 0 ? "users.username" : "goods.title"; $condition[] = [$filed,"like",'%'.$key["title"].'%']; } $count = UsersCommentModel::withJoin(['goods','users'])->where($condition)->count(); $result = UsersCommentModel::withJoin(['goods','users'])->where($condition)->page($data["page"]??1,$data["limit"]??10)->order("users_comment.id","desc")->select()->toArray(); return [ "count"=>$count, "data"=>array_map(function ($res){ $res["username"] = getUserName($res); return $res; },$result) ]; } /** * 详情 * @param $id * @return array * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException */ public static function detail($id){ if(!$row=UsersCommentModel::where("id",$id)->find()){ throw new \Exception("您要查找的内容不存在!"); } $row["goods_name"] = GoodsModel::where("id",$row["goods_id"])->value("title"); $users = UsersModel::where("id",$row["user_id"])->find(); $row["username"] = getUserName($users); return [ "data"=>$row ]; } /** * 保存数据 * @param $data * @return bool * @throws \Exception */ public static function save($data){ if(empty($data["reply_content"])){ throw new \Exception("请填写回复内容",0); } $data["admin_id"] = Session::get("system_user_id"); $data["reply_time"] = time(); $data["status"] = 1; UsersCommentModel::where("id",$data["id"])->save($data); return true; } /** * 删除 * @param $id * @return bool */ public static function delete($id){ return UsersCommentModel::where("id",$id)->delete(); } }