# `Sp_WorkWeekReport` (procedure)


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `tStartDate` | `datetime` |
| 2 | IN | `tEndDate` | `datetime` |
| 3 | IN | `sLoginId` | `varchar(100)` |
| 4 | IN | `sBrId` | `varchar(100)` |
| 5 | IN | `sSuId` | `varchar(100)` |
| 6 | OUT | `sReturn` | `varchar(1000)` |
| 7 | OUT | `sCode` | `int` |

## Body

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

## Narrative

**Business context:** 成本管理 → 材料存货分析 → 生产周报 — placeholder data-source for the 生产周报 report. The form is registered but the procedure is a stub: it only returns the date range it was given, with no aggregation logic yet.

**What it does:** Date-aligns `tEndDate = DATE_ADD(DATE_FORMAT(tEndDate,'%Y-%m-%d'), INTERVAL 1 DAY)` and runs a single `SELECT tStartDate, tEndDate;`. No CRUD, no joins, no real data — opening the report will only display the two date columns.

**Invocation:** Bound as `gdsconfigformmaster.sSqlStr` on form `101251240115016179581404740` (生产周报, parent module `101251240115016179581403880`) under 成本管理 → 材料存货分析. Fires when the report is opened. No other channel calls it. Status: report scaffold awaiting an actual implementation — flag for maintainer follow-up.
