Project

General

Profile

New Function #100

Updated by Deca Park over 1 year ago

<p>1.description<br /> 
 &nbsp; 1) crontab<br /> 
 &nbsp; &nbsp; - <strong>everyday 4 AM</strong><br /> 
 &nbsp; &nbsp; - get store / store product data from KRS DB<br /> 
 &nbsp; 2) <strong>KRS DB info (define as properties)</strong><br /> 
 &nbsp; &nbsp; - IP : 222.108.149.24<br /> 
 &nbsp; &nbsp; - DBMS : Oracle11g<br /> 
 &nbsp; &nbsp; - SID : orahi<br /> 
 &nbsp; &nbsp; - USER : US_STORYAPP<br /> 
 &nbsp; &nbsp; - PW : sApp8800!</p> 

 <p>2<strong>.Scheduler -&nbsp;KRS Store DB </strong><br /> 
 &nbsp; 1) logic<br /> 
 &nbsp; &nbsp; a) SELECT KRS DB (VI_APP_STORE_STORY)<br /> 
 &nbsp; &nbsp; &nbsp; &nbsp;columns: set according to&nbsp;following mapping info (not use *)<br /> 
 &nbsp; &nbsp; &nbsp; &nbsp;condition: BSNS_SE_CD IN (&#39;102&#39;,&#39;002&#39;) // 102: 편의점, 002: 전문점<br /> 
 &nbsp; &nbsp; b) mapping<br /> 
 &nbsp; &nbsp; &nbsp; KRS: VI_APP_STORE_STORY -&gt; KORAIL: st_mall<br /> 
 &nbsp; &nbsp; &nbsp; ------------------------------------------------------------<br /> 
 &nbsp; &nbsp; &nbsp; DEPT_CD -&gt; mall_code<br /> 
 &nbsp; &nbsp; &nbsp; DEPT_NM -&gt; mall_name<br /> 
 &nbsp; &nbsp; &nbsp; APP_STATN_CD -&gt; station_code<br /> 
 &nbsp; &nbsp; &nbsp; STORE_LCLAS_CD -&gt; store_category_code<br /> 
 &nbsp; &nbsp; &nbsp; STORE_LC_NM -&gt; mall_location<br /> 
 &nbsp; &nbsp; &nbsp; CTTPC_NO -&gt; mall_phone<br /> 
 &nbsp; &nbsp; &nbsp; IMG_URL -&gt; image_url (NEW)<br /> 
 &nbsp; &nbsp; &nbsp; BSNS_SE_CD -&gt; bsns_se_cd (NEW)</p> 

 <p>&nbsp; &nbsp; &nbsp; KRS: VI_APP_STORE_STORY -&gt; KORAIL: st_mall_hour<br /> 
 &nbsp; &nbsp; &nbsp; ------------------------------------------------------------<br /> 
 &nbsp; &nbsp; &nbsp; START_TM -&gt; start_hour (convert: 0600 -&gt; 06:00)<br /> 
 &nbsp; &nbsp; &nbsp; END_TM -&gt; end_hour (convert: 0600 -&gt; 06:00)<br /> 
 &nbsp; &nbsp; c) INSERT/UPDATE KORAIL DB (st_mall)<br /> 
 &nbsp; &nbsp; &nbsp; c-1) if data is NOT existed, INSERT st_mall<br /> 
 &nbsp; &nbsp; &nbsp; &nbsp; - <strong>mall_type : &#39;store&#39;</strong><br /> 
 &nbsp; &nbsp; &nbsp; &nbsp; - reg_date : current date<br /> 
 &nbsp; &nbsp; &nbsp; c-2) if data is existed, UPDATE st_mall<br /> 
 &nbsp; &nbsp; &nbsp; &nbsp; - mod_date : current date<br /> 
 &nbsp; &nbsp; c) INSERT/UPDATE KORAIL DB (st_mall_hour)<br /> 
 &nbsp; &nbsp; &nbsp; c-1) if data is NOT existed, INSERT st_mall_hour<br /> 
 &nbsp; &nbsp; &nbsp; &nbsp; - sort_no : 1<br /> 
 &nbsp; &nbsp; &nbsp; &nbsp; - hour_type : &#39;HT01&#39;<br /> 
 &nbsp; &nbsp; &nbsp; c-2) if data is existed, UPDATE st_mall_hour<br /> 
 &nbsp; &nbsp; &nbsp;&nbsp;</p> 

 <p>3<strong>.Scheduler -&nbsp;KRS Store Product DB</strong></p> <p><br /> 
 IMG_URL</p> 

 <p><br /> 
 CTTPC_NO</p> 

 <p><br /> 
 bsns_se_cd</p>

Back