1
2
3
4
5
| -- FAMS 第二阶段:扫码功能取消,预置标签模板去掉二维码并重新排版(文字占满标签宽度)
| update BUS_LABEL_TEMPLATE set MODIFY_TIME = now(), LAYOUT_JSON = '{"elements":[{"type":"text","text":"固定资产标签","fontSize":10,"bold":true,"align":"center","x":2,"y":1.5,"w":56,"h":5},{"type":"field","field":"ASSET_NO","showTitle":true,"fontSize":8.5,"bold":true,"align":"left","x":2,"y":8,"w":56,"h":5},{"type":"field","field":"ASSET_NAME","showTitle":true,"fontSize":7.5,"bold":false,"align":"left","x":2,"y":13.5,"w":56,"h":5},{"type":"field","field":"USE_DEPT_NAME","showTitle":true,"fontSize":7.5,"bold":false,"align":"left","x":2,"y":19,"w":56,"h":5},{"type":"field","field":"LOCATION_NAME","showTitle":true,"fontSize":7,"bold":false,"align":"left","x":2,"y":24.5,"w":56,"h":8},{"type":"field","field":"PURCHASE_DATE","showTitle":true,"fontSize":7,"bold":false,"align":"left","x":2,"y":33,"w":56,"h":5}]}' where ID = 1800000000000002217;
| update BUS_LABEL_TEMPLATE set MODIFY_TIME = now(), LAYOUT_JSON = '{"elements":[{"type":"text","text":"特种/计量设备标签","fontSize":10,"bold":true,"align":"center","x":2,"y":1.5,"w":66,"h":5},{"type":"field","field":"ASSET_NO","showTitle":true,"fontSize":8.5,"bold":true,"align":"left","x":2,"y":8,"w":66,"h":5},{"type":"field","field":"ASSET_NAME","showTitle":true,"fontSize":7.5,"bold":false,"align":"left","x":2,"y":13.5,"w":66,"h":5},{"type":"field","field":"CERT_NO","showTitle":true,"fontSize":7.5,"bold":false,"align":"left","x":2,"y":19,"w":66,"h":5},{"type":"field","field":"SAFETY_USER_NAME","showTitle":true,"fontSize":7.5,"bold":false,"align":"left","x":2,"y":24.5,"w":66,"h":5},{"type":"field","field":"VERIFY_EXPIRE_DATE","showTitle":true,"fontSize":9,"bold":true,"align":"left","x":2,"y":30.5,"w":66,"h":6},{"type":"field","field":"LOCATION_NAME","showTitle":true,"fontSize":7.5,"bold":false,"align":"left","x":2,"y":37.5,"w":66,"h":6},{"type":"field","field":"USE_DEPT_NAME","showTitle":true,"fontSize":7.5,"bold":false,"align":"left","x":2,"y":44,"w":66,"h":5}]}' where ID = 1800000000000002218;
| update BUS_LABEL_TEMPLATE set MODIFY_TIME = now(), LAYOUT_JSON = '{"elements":[{"type":"field","field":"ASSET_NO","showTitle":false,"fontSize":8,"bold":true,"align":"left","x":1.5,"y":2,"w":37,"h":5},{"type":"field","field":"ASSET_NAME","showTitle":false,"fontSize":7,"bold":false,"align":"left","x":1.5,"y":8,"w":37,"h":10},{"type":"field","field":"USE_DEPT_NAME","showTitle":true,"fontSize":6,"bold":false,"align":"left","x":1.5,"y":20,"w":37,"h":4.5}]}' where ID = 1800000000000002219;
| select ID, TEMPLATE_NAME, LAYOUT_JSON like '%qrcode%' as has_qr from BUS_LABEL_TEMPLATE;
|
|