# `Sp_Quantity_PatrolDailyPaper` (procedure)

> @author:杨恒林
							@date:20210523 封存
							@describe: 巡检日报主管审批过程	质量管理-过程管理-巡检日报-主管审核按钮：


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sProInParam` | `varchar(10000)` |
| 2 | IN | `sMakePerson` | `varchar(100)` |
| 3 | IN | `sBrId` | `varchar(100)` |
| 4 | IN | `sSuId` | `varchar(100)` |
| 5 | OUT | `sReturn` | `varchar(1000)` |
| 6 | OUT | `sCode` | `int` |

## Body

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

## Narrative

**Business context:** 质量管理 → 过程管理 → 巡检日报 — supervisor (主管) approval button on the 巡检日报 daily-inspection summary. The DB COMMENT explicitly marks the proc as `20210523 封存` (sealed/deprecated 2021-05-23) and authored by 杨恒林.

**What it does:** Parses `sProInParam` for `$.params[*].value[*]` and `$.changeValue.textareaValue` (the supervisor's remark). For each row it reads `tCreateDate` + `sMakePerson` and runs `UPDATE QlyProcessTestMaster SET bCheck=1, sStatus=1, sCheckPerson=sMakePerson, tCheckDate=NOW() WHERE sMakePerson=p_sMakePerson AND DATE_FORMAT(tCreateDate,'%Y-%m-%d') = LEFT(p_tCreateDate,10)` scoped by sBrId/sSuId — i.e. it stamps every patrol-test record that the named operator created on that day. Each row also writes a `syslog` audit entry with `sFormId='12012615914116371204913630'` (巡检日报 form id) and `sOperationType='巡检日报审批'`.

**Invocation:** Signature is the standard `Sp_BtnEvent_*` generic-dispatch shape, but no live binding: `gdsmodule.sSaveProName`/`sProcName` empty, no other routine references it, and `grep -rln` on xly-src returns one hit — `script/标版/30100101/Sp_Quantity_PatrolDailyPaper.sql` (install script only). Status: deprecated by COMMENT, orphaned in the live config; the replacement is the per-row approval on `QlyProcessTestMaster` directly. Candidate for maintainer audit / removal.