MMSL

<?php
$timestamp_start = date("d-m-Y, H:i:s");
$row_num = $_POST['row_num'];
$params = array();
$params['row_num'] = $row_num;
$service = new ServiceConsumer($db, "get_mmsl_master_obat", $params, "gudang_farmasi");
$service->setMode(ServiceConsumer::$CLEAN_BOTH);
$content = $service->execute()->getContent();
$nama_obat = $content[0];
$nama_jenis_obat = $content[1];

$bulan = $_POST['bulan'];
$tahun = $_POST['tahun'];
$jumlah_hari = cal_days_in_month(0, $bulan, $tahun);

//PRDI - I:
$start_day = 1;
$end_day = 7;
$params = array();
$params['nama_obat'] = $nama_obat;
$params['nama_jenis_obat'] = $nama_jenis_obat;
$params['tanggal_from'] = $tahun . "-" . $bulan . "-" . $start_day;
$params['tanggal_to'] = $tahun . "-" . $bulan . "-" . $end_day;
$service = new ServiceConsumer($db, "get_mmsl_penggunaan_riil", $params, "depo_farmasi");
$service->setMode(ServiceConsumer::$CLEAN_BOTH);
$content = $service->execute()->getContent();
$prd1_1 = $content[0];

//PRDI - II:
$start_day += 7;
$end_day += 7;
$params = array();
$params['nama_obat'] = $nama_obat;
$params['nama_jenis_obat'] = $nama_jenis_obat;
$params['tanggal_from'] = $tahun . "-" . $bulan . "-" . $start_day;
$params['tanggal_to'] = $tahun . "-" . $bulan . "-" . $end_day;
$service = new ServiceConsumer($db, "get_mmsl_penggunaan_riil", $params, "depo_farmasi");
$service->setMode(ServiceConsumer::$CLEAN_BOTH);
$content = $service->execute()->getContent();
$prd1_2 = $content[0];

//PRDI - III:
$start_day += 7;
$end_day += 7;
$params = array();
$params['nama_obat'] = $nama_obat;
$params['nama_jenis_obat'] = $nama_jenis_obat;
$params['tanggal_from'] = $tahun . "-" . $bulan . "-" . $start_day;
$params['tanggal_to'] = $tahun . "-" . $bulan . "-" . $end_day;
$service = new ServiceConsumer($db, "get_mmsl_penggunaan_riil", $params, "depo_farmasi");
$service->setMode(ServiceConsumer::$CLEAN_BOTH);
$content = $service->execute()->getContent();
$prd1_3 = $content[0];

//PRDI - IV:
$start_day += 7;
$end_day = $jumlah_hari;
$params = array();
$params['nama_obat'] = $nama_obat;
$params['nama_jenis_obat'] = $nama_jenis_obat;
$params['tanggal_from'] = $tahun . "-" . $bulan . "-" . $start_day;
$params['tanggal_to'] = $tahun . "-" . $bulan . "-" . $end_day;
$service = new ServiceConsumer($db, "get_mmsl_penggunaan_riil", $params, "depo_farmasi");
$service->setMode(ServiceConsumer::$CLEAN_BOTH);
$content = $service->execute()->getContent();
$prd1_4 = $content[0];

$prd_total = $prd1_1 + $prd1_2 + $prd1_3 + $prd1_4;
$prd_rerata_normal = ceil($prd_total / 4);

$bobot_1 = $_POST['bobot_1'];
$bobot_2 = $_POST['bobot_2'];
$bobot_3 = $_POST['bobot_3'];
$bobot_4 = $_POST['bobot_4'];
$bobot_total = $bobot_1 + $bobot_2 + $bobot_3 + $bobot_4;
$prd_rerata_bobot = ceil(($bobot_1 * ($prd1_1 + $prd2_1) + $bobot_2 * ($prd1_2 + $prd2_2) + $bobot_3 * ($prd1_3 + $prd2_3) + $bobot_4 * ($prd1_4 + $prd2_4)) / $bobot_total);

