#!/usr/bin/env bash
set -euo pipefail
TOKEN="eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJNX1VzZXJJRCI6IjIiLCJNX1VzZXJFbWFpbCI6Impva29AZ21haWwuY29tIiwiTV9Vc2VyVXNlcm5hbWUiOiJqb2tvQGdtYWlsLmNvbSIsIk1fVXNlckdyb3VwRGFzaGJvYXJkIjoib25lLXVpXC90ZXN0XC92dWV4XC9vbmUtbWQtdXNlcmdyb3VwLXVzZXItdjVcLyIsIk1fVXNlckRlZmF1bHRUX1NhbXBsZVN0YXRpb25JRCI6IjEiLCJNX1N0YWZmTmFtZSI6IkFkbWluIENQT05FIiwiaXNfY291cmllciI6Ik4iLCJNX0JyYW5jaElEIjoiMTAiLCJNX0JyYW5jaE5hbWUiOiJMYWJvcmF0b3JpdW0gTWFrYXNzYXIiLCJ0aW1lX2F1dG9sb2dvdXQiOiIxNSIsImlwIjoiMTI4LjE5OS44Ni43IiwiYWdlbnQiOiJHby1odHRwLWNsaWVudFwvMS4xIiwidmVyc2lvbiI6InYyIiwibGFzdC1sb2dpbiI6IjIwMjYtMDUtMDYgMTY6MDA6MzYifQ.YoDFYB-uayRtGSqGeapbo9EbvtHx_RcvNLlXDNwVk4s"
COOKIE="cpone_session=ZmFqcmk.4VydTLnAE5nMiudJXBPrlz1MqzQbA38R6JGiawYu5zI; cpone_project_mcu_id=1583; token=${TOKEN}"
ORDER_IDS=$(ssh -o BatchMode=yes one@devcpone.aplikasi.web.id "mysql -N -D cpone -e \"SELECT DISTINCT pp.Mcu_PreregisterPatientsT_OrderHeaderID FROM mcu_preregister_patients pp JOIN mcu_preregister_date pd ON pd.Mcu_PreregisterDateMcu_PreregisterPatientsID=pp.Mcu_PreregisterPatientsID AND pd.Mcu_PreregisterDateIsActive='Y' JOIN t_orderheader oh ON oh.T_OrderHeaderID=pp.Mcu_PreregisterPatientsT_OrderHeaderID AND oh.T_OrderHeaderIsActive='Y' WHERE pp.Mcu_PreregisterPatientsMgm_McuID=1583 AND pd.Mcu_PreregisterDateCheckinSchedule='2026-05-05' AND pp.Mcu_PreregisterPatientsIsActive='Y' ORDER BY pp.Mcu_PreregisterPatientsT_OrderHeaderID;\"")

ok=0
val_fail=0
gen_fail=0
sync_fail=0
total=0

for OID in $ORDER_IDS; do
  total=$((total+1))
  RESP=$(curl -sS "https://devcpone.aplikasi.web.id/one-api/mockup/mcuoffline/Resumeindividucponev7/generateFitnessCategory" \
    -H "Accept: application/json, text/plain, */*" \
    -H "Content-Type: application/json;charset=UTF-8" \
    -H "Cookie: ${COOKIE}" \
    --data-raw "{\"token\":\"${TOKEN}\",\"orderid\":\"${OID}\",\"kesimpulan\":\"\",\"rekomendasi\":\"\",\"saran\":\"\",\"conclusion\":\"\",\"recomendation\":\"\",\"advice\":\"\"}")

  if echo "$RESP" | grep -q '"status":"OK"'; then
    if ssh -o BatchMode=yes one@devcpone.aplikasi.web.id "mysql -N -D cpone -e \"CALL cpone.sp_sync_kelainan_details_by_orderheader(${OID});\"" >/dev/null 2>&1; then
      ok=$((ok+1))
    else
      sync_fail=$((sync_fail+1))
    fi
  elif echo "$RESP" | grep -q 'belum di validasi'; then
    val_fail=$((val_fail+1))
  else
    gen_fail=$((gen_fail+1))
  fi

done

echo "RESULT total=${total} ok=${ok} val_fail=${val_fail} gen_fail=${gen_fail} sync_fail=${sync_fail}"