| 1234567 |
- update `[Q]flow_element` set `name`='性别',`fields`='sex',`dev`=null,`data`='男,女' where `id`=206 and `mid`=29;
- ROCKSPLIT
- @id=SELECT `id` from `[Q]option` where `num`='sysoption';
- ROCKSPLIT
- INSERT INTO `[Q]option` (`name`,`pid`,`value`,`num`,`explain`) select '重新走编辑审批','{lastid}','0','sysreflowcheck','申请重新走审批天数，0不让重新走' from `[Q]menu` WHERE `id`=1 and NOT EXISTS(SELECT 1 FROM `[Q]option` where `num`='sysreflowcheck');
- ROCKSPLIT
- INSERT INTO `[Q]option` (`name`,`pid`,`value`,`num`,`explain`) select '物品采购领用直接出入库','62','0',' wpautostock','对应值写1就是物品相关审核完成直接出入库。' from `[Q]menu` WHERE `id`=1 and NOT EXISTS(SELECT 1 FROM `[Q]option` where `num`=' wpautostock');
|
