[쇼룸] 코드 관리 yaml

[hbkim]

셀렉트 쇼룸의 광고 신청 페이지 YAML 코드입니다.

궁금한 점은 댓글이나 이메일, 서비스 내 채팅, 슬랙 등으로 편하게 문의주세요. 감사합니다.

menus:
- path: code-manager
  name: 🍩     코드 관리
pages:
- path: code-manager
  blocks:
    - type: left
      title: 코드내역 조회
      style:
        width: calc(65% - 1rem)    
        padding-right: 1rem
      blocks:
        - type: query
          resource: mysql.qa
          sqlType: select
          name: 코드 그룹
          sql: >
            SELECT *
            FROM CodeGroup
          tableOptions:
            bordered: false
            striped: true
          showDownload: false
          columns:
            name:
              updateParams:
                name: "{{name}}"

        - type: query
          resource: mysql.qa
          sqlType: select
          name: 코드
          sql: >
            SELECT *
            FROM CodeItem
            WHERE (LENGTH(:name)=0 OR group_name = :name)
          params:
            - key: name
              help: 코드 그룹 이름
              datalistFromQuery: 
                type: query
                resource: mysql.qa
                sqlType: select
                sql: >
                  SELECT name
                  FROM CodeGroup
          tableOptions:
            bordered: false
            striped: true
          showDownload: false            

    - type: right
      style:
        width: calc(35% - 1rem)
        padding-left: 1rem
      blocks:
        - type: query
          title: 코드 그룹 추가
          resource: mysql.qa
          sqlType: insert
          sql: >
            INSERT INTO CodeGroup
            SET created_at = NOW()
              , name = :name
              , prefix = :prefix
              , description = :description
          reloadAfterSubmit: true    
          params:
            - key: name
              required: true
            - key: prefix
              required: true
            - key: description

        - type: query
          title: 코드 추가
          resource: mysql.qa
          sqlType: insert
          sql: >
            INSERT INTO CodeItem
            SET created_at = NOW()
              , group_name = :group_name
              , name = :name
              , label = :label
              , description = :description
              , order_number = :order_number
          reloadAfterSubmit: true
          params:
            - key: group_name
              required: true
            - key: name
              required: true
            - key: label
              required: true
            - key: description
            - key: order_number            
              required: true