sindhu/belajar
1
0
Code Issues 51 Packages Projects Wiki

[WA Bisnis - Rest API] #44

New Issue
Open
opened 2024-03-06 16:27:54 +07:00 by sindhu · 0 comments
sindhu commented 2024-03-06 16:27:54 +07:00
Owner
Copy Link

1. Listing table

Note

  • status
    jika Y nanti di UI nya Hijau, jika masih N abu-abu

  • Result_CounterStatus atau status_action
    jika Y nanti di UI nya Hijau, jika masih N abu-abu

Tgl. Registrasi -> T_OrderHeaderDate
Tgl. Janji Hasil -> T_OrderPromiseDateTime
Tgl. Serah Terima Hasil -> Result_ProcessToOfficeSendTime

K = Kirim Result_CounterIsSend
T = Terima Result_CounterIsReceive
B = Baca Result_CounterIsRead

status_name isinya jika Result_CounterStatus :
N = Belum kirim
Y = Proses Pengiriman
S = Terkirim
E = Error

getStatus = Result_CounterStatus
search = no reg / nama
getDataType = T_OrderHeaderDate / T_OrderPromiseDateTime / Result_ProcessToOfficeSendTime
tglFilter = tgl yg dipilih

kalo by tgl. registrasi from nya t_orderheader join ke result_counter
kalo by tgl. janji hasil from nya t_orderpromise join ke result_counter
kalo by tgl. serahkan hasil from nya result_processtooffice join ke result_counter

date nya langsung dari join

Kasus filter T_OrderHeaderDate / tgl registrasi

getStatus == 'A' berarti semua

{
  "getDataType":"T_OrderHeaderDate",
  "getStatus":"A",
  "search":"",
  "tglFilter":"2024-02-26",
  "current_page":"1"
}

hasilnya

