B £Øt[Hã@s$ddlmZmZdd„Zdd„ZdS)é)Ú dataAccessÚutilcCs†t ¡}| dt|ƒd¡}|dkr6t ¡ d¡}n|}|dkrL|dj}| d|dt|ƒd¡}|dkr||dj}| d t|ƒd ¡}| d t|ƒd |d ¡}| dt|ƒd|d¡}g} g} x||D]t} xH|D]@} d} x,|D]$}| j |j krô| j |j krô|j } PqôW|   | ¡qæW| j| j | j| j| dœ}|   |¡g} qÜW| dt|ƒd|d¡}||| ||||jfS)Nzselect kbnKey , name , case zo when kbnKey then 'selected' else '' end as selectedValue from M_KbnMeisyo where kbn = 1Úz%Y/%m/%dru—select CONVERT(NVARCHAR, stDate, 11) as value , case MONTH(stDate) when MONTH(edDate) then STR(YEAR(stDate)) + 'å¹´' + RIGHT(SPACE(1) + STR(MONTH(stDate)), 2) + '月' else STR(YEAR(stDate)) + 'å¹´' + RIGHT(SPACE(1) + STR(MONTH(stDate)), 2) + '月' + ' ～' + STR(YEAR(edDate)) + 'å¹´' + RIGHT(SPACE(1) + STR(MONTH(edDate)), 2) + '月' end as dispValue , case stDate when 'zq' then 'selected' else '' end as selectedValue From M_CheckPeriod where checkKbn = z order by stDate desczBselect answerCode, answerNm from M_CheckAnswer where checkKbn = z order by answerCodezŒselect syainName, SYAINCODE , ( select count(*) from T_CheckResult tcr where ms.syainCode = tcr.userId and tcr.checkKbn = z# and tcr.implementationDate = 'z¡' ) as resultCnt , row_number() OVER (ORDER BY SYAINCODE) - 1 as rowNumber From [M_system].[dbo].M_Syain ms where GroupCode in ('06','07') order by SYAINCODEzTselect userId , answerCode , count(*) as CNT from T_CheckResult where checkKbn = z and implementationDate = 'z'' group by userId, checkKbn, answerCode)Ú syainNameZ syainCodeÚ resultCntÚ rowNumberZcheckCountListz6select kakuteiFlg from M_CheckPeriod where checkKbn = z and stDate = 'ú')rÚDBAccessÚ select_rowsÚstrrÚ now_datetimeÚstrftimeÚkbnKeyÚvalueZ SYAINCODEÚuserIdÚ answerCodeÚCNTÚappendrrrÚ select_rowÚ kakuteiFlg)Ú check_kbnÚ check_periodÚ db_accessÚcheck_list_kbnÚnow_dateÚcheck_period_listÚrow_answer_listÚuser_check_result_listZcheck_result_count_listZcheck_count_listZuser_check_result_list_modZrow_resZrow_ansÚ check_countZrow_cntZrow_inÚkakutei©r ú5C:\python_env\checklist\cms\business\adminBusiness.pyÚ init_procsR        r"cCsbt ¡}| dt|ƒd|d¡| ¡| dt|ƒd|d¡}|jdkrZdSdSdS) Nzcupdate M_CheckPeriod set kakuteiFlg = case kakuteiFlg when 0 then 1 else 0 end where checkKbn = z and stDate = 'rz6select kakuteiFlg from M_CheckPeriod where checkKbn = z and stDate = 'éu確定ãŒå®Œäº†ã—ã¾ã—ãŸã€‚u$確定解除ãŒå®Œäº†ã—ã¾ã—ãŸã€‚)rr Ú regist_dbr Úcommitrr)rrrrr r r!Úregist_kakutei_flgos r&N)Ú cms.commonrrr"r&r r r r!Úsk