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 ('F326120810521','input','1',' MDE1 CM 14','TOKO','PM-E','E1D-ZGBC-262-0','CC VELG POLOS CM 14 8K ','','1.830','1','100.00','1872000','0','0','15000','1872000','0','0','0','1872000','SIN','00415335','E1D','0','0','-','0','1023000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGBC-262-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.830',berat_jual_asli=berat_jual_asli+'1.830',stock_jual='1',berat_akhir=berat_akhir-'1.830',berat_akhir_asli=berat_akhir_asli-'1.830',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='E1D-ZGBC-262-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 ('F326120810521','2026-10-12','1.830','2026-10-12','08:10:53','PLG0031805','1872000','1872000','0','1872000','1872000','input','2026-10-12 08:10:52','F32612081052'); 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-12','F326120810521','2026-10-12','08:10:53','SIN','1872000','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-261012-0002','D','2026-10-12','08:10:53','input','PENJUALAN','F326120810521','7800942000','1872000','7802814000'); 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 ('F326120851521','input','1',' MFE2 KH 10','TOKO','PM-E','E2F-ZJXE-410-0','CC MODEL PAKU MATA KH 10 8K ','','0.330','1','100.00','351000','0','0','15000','350000','0','0','0','350000','LIS','00427901','E2F','0','0','-','1','1063000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZJXE-410-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='E2F-ZJXE-410-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 ('F326120851521','2026-10-12','0.330','2026-10-12','08:51:52','PLG0031806','350000','350000','0','350000','350000','input','2026-10-12 08:51:52','F32612085152'); 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-12','F326120851521','2026-10-12','08:51:52','LIS','350000','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-261012-0003','D','2026-10-12','08:51:52','input','PENJUALAN','F326120851521','7802814000','350000','7803164000'); 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 ('F326120911361','input','1',' MEB1E X LG','TOKO','PM-B','B1E-ZGXG-66-0','GW X TAUGE MRICAN SLEP LG 8K ','','0.560','1','100.00','584000','0','0','15000','585000','0','0','0','585000','AAT','00412467','B1E','0','0','-','0','1043000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGXG-66-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='B1E-ZGXG-66-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 ('F326120911361','2026-10-12','0.560','2026-10-12','09:11:37','PLG0031807','585000','585000','0','585000','585000','input','2026-10-12 09:11:36','F32612091136'); 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-12','F326120911361','2026-10-12','09:11:37','AAT','585000','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-261012-0004','D','2026-10-12','09:11:37','input','PENJUALAN','F326120911361','7803164000','585000','7803749000'); 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 ('F326120922101','input','1',' MEB1E X LG','TOKO','PM-B','B1E-ZIXH-31-0','GW X TIFF JANGKAR MATA VAR LG 8K ','','0.570','1','100.00','595000','0','0','15000','595000','0','0','0','595000','AAT','00422298','B1E','0','0','-','0','1043000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZIXH-31-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='B1E-ZIXH-31-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 ('F326120922101','2026-10-12','0.570','2026-10-12','09:22:11','PLG0031808','595000','595000','0','595000','595000','input','2026-10-12 09:22:10','F32612092210'); 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-12','F326120922101','2026-10-12','09:22:11','AAT','595000','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-261012-0005','D','2026-10-12','09:22:11','input','PENJUALAN','F326120922101','7803749000','595000','7804344000'); 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 ('F326120922461','input','1',' MEB1E X LG','TOKO','PM-B','B1E-ZEBH-437-0','GW X TIFF MATA VAR LG 8K ','','0.630','1','100.00','657000','0','0','15000','658000','0','0','0','658000','AAT','00405655','B1E','0','0','-','0','1043000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEBH-437-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='B1E-ZEBH-437-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 ('F326120922461','2026-10-12','0.630','2026-10-12','09:22:47','PLG0031809','658000','658000','0','658000','658000','input','2026-10-12 09:22:46','F32612092246'); 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-12','F326120922461','2026-10-12','09:22:47','AAT','658000','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-261012-0006','D','2026-10-12','09:22:47','input','PENJUALAN','F326120922461','7804344000','658000','7805002000'); 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 ('F326120932401','input','1',' TAE0 DW 15','TOKO','PT-E','E0TA-WEXB-58-T','CC SALANG LEWAT DW 15 ','','1.500','1','100.00','2760000','0','0','15000','2760000','0','0','0','2760000','LIS','T0043869','E0TA','0','0','-','0','1840000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0TA-WEXB-58-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='E0TA-WEXB-58-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-E' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326120932401','2026-10-12','1.500','2026-10-12','09:32:40','PLG0031810','2760000','2760000','0','2760000','2760000','input','2026-10-12 09:32:40','F32612093240'); 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-12','F326120932401','2026-10-12','09:32:40','LIS','2760000','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-261012-0007','D','2026-10-12','09:32:40','input','PENJUALAN','F326120932401','7805002000','2760000','7807762000'); 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 ('F326120936591','input','1',' MFD2F X LG','TOKO','PM-D','D2F-YGXE-211-0','LT X MODEL HURUF LG C 8K ','','0.460','1','100.00','489000','0','0','15000','490000','0','0','0','490000','SIN','00359850','D2F','0','0','-','0','1063000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2F-YGXE-211-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='D2F-YGXE-211-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 ('F326120936591','2026-10-12','0.460','2026-10-12','09:36:59','PLG0031811','490000','490000','0','490000','490000','input','2026-10-12 09:36:59','F32612093659'); 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-12','F326120936591','2026-10-12','09:36:59','SIN','490000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261012-0008','D','2026-10-12','09:36:59','input','PENJUALAN','F326120936591','7807762000','490000','7808252000'); 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 ('F326121035351','input','1',' MEF3E X HW','TOKO','PM-F','F3E-ZIBE-123-0','GL X TIFF SLEP VAR HW 8K ','','1.260','1','100.00','1314000','0','0','15000','1314000','0','0','0','1314000','SIN','00425498','F3E','0','0','-','0','1043000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIBE-123-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.260',berat_jual_asli=berat_jual_asli+'1.260',stock_jual='1',berat_akhir=berat_akhir-'1.260',berat_akhir_asli=berat_akhir_asli-'1.260',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='F3E-ZIBE-123-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 ('F326121035351','2026-10-12','1.260','2026-10-12','10:35:36','PLG0031812','1314000','1314000','0','1314000','1314000','input','2026-10-12 10:35:35','F32612103535'); 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-12','F326121035351','2026-10-12','10:35:36','SIN','1314000','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-261012-0009','D','2026-10-12','10:35:36','input','PENJUALAN','F326121035351','7808252000','1314000','7809566000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1314000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326121035351' 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 ('F326121035352','input',' 1',' MGS1G X DG','TOKO','PM-S','S1G-ZIAD-1-0','AS X EXTENTION DG 8K ','','0.200','1','100.00','217000','0','0','15000','217000','0','0','0','217000','SIN','00423361','S1G','0','0','-','0','1083000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZIAD-1-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='S1G-ZIAD-1-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-S' 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 ('F326121035352','2026-10-12','0.200','2026-10-12','10:35:36','PLG0031813','217000','217000','0','217000','217000','input','2026-10-12 10:35:35','F32612103535'); 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-12','F326121035352','2026-10-12','10:35:36','SIN','217000','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-261012-0010','D','2026-10-12','10:35:36','input','PENJUALAN','F326121035352','7809566000','217000','7809783000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='217000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326121035352' 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 ('F326121037411','input','1',' MEB1E X YT','TOKO','PM-B','B1E-ZIXI-151-0','GW X MODEL SLEP YT 8K ','','0.570','1','100.00','595000','0','0','15000','595000','0','0','0','595000','LIS','00422689','B1E','0','0','-','0','1043000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZIXI-151-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='B1E-ZIXI-151-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 ('F326121037411','2026-10-12','0.570','2026-10-12','10:37:41','PLG0031814','595000','595000','0','595000','595000','input','2026-10-12 10:37:41','F32612103741'); 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-12','F326121037411','2026-10-12','10:37:41','LIS','595000','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-261012-0011','D','2026-10-12','10:37:41','input','PENJUALAN','F326121037411','7809783000','595000','7810378000'); 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 ('F326121038381','input','1',' MEF3 XX HW','TOKO','PM-F','F3E-ZABH-104-0','GL XX FANCY SLEP VAR HW 8K ','','2.640','1','100.00','2754000','0','0','15000','2675000','0','0','0','2675000','AAT','00386962','F3E','0','0','-','1','1043000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZABH-104-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.640',berat_jual_asli=berat_jual_asli+'2.640',stock_jual='1',berat_akhir=berat_akhir-'2.640',berat_akhir_asli=berat_akhir_asli-'2.640',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='F3E-ZABH-104-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 ('F326121038381','2026-10-12','2.640','2026-10-12','10:38:38','PLG0031815','2675000','2675000','0','2675000','2675000','input','2026-10-12 10:38:38','F32612103838'); 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-12','F326121038381','2026-10-12','10:38:38','AAT','2675000','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-261012-0012','D','2026-10-12','10:38:38','input','PENJUALAN','F326121038381','7810378000','2675000','7813053000'); 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-00020499','X-00020499','CC MODEL PAKU MATA SLEP KH 17 8K','GR','---','E2E','BELI','BELI001','402000','2026-10-12','0.500','1','kasir','2026-10-12 11:15:54'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020499','X-00020499'); 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-261012-0001','F326241020371','LIS','1','BELI','BELI001','E2E', 'X-00020499', 'CC MODEL PAKU MATA SLEP KH 17 8K','0.500','0.500','100.00','542000','402000','804000','1043000','1','402000','402000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-12' 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-261012-0001','2026-10-12','2026-10-12','11:15:54','LIS','---','0.500','402000','402000','402000','402000','402000','kasir','2026-10-12 11:15:54','FB-261012-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261012-0001','DWI','BAKALAN','','','','kasir','2026-10-12 11:15:54'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-12' 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-261012-0013','K','2026-10-12','11:15:54','kasir','PEMBELIAN UMUM','FB-261012-0001','7813053000','402000','7812651000'); 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-00020500','X-00020500','CC MODEL MATA VAR LG 9 8K','GR','---','E2E','BELI','BELI001','485000','2026-10-12','0.500','1','kasir','2026-10-12 11:17:26'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020500','X-00020500'); 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-261012-0002','F325280238031','SIN','1','BELI','BELI001','E2E', 'X-00020500', 'CC MODEL MATA VAR LG 9 8K','0.500','0.500','100.00','550000','485000','970000','1043000','1','485000','485000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-12' 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-261012-0002','2026-10-12','2026-10-12','11:17:26','SIN','---','0.500','485000','485000','485000','485000','485000','kasir','2026-10-12 11:17:26','FB-261012-0002'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261012-0002','ANI','MIRI KISMANTORO','','','','kasir','2026-10-12 11:17:26'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-12' 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-261012-0014','K','2026-10-12','11:17:26','kasir','PEMBELIAN UMUM','FB-261012-0002','7812651000','485000','7812166000'); 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-00020501','X-00020501','GW X MODEL TAUGE MATA HK 8K','GR','---','B1E','BELI','BELI001','315000','2026-10-12','0.400','1','kasir','2026-10-12 11:17:50'); DELETE FROM tp_barang WHERE kode_dept = 'X-B1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00020501','X-00020501'); 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-261012-0003','F325070245221','FIT','1','BELI','BELI001','B1E', 'X-00020501', 'GW X MODEL TAUGE MATA HK 8K','0.400','0.400','100.00','410000','315000','787500','1043000','1','315000','315000','RUSAK'); 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-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1E' 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-261012-0003','2026-10-12','2026-10-12','11:17:50','FIT','---','0.400','315000','315000','315000','315000','315000','kasir','2026-10-12 11:17:50','FB-261012-0003'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261012-0003','ISTIQOMAH','KARANG GONDANG','','','','kasir','2026-10-12 11:17:50'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-12' 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-261012-0015','K','2026-10-12','11:17:50','kasir','PEMBELIAN UMUM','FB-261012-0003','7812166000','315000','7811851000'); 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-00020502','X-00020502','GL XXX TIFF SLEP HW 8K','GR','---','F3E','BELI','BELI001','987000','2026-10-12','1.030','1','kasir','2026-10-12 11:18:13'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020502','X-00020502'); 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-261012-0004','F326300113251','SIN','1','BELI','BELI001','F3E', 'X-00020502', 'GL XXX TIFF SLEP HW 8K','1.030','1.030','100.00','1040000','987000','958252','1043000','1','987000','987000','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-12' 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-261012-0004','2026-10-12','2026-10-12','11:18:12','SIN','---','1.030','987000','987000','987000','987000','987000','kasir','2026-10-12 11:18:13','FB-261012-0004'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261012-0004','INTAN DWI SEFTIA','BANDAR','','','','kasir','2026-10-12 11:18:13'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-12' 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-261012-0016','K','2026-10-12','11:18:12','kasir','PEMBELIAN UMUM','FB-261012-0004','7811851000','987000','7810864000'); 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 ('F326121120091','kasir','1',' MFD1 11K B','TOKO','PM-D','D1F-ZJXE-361-0','LT MODEL IKAN SLEP BG 8K','','2.070','1','100.00','2200000','0','0','15000','2201000','0','11000','0','2212000','LIS','00427852','D1F','0','0','-','0','1063000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZJXE-361-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='D1F-ZJXE-361-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 ('F326121120091','2026-10-12','2.070','2026-10-12','11:20:09','PLG0031816','2201000','2201000','11000','2212000','2212000','kasir','2026-10-12 11:20:09','F32612112009'); 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-12','F326121120091','2026-10-12','11:20:09','LIS','2212000','11000'); 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-261012-0017','D','2026-10-12','11:20:09','kasir','PENJUALAN','F326121120091','7810864000','2212000','7813076000'); 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 ('F326121218141','kasir','1',' MEH1E HW 4','TOKO','PM-H','H1E-ZHXH-401-0','KL ITALY VAR SLEP HW 42 8K ','','1.720','1','100.00','1794000','0','0','15000','1795000','0','0','0','1795000','SIN','00418131','H1E','0','0','-','0','1043000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHXH-401-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.720',berat_jual_asli=berat_jual_asli+'1.720',stock_jual='1',berat_akhir=berat_akhir-'1.720',berat_akhir_asli=berat_akhir_asli-'1.720',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='H1E-ZHXH-401-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 ('F326121218141','2026-10-12','1.720','2026-10-12','12:18:14','PLG0031817','1795000','1795000','0','1795000','1795000','kasir','2026-10-12 12:18:14','F32612121814'); 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-12','F326121218141','2026-10-12','12:18:14','SIN','1795000','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-261012-0018','D','2026-10-12','12:18:14','kasir','PENJUALAN','F326121218141','7813076000','1795000','7814871000'); 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 ('F326121223501','kasir','1',' MEH1 HW 48','TOKO','PM-H','H1E-ZIXI-62-0','KL FLIK HW 48CM 8K ','','2.220','1','100.00','2315000','0','0','15000','2315000','0','0','0','2315000','LIS','00422599','H1E','0','0','-','0','1043000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIXI-62-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.220',berat_jual_asli=berat_jual_asli+'2.220',stock_jual='1',berat_akhir=berat_akhir-'2.220',berat_akhir_asli=berat_akhir_asli-'2.220',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='H1E-ZIXI-62-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 ('F326121223501','2026-10-12','2.220','2026-10-12','12:23:50','PLG0031818','2315000','2315000','0','2315000','2315000','kasir','2026-10-12 12:23:50','F32612122350'); 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-12','F326121223501','2026-10-12','12:23:50','LIS','2315000','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-261012-0019','D','2026-10-12','12:23:50','kasir','PENJUALAN','F326121223501','7814871000','2315000','7817186000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='2315000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326121223501' 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 ('F326121223502','kasir',' 1',' MDE2 X YT ','TOKO','PM-E','E2D-ZHXA-248-0','CC X MODEL MATA YT 16 8K ','','1.780','1','100.00','1821000','0','0','15000','1822000','0','0','0','1822000','LIS','00416546','E2D','0','0','-','0','1023000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZHXA-248-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.780',berat_jual_asli=berat_jual_asli+'1.780',stock_jual='1',berat_akhir=berat_akhir-'1.780',berat_akhir_asli=berat_akhir_asli-'1.780',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='E2D-ZHXA-248-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 ('F326121223502','2026-10-12','1.780','2026-10-12','12:23:50','PLG0031819','1822000','1822000','0','1822000','1822000','kasir','2026-10-12 12:23:50','F32612122350'); 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-12','F326121223502','2026-10-12','12:23:50','LIS','1822000','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-261012-0020','D','2026-10-12','12:23:50','kasir','PENJUALAN','F326121223502','7817186000','1822000','7819008000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='1822000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326121223502' 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 ('F326121223503','kasir',' 1',' MED2E X LG','TOKO','PM-D','D2E-ZIBF-334-0','LT X MODEL HURUF MATA LG A 8K ','','0.570','1','100.00','595000','0','0','15000','595000','0','0','0','595000','LIS','00425952','D2E','0','0','-','0','1043000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZIBF-334-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='D2E-ZIBF-334-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 ('F326121223503','2026-10-12','0.570','2026-10-12','12:23:50','PLG0031820','595000','595000','0','595000','595000','kasir','2026-10-12 12:23:50','F32612122350'); 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-12','F326121223503','2026-10-12','12:23:50','LIS','595000','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-261012-0021','D','2026-10-12','12:23:50','kasir','PENJUALAN','F326121223503','7819008000','595000','7819603000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='595000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326121223503' 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 ('F326121223504','kasir',' 1',' MEH1 X KH ','TOKO','PM-H','H1E-ZGCA-78-0','KL X NORI ANAK KH 34 8K ','','2.050','1','100.00','2138000','0','0','15000','2138000','0','0','0','2138000','LIS','00416164','H1E','0','0','-','0','1043000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGCA-78-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.050',berat_jual_asli=berat_jual_asli+'2.050',stock_jual='1',berat_akhir=berat_akhir-'2.050',berat_akhir_asli=berat_akhir_asli-'2.050',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='H1E-ZGCA-78-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 ('F326121223504','2026-10-12','2.050','2026-10-12','12:23:50','PLG0031821','2138000','2138000','0','2138000','2138000','kasir','2026-10-12 12:23:50','F32612122350'); 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-12','F326121223504','2026-10-12','12:23:50','LIS','2138000','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-261012-0022','D','2026-10-12','12:23:50','kasir','PENJUALAN','F326121223504','7819603000','2138000','7821741000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='2138000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326121223504' 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 ('F326121223505','kasir',' 1',' MEE1E PM 1','TOKO','PM-E','E1E-ZHBE-299-0','CC MODEL SLEP PM 12 8K ','','0.520','1','100.00','542000','0','0','15000','542000','0','0','0','542000','LIS','00420341','E1E','0','0','-','0','1043000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHBE-299-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-12' AND kode_barang='E1E-ZHBE-299-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 ('F326121223505','2026-10-12','0.520','2026-10-12','12:23:50','PLG0031822','542000','542000','0','542000','542000','kasir','2026-10-12 12:23:50','F32612122350'); 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-12','F326121223505','2026-10-12','12:23:50','LIS','542000','0'); INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261012-0023','D','2026-10-12','12:23:50','kasir','PENJUALAN','F326121223505','7821741000','542000','7822283000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='542000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326121223505' 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 ('F326121225591','kasir','1',' MFE1 KH 16','TOKO','PM-E','E1F-ZJXE-389-0','CC MODEL SPECTRA SLEP KH 16 8K ','','0.350','1','100.00','372000','0','0','15000','373000','0','0','0','373000','SIN','00427880','E1F','0','0','-','0','1063000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZJXE-389-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='E1F-ZJXE-389-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 ('F326121225591','2026-10-12','0.350','2026-10-12','12:25:59','PLG0031823','373000','373000','0','373000','373000','kasir','2026-10-12 12:25:59','F32612122559'); 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-12','F326121225591','2026-10-12','12:25:59','SIN','373000','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-261012-0024','D','2026-10-12','12:25:59','kasir','PENJUALAN','F326121225591','7822283000','373000','7822656000'); 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 ('F326121238241','kasir','1',' MEH1 KH 42','TOKO','PM-H','H1E-ZGBH-116-0','KL SIEM COBRA KH 42 8K ','','1.270','1','100.00','1325000','0','0','15000','1325000','0','0','0','1325000','FIT','00415732','H1E','0','0','-','0','1043000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGBH-116-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.270',berat_jual_asli=berat_jual_asli+'1.270',stock_jual='1',berat_akhir=berat_akhir-'1.270',berat_akhir_asli=berat_akhir_asli-'1.270',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='H1E-ZGBH-116-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 ('F326121238241','2026-10-12','1.270','2026-10-12','12:38:24','PLG0031824','1325000','1325000','0','1325000','1325000','kasir','2026-10-12 12:38:24','F32612123824'); 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-12','F326121238241','2026-10-12','12:38:24','FIT','1325000','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-261012-0025','D','2026-10-12','12:38:24','kasir','PENJUALAN','F326121238241','7822656000','1325000','7823981000'); 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 ('F326120108501','kasir','1',' MFD1 7K BG','TOKO','PM-D','D1F-ZJXC-293-0','LT MODEL IKAN SLEP BG 8K ','','1.320','1','100.00','1403000','0','0','15000','1403000','0','7000','0','1410000','FIT','00427440','D1F','0','0','-','0','1063000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZJXC-293-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.320',berat_jual_asli=berat_jual_asli+'1.320',stock_jual='1',berat_akhir=berat_akhir-'1.320',berat_akhir_asli=berat_akhir_asli-'1.320',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='D1F-ZJXC-293-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 ('F326120108501','2026-10-12','1.320','2026-10-12','13:08:50','PLG0031825','1403000','1403000','7000','1410000','1410000','kasir','2026-10-12 13:08:50','F32612010850'); 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-12','F326120108501','2026-10-12','13:08:50','FIT','1410000','7000'); 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-261012-0026','D','2026-10-12','13:08:50','kasir','PENJUALAN','F326120108501','7823981000','1410000','7825391000'); 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 ('F326120120541','kasir','1',' MEF1 X UB ','TOKO','PM-F','F1E-ZFAG-51-0','GL X SHOGUN POLOS UB 56 8K ','','3.920','1','100.00','4089000','0','0','15000','4090000','0','0','0','4090000','SIN','00408874','F1E','0','0','-','0','1043000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFAG-51-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.920',berat_jual_asli=berat_jual_asli+'3.920',stock_jual='1',berat_akhir=berat_akhir-'3.920',berat_akhir_asli=berat_akhir_asli-'3.920',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='F1E-ZFAG-51-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 ('F326120120541','2026-10-12','3.920','2026-10-12','13:20:54','PLG0031826','4090000','4090000','0','4090000','4090000','kasir','2026-10-12 13:20:54','F32612012054'); 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-12','F326120120541','2026-10-12','13:20:54','SIN','4090000','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-261012-0027','D','2026-10-12','13:20:54','kasir','PENJUALAN','F326120120541','7825391000','4090000','7829481000'); 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-00020503','X-00020503','CC PIPA KUKU MACAN SLEP CM 12 8K','GR','---','E1E','BELI','BELI001','512000','2026-10-12','0.530','1','kasir','2026-10-12 13:29:55'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020503','X-00020503'); 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-261012-0005','F326170224481','AAT','1','BELI','BELI001','E1E', 'X-00020503', 'CC PIPA KUKU MACAN SLEP CM 12 8K','0.530','0.530','100.00','590000','512000','966038','1043000','1','512000','512000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-12' 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-261012-0005','2026-10-12','2026-10-12','13:29:54','AAT','---','0.530','512000','512000','512000','512000','512000','kasir','2026-10-12 13:29:55','FB-261012-0005'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261012-0005','RINI','KENTENG','','','','kasir','2026-10-12 13:29:55'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-12' 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-261012-0028','K','2026-10-12','13:29:54','kasir','PEMBELIAN UMUM','FB-261012-0005','7829481000','512000','7828969000'); 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-00020504','X-00020504','GL ANAK VERONA SLEP PM 8K','GR','---','F3E','BELI','BELI001','1990000','2026-10-12','2.070','1','kasir','2026-10-12 13:31:32'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020504','X-00020504'); 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-261012-0006','F326060205231','FIT','1','BELI','BELI001','F3E', 'X-00020504', 'GL ANAK VERONA SLEP PM 8K','2.070','2.070','100.00','2163000','1990000','961353','1043000','1','1990000','1990000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.070',berat_beli_asli=berat_beli_asli+'2.070',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.070',berat_akhir_asli=berat_akhir_asli+'2.070',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-12' 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-261012-0006','2026-10-12','2026-10-12','13:31:32','FIT','---','2.070','1990000','1990000','1990000','1990000','1990000','kasir','2026-10-12 13:31:32','FB-261012-0006'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261012-0006','AISYAH','PAKISBARU NAWANGAN','','','','kasir','2026-10-12 13:31:32'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-12' 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-261012-0029','K','2026-10-12','13:31:32','kasir','PEMBELIAN UMUM','FB-261012-0006','7828969000','1990000','7826979000'); 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 ('F326120134151','kasir','1',' MEH1 KH 32','TOKO','PM-H','H1E-ZJXI-466-0','KL ANAK SIEM COBRA KH 32CM 8K ','','1.050','1','100.00','1095000','0','0','15000','1095000','0','0','0','1095000','FIT','00429447','H1E','0','0','-','0','1043000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZJXI-466-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='H1E-ZJXI-466-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 ('F326120134151','2026-10-12','1.050','2026-10-12','13:34:16','PLG0031827','1095000','1095000','0','1095000','1095000','kasir','2026-10-12 13:34:15','F32612013415'); 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-12','F326120134151','2026-10-12','13:34:16','FIT','1095000','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-261012-0030','D','2026-10-12','13:34:16','kasir','PENJUALAN','F326120134151','7826979000','1095000','7828074000'); 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 ('F326120217541','kasir','1',' TED2 X CM ','TOKO','PT-D','D2TE-XBBF-6-T','LT X MODEL HATI MATA VAR CM ','','1.110','1','100.00','2142000','0','0','15000','2142000','0','0','0','2142000','LIS','T0054305','D2TE','0','0','-','0','1940000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2TE-XBBF-6-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.110',berat_jual_asli=berat_jual_asli+'1.110',stock_jual='1',berat_akhir=berat_akhir-'1.110',berat_akhir_asli=berat_akhir_asli-'1.110',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='D2TE-XBBF-6-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-D' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326120217541','2026-10-12','1.110','2026-10-12','14:17:54','PLG0031828','2142000','2142000','0','2142000','2142000','kasir','2026-10-12 14:17:54','F32612021754'); 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-12','F326120217541','2026-10-12','14:17:54','LIS','2142000','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-261012-0031','D','2026-10-12','14:17:54','kasir','PENJUALAN','F326120217541','7828074000','2142000','7830216000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='2142000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326120217541' 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 ('F326120217542','kasir',' 1',' TEF3 HW ','TOKO','PT-F','F3TE-ZJXE-236-T','GL FLIK MODEL PLAT ARESO VAR HW 17K ','','3.170','1','100.00','6118000','0','0','15000','6118000','0','0','0','6118000','LIS','T0085746','F3TE','0','0','-','0','1940000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-ZJXE-236-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.170',berat_jual_asli=berat_jual_asli+'3.170',stock_jual='1',berat_akhir=berat_akhir-'3.170',berat_akhir_asli=berat_akhir_asli-'3.170',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='F3TE-ZJXE-236-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326120217542','2026-10-12','3.170','2026-10-12','14:17:54','PLG0031829','6118000','6118000','0','6118000','6118000','kasir','2026-10-12 14:17:54','F32612021754'); 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-12','F326120217542','2026-10-12','14:17:54','LIS','6118000','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-261012-0032','D','2026-10-12','14:17:54','kasir','PENJUALAN','F326120217542','7830216000','6118000','7836334000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='6118000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326120217542' 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-00020505','X-00020505','GL LEMES RANTE VAR HW 8K','GR','---','F3E','BELI','BELI001','942000','2026-10-12','0.980','1','kasir','2026-10-12 14:21:04'); DELETE FROM tp_barang WHERE kode_dept = 'X-F3E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020505','X-00020505'); 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-261012-0007','F326090254171','SIN','1','BELI','BELI001','F3E', 'X-00020505', 'GL LEMES RANTE VAR HW 8K','0.980','0.980','100.00','1025000','942000','961224','1043000','1','942000','942000','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-12' 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-261012-0007','2026-10-12','2026-10-12','14:21:04','SIN','---','0.980','942000','942000','942000','942000','942000','kasir','2026-10-12 14:21:04','FB-261012-0007'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261012-0007','ZHELA','KISMANTORO','','','083821908756','kasir','2026-10-12 14:21:04'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-12' 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-261012-0033','K','2026-10-12','14:21:04','kasir','PEMBELIAN UMUM','FB-261012-0007','7836334000','942000','7835392000'); 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-00020506','X-00020506','CC X MODEL MATA LG 12 8K','GR','---','E2D','BELI','BELI001','883000','2026-10-12','0.930','1','kasir','2026-10-12 14:21:04'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020506','X-00020506'); 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-261012-0008','F326070218091','SIN','2','BELI','BELI001','E2D', 'X-00020506', 'CC X MODEL MATA LG 12 8K','0.930','0.930','100.00','950000','883000','949462','1023000','1','883000','883000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.930',berat_beli_asli=berat_beli_asli+'0.930',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.930',berat_akhir_asli=berat_akhir_asli+'0.930',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-12' 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-261012-0008','2026-10-12','2026-10-12','14:21:04','SIN','---','0.930','883000','883000','883000','883000','883000','kasir','2026-10-12 14:21:04','FB-261012-0007'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261012-0008','ZHELA','KISMANTORO','','','','kasir','2026-10-12 14:21:04'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-12' 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-261012-0034','K','2026-10-12','14:21:04','kasir','PEMBELIAN UMUM','FB-261012-0008','7835392000','883000','7834509000'); 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-00020507','X-00020507','CC X MODEL MATA YT 10 8K','GR','---','E2D','BELI','BELI001','805000','2026-10-12','0.840','1','kasir','2026-10-12 14:21:04'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020507','X-00020507'); 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-261012-0009','F326200155331','SIN','3','BELI','BELI001','E2D', 'X-00020507', 'CC X MODEL MATA YT 10 8K','0.840','0.840','100.00','895000','805000','958333','1023000','1','805000','805000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.840',berat_beli_asli=berat_beli_asli+'0.840',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.840',berat_akhir_asli=berat_akhir_asli+'0.840',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-12' 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-261012-0009','2026-10-12','2026-10-12','14:21:04','SIN','---','0.840','805000','805000','805000','805000','805000','kasir','2026-10-12 14:21:04','FB-261012-0007'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261012-0009','ZHELA','KISMANTORO','','','','kasir','2026-10-12 14:21:04'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-12' 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-261012-0035','K','2026-10-12','14:21:04','kasir','PEMBELIAN UMUM','FB-261012-0009','7834509000','805000','7833704000'); 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-00020508','X-00020508','CC X MODEL MATA UB 10 8K','GR','---','E2E','BELI','BELI001','665000','2026-10-12','0.680','1','kasir','2026-10-12 14:21:04'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020508','X-00020508'); 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-261012-0010','F326180135241','SIN','4','BELI','BELI001','E2E', 'X-00020508', 'CC X MODEL MATA UB 10 8K','0.680','0.680','100.00','740000','665000','977941','1043000','1','665000','665000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.680',berat_beli_asli=berat_beli_asli+'0.680',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.680',berat_akhir_asli=berat_akhir_asli+'0.680',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-12' 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-261012-0010','2026-10-12','2026-10-12','14:21:04','SIN','---','0.680','665000','665000','665000','665000','665000','kasir','2026-10-12 14:21:04','FB-261012-0007'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261012-0010','ZHELA ERAWATI','KISMANTORO','','','','kasir','2026-10-12 14:21:04'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-12' 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-261012-0036','K','2026-10-12','14:21:04','kasir','PEMBELIAN UMUM','FB-261012-0010','7833704000','665000','7833039000'); 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-00020509','X-00020509','LT X MODEL SLEP HW 8K','GR','---','D1G','BELI','BELI001','295000','2026-10-12','0.300','1','kasir','2026-10-12 14:21:04'); DELETE FROM tp_barang WHERE kode_dept = 'X-D1G'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1G','X-00020509','X-00020509'); 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-261012-0011','F326081155331','SIN','5','BELI','BELI001','D1G', 'X-00020509', 'LT X MODEL SLEP HW 8K','0.300','0.300','100.00','338000','295000','983333','1083000','1','295000','295000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.300',berat_beli_asli=berat_beli_asli+'0.300',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.300',berat_akhir_asli=berat_akhir_asli+'0.300',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1G' 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-261012-0011','2026-10-12','2026-10-12','14:21:04','SIN','---','0.300','295000','295000','295000','295000','295000','kasir','2026-10-12 14:21:04','FB-261012-0007'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261012-0011','ZHELA','KISMANTORO','','','','kasir','2026-10-12 14:21:04'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-12' 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-261012-0037','K','2026-10-12','14:21:04','kasir','PEMBELIAN UMUM','FB-261012-0011','7833039000','295000','7832744000'); 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-00020510','X-00020510','LT XX MODEL HATI MATA LG 8K','GR','---','D2E','BELI','BELI001','515000','2026-10-12','0.530','1','kasir','2026-10-12 14:21:04'); DELETE FROM tp_barang WHERE kode_dept = 'X-D2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2E','X-00020510','X-00020510'); 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-261012-0012','F326271244151','SIN','6','BELI','BELI001','D2E', 'X-00020510', 'LT XX MODEL HATI MATA LG 8K','0.530','0.530','100.00','543000','515000','971698','1043000','1','515000','515000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2E' 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-261012-0012','2026-10-12','2026-10-12','14:21:04','SIN','---','0.530','515000','515000','515000','515000','515000','kasir','2026-10-12 14:21:04','FB-261012-0007'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261012-0012','ZHELA','KISMANTORO','','','','kasir','2026-10-12 14:21:04'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-12' 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-261012-0038','K','2026-10-12','14:21:04','kasir','PEMBELIAN UMUM','FB-261012-0012','7832744000','515000','7832229000'); 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 ('F326120249171','kasir','1',' MEF3 X UB ','TOKO','PM-F','F3E-ZJXF-213-0','GL X KREPYK DAUN SPECTRA UB 8K ','','4.950','1','100.00','5163000','0','0','15000','5163000','0','0','0','5163000','LIS','00428117','F3E','0','0','-','0','1043000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJXF-213-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.950',berat_jual_asli=berat_jual_asli+'4.950',stock_jual='1',berat_akhir=berat_akhir-'4.950',berat_akhir_asli=berat_akhir_asli-'4.950',stock_akhir='0' WHERE tanggal='2026-10-12' AND kode_barang='F3E-ZJXF-213-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 ('F326120249171','2026-10-12','4.950','2026-10-12','14:49:17','PLG0031830','5163000','5163000','0','5163000','5163000','kasir','2026-10-12 14:49:17','F32612024917'); 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-12','F326120249171','2026-10-12','14:49:17','LIS','5163000','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-261012-0039','D','2026-10-12','14:49:17','kasir','PENJUALAN','F326120249171','7832229000','5163000','7837392000'); 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 ('F326120256081','kasir','1',' MDE1 CM 18','TOKO','PM-E','E1D-YEXC-434-0','CC MODEL SLEP VAR CM 18 8K ','','1.020','1','100.00','1043000','0','0','15000','1043000','0','0','0','1043000','LIS','00352745','E1D','0','0','-','0','1023000'); UPDATE tm_barang SET tgl_last_jual='2026-10-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-YEXC-434-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-12' AND kode_barang='E1D-YEXC-434-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 ('F326120256081','2026-10-12','1.020','2026-10-12','14:56:09','PLG0031831','1043000','1043000','0','1043000','1043000','kasir','2026-10-12 14:56:08','F32612025608'); 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-12','F326120256081','2026-10-12','14:56:09','LIS','1043000','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-261012-0040','D','2026-10-12','14:56:09','kasir','PENJUALAN','F326120256081','7837392000','1043000','7838435000'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261012-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261012-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261012-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261012-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261012-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261012-0003'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261012-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261012-0004'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261012-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261012-0005'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261012-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261012-0006'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261012-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261012-0007'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261012-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261012-0008'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261012-0009' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261012-0009'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261012-0010' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261012-0010'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261012-0011' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261012-0011'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261012-0012' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261012-0012'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326120108501' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326120108501' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326120108501'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326120120541' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326120120541' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326120120541'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326120134151' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326120134151' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326120134151'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326120217541' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326120217541' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326120217541'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326120217542' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326120217542' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326120217542'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326120249171' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326120249171' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326120249171'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326120256081' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326120256081' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326120256081'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326120810521' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326120810521' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326120810521'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326120851521' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326120851521' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326120851521'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326120911361' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326120911361' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326120911361'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326120922101' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326120922101' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326120922101'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326120922461' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326120922461' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326120922461'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326120932401' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326120932401' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326120932401'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326120936591' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326120936591' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326120936591'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121035351' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121035351' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121035351'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121035352' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121035352' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121035352'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121037411' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121037411' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121037411'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121038381' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121038381' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121038381'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121120091' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121120091' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121120091'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121218141' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121218141' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121218141'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121223501' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121223501' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121223501'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121223502' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121223502' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121223502'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121223503' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121223503' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121223503'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121223504' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121223504' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121223504'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121223505' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121223505' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121223505'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121225591' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121225591' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121225591'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326121238241' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326121238241' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326121238241'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-13','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-12'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-12'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-12'; 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-12' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-12'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-12'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-12'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-12'; 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-13' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-12' 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-261013-0001','D','2026-10-13','15:19:00','SYSTEM','SALDO AWAL','SALDO AWAL','0','7838435000','7838435000'); 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-261013-0001','D','2026-10-13','15:19:00','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-261013-0001','D','2026-10-13','15:19:00','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-261013-0001','D','2026-10-13','15:19:00','BCA','SALDO AWAL','SALDO AWAL','0','743627000','743627000'); UPDATE tp_system SET tgl_system='2026-10-13';