Helpers

 

<?php

function RP($angka)

{

    $hasil_rupiah = "Rp " . number_format($angka, 2, ',', '.');

    echo $hasil_rupiah;

}

function WKT($sekarang)

{

    $tanggal = substr($sekarang, 8, 2) + 0;

    $bulan = substr($sekarang, 5, 2);

    $tahun = substr($sekarang, 0, 4);

    $judul_bln = array(1 => "Januari", "Februari", "Maret", "April", "Mei", "Juni", "Juli", "Agustus", "September", "Oktober", "November", "Desember");

    $wk = $tanggal . " " . $judul_bln[(int)$bulan] . " " . $tahun;

    return $wk;

}

function WKTP($sekarang)

{

    $tanggal = substr($sekarang, 8, 2) + 0;

    $bulan = substr($sekarang, 5, 2);

    $tahun = substr($sekarang, 2, 2);

    $judul_bln = array(1 => "Jan", "Feb", "Mar", "Apr", "Mei", "Jun", "Jul", "Agu", "Sep", "Okt", "Nov", "Des");

    $wk = $tanggal . " " . $judul_bln[(int)$bulan] . "'" . $tahun;

    return $wk;

}

function getEven($kode){

    $sql = "SELECT `nama_even`,`jumlah` FROM `tb_even` WHERE `id_even`= '" . $kode . "'";

    $results = DB::select($sql);

    $nama_even = $results[0]->nama_even;

$jumlah = $results[0]->jumlah;

    return "$nama_even";// ($jumlah Dicari)

}

function getRelawan($kode){

    $sql = "SELECT `nama_relawan` FROM `tb_relawan` WHERE `id_relawan`= '" . $kode . "'";

    $results = DB::select($sql);

    $hasil = $results[0]->nama_relawan;

    return $hasil;

}

function getUser($kode){

    $sql = "SELECT `nama_user` FROM `tb_user` WHERE `id_user`= '" . $kode . "'";

    $results = DB::select($sql);

    $hasil = $results[0]->nama_user;

    return $hasil;

}

function getPendaftaran($kode){

    $sql = "SELECT * FROM `tb_pendaftaran` WHERE `id_pendaftaran`= '" . $kode . "'";

    $results = DB::select($sql);

    $even= getEven($results[0]->id_even);

$relawan= getRelawan($results[0]->id_relawan);

$alasan= $results[0]->alasan;

    return "$even<br>Relawan: $relawan, <i>$alasan</i>";

}