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 ('F326050856301','input','1',' MEH1 KH 42','TOKO','PM-H','H1E-ZDXA-39-0','KL SANTA KH 42CM 8K ','','2.020','1','100.00','2343000','0','0','15000','2343000','0','0','0','2343000','AAT','00397518','H1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDXA-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='H1E-ZDXA-39-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 ('F326050856301','2026-04-05','2.020','2026-04-05','08:56:30','PLG0028444','2343000','2343000','0','2343000','2343000','input','2026-04-05 08:56:30','F32605085630');
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-04-05','F326050856301','2026-04-05','08:56:30','AAT','2343000','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-260405-0002','D','2026-04-05','08:56:30','input','PENJUALAN','F326050856301','4205256000','2343000','4207599000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2343000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326050856301' 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 ('F326050856302','input',' 1',' MFD2F X LG','TOKO','PM-D','D2F-WBAC-426-0','LT X MODEL HURUF MATA LG P ','','0.460','1','100.00','543000','0','0','15000','542000','0','0','0','542000','AAT','00213730','D2F','0','0','-','1','1190000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2F-WBAC-426-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-04-05' AND kode_barang='D2F-WBAC-426-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 ('F326050856302','2026-04-05','0.460','2026-04-05','08:56:30','PLG0028445','542000','542000','0','542000','542000','input','2026-04-05 08:56:30','F32605085630');
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-04-05','F326050856302','2026-04-05','08:56:30','AAT','542000','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-260405-0003','D','2026-04-05','08:56:30','input','PENJUALAN','F326050856302','4207599000','542000','4208141000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='542000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326050856302' 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 ('F326050930141','input','1',' MEA1 UB ','TOKO','PM-A','A1E-ZBAI-303-0','AT JERSY SLEP UB 8K ','','0.400','1','100.00','464000','0','0','15000','465000','0','0','0','465000','LIS','00390975','A1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZBAI-303-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='A1E-ZBAI-303-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 ('F326050930141','2026-04-05','0.400','2026-04-05','09:30:15','PLG0028446','465000','465000','0','465000','465000','input','2026-04-05 09:30:14','F32605093014');
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-04-05','F326050930141','2026-04-05','09:30:15','LIS','465000','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-260405-0004','D','2026-04-05','09:30:15','input','PENJUALAN','F326050930141','4208141000','465000','4208606000');
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 ('F326050931131','input','1',' MDE2 X CM ','TOKO','PM-E','E2D-YLXH-79-0','CC X LISTERING MATA CM 18 8K ','','0.850','1','100.00','969000','0','0','15000','970000','0','0','0','970000','FIT','00380201','E2D','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YLXH-79-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='E2D-YLXH-79-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 ('F326050931131','2026-04-05','0.850','2026-04-05','09:31:14','PLG0028447','970000','970000','0','970000','970000','input','2026-04-05 09:31:13','F32605093113');
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-04-05','F326050931131','2026-04-05','09:31:14','FIT','970000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260405-0005','D','2026-04-05','09:31:14','input','PENJUALAN','F326050931131','4208606000','970000','4209576000');
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 ('F326050934081','input','1',' MEF1 HW 40','TOKO','PM-F','F1E-ZCAG-209-0','GL BANGKOK C ANAK SLEP HW 40 8K','','1.780','1','100.00','2065000','0','0','15000','2065000','0','0','0','2065000','SIN','00394927','F1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCAG-209-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.780',berat_jual_asli=berat_jual_asli+'1.780',stock_jual='1',berat_akhir=berat_akhir-'1.780',berat_akhir_asli=berat_akhir_asli-'1.780',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='F1E-ZCAG-209-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 ('F326050934081','2026-04-05','1.780','2026-04-05','09:34:08','PLG0028448','2065000','2065000','0','2065000','2065000','input','2026-04-05 09:34:08','F32605093408');
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-04-05','F326050934081','2026-04-05','09:34:08','SIN','2065000','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-260405-0006','D','2026-04-05','09:34:08','input','PENJUALAN','F326050934081','4209576000','2065000','4211641000');
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 ('F326050938001','input','1',' MEF3E X KH','TOKO','PM-F','F3E-YFBH-84-0','GL X KREPYAK SLEP KH 8K ','','7.180','1','100.00','8329000','0','0','15000','8330000','0','0','0','8330000','AAT','00358792','F3E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YFBH-84-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'7.180',berat_jual_asli=berat_jual_asli+'7.180',stock_jual='1',berat_akhir=berat_akhir-'7.180',berat_akhir_asli=berat_akhir_asli-'7.180',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='F3E-YFBH-84-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 ('F326050938001','2026-04-05','7.180','2026-04-05','09:38:01','PLG0028449','8330000','8330000','0','8330000','8330000','input','2026-04-05 09:38:00','F32605093800');
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-04-05','F326050938001','2026-04-05','09:38:01','AAT','8330000','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-260405-0007','D','2026-04-05','09:38:01','input','PENJUALAN','F326050938001','4211641000','8330000','4219971000');
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 ('F326050945051','input','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZCAI-157-0','CC X WEDDING MATA CM 16 8K ','','1.530','1','100.00','1744000','0','0','15000','1745000','0','0','0','1745000','FIT','00395553','E2D','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAI-157-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='E2D-ZCAI-157-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 ('F326050945051','2026-04-05','1.530','2026-04-05','09:45:05','PLG0028450','1745000','1745000','0','1745000','1745000','input','2026-04-05 09:45:05','F32605094505');
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-04-05','F326050945051','2026-04-05','09:45:05','FIT','1745000','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-260405-0008','D','2026-04-05','09:45:05','input','PENJUALAN','F326050945051','4219971000','1745000','4221716000');
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 ('F326050949311','input','1',' MDE2 10K C','TOKO','PM-E','E2D-YJAF-176-0','CC WEDDING MATA CM 22 8K ','','1.570','1','100.00','1790000','0','0','15000','1790000','0','10000','0','1800000','AAT','00373493','E2D','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJAF-176-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.570',berat_jual_asli=berat_jual_asli+'1.570',stock_jual='1',berat_akhir=berat_akhir-'1.570',berat_akhir_asli=berat_akhir_asli-'1.570',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='E2D-YJAF-176-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 ('F326050949311','2026-04-05','1.570','2026-04-05','09:49:32','PLG0028451','1790000','1790000','10000','1800000','1800000','input','2026-04-05 09:49:31','F32605094931');
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-04-05','F326050949311','2026-04-05','09:49:32','AAT','1800000','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-260405-0009','D','2026-04-05','09:49:32','input','PENJUALAN','F326050949311','4221716000','1800000','4223516000');
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 ('F326050957531','input','1',' MEH1 UB 34','TOKO','PM-H','H1E-YDBF-93-0','KL RANTAI HOLLOW ANAK UB 34 8K ','','0.650','1','100.00','754000','0','0','15000','755000','0','0','0','755000','LIS','00351042','H1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YDBF-93-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='H1E-YDBF-93-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 ('F326050957531','2026-04-05','0.650','2026-04-05','09:57:54','PLG0028452','755000','755000','0','755000','755000','input','2026-04-05 09:57:53','F32605095753');
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-04-05','F326050957531','2026-04-05','09:57:54','LIS','755000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260405-0010','D','2026-04-05','09:57:54','input','PENJUALAN','F326050957531','4223516000','755000','4224271000');
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 ('F326051004111','input','1',' MHB1H X LG','TOKO','PM-B','B1H-ZBBE-120-0','GW X TUSUK MRICAN SLEP LG 8K ','','0.250','1','100.00','305000','0','0','15000','305000','0','0','0','305000','FIT','00391266','B1H','0','0','-','0','1220000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-ZBBE-120-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='B1H-ZBBE-120-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 ('F326051004111','2026-04-05','0.250','2026-04-05','10:04:11','PLG0028453','305000','305000','0','305000','305000','input','2026-04-05 10:04:11','F32605100411');
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-04-05','F326051004111','2026-04-05','10:04:11','FIT','305000','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-260405-0011','D','2026-04-05','10:04:11','input','PENJUALAN','F326051004111','4224271000','305000','4224576000');
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 ('F326051006241','input','1',' MEA1E X LG','TOKO','PM-A','A1E-ZAAF-31-0','AT X MODEL MATA VAR LG 8K ','','0.470','1','100.00','545000','0','0','15000','545000','0','0','0','545000','SIN','00385482','A1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZAAF-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='A1E-ZAAF-31-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 ('F326051006241','2026-04-05','0.470','2026-04-05','10:06:24','PLG0028454','545000','545000','0','545000','545000','input','2026-04-05 10:06:24','F32605100624');
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-04-05','F326051006241','2026-04-05','10:06:24','SIN','545000','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-260405-0012','D','2026-04-05','10:06:24','input','PENJUALAN','F326051006241','4224576000','545000','4225121000');
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 ('F326051026171','input','1',' TAA0 X DW ','TOKO','PT-A','A0TA-YLBF-55-T','AT X JERSY MRICAN DW 17K ','','0.950','1','100.00','1924000','0','0','15000','1925000','0','0','0','1925000','FIT','T0076225','A0TA','0','0','-','0','2025000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A0TA-YLBF-55-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='A0TA-YLBF-55-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326051026171','2026-04-05','0.950','2026-04-05','10:26:17','PLG0028455','1925000','1925000','0','1925000','1925000','input','2026-04-05 10:26:17','F32605102617');
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-04-05','F326051026171','2026-04-05','10:26:17','FIT','1925000','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-260405-0013','D','2026-04-05','10:26:17','input','PENJUALAN','F326051026171','4225121000','1925000','4227046000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1925000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326051026171' 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 ('F326051026172','input',' 1',' TFE1 X LG ','TOKO','PT-E','E1TF-WHAB-105-T','CC X OSROT BABY PLAT GRAFIR LG ','','0.550','1','100.00','1174000','0','0','15000','1175000','0','0','0','1175000','FIT','T0047406','E1TF','0','0','-','0','2135000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TF-WHAB-105-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='E1TF-WHAB-105-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 ('F326051026172','2026-04-05','0.550','2026-04-05','10:26:17','PLG0028456','1175000','1175000','0','1175000','1175000','input','2026-04-05 10:26:17','F32605102617');
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-04-05','F326051026172','2026-04-05','10:26:17','FIT','1175000','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-260405-0014','D','2026-04-05','10:26:17','input','PENJUALAN','F326051026172','4227046000','1175000','4228221000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1175000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326051026172' 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 ('F326051036511','input','1',' MEF2 10K L','TOKO','PM-F','F2E-ZCBG-89-0','GL ANAK PIPA BONEKA CAT MATA LG D38 8K ','','2.050','1','100.00','2378000','0','0','15000','2378000','0','10000','0','2388000','LIS','00396873','F2E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZCBG-89-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='F2E-ZCBG-89-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 ('F326051036511','2026-04-05','2.050','2026-04-05','10:36:52','PLG0028457','2378000','2378000','10000','2388000','2388000','input','2026-04-05 10:36:51','F32605103651');
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-04-05','F326051036511','2026-04-05','10:36:52','LIS','2388000','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-260405-0015','D','2026-04-05','10:36:52','input','PENJUALAN','F326051036511','4228221000','2388000','4230609000');
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 ('F326051044421','input','1',' MDE1 X OR ','TOKO','PM-E','E1D-ZCCA-172-0','CC X VELG POLOS OR 18 8K ','','1.080','1','100.00','1231000','0','0','15000','1232000','0','0','0','1232000','AAT','00397395','E1D','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCCA-172-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='E1D-ZCCA-172-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 ('F326051044421','2026-04-05','1.080','2026-04-05','10:44:43','PLG0028458','1232000','1232000','0','1232000','1232000','input','2026-04-05 10:44:42','F32605104442');
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-04-05','F326051044421','2026-04-05','10:44:43','AAT','1232000','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-260405-0016','D','2026-04-05','10:44:43','input','PENJUALAN','F326051044421','4230609000','1232000','4231841000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1232000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326051044421' 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 ('F326051044422','input',' 1',' MEB1E X LG','TOKO','PM-B','B1E-ZABC-26-0','GW X TIFF MATA VAR LG 8K ','','0.550','1','100.00','638000','0','0','15000','638000','0','0','0','638000','AAT','00386656','B1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZABC-26-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='B1E-ZABC-26-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 ('F326051044422','2026-04-05','0.550','2026-04-05','10:44:43','PLG0028459','638000','638000','0','638000','638000','input','2026-04-05 10:44:42','F32605104442');
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-04-05','F326051044422','2026-04-05','10:44:43','AAT','638000','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-260405-0017','D','2026-04-05','10:44:43','input','PENJUALAN','F326051044422','4231841000','638000','4232479000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='638000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326051044422' 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 ('F326051047441','input','1',' MEF1 10K C','TOKO','PM-F','F1E-ZCAH-356-0','GL ANAK MODEL OSROT BONEKA CAT CM 8K ','','0.950','1','100.00','1102000','0','0','15000','1103000','0','10000','0','1113000','FIT','00395311','F1E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZCAH-356-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='F1E-ZCAH-356-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 ('F326051047441','2026-04-05','0.950','2026-04-05','10:47:45','PLG0028460','1103000','1103000','10000','1113000','1113000','input','2026-04-05 10:47:44','F32605104744');
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-04-05','F326051047441','2026-04-05','10:47:45','FIT','1113000','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-260405-0018','D','2026-04-05','10:47:45','input','PENJUALAN','F326051047441','4232479000','1113000','4233592000');
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 ('F326051055301','input','1',' MEF3E X UB','TOKO','PM-F','F3E-YLXF-242-0','GL X TIFF ARESO VAR UB 8K ','','3.730','1','100.00','4327000','0','0','15000','4328000','0','0','0','4328000','SIN','00380058','F3E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLXF-242-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.730',berat_jual_asli=berat_jual_asli+'3.730',stock_jual='1',berat_akhir=berat_akhir-'3.730',berat_akhir_asli=berat_akhir_asli-'3.730',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='F3E-YLXF-242-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 ('F326051055301','2026-04-05','3.730','2026-04-05','10:55:31','PLG0028461','4328000','4328000','0','4328000','4328000','input','2026-04-05 10:55:30','F32605105530');
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-04-05','F326051055301','2026-04-05','10:55:31','SIN','4328000','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-260405-0019','D','2026-04-05','10:55:31','input','PENJUALAN','F326051055301','4233592000','4328000','4237920000');
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 ('F326051101381','input','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZCCA-174-0','CC X VELG SLEP CM 16 8K ','','1.030','1','100.00','1174000','0','0','15000','1175000','0','0','0','1175000','AAT','00397398','E1D','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCCA-174-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-04-05' AND kode_barang='E1D-ZCCA-174-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 ('F326051101381','2026-04-05','1.030','2026-04-05','11:01:38','PLG0028462','1175000','1175000','0','1175000','1175000','input','2026-04-05 11:01:38','F32605110138');
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-04-05','F326051101381','2026-04-05','11:01:38','AAT','1175000','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-260405-0020','D','2026-04-05','11:01:38','input','PENJUALAN','F326051101381','4237920000','1175000','4239095000');
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 ('F326051125291','input','1',' MEF3E X LT','TOKO','PM-F','F3E-ZCAI-309-0','GL X TIFF SPECTRA VAR LT 8K ','','1.220','1','100.00','1415000','0','0','15000','1415000','0','0','0','1415000','FIT','00395707','F3E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCAI-309-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.220',berat_jual_asli=berat_jual_asli+'1.220',stock_jual='1',berat_akhir=berat_akhir-'1.220',berat_akhir_asli=berat_akhir_asli-'1.220',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='F3E-ZCAI-309-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 ('F326051125291','2026-04-05','1.220','2026-04-05','11:25:30','PLG0028463','1415000','1415000','0','1415000','1415000','input','2026-04-05 11:25:29','F32605112529');
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-04-05','F326051125291','2026-04-05','11:25:30','FIT','1415000','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-260405-0021','D','2026-04-05','11:25:30','input','PENJUALAN','F326051125291','4239095000','1415000','4240510000');
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 ('F326051128341','input','1',' TDE1 X YS ','TOKO','PT-E','E1TD-XJAB-131-T','CC X VELG KACA YS 11 17K ','','1.000','1','100.00','2095000','0','0','15000','2095000','0','0','0','2095000','LIS','T0062992','E1TD','0','0','-','0','2095000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-XJAB-131-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-04-05' AND kode_barang='E1TD-XJAB-131-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 ('F326051128341','2026-04-05','1.000','2026-04-05','11:28:35','PLG0028464','2095000','2095000','0','2095000','2095000','input','2026-04-05 11:28:34','F32605112834');
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-04-05','F326051128341','2026-04-05','11:28:35','LIS','2095000','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-260405-0022','D','2026-04-05','11:28:35','input','PENJUALAN','F326051128341','4240510000','2095000','4242605000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2095000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326051128341' 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 ('F326051128342','input',' 1',' TEA1 X LG ','TOKO','PT-A','A1TE-VJAX-78-T','AT X JERSEY SLEP LG ','','1.020','1','100.00','2157000','0','0','15000','2158000','0','0','0','2158000','LIS','T0038795','A1TE','0','0','-','0','2115000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TE-VJAX-78-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='A1TE-VJAX-78-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326051128342','2026-04-05','1.020','2026-04-05','11:28:35','PLG0028465','2158000','2158000','0','2158000','2158000','input','2026-04-05 11:28:34','F32605112834');
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-04-05','F326051128342','2026-04-05','11:28:35','LIS','2158000','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-260405-0023','D','2026-04-05','11:28:35','input','PENJUALAN','F326051128342','4242605000','2158000','4244763000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2158000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326051128342' 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 ('F326051146501','input','1',' MED2 LG A ','TOKO','PM-D','D2E-ZCAH-335-0','LT MODEL HURUF MATA LG A 8K ','','0.600','1','100.00','696000','0','0','15000','696000','0','0','0','696000','SIN','00395290','D2E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZCAH-335-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-04-05' AND kode_barang='D2E-ZCAH-335-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 ('F326051146501','2026-04-05','0.600','2026-04-05','11:46:50','PLG0028466','696000','696000','0','696000','696000','input','2026-04-05 11:46:50','F32605114650');
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-04-05','F326051146501','2026-04-05','11:46:50','SIN','696000','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-260405-0024','D','2026-04-05','11:46:50','input','PENJUALAN','F326051146501','4244763000','696000','4245459000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='696000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326051146501' 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 ('F326051146502','input',' 1',' MDE2 CM 12','TOKO','PM-E','E2D-ZCAX-162-0','CC MODEL MATA SLEP VAR CM 12 8K ','','1.050','1','100.00','1197000','0','0','15000','1197000','0','0','0','1197000','SIN','00393133','E2D','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCAX-162-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-04-05' AND kode_barang='E2D-ZCAX-162-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 ('F326051146502','2026-04-05','1.050','2026-04-05','11:46:50','PLG0028467','1197000','1197000','0','1197000','1197000','input','2026-04-05 11:46:50','F32605114650');
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-04-05','F326051146502','2026-04-05','11:46:50','SIN','1197000','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-260405-0025','D','2026-04-05','11:46:50','input','PENJUALAN','F326051146502','4245459000','1197000','4246656000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1197000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326051146502' 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 ('F326051147391','input','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZCCX-521-0','CC X MODEL MATA CM 14 8K ','','0.860','1','100.00','980000','0','0','15000','980000','0','0','0','980000','SIN','00397175','E2D','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCCX-521-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='E2D-ZCCX-521-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 ('F326051147391','2026-04-05','0.860','2026-04-05','11:47:40','PLG0028468','980000','980000','0','980000','980000','input','2026-04-05 11:47:39','F32605114739');
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-04-05','F326051147391','2026-04-05','11:47:40','SIN','980000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260405-0026','D','2026-04-05','11:47:40','input','PENJUALAN','F326051147391','4246656000','980000','4247636000');
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 ('F326051150151','input','1',' MEF3 UB ','TOKO','PM-F','F3E-YFBD-128-0','GL TRIXIE MODEL PITA VAR UB 8K ','','2.090','1','100.00','2424000','0','0','15000','2425000','0','0','0','2425000','SIN','00358564','F3E','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YFBD-128-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.090',berat_jual_asli=berat_jual_asli+'2.090',stock_jual='1',berat_akhir=berat_akhir-'2.090',berat_akhir_asli=berat_akhir_asli-'2.090',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='F3E-YFBD-128-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 ('F326051150151','2026-04-05','2.090','2026-04-05','11:50:15','PLG0028469','2425000','2425000','0','2425000','2425000','input','2026-04-05 11:50:15','F32605115015');
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-04-05','F326051150151','2026-04-05','11:50:15','SIN','2425000','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-260405-0027','D','2026-04-05','11:50:15','input','PENJUALAN','F326051150151','4247636000','2425000','4250061000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2425000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326051150151' 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 ('F326051150152','input',' 1',' MDE2 X UB ','TOKO','PM-E','E2D-ZCCX-504-0','CC X MODEL MATA UB 14 8K','','1.210','1','100.00','1379000','0','0','15000','1380000','0','0','0','1380000','SIN','00397158','E2D','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZCCX-504-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.210',berat_jual_asli=berat_jual_asli+'1.210',stock_jual='1',berat_akhir=berat_akhir-'1.210',berat_akhir_asli=berat_akhir_asli-'1.210',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='E2D-ZCCX-504-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 ('F326051150152','2026-04-05','1.210','2026-04-05','11:50:15','PLG0028470','1380000','1380000','0','1380000','1380000','input','2026-04-05 11:50:15','F32605115015');
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-04-05','F326051150152','2026-04-05','11:50:15','SIN','1380000','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-260405-0028','D','2026-04-05','11:50:15','input','PENJUALAN','F326051150152','4250061000','1380000','4251441000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1380000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326051150152' 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 ('F326051240261','input','1',' MJH2 X UB ','TOKO','PM-H','H2J-ZCXG-218-0','KL X GUCCI UB 40 9K ','','1.130','1','100.00','1424000','0','0','15000','1425000','0','0','0','1425000','LIS','00392654','H2J','0','0','-','0','1260000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZCXG-218-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.130',berat_jual_asli=berat_jual_asli+'1.130',stock_jual='1',berat_akhir=berat_akhir-'1.130',berat_akhir_asli=berat_akhir_asli-'1.130',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='H2J-ZCXG-218-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 ('F326051240261','2026-04-05','1.130','2026-04-05','12:40:27','PLG0028471','1425000','1425000','0','1425000','1425000','input','2026-04-05 12:40:26','F32605124026');
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-04-05','F326051240261','2026-04-05','12:40:27','LIS','1425000','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-260405-0029','D','2026-04-05','12:40:27','input','PENJUALAN','F326051240261','4251441000','1425000','4252866000');
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 ('F326050108081','input','1',' TED1 X 7K ','TOKO','PT-D','D1TE-ZCBC-44-T','LT X MODEL FINE GOLD BAR LG 17K ','','0.570','1','100.00','1206000','0','0','15000','1195000','0','0','0','1195000','SIN','T0078279','D1TE','0','0','-','1','2115000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1TE-ZCBC-44-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='D1TE-ZCBC-44-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326050108081','2026-04-05','0.570','2026-04-05','13:08:09','PLG0028472','1195000','1195000','0','1195000','1195000','input','2026-04-05 13:08:08','F32605010808');
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-04-05','F326050108081','2026-04-05','13:08:09','SIN','1195000','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-260405-0030','D','2026-04-05','13:08:09','input','PENJUALAN','F326050108081','4252866000','1195000','4254061000');
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-00018708','X-00018708','CC MODEL MATA CM 22 8K','GR','---','E2D','BELI','BELI001','1395000','2026-04-05','1.820','1','kasir','2026-04-05 13:14:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00018708','X-00018708');
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-260405-0001','F325241258101','AAT','1','BELI','BELI001','E2D', 'X-00018708', 'CC MODEL MATA CM 22 8K','1.820','1.820','100.00','1305000','1395000','766484','1150000','1','1395000','1395000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.820',berat_beli_asli=berat_beli_asli+'1.820',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.820',berat_akhir_asli=berat_akhir_asli+'1.820',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-05' 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-260405-0001','2026-04-05','2026-04-05','13:14:29','AAT','---','1.820','1395000','1395000','1395000','1395000','1395000','kasir','2026-04-05 13:14:29','FB-260405-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260405-0001','BU DIANI','BULUREJO BULUKERTO','','','','kasir','2026-04-05 13:14:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-05' 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-260405-0031','K','2026-04-05','13:14:29','kasir','PEMBELIAN UMUM','FB-260405-0001','4254061000','1395000','4252666000');
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-00018709','X-00018709','CC X MODEL PIPA MATA HT 20 8K','GR','---','E2E','BELI','BELI001','460000','2026-04-05','0.470','1','kasir','2026-04-05 13:15:01');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018709','X-00018709');
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-260405-0002','F325261036051','SIN','1','BELI','BELI001','E2E', 'X-00018709', 'CC X MODEL PIPA MATA HT 20 8K','0.470','0.470','100.00','495000','460000','978723','1170000','1','460000','460000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.470',berat_beli_asli=berat_beli_asli+'0.470',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.470',berat_akhir_asli=berat_akhir_asli+'0.470',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-05' 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-260405-0002','2026-04-05','2026-04-05','13:15:01','SIN','---','0.470','460000','460000','460000','460000','460000','kasir','2026-04-05 13:15:01','FB-260405-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260405-0002','CITRA','KEPYAR','','','','kasir','2026-04-05 13:15:01');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-05' 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-260405-0032','K','2026-04-05','13:15:01','kasir','PEMBELIAN UMUM','FB-260405-0002','4252666000','460000','4252206000');
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-00018710','X-00018710','CC MODEL KUPU SLEP LG 14 8K','GR','---','E1G','BELI','BELI001','372000','2026-04-05','0.350','1','kasir','2026-04-05 13:15:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1G','X-00018710','X-00018710');
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-260405-0003','F326251029071','FIT','1','BELI','BELI001','E1G', 'X-00018710', 'CC MODEL KUPU SLEP LG 14 8K','0.350','0.350','100.00','415000','372000','1062857','1200000','1','372000','372000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.350',berat_beli_asli=berat_beli_asli+'0.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.350',berat_akhir_asli=berat_akhir_asli+'0.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1G' 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-260405-0003','2026-04-05','2026-04-05','13:15:29','FIT','---','0.350','372000','372000','372000','372000','372000','kasir','2026-04-05 13:15:30','FB-260405-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260405-0003','CITRA','JANGGIR SUMBER PWO','','','','kasir','2026-04-05 13:15:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-05' 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-260405-0033','K','2026-04-05','13:15:29','kasir','PEMBELIAN UMUM','FB-260405-0003','4252206000','372000','4251834000');
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-00018711','X-00018711','GL TIFF SLEP VAR HW 8K','GR','---','F3E','BELI','BELI001','1262000','2026-04-05','1.270','1','kasir','2026-04-05 13:15:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00018711','X-00018711');
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-260405-0004','F326201059201','FIT','1','BELI','BELI001','F3E', 'X-00018711', 'GL TIFF SLEP VAR HW 8K','1.270','1.270','100.00','1575000','1262000','993701','1170000','1','1262000','1262000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.270',berat_beli_asli=berat_beli_asli+'1.270',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.270',berat_akhir_asli=berat_akhir_asli+'1.270',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-05' 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-260405-0004','2026-04-05','2026-04-05','13:15:56','FIT','---','1.270','1262000','1262000','1262000','1262000','1262000','kasir','2026-04-05 13:15:57','FB-260405-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260405-0004','INDAH','BULUKERTO','','','','kasir','2026-04-05 13:15:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-05' 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-260405-0034','K','2026-04-05','13:15:56','kasir','PEMBELIAN UMUM','FB-260405-0004','4251834000','1262000','4250572000');
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-00018712','X-00018712','KL X SANTA KH 44 9K','GR','---','H2I','BELI','BELI001','3227000','2026-04-05','3.030','1','kasir','2026-04-05 13:16:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00018712','X-00018712');
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-260405-0005','F325191058295','FIT','1','BELI','BELI001','H2I', 'X-00018712', 'KL X SANTA KH 44 9K','3.030','3.030','100.00','3470000','3227000','1065017','1240000','1','3227000','3227000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.030',berat_beli_asli=berat_beli_asli+'3.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.030',berat_akhir_asli=berat_akhir_asli+'3.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2I' 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-260405-0005','2026-04-05','2026-04-05','13:16:42','FIT','---','3.030','3227000','3227000','3227000','3227000','3227000','kasir','2026-04-05 13:16:43','FB-260405-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260405-0005','ANA','KUNTI BADEGAN','','','0881027749248','kasir','2026-04-05 13:16:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-05' 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-260405-0035','K','2026-04-05','13:16:42','kasir','PEMBELIAN UMUM','FB-260405-0005','4250572000','3227000','4247345000');
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-00018713','X-00018713','KL X FLAMINGGO KH 44 9K','GR','---','H2I','BELI','BELI001','2162000','2026-04-05','2.030','1','kasir','2026-04-05 13:16:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00018713','X-00018713');
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-260405-0006','F325191058296','FIT','2','BELI','BELI001','H2I', 'X-00018713', 'KL X FLAMINGGO KH 44 9K','2.030','2.030','100.00','2325000','2162000','1065025','1240000','1','2162000','2162000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.030',berat_beli_asli=berat_beli_asli+'2.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.030',berat_akhir_asli=berat_akhir_asli+'2.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2I' 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-260405-0006','2026-04-05','2026-04-05','13:16:42','FIT','---','2.030','2162000','2162000','2162000','2162000','2162000','kasir','2026-04-05 13:16:43','FB-260405-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260405-0006','ANA','KUNTI BADEGAN','','','0881027749248','kasir','2026-04-05 13:16:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-05' 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-260405-0036','K','2026-04-05','13:16:42','kasir','PEMBELIAN UMUM','FB-260405-0006','4247345000','2162000','4245183000');
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-00018714','X-00018714','CC X MODEL MATA UB 14 8K','GR','---','E2E','BELI','BELI001','835000','2026-04-05','1.220','1','kasir','2026-04-05 13:17:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018714','X-00018714');
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-260405-0007','F324090846281','LIS','1','BELI','BELI001','E2E', 'X-00018714', 'CC X MODEL MATA UB 14 8K','1.220','1.220','100.00','785000','835000','684426','1170000','1','835000','835000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.220',berat_beli_asli=berat_beli_asli+'1.220',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.220',berat_akhir_asli=berat_akhir_asli+'1.220',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-05' 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-260405-0007','2026-04-05','2026-04-05','13:17:31','LIS','---','1.220','835000','835000','835000','835000','835000','kasir','2026-04-05 13:17:31','FB-260405-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260405-0007','TUTIK','CRABAK GAMBIRANOM KISMANTORO','','','','kasir','2026-04-05 13:17:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-05' 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-260405-0037','K','2026-04-05','13:17:31','kasir','PEMBELIAN UMUM','FB-260405-0007','4245183000','835000','4244348000');
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-00018715','X-00018715','CC WEDDING MATA CM 10 8K','GR','---','E2E','BELI','BELI001','1502000','2026-04-05','2.000','1','kasir','2026-04-05 13:32:53');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018715','X-00018715');
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-260405-0008','F324071005332','LIS','1','BELI','BELI001','E2E', 'X-00018715', 'CC WEDDING MATA CM 10 8K','2.000','2.000','100.00','1220000','1502000','751000','1170000','1','1502000','1502000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.000',berat_beli_asli=berat_beli_asli+'2.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.000',berat_akhir_asli=berat_akhir_asli+'2.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-05' 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-260405-0008','2026-04-05','2026-04-05','13:32:52','LIS','---','2.000','1502000','1502000','1502000','1502000','1502000','kasir','2026-04-05 13:32:53','FB-260405-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260405-0008','EKA','NGROTO KISMANTORO','','','088221540003','kasir','2026-04-05 13:32:53');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-05' 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-260405-0038','K','2026-04-05','13:32:52','kasir','PEMBELIAN UMUM','FB-260405-0008','4244348000','1502000','4242846000');
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-00018716','X-00018716','CC WEDDING MATA CM 19 8K','GR','---','E2E','BELI','BELI001','1628000','2026-04-05','2.150','1','kasir','2026-04-05 13:32:53');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00018716','X-00018716');
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-260405-0009','F324071005331','LIS','2','BELI','BELI001','E2E', 'X-00018716', 'CC WEDDING MATA CM 19 8K','2.150','2.150','100.00','1310000','1628000','757209','1170000','1','1628000','1628000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.150',berat_beli_asli=berat_beli_asli+'2.150',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.150',berat_akhir_asli=berat_akhir_asli+'2.150',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-05' 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-260405-0009','2026-04-05','2026-04-05','13:32:52','LIS','---','2.150','1628000','1628000','1628000','1628000','1628000','kasir','2026-04-05 13:32:53','FB-260405-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260405-0009','EKA','NGROTO KISMANTORO','','','088221540003','kasir','2026-04-05 13:32:53');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-05' 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-260405-0039','K','2026-04-05','13:32:52','kasir','PEMBELIAN UMUM','FB-260405-0009','4242846000','1628000','4241218000');
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-00018717','X-00018717','CC X MODEL MATA PM 12 8K','GR','---','E2D','BELI','BELI001','1035000','2026-04-05','1.080','1','kasir','2026-04-05 13:48:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00018717','X-00018717');
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-260405-0010','F325251246381','SIN','1','BELI','BELI001','E2D', 'X-00018717', 'CC X MODEL MATA PM 12 8K','1.080','1.080','100.00','1113000','1035000','958333','1150000','1','1035000','1035000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.080',berat_beli_asli=berat_beli_asli+'1.080',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.080',berat_akhir_asli=berat_akhir_asli+'1.080',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-04-05' 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-260405-0010','2026-04-05','2026-04-05','13:48:03','SIN','---','1.080','1035000','1035000','1035000','1035000','1035000','kasir','2026-04-05 13:48:03','FB-260405-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260405-0010','WAFIQ','PLOSO KISMANTORO','','','082136941826','kasir','2026-04-05 13:48:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-04-05' 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-260405-0040','K','2026-04-05','13:48:03','kasir','PEMBELIAN UMUM','FB-260405-0010','4241218000','1035000','4240183000');
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 ('F326050234301','input','1',' TEB1 X HK ','TOKO','PT-B','B1TE-YLAC-19-T','GW X MODEL TOGE MATA HK 17K ','','0.500','1','100.00','1057000','0','0','15000','1058000','0','0','0','1058000','FIT','T0075754','B1TE','0','0','-','0','2115000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TE-YLAC-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='B1TE-YLAC-19-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326050234301','2026-04-05','0.500','2026-04-05','14:34:30','PLG0028473','1058000','1058000','0','1058000','1058000','input','2026-04-05 14:34:30','F32605023430');
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-04-05','F326050234301','2026-04-05','14:34:30','FIT','1058000','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-260405-0041','D','2026-04-05','14:34:30','input','PENJUALAN','F326050234301','4240183000','1058000','4241241000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1058000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326050234301' 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 ('F326050234302','input',' 1',' TEF2 X KH ','TOKO','PT-F','F2TE-XJAB-169-T','GL X ANAK PIPA MODEL MATA VAR KH D44 17K ','','2.860','1','100.00','6049000','0','0','15000','6050000','0','0','0','6050000','FIT','T0063030','F2TE','0','0','-','0','2115000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2TE-XJAB-169-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.860',berat_jual_asli=berat_jual_asli+'2.860',stock_jual='1',berat_akhir=berat_akhir-'2.860',berat_akhir_asli=berat_akhir_asli-'2.860',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='F2TE-XJAB-169-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326050234302','2026-04-05','2.860','2026-04-05','14:34:30','PLG0028474','6050000','6050000','0','6050000','6050000','input','2026-04-05 14:34:30','F32605023430');
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-04-05','F326050234302','2026-04-05','14:34:30','FIT','6050000','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-260405-0042','D','2026-04-05','14:34:30','input','PENJUALAN','F326050234302','4241241000','6050000','4247291000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='6050000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326050234302' 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 ('F326050237381','input','1',' MGPE X 10K','TOKO','PM-P','PEG-YJCA-101-0','CC X WEDDING POLOS CM 22 8K ','','1.970','1','100.00','2364000','0','0','15000','2365000','0','10000','0','2375000','SIN','00375488','PEG','0','0','-','0','1200000');
UPDATE tm_barang SET tgl_last_jual='2026-04-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PEG-YJCA-101-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2026-04-05' AND kode_barang='PEG-YJCA-101-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-P' 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 ('F326050237381','2026-04-05','1.970','2026-04-05','14:37:39','PLG0028475','2365000','2365000','10000','2375000','2375000','input','2026-04-05 14:37:38','F32605023738');
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-04-05','F326050237381','2026-04-05','14:37:39','SIN','2375000','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-260405-0043','D','2026-04-05','14:37:39','input','PENJUALAN','F326050237381','4247291000','2375000','4249666000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260405-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260405-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260405-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260405-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260405-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260405-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260405-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260405-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260405-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260405-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260405-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260405-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260405-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260405-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260405-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260405-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260405-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260405-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260405-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260405-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050108081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050108081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050108081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050234301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050234301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050234301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050234302' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050234302' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050234302';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050237381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050237381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050237381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050856301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050856301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050856301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050856302' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050856302' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050856302';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050930141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050930141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050930141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050931131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050931131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050931131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050934081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050934081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050934081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050938001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050938001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050938001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050945051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050945051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050945051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050949311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050949311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050949311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326050957531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326050957531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326050957531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051004111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051004111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051004111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051006241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051006241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051006241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051026171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051026171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051026171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051026172' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051026172' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051026172';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051036511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051036511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051036511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051044421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051044421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051044421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051044422' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051044422' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051044422';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051047441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051047441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051047441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051055301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051055301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051055301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051101381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051101381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051101381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051125291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051125291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051125291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051128341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051128341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051128341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051128342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051128342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051128342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051146501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051146501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051146501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051146502' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051146502' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051146502';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051147391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051147391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051147391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051150151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051150151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051150151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051150152' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051150152' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051150152';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326051240261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326051240261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326051240261';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-06','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-06';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-05';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-05';
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-04-05' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-05';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-05';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-05';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-05';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-06' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-05' 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-260406-0001','D','2026-04-06','15:37:30','SYSTEM','SALDO AWAL','SALDO AWAL','0','4249666000','4249666000');
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-260406-0001','D','2026-04-06','15:37:30','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-260406-0001','D','2026-04-06','15:37:30','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-260406-0001','D','2026-04-06','15:37:30','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-04-06';