function browse()
{
$data['controller'] = $this->controller;
$data['fields_caption'] = array('Kode', 'Var Value', 'keterangan');
$data['fields'] = array('varname', 'varvalue', 'keterangan');
$data['field_key'] = 'varname';
$data['caption'] = 'DAFTAR KODE PENOMORAN TRANSAKSI';
$this->load->library('search_criteria');
$faa[] = criteria("Search: ", "sid_nama");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 50, $order_column = 'sales_order_number', $order_type = 'asc')
{
$data['controller'] = 'coa_group';
$data['fields_caption'] = array('Kode', 'Nama Kelompok Akun Perkiraan', 'Parent', 'Type');
$data['fields'] = array('group_type', 'group_name', 'parent_group_type', 'account_type');
$data['field_key'] = 'group_type';
$data['caption'] = 'DAFTAR KELOMPOK PERKIRAAN';
$this->load->library('search_criteria');
$faa[] = criteria("Kelompok", "sid_nama");
$data['criteria'] = $faa;
$this->template->display_browse($data);
}
function browse($offset = 0, $limit = 50, $order_column = 'account', $order_type = 'asc')
{
$data['controller'] = 'coa';
$data['fields_caption'] = array('Type Akun', 'Kelompok', 'Kode Akun', 'Nama Akun Perkiraan', 'Db/Cr', 'Saldo Awal');
$data['fields'] = array('account_type', 'group_type', 'account', 'account_description', 'db_or_cr', 'beginning_balance');
$data['field_key'] = 'account';
$data['caption'] = 'DAFTAR KODE AKUN / COA / PERKIRAAN';
$this->load->library('search_criteria');
$faa[] = criteria("Kode Akun", "sid_no");
$faa[] = criteria("Nama Akun", "sid_nama");
$faa[] = criteria("Kelompok", "sid_kel");
$data['criteria'] = $faa;
$this->template->display_browse($data);
}
function browse($offset = 0, $limit = 50, $order_column = '', $order_type = 'asc')
{
$data['controller'] = $this->controller;
$data['fields_caption'] = array('Nomor Bukti', 'Tanggal', 'Faktur', 'Jumlah', 'Keterangan', 'Kode Akun', 'Perkiraan');
$data['fields'] = array('kodecrdb', 'tanggal', 'docnumber', 'amount', 'keterangan', 'account', 'account_description');
$data['field_key'] = 'kodecrdb';
$data['caption'] = 'DAFTAR CREDI MEMO';
$this->load->library('search_criteria');
$faa[] = criteria("Dari", "sid_date_from", "easyui-datetimebox");
$faa[] = criteria("S/d", "sid_date_to", "easyui-datetimebox");
$faa[] = criteria("Nomor BUkti", "sid_number");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 50, $order_column = 'sales_order_number', $order_type = 'asc')
{
$data['controller'] = $this->controller;
$data['fields_caption'] = array('Nomor Bukti', 'Tanggal', 'Jumlah', 'Faktur', 'Kode Cust', 'Nama Customer', 'Salesman', 'Kota', 'Gudang');
$data['fields'] = array('invoice_number', 'invoice_date', 'amount', 'your_order__', 'sold_to_customer', 'company', 'salesman', 'city', 'warehouse_code');
$data['field_key'] = 'invoice_number';
$data['caption'] = 'DAFTAR RETUR PENJUALAN';
$this->load->library('search_criteria');
$faa[] = criteria("Dari", "sid_date_from", "easyui-datetimebox");
$faa[] = criteria("S/d", "sid_date_to", "easyui-datetimebox");
$faa[] = criteria("Nomor", "sid_number");
$faa[] = criteria("Pelanggan", "sid_cust");
$faa[] = criteria("Salesman", "sid_salesman");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 50, $order_column = 'purchase_order_number', $order_type = 'asc')
{
$data['controller'] = $this->controller;
$data['fields_caption'] = array('Nomor Bukri', 'Tgl Bayar', 'Faktur', 'Tgl Faktur', 'Jenis', 'Jumlah Faktur', 'Jumlah Bayar', 'Kode Supplier', 'Nama Supplier', 'Kota', 'Line');
$data['fields'] = array('no_bukti', 'date_paid', 'purchase_order_number', 'po_date', 'how_paid', 'amount', 'amount_paid', 'supplier_number', 'supplier_name', 'city', 'line_number');
$data['field_key'] = 'no_bukti';
$data['caption'] = 'DAFTAR PEMBAYARAN FAKTUR PEMBELIAN';
$this->load->library('search_criteria');
$faa[] = criteria("Dari", "sid_date_from", "easyui-datetimebox");
$faa[] = criteria("S/d", "sid_date_to", "easyui-datetimebox");
$faa[] = criteria("Nomor", "no_bukti");
$faa[] = criteria("Faktur", "invoice_number");
$faa[] = criteria("Supplier", "sid_supplier");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function list_info($offset = 0)
{
if (isset($_GET['offset'])) {
$offset = $_GET['offset'];
}
$data['offset'] = $offset;
$this->load->library('search_criteria');
$faa[] = criteria("Kode Akun", "sid_no");
$faa[] = criteria("Nama Akun", "sid_nama");
$faa[] = criteria("Kelompok", "sid_kel");
$data['criteria'] = $faa;
$data['criteria_text'] = criteria_text($faa);
$data['sid_nama'] = $this->session->userdata('sid_nama');
$data['sid_kel'] = $this->session->userdata('sid_kel');
$data['sid_no'] = $this->session->userdata('sid_no');
$this->template->display_form_input('gl/info_list_coa', $data);
}
function browse($offset = 0, $limit = 50, $order_column = 'sales_order_number', $order_type = 'asc')
{
$data['controller'] = 'jobs';
$data['fields_caption'] = array('User Group', 'Nama User Group', 'Keterangan');
$data['fields'] = array('user_group_id', 'user_group_name', 'description');
$data['field_key'] = 'user_group_id';
$data['caption'] = 'DAFTAR USER JOB';
$this->load->library('search_criteria');
$faa[] = criteria("Nama user", "sid_nama");
$faa[] = criteria("Kelompok", "sid_kel");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 10, $order_column = 'loan_number', $order_type = 'asc')
{
$data['caption'] = 'DAFTAR PINJAMAN KARYAWAN';
$data['controller'] = 'payroll/pinjaman';
$data['fields_caption'] = array('Nomor', 'NIP', 'Nama Pegawai', 'Dept', 'Divisi', 'Tanggal', 'Jml Pinjaman', 'Jk Waktu', 'Jumlah');
$data['fields'] = array('loan_number', 'nip', 'nama', 'dept', 'divisi', 'loan_date', 'loan_amount', 'loan_count');
$data['field_key'] = 'loan_number';
$this->load->library('search_criteria');
$faa[] = criteria("Nomor", "sid_loan_number");
$faa[] = criteria("NIP", "sid_nip");
$faa[] = criteria("Nama", "sid_nama");
$faa[] = criteria("Dept", "sid_dept");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 10, $order_column = 'company', $order_type = 'asc')
{
$data['caption'] = 'DAFTAR MASTER PELANGGAN';
$data['controller'] = 'customer';
$data['fields_caption'] = array('Kode', 'Nama Pelanggan', 'Kota', 'Telp', 'Fax', 'Salesman', 'Kelompok');
$data['fields'] = array('customer_number', 'company', 'city', 'phone', 'fax', 'salesman', 'customer_record_type');
$data['field_key'] = 'customer_number';
$this->load->library('search_criteria');
$faa[] = criteria("Nama", "sid_cust");
$faa[] = criteria("Salesman", "sid_sales");
$faa[] = criteria("Kota", "sid_city");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 10, $order_column = 'company', $order_type = 'asc')
{
$data['caption'] = 'DAFTAR MASTER PEGAWAI';
$data['controller'] = 'employee';
$data['fields_caption'] = array('Kode', 'Nama Pegawai', 'Dept', 'Divisi', 'Jabatan', 'Kelompok');
$data['fields'] = array('nip', 'nama', 'dept', 'divisi', 'position', 'emptype');
$data['field_key'] = 'nip';
$this->load->library('search_criteria');
$faa[] = criteria("NIP", "sid");
$faa[] = criteria("Nama", "sid_nama");
$faa[] = criteria("Dept", "sid_dept");
$faa[] = criteria("Divisi", "sid_div");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 10, $order_column = 'company', $order_type = 'asc')
{
$data['caption'] = 'DAFTAR HARGA SATUAN BARANG';
$data['controller'] = 'inventory_prices';
$data['fields_caption'] = array('Kode Barang', 'Satuan', 'Harga Jual', 'From Qty', 'To Qty', 'From Date', 'To Date');
$data['fields'] = array('item_number', 'customer_pricing_code', 'retail', 'quantity_high', 'quantity_low', 'date_from', 'date_to');
$data['field_key'] = 'item_number';
$this->load->library('search_criteria');
$faa[] = criteria("Kode", "sid_kode");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 50, $order_column = 'mac_id', $order_type = 'asc')
{
$data['controller'] = $this->controller;
$data['fields_caption'] = array('Kode Mesin', 'Nama Mesin', 'Grup', 'Location', 'Kapasitas');
$data['fields'] = array('mac_id', 'mac_name', 'mac_group', 'location', 'capacity');
$data['field_key'] = 'mac_id';
$data['caption'] = 'DAFTAR KODE MESIN';
$this->load->library('search_criteria');
$faa[] = criteria("Kode", "sid_no");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 50, $order_column = 'sales_order_number', $order_type = 'asc')
{
$data['controller'] = $this->controller;
$data['fields_caption'] = array('Kode WOE', 'Kode WO', 'Start Date', 'Exp Date', 'Person', 'Comments');
$data['fields'] = array('work_exec_no', 'wo_number', 'start_date', 'expected_date', 'person_in_charge', 'comments');
$data['field_key'] = 'work_exec_no';
$data['caption'] = 'DAFTAR WORK ORDER EXEC';
$this->load->library('search_criteria');
$faa[] = criteria("Dari", "sid_date_from", "easyui-datetimebox");
$faa[] = criteria("S/d", "sid_date_to", "easyui-datetimebox");
$faa[] = criteria("Kode WOE", "sid_woe");
$faa[] = criteria("Kode WO", "sid_wo");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 10, $order_column = 'company', $order_type = 'asc')
{
$data['caption'] = 'DAFTAR KODE PTKP';
$data['controller'] = 'payroll/ptkp';
$data['fields_caption'] = array('Kode', 'Keterangan', 'Ptkp', 'Id');
$data['fields'] = array('kode', 'keterangan', 'jumlah');
$data['field_key'] = 'kode';
$this->load->library('search_criteria');
$faa[] = criteria("Kode", "sid");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 10, $order_column = 'shipment_id', $order_type = 'asc')
{
$data['caption'] = 'DAFTAR TRANSAKSI STOCK ADJUSTMENT';
$data['controller'] = 'stock_adjust';
$data['fields_caption'] = array('Nomor Bukti', 'Tanggal', 'Item Number', 'Description', 'Qty', 'Unit', 'Gudang', 'Keterangan');
$data['fields'] = array('shipment_id', 'date_received', 'item_number', 'description', 'quantity_received', 'unit', 'warehouse_code', 'comments');
$data['field_key'] = 'shipment_id';
$this->load->library('search_criteria');
$faa[] = criteria("Dari", "sid_date_from", "easyui-datetimebox");
$faa[] = criteria("S/d", "sid_date_to", "easyui-datetimebox");
$faa[] = criteria("Nomor", "sid_nomor");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 50, $order_column = 'sales_order_number', $order_type = 'asc')
{
$data['controller'] = $this->controller;
$data['fields_caption'] = array('Nomor Bukti', 'Tanggal', 'Jumlah', 'Rekening', 'Untuk', 'Jenis Transaksi', 'Nomor Giro', 'Keterangan', 'Trans Id');
$data['fields'] = array('voucher', 'check_date', 'payment_amount', 'account_number', 'payee', 'trans_type', 'check_number', 'memo', 'trans_id');
$data['field_key'] = 'voucher';
$data['caption'] = 'DAFTAR TRANSAKSI KAS/BANK KELUAR';
$this->load->library('search_criteria');
$faa[] = criteria("Dari", "sid_date_from", "easyui-datetimebox");
$faa[] = criteria("S/d", "sid_date_to", "easyui-datetimebox");
$faa[] = criteria("Nomor Bukti", "sid_number");
$faa[] = criteria("Rekening", "sid_rek");
$faa[] = criteria("Jenis", "sid_type");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 50, $order_column = "", $order_type = 'asc')
{
if ($order_column == "") {
$order_column = $this->primary_key;
}
$data['controller'] = $this->controller;
$data['fields'] = array("cust_name", "cust_id", "phone", "province", "city", "kec", "kel");
$data['fields_caption'] = array("Nama Customer", "Kode", "Telp", "Propinsi", "Kota", "Kecamatan", "Kelurahan");
$data['field_key'] = $this->primary_key;
$data['caption'] = $this->title;
$this->load->library('search_criteria');
$faa[] = criteria("Nama Debitur", "sid_nama");
$data['criteria'] = $faa;
$data['other_menu'] = "leasing/cust_master_menu";
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 50, $order_column = "", $order_type = 'asc')
{
if ($order_column == "") {
$order_column = $this->primary_key;
}
$data['controller'] = $this->controller;
$data['fields'] = array("cust_name", "loan_date", "loan_id", "loan_amount", "max_month", "inst_amount", "dealer_name", "dealer_id", "status");
$data['fields_caption'] = array("Pelanggan", "Tanggal", "Nomor Akad", "Jumlah", "Tenor", "Angsuran", "Counter", "Counter Id", "Status");
$data['fields_format_numeric'] = array("loan_amount", "inst_amount");
$data['field_key'] = $this->primary_key;
$data['caption'] = $this->title;
$this->load->library('search_criteria');
$faa[] = criteria("Nama Pelanggan", "sid_nama");
$data['criteria'] = $faa;
$data['other_menu'] = "leasing/loan_menu";
$this->template->display_browse2($data);
}
function list_info($offset = 0)
{
if (isset($_GET['offset'])) {
$offset = $_GET['offset'];
}
$data['offset'] = $offset;
$this->load->library('search_criteria');
$faa[] = criteria("Kode", "sid_kode");
$faa[] = criteria("Nama", "sid_nama");
$faa[] = criteria("Supplier", "sid_supp");
$faa[] = criteria("Kelompok", "sid_cat");
$data['criteria'] = $faa;
$data['criteria_text'] = criteria_text($faa);
$data['sid_kode'] = $this->session->userdata('sid_kode');
$data['sid_nama'] = $this->session->userdata('sid_nama');
$data['sid_supp'] = $this->session->userdata('sid_supp');
$data['sid_cat'] = $this->session->userdata('sid_cat');
$this->template->display_form_input('inventory/info_list', $data);
}
function browse($offset = 0, $limit = 50, $order_column = 'sales_order_number', $order_type = 'asc')
{
$data['controller'] = $this->controller;
$data['fields_caption'] = array('Nomor Bukti', 'Tanggal', 'Kode Akun', 'Nama Akun', 'Debit', 'Kredit', 'Source', 'Jenis', 'Ref', 'account_id', 'ID');
$data['fields'] = array('gl_id', 'date', 'account', 'account_description', 'debit', 'credit', 'source', 'operation', 'custsuppbank', 'account_id', 'transaction_id');
$data['field_key'] = 'gl_id';
$data['caption'] = 'DAFTAR TRANSAKSI JURNAL';
$data['export_visible'] = true;
$this->load->library('search_criteria');
$faa[] = criteria("Dari", "sid_date_from", "easyui-datetimebox");
$faa[] = criteria("S/d", "sid_date_to", "easyui-datetimebox");
$faa[] = criteria("Nomor Bukti", "sid_number");
$faa[] = criteria("Jenis", "sid_opr");
$faa[] = criteria("Only Not Balance", "sid_balance", "checkbox");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 10, $order_column = 'type_of_payment', $order_type = 'asc')
{
$data['caption'] = "DAFTAR TERMIN PEMBAYARAN";
$data['controller'] = 'type_of_payment';
$data['fields_caption'] = array('Termin Pembayaran', 'Discount%', 'Discount Day', 'Days');
$data['fields'] = array('type_of_payment', 'discount_percent', 'discount_days', 'days');
$data['field_key'] = 'type_of_payment';
$this->load->library('search_criteria');
$faa[] = criteria("Nama", "sid_type");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 10, $order_column = 'shipment_id', $order_type = 'asc')
{
$data['caption'] = 'DAFTAR PENERIMAAN BARANG ATAS NOMOR PURCHASE ORDER';
$data['controller'] = 'receive_po';
$data['fields_caption'] = array('Nomor Bukti', 'Tanggal', 'Nomor PO', 'Kode Supplier', 'Nama Supplier', 'Keterangan', '');
$data['fields'] = array('shipment_id', 'date_received', 'purchase_order_number', 'supplier_number', 'supplier_name', 'comments');
$data['field_key'] = 'shipment_id';
$this->load->library('search_criteria');
$faa[] = criteria("Dari", "sid_date_from", "easyui-datetimebox");
$faa[] = criteria("S/d", "sid_date_to", "easyui-datetimebox");
$faa[] = criteria("Nomor", "sid_nomor");
$faa[] = criteria("Supplier", "sid_supplier");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 50, $order_column = 'sales_order_number', $order_type = 'asc')
{
$data['controller'] = $this->controller;
$data['fields_caption'] = array('Kode', 'Nama Aktiva', 'Kelompok', 'Lokasi', 'Tgl Beli', 'Metode Susut', 'Waktu');
$data['fields'] = array('id', 'description', 'group_id', 'location_id', 'acquisition_date', 'depn_method', 'useful_lives');
$data['field_key'] = 'id';
$data['caption'] = 'DAFTAR AKTIVA TETAP';
$this->load->library('search_criteria');
$faa[] = criteria("Kode", "sid_number");
$faa[] = criteria("Nama", "sid_nama");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 10, $order_column = 'company', $order_type = 'asc')
{
$data['caption'] = 'DAFTAR KELAS BARANG DAN JASA';
$data['controller'] = 'inventory_class';
$data['fields_caption'] = array('Kode', 'Nama Kelas Barang/Jasa');
$data['fields'] = array('kode', 'class');
$data['field_key'] = 'kode';
$data['_form'] = $this->file_view;
$this->load->library('search_criteria');
$faa[] = criteria("Nama", "sid_nama");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 50, $order_column = 'purchase_order_number', $order_type = 'asc')
{
$data['controller'] = $this->controller;
$data['fields_caption'] = array('Nomor Bukti', 'Tanggal', 'Jumlah', 'Posted', 'Faktur', 'Kode Supplier', 'Nama Supplier', 'Kota', 'Gudang');
$data['fields'] = array('purchase_order_number', 'po_date', 'amount', 'posted', 'po_ref', 'supplier_number', 'supplier_name', 'city', 'warehouse_code');
$data['field_key'] = 'purchase_order_number';
$data['caption'] = 'DAFTAR PURCHASE RETUR';
$data['posting_visible'] = true;
$this->load->library('search_criteria');
$faa[] = criteria("Dari", "sid_date_from", "easyui-datetimebox");
$faa[] = criteria("S/d", "sid_date_to", "easyui-datetimebox");
$faa[] = criteria("Nomor BUkti", "sid_po_number");
$faa[] = criteria("Supplier", "sid_supplier");
$faa[] = criteria("Posted", "sid_posted");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 10, $order_column = 'company', $order_type = 'asc')
{
$data['caption'] = 'DAFTAR BIAYA TENAGA KERJA';
$data['controller'] = $this->controller;
$data['fields_caption'] = array('Kode', 'Nama Barang', 'Unit', 'Kelompok', 'Sub', 'Cost', 'Supplier');
$data['fields'] = array('item_number', 'description', 'unit_of_measure', 'category', 'sub_category', 'cost', 'supplier_name');
$data['field_key'] = 'item_number';
$this->load->library('search_criteria');
$faa[] = criteria("Kode", "sid_kode");
$faa[] = criteria("Nama", "sid_nama");
$faa[] = criteria("Kelompok", "sid_cat");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 50, $order_column = 'module_id', $order_type = 'asc')
{
$data['controller'] = 'modules';
$data['fields_caption'] = array('Kode', 'Nama Modul', 'Keterangan', 'Parent', 'Form Name', 'Type', 'No Urut');
$data['fields'] = array('module_id', 'module_name', 'description', 'parentid', 'form_name', 'type', 'sequence');
$data['field_key'] = 'module_id';
$data['caption'] = 'DAFTAR MODUL';
$this->load->library('search_criteria');
$faa[] = criteria("Nama Modul", "sid_nama");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 50, $order_column = "", $order_type = 'asc')
{
if ($order_column == "") {
$order_column = $this->primary_key;
}
$data['controller'] = $this->controller;
$data['fields'] = array("loan_id", "app_id", "loan_date", "loan_amount", "max_mount", "status", "cust_id");
$data['fields_caption'] = array("Kode", "AppId", "Tanggal", "Jumlah", "Tenor", "Status", "Pelanggan");
$data['field_key'] = $this->primary_key;
$data['caption'] = $this->title;
$this->load->library('search_criteria');
$faa[] = criteria("Nama Pelanggan", "sid_nama");
$data['criteria'] = $faa;
$this->template->display_browse2($data);
}
function browse($offset = 0, $limit = 50, $order_column = "", $order_type = 'asc')
{
if ($order_column == "") {
$order_column = $this->primary_key;
}
$data['controller'] = $this->controller;
$data['field_key'] = $this->primary_key;
$data['caption'] = $this->title;
$this->load->library('search_criteria');
$faa[] = criteria("Nomor Aplikasi", "sid_no", "", "style='width:400px'");
$faa[] = criteria("Nama Debitur", "sid_nama", "", "style='width:400px'");
$data['criteria'] = $faa;
$data['fields_caption'] = array('Nama Debitur', 'Nomor Aplikasi', 'Tanggal', 'Sales Agent', 'Id');
$data['fields'] = array('cust_name', 'app_id', 'app_date', 'sales_agent', 'id');
$this->template->display_browse2($data);
}