콘텐츠 관리 CMS ​

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
    autoload: false
    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