# 위 화면은 아래의 설정으로 만들어졌습니다.
menus:
- path: contents
  name: 컨텐츠 관리
  group: cms

pages:
- path: contents
  blocks:
    - type: query
      resource: mysql.cms
      sqlType: select
      sql: >
        SELECT *
        FROM s_contents
        WHERE (!LENGTH(:locale) OR locale = :locale)
        ORDER BY page, order_in_page ASC
      searchOptions:
        enabled: true                  
      params:
        - key: locale
          label: 언어
          dropdown:
            - '' 
            - en-US
            - ko-KR
      columns:
        id:
          label: ID
        page:
          label: 페이지
        label:
          label: 라벨
        content:
          label: 내용
        order_in_page:
          label: 페이지 순서
        locale:
          label: 언어

      viewModal:
        useColumn: page
        blocks:
          - type: query
            resource: mysql.cms
            sqlType: update
            sql: >
              UPDATE s_contents
              SET content = :content
              WHERE id = :id
            reloadAfterSubmit: true  
            params:
              - key: content
                label: 콘텐츠
                format: textarea
                defaultValueFromRow: content
              - key: id
                label: ID
                valueFromRow: id

# https://www.selectfromuser.com