title: 어드민 제목

layout:
  style:
    backgroundColor: "#3f63bf !important"
    borderBottom: solid 1px rgba(0,0,0,0.05)

layout:
  login:
    methods:
      google:
        enabled: true
        text: 회사계정 로그인
      email:
        enabled: true
        text: 이메일 비밀번호 로그인
    
    header: Selectfromuser.com
    # header: |
    #   <img src="https://align.selectfromuser.com/lib_DmHvtrBlUMtUhGvc/sh11bex09q31frsy.png" style="height: 50px; margin: 0 auto;" />
    favicon: https://files.umso.co/lib_DmHvtrBlUMtUhGvc/emvdae7wl2lyppo0.png
    title: 파트너센터 로그인
    subtitle: 입점한 셀러분들만 이용할 수 있어요.
    width: 600
    buttons:
      - label: 도움말
        href: https://docs.selectfromuser.com
        target: _blank
      - label: 입점하기
        href: https://docs.selectfromuser.com
        target: _blank
    footer: |
      <b>© 2023 selectfromuser Inc.</b>
      주식회사 셀렉트프롬유저 | 서울시 송파구 법원로 128, B동 1408호 (문정동, 문정역SKV1)
      사업자등록번호 386-88-02410 | 통신판매신고 제2023-서울송파-0491호

layout:
  head:
    - tag: script
      async: true
      src: https://www.googletagmanager.com/gtag/js?id=G-XXXXXXXXXX
    
    - tag: script
      innerHTML: |
        window.dataLayer = window.dataLayer || [];
        function gtag(){dataLayer.push(arguments);}
        gtag('js', new Date());

        gtag('config', 'G-XXXXXXXXXX');

layout:
  hideLeftMenu: true

menus:
- path: user
  name: 사용자

menus:
- path: user
  name: 사용자
  group: u
- path: user/active
  name: 활성 유저
  group: u

placement: menu-only
placement: tab-only
placement: expand-only
placement: page-only # 탭메뉴 표시 안함

menus:
- path: user
  name: 사용자
  group: u
- path: user/active
  name: 활성 유저
  group: u
  placement: tab-only

menus:
- path: user
  name: 사용자
  group: u
  redirect: user/all
  placement: menu-only
- path: user/all
  name: 전체 사용자
  group: u
  placement: tab-only
- path: user/active
  name: 활성 유저
  group: u
  placement: tab-only

menus:
- path: /approvals
  name: 심사
  roles:
    list:
    - 팀장
    - 임원
    view:
    - 팀장
    - 임원
    - email::test@email.com

menus:
- path: user
  name: 사용자
  group: u
  
- type: divider

- path: payment
  name: 결제
  group: p

menus: 

  - type: search
    label: 검색
    placeholder: 고객이름
    redirect: search-user?name={{value}}

  - type: search
    label: 찾기
    placeholder: 010-0000-0000
    redirect: search-user?phone={{value}}
    
  - path: search-user

menus:

  - type: search
    label: 검색
    placeholder: 010-0000-0000
    redirect: search-user?phone={{value}}
    placement: top
    style:
      width: 500px

menus:
  - type: search
    placement: top
    placeholder: 상품코드/재고코드/공급코드
    style:
      width: 300px
    datalistFromQuery:
      resource: mysql.qa
      type: query
      sqlType: select 
      sql: >
        (
          SELECT id, name, 'properties' AS category
          FROM properties
          WHERE id LIKE CONCAT('%', :value, '%')
             OR (LENGTH(:value) > 2 AND name LIKE CONCAT('%', :value, '%'))
          ORDER BY id DESC
          LIMIT 10
        )
        UNION ALL
        (
          SELECT id, name AS name2, 'properties2' AS category
          FROM properties2
          WHERE id LIKE CONCAT('%', :value, '%')
             OR (LENGTH(:value) > 2 AND name LIKE CONCAT('%', :value, '%'))
          ORDER BY id DESC
          LIMIT 10
        )
      format: >
        ID: {{ id}}     Name: {{name}}{{   name2    }} ({{category}})
      
      # html: true
      # format: >
      #   <span style="color: royalblue">ID: {{ id}}</span>    
      #   {{name}}{{   name2   }}
      #   ({{category}})

      # redirect: search-user-id?p={{category}}&user_id={{id}}
      
      redirect:
        properties: search-user-id?p={{category}}&user_id={{id}}
        properties2: >
          search-user-id?p={{category}}&cc_id={{id}}#{{hero_image_url}}

