INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325060959181','input','1',' MEB1 5K LG','TOKO','PM-B','B1E-YJBC-266-0','GW MODEL BONEKA ANAK TAUGE CAT LG 8K ','','0.550','1','100.00','544000','0','0','15000','545000','0','5000','0','550000','SIN','00374584','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJBC-266-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='B1E-YJBC-266-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325060959181','2025-11-06','0.550','2025-11-06','09:59:19','PLG0025554','545000','545000','5000','550000','550000','input','2025-11-06 09:59:18','F32506095918');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F325060959181','2025-11-06','09:59:19','SIN','550000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251106-0002','D','2025-11-06','09:59:19','input','PENJUALAN','F325060959181','569427000','550000','569977000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325061015571','input','1',' MEF1 10K P','TOKO','PM-F','F1E-YCBA-263-0','GL ANAK BANGKOK HOLLOW LASER PM D42 8K','','2.150','1','100.00','2128000','0','0','15000','2128000','0','10000','0','2138000','AAT','00344640','F1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YCBA-263-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.150',berat_jual_asli=berat_jual_asli+'2.150',stock_jual='1',berat_akhir=berat_akhir-'2.150',berat_akhir_asli=berat_akhir_asli-'2.150',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='F1E-YCBA-263-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325061015571','2025-11-06','2.150','2025-11-06','10:15:57','PLG0025555','2128000','2128000','10000','2138000','2138000','input','2025-11-06 10:15:57','F32506101557');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F325061015571','2025-11-06','10:15:57','AAT','2138000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251106-0003','D','2025-11-06','10:15:57','input','PENJUALAN','F325061015571','569977000','2138000','572115000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2138000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325061015571' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325061015572','input',' 1',' MDE2 5K LG','TOKO','PM-E','E2D-YFAF-127-0','CC ANAK OSROT BONEKA CAT MATA VAR LG 8K ','','1.080','1','100.00','1048000','0','0','15000','1048000','0','5000','0','1053000','AAT','00357769','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YFAF-127-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='E2D-YFAF-127-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325061015572','2025-11-06','1.080','2025-11-06','10:15:57','PLG0025556','1048000','1048000','5000','1053000','1053000','input','2025-11-06 10:15:57','F32506101557');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F325061015572','2025-11-06','10:15:57','AAT','1053000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251106-0004','D','2025-11-06','10:15:57','input','PENJUALAN','F325061015572','572115000','1053000','573168000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1053000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325061015572' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325061045211','input','1',' MEH1 X UB ','TOKO','PM-H','H1E-YJXA-312-0','KL X NORY UB 44 8K ','','2.020','1','100.00','2000000','0','0','15000','2000000','0','0','0','2000000','SIN','00371557','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJXA-312-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='H1E-YJXA-312-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325061045211','2025-11-06','2.020','2025-11-06','10:45:21','PLG0025557','2000000','2000000','0','2000000','2000000','input','2025-11-06 10:45:21','F32506104521');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F325061045211','2025-11-06','10:45:21','SIN','2000000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251106-0005','D','2025-11-06','10:45:21','input','PENJUALAN','F325061045211','573168000','2000000','575168000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325061050071','input','1',' MED1E X LG','TOKO','PM-D','D1E-YKXC-366-0','LT X SLOBOK DAUN SLEP LG 8K ','','0.760','1','100.00','752000','0','0','15000','753000','0','0','0','753000','AAT','00376294','D1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YKXC-366-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='D1E-YKXC-366-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325061050071','2025-11-06','0.760','2025-11-06','10:50:08','PLG0025558','753000','753000','0','753000','753000','input','2025-11-06 10:50:07','F32506105007');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F325061050071','2025-11-06','10:50:08','AAT','753000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251106-0006','D','2025-11-06','10:50:08','input','PENJUALAN','F325061050071','575168000','753000','575921000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='753000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325061050071' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325061050072','input',' 1',' MDE1 CM 18','TOKO','PM-E','E1D-YJCX-79-0','CC MODEL SLEP CM 18 8K ','','1.360','1','100.00','1319000','0','0','15000','1320000','0','0','0','1320000','AAT','00375291','E1D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJCX-79-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.360',berat_jual_asli=berat_jual_asli+'1.360',stock_jual='1',berat_akhir=berat_akhir-'1.360',berat_akhir_asli=berat_akhir_asli-'1.360',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='E1D-YJCX-79-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325061050072','2025-11-06','1.360','2025-11-06','10:50:08','PLG0025559','1320000','1320000','0','1320000','1320000','input','2025-11-06 10:50:07','F32506105007');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F325061050072','2025-11-06','10:50:08','AAT','1320000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251106-0007','D','2025-11-06','10:50:08','input','PENJUALAN','F325061050072','575921000','1320000','577241000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1320000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325061050072' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017398','X-00017398','GL ANAK MODEL C TD D42 8K','GR','---','F1E','BELI','BELI001','2330000','2025-11-06','2.740','1','kasir','2025-11-06 11:07:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00017398','X-00017398');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251106-0001','F325170229451','AAT','1','BELI','BELI001','F1E', 'X-00017398', 'GL ANAK MODEL C TD D42 8K','2.740','2.740','100.00','2973000','2330000','850365','1000000','1','2330000','2330000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.740',berat_beli_asli=berat_beli_asli+'2.740',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.740',berat_akhir_asli=berat_akhir_asli+'2.740',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251106-0001','2025-11-06','2025-11-06','11:07:54','AAT','---','2.740','2330000','2330000','2330000','2330000','2330000','kasir','2025-11-06 11:07:54','FB-251106-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251106-0001','MIKAILA','DANGKRANG','','','','kasir','2025-11-06 11:07:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251106-0008','K','2025-11-06','11:07:54','kasir','PEMBELIAN UMUM','FB-251106-0001','577241000','2330000','574911000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325061109591','kasir','1',' MEF3E X YT','TOKO','PM-F','F3E-YJXB-234-0','GL X CAPELLA SLEP YT 8K ','','1.010','1','100.00','1000000','0','0','15000','1000000','0','0','0','1000000','SIN','00371818','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJXB-234-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='F3E-YJXB-234-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325061109591','2025-11-06','1.010','2025-11-06','11:10:00','PLG0025560','1000000','1000000','0','1000000','1000000','kasir','2025-11-06 11:09:59','F32506110959');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F325061109591','2025-11-06','11:10:00','SIN','1000000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251106-0009','D','2025-11-06','11:10:00','kasir','PENJUALAN','F325061109591','574911000','1000000','575911000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017399','X-00017399','KL VAR 9K','GR','---','H3J','BELI','BELI001','3700000','2025-11-06','4.870','1','kasir','2025-11-06 11:31:21');
DELETE FROM tp_barang WHERE kode_dept = 'X-H3J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H3J','X-00017399','X-00017399');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251106-0002','F321060137421','FIT','1','BELI','BELI001','H3J', 'X-00017399', 'KL VAR 9K','4.870','4.870','100.00','2207000','3700000','759754','1100000','1','3700000','3700000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.870',berat_beli_asli=berat_beli_asli+'4.870',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.870',berat_akhir_asli=berat_akhir_asli+'4.870',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H3J' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251106-0002','2025-11-06','2025-11-06','11:31:21','FIT','---','4.870','3700000','3700000','3700000','3700000','3700000','kasir','2025-11-06 11:31:21','FB-251106-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251106-0002','NOVITASARI','PURWANTORO','','','','kasir','2025-11-06 11:31:21');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251106-0010','K','2025-11-06','11:31:21','kasir','PEMBELIAN UMUM','FB-251106-0002','575911000','3700000','572211000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325061213301','kasir','1',' MEF1 XX UB','TOKO','PM-F','F1E-YGAX-20-0','GL XX OVAL C SLEP UB 54 8K ','','4.440','1','100.00','4396000','0','0','15000','4395000','0','0','0','4395000','SIN','00360414','F1E','0','0','-','1','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YGAX-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.440',berat_jual_asli=berat_jual_asli+'4.440',stock_jual='1',berat_akhir=berat_akhir-'4.440',berat_akhir_asli=berat_akhir_asli-'4.440',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='F1E-YGAX-20-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325061213301','2025-11-06','4.440','2025-11-06','12:13:30','PLG0025561','4395000','4395000','0','4395000','4395000','kasir','2025-11-06 12:13:30','F32506121330');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F325061213301','2025-11-06','12:13:30','SIN','4395000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251106-0011','D','2025-11-06','12:13:30','kasir','PENJUALAN','F325061213301','572211000','4395000','576606000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325061222251','kasir','1',' MDE2 10K C','TOKO','PM-E','E2D-YJBG-123-0','CC WEDDING MATA CM 14 8K ','','2.020','1','100.00','1959000','0','0','15000','1960000','0','10000','0','1970000','FIT','00374915','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJBG-123-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='E2D-YJBG-123-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325061222251','2025-11-06','2.020','2025-11-06','12:22:25','PLG0025562','1960000','1960000','10000','1970000','1970000','kasir','2025-11-06 12:22:25','F32506122225');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F325061222251','2025-11-06','12:22:25','FIT','1970000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251106-0012','D','2025-11-06','12:22:25','kasir','PENJUALAN','F325061222251','576606000','1970000','578576000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017400','X-00017400','CC X MODEL MATA LG 10 8K','GR','---','E2E','BELI','BELI001','380000','2025-11-06','0.500','1','kasir','2025-11-06 13:24:45');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00017400','X-00017400');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251106-0003','F325010305582','AAT','1','BELI','BELI001','E2E', 'X-00017400', 'CC X MODEL MATA LG 10 8K','0.500','0.500','100.00','408000','380000','760000','1000000','1','380000','380000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251106-0003','2025-11-06','2025-11-06','13:24:45','AAT','---','0.500','380000','380000','380000','380000','380000','kasir','2025-11-06 13:24:45','FB-251106-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251106-0003','ZAHRA','SENDANG PURWANTORO','','','','kasir','2025-11-06 13:24:45');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251106-0013','K','2025-11-06','13:24:45','kasir','PEMBELIAN UMUM','FB-251106-0003','578576000','380000','578196000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017401','X-00017401','KL X NORY ANAK UB 36 8K','GR','---','H1E','BELI','BELI001','627000','2025-11-06','0.900','1','kasir','2025-11-06 13:26:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00017401','X-00017401');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251106-0004','F325150206021','FIT','1','BELI','BELI001','H1E', 'X-00017401', 'KL X NORY ANAK UB 36 8K','0.900','0.900','100.00','743000','627000','696667','1000000','1','627000','627000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251106-0004','2025-11-06','2025-11-06','13:26:18','FIT','---','0.900','627000','627000','627000','627000','627000','kasir','2025-11-06 13:26:18','FB-251106-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251106-0004','ARA','BANGSRI','','','','kasir','2025-11-06 13:26:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251106-0014','K','2025-11-06','13:26:18','kasir','PEMBELIAN UMUM','FB-251106-0004','578196000','627000','577569000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017402','X-00017402','GL X BANGKOK TIMBUL SLEP UB 58 8K','GR','---','F1E','BELI','BELI001','8170000','2025-11-06','10.500','1','kasir','2025-11-06 13:27:11');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00017402','X-00017402');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251106-0005','F325121144091','AAT','1','BELI','BELI001','F1E', 'X-00017402', 'GL X BANGKOK TIMBUL SLEP UB 58 8K','10.500','10.500','100.00','8695000','8170000','778095','1000000','1','8170000','8170000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'10.500',berat_beli_asli=berat_beli_asli+'10.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'10.500',berat_akhir_asli=berat_akhir_asli+'10.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251106-0005','2025-11-06','2025-11-06','13:27:10','AAT','---','10.500','8170000','8170000','8170000','8170000','8170000','kasir','2025-11-06 13:27:11','FB-251106-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251106-0005','NEYZA','NGROMO NAWANGAN','','','','kasir','2025-11-06 13:27:11');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251106-0015','K','2025-11-06','13:27:10','kasir','PEMBELIAN UMUM','FB-251106-0005','577569000','8170000','569399000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017403','X-00017403','AT X TINDIK BABY MRICAN SG 17K','GR','---','A1TE','BELI','BELI001','730000','2025-11-06','0.470','1','kasir','2025-11-06 13:27:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1TE','X-00017403','X-00017403');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251106-0006','F325280856381','SIN','1','BELI','BELI001','A1TE', 'X-00017403', 'AT X TINDIK BABY MRICAN SG 17K','0.470','0.470','100.00','785000','730000','1553191','1780000','1','730000','730000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.470',berat_beli_asli=berat_beli_asli+'0.470',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.470',berat_akhir_asli=berat_akhir_asli+'0.470',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1TE' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251106-0006','2025-11-06','2025-11-06','13:27:30','SIN','---','0.470','730000','730000','730000','730000','730000','kasir','2025-11-06 13:27:31','FB-251106-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251106-0006','RARA','WATUBONANG BADEGAN','','','','kasir','2025-11-06 13:27:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251106-0016','K','2025-11-06','13:27:30','kasir','PEMBELIAN UMUM','FB-251106-0006','569399000','730000','568669000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017404','X-00017404','GL XX FLIK CAPELA VAR HW 17K','GR','---','F3TE','BELI','BELI001','2610000','2025-11-06','1.870','1','kasir','2025-11-06 13:28:39');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3TE','X-00017404','X-00017404');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251106-0007','F325071056431','AAT','1','BELI','BELI001','F3TE', 'X-00017404', 'GL XX FLIK CAPELA VAR HW 17K','1.870','1.870','100.00','2740000','2610000','1395722','1780000','1','2610000','2610000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.870',berat_beli_asli=berat_beli_asli+'1.870',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.870',berat_akhir_asli=berat_akhir_asli+'1.870',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3TE' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251106-0007','2025-11-06','2025-11-06','13:28:38','AAT','---','1.870','2610000','2610000','2610000','2610000','2610000','kasir','2025-11-06 13:28:39','FB-251106-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251106-0007','TRI','BANGSRI','','','','kasir','2025-11-06 13:28:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251106-0017','K','2025-11-06','13:28:38','kasir','PEMBELIAN UMUM','FB-251106-0007','568669000','2610000','566059000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017405','X-00017405','GW COR 8K','GR','---','B1F','BELI','BELI001','280000','2025-11-06','0.530','1','kasir','2025-11-06 13:30:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1F','X-00017405','X-00017405');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251106-0008','F323110226101','FIT','1','BELI','BELI001','B1F', 'X-00017405', 'GW COR 8K','0.530','0.530','100.00','245000','280000','528302','1020000','1','280000','280000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251106-0008','2025-11-06','2025-11-06','13:30:42','FIT','---','0.530','280000','280000','280000','280000','280000','kasir','2025-11-06 13:30:42','FB-251106-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251106-0008','FEBY','BITING','','','','kasir','2025-11-06 13:30:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251106-0018','K','2025-11-06','13:30:42','kasir','PEMBELIAN UMUM','FB-251106-0008','566059000','280000','565779000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251106-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251106-0004';
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017406','X-00017406','KL X NORY ANAK UB 36 8K','GR','---','H1E','BELI','BELI001','560000','2025-11-06','0.900','1','kasir','2025-11-06 13:46:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00017406','X-00017406');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251106-0009','F325150206021','AAT','1','BELI','BELI001','H1E', 'X-00017406', 'KL X NORY ANAK UB 36 8K','0.900','0.900','100.00','743000','560000','622222','1000000','1','560000','560000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251106-0009','2025-11-06','2025-11-06','13:46:29','AAT','---','0.900','560000','560000','560000','560000','560000','kasir','2025-11-06 13:46:30','FB-251106-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251106-0009','ARA','BANGSRI','','','','kasir','2025-11-06 13:46:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251106-0020','K','2025-11-06','13:46:29','kasir','PEMBELIAN UMUM','FB-251106-0009','566406000','560000','565846000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017407','X-00017407','GL X OVAL C YT 58 8K','GR','---','F1E','BELI','BELI001','3200000','2025-11-06','3.480','1','kasir','2025-11-06 13:46:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00017407','X-00017407');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251106-0010','F325020251311','AAT','1','BELI','BELI001','F1E', 'X-00017407', 'GL X OVAL C YT 58 8K','3.480','3.480','100.00','3445000','3200000','919540','1000000','1','3200000','3200000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.480',berat_beli_asli=berat_beli_asli+'3.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.480',berat_akhir_asli=berat_akhir_asli+'3.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251106-0010','2025-11-06','2025-11-06','13:46:46','AAT','---','3.480','3200000','3200000','3200000','3200000','3200000','kasir','2025-11-06 13:46:46','FB-251106-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251106-0010','BU KATINI','PAKIS BARU','','','','kasir','2025-11-06 13:46:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251106-0021','K','2025-11-06','13:46:46','kasir','PEMBELIAN UMUM','FB-251106-0010','565846000','3200000','562646000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325060150061','kasir','1',' TFH1 X UB ','TOKO','PT-H','H1TF-WLBF-123-T','KL X KOREA UB 40CM 17K ','','3.100','1','100.00','5580000','0','0','15000','5610000','0','0','0','5610000','SIN','T0052784','H1TF','0','0','-','0','1800000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TF-WLBF-123-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.100',berat_jual_asli=berat_jual_asli+'3.100',stock_jual='1',berat_akhir=berat_akhir-'3.100',berat_akhir_asli=berat_akhir_asli-'3.100',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='H1TF-WLBF-123-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325060150061','2025-11-06','3.100','2025-11-06','13:50:06','PLG0025563','5610000','5610000','0','5610000','5610000','kasir','2025-11-06 13:50:06','F32506015006');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F325060150061','2025-11-06','13:50:06','SIN','5610000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251106-0022','D','2025-11-06','13:50:06','kasir','PENJUALAN','F325060150061','562646000','5610000','568256000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5610000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325060150061' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325060150062','kasir',' 1',' MEA1 LG ','TOKO','PM-A','A1E-YGCX-202-0','AT JERSY MATA LG 8K ','','0.610','1','100.00','604000','0','0','15000','605000','0','0','0','605000','SIN','00363231','A1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YGCX-202-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='A1E-YGCX-202-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325060150062','2025-11-06','0.610','2025-11-06','13:50:06','PLG0025564','605000','605000','0','605000','605000','kasir','2025-11-06 13:50:06','F32506015006');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F325060150062','2025-11-06','13:50:06','SIN','605000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251106-0023','D','2025-11-06','13:50:06','kasir','PENJUALAN','F325060150062','568256000','605000','568861000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='605000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325060150062' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017408','X-00017408','LT MODEL HATI MATA LG','GR','---','D2TE','BELI','BELI001','895000','2025-11-06','0.650','1','kasir','2025-11-06 13:59:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2TE','X-00017408','X-00017408');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251106-0011','F325161115261','SIN','1','BELI','BELI001','D2TE', 'X-00017408', 'LT MODEL HATI MATA LG','0.650','0.650','100.00','972000','895000','1376923','1780000','1','895000','895000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.650',berat_beli_asli=berat_beli_asli+'0.650',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.650',berat_akhir_asli=berat_akhir_asli+'0.650',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2TE' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251106-0011','2025-11-06','2025-11-06','13:59:47','SIN','---','0.650','895000','895000','895000','895000','895000','kasir','2025-11-06 13:59:47','FB-251106-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251106-0011','SULASTRI','BAKALAN','','','','kasir','2025-11-06 13:59:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251106-0024','K','2025-11-06','13:59:47','kasir','PEMBELIAN UMUM','FB-251106-0011','568861000','895000','567966000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017409','X-00017409','AT X MODEL ARESO SLEP BW 8K','GR','---','A1F','BELI','BELI001','530000','2025-11-06','0.650','1','kasir','2025-11-06 14:00:45');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00017409','X-00017409');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251106-0012','F325300255451','SIN','1','BELI','BELI001','A1F', 'X-00017409', 'AT X MODEL ARESO SLEP BW 8K','0.650','0.650','100.00','565000','530000','815385','1020000','1','530000','530000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.650',berat_beli_asli=berat_beli_asli+'0.650',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.650',berat_akhir_asli=berat_akhir_asli+'0.650',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251106-0012','2025-11-06','2025-11-06','14:00:45','SIN','---','0.650','530000','530000','530000','530000','530000','kasir','2025-11-06 14:00:45','FB-251106-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251106-0012','SULASTRI','BAKALAN','','','','kasir','2025-11-06 14:00:45');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251106-0025','K','2025-11-06','14:00:45','kasir','PEMBELIAN UMUM','FB-251106-0012','567966000','530000','567436000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017410','X-00017410','KL X SANTA SEMI HW 50CM','GR','---','H1TF','BELI','BELI001','5545000','2025-11-06','3.900','1','kasir','2025-11-06 14:01:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1TF','X-00017410','X-00017410');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251106-0013','F325161115262','SIN','1','BELI','BELI001','H1TF', 'X-00017410', 'KL X SANTA SEMI HW 50CM','3.900','3.900','100.00','5898000','5545000','1421795','1800000','1','5545000','5545000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.900',berat_beli_asli=berat_beli_asli+'3.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.900',berat_akhir_asli=berat_akhir_asli+'3.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1TF' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251106-0013','2025-11-06','2025-11-06','14:01:54','SIN','---','3.900','5545000','5545000','5545000','5545000','5545000','kasir','2025-11-06 14:01:54','FB-251106-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251106-0013','SULASTRI','BAKALAN','','','','kasir','2025-11-06 14:01:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251106-0026','K','2025-11-06','14:01:54','kasir','PEMBELIAN UMUM','FB-251106-0013','567436000','5545000','561891000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017411','X-00017411','CC X MODEL MATA PM 20 8K','GR','---','E2D','BELI','BELI001','1110000','2025-11-06','1.450','1','kasir','2025-11-06 14:02:39');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017411','X-00017411');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251106-0014','F325221230221','FIT','1','BELI','BELI001','E2D', 'X-00017411', 'CC X MODEL MATA PM 20 8K','1.450','1.450','100.00','1195000','1110000','765517','980000','1','1110000','1110000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.450',berat_beli_asli=berat_beli_asli+'1.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.450',berat_akhir_asli=berat_akhir_asli+'1.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251106-0014','2025-11-06','2025-11-06','14:02:38','FIT','---','1.450','1110000','1110000','1110000','1110000','1110000','kasir','2025-11-06 14:02:39','FB-251106-0014');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251106-0014','NURIL','KISMANTORO','','','','kasir','2025-11-06 14:02:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251106-0027','K','2025-11-06','14:02:38','kasir','PEMBELIAN UMUM','FB-251106-0014','561891000','1110000','560781000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325060209421','kasir','1',' MDE2 X LG ','TOKO','PM-E','E2D-YEBG-23-0','CC X EROPA ANAK MATA LG 8K ','','1.010','1','100.00','980000','0','0','15000','980000','0','0','0','980000','SIN','00355577','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YEBG-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='E2D-YEBG-23-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325060209421','2025-11-06','1.010','2025-11-06','14:09:43','PLG0025565','980000','980000','0','980000','980000','kasir','2025-11-06 14:09:42','F32506020942');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F325060209421','2025-11-06','14:09:43','SIN','980000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251106-0028','D','2025-11-06','14:09:43','kasir','PENJUALAN','F325060209421','560781000','980000','561761000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='980000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325060209421' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F325060209422','kasir',' 1',' MDE2 X YT ','TOKO','PM-E','E2D-YIAC-217-0','CC X MODEL MATA YT 12 8K ','','1.060','1','100.00','1028000','0','0','15000','1030000','0','0','0','1030000','SIN','00369301','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIAC-217-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2025-11-06' AND kode_barang='E2D-YIAC-217-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F325060209422','2025-11-06','1.060','2025-11-06','14:09:43','PLG0025566','1030000','1030000','0','1030000','1030000','kasir','2025-11-06 14:09:42','F32506020942');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-06','F325060209422','2025-11-06','14:09:43','SIN','1030000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251106-0029','D','2025-11-06','14:09:43','kasir','PENJUALAN','F325060209422','561761000','1030000','562791000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1030000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325060209422' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00017412','X-00017412','CC X SOLITAIRE MATA BM 12 8K','GR','---','E2D','BELI','BELI001','625000','2025-11-06','1.030','1','kasir','2025-11-06 14:48:49');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017412','X-00017412');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251106-0015','F324171204061','SIN','1','BELI','BELI001','E2D', 'X-00017412', 'CC X SOLITAIRE MATA BM 12 8K','1.030','1.030','100.00','650000','625000','606796','980000','1','625000','625000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.030',berat_beli_asli=berat_beli_asli+'1.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.030',berat_akhir_asli=berat_akhir_asli+'1.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251106-0015','2025-11-06','2025-11-06','14:48:48','SIN','---','1.030','625000','625000','625000','625000','625000','kasir','2025-11-06 14:48:49','FB-251106-0015');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251106-0015','EVI','PLOSO','','','','kasir','2025-11-06 14:48:49');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251106-0030','K','2025-11-06','14:48:48','kasir','PEMBELIAN UMUM','FB-251106-0015','562791000','625000','562166000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251106-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251106-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251106-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251106-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251106-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251106-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251106-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251106-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251106-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251106-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251106-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251106-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251106-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251106-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251106-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251106-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251106-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251106-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251106-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251106-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251106-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251106-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251106-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251106-0013';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251106-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251106-0014';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251106-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251106-0015';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325060150061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325060150061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325060150061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325060150062' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325060150062' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325060150062';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325060209421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325060209421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325060209421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325060209422' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325060209422' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325060209422';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325060959181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325060959181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325060959181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061015571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061015571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061015571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061015572' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061015572' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061015572';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061045211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061045211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061045211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061050071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061050071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061050071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061050072' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061050072' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061050072';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061109591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061109591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061109591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061213301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061213301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061213301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061222251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061222251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061222251';
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251106-0001','1','B1F-YIBB-125-0','1','0.400','0.400','TOKO','PM-B','TOKO','SBK-B');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SBK-B' WHERE kode_barang='B1F-YIBB-125-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-B';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-11-06','TOKO','SBK-B','B1F','B1F-YIBB-125-0','100.00','1','0.400','0.400','1','0.400','0.400');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.400',berat_out_asli=berat_out_asli+'0.400',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-06' AND kode_barang='B1F-YIBB-125-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251106-0001','2025-11-06','2025-11-06','15:19','0.4','input','2025-11-06 15:20:14');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-07','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-07';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-06';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-06';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-11-06' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-06';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-06';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-06';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-06';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-07' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-06' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251107-0001','D','2025-11-07','15:29:25','SYSTEM','SALDO AWAL','SALDO AWAL','0','562166000','562166000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251107-0001','D','2025-11-07','15:29:25','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251107-0001','D','2025-11-07','15:29:25','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251107-0001','D','2025-11-07','15:29:25','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
UPDATE tp_system SET tgl_system='2025-11-07';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251107-0001','1','B1F-YIBB-125-0','1','0.400','TOKO','SBK-B');
DELETE FROM tm_barang_export WHERE kode_barang='B1F-YIBB-125-0' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='B1F-YIBB-125-0' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_group_export WHERE kode_group='MF' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_group_export SELECT * FROM tm_group WHERE kode_group='MF' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_dept_export WHERE kode_dept='B1F' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='B1F' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBK-B';
INSERT INTO db_nagagold_dewigold2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBK-B';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='B1F-YIBB-125-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.400',berat_out_asli='0.400', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.400',berat_akhir_asli =berat_akhir_asli-'0.400' WHERE kode_barang='B1F-YIBB-125-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-251107-0001','2025-11-07','2025-11-07','16:19','0.400','admpindah','251107');