B 1 [ñã@s0ddlmZmZdZdd„Zdd„Zdd„Zd S) é)Ú dataAccessÚutilZtypicalcCsTt ¡}| d|d¡}t|||ƒ}|dk r2|S|j d¡|j|jd<tƒdS)NzÉselect M_Syain_Mail.SyainCode from [M_system].[dbo].M_Syain_Mail inner join [M_system].[dbo].M_Syain on M_Syain_Mail.SyainCode = M_Syain.SyainCode and M_Syain.DELETEFLAG = 0 where Mail_Address = 'ú'rÚuserId)rÚDBAccessÚ select_rowsÚ input_checkÚsessionZ set_expiryZ SyainCodeÚcreate_check_period)ÚrequestÚsyain_idÚpasswordÚ db_accessÚm_syainZ err_message©rú5C:\python_env\checklist\cms\business\loginBusiness.pyÚdo_logins   rcCs4|dkr dS|dkrdS|dkr$dS|tkr0dSdS)NÚu-ユーザåãŒå…¥åŠ›ã•ã‚Œã¦ã„ã¾ã›ã‚“。u0パスワードãŒå…¥åŠ›ã•ã‚Œã¦ã„ã¾ã›ã‚“。uユーザåãŒä¸æ­£ã§ã™ã€‚u!パスワードãŒä¸æ­£ã§ã™ã€‚)ÚLOGIN_PASSWORD)r r rrrrr8src CsŒt ¡}t ¡ d¡}| d¡}x\|D]R}| dt|jƒd|d|d¡}|j dkr(| dt|jƒ¡}|j }|d kr’t ¡ d ¡}nªt ¡j }t ¡j } d } | d krº| d 7} x€t d ƒD]t} | | kræ| |d kr0nnF| d krú| d } | |d d kr|d 8}t|ƒdt| dƒd}P| |7} qÄW| dt|jƒd|dddt|ƒd|dd¡q(W| ¡dS)Nz%Y/%m/%dz2select kbnKey, name from M_KbnMeisyo where kbn = 1z;select count(*) as cnt from M_CheckPeriod where checkKbn = z and stDate <= 'z' and edDate >= 'rrz:select value from M_KbnMeisyo where kbn = 3 and kbnKey = éz%Y/%m/01éé éú/Z02dz/01z"insert into M_CheckPeriod values (z,'ú,zDATEADD(DAY,-1,DATEADD(MONTH,z'))z,0))rrrZ now_datetimeÚstrftimerZ select_rowÚstrZkbnKeyÚcntÚvalueÚyearÚmonthÚrangeÚformatZ regist_dbÚcommit) rZnow_dateÚcheck_list_kbnÚrowZcheck_period_cntZ check_preiodZpreiodZst_dateZnow_yearZ now_monthZ calc_monthÚidxrrrr Fs>$   " @r N)Z cms.commonrrrrrr rrrrÚs0