menus:
- name: 시약관리
  type: nav
  placement: top
  menus:
  - path: pages/search
    name: 시약검색
    placement: top
  - path: pages/codes
    name: 코드관리
    placement: top
  - path: pages/qc
    name: 품질관리
    placement: top

menus:
- path: user
  icon: U
  name: 사용자  
- path: payment
  icon: mdi-cash
  name: 결제관리

menus:
- path: payment
  iconEnd: mdi-cash
  name: 결제관리

menus:
- path: user
  name: 사용자 관리
  placement: expand-only

  menus:
  - path: active-user
    name: 활성 사용자

menus:
- path: orders/pending
  name: 상품 준비중 관리
  badgeOptions:
    enabled: true
    type: query
    resource: mysql.qa
    sql: >
      SELECT COUNT(id) FROM ProductOrder
    postfix: 건
    color: green

menus:
- path: user
- path: payment

pages:
- path: user
- path: payment

menus:
- path: user

pages:
- path: user
  blocks:

pages:
- path: user
  autofocus: false

pages:
  - path: property-detail
    layout:
      style:
        # max-width: 1400px
        margin: 0px auto
        display: flex
        flex-wrap: wrap
      div:
        - name: page1
          style:
            width: 100%
        - name: page2-1
          style: 
            width: 50%
            padding-right: 20px
        - name: page2-2
          style: 
            width: 50%
        - name: page3
          style:
            width: 100%
    blocks:
      - layout: page1
        type: markdown
      - layout: page2-1
        type: markdown
      - layout: page2-2
        type: markdown
      - layout: page3
        type: markdown

pages:
  - path: sample/layout/dashboard
    layout: dashboard
    blocks:
      - type: markdown
        content: |
          layout dashboard 1
      - type: markdown
        content: |
          layout dashboard 2
      - type: markdown
        content: |
          layout dashboard 3

pages:
- path: pages/Ze1f_b
  roles:
    list: 
      - email::test@selectfromuser.com
    view:
      - email::test@selectfromuser.com

menus:
- path: pages/Ze1f_b
  placement: page-only
  roles:
    list: 
      - email::test@selectfromuser.com
    view:
      - email::test@selectfromuser.com  
pages:
- path: pages/Ze1f_b

blocks:
- type: query
- type: http
- type: markdown

blocks:
- type: query
  name: 샘플 쿼리
  resource: sample.db
  sqlType: select # update, insert
- type: http
  name: 샘플 http
  axios: GET
- type: markdown
  content: type anything

sqlType: select
sqlType: update
sqlType: insert

- type: query
  resource: sample.db
  sqlType: select
  sql: SELECT * FROM user LIMIT 10

- type: query
  resource: sample.db
  sqlType: update
  sql: UPDATE user SET status = :status WHERE id = :id AND email = :email
  params:
  - key: status
  - key: id
  - key: email

- type: query
  resource: sample.db
  sqlType: select
  sql: UPDATE user SET status = :status WHERE id = :id AND email = :email
  sqlConfirm: true
  params:
  - key: status
  - key: id
  - key: email

- type: query
  resource: mysql.qa
  sqlType: insert
  sql: INSERT INTO properties SET created_at = NOW(), name = :name
  params:
    - key: name
  confirm: false

- type: query
  resource: sample.db
  sqlType: select
  sql: UPDATE user SET status = :status WHERE id = :id AND email = :email
  sqlConfirm: true
  params:
  - key: status
  - key: id
  - key: email
  toast: 상태를 변경했습니다.
  toastOptions:
    type: success
    # success, error, warning, info
    position: top-right
    # top-right, top-center, top-left, bottom-right, bottom-center, bottom-left
    duration: 3000

