Feature/chenmin

ServiceSite/src/main/java/com/seasky/flowportal/mapper/xml/BusFlowMapper.xml

@@ -6,7 +6,7 @@
             resultType="com.seasky.flowportal.domain.po.BusFlowPo">
         SELECT *
         FROM (
-            SELECT *,row_number() over (PARTITION BY apply_code ORDER BY create_date DESC) AS group_idx
+            SELECT *,row_number() over (PARTITION BY apply_code ORDER BY create_date DESC, id DESC) AS group_idx
             FROM tb_bus_flow
             WHERE instance_id = #{qry.instanceId} AND execution_status = #{qry.executionStatus}
         ) u
@@ -14,7 +14,7 @@
         <if test="qry.applyCode != null and qry.applyCode != ''">
             AND apply_code LIKE "%"#{qry.applyCode}"%"
         </if>
-        ORDER BY create_date DESC
+        ORDER BY create_date DESC, id DESC
     </select>
 
     <select id="selectFirstNotYetSuccessfulBusFlow"
@@ -30,7 +30,7 @@
                 AND apply_code = #{qry.applyCode}
             </if>
         </where>
-        ORDER BY create_date ASC
+        ORDER BY create_date ASC, id ASC
         LIMIT 1
     </select>
 
@@ -57,7 +57,7 @@
                 AND create_date &lt;= #{qry.createDate}
             </if>
         </where>
-        ORDER BY create_date DESC
+        ORDER BY create_date DESC, id DESC
         LIMIT 1
     </select>
 
@@ -83,7 +83,7 @@
                 AND create_date &lt;= #{qry.createDate}
             </if>
         </where>
-        ORDER BY create_date DESC
+        ORDER BY create_date DESC, id DESC
     </select>
 
 </mapper>
\ No newline at end of file