صفحهٔ اصلی گشت‌و‌گذار راهنما
ورود
mes-cz060
/
mescloud
4
0
انشعاب 0
پرونده‌ها مشکلات 0 درخواست واکشی 0 ویکی
شاخه: master
شاخه‌ها تگ‌ها
mescloud
/
db
/
cz060_line_process_fangdai_repeat.sql

cz060_line_process_fangdai_repeat.sql 17 KB
لینک دائمی تاريخچه خام

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158 
  1. -- =====================================================================================================================================
    2. 

  2. -- CZ060 生产工位管理（mes_line_process）：防呆=否、重复工作=是
    3. 

  3. -- 需求：/js/a/mes/mesLineProcess/list 页面，CZ060 产线所有工位 防呆 设为"否"，重复工作 设为"是"
    4. 

  4. --
    5. 

  5. -- 口径说明（字典 mes_line_process_quality / mes_line_process_repeat：是=1，否=0）：
    6. 

  6. --   防呆 = 否      -> quality = '0'
    7. 

  7. --   重复工作 = 是  -> `repeat` = '1'
    8. 

  8. --
    9. 

  9. -- 业务影响：MesProductRecordController 中判断条件为
    10. 

  10. --   quality='0' AND `repeat`='1'  -> "不防呆且可以重复工作"（过站不校验重复/不拦截）
    11. 

  11. --   quality='1'                   -> 走防呆校验分支
    12. 

  12. --   所以本脚本执行后，CZ060 全部工位不再走防呆校验，并且允许同一工位重复过站。
    13. 

  13. --
    14. 

  14. -- 范围：仅 CZ060 产线（line_id = 2102288813172203520），共 119 个工位；CZ061 不动。
    15. 

  15. -- 幂等性：可重复执行；已符合目标值的行不会被再次更新（update_date 不会被无谓刷新）。
    16. 

  16. -- 生效方式：无缓存，页面刷新即生效。
    17. 

  17. -- =====================================================================================================================================
    18. 

  18. 

  19. -- ---------------------------------------------------------------- 1. 前置核对 ----------------------------------------------------------------
    20. 

  20. -- 执行前后可分别跑一次，确认分布：q_no/q_yes 应逐步变为 119/0，r_no/r_yes 应变为 0/119
    21. 

  21. -- SELECT count(*) cnt,
    22. 

  22. --        sum(quality='0') q_no, sum(quality='1') q_yes,
    23. 

  23. --        sum(`repeat`='0') r_no, sum(`repeat`='1') r_yes
    24. 

  24. --   FROM mes_line_process WHERE line_id = '2102288813172203520';
    25. 

  25. 

  26. -- ---------------------------------------------------------------- 2. 更新 ----------------------------------------------------------------
    27. 

  27. UPDATE mes_line_process
    28. 

  28.    SET quality = '0',
    29. 

  29.        `repeat` = '1',
    30. 

  30.        update_by = 'system',
    31. 

  31.        update_date = NOW()
    32. 

  32.  WHERE line_id = '2102288813172203520'
    33. 

  33.    AND (quality <> '0' OR `repeat` <> '1');
    34. 

  34. 

  35. -- ---------------------------------------------------------------- 3. 回滚参考（默认注释，需要恢复时去掉行首 "-- " 逐行执行） ----------------------------------------------------------------
    36. 

  36. -- 以下每条为改动前该工位 (quality, `repeat`) 的原始值，按 sorts/oprno 排序，共 119 条。
    37. 

  37. -- 一次性回滚（恢复为脚本执行前的状态）也可用：
    38. 

  38. --   UPDATE mes_line_process SET quality='0', `repeat`='1' WHERE line_id='2102288813172203520';  -- 再逐条执行下面与本工位原值一致的行
    39. 

  39. 

  40. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112380841121476608';  /* OP035B 搴曟澘棰勬嫾+鎵撶爜 */
    41. 

  41. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112444934759051264';  /* OP040B 搴曟澘鍙嶉潰FSW */
    42. 

  42. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112444969076846592';  /* OP040C 搴曟澘鍙嶉潰FSW */
    43. 

  43. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112445008994037760';  /* OP040D 搴曟澘鍙嶉潰FSW */
    44. 

  44. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112445072323833856';  /* OP040E 搴曟澘鍙嶉潰FSW */
    45. 

  45. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112445104003411968';  /* OP040F 搴曟澘鍙嶉潰FSW */
    46. 

  46. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112445203018346496';  /* OP045B 搴曟澘鍙嶉潰鎵撶（ */
    47. 

  47. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112447838022725632';  /* OP050B 搴曟澘姝ｉ潰FSW */
    48. 

  48. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112447722054414336';  /* OP050C 搴曟澘姝ｉ潰FSW */
    49. 

  49. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112447787309395968';  /* OP050D 搴曟澘姝ｉ潰FSW */
    50. 

  50. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112447860713910272';  /* OP050E 搴曟澘姝ｉ潰FSW */
    51. 

  51. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112447738026323968';  /* OP050F 搴曟澘姝ｉ潰FSW */
    52. 

  52. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112424349903548416';  /* OP055B CNC渚ч摚 */
    53. 

  53. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112424423295479808';  /* OP055C CNC渚ч摚 */
    54. 

  54. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112743982488203264';  /* OP070B 灏佹澘姝ｉ潰FSW */
    55. 

  55. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112744034933780480';  /* OP070C 灏佹澘姝ｉ潰FSW */
    56. 

  56. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112744048456216576';  /* OP070D 灏佹澘姝ｉ潰FSW */
    57. 

  57. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112744239133470720';  /* OP075B 灏佹澘姝ｉ潰鎵撶（ */
    58. 

  58. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112744427977814016';  /* OP080B 灏佹澘鍙嶉潰FSW */
    59. 

  59. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112744442536243200';  /* OP080C 灏佹澘鍙嶉潰FSW */
    60. 

  60. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112744459682557952';  /* OP080D 灏佹澘鍙嶉潰FSW */
    61. 

  61. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112744474169683968';  /* OP080E 灏佹澘鍙嶉潰FSW */
    62. 

  62. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112744486983282688';  /* OP080F 灏佹澘鍙嶉潰FSW */
    63. 

  63. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='2112441840369332224';  /* OP095B 妫€婕忎竴搴?0 */
    64. 

  64. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112424588228096000';  /* OP105B 棰勬嫾閿佷粯 */
    65. 

  65. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2112424635812474880';  /* OP105C 棰勬嫾閿佷粯 */
    66. 

  66. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='2109936485343428608';  /* OP120B TIG鎵嬪伐鐒?0 */
    67. 

  67. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='2109936509099966464';  /* OP120C TIG鎵嬪伐鐒?0 */
    68. 

  68. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='2110211986548830208';  /* OP180A 鏀灦瀹夎 */
    69. 

  69. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154026001';  /* OP035 搴曟澘棰勬嫾+鎵撶爜 */
    70. 

  70. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168068049';  /* OP035A 搴曟澘棰勬嫾+鎵撶爜 */
    71. 

  71. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154028002';  /* OP040 搴曟澘鍙嶉潰FSW */
    72. 

  72. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168069050';  /* OP040A 搴曟澘鍙嶉潰FSW */
    73. 

  73. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154028003';  /* OP045 搴曟澘鍙嶉潰鎵撶（ */
    74. 

  74. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168069051';  /* OP045A 搴曟澘鍙嶉潰鎵撶（ */
    75. 

  75. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154028004';  /* OP050 搴曟澘姝ｉ潰FSW */
    76. 

  76. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168069052';  /* OP050A 搴曟澘姝ｉ潰FSW */
    77. 

  77. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154028005';  /* OP055 CNC渚ч摚 */
    78. 

  78. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168069053';  /* OP055A CNC渚ч摚 */
    79. 

  79. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154028006';  /* OP060 骞插啺娓呮磥 */
    80. 

  80. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168069054';  /* OP060A 骞插啺娓呮磥 */
    81. 

  81. -- UPDATE mes_line_process SET quality='0', `repeat`='1' WHERE id='1790149154028007';  /* OP065 灏佹澘棰勮+鐐圭剨 */
    82. 

  82. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168069055';  /* OP065A 灏佹澘棰勮+鐐圭剨 */
    83. 

  83. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154029008';  /* OP070 灏佹澘姝ｉ潰FSW */
    84. 

  84. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168069056';  /* OP070A 灏佹澘姝ｉ潰FSW */
    85. 

  85. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154029009';  /* OP075 灏佹澘姝ｉ潰鎵撶（ */
    86. 

  86. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168069057';  /* OP075A 灏佹澘姝ｉ潰鎵撶（ */
    87. 

  87. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154029010';  /* OP080 灏佹澘鍙嶉潰FSW */
    88. 

  88. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168069058';  /* OP080A 灏佹澘鍙嶉潰FSW */
    89. 

  89. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149154029011';  /* OP085 TIG鎵嬪伐鐒?1 */
    90. 

  90. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149168070059';  /* OP085A TIG鎵嬪伐鐒?0 */
    91. 

  91. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154029012';  /* OP090 鎵撶（ */
    92. 

  92. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168070060';  /* OP090A 鎵撶（ */
    93. 

  93. -- UPDATE mes_line_process SET quality='1', `repeat`='' WHERE id='1790149154029013';  /* OP095 妫€婕忎竴搴?0 */
    94. 

  94. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149168070061';  /* OP095A 妫€婕忎竴搴?0 */
    95. 

  95. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149154030015';  /* OP100 鍓嶈啫鑳€姊佹墦鐮?1 */
    96. 

  96. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168070062';  /* OP105A 棰勬嫾閿佷粯 */
    97. 

  97. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149168070063';  /* OP100A 鍓嶈啫鑳€姊佹墦鐮?0 */
    98. 

  98. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154029014';  /* OP105 棰勬嫾閿佷粯 */
    99. 

  99. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149154030016';  /* OP110 寮х剨涓€搴?1 */
    100. 

  100. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149168070064';  /* OP110A 寮х剨涓€搴?0 */
    101. 

  101. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154030017';  /* OP115 寮х剨浜屽簭 */
    102. 

  102. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168071065';  /* OP115A 寮х剨浜屽簭 */
    103. 

  103. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149154030018';  /* OP120 TIG鎵嬪伐鐒?1 */
    104. 

  104. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149168071066';  /* OP120A TIG鎵嬪伐鐒?0 */
    105. 

  105. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154030019';  /* OP125 鎵撶（ */
    106. 

  106. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168071067';  /* OP125A 鎵撶（ */
    107. 

  107. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154030020';  /* OP130 鎬绘垚姝ｉ潰CNC */
    108. 

  108. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168071068';  /* OP130A 鎬绘垚姝ｉ潰CNC */
    109. 

  109. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154031021';  /* OP135 鎬绘垚鍙嶉潰CNC */
    110. 

  110. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168071069';  /* OP135A 鎬绘垚鍙嶉潰CNC */
    111. 

  111. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154031022';  /* OP140 鍚归摑灞?鍒瘺鍒?娓呮磥 */
    112. 

  112. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168072070';  /* OP140A 鍚归摑灞?鍒瘺鍒?娓呮磥 */
    113. 

  113. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149154031023';  /* OP145 妫€婕忎簩搴?1 */
    114. 

  114. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149168072071';  /* OP145A 妫€婕忎簩搴?0 */
    115. 

  115. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154032027';  /* OP150 鎷夐搯 */
    116. 

  116. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149168072072';  /* OP150A TIG鎵嬪伐鐒?0 */
    117. 

  117. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168072073';  /* OP166A 浜哄伐娓呮磥 */
    118. 

  118. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149154032029';  /* OP160 绠变綋姘斿瘑涓€搴?1 */
    119. 

  119. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168072074';  /* OP175A 鎶借姱鎷夐搯 */
    120. 

  120. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168072075';  /* OP150A 鎷夐搯 */
    121. 

  121. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149154033030';  /* OP165 姘撮亾姘斿瘑涓€搴?1 */
    122. 

  122. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154032025';  /* OP166 浜哄伐娓呮磥 */
    123. 

  123. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154032028';  /* OP170 铻哄瀹夎 */
    124. 

  124. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168073076';  /* OP170A 铻哄瀹夎 */
    125. 

  125. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149168073077';  /* OP160A 绠变綋姘斿瘑涓€搴?0 */
    126. 

  126. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154032026';  /* OP175 鎶借姱鎷夐搯 */
    127. 

  127. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149168073078';  /* OP165A 姘撮亾姘斿瘑涓€搴?0 */
    128. 

  128. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='2110211325606211584';  /* OP180 鏀灦瀹夎 */
    129. 

  129. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154033032';  /* OP185 鐧戒欢GP12 */
    130. 

  130. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149168073079';  /* OP190A 妫€鍏?0 */
    131. 

  131. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168073080';  /* OP185A 鐧戒欢GP12 */
    132. 

  132. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149154033031';  /* OP190 妫€鍏?1 */
    133. 

  133. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149154033033';  /* OP195 鍠风矇鍓嶆墦鍖?1 */
    134. 

  134. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149168073081';  /* OP195A 鍠风矇鍓嶆墦鍖?0 */
    135. 

  135. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154033037';  /* OP205 姘︽ */
    136. 

  136. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168073083';  /* OP210A 绠变綋姘斿瘑浜屽簭 */
    137. 

  137. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154033035';  /* OP210 绠变綋姘斿瘑浜屽簭 */
    138. 

  138. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168074085';  /* OP205A 姘︽ */
    139. 

  139. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154034038';  /* OP220 鎬绘垚娓呮磥 */
    140. 

  140. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168074086';  /* OP220A 鎬绘垚娓呮磥 */
    141. 

  141. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149154034039';  /* OP225 瀹夎瀹氫綅閿€&璐磋兌甯?1 */
    142. 

  142. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168074087';  /* OP225A 鏀灦銆佸畾浣嶉攢瀹夎 */
    143. 

  143. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149154034040';  /* OP230 璐磒c鏉?1 */
    144. 

  144. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168074088';  /* OP230A 娑傝兌 */
    145. 

  145. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154034041';  /* OP235 娑傚皝鍫佃兌 */
    146. 

  146. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168074089';  /* OP235A 鍏ㄦ */
    147. 

  147. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154034042';  /* OP240 鍏ㄦ */
    148. 

  148. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149168074090';  /* OP240A GP12鎴愬搧妫€楠?0 */
    149. 

  149. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149154034043';  /* OP245 GP12鎴愬搧妫€楠?1 */
    150. 

  150. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149168074091';  /* OP245A CCD妫€娴?0 */
    151. 

  151. -- UPDATE mes_line_process SET quality='0', `repeat`='' WHERE id='1790149154035044';  /* OP250 CCD妫€娴?1 */
    152. 

  152. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168074092';  /* OP250A 缁濈紭鑰愬帇娴嬭瘯 */
    153. 

  153. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168074093';  /* OP260A 鎴愬搧鎵撳寘 */
    154. 

  154. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154035045';  /* OP260 鎴愬搧鎵撳寘 */
    155. 

  155. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168075094';  /* OP265A 鍏ュ簱 */
    156. 

  156. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154035046';  /* OP265 鍏ュ簱 */
    157. 

  157. -- UPDATE mes_line_process SET quality='1', `repeat`='0' WHERE id='1790149154035047';  /* OP270 鍑鸿揣 */
    158. 

  158. -- UPDATE mes_line_process SET quality='0', `repeat`='0' WHERE id='1790149168075095';  /* OP270A 鍑鸿揣 */
    159.