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 ('F325060857341','input','1',' MEE1 LG 11','TOKO','PM-E','E1E-YJBI-94-T','CC MODEL HATI VAR LG 11 8K ','','0.550','1','100.00','565000','0','0','15000','565000','0','0','0','565000','AAT','T0074654','E1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJBI-94-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-12-06' AND kode_barang='E1E-YJBI-94-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 ('F325060857341','2025-12-06','0.550','2025-12-06','08:57:35','PLG0026038','565000','565000','0','565000','565000','input','2025-12-06 08:57:34','F32506085734');
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-12-06','F325060857341','2025-12-06','08:57:35','AAT','565000','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-251206-0002','D','2025-12-06','08:57:35','input','PENJUALAN','F325060857341','1000127000','565000','1000692000');
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 ('F325060921441','input','1',' MJH2 X KH ','TOKO','PM-H','H2J-YKBD-108-0','KL X SIEM COBRO ANAK KH 34 9K ','','1.060','1','100.00','1195000','0','0','15000','1195000','0','0','0','1195000','FIT','00378517','H2J','0','0','-','0','1137000');
UPDATE tm_barang SET tgl_last_jual='2025-12-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-YKBD-108-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2025-12-06' AND kode_barang='H2J-YKBD-108-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 ('F325060921441','2025-12-06','1.060','2025-12-06','09:21:44','PLG0026039','1195000','1195000','0','1195000','1195000','input','2025-12-06 09:21:44','F32506092144');
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-12-06','F325060921441','2025-12-06','09:21:44','FIT','1195000','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-251206-0003','D','2025-12-06','09:21:44','input','PENJUALAN','F325060921441','1000692000','1195000','1001887000');
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 ('F325061002281','input','1',' MEF1 X 10K','TOKO','PM-F','F1E-YKXC-179-0','GL X OSROT BONEKA ANAK LG 8K ','','1.070','1','100.00','1099000','0','0','15000','1100000','0','10000','0','1110000','FIT','00376101','F1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YKXC-179-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2025-12-06' AND kode_barang='F1E-YKXC-179-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 ('F325061002281','2025-12-06','1.070','2025-12-06','10:02:29','PLG0026040','1100000','1100000','10000','1110000','1110000','input','2025-12-06 10:02:28','F32506100228');
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-12-06','F325061002281','2025-12-06','10:02:29','FIT','1110000','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-251206-0004','D','2025-12-06','10:02:29','input','PENJUALAN','F325061002281','1001887000','1110000','1002997000');
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 ('F325061044271','input','1',' MEE1 LG 14','TOKO','PM-E','E1E-YKAE-162-0','CC MODEL DAUN VAR LG 14 8K ','','0.460','1','100.00','472000','0','0','15000','473000','0','0','0','473000','FIT','00377570','E1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YKAE-162-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-12-06' AND kode_barang='E1E-YKAE-162-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 ('F325061044271','2025-12-06','0.460','2025-12-06','10:44:28','PLG0026041','473000','473000','0','473000','473000','input','2025-12-06 10:44:27','F32506104427');
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-12-06','F325061044271','2025-12-06','10:44:28','FIT','473000','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-251206-0005','D','2025-12-06','10:44:28','input','PENJUALAN','F325061044271','1002997000','473000','1003470000');
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 ('F325061047441','input','1',' MEE1 LG 19','TOKO','PM-E','E1E-YKAE-163-0','CC MODEL DAUN VAR LG 19 8K ','','0.520','1','100.00','534000','0','0','15000','535000','0','0','0','535000','SIN','00377571','E1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YKAE-163-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-12-06' AND kode_barang='E1E-YKAE-163-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 ('F325061047441','2025-12-06','0.520','2025-12-06','10:47:45','PLG0026042','535000','535000','0','535000','535000','input','2025-12-06 10:47:44','F32506104744');
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-12-06','F325061047441','2025-12-06','10:47:45','SIN','535000','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-251206-0006','D','2025-12-06','10:47:45','input','PENJUALAN','F325061047441','1003470000','535000','1004005000');
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 ('F325061055221','input','1',' MFA1F X LG','TOKO','PM-A','A1F-YHXH-73-0','AT X BANGKOK KLIP SLEP LG 8K','','0.500','1','100.00','523000','0','0','15000','525000','0','0','0','525000','FIT','00364601','A1F','0','0','-','0','1047000');
UPDATE tm_barang SET tgl_last_jual='2025-12-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-YHXH-73-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-12-06' AND kode_barang='A1F-YHXH-73-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 ('F325061055221','2025-12-06','0.500','2025-12-06','10:55:22','PLG0026043','525000','525000','0','525000','525000','input','2025-12-06 10:55:22','F32506105522');
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-12-06','F325061055221','2025-12-06','10:55:22','FIT','525000','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-251206-0007','D','2025-12-06','10:55:22','input','PENJUALAN','F325061055221','1004005000','525000','1004530000');
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 ('F325061103051','input','1',' MDE2 X NJ ','TOKO','PM-E','E2D-YEXA-193-0','CC X MODEL MATA ROSE NJ 16 8K ','','1.130','1','100.00','1138000','0','0','15000','1138000','0','0','0','1138000','SIN','00351786','E2D','0','0','-','0','1007000');
UPDATE tm_barang SET tgl_last_jual='2025-12-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YEXA-193-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2025-12-06' AND kode_barang='E2D-YEXA-193-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 ('F325061103051','2025-12-06','1.130','2025-12-06','11:03:05','PLG0026044','1138000','1138000','0','1138000','1138000','input','2025-12-06 11:03:05','F32506110305');
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-12-06','F325061103051','2025-12-06','11:03:05','SIN','1138000','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-251206-0008','D','2025-12-06','11:03:05','input','PENJUALAN','F325061103051','1004530000','1138000','1005668000');
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 ('F325061132311','input','1',' MDE2 10K C','TOKO','PM-E','E2D-YLXC-237-0','CC WEDDING MATA CM 12 8K ','','1.510','1','100.00','1521000','0','0','15000','1520000','0','10000','0','1530000','FIT','00379553','E2D','0','0','-','1','1007000');
UPDATE tm_barang SET tgl_last_jual='2025-12-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YLXC-237-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2025-12-06' AND kode_barang='E2D-YLXC-237-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 ('F325061132311','2025-12-06','1.510','2025-12-06','11:32:31','PLG0026045','1520000','1520000','10000','1530000','1530000','input','2025-12-06 11:32:31','F32506113231');
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-12-06','F325061132311','2025-12-06','11:32:31','FIT','1530000','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-251206-0009','D','2025-12-06','11:32:31','input','PENJUALAN','F325061132311','1005668000','1530000','1007198000');
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 ('F325061142031','input','1',' MDE2 X MJ ','TOKO','PM-E','E2D-YFBH-34-0','CC X MODEL MATA MJ 16 8K ','','1.130','1','100.00','1138000','0','0','15000','1140000','0','0','0','1140000','AAT','00358742','E2D','0','0','-','0','1007000');
UPDATE tm_barang SET tgl_last_jual='2025-12-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YFBH-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2025-12-06' AND kode_barang='E2D-YFBH-34-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 ('F325061142031','2025-12-06','1.130','2025-12-06','11:42:04','PLG0026046','1140000','1140000','0','1140000','1140000','input','2025-12-06 11:42:03','F32506114203');
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-12-06','F325061142031','2025-12-06','11:42:04','AAT','1140000','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-251206-0010','D','2025-12-06','11:42:04','input','PENJUALAN','F325061142031','1007198000','1140000','1008338000');
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 ('F325061153481','input','1',' MEE2 X CM ','TOKO','PM-E','E2E-YKAA-293-0','CC X MODEL MATA CM 14 8K ','','0.710','1','100.00','729000','0','0','15000','730000','0','0','0','730000','FIT','00377259','E2E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YKAA-293-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-12-06' AND kode_barang='E2E-YKAA-293-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 ('F325061153481','2025-12-06','0.710','2025-12-06','11:53:48','PLG0026047','730000','730000','0','730000','730000','input','2025-12-06 11:53:48','F32506115348');
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-12-06','F325061153481','2025-12-06','11:53:48','FIT','730000','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-251206-0011','D','2025-12-06','11:53:48','input','PENJUALAN','F325061153481','1008338000','730000','1009068000');
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 ('F325061213031','input','1',' MEF1 XX TD','TOKO','PM-F','F1E-WIAD-145-0','GL XX OVAL C TD 54 ','','4.380','1','100.00','4498000','0','0','15000','4500000','0','0','0','4500000','FIT','00253984','F1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-WIAD-145-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.380',berat_jual_asli=berat_jual_asli+'4.380',stock_jual='1',berat_akhir=berat_akhir-'4.380',berat_akhir_asli=berat_akhir_asli-'4.380',stock_akhir='0' WHERE tanggal='2025-12-06' AND kode_barang='F1E-WIAD-145-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 ('F325061213031','2025-12-06','4.380','2025-12-06','12:13:03','PLG0026048','4500000','4500000','0','4500000','4500000','input','2025-12-06 12:13:03','F32506121303');
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-12-06','F325061213031','2025-12-06','12:13:03','FIT','4500000','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-251206-0012','D','2025-12-06','12:13:03','input','PENJUALAN','F325061213031','1009068000','4500000','1013568000');
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 ('F325061214061','input','1',' MDD2D X JP','TOKO','PM-D','D2D-YKBD-40-0','LT X MODEL MATA JP 8K ','','0.840','1','100.00','846000','0','0','15000','845000','0','0','0','845000','FIT','00378449','D2D','0','0','-','1','1007000');
UPDATE tm_barang SET tgl_last_jual='2025-12-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-YKBD-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.840',berat_jual_asli=berat_jual_asli+'0.840',stock_jual='1',berat_akhir=berat_akhir-'0.840',berat_akhir_asli=berat_akhir_asli-'0.840',stock_akhir='0' WHERE tanggal='2025-12-06' AND kode_barang='D2D-YKBD-40-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 ('F325061214061','2025-12-06','0.840','2025-12-06','12:14:07','PLG0026049','845000','845000','0','845000','845000','input','2025-12-06 12:14:06','F32506121406');
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-12-06','F325061214061','2025-12-06','12:14:07','FIT','845000','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-251206-0013','D','2025-12-06','12:14:07','input','PENJUALAN','F325061214061','1013568000','845000','1014413000');
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 ('F325061214551','input','1',' MDE1 CM 14','TOKO','PM-E','E1D-YKBI-184-0','CC MODEL DAUN VAR CM 14 8K ','','0.670','1','100.00','675000','0','0','15000','675000','0','0','0','675000','FIT','00379150','E1D','0','0','-','0','1007000');
UPDATE tm_barang SET tgl_last_jual='2025-12-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YKBI-184-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2025-12-06' AND kode_barang='E1D-YKBI-184-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 ('F325061214551','2025-12-06','0.670','2025-12-06','12:14:56','PLG0026050','675000','675000','0','675000','675000','input','2025-12-06 12:14:55','F32506121455');
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-12-06','F325061214551','2025-12-06','12:14:56','FIT','675000','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-251206-0014','D','2025-12-06','12:14:56','input','PENJUALAN','F325061214551','1014413000','675000','1015088000');
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 ('F325061221031','input','1',' MEE1 X YT ','TOKO','PM-E','E1E-YKXH-173-0','CC X MODEL MATA YT 12 8K ','','0.730','1','100.00','750000','0','0','15000','750000','0','0','0','750000','FIT','00376956','E1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YKXH-173-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2025-12-06' AND kode_barang='E1E-YKXH-173-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 ('F325061221031','2025-12-06','0.730','2025-12-06','12:21:04','PLG0026051','750000','750000','0','750000','750000','input','2025-12-06 12:21:03','F32506122103');
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-12-06','F325061221031','2025-12-06','12:21:04','FIT','750000','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-251206-0015','D','2025-12-06','12:21:04','input','PENJUALAN','F325061221031','1015088000','750000','1015838000');
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 ('F325061236471','input','1',' MJH2J *UB ','TOKO','PM-H','H2J-UBXI-43','KL * MILANO SEMI UB 52CM','','12.030','1','100.00','13558000','0','0','15000','13500000','0','0','0','13500000','SIN','00082668','H2J','0','0','-','1','1137000');
UPDATE tm_barang SET tgl_last_jual='2025-12-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-UBXI-43' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'12.030',berat_jual_asli=berat_jual_asli+'12.030',stock_jual='1',berat_akhir=berat_akhir-'12.030',berat_akhir_asli=berat_akhir_asli-'12.030',stock_akhir='0' WHERE tanggal='2025-12-06' AND kode_barang='H2J-UBXI-43' 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 ('F325061236471','2025-12-06','12.030','2025-12-06','12:36:48','PLG0026052','13500000','13500000','0','13500000','13500000','input','2025-12-06 12:36:47','F32506123647');
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-12-06','F325061236471','2025-12-06','12:36:48','SIN','13500000','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-251206-0016','D','2025-12-06','12:36:48','input','PENJUALAN','F325061236471','1015838000','13500000','1029338000');
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 ('F325061255401','input','1',' MDE2 10K C','TOKO','PM-E','E2D-YLXC-238-0','CC WEDDING MATA CM 12 8K ','','1.530','1','100.00','1541000','0','0','15000','1540000','0','10000','0','1550000','FIT','00379554','E2D','0','0','-','1','1007000');
UPDATE tm_barang SET tgl_last_jual='2025-12-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YLXC-238-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2025-12-06' AND kode_barang='E2D-YLXC-238-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 ('F325061255401','2025-12-06','1.530','2025-12-06','12:55:41','PLG0026053','1540000','1540000','10000','1550000','1550000','input','2025-12-06 12:55:40','F32506125540');
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-12-06','F325061255401','2025-12-06','12:55:41','FIT','1550000','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-251206-0017','D','2025-12-06','12:55:41','input','PENJUALAN','F325061255401','1029338000','1550000','1030888000');
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 ('F325061258141','input','1',' MEH1 UB 34','TOKO','PM-H','H1E-YLXA-1-0','KL NORI ANAK UB 34 8K ','','1.030','1','100.00','1058000','0','0','15000','1058000','0','0','0','1058000','SIN','00379159','H1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-06', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLXA-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2025-12-06' AND kode_barang='H1E-YLXA-1-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 ('F325061258141','2025-12-06','1.030','2025-12-06','12:58:14','PLG0026054','1058000','1058000','0','1058000','1058000','input','2025-12-06 12:58:14','F32506125814');
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-12-06','F325061258141','2025-12-06','12:58:14','SIN','1058000','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-251206-0018','D','2025-12-06','12:58:14','input','PENJUALAN','F325061258141','1030888000','1058000','1031946000');
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-00017616','X-00017616','AT COR 8K','GR','---','A1F','BELI','BELI001','265000','2025-12-06','0.460','1','kasir','2025-12-06 14:17:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00017616','X-00017616');
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-251206-0001','F323300925161','FIT','1','BELI','BELI001','A1F', 'X-00017616', 'AT COR 8K','0.460','0.460','100.00','218000','265000','576087','1047000','1','265000','265000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.460',berat_beli_asli=berat_beli_asli+'0.460',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.460',berat_akhir_asli=berat_akhir_asli+'0.460',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251206-0001','2025-12-06','2025-12-06','14:17:03','FIT','---','0.460','265000','265000','265000','265000','265000','kasir','2025-12-06 14:17:03','FB-251206-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251206-0001','LIA SANDRA','GAMBIRANOM','','','','kasir','2025-12-06 14:17:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251206-0019','K','2025-12-06','14:17:03','kasir','PEMBELIAN UMUM','FB-251206-0001','1031946000','265000','1031681000');
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-00017617','X-00017617','CC COR T 8K','GR','---','E1E','BELI','BELI001','630000','2025-12-06','1.010','1','kasir','2025-12-06 14:19:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00017617','X-00017617');
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-251206-0002','F321011125201','FIT','1','BELI','BELI001','E1E', 'X-00017617', 'CC COR T 8K','1.010','1.010','100.00','415000','630000','623762','1037000','1','630000','630000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.010',berat_beli_asli=berat_beli_asli+'1.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.010',berat_akhir_asli=berat_akhir_asli+'1.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-06' 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-251206-0002','2025-12-06','2025-12-06','14:19:16','FIT','---','1.010','630000','630000','630000','630000','630000','kasir','2025-12-06 14:19:17','FB-251206-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251206-0002','BU GIARTI','BULUKERTO','','','','kasir','2025-12-06 14:19:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251206-0020','K','2025-12-06','14:19:16','kasir','PEMBELIAN UMUM','FB-251206-0002','1031681000','630000','1031051000');
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-00017618','X-00017618','KL X JEDAR KH 42 9K','GR','---','H2I','BELI','BELI001','1160000','2025-12-06','1.130','1','kasir','2025-12-06 14:19:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00017618','X-00017618');
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-251206-0003','F325151115401','AAT','1','BELI','BELI001','H2I', 'X-00017618', 'KL X JEDAR KH 42 9K','1.130','1.130','100.00','1250000','1160000','1026549','1117000','1','1160000','1160000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.130',berat_beli_asli=berat_beli_asli+'1.130',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.130',berat_akhir_asli=berat_akhir_asli+'1.130',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2I' 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-251206-0003','2025-12-06','2025-12-06','14:19:33','AAT','---','1.130','1160000','1160000','1160000','1160000','1160000','kasir','2025-12-06 14:19:34','FB-251206-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251206-0003','ANINDITA','SIDOWAYAH','','','','kasir','2025-12-06 14:19:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251206-0021','K','2025-12-06','14:19:33','kasir','PEMBELIAN UMUM','FB-251206-0003','1031051000','1160000','1029891000');
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-00017619','X-00017619','CC COR T 17K','GR','---','E1TF','BELI','BELI001','1630000','2025-12-06','1.150','1','kasir','2025-12-06 14:21:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1TF','X-00017619','X-00017619');
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-251206-0004','t0040240','FIT','1','BELI','BELI001','E1TF', 'X-00017619', 'CC COR T 17K','1.150','1.150','100.00','920000','1630000','1417391','1895000','1','1630000','1630000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.150',berat_beli_asli=berat_beli_asli+'1.150',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.150',berat_akhir_asli=berat_akhir_asli+'1.150',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-06' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1TF' 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-251206-0004','2025-12-06','2025-12-06','14:21:08','FIT','---','1.150','1630000','1630000','1630000','1630000','1630000','kasir','2025-12-06 14:21:09','FB-251206-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251206-0004','HERNA','MIRI KISMANTORO','','','','kasir','2025-12-06 14:21:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-06' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251206-0022','K','2025-12-06','14:21:08','kasir','PEMBELIAN UMUM','FB-251206-0004','1029891000','1630000','1028261000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251206-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251206-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251206-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251206-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251206-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251206-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251206-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251206-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325060857341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325060857341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325060857341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325060921441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325060921441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325060921441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061002281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061002281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061002281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061044271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061044271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061044271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061047441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061047441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061047441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061055221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061055221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061055221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061103051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061103051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061103051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061132311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061132311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061132311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061142031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061142031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061142031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061153481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061153481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061153481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061213031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061213031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061213031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061214061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061214061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061214061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061214551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061214551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061214551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061221031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061221031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061221031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061236471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061236471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061236471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061255401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061255401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061255401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325061258141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325061258141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325061258141';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-07','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-06';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-06';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-06';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-12-06' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-06';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-06';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-06';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-06';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-07' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-06' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251207-0001','D','2025-12-07','15:41:23','SYSTEM','SALDO AWAL','SALDO AWAL','0','1028261000','1028261000');
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-251207-0001','D','2025-12-07','15:41:23','BCA','SALDO AWAL','SALDO AWAL','0','694074000','694074000');
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-251207-0001','D','2025-12-07','15:41:23','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251207-0001','D','2025-12-07','15:41:23','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2025-12-07';
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-20251207-0001','1','A1D-YLXF-139-0','1','0.970','0.970','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-YLXF-139-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-YLXF-139-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-12-07 16:48:54' WHERE kode_barang='A1D-YLXF-139-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-YLXF-139-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-12-07 16:48:54','TOKO','PM-A','A1D','A1D-YLXF-139-0','1','0.970','0.970','1','0.970','0.970','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' 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='A1D-YLXF-139-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-YLXF-139-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-20251207-0001','1','A1E-YLXF-150-0','1','0.530','0.530','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YLXF-150-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YLXF-150-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-12-07 16:48:54' WHERE kode_barang='A1E-YLXF-150-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YLXF-150-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-12-07 16:48:54','TOKO','PM-A','A1E','A1E-YLXF-150-0','1','0.530','0.530','1','0.530','0.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' 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='A1E-YLXF-150-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YLXF-150-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-20251207-0001','1','A1E-YLXF-160-0','1','0.550','0.550','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YLXF-160-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YLXF-160-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-12-07 16:48:54' WHERE kode_barang='A1E-YLXF-160-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YLXF-160-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-12-07 16:48:54','TOKO','PM-A','A1E','A1E-YLXF-160-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' 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='A1E-YLXF-160-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YLXF-160-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-20251207-0001','1','A1E-YLXF-161-0','1','0.580','0.580','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YLXF-161-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YLXF-161-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-12-07 16:48:54' WHERE kode_barang='A1E-YLXF-161-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YLXF-161-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-12-07 16:48:54','TOKO','PM-A','A1E','A1E-YLXF-161-0','1','0.580','0.580','1','0.580','0.580','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' 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='A1E-YLXF-161-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YLXF-161-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-20251207-0001','1','A1D-YLXF-168-0','1','0.950','0.950','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-YLXF-168-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-YLXF-168-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-12-07 16:48:54' WHERE kode_barang='A1D-YLXF-168-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-YLXF-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-12-07 16:48:54','TOKO','PM-A','A1D','A1D-YLXF-168-0','1','0.950','0.950','1','0.950','0.950','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' 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='A1D-YLXF-168-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-YLXF-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-20251207-0001','1','A1D-YLXF-192-0','1','0.950','0.950','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-YLXF-192-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-YLXF-192-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2025-12-07 16:48:54' WHERE kode_barang='A1D-YLXF-192-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-YLXF-192-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-12-07 16:48:54','TOKO','PM-A','A1D','A1D-YLXF-192-0','1','0.950','0.950','1','0.950','0.950','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' 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='A1D-YLXF-192-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-YLXF-192-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251207-0001','2025-12-07','16:48','4.530','admpindah','2025-12-06 16:48:54');
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-20251207-0001','1','B1E-YLXF-182-0','1','0.400','0.400','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-YLXF-182-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-YLXF-182-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2025-12-07 16:49:12' WHERE kode_barang='B1E-YLXF-182-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-YLXF-182-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-12-07 16:49:12','TOKO','PM-B','B1E','B1E-YLXF-182-0','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' 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='B1E-YLXF-182-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-YLXF-182-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251207-0001','2025-12-07','16:49','0.400','admpindah','2025-12-06 16:49:11');
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-20251207-0001','1','D2D-YLXF-196-0','1','1.150','1.150','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D2D-YLXF-196-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2D-YLXF-196-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2025-12-07 16:49:29' WHERE kode_barang='D2D-YLXF-196-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2D-YLXF-196-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-12-07 16:49:29','TOKO','PM-D','D2D','D2D-YLXF-196-0','1','1.150','1.150','1','1.150','1.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2D' 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='D2D-YLXF-196-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2D-YLXF-196-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-20251207-0001','1','D2D-YLXF-197-0','1','0.860','0.860','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D2D-YLXF-197-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2D-YLXF-197-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2025-12-07 16:49:29' WHERE kode_barang='D2D-YLXF-197-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2D-YLXF-197-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-12-07 16:49:29','TOKO','PM-D','D2D','D2D-YLXF-197-0','1','0.860','0.860','1','0.860','0.860','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2D' 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='D2D-YLXF-197-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2D-YLXF-197-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-20251207-0001','1','D2D-YLXF-198-0','1','0.950','0.950','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D2D-YLXF-198-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2D-YLXF-198-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2025-12-07 16:49:29' WHERE kode_barang='D2D-YLXF-198-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2D-YLXF-198-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-12-07 16:49:29','TOKO','PM-D','D2D','D2D-YLXF-198-0','1','0.950','0.950','1','0.950','0.950','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2D' 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='D2D-YLXF-198-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2D-YLXF-198-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-20251207-0001','1','D2E-YLXF-205-0','1','0.480','0.480','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-YLXF-205-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-YLXF-205-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2025-12-07 16:49:29' WHERE kode_barang='D2E-YLXF-205-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-YLXF-205-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-12-07 16:49:29','TOKO','PM-D','D2E','D2E-YLXF-205-0','1','0.480','0.480','1','0.480','0.480','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-YLXF-205-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-YLXF-205-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-20251207-0001','1','D2E-YLXF-206-0','1','0.500','0.500','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-YLXF-206-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-YLXF-206-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2025-12-07 16:49:29' WHERE kode_barang='D2E-YLXF-206-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-YLXF-206-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-12-07 16:49:29','TOKO','PM-D','D2E','D2E-YLXF-206-0','1','0.500','0.500','1','0.500','0.500','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-YLXF-206-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-YLXF-206-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251207-0001','2025-12-07','16:49','3.940','admpindah','2025-12-06 16:49: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-20251207-0001','1','F1E-YLXC-257-0','1','4.450','4.450','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-YLXC-257-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-YLXC-257-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-07 16:49:46' WHERE kode_barang='F1E-YLXC-257-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-YLXC-257-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-12-07 16:49:46','TOKO','PM-F','F1E','F1E-YLXC-257-0','1','4.450','4.450','1','4.450','4.450','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-YLXC-257-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-YLXC-257-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-20251207-0001','1','F1E-YLXF-216-0','1','3.000','3.000','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-YLXF-216-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-YLXF-216-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-07 16:49:46' WHERE kode_barang='F1E-YLXF-216-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-YLXF-216-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-12-07 16:49:46','TOKO','PM-F','F1E','F1E-YLXF-216-0','1','3.000','3.000','1','3.000','3.000','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-YLXF-216-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-YLXF-216-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-20251207-0001','1','F1E-YLXF-219-0','1','3.080','3.080','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-YLXF-219-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-YLXF-219-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-07 16:49:46' WHERE kode_barang='F1E-YLXF-219-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-YLXF-219-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-12-07 16:49:46','TOKO','PM-F','F1E','F1E-YLXF-219-0','1','3.080','3.080','1','3.080','3.080','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-YLXF-219-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-YLXF-219-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-20251207-0001','1','F1E-YLXF-224-0','1','4.390','4.390','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-YLXF-224-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-YLXF-224-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-07 16:49:46' WHERE kode_barang='F1E-YLXF-224-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-YLXF-224-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-12-07 16:49:46','TOKO','PM-F','F1E','F1E-YLXF-224-0','1','4.390','4.390','1','4.390','4.390','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-YLXF-224-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-YLXF-224-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-20251207-0001','1','F2E-YLXF-227-0','1','1.930','1.930','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-YLXF-227-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-YLXF-227-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-07 16:49:46' WHERE kode_barang='F2E-YLXF-227-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-YLXF-227-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-12-07 16:49:46','TOKO','PM-F','F2E','F2E-YLXF-227-0','1','1.930','1.930','1','1.930','1.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-YLXF-227-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-YLXF-227-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-20251207-0001','1','F4I-YLXF-234-0','1','1.030','1.030','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F4I-YLXF-234-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F4I-YLXF-234-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-07 16:49:46' WHERE kode_barang='F4I-YLXF-234-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F4I-YLXF-234-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-12-07 16:49:46','TOKO','PM-F','F4I','F4I-YLXF-234-0','1','1.030','1.030','1','1.030','1.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='F4I' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F4I' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MI' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MI' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F4I-YLXF-234-0';
DELETE FROM tm_barang_export WHERE kode_barang='F4I-YLXF-234-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-20251207-0001','1','F3E-YLXF-241-0','1','1.730','1.730','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YLXF-241-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YLXF-241-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-07 16:49:46' WHERE kode_barang='F3E-YLXF-241-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YLXF-241-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-12-07 16:49:46','TOKO','PM-F','F3E','F3E-YLXF-241-0','1','1.730','1.730','1','1.730','1.730','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-YLXF-241-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YLXF-241-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-20251207-0001','1','F3E-YLXF-250-0','1','2.350','2.350','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YLXF-250-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YLXF-250-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-07 16:49:46' WHERE kode_barang='F3E-YLXF-250-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YLXF-250-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-12-07 16:49:46','TOKO','PM-F','F3E','F3E-YLXF-250-0','1','2.350','2.350','1','2.350','2.350','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-YLXF-250-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YLXF-250-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-20251207-0001','1','F3E-YLXF-252-0','1','1.160','1.160','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YLXF-252-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YLXF-252-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-07 16:49:46' WHERE kode_barang='F3E-YLXF-252-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YLXF-252-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-12-07 16:49:46','TOKO','PM-F','F3E','F3E-YLXF-252-0','1','1.160','1.160','1','1.160','1.160','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-YLXF-252-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YLXF-252-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-20251207-0001','1','F3E-YLXF-253-0','1','2.960','2.960','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YLXF-253-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YLXF-253-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-07 16:49:46' WHERE kode_barang='F3E-YLXF-253-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YLXF-253-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-12-07 16:49:46','TOKO','PM-F','F3E','F3E-YLXF-253-0','1','2.960','2.960','1','2.960','2.960','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-YLXF-253-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YLXF-253-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-20251207-0001','1','F4J-YLXF-259-0','1','2.500','2.500','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F4J-YLXF-259-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F4J-YLXF-259-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-12-07 16:49:46' WHERE kode_barang='F4J-YLXF-259-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F4J-YLXF-259-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-12-07 16:49:46','TOKO','PM-F','F4J','F4J-YLXF-259-0','1','2.500','2.500','1','2.500','2.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='F4J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F4J' 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='F4J-YLXF-259-0';
DELETE FROM tm_barang_export WHERE kode_barang='F4J-YLXF-259-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251207-0001','2025-12-07','16:49','28.580','admpindah','2025-12-06 16:49:46');
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-20251207-0001','1','H1F-YKBB-60-0','1','1.020','1.020','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1F-YKBB-60-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1F-YKBB-60-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-12-07 16:50:21' WHERE kode_barang='H1F-YKBB-60-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1F-YKBB-60-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-12-07 16:50:21','TOKO','PM-H','H1F','H1F-YKBB-60-0','1','1.020','1.020','1','1.020','1.020','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1F' 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='H1F-YKBB-60-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1F-YKBB-60-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-20251207-0001','1','H1E-YLXD-27-0','1','4.900','4.900','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YLXD-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YLXD-27-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2025-12-07 16:50:21' WHERE kode_barang='H1E-YLXD-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YLXD-27-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-12-07 16:50:21','TOKO','PM-H','H1E','H1E-YLXD-27-0','1','4.900','4.900','1','4.900','4.900','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-YLXD-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YLXD-27-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251207-0001','2025-12-07','16:50','5.920','admpindah','2025-12-06 16:50:21');