You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
95 lines
2.8 KiB
PHP
95 lines
2.8 KiB
PHP
<?php
|
|
|
|
use NN\Route;
|
|
use NN\Session;
|
|
use NN\Module\DB;
|
|
use NN\Module\DD;
|
|
use NN\Link;
|
|
use NN\Files;
|
|
use NN\load;
|
|
use NN\Module\View;
|
|
use NN\Module\Uuid as id;
|
|
use NN\Webs;
|
|
use NN\Bug;
|
|
use NN\Module\crontab;
|
|
use NN\Module\Help;
|
|
use NN\Module\Datatable;
|
|
use NN\Enc;
|
|
use NN\Post;
|
|
|
|
$api->addLink('/deposits/member/{id}', function($id=""){
|
|
$accept = $_SERVER['HTTP_ACCEPT'];
|
|
$authorization = $_SERVER['HTTP_AUTHORIZATION'];
|
|
header("Content-Type: $accept");
|
|
$token = explode(" ", $authorization)[1];
|
|
$validasi_login = DB::query_result_object_row("SELECT * FROM login WHERE token = '$token'");
|
|
|
|
if($validasi_login == null){
|
|
|
|
echo json_encode([
|
|
"success" => false,
|
|
"message" => "anda tidak memiliki akses",
|
|
]);
|
|
|
|
return false;
|
|
}
|
|
|
|
$datalogin = DB::query_result_object_row("SELECT * FROM login WHERE token = '$token'");
|
|
$kode_anggota = $datalogin ? $datalogin->memberid: null;
|
|
$anggota = DB::query_result_object_row("SELECT * FROM anggota WHERE kode = '$kode_anggota'");
|
|
$simpanan = DB::query_result_object("SELECT j.kode, j.nama, k.total FROM jpinjam j
|
|
LEFT JOIN (
|
|
SELECT kodesp, sum(IF(dk='D', jumlah, jumlah * -1)) total FROM msimpan WHERE kode = '$kode_anggota' GROUP BY kodesp
|
|
) k ON j.kode = k.kodesp
|
|
WHERE j.rw <> '-'");
|
|
|
|
$data = [];
|
|
|
|
$koperasiColors = [
|
|
"#17936B", // Hijau Koperasi
|
|
"#1B5E20", // Hijau Gelap
|
|
"#2E7D32", // Hijau Forest
|
|
"#00695C", // Teal Gelap
|
|
"#0277BD", // Biru Laut
|
|
"#1565C0", // Biru Koperasi
|
|
"#4527A0", // Ungu Tua
|
|
"#283593", // Indigo Gelap
|
|
"#006064", // Cyan Gelap
|
|
"#00838F" // Cyan Medium
|
|
];
|
|
$no = 1;
|
|
foreach($simpanan as $key => $itemSimpanan)
|
|
{
|
|
$colorIndex = $key % count($koperasiColors);
|
|
|
|
$data[] = [
|
|
"deposit_id" => 1,
|
|
"deposit_name" => $itemSimpanan->nama,
|
|
"single" => 1,
|
|
"deposit" => "sekali",
|
|
"timed" => 0,
|
|
"withdrawable" => 0,
|
|
"wallet" => 0,
|
|
"bonus_wallet" => 0,
|
|
"add_to_obligation" => 0,
|
|
"detail_account_id" => 26,
|
|
"total_amount" => null,
|
|
"active_member" => 1,
|
|
"member_deposit_id" => 2865,
|
|
"account_no" => $kode_anggota."12200000".str_pad($no, 4, "0", STR_PAD_LEFT),
|
|
"personalized_name" => $itemSimpanan->nama,
|
|
"personalized_background_color" => $koperasiColors[$colorIndex],
|
|
"approved" => 1,
|
|
"deposit_date" => "1",
|
|
"due_date" => null,
|
|
"balance" => $itemSimpanan->total,
|
|
"auto_renewal" => 0,
|
|
"active" => 1
|
|
];
|
|
$no++;
|
|
}
|
|
|
|
echo json_encode(
|
|
$data
|
|
);
|
|
}); |