eduepos-group/docs/inspect-seed-indicators.sql

-- Seed default inspection indicators for the current optimized schema.
-- Run in database `eduepos`. Idempotent (unique on INDICATOR_CODE).
SET NAMES utf8mb4;

INSERT IGNORE INTO `bu_inspect_indicator`
  (`INDICATOR_CODE`, `INDICATOR_NAME`, `INDICATOR_TYPE`, `DATA_SOURCE`, `MAX_SCORE`, `PASS_SCORE`, `WEIGHT`, `SCORE_RULE`, `SORT`, `STATUS`, `RMK`)
VALUES
  ('COOK_TIME', '鍑洪鏃舵晥', 1, 'ORDER_COOK_TIME', 100.00, 60.00, 20.00,
   '{"type":"range","ranges":[{"min":0,"max":10,"score":100},{"min":10,"max":20,"score":80},{"min":20,"max":30,"score":60},{"min":30,"max":999,"score":40}],"unit":"鍒嗛挓","description":"鍑洪鏃舵晥锛?-10鍒嗛挓100鍒嗭紝10-20鍒嗛挓80鍒嗭紝20-30鍒嗛挓60鍒嗭紝30鍒嗛挓浠ヤ笂40鍒?}',
   10, 1, '绯荤粺棰勭疆鑷姩閲囬泦鎸囨爣'),
  ('GOOD_RATE', '好评率'EVALUATE_GOOD_RATE', 100.00, 60.00, 20.00,
   '{"type":"percentage","thresholds":[{"min":95,"score":100},{"min":90,"score":80},{"min":80,"score":60},{"min":0,"score":40}],"unit":"%","description":"濂借瘎鐜囷細澶т簬绛変簬95%寰?00鍒嗭紝澶т簬绛変簬90%寰?0鍒嗭紝澶т簬绛変簬80%寰?0鍒嗭紝浣庝簬80%寰?0鍒?}',
   20, 1, '绯荤粺棰勭疆鑷姩閲囬泦鎸囨爣'),
  ('REJECT_RATE', '拒单率'ORDER_REJECT_RATE', 100.00, 60.00, 15.00,
   '{"type":"percentage_reverse","thresholds":[{"max":0,"score":100},{"max":2,"score":80},{"max":5,"score":60},{"max":100,"score":40}],"unit":"%","description":"鎷掑崟鐜囷細0%寰?00鍒嗭紝灏忎簬绛変簬2%寰?0鍒嗭紝灏忎簬绛変簬5%寰?0鍒嗭紝澶т簬5%寰?0鍒?}',
   30, 1, '绯荤粺棰勭疆鑷姩閲囬泦鎸囨爣'),
  ('OVERTIME_RATE', '超时率'ORDER_OVERTIME_RATE', 100.00, 60.00, 15.00,
   '{"type":"percentage_reverse","thresholds":[{"max":0,"score":100},{"max":3,"score":80},{"max":8,"score":60},{"max":100,"score":40}],"unit":"%","description":"瓒呮椂鐜囷細0%寰?00鍒嗭紝灏忎簬绛変簬3%寰?0鍒嗭紝灏忎簬绛変簬8%寰?0鍒嗭紝澶т簬8%寰?0鍒?}',
   40, 1, '绯荤粺棰勭疆鑷姩閲囬泦鎸囨爣'),
  ('HYGIENE', '鍗敓璇勫垎', 2, NULL, 100.00, 60.00, 15.00, NULL, 50, 1, '绯荤粺棰勭疆浜哄伐宸℃鎸囨爣'),
  ('SERVICE', '鏈嶅姟鎬佸害', 2, NULL, 100.00, 60.00, 10.00, NULL, 60, 1, '绯荤粺棰勭疆浜哄伐宸℃鎸囨爣'),
  ('PACKAGING', '鍖呰瑙勮寖', 2, NULL, 100.00, 60.00, 5.00, NULL, 70, 1, '绯荤粺棰勭疆浜哄伐宸℃鎸囨爣');