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 ('F326010908411','input','1',' MEF3E X HW','TOKO','PM-F','F3E-ZBAD-186-0','GL X FANCY SLEP HW 8K ','','2.730','1','100.00','3399000','0','0','15000','3400000','0','0','0','3400000','FIT','00389792','F3E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBAD-186-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.730',berat_jual_asli=berat_jual_asli+'2.730',stock_jual='1',berat_akhir=berat_akhir-'2.730',berat_akhir_asli=berat_akhir_asli-'2.730',stock_akhir='0' WHERE tanggal='2026-03-01' AND kode_barang='F3E-ZBAD-186-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 ('F326010908411','2026-03-01','2.730','2026-03-01','09:08:42','PLG0027382','3400000','3400000','0','3400000','3400000','input','2026-03-01 09:08:41','F32601090841');
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-01','F326010908411','2026-03-01','09:08:42','FIT','3400000','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-260301-0002','D','2026-03-01','09:08:42','input','PENJUALAN','F326010908411','2662759000','3400000','2666159000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010908411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010908411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010908411';
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 ('F326010919141','kasir','1',' MEF3E X LT','TOKO','PM-F','F3E-ZBXF-42-0','FL X FLIK ANAK SLEP LT 8K ','','1.980','1','100.00','2465000','0','0','15000','2465000','0','0','0','2465000','FIT','00388624','F3E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBXF-42-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-03-01' AND kode_barang='F3E-ZBXF-42-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 ('F326010919141','2026-03-01','1.980','2026-03-01','09:19:14','PLG0027383','2465000','2465000','0','2465000','2465000','kasir','2026-03-01 09:19:14','F32601091914');
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-01','F326010919141','2026-03-01','09:19:14','FIT','2465000','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-260301-0004','D','2026-03-01','09:19:14','kasir','PENJUALAN','F326010919141','2662759000','2465000','2665224000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2465000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326010919141' 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 ('F326010919142','kasir',' 1',' MDE2 X 5K ','TOKO','PM-E','E2D-YLBC-233-0','CC X ANAK BONEKA CAT MATA VAR LG 8K ','','1.170','1','100.00','1433000','0','0','15000','1433000','0','5000','0','1438000','FIT','00382676','E2D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YLBC-233-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.170',berat_jual_asli=berat_jual_asli+'1.170',stock_jual='1',berat_akhir=berat_akhir-'1.170',berat_akhir_asli=berat_akhir_asli-'1.170',stock_akhir='0' WHERE tanggal='2026-03-01' AND kode_barang='E2D-YLBC-233-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 ('F326010919142','2026-03-01','1.170','2026-03-01','09:19:14','PLG0027384','1433000','1433000','5000','1438000','1438000','kasir','2026-03-01 09:19:14','F32601091914');
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-01','F326010919142','2026-03-01','09:19:14','FIT','1438000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260301-0005','D','2026-03-01','09:19:14','kasir','PENJUALAN','F326010919142','2665224000','1438000','2666662000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1438000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326010919142' 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 ('F326010940271','kasir','1',' MEF3 LT ','TOKO','PM-F','F3E-YKBH-100-0','GL ANAK TRIXIE MODEL VAR LT 8K ','','1.010','1','100.00','1257000','0','0','15000','1258000','0','0','0','1258000','FIT','00378961','F3E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKBH-100-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-01' AND kode_barang='F3E-YKBH-100-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 ('F326010940271','2026-03-01','1.010','2026-03-01','09:40:27','PLG0027385','1258000','1258000','0','1258000','1258000','kasir','2026-03-01 09:40:27','F32601094027');
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-01','F326010940271','2026-03-01','09:40:27','FIT','1258000','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-260301-0006','D','2026-03-01','09:40:27','kasir','PENJUALAN','F326010940271','2666662000','1258000','2667920000');
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 ('F326010943191','kasir','1',' MDE1 CM 18','TOKO','PM-E','E1D-ZAXH-110-T','CC MODEL DAUN VAR CM 18 8K ','','1.000','1','100.00','1225000','0','0','15000','1225000','0','0','0','1225000','AAT','T0076433','E1D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZAXH-110-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-03-01' AND kode_barang='E1D-ZAXH-110-T' 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 ('F326010943191','2026-03-01','1.000','2026-03-01','09:43:20','PLG0027386','1225000','1225000','0','1225000','1225000','kasir','2026-03-01 09:43:19','F32601094319');
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-01','F326010943191','2026-03-01','09:43:20','AAT','1225000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260301-0007','D','2026-03-01','09:43:20','kasir','PENJUALAN','F326010943191','2667920000','1225000','2669145000');
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 ('F326010944231','kasir','1',' MEE1 X CM ','TOKO','PM-E','E1E-ZBAA-132-0','CC X MODEL SLEP CM 14 8K ','','0.710','1','100.00','884000','0','0','15000','885000','0','0','0','885000','SIN','00389278','E1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZBAA-132-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.710',berat_jual_asli=berat_jual_asli+'0.710',stock_jual='1',berat_akhir=berat_akhir-'0.710',berat_akhir_asli=berat_akhir_asli-'0.710',stock_akhir='0' WHERE tanggal='2026-03-01' AND kode_barang='E1E-ZBAA-132-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 ('F326010944231','2026-03-01','0.710','2026-03-01','09:44:23','PLG0027387','885000','885000','0','885000','885000','kasir','2026-03-01 09:44:23','F32601094423');
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-01','F326010944231','2026-03-01','09:44:23','SIN','885000','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-260301-0008','D','2026-03-01','09:44:23','kasir','PENJUALAN','F326010944231','2669145000','885000','2670030000');
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 ('F326010948571','kasir','1',' MIH2 X KH ','TOKO','PM-H','H2I-YKAG-83-0','KL X SANTA KH 44 9K ','','4.850','1','100.00','6426000','0','0','15000','6425000','0','0','0','6425000','FIT','00377659','H2I','0','0','-','1','1325000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YKAG-83-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.850',berat_jual_asli=berat_jual_asli+'4.850',stock_jual='1',berat_akhir=berat_akhir-'4.850',berat_akhir_asli=berat_akhir_asli-'4.850',stock_akhir='0' WHERE tanggal='2026-03-01' AND kode_barang='H2I-YKAG-83-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 ('F326010948571','2026-03-01','4.850','2026-03-01','09:48:58','PLG0027388','6425000','6425000','0','6425000','6425000','kasir','2026-03-01 09:48:57','F32601094857');
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-01','F326010948571','2026-03-01','09:48:58','FIT','6425000','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-260301-0009','D','2026-03-01','09:48:58','kasir','PENJUALAN','F326010948571','2670030000','6425000','2676455000');
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 ('F326010955141','kasir','1',' MGD1G X HW','TOKO','PM-D','D1G-ZAAF-75-0','LT X SLOBOK RIBBON SLEP HW 8K','GT UNTIR','0.320','1','100.00','411000','0','0','15000','412000','0','30000','0','442000','FIT','00385526','D1G','0','0','-','0','1285000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZAAF-75-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2026-03-01' AND kode_barang='D1G-ZAAF-75-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 ('F326010955141','2026-03-01','0.320','2026-03-01','09:55:15','PLG0027389','412000','412000','30000','442000','442000','kasir','2026-03-01 09:55:14','F32601095514');
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-01','F326010955141','2026-03-01','09:55:15','FIT','442000','30000');
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-260301-0010','D','2026-03-01','09:55:15','kasir','PENJUALAN','F326010955141','2676455000','442000','2676897000');
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 ('F326011012491','kasir','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZBAD-270-0','CC X MODEL MATA CM 10 8K ','','0.930','1','100.00','1139000','0','0','15000','1140000','0','0','0','1140000','FIT','00389876','E2D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZBAD-270-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-01' AND kode_barang='E2D-ZBAD-270-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 ('F326011012491','2026-03-01','0.930','2026-03-01','10:12:50','PLG0027390','1140000','1140000','0','1140000','1140000','kasir','2026-03-01 10:12:49','F32601101249');
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-01','F326011012491','2026-03-01','10:12:50','FIT','1140000','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-260301-0011','D','2026-03-01','10:12:50','kasir','PENJUALAN','F326011012491','2676897000','1140000','2678037000');
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 ('F326011028181','kasir','1',' MDE2 X KH ','TOKO','PM-E','E2D-YEXA-128-0','CC X MODEL MATA KH 12 8K ','','1.000','1','100.00','1225000','0','0','15000','1225000','0','0','0','1225000','FIT','00351721','E2D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YEXA-128-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-03-01' AND kode_barang='E2D-YEXA-128-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326011028181','2026-03-01','1.000','2026-03-01','10:28:18','PLG0027391','1225000','1225000','0','1225000','1225000','kasir','2026-03-01 10:28:18','F32601102818');
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-01','F326011028181','2026-03-01','10:28:18','FIT','1225000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260301-0012','D','2026-03-01','10:28:18','kasir','PENJUALAN','F326011028181','2678037000','1225000','2679262000');
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 ('F326011030461','kasir','1',' MEF1 X YT ','TOKO','PM-F','F1E-YKAA-88-0','GL X OVAL C SLEP YT 60 8K ','','3.600','1','100.00','4482000','0','0','15000','4483000','0','0','0','4483000','SIN','00377054','F1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YKAA-88-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.600',berat_jual_asli=berat_jual_asli+'3.600',stock_jual='1',berat_akhir=berat_akhir-'3.600',berat_akhir_asli=berat_akhir_asli-'3.600',stock_akhir='0' WHERE tanggal='2026-03-01' AND kode_barang='F1E-YKAA-88-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 ('F326011030461','2026-03-01','3.600','2026-03-01','10:30:47','PLG0027392','4483000','4483000','0','4483000','4483000','kasir','2026-03-01 10:30:46','F32601103046');
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-01','F326011030461','2026-03-01','10:30:47','SIN','4483000','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-260301-0013','D','2026-03-01','10:30:47','kasir','PENJUALAN','F326011030461','2679262000','4483000','2683745000');
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 ('F326011033521','kasir','1',' MDE1 X M4 ','TOKO','PM-E','E1D-YLCX-170-0','CC X VELG KACA M4 18 8K ','','1.540','1','100.00','1886000','0','0','15000','1885000','0','0','0','1885000','AAT','00383575','E1D','0','0','-','1','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YLCX-170-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.540',berat_jual_asli=berat_jual_asli+'1.540',stock_jual='1',berat_akhir=berat_akhir-'1.540',berat_akhir_asli=berat_akhir_asli-'1.540',stock_akhir='0' WHERE tanggal='2026-03-01' AND kode_barang='E1D-YLCX-170-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 ('F326011033521','2026-03-01','1.540','2026-03-01','10:33:53','PLG0027393','1885000','1885000','0','1885000','1885000','kasir','2026-03-01 10:33:52','F32601103352');
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-01','F326011033521','2026-03-01','10:33:53','AAT','1885000','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-260301-0014','D','2026-03-01','10:33:53','kasir','PENJUALAN','F326011033521','2683745000','1885000','2685630000');
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 ('F326011037031','kasir','1',' MFF3F X UB','TOKO','PM-F','F3F-ZBAA-178-0','GL X KOREA SLEP UB 8K ','','0.460','1','100.00','582000','0','0','15000','583000','0','0','0','583000','FIT','00389324','F3F','0','0','-','0','1265000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3F-ZBAA-178-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-03-01' AND kode_barang='F3F-ZBAA-178-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 ('F326011037031','2026-03-01','0.460','2026-03-01','10:37:04','PLG0027394','583000','583000','0','583000','583000','kasir','2026-03-01 10:37:03','F32601103703');
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-01','F326011037031','2026-03-01','10:37:04','FIT','583000','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-260301-0015','D','2026-03-01','10:37:04','kasir','PENJUALAN','F326011037031','2685630000','583000','2686213000');
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 ('F326011049371','kasir','1',' MDE2 CM 14','TOKO','PM-E','E2D-YIBI-59-T','CC MODEL MATA VAR CM 14 8K ','','0.880','1','100.00','1078000','0','0','15000','1078000','0','0','0','1078000','SIN','T0073372','E2D','0','0','-','0','1235000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIBI-59-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.880',berat_jual_asli=berat_jual_asli+'0.880',stock_jual='1',berat_akhir=berat_akhir-'0.880',berat_akhir_asli=berat_akhir_asli-'0.880',stock_akhir='0' WHERE tanggal='2026-03-01' AND kode_barang='E2D-YIBI-59-T' 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 ('F326011049371','2026-03-01','0.880','2026-03-01','10:49:38','PLG0027395','1078000','1078000','0','1078000','1078000','kasir','2026-03-01 10:49:37','F32601104937');
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-01','F326011049371','2026-03-01','10:49:38','SIN','1078000','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-260301-0016','D','2026-03-01','10:49:38','kasir','PENJUALAN','F326011049371','2686213000','1078000','2687291000');
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 ('F326011120441','kasir','1',' MEF1 X 10K','TOKO','PM-F','F1E-YLBC-230-0','GL X OSROT ANAK BONEKA CAT LG 8K ','','1.550','1','100.00','1930000','0','0','15000','1930000','0','10000','0','1940000','AAT','00382673','F1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YLBC-230-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-01' AND kode_barang='F1E-YLBC-230-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 ('F326011120441','2026-03-01','1.550','2026-03-01','11:20:44','PLG0027396','1930000','1930000','10000','1940000','1940000','kasir','2026-03-01 11:20:44','F32601112044');
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-01','F326011120441','2026-03-01','11:20:44','AAT','1940000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260301-0017','D','2026-03-01','11:20:44','kasir','PENJUALAN','F326011120441','2687291000','1940000','2689231000');
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 ('F326011147411','kasir','1',' MEA1 CM ','TOKO','PM-A','A1E-ZAAI-101-0','AT JERSY POLOS CM 8K ','','0.580','1','100.00','722000','0','0','15000','723000','0','0','0','723000','FIT','00386040','A1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZAAI-101-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-03-01' AND kode_barang='A1E-ZAAI-101-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 ('F326011147411','2026-03-01','0.580','2026-03-01','11:47:41','PLG0027397','723000','723000','0','723000','723000','kasir','2026-03-01 11:47:41','F32601114741');
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-01','F326011147411','2026-03-01','11:47:41','FIT','723000','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-260301-0018','D','2026-03-01','11:47:41','kasir','PENJUALAN','F326011147411','2689231000','723000','2689954000');
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 ('F326010138131','kasir','1',' MEF3E X HW','TOKO','PM-F','F3E-ZBXF-25-0','GL X TIFF SLEP HW 8K ','','1.100','1','100.00','1369000','0','0','15000','1370000','0','0','0','1370000','FIT','00388607','F3E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZBXF-25-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-03-01' AND kode_barang='F3E-ZBXF-25-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 ('F326010138131','2026-03-01','1.100','2026-03-01','13:38:13','PLG0027398','1370000','1370000','0','1370000','1370000','kasir','2026-03-01 13:38:13','F32601013813');
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-01','F326010138131','2026-03-01','13:38:13','FIT','1370000','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-260301-0019','D','2026-03-01','13:38:13','kasir','PENJUALAN','F326010138131','2689954000','1370000','2691324000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1370000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326010138131' 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 ('F326010138132','kasir',' 1',' MEE1 X LG ','TOKO','PM-E','E1E-ZBBE-89-0','CC X MODEL DAUN SLEP LG 16 8K ','','0.450','1','100.00','560000','0','0','15000','560000','0','0','0','560000','FIT','00391235','E1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZBBE-89-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-01' AND kode_barang='E1E-ZBBE-89-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 ('F326010138132','2026-03-01','0.450','2026-03-01','13:38:13','PLG0027399','560000','560000','0','560000','560000','kasir','2026-03-01 13:38:13','F32601013813');
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-01','F326010138132','2026-03-01','13:38:13','FIT','560000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260301-0020','D','2026-03-01','13:38:13','kasir','PENJUALAN','F326010138132','2691324000','560000','2691884000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='560000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326010138132' 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 ('F326010201081','kasir','1',' MEH1 X UB ','TOKO','PM-H','H1E-ZBAA-189-0','KL X MILANO UB 42 8K ','','2.110','1','100.00','2627000','0','0','15000','2628000','0','0','0','2628000','AAT','00389335','H1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZBAA-189-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.110',berat_jual_asli=berat_jual_asli+'2.110',stock_jual='1',berat_akhir=berat_akhir-'2.110',berat_akhir_asli=berat_akhir_asli-'2.110',stock_akhir='0' WHERE tanggal='2026-03-01' AND kode_barang='H1E-ZBAA-189-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 ('F326010201081','2026-03-01','2.110','2026-03-01','14:01:08','PLG0027400','2628000','2628000','0','2628000','2628000','kasir','2026-03-01 14:01:08','F32601020108');
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-01','F326010201081','2026-03-01','14:01:08','AAT','2628000','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-260301-0021','D','2026-03-01','14:01:08','kasir','PENJUALAN','F326010201081','2691884000','2628000','2694512000');
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 ('F326010218051','input','1',' MEB1E HW ','TOKO','PM-B','B1E-YKBF-175-0','GW ITALY DAUN SLEP HW 8K ','','0.760','1','100.00','946000','0','0','15000','946000','0','0','0','946000','SIN','00378847','B1E','0','0','-','0','1255000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YKBF-175-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2026-03-01' AND kode_barang='B1E-YKBF-175-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326010218051','2026-03-01','0.760','2026-03-01','14:18:06','PLG0027401','946000','946000','0','946000','946000','input','2026-03-01 14:18:05','F32601021805');
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-01','F326010218051','2026-03-01','14:18:06','SIN','946000','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-260301-0022','D','2026-03-01','14:18:06','input','PENJUALAN','F326010218051','2694512000','946000','2695458000');
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 ('F326010240521','input','1',' TAE0 DW 16','TOKO','PT-E','E0TA-WEXB-43-T','CC POLOS DW 16 ','','3.000','1','100.00','6540000','0','0','15000','6540000','0','0','0','6540000','FIT','T0043854','E0TA','0','0','-','0','2180000');
UPDATE tm_barang SET tgl_last_jual='2026-03-01', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0TA-WEXB-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.000',berat_jual_asli=berat_jual_asli+'3.000',stock_jual='1',berat_akhir=berat_akhir-'3.000',berat_akhir_asli=berat_akhir_asli-'3.000',stock_akhir='0' WHERE tanggal='2026-03-01' AND kode_barang='E0TA-WEXB-43-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326010240521','2026-03-01','3.000','2026-03-01','14:40:53','PLG0027402','6540000','6540000','0','6540000','6540000','input','2026-03-01 14:40:52','F32601024052');
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-01','F326010240521','2026-03-01','14:40:53','FIT','6540000','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-260301-0023','D','2026-03-01','14:40:53','input','PENJUALAN','F326010240521','2695458000','6540000','2701998000');
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-00018326','X-00018326','GL X PAPERLINA ANAK VAR LT','GR','---','F3E','BELI','BELI001','1545000','2026-03-01','1.980','1','kasir','2026-03-01 14:51:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00018326','X-00018326');
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-260301-0001','F322090226111','FIT','1','BELI','BELI001','F3E', 'X-00018326', 'GL X PAPERLINA ANAK VAR LT','3.030','1.980','100.00','1245000','1545000','780303','1255000','1','1545000','1545000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.980',berat_beli_asli=berat_beli_asli+'1.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.980',berat_akhir_asli=berat_akhir_asli+'1.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-01' 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-260301-0001','2026-03-01','2026-03-01','14:51:37','FIT','---','1.980','1545000','1545000','1545000','1545000','1545000','kasir','2026-03-01 14:51:38','FB-260301-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260301-0001','DIAN','JERUK','','','','kasir','2026-03-01 14:51:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-01' 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-260301-0024','K','2026-03-01','14:51:37','kasir','PEMBELIAN UMUM','FB-260301-0001','2701998000','1545000','2700453000');
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-00018327','X-00018327','KL X GUCCI UB 42 8K','GR','---','H1E','BELI','BELI001','1292000','2026-03-01','1.120','1','kasir','2026-03-01 14:51:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00018327','X-00018327');
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-260301-0002','F326011117471','FIT','1','BELI','BELI001','H1E', 'X-00018327', 'KL X GUCCI UB 42 8K','1.120','1.120','100.00','1390000','1292000','1153571','1255000','1','1292000','1292000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.120',berat_beli_asli=berat_beli_asli+'1.120',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.120',berat_akhir_asli=berat_akhir_asli+'1.120',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260301-0002','2026-03-01','2026-03-01','14:51:57','FIT','---','1.120','1292000','1292000','1292000','1292000','1292000','kasir','2026-03-01 14:51:57','FB-260301-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260301-0002','ARDI','BUGELAN KISMANTORO','','','','kasir','2026-03-01 14:51:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-01' 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-260301-0025','K','2026-03-01','14:51:57','kasir','PEMBELIAN UMUM','FB-260301-0002','2700453000','1292000','2699161000');
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-00018328','X-00018328','CC X MODEL MATA UB 12 8K','GR','---','E2E','BELI','BELI001','1020000','2026-03-01','1.450','1','kasir','2026-03-01 14:53:42');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018328','X-00018328');
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-260301-0003','F324241031141','FIT','1','BELI','BELI001','E2E', 'X-00018328', 'CC X MODEL MATA UB 12 8K','1.450','1.450','100.00','870000','1020000','703448','1255000','1','1020000','1020000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.450',berat_beli_asli=berat_beli_asli+'1.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.450',berat_akhir_asli=berat_akhir_asli+'1.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-01' 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-260301-0003','2026-03-01','2026-03-01','14:53:42','FIT','---','1.450','1020000','1020000','1020000','1020000','1020000','kasir','2026-03-01 14:53:42','FB-260301-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260301-0003','MAYA','BANDAR PACITAN','','','','kasir','2026-03-01 14:53:42');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-01' 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-260301-0026','K','2026-03-01','14:53:42','kasir','PEMBELIAN UMUM','FB-260301-0003','2699161000','1020000','2698141000');
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-00018329','X-00018329','GL XX OVAL C GELOMBANG TD 60 8K','GR','---','F2E','BELI','BELI001','2960000','2026-03-01','2.920','1','kasir','2026-03-01 14:54:05');
DELETE FROM tp_barang WHERE kode_dept = 'X-F2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00018329','X-00018329');
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-260301-0004','F326070950351','FIT','1','BELI','BELI001','F2E', 'X-00018329', 'GL XX OVAL C GELOMBANG TD 60 8K','2.920','2.920','100.00','3115000','2960000','1013699','1255000','1','2960000','2960000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.920',berat_beli_asli=berat_beli_asli+'2.920',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.920',berat_akhir_asli=berat_akhir_asli+'2.920',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F2E' 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-260301-0004','2026-03-01','2026-03-01','14:54:04','FIT','---','2.920','2960000','2960000','2960000','2960000','2960000','kasir','2026-03-01 14:54:05','FB-260301-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260301-0004','YOSY','WONOSARI SLOGOHIMO','','','082313681521','kasir','2026-03-01 14:54:05');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-01' 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-260301-0027','K','2026-03-01','14:54:04','kasir','PEMBELIAN UMUM','FB-260301-0004','2698141000','2960000','2695181000');
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-00018330','X-00018330','CC X MODEL MATA BM 12 8K','GR','---','E2D','BELI','BELI001','885000','2026-03-01','0.800','1','kasir','2026-03-01 14:54:19');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00018330','X-00018330');
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-260301-0005','F326021132191','AAT','1','BELI','BELI001','E2D', 'X-00018330', 'CC X MODEL MATA BM 12 8K','0.800','0.800','100.00','953000','885000','1106250','1235000','1','885000','885000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.800',berat_beli_asli=berat_beli_asli+'0.800',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.800',berat_akhir_asli=berat_akhir_asli+'0.800',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260301-0005','2026-03-01','2026-03-01','14:54:18','AAT','---','0.800','885000','885000','885000','885000','885000','kasir','2026-03-01 14:54:19','FB-260301-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260301-0005','ANA NUR RAHAYU','SLOGOHIMO','','','','kasir','2026-03-01 14:54:19');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-01' 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-260301-0028','K','2026-03-01','14:54:18','kasir','PEMBELIAN UMUM','FB-260301-0005','2695181000','885000','2694296000');
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-00018331','X-00018331','KL X TOSCA HW 42CM','GR','---','H1TF','BELI','BELI001','5277000','2026-03-01','3.010','1','kasir','2026-03-01 14:54:41');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1TF','X-00018331','X-00018331');
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-260301-0006','F324011055471','AAT','1','BELI','BELI001','H1TF', 'X-00018331', 'KL X TOSCA HW 42CM','3.010','3.010','100.00','3582000','5277000','1753156','2290000','1','5277000','5277000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.010',berat_beli_asli=berat_beli_asli+'3.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.010',berat_akhir_asli=berat_akhir_asli+'3.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1TF' 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-260301-0006','2026-03-01','2026-03-01','14:54:40','AAT','---','3.010','5277000','5277000','5277000','5277000','5277000','kasir','2026-03-01 14:54:41','FB-260301-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260301-0006','WIDYANTI','BITING','','','','kasir','2026-03-01 14:54:41');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-01' 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-260301-0029','K','2026-03-01','14:54:40','kasir','PEMBELIAN UMUM','FB-260301-0006','2694296000','5277000','2689019000');
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-00018332','X-00018332','KL POLOS 9K','GR','---','H2J','BELI','BELI001','1000000','2026-03-01','1.150','1','kasir','2026-03-01 14:56:14');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2J';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2J','X-00018332','X-00018332');
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-260301-0007','F323280224281','FIT','1','BELI','BELI001','H2J', 'X-00018332', 'KL POLOS 9K','1.150','1.150','100.00','580000','1000000','869565','1355000','1','1000000','1000000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.150',berat_beli_asli=berat_beli_asli+'1.150',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.150',berat_akhir_asli=berat_akhir_asli+'1.150',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-01' 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-260301-0007','2026-03-01','2026-03-01','14:56:14','FIT','---','1.150','1000000','1000000','1000000','1000000','1000000','kasir','2026-03-01 14:56:14','FB-260301-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260301-0007','NUR HAYATI','JERUK PACITAN','','','','kasir','2026-03-01 14:56:14');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-01' 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-260301-0030','K','2026-03-01','14:56:14','kasir','PEMBELIAN UMUM','FB-260301-0007','2689019000','1000000','2688019000');
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-00018333','X-00018333','CC X SOLITAIRE MATA CM 14 8K','GR','---','E2D','BELI','BELI001','770000','2026-03-01','1.110','1','kasir','2026-03-01 14:56:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00018333','X-00018333');
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-260301-0008','F325291058431','FIT','1','BELI','BELI001','E2D', 'X-00018333', 'CC X SOLITAIRE MATA CM 14 8K','1.110','1.110','100.00','750000','770000','693694','1235000','1','770000','770000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.110',berat_beli_asli=berat_beli_asli+'1.110',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.110',berat_akhir_asli=berat_akhir_asli+'1.110',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-01' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260301-0008','2026-03-01','2026-03-01','14:56:42','FIT','---','1.110','770000','770000','770000','770000','770000','kasir','2026-03-01 14:56:43','FB-260301-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260301-0008','DELLA','SLOGOHIMO','','','','kasir','2026-03-01 14:56:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-01' 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-260301-0031','K','2026-03-01','14:56:42','kasir','PEMBELIAN UMUM','FB-260301-0008','2688019000','770000','2687249000');
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-00018334','X-00018334','GL X TRIXIE CLOVER HITAM VAR SERUT YT 8K','GR','---','F3F','BELI','BELI001','1035000','2026-03-01','1.450','1','kasir','2026-03-01 14:57:08');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3F','X-00018334','X-00018334');
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-260301-0009','F324180130331','AAT','1','BELI','BELI001','F3F', 'X-00018334', 'GL X TRIXIE CLOVER HITAM VAR SERUT YT 8K','1.550','1.450','100.00','773000','1035000','713793','1265000','1','1035000','1035000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.450',berat_beli_asli=berat_beli_asli+'1.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.450',berat_akhir_asli=berat_akhir_asli+'1.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-03-01' 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-260301-0009','2026-03-01','2026-03-01','14:57:07','AAT','---','1.450','1035000','1035000','1035000','1035000','1035000','kasir','2026-03-01 14:57:08','FB-260301-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260301-0009','SINDI','GESING KISMANTORO','','','','kasir','2026-03-01 14:57:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-03-01' 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-260301-0032','K','2026-03-01','14:57:07','kasir','PEMBELIAN UMUM','FB-260301-0009','2687249000','1035000','2686214000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260301-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260301-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260301-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260301-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260301-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260301-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260301-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260301-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260301-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260301-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260301-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260301-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260301-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260301-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260301-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260301-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260301-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260301-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010138131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010138131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010138131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010138132' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010138132' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010138132';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010201081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010201081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010201081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010218051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010218051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010218051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010240521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010240521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010240521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010919141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010919141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010919141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010919142' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010919142' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010919142';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010940271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010940271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010940271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010943191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010943191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010943191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010944231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010944231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010944231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010948571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010948571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010948571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326010955141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326010955141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326010955141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011012491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011012491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011012491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011028181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011028181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011028181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011030461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011030461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011030461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011033521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011033521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011033521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011037031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011037031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011037031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011049371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011049371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011049371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011120441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011120441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011120441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326011147411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326011147411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326011147411';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-03-02','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-30';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-03-01';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-03-01';
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-01' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-03-01';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-03-01';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-03-01';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-03-01';
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-02' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-03-01' 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-260302-0001','D','2026-03-02','15:48:06','SYSTEM','SALDO AWAL','SALDO AWAL','0','2686214000','2686214000');
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-260302-0001','D','2026-03-02','15:48:06','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260302-0001','D','2026-03-02','15:48:06','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-260302-0001','D','2026-03-02','15:48:06','BCA','SALDO AWAL','SALDO AWAL','0','707186000','707186000');
UPDATE tp_system SET tgl_system='2026-03-02';