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

<?php

namespace app\admin\model\stock;

use think\Model;

class Stockcur extends Model {

    // 表名
    protected $name = 'stock_stockcur';
    // 自动写入时间戳字段
    protected $autoWriteTimestamp = false;
    // 定义时间戳字段名
    protected $createTime = false;
    protected $updateTime = false;
    // 追加属性
    protected $append = [
    ];

    public function stockgoods() {
        return $this->belongsTo('\app\admin\model\stock\Goods', 'stock_goods_id', 'id', [], 'LEFT')->setEagerlyType(0);
    }

    public function stockinlist() {
        return $this->belongsTo('\app\admin\model\stock\Stockinlist', 'stock_stockin_list_id', 'id', [], 'LEFT')->setEagerlyType(0);
    }

    public function getGoodsStoknum($goodsid) {
        $result = model('\app\admin\model\stock\Stockcur')->field('SUM(curnums)')->where('stock_goods_id', $goodsid)->select();
        $curnum = $result[0]['SUM(curnums)'] == null ? 0 : $result[0]['SUM(curnums)'];
        return $curnum;
    }
}