<?php

/*******************************************************************

    Module        : /apps/php/api/master.php
    Desc.         : PHP - Fungsi MASTER
    Created By    : Siau Pheng (siaupheng@3fonia.com).
    Created Date  : December 18th, 2025.

    (c) 2025, 3FONIA Software; WWW.3FONIA.COM.

*******************************************************************/

require_once(__DIR__."/../../../../../vendor/autoload.php");
require_once(__DIR__."/../func.sippd.php");

use siaupheng\fonia3\Web\Param;

function simpan_master_subkeg($db = null) {
    $aret = ['status' => "success", 'message' => 'Berhasil simpan data Master Sub Kegiatan !'];
    if (empty($_POST['subgiat'])) return $aret;

    $tahun = Param::Get("tahun_anggaran", 0);
    $adata = json_decode(stripslashes(html_entity_decode($_POST['subgiat'])), true);

    if ($tahun == 0) {
        $aret['message'] = "Tahun Anggaran Tidak Ada !";
        return $aret;
    }

    // hapus sesuai tahun
    if (empty($_POST['page']) || (!empty($_POST['page']) && $_POST['page'] == 1)) {
        $db->Query("DELETE FROM i_submap WHERE Tahun='".$tahun."'");
    }

    foreach ($adata as $_key1 => $asub) {
        if ($asub['set_kab_kota'] == 0) continue;
        if (!(in_array($asub['id_daerah'], [0,553]) || in_array($asub['id_daerah_khusus'], [0,553]))) continue;

        $apull = [  'Tahun' => $tahun,
                    'UrusanID' => $asub['id_urusan'],
                    'BUID' => $asub['id_bidang_urusan'],
                    'ProgID' => $asub['id_program'],
                    'KegID' => $asub['id_giat'],
                    'SubID' => $asub['id_sub_giat'],
                    'K_Urusan' => $asub['kode_urusan'],
                    'N_Urusan' => $asub['nama_urusan'],
                    'K_Bidu' => $asub['kode_bidang_urusan'],
                    'N_Bidu' => $asub['nama_bidang_urusan'],
                    'K_Prog' => $asub['kode_program'],
                    'N_Prog' => $asub['nama_program'],
                    'K_Keg' => $asub['kode_giat'],
                    'N_Keg' => $asub['nama_giat'],
                    'K_Sub' => $asub['kode_sub_giat'],
                    'N_Sub' => $asub['nama_sub_giat'],
                    'Indikator' => $asub['indikator'],
                    'Satuan' => $asub['satuan']
        ];
        fastInsert("i_submap", $apull);

    }
    return $aret;
}

function simpan_master_akun($db = null) {
    $aret = ['status' => 'success', 'message' => 'Berhasil export Akun Rekening Belanja!'];
    if (empty($_POST['akun'])) return $aret;

    $tahun = Param::Get("tahun_anggaran", 0);
    $akun = json_decode(stripslashes(html_entity_decode($_POST['akun'])), true);

    // hapus sesuai tahun
    if (empty($_POST['page']) || (!empty($_POST['page']) && $_POST['page'] == 1)) {
        $db->Query("DELETE FROM i_akun WHERE Tahun='".$tahun."'");
    }

    foreach ($akun as $k => $v) {
        if ($v['set_kab_kota'] == 0) continue;
        $apull = [
            'Tahun' => $tahun,
            'AkunID' => $v['id_akun'],
            'K_Akun' => $v['kode_akun'],
            'N_Akun' => $v['nama_akun'],
            'Is_Pend' => $v['is_pendapatan'],
            'Is_BL' => $v['is_bl'],
            'Is_Biaya' => $v['is_pembiayaan'],
            'Is_Gaji' => $v['is_gaji_asn'],
            'Is_Barjas' => $v['is_barjas'],
            'Is_Bunga' => $v['is_bunga'],
            'Is_Subsidi' => $v['is_subsidi'],
            'Is_Bagi_Hasil' => $v['is_bagi_hasil'],
            'Set_Input' => $v['set_input']
        ];
        fastInsert("i_akun", $apull);
    }
    return $aret;
}

?>