INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-20','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-19';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-19';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-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='2025-10-19' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-19';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-19';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-19';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-19';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-20' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-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-251020-0001','D','2025-10-20','07:45:21','SYSTEM','SALDO AWAL','SALDO AWAL','0','1570138000','1570138000');
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-251020-0001','D','2025-10-20','07:45:21','','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-251020-0001','D','2025-10-20','07:45:21','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-251020-0001','D','2025-10-20','07:45:21','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-251020-0001','D','2025-10-20','07:45:21','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251020-0001','D','2025-10-20','07:45:21','BCA','SALDO AWAL','SALDO AWAL','0','4070872888','4070872888');
UPDATE tp_system SET tgl_system='2025-10-20';
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 ('F225200823471','kasir','1',' MEH1 10K K','TOKO','SMBK-H','H1E-YDAE-12-0','KL SANTA MODEL HATI MATA VAR KH 8K ','','2.710','1','100.00','2873000','0','0','15000','2900000','0','10000','0','2910000','RTA','00349481','H1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YDAE-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.710',berat_jual_asli=berat_jual_asli+'2.710',stock_jual='1',berat_akhir=berat_akhir-'2.710',berat_akhir_asli=berat_akhir_asli-'2.710',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='H1E-YDAE-12-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225200823471','2025-10-20','2.710','2025-10-20','08:23:47','PLG0073791','2900000','2900000','10000','2910000','2910000','kasir','2025-10-20 08:23:47','F22520082347');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200823471','2025-10-20','08:23:47','RTA','2910000','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-251020-0002','D','2025-10-20','08:23:47','kasir','PENJUALAN','F225200823471','1570138000','2910000','1573048000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2910000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225200823471' 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 ('F225200823472','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-YFXD-13-T','GL RANTAI HOLLOW PLAT VAR UB 8K ','','3.050','1','100.00','3233000','0','0','15000','3265000','0','0','0','3265000','RTA','T0069757','F3E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YFXD-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='F3E-YFXD-13-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 ('F225200823472','2025-10-20','3.050','2025-10-20','08:23:47','PLG0073792','3265000','3265000','0','3265000','3265000','kasir','2025-10-20 08:23:47','F22520082347');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200823472','2025-10-20','08:23:47','RTA','3265000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251020-0003','D','2025-10-20','08:23:47','kasir','PENJUALAN','F225200823472','1573048000','3265000','1576313000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3265000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225200823472' 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 ('F225200900161','kasir','1',' MEE2 CM 16','TOKO','SMBK-E','E2E-YJXF-14-T','CC MODEL HATI MATA CM 16 8K ','OL','0.650','1','100.00','689000','0','0','15000','702000','0','5000','0','707000','RTA','T0073912','E2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXF-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E2E-YJXF-14-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 ('F225200900161','2025-10-20','0.650','2025-10-20','09:00:17','PLG0073793','702000','702000','5000','707000','707000','kasir','2025-10-20 09:00:16','F22520090016');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200900161','2025-10-20','09:00:17','RTA','707000','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-251020-0004','D','2025-10-20','09:00:17','kasir','PENJUALAN','F225200900161','1576313000','707000','1577020000');
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 ('F225200915391','kasir','1',' MED1E LG ','TOKO','SMBK-D','D1E-YJAE-17-T','LT MODEL FINE GOLD LG 8K ','OL','0.520','1','100.00','551000','0','0','15000','565000','0','5000','0','570000','RTA','T0074066','D1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJAE-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='D1E-YJAE-17-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 ('F225200915391','2025-10-20','0.520','2025-10-20','09:15:39','PLG0073794','565000','565000','5000','570000','570000','kasir','2025-10-20 09:15:39','F22520091539');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200915391','2025-10-20','09:15:39','RTA','570000','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-251020-0005','D','2025-10-20','09:15:39','kasir','PENJUALAN','F225200915391','1577020000','570000','1577590000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='570000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225200915391' 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 ('F225200915392','kasir',' 1',' MED1E LG ','TOKO','SMBK-D','D1E-YJAE-20-T','LT MODEL FINE GOLD LG 8K ','OL','0.520','1','100.00','551000','0','0','15000','565000','0','5000','0','570000','RTA','T0074069','D1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJAE-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='D1E-YJAE-20-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 ('F225200915392','2025-10-20','0.520','2025-10-20','09:15:39','PLG0073795','565000','565000','5000','570000','570000','kasir','2025-10-20 09:15:39','F22520091539');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200915392','2025-10-20','09:15:39','RTA','570000','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-251020-0006','D','2025-10-20','09:15:39','kasir','PENJUALAN','F225200915392','1577590000','570000','1578160000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='570000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225200915392' 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 ('F225200929521','kasir','1',' MEH1 10K H','TOKO','SMBK-H','H1E-YIBB-28-T','KL SANTA MODEL CAT VAR HW 8K ','','2.140','1','100.00','2268000','0','0','15000','2290000','0','10000','0','2300000','TJ','T0073164','H1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YIBB-28-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='2025-10-20' AND kode_barang='H1E-YIBB-28-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225200929521','2025-10-20','2.140','2025-10-20','09:29:52','PLG0073796','2290000','2290000','10000','2300000','0','kasir','2025-10-20 09:29:52','F22520092952');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200929521','2025-10-20','09:29:52','TJ','2300000','10000');
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-251020-0001','2025-10-20','2025-10-20 09:29:52','PENJUALAN : F225200929521','764984798405','BCA','2300000','2300000','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-251020-0002','D','2025-10-20','09:29:52','BCA','PENJUALAN','F225200929521','4070872888','2300000','4073172888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('764984798405','ADE');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2300000' WHERE no_faktur_jual='F225200929521' 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 ('F225200931501','kasir','1',' MEA1E X LG','TOKO','SMBK-A','A1E-YIAE-25-0','AT X GYPSY MATA ANAK LG 8K ','','0.600','1','100.00','636000','0','0','15000','642000','0','0','0','642000','TJ','00369476','A1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YIAE-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='A1E-YIAE-25-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 ('F225200931501','2025-10-20','0.600','2025-10-20','09:31:50','PLG0073797','642000','642000','0','642000','642000','kasir','2025-10-20 09:31:50','F22520093150');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200931501','2025-10-20','09:31:50','TJ','642000','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-251020-0007','D','2025-10-20','09:31:50','kasir','PENJUALAN','F225200931501','1578160000','642000','1578802000');
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 ('F225200943081','kasir','1',' MFH1 X HW ','TOKO','SMBK-H','H1F-XCAI-176-0','KL X CASANO PANJANG HW 64 8K ','','1.400','1','100.00','1512000','0','0','15000','1512000','0','0','0','1512000','TJ','00286761','H1F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-XCAI-176-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.400',berat_jual_asli=berat_jual_asli+'1.400',stock_jual='1',berat_akhir=berat_akhir-'1.400',berat_akhir_asli=berat_akhir_asli-'1.400',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='H1F-XCAI-176-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225200943081','2025-10-20','1.400','2025-10-20','09:43:09','PLG0073798','1512000','1512000','0','1512000','1512000','kasir','2025-10-20 09:43:08','F22520094308');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200943081','2025-10-20','09:43:09','TJ','1512000','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-251020-0008','D','2025-10-20','09:43:09','kasir','PENJUALAN','F225200943081','1578802000','1512000','1580314000');
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 ('F225201006051','kasir','1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YJXD-73-T','GW TUSUK MODEL MATA VAR LG PE 8K ','','0.550','1','100.00','583000','0','0','15000','589000','0','0','0','589000','TJ','T0073887','B1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJXD-73-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='B1E-YJXD-73-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 ('F225201006051','2025-10-20','0.550','2025-10-20','10:06:05','PLG0073799','589000','589000','0','589000','589000','kasir','2025-10-20 10:06:05','F22520100605');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201006051','2025-10-20','10:06:05','TJ','589000','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-251020-0009','D','2025-10-20','10:06:05','kasir','PENJUALAN','F225201006051','1580314000','589000','1580903000');
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 ('F225201010041','kasir','1',' MGD1 5K LG','TOKO','SMBK-D','D1G-YIXH-56-T','LT MODEL BONEKA CAT VAR LG 8K ','','0.370','1','100.00','407000','0','0','15000','411000','0','5000','0','416000','RTA','T0073065','D1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YIXH-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='D1G-YIXH-56-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225201010041','2025-10-20','0.370','2025-10-20','10:10:05','PLG0073800','411000','411000','5000','416000','0','kasir','2025-10-20 10:10:04','F22520101004');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201010041','2025-10-20','10:10:05','RTA','416000','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-251020-0002','2025-10-20','2025-10-20 10:10:04','PENJUALAN : F225201010041','988787766556','BCA','416000','416000','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-251020-0003','D','2025-10-20','10:10:05','BCA','PENJUALAN','F225201010041','4073172888','416000','4073588888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('988787766556','DESSY');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='416000' WHERE no_faktur_jual='F225201010041' 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 ('F225201011491','kasir','1',' MEA1 5K LG','TOKO','SMBK-A','A1E-YFBD-79-T','AT ANAK BONEKA CAT VAR LG 8K ','','0.530','1','100.00','562000','0','0','15000','567000','0','5000','0','572000','RTA','T0070299','A1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YFBD-79-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='A1E-YFBD-79-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225201011491','2025-10-20','0.530','2025-10-20','10:11:49','PLG0073801','567000','567000','5000','572000','0','kasir','2025-10-20 10:11:49','F22520101149');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201011491','2025-10-20','10:11:49','RTA','572000','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-251020-0003','2025-10-20','2025-10-20 10:11:49','PENJUALAN : F225201011491','9889877876','BCA','572000','572000','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-251020-0004','D','2025-10-20','10:11:49','BCA','PENJUALAN','F225201011491','4073588888','572000','4074160888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('9889877876','DESY');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='572000' WHERE no_faktur_jual='F225201011491' 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 ('F225201022531','kasir','1',' MEE2 5K LG','TOKO','SMBK-E','E2E-YFXD-27-T','CC MODEL BONEKA CAT VAR LG 8K ','','0.480','1','100.00','509000','0','0','15000','514000','0','5000','0','519000','TJ','T0069771','E2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YFXD-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E2E-YFXD-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 ('F225201022531','2025-10-20','0.480','2025-10-20','10:22:53','PLG0073802','514000','514000','5000','519000','519000','kasir','2025-10-20 10:22:53','F22520102253');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201022531','2025-10-20','10:22:53','TJ','519000','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-251020-0010','D','2025-10-20','10:22:53','kasir','PENJUALAN','F225201022531','1580903000','519000','1581422000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='519000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201022531' 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 ('F225201022532','kasir',' 1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YIAB-268-0','CC X MODEL MATA CM 14 8K ','','0.960','1','100.00','998000','0','0','15000','1008000','0','0','0','1008000','TJ','00369045','E2D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIAB-268-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='2025-10-20' AND kode_barang='E2D-YIAB-268-0' 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 ('F225201022532','2025-10-20','0.960','2025-10-20','10:22:53','PLG0073803','1008000','1008000','0','1008000','1008000','kasir','2025-10-20 10:22:53','F22520102253');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201022532','2025-10-20','10:22:53','TJ','1008000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251020-0011','D','2025-10-20','10:22:53','kasir','PENJUALAN','F225201022532','1581422000','1008000','1582430000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1008000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201022532' 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 ('F225201030431','kasir','1',' MDE2 5K CM','TOKO','SMBK-E','E2D-YEBX-28-T','CC MODEL MATA VAR CM 16 8K ','OL','1.000','1','100.00','1040000','0','0','15000','1080000','0','5000','0','1085000','RTA','T0069400','E2D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YEBX-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E2D-YEBX-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 ('F225201030431','2025-10-20','1.000','2025-10-20','10:30:44','PLG0073804','1080000','1080000','5000','1085000','1085000','kasir','2025-10-20 10:30:43','F22520103043');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201030431','2025-10-20','10:30:44','RTA','1085000','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-251020-0012','D','2025-10-20','10:30:44','kasir','PENJUALAN','F225201030431','1582430000','1085000','1583515000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1085000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201030431' 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 ('F225201030432','kasir',' 1',' MDE2 X BM ','TOKO','SMBK-E','E2D-YFAD-63-0','CC X MODEL MATA BM 16 8K ','OL','2.150','1','100.00','2236000','0','0','15000','2322000','0','11000','0','2333000','RTA','00357343','E2D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YFAD-63-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.150',berat_jual_asli=berat_jual_asli+'2.150',stock_jual='1',berat_akhir=berat_akhir-'2.150',berat_akhir_asli=berat_akhir_asli-'2.150',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E2D-YFAD-63-0' 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 ('F225201030432','2025-10-20','2.150','2025-10-20','10:30:44','PLG0073805','2322000','2322000','11000','2333000','2333000','kasir','2025-10-20 10:30:43','F22520103043');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201030432','2025-10-20','10:30:44','RTA','2333000','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-251020-0013','D','2025-10-20','10:30:44','kasir','PENJUALAN','F225201030432','1583515000','2333000','1585848000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2333000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201030432' 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 ('F225201032061','kasir','1',' MDE2X 10K ','TOKO','SMBK-E','E2D-YHCX-8-T','CC X WEDDING MATA BM 21 8K ','','1.750','1','100.00','1820000','0','0','15000','1838000','0','10000','0','1848000','TJ','T0072719','E2D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YHCX-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.750',berat_jual_asli=berat_jual_asli+'1.750',stock_jual='1',berat_akhir=berat_akhir-'1.750',berat_akhir_asli=berat_akhir_asli-'1.750',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E2D-YHCX-8-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 ('F225201032061','2025-10-20','1.750','2025-10-20','10:32:06','PLG0073806','1838000','1838000','10000','1848000','1848000','kasir','2025-10-20 10:32:06','F22520103206');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201032061','2025-10-20','10:32:06','TJ','1848000','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-251020-0014','D','2025-10-20','10:32:06','kasir','PENJUALAN','F225201032061','1585848000','1848000','1587696000');
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 ('F225201119111','kasir','1',' MEH1 X HW ','TOKO','SMBK-H','H1E-YJAC-101-0','KL X TIFF HATI VAR HW 42 8K ','OL','1.440','1','100.00','1526000','0','0','15000','1555000','0','7000','0','1562000','RTA','00372831','H1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJAC-101-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.440',berat_jual_asli=berat_jual_asli+'1.440',stock_jual='1',berat_akhir=berat_akhir-'1.440',berat_akhir_asli=berat_akhir_asli-'1.440',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='H1E-YJAC-101-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225201119111','2025-10-20','1.440','2025-10-20','11:19:11','PLG0073807','1555000','1555000','7000','1562000','1562000','kasir','2025-10-20 11:19:11','F22520111911');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201119111','2025-10-20','11:19:11','RTA','1562000','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-251020-0015','D','2025-10-20','11:19:11','kasir','PENJUALAN','F225201119111','1587696000','1562000','1589258000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1562000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201119111' 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 ('F225201119112','kasir',' 1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YJAA-37-0','CC X SOLITAIRE MATA CM 16 8K ','OL','1.020','1','100.00','1061000','0','0','15000','1097000','0','10000','0','1107000','RTA','00372575','E2D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJAA-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E2D-YJAA-37-0' 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 ('F225201119112','2025-10-20','1.020','2025-10-20','11:19:11','PLG0073808','1097000','1097000','10000','1107000','1107000','kasir','2025-10-20 11:19:11','F22520111911');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201119112','2025-10-20','11:19:11','RTA','1107000','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-251020-0016','D','2025-10-20','11:19:11','kasir','PENJUALAN','F225201119112','1589258000','1107000','1590365000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1107000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201119112' 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 ('F225201119113','kasir',' 1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YJAC-307-0','CC X SOLITAIRE MATA CM 16 8K ','OL','1.040','1','100.00','1082000','0','0','15000','1121000','0','7000','0','1128000','RTA','00373037','E2D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJAC-307-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.040',berat_jual_asli=berat_jual_asli+'1.040',stock_jual='1',berat_akhir=berat_akhir-'1.040',berat_akhir_asli=berat_akhir_asli-'1.040',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E2D-YJAC-307-0' 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 ('F225201119113','2025-10-20','1.040','2025-10-20','11:19:11','PLG0073809','1121000','1121000','7000','1128000','1128000','kasir','2025-10-20 11:19:11','F22520111911');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201119113','2025-10-20','11:19:11','RTA','1128000','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-251020-0017','D','2025-10-20','11:19:11','kasir','PENJUALAN','F225201119113','1590365000','1128000','1591493000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1128000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201119113' 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 ('F225201119114','kasir',' 1',' MEE2 X UB ','TOKO','SMBK-E','E2E-YJAC-299-0','CC X SOLITAIRE MATA UB 16 8K ','OL','0.690','1','100.00','731000','0','0','15000','747000','0','7000','0','754000','RTA','00373029','E2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJAC-299-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.690',berat_jual_asli=berat_jual_asli+'0.690',stock_jual='1',berat_akhir=berat_akhir-'0.690',berat_akhir_asli=berat_akhir_asli-'0.690',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E2E-YJAC-299-0' 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 ('F225201119114','2025-10-20','0.690','2025-10-20','11:19:11','PLG0073810','747000','747000','7000','754000','754000','kasir','2025-10-20 11:19:11','F22520111911');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201119114','2025-10-20','11:19:11','RTA','754000','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-251020-0018','D','2025-10-20','11:19:11','kasir','PENJUALAN','F225201119114','1591493000','754000','1592247000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='754000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201119114' 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 ('F225201119115','kasir',' 1',' MEE2E HW 1','TOKO','SMBK-E','E2E-YJAH-28-T','CC MODEL MATA HW 13 8K ','OL','0.480','1','100.00','509000','0','0','15000','521000','0','5000','0','526000','RTA','T0074241','E2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJAH-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E2E-YJAH-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 ('F225201119115','2025-10-20','0.480','2025-10-20','11:19:11','PLG0073811','521000','521000','5000','526000','526000','kasir','2025-10-20 11:19:11','F22520111911');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201119115','2025-10-20','11:19:11','RTA','526000','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-251020-0019','D','2025-10-20','11:19:11','kasir','PENJUALAN','F225201119115','1592247000','526000','1592773000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='526000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201119115' 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 ('F225201119116','kasir',' 1',' MEE2E HW 1','TOKO','SMBK-E','E2E-YJAH-29-T','CC MODEL MATA HW 17 8K ','OL','0.520','1','100.00','551000','0','0','15000','564000','0','5000','0','569000','RTA','T0074242','E2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJAH-29-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E2E-YJAH-29-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 ('F225201119116','2025-10-20','0.520','2025-10-20','11:19:11','PLG0073812','564000','564000','5000','569000','569000','kasir','2025-10-20 11:19:11','F22520111911');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201119116','2025-10-20','11:19:11','RTA','569000','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-251020-0020','D','2025-10-20','11:19:11','kasir','PENJUALAN','F225201119116','1592773000','569000','1593342000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='569000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201119116' 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 ('F225201119117','kasir',' 1',' MEE2E HW 1','TOKO','SMBK-E','E2E-YJAH-27-T','CC MODEL MATA HW 15 8K ','OL','0.450','1','100.00','477000','0','0','15000','488000','0','5000','0','493000','RTA','T0074240','E2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJAH-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E2E-YJAH-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 ('F225201119117','2025-10-20','0.450','2025-10-20','11:19:11','PLG0073813','488000','488000','5000','493000','493000','kasir','2025-10-20 11:19:11','F22520111911');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201119117','2025-10-20','11:19:11','RTA','493000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251020-0021','D','2025-10-20','11:19:11','kasir','PENJUALAN','F225201119117','1593342000','493000','1593835000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='493000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201119117' 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 ('F225201119118','kasir',' 1',' MHD1 5K BG','TOKO','SMBK-D','D1H-YIBD-14-T','LT SLOBOK BOLA KRAWANG BG 8K ','OL','0.260','1','100.00','291000','0','0','15000','298000','0','5000','0','303000','RTA','T0073276','D1H','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1H-YIBD-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='D1H-YIBD-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225201119118','2025-10-20','0.260','2025-10-20','11:19:11','PLG0073814','298000','298000','5000','303000','303000','kasir','2025-10-20 11:19:11','F22520111911');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201119118','2025-10-20','11:19:11','RTA','303000','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-251020-0022','D','2025-10-20','11:19:11','kasir','PENJUALAN','F225201119118','1593835000','303000','1594138000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='303000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201119118' 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 ('F225201119119','kasir',' 1',' MHD1 5K BG','TOKO','SMBK-D','D1H-YIBD-13-T','LT SLOBOK BOLA KRAWANG BG 8K ','OL','0.270','1','100.00','302000','0','0','15000','309000','0','5000','0','314000','RTA','T0073275','D1H','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1H-YIBD-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.270',berat_jual_asli=berat_jual_asli+'0.270',stock_jual='1',berat_akhir=berat_akhir-'0.270',berat_akhir_asli=berat_akhir_asli-'0.270',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='D1H-YIBD-13-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 ('F225201119119','2025-10-20','0.270','2025-10-20','11:19:11','PLG0073815','309000','309000','5000','314000','314000','kasir','2025-10-20 11:19:11','F22520111911');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201119119','2025-10-20','11:19:11','RTA','314000','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-251020-0023','D','2025-10-20','11:19:11','kasir','PENJUALAN','F225201119119','1594138000','314000','1594452000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='314000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201119119' 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 ('F225201120581','kasir','1',' MED1E LG ','TOKO','SMBK-D','D1E-YJAE-21-T','LT MODEL FINE GOLD LG 8K ','OL','0.550','1','100.00','583000','0','0','15000','597000','0','5000','0','602000','RTA','T0074070','D1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJAE-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='D1E-YJAE-21-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 ('F225201120581','2025-10-20','0.550','2025-10-20','11:20:59','PLG0073816','597000','597000','5000','602000','602000','kasir','2025-10-20 11:20:58','F22520112058');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201120581','2025-10-20','11:20:59','RTA','602000','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-251020-0024','D','2025-10-20','11:20:59','kasir','PENJUALAN','F225201120581','1594452000','602000','1595054000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='602000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201120581' 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 ('F225201120582','kasir',' 1',' MED1E LG ','TOKO','SMBK-D','D1E-YJAE-19-T','LT MODEL FINE GOLD LG 8K ','OL','0.550','1','100.00','583000','0','0','15000','597000','0','5000','0','602000','RTA','T0074068','D1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJAE-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='D1E-YJAE-19-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 ('F225201120582','2025-10-20','0.550','2025-10-20','11:20:59','PLG0073817','597000','597000','5000','602000','602000','kasir','2025-10-20 11:20:58','F22520112058');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201120582','2025-10-20','11:20:59','RTA','602000','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-251020-0025','D','2025-10-20','11:20:59','kasir','PENJUALAN','F225201120582','1595054000','602000','1595656000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='602000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201120582' 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 ('F225201120583','kasir',' 1',' MFD1F BM ','TOKO','SMBK-D','D1F-YJAE-11-T','LT MODEL PLAT BM 8K ','OL','0.400','1','100.00','432000','0','0','15000','442000','0','5000','0','447000','RTA','T0074060','D1F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YJAE-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='D1F-YJAE-11-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 ('F225201120583','2025-10-20','0.400','2025-10-20','11:20:59','PLG0073818','442000','442000','5000','447000','447000','kasir','2025-10-20 11:20:58','F22520112058');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201120583','2025-10-20','11:20:59','RTA','447000','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-251020-0026','D','2025-10-20','11:20:59','kasir','PENJUALAN','F225201120583','1595656000','447000','1596103000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='447000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201120583' 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 ('F225201135201','kasir','1',' MEB1E CM ','TOKO','SMBK-B','B1E-YJAF-77-T','GW MODEL DAUN SLEP CM 8K ','OL','0.660','1','100.00','700000','0','0','15000','716000','0','5000','0','721000','RTA','T0074203','B1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJAF-77-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='B1E-YJAF-77-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 ('F225201135201','2025-10-20','0.660','2025-10-20','11:35:21','PLG0073819','716000','716000','5000','721000','721000','kasir','2025-10-20 11:35:20','F22520113520');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201135201','2025-10-20','11:35:21','RTA','721000','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-251020-0027','D','2025-10-20','11:35:21','kasir','PENJUALAN','F225201135201','1596103000','721000','1596824000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='721000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201135201' 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 ('F225201135202','kasir',' 1',' MEE2 CM 14','TOKO','SMBK-E','E2E-YJXD-49-T','CC MODEL MATA VAR CM 14 8K ','OL','0.650','1','100.00','689000','0','0','15000','705000','0','5000','0','710000','RTA','T0073863','E2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXD-49-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E2E-YJXD-49-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 ('F225201135202','2025-10-20','0.650','2025-10-20','11:35:21','PLG0073820','705000','705000','5000','710000','710000','kasir','2025-10-20 11:35:20','F22520113520');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201135202','2025-10-20','11:35:21','RTA','710000','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-251020-0028','D','2025-10-20','11:35:21','kasir','PENJUALAN','F225201135202','1596824000','710000','1597534000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='710000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201135202' 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 ('F225201135203','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAF-66-T','CC MODEL PITA SLEP CM 15 8K ','OL','0.700','1','100.00','742000','0','0','15000','760000','0','5000','0','765000','RTA','T0074192','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAF-66-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E1E-YJAF-66-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 ('F225201135203','2025-10-20','0.700','2025-10-20','11:35:21','PLG0073821','760000','760000','5000','765000','765000','kasir','2025-10-20 11:35:20','F22520113520');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201135203','2025-10-20','11:35:21','RTA','765000','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-251020-0029','D','2025-10-20','11:35:21','kasir','PENJUALAN','F225201135203','1597534000','765000','1598299000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='765000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201135203' 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 ('F225201149081','kasir','1',' MIH2 X KH ','TOKO','SMBK-H','H2I-YHAC-126-0','KL XX SANTA KH 44 9K ','OL','3.000','1','100.00','3420000','0','0','15000','3480000','0','15000','0','3495000','RHM','00365497','H2I','0','0','-','0','1140000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YHAC-126-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='H2I-YHAC-126-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225201149081','2025-10-20','3.000','2025-10-20','11:49:08','PLG0073822','3480000','3480000','15000','3495000','3495000','kasir','2025-10-20 11:49:08','F22520114908');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201149081','2025-10-20','11:49:08','RHM','3495000','15000');
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-251020-0030','D','2025-10-20','11:49:08','kasir','PENJUALAN','F225201149081','1598299000','3495000','1601794000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3495000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201149081' 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 ('F225201149082','kasir',' 1',' MFD2F X LG','TOKO','SMBK-D','D2F-YEBD-146-0','LT X MODEL BOLA MATA LG 8K ','OL','0.970','1','100.00','1052000','0','0','15000','1067000','0','10000','0','1077000','RHM','00355233','D2F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2F-YEBD-146-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='D2F-YEBD-146-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 ('F225201149082','2025-10-20','0.970','2025-10-20','11:49:08','PLG0073823','1067000','1067000','10000','1077000','1077000','kasir','2025-10-20 11:49:08','F22520114908');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201149082','2025-10-20','11:49:08','RHM','1077000','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-251020-0031','D','2025-10-20','11:49:08','kasir','PENJUALAN','F225201149082','1601794000','1077000','1602871000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1077000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201149082' 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 ('F225201152111','kasir','1',' TFA1 X ','TOKO','TBK-A','A1TF-XLBG-19-T','AT X MODEL ITALY PANJANG VAR 17K ','OL','1.450','1','100.00','2777000','0','0','15000','2818000','0','10000','0','2828000','RHM','T0065371','A1TF','0','0','-','0','1915000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TF-XLBG-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.450',berat_jual_asli=berat_jual_asli+'1.450',stock_jual='1',berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='A1TF-XLBG-19-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225201152111','2025-10-20','1.450','2025-10-20','11:52:11','PLG0073824','2818000','2818000','10000','2828000','2828000','kasir','2025-10-20 11:52:11','F22520115211');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201152111','2025-10-20','11:52:11','RHM','2828000','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-251020-0032','D','2025-10-20','11:52:11','kasir','PENJUALAN','F225201152111','1602871000','2828000','1605699000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2828000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201152111' 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 ('F225201152112','kasir',' 1',' TAA0 DG ','TOKO','TBK-A','A0TA-YEBD-67-T','AT MRICAN POLOS DG 17K ','OL','0.500','1','100.00','900000','0','0','15000','918000','0','7000','0','925000','RHM','T0069570','A0TA','0','0','-','0','1800000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A0TA-YEBD-67-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='A0TA-YEBD-67-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225201152112','2025-10-20','0.500','2025-10-20','11:52:11','PLG0073825','918000','918000','7000','925000','925000','kasir','2025-10-20 11:52:11','F22520115211');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201152112','2025-10-20','11:52:11','RHM','925000','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-251020-0033','D','2025-10-20','11:52:11','kasir','PENJUALAN','F225201152112','1605699000','925000','1606624000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='925000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201152112' 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 ('F225201158461','kasir','1',' MFH1 X UB ','TOKO','SMBK-H','H1F-YEAI-132-0','KL X CARENDELANO HURUF UB E 8K ','OL','2.070','1','100.00','2236000','0','0','15000','2277000','0','10000','0','2287000','RHM','00354616','H1F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YEAI-132-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='H1F-YEAI-132-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225201158461','2025-10-20','2.070','2025-10-20','11:58:46','PLG0073826','2277000','2277000','10000','2287000','2287000','kasir','2025-10-20 11:58:46','F22520115846');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201158461','2025-10-20','11:58:46','RHM','2287000','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-251020-0034','D','2025-10-20','11:58:46','kasir','PENJUALAN','F225201158461','1606624000','2287000','1608911000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2287000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201158461' 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 ('F225201158462','kasir',' 1',' MEH1 KH 44','TOKO','SMBK-H','H1E-YJAD-8-T','KL HOLLOW KH 44CM 8K ','OL','2.060','1','100.00','2184000','0','0','15000','2225000','0','10000','0','2235000','RHM','T0074034','H1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJAD-8-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='2025-10-20' AND kode_barang='H1E-YJAD-8-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225201158462','2025-10-20','2.060','2025-10-20','11:58:46','PLG0073827','2225000','2225000','10000','2235000','2235000','kasir','2025-10-20 11:58:46','F22520115846');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201158462','2025-10-20','11:58:46','RHM','2235000','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-251020-0035','D','2025-10-20','11:58:46','kasir','PENJUALAN','F225201158462','1608911000','2235000','1611146000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2235000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201158462' 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 ('F225201158463','kasir',' 1',' MED1E YT ','TOKO','SMBK-D','D1E-YJAE-3-T','LT MODEL SPECTRA HITAM YT 8K ','OL','0.530','1','100.00','562000','0','0','15000','575000','0','5000','0','580000','RHM','T0074052','D1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJAE-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='D1E-YJAE-3-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 ('F225201158463','2025-10-20','0.530','2025-10-20','11:58:46','PLG0073828','575000','575000','5000','580000','580000','kasir','2025-10-20 11:58:46','F22520115846');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201158463','2025-10-20','11:58:46','RHM','580000','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-251020-0036','D','2025-10-20','11:58:46','kasir','PENJUALAN','F225201158463','1611146000','580000','1611726000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='580000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201158463' 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 ('F225201158464','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAF-73-T','CC MODEL PITA SLEP CM 17 8K ','OL','0.840','1','100.00','890000','0','0','15000','911000','0','5000','0','916000','RHM','T0074199','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAF-73-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.840',berat_jual_asli=berat_jual_asli+'0.840',stock_jual='1',berat_akhir=berat_akhir-'0.840',berat_akhir_asli=berat_akhir_asli-'0.840',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E1E-YJAF-73-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 ('F225201158464','2025-10-20','0.840','2025-10-20','11:58:46','PLG0073829','911000','911000','5000','916000','916000','kasir','2025-10-20 11:58:46','F22520115846');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201158464','2025-10-20','11:58:46','RHM','916000','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-251020-0037','D','2025-10-20','11:58:46','kasir','PENJUALAN','F225201158464','1611726000','916000','1612642000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='916000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201158464' 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 ('F225201158465','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAE-36-T','CC MODEL PITA SLEP CM 15 8K ','OL','0.810','1','100.00','859000','0','0','15000','879000','0','5000','0','884000','RHM','T0074085','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAE-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E1E-YJAE-36-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 ('F225201158465','2025-10-20','0.810','2025-10-20','11:58:46','PLG0073830','879000','879000','5000','884000','884000','kasir','2025-10-20 11:58:46','F22520115846');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201158465','2025-10-20','11:58:46','RHM','884000','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-251020-0038','D','2025-10-20','11:58:46','kasir','PENJUALAN','F225201158465','1612642000','884000','1613526000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='884000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201158465' 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 ('F225201158466','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAE-40-T','CC MODEL PITA SLEP CM 13 8K ','OL','0.780','1','100.00','827000','0','0','15000','846000','0','5000','0','851000','RHM','T0074089','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAE-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.780',berat_jual_asli=berat_jual_asli+'0.780',stock_jual='1',berat_akhir=berat_akhir-'0.780',berat_akhir_asli=berat_akhir_asli-'0.780',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E1E-YJAE-40-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 ('F225201158466','2025-10-20','0.780','2025-10-20','11:58:46','PLG0073831','846000','846000','5000','851000','851000','kasir','2025-10-20 11:58:46','F22520115846');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201158466','2025-10-20','11:58:46','RHM','851000','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-251020-0039','D','2025-10-20','11:58:46','kasir','PENJUALAN','F225201158466','1613526000','851000','1614377000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='851000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201158466' 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 ('F225201158467','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAE-50-T','CC MODEL PITA SLEP CM 17 8K ','OL','0.750','1','100.00','795000','0','0','15000','814000','0','5000','0','819000','RHM','T0074099','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAE-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E1E-YJAE-50-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 ('F225201158467','2025-10-20','0.750','2025-10-20','11:58:46','PLG0073832','814000','814000','5000','819000','819000','kasir','2025-10-20 11:58:46','F22520115846');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201158467','2025-10-20','11:58:46','RHM','819000','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-251020-0040','D','2025-10-20','11:58:46','kasir','PENJUALAN','F225201158467','1614377000','819000','1615196000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='819000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201158467' 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 ('F225201158468','kasir',' 1',' MDE1 X BM ','TOKO','SMBK-E','E1D-YJAC-309-0','CC X MODEL SLEP CAT BM 14 8K ','OL','1.000','1','100.00','1040000','0','0','15000','1080000','0','5000','0','1085000','RHM','00373039','E1D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YJAC-309-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E1D-YJAC-309-0' 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 ('F225201158468','2025-10-20','1.000','2025-10-20','11:58:46','PLG0073833','1080000','1080000','5000','1085000','1085000','kasir','2025-10-20 11:58:46','F22520115846');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201158468','2025-10-20','11:58:46','RHM','1085000','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-251020-0041','D','2025-10-20','11:58:46','kasir','PENJUALAN','F225201158468','1615196000','1085000','1616281000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1085000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201158468' 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 ('F225201158469','kasir',' 1',' MEE2 CM 12','TOKO','SMBK-E','E2E-YJXA-18-T','CC MODEL MATA VAR CM 12 8K ','OL','0.630','1','100.00','668000','0','0','15000','684000','0','5000','0','689000','RHM','T0073510','E2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXA-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E2E-YJXA-18-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 ('F225201158469','2025-10-20','0.630','2025-10-20','11:58:46','PLG0073834','684000','684000','5000','689000','689000','kasir','2025-10-20 11:58:46','F22520115846');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201158469','2025-10-20','11:58:46','RHM','689000','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-251020-0042','D','2025-10-20','11:58:46','kasir','PENJUALAN','F225201158469','1616281000','689000','1616970000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='689000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201158469' 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 ('F225201201231','kasir','1',' MEB1E CM ','TOKO','SMBK-B','B1E-YJAF-76-T','GW MODEL DAUN SLEP CM 8K ','OL','0.670','1','100.00','710000','0','0','15000','727000','0','5000','0','732000','RHM','T0074202','B1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJAF-76-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='B1E-YJAF-76-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 ('F225201201231','2025-10-20','0.670','2025-10-20','12:01:24','PLG0073835','727000','727000','5000','732000','732000','kasir','2025-10-20 12:01:23','F22520120123');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201201231','2025-10-20','12:01:24','RHM','732000','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-251020-0043','D','2025-10-20','12:01:24','kasir','PENJUALAN','F225201201231','1616970000','732000','1617702000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='732000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201201231' 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 ('F225201201232','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAF-70-T','CC MODEL PITA SLEP CM 17 8K ','OL','0.830','1','100.00','880000','0','0','15000','901000','0','5000','0','906000','RHM','T0074196','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAF-70-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='2025-10-20' AND kode_barang='E1E-YJAF-70-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 ('F225201201232','2025-10-20','0.830','2025-10-20','12:01:24','PLG0073836','901000','901000','5000','906000','906000','kasir','2025-10-20 12:01:23','F22520120123');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201201232','2025-10-20','12:01:24','RHM','906000','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-251020-0044','D','2025-10-20','12:01:24','kasir','PENJUALAN','F225201201232','1617702000','906000','1618608000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='906000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201201232' 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 ('F225201217411','kasir','1',' MHB1 HK ','TOKO','SMBK-B','B1H-YHXF-73-T','GW TUSUK MRICAN SLEP HK 8K ','OL','0.260','1','100.00','291000','0','0','15000','298000','0','5000','0','303000','RHM','T0071965','B1H','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-YHXF-73-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='B1H-YHXF-73-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 ('F225201217411','2025-10-20','0.260','2025-10-20','12:17:42','PLG0073837','298000','298000','5000','303000','303000','kasir','2025-10-20 12:17:41','F22520121741');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201217411','2025-10-20','12:17:42','RHM','303000','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-251020-0045','D','2025-10-20','12:17:42','kasir','PENJUALAN','F225201217411','1618608000','303000','1618911000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='303000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201217411' 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 ('F225201217412','kasir',' 1',' MEB1E ','TOKO','SMBK-B','B1E-YJAF-75-T','GW MODEL DAUN SLEP CM 8K ','OL','0.660','1','100.00','700000','0','0','15000','716000','0','5000','0','721000','RHM','T0074201','B1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJAF-75-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='B1E-YJAF-75-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 ('F225201217412','2025-10-20','0.660','2025-10-20','12:17:42','PLG0073838','716000','716000','5000','721000','721000','kasir','2025-10-20 12:17:41','F22520121741');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201217412','2025-10-20','12:17:42','RHM','721000','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-251020-0046','D','2025-10-20','12:17:42','kasir','PENJUALAN','F225201217412','1618911000','721000','1619632000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='721000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201217412' 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 ('F225201217413','kasir',' 1',' MHD1 LG ','TOKO','SMBK-D','D1H-YIBD-21-T','LT MODEL DAUN VAR LG 8K ','OL','0.180','1','100.00','202000','0','0','15000','206000','0','5000','0','211000','RHM','T0073283','D1H','0','0','-','0','1120000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1H-YIBD-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.180',berat_jual_asli=berat_jual_asli+'0.180',stock_jual='1',berat_akhir=berat_akhir-'0.180',berat_akhir_asli=berat_akhir_asli-'0.180',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='D1H-YIBD-21-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 ('F225201217413','2025-10-20','0.180','2025-10-20','12:17:42','PLG0073839','206000','206000','5000','211000','211000','kasir','2025-10-20 12:17:41','F22520121741');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201217413','2025-10-20','12:17:42','RHM','211000','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-251020-0047','D','2025-10-20','12:17:42','kasir','PENJUALAN','F225201217413','1619632000','211000','1619843000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='211000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201217413' 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 ('F225201217414','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAE-47-T','CC MODEL PITA SLEP CM 17 8K ','OL','0.820','1','100.00','869000','0','0','15000','890000','0','5000','0','895000','RHM','T0074096','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAE-47-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='2025-10-20' AND kode_barang='E1E-YJAE-47-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 ('F225201217414','2025-10-20','0.820','2025-10-20','12:17:42','PLG0073840','890000','890000','5000','895000','895000','kasir','2025-10-20 12:17:41','F22520121741');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201217414','2025-10-20','12:17:42','RHM','895000','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-251020-0048','D','2025-10-20','12:17:42','kasir','PENJUALAN','F225201217414','1619843000','895000','1620738000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='895000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201217414' 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 ('F225201217415','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAE-35-T','CC MODEL PITA SLEP CM 15 8K ','','0.810','1','100.00','859000','0','0','15000','879000','0','5000','0','884000','RHM','T0074084','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAE-35-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E1E-YJAE-35-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 ('F225201217415','2025-10-20','0.810','2025-10-20','12:17:42','PLG0073841','879000','879000','5000','884000','884000','kasir','2025-10-20 12:17:41','F22520121741');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201217415','2025-10-20','12:17:42','RHM','884000','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-251020-0049','D','2025-10-20','12:17:42','kasir','PENJUALAN','F225201217415','1620738000','884000','1621622000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='884000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201217415' 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 ('F225201217416','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAE-43-T','CC MODEL PITA SLEP CM 13 8K ','OL','0.710','1','100.00','753000','0','0','15000','770000','0','5000','0','775000','RHM','T0074092','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAE-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.710',berat_jual_asli=berat_jual_asli+'0.710',stock_jual='1',berat_akhir=berat_akhir-'0.710',berat_akhir_asli=berat_akhir_asli-'0.710',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E1E-YJAE-43-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 ('F225201217416','2025-10-20','0.710','2025-10-20','12:17:42','PLG0073842','770000','770000','5000','775000','775000','kasir','2025-10-20 12:17:41','F22520121741');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201217416','2025-10-20','12:17:42','RHM','775000','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-251020-0050','D','2025-10-20','12:17:42','kasir','PENJUALAN','F225201217416','1621622000','775000','1622397000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='775000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201217416' 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 ('F225201217417','kasir',' 1',' MEE2 X CM ','TOKO','SMBK-E','E2E-YJAC-296-0','CC X MODEL MATA CM 18 8K ','OL','0.570','1','100.00','604000','0','0','15000','618000','0','5000','0','623000','RHM','00373026','E2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJAC-296-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E2E-YJAC-296-0' 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 ('F225201217417','2025-10-20','0.570','2025-10-20','12:17:42','PLG0073843','618000','618000','5000','623000','623000','kasir','2025-10-20 12:17:41','F22520121741');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201217417','2025-10-20','12:17:42','RHM','623000','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-251020-0051','D','2025-10-20','12:17:42','kasir','PENJUALAN','F225201217417','1622397000','623000','1623020000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='623000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201217417' 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 ('F225201217418','kasir',' 1',' MEE2 HTM 1','TOKO','SMBK-E','E2E-YJXF-23-T','CC PIPA MODEL HATI MATA HTM 13 8K ','OL','0.560','1','100.00','594000','0','0','15000','608000','0','5000','0','613000','RHM','T0073921','E2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXF-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E2E-YJXF-23-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 ('F225201217418','2025-10-20','0.560','2025-10-20','12:17:42','PLG0073844','608000','608000','5000','613000','613000','kasir','2025-10-20 12:17:41','F22520121741');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201217418','2025-10-20','12:17:42','RHM','613000','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-251020-0052','D','2025-10-20','12:17:42','kasir','PENJUALAN','F225201217418','1623020000','613000','1623633000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='613000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201217418' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200823471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200823471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200823471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200823472' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200823472' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200823472';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200900161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200900161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200900161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200915391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200915391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200915391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200915392' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200915392' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200915392';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200929521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200929521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200929521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200931501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200931501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200931501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200943081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200943081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200943081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201006051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201006051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201006051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201010041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201010041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201010041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201011491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201011491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201011491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201022531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201022531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201022531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201022532' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201022532' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201022532';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201030431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201030431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201030431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201030432' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201030432' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201030432';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201032061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201032061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201032061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201119111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201119111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201119111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201119112' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201119112' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201119112';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201119113' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201119113' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201119113';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201119114' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201119114' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201119114';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201119115' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201119115' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201119115';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201119116' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201119116' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201119116';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201119117' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201119117' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201119117';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201119118' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201119118' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201119118';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201119119' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201119119' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201119119';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201120581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201120581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201120581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201120582' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201120582' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201120582';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201120583' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201120583' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201120583';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201135201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201135201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201135201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201135202' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201135202' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201135202';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201135203' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201135203' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201135203';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201149081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201149081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201149081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201149082' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201149082' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201149082';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201152111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201152111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201152111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201152112' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201152112' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201152112';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201158461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201158461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201158461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201158462' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201158462' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201158462';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201158463' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201158463' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201158463';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201158464' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201158464' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201158464';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201158465' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201158465' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201158465';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201158466' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201158466' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201158466';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201158467' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201158467' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201158467';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201158468' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201158468' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201158468';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201158469' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201158469' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201158469';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201201231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201201231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201201231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201201232' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201201232' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201201232';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201217411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201217411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201217411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201217412' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201217412' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201217412';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201217413' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201217413' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201217413';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201217414' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201217414' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201217414';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201217415' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201217415' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201217415';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201217416' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201217416' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201217416';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201217417' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201217417' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201217417';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201217418' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201217418' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201217418';
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 ('F225201229201','kasir','1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAF-63-T','CC MODEL PITA SLEP CM 15 8K ','OL','0.830','1','100.00','880000','0','0','15000','896000','0','5000','0','901000','RHM','T0074189','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAF-63-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='2025-10-20' AND kode_barang='E1E-YJAF-63-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 ('F225201229201','2025-10-20','0.830','2025-10-20','12:29:20','PLG0073845','896000','896000','5000','901000','901000','kasir','2025-10-20 12:29:20','F22520122920');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201229201','2025-10-20','12:29:20','RHM','901000','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-251020-0053','D','2025-10-20','12:29:20','kasir','PENJUALAN','F225201229201','1623633000','901000','1624534000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='901000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201229201' 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 ('F225201229202','kasir',' 1',' MEE1E CM 1','TOKO','SMBK-E','E1E-YJAH-2-T','CC MODEL SLEP CM 14 8K ','OL','0.670','1','100.00','710000','0','0','15000','725000','0','5000','0','730000','RHM','T0074215','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAH-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E1E-YJAH-2-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 ('F225201229202','2025-10-20','0.670','2025-10-20','12:29:20','PLG0073846','725000','725000','5000','730000','730000','kasir','2025-10-20 12:29:20','F22520122920');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201229202','2025-10-20','12:29:20','RHM','730000','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-251020-0054','D','2025-10-20','12:29:20','kasir','PENJUALAN','F225201229202','1624534000','730000','1625264000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='730000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201229202' 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 ('F225201229203','kasir',' 1',' MFD1F HW ','TOKO','SMBK-D','D1F-YJAE-14-T','LT MODEL PLAT HW 8K ','OL','0.750','1','100.00','810000','0','0','15000','825000','0','5000','0','830000','RHM','T0074063','D1F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YJAE-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='D1F-YJAE-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225201229203','2025-10-20','0.750','2025-10-20','12:29:20','PLG0073847','825000','825000','5000','830000','830000','kasir','2025-10-20 12:29:20','F22520122920');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201229203','2025-10-20','12:29:20','RHM','830000','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-251020-0055','D','2025-10-20','12:29:20','kasir','PENJUALAN','F225201229203','1625264000','830000','1626094000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='830000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225201229203' 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 ('F225201243141','kasir','1',' TDA1 X ','TOKO','TBK-A','A1TD-YFBF-48-T','AT X MODEL HATI MATA VAR 17K ','OL','0.810','1','100.00','1519000','0','0','15000','1560000','0','7000','0','1567000','RTA','T0070415','A1TD','0','0','-','0','1875000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TD-YFBF-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='A1TD-YFBF-48-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F225201243141','2025-10-20','0.810','2025-10-20','12:43:14','PLG0073848','1560000','1560000','7000','1567000','1567000','kasir','2025-10-20 12:43:14','F22520124314');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225201243141','2025-10-20','12:43:14','RTA','1567000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251020-0056','D','2025-10-20','12:43:14','kasir','PENJUALAN','F225201243141','1626094000','1567000','1627661000');
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 ('F225200109011','kasir','1',' MED1 X CM ','TOKO','SMBK-D','D1E-YHBI-176-0','LT X MODEL MATA SLEP CM 8K ','OL','0.510','1','100.00','541000','0','0','15000','553000','0','5000','0','558000','TIN','00367417','D1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YHBI-176-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='D1E-YHBI-176-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 ('F225200109011','2025-10-20','0.510','2025-10-20','13:09:02','PLG0073849','553000','553000','5000','558000','558000','kasir','2025-10-20 13:09:01','F22520010901');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200109011','2025-10-20','13:09:02','TIN','558000','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-251020-0057','D','2025-10-20','13:09:02','kasir','PENJUALAN','F225200109011','1627661000','558000','1628219000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='558000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225200109011' 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 ('F225200109012','kasir',' 1',' MDD1 7K BW','TOKO','SMBK-D','D1D-YJAH-82-T','LT MODEL SPECTRA HITAM BW 8K ','OL','1.140','1','100.00','1186000','0','0','15000','1230000','0','7000','0','1237000','TIN','T0074295','D1D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1D-YJAH-82-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.140',berat_jual_asli=berat_jual_asli+'1.140',stock_jual='1',berat_akhir=berat_akhir-'1.140',berat_akhir_asli=berat_akhir_asli-'1.140',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='D1D-YJAH-82-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 ('F225200109012','2025-10-20','1.140','2025-10-20','13:09:02','PLG0073850','1230000','1230000','7000','1237000','1237000','kasir','2025-10-20 13:09:01','F22520010901');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200109012','2025-10-20','13:09:02','TIN','1237000','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-251020-0058','D','2025-10-20','13:09:02','kasir','PENJUALAN','F225200109012','1628219000','1237000','1629456000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1237000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225200109012' 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 ('F225200109013','kasir',' 1',' MEE2 X LG ','TOKO','SMBK-E','E2E-YJAC-295-0','CC X MODEL MATA LG 10 8K ','OL','0.500','1','100.00','530000','0','0','15000','543000','0','5000','0','548000','TIN','00373025','E2E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJAC-295-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E2E-YJAC-295-0' 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 ('F225200109013','2025-10-20','0.500','2025-10-20','13:09:02','PLG0073851','543000','543000','5000','548000','548000','kasir','2025-10-20 13:09:01','F22520010901');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200109013','2025-10-20','13:09:02','TIN','548000','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-251020-0059','D','2025-10-20','13:09:02','kasir','PENJUALAN','F225200109013','1629456000','548000','1630004000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='548000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225200109013' 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 ('F225200109014','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAF-68-T','CC MODEL PITA SLEP CM 17 8K ','OL','0.690','1','100.00','731000','0','0','15000','749000','0','5000','0','754000','TIN','T0074194','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAF-68-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.690',berat_jual_asli=berat_jual_asli+'0.690',stock_jual='1',berat_akhir=berat_akhir-'0.690',berat_akhir_asli=berat_akhir_asli-'0.690',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E1E-YJAF-68-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 ('F225200109014','2025-10-20','0.690','2025-10-20','13:09:02','PLG0073852','749000','749000','5000','754000','754000','kasir','2025-10-20 13:09:01','F22520010901');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200109014','2025-10-20','13:09:02','TIN','754000','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-251020-0060','D','2025-10-20','13:09:02','kasir','PENJUALAN','F225200109014','1630004000','754000','1630758000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='754000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225200109014' 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 ('F225200109015','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAE-38-T','CC MODEL PITA SLEP CM 15 8K ','OL','0.810','1','100.00','859000','0','0','15000','879000','0','5000','0','884000','TIN','T0074087','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAE-38-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E1E-YJAE-38-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 ('F225200109015','2025-10-20','0.810','2025-10-20','13:09:02','PLG0073853','879000','879000','5000','884000','884000','kasir','2025-10-20 13:09:01','F22520010901');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200109015','2025-10-20','13:09:02','TIN','884000','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-251020-0061','D','2025-10-20','13:09:02','kasir','PENJUALAN','F225200109015','1630758000','884000','1631642000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='884000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225200109015' 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 ('F225200109016','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAE-48-T','CC MODEL PITA SLEP CM 17 8K ','OL','0.810','1','100.00','859000','0','0','15000','879000','0','5000','0','884000','TIN','T0074097','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAE-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E1E-YJAE-48-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 ('F225200109016','2025-10-20','0.810','2025-10-20','13:09:02','PLG0073854','879000','879000','5000','884000','884000','kasir','2025-10-20 13:09:01','F22520010901');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200109016','2025-10-20','13:09:02','TIN','884000','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-251020-0062','D','2025-10-20','13:09:02','kasir','PENJUALAN','F225200109016','1631642000','884000','1632526000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='884000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225200109016' 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 ('F225200109017','kasir',' 1',' MEH1 10K H','TOKO','SMBK-H','H1E-YJXC-61-T','KL SANTA MODEL HATI PASIR HW 8K ','OL','1.980','1','100.00','2099000','0','0','15000','2138000','0','10000','0','2148000','TIN','T0073782','H1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJXC-61-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='H1E-YJXC-61-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225200109017','2025-10-20','1.980','2025-10-20','13:09:02','PLG0073855','2138000','2138000','10000','2148000','2148000','kasir','2025-10-20 13:09:01','F22520010901');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200109017','2025-10-20','13:09:02','TIN','2148000','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-251020-0063','D','2025-10-20','13:09:02','kasir','PENJUALAN','F225200109017','1632526000','2148000','1634674000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2148000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225200109017' 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 ('F225200109018','kasir',' 1',' MFH1 UB 40','TOKO','SMBK-H','H1F-YIXH-68-T','KL MILANO UB 40CM 8K ','OL','2.110','1','100.00','2279000','0','0','15000','2321000','0','11000','0','2332000','TIN','T0073077','H1F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YIXH-68-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.110',berat_jual_asli=berat_jual_asli+'2.110',stock_jual='1',berat_akhir=berat_akhir-'2.110',berat_akhir_asli=berat_akhir_asli-'2.110',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='H1F-YIXH-68-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225200109018','2025-10-20','2.110','2025-10-20','13:09:02','PLG0073856','2321000','2321000','11000','2332000','2332000','kasir','2025-10-20 13:09:01','F22520010901');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200109018','2025-10-20','13:09:02','TIN','2332000','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-251020-0064','D','2025-10-20','13:09:02','kasir','PENJUALAN','F225200109018','1634674000','2332000','1637006000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2332000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225200109018' 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 ('F225200110401','kasir','1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAE-45-T','CC MODEL PITA SLEP CM 13 8K ','OL','0.750','1','100.00','795000','0','0','15000','814000','0','5000','0','819000','TIN','T0074094','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAE-45-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E1E-YJAE-45-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 ('F225200110401','2025-10-20','0.750','2025-10-20','13:10:41','PLG0073857','814000','814000','5000','819000','819000','kasir','2025-10-20 13:10:40','F22520011040');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200110401','2025-10-20','13:10:41','TIN','819000','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-251020-0065','D','2025-10-20','13:10:41','kasir','PENJUALAN','F225200110401','1637006000','819000','1637825000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='819000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225200110401' 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 ('F225200110402','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAF-71-T','CC MODEL PITA SLEP CM 17 8K ','OL','0.750','1','100.00','795000','0','0','15000','814000','0','5000','0','819000','TIN','T0074197','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAF-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E1E-YJAF-71-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 ('F225200110402','2025-10-20','0.750','2025-10-20','13:10:41','PLG0073858','814000','814000','5000','819000','819000','kasir','2025-10-20 13:10:40','F22520011040');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200110402','2025-10-20','13:10:41','TIN','819000','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-251020-0066','D','2025-10-20','13:10:41','kasir','PENJUALAN','F225200110402','1637825000','819000','1638644000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='819000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225200110402' 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 ('F225200110403','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAF-51-T','CC MODEL PITA SLEP CM 13 8K ','OL','0.780','1','100.00','827000','0','0','15000','846000','0','5000','0','851000','TIN','T0074177','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAF-51-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.780',berat_jual_asli=berat_jual_asli+'0.780',stock_jual='1',berat_akhir=berat_akhir-'0.780',berat_akhir_asli=berat_akhir_asli-'0.780',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E1E-YJAF-51-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 ('F225200110403','2025-10-20','0.780','2025-10-20','13:10:41','PLG0073859','846000','846000','5000','851000','851000','kasir','2025-10-20 13:10:40','F22520011040');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200110403','2025-10-20','13:10:41','TIN','851000','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-251020-0067','D','2025-10-20','13:10:41','kasir','PENJUALAN','F225200110403','1638644000','851000','1639495000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='851000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225200110403' 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 ('F225200110404','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAE-69-T','CC MODEL PITA SLEP CM 17 8K ','OL','0.780','1','100.00','827000','0','0','15000','846000','0','5000','0','851000','TIN','T0074118','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAE-69-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.780',berat_jual_asli=berat_jual_asli+'0.780',stock_jual='1',berat_akhir=berat_akhir-'0.780',berat_akhir_asli=berat_akhir_asli-'0.780',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E1E-YJAE-69-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 ('F225200110404','2025-10-20','0.780','2025-10-20','13:10:41','PLG0073860','846000','846000','5000','851000','851000','kasir','2025-10-20 13:10:40','F22520011040');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200110404','2025-10-20','13:10:41','TIN','851000','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-251020-0068','D','2025-10-20','13:10:41','kasir','PENJUALAN','F225200110404','1639495000','851000','1640346000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='851000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225200110404' 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 ('F225200110405','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAF-61-T','CC MODEL PITA SLEP CM 15 8K ','OL','0.800','1','100.00','848000','0','0','15000','868000','0','5000','0','873000','TIN','T0074187','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAF-61-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E1E-YJAF-61-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 ('F225200110405','2025-10-20','0.800','2025-10-20','13:10:41','PLG0073861','868000','868000','5000','873000','873000','kasir','2025-10-20 13:10:40','F22520011040');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200110405','2025-10-20','13:10:41','TIN','873000','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-251020-0069','D','2025-10-20','13:10:41','kasir','PENJUALAN','F225200110405','1640346000','873000','1641219000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='873000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225200110405' 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 ('F225200110406','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAE-37-T','CC MODEL PITA SLEP CM 15 8K ','OL','0.820','1','100.00','869000','0','0','15000','890000','0','5000','0','895000','TIN','T0074086','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAE-37-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='2025-10-20' AND kode_barang='E1E-YJAE-37-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 ('F225200110406','2025-10-20','0.820','2025-10-20','13:10:41','PLG0073862','890000','890000','5000','895000','895000','kasir','2025-10-20 13:10:40','F22520011040');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200110406','2025-10-20','13:10:41','TIN','895000','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-251020-0070','D','2025-10-20','13:10:41','kasir','PENJUALAN','F225200110406','1641219000','895000','1642114000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='895000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225200110406' 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 ('F225200111121','kasir','1',' MJF4 KH ','TOKO','SMBK-F','F4J-YHBE-32-T','GL RANTAI HOLLOW KH 9K ','OL','4.110','1','100.00','4768000','0','0','15000','4849000','0','21000','0','4870000','TIN','T0072517','F4J','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F4J-YHBE-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.110',berat_jual_asli=berat_jual_asli+'4.110',stock_jual='1',berat_akhir=berat_akhir-'4.110',berat_akhir_asli=berat_akhir_asli-'4.110',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='F4J-YHBE-32-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 ('F225200111121','2025-10-20','4.110','2025-10-20','13:11:12','PLG0073863','4849000','4849000','21000','4870000','4870000','kasir','2025-10-20 13:11:12','F22520011112');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200111121','2025-10-20','13:11:12','TIN','4870000','21000');
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-251020-0071','D','2025-10-20','13:11:12','kasir','PENJUALAN','F225200111121','1642114000','4870000','1646984000');
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 ('F225200141551','kasir','1',' MEF3E X UB','TOKO','SMBK-F','F3E-YJAC-175-0','GL X TIFF SPECTRA HITAM UB 8K ','OL','2.070','1','100.00','2194000','0','0','15000','2242000','0','15000','0','2257000','TJ','00372905','F3E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJAC-175-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='F3E-YJAC-175-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 ('F225200141551','2025-10-20','2.070','2025-10-20','13:41:55','PLG0073864','2242000','2242000','15000','2257000','2257000','kasir','2025-10-20 13:41:55','F22520014155');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200141551','2025-10-20','13:41:55','TJ','2257000','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-251020-0072','D','2025-10-20','13:41:55','kasir','PENJUALAN','F225200141551','1646984000','2257000','1649241000');
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 ('F225200216401','kasir','1',' MEA1 BW ','TOKO','SMBK-A','A1E-YJXC-74-T','AT MODEL ITALY PANJANG VAR BW 8K ','','0.530','1','100.00','562000','0','0','15000','570000','0','0','0','570000','TIN','T0073795','A1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJXC-74-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='A1E-YJXC-74-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225200216401','2025-10-20','0.530','2025-10-20','14:16:40','PLG0073865','570000','570000','0','570000','570000','kasir','2025-10-20 14:16:40','F22520021640');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200216401','2025-10-20','14:16:40','TIN','570000','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-251020-0073','D','2025-10-20','14:16:40','kasir','PENJUALAN','F225200216401','1649241000','570000','1649811000');
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 ('F225200223121','kasir','1',' MED1E LG ','TOKO','SMBK-D','D1E-YJAH-85-T','LT SOLITAIRE MATA LG 8K ','OL','0.550','1','100.00','583000','0','0','15000','595000','0','10000','0','605000','RTA','T0074298','D1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJAH-85-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='D1E-YJAH-85-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 ('F225200223121','2025-10-20','0.550','2025-10-20','14:23:12','PLG0073866','595000','595000','10000','605000','605000','kasir','2025-10-20 14:23:12','F22520022312');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200223121','2025-10-20','14:23:12','RTA','605000','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-251020-0074','D','2025-10-20','14:23:12','kasir','PENJUALAN','F225200223121','1649811000','605000','1650416000');
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 ('F225200233061','kasir','1',' MEE1 5K CM','TOKO','SMBK-E','E1E-YJAF-53-T','CC MODEL PITA SLEP CM 13 8K','','0.700','1','100.00','742000','0','0','15000','753000','0','5000','0','758000','TJ','T0074179','E1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJAF-53-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='E1E-YJAF-53-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 ('F225200233061','2025-10-20','0.700','2025-10-20','14:33:07','PLG0073867','753000','753000','5000','758000','0','kasir','2025-10-20 14:33:06','F22520023306');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200233061','2025-10-20','14:33:07','TJ','758000','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-251020-0004','2025-10-20','2025-10-20 14:33:06','PENJUALAN : F225200233061','65238674868799','BCA','758000','758000','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-251020-0005','D','2025-10-20','14:33:07','BCA','PENJUALAN','F225200233061','4074160888','758000','4074918888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('65238674868799','YAYUK');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='758000' WHERE no_faktur_jual='F225200233061' 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 ('F225200233062','kasir',' 1',' MFF3 HW ','TOKO','SMBK-F','F3F-YHAE-70-T','GL JEDAR SERUT BUNGA ARESO VAR HW 8K ','','1.470','1','100.00','1588000','0','0','15000','1610000','0','0','0','1610000','TJ','T0072370','F3F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YHAE-70-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.470',berat_jual_asli=berat_jual_asli+'1.470',stock_jual='1',berat_akhir=berat_akhir-'1.470',berat_akhir_asli=berat_akhir_asli-'1.470',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='F3F-YHAE-70-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 ('F225200233062','2025-10-20','1.470','2025-10-20','14:33:07','PLG0073868','1610000','1610000','0','1610000','0','kasir','2025-10-20 14:33:06','F22520023306');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200233062','2025-10-20','14:33:07','TJ','1610000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251020-0005','2025-10-20','2025-10-20 14:33:06','PENJUALAN : F225200233062','65238674868799','BCA','1610000','1610000','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-251020-0006','D','2025-10-20','14:33:07','BCA','PENJUALAN','F225200233062','4074918888','1610000','4076528888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('65238674868799','YAYUK');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200233062' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200233062' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200233062';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200233061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200233061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200233061';
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 ('F225200303541','kasir','1',' MFD1 HW ','TOKO','SMBK-D','D1F-YJXB-73-T','LT LETTERA PANJANG HW 8K ','OL','0.750','1','100.00','810000','0','0','15000','833000','0','5000','0','838000','TIN','T0073653','D1F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YJXB-73-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='D1F-YJXB-73-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 ('F225200303541','2025-10-20','0.750','2025-10-20','15:03:55','PLG0073869','833000','833000','5000','838000','838000','kasir','2025-10-20 15:03:54','F22520030354');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200303541','2025-10-20','15:03:55','TIN','838000','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-251020-0075','D','2025-10-20','15:03:55','kasir','PENJUALAN','F225200303541','1650416000','838000','1651254000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='838000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225200303541' 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 ('F225200303542','kasir',' 1',' MFD1F HW ','TOKO','SMBK-D','D1F-YJAE-16-T','LT MODEL COIN HW 8K ','OL','0.620','1','100.00','670000','0','0','15000','688000','0','5000','0','693000','TIN','T0074065','D1F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YJAE-16-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.620',berat_jual_asli=berat_jual_asli+'0.620',stock_jual='1',berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='D1F-YJAE-16-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 ('F225200303542','2025-10-20','0.620','2025-10-20','15:03:55','PLG0073870','688000','688000','5000','693000','693000','kasir','2025-10-20 15:03:54','F22520030354');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200303542','2025-10-20','15:03:55','TIN','693000','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-251020-0076','D','2025-10-20','15:03:55','kasir','PENJUALAN','F225200303542','1651254000','693000','1651947000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='693000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225200303542' 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 ('F225200316071','kasir','1',' MDA1D CM ','TOKO','SMBK-A','A1D-YJAH-55-T','AT CLIP DAUN MATA CM 8K ','OL','1.260','1','100.00','1310000','0','0','15000','1367000','0','6000','0','1373000','RTA','T0074268','A1D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YJAH-55-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.260',berat_jual_asli=berat_jual_asli+'1.260',stock_jual='1',berat_akhir=berat_akhir-'1.260',berat_akhir_asli=berat_akhir_asli-'1.260',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='A1D-YJAH-55-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225200316071','2025-10-20','1.260','2025-10-20','15:16:07','PLG0073871','1367000','1367000','6000','1373000','1373000','kasir','2025-10-20 15:16:07','F22520031607');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200316071','2025-10-20','15:16:07','RTA','1373000','6000');
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-251020-0077','D','2025-10-20','15:16:07','kasir','PENJUALAN','F225200316071','1651947000','1373000','1653320000');
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 ('F225200329261','kasir','1',' MDD2 X YT ','TOKO','SMBK-D','D2D-YEBD-130-0','LT X MODEL MATA YT 8K ','OL','0.810','1','100.00','842000','0','0','15000','883000','0','5000','0','888000','RTA','00355217','D2D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2025-10-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-YEBD-130-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.810',berat_jual_asli=berat_jual_asli+'0.810',stock_jual='1',berat_akhir=berat_akhir-'0.810',berat_akhir_asli=berat_akhir_asli-'0.810',stock_akhir='0' WHERE tanggal='2025-10-20' AND kode_barang='D2D-YEBD-130-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 ('F225200329261','2025-10-20','0.810','2025-10-20','15:29:26','PLG0073872','883000','883000','5000','888000','888000','kasir','2025-10-20 15:29:26','F22520032926');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-20','F225200329261','2025-10-20','15:29:26','RTA','888000','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-251020-0078','D','2025-10-20','15:29:26','kasir','PENJUALAN','F225200329261','1653320000','888000','1654208000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200109011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200109011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200109011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200109012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200109012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200109012';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200109013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200109013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200109013';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200109014' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200109014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200109014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200109015' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200109015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200109015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200109016' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200109016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200109016';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200109017' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200109017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200109017';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200109018' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200109018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200109018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200110401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200110401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200110401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200110402' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200110402' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200110402';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200110403' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200110403' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200110403';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200110404' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200110404' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200110404';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200110405' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200110405' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200110405';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200110406' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200110406' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200110406';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200111121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200111121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200111121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200141551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200141551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200141551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200216401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200216401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200216401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200223121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200223121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200223121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200303541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200303541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200303541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200303542' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200303542' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200303542';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200316071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200316071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200316071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225200329261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225200329261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225200329261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201229201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201229201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201229201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201229202' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201229202' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201229202';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201229203' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201229203' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201229203';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225201243141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225201243141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225201243141';
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-00004756','X-00004756','CC MODEL BUNGA ARESO MATA VAR YT 12 8K','GR','---','E2E','BELI','BELI001','520000','2025-10-20','0.680','1','kasir','2025-10-20 15:39:52');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00004756','X-00004756');
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-251020-0001','F225271047291','RTA','1','BELI','BELI001','E2E', 'X-00004756', 'CC MODEL BUNGA ARESO MATA VAR YT 12 8K','0.730','0.680','100.00','559000','520000','764706','1060000','1','520000','520000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.680',berat_beli_asli=berat_beli_asli+'0.680',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.680',berat_akhir_asli=berat_akhir_asli+'0.680',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-20' 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-251020-0001','2025-10-20','2025-10-20','15:39:51','RTA','---','0.680','520000','520000','520000','520000','520000','kasir','2025-10-20 15:39:52','FB-251020-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251020-0001','ENI DWI ASTUTI','DS KUNTI SAMPUNG PO','','','085748644914','kasir','2025-10-20 15:39:52');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-20' 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-251020-0079','K','2025-10-20','15:39:51','kasir','PEMBELIAN UMUM','FB-251020-0001','1654208000','520000','1653688000');
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-00004757','X-00004757','AT GYPSY SLEP MODEL HATI ARESO VAR UB 8K','GR','---','A1F','BELI','BELI001','459000','2025-10-20','0.600','1','kasir','2025-10-20 15:39:52');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00004757','X-00004757');
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-251020-0002','F224211221091','RTA','2','BELI','BELI001','A1F', 'X-00004757', 'AT GYPSY SLEP MODEL HATI ARESO VAR UB 8K','0.650','0.600','100.00','403000','459000','765000','1005000','1','459000','459000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.600',berat_beli_asli=berat_beli_asli+'0.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.600',berat_akhir_asli=berat_akhir_asli+'0.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-20' 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-251020-0002','2025-10-20','2025-10-20','15:39:51','RTA','---','0.600','459000','459000','459000','459000','459000','kasir','2025-10-20 15:39:52','FB-251020-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251020-0002','ENI DWI ASTUTI','KUNTI SAMPUNG','','','085748644914','kasir','2025-10-20 15:39:52');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-20' 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-251020-0080','K','2025-10-20','15:39:51','kasir','PEMBELIAN UMUM','FB-251020-0002','1653688000','459000','1653229000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251020-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251020-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251020-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251020-0002';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-21','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-20';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-20';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-20';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-10-20' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-20';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-20';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-20';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-20';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-21' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-20' 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-251021-0001','D','2025-10-21','16:13:21','SYSTEM','SALDO AWAL','SALDO AWAL','0','1653229000','1653229000');
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-251021-0001','D','2025-10-21','16:13:21','BCA','SALDO AWAL','SALDO AWAL','0','4076528888','4076528888');
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-251021-0001','D','2025-10-21','16:13:21','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251021-0001','D','2025-10-21','16:13:21','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-251021-0001','D','2025-10-21','16:13:21','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-251021-0001','D','2025-10-21','16:13:21','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2025-10-21';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251021-0001','1','H1E-YJBX-60-0','1','3.030','3.030','TOKO','SSBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YJBX-60-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YJBX-60-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-10-21 16:58:26' WHERE kode_barang='H1E-YJBX-60-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YJBX-60-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-10-21 16:58:26','TOKO','SMBK-H','H1E','H1E-YJBX-60-0','1','3.030','3.030','1','3.030','3.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-YJBX-60-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YJBX-60-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251021-0001','2025-10-21','16:58','3.030','input','2025-10-20 16:58:26');