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 ('F326020833191','input','1',' MFD1F X LG','TOKO','PM-D','D1F-ZGCX-40-0','LT X SLOBOK RIBBON SLEP LG 8K ','GL MANIK','0.310','1','100.00','325000','0','0','15000','325000','0','35000','0','360000','FIT','00415939','D1F','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-08-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGCX-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-08-02' AND kode_barang='D1F-ZGCX-40-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 ('F326020833191','2026-08-02','0.310','2026-08-02','08:33:20','PLG0030599','325000','325000','35000','360000','360000','input','2026-08-02 08:33:19','F32602083319');
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-08-02','F326020833191','2026-08-02','08:33:20','FIT','360000','35000');
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-260802-0002','D','2026-08-02','08:33:20','input','PENJUALAN','F326020833191','6602104000','360000','6602464000');
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 ('F326020833591','input','1',' MFD1F X LG','TOKO','PM-D','D1F-ZFCX-35-0','LT X SLOBOK KUPU SLEP LG 8K ','','0.320','1','100.00','336000','0','0','15000','337000','0','35000','0','372000','FIT','00411242','D1F','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-08-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZFCX-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2026-08-02' AND kode_barang='D1F-ZFCX-35-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 ('F326020833591','2026-08-02','0.320','2026-08-02','08:33:59','PLG0030600','337000','337000','35000','372000','372000','input','2026-08-02 08:33:59','F32602083359');
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-08-02','F326020833591','2026-08-02','08:33:59','FIT','372000','35000');
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-260802-0003','D','2026-08-02','08:33:59','input','PENJUALAN','F326020833591','6602464000','372000','6602836000');
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 ('F326020853511','input','1',' MEH1E UB 5','TOKO','PM-H','H1E-ZGBI-133-0','KL NORY SEMI UB 54 8K ','','4.060','1','100.00','4182000','0','0','15000','4183000','0','0','0','4183000','FIT','00415893','H1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGBI-133-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-08-02' AND kode_barang='H1E-ZGBI-133-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 ('F326020853511','2026-08-02','4.060','2026-08-02','08:53:51','PLG0030601','4183000','4183000','0','4183000','4183000','input','2026-08-02 08:53:51','F32602085351');
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-08-02','F326020853511','2026-08-02','08:53:51','FIT','4183000','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-260802-0004','D','2026-08-02','08:53:51','input','PENJUALAN','F326020853511','6602836000','4183000','6607019000');
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 ('F326020926531','input','1',' MEE1 X OR ','TOKO','PM-E','E1E-XDBI-135-0','CC X BANGKOK SLEP OR 10 8K ','','0.960','1','100.00','989000','0','0','15000','990000','0','0','0','990000','FIT','00295525','E1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-XDBI-135-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-08-02' AND kode_barang='E1E-XDBI-135-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 ('F326020926531','2026-08-02','0.960','2026-08-02','09:26:54','PLG0030602','990000','990000','0','990000','990000','input','2026-08-02 09:26:53','F32602092653');
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-08-02','F326020926531','2026-08-02','09:26:54','FIT','990000','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-260802-0005','D','2026-08-02','09:26:54','input','PENJUALAN','F326020926531','6607019000','990000','6608009000');
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 ('F326020948111','input','1',' MEA1E X UB','TOKO','PM-A','A1E-ZCAD-26-0','AT X MODEL ARESO VAR UB 8K ','','0.710','1','100.00','731000','0','0','15000','732000','0','0','0','732000','FIT','00394154','A1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZCAD-26-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-08-02' AND kode_barang='A1E-ZCAD-26-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 ('F326020948111','2026-08-02','0.710','2026-08-02','09:48:12','PLG0030603','732000','732000','0','732000','732000','input','2026-08-02 09:48:11','F32602094811');
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-08-02','F326020948111','2026-08-02','09:48:12','FIT','732000','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-260802-0006','D','2026-08-02','09:48:12','input','PENJUALAN','F326020948111','6608009000','732000','6608741000');
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 ('F326020949561','input','1',' MFD1F X BG','TOKO','PM-D','D1F-ZFAB-157-0','LT X SLOBOK HURUF BULAT BG A 8K ','GL MANIK','0.620','1','100.00','651000','0','0','15000','652000','0','35000','0','687000','FIT','00408626','D1F','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-08-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZFAB-157-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-08-02' AND kode_barang='D1F-ZFAB-157-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 ('F326020949561','2026-08-02','0.620','2026-08-02','09:49:56','PLG0030604','652000','652000','35000','687000','687000','input','2026-08-02 09:49:56','F32602094956');
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-08-02','F326020949561','2026-08-02','09:49:56','FIT','687000','35000');
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-260802-0007','D','2026-08-02','09:49:56','input','PENJUALAN','F326020949561','6608741000','687000','6609428000');
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 ('F326021008131','input','1',' MGA1G X LG','TOKO','PM-A','A1G-ZGAG-24-0','AT X DAKOCAN ANAK LG 8K ','','0.300','1','100.00','321000','0','0','15000','320000','0','0','0','320000','LIS','00413860','A1G','0','0','-','1','1070000');
UPDATE tm_barang SET tgl_last_jual='2026-08-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZGAG-24-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2026-08-02' AND kode_barang='A1G-ZGAG-24-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 ('F326021008131','2026-08-02','0.300','2026-08-02','10:08:14','PLG0030605','320000','320000','0','320000','320000','input','2026-08-02 10:08:13','F32602100813');
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-08-02','F326021008131','2026-08-02','10:08:14','LIS','320000','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-260802-0008','D','2026-08-02','10:08:14','input','PENJUALAN','F326021008131','6609428000','320000','6609748000');
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 ('F326021017431','input','1',' MEF1 X 10K','TOKO','PM-F','F1E-ZFXE-276-0','GL XX BANGKOK HOLLOW SLEP PM 58 8K ','','2.850','1','100.00','2935000','0','0','15000','2935000','0','10000','0','2945000','FIT','00407528','F1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFXE-276-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.850',berat_jual_asli=berat_jual_asli+'2.850',stock_jual='1',berat_akhir=berat_akhir-'2.850',berat_akhir_asli=berat_akhir_asli-'2.850',stock_akhir='0' WHERE tanggal='2026-08-02' AND kode_barang='F1E-ZFXE-276-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 ('F326021017431','2026-08-02','2.850','2026-08-02','10:17:43','PLG0030606','2935000','2935000','10000','2945000','2945000','input','2026-08-02 10:17:43','F32602101743');
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-08-02','F326021017431','2026-08-02','10:17:43','FIT','2945000','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-260802-0009','D','2026-08-02','10:17:43','input','PENJUALAN','F326021017431','6609748000','2945000','6612693000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2945000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326021017431' 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 ('F326021017432','input',' 1',' MEF1 X PM ','TOKO','PM-F','F1E-ZFXC-145-0','GL X BANGKOK HOLLOW LASER PM 58 8K ','','2.960','1','100.00','3049000','0','0','15000','3050000','0','0','0','3050000','FIT','00406688','F1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFXC-145-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.960',berat_jual_asli=berat_jual_asli+'2.960',stock_jual='1',berat_akhir=berat_akhir-'2.960',berat_akhir_asli=berat_akhir_asli-'2.960',stock_akhir='0' WHERE tanggal='2026-08-02' AND kode_barang='F1E-ZFXC-145-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 ('F326021017432','2026-08-02','2.960','2026-08-02','10:17:43','PLG0030607','3050000','3050000','0','3050000','3050000','input','2026-08-02 10:17:43','F32602101743');
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-08-02','F326021017432','2026-08-02','10:17:43','FIT','3050000','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-260802-0010','D','2026-08-02','10:17:43','input','PENJUALAN','F326021017432','6612693000','3050000','6615743000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3050000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326021017432' 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 ('F326021028591','input','1',' MEE1 XXX C','TOKO','PM-E','E1E-ZEBH-288-0','CC XXX PIPA SLEP CM 18 8K ','','0.690','1','100.00','711000','0','0','15000','690000','0','0','0','690000','FIT','00405506','E1E','0','0','-','1','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBH-288-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.690',berat_jual_asli=berat_jual_asli+'0.690',stock_jual='1',berat_akhir=berat_akhir-'0.690',berat_akhir_asli=berat_akhir_asli-'0.690',stock_akhir='0' WHERE tanggal='2026-08-02' AND kode_barang='E1E-ZEBH-288-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 ('F326021028591','2026-08-02','0.690','2026-08-02','10:28:59','PLG0030608','690000','690000','0','690000','690000','input','2026-08-02 10:28:59','F32602102859');
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-08-02','F326021028591','2026-08-02','10:28:59','FIT','690000','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-260802-0011','D','2026-08-02','10:28:59','input','PENJUALAN','F326021028591','6615743000','690000','6616433000');
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 ('F326021127061','input','1',' MDA1D X LG','TOKO','PM-A','A1D-ZABC-3-0','AT X GYPSY SLEP LG 8K ','','1.080','1','100.00','1091000','0','0','15000','1092000','0','0','0','1092000','FIT','00386633','A1D','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2026-08-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZABC-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-08-02' AND kode_barang='A1D-ZABC-3-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 ('F326021127061','2026-08-02','1.080','2026-08-02','11:27:07','PLG0030609','1092000','1092000','0','1092000','1092000','input','2026-08-02 11:27:06','F32602112706');
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-08-02','F326021127061','2026-08-02','11:27:07','FIT','1092000','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-260802-0012','D','2026-08-02','11:27:07','input','PENJUALAN','F326021127061','6616433000','1092000','6617525000');
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 ('F326021147241','input','1',' MEF3E PM ','TOKO','PM-F','F3E-ZGBI-137-0','GL VERONA SLEP PM 8K ','','3.130','1','100.00','3224000','0','0','15000','3225000','0','0','0','3225000','FIT','00415897','F3E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGBI-137-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.130',berat_jual_asli=berat_jual_asli+'3.130',stock_jual='1',berat_akhir=berat_akhir-'3.130',berat_akhir_asli=berat_akhir_asli-'3.130',stock_akhir='0' WHERE tanggal='2026-08-02' AND kode_barang='F3E-ZGBI-137-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 ('F326021147241','2026-08-02','3.130','2026-08-02','11:47:24','PLG0030610','3225000','3225000','0','3225000','3225000','input','2026-08-02 11:47:24','F32602114724');
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-08-02','F326021147241','2026-08-02','11:47:24','FIT','3225000','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-260802-0013','D','2026-08-02','11:47:24','input','PENJUALAN','F326021147241','6617525000','3225000','6620750000');
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 ('F326021212431','kasir','1',' MEF2 UB 56','TOKO','PM-F','F2E-ZGAH-137-0','GL COR OVAL PAKU MATA UB 56 8K ','','2.360','1','100.00','2431000','0','0','15000','2430000','0','0','0','2430000','FIT','00414198','F2E','0','0','-','1','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZGAH-137-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.360',berat_jual_asli=berat_jual_asli+'2.360',stock_jual='1',berat_akhir=berat_akhir-'2.360',berat_akhir_asli=berat_akhir_asli-'2.360',stock_akhir='0' WHERE tanggal='2026-08-02' AND kode_barang='F2E-ZGAH-137-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 ('F326021212431','2026-08-02','2.360','2026-08-02','12:12:43','PLG0030611','2430000','2430000','0','2430000','2430000','kasir','2026-08-02 12:12:43','F32602121243');
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-08-02','F326021212431','2026-08-02','12:12:43','FIT','2430000','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-260802-0014','D','2026-08-02','12:12:43','kasir','PENJUALAN','F326021212431','6620750000','2430000','6623180000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326021212431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326021212431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326021212431';
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 ('F326021215361','kasir','1',' MEF2 UB 56','TOKO','PM-F','F2E-ZGAH-137-0','GL COR OVAL PAKU MATA UB 56 8K ','','2.360','1','100.00','2431000','0','0','15000','2430000','0','0','0','2430000','FIT','00414198','F2E','0','0','-','1','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZGAH-137-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.360',berat_jual_asli=berat_jual_asli+'2.360',stock_jual='1',berat_akhir=berat_akhir-'2.360',berat_akhir_asli=berat_akhir_asli-'2.360',stock_akhir='0' WHERE tanggal='2026-08-02' AND kode_barang='F2E-ZGAH-137-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 ('F326021215361','2026-08-02','2.360','2026-08-02','12:15:36','PLG0030612','2430000','2430000','0','2430000','2430000','kasir','2026-08-02 12:15:36','F32602121536');
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-08-02','F326021215361','2026-08-02','12:15:36','FIT','2430000','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-260802-0016','D','2026-08-02','12:15:36','kasir','PENJUALAN','F326021215361','6620750000','2430000','6623180000');
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-00019808','X-00019808','AT MODEL SLEP VAR LG 8K','GR','---','A1D','BELI','BELI001','777000','2026-08-02','0.830','1','kasir','2026-08-02 12:21:27');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00019808','X-00019808');
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-260802-0001','F326281201101','FIT','1','BELI','BELI001','A1D', 'X-00019808', 'AT MODEL SLEP VAR LG 8K','0.830','0.830','100.00','868000','777000','936145','1020000','1','777000','777000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.830',berat_beli_asli=berat_beli_asli+'0.830',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.830',berat_akhir_asli=berat_akhir_asli+'0.830',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-02' 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-260802-0001','2026-08-02','2026-08-02','12:21:26','FIT','---','0.830','777000','777000','777000','777000','777000','kasir','2026-08-02 12:21:27','FB-260802-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260802-0001','DESI','POHIJO SAMPUNG','','','','kasir','2026-08-02 12:21:27');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-02' 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-260802-0017','K','2026-08-02','12:21:26','kasir','PEMBELIAN UMUM','FB-260802-0001','6623180000','777000','6622403000');
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-00019809','X-00019809','CC VELG POLOS CM 14 8K','GR','---','E1D','BELI','BELI001','737000','2026-08-02','1.010','1','kasir','2026-08-02 12:23:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019809','X-00019809');
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-260802-0002','F325070924181','FIT','1','BELI','BELI001','E1D', 'X-00019809', 'CC VELG POLOS CM 14 8K','1.030','1.010','100.00','835000','737000','729703','1020000','1','737000','737000','RUSAK');
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-08-02' 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-260802-0002','2026-08-02','2026-08-02','12:23:33','FIT','---','1.010','737000','737000','737000','737000','737000','kasir','2026-08-02 12:23:33','FB-260802-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260802-0002','ISNA','POHIJO SAMPUNG','','','','kasir','2026-08-02 12:23:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-02' 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-260802-0018','K','2026-08-02','12:23:33','kasir','PEMBELIAN UMUM','FB-260802-0002','6622403000','737000','6621666000');
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-00019810','X-00019810','CC VELG KACA CM 22 8K','GR','---','E1D','BELI','BELI001','825000','2026-08-02','0.950','1','kasir','2026-08-02 12:24:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019810','X-00019810');
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-260802-0003','F326111025311','AAT','1','BELI','BELI001','E1D', 'X-00019810', 'CC VELG KACA CM 22 8K','0.950','0.950','100.00','1180000','825000','868421','1020000','1','825000','825000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.950',berat_beli_asli=berat_beli_asli+'0.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.950',berat_akhir_asli=berat_akhir_asli+'0.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-02' 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-260802-0003','2026-08-02','2026-08-02','12:24:23','AAT','---','0.950','825000','825000','825000','825000','825000','kasir','2026-08-02 12:24:23','FB-260802-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260802-0003','ANI','JATAN MIRICINDE','','','','kasir','2026-08-02 12:24:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-02' 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-260802-0019','K','2026-08-02','12:24:23','kasir','PEMBELIAN UMUM','FB-260802-0003','6621666000','825000','6620841000');
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-00019811','X-00019811','CC X MODEL MATA CM 8 8K','GR','---','E2E','BELI','BELI001','530000','2026-08-02','0.550','1','kasir','2026-08-02 13:42:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00019811','X-00019811');
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-260802-0004','F326120919031','LIS','1','BELI','BELI001','E2E', 'X-00019811', 'CC X MODEL MATA CM 8 8K','0.550','0.550','100.00','620000','530000','963636','1040000','1','530000','530000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.550',berat_beli_asli=berat_beli_asli+'0.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.550',berat_akhir_asli=berat_akhir_asli+'0.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-02' 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-260802-0004','2026-08-02','2026-08-02','13:42:37','LIS','---','0.550','530000','530000','530000','530000','530000','kasir','2026-08-02 13:42:38','FB-260802-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260802-0004','LIYA','MIRICINDE PWO','','','','kasir','2026-08-02 13:42:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-02' 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-260802-0020','K','2026-08-02','13:42:37','kasir','PEMBELIAN UMUM','FB-260802-0004','6620841000','530000','6620311000');
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-00019812','X-00019812','CC X SOLITAIRE MATA CM 22 8K','GR','---','E2D','BELI','BELI001','1395000','2026-08-02','1.470','1','kasir','2026-08-02 13:42:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019812','X-00019812');
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-260802-0005','F326221055081','FIT','1','BELI','BELI001','E2D', 'X-00019812', 'CC X SOLITAIRE MATA CM 22 8K','1.470','1.470','100.00','1655000','1395000','948980','1020000','1','1395000','1395000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.470',berat_beli_asli=berat_beli_asli+'1.470',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.470',berat_akhir_asli=berat_akhir_asli+'1.470',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-02' 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-260802-0005','2026-08-02','2026-08-02','13:42:53','FIT','---','1.470','1395000','1395000','1395000','1395000','1395000','kasir','2026-08-02 13:42:54','FB-260802-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260802-0005','TYA','BITING JATISARI PWO','','','','kasir','2026-08-02 13:42:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-02' 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-260802-0021','K','2026-08-02','13:42:53','kasir','PEMBELIAN UMUM','FB-260802-0005','6620311000','1395000','6618916000');
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-00019813','X-00019813','CC MODEL AUREL MATA VAR PM 10 8K','GR','---','E2E','BELI','BELI001','365000','2026-08-02','0.550','1','kasir','2026-08-02 13:56:04');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00019813','X-00019813');
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-260802-0006','F324130942431','LIS','1','BELI','BELI001','E2E', 'X-00019813', 'CC MODEL AUREL MATA VAR PM 10 8K','0.550','0.550','100.00','335000','365000','663636','1040000','1','365000','365000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.550',berat_beli_asli=berat_beli_asli+'0.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.550',berat_akhir_asli=berat_akhir_asli+'0.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-02' 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-260802-0006','2026-08-02','2026-08-02','13:56:03','LIS','---','0.550','365000','365000','365000','365000','365000','kasir','2026-08-02 13:56:04','FB-260802-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260802-0006','YULI','SIGERENG','','','','kasir','2026-08-02 13:56:04');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-02' 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-260802-0022','K','2026-08-02','13:56:03','kasir','PEMBELIAN UMUM','FB-260802-0006','6618916000','365000','6618551000');
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 ('F326020212331','input','1',' MEF3E X KH','TOKO','PM-F','F3E-ZFXH-152-0','GL X RANTAI HOLLOW P3 ANAK SLEP KH 8K ','','2.150','1','100.00','2214000','0','0','15000','2215000','0','0','0','2215000','LIS','00408013','F3E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXH-152-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.150',berat_jual_asli=berat_jual_asli+'2.150',stock_jual='1',berat_akhir=berat_akhir-'2.150',berat_akhir_asli=berat_akhir_asli-'2.150',stock_akhir='0' WHERE tanggal='2026-08-02' AND kode_barang='F3E-ZFXH-152-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 ('F326020212331','2026-08-02','2.150','2026-08-02','14:12:34','PLG0030613','2215000','2215000','0','2215000','2215000','input','2026-08-02 14:12:33','F32602021233');
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-08-02','F326020212331','2026-08-02','14:12:34','LIS','2215000','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-260802-0023','D','2026-08-02','14:12:34','input','PENJUALAN','F326020212331','6618551000','2215000','6620766000');
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 ('F326020220461','input','1',' MDE1 X LG ','TOKO','PM-E','E1D-ZGBA-175-0','CC X MODEL SLEP LG 12 8K ','','0.920','1','100.00','929000','0','0','15000','930000','0','0','0','930000','FIT','00414657','E1D','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2026-08-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGBA-175-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.920',berat_jual_asli=berat_jual_asli+'0.920',stock_jual='1',berat_akhir=berat_akhir-'0.920',berat_akhir_asli=berat_akhir_asli-'0.920',stock_akhir='0' WHERE tanggal='2026-08-02' AND kode_barang='E1D-ZGBA-175-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 ('F326020220461','2026-08-02','0.920','2026-08-02','14:20:46','PLG0030614','930000','930000','0','930000','930000','input','2026-08-02 14:20:46','F32602022046');
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-08-02','F326020220461','2026-08-02','14:20:46','FIT','930000','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-260802-0024','D','2026-08-02','14:20:46','input','PENJUALAN','F326020220461','6620766000','930000','6621696000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='930000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326020220461' 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 ('F326020220462','input',' 1',' MEH1 UB 42','TOKO','PM-H','H1E-ZGBH-117-0','KL MILANO UB 42 8K ','','2.100','1','100.00','2163000','0','0','15000','2163000','0','0','0','2163000','FIT','00415733','H1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGBH-117-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-08-02' AND kode_barang='H1E-ZGBH-117-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 ('F326020220462','2026-08-02','2.100','2026-08-02','14:20:46','PLG0030615','2163000','2163000','0','2163000','2163000','input','2026-08-02 14:20:46','F32602022046');
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-08-02','F326020220462','2026-08-02','14:20:46','FIT','2163000','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-260802-0025','D','2026-08-02','14:20:46','input','PENJUALAN','F326020220462','6621696000','2163000','6623859000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2163000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326020220462' 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 ('F326020231311','input','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZGBA-172-0','CC X MODEL SLEP CM 18 8K ','','1.300','1','100.00','1313000','0','0','15000','1313000','0','0','0','1313000','AAT','00414654','E1D','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2026-08-02', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGBA-172-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-08-02' AND kode_barang='E1D-ZGBA-172-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 ('F326020231311','2026-08-02','1.300','2026-08-02','14:31:32','PLG0030616','1313000','1313000','0','1313000','1313000','input','2026-08-02 14:31:31','F32602023131');
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-08-02','F326020231311','2026-08-02','14:31:32','AAT','1313000','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-260802-0026','D','2026-08-02','14:31:32','input','PENJUALAN','F326020231311','6623859000','1313000','6625172000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260802-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260802-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260802-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260802-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260802-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260802-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260802-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260802-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260802-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260802-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260802-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260802-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326020212331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326020212331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326020212331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326020220461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326020220461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326020220461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326020220462' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326020220462' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326020220462';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326020231311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326020231311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326020231311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326020833191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326020833191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326020833191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326020833591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326020833591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326020833591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326020853511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326020853511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326020853511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326020926531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326020926531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326020926531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326020948111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326020948111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326020948111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326020949561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326020949561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326020949561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326021008131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326021008131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326021008131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326021017431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326021017431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326021017431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326021017432' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326021017432' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326021017432';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326021028591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326021028591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326021028591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326021127061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326021127061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326021127061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326021147241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326021147241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326021147241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326021215361' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326021215361' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326021215361';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-03','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-03';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-02';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-02';
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-08-02' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-02';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-02';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-02';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-02';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202607 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
UPDATE tt_barang_saldo SET tanggal= '2026-08-03' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-02' 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-260803-0001','D','2026-08-03','15:06:14','SYSTEM','SALDO AWAL','SALDO AWAL','0','6625172000','6625172000');
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-260803-0001','D','2026-08-03','15:06:14','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-260803-0001','D','2026-08-03','15:06:14','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-260803-0001','D','2026-08-03','15:06:14','BCA','SALDO AWAL','SALDO AWAL','0','738685000','738685000');
UPDATE tp_system SET tgl_system='2026-08-03';