del_quoworklog (procedure)

• 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 PROCEDUREdelquoworklog'._

Narrative

Business context: 报价单 / 工单报价 — daily housekeeping of the per-session scratch tables that back the quotation and work-order calculators. The _tmp tables accumulate intermediate rows while a user is composing a quotation or a work order; this routine flushes them after-hours so the next day starts clean.

What it does: TRUNCATEs 17 *_tmp tables in two families: nine quoquotation*_tmp (master, slave, control, controlcombine, process, materials, param, calc) and eight mftworkorder*_tmp (master, slave, slavemoney, materials, control, controlcombine, process, calc).

Invocation: Driven by a MySQL EVENT del_quoquoworklog defined in xly-src/script/标版/upgrade/定时器/工单报价单临时表清空定时器.sql — runs once a day at 04:00 (ON SCHEDULE EVERY 1 DAY STARTS '2022-08-18 04:00:00'). No form-master or proc caller; reached only through the scheduler.