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 ('F326120810061','input','1',' TEE2 CM 12','TOKO','PT-E','E2TE-WABA-33-T','CC WEDDING MATA CM 12 ','','2.200','1','100.00','4224000','0','0','15000','4225000','0','0','0','4225000','SIN','T0041651','E2TE','0','0','-','0','1920000');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TE-WABA-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.200',berat_jual_asli=berat_jual_asli+'2.200',stock_jual='1',berat_akhir=berat_akhir-'2.200',berat_akhir_asli=berat_akhir_asli-'2.200',stock_akhir='0' WHERE tanggal='2026-07-12' AND kode_barang='E2TE-WABA-33-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 ('F326120810061','2026-07-12','2.200','2026-07-12','08:10:07','PLG0030270','4225000','4225000','0','4225000','4225000','input','2026-07-12 08:10:06','F32612081006');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-12','F326120810061','2026-07-12','08:10:07','SIN','4225000','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-260712-0002','D','2026-07-12','08:10:07','input','PENJUALAN','F326120810061','6280140000','4225000','6284365000');
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 ('F326120920481','input','1',' MEH1E KH 4','TOKO','PM-H','H1E-ZGAA-81-0','KL SIEM COBRA KH 42 8K ','','2.030','1','100.00','2152000','0','0','15000','2132000','0','0','0','2132000','LIS','00413260','H1E','0','0','-','1','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGAA-81-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-07-12' AND kode_barang='H1E-ZGAA-81-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 ('F326120920481','2026-07-12','2.030','2026-07-12','09:20:48','PLG0030271','2132000','2132000','0','2132000','2132000','input','2026-07-12 09:20:48','F32612092048');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-12','F326120920481','2026-07-12','09:20:48','LIS','2132000','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-260712-0003','D','2026-07-12','09:20:48','input','PENJUALAN','F326120920481','6284365000','2132000','6286497000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2132000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326120920481' 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 ('F326120920482','input',' 1',' MEA1 UB ','TOKO','PM-A','A1E-ZDXA-47-0','AT JERSY SLEP UB 8K ','','0.410','1','100.00','430000','0','0','15000','431000','0','0','0','431000','LIS','00397526','A1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZDXA-47-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2026-07-12' AND kode_barang='A1E-ZDXA-47-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 ('F326120920482','2026-07-12','0.410','2026-07-12','09:20:48','PLG0030272','431000','431000','0','431000','431000','input','2026-07-12 09:20:48','F32612092048');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-12','F326120920482','2026-07-12','09:20:48','LIS','431000','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-260712-0004','D','2026-07-12','09:20:48','input','PENJUALAN','F326120920482','6286497000','431000','6286928000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='431000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326120920482' 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 ('F326120924511','input','1',' MFF3F X UB','TOKO','PM-F','F3F-YKXA-269-0','GL X GUCCI UB 8K ','','0.580','1','100.00','615000','0','0','15000','620000','0','0','0','620000','FIT','00375840','F3F','0','0','-','0','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-YKXA-269-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-07-12' AND kode_barang='F3F-YKXA-269-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 ('F326120924511','2026-07-12','0.580','2026-07-12','09:24:51','PLG0030273','620000','620000','0','620000','620000','input','2026-07-12 09:24:51','F32612092451');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-12','F326120924511','2026-07-12','09:24:51','FIT','620000','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-260712-0005','D','2026-07-12','09:24:51','input','PENJUALAN','F326120924511','6286928000','620000','6287548000');
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 ('F326121013441','input','1',' MEB1 X CM ','TOKO','PM-B','B1E-ZGXG-61-0','GW X MODEL MATA CM PE 8K ','','0.720','1','100.00','756000','0','0','15000','755000','0','0','0','755000','AAT','00412462','B1E','0','0','-','1','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGXG-61-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2026-07-12' AND kode_barang='B1E-ZGXG-61-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326121013441','2026-07-12','0.720','2026-07-12','10:13:45','PLG0030274','755000','755000','0','755000','755000','input','2026-07-12 10:13:44','F32612101344');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-12','F326121013441','2026-07-12','10:13:45','AAT','755000','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-260712-0006','D','2026-07-12','10:13:45','input','PENJUALAN','F326121013441','6287548000','755000','6288303000');
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 ('F326121019401','input','1',' MJH2 X UB ','TOKO','PM-H','H2J-ZEXI-197-0','KL X MILANO UB 44 9K ','','2.970','1','100.00','3415000','0','0','15000','3415000','0','0','0','3415000','SIN','00403018','H2J','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZEXI-197-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.970',berat_jual_asli=berat_jual_asli+'2.970',stock_jual='1',berat_akhir=berat_akhir-'2.970',berat_akhir_asli=berat_akhir_asli-'2.970',stock_akhir='0' WHERE tanggal='2026-07-12' AND kode_barang='H2J-ZEXI-197-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 ('F326121019401','2026-07-12','2.970','2026-07-12','10:19:41','PLG0030275','3415000','3415000','0','3415000','3415000','input','2026-07-12 10:19:40','F32612101940');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-12','F326121019401','2026-07-12','10:19:41','SIN','3415000','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-260712-0007','D','2026-07-12','10:19:41','input','PENJUALAN','F326121019401','6288303000','3415000','6291718000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3415000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326121019401' 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 ('F326121019402','input',' 1',' MED1E X TD','TOKO','PM-D','D1E-ZEBG-73-0','LT X MODEL SPECTRA HITAM TD 8K ','','0.510','1','100.00','535000','0','0','15000','535000','0','5000','0','540000','SIN','00405071','D1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZEBG-73-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-07-12' AND kode_barang='D1E-ZEBG-73-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 ('F326121019402','2026-07-12','0.510','2026-07-12','10:19:41','PLG0030276','535000','535000','5000','540000','540000','input','2026-07-12 10:19:40','F32612101940');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-12','F326121019402','2026-07-12','10:19:41','SIN','540000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260712-0008','D','2026-07-12','10:19:41','input','PENJUALAN','F326121019402','6291718000','540000','6292258000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='540000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326121019402' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121019401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121019401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121019401';
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 ('F326121022221','kasir','1',' MJH2 X UB ','TOKO','PM-H','H2J-ZEXI-197-0','KL X MILANO UB 44 9K ','','2.970','1','100.00','3415000','0','0','15000','3415000','0','0','0','3415000','SIN','00403018','H2J','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZEXI-197-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.970',berat_jual_asli=berat_jual_asli+'2.970',stock_jual='1',berat_akhir=berat_akhir-'2.970',berat_akhir_asli=berat_akhir_asli-'2.970',stock_akhir='0' WHERE tanggal='2026-07-12' AND kode_barang='H2J-ZEXI-197-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 ('F326121022221','2026-07-12','2.970','2026-07-12','10:22:23','PLG0030277','3415000','3415000','0','3415000','3415000','kasir','2026-07-12 10:22:22','F32612102222');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-12','F326121022221','2026-07-12','10:22:23','SIN','3415000','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-260712-0010','D','2026-07-12','10:22:23','kasir','PENJUALAN','F326121022221','6288843000','3415000','6292258000');
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 ('F326121022521','kasir','1',' MEF3E UB ','TOKO','PM-F','F3E-ZGXA-286-0','GL KREPYAK SPECTRA VAR UB 8K ','','4.800','1','100.00','5040000','0','0','15000','5040000','0','0','0','5040000','FIT','00411810','F3E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGXA-286-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.800',berat_jual_asli=berat_jual_asli+'4.800',stock_jual='1',berat_akhir=berat_akhir-'4.800',berat_akhir_asli=berat_akhir_asli-'4.800',stock_akhir='0' WHERE tanggal='2026-07-12' AND kode_barang='F3E-ZGXA-286-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 ('F326121022521','2026-07-12','4.800','2026-07-12','10:22:53','PLG0030278','5040000','5040000','0','5040000','5040000','kasir','2026-07-12 10:22:52','F32612102252');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-12','F326121022521','2026-07-12','10:22:53','FIT','5040000','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-260712-0011','D','2026-07-12','10:22:53','kasir','PENJUALAN','F326121022521','6292258000','5040000','6297298000');
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 ('F326121030461','kasir','1',' MEA1E LG ','TOKO','PM-A','A1E-YJBX-42-0','AT GYPSY ANAK HATI SLEP LG 8K ','','0.560','1','100.00','588000','0','0','15000','588000','0','0','0','588000','LIS','00373825','A1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJBX-42-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-07-12' AND kode_barang='A1E-YJBX-42-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 ('F326121030461','2026-07-12','0.560','2026-07-12','10:30:46','PLG0030279','588000','588000','0','588000','588000','kasir','2026-07-12 10:30:46','F32612103046');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-12','F326121030461','2026-07-12','10:30:46','LIS','588000','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-260712-0012','D','2026-07-12','10:30:46','kasir','PENJUALAN','F326121030461','6297298000','588000','6297886000');
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 ('F326121031421','kasir','1',' MEF3E X HW','TOKO','PM-F','F3E-ZGXI-108-0','GL X CASTELI SPECTRA VAR SLEP HW 8K ','','2.270','1','100.00','2383000','0','0','15000','2385000','0','0','0','2385000','FIT','00412827','F3E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGXI-108-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.270',berat_jual_asli=berat_jual_asli+'2.270',stock_jual='1',berat_akhir=berat_akhir-'2.270',berat_akhir_asli=berat_akhir_asli-'2.270',stock_akhir='0' WHERE tanggal='2026-07-12' AND kode_barang='F3E-ZGXI-108-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 ('F326121031421','2026-07-12','2.270','2026-07-12','10:31:42','PLG0030280','2385000','2385000','0','2385000','2385000','kasir','2026-07-12 10:31:42','F32612103142');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-12','F326121031421','2026-07-12','10:31:42','FIT','2385000','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-260712-0013','D','2026-07-12','10:31:42','kasir','PENJUALAN','F326121031421','6297886000','2385000','6300271000');
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 ('F326121039091','kasir','1',' MFE1F CM 1','TOKO','PM-E','E1F-ZGAA-64-0','CC MODEL SLEP CM 14 8K ','','0.370','1','100.00','400000','0','0','15000','396000','0','0','0','396000','FIT','00413243','E1F','0','0','-','1','1080000');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGAA-64-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-07-12' AND kode_barang='E1F-ZGAA-64-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 ('F326121039091','2026-07-12','0.370','2026-07-12','10:39:10','PLG0030281','396000','396000','0','396000','396000','kasir','2026-07-12 10:39:09','F32612103909');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-12','F326121039091','2026-07-12','10:39:10','FIT','396000','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-260712-0014','D','2026-07-12','10:39:10','kasir','PENJUALAN','F326121039091','6300271000','396000','6300667000');
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 ('F326121058501','kasir','1',' TAE0 DG 24','TOKO','PT-E','E0TA-YEBD-65-T','CC STEMPEL DG 24 17K ','','3.020','1','100.00','5527000','0','0','15000','5528000','0','0','0','5528000','SIN','T0069568','E0TA','0','0','-','0','1830000');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0TA-YEBD-65-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.020',berat_jual_asli=berat_jual_asli+'3.020',stock_jual='1',berat_akhir=berat_akhir-'3.020',berat_akhir_asli=berat_akhir_asli-'3.020',stock_akhir='0' WHERE tanggal='2026-07-12' AND kode_barang='E0TA-YEBD-65-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 ('F326121058501','2026-07-12','3.020','2026-07-12','10:58:51','PLG0030282','5528000','5528000','0','5528000','5528000','kasir','2026-07-12 10:58:50','F32612105850');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-12','F326121058501','2026-07-12','10:58:51','SIN','5528000','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-260712-0015','D','2026-07-12','10:58:51','kasir','PENJUALAN','F326121058501','6300667000','5528000','6306195000');
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 ('F326121205591','kasir','1',' TEF1 UB 40','TOKO','PT-F','F1TE-ZFXE-102-T','GL ANAK PIPA KUPU SLEP UB 40 17K ','','2.160','1','100.00','4147000','0','0','15000','4147000','0','0','0','4147000','SIN','T0080404','F1TE','0','0','-','0','1920000');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-ZFXE-102-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.160',berat_jual_asli=berat_jual_asli+'2.160',stock_jual='1',berat_akhir=berat_akhir-'2.160',berat_akhir_asli=berat_akhir_asli-'2.160',stock_akhir='0' WHERE tanggal='2026-07-12' AND kode_barang='F1TE-ZFXE-102-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326121205591','2026-07-12','2.160','2026-07-12','12:06:00','PLG0030283','4147000','4147000','0','4147000','4147000','kasir','2026-07-12 12:05:59','F32612120559');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-12','F326121205591','2026-07-12','12:06:00','SIN','4147000','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-260712-0016','D','2026-07-12','12:06:00','kasir','PENJUALAN','F326121205591','6306195000','4147000','6310342000');
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 ('F326121244451','kasir','1',' MEF1 CM 55','TOKO','PM-F','F1E-ZGXA-280-0','GL OVAL DAUN SLEP CM 55 8K ','','3.120','1','100.00','3276000','0','0','15000','3276000','0','0','0','3276000','FIT','00411804','F1E','0','0','-','0','1060000');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGXA-280-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-07-12' AND kode_barang='F1E-ZGXA-280-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 ('F326121244451','2026-07-12','3.120','2026-07-12','12:44:45','PLG0030284','3276000','3276000','0','3276000','3276000','kasir','2026-07-12 12:44:45','F32612124445');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-12','F326121244451','2026-07-12','12:44:45','FIT','3276000','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-260712-0017','D','2026-07-12','12:44:45','kasir','PENJUALAN','F326121244451','6310342000','3276000','6313618000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3276000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326121244451' 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 ('F326121244452','kasir',' 1',' MDA1D X UB','TOKO','PM-A','A1D-ZEXI-87-0','AT X HUGGIES KLIP MATA VAR UB 8K ','','1.080','1','100.00','1112000','0','0','15000','1112000','0','0','0','1112000','FIT','00402908','A1D','0','0','-','0','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZEXI-87-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-07-12' AND kode_barang='A1D-ZEXI-87-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 ('F326121244452','2026-07-12','1.080','2026-07-12','12:44:45','PLG0030285','1112000','1112000','0','1112000','1112000','kasir','2026-07-12 12:44:45','F32612124445');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-12','F326121244452','2026-07-12','12:44:45','FIT','1112000','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-260712-0018','D','2026-07-12','12:44:45','kasir','PENJUALAN','F326121244452','6313618000','1112000','6314730000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1112000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326121244452' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00019630','X-00019630','AT X GYPSY MRICAN SLEP LG 8K','GR','---','A1E','BELI','BELI001','225000','2026-07-12','0.260','1','kasir','2026-07-12 13:08:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00019630','X-00019630');
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-260712-0001','F326080943221','AAT','1','BELI','BELI001','A1E', 'X-00019630', 'AT X GYPSY MRICAN SLEP LG 8K','0.530','0.260','100.00','550000','225000','865385','1060000','1','225000','225000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.260',berat_beli_asli=berat_beli_asli+'0.260',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.260',berat_akhir_asli=berat_akhir_asli+'0.260',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-12' 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-260712-0001','2026-07-12','2026-07-12','13:08:47','AAT','---','0.260','225000','225000','225000','225000','225000','kasir','2026-07-12 13:08:47','FB-260712-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260712-0001','MUTIARA','SIGERENG','','','','kasir','2026-07-12 13:08:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-12' 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-260712-0019','K','2026-07-12','13:08:47','kasir','PEMBELIAN UMUM','FB-260712-0001','6314730000','225000','6314505000');
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-00019631','X-00019631','LT X MODEL MATA VAR HK 17K','GR','---','D2TE','BELI','BELI001','987000','2026-07-12','0.550','1','kasir','2026-07-12 13:09:09');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2TE','X-00019631','X-00019631');
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-260712-0002','F326260223191','LIS','1','BELI','BELI001','D2TE', 'X-00019631', 'LT X MODEL MATA VAR HK 17K','0.550','0.550','100.00','1063000','987000','1794545','1920000','1','987000','987000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.550',berat_beli_asli=berat_beli_asli+'0.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.550',berat_akhir_asli=berat_akhir_asli+'0.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2TE' 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-260712-0002','2026-07-12','2026-07-12','13:09:09','LIS','---','0.550','987000','987000','987000','987000','987000','kasir','2026-07-12 13:09:09','FB-260712-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260712-0002','SAMI','GESING KISMANTORO','','','','kasir','2026-07-12 13:09:09');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-12' 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-260712-0020','K','2026-07-12','13:09:09','kasir','PEMBELIAN UMUM','FB-260712-0002','6314505000','987000','6313518000');
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 ('F326120119471','kasir','1',' MDE2 X 10K','TOKO','PM-E','E2D-YKXC-50-0','CC X BONEKA ANAK CAT MATA LG 8K ','','1.050','1','100.00','1081000','0','0','15000','1080000','0','10000','0','1090000','LIS','00375971','E2D','0','0','-','1','1040000');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YKXC-50-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-07-12' AND kode_barang='E2D-YKXC-50-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 ('F326120119471','2026-07-12','1.050','2026-07-12','13:19:48','PLG0030286','1080000','1080000','10000','1090000','1090000','kasir','2026-07-12 13:19:47','F32612011947');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-12','F326120119471','2026-07-12','13:19:48','LIS','1090000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260712-0021','D','2026-07-12','13:19:48','kasir','PENJUALAN','F326120119471','6313518000','1090000','6314608000');
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-00019632','X-00019632','CC X MODEL MATA MJ 18 8K','GR','---','E2D','BELI','BELI001','650000','2026-07-12','0.730','1','kasir','2026-07-12 13:55:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019632','X-00019632');
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-260712-0003','F326240824441','LIS','1','BELI','BELI001','E2D', 'X-00019632', 'CC X MODEL MATA MJ 18 8K','0.730','0.730','100.00','800000','650000','890411','1040000','1','650000','650000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.730',berat_beli_asli=berat_beli_asli+'0.730',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.730',berat_akhir_asli=berat_akhir_asli+'0.730',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-12' 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-260712-0003','2026-07-12','2026-07-12','13:55:58','LIS','---','0.730','650000','650000','650000','650000','650000','kasir','2026-07-12 13:55:59','FB-260712-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260712-0003','NATA','NGROMO NAWANGAN','','','','kasir','2026-07-12 13:55:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-12' 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-260712-0022','K','2026-07-12','13:55:58','kasir','PEMBELIAN UMUM','FB-260712-0003','6314608000','650000','6313958000');
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 ('F326120211281','input','1',' MJH3 X UB ','TOKO','PM-H','H3J-ZDBX-167-0','KL X SANTA MATA VAR UB 44 9K ','','2.950','1','100.00','3392000','0','0','15000','3393000','0','0','0','3393000','SIN','00400104','H3J','0','0','-','0','1160000');
UPDATE tm_barang SET tgl_last_jual='2026-07-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H3J-ZDBX-167-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.950',berat_jual_asli=berat_jual_asli+'2.950',stock_jual='1',berat_akhir=berat_akhir-'2.950',berat_akhir_asli=berat_akhir_asli-'2.950',stock_akhir='0' WHERE tanggal='2026-07-12' AND kode_barang='H3J-ZDBX-167-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 ('F326120211281','2026-07-12','2.950','2026-07-12','14:11:28','PLG0030287','3393000','3393000','0','3393000','3393000','input','2026-07-12 14:11:28','F32612021128');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-07-12','F326120211281','2026-07-12','14:11:28','SIN','3393000','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-260712-0023','D','2026-07-12','14:11:28','input','PENJUALAN','F326120211281','6313958000','3393000','6317351000');
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-00019633','X-00019633','KL X MILANO UB 44 9K','GR','---','H2J','BELI','BELI001','5295000','2026-07-12','4.910','1','kasir','2026-07-12 14:33:13');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00019633','X-00019633');
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-260712-0004','F326111158281','SIN','1','BELI','BELI001','H2J', 'X-00019633', 'KL X MILANO UB 44 9K','4.910','4.910','100.00','6408000','5295000','1078411','1160000','1','5295000','5295000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'4.910',berat_beli_asli=berat_beli_asli+'4.910',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'4.910',berat_akhir_asli=berat_akhir_asli+'4.910',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-12' 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-260712-0004','2026-07-12','2026-07-12','14:33:13','SIN','---','4.910','5295000','5295000','5295000','5295000','5295000','kasir','2026-07-12 14:33:13','FB-260712-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260712-0004','IRFAN','PAKIS BARU NAWANGAN','','','083845282897','kasir','2026-07-12 14:33:13');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-12' 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-260712-0024','K','2026-07-12','14:33:13','kasir','PEMBELIAN UMUM','FB-260712-0004','6317351000','5295000','6312056000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326120119471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326120119471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326120119471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326120211281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326120211281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326120211281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326120810061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326120810061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326120810061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326120920481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326120920481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326120920481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326120920482' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326120920482' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326120920482';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326120924511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326120924511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326120924511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121013441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121013441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121013441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121019402' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121019402' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121019402';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121022221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121022221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121022221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121022521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121022521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121022521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121030461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121030461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121030461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121031421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121031421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121031421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121039091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121039091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121039091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121058501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121058501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121058501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121205591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121205591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121205591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121244451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121244451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121244451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121244452' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121244452' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121244452';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260712-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260712-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260712-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260712-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260712-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260712-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260712-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260712-0004';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-13','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-12';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-12';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-12';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-07-12' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-12';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-12';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-12';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-12';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-13' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-12' 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-260713-0001','D','2026-07-13','15:10:04','SYSTEM','SALDO AWAL','SALDO AWAL','0','6312056000','6312056000');
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-260713-0001','D','2026-07-13','15:10:04','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-260713-0001','D','2026-07-13','15:10:04','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-260713-0001','D','2026-07-13','15:10:04','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-07-13';