# `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 PROCEDURE `del_quoworklog`'`._

## 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:** `TRUNCATE`s 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.