- type: query
  resource: mysql.qa
  sqlType: insert
  sql: >
    INSERT INTO stock_wine
    SET code = :code
  params:
    - key: code
  confirm: false
  toast: |
    완료 
    <br />
    <p>affectedRows: {{affectedRows}}</p>
    <p>insertId: <a href="#{{insertId}}">{{insertId}}</a></p>

- type: http
  axios:
    method: GET
    url: https://testapi.com/v1/33iac2d
  rowsPath: rows

- type: http
  axios:
    method: POST
    url: https://testapi.com/v1/33iac2d
    data:
      'user_id': user-{{id}}
      'v': "{{API_VERSION}}" 
  params:
  - key: id
  - key: API_VERSION
    valueFromEnv: true

- type: http
  name: http 샘플
  axios:
    method: POST
    url: https://testapi.com/v1/33iac2d
    data:
      query: >
        {
          getUser(id: "test") {
            id
            name
            email
          }
        }

- type: markdown
  content: >
    write something

blocks:
- type: top # left, center, right, bottom
  title: title
  subtitle: subtitle
  blocks:
  - type: markdown
  - type: query

pages:
- path: company-layouts
  blocks:
  - 
    type: top
    title: title
    blocks:
      - type: markdown
        content: >
          > TOP
  - 
    type: left
    title: title
    subtitle: subtitle
    blocks:
      - type: markdown
        content: >
          > LEFT
  - 
    type: center
    style:
      width: 50%
      height: 80vh
      maxHeight: calc(100vh - 300px)
      overflow: scroll
    blocks:
      - type: markdown
        content: >
          > CENTER
      - type: query
        title: 내역은 최근 30일
        subtitle: 내역은 최근 30일
        description: 영수증 목록
        resource: mysql.qa
        sql: SELECT * FROM test_10k LIMIT 300
        sqlType: select
  - 
    type: right
    blocks:
      - type: markdown
        content: >
          > RIGHT
  - 
    type: bottom
    blocks:
      - type: markdown
        content: >
          > BOTTOM

blocks:
- type: header # 사이트 이동 경로(breadcrumb) 표시 영역
  items:
  - path: company
    label: 업체목록
    icon: home
  - label: 업체상세

blocks:
- type: tab
  tabOptions:
    type: button # 버튼형 탭
    # type: button full # 전체폭 버튼형 탭
    # type: full # 전체폭 탭
    # type: plain
    # keep: true
    autoload: 1
    tabs:
    - name: 주문
      blocks:
    - name: 결제
      blocks:

blocks:
  - type: toggle
    name: toggle sample
    icon: tree
    class: text-lg p-2 shadow rounded text-green-700
    toggledClass: font-medium text-green-700 bg-green-600/10
    # toggled: true
    blocks:
      - type: query

pages:
- path: iframe-sample
  blocks:
  - type: iframe
    src: https://www.selectfromuser.com/
    style:
      width: 50%
      minWidth: 550px
      height: 80vh

- type: query
  resource: mysql.qa
  sql: SELECT id, name, created_at FROM customers LIMIT 5
  columns:
    id:
      hidden: false
  viewModal: 
    mode: side
    useColumn: name
    blocks:
      - type: comment
        path: customers/{{id}}
        params:
          - key: id
            valueFromRow: true

blocks:
  - type: userProperty

menus:
- path: pages/LiyQhD
  name: 사용자 속성 설정
pages:
- path: pages/LiyQhD
  containerStyle: |
    width: 800px
  # class: container
  title: 상점 권한 관리
  blocks:

  - type: markdown
    content: |
      - 파트너 권한
  
  - type: userProperty

    roles:
      edit: 
        - 계정관리
    
    properties:
      shopCode:
        type: string
        placeholder: 상점코드
        dropdown:
          # - A
          # - B
          A: 타입 A
          B: 타입 B
      shopId:
        type: string
        label: 상점 ID
        placeholder: 상점ID 8자리
        description: 상점ID를 입력해주세요.
      A:
        type: string
      B:
        type: string
        # required: true

- type: query
  resource: mysql
  sqlType: insert
  sql: >
    INSERT INTO products
    SET created_at = NOW()
      , name = :name
  params:
    - key: name
      label: 상품명
  reloadAfterSubmit: true

