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 ('F326230841031','input','1',' TEE1 HT 13','TOKO','PT-E','E1TE-ZGAG-57-T','CC BANGKOK VAR SLEP HT 13 17K ','','0.570','1','100.00','1134000','0','0','15000','1135000','0','0','0','1135000','SIN','T0081280','E1TE','0','0','-','0','1990000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-ZGAG-57-T' 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-08-23' AND kode_barang='E1TE-ZGAG-57-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 ('F326230841031','2026-08-23','0.570','2026-08-23','08:41:03','PLG0030910','1135000','1135000','0','1135000','1135000','input','2026-08-23 08:41:03','F32623084103');
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-08-23','F326230841031','2026-08-23','08:41:03','SIN','1135000','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-260823-0002','D','2026-08-23','08:41:03','input','PENJUALAN','F326230841031','6913694000','1135000','6914829000');
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 ('F326230911191','input','1',' MEF3E X PM','TOKO','PM-F','F3E-ZGCA-99-0','GL X KREPYAK DAUN SLEP PM 8K ','','3.130','1','100.00','3396000','0','0','15000','3395000','0','0','0','3395000','LIS','00416185','F3E','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGCA-99-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.130',berat_jual_asli=berat_jual_asli+'3.130',stock_jual='1',berat_akhir=berat_akhir-'3.130',berat_akhir_asli=berat_akhir_asli-'3.130',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='F3E-ZGCA-99-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 ('F326230911191','2026-08-23','3.130','2026-08-23','09:11:20','PLG0030911','3395000','3395000','0','3395000','3395000','input','2026-08-23 09:11:19','F32623091119');
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-08-23','F326230911191','2026-08-23','09:11:20','LIS','3395000','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-260823-0003','D','2026-08-23','09:11:20','input','PENJUALAN','F326230911191','6914829000','3395000','6918224000');
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 ('F326230919351','input','1',' MEF2 X YT ','TOKO','PM-F','F2E-ZDBX-31-0','GL X OVAL MATA YT 56 8K ','','5.250','1','100.00','5696000','0','0','15000','5697000','0','0','0','5697000','AAT','00399966','F2E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZDBX-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.250',berat_jual_asli=berat_jual_asli+'5.250',stock_jual='1',berat_akhir=berat_akhir-'5.250',berat_akhir_asli=berat_akhir_asli-'5.250',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='F2E-ZDBX-31-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 ('F326230919351','2026-08-23','5.250','2026-08-23','09:19:36','PLG0030912','5697000','5697000','0','5697000','5697000','input','2026-08-23 09:19:35','F32623091935');
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-08-23','F326230919351','2026-08-23','09:19:36','AAT','5697000','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-260823-0004','D','2026-08-23','09:19:36','input','PENJUALAN','F326230919351','6918224000','5697000','6923921000');
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 ('F326230944221','input','1',' MGS1G DG ','TOKO','PM-S','S1G-ZHAX-327-0','AS EXTENTION DG 8K ','','0.190','1','100.00','214000','0','0','15000','215000','0','0','0','215000','SIN','00418472','S1G','0','0','-','0','1125000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZHAX-327-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.190',berat_jual_asli=berat_jual_asli+'0.190',stock_jual='1',berat_akhir=berat_akhir-'0.190',berat_akhir_asli=berat_akhir_asli-'0.190',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='S1G-ZHAX-327-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 ('F326230944221','2026-08-23','0.190','2026-08-23','09:44:22','PLG0030913','215000','215000','0','215000','215000','input','2026-08-23 09:44:22','F32623094422');
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-08-23','F326230944221','2026-08-23','09:44:22','SIN','215000','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-260823-0005','D','2026-08-23','09:44:22','input','PENJUALAN','F326230944221','6923921000','215000','6924136000');
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-00019997','X-00019997','GL XX CASTELI SLEP VAR HW 8K','GR','---','F3E','BELI','BELI001','1412000','2026-08-23','1.520','1','kasir','2026-08-23 10:03:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019997','X-00019997');
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-260823-0001','F326051016371','AAT','1','BELI','BELI001','F3E', 'X-00019997', 'GL XX CASTELI SLEP VAR HW 8K','1.520','1.520','100.00','1520000','1412000','928947','1095000','1','1412000','1412000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.520',berat_beli_asli=berat_beli_asli+'1.520',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.520',berat_akhir_asli=berat_akhir_asli+'1.520',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-23' 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-260823-0001','2026-08-23','2026-08-23','10:03:36','AAT','---','1.520','1412000','1412000','1412000','1412000','1412000','kasir','2026-08-23 10:03:37','FB-260823-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260823-0001','ANIK','NAWANGAN PACITAN','','','','kasir','2026-08-23 10:03:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-23' 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-260823-0006','K','2026-08-23','10:03:36','kasir','PEMBELIAN UMUM','FB-260823-0001','6924136000','1412000','6922724000');
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-00019998','X-00019998','AT X MODEL MATA BW 8K','GR','---','A1E','BELI','BELI001','222000','2026-08-23','0.310','1','kasir','2026-08-23 10:04:07');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00019998','X-00019998');
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-260823-0002','F325240859411','LIS','1','BELI','BELI001','A1E', 'X-00019998', 'AT X MODEL MATA BW 8K','0.630','0.310','100.00','525000','222000','716129','1095000','1','222000','222000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.310',berat_beli_asli=berat_beli_asli+'0.310',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.310',berat_akhir_asli=berat_akhir_asli+'0.310',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-23' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260823-0002','2026-08-23','2026-08-23','10:04:07','LIS','---','0.310','222000','222000','222000','222000','222000','kasir','2026-08-23 10:04:07','FB-260823-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260823-0002','LAYLA','PUHPELEM','','','','kasir','2026-08-23 10:04:07');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-23' 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-260823-0007','K','2026-08-23','10:04:07','kasir','PEMBELIAN UMUM','FB-260823-0002','6922724000','222000','6922502000');
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-00019999','X-00019999','CC X WEDDING MATA CM 12 8K','GR','---','E2E','BELI','BELI001','767000','2026-08-23','0.760','1','kasir','2026-08-23 10:04:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00019999','X-00019999');
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-260823-0003','F326101103551','FIT','1','BELI','BELI001','E2E', 'X-00019999', 'CC X WEDDING MATA CM 12 8K','0.760','0.760','100.00','825000','767000','1009211','1095000','1','767000','767000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.760',berat_beli_asli=berat_beli_asli+'0.760',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.760',berat_akhir_asli=berat_akhir_asli+'0.760',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-23' 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-260823-0003','2026-08-23','2026-08-23','10:04:24','FIT','---','0.760','767000','767000','767000','767000','767000','kasir','2026-08-23 10:04:24','FB-260823-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260823-0003','FITRI','SUMBER NGUNENG PUHPELEM','','','','kasir','2026-08-23 10:04:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-23' 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-260823-0008','K','2026-08-23','10:04:24','kasir','PEMBELIAN UMUM','FB-260823-0003','6922502000','767000','6921735000');
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-00020000','X-00020000','CC X MODEL SLEP NJ 12','GR','---','E1E','BELI','BELI001','675000','2026-08-23','0.950','1','kasir','2026-08-23 10:22:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00020000','X-00020000');
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-260823-0004','F322220230471','AAT','1','BELI','BELI001','E1E', 'X-00020000', 'CC X MODEL SLEP NJ 12','1.000','0.950','100.00','410000','675000','710526','1095000','1','675000','675000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.950',berat_beli_asli=berat_beli_asli+'0.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.950',berat_akhir_asli=berat_akhir_asli+'0.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-23' 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-260823-0004','2026-08-23','2026-08-23','10:22:29','AAT','---','0.950','675000','675000','675000','675000','675000','kasir','2026-08-23 10:22:29','FB-260823-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260823-0004','LAILA','SENDANG','','','','kasir','2026-08-23 10:22:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-23' 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-260823-0009','K','2026-08-23','10:22:29','kasir','PEMBELIAN UMUM','FB-260823-0004','6921735000','675000','6921060000');
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 ('F326231023121','kasir','1',' MEH1 10K K','TOKO','PM-H','H1E-ZFXB-87-0','KL SANTA ANAK CAT SLEP KH 34 8K ','','2.180','1','100.00','2365000','0','0','15000','2365000','0','10000','0','2375000','SIN','00406479','H1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFXB-87-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.180',berat_jual_asli=berat_jual_asli+'2.180',stock_jual='1',berat_akhir=berat_akhir-'2.180',berat_akhir_asli=berat_akhir_asli-'2.180',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='H1E-ZFXB-87-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 ('F326231023121','2026-08-23','2.180','2026-08-23','10:23:12','PLG0030914','2365000','2365000','10000','2375000','2375000','kasir','2026-08-23 10:23:12','F32623102312');
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-08-23','F326231023121','2026-08-23','10:23:12','SIN','2375000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260823-0010','D','2026-08-23','10:23:12','kasir','PENJUALAN','F326231023121','6921060000','2375000','6923435000');
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 ('F326231024001','kasir','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZDAH-206-0','CC X VELG POLOS CM 12 8K ','','0.960','1','100.00','1022000','0','0','15000','1022000','0','0','0','1022000','SIN','00399907','E1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDAH-206-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.960',berat_jual_asli=berat_jual_asli+'0.960',stock_jual='1',berat_akhir=berat_akhir-'0.960',berat_akhir_asli=berat_akhir_asli-'0.960',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='E1D-ZDAH-206-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326231024001','2026-08-23','0.960','2026-08-23','10:24:01','PLG0030915','1022000','1022000','0','1022000','1022000','kasir','2026-08-23 10:24:00','F32623102400');
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-08-23','F326231024001','2026-08-23','10:24:01','SIN','1022000','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-260823-0011','D','2026-08-23','10:24:01','kasir','PENJUALAN','F326231024001','6923435000','1022000','6924457000');
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 ('F326231033511','kasir','1',' MEE2 5K LG','TOKO','PM-E','E2E-ZGBC-271-0','CC BONEKA ANAK CAT MATA LG 8K ','','0.500','1','100.00','542000','0','0','15000','542000','0','5000','0','547000','SIN','00415344','E2E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGBC-271-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-08-23' AND kode_barang='E2E-ZGBC-271-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 ('F326231033511','2026-08-23','0.500','2026-08-23','10:33:52','PLG0030916','542000','542000','5000','547000','547000','kasir','2026-08-23 10:33:51','F32623103351');
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-08-23','F326231033511','2026-08-23','10:33:52','SIN','547000','5000');
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-260823-0012','D','2026-08-23','10:33:52','kasir','PENJUALAN','F326231033511','6924457000','547000','6925004000');
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 ('F326231037341','kasir','1',' MDA1D X UB','TOKO','PM-A','A1D-ZFXH-30-0','AT X ITALY SLEP VAR UB 8K ','','0.950','1','100.00','1012000','0','0','15000','1013000','0','0','0','1013000','LIS','00407891','A1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZFXH-30-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-08-23' AND kode_barang='A1D-ZFXH-30-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326231037341','2026-08-23','0.950','2026-08-23','10:37:35','PLG0030917','1013000','1013000','0','1013000','1013000','kasir','2026-08-23 10:37:34','F32623103734');
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-08-23','F326231037341','2026-08-23','10:37:35','LIS','1013000','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-260823-0013','D','2026-08-23','10:37:35','kasir','PENJUALAN','F326231037341','6925004000','1013000','6926017000');
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-00020001','X-00020001','GL BANGKOK KACA ANAK PM 42 8K','GR','---','F1E','BELI','BELI001','1465000','2026-08-23','1.520','1','kasir','2026-08-23 10:58:47');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00020001','X-00020001');
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-260823-0005','F325130200581','LIS','1','BELI','BELI001','F1E', 'X-00020001', 'GL BANGKOK KACA ANAK PM 42 8K','1.520','1.520','100.00','1592000','1465000','963816','1095000','1','1465000','1465000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.520',berat_beli_asli=berat_beli_asli+'1.520',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.520',berat_akhir_asli=berat_akhir_asli+'1.520',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-23' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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-260823-0005','2026-08-23','2026-08-23','10:58:46','LIS','---','1.520','1465000','1465000','1465000','1465000','1465000','kasir','2026-08-23 10:58:47','FB-260823-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260823-0005','SAKA','JOHO','','','','kasir','2026-08-23 10:58:47');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-23' 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-260823-0014','K','2026-08-23','10:58:46','kasir','PEMBELIAN UMUM','FB-260823-0005','6926017000','1465000','6924552000');
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-00020002','X-00020002','AT MODEL BONEKA CAT VAR LG 8K','GR','---','A1E','BELI','BELI001','435000','2026-08-23','0.560','1','kasir','2026-08-23 10:59:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00020002','X-00020002');
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-260823-0006','F325271027162','LIS','1','BELI','BELI001','A1E', 'X-00020002', 'AT MODEL BONEKA CAT VAR LG 8K','0.560','0.560','100.00','468000','435000','776786','1095000','1','435000','435000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.560',berat_beli_asli=berat_beli_asli+'0.560',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.560',berat_akhir_asli=berat_akhir_asli+'0.560',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-23' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260823-0006','2026-08-23','2026-08-23','10:59:29','LIS','---','0.560','435000','435000','435000','435000','435000','kasir','2026-08-23 10:59:29','FB-260823-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260823-0006','HENI','MADE SLOGOHIMO','','','','kasir','2026-08-23 10:59:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-23' 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-260823-0015','K','2026-08-23','10:59:29','kasir','PEMBELIAN UMUM','FB-260823-0006','6924552000','435000','6924117000');
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-00020003','X-00020003','GW X TUSUK MRICAN SLEP AV 8K','GR','---','B1H','BELI','BELI001','270000','2026-08-23','0.260','1','kasir','2026-08-23 10:59:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1H';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1H','X-00020003','X-00020003');
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-260823-0007','F326270126041','AAT','1','BELI','BELI001','B1H', 'X-00020003', 'GW X TUSUK MRICAN SLEP AV 8K','0.260','0.260','100.00','305000','270000','1038462','1145000','1','270000','270000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.260',berat_beli_asli=berat_beli_asli+'0.260',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.260',berat_akhir_asli=berat_akhir_asli+'0.260',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-23' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1H' 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-260823-0007','2026-08-23','2026-08-23','10:59:51','AAT','---','0.260','270000','270000','270000','270000','270000','kasir','2026-08-23 10:59:51','FB-260823-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260823-0007','NURAINI','BITING','','','','kasir','2026-08-23 10:59:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-23' 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-260823-0016','K','2026-08-23','10:59:51','kasir','PEMBELIAN UMUM','FB-260823-0007','6924117000','270000','6923847000');
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 ('F326231124371','kasir','1',' MEB1 X LG ','TOKO','PM-B','B1E-ZFCX-260-0','GW X MODEL TAUGE MATA LG 8K ','','0.580','1','100.00','629000','0','0','15000','630000','0','0','0','630000','FIT','00411467','B1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZFCX-260-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='B1E-ZFCX-260-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 ('F326231124371','2026-08-23','0.580','2026-08-23','11:24:38','PLG0030918','630000','630000','0','630000','630000','kasir','2026-08-23 11:24:37','F32623112437');
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-08-23','F326231124371','2026-08-23','11:24:38','FIT','630000','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-260823-0017','D','2026-08-23','11:24:38','kasir','PENJUALAN','F326231124371','6923847000','630000','6924477000');
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 ('F326231155401','kasir','1',' MDE1 X LG ','TOKO','PM-E','E1D-ZCCA-149-0','CC X MODEL SLEP LG 22 8K ','','2.100','1','100.00','2236000','0','0','15000','2236000','0','0','0','2236000','SIN','00397372','E1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZCCA-149-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='E1D-ZCCA-149-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 ('F326231155401','2026-08-23','2.100','2026-08-23','11:55:41','PLG0030919','2236000','2236000','0','2236000','2236000','kasir','2026-08-23 11:55:40','F32623115540');
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-08-23','F326231155401','2026-08-23','11:55:41','SIN','2236000','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-260823-0018','D','2026-08-23','11:55:41','kasir','PENJUALAN','F326231155401','6924477000','2236000','6926713000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2236000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326231155401' 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 ('F326231155402','kasir',' 1',' MDE2 X CM ','TOKO','PM-E','E2D-ZFAB-183-0','CC X MODEL MATA CM 22 8K ','','2.150','1','100.00','2290000','0','0','15000','2290000','0','0','0','2290000','SIN','00408652','E2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFAB-183-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.150',berat_jual_asli=berat_jual_asli+'2.150',stock_jual='1',berat_akhir=berat_akhir-'2.150',berat_akhir_asli=berat_akhir_asli-'2.150',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='E2D-ZFAB-183-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 ('F326231155402','2026-08-23','2.150','2026-08-23','11:55:41','PLG0030920','2290000','2290000','0','2290000','2290000','kasir','2026-08-23 11:55:40','F32623115540');
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-08-23','F326231155402','2026-08-23','11:55:41','SIN','2290000','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-260823-0019','D','2026-08-23','11:55:41','kasir','PENJUALAN','F326231155402','6926713000','2290000','6929003000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2290000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326231155402' 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 ('F326231217321','kasir','1',' MEA1E LG ','TOKO','PM-A','A1E-ZHXF-343-0','AT GYPSY SLEP LG 8K ','','0.500','1','100.00','542000','0','0','15000','543000','0','0','0','543000','LIS','00417401','A1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZHXF-343-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-08-23' AND kode_barang='A1E-ZHXF-343-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326231217321','2026-08-23','0.500','2026-08-23','12:17:33','PLG0030921','543000','543000','0','543000','543000','kasir','2026-08-23 12:17:32','F32623121732');
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-08-23','F326231217321','2026-08-23','12:17:33','LIS','543000','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-260823-0020','D','2026-08-23','12:17:33','kasir','PENJUALAN','F326231217321','6929003000','543000','6929546000');
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 ('F326231218101','kasir','1',' MEE1 HTM 1','TOKO','PM-E','E1E-ZEXA-36-0','CC PIPA MODEL DAUN VAR HTM 18 8K ','','0.470','1','100.00','510000','0','0','15000','510000','0','0','0','510000','LIS','00401933','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXA-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='E1E-ZEXA-36-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 ('F326231218101','2026-08-23','0.470','2026-08-23','12:18:11','PLG0030922','510000','510000','0','510000','510000','kasir','2026-08-23 12:18:10','F32623121810');
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-08-23','F326231218101','2026-08-23','12:18:11','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) VALUES ('KM-260823-0021','D','2026-08-23','12:18:11','kasir','PENJUALAN','F326231218101','6929546000','510000','6930056000');
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 ('F326231218501','kasir','1',' MFE1 KH 12','TOKO','PM-E','E1F-ZHXF-335-0','CC MODEL KUPU SLEP KH 12 8K ','','0.320','1','100.00','354000','0','0','15000','354000','0','0','0','354000','LIS','00417393','E1F','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZHXF-335-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='E1F-ZHXF-335-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 ('F326231218501','2026-08-23','0.320','2026-08-23','12:18:50','PLG0030923','354000','354000','0','354000','354000','kasir','2026-08-23 12:18:50','F32623121850');
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-08-23','F326231218501','2026-08-23','12:18:50','LIS','354000','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-260823-0022','D','2026-08-23','12:18:50','kasir','PENJUALAN','F326231218501','6930056000','354000','6930410000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326231218101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326231218101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326231218101';
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 ('F326231223461','kasir','1',' MEE1 HTM 1','TOKO','PM-E','E1E-ZEXA-36-0','CC PIPA MODEL DAUN VAR HTM 18 8K ','','0.470','1','100.00','510000','0','0','15000','510000','0','0','0','510000','LIS','00401933','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXA-36-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='E1E-ZEXA-36-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 ('F326231223461','2026-08-23','0.470','2026-08-23','12:23:46','PLG0030924','510000','510000','0','510000','510000','kasir','2026-08-23 12:23:46','F32623122346');
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-08-23','F326231223461','2026-08-23','12:23:46','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) VALUES ('KM-260823-0024','D','2026-08-23','12:23:46','kasir','PENJUALAN','F326231223461','6929900000','510000','6930410000');
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 ('F326231238191','kasir','1',' MEE1E LG 1','TOKO','PM-E','E1E-ZHXE-303-0','CC MODEL SNACK SLEP LG 12 8K ','','0.530','1','100.00','575000','0','0','15000','575000','0','0','0','575000','SIN','00417072','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHXE-303-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='E1E-ZHXE-303-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 ('F326231238191','2026-08-23','0.530','2026-08-23','12:38:19','PLG0030925','575000','575000','0','575000','575000','kasir','2026-08-23 12:38:19','F32623123819');
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-08-23','F326231238191','2026-08-23','12:38:19','SIN','575000','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-260823-0025','D','2026-08-23','12:38:19','kasir','PENJUALAN','F326231238191','6930410000','575000','6930985000');
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 ('F326230109161','kasir','1',' MFB1F X LG','TOKO','PM-B','B1F-ZEBE-17-0','GW X TUSUK MRICAN SLEP LG 8K ','','0.320','1','100.00','354000','0','0','15000','355000','0','0','0','355000','FIT','00404716','B1F','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-ZEBE-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='B1F-ZEBE-17-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 ('F326230109161','2026-08-23','0.320','2026-08-23','13:09:17','PLG0030926','355000','355000','0','355000','355000','kasir','2026-08-23 13:09:16','F32623010916');
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-08-23','F326230109161','2026-08-23','13:09:17','FIT','355000','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-260823-0026','D','2026-08-23','13:09:17','kasir','PENJUALAN','F326230109161','6930985000','355000','6931340000');
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 ('F326230112181','kasir','1',' MDE1 CM 20','TOKO','PM-E','E1D-ZGBC-260-0','CC VELG POLOS CM 20 8K ','','1.820','1','100.00','1938000','0','0','15000','1938000','0','0','0','1938000','SIN','00415333','E1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGBC-260-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.820',berat_jual_asli=berat_jual_asli+'1.820',stock_jual='1',berat_akhir=berat_akhir-'1.820',berat_akhir_asli=berat_akhir_asli-'1.820',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='E1D-ZGBC-260-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 ('F326230112181','2026-08-23','1.820','2026-08-23','13:12:19','PLG0030927','1938000','1938000','0','1938000','1938000','kasir','2026-08-23 13:12:18','F32623011218');
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-08-23','F326230112181','2026-08-23','13:12:19','SIN','1938000','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-260823-0027','D','2026-08-23','13:12:19','kasir','PENJUALAN','F326230112181','6931340000','1938000','6933278000');
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 ('F326230116431','kasir','1',' MEE2 KH 14','TOKO','PM-E','E2E-ZGBC-269-0','CC MODEL MATA KH 14 8K ','','0.470','1','100.00','510000','0','0','15000','510000','0','0','0','510000','SIN','00415342','E2E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZGBC-269-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='E2E-ZGBC-269-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 ('F326230116431','2026-08-23','0.470','2026-08-23','13:16:44','PLG0030928','510000','510000','0','510000','510000','kasir','2026-08-23 13:16:43','F32623011643');
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-08-23','F326230116431','2026-08-23','13:16:44','SIN','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-260823-0028','D','2026-08-23','13:16:44','kasir','PENJUALAN','F326230116431','6933278000','510000','6933788000');
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 ('F326230143391','kasir','1',' MDE2 X CM ','TOKO','PM-E','E2D-ZGXA-49-0','CC X MODEL CAT MATA CM 16 8K ','','1.030','1','100.00','1097000','0','0','15000','1097000','0','5000','0','1102000','LIS','00411573','E2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGXA-49-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='E2D-ZGXA-49-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 ('F326230143391','2026-08-23','1.030','2026-08-23','13:43:40','PLG0030929','1097000','1097000','5000','1102000','1102000','kasir','2026-08-23 13:43:39','F32623014339');
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-08-23','F326230143391','2026-08-23','13:43:40','LIS','1102000','5000');
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-260823-0029','D','2026-08-23','13:43:40','kasir','PENJUALAN','F326230143391','6933788000','1102000','6934890000');
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 ('F326230202241','kasir','1',' MEF3E HW ','TOKO','PM-F','F3E-ZHXE-304-0','GL RANTAI VERONA VAR SLEP HW 8K ','','1.710','1','100.00','1855000','0','0','15000','1855000','0','0','0','1855000','AAT','00417073','F3E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZHXE-304-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.710',berat_jual_asli=berat_jual_asli+'1.710',stock_jual='1',berat_akhir=berat_akhir-'1.710',berat_akhir_asli=berat_akhir_asli-'1.710',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='F3E-ZHXE-304-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 ('F326230202241','2026-08-23','1.710','2026-08-23','14:02:25','PLG0030930','1855000','1855000','0','1855000','1855000','kasir','2026-08-23 14:02:24','F32623020224');
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-08-23','F326230202241','2026-08-23','14:02:25','AAT','1855000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260823-0030','D','2026-08-23','14:02:25','kasir','PENJUALAN','F326230202241','6934890000','1855000','6936745000');
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 ('F326230226401','input','1',' MDE1 X PM ','TOKO','PM-E','E1D-ZGXG-88-0','CC X BANGKOK SLEP PM 16 8K ','','1.100','1','100.00','1171000','0','0','15000','1171000','0','0','0','1171000','SIN','00412489','E1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-23', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGXG-88-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-08-23' AND kode_barang='E1D-ZGXG-88-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 ('F326230226401','2026-08-23','1.100','2026-08-23','14:26:41','PLG0030931','1171000','1171000','0','1171000','1171000','input','2026-08-23 14:26:40','F32623022640');
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-08-23','F326230226401','2026-08-23','14:26:41','SIN','1171000','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-260823-0031','D','2026-08-23','14:26:41','input','PENJUALAN','F326230226401','6936745000','1171000','6937916000');
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-00020004','X-00020004','KL NORY UB 46CM 8K','GR','---','H1E','BELI','BELI001','885000','2026-08-23','0.950','1','kasir','2026-08-23 14:32:53');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020004','X-00020004');
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-260823-0008','F326030302021','LIS','1','BELI','BELI001','H1E', 'X-00020004', 'KL NORY UB 46CM 8K','0.950','0.950','100.00','1050000','885000','931579','1095000','1','885000','885000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.950',berat_beli_asli=berat_beli_asli+'0.950',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.950',berat_akhir_asli=berat_akhir_asli+'0.950',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-23' 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-260823-0008','2026-08-23','2026-08-23','14:32:53','LIS','---','0.950','885000','885000','885000','885000','885000','kasir','2026-08-23 14:32:53','FB-260823-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260823-0008','DEWI','KEPYAR','','','','kasir','2026-08-23 14:32:53');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-23' 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-260823-0032','K','2026-08-23','14:32:53','kasir','PEMBELIAN UMUM','FB-260823-0008','6937916000','885000','6937031000');
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-00020005','X-00020005','AT X GYPSY SLEP ANAK LG 8K','GR','---','A1E','BELI','BELI001','510000','2026-08-23','0.500','1','kasir','2026-08-23 14:33:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00020005','X-00020005');
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-260823-0009','F326311223191','SIN','1','BELI','BELI001','A1E', 'X-00020005', 'AT X GYPSY SLEP ANAK LG 8K','0.500','0.500','100.00','570000','510000','1020000','1095000','1','510000','510000','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-08-23' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260823-0009','2026-08-23','2026-08-23','14:33:28','SIN','---','0.500','510000','510000','510000','510000','510000','kasir','2026-08-23 14:33:28','FB-260823-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260823-0009','DILA','SLOGOHIMO','','','','kasir','2026-08-23 14:33:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-23' 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-260823-0033','K','2026-08-23','14:33:28','kasir','PEMBELIAN UMUM','FB-260823-0009','6937031000','510000','6936521000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260823-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260823-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260823-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260823-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260823-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260823-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260823-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260823-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260823-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260823-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260823-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260823-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260823-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260823-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260823-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260823-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260823-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260823-0009';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326230109161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326230109161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326230109161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326230112181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326230112181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326230112181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326230116431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326230116431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326230116431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326230143391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326230143391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326230143391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326230202241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326230202241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326230202241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326230226401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326230226401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326230226401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326230841031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326230841031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326230841031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326230911191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326230911191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326230911191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326230919351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326230919351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326230919351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326230944221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326230944221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326230944221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326231023121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326231023121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326231023121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326231024001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326231024001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326231024001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326231033511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326231033511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326231033511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326231037341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326231037341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326231037341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326231124371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326231124371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326231124371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326231155401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326231155401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326231155401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326231155402' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326231155402' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326231155402';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326231217321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326231217321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326231217321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326231218501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326231218501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326231218501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326231223461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326231223461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326231223461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326231238191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326231238191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326231238191';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-24','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-24';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-23';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-23';
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-08-23' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-23';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-23';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-23';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-23';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202607 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
UPDATE tt_barang_saldo SET tanggal= '2026-08-24' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-23' 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-260824-0001','D','2026-08-24','15:10:27','SYSTEM','SALDO AWAL','SALDO AWAL','0','6936521000','6936521000');
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-260824-0001','D','2026-08-24','15:10:27','BCA','SALDO AWAL','SALDO AWAL','0','738685000','738685000');
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-260824-0001','D','2026-08-24','15:10:27','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-260824-0001','D','2026-08-24','15:10:27','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-08-24';