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 ('F325040826191','input','1',' MEH1 X KH ','TOKO','PM-H','H1E-YABE-248-0','KL X NORY KH 44 8K ','','4.000','1','100.00','3960000','0','0','15000','3960000','0','0','0','3960000','SIN','00336531','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YABE-248-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.000',berat_jual_asli=berat_jual_asli+'4.000',stock_jual='1',berat_akhir=berat_akhir-'4.000',berat_akhir_asli=berat_akhir_asli-'4.000',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='H1E-YABE-248-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 ('F325040826191','2025-11-04','4.000','2025-11-04','08:26:19','PLG0025530','3960000','3960000','0','3960000','3960000','input','2025-11-04 08:26:19','F32504082619');
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-04','F325040826191','2025-11-04','08:26:19','SIN','3960000','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-251104-0002','D','2025-11-04','08:26:19','input','PENJUALAN','F325040826191','539699000','3960000','543659000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3960000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325040826191' 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 ('F325040826192','input',' 1',' MED2E XXX ','TOKO','PM-D','D2E-XGXB-41-0','LT XXX MODEL MATA UB 8K ','','1.200','1','100.00','1188000','0','0','15000','1190000','0','0','0','1190000','SIN','00305303','D2E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-XGXB-41-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.200',berat_jual_asli=berat_jual_asli+'1.200',stock_jual='1',berat_akhir=berat_akhir-'1.200',berat_akhir_asli=berat_akhir_asli-'1.200',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='D2E-XGXB-41-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 ('F325040826192','2025-11-04','1.200','2025-11-04','08:26:19','PLG0025531','1190000','1190000','0','1190000','1190000','input','2025-11-04 08:26:19','F32504082619');
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-04','F325040826192','2025-11-04','08:26:19','SIN','1190000','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-251104-0003','D','2025-11-04','08:26:19','input','PENJUALAN','F325040826192','543659000','1190000','544849000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1190000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325040826192' 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 ('F325040902141','input','1',' MDE1 X UB ','TOKO','PM-E','E1D-YIBD-401-0','CC X MODEL SLEP UB 16 8K ','','1.410','1','100.00','1368000','0','0','15000','1368000','0','0','0','1368000','FIT','00370822','E1D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YIBD-401-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.410',berat_jual_asli=berat_jual_asli+'1.410',stock_jual='1',berat_akhir=berat_akhir-'1.410',berat_akhir_asli=berat_akhir_asli-'1.410',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='E1D-YIBD-401-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 ('F325040902141','2025-11-04','1.410','2025-11-04','09:02:15','PLG0025532','1368000','1368000','0','1368000','1368000','input','2025-11-04 09:02:14','F32504090214');
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-04','F325040902141','2025-11-04','09:02:15','FIT','1368000','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-251104-0004','D','2025-11-04','09:02:15','input','PENJUALAN','F325040902141','544849000','1368000','546217000');
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 ('F325040954431','input','1',' MEF3E X LT','TOKO','PM-F','F3E-YFAD-302-0','GL X HARLEY KREPYAK PLAT SLEP LT 8K ','','8.550','1','100.00','8464000','0','0','15000','8465000','0','0','0','8465000','AAT','00357582','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YFAD-302-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'8.550',berat_jual_asli=berat_jual_asli+'8.550',stock_jual='1',berat_akhir=berat_akhir-'8.550',berat_akhir_asli=berat_akhir_asli-'8.550',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='F3E-YFAD-302-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 ('F325040954431','2025-11-04','8.550','2025-11-04','09:54:44','PLG0025533','8465000','8465000','0','8465000','8465000','input','2025-11-04 09:54:43','F32504095443');
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-04','F325040954431','2025-11-04','09:54:44','AAT','8465000','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-251104-0005','D','2025-11-04','09:54:44','input','PENJUALAN','F325040954431','546217000','8465000','554682000');
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 ('F325041018111','input','1',' MEF3E X UB','TOKO','PM-F','F3E-YJBB-174-0','GL X TIFF MATA VAR UB 8K ','','1.470','1','100.00','1455000','0','0','15000','1455000','0','0','0','1455000','FIT','00374237','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJBB-174-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.470',berat_jual_asli=berat_jual_asli+'1.470',stock_jual='1',berat_akhir=berat_akhir-'1.470',berat_akhir_asli=berat_akhir_asli-'1.470',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='F3E-YJBB-174-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 ('F325041018111','2025-11-04','1.470','2025-11-04','10:18:11','PLG0025534','1455000','1455000','0','1455000','1455000','input','2025-11-04 10:18:11','F32504101811');
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-04','F325041018111','2025-11-04','10:18:11','FIT','1455000','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-251104-0006','D','2025-11-04','10:18:11','input','PENJUALAN','F325041018111','554682000','1455000','556137000');
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 ('F325041032191','input','1',' MIH2 X KH ','TOKO','PM-H','H2I-YHAC-94-0','KL X SANTA KH 44 9K ','','4.000','1','100.00','4280000','0','0','15000','4280000','0','0','0','4280000','AAT','00365464','H2I','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YHAC-94-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.000',berat_jual_asli=berat_jual_asli+'4.000',stock_jual='1',berat_akhir=berat_akhir-'4.000',berat_akhir_asli=berat_akhir_asli-'4.000',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='H2I-YHAC-94-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 ('F325041032191','2025-11-04','4.000','2025-11-04','10:32:20','PLG0025535','4280000','4280000','0','4280000','4280000','input','2025-11-04 10:32:19','F32504103219');
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-04','F325041032191','2025-11-04','10:32:20','AAT','4280000','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-251104-0007','D','2025-11-04','10:32:20','input','PENJUALAN','F325041032191','556137000','4280000','560417000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4280000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325041032191' 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 ('F325041032192','input',' 1',' MEE2 X CM ','TOKO','PM-E','E2E-YGAA-206-0','CC X MODEL MATA CM 10 8K ','','0.600','1','100.00','594000','0','0','15000','595000','0','0','0','595000','AAT','00360759','E2E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YGAA-206-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='E2E-YGAA-206-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 ('F325041032192','2025-11-04','0.600','2025-11-04','10:32:20','PLG0025536','595000','595000','0','595000','595000','input','2025-11-04 10:32:19','F32504103219');
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-04','F325041032192','2025-11-04','10:32:20','AAT','595000','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-251104-0008','D','2025-11-04','10:32:20','input','PENJUALAN','F325041032192','560417000','595000','561012000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='595000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325041032192' 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 ('F325041036121','input','1',' MHA1 HK ','TOKO','PM-A','A1H-YIBB-120-0','AT TINDIK BABY HK 8K ','','0.240','1','100.00','252000','0','0','15000','252000','0','0','0','252000','SIN','00370168','A1H','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1H-YIBB-120-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.240',berat_jual_asli=berat_jual_asli+'0.240',stock_jual='1',berat_akhir=berat_akhir-'0.240',berat_akhir_asli=berat_akhir_asli-'0.240',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='A1H-YIBB-120-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 ('F325041036121','2025-11-04','0.240','2025-11-04','10:36:12','PLG0025537','252000','252000','0','252000','252000','input','2025-11-04 10:36:12','F32504103612');
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-04','F325041036121','2025-11-04','10:36:12','SIN','252000','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-251104-0009','D','2025-11-04','10:36:12','input','PENJUALAN','F325041036121','561012000','252000','561264000');
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 ('F325041114241','input','1',' MEB1 X UB ','TOKO','PM-B','B1E-YFBX-35-0','GW X TIFF MATA VAR UB PE 8K ','','1.720','1','100.00','1703000','0','0','15000','1703000','0','0','0','1703000','AAT','00358120','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YFBX-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.720',berat_jual_asli=berat_jual_asli+'1.720',stock_jual='1',berat_akhir=berat_akhir-'1.720',berat_akhir_asli=berat_akhir_asli-'1.720',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='B1E-YFBX-35-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 ('F325041114241','2025-11-04','1.720','2025-11-04','11:14:24','PLG0025538','1703000','1703000','0','1703000','1703000','input','2025-11-04 11:14:24','F32504111424');
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-04','F325041114241','2025-11-04','11:14:24','AAT','1703000','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-251104-0010','D','2025-11-04','11:14:24','input','PENJUALAN','F325041114241','561264000','1703000','562967000');
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 ('F325041122111','input','1',' MDE2 20K U','TOKO','PM-E','E2D-YCBF-27-0','CC EROPA MATA BIRU UB 22 8K ','','3.840','1','100.00','3763000','0','0','15000','3725000','0','20000','0','3745000','AAT','00345750','E2D','0','0','-','1','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YCBF-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.840',berat_jual_asli=berat_jual_asli+'3.840',stock_jual='1',berat_akhir=berat_akhir-'3.840',berat_akhir_asli=berat_akhir_asli-'3.840',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='E2D-YCBF-27-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 ('F325041122111','2025-11-04','3.840','2025-11-04','11:22:11','PLG0025539','3725000','3725000','20000','3745000','3745000','input','2025-11-04 11:22:11','F32504112211');
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-04','F325041122111','2025-11-04','11:22:11','AAT','3745000','20000');
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-251104-0011','D','2025-11-04','11:22:11','input','PENJUALAN','F325041122111','562967000','3745000','566712000');
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-00017387','X-00017387','CC MODEL MATA VAR LG 13 8K','GR','---','E2E','BELI','BELI001','412000','2025-11-04','0.500','1','kasir','2025-11-04 12:13:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00017387','X-00017387');
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-251104-0001','F325150937272','AAT','1','BELI','BELI001','E2E', 'X-00017387', 'CC MODEL MATA VAR LG 13 8K','0.500','0.500','100.00','448000','412000','824000','1000000','1','412000','412000','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-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251104-0001','2025-11-04','2025-11-04','12:13:31','AAT','---','0.500','412000','412000','412000','412000','412000','kasir','2025-11-04 12:13:31','FB-251104-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251104-0001','IBTY','GADUNGAN KISMANTORO','','','','kasir','2025-11-04 12:13:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-04' 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-251104-0012','K','2025-11-04','12:13:31','kasir','PEMBELIAN UMUM','FB-251104-0001','566712000','412000','566300000');
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-00017388','X-00017388','GL PIPA ANAK BONEKA CAT UB 40 8K','GR','---','F1E','BELI','BELI001','1100000','2025-11-04','1.720','1','kasir','2025-11-04 12:14:04');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00017388','X-00017388');
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-251104-0002','F324130241531','AAT','1','BELI','BELI001','F1E', 'X-00017388', 'GL PIPA ANAK BONEKA CAT UB 40 8K','1.720','1.720','100.00','1145000','1100000','639535','1000000','1','1100000','1100000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.720',berat_beli_asli=berat_beli_asli+'1.720',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.720',berat_akhir_asli=berat_akhir_asli+'1.720',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-04' 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-251104-0002','2025-11-04','2025-11-04','12:14:03','AAT','---','1.720','1100000','1100000','1100000','1100000','1100000','kasir','2025-11-04 12:14:04','FB-251104-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251104-0002','HANUM','JERUK PACITAN','','','','kasir','2025-11-04 12:14:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-04' 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-251104-0013','K','2025-11-04','12:14:03','kasir','PEMBELIAN UMUM','FB-251104-0002','566300000','1100000','565200000');
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-00017389','X-00017389','KL X MILANO KH 44 9K','GR','---','H2J','BELI','BELI001','2935000','2025-11-04','3.070','1','kasir','2025-11-04 12:14:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00017389','X-00017389');
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-251104-0003','F325201226371','AAT','1','BELI','BELI001','H2J', 'X-00017389', 'KL X MILANO KH 44 9K','3.070','3.070','100.00','3592000','2935000','956026','1100000','1','2935000','2935000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.070',berat_beli_asli=berat_beli_asli+'3.070',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.070',berat_akhir_asli=berat_akhir_asli+'3.070',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2J' 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-251104-0003','2025-11-04','2025-11-04','12:14:22','AAT','---','3.070','2935000','2935000','2935000','2935000','2935000','kasir','2025-11-04 12:14:23','FB-251104-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251104-0003','CICI','BITING BADEGAN','','','','kasir','2025-11-04 12:14:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-04' 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-251104-0014','K','2025-11-04','12:14:22','kasir','PEMBELIAN UMUM','FB-251104-0003','565200000','2935000','562265000');
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-00017390','X-00017390','CC COR M 8K','GR','---','E2E','BELI','BELI001','1075000','2025-11-04','1.750','1','kasir','2025-11-04 13:40:48');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00017390','X-00017390');
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-251104-0004','F323021046001','FIT','1','BELI','BELI001','E2E', 'X-00017390', 'CC COR M 8K','1.750','1.750','100.00','787000','1075000','614286','1000000','1','1075000','1075000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.750',berat_beli_asli=berat_beli_asli+'1.750',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.750',berat_akhir_asli=berat_akhir_asli+'1.750',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251104-0004','2025-11-04','2025-11-04','13:40:48','FIT','---','1.750','1075000','1075000','1075000','1075000','1075000','kasir','2025-11-04 13:40:48','FB-251104-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251104-0004','NIA','BANGSRI','','','','kasir','2025-11-04 13:40:48');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-04' 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-251104-0015','K','2025-11-04','13:40:48','kasir','PEMBELIAN UMUM','FB-251104-0004','562265000','1075000','561190000');
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-00017391','X-00017391','CC COR M 8K','GR','---','E2E','BELI','BELI001','1040000','2025-11-04','1.700','1','kasir','2025-11-04 13:42:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00017391','X-00017391');
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-251104-0005','F323021046002','FIT','1','BELI','BELI001','E2E', 'X-00017391', 'CC COR M 8K','1.700','1.700','100.00','787000','1040000','611765','1000000','1','1040000','1040000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.700',berat_beli_asli=berat_beli_asli+'1.700',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.700',berat_akhir_asli=berat_akhir_asli+'1.700',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251104-0005','2025-11-04','2025-11-04','13:42:50','FIT','---','1.700','1040000','1040000','1040000','1040000','1040000','kasir','2025-11-04 13:42:51','FB-251104-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251104-0005','NIA','BANGSRI','','','','kasir','2025-11-04 13:42:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-04' 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-251104-0016','K','2025-11-04','13:42:50','kasir','PEMBELIAN UMUM','FB-251104-0005','561190000','1040000','560150000');
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 ('F325040226311','kasir','1',' MHA1H LG ','TOKO','PM-A','A1H-YJCX-33-0','AT DAISY MATA LG 8K','','0.250','1','100.00','265000','0','0','15000','263000','0','0','0','263000','SIN','00375245','A1H','0','0','-','1','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-11-04', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1H-YJCX-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2025-11-04' AND kode_barang='A1H-YJCX-33-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 ('F325040226311','2025-11-04','0.250','2025-11-04','14:26:31','PLG0025540','263000','263000','0','263000','263000','kasir','2025-11-04 14:26:31','F32504022631');
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-04','F325040226311','2025-11-04','14:26:31','SIN','263000','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-251104-0017','D','2025-11-04','14:26:31','kasir','PENJUALAN','F325040226311','560150000','263000','560413000');
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-00017392','X-00017392','CC X METRO HATI MATA BIRU LG 19','GR','---','E2TE','BELI','BELI001','1450000','2025-11-04','1.350','1','kasir','2025-11-04 14:52:12');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00017392','X-00017392');
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-251104-0006','F322060239561','FIT','1','BELI','BELI001','E2TE', 'X-00017392', 'CC X METRO HATI MATA BIRU LG 19','1.350','1.350','100.00','1020000','1450000','1074074','1800000','1','1450000','1450000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.350',berat_beli_asli=berat_beli_asli+'1.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.350',berat_akhir_asli=berat_akhir_asli+'1.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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-251104-0006','2025-11-04','2025-11-04','14:52:12','FIT','---','1.350','1450000','1450000','1450000','1450000','1450000','kasir','2025-11-04 14:52:12','FB-251104-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251104-0006','KAYLA','PUCUNG KISMANTORO','','','','kasir','2025-11-04 14:52:12');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-04' 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-251104-0018','K','2025-11-04','14:52:12','kasir','PEMBELIAN UMUM','FB-251104-0006','560413000','1450000','558963000');
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-00017393','X-00017393','LT COR T 8K','GR','---','D1E','BELI','BELI001','1710000','2025-11-04','2.000','1','kasir','2025-11-04 14:54:32');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1E','X-00017393','X-00017393');
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-251104-0007','00369095','AAT','1','BELI','BELI001','D1E', 'X-00017393', 'LT COR T 8K','2.000','2.000','100.00','1902000','1710000','855000','1000000','1','1710000','1710000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.000',berat_beli_asli=berat_beli_asli+'2.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.000',berat_akhir_asli=berat_akhir_asli+'2.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-04' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1E' 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-251104-0007','2025-11-04','2025-11-04','14:54:32','AAT','---','2.000','1710000','1710000','1710000','1710000','1710000','kasir','2025-11-04 14:54:32','FB-251104-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251104-0007','BUYUNG','PO','','','','kasir','2025-11-04 14:54:32');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-04' 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-251104-0019','K','2025-11-04','14:54:32','kasir','PEMBELIAN UMUM','FB-251104-0007','558963000','1710000','557253000');
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-00017394','X-00017394','AT JERSY POLOS LG 8K','GR','---','A1E','BELI','BELI001','470000','2025-11-04','0.510','1','kasir','2025-11-04 14:55:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00017394','X-00017394');
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-251104-0008','F325140118311','SIN','1','BELI','BELI001','A1E', 'X-00017394', 'AT JERSY POLOS LG 8K','0.510','0.510','100.00','525000','470000','921569','1000000','1','470000','470000','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-04' 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-251104-0008','2025-11-04','2025-11-04','14:55:36','SIN','---','0.510','470000','470000','470000','470000','470000','kasir','2025-11-04 14:55:37','FB-251104-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251104-0008','RUNI','JERUK','','','','kasir','2025-11-04 14:55:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-04' 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-251104-0020','K','2025-11-04','14:55:36','kasir','PEMBELIAN UMUM','FB-251104-0008','557253000','470000','556783000');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251104-0001','1','F3TE-YFAA-87-T','1','3.050','3.050','TOKO','PT-F','TOKO','TBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='TBK-F' WHERE kode_barang='F3TE-YFAA-87-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PT-F';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-11-04','TOKO','TBK-F','F3TE','F3TE-YFAA-87-T','100.00','1','3.050','3.050','1','3.050','3.050');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.050',berat_out_asli=berat_out_asli+'3.050',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-04' AND kode_barang='F3TE-YFAA-87-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PT-F' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251104-0001','2025-11-04','2025-11-04','15:03','3.05','input','2025-11-04 15:04:12');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325040226311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325040226311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325040226311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325040826191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325040826191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325040826191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325040826192' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325040826192' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325040826192';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325040902141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325040902141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325040902141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325040954431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325040954431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325040954431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325041018111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325041018111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325041018111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325041032191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325041032191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325041032191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325041032192' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325041032192' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325041032192';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325041036121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325041036121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325041036121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325041114241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325041114241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325041114241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325041122111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325041122111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325041122111';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251104-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251104-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251104-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251104-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251104-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251104-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251104-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251104-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251104-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251104-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251104-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251104-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251104-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251104-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251104-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251104-0008';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-05','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-05';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-04';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-04';
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-04' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-04';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-04';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-04';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-04';
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-05' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-04' 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-251105-0001','D','2025-11-05','15:36:04','SYSTEM','SALDO AWAL','SALDO AWAL','0','556783000','556783000');
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-251105-0001','D','2025-11-05','15:36:04','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-251105-0001','D','2025-11-05','15:36:04','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-251105-0001','D','2025-11-05','15:36:04','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
UPDATE tp_system SET tgl_system='2025-11-05';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251105-0001','1','F3TE-YFAA-87-T','1','3.050','TOKO','TBK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3TE-YFAA-87-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3TE-YFAA-87-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_dept_export WHERE kode_dept='F3TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold2.tm_lokasi_toko_export WHERE kode_lokasi_toko='TBK-F';
INSERT INTO db_nagagold_dewigold2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='TBK-F';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='F3TE-YFAA-87-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.050',berat_out_asli='3.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.050',berat_akhir_asli =berat_akhir_asli-'3.050' WHERE kode_barang='F3TE-YFAA-87-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-251105-0001','2025-11-05','2025-11-05','16:20','3.050','admpindah','251105');
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-20251105-0001','1','F4I-YKXD-98-0','1','1.930','1.930','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F4I-YKXD-98-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F4I-YKXD-98-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-11-05 16:58:50' WHERE kode_barang='F4I-YKXD-98-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F4I-YKXD-98-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-05 16:58:50','TOKO','PM-F','F4I','F4I-YKXD-98-0','1','1.930','1.930','1','1.930','1.930','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-YKXD-98-0';
DELETE FROM tm_barang_export WHERE kode_barang='F4I-YKXD-98-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-20251105-0001','1','F3E-YKXD-99-0','1','2.700','2.700','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YKXD-99-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YKXD-99-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-11-05 16:58:50' WHERE kode_barang='F3E-YKXD-99-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YKXD-99-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-05 16:58:50','TOKO','PM-F','F3E','F3E-YKXD-99-0','1','2.700','2.700','1','2.700','2.700','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-YKXD-99-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YKXD-99-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-20251105-0001','1','F3E-YKXD-100-0','1','3.920','3.920','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YKXD-100-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YKXD-100-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-11-05 16:58:50' WHERE kode_barang='F3E-YKXD-100-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YKXD-100-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-05 16:58:50','TOKO','PM-F','F3E','F3E-YKXD-100-0','1','3.920','3.920','1','3.920','3.920','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-YKXD-100-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YKXD-100-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-20251105-0001','1','F3E-YKXD-101-0','1','1.330','1.330','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YKXD-101-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YKXD-101-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-11-05 16:58:50' WHERE kode_barang='F3E-YKXD-101-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YKXD-101-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-05 16:58:50','TOKO','PM-F','F3E','F3E-YKXD-101-0','1','1.330','1.330','1','1.330','1.330','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-YKXD-101-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YKXD-101-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-20251105-0001','1','F3E-YKXD-102-0','1','3.280','3.280','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YKXD-102-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YKXD-102-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-11-05 16:58:50' WHERE kode_barang='F3E-YKXD-102-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YKXD-102-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-05 16:58:50','TOKO','PM-F','F3E','F3E-YKXD-102-0','1','3.280','3.280','1','3.280','3.280','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-YKXD-102-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YKXD-102-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-20251105-0001','1','F3E-YKXD-103-0','1','3.950','3.950','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YKXD-103-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YKXD-103-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-11-05 16:58:50' WHERE kode_barang='F3E-YKXD-103-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YKXD-103-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-05 16:58:50','TOKO','PM-F','F3E','F3E-YKXD-103-0','1','3.950','3.950','1','3.950','3.950','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-YKXD-103-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YKXD-103-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-20251105-0001','1','F3E-YKXD-104-0','1','1.580','1.580','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YKXD-104-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YKXD-104-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-11-05 16:58:50' WHERE kode_barang='F3E-YKXD-104-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YKXD-104-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-05 16:58:50','TOKO','PM-F','F3E','F3E-YKXD-104-0','1','1.580','1.580','1','1.580','1.580','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-YKXD-104-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YKXD-104-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-20251105-0001','1','F3F-YKXD-105-0','1','0.520','0.520','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3F-YKXD-105-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3F-YKXD-105-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2025-11-05 16:58:50' WHERE kode_barang='F3F-YKXD-105-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3F-YKXD-105-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-05 16:58:50','TOKO','PM-F','F3F','F3F-YKXD-105-0','1','0.520','0.520','1','0.520','0.520','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-YKXD-105-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3F-YKXD-105-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251105-0001','2025-11-05','16:58','19.210','admpindah','2025-11-04 16:58:49');