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 ('F326160921441','input','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZBXD-256-0','CC X VELG KACA CM 18 8K ','','1.010','1','100.00','1177000','0','0','15000','1178000','0','0','0','1178000','SIN','00387941','E1D','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZBXD-256-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='E1D-ZBXD-256-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 ('F326160921441','2026-03-16','1.010','2026-03-16','09:21:44','PLG0027702','1178000','1178000','0','1178000','1178000','input','2026-03-16 09:21:44','F32616092144');
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-03-16','F326160921441','2026-03-16','09:21:44','SIN','1178000','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-260316-0002','D','2026-03-16','09:21:44','input','PENJUALAN','F326160921441','3077481000','1178000','3078659000');
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 ('F326160944171','input','1',' MEF3E X KH','TOKO','PM-F','F3E-YGAG-101-0','GL X RANTAI HOLLOW P3 SLEP KH 8K ','','2.120','1','100.00','2512000','0','0','15000','2513000','0','0','0','2513000','AAT','00361186','F3E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YGAG-101-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.120',berat_jual_asli=berat_jual_asli+'2.120',stock_jual='1',berat_akhir=berat_akhir-'2.120',berat_akhir_asli=berat_akhir_asli-'2.120',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='F3E-YGAG-101-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 ('F326160944171','2026-03-16','2.120','2026-03-16','09:44:18','PLG0027703','2513000','2513000','0','2513000','2513000','input','2026-03-16 09:44:17','F32616094417');
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-03-16','F326160944171','2026-03-16','09:44:18','AAT','2513000','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-260316-0003','D','2026-03-16','09:44:18','input','PENJUALAN','F326160944171','3078659000','2513000','3081172000');
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 ('F326160952571','input','1',' MIF4 KH ','TOKO','PM-F','F4I-ZCAB-190-0','GL RANTAI HOLLOW KH 9K ','','4.020','1','100.00','5085000','0','0','15000','5085000','0','0','0','5085000','LIS','00393891','F4I','0','0','-','0','1275000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F4I-ZCAB-190-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.020',berat_jual_asli=berat_jual_asli+'4.020',stock_jual='1',berat_akhir=berat_akhir-'4.020',berat_akhir_asli=berat_akhir_asli-'4.020',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='F4I-ZCAB-190-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326160952571','2026-03-16','4.020','2026-03-16','09:52:57','PLG0027704','5085000','5085000','0','5085000','5085000','input','2026-03-16 09:52:57','F32616095257');
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-03-16','F326160952571','2026-03-16','09:52:57','LIS','5085000','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-260316-0004','D','2026-03-16','09:52:57','input','PENJUALAN','F326160952571','3081172000','5085000','3086257000');
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 ('F326161013251','input','1',' MEE2 CM 12','TOKO','PM-E','E2E-ZCAE-192-0','CC PIPA MODEL MATA VAR CM 12 8K ','','0.600','1','100.00','717000','0','0','15000','717000','0','0','0','717000','AAT','00394599','E2E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZCAE-192-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='E2E-ZCAE-192-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 ('F326161013251','2026-03-16','0.600','2026-03-16','10:13:26','PLG0027705','717000','717000','0','717000','717000','input','2026-03-16 10:13:25','F32616101325');
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-03-16','F326161013251','2026-03-16','10:13:26','AAT','717000','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-260316-0005','D','2026-03-16','10:13:26','input','PENJUALAN','F326161013251','3086257000','717000','3086974000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='717000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161013251' 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 ('F326161013252','input',' 1',' MDE2 CM 12','TOKO','PM-E','E2D-ZCAX-163-0','CC MODEL MATA SLEP VAR CM 12 8K ','','0.930','1','100.00','1083000','0','0','15000','1083000','0','0','0','1083000','AAT','00393134','E2D','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAX-163-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.930',berat_jual_asli=berat_jual_asli+'0.930',stock_jual='1',berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='E2D-ZCAX-163-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 ('F326161013252','2026-03-16','0.930','2026-03-16','10:13:26','PLG0027706','1083000','1083000','0','1083000','1083000','input','2026-03-16 10:13:25','F32616101325');
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-03-16','F326161013252','2026-03-16','10:13:26','AAT','1083000','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-260316-0006','D','2026-03-16','10:13:26','input','PENJUALAN','F326161013252','3086974000','1083000','3088057000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1083000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161013252' 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 ('F326161035441','input','1',' MEE1 X LG ','TOKO','PM-E','E1E-ZCXG-153-0','CC X MODEL GELOMBANG SLEP LG 16 8K ','','0.530','1','100.00','628000','0','0','15000','628000','0','0','0','628000','SIN','00392589','E1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCXG-153-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='E1E-ZCXG-153-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 ('F326161035441','2026-03-16','0.530','2026-03-16','10:35:45','PLG0027707','628000','628000','0','628000','628000','input','2026-03-16 10:35:44','F32616103544');
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-03-16','F326161035441','2026-03-16','10:35:45','SIN','628000','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-260316-0007','D','2026-03-16','10:35:45','input','PENJUALAN','F326161035441','3088057000','628000','3088685000');
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 ('F326161059501','input','1',' MDE1 CM 14','TOKO','PM-E','E1D-ZCAD-265-0','CC BANGKOK POLOS CM 14 8K ','','1.050','1','100.00','1234000','0','0','15000','1223000','0','0','0','1223000','SIN','00394398','E1D','0','0','-','1','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCAD-265-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-03-16' AND kode_barang='E1D-ZCAD-265-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 ('F326161059501','2026-03-16','1.050','2026-03-16','10:59:51','PLG0027708','1223000','1223000','0','1223000','1223000','input','2026-03-16 10:59:50','F32616105950');
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-03-16','F326161059501','2026-03-16','10:59:51','SIN','1223000','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-260316-0008','D','2026-03-16','10:59:51','input','PENJUALAN','F326161059501','3088685000','1223000','3089908000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1223000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161059501' 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 ('F326161059502','input',' 1',' MDE1 LG 14','TOKO','PM-E','E1D-ZCAE-193-0','CC MODEL DAUN VAR LG 14 8K ','','1.150','1','100.00','1351000','0','0','15000','1340000','0','0','0','1340000','SIN','00394600','E1D','0','0','-','1','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCAE-193-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='E1D-ZCAE-193-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 ('F326161059502','2026-03-16','1.150','2026-03-16','10:59:51','PLG0027709','1340000','1340000','0','1340000','1340000','input','2026-03-16 10:59:50','F32616105950');
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-03-16','F326161059502','2026-03-16','10:59:51','SIN','1340000','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-260316-0009','D','2026-03-16','10:59:51','input','PENJUALAN','F326161059502','3089908000','1340000','3091248000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1340000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161059502' 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-00018481','X-00018481','CC COR M 17K','GR','---','E2TE','BELI','BELI001','2885000','2026-03-16','1.970','1','kasir','2026-03-16 11:28:11');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00018481','X-00018481');
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-260316-0001','t0048065','AAT','1','BELI','BELI001','E2TE', 'X-00018481', 'CC COR M 17K','1.970','1.970','100.00','1595000','2885000','1464467','2150000','1','2885000','2885000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.970',berat_beli_asli=berat_beli_asli+'1.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.970',berat_akhir_asli=berat_akhir_asli+'1.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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-260316-0001','2026-03-16','2026-03-16','11:28:11','AAT','---','1.970','2885000','2885000','2885000','2885000','2885000','kasir','2026-03-16 11:28:11','FB-260316-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260316-0001','DEVI','SURABAYA','','','','kasir','2026-03-16 11:28:11');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-16' 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-260316-0010','K','2026-03-16','11:28:11','kasir','PEMBELIAN UMUM','FB-260316-0001','3091248000','2885000','3088363000');
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-00018482','X-00018482','GL LEMES 8K','GR','---','F3F','BELI','BELI001','2320000','2026-03-16','2.110','1','kasir','2026-03-16 11:29:19');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3F','X-00018482','X-00018482');
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-260316-0002','00386136','FIT','1','BELI','BELI001','F3F', 'X-00018482', 'GL LEMES 8K','2.110','2.110','100.00','2574000','2320000','1099526','1215000','1','2320000','2320000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.110',berat_beli_asli=berat_beli_asli+'2.110',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.110',berat_akhir_asli=berat_akhir_asli+'2.110',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3F' 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-260316-0002','2026-03-16','2026-03-16','11:29:19','FIT','---','2.110','2320000','2320000','2320000','2320000','2320000','kasir','2026-03-16 11:29:19','FB-260316-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260316-0002','SILVI','PURWANTORO','','','','kasir','2026-03-16 11:29:19');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-16' 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-260316-0011','K','2026-03-16','11:29:19','kasir','PEMBELIAN UMUM','FB-260316-0002','3088363000','2320000','3086043000');
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-00018483','X-00018483','CC COR M 8K','GR','---','E2E','BELI','BELI001','1610000','2026-03-16','2.240','1','kasir','2026-03-16 11:30:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018483','X-00018483');
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-260316-0003','F323061120521','FIT','1','BELI','BELI001','E2E', 'X-00018483', 'CC COR M 8K','2.240','2.240','100.00','1015000','1610000','718750','1195000','1','1610000','1610000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.240',berat_beli_asli=berat_beli_asli+'2.240',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.240',berat_akhir_asli=berat_akhir_asli+'2.240',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-16' 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-260316-0003','2026-03-16','2026-03-16','11:30:25','FIT','---','2.240','1610000','1610000','1610000','1610000','1610000','kasir','2026-03-16 11:30:25','FB-260316-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260316-0003','RIYANTO','BULUREJO BULUKERTO','','','','kasir','2026-03-16 11:30:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-16' 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-260316-0012','K','2026-03-16','11:30:25','kasir','PEMBELIAN UMUM','FB-260316-0003','3086043000','1610000','3084433000');
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-00018484','X-00018484','LT COR T 8K','GR','---','D1F','BELI','BELI001','512000','2026-03-16','0.730','1','kasir','2026-03-16 11:31:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1F','X-00018484','X-00018484');
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-260316-0004','F323251040481','FIT','1','BELI','BELI001','D1F', 'X-00018484', 'LT COR T 8K','0.730','0.730','100.00','350000','512000','701370','1215000','1','512000','512000','CUCI');
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-03-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1F' 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-260316-0004','2026-03-16','2026-03-16','11:31:36','FIT','---','0.730','512000','512000','512000','512000','512000','kasir','2026-03-16 11:31:37','FB-260316-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260316-0004','GENDHIS','PUHPELEM','','','','kasir','2026-03-16 11:31:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-16' 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-260316-0013','K','2026-03-16','11:31:36','kasir','PEMBELIAN UMUM','FB-260316-0004','3084433000','512000','3083921000');
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 ('F326161132321','kasir','1',' TAE0 X DW ','TOKO','PT-E','E0TA-WLBF-115-T','CC X POLOS DW 20 ','','1.980','1','100.00','4079000','0','0','15000','4080000','0','0','0','4080000','FIT','T0052776','E0TA','0','0','-','0','2060000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0TA-WLBF-115-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='E0TA-WLBF-115-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 ('F326161132321','2026-03-16','1.980','2026-03-16','11:32:33','PLG0027710','4080000','4080000','0','4080000','4080000','kasir','2026-03-16 11:32:32','F32616113232');
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-03-16','F326161132321','2026-03-16','11:32:33','FIT','4080000','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-260316-0014','D','2026-03-16','11:32:33','kasir','PENJUALAN','F326161132321','3083921000','4080000','3088001000');
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-00018485','X-00018485','CC X VELG POLOS CM 19 8K','GR','---','E1D','BELI','BELI001','1290000','2026-03-16','1.180','1','kasir','2026-03-16 11:33:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00018485','X-00018485');
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-260316-0005','F326070911532','AAT','1','BELI','BELI001','E1D', 'X-00018485', 'CC X VELG POLOS CM 19 8K','1.180','1.180','100.00','1457000','1290000','1093220','1175000','1','1290000','1290000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.180',berat_beli_asli=berat_beli_asli+'1.180',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.180',berat_akhir_asli=berat_akhir_asli+'1.180',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-16' 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-260316-0005','2026-03-16','2026-03-16','11:33:35','AAT','---','1.180','1290000','1290000','1290000','1290000','1290000','kasir','2026-03-16 11:33:35','FB-260316-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260316-0005','SULIS','SLOGOHIMO','','','089675877627','kasir','2026-03-16 11:33:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-16' 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-260316-0015','K','2026-03-16','11:33:35','kasir','PEMBELIAN UMUM','FB-260316-0005','3088001000','1290000','3086711000');
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-00018486','X-00018486','GW X ITALY SLEP HW 8K','GR','---','B1F','BELI','BELI001','522000','2026-03-16','0.530','1','kasir','2026-03-16 11:34:00');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1F','X-00018486','X-00018486');
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-260316-0006','F325131001071','SIN','1','BELI','BELI001','B1F', 'X-00018486', 'GW X ITALY SLEP HW 8K','0.530','0.530','100.00','563000','522000','984906','1215000','1','522000','522000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1F' 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-260316-0006','2026-03-16','2026-03-16','11:33:59','SIN','---','0.530','522000','522000','522000','522000','522000','kasir','2026-03-16 11:34:00','FB-260316-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260316-0006','LILIS','NAWANGAN','','','','kasir','2026-03-16 11:34:00');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-16' 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-260316-0016','K','2026-03-16','11:33:59','kasir','PEMBELIAN UMUM','FB-260316-0006','3086711000','522000','3086189000');
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-00018487','X-00018487','CC X MODEL MATA MERAH KH 12 8K','GR','---','E2E','BELI','BELI001','670000','2026-03-16','1.020','1','kasir','2026-03-16 11:34:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018487','X-00018487');
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-260316-0007','F324180955233','FIT','1','BELI','BELI001','E2E', 'X-00018487', 'CC X MODEL MATA MERAH KH 12 8K','1.020','1.020','100.00','620000','670000','656863','1195000','1','670000','670000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.020',berat_beli_asli=berat_beli_asli+'1.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.020',berat_akhir_asli=berat_akhir_asli+'1.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-16' 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-260316-0007','2026-03-16','2026-03-16','11:34:29','FIT','---','1.020','670000','670000','670000','670000','670000','kasir','2026-03-16 11:34:29','FB-260316-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260316-0007','ENI','KISMANTORO','','','','kasir','2026-03-16 11:34:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-16' 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-260316-0017','K','2026-03-16','11:34:29','kasir','PEMBELIAN UMUM','FB-260316-0007','3086189000','670000','3085519000');
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-00018488','X-00018488','CC X MODEL SLEP BG 18 8K','GR','---','E1D','BELI','BELI001','2075000','2026-03-16','1.900','1','kasir','2026-03-16 11:46:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00018488','X-00018488');
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-260316-0008','F326311013301','AAT','1','BELI','BELI001','E1D', 'X-00018488', 'CC X MODEL SLEP BG 18 8K','1.900','1.900','100.00','2318000','2075000','1092105','1175000','1','2075000','2075000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.900',berat_beli_asli=berat_beli_asli+'1.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.900',berat_akhir_asli=berat_akhir_asli+'1.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-16' 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-260316-0008','2026-03-16','2026-03-16','11:46:38','AAT','---','1.900','2075000','2075000','2075000','2075000','2075000','kasir','2026-03-16 11:46:38','FB-260316-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260316-0008','WARTI','DOMAS BULUKERTO','','','082138962505','kasir','2026-03-16 11:46:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-16' 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-260316-0018','K','2026-03-16','11:46:38','kasir','PEMBELIAN UMUM','FB-260316-0008','3085519000','2075000','3083444000');
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 ('F326161156211','kasir','1',' MDE2 10K C','TOKO','PM-E','E2D-ZCAD-267-0','CC WEDDING MATA CM 12 8K ','','1.010','1','100.00','1187000','0','0','15000','1177000','0','10000','0','1187000','SIN','00394400','E2D','0','0','-','1','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAD-267-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='E2D-ZCAD-267-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 ('F326161156211','2026-03-16','1.010','2026-03-16','11:56:22','PLG0027711','1177000','1177000','10000','1187000','1187000','kasir','2026-03-16 11:56:21','F32616115621');
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-03-16','F326161156211','2026-03-16','11:56:22','SIN','1187000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260316-0019','D','2026-03-16','11:56:22','kasir','PENJUALAN','F326161156211','3083444000','1187000','3084631000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1187000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161156211' 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 ('F326161156212','kasir',' 1',' MEE1 X LG ','TOKO','PM-E','E1E-ZBAD-336-0','CC X MODEL DAUN SLEP LG 8 8K ','','0.420','1','100.00','498000','0','0','15000','498000','0','0','0','498000','SIN','00389942','E1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZBAD-336-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='E1E-ZBAD-336-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326161156212','2026-03-16','0.420','2026-03-16','11:56:22','PLG0027712','498000','498000','0','498000','498000','kasir','2026-03-16 11:56:21','F32616115621');
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-03-16','F326161156212','2026-03-16','11:56:22','SIN','498000','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-260316-0020','D','2026-03-16','11:56:22','kasir','PENJUALAN','F326161156212','3084631000','498000','3085129000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='498000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161156212' 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 ('F326161157161','kasir','1',' MEH1 X KH ','TOKO','PM-H','H1E-YLAE-103-0','KL X SANTA KH 42 8K ','','1.550','1','100.00','1837000','0','0','15000','1835000','0','0','0','1835000','AAT','00381081','H1E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YLAE-103-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='H1E-YLAE-103-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 ('F326161157161','2026-03-16','1.550','2026-03-16','11:57:16','PLG0027713','1835000','1835000','0','1835000','1835000','kasir','2026-03-16 11:57:16','F32616115716');
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-03-16','F326161157161','2026-03-16','11:57:16','AAT','1835000','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-260316-0021','D','2026-03-16','11:57:16','kasir','PENJUALAN','F326161157161','3085129000','1835000','3086964000');
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 ('F326161209151','kasir','1',' MEF3E X UB','TOKO','PM-F','F3E-ZCXB-270-0','GL X LADY GG SLEP UB 8K ','','3.510','1','100.00','4159000','0','0','15000','4160000','0','0','0','4160000','LIS','00391693','F3E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCXB-270-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.510',berat_jual_asli=berat_jual_asli+'3.510',stock_jual='1',berat_akhir=berat_akhir-'3.510',berat_akhir_asli=berat_akhir_asli-'3.510',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='F3E-ZCXB-270-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 ('F326161209151','2026-03-16','3.510','2026-03-16','12:09:15','PLG0027714','4160000','4160000','0','4160000','4160000','kasir','2026-03-16 12:09:15','F32616120915');
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-03-16','F326161209151','2026-03-16','12:09:15','LIS','4160000','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-260316-0022','D','2026-03-16','12:09:15','kasir','PENJUALAN','F326161209151','3086964000','4160000','3091124000');
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 ('F326161218081','kasir','1',' MJH2 X KH ','TOKO','PM-H','H2J-ZABH-118-0','KL X MILANO KH 44 9K ','','6.010','1','100.00','7723000','0','0','15000','7723000','0','0','0','7723000','SIN','00386976','H2J','0','0','-','0','1295000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZABH-118-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.010',berat_jual_asli=berat_jual_asli+'6.010',stock_jual='1',berat_akhir=berat_akhir-'6.010',berat_akhir_asli=berat_akhir_asli-'6.010',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='H2J-ZABH-118-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 ('F326161218081','2026-03-16','6.010','2026-03-16','12:18:09','PLG0027715','7723000','7723000','0','7723000','7723000','kasir','2026-03-16 12:18:08','F32616121808');
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-03-16','F326161218081','2026-03-16','12:18:09','SIN','7723000','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-260316-0023','D','2026-03-16','12:18:09','kasir','PENJUALAN','F326161218081','3091124000','7723000','3098847000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='7723000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161218081' 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 ('F326161218082','kasir',' 1',' MDD2 XXX U','TOKO','PM-D','D2D-ZABH-57-0','LT XXX MODEL HATI MATA PINK UB 8K ','','1.150','1','100.00','1340000','0','0','15000','1305000','0','0','0','1305000','SIN','00386915','D2D','0','0','-','1','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZABH-57-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='D2D-ZABH-57-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 ('F326161218082','2026-03-16','1.150','2026-03-16','12:18:09','PLG0027716','1305000','1305000','0','1305000','1305000','kasir','2026-03-16 12:18:08','F32616121808');
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-03-16','F326161218082','2026-03-16','12:18:09','SIN','1305000','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-260316-0024','D','2026-03-16','12:18:09','kasir','PENJUALAN','F326161218082','3098847000','1305000','3100152000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1305000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326161218082' 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 ('F326161224491','kasir','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZCXI-73-0','CC X MODEL DAUN SLEP CM 22 8K ','','1.160','1','100.00','1351000','0','0','15000','1350000','0','0','0','1350000','LIS','00392888','E1D','0','0','-','1','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCXI-73-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.160',berat_jual_asli=berat_jual_asli+'1.160',stock_jual='1',berat_akhir=berat_akhir-'1.160',berat_akhir_asli=berat_akhir_asli-'1.160',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='E1D-ZCXI-73-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326161224491','2026-03-16','1.160','2026-03-16','12:24:49','PLG0027717','1350000','1350000','0','1350000','1350000','kasir','2026-03-16 12:24:49','F32616122449');
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-03-16','F326161224491','2026-03-16','12:24:49','LIS','1350000','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-260316-0025','D','2026-03-16','12:24:49','kasir','PENJUALAN','F326161224491','3100152000','1350000','3101502000');
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 ('F326161225101','kasir','1',' MDE1 X OR ','TOKO','PM-E','E1D-YLXH-142-0','CC X VELG SLEP OR 14 8K ','','2.060','1','100.00','2400000','0','0','15000','2400000','0','0','0','2400000','FIT','00380264','E1D','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YLXH-142-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='E1D-YLXH-142-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 ('F326161225101','2026-03-16','2.060','2026-03-16','12:25:10','PLG0027718','2400000','2400000','0','2400000','2400000','kasir','2026-03-16 12:25:10','F32616122510');
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-03-16','F326161225101','2026-03-16','12:25:10','FIT','2400000','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-260316-0026','D','2026-03-16','12:25:10','kasir','PENJUALAN','F326161225101','3101502000','2400000','3103902000');
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 ('F326160103291','kasir','1',' MEE1 LG 12','TOKO','PM-E','E1E-ZCAC-218-0','CC MODEL DAUN SLEP VAR LG 12 8K ','','0.450','1','100.00','533000','0','0','15000','533000','0','0','0','533000','FIT','00394119','E1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZCAC-218-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='E1E-ZCAC-218-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 ('F326160103291','2026-03-16','0.450','2026-03-16','13:03:29','PLG0027719','533000','533000','0','533000','533000','kasir','2026-03-16 13:03:29','F32616010329');
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-03-16','F326160103291','2026-03-16','13:03:29','FIT','533000','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-260316-0027','D','2026-03-16','13:03:29','kasir','PENJUALAN','F326160103291','3103902000','533000','3104435000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='533000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326160103291' 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 ('F326160103292','kasir',' 1',' MDE2 10K C','TOKO','PM-E','E2D-ZCAD-268-0','CC WEDDING MATA CM 14 8K ','','1.060','1','100.00','1245000','0','0','15000','1235000','0','10000','0','1245000','FIT','00394401','E2D','0','0','-','1','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAD-268-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='E2D-ZCAD-268-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 ('F326160103292','2026-03-16','1.060','2026-03-16','13:03:29','PLG0027720','1235000','1235000','10000','1245000','1245000','kasir','2026-03-16 13:03:29','F32616010329');
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-03-16','F326160103292','2026-03-16','13:03:29','FIT','1245000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260316-0028','D','2026-03-16','13:03:29','kasir','PENJUALAN','F326160103292','3104435000','1245000','3105680000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1245000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326160103292' 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 ('F326160103293','kasir',' 1',' MEF3E X LT','TOKO','PM-F','F3E-ZCAD-107-0','GL X RANTAI HOLLOW P3 LT 8K ','','1.030','1','100.00','1221000','0','0','15000','1220000','0','0','0','1220000','FIT','00394235','F3E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAD-107-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='F3E-ZCAD-107-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 ('F326160103293','2026-03-16','1.030','2026-03-16','13:03:29','PLG0027721','1220000','1220000','0','1220000','1220000','kasir','2026-03-16 13:03:29','F32616010329');
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-03-16','F326160103293','2026-03-16','13:03:29','FIT','1220000','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-260316-0029','D','2026-03-16','13:03:29','kasir','PENJUALAN','F326160103293','3105680000','1220000','3106900000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1220000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326160103293' 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 ('F326160114511','kasir','1',' MEF3E X LG','TOKO','PM-F','F3E-YKAE-82-0','GL X TIFF DOTTIF CAT HITAM LG 8K ','','0.910','1','100.00','1078000','0','0','15000','1080000','0','0','0','1080000','FIT','00377490','F3E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKAE-82-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='F3E-YKAE-82-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 ('F326160114511','2026-03-16','0.910','2026-03-16','13:14:51','PLG0027722','1080000','1080000','0','1080000','1080000','kasir','2026-03-16 13:14:51','F32616011451');
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-03-16','F326160114511','2026-03-16','13:14:51','FIT','1080000','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-260316-0030','D','2026-03-16','13:14:51','kasir','PENJUALAN','F326160114511','3106900000','1080000','3107980000');
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 ('F326160134241','kasir','1',' MEA1 6K UB','TOKO','PM-A','A1E-YIBI-138-0','AT ANAK BONEKA CAT VAR UB 8K ','','0.830','1','100.00','984000','0','0','15000','985000','0','6000','0','991000','LIS','00371009','A1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YIBI-138-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='A1E-YIBI-138-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 ('F326160134241','2026-03-16','0.830','2026-03-16','13:34:25','PLG0027723','985000','985000','6000','991000','991000','kasir','2026-03-16 13:34:24','F32616013424');
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-03-16','F326160134241','2026-03-16','13:34:25','LIS','991000','6000');
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-260316-0031','D','2026-03-16','13:34:25','kasir','PENJUALAN','F326160134241','3107980000','991000','3108971000');
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 ('F326160135241','kasir','1',' MEA1 5K UB','TOKO','PM-A','A1E-ZCXF-176-0','AT ANAK BONEKA CAT VAR UB 8K ','','0.820','1','100.00','972000','0','0','15000','972000','0','5000','0','977000','LIS','00392431','A1E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZCXF-176-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.820',berat_jual_asli=berat_jual_asli+'0.820',stock_jual='1',berat_akhir=berat_akhir-'0.820',berat_akhir_asli=berat_akhir_asli-'0.820',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='A1E-ZCXF-176-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 ('F326160135241','2026-03-16','0.820','2026-03-16','13:35:24','PLG0027724','972000','972000','5000','977000','977000','kasir','2026-03-16 13:35:24','F32616013524');
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-03-16','F326160135241','2026-03-16','13:35:24','LIS','977000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260316-0032','D','2026-03-16','13:35:24','kasir','PENJUALAN','F326160135241','3108971000','977000','3109948000');
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 ('F326160137041','kasir','1',' MJH2 X UB ','TOKO','PM-H','H2J-ZCAD-75-0','KL X GUCCI UB 44 9K ','','3.010','1','100.00','3898000','0','0','15000','3838000','0','0','0','3838000','FIT','00394203','H2J','0','0','-','1','1295000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZCAD-75-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.010',berat_jual_asli=berat_jual_asli+'3.010',stock_jual='1',berat_akhir=berat_akhir-'3.010',berat_akhir_asli=berat_akhir_asli-'3.010',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='H2J-ZCAD-75-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 ('F326160137041','2026-03-16','3.010','2026-03-16','13:37:05','PLG0027725','3838000','3838000','0','3838000','3838000','kasir','2026-03-16 13:37:04','F32616013704');
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-03-16','F326160137041','2026-03-16','13:37:05','FIT','3838000','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-260316-0033','D','2026-03-16','13:37:05','kasir','PENJUALAN','F326160137041','3109948000','3838000','3113786000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3838000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326160137041' 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 ('F326160137042','kasir',' 1',' MDD2D CM ','TOKO','PM-D','D2D-YIBX-6-0','LT MODEL MATA SLEP CM 8K ','','0.830','1','100.00','967000','0','0','15000','960000','0','0','0','960000','FIT','00369995','D2D','0','0','-','1','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-YIBX-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='D2D-YIBX-6-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 ('F326160137042','2026-03-16','0.830','2026-03-16','13:37:05','PLG0027726','960000','960000','0','960000','960000','kasir','2026-03-16 13:37:04','F32616013704');
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-03-16','F326160137042','2026-03-16','13:37:05','FIT','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,status_valid) VALUES ('KM-260316-0034','D','2026-03-16','13:37:05','kasir','PENJUALAN','F326160137042','3113786000','960000','3114746000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='960000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326160137042' 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 ('F326160156411','kasir','1',' MEF2 UB D5','TOKO','PM-F','F2E-ZCAA-1-0','GL OVAL PAKU MATA VAR UB D54 8K ','','2.640','1','100.00','3128000','0','0','15000','3128000','0','0','0','3128000','SIN','00393503','F2E','0','0','-','0','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZCAA-1-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.640',berat_jual_asli=berat_jual_asli+'2.640',stock_jual='1',berat_akhir=berat_akhir-'2.640',berat_akhir_asli=berat_akhir_asli-'2.640',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='F2E-ZCAA-1-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 ('F326160156411','2026-03-16','2.640','2026-03-16','13:56:42','PLG0027727','3128000','3128000','0','3128000','3128000','kasir','2026-03-16 13:56:41','F32616015641');
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-03-16','F326160156411','2026-03-16','13:56:42','SIN','3128000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260316-0035','D','2026-03-16','13:56:42','kasir','PENJUALAN','F326160156411','3114746000','3128000','3117874000');
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-00018489','X-00018489','KL X MILANO UB 42 9K','GR','---','H2J','BELI','BELI001','1655000','2026-03-16','2.060','1','kasir','2026-03-16 14:04:34');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00018489','X-00018489');
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-260316-0009','F324070955281','FIT','1','BELI','BELI001','H2J', 'X-00018489', 'KL X MILANO UB 42 9K','2.060','2.060','100.00','1425000','1655000','803398','1295000','1','1655000','1655000','RUSAK');
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-03-16' 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-260316-0009','2026-03-16','2026-03-16','14:04:34','FIT','---','2.060','1655000','1655000','1655000','1655000','1655000','kasir','2026-03-16 14:04:34','FB-260316-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260316-0009','YAYUK','KALIWUNGU BANDAR PACITAN','','','','kasir','2026-03-16 14:04:34');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-16' 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-260316-0036','K','2026-03-16','14:04:34','kasir','PEMBELIAN UMUM','FB-260316-0009','3117874000','1655000','3116219000');
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-00018490','X-00018490','GL X TIFF SLEP UB 8K','GR','---','F3E','BELI','BELI001','1020000','2026-03-16','1.030','1','kasir','2026-03-16 14:04:52');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00018490','X-00018490');
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-260316-0010','F325191127523','SIN','1','BELI','BELI001','F3E', 'X-00018490', 'GL X TIFF SLEP UB 8K','1.030','1.030','100.00','1097000','1020000','990291','1195000','1','1020000','1020000','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-03-16' 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-260316-0010','2026-03-16','2026-03-16','14:04:52','SIN','---','1.030','1020000','1020000','1020000','1020000','1020000','kasir','2026-03-16 14:04:52','FB-260316-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260316-0010','TRIANA','KUNTI BADEGAN','','','0881027749248','kasir','2026-03-16 14:04:52');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-16' 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-260316-0037','K','2026-03-16','14:04:52','kasir','PEMBELIAN UMUM','FB-260316-0010','3116219000','1020000','3115199000');
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-00018491','X-00018491','CC X MODEL MATA HW 13 8K','GR','---','E2E','BELI','BELI001','477000','2026-03-16','0.430','1','kasir','2026-03-16 14:06:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018491','X-00018491');
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-260316-0011','F326130922341','FIT','1','BELI','BELI001','E2E', 'X-00018491', 'CC X MODEL MATA HW 13 8K','0.430','0.430','100.00','533000','477000','1109302','1195000','1','477000','477000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.430',berat_beli_asli=berat_beli_asli+'0.430',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.430',berat_akhir_asli=berat_akhir_asli+'0.430',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-16' 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-260316-0011','2026-03-16','2026-03-16','14:06:13','FIT','---','0.430','477000','477000','477000','477000','477000','kasir','2026-03-16 14:06:14','FB-260316-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260316-0011','NATA','NAWANGAN PACITAN','','','083867373416','kasir','2026-03-16 14:06:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-16' 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-260316-0038','K','2026-03-16','14:06:13','kasir','PEMBELIAN UMUM','FB-260316-0011','3115199000','477000','3114722000');
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 ('F326160222181','kasir','1',' MDE2 X PM ','TOKO','PM-E','E2D-YLCX-38-0','CC X MODEL MATA PM 12 8K ','','0.970','1','100.00','1130000','0','0','15000','1130000','0','0','0','1130000','LIS','00383443','E2D','0','0','-','0','1175000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YLCX-38-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='E2D-YLCX-38-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 ('F326160222181','2026-03-16','0.970','2026-03-16','14:22:18','PLG0027728','1130000','1130000','0','1130000','1130000','kasir','2026-03-16 14:22:18','F32616022218');
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-03-16','F326160222181','2026-03-16','14:22:18','LIS','1130000','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-260316-0039','D','2026-03-16','14:22:18','kasir','PENJUALAN','F326160222181','3114722000','1130000','3115852000');
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 ('F326160235491','kasir','1',' MEF3E X KH','TOKO','PM-F','F3E-ZAAE-67-0','GL X TIFF SLEP KH 8K ','','2.030','1','100.00','2406000','0','0','15000','2405000','0','0','0','2405000','SIN','00385316','F3E','0','0','-','1','1195000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZAAE-67-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-03-16' AND kode_barang='F3E-ZAAE-67-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 ('F326160235491','2026-03-16','2.030','2026-03-16','14:35:50','PLG0027729','2405000','2405000','0','2405000','2405000','kasir','2026-03-16 14:35:49','F32616023549');
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-03-16','F326160235491','2026-03-16','14:35:50','SIN','2405000','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-260316-0040','D','2026-03-16','14:35:50','kasir','PENJUALAN','F326160235491','3115852000','2405000','3118257000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2405000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326160235491' 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 ('F326160235492','kasir',' 1',' MGS1G X DG','TOKO','PM-S','S1G-ZCXG-295-0','AS X EXTENTION DG 8K ','','0.310','1','100.00','383000','0','0','15000','380000','0','0','0','380000','SIN','00392731','S1G','0','0','-','1','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-03-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZCXG-295-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-03-16' AND kode_barang='S1G-ZCXG-295-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-S' 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 ('F326160235492','2026-03-16','0.310','2026-03-16','14:35:50','PLG0027730','380000','380000','0','380000','380000','kasir','2026-03-16 14:35:49','F32616023549');
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-03-16','F326160235492','2026-03-16','14:35:50','SIN','380000','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-260316-0041','D','2026-03-16','14:35:50','kasir','PENJUALAN','F326160235492','3118257000','380000','3118637000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='380000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326160235492' LIMIT 1;
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260316-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260316-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260316-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260316-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260316-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260316-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260316-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260316-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260316-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260316-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260316-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260316-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260316-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260316-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260316-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260316-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260316-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260316-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260316-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260316-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260316-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260316-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160103291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160103291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160103291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160103292' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160103292' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160103292';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160103293' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160103293' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160103293';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160114511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160114511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160114511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160134241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160134241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160134241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160135241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160135241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160135241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160137041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160137041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160137041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160137042' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160137042' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160137042';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160156411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160156411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160156411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160222181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160222181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160222181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160235491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160235491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160235491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160235492' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160235492' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160235492';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160921441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160921441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160921441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160944171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160944171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160944171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160952571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160952571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160952571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161013251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161013251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161013251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161013252' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161013252' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161013252';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161035441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161035441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161035441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161059501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161059501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161059501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161059502' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161059502' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161059502';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161132321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161132321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161132321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161156211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161156211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161156211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161156212' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161156212' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161156212';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161157161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161157161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161157161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161209151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161209151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161209151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161218081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161218081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161218081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161218082' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161218082' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161218082';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161224491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161224491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161224491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161225101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161225101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161225101';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-17','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-02-14';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-16';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-16';
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-03-16' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-16';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-16';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-16';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-16';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202602 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-02';
UPDATE tt_barang_saldo SET tanggal= '2026-03-17' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-16' 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-260317-0001','D','2026-03-17','15:21:17','SYSTEM','SALDO AWAL','SALDO AWAL','0','3118637000','3118637000');
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-260317-0001','D','2026-03-17','15:21:17','BCA','SALDO AWAL','SALDO AWAL','0','707186000','707186000');
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-260317-0001','D','2026-03-17','15:21:17','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-260317-0001','D','2026-03-17','15:21:17','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-03-17';