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 ('F325270753491','input','1',' MEE1 X CM ','TOKO','PM-E','E1E-VHXI-282-0','CC X POLOS CM 17 ','','1.450','1','100.00','1472000','0','0','15000','1473000','0','0','0','1473000','SIN','00181225','E1E','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-VHXI-282-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.450',berat_jual_asli=berat_jual_asli+'1.450',stock_jual='1',berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='E1E-VHXI-282-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 ('F325270753491','2025-11-27','1.450','2025-11-27','07:53:49','PLG0025879','1473000','1473000','0','1473000','1473000','input','2025-11-27 07:53:49','F32527075349');
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-27','F325270753491','2025-11-27','07:53:49','SIN','1473000','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-251127-0002','D','2025-11-27','07:53:49','input','PENJUALAN','F325270753491','857176000','1473000','858649000');
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 ('F325270756421','input','1',' MEF2 10K P','TOKO','PM-F','F2E-YCBA-281-0','GL PIPA MODEL MATA SLEP VAR PM D56 8K ','','4.980','1','100.00','5055000','0','0','15000','5055000','0','10000','0','5065000','AAT','00344658','F2E','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YCBA-281-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.980',berat_jual_asli=berat_jual_asli+'4.980',stock_jual='1',berat_akhir=berat_akhir-'4.980',berat_akhir_asli=berat_akhir_asli-'4.980',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='F2E-YCBA-281-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 ('F325270756421','2025-11-27','4.980','2025-11-27','07:56:43','PLG0025880','5055000','5055000','10000','5065000','5065000','input','2025-11-27 07:56:42','F32527075642');
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-27','F325270756421','2025-11-27','07:56:43','AAT','5065000','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-251127-0003','D','2025-11-27','07:56:43','input','PENJUALAN','F325270756421','858649000','5065000','863714000');
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 ('F325270846171','input','1',' MEF3 HW ','TOKO','PM-F','F3E-YJCX-51-0','GL RANTAI HOLLOW FLIK VAR HW 8K ','','1.370','1','100.00','1391000','0','0','15000','1390000','0','0','0','1390000','FIT','00375263','F3E','0','0','-','1','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJCX-51-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.370',berat_jual_asli=berat_jual_asli+'1.370',stock_jual='1',berat_akhir=berat_akhir-'1.370',berat_akhir_asli=berat_akhir_asli-'1.370',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='F3E-YJCX-51-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 ('F325270846171','2025-11-27','1.370','2025-11-27','08:46:18','PLG0025881','1390000','1390000','0','1390000','1390000','input','2025-11-27 08:46:17','F32527084617');
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-27','F325270846171','2025-11-27','08:46:18','FIT','1390000','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-251127-0004','D','2025-11-27','08:46:18','input','PENJUALAN','F325270846171','863714000','1390000','865104000');
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 ('F325270901221','input','1',' MED2 X LG ','TOKO','PM-D','D2E-YJXA-75-0','LT X MODEL HURUF MATA LG Y 8K ','','0.460','1','100.00','467000','0','0','15000','467000','0','0','0','467000','FIT','00371320','D2E','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YJXA-75-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='D2E-YJXA-75-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 ('F325270901221','2025-11-27','0.460','2025-11-27','09:01:23','PLG0025882','467000','467000','0','467000','467000','input','2025-11-27 09:01:22','F32527090122');
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-27','F325270901221','2025-11-27','09:01:23','FIT','467000','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-251127-0005','D','2025-11-27','09:01:23','input','PENJUALAN','F325270901221','865104000','467000','865571000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='467000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325270901221' 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 ('F325270901222','input',' 1',' MJH2 X UB ','TOKO','PM-H','H2J-YJXA-300-0','KL X GUCCI ANAK UB 34 9K ','','1.310','1','100.00','1461000','0','0','15000','1461000','0','0','0','1461000','FIT','00371545','H2J','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YJXA-300-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.310',berat_jual_asli=berat_jual_asli+'1.310',stock_jual='1',berat_akhir=berat_akhir-'1.310',berat_akhir_asli=berat_akhir_asli-'1.310',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='H2J-YJXA-300-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 ('F325270901222','2025-11-27','1.310','2025-11-27','09:01:23','PLG0025883','1461000','1461000','0','1461000','1461000','input','2025-11-27 09:01:22','F32527090122');
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-27','F325270901222','2025-11-27','09:01:23','FIT','1461000','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-251127-0006','D','2025-11-27','09:01:23','input','PENJUALAN','F325270901222','865571000','1461000','867032000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1461000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325270901222' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325270901222' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325270901222' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325270901222';
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 ('F325270906461','kasir','1',' MJH2 X UB ','TOKO','PM-H','H2J-YJXA-300-0','KL X GUCCI ANAK UB 34 9K ','','1.310','1','100.00','1461000','0','0','15000','1461000','0','0','0','1461000','FIT','00371545','H2J','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YJXA-300-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.310',berat_jual_asli=berat_jual_asli+'1.310',stock_jual='1',berat_akhir=berat_akhir-'1.310',berat_akhir_asli=berat_akhir_asli-'1.310',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='H2J-YJXA-300-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 ('F325270906461','2025-11-27','1.310','2025-11-27','09:06:47','PLG0025884','1461000','1461000','0','1461000','1461000','kasir','2025-11-27 09:06:46','F32527090646');
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-27','F325270906461','2025-11-27','09:06:47','FIT','1461000','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-251127-0008','D','2025-11-27','09:06:47','kasir','PENJUALAN','F325270906461','865571000','1461000','867032000');
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 ('F325270935301','kasir','1',' MDE1 CM 20','TOKO','PM-E','E1D-YKAG-86-T','CC MODEL DAUN VAR CM 20 8K ','','1.170','1','100.00','1164000','0','0','15000','1165000','0','0','0','1165000','SIN','T0075089','E1D','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YKAG-86-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.170',berat_jual_asli=berat_jual_asli+'1.170',stock_jual='1',berat_akhir=berat_akhir-'1.170',berat_akhir_asli=berat_akhir_asli-'1.170',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='E1D-YKAG-86-T' 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 ('F325270935301','2025-11-27','1.170','2025-11-27','09:35:31','PLG0025885','1165000','1165000','0','1165000','1165000','kasir','2025-11-27 09:35:30','F32527093530');
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-27','F325270935301','2025-11-27','09:35:31','SIN','1165000','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-251127-0009','D','2025-11-27','09:35:31','kasir','PENJUALAN','F325270935301','867032000','1165000','868197000');
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 ('F325270949331','kasir','1',' MEF3E X LT','TOKO','PM-F','F3E-YBAE-341-0','GL X TIFF CAPELLA SLEP LT 8K ','','2.100','1','100.00','2131000','0','0','15000','2130000','0','0','0','2130000','SIN','00339401','F3E','0','0','-','1','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YBAE-341-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='F3E-YBAE-341-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 ('F325270949331','2025-11-27','2.100','2025-11-27','09:49:33','PLG0025886','2130000','2130000','0','2130000','2130000','kasir','2025-11-27 09:49:33','F32527094933');
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-27','F325270949331','2025-11-27','09:49:33','SIN','2130000','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-251127-0010','D','2025-11-27','09:49:33','kasir','PENJUALAN','F325270949331','868197000','2130000','870327000');
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 ('F325271004261','kasir','1',' MEF1 PM 40','TOKO','PM-F','F1E-YKBF-162-0','GL PIPA DAUN ANAK SLEP PM 40 8K ','','2.070','1','100.00','2122000','0','0','15000','2100000','0','0','0','2100000','SIN','00378834','F1E','0','0','-','1','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YKBF-162-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='F1E-YKBF-162-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 ('F325271004261','2025-11-27','2.070','2025-11-27','10:04:27','PLG0025887','2100000','2100000','0','2100000','2100000','kasir','2025-11-27 10:04:26','F32527100426');
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-27','F325271004261','2025-11-27','10:04:27','SIN','2100000','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-251127-0011','D','2025-11-27','10:04:27','kasir','PENJUALAN','F325271004261','870327000','2100000','872427000');
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 ('F325271005411','kasir','1',' MEF1 PM 40','TOKO','PM-F','F1E-YKBF-163-0','GL PIPA DAUN ANAK SLEP PM 40 8K ','','2.100','1','100.00','2152000','0','0','15000','2130000','0','0','0','2130000','SIN','00378835','F1E','0','0','-','1','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YKBF-163-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='F1E-YKBF-163-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 ('F325271005411','2025-11-27','2.100','2025-11-27','10:05:41','PLG0025888','2130000','2130000','0','2130000','2130000','kasir','2025-11-27 10:05:41','F32527100541');
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-27','F325271005411','2025-11-27','10:05:41','SIN','2130000','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-251127-0012','D','2025-11-27','10:05:41','kasir','PENJUALAN','F325271005411','872427000','2130000','874557000');
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-00017543','X-00017543','CC MODEL MATA MG 20 8K','GR','---','E2D','BELI','BELI001','750000','2025-11-27','1.000','1','kasir','2025-11-27 10:18:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00017543','X-00017543');
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-251127-0001','F325060944211','AAT','1','BELI','BELI001','E2D', 'X-00017543', 'CC MODEL MATA MG 20 8K','1.000','1.000','100.00','816000','750000','750000','1005000','1','750000','750000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-27' 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-251127-0001','2025-11-27','2025-11-27','10:18:33','AAT','---','1.000','750000','750000','750000','750000','750000','kasir','2025-11-27 10:18:34','FB-251127-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251127-0001','ANGGI','PENGGUNG NAWANGAN','','','','kasir','2025-11-27 10:18:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-27' 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-251127-0013','K','2025-11-27','10:18:33','kasir','PEMBELIAN UMUM','FB-251127-0001','874557000','750000','873807000');
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-00017544','X-00017544','CC MODEL SLEP VAR HW 17 8K','GR','---','E1E','BELI','BELI001','540000','2025-11-27','0.650','1','kasir','2025-11-27 10:19:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00017544','X-00017544');
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-251127-0002','F325131030401','AAT','1','BELI','BELI001','E1E', 'X-00017544', 'CC MODEL SLEP VAR HW 17 8K','0.650','0.650','100.00','582000','540000','830769','1025000','1','540000','540000','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-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-251127-0002','2025-11-27','2025-11-27','10:19:05','AAT','---','0.650','540000','540000','540000','540000','540000','kasir','2025-11-27 10:19:06','FB-251127-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251127-0002','DYAH','TALESAN','','','','kasir','2025-11-27 10:19:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-27' 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-251127-0014','K','2025-11-27','10:19:05','kasir','PEMBELIAN UMUM','FB-251127-0002','873807000','540000','873267000');
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-00017545','X-00017545','GL X SANTA ARESO SERUT UB 8K','GR','---','F3E','BELI','BELI001','1270000','2025-11-27','1.530','1','kasir','2025-11-27 10:20:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017545','X-00017545');
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-251127-0003','F325050848562','FIT','1','BELI','BELI001','F3E', 'X-00017545', 'GL X SANTA ARESO SERUT UB 8K','1.650','1.530','100.00','1605000','1270000','830065','1025000','1','1270000','1270000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.530',berat_beli_asli=berat_beli_asli+'1.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.530',berat_akhir_asli=berat_akhir_asli+'1.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' 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-251127-0003','2025-11-27','2025-11-27','10:20:02','FIT','---','1.530','1270000','1270000','1270000','1270000','1270000','kasir','2025-11-27 10:20:02','FB-251127-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251127-0003','ANGGRAENI','JERUK PACITAN','','','081249540178','kasir','2025-11-27 10:20:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-27' 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-251127-0015','K','2025-11-27','10:20:02','kasir','PEMBELIAN UMUM','FB-251127-0003','873267000','1270000','871997000');
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 ('F325271022431','kasir','1',' MDE2 X BM ','TOKO','PM-E','E2D-YIBD-382-0','CC X MODEL MATA BM 16 8K ','','0.930','1','100.00','925000','0','0','15000','925000','0','0','0','925000','SIN','00370803','E2D','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIBD-382-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.930',berat_jual_asli=berat_jual_asli+'0.930',stock_jual='1',berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='E2D-YIBD-382-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 ('F325271022431','2025-11-27','0.930','2025-11-27','10:22:44','PLG0025889','925000','925000','0','925000','925000','kasir','2025-11-27 10:22:43','F32527102243');
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-27','F325271022431','2025-11-27','10:22:44','SIN','925000','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-251127-0016','D','2025-11-27','10:22:44','kasir','PENJUALAN','F325271022431','871997000','925000','872922000');
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 ('F325271023391','kasir','1',' MEE1 X HW ','TOKO','PM-E','E1E-YKAA-311-0','CC X MODEL GELOMBANG CAT HW 17 8K ','','0.710','1','100.00','721000','0','0','15000','720000','0','0','0','720000','SIN','00377277','E1E','0','0','-','1','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YKAA-311-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.710',berat_jual_asli=berat_jual_asli+'0.710',stock_jual='1',berat_akhir=berat_akhir-'0.710',berat_akhir_asli=berat_akhir_asli-'0.710',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='E1E-YKAA-311-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 ('F325271023391','2025-11-27','0.710','2025-11-27','10:23:39','PLG0025890','720000','720000','0','720000','720000','kasir','2025-11-27 10:23:39','F32527102339');
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-27','F325271023391','2025-11-27','10:23:39','SIN','720000','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-251127-0017','D','2025-11-27','10:23:39','kasir','PENJUALAN','F325271023391','872922000','720000','873642000');
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 ('F325271030511','kasir','1',' MIF4I X KH','TOKO','PM-F','F4I-YKBF-35-0','GL X KOREA SLEP KH 9K ','','1.120','1','100.00','1238000','0','0','15000','1225000','0','0','0','1225000','FIT','00378707','F4I','0','0','-','1','1105000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F4I-YKBF-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='F4I-YKBF-35-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 ('F325271030511','2025-11-27','1.120','2025-11-27','10:30:51','PLG0025891','1225000','1225000','0','1225000','1225000','kasir','2025-11-27 10:30:51','F32527103051');
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-27','F325271030511','2025-11-27','10:30:51','FIT','1225000','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-251127-0018','D','2025-11-27','10:30:51','kasir','PENJUALAN','F325271030511','873642000','1225000','874867000');
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 ('F325271033381','kasir','1',' MEE2 HT 14','TOKO','PM-E','E2E-YKBB-46-0','CC PIPA MATA HT 14 8K ','','0.500','1','100.00','507000','0','0','15000','508000','0','0','0','508000','SIN','00378195','E2E','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YKBB-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='E2E-YKBB-46-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 ('F325271033381','2025-11-27','0.500','2025-11-27','10:33:38','PLG0025892','508000','508000','0','508000','508000','kasir','2025-11-27 10:33:38','F32527103338');
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-27','F325271033381','2025-11-27','10:33:38','SIN','508000','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-251127-0019','D','2025-11-27','10:33:38','kasir','PENJUALAN','F325271033381','874867000','508000','875375000');
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-00017546','X-00017546','GL X SHOGUN SLEP NJ 54','GR','---','F1E','BELI','BELI001','7890000','2025-11-27','9.970','1','kasir','2025-11-27 10:35:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00017546','X-00017546');
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-251127-0004','F325051143371','AAT','1','BELI','BELI001','F1E', 'X-00017546', 'GL X SHOGUN SLEP NJ 54','9.970','9.970','100.00','8395000','7890000','791374','1025000','1','7890000','7890000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'9.970',berat_beli_asli=berat_beli_asli+'9.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'9.970',berat_akhir_asli=berat_akhir_asli+'9.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-27' 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-251127-0004','2025-11-27','2025-11-27','10:35:17','AAT','---','9.970','7890000','7890000','7890000','7890000','7890000','kasir','2025-11-27 10:35:17','FB-251127-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251127-0004','SURYATI','BANDAR PACITAN','','','','kasir','2025-11-27 10:35:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-27' 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-251127-0020','K','2025-11-27','10:35:17','kasir','PEMBELIAN UMUM','FB-251127-0004','875375000','7890000','867485000');
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 ('F325271038241','kasir','1',' MJH2 X UB ','TOKO','PM-H','H2J-YJAC-111-0','KL X GUCCI ANAK UB 34 9K ','','1.930','1','100.00','2152000','0','0','15000','2153000','0','0','0','2153000','AAT','00372841','H2J','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YJAC-111-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.930',berat_jual_asli=berat_jual_asli+'1.930',stock_jual='1',berat_akhir=berat_akhir-'1.930',berat_akhir_asli=berat_akhir_asli-'1.930',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='H2J-YJAC-111-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 ('F325271038241','2025-11-27','1.930','2025-11-27','10:38:25','PLG0025893','2153000','2153000','0','2153000','2153000','kasir','2025-11-27 10:38:24','F32527103824');
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-27','F325271038241','2025-11-27','10:38:25','AAT','2153000','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-251127-0021','D','2025-11-27','10:38:25','kasir','PENJUALAN','F325271038241','867485000','2153000','869638000');
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 ('F325271040241','kasir','1',' MDE1 HW 15','TOKO','PM-E','E1D-YKBB-44-0','CC MODEL SLEP HW 15 8K ','','0.800','1','100.00','796000','0','0','15000','795000','0','0','0','795000','SIN','00378193','E1D','0','0','-','1','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YKBB-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='E1D-YKBB-44-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 ('F325271040241','2025-11-27','0.800','2025-11-27','10:40:24','PLG0025894','795000','795000','0','795000','795000','kasir','2025-11-27 10:40:24','F32527104024');
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-27','F325271040241','2025-11-27','10:40:24','SIN','795000','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-251127-0022','D','2025-11-27','10:40:24','kasir','PENJUALAN','F325271040241','869638000','795000','870433000');
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 ('F325271058541','kasir','1',' MDB1 X CM ','TOKO','PM-B','B1D-YFBX-49-0','GW X MODEL MATA CM PE 8K ','','1.010','1','100.00','1005000','0','0','15000','1005000','0','0','0','1005000','SIN','00358134','B1D','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-YFBX-49-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-27' AND kode_barang='B1D-YFBX-49-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 ('F325271058541','2025-11-27','1.010','2025-11-27','10:58:54','PLG0025895','1005000','1005000','0','1005000','1005000','kasir','2025-11-27 10:58:54','F32527105854');
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-27','F325271058541','2025-11-27','10:58:54','SIN','1005000','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-251127-0023','D','2025-11-27','10:58:54','kasir','PENJUALAN','F325271058541','870433000','1005000','871438000');
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 ('F325271109401','kasir','1',' MEE1 LG 14','TOKO','PM-E','E1E-YJCX-95-0','CC MODEL SLEP LG 14 8K ','','0.430','1','100.00','436000','0','0','15000','435000','0','0','0','435000','SIN','00375307','E1E','0','0','-','1','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJCX-95-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='E1E-YJCX-95-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 ('F325271109401','2025-11-27','0.430','2025-11-27','11:09:40','PLG0025896','435000','435000','0','435000','435000','kasir','2025-11-27 11:09:40','F32527110940');
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-27','F325271109401','2025-11-27','11:09:40','SIN','435000','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-251127-0024','D','2025-11-27','11:09:40','kasir','PENJUALAN','F325271109401','871438000','435000','871873000');
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 ('F325271118441','kasir','1',' MFH1 X HW ','TOKO','PM-H','H1F-XFBH-192-0','KL X TRIXIE MATA VAR HW 8K ','','2.950','1','100.00','3053000','0','0','15000','3055000','0','0','0','3055000','SIN','00305023','H1F','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-XFBH-192-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.950',berat_jual_asli=berat_jual_asli+'2.950',stock_jual='1',berat_akhir=berat_akhir-'2.950',berat_akhir_asli=berat_akhir_asli-'2.950',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='H1F-XFBH-192-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 ('F325271118441','2025-11-27','2.950','2025-11-27','11:18:45','PLG0025897','3055000','3055000','0','3055000','3055000','kasir','2025-11-27 11:18:44','F32527111844');
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-27','F325271118441','2025-11-27','11:18:45','SIN','3055000','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-251127-0025','D','2025-11-27','11:18:45','kasir','PENJUALAN','F325271118441','871873000','3055000','874928000');
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 ('F325271119431','kasir','1',' MEF2 X UB ','TOKO','PM-F','F2E-YIAE-172-0','GL X PIPA MATA UB 56 8K ','','5.030','1','100.00','5105000','0','0','15000','5105000','0','0','0','5105000','FIT','00369623','F2E','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YIAE-172-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.030',berat_jual_asli=berat_jual_asli+'5.030',stock_jual='1',berat_akhir=berat_akhir-'5.030',berat_akhir_asli=berat_akhir_asli-'5.030',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='F2E-YIAE-172-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 ('F325271119431','2025-11-27','5.030','2025-11-27','11:19:43','PLG0025898','5105000','5105000','0','5105000','5105000','kasir','2025-11-27 11:19:43','F32527111943');
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-27','F325271119431','2025-11-27','11:19:43','FIT','5105000','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-251127-0026','D','2025-11-27','11:19:43','kasir','PENJUALAN','F325271119431','874928000','5105000','880033000');
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 ('F325271120061','kasir','1',' MEF2 10K P','TOKO','PM-F','F2E-YCBA-280-0','GL PIPA MODEL MATA SLEP VAR PM D56 8K ','','4.900','1','100.00','4973000','0','0','15000','4973000','0','10000','0','4983000','FIT','00344657','F2E','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YCBA-280-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.900',berat_jual_asli=berat_jual_asli+'4.900',stock_jual='1',berat_akhir=berat_akhir-'4.900',berat_akhir_asli=berat_akhir_asli-'4.900',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='F2E-YCBA-280-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 ('F325271120061','2025-11-27','4.900','2025-11-27','11:20:07','PLG0025899','4973000','4973000','10000','4983000','4983000','kasir','2025-11-27 11:20:06','F32527112006');
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-27','F325271120061','2025-11-27','11:20:07','FIT','4983000','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-251127-0027','D','2025-11-27','11:20:07','kasir','PENJUALAN','F325271120061','880033000','4983000','885016000');
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 ('F325271124331','kasir','1',' MCB0 DG ','TOKO','PM-B','B0C-YKXC-499-0','GW TUSUK MRICAN POLOS DG 8K ','','0.500','1','100.00','487000','0','0','15000','488000','0','0','0','488000','SIN','00376430','B0C','0','0','-','0','985000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B0C-YKXC-499-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='B0C-YKXC-499-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 ('F325271124331','2025-11-27','0.500','2025-11-27','11:24:33','PLG0025900','488000','488000','0','488000','488000','kasir','2025-11-27 11:24:33','F32527112433');
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-27','F325271124331','2025-11-27','11:24:33','SIN','488000','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-251127-0028','D','2025-11-27','11:24:33','kasir','PENJUALAN','F325271124331','885016000','488000','885504000');
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 ('F325271220591','kasir','1',' MDA1D X LG','TOKO','PM-A','A1D-YFXI-100-0','AT X MODEL KLIP MATA LG 8K ','','1.000','1','100.00','995000','0','0','15000','995000','0','0','0','995000','SIN','00356845','A1D','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YFXI-100-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='A1D-YFXI-100-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 ('F325271220591','2025-11-27','1.000','2025-11-27','12:20:59','PLG0025901','995000','995000','0','995000','995000','kasir','2025-11-27 12:20:59','F32527122059');
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-27','F325271220591','2025-11-27','12:20:59','SIN','995000','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-251127-0029','D','2025-11-27','12:20:59','kasir','PENJUALAN','F325271220591','885504000','995000','886499000');
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 ('F325271222461','kasir','1',' MEH1 X KH ','TOKO','PM-H','H1E-YKAG-79-0','KL X NORY KH 44 8K ','','1.960','1','100.00','2009000','0','0','15000','1990000','0','0','0','1990000','SIN','00377655','H1E','0','0','-','1','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YKAG-79-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.960',berat_jual_asli=berat_jual_asli+'1.960',stock_jual='1',berat_akhir=berat_akhir-'1.960',berat_akhir_asli=berat_akhir_asli-'1.960',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='H1E-YKAG-79-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 ('F325271222461','2025-11-27','1.960','2025-11-27','12:22:47','PLG0025902','1990000','1990000','0','1990000','1990000','kasir','2025-11-27 12:22:46','F32527122246');
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-27','F325271222461','2025-11-27','12:22:47','SIN','1990000','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-251127-0030','D','2025-11-27','12:22:47','kasir','PENJUALAN','F325271222461','886499000','1990000','888489000');
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 ('F325271223291','kasir','1',' MED2E X BM','TOKO','PM-D','D2E-YJAC-58-0','LT X MODEL MATA BM 8K ','','0.750','1','100.00','761000','0','0','15000','760000','0','0','0','760000','SIN','00372788','D2E','0','0','-','1','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YJAC-58-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='D2E-YJAC-58-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 ('F325271223291','2025-11-27','0.750','2025-11-27','12:23:29','PLG0025903','760000','760000','0','760000','760000','kasir','2025-11-27 12:23:29','F32527122329');
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-27','F325271223291','2025-11-27','12:23:29','SIN','760000','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-251127-0031','D','2025-11-27','12:23:29','kasir','PENJUALAN','F325271223291','888489000','760000','889249000');
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 ('F325271246251','kasir','1',' MDE2 X CM ','TOKO','PM-E','E2D-YIAC-166-0','CC X MODEL MATA CM 14 8K ','','1.000','1','100.00','995000','0','0','15000','995000','0','0','0','995000','FIT','00369250','E2D','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIAC-166-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='E2D-YIAC-166-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 ('F325271246251','2025-11-27','1.000','2025-11-27','12:46:26','PLG0025904','995000','995000','0','995000','995000','kasir','2025-11-27 12:46:25','F32527124625');
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-27','F325271246251','2025-11-27','12:46:26','FIT','995000','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-251127-0032','D','2025-11-27','12:46:26','kasir','PENJUALAN','F325271246251','889249000','995000','890244000');
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-00017547','X-00017547','CC MODEL SLEP LG 14 8K','GR','---','E1E','BELI','BELI001','465000','2025-11-27','0.510','1','kasir','2025-11-27 13:10:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00017547','X-00017547');
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-251127-0005','F325300908561','SIN','1','BELI','BELI001','E1E', 'X-00017547', 'CC MODEL SLEP LG 14 8K','0.510','0.510','100.00','505000','465000','911765','1025000','1','465000','465000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-251127-0005','2025-11-27','2025-11-27','13:10:15','SIN','---','0.510','465000','465000','465000','465000','465000','kasir','2025-11-27 13:10:16','FB-251127-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251127-0005','RIA','SAMPUNG','','','','kasir','2025-11-27 13:10:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-27' 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-251127-0033','K','2025-11-27','13:10:15','kasir','PEMBELIAN UMUM','FB-251127-0005','890244000','465000','889779000');
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-00017548','X-00017548','GL TFF SLEP VAR YT 8K','GR','---','F3E','BELI','BELI001','1500000','2025-11-27','2.070','1','kasir','2025-11-27 13:10:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00017548','X-00017548');
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-251127-0006','F325291239221','FIT','1','BELI','BELI001','F3E', 'X-00017548', 'GL TFF SLEP VAR YT 8K','2.070','2.070','100.00','1615000','1500000','724638','1025000','1','1500000','1500000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.070',berat_beli_asli=berat_beli_asli+'2.070',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.070',berat_akhir_asli=berat_akhir_asli+'2.070',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' 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-251127-0006','2025-11-27','2025-11-27','13:10:32','FIT','---','2.070','1500000','1500000','1500000','1500000','1500000','kasir','2025-11-27 13:10:33','FB-251127-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251127-0006','ANIK','BULUKERTO','','','','kasir','2025-11-27 13:10:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-27' 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-251127-0034','K','2025-11-27','13:10:32','kasir','PEMBELIAN UMUM','FB-251127-0006','889779000','1500000','888279000');
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-00017549','X-00017549','AT GYPSY MRICAN LG 8K','GR','---','A1E','BELI','BELI001','657000','2025-11-27','0.970','1','kasir','2025-11-27 13:22:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00017549','X-00017549');
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-251127-0007','F324241239371','FIT','1','BELI','BELI001','A1E', 'X-00017549', 'AT GYPSY MRICAN LG 8K','0.970','0.970','100.00','475000','657000','677320','1025000','1','657000','657000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.970',berat_beli_asli=berat_beli_asli+'0.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.970',berat_akhir_asli=berat_akhir_asli+'0.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' 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-251127-0007','2025-11-27','2025-11-27','13:22:02','FIT','---','0.970','657000','657000','657000','657000','657000','kasir','2025-11-27 13:22:03','FB-251127-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251127-0007','AULIA','BULUKERTO','','','','kasir','2025-11-27 13:22:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-27' 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-251127-0035','K','2025-11-27','13:22:02','kasir','PEMBELIAN UMUM','FB-251127-0007','888279000','657000','887622000');
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-00017550','X-00017550','GW X MODEL TAUGE MATA HK 8K','GR','---','B1F','BELI','BELI001','255000','2025-11-27','0.400','1','kasir','2025-11-27 13:22:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1F','X-00017550','X-00017550');
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-251127-0008','F325050843211','FIT','1','BELI','BELI001','B1F', 'X-00017550', 'GW X MODEL TAUGE MATA HK 8K','0.400','0.400','100.00','270000','255000','637500','1045000','1','255000','255000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.400',berat_beli_asli=berat_beli_asli+'0.400',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.400',berat_akhir_asli=berat_akhir_asli+'0.400',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-27' 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-251127-0008','2025-11-27','2025-11-27','13:22:28','FIT','---','0.400','255000','255000','255000','255000','255000','kasir','2025-11-27 13:22:29','FB-251127-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251127-0008','ANISA','DUREN SUMBERGALIH','','','','kasir','2025-11-27 13:22:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-27' 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-251127-0036','K','2025-11-27','13:22:28','kasir','PEMBELIAN UMUM','FB-251127-0008','887622000','255000','887367000');
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-00017551','X-00017551','GL OVAL MODEL DAUN SLEP VAR CM D55 8K','GR','---','F1E','BELI','BELI001','2537000','2025-11-27','3.280','1','kasir','2025-11-27 13:22:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00017551','X-00017551');
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-251127-0009','F325120105561','FIT','1','BELI','BELI001','F1E', 'X-00017551', 'GL OVAL MODEL DAUN SLEP VAR CM D55 8K','3.280','3.280','100.00','2730000','2537000','773476','1025000','1','2537000','2537000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.280',berat_beli_asli=berat_beli_asli+'3.280',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.280',berat_akhir_asli=berat_akhir_asli+'3.280',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-27' 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-251127-0009','2025-11-27','2025-11-27','13:22:58','FIT','---','3.280','2537000','2537000','2537000','2537000','2537000','kasir','2025-11-27 13:22:59','FB-251127-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251127-0009','NARMI','KENTENG PURWANTORO','','','082325770389','kasir','2025-11-27 13:22:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-27' 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-251127-0037','K','2025-11-27','13:22:58','kasir','PEMBELIAN UMUM','FB-251127-0009','887367000','2537000','884830000');
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-00017552','X-00017552','AT DGP 17K','GR','---','A0TA','BELI','BELI001','565000','2025-11-27','0.500','1','kasir','2025-11-27 13:25:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-A0TA';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A0TA','X-00017552','X-00017552');
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-251127-0010','t0008040','AAT','1','BELI','BELI001','A0TA', 'X-00017552', 'AT DGP 17K','0.500','0.500','100.00','345000','565000','1130000','1765000','1','565000','565000','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-27' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A0TA' 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-251127-0010','2025-11-27','2025-11-27','13:25:22','AAT','---','0.500','565000','565000','565000','565000','565000','kasir','2025-11-27 13:25:23','FB-251127-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251127-0010','BETTY','SINGOSAREN','','','','kasir','2025-11-27 13:25:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-27' 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-251127-0038','K','2025-11-27','13:25:22','kasir','PEMBELIAN UMUM','FB-251127-0010','884830000','565000','884265000');
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 ('F325270139331','kasir','1',' MEF3 UB ','TOKO','PM-F','F3E-YKXC-322-0','GL MODEL GENIA UB 8K ','','0.520','1','100.00','528000','0','0','15000','528000','0','0','0','528000','SIN','00376250','F3E','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKXC-322-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='F3E-YKXC-322-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 ('F325270139331','2025-11-27','0.520','2025-11-27','13:39:33','PLG0025905','528000','528000','0','528000','528000','kasir','2025-11-27 13:39:33','F32527013933');
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-27','F325270139331','2025-11-27','13:39:33','SIN','528000','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-251127-0039','D','2025-11-27','13:39:33','kasir','PENJUALAN','F325270139331','884265000','528000','884793000');
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 ('F325270158381','kasir','1',' MEH1 X UB ','TOKO','PM-H','H1E-YKXH-113-0','KL X GUCCI UB 42 8K','','2.000','1','100.00','2030000','0','0','15000','2030000','0','0','0','2030000','AAT','00376896','H1E','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YKXH-113-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='H1E-YKXH-113-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 ('F325270158381','2025-11-27','2.000','2025-11-27','13:58:39','PLG0025906','2030000','2030000','0','2030000','2030000','kasir','2025-11-27 13:58:38','F32527015838');
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-27','F325270158381','2025-11-27','13:58:39','AAT','2030000','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-251127-0040','D','2025-11-27','13:58:39','kasir','PENJUALAN','F325270158381','884793000','2030000','886823000');
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 ('F325270158511','kasir','1',' MED1E X UB','TOKO','PM-D','D1E-YKBD-44-0','LT X MODEL SPECTRA SLEP UB 8K ','','0.650','1','100.00','660000','0','0','15000','660000','0','0','0','660000','AAT','00378453','D1E','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YKBD-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='D1E-YKBD-44-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 ('F325270158511','2025-11-27','0.650','2025-11-27','13:58:52','PLG0025907','660000','660000','0','660000','660000','kasir','2025-11-27 13:58:51','F32527015851');
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-27','F325270158511','2025-11-27','13:58:52','AAT','660000','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-251127-0041','D','2025-11-27','13:58:52','kasir','PENJUALAN','F325270158511','886823000','660000','887483000');
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 ('F325270201351','kasir','1',' MDE1 UB 16','TOKO','PM-E','E1D-YKAE-159-0','CC MODEL DAUN SLEP VAR UB 16 8K ','','0.870','1','100.00','866000','0','0','15000','865000','0','0','0','865000','SIN','00377567','E1D','0','0','-','1','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-11-27', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YKAE-159-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.870',berat_jual_asli=berat_jual_asli+'0.870',stock_jual='1',berat_akhir=berat_akhir-'0.870',berat_akhir_asli=berat_akhir_asli-'0.870',stock_akhir='0' WHERE tanggal='2025-11-27' AND kode_barang='E1D-YKAE-159-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 ('F325270201351','2025-11-27','0.870','2025-11-27','14:01:36','PLG0025908','865000','865000','0','865000','865000','kasir','2025-11-27 14:01:35','F32527020135');
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-27','F325270201351','2025-11-27','14:01:36','SIN','865000','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-251127-0042','D','2025-11-27','14:01:36','kasir','PENJUALAN','F325270201351','887483000','865000','888348000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325270139331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325270139331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325270139331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325270158381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325270158381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325270158381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325270158511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325270158511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325270158511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325270201351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325270201351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325270201351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325270753491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325270753491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325270753491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325270756421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325270756421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325270756421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325270846171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325270846171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325270846171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325270901221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325270901221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325270901221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325270906461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325270906461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325270906461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325270935301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325270935301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325270935301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325270949331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325270949331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325270949331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271004261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271004261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271004261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271005411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271005411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271005411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271022431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271022431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271022431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271023391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271023391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271023391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271030511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271030511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271030511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271033381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271033381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271033381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271038241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271038241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271038241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271040241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271040241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271040241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271058541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271058541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271058541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271109401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271109401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271109401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271118441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271118441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271118441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271119431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271119431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271119431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271120061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271120061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271120061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271124331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271124331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271124331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271220591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271220591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271220591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271222461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271222461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271222461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271223291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271223291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271223291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325271246251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325271246251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325271246251';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251127-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251127-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251127-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251127-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251127-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251127-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251127-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251127-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251127-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251127-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251127-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251127-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251127-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251127-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251127-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251127-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251127-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251127-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251127-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251127-0010';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-28','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-28';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-27';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-27';
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-27' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-27';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-27';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-27';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-27';
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-28' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-27' 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-251128-0001','D','2025-11-28','15:36:49','SYSTEM','SALDO AWAL','SALDO AWAL','0','888348000','888348000');
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-251128-0001','D','2025-11-28','15:36:49','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
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-251128-0001','D','2025-11-28','15:36:49','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-251128-0001','D','2025-11-28','15:36:49','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-11-28';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251128-0001','1','D2E-YIAE-94-0','1','0.470','0.470','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-YIAE-94-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-YIAE-94-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2025-11-28 16:51:12' WHERE kode_barang='D2E-YIAE-94-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-YIAE-94-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-28 16:51:12','TOKO','PM-D','D2E','D2E-YIAE-94-0','1','0.470','0.470','1','0.470','0.470','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2E-YIAE-94-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-YIAE-94-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251128-0001','2025-11-28','16:51','0.470','admpindah','2025-11-27 16:51:12');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251128-0001','1','E1E-YJBA-151-0','1','0.730','0.730','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YJBA-151-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YJBA-151-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-11-28 16:51:27' WHERE kode_barang='E1E-YJBA-151-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YJBA-151-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-28 16:51:27','TOKO','PM-E','E1E','E1E-YJBA-151-0','1','0.730','0.730','1','0.730','0.730','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-YJBA-151-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YJBA-151-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251128-0001','1','E2D-YKXC-550-0','1','0.900','0.900','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YKXC-550-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YKXC-550-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-11-28 16:51:27' WHERE kode_barang='E2D-YKXC-550-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YKXC-550-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-28 16:51:27','TOKO','PM-E','E2D','E2D-YKXC-550-0','1','0.900','0.900','1','0.900','0.900','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-YKXC-550-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YKXC-550-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251128-0001','1','E1E-YKBD-204-0','1','0.500','0.500','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YKBD-204-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YKBD-204-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2025-11-28 16:51:27' WHERE kode_barang='E1E-YKBD-204-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YKBD-204-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-28 16:51:27','TOKO','PM-E','E1E','E1E-YKBD-204-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-YKBD-204-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YKBD-204-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251128-0001','2025-11-28','16:51','2.130','admpindah','2025-11-27 16:51:26');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251128-0001','1','F2E-YHAD-292-0','1','4.930','4.930','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-YHAD-292-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-YHAD-292-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-11-28 16:51:42' WHERE kode_barang='F2E-YHAD-292-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-YHAD-292-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-28 16:51:42','TOKO','PM-F','F2E','F2E-YHAD-292-0','1','4.930','4.930','1','4.930','4.930','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F2E-YHAD-292-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-YHAD-292-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251128-0001','1','F3F-YKXA-133-0','1','1.160','1.160','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3F-YKXA-133-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3F-YKXA-133-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-11-28 16:51:42' WHERE kode_barang='F3F-YKXA-133-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3F-YKXA-133-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-28 16:51:42','TOKO','PM-F','F3F','F3F-YKXA-133-0','1','1.160','1.160','1','1.160','1.160','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3F-YKXA-133-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3F-YKXA-133-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251128-0001','1','F2E-YKXA-199-0','1','4.970','4.970','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-YKXA-199-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-YKXA-199-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-11-28 16:51:42' WHERE kode_barang='F2E-YKXA-199-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-YKXA-199-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-28 16:51:42','TOKO','PM-F','F2E','F2E-YKXA-199-0','1','4.970','4.970','1','4.970','4.970','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F2E-YKXA-199-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-YKXA-199-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251128-0001','1','F3E-YKXC-168-0','1','0.500','0.500','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YKXC-168-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YKXC-168-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-11-28 16:51:42' WHERE kode_barang='F3E-YKXC-168-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YKXC-168-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-28 16:51:42','TOKO','PM-F','F3E','F3E-YKXC-168-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-YKXC-168-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YKXC-168-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251128-0001','1','F1E-YKBF-89-0','1','2.060','2.060','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-YKBF-89-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-YKBF-89-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-11-28 16:51:42' WHERE kode_barang='F1E-YKBF-89-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-YKBF-89-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-28 16:51:42','TOKO','PM-F','F1E','F1E-YKBF-89-0','1','2.060','2.060','1','2.060','2.060','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-YKBF-89-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-YKBF-89-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251128-0001','2025-11-28','16:51','13.620','admpindah','2025-11-27 16:51:41');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251128-0001','1','H2J-YKXA-220-0','1','2.060','2.060','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2J-YKXA-220-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-YKXA-220-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-11-28 16:51:59' WHERE kode_barang='H2J-YKXA-220-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-YKXA-220-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-28 16:51:59','TOKO','PM-H','H2J','H2J-YKXA-220-0','1','2.060','2.060','1','2.060','2.060','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2J' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2J-YKXA-220-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2J-YKXA-220-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251128-0001','1','H2J-YKAA-151-0','1','1.410','1.410','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2J-YKAA-151-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-YKAA-151-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-11-28 16:51:59' WHERE kode_barang='H2J-YKAA-151-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-YKAA-151-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-28 16:51:59','TOKO','PM-H','H2J','H2J-YKAA-151-0','1','1.410','1.410','1','1.410','1.410','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2J' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2J-YKAA-151-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2J-YKAA-151-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251128-0001','1','H2J-YKBD-96-0','1','2.010','2.010','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H2J-YKBD-96-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-YKBD-96-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-11-28 16:51:59' WHERE kode_barang='H2J-YKBD-96-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-YKBD-96-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-28 16:51:59','TOKO','PM-H','H2J','H2J-YKBD-96-0','1','2.010','2.010','1','2.010','2.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2J' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2J-YKBD-96-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2J-YKBD-96-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251128-0001','1','H1E-YKBD-116-0','1','2.020','2.020','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YKBD-116-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YKBD-116-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-11-28 16:51:59' WHERE kode_barang='H1E-YKBD-116-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YKBD-116-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-28 16:51:59','TOKO','PM-H','H1E','H1E-YKBD-116-0','1','2.020','2.020','1','2.020','2.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-YKBD-116-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YKBD-116-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251128-0001','2025-11-28','16:51','7.500','admpindah','2025-11-27 16:51:58');