INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-11','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-11';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-10';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-10';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-11-10' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-10';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-10';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-10';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-10';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-11' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-10' 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-251111-0001','D','2025-11-11','08:42:10','SYSTEM','SALDO AWAL','SALDO AWAL','0','2617147000','2617147000');
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-251111-0001','D','2025-11-11','08:42:10','BCA','SALDO AWAL','SALDO AWAL','0','4133818888','4133818888');
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-251111-0001','D','2025-11-11','08:42:10','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
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-251111-0001','D','2025-11-11','08:42:10','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-251111-0001','D','2025-11-11','08:42:10','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251111-0001','D','2025-11-11','08:42:10','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2025-11-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 ('F225110843591','kasir','1',' MDA1D X LG','TOKO','SMBK-A','A1D-YIAB-12-0','AT X MODEL APELL MATA CAT VAR LG 8K ','OL H','1.040','1','100.00','1019000','0','0','15000','1056000','0','10000','0','1066000','NS','00368789','A1D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YIAB-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.040',berat_jual_asli=berat_jual_asli+'1.040',stock_jual='1',berat_akhir=berat_akhir-'1.040',berat_akhir_asli=berat_akhir_asli-'1.040',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='A1D-YIAB-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225110843591','2025-11-11','1.040','2025-11-11','08:44:00','PLG0074692','1056000','1056000','10000','1066000','1066000','kasir','2025-11-11 08:43:59','F22511084359');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110843591','2025-11-11','08:44:00','NS','1066000','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-251111-0002','D','2025-11-11','08:44:00','kasir','PENJUALAN','F225110843591','2617147000','1066000','2618213000');
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 ('F225110844421','kasir','1',' MEB1 LG ','TOKO','SMBK-B','B1E-YJCA-42-T','GW TRIXIE PANJANG MODEL MATA VAR LG 8K ','OL','0.560','1','100.00','560000','0','0','15000','574000','0','5000','0','579000','NS','T0074773','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJCA-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='B1E-YJCA-42-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225110844421','2025-11-11','0.560','2025-11-11','08:44:42','PLG0074693','574000','574000','5000','579000','579000','kasir','2025-11-11 08:44:42','F22511084442');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110844421','2025-11-11','08:44:42','NS','579000','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-251111-0003','D','2025-11-11','08:44:42','kasir','PENJUALAN','F225110844421','2618213000','579000','2618792000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='579000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110844421' 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 ('F225110844422','kasir',' 1',' MEB1 LG ','TOKO','SMBK-B','B1E-YJCA-47-T','GW TRIXIE PANJANG MODEL MATA VAR LG 8K ','OL','0.560','1','100.00','560000','0','0','15000','574000','0','5000','0','579000','NS','T0074778','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJCA-47-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='B1E-YJCA-47-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225110844422','2025-11-11','0.560','2025-11-11','08:44:42','PLG0074694','574000','574000','5000','579000','579000','kasir','2025-11-11 08:44:42','F22511084442');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110844422','2025-11-11','08:44:42','NS','579000','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-251111-0004','D','2025-11-11','08:44:42','kasir','PENJUALAN','F225110844422','2618792000','579000','2619371000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='579000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110844422' 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 ('F225110934551','kasir','1',' MEB1 LG ','TOKO','SMBK-B','B1E-YJBI-18-T','GW TRIXIE PANJANG PITA ARESO LG 8K ','OL','0.590','1','100.00','590000','0','0','15000','614000','0','5000','0','619000','TIN','T0074578','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJBI-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.590',berat_jual_asli=berat_jual_asli+'0.590',stock_jual='1',berat_akhir=berat_akhir-'0.590',berat_akhir_asli=berat_akhir_asli-'0.590',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='B1E-YJBI-18-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225110934551','2025-11-11','0.590','2025-11-11','09:34:55','PLG0074695','614000','614000','5000','619000','619000','kasir','2025-11-11 09:34:55','F22511093455');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110934551','2025-11-11','09:34:55','TIN','619000','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-251111-0005','D','2025-11-11','09:34:55','kasir','PENJUALAN','F225110934551','2619371000','619000','2619990000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='619000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110934551' 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 ('F225110934552','kasir',' 1',' MEB1 LG ','TOKO','SMBK-B','B1E-YJCA-44-T','GW TRIXIE PANJANG MODEL MATA VAR LG 8K ','OL','0.550','1','100.00','550000','0','0','15000','572000','0','5000','0','577000','TIN','T0074775','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJCA-44-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='B1E-YJCA-44-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225110934552','2025-11-11','0.550','2025-11-11','09:34:55','PLG0074696','572000','572000','5000','577000','577000','kasir','2025-11-11 09:34:55','F22511093455');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110934552','2025-11-11','09:34:55','TIN','577000','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-251111-0006','D','2025-11-11','09:34:55','kasir','PENJUALAN','F225110934552','2619990000','577000','2620567000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='577000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110934552' 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 ('F225110934553','kasir',' 1',' MEH1 HW ','TOKO','SMBK-H','H1E-YJCA-25-T','KL RANTAI HOLLOW MODEL CD VAR HW 8K ','OL','2.020','1','100.00','2020000','0','0','15000','2091000','0','10000','0','2101000','TIN','T0074756','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJCA-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='H1E-YJCA-25-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225110934553','2025-11-11','2.020','2025-11-11','09:34:55','PLG0074697','2091000','2091000','10000','2101000','2101000','kasir','2025-11-11 09:34:55','F22511093455');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110934553','2025-11-11','09:34:55','TIN','2101000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251111-0007','D','2025-11-11','09:34:55','kasir','PENJUALAN','F225110934553','2620567000','2101000','2622668000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2101000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110934553' 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 ('F225110934554','kasir',' 1',' MEB1 5K CM','TOKO','SMBK-B','B1E-YKXA-58-T','GW TUSUK BUNGA PASIR VAR CM PE 8K ','OL','0.800','1','100.00','800000','0','0','15000','832000','0','5000','0','837000','TIN','T0074853','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YKXA-58-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='B1E-YKXA-58-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225110934554','2025-11-11','0.800','2025-11-11','09:34:55','PLG0074698','832000','832000','5000','837000','837000','kasir','2025-11-11 09:34:55','F22511093455');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110934554','2025-11-11','09:34:55','TIN','837000','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-251111-0008','D','2025-11-11','09:34:55','kasir','PENJUALAN','F225110934554','2622668000','837000','2623505000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='837000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110934554' 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 ('F225110935581','kasir','1',' TFH1 X UB ','TOKO','TBK-H','H1TF-YJXB-121-T','KL X SANTA SEMI UB 52CM 17K ','','10.000','1','100.00','18400000','0','0','15000','18700000','0','0','0','18700000','TJ','T0073701','H1TF','0','0','-','0','1840000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TF-YJXB-121-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'10.000',berat_jual_asli=berat_jual_asli+'10.000',stock_jual='1',berat_akhir=berat_akhir-'10.000',berat_akhir_asli=berat_akhir_asli-'10.000',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='H1TF-YJXB-121-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225110935581','2025-11-11','10.000','2025-11-11','09:35:59','PLG0074699','18700000','18700000','0','18700000','18700000','kasir','2025-11-11 09:35:58','F22511093558');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110935581','2025-11-11','09:35:59','TJ','18700000','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-251111-0009','D','2025-11-11','09:35:59','kasir','PENJUALAN','F225110935581','2623505000','18700000','2642205000');
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 ('F225110945471','kasir','1',' MDE2 10K B','TOKO','SMBK-E','E2D-YBAA-78-T','CC WEDDING MATA BM 24 8K ','','2.620','1','100.00','2568000','0','0','15000','2633000','0','10000','0','2643000','RTA','T0066734','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YBAA-78-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.620',berat_jual_asli=berat_jual_asli+'2.620',stock_jual='1',berat_akhir=berat_akhir-'2.620',berat_akhir_asli=berat_akhir_asli-'2.620',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='E2D-YBAA-78-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225110945471','2025-11-11','2.620','2025-11-11','09:45:47','PLG0074700','2633000','2633000','10000','2643000','2643000','kasir','2025-11-11 09:45:47','F22511094547');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110945471','2025-11-11','09:45:47','RTA','2643000','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-251111-0010','D','2025-11-11','09:45:47','kasir','PENJUALAN','F225110945471','2642205000','2643000','2644848000');
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 ('F225111032411','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-YIXB-30-T','CC WEDDING MATA CM 14 8K ','','2.010','1','100.00','1970000','0','0','15000','2020000','0','10000','0','2030000','TJ','T0072774','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIXB-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='E2D-YIXB-30-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111032411','2025-11-11','2.010','2025-11-11','10:32:41','PLG0074701','2020000','2020000','10000','2030000','2030000','kasir','2025-11-11 10:32:41','F22511103241');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111032411','2025-11-11','10:32:41','TJ','2030000','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-251111-0011','D','2025-11-11','10:32:41','kasir','PENJUALAN','F225111032411','2644848000','2030000','2646878000');
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 ('F225111043361','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-YCBA-3-T','AT MODEL MATA VAR LG 8K ','','0.550','1','100.00','550000','0','0','15000','564000','0','0','0','564000','RTA','T0068045','A1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YCBA-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='A1E-YCBA-3-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111043361','2025-11-11','0.550','2025-11-11','10:43:37','PLG0074702','564000','564000','0','564000','564000','kasir','2025-11-11 10:43:36','F22511104336');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111043361','2025-11-11','10:43:37','RTA','564000','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-251111-0012','D','2025-11-11','10:43:37','kasir','PENJUALAN','F225111043361','2646878000','564000','2647442000');
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-00004816','X-00004816','','GR','---','A0A','BELI','BELI001','4335000','2025-11-11','2.970','1','kasir','2025-11-11 10:50:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-A0A';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A0A','X-00004816','X-00004816');
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-251111-0001','F223151156141','RHM','1','BELI','BELI001','A0A', 'X-00004816', '','3.070','2.970','100.00','2441000','4335000','1459596','100000','1','4335000','4335000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.970',berat_beli_asli=berat_beli_asli+'2.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.970',berat_akhir_asli=berat_akhir_asli+'2.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A0A' 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-251111-0001','2025-11-11','2025-11-11','10:50:41','RHM','---','2.970','4335000','4335000','4335000','4335000','4335000','kasir','2025-11-11 10:50:41','FB-251111-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251111-0001','','','','','','kasir','2025-11-11 10:50:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-11' 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-251111-0013','K','2025-11-11','10:50:41','kasir','PEMBELIAN UMUM','FB-251111-0001','2647442000','4335000','2643107000');
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 ('F225111121321','kasir','1',' MEB1 CM PE','TOKO','SMBK-B','B1E-YCAE-8-T','GW TUSUK MODEL HATI VAR CM PE 8K ','OL ','0.580','1','100.00','580000','0','0','15000','603000','0','5000','0','608000','RHM','T0067751','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YCAE-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='B1E-YCAE-8-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225111121321','2025-11-11','0.580','2025-11-11','11:21:33','PLG0074703','603000','603000','5000','608000','608000','kasir','2025-11-11 11:21:32','F22511112132');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111121321','2025-11-11','11:21:33','RHM','608000','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-251111-0014','D','2025-11-11','11:21:33','kasir','PENJUALAN','F225111121321','2643107000','608000','2643715000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='608000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111121321' 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 ('F225111121322','kasir',' 1',' MEB1 CM PE','TOKO','SMBK-B','B1E-YCAE-9-T','GW TUSUK MODEL HATI VAR CM PE 8K ','OL ','0.580','1','100.00','580000','0','0','15000','603000','0','5000','0','608000','RHM','T0067752','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YCAE-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='B1E-YCAE-9-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225111121322','2025-11-11','0.580','2025-11-11','11:21:33','PLG0074704','603000','603000','5000','608000','608000','kasir','2025-11-11 11:21:32','F22511112132');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111121322','2025-11-11','11:21:33','RHM','608000','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-251111-0015','D','2025-11-11','11:21:33','kasir','PENJUALAN','F225111121322','2643715000','608000','2644323000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='608000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111121322' 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 ('F225111121323','kasir',' 1',' MEB1 X LG ','TOKO','SMBK-B','B1E-YFXI-56-0','GW X MODEL MATA LG PE 8K ','OL ','0.600','1','100.00','600000','0','0','15000','624000','0','5000','0','629000','RHM','00356801','B1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YFXI-56-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='B1E-YFXI-56-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225111121323','2025-11-11','0.600','2025-11-11','11:21:33','PLG0074705','624000','624000','5000','629000','629000','kasir','2025-11-11 11:21:32','F22511112132');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111121323','2025-11-11','11:21:33','RHM','629000','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-251111-0016','D','2025-11-11','11:21:33','kasir','PENJUALAN','F225111121323','2644323000','629000','2644952000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='629000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111121323' 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 ('F225111121324','kasir',' 1',' MGPB X CM ','TOKO','SMBK-P','PBG-YJCA-62-T','GW X WG TUSUK DAISY MATA CM PE 8K ','OL ','0.480','1','100.00','499000','0','0','15000','518000','0','5000','0','523000','RHM','T0074793','PBG','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBG-YJCA-62-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='PBG-YJCA-62-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111121324','2025-11-11','0.480','2025-11-11','11:21:33','PLG0074706','518000','518000','5000','523000','523000','kasir','2025-11-11 11:21:32','F22511112132');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111121324','2025-11-11','11:21:33','RHM','523000','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-251111-0017','D','2025-11-11','11:21:33','kasir','PENJUALAN','F225111121324','2644952000','523000','2645475000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='523000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111121324' 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 ('F225111124281','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YKXA-98-T','LT SLOBOK BALOK HURUF BG S 8K ','OL ','0.600','1','100.00','624000','0','0','15000','648000','0','5000','0','653000','RHM','T0074893','D1G','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YKXA-98-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='D1G-YKXA-98-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111124281','2025-11-11','0.600','2025-11-11','11:24:29','PLG0074707','648000','648000','5000','653000','653000','kasir','2025-11-11 11:24:28','F22511112428');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111124281','2025-11-11','11:24:29','RHM','653000','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-251111-0018','D','2025-11-11','11:24:29','kasir','PENJUALAN','F225111124281','2645475000','653000','2646128000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='653000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111124281' 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 ('F225111124282','kasir',' 1',' MFD1 X BG ','TOKO','SMBK-D','D1F-YCXC-221-0','LT X SLOBOK BALOK HURUF BG C 8K ','OL ','0.460','1','100.00','469000','0','0','15000','488000','0','5000','0','493000','RHM','00341260','D1F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YCXC-221-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='D1F-YCXC-221-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111124282','2025-11-11','0.460','2025-11-11','11:24:29','PLG0074708','488000','488000','5000','493000','493000','kasir','2025-11-11 11:24:28','F22511112428');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111124282','2025-11-11','11:24:29','RHM','493000','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-251111-0019','D','2025-11-11','11:24:29','kasir','PENJUALAN','F225111124282','2646128000','493000','2646621000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='493000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111124282' 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 ('F225111124283','kasir',' 1',' MHD1 5K BG','TOKO','SMBK-D','D1H-YKXC-33-T','LT SLOBOK BOLA KRAWANG BG 8K ','OL ','0.270','1','100.00','286000','0','0','15000','297000','0','5000','0','302000','RHM','T0074946','D1H','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1H-YKXC-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.270',berat_jual_asli=berat_jual_asli+'0.270',stock_jual='1',berat_akhir=berat_akhir-'0.270',berat_akhir_asli=berat_akhir_asli-'0.270',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='D1H-YKXC-33-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111124283','2025-11-11','0.270','2025-11-11','11:24:29','PLG0074709','297000','297000','5000','302000','302000','kasir','2025-11-11 11:24:28','F22511112428');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111124283','2025-11-11','11:24:29','RHM','302000','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-251111-0020','D','2025-11-11','11:24:29','kasir','PENJUALAN','F225111124283','2646621000','302000','2646923000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='302000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111124283' 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 ('F225111124284','kasir',' 1',' MHD1 5K BG','TOKO','SMBK-D','D1H-YKXC-32-T','LT SLOBOK BOLA KRAWANG BG 8K ','OL ','0.260','1','100.00','276000','0','0','15000','286000','0','5000','0','291000','RHM','T0074945','D1H','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1H-YKXC-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='D1H-YKXC-32-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111124284','2025-11-11','0.260','2025-11-11','11:24:29','PLG0074710','286000','286000','5000','291000','291000','kasir','2025-11-11 11:24:28','F22511112428');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111124284','2025-11-11','11:24:29','RHM','291000','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-251111-0021','D','2025-11-11','11:24:29','kasir','PENJUALAN','F225111124284','2646923000','291000','2647214000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='291000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111124284' 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 ('F225111124285','kasir',' 1',' MHD1 5K BG','TOKO','SMBK-D','D1H-YKXC-35-T','LT SLOBOK BOLA KRAWANG BG 8K ','OL ','0.260','1','100.00','276000','0','0','15000','286000','0','5000','0','291000','RHM','T0074948','D1H','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1H-YKXC-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='D1H-YKXC-35-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111124285','2025-11-11','0.260','2025-11-11','11:24:29','PLG0074711','286000','286000','5000','291000','291000','kasir','2025-11-11 11:24:28','F22511112428');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111124285','2025-11-11','11:24:29','RHM','291000','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-251111-0022','D','2025-11-11','11:24:29','kasir','PENJUALAN','F225111124285','2647214000','291000','2647505000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='291000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111124285' 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 ('F225111124286','kasir',' 1',' MEA1 5K LG','TOKO','SMBK-A','A1E-YHBX-268-0','AT MODEL APESL CAT HITAM MT LG 8K ','OL ','0.540','1','100.00','540000','0','0','15000','562000','0','5000','0','567000','RHM','00366546','A1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YHBX-268-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.540',berat_jual_asli=berat_jual_asli+'0.540',stock_jual='1',berat_akhir=berat_akhir-'0.540',berat_akhir_asli=berat_akhir_asli-'0.540',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='A1E-YHBX-268-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111124286','2025-11-11','0.540','2025-11-11','11:24:29','PLG0074712','562000','562000','5000','567000','567000','kasir','2025-11-11 11:24:28','F22511112428');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111124286','2025-11-11','11:24:29','RHM','567000','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-251111-0023','D','2025-11-11','11:24:29','kasir','PENJUALAN','F225111124286','2647505000','567000','2648072000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='567000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111124286' 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 ('F225111125461','kasir','1',' MJF4 KH ','TOKO','SMBK-F','F4J-YHBE-28-T','GL JEDAR KH 9K ','OL ','0.610','1','100.00','671000','0','0','15000','695000','0','5000','0','700000','RHM','T0072513','F4J','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F4J-YHBE-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='F4J-YHBE-28-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111125461','2025-11-11','0.610','2025-11-11','11:25:46','PLG0074713','695000','695000','5000','700000','700000','kasir','2025-11-11 11:25:46','F22511112546');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111125461','2025-11-11','11:25:46','RHM','700000','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-251111-0024','D','2025-11-11','11:25:46','kasir','PENJUALAN','F225111125461','2648072000','700000','2648772000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='700000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111125461' 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 ('F225111125462','kasir',' 1',' MJF4J X KH','TOKO','SMBK-F','F4J-YIBD-211-0','GL X JEDAR KH 9K ','OL ','0.720','1','100.00','792000','0','0','15000','821000','0','5000','0','826000','RHM','00370632','F4J','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F4J-YIBD-211-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='F4J-YIBD-211-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111125462','2025-11-11','0.720','2025-11-11','11:25:46','PLG0074714','821000','821000','5000','826000','826000','kasir','2025-11-11 11:25:46','F22511112546');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111125462','2025-11-11','11:25:46','RHM','826000','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-251111-0025','D','2025-11-11','11:25:46','kasir','PENJUALAN','F225111125462','2648772000','826000','2649598000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='826000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111125462' 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 ('F225111125463','kasir',' 1',' MEF3E LT ','TOKO','SMBK-F','F3E-YJBD-95-T','GL MODEL VERONICA VAR LT 8K ','OL ','1.040','1','100.00','1040000','0','0','15000','1077000','0','5000','0','1082000','RHM','T0074445','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJBD-95-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.040',berat_jual_asli=berat_jual_asli+'1.040',stock_jual='1',berat_akhir=berat_akhir-'1.040',berat_akhir_asli=berat_akhir_asli-'1.040',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='F3E-YJBD-95-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111125463','2025-11-11','1.040','2025-11-11','11:25:46','PLG0074715','1077000','1077000','5000','1082000','1082000','kasir','2025-11-11 11:25:46','F22511112546');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111125463','2025-11-11','11:25:46','RHM','1082000','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-251111-0026','D','2025-11-11','11:25:46','kasir','PENJUALAN','F225111125463','2649598000','1082000','2650680000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1082000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111125463' 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 ('F225111128441','kasir','1',' MGE1 HW 15','TOKO','SMBK-E','E1G-YKXA-3-T','CC LISTRING GELOMBANG SLEP HW 15 8K ','OL ','0.400','1','100.00','416000','0','0','15000','432000','0','5000','0','437000','RHM','T0074798','E1G','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-YKXA-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='E1G-YKXA-3-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111128441','2025-11-11','0.400','2025-11-11','11:28:45','PLG0074716','432000','432000','5000','437000','437000','kasir','2025-11-11 11:28:44','F22511112844');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111128441','2025-11-11','11:28:45','RHM','437000','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-251111-0027','D','2025-11-11','11:28:45','kasir','PENJUALAN','F225111128441','2650680000','437000','2651117000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='437000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111128441' 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 ('F225111128442','kasir',' 1',' MGE1 HW 15','TOKO','SMBK-E','E1G-YKXA-5-T','CC LISTRING GELOMBANG SLEP HW 15 8K ','OL ','0.400','1','100.00','416000','0','0','15000','432000','0','5000','0','437000','RHM','T0074800','E1G','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-YKXA-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='E1G-YKXA-5-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111128442','2025-11-11','0.400','2025-11-11','11:28:45','PLG0074717','432000','432000','5000','437000','437000','kasir','2025-11-11 11:28:44','F22511112844');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111128442','2025-11-11','11:28:45','RHM','437000','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-251111-0028','D','2025-11-11','11:28:45','kasir','PENJUALAN','F225111128442','2651117000','437000','2651554000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='437000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111128442' 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 ('F225111128443','kasir',' 1',' MGE1 HW 15','TOKO','SMBK-E','E1G-YKXA-4-T','CC LISTRING GELOMBANG SLEP HW 15 8K ','OL ','0.400','1','100.00','416000','0','0','15000','432000','0','5000','0','437000','RHM','T0074799','E1G','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-YKXA-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='E1G-YKXA-4-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111128443','2025-11-11','0.400','2025-11-11','11:28:45','PLG0074718','432000','432000','5000','437000','437000','kasir','2025-11-11 11:28:44','F22511112844');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111128443','2025-11-11','11:28:45','RHM','437000','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-251111-0029','D','2025-11-11','11:28:45','kasir','PENJUALAN','F225111128443','2651554000','437000','2651991000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='437000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111128443' 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 ('F225111128444','kasir',' 1',' MDE2 HW 15','TOKO','SMBK-E','E2D-YJBE-6-T','CC COR MODEL PAKU MATA HW 8K ','OL ','1.020','1','100.00','1000000','0','0','15000','1056000','0','5000','0','1061000','RHM','T0074479','E2D','0','0','-','0','980000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJBE-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='E2D-YJBE-6-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111128444','2025-11-11','1.020','2025-11-11','11:28:45','PLG0074719','1056000','1056000','5000','1061000','1061000','kasir','2025-11-11 11:28:44','F22511112844');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111128444','2025-11-11','11:28:45','RHM','1061000','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-251111-0030','D','2025-11-11','11:28:45','kasir','PENJUALAN','F225111128444','2651991000','1061000','2653052000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1061000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111128444' 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 ('F225111128445','kasir',' 1',' MEE1 LG 14','TOKO','SMBK-E','E1E-YJBI-97-T','CC MODEL DAUN VAR LG 14 8K ','OL ','0.450','1','100.00','450000','0','0','15000','468000','0','5000','0','473000','RHM','T0074657','E1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJBI-97-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='E1E-YJBI-97-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111128445','2025-11-11','0.450','2025-11-11','11:28:45','PLG0074720','468000','468000','5000','473000','473000','kasir','2025-11-11 11:28:44','F22511112844');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111128445','2025-11-11','11:28:45','RHM','473000','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-251111-0031','D','2025-11-11','11:28:45','kasir','PENJUALAN','F225111128445','2653052000','473000','2653525000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='473000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111128445' 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 ('F225111128446','kasir',' 1',' MEE1 LG 14','TOKO','SMBK-E','E1E-YJBI-102-T','CC MODEL DAUN VAR LG 14 8K ','OL ','0.450','1','100.00','450000','0','0','15000','468000','0','5000','0','473000','RHM','T0074662','E1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJBI-102-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='E1E-YJBI-102-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111128446','2025-11-11','0.450','2025-11-11','11:28:45','PLG0074721','468000','468000','5000','473000','473000','kasir','2025-11-11 11:28:44','F22511112844');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111128446','2025-11-11','11:28:45','RHM','473000','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-251111-0032','D','2025-11-11','11:28:45','kasir','PENJUALAN','F225111128446','2653525000','473000','2653998000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='473000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111128446' 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 ('F225111128447','kasir',' 1',' MEE1 LG 14','TOKO','SMBK-E','E1E-YJBI-98-T','CC MODEL DAUN VAR LG 14 8K ','OL ','0.450','1','100.00','450000','0','0','15000','468000','0','5000','0','473000','RHM','T0074658','E1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJBI-98-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='E1E-YJBI-98-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111128447','2025-11-11','0.450','2025-11-11','11:28:45','PLG0074722','468000','468000','5000','473000','473000','kasir','2025-11-11 11:28:44','F22511112844');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111128447','2025-11-11','11:28:45','RHM','473000','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-251111-0033','D','2025-11-11','11:28:45','kasir','PENJUALAN','F225111128447','2653998000','473000','2654471000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='473000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111128447' 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 ('F225111128448','kasir',' 1',' MEE1 LG 14','TOKO','SMBK-E','E1E-YJBI-99-T','CC MODEL DAUN VAR LG 14 8K ','OL ','0.430','1','100.00','430000','0','0','15000','447000','0','5000','0','452000','RHM','T0074659','E1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJBI-99-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='E1E-YJBI-99-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111128448','2025-11-11','0.430','2025-11-11','11:28:45','PLG0074723','447000','447000','5000','452000','452000','kasir','2025-11-11 11:28:44','F22511112844');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111128448','2025-11-11','11:28:45','RHM','452000','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-251111-0034','D','2025-11-11','11:28:45','kasir','PENJUALAN','F225111128448','2654471000','452000','2654923000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='452000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111128448' 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 ('F225111130141','kasir','1',' TDE1 CM 14','TOKO','TBK-E','E1TD-YIXD-30-T','CC MODEL HATI SLEP VAR CM 14 17K ','OL ','1.000','1','100.00','1800000','0','0','15000','1858000','0','7000','0','1865000','RHM','T0072882','E1TD','0','0','-','0','1800000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YIXD-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='E1TD-YIXD-30-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225111130141','2025-11-11','1.000','2025-11-11','11:30:15','PLG0074724','1858000','1858000','7000','1865000','1865000','kasir','2025-11-11 11:30:14','F22511113014');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111130141','2025-11-11','11:30:15','RHM','1865000','7000');
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-251111-0035','D','2025-11-11','11:30:15','kasir','PENJUALAN','F225111130141','2654923000','1865000','2656788000');
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 ('F225111138051','kasir','1',' MFE1 UB 14','TOKO','SMBK-E','E1F-YJCX-3-T','CC MODEL GELOMBANG VAR UB 14 8K ','','0.720','1','100.00','734000','0','0','15000','752000','0','0','0','752000','TIN','T0074707','E1F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-YJCX-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='E1F-YJCX-3-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111138051','2025-11-11','0.720','2025-11-11','11:38:06','PLG0074725','752000','752000','0','752000','0','kasir','2025-11-11 11:38:05','F22511113805');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111138051','2025-11-11','11:38:06','TIN','752000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251111-0001','2025-11-11','2025-11-11 11:38:05','PENJUALAN : F225111138051','785485486548654','BCA','752000','752000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251111-0002','D','2025-11-11','11:38:06','BCA','PENJUALAN','F225111138051','4133818888','752000','4134570888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('785485486548654','HHHH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='752000' WHERE no_faktur_jual='F225111138051' 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 ('F225111139061','kasir','1',' MEF3E X UB','TOKO','SMBK-F','F3E-YKXD-89-0','GL X VERONICA DOBEL SLEP UB 8K ','','2.450','1','100.00','2450000','0','0','15000','2498000','0','0','0','2498000','TIN','00376625','F3E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKXD-89-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.450',berat_jual_asli=berat_jual_asli+'2.450',stock_jual='1',berat_akhir=berat_akhir-'2.450',berat_akhir_asli=berat_akhir_asli-'2.450',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='F3E-YKXD-89-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111139061','2025-11-11','2.450','2025-11-11','11:39:07','PLG0074726','2498000','2498000','0','2498000','0','kasir','2025-11-11 11:39:06','F22511113906');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111139061','2025-11-11','11:39:07','TIN','2498000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251111-0002','2025-11-11','2025-11-11 11:39:06','PENJUALAN : F225111139061','785485484854684','BCA','2498000','2498000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251111-0003','D','2025-11-11','11:39:07','BCA','PENJUALAN','F225111139061','4134570888','2498000','4137068888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('785485484854684','HHHH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2498000' WHERE no_faktur_jual='F225111139061' 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 ('F225111221411','kasir','1',' MEF1 TD D4','TOKO','SMBK-F','F1E-YDAE-12-T','GL ANAK BANGKOK MODEL C TD D42 8K ','','1.990','1','100.00','1990000','0','0','15000','2060000','0','0','0','2060000','TIN','T0068672','F1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YDAE-12-T' 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='2025-11-11' AND kode_barang='F1E-YDAE-12-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225111221411','2025-11-11','1.990','2025-11-11','12:21:42','PLG0074727','2060000','2060000','0','2060000','2060000','kasir','2025-11-11 12:21:41','F22511122141');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225111221411','2025-11-11','12:21:42','TIN','2060000','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-251111-0036','D','2025-11-11','12:21:42','kasir','PENJUALAN','F225111221411','2656788000','2060000','2658848000');
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 ('F225110140051','kasir','1',' MED2 LG L ','TOKO','SMBK-D','D2E-YGBD-10-T','LT MODEL HURUF MATA LG L 8K ','','0.530','1','100.00','530000','0','0','15000','549000','0','0','0','549000','TIN','T0071438','D2E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YGBD-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='D2E-YGBD-10-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225110140051','2025-11-11','0.530','2025-11-11','13:40:05','PLG0074728','549000','549000','0','549000','549000','kasir','2025-11-11 13:40:05','F22511014005');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110140051','2025-11-11','13:40:05','TIN','549000','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-251111-0037','D','2025-11-11','13:40:05','kasir','PENJUALAN','F225110140051','2658848000','549000','2659397000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='549000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110140051' 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 ('F225110140052','kasir',' 1',' MEH1 KH 42','TOKO','SMBK-H','H1E-YGAF-56-T','KL NORY KH 42CM 8K ','','3.050','1','100.00','3050000','0','0','15000','3157000','0','0','0','3157000','TIN','T0070999','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YGAF-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='H1E-YGAF-56-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225110140052','2025-11-11','3.050','2025-11-11','13:40:05','PLG0074729','3157000','3157000','0','3157000','3157000','kasir','2025-11-11 13:40:05','F22511014005');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110140052','2025-11-11','13:40:05','TIN','3157000','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-251111-0038','D','2025-11-11','13:40:05','kasir','PENJUALAN','F225110140052','2659397000','3157000','2662554000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3157000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110140052' 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 ('F225110154451','kasir','1',' MEE2 HTM 1','TOKO','SMBK-E','E2E-YEBD-32-T','CC PIPA MODEL MATA VAR HTM 13 8K ','','0.520','1','100.00','520000','0','0','15000','538000','0','0','0','538000','RTA','T0069535','E2E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YEBD-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='E2E-YEBD-32-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225110154451','2025-11-11','0.520','2025-11-11','13:54:45','PLG0074730','538000','538000','0','538000','538000','kasir','2025-11-11 13:54:45','F22511015445');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110154451','2025-11-11','13:54:45','RTA','538000','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-251111-0039','D','2025-11-11','13:54:45','kasir','PENJUALAN','F225110154451','2662554000','538000','2663092000');
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 ('F225110217321','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YJBI-134-T','LT SLOBOK BULAT HURUF BG T 8K','OL ','0.560','1','100.00','582000','0','0','15000','610000','0','5000','0','615000','RHM','T0074694','D1G','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YJBI-134-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='D1G-YJBI-134-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225110217321','2025-11-11','0.560','2025-11-11','14:17:33','PLG0074731','610000','610000','5000','615000','615000','kasir','2025-11-11 14:17:32','F22511021732');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110217321','2025-11-11','14:17:33','RHM','615000','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-251111-0040','D','2025-11-11','14:17:33','kasir','PENJUALAN','F225110217321','2663092000','615000','2663707000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='615000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110217321' 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 ('F225110217322','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-YJAH-101-T','LT CHARM BULAT HURUF A BG 8K ','OL ','0.500','1','100.00','510000','0','0','15000','535000','0','5000','0','540000','RHM','T0074314','D1F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YJAH-101-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='D1F-YJAH-101-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225110217322','2025-11-11','0.500','2025-11-11','14:17:33','PLG0074732','535000','535000','5000','540000','540000','kasir','2025-11-11 14:17:32','F22511021732');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110217322','2025-11-11','14:17:33','RHM','540000','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-251111-0041','D','2025-11-11','14:17:33','kasir','PENJUALAN','F225110217322','2663707000','540000','2664247000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='540000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110217322' 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 ('F225110217323','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YIXD-14-T','LT SLOBOK BALOK HURUF BG E 8K ','OL ','0.650','1','100.00','676000','0','0','15000','709000','0','5000','0','714000','RHM','T0072866','D1G','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YIXD-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='D1G-YIXD-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225110217323','2025-11-11','0.650','2025-11-11','14:17:33','PLG0074733','709000','709000','5000','714000','714000','kasir','2025-11-11 14:17:32','F22511021732');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110217323','2025-11-11','14:17:33','RHM','714000','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-251111-0042','D','2025-11-11','14:17:33','kasir','PENJUALAN','F225110217323','2664247000','714000','2664961000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='714000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110217323' 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 ('F225110217324','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YJBI-136-T','LT SLOBOK BALOK HURUF BG A 8K ','OL ','0.550','1','100.00','572000','0','0','15000','600000','0','5000','0','605000','RHM','T0074696','D1G','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YJBI-136-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='D1G-YJBI-136-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225110217324','2025-11-11','0.550','2025-11-11','14:17:33','PLG0074734','600000','600000','5000','605000','605000','kasir','2025-11-11 14:17:32','F22511021732');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110217324','2025-11-11','14:17:33','RHM','605000','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-251111-0043','D','2025-11-11','14:17:33','kasir','PENJUALAN','F225110217324','2664961000','605000','2665566000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='605000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110217324' 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 ('F225110217325','kasir',' 1',' MED2E X LG','TOKO','SMBK-D','D2E-YJXA-67-0','LT X MODEL HURUF MATA LG A 8K ','OL ','0.550','1','100.00','550000','0','0','15000','578000','0','5000','0','583000','RHM','00371312','D2E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YJXA-67-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='D2E-YJXA-67-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225110217325','2025-11-11','0.550','2025-11-11','14:17:33','PLG0074735','578000','578000','5000','583000','583000','kasir','2025-11-11 14:17:32','F22511021732');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110217325','2025-11-11','14:17:33','RHM','583000','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-251111-0044','D','2025-11-11','14:17:33','kasir','PENJUALAN','F225110217325','2665566000','583000','2666149000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='583000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110217325' 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 ('F225110217326','kasir',' 1',' MED2 LG R ','TOKO','SMBK-D','D2E-YHBG-56-T','LT MODEL HURUF MATA LG R 8K ','OL ','0.570','1','100.00','570000','0','0','15000','599000','0','5000','0','604000','RHM','T0072648','D2E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-YHBG-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='D2E-YHBG-56-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225110217326','2025-11-11','0.570','2025-11-11','14:17:33','PLG0074736','599000','599000','5000','604000','604000','kasir','2025-11-11 14:17:32','F22511021732');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110217326','2025-11-11','14:17:33','RHM','604000','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-251111-0045','D','2025-11-11','14:17:33','kasir','PENJUALAN','F225110217326','2666149000','604000','2666753000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='604000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110217326' 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 ('F225110219351','kasir','1',' MGE1 HW 15','TOKO','SMBK-E','E1G-YKXA-11-T','CC LISTRING GELOMBANG SLEP HW 15 8K ','OL ','0.380','1','100.00','395000','0','0','15000','415000','0','5000','0','420000','RHM','T0074806','E1G','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1G-YKXA-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='E1G-YKXA-11-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225110219351','2025-11-11','0.380','2025-11-11','14:19:36','PLG0074737','415000','415000','5000','420000','420000','kasir','2025-11-11 14:19:35','F22511021935');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110219351','2025-11-11','14:19:36','RHM','420000','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-251111-0046','D','2025-11-11','14:19:36','kasir','PENJUALAN','F225110219351','2666753000','420000','2667173000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='420000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110219351' 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 ('F225110219352','kasir',' 1',' MEH1 LT 40','TOKO','SMBK-H','H1E-YJCX-16-T','KL NORY LT 40CM 8K ','OL ','1.010','1','100.00','1010000','0','0','15000','1056000','0','5000','0','1061000','RHM','T0074720','H1E','0','0','-','0','1000000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJCX-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='H1E-YJCX-16-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225110219352','2025-11-11','1.010','2025-11-11','14:19:36','PLG0074738','1056000','1056000','5000','1061000','1061000','kasir','2025-11-11 14:19:35','F22511021935');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110219352','2025-11-11','14:19:36','RHM','1061000','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-251111-0047','D','2025-11-11','14:19:36','kasir','PENJUALAN','F225110219352','2667173000','1061000','2668234000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1061000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110219352' 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 ('F225110219353','kasir',' 1',' MFH1F UB 4','TOKO','SMBK-H','H1F-YJBD-118-T','KL KOREA UB 46CM 8K ','OL ','1.010','1','100.00','1030000','0','0','15000','1056000','0','5000','0','1061000','RHM','T0074468','H1F','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YJBD-118-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='H1F-YJBD-118-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F225110219353','2025-11-11','1.010','2025-11-11','14:19:36','PLG0074739','1056000','1056000','5000','1061000','1061000','kasir','2025-11-11 14:19:35','F22511021935');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110219353','2025-11-11','14:19:36','RHM','1061000','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-251111-0048','D','2025-11-11','14:19:36','kasir','PENJUALAN','F225110219353','2668234000','1061000','2669295000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1061000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110219353' 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 ('F225110220271','kasir','1',' TDE1 CM 18','TOKO','TBK-E','E1TD-YCBD-11-T','CC POLOS CM 18 17K ','OL ','0.980','1','100.00','1764000','0','0','15000','1838000','0','7000','0','1845000','RHM','T0068137','E1TD','0','0','-','0','1800000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YCBD-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='E1TD-YCBD-11-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225110220271','2025-11-11','0.980','2025-11-11','14:20:27','PLG0074740','1838000','1838000','7000','1845000','1845000','kasir','2025-11-11 14:20:27','F22511022027');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110220271','2025-11-11','14:20:27','RHM','1845000','7000');
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-251111-0049','D','2025-11-11','14:20:27','kasir','PENJUALAN','F225110220271','2669295000','1845000','2671140000');
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 ('F225110234411','kasir','1',' TDE2X 10K ','TOKO','TBK-E','E2TD-XLAI-101-T','CC X WEDDING MATA CM 20 17K ','','1.900','1','100.00','3420000','0','0','15000','3496000','0','10000','0','3506000','TIN','T0065137','E2TD','0','0','-','0','1800000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-XLAI-101-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.900',berat_jual_asli=berat_jual_asli+'1.900',stock_jual='1',berat_akhir=berat_akhir-'1.900',berat_akhir_asli=berat_akhir_asli-'1.900',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='E2TD-XLAI-101-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225110234411','2025-11-11','1.900','2025-11-11','14:34:42','PLG0074741','3496000','3496000','10000','3506000','3506000','kasir','2025-11-11 14:34:41','F22511023441');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110234411','2025-11-11','14:34:42','TIN','3506000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251111-0050','D','2025-11-11','14:34:42','kasir','PENJUALAN','F225110234411','2671140000','3506000','2674646000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3506000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110234411' 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 ('F225110234412','kasir',' 1',' TGPE 10K C','TOKO','TBK-P','PETG-XKBB-43-T','CC WG WEDDING MATA CM 24 17K ','','2.320','1','100.00','4315000','0','0','15000','4408000','0','10000','0','4418000','TIN','T0064215','PETG','0','0','-','0','1860000');
UPDATE tm_barang SET tgl_last_jual='2025-11-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PETG-XKBB-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.320',berat_jual_asli=berat_jual_asli+'2.320',stock_jual='1',berat_akhir=berat_akhir-'2.320',berat_akhir_asli=berat_akhir_asli-'2.320',stock_akhir='0' WHERE tanggal='2025-11-11' AND kode_barang='PETG-XKBB-43-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225110234412','2025-11-11','2.320','2025-11-11','14:34:42','PLG0074742','4408000','4408000','10000','4418000','4418000','kasir','2025-11-11 14:34:41','F22511023441');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-11','F225110234412','2025-11-11','14:34:42','TIN','4418000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251111-0051','D','2025-11-11','14:34:42','kasir','PENJUALAN','F225110234412','2674646000','4418000','2679064000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4418000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110234412' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110140051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110140051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110140051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110140052' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110140052' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110140052';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110154451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110154451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110154451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110217321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110217321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110217321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110217322' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110217322' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110217322';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110217323' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110217323' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110217323';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110217324' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110217324' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110217324';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110217325' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110217325' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110217325';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110217326' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110217326' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110217326';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110219351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110219351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110219351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110219352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110219352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110219352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110219353' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110219353' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110219353';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110220271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110220271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110220271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110234411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110234411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110234411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110234412' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110234412' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110234412';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110843591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110843591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110843591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110844421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110844421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110844421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110844422' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110844422' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110844422';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110934551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110934551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110934551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110934552' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110934552' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110934552';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110934553' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110934553' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110934553';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110934554' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110934554' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110934554';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110935581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110935581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110935581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110945471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110945471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110945471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111032411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111032411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111032411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111043361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111043361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111043361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111121321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111121321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111121321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111121322' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111121322' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111121322';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111121323' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111121323' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111121323';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111121324' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111121324' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111121324';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111124281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111124281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111124281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111124282' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111124282' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111124282';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111124283' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111124283' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111124283';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111124284' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111124284' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111124284';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111124285' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111124285' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111124285';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111124286' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111124286' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111124286';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111125461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111125461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111125461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111125462' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111125462' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111125462';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111125463' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111125463' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111125463';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111128441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111128441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111128441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111128442' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111128442' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111128442';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111128443' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111128443' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111128443';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111128444' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111128444' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111128444';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111128445' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111128445' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111128445';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111128446' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111128446' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111128446';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111128447' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111128447' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111128447';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111128448' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111128448' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111128448';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111130141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111130141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111130141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111138051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111138051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111138051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111139061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111139061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111139061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111221411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111221411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111221411';
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-00004817','X-00004817','CC WEDDING MATA CM 20 8K','GR','---','E2D','BELI','BELI001','1908000','2025-11-11','2.010','1','admin','2025-11-11 15:01:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00004817','X-00004817');
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-251111-0002','F225081205151','RTA','1','BELI','BELI001','E2D', 'X-00004817', 'CC WEDDING MATA CM 20 8K','2.010','2.010','100.00','2030000','1908000','949254','980000','1','1908000','1908000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.010',berat_beli_asli=berat_beli_asli+'2.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.010',berat_akhir_asli=berat_akhir_asli+'2.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-11' 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-251111-0002','2025-11-11','2025-11-11','15:01:17','RTA','---','2.010','1908000','1908000','1908000','1908000','1908000','admin','2025-11-11 15:01:18','FB-251111-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251111-0002','TONI','','','','','admin','2025-11-11 15:01:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-11' 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-251111-0052','K','2025-11-11','15:01:17','admin','PEMBELIAN UMUM','FB-251111-0002','2679064000','1908000','2677156000');
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-00004818','X-00004818','GL RANTAI HOLLOW UB 8K','GR','---','F3F','BELI','BELI001','288000','2025-11-11','0.380','1','admin','2025-11-11 15:01:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3F','X-00004818','X-00004818');
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-251111-0003','F225261249441','RHM','1','BELI','BELI001','F3F', 'X-00004818', 'GL RANTAI HOLLOW UB 8K','0.380','0.380','100.00','320000','288000','757895','1020000','1','288000','288000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.380',berat_beli_asli=berat_beli_asli+'0.380',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.380',berat_akhir_asli=berat_akhir_asli+'0.380',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3F' 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-251111-0003','2025-11-11','2025-11-11','15:01:33','RHM','---','0.380','288000','288000','288000','288000','288000','admin','2025-11-11 15:01:33','FB-251111-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251111-0003','SOFI','BANDAR PACITAN','','','','admin','2025-11-11 15:01:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-11' 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-251111-0053','K','2025-11-11','15:01:33','admin','PEMBELIAN UMUM','FB-251111-0003','2677156000','288000','2676868000');
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-00004819','X-00004819','CC MODEL SOLITAIRE MATA UB 14','GR','---','E2TE','BELI','BELI001','803000','2025-11-11','0.550','1','admin','2025-11-11 15:01:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00004819','X-00004819');
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-251111-0004','F225040312491','TIN','1','BELI','BELI001','E2TE', 'X-00004819', 'CC MODEL SOLITAIRE MATA UB 14','0.630','0.550','100.00','728000','803000','1460000','1820000','1','803000','803000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.550',berat_beli_asli=berat_beli_asli+'0.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.550',berat_akhir_asli=berat_akhir_asli+'0.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-11-11' 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-251111-0004','2025-11-11','2025-11-11','15:01:58','TIN','---','0.550','803000','803000','803000','803000','803000','admin','2025-11-11 15:01:59','FB-251111-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251111-0004','KHOLIFATUL','PLALANGAN JENANGAN','','','081939180607','admin','2025-11-11 15:01:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-11-11' 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-251111-0054','K','2025-11-11','15:01:58','admin','PEMBELIAN UMUM','FB-251111-0004','2676868000','803000','2676065000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251111-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251111-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251111-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251111-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251111-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251111-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251111-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251111-0004';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-12','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-12';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-11';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-11';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-11-11' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-11';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-11';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-11';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-11';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-12' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-11' 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-251112-0001','D','2025-11-12','16:01:52','SYSTEM','SALDO AWAL','SALDO AWAL','0','2676065000','2676065000');
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-251112-0001','D','2025-11-12','16:01:52','BCA','SALDO AWAL','SALDO AWAL','0','4137068888','4137068888');
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-251112-0001','D','2025-11-12','16:01:52','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
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-251112-0001','D','2025-11-12','16:01:52','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251112-0001','D','2025-11-12','16:01:52','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-251112-0001','D','2025-11-12','16:01:52','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2025-11-12';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251112-0001','1','A1E-YKAA-3-0','1','0.510','0.510','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YKAA-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YKAA-3-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2025-11-12 16:36:04' WHERE kode_barang='A1E-YKAA-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YKAA-3-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:04','TOKO','SMBK-A','A1E','A1E-YKAA-3-0','1','0.510','0.510','1','0.510','0.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-YKAA-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YKAA-3-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-20251112-0001','1','A1E-YKAA-14-0','1','0.570','0.570','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-YKAA-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-YKAA-14-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2025-11-12 16:36:04' WHERE kode_barang='A1E-YKAA-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-YKAA-14-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:04','TOKO','SMBK-A','A1E','A1E-YKAA-14-0','1','0.570','0.570','1','0.570','0.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-YKAA-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-YKAA-14-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-20251112-0001','1','A1D-YKAA-17-0','1','0.970','0.970','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-YKAA-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-YKAA-17-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2025-11-12 16:36:04' WHERE kode_barang='A1D-YKAA-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-YKAA-17-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:04','TOKO','SMBK-A','A1D','A1D-YKAA-17-0','1','0.970','0.970','1','0.970','0.970','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-YKAA-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-YKAA-17-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-20251112-0001','1','A1D-YKAA-18-0','1','1.090','1.090','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-YKAA-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-YKAA-18-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2025-11-12 16:36:04' WHERE kode_barang='A1D-YKAA-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-YKAA-18-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:04','TOKO','SMBK-A','A1D','A1D-YKAA-18-0','1','1.090','1.090','1','1.090','1.090','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-YKAA-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-YKAA-18-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-20251112-0001','1','A1D-YKAA-19-0','1','0.950','0.950','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-YKAA-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-YKAA-19-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2025-11-12 16:36:04' WHERE kode_barang='A1D-YKAA-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-YKAA-19-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:04','TOKO','SMBK-A','A1D','A1D-YKAA-19-0','1','0.950','0.950','1','0.950','0.950','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-YKAA-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-YKAA-19-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-20251112-0001','1','A1D-YKAA-22-0','1','0.930','0.930','TOKO','SSBK-A','TOKO','SMBK-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-YKAA-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-YKAA-22-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-A',tgl_last_beli='2025-11-12 16:36:04' WHERE kode_barang='A1D-YKAA-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-YKAA-22-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:04','TOKO','SMBK-A','A1D','A1D-YKAA-22-0','1','0.930','0.930','1','0.930','0.930','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1D-YKAA-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-YKAA-22-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251112-0001','2025-11-12','16:35','5.020','input','2025-11-11 16:36:04');
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-20251112-0001','1','B1E-YKAA-38-0','1','0.600','0.600','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-YKAA-38-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-YKAA-38-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-11-12 16:36:19' WHERE kode_barang='B1E-YKAA-38-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-YKAA-38-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:19','TOKO','SMBK-B','B1E','B1E-YKAA-38-0','1','0.600','0.600','1','0.600','0.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-YKAA-38-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-YKAA-38-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-20251112-0001','1','B1E-YKAA-41-0','1','0.400','0.400','TOKO','SSBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-YKAA-41-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-YKAA-41-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-11-12 16:36:19' WHERE kode_barang='B1E-YKAA-41-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-YKAA-41-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:19','TOKO','SMBK-B','B1E','B1E-YKAA-41-0','1','0.400','0.400','1','0.400','0.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-YKAA-41-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-YKAA-41-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251112-0001','2025-11-12','16:36','1.000','input','2025-11-11 16:36:19');
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-20251112-0001','1','D2E-YKAA-68-0','1','0.550','0.550','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-YKAA-68-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-YKAA-68-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2025-11-12 16:36:32' WHERE kode_barang='D2E-YKAA-68-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-YKAA-68-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:32','TOKO','SMBK-D','D2E','D2E-YKAA-68-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2E-YKAA-68-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-YKAA-68-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-20251112-0001','1','D2E-YKAA-71-0','1','0.450','0.450','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-YKAA-71-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-YKAA-71-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2025-11-12 16:36:32' WHERE kode_barang='D2E-YKAA-71-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-YKAA-71-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:32','TOKO','SMBK-D','D2E','D2E-YKAA-71-0','1','0.450','0.450','1','0.450','0.450','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2E-YKAA-71-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-YKAA-71-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-20251112-0001','1','D2E-YKAA-75-0','1','0.580','0.580','TOKO','SSBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D2E-YKAA-75-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2E-YKAA-75-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2025-11-12 16:36:32' WHERE kode_barang='D2E-YKAA-75-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2E-YKAA-75-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:32','TOKO','SMBK-D','D2E','D2E-YKAA-75-0','1','0.580','0.580','1','0.580','0.580','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2E-YKAA-75-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2E-YKAA-75-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251112-0001','2025-11-12','16:36','1.580','input','2025-11-11 16:36:32');
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-20251112-0001','1','E2D-YKAA-303-0','1','1.250','1.250','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YKAA-303-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YKAA-303-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-11-12 16:36:47' WHERE kode_barang='E2D-YKAA-303-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YKAA-303-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:47','TOKO','SMBK-E','E2D','E2D-YKAA-303-0','1','1.250','1.250','1','1.250','1.250','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-YKAA-303-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YKAA-303-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-20251112-0001','1','E2D-YKAA-304-0','1','1.000','1.000','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YKAA-304-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YKAA-304-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-11-12 16:36:47' WHERE kode_barang='E2D-YKAA-304-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YKAA-304-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:47','TOKO','SMBK-E','E2D','E2D-YKAA-304-0','1','1.000','1.000','1','1.000','1.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-YKAA-304-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YKAA-304-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-20251112-0001','1','E2D-YKAA-305-0','1','0.830','0.830','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YKAA-305-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YKAA-305-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-11-12 16:36:47' WHERE kode_barang='E2D-YKAA-305-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YKAA-305-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:47','TOKO','SMBK-E','E2D','E2D-YKAA-305-0','1','0.830','0.830','1','0.830','0.830','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-YKAA-305-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YKAA-305-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-20251112-0001','1','E2D-YKAA-306-0','1','0.800','0.800','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-YKAA-306-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-YKAA-306-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-11-12 16:36:47' WHERE kode_barang='E2D-YKAA-306-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-YKAA-306-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:47','TOKO','SMBK-E','E2D','E2D-YKAA-306-0','1','0.800','0.800','1','0.800','0.800','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-YKAA-306-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-YKAA-306-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-20251112-0001','1','E2E-YKAA-307-0','1','0.600','0.600','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YKAA-307-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YKAA-307-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-11-12 16:36:47' WHERE kode_barang='E2E-YKAA-307-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YKAA-307-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:47','TOKO','SMBK-E','E2E','E2E-YKAA-307-0','1','0.600','0.600','1','0.600','0.600','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-YKAA-307-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YKAA-307-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-20251112-0001','1','E2E-YKAA-308-0','1','0.510','0.510','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YKAA-308-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YKAA-308-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-11-12 16:36:47' WHERE kode_barang='E2E-YKAA-308-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YKAA-308-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:47','TOKO','SMBK-E','E2E','E2E-YKAA-308-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-YKAA-308-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YKAA-308-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-20251112-0001','1','E2E-YKAA-309-0','1','0.660','0.660','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-YKAA-309-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-YKAA-309-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-11-12 16:36:47' WHERE kode_barang='E2E-YKAA-309-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-YKAA-309-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:47','TOKO','SMBK-E','E2E','E2E-YKAA-309-0','1','0.660','0.660','1','0.660','0.660','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-YKAA-309-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-YKAA-309-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-20251112-0001','1','E1E-YKAA-310-0','1','0.530','0.530','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YKAA-310-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YKAA-310-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-11-12 16:36:47' WHERE kode_barang='E1E-YKAA-310-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YKAA-310-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:47','TOKO','SMBK-E','E1E','E1E-YKAA-310-0','1','0.530','0.530','1','0.530','0.530','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-YKAA-310-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YKAA-310-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-20251112-0001','1','E1E-YKAA-311-0','1','0.710','0.710','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-YKAA-311-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-YKAA-311-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-11-12 16:36:47' WHERE kode_barang='E1E-YKAA-311-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-YKAA-311-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:47','TOKO','SMBK-E','E1E','E1E-YKAA-311-0','1','0.710','0.710','1','0.710','0.710','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-YKAA-311-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-YKAA-311-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-20251112-0001','1','E1D-YKAA-312-0','1','0.840','0.840','TOKO','SSBK-E','TOKO','SMBK-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-YKAA-312-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-YKAA-312-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-E',tgl_last_beli='2025-11-12 16:36:47' WHERE kode_barang='E1D-YKAA-312-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-YKAA-312-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:36:47','TOKO','SMBK-E','E1D','E1D-YKAA-312-0','1','0.840','0.840','1','0.840','0.840','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-YKAA-312-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-YKAA-312-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251112-0001','2025-11-12','16:36','7.730','input','2025-11-11 16:36:46');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251112-0001','1','H1E-YKAA-140-0','1','2.250','2.250','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YKAA-140-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YKAA-140-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-11-12 16:37:05' WHERE kode_barang='H1E-YKAA-140-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YKAA-140-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:37:05','TOKO','SMBK-H','H1E','H1E-YKAA-140-0','1','2.250','2.250','1','2.250','2.250','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-YKAA-140-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YKAA-140-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-20251112-0001','1','H1E-YKAA-141-0','1','1.710','1.710','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YKAA-141-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YKAA-141-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-11-12 16:37:05' WHERE kode_barang='H1E-YKAA-141-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YKAA-141-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:37:05','TOKO','SMBK-H','H1E','H1E-YKAA-141-0','1','1.710','1.710','1','1.710','1.710','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-YKAA-141-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YKAA-141-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-20251112-0001','1','H1F-YKAA-144-0','1','2.460','2.460','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1F-YKAA-144-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1F-YKAA-144-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-11-12 16:37:05' WHERE kode_barang='H1F-YKAA-144-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1F-YKAA-144-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:37:05','TOKO','SMBK-H','H1F','H1F-YKAA-144-0','1','2.460','2.460','1','2.460','2.460','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1F-YKAA-144-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1F-YKAA-144-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-20251112-0001','1','H2J-YKAA-148-0','1','1.510','1.510','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H2J-YKAA-148-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-YKAA-148-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-11-12 16:37:05' WHERE kode_barang='H2J-YKAA-148-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-YKAA-148-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:37:05','TOKO','SMBK-H','H2J','H2J-YKAA-148-0','1','1.510','1.510','1','1.510','1.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2J' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2J-YKAA-148-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2J-YKAA-148-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-20251112-0001','1','H2J-YKAA-154-0','1','1.480','1.480','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H2J-YKAA-154-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H2J-YKAA-154-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-11-12 16:37:05' WHERE kode_barang='H2J-YKAA-154-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H2J-YKAA-154-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:37:05','TOKO','SMBK-H','H2J','H2J-YKAA-154-0','1','1.480','1.480','1','1.480','1.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='H2J' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H2J' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MJ' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MJ' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H2J-YKAA-154-0';
DELETE FROM tm_barang_export WHERE kode_barang='H2J-YKAA-154-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-20251112-0001','1','H1E-YKAA-175-0','1','0.880','0.880','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YKAA-175-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YKAA-175-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-11-12 16:37:05' WHERE kode_barang='H1E-YKAA-175-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YKAA-175-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:37:05','TOKO','SMBK-H','H1E','H1E-YKAA-175-0','1','0.880','0.880','1','0.880','0.880','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-YKAA-175-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YKAA-175-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251112-0001','2025-11-12','16:36','10.290','input','2025-11-11 16:37:04');
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-20251112-0001','1','PEG-WHXI-32-T','1','1.370','1.370','TOKO','SSBK-P','TOKO','SMBK-P');
DELETE FROM tm_barang WHERE kode_barang='PEG-WHXI-32-T' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PEG-WHXI-32-T' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-P',tgl_last_beli='2025-11-12 16:37:20' WHERE kode_barang='PEG-WHXI-32-T' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PEG-WHXI-32-T' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-12 16:37:20','TOKO','SMBK-P','PEG','PEG-WHXI-32-T','1','1.370','1.370','1','1.370','1.370','100.00');
DELETE FROM tm_dept WHERE kode_dept='PEG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PEG' 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='PEG-WHXI-32-T';
DELETE FROM tm_barang_export WHERE kode_barang='PEG-WHXI-32-T';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251112-0001','2025-11-12','16:37','1.370','input','2025-11-11 16:37:19');