Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -----------------
- Identifiaksi menu
- =================
- -Kategori Biaya
- -Kode Biaya
- -Barang Golongan
- -Barang Kelas
- -Barang Jenis
- -Barang Satuan
- -Barang Tipe
- -Barang Item
- -Gudang Lokasi
- -User
- -Role
- -Grup
- ?dari bdp_item_request ke-> bdp_purchase_request. (kedua menu tersebut, merequest item)
- !dari bdp_stok_opname ke-> bdp_stok_opname_approval. (muncul item barang yg akan di approve(po_barang))
- !dari po_barang ke-> bdp_warehouse_stock/gudang stok (tambah item->mucul di gudang stok)
- function table();
- function get_option_data($table, $key , $val , $where = '',$empty = false, $kosong = false, $val2 = '')
- $this->_po_barang = get_option_data('tm_po_barang', 'id_tm_po_barang', 'kode_tm_po_barang',[],true, 'nama_tm_po_barang');
- foreach ($list as $key => $val) {
- $list[$key]->kode= "$val->kode $val->nama";
- }
- IT, minta buku minta komputer(beda vendor/beda nomer po).
- 07601
- ROLE
- ====
- role => (Nama Role->button pilihan menu)
- --------
- id_role,
- nama_role;
- role_master => (Nama Role/Menu Role);
- --------------
- id_role_master,
- nama_role_master,
- menu_role_master,
- dihapus_role_master,
- dibuat_oleh_role_master,
- dibuat_saat_role_master,
- diperbarui_oleh_role_master,
- diperbarui_saat_role_master;
- role_permission =>
- ------------------
- id_rolep
- role_id
- menu_rolep
- view_rolep
- add_rolep
- edit_rolep
- del_rolep
- join table barang dan warehose_stok(stok barang);
- SELECT id_tm_bdp_gudang_stok, tm_po_barang.kode_tm_po_barang, tm_po_barang.nama_tm_po_barang, jumlah_tm_bdp_gudang_stok
- FROM po_budgeting.tm_bdp_gudang_stok
- JOIN tm_po_barang on tm_bdp_gudang_stok.barang_id_tm_bdp_gudang_stok = tm_po_barang.id_tm_po_barang
- WHERE kode_tm_po_barang =007601;
- kode tester po_barang
- 00001 bindex bambi
Advertisement
Add Comment
Please, Sign In to add comment