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 ('F326260925521','kasir','1',' MEF3E X HW','TOKO','PM-F','F3E-ZJAF-17-0','GL X CAPELLA DAUN SLEP VAR HW 8K ','','1.660','1','100.00','1701000','0','0','15000','1702000','0','0','0','1702000','FIT','00430196','F3E','0','0','-','0','1035000'); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJAF-17-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.660',berat_jual_asli=berat_jual_asli+'1.660',stock_jual='1',berat_akhir=berat_akhir-'1.660',berat_akhir_asli=berat_akhir_asli-'1.660',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='F3E-ZJAF-17-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 ('F326260925521','2026-10-26','1.660','2026-10-26','09:25:52','PLG0032065','1702000','1702000','0','1702000','1702000','kasir','2026-10-26 09:25:52','F32626092552'); 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-26','F326260925521','2026-10-26','09:25:52','FIT','1702000','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-261026-0002','D','2026-10-26','09:25:52','kasir','PENJUALAN','F326260925521','8003919000','1702000','8005621000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1702000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326260925521' 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 ('F326260925522','kasir',' 1',' MDE2 CM 10','TOKO','PM-E','E2D-ZIBH-409-0','CC MODEL MATA CM 10 8K ','','1.000','1','100.00','1005000','0','0','15000','1005000','0','0','0','1005000','FIT','00426388','E2D','0','0','-','0','1015000'); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZIBH-409-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-26' AND kode_barang='E2D-ZIBH-409-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 ('F326260925522','2026-10-26','1.000','2026-10-26','09:25:52','PLG0032066','1005000','1005000','0','1005000','1005000','kasir','2026-10-26 09:25:52','F32626092552'); 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-26','F326260925522','2026-10-26','09:25:52','FIT','1005000','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-261026-0003','D','2026-10-26','09:25:52','kasir','PENJUALAN','F326260925522','8005621000','1005000','8006626000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1005000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326260925522' 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 ('F326260931491','kasir','1',' MEB1 X LG ','TOKO','PM-B','B1E-ZDBX-238-0','GW X MODEL MATA LG PE 8K ','','0.620','1','100.00','635000','0','0','15000','635000','0','0','0','635000','SIN','00400175','B1E','0','0','-','0','1035000'); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDBX-238-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.620',berat_jual_asli=berat_jual_asli+'0.620',stock_jual='1',berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='B1E-ZDBX-238-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 ('F326260931491','2026-10-26','0.620','2026-10-26','09:31:49','PLG0032067','635000','635000','0','635000','635000','kasir','2026-10-26 09:31:49','F32626093149'); 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-26','F326260931491','2026-10-26','09:31:49','SIN','635000','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-261026-0004','D','2026-10-26','09:31:49','kasir','PENJUALAN','F326260931491','8006626000','635000','8007261000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='635000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326260931491' 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 ('F326260931492','kasir',' 1',' MFA1F X UB','TOKO','PM-A','A1F-YFBH-134-0','AT X MODEL ARESO PASIR UB 8K ','','1.440','1','100.00','1505000','0','0','15000','1505000','0','0','0','1505000','SIN','00358842','A1F','0','0','-','0','1055000'); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-YFBH-134-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.440',berat_jual_asli=berat_jual_asli+'1.440',stock_jual='1',berat_akhir=berat_akhir-'1.440',berat_akhir_asli=berat_akhir_asli-'1.440',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='A1F-YFBH-134-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 ('F326260931492','2026-10-26','1.440','2026-10-26','09:31:49','PLG0032068','1505000','1505000','0','1505000','1505000','kasir','2026-10-26 09:31:49','F32626093149'); 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-26','F326260931492','2026-10-26','09:31:49','SIN','1505000','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-261026-0005','D','2026-10-26','09:31:49','kasir','PENJUALAN','F326260931492','8007261000','1505000','8008766000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1505000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326260931492' 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 ('F326260947371','kasir','1',' TGA1 CM ','TOKO','PT-A','A1TG-ZGAG-45-T','AT TINDIK BABY CM 17K ','','0.230','1','100.00','444000','0','0','15000','445000','0','0','0','445000','FIT','T0081268','A1TG','0','0','-','0','1930000'); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TG-ZGAG-45-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.230',berat_jual_asli=berat_jual_asli+'0.230',stock_jual='1',berat_akhir=berat_akhir-'0.230',berat_akhir_asli=berat_akhir_asli-'0.230',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='A1TG-ZGAG-45-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 ('F326260947371','2026-10-26','0.230','2026-10-26','09:47:37','PLG0032069','445000','445000','0','445000','445000','kasir','2026-10-26 09:47:37','F32626094737'); 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-26','F326260947371','2026-10-26','09:47:37','FIT','445000','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-261026-0006','D','2026-10-26','09:47:37','kasir','PENJUALAN','F326260947371','8008766000','445000','8009211000'); 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-00020641','X-00020641','GL X TIFF MATA VAR KH 8K','GR','---','F3E','BELI','BELI001','3227000','2026-10-26','3.380','1','kasir','2026-10-26 10:59:39'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020641','X-00020641'); 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-261026-0001','F325070915241','AAT','1','BELI','BELI001','F3E', 'X-00020641', 'GL X TIFF MATA VAR KH 8K','3.380','3.380','100.00','3470000','3227000','954734','1035000','1','3227000','3227000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.380',berat_beli_asli=berat_beli_asli+'3.380',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.380',berat_akhir_asli=berat_akhir_asli+'3.380',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-26' 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-261026-0001','2026-10-26','2026-10-26','10:59:38','AAT','---','3.380','3227000','3227000','3227000','3227000','3227000','kasir','2026-10-26 10:59:39','FB-261026-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261026-0001','IKA','RANDUSARI','','','','kasir','2026-10-26 10:59:39'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-26' 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-261026-0007','K','2026-10-26','10:59:38','kasir','PEMBELIAN UMUM','FB-261026-0001','8009211000','3227000','8005984000'); 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-00020642','X-00020642','CC MODEL BONEKA ANAK CAT MATA LG 8K','GR','---','E2E','BELI','BELI001','453000','2026-10-26','0.480','1','kasir','2026-10-26 10:59:39'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020642','X-00020642'); 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-261026-0002','F325070939191','AAT','2','BELI','BELI001','E2E', 'X-00020642', 'CC MODEL BONEKA ANAK CAT MATA LG 8K','0.480','0.480','100.00','493000','453000','943750','1035000','1','453000','453000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.480',berat_beli_asli=berat_beli_asli+'0.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.480',berat_akhir_asli=berat_akhir_asli+'0.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-26' 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-261026-0002','2026-10-26','2026-10-26','10:59:38','AAT','---','0.480','453000','453000','453000','453000','453000','kasir','2026-10-26 10:59:39','FB-261026-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261026-0002','TIKA','JAGIR SLOGOHIMO','','','','kasir','2026-10-26 10:59:39'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-26' 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-261026-0008','K','2026-10-26','10:59:38','kasir','PEMBELIAN UMUM','FB-261026-0002','8005984000','453000','8005531000'); 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-00020643','X-00020643','CC X BABY PLAT LG 8K','GR','---','E1F','BELI','BELI001','535000','2026-10-26','0.550','1','kasir','2026-10-26 10:59:39'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1F'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1F','X-00020643','X-00020643'); 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-261026-0003','F325070938331','AAT','3','BELI','BELI001','E1F', 'X-00020643', 'CC X BABY PLAT LG 8K','0.550','0.550','100.00','575000','535000','972727','1055000','1','535000','535000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.550',berat_beli_asli=berat_beli_asli+'0.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.550',berat_akhir_asli=berat_akhir_asli+'0.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1F' 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-261026-0003','2026-10-26','2026-10-26','10:59:38','AAT','---','0.550','535000','535000','535000','535000','535000','kasir','2026-10-26 10:59:39','FB-261026-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261026-0003','TIKA','JAGIR SLOGOHIMO','','','','kasir','2026-10-26 10:59:39'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-26' 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-261026-0009','K','2026-10-26','10:59:38','kasir','PEMBELIAN UMUM','FB-261026-0003','8005531000','535000','8004996000'); 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-00020644','X-00020644','CC MODEL PAKU MATA VAR KH 14 8K','GR','---','E2F','BELI','BELI001','380000','2026-10-26','0.400','1','kasir','2026-10-26 11:00:10'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2F'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2F','X-00020644','X-00020644'); 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-261026-0004','F326011018412','SIN','1','BELI','BELI001','E2F', 'X-00020644', 'CC MODEL PAKU MATA VAR KH 14 8K','0.400','0.400','100.00','422000','380000','950000','1055000','1','380000','380000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.400',berat_beli_asli=berat_beli_asli+'0.400',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.400',berat_akhir_asli=berat_akhir_asli+'0.400',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2F' 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-261026-0004','2026-10-26','2026-10-26','11:00:09','SIN','---','0.400','380000','380000','380000','380000','380000','kasir','2026-10-26 11:00:10','FB-261026-0004'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261026-0004','DWI','PUHPELEM','','','','kasir','2026-10-26 11:00:10'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-26' 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-261026-0010','K','2026-10-26','11:00:09','kasir','PEMBELIAN UMUM','FB-261026-0004','8004996000','380000','8004616000'); 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-00020645','X-00020645','CC MODEL SPECTRA SLEP KH 12 8K','GR','---','E1F','BELI','BELI001','332000','2026-10-26','0.350','1','kasir','2026-10-26 11:02:08'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1F'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1F','X-00020645','X-00020645'); 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-261026-0005','F326280903571','SIN','1','BELI','BELI001','E1F', 'X-00020645', 'CC MODEL SPECTRA SLEP KH 12 8K','0.350','0.350','100.00','373000','332000','948571','1055000','1','332000','332000','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-10-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1F' 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-261026-0005','2026-10-26','2026-10-26','11:02:08','SIN','---','0.350','332000','332000','332000','332000','332000','kasir','2026-10-26 11:02:08','FB-261026-0005'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261026-0005','SUNARSIH','JANGGIR SUMBER GALIH','','','','kasir','2026-10-26 11:02:08'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-26' 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-261026-0011','K','2026-10-26','11:02:08','kasir','PEMBELIAN UMUM','FB-261026-0005','8004616000','332000','8004284000'); 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-00020646','X-00020646','GL CASTELI SPECTRA SLEP HW 8K','GR','---','F3E','BELI','BELI001','1675000','2026-10-26','1.760','1','kasir','2026-10-26 11:02:28'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020646','X-00020646'); 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-261026-0006','F326301119311','SIN','1','BELI','BELI001','F3E', 'X-00020646', 'GL CASTELI SPECTRA SLEP HW 8K','1.760','1.760','100.00','1848000','1675000','951705','1035000','1','1675000','1675000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.760',berat_beli_asli=berat_beli_asli+'1.760',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.760',berat_akhir_asli=berat_akhir_asli+'1.760',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-26' 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-261026-0006','2026-10-26','2026-10-26','11:02:28','SIN','---','1.760','1675000','1675000','1675000','1675000','1675000','kasir','2026-10-26 11:02:28','FB-261026-0006'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261026-0006','NIA AYU','SUKOBOYO SLOGOHIMO','','','','kasir','2026-10-26 11:02:28'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-26' 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-261026-0012','K','2026-10-26','11:02:28','kasir','PEMBELIAN UMUM','FB-261026-0006','8004284000','1675000','8002609000'); 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-00020647','X-00020647','CC WEDDING MATA CM 18 8K','GR','---','E2D','BELI','BELI001','890000','2026-10-26','1.060','1','kasir','2026-10-26 11:03:43'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020647','X-00020647'); 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-261026-0007','F326191024272','LIS','1','BELI','BELI001','E2D', 'X-00020647', 'CC WEDDING MATA CM 18 8K','1.060','1.060','100.00','1130000','890000','839623','1015000','1','890000','890000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.060',berat_beli_asli=berat_beli_asli+'1.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.060',berat_akhir_asli=berat_akhir_asli+'1.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-26' 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-261026-0007','2026-10-26','2026-10-26','11:03:42','LIS','---','1.060','890000','890000','890000','890000','890000','kasir','2026-10-26 11:03:43','FB-261026-0007'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261026-0007','RINA','BITING PURWANTORO','','','085939200596','kasir','2026-10-26 11:03:43'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-26' 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-261026-0013','K','2026-10-26','11:03:42','kasir','PEMBELIAN UMUM','FB-261026-0007','8002609000','890000','8001719000'); 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-00020648','X-00020648','AT X GYPSY ARESO LG','GR','---','A1TF','BELI','BELI001','708000','2026-10-26','0.510','1','kasir','2026-10-26 11:05:43'); DELETE FROM tp_barang WHERE kode_dept = 'X-A1TF'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1TF','X-00020648','X-00020648'); 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-261026-0008','F322211042402','SIN','1','BELI','BELI001','A1TF', 'X-00020648', 'AT X GYPSY ARESO LG','0.510','0.510','100.00','395000','708000','1388235','1910000','1','708000','708000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1TF' 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-261026-0008','2026-10-26','2026-10-26','11:05:43','SIN','---','0.510','708000','708000','708000','708000','708000','kasir','2026-10-26 11:05:43','FB-261026-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261026-0008','LINTANG','TERBIS KISMANTORO','','','','kasir','2026-10-26 11:05:43'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-26' 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-261026-0014','K','2026-10-26','11:05:43','kasir','PEMBELIAN UMUM','FB-261026-0008','8001719000','708000','8001011000'); 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-00020649','X-00020649','GL XX PIPA MATA MP 54 8K','GR','---','F2E','BELI','BELI001','2550000','2026-10-26','3.160','1','kasir','2026-10-26 11:38:52'); DELETE FROM tp_barang WHERE kode_dept = 'X-F2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00020649','X-00020649'); 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-261026-0009','F325161032131','SIN','1','BELI','BELI001','F2E', 'X-00020649', 'GL XX PIPA MATA MP 54 8K','3.160','3.160','100.00','2685000','2550000','806962','1035000','1','2550000','2550000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.160',berat_beli_asli=berat_beli_asli+'3.160',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.160',berat_akhir_asli=berat_akhir_asli+'3.160',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F2E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261026-0009','2026-10-26','2026-10-26','11:38:51','SIN','---','3.160','2550000','2550000','2550000','2550000','2550000','kasir','2026-10-26 11:38:52','FB-261026-0009'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261026-0009','TRIA','BLIMBING PURWANTORO','','','','kasir','2026-10-26 11:38:52'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-26' 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-261026-0015','K','2026-10-26','11:38:51','kasir','PEMBELIAN UMUM','FB-261026-0009','8001011000','2550000','7998461000'); 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-00020650','X-00020650','CC X WEDDING POLOS CM 22 8K','GR','---','E1D','BELI','BELI001','972000','2026-10-26','1.030','1','kasir','2026-10-26 11:51:41'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00020650','X-00020650'); 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-261026-0010','F326091115431','AAT','1','BELI','BELI001','E1D', 'X-00020650', 'CC X WEDDING POLOS CM 22 8K','1.030','1.030','100.00','1283000','972000','943689','1015000','1','972000','972000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.030',berat_beli_asli=berat_beli_asli+'1.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.030',berat_akhir_asli=berat_akhir_asli+'1.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261026-0010','2026-10-26','2026-10-26','11:51:40','AAT','---','1.030','972000','972000','972000','972000','972000','kasir','2026-10-26 11:51:41','FB-261026-0010'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261026-0010','ANA','SLOGOHIMO','','','082242411613','kasir','2026-10-26 11:51:41'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-26' 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-261026-0016','K','2026-10-26','11:51:40','kasir','PEMBELIAN UMUM','FB-261026-0010','7998461000','972000','7997489000'); 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 ('F326261152371','kasir','1',' MEH1 X UB ','TOKO','PM-H','H1E-ZJAE-265-0','KL X NORY UB 44 8K ','','2.030','1','100.00','2081000','0','0','15000','2080000','0','0','0','2080000','SIN','00430148','H1E','0','0','-','1','1035000'); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZJAE-265-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2026-10-26' AND kode_barang='H1E-ZJAE-265-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 ('F326261152371','2026-10-26','2.030','2026-10-26','11:52:37','PLG0032070','2080000','2080000','0','2080000','2080000','kasir','2026-10-26 11:52:37','F32626115237'); 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-26','F326261152371','2026-10-26','11:52:37','SIN','2080000','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-261026-0017','D','2026-10-26','11:52:37','kasir','PENJUALAN','F326261152371','7997489000','2080000','7999569000'); 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-00020651','X-00020651','KL X NORY KH 44 8K','GR','---','H1E','BELI','BELI001','1520000','2026-10-26','2.130','1','kasir','2026-10-26 11:54:30'); DELETE FROM tp_barang WHERE kode_dept = 'X-H1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020651','X-00020651'); 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-261026-0011','F324311005041','SIN','1','BELI','BELI001','H1E', 'X-00020651', 'KL X NORY KH 44 8K','2.130','2.130','100.00','1460000','1520000','713615','1035000','1','1520000','1520000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.130',berat_beli_asli=berat_beli_asli+'2.130',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.130',berat_akhir_asli=berat_akhir_asli+'2.130',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-26' 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-261026-0011','2026-10-26','2026-10-26','11:54:29','SIN','---','2.130','1520000','1520000','1520000','1520000','1520000','kasir','2026-10-26 11:54:30','FB-261026-0011'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261026-0011','AQILA','KARANGLO TEGALREJO','','','','kasir','2026-10-26 11:54:30'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-26' 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-261026-0018','K','2026-10-26','11:54:29','kasir','PEMBELIAN UMUM','FB-261026-0011','7999569000','1520000','7998049000'); 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-00020652','X-00020652','GL X PIPA MATA LG 56 8K','GR','---','F2E','BELI','BELI001','3752000','2026-10-26','3.900','1','kasir','2026-10-26 11:58:03'); DELETE FROM tp_barang WHERE kode_dept = 'X-F2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00020652','X-00020652'); 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-261026-0012','F326271130441','SIN','1','BELI','BELI001','F2E', 'X-00020652', 'GL X PIPA MATA LG 56 8K','3.900','3.900','100.00','4407000','3752000','962051','1035000','1','3752000','3752000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.900',berat_beli_asli=berat_beli_asli+'3.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.900',berat_akhir_asli=berat_akhir_asli+'3.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F2E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261026-0012','2026-10-26','2026-10-26','11:58:02','SIN','---','3.900','3752000','3752000','3752000','3752000','3752000','kasir','2026-10-26 11:58:03','FB-261026-0012'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261026-0012','BU ARISTA','KARANGLO TEGALREJO','','','082221218884','kasir','2026-10-26 11:58:03'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-26' 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-261026-0019','K','2026-10-26','11:58:02','kasir','PEMBELIAN UMUM','FB-261026-0012','7998049000','3752000','7994297000'); 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 ('F326261204531','kasir','1',' TDA1 UB ','TOKO','PT-A','A1TD-ZJXE-255-T','AT MODEL HATI ARESO UB 17K ','','1.030','1','100.00','1926000','0','0','15000','1925000','0','0','0','1925000','AAT','T0085765','A1TD','0','0','-','1','1870000'); UPDATE tm_barang SET tgl_last_jual='2026-10-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TD-ZJXE-255-T' 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-10-26' AND kode_barang='A1TD-ZJXE-255-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 ('F326261204531','2026-10-26','1.030','2026-10-26','12:04:53','PLG0032071','1925000','1925000','0','1925000','1925000','kasir','2026-10-26 12:04:53','F32626120453'); 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-26','F326261204531','2026-10-26','12:04:53','AAT','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) VALUES ('KM-261026-0020','D','2026-10-26','12:04:53','kasir','PENJUALAN','F326261204531','7994297000','1925000','7996222000'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261026-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261026-0007'; 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-00020653','X-00020653','CC WEDDING MATA CM 18 8K','GR','---','E2D','BELI','BELI001','990000','2026-10-26','1.060','1','kasir','2026-10-26 14:28:52'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020653','X-00020653'); 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-261026-0013','F326191024272','LIS','1','BELI','BELI001','E2D', 'X-00020653', 'CC WEDDING MATA CM 18 8K','1.060','1.060','100.00','1130000','990000','933962','1015000','1','990000','990000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.060',berat_beli_asli=berat_beli_asli+'1.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.060',berat_akhir_asli=berat_akhir_asli+'1.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-26' 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-261026-0013','2026-10-26','2026-10-26','14:28:51','LIS','---','1.060','990000','990000','990000','990000','990000','kasir','2026-10-26 14:28:52','FB-261026-0013'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261026-0013','RINA','BITING PURWANTORO','','','085939200596','kasir','2026-10-26 14:28:52'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-26' 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-261026-0022','K','2026-10-26','14:28:51','kasir','PEMBELIAN UMUM','FB-261026-0013','7997112000','990000','7996122000'); 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-00020654','X-00020654','AT X MODEL ARESO VAR HW 8K','GR','---','A1D','BELI','BELI001','802000','2026-10-26','0.850','1','kasir','2026-10-26 14:33:58'); DELETE FROM tp_barang WHERE kode_dept = 'X-A1D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00020654','X-00020654'); 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-261026-0014','F326161006501','SIN','1','BELI','BELI001','A1D', 'X-00020654', 'AT X MODEL ARESO VAR HW 8K','0.850','0.850','100.00','910000','802000','943529','1015000','1','802000','802000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.850',berat_beli_asli=berat_beli_asli+'0.850',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.850',berat_akhir_asli=berat_akhir_asli+'0.850',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-26' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' 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-261026-0014','2026-10-26','2026-10-26','14:33:57','SIN','---','0.850','802000','802000','802000','802000','802000','kasir','2026-10-26 14:33:58','FB-261026-0014'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261026-0014','SINDY','CRABAK GAMBIRANOM KISMANTORO','','','085728450819','kasir','2026-10-26 14:33:58'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-26' 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-261026-0023','K','2026-10-26','14:33:57','kasir','PEMBELIAN UMUM','FB-261026-0014','7996122000','802000','7995320000'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261026-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261026-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261026-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261026-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261026-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261026-0003'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261026-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261026-0004'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261026-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261026-0005'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261026-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261026-0006'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261026-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261026-0008'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261026-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261026-0009'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261026-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261026-0010'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261026-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261026-0011'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261026-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261026-0012'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261026-0013' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261026-0013'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261026-0014' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261026-0014'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260925521' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260925521' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260925521'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260925522' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260925522' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260925522'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260931491' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260931491' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260931491'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260931492' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260931492' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260931492'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326260947371' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326260947371' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326260947371'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261152371' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261152371' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261152371'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326261204531' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326261204531' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326261204531'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-27','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-26'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-26'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-26'; 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-26' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-26'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-26'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-26'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-26'; 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-27' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-26' 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-261027-0001','D','2026-10-27','15:09:42','SYSTEM','SALDO AWAL','SALDO AWAL','0','7995320000','7995320000'); 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-261027-0001','D','2026-10-27','15:09:42','BCA','SALDO AWAL','SALDO AWAL','0','748085000','748085000'); 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-261027-0001','D','2026-10-27','15:09:42','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-261027-0001','D','2026-10-27','15:09:42','BRI','SALDO AWAL','SALDO AWAL','0','0','0'); UPDATE tp_system SET tgl_system='2026-10-27';