API Upah Minimum

// Fungsi untuk mendapatkan upah minimum berdasarkan lokasi karyawan
async function getMinimumWage(regionCode, year = new Date().getFullYear()) {
  // Coba dapatkan UMK terlebih dahulu (lebih spesifik)
  let response = await fetch(
    `https://api.portaldata.id/api/v1/wages?region=${regionCode}&type=UMK&year=${year}`,
    { headers: { 'X-API-Key': 'YOUR_API_KEY' } }
  );

  let { data } = await response.json();

  // Jika UMK tidak ada, gunakan UMP provinsi
  if (data.length === 0) {
    // Ambil kode provinsi (2 digit pertama)
    const provinceCode = regionCode.split('.')[0];

    response = await fetch(
      `https://api.portaldata.id/api/v1/wages?region=${provinceCode}&type=UMP&year=${year}`,
      { headers: { 'X-API-Key': 'YOUR_API_KEY' } }
    );

    ({ data } = await response.json());
  }

  if (data.length > 0) {
    return {
      amount: data[0].amount,
      type: data[0].type,
      regionName: data[0].regionName,
      effectiveDate: data[0].effectiveDate
    };
  }

  throw new Error('Upah minimum tidak ditemukan');
}

// Fungsi untuk menghitung gaji minimum dengan overtime
function calculateSalary(minimumWage, overtimeHours = 0) {
  // Asumsi 173 jam kerja per bulan (standar Kemenaker)
  const hourlyRate = minimumWage / 173;
  const overtimeRate = hourlyRate * 1.5; // 150% untuk overtime

  return {
    baseSalary: minimumWage,
    hourlyRate: Math.round(hourlyRate),
    overtimePay: Math.round(overtimeHours * overtimeRate),
    totalSalary: minimumWage + Math.round(overtimeHours * overtimeRate)
  };
}

// Contoh penggunaan
const wage = await getMinimumWage('32.73'); // Kota Bandung
console.log('Upah Minimum:', wage);
// Output:
// {
//   amount: 4340940,
//   type: 'UMK',
//   regionName: 'Kota Bandung',
//   effectiveDate: '2025-01-01'
// }

const salary = calculateSalary(wage.amount, 10);
console.log('Perhitungan Gaji:', salary);
// Output:
// {
//   baseSalary: 4340940,
//   hourlyRate: 25092,
//   overtimePay: 376380,
//   totalSalary: 4717320
// }

import requests
import pandas as pd

API_KEY = 'YOUR_API_KEY'
BASE_URL = 'https://api.portaldata.id/api/v1'

def get_all_ump(year):
    """Mendapatkan semua UMP dalam satu tahun"""
    response = requests.get(
        f'{BASE_URL}/wages',
        params={'type': 'UMP', 'year': year, 'limit': 100},
        headers={'X-API-Key': API_KEY}
    )
    return response.json()['data']

def compare_ump(year1, year2):
    """Membandingkan UMP antara dua tahun"""
    ump_year1 = {w['regionCode']: w for w in get_all_ump(year1)}
    ump_year2 = {w['regionCode']: w for w in get_all_ump(year2)}

    comparison = []
    for code, w2 in ump_year2.items():
        w1 = ump_year1.get(code)
        if w1:
            increase = w2['amount'] - w1['amount']
            pct_increase = (increase / w1['amount']) * 100
            comparison.append({
                'region': w2['regionName'],
                f'UMP_{year1}': w1['amount'],
                f'UMP_{year2}': w2['amount'],
                'increase': increase,
                'pct_increase': round(pct_increase, 2)
            })

    return sorted(comparison, key=lambda x: x['pct_increase'], reverse=True)

# Contoh penggunaan
comparison = compare_ump(2024, 2025)
df = pd.DataFrame(comparison)
print(df.head(10))

# Output:
#          region  UMP_2024  UMP_2025  increase  pct_increase
# 0   DKI Jakarta   5067381   5396761    329380          6.50
# 1   Jawa Tengah   2032856   2159866    127010          6.25
# 2    DIY Yogya   2125800   2254100    128300          6.03
# ...