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 ('F326090802031','input','1',' MFE1 LG 10','TOKO','PM-E','E1F-ZGXA-341-0','CC MODEL ISYANA SLEP LG 10 8K ','','0.400','1','100.00','442000','0','0','15000','443000','0','0','0','443000','SIN','00411865','E1F','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGXA-341-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-08-09' AND kode_barang='E1F-ZGXA-341-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 ('F326090802031','2026-08-09','0.400','2026-08-09','08:02:03','PLG0030691','443000','443000','0','443000','443000','input','2026-08-09 08:02:03','F32609080203');
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-09','F326090802031','2026-08-09','08:02:03','SIN','443000','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-260809-0002','D','2026-08-09','08:02:03','input','PENJUALAN','F326090802031','6717062000','443000','6717505000');
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 ('F326090836591','input','1',' MEF1 XXX P','TOKO','PM-F','F1E-ZABC-95-0','GL XXX BANGKOK HOLLOW LASER PM 58 8K ','','6.010','1','100.00','6521000','0','0','15000','6340000','0','0','0','6340000','LIS','00386725','F1E','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZABC-95-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.010',berat_jual_asli=berat_jual_asli+'6.010',stock_jual='1',berat_akhir=berat_akhir-'6.010',berat_akhir_asli=berat_akhir_asli-'6.010',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='F1E-ZABC-95-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 ('F326090836591','2026-08-09','6.010','2026-08-09','08:37:00','PLG0030692','6340000','6340000','0','6340000','6340000','input','2026-08-09 08:36:59','F32609083659');
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-09','F326090836591','2026-08-09','08:37:00','LIS','6340000','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-260809-0003','D','2026-08-09','08:37:00','input','PENJUALAN','F326090836591','6717505000','6340000','6723845000');
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 ('F326090855011','input','1',' MEF1 X PM ','TOKO','PM-F','F1E-YKXA-194-0','GL X BANGKOK KACA ANAK PM 40 8K ','','1.570','1','100.00','1703000','0','0','15000','1703000','0','0','0','1703000','LIS','00375765','F1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YKXA-194-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.570',berat_jual_asli=berat_jual_asli+'1.570',stock_jual='1',berat_akhir=berat_akhir-'1.570',berat_akhir_asli=berat_akhir_asli-'1.570',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='F1E-YKXA-194-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 ('F326090855011','2026-08-09','1.570','2026-08-09','08:55:02','PLG0030693','1703000','1703000','0','1703000','1703000','input','2026-08-09 08:55:01','F32609085501');
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-09','F326090855011','2026-08-09','08:55:02','LIS','1703000','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-260809-0004','D','2026-08-09','08:55:02','input','PENJUALAN','F326090855011','6723845000','1703000','6725548000');
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 ('F326090918121','input','1',' MEF1E TD 4','TOKO','PM-F','F1E-ZGAA-78-0','GL BANGKOK ANAK C SLEP TD 42 8K ','','1.980','1','100.00','2148000','0','0','15000','2148000','0','0','0','2148000','SIN','00413257','F1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGAA-78-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='F1E-ZGAA-78-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 ('F326090918121','2026-08-09','1.980','2026-08-09','09:18:12','PLG0030694','2148000','2148000','0','2148000','2148000','input','2026-08-09 09:18:12','F32609091812');
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-09','F326090918121','2026-08-09','09:18:12','SIN','2148000','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-260809-0005','D','2026-08-09','09:18:12','input','PENJUALAN','F326090918121','6725548000','2148000','6727696000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2148000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326090918121' 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 ('F326090918122','input',' 1',' MEE1 LG 20','TOKO','PM-E','E1E-ZFXA-128-0','CC BANGKOK SLEP LG 20 8K ','','0.550','1','100.00','597000','0','0','15000','597000','0','0','0','597000','SIN','00406296','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFXA-128-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-08-09' AND kode_barang='E1E-ZFXA-128-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 ('F326090918122','2026-08-09','0.550','2026-08-09','09:18:12','PLG0030695','597000','597000','0','597000','597000','input','2026-08-09 09:18:12','F32609091812');
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-09','F326090918122','2026-08-09','09:18:12','SIN','597000','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-260809-0006','D','2026-08-09','09:18:12','input','PENJUALAN','F326090918122','6727696000','597000','6728293000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='597000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326090918122' 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 ('F326090929441','input','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZGXG-73-0','CC XMODEL MATA CM 10 8K ','','1.050','1','100.00','1118000','0','0','15000','1118000','0','0','0','1118000','FIT','00412474','E2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGXG-73-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='E2D-ZGXG-73-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 ('F326090929441','2026-08-09','1.050','2026-08-09','09:29:44','PLG0030696','1118000','1118000','0','1118000','1118000','input','2026-08-09 09:29:44','F32609092944');
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-09','F326090929441','2026-08-09','09:29:44','FIT','1118000','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-260809-0007','D','2026-08-09','09:29:44','input','PENJUALAN','F326090929441','6728293000','1118000','6729411000');
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 ('F326090932481','input','1',' MEE1 KH 14','TOKO','PM-E','E1E-ZHXF-337-0','CC MODEL SPIRAL ARESO SLEP KH 14 8K ','','0.450','1','100.00','488000','0','0','15000','488000','0','0','0','488000','LIS','00417395','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHXF-337-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='E1E-ZHXF-337-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 ('F326090932481','2026-08-09','0.450','2026-08-09','09:32:48','PLG0030697','488000','488000','0','488000','488000','input','2026-08-09 09:32:48','F32609093248');
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-09','F326090932481','2026-08-09','09:32:48','LIS','488000','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-260809-0008','D','2026-08-09','09:32:48','input','PENJUALAN','F326090932481','6729411000','488000','6729899000');
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 ('F326090943191','input','1',' TFH1 X HW ','TOKO','PT-H','H1TF-WFAF-87-T','KL X KOREA HW 42CM ','','5.120','1','100.00','10291000','0','0','15000','10290000','0','0','0','10290000','SIN','T0045290','H1TF','0','0','-','1','2010000');
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 ('F326090945061','input','1',' MDD2D X UB','TOKO','PM-D','D2D-ZFAH-30-0','LT X MODEL MATA UB 8K ','','1.150','1','100.00','1225000','0','0','15000','1225000','0','0','0','1225000','SIN','00409037','D2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZFAH-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='D2D-ZFAH-30-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 ('F326090945061','2026-08-09','1.150','2026-08-09','09:45:06','PLG0030699','1225000','1225000','0','1225000','1225000','input','2026-08-09 09:45:06','F32609094506');
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-09','F326090945061','2026-08-09','09:45:06','SIN','1225000','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-260809-0009','D','2026-08-09','09:45:06','input','PENJUALAN','F326090945061','6729899000','1225000','6731124000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1225000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326090945061' 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 ('F326090945062','input',' 1',' TFH1 X HW ','TOKO','PT-H','H1TF-WFAF-87-T','KL X KOREA HW 42CM ','','5.120','1','100.00','10291000','0','0','15000','10290000','0','0','0','10290000','SIN','T0045290','H1TF','0','0','-','1','2010000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TF-WFAF-87-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.120',berat_jual_asli=berat_jual_asli+'5.120',stock_jual='1',berat_akhir=berat_akhir-'5.120',berat_akhir_asli=berat_akhir_asli-'5.120',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='H1TF-WFAF-87-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 ('F326090945062','2026-08-09','5.120','2026-08-09','09:45:06','PLG0030700','10290000','10290000','0','10290000','10290000','input','2026-08-09 09:45:06','F32609094506');
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-09','F326090945062','2026-08-09','09:45:06','SIN','10290000','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-260809-0010','D','2026-08-09','09:45:06','input','PENJUALAN','F326090945062','6731124000','10290000','6741414000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='10290000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326090945062' 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 ('F326090950051','input','1',' MDE2 X UB ','TOKO','PM-E','E2D-ZAXI-348-0','CC X MODEL MATA UB 12 8K ','','0.910','1','100.00','969000','0','0','15000','970000','0','0','0','970000','AAT','00384725','E2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZAXI-348-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='E2D-ZAXI-348-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 ('F326090950051','2026-08-09','0.910','2026-08-09','09:50:06','PLG0030701','970000','970000','0','970000','970000','input','2026-08-09 09:50:05','F32609095005');
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-09','F326090950051','2026-08-09','09:50:06','AAT','970000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260809-0011','D','2026-08-09','09:50:06','input','PENJUALAN','F326090950051','6741414000','970000','6742384000');
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 ('F326090952471','input','1',' TEH1 X HW ','TOKO','PT-H','H1TE-ZCBC-47-T','KL X KOREA PANJANG HW 64CM 17K ','','10.010','1','100.00','19920000','0','0','15000','19920000','0','0','0','19920000','FIT','T0078282','H1TE','0','0','-','0','1990000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZCBC-47-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'10.010',berat_jual_asli=berat_jual_asli+'10.010',stock_jual='1',berat_akhir=berat_akhir-'10.010',berat_akhir_asli=berat_akhir_asli-'10.010',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='H1TE-ZCBC-47-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 ('F326090952471','2026-08-09','10.010','2026-08-09','09:52:47','PLG0030702','19920000','19920000','0','19920000','19920000','input','2026-08-09 09:52:47','F32609095247');
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-09','F326090952471','2026-08-09','09:52:47','FIT','19920000','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-260809-0012','D','2026-08-09','09:52:47','input','PENJUALAN','F326090952471','6742384000','19920000','6762304000');
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 ('F326090955221','input','1',' MEF1 15K U','TOKO','PM-F','F1E-YJBE-20-0','GL SHOGUN SLEP UB 56 8K ','','4.150','1','100.00','4503000','0','0','15000','4503000','0','15000','0','4518000','SIN','00374697','F1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YJBE-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.150',berat_jual_asli=berat_jual_asli+'4.150',stock_jual='1',berat_akhir=berat_akhir-'4.150',berat_akhir_asli=berat_akhir_asli-'4.150',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='F1E-YJBE-20-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 ('F326090955221','2026-08-09','4.150','2026-08-09','09:55:22','PLG0030703','4503000','4503000','15000','4518000','4518000','input','2026-08-09 09:55:22','F32609095522');
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-09','F326090955221','2026-08-09','09:55:22','SIN','4518000','15000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260809-0013','D','2026-08-09','09:55:22','input','PENJUALAN','F326090955221','6762304000','4518000','6766822000');
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 ('F326090956211','input','1',' MDE2 X LG ','TOKO','PM-E','E2D-ZFXC-117-0','CC X EROPA MATA BIRU LG 8K ','','1.020','1','100.00','1086000','0','0','15000','1085000','0','5000','0','1090000','SIN','00406660','E2D','0','0','-','1','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFXC-117-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='E2D-ZFXC-117-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 ('F326090956211','2026-08-09','1.020','2026-08-09','09:56:22','PLG0030704','1085000','1085000','5000','1090000','1090000','input','2026-08-09 09:56:21','F32609095621');
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-09','F326090956211','2026-08-09','09:56:22','SIN','1090000','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-260809-0014','D','2026-08-09','09:56:22','input','PENJUALAN','F326090956211','6766822000','1090000','6767912000');
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 ('F326091016541','kasir','1',' MEF3E X UB','TOKO','PM-F','F3E-ZGCA-118-0','GL X CASTELI SLEP UB 8K ','','2.960','1','100.00','3212000','0','0','15000','3212000','0','0','0','3212000','FIT','00416204','F3E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGCA-118-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-09' AND kode_barang='F3E-ZGCA-118-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 ('F326091016541','2026-08-09','2.960','2026-08-09','10:16:54','PLG0030705','3212000','3212000','0','3212000','3212000','kasir','2026-08-09 10:16:54','F32609101654');
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-09','F326091016541','2026-08-09','10:16:54','FIT','3212000','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-260809-0015','D','2026-08-09','10:16:54','kasir','PENJUALAN','F326091016541','6767912000','3212000','6771124000');
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 ('F326091023541','kasir','1',' MDE1 HT 12','TOKO','PM-E','E1D-ZHXF-331-0','CC MODEL PAKU SLEP HT 12 8K ','','0.920','1','100.00','980000','0','0','15000','980000','0','0','0','980000','SIN','00417389','E1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZHXF-331-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-09' AND kode_barang='E1D-ZHXF-331-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 ('F326091023541','2026-08-09','0.920','2026-08-09','10:23:55','PLG0030706','980000','980000','0','980000','980000','kasir','2026-08-09 10:23:54','F32609102354');
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-09','F326091023541','2026-08-09','10:23:55','SIN','980000','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-260809-0016','D','2026-08-09','10:23:55','kasir','PENJUALAN','F326091023541','6771124000','980000','6772104000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='980000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326091023541' 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 ('F326091023542','kasir',' 1',' MEE1 KH 14','TOKO','PM-E','E1E-ZHXF-336-0','CC MODEL SPIRAL ARESO SLEP KH 14 8K ','','0.460','1','100.00','499000','0','0','15000','500000','0','0','0','500000','SIN','00417394','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHXF-336-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='E1E-ZHXF-336-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 ('F326091023542','2026-08-09','0.460','2026-08-09','10:23:55','PLG0030707','500000','500000','0','500000','500000','kasir','2026-08-09 10:23:54','F32609102354');
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-09','F326091023542','2026-08-09','10:23:55','SIN','500000','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-260809-0017','D','2026-08-09','10:23:55','kasir','PENJUALAN','F326091023542','6772104000','500000','6772604000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='500000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326091023542' 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 ('F326091031531','kasir','1',' MEE1 X UB ','TOKO','PM-E','E1E-ZDBX-318-0','CC X MODEL SLEP UB 14 8K ','','0.680','1','100.00','738000','0','0','15000','738000','0','0','0','738000','SIN','00400255','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBX-318-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.680',berat_jual_asli=berat_jual_asli+'0.680',stock_jual='1',berat_akhir=berat_akhir-'0.680',berat_akhir_asli=berat_akhir_asli-'0.680',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='E1E-ZDBX-318-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 ('F326091031531','2026-08-09','0.680','2026-08-09','10:31:54','PLG0030708','738000','738000','0','738000','738000','kasir','2026-08-09 10:31:53','F32609103153');
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-09','F326091031531','2026-08-09','10:31:54','SIN','738000','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-260809-0018','D','2026-08-09','10:31:54','kasir','PENJUALAN','F326091031531','6772604000','738000','6773342000');
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 ('F326091100121','kasir','1',' MEF3E HW ','TOKO','PM-F','F3E-ZFXE-190-0','GL CASTELI VAR SLEP HW 8K ','','1.600','1','100.00','1736000','0','0','15000','1720000','0','0','0','1720000','LIS','00407442','F3E','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXE-190-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.600',berat_jual_asli=berat_jual_asli+'1.600',stock_jual='1',berat_akhir=berat_akhir-'1.600',berat_akhir_asli=berat_akhir_asli-'1.600',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='F3E-ZFXE-190-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 ('F326091100121','2026-08-09','1.600','2026-08-09','11:00:12','PLG0030709','1720000','1720000','0','1720000','1720000','kasir','2026-08-09 11:00:12','F32609110012');
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-09','F326091100121','2026-08-09','11:00:12','LIS','1720000','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-260809-0019','D','2026-08-09','11:00:12','kasir','PENJUALAN','F326091100121','6773342000','1720000','6775062000');
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 ('F326091104391','kasir','1',' MEE1E HT 1','TOKO','PM-E','E1E-ZFAI-86-0','CC MODEL BANGKOK SLEP HT 18 8K ','','0.520','1','100.00','564000','0','0','15000','565000','0','0','0','565000','AAT','00409391','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFAI-86-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='E1E-ZFAI-86-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 ('F326091104391','2026-08-09','0.520','2026-08-09','11:04:40','PLG0030710','565000','565000','0','565000','565000','kasir','2026-08-09 11:04:39','F32609110439');
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-09','F326091104391','2026-08-09','11:04:40','AAT','565000','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-260809-0020','D','2026-08-09','11:04:40','kasir','PENJUALAN','F326091104391','6775062000','565000','6775627000');
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 ('F326090104391','kasir','1',' TEE1 LG 21','TOKO','PT-E','E1TE-ZGAG-59-T','CC BANGKOK SLEP LG 21 17K ','','0.530','1','100.00','1055000','0','0','15000','1050000','0','0','0','1050000','LIS','T0081282','E1TE','0','0','-','1','1990000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-ZGAG-59-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='E1TE-ZGAG-59-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326090104391','2026-08-09','0.530','2026-08-09','13:04:40','PLG0030711','1050000','1050000','0','1050000','1050000','kasir','2026-08-09 13:04:39','F32609010439');
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-09','F326090104391','2026-08-09','13:04:40','LIS','1050000','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-260809-0021','D','2026-08-09','13:04:40','kasir','PENJUALAN','F326090104391','6775627000','1050000','6776677000');
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-00019855','X-00019855','CC X KUKU MACAN HA 16 8K','GR','---','E1E','BELI','BELI001','525000','2026-08-09','0.520','1','kasir','2026-08-09 13:14:55');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019855','X-00019855');
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-260809-0001','F326061048361','SIN','1','BELI','BELI001','E1E', 'X-00019855', 'CC X KUKU MACAN HA 16 8K','0.520','0.520','100.00','565000','525000','1009615','1095000','1','525000','525000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.520',berat_beli_asli=berat_beli_asli+'0.520',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.520',berat_akhir_asli=berat_akhir_asli+'0.520',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-09' 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-260809-0001','2026-08-09','2026-08-09','13:14:54','SIN','---','0.520','525000','525000','525000','525000','525000','kasir','2026-08-09 13:14:55','FB-260809-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260809-0001','NURUL KHALIFAH','TANJUNG BULUKERTO','','','','kasir','2026-08-09 13:14:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-09' 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-260809-0022','K','2026-08-09','13:14:54','kasir','PEMBELIAN UMUM','FB-260809-0001','6776677000','525000','6776152000');
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-00019856','X-00019856','GL MODEL FLIK VAR LT 8K','GR','---','F3E','BELI','BELI001','1180000','2026-08-09','1.530','1','kasir','2026-08-09 13:15:17');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019856','X-00019856');
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-260809-0002','F325110836011','LIS','1','BELI','BELI001','F3E', 'X-00019856', 'GL MODEL FLIK VAR LT 8K','1.530','1.530','100.00','1265000','1180000','771242','1095000','1','1180000','1180000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.530',berat_beli_asli=berat_beli_asli+'1.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.530',berat_akhir_asli=berat_akhir_asli+'1.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-09' 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-260809-0002','2026-08-09','2026-08-09','13:15:16','LIS','---','1.530','1180000','1180000','1180000','1180000','1180000','kasir','2026-08-09 13:15:17','FB-260809-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260809-0002','TINI','JERUK','','','','kasir','2026-08-09 13:15:17');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-09' 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-260809-0023','K','2026-08-09','13:15:16','kasir','PEMBELIAN UMUM','FB-260809-0002','6776152000','1180000','6774972000');
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-00019857','X-00019857','CC X WEDDING MATA CM 19 8K','GR','---','E2D','BELI','BELI001','1155000','2026-08-09','1.580','1','kasir','2026-08-09 13:15:53');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019857','X-00019857');
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-260809-0003','F324251149532','LIS','1','BELI','BELI001','E2D', 'X-00019857', 'CC X WEDDING MATA CM 19 8K','1.600','1.580','100.00','981000','1155000','731013','1075000','1','1155000','1155000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.580',berat_beli_asli=berat_beli_asli+'1.580',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.580',berat_akhir_asli=berat_akhir_asli+'1.580',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-09' 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-260809-0003','2026-08-09','2026-08-09','13:15:53','LIS','---','1.580','1155000','1155000','1155000','1155000','1155000','kasir','2026-08-09 13:15:53','FB-260809-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260809-0003','MELA','NAWANGAN','','','','kasir','2026-08-09 13:15:53');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-09' 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-260809-0024','K','2026-08-09','13:15:53','kasir','PEMBELIAN UMUM','FB-260809-0003','6774972000','1155000','6773817000');
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-00019858','X-00019858','CC X WEDDING POLOS CM 18 8K','GR','---','E1D','BELI','BELI001','1020000','2026-08-09','1.020','1','kasir','2026-08-09 13:16:07');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019858','X-00019858');
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-260809-0004','F326120120142','AAT','1','BELI','BELI001','E1D', 'X-00019858', 'CC X WEDDING POLOS CM 18 8K','1.020','1.020','100.00','1255000','1020000','1000000','1075000','1','1020000','1020000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.020',berat_beli_asli=berat_beli_asli+'1.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.020',berat_akhir_asli=berat_akhir_asli+'1.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-09' 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-260809-0004','2026-08-09','2026-08-09','13:16:07','AAT','---','1.020','1020000','1020000','1020000','1020000','1020000','kasir','2026-08-09 13:16:07','FB-260809-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260809-0004','SAFII','SENAYU BITING','','','','kasir','2026-08-09 13:16:07');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-09' 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-260809-0025','K','2026-08-09','13:16:07','kasir','PEMBELIAN UMUM','FB-260809-0004','6773817000','1020000','6772797000');
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 ('F326090119141','kasir','1',' MFE1 KH 10','TOKO','PM-E','E1F-ZGBA-302-0','CC COR MODEL SPECTRA SLEP 10 KH 8K ','','0.340','1','100.00','376000','0','0','15000','375000','0','0','0','375000','LIS','00414784','E1F','0','0','-','1','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBA-302-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.340',berat_jual_asli=berat_jual_asli+'0.340',stock_jual='1',berat_akhir=berat_akhir-'0.340',berat_akhir_asli=berat_akhir_asli-'0.340',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='E1F-ZGBA-302-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 ('F326090119141','2026-08-09','0.340','2026-08-09','13:19:14','PLG0030712','375000','375000','0','375000','375000','kasir','2026-08-09 13:19:14','F32609011914');
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-09','F326090119141','2026-08-09','13:19:14','LIS','375000','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-260809-0026','D','2026-08-09','13:19:14','kasir','PENJUALAN','F326090119141','6772797000','375000','6773172000');
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-00019859','X-00019859','AT X GYPSY ANAK SLEP LG 8K','GR','---','A1E','BELI','BELI001','500000','2026-08-09','0.510','1','kasir','2026-08-09 13:45:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00019859','X-00019859');
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-260809-0005','F325151228471','AAT','1','BELI','BELI001','A1E', 'X-00019859', 'AT X GYPSY ANAK SLEP LG 8K','0.510','0.510','100.00','538000','500000','980392','1095000','1','500000','500000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-09' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' 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-260809-0005','2026-08-09','2026-08-09','13:45:37','AAT','---','0.510','500000','500000','500000','500000','500000','kasir','2026-08-09 13:45:38','FB-260809-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260809-0005','BUNGA','JERUK BANDAR','','','081228790546','kasir','2026-08-09 13:45:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-09' 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-260809-0027','K','2026-08-09','13:45:37','kasir','PEMBELIAN UMUM','FB-260809-0005','6773172000','500000','6772672000');
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-00019860','X-00019860','GL OVAL C SLEP UB 56 8K','GR','---','F1E','BELI','BELI001','1972000','2026-08-09','2.240','1','kasir','2026-08-09 13:46:26');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00019860','X-00019860');
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-260809-0006','F326211236321','AAT','1','BELI','BELI001','F1E', 'X-00019860', 'GL OVAL C SLEP UB 56 8K','2.240','2.240','100.00','2320000','1972000','880357','1095000','1','1972000','1972000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.240',berat_beli_asli=berat_beli_asli+'2.240',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.240',berat_akhir_asli=berat_akhir_asli+'2.240',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-09' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260809-0006','2026-08-09','2026-08-09','13:46:26','AAT','---','2.240','1972000','1972000','1972000','1972000','1972000','kasir','2026-08-09 13:46:26','FB-260809-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260809-0006','TIKA','TENGGAR BULUKERTO','','','','kasir','2026-08-09 13:46:26');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-09' 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-260809-0028','K','2026-08-09','13:46:26','kasir','PEMBELIAN UMUM','FB-260809-0006','6772672000','1972000','6770700000');
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-00019861','X-00019861','LT SLOBOK RIBBON SLEP LG 8K','GR','---','D1G','BELI','BELI001','305000','2026-08-09','0.320','1','kasir','2026-08-09 13:48:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1G','X-00019861','X-00019861');
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-260809-0007','F325161032501','SIN','1','BELI','BELI001','D1G', 'X-00019861', 'LT SLOBOK RIBBON SLEP LG 8K','0.320','0.320','100.00','340000','305000','953125','1125000','1','305000','305000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.320',berat_beli_asli=berat_beli_asli+'0.320',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.320',berat_akhir_asli=berat_akhir_asli+'0.320',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-09' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1G' 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-260809-0007','2026-08-09','2026-08-09','13:48:49','SIN','---','0.320','305000','305000','305000','305000','305000','kasir','2026-08-09 13:48:50','FB-260809-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260809-0007','JUMATIN','BADEGAN WATU BONANG','','','088226947024','kasir','2026-08-09 13:48:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-09' 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-260809-0029','K','2026-08-09','13:48:49','kasir','PEMBELIAN UMUM','FB-260809-0007','6770700000','305000','6770395000');
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-00019862','X-00019862','CC X MODEL MATA ROSE NJ 16 8K','GR','---','E2D','BELI','BELI001','895000','2026-08-09','1.160','1','kasir','2026-08-09 13:48:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019862','X-00019862');
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-260809-0008','F325030931492','SIN','2','BELI','BELI001','E2D', 'X-00019862', 'CC X MODEL MATA ROSE NJ 16 8K','1.160','1.160','100.00','953000','895000','771552','1075000','1','895000','895000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.160',berat_beli_asli=berat_beli_asli+'1.160',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.160',berat_akhir_asli=berat_akhir_asli+'1.160',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-09' 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-260809-0008','2026-08-09','2026-08-09','13:48:49','SIN','---','1.160','895000','895000','895000','895000','895000','kasir','2026-08-09 13:48:50','FB-260809-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260809-0008','JUMADIN','WATU BONANG','','','','kasir','2026-08-09 13:48:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-09' 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-260809-0030','K','2026-08-09','13:48:49','kasir','PEMBELIAN UMUM','FB-260809-0008','6770395000','895000','6769500000');
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-00019863','X-00019863','KL X GUCCI UB 42 9K','GR','---','H2J','BELI','BELI001','2122000','2026-08-09','2.050','1','kasir','2026-08-09 13:48:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00019863','X-00019863');
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-260809-0009','F325161036061','SIN','3','BELI','BELI001','H2J', 'X-00019863', 'KL X GUCCI UB 42 9K','2.050','2.050','100.00','2305000','2122000','1035122','1185000','1','2122000','2122000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.050',berat_beli_asli=berat_beli_asli+'2.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.050',berat_akhir_asli=berat_akhir_asli+'2.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-09' 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-260809-0009','2026-08-09','2026-08-09','13:48:49','SIN','---','2.050','2122000','2122000','2122000','2122000','2122000','kasir','2026-08-09 13:48:50','FB-260809-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260809-0009','JUMATIN','BADEGAN WATU BONANG','','','','kasir','2026-08-09 13:48:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-09' 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-260809-0031','K','2026-08-09','13:48:49','kasir','PEMBELIAN UMUM','FB-260809-0009','6769500000','2122000','6767378000');
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 ('F326090228321','kasir','1',' MEA1 5K LG','TOKO','PM-A','A1E-ZDBD-122-0','AT BONEKA ANAK CAT MATA VAR LG 8K ','','0.510','1','100.00','553000','0','0','15000','554000','0','5000','0','559000','AAT','00401093','A1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZDBD-122-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='A1E-ZDBD-122-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 ('F326090228321','2026-08-09','0.510','2026-08-09','14:28:33','PLG0030713','554000','554000','5000','559000','559000','kasir','2026-08-09 14:28:32','F32609022832');
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-09','F326090228321','2026-08-09','14:28:33','AAT','559000','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-260809-0032','D','2026-08-09','14:28:33','kasir','PENJUALAN','F326090228321','6767378000','559000','6767937000');
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 ('F326090237241','input','1',' MFE2F KH 1','TOKO','PM-E','E2F-ZGBD-154-0','CC MODEL PAKU MAT SLEP KH 10 8K ','','0.380','1','100.00','420000','0','0','15000','420000','0','0','0','420000','AAT','00415531','E2F','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZGBD-154-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='E2F-ZGBD-154-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 ('F326090237241','2026-08-09','0.380','2026-08-09','14:37:24','PLG0030714','420000','420000','0','420000','420000','input','2026-08-09 14:37:24','F32609023724');
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-09','F326090237241','2026-08-09','14:37:24','AAT','420000','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-260809-0033','D','2026-08-09','14:37:24','input','PENJUALAN','F326090237241','6767937000','420000','6768357000');
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 ('F326090242211','input','1',' MEF1 X TD ','TOKO','PM-F','F1E-ZDXD-5-0','GL X OVAL C SLEP TD 52 8K ','','4.610','1','100.00','5002000','0','0','15000','5002000','0','0','0','5002000','SIN','00397705','F1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZDXD-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.610',berat_jual_asli=berat_jual_asli+'4.610',stock_jual='1',berat_akhir=berat_akhir-'4.610',berat_akhir_asli=berat_akhir_asli-'4.610',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='F1E-ZDXD-5-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 ('F326090242211','2026-08-09','4.610','2026-08-09','14:42:22','PLG0030715','5002000','5002000','0','5002000','5002000','input','2026-08-09 14:42:21','F32609024221');
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-09','F326090242211','2026-08-09','14:42:22','SIN','5002000','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-260809-0034','D','2026-08-09','14:42:22','input','PENJUALAN','F326090242211','6768357000','5002000','6773359000');
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 ('F326090247561','input','1',' TDE1 X CM ','TOKO','PT-E','E1TD-YLBF-66-T','CC X VELG KACA CM 14 17K ','','1.480','1','100.00','2916000','0','0','15000','2915000','0','0','0','2915000','LIS','T0076236','E1TD','0','0','-','1','1970000');
UPDATE tm_barang SET tgl_last_jual='2026-08-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YLBF-66-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.480',berat_jual_asli=berat_jual_asli+'1.480',stock_jual='1',berat_akhir=berat_akhir-'1.480',berat_akhir_asli=berat_akhir_asli-'1.480',stock_akhir='0' WHERE tanggal='2026-08-09' AND kode_barang='E1TD-YLBF-66-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326090247561','2026-08-09','1.480','2026-08-09','14:47:57','PLG0030716','2915000','2915000','0','2915000','2915000','input','2026-08-09 14:47:56','F32609024756');
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-09','F326090247561','2026-08-09','14:47:57','LIS','2915000','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-260809-0035','D','2026-08-09','14:47:57','input','PENJUALAN','F326090247561','6773359000','2915000','6776274000');
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-00019864','X-00019864','AT GYPSY ANAK SLEP LG 8K','GR','---','A1E','BELI','BELI001','357000','2026-08-09','0.500','1','kasir','2026-08-09 14:53:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00019864','X-00019864');
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-260809-0010','F324300105261','AAT','1','BELI','BELI001','A1E', 'X-00019864', 'AT GYPSY ANAK SLEP LG 8K','0.500','0.500','100.00','335000','357000','714000','1095000','1','357000','357000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-09' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' 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-260809-0010','2026-08-09','2026-08-09','14:53:14','AAT','---','0.500','357000','357000','357000','357000','357000','kasir','2026-08-09 14:53:14','FB-260809-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260809-0010','KAIRA','KEPUH PLOSO PURWANTORO','','','','kasir','2026-08-09 14:53:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-09' 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-260809-0036','K','2026-08-09','14:53:14','kasir','PEMBELIAN UMUM','FB-260809-0010','6776274000','357000','6775917000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090104391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090104391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090104391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090119141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090119141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090119141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090228321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090228321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090228321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090237241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090237241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090237241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090242211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090242211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090242211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090247561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090247561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090247561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090802031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090802031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090802031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090836591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090836591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090836591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090855011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090855011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090855011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090918121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090918121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090918121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090918122' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090918122' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090918122';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090929441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090929441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090929441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090932481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090932481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090932481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090945061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090945061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090945061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090945062' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090945062' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090945062';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090950051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090950051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090950051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090952471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090952471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090952471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090955221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090955221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090955221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090956211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090956211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090956211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326091016541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326091016541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326091016541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326091023541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326091023541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326091023541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326091023542' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326091023542' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326091023542';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326091031531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326091031531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326091031531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326091100121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326091100121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326091100121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326091104391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326091104391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326091104391';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260809-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260809-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260809-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260809-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260809-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260809-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260809-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260809-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260809-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260809-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260809-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260809-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260809-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260809-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260809-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260809-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260809-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260809-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260809-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260809-0010';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-10','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-10';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-09';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-09';
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-09' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-09';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-09';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-09';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-09';
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-10' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-09' 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-260810-0001','D','2026-08-10','15:19:23','SYSTEM','SALDO AWAL','SALDO AWAL','0','6775917000','6775917000');
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-260810-0001','D','2026-08-10','15:19:23','BCA','SALDO AWAL','SALDO AWAL','0','738685000','738685000');
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-260810-0001','D','2026-08-10','15:19:23','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-260810-0001','D','2026-08-10','15:19:23','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-08-10';