public static function tableName()
{
return '{{%goods}}';
}
public static function getVolumeByStoreId($storeId) { $sql = 'SELECT sum(t0.count * t1.price) FROM ' . static::tableName() . ' AS t0 LEFT JOIN ' . Goods::tableName() . ' AS t1 ON t0.goods_id = t1.id WHERE t0.store_id=:store_id;'; $volume = Yii::$app->db->createCommand($sql, [':store_id' => $storeId])->queryScalar(); return bcadd($volume, '0', 2); }