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 ('F326030758451','input','1',' MDE2 CM 13','TOKO','PM-E','E2D-ZFAF-5-0','CC WEDDING MATA CM 13 8K ','','1.050','1','100.00','1060000','0','0','15000','1060000','0','0','0','1060000','FIT','00408754','E2D','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFAF-5-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-03' AND kode_barang='E2D-ZFAF-5-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 ('F326030758451','2026-08-03','1.050','2026-08-03','07:58:46','PLG0030617','1060000','1060000','0','1060000','1060000','input','2026-08-03 07:58:45','F32603075845');
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-03','F326030758451','2026-08-03','07:58:46','FIT','1060000','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-260803-0002','D','2026-08-03','07:58:46','input','PENJUALAN','F326030758451','6625172000','1060000','6626232000');
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 ('F326030827461','input','1',' MEF3E HW ','TOKO','PM-F','F3E-ZGXF-5-0','GL RANTAI HOLLOW DAUN SLEP HW 8K ','','1.740','1','100.00','1792000','0','0','15000','1793000','0','0','0','1793000','SIN','00412386','F3E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGXF-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.740',berat_jual_asli=berat_jual_asli+'1.740',stock_jual='1',berat_akhir=berat_akhir-'1.740',berat_akhir_asli=berat_akhir_asli-'1.740',stock_akhir='0' WHERE tanggal='2026-08-03' AND kode_barang='F3E-ZGXF-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 ('F326030827461','2026-08-03','1.740','2026-08-03','08:27:47','PLG0030618','1793000','1793000','0','1793000','1793000','input','2026-08-03 08:27:46','F32603082746');
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-03','F326030827461','2026-08-03','08:27:47','SIN','1793000','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-260803-0003','D','2026-08-03','08:27:47','input','PENJUALAN','F326030827461','6626232000','1793000','6628025000');
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 ('F326030940291','kasir','1',' MEF1 X TD ','TOKO','PM-F','F1E-ZFAG-45-0','GL X OVAL C SLEP TD 56 8K ','','3.120','1','100.00','3214000','0','0','15000','3215000','0','0','0','3215000','AAT','00408868','F1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFAG-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.120',berat_jual_asli=berat_jual_asli+'3.120',stock_jual='1',berat_akhir=berat_akhir-'3.120',berat_akhir_asli=berat_akhir_asli-'3.120',stock_akhir='0' WHERE tanggal='2026-08-03' AND kode_barang='F1E-ZFAG-45-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 ('F326030940291','2026-08-03','3.120','2026-08-03','09:40:30','PLG0030619','3215000','3215000','0','3215000','3215000','kasir','2026-08-03 09:40:29','F32603094029');
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-03','F326030940291','2026-08-03','09:40:30','AAT','3215000','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-260803-0004','D','2026-08-03','09:40:30','kasir','PENJUALAN','F326030940291','6628025000','3215000','6631240000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3215000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326030940291' 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 ('F326030940292','kasir',' 1',' MEH1 UB 44','TOKO','PM-H','H1E-ZGXA-290-0','KL KOREA UB 44 8K ','','0.940','1','100.00','968000','0','0','15000','970000','0','0','0','970000','AAT','00411814','H1E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGXA-290-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.940',berat_jual_asli=berat_jual_asli+'0.940',stock_jual='1',berat_akhir=berat_akhir-'0.940',berat_akhir_asli=berat_akhir_asli-'0.940',stock_akhir='0' WHERE tanggal='2026-08-03' AND kode_barang='H1E-ZGXA-290-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 ('F326030940292','2026-08-03','0.940','2026-08-03','09:40:30','PLG0030620','970000','970000','0','970000','970000','kasir','2026-08-03 09:40:29','F32603094029');
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-03','F326030940292','2026-08-03','09:40:30','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,status_valid) VALUES ('KM-260803-0005','D','2026-08-03','09:40:30','kasir','PENJUALAN','F326030940292','6631240000','970000','6632210000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='970000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326030940292' 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 ('F326030947081','kasir','1',' MFE1 KH 12','TOKO','PM-E','E1F-ZGBX-180-0','CC MODEL SPECTRA SLEP KH 12 8K ','','0.360','1','100.00','378000','0','0','15000','378000','0','0','0','378000','AAT','00414381','E1F','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGBX-180-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-08-03' AND kode_barang='E1F-ZGBX-180-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 ('F326030947081','2026-08-03','0.360','2026-08-03','09:47:09','PLG0030621','378000','378000','0','378000','378000','kasir','2026-08-03 09:47:08','F32603094708');
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-03','F326030947081','2026-08-03','09:47:09','AAT','378000','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-260803-0006','D','2026-08-03','09:47:09','kasir','PENJUALAN','F326030947081','6632210000','378000','6632588000');
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 ('F326030952591','kasir','1',' MEF3E UB ','TOKO','PM-F','F3E-ZGBD-162-0','GL RANTAI HOLLOW SLEP UB 8K ','','2.010','1','100.00','2070000','0','0','15000','2070000','0','0','0','2070000','LIS','00415539','F3E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGBD-162-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.010',berat_jual_asli=berat_jual_asli+'2.010',stock_jual='1',berat_akhir=berat_akhir-'2.010',berat_akhir_asli=berat_akhir_asli-'2.010',stock_akhir='0' WHERE tanggal='2026-08-03' AND kode_barang='F3E-ZGBD-162-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 ('F326030952591','2026-08-03','2.010','2026-08-03','09:53:00','PLG0030622','2070000','2070000','0','2070000','2070000','kasir','2026-08-03 09:52:59','F32603095259');
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-03','F326030952591','2026-08-03','09:53:00','LIS','2070000','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-260803-0007','D','2026-08-03','09:53:00','kasir','PENJUALAN','F326030952591','6632588000','2070000','6634658000');
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 ('F326031016201','kasir','1',' TDE1 X CM ','TOKO','PT-E','E1TD-ZGBH-43-T','CC X VELG SLEP CM 22 17K ','','2.050','1','100.00','3834000','0','0','15000','3835000','0','0','0','3835000','LIS','T0081643','E1TD','0','0','-','0','1870000');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-ZGBH-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-08-03' AND kode_barang='E1TD-ZGBH-43-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 ('F326031016201','2026-08-03','2.050','2026-08-03','10:16:21','PLG0030623','3835000','3835000','0','3835000','3835000','kasir','2026-08-03 10:16:20','F32603101620');
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-03','F326031016201','2026-08-03','10:16:21','LIS','3835000','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-260803-0008','D','2026-08-03','10:16:21','kasir','PENJUALAN','F326031016201','6634658000','3835000','6638493000');
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 ('F326031037161','kasir','1',' MFA1 YT ','TOKO','PM-A','A1F-YCBF-331-0','AT TRIXIE PANJANG HATI ARESO VAR YT 8K ','','0.740','1','100.00','777000','0','0','15000','778000','0','0','0','778000','SIN','00346054','A1F','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-YCBF-331-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.740',berat_jual_asli=berat_jual_asli+'0.740',stock_jual='1',berat_akhir=berat_akhir-'0.740',berat_akhir_asli=berat_akhir_asli-'0.740',stock_akhir='0' WHERE tanggal='2026-08-03' AND kode_barang='A1F-YCBF-331-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 ('F326031037161','2026-08-03','0.740','2026-08-03','10:37:17','PLG0030624','778000','778000','0','778000','778000','kasir','2026-08-03 10:37:16','F32603103716');
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-03','F326031037161','2026-08-03','10:37:17','SIN','778000','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-260803-0009','D','2026-08-03','10:37:17','kasir','PENJUALAN','F326031037161','6638493000','778000','6639271000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='778000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326031037161' 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 ('F326031037162','kasir',' 1',' MJH2 X UB ','TOKO','PM-H','H2J-ZGCA-42-0','KL X GUCCI UB 44 9K ','','3.000','1','100.00','3390000','0','0','15000','3390000','0','0','0','3390000','SIN','00416128','H2J','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZGCA-42-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2026-08-03' AND kode_barang='H2J-ZGCA-42-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 ('F326031037162','2026-08-03','3.000','2026-08-03','10:37:17','PLG0030625','3390000','3390000','0','3390000','3390000','kasir','2026-08-03 10:37:16','F32603103716');
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-03','F326031037162','2026-08-03','10:37:17','SIN','3390000','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-260803-0010','D','2026-08-03','10:37:17','kasir','PENJUALAN','F326031037162','6639271000','3390000','6642661000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3390000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326031037162' 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 ('F326031206571','kasir','1',' MDE2 CM 14','TOKO','PM-E','E2D-YBAI-23-0','CC MODEL MATA CM 14 8K ','','0.950','1','100.00','959000','0','0','15000','960000','0','0','0','960000','SIN','00339968','E2D','0','0','-','0','1020000');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YBAI-23-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-08-03' AND kode_barang='E2D-YBAI-23-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 ('F326031206571','2026-08-03','0.950','2026-08-03','12:06:57','PLG0030626','960000','960000','0','960000','960000','kasir','2026-08-03 12:06:57','F32603120657');
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-03','F326031206571','2026-08-03','12:06:57','SIN','960000','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-260803-0011','D','2026-08-03','12:06:57','kasir','PENJUALAN','F326031206571','6642661000','960000','6643621000');
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 ('F326031233371','kasir','1',' MEF3E YT ','TOKO','PM-F','F3E-ZGBD-167-0','GL TIFF VAR SLEP YT 8K ','','1.890','1','100.00','1947000','0','0','15000','1948000','0','0','0','1948000','SIN','00415544','F3E','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGBD-167-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.890',berat_jual_asli=berat_jual_asli+'1.890',stock_jual='1',berat_akhir=berat_akhir-'1.890',berat_akhir_asli=berat_akhir_asli-'1.890',stock_akhir='0' WHERE tanggal='2026-08-03' AND kode_barang='F3E-ZGBD-167-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 ('F326031233371','2026-08-03','1.890','2026-08-03','12:33:38','PLG0030627','1948000','1948000','0','1948000','1948000','kasir','2026-08-03 12:33:37','F32603123337');
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-03','F326031233371','2026-08-03','12:33:38','SIN','1948000','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-260803-0012','D','2026-08-03','12:33:38','kasir','PENJUALAN','F326031233371','6643621000','1948000','6645569000');
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-00019814','X-00019814','CC MODEL SLEP UB 12 8K','GR','---','E1E','BELI','BELI001','680000','2026-08-03','0.710','1','kasir','2026-08-03 12:36:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019814','X-00019814');
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-260803-0001','F326130935183','FIT','1','BELI','BELI001','E1E', 'X-00019814', 'CC MODEL SLEP UB 12 8K','0.710','0.710','100.00','795000','680000','957746','1040000','1','680000','680000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.710',berat_beli_asli=berat_beli_asli+'0.710',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.710',berat_akhir_asli=berat_akhir_asli+'0.710',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-03' 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-260803-0001','2026-08-03','2026-08-03','12:36:25','FIT','---','0.710','680000','680000','680000','680000','680000','kasir','2026-08-03 12:36:25','FB-260803-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260803-0001','SILVIANA','BITING BADEGAN','','','081914775355','kasir','2026-08-03 12:36:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-03' 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-260803-0013','K','2026-08-03','12:36:25','kasir','PEMBELIAN UMUM','FB-260803-0001','6645569000','680000','6644889000');
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-00019815','X-00019815','CC MODEL ISYANA SLEP LG 18 8K','GR','---','E1E','BELI','BELI001','405000','2026-08-03','0.460','1','kasir','2026-08-03 12:36:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019815','X-00019815');
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-260803-0002','F326090224481','LIS','1','BELI','BELI001','E1E', 'X-00019815', 'CC MODEL ISYANA SLEP LG 18 8K','0.460','0.460','100.00','478000','405000','880435','1040000','1','405000','405000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.460',berat_beli_asli=berat_beli_asli+'0.460',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.460',berat_akhir_asli=berat_akhir_asli+'0.460',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-03' 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-260803-0002','2026-08-03','2026-08-03','12:36:50','LIS','---','0.460','405000','405000','405000','405000','405000','kasir','2026-08-03 12:36:51','FB-260803-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260803-0002','DIKI','LEMAHBANG KISMANTORO','','','','kasir','2026-08-03 12:36:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-03' 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-260803-0014','K','2026-08-03','12:36:50','kasir','PEMBELIAN UMUM','FB-260803-0002','6644889000','405000','6644484000');
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-00019816','X-00019816','CC MODEL ISYANA SLEP LG 12 8K','GR','---','E1E','BELI','BELI001','415000','2026-08-03','0.470','1','kasir','2026-08-03 12:37:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019816','X-00019816');
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-260803-0003','F326090224482','LIS','1','BELI','BELI001','E1E', 'X-00019816', 'CC MODEL ISYANA SLEP LG 12 8K','0.470','0.470','100.00','490000','415000','882979','1040000','1','415000','415000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.470',berat_beli_asli=berat_beli_asli+'0.470',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.470',berat_akhir_asli=berat_akhir_asli+'0.470',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-03' 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-260803-0003','2026-08-03','2026-08-03','12:37:27','LIS','---','0.470','415000','415000','415000','415000','415000','kasir','2026-08-03 12:37:28','FB-260803-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260803-0003','DIKI','LEMAHBANG KISMANTORO','','','','kasir','2026-08-03 12:37:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-03' 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-260803-0015','K','2026-08-03','12:37:27','kasir','PEMBELIAN UMUM','FB-260803-0003','6644484000','415000','6644069000');
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-00019817','X-00019817','CC MODEL DAUN VAR CM 12 8K','GR','---','E1E','BELI','BELI001','745000','2026-08-03','0.780','1','kasir','2026-08-03 12:38:08');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019817','X-00019817');
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-260803-0004','F326250208341','LIS','1','BELI','BELI001','E1E', 'X-00019817', 'CC MODEL DAUN VAR CM 12 8K','0.780','0.780','100.00','823000','745000','955128','1040000','1','745000','745000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.780',berat_beli_asli=berat_beli_asli+'0.780',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.780',berat_akhir_asli=berat_akhir_asli+'0.780',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-03' 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-260803-0004','2026-08-03','2026-08-03','12:38:07','LIS','---','0.780','745000','745000','745000','745000','745000','kasir','2026-08-03 12:38:08','FB-260803-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260803-0004','VINA','TEGALREJO','','','','kasir','2026-08-03 12:38:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-03' 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-260803-0016','K','2026-08-03','12:38:07','kasir','PEMBELIAN UMUM','FB-260803-0004','6644069000','745000','6643324000');
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-00019818','X-00019818','CC MODEL SLEP HW 15 8K','GR','---','E1D','BELI','BELI001','965000','2026-08-03','1.030','1','kasir','2026-08-03 12:38:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019818','X-00019818');
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-260803-0005','F326301100071','AAT','1','BELI','BELI001','E1D', 'X-00019818', 'CC MODEL SLEP HW 15 8K','1.030','1.030','100.00','1060000','965000','936893','1020000','1','965000','965000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.030',berat_beli_asli=berat_beli_asli+'1.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.030',berat_akhir_asli=berat_akhir_asli+'1.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-03' 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-260803-0005','2026-08-03','2026-08-03','12:38:35','AAT','---','1.030','965000','965000','965000','965000','965000','kasir','2026-08-03 12:38:35','FB-260803-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260803-0005','SURYANI','BITING PURWANTORO','','','085177493093','kasir','2026-08-03 12:38:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-03' 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-260803-0017','K','2026-08-03','12:38:35','kasir','PEMBELIAN UMUM','FB-260803-0005','6643324000','965000','6642359000');
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-00019819','X-00019819','GL XXX FLIK SLEP HW 8K','GR','---','F3E','BELI','BELI001','2035000','2026-08-03','2.060','1','kasir','2026-08-03 12:38:55');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019819','X-00019819');
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-260803-0006','F326071057521','AAT','1','BELI','BELI001','F3E', 'X-00019819', 'GL XXX FLIK SLEP HW 8K','2.060','2.060','100.00','2307000','2035000','987864','1040000','1','2035000','2035000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.060',berat_beli_asli=berat_beli_asli+'2.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.060',berat_akhir_asli=berat_akhir_asli+'2.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-03' 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-260803-0006','2026-08-03','2026-08-03','12:38:55','AAT','---','2.060','2035000','2035000','2035000','2035000','2035000','kasir','2026-08-03 12:38:55','FB-260803-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260803-0006','FITRI','SIGERENG BITING','','','081326622374','kasir','2026-08-03 12:38:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-03' 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-260803-0018','K','2026-08-03','12:38:55','kasir','PEMBELIAN UMUM','FB-260803-0006','6642359000','2035000','6640324000');
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-00019820','X-00019820','KL NORY UB 42 CM 8K','GR','---','H1E','BELI','BELI001','1380000','2026-08-03','1.560','1','kasir','2026-08-03 12:40:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00019820','X-00019820');
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-260803-0007','F326061111591','AAT','1','BELI','BELI001','H1E', 'X-00019820', 'KL NORY UB 42 CM 8K','1.560','1.560','100.00','1795000','1380000','884615','1040000','1','1380000','1380000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.560',berat_beli_asli=berat_beli_asli+'1.560',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.560',berat_akhir_asli=berat_akhir_asli+'1.560',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' 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-260803-0007','2026-08-03','2026-08-03','12:40:05','AAT','---','1.560','1380000','1380000','1380000','1380000','1380000','kasir','2026-08-03 12:40:06','FB-260803-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260803-0007','SURYANI','BITING','','','','kasir','2026-08-03 12:40:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-03' 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-260803-0019','K','2026-08-03','12:40:05','kasir','PEMBELIAN UMUM','FB-260803-0007','6640324000','1380000','6638944000');
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-00019821','X-00019821','GW X TUSUK MODEL ARESO UB','GR','---','B1TF','BELI','BELI001','1875000','2026-08-03','1.050','1','kasir','2026-08-03 12:41:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1TF','X-00019821','X-00019821');
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-260803-0008','F326261018183','FIT','1','BELI','BELI001','B1TF', 'X-00019821', 'GW X TUSUK MODEL ARESO UB','1.050','1.050','100.00','2373000','1875000','1785714','1910000','1','1875000','1875000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1TF' 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-260803-0008','2026-08-03','2026-08-03','12:41:33','FIT','---','1.050','1875000','1875000','1875000','1875000','1875000','kasir','2026-08-03 12:41:33','FB-260803-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260803-0008','SUMPAH SISWANTI','KISMANTORO','','','','kasir','2026-08-03 12:41:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-03' 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-260803-0020','K','2026-08-03','12:41:33','kasir','PEMBELIAN UMUM','FB-260803-0008','6638944000','1875000','6637069000');
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-00019822','X-00019822','CC MODEL HATI SLEP LG 12 8K','GR','---','E1E','BELI','BELI001','535000','2026-08-03','0.560','1','kasir','2026-08-03 12:41:55');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019822','X-00019822');
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-260803-0009','F326090215432','SIN','1','BELI','BELI001','E1E', 'X-00019822', 'CC MODEL HATI SLEP LG 12 8K','0.560','0.560','100.00','627000','535000','955357','1040000','1','535000','535000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.560',berat_beli_asli=berat_beli_asli+'0.560',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.560',berat_akhir_asli=berat_akhir_asli+'0.560',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-03' 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-260803-0009','2026-08-03','2026-08-03','12:41:54','SIN','---','0.560','535000','535000','535000','535000','535000','kasir','2026-08-03 12:41:55','FB-260803-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260803-0009','AULIA','BAKALAN PWO','','','0886530917','kasir','2026-08-03 12:41:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-03' 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-260803-0021','K','2026-08-03','12:41:54','kasir','PEMBELIAN UMUM','FB-260803-0009','6637069000','535000','6636534000');
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-00019823','X-00019823','CC X MODEL CAT HITAM TD 12 8K','GR','---','E1E','BELI','BELI001','502000','2026-08-03','0.520','1','kasir','2026-08-03 12:42:12');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019823','X-00019823');
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-260803-0010','F326090215431','SIN','1','BELI','BELI001','E1E', 'X-00019823', 'CC X MODEL CAT HITAM TD 12 8K','0.520','0.520','100.00','583000','502000','965385','1040000','1','502000','502000','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-03' 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-260803-0010','2026-08-03','2026-08-03','12:42:11','SIN','---','0.520','502000','502000','502000','502000','502000','kasir','2026-08-03 12:42:12','FB-260803-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260803-0010','AULIA','BAKALAN PWO','','','0886530917','kasir','2026-08-03 12:42:12');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-03' 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-260803-0022','K','2026-08-03','12:42:11','kasir','PEMBELIAN UMUM','FB-260803-0010','6636534000','502000','6636032000');
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-00019824','X-00019824','GL X CAPELLA ARESO PASIR HW 8K','GR','---','F3E','BELI','BELI001','1953000','2026-08-03','2.160','1','kasir','2026-08-03 12:43:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019824','X-00019824');
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-260803-0011','F325081214031','SIN','1','BELI','BELI001','F3E', 'X-00019824', 'GL X CAPELLA ARESO PASIR HW 8K','2.160','2.160','100.00','2220000','1953000','904167','1040000','1','1953000','1953000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.160',berat_beli_asli=berat_beli_asli+'2.160',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.160',berat_akhir_asli=berat_akhir_asli+'2.160',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-03' 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-260803-0011','2026-08-03','2026-08-03','12:43:30','SIN','---','2.160','1953000','1953000','1953000','1953000','1953000','kasir','2026-08-03 12:43:31','FB-260803-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260803-0011','AULIA','BAKALAN','','','','kasir','2026-08-03 12:43:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-03' 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-260803-0023','K','2026-08-03','12:43:30','kasir','PEMBELIAN UMUM','FB-260803-0011','6636032000','1953000','6634079000');
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-00019825','X-00019825','CC BANGKOK PASIR BW 17 8K','GR','---','E1E','BELI','BELI001','440000','2026-08-03','0.600','1','kasir','2026-08-03 12:44:52');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019825','X-00019825');
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-260803-0012','F325300811121','LIS','1','BELI','BELI001','E1E', 'X-00019825', 'CC BANGKOK PASIR BW 17 8K','0.600','0.600','100.00','518000','440000','733333','1040000','1','440000','440000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.600',berat_beli_asli=berat_beli_asli+'0.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.600',berat_akhir_asli=berat_akhir_asli+'0.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-03' 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-260803-0012','2026-08-03','2026-08-03','12:44:51','LIS','---','0.600','440000','440000','440000','440000','440000','kasir','2026-08-03 12:44:52','FB-260803-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260803-0012','LIA','GUNAN SLOGOHIMO','','','','kasir','2026-08-03 12:44:52');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-03' 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-260803-0024','K','2026-08-03','12:44:51','kasir','PEMBELIAN UMUM','FB-260803-0012','6634079000','440000','6633639000');
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-00019826','X-00019826','GL LEMES 8K','GR','---','F3E','BELI','BELI001','795000','2026-08-03','0.900','1','kasir','2026-08-03 12:47:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019826','X-00019826');
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-260803-0013','00406720','AAT','1','BELI','BELI001','F3E', 'X-00019826', 'GL LEMES 8K','0.970','0.900','100.00','1035000','795000','883333','1040000','1','795000','795000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-03' 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-260803-0013','2026-08-03','2026-08-03','12:47:32','AAT','---','0.900','795000','795000','795000','795000','795000','kasir','2026-08-03 12:47:33','FB-260803-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260803-0013','INDAH','KENITEN PONOROGO','','','','kasir','2026-08-03 12:47:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-03' 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-260803-0025','K','2026-08-03','12:47:32','kasir','PEMBELIAN UMUM','FB-260803-0013','6633639000','795000','6632844000');
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 ('F326030116471','kasir','1',' MEH1 X UB ','TOKO','PM-H','H1E-ZFXH-193-0','KL X NORY ANAK UB 34 8K ','','1.020','1','100.00','1051000','0','0','15000','1050000','0','0','0','1050000','AAT','00408054','H1E','0','0','-','1','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFXH-193-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-03' AND kode_barang='H1E-ZFXH-193-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 ('F326030116471','2026-08-03','1.020','2026-08-03','13:16:47','PLG0030628','1050000','1050000','0','1050000','1050000','kasir','2026-08-03 13:16:47','F32603011647');
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-03','F326030116471','2026-08-03','13:16:47','AAT','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-260803-0026','D','2026-08-03','13:16:47','kasir','PENJUALAN','F326030116471','6632844000','1050000','6633894000');
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 ('F326030122071','kasir','1',' MED1E X LG','TOKO','PM-D','D1E-ZCXG-118-0','LT X BONEKA ANAK CAT LG 8K ','','0.550','1','100.00','566000','0','0','15000','565000','0','0','0','565000','AAT','00392554','D1E','0','0','-','1','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZCXG-118-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-03' AND kode_barang='D1E-ZCXG-118-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 ('F326030122071','2026-08-03','0.550','2026-08-03','13:22:07','PLG0030629','565000','565000','0','565000','565000','kasir','2026-08-03 13:22:07','F32603012207');
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-03','F326030122071','2026-08-03','13:22:07','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-260803-0027','D','2026-08-03','13:22:07','kasir','PENJUALAN','F326030122071','6633894000','565000','6634459000');
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-00019827','X-00019827','CC X MODEL MATA NJ 14 8K','GR','---','E2E','BELI','BELI001','645000','2026-08-03','0.970','1','kasir','2026-08-03 14:16:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00019827','X-00019827');
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-260803-0014','F324221055342','SIN','1','BELI','BELI001','E2E', 'X-00019827', 'CC X MODEL MATA NJ 14 8K','0.970','0.970','100.00','475000','645000','664948','1040000','1','645000','645000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.970',berat_beli_asli=berat_beli_asli+'0.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.970',berat_akhir_asli=berat_akhir_asli+'0.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-03' 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-260803-0014','2026-08-03','2026-08-03','14:16:13','SIN','---','0.970','645000','645000','645000','645000','645000','kasir','2026-08-03 14:16:14','FB-260803-0014');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260803-0014','LINDA','NADI BULUKERTO','','','','kasir','2026-08-03 14:16:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-03' 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-260803-0028','K','2026-08-03','14:16:13','kasir','PEMBELIAN UMUM','FB-260803-0014','6634459000','645000','6633814000');
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 ('F326030255411','kasir','1',' MED2 LG L ','TOKO','PM-D','D2E-ZABA-170-0','LT MODEL HURUF MATA LG L 8K ','','0.550','1','100.00','566000','0','0','15000','560000','0','0','0','560000','SIN','00386495','D2E','0','0','-','1','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-08-03', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZABA-170-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-03' AND kode_barang='D2E-ZABA-170-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 ('F326030255411','2026-08-03','0.550','2026-08-03','14:55:42','PLG0030630','560000','560000','0','560000','560000','kasir','2026-08-03 14:55:41','F32603025541');
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-03','F326030255411','2026-08-03','14:55:42','SIN','560000','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-260803-0029','D','2026-08-03','14:55:42','kasir','PENJUALAN','F326030255411','6633814000','560000','6634374000');
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-00019828','X-00019828','LT MODEL BOLA MATA LG','GR','---','D2E','BELI','BELI001','690000','2026-08-03','1.200','1','kasir','2026-08-03 14:59:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00019828','X-00019828');
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-260803-0015','F322080207301','SIN','1','BELI','BELI001','D2E', 'X-00019828', 'LT MODEL BOLA MATA LG','1.200','1.200','100.00','495000','690000','575000','1040000','1','690000','690000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.200',berat_beli_asli=berat_beli_asli+'1.200',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.200',berat_akhir_asli=berat_akhir_asli+'1.200',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-03' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' 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-260803-0015','2026-08-03','2026-08-03','14:59:01','SIN','---','1.200','690000','690000','690000','690000','690000','kasir','2026-08-03 14:59:02','FB-260803-0015');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260803-0015','LINA','KISMANTORO','','','','kasir','2026-08-03 14:59:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-03' 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-260803-0030','K','2026-08-03','14:59:01','kasir','PEMBELIAN UMUM','FB-260803-0015','6634374000','690000','6633684000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260803-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260803-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260803-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260803-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260803-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260803-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260803-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260803-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260803-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260803-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260803-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260803-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260803-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260803-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260803-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260803-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260803-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260803-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260803-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260803-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260803-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260803-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260803-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260803-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260803-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260803-0013';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260803-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260803-0014';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260803-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260803-0015';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030116471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030116471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030116471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030122071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030122071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030122071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030255411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030255411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030255411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030758451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030758451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030758451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030827461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030827461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030827461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030940291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030940291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030940291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030940292' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030940292' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030940292';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030947081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030947081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030947081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326030952591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326030952591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326030952591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326031016201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326031016201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326031016201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326031037161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326031037161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326031037161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326031037162' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326031037162' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326031037162';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326031206571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326031206571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326031206571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326031233371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326031233371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326031233371';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-04','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-04';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-03';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-03';
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-03' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-03';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-03';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-03';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-03';
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-04' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-03' 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-260804-0001','D','2026-08-04','15:18:36','SYSTEM','SALDO AWAL','SALDO AWAL','0','6633684000','6633684000');
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-260804-0001','D','2026-08-04','15:18:36','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-260804-0001','D','2026-08-04','15:18:36','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-260804-0001','D','2026-08-04','15:18:36','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-08-04';