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 ('F326150756341','input','1',' MEF3E HW ','TOKO','PM-F','F3E-ZGBD-163-0','GL RANTAI HOLLOW SLEP HW 8K ','','3.070','1','100.00','3202000','0','0','15000','3203000','0','0','0','3203000','LIS','00415540','F3E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGBD-163-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.070',berat_jual_asli=berat_jual_asli+'3.070',stock_jual='1',berat_akhir=berat_akhir-'3.070',berat_akhir_asli=berat_akhir_asli-'3.070',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='F3E-ZGBD-163-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 ('F326150756341','2026-10-15','3.070','2026-10-15','07:56:35','PLG0031881','3203000','3203000','0','3203000','3203000','input','2026-10-15 07:56:34','F32615075634'); 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-10-15','F326150756341','2026-10-15','07:56:35','LIS','3203000','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-261015-0002','D','2026-10-15','07:56:35','input','PENJUALAN','F326150756341','7866777000','3203000','7869980000'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261015-0001','1','D1E-ZJXH-80-0','1','0.510','0.510','TOKO','PMBK-D','TOKO','PM-D'); DELETE FROM tm_barang WHERE kode_barang='D1E-ZJXH-80-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZJXH-80-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-10-15 08:06:02' WHERE kode_barang='D1E-ZJXH-80-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZJXH-80-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-15 08:06:02','TOKO','PM-D','D1E','D1E-ZJXH-80-0','1','0.510','0.510','1','0.510','0.510','100.00'); DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1E-ZJXH-80-0'; DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZJXH-80-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261015-0001','2026-10-15','08:05','0.510','admpindah','2026-10-15 08:06:02'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261015-0001','1','E1E-ZHAD-47-0','1','0.520','0.520','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1E-ZHAD-47-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZHAD-47-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-15 08:06:20' WHERE kode_barang='E1E-ZHAD-47-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZHAD-47-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-15 08:06:20','TOKO','PM-E','E1E','E1E-ZHAD-47-0','1','0.520','0.520','1','0.520','0.520','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZHAD-47-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZHAD-47-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261015-0001','1','E1E-ZIBA-452-0','1','0.530','0.530','TOKO','PMBK-E','TOKO','PM-E'); DELETE FROM tm_barang WHERE kode_barang='E1E-ZIBA-452-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZIBA-452-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-15 08:06:20' WHERE kode_barang='E1E-ZIBA-452-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZIBA-452-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-15 08:06:20','TOKO','PM-E','E1E','E1E-ZIBA-452-0','1','0.530','0.530','1','0.530','0.530','100.00'); DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1E-ZIBA-452-0'; DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZIBA-452-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261015-0001','2026-10-15','08:06','1.050','admpindah','2026-10-15 08:06:19'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261015-0001','1','F1E-ZIBF-7-0','1','5.940','5.940','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F1E-ZIBF-7-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZIBF-7-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-15 08:06:40' WHERE kode_barang='F1E-ZIBF-7-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZIBF-7-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-15 08:06:40','TOKO','PM-F','F1E','F1E-ZIBF-7-0','1','5.940','5.940','1','5.940','5.940','100.00'); DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F1E-ZIBF-7-0'; DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZIBF-7-0'; INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261015-0001','1','F3E-ZJXF-223-0','1','1.730','1.730','TOKO','PMBK-F','TOKO','PM-F'); DELETE FROM tm_barang WHERE kode_barang='F3E-ZJXF-223-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZJXF-223-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-15 08:06:40' WHERE kode_barang='F3E-ZJXF-223-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZJXF-223-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-15 08:06:40','TOKO','PM-F','F3E','F3E-ZJXF-223-0','1','1.730','1.730','1','1.730','1.730','100.00'); DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZJXF-223-0'; DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZJXF-223-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261015-0001','2026-10-15','08:06','7.670','admpindah','2026-10-15 08:06:40'); INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20261015-0001','1','H1E-ZJXF-188-0','1','6.100','6.100','TOKO','PMBK-H','TOKO','PM-H'); DELETE FROM tm_barang WHERE kode_barang='H1E-ZJXF-188-0' LIMIT 1; INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZJXF-188-0' LIMIT 1; UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-10-15 08:07:06' WHERE kode_barang='H1E-ZJXF-188-0' LIMIT 1; DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZJXF-188-0' LIMIT 1; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-10-15 08:07:06','TOKO','PM-H','H1E','H1E-ZJXF-188-0','1','6.100','6.100','1','6.100','6.100','100.00'); DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1; INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1; DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1; INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1; UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZJXF-188-0'; DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZJXF-188-0'; INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261015-0001','2026-10-15','08:06','6.100','admpindah','2026-10-15 08:07:06'); 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 ('F326150925081','input','1',' MEF1 X UB ','TOKO','PM-F','F1E-ZIBE-92-0','GL X PIPA BONEKA ANAK CAT UB 40 8K ','','1.780','1','100.00','1857000','0','0','15000','1855000','0','0','0','1855000','AAT','00425467','F1E','0','0','-','1','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZIBE-92-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-10-15' AND kode_barang='F1E-ZIBE-92-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 ('F326150925081','2026-10-15','1.780','2026-10-15','09:25:09','PLG0031882','1855000','1855000','0','1855000','1855000','input','2026-10-15 09:25:08','F32615092508'); 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-10-15','F326150925081','2026-10-15','09:25:09','AAT','1855000','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-261015-0003','D','2026-10-15','09:25:09','input','PENJUALAN','F326150925081','7869980000','1855000','7871835000'); 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 ('F326150930321','input','1',' MDA1D X LG','TOKO','PM-A','A1D-YBXH-74-0','AT X BONEKA ANAK MATA CAT LG 8K ','','1.000','1','100.00','1023000','0','0','15000','1023000','0','0','0','1023000','LIS','00338137','A1D','0','0','-','0','1023000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YBXH-74-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='A1D-YBXH-74-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 ('F326150930321','2026-10-15','1.000','2026-10-15','09:30:33','PLG0031883','1023000','1023000','0','1023000','1023000','input','2026-10-15 09:30:32','F32615093032'); 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-10-15','F326150930321','2026-10-15','09:30:33','LIS','1023000','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-261015-0004','D','2026-10-15','09:30:33','input','PENJUALAN','F326150930321','7871835000','1023000','7872858000'); 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 ('F326151015231','input','1',' MJH2 X KH ','TOKO','PM-H','H2J-XLBC-267-0','KL X MILANO SEMI KH 54 9K ','','8.040','1','100.00','9190000','0','0','15000','9190000','0','0','0','9190000','SIN','00331269','H2J','0','0','-','0','1143000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-XLBC-267-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'8.040',berat_jual_asli=berat_jual_asli+'8.040',stock_jual='1',berat_akhir=berat_akhir-'8.040',berat_akhir_asli=berat_akhir_asli-'8.040',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='H2J-XLBC-267-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 ('F326151015231','2026-10-15','8.040','2026-10-15','10:15:24','PLG0031884','9190000','9190000','0','9190000','9190000','input','2026-10-15 10:15:23','F32615101523'); 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-10-15','F326151015231','2026-10-15','10:15:24','SIN','9190000','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-261015-0005','D','2026-10-15','10:15:24','input','PENJUALAN','F326151015231','7872858000','9190000','7882048000'); 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-00020535','X-00020535','CC X MODEL MATA YT 17 8K','GR','---','E2E','BELI','BELI001','770000','2026-10-15','0.790','1','kasir','2026-10-15 11:23:16'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020535','X-00020535'); 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-261015-0001','F326101241351','LIS','1','BELI','BELI001','E2E', 'X-00020535', 'CC X MODEL MATA YT 17 8K','0.790','0.790','100.00','830000','770000','974684','1053000','1','770000','770000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.790',berat_beli_asli=berat_beli_asli+'0.790',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.790',berat_akhir_asli=berat_akhir_asli+'0.790',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-15' 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-261015-0001','2026-10-15','2026-10-15','11:23:15','LIS','---','0.790','770000','770000','770000','770000','770000','kasir','2026-10-15 11:23:16','FB-261015-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261015-0001','ANGGUN AURA','TEGALREJO','','','','kasir','2026-10-15 11:23:16'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-15' 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-261015-0006','K','2026-10-15','11:23:15','kasir','PEMBELIAN UMUM','FB-261015-0001','7882048000','770000','7881278000'); 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-00020536','X-00020536','KL SANTA KH 42 8K','GR','---','H1E','BELI','BELI001','2930000','2026-10-15','3.020','1','kasir','2026-10-15 11:23:51'); DELETE FROM tp_barang WHERE kode_dept = 'X-H1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020536','X-00020536'); 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-261015-0002','F326270852401','FIT','1','BELI','BELI001','H1E', 'X-00020536', 'KL SANTA KH 42 8K','3.020','3.020','100.00','3186000','2930000','970199','1053000','1','2930000','2930000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.020',berat_beli_asli=berat_beli_asli+'3.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.020',berat_akhir_asli=berat_akhir_asli+'3.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-15' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261015-0002','2026-10-15','2026-10-15','11:23:50','FIT','---','3.020','2930000','2930000','2930000','2930000','2930000','kasir','2026-10-15 11:23:51','FB-261015-0002'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261015-0002','ANGGI','SUGIHAN BULUKERTO','','','','kasir','2026-10-15 11:23:51'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-15' 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-261015-0007','K','2026-10-15','11:23:50','kasir','PEMBELIAN UMUM','FB-261015-0002','7881278000','2930000','7878348000'); 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-00020537','X-00020537','AT X HUGGIES SLEP UB 8K','GR','---','A1E','BELI','BELI001','630000','2026-10-15','0.690','1','kasir','2026-10-15 11:24:17'); DELETE FROM tp_barang WHERE kode_dept = 'X-A1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00020537','X-00020537'); 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-261015-0003','F326251154021','LIS','1','BELI','BELI001','A1E', 'X-00020537', 'AT X HUGGIES SLEP UB 8K','0.690','0.690','100.00','715000','630000','913043','1053000','1','630000','630000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.690',berat_beli_asli=berat_beli_asli+'0.690',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.690',berat_akhir_asli=berat_akhir_asli+'0.690',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-15' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261015-0003','2026-10-15','2026-10-15','11:24:17','LIS','---','0.690','630000','630000','630000','630000','630000','kasir','2026-10-15 11:24:17','FB-261015-0003'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261015-0003','SASA','BULUKERTO','','','','kasir','2026-10-15 11:24:17'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-15' 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-261015-0008','K','2026-10-15','11:24:17','kasir','PEMBELIAN UMUM','FB-261015-0003','7878348000','630000','7877718000'); 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 ('F326151131171','kasir','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZGXA-180-0','CC X VELG KACA CM 18 8K ','','1.510','1','100.00','1545000','0','0','15000','1545000','0','0','0','1545000','LIS','00411704','E1D','0','0','-','0','1023000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGXA-180-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='E1D-ZGXA-180-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326151131171','2026-10-15','1.510','2026-10-15','11:31:17','PLG0031885','1545000','1545000','0','1545000','1545000','kasir','2026-10-15 11:31:17','F32615113117'); 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-10-15','F326151131171','2026-10-15','11:31:17','LIS','1545000','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-261015-0009','D','2026-10-15','11:31:17','kasir','PENJUALAN','F326151131171','7877718000','1545000','7879263000'); 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 ('F326151145381','kasir','1',' MEE2 X CM ','TOKO','PM-E','E2E-WKAF-184-0','CC X MODEL MATA CM 18 ','','1.950','1','100.00','2034000','0','0','15000','2034000','0','0','0','2034000','SIN','00264622','E2E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-WKAF-184-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.950',berat_jual_asli=berat_jual_asli+'1.950',stock_jual='1',berat_akhir=berat_akhir-'1.950',berat_akhir_asli=berat_akhir_asli-'1.950',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='E2E-WKAF-184-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 ('F326151145381','2026-10-15','1.950','2026-10-15','11:45:39','PLG0031886','2034000','2034000','0','2034000','2034000','kasir','2026-10-15 11:45:38','F32615114538'); 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-10-15','F326151145381','2026-10-15','11:45:39','SIN','2034000','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-261015-0010','D','2026-10-15','11:45:39','kasir','PENJUALAN','F326151145381','7879263000','2034000','7881297000'); 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 ('F326150154421','kasir','1',' MEF1 X TD ','TOKO','PM-F','F1E-ZIBE-79-0','GL X BANGKOK C SLEP TD 56 8K ','','3.960','1','100.00','4130000','0','0','15000','4130000','0','0','0','4130000','SIN','00425454','F1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZIBE-79-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.960',berat_jual_asli=berat_jual_asli+'3.960',stock_jual='1',berat_akhir=berat_akhir-'3.960',berat_akhir_asli=berat_akhir_asli-'3.960',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='F1E-ZIBE-79-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 ('F326150154421','2026-10-15','3.960','2026-10-15','13:54:43','PLG0031887','4130000','4130000','0','4130000','4130000','kasir','2026-10-15 13:54:42','F32615015442'); 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-10-15','F326150154421','2026-10-15','13:54:43','SIN','4130000','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-261015-0011','D','2026-10-15','13:54:43','kasir','PENJUALAN','F326150154421','7881297000','4130000','7885427000'); 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 ('F326150210151','input','1',' MEF1 X YT ','TOKO','PM-F','F1E-ZJXF-195-0','GL X OVAL C SLEP YT 60 8K ','','2.210','1','100.00','2305000','0','0','15000','2305000','0','0','0','2305000','FIT','00428099','F1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZJXF-195-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.210',berat_jual_asli=berat_jual_asli+'2.210',stock_jual='1',berat_akhir=berat_akhir-'2.210',berat_akhir_asli=berat_akhir_asli-'2.210',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='F1E-ZJXF-195-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 ('F326150210151','2026-10-15','2.210','2026-10-15','14:10:16','PLG0031888','2305000','2305000','0','2305000','2305000','input','2026-10-15 14:10:15','F32615021015'); 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-10-15','F326150210151','2026-10-15','14:10:16','FIT','2305000','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-261015-0012','D','2026-10-15','14:10:16','input','PENJUALAN','F326150210151','7885427000','2305000','7887732000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='2305000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150210151' 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 ('F326150210152','input',' 1',' MEF2 CM D5','TOKO','PM-F','F2E-ZJXA-89-0','GL OVAL MODEL MATA VAR CM D55 8K ','','1.230','1','100.00','1283000','0','0','15000','1283000','0','0','0','1283000','FIT','00426722','F2E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZJXA-89-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.230',berat_jual_asli=berat_jual_asli+'1.230',stock_jual='1',berat_akhir=berat_akhir-'1.230',berat_akhir_asli=berat_akhir_asli-'1.230',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='F2E-ZJXA-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 ('F326150210152','2026-10-15','1.230','2026-10-15','14:10:16','PLG0031889','1283000','1283000','0','1283000','1283000','input','2026-10-15 14:10:15','F32615021015'); 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-10-15','F326150210152','2026-10-15','14:10:16','FIT','1283000','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-261015-0013','D','2026-10-15','14:10:16','input','PENJUALAN','F326150210152','7887732000','1283000','7889015000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1283000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150210152' 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 ('F326150210153','input',' 1',' MDB1 LG PE','TOKO','PM-B','B1D-ZIAI-305-0','GW MODEL MATA LG PE 8K ','','0.950','1','100.00','972000','0','0','15000','972000','0','0','0','972000','FIT','00424527','B1D','0','0','-','0','1023000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZIAI-305-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-10-15' AND kode_barang='B1D-ZIAI-305-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 ('F326150210153','2026-10-15','0.950','2026-10-15','14:10:16','PLG0031890','972000','972000','0','972000','972000','input','2026-10-15 14:10:15','F32615021015'); 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-10-15','F326150210153','2026-10-15','14:10:16','FIT','972000','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-261015-0014','D','2026-10-15','14:10:16','input','PENJUALAN','F326150210153','7889015000','972000','7889987000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='972000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150210153' 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 ('F326150210154','input',' 1',' MFE2 KH 14','TOKO','PM-E','E2F-ZJXA-104-0','CC MODEL MATA VAR KH 14 8K ','','0.370','1','100.00','393000','0','0','15000','393000','0','0','0','393000','FIT','00426737','E2F','0','0','-','0','1063000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZJXA-104-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='E2F-ZJXA-104-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 ('F326150210154','2026-10-15','0.370','2026-10-15','14:10:16','PLG0031891','393000','393000','0','393000','393000','input','2026-10-15 14:10:15','F32615021015'); 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-10-15','F326150210154','2026-10-15','14:10:16','FIT','393000','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-261015-0015','D','2026-10-15','14:10:16','input','PENJUALAN','F326150210154','7889987000','393000','7890380000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='393000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150210154' 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 ('F326150210155','input',' 1',' MFE1 KH 14','TOKO','PM-E','E1F-ZJXE-402-0','CC MODEL DAUN SLEP KH 14 8K ','','0.400','1','100.00','425000','0','0','15000','425000','0','0','0','425000','FIT','00427893','E1F','0','0','-','0','1063000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZJXE-402-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-10-15' AND kode_barang='E1F-ZJXE-402-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 ('F326150210155','2026-10-15','0.400','2026-10-15','14:10:16','PLG0031892','425000','425000','0','425000','425000','input','2026-10-15 14:10:15','F32615021015'); 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-10-15','F326150210155','2026-10-15','14:10:16','FIT','425000','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-261015-0016','D','2026-10-15','14:10:16','input','PENJUALAN','F326150210155','7890380000','425000','7890805000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='425000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150210155' 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 ('F326150210156','input',' 1',' MEE2 X KH ','TOKO','PM-E','E2E-ZIBE-206-0','CC X MODEL MATA KH 14 8K ','','0.470','1','100.00','490000','0','0','15000','490000','0','0','0','490000','FIT','00425581','E2E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZIBE-206-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-10-15' AND kode_barang='E2E-ZIBE-206-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 ('F326150210156','2026-10-15','0.470','2026-10-15','14:10:16','PLG0031893','490000','490000','0','490000','490000','input','2026-10-15 14:10:15','F32615021015'); 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-10-15','F326150210156','2026-10-15','14:10:16','FIT','490000','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-261015-0017','D','2026-10-15','14:10:16','input','PENJUALAN','F326150210156','7890805000','490000','7891295000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='490000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150210156' 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 ('F326150210157','input',' 1',' MFE1 KH 14','TOKO','PM-E','E1F-ZJXE-393-0','CC MODEL SPECTRA SLEP KH 14 8K ','','0.360','1','100.00','383000','0','0','15000','383000','0','0','0','383000','FIT','00427884','E1F','0','0','-','0','1063000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZJXE-393-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='E1F-ZJXE-393-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 ('F326150210157','2026-10-15','0.360','2026-10-15','14:10:16','PLG0031894','383000','383000','0','383000','383000','input','2026-10-15 14:10:15','F32615021015'); 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-10-15','F326150210157','2026-10-15','14:10:16','FIT','383000','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-261015-0018','D','2026-10-15','14:10:16','input','PENJUALAN','F326150210157','7891295000','383000','7891678000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='383000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150210157' 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 ('F326150210158','input',' 1',' MEB1 LG PE','TOKO','PM-B','B1E-ZEBX-218-0','GW MODEL MATA LG PE 8K ','','0.610','1','100.00','636000','0','0','15000','636000','0','0','0','636000','FIT','00404496','B1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEBX-218-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='B1E-ZEBX-218-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 ('F326150210158','2026-10-15','0.610','2026-10-15','14:10:16','PLG0031895','636000','636000','0','636000','636000','input','2026-10-15 14:10:15','F32615021015'); 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-10-15','F326150210158','2026-10-15','14:10:16','FIT','636000','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-261015-0019','D','2026-10-15','14:10:16','input','PENJUALAN','F326150210158','7891678000','636000','7892314000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='636000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150210158' 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 ('F326150210159','input',' 1',' MED2E X CM','TOKO','PM-D','D2E-ZFXC-85-0','LT X MODEL MATA CM 8K ','','0.500','1','100.00','521000','0','0','15000','521000','0','0','0','521000','FIT','00406628','D2E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZFXC-85-0' 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-10-15' AND kode_barang='D2E-ZFXC-85-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 ('F326150210159','2026-10-15','0.500','2026-10-15','14:10:16','PLG0031896','521000','521000','0','521000','521000','input','2026-10-15 14:10:15','F32615021015'); 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-10-15','F326150210159','2026-10-15','14:10:16','FIT','521000','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-261015-0020','D','2026-10-15','14:10:16','input','PENJUALAN','F326150210159','7892314000','521000','7892835000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='521000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150210159' 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 ('F3261502101510','input',' 1',' MEH1 X UB ','TOKO','PM-H','H1E-ZGAG-197-0','KL X GUCCI UB 42 8K ','','1.130','1','100.00','1179000','0','0','15000','1179000','0','0','0','1179000','FIT','00414033','H1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGAG-197-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-10-15' AND kode_barang='H1E-ZGAG-197-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F3261502101510','2026-10-15','1.130','2026-10-15','14:10:16','PLG0031897','1179000','1179000','0','1179000','1179000','input','2026-10-15 14:10:15','F32615021015'); 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-10-15','F3261502101510','2026-10-15','14:10:16','FIT','1179000','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-261015-0021','D','2026-10-15','14:10:16','input','PENJUALAN','F3261502101510','7892835000','1179000','7894014000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1179000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F3261502101510' 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 ('F3261502101511','input',' 1',' MEH1 X HW ','TOKO','PM-H','H1E-ZHBG-33-0','KL X KOREA HW 44 8K ','','2.910','1','100.00','3035000','0','0','15000','3035000','0','0','0','3035000','FIT','00420699','H1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHBG-33-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.910',berat_jual_asli=berat_jual_asli+'2.910',stock_jual='1',berat_akhir=berat_akhir-'2.910',berat_akhir_asli=berat_akhir_asli-'2.910',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='H1E-ZHBG-33-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 ('F3261502101511','2026-10-15','2.910','2026-10-15','14:10:16','PLG0031898','3035000','3035000','0','3035000','3035000','input','2026-10-15 14:10:15','F32615021015'); 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-10-15','F3261502101511','2026-10-15','14:10:16','FIT','3035000','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-261015-0022','D','2026-10-15','14:10:16','input','PENJUALAN','F3261502101511','7894014000','3035000','7897049000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='3035000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F3261502101511' 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 ('F326150211251','input','1',' MEF3 HW ','TOKO','PM-F','F3E-ZIBA-440-0','GL MODEL FANCY POLOS HW 8K ','','2.000','1','100.00','2086000','0','0','15000','2086000','0','0','0','2086000','LIS','00424984','F3E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIBA-440-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='F3E-ZIBA-440-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 ('F326150211251','2026-10-15','2.000','2026-10-15','14:11:26','PLG0031899','2086000','2086000','0','2086000','2086000','input','2026-10-15 14:11:25','F32615021125'); 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-10-15','F326150211251','2026-10-15','14:11:26','LIS','2086000','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-261015-0023','D','2026-10-15','14:11:26','input','PENJUALAN','F326150211251','7897049000','2086000','7899135000'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150210151' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150210151' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150210151'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F3261502101510' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F3261502101510' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F3261502101510'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F3261502101511' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F3261502101511' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F3261502101511'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150210152' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150210152' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150210152'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150210153' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150210153' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150210153'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150210154' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150210154' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150210154'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150210155' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150210155' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150210155'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150210156' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150210156' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150210156'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150210157' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150210157' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150210157'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150210159' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150210159' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150210159'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150210158' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150210158' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150210158'; 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 ('F326150223511','kasir','1',' MEF1 X YT ','TOKO','PM-F','F1E-ZJXF-195-0','GL X OVAL C SLEP YT 60 8K ','','2.210','1','100.00','2305000','0','0','15000','2305000','0','0','0','2305000','FIT','00428099','F1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZJXF-195-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.210',berat_jual_asli=berat_jual_asli+'2.210',stock_jual='1',berat_akhir=berat_akhir-'2.210',berat_akhir_asli=berat_akhir_asli-'2.210',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='F1E-ZJXF-195-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 ('F326150223511','2026-10-15','2.210','2026-10-15','14:23:52','PLG0031900','2305000','2305000','0','2305000','2305000','kasir','2026-10-15 14:23:51','F32615022351'); 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-10-15','F326150223511','2026-10-15','14:23:52','FIT','2305000','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-261015-0035','D','2026-10-15','14:23:52','kasir','PENJUALAN','F326150223511','7887513000','2305000','7889818000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='2305000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150223511' 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 ('F326150223512','kasir',' 1',' MEF2 CM D5','TOKO','PM-F','F2E-ZJXA-89-0','GL OVAL MODEL MATA VAR CM D55 8K ','','1.230','1','100.00','1283000','0','0','15000','1283000','0','0','0','1283000','FIT','00426722','F2E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZJXA-89-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.230',berat_jual_asli=berat_jual_asli+'1.230',stock_jual='1',berat_akhir=berat_akhir-'1.230',berat_akhir_asli=berat_akhir_asli-'1.230',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='F2E-ZJXA-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 ('F326150223512','2026-10-15','1.230','2026-10-15','14:23:52','PLG0031901','1283000','1283000','0','1283000','1283000','kasir','2026-10-15 14:23:51','F32615022351'); 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-10-15','F326150223512','2026-10-15','14:23:52','FIT','1283000','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-261015-0036','D','2026-10-15','14:23:52','kasir','PENJUALAN','F326150223512','7889818000','1283000','7891101000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1283000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150223512' 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 ('F326150223513','kasir',' 1',' MEH1 X HW ','TOKO','PM-H','H1E-ZHBG-33-0','KL X KOREA HW 44 8K ','','2.910','1','100.00','3035000','0','0','15000','3035000','0','0','0','3035000','FIT','00420699','H1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHBG-33-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.910',berat_jual_asli=berat_jual_asli+'2.910',stock_jual='1',berat_akhir=berat_akhir-'2.910',berat_akhir_asli=berat_akhir_asli-'2.910',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='H1E-ZHBG-33-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 ('F326150223513','2026-10-15','2.910','2026-10-15','14:23:52','PLG0031902','3035000','3035000','0','3035000','3035000','kasir','2026-10-15 14:23:51','F32615022351'); 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-10-15','F326150223513','2026-10-15','14:23:52','FIT','3035000','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-261015-0037','D','2026-10-15','14:23:52','kasir','PENJUALAN','F326150223513','7891101000','3035000','7894136000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='3035000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150223513' 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 ('F326150223514','kasir',' 1',' MEH1 X UB ','TOKO','PM-H','H1E-ZGAG-197-0','KL X GUCCI UB 42 8K ','','1.130','1','100.00','1179000','0','0','15000','1179000','0','0','0','1179000','FIT','00414033','H1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGAG-197-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-10-15' AND kode_barang='H1E-ZGAG-197-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326150223514','2026-10-15','1.130','2026-10-15','14:23:52','PLG0031903','1179000','1179000','0','1179000','1179000','kasir','2026-10-15 14:23:51','F32615022351'); 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-10-15','F326150223514','2026-10-15','14:23:52','FIT','1179000','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-261015-0038','D','2026-10-15','14:23:52','kasir','PENJUALAN','F326150223514','7894136000','1179000','7895315000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1179000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150223514' 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 ('F326150224341','kasir','1',' MED2E X CM','TOKO','PM-D','D2E-ZFXC-85-0','LT X MODEL MATA CM 8K ','','0.500','1','100.00','521000','0','0','15000','521000','0','0','0','521000','FIT','00406628','D2E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZFXC-85-0' 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-10-15' AND kode_barang='D2E-ZFXC-85-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 ('F326150224341','2026-10-15','0.500','2026-10-15','14:24:35','PLG0031904','521000','521000','0','521000','521000','kasir','2026-10-15 14:24:34','F32615022434'); 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-10-15','F326150224341','2026-10-15','14:24:35','FIT','521000','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-261015-0039','D','2026-10-15','14:24:35','kasir','PENJUALAN','F326150224341','7895315000','521000','7895836000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='521000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150224341' 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 ('F326150224342','kasir',' 1',' MEB1 LG PE','TOKO','PM-B','B1E-ZEBX-218-0','GW MODEL MATA LG PE 8K ','','0.610','1','100.00','636000','0','0','15000','636000','0','0','0','636000','FIT','00404496','B1E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEBX-218-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='B1E-ZEBX-218-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 ('F326150224342','2026-10-15','0.610','2026-10-15','14:24:35','PLG0031905','636000','636000','0','636000','636000','kasir','2026-10-15 14:24:34','F32615022434'); 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-10-15','F326150224342','2026-10-15','14:24:35','FIT','636000','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-261015-0040','D','2026-10-15','14:24:35','kasir','PENJUALAN','F326150224342','7895836000','636000','7896472000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='636000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150224342' 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 ('F326150224343','kasir',' 1',' MDB1 LG PE','TOKO','PM-B','B1D-ZIAI-305-0','GW MODEL MATA LG PE 8K ','','0.950','1','100.00','972000','0','0','15000','972000','0','0','0','972000','FIT','00424527','B1D','0','0','-','0','1023000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZIAI-305-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-10-15' AND kode_barang='B1D-ZIAI-305-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 ('F326150224343','2026-10-15','0.950','2026-10-15','14:24:35','PLG0031906','972000','972000','0','972000','972000','kasir','2026-10-15 14:24:34','F32615022434'); 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-10-15','F326150224343','2026-10-15','14:24:35','FIT','972000','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-261015-0041','D','2026-10-15','14:24:35','kasir','PENJUALAN','F326150224343','7896472000','972000','7897444000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='972000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150224343' 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 ('F326150225201','kasir','1',' MFE1 KH 14','TOKO','PM-E','E1F-ZJXE-402-0','CC MODEL DAUN SLEP KH 14 8K ','','0.400','1','100.00','425000','0','0','15000','425000','0','0','0','425000','FIT','00427893','E1F','0','0','-','0','1063000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZJXE-402-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-10-15' AND kode_barang='E1F-ZJXE-402-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 ('F326150225201','2026-10-15','0.400','2026-10-15','14:25:21','PLG0031907','425000','425000','0','425000','425000','kasir','2026-10-15 14:25:20','F32615022520'); 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-10-15','F326150225201','2026-10-15','14:25:21','FIT','425000','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-261015-0042','D','2026-10-15','14:25:21','kasir','PENJUALAN','F326150225201','7897444000','425000','7897869000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='425000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150225201' 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 ('F326150225202','kasir',' 1',' MFE2 KH 14','TOKO','PM-E','E2F-ZJXA-104-0','CC MODEL MATA VAR KH 14 8K ','','0.370','1','100.00','393000','0','0','15000','393000','0','0','0','393000','FIT','00426737','E2F','0','0','-','0','1063000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZJXA-104-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='E2F-ZJXA-104-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 ('F326150225202','2026-10-15','0.370','2026-10-15','14:25:21','PLG0031908','393000','393000','0','393000','393000','kasir','2026-10-15 14:25:20','F32615022520'); 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-10-15','F326150225202','2026-10-15','14:25:21','FIT','393000','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-261015-0043','D','2026-10-15','14:25:21','kasir','PENJUALAN','F326150225202','7897869000','393000','7898262000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='393000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150225202' 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 ('F326150225203','kasir',' 1',' MFE1 KH 14','TOKO','PM-E','E1F-ZJXE-393-0','CC MODEL SPECTRA SLEP KH 14 8K ','','0.360','1','100.00','383000','0','0','15000','383000','0','0','0','383000','FIT','00427884','E1F','0','0','-','0','1063000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZJXE-393-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-10-15' AND kode_barang='E1F-ZJXE-393-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 ('F326150225203','2026-10-15','0.360','2026-10-15','14:25:21','PLG0031909','383000','383000','0','383000','383000','kasir','2026-10-15 14:25:20','F32615022520'); 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-10-15','F326150225203','2026-10-15','14:25:21','FIT','383000','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-261015-0044','D','2026-10-15','14:25:21','kasir','PENJUALAN','F326150225203','7898262000','383000','7898645000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='383000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150225203' 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 ('F326150225204','kasir',' 1',' MEE2 X KH ','TOKO','PM-E','E2E-ZIBE-206-0','CC X MODEL MATA KH 14 8K ','','0.470','1','100.00','490000','0','0','15000','490000','0','0','0','490000','FIT','00425581','E2E','0','0','-','0','1053000'); UPDATE tm_barang SET tgl_last_jual='2026-10-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZIBE-206-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-10-15' AND kode_barang='E2E-ZIBE-206-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 ('F326150225204','2026-10-15','0.470','2026-10-15','14:25:21','PLG0031910','490000','490000','0','490000','490000','kasir','2026-10-15 14:25:20','F32615022520'); 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-10-15','F326150225204','2026-10-15','14:25:21','FIT','490000','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-261015-0045','D','2026-10-15','14:25:21','kasir','PENJUALAN','F326150225204','7898645000','490000','7899135000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='490000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150225204' LIMIT 1; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261015-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261015-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261015-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261015-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261015-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261015-0003'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150154421' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150154421' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150154421'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150211251' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150211251' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150211251'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150223511' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150223511' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150223511'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150223512' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150223512' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150223512'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150223513' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150223513' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150223513'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150223514' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150223514' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150223514'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150224341' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150224341' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150224341'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150224342' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150224342' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150224342'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150224343' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150224343' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150224343'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150225201' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150225201' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150225201'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150225202' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150225202' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150225202'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150225203' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150225203' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150225203'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150225204' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150225204' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150225204'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150756341' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150756341' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150756341'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150925081' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150925081' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150925081'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150930321' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150930321' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150930321'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326151015231' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326151015231' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326151015231'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326151131171' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326151131171' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326151131171'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326151145381' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326151145381' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326151145381'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-16','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-15'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-15'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-15'; 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-10-15' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-15'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-15'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-15'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-15'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; UPDATE tt_barang_saldo SET tanggal= '2026-10-16' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-15' 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-261016-0001','D','2026-10-16','15:10:19','SYSTEM','SALDO AWAL','SALDO AWAL','0','7899135000','7899135000'); 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-261016-0001','D','2026-10-16','15:10:19','BCA','SALDO AWAL','SALDO AWAL','0','743627000','743627000'); 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-261016-0001','D','2026-10-16','15:10:19','BRI','SALDO AWAL','SALDO AWAL','0','0','0'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261016-0001','D','2026-10-16','15:10:19','DLL','SALDO AWAL','SALDO AWAL','0','0','0'); UPDATE tp_system SET tgl_system='2026-10-16';