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 ('F326050945001','input','1',' MEF1E TD 5','TOKO','PM-F','F1E-ZEBX-177-0','GL BANGKOK C LINE SLEP TD 56 8K ','','4.000','1','100.00','4240000','0','0','15000','4240000','0','0','0','4240000','AAT','00404455','F1E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEBX-177-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.000',berat_jual_asli=berat_jual_asli+'4.000',stock_jual='1',berat_akhir=berat_akhir-'4.000',berat_akhir_asli=berat_akhir_asli-'4.000',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='F1E-ZEBX-177-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 ('F326050945001','2026-07-05','4.000','2026-07-05','09:45:01','PLG0030136','4240000','4240000','0','4240000','4240000','input','2026-07-05 09:45:00','F32605094500');
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-07-05','F326050945001','2026-07-05','09:45:01','AAT','4240000','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-260705-0002','D','2026-07-05','09:45:01','input','PENJUALAN','F326050945001','6136340000','4240000','6140580000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4240000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326050945001' 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 ('F326050945002','input',' 1',' MEF1E TD 5','TOKO','PM-F','F1E-ZEBX-183-0','GL BANGKOK C SLEP TD 56 8K ','','2.950','1','100.00','3127000','0','0','15000','3128000','0','0','0','3128000','AAT','00404461','F1E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEBX-183-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.950',berat_jual_asli=berat_jual_asli+'2.950',stock_jual='1',berat_akhir=berat_akhir-'2.950',berat_akhir_asli=berat_akhir_asli-'2.950',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='F1E-ZEBX-183-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 ('F326050945002','2026-07-05','2.950','2026-07-05','09:45:01','PLG0030137','3128000','3128000','0','3128000','3128000','input','2026-07-05 09:45:00','F32605094500');
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-07-05','F326050945002','2026-07-05','09:45:01','AAT','3128000','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-260705-0003','D','2026-07-05','09:45:01','input','PENJUALAN','F326050945002','6140580000','3128000','6143708000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3128000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326050945002' 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 ('F326050945003','input',' 1',' MFH1 X UB ','TOKO','PM-H','H1F-YAXC-13-0','KL X CARENDELANO HURUF UB E 8K ','','2.050','1','100.00','2214000','0','0','15000','2215000','0','10000','0','2225000','AAT','00331976','H1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YAXC-13-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='H1F-YAXC-13-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 ('F326050945003','2026-07-05','2.050','2026-07-05','09:45:01','PLG0030138','2215000','2215000','10000','2225000','2225000','input','2026-07-05 09:45:00','F32605094500');
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-07-05','F326050945003','2026-07-05','09:45:01','AAT','2225000','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-260705-0004','D','2026-07-05','09:45:01','input','PENJUALAN','F326050945003','6143708000','2225000','6145933000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2225000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326050945003' 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 ('F326050945004','input',' 1',' MEH1 X UB ','TOKO','PM-H','H1E-ZEBE-189-0','KL X GUCCI ANAK UB 34 8K ','','1.070','1','100.00','1134000','0','0','15000','1135000','0','0','0','1135000','AAT','00404888','H1E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEBE-189-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.070',berat_jual_asli=berat_jual_asli+'1.070',stock_jual='1',berat_akhir=berat_akhir-'1.070',berat_akhir_asli=berat_akhir_asli-'1.070',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='H1E-ZEBE-189-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 ('F326050945004','2026-07-05','1.070','2026-07-05','09:45:01','PLG0030139','1135000','1135000','0','1135000','1135000','input','2026-07-05 09:45:00','F32605094500');
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-07-05','F326050945004','2026-07-05','09:45:01','AAT','1135000','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-260705-0005','D','2026-07-05','09:45:01','input','PENJUALAN','F326050945004','6145933000','1135000','6147068000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1135000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326050945004' 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 ('F326050945005','input',' 1',' MDE1 LG 16','TOKO','PM-E','E1D-ZEAE-229-0','CC MODEL LINEA LG 16 8K ','','1.100','1','100.00','1144000','0','0','15000','1145000','0','0','0','1145000','AAT','00403707','E1D','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZEAE-229-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-07-05' AND kode_barang='E1D-ZEAE-229-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 ('F326050945005','2026-07-05','1.100','2026-07-05','09:45:01','PLG0030140','1145000','1145000','0','1145000','1145000','input','2026-07-05 09:45:00','F32605094500');
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-07-05','F326050945005','2026-07-05','09:45:01','AAT','1145000','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-260705-0006','D','2026-07-05','09:45:01','input','PENJUALAN','F326050945005','6147068000','1145000','6148213000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1145000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326050945005' 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 ('F326051003441','input','1',' MEB1 LG PE','TOKO','PM-B','B1E-YKBB-230-0','GW MODEL MATA LG PE 8K ','','0.550','1','100.00','583000','0','0','15000','583000','0','0','0','583000','FIT','00378379','B1E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YKBB-230-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-07-05' AND kode_barang='B1E-YKBB-230-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 ('F326051003441','2026-07-05','0.550','2026-07-05','10:03:44','PLG0030141','583000','583000','0','583000','583000','input','2026-07-05 10:03:44','F32605100344');
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-07-05','F326051003441','2026-07-05','10:03:44','FIT','583000','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-260705-0007','D','2026-07-05','10:03:44','input','PENJUALAN','F326051003441','6148213000','583000','6148796000');
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 ('F326051025181','input','1',' MFD1F X BG','TOKO','PM-D','D1F-ZDBB-11-0','LT X SLOBOK HURUF BALOK BG S 8K ','','0.610','1','100.00','659000','0','0','15000','660000','0','0','0','660000','FIT','00400621','D1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZDBB-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='D1F-ZDBB-11-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 ('F326051025181','2026-07-05','0.610','2026-07-05','10:25:18','PLG0030142','660000','660000','0','660000','660000','input','2026-07-05 10:25:18','F32605102518');
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-07-05','F326051025181','2026-07-05','10:25:18','FIT','660000','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-260705-0008','D','2026-07-05','10:25:18','input','PENJUALAN','F326051025181','6148796000','660000','6149456000');
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 ('F326051032231','input','1',' MDE2 5K LG','TOKO','PM-E','E2D-ZDXG-221-0','CC ANAK OSROT BONEKA CAT MATA VAR LG 8K ','','1.000','1','100.00','1040000','0','0','15000','1040000','0','5000','0','1045000','FIT','00398399','E2D','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDXG-221-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='2026-07-05' AND kode_barang='E2D-ZDXG-221-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 ('F326051032231','2026-07-05','1.000','2026-07-05','10:32:23','PLG0030143','1040000','1040000','5000','1045000','1045000','input','2026-07-05 10:32:23','F32605103223');
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-07-05','F326051032231','2026-07-05','10:32:23','FIT','1045000','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-260705-0009','D','2026-07-05','10:32:23','input','PENJUALAN','F326051032231','6149456000','1045000','6150501000');
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 ('F326051046011','input','1',' MEF2 X PM ','TOKO','PM-F','F2E-ZEXI-12-0','GL X PIPA MATA PM 54 8K ','','2.940','1','100.00','3116000','0','0','15000','3115000','0','0','0','3115000','AAT','00402833','F2E','0','0','-','1','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZEXI-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.940',berat_jual_asli=berat_jual_asli+'2.940',stock_jual='1',berat_akhir=berat_akhir-'2.940',berat_akhir_asli=berat_akhir_asli-'2.940',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='F2E-ZEXI-12-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 ('F326051046011','2026-07-05','2.940','2026-07-05','10:46:02','PLG0030144','3115000','3115000','0','3115000','3115000','input','2026-07-05 10:46:01','F32605104601');
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-07-05','F326051046011','2026-07-05','10:46:02','AAT','3115000','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-260705-0010','D','2026-07-05','10:46:02','input','PENJUALAN','F326051046011','6150501000','3115000','6153616000');
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 ('F326051050141','input','1',' MEF3 UB ','TOKO','PM-F','F3E-YCBG-58-0','GL MODEL FANCY VAR UB 8K ','','1.950','1','100.00','2067000','0','0','15000','2068000','0','0','0','2068000','LIS','00346125','F3E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YCBG-58-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.950',berat_jual_asli=berat_jual_asli+'1.950',stock_jual='1',berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='F3E-YCBG-58-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 ('F326051050141','2026-07-05','1.950','2026-07-05','10:50:14','PLG0030145','2068000','2068000','0','2068000','2068000','input','2026-07-05 10:50:14','F32605105014');
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-07-05','F326051050141','2026-07-05','10:50:14','LIS','2068000','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-260705-0011','D','2026-07-05','10:50:14','input','PENJUALAN','F326051050141','6153616000','2068000','6155684000');
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 ('F326051058361','input','1',' TEH1 X DKS','TOKO','PT-H','H1TE-ZEBA-18-T','KL X SANTA SLEP DKS 44 17K ','','2.920','1','100.00','5694000','0','0','15000','5695000','0','0','0','5695000','FIT','T0079725','H1TE','0','0','-','0','1950000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZEBA-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.920',berat_jual_asli=berat_jual_asli+'2.920',stock_jual='1',berat_akhir=berat_akhir-'2.920',berat_akhir_asli=berat_akhir_asli-'2.920',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='H1TE-ZEBA-18-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326051058361','2026-07-05','2.920','2026-07-05','10:58:36','PLG0030146','5695000','5695000','0','5695000','5695000','input','2026-07-05 10:58:36','F32605105836');
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-07-05','F326051058361','2026-07-05','10:58:36','FIT','5695000','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-260705-0012','D','2026-07-05','10:58:36','input','PENJUALAN','F326051058361','6155684000','5695000','6161379000');
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 ('F326051151361','input','1',' MFE1 LG 10','TOKO','PM-E','E1F-ZGXA-339-0','CC MODEL ISYANA SLEP LG 10 8K ','','0.400','1','100.00','432000','0','0','15000','432000','0','0','0','432000','LIS','00411863','E1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGXA-339-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-07-05' AND kode_barang='E1F-ZGXA-339-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 ('F326051151361','2026-07-05','0.400','2026-07-05','11:51:37','PLG0030147','432000','432000','0','432000','432000','input','2026-07-05 11:51:36','F32605115136');
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-07-05','F326051151361','2026-07-05','11:51:37','LIS','432000','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-260705-0013','D','2026-07-05','11:51:37','input','PENJUALAN','F326051151361','6161379000','432000','6161811000');
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 ('F326051159341','input','1',' MEE1 X LG ','TOKO','PM-E','E1E-ZGXA-202-0','CC X MODEL DAUN SLEP LG 22 8K ','','0.550','1','100.00','583000','0','0','15000','583000','0','0','0','583000','SIN','00411726','E1E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXA-202-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-07-05' AND kode_barang='E1E-ZGXA-202-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 ('F326051159341','2026-07-05','0.550','2026-07-05','11:59:34','PLG0030148','583000','583000','0','583000','583000','input','2026-07-05 11:59:34','F32605115934');
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-07-05','F326051159341','2026-07-05','11:59:34','SIN','583000','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-260705-0014','D','2026-07-05','11:59:34','input','PENJUALAN','F326051159341','6161811000','583000','6162394000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='583000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326051159341' 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 ('F326051159342','input',' 1',' MEE1E HT 1','TOKO','PM-E','E1E-ZFBE-150-0','CC MODEL SLEP HT 17 8K ','','0.500','1','100.00','530000','0','0','15000','530000','0','0','0','530000','SIN','00410428','E1E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFBE-150-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='E1E-ZFBE-150-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 ('F326051159342','2026-07-05','0.500','2026-07-05','11:59:34','PLG0030149','530000','530000','0','530000','530000','input','2026-07-05 11:59:34','F32605115934');
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-07-05','F326051159342','2026-07-05','11:59:34','SIN','530000','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-260705-0015','D','2026-07-05','11:59:34','input','PENJUALAN','F326051159342','6162394000','530000','6162924000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='530000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326051159342' 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-00019555','X-00019555','CC BANGKOK SLEP PM 18 8K','GR','---','E1D','BELI','BELI001','1110000','2026-07-05','1.150','1','kasir','2026-07-05 12:15:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019555','X-00019555');
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-260705-0001','F326080808141','SIN','1','BELI','BELI001','E1D', 'X-00019555', 'CC BANGKOK SLEP PM 18 8K','1.150','1.150','100.00','1262000','1110000','965217','1050000','1','1110000','1110000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.150',berat_beli_asli=berat_beli_asli+'1.150',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.150',berat_akhir_asli=berat_akhir_asli+'1.150',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-05' 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-260705-0001','2026-07-05','2026-07-05','12:15:42','SIN','---','1.150','1110000','1110000','1110000','1110000','1110000','kasir','2026-07-05 12:15:42','FB-260705-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260705-0001','TINI','KENTENG','','','','kasir','2026-07-05 12:15:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-05' 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-260705-0016','K','2026-07-05','12:15:42','kasir','PEMBELIAN UMUM','FB-260705-0001','6162924000','1110000','6161814000');
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-00019556','X-00019556','CC X MODEL DAUN SLEP LG 14 8K','GR','---','E1E','BELI','BELI001','457000','2026-07-05','0.460','1','kasir','2026-07-05 12:16:05');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019556','X-00019556');
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-260705-0002','F326270919411','LIS','1','BELI','BELI001','E1E', 'X-00019556', 'CC X MODEL DAUN SLEP LG 14 8K','0.460','0.460','100.00','520000','457000','993478','1070000','1','457000','457000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.460',berat_beli_asli=berat_beli_asli+'0.460',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.460',berat_akhir_asli=berat_akhir_asli+'0.460',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-05' 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-260705-0002','2026-07-05','2026-07-05','12:16:05','LIS','---','0.460','457000','457000','457000','457000','457000','kasir','2026-07-05 12:16:05','FB-260705-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260705-0002','SRI LESTARI','BANDAR PACITAN','','','082338491291','kasir','2026-07-05 12:16:05');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-05' 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-260705-0017','K','2026-07-05','12:16:05','kasir','PEMBELIAN UMUM','FB-260705-0002','6161814000','457000','6161357000');
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-00019557','X-00019557','AT X HUGGIES KLIP MATA LG 8K','GR','---','A1D','BELI','BELI001','1075000','2026-07-05','1.100','1','kasir','2026-07-05 12:19:32');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00019557','X-00019557');
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-260705-0003','F326300233191','SIN','1','BELI','BELI001','A1D', 'X-00019557', 'AT X HUGGIES KLIP MATA LG 8K','1.100','1.100','100.00','1210000','1075000','977273','1050000','1','1075000','1075000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.100',berat_beli_asli=berat_beli_asli+'1.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.100',berat_akhir_asli=berat_akhir_asli+'1.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-05' 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-260705-0003','2026-07-05','2026-07-05','12:19:31','SIN','---','1.100','1075000','1075000','1075000','1075000','1075000','kasir','2026-07-05 12:19:32','FB-260705-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260705-0003','NASYA','KISMANTORO','','','','kasir','2026-07-05 12:19:32');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-05' 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-260705-0018','K','2026-07-05','12:19:31','kasir','PEMBELIAN UMUM','FB-260705-0003','6161357000','1075000','6160282000');
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-00019558','X-00019558','GL X RANTAI HOLLOW P4 SLEP KH','GR','---','F3E','BELI','BELI001','3735000','2026-07-05','4.970','1','kasir','2026-07-05 12:20:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019558','X-00019558');
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-260705-0004','F322300918342','LIS','1','BELI','BELI001','F3E', 'X-00019558', 'GL X RANTAI HOLLOW P4 SLEP KH','5.150','4.970','100.00','2274000','3735000','751509','1070000','1','3735000','3735000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.970',berat_beli_asli=berat_beli_asli+'4.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.970',berat_akhir_asli=berat_akhir_asli+'4.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-05' 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-260705-0004','2026-07-05','2026-07-05','12:20:24','LIS','---','4.970','3735000','3735000','3735000','3735000','3735000','kasir','2026-07-05 12:20:25','FB-260705-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260705-0004','LENDO','BANGSRI','','','','kasir','2026-07-05 12:20:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-05' 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-260705-0019','K','2026-07-05','12:20:24','kasir','PEMBELIAN UMUM','FB-260705-0004','6160282000','3735000','6156547000');
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-00019559','X-00019559','CC WEDDING MATA CM 20 8K','GR','---','E2D','BELI','BELI001','1588000','2026-07-05','2.160','1','kasir','2026-07-05 12:21:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019559','X-00019559');
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-260705-0005','F325151218382','FIT','1','BELI','BELI001','E2D', 'X-00019559', 'CC WEDDING MATA CM 20 8K','2.160','2.160','100.00','1700000','1588000','735185','1050000','1','1588000','1588000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.160',berat_beli_asli=berat_beli_asli+'2.160',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.160',berat_akhir_asli=berat_akhir_asli+'2.160',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-05' 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-260705-0005','2026-07-05','2026-07-05','12:21:13','FIT','---','2.160','1588000','1588000','1588000','1588000','1588000','kasir','2026-07-05 12:21:14','FB-260705-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260705-0005','YESICA MAHARANI','TERBIS KISMANTORO','','','','kasir','2026-07-05 12:21:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-05' 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-260705-0020','K','2026-07-05','12:21:13','kasir','PEMBELIAN UMUM','FB-260705-0005','6156547000','1588000','6154959000');
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-00019560','X-00019560','CC VELG POLOS CM 22 8K','GR','---','E1D','BELI','BELI001','735000','2026-07-05','1.000','1','kasir','2026-07-05 12:21:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019560','X-00019560');
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-260705-0006','F325151218381','FIT','2','BELI','BELI001','E1D', 'X-00019560', 'CC VELG POLOS CM 22 8K','1.000','1.000','100.00','787000','735000','735000','1050000','1','735000','735000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-05' 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-260705-0006','2026-07-05','2026-07-05','12:21:13','FIT','---','1.000','735000','735000','735000','735000','735000','kasir','2026-07-05 12:21:14','FB-260705-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260705-0006','YESICA MAHARANI','TERBIS KISMANTORO','','','','kasir','2026-07-05 12:21:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-05' 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-260705-0021','K','2026-07-05','12:21:13','kasir','PEMBELIAN UMUM','FB-260705-0006','6154959000','735000','6154224000');
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-00019561','X-00019561','CC WEDDING MATA CM 12 8K','GR','---','E2D','BELI','BELI001','1532000','2026-07-05','1.980','1','kasir','2026-07-05 12:21:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019561','X-00019561');
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-260705-0007','F325140140002','LIS','1','BELI','BELI001','E2D', 'X-00019561', 'CC WEDDING MATA CM 12 8K','1.980','1.980','100.00','1648000','1532000','773737','1050000','1','1532000','1532000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.980',berat_beli_asli=berat_beli_asli+'1.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.980',berat_akhir_asli=berat_akhir_asli+'1.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-05' 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-260705-0007','2026-07-05','2026-07-05','12:21:35','LIS','---','1.980','1532000','1532000','1532000','1532000','1532000','kasir','2026-07-05 12:21:35','FB-260705-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260705-0007','ALVINA','BANGSRI PURWANTORO','','','','kasir','2026-07-05 12:21:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-05' 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-260705-0022','K','2026-07-05','12:21:35','kasir','PEMBELIAN UMUM','FB-260705-0007','6154224000','1532000','6152692000');
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-00019562','X-00019562','KL MILANO UB 40CM 8K','GR','---','H1F','BELI','BELI001','5055000','2026-07-05','5.040','1','kasir','2026-07-05 12:25:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1F','X-00019562','X-00019562');
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-260705-0008','F326181207541','SIN','1','BELI','BELI001','H1F', 'X-00019562', 'KL MILANO UB 40CM 8K','5.040','5.040','100.00','5670000','5055000','1002976','1080000','1','5055000','5055000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.040',berat_beli_asli=berat_beli_asli+'5.040',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.040',berat_akhir_asli=berat_akhir_asli+'5.040',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1F' 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-260705-0008','2026-07-05','2026-07-05','12:25:10','SIN','---','5.040','5055000','5055000','5055000','5055000','5055000','kasir','2026-07-05 12:25:10','FB-260705-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260705-0008','IKA','KISMANTORO LEMAHBANG','','','081249346287','kasir','2026-07-05 12:25:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-05' 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-260705-0023','K','2026-07-05','12:25:10','kasir','PEMBELIAN UMUM','FB-260705-0008','6152692000','5055000','6147637000');
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-00019563','X-00019563','CC X MODEL MATA CM 14 8K','GR','---','E2D','BELI','BELI001','1170000','2026-07-05','1.200','1','kasir','2026-07-05 12:25:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019563','X-00019563');
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-260705-0009','F326181207542','SIN','2','BELI','BELI001','E2D', 'X-00019563', 'CC X MODEL MATA CM 14 8K','1.200','1.200','100.00','1302000','1170000','975000','1050000','1','1170000','1170000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.200',berat_beli_asli=berat_beli_asli+'1.200',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.200',berat_akhir_asli=berat_akhir_asli+'1.200',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-05' 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-260705-0009','2026-07-05','2026-07-05','12:25:10','SIN','---','1.200','1170000','1170000','1170000','1170000','1170000','kasir','2026-07-05 12:25:10','FB-260705-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260705-0009','IKA','KISMANTORO LEMAHBANG','','','081249346287','kasir','2026-07-05 12:25:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-05' 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-260705-0024','K','2026-07-05','12:25:10','kasir','PEMBELIAN UMUM','FB-260705-0009','6147637000','1170000','6146467000');
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-00019564','X-00019564','CC X MODEL MATA HW 13 8K','GR','---','E2D','BELI','BELI001','1512000','2026-07-05','1.550','1','kasir','2026-07-05 12:25:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019564','X-00019564');
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-260705-0010','F326181207544','SIN','3','BELI','BELI001','E2D', 'X-00019564', 'CC X MODEL MATA HW 13 8K','1.550','1.550','100.00','1682000','1512000','975484','1050000','1','1512000','1512000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.550',berat_beli_asli=berat_beli_asli+'1.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.550',berat_akhir_asli=berat_akhir_asli+'1.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-05' 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-260705-0010','2026-07-05','2026-07-05','12:25:10','SIN','---','1.550','1512000','1512000','1512000','1512000','1512000','kasir','2026-07-05 12:25:10','FB-260705-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260705-0010','IKA','KISMANTORO LEMAHBANG','','','081249346287','kasir','2026-07-05 12:25:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-05' 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-260705-0025','K','2026-07-05','12:25:10','kasir','PEMBELIAN UMUM','FB-260705-0010','6146467000','1512000','6144955000');
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-00019565','X-00019565','LT XXX MODEL MATA LT 8K','GR','---','D2D','BELI','BELI001','1007000','2026-07-05','1.010','1','kasir','2026-07-05 12:25:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2D','X-00019565','X-00019565');
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-260705-0011','F326181207543','SIN','4','BELI','BELI001','D2D', 'X-00019565', 'LT XXX MODEL MATA LT 8K','1.010','1.010','100.00','1095000','1007000','997030','1050000','1','1007000','1007000','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-07-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2D' 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-260705-0011','2026-07-05','2026-07-05','12:25:10','SIN','---','1.010','1007000','1007000','1007000','1007000','1007000','kasir','2026-07-05 12:25:10','FB-260705-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260705-0011','IKA','KISMANTORO LEMAHBANG','','','081249346287','kasir','2026-07-05 12:25:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-05' 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-260705-0026','K','2026-07-05','12:25:10','kasir','PEMBELIAN UMUM','FB-260705-0011','6144955000','1007000','6143948000');
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 ('F326051247541','kasir','1',' MGB1G LG ','TOKO','PM-B','B1G-ZFBB-63-0','GW MODEL TAUGE MRICAN LG 8K ','','0.280','1','100.00','308000','0','0','15000','308000','0','0','0','308000','SIN','00409642','B1G','0','0','-','0','1100000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZFBB-63-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.280',berat_jual_asli=berat_jual_asli+'0.280',stock_jual='1',berat_akhir=berat_akhir-'0.280',berat_akhir_asli=berat_akhir_asli-'0.280',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='B1G-ZFBB-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 ('F326051247541','2026-07-05','0.280','2026-07-05','12:47:54','PLG0030150','308000','308000','0','308000','308000','kasir','2026-07-05 12:47:54','F32605124754');
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-07-05','F326051247541','2026-07-05','12:47:54','SIN','308000','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-260705-0027','D','2026-07-05','12:47:54','kasir','PENJUALAN','F326051247541','6143948000','308000','6144256000');
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-00019566','X-00019566','AT TINDIK BABY HK 8K','GR','---','A1H','BELI','BELI001','265000','2026-07-05','0.260','1','kasir','2026-07-05 12:51:19');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1H';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1H','X-00019566','X-00019566');
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-260705-0012','F326170827451','SIN','1','BELI','BELI001','A1H', 'X-00019566', 'AT TINDIK BABY HK 8K','0.260','0.260','100.00','310000','265000','1019231','1120000','1','265000','265000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.260',berat_beli_asli=berat_beli_asli+'0.260',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.260',berat_akhir_asli=berat_akhir_asli+'0.260',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1H' 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-260705-0012','2026-07-05','2026-07-05','12:51:19','SIN','---','0.260','265000','265000','265000','265000','265000','kasir','2026-07-05 12:51:19','FB-260705-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260705-0012','RISKI','KENTENG PURWANTORO','','','0881012586329','kasir','2026-07-05 12:51:19');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-05' 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-260705-0028','K','2026-07-05','12:51:19','kasir','PEMBELIAN UMUM','FB-260705-0012','6144256000','265000','6143991000');
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 ('F326050102181','kasir','1',' MJH2 X KH ','TOKO','PM-H','H2J-ZFXH-182-0','KL X SIEM COBRA KH 42 9K ','','1.300','1','100.00','1508000','0','0','15000','1508000','0','0','0','1508000','LIS','00408043','H2J','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZFXH-182-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.300',berat_jual_asli=berat_jual_asli+'1.300',stock_jual='1',berat_akhir=berat_akhir-'1.300',berat_akhir_asli=berat_akhir_asli-'1.300',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='H2J-ZFXH-182-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 ('F326050102181','2026-07-05','1.300','2026-07-05','13:02:19','PLG0030151','1508000','1508000','0','1508000','1508000','kasir','2026-07-05 13:02:18','F32605010218');
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-07-05','F326050102181','2026-07-05','13:02:19','LIS','1508000','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-260705-0029','D','2026-07-05','13:02:19','kasir','PENJUALAN','F326050102181','6143991000','1508000','6145499000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1508000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326050102181' 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 ('F326050102182','kasir',' 1',' MFD2F X LG','TOKO','PM-D','D2F-ZDBG-49-0','LT X MODEL MATA ROSE LG 8K ','','0.390','1','100.00','421000','0','0','15000','422000','0','0','0','422000','LIS','00401292','D2F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2F-ZDBG-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.390',berat_jual_asli=berat_jual_asli+'0.390',stock_jual='1',berat_akhir=berat_akhir-'0.390',berat_akhir_asli=berat_akhir_asli-'0.390',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='D2F-ZDBG-49-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 ('F326050102182','2026-07-05','0.390','2026-07-05','13:02:19','PLG0030152','422000','422000','0','422000','422000','kasir','2026-07-05 13:02:18','F32605010218');
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-07-05','F326050102182','2026-07-05','13:02:19','LIS','422000','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-260705-0030','D','2026-07-05','13:02:19','kasir','PENJUALAN','F326050102182','6145499000','422000','6145921000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='422000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326050102182' 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 ('F326050111301','kasir','1',' MEE2 X CM ','TOKO','PM-E','E2E-ZGXA-75-0','CC X MODEL MATA CM 16 8K ','','0.630','1','100.00','668000','0','0','15000','668000','0','0','0','668000','LIS','00411599','E2E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGXA-75-0' 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='2026-07-05' AND kode_barang='E2E-ZGXA-75-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 ('F326050111301','2026-07-05','0.630','2026-07-05','13:11:31','PLG0030153','668000','668000','0','668000','668000','kasir','2026-07-05 13:11:30','F32605011130');
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-07-05','F326050111301','2026-07-05','13:11:31','LIS','668000','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-260705-0031','D','2026-07-05','13:11:31','kasir','PENJUALAN','F326050111301','6145921000','668000','6146589000');
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 ('F326050124441','kasir','1',' MEB1 LG PE','TOKO','PM-B','B1E-ZEBX-219-0','GW MODEL MATA LG PE 8K ','','0.610','1','100.00','647000','0','0','15000','645000','0','0','0','645000','AAT','00404497','B1E','0','0','-','1','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEBX-219-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='B1E-ZEBX-219-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 ('F326050124441','2026-07-05','0.610','2026-07-05','13:24:44','PLG0030154','645000','645000','0','645000','645000','kasir','2026-07-05 13:24:44','F32605012444');
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-07-05','F326050124441','2026-07-05','13:24:44','AAT','645000','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-260705-0032','D','2026-07-05','13:24:44','kasir','PENJUALAN','F326050124441','6146589000','645000','6147234000');
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 ('F326050125081','kasir','1',' MFA1F X BM','TOKO','PM-A','A1F-XDXG-565-0','AT X BONEKA ANAK CAT BM 8K ','','0.620','1','100.00','670000','0','0','15000','670000','0','0','0','670000','AAT','00291516','A1F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-XDXG-565-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-07-05' AND kode_barang='A1F-XDXG-565-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 ('F326050125081','2026-07-05','0.620','2026-07-05','13:25:08','PLG0030155','670000','670000','0','670000','670000','kasir','2026-07-05 13:25:08','F32605012508');
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-07-05','F326050125081','2026-07-05','13:25:08','AAT','670000','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-260705-0033','D','2026-07-05','13:25:08','kasir','PENJUALAN','F326050125081','6147234000','670000','6147904000');
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-00019567','X-00019567','CC WEDDING MATA CM 12 8K','GR','---','E2D','BELI','BELI001','1450000','2026-07-05','1.500','1','kasir','2026-07-05 14:11:13');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019567','X-00019567');
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-260705-0013','F326101206341','LIS','1','BELI','BELI001','E2D', 'X-00019567', 'CC WEDDING MATA CM 12 8K','1.500','1.500','100.00','1620000','1450000','966667','1050000','1','1450000','1450000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.500',berat_beli_asli=berat_beli_asli+'1.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.500',berat_akhir_asli=berat_akhir_asli+'1.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-05' 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-260705-0013','2026-07-05','2026-07-05','14:11:13','LIS','---','1.500','1450000','1450000','1450000','1450000','1450000','kasir','2026-07-05 14:11:13','FB-260705-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260705-0013','DWI SUSANTI','PLOSO','','','','kasir','2026-07-05 14:11:13');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-05' 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-260705-0034','K','2026-07-05','14:11:13','kasir','PEMBELIAN UMUM','FB-260705-0013','6147904000','1450000','6146454000');
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 ('F326050225381','input','1',' MDA1D X HW','TOKO','PM-A','A1D-ZEXE-5-0','AT X MODEL ARESO SLEP VAR HW 8K ','','0.850','1','100.00','884000','0','0','15000','885000','0','0','0','885000','SIN','00402178','A1D','0','0','-','0','1050000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZEXE-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='A1D-ZEXE-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 ('F326050225381','2026-07-05','0.850','2026-07-05','14:25:39','PLG0030156','885000','885000','0','885000','885000','input','2026-07-05 14:25:38','F32605022538');
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-07-05','F326050225381','2026-07-05','14:25:39','SIN','885000','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-260705-0035','D','2026-07-05','14:25:39','input','PENJUALAN','F326050225381','6146454000','885000','6147339000');
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 ('F326050238531','input','1',' MEH1 X UB ','TOKO','PM-H','H1E-ZFXH-187-0','KL X GUCCI UB 44 8K ','','3.910','1','100.00','4145000','0','0','15000','4145000','0','0','0','4145000','LIS','00408048','H1E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFXH-187-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.910',berat_jual_asli=berat_jual_asli+'3.910',stock_jual='1',berat_akhir=berat_akhir-'3.910',berat_akhir_asli=berat_akhir_asli-'3.910',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='H1E-ZFXH-187-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 ('F326050238531','2026-07-05','3.910','2026-07-05','14:38:54','PLG0030157','4145000','4145000','0','4145000','4145000','input','2026-07-05 14:38:53','F32605023853');
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-07-05','F326050238531','2026-07-05','14:38:54','LIS','4145000','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-260705-0036','D','2026-07-05','14:38:54','input','PENJUALAN','F326050238531','6147339000','4145000','6151484000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='4145000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326050238531' 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 ('F326050238532','input',' 1',' MEF3E X HW','TOKO','PM-F','F3E-ZFCX-176-0','GL X CASTELI SLEP HW 8K ','','1.330','1','100.00','1410000','0','0','15000','1410000','0','0','0','1410000','LIS','00411383','F3E','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-07-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFCX-176-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.330',berat_jual_asli=berat_jual_asli+'1.330',stock_jual='1',berat_akhir=berat_akhir-'1.330',berat_akhir_asli=berat_akhir_asli-'1.330',stock_akhir='0' WHERE tanggal='2026-07-05' AND kode_barang='F3E-ZFCX-176-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 ('F326050238532','2026-07-05','1.330','2026-07-05','14:38:54','PLG0030158','1410000','1410000','0','1410000','1410000','input','2026-07-05 14:38:53','F32605023853');
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-07-05','F326050238532','2026-07-05','14:38:54','LIS','1410000','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-260705-0037','D','2026-07-05','14:38:54','input','PENJUALAN','F326050238532','6151484000','1410000','6152894000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1410000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326050238532' 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-00019568','X-00019568','KL XXX MILANO KH 44 9K','GR','---','H2J','BELI','BELI001','2147000','2026-07-05','2.110','1','kasir','2026-07-05 14:45:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00019568','X-00019568');
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-260705-0014','F325021118141','LIS','1','BELI','BELI001','H2J', 'X-00019568', 'KL XXX MILANO KH 44 9K','2.110','2.110','100.00','2260000','2147000','1017536','1160000','1','2147000','2147000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.110',berat_beli_asli=berat_beli_asli+'2.110',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.110',berat_akhir_asli=berat_akhir_asli+'2.110',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-05' 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-260705-0014','2026-07-05','2026-07-05','14:45:09','LIS','---','2.110','2147000','2147000','2147000','2147000','2147000','kasir','2026-07-05 14:45:10','FB-260705-0014');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260705-0014','SINTYA','PUHPELEM','','','082141366654','kasir','2026-07-05 14:45:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-05' 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-260705-0038','K','2026-07-05','14:45:09','kasir','PEMBELIAN UMUM','FB-260705-0014','6152894000','2147000','6150747000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260705-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260705-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260705-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260705-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260705-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260705-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260705-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260705-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260705-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260705-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260705-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260705-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260705-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260705-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260705-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260705-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260705-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260705-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260705-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260705-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260705-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260705-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260705-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260705-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260705-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260705-0013';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260705-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260705-0014';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050102181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050102181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050102181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050102182' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050102182' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050102182';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050111301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050111301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050111301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050124441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050124441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050124441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050125081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050125081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050125081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050225381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050225381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050225381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050238531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050238531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050238531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050238532' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050238532' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050238532';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050945001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050945001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050945001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050945002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050945002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050945002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050945003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050945003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050945003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050945004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050945004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050945004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050945005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050945005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050945005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051003441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051003441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051003441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051025181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051025181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051025181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051032231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051032231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051032231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051046011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051046011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051046011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051050141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051050141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051050141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051058361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051058361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051058361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051151361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051151361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051151361';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051159341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051159341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051159341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051159342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051159342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051159342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051247541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051247541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051247541';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-06','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-05';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-05';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-05';
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-07-05' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-05';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-05';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-05';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-05';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-06' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-05' 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-260706-0001','D','2026-07-06','15:07:56','SYSTEM','SALDO AWAL','SALDO AWAL','0','6150747000','6150747000');
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-260706-0001','D','2026-07-06','15:07:56','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-260706-0001','D','2026-07-06','15:07:56','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-260706-0001','D','2026-07-06','15:07:56','BCA','SALDO AWAL','SALDO AWAL','0','732522000','732522000');
UPDATE tp_system SET tgl_system='2026-07-06';