@baseUrl = https://devcpone.aplikasi.web.id/one-api/summarymcu
@contentType = application/json

### ============================================================
### LIST CORPORATE 
### ============================================================

POST {{baseUrl}}/sqlgenerator/list_mcu_corporate
Content-Type: application/json

{
  "db_name": "cpone_corporate"
}


### ============================================================
### LIST PASIEN
### ============================================================

### List Pasien MCU by Kelainan
# Mengelompokkan pasien berdasarkan kelainan dari tabel kelainan_details
# dan menghitung total pasien untuk setiap kelainan.
### LIST PASIEN MCU
POST {{baseUrl}}/sqlgenerator/list_pasien_mcu
Content-Type: application/json

{
  
}

###
POST {{baseUrl}}/sqlgenerator/get_count_kelainan
Content-Type: application/json

{
  "Mgm_McuID": 151
}



###
POST {{baseUrl}}/sqlgenerator/total_pasien_mcu
Content-Type: application/json

{}

###
{{baseUrl}}/sqlgenerator/save_kelainan_selection
Content-Type: {{contentType}}

{
  "mgm_mcu_id": 151,
  "selected_kelainan": [
    { "id": 80, "name": "Peningkatan profil lemak" },
    { "id": 133, "name": "Peningkatan fungsi hati" },
    { "id": 33, "name": "Karang Gigi" },
    { "id": 214, "name": "Miopia O" },
    { "id": 180, "name": "Presbiopia ODS" },
    { "id": 60, "name": "Leukositosis" },
    { "id": 4, "name": "Obesitas tipe 2" },
    { "id": 2, "name": "Overweight" },
    { "id": 134, "name": "Gangguan fungsi hati" },
    { "id": 227, "name": "Hipertensi stage 1" }
  ]
}

### ============================================================
### DATABASE DUMP
### ============================================================

### ============================================================
### DATABASE TRUNCATE
### ============================================================

### Truncate tabel-tabel corporate
POST {{baseUrl}}/sqlgenerator/truncate_corporate_tables
Content-Type: {{contentType}}

{
  "confirm_truncate": true
}

### Enkripsi dan unduh database sebagai file .dat
GET {{baseUrl}}/sqlgenerator/download
Content-Type: application/json

{
  "db_name": "cpone_corporate",
  "Mgm_McuID": 151
}

##
### Tampilkan komponen kunci enkripsi
POST {{baseUrl}}/sqlgenerator/show_key
Content-Type: application/json

{
  "Mgm_McuID": 151
}

####
POST {{baseUrl}}/sqlgenerator/create_encrypt_key
Content-Type: application/json

{
  "Mgm_McuID": 151
}

####
POST {{baseUrl}}/sqlgenerator/get_active_encrypt_key
Content-Type: application/json

{
  "Mgm_McuID": 151
}