mes-sdai-server-api/application/admin/model/stock/Goods.php

<?php

namespace app\admin\model\stock;

use think\Model;

class Goods extends Model {

    // 表名
    protected $name = 'stock_goods';
    // 自动写入时间戳字段
    protected $autoWriteTimestamp = 'int';
    // 定义时间戳字段名
    protected $createTime = 'createtime';
    protected $updateTime = 'updatetime';
    // 追加属性
    protected $append = ["curstocknum"];
    public function goodscategory() {
        return $this->hasone('\app\admin\model\stock\Goodscategory', 'id', 'goodscategoryid')->setEagerlyType(0);
    }
    // 当前库存
    public function getCurstocknumAttr($value,$data) {
        $curstocknum=\app\admin\model\stock\Stockcur::where("stock_goods_id",$data["id"])->sum("curnums");
        return $curstocknum;
    }
}