# `Sp_Graphic_Report_Analysis_Data` (procedure)


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

## Parameters

| # | Mode | Name | Type |
|---|---|---|---|
| 1 | IN | `sGdsconfigCharMasterId` | `varchar(255)` |
| 2 | IN | `sProcedureNo` | `varchar(255)` |
| 3 | IN | `sSqlCondition` | `varchar(5000)` |
| 4 | IN | `sBrId` | `varchar(255)` |
| 5 | IN | `sSuId` | `varchar(255)` |
| 6 | IN | `sLoginId` | `varchar(100)` |
| 7 | OUT | `sReturn` | `varchar(5000)` |

## Body

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

## Narrative

**Business context:** Demo-data emitter for an early graphical-report Analysis chart. The body builds five hardcoded JSON literals (sample machine-Gantt + month-money series with literal x/y values like `"11-24"/"SM74"`, `"1"/245`, etc.) — no real database reads. Intended as a placeholder while the actual chart pipeline was being designed.

**What it does:** Sets `@jsonString` through `@jsonString5` to concatenated literal JSON strings (machine-name Gantt strip, monthly revenue line, etc.) and returns one via `sReturn`. The IN params `sGdsconfigCharMasterId` / `sSqlCondition` / `sLoginId` are unused.

**Invocation:** Status: appears orphaned. No caller found in any channel (form-master, gdsmodule hooks, other routines). The only xly-src reference is a commented-out block in `CharServiceImpl` (the `getDataByCode` chart-data path) — the live chart pipeline uses `getConfigZx(code, sSqlConditionMap)` instead, with this CALL block left as dead code. Zero rows in `gdsconfigcharmaster.sProcedureName` reference this name. Candidate for removal once a maintainer confirms no chart-master row points at it.
