Ellis improvement

개선(improvement) #307

Updated by John Lee 9 months ago

Notion: https://www.notion.so/traport/Improvement-Replace-orders-of-list-Product-Group-and-Product-List-on-Event-Deals-menu-1b993412093e8037ad96eb9db1acf2be?pvs=4 

 Description: 
 1. The ability to change the order with drag and drop should only be applied within the same city. Items within the same city can only be changed. 
 2. If you change the order by drag and drop and save it, it means that the same order will be applied to the B2C site as well.  
 If you swap the positions of product 1 and product 2 in the admin, it will appear in the 2-1 order in the admin, and the B2C site will also show the 2-1 order. 

 !picture779-1.png! 


 Script update ranking_order raking_order product hotel: 
 <pre><code class="c"> 
 UPDATE BS_EVENT_PRODUCT ep 
 JOIN ( 
     SELECT  
         PRODUCT_CODE, 
         EVENT_MASTER_SEQ, 
         ROW_NUMBER() OVER ( 
             PARTITION BY EVENT_CITY_GROUP_SEQ  
             ORDER BY RANKING_ORDER 
         ) AS new_rank 
     FROM BS_EVENT_PRODUCT 
 ) ranked ON ep.PRODUCT_CODE = ranked.PRODUCT_CODE 
 AND ep.EVENT_MASTER_SEQ = ranked.EVENT_MASTER_SEQ 
 SET ep.RANKING_ORDER = ranked.new_rank; 
 </code></pre> 

 Script update ranking_order raking_order product group hotel: 
 <pre><code class="c"> 
 UPDATE BS_EVENT_CITY_GROUP ep 
 JOIN ( 
     SELECT  
         EVENT_CITY_GROUP_SEQ, 
         EVENT_MASTER_SEQ, 
         ROW_NUMBER() OVER ( 
             PARTITION BY EVENT_MASTER_SEQ 
             ORDER BY RANKING_ORDER 
         ) AS new_rank 
     FROM BS_EVENT_CITY_GROUP 
 ) ranked ON ep.EVENT_MASTER_SEQ = ranked.EVENT_MASTER_SEQ 
 AND ep.EVENT_CITY_GROUP_SEQ = ranked.EVENT_CITY_GROUP_SEQ 
 SET ep.RANKING_ORDER = ranked.new_rank; 
 </code></pre> 

Back