{
  "status": "OK",
  "data": {
    "total": 3,
    "total_filter": 10,
    "records": [
      {
        "Result_ProcessToOfficeID": "201925",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 11:50:01",
        "tanggal_janji_hasil": "2024-02-27 12:00:00",
        "tanggal_serahkan": "2024-02-26 12:00:23",
        "no_reg": "05000034LA",
        "nama": "MR.HAYASHI SHIGEKI",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pengirim | -",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132116&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201923",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 11:50:01",
        "tanggal_janji_hasil": "2024-02-27 12:00:00",
        "tanggal_serahkan": "2024-02-26 12:00:23",
        "no_reg": "05000034LA",
        "nama": "MR.HAYASHI SHIGEKI",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pasien | 082113702602",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132116&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201932",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 12:00:40",
        "tanggal_janji_hasil": "2024-02-27 12:00:00",
        "tanggal_serahkan": "2024-02-26 12:12:51",
        "no_reg": "05000035LA",
        "nama": "KASMONO SUTOTO",
        "dokter": "dr. ABDILLAH S ALHADAD",
        "tujuan": "Whatsapp Pengirim | -",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132117&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201930",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 12:00:40",
        "tanggal_janji_hasil": "2024-02-27 12:00:00",
        "tanggal_serahkan": "2024-02-26 12:12:51",
        "no_reg": "05000035LA",
        "nama": "KASMONO SUTOTO",
        "dokter": "dr. ABDILLAH S ALHADAD",
        "tujuan": "Whatsapp Pasien | 087823628917",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132117&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201939",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 13:10:09",
        "tanggal_janji_hasil": "2024-02-27 12:00:00",
        "tanggal_serahkan": "2024-02-26 13:23:36",
        "no_reg": "05000036LA",
        "nama": "KOESDIONO",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pengirim | -",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132118&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201937",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 13:10:09",
        "tanggal_janji_hasil": "2024-02-27 12:00:00",
        "tanggal_serahkan": "2024-02-26 13:23:36",
        "no_reg": "05000036LA",
        "nama": "KOESDIONO",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pasien | 086876767832",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132118&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201948",
        "Result_CounterGroup_ResultID": "4",
        "tanggal_registrasi": "2024-02-26 13:15:37",
        "tanggal_janji_hasil": "2024-02-28 17:00:00",
        "tanggal_serahkan": "2024-02-26 13:42:13",
        "no_reg": "05000037LA",
        "nama": "SJOFIAN AZHAR",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pengirim | -",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "Rontgen",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/run?__report=report%2Fone%2Flab%2Frpt_hasil_so_xray_email.rptdesign&__format=pdf&username=adminsas&PID=132119&PLang=1&tm=1708929763659",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201947",
        "Result_CounterGroup_ResultID": "4",
        "tanggal_registrasi": "2024-02-26 13:15:37",
        "tanggal_janji_hasil": "2024-02-28 17:00:00",
        "tanggal_serahkan": "2024-02-26 13:42:13",
        "no_reg": "05000037LA",
        "nama": "SJOFIAN AZHAR",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pasien | 08757897645",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "Rontgen",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/run?__report=report%2Fone%2Flab%2Frpt_hasil_so_xray_email.rptdesign&__format=pdf&username=adminsas&PID=132119&PLang=1&tm=1708929763659",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201945",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 13:15:37",
        "tanggal_janji_hasil": "2024-02-28 17:00:00",
        "tanggal_serahkan": "2024-02-26 13:35:54",
        "no_reg": "05000037LA",
        "nama": "SJOFIAN AZHAR",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pengirim | -",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132119&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201944",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 13:15:37",
        "tanggal_janji_hasil": "2024-02-28 17:00:00",
        "tanggal_serahkan": "2024-02-26 13:35:54",
        "no_reg": "05000037LA",
        "nama": "SJOFIAN AZHAR",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pasien | 08757897645",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132119&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      }
    ],
    "sql": "SELECT\r\n                rpo.Result_ProcessToOfficeID,\r\n                rc.Result_CounterGroup_ResultID,\r\n                IFNULL(th.T_OrderHeaderDate, '-') AS tanggal_registrasi,\r\n                IFNULL(tp.T_OrderPromiseDateTime, '-') AS tanggal_janji_hasil,\r\n                IFNULL(rpo.Result_ProcessToOfficeSendTime, '-') AS tanggal_serahkan,\r\n                th.T_OrderHeaderLabNumber AS no_reg,\r\n                mp.M_PatientName AS nama,\r\n                fn_get_doctor_fullname(th.T_OrderHeaderSenderM_DoctorID) AS dokter,\r\n                CONCAT(\r\n                    md.M_DeliveryName,\r\n                    ' | ',\r\n                    rc.Result_CounterDestination\r\n                ) AS tujuan,\r\n                rc.Result_CounterIsSend AS status_k,\r\n                rc.Result_CounterIsReceive AS status_t,\r\n                rc.Result_CounterIsRead AS status_b,\r\n                fn_wa_get_groupresult(rc.Result_CounterGroup_ResultID) AS group_result,\r\n                rc.Result_CounterStatus as Result_CounterStatus,\r\n                CASE\r\n                    rc.Result_CounterStatus\r\n                    WHEN 'N' THEN 'Belum kirim'\r\n                    WHEN 'Y' THEN 'Proses Pengiriman'\r\n                    WHEN 'S' THEN 'Terkirim'\r\n                    WHEN 'E' THEN 'Error'\r\n                    ELSE 'Unknown'\r\n                END AS status_name,\r\n                Result_CounterUrlReport,\r\n                Result_CounterIsImage,\r\n                Result_CounterUrlImage,\r\n                Result_CounterCounter\r\n                FROM\r\n                    t_orderheader th\r\n                    JOIN result_counter rc \r\n                        ON th.T_OrderHeaderID = rc.Result_CounterT_OrderHeaderID\r\n                        AND th.T_OrderHeaderIsActive = 'Y'\r\n                        AND rc.Result_CounterIsActive = 'Y'\r\n                        \r\n                         AND th.T_OrderHeaderDate LIKE '%2024-02-26%'\r\n                    JOIN m_patient mp \r\n                        ON th.T_OrderHeaderM_PatientID = mp.M_PatientID\r\n                        AND mp.M_PatientIsActive = 'Y'\r\n                    JOIN m_delivery md \r\n                        ON rc.Result_CounterM_DeliveryID = md.M_DeliveryID\r\n                        AND md.M_DeliveryIsActive = 'Y'\r\n                    left JOIN group_result gr \r\n                        ON rc.Result_CounterGroup_ResultID = gr.Group_ResultID\r\n                        AND gr.Group_ResultIsActive = 'Y'\r\n                    JOIN (\r\n                        SELECT\r\n                            T_OrderPromiseT_OrderHeaderID,\r\n                            MAX(T_OrderPromiseDateTime) AS T_OrderPromiseDateTime\r\n                        FROM\r\n                            t_orderpromise\r\n                        WHERE\r\n                            T_OrderPromiseIsActive = 'Y'\r\n                        GROUP BY\r\n                            T_OrderPromiseT_OrderHeaderID\r\n                    ) AS tp ON th.T_OrderHeaderID = tp.T_OrderPromiseT_OrderHeaderID\r\n                    JOIN t_orderpromise tp2 \r\n                        ON th.T_OrderHeaderID = tp2.T_OrderPromiseT_OrderHeaderID\r\n                        AND tp.T_OrderPromiseDateTime = tp2.T_OrderPromiseDateTime\r\n                    JOIN result_processtooffice rpo \r\n                        ON th.T_OrderHeaderID = rpo.Result_ProcessToOfficeT_OrderHeaderID\r\n                        AND rpo.Result_ProcessToOfficeIsActive = 'Y'\r\n                        AND rpo.Result_ProcessToOfficeGroup_ResultID = rc.Result_CounterGroup_ResultID\r\n                        AND rpo.Result_ProcessToOfficeT_OrderDeliveryM_DeliveryID = md.M_DeliveryID\r\n                        AND rpo.Result_ProcessToOfficeStatus = 'S'\r\n                        AND (\r\n                    th.T_OrderHeaderLabNumber LIKE \"%%\"\r\n                    OR mp.M_PatientName LIKE \"%%\"\r\n                ) \r\n                    group by\r\n                        th.T_OrderHeaderID,\r\n                        md.M_DeliveryID,\r\n                        rc.Result_CounterGroup_ResultID\r\n                        ORDER BY Result_CounterID DESC limit 10 offset 0"
  }
}

Kasus filter T_OrderPromiseDateTime / tgl janji hasil

{
  "getDataType":"T_OrderPromiseDateTime",
  "getStatus":"Y",
  "search":"",
  "tglFilter":"2024-02-26",
  "current_page":"1"
}

hasilnya

{
  "status": "OK",
  "data": {
    "total": 2,
    "total_filter": 10,
    "records": [
      {
        "Result_ProcessToOfficeID": "201925",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 11:50:01",
        "tanggal_janji_hasil": "2024-02-26 15:50:01",
        "tanggal_serahkan": "2024-02-26 12:00:23",
        "no_reg": "05000034LA",
        "nama": "MR.HAYASHI SHIGEKI",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pengirim | -",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132116&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201923",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 11:50:01",
        "tanggal_janji_hasil": "2024-02-26 15:50:01",
        "tanggal_serahkan": "2024-02-26 12:00:23",
        "no_reg": "05000034LA",
        "nama": "MR.HAYASHI SHIGEKI",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pasien | 082113702602",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132116&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201932",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 12:00:40",
        "tanggal_janji_hasil": "2024-02-26 16:00:40",
        "tanggal_serahkan": "2024-02-26 12:12:51",
        "no_reg": "05000035LA",
        "nama": "KASMONO SUTOTO",
        "dokter": "dr. ABDILLAH S ALHADAD",
        "tujuan": "Whatsapp Pengirim | -",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132117&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201930",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 12:00:40",
        "tanggal_janji_hasil": "2024-02-26 16:00:40",
        "tanggal_serahkan": "2024-02-26 12:12:51",
        "no_reg": "05000035LA",
        "nama": "KASMONO SUTOTO",
        "dokter": "dr. ABDILLAH S ALHADAD",
        "tujuan": "Whatsapp Pasien | 087823628917",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132117&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201939",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 13:10:09",
        "tanggal_janji_hasil": "2024-02-26 17:10:09",
        "tanggal_serahkan": "2024-02-26 13:23:36",
        "no_reg": "05000036LA",
        "nama": "KOESDIONO",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pengirim | -",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132118&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201937",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 13:10:09",
        "tanggal_janji_hasil": "2024-02-26 17:10:09",
        "tanggal_serahkan": "2024-02-26 13:23:36",
        "no_reg": "05000036LA",
        "nama": "KOESDIONO",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pasien | 086876767832",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132118&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201948",
        "Result_CounterGroup_ResultID": "4",
        "tanggal_registrasi": "2024-02-26 13:15:37",
        "tanggal_janji_hasil": "2024-02-26 20:30:00",
        "tanggal_serahkan": "2024-02-26 13:42:13",
        "no_reg": "05000037LA",
        "nama": "SJOFIAN AZHAR",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pengirim | -",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "Rontgen",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/run?__report=report%2Fone%2Flab%2Frpt_hasil_so_xray_email.rptdesign&__format=pdf&username=adminsas&PID=132119&PLang=1&tm=1708929763659",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201947",
        "Result_CounterGroup_ResultID": "4",
        "tanggal_registrasi": "2024-02-26 13:15:37",
        "tanggal_janji_hasil": "2024-02-26 20:30:00",
        "tanggal_serahkan": "2024-02-26 13:42:13",
        "no_reg": "05000037LA",
        "nama": "SJOFIAN AZHAR",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pasien | 08757897645",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "Rontgen",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/run?__report=report%2Fone%2Flab%2Frpt_hasil_so_xray_email.rptdesign&__format=pdf&username=adminsas&PID=132119&PLang=1&tm=1708929763659",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201945",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 13:15:37",
        "tanggal_janji_hasil": "2024-02-26 20:30:00",
        "tanggal_serahkan": "2024-02-26 13:35:54",
        "no_reg": "05000037LA",
        "nama": "SJOFIAN AZHAR",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pengirim | -",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132119&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201944",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 13:15:37",
        "tanggal_janji_hasil": "2024-02-26 20:30:00",
        "tanggal_serahkan": "2024-02-26 13:35:54",
        "no_reg": "05000037LA",
        "nama": "SJOFIAN AZHAR",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pasien | 08757897645",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132119&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      }
    ],
    "sql": "SELECT\r\n                        rpo.Result_ProcessToOfficeID,\r\n                        rc.Result_CounterGroup_ResultID,\r\n                        IFNULL(th.T_OrderHeaderDate, '-') AS tanggal_registrasi,\r\n                        IFNULL(tp.T_OrderPromiseDateTime, '-') AS tanggal_janji_hasil,\r\n                        IFNULL(rpo.Result_ProcessToOfficeSendTime, '-') AS tanggal_serahkan,\r\n                        th.T_OrderHeaderLabNumber AS no_reg,\r\n                        mp.M_PatientName AS nama,\r\n                        fn_get_doctor_fullname(th.T_OrderHeaderSenderM_DoctorID) AS dokter,\r\n                        CONCAT(\r\n                            md.M_DeliveryName,\r\n                            ' | ',\r\n                            rc.Result_CounterDestination\r\n                        ) AS tujuan,\r\n                        rc.Result_CounterIsSend AS status_k,\r\n                        rc.Result_CounterIsReceive AS status_t,\r\n                        rc.Result_CounterIsRead AS status_b,\r\n                        fn_wa_get_groupresult(rc.Result_CounterGroup_ResultID) AS group_result,\r\n                        rc.Result_CounterStatus as Result_CounterStatus,\r\n                        CASE\r\n                            rc.Result_CounterStatus\r\n                            WHEN 'N' THEN 'Belum kirim'\r\n                            WHEN 'Y' THEN 'Proses Pengiriman'\r\n                            WHEN 'S' THEN 'Terkirim'\r\n                            WHEN 'E' THEN 'Error'\r\n                            ELSE 'Unknown'\r\n                        END AS status_name,\r\n                        rc.Result_CounterUrlReport,\r\n                        rc.Result_CounterIsImage,\r\n                        rc.Result_CounterUrlImage,\r\n                        rc.Result_CounterCounter\r\n                    FROM\r\n                        t_orderpromise tp\r\n                        JOIN result_counter rc \r\n                        ON tp.T_OrderPromiseT_OrderHeaderID = rc.Result_CounterT_OrderHeaderID\r\n                         AND tp.T_OrderPromiseDateTime LIKE '%2024-02-26%'\r\n                        JOIN t_orderheader th ON rc.Result_CounterT_OrderHeaderID = th.T_OrderHeaderID\r\n                        AND th.T_OrderHeaderIsActive = 'Y'\r\n                        JOIN m_patient mp ON th.T_OrderHeaderM_PatientID = mp.M_PatientID\r\n                        AND mp.M_PatientIsActive = 'Y'\r\n                        JOIN m_delivery md ON rc.Result_CounterM_DeliveryID = md.M_DeliveryID\r\n                        AND md.M_DeliveryIsActive = 'Y'\r\n                        left JOIN group_result gr ON rc.Result_CounterGroup_ResultID = gr.Group_ResultID\r\n                        AND gr.Group_ResultIsActive = 'Y'\r\n                        JOIN (\r\n                            SELECT\r\n                                T_OrderPromiseT_OrderHeaderID,\r\n                                MAX(T_OrderPromiseDateTime) AS T_OrderPromiseDateTime\r\n                            FROM\r\n                                t_orderpromise\r\n                            WHERE\r\n                                T_OrderPromiseIsActive = 'Y'\r\n                            GROUP BY\r\n                                T_OrderPromiseT_OrderHeaderID\r\n                        ) AS tp2 ON th.T_OrderHeaderID = tp2.T_OrderPromiseT_OrderHeaderID\r\n                        JOIN result_processtooffice rpo ON th.T_OrderHeaderID = rpo.Result_ProcessToOfficeT_OrderHeaderID\r\n                        AND rpo.Result_ProcessToOfficeIsActive = 'Y'\r\n                        AND rpo.Result_ProcessToOfficeGroup_ResultID = rc.Result_CounterGroup_ResultID\r\n                        AND rpo.Result_ProcessToOfficeT_OrderDeliveryM_DeliveryID = md.M_DeliveryID\r\n                        AND rpo.Result_ProcessToOfficeStatus = 'S'\r\n                         AND rc.Result_CounterStatus = 'N' \r\n                        AND (\r\n                    th.T_OrderHeaderLabNumber LIKE \"%%\"\r\n                    OR mp.M_PatientName LIKE \"%%\"\r\n                ) \r\n                    GROUP BY\r\n                        th.T_OrderHeaderID,\r\n                        md.M_DeliveryID,\r\n                        rc.Result_CounterGroup_ResultID\r\n                    ORDER BY Result_CounterID DESC limit 10 offset 0"
  }
}

Kasus filter Result_ProcessToOfficeSendTime / tgl serahkan

{
  "getDataType":"Result_ProcessToOfficeSendTime",
  "getStatus":"N",
  "search":"",
  "tglFilter":"2024-02-26",
  "current_page":"1"
}

hasilnya

{
  "status": "OK",
  "data": {
    "total": 2,
    "total_filter": 10,
    "records": [
      {
        "Result_ProcessToOfficeID": "201925",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 11:50:01",
        "tanggal_janji_hasil": "2024-02-27 12:00:00",
        "tanggal_serahkan": "2024-02-26 12:00:23",
        "no_reg": "05000034LA",
        "nama": "MR.HAYASHI SHIGEKI",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pengirim | -",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132116&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201923",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 11:50:01",
        "tanggal_janji_hasil": "2024-02-27 12:00:00",
        "tanggal_serahkan": "2024-02-26 12:00:23",
        "no_reg": "05000034LA",
        "nama": "MR.HAYASHI SHIGEKI",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pasien | 082113702602",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132116&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201925",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 12:00:40",
        "tanggal_janji_hasil": "2024-02-27 12:00:00",
        "tanggal_serahkan": "2024-02-26 12:00:23",
        "no_reg": "05000035LA",
        "nama": "KASMONO SUTOTO",
        "dokter": "dr. ABDILLAH S ALHADAD",
        "tujuan": "Whatsapp Pengirim | -",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132117&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201923",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 12:00:40",
        "tanggal_janji_hasil": "2024-02-27 12:00:00",
        "tanggal_serahkan": "2024-02-26 12:00:23",
        "no_reg": "05000035LA",
        "nama": "KASMONO SUTOTO",
        "dokter": "dr. ABDILLAH S ALHADAD",
        "tujuan": "Whatsapp Pasien | 087823628917",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132117&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201925",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 13:10:09",
        "tanggal_janji_hasil": "2024-02-27 12:00:00",
        "tanggal_serahkan": "2024-02-26 12:00:23",
        "no_reg": "05000036LA",
        "nama": "KOESDIONO",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pengirim | -",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132118&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201923",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 13:10:09",
        "tanggal_janji_hasil": "2024-02-27 12:00:00",
        "tanggal_serahkan": "2024-02-26 12:00:23",
        "no_reg": "05000036LA",
        "nama": "KOESDIONO",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pasien | 086876767832",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132118&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201948",
        "Result_CounterGroup_ResultID": "4",
        "tanggal_registrasi": "2024-02-26 13:15:37",
        "tanggal_janji_hasil": "2024-02-28 17:00:00",
        "tanggal_serahkan": "2024-02-26 13:42:13",
        "no_reg": "05000037LA",
        "nama": "SJOFIAN AZHAR",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pengirim | -",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "Rontgen",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/run?__report=report%2Fone%2Flab%2Frpt_hasil_so_xray_email.rptdesign&__format=pdf&username=adminsas&PID=132119&PLang=1&tm=1708929763659",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201947",
        "Result_CounterGroup_ResultID": "4",
        "tanggal_registrasi": "2024-02-26 13:15:37",
        "tanggal_janji_hasil": "2024-02-28 17:00:00",
        "tanggal_serahkan": "2024-02-26 13:42:13",
        "no_reg": "05000037LA",
        "nama": "SJOFIAN AZHAR",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pasien | 08757897645",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "Rontgen",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/run?__report=report%2Fone%2Flab%2Frpt_hasil_so_xray_email.rptdesign&__format=pdf&username=adminsas&PID=132119&PLang=1&tm=1708929763659",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201925",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 13:15:37",
        "tanggal_janji_hasil": "2024-02-28 17:00:00",
        "tanggal_serahkan": "2024-02-26 12:00:23",
        "no_reg": "05000037LA",
        "nama": "SJOFIAN AZHAR",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pengirim | -",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132119&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      },
      {
        "Result_ProcessToOfficeID": "201923",
        "Result_CounterGroup_ResultID": "1",
        "tanggal_registrasi": "2024-02-26 13:15:37",
        "tanggal_janji_hasil": "2024-02-28 17:00:00",
        "tanggal_serahkan": "2024-02-26 12:00:23",
        "no_reg": "05000037LA",
        "nama": "SJOFIAN AZHAR",
        "dokter": "dr. A B WARDOYO., Sp. PD",
        "tujuan": "Whatsapp Pasien | 08757897645",
        "status_k": "N",
        "status_t": "N",
        "status_b": "N",
        "group_result": "LAB",
        "Result_CounterStatus": "N",
        "status_name": "Belum kirim",
        "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132119&ts=20240307100649",
        "Result_CounterIsImage": "N",
        "Result_CounterUrlImage": "",
        "Result_CounterCounter": "1"
      }
    ],
    "sql": "SELECT\r\n                        rpo.Result_ProcessToOfficeID,\r\n                        rc.Result_CounterGroup_ResultID,\r\n                        IFNULL(th.T_OrderHeaderDate, '-') AS tanggal_registrasi,\r\n                        IFNULL(tp.T_OrderPromiseDateTime, '-') AS tanggal_janji_hasil,\r\n                        IFNULL(rpo.Result_ProcessToOfficeSendTime, '-') AS tanggal_serahkan,\r\n                        th.T_OrderHeaderLabNumber AS no_reg,\r\n                        mp.M_PatientName AS nama,\r\n                        fn_get_doctor_fullname(th.T_OrderHeaderSenderM_DoctorID) AS dokter,\r\n                        CONCAT(\r\n                            md.M_DeliveryName,\r\n                            ' | ',\r\n                            rc.Result_CounterDestination\r\n                        ) AS tujuan,\r\n                        rc.Result_CounterIsSend AS status_k,\r\n                        rc.Result_CounterIsReceive AS status_t,\r\n                        rc.Result_CounterIsRead AS status_b,\r\n                        fn_wa_get_groupresult(rc.Result_CounterGroup_ResultID) AS group_result,\r\n                        rc.Result_CounterStatus as Result_CounterStatus,\r\n                        CASE\r\n                            rc.Result_CounterStatus\r\n                            WHEN 'N' THEN 'Belum kirim'\r\n                            WHEN 'Y' THEN 'Proses Pengiriman'\r\n                            WHEN 'S' THEN 'Terkirim'\r\n                            WHEN 'E' THEN 'Error'\r\n                            ELSE 'Unknown'\r\n                        END AS status_name,\r\n                        rc.Result_CounterUrlReport,\r\n                        rc.Result_CounterIsImage,\r\n                        rc.Result_CounterUrlImage,\r\n                        rc.Result_CounterCounter\r\n                    FROM\r\n                        result_processtooffice rpo\r\n                        JOIN result_counter rc \r\n                        ON rpo.Result_ProcessToOfficeGroup_ResultID = rc.Result_CounterGroup_ResultID\r\n                        AND rpo.Result_ProcessToOfficeT_OrderDeliveryM_DeliveryID = rc.Result_CounterM_DeliveryID\r\n                         AND rpo.Result_ProcessToOfficeSendTime LIKE '%2024-02-26%'\r\n                         AND rc.Result_CounterStatus = 'N' \r\n                        JOIN t_orderheader th ON rc.Result_CounterT_OrderHeaderID = th.T_OrderHeaderID\r\n                        AND th.T_OrderHeaderIsActive = 'Y'\r\n                        JOIN m_patient mp ON th.T_OrderHeaderM_PatientID = mp.M_PatientID\r\n                        AND mp.M_PatientIsActive = 'Y'\r\n                        JOIN m_delivery md ON rc.Result_CounterM_DeliveryID = md.M_DeliveryID\r\n                        AND md.M_DeliveryIsActive = 'Y'\r\n                        left JOIN group_result gr ON rc.Result_CounterGroup_ResultID = gr.Group_ResultID\r\n                        AND gr.Group_ResultIsActive = 'Y'\r\n                        JOIN (\r\n                            SELECT\r\n                                T_OrderPromiseT_OrderHeaderID,\r\n                                MAX(T_OrderPromiseDateTime) AS T_OrderPromiseDateTime\r\n                            FROM\r\n                                t_orderpromise\r\n                            WHERE\r\n                                T_OrderPromiseIsActive = 'Y'\r\n                            GROUP BY\r\n                                T_OrderPromiseT_OrderHeaderID\r\n                        ) AS tp ON th.T_OrderHeaderID = tp.T_OrderPromiseT_OrderHeaderID\r\n                        JOIN t_orderpromise tp2 ON th.T_OrderHeaderID = tp2.T_OrderPromiseT_OrderHeaderID\r\n                        AND tp.T_OrderPromiseDateTime = tp2.T_OrderPromiseDateTime\r\n                    WHERE\r\n                        rpo.Result_ProcessToOfficeIsActive = 'Y'\r\n                        AND rpo.Result_ProcessToOfficeStatus = 'S'\r\n                        AND (\r\n                    th.T_OrderHeaderLabNumber LIKE \"%%\"\r\n                    OR mp.M_PatientName LIKE \"%%\"\r\n                ) \r\n                    GROUP BY\r\n                        th.T_OrderHeaderID,\r\n                        md.M_DeliveryID,\r\n                        rc.Result_CounterGroup_ResultID\r\n                    ORDER BY Result_CounterID DESC limit 10 offset 0"
  }
}
### 1. Listing table ### **Note** - status jika Y nanti di UI nya Hijau, jika masih N abu-abu - Result_CounterStatus atau status_action jika Y nanti di UI nya Hijau, jika masih N abu-abu Tgl. Registrasi -> T_OrderHeaderDate Tgl. Janji Hasil -> T_OrderPromiseDateTime Tgl. Serah Terima Hasil -> Result_ProcessToOfficeSendTime K = Kirim Result_CounterIsSend T = Terima Result_CounterIsReceive B = Baca Result_CounterIsRead status_name isinya jika Result_CounterStatus : N = Belum kirim Y = Proses Pengiriman S = Terkirim E = Error getStatus = Result_CounterStatus search = no reg / nama getDataType = T_OrderHeaderDate / T_OrderPromiseDateTime / Result_ProcessToOfficeSendTime tglFilter = tgl yg dipilih kalo by tgl. registrasi from nya t_orderheader join ke result_counter kalo by tgl. janji hasil from nya t_orderpromise join ke result_counter kalo by tgl. serahkan hasil from nya result_processtooffice join ke result_counter date nya langsung dari join **Kasus filter T_OrderHeaderDate / tgl registrasi** getStatus == 'A' berarti semua ```json { "getDataType":"T_OrderHeaderDate", "getStatus":"A", "search":"", "tglFilter":"2024-02-26", "current_page":"1" } ``` hasilnya ```json { "status": "OK", "data": { "total": 3, "total_filter": 10, "records": [ { "Result_ProcessToOfficeID": "201925", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 11:50:01", "tanggal_janji_hasil": "2024-02-27 12:00:00", "tanggal_serahkan": "2024-02-26 12:00:23", "no_reg": "05000034LA", "nama": "MR.HAYASHI SHIGEKI", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pengirim | -", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132116&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201923", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 11:50:01", "tanggal_janji_hasil": "2024-02-27 12:00:00", "tanggal_serahkan": "2024-02-26 12:00:23", "no_reg": "05000034LA", "nama": "MR.HAYASHI SHIGEKI", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pasien | 082113702602", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132116&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201932", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 12:00:40", "tanggal_janji_hasil": "2024-02-27 12:00:00", "tanggal_serahkan": "2024-02-26 12:12:51", "no_reg": "05000035LA", "nama": "KASMONO SUTOTO", "dokter": "dr. ABDILLAH S ALHADAD", "tujuan": "Whatsapp Pengirim | -", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132117&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201930", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 12:00:40", "tanggal_janji_hasil": "2024-02-27 12:00:00", "tanggal_serahkan": "2024-02-26 12:12:51", "no_reg": "05000035LA", "nama": "KASMONO SUTOTO", "dokter": "dr. ABDILLAH S ALHADAD", "tujuan": "Whatsapp Pasien | 087823628917", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132117&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201939", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 13:10:09", "tanggal_janji_hasil": "2024-02-27 12:00:00", "tanggal_serahkan": "2024-02-26 13:23:36", "no_reg": "05000036LA", "nama": "KOESDIONO", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pengirim | -", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132118&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201937", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 13:10:09", "tanggal_janji_hasil": "2024-02-27 12:00:00", "tanggal_serahkan": "2024-02-26 13:23:36", "no_reg": "05000036LA", "nama": "KOESDIONO", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pasien | 086876767832", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132118&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201948", "Result_CounterGroup_ResultID": "4", "tanggal_registrasi": "2024-02-26 13:15:37", "tanggal_janji_hasil": "2024-02-28 17:00:00", "tanggal_serahkan": "2024-02-26 13:42:13", "no_reg": "05000037LA", "nama": "SJOFIAN AZHAR", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pengirim | -", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "Rontgen", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/run?__report=report%2Fone%2Flab%2Frpt_hasil_so_xray_email.rptdesign&__format=pdf&username=adminsas&PID=132119&PLang=1&tm=1708929763659", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201947", "Result_CounterGroup_ResultID": "4", "tanggal_registrasi": "2024-02-26 13:15:37", "tanggal_janji_hasil": "2024-02-28 17:00:00", "tanggal_serahkan": "2024-02-26 13:42:13", "no_reg": "05000037LA", "nama": "SJOFIAN AZHAR", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pasien | 08757897645", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "Rontgen", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/run?__report=report%2Fone%2Flab%2Frpt_hasil_so_xray_email.rptdesign&__format=pdf&username=adminsas&PID=132119&PLang=1&tm=1708929763659", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201945", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 13:15:37", "tanggal_janji_hasil": "2024-02-28 17:00:00", "tanggal_serahkan": "2024-02-26 13:35:54", "no_reg": "05000037LA", "nama": "SJOFIAN AZHAR", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pengirim | -", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132119&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201944", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 13:15:37", "tanggal_janji_hasil": "2024-02-28 17:00:00", "tanggal_serahkan": "2024-02-26 13:35:54", "no_reg": "05000037LA", "nama": "SJOFIAN AZHAR", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pasien | 08757897645", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132119&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" } ], "sql": "SELECT\r\n rpo.Result_ProcessToOfficeID,\r\n rc.Result_CounterGroup_ResultID,\r\n IFNULL(th.T_OrderHeaderDate, '-') AS tanggal_registrasi,\r\n IFNULL(tp.T_OrderPromiseDateTime, '-') AS tanggal_janji_hasil,\r\n IFNULL(rpo.Result_ProcessToOfficeSendTime, '-') AS tanggal_serahkan,\r\n th.T_OrderHeaderLabNumber AS no_reg,\r\n mp.M_PatientName AS nama,\r\n fn_get_doctor_fullname(th.T_OrderHeaderSenderM_DoctorID) AS dokter,\r\n CONCAT(\r\n md.M_DeliveryName,\r\n ' | ',\r\n rc.Result_CounterDestination\r\n ) AS tujuan,\r\n rc.Result_CounterIsSend AS status_k,\r\n rc.Result_CounterIsReceive AS status_t,\r\n rc.Result_CounterIsRead AS status_b,\r\n fn_wa_get_groupresult(rc.Result_CounterGroup_ResultID) AS group_result,\r\n rc.Result_CounterStatus as Result_CounterStatus,\r\n CASE\r\n rc.Result_CounterStatus\r\n WHEN 'N' THEN 'Belum kirim'\r\n WHEN 'Y' THEN 'Proses Pengiriman'\r\n WHEN 'S' THEN 'Terkirim'\r\n WHEN 'E' THEN 'Error'\r\n ELSE 'Unknown'\r\n END AS status_name,\r\n Result_CounterUrlReport,\r\n Result_CounterIsImage,\r\n Result_CounterUrlImage,\r\n Result_CounterCounter\r\n FROM\r\n t_orderheader th\r\n JOIN result_counter rc \r\n ON th.T_OrderHeaderID = rc.Result_CounterT_OrderHeaderID\r\n AND th.T_OrderHeaderIsActive = 'Y'\r\n AND rc.Result_CounterIsActive = 'Y'\r\n \r\n AND th.T_OrderHeaderDate LIKE '%2024-02-26%'\r\n JOIN m_patient mp \r\n ON th.T_OrderHeaderM_PatientID = mp.M_PatientID\r\n AND mp.M_PatientIsActive = 'Y'\r\n JOIN m_delivery md \r\n ON rc.Result_CounterM_DeliveryID = md.M_DeliveryID\r\n AND md.M_DeliveryIsActive = 'Y'\r\n left JOIN group_result gr \r\n ON rc.Result_CounterGroup_ResultID = gr.Group_ResultID\r\n AND gr.Group_ResultIsActive = 'Y'\r\n JOIN (\r\n SELECT\r\n T_OrderPromiseT_OrderHeaderID,\r\n MAX(T_OrderPromiseDateTime) AS T_OrderPromiseDateTime\r\n FROM\r\n t_orderpromise\r\n WHERE\r\n T_OrderPromiseIsActive = 'Y'\r\n GROUP BY\r\n T_OrderPromiseT_OrderHeaderID\r\n ) AS tp ON th.T_OrderHeaderID = tp.T_OrderPromiseT_OrderHeaderID\r\n JOIN t_orderpromise tp2 \r\n ON th.T_OrderHeaderID = tp2.T_OrderPromiseT_OrderHeaderID\r\n AND tp.T_OrderPromiseDateTime = tp2.T_OrderPromiseDateTime\r\n JOIN result_processtooffice rpo \r\n ON th.T_OrderHeaderID = rpo.Result_ProcessToOfficeT_OrderHeaderID\r\n AND rpo.Result_ProcessToOfficeIsActive = 'Y'\r\n AND rpo.Result_ProcessToOfficeGroup_ResultID = rc.Result_CounterGroup_ResultID\r\n AND rpo.Result_ProcessToOfficeT_OrderDeliveryM_DeliveryID = md.M_DeliveryID\r\n AND rpo.Result_ProcessToOfficeStatus = 'S'\r\n AND (\r\n th.T_OrderHeaderLabNumber LIKE \"%%\"\r\n OR mp.M_PatientName LIKE \"%%\"\r\n ) \r\n group by\r\n th.T_OrderHeaderID,\r\n md.M_DeliveryID,\r\n rc.Result_CounterGroup_ResultID\r\n ORDER BY Result_CounterID DESC limit 10 offset 0" } } ``` **Kasus filter T_OrderPromiseDateTime / tgl janji hasil** ```json { "getDataType":"T_OrderPromiseDateTime", "getStatus":"Y", "search":"", "tglFilter":"2024-02-26", "current_page":"1" } ``` hasilnya ```json { "status": "OK", "data": { "total": 2, "total_filter": 10, "records": [ { "Result_ProcessToOfficeID": "201925", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 11:50:01", "tanggal_janji_hasil": "2024-02-26 15:50:01", "tanggal_serahkan": "2024-02-26 12:00:23", "no_reg": "05000034LA", "nama": "MR.HAYASHI SHIGEKI", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pengirim | -", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132116&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201923", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 11:50:01", "tanggal_janji_hasil": "2024-02-26 15:50:01", "tanggal_serahkan": "2024-02-26 12:00:23", "no_reg": "05000034LA", "nama": "MR.HAYASHI SHIGEKI", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pasien | 082113702602", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132116&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201932", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 12:00:40", "tanggal_janji_hasil": "2024-02-26 16:00:40", "tanggal_serahkan": "2024-02-26 12:12:51", "no_reg": "05000035LA", "nama": "KASMONO SUTOTO", "dokter": "dr. ABDILLAH S ALHADAD", "tujuan": "Whatsapp Pengirim | -", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132117&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201930", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 12:00:40", "tanggal_janji_hasil": "2024-02-26 16:00:40", "tanggal_serahkan": "2024-02-26 12:12:51", "no_reg": "05000035LA", "nama": "KASMONO SUTOTO", "dokter": "dr. ABDILLAH S ALHADAD", "tujuan": "Whatsapp Pasien | 087823628917", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132117&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201939", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 13:10:09", "tanggal_janji_hasil": "2024-02-26 17:10:09", "tanggal_serahkan": "2024-02-26 13:23:36", "no_reg": "05000036LA", "nama": "KOESDIONO", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pengirim | -", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132118&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201937", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 13:10:09", "tanggal_janji_hasil": "2024-02-26 17:10:09", "tanggal_serahkan": "2024-02-26 13:23:36", "no_reg": "05000036LA", "nama": "KOESDIONO", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pasien | 086876767832", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132118&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201948", "Result_CounterGroup_ResultID": "4", "tanggal_registrasi": "2024-02-26 13:15:37", "tanggal_janji_hasil": "2024-02-26 20:30:00", "tanggal_serahkan": "2024-02-26 13:42:13", "no_reg": "05000037LA", "nama": "SJOFIAN AZHAR", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pengirim | -", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "Rontgen", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/run?__report=report%2Fone%2Flab%2Frpt_hasil_so_xray_email.rptdesign&__format=pdf&username=adminsas&PID=132119&PLang=1&tm=1708929763659", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201947", "Result_CounterGroup_ResultID": "4", "tanggal_registrasi": "2024-02-26 13:15:37", "tanggal_janji_hasil": "2024-02-26 20:30:00", "tanggal_serahkan": "2024-02-26 13:42:13", "no_reg": "05000037LA", "nama": "SJOFIAN AZHAR", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pasien | 08757897645", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "Rontgen", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/run?__report=report%2Fone%2Flab%2Frpt_hasil_so_xray_email.rptdesign&__format=pdf&username=adminsas&PID=132119&PLang=1&tm=1708929763659", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201945", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 13:15:37", "tanggal_janji_hasil": "2024-02-26 20:30:00", "tanggal_serahkan": "2024-02-26 13:35:54", "no_reg": "05000037LA", "nama": "SJOFIAN AZHAR", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pengirim | -", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132119&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201944", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 13:15:37", "tanggal_janji_hasil": "2024-02-26 20:30:00", "tanggal_serahkan": "2024-02-26 13:35:54", "no_reg": "05000037LA", "nama": "SJOFIAN AZHAR", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pasien | 08757897645", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132119&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" } ], "sql": "SELECT\r\n rpo.Result_ProcessToOfficeID,\r\n rc.Result_CounterGroup_ResultID,\r\n IFNULL(th.T_OrderHeaderDate, '-') AS tanggal_registrasi,\r\n IFNULL(tp.T_OrderPromiseDateTime, '-') AS tanggal_janji_hasil,\r\n IFNULL(rpo.Result_ProcessToOfficeSendTime, '-') AS tanggal_serahkan,\r\n th.T_OrderHeaderLabNumber AS no_reg,\r\n mp.M_PatientName AS nama,\r\n fn_get_doctor_fullname(th.T_OrderHeaderSenderM_DoctorID) AS dokter,\r\n CONCAT(\r\n md.M_DeliveryName,\r\n ' | ',\r\n rc.Result_CounterDestination\r\n ) AS tujuan,\r\n rc.Result_CounterIsSend AS status_k,\r\n rc.Result_CounterIsReceive AS status_t,\r\n rc.Result_CounterIsRead AS status_b,\r\n fn_wa_get_groupresult(rc.Result_CounterGroup_ResultID) AS group_result,\r\n rc.Result_CounterStatus as Result_CounterStatus,\r\n CASE\r\n rc.Result_CounterStatus\r\n WHEN 'N' THEN 'Belum kirim'\r\n WHEN 'Y' THEN 'Proses Pengiriman'\r\n WHEN 'S' THEN 'Terkirim'\r\n WHEN 'E' THEN 'Error'\r\n ELSE 'Unknown'\r\n END AS status_name,\r\n rc.Result_CounterUrlReport,\r\n rc.Result_CounterIsImage,\r\n rc.Result_CounterUrlImage,\r\n rc.Result_CounterCounter\r\n FROM\r\n t_orderpromise tp\r\n JOIN result_counter rc \r\n ON tp.T_OrderPromiseT_OrderHeaderID = rc.Result_CounterT_OrderHeaderID\r\n AND tp.T_OrderPromiseDateTime LIKE '%2024-02-26%'\r\n JOIN t_orderheader th ON rc.Result_CounterT_OrderHeaderID = th.T_OrderHeaderID\r\n AND th.T_OrderHeaderIsActive = 'Y'\r\n JOIN m_patient mp ON th.T_OrderHeaderM_PatientID = mp.M_PatientID\r\n AND mp.M_PatientIsActive = 'Y'\r\n JOIN m_delivery md ON rc.Result_CounterM_DeliveryID = md.M_DeliveryID\r\n AND md.M_DeliveryIsActive = 'Y'\r\n left JOIN group_result gr ON rc.Result_CounterGroup_ResultID = gr.Group_ResultID\r\n AND gr.Group_ResultIsActive = 'Y'\r\n JOIN (\r\n SELECT\r\n T_OrderPromiseT_OrderHeaderID,\r\n MAX(T_OrderPromiseDateTime) AS T_OrderPromiseDateTime\r\n FROM\r\n t_orderpromise\r\n WHERE\r\n T_OrderPromiseIsActive = 'Y'\r\n GROUP BY\r\n T_OrderPromiseT_OrderHeaderID\r\n ) AS tp2 ON th.T_OrderHeaderID = tp2.T_OrderPromiseT_OrderHeaderID\r\n JOIN result_processtooffice rpo ON th.T_OrderHeaderID = rpo.Result_ProcessToOfficeT_OrderHeaderID\r\n AND rpo.Result_ProcessToOfficeIsActive = 'Y'\r\n AND rpo.Result_ProcessToOfficeGroup_ResultID = rc.Result_CounterGroup_ResultID\r\n AND rpo.Result_ProcessToOfficeT_OrderDeliveryM_DeliveryID = md.M_DeliveryID\r\n AND rpo.Result_ProcessToOfficeStatus = 'S'\r\n AND rc.Result_CounterStatus = 'N' \r\n AND (\r\n th.T_OrderHeaderLabNumber LIKE \"%%\"\r\n OR mp.M_PatientName LIKE \"%%\"\r\n ) \r\n GROUP BY\r\n th.T_OrderHeaderID,\r\n md.M_DeliveryID,\r\n rc.Result_CounterGroup_ResultID\r\n ORDER BY Result_CounterID DESC limit 10 offset 0" } } ``` **Kasus filter Result_ProcessToOfficeSendTime / tgl serahkan** ```json { "getDataType":"Result_ProcessToOfficeSendTime", "getStatus":"N", "search":"", "tglFilter":"2024-02-26", "current_page":"1" } ``` hasilnya ```json { "status": "OK", "data": { "total": 2, "total_filter": 10, "records": [ { "Result_ProcessToOfficeID": "201925", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 11:50:01", "tanggal_janji_hasil": "2024-02-27 12:00:00", "tanggal_serahkan": "2024-02-26 12:00:23", "no_reg": "05000034LA", "nama": "MR.HAYASHI SHIGEKI", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pengirim | -", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132116&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201923", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 11:50:01", "tanggal_janji_hasil": "2024-02-27 12:00:00", "tanggal_serahkan": "2024-02-26 12:00:23", "no_reg": "05000034LA", "nama": "MR.HAYASHI SHIGEKI", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pasien | 082113702602", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132116&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201925", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 12:00:40", "tanggal_janji_hasil": "2024-02-27 12:00:00", "tanggal_serahkan": "2024-02-26 12:00:23", "no_reg": "05000035LA", "nama": "KASMONO SUTOTO", "dokter": "dr. ABDILLAH S ALHADAD", "tujuan": "Whatsapp Pengirim | -", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132117&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201923", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 12:00:40", "tanggal_janji_hasil": "2024-02-27 12:00:00", "tanggal_serahkan": "2024-02-26 12:00:23", "no_reg": "05000035LA", "nama": "KASMONO SUTOTO", "dokter": "dr. ABDILLAH S ALHADAD", "tujuan": "Whatsapp Pasien | 087823628917", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132117&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201925", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 13:10:09", "tanggal_janji_hasil": "2024-02-27 12:00:00", "tanggal_serahkan": "2024-02-26 12:00:23", "no_reg": "05000036LA", "nama": "KOESDIONO", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pengirim | -", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132118&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201923", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 13:10:09", "tanggal_janji_hasil": "2024-02-27 12:00:00", "tanggal_serahkan": "2024-02-26 12:00:23", "no_reg": "05000036LA", "nama": "KOESDIONO", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pasien | 086876767832", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132118&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201948", "Result_CounterGroup_ResultID": "4", "tanggal_registrasi": "2024-02-26 13:15:37", "tanggal_janji_hasil": "2024-02-28 17:00:00", "tanggal_serahkan": "2024-02-26 13:42:13", "no_reg": "05000037LA", "nama": "SJOFIAN AZHAR", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pengirim | -", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "Rontgen", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/run?__report=report%2Fone%2Flab%2Frpt_hasil_so_xray_email.rptdesign&__format=pdf&username=adminsas&PID=132119&PLang=1&tm=1708929763659", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201947", "Result_CounterGroup_ResultID": "4", "tanggal_registrasi": "2024-02-26 13:15:37", "tanggal_janji_hasil": "2024-02-28 17:00:00", "tanggal_serahkan": "2024-02-26 13:42:13", "no_reg": "05000037LA", "nama": "SJOFIAN AZHAR", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pasien | 08757897645", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "Rontgen", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/run?__report=report%2Fone%2Flab%2Frpt_hasil_so_xray_email.rptdesign&__format=pdf&username=adminsas&PID=132119&PLang=1&tm=1708929763659", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201925", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 13:15:37", "tanggal_janji_hasil": "2024-02-28 17:00:00", "tanggal_serahkan": "2024-02-26 12:00:23", "no_reg": "05000037LA", "nama": "SJOFIAN AZHAR", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pengirim | -", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132119&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" }, { "Result_ProcessToOfficeID": "201923", "Result_CounterGroup_ResultID": "1", "tanggal_registrasi": "2024-02-26 13:15:37", "tanggal_janji_hasil": "2024-02-28 17:00:00", "tanggal_serahkan": "2024-02-26 12:00:23", "no_reg": "05000037LA", "nama": "SJOFIAN AZHAR", "dokter": "dr. A B WARDOYO., Sp. PD", "tujuan": "Whatsapp Pasien | 08757897645", "status_k": "N", "status_t": "N", "status_b": "N", "group_result": "LAB", "Result_CounterStatus": "N", "status_name": "Belum kirim", "Result_CounterUrlReport": "\/birt\/frameset?__report=report%2Fone%2Flab%2Frpt_test_email.rptdesign&__format=pdf&username=admin&PID=132119&ts=20240307100649", "Result_CounterIsImage": "N", "Result_CounterUrlImage": "", "Result_CounterCounter": "1" } ], "sql": "SELECT\r\n rpo.Result_ProcessToOfficeID,\r\n rc.Result_CounterGroup_ResultID,\r\n IFNULL(th.T_OrderHeaderDate, '-') AS tanggal_registrasi,\r\n IFNULL(tp.T_OrderPromiseDateTime, '-') AS tanggal_janji_hasil,\r\n IFNULL(rpo.Result_ProcessToOfficeSendTime, '-') AS tanggal_serahkan,\r\n th.T_OrderHeaderLabNumber AS no_reg,\r\n mp.M_PatientName AS nama,\r\n fn_get_doctor_fullname(th.T_OrderHeaderSenderM_DoctorID) AS dokter,\r\n CONCAT(\r\n md.M_DeliveryName,\r\n ' | ',\r\n rc.Result_CounterDestination\r\n ) AS tujuan,\r\n rc.Result_CounterIsSend AS status_k,\r\n rc.Result_CounterIsReceive AS status_t,\r\n rc.Result_CounterIsRead AS status_b,\r\n fn_wa_get_groupresult(rc.Result_CounterGroup_ResultID) AS group_result,\r\n rc.Result_CounterStatus as Result_CounterStatus,\r\n CASE\r\n rc.Result_CounterStatus\r\n WHEN 'N' THEN 'Belum kirim'\r\n WHEN 'Y' THEN 'Proses Pengiriman'\r\n WHEN 'S' THEN 'Terkirim'\r\n WHEN 'E' THEN 'Error'\r\n ELSE 'Unknown'\r\n END AS status_name,\r\n rc.Result_CounterUrlReport,\r\n rc.Result_CounterIsImage,\r\n rc.Result_CounterUrlImage,\r\n rc.Result_CounterCounter\r\n FROM\r\n result_processtooffice rpo\r\n JOIN result_counter rc \r\n ON rpo.Result_ProcessToOfficeGroup_ResultID = rc.Result_CounterGroup_ResultID\r\n AND rpo.Result_ProcessToOfficeT_OrderDeliveryM_DeliveryID = rc.Result_CounterM_DeliveryID\r\n AND rpo.Result_ProcessToOfficeSendTime LIKE '%2024-02-26%'\r\n AND rc.Result_CounterStatus = 'N' \r\n JOIN t_orderheader th ON rc.Result_CounterT_OrderHeaderID = th.T_OrderHeaderID\r\n AND th.T_OrderHeaderIsActive = 'Y'\r\n JOIN m_patient mp ON th.T_OrderHeaderM_PatientID = mp.M_PatientID\r\n AND mp.M_PatientIsActive = 'Y'\r\n JOIN m_delivery md ON rc.Result_CounterM_DeliveryID = md.M_DeliveryID\r\n AND md.M_DeliveryIsActive = 'Y'\r\n left JOIN group_result gr ON rc.Result_CounterGroup_ResultID = gr.Group_ResultID\r\n AND gr.Group_ResultIsActive = 'Y'\r\n JOIN (\r\n SELECT\r\n T_OrderPromiseT_OrderHeaderID,\r\n MAX(T_OrderPromiseDateTime) AS T_OrderPromiseDateTime\r\n FROM\r\n t_orderpromise\r\n WHERE\r\n T_OrderPromiseIsActive = 'Y'\r\n GROUP BY\r\n T_OrderPromiseT_OrderHeaderID\r\n ) AS tp ON th.T_OrderHeaderID = tp.T_OrderPromiseT_OrderHeaderID\r\n JOIN t_orderpromise tp2 ON th.T_OrderHeaderID = tp2.T_OrderPromiseT_OrderHeaderID\r\n AND tp.T_OrderPromiseDateTime = tp2.T_OrderPromiseDateTime\r\n WHERE\r\n rpo.Result_ProcessToOfficeIsActive = 'Y'\r\n AND rpo.Result_ProcessToOfficeStatus = 'S'\r\n AND (\r\n th.T_OrderHeaderLabNumber LIKE \"%%\"\r\n OR mp.M_PatientName LIKE \"%%\"\r\n ) \r\n GROUP BY\r\n th.T_OrderHeaderID,\r\n md.M_DeliveryID,\r\n rc.Result_CounterGroup_ResultID\r\n ORDER BY Result_CounterID DESC limit 10 offset 0" } } ```
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
No items
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
sindhu
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: sindhu/belajar#44
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?