# `Sp_Bd_Root_allstatus_1_new` (procedure)

> @author:zhucx
							@date:20210620 封存
							@describe: 看板管理-数字工厂状态看板 下 销售数据展示
							根据印件中的 印件属性为取值


- **Type:** PROCEDURE
- **Deterministic:** NO
- **SQL data access:** CONTAINS SQL

## Parameters

_No parameters._

## Body

_Body is not pre-cached. To inspect: `mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE PROCEDURE `Sp_Bd_Root_allstatus_1_new`'`._

## Narrative

**Business context:** 看板管理 / 数字工厂状态看板 — successor of `Sp_Bd_Root_allstatus_1`. Same "销售数据展示" bucketed-by-印件属性 tile, but with no input parameters and returning the rowset directly (`sValue AS data, sName AS axis`) instead of a JSON string. Author tagged `封存` 2021-06-20.

**What it does:** Same body as `Sp_Bd_Root_allstatus_1` — seeds `p_Root_allstatus_1` from `eleproduct.sProductproperty`, joins `viw_salsalesorder` (current month, `bCheck=1`) summing `dProductMoney/10000 + 300`, then forces 卡盒类/书刊类/坑盒类/其他 to 36/58/86/86, and emits a two-column result set.

**Invocation:** No install script in xly-src, no form-master, no `gdsmodule` hook, no Java caller, no other-routine caller. Reached only by an external dashboard HTTP endpoint that calls the proc by name. Marked `封存` (sealed); same hard-coded offsets/forces as the non-`_new` version — output is mostly demo data.
