Untitled
unknown
php
2 years ago
286 kB
4
Indexable
<?php date_default_timezone_set("Asia/Jakarta"); require "konek.php"; function konek() { return mysqli_connect("localhost", "root", "", "nsw"); } function query($id) { $konek = konek(); return mysqli_query($konek, $id); } function query_banyak($id) { return mysqli_fetch_assoc($id); } function query_satu($id) { $konek = konek(); return mysqli_fetch_assoc( mysqli_query($konek, $id) ); } function jumlah($id) { $konek = konek(); return mysqli_num_rows( mysqli_query($konek, $id) ); } function enc($id) { return base64_encode($id); } function dec($id) { return base64_decode($id); } function riwayat() { return date("Y-m-d H:i:s"); } function riwayat_all($kode, $id_riwayat_header) { return query("SELECT * FROM riwayat WHERE kode = '$kode' AND id_riwayat_header = '$id_riwayat_header' ORDER BY tgl ASC"); } function p($id) { return @$_POST[$id]; } function g($id) { return $_GET[$id]; } function f($id) { return $_FILES[$id]; } function code($id) { return eval(base64_decode($id)); } function get_random_string($valid_chars, $length) { // start with an empty random string $random_string = ""; // count the number of chars in the valid chars string so we know how many choices we have $num_valid_chars = strlen($valid_chars); // repeat the steps until we've created a string of the right length for ($i = 0; $i < $length; $i++) { // pick a random number from 1 up to the number of valid chars $random_pick = mt_Rand(1, $num_valid_chars); // take the random character out of the string of valid chars // subtract 1 from $random_pick because strings are indexed starting at 0, and we started picking at 1 $random_char = $valid_chars[$random_pick - 1]; // add the randomly-chosen char onto the end of our string so far $random_string .= $random_char; } // return our finished random string return $random_string; } function user($id) { $q = query_satu("SELECT * FROM user WHERE id_user = '$_SESSION[id_user]'"); return $q[$id]; } function account_disabled() { if ($_SESSION) { $q = @query_satu("SELECT * FROM user WHERE id_user = '$_SESSION[id_user]'"); if ($q && $q["id_status_user"] != 1) { return true; } else { return false; } } else { return false; } } function user_image() { $q = query_satu("SELECT * FROM user_gambar WHERE id_user = '$_SESSION[id_user]'"); $img_name = $q["nama_gambar_user"]; if ($img_name == "" or $img_name == null or $img_name == "unknown") { return "nophoto.png"; } else { return $img_name; } } function user_image_jumlah($id) { return jumlah("SELECT * FROM user_gambar WHERE id_user = '$id'"); } function user_image_satu($id, $ok) { $a = query_satu("SELECT * FROM user_gambar WHERE id_user = '$id'"); return $a[$ok]; } function title($alt) { if (@$_GET['halaman'] == 'produk') { $hal = 'Halaman Produk'; } elseif (@$_GET['halaman'] == 'kategori') { $hal = 'Halaman Kategori'; } elseif (@$_GET['halaman'] == 'customer') { $hal = 'Halaman Customer'; } elseif (@$_GET['halaman'] == 'wilayah') { $hal = 'Halaman Wilayah'; } elseif (@$_GET['halaman'] == 'satuan') { $hal = 'Halaman Satuan'; } else { if ($alt != "") { $hal = $alt; } else { $hal = "Admin NSW"; } } return $hal; } function rupiah($angka) { $hasil_rupiah = "Rp. " . number_format($angka, 2, ",", "."); return $hasil_rupiah; } function rp($angka) { $hasil_rupiah = "Rp " . number_format($angka, 0, ",", "."); return $hasil_rupiah; } function numb($id) { return number_format($id, 2, ",", "."); } function numb_nol($id) { return number_format($id, 0, ",", "."); } function get_sidebar_user($level) { if ($level == 1) { return ' <li class="nav-item"> <a href="../../" class="nav-link active"> <i class="nav-icon fas fa-tachometer-alt"></i> <p> Dashboard </p> </a> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="nav-icon fas fa-chart-line"></i> <p> Other Dashboard <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-sales" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Sales and Profitability</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-finance" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Finance</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-inventory" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Inventory</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-cfo" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>CFO</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-ceo" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>CEO</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-cashflow" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Cash Flow</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-budget-actual" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Budget vs Acutal</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-accounts-payable" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Accounts Payable </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-accounts-receivable" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Accounts Receivable </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-profit-margin" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Profit Margin </p> </a> </li> <!-- <li class="nav-item"> <a href="pages/nsw/?halaman=yearly-comparison-report" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Yearly Comparison </p> </a> </li> --> <li class="nav-item"> <a href="#" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p> Yearly Comparison <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=yearly-comparison-report-jenis" class="nav-link"> <i class="far fa-dot-circle nav-icon"></i> <p>Jenis Produk</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=yearly-comparison-report-produk" class="nav-link"> <i class="far fa-dot-circle nav-icon"></i> <p>Produk</p> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p> KPI <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-kpi-monthly" class="nav-link"> <i class="far fa-dot-circle nav-icon"></i> <p>Monthly</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-kpi-ytd" class="nav-link"> <i class="far fa-dot-circle nav-icon"></i> <p>YTD</p> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p> Annual Report <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-AR-quater" class="nav-link"> <i class="far fa-dot-circle nav-icon"></i> <p>Quater</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-AR-month" class="nav-link"> <i class="far fa-dot-circle nav-icon"></i> <p>Month</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-AR-report" class="nav-link"> <i class="far fa-dot-circle nav-icon"></i> <p>Report</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-AR-income" class="nav-link"> <i class="far fa-dot-circle nav-icon"></i> <p>Income Statement</p> </a> </li> </ul> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-salesman" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Salesman </p> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="nav-icon fas fa-shopping-bag"></i> <p> Onlineshop <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=dasbor-OS" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Dasbor Penjualan</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=product-OS" class="nav-link"> <i class="fas fa-box-open nav-icon"></i> <p>Product</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=order-OS" class="nav-link"> <i class="fas fa-clipboard-list nav-icon"></i> <p>Pesanan</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=payment-OS" class="nav-link"> <i class="fas fa-money-bill-wave-alt nav-icon"></i> <p>Pembayaran</p> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="fas fa-building"></i> <p> Dashboard Office <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Pengumuman Marketing</p> </a> </li> <li class="nav-item"> <a href="" class="nav-link"> <i class="fas fa-box-open nav-icon"></i> <p>Pengumuman Surkom</p> </a> </li> <li class="nav-item"> <a href="" class="nav-link"> <i class="fas fa-clipboard-list nav-icon"></i> <p>Planing Jadwal</p> </a> </li> <li class="nav-item"> <a href="" class="nav-link"> <i class="fas fa-money-bill-wave-alt nav-icon"></i> <p>Kalender</p> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="nav-icon fas fa-folder"></i> <p> Master Database <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="#" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p> Produk <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=produk" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p>Produk</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=kategori" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p>Kategori</p> </a> </li> </ul> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=customer" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p>Customer</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=wilayah" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p>Wilayah</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=satuan" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p>Satuan</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=expedisi" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p>Expedisi</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=sales" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p>Sales</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=bank" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p>Bank</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=promo" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p> Promo </p> </a> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p> Supplier <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=supplier" class="nav-link"> <i class="far fa-dot-circle nav-icon"></i> <p>Supplier</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=data-supplier" class="nav-link"> <i class="far fa-dot-circle nav-icon"></i> <p>Data Supplier</p> </a> </li> </ul> </li> </ul> </li> <li class="nav-header">DATA PUSAT</li> <li class="nav-item"> <a href="pages/nsw/?halaman=coa" class="nav-link"> <i class="fas fa-book nav-icon"></i> <p> Master Perkiraan </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=jurnal" class="nav-link"> <i class="fas fa-cash-register nav-icon"></i> <p> Jurnal </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=bank-new" class="nav-link"> <i class="fas fa-university nav-icon"></i> <p> Bank </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=asset" class="nav-link"> <i class="fas fa-coins nav-icon"></i> <p> Asset </p> </a> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="fas fa-book-open nav-icon"></i> <p> Buku Kas <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=kas" class="nav-link"> <i class="far fa-circle nav-icon" style="font-size:15px"></i> <p>Daftar Kas</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=kas-bank" class="nav-link"> <i class="far fa-circle nav-icon" style="font-size:15px"></i> <p>Daftar Kas Bank</p> </a> </li> </ul> </li> <li class="nav-header">DATA CABANG</li> <li class="nav-item"> <a href="pages/nsw/?halaman=cabang" class="nav-link"> <i class="fas fa-clinic-medical nav-icon"></i> <p> Cabang </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=coa-cabang" class="nav-link"> <i class="fas fa-book nav-icon"></i> <p> Master Perkiraan </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=jurnal-cabang" class="nav-link"> <i class="fas fa-cash-register nav-icon"></i> <p> Jurnal </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=bank-cabang" class="nav-link"> <i class="fas fa-university nav-icon"></i> <p> Bank </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=asset-cabang" class="nav-link"> <i class="fas fa-coins nav-icon"></i> <p> Asset </p> </a> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="fas fa-book-open nav-icon"></i> <p> Buku Kas <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=kas-cabang" class="nav-link"> <i class="far fa-circle nav-icon" style="font-size:15px"></i> <p>Daftar Kas</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=kas-bank-cabang" class="nav-link"> <i class="far fa-circle nav-icon" style="font-size:15px"></i> <p>Daftar Kas Bank</p> </a> </li> </ul> </li> <li class="nav-header">PPIC</li> <li class="nav-item"> <a href="pages/nsw/?halaman=ppic" class="nav-link"> <i class="fab fa-envira nav-icon"></i> <p> PPIC </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=recycle-bin" class="nav-link"> <i class="fas fa-recycle nav-icon"></i> <p> Recycle Bin </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=bom" class="nav-link"> <i class="fab fa-envira nav-icon"></i> <p> BOM </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=quantation" class="nav-link"> <i class="fas fa-envelope-open nav-icon"></i> <p> Surat Penawaran </p> </a> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="nav-icon far fa-handshake"></i> <p> Transaksi <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=transaksi-SO" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>Sales Order (SO)</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=transaksi-FP" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>Faktur Penjualan (FP)</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=transaksi-SPB" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>SPB</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=transaksi-RJ" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>Retur Jual (RJ)</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=transaksi-WO" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>Working Order (WO)</p> </a> </li> <li class="nav-item"> <a href="" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>PBBP</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=transaksi-LHP" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>Laporan Hasil Produksi</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=transaksi-BPBP" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>Bukti Penerimaan Barang Pembelian (BPBP)</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=transaksi-PR" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>Purchase Request (PR)</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=transaksi-PO" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>Purchase Order (PO)</p> </a> </li> </ul> </li> '; } elseif ($level == 2) { return ' <li class="nav-item"> <a href="../../" class="nav-link active"> <i class="nav-icon fas fa-tachometer-alt"></i> <p> Dashboard </p> </a> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="nav-icon fas fa-shopping-bag"></i> <p> Onlineshop <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=dasbor-OS" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Dasbor Penjualan</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=product-OS" class="nav-link"> <i class="fas fa-box-open nav-icon"></i> <p>Product</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=order-OS" class="nav-link"> <i class="fas fa-clipboard-list nav-icon"></i> <p>Pesanan</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=payment-OS" class="nav-link"> <i class="fas fa-money-bill-wave-alt nav-icon"></i> <p>Pembayaran</p> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="fas fa-building"></i> <p> Dashboard Office <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Pengumuman Marketing</p> </a> </li> <li class="nav-item"> <a href="" class="nav-link"> <i class="fas fa-box-open nav-icon"></i> <p>Pengumuman Surkom</p> </a> </li> <li class="nav-item"> <a href="" class="nav-link"> <i class="fas fa-clipboard-list nav-icon"></i> <p>Planing Jadwal</p> </a> </li> <li class="nav-item"> <a href="" class="nav-link"> <i class="fas fa-money-bill-wave-alt nav-icon"></i> <p>Kalender</p> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="nav-icon fas fa-chart-line"></i> <p> Dashboard Report <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-sales" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Sales and Profitability</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-finance" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Finance</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-inventory" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Inventory</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-cfo" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>CFO</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-ceo" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>CEO</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-cashflow" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Cash Flow</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-budget-actual" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Budget vs Acutal</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-accounts-payable" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Accounts Payable </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-accounts-receivable" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Accounts Receivable </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-profit-margin" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Profit Margin </p> </a> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p> Yearly Comparison <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=yearly-comparison-report-jenis" class="nav-link"> <i class="far fa-dot-circle nav-icon"></i> <p>Jenis Produk</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=yearly-comparison-report-produk" class="nav-link"> <i class="far fa-dot-circle nav-icon"></i> <p>Produk</p> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p> KPI <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-kpi-monthly" class="nav-link"> <i class="far fa-dot-circle nav-icon"></i> <p>Monthly</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-kpi-ytd" class="nav-link"> <i class="far fa-dot-circle nav-icon"></i> <p>YTD</p> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p> Annual Report <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-AR-quater" class="nav-link"> <i class="far fa-dot-circle nav-icon"></i> <p>Quater</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-AR-month" class="nav-link"> <i class="far fa-dot-circle nav-icon"></i> <p>Month</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-AR-report" class="nav-link"> <i class="far fa-dot-circle nav-icon"></i> <p>Report</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-AR-income" class="nav-link"> <i class="far fa-dot-circle nav-icon"></i> <p>Income Statement</p> </a> </li> </ul> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-salesman" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Salesman</p> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="fas fa-server"></i> <p> Master Database <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="#" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p> Produk <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=produk" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p>Produk</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=stock" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p>Stock</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=kategori" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p>Kategori</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=satuan" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p>Satuan</p> </a> </li> </ul> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=sales" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p> Sales </p> </a> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p> Customer <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=customer" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p>Customer</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=data-customer" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p>Data Customer</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=wilayah" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p>Wilayah</p> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p> Markerting <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=promo" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p> Promo </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=promo" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p> Pameran & EVENT </p> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p> Supplier, Cargo & Transport <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=supplier" class="nav-link"> <i class="far fa-dot-circle nav-icon"></i> <p>Supplier</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=data-supplier" class="nav-link"> <i class="far fa-dot-circle nav-icon"></i> <p>Data Supplier</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=expedisi" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p>Expedisi</p> </a> </li> </ul> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="fas fa-database"></i> <p> MASTER PUSAT <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="#" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p> Bank <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=bank" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p>Bank Umum</p> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p> Rekening Perushaan <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=bank-new" class="nav-link"> <i class="fas fa-university nav-icon"></i> <p> My Rekening </p> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="far fa-circle nav-icon"></i> <p> Master Perkiraan <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=coa" class="nav-link"> <i class="fas fa-book nav-icon"></i> <p> Master COA </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=coa" class="nav-link"> <i class="fas fa-book nav-icon"></i> <p> Input Perkiraan </p> </a> </li> </ul> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=jurnal" class="nav-link"> <i class="fas fa-cash-register nav-icon"></i> <p> Jurnal </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=asset" class="nav-link"> <i class="fas fa-coins nav-icon"></i> <p> Asset </p> </a> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="fas fa-book-open nav-icon"></i> <p> Buku Kas <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=kas" class="nav-link"> <i class="far fa-circle nav-icon" style="font-size:15px"></i> <p>Daftar Kas</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=kas-bank" class="nav-link"> <i class="far fa-circle nav-icon" style="font-size:15px"></i> <p>Daftar Kas Bank</p> </a> </li> </ul> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="fas fa-code-branch"></i> <p> MASTER CABANG <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=cabang" class="nav-link"> <i class="fas fa-clinic-medical nav-icon"></i> <p> Cabang </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=coa-cabang" class="nav-link"> <i class="fas fa-book nav-icon"></i> <p> Master Perkiraan </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=jurnal-cabang" class="nav-link"> <i class="fas fa-cash-register nav-icon"></i> <p> Jurnal </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=bank-cabang" class="nav-link"> <i class="fas fa-university nav-icon"></i> <p> Bank </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=asset-cabang" class="nav-link"> <i class="fas fa-coins nav-icon"></i> <p> Asset </p> </a> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="fas fa-book-open nav-icon"></i> <p> Buku Kas <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=kas-cabang" class="nav-link"> <i class="far fa-circle nav-icon" style="font-size:15px"></i> <p>Daftar Kas</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=kas-bank-cabang" class="nav-link"> <i class="far fa-circle nav-icon" style="font-size:15px"></i> <p>Daftar Kas Bank</p> </a> </li> </ul> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="fas fa-money-check-alt nav-icon"></i> <p> PROSES GIRO <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=giro-masuk" class="nav-link"> <i class="far fa-circle nav-icon" style="font-size:15px"></i> <p>Giro Masuk</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=giro-keluar" class="nav-link"> <i class="far fa-circle nav-icon" style="font-size:15px"></i> <p>Giro Keluar</p> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="nav-icon far fa-handshake"></i> <p> Transaksi Pembelian <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=transaksi-PR" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>Purchase Request (PR)</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=pemesanan-barang" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>SPBD</p> </a> </li> <li class="nav-item"> <a href="" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>PBBP</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=transaksi-PO" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>Purchase Order (PO)</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=transaksi-BPBP" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>Bukti Penerimaan Barang Pembelian (BPBP)</p> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="fas fa-cash-register"></i> <p> Transaksi Penjualan <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=transaksi-RJ" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>Retur Jual (RJ)</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=quantation" class="nav-link"> <i class="fas fa-envelope-open nav-icon"></i> <p> Surat Penawaran </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=transaksi-SO" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>Sales Order (SO)</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=transaksi-FP" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>Faktur Penjualan (FP)</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=transaksi-SPB" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>SPB</p> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="fas fa-truck-loading"></i> <p> Transaksi Produksi <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=ppic" class="nav-link"> <i class="fab fa-envira nav-icon"></i> <p> PPIC </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=bom" class="nav-link"> <i class="fab fa-envira nav-icon"></i> <p> BOM </p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=transaksi-WO" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>Working Order (WO)</p> </a> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=transaksi-LHP" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>Laporan Hasil Produksi</p> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="fas fa-hand-holding-usd"></i> <p> Payroll <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=karyawan" class="nav-link"> <i class="fas fa-users"></i> <p> Data Karyawan </p> </a> </li> </ul> </li> <li class="nav-item"> <a href="pages/nsw/?halaman=recycle-bin" class="nav-link"> <i class="fas fa-recycle nav-icon"></i> <p> Recycle Bin </p> </a> </li> '; } elseif ($level == 3) { return ' <li class="nav-item"> <a href="#" class="nav-link"> <i class="nav-icon fas fa-tachometer-alt"></i> <p> Dashboard </p> </a> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="nav-icon fas fa-chart-line"></i> <p> Other Dashboard <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=dashboard-salesman" class="nav-link"> <i class="fas fa-chart-line nav-icon"></i> <p>Salesman </p> </a> </li> </ul> </li> <li class="nav-item"> <a href="#" class="nav-link"> <i class="nav-icon far fa-handshake"></i> <p> Transaksi <i class="right fas fa-angle-left"></i> </p> </a> <ul class="nav nav-treeview"> <li class="nav-item"> <a href="pages/nsw/?halaman=transaksi-SO" class="nav-link"> <i class="fas fa-minus nav-icon"></i> <p>Sales Order (SO)</p> </a> </li> </ul> </li> '; } } function content_header() { if (@$_GET['halaman'] == "kategori") { return "<h1>Halaman Master Kategori<h1>"; } elseif (@$_GET['halaman'] == "setting_account") { return "<h1>Settings<h1>"; } elseif (@$_GET['halaman'] == "customer") { return "<h1>Halaman Master Customer<h1>"; } elseif (@$_GET['halaman'] == 'wilayah') { return "<h1>Halaman Master Wilayah<h1>"; } elseif (@$_GET['halaman'] == 'satuan') { return "<h1>Halaman Master Satuan<h1>"; } elseif (@$_GET["halaman"] == "dashboard-sales") { return "<h1>Dashboard Sales and Profitability<h1>"; } elseif (@$_GET["halaman"] == "dashboard-finance") { return "<h1>Dashboard Finance<h1>"; } elseif (@$_GET["halaman"] == "dashboard-inventory") { return "<h1>Dashboard Inventory<h1>"; } elseif (@$_GET["halaman"] == "dashboard-cfo") { return "<h1>Dashboard CFO<h1>"; } elseif (@$_GET["halaman"] == "dashboard-ceo") { return "<h1>Dashboard CEO<h1>"; } elseif (@$_GET["halaman"] == "dashboard-cashflow") { return "<h1>Dashboard Cash Flow<h1>"; } elseif (@$_GET["halaman"] == "dashboard-budget-actual") { return "<h1>Dashboard Budget vs Acutal<h1>"; } elseif (@$_GET["halaman"] == "dashboard-accounts-payable") { return "<h1>Dashboard Accounts Payable<h1>"; } elseif (@$_GET["halaman"] == "dashboard-accounts-receivable") { return "<h1>Dashboard Accounts Receivable<h1>"; } elseif (@$_GET["halaman"] == "dashboard-profit-margin") { return "<h1>Dashboard Profit Margin<h1>"; } elseif (@$_GET["halaman"] == "dashboard-kpi-monthly") { return "<h1>Dashboard KPI Monthly<h1>"; } elseif (@$_GET["halaman"] == "dashboard-kpi-ytd") { return "<h1>Dashboard KPI YTD<h1>"; } elseif (@$_GET["halaman"] == "dashboard-AR-quater") { return "<h1>Dashboard Annual Report Quater<h1>"; } elseif (@$_GET["halaman"] == "dashboard-AR-month") { return "<h1>Dashboard Annual Report Month<h1>"; } elseif (@$_GET["halaman"] == "dashboard-AR-report") { return "<h1>Dashboard Annual Report<h1>"; } elseif (@$_GET["halaman"] == "dashboard-AR-income") { return "<h1>Dashboard Annual Report Income<h1>"; } elseif (@$_GET['halaman'] == 'dasbor-OS') { return "<h1>Halaman Dasbor Penjualan<h1>"; } elseif (@$_GET['halaman'] == 'product-OS') { return "<h1>Halaman Product Onlineshop<h1>"; } elseif (@$_GET['detail-productOS']) { return "<h1>Halaman Detail Produk Onlineshop<h1>"; } elseif (@$_GET['halaman'] == 'order-OS') { return "<h1>Halaman Order Onlineshop<h1>"; } elseif (@$_GET['detail-orderOS']) { return "<h1>Halaman Detail Pesanan Onlineshop<h1>"; } elseif (@$_GET['invoice-orderOS']) { return "<h1>Halaman Invoice Pesanan Onlineshop<h1>"; } elseif (@$_GET['halaman'] == 'payment-OS') { return "<h1>Halaman Payment Onlineshop<h1>"; } elseif (@$_GET['edit-wilayah']) { return "<h1>Halaman Edit Kode Wilayah<h1>"; } elseif (@$_GET['halaman'] == 'produk' || @$_GET['produk-kategori']) { return "<h1>Halaman Produk<h1>"; } elseif (@$_GET['detail-produk']) { return "<h1>Halaman Detail Produk<h1>"; } elseif (@$_GET['detail-customer']) { return "<h1>Halaman Detail Customer<h1>"; } elseif (@$_GET["halaman"] == "bom") { return "<h1>Halaman BOM (Bill of Material)<h1>"; } elseif (@$_GET["bom-detail"]) { return "<h1>Halaman Detail BOM (Bill of Material)<h1>"; } elseif (@$_GET["halaman"] == "transaksi-LHP") { return "<h1>Laporan Hasil Produksi<h1>"; } elseif (@$_GET["invoice-LHP"]) { return "<h1>Data Laporan Hasil Produksi<h1>"; } elseif (@$_GET["halaman"] == "transaksi-FP") { return "<h1>Faktur Penjualan<h1>"; } elseif (@$_GET["invoice-FP"]) { return "<h1>Data Faktur Penjualan<h1>"; } elseif (@$_GET["halaman"] == "transaksi-BPBP") { return "<h1>Bukti Penerimaan Barang Pembelian (BPBP)<h1>"; } elseif (@$_GET["halaman"] == "transaksi-RJ" || @$_GET["invoice-RJ"]) { return "<h1>Retur Jual (RJ)<h1>"; } elseif (@$_GET["halaman"] == "transaksi-WO" || @$_GET["invoice-WO"]) { return "<h1>Working Order (WO)<h1>"; } elseif (@$_GET["halaman"] == "transaksi-PR" || @$_GET["invoice-PR"]) { return "<h1>Purchase Request (PR)<h1>"; } elseif (@$_GET["halaman"] == "transaksi-PO" || @$_GET["invoice-PO"]) { return "<h1>Purchase Order (PO)<h1>"; } elseif (@$_GET["invoice-BPBP"]) { return "<h1>Data Bukti Penerimaan Barang Pembelian<h1>"; } elseif (@$_GET["halaman"] == "expedisi") { return "<h1>Halaman Expedisi<h1>"; } elseif (@$_GET["expedisi-detail"]) { return "<h1>Halaman Detail Expedisi<h1>"; } elseif (@$_GET["halaman"] == "status-customer") { return "<h1>Halaman Status Customer<h1>"; } elseif (@$_GET["halaman"] == "type-customer") { return "<h1>Halaman Tipe Customer<h1>"; } elseif (@$_GET["halaman"] == "sales" || @$_GET["sales-detail"]) { return "<h1>Halaman Sales<h1>"; } elseif (@$_GET["halaman"] == "promo") { return "<h1>Halaman Promo<h1>"; } else { return "Halaman kosong"; } } function diskon_jenis() { $isi = []; $a = query("SELECT * FROM diskon_jenis WHERE id_diskon_jenis <> 0"); while ($b = query_banyak($a)) { $isi[] = $b; } return $isi; } function diskon_detail($id, $kode) { $a = query_satu("SELECT * FROM diskon, diskon_jenis, diskon_tipe WHERE diskon.id_diskon = '$id' AND diskon_jenis.id_diskon_jenis = diskon.id_diskon_jenis AND diskon_tipe.id_diskon_tipe = diskon.id_diskon_tipe"); return $a[$kode]; } function produk() { $i = []; $a = query("SELECT * FROM produk, kategori, kategori_jenis, kategori_header WHERE kategori.id_kategori = produk.id_kategori AND kategori_jenis.id_kategori_jenis = kategori.id_kategori_jenis AND kategori_header.id_kategori_header = kategori.id_kategori_header ORDER BY produk.sku DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function produk_urutan() { return query("SELECT * FROM produk LIMIT 1"); } function produk_stok() { $i = []; $a = query("SELECT * FROM produk, kategori, kategori_jenis, kategori_header WHERE kategori.id_kategori = produk.id_kategori AND kategori_jenis.id_kategori_jenis = kategori.id_kategori_jenis AND kategori_header.id_kategori_header = kategori.id_kategori_header AND produk.stok_produk <> 0 ORDER BY produk.sku DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function satuan_all() { return query("SELECT * FROM satuan"); } function produk_isi_satuan_jum($id) { return jumlah("SELECT * FROM produk_isi_satuan WHERE id_produk = '$id'"); } function produk_isi_satuan_akhir($id, $y) { $a = query_satu("SELECT * FROM produk_isi_satuan WHERE id_produk = '$id' ORDER BY id DESC LIMIT 1"); return @$a[$y]; } function produk_isi_satuan_awal($id, $y) { $a = query_satu("SELECT * FROM produk_isi_satuan WHERE id_produk = '$id' ORDER BY id ASC LIMIT 1"); return $a[$y]; } function produk_isi_satuan($id) { $i = []; $a = query("SELECT * FROM produk_isi_satuan WHERE id_produk = '$id' ORDER BY id ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function produk_isi_satuan_kebalik($id) { $i = []; $a = query("SELECT * FROM produk_isi_satuan WHERE id_produk = '$id' ORDER BY id DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function produk_isi_satuan_all($id, $o) { return query("SELECT * FROM produk_isi_satuan LIMIT $id, $o"); } function produk_isi_satuan_alla() { return query("SELECT * FROM produk_isi_satuan"); } function produk_isi_satuan_kecuali($id, $y) { return query("SELECT * FROM produk_isi_satuan WHERE id_produk = '$id' AND id_satuan <> '$y' ORDER BY id ASC"); } function produk_isi_satuan_kecuali_kebalik($id, $y) { return query("SELECT * FROM produk_isi_satuan WHERE id_produk = '$id' AND id_satuan <> '$y' ORDER BY id DESC"); } function produk_isi_satuan_jum_jq($id, $y) { return jumlah("SELECT * FROM produk_isi_satuan, satuan, jenis_qty WHERE satuan.id_satuan = produk_isi_satuan.id_satuan AND jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND jenis_qty.id_jenis_qty = '$y' AND produk_isi_satuan.id_produk = '$id'"); } function produk_isi_satuan_kedua($id) { $a = []; foreach (produk_isi_satuan($id) as $pis) : $a[] = $pis["id_satuan"]; endforeach; return $a[1]; } function produk_sisa_produksi_satu($id, $o, $n) { $a = query_satu("SELECT * FROM produk_sisa_produksi WHERE id_produk = '$id' AND id_satuan = '$o'"); return @$a[$n]; } function produk_sisa_produksi_jum($id, $o) { return jumlah("SELECT * FROM produk_sisa_produksi WHERE id_produk = '$id' AND id_satuan = '$o' AND jumlah != 0"); } function produk_sisa_produksi_jumlah($id, $o) { return jumlah("SELECT * FROM produk_sisa_produksi WHERE id_produk = '$id' AND id_satuan = '$o'"); } function produk_sisa_produksi_riwayat_id($id, $o, $y) { $a = query_satu("SELECT id FROM produk_sisa_produksi_riwayat WHERE id_produk = '$id' AND tgl = '$o' AND id_user = '$y'"); return $a["id"]; } function produk_sisa_produksi_riwayat_satu($id, $o) { $a = query_satu("SELECT * FROM produk_sisa_produksi_riwayat WHERE id = '$id'"); return $a[$o]; } function produk_link_bsj_jum($id) { return jumlah("SELECT * FROM produk_link_bsj WHERE id_produk_utama = '$id'"); } function produk_link_bsj_satu($id, $o) { $a = query_satu("SELECT * FROM produk_link_bsj WHERE id_produk_utama = '$id'"); return @$a[$o]; } function produk_nama_jum($id) { return jumlah("SELECT * FROM produk WHERE nama_produk = '$id'"); } function kategori() { $i = []; $a = query("SELECT * FROM kategori, kategori_header, kategori_jenis WHERE kategori_header.id_kategori_header = kategori.id_kategori_header AND kategori_jenis.id_kategori_jenis = kategori.id_kategori_jenis"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function kategori_kecuali($id) { $i = []; $a = query("SELECT * FROM kategori, kategori_header, kategori_jenis WHERE kategori_header.id_kategori_header = kategori.id_kategori_header AND kategori_jenis.id_kategori_jenis = kategori.id_kategori_jenis AND kategori.id_kategori <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function kategori_satu($id, $ok) { $a = query_satu("SELECT * FROM kategori WHERE id_kategori = '$id'"); return $a[$ok]; } function kategori_header_satu($id, $ok) { $a = query_satu("SELECT * FROM kategori_header WHERE id_kategori_header = '$id'"); return $a[$ok]; } function kategori_header() { return query("SELECT * FROM kategori_header"); } function diskon_produk_gratis($id) { $i = []; $a = query("SELECT * FROM diskon_produk_gratis, produk_satuan, satuan, produk WHERE diskon_produk_gratis.id_diskon = '$id' AND produk_satuan.id_produk_satuan = diskon_produk_gratis.id_produk_satuan AND satuan.id_satuan = produk_satuan.id_satuan AND produk.id_produk = diskon_produk_gratis.id_produk"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function diskon() { $i = []; $a = query("SELECT * FROM diskon, diskon_jenis, diskon_tipe WHERE diskon_jenis.id_diskon_jenis = diskon.id_diskon_jenis AND diskon_tipe.id_diskon_tipe = diskon.id_diskon_tipe"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function diskon_target($id, $oke) { $a = query_satu("SELECT * FROM diskon_target, diskon_target_jenis WHERE diskon_target.id_diskon = '$id' AND diskon_target_jenis.id_diskon_target_jenis = diskon_target.id_diskon_target_jenis"); return $a[$oke]; } function diskon_target_jenis() { $i = []; $a = query("SELECT * FROM diskon_target_jenis"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function diskon_target_jenis_kecuali($id) { $i = []; $a = query("SELECT * FROM diskon_target_jenis WHERE id_diskon_target_jenis <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function diskon_produk_jenis() { $i = []; $a = query("SELECT * FROM diskon_produk_jenis"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function diskon_produk($id) { $i = []; $a = query("SELECT * FROM diskon_produk, diskon_produk_jenis WHERE diskon_produk.id_diskon = '$id' AND diskon_produk_jenis.id_diskon_produk_jenis = diskon_produk.id_diskon_produk_jenis"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function hari() { $i = []; $a = query("SELECT * FROM hari ORDER BY id_hari ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function seller() { $i = []; $a = query("SELECT * FROM seller"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function seller_satu($id, $ok) { $a = query_satu("SELECT * FROM seller WHERE id_seller = '$id'"); return @$a[$ok]; } function seller_kecuali($id) { $i = []; $a = query("SELECT * FROM seller WHERE id_seller <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function merk() { $i = []; $a = query("SELECT * FROM merk WHERE id_merk <> 0"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function merk_satu($id, $y) { $a = query_satu("SELECT * FROM merk WHERE id_merk = '$id'"); return $a[$y]; } function merk_kecuali($id) { $i = []; $a = query("SELECT * FROM merk WHERE id_merk <> 0 AND id_merk <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function pabrik_produk() { $i = []; $a = query("SELECT * FROM pabrik WHERE id_pabrik <> 0"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function pabrik_kecuali($id) { $i = []; $a = query("SELECT * FROM pabrik WHERE id_pabrik <> 0 AND id_pabrik <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function pabrik_satu($id, $y) { $a = query_satu("SELECT * FROM pabrik WHERE id_pabrik = '$id'"); return $a[$y]; } function kategori_jenis() { $i = []; $a = query("SELECT * FROM kategori_jenis WHERE id_kategori_jenis <> 0"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function diskon_cust($id) { $i = []; $a = query("SELECT * FROM diskon_cust, diskon_cust_jenis WHERE diskon_cust.id_diskon = '$id' AND diskon_cust_jenis.id_diskon_cust_jenis = diskon_cust.id_diskon_cust_jenis"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function diskon_cust_jenis() { $i = []; $a = query("SELECT * FROM diskon_cust_jenis"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function customer() { $i = []; $a = query("SELECT * FROM customer"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function customer_satu($id, $o) { $a = query_satu("SELECT * FROM customer WHERE id_customer = '$id'"); return @$a[$o]; } function customer_kil_pilih() { return query("SELECT * FROM customer WHERE id_customer NOT IN(SELECT id_customer FROM kil_customer)"); } function customer_lihat($id, $oke) { $a = query_satu("SELECT * FROM customer, customer_alamat WHERE customer.id_customer = '$id' AND customer_alamat.id_customer = customer.id_customer AND customer_alamat.utama = 1"); return @$a[$oke]; } function customer_tipe() { $i = []; $a = query("SELECT * FROM customer_tipe"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function customer_status() { $i = []; $a = query("SELECT * FROM customer_status, seller WHERE seller.id_seller = customer_status.id_seller"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function customer_status_satu($id, $ok) { $a = query_satu("SELECT * FROM customer_status WHERE kode_customer_status = '$id'"); return @$a[$ok]; } function customer_search($id) { return query("SELECT * FROM customer, customer_tipe, customer_status WHERE customer_tipe.kode_customer_tipe = customer.kode_customer_tipe AND customer_status.kode_customer_status = customer.kode_customer_status AND customer.kode_customer LIKE '%$id%' OR customer_tipe.kode_customer_tipe = customer.kode_customer_tipe AND customer_status.kode_customer_status = customer.kode_customer_status AND customer.nama_customer LIKE '%$id%' OR customer_tipe.kode_customer_tipe = customer.kode_customer_tipe AND customer_status.kode_customer_status = customer.kode_customer_status AND customer_tipe.nama_customer_tipe LIKE '%$id%' OR customer_tipe.kode_customer_tipe = customer.kode_customer_tipe AND customer_status.kode_customer_status = customer.kode_customer_status AND customer_status.nama_customer_status LIKE '%$id%'"); } function customer_telp($id) { return query("SELECT * FROM customer_telp WHERE id_customer = '$id'"); } function customer_kecuali($id) { return query("SELECT * FROM customer WHERE id_customer != '$id'"); } function diskon_jumlah($id, $kode) { $a = query_satu("SELECT * FROM diskon_jumlah WHERE id_diskon = '$id'"); return $a[$kode]; } function prov_lihat($id, $oke) { $a = query_satu("SELECT * FROM provinces WHERE id = '$id'"); return @$a[$oke]; } function kab_lihat($id, $oke) { $a = query_satu("SELECT * FROM regencies WHERE id = '$id'"); return @$a[$oke]; } function kec_lihat($id, $oke) { $a = query_satu("SELECT * FROM districts WHERE id = '$id'"); return @$a[$oke]; } function kel_lihat($id, $oke) { $a = query_satu("SELECT * FROM villages WHERE id = '$id'"); return @$a[$oke]; } function expedisi_contact($id) { $i = []; $a = query("SELECT * FROM expedisi_contact, expedisi_posisi WHERE expedisi_contact.id_expedisi_alamat = '$id' AND expedisi_posisi.id_expedisi_posisi = expedisi_contact.id_expedisi_posisi"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function expired($id, $kode) { if ($id == 1) { $jj = date("Y-m-d"); if ($jj > $kode) { return ' <span class="badge bg-danger">Expired</span> '; } else { $tgl1 = strtotime(date("Y-m-d")); $tgl2 = strtotime($kode); $jarak = $tgl2 - $tgl1; $hari = $jarak / 60 / 60 / 24; if ($hari > 30 and $hari < 360) { $thari = round($hari / 30, 1) . ' bulan'; } elseif ($hari > 360) { $thari = round($hari / 30 / 12, 1) . ' tahun'; } else { $thari = $hari . ' hari'; } return ' <span class="badge bg-success">' . $thari . '</span> '; } } else { return '<span class="badge bg-info">Nothing</span>'; } } function expired2($id, $kode) { if ($id == 1) { $jj = date("Y-m-d"); if ($jj > $kode) { return false; } else { $tgl1 = strtotime(date("Y-m-d")); $tgl2 = strtotime($kode); $jarak = $tgl2 - $tgl1; $hari = $jarak / 60 / 60 / 24; if ($hari > 30 and $hari < 360) { $thari = round($hari / 30, 1) . ' bulan'; } elseif ($hari > 360) { $thari = round($hari / 30 / 12, 1) . ' tahun'; } else { $thari = $hari . ' hari'; } return true; } } else { return true; } } function expedisi_alamat() { $i = []; $a = query("SELECT * FROM expedisi_alamat, expedisi, provinces, expedisi_tipe WHERE expedisi.id_expedisi = expedisi_alamat.id_expedisi AND provinces.id = expedisi_alamat.id_provinsi AND expedisi_tipe.id_expedisi_tipe = expedisi.id_expedisi_tipe ORDER BY expedisi.id_expedisi ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function expedisi_alamat_kab_jum($id, $ok) { return jumlah("SELECT * FROM expedisi_alamat WHERE id_expedisi = '$id' AND id_kabupaten = '$ok'"); } function expedisi_alamat_kab($id, $ok, $yes) { $a = query_satu("SELECT * FROM expedisi_alamat WHERE id_expedisi = '$id' AND id_kabupaten = '$ok'"); return $a[$yes]; } function expedisi_alamat_kec_jum($id, $ok) { return jumlah("SELECT * FROM expedisi_alamat WHERE id_expedisi = '$id' AND id_kecamatan = '$ok'"); } function expedisi_alamat_kec($id, $ok, $yes) { $a = query_satu("SELECT * FROM expedisi_alamat WHERE id_expedisi = '$id' AND id_kecamatan = '$ok'"); return $a[$yes]; } function expedisi_ongkir($id, $id2, $id3) { $i = []; $a = query("SELECT * FROM expedisi_alamat, expedisi WHERE expedisi.id_expedisi = expedisi_alamat.id_expedisi AND expedisi_alamat.id_expedisi_alamat NOT IN(SELECT id_expedisi_alamat FROM expedisi_ongkir WHERE id_kecamatan = '$id' AND id_kabupaten = '$id2' AND id_provinsi = '$id3')"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function ongkir_satu($id, $o) { $a = query_satu("SELECT * FROM ongkir WHERE id_ongkir = '$id'"); return @$a[$o]; } function sales_grup() { $i = []; $a = query("SELECT * FROM sales_grup, sales, sales_jab, sales_alamat WHERE sales.id_sales = sales_grup.id_sales AND sales_grup.status_sales_grup = 1 AND sales_jab.id_sales_jab = sales_grup.id_sales_jab AND sales_alamat.id_sales = sales.id_sales AND sales_alamat.alamat_utama = 1"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function sales_satu($id, $oke) { $a = query_satu("SELECT * FROM sales WHERE id_sales = '$id'"); return $a[$oke]; } function sales_hp_satu($id, $oke) { $a = query_satu("SELECT * FROM sales_hp WHERE id_sales = '$id'"); return $a[$oke]; } function sales_hp($id) { $i = []; $a = query("SELECT * FROM sales_hp WHERE id_sales = '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function sales_photo_jumlah($id) { $a = jumlah("SELECT * FROM sales_photo WHERE id_sales = '$id'"); return $a; } function sales_photo_satu($id, $kode) { $a = query_satu("SELECT * FROM sales_photo WHERE id_sales = '$id' AND utama = 1"); return $a[$kode]; } function sales_kecuali($id) { return query("SELECT * FROM sales WHERE id_sales != '$id'"); } function grup() { $i = []; // $a = query("SELECT * FROM grup, // market, // sales_grup, // sales, // sales_jab // WHERE // market.id_market = grup.id_market AND // sales_grup.id_grup = grup.id_grup AND // sales_grup.status_sales_grup = 1 AND // sales_grup.pimpinan = 1 AND // sales.id_sales = sales_grup.id_sales AND // sales_jab.id_sales_jab = sales_grup.id_sales_jab // ORDER BY grup.id_market DESC"); $a = query("SELECT * FROM grup, market WHERE market.id_market = grup.id_market"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function grup_pimpinan($id, $oke) { $a = query_satu("SELECT * FROM sales_grup WHERE id_grup = '$id' AND status_sales_grup = '1'"); return $a[$oke]; } function grup_pimpinan_jumlah($id) { return jumlah("SELECT * FROM sales_grup WHERE id_grup = '$id' AND pimpinan = 1 AND status_sales_grup = 1"); } function grup_pimpinan_all($id) { $cek_pim_isi = []; $cek_pim = query("SELECT * FROM sales_grup, sales, sales_jab WHERE sales_grup.id_grup = '$id' AND sales_grup.status_sales_grup = 1 AND sales_grup.kepala = 1 AND sales.id_sales = sales_grup.id_sales AND sales_jab.id_sales_jab = sales_grup.id_sales_jab"); while ($l_cek_pim = query_banyak($cek_pim)) { $cek_pim_isi[] = $l_cek_pim; } return $cek_pim_isi; } function grup_anggota($id) { $i = []; $a = query("SELECT * FROM sales_grup, sales WHERE sales_grup.id_grup = '$id' AND sales_grup.kepala = 0 AND sales_grup.status_sales_grup = 1 AND sales.id_sales = sales_grup.id_sales LIMIT 5"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function sales() { $i = []; $a = query("SELECT * FROM sales WHERE id_sales NOT IN(SELECT id_sales FROM sales_grup)"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function sales_all() { $i = []; $a = query("SELECT * FROM sales, sales_jenis WHERE sales_jenis.id_sales_jenis = sales.id_sales_jenis"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function sales_alamat($id, $oke) { $a = query_satu("SELECT * FROM sales_alamat, villages WHERE sales_alamat.id_sales = '$id' AND sales_alamat.alamat_utama = 1 AND villages.id = sales_alamat.id_kelurahan"); return $a[$oke]; } function sales_jab() { $i = []; $a = query("SELECT * FROM sales_jab ORDER BY nama_sales_jab ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function sales_jab_isi($id, $oke) { $a = query_satu("SELECT * FROM sales_jab WHERE id_sales_jab = '$id'"); return $a[$oke]; } function grup_detail($id, $oke) { $a = query_satu("SELECT * FROM grup, sales_grup, sales, sales_jab WHERE grup.id_grup = '$id' AND sales_grup.id_grup = grup.id_grup AND sales.id_sales = sales_grup.id_sales AND sales_jab.id_sales_jab = sales_jab.id_sales_jab AND sales_grup.pimpinan = 1 AND sales_grup.status_sales_grup = 1"); return $a[$oke]; } function grup_isi($id, $oke) { $a = query_satu("SELECT * FROM grup WHERE id_grup = '$id'"); return $a[$oke]; } function grup_kecuali($id) { $i = []; $a = query("SELECT * FROM grup WHERE id_grup <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function grup_wilayah($id) { $i = []; $a = query("SELECT * FROM grup_wilayah WHERE id_grup = '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function grup_wilayah_jumlah_all($id) { return jumlah("SELECT * FROM grup_wilayah WHERE id_grup = '$id'"); } function sales_wilayah($id) { $i = []; $a = query("SELECT * FROM sales_wilayah WHERE id_sales_grup = '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function sales_wilayah_header($id) { $i = []; $a = query("SELECT * FROM sales_wilayah_header, sales_grup, sales WHERE sales_wilayah_header.id_sales_wilayah = '$id' AND sales_grup.id_sales_grup = sales_wilayah_header.id_sales_grup AND sales.id_sales = sales_grup.id_sales AND sales_grup.status_sales_grup = 1"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function sales_wilayah_header_all() { $i = []; $a = query("SELECT * FROM sales_wilayah_header, sales_grup, sales, grup WHERE sales_grup.id_sales_grup = sales_wilayah_header.id_sales_grup AND sales.id_sales = sales_grup.id_sales AND grup.id_grup = sales_grup.id_grup"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function sales_wilayah_detail($id) { $i = []; $a = query("SELECT * FROM sales_wilayah_detail, villages WHERE sales_wilayah_detail.id_sales_wilayah_header = '$id' AND villages.id = sales_wilayah_detail.id_kelurahan"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function sales_cust($id) { $i = []; $a = query("SELECT * FROM sales_cust, customer, customer_alamat WHERE sales_cust.id_grup_wilayah_sales = '$id' AND customer.id_customer = sales_cust.id_customer AND customer_alamat.id_customer = customer.id_customer AND utama = 1"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function sales_cust_jumlah($id) { return jumlah("SELECT * FROM sales_cust WHERE id_grup_wilayah_sales = '$id'"); } function sales_cust_jumlah_all($id) { $a = jumlah("SELECT * FROM sales_cust, grup_wilayah_sales WHERE grup_wilayah_sales.id_grup_wilayah_sales = sales_cust.id_grup_wilayah_sales AND grup_wilayah_sales.id_grup_wilayah = '$id' AND grup_wilayah_sales.status = 1"); echo $a; } function jumlah_diskon_sales($id) { return jumlah("SELECT * FROM diskon_sales WHERE id_diskon = '$id'"); } function jumlah_diskon_wilayah($id) { return jumlah("SELECT * FROM diskon_wilayah WHERE id_diskon = '$id'"); } function diskon_sales_aktif() { $i = []; $a = query("SELECT * FROM sales_grup, sales, sales_jab, grup WHERE sales_grup.status_sales_grup = 1 AND sales.id_sales = sales_grup.id_sales AND sales_jab.id_sales_jab = sales_grup.id_sales_jab AND grup.id_grup = sales_grup.id_grup AND sales_grup.id_sales ORDER BY grup.nama_grup"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function diskon_sales($id) { $i = []; $a = query("SELECT * FROM diskon_sales, diskon_sales_jenis WHERE diskon_sales.id_diskon = '$id' AND diskon_sales_jenis.id_diskon_sales_jenis = diskon_sales.id_diskon_sales_jenis"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function diskon_wilayah() { $i = []; $a = query("SELECT * FROM kode_customer ORDER BY kode_cust"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function diskon_wilayah_detail($id) { $i = []; $a = query("SELECT * FROM diskon_wilayah, kode_customer WHERE diskon_wilayah.id_diskon = '$id' AND kode_customer.id_kode_customer = diskon_wilayah.id_kode_customer"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function diskon_sales_jenis() { $i = []; $a = query("SELECT * FROM diskon_sales_jenis"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function bank() { $i = []; $a = query("SELECT * FROM bank WHERE id_bank NOT IN(SELECT kode FROM recycle WHERE id_recycle_jenis = 8) ORDER BY edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function bank_kecuali($id) { $i = []; $a = query("SELECT * FROM bank WHERE id_bank <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function bank_coa_aktiva($id, $ok) { $a = query_satu("SELECT * FROM bank_coa, coa WHERE bank_coa.id_rekening = '$id' AND bank_coa.id_bank_coa_jenis = 1 AND coa.id_coa = bank_coa.id_coa"); return $a[$ok]; } function bank_coa_passiva($id, $ok) { $a = query_satu("SELECT * FROM bank_coa, coa WHERE bank_coa.id_rekening = '$id' AND bank_coa.id_bank_coa_jenis = 2 AND coa.id_coa = bank_coa.id_coa"); return $a[$ok]; } function bank_satu($id, $ok) { $a = query_satu("SELECT * FROM bank WHERE id_bank = '$id'"); return $a[$ok]; } function jumlah_sales_anggota($id) { return jumlah("SELECT * FROM sales_wilayah_header WHERE id_sales_grup = '$id'"); } function jumlah_sales_wilayah($id) { return jumlah("SELECT * FROM sales_wilayah WHERE id_sales_grup = '$id'"); } function jumlah_sales_grup($id) { return jumlah("SELECT * FROM sales_grup, grup_wilayah_sales WHERE status_sales_grup = 1 AND grup_wilayah_sales.id_sales_grup = sales_grup.id_sales_grup AND grup_wilayah_sales.id_grup_wilayah = '$id'"); } function sales_grup_detail($id, $oke) { $a = query_satu("SELECT * FROM sales_grup, grup, sales, sales_jab WHERE sales_grup.id_sales_grup = '$id' AND grup.id_grup = sales_grup.id_grup AND sales.id_sales = sales_grup.id_sales AND sales_jab.id_sales_jab = sales_grup.id_sales_jab"); return $a[$oke]; } function sales_grup_jumlah_isi($id) { return jumlah("SELECT * FROM sales_grup WHERE id_sales = '$id' AND pimpinan = 1 AND status_sales_grup = 1"); } function suplier() { $i = []; $a = query("SELECT * FROM suplier, suplier_jenis WHERE suplier_jenis.id_suplier_jenis = suplier.id_suplier_jenis ORDER BY suplier.nama_suplier ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function suplier_pilih($id) { $i = []; $a = query("SELECT * FROM suplier, suplier_jenis WHERE suplier.id_suplier_jenis = '$id' AND suplier_jenis.id_suplier_jenis = suplier.id_suplier_jenis"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function suplier_email($id) { $i = []; $a = query("SELECT * FROM suplier_email WHERE id_suplier = '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function suplier_contact($id) { $i = []; $a = query("SELECT * FROM suplier_contact WHERE id_suplier = '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function suplier_detail($id, $oke) { $a = query_satu("SELECT * FROM suplier, suplier_jenis WHERE suplier.id_suplier = '$id' AND suplier_jenis.id_suplier_jenis = suplier.id_suplier_jenis"); return $a[$oke]; } function suplier_alamat($id, $oke) { $a = query_satu("SELECT * FROM suplier_alamat WHERE id_suplier = '$id'"); return @$a[$oke]; } function suplier_rekening($id) { $i = []; $a = query("SELECT * FROM suplier_rek, bank WHERE suplier_rek.id_suplier = '$id' AND bank.id_bank = suplier_rek.id_bank"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function suplier_produk($id) { $i = []; $a = query("SELECT * FROM suplier_produk, produk_satuan, produk, satuan, kategori, kategori_header, kategori_jenis WHERE suplier_produk.id_suplier = '$id' AND produk_satuan.id_produk_satuan = suplier_produk.id_produk_satuan AND produk.id_produk = produk_satuan.id_produk AND satuan.id_satuan = produk_satuan.id_satuan AND kategori.id_kategori = produk.id_kategori AND kategori_header.id_kategori_header = kategori.id_kategori_header AND kategori_jenis.id_kategori_jenis = kategori.id_kategori_jenis"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function suplier_produk_isi($id) { $i = []; $a = query("SELECT * FROM suplier_produk_isi, produk, satuan WHERE suplier_produk_isi.id_suplier = '$id' AND produk.id_produk = suplier_produk_isi.id_produk AND satuan.id_satuan = suplier_produk_isi.id_satuan ORDER BY suplier_produk_isi.edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function suplier_produk_isi_jum_suplier($id, $ok) { return jumlah("SELECT * FROM suplier_produk_isi WHERE id_produk = '$id' AND id_suplier = '$ok'"); } function suplier_produk_isi_satu_suplier($id) { return query("SELECT DISTINCT id_suplier FROM suplier_produk_isi WHERE id_produk = '$id'"); } function suplier_produk_isi_jum($id, $y, $a) { return jumlah("SELECT * FROM suplier_produk_isi WHERE id_suplier = '$id' AND id_produk = '$y' AND id_satuan = '$a'"); } function suplier_produk_isi_satu($id, $y, $a, $b) { $c = query_satu("SELECT * FROM suplier_produk_isi WHERE id_suplier = '$id' AND id_produk = '$y' AND id_satuan = '$a'"); return @$c[$b]; } function suplier_produk_per_produk($id) { $i = []; $a = query("SELECT * FROM suplier_produk, produk_satuan, produk WHERE produk_satuan.id_produk_satuan = suplier_produk.id_produk_satuan AND suplier_produk.id_suplier_produk = '$id' AND produk.id_produk = produk_satuan.id_produk"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function suplier_produk_per_produk_satu($id, $ok) { $a = query_satu("SELECT * FROM suplier_produk, produk_satuan, produk, satuan WHERE suplier_produk.id_suplier_produk = '$id' AND produk_satuan.id_produk_satuan = suplier_produk.id_produk_satuan AND produk.id_produk = produk_satuan.id_produk AND satuan.id_satuan = produk_satuan.id_satuan"); return $a[$ok]; } function suplier_ex_bpom($id, $oke) { $a = query_satu("SELECT * FROM suplier_produk_expired WHERE id_suplier_produk = '$id' AND id_expired = 2"); return $a[$oke]; } function suplier_ex_bpom_produk($id, $ok, $yes) { $a = query_satu("SELECT * FROM suplier_produk_expired, suplier_produk, produk_satuan WHERE suplier_produk_expired.id_expired = 2 AND suplier_produk.id_suplier_produk = suplier_produk_expired.id_suplier_produk AND suplier_produk.id_suplier = '$id' AND produk_satuan.id_produk_satuan = suplier_produk.id_produk_satuan AND produk_satuan.id_produk = '$ok' "); return $a[$yes]; } function suplier_ex_mui_produk($id, $ok, $yes) { $a = query_satu("SELECT * FROM suplier_produk_expired, suplier_produk, produk_satuan WHERE suplier_produk_expired.id_expired = 1 AND suplier_produk.id_suplier_produk = suplier_produk_expired.id_suplier_produk AND suplier_produk.id_suplier = '$id' AND produk_satuan.id_produk_satuan = suplier_produk.id_produk_satuan AND produk_satuan.id_produk = '$ok' "); return $a[$yes]; } function suplier_produk_ex($ha, $id, $ok, $yes) { $a = query_satu("SELECT * FROM suplier_produk_expired, suplier_produk, produk_satuan WHERE suplier_produk_expired.id_expired = '$ha' AND suplier_produk.id_suplier_produk = suplier_produk_expired.id_suplier_produk AND suplier_produk.id_suplier = '$id' AND produk_satuan.id_produk_satuan = suplier_produk.id_produk_satuan AND produk_satuan.id_produk = '$ok' "); return $a[$yes]; } function suplier_ex_mui($id, $oke) { $a = query_satu("SELECT * FROM suplier_produk_expired WHERE id_suplier_produk = '$id' AND id_expired = 1 ORDER BY tgl_expired ASC"); return $a[$oke]; } function suplier_produk_saja() { $i = []; $a = query("SELECT * FROM suplier_produk, suplier, produk_satuan, satuan WHERE suplier.id_suplier = suplier_produk.id_suplier AND produk_satuan.id_produk_satuan = suplier_produk.id_produk_satuan AND satuan.id_satuan = produk_satuan.id_satuan"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function suplier_produk_nama($id, $oke) { $a = query_satu("SELECT * FROM produk_satuan, produk, kategori WHERE produk_satuan.id_produk_satuan = '$id' AND produk.id_produk = produk_satuan.id_produk AND kategori.id_kategori = produk.id_kategori"); return $a[$oke]; } function produk_suplier($id) { $i = []; $a = query("SELECT * FROM suplier_produk, suplier, produk_satuan, satuan WHERE suplier_produk.id_produk_satuan = '$id' AND suplier.id_suplier = suplier_produk.id_suplier AND produk_satuan.id_produk_satuan = suplier_produk.id_produk_satuan AND satuan.id_satuan = produk_satuan.id_satuan"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function suplier_jenis() { $i = []; $a = query("SELECT * FROM suplier_jenis"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function suplier_jenis_kecuali($id) { $i = []; $a = query("SELECT * FROM suplier_jenis WHERE id_suplier_jenis <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function suplier_jenis_satu($id, $oke) { $a = query_satu("SELECT * FROM suplier_jenis WHERE id_suplier_jenis = '$id'"); return $a[$oke]; } function suplier_satu($id, $ok) { $a = query_satu("SELECT * FROM suplier WHERE id_suplier = '$id'"); return $a[$ok]; } function kategori_jenis_satu($id, $oke) { $a = query_satu("SELECT * FROM kategori_jenis WHERE id_kategori_jenis = '$id'"); return $a[$oke]; } function kategori_jenis_all() { $a = query("SELECT * FROM kategori_jenis"); return $a; } function diskon_bonus_produk() { $i = []; $a = query("SELECT * FROM diskon_bonus_produk ORDER BY nama_diskon_bonus_produk ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function diskon_bonus($id) { $i = []; $a = query("SELECT * FROM diskon_bonus, diskon_bonus_jenis WHERE diskon_bonus.id_diskon = '$id' AND diskon_bonus_jenis.id_diskon_bonus_jenis = diskon_bonus.id_diskon_bonus_jenis"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function diskon_bonus_produk_header($id) { $i = []; $a = query("SELECT * FROM diskon_bonus_produk_header, diskon_bonus_produk WHERE diskon_bonus_produk_header.id_diskon_bonus = '$id' AND diskon_bonus_produk.id_diskon_bonus_produk = diskon_bonus_produk_header.id_diskon_bonus_produk"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function market() { $i = []; $a = query("SELECT * FROM market ORDER BY edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function market_grup_jumlah($id) { return jumlah("SELECT * FROM grup WHERE id_market = '$id'"); } function market_kecuali($id) { $i = []; $a = query("SELECT * FROM market WHERE id_market <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function kode($id, $kode) { $a = query_satu("SELECT * FROM kode WHERE id = '$id'"); return $a[$kode]; } function jumlah_pimpinan_grup($id) { $a = jumlah("SELECT * FROM sales_grup WHERE id_grup = '$id' AND pimpinan = 1 AND status_sales_grup = 1"); return $a; } function grup_wilayah_sales($id) { $i = []; $a = query("SELECT * FROM grup_wilayah_sales, sales WHERE grup_wilayah_sales.id_grup_wilayah = '$id' AND sales.id_sales = grup_wilayah_sales.id_sales AND status = 1"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function grup_wilayah_sales_detail($id, $oke) { $a = query_satu("SELECT * FROM grup_wilayah_sales, sales, grup_wilayah WHERE grup_wilayah_sales.id_grup_wilayah_sales = '$id' AND sales.id_sales = grup_wilayah_sales.id_sales AND grup_wilayah.id_grup_wilayah = grup_wilayah_sales.id_grup_wilayah"); return $a[$oke]; } function grup_wilayah_sales_jumlah_all($id) { return jumlah("SELECT * FROM grup_wilayah_sales WHERE id_grup_wilayah = '$id' AND status = 1"); } function villages($id) { $i = []; $a = query("SELECT * FROM villages WHERE district_id = '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function villages_kecuali($id, $o) { $i = []; $a = query("SELECT * FROM villages WHERE district_id = '$id' AND id != '$o'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function tipe_master_perkiraan() { $i = []; $a = query("SELECT * FROM coa_tipe_perkiraan"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_kecuali($kode_master_perkiraan, $id_coa) { return query("SELECT * FROM coa WHERE kode_master_perkiraan = '$kode_master_perkiraan' AND id_coa != '$id_coa'"); } function coa_master_perkiraan() { $i = []; $a = query("SELECT * FROM coa_master_perkiraan ORDER BY kode_master_perkiraan ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_master_perkiraan_kecuali($kode_master_perkiraan) { return query("SELECT * FROM coa_master_perkiraan WHERE kode_master_perkiraan != '$kode_master_perkiraan'"); } function coa_master_perkiraan_satu_kode($kode_master_perkiraan, $isi) { $a = query_satu("SELECT * FROM coa_master_perkiraan WHERE kode_master_perkiraan = '$kode_master_perkiraan'"); return $a[$isi]; } function coa_master_perkiraan_bukan_biaya() { $i = []; $a = query("SELECT * FROM coa_master_perkiraan, coa_tipe_perkiraan, coa_kelompok_perkiraan WHERE coa_master_perkiraan.id_coa_tipe_perkiraan <> 5 AND coa_tipe_perkiraan.id_coa_tipe_perkiraan = coa_master_perkiraan.id_coa_tipe_perkiraan AND coa_kelompok_perkiraan.id_coa_kelompok_perkiraan = coa_master_perkiraan.id_coa_kelompok_perkiraan ORDER BY coa_master_perkiraan.kode_master_perkiraan ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_master_perkiraan_yang_biaya() { $i = []; $a = query("SELECT * FROM coa_master_perkiraan, coa_tipe_perkiraan, coa_kelompok_perkiraan WHERE coa_master_perkiraan.id_coa_tipe_perkiraan = 5 AND coa_tipe_perkiraan.id_coa_tipe_perkiraan = coa_master_perkiraan.id_coa_tipe_perkiraan AND coa_kelompok_perkiraan.id_coa_kelompok_perkiraan = coa_master_perkiraan.id_coa_kelompok_perkiraan ORDER BY coa_master_perkiraan.kode_master_perkiraan ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_master_perkiraan_detail() { $i = []; $a = query("SELECT * FROM coa_master_perkiraan_detail, coa_master_perkiraan, coa_kelompok_perkiraan WHERE coa_master_perkiraan.id_coa_master_perkiraan = coa_master_perkiraan_detail.id_coa_master_perkiraan AND coa_kelompok_perkiraan.id_coa_kelompok_perkiraan = coa_master_perkiraan.id_coa_kelompok_perkiraan ORDER BY coa_master_perkiraan_detail.edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_master_perkiraan_detail_berdasarkan($id) { $i = []; $a = query("SELECT * FROM coa_master_perkiraan_detail, coa_master_perkiraan WHERE coa_master_perkiraan_detail.id_coa_master_perkiraan = '$id' AND coa_master_perkiraan.id_coa_master_perkiraan = coa_master_perkiraan_detail.id_coa_master_perkiraan"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_neraca_lajur() { $i = []; $a = query("SELECT * FROM coa_neraca_lajur ORDER BY edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_jenis_perkiraan() { $i = []; $a = query("SELECT * FROM coa_jenis_perkiraan ORDER BY edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_kategori_perkiraan() { $i = []; $a = query("SELECT * FROM coa_kategori_perkiraan ORDER BY edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_jenis_biaya_perkiraan() { $i = []; $a = query("SELECT * FROM coa_jenis_biaya_perkiraan ORDER BY edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_lihat($id) { $i = []; $a = query("SELECT * FROM coa, coa_master_perkiraan, coa_jenis_perkiraan, coa_detail, coa_kategori_perkiraan, coa_kelompok_perkiraan WHERE coa_master_perkiraan.kode_master_perkiraan = coa.kode_master_perkiraan AND coa.kode_master_perkiraan = '$id' AND coa_jenis_perkiraan.id_coa_jenis_perkiraan = coa.id_coa_jenis_perkiraan AND coa_detail.id_coa = coa.id_coa AND coa_kategori_perkiraan.id_coa_kategori_perkiraan = coa.id_kategori_perkiraan AND coa_kelompok_perkiraan.id_coa_kelompok_perkiraan = coa_master_perkiraan.id_coa_kelompok_perkiraan"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_lihat_passiva($id) { $i = []; $a = query("SELECT * FROM coa, coa_master_perkiraan, coa_jenis_perkiraan, coa_detail, coa_kategori_perkiraan, coa_kelompok_perkiraan WHERE coa_master_perkiraan.kode_master_perkiraan = coa.kode_master_perkiraan AND coa.kode_master_perkiraan = '$id' AND coa_jenis_perkiraan.id_coa_jenis_perkiraan = coa.id_coa_jenis_perkiraan AND coa_detail.id_coa = coa.id_coa AND coa_kategori_perkiraan.id_coa_kategori_perkiraan = coa.id_kategori_perkiraan AND coa_kelompok_perkiraan.id_coa_kelompok_perkiraan = coa_master_perkiraan.id_coa_kelompok_perkiraan AND coa.id_coa_jenis_perkiraan = 2"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_lihat_aktiva($id) { $i = []; $a = query("SELECT * FROM coa, coa_master_perkiraan, coa_jenis_perkiraan, coa_detail, coa_kategori_perkiraan, coa_kelompok_perkiraan WHERE coa_master_perkiraan.kode_master_perkiraan = coa.kode_master_perkiraan AND coa.kode_master_perkiraan = '$id' AND coa_jenis_perkiraan.id_coa_jenis_perkiraan = coa.id_coa_jenis_perkiraan AND coa_detail.id_coa = coa.id_coa AND coa_kategori_perkiraan.id_coa_kategori_perkiraan = coa.id_kategori_perkiraan AND coa_kelompok_perkiraan.id_coa_kelompok_perkiraan = coa_master_perkiraan.id_coa_kelompok_perkiraan AND coa.id_coa_jenis_perkiraan = 1"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_lihat_modal($id) { $i = []; $a = query("SELECT * FROM coa, coa_master_perkiraan, coa_jenis_perkiraan, coa_detail, coa_kategori_perkiraan, coa_kelompok_perkiraan WHERE coa_master_perkiraan.kode_master_perkiraan = coa.kode_master_perkiraan AND coa.kode_master_perkiraan = '$id' AND coa_jenis_perkiraan.id_coa_jenis_perkiraan = coa.id_coa_jenis_perkiraan AND coa_detail.id_coa = coa.id_coa AND coa_kategori_perkiraan.id_coa_kategori_perkiraan = coa.id_kategori_perkiraan AND coa_kelompok_perkiraan.id_coa_kelompok_perkiraan = coa_master_perkiraan.id_coa_kelompok_perkiraan AND coa.id_coa_jenis_perkiraan = 3"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_lihat_laba_rugi($id) { $i = []; $a = query("SELECT * FROM coa, coa_master_perkiraan, coa_jenis_perkiraan, coa_detail, coa_kategori_perkiraan, coa_kelompok_perkiraan WHERE coa_master_perkiraan.kode_master_perkiraan = coa.kode_master_perkiraan AND coa.kode_master_perkiraan = '$id' AND coa_jenis_perkiraan.id_coa_jenis_perkiraan = coa.id_coa_jenis_perkiraan AND coa_detail.id_coa = coa.id_coa AND coa_kategori_perkiraan.id_coa_kategori_perkiraan = coa.id_kategori_perkiraan AND coa_kelompok_perkiraan.id_coa_kelompok_perkiraan = coa_master_perkiraan.id_coa_kelompok_perkiraan AND coa.id_coa_jenis_perkiraan = 17"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_lihat_biaya($id) { $i = []; $a = query("SELECT * FROM coa, coa_master_perkiraan, coa_jenis_perkiraan, coa_detail, coa_kategori_perkiraan, coa_kelompok_perkiraan WHERE coa_master_perkiraan.kode_master_perkiraan = coa.kode_master_perkiraan AND coa.kode_master_perkiraan = '$id' AND coa_jenis_perkiraan.id_coa_jenis_perkiraan = coa.id_coa_jenis_perkiraan AND coa_detail.id_coa = coa.id_coa AND coa_kategori_perkiraan.id_coa_kategori_perkiraan = coa.id_kategori_perkiraan AND coa_kelompok_perkiraan.id_coa_kelompok_perkiraan = coa_master_perkiraan.id_coa_kelompok_perkiraan AND coa.id_coa_jenis_perkiraan = 4"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function jumlah_coa_biaya($id) { return jumlah("SELECT * FROM coa_biaya WHERE id_coa = '$id'"); } function coa_biaya_lihat($id, $ok) { $a = query_satu("SELECT * FROM coa_biaya, coa_jenis_biaya_perkiraan WHERE coa_biaya.id_coa = '$id' AND coa_jenis_biaya_perkiraan.id_coa_jenis_biaya_perkiraan = coa_biaya.id_jenis_biaya_perkiraan"); return $a[$ok]; } function coa_aja($id, $ok) { $a = query_satu("SELECT * FROM coa, coa_master_perkiraan, coa_jenis_perkiraan, coa_kategori_perkiraan, coa_detail, coa_jenis, coa_neraca_lajur WHERE coa.id_coa = '$id' AND coa_master_perkiraan.kode_master_perkiraan = coa.kode_master_perkiraan AND coa_jenis_perkiraan.id_coa_jenis_perkiraan = coa.id_coa_jenis_perkiraan AND coa_kategori_perkiraan.id_coa_kategori_perkiraan = coa.id_kategori_perkiraan AND coa_detail.id_coa = coa.id_coa AND coa_jenis.id_coa_jenis = coa_detail.id_coa_jenis AND coa_neraca_lajur.id_coa_neraca_lajur = coa.id_coa_neraca_lajur"); return $a[$ok]; } function coa_jenis_perkiraan_kecuali($id) { $i = []; $a = query("SELECT * FROM coa_jenis_perkiraan WHERE id_coa_jenis_perkiraan <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_kategori_perkiraan_kecuali($id) { $i = []; $a = query("SELECT * FROM coa_kategori_perkiraan WHERE id_coa_kategori_perkiraan <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_biaya_satu($id, $ok) { $a = query_satu("SELECT * FROM coa_biaya, coa_jenis_biaya_perkiraan WHERE coa_biaya.id_coa = '$id' AND coa_jenis_biaya_perkiraan.id_coa_jenis_biaya_perkiraan = coa_biaya.id_jenis_biaya_perkiraan"); return $a[$ok]; } function coa_biaya_kecuali($id) { $i = []; $a = query("SELECT * FROM coa_jenis_biaya_perkiraan WHERE id_coa_jenis_biaya_perkiraan <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_neraca_lajur_kecuali($id) { $i = []; $a = query("SELECT * FROM coa_neraca_lajur WHERE id_coa_neraca_lajur <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_master_perkiraan_ada_dicoa() { $i = []; $a = query("SELECT * FROM coa_master_perkiraan WHERE kode_master_perkiraan IN(SELECT kode_master_perkiraan FROM coa)"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_master_perkiraan_aktiva() { $i = []; $a = query("SELECT * FROM coa_master_perkiraan WHERE kode_master_perkiraan IN(SELECT kode_master_perkiraan FROM coa WHERE id_coa_jenis_perkiraan = 1)"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_master_perkiraan_passiva() { $i = []; $a = query("SELECT * FROM coa_master_perkiraan WHERE kode_master_perkiraan IN(SELECT kode_master_perkiraan FROM coa WHERE id_coa_jenis_perkiraan = 2)"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_master_perkiraan_modal() { $i = []; $a = query("SELECT * FROM coa_master_perkiraan WHERE kode_master_perkiraan IN(SELECT kode_master_perkiraan FROM coa WHERE id_coa_jenis_perkiraan = 3)"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_master_perkiraan_laba_rugi() { $i = []; $a = query("SELECT * FROM coa_master_perkiraan WHERE kode_master_perkiraan IN(SELECT kode_master_perkiraan FROM coa WHERE id_coa_jenis_perkiraan = 17)"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_master_perkiraan_biaya() { $i = []; $a = query("SELECT * FROM coa_master_perkiraan WHERE kode_master_perkiraan IN(SELECT kode_master_perkiraan FROM coa WHERE id_coa_jenis_perkiraan = 4)"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_detail($id, $oke) { $a = query_satu("SELECT * FROM coa, coa_jenis_perkiraan, coa_kategori_perkiraan, coa_master_perkiraan, coa_kelompok_perkiraan, coa_neraca_lajur WHERE coa.id_coa = '$id' AND coa_jenis_perkiraan.id_coa_jenis_perkiraan = coa.id_coa_jenis_perkiraan AND coa_kategori_perkiraan.id_coa_kategori_perkiraan = coa.id_kategori_perkiraan AND coa_master_perkiraan.kode_master_perkiraan = coa.kode_master_perkiraan AND coa_kelompok_perkiraan.id_coa_kelompok_perkiraan = coa_master_perkiraan.id_coa_kelompok_perkiraan AND coa_neraca_lajur.id_coa_neraca_lajur = coa.id_coa_neraca_lajur"); return $a[$oke]; } function coa_detail_satu($id, $ok) { $a = query_satu("SELECT * FROM coa_detail WHERE id_coa = '$id'"); return $a[$ok]; } function coa_aktiva() { $i = []; $a = query("SELECT * FROM coa WHERE id_coa_jenis_perkiraan = 1"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_aktiva_kecuali($id) { $i = []; $a = query("SELECT * FROM coa WHERE id_coa_jenis_perkiraan = 1 AND id_coa <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_passiva() { $i = []; $a = query("SELECT * FROM coa WHERE id_coa_jenis_perkiraan = 2"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_passiva_kecuali($id) { $i = []; $a = query("SELECT * FROM coa WHERE id_coa_jenis_perkiraan = 2 AND id_coa <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function produk_img($id) { $i = []; $a = query("SELECT * FROM produk_img WHERE id_produk = '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa() { $i = []; $a = query("SELECT * FROM coa, coa_jenis_perkiraan, coa_detail, coa_kategori_perkiraan WHERE coa_jenis_perkiraan.id_coa_jenis_perkiraan = coa.id_coa_jenis_perkiraan AND coa_detail.id_coa = coa.id_coa AND coa_kategori_perkiraan.id_coa_kategori_perkiraan = coa.id_kategori_perkiraan ORDER BY coa.kode_coa ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_favorite() { $i = []; $a = query("SELECT * FROM coa_favorit, coa, coa_jenis_perkiraan WHERE coa.kode_coa = coa_favorit.kode_coa AND coa_jenis_perkiraan.id_coa_jenis_perkiraan = coa.id_coa_jenis_perkiraan ORDER BY coa_favorit.kode_coa ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_jenis_perkiraan_biaya() { $i = []; $a = query("SELECT * FROM coa WHERE id_coa_jenis_perkiraan = 4 ORDER BY kode_coa ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function jurnal_kelompok() { $i = []; $a = query("SELECT * FROM jurnal_kelompok ORDER BY edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function jurnal_kelompok_satu($id, $ok) { $a = query_satu("SELECT * FROM jurnal_kelompok WHERE id_jurnal_kelompok = '$id'"); return $a[$ok]; } function coa_satu($id, $ok) { $a = query_satu("SELECT * FROM coa, coa_kategori_perkiraan WHERE coa.id_coa = '$id' AND coa_kategori_perkiraan.id_coa_kategori_perkiraan = coa.id_kategori_perkiraan"); return $a[$ok]; } function jurnal_kode_jumlah($id, $ok) { return jumlah("SELECT * FROM jurnal_kode WHERE bulan = '$id' AND tahun = '$ok'"); } function jurnal_kode_satu($id, $ok, $ya) { $a = query_satu("SELECT * FROM jurnal_kode WHERE bulan = '$id' AND tahun = '$ok'"); return $a[$ya]; } function jurnal_satu($id, $ok) { $a = query_satu("SELECT * FROM jurnal, jurnal_kelompok, jurnal_jenis WHERE jurnal.id_jurnal = '$id' AND jurnal_kelompok.id_jurnal_kelompok = jurnal.id_jurnal_kelompok AND jurnal_jenis.id_jurnal_jenis = jurnal.id_jurnal_jenis"); return $a[$ok]; } function jurnal() { $i = []; $a = query("SELECT * FROM jurnal WHERE id_jurnal NOT IN(SELECT kode FROM recycle WHERE id_recycle_jenis = 1) ORDER BY kode_jurnal ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function jurnal_kelompok_kecuali($id) { $i = []; $a = query("SELECT * FROM jurnal_kelompok WHERE id_jurnal_kelompok <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function jurnal_detail($id) { $i = []; $a = query("SELECT * FROM jurnal_detail, coa, coa_kategori_perkiraan WHERE jurnal_detail.id_jurnal = '$id' AND coa.kode_coa = jurnal_detail.kode_coa AND coa_kategori_perkiraan.id_coa_kategori_perkiraan = coa.id_kategori_perkiraan"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function jurnal_detail_satu($id, $ok) { $a = query_satu("SELECT * FROM jurnal_detail, coa, coa_kategori_perkiraan, akuntan_jenis WHERE jurnal_detail.id_jurnal_detail = '$id' AND coa.kode_coa = jurnal_detail.kode_coa AND coa_kategori_perkiraan.id_coa_kategori_perkiraan = coa.id_kategori_perkiraan AND akuntan_jenis.id_akuntan_jenis = jurnal_detail.id_akuntan_jenis"); return $a[$ok]; } function akuntan_jenis() { return query("SELECT * FROM akuntan_jenis"); } function akuntan_jenis_kecuali($id) { return query("SELECT * FROM akuntan_jenis WHERE id_akuntan_jenis != '$id'"); } function akuntan_jenis_satu($id, $a) { $b = query_satu("SELECT * FROM akuntan_jenis WHERE id_akuntan_jenis = '$id'"); return $b[$a]; } function jurnal_detail_jumlah($id) { return jumlah("SELECT * FROM jurnal_detail WHERE id_jurnal = '$id'"); } function cabang() { $i = []; $a = query("SELECT * FROM cabang WHERE id_cabang NOT IN(SELECT kode FROM recycle WHERE id_recycle_jenis = 2) ORDER BY edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function recycle() { $i = []; $a = query("SELECT * FROM recycle, recycle_jenis, user WHERE recycle_jenis.id_recycle_jenis = recycle.id_recycle_jenis AND user.id_user = recycle.id_user ORDER BY recycle.tgl_masuk DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function recycle_jumlah() { return jumlah("SELECT * FROM recycle"); } function cabang_cp($id) { $i = []; $a = query("SELECT * FROM cabang_cp WHERE id_cabang = '$id' AND id_cabang_cp NOT IN(SELECT kode FROM recycle WHERE id_recycle_jenis = 3) ORDER BY edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function cabang_cp_satu($id, $i) { $a = query_satu("SELECT * FROM cabang_cp WHERE id_cabang_cp = '$id'"); return $a[$i]; } function recycle_proses() { $hari = date("Y-m-d"); $cek = jumlah("SELECT * FROM recycle WHERE '$hari' > tgl_berakhir"); if ($cek > 0) { $lihat = query("SELECT * FROM recycle WHERE '$hari' > tgl_berakhir"); while ($l_lihat = query_banyak($lihat)) { $recycle_jenis = $l_lihat["id_recycle_jenis"]; $kode = $l_lihat["kode"]; $id = $l_lihat["id"]; if ($recycle_jenis == 1) { $h = query("DELETE FROM jurnal_detail WHERE id_jurnal = '$kode'"); if ($h) { query("DELETE FROM jurnal WHERE id_jurnal = '$kode'"); query("DELETE FROM recycle WHERE id = '$id'"); } else { query("DELETE FROM recycle WHERE id = '$id'"); } } elseif ($recycle_jenis == 2) { $h = query("DELETE FROM cabang WHERE id_cabang = '$kode'"); if ($h) { query("DELETE FROM cabang_cp WHERE id_cabang = '$kode'"); query("DELETE FROM recycle WHERE id = '$id'"); } else { query("DELETE FROM recycle WHERE id = '$id'"); } } elseif ($recycle_jenis == 3) { $h = query("DELETE FROM cabang_cp WHERE id_cabang_cp = '$kode'"); if ($h) { query("DELETE FROM recycle WHERE id = '$id'"); } else { query("DELETE FROM recycle WHERE id = '$id'"); } } elseif ($recycle_jenis == 4) { $h = query("DELETE FROM asset_bulan_susut WHERE id_asset_bulan_susut = '$kode'"); if ($h) { query("DELETE FROM recycle WHERE id = '$id'"); } else { query("DELETE FROM recycle WHERE id = '$id'"); } } elseif ($recycle_jenis == 5) { $h = query("DELETE FROM asset_coa WHERE id_asset = '$kode'"); if ($h) { query("DELETE FROM asset_suplier WHERE id_asset = '$kode'"); query("DELETE FROM asset WHERE id_asset = '$kode'"); query("DELETE FROM recycle WHERE id = '$id'"); } else { query("DELETE FROM recycle WHERE id = '$id'"); } } elseif ($recycle_jenis == 6) { $h = query("DELETE FROM rekening WHERE id_rekening = '$kode'"); if ($h) { query("DELETE FROM rekening_alamat WHERE id_rekening = '$kode'"); query("DELETE FROM bank_coa WHERE id_rekening = '$kode'"); query("DELETE FROM recycle WHERE id = '$id'"); } else { query("DELETE FROM recycle WHERE id = '$id'"); } } elseif ($recycle_jenis == 7) { $h = query("DELETE FROM bank_biaya_jenis WHERE id_bank_biaya_jenis = '$kode'"); if ($h) { query("DELETE FROM recycle WHERE id = '$id'"); } else { query("DELETE FROM recycle WHERE id = '$id'"); } } elseif ($recycle_jenis == 8) { $cek_bank = query_satu("SELECT * FROM bank WHERE id_bank = '$kode'"); $gambar_bank = $cek_bank["gambar_bank"]; $tmp = "../../admin/pages/img/bank/" . $gambar_bank; $h = query("DELETE FROM bank WHERE id_bank = '$kode'"); if ($h) { if ($gambar_bank != "nophoto.jpg") { unlink($tmp); } query("DELETE FROM recycle WHERE id = '$id'"); } else { query("DELETE FROM recycle WHERE id = '$id'"); } } elseif ($recycle_jenis == 9) { $h = query("DELETE FROM bank_biaya WHERE id_bank_biaya = '$kode'"); if ($h) { query("DELETE FROM recycle WHERE id = '$id'"); } else { query("DELETE FROM recycle WHERE id = '$id'"); } } } } } function recycle_jenis_satu($id, $o) { $a = query_satu("SELECT * FROM recycle_jenis WHERE id_recycle_jenis = '$id'"); return $a[$o]; } function asset_bulan_susut() { $i = []; $a = query("SELECT * FROM asset_bulan_susut WHERE id_asset_bulan_susut NOT IN(SELECT kode FROM recycle WHERE id_recycle_jenis = 4) ORDER BY bulan_susut ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function asset_bulan_susut_kecuali($id) { $i = []; $a = query("SELECT * FROM asset_bulan_susut WHERE id_asset_bulan_susut NOT IN(SELECT kode FROM recycle WHERE id_recycle_jenis = 4) AND bulan_susut <> '$id' ORDER BY bulan_susut ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_inventaris() { $i = []; $a = query("SELECT * FROM coa WHERE kode_master_perkiraan = 108"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_inventaris_kecuali($id) { $i = []; $a = query("SELECT * FROM coa WHERE kode_master_perkiraan = 108 AND kode_coa <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_biaya_penyusutan() { $i = []; $a = query("SELECT * FROM coa WHERE kode_master_perkiraan = 604"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_biaya_penyusutan_kecuali($id) { $i = []; $a = query("SELECT * FROM coa WHERE kode_master_perkiraan = 604 AND kode_coa <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_akumulasi_penyusutan() { $i = []; $a = query("SELECT * FROM coa WHERE kode_master_perkiraan = 109"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_akumulasi_penyusutan_kecuali($id) { $i = []; $a = query("SELECT * FROM coa WHERE kode_master_perkiraan = 109 AND kode_coa <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function asset_pusat() { $i = []; $a = query("SELECT * FROM asset WHERE pusat = 1 AND id_asset NOT IN(SELECT kode FROM recycle WHERE id_recycle_jenis = 5) ORDER BY edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function asset_coa($id) { $i = []; $a = query("SELECT * FROM asset_coa, coa, asset_coa_jenis WHERE asset_coa.id_asset = '$id' AND coa.kode_coa = asset_coa.kode_coa AND asset_coa_jenis.id_asset_coa_jenis = asset_coa.id_asset_coa_jenis"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function asset_coa_satu($id, $ok) { $a = query_satu("SELECT * FROM asset_coa, coa, asset_coa_jenis WHERE asset_coa.id_asset_coa = '$id' AND coa.kode_coa = asset_coa.kode_coa AND asset_coa_jenis.id_asset_coa_jenis = asset_coa.id_asset_coa_jenis"); return $a[$ok]; } function asset_suplier($id, $ok) { $a = query_satu("SELECT * FROM asset_suplier, suplier WHERE asset_suplier.id_asset = '$id' AND suplier.id_suplier = asset_suplier.id_suplier"); return $a[$ok]; } function asset_satu($id, $ok) { $a = query_satu("SELECT * FROM asset WHERE id_asset = '$id'"); return $a[$ok]; } function asset_inventaris_satu($id, $ok) { $a = query_satu("SELECT * FROM asset_coa, coa WHERE asset_coa.id_asset = '$id' AND coa.kode_coa = asset_coa.kode_coa AND coa.kode_master_perkiraan = 108"); return $a[$ok]; } function asset_biaya_penyusutan($id, $ok) { $a = query_satu("SELECT * FROM asset_coa, coa WHERE asset_coa.id_asset = '$id' AND coa.kode_coa = asset_coa.kode_coa AND coa.kode_master_perkiraan = 604"); return $a[$ok]; } function rekening() { $i = []; $a = query("SELECT * FROM rekening, bank WHERE rekening.id_rekening NOT IN(SELECT kode FROM recycle WHERE id_recycle_jenis = 6) AND bank.id_bank = rekening.id_bank ORDER BY rekening.edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function rekening_alamat($id, $ok) { $a = query_satu("SELECT * FROM rekening_alamat WHERE id_rekening = '$id'"); return $a[$ok]; } function rekening_sendiri() { $i = []; $a = query("SELECT * FROM rekening, bank, bank_valuta WHERE rekening.id_rekening NOT IN(SELECT kode FROM recycle WHERE id_recycle_jenis = 6) AND bank.id_bank = rekening.id_bank AND sendiri = 1 AND bank_valuta.id_bank_valuta = rekening.id_bank_valuta ORDER BY rekening.edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function rekening_lainnya() { $i = []; $a = query("SELECT * FROM rekening, bank WHERE rekening.id_rekening NOT IN(SELECT kode FROM recycle WHERE id_recycle_jenis = 6) AND bank.id_bank = rekening.id_bank AND sendiri = 0 ORDER BY rekening.edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function rekening_satu($id, $ok) { $a = query_satu("SELECT * FROM rekening, bank, bank_valuta WHERE rekening.id_rekening = '$id' AND bank.id_bank = rekening.id_bank AND bank_valuta.id_bank_valuta = rekening.id_bank_valuta"); return $a[$ok]; } function rekening_kecuali($id_rekening) { return query("SELECT * FROM rekening WHERE id_rekening != '$id_rekening'"); } function bank_biaya_jenis() { $i = []; $a = query("SELECT * FROM bank_biaya_jenis WHERE id_bank_biaya_jenis NOT IN(SELECT kode FROM recycle WHERE id_recycle_jenis = 7) ORDER BY edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function bank_biaya_jenis_satu($id, $ok) { $a = query_satu("SELECT * FROM bank_biaya_jenis WHERE id_bank_biaya_jenis = '$id'"); return $a[$ok]; } function bank_valuta() { $i = []; $a = query("SELECT * FROM bank_valuta ORDER BY id_bank_valuta ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function bank_valuta_kecuali($id) { $i = []; $a = query("SELECT * FROM bank_valuta WHERE id_bank_valuta <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function bank_coa($id) { $i = []; $a = query("SELECT * FROM bank_coa, coa, bank_coa_jenis WHERE bank_coa.id_rekening = '$id' AND coa.id_coa = bank_coa.id_coa AND bank_coa_jenis.id_bank_coa_jenis = bank_coa.id_bank_coa_jenis"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function bank_coa_satu($id, $ok) { $a = query_satu("SELECT * FROM bank_coa, bank_coa_jenis, coa WHERE bank_coa.id_bank_coa = '$id' AND bank_coa_jenis.id_bank_coa_jenis = bank_coa.id_bank_coa_jenis AND coa.id_coa = bank_coa.id_coa"); return $a[$ok]; } function bank_biaya() { $i = []; $a = query("SELECT * FROM bank_biaya, bank, coa, bank_biaya_jenis WHERE bank.id_bank = bank_biaya.id_bank AND coa.id_coa = bank_biaya.id_coa AND bank_biaya_jenis.id_bank_biaya_jenis = bank_biaya.id_bank_biaya_jenis AND bank_biaya.id_bank_biaya NOT IN(SELECT kode FROM recycle WHERE id_recycle_jenis = 9) ORDER BY bank_biaya.id_bank ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function produk_online_kondisi() { $i = []; $a = query("SELECT * FROM produk_online_kondisi"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function produk_online_kondisi_kecuali($id) { $i = []; $a = query("SELECT * FROM produk_online_kondisi WHERE id_produk_online_kondisi <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function produk_online_kondisi_satu($id, $o) { $a = query_satu("SELECT * FROM produk_online_kondisi WHERE id_produk_online_kondisi = '$id'"); return $a[$o]; } function produk_online() { return query("SELECT * FROM produk_online"); } function check_product_online($id) { $a = query_satu("SELECT * FROM produk_online WHERE id_produk_online = '$id'"); if ($a) { return true; } else { return false; } } function get_product_data($id) { $a = query_satu("SELECT * FROM produk_online, produk, kategori WHERE produk.id_produk = produk_online.id_produk AND kategori.id_kategori = produk.id_kategori AND produk_online.id_produk_online = '$id'"); return $a; } function produk_online_satuan_satu($id, $ok) { $a = query_satu("SELECT * FROM produk_online_satuan WHERE id_produk = '$id' ORDER BY buat ASC"); return $a[$ok]; } function get_product_online_satuan($id_satuan) { if ($id_satuan == "") { return "-"; } else { $a = query_satu("SELECT * FROM satuan WHERE id_satuan = '$id_satuan'"); if ($a) { return $a['nama_satuan']; } else { return "-"; } } } function produk_online_file_gambar_satu($id, $ok) { $a = query_satu("SELECT * FROM produk_online_file WHERE id_produk = '$id'"); if ($a) { return $a[$ok]; } else { return ""; } } function produk_online_satu($id, $ok) { $a = query_satu("SELECT * FROM produk_online WHERE id_produk = '$id'"); return $a[$ok]; } function produk_online_satuan($id) { return query("SELECT * FROM produk_online_satuan WHERE id_produk = '$id'"); } function produk_online_harga($id, $satuan) { $satuan_terbesar = produk_isi_satuan_awal($id, "id_satuan"); $harga_jual = @harga_produk_terbesar_satu(4, $id, "harga") + (@harga_produk_terbesar_satu(4, $id, "harga") * @produk_harga_jual(@harga_produk_terbesar_satu(4, $id, "id_harga_produk_terbesar"), "persen") / 100); $nilai = @produk_satuan_nilai($id, $satuan_terbesar, $satuan, "nilai"); if ($satuan == $satuan_terbesar) { $hasil = @$harga_jual; } else { $hasil = @$harga_jual / @$nilai; } return $hasil; } function produk_stok_all($id, $satuan) { $satuan_terkecil = produk_isi_satuan_akhir($id, "id_satuan"); if ($satuan_terkecil == $satuan) { echo @produk_satu($id, "stok_produk"); } else { if (@produk_satu($id, "stok_produk") / @produk_satuan_nilai($id, $satuan, $satuan_terkecil, "nilai") > 0) { $hasil = @produk_satu($id, "stok_produk") / @produk_satuan_nilai($id, $satuan, $satuan_terkecil, "nilai"); } else { $hasil = 0; } } return @$hasil; } function produk_berat($id, $satuan) { $satuan_terbesar = produk_isi_satuan_awal($id, "id_satuan"); if ($satuan_terbesar == $satuan) { $hasil = @produk_satu($id, "gram_satuan_terbesar"); } else { $hasil = @produk_satu($id, "gram_satuan_terbesar") / produk_satuan_nilai($id, $satuan_terbesar, $satuan, "nilai"); } return $hasil; } function produk_online_file_gambar($id) { $i = []; $a = query("SELECT * FROM produk_online_file WHERE id_produk_online_tipe = 1 AND id_produk = '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function produk_online_file_gambar_kecuali($id, $nama) { return query("SELECT * FROM produk_online_file WHERE id_produk_online_tipe = 1 AND id_produk = '$id' AND nama_file <> '$nama'"); } function fsize($file) { $a = array("B", "KB", "MB", "GB", "TB", "PB"); $pos = 0; $size = filesize($file); while ($size >= 1024) { $size /= 1024; $pos++; } return round($size, 2) . " " . $a[$pos]; } function produk_kategori_kecuali($id, $ok) { $i = []; $a = query("SELECT * FROM produk WHERE id_kategori = '$id' AND id_produk <> '$ok'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function produk_kategori($id) { $i = []; $a = query("SELECT * FROM produk WHERE id_kategori = '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function produk_kategori_jum($id) { return jumlah("SELECT * FROM produk WHERE id_kategori = '$id'"); } function produk_kecuali($id) { return query("SELECT * FROM produk WHERE id_produk != '$id'"); } function coa_setting_autobalance($id) { $a = query_satu("SELECT * FROM coa_setting, coa WHERE coa_setting.id_coa_setting = 1 AND coa.kode_coa = coa_setting.kode_coa"); return $a[$id]; } function produk_harga_standard() { $i = []; $a = query("SELECT * FROM produk_harga, produk, harga_produk_header, produk_satuan, satuan, kategori, kategori_jenis, kategori_header WHERE produk_harga.id_produk_harga_header = 1 AND produk.id_produk = produk_harga.id_produk AND harga_produk_header.id_harga_produk_header = produk_harga.id_harga_produk_header AND produk_satuan.id_produk_satuan = harga_produk_header.id_produk_satuan AND satuan.id_satuan = produk_satuan.id_satuan AND kategori.id_kategori = produk.id_kategori AND kategori_jenis.id_kategori_jenis = kategori.id_kategori_jenis AND kategori_header.id_kategori_header = kategori.id_kategori_header"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function produk_harga_standard_satu($id) { return harga_produk_terbesar_satu(4, $id, "harga") + (harga_produk_terbesar_satu(4, $id, "harga") * produk_harga_jual(harga_produk_terbesar_satu(4, $id, "id_harga_produk_terbesar"), "persen") / 100); } function harga_produk_header($id, $ok, $cie, $yes) { $a = query_satu("SELECT * FROM harga_produk_header WHERE id_produk = '$id' AND id_produk_satuan = '$ok' AND id_seller = '$cie'"); return $a[$yes]; } function produk_satu($id, $ok) { $a = query_satu("SELECT * FROM produk, kategori, merk, mata_uang, buatan, pabrik, warna, kategori_header WHERE produk.id_produk = '$id' AND kategori.id_kategori = produk.id_kategori AND merk.id_merk = produk.id_merk AND mata_uang.id_mata_uang = produk.id_mata_uang AND buatan.id_buatan = produk.id_buatan AND pabrik.id_pabrik = produk.id_pabrik AND warna.id_warna = produk.id_warna AND kategori_header.id_kategori_header = kategori.id_kategori_header"); return @$a[$ok]; } function produk_satu_nama($id, $i) { $a = query_satu("SELECT * FROM produk WHERE nama_produk = '$id'"); return $a[$i]; } function cek_kategri_produk($id) { return @produk_satu($id, "nama_kategori"); } function get_id_jenis_kat($id) { return @produk_satu($id, "id_kategori_jenis"); } function cek_jenis_kat($id) { return @query_satu("SELECT * FROM kategori_jenis WHERE id_kategori_jenis = '$id'")["nama_kategori_jenis"]; } function produk_search_simple($isi) { return query("SELECT * FROM produk WHERE sku LIKE '%$isi%' OR nama_produk LIKE '%$isi%'"); } function produk_search($id) { return query("SELECT * FROM produk, kategori, kategori_jenis, kategori_header WHERE kategori.id_kategori = produk.id_kategori AND kategori_jenis.id_kategori_jenis = kategori.id_kategori_jenis AND kategori_header.id_kategori_header = kategori.id_kategori_header AND kategori.nama_kategori LIKE '%$id%' OR kategori.id_kategori = produk.id_kategori AND kategori_jenis.id_kategori_jenis = kategori.id_kategori_jenis AND kategori_header.id_kategori_header = kategori.id_kategori_header AND produk.nama_produk LIKE '%$id%' OR kategori.id_kategori = produk.id_kategori AND kategori_jenis.id_kategori_jenis = kategori.id_kategori_jenis AND kategori_header.id_kategori_header = kategori.id_kategori_header AND produk.sku LIKE '%$id%' OR kategori.id_kategori = produk.id_kategori AND kategori_jenis.id_kategori_jenis = kategori.id_kategori_jenis AND kategori_header.id_kategori_header = kategori.id_kategori_header AND kategori_jenis.nama_kategori_jenis LIKE '%$id%' OR kategori.id_kategori = produk.id_kategori AND kategori_jenis.id_kategori_jenis = kategori.id_kategori_jenis AND kategori_header.id_kategori_header = kategori.id_kategori_header AND kategori_header.nama_kategori_header LIKE '%$id%'"); } function jurnal_setting() { $i = []; $a = query("SELECT * FROM jurnal_setting"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_setting() { $i = []; $a = query("SELECT * FROM coa_setting, coa WHERE coa.kode_coa = coa_setting.kode_coa"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function coa_setting_cari($id, $ok) { $a = query_satu("SELECT * FROM coa_setting, coa WHERE coa_setting.id_coa_setting = '$id' AND coa.kode_coa = coa_setting.kode_coa"); return $a[$ok]; } function lembaga_penerbit_halal() { $i = []; $a = query("SELECT * FROM lembaga_penerbit_halal, user WHERE user.id_user = lembaga_penerbit_halal.id_user ORDER BY lembaga_penerbit_halal.edit_lembaga DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function lembaga_penerbit_halal_satu($id, $ok) { $a = query_satu("SELECT * FROM lembaga_penerbit_halal WHERE id_lembaga_penerbit_halal = '$id'"); return $a[$ok]; } function satuan() { $i = []; $a = query("SELECT * FROM satuan ORDER BY id_jenis_qty ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function jenis_qty($id, $ok) { $a = query_satu("SELECT * FROM jenis_qty WHERE id_jenis_qty = '$id'"); return $a[$ok]; } function satuan_kecuali($id) { $i = []; $a = query("SELECT * FROM satuan WHERE id_satuan != '$id' ORDER BY id_jenis_qty ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function satuan_jenis_qty_kecuali($id) { $i = []; $a = query("SELECT * FROM satuan, jenis_qty WHERE jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty != '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function satuan_value() { $i = []; $a = query("SELECT * FROM satuan_value ORDER BY satuan1 ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function satuan_value_kg($id, $ok) { $a = query_satu("SELECT * FROM satuan_value WHERE satuan1 = '$id' AND satuan2 = 12"); return $a[$ok]; } function satuan_satu($id, $ok) { $a = query_satu("SELECT * FROM satuan, jenis_qty WHERE satuan.id_satuan = '$id' AND jenis_qty.id_jenis_qty = satuan.id_jenis_qty"); return @$a[$ok]; } function satuan_besar() { $i = []; $a = query("SELECT * FROM satuan WHERE id_jenis_qty = 1"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function satuan_besar_kecuali() { $i = []; $a = query("SELECT * FROM satuan WHERE id_jenis_qty <> 1"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function satuan_sedang() { $i = []; $a = query("SELECT * FROM satuan, jenis_qty WHERE jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 2"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function satuan_sedangkecil() { $i = []; $a = query("SELECT * FROM satuan, jenis_qty WHERE jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 2 or jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 3 or jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 4 or jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 5 ORDER BY satuan.id_jenis_qty ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function satuan_kecil() { $i = []; $a = query("SELECT * FROM satuan, jenis_qty WHERE jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 3"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function satuan_kecil_hujan_lagi() { $i = []; $a = query("SELECT * FROM satuan, jenis_qty WHERE jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 6"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function satuan_kecilpalingkecil() { $i = []; $a = query("SELECT * FROM satuan, jenis_qty WHERE jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 3 or jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 4 or jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 5 or jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 6 ORDER BY satuan.id_jenis_qty ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function satuan_palingkecil() { $i = []; $a = query("SELECT * FROM satuan, jenis_qty WHERE jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 4 or jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 5 or jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 6 ORDER BY satuan.id_jenis_qty ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function satuan_palingkecilkecil() { $i = []; $a = query("SELECT * FROM satuan, jenis_qty WHERE jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 5 or jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 6 ORDER BY satuan.id_jenis_qty ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function satuan_besarsedang() { $i = []; $a = query("SELECT * FROM satuan, jenis_qty WHERE jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 1 or jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 2 or jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 3 or jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 4 or jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND satuan.id_jenis_qty = 5 ORDER BY satuan.id_jenis_qty ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function country() { $i = []; $a = query("SELECT * FROM country"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function country_satu($id, $ok) { $a = query_satu("SELECT * FROM country WHERE id = '$id'"); return $a[$ok]; } function country_kecuali($id) { $i = []; $a = query("SELECT * FROM country WHERE id <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function pajak_satu($id, $i) { $a = query_satu("SELECT * FROM pajak WHERE id_pajak = '$id'"); return $a[$i]; } function pajak_persen_satu($id, $i) { $a = query_satu("SELECT * FROM pajak_persen WHERE id_pajak_persen = '$id'"); return $a[$i]; } function pajak_persen() { $i = []; $a = query("SELECT * FROM pajak_persen, pajak WHERE pajak.id_pajak = pajak_persen.id_pajak"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function expedisi_ongkir_jenis($id) { $i = []; $a = query("SELECT * FROM expedisi_ongkir_jenis WHERE id_expedisi = '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function expedisi_ongkir_jenis_satu($id, $ok) { $a = query_satu("SELECT * FROM expedisi_ongkir_jenis WHERE id_expedisi_ongkir_jenis = '$id'"); return @$a[$ok]; } function expedisi_satu($id, $o) { $a = query_satu("SELECT * FROM expedisi WHERE id_expedisi = '$id'"); return @$a[$o]; } function province() { $i = []; $a = query("SELECT * FROM provinces"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function province_kecuali($id) { $i = []; $a = query("SELECT * FROM provinces WHERE id != '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function regencies() { $i = []; $a = query("SELECT * FROM regencies"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function regencies_pilih($id) { $i = []; $a = query("SELECT * FROM regencies WHERE province_id = '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function regencies_kecuali($id, $o) { $i = []; $a = query("SELECT * FROM regencies WHERE province_id = '$id' AND id != '$o'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function districts() { $i = []; $a = query("SELECT * FROM districts"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function districts_pilih($id) { $i = []; $a = query("SELECT * FROM districts WHERE regency_id = '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function districts_kecuali($id, $o) { $i = []; $a = query("SELECT * FROM districts WHERE regency_id = '$id' AND id != '$o'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function expedisi_hp($id) { return query("SELECT * FROM expedisi_hp WHERE id_expedisi_hp= '$id'"); } function expedisi_hp_satu($id, $o) { $a = query_satu("SELECT * FROM expedisi_hp WHERE id_expedisi_contact = '$id'"); return $a[$o]; } function expedisi_alamat_prov($id, $ok) { $i = []; $a = query("SELECT * FROM expedisi_alamat, expedisi_header WHERE expedisi_alamat.id_provinsi = '$id' AND expedisi_alamat.id_expedisi = '$ok' AND expedisi_header.id_expedisi_header = expedisi_alamat.id_expedisi_header"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function expedisi_alamat_prov_jumlah($id, $ok) { return jumlah("SELECT * FROM expedisi_alamat WHERE id_provinsi = '$id' AND id_expedisi = '$ok'"); } function suplier_sertifikasi_halal($id) { $i = []; $a = query("SELECT * FROM suplier_sertifikasi_halal, lembaga_penerbit_halal WHERE suplier_sertifikasi_halal.id_suplier = '$id' AND lembaga_penerbit_halal.id_lembaga_penerbit_halal = suplier_sertifikasi_halal.id_lembaga_penerbit_halal"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function suplier_sertifikasi_halal_jumlah($id) { return jumlah("SELECT * FROM suplier_sertifikasi_halal WHERE id_suplier = '$id'"); } function suplier_sertifikasi_halal_satu($id, $ok) { $a = query_satu("SELECT * FROM suplier_sertifikasi_halal, lembaga_penerbit_halal WHERE suplier_sertifikasi_halal.id_suplier = '$id' AND lembaga_penerbit_halal.id_lembaga_penerbit_halal = suplier_sertifikasi_halal.id_lembaga_penerbit_halal"); return $a[$ok]; } function surat_pemesanan($id, $ok) { $a = query_satu("SELECT * FROM surat_pemesanan, suplier, status WHERE surat_pemesanan.id_surat_pemesanan = '$id' AND suplier.id_suplier = surat_pemesanan.id_suplier AND status.id_status = surat_pemesanan.id_status OR surat_pemesanan.no_po = '$id' AND suplier.id_suplier = surat_pemesanan.id_suplier AND status.id_status = surat_pemesanan.id_status"); return @$a[$ok]; } function surat_pemesanan_status() { foreach(surat_pemesanan_save() as $sps) : $a = jumlah("SELECT * FROM surat_pemesanan_detail WHERE id_surat_pemesanan = '$sps[id_surat_pemesanan]' AND sisa != 0"); if ($a == 0) { return query("UPDATE surat_pemesanan SET id_status = 1 WHERE id_surat_pemesanan = '$sps[id_surat_pemesanan]'"); } endforeach; } function surat_pemesanan_satu($id, $ok) { $a = query_satu("SELECT * FROM surat_pemesanan, suplier, status WHERE surat_pemesanan.id_surat_pemesanan = '$id' AND suplier.id_suplier = surat_pemesanan.id_suplier AND status.id_status = surat_pemesanan.id_status"); return $a[$ok]; } function surat_pemesanan_po($id, $ok) { $a = query_satu("SELECT * FROM surat_pemesanan, suplier, status WHERE surat_pemesanan.no_po = '$id' AND suplier.id_suplier = surat_pemesanan.id_suplier AND status.id_status = surat_pemesanan.id_status"); return @$a[$ok]; } function surat_pemesanan_si($id, $ok) { $a = query_satu("SELECT * FROM si_stok_detail, si_stok, customer, si, status WHERE si_stok_detail.id_si = '$id' AND si.id_si = '$id' AND customer.id_customer = si_stok.id_customer AND status.id_status = si.id_status"); return @$a[$ok]; } function surat_pemesanan_save() { $i = []; $a = query("SELECT * FROM surat_pemesanan, suplier, status WHERE surat_pemesanan.id_status <> 0 AND suplier.id_suplier = surat_pemesanan.id_suplier AND status.id_status = surat_pemesanan.id_status ORDER BY surat_pemesanan.tgl_po DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function surat_pemesanan_today() { $date = date("Y-m-d"); return query("SELECT * FROM surat_pemesanan WHERE tgl_po = '$date' AND id_status != 0"); } function surat_pemesanan_kredit($id, $ok) { $a = query_satu("SELECT * FROM surat_pemesanan_kredit WHERE id_surat_pemesanan = '$id'"); return $a[$ok]; } function surat_pemesanan_pajak($id, $ok) { $a = query_satu("SELECT * FROM surat_pemesanan_pajak WHERE id_surat_pemesanan = '$id'"); return $a[$ok]; } function surat_pemesanan_pajak_jumlah($id) { return jumlah("SELECT * FROM surat_pemesanan_pajak WHERE id_surat_pemesanan = '$id'"); } function surat_pemesanan_diskon($id, $ok) { $a = query_satu("SELECT * FROM surat_pemesanan_diskon WHERE id_surat_pemesanan = '$id'"); return $a[$ok]; } function surat_pemesanan_detail($id) { $i = []; $a = query("SELECT * FROM surat_pemesanan_detail, produk, satuan WHERE surat_pemesanan_detail.id_surat_pemesanan = '$id' AND produk.id_produk = surat_pemesanan_detail.id_produk AND satuan.id_satuan = surat_pemesanan_detail.id_satuan"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function surat_pemesanan_detail_si($id) { $i = []; $a = query("SELECT * FROM si_stok_detail, produk, satuan WHERE si_stok_detail.id_si = '$id' AND produk.id_produk = si_stok_detail.id_produk AND satuan.id_satuan = si_stok_detail.id_satuan"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function surat_pemesanan_detail_sisa() { $i = []; $a = query("SELECT distinct id_surat_pemesanan FROM surat_pemesanan_detail WHERE sisa <> 0 "); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function surat_pemesanan_detail_harga_satuan($id, $o, $y, $h) { $a = query_satu("SELECT * FROM surat_pemesanan_detail WHERE id_surat_pemesanan = '$id' AND id_produk = '$o' AND id_satuan = '$y'"); return $a[$h]; } function surat_pemesanan_detail_satu($id, $ok) { $a = query_satu("SELECT * FROM surat_pemesanan_detail WHERE id_surat_pemesanan_detail = '$id'"); return $a[$ok]; } function surat_pemesanan_detail_satu_dua($id_surat_pemesanan,$id_produk, $isi) { $a = query_satu("SELECT * FROM surat_pemesanan_detail WHERE id_surat_pemesanan = '$id_surat_pemesanan' AND id_produk = '$id_produk'"); return $a[$isi]; } function surat_pemesanan_detail_jum($id) { return jumlah("SELECT * FROM surat_pemesanan_detail WHERE id_surat_pemesanan = '$id'"); } function surat_pemesanan_detail_jum_produk($id, $y) { return jumlah("SELECT * FROM surat_pemesanan_detail WHERE id_surat_pemesanan = '$id' AND id_produk = '$y'"); } function surat_pemesanan_detail_diskon($id, $ok) { $a = query_satu("SELECT * FROM surat_pemesanan_detail_diskon WHERE id_surat_pemesanan_detail = '$id'"); return $a[$ok]; } function cek_ongkir($id, $ok) { $i = []; $a = query("SELECT * FROM ongkir, expedisi_ongkir_jenis, expedisi WHERE ongkir.kabupaten_pengirim = '$id' AND ongkir.kecamatan_tujuan = '$ok' AND expedisi_ongkir_jenis.id_expedisi_ongkir_jenis = ongkir.id_expedisi_ongkir_jenis AND expedisi.id_expedisi = expedisi_ongkir_jenis.id_expedisi"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function cek_ongkir_jumlah($id, $ok) { return jumlah("SELECT * FROM ongkir WHERE kabupaten_pengirim = '$id' AND kecamatan_tujuan = '$ok'"); } function company_nsw($a) { $b = query_satu("SELECT * FROM company WHERE id_company = 1"); return $b[$a]; } function surat_pemesanan_expedisi($id, $ok) { $a = query_satu("SELECT * FROM surat_pemesanan_expedisi, ongkir, expedisi_ongkir_jenis, expedisi WHERE surat_pemesanan_expedisi.id_surat_pemesanan = '$id' AND ongkir.id_ongkir = surat_pemesanan_expedisi.id_ongkir AND expedisi_ongkir_jenis.id_expedisi_ongkir_jenis = ongkir.id_expedisi_ongkir_jenis AND expedisi.id_expedisi = expedisi_ongkir_jenis.id_expedisi"); return @$a[$ok]; } function surat_pemesanan_expedisi_jum($id) { return jumlah("SELECT * FROM surat_pemesanan_expedisi WHERE id_surat_pemesanan = '$id'"); } function status_riwayat_terakhir($id, $ok, $yes) { $a = query_satu("SELECT * FROM status_riwayat WHERE kode = '$id' AND id_report = '$ok' ORDER BY tgl DESC"); return @$a[$yes]; } function status_riwayat_lalu($id, $ok, $ho) { $i = []; $a = query("SELECT * FROM status_riwayat WHERE kode = '$id' AND id_report = '$ok' AND tgl <> '$ho' ORDER BY tgl ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function status_riwayat_jum($id, $ok) { return jumlah("SELECT * FROM status_riwayat WHERE kode = '$id' AND id_report = '$ok'"); } function surat_pemesanan_brutto($id) { foreach (surat_pemesanan_detail($id) as $spd) : if ($spd["diskon"] == 1) { if (surat_pemesanan_detail_diskon($spd["id_surat_pemesanan_detail"], "tipe_diskon") == 1) { $diskon_produk = surat_pemesanan_detail_diskon($spd["id_surat_pemesanan_detail"], "value"); } elseif (surat_pemesanan_detail_diskon($spd["id_surat_pemesanan_detail"], "tipe_diskon") == 2) { $diskon_produk = ($spd["qty"] * $spd["harga_satuan"]) * surat_pemesanan_detail_diskon($spd["id_surat_pemesanan_detail"], "value") / 100; } } else { $diskon_produk = 0; } // $kg = $spd["weight_kg"]*$spd["qty"]; @$brutto = @$brutto + (($spd["harga_satuan"] * $spd["qty"])); // @$brutto = @$brutto + (($spd["harga_satuan"] * $spd["qty"]) - $diskon_produk); //@$total_kg = @$total_kg + $kg; // if ($spd["id_satuan"] == 12) { // $weight = $spd["qty"]; // }else { // $weight = satuan_value_kg($spd["id_satuan"],"value")*$spd["qty"]; // } // $brutto = $weight*$spd["harga_satuan"]-@$diskon_produk; // @$tot_brutto = @$tot_brutto + $brutto; endforeach; return $brutto; } function surat_pemesanan_diskon_nilai($id) { if (surat_pemesanan($id, "diskon") == 1) { if (surat_pemesanan_diskon($id, "tipe_diskon") == 1) { $diskon = surat_pemesanan_diskon($id, "value_diskon"); } elseif (surat_pemesanan_diskon($id, "tipe_diskon") == 2) { $diskon = surat_pemesanan_brutto($id) * (surat_pemesanan_diskon($id, "value_diskon") / 100); } } else { $diskon = 0; } return $diskon; } function surat_pemesanan_dpp($id) { //error_reporting(0); // foreach (surat_pemesanan_detail($id) as $spd) : // if ($spd["diskon"] == 1) { // if (surat_pemesanan_detail_diskon($spd["id_surat_pemesanan_detail"], "tipe_diskon") == 1) { // $diskon_produk = surat_pemesanan_detail_diskon($spd["id_surat_pemesanan_detail"], "value"); // } elseif (surat_pemesanan_detail_diskon($spd["id_surat_pemesanan_detail"], "tipe_diskon") == 2) { // $diskon_produk = ($spd["qty"] * $spd["harga_satuan"]) * surat_pemesanan_detail_diskon($spd["id_surat_pemesanan_detail"], "value") / 100; // } // }else{ // $diskon_produk = 0; // } // $brutto = ($spd["qty"] * $spd["harga_satuan"]) - $diskon_produk; // $total_brutto = $brutto; // $total_brutto += $total_brutto; // endforeach; // if (surat_pemesanan($id, "diskon") == 1) { // if (surat_pemesanan_diskon($id, "tipe_diskon") == 1) { // $diskon = surat_pemesanan_diskon($id, "value_diskon"); // } elseif (surat_pemesanan_diskon($id, "tipe_diskon") == 2) { // $diskon = surat_pemesanan_brutto($id) * surat_pemesanan_diskon($id, "value_diskon") / 100; // } // } else { // $diskon = 0; // } $dpp = surat_pemesanan_brutto($id) - surat_pemesanan_diskon_nilai($id); return $dpp; } function surat_pemesanan_tax($id) { $dpp = surat_pemesanan_dpp($id); if (surat_pemesanan($id, "pajak") == 1) { $pajak = $dpp * surat_pemesanan_pajak($id, "persen") / 100; } elseif (surat_pemesanan($id, "pajak") == 0) { $pajak = 0; } return $pajak; } function surat_pemesanan_ongkir($id) { error_reporting(0); // foreach (surat_pemesanan_detail($id) as $spd) : // $kg = $spd["weight_kg"] * $spd["qty"]; // $berat += $kg; // //$berat += $berat; // endforeach; // // $ongkir = surat_pemesanan_expedisi($id, "kg") * $berat; // return $ongkir; foreach (surat_pemesanan_detail($id) as $ss) : @$tt += $ss["weight_kg"] * $ss["qty"]; endforeach; $tt = surat_pemesanan_expedisi($id, "kg") * $tt; return $tt; } function surat_pemesanan_weight_kg($id) { foreach (surat_pemesanan_detail($id) as $spd) : @$tt += $spd["weight_kg"] * $spd["qty"]; endforeach; return $tt; } function surat_pemesanan_tgl_berakhir_po($id) { $b = mktime(0, 0, 0, date("n", strtotime(surat_pemesanan($id, "tgl_po"))), date("j", strtotime(surat_pemesanan($id, "tgl_po"))) + surat_pemesanan($id, "masa_berlaku"), date("Y", strtotime(surat_pemesanan($id, "tgl_po")))); $masa_berakhir_po = date("Y-m-d", $b); return query("UPDATE surat_pemesanan SET tgl_berakhir_po = '$masa_berakhir_po' WHERE id_surat_pemesanan = '$id'"); } // function surat_pemesanan_ongkir_master($id) // { // error_reporting(0); // foreach (surat_pemesanan_detail($id) as $spd) : // $kg = $spd["weight_kg"] * $spd["qty"]; // $berat += $kg; // //$berat += $berat; // endforeach; // // $ongkir = surat_pemesanan_expedisi($id, "kg") * $berat; // return $ongkir; // // foreach(surat_pemesanan_detail($id) as $ss) : // // @$tt += $ss["weight_kg"]*$ss["qty"]; // // endforeach; // // $tt = surat_pemesanan_expedisi($id,"kg")*$tt; // // return $tt; // } function surat_pemesanan_ongkir_diskon($id) { if (surat_pemesanan_diskon_ongkir_jum($id) > 0) { $x = surat_pemesanan_diskon_ongkir_satu($id, "nilai_diskon_ongkir"); } else { $x = 0; } return $x; } function surat_pemesanan_ongkir_bersih($id) { $tot = surat_pemesanan_ongkir($id) - surat_pemesanan_ongkir_diskon($id); return $tot; } function surat_pemesanan_netto($id) { error_reporting(0); $dpp = surat_pemesanan_dpp($id); $pajak = surat_pemesanan_tax($id); $ongkos_angkut = surat_pemesanan($id, "ongkos_angkut"); // foreach (surat_pemesanan_detail($id) as $spd) : // if ($spd["id_satuan"] == 12) { // $kg = $spd["qty"]; // } else { // $kg = satuan_value_kg($spd["id_satuan"], "value") * $spd["qty"]; // } // $berat += $kg; // //$berat += $berat; // endforeach; // $ongkir = surat_pemesanan_expedisi($id, "kg") * $berat; $ongkir = surat_pemesanan_ongkir_bersih($id); $netto = $dpp + $pajak; // $netto = $dpp + $pajak + $ongkos_angkut + $ongkir; return $netto; } function total_faktur_ql($id) { error_reporting(0); $dpp = surat_pemesanan_dpp($id); $pajak = surat_pemesanan_tax($id); $ongkos_angkut = surat_pemesanan($id, "ongkos_angkut"); $total_faktur = $dpp + $pajak + $ongkos_angkut; return $total_faktur; } function surat_pemesanan_gr() { $i = []; $a = query("SELECT * FROM surat_pemesanan, suplier WHERE surat_pemesanan.id_status = 3 AND suplier.id_suplier = surat_pemesanan.id_suplier"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function status_riwayat($id, $ok) { $i = []; $a = query("SELECT * FROM status_riwayat WHERE kode = '$id' AND id_report = '$ok' ORDER BY tgl DESC LIMIT 3"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function status_riwayatmodal($id, $ok) { $i = []; $a = query("SELECT * FROM status_riwayat WHERE kode = '$id' AND id_report = '$ok'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function status_riwayat_all($id, $ok) { return query("SELECT * FROM status_riwayat WHERE kode = '$id' AND id_report = '$ok'"); } function menu() { $i = []; $a = query("SELECT * FROM menu"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function menu_satu($id, $ok) { $a = query_satu("SELECT * FROM menu WHERE id_menu = '$id'"); return $a[$ok]; } function menu_halaman($id) { $i = []; $a = query("SELECT * FROM menu_halaman WHERE id_menu = '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function menu_option() { $i = []; $a = query("SELECT * FROM menu_option ORDER BY id_menu_option ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function level_user() { $i = []; $a = query("SELECT * FROM level_user, user_jenis WHERE user_jenis.id_user_jenis = level_user.id_user_jenis ORDER BY level_user.edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function level_user_kecuali($id) { $i = []; $a = query("SELECT * FROM level_user, user_jenis WHERE user_jenis.id_user_jenis = level_user.id_user_jenis AND level_user.id_level_user <> '$id' ORDER BY level_user.edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function level_user_jum() { return jumlah("SELECT * FROM level_user"); } function level_user_per_user($id) { return jumlah("SELECT * FROM user WHERE id_level_user = '$id'"); } function level_user_satu($id, $ok) { $a = query_satu("SELECT * FROM level_user, user_jenis WHERE level_user.id_level_user = '$id' AND user_jenis.id_user_jenis = level_user.id_user_jenis"); return $a[$ok]; } function user_jenis() { $i = []; $a = query("SELECT * FROM user_jenis, user WHERE user.id_user = user_jenis.id_user ORDER BY user_jenis.edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function user_jenis_kecuali($id) { $i = []; $a = query("SELECT * FROM user_jenis, user WHERE user.id_user = user_jenis.id_user AND user_jenis.id_user_jenis <> '$id' ORDER BY user_jenis.edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function menu_halaman_option_jumsatu($id, $ok, $tes) { return jumlah("SELECT * FROM menu_halaman_option WHERE id_menu_halaman = '$id' AND id_menu_option = '$ok' AND id_level_user = '$tes'"); } function menu_halaman_option_level_user($id, $ok) { return jumlah("SELECT * FROM menu_halaman_option, menu_halaman, menu WHERE menu_halaman_option.id_level_user = '$id' AND menu_halaman.id_menu_halaman = menu_halaman_option.id_menu_halaman AND menu.id_menu = menu_halaman.id_menu AND menu.id_menu = '$ok'"); } function user_satu($id, $ok) { $a = query_satu("SELECT * FROM user, status_user WHERE user.id_user = '$id' AND status_user.id_status_user = user.id_status_user"); return @$a[$ok]; } function report() { $i = []; $a = query("SELECT * FROM report, report_setting_jenis WHERE report_setting_jenis.id_report_setting_jenis = report.id_report_setting_jenis"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function report_setting($id) { $i = []; $a = query("SELECT * FROM report_setting, report_setting_ttd_jenis, level_user WHERE id_report = '$id' AND report_setting_ttd_jenis.id_report_setting_ttd_jenis = report_setting.id_report_setting_ttd_jenis AND level_user.id_level_user = report_setting.id_level_user ORDER BY report_setting.urutan ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function report_setting_urutan_satu($id, $o, $y) { $a = query_satu("SELECT * FROM report_setting WHERE id_report = '$id' AND urutan = '$o'"); return $a[$y]; } function report_setting_status_satu($id, $o, $y) { $a = query_satu("SELECT * FROM report_setting WHERE id_report = '$id' AND id_status = '$o' ORDER BY urutan ASC"); return $a[$y]; } function report_setting_kecuali_satu($id, $o, $x, $y) { $a = query_satu("SELECT * FROM report_setting WHERE id_report = '$id' AND id_status != '$o' AND urutan > '$x' ORDER BY urutan ASC"); return $a[$y]; } function report_satu($id, $ok) { $a = query_satu("SELECT * FROM report, report_setting_jenis WHERE report.id_report = '$id' AND report_setting_jenis.id_report_setting_jenis = report.id_report_setting_jenis"); return $a[$ok]; } function report_setting_ttd_jenis() { $i = []; $a = query("SELECT * FROM report_setting_ttd_jenis ORDER BY edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function report_setting_jum($id) { return jumlah("SELECT * FROM report_setting WHERE id_report = '$id'"); } function report_gudang($id) { $a = query_satu("SELECT id_gudang FROM report_gudang WHERE id_report = '$id'"); return $a["id_gudang"]; } function report_gudang_satu($id, $o) { $a = query_satu("SELECT * FROM report_gudang WHERE id_report = '$id'"); return $a[$o]; } function report_gudang_rh_satu($id, $y, $o) { $a = query_satu("SELECT * FROM report_gudang WHERE id_report = '$id' AND id_riwayat_header = '$y'"); return $a[$o]; } function report_gudang_jum($id) { return jumlah("SELECT id_gudang FROM report_gudang WHERE id_report = '$id'"); } function report_rek_jum($id_report) { return jumlah("SELECT * FROM report_rek WHERE id_report = '$id_report'"); } function report_rek_satu($id_report,$o) { $a = query_satu("SELECT * FROM report_rek WHERE id_report = '$id_report'"); return $a[$o]; } function user_akses_jumlah($id, $ok, $yes) { return jumlah("SELECT * FROM user_akses WHERE id_user = '$id' AND id_menu_halaman = '$ok' AND id_menu_option = '$yes'"); } function user_akses_satu($id, $ok, $haha, $yes) { $a = query_satu("SELECT * FROM user_akses WHERE id_user = '$id' AND id_menu_halaman = '$ok' AND id_menu_option = '$haha' AND id_user <> 1"); return $a[$yes]; } function user_akses_cek($id, $ok) { return jumlah("SELECT * FROM user_akses, menu_halaman, menu WHERE user_akses.id_user = '$id' AND menu_halaman.id_menu_halaman = user_akses.id_menu_halaman AND menu.id_menu = menu_halaman.id_menu AND menu.id_menu = '$ok'"); } function user_kecuali($id) { $i = []; $a = query("SELECT * FROM user, status_user WHERE user.id_user <> '$id' AND status_user.id_status_user = user.id_status_user AND user.id_user <> 1"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function status_user_kecuali($id) { $i = []; $a = query("SELECT * FROM status_user WHERE id_status_user <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function user_jum() { return jumlah("SELECT * FROM user WHERE id_user <> 1"); } function surat_pemesanan_diskon_ongkir_jum($id) { return jumlah("SELECT * FROM surat_pemesanan_diskon_ongkir WHERE id_surat_pemesanan = '$id'"); } function surat_pemesanan_diskon_ongkir_satu($id, $ok) { $a = query_satu("SELECT * FROM surat_pemesanan_diskon_ongkir WHERE id_surat_pemesanan = '$id'"); return $a[$ok]; } function user_ttd_jum($id) { return jumlah("SELECT * FROM user_ttd WHERE id_user = '$id'"); } function user_ttd_satu($id, $ok) { $a = query_satu("SELECT * FROM user_ttd WHERE id_user = '$id'"); return $a[$ok]; } function gr_satu($id, $ok) { $a = query_satu("SELECT * FROM gr, suplier WHERE gr.id_gr = '$id' AND suplier.id_suplier = gr.id_suplier or gr.no_gr = '$id' AND suplier.id_suplier = gr.id_suplier"); return $a[$ok]; } function gr_no($no_gr,$isi) { $a = query_satu("SELECT * FROM gr WHERE no_gr = '$no_gr'"); return $a[$isi]; } function gr_alone($id, $ok) { $a = query_satu("SELECT * FROM gr WHERE id_gr = '$id'"); return $a[$ok]; } function gr_pesanan($id) { $i = []; $a = query("SELECT * FROM gr_pesanan, produk, gr, satuan WHERE gr_pesanan.id_gr = '$id' AND produk.id_produk = gr_pesanan.id_produk AND gr.id_gr = gr_pesanan.id_gr AND gr_pesanan.id_satuan = satuan.id_satuan"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function gr_pesanan_satu($id, $ok, $ye, $ya) { $a = query_satu("SELECT * FROM gr_pesanan WHERE id_gr = '$id' AND id_produk = '$ok' AND id_satuan = '$ye'"); return $a[$ya]; } function gr_pesanan_jumlah($id, $ok, $ye) { return jumlah("SELECT * FROM gr_pesanan WHERE id_gr = '$id' AND id_produk = '$ok' AND id_satuan = '$ye'"); } function gr_pesanan_qty_diterima($id) { foreach (gr_pesanan($id) as $gp) { $qty = $gp["qty_diterima"]; @$tot += $qty; } return $tot; } function gr_pesanan_qty_rusak($id) { foreach (gr_pesanan($id) as $gp) { $qty = $gp["qty_kondisi_rusak"]; @$tot += $qty; } return $tot; } function gr_pesanan_qty_baik($id) { foreach (gr_pesanan($id) as $gp) { $qty = $gp["qty_kondisi_baik"]; @$tot += $qty; } return $tot; } function gr_pesanan_qty_awal($id) { foreach (gr_pesanan($id) as $gp) { $qty = $gp["qty_awal"]; @$tot += $qty; } return $tot; } function gr_pesanan_total($id, $ok) { error_reporting(0); foreach (gr_pesanan($id) as $gp) { $id_produk = $gp["id_produk"]; $id_satuan = $gp["id_satuan"]; $qty_diterima = $gp["qty_diterima"]; $a = query("SELECT * FROM surat_pemesanan_detail WHERE id_surat_pemesanan = '$ok' AND id_produk = '$id_produk' AND id_satuan = '$id_satuan'"); while ($l_a = query_banyak($a)) { $harga_satuan = $l_a["harga_satuan"]; $total = $harga_satuan * $qty_diterima; @$tot += @$tot + $total; } } return @$tot; } function gr() { $i = []; $a = query("SELECT * FROM gr, suplier, status WHERE suplier.id_suplier = gr.id_suplier AND status.id_status = gr.id_status AND gr.no_gr <> ''"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function gr_header_satu($id, $ok) { $a = query_satu("SELECT * FROM gr_header WHERE id_gr = '$id' AND id_status = 0"); return $a[$ok]; } function gr_pesanan_ex($id, $yes, $j) { $a = query_satu("SELECT * FROM gr_pesanan_ex, expired WHERE expired.id_expired = gr_pesanan_ex.id_expired AND gr_pesanan_ex.id_gr_pesanan = '$id' AND gr_pesanan_ex.id_expired = '$yes'"); return @$a[$j]; } function gr_pesanan_ex_jum($id, $yes) { return jumlah("SELECT * FROM gr_pesanan_ex, expired WHERE expired.id_expired = gr_pesanan_ex.id_expired AND gr_pesanan_ex.id_gr_pesanan = '$id' AND gr_pesanan_ex.id_expired = '$yes'"); } function gr_pesanan_total_qty_minus($id) { foreach (gr_pesanan($id) as $gp) { $qty_minus = $gp["qty_minus"]; @$tot += $qty_minus; } return @$tot; } function gr_produk_sisa($id, $ok, $ye) { $a = query_satu("SELECT * FROM gr_produk_sisa WHERE id_gr = '$id' AND id_produk = '$ok'"); return $a[$ye]; } function status_satu($id, $ok) { $a = query_satu("SELECT * FROM status WHERE id_status = '$id'"); return $a[$ok]; } function status() { return query("SELECT * FROM status"); } function status_kecuali($id) { return query("SELECT * FROM status WHERE id_status != '$id'"); } function report_coa($id, $ok) { $a = query_satu("SELECT * FROM report_coa, coa, suplier_jenis WHERE coa.id_coa = report_coa.id_coa AND report_coa.id_report = '$id' AND suplier_jenis.id_suplier_jenis = report_coa.id_suplier_jenis"); return $a[$ok]; } function report_coa_all($id_report) { return query("SELECT * FROM report_coa WHERE id_report = '$id_report'"); } function report_coa_dua($id, $ok, $y) { $a = query_satu("SELECT * FROM report_coa, coa, suplier_jenis WHERE coa.id_coa = report_coa.id_coa AND report_coa.id_report = '$id' AND suplier_jenis.id_suplier_jenis = report_coa.id_suplier_jenis AND report_coa.id_suplier_jenis = '$ok'"); return $a[$y]; } function report_coa_satu($id, $ok, $y) { $a = query_satu("SELECT * FROM report_coa, coa WHERE report_coa.id_report = '$id' AND report_coa.id_suplier_jenis = '$ok' AND coa.id_coa = report_coa.id_coa"); return $a[$y]; } function report_coa_lihat($id) { $i = []; $a = query("SELECT * FROM report_coa, suplier_jenis, coa WHERE report_coa.id_report = '$id' AND suplier_jenis.id_suplier_jenis = report_coa.id_suplier_jenis AND coa.id_coa = report_coa.id_coa"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function report_coa_lihat_satu($id_report, $id_akuntan_jenis, $id_suplier_jenis, $isi) { $a = query_satu("SELECT * FROM report_coa WHERE id_report = '$id_report' AND id_akuntan_jenis = '$id_akuntan_jenis' AND id_suplier_jenis = '$id_suplier_jenis'"); return $a[$isi]; } function kode_bulan($id, $yes, $ya, $yo) { $a = query_satu("SELECT * FROM kode_bulan WHERE bulan = '$id' AND tahun = '$yes' AND id_report = '$ya'"); return $a[$yo]; } function kode_bulan_jum($id, $ya, $yo) { return jumlah("SELECT * FROM kode_bulan WHERE bulan = '$id' AND tahun = '$ya' AND id_report = '$yo'"); } function get_total_accounts() { return jumlah("SELECT * FROM user"); } function get_total_products() { return jumlah("SELECT * FROM produk"); } function get_total_customers() { return jumlah("SELECT * FROM customer"); } function get_total_branch() { return jumlah("SELECT * FROM cabang"); } function get_total_sales() { return jumlah("SELECT * FROM sales"); } function get_total_category() { return jumlah("SELECT * FROM kategori"); } function get_total_promo_active() { $total = 0; foreach (diskon() as $d) { if ($d["status_diskon"] == 1) { if (expired2($d["kadaluarsa"], $d["tgl_kadaluarsa"]) == true) { $total++; } } } return $total; } function get_total_active_purchase_order() { $total = 0; foreach (surat_pemesanan_save() as $d) { $encrypted = enc($d["id_surat_pemesanan"]); if ($encrypted) { $id = mysqli_real_escape_string(konek(), dec($encrypted)); if ($id) { if (surat_pemesanan($id, "masa_berlaku") > 0) { $total++; } } } } return $total; } function invoice_pi() { $i = []; $a = query("SELECT * FROM invoice WHERE id_report = 10"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function invoice_pi_brutto($id_gr, $id_surat_pemesanan) { foreach (gr_pesanan($id_gr) as $ip) { $har_sat = surat_pemesanan_detail_harga_satuan($id_surat_pemesanan, $ip["id_produk"], $ip["id_satuan"], "harga_satuan"); if (surat_pemesanan_detail_harga_satuan($id_surat_pemesanan, $ip["id_produk"], $ip["id_satuan"], "diskon") == 1) { if (surat_pemesanan_detail_diskon(surat_pemesanan_detail_harga_satuan($id_surat_pemesanan, $ip["id_produk"], $ip["id_satuan"], "id_surat_pemesanan_detail"), "tipe_diskon") == 1) { $diskon_produk = surat_pemesanan_detail_diskon(surat_pemesanan_detail_harga_satuan($id_surat_pemesanan, $ip["id_produk"], $ip["id_satuan"], "id_surat_pemesanan_detail"), "value"); } else { $diskon_produk = surat_pemesanan_detail_diskon(surat_pemesanan_detail_harga_satuan($id_surat_pemesanan, $ip["id_produk"], $ip["id_satuan"], "id_surat_pemesanan_detail"), "value") * ($ip["qty_diterima"] * $har_sat) / 100; } } else { $diskon_produk = 0; } // $brutto = $ip["qty_diterima"] * $har_sat - $diskon_produk; $brutto = $ip["qty_diterima"] * $har_sat - $diskon_produk; @$tot = @$tot + $brutto; } return @$tot; } function invoice_pi_diskon($id_surat_pemesanan, $id_gr) { if (surat_pemesanan($id_surat_pemesanan, "diskon") == 1) { if (surat_pemesanan_diskon($id_surat_pemesanan, "tipe_diskon") == 1) { $diskon_akhir = surat_pemesanan_diskon($id_surat_pemesanan, "value_diskon"); } elseif (surat_pemesanan_diskon($id_surat_pemesanan, "tipe_diskon") == 2) { $diskon_akhir = invoice_pi_brutto($id_gr, $id_surat_pemesanan) * surat_pemesanan_diskon($id_surat_pemesanan, "value_diskon") / 100; } } elseif (surat_pemesanan($id_surat_pemesanan, "diskon") == 0) { echo $diskon_akhir = null; } return $diskon_akhir; } function invoice_pi_dpp($id_gr, $id_surat_pemesanan) { return invoice_pi_brutto($id_gr, $id_surat_pemesanan) - invoice_pi_diskon($id_surat_pemesanan, $id_gr); } function invoice_pi_tax($id_surat_pemesanan, $id_gr) { if (surat_pemesanan($id_surat_pemesanan, "pajak") == 1) { $pajak = (invoice_pi_dpp($id_gr, $id_surat_pemesanan)) * surat_pemesanan_pajak($id_surat_pemesanan, "persen") / 100; } else { $pajak = 0; } return $pajak; } function invoice_pi_ongkir($id) { // foreach (surat_pemesanan_detail($id) as $ss) : // @$tt += $ss["weight_kg"] * $ss["qty"]; // endforeach; // $tt = surat_pemesanan_expedisi($id, "kg") * $tt; // return $tt; } function invoice_po($id) { if (invoice_header($id, "id_report") == 1) { $no_po = invoice_header($id, "kode"); } elseif (invoice_header($id, "id_report") == 9) { $no_po = gr_satu(invoice_header($id, "kode"), "no_po"); } return $no_po; } function invoice_header($id, $ok) { $a = query_satu("SELECT * FROM invoice_header WHERE no_invoice = '$id'"); return @$a[$ok]; } function invoice_satu($id, $o) { $a = query_satu("SELECT * FROM invoice WHERE no_invoice = '$id'"); return $a[$o]; } function invoice($id_report) { return query("SELECT * FROM invoice WHERE id_report = '$id_report'"); } function invoice_jumlah($no_invoice) { return jumlah("SELECT * FROM invoice WHERE no_invoice = '$no_invoice'"); } function stok_produk_satu($id, $ok, $y) { $a = query_satu("SELECT * FROM stok_produk WHERE id_produk = '$id' AND id_satuan = '$ok'"); return $a[$y]; } function stok_produk_ulang_satu() { $i = []; $a = query("SELECT distinct id_produk, id_satuan FROM stok_produk ORDER BY id_produk ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function stok_produk_total($id, $ok) { $a = query_satu("SELECT SUM(value_stok) AS total_value FROM stok_produk WHERE id_produk = '$id' AND id_satuan = '$ok'"); return $a["total_value"]; } function stok_produk_control_satu($a, $b, $c) { $d = query_satu("SELECT * FROM stok_produk_control WHERE id_produk = '$a' AND bsk = '$b'"); return $d[$c]; } function produk_satuan_nilai_jum($id) { return jumlah("SELECT * FROM produk_satuan_nilai WHERE id_produk = '$id'"); } function produk_satuan_nilai_satu($id) { $i = []; $a = query("SELECT * FROM produk_satuan_nilai WHERE id_produk = '$id' AND tampil = 1"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function produk_satuan_nilai_nol($id) { $i = []; $a = query("SELECT * FROM produk_satuan_nilai WHERE id_produk = '$id' AND tampil = 0"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function produk_satuan_nilai_jumlah($id, $ok) { return jumlah("SELECT * FROM produk_satuan_nilai WHERE satuan1 = '$id' AND id_produk = '$ok'"); } function produk_satuan_nilai_jumlah_sama($id, $ok, $yes) { return jumlah("SELECT * FROM produk_satuan_nilai WHERE satuan1 = '$id' AND satuan2 = '$ok' AND id_produk = '$yes'"); } function produk_satuan_nilai($id, $y, $z, $x) { $a = query_satu("SELECT * FROM produk_satuan_nilai WHERE id_produk = '$id' AND satuan1 = '$y' AND satuan2 = '$z'"); return @$a[$x]; } function produk_satuan_nilai_all($id) { return query("SELECT * FROM produk_satuan_nilai WHERE id_produk = '$id'"); } function produk_satuan_b_jum($id) { return jumlah("SELECT * FROM produk_isi_satuan, satuan, jenis_qty WHERE produk_isi_satuan.id_produk = '$id' AND satuan.id_satuan = produk_isi_satuan.id_satuan AND jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND jenis_qty.id_jenis_qty = 1 or produk_isi_satuan.id_produk = '$id' AND satuan.id_satuan = produk_isi_satuan.id_satuan AND jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND jenis_qty.id_jenis_qty = 2"); } function produk_satuan_b($id) { $i = []; $a = query("SELECT * FROM produk_isi_satuan, satuan, jenis_qty WHERE produk_isi_satuan.id_produk = '$id' AND satuan.id_satuan = produk_isi_satuan.id_satuan AND jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND jenis_qty.id_jenis_qty = 1 or produk_isi_satuan.id_produk = '$id' AND satuan.id_satuan = produk_isi_satuan.id_satuan AND jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND jenis_qty.id_jenis_qty = 2"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function produk_satuan_b_satu($id, $ok) { $a = query_satu("SELECT * FROM produk_isi_satuan, satuan, jenis_qty WHERE produk_isi_satuan.id_produk = '$id' AND satuan.id_satuan = produk_isi_satuan.id_satuan AND jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND jenis_qty.id_jenis_qty = 1 or produk_isi_satuan.id_produk = '$id' AND satuan.id_satuan = produk_isi_satuan.id_satuan AND jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND jenis_qty.id_jenis_qty = 2"); return $a[$ok]; } function produk_satuan_s_jum($id) { return jumlah("SELECT * FROM produk_isi_satuan, satuan, jenis_qty WHERE produk_isi_satuan.id_produk = '$id' AND satuan.id_satuan = produk_isi_satuan.id_satuan AND jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND jenis_qty.id_jenis_qty = 3 or produk_isi_satuan.id_produk = '$id' AND satuan.id_satuan = produk_isi_satuan.id_satuan AND jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND jenis_qty.id_jenis_qty = 4"); } function produk_satuan_s_satu($id, $ok) { $a = query_satu("SELECT * FROM produk_isi_satuan, satuan, jenis_qty WHERE produk_isi_satuan.id_produk = '$id' AND satuan.id_satuan = produk_isi_satuan.id_satuan AND jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND jenis_qty.id_jenis_qty = 3 or produk_isi_satuan.id_produk = '$id' AND satuan.id_satuan = produk_isi_satuan.id_satuan AND jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND jenis_qty.id_jenis_qty = 4"); return $a[$ok]; } function produk_satuan_k_satu($id, $ok) { $a = query_satu("SELECT * FROM produk_isi_satuan, satuan, jenis_qty WHERE produk_isi_satuan.id_produk = '$id' AND satuan.id_satuan = produk_isi_satuan.id_satuan AND jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND jenis_qty.id_jenis_qty = 5 or produk_isi_satuan.id_produk = '$id' AND satuan.id_satuan = produk_isi_satuan.id_satuan AND jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND jenis_qty.id_jenis_qty = 6"); return $a[$ok]; } function produk_satuan_s($id) { $i = []; $a = query("SELECT * FROM produk_isi_satuan, satuan, jenis_qty WHERE produk_isi_satuan.id_produk = '$id' AND satuan.id_satuan = produk_isi_satuan.id_satuan AND jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND jenis_qty.id_jenis_qty = 3 or produk_isi_satuan.id_produk = '$id' AND satuan.id_satuan = produk_isi_satuan.id_satuan AND jenis_qty.id_jenis_qty = satuan.id_jenis_qty AND jenis_qty.id_jenis_qty = 4"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function jenis_qty_satu($id, $y) { $a = query_satu("SELECT * FROM jenis_qty WHERE id_jenis_qty = '$id'"); return $a[$y]; } function gudang() { $i = []; $a = query("SELECT * FROM gudang ORDER BY edit DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function gudang_satu($id, $y) { $a = query_satu("SELECT * FROM gudang WHERE id_gudang = '$id'"); return $a[$y]; } function gudang_kecuali($id) { return query("SELECT * FROM gudang WHERE id_gudang != '$id'"); } function gudang_produk_jum($id_produk, $id_gudang, $id_satuan, $id_wo_jenis) { return jumlah("SELECT * FROM gudang_produk WHERE id_produk = '$id_produk' AND id_gudang = '$id_gudang' AND id_satuan = '$id_satuan' AND id_wo_jenis = '$id_wo_jenis'"); } function gudang_produk_satu($id_produk, $id_gudang, $id_satuan, $id_wo_jenis, $isi) { $a = query_satu("SELECT * FROM gudang_produk WHERE id_produk = '$id_produk' AND id_gudang = '$id_gudang' AND id_satuan = '$id_satuan' AND id_wo_jenis = '$id_wo_jenis'"); return $a[$isi]; } function jenis_satuan() { $i = []; $a = query("SELECT * FROM jenis_qty"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function mata_uang_kecuali($id) { $i = []; $a = query("SELECT * FROM mata_uang WHERE id_mata_uang <> '$id' AND id_mata_uang = 0"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function mata_uang(){ return query("SELECT * FROM mata_uang"); } function mata_uang_satu($id_mata_uang,$isi) { $a = query_satu("SELECT * FROM mata_uang WHERE id_mata_uang = '$id_mata_uang'"); return $a[$isi]; } function warna_kecuali($id) { $i = []; $a = query("SELECT * FROM warna WHERE id_warna <> '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function ukuran() { $i = []; $a = query("SELECT * FROM ukuran"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function ukuran_satu($id, $x) { $a = query_satu("SELECT * FROM ukuran WHERE id_ukuran = '$id'"); return $a[$x]; } function produk_ukuran_isi_satu($id, $y, $u) { $a = query_satu("SELECT * FROM produk_ukuran_isi WHERE id_ukuran = '$id' AND id_produk = '$y'"); return $a[$u]; } function produk_ukuran_isi_jum($id) { return jumlah("SELECT * FROM produk_ukuran_isi WHERE id_produk = '$id'"); } function produk_ukuran_isi_total($id) { $pu_yeah = query_satu("SELECT ROUND(EXP(SUM(LOG(nilai))),0) as total FROM produk_ukuran_isi WHERE id_produk = '$id'"); return $pu_yeah["total"]; } function produk_ukuran_isi($id) { $i = []; $a = query("SELECT * FROM produk_ukuran_isi WHERE id_produk = '$id' ORDER BY id_ukuran ASC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function harga_produk_terbesar_jum($id) { return jumlah("SELECT * FROM harga_produk_terbesar WHERE id_produk = '$id'"); } function harga_produk_terbesar_pilih($id, $ok) { $i = []; $a = query("SELECT * FROM harga_produk_terbesar WHERE id_seller = '$id' AND id_produk = '$ok'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function harga_produk_terbesar($id) { $i = []; $a = query("SELECT * FROM harga_produk_terbesar WHERE id_produk = '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function harga_produk_terbesar_all() { return query("SELECT * FROM harga_produk_terbesar"); } function harga_produk_terbesar_hanya_produk() { return query("SELECT distinct id_produk FROM harga_produk_terbesar"); } function harga_produk_terbesar_satu($id, $ok, $y) { $a = query_satu("SELECT * FROM harga_produk_terbesar WHERE id_seller = '$id' AND id_produk = '$ok'"); return @$a[$y]; } function produk_harga_jual_jum($id) { return jumlah("SELECT * FROM produk_harga_jual WHERE id_harga_produk_terbesar = '$id'"); } function produk_harga_jual($id, $ok) { $a = query_satu("SELECT * FROM produk_harga_jual WHERE id_harga_produk_terbesar = '$id'"); return $a[$ok]; } function produk_harga_header_satu($id, $ok) { $a = query_satu("SELECT * FROM produk_harga_header WHERE id_produk_harga_header = '$id'"); return $a[$ok]; } function produk_harga_header() { $i = []; $a = query("SELECT * FROM produk_harga_header WHERE id_produk_harga_header <> 1"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function produk_harga_header_kecuali($id) { $i = []; $a = query("SELECT * FROM produk_harga_header WHERE id_produk_harga_header NOT IN(SELECT id_produk_harga_header FROM produk_harga_jual WHERE id_harga_produk_terbesar = '$id')"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function produk_harga_jual_ada($id) { $i = []; $a = query("SELECT * FROM produk_harga_jual WHERE id_harga_produk_terbesar = '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function produk_expired_jum($id) { return jumlah("SELECT * FROM produk_expired WHERE id_produk = '$id'"); } function produk_expired($id) { $i = []; $a = query("SELECT * FROM produk_expired WHERE id_produk = '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function expired_all() { $i = []; $a = query("SELECT * FROM expired"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function expired_satu($id, $ok) { $a = query_satu("SELECT * FROM expired WHERE id_expired = '$id'"); return $a[$ok]; } function bom() { $i = []; $a = query("SELECT * FROM bom"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function bom_detail($id) { return query("SELECT * FROM bom_detail WHERE id_bom = '$id'"); } function bom_detail_jum($id) { return jumlah("SELECT * FROM bom_detail WHERE id_bom = '$id'"); } function bom_satu($id, $ok) { $a = query_satu("SELECT * FROM bom WHERE id_bom = '$id'"); return @$a[$ok]; } function bom_satuan($id) { return query("SELECT * FROM bom_satuan WHERE id_bom = '$id'"); } function bom_satuan_jum($id) { return jumlah("SELECT * FROM bom_satuan WHERE id_bom = '$id'"); } function bom_satuan_satu($id_bom, $id_produk, $y) { $a = query_satu("SELECT * FROM bom_satuan WHERE id_bom = '$id_bom' AND id_produk = '$id_produk'"); return $a[$y]; } function bom_reciep_satuan_jum($id) { return jumlah("SELECT * FROM bom_reciep_satuan WHERE id_bom = '$id'"); } function bom_reciep_satuan_satu($id, $o) { $a = query_satu("SELECT * FROM bom_reciep_satuan WHERE id_bom = '$id'"); return @$a[$o]; } function ppic_favorit($id) { $i = []; $a = query("SELECT * FROM ppic WHERE fav = 1 AND id_user = '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function ppic_not_fav_jum($id) { $user = user("id_user"); return jumlah("SELECT * FROM ppic WHERE id_bom = '$id' AND id_user = '$user' AND fav = 0"); } function ppic_one($id, $ok, $y) { $user = user("id_user"); $a = query_satu("SELECT * FROM ppic WHERE id_bom = '$id' AND id_user = '$user' AND fav = '$ok'"); return $a[$y]; } function ppic($id) { $i = []; $a = query("SELECT * FROM ppic WHERE fav = 0 AND id_user = '$id'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function ppic_tot($id) { $user = user("id_user"); $c = query("SELECT distinct id_produk FROM bom_detail WHERE id_bom IN(SELECT id_bom FROM ppic WHERE fav = 1)"); while ($d = query_banyak($c)) { if ($id == 1) { foreach (ppic_favorit($user) as $pf) : if (@produk_isi_satuan_awal($d["id_produk"], "id_satuan")) { if (@$resep_persen = @bom_detail_satu($pf["id_bom"], $d["id_produk"], "resep_persen")) { if ($pf["b"] != 0) { @$tot = ($resep_persen) * ($pf["b"] * produk_satuan_nilai($d["id_produk"], @produk_isi_satuan_awal($d["id_produk"], "id_satuan"), @produk_isi_satuan_akhir($d["id_produk"], "id_satuan"), "nilai")) / 100; $cek = jumlah("SELECT * FROM ppic_tot WHERE id_produk = '$d[id_produk]' AND id_user = '$user'"); if ($cek == 0) { if (!empty($tot)) { query("INSERT INTO ppic_tot (id_produk,tot,id_user) VALUES('$d[id_produk]','$tot','$user')"); } } else { $lih = query_satu("SELECT * FROM ppic_tot WHERE id_produk = '$d[id_produk]' AND id_user = '$user'"); $hehe = $lih["tot"] + $tot; if (!empty($hehe)) { query("UPDATE ppic_tot SET tot = '$hehe' WHERE id_produk = '$d[id_produk]' AND id_user = '$user'"); } } } else { @$tot = @$pf["k"] * bom_detail_satu($pf["id_bom"], $d["id_produk"], "resep_persen") / 100; $cek = jumlah("SELECT * FROM ppic_tot WHERE id_produk = '$d[id_produk]' AND id_user = '$user'"); if ($cek == 0) { if (!empty($tot)) { query("INSERT INTO (id_produk,tot,id_user) ppic_tot VALUES('$d[id_produk]','$tot','$user')"); } } else { $lih = query_satu("SELECT * FROM ppic_tot WHERE id_produk = '$d[id_produk]' AND id_user = '$user'"); $hehe = $lih["tot"] + $tot; if (!empty($hehe)) { query("UPDATE ppic_tot SET tot = '$hehe' WHERE id_produk = '$d[id_produk]' AND id_user = '$user'"); } } //numb_nol($pf["k"]/produk_satuan_nilai($d["id_produk"], @produk_isi_satuan_awal($d["id_produk"], "id_satuan"), @produk_isi_satuan_akhir($d["id_produk"], "id_satuan"), "nilai")); } } else { $xx = 0; //echo "Resep nya kosong<br>"; } } else { $xx = 0; //echo '0<br>'; } endforeach; } elseif ($id == 2) { foreach (ppic($user) as $p) : if (@produk_isi_satuan_awal($d["id_produk"], "id_satuan")) { if (@$resep_persen = @bom_detail_satu($p["id_bom"], $d["id_produk"], "resep_persen")) { if ($p["b"] != 0) { @$tot = ($resep_persen) * ($p["b"] * produk_satuan_nilai($d["id_produk"], @produk_isi_satuan_awal($d["id_produk"], "id_satuan"), @produk_isi_satuan_akhir($d["id_produk"], "id_satuan"), "nilai")) / 100; $cek = jumlah("SELECT * FROM ppic_tot WHERE id_produk = '$d[id_produk]' AND id_user = '$user'"); if ($cek == 0) { if (!empty($tot)) { query("INSERT INTO ppic_tot (id_produk,tot,id_user) VALUES('$d[id_produk]','$tot','$user')"); } } else { $lih = query_satu("SELECT * FROM ppic_tot WHERE id_produk = '$d[id_produk]' AND id_user = '$user'"); $hehe = $lih["tot"] + $tot; if (!empty($hehe)) { query("UPDATE ppic_tot SET tot = '$hehe' WHERE id_produk = '$d[id_produk]' AND id_user = '$user'"); } } } else { @$tot = @$p["k"] * bom_detail_satu($p["id_bom"], $d["id_produk"], "resep_persen") / 100; $cek = jumlah("SELECT * FROM ppic_tot WHERE id_produk = '$d[id_produk]' AND id_user = '$user'"); if ($cek == 0) { if (!empty($tot)) { query("INSERT INTO ppic_tot (id_produk,tot,id_user) VALUES('$d[id_produk]','$tot','$user')"); } } else { $lih = query_satu("SELECT * FROM ppic_tot WHERE id_produk = '$d[id_produk]' AND id_user = '$user'"); $hehe = $lih["tot"] + $tot; if (!empty($hehe)) { query("UPDATE ppic_tot SET tot = '$hehe' WHERE id_produk = '$d[id_produk]' AND id_user = '$user'"); } } // numb_nol($p["k"]/produk_satuan_nilai($d["id_produk"], @produk_isi_satuan_awal($d["id_produk"], "id_satuan"), @produk_isi_satuan_akhir($d["id_produk"], "id_satuan"), "nilai")); } } else { $xx = 0; //echo "Resep nya kosong<br>"; } } else { $xx = 0; //echo '0<br>'; } endforeach; } } } function ppic_tot_remove() { $user = user("id_user"); return query("DELETE FROM ppic_tot WHERE id_user = '$user'"); } function ppic_tot_see() { $user = user("id_user"); $i = []; $a = query("SELECT * FROM ppic_tot WHERE id_user = '$user'"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function ppic_tot_see_minus() { $user = user("id_user"); return query("SELECT * FROM ppic_tot WHERE persen < 0 AND id_user = '$user'"); } function ppic_tot_see_nol() { $user = user("id_user"); return query("SELECT * FROM ppic_tot WHERE persen = 0 AND id_user = '$user'"); } function ppic_tot_see_20() { $user = user("id_user"); return query("SELECT * FROM ppic_tot WHERE persen > 0 AND persen <= 20 AND id_user = '$user'"); } function ppic_tot_see_40() { $user = user("id_user"); return query("SELECT * FROM ppic_tot WHERE persen > 20 AND persen <= 40 AND id_user = '$user'"); } function ppic_tot_see_60() { $user = user("id_user"); return query("SELECT * FROM ppic_tot WHERE persen > 40 AND persen <= 60 AND id_user = '$user'"); } function ppic_tot_see_100() { $user = user("id_user"); return query("SELECT * FROM ppic_tot WHERE persen > 60 AND id_user = '$user'"); } function ppic_persen($id, $haha) { // $min_stok = @stok_produk_control_satu($id,3,"min"); // $sisa_stok = produk_satu($id,"stok_produk"); // if ($min_stok != 0){ // if ($sisa_stok < $min_stok) { // $haha = '-'.($min_stok-$sisa_stok)/$min_stok*100; // }elseif ($sisa_stok > $min_stok) { // $haha = ($sisa_stok-$min_stok)/$min_stok*100; // }elseif ($sisa_stok == $min_stok) { // $haha = 0; // } // }else { // $haha = 0; // } $user = user("id_user"); return query("UPDATE ppic_tot SET persen = '$haha' WHERE id_produk = '$id' AND id_user = '$user'"); } function id($id) { $konek = konek(); $id = mysqli_real_escape_string($konek, g($id)); return $id; } function bom_detail_satu($id, $ok, $y) { $a = query_satu("SELECT * FROM bom_detail WHERE id_bom = '$id' AND id_produk = '$ok'"); return $a[$y]; } function bom_detail_id_satu($id, $y) { $a = query_satu("SELECT * FROM bom_detail WHERE id_bom_detail = '$id'"); return $a[$y]; } function pr_nol_satu($id, $ok) { $user = user("id_user"); $a = query_satu("SELECT * FROM pr WHERE id_produk = '$id' AND id_user = '$user' AND status_pr = '0'"); return $a[$ok]; } function pr_nol_jum($id) { $user = user("id_user"); return jumlah("SELECT * FROM pr WHERE id_produk = '$id' AND id_user = '$user' AND status_pr = '0'"); } function pr_pilih_jum($id) { $user = user("id_user"); return jumlah("SELECT * FROM pr_pilih WHERE id_produk = '$id' AND id_user = '$user'"); } function pr_pilih() { $user = user("id_user"); return query("SELECT * FROM pr_pilih WHERE id_user = '$user'"); } function pr_header_all() { return query("SELECT * FROM pr_header WHERE hidden = 0"); } function pr_header_all_semua() { return query("SELECT * FROM pr_header"); } function pr_header_hidden() { foreach (pr_header_all_semua() as $id) : if (pr_detail_jum($id["kode_pr"]) == surat_pemesanan_detail_pr_jum_kodepr($id["kode_pr"])) { return query("UPDATE pr_header SET hidden = 1 WHERE kode_pr = '$id[kode_pr]'"); } else { return query("UPDATE pr_header SET hidden = 0 WHERE kode_pr = '$id[kode_pr]'"); } endforeach; } function pr_header_this_month() { $bulan = date("m"); $tahun = date("Y"); return query("SELECT * FROM pr_header WHERE month(tgl_pr) = '$bulan' AND year(tgl_pr) = '$tahun'"); } function pr_header_today() { $bulan = date("m"); $tahun = date("Y"); $tanggal = date("d"); return query("SELECT * FROM pr_header WHERE month(tgl_pr) = '$bulan' AND year(tgl_pr) = '$tahun' AND day(tgl_pr) = '$tanggal'"); } function pr_header_choose_date($id) { return query("SELECT * FROM pr_header WHERE date(tgl_pr) = '$id'"); } function pr_header_choose_month($bulan, $tahun) { return query("SELECT * FROM pr_header WHERE month(tgl_pr) = '$bulan' AND year(tgl_pr) = '$tahun'"); } function pr_header_choose_year($tahun) { return query("SELECT * FROM pr_header WHERE year(tgl_pr) = '$tahun'"); } function pr_header_satu($id, $ok) { $a = query_satu("SELECT * FROM pr_header WHERE kode_pr = '$id'"); return $a[$ok]; } function pr_header_tahun() { return query("SELECT DISTINCT year(tgl_pr) AS tahun FROM pr_header"); } function pr_detail_jum($id) { return jumlah("SELECT * FROM pr_detail WHERE kode_pr = '$id'"); } function pr_detail($id) { return query("SELECT * FROM pr_detail WHERE kode_pr = '$id' AND id_produk NOT IN(SELECT id_produk FROM surat_pemesanan_detail_pr WHERE kode_pr = '$id')"); } function pr_detail_all($id) { return query("SELECT * FROM pr_detail WHERE kode_pr = '$id'"); } function pr_detail_satu($id, $ok, $y) { $a = query_satu("SELECT * FROM pr_detail WHERE kode_pr = '$id' AND id_produk = '$ok'"); return $a[$y]; } function surat_pemesanan_detail_pr_satu($id, $ok, $y) { $a = query_satu("SELECT * FROM surat_pemesanan_detail_pr WHERE id_surat_pemesanan_detail = '$id' AND id_produk = '$ok'"); return $a[$y]; } function surat_pemesanan_detail_pr_jum_kodepr($id) { return jumlah("SELECT * FROM surat_pemesanan_detail_pr WHERE kode_pr = '$id'"); } function surat_pemesanan_detail_pr_jum_kodepr_produk($id, $y) { return jumlah("SELECT * FROM surat_pemesanan_detail_pr WHERE kode_pr = '$id' AND id_produk = '$y'"); } function surat_penawaran_satu($id, $ok) { $a = query_satu("SELECT * FROM surat_penawaran WHERE id_surat_penawaran = '$id'"); return $a[$ok]; } function ql_tot_see($id) { $a = query_satu("SELECT * FROM ql_tot WHERE id_surat_penawaran = '$id'"); return $a["tot"]; } function ql_tot($id, $o) { $cek = jumlah("SELECT * FROM ql_tot WHERE id_surat_penawaran = '$id'"); if ($cek > 0) { $t = query("UPDATE ql_tot SET tot = '$o' WHERE id_surat_penawaran = '$id'"); } else { $t = query("INSERT INTO ql_tot VALUES('$id','$o')"); } return $t; } function surat_penawaran_detail_jum($id) { return jumlah("SELECT * FROM surat_penawaran_detail WHERE id_surat_penawaran = '$id'"); } function surat_penawaran_detail($id) { return query("SELECT * FROM surat_penawaran_detail WHERE id_surat_penawaran = '$id'"); } function surat_penawaran_detail_diskon($id, $o) { $a = query_satu("SELECT * FROM surat_penawaran_detail_diskon WHERE id_surat_penawaran = '$id'"); return @$a[$o]; } function surat_penawaran_detail_diskon_lihat($id,$y, $o) { $a = query_satu("SELECT * FROM surat_penawaran_detail_diskon WHERE id_surat_penawaran = '$id' AND id_produk = '$y'"); return @$a[$o]; } function surat_penawaran_brutto($id) { foreach (surat_penawaran_detail($id) as $spd) : $harga = $spd["harga"] * $spd["qty"]; if ($spd["diskon_jenis_nama"] == 0) { $diskon = 0; } else { if ($spd["diskon_jenis_nama"] == 1) { $diskon = surat_penawaran_detail_diskon($id, "value"); } elseif ($spd["diskon_jenis_nama"] == 2) { $diskon = surat_penawaran_detail_diskon($id, "value") * $harga / 100; } } $tot = $harga - $diskon; @$tot_all = $tot; endforeach; return @$tot_all; } function surat_penawaran_tot_berat($id) { foreach (surat_penawaran_detail($id) as $spd) : $tot = $spd["berat_gram"]; @$tot_all += $tot; endforeach; return @$tot_all; } function surat_penawaran_ongkir_total($id) { return surat_penawaran_ongkir_satu($id, "kg") * (surat_penawaran_tot_berat($id) / 1000); } function surat_penawaran_ongkir_netto($id) { return surat_penawaran_brutto($id) + @surat_penawaran_ongkir_total($id); } function surat_penawaran_ongkir_jum($id) { return jumlah("SELECT * FROM surat_penawaran_ongkir WHERE id_surat_penawaran = '$id'"); } function surat_penawaran_ongkir_satu($id, $o) { $a = query_satu("SELECT * FROM surat_penawaran_ongkir WHERE id_surat_penawaran = '$id'"); return $a[$o]; } function surat_penawaran_ongkir($id_surat_penawaran) { return query("SELECT * FROM surat_penawaran_ongkir WHERE id_surat_penawaran = '$id_surat_penawaran'"); } function surat_penawaran_masa_berlaku() { return query("SELECT * FROM surat_penawaran_masa_berlaku"); } function surat_penawaran_masa_berlaku_satu($id, $y) { $a = query_satu("SELECT * FROM surat_penawaran_masa_berlaku WHERE id = '$id' "); return $a[$y]; } function surat_penawaran_masa_berlaku_hari_satu($id, $o, $y) { $a = query_satu("SELECT * FROM surat_penawaran_masa_berlaku_hari WHERE id_surat_penawaran = '$id' AND id = '$o'"); return $a[$y]; } function surat_penawaran_masa_berlaku_hari_jum($id) { return jumlah("SELECT * FROM surat_penawaran_masa_berlaku_hari WHERE id_surat_penawaran = '$id'"); } function surat_penawaran_this_month() { $bulan = date("m"); $tahun = date("Y"); return query("SELECT * FROM surat_penawaran WHERE status != 0 AND month(tgl_surat_penawaran) = '$bulan' AND year(tgl_surat_penawaran) = '$tahun'"); } function surat_penawaran_this_day() { $date = date("Y-m-d"); return query("SELECT * FROM surat_penawaran WHERE status != 0 AND tgl_surat_penawaran = '$date'"); } function surat_penawaran_not_in_so() { return query("SELECT * FROM surat_penawaran WHERE id_surat_penawaran NOT IN(SELECT id_surat_penawaran FROM so WHERE no_so != '') AND no_ql != '' AND status = 1"); } function surat_penawaran_not_in_so_jum() { return jumlah("SELECT * FROM surat_penawaran WHERE id_surat_penawaran NOT IN(SELECT id_surat_penawaran FROM so WHERE no_so != '') AND no_ql != '' AND status = 1"); } function surat_penawaran_jenis_satu($id, $o) { $a = query_satu("SELECT * FROM surat_penawaran_jenis WHERE id = '$id'"); return $a[$o]; } function adj() { $i = []; $a = query("SELECT * FROM adjusment ORDER BY id DESC"); while ($b = query_banyak($a)) { $i[] = $b; } return $i; } function adj_gudang() { return query("SELECT id_gudang FROM adjusment_gudang"); } // fun function so_satu_ql($id, $o) { $a = query_satu("SELECT * FROM so WHERE id_surat_penawaran = '$id'"); return $a[$o]; } function so_tot_see($id) { $a = query_satu("SELECT * FROM so_tot WHERE id_so = '$id'"); return $a["tot"]; } function so_tot($id, $o) { $cek = jumlah("SELECT * FROM so_tot WHERE id_so = '$id'"); if ($cek > 0) { $t = query("UPDATE so_tot SET tot = '$o' WHERE id_so = '$id'"); } else { $t = query("INSERT INTO so_tot VALUES('$id','$o')"); } return $t; } function so_satu($id, $o) { $a = query_satu("SELECT * FROM so WHERE id_so = '$id' OR no_so = '$id'"); return @$a[$o]; } function so_no_so($id, $o) { $a = query_satu("SELECT * FROM so WHERE id_so = '$id' OR no_so = '$id'"); return $a[$o]; } function so_ongkir($id, $o) { $a = query_satu("SELECT * FROM so_ongkir WHERE id_so = '$id'"); return $a[$o]; } function so_ongkir_total($id, $o) { return so_ongkir($id, "kg") * (surat_penawaran_tot_berat($o) / 1000); } function so_ongkir_total_detail($id) { return so_ongkir($id, "kg") * (so_detail_berat_gram($id) / 1000); } function so_ongkir_jum($id) { return jumlah("SELECT * FROM so_ongkir WHERE id_so = '$id'"); } function so_kredit_satu($id, $o) { $a = query_satu("SELECT * FROM so_kredit WHERE id_so = '$id'"); return $a[$o]; } function so_pajak_persen($id, $o) { $a = query_satu("SELECT * FROM so_pajak_persen WHERE id_so = '$id'"); return @$a[$o]; } function so_diskon($id, $o) { $a = query_satu("SELECT * FROM so_diskon WHERE id_so = '$id'"); return $a[$o]; } function so_diskon_tot($id) { $brutto = surat_penawaran_brutto(so_satu($id, "id_surat_penawaran")); if (so_satu($id, "diskon_jenis_nama") == 0) { $diskon = 0; } else { if (so_satu($id, "diskon_jenis_nama") == 1) { $diskon = so_diskon($id, "val"); } elseif (so_satu($id, "diskon_jenis_nama") == 2) { $diskon = $brutto * so_diskon($id, "val") / 100; } } return $diskon; } function so_diskon_satu($id_so,$isi) { $a = query_satu("SELECT * FROM so_diskon WHERE id_so = '$id_so'"); return $a[$isi]; } function so_diskon_tot_detail($id) { $brutto = so_detail_brutto($id); if (so_satu($id, "diskon_jenis_nama") == 0) { $diskon = 0; } else { if (so_satu($id, "diskon_jenis_nama") == 1) { $diskon = so_diskon($id, "val"); } elseif (so_satu($id, "diskon_jenis_nama") == 2) { $diskon = $brutto * so_diskon($id, "val") / 100; } } return $diskon; } function so_tax($id) { $brutto = surat_penawaran_brutto(so_satu($id, "id_surat_penawaran")); if (so_satu($id, "tax") == 1) { $tax = $brutto * so_pajak_persen($id, "value") / 100; } else { $tax = 0; } return $tax; } function so_tax_detail($id) { $brutto = so_detail_brutto($id); if (so_satu($id, "tax") == 1) { $tax = $brutto * so_pajak_persen($id, "value") / 100; } else { $tax = 0; } return $tax; } function so_netto($id) { $brutto = surat_penawaran_brutto(so_satu($id, "id_surat_penawaran")); if (so_ongkir_jum($id) > 0) { $ongkir = so_ongkir_total($id, so_satu($id, "id_surat_penawaran")); } else { $ongkir = 0; } $tax = so_tax($id); $diskon = so_diskon_tot($id); return ($brutto + $ongkir + $tax) - $diskon; } function so_netto_detail($id) { $brutto = so_detail_brutto($id); if (so_ongkir_jum($id) > 0) { $ongkir = so_ongkir_total_detail($id); } else { $ongkir = 0; } $tax = so_tax_detail($id); $diskon = so_diskon_tot_detail($id); return $brutto + $ongkir + $tax - $diskon; // $brutto = so_detail_brutto($id); // if (so_ongkir_jum($id)>0) { // $ongkir = so_ongkir_total($id,so_satu($id,"id_surat_penawaran")); // }else { // $ongkir = 0; // } // $tax = so_tax_detail($id); // $diskon = so_diskon_tot_detail($id); // return ($brutto+$ongkir+$tax)-$diskon; } function so_all_this_month() { // $bulan = date("m"); // $tahun = date("Y"); // return query("SELECT * FROM so WHERE // status != 0 AND // month(buat) = '$bulan' AND // year(buat) = '$tahun'"); return query("SELECT * FROM so WHERE status != 0"); } function so_all_this_day() { $tgl = date("Y-m-d"); // return query("SELECT * FROM so WHERE // status != 0 AND // month(buat) = '$bulan' AND // year(buat) = '$tahun'"); return query("SELECT * FROM so WHERE status != 0 AND date(buat) = '$tgl'"); } function so_detail_jum($id) { return jumlah("SELECT * FROM so_detail WHERE id_so = '$id'"); } function so_detail($ono) { return query("SELECT * FROM so_detail WHERE id_so = '$ono'"); } function so_detail_diskon($id, $y, $o) { $a = query_satu("SELECT * FROM so_detail_diskon WHERE id_so = '$id' AND id_produk = '$y'"); return $a[$o]; } function so_detail_brutto($id) { foreach (so_detail($id) as $sd) : $harga = $sd["harga"]; if ($sd["diskon_jenis_nama"] == 0) { $diskon = 0; } else { if (so_satu($id, "id_surat_penawaran") == 0) { if ($sd["diskon_jenis_nama"] == 1) { $diskon = so_detail_diskon($id, $sd["id_produk"], "value"); } elseif ($sd["diskon_jenis_nama"] == 2) { $diskon = so_detail_diskon($id, $sd["id_produk"], "value") * ($harga * $sd["qty"]) / 100; } } else { if ($sd["diskon_jenis_nama"] == 1) { $diskon = surat_penawaran_detail_diskon(si_satu($id, "id_surat_penawaran"), "value"); } elseif ($sd["diskon_jenis_nama"] == 2) { $diskon = surat_penawaran_detail_diskon(si_satu($id, "id_surat_penawaran"), "value") * $harga / 100; } } } $tot = $harga * $sd["qty"] - ($diskon); @$all_tot += @$tot; endforeach; return @$all_tot; // foreach(so_detail($id) as $sd) : // if ($sd["diskon_jenis_nama"] == 1) { // $diskon = so_detail_diskon($id,$sd["id_produk"],"value"); // }elseif ($sd["diskon_jenis_nama"] == 2) { // $diskon = so_detail_diskon($id,$sd["id_produk"],"value")*($sd["harga"]*$sd["qty"])/100; // }else { // $diskon = 0; // } // $tot = $sd["harga"]*$sd["qty"]-$diskon; // @$all_tot += @$tot; // endforeach; // return @$all_tot; } function so_detail_berat_gram($id) { foreach (so_detail($id) as $sd) : $gram = $sd["berat_gram"]; @$all_tot += @$gram; endforeach; return @$all_tot; } function so_detail_satu($id_so,$id_produk,$isi) { $a = query_satu("SELECT * FROM so_detail WHERE id_so = '$id_so' AND id_produk = '$id_produk'"); return $a[$isi]; } function so_confirm() { return query("SELECT * FROM so WHERE status = 16 AND id_so NOT IN(SELECT id_so FROM si_so)"); } function so_sales_jum($id) { return jumlah("SELECT * FROM so_sales WHERE id_so = '$id'"); } function so_sales($id,$b) { $a = query_satu("SELECT * FROM so_sales WHERE id_so = '$id'"); return $a[$b]; } function diskon_jenis_nama_satu($id, $o) { $a = query_satu("SELECT * FROM diskon_jenis_nama WHERE id = '$id'"); return $a[$o]; } function diskon_jenis_nama_all() { return query("SELECT * FROM diskon_jenis_nama"); } function diskon_jenis_nama_kecuali($id) { return query("SELECT * FROM diskon_jenis_nama WHERE id != '$id'"); } function po_penjualan_satu($id, $o) { $a = query_satu("SELECT * FROM po_penjualan WHERE id_po_penjualan = '$id'"); return $a[$o]; } function po_penjualan_kredit_satu($id, $o) { $a = query_satu("SELECT * FROM po_penjualan_kredit WHERE id_po_penjualan = '$id'"); return $a[$o]; } function si_satu($id, $o) { $a = query_satu("SELECT * FROM si WHERE id_si = '$id' OR no_si = '$id'"); return @$a[$o]; } function si_complete() { return query("SELECT * FROM si WHERE id_status = 1"); } function si_so($id) { $a = query_satu("SELECT id_so FROM si_so WHERE id_si = '$id'"); return $a["id_so"]; } function si_so_jum($id_si) { return jumlah("SELECT * FROM si_so WHERE id_si = '$id_si'"); } function si_so_netto($id) { $brutto = so_detail_brutto($id); if (@si_ongkir($id, "kg")) { $ongkir = so_detail_berat_gram($id) / 1000 * (@si_ongkir($id, "kg")); } else { $ongkir = 0; } $tax = @so_tax_detail($id); $diskon = @so_diskon_tot_detail($id); $tot = $brutto + $ongkir + $tax - $diskon; return $tot; } function si_ongkir($id, $o) { $a = query_satu("SELECT * FROM si_ongkir WHERE id_si = '$id'"); return @$a[$o]; } function si_ongkir_potongan_jum($id) { return jumlah("SELECT * FROM si_ongkir_potongan WHERE id_si = '$id'"); } function si_ongkir_potongan_satu($id, $o) { $a = query_satu("SELECT * FROM si_ongkir_potongan WHERE id_si = '$id'"); return $a[$o]; } function si_ongkir_total($id) { if (si_satu($id, "input_dari") == 1) { $ongkir = so_ongkir_total_detail($id); } elseif (si_satu($id, "input_dari") == 2) { $ongkir = si_ongkir($id, "kg") * (si_stok_berat($id) / 1000); } else { $ongkir = 0; } return $ongkir; } function si_ongkir_jum($id) { return jumlah("SELECT * FROM si_ongkir WHERE id_si = '$id'"); } function si_stok($id, $o) { $a = query_satu("SELECT * FROM si_stok WHERE id_si = '$id'"); return @$a[$o]; } function si_stok_kredit($id, $o) { $a = query_satu("SELECT * FROM si_stok_kredit WHERE id_si = '$id'"); return $a[$o]; } function si_stok_kredit_jum($id) { return jumlah("SELECT * FROM si_stok_kredit WHERE id_si = '$id'"); } function si_stok_jum($id) { return jumlah("SELECT * FROM si_stok WHERE id_si = '$id'"); } function si_stok_satu($id, $o) { $a = query_satu("SELECT * FROM si_stok WHERE id_si = '$id'"); return @$a[$o]; } function si_stok_pajak($id, $o) { $a = query_satu("SELECT * FROM si_stok_pajak WHERE id_si = '$id'"); return $a[$o]; } function si_stok_pajak_jumlah($id_si) { return jumlah("SELECT * FROM si_stok_pajak WHERE id_si = '$id_si'"); } function so_stok_pajak_jumlah($id_so) { return jumlah("SELECT * FROM so_pajak_persen WHERE id_so = '$id_so' "); } function si_stok_pajak_jum($id) { if (si_stok_satu($id, "tax") == 1) { $tax = si_stok_pajak($id, "persen") * si_stok_brutto($id) / 100; } elseif (si_stok_satu($id, "tax") == 0) { $tax = 0; } return $tax; } function si_save_today() { $tgl = date("Y-m-d"); return query("SELECT * FROM si WHERE id_status != 0 AND tgl_si = '$tgl'"); } function si_report() { return query("SELECT * FROM si WHERE id_status != 0 "); } function si_tot($id, $o) { $cek = jumlah("SELECT * FROM si_tot WHERE id_si = '$id'"); if ($cek > 0) { $t = query("UPDATE si_tot SET tot = '$o' WHERE id_si = '$id'"); } else { $t = query("INSERT INTO si_tot VALUES('$id','$o')"); } return $t; } function si_tot_see($id) { $a = query_satu("SELECT * FROM si_tot WHERE id_si = '$id'"); return $a["tot"]; } function si_stok_detail($id) { return query("SELECT * FROM si_stok_detail WHERE id_si = '$id'"); } function si_stok_detail_satu($id_si,$id_produk,$isi) { $a = query_satu("SELECT * FROM si_stok_detail WHERE id_si = '$id_si' AND id_produk = '$id_produk'"); return @$a[$isi]; } function si_stok_detaillimitnya($id) { return query("SELECT * FROM si_stok_detail WHERE id_si = '$id' LIMIT 5"); } function si_stok_detail_jum($id) { return jumlah("SELECT * FROM si_stok_detail WHERE id_si = '$id'"); } function si_stok_detail_diskon_satu($id, $o, $u) { $a = query_satu("SELECT * FROM si_stok_detail_diskon WHERE id_si = '$id' AND id_produk = '$o'"); return $a[$u]; } function si_stok_diskon($id) { $a = query_satu("SELECT * FROM si_stok_diskon WHERE id_si = '$id'"); return $a["value"]; } function si_stok_diskon_jum($id) { return jumlah("SELECT * FROM si_stok_diskon WHERE id_si = '$id'"); } function si_stok_diskon_total($id) { if (@si_stok_satu($id, "diskon_jenis_nama") == 1) { @$diskon = @si_stok_diskon($id); } elseif (si_stok_satu($id, "diskon_jenis_nama") == 2) { @$diskon = @si_stok_diskon($id) * @si_stok_brutto($id) / 100; } return @$diskon; } function si_stok_brutto($id) { foreach (si_stok_detail($id) as $ssd) : $qty = $ssd["qty"]; $harga = $ssd["harga"]; if ($ssd["diskon_jenis_nama"] == 0) { $diskon = 0; } elseif ($ssd["diskon_jenis_nama"] == 1) { $diskon = si_stok_detail_diskon_satu($id, $ssd["id_produk"], "value"); } elseif ($ssd["diskon_jenis_nama"] == 2) { $diskon = si_stok_detail_diskon_satu($id, $ssd["id_produk"], "value") * ($ssd["qty"] * $ssd["harga"]) / 100; } $tot = ($qty * $harga - $diskon ); @$tot_all += $tot; endforeach; return @$tot_all; } function si_stok_berat($id) { foreach (si_stok_detail($id) as $ssd) : $tot = $ssd["berat_gram"]; @$tot_all += $tot; endforeach; return @$tot_all; } function si_stok_netto($id) { $brutto = si_stok_brutto($id); $ongkir = si_ongkir_total($id); $ongkos_angkut = si_stok_satu($id, "ongkos_angkut"); $tax = si_stok_pajak_jum($id); $diskon = si_stok_diskon_total($id); $uang_muka = si_stok_satu($id, "uang_muka"); return ($brutto + $ongkir + $ongkos_angkut + $tax) - $diskon - $uang_muka; } function si_sales_jum($id) { return jumlah("SELECT * FROM si_sales WHERE id_si = '$id'"); } function si_sales($id) { $a = query_satu("SELECT * FROM si_sales WHERE id_si = '$id'"); return $a["id_sales"]; } function diantar_satu($id, $o) { $a = query_satu("SELECT * FROM diantar WHERE id_diantar = '$id'"); return @$a[$o]; } function diantar_kecuali($id) { return query("SELECT * FROM diantar WHERE id_diantar != '$id'"); } function do_satu($id, $o) { $a = query_satu("SELECT * FROM do WHERE no_do = '$id'"); return $a[$o]; } function do_all() { return query("SELECT * FROM do"); } function do_ongkir($id, $o) { $a = query_satu("SELECT * FROM so_ongkir WHERE id_do = '$id'"); return $a[$o]; } function csv() { return query("SELECT * FROM csv ORDER BY urutan ASC"); } function expedisi_jenis() { return query("SELECT * FROM expedisi_jenis ORDER BY edit DESC"); } function expedisi_jenis_satu($id, $o) { $a = query_satu("SELECT * FROM expedisi_jenis WHERE id = '$id'"); return $a[$o]; } function expedisi_jenis_kecuali($id) { return query("SELECT * FROM expedisi_jenis WHERE id != '$id'"); } function expedisi_tipe() { return query("SELECT * FROM expedisi_tipe ORDER BY edit DESC"); } function expedisi_tipe_satu($id, $o) { $a = query_satu("SELECT * FROM expedisi_tipe WHERE id_expedisi_tipe = '$id'"); return $a[$o]; } function pages($id, $start_start) { $awal = 5; $jum = jumlah("SELECT * FROM $id"); $pages = $jum / 5; $cek_akhir = floor($pages); $start = $start_start; if (($cek_akhir * $awal) == $jum) { $akhir = $cek_akhir; } else { $akhir = $cek_akhir + 1; } $html = ' <nav aria-label="..."> <ul class="pagination pagination-sm m-0 float-right">'; if ($start == 1) { $html .= '<li class="page-item disabled"> <span class="page-link">Previous</span> </li> <li class="page-item active"><button class="page-link">1</button></li>'; } else { $html .= '<li class="page-item"> <span class="page-link pilih-pages" pages="' . $start - 1 . '">Previous</span> </li> <li class="page-item"><button class="page-link pilih-pages" pages="1">1...</button></li>'; } if ($start > 2 and $start < $akhir) { $html .= '<li class="page-item" aria-current="page"> <span class="page-link pilih-pages" pages="' . $start - 1 . '">' . $start - 1 . '</span> </li>'; } if ($start != 1 and $start < $akhir) { $html .= '<li class="page-item active" aria-current="page"> <span class="page-link">' . $start . '</span> </li>'; } if (($start + 1) != $akhir and $start < $akhir) { $html .= '<li class="page-item" aria-current="page"> <span class="page-link pilih-pages" pages="' . $start + 1 . '">' . $start + 1 . '</span> </li>'; } if (($start) != $akhir) { $html .= '<li class="page-item" aria-current="page"> <span class="page-link pilih-pages" pages="' . $akhir . '">...' . $akhir . '</span> </li>'; } else { $html .= ' <li class="page-item" aria-current="page"> <span class="page-link pilih-pages" pages="' . $akhir - 1 . '">' . $akhir - 1 . '</span> </li> <li class="page-item active" aria-current="page"> <span class="page-link">' . $akhir . '</span> </li>'; } if ($start != $akhir and $start < $akhir) { $html .= '<li class="page-item"> <span class="page-link pilih-pages" pages="' . $start + 1 . '">Next</span> </li>'; } else { $html .= ' <li class="page-item disabled"> <span class="page-link">Next</span> </li>'; } $html .= ' </ul> </nav> '; echo $html; } function pages_kil($id, $start_start, $awal) { $awal = $awal; $jum = jumlah("SELECT * FROM kil WHERE id_kil_header = '$id' AND status != 0"); $pages = $jum / $awal; $cek_akhir = floor($pages); $start = $start_start; if (($cek_akhir * $awal) == $jum) { $akhir = $cek_akhir; } else { $akhir = $cek_akhir + 1; } $html = ' <nav aria-label="..."> <ul class="pagination pagination-sm m-0 float-right">'; if ($start == 1) { $html .= '<li class="page-item disabled"> <span class="page-link">Previous</span> </li> <li class="page-item active"><button class="page-link">1</button></li>'; } else { $html .= '<li class="page-item"> <span class="page-link pilih-pages" pages="' . $start - 1 . '">Previous</span> </li> <li class="page-item"><button class="page-link pilih-pages" pages="1">1...</button></li>'; } if ($start > 2 and $start < $akhir) { $html .= '<li class="page-item" aria-current="page"> <span class="page-link pilih-pages" pages="' . $start - 1 . '">' . $start - 1 . '</span> </li>'; } if ($start != 1 and $start < $akhir) { $html .= '<li class="page-item active" aria-current="page"> <span class="page-link">' . $start . '</span> </li>'; } if (($start + 1) != $akhir and $start < $akhir) { $html .= '<li class="page-item" aria-current="page"> <span class="page-link pilih-pages" pages="' . $start + 1 . '">' . $start + 1 . '</span> </li>'; } if (($start) != $akhir) { $html .= '<li class="page-item" aria-current="page"> <span class="page-link pilih-pages" pages="' . $akhir . '">...' . $akhir . '</span> </li>'; } else { $html .= ' <li class="page-item" aria-current="page"> <span class="page-link pilih-pages" pages="' . $akhir - 1 . '">' . $akhir - 1 . '</span> </li> <li class="page-item active" aria-current="page"> <span class="page-link">' . $akhir . '</span> </li>'; } if ($start != $akhir and $start < $akhir) { $html .= '<li class="page-item"> <span class="page-link pilih-pages" pages="' . $start + 1 . '">Next</span> </li>'; } else { $html .= ' <li class="page-item disabled"> <span class="page-link">Next</span> </li>'; } $html .= ' </ul> </nav> '; echo $html; } function kil_jenis($id) { return query("SELECT * FROM kil_jenis WHERE id_kil_jenis_nama = '$id'"); } function kil_jenis_satu($id, $o) { $a = query_satu("SELECT * FROM kil_jenis WHERE id_kil_jenis_nama = '$id'"); return $a[$o]; } function kil_jenis_satu_id($id, $o) { $a = query_satu("SELECT * FROM kil_jenis WHERE id_kil_jenis = '$id'"); return $a[$o]; } function kil($id) { return query("SELECT * FROM kil WHERE id_kil_header = '$id' AND status = 1"); } function kil_customer_pilih($id) { return query("SELECT * FROM kil WHERE id_kil_header = '$id' AND status = 1 AND id NOT IN(SELECT id_kil FROM kil_customer)"); } function kil_id($id) { $konek = konek(); $user = user("id_user"); $ri = riwayat(); $cek = kil_jum_id($id); if ($cek > 0) { $a = query_satu("SELECT * FROM kil WHERE id_kil_header = '$id' AND id_user = '$user' AND status = '0'"); $id_kil = $a["id"]; } else { $a = mysqli_query($konek, "INSERT INTO kil (id_kil_header,edit,id_user) VALUES('$id','$ri','$user')"); $id_kil = mysqli_insert_id($konek); } return $id_kil; } function kil_satu($id, $o) { $a = query_satu("SELECT * FROM kil WHERE id = '$id'"); return @$a[$o]; } function kil_jum($id) { return jumlah("SELECT * FROM kil WHERE id_kil_header = '$id' AND status = 1"); } function kil_jum_id($id) { $user = user("id_user"); return jumlah("SELECT * FROM kil WHERE id_kil_header = '$id' AND id_user = '$user' AND status = 0"); } function kil_identitas_jum($id, $o) { return jumlah("SELECT * FROM kil_identitas WHERE id_kil = '$id' AND id_kil_identitas_jenis = '$o'"); } function kil_identitas_satu($id, $o, $y) { $a = query_satu("SELECT * FROM kil_identitas WHERE id_kil = '$id' AND id_kil_identitas_jenis = '$o'"); return $a[$y]; } function kil_identitas_id($id_kil, $id_kil_jenis) { $konek = konek(); $cek = kil_identitas_jum($id_kil, $id_kil_jenis); if ($cek > 0) { $id_kil_identitas = kil_identitas_satu($id_kil, $id_kil_jenis, "id"); } else { @mysqli_query($konek, "INSERT INTO kil_identitas (id_kil,id_kil_identitas_jenis) VALUES('$id_kil','$id_kil_jenis')"); $id_kil_identitas = mysqli_insert_id($konek); } return $id_kil_identitas; } function kil_identitas_alamat($id) { return query("SELECT * FROM kil_identitas WHERE id_kil = '$id' AND ket IN(SELECT kelurahan FROM kil_alamat)"); } function kil_identitas_alamat_jum($id) { return jumlah("SELECT * FROM kil_identitas WHERE id_kil = '$id' AND ket IN(SELECT kelurahan FROM kil_alamat)"); } function kil_telp_satu($id) { $a = query_satu("SELECT * FROM kil_telp WHERE id_kil_identitas = '$id'"); return $a["telp"]; } function kil_telp($id) { return query("SELECT * FROM kil_telp WHERE id_kil_identitas = '$id'"); } function kil_email_satu($id) { $a = query_satu("SELECT * FROM kil_email WHERE id_kil_identitas = '$id'"); return $a["email"]; } function kil_email($id) { return query("SELECT * FROM kil_email WHERE id_kil_identitas = '$id'"); } function kil_alamat_satu($id, $o) { $a = query_satu("SELECT * FROM kil_alamat WHERE id_kil_identitas = '$id'"); return @$a[$o]; } function kil_alamat_jum($id) { return jumlah("SELECT * FROM kil_alamat WHERE id_kil_identitas = '$id'"); } // function kil_alamat_sesuaikan() // { // $a = query("SELECT * FROM kil_alamat"); // foreach($a as $b) : // $id_kil_identitas = $b["id_kil_identitas"]; // $kel = $b["kelurahan"]; // $kec = kel_lihat($kel,"district_id"); // $kab = kec_lihat(kel_lihat($kel,"district_id"),"regency_id"); // $prov = kab_lihat(kec_lihat(kel_lihat($kel,"district_id"),"regency_id"),"province_id"); // query("UPDATE kil_alamat SET // province = '$prov', // kabupaten = '$kab', // kecamatan = '$kec' // WHERE // id_kil_identitas = '$id_kil_identitas' AND // kelurahan = '$kel'"); // endforeach; // } function kil_nomor_satu($id, $o, $y) { $a = query_satu("SELECT * FROM kil_nomor WHERE id_kil = '$id' AND id_nomor_jenis = '$o'"); return $a[$y]; } function kil_contact_satu($id, $o) { $a = query_satu("SELECT * FROM kil_contact WHERE id_kil_identitas = '$id'"); return @$a[$o]; } function kil_status($id) { return query("SELECT * FROM kil_status WHERE id_kil = '$id'"); } function kil_bank($id) { return query("SELECT * FROM kil_bank WHERE id_kil = '$id'"); } function kil_bank_jum($id, $o, $y) { return jumlah("SELECT * FROM kil_bank WHERE id_kil = '$id' AND id_bank = '$o' AND norek = '$y'"); } function kil_armada($id) { return query("SELECT * FROM kil_armada WHERE id_kil = '$id'"); } function kil_karyawan($id) { return query("SELECT * FROM kil_karyawan WHERE id_kil = '$id'"); } function kil_karyawan_satu($id, $o) { $a = query_satu("SELECT * FROM kil_karyawan WHERE id_kil = '$id'"); return @$a[$o]; } function kil_karyawan_telp($id, $o, $nama) { return query("SELECT * FROM kil_karyawan_telp WHERE id_kil = '$id' AND id_karyawan_jenis = '$o' AND nama = '$nama'"); } function kil_karyawan_telp_satu($id, $o, $nama, $y) { $a = query_satu("SELECT * FROM kil_karyawan_telp WHERE id_kil = '$id' AND id_karyawan_jenis = '$o' AND nama = '$nama'"); return @$a[$y]; } function kil_area($id) { return query("SELECT * FROM kil_area WHERE id_kil = '$id'"); } function kil_area_jum($id) { return jumlah("SELECT * FROM kil_area WHERE id_kil = '$id'"); } function kil_plafond_satu($id, $y, $o) { $a = query_satu("SELECT * FROM kil_pafond WHERE id_kil = '$id' AND id_kil_plafond_jenis = '$y'"); return $a[$o]; } function kil_produk_jum($id, $o) { return jumlah("SELECT * FROM kil_produk WHERE id_kil = '$id' AND agent = '$o'"); } function kil_produk($id, $o) { return query("SELECT * FROM kil_produk WHERE id_kil = '$id' AND agent = '$o'"); } function kil_identitas_nama_satu($id, $o) { $a = query_satu("SELECT * FROM kil_identitas_nama WHERE id_kil_identitas = '$id'"); return $a[$o]; } function kil_identitas_contact($id) { return query("SELECT * FROM kil_identitas WHERE id_kil = '$id' AND id IN(SELECT id_kil_identitas FROM kil_contact)"); } function kil_identitas_contact_jum($id) { return jumlah("SELECT * FROM kil_identitas WHERE id_kil = '$id' AND id IN(SELECT id_kil_identitas FROM kil_contact)"); } function kil_distributor_stockis_jum($id) { return jumlah("SELECT * FROM kil_distributor_stockis WHERE id_kil = '$id'"); } function kil_distributor_stockis($id) { return query("SELECT * FROM kil_distributor_stockis WHERE id_kil = '$id'"); } function do_armada_satu($id, $o) { $a = query_satu("SELECT * FROM do_armada WHERE no_do = '$id'"); return $a[$o]; } function do_armada($id) { return query("SELECT * FROM do_armada WHERE nama_supir = '$id'"); } function kil_objek_jum($id) { return jumlah("SELECT * FROM kil_objek WHERE id_kil = '$id'"); } function kil_objek_satu($id, $o) { $a = query_satu("SELECT * FROM kil_objek WHERE id_kil = '$id'"); return @$a[$o]; } function kil_prangko_gudang_jum($id) { return jumlah("SELECT * FROM kil_prangko_gudang WHERE id_kil = '$id'"); } function kil_prangko_gudang_satu($id, $o) { $a = query_satu("SELECT * FROM kil_prangko_gudang WHERE id_kil = '$id'"); return @$a[$o]; } function kil_prangko_gudang_produk_jum($id, $o) { return jumlah("SELECT * FROM kil_prangko_gudang_produk WHERE id_kil_prangko_gudang = '$id' AND nama_produk = '$o'"); } function kil_prangko_gudang_produk_jum_all($id) { $kil_prangko_gudang = kil_prangko_gudang_satu($id, "id"); return jumlah("SELECT * FROM kil_prangko_gudang_produk WHERE id_kil_prangko_gudang = '$kil_prangko_gudang'"); } function kil_prangko_gudang_produk($id) { $kil_prangko_gudang = kil_prangko_gudang_satu($id, "id"); return query("SELECT * FROM kil_prangko_gudang_produk WHERE id_kil_prangko_gudang = '$kil_prangko_gudang'"); } function kil_type_toko($id) { return query("SELECT * FROM kil_type_toko WHERE id_kil = '$id'"); } function kil_kategori_toko($id) { return query("SELECT * FROM kil_kategori_toko WHERE id_kil = '$id'"); } function kil_jenis_pembayaran($id) { return query("SELECT * FROM kil_jenis_pembayaran WHERE id_kil = '$id'"); } function kil_fax_satu($id, $o) { $a = query_satu("SELECT * FROM kil_fax WHERE id_kil_identitas = '$id'"); return @$a[$o]; } function kil_web_satu($id, $o) { $a = query_satu("SELECT * FROM kil_web WHERE id_kil = '$id'"); return @$a[$o]; } function kil_contact($id) { return query("SELECT * FROM kil_contact WHERE id_kil_identitas = '$id'"); } function kil_depo_cabang($id) { return query("SELECT * FROM kil_depo_cabang WHERE id_kil = '$id'"); } function kil_area_distribusi($id) { return query("SELECT * FROM kil_area_distribusi WHERE id_kil = '$id'"); } function kil_karyawan_jumlah($id) { return query("SELECT * FROM kil_karyawan_jumlah WHERE id_kil = '$id'"); } function kil_karyawan_jumlah_jum($id) { return jumlah("SELECT * FROM kil_karyawan_jumlah WHERE id_kil = '$id'"); } function kil_pelanggan($id) { return query("SELECT * FROM kil_pelanggan WHERE id_kil = '$id'"); } function kil_pelanggan_jum($id) { return jumlah("SELECT * FROM kil_pelanggan WHERE id_kil = '$id'"); } function kil_principals($id) { return query("SELECT * FROM kil_principals WHERE id_kil = '$id'"); } function kil_principals_jum($id) { return jumlah("SELECT * FROM kil_principals WHERE id_kil = '$id'"); } function kil_area_distribusi_produk_satu($id, $o) { $a = query_satu("SELECT * FROM kil_area_distribusi_produk WHERE id_kil = '$id'"); return $a[$o]; } function kil_area_distribusi_produk_jum($id) { return jumlah("SELECT * FROM kil_area_distribusi_produk WHERE id_kil = '$id'"); } function kil_customer($id, $o) { $a = query_satu("SELECT * FROM kil_customer WHERE id_customer = '$id' or id_kil = '$id'"); return @$a[$o]; } function kil_customer_jum_kil($id) { return jumlah("SELECT * FROM kil_customer WHERE id_kil = '$id'"); } function kil_customer_jum_customer($id) { return jumlah("SELECT * FROM kil_customer WHERE id_customer = '$id'"); } function wo_produksi() { $sekarang = date("Y-m-d"); return query("SELECT * FROM wo WHERE id NOT IN(SELECT id_wo FROM produksi) AND tgl_akhir_berlaku >= '$sekarang' AND id IN(SELECT id_wo FROM wo_jadwal_produksi)"); } function wo_produksi_jum($id) { return jumlah("SELECT * FROM produksi WHERE id_wo = '$id'"); } function wo_jenis($id) { return query("SELECT * FROM wo_jenis WHERE id_wo_jenis_nama = '$id'"); } function wo_jenis_satu($id, $o) { $a = query_satu("SELECT * FROM wo_jenis WHERE id = '$id'"); return @$a[$o]; } function wo_satu($id, $o) { $a = query_satu("SELECT * FROM wo WHERE id = '$id'"); return @$a[$o]; } function wo() { return query("SELECT * FROM wo"); } function wo_check($id) { if (jumlah("SELECT * FROM wo WHERE id = '$id'") < 1) { echo "<script>location='?halaman=working-order'</script>"; } } function wo_today() { $today = date("Y-m-d"); return query("SELECT * FROM wo WHERE date(buat) = '$today'"); } function wo_allin() { return query("SELECT * FROM wo "); } function wo_date_search($id) { return query("SELECT * FROM wo WHERE date(buat) = '$id'"); } function wo_month_search($bulan, $tahun) { return query("SELECT * FROM wo WHERE month(buat) = '$bulan' AND year(buat) = '$tahun'"); } function wo_year_search($id) { return query("SELECT * FROM wo WHERE year(buat) = '$id'"); } function wo_section1_id($id) { $konek = konek(); $jum = jumlah("SELECT * FROM wo_section1 WHERE id_wo = '$id'"); if ($jum > 0) { $cek = query_satu("SELECT id FROM wo_section1 WHERE id_wo = '$id'"); $id = $cek["id"]; } else { mysqli_query($konek, "INSERT INTO wo_section1 VALUES(null,'$id','')"); $id = mysqli_insert_id($konek); } return $id; } function wo_section1($id) { $a = query_satu("SELECT * FROM wo_section1 WHERE id = '$id' OR id_wo = '$id'"); return @$a["jumlah_berat_hasil_produk"]; } function wo_section1_satu($id_wo, $o) { $a = query_satu("SELECT * FROM wo_section1 WHERE id_wo = '$id_wo'"); return $a[$o]; } function wo_section1_detail_jum($id, $o, $y) { return jumlah("SELECT * FROM wo_section1_detail WHERE id_wo_section1 = '$id' AND id_bom_detail = '$o' AND id_wo_jenis = '$y'"); } function wo_section1_detail_satu($id, $o, $y, $u) { $a = query_satu("SELECT * FROM wo_section1_detail WHERE id_wo_section1 = '$id' AND id_bom_detail = '$o' AND id_wo_jenis = '$y'"); return @$a[$u]; } function wo_section1_satuan_satu($id, $o, $e, $y) { $id_wo_section1 = wo_section1_id($id); $a = query_satu("SELECT * FROM wo_section1_satuan WHERE id_wo_section1 = '$id_wo_section1' AND id_produk = '$o' AND id_wo_jenis = '$e'"); return @$a[$y]; } function wo_section1_satuan_jum($id) { return jumlah("SELECT * FROM wo_section1_satuan WHERE id_wo_section1 = '$id'"); } function wo_section1_satuan($id) { return query("SELECT * FROM wo_section1_satuan WHERE id_wo_section1 = '$id'"); } function wo_reciep_satuan_satu($id, $o, $y) { $a = query_satu("SELECT * FROM wo_reciep_satuan WHERE id_wo_section1 = '$id' AND id_produk = '$o'"); return @$a[$y]; } function wo_reciep_satuan($id) { return query("SELECT * FROM wo_reciep_satuan WHERE id_wo_section1 = '$id'"); } function wo_reciep_satuan_jum($id) { return jumlah("SELECT * FROM wo_reciep_satuan WHERE id_wo_section1 = '$id'"); } function wo_reciep_satuan_detail_satu($id, $o, $y) { $a = query_satu("SELECT * FROM wo_reciep_satuan_detail WHERE id_wo_reciep_satuan = '$id' AND id_wo_jenis = '$o'"); return @$a[$y]; } function wo_section2_jum($id) { return jumlah("SELECT * FROM wo_section2 WHERE id_wo = '$id'"); } function wo_section2_satu($id, $o) { $a = query_satu("SELECT * FROM wo_section2 WHERE id_wo = '$id' or id = '$id'"); return @$a[$o]; } function wo_section2_header_jum($id) { return jumlah("SELECT * FROM wo_section2_header WHERE id_wo_section2 = '$id'"); } function wo_section2_header($id) { return query("SELECT * FROM wo_section2_header WHERE id_wo_section2 = '$id'"); } function wo_section2_header_satu($id, $o) { $a = query_satu("SELECT * FROM wo_section2_header WHERE id_wo_section2 = '$id'"); return @$a[$o]; } function wo_section2_header_tot_qty_plastik($id) { foreach (wo_section2_header($id) as $ws2h) : $qty_plastik = $ws2h["qty_plastik"]; @$tot_qty_plastik += $qty_plastik; endforeach; return $tot_qty_plastik; } function wo_section2_detail_satu($id, $o, $y) { $a = query_satu("SELECT * FROM wo_section2_detail WHERE id_wo_section2_header = '$id' AND wo_jenis_section2 = '$o'"); return @$a[$y]; } function wo_section2_detail_total($oke) { $id_wo_section2 = wo_section2_satu($oke, "id"); foreach (wo_section2_header($id_wo_section2) as $ws2h) : $id = $ws2h["id"]; $qty = wo_section2_detail_satu($id, 11, "qty"); @$tot_qty += $qty; endforeach; if (wo_section2_link_bsj_jum($id_wo_section2) > 0) { $satuan_bsj_link = wo_section2_link_bsj_satu($id_wo_section2, "id_satuan"); $qty_bsj_link = wo_section2_link_bsj_satu($id_wo_section2, "qty"); $satuan_sec2 = wo_section2_satu($oke, "id_satuan"); $id_produk = bom_satu(wo_satu($oke, "id_bom"), "id_produk"); $nilai = produk_satuan_nilai($id_produk, $satuan_sec2, $satuan_bsj_link, "nilai"); $total = ($qty_bsj_link / $nilai) + $tot_qty; } else { $total = $tot_qty; } return $total; } function wo_section2_detail_total_bs_plastik($id_wo) { $id_wo_section2 = wo_section2_satu($id_wo, "id"); foreach (wo_section2_header($id_wo_section2) as $ws2h) : $qty_plastik_bs_sec2 = wo_section2_detail_satu($ws2h["id"], 12, "qty"); @$tot_qty_plastik_bs_sec2 += $qty_plastik_bs_sec2; endforeach; return @$tot_qty_plastik_bs_sec2; //echo "Sedang dalam pengembangan"; } function wo_section2_detail_total_bs_bb($id_wo) { $id_wo_section2 = wo_section2_satu($id_wo, "id"); foreach (wo_section2_header($id_wo_section2) as $ws2h) : $qty_bb_sec2 = wo_section2_detail_satu($ws2h["id"], 13, "qty"); @$tot_bb_sec2 += $qty_bb_sec2; endforeach; return @$tot_bb_sec2; //echo "Sedang dalam pengembangan"; } function wo_section2_link_bsj_jum($id) { return jumlah("SELECT * FROM wo_section2_link_bsj WHERE id_wo_section2 = '$id'"); } function wo_section2_link_bsj_satu($id, $o) { $a = query_satu("SELECT * FROM wo_section2_link_bsj WHERE id_wo_section2 = '$id'"); return $a[$o]; } function wo_section2_link_bsj_total($oke) { $id_wo_section2 = wo_section2_satu($oke, "id"); if (wo_section2_link_bsj_jum($id_wo_section2) > 0) { $satuan_bsj_link = wo_section2_link_bsj_satu($id_wo_section2, "id_satuan"); $satuan_sec2 = wo_section2_satu($oke, "id_satuan"); $id_produk = bom_satu(wo_satu($oke, "id_bom"), "id_produk"); $nilai = produk_satuan_nilai($id_produk, $satuan_sec2, $satuan_bsj_link, "nilai"); } else { $nilai = 0; } return $nilai; } function wo_section3_satu($id, $o) { $a = query_satu("SELECT * FROM wo_section3 WHERE id_wo = '$id'"); return $a[$o]; } function wo_section3_detail_jum($id) { return jumlah("SELECT * FROM wo_section3_detail WHERE id_wo_section3 = '$id'"); } function wo_section3_detail_satu($id, $o) { $a = query_satu("SELECT * FROM wo_section3_detail WHERE id_wo_section3 = '$id'"); return @$a[$o]; } function wo_section3_detail($id) { return query("SELECT * FROM wo_section3_detail WHERE id_wo_section3 = '$id'"); } function wo_section3_detail_total_qty($id) { foreach (wo_section3_detail(wo_section3_satu($id, "id")) as $ws3d) : $qty = $ws3d["qty"]; @$tot_qty += $qty; endforeach; return @$tot_qty; } function wo_section3_header_jum($id) { return jumlah("SELECT * FROM wo_section3_header WHERE id_wo_section3 = '$id'"); } function wo_section3_header_satu($id, $o) { $a = query_satu("SELECT * FROM wo_section3_header WHERE id_wo_section3 = '$id'"); return @$a[$o]; } function wo_section3_header_wo_jenis_satu($id, $y, $o) { $a = query_satu("SELECT * FROM wo_section3_header WHERE id_wo_section3 = '$id' AND id_wo_jenis = '$y'"); return @$a[$o]; } function wo_tambah_sisa_jum($id, $o) { return jumlah("SELECT * FROM wo_tambah_sisa WHERE id_wo = '$id' AND id_wo_jenis = '$o'"); } function wo_tambah_sisa_satu($id, $o, $y) { $a = query_satu("SELECT * FROM wo_tambah_sisa WHERE id_wo = '$id' AND id_wo_jenis = '$o'"); return $a[$y]; } function wo_losspacking($id) { return query("SELECT * FROM wo_losspacking WHERE id_wo_section1 = '$id'"); } function wo_losspacking_satu($id, $a, $o) { $b = query_satu("SELECT * FROM wo_losspacking WHERE id_wo_section1 = '$id' AND id_wo_jenis = '$a'"); return $b[$o]; } function wo_losspacking_jum($id) { return jumlah("SELECT * FROM wo_losspacking WHERE id_wo_section1 = '$id'"); } function wo_metode_lhp_satu($id_wo, $id_wo_section, $id_wo_jenis_bs, $o) { $a = query_satu("SELECT * FROM wo_metode_lhp WHERE id_wo = '$id_wo' AND id_wo_section = '$id_wo_section' AND id_wo_jenis_bs = '$id_wo_jenis_bs' "); return @$a[$o]; } function wo_metode_lhp_jum($id_wo, $id_wo_section, $id_wo_jenis_bs) { return jumlah("SELECT * FROM wo_metode_lhp WHERE id_wo = '$id_wo' AND id_wo_section = '$id_wo_section' AND id_wo_jenis_bs = '$id_wo_jenis_bs'"); } function wo_status($id) { $a = query_satu("SELECT id_wo_jenis FROM wo_status WHERE id_wo = '$id'"); return $a["id_wo_jenis"]; } function wo_riwayat($id) { return query("SELECT * FROM wo_riwayat WHERE id_wo = '$id'"); } function wo_bom_today() { $date = date("Y-m-d"); return query("SELECT * FROM wo_bom WHERE date(buat) = '$date'"); } function wo_bom_satu($id, $a) { $b = query_satu("SELECT * FROM wo_bom WHERE id_wo = '$id'"); return $b[$a]; } function wo_bom_jumlah($id) { return jumlah("SELECT * FROM wo_bom WHERE id = '$id'"); } function wo_bom_check($id) { if (wo_bom_jumlah($id) < 1) { echo "<script> location='?halaman=bill-of-materials'; </script>"; } } function wo_bom_header_jum($id) { return jumlah("SELECT * FROM wo_bom_header WHERE id_wo_bom = '$id'"); } function wo_bom_header_satu($id, $o, $y) { $a = query_satu("SELECT * FROM wo_bom_header WHERE id_wo_bom = '$id' AND id_produk = '$o'"); return @$a[$y]; } function wo_bom_header_detail_satu($id, $y, $o) { $a = query_satu("SELECT * FROM wo_bom_header_detail WHERE id_wo_bom_header = '$id' AND id_wo_jenis = '$y'"); return @$a[$o]; } function wo_bom_header_detail_jum($id_wo_jenis, $id_wo_bom) { return jumlah("SELECT * FROM wo_bom_header_detail WHERE id_wo_jenis = '$id_wo_jenis' AND id_wo_bom = '$id_wo_bom'"); } function wo_bom_header($id) { return query("SELECT * FROM wo_bom_header WHERE id_wo_bom = '$id'"); } function wo_jadwal_produksi_jum($id) { return jumlah("SELECT * FROM wo_jadwal_produksi WHERE id_wo = '$id'"); } function wo_jadwal_produksi_satu($id, $o) { $a = query_satu("SELECT * FROM wo_jadwal_produksi WHERE id_wo = '$id'"); return $a[$o]; } // function wo_update_satuan() // { // $a = query("SELECT * FROM bom_reciep_satuan"); // foreach($a as $b) : // query("UPDATE wo SET id_satuan = '$b[id_satuan]' // WHERE // id_bom = '$b[id_bom]'"); // endforeach; // } function produksi_today() { $hari_ini = date("Y-m-d"); return query("SELECT * FROM produksi WHERE date(buat) = '$hari_ini'"); } function produksi_all() { return query("SELECT * FROM produksi"); } function produksi_satu($id, $o) { $a = query_satu("SELECT * FROM produksi WHERE id_wo = '$id'"); return $a[$o]; } function tindakan_riwayat_satu($id, $o) { $a = query_satu("SELECT * FROM tindakan_riwayat WHERE id_tindakan_riwayat = '$id'"); return $a[$o]; } function produk_stok_riwayat_satu($id, $o) { $a = query_satu("SELECT * FROM produk_stok_riwayat WHERE id_user = '$id'"); return $a[$o]; } function produk_stok_riwayat($id_produk) { return query("SELECT * FROM produk_stok_riwayat WHERE id_produk = '$id_produk' ORDER BY tgl DESC"); } function bulan_nama($id) { $a = query_satu("SELECT nama FROM bulan WHERE id = '$id'"); return $a["nama"]; } function bulan_all() { return query("SELECT * FROM bulan"); } function pp_year() { $tahun = date("Y"); return query("SELECT * FROM pp WHERE tahun = '$tahun'"); } function pp_year_pilih($tahun) { return query("SELECT * FROM pp WHERE tahun = '$tahun'"); } function pp_satu($id, $o) { $a = query_satu("SELECT * FROM pp WHERE id = '$id'"); return $a[$o]; } function pp_jenis($id) { return query("SELECT * FROM pp_jenis WHERE id_pp_jenis_header = '$id'"); } function pp_jenis_satu($id, $o) { $a = query_satu("SELECT * FROM pp_jenis WHERE id = '$id'"); return $a[$o]; } function pp_detail_check($id) { $cek = jumlah("SELECT * FROM pp WHERE id = '$id'"); if ($cek < 1) { echo "<script> location='?halaman=planning'; </script>"; } } function pp_week($id) { return query("SELECT * FROM pp_week WHERE id_pp = '$id' ORDER BY id_pp_jenis ASC"); } function pp_week_jenis($id, $jenis, $isi) { $a = query_satu("SELECT * FROM pp_week WHERE id_pp = '$id' AND id_pp_jenis = '$jenis'"); return $a[$isi]; } function pp_week_jum($id) { return jumlah("SELECT * FROM pp_week WHERE id_pp = '$id'"); } function pp_week_satu($id_pp, $id_pp_jenis, $isi) { $a = query_satu("SELECT * FROM pp_week WHERE id_pp = '$id_pp' AND id_pp_jenis = '$id_pp_jenis'"); return $a[$isi]; } function pp_produk_header($id) { return query("SELECT * FROM pp_produk_header WHERE id_pp = '$id'"); } function pp_produk_header_satu($id_pp, $id_produk, $isi) { $a = query_satu("SELECT * FROM pp_produk_header WHERE id_pp = '$id_pp' AND id_produk = '$id_produk'"); return $a[$isi]; } function pp_sdm_satu($id_pp, $date, $isi) { $a = query_satu("SELECT * FROM pp_sdm WHERE id_pp = '$id_pp' AND date = '$date'"); return @$a[$isi]; } function pp_qty_satu($id_pp, $id_produk, $date, $isi) { $a = query_satu("SELECT * FROM pp_qty WHERE id_pp = '$id_pp' AND id_produk = '$id_produk' AND date = '$date'"); return @$a[$isi]; } function pp_qty_total($id_pp, $id_produk, $id_pp_jenis_week) { $a = query("SELECT * FROM pp_qty WHERE id_pp = '$id_pp' AND id_produk = '$id_produk' AND id_pp_jenis_week = '$id_pp_jenis_week'"); foreach ($a as $b) : @$total += $b["value"]; endforeach; return @$total; } function pp_qty_total_kesamping($id_pp, $id_produk) { $a = query("SELECT * FROM pp_qty WHERE id_pp = '$id_pp' AND id_produk = '$id_produk'"); foreach ($a as $b) : @$total += $b["value"]; endforeach; return @$total; } function pp_tahun() { return query("SELECT distinct tahun FROM pp ORDER BY tahun ASC"); } # onlineshop function get_carts($id) { if (!empty($id)) { return query("SELECT * FROM cart WHERE id_user = '$id'"); }; } function get_username_os($id) { if (!empty($id)) { $u = @query_satu("SELECT * FROM user_onlineshop WHERE id_user = '$id'"); if (!empty($u)) { return $u["username"]; } } } function status_pesanan_os($id) { return @query_satu("SELECT * FROM status_pesanan_os WHERE id_status = '$id'")["nama_status"]; } function class_pesanan_os($id) { return @query_satu("SELECT * FROM status_pesanan_os WHERE id_status = '$id'")["class"]; } function get_product_os_name($id) { if (!empty($id)) { $p = @query_satu("SELECT * FROM produk_online WHERE id_produk = '$id'"); if (!empty($p)) { return $p["judul_online"]; } } } function pp_total($id_pp) { query("DELETE FROM pp_total_per_satuan WHERE id_pp = '$id_pp'"); $cek_satuan_produk_header = query("SELECT distinct id_satuan FROM pp_produk_header WHERE id_pp = '$id_pp'"); foreach ($cek_satuan_produk_header as $csph) { $kk = query("SELECT * FROM pp_produk_header, pp_qty WHERE pp_qty.id_pp = '$id_pp' AND pp_qty.id_produk = pp_produk_header.id_produk AND pp_produk_header.id_satuan = '$csph[id_satuan]' AND pp_produk_header.id_pp = '$id_pp'"); foreach ($kk as $k) { $cek = jumlah("SELECT * FROM pp_total_per_satuan WHERE id_pp = '$id_pp' AND id_satuan = '$csph[id_satuan]'"); if ($cek > 0) { $totot = pp_total_per_satuan($id_pp, $csph["id_satuan"]) + $k["value"]; query("UPDATE pp_total_per_satuan SET total = '$totot' WHERE id_pp = '$id_pp' AND id_satuan = '$csph[id_satuan]'"); } else { query("INSERT INTO pp_total_per_satuan VALUES('$id_pp','$csph[id_satuan]','$k[value]')"); } } } } function pp_total_per_satuan($id_pp, $satuan) { $a = query_satu("SELECT * FROM pp_total_per_satuan WHERE id_pp = '$id_pp' AND id_satuan = '$satuan'"); return @$a["total"]; } function pp_total_per_satuan_all($id_pp) { return query("SELECT * FROM pp_total_per_satuan WHERE id_pp = '$id_pp'"); } function get_all_order_os() { return @query("SELECT * FROM pesanan_os"); } function get_data_order_os_byid($id) { return @query_satu("SELECT * FROM pesanan_os WHERE id = '$id'"); } function retur_cust_satu($id_retur,$isi) { $a = query_satu("SELECT * FROM retur_cust WHERE id_retur = '$id_retur'"); return $a[$isi]; } function retur_cust_jum($id_retur) { return jumlah("SELECT * FROM retur_cust WHERE id_retur = '$id_retur'"); } function retur_kode_satu($id_retur,$isi) { $a = query_satu("SELECT * FROM retur_kode WHERE id_retur = '$id_retur'"); return @$a[$isi]; } function retur_kode_jum($id_retur) { return jumlah("SELECT * FROM retur_kode WHERE id_retur = '$id_retur'"); } function retur_detail_jum($id_retur) { return jumlah("SELECT * FROM retur_detail WHERE id_retur = '$id_retur'"); } function retur_detail($id_retur) { return query("SELECT * FROM retur_detail WHERE id_retur = '$id_retur'"); } function retur_detail_satu($id_retur,$id_produk,$isi) { $a = query_satu("SELECT * FROM retur_detail WHERE id_retur = '$id_retur' AND id_produk = '$id_produk'"); return $a[$isi]; } function retur_detail_diskon_satu($id_retur,$id_produk,$isi) { $a = query_satu("SELECT * FROM retur_detail_diskon WHERE id_retur = '$id_retur' AND id_produk = '$id_produk'"); return $a[$isi]; } function retur_total($id_retur) { foreach(retur_detail($id_retur) as $rd) : if ($rd["id_diskon_jenis_nama"] == 0) { $diskon = 0; }elseif ($rd["id_diskon_jenis_nama"] == 1) { $diskon = retur_detail_diskon_satu($id_retur,$rd["id_produk"],"nilai"); }elseif ($rd["id_diskon_jenis_nama"] == 2) { $diskon = retur_detail_diskon_satu($id_retur,$rd["id_produk"],"nilai")*$rd["harga"]/100; } $tot = ($rd["harga"]-$diskon)*$rd["qty"]; @$tot_tot += $tot; endforeach; if (retur_diskon_jum($id_retur)>0) { if (retur_diskon_satu($id_retur,"id_diskon_jenis_nama") == 1) { $diskon_retur = retur_diskon_satu($id_retur,"nilai"); }elseif (retur_diskon_satu($id_retur,"id_diskon_jenis_nama") == 2) { $diskon_retur = retur_diskon_satu($id_retur,"nilai")*@$tot_tot/100; } }else { $diskon_retur = 0; } @$all_tot = @$tot_tot - $diskon_retur; return @$all_tot; } function retur_jenis() { return query("SELECT * FROM retur_jenis"); } function retur_jenis_satu($id_retur_jenis) { $a = query_satu("SELECT * FROM retur_jenis WHERE id = '$id_retur_jenis'"); return @$a["nama"]; } function retur_satu($id,$isi) { $a = query_satu("SELECT * FROM retur WHERE id = '$id'"); return $a[$isi]; } function retur_today() { $hari = date("Y-m-d"); return query("SELECT * FROM retur WHERE date(edit) = '$hari' AND id_status != 44"); } function retur_report_today($id_report) { $hari = date("Y-m-d"); return query("SELECT * FROM retur WHERE date(edit) = '$hari' AND id_report = '$id_report' AND id_status != 44"); } function retur_diskon_jum($id_retur) { return jumlah("SELECT * FROM retur_diskon WHERE id_retur = '$id_retur'"); } function retur_diskon_satu($id_retur,$isi){ $a = query_satu("SELECT * FROM retur_diskon WHERE id_retur = '$id_retur'"); return $a[$isi]; } function retur_suplier($id_retur,$isi) { $a = query_satu("SELECT * FROM retur_suplier WHERE id_retur = '$id_retur'"); return $a[$isi]; } function retur_alasan_satu($id_retur,$isi) { $a = query_satu("SELECT * FROM retur_alasan WHERE id_retur = '$id_retur'"); return @$a[$isi]; } function si_bruto_total($id_si) { if (si_stok_pajak_jumlah($id_si)>0) { foreach(si_stok_detail($id_si) as $nb) : $k = "1.".si_stok_pajak($id_si,"persen"); $harga = ($nb["harga"]/$k); if ($nb["diskon_jenis_nama"] == 0) { $diskon = 0; }elseif ($nb["diskon_jenis_nama"] == 1) { $diskon = si_stok_detail_diskon_satu($nb["id_si"],$nb["id_produk"],"value"); }elseif ($nb["diskon_jenis_nama"] == 2) { $diskon = si_stok_detail_diskon_satu($nb["id_si"],$nb["id_produk"],"value")*$harga/100; } $harga_dong = ($harga-$diskon)*$nb["qty"]; @$tot += ($harga_dong); endforeach; }else { foreach(si_stok_detail($id_si) as $nb) : if ($nb["diskon_jenis_nama"] == 0) { $diskon = 0; }elseif ($nb["diskon_jenis_nama"] == 1) { $diskon = si_stok_detail_diskon_satu($nb["id_si"],$nb["id_produk"],"value"); }elseif ($nb["diskon_jenis_nama"] == 2) { $diskon = si_stok_detail_diskon_satu($nb["id_si"],$nb["id_produk"],"value")*$nb["harga"]/100; } $harga = ($nb["harga"]-$diskon) * $nb["qty"]; @$tot += $harga; endforeach; } return @$tot; } function si_netto($id_si) { $tot = si_bruto_total($id_si); return $tot; } function ewallet() { return query("SELECT * FROM e_wallet ORDER BY nama ASC"); } function ewallet_satu($id,$isi) { $a = query_satu("SELECT * FROM e_wallet WHERE id = '$id'"); return $a[$isi]; } function ewallet_kecuali($id_ewallet) { return query("SELECT * FROM e_wallet WHERE id != '$id_ewallet'"); } function ewallet_data() { return query("SELECT * FROM e_wallet_data ORDER BY id_ewallet ASC"); } function e_wallet_data_satu($id,$isi) { $a = query_satu("SELECT * FROM e_wallet_data WHERE id = '$id'"); return $a[$isi]; } function tampil_si_piutang (){ $i = []; $a = query("SELECT * FROM si, so, si_so, so_detail, so_tot, si_stok, si_stok detail WHERE si.id_si = si_so.id_si"); } function hutang_sisa($id_suplier) { if (jumlah("SELECT * FROM gr WHERE id_suplier = '$id_suplier' AND no_gr IN(SELECT kode FROM invoice_header)")>0) { $q = query("SELECT * FROM gr, invoice_header WHERE invoice_header.kode = gr.no_gr AND gr.id_suplier = '$id_suplier'"); foreach($q as $qs) : if (invoice_jumlah($qs["no_invoice"])>0) { $jum =+ invoice_satu($qs["no_invoice"],"value"); } endforeach; return $jum; } } function hutang_cek_jum($id_suplier) { $cek = jumlah("SELECT * FROM hutang WHERE id_suplier = '$id_suplier' AND id_status = 49"); return $cek; } function hutang_not_save($id_suplier,$isi) { $a = query_satu("SELECT * FROM hutang WHERE id_suplier = '$id_suplier' AND id_status = 49"); return $a[$isi]; } function hutang_satu($id,$isi) { $a = query_satu("SELECT * FROM hutang WHERE id = '$id'"); return $a[$isi]; } function hutang_faktur($id_hutang) { $a = query("SELECT * FROM hutang_faktur WHERE id_hutang = '$id_hutang'"); return $a; } function hutang_faktur_invoice_jum($id_hutang,$no_invoice) { return jumlah("SELECT * FROM hutang_faktur WHERE id_hutang = '$id_hutang' AND no_invoice = '$no_invoice'"); } function hutang_faktur_invoice_satu($id_hutang,$no_invoice,$isi) { $a = query_satu("SELECT * FROM hutang_faktur WHERE id_hutang = '$id_hutang' AND no_invoice = '$no_invoice'"); return $a[$isi]; } function hutang_faktur_total_bayar($id_hutang) { $query = hutang_faktur($id_hutang); foreach($query as $q) : $jum_bayar = $q["jum_bayar"]; @$tot_bayar += $jum_bayar; endforeach; return @$tot_bayar; } function hutang_bayar_jum($id_hutang,$id_hutang_bayar_jenis) { return jumlah("SELECT * FROM hutang_bayar WHERE id_hutang = '$id_hutang' AND id_hutang_bayar_jenis = '$id_hutang_bayar_jenis'"); } function hutang_bayar_satu($id_hutang,$id_hutang_bayar_jenis,$isi) { $a = query_satu("SELECT * FROM hutang_bayar WHERE id_hutang = '$id_hutang' AND id_hutang_bayar_jenis = '$id_hutang_bayar_jenis'"); return $a[$isi]; } function hutang_bayar_total($id_hutang) { $a = query("SELECT * FROM hutang_bayar WHERE id_hutang = '$id_hutang'"); foreach($a as $b) : $nilai = $b["nilai"]; @$total += $nilai; endforeach; return $total; } function hutang_bayar_kode_jum($id_hutang,$id_hutang_bayar_jenis) { return jumlah("SELECT * FROM hutang_bayar_kode WHERE id_hutang = '$id_hutang' AND id_hutang_bayar_jenis = '$id_hutang_bayar_jenis'"); } function hutang_bayar_kode_satu($id_hutang,$id_hutang_bayar_jenis,$isi) { $a = query_satu("SELECT * FROM hutang_bayar_kode WHERE id_hutang = '$id_hutang' AND id_hutang_bayar_jenis = '$id_hutang_bayar_jenis'"); return $a[$isi]; } function hutang_giro($id_hutang) { return query("SELECT * FROM hutang_giro WHERE id_hutang = '$id_hutang'"); } function hutang_giro_satu($id,$isi) { $a = query_satu("SELECT * FROM hutang_giro WHERE id = '$id'"); return $a[$isi]; } function hutang_giro_total($id_hutang) { foreach(hutang_giro($id_hutang) as $hg) : @$nilai_faktur += $hg["nilai_faktur"]; endforeach; return @$nilai_faktur; } function hutang_panjar_giro($id_hutang) { return query("SELECT * FROM hutang_panjar_giro WHERE id_hutang = '$id_hutang'"); } function sisa_hari($tanggal_awal,$tanggal_akhir) { $tgl1 = strtotime($tanggal_awal); $tgl2 = strtotime($tanggal_akhir); $jarak = $tgl2 - $tgl1; $hari = $jarak / 60 / 60 / 24; return $hari; }
Editor is loading...