- type: query
  resource: mysql
  sqlType: insert
  sql: >
    INSERT INTO properties
    SET created_at = NOW()
      , name = :name
  params:
    - key: name
      label: 자산명
  resetAfterSubmit: true

- type: query
  name: 추가
  resource: mysql.qa
  sqlType: insert
  sql: >
    INSERT INTO FaqContent
    SET name = :name,
        type2 = :type2,
        created_at = NOW()
  redirectAfterSubmit: "/faq-contents"
  # redirectAfterSubmit: |
  #   /faq-contents#{"modal":{"id":{{insertId}},"$name":"view","p":"pages.142.blocks.0"},"tableSelectedRows":[]}

modals:
  - path: modal1-:id
    header: false
    height: 400px
    blocks:
      - type: http
        name: 포스트 업데이트
        axios:
          method: POST
          url: https://jsonplaceholder.typicode.com/posts
        closeAfterSubmit: true  
        params:
        - key: published_at

- type: query
  resource: mysql.qa
  sqlType: select
  sql: >
    SELECT id, name FROM wine_stock
    WHERE name LIKE CONCAT('%', :category ,'%')
  autosubmit: true
  params:
    - key: category
      dropdown:
        - 블랑
        - 트라피체

pages:
- path: select/UserTemplateLog
  blocks:
  - type: query
    resource: selectCloud
    containerClass: container mx-auto
    sqlType: select
    sql: ...

blocks:
  - type: query
    id: query1
    resource: mysql.qa
    sqlType: select
    sql: >
      SELECT * FROM properties3 WHERE id = :id LIMIT 3
    params:
      - key: id
        value: 1
    showRefresh: true
    responseFn: |
      // query2.trigger() // 이 내용 새로고침시 query2도 새로고침

  - type: query
    id: query2
    resource: mysql.qa
    sqlType: select
    sql: >
      select NOW()
    showRefresh: true
    params:
      - key: id2
        value: 2

pages:
- path: show-download-false
  blocks:
  - type: query
    resource: mysql.qa
    sqlType: select
    sql: >
      SELECT *
      FROM test
      LIMIT 10
    showDownload: false

pages:
- path: show-download-csv
  blocks:
  - type: query
    resource: mysql.qa
    sqlType: select
    sql: >
      SELECT *
      FROM test
      LIMIT 10
    showDownload: csv

blocks:
  - 
    type: query
    resource: mysql.qa
    sqlType: select
    sql: >
      SELECT * FROM test_10k
      WHERE id BETWEEN :from AND :to 
      LIMIT 100000
    
    # type: http
    # axios:
    #   url: https://api.selectfromuser.com/sample-api/products
    #   method: GET
    # rowsPath: rows

    params:
      - key: from
        value: 1
      - key: to
        value: 5000
    submitButton: 
      label: 다운로드
    autoload: false
    showDownload: csv xlsx
    downloadAfterSubmit: true

blocks:
- type: query
  resource: mysql.qa
  sqlType: insert
  sql: >
    INSERT INTO test SET name = :name, created_at = NOW()
  params:
  - key: name
  # log: true
  log: 데이터추가 name={{name}}

- type: right
  blocks:
    - type: http
      axios:
        url: https://httpbin.selectfromuser.com/anything
        method: POST
      log:
        name: 수정_와인목록_API
        prompt: true
        # promptComments:
        #   - 고객요청
        #   - 파기
      params: 
        - key: name
          value: HELLO  
- type: left
  blocks:
  - type: query
    resource: mysql.qa
    sqlType: insert
    sql: SELECT 1
    log:
      name: 수정_와인목록
      prompt: true
      promptComments:
        - 고객요청
        - 파기
    params: 
      - key: name
        value: HELLO

- type: http
  axios:
    url: https://httpbin.selectfromuser.com/anything
    method: POST
  roles:
    edit: 
      - email::testsupport@selectfromuser.com

- type: query
  ...
  paginationOptions:
    enabled: true
    perPage: 10

paginationOptions:
  enabled: true
  jumpPage: true

paginationOptions:
  enabled: true
  position: top

- type: query
  ...
  searchOptions:
    enabled: true

