# \[쇼룸\] 구성원 연락처 yaml

**URL:** <https://ask.selectfromuser.com/t/yaml/97>\
**Category:** 자유게시판\
**Tags:** showroom\
**Created:** [2월 13, 2024, 5:27오전 UTC](https://ask.selectfromuser.com/t/yaml/97 "2024-02-13T05:27:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![hbkim](https://yyz2.discourse-cdn.com/flex032/user_avatar/ask.selectfromuser.com/hbkim/32/23_2.png) [@hbkim](https://ask.selectfromuser.com/u/hbkim)\
**Post date:** [2월 13, 2024, 5:27오전 UTC](https://ask.selectfromuser.com/t/yaml/97/1 "2024-02-13T05:27:00Z")

</div>

셀렉트 쇼룸의 [구성원 연락처](https://showroom.selectfromuser.com/member-contacts) 페이지의 YAML 코드입니다.

궁금한 점은 댓글이나 [이메일](mailto:support@selectfromuser.com), 서비스내 채팅 등으로 편하게 문의주세요.

 ![image](https://canada1.discourse-cdn.com/flex032/uploads/selectfromuser/original/1X/810fcf05f93b34dbec950d070fd2d41f03ef5bfd.jpeg)

```yaml
menus:
- path: member-contacts
  name: 📗 구성원 연락처
  
pages:
- path: member-contacts
  class: container
  blocks:
  - type: query
    resource: mysql.qa
    sqlType: select
    sql: >
      select *
      from members
      limit 5
    showDownload: csv
    columns:
      id:
        label: ID
      created_at:
        label: 생성일
      updated_at:
        hidden: true
      deleted_at:
        hidden: true
      name:
        label: 이름
      email:
        label: 이메일
      phone:
        label: 연락처
      department:
        label: 부서
      role:
        label: 직책
      company_phone:
        label: 회사전화
    actions:
      - type: query
        label: CSV 파일로 업로드
        resource: mysql.qa
        toast: >
          예시: 미리보기 내용을 업로드합니다.
        sqlType: insert
        sql: >
          INSERT INTO members
          SET created_at = NOW()
            , name = :name
            , email = :email
            , phone = :phone
            , department = :department
            , role = :role
            , company_phone = :company_phone
        forEach: true
        single: true
        modal: true
        params:
          - key: sheet
            format: sheet
            label: CSV 파일
          - key: name
            valueFromSheet: name
          - key: email
            valueFromSheet: email
          - key: phone
            valueFromSheet: phone
          - key: department
            valueFromSheet: department
          - key: role
            valueFromSheet: role                        
          - key: company_phone
            valueFromSheet: company_phone          
        reloadAfterSubmit: true
        resetAfterSubmit: true

```
