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 ('F326110808101','input','1',' MDE2 10K C','TOKO','PM-E','E2D-ZIXI-107-0','CC WEDDING MATA CM 14 8K ','','1.500','1','100.00','1534000','0','0','15000','1535000','0','10000','0','1545000','AAT','00422645','E2D','0','0','-','0','1023000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZIXI-107-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='E2D-ZIXI-107-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326110808101','2026-10-11','1.500','2026-10-11','08:08:11','PLG0031780','1535000','1535000','10000','1545000','1545000','input','2026-10-11 08:08:10','F32611080810');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326110808101','2026-10-11','08:08:11','AAT','1545000','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-261011-0002','D','2026-10-11','08:08:11','input','PENJUALAN','F326110808101','7782564000','1545000','7784109000');
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 ('F326110903411','input','1',' MEF3E HW ','TOKO','PM-F','F3E-ZJXE-351-0','GL CASTELI ARESO VAR HW 8K ','','2.430','1','100.00','2535000','0','0','15000','2535000','0','0','0','2535000','AAT','00427842','F3E','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJXE-351-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.430',berat_jual_asli=berat_jual_asli+'2.430',stock_jual='1',berat_akhir=berat_akhir-'2.430',berat_akhir_asli=berat_akhir_asli-'2.430',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='F3E-ZJXE-351-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326110903411','2026-10-11','2.430','2026-10-11','09:03:41','PLG0031781','2535000','2535000','0','2535000','2535000','input','2026-10-11 09:03:41','F32611090341');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326110903411','2026-10-11','09:03:41','AAT','2535000','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-261011-0003','D','2026-10-11','09:03:41','input','PENJUALAN','F326110903411','7784109000','2535000','7786644000');
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 ('F326110932521','input','1',' MEB1 X CM ','TOKO','PM-B','B1E-ZEBG-140-0','GW X MODEL BUNGA SLEP CM PE 8K ','','0.620','1','100.00','647000','0','0','15000','647000','0','0','0','647000','LIS','00405138','B1E','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEBG-140-0' 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='2026-10-11' AND kode_barang='B1E-ZEBG-140-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326110932521','2026-10-11','0.620','2026-10-11','09:32:53','PLG0031782','647000','647000','0','647000','647000','input','2026-10-11 09:32:52','F32611093252');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326110932521','2026-10-11','09:32:53','LIS','647000','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-261011-0004','D','2026-10-11','09:32:53','input','PENJUALAN','F326110932521','7786644000','647000','7787291000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='647000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110932521' 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 ('F326110932522','input',' 1',' MEF3 HW ','TOKO','PM-F','F3E-ZIBI-15-0','GL MODEL FANCY VAR HW 8K ','','1.230','1','100.00','1283000','0','0','15000','1283000','0','0','0','1283000','LIS','00426409','F3E','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIBI-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.230',berat_jual_asli=berat_jual_asli+'1.230',stock_jual='1',berat_akhir=berat_akhir-'1.230',berat_akhir_asli=berat_akhir_asli-'1.230',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='F3E-ZIBI-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326110932522','2026-10-11','1.230','2026-10-11','09:32:53','PLG0031783','1283000','1283000','0','1283000','1283000','input','2026-10-11 09:32:52','F32611093252');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326110932522','2026-10-11','09:32:53','LIS','1283000','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-261011-0005','D','2026-10-11','09:32:53','input','PENJUALAN','F326110932522','7787291000','1283000','7788574000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1283000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110932522' 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 ('F326110932523','input',' 1',' MEF1 XX UB','TOKO','PM-F','F1E-ZDAX-1-0','GL XX OVAL C SLEP UB 60 8K ','','4.790','1','100.00','4996000','0','0','15000','4853000','0','0','0','4853000','LIS','00398771','F1E','0','0','-','1','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZDAX-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.790',berat_jual_asli=berat_jual_asli+'4.790',stock_jual='1',berat_akhir=berat_akhir-'4.790',berat_akhir_asli=berat_akhir_asli-'4.790',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='F1E-ZDAX-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326110932523','2026-10-11','4.790','2026-10-11','09:32:53','PLG0031784','4853000','4853000','0','4853000','4853000','input','2026-10-11 09:32:52','F32611093252');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326110932523','2026-10-11','09:32:53','LIS','4853000','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-261011-0006','D','2026-10-11','09:32:53','input','PENJUALAN','F326110932523','7788574000','4853000','7793427000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4853000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110932523' 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 ('F326110934201','input','1',' MDE2 X YS ','TOKO','PM-E','E2D-YKAC-11-0','CC X POLOS YS 14 8K ','','2.080','1','100.00','2128000','0','0','15000','2128000','0','0','0','2128000','FIT','00377320','E2D','0','0','-','0','1023000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YKAC-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='E2D-YKAC-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326110934201','2026-10-11','2.080','2026-10-11','09:34:20','PLG0031785','2128000','2128000','0','2128000','2128000','input','2026-10-11 09:34:20','F32611093420');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326110934201','2026-10-11','09:34:20','FIT','2128000','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-261011-0007','D','2026-10-11','09:34:20','input','PENJUALAN','F326110934201','7793427000','2128000','7795555000');
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 ('F326110943141','input','1',' MEB1 X LG ','TOKO','PM-B','B1E-ZJXH-55-0','GW X MODEL RIBBON SLEP LG PE 8K ','','0.470','1','100.00','490000','0','0','15000','490000','0','0','0','490000','FIT','00428543','B1E','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZJXH-55-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='B1E-ZJXH-55-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326110943141','2026-10-11','0.470','2026-10-11','09:43:15','PLG0031786','490000','490000','0','490000','490000','input','2026-10-11 09:43:14','F32611094314');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326110943141','2026-10-11','09:43:15','FIT','490000','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-261011-0008','D','2026-10-11','09:43:15','input','PENJUALAN','F326110943141','7795555000','490000','7796045000');
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 ('F326110947101','input','1',' MEE2 CM 8 ','TOKO','PM-E','E2E-ZJXE-368-0','CC MODEL MATA CM 8 8K ','','0.650','1','100.00','678000','0','0','15000','678000','0','0','0','678000','SIN','00427859','E2E','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZJXE-368-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='E2E-ZJXE-368-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326110947101','2026-10-11','0.650','2026-10-11','09:47:10','PLG0031787','678000','678000','0','678000','678000','input','2026-10-11 09:47:10','F32611094710');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326110947101','2026-10-11','09:47:10','SIN','678000','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-261011-0009','D','2026-10-11','09:47:10','input','PENJUALAN','F326110947101','7796045000','678000','7796723000');
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 ('F326110956231','input','1',' MEF3E X LT','TOKO','PM-F','F3E-ZGXG-131-0','GL X RANTAI HOLLOW P4 LT 8K ','','3.060','1','100.00','3192000','0','0','15000','3192000','0','0','0','3192000','FIT','00412532','F3E','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGXG-131-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.060',berat_jual_asli=berat_jual_asli+'3.060',stock_jual='1',berat_akhir=berat_akhir-'3.060',berat_akhir_asli=berat_akhir_asli-'3.060',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='F3E-ZGXG-131-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326110956231','2026-10-11','3.060','2026-10-11','09:56:23','PLG0031788','3192000','3192000','0','3192000','3192000','input','2026-10-11 09:56:23','F32611095623');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326110956231','2026-10-11','09:56:23','FIT','3192000','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-261011-0010','D','2026-10-11','09:56:23','input','PENJUALAN','F326110956231','7796723000','3192000','7799915000');
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 ('F326111002171','input','1',' MEF1 X YT ','TOKO','PM-F','F1E-ZIBF-15-0','GL X OVAL C SLEP YT 54 8K ','','3.030','1','100.00','3160000','0','0','15000','3160000','0','0','0','3160000','LIS','00425633','F1E','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZIBF-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.030',berat_jual_asli=berat_jual_asli+'3.030',stock_jual='1',berat_akhir=berat_akhir-'3.030',berat_akhir_asli=berat_akhir_asli-'3.030',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='F1E-ZIBF-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326111002171','2026-10-11','3.030','2026-10-11','10:02:18','PLG0031789','3160000','3160000','0','3160000','3160000','input','2026-10-11 10:02:17','F32611100217');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326111002171','2026-10-11','10:02:18','LIS','3160000','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-261011-0011','D','2026-10-11','10:02:18','input','PENJUALAN','F326111002171','7799915000','3160000','7803075000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3160000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326111002171' 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 ('F326111002172','input',' 1',' MEH1 X KH ','TOKO','PM-H','H1E-ZFCX-237-0','KL X SANTA KH 46 8K ','','4.060','1','100.00','4235000','0','0','15000','4235000','0','0','0','4235000','LIS','00411444','H1E','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFCX-237-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.060',berat_jual_asli=berat_jual_asli+'4.060',stock_jual='1',berat_akhir=berat_akhir-'4.060',berat_akhir_asli=berat_akhir_asli-'4.060',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='H1E-ZFCX-237-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326111002172','2026-10-11','4.060','2026-10-11','10:02:18','PLG0031790','4235000','4235000','0','4235000','4235000','input','2026-10-11 10:02:17','F32611100217');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326111002172','2026-10-11','10:02:18','LIS','4235000','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-261011-0012','D','2026-10-11','10:02:18','input','PENJUALAN','F326111002172','7803075000','4235000','7807310000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4235000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326111002172' 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 ('F326111002173','input',' 1',' MFD1 5K BG','TOKO','PM-D','D1F-ZICX-211-0','LT MODEL BALLERINA PASIR BG 8K ','','0.600','1','100.00','638000','0','0','15000','638000','0','5000','0','643000','LIS','00426620','D1F','0','0','-','0','1063000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZICX-211-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='2026-10-11' AND kode_barang='D1F-ZICX-211-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326111002173','2026-10-11','0.600','2026-10-11','10:02:18','PLG0031791','638000','638000','5000','643000','643000','input','2026-10-11 10:02:17','F32611100217');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326111002173','2026-10-11','10:02:18','LIS','643000','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-261011-0013','D','2026-10-11','10:02:18','input','PENJUALAN','F326111002173','7807310000','643000','7807953000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='643000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326111002173' 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 ('F326111002174','input',' 1',' MDA1D X HW','TOKO','PM-A','A1D-ZIBH-5-0','AT X ITALY SLEP VAR HW 8K ','','0.950','1','100.00','972000','0','0','15000','972000','0','0','0','972000','LIS','00425984','A1D','0','0','-','0','1023000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZIBH-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='A1D-ZIBH-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326111002174','2026-10-11','0.950','2026-10-11','10:02:18','PLG0031792','972000','972000','0','972000','972000','input','2026-10-11 10:02:17','F32611100217');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326111002174','2026-10-11','10:02:18','LIS','972000','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-261011-0014','D','2026-10-11','10:02:18','input','PENJUALAN','F326111002174','7807953000','972000','7808925000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='972000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326111002174' 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 ('F326111020451','input','1',' MFE1 X LG ','TOKO','PM-E','E1E-ZIBF-143-0','CC X MODEL DAUN SLEP LG 10 8K','','0.400','1','100.00','417000','0','0','15000','417000','0','0','0','417000','SIN','00425761','E1E','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZIBF-143-0' 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='2026-10-11' AND kode_barang='E1E-ZIBF-143-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326111020451','2026-10-11','0.400','2026-10-11','10:20:46','PLG0031793','417000','417000','0','417000','417000','input','2026-10-11 10:20:45','F32611102045');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326111020451','2026-10-11','10:20:46','SIN','417000','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-261011-0015','D','2026-10-11','10:20:46','input','PENJUALAN','F326111020451','7808925000','417000','7809342000');
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 ('F326111050181','input','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZGXI-195-0','CC X MODEL MATA CM 16 8K ','','0.950','1','100.00','972000','0','0','15000','970000','0','0','0','970000','AAT','00412914','E2D','0','0','-','1','1023000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGXI-195-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='E2D-ZGXI-195-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326111050181','2026-10-11','0.950','2026-10-11','10:50:19','PLG0031794','970000','970000','0','970000','970000','input','2026-10-11 10:50:18','F32611105018');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326111050181','2026-10-11','10:50:19','AAT','970000','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-261011-0016','D','2026-10-11','10:50:19','input','PENJUALAN','F326111050181','7809342000','970000','7810312000');
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 ('F326111103161','input','1',' MEE2 KH 12','TOKO','PM-E','E2E-ZJXE-406-0','CC MODEL SNAKE MATA KH 12 8K ','','0.480','1','100.00','501000','0','0','15000','502000','0','0','0','502000','FIT','00427897','E2E','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZJXE-406-0' 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='2026-10-11' AND kode_barang='E2E-ZJXE-406-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326111103161','2026-10-11','0.480','2026-10-11','11:03:17','PLG0031795','502000','502000','0','502000','502000','input','2026-10-11 11:03:16','F32611110316');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326111103161','2026-10-11','11:03:17','FIT','502000','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-261011-0017','D','2026-10-11','11:03:17','input','PENJUALAN','F326111103161','7810312000','502000','7810814000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='502000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326111103161' 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 ('F326111103162','input',' 1',' MFE1 KH 12','TOKO','PM-E','E1F-ZJXE-394-0','CC MODEL SPECTRA SLEP KH 12 8K ','','0.350','1','100.00','372000','0','0','15000','373000','0','0','0','373000','FIT','00427885','E1F','0','0','-','0','1063000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZJXE-394-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='E1F-ZJXE-394-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326111103162','2026-10-11','0.350','2026-10-11','11:03:17','PLG0031796','373000','373000','0','373000','373000','input','2026-10-11 11:03:16','F32611110316');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326111103162','2026-10-11','11:03:17','FIT','373000','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-261011-0018','D','2026-10-11','11:03:17','input','PENJUALAN','F326111103162','7810814000','373000','7811187000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='373000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326111103162' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020489','X-00020489','CC X MODEL MATA UB 12 8K','GR','---','E2E','BELI','BELI001','587000','2026-10-11','0.600','1','kasir','2026-10-11 11:24:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020489','X-00020489');
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-261011-0001','F326121140521','SIN','1','BELI','BELI001','E2E', 'X-00020489', 'CC X MODEL MATA UB 12 8K','0.600','0.600','100.00','705000','587000','978333','1043000','1','587000','587000','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 ='2026-10-11' 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-261011-0001','2026-10-11','2026-10-11','11:24:01','SIN','---','0.600','587000','587000','587000','587000','587000','kasir','2026-10-11 11:24:02','FB-261011-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261011-0001','AMEL CANTIK','PURWANTORO','','','','kasir','2026-10-11 11:24:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-11' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261011-0019','K','2026-10-11','11:24:01','kasir','PEMBELIAN UMUM','FB-261011-0001','7811187000','587000','7810600000');
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-00020490','X-00020490','GL FANCY MODEL ARESO VAR HW 8K','GR','---','F3E','BELI','BELI001','1075000','2026-10-11','1.540','1','kasir','2026-10-11 11:24:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020490','X-00020490');
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-261011-0002','F325210256361','SIN','2','BELI','BELI001','F3E', 'X-00020490', 'GL FANCY MODEL ARESO VAR HW 8K','1.710','1.540','100.00','1310000','1075000','698052','1043000','1','1075000','1075000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.540',berat_beli_asli=berat_beli_asli+'1.540',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.540',berat_akhir_asli=berat_akhir_asli+'1.540',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' 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-261011-0002','2026-10-11','2026-10-11','11:24:01','SIN','---','1.540','1075000','1075000','1075000','1075000','1075000','kasir','2026-10-11 11:24:02','FB-261011-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261011-0002','NURHAYATI','JERUK PACITAN','','','','kasir','2026-10-11 11:24:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-11' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261011-0020','K','2026-10-11','11:24:01','kasir','PEMBELIAN UMUM','FB-261011-0002','7810600000','1075000','7809525000');
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-00020491','X-00020491','CC X MODEL METRO MATA LG 18 8K','GR','---','E2D','BELI','BELI001','1365000','2026-10-11','1.420','1','kasir','2026-10-11 11:24:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020491','X-00020491');
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-261011-0003','F325261009041','SIN','3','BELI','BELI001','E2D', 'X-00020491', 'CC X MODEL METRO MATA LG 18 8K','1.420','1.420','100.00','1535000','1365000','961268','1023000','1','1365000','1365000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.420',berat_beli_asli=berat_beli_asli+'1.420',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.420',berat_akhir_asli=berat_akhir_asli+'1.420',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261011-0003','2026-10-11','2026-10-11','11:24:01','SIN','---','1.420','1365000','1365000','1365000','1365000','1365000','kasir','2026-10-11 11:24:02','FB-261011-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261011-0003','MIYATUN','KISMANTORO','','','088216687523','kasir','2026-10-11 11:24:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-11' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261011-0021','K','2026-10-11','11:24:01','kasir','PEMBELIAN UMUM','FB-261011-0003','7809525000','1365000','7808160000');
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-00020492','X-00020492','CC MODEL HATI VAR LG 10 8K','GR','---','E1E','BELI','BELI001','430000','2026-10-11','0.550','1','kasir','2026-10-11 11:24:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020492','X-00020492');
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-261011-0004','F325231240263','SIN','4','BELI','BELI001','E1E', 'X-00020492', 'CC MODEL HATI VAR LG 10 8K','0.550','0.550','100.00','458000','430000','781818','1043000','1','430000','430000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.550',berat_beli_asli=berat_beli_asli+'0.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.550',berat_akhir_asli=berat_akhir_asli+'0.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261011-0004','2026-10-11','2026-10-11','11:24:01','SIN','---','0.550','430000','430000','430000','430000','430000','kasir','2026-10-11 11:24:02','FB-261011-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261011-0004','NURUL','BLIMBING PURWANTORO','','','','kasir','2026-10-11 11:24:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-11' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261011-0022','K','2026-10-11','11:24:01','kasir','PEMBELIAN UMUM','FB-261011-0004','7808160000','430000','7807730000');
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-00020493','X-00020493','CC MODEL SNAKE MATA SLEP KH 12 8K','GR','---','E2E','BELI','BELI001','465000','2026-10-11','0.480','1','kasir','2026-10-11 11:27:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020493','X-00020493');
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-261011-0005','F326220937391','AAT','1','BELI','BELI001','E2E', 'X-00020493', 'CC MODEL SNAKE MATA SLEP KH 12 8K','0.480','0.480','100.00','528000','465000','968750','1043000','1','465000','465000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.480',berat_beli_asli=berat_beli_asli+'0.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.480',berat_akhir_asli=berat_akhir_asli+'0.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-11' 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-261011-0005','2026-10-11','2026-10-11','11:27:01','AAT','---','0.480','465000','465000','465000','465000','465000','kasir','2026-10-11 11:27:02','FB-261011-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261011-0005','RARA','POHIJO SAMPUNG','','','','kasir','2026-10-11 11:27:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-11' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261011-0023','K','2026-10-11','11:27:01','kasir','PEMBELIAN UMUM','FB-261011-0005','7807730000','465000','7807265000');
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-00020494','X-00020494','CC X MODEL SLEP LG 16 8K','GR','---','E1D','BELI','BELI001','1190000','2026-10-11','1.260','1','kasir','2026-10-11 11:27:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00020494','X-00020494');
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-261011-0006','F326010758411','AAT','2','BELI','BELI001','E1D', 'X-00020494', 'CC X MODEL SLEP LG 16 8K','1.260','1.260','100.00','1280000','1190000','944444','1023000','1','1190000','1190000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.260',berat_beli_asli=berat_beli_asli+'1.260',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.260',berat_akhir_asli=berat_akhir_asli+'1.260',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' 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-261011-0006','2026-10-11','2026-10-11','11:27:01','AAT','---','1.260','1190000','1190000','1190000','1190000','1190000','kasir','2026-10-11 11:27:02','FB-261011-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261011-0006','MBOK TUKINEM','TRITIS TEGALREJO','','','','kasir','2026-10-11 11:27:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-11' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261011-0024','K','2026-10-11','11:27:01','kasir','PEMBELIAN UMUM','FB-261011-0006','7807265000','1190000','7806075000');
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-00020495','X-00020495','AT GYPSY POLOS LG 8K','GR','---','A1D','BELI','BELI001','960000','2026-10-11','1.010','1','kasir','2026-10-11 11:27:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00020495','X-00020495');
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-261011-0007','F326280828494','AAT','3','BELI','BELI001','A1D', 'X-00020495', 'AT GYPSY POLOS LG 8K','1.010','1.010','100.00','1081000','960000','950495','1023000','1','960000','960000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.010',berat_beli_asli=berat_beli_asli+'1.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.010',berat_akhir_asli=berat_akhir_asli+'1.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' 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-261011-0007','2026-10-11','2026-10-11','11:27:01','AAT','---','1.010','960000','960000','960000','960000','960000','kasir','2026-10-11 11:27:02','FB-261011-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261011-0007','REVITA','WATUBONANG BADEGAN','','','088228011674','kasir','2026-10-11 11:27:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-11' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261011-0025','K','2026-10-11','11:27:01','kasir','PEMBELIAN UMUM','FB-261011-0007','7806075000','960000','7805115000');
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-00020496','X-00020496','GL BANGKOK C ANAK SLEP HW 42 8K','GR','---','F1E','BELI','BELI001','1927000','2026-10-11','1.990','1','kasir','2026-10-11 11:36:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020496','X-00020496');
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-261011-0008','F326061126571','SIN','1','BELI','BELI001','F1E', 'X-00020496', 'GL BANGKOK C ANAK SLEP HW 42 8K','1.990','1.990','100.00','2200000','1927000','968342','1043000','1','1927000','1927000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.990',berat_beli_asli=berat_beli_asli+'1.990',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.990',berat_akhir_asli=berat_akhir_asli+'1.990',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261011-0008','2026-10-11','2026-10-11','11:36:35','SIN','---','1.990','1927000','1927000','1927000','1927000','1927000','kasir','2026-10-11 11:36:35','FB-261011-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261011-0008','BARA','SIDOHARJO','','','085280418530','kasir','2026-10-11 11:36:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-11' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261011-0026','K','2026-10-11','11:36:35','kasir','PEMBELIAN UMUM','FB-261011-0008','7805115000','1927000','7803188000');
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 ('F326111245261','kasir','1',' MEA1E 5K L','TOKO','PM-A','A1E-ZFBX-517-0','AT BONEKA ANAK CAT MATA VAR LG 8K ','','0.520','1','100.00','542000','0','0','15000','543000','0','5000','0','548000','SIN','00409534','A1E','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZFBX-517-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='A1E-ZFBX-517-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326111245261','2026-10-11','0.520','2026-10-11','12:45:27','PLG0031797','543000','543000','5000','548000','548000','kasir','2026-10-11 12:45:26','F32611124526');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326111245261','2026-10-11','12:45:27','SIN','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) VALUES ('KM-261011-0027','D','2026-10-11','12:45:27','kasir','PENJUALAN','F326111245261','7803188000','548000','7803736000');
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-00020497','X-00020497','KL X MILANO SEMI UB 54 9K','GR','---','H2J','BELI','BELI001','8310000','2026-10-11','7.770','1','kasir','2026-10-11 13:03:40');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00020497','X-00020497');
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-261011-0009','F326101133541','LIS','1','BELI','BELI001','H2J', 'X-00020497', 'KL X MILANO SEMI UB 54 9K','7.770','7.770','100.00','8935000','8310000','1069498','1143000','1','8310000','8310000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'7.770',berat_beli_asli=berat_beli_asli+'7.770',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'7.770',berat_akhir_asli=berat_akhir_asli+'7.770',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2J' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261011-0009','2026-10-11','2026-10-11','13:03:40','LIS','---','7.770','8310000','8310000','8310000','8310000','8310000','kasir','2026-10-11 13:03:40','FB-261011-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261011-0009','DWI SURYANI','NGROMO NAWANGAN','','','','kasir','2026-10-11 13:03:40');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-11' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261011-0028','K','2026-10-11','13:03:40','kasir','PEMBELIAN UMUM','FB-261011-0009','7803736000','8310000','7795426000');
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-00020498','X-00020498','CC X MODEL MATA CM 16 8K','GR','---','E2D','BELI','BELI001','925000','2026-10-11','0.980','1','kasir','2026-10-11 13:04:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020498','X-00020498');
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-261011-0010','F326281256451','LIS','1','BELI','BELI001','E2D', 'X-00020498', 'CC X MODEL MATA CM 16 8K','0.980','0.980','100.00','995000','925000','943878','1023000','1','925000','925000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.980',berat_beli_asli=berat_beli_asli+'0.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.980',berat_akhir_asli=berat_akhir_asli+'0.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261011-0010','2026-10-11','2026-10-11','13:04:18','LIS','---','0.980','925000','925000','925000','925000','925000','kasir','2026-10-11 13:04:18','FB-261011-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261011-0010','INDAH','BULUKERTO','','','','kasir','2026-10-11 13:04:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-11' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261011-0029','K','2026-10-11','13:04:18','kasir','PEMBELIAN UMUM','FB-261011-0010','7795426000','925000','7794501000');
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 ('F326110138231','kasir','1',' MEE2 X CM ','TOKO','PM-E','E2E-ZJXH-125-0','CC X MODEL MATA CM 16 8K ','','0.710','1','100.00','741000','0','0','15000','740000','0','0','0','740000','SIN','00428613','E2E','0','0','-','1','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZJXH-125-0' 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='2026-10-11' AND kode_barang='E2E-ZJXH-125-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326110138231','2026-10-11','0.710','2026-10-11','13:38:23','PLG0031798','740000','740000','0','740000','740000','kasir','2026-10-11 13:38:23','F32611013823');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326110138231','2026-10-11','13:38:23','SIN','740000','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-261011-0030','D','2026-10-11','13:38:23','kasir','PENJUALAN','F326110138231','7794501000','740000','7795241000');
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 ('F326110221591','kasir','1',' MFB1 LG ','TOKO','PM-B','B1F-ZIXI-72-0','GW TUSUK MRICAN POLOS LG 8K ','','0.250','1','100.00','266000','0','0','15000','266000','0','0','0','266000','LIS','00422609','B1F','0','0','-','0','1063000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-ZIXI-72-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='B1F-ZIXI-72-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326110221591','2026-10-11','0.250','2026-10-11','14:21:59','PLG0031799','266000','266000','0','266000','266000','kasir','2026-10-11 14:21:59','F32611022159');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326110221591','2026-10-11','14:21:59','LIS','266000','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-261011-0031','D','2026-10-11','14:21:59','kasir','PENJUALAN','F326110221591','7795241000','266000','7795507000');
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 ('F326110224001','kasir','1',' MEH1 LG 42','TOKO','PM-H','H1E-ZIAI-292-0','KL TIFF MELODY MATA VAR LG 8K ','','0.980','1','100.00','1022000','0','0','15000','1023000','0','0','0','1023000','SIN','00424514','H1E','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIAI-292-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='H1E-ZIAI-292-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326110224001','2026-10-11','0.980','2026-10-11','14:24:00','PLG0031800','1023000','1023000','0','1023000','1023000','kasir','2026-10-11 14:24:00','F32611022400');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326110224001','2026-10-11','14:24:00','SIN','1023000','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-261011-0032','D','2026-10-11','14:24:00','kasir','PENJUALAN','F326110224001','7795507000','1023000','7796530000');
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 ('F326110231051','kasir','1',' MEA1 5K LG','TOKO','PM-A','A1E-ZIAI-298-0','AT BONEKA ANAK CAT VAR LG 8K ','','0.550','1','100.00','574000','0','0','15000','575000','0','5000','0','580000','AAT','00424520','A1E','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZIAI-298-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='A1E-ZIAI-298-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326110231051','2026-10-11','0.550','2026-10-11','14:31:06','PLG0031801','575000','575000','5000','580000','580000','kasir','2026-10-11 14:31:05','F32611023105');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326110231051','2026-10-11','14:31:06','AAT','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) VALUES ('KM-261011-0033','D','2026-10-11','14:31:06','kasir','PENJUALAN','F326110231051','7796530000','580000','7797110000');
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 ('F326110232041','kasir','1',' MDB1D X UB','TOKO','PM-B','B1D-ZJXH-63-0','GW X TIFF ARESO SLEP VAR UB 8K ','','1.100','1','100.00','1125000','0','0','15000','1125000','0','0','0','1125000','SIN','00428551','B1D','0','0','-','0','1023000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZJXH-63-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='B1D-ZJXH-63-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326110232041','2026-10-11','1.100','2026-10-11','14:32:04','PLG0031802','1125000','1125000','0','1125000','1125000','kasir','2026-10-11 14:32:04','F32611023204');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326110232041','2026-10-11','14:32:04','SIN','1125000','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-261011-0034','D','2026-10-11','14:32:04','kasir','PENJUALAN','F326110232041','7797110000','1125000','7798235000');
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 ('F326110259461','kasir','1',' MEH1 X KH ','TOKO','PM-H','H1E-ZHBE-41-0','KL X NORY KH 36 8K','','2.030','1','100.00','2117000','0','0','15000','2117000','0','0','0','2117000','SIN','00420083','H1E','0','0','-','0','1043000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHBE-41-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='H1E-ZHBE-41-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326110259461','2026-10-11','2.030','2026-10-11','14:59:47','PLG0031803','2117000','2117000','0','2117000','2117000','kasir','2026-10-11 14:59:46','F32611025946');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326110259461','2026-10-11','14:59:47','SIN','2117000','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-261011-0035','D','2026-10-11','14:59:47','kasir','PENJUALAN','F326110259461','7798235000','2117000','7800352000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2117000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110259461' 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 ('F326110259462','kasir',' 1',' MFD1 5K BG','TOKO','PM-D','D1F-ZICX-213-0','LT MODEL BALLERINA PASIR BG 8K ','','0.550','1','100.00','585000','0','0','15000','585000','0','5000','0','590000','SIN','00426622','D1F','0','0','-','0','1063000');
UPDATE tm_barang SET tgl_last_jual='2026-10-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZICX-213-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-10-11' AND kode_barang='D1F-ZICX-213-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326110259462','2026-10-11','0.550','2026-10-11','14:59:47','PLG0031804','585000','585000','5000','590000','590000','kasir','2026-10-11 14:59:46','F32611025946');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-10-11','F326110259462','2026-10-11','14:59:47','SIN','590000','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-261011-0036','D','2026-10-11','14:59:47','kasir','PENJUALAN','F326110259462','7800352000','590000','7800942000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='590000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326110259462' LIMIT 1;
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261011-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261011-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261011-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261011-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261011-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261011-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261011-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261011-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261011-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261011-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261011-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261011-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261011-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261011-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261011-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261011-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261011-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261011-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261011-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261011-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110138231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110138231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110138231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110221591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110221591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110221591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110224001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110224001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110224001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110231051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110231051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110231051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110232041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110232041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110232041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110259461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110259461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110259461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110259462' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110259462' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110259462';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110808101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110808101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110808101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110903411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110903411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110903411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110932521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110932521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110932521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110932522' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110932522' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110932522';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110932523' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110932523' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110932523';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110934201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110934201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110934201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110943141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110943141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110943141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110947101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110947101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110947101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326110956231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326110956231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326110956231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111002171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111002171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111002171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111002172' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111002172' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111002172';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111002173' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111002173' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111002173';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111002174' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111002174' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111002174';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111020451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111020451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111020451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111050181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111050181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111050181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111103161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111103161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111103161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111103162' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111103162' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111103162';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326111245261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326111245261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326111245261';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-12','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-11';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-11';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-11';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-10-11' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-11';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-11';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-11';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-11';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09';
UPDATE tt_barang_saldo SET tanggal= '2026-10-12' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-11' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261012-0001','D','2026-10-12','15:15:01','SYSTEM','SALDO AWAL','SALDO AWAL','0','7800942000','7800942000');
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-261012-0001','D','2026-10-12','15:15:01','BCA','SALDO AWAL','SALDO AWAL','0','743627000','743627000');
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-261012-0001','D','2026-10-12','15:15:01','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-261012-0001','D','2026-10-12','15:15:01','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-10-12';