B ¤d[Aã@sddlmZmZdd„ZdS)é)Ú dataAccessÚutilcCs<t ¡}t ¡ d¡}| d|d|d|d¡}|S)Nz%Y/%m/%dzÜselect kbnKey , name , (select count(*) from M_CheckPeriod mcp inner join T_CheckResult tcr on mcp.checkKbn = tcr.checkKbn and mcp.stDate = tcr.implementationDate and tcr.userId = 'zG' where mcp.checkKbn = M_KbnMeisyo.kbnKey and mcp.stDate <= 'z' and mcp.edDate >= 'z,' ) as cnt from M_KbnMeisyo where kbn = 1)rÚDBAccessrÚ now_datetimeÚstrftimeÚ select_rows)Úuser_idÚ db_accessÚnow_dateÚcheck_list_kbn©r ú4C:\python_env\checklist\cms\business\menuBusiness.pyÚ init_procs  rN)Ú cms.commonrrrr r r r Ús