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 ('F326250815221','input','1',' MEA1E X HW','TOKO','PM-A','A1E-ZFXH-61-0','AT X MODEL HATI VAR HW 8K ','','0.600','1','100.00','615000','0','0','15000','615000','0','0','0','615000','LIS','00407922','A1E','0','0','-','0','1035000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZFXH-61-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-10-25' AND kode_barang='A1E-ZFXH-61-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 ('F326250815221','2026-10-25','0.600','2026-10-25','08:15:23','PLG0032042','615000','615000','0','615000','615000','input','2026-10-25 08:15:22','F32625081522'); 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-25','F326250815221','2026-10-25','08:15:23','LIS','615000','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-261025-0002','D','2026-10-25','08:15:23','input','PENJUALAN','F326250815221','7979929000','615000','7980544000'); 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 ('F326250926051','input','1',' MDE2 10K C','TOKO','PM-E','E2D-ZIAE-294-0','CC WEDDING MATA CM 22 8K ','','1.530','1','100.00','1538000','0','0','15000','1538000','0','10000','0','1548000','LIS','00423830','E2D','0','0','-','0','1015000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZIAE-294-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-10-25' AND kode_barang='E2D-ZIAE-294-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 ('F326250926051','2026-10-25','1.530','2026-10-25','09:26:06','PLG0032043','1538000','1538000','10000','1548000','1548000','input','2026-10-25 09:26:05','F32625092605'); 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-25','F326250926051','2026-10-25','09:26:06','LIS','1548000','10000'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261025-0003','D','2026-10-25','09:26:06','input','PENJUALAN','F326250926051','7980544000','1548000','7982092000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1548000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326250926051' 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 ('F326250926052','input',' 1',' MDE2 10K C','TOKO','PM-E','E2D-ZJBX-38-0','CC WEDDING MATA 14 CM 8K ','','1.540','1','100.00','1548000','0','0','15000','1547000','0','10000','0','1557000','LIS','00430637','E2D','0','0','-','1','1015000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZJBX-38-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.540',berat_jual_asli=berat_jual_asli+'1.540',stock_jual='1',berat_akhir=berat_akhir-'1.540',berat_akhir_asli=berat_akhir_asli-'1.540',stock_akhir='0' WHERE tanggal='2026-10-25' AND kode_barang='E2D-ZJBX-38-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326250926052','2026-10-25','1.540','2026-10-25','09:26:06','PLG0032044','1547000','1547000','10000','1557000','1557000','input','2026-10-25 09:26:05','F32625092605'); 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-25','F326250926052','2026-10-25','09:26:06','LIS','1557000','10000'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261025-0004','D','2026-10-25','09:26:06','input','PENJUALAN','F326250926052','7982092000','1557000','7983649000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1557000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326250926052' 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 ('F326250935541','kasir','1',' MGA1G DG ','TOKO','PM-A','A1G-ZGAE-76-0','AT TINDIK BABY DG 8K ','','0.230','1','100.00','245000','0','0','15000','245000','0','0','0','245000','FIT','00413683','A1G','0','0','-','0','1065000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZGAE-76-0' 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-25' AND kode_barang='A1G-ZGAE-76-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 ('F326250935541','2026-10-25','0.230','2026-10-25','09:35:54','PLG0032045','245000','245000','0','245000','245000','kasir','2026-10-25 09:35:54','F32625093554'); 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-25','F326250935541','2026-10-25','09:35:54','FIT','245000','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-261025-0005','D','2026-10-25','09:35:54','kasir','PENJUALAN','F326250935541','7983649000','245000','7983894000'); 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 ('F326250955291','kasir','1',' MFE1 KH 18','TOKO','PM-E','E1F-ZJXE-398-0','CC MODEL DAU SLEP KH 18 8K ','','0.400','1','100.00','418000','0','0','15000','418000','0','0','0','418000','SIN','00427889','E1F','0','0','-','0','1055000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZJXE-398-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-25' AND kode_barang='E1F-ZJXE-398-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 ('F326250955291','2026-10-25','0.400','2026-10-25','09:55:30','PLG0032046','418000','418000','0','418000','418000','kasir','2026-10-25 09:55:29','F32625095529'); 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-25','F326250955291','2026-10-25','09:55:30','SIN','418000','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-261025-0006','D','2026-10-25','09:55:30','kasir','PENJUALAN','F326250955291','7983894000','418000','7984312000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='418000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326250955291' 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 ('F326250955292','kasir',' 1',' MEE1 LG 18','TOKO','PM-E','E1E-ZGXA-315-0','CC MODEL DAUN SLEP LG 18 8K ','','0.500','1','100.00','512000','0','0','15000','513000','0','0','0','513000','SIN','00411839','E1E','0','0','-','0','1035000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZGXA-315-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-25' AND kode_barang='E1E-ZGXA-315-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 ('F326250955292','2026-10-25','0.500','2026-10-25','09:55:30','PLG0032047','513000','513000','0','513000','513000','kasir','2026-10-25 09:55:29','F32625095529'); 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-25','F326250955292','2026-10-25','09:55:30','SIN','513000','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-261025-0007','D','2026-10-25','09:55:30','kasir','PENJUALAN','F326250955292','7984312000','513000','7984825000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='513000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326250955292' 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 ('F326250955293','kasir',' 1',' MEE2 KH 18','TOKO','PM-E','E2E-ZJXE-372-0','CC MODEL SNAKE MATA KH 18 8K ','','0.480','1','100.00','492000','0','0','15000','492000','0','0','0','492000','SIN','00427863','E2E','0','0','-','0','1035000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZJXE-372-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-10-25' AND kode_barang='E2E-ZJXE-372-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 ('F326250955293','2026-10-25','0.480','2026-10-25','09:55:30','PLG0032048','492000','492000','0','492000','492000','kasir','2026-10-25 09:55:29','F32625095529'); 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-25','F326250955293','2026-10-25','09:55:30','SIN','492000','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-261025-0008','D','2026-10-25','09:55:30','kasir','PENJUALAN','F326250955293','7984825000','492000','7985317000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='492000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326250955293' 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 ('F326251005001','kasir','1',' MEF1 10K C','TOKO','PM-F','F1E-ZEAF-85-0','GL OSROT BONEKA ANAK CAT CM 8K ','','1.020','1','100.00','1045000','0','0','15000','1045000','0','10000','0','1055000','AAT','00403879','F1E','0','0','-','0','1035000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEAF-85-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-10-25' AND kode_barang='F1E-ZEAF-85-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 ('F326251005001','2026-10-25','1.020','2026-10-25','10:05:01','PLG0032049','1045000','1045000','10000','1055000','1055000','kasir','2026-10-25 10:05:00','F32625100500'); 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-25','F326251005001','2026-10-25','10:05:01','AAT','1055000','10000'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261025-0009','D','2026-10-25','10:05:01','kasir','PENJUALAN','F326251005001','7985317000','1055000','7986372000'); 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 ('F326251007421','kasir','1',' MED1E LG ','TOKO','PM-D','D1E-ZJXE-359-0','LT SLOBOK DAUN SLEP LG 8K ','GT ','0.700','1','100.00','717000','0','0','15000','718000','0','30000','0','748000','FIT','00427850','D1E','0','0','-','0','1035000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZJXE-359-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-10-25' AND kode_barang='D1E-ZJXE-359-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 ('F326251007421','2026-10-25','0.700','2026-10-25','10:07:43','PLG0032050','718000','718000','30000','748000','748000','kasir','2026-10-25 10:07:42','F32625100742'); 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-25','F326251007421','2026-10-25','10:07:43','FIT','748000','30000'); 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-261025-0010','D','2026-10-25','10:07:43','kasir','PENJUALAN','F326251007421','7986372000','748000','7987120000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='748000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326251007421' 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 ('F326251007422','kasir',' 1',' MDE2 X HK ','TOKO','PM-E','E2D-ZEBH-148-0','CC X MODEL MATA HK 15 8K','','1.410','1','100.00','1417000','0','0','15000','1418000','0','0','0','1418000','FIT','00405366','E2D','0','0','-','0','1015000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBH-148-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.410',berat_jual_asli=berat_jual_asli+'1.410',stock_jual='1',berat_akhir=berat_akhir-'1.410',berat_akhir_asli=berat_akhir_asli-'1.410',stock_akhir='0' WHERE tanggal='2026-10-25' AND kode_barang='E2D-ZEBH-148-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 ('F326251007422','2026-10-25','1.410','2026-10-25','10:07:43','PLG0032051','1418000','1418000','0','1418000','1418000','kasir','2026-10-25 10:07:42','F32625100742'); 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-25','F326251007422','2026-10-25','10:07:43','FIT','1418000','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-261025-0011','D','2026-10-25','10:07:43','kasir','PENJUALAN','F326251007422','7987120000','1418000','7988538000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1418000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326251007422' 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 ('F326251007423','kasir',' 1',' MEF1 XXX Y','TOKO','PM-F','F1E-ZJXF-201-0','GL XXX OVAL C GELOMBANG YT 60 8K','','3.760','1','100.00','3854000','0','0','15000','3742000','0','0','0','3742000','FIT','00428105','F1E','0','0','-','1','1035000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZJXF-201-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.760',berat_jual_asli=berat_jual_asli+'3.760',stock_jual='1',berat_akhir=berat_akhir-'3.760',berat_akhir_asli=berat_akhir_asli-'3.760',stock_akhir='0' WHERE tanggal='2026-10-25' AND kode_barang='F1E-ZJXF-201-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 ('F326251007423','2026-10-25','3.760','2026-10-25','10:07:43','PLG0032052','3742000','3742000','0','3742000','3742000','kasir','2026-10-25 10:07:42','F32625100742'); 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-25','F326251007423','2026-10-25','10:07:43','FIT','3742000','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-261025-0012','D','2026-10-25','10:07:43','kasir','PENJUALAN','F326251007423','7988538000','3742000','7992280000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='3742000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326251007423' LIMIT 1; INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020634','X-00020634','CC MATAHARI DG 16','GR','---','E0C','BELI','BELI001','595000','2026-10-25','0.980','1','kasir','2026-10-25 10:19:32'); DELETE FROM tp_barang WHERE kode_dept = 'X-E0C'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E0C','X-00020634','X-00020634'); 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-261025-0001','F322080242171','FIT','1','BELI','BELI001','E0C', 'X-00020634', 'CC MATAHARI DG 16','1.000','0.980','100.00','420000','595000','607143','985000','1','595000','595000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.980',berat_beli_asli=berat_beli_asli+'0.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.980',berat_akhir_asli=berat_akhir_asli+'0.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E0C' 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-261025-0001','2026-10-25','2026-10-25','10:19:31','FIT','---','0.980','595000','595000','595000','595000','595000','kasir','2026-10-25 10:19:32','FB-261025-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261025-0001','SAKIYEM','SONO BANGUNSARI','','','','kasir','2026-10-25 10:19:32'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-25' 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-261025-0013','K','2026-10-25','10:19:31','kasir','PEMBELIAN UMUM','FB-261025-0001','7992280000','595000','7991685000'); 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-00020635','X-00020635','CC MODEL ISYANA SLEP LG 18 8K','GR','---','E1E','BELI','BELI001','600000','2026-10-25','0.630','1','kasir','2026-10-25 10:19:54'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020635','X-00020635'); 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-261025-0002','F326201013551','SIN','1','BELI','BELI001','E1E', 'X-00020635', 'CC MODEL ISYANA SLEP LG 18 8K','0.630','0.630','100.00','685000','600000','952381','1035000','1','600000','600000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.630',berat_beli_asli=berat_beli_asli+'0.630',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.630',berat_akhir_asli=berat_akhir_asli+'0.630',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-261025-0002','2026-10-25','2026-10-25','10:19:54','SIN','---','0.630','600000','600000','600000','600000','600000','kasir','2026-10-25 10:19:54','FB-261025-0002'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261025-0002','SRI WAHYUNI','PUHPELEM','','','','kasir','2026-10-25 10:19:54'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-25' 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-261025-0014','K','2026-10-25','10:19:54','kasir','PEMBELIAN UMUM','FB-261025-0002','7991685000','600000','7991085000'); 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-00020636','X-00020636','CC PIPA MODEL HATI SLEP VAR KH 14 8K','GR','---','E1E','BELI','BELI001','525000','2026-10-25','0.550','1','kasir','2026-10-25 10:20:37'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020636','X-00020636'); 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-261025-0003','F326021049032','LIS','1','BELI','BELI001','E1E', 'X-00020636', 'CC PIPA MODEL HATI SLEP VAR KH 14 8K','0.550','0.550','100.00','570000','525000','954545','1035000','1','525000','525000','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-25' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-261025-0003','2026-10-25','2026-10-25','10:20:37','LIS','---','0.550','525000','525000','525000','525000','525000','kasir','2026-10-25 10:20:37','FB-261025-0003'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261025-0003','SULIS','PUHPELEM','','','','kasir','2026-10-25 10:20:37'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-25' 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-261025-0015','K','2026-10-25','10:20:37','kasir','PEMBELIAN UMUM','FB-261025-0003','7991085000','525000','7990560000'); 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-00020637','X-00020637','CC X MODEL MATA PM 12 8K','GR','---','E2D','BELI','BELI001','915000','2026-10-25','0.970','1','kasir','2026-10-25 10:20:37'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020637','X-00020637'); 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-261025-0004','F326160222181','LIS','2','BELI','BELI001','E2D', 'X-00020637', 'CC X MODEL MATA PM 12 8K','0.970','0.970','100.00','1130000','915000','943299','1015000','1','915000','915000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.970',berat_beli_asli=berat_beli_asli+'0.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.970',berat_akhir_asli=berat_akhir_asli+'0.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-25' 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-261025-0004','2026-10-25','2026-10-25','10:20:37','LIS','---','0.970','915000','915000','915000','915000','915000','kasir','2026-10-25 10:20:37','FB-261025-0003'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261025-0004','SULIS','PUHPELEM','','','088219787072','kasir','2026-10-25 10:20:37'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-25' 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-261025-0016','K','2026-10-25','10:20:37','kasir','PEMBELIAN UMUM','FB-261025-0004','7990560000','915000','7989645000'); 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-00020638','X-00020638','CC XX MODEL MATA ROSE UB 20 8K','GR','---','E2D','BELI','BELI001','1255000','2026-10-25','1.310','1','kasir','2026-10-25 10:20:57'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020638','X-00020638'); 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-261025-0005','F326041120442','LIS','1','BELI','BELI001','E2D', 'X-00020638', 'CC XX MODEL MATA ROSE UB 20 8K','1.310','1.310','100.00','1322000','1255000','958015','1015000','1','1255000','1255000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.310',berat_beli_asli=berat_beli_asli+'1.310',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.310',berat_akhir_asli=berat_akhir_asli+'1.310',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-25' 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-261025-0005','2026-10-25','2026-10-25','10:20:56','LIS','---','1.310','1255000','1255000','1255000','1255000','1255000','kasir','2026-10-25 10:20:57','FB-261025-0005'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261025-0005','NARSIH','BANDAR PACITAN','','','085325659940','kasir','2026-10-25 10:20:57'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-25' 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-261025-0017','K','2026-10-25','10:20:56','kasir','PEMBELIAN UMUM','FB-261025-0005','7989645000','1255000','7988390000'); 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 ('F326251023251','kasir','1',' TEH1 X HW ','TOKO','PT-H','H1TE-ZIXE-41-T','KL X SANTA HW 44CM 17K ','','4.000','1','100.00','7560000','0','0','15000','7560000','0','0','0','7560000','SIN','T0083059','H1TE','0','0','-','0','1890000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZIXE-41-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.000',berat_jual_asli=berat_jual_asli+'4.000',stock_jual='1',berat_akhir=berat_akhir-'4.000',berat_akhir_asli=berat_akhir_asli-'4.000',stock_akhir='0' WHERE tanggal='2026-10-25' AND kode_barang='H1TE-ZIXE-41-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326251023251','2026-10-25','4.000','2026-10-25','10:23:26','PLG0032053','7560000','7560000','0','7560000','7560000','kasir','2026-10-25 10:23:25','F32625102325'); 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-25','F326251023251','2026-10-25','10:23:26','SIN','7560000','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-261025-0018','D','2026-10-25','10:23:26','kasir','PENJUALAN','F326251023251','7988390000','7560000','7995950000'); 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 ('F326251031121','kasir','1',' MDE2D 10K ','TOKO','PM-E','E2D-ZEBH-120-T','CC WEDDING MATA SLEP CM 18 8K ','','1.550','1','100.00','1558000','0','0','15000','1558000','0','10000','0','1568000','AAT','T0080061','E2D','0','0','-','0','1015000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEBH-120-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-10-25' AND kode_barang='E2D-ZEBH-120-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326251031121','2026-10-25','1.550','2026-10-25','10:31:13','PLG0032054','1558000','1558000','10000','1568000','1568000','kasir','2026-10-25 10:31:12','F32625103112'); 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-25','F326251031121','2026-10-25','10:31:13','AAT','1568000','10000'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261025-0019','D','2026-10-25','10:31:13','kasir','PENJUALAN','F326251031121','7995950000','1568000','7997518000'); 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 ('F326251109171','kasir','1',' MEF2 PM 56','TOKO','PM-F','F2E-ZGXF-3-0','GL PIPA MATA PM 56 8K ','','2.960','1','100.00','3034000','0','0','15000','3035000','0','0','0','3035000','LIS','00412384','F2E','0','0','-','0','1035000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZGXF-3-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.960',berat_jual_asli=berat_jual_asli+'2.960',stock_jual='1',berat_akhir=berat_akhir-'2.960',berat_akhir_asli=berat_akhir_asli-'2.960',stock_akhir='0' WHERE tanggal='2026-10-25' AND kode_barang='F2E-ZGXF-3-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 ('F326251109171','2026-10-25','2.960','2026-10-25','11:09:17','PLG0032055','3035000','3035000','0','3035000','3035000','kasir','2026-10-25 11:09:17','F32625110917'); 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-25','F326251109171','2026-10-25','11:09:17','LIS','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) VALUES ('KM-261025-0020','D','2026-10-25','11:09:17','kasir','PENJUALAN','F326251109171','7997518000','3035000','8000553000'); 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-00020639','X-00020639','GL X PIPA MATA UB 56 8K','GR','---','F2E','BELI','BELI001','4357000','2026-10-25','5.030','1','kasir','2026-10-25 11:17:16'); DELETE FROM tp_barang WHERE kode_dept = 'X-F2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00020639','X-00020639'); 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-261025-0006','F325271119431','FIT','1','BELI','BELI001','F2E', 'X-00020639', 'GL X PIPA MATA UB 56 8K','5.030','5.030','100.00','5105000','4357000','866203','1035000','1','4357000','4357000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.030',berat_beli_asli=berat_beli_asli+'5.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.030',berat_akhir_asli=berat_akhir_asli+'5.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-25' 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-261025-0006','2026-10-25','2026-10-25','11:17:16','FIT','---','5.030','4357000','4357000','4357000','4357000','4357000','kasir','2026-10-25 11:17:16','FB-261025-0006'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261025-0006','SURATI','BUGEL TENGGER PUHPELEM','','','','kasir','2026-10-25 11:17:16'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-25' 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-261025-0021','K','2026-10-25','11:17:16','kasir','PEMBELIAN UMUM','FB-261025-0006','8000553000','4357000','7996196000'); 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 ('F326251132251','kasir','1',' MEH1 X UB ','TOKO','PM-H','H1E-ZJAE-121-0','KL X GUCCI UB 44 8K ','','2.000','1','100.00','2050000','0','0','15000','2050000','0','0','0','2050000','SIN','00430004','H1E','0','0','-','0','1035000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZJAE-121-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-25' AND kode_barang='H1E-ZJAE-121-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 ('F326251132251','2026-10-25','2.000','2026-10-25','11:32:25','PLG0032056','2050000','2050000','0','2050000','2050000','kasir','2026-10-25 11:32:25','F32625113225'); 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-25','F326251132251','2026-10-25','11:32:25','SIN','2050000','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-261025-0022','D','2026-10-25','11:32:25','kasir','PENJUALAN','F326251132251','7996196000','2050000','7998246000'); 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 ('F326250100181','kasir','1',' MDE2 10K C','TOKO','PM-E','E2D-ZJBX-33-0','CC WEDDING MATA 12 CM 8K ','','1.530','1','100.00','1538000','0','0','15000','1538000','0','10000','0','1548000','FIT','00430632','E2D','0','0','-','0','1015000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZJBX-33-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2026-10-25' AND kode_barang='E2D-ZJBX-33-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 ('F326250100181','2026-10-25','1.530','2026-10-25','13:00:19','PLG0032057','1538000','1538000','10000','1548000','1548000','kasir','2026-10-25 13:00:18','F32625010018'); 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-25','F326250100181','2026-10-25','13:00:19','FIT','1548000','10000'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261025-0023','D','2026-10-25','13:00:19','kasir','PENJUALAN','F326250100181','7998246000','1548000','7999794000'); 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 ('F326250115441','kasir','1',' MEE1 X LG ','TOKO','PM-E','E1E-ZHAD-47-0','CC X BANGKOK SLEP LG 15 8K ','','0.520','1','100.00','533000','0','0','15000','535000','0','0','0','535000','AAT','00418932','E1E','0','0','-','0','1035000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHAD-47-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-10-25' AND kode_barang='E1E-ZHAD-47-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 ('F326250115441','2026-10-25','0.520','2026-10-25','13:15:44','PLG0032058','535000','535000','0','535000','535000','kasir','2026-10-25 13:15:44','F32625011544'); 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-25','F326250115441','2026-10-25','13:15:44','AAT','535000','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-261025-0024','D','2026-10-25','13:15:44','kasir','PENJUALAN','F326250115441','7999794000','535000','8000329000'); 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 ('F326250121141','kasir','1',' MFE1 KH 16','TOKO','PM-E','E1F-ZJXE-387-0','CC MODEL SPECTRA SLEP KH 16 8K ','','0.370','1','100.00','387000','0','0','15000','388000','0','0','0','388000','SIN','00427878','E1F','0','0','-','0','1055000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZJXE-387-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-25' AND kode_barang='E1F-ZJXE-387-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 ('F326250121141','2026-10-25','0.370','2026-10-25','13:21:14','PLG0032059','388000','388000','0','388000','388000','kasir','2026-10-25 13:21:14','F32625012114'); 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-25','F326250121141','2026-10-25','13:21:14','SIN','388000','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-261025-0025','D','2026-10-25','13:21:14','kasir','PENJUALAN','F326250121141','8000329000','388000','8000717000'); 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 ('F326250121521','kasir','1',' MFE1 KH 16','TOKO','PM-E','E1F-ZIAE-279-0','CC BUNGA CLOVER SLEP KH 16 8K ','','0.370','1','100.00','387000','0','0','15000','388000','0','0','0','388000','SIN','00423815','E1F','0','0','-','0','1055000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZIAE-279-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-25' AND kode_barang='E1F-ZIAE-279-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 ('F326250121521','2026-10-25','0.370','2026-10-25','13:21:52','PLG0032060','388000','388000','0','388000','388000','kasir','2026-10-25 13:21:52','F32625012152'); 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-25','F326250121521','2026-10-25','13:21:52','SIN','388000','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-261025-0026','D','2026-10-25','13:21:52','kasir','PENJUALAN','F326250121521','8000717000','388000','8001105000'); 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 ('F326250124421','kasir','1',' MFA1 X UB ','TOKO','PM-A','A1F-YGAH-344-0','AT X HUGGIES KLIP BOLA ARESO UB 8K ','','1.400','1','100.00','1463000','0','0','15000','1463000','0','0','0','1463000','LIS','00361753','A1F','0','0','-','0','1055000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-YGAH-344-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.400',berat_jual_asli=berat_jual_asli+'1.400',stock_jual='1',berat_akhir=berat_akhir-'1.400',berat_akhir_asli=berat_akhir_asli-'1.400',stock_akhir='0' WHERE tanggal='2026-10-25' AND kode_barang='A1F-YGAH-344-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 ('F326250124421','2026-10-25','1.400','2026-10-25','13:24:43','PLG0032061','1463000','1463000','0','1463000','1463000','kasir','2026-10-25 13:24:42','F32625012442'); 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-25','F326250124421','2026-10-25','13:24:43','LIS','1463000','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-261025-0027','D','2026-10-25','13:24:43','kasir','PENJUALAN','F326250124421','8001105000','1463000','8002568000'); 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 ('F326250134371','kasir','1',' MEE2 X KH ','TOKO','PM-E','E2E-ZJXF-329-0','CC X MODEL SNAKE MATA KH 20 8K ','','0.500','1','100.00','512000','0','0','15000','513000','0','0','0','513000','LIS','00428233','E2E','0','0','-','0','1035000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZJXF-329-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-25' AND kode_barang='E2E-ZJXF-329-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 ('F326250134371','2026-10-25','0.500','2026-10-25','13:34:37','PLG0032062','513000','513000','0','513000','513000','kasir','2026-10-25 13:34:37','F32625013437'); 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-25','F326250134371','2026-10-25','13:34:37','LIS','513000','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-261025-0028','D','2026-10-25','13:34:37','kasir','PENJUALAN','F326250134371','8002568000','513000','8003081000'); 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 ('F326250142481','kasir','1',' MEB1E X CM','TOKO','PM-B','B1E-ZIBE-39-0','GW X PANJANG DAUN SLEP CM 8K ','','0.670','1','100.00','687000','0','0','15000','688000','0','0','0','688000','LIS','00425414','B1E','0','0','-','0','1035000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZIBE-39-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2026-10-25' AND kode_barang='B1E-ZIBE-39-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 ('F326250142481','2026-10-25','0.670','2026-10-25','13:42:49','PLG0032063','688000','688000','0','688000','688000','kasir','2026-10-25 13:42:48','F32625014248'); 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-25','F326250142481','2026-10-25','13:42:49','LIS','688000','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-261025-0029','D','2026-10-25','13:42:49','kasir','PENJUALAN','F326250142481','8003081000','688000','8003769000'); 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 ('F326250150511','kasir','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZFBI-87-0','CC X MODEL MATA CM 14 8K ','','1.100','1','100.00','1105000','0','0','15000','1105000','0','0','0','1105000','FIT','00411079','E2D','0','0','-','0','1015000'); UPDATE tm_barang SET tgl_last_jual='2026-10-25', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFBI-87-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-10-25' AND kode_barang='E2D-ZFBI-87-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 ('F326250150511','2026-10-25','1.100','2026-10-25','13:50:52','PLG0032064','1105000','1105000','0','1105000','1105000','kasir','2026-10-25 13:50:51','F32625015051'); 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-25','F326250150511','2026-10-25','13:50:52','FIT','1105000','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-261025-0030','D','2026-10-25','13:50:52','kasir','PENJUALAN','F326250150511','8003769000','1105000','8004874000'); 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-00020640','X-00020640','KL NORY ANAK UB 34 8K','GR','---','H1E','BELI','BELI001','955000','2026-10-25','1.010','1','kasir','2026-10-25 14:03:25'); DELETE FROM tp_barang WHERE kode_dept = 'X-H1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020640','X-00020640'); 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-261025-0007','F325300747411','AAT','1','BELI','BELI001','H1E', 'X-00020640', 'KL NORY ANAK UB 34 8K','1.010','1.010','100.00','1040000','955000','945545','1035000','1','955000','955000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.010',berat_beli_asli=berat_beli_asli+'1.010',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.010',berat_akhir_asli=berat_akhir_asli+'1.010',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-25' 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-261025-0007','2026-10-25','2026-10-25','14:03:25','AAT','---','1.010','955000','955000','955000','955000','955000','kasir','2026-10-25 14:03:25','FB-261025-0007'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261025-0007','ALMAIRA','WARU BUGELAN KISMANTORO','','','081228531416','kasir','2026-10-25 14:03:25'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-25' 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-261025-0031','K','2026-10-25','14:03:25','kasir','PEMBELIAN UMUM','FB-261025-0007','8004874000','955000','8003919000'); UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250100181' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250100181' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250100181'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250115441' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250115441' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250115441'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250121141' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250121141' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250121141'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250121521' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250121521' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250121521'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250124421' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250124421' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250124421'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250134371' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250134371' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250134371'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250142481' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250142481' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250142481'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250150511' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250150511' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250150511'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250815221' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250815221' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250815221'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250926051' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250926051' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250926051'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250926052' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250926052' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250926052'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250935541' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250935541' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250935541'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250955291' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250955291' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250955291'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250955292' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250955292' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250955292'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326250955293' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326250955293' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326250955293'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251005001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251005001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251005001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251007421' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251007421' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251007421'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251007422' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251007422' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251007422'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251007423' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251007423' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251007423'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251023251' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251023251' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251023251'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251031121' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251031121' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251031121'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251109171' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251109171' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251109171'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326251132251' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326251132251' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326251132251'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261025-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261025-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261025-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261025-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261025-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261025-0003'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261025-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261025-0004'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261025-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261025-0005'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261025-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261025-0006'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261025-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261025-0007'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-26','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-25'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-25'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-25'; 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-25' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-25'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-25'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-25'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-25'; 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-26' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-25' 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-261026-0001','D','2026-10-26','15:07:45','SYSTEM','SALDO AWAL','SALDO AWAL','0','8003919000','8003919000'); 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-261026-0001','D','2026-10-26','15:07:45','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-261026-0001','D','2026-10-26','15:07:45','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-261026-0001','D','2026-10-26','15:07:45','BCA','SALDO AWAL','SALDO AWAL','0','748085000','748085000'); UPDATE tp_system SET tgl_system='2026-10-26';