Fun_box_pic (function)

获取盒型图片

• Type: FUNCTION
• Returns: longtext
• Deterministic: NO
• SQL data access: CONTAINS SQL

Parameters

#	Mode	Name	Type
1	IN	sProductTypeId	varchar(100)

Body

Body is not pre-cached. To inspect: mysql --defaults-file=~/.my.cnf -e 'SHOW CREATE FUNCTIONFunbox_pic'._

Narrative

Business context: Box-type (盒型) reference-image lookup for the packaging-quotation form. For a chosen product type, returns the gallery of box-shape thumbnails registered under eleproductfile so the FROUNT control can render them as a picker.

What it does: builds a JSON array via GROUP_CONCAT(JSON_OBJECT(...)) from eleproductfile rows where sParentId = sProductTypeId, projecting the file's id, name, picture path, and tenant ids, ordered by iOrder. The thumb shape duplicates sFileName into sChinese/showName/sBig5 so existing dropdown components can consume it without a separate label column.

Invocation: Status: appears orphaned. No caller found in any channel (form-master sSqlStr, gdsmodule hooks, other routines, exhaustive xly-src grep, dynamic-dispatch search) — candidate for maintainer audit. Likely written for a planned packaging-form widget that never went into production, or for a customer-specific deployment whose SQL is not in this snapshot.