searchOptions:
  enabled: true
  trigger: enter

searchOptions:
  enabled: true
  placeholder: '입력한 검색어로 찾습니다.'

searchOptions:
  enabled: true
  ignoreCase: false

searchOptions:
  enabled: true
  ignoreWhitespace: false

sql: SELECT * FROM test_10k
columns:
  name:
    filterOptions:
      enabled: true
      placeholder: 이름 검색

- type: query 
	...
  tableOptions:
    fixed: true
    height: 300px
    # height: 80vh
    condensed: true
    bordered: false
    striped: true
    small: true
    sortable: false
    # hidden: true
    thClass: text-center
    tdClass: text-center
    # cellWidth: 100px

tableOptions:
  cell: true
columns:
  inflow:
    updateOptions:
      type: query
      resource: mysql.qa
      sql: UPDATE wine_stock SET inflow = :value WHERE id = :id
      toast: 저장

blocks:
- type: query 
  resource: mysql
  sqlType: select
  sql: >
    ...
  sortOptions:
    enabled: true
    initialSortBy:
      field: Ratio # 필드 이름
      type: desc # desc, asc

blocks:
- type: query 
  resource: mysql
  sqlType: select
  sql: >
    ...
  multipleColumns: true   
  sortOptions:
    enabled: true
    initialSortBy:
      - field: Ratio
        type: desc
      - field: ClickCount
        type: desc

- type: query
  ...
  columnOptions:
  - field: id
  - field: name
    label: 이름
  - field: json
    format: json

columnOptionsAppend: true
columnOptions:
- field: name
  label: 이름

- type: query
  ...
  columns:
    id:
    name:
      label: 이름
    rank:
      label: 랭킹
      type: number
    created_at:

- type: query
  ...
  params:
  - key: id
    label: 아이디(ID)

blocks:
  - type: query
    resource: mysql.qa
    sqlType: select
    sqlOptions:
      # name, address, type이 지정되어 있고 type이 ALL이 아닌 경우
      - condition: name && address && type && type != 'ALL'
        bind: |
          {
            name: '%' + name + '%',
            address: '%' + address + '%',
            type: type,
          }
        sql: >
          SELECT * FROM properties
          WHERE name LIKE :name
            AND address LIKE :address
            AND `type` = :type
          ORDER BY name
        name: 특정 숙소 검색 (이름, 주소, 타입)

      # type이 입력되어 있고 type이 ALL이 아닌 경우
      - condition: type && type != 'ALL'
        sql: >
          SELECT * FROM properties
          WHERE `type` = :type
          ORDER BY `type`, id DESC
        name: 전체 숙소 검색 (타입별) 이름순 정렬

      # name, address만 입력된 경우
      - condition: name && address
        bind: |
          {
            name: '%' + name + '%',
            address: '%' + address + '%',
          }
        sql: >
          SELECT * FROM properties
          WHERE name LIKE :name
             AND address LIKE :address
          ORDER BY name
        name: 전체 숙소 검색 (이름, 주소 포함)

      # 기본 쿼리: 위의 모든 조건이 아닌 경우 (else)
      - condition: true
        sql: >
          SELECT * FROM properties
          ORDER BY updated_at DESC
          LIMIT 10
        name: 최근 업데이트순 정렬
    params:
      - key: type
        label: 타입 전체조회
        group: a
        radioButtonGroup: true
        radio:
          - HOTEL
          - RESORT
          - ALL
      - key: name
        label: "포함검색 (숙소이름)"
        group: b
        help: "'호텔' 입력"
      - key: address
        label: 주소
        group: b
        help: "'서초' 입력"
    resetButton: true

blocks:
- type: query
  ...
  tabOptions:
    autoload: 1
    tabs:
    - name: 주문
      blocks:
    - name: 결제
      blocks:

blocks:
- type: query
  name: 상품 카테고리 비율
  resource: mysql.qa
  sqlType: select
  sql: >
    SELECT `type`, COUNT(id) AS count
    FROM products
    WHERE `type` IS NOT NULL
    GROUP BY `type`
  chartOptions:
    type: bar # line, doughnut, polarArea
    x: type
    y: count
  showButtonWithResult: true