B
    *d[â  ã               @   s,   d dl mZmZ dd„ Zdd„ Zdd„ ZdS )	é    )Ú
dataAccessÚutilc             C   s6  t  ¡ }|dkr t ¡  d¡}n|}| d| d t| ƒ d ¡}|dkrV|d j}n|}| dt|ƒ d | d	 d
 t| ƒ d | d | d ¡}d}	d }
d }d }g }g }xè|D ]à}||jk�r|d k	rè|
||dœ}| 	|¡ g }|	d7 }	|	}
|j
 d¡}|j}d}|d k�r&|jd k	�r|d}nVt|ƒdk�r|xF|D ]>}t|jƒ| d¡d k�r:t|jƒ| d¡d k�r:d}�q:W |j|j|dœ}| 	|¡ q¶W |
||dœ}| 	|¡ | dt| ƒ d ¡}| dt| ƒ ¡}| dt| ƒ ¡}d}|d k�r|j d¡}| dt| ƒ d | d	 ¡}|||||||jfS )NÚ z%Y/%m/%du—  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 descr   a«  select  M_CheckList.checkCode  , M_CheckList.questionNm  , M_CheckAnswer.answerCode  , T_CheckResult.checkFlg From M_CheckList inner join M_CheckAnswer   on  M_CheckList.checkKbn = M_CheckAnswer.checkKbn left outer join T_CheckResult   on  M_CheckList.checkKbn = T_CheckResult.checkKbn   and M_CheckList.checkCode = T_CheckResult.checkCode   and M_CheckAnswer.answerCode = T_CheckResult.answerCode   and T_CheckResult.userId = z+   and T_CheckResult.implementationDate = 'ú'z where M_CheckList.checkKbn = z and M_CheckList.stDate <= 'z' and M_CheckList.edDate >= 'z:' order by M_CheckList.checkCode, M_CheckAnswer.answerCode)ZrowNoÚ
questionNmZcheckBoxListé   z
ÚcheckedÚ_)Ú	checkCodeÚ
answerCodeÚcheckFlgzBselect answerCode, answerNm  from M_CheckAnswer  where checkKbn = z order by answerCodez@select kbnKey, name from M_KbnMeisyo where kbn = 1 and kbnKey = z8select name from M_KbnMeisyo where kbn = 2 and kbnKey = zwselect  case kakuteiFlg    when 0 then ''           else 'disabled'  end disabled from M_CheckPeriod where checkKbn =  z and stDate = ')r   ÚDBAccessr   Únow_datetimeÚstrftimeÚselect_rowsÚstrÚvaluer
   Úappendr   Úsplitr   Úlenr   Ú
select_rowÚnameÚdisabled)Ú	check_kbnÚcheck_periodÚuser_idÚcheck_resultÚ	db_accessÚnow_dateÚcheck_period_listÚ	proc_dateZrow_check_listÚiZrow_noZquestion_nmÚ
check_codeÚ
check_listZcheck_box_listÚlistZ	check_rowr   ÚrowZ	check_boxÚrow_answer_listZrow_check_nameZ
row_hosokuZrow_hosoku_listZ
kakuteiFlg© r'   ú>C:\python_env\checklist\cms\business\inputCheckListBusiness.pyÚ	init_proc   sˆ    :







r)   c             C   sÂ   t  ¡ }t| ||ƒ}|d k	r |S | dt|ƒ d t| ƒ d | d ¡ xr|D ]j}| dt| ƒ d t| d¡d ƒ d t| d¡d	 ƒ d t|ƒ d
 | d d d ¡ | ¡  qPW d S )Nz*delete from T_CheckResult  where userId = z and checkKbn = z and implementationDate = 'r   z#insert into T_CheckResult  values (ú,r	   r   r   z,'z1))r   r   Ú
inputCheckÚ	regist_dbr   r   Úcommit)r   r   r    r   r   Úmsgr%   r'   r'   r(   Úregist_check_list•   s    &
Zr/   c       
      C   sÀ   t  ¡ }t|ƒdkrdS | dt| ƒ ¡}|d k	rt|jdkrt| dt| ƒ d | d | d ¡}t|ƒ|jkrtd	S d
}d}x>|D ]6}| d¡d }	||	kr¤|	}d}|d7 }|dkr‚dS q‚W d S )Nr   u!   ãƒ�ã‚§ãƒƒã‚¯ã�Œã�‚ã‚Šã�¾ã�›ã‚“ã€‚z9select value from M_KbnMeisyo where kbn = 4 and kbnKey = r   zEselect count(*) as CNT From M_CheckList where M_CheckList.checkKbn = z and M_CheckList.stDate <= 'z' and M_CheckList.edDate >= 'r   u6   ãƒ�ã‚§ãƒƒã‚¯ã�•ã‚Œã�¦ã�ªã�„é …ç›®ã�Œå­˜åœ¨ã�—ã�¾ã�™ã€‚r   r	   u3   ï¼‘ã�¤ã�®é …ç›®ã�«è¤‡æ•°é�¸æŠžã�•ã‚Œã�¦ã�„ã�¾ã�™ã€‚)r   r   r   r   r   r   ZCNTr   )
r   r   r    r   Zrequired_check_flgZcheck_countZbef_check_codeÚcntr%   r"   r'   r'   r(   r+   ²   s(    "
r+   N)Ú
cms.commonr   r   r)   r/   r+   r'   r'   r'   r(   Ú<module>   s    