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 ('F326250846191','input','1',' MDE1 PM 14','TOKO','PM-E','E1D-ZDAC-112-0','CC MODEL DAUN VAR PM 14 8K ','','0.960','1','100.00','1070000','0','0','15000','1070000','0','0','0','1070000','AAT','00399282','E1D','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDAC-112-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='E1D-ZDAC-112-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 ('F326250846191','2026-04-25','0.960','2026-04-25','08:46:19','PLG0028810','1070000','1070000','0','1070000','1070000','input','2026-04-25 08:46:19','F32625084619');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','F326250846191','2026-04-25','08:46:19','AAT','1070000','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-260425-0002','D','2026-04-25','08:46:19','input','PENJUALAN','F326250846191','4613303000','1070000','4614373000');
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 ('F326250851211','input','1',' MDE1 PM 16','TOKO','PM-E','E1D-ZDAC-115-0','CC MODEL DAUN VAR PM 16 8K ','','1.010','1','100.00','1126000','0','0','15000','1126000','0','0','0','1126000','SIN','00399285','E1D','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDAC-115-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='E1D-ZDAC-115-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 ('F326250851211','2026-04-25','1.010','2026-04-25','08:51:21','PLG0028811','1126000','1126000','0','1126000','1126000','input','2026-04-25 08:51:21','F32625085121');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','F326250851211','2026-04-25','08:51:21','SIN','1126000','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-260425-0003','D','2026-04-25','08:51:21','input','PENJUALAN','F326250851211','4614373000','1126000','4615499000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1126000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326250851211' 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 ('F326250851212','input',' 1',' MEE1 5K CM','TOKO','PM-E','E1E-ZDBC-201-0','CC MODEL PITA PASIR CM 14 8K ','','0.730','1','100.00','829000','0','0','15000','830000','0','5000','0','835000','SIN','00400923','E1E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBC-201-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='2026-04-25' AND kode_barang='E1E-ZDBC-201-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 ('F326250851212','2026-04-25','0.730','2026-04-25','08:51:21','PLG0028812','830000','830000','5000','835000','835000','input','2026-04-25 08:51:21','F32625085121');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','F326250851212','2026-04-25','08:51:21','SIN','835000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260425-0004','D','2026-04-25','08:51:21','input','PENJUALAN','F326250851212','4615499000','835000','4616334000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='835000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326250851212' 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 ('F326250851213','input',' 1',' MEE1 HW ','TOKO','PM-E','E1E-ZABX-85-0','CC COR MODEL SLEP HW 8K ','','0.470','1','100.00','533000','0','0','15000','533000','0','0','0','533000','SIN','00386314','E1E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZABX-85-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='E1E-ZABX-85-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 ('F326250851213','2026-04-25','0.470','2026-04-25','08:51:21','PLG0028813','533000','533000','0','533000','533000','input','2026-04-25 08:51:21','F32625085121');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','F326250851213','2026-04-25','08:51:21','SIN','533000','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-260425-0005','D','2026-04-25','08:51:21','input','PENJUALAN','F326250851213','4616334000','533000','4616867000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='533000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326250851213' 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 ('F326250900481','input','1',' MED1E LG ','TOKO','PM-D','D1E-ZDAE-172-0','LT MODEL HATI SLEP LG 8K ','','0.500','1','100.00','567000','0','0','15000','568000','0','0','0','568000','FIT','00399458','D1E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZDAE-172-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='2026-04-25' AND kode_barang='D1E-ZDAE-172-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 ('F326250900481','2026-04-25','0.500','2026-04-25','09:00:49','PLG0028814','568000','568000','0','568000','568000','input','2026-04-25 09:00:48','F32625090048');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','F326250900481','2026-04-25','09:00:49','FIT','568000','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-260425-0006','D','2026-04-25','09:00:49','input','PENJUALAN','F326250900481','4616867000','568000','4617435000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='568000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326250900481' 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 ('F326250900482','input',' 1',' MIH2 X KH ','TOKO','PM-H','H2I-ZCXB-351-0','KL X SIEM SINGEL KH 46 9K ','','3.930','1','100.00','4775000','0','0','15000','4775000','0','0','0','4775000','FIT','00391774','H2I','0','0','-','0','1215000');
UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-ZCXB-351-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.930',berat_jual_asli=berat_jual_asli+'3.930',stock_jual='1',berat_akhir=berat_akhir-'3.930',berat_akhir_asli=berat_akhir_asli-'3.930',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='H2I-ZCXB-351-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 ('F326250900482','2026-04-25','3.930','2026-04-25','09:00:49','PLG0028815','4775000','4775000','0','4775000','4775000','input','2026-04-25 09:00:48','F32625090048');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','F326250900482','2026-04-25','09:00:49','FIT','4775000','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-260425-0007','D','2026-04-25','09:00:49','input','PENJUALAN','F326250900482','4617435000','4775000','4622210000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4775000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326250900482' 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 ('F326251028551','input','1',' MDD2D X CM','TOKO','PM-D','D2D-ZCCX-383-0','LT X MODEL MATA CM 8K ','','0.820','1','100.00','914000','0','0','15000','915000','0','0','0','915000','LIS','00397037','D2D','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZCCX-383-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.820',berat_jual_asli=berat_jual_asli+'0.820',stock_jual='1',berat_akhir=berat_akhir-'0.820',berat_akhir_asli=berat_akhir_asli-'0.820',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='D2D-ZCCX-383-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 ('F326251028551','2026-04-25','0.820','2026-04-25','10:28:56','PLG0028816','915000','915000','0','915000','915000','input','2026-04-25 10:28:55','F32625102855');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','F326251028551','2026-04-25','10:28:56','LIS','915000','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-260425-0008','D','2026-04-25','10:28:56','input','PENJUALAN','F326251028551','4622210000','915000','4623125000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='915000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326251028551' 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 ('F326251028552','input',' 1',' MEH1 UB 40','TOKO','PM-H','H1E-ZDBC-219-0','KL MILANO UB 40CM 8K ','','4.130','1','100.00','4688000','0','0','15000','4688000','0','0','0','4688000','LIS','00400941','H1E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDBC-219-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.130',berat_jual_asli=berat_jual_asli+'4.130',stock_jual='1',berat_akhir=berat_akhir-'4.130',berat_akhir_asli=berat_akhir_asli-'4.130',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='H1E-ZDBC-219-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 ('F326251028552','2026-04-25','4.130','2026-04-25','10:28:56','PLG0028817','4688000','4688000','0','4688000','4688000','input','2026-04-25 10:28:55','F32625102855');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','F326251028552','2026-04-25','10:28:56','LIS','4688000','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-260425-0009','D','2026-04-25','10:28:56','input','PENJUALAN','F326251028552','4623125000','4688000','4627813000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4688000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326251028552' 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 ('F326251041491','input','1',' MJH2 X UB ','TOKO','PM-H','H2J-ZCBD-5-0','KL X GUCCI UB 44 9K ','','3.030','1','100.00','3742000','0','0','15000','3743000','0','0','0','3743000','FIT','00396485','H2J','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZCBD-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.030',berat_jual_asli=berat_jual_asli+'3.030',stock_jual='1',berat_akhir=berat_akhir-'3.030',berat_akhir_asli=berat_akhir_asli-'3.030',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='H2J-ZCBD-5-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 ('F326251041491','2026-04-25','3.030','2026-04-25','10:41:50','PLG0028818','3743000','3743000','0','3743000','3743000','input','2026-04-25 10:41:49','F32625104149');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','F326251041491','2026-04-25','10:41:50','FIT','3743000','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-260425-0010','D','2026-04-25','10:41:50','input','PENJUALAN','F326251041491','4627813000','3743000','4631556000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3743000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326251041491' 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 ('F326251041492','input',' 1',' MEF3E X HW','TOKO','PM-F','F3E-ZDBX-80-0','GL X CASTELI SPECTRA VAR HW 8K ','','1.850','1','100.00','2100000','0','0','15000','2100000','0','0','0','2100000','FIT','00400015','F3E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDBX-80-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='F3E-ZDBX-80-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 ('F326251041492','2026-04-25','1.850','2026-04-25','10:41:50','PLG0028819','2100000','2100000','0','2100000','2100000','input','2026-04-25 10:41:49','F32625104149');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','F326251041492','2026-04-25','10:41:50','FIT','2100000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260425-0011','D','2026-04-25','10:41:50','input','PENJUALAN','F326251041492','4631556000','2100000','4633656000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2100000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326251041492' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00018922','X-00018922','CC X MODEL MATA CM 14 8K','GR','---','E2D','BELI','BELI001','1182000','2026-04-25','1.130','1','kasir','2026-04-25 12:02:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00018922','X-00018922');
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-260425-0001','F326080836191','LIS','1','BELI','BELI001','E2D', 'X-00018922', 'CC X MODEL MATA CM 14 8K','1.130','1.130','100.00','1355000','1182000','1046018','1125000','1','1182000','1182000','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 ='2026-04-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260425-0001','2026-04-25','2026-04-25','12:02:36','LIS','---','1.130','1182000','1182000','1182000','1182000','1182000','kasir','2026-04-25 12:02:37','FB-260425-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260425-0001','HENI','GENENG BULUKERTO','','','','kasir','2026-04-25 12:02:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-25' 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-260425-0012','K','2026-04-25','12:02:36','kasir','PEMBELIAN UMUM','FB-260425-0001','4633656000','1182000','4632474000');
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-00018923','X-00018923','GL OVAL MODEL C UB D54 8K','GR','---','F1E','BELI','BELI001','1700000','2026-04-25','2.230','1','kasir','2026-04-25 12:03:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00018923','X-00018923');
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-260425-0002','F325301219071','AAT','1','BELI','BELI001','F1E', 'X-00018923', 'GL OVAL MODEL C UB D54 8K','2.230','2.230','100.00','1740000','1700000','762332','1145000','1','1700000','1700000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.230',berat_beli_asli=berat_beli_asli+'2.230',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.230',berat_akhir_asli=berat_akhir_asli+'2.230',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-25' 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-260425-0002','2026-04-25','2026-04-25','12:03:17','AAT','---','2.230','1700000','1700000','1700000','1700000','1700000','kasir','2026-04-25 12:03:18','FB-260425-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260425-0002','TRI SEPTIANI NINGSIH','PAKEL SAMPUNG','','','','kasir','2026-04-25 12:03:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-25' 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-260425-0013','K','2026-04-25','12:03:17','kasir','PEMBELIAN UMUM','FB-260425-0002','4632474000','1700000','4630774000');
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-00018924','X-00018924','LT COR M 8K','GR','---','D2F','BELI','BELI001','282000','2026-04-25','0.480','1','kasir','2026-04-25 12:04:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2F','X-00018924','X-00018924');
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-260425-0003','00170936','AAT','1','BELI','BELI001','D2F', 'X-00018924', 'LT COR M 8K','0.480','0.480','100.00','218000','282000','587500','1165000','1','282000','282000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.480',berat_beli_asli=berat_beli_asli+'0.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.480',berat_akhir_asli=berat_akhir_asli+'0.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2F' 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-260425-0003','2026-04-25','2026-04-25','12:04:28','AAT','---','0.480','282000','282000','282000','282000','282000','kasir','2026-04-25 12:04:29','FB-260425-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260425-0003','TIAAN','POHIJO SAMPUNG','','','','kasir','2026-04-25 12:04:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-25' 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-260425-0014','K','2026-04-25','12:04:28','kasir','PEMBELIAN UMUM','FB-260425-0003','4630774000','282000','4630492000');
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-00018925','X-00018925','KL TIFF LT 42 8K','GR','---','H1E','BELI','BELI001','810000','2026-04-25','1.050','1','kasir','2026-04-25 12:05:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00018925','X-00018925');
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-260425-0004','F325150914551','SIN','1','BELI','BELI001','H1E', 'X-00018925', 'KL TIFF LT 42 8K','1.050','1.050','100.00','780000','810000','771429','1145000','1','810000','810000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260425-0004','2026-04-25','2026-04-25','12:05:01','SIN','---','1.050','810000','810000','810000','810000','810000','kasir','2026-04-25 12:05:02','FB-260425-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260425-0004','TIKA','PURWANTORO','','','','kasir','2026-04-25 12:05:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-25' 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-260425-0015','K','2026-04-25','12:05:01','kasir','PEMBELIAN UMUM','FB-260425-0004','4630492000','810000','4629682000');
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 ('F326251228361','kasir','1',' MEE2 X HT ','TOKO','PM-E','E2E-ZDBX-313-0','CC X PIPA MATA HT 20 ','','0.460','1','100.00','522000','0','0','15000','523000','0','0','0','523000','SIN','00400250','E2E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDBX-313-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='2026-04-25' AND kode_barang='E2E-ZDBX-313-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 ('F326251228361','2026-04-25','0.460','2026-04-25','12:28:37','PLG0028820','523000','523000','0','523000','523000','kasir','2026-04-25 12:28:36','F32625122836');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','F326251228361','2026-04-25','12:28:37','SIN','523000','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-260425-0016','D','2026-04-25','12:28:37','kasir','PENJUALAN','F326251228361','4629682000','523000','4630205000');
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 ('F326250117021','kasir','1',' MDE2 10K C','TOKO','PM-E','E2D-ZDAC-103-0','CC WEDDING MATA CM 16 8K ','','0.850','1','100.00','948000','0','0','15000','948000','0','10000','0','958000','AAT','00399273','E2D','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDAC-103-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='E2D-ZDAC-103-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 ('F326250117021','2026-04-25','0.850','2026-04-25','13:17:02','PLG0028821','948000','948000','10000','958000','958000','kasir','2026-04-25 13:17:02','F32625011702');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','F326250117021','2026-04-25','13:17:02','AAT','958000','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-260425-0017','D','2026-04-25','13:17:02','kasir','PENJUALAN','F326250117021','4630205000','958000','4631163000');
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 ('F326250119391','kasir','1',' MFPF HW ','TOKO','PM-P','PFF-YKBI-192-0','GL WG HARLEY HW 8K ','','1.990','1','100.00','2298000','0','0','15000','2298000','0','0','0','2298000','FIT','00379158','PFF','0','0','-','0','1165000');
UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PFF-YKBI-192-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.990',berat_jual_asli=berat_jual_asli+'1.990',stock_jual='1',berat_akhir=berat_akhir-'1.990',berat_akhir_asli=berat_akhir_asli-'1.990',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='PFF-YKBI-192-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-P' 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 ('F326250119391','2026-04-25','1.990','2026-04-25','13:19:40','PLG0028822','2298000','2298000','0','2298000','2298000','kasir','2026-04-25 13:19:39','F32625011939');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','F326250119391','2026-04-25','13:19:40','FIT','2298000','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-260425-0018','D','2026-04-25','13:19:40','kasir','PENJUALAN','F326250119391','4631163000','2298000','4633461000');
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 ('F326250126391','kasir','1',' MHA1 CM ','TOKO','PM-A','A1H-ZDXG-167-0','AT TINDIK BABY CM 8K ','','0.250','1','100.00','299000','0','0','15000','300000','0','0','0','300000','SIN','00398342','A1H','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1H-ZDXG-167-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='2026-04-25' AND kode_barang='A1H-ZDXG-167-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 ('F326250126391','2026-04-25','0.250','2026-04-25','13:26:39','PLG0028823','300000','300000','0','300000','300000','kasir','2026-04-25 13:26:39','F32625012639');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','F326250126391','2026-04-25','13:26:39','SIN','300000','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-260425-0019','D','2026-04-25','13:26:39','kasir','PENJUALAN','F326250126391','4633461000','300000','4633761000');
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 ('F326250134571','kasir','1',' MEH1 X HW ','TOKO','PM-H','H1E-ZCBE-285-0','KL X NORI BONEKA ANAK CAT HW 8K ','','2.160','1','100.00','2452000','0','0','15000','2450000','0','0','0','2450000','AAT','00396747','H1E','0','0','-','1','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCBE-285-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.160',berat_jual_asli=berat_jual_asli+'2.160',stock_jual='1',berat_akhir=berat_akhir-'2.160',berat_akhir_asli=berat_akhir_asli-'2.160',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='H1E-ZCBE-285-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 ('F326250134571','2026-04-25','2.160','2026-04-25','13:34:58','PLG0028824','2450000','2450000','0','2450000','2450000','kasir','2026-04-25 13:34:57','F32625013457');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','F326250134571','2026-04-25','13:34:58','AAT','2450000','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-260425-0020','D','2026-04-25','13:34:58','kasir','PENJUALAN','F326250134571','4633761000','2450000','4636211000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2450000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326250134571' 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 ('F326250134572','kasir',' 1',' MEF2 PM D4','TOKO','PM-F','F2E-ZBAF-95-0','GL ANAK PIPA MODEL MATA PM D40 8K ','','1.970','1','100.00','2236000','0','0','15000','2235000','0','0','0','2235000','AAT','00390067','F2E','0','0','-','1','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZBAF-95-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='F2E-ZBAF-95-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 ('F326250134572','2026-04-25','1.970','2026-04-25','13:34:58','PLG0028825','2235000','2235000','0','2235000','2235000','kasir','2026-04-25 13:34:57','F32625013457');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','F326250134572','2026-04-25','13:34:58','AAT','2235000','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-260425-0021','D','2026-04-25','13:34:58','kasir','PENJUALAN','F326250134572','4636211000','2235000','4638446000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2235000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326250134572' 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 ('F326250135481','kasir','1',' MEF3E X UB','TOKO','PM-F','F3E-ZDBX-120-0','GL X TIFF SPECTRA SERUT VAR UB 8K ','','1.610','1','100.00','1827000','0','0','15000','1828000','0','10000','0','1838000','FIT','00400057','F3E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDBX-120-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.610',berat_jual_asli=berat_jual_asli+'1.610',stock_jual='1',berat_akhir=berat_akhir-'1.610',berat_akhir_asli=berat_akhir_asli-'1.610',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='F3E-ZDBX-120-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 ('F326250135481','2026-04-25','1.610','2026-04-25','13:35:48','PLG0028826','1828000','1828000','10000','1838000','1838000','kasir','2026-04-25 13:35:48','F32625013548');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','F326250135481','2026-04-25','13:35:48','FIT','1838000','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-260425-0022','D','2026-04-25','13:35:48','kasir','PENJUALAN','F326250135481','4638446000','1838000','4640284000');
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 ('F326250203431','kasir','1',' MGS1G X DG','TOKO','PM-S','S1G-ZDAH-1-0','AS X EXTENTION DG 8K ','','0.430','1','100.00','505000','0','0','15000','505000','0','0','0','505000','LIS','00399702','S1G','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZDAH-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='S1G-ZDAH-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-S' 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 ('F326250203431','2026-04-25','0.430','2026-04-25','14:03:44','PLG0028827','505000','505000','0','505000','505000','kasir','2026-04-25 14:03:43','F32625020343');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','F326250203431','2026-04-25','14:03:44','LIS','505000','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-260425-0023','D','2026-04-25','14:03:44','kasir','PENJUALAN','F326250203431','4640284000','505000','4640789000');
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-00018926','X-00018926','CC X MODEL MATA VAR HW 13 17K','GR','---','E2TE','BELI','BELI001','2730000','2026-04-25','1.550','1','kasir','2026-04-25 14:06:19');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00018926','X-00018926');
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-260425-0005','F325270924331','FIT','1','BELI','BELI001','E2TE', 'X-00018926', 'CC X MODEL MATA VAR HW 13 17K','1.550','1.550','100.00','2906000','2730000','1761290','2080000','1','2730000','2730000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.550',berat_beli_asli=berat_beli_asli+'1.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.550',berat_akhir_asli=berat_akhir_asli+'1.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-25' 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-260425-0005','2026-04-25','2026-04-25','14:06:19','FIT','---','1.550','2730000','2730000','2730000','2730000','2730000','kasir','2026-04-25 14:06:19','FB-260425-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260425-0005','SUSAN','SIGERENG','','','','kasir','2026-04-25 14:06:19');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-25' 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-260425-0024','K','2026-04-25','14:06:19','kasir','PEMBELIAN UMUM','FB-260425-0005','4640789000','2730000','4638059000');
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-00018927','X-00018927','CC MODEL PITA PASIR CM 14 8K','GR','---','E1E','BELI','BELI001','788000','2026-04-25','0.700','1','kasir','2026-04-25 14:06:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00018927','X-00018927');
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-260425-0006','F326230218571','AAT','1','BELI','BELI001','E1E', 'X-00018927', 'CC MODEL PITA PASIR CM 14 8K','0.700','0.700','100.00','798000','788000','1125714','1145000','1','788000','788000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.700',berat_beli_asli=berat_beli_asli+'0.700',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.700',berat_akhir_asli=berat_akhir_asli+'0.700',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-25' 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-260425-0006','2026-04-25','2026-04-25','14:06:40','AAT','---','0.700','788000','788000','788000','788000','788000','kasir','2026-04-25 14:06:41','FB-260425-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260425-0006','YANA','KARANGLO PURWANTORO','','','','kasir','2026-04-25 14:06:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-25' 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-260425-0025','K','2026-04-25','14:06:40','kasir','PEMBELIAN UMUM','FB-260425-0006','4638059000','788000','4637271000');
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0002953' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0002941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0002939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0002936' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0002933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0002942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0002950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0002947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0002945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0002944' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0002931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0002930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3920500',harga_beli ='3920500' WHERE kode_barcode='T0002720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='11940000',harga_beli ='11940000' WHERE kode_barcode='T0002458' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0002457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0002456' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0002454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0002451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='11860500',harga_beli ='11860500' WHERE kode_barcode='T0002721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9910500',harga_beli ='9910500' WHERE kode_barcode='T0002722' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0002929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0002927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0002450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0002978' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0002977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0002976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0002975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0002963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0002962' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0002961' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0002960' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0002959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0002964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0002965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0002971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0002970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0002969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0002967' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0002966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0002954' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0002392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0002390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0002389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0002394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0002402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0002369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0002367' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0002366' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0002370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0002371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0002380' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0002378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0002377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0002376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0002374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0002372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0002360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='19900000',harga_beli ='19900000' WHERE kode_barcode='T0002449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0002435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0002432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0002430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0002448' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0002447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0002446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0002445' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0002427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0002409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0002408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0002407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0002415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0002425' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0002421' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0002420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003607' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0003609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0003610' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0003611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0003622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0003623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003631' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003641' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003643' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0003647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0003648' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0003657' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0003670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0003672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0003673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0003674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0003676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0003677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0003678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003574' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='935500',harga_beli ='935500' WHERE kode_barcode='T0003412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003994' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0004018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0004015' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0004014' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0004012' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0003885' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0003886' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0003887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0003888' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0003889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0003890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0003891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0003892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0003893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0003894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0003896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0003897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0003899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003904' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003916' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003921' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003930' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003931' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0003932' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0003933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0003935' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0003937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0003939' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0003940' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0003941' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0003942' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0003943' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0003944' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0003946' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0003947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0003948' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0003949' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0003950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0004083' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0004084' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0004149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0004150' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0004153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0004158' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0004161' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0004162' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0004165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0004167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0004168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='11940000',harga_beli ='11940000' WHERE kode_barcode='T0004170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='11940000',harga_beli ='11940000' WHERE kode_barcode='T0004171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='11940000',harga_beli ='11940000' WHERE kode_barcode='T0004172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='15920000',harga_beli ='15920000' WHERE kode_barcode='T0004175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='19900000',harga_beli ='19900000' WHERE kode_barcode='T0004177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='13930000',harga_beli ='13930000' WHERE kode_barcode='T0004185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0004191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0004195' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0004196' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='13930000',harga_beli ='13930000' WHERE kode_barcode='T0004199' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='13930000',harga_beli ='13930000' WHERE kode_barcode='T0004200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2089500',harga_beli ='2089500' WHERE kode_barcode='T0009250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0029917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0027569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0027572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0027624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0027626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='11980000',harga_beli ='11980000' WHERE kode_barcode='T0029878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1950500',harga_beli ='1950500' WHERE kode_barcode='T0032972' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7900500',harga_beli ='7900500' WHERE kode_barcode='T0032971' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0032970' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0032968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2010000',harga_beli ='2010000' WHERE kode_barcode='T0032966' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1950500',harga_beli ='1950500' WHERE kode_barcode='T0032965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0032964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0032974' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0032975' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3900500',harga_beli ='3900500' WHERE kode_barcode='T0032963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1055000',harga_beli ='1055000' WHERE kode_barcode='T0033067' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0033058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7900500',harga_beli ='7900500' WHERE kode_barcode='T0034745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5930500',harga_beli ='5930500' WHERE kode_barcode='T0034750' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='15920000',harga_beli ='15920000' WHERE kode_barcode='T0034746' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0035992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0035990' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0035989' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7960000',harga_beli ='7960000' WHERE kode_barcode='T0035987' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0035986' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0035985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0035984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0035983' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0036163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='11144000',harga_beli ='11144000' WHERE kode_barcode='T0036779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2885500',harga_beli ='2885500' WHERE kode_barcode='T0042513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='6010000',harga_beli ='6010000' WHERE kode_barcode='T0043865' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0043877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0043873' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='6010000',harga_beli ='6010000' WHERE kode_barcode='T0043872' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0043871' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='4020000',harga_beli ='4020000' WHERE kode_barcode='T0043870' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0043869' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0043867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0043864' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0043859' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1035000',harga_beli ='1035000' WHERE kode_barcode='T0044183' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0044191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0044193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0044178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3880500',harga_beli ='3880500' WHERE kode_barcode='T0044177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5890500',harga_beli ='5890500' WHERE kode_barcode='T0044176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0044173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0044172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3084500',harga_beli ='3084500' WHERE kode_barcode='T0044171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0044170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0044168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1930500',harga_beli ='1930500' WHERE kode_barcode='T0048348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0048349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0048350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3005000',harga_beli ='3005000' WHERE kode_barcode='T0048351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0048352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3900500',harga_beli ='3900500' WHERE kode_barcode='T0048355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0048356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1890500',harga_beli ='1890500' WHERE kode_barcode='T0048357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0041546' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5870500',harga_beli ='5870500' WHERE kode_barcode='T0052773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0052781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1950500',harga_beli ='1950500' WHERE kode_barcode='T0052780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0052779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2010000',harga_beli ='2010000' WHERE kode_barcode='T0052778' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='4020000',harga_beli ='4020000' WHERE kode_barcode='T0052777' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9791000',harga_beli ='9791000' WHERE kode_barcode='T0052775' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0052774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0052771' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3681500',harga_beli ='3681500' WHERE kode_barcode='T0052770' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7860500',harga_beli ='7860500' WHERE kode_barcode='T0052769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5890500',harga_beli ='5890500' WHERE kode_barcode='T0052768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='19920000',harga_beli ='19920000' WHERE kode_barcode='T0052766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='19920000',harga_beli ='19920000' WHERE kode_barcode='T0052765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0052835' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='995000',harga_beli ='995000' WHERE kode_barcode='T0056350' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0056351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0056352' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0056355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0056356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='955500',harga_beli ='955500' WHERE kode_barcode='T0056800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='4000000',harga_beli ='4000000' WHERE kode_barcode='T0056817' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0056818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9950000',harga_beli ='9950000' WHERE kode_barcode='T0056819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0056821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9990000',harga_beli ='9990000' WHERE kode_barcode='T0056822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7920500',harga_beli ='7920500' WHERE kode_barcode='T0056823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='7920500',harga_beli ='7920500' WHERE kode_barcode='T0056824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='4000000',harga_beli ='4000000' WHERE kode_barcode='T0056825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2885500',harga_beli ='2885500' WHERE kode_barcode='T0056826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0056827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1950500',harga_beli ='1950500' WHERE kode_barcode='T0056828' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1950500',harga_beli ='1950500' WHERE kode_barcode='T0056829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0069555' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0069556' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0069569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0069557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0069560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3980000',harga_beli ='3980000' WHERE kode_barcode='T0069561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0069562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0069563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2985000',harga_beli ='2985000' WHERE kode_barcode='T0069564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='9990000',harga_beli ='9990000' WHERE kode_barcode='T0069566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5970000',harga_beli ='5970000' WHERE kode_barcode='T0069567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='6010000',harga_beli ='6010000' WHERE kode_barcode='T0069568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='955500',harga_beli ='955500' WHERE kode_barcode='T0074545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='915500',harga_beli ='915500' WHERE kode_barcode='T0074546' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='3224000',harga_beli ='3224000' WHERE kode_barcode='T0074549' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='6288500',harga_beli ='6288500' WHERE kode_barcode='T0074550' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1990000',harga_beli ='1990000' WHERE kode_barcode='T0076226' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='2030000',harga_beli ='2030000' WHERE kode_barcode='T0076227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='1950500',harga_beli ='1950500' WHERE kode_barcode='T0076230' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='4060000',harga_beli ='4060000' WHERE kode_barcode='T0076231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='1990000',harga_jual='5870500',harga_beli ='5870500' WHERE kode_barcode='T0038726' LIMIT 1;
UPDATE tm_group SET harga='1990000' WHERE kode_group = 'TA' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('TA','1990000','input','2026-04-25 14:23:11');
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 ('F326250224011','input','1',' TAE0 DW 19','TOKO','PT-E','E0TA-UDAD-87-T','CC ISABELLA DW 19 ','','1.500','1','100.00','2985000','0','0','15000','2985000','0','0','0','2985000','LIS','T0003899','E0TA','0','0','-','0','1990000');
UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0TA-UDAD-87-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='E0TA-UDAD-87-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326250224011','2026-04-25','1.500','2026-04-25','14:24:01','PLG0028828','2985000','2985000','0','2985000','2985000','input','2026-04-25 14:24:01','F32625022401');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','F326250224011','2026-04-25','14:24:01','LIS','2985000','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-260425-0026','D','2026-04-25','14:24:01','input','PENJUALAN','F326250224011','4637271000','2985000','4640256000');
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-00018928','X-00018928','CC EROPA MATA BIRU UB 22 8K','GR','---','E2D','BELI','BELI001','3465000','2026-04-25','3.840','1','kasir','2026-04-25 14:49:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00018928','X-00018928');
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-260425-0007','F325041122111','AAT','1','BELI','BELI001','E2D', 'X-00018928', 'CC EROPA MATA BIRU UB 22 8K','3.840','3.840','100.00','3725000','3465000','902344','1125000','1','3465000','3465000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.840',berat_beli_asli=berat_beli_asli+'3.840',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.840',berat_akhir_asli=berat_akhir_asli+'3.840',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260425-0007','2026-04-25','2026-04-25','14:49:42','AAT','---','3.840','3465000','3465000','3465000','3465000','3465000','kasir','2026-04-25 14:49:42','FB-260425-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260425-0007','IBTI','KISMANTORO','','','','kasir','2026-04-25 14:49:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-25' 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-260425-0027','K','2026-04-25','14:49:42','kasir','PEMBELIAN UMUM','FB-260425-0007','4640256000','3465000','4636791000');
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 ('F326250255571','kasir','1',' MEH1 KH 44','TOKO','PM-H','H1E-ZDXH-118-0','KL NORY 44 CM KH 8K ','','3.100','1','100.00','3518000','0','0','15000','3520000','0','0','0','3520000','LIS','00398570','H1E','0','0','-','0','1145000');
UPDATE tm_barang SET tgl_last_jual='2026-04-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDXH-118-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.100',berat_jual_asli=berat_jual_asli+'3.100',stock_jual='1',berat_akhir=berat_akhir-'3.100',berat_akhir_asli=berat_akhir_asli-'3.100',stock_akhir='0' WHERE tanggal='2026-04-25' AND kode_barang='H1E-ZDXH-118-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 ('F326250255571','2026-04-25','3.100','2026-04-25','14:55:57','PLG0028829','3520000','3520000','0','3520000','3520000','kasir','2026-04-25 14:55:57','F32625025557');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-25','F326250255571','2026-04-25','14:55:57','LIS','3520000','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-260425-0028','D','2026-04-25','14:55:57','kasir','PENJUALAN','F326250255571','4636791000','3520000','4640311000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260425-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260425-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260425-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260425-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260425-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260425-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260425-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260425-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260425-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260425-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260425-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260425-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260425-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260425-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250117021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250117021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250117021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250119391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250119391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250119391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250126391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250126391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250126391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250134571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250134571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250134571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250134572' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250134572' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250134572';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250135481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250135481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250135481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250203431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250203431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250203431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250224011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250224011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250224011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250255571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250255571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250255571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250846191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250846191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250846191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250851211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250851211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250851211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250851212' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250851212' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250851212';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250851213' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250851213' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250851213';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250900481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250900481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250900481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250900482' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250900482' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250900482';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251028551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251028551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251028551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251028552' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251028552' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251028552';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251041491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251041491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251041491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251041492' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251041492' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251041492';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251228361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251228361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251228361';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-26','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-26';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-25';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-25';
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='2026-04-25' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-25';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-25';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-25';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-25';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-26' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-25' 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-260426-0001','D','2026-04-26','15:25:47','SYSTEM','SALDO AWAL','SALDO AWAL','0','4640311000','4640311000');
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-260426-0001','D','2026-04-26','15:25:47','BCA','SALDO AWAL','SALDO AWAL','0','708411000','708411000');
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-260426-0001','D','2026-04-26','15:25:47','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-260426-0001','D','2026-04-26','15:25:47','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-04-26';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260426-0001','1','D1E-ZDBX-266-0','1','0.510','0.510','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-ZDBX-266-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZDBX-266-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-04-26 17:08:47' WHERE kode_barang='D1E-ZDBX-266-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZDBX-266-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 ('2026-04-26 17:08:47','TOKO','PM-D','D1E','D1E-ZDBX-266-0','1','0.510','0.510','1','0.510','0.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' 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='D1E-ZDBX-266-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZDBX-266-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260426-0001','2026-04-26','17:08','0.510','admpindah','2026-04-25 17:08:47');
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-20260426-0001','1','E2E-ZDBE-395-0','1','0.530','0.530','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZDBE-395-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZDBE-395-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-04-26 17:09:00' WHERE kode_barang='E2E-ZDBE-395-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZDBE-395-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 ('2026-04-26 17:09:00','TOKO','PM-E','E2E','E2E-ZDBE-395-0','1','0.530','0.530','1','0.530','0.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' 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='E2E-ZDBE-395-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZDBE-395-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-20260426-0001','1','E2E-ZDBE-396-0','1','0.510','0.510','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZDBE-396-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZDBE-396-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-04-26 17:09:00' WHERE kode_barang='E2E-ZDBE-396-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZDBE-396-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 ('2026-04-26 17:09:00','TOKO','PM-E','E2E','E2E-ZDBE-396-0','1','0.510','0.510','1','0.510','0.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' 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='E2E-ZDBE-396-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZDBE-396-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-20260426-0001','1','E1E-ZDBE-397-0','1','0.400','0.400','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZDBE-397-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZDBE-397-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-04-26 17:09:00' WHERE kode_barang='E1E-ZDBE-397-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZDBE-397-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 ('2026-04-26 17:09:00','TOKO','PM-E','E1E','E1E-ZDBE-397-0','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZDBE-397-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZDBE-397-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-20260426-0001','1','E1G-ZDBE-398-0','1','0.350','0.350','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1G-ZDBE-398-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1G-ZDBE-398-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-04-26 17:09:00' WHERE kode_barang='E1G-ZDBE-398-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1G-ZDBE-398-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 ('2026-04-26 17:09:00','TOKO','PM-E','E1G','E1G-ZDBE-398-0','1','0.350','0.350','1','0.350','0.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1G-ZDBE-398-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1G-ZDBE-398-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-20260426-0001','1','E1E-ZDBE-399-0','1','0.780','0.780','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZDBE-399-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZDBE-399-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-04-26 17:09:00' WHERE kode_barang='E1E-ZDBE-399-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZDBE-399-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 ('2026-04-26 17:09:00','TOKO','PM-E','E1E','E1E-ZDBE-399-0','1','0.780','0.780','1','0.780','0.780','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZDBE-399-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZDBE-399-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-20260426-0001','1','E1E-ZDBE-400-0','1','0.760','0.760','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZDBE-400-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZDBE-400-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-04-26 17:09:00' WHERE kode_barang='E1E-ZDBE-400-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZDBE-400-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 ('2026-04-26 17:09:00','TOKO','PM-E','E1E','E1E-ZDBE-400-0','1','0.760','0.760','1','0.760','0.760','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZDBE-400-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZDBE-400-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-20260426-0001','1','E1E-ZDBE-401-0','1','0.450','0.450','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZDBE-401-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZDBE-401-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-04-26 17:09:00' WHERE kode_barang='E1E-ZDBE-401-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZDBE-401-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 ('2026-04-26 17:09:00','TOKO','PM-E','E1E','E1E-ZDBE-401-0','1','0.450','0.450','1','0.450','0.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZDBE-401-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZDBE-401-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-20260426-0001','1','E1E-ZDBE-402-0','1','0.560','0.560','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZDBE-402-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZDBE-402-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-04-26 17:09:00' WHERE kode_barang='E1E-ZDBE-402-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZDBE-402-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 ('2026-04-26 17:09:00','TOKO','PM-E','E1E','E1E-ZDBE-402-0','1','0.560','0.560','1','0.560','0.560','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZDBE-402-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZDBE-402-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-20260426-0001','1','E1E-ZDBE-403-0','1','0.560','0.560','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZDBE-403-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZDBE-403-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-04-26 17:09:00' WHERE kode_barang='E1E-ZDBE-403-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZDBE-403-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 ('2026-04-26 17:09:00','TOKO','PM-E','E1E','E1E-ZDBE-403-0','1','0.560','0.560','1','0.560','0.560','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZDBE-403-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZDBE-403-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260426-0001','2026-04-26','17:08','4.900','admpindah','2026-04-25 17:09:00');
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-20260426-0001','1','F1E-ZDBX-43-0','1','2.000','2.000','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZDBX-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZDBX-43-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-04-26 17:09:17' WHERE kode_barang='F1E-ZDBX-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZDBX-43-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 ('2026-04-26 17:09:17','TOKO','PM-F','F1E','F1E-ZDBX-43-0','1','2.000','2.000','1','2.000','2.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-ZDBX-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZDBX-43-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260426-0001','2026-04-26','17:09','2.000','admpindah','2026-04-25 17:09:17');