INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260519-0001','1','B1D-ZEAH-5-T','1','0.820','TOKO','PMBK-B');
DELETE FROM tm_barang_export WHERE kode_barang='B1D-ZEAH-5-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='B1D-ZEAH-5-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='B1D' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='B1D' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PMBK-B';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PMBK-B';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='B1D-ZEAH-5-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='0.820',berat_out_asli='0.820', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'0.820',berat_akhir_asli =berat_akhir_asli-'0.820' WHERE kode_barang='B1D-ZEAH-5-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260519-0001','2026-05-19','2026-05-19','08:02','0.820','input','260519');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260519-0002','1','H1E-ZEAH-29-T','1','2.280','TOKO','PMBK-H');
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZEAH-29-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='H1E-ZEAH-29-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='ME' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='ME' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PMBK-H';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PMBK-H';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='H1E-ZEAH-29-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.280',berat_out_asli='2.280', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.280',berat_akhir_asli =berat_akhir_asli-'2.280' WHERE kode_barang='H1E-ZEAH-29-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-260519-0002','2026-05-19','2026-05-19','08:02','2.280','input','260519');
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 ('F226190840551','kasir','1',' MED1 LG ','TOKO','SMBK-D','D1E-ZEXF-46-T','LT SLOBOK BOLA ARESO LG 8K ','OL','0.410','1','100.00','451000','0','0','15000','455000','0','5000','0','460000','TIN','T0079207','D1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZEXF-46-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='D1E-ZEXF-46-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 ('F226190840551','2026-05-19','0.410','2026-05-19','08:40:56','PLG0080196','455000','455000','5000','460000','0','kasir','2026-05-19 08:40:55','F22619084055');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190840551','2026-05-19','08:40:56','TIN','460000','5000');
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-260519-0001','2026-05-19','2026-05-19 08:40:55','PENJUALAN : F226190840551','745583765767','BCA','460000','460000','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-260519-0002','D','2026-05-19','08:40:56','BCA','PENJUALAN','F226190840551','4437252888','460000','4437712888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('745583765767','ALIN');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='460000' WHERE no_faktur_jual='F226190840551' 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 ('F226190856361','kasir','1',' MFD1F X BG','TOKO','SMBK-D','D1F-YBAB-200-0','LT X SLOBOK HURUF BG J 8K ','OL','0.550','1','100.00','616000','0','0','15000','633000','0','5000','0','638000','LUS','00338753','D1F','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YBAB-200-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='2026-05-19' AND kode_barang='D1F-YBAB-200-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 ('F226190856361','2026-05-19','0.550','2026-05-19','08:56:36','PLG0080197','633000','633000','5000','638000','638000','kasir','2026-05-19 08:56:36','F22619085636');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190856361','2026-05-19','08:56:36','LUS','638000','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-260519-0002','D','2026-05-19','08:56:36','kasir','PENJUALAN','F226190856361','9839119000','638000','9839757000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='638000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226190856361' 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 ('F226190856362','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZEXF-89-T','LT SLOBOK BULAT HURUF BG E 8K ','OL','0.560','1','100.00','627000','0','0','15000','644000','0','5000','0','649000','LUS','T0079250','D1F','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZEXF-89-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='2026-05-19' AND kode_barang='D1F-ZEXF-89-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 ('F226190856362','2026-05-19','0.560','2026-05-19','08:56:36','PLG0080198','644000','644000','5000','649000','649000','kasir','2026-05-19 08:56:36','F22619085636');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190856362','2026-05-19','08:56:36','LUS','649000','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-260519-0003','D','2026-05-19','08:56:36','kasir','PENJUALAN','F226190856362','9839757000','649000','9840406000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='649000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226190856362' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190856361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190856361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190856361';
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 ('F226190903591','kasir','1',' TFE2TF MT ','TOKO','TBK-E','E2TF-UGBF-5-T','CC WEDDING MATA MT 18 ','OLS 3354J','2.130','1','100.00','4388000','0','0','15000','4302000','0','333000','0','4635000','TJ','T0013082','E2TF','0','0','-','1','2060000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TF-UGBF-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.130',berat_jual_asli=berat_jual_asli+'2.130',stock_jual='1',berat_akhir=berat_akhir-'2.130',berat_akhir_asli=berat_akhir_asli-'2.130',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='E2TF-UGBF-5-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 ('F226190903591','2026-05-19','2.130','2026-05-19','09:04:00','PLG0080199','4302000','4302000','333000','4635000','4635000','kasir','2026-05-19 09:03:59','F22619090359');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190903591','2026-05-19','09:04:00','TJ','4635000','333000');
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-260519-0004','D','2026-05-19','09:04:00','kasir','PENJUALAN','F226190903591','9840406000','4635000','9845041000');
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 ('F226190907291','kasir','1',' MGPD 5K LG','TOKO','SMBK-P','PDG-YBXE-52-T','LT WG MODEL SOLITAIRE MATA VAR LG 8K ','OLS M990U','0.580','1','100.00','661000','0','0','15000','682000','0','79000','0','761000','TJ','T0066633','PDG','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PDG-YBXE-52-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='2026-05-19' AND kode_barang='PDG-YBXE-52-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 ('F226190907291','2026-05-19','0.580','2026-05-19','09:07:29','PLG0080200','682000','682000','79000','761000','761000','kasir','2026-05-19 09:07:29','F22619090729');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190907291','2026-05-19','09:07:29','TJ','761000','79000');
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-260519-0005','D','2026-05-19','09:07:29','kasir','PENJUALAN','F226190907291','9845041000','761000','9845802000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='761000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226190907291' 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 ('F226190907292','kasir',' 1',' MGPH X KH ','TOKO','SMBK-P','PHG-YCBH-18-T','KL X WG NORY KH 42CM 8K ','OLS 1YC62','2.060','1','100.00','2348000','0','0','15000','2390000','0','169000','0','2559000','TJ','T0068364','PHG','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PHG-YCBH-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='PHG-YCBH-18-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 ('F226190907292','2026-05-19','2.060','2026-05-19','09:07:29','PLG0080201','2390000','2390000','169000','2559000','2559000','kasir','2026-05-19 09:07:29','F22619090729');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190907292','2026-05-19','09:07:29','TJ','2559000','169000');
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-260519-0006','D','2026-05-19','09:07:29','kasir','PENJUALAN','F226190907292','9845802000','2559000','9848361000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2559000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226190907292' 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 ('F226190930341','kasir','1',' MED1E X LG','TOKO','SMBK-D','D1E-ZEXE-160-0','LT X MODEL FG GRAFIR LG 8K ','OL','0.520','1','100.00','572000','0','0','15000','590000','0','5000','0','595000','TJ','00402333','D1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZEXE-160-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='D1E-ZEXE-160-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 ('F226190930341','2026-05-19','0.520','2026-05-19','09:30:35','PLG0080202','590000','590000','5000','595000','595000','kasir','2026-05-19 09:30:34','F22619093034');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190930341','2026-05-19','09:30:35','TJ','595000','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-260519-0007','D','2026-05-19','09:30:35','kasir','PENJUALAN','F226190930341','9848361000','595000','9848956000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='595000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226190930341' 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 ('F226190930342','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-YLAH-43-T','LT CHARM HURUF S BG 8K ','OL','0.680','1','100.00','762000','0','0','15000','785000','0','5000','0','790000','TJ','T0075972','D1F','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YLAH-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='D1F-YLAH-43-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 ('F226190930342','2026-05-19','0.680','2026-05-19','09:30:35','PLG0080203','785000','785000','5000','790000','790000','kasir','2026-05-19 09:30:34','F22619093034');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190930342','2026-05-19','09:30:35','TJ','790000','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-260519-0008','D','2026-05-19','09:30:35','kasir','PENJUALAN','F226190930342','9848956000','790000','9849746000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='790000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226190930342' 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 ('F226190930343','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZDAF-45-T','LT SLOBOK BULAT HURUF BG E 8K ','OL','0.560','1','100.00','627000','0','0','15000','647000','0','5000','0','652000','TJ','T0078711','D1F','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZDAF-45-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='2026-05-19' AND kode_barang='D1F-ZDAF-45-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 ('F226190930343','2026-05-19','0.560','2026-05-19','09:30:35','PLG0080204','647000','647000','5000','652000','652000','kasir','2026-05-19 09:30:34','F22619093034');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190930343','2026-05-19','09:30:35','TJ','652000','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-260519-0009','D','2026-05-19','09:30:35','kasir','PENJUALAN','F226190930343','9849746000','652000','9850398000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='652000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226190930343' 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 ('F226190930344','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZEXF-74-T','CC MODEL PITA PASIR VAR CM 12 8K ','OL','0.820','1','100.00','902000','0','0','15000','931000','0','5000','0','936000','TJ','T0079235','E1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXF-74-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.820',berat_jual_asli=berat_jual_asli+'0.820',stock_jual='1',berat_akhir=berat_akhir-'0.820',berat_akhir_asli=berat_akhir_asli-'0.820',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='E1E-ZEXF-74-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 ('F226190930344','2026-05-19','0.820','2026-05-19','09:30:35','PLG0080205','931000','931000','5000','936000','936000','kasir','2026-05-19 09:30:34','F22619093034');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190930344','2026-05-19','09:30:35','TJ','936000','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-260519-0010','D','2026-05-19','09:30:35','kasir','PENJUALAN','F226190930344','9850398000','936000','9851334000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='936000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226190930344' 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 ('F226190930345','kasir',' 1',' MEB1 HW ','TOKO','SMBK-B','B1E-ZEAE-90-T','GW TRIXIE PANJANG KUPU MATA VAR HW 8K ','OL','0.490','1','100.00','539000','0','0','15000','556000','0','5000','0','561000','TJ','T0079516','B1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEAE-90-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.490',berat_jual_asli=berat_jual_asli+'0.490',stock_jual='1',berat_akhir=berat_akhir-'0.490',berat_akhir_asli=berat_akhir_asli-'0.490',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='B1E-ZEAE-90-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 ('F226190930345','2026-05-19','0.490','2026-05-19','09:30:35','PLG0080206','556000','556000','5000','561000','561000','kasir','2026-05-19 09:30:34','F22619093034');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190930345','2026-05-19','09:30:35','TJ','561000','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-260519-0011','D','2026-05-19','09:30:35','kasir','PENJUALAN','F226190930345','9851334000','561000','9851895000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='561000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226190930345' 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 ('F226190930346','kasir',' 1',' MGB1 LG ','TOKO','SMBK-B','B1G-ZEAE-69-T','GW TUSUK DAISY MATA LG 8K ','OL','0.300','1','100.00','342000','0','0','15000','353000','0','5000','0','358000','TJ','T0079495','B1G','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZEAE-69-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='B1G-ZEAE-69-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 ('F226190930346','2026-05-19','0.300','2026-05-19','09:30:35','PLG0080207','353000','353000','5000','358000','358000','kasir','2026-05-19 09:30:34','F22619093034');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190930346','2026-05-19','09:30:35','TJ','358000','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-260519-0012','D','2026-05-19','09:30:35','kasir','PENJUALAN','F226190930346','9851895000','358000','9852253000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='358000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226190930346' 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 ('F226190930347','kasir',' 1',' MEB1 5K LG','TOKO','SMBK-B','B1E-ZEAE-54-T','GW TUSUK APEL CAT VAR LG PE 8K ','OL','0.470','1','100.00','517000','0','0','15000','533000','0','5000','0','538000','TJ','T0079480','B1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEAE-54-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='B1E-ZEAE-54-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 ('F226190930347','2026-05-19','0.470','2026-05-19','09:30:35','PLG0080208','533000','533000','5000','538000','538000','kasir','2026-05-19 09:30:34','F22619093034');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190930347','2026-05-19','09:30:35','TJ','538000','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-260519-0013','D','2026-05-19','09:30:35','kasir','PENJUALAN','F226190930347','9852253000','538000','9852791000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='538000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226190930347' 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 ('F226190932211','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZEAE-66-T','GL RANTAI HOLLOW MODEL CD VAR HW 8K ','OL','1.110','1','100.00','1221000','0','0','15000','1254000','0','6000','0','1260000','TJ','T0079492','F3E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEAE-66-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.110',berat_jual_asli=berat_jual_asli+'1.110',stock_jual='1',berat_akhir=berat_akhir-'1.110',berat_akhir_asli=berat_akhir_asli-'1.110',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='F3E-ZEAE-66-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 ('F226190932211','2026-05-19','1.110','2026-05-19','09:32:22','PLG0080209','1254000','1254000','6000','1260000','1260000','kasir','2026-05-19 09:32:21','F22619093221');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190932211','2026-05-19','09:32:22','TJ','1260000','6000');
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-260519-0014','D','2026-05-19','09:32:22','kasir','PENJUALAN','F226190932211','9852791000','1260000','9854051000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1260000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226190932211' 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 ('F226190932212','kasir',' 1',' MEF1 UB D5','TOKO','SMBK-F','F1E-ZEAC-12-T','GL OVAL MODEL C UB D58 8K ','OL','2.340','1','100.00','2574000','0','0','15000','2644000','0','12000','0','2656000','TJ','T0079417','F1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEAC-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.340',berat_jual_asli=berat_jual_asli+'2.340',stock_jual='1',berat_akhir=berat_akhir-'2.340',berat_akhir_asli=berat_akhir_asli-'2.340',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='F1E-ZEAC-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 ('F226190932212','2026-05-19','2.340','2026-05-19','09:32:22','PLG0080210','2644000','2644000','12000','2656000','2656000','kasir','2026-05-19 09:32:21','F22619093221');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190932212','2026-05-19','09:32:22','TJ','2656000','12000');
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-260519-0015','D','2026-05-19','09:32:22','kasir','PENJUALAN','F226190932212','9854051000','2656000','9856707000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2656000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226190932212' 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 ('F226190932213','kasir',' 1',' MEF1 UB D5','TOKO','SMBK-F','F1E-ZEAB-1-T','GL OVAL MODEL C UB D54 8K ','OL','1.370','1','100.00','1507000','0','0','15000','1548000','0','7000','0','1555000','TJ','T0079359','F1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEAB-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.370',berat_jual_asli=berat_jual_asli+'1.370',stock_jual='1',berat_akhir=berat_akhir-'1.370',berat_akhir_asli=berat_akhir_asli-'1.370',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='F1E-ZEAB-1-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 ('F226190932213','2026-05-19','1.370','2026-05-19','09:32:22','PLG0080211','1548000','1548000','7000','1555000','1555000','kasir','2026-05-19 09:32:21','F22619093221');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190932213','2026-05-19','09:32:22','TJ','1555000','7000');
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-260519-0016','D','2026-05-19','09:32:22','kasir','PENJUALAN','F226190932213','9856707000','1555000','9858262000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1555000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226190932213' 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 ('F226190932214','kasir',' 1',' MEF1 UB D5','TOKO','SMBK-F','F1E-ZEAB-6-T','GL OVAL MODEL C UB D52 8K ','OL','2.140','1','100.00','2354000','0','0','15000','2419000','0','11000','0','2430000','TJ','T0079364','F1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEAB-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.140',berat_jual_asli=berat_jual_asli+'2.140',stock_jual='1',berat_akhir=berat_akhir-'2.140',berat_akhir_asli=berat_akhir_asli-'2.140',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='F1E-ZEAB-6-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 ('F226190932214','2026-05-19','2.140','2026-05-19','09:32:22','PLG0080212','2419000','2419000','11000','2430000','2430000','kasir','2026-05-19 09:32:21','F22619093221');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190932214','2026-05-19','09:32:22','TJ','2430000','11000');
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-260519-0017','D','2026-05-19','09:32:22','kasir','PENJUALAN','F226190932214','9858262000','2430000','9860692000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2430000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226190932214' 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 ('F226191003591','kasir','1',' MDA1D X UB','TOKO','SMBK-A','A1D-ZEXI-118-0','AT X MODEL MATA VAR UB 8K ','OL','0.960','1','100.00','1037000','0','0','15000','1065000','0','10000','0','1075000','LUS','00402939','A1D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZEXI-118-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='A1D-ZEXI-118-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 ('F226191003591','2026-05-19','0.960','2026-05-19','10:03:59','PLG0080213','1065000','1065000','10000','1075000','1075000','kasir','2026-05-19 10:03:59','F22619100359');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226191003591','2026-05-19','10:03:59','LUS','1075000','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-260519-0018','D','2026-05-19','10:03:59','kasir','PENJUALAN','F226191003591','9860692000','1075000','9861767000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1075000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226191003591' 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 ('F226191003592','kasir',' 1',' MEB1 HW ','TOKO','SMBK-B','B1E-ZEAE-88-T','GW ITALY PANJANG HATI MATA VAR HW 8K ','OL','0.650','1','100.00','715000','0','0','15000','738000','0','5000','0','743000','LUS','T0079514','B1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEAE-88-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='2026-05-19' AND kode_barang='B1E-ZEAE-88-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 ('F226191003592','2026-05-19','0.650','2026-05-19','10:03:59','PLG0080214','738000','738000','5000','743000','743000','kasir','2026-05-19 10:03:59','F22619100359');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226191003592','2026-05-19','10:03:59','LUS','743000','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-260519-0019','D','2026-05-19','10:03:59','kasir','PENJUALAN','F226191003592','9861767000','743000','9862510000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='743000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226191003592' 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 ('F226191003593','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZEXG-23-T','LT SLOBOK KUPU PASIR VAR BG 8K ','OL','0.420','1','100.00','470000','0','0','15000','485000','0','5000','0','490000','LUS','T0079288','D1F','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZEXG-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='D1F-ZEXG-23-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 ('F226191003593','2026-05-19','0.420','2026-05-19','10:03:59','PLG0080215','485000','485000','5000','490000','490000','kasir','2026-05-19 10:03:59','F22619100359');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226191003593','2026-05-19','10:03:59','LUS','490000','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-260519-0020','D','2026-05-19','10:03:59','kasir','PENJUALAN','F226191003593','9862510000','490000','9863000000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='490000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226191003593' 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 ('F226191003594','kasir',' 1',' MDE2 CM 20','TOKO','SMBK-E','E2D-ZEXH-56-T','CC MODEL MATA SLEP VAR CM 20 8K ','OL','1.180','1','100.00','1274000','0','0','15000','1310000','0','6000','0','1316000','LUS','T0079355','E2D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEXH-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.180',berat_jual_asli=berat_jual_asli+'1.180',stock_jual='1',berat_akhir=berat_akhir-'1.180',berat_akhir_asli=berat_akhir_asli-'1.180',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='E2D-ZEXH-56-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 ('F226191003594','2026-05-19','1.180','2026-05-19','10:03:59','PLG0080216','1310000','1310000','6000','1316000','1316000','kasir','2026-05-19 10:03:59','F22619100359');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226191003594','2026-05-19','10:03:59','LUS','1316000','6000');
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-260519-0021','D','2026-05-19','10:03:59','kasir','PENJUALAN','F226191003594','9863000000','1316000','9864316000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1316000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226191003594' 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 ('F226191003595','kasir',' 1',' MEF3E X LG','TOKO','SMBK-F','F3E-ZEXE-115-0','GL X MODEL PAJERO VAR LG 8K ','OL','3.150','1','100.00','3465000','0','0','15000','3559000','0','16000','0','3575000','LUS','00402288','F3E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXE-115-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.150',berat_jual_asli=berat_jual_asli+'3.150',stock_jual='1',berat_akhir=berat_akhir-'3.150',berat_akhir_asli=berat_akhir_asli-'3.150',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='F3E-ZEXE-115-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 ('F226191003595','2026-05-19','3.150','2026-05-19','10:03:59','PLG0080217','3559000','3559000','16000','3575000','3575000','kasir','2026-05-19 10:03:59','F22619100359');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226191003595','2026-05-19','10:03:59','LUS','3575000','16000');
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-260519-0022','D','2026-05-19','10:03:59','kasir','PENJUALAN','F226191003595','9864316000','3575000','9867891000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3575000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226191003595' 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 ('F226191021161','kasir','1',' MDB1 HW PE','TOKO','SMBK-B','B1D-ZACX-40-T','GW TUSUK MODEL HATI MATA VAR HW PE 8K ','','0.830','1','100.00','896000','0','0','15000','915000','0','0','0','915000','TJ','T0076954','B1D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZACX-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='B1D-ZACX-40-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 ('F226191021161','2026-05-19','0.830','2026-05-19','10:21:17','PLG0080218','915000','915000','0','915000','915000','kasir','2026-05-19 10:21:16','F22619102116');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226191021161','2026-05-19','10:21:17','TJ','915000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260519-0023','D','2026-05-19','10:21:17','kasir','PENJUALAN','F226191021161','9867891000','915000','9868806000');
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 ('F226191032151','kasir','1',' MEE1 LG 16','TOKO','SMBK-E','E1E-ZEAE-13-T','CINCIN MODEL LINEA LG 16 8K ','OL','0.530','1','100.00','583000','0','0','15000','602000','0','5000','0','607000','LUS','T0079439','E1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEAE-13-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='2026-05-19' AND kode_barang='E1E-ZEAE-13-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 ('F226191032151','2026-05-19','0.530','2026-05-19','10:32:15','PLG0080219','602000','602000','5000','607000','607000','kasir','2026-05-19 10:32:15','F22619103215');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226191032151','2026-05-19','10:32:15','LUS','607000','5000');
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-260519-0024','D','2026-05-19','10:32:15','kasir','PENJUALAN','F226191032151','9868806000','607000','9869413000');
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 ('F226191048011','kasir','1',' MEF3E X KH','TOKO','SMBK-F','F3E-ZEXB-72-0','GL X RANTAI HOLLOW KH 8K ','OL','2.980','1','100.00','3278000','0','0','15000','3293000','0','15000','0','3308000','TIN','00402088','F3E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXB-72-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.980',berat_jual_asli=berat_jual_asli+'2.980',stock_jual='1',berat_akhir=berat_akhir-'2.980',berat_akhir_asli=berat_akhir_asli-'2.980',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='F3E-ZEXB-72-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 ('F226191048011','2026-05-19','2.980','2026-05-19','10:48:01','PLG0080220','3293000','3293000','15000','3308000','3308000','kasir','2026-05-19 10:48:01','F22619104801');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226191048011','2026-05-19','10:48:01','TIN','3308000','15000');
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-260519-0025','D','2026-05-19','10:48:01','kasir','PENJUALAN','F226191048011','9869413000','3308000','9872721000');
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 ('F226191141381','kasir','1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZEAF-28-T','CC MODEL PITA PASIR VAR CM 15 8K','OL','0.760','1','100.00','836000','0','0','15000','844000','0','5000','0','849000','TIN','T0079550','E1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEAF-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='E1E-ZEAF-28-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 ('F226191141381','2026-05-19','0.760','2026-05-19','11:41:38','PLG0080221','844000','844000','5000','849000','849000','kasir','2026-05-19 11:41:38','F22619114138');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226191141381','2026-05-19','11:41:38','TIN','849000','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-260519-0026','D','2026-05-19','11:41:38','kasir','PENJUALAN','F226191141381','9872721000','849000','9873570000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='849000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226191141381' 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 ('F226191141382','kasir',' 1',' MDE1 5K CM','TOKO','SMBK-E','E1D-ZEAF-27-T','CC MODEL PITA PASIR VAR CM 15 8K ','OL','0.880','1','100.00','950000','0','0','15000','977000','0','5000','0','982000','TIN','T0079549','E1D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEAF-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.880',berat_jual_asli=berat_jual_asli+'0.880',stock_jual='1',berat_akhir=berat_akhir-'0.880',berat_akhir_asli=berat_akhir_asli-'0.880',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='E1D-ZEAF-27-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 ('F226191141382','2026-05-19','0.880','2026-05-19','11:41:38','PLG0080222','977000','977000','5000','982000','982000','kasir','2026-05-19 11:41:38','F22619114138');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226191141382','2026-05-19','11:41:38','TIN','982000','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-260519-0027','D','2026-05-19','11:41:38','kasir','PENJUALAN','F226191141382','9873570000','982000','9874552000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='982000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226191141382' 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 ('F226191141383','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZEXF-72-T','CC MODEL PITA PASIR VAR CM 12 8K ','OL','0.860','1','100.00','946000','0','0','15000','955000','0','5000','0','960000','TIN','T0079233','E1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXF-72-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='E1E-ZEXF-72-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 ('F226191141383','2026-05-19','0.860','2026-05-19','11:41:38','PLG0080223','955000','955000','5000','960000','960000','kasir','2026-05-19 11:41:38','F22619114138');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226191141383','2026-05-19','11:41:38','TIN','960000','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-260519-0028','D','2026-05-19','11:41:38','kasir','PENJUALAN','F226191141383','9874552000','960000','9875512000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='960000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226191141383' 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 ('F226191141384','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZEXF-76-T','CC MODEL PITA PASIR VAR CM 12 8K ','OL','0.980','1','100.00','1078000','0','0','15000','1088000','0','5000','0','1093000','TIN','T0079237','E1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXF-76-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='2026-05-19' AND kode_barang='E1E-ZEXF-76-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 ('F226191141384','2026-05-19','0.980','2026-05-19','11:41:38','PLG0080224','1088000','1088000','5000','1093000','1093000','kasir','2026-05-19 11:41:38','F22619114138');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226191141384','2026-05-19','11:41:38','TIN','1093000','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-260519-0029','D','2026-05-19','11:41:38','kasir','PENJUALAN','F226191141384','9875512000','1093000','9876605000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1093000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226191141384' 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 ('F226191235091','kasir','1',' MEE1 LG 17','TOKO','SMBK-E','E1E-ZEXH-39-T','CC BANGKOK SLEP LG 17 8K ','','0.500','1','100.00','550000','0','0','15000','560000','0','0','0','560000','TJ','T0079338','E1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXH-39-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='2026-05-19' AND kode_barang='E1E-ZEXH-39-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 ('F226191235091','2026-05-19','0.500','2026-05-19','12:35:10','PLG0080225','560000','560000','0','560000','560000','kasir','2026-05-19 12:35:09','F22619123509');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226191235091','2026-05-19','12:35:10','TJ','560000','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-260519-0030','D','2026-05-19','12:35:10','kasir','PENJUALAN','F226191235091','9876605000','560000','9877165000');
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 ('F226191255481','kasir','1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZEAF-28-T','CC MODEL PITA PASIR VAR CM 15 8K','OL','0.760','1','100.00','836000','0','0','15000','859000','0','5000','0','864000','TIN','T0079550','E1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEAF-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='E1E-ZEAF-28-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 ('F226191255481','2026-05-19','0.760','2026-05-19','12:55:48','PLG0080226','859000','859000','5000','864000','864000','kasir','2026-05-19 12:55:48','F22619125548');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226191255481','2026-05-19','12:55:48','TIN','864000','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-260519-0036','D','2026-05-19','12:55:48','kasir','PENJUALAN','F226191255481','9869973000','864000','9870837000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='864000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226191255481' 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 ('F226191255482','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZEXF-72-T','CC MODEL PITA PASIR VAR CM 12 8K ','OL','0.860','1','100.00','946000','0','0','15000','972000','0','5000','0','977000','TIN','T0079233','E1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXF-72-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='E1E-ZEXF-72-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 ('F226191255482','2026-05-19','0.860','2026-05-19','12:55:48','PLG0080227','972000','972000','5000','977000','977000','kasir','2026-05-19 12:55:48','F22619125548');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226191255482','2026-05-19','12:55:48','TIN','977000','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-260519-0037','D','2026-05-19','12:55:48','kasir','PENJUALAN','F226191255482','9870837000','977000','9871814000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='977000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226191255482' 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 ('F226191255483','kasir',' 1',' MDE1 5K CM','TOKO','SMBK-E','E1D-ZEAF-27-T','CC MODEL PITA PASIR VAR CM 15 8K ','OL','0.880','1','100.00','950000','0','0','15000','994000','0','5000','0','999000','TIN','T0079549','E1D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEAF-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.880',berat_jual_asli=berat_jual_asli+'0.880',stock_jual='1',berat_akhir=berat_akhir-'0.880',berat_akhir_asli=berat_akhir_asli-'0.880',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='E1D-ZEAF-27-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 ('F226191255483','2026-05-19','0.880','2026-05-19','12:55:48','PLG0080228','994000','994000','5000','999000','999000','kasir','2026-05-19 12:55:48','F22619125548');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226191255483','2026-05-19','12:55:48','TIN','999000','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-260519-0038','D','2026-05-19','12:55:48','kasir','PENJUALAN','F226191255483','9871814000','999000','9872813000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='999000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226191255483' 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 ('F226191255484','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZEXF-76-T','CC MODEL PITA PASIR VAR CM 12 8K ','OL','0.980','1','100.00','1078000','0','0','15000','1107000','0','5000','0','1112000','TIN','T0079237','E1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXF-76-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='2026-05-19' AND kode_barang='E1E-ZEXF-76-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 ('F226191255484','2026-05-19','0.980','2026-05-19','12:55:48','PLG0080229','1107000','1107000','5000','1112000','1112000','kasir','2026-05-19 12:55:48','F22619125548');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226191255484','2026-05-19','12:55:48','TIN','1112000','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-260519-0039','D','2026-05-19','12:55:48','kasir','PENJUALAN','F226191255484','9872813000','1112000','9873925000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1112000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226191255484' 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 ('F226190109001','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZCAH-11-T','CC WEDDING MATA CM 16 8K ','','1.050','1','100.00','1134000','0','0','15000','1155000','0','10000','0','1165000','LUS','T0078199','E2D','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAH-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='E2D-ZCAH-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 ('F226190109001','2026-05-19','1.050','2026-05-19','13:09:00','PLG0080230','1155000','1155000','10000','1165000','1165000','kasir','2026-05-19 13:09:00','F22619010900');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190109001','2026-05-19','13:09:00','LUS','1165000','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-260519-0040','D','2026-05-19','13:09:00','kasir','PENJUALAN','F226190109001','9873925000','1165000','9875090000');
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 ('F226190109291','kasir','1',' MEF3E X KH','TOKO','SMBK-F','F3E-ZEXB-72-0','GL X RANTAI HOLLOW KH 8K ','OL','2.980','1','100.00','3278000','0','0','15000','3352000','0','15000','0','3367000','TIN','00402088','F3E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXB-72-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.980',berat_jual_asli=berat_jual_asli+'2.980',stock_jual='1',berat_akhir=berat_akhir-'2.980',berat_akhir_asli=berat_akhir_asli-'2.980',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='F3E-ZEXB-72-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 ('F226190109291','2026-05-19','2.980','2026-05-19','13:09:29','PLG0080231','3352000','3352000','15000','3367000','3367000','kasir','2026-05-19 13:09:29','F22619010929');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190109291','2026-05-19','13:09:29','TIN','3367000','15000');
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-260519-0041','D','2026-05-19','13:09:29','kasir','PENJUALAN','F226190109291','9875090000','3367000','9878457000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190109001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190109001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190109001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190109291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190109291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190109291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190840551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190840551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190840551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190856362' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190856362' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190856362';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190903591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190903591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190903591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190907291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190907291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190907291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190907292' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190907292' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190907292';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190930341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190930341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190930341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190930342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190930342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190930342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190930343' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190930343' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190930343';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190930344' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190930344' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190930344';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190930345' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190930345' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190930345';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190930346' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190930346' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190930346';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190930347' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190930347' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190930347';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190932211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190932211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190932211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190932212' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190932212' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190932212';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190932213' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190932213' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190932213';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190932214' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190932214' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190932214';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226191003591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226191003591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226191003591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226191003592' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226191003592' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226191003592';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226191003593' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226191003593' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226191003593';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226191003594' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226191003594' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226191003594';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226191003595' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226191003595' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226191003595';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226191021161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226191021161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226191021161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226191032151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226191032151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226191032151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226191235091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226191235091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226191235091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226191255481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226191255481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226191255481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226191255482' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226191255482' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226191255482';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226191255483' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226191255483' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226191255483';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226191255484' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226191255484' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226191255484';
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 ('F226190258541','kasir','1',' MEB1 X CM ','TOKO','SMBK-B','B1E-YJXA-32-0','GW X MODEL SLEP CM PE 8K ','OL','0.680','1','100.00','748000','0','0','15000','772000','0','5000','0','777000','TIN','00371277','B1E','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJXA-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='B1E-YJXA-32-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 ('F226190258541','2026-05-19','0.680','2026-05-19','14:58:55','PLG0080232','772000','772000','5000','777000','777000','kasir','2026-05-19 14:58:54','F22619025854');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190258541','2026-05-19','14:58:55','TIN','777000','5000');
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-260519-0042','D','2026-05-19','14:58:55','kasir','PENJUALAN','F226190258541','9878457000','777000','9879234000');
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-00005366','X-00005366','LT COR M 17K','GR','---','D2TE','BELI','BELI001','1418000','2026-05-19','0.870','1','kasir','2026-05-19 15:27:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2TE','X-00005366','X-00005366');
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-260519-0001','F221111249062','TIN','1','BELI','BELI001','D2TE', 'X-00005366', 'LT COR M 17K','1.270','0.870','100.00','864000','1418000','1629885','2000000','1','1418000','1418000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.870',berat_beli_asli=berat_beli_asli+'0.870',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.870',berat_akhir_asli=berat_akhir_asli+'0.870',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2TE' 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-260519-0001','2026-05-19','2026-05-19','15:27:57','TIN','---','0.870','1418000','1418000','1418000','1418000','1418000','kasir','2026-05-19 15:27:57','FB-260519-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260519-0001','NINIK','KERENAYU','081615444468','','','kasir','2026-05-19 15:27:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-19' 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-260519-0043','K','2026-05-19','15:27:57','kasir','PEMBELIAN UMUM','FB-260519-0001','9879234000','1418000','9877816000');
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-00005367','X-00005367','AT X ITALY SLEP VAR BW 8K','GR','---','A1F','BELI','BELI001','357000','2026-05-19','0.450','1','kasir','2026-05-19 15:28:46');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00005367','X-00005367');
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-260519-0002','F224031017121','LUS','1','BELI','BELI001','A1F', 'X-00005367', 'AT X ITALY SLEP VAR BW 8K','0.510','0.450','100.00','325000','357000','793333','1120000','1','357000','357000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.450',berat_beli_asli=berat_beli_asli+'0.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.450',berat_akhir_asli=berat_akhir_asli+'0.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260519-0002','2026-05-19','2026-05-19','15:28:46','LUS','---','0.450','357000','357000','357000','357000','357000','kasir','2026-05-19 15:28:46','FB-260519-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260519-0002','SILVI','SLAHUNG 2/1','','','0895810094488','kasir','2026-05-19 15:28:46');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-19' 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-260519-0044','K','2026-05-19','15:28:46','kasir','PEMBELIAN UMUM','FB-260519-0002','9877816000','357000','9877459000');
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-00005368','X-00005368','CC MODEL MATA VAR LG 10 8K','GR','---','E2E','BELI','BELI001','395000','2026-05-19','0.520','1','kasir','2026-05-19 15:29:27');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00005368','X-00005368');
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-260519-0003','F225110810541','TIN','1','BELI','BELI001','E2E', 'X-00005368', 'CC MODEL MATA VAR LG 10 8K','0.520','0.520','100.00','430000','395000','759615','1100000','1','395000','395000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.520',berat_beli_asli=berat_beli_asli+'0.520',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.520',berat_akhir_asli=berat_akhir_asli+'0.520',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-19' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260519-0003','2026-05-19','2026-05-19','15:29:27','TIN','---','0.520','395000','395000','395000','395000','395000','kasir','2026-05-19 15:29:27','FB-260519-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260519-0003','WIDIA','PERUM BUKIT ASRI B2 NO 3','','','0816292389','kasir','2026-05-19 15:29:27');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-19' 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-260519-0045','K','2026-05-19','15:29:27','kasir','PEMBELIAN UMUM','FB-260519-0003','9877459000','395000','9877064000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190258541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190258541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190258541';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260519-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260519-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260519-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260519-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260519-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260519-0003';
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 ('F226190407151','admin','1',' TEF1 X OR ','TOKO','TBK-F','F1TE-ZDXD-156-T','GL X SHOGUN POLOS OR D56 17K ','','4.980','1','100.00','9960000','0','0','15000','10000000','0','0','0','10000000','LUS','T0078443','F1TE','0','0','-','0','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-05-19', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-ZDXD-156-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.980',berat_jual_asli=berat_jual_asli+'4.980',stock_jual='1',berat_akhir=berat_akhir-'4.980',berat_akhir_asli=berat_akhir_asli-'4.980',stock_akhir='0' WHERE tanggal='2026-05-19' AND kode_barang='F1TE-ZDXD-156-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226190407151','2026-05-19','4.980','2026-05-19','16:07:15','PLG0080233','10000000','10000000','0','10000000','10000000','admin','2026-05-19 16:07:15','F22619040715');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-05-19','F226190407151','2026-05-19','16:07:15','LUS','10000000','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-260519-0046','D','2026-05-19','16:07:15','admin','PENJUALAN','F226190407151','9877064000','10000000','9887064000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226190407151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226190407151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226190407151';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-20','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-19';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-19';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-19';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-05-19' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-19';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-19';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-19';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-19';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-20' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-19' 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-260520-0001','D','2026-05-20','16:29:30','SYSTEM','SALDO AWAL','SALDO AWAL','0','9887064000','9887064000');
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-260520-0001','D','2026-05-20','16:29:30','BCA','SALDO AWAL','SALDO AWAL','0','4437712888','4437712888');
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-260520-0001','D','2026-05-20','16:29:30','','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-260520-0001','D','2026-05-20','16:29:30','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-260520-0001','D','2026-05-20','16:29:30','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-260520-0001','D','2026-05-20','16:29:30','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2026-05-20';