$smax_minggu = round($_POST['smax_minggu'], 1);
$smin_minggu = round($_POST['smin_minggu'], 1);
$rop_minggu = round($_POST['rop_minggu'], 1);
$lt_minggu = round($_POST['lt_minggu'], 1);
$smax_normal = round($smax_minggu * $prd_rerata_normal);
$smax_bobot = round($smax_minggu * $prd_rerata_bobot);
$smin_normal = round($smin_minggu * $prd_rerata_normal);
$smin_bobot = round($smin_minggu * $prd_rerata_bobot);
$rop_normal = round($rop_minggu * $prd_rerata_normal);
$rop_bobot = round($rop_minggu * $prd_rerata_bobot);
$lt_normal = round($lt_minggu * $prd_rerata_normal);
$lt_bobot = round($lt_minggu * $prd_rerata_bobot);

$service = new ServiceConsumer($db, "get_mmsl_stok", $params, "depo_farmasi");
$service->setMode(ServiceConsumer::$CLEAN_BOTH);
$content = $service->execute()->getContent();
$stok_depo_1 = $content[0];
$service = new ServiceConsumer($db, "get_mmsl_stok", $params, "gudang_farmasi");
$service->setMode(ServiceConsumer::$CLEAN_BOTH);
$content = $service->execute()->getContent();
$stok_gudang_farmasi = $content[0];
$stok_total = $stok_depo_1 + $stok_gudang_farmasi;

$mmsl_status_normal = "TIDAK PESAN";
$qty_beli_normal = 0;
if ($stok_total <= $rop_normal) {
    $qty_beli_normal = $smax_normal - $stok_total + $lt_normal;
    $mmsl_status_normal = $qty_beli_normal == 0? "TIDAK PESAN" : "<strong>PESAN</strong>";
}
$mmsl_status_bobot = "TIDAK PESAN";
$qty_beli_bobot = 0;
if ($stok_total <= $rop_bobot) {
    $qty_beli_bobot = $smax_bobot - $stok_total + $lt_bobot;
    $mmsl_status_bobot = $qty_beli_bobot == 0? "TIDAK PESAN" : "<strong>PESAN</strong>";
}

$data = array();
$data['nama_obat'] = $nama_obat;
$data['jenis_obat'] = $nama_jenis_obat;
$data['timestamp_start'] = $timestamp_start;
$timestamp_end = date("d-m-Y, H:i:s");
$data['timestamp_end'] = $timestamp_end;
$durasi = strtotime($timestamp_end) - strtotime($timestamp_start);
$data['durasi'] = $durasi . " detik";
$data['element'] = "
    <tr id='obat_" . $row_num . "'>
        <td><small>" . ($row_num + 1) . "</small></td>
        <td><small>" . $nama_obat . "</small></td>
        <td><small>" . $nama_jenis_obat . "</small></td>
        <td style='text-align: right !important;'><small>" . $prd1_1 . "</small></td>
        <td style='text-align: right !important;'><small>" . $prd1_2 . "</small></td>
        <td style='text-align: right !important;'><small>" . $prd1_3 . "</small></td>
        <td style='text-align: right !important;'><small>" . $prd1_4 . "</small></td>
        <td style='text-align: right !important;'><small>" . $prd_total . "</small></td>
        <td style='text-align: right !important;'><small>" . $stok_gudang_farmasi . "</small></td>
        <td style='text-align: right !important;'><small>" . $stok_depo_1 . "</small></td>
        <td style='text-align: right !important;'><small>" . $stok_total . "</small></td>
        <td style='text-align: right !important;'><small>" . $prd_rerata_normal . "</small></td>
        <td style='text-align: right !important;'><small>" . $prd_rerata_bobot . "</small></td>
        <td style='text-align: right !important;'><small>" . $smax_normal . "</small></td>
        <td style='text-align: right !important;'><small>" . $smax_bobot . "</small></td>
        <td style='text-align: right !important;'><small>" . $smin_normal . "</small></td>
        <td style='text-align: right !important;'><small>" . $smin_bobot . "</small></td>
        <td style='text-align: right !important;'><small>" . $rop_normal . "</small></td>
        <td style='text-align: right !important;'><small>" . $rop_bobot . "</small></td>
        <td style='text-align: right !important;'><small>" . $lt_normal . "</small></td>
        <td style='text-align: right !important;'><small>" . $lt_bobot . "</small></td>
        <td style='text-align: right !important;'><small>" . $mmsl_status_normal . "</small></td>
        <td style='text-align: right !important;'><small>" . $mmsl_status_bobot . "</small></td>
        <td style='text-align: right !important;'><small>" . $qty_beli_normal . "</small></td>
        <td style='text-align: right !important;'><small>" . $qty_beli_bobot . "</small></td>
    </tr>
";
echo json_encode($data);
?>