x-39-php-9019/app/controller/MyGoodsController.php

<?php

namespace app\controller;


use app\business\GoodsBusiness;
use app\business\LoginBusiness;
use Illuminate\Support\Arr;
use Respect\Validation\Validator;
use support\Db;
use support\Redis;
use support\Request;
use hg\apidoc\annotation as Apidoc;
use Webman\Captcha\CaptchaBuilder;
use Webman\Captcha\PhraseBuilder;

#[Apidoc\Title("投资记录")]
#[Apidoc\Group("Goods")]
#[Apidoc\Sort(3)]
class MyGoodsController
{
    #[Apidoc\Title("投资记录列表")]
    #[Apidoc\Url("api/user/mygoods.html")]
    #[Apidoc\Method("POST")]
    #[Apidoc\Header("token", type: "string", require: true, desc: "身份令牌Token", mock: "@token")]
    #[Apidoc\Param("page", type: "int", require: true, desc: "页面", mock: 1)]
    #[Apidoc\Param("limit", type: "int", require: true, desc: "输出条数", mock: 10)]
    #[Apidoc\Returned(name: "good_name", type: "string", require: true, desc: '商品名称', default: '')]
    #[Apidoc\Returned(name: "pay_price", type: "string", require: true, desc: '商品单价', default: '')]
    #[Apidoc\Returned(name: "money", type: "string", require: true, desc: '支付金额', default: '')]
    #[Apidoc\Returned(name: "bonus", type: "string", require: true, desc: '日收益', default: '')]
    #[Apidoc\Returned(name: "balance", type: "string", require: true, desc: '关税宝余额', default: '')]
    #[Apidoc\Returned(name: "bl", type: "string", require: true, desc: '比例', default: '')]
    #[Apidoc\Returned(name: "created_at", type: "string", require: true, desc: '购买时间', default: '')]
    #[Apidoc\Returned(name: "status", type: "string", require: true, desc: '状态  1正常  2失效  3终止', default: '')]
    public function index(Request $request)
    {
        $param = $request->param_data;
        try {
            Validator::input($param, [
                'page'  => Validator::notEmpty()->intType()->setName('页面'),
                'limit' => Validator::notEmpty()->intType()->setName('输出条数'),
            ]);
            $data = Db::table('wa_my_goods')
                ->where('user_id', $request->user_data['id'])
                ->where(function ($query) use ($param) {
                    if (Arr::get($param, 'type')) {
                        $query->where('type', $param['type']);
                    }
                })
                ->orderByDesc('id')
                ->paginate(Arr::get($param, 'limit', 10), ['*'], 'page', Arr::get($param, 'page'))
                ->toArray();
            $arr  = [];
            foreach ($data['data'] as $k => $v) {
                $wa_goods = Db::table('wa_goods')->where('id', $v->goods_id)->first();
                $arr[]    = [
                    'good_name'           => $wa_goods->name,
                    'pay_price'           => $wa_goods->pay_price,
                    'bonus'               => $wa_goods->bonus,
                    'balance'             => $wa_goods->balance,
                    'bl'                  => $wa_goods->bl,
                    'describe'            => $wa_goods->describe,
                    'img'                 => imageToBase64($wa_goods->img),
                    'created_at'          => date('Y-m-d H:i:s', strtotime($v->created_at)),
                    'id'                  => $v->id,
                    'num'                 => $v->num,
                    'money'               => $v->money,
                    'status'              => $v->status,
                    'name'                => $v->name,
                    'mobile'              => $v->mobile,
                    'address'             => $v->address,
                    'send_status'         => $v->send_status,
                    'pass'                => $v->pass,
                    'type'                => $v->type,
                    'reservation_name'    => $v->reservation_name,
                    'reservation_mobile'  => $v->reservation_mobile,
                    'reservation_address' => $v->reservation_address,
                    'reservation_status'  => $v->reservation_status,
                    'account_number'      => $v->account_number,
                ];
            }
        } catch (\Throwable $exception) {
            return error($exception->getMessage());
        }
        return success($arr, '成功', 200, $data['total']);
    }

}