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 ('F326150906341','input','1',' MEF2 YT D5','TOKO','PM-F','F2E-ZKXC-342-0','GL OVAL MODEL PAKU MATA VAR YT D54 8K ','','1.630','1','100.00','1663000','0','0','15000','1663000','0','0','0','1663000','SIN','00432965','F2E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZKXC-342-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.630',berat_jual_asli=berat_jual_asli+'1.630',stock_jual='1',berat_akhir=berat_akhir-'1.630',berat_akhir_asli=berat_akhir_asli-'1.630',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='F2E-ZKXC-342-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 ('F326150906341','2026-11-15','1.630','2026-11-15','09:06:35','PLG0032372','1663000','1663000','0','1663000','1663000','input','2026-11-15 09:06:34','F32615090634'); 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-11-15','F326150906341','2026-11-15','09:06:35','SIN','1663000','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-261115-0002','D','2026-11-15','09:06:35','input','PENJUALAN','F326150906341','8205611000','1663000','8207274000'); 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 ('F326150918001','input','1',' MEE2 KH 14','TOKO','PM-E','E2E-ZKAC-28-0','CC MODEL SNAKE MATA VAR KH 14 8K ','','0.500','1','100.00','515000','0','0','15000','510000','0','0','0','510000','AAT','00435005','E2E','0','0','-','1','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZKAC-28-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-11-15' AND kode_barang='E2E-ZKAC-28-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 ('F326150918001','2026-11-15','0.500','2026-11-15','09:18:01','PLG0032373','510000','510000','0','510000','510000','input','2026-11-15 09:18:00','F32615091800'); 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-11-15','F326150918001','2026-11-15','09:18:01','AAT','510000','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-261115-0003','D','2026-11-15','09:18:01','input','PENJUALAN','F326150918001','8207274000','510000','8207784000'); 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 ('F326150925471','input','1',' MEF3 YT ','TOKO','PM-F','F3E-ZJBG-164-0','GL TRIXIE SERUT BUNGA CLOVER SLEP YT 8K ','','2.780','1','100.00','2836000','0','0','15000','2836000','0','0','0','2836000','LIS','00431595','F3E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJBG-164-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.780',berat_jual_asli=berat_jual_asli+'2.780',stock_jual='1',berat_akhir=berat_akhir-'2.780',berat_akhir_asli=berat_akhir_asli-'2.780',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='F3E-ZJBG-164-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 ('F326150925471','2026-11-15','2.780','2026-11-15','09:25:48','PLG0032374','2836000','2836000','0','2836000','2836000','input','2026-11-15 09:25:47','F32615092547'); 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-11-15','F326150925471','2026-11-15','09:25:48','LIS','2836000','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-261115-0004','D','2026-11-15','09:25:48','input','PENJUALAN','F326150925471','8207784000','2836000','8210620000'); 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 ('F326150938271','input','1',' MEF3 HW ','TOKO','PM-F','F3E-ZIXI-57-0','GL MODEL FLIK POLOS HW 8K ','','1.020','1','100.00','1040000','0','0','15000','1040000','0','0','0','1040000','SIN','00422594','F3E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIXI-57-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-11-15' AND kode_barang='F3E-ZIXI-57-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 ('F326150938271','2026-11-15','1.020','2026-11-15','09:38:27','PLG0032375','1040000','1040000','0','1040000','1040000','input','2026-11-15 09:38:27','F32615093827'); 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-11-15','F326150938271','2026-11-15','09:38:27','SIN','1040000','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-261115-0005','D','2026-11-15','09:38:27','input','PENJUALAN','F326150938271','8210620000','1040000','8211660000'); 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 ('F326150939131','input','1',' MEF3 X PM ','TOKO','PM-F','F3E-ZIBF-220-0','GL X KREPYAK DAUN SLEP PM 8K ','','3.050','1','100.00','3111000','0','0','15000','3110000','0','0','0','3110000','SIN','00425838','F3E','0','0','-','1','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZIBF-220-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='F3E-ZIBF-220-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 ('F326150939131','2026-11-15','3.050','2026-11-15','09:39:14','PLG0032376','3110000','3110000','0','3110000','3110000','input','2026-11-15 09:39:13','F32615093913'); 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-11-15','F326150939131','2026-11-15','09:39:14','SIN','3110000','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-261115-0006','D','2026-11-15','09:39:14','input','PENJUALAN','F326150939131','8211660000','3110000','8214770000'); 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 ('F326150940581','input','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZIAX-17-0','CC X MODEL MATA CM 10 8K ','','0.910','1','100.00','910000','0','0','15000','910000','0','0','0','910000','FIT','00422821','E2D','0','0','-','0','1010000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZIAX-17-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='E2D-ZIAX-17-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 ('F326150940581','2026-11-15','0.910','2026-11-15','09:40:59','PLG0032377','910000','910000','0','910000','910000','input','2026-11-15 09:40:58','F32615094058'); 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-11-15','F326150940581','2026-11-15','09:40:59','FIT','910000','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-261115-0007','D','2026-11-15','09:40:59','input','PENJUALAN','F326150940581','8214770000','910000','8215680000'); 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 ('F326150941581','input','1',' MFE1 X KH ','TOKO','PM-E','E1F-ZJXH-179-0','CC X MODEL HATI SLEP KH 14 8K ','','0.420','1','100.00','437000','0','0','15000','437000','0','0','0','437000','AAT','00428667','E1F','0','0','-','0','1050000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZJXH-179-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='E1F-ZJXH-179-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 ('F326150941581','2026-11-15','0.420','2026-11-15','09:41:59','PLG0032378','437000','437000','0','437000','437000','input','2026-11-15 09:41:58','F32615094158'); 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-11-15','F326150941581','2026-11-15','09:41:59','AAT','437000','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-261115-0008','D','2026-11-15','09:41:59','input','PENJUALAN','F326150941581','8215680000','437000','8216117000'); 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 ('F326150950561','input','1',' MEE1E KH 1','TOKO','PM-E','E1E-ZHBE-297-0','CC MODEL SLEP KH 16 8K ','','0.550','1','100.00','561000','0','0','15000','562000','0','0','0','562000','FIT','00420339','E1E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHBE-297-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='E1E-ZHBE-297-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 ('F326150950561','2026-11-15','0.550','2026-11-15','09:50:57','PLG0032379','562000','562000','0','562000','562000','input','2026-11-15 09:50:56','F32615095056'); 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-11-15','F326150950561','2026-11-15','09:50:57','FIT','562000','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-261115-0009','D','2026-11-15','09:50:57','input','PENJUALAN','F326150950561','8216117000','562000','8216679000'); 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 ('F326151016581','input','1',' MEF1 X UB ','TOKO','PM-F','F1E-ZJXF-193-0','GL X OVAL C SLEP UB 54 8K ','','2.200','1','100.00','2244000','0','0','15000','2245000','0','0','0','2245000','SIN','00428097','F1E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZJXF-193-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.200',berat_jual_asli=berat_jual_asli+'2.200',stock_jual='1',berat_akhir=berat_akhir-'2.200',berat_akhir_asli=berat_akhir_asli-'2.200',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='F1E-ZJXF-193-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 ('F326151016581','2026-11-15','2.200','2026-11-15','10:16:58','PLG0032380','2245000','2245000','0','2245000','2245000','input','2026-11-15 10:16:58','F32615101658'); 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-11-15','F326151016581','2026-11-15','10:16:58','SIN','2245000','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-261115-0010','D','2026-11-15','10:16:58','input','PENJUALAN','F326151016581','8216679000','2245000','8218924000'); 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 ('F326151026031','input','1',' MEF2 10K B','TOKO','PM-F','F2E-ZDXD-262-0','GL OSROT ANAK MODEL CAT BM 8K ','','0.870','1','100.00','887000','0','0','15000','887000','0','10000','0','897000','AAT','00397962','F2E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZDXD-262-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.870',berat_jual_asli=berat_jual_asli+'0.870',stock_jual='1',berat_akhir=berat_akhir-'0.870',berat_akhir_asli=berat_akhir_asli-'0.870',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='F2E-ZDXD-262-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 ('F326151026031','2026-11-15','0.870','2026-11-15','10:26:03','PLG0032381','887000','887000','10000','897000','897000','input','2026-11-15 10:26:03','F32615102603'); 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-11-15','F326151026031','2026-11-15','10:26:03','AAT','897000','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-261115-0011','D','2026-11-15','10:26:03','input','PENJUALAN','F326151026031','8218924000','897000','8219821000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='897000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326151026031' 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 ('F326151026032','input',' 1',' MEE2 5K LG','TOKO','PM-E','E2E-ZGXA-353-0','CC BONEKA ANAK CAT MATA LG 8K ','','0.550','1','100.00','561000','0','0','15000','562000','0','5000','0','567000','AAT','00411877','E2E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGXA-353-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='E2E-ZGXA-353-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 ('F326151026032','2026-11-15','0.550','2026-11-15','10:26:03','PLG0032382','562000','562000','5000','567000','567000','input','2026-11-15 10:26:03','F32615102603'); 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-11-15','F326151026032','2026-11-15','10:26:03','AAT','567000','5000'); 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-261115-0012','D','2026-11-15','10:26:03','input','PENJUALAN','F326151026032','8219821000','567000','8220388000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='567000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326151026032' 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 ('F326151057101','input','1',' MFD1 XX BG','TOKO','PM-D','D1F-WJXB-99-0','CHARM XX SLOBOK HURUF BALOK BG B ','GL MANIK','0.600','1','100.00','624000','0','0','15000','605000','0','30000','0','635000','AAT','00256870','D1F','0','0','-','1','1050000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-WJXB-99-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-11-15' AND kode_barang='D1F-WJXB-99-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 ('F326151057101','2026-11-15','0.600','2026-11-15','10:57:11','PLG0032383','605000','605000','30000','635000','635000','input','2026-11-15 10:57:10','F32615105710'); 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-11-15','F326151057101','2026-11-15','10:57:11','AAT','635000','30000'); 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-261115-0013','D','2026-11-15','10:57:11','input','PENJUALAN','F326151057101','8220388000','635000','8221023000'); 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-00020846','X-00020846','CC MODEL ISYANA SLEP LG 12 8K','GR','---','E1F','BELI','BELI001','377000','2026-11-15','0.400','1','kasir','2026-11-15 11:03:36'); DELETE FROM tp_barang WHERE kode_dept = 'X-E1F'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1F','X-00020846','X-00020846'); 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-261115-0001','F326280121211','AAT','1','BELI','BELI001','E1F', 'X-00020846', 'CC MODEL ISYANA SLEP LG 12 8K','0.400','0.400','100.00','423000','377000','942500','1050000','1','377000','377000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.400',berat_beli_asli=berat_beli_asli+'0.400',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.400',berat_akhir_asli=berat_akhir_asli+'0.400',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-15' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1F' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261115-0001','2026-11-15','2026-11-15','11:03:36','AAT','---','0.400','377000','377000','377000','377000','377000','kasir','2026-11-15 11:03:36','FB-261115-0001'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261115-0001','IBTI','GADUNGAN KISMANTORO','','','','kasir','2026-11-15 11:03:36'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-15' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261115-0014','K','2026-11-15','11:03:36','kasir','PEMBELIAN UMUM','FB-261115-0001','8221023000','377000','8220646000'); 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-00020847','X-00020847','KL X GUCCI UB 44 8K','GR','---','H1E','BELI','BELI001','1850000','2026-11-15','1.920','1','kasir','2026-11-15 11:04:27'); DELETE FROM tp_barang WHERE kode_dept = 'X-H1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020847','X-00020847'); 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-261115-0002','F326080217471','SIN','1','BELI','BELI001','H1E', 'X-00020847', 'KL X GUCCI UB 44 8K','1.920','1.920','100.00','1968000','1850000','963542','1020000','1','1850000','1850000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.920',berat_beli_asli=berat_beli_asli+'1.920',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.920',berat_akhir_asli=berat_akhir_asli+'1.920',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-15' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261115-0002','2026-11-15','2026-11-15','11:04:26','SIN','---','1.920','1850000','1850000','1850000','1850000','1850000','kasir','2026-11-15 11:04:27','FB-261115-0002'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261115-0002','PUTRI','TUMPUK MIRI','','','','kasir','2026-11-15 11:04:27'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-15' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261115-0015','K','2026-11-15','11:04:26','kasir','PEMBELIAN UMUM','FB-261115-0002','8220646000','1850000','8218796000'); 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-00020848','X-00020848','CC X MODEL MATA UB 11 8K','GR','---','E2D','BELI','BELI001','1755000','2026-11-15','1.870','1','kasir','2026-11-15 11:05:10'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020848','X-00020848'); 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-261115-0003','F326140940401','LIS','1','BELI','BELI001','E2D', 'X-00020848', 'CC X MODEL MATA UB 11 8K','1.870','1.870','100.00','2057000','1755000','938503','1010000','1','1755000','1755000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.870',berat_beli_asli=berat_beli_asli+'1.870',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.870',berat_akhir_asli=berat_akhir_asli+'1.870',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-15' 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-261115-0003','2026-11-15','2026-11-15','11:05:09','LIS','---','1.870','1755000','1755000','1755000','1755000','1755000','kasir','2026-11-15 11:05:10','FB-261115-0003'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261115-0003','SUSANTI','TENGGAR','','','','kasir','2026-11-15 11:05:10'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-15' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261115-0016','K','2026-11-15','11:05:09','kasir','PEMBELIAN UMUM','FB-261115-0003','8218796000','1755000','8217041000'); 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-00020849','X-00020849','CC X MODEL MATA VAR MJ 16 17K','GR','---','E2TD','BELI','BELI001','4370000','2026-11-15','3.000','1','kasir','2026-11-15 11:05:44'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2TD'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TD','X-00020849','X-00020849'); 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-261115-0004','F325190120051','LIS','1','BELI','BELI001','E2TD', 'X-00020849', 'CC X MODEL MATA VAR MJ 16 17K','3.000','3.000','100.00','4345000','4370000','1456667','1860000','1','4370000','4370000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.000',berat_beli_asli=berat_beli_asli+'3.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.000',berat_akhir_asli=berat_akhir_asli+'3.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-15' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TD' 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-261115-0004','2026-11-15','2026-11-15','11:05:43','LIS','---','3.000','4370000','4370000','4370000','4370000','4370000','kasir','2026-11-15 11:05:44','FB-261115-0004'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261115-0004','AFID','WATUKUDI 2/6 JERUK PACITAN','','','','kasir','2026-11-15 11:05:44'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-15' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261115-0017','K','2026-11-15','11:05:43','kasir','PEMBELIAN UMUM','FB-261115-0004','8217041000','4370000','8212671000'); 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 ('F326151106471','kasir','1',' MEF1 X UB ','TOKO','PM-F','F1E-ZGXI-8-0','GL X OVAL DAUN SLEP UB 58 8K ','','3.230','1','100.00','3295000','0','0','15000','3295000','0','0','0','3295000','SIN','00412727','F1E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGXI-8-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.230',berat_jual_asli=berat_jual_asli+'3.230',stock_jual='1',berat_akhir=berat_akhir-'3.230',berat_akhir_asli=berat_akhir_asli-'3.230',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='F1E-ZGXI-8-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 ('F326151106471','2026-11-15','3.230','2026-11-15','11:06:48','PLG0032384','3295000','3295000','0','3295000','3295000','kasir','2026-11-15 11:06:47','F32615110647'); 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-11-15','F326151106471','2026-11-15','11:06:48','SIN','3295000','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-261115-0018','D','2026-11-15','11:06:48','kasir','PENJUALAN','F326151106471','8212671000','3295000','8215966000'); 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 ('F326151115201','kasir','1',' MED1E X YT','TOKO','PM-D','D1E-ZFAH-31-0','LT X BONEKA ANAK CAT YT 8K ','','0.600','1','100.00','612000','0','0','15000','613000','0','0','0','613000','AAT','00409038','D1E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZFAH-31-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-11-15' AND kode_barang='D1E-ZFAH-31-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 ('F326151115201','2026-11-15','0.600','2026-11-15','11:15:20','PLG0032385','613000','613000','0','613000','613000','kasir','2026-11-15 11:15:20','F32615111520'); 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-11-15','F326151115201','2026-11-15','11:15:20','AAT','613000','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-261115-0019','D','2026-11-15','11:15:20','kasir','PENJUALAN','F326151115201','8215966000','613000','8216579000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='613000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326151115201' 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 ('F326151115202','kasir',' 1',' MEH1 UB 42','TOKO','PM-H','H1E-ZKXI-84-0','KL NORY UB 42 8K ','','2.060','1','100.00','2101000','0','0','15000','2102000','0','0','0','2102000','AAT','00434053','H1E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZKXI-84-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='H1E-ZKXI-84-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 ('F326151115202','2026-11-15','2.060','2026-11-15','11:15:20','PLG0032386','2102000','2102000','0','2102000','2102000','kasir','2026-11-15 11:15:20','F32615111520'); 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-11-15','F326151115202','2026-11-15','11:15:20','AAT','2102000','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-261115-0020','D','2026-11-15','11:15:20','kasir','PENJUALAN','F326151115202','8216579000','2102000','8218681000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='2102000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326151115202' 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 ('F326151119571','kasir','1',' MDE2 X CM1','TOKO','PM-E','E2D-ZJXH-136-0','CC X MODEL MATA CM 14 8K ','','0.900','1','100.00','900000','0','0','15000','900000','0','0','0','900000','LIS','00428624','E2D','0','0','-','0','1010000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZJXH-136-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='E2D-ZJXH-136-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 ('F326151119571','2026-11-15','0.900','2026-11-15','11:19:58','PLG0032387','900000','900000','0','900000','900000','kasir','2026-11-15 11:19:57','F32615111957'); 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-11-15','F326151119571','2026-11-15','11:19:58','LIS','900000','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-261115-0021','D','2026-11-15','11:19:58','kasir','PENJUALAN','F326151119571','8218681000','900000','8219581000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='900000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326151119571' 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 ('F326151119572','kasir',' 1',' MEE1E PM 1','TOKO','PM-E','E1E-ZHBE-302-0','CC MODEL SLEP PM 10 8K ','','0.500','1','100.00','510000','0','0','15000','510000','0','0','0','510000','LIS','00420344','E1E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHBE-302-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-11-15' AND kode_barang='E1E-ZHBE-302-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 ('F326151119572','2026-11-15','0.500','2026-11-15','11:19:58','PLG0032388','510000','510000','0','510000','510000','kasir','2026-11-15 11:19:57','F32615111957'); 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-11-15','F326151119572','2026-11-15','11:19:58','LIS','510000','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-261115-0022','D','2026-11-15','11:19:58','kasir','PENJUALAN','F326151119572','8219581000','510000','8220091000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='510000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326151119572' 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 ('F326150126521','kasir','1',' MCE0 X DG ','TOKO','PM-E','E0C-ZIBA-433-0','CC X WARU DG 6 8K ','','0.480','1','100.00','470000','0','0','15000','470000','0','0','0','470000','LIS','00424977','E0C','0','0','-','0','980000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0C-ZIBA-433-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-11-15' AND kode_barang='E0C-ZIBA-433-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 ('F326150126521','2026-11-15','0.480','2026-11-15','13:26:52','PLG0032389','470000','470000','0','470000','470000','kasir','2026-11-15 13:26:52','F32615012652'); 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-11-15','F326150126521','2026-11-15','13:26:52','LIS','470000','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-261115-0023','D','2026-11-15','13:26:52','kasir','PENJUALAN','F326150126521','8220091000','470000','8220561000'); 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-00020850','X-00020850','GL COR OVAL PAKU MATA UB 56 8K','GR','---','F2E','BELI','BELI001','2012000','2026-11-15','2.360','1','kasir','2026-11-15 13:32:00'); DELETE FROM tp_barang WHERE kode_dept = 'X-F2E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F2E','X-00020850','X-00020850'); 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-261115-0005','F326021215361','LIS','1','BELI','BELI001','F2E', 'X-00020850', 'GL COR OVAL PAKU MATA UB 56 8K','2.360','2.360','100.00','2430000','2012000','852542','1020000','1','2012000','2012000','RUSAK'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.360',berat_beli_asli=berat_beli_asli+'2.360',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.360',berat_akhir_asli=berat_akhir_asli+'2.360',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-15' 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-261115-0005','2026-11-15','2026-11-15','13:32:00','LIS','---','2.360','2012000','2012000','2012000','2012000','2012000','kasir','2026-11-15 13:32:00','FB-261115-0005'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261115-0005','DINAR','BULUREJO BULUKERTO','','','','kasir','2026-11-15 13:32:00'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-15' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261115-0024','K','2026-11-15','13:32:00','kasir','PEMBELIAN UMUM','FB-261115-0005','8220561000','2012000','8218549000'); 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 ('F326150202231','kasir','1',' MEF3 PM ','TOKO','PM-F','F3E-ZJXF-209-0','GL MODEL DAUN SLEP VAR PM 8K ','','3.050','1','100.00','3111000','0','0','15000','3111000','0','0','0','3111000','LIS','00428113','F3E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJXF-209-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='F3E-ZJXF-209-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326150202231','2026-11-15','3.050','2026-11-15','14:02:23','PLG0032390','3111000','3111000','0','3111000','3111000','kasir','2026-11-15 14:02:23','F32615020223'); 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-11-15','F326150202231','2026-11-15','14:02:23','LIS','3111000','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-261115-0025','D','2026-11-15','14:02:23','kasir','PENJUALAN','F326150202231','8218549000','3111000','8221660000'); 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 ('F326150203131','kasir','1',' MDE2 X YT ','TOKO','PM-E','E2D-ZKAA-223-0','CC X MODEL MATA CAT YT 12 8K ','','0.950','1','100.00','950000','0','0','15000','950000','0','0','0','950000','FIT','00434591','E2D','0','0','-','0','1010000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZKAA-223-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='E2D-ZKAA-223-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 ('F326150203131','2026-11-15','0.950','2026-11-15','14:03:14','PLG0032391','950000','950000','0','950000','950000','kasir','2026-11-15 14:03:13','F32615020313'); 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-11-15','F326150203131','2026-11-15','14:03:14','FIT','950000','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-261115-0026','D','2026-11-15','14:03:14','kasir','PENJUALAN','F326150203131','8221660000','950000','8222610000'); 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 ('F326150206271','kasir','1',' MDE1 X LG ','TOKO','PM-E','E1D-ZKAX-251-0','CC X MODEL TINJU SLEP LG 14 8K ','','0.850','1','100.00','850000','0','0','15000','850000','0','0','0','850000','SIN','00434261','E1D','0','0','-','0','1010000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZKAX-251-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.850',berat_jual_asli=berat_jual_asli+'0.850',stock_jual='1',berat_akhir=berat_akhir-'0.850',berat_akhir_asli=berat_akhir_asli-'0.850',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='E1D-ZKAX-251-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 ('F326150206271','2026-11-15','0.850','2026-11-15','14:06:27','PLG0032392','850000','850000','0','850000','850000','kasir','2026-11-15 14:06:27','F32615020627'); 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-11-15','F326150206271','2026-11-15','14:06:27','SIN','850000','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-261115-0027','D','2026-11-15','14:06:27','kasir','PENJUALAN','F326150206271','8222610000','850000','8223460000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='850000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150206271' 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 ('F326150206272','kasir',' 1',' MEE1 HT 18','TOKO','PM-E','E1E-ZKAX-318-0','CC PIPA DAUN SLEP HT 18 8K ','','0.610','1','100.00','622000','0','0','15000','622000','0','0','0','622000','SIN','00434328','E1E','0','0','-','0','1020000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZKAX-318-0' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='E1E-ZKAX-318-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 ('F326150206272','2026-11-15','0.610','2026-11-15','14:06:27','PLG0032393','622000','622000','0','622000','622000','kasir','2026-11-15 14:06:27','F32615020627'); 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-11-15','F326150206272','2026-11-15','14:06:27','SIN','622000','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-261115-0028','D','2026-11-15','14:06:27','kasir','PENJUALAN','F326150206272','8223460000','622000','8224082000','OPEN'); UPDATE tt_jual_head SET dibayar_rp='622000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326150206272' 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-00020851','X-00020851','KL X SANTA UB 42 8K','GR','---','H1E','BELI','BELI001','3982000','2026-11-15','5.020','1','kasir','2026-11-15 14:14:53'); DELETE FROM tp_barang WHERE kode_dept = 'X-H1E'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020851','X-00020851'); 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-261115-0006','F325031024071','FIT','1','BELI','BELI001','H1E', 'X-00020851', 'KL X SANTA UB 42 8K','5.050','5.020','100.00','4218000','3982000','793227','1020000','1','3982000','3982000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.020',berat_beli_asli=berat_beli_asli+'5.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.020',berat_akhir_asli=berat_akhir_asli+'5.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-15' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1; INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261115-0006','2026-11-15','2026-11-15','14:14:52','FIT','---','5.020','3982000','3982000','3982000','3982000','3982000','kasir','2026-11-15 14:14:53','FB-261115-0006'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261115-0006','ANGGA','GIRIHARJO','','','','kasir','2026-11-15 14:14:53'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-15' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261115-0029','K','2026-11-15','14:14:52','kasir','PEMBELIAN UMUM','FB-261115-0006','8224082000','3982000','8220100000'); 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-00020852','X-00020852','CC WEDDING MATA CM 16 8K','GR','---','E2D','BELI','BELI001','1485000','2026-11-15','1.600','1','kasir','2026-11-15 14:15:15'); DELETE FROM tp_barang WHERE kode_dept = 'X-E2D'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020852','X-00020852'); 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-261115-0007','F325280248501','FIT','1','BELI','BELI001','E2D', 'X-00020852', 'CC WEDDING MATA CM 16 8K','1.600','1.600','100.00','1729000','1485000','928125','1010000','1','1485000','1485000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.600',berat_beli_asli=berat_beli_asli+'1.600',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.600',berat_akhir_asli=berat_akhir_asli+'1.600',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-15' 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-261115-0007','2026-11-15','2026-11-15','14:15:14','FIT','---','1.600','1485000','1485000','1485000','1485000','1485000','kasir','2026-11-15 14:15:15','FB-261115-0007'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261115-0007','DEWI','NGROMO NAWANGAN','','','082138826656','kasir','2026-11-15 14:15:15'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-15' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261115-0030','K','2026-11-15','14:15:14','kasir','PEMBELIAN UMUM','FB-261115-0007','8220100000','1485000','8218615000'); 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-00020853','X-00020853','KL X KOREA KH 44 8K','GR','---','H1F','BELI','BELI001','2040000','2026-11-15','2.100','1','kasir','2026-11-15 14:15:36'); DELETE FROM tp_barang WHERE kode_dept = 'X-H1F'; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1F','X-00020853','X-00020853'); 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-261115-0008','F325150220121','SIN','1','BELI','BELI001','H1F', 'X-00020853', 'KL X KOREA KH 44 8K','2.100','2.100','100.00','2195000','2040000','971429','1050000','1','2040000','2040000','CUCI'); UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.100',berat_beli_asli=berat_beli_asli+'2.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.100',berat_akhir_asli=berat_akhir_asli+'2.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-11-15' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1F' 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-261115-0008','2026-11-15','2026-11-15','14:15:36','SIN','---','2.100','2040000','2040000','2040000','2040000','2040000','kasir','2026-11-15 14:15:36','FB-261115-0008'); INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261115-0008','YUNI','PENGGUNG NAWANGAN','','','081225435004','kasir','2026-11-15 14:15:36'); SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-11-15' ORDER BY right(no_ref,4) DESC LIMIT 1; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-261115-0031','K','2026-11-15','14:15:36','kasir','PEMBELIAN UMUM','FB-261115-0008','8218615000','2040000','8216575000'); 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 ('F326150220161','input','1',' TFA1 X UB ','TOKO','PT-A','A1TF-VBAI-118-T','AT X ITALY PANJANG VAR UB ','','1.250','1','100.00','2375000','0','0','15000','2375000','0','0','0','2375000','AAT','T0029910','A1TF','0','0','-','0','1900000'); UPDATE tm_barang SET tgl_last_jual='2026-11-15', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TF-VBAI-118-T' LIMIT 1; UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.250',berat_jual_asli=berat_jual_asli+'1.250',stock_jual='1',berat_akhir=berat_akhir-'1.250',berat_akhir_asli=berat_akhir_asli-'1.250',stock_akhir='0' WHERE tanggal='2026-11-15' AND kode_barang='A1TF-VBAI-118-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-A' AND stock_akhir > 0 LIMIT 1; INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326150220161','2026-11-15','1.250','2026-11-15','14:20:17','PLG0032394','2375000','2375000','0','2375000','2375000','input','2026-11-15 14:20:16','F32615022016'); 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-11-15','F326150220161','2026-11-15','14:20:17','AAT','2375000','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-261115-0032','D','2026-11-15','14:20:17','input','PENJUALAN','F326150220161','8216575000','2375000','8218950000'); UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261115-0001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261115-0001'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261115-0002' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261115-0002'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261115-0003' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261115-0003'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261115-0004' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261115-0004'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261115-0005' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261115-0005'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261115-0006' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261115-0006'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261115-0007' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261115-0007'; UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261115-0008' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261115-0008'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150126521' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150126521' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150126521'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150202231' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150202231' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150202231'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150203131' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150203131' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150203131'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150206271' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150206271' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150206271'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150206272' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150206272' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150206272'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150220161' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150220161' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150220161'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150906341' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150906341' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150906341'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150918001' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150918001' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150918001'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150925471' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150925471' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150925471'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150938271' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150938271' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150938271'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150939131' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150939131' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150939131'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150940581' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150940581' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150940581'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150941581' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150941581' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150941581'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326150950561' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326150950561' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326150950561'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326151016581' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326151016581' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326151016581'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326151026031' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326151026031' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326151026031'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326151026032' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326151026032' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326151026032'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326151057101' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326151057101' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326151057101'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326151106471' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326151106471' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326151106471'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326151115201' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326151115201' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326151115201'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326151115202' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326151115202' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326151115202'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326151119571' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326151119571' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326151119571'; UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326151119572' LIMIT 1; UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326151119572' LIMIT 1; UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326151119572'; INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-16','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-16'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-15'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-15'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-11-15' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-15'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-15'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-15'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-15'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-16' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-15' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261116-0001','D','2026-11-16','15:12:50','SYSTEM','SALDO AWAL','SALDO AWAL','0','8218950000','8218950000'); 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-261116-0001','D','2026-11-16','15:12:50','BCA','SALDO AWAL','SALDO AWAL','0','748085000','748085000'); INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261116-0001','D','2026-11-16','15:12:50','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-261116-0001','D','2026-11-16','15:12:50','BRI','SALDO AWAL','SALDO AWAL','0','0','0'); UPDATE tp_system SET tgl_system='2026-11-16';