Skip to content

Instantly share code, notes, and snippets.

@mdmunir

mdmunir/excel-columns.php

Created April 22, 2022 07:16
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mdmunir/c78d0bebe14b2d12a71af9737e6b0ff7 to your computer and use it in GitHub Desktop.
Save mdmunir/c78d0bebe14b2d12a71af9737e6b0ff7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
excel-columns.php
<?php
// API /api/customer-lt
$columns = [
[
'key' => 'registration_at',
'title' => 'Tanggal Didaftarkan',
'type' => 'date',
'width' => 22,
],
[
'key' => 'code',
'title' => 'ID Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'name',
'title' => 'Nama Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor_code',
'title' => 'Kode Large Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor_name',
'title' => 'Nama Large Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'address',
'title' => 'Alamat',
'type' => 'string',
'width' => 22,
],
[
'key' => 'owner',
'title' => 'Nama Pemilik Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor_code2',
'title' => 'Kode Distributor Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor_name2',
'title' => 'Nama Distributor Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'region',
'title' => 'Region Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'provinsi',
'title' => 'Provinsi Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'area',
'title' => 'Area Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kabupaten',
'title' => 'Kabupaten Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kecamatan',
'title' => 'Kecamatan Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'desa',
'title' => 'Kelurahan / Desa Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'status_text',
'title' => 'status toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'status',
'title' => 'Status Approval',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kelengkapan_dokumen',
'title' => 'kelengkapan dokumen',
'type' => 'string',
'width' => 22,
],
];
// API /api/customers
$columns = [
[
'key' => 'registration_at',
'title' => 'Tanggal Didaftarkan',
'type' => 'date',
'width' => 22,
],
[
'key' => 'code',
'title' => 'ID Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'name',
'title' => 'Nama Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor_code',
'title' => 'Kode Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor_name',
'title' => 'Nama Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'address',
'title' => 'Alamat',
'type' => 'string',
'width' => 22,
],
[
'key' => 'owner',
'title' => 'Nama Pemilik Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'desa',
'title' => 'Kelurahan / Desa Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kecamatan',
'title' => 'Kecamatan Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kabupaten',
'title' => 'Kabupaten Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'area',
'title' => 'Area Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'provinsi',
'title' => 'Provinsi Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'region',
'title' => 'Region Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'status_text',
'title' => 'Status Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'status',
'title' => 'Status Approval',
'type' => 'string',
'width' => 22,
],
];
// API /api/distributors
$columns = [
[
'key' => 'code',
'title' => 'Kode Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'name',
'title' => 'Nama Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'address',
'title' => 'Alamat Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'jumlah_gudang',
'title' => 'Total Gudang',
'type' => '0',
'width' => 22,
],
[
'key' => 'areas',
'title' => 'Cakupan Area Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kapasitas_gudang',
'title' => 'Total Kapasitas Gudang',
'type' => '0',
'width' => 22,
],
[
'key' => 'jumlah_toko',
'title' => 'Jumlah Toko',
'type' => '0',
'width' => 22,
],
[
'key' => 'status_text',
'title' => 'Status Distributor',
'type' => 'string',
'width' => 22,
],
];
// API /api/lt
$columns = [
[
'key' => 'registration_at',
'title' => 'Tanggal Didaftarkan',
'type' => 'datetime',
'width' => 22,
],
[
'key' => 'code',
'title' => 'ID Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'name',
'title' => 'Nama Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor_code',
'title' => 'Kode Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor_name',
'title' => 'Nama Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'address',
'title' => 'Alamat',
'type' => 'string',
'width' => 22,
],
[
'key' => 'owner',
'title' => 'Nama Pemilik Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'region',
'title' => 'Region Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'provinsi',
'title' => 'Provinsi Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'area',
'title' => 'Area Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kabupaten',
'title' => 'Kabupaten Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kecamatan',
'title' => 'Kecamatan Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'desa',
'title' => 'Kelurahan / Desa Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'status_text',
'title' => 'Status Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'status',
'title' => 'Status Approval',
'type' => 'string',
'width' => 22,
],
];
// API /api/organizations
$columns = [
[
'key' => 'no',
'title' => 'No',
'type' => 'string',
'width' => 22,
],
[
'key' => 'name',
'title' => 'Nama Organisasi',
'type' => 'string',
'width' => 22,
],
[
'key' => 'level',
'title' => 'Level Organisasi',
'type' => 'string',
'width' => 22,
],
[
'key' => 'description',
'title' => 'Struktur Organisasi',
'type' => 'string',
'width' => 22,
],
[
'key' => 'status',
'title' => 'Status',
'type' => 'string',
'width' => 22,
],
];
// API /api/products
$columns = [
[
'key' => 'code',
'title' => 'Kode Produk',
'type' => 'string',
'width' => 22,
],
[
'key' => 'name',
'title' => 'Nama Produk',
'type' => 'string',
'width' => 22,
],
[
'key' => 'category',
'title' => 'Kategori',
'type' => 'string',
'width' => 22,
],
[
'key' => 'subcategory',
'title' => 'Sub Kategori',
'type' => 'string',
'width' => 22,
],
[
'key' => 'brand_name',
'title' => 'Brand Produk',
'type' => 'string',
'width' => 22,
],
];
// API /api/report-oi/level-stock
$columns = [
[
'key' => 'kode_distri_si',
'title' => 'Kode Distributor SI',
'type' => 'string',
'width' => 22,
],
[
'key' => 'nama_distrik',
'title' => 'Nama Distrik',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kode_gudang_si',
'title' => 'Kode Gudang SI',
'type' => 'string',
'width' => 22,
],
[
'key' => 'gudang',
'title' => 'Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'alamat',
'title' => 'Alamat',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kapasitas_bongkar',
'title' => 'Kemampuan Bongkar Gudang',
'type' => '0',
'width' => 22,
],
[
'key' => 'so_hari_ini',
'title' => 'SO Hari ini + CO',
'type' => '0.00',
'width' => 22,
],
[
'key' => 'ketahanan_so',
'title' => 'Ketahanan SO (Hari)',
'type' => '0.0',
'width' => 22,
],
[
'key' => 'kapasitas_gudang',
'title' => 'Kapasitas (ZAK)',
'type' => '0',
'width' => 22,
],
[
'key' => 'volume_stock_gudang',
'title' => 'Volume Stok Gudang (ZAK)',
'type' => '0',
'width' => 22,
],
[
'key' => 'level_stock',
'title' => 'Level Stok Gudang (All Brand)',
'type' => '0.00',
'width' => 22,
],
[
'key' => 'penjualan_avg',
'title' => 'Rata-rata Sell Out (ZAK)',
'type' => '0.00',
'width' => 22,
],
[
'key' => 'sell_out',
'title' => 'Sell Out (ZAK)',
'type' => '0.00',
'width' => 22,
],
[
'key' => 'ketahanan_stock',
'title' => 'Ketahanan Stok (Hari)',
'type' => '0.00',
'width' => 22,
],
[
'key' => 'antrian_truk',
'title' => 'Antrian Truk',
'type' => '0',
'width' => 22,
],
[
'key' => 'status_gudang',
'title' => 'Status Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'action_plant',
'title' => 'Action Plan',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kekurangan_so',
'title' => 'Kekurangan SO',
'type' => '0',
'width' => 22,
],
[
'key' => 'siap_kirim',
'title' => 'Siap Kirim Hari ini',
'type' => '0',
'width' => 22,
],
[
'key' => 'ssc',
'title' => 'SO Clean & Clear (TON)',
'type' => '0.00',
'width' => 22,
],
[
'key' => 'pic',
'title' => 'PIC',
'type' => 'string',
'width' => 22,
],
[
'key' => 'ship_out',
'title' => 'Ship Out (ZAK)',
'type' => '0',
'width' => 22,
],
[
'key' => 'sell_in',
'title' => 'Sell In (ZAK)',
'type' => '0',
'width' => 22,
],
[
'key' => 'keterangan',
'title' => 'Keterangan',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distibutor',
'title' => 'Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distrik',
'title' => 'Distrik',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kd_distri_sbi',
'title' => 'Kode Distributor SBI',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kd_gudang_sbi',
'title' => 'Kode Gudang SBI',
'type' => 'string',
'width' => 22,
],
[
'key' => 'tanggal_stock',
'title' => 'Tanggal Stok',
'type' => 'date',
'width' => 22,
],
];
// API /api/report-oi/per-distrik
$columns = [
[
'key' => 'kode_distrik',
'title' => 'Kode Distrik',
'type' => 'string',
'width' => 22,
],
[
'key' => 'nama_distrik',
'title' => 'Nama Distrik',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kapasitas_bongkar',
'title' => 'Kemampuan Bongkar Gudang',
'type' => '0',
'width' => 22,
],
[
'key' => 'so_hari_ini',
'title' => 'SO Hari ini + CO',
'type' => '0',
'width' => 22,
],
[
'key' => 'ketahanan_so',
'title' => 'Ketahanan SO (Hari)',
'type' => '0',
'width' => 22,
],
[
'key' => 'kapasitas_gudang',
'title' => 'Kapasitas',
'type' => '0',
'width' => 22,
],
[
'key' => 'volume_stock_gudang',
'title' => 'Volume Stok Gudang',
'type' => '0',
'width' => 22,
],
[
'key' => 'level_stock',
'title' => 'Level Stok Gudang',
'type' => '0.00',
'width' => 22,
],
[
'key' => 'penjualan_avg',
'title' => 'Rata - rata Penjualan (ZAK)',
'type' => '0.00',
'width' => 22,
],
[
'key' => 'ketahanan_stock',
'title' => 'Ketahanan Stok (Hari)',
'type' => '0',
'width' => 22,
],
[
'key' => 'ship_out',
'title' => 'Ship Out [Pengiriman Pabrik H-1](ZAK)',
'type' => '0',
'width' => 22,
],
];
// API /api/report/customer-noo
$columns = [
[
'key' => 'customer_id',
'title' => 'ID Customer',
'type' => 'string',
'width' => 22,
],
[
'key' => 'customer_name',
'title' => 'Nama Customer',
'type' => 'string',
'width' => 22,
],
[
'key' => 'wilayah_name',
'title' => 'Wilayah',
'type' => 'string',
'width' => 22,
],
[
'key' => 'area_name',
'title' => 'Area',
'type' => 'string',
'width' => 22,
],
[
'key' => 'region_name',
'title' => 'Regional',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor_code',
'title' => 'Kode Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor_name',
'title' => 'Nama Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'product_code',
'title' => 'Kode Product',
'type' => 'string',
'width' => 22,
],
[
'key' => 'product_name',
'title' => 'Nama Product',
'type' => 'string',
'width' => 22,
],
[
'key' => 'brand_name',
'title' => 'Brand',
'type' => 'string',
'width' => 22,
],
[
'key' => 'date',
'title' => 'Tanggal',
'type' => 'date',
'width' => 22,
],
[
'key' => 'qty',
'title' => 'Quality',
'type' => '0',
'width' => 22,
],
[
'key' => 'price',
'title' => 'Harga',
'type' => '0',
'width' => 22,
],
];
// API /api/report/detail-gudang-distributor
$columns = [
[
'key' => 'bulan',
'title' => 'Bulan',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distri_code',
'title' => 'Kode Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distri_name',
'title' => 'Nama Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'gudang_code',
'title' => 'Kode Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'gudang_name',
'title' => 'Nama Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'product_code',
'title' => 'Kode Produk',
'type' => 'string',
'width' => 22,
],
[
'key' => 'product_name',
'title' => 'Nama Produk',
'type' => 'string',
'width' => 22,
],
[
'key' => 'uom',
'title' => 'UOM',
'type' => 'string',
'width' => 22,
],
[
'key' => 'stock_awal',
'title' => 'Stok Awal',
'type' => '0',
'width' => 22,
],
[
'key' => 'sell_in',
'title' => 'Sell In',
'type' => '0',
'width' => 22,
],
[
'key' => 'sell_out',
'title' => 'Sell Out',
'type' => '0',
'width' => 22,
],
[
'key' => 'selisih',
'title' => 'Selisih',
'type' => '0',
'width' => 22,
],
];
// API /api/report/detail-trx-lt/toko
$columns = [
[
'key' => 'tanggal',
'title' => 'Tanggal Transaksi',
'type' => 'date',
'width' => 22,
],
[
'key' => 'ts_id',
'title' => 'ID Transaksi',
'type' => 'string',
'width' => 22,
],
[
'key' => 'toko_code',
'title' => 'ID Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'toko_name',
'title' => 'Nama Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'toko_kab',
'title' => 'Kabupaten Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'toko_prov',
'title' => 'Propinsi Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'toko_area',
'title' => 'Area Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'toko_reg',
'title' => 'Region Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'brand_name',
'title' => 'Brand Name',
'type' => 'string',
'width' => 22,
],
[
'key' => 'product_code',
'title' => 'Product Code',
'type' => 'string',
'width' => 22,
],
[
'key' => 'product_name',
'title' => 'Product Name',
'type' => 'string',
'width' => 22,
],
[
'key' => 'price',
'title' => 'Price ',
'type' => '0',
'width' => 22,
],
[
'key' => 'quantity_zak',
'title' => 'qty_zak',
'type' => '0',
'width' => 22,
],
[
'key' => 'uom1',
'title' => 'UOM 1 ',
'type' => 'string',
'width' => 22,
],
[
'key' => 'quantity_ton',
'title' => 'qty_ton',
'type' => '0.00',
'width' => 22,
],
[
'key' => 'uom2',
'title' => 'UOM 2',
'type' => 'string',
'width' => 22,
],
[
'key' => 'lt_code',
'title' => 'Kode LT',
'type' => 'string',
'width' => 22,
],
[
'key' => 'lt_name',
'title' => 'Nama LT',
'type' => 'string',
'width' => 22,
],
[
'key' => 'lt_kab',
'title' => 'Kabupaten LT',
'type' => 'string',
'width' => 22,
],
[
'key' => 'lt_prov',
'title' => 'Propinsi LT',
'type' => 'string',
'width' => 22,
],
[
'key' => 'lt_area',
'title' => 'Area LT',
'type' => 'string',
'width' => 22,
],
[
'key' => 'lt_reg',
'title' => 'Region LT',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor_code',
'title' => 'Distributor Code',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor_name',
'title' => 'Distributor Name',
'type' => 'string',
'width' => 22,
],
];
// API /api/report/detail-trx/distributor
$columns = [
[
'key' => 'tanggal',
'title' => 'Tanggal Transaksi',
'type' => 'date',
'width' => 22,
],
[
'key' => 'customer_code',
'title' => 'ID Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'customer_name',
'title' => 'Nama Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'customer_address',
'title' => 'Alamat Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'customer_kabupaten',
'title' => 'Kabupaten Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'customer_propinsi',
'title' => 'Provinsi Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'customer_regional',
'title' => 'Regional Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'customer_area',
'title' => 'Area Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'brand_name',
'title' => 'Brands',
'type' => 'string',
'width' => 22,
],
[
'key' => 'product_code',
'title' => 'Kode Produk',
'type' => 'string',
'width' => 22,
],
[
'key' => 'product_name',
'title' => 'Nama Produk',
'type' => 'string',
'width' => 22,
],
[
'key' => 'price',
'title' => 'Harga',
'type' => '0',
'width' => 22,
],
[
'key' => 'quantity_zak',
'title' => 'Zak Quantity ',
'type' => '0',
'width' => 22,
],
[
'key' => 'uom1',
'title' => 'UOM 1',
'type' => 'string',
'width' => 22,
],
[
'key' => 'quantity_ton',
'title' => 'TON Quantity ',
'type' => '0.00',
'width' => 22,
],
[
'key' => 'uom2',
'title' => 'UOM 2',
'type' => 'string',
'width' => 22,
],
[
'key' => 'transaksi_code',
'title' => 'No Transaksi',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor_code',
'title' => 'Kode Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor_name',
'title' => 'Nama Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'warehouse_code',
'title' => 'Kode Gudang ',
'type' => 'string',
'width' => 22,
],
[
'key' => 'warehouse_name',
'title' => 'Nama Gudang ',
'type' => 'string',
'width' => 22,
],
[
'key' => 'regional_name',
'title' => 'Regional Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'warehouse_propinsi',
'title' => 'Provinsi Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'warehouse_area',
'title' => 'Area Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'warehouse_kabupaten',
'title' => 'Kabupaten Gudang',
'type' => 'string',
'width' => 22,
],
];
// API /api/report/detail-trx/toko
$columns = [
[
'key' => 'tanggal',
'title' => 'Tanggal Transaksi',
'type' => 'date',
'width' => 22,
],
[
'key' => 'customer_code',
'title' => 'ID Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'customer_name',
'title' => 'Nama Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'customer_address',
'title' => 'Alamat Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'customer_kabupaten',
'title' => 'Kabupaten Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'customer_propinsi',
'title' => 'Provinsi Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'customer_regional',
'title' => 'Regional Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'customer_area',
'title' => 'Area Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'brand_name',
'title' => 'Brands',
'type' => 'string',
'width' => 22,
],
[
'key' => 'product_code',
'title' => 'Kode Produk',
'type' => 'string',
'width' => 22,
],
[
'key' => 'product_name',
'title' => 'Nama Produk',
'type' => 'string',
'width' => 22,
],
[
'key' => 'price',
'title' => 'Harga',
'type' => '0',
'width' => 22,
],
[
'key' => 'quantity_zak',
'title' => 'Zak Quantity ',
'type' => '0',
'width' => 22,
],
[
'key' => 'uom1',
'title' => 'UOM 1',
'type' => 'string',
'width' => 22,
],
[
'key' => 'quantity_ton',
'title' => 'TON Quantity ',
'type' => '0.00',
'width' => 22,
],
[
'key' => 'uom2',
'title' => 'UOM 2',
'type' => 'string',
'width' => 22,
],
[
'key' => 'transaksi_code',
'title' => 'No Transaksi',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor_code',
'title' => 'Kode Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor_name',
'title' => 'Nama Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'warehouse_code',
'title' => 'Kode Gudang ',
'type' => 'string',
'width' => 22,
],
[
'key' => 'warehouse_name',
'title' => 'Nama Gudang ',
'type' => 'string',
'width' => 22,
],
[
'key' => 'regional_name',
'title' => 'Regional Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'warehouse_propinsi',
'title' => 'Provinsi Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'warehouse_area',
'title' => 'Area Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'warehouse_kabupaten',
'title' => 'Kabupaten Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'type_name',
'title' => 'Tipe Customer',
'type' => 'string',
'width' => 22,
],
[
'key' => 'created_at_dist',
'title' => 'Created_at_Dist',
'type' => 'datetime',
'width' => 22,
],
];
// API /api/report/distributor
$columns = [
[
'key' => 'vendor_si',
'title' => 'Kode Distributor SI',
'type' => 'string',
'width' => 22,
],
[
'key' => 'vendor_sbi',
'title' => 'Kode Distributor SBI',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor',
'title' => 'Nama Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'gudang_si',
'title' => 'Kode Gudang SI',
'type' => 'string',
'width' => 22,
],
[
'key' => 'gudang_sbi',
'title' => 'Kode Gudang SBI',
'type' => 'string',
'width' => 22,
],
[
'key' => 'tanggal',
'title' => 'Tanggal Stok',
'type' => 'date',
'width' => 22,
],
[
'key' => 'gudang',
'title' => 'Nama Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'address',
'title' => 'Alamat Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kapasitas',
'title' => 'Kapasitas Gudang',
'type' => '0',
'width' => 22,
],
[
'key' => 'kapasitas_bongkar',
'title' => 'Kemampuan Bongkar Gudang',
'type' => '0',
'width' => 22,
],
[
'key' => 'stok',
'title' => 'Volume Stok (ZAK)',
'type' => '0',
'width' => 22,
],
[
'key' => 'level_stock',
'title' => 'Level Stok',
'type' => '0.00',
'width' => 22,
],
];
// API /api/report/gpm-distributor
$columns = [
[
'key' => 'dist_code',
'title' => 'Kode Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'dist_name',
'title' => 'Nama Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'product_code',
'title' => 'Kode Produk',
'type' => 'string',
'width' => 22,
],
[
'key' => 'product_name',
'title' => 'Nama Produk',
'type' => 'string',
'width' => 22,
],
[
'key' => 'price',
'title' => 'Harga Beli ',
'type' => '0',
'width' => 22,
],
[
'key' => 'min_price',
'title' => 'Harga Jual (MIN) ',
'type' => '0',
'width' => 22,
],
[
'key' => 'max_price',
'title' => 'Harga Jual (MAX) ',
'type' => '0',
'width' => 22,
],
[
'key' => 'avg_price',
'title' => 'Harga Jual (AVG) ',
'type' => '0',
'width' => 22,
],
[
'key' => 'margin',
'title' => 'Margin',
'type' => '0',
'width' => 22,
],
[
'key' => 'margin_persen',
'title' => '% Margin ',
'type' => '0.00',
'width' => 22,
],
];
// API /api/report/gpm-gudang
$columns = [
[
'key' => 'warehouse_code',
'title' => 'Kode Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'warehouse_name',
'title' => 'Nama Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'product_code',
'title' => 'Kode Produk',
'type' => 'string',
'width' => 22,
],
[
'key' => 'product_name',
'title' => 'Nama Produk',
'type' => 'string',
'width' => 22,
],
[
'key' => 'region_name',
'title' => 'Region Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'provinsi',
'title' => 'Provinsi Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'area_name',
'title' => 'Area Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kabupaten',
'title' => 'Kabupaten/Kota Gudang ',
'type' => 'string',
'width' => 22,
],
[
'key' => 'price',
'title' => 'Harga Beli ',
'type' => '0',
'width' => 22,
],
[
'key' => 'min_price',
'title' => 'Harga Jual (MIN) ',
'type' => '0',
'width' => 22,
],
[
'key' => 'max_price',
'title' => 'Harga Jual (MAX) ',
'type' => '0',
'width' => 22,
],
[
'key' => 'avg_price',
'title' => 'Harga Jual (AVG)',
'type' => '0',
'width' => 22,
],
[
'key' => 'margin',
'title' => 'Margin',
'type' => '0',
'width' => 22,
],
[
'key' => 'margin_persen',
'title' => '% Margin',
'type' => '0.00',
'width' => 22,
],
];
// API /api/report/performance-gudang
$columns = [
[
'key' => 'date',
'title' => 'Tanggal',
'type' => 'date',
'width' => 22,
],
[
'key' => 'gudang_code',
'title' => 'Kode Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'gudang_name',
'title' => 'Nama Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'sell_in',
'title' => 'Sell In',
'type' => '0',
'width' => 22,
],
[
'key' => 'sell_out',
'title' => 'Sell Out',
'type' => '0',
'width' => 22,
],
[
'key' => 'stock',
'title' => 'Stock',
'type' => '0',
'width' => 22,
],
[
'key' => 'regional',
'title' => 'Nama Regional',
'type' => 'string',
'width' => 22,
],
[
'key' => 'provinsi',
'title' => 'Nama Provinsi',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kabupaten',
'title' => 'Nama Kabupaten Kota',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor',
'title' => 'Nama Distributor',
'type' => 'string',
'width' => 22,
],
];
// API /api/report/potensi-penjualan
$columns = [
[
'key' => 'distributor_code',
'title' => 'Kode Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor_name',
'title' => 'Nama Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'warehouse_code',
'title' => 'Kode Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'warehouse_name',
'title' => 'Nama Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'wilayah_name',
'title' => 'Alamat',
'type' => 'string',
'width' => 22,
],
[
'key' => 'provinsi',
'title' => 'Gudang Provinsi',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kapasitas',
'title' => 'Kapasitas Gudang (ZAK)',
'type' => '0',
'width' => 22,
],
[
'key' => 'kapasitas_bongkarmuat',
'title' => 'Kapasitas Bongkar',
'type' => '0',
'width' => 22,
],
[
'key' => 'brands',
'title' => 'Stok Brands',
'type' => 'string',
'width' => 22,
],
[
'key' => 'qty_stock',
'title' => 'Stok Gudang',
'type' => '0',
'width' => 22,
],
[
'key' => 'date_stock',
'title' => 'Tanggal Sync Stok',
'type' => 'date',
'width' => 22,
],
[
'key' => 'avg_out',
'title' => 'Rata - Rata Penjualan',
'type' => '0',
'width' => 22,
],
[
'key' => 'level',
'title' => 'Level Stock %',
'type' => '0.00',
'width' => 22,
],
[
'key' => 'qty_gr',
'title' => 'Penerimaan(ZAK)',
'type' => '0',
'width' => 22,
],
[
'key' => 'qty_sales',
'title' => 'Penjualan(ZAK)',
'type' => '0',
'width' => 22,
],
[
'key' => 'avg_out',
'title' => 'Rata - rata Penjualan(ZAK)',
'type' => '0',
'width' => 22,
],
[
'key' => 'ketahanan_stock',
'title' => 'Ketahanan Stok(Hari)',
'type' => '0',
'width' => 22,
],
[
'key' => 'min_price_40',
'title' => 'Minimum Harga (40Kg)',
'type' => '0',
'width' => 22,
],
[
'key' => 'max_price_40',
'title' => 'Maximum Harga (40Kg)',
'type' => '0',
'width' => 22,
],
[
'key' => 'avg_price_40',
'title' => 'Rata - rata Harga(40Kg)',
'type' => '0',
'width' => 22,
],
[
'key' => 'mode_price_40',
'title' => 'Modus Harga(40Kg)',
'type' => '0',
'width' => 22,
],
[
'key' => 'min_price_50',
'title' => 'Minimum Harga (50Kg)',
'type' => '0',
'width' => 22,
],
[
'key' => 'max_price_50',
'title' => 'Maximum Harga (50Kg)',
'type' => '0',
'width' => 22,
],
[
'key' => 'avg_price_50',
'title' => 'Rata - rata Harga(50Kg)',
'type' => '0',
'width' => 22,
],
[
'key' => 'mode_price_50',
'title' => 'Modus Harga(50Kg)',
'type' => '0',
'width' => 22,
],
[
'key' => 'jml_trx',
'title' => 'Jumlah Transaksi Penjualan',
'type' => '0',
'width' => 22,
],
[
'key' => 'trx_toko',
'title' => 'Toko Transaksi(ID Toko)',
'type' => '0',
'width' => 22,
],
];
// API /api/report/transaksi-distributor
$columns = [
[
'key' => 'bulan',
'title' => 'Bulan',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distri_code',
'title' => 'Kode Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distri_name',
'title' => 'Nama Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'product_code',
'title' => 'Kode Product',
'type' => 'string',
'width' => 22,
],
[
'key' => 'product_name',
'title' => 'Nama Produk',
'type' => 'string',
'width' => 22,
],
[
'key' => 'uom',
'title' => 'UOM',
'type' => 'string',
'width' => 22,
],
[
'key' => 'stock_awal',
'title' => 'Stok Awal',
'type' => '0',
'width' => 22,
],
[
'key' => 'sell_in',
'title' => 'Sell In',
'type' => '0',
'width' => 22,
],
[
'key' => 'sell_out',
'title' => 'Sell Out',
'type' => '0',
'width' => 22,
],
[
'key' => 'w_idbk',
'title' => 'Penjualan Dengan ID Toko',
'type' => '0',
'width' => 22,
],
[
'key' => 'n_idbk',
'title' => 'Penjualan Tanpa ID Toko',
'type' => '0',
'width' => 22,
],
[
'key' => 'selisih',
'title' => 'Selisih Stok',
'type' => '0',
'width' => 22,
],
[
'key' => 'status',
'title' => 'Status',
'type' => 'string',
'width' => 22,
],
];
// API /api/report/transaksi-toko
$columns = [
[
'key' => 'bulan',
'title' => 'Bulan',
'type' => 'string',
'width' => 22,
],
[
'key' => 'tahun',
'title' => 'Tahun',
'type' => '0',
'width' => 22,
],
[
'key' => 'id_bk',
'title' => 'ID BK',
'type' => 'string',
'width' => 22,
],
[
'key' => 'toko_name',
'title' => 'Nama Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'wr_prov',
'title' => 'Provinsi Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'wr_kab',
'title' => 'Kabupaten / Kota Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'wr_reg',
'title' => 'Region Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'wr_area',
'title' => 'Area Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'code_distri',
'title' => 'Kode Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distri_name',
'title' => 'Nama Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'product_name',
'title' => 'Produk',
'type' => 'string',
'width' => 22,
],
[
'key' => 'uom',
'title' => 'UoM Produk',
'type' => 'string',
'width' => 22,
],
[
'key' => 'total_volume',
'title' => 'Total Volume',
'type' => '0',
'width' => 22,
],
[
'key' => 'total_trx',
'title' => 'Total Transaksi',
'type' => '0',
'width' => 22,
],
];
// API /api/report/transaksi-toko-harian
$columns = [
[
'key' => 'tgl_trx',
'title' => 'Tanggal Transaksi',
'type' => 'date',
'width' => 22,
],
[
'key' => 'id_bk',
'title' => 'ID Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'nama_toko',
'title' => 'Nama Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'reg_toko',
'title' => 'Regional Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'prov_toko',
'title' => 'Provinsi Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'area_toko',
'title' => 'Area Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kab_toko',
'title' => 'Kabupaten/Kota Toko',
'type' => 'string',
'width' => 22,
],
[
'key' => 'no_so',
'title' => 'No Transaksi',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distri_code',
'title' => 'Kode Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distri_name',
'title' => 'Nama Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kode_produk',
'title' => 'Kode Produk',
'type' => 'string',
'width' => 22,
],
[
'key' => 'produk_name',
'title' => 'Nama Produk',
'type' => 'string',
'width' => 22,
],
[
'key' => 'brand',
'title' => 'Brands',
'type' => 'string',
'width' => 22,
],
[
'key' => 'uom',
'title' => 'UOM ',
'type' => 'string',
'width' => 22,
],
[
'key' => 'zak_qty',
'title' => 'Zak Quantity ',
'type' => '0',
'width' => 22,
],
[
'key' => 'ton_qty',
'title' => 'TON Quantity ',
'type' => '0.00',
'width' => 22,
],
[
'key' => 'price',
'title' => 'Harga ',
'type' => '0',
'width' => 22,
],
[
'key' => 'total_price',
'title' => 'Total Harga ',
'type' => '0',
'width' => 22,
],
[
'key' => 'kode_gudang',
'title' => 'Kode Gudang ',
'type' => 'string',
'width' => 22,
],
[
'key' => 'nama_gudang',
'title' => 'Nama Gudang ',
'type' => 'string',
'width' => 22,
],
[
'key' => 'reg_gudang',
'title' => 'Regional Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'prov_gudang',
'title' => 'Provinsi Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'area_gudang',
'title' => 'Area Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kab_gudang',
'title' => 'Kota / Kabupaten Gudang',
'type' => 'string',
'width' => 22,
],
];
// API /api/sales-organisasi
$columns = [
[
'key' => 'fullname',
'title' => 'Nama Sales',
'type' => 'string',
'width' => 22,
],
[
'key' => 'username',
'title' => 'User Name',
'type' => 'string',
'width' => 22,
],
[
'key' => 'role_name',
'title' => 'Level Sales',
'type' => 'string',
'width' => 22,
],
[
'key' => 'area',
'title' => 'Area',
'type' => 'string',
'width' => 22,
],
[
'key' => 'status',
'title' => 'Status',
'type' => 'string',
'width' => 22,
],
];
// API /api/warehouses
$columns = [
[
'key' => 'code',
'title' => 'Kode Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'name',
'title' => 'Nama Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'address',
'title' => 'Alamat Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor_code',
'title' => 'Kode Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'distributor',
'title' => 'Nama Distributor',
'type' => 'string',
'width' => 22,
],
[
'key' => 'region',
'title' => 'Region Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'provinsi',
'title' => 'Provinsi Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'area',
'title' => 'Area Gudang',
'type' => 'string',
'width' => 22,
],
[
'key' => 'wilayah',
'title' => 'Kabupaten / Kota',
'type' => 'string',
'width' => 22,
],
[
'key' => 'kapasitas',
'title' => 'Kapasitas Gudang',
'type' => '0',
'width' => 22,
],
[
'key' => 'kapasitas_bongkarmuat',
'title' => 'Kapasitas Bongkar Muat',
'type' => '0',
'width' => 22,
],
];
// API /api/wilayah
$columns = [
[
'key' => 'region',
'title' => 'Nama Regional',
'type' => 'string',
'width' => 22,
],
[
'key' => 'area',
'title' => 'Nama Area',
'type' => 'string',
'width' => 22,
],
[
'key' => 'provinsi',
'title' => 'Nama Provinsi',
'type' => 'string',
'width' => 22,
],
[
'key' => 'name',
'title' => 'Nama Kabupaten Kota',
'type' => 'string',
'width' => 22,
],
[
'key' => 'jumlah_kec',
'title' => 'Total Kecamatan',
'type' => '0',
'width' => 22,
],
];
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment