파수 FXM

SELECT
	approval_no AS approval_id,
	CASE
		WHEN approval_type='TAKEOUT' THEN 'PC반출'
		WHEN approval_type='DECRYPT' THEN '암호화 해제'
		WHEN approval_type='PRINTOUT' THEN '인쇄 예외'
		WHEN approval_type='PROVISIONAL' THEN '임시 권한'
		WHEN approval_type='PRINTPOLICY' THEN '기간 내 예외'
		WHEN approval_type='PRINTFILE' THEN '지정 문서 예외'
		WHEN approval_type='PRINTCLIENT' THEN '인쇄 시 결재'
		WHEN approval_type='ENCMAIL' THEN '암호화 해제 시 메일 전송'
		ELSE approval_type END AS category,
	CASE
		WHEN approval_method='PRE' THEN '사전 결재'
		WHEN approval_method='POST' THEN '사후 결재'
		WHEN approval_method='SELF' THEN '자가 결재'
		WHEN approval_method='PROXY' THEN '대리 승인'
		WHEN approval_method='URGENCY' THEN '관리자 긴급 승인'
	ELSE approval_method END AS method,
	apply_user_id AS user,
	apply_user_name AS user_name,
	apply_dept_code AS user_dept_code,
	apply_dept_name AS user_dept_name,
	apply_position_code AS user_position_code,
	apply_position_name AS user_position_name,
	apply_remark AS description,
	from_unixtime(apply_date/1000) AS event_time,
	approval_step AS total_step,
	current_step AS current_step,
	CASE
		WHEN status='APPLY' THEN '신청'
		WHEN status='PROGRESS' THEN '승인 중'
		WHEN status='CANCEL' THEN '취소'
		WHEN status='REJECT' THEN '반려'
		WHEN status='APPROVAL' THEN '승인 완료'
		WHEN status='EXPIRED' THEN '만료'
		WHEN status='DISMISSAL' THEN '기각'
	ELSE status END AS status,
	apply_step_approval AS approval,
	user_ip AS host_ip,
	code AS policy_code
FROM fxm_approval
$where
ORDER BY approval_no;

SELECT
    action_log_no AS action_log_id,
    approval_no AS approval_id,
    approval_type,
    step AS current_step,
    user_id AS user,
    user_name,
    dept_code AS user_dept_code,
    dept_name AS user_dept_name,
    position_code AS user_position_code,
    position_name AS user_position_name,
    CASE
			WHEN approval_method='PRE' THEN '사전 결재'
			WHEN approval_method='POST' THEN '사후 결재'
			WHEN approval_method='SELF' THEN '자가 결재'
			WHEN approval_method='PROXY' THEN '대리 승인'
			WHEN approval_method='URGENCY' THEN '관리자 긴급 승인'
		ELSE approval_method END AS method,
    CASE
			WHEN approval_status='REJECT' THEN '반려'
			WHEN approval_status='APPROVAL' THEN '승인 완료'
			WHEN approval_status='EXPIRED' THEN '만료'
			WHEN approval_status='DISMISSAL' THEN '기각'
		ELSE approval_status END AS status,
    approval_remark AS description,
    from_unixtime(updated_ts/1000) AS updated,
    updated_ts,
    user_ip AS host_ip,
    other_user_id AS proxy_user_id,
    other_user_name AS proxy_user_name,
    other_position_code AS proxy_position_code,
    other_position_name AS proxy_position_name,
    other_dept_code AS proxy_dept_code,
    other_dept_name AS proxy_dept_name,
    other_role_code AS proxy_role_code,
    other_role_name AS proxy_role_name
FROM fxm_approval_action_log
$where
ORDER BY updated_ts;

SELECT
	approval_no AS approval_id,
	step AS current_step,
	approval_type AS type,
	user_id AS user,
	user_name,
	dept_code AS user_dept_code,
	dept_name AS user_dept_name,
	position_code AS user_position_code,
	position_name AS user_position_name,
	from_unixtime(updated_ts/1000) AS updated,
	updated_ts
FROM fxm_approval_approver
$where
ORDER BY updated_ts;