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 ('F226130830501','kasir','1',' MDE1D CM 1','TOKO','SMBK-E','E1D-ZHXG-30-T','CC VELG POLOS SLEP CM 17 8K ','OL','0.970','1','100.00','1043000','0','0','15000','1062000','0','5000','0','1067000','LUS','T0082083','E1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZHXG-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='E1D-ZHXG-30-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226130830501','2026-08-13','0.970','2026-08-13','08:30:50','PLG0083473','1062000','1062000','5000','1067000','1067000','kasir','2026-08-13 08:30:50','F22613083050');
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-13','F226130830501','2026-08-13','08:30:50','LUS','1067000','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-260813-0002','D','2026-08-13','08:30:50','kasir','PENJUALAN','F226130830501','13494314000','1067000','13495381000');
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 ('F226130831281','kasir','1',' MFE1 X KH ','TOKO','SMBK-E','E1F-ZHXG-106-0','CC X MODEL ARESO SLEP KH 14 8K ','OL','0.350','1','100.00','390000','0','0','15000','397000','0','5000','0','402000','LUS','00417525','E1F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZHXG-106-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='E1F-ZHXG-106-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226130831281','2026-08-13','0.350','2026-08-13','08:31:29','PLG0083474','397000','397000','5000','402000','402000','kasir','2026-08-13 08:31:28','F22613083128');
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-13','F226130831281','2026-08-13','08:31:29','LUS','402000','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-260813-0003','D','2026-08-13','08:31:29','kasir','PENJUALAN','F226130831281','13495381000','402000','13495783000');
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 ('F226130834071','kasir','1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZHXD-50-T','KL SIEM COBRA PITA VAR SLEP KH 42 8K ','OL','1.960','1','100.00','2166000','0','0','15000','2185000','0','10000','0','2195000','DIN','T0081888','H1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHXD-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.960',berat_jual_asli=berat_jual_asli+'1.960',stock_jual='1',berat_akhir=berat_akhir-'1.960',berat_akhir_asli=berat_akhir_asli-'1.960',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='H1E-ZHXD-50-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226130834071','2026-08-13','1.960','2026-08-13','08:34:08','PLG0083475','2185000','2185000','10000','2195000','2195000','kasir','2026-08-13 08:34:07','F22613083407');
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-13','F226130834071','2026-08-13','08:34:08','DIN','2195000','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-260813-0004','D','2026-08-13','08:34:08','kasir','PENJUALAN','F226130834071','13495783000','2195000','13497978000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2195000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226130834071' 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 ('F226130834072','kasir',' 1',' MED2 X LG ','TOKO','SMBK-D','D2E-ZGCA-204-0','LT X MODEL HURUF MATA A LG 8K ','OL','0.590','1','100.00','652000','0','0','15000','661000','0','5000','0','666000','DIN','00416290','D2E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZGCA-204-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.590',berat_jual_asli=berat_jual_asli+'0.590',stock_jual='1',berat_akhir=berat_akhir-'0.590',berat_akhir_asli=berat_akhir_asli-'0.590',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='D2E-ZGCA-204-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226130834072','2026-08-13','0.590','2026-08-13','08:34:08','PLG0083476','661000','661000','5000','666000','666000','kasir','2026-08-13 08:34:07','F22613083407');
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-13','F226130834072','2026-08-13','08:34:08','DIN','666000','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-260813-0005','D','2026-08-13','08:34:08','kasir','PENJUALAN','F226130834072','13497978000','666000','13498644000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='666000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226130834072' 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 ('F226130838031','kasir','1',' MDA1 LG ','TOKO','SMBK-A','A1D-ZEAE-34-T','AT JERSY MRICAN VAR LG 8K ','','1.010','1','100.00','1086000','0','0','15000','1096000','0','0','0','1096000','NOV','T0079460','A1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZEAE-34-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='A1D-ZEAE-34-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226130838031','2026-08-13','1.010','2026-08-13','08:38:03','PLG0083477','1096000','1096000','0','1096000','976000','kasir','2026-08-13 08:38:03','F22613083803');
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-13','F226130838031','2026-08-13','08:38:03','NOV','1096000','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-260813-0006','D','2026-08-13','08:38:03','kasir','PENJUALAN','F226130838031','13498644000','976000','13499620000','OPEN');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260813-0001','2026-08-13','2026-08-13 08:38:03','PENJUALAN : F226130838031','344345455665','BCA','120000','120000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260813-0002','D','2026-08-13','08:38:03','BCA','PENJUALAN','F226130838031','4694897888','120000','4695017888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('344345455665','HABIB');
UPDATE tt_jual_head SET dibayar_rp='976000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='120000' WHERE no_faktur_jual='F226130838031' 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 ('F226130920181','kasir','1',' MFE2 KH 14','TOKO','SMBK-E','E2F-ZHAA-128-T','CC MODEL PAKU MATA 14 KH 8K ','OL','0.380','1','100.00','424000','0','0','15000','431000','0','5000','0','436000','DIN','T0082268','E2F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZHAA-128-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='E2F-ZHAA-128-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226130920181','2026-08-13','0.380','2026-08-13','09:20:19','PLG0083478','431000','431000','5000','436000','436000','kasir','2026-08-13 09:20:18','F22613092018');
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-13','F226130920181','2026-08-13','09:20:19','DIN','436000','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-260813-0007','D','2026-08-13','09:20:19','kasir','PENJUALAN','F226130920181','13499620000','436000','13500056000');
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 ('F226131001131','kasir','1',' MEE1E KH 2','TOKO','SMBK-E','E1E-ZHXD-34-T','CC MODEL SNACK SLEP KH 20 8K ','OL','0.480','1','100.00','530000','0','0','15000','535000','0','5000','0','540000','DIN','T0081872','E1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHXD-34-T' 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-08-13' AND kode_barang='E1E-ZHXD-34-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226131001131','2026-08-13','0.480','2026-08-13','10:01:13','PLG0083479','535000','535000','5000','540000','540000','kasir','2026-08-13 10:01:13','F22613100113');
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-13','F226131001131','2026-08-13','10:01:13','DIN','540000','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-260813-0008','D','2026-08-13','10:01:13','kasir','PENJUALAN','F226131001131','13500056000','540000','13500596000');
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 ('F226131038581','kasir','1',' MED1 LG ','TOKO','SMBK-D','D1E-ZDBX-17-T','LT MODEL HATI POLOS LG 8K ','OL','0.490','1','100.00','541000','0','0','15000','546000','0','5000','0','551000','TIN','T0078752','D1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZDBX-17-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.490',berat_jual_asli=berat_jual_asli+'0.490',stock_jual='1',berat_akhir=berat_akhir-'0.490',berat_akhir_asli=berat_akhir_asli-'0.490',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='D1E-ZDBX-17-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226131038581','2026-08-13','0.490','2026-08-13','10:38:59','PLG0083480','546000','546000','5000','551000','551000','kasir','2026-08-13 10:38:58','F22613103858');
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-13','F226131038581','2026-08-13','10:38:59','TIN','551000','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-260813-0009','D','2026-08-13','10:38:59','kasir','PENJUALAN','F226131038581','13500596000','551000','13501147000');
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 ('F226131039401','kasir','1',' MEE2 KH 15','TOKO','SMBK-E','E2E-ZHAA-152-T','CC MODEL MATA SLEP VAR 15 KH 8K ','OL','0.500','1','100.00','552000','0','0','15000','558000','0','5000','0','563000','TIN','T0082292','E2E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHAA-152-T' 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-13' AND kode_barang='E2E-ZHAA-152-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226131039401','2026-08-13','0.500','2026-08-13','10:39:40','PLG0083481','558000','558000','5000','563000','563000','kasir','2026-08-13 10:39:40','F22613103940');
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-13','F226131039401','2026-08-13','10:39:40','TIN','563000','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-260813-0010','D','2026-08-13','10:39:40','kasir','PENJUALAN','F226131039401','13501147000','563000','13501710000');
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 ('F226131046431','kasir','1',' TDB1 X UB ','TOKO','TBK-B','B1TD-YLAA-11-T','GW X COR MODEL TUSUK MATA UB 17K','OL','1.150','1','100.00','2277000','0','0','15000','2304000','0','8000','0','2312000','DIN','T0075669','B1TD','0','0','-','0','1980000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1TD-YLAA-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.150',berat_jual_asli=berat_jual_asli+'1.150',stock_jual='1',berat_akhir=berat_akhir-'1.150',berat_akhir_asli=berat_akhir_asli-'1.150',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='B1TD-YLAA-11-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226131046431','2026-08-13','1.150','2026-08-13','10:46:43','PLG0083482','2304000','2304000','8000','2312000','2312000','kasir','2026-08-13 10:46:43','F22613104643');
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-13','F226131046431','2026-08-13','10:46:43','DIN','2312000','8000');
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-260813-0011','D','2026-08-13','10:46:43','kasir','PENJUALAN','F226131046431','13501710000','2312000','13504022000');
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 ('F226131047131','kasir','1',' MEF1E TD 6','TOKO','SMBK-F','F1E-ZHXC-102-T','GL OVAL C SLEP TD 60 8K ','OL','3.250','1','100.00','3591000','0','0','15000','3608000','0','16000','0','3624000','DIN','T0081831','F1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZHXC-102-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.250',berat_jual_asli=berat_jual_asli+'3.250',stock_jual='1',berat_akhir=berat_akhir-'3.250',berat_akhir_asli=berat_akhir_asli-'3.250',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='F1E-ZHXC-102-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226131047131','2026-08-13','3.250','2026-08-13','10:47:14','PLG0083483','3608000','3608000','16000','3624000','3624000','kasir','2026-08-13 10:47:13','F22613104713');
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-13','F226131047131','2026-08-13','10:47:14','DIN','3624000','16000');
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-260813-0012','D','2026-08-13','10:47:14','kasir','PENJUALAN','F226131047131','13504022000','3624000','13507646000');
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 ('F226131106591','kasir','1',' MEH1 HW 42','TOKO','SMBK-H','H1E-ZHAA-334-0','KL RANTAI HOLLOW CD VAR HW 42 8K ','OL','1.920','1','100.00','2122000','0','0','15000','2131000','0','10000','0','2141000','DIN','00418863','H1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHAA-334-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.920',berat_jual_asli=berat_jual_asli+'1.920',stock_jual='1',berat_akhir=berat_akhir-'1.920',berat_akhir_asli=berat_akhir_asli-'1.920',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='H1E-ZHAA-334-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226131106591','2026-08-13','1.920','2026-08-13','11:06:59','PLG0083484','2131000','2131000','10000','2141000','2141000','kasir','2026-08-13 11:06:59','F22613110659');
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-13','F226131106591','2026-08-13','11:06:59','DIN','2141000','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-260813-0013','D','2026-08-13','11:06:59','kasir','PENJUALAN','F226131106591','13507646000','2141000','13509787000');
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 ('F226131108031','kasir','1',' MEB1 X LG ','TOKO','SMBK-B','B1E-ZHXH-8-0','GW X MODEL HURUF MATA LG PE A 8K ','OL','0.600','1','100.00','663000','0','0','15000','669000','0','5000','0','674000','DIN','00417737','B1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZHXH-8-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-08-13' AND kode_barang='B1E-ZHXH-8-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226131108031','2026-08-13','0.600','2026-08-13','11:08:04','PLG0083485','669000','669000','5000','674000','674000','kasir','2026-08-13 11:08:03','F22613110803');
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-13','F226131108031','2026-08-13','11:08:04','DIN','674000','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-260813-0014','D','2026-08-13','11:08:04','kasir','PENJUALAN','F226131108031','13509787000','674000','13510461000');
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 ('F226131129391','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZDAF-41-T','LT SLOBOK BALOK HURUF BG Y 8K ','OL','0.460','1','100.00','513000','0','0','15000','522000','0','5000','0','527000','LUS','T0078707','D1F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZDAF-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='D1F-ZDAF-41-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226131129391','2026-08-13','0.460','2026-08-13','11:29:39','PLG0083486','522000','522000','5000','527000','527000','kasir','2026-08-13 11:29:39','F22613112939');
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-13','F226131129391','2026-08-13','11:29:39','LUS','527000','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-260813-0015','D','2026-08-13','11:29:39','kasir','PENJUALAN','F226131129391','13510461000','527000','13510988000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='527000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226131129391' 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 ('F226131129392','kasir',' 1',' MFD1F X BG','TOKO','SMBK-D','D1F-ZGXC-15-0','LT X SLOBOK HURUF BALOK BG E 8K ','OL','0.510','1','100.00','569000','0','0','15000','579000','0','5000','0','584000','LUS','00412207','D1F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGXC-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='D1F-ZGXC-15-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226131129392','2026-08-13','0.510','2026-08-13','11:29:39','PLG0083487','579000','579000','5000','584000','584000','kasir','2026-08-13 11:29:39','F22613112939');
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-13','F226131129392','2026-08-13','11:29:39','LUS','584000','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-260813-0016','D','2026-08-13','11:29:39','kasir','PENJUALAN','F226131129392','13510988000','584000','13511572000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='584000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226131129392' 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 ('F226131129393','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZGAE-20-T','LT SLOBOK BALOK HURUF BG D 8K ','OL','0.520','1','100.00','580000','0','0','15000','590000','0','5000','0','595000','LUS','T0081165','D1F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGAE-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='D1F-ZGAE-20-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226131129393','2026-08-13','0.520','2026-08-13','11:29:39','PLG0083488','590000','590000','5000','595000','595000','kasir','2026-08-13 11:29:39','F22613112939');
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-13','F226131129393','2026-08-13','11:29:39','LUS','595000','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-260813-0017','D','2026-08-13','11:29:39','kasir','PENJUALAN','F226131129393','13511572000','595000','13512167000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='595000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226131129393' 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 ('F226131129394','kasir',' 1',' MED1 LG ','TOKO','SMBK-D','D1E-ZDBB-4-T','LT SLOBOK MODEL KRAWANG VAR LG 8K ','OL','0.620','1','100.00','685000','0','0','15000','691000','0','5000','0','696000','LUS','T0078794','D1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZDBB-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.620',berat_jual_asli=berat_jual_asli+'0.620',stock_jual='1',berat_akhir=berat_akhir-'0.620',berat_akhir_asli=berat_akhir_asli-'0.620',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='D1E-ZDBB-4-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226131129394','2026-08-13','0.620','2026-08-13','11:29:39','PLG0083489','691000','691000','5000','696000','696000','kasir','2026-08-13 11:29:39','F22613112939');
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-13','F226131129394','2026-08-13','11:29:39','LUS','696000','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-260813-0018','D','2026-08-13','11:29:39','kasir','PENJUALAN','F226131129394','13512167000','696000','13512863000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='696000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226131129394' 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 ('F226131129395','kasir',' 1',' MEF1E TD 5','TOKO','SMBK-F','F1E-ZFXD-107-T','GL OVAL C SLEP TD 58 8K ','OL','3.250','1','100.00','3591000','0','0','15000','3608000','0','16000','0','3624000','LUS','T0080272','F1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFXD-107-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.250',berat_jual_asli=berat_jual_asli+'3.250',stock_jual='1',berat_akhir=berat_akhir-'3.250',berat_akhir_asli=berat_akhir_asli-'3.250',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='F1E-ZFXD-107-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226131129395','2026-08-13','3.250','2026-08-13','11:29:39','PLG0083490','3608000','3608000','16000','3624000','3624000','kasir','2026-08-13 11:29:39','F22613112939');
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-13','F226131129395','2026-08-13','11:29:39','LUS','3624000','16000');
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-260813-0019','D','2026-08-13','11:29:39','kasir','PENJUALAN','F226131129395','13512863000','3624000','13516487000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3624000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226131129395' 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 ('F226131130581','kasir','1',' MEE2 X CM ','TOKO','SMBK-E','E2E-ZHXH-342-0','CC X MODEL MATA CM 12 8K ','OL','0.750','1','100.00','829000','0','0','15000','836000','0','5000','0','841000','LUS','00418072','E2E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHXH-342-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='E2E-ZHXH-342-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226131130581','2026-08-13','0.750','2026-08-13','11:30:59','PLG0083491','836000','836000','5000','841000','841000','kasir','2026-08-13 11:30:58','F22613113058');
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-13','F226131130581','2026-08-13','11:30:59','LUS','841000','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-260813-0020','D','2026-08-13','11:30:59','kasir','PENJUALAN','F226131130581','13516487000','841000','13517328000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='841000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226131130581' 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 ('F226131130582','kasir',' 1',' MEE2 X CM ','TOKO','SMBK-E','E2E-ZHXH-357-0','CC X MODEL MATA CM 12 8K ','OL','0.750','1','100.00','829000','0','0','15000','836000','0','5000','0','841000','LUS','00418087','E2E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHXH-357-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='E2E-ZHXH-357-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226131130582','2026-08-13','0.750','2026-08-13','11:30:59','PLG0083492','836000','836000','5000','841000','841000','kasir','2026-08-13 11:30:58','F22613113058');
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-13','F226131130582','2026-08-13','11:30:59','LUS','841000','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-260813-0021','D','2026-08-13','11:30:59','kasir','PENJUALAN','F226131130582','13517328000','841000','13518169000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='841000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226131130582' 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 ('F226131145591','kasir','1',' MDA1D X UB','TOKO','SMBK-A','A1D-ZHXG-41-0','AT X HUGGIES ARESO SLEP VAR UB 8K ','OL','1.330','1','100.00','1430000','0','0','15000','1456000','0','7000','0','1463000','LUS','00417460','A1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZHXG-41-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.330',berat_jual_asli=berat_jual_asli+'1.330',stock_jual='1',berat_akhir=berat_akhir-'1.330',berat_akhir_asli=berat_akhir_asli-'1.330',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='A1D-ZHXG-41-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226131145591','2026-08-13','1.330','2026-08-13','11:46:00','PLG0083493','1456000','1456000','7000','1463000','1463000','kasir','2026-08-13 11:45:59','F22613114559');
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-13','F226131145591','2026-08-13','11:46:00','LUS','1463000','7000');
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-260813-0022','D','2026-08-13','11:46:00','kasir','PENJUALAN','F226131145591','13518169000','1463000','13519632000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1463000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226131145591' 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 ('F226131145592','kasir',' 1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZHXE-96-T','KL SIEM COBRA KH 42 8K ','OL','1.280','1','100.00','1414000','0','0','15000','1429000','0','6000','0','1435000','LUS','T0082009','H1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHXE-96-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.280',berat_jual_asli=berat_jual_asli+'1.280',stock_jual='1',berat_akhir=berat_akhir-'1.280',berat_akhir_asli=berat_akhir_asli-'1.280',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='H1E-ZHXE-96-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226131145592','2026-08-13','1.280','2026-08-13','11:46:00','PLG0083494','1429000','1429000','6000','1435000','1435000','kasir','2026-08-13 11:45:59','F22613114559');
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-13','F226131145592','2026-08-13','11:46:00','LUS','1435000','6000');
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-260813-0023','D','2026-08-13','11:46:00','kasir','PENJUALAN','F226131145592','13519632000','1435000','13521067000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1435000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226131145592' 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 ('F226131145593','kasir',' 1',' MEH1 10K H','TOKO','SMBK-H','H1E-ZHAA-327-0','KL SANTA HATI PASIR VAR HW 42 8K ','OL','1.890','1','100.00','2088000','0','0','15000','2107000','0','10000','0','2117000','LUS','00418856','H1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHAA-327-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.890',berat_jual_asli=berat_jual_asli+'1.890',stock_jual='1',berat_akhir=berat_akhir-'1.890',berat_akhir_asli=berat_akhir_asli-'1.890',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='H1E-ZHAA-327-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226131145593','2026-08-13','1.890','2026-08-13','11:46:00','PLG0083495','2107000','2107000','10000','2117000','2117000','kasir','2026-08-13 11:45:59','F22613114559');
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-13','F226131145593','2026-08-13','11:46:00','LUS','2117000','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-260813-0024','D','2026-08-13','11:46:00','kasir','PENJUALAN','F226131145593','13521067000','2117000','13523184000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2117000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226131145593' 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 ('F226131145594','kasir',' 1',' MEH1 HW 42','TOKO','SMBK-H','H1E-ZHAA-333-0','KL RANTAI HOLLOW CD VAR HW 42 8K ','OL','1.910','1','100.00','2111000','0','0','15000','2130000','0','10000','0','2140000','LUS','00418862','H1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHAA-333-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.910',berat_jual_asli=berat_jual_asli+'1.910',stock_jual='1',berat_akhir=berat_akhir-'1.910',berat_akhir_asli=berat_akhir_asli-'1.910',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='H1E-ZHAA-333-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226131145594','2026-08-13','1.910','2026-08-13','11:46:00','PLG0083496','2130000','2130000','10000','2140000','2140000','kasir','2026-08-13 11:45:59','F22613114559');
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-13','F226131145594','2026-08-13','11:46:00','LUS','2140000','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-260813-0025','D','2026-08-13','11:46:00','kasir','PENJUALAN','F226131145594','13523184000','2140000','13525324000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2140000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226131145594' 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 ('F226131149301','kasir','1',' TDE2 X HK ','TOKO','TBK-E','E2TD-YLAA-40-T','CC X COR MODEL MATA 12 HK 17K ','OL','1.510','1','100.00','2990000','0','0','15000','3024000','0','11000','0','3035000','TIN','T0075698','E2TD','0','0','-','0','1980000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YLAA-40-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='E2TD-YLAA-40-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226131149301','2026-08-13','1.510','2026-08-13','11:49:30','PLG0083497','3024000','3024000','11000','3035000','3035000','kasir','2026-08-13 11:49:30','F22613114930');
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-13','F226131149301','2026-08-13','11:49:30','TIN','3035000','11000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260813-0026','D','2026-08-13','11:49:30','kasir','PENJUALAN','F226131149301','13525324000','3035000','13528359000');
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 ('F226131209221','kasir','1',' MEH1E HW 4','TOKO','SMBK-H','H1E-ZHXG-64-T','KL SANTA HATI ARESO SLEP HW 42 8K ','ol','1.870','1','100.00','2066000','0','0','15000','2076000','0','9000','0','2085000','LUS','T0082117','H1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHXG-64-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.870',berat_jual_asli=berat_jual_asli+'1.870',stock_jual='1',berat_akhir=berat_akhir-'1.870',berat_akhir_asli=berat_akhir_asli-'1.870',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='H1E-ZHXG-64-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226131209221','2026-08-13','1.870','2026-08-13','12:09:22','PLG0083498','2076000','2076000','9000','2085000','2085000','kasir','2026-08-13 12:09:22','F22613120922');
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-13','F226131209221','2026-08-13','12:09:22','LUS','2085000','9000');
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-260813-0027','D','2026-08-13','12:09:22','kasir','PENJUALAN','F226131209221','13528359000','2085000','13530444000');
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 ('F226131256161','kasir','1',' MEA1 CM ','TOKO','SMBK-A','A1E-ZDBC-9-T','AT JERSY POLOS CM 8K ','ol','0.550','1','100.00','608000','0','0','15000','609000','0','5000','0','614000','DIN','T0078890','A1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZDBC-9-T' 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-08-13' AND kode_barang='A1E-ZDBC-9-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226131256161','2026-08-13','0.550','2026-08-13','12:56:16','PLG0083499','609000','609000','5000','614000','614000','kasir','2026-08-13 12:56:16','F22613125616');
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-13','F226131256161','2026-08-13','12:56:16','DIN','614000','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-260813-0028','D','2026-08-13','12:56:16','kasir','PENJUALAN','F226131256161','13530444000','614000','13531058000');
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 ('F226130109071','kasir','1',' MDE1D CM 1','TOKO','SMBK-E','E1E-ZHXG-27-T','CC VELG POLOS SLEP CM 14 8K','ol','0.960','1','100.00','1061000','0','0','15000','1051000','0','5000','0','1056000','LUS','T0082080','E1E','0','0','-','1','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZHXG-27-T' 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-13' AND kode_barang='E1E-ZHXG-27-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226130109071','2026-08-13','0.960','2026-08-13','13:09:07','PLG0083500','1051000','1051000','5000','1056000','1056000','kasir','2026-08-13 13:09:07','F22613010907');
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-13','F226130109071','2026-08-13','13:09:07','LUS','1056000','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-260813-0029','D','2026-08-13','13:09:07','kasir','PENJUALAN','F226130109071','13531058000','1056000','13532114000');
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 ('F226130120151','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZHAA-57-T','LT SLOBOK HURUF M BG 8K ','OL','0.800','1','100.00','892000','0','0','15000','898000','0','5000','0','903000','DIN','T0082197','D1F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZHAA-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.800',berat_jual_asli=berat_jual_asli+'0.800',stock_jual='1',berat_akhir=berat_akhir-'0.800',berat_akhir_asli=berat_akhir_asli-'0.800',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='D1F-ZHAA-57-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226130120151','2026-08-13','0.800','2026-08-13','13:20:15','PLG0083501','898000','898000','5000','903000','903000','kasir','2026-08-13 13:20:15','F22613012015');
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-13','F226130120151','2026-08-13','13:20:15','DIN','903000','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-260813-0030','D','2026-08-13','13:20:15','kasir','PENJUALAN','F226130120151','13532114000','903000','13533017000');
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 ('F226130140541','kasir','1',' TEF3 X LT ','TOKO','TBK-F','F3TE-ZGBI-21-T','GL X RANTAI P4 SLEP LT 17K ','','3.060','1','100.00','6120000','0','0','15000','6120000','0','0','0','6120000','TIN','T0081680','F3TE','0','0','-','0','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3TE-ZGBI-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.060',berat_jual_asli=berat_jual_asli+'3.060',stock_jual='1',berat_akhir=berat_akhir-'3.060',berat_akhir_asli=berat_akhir_asli-'3.060',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='F3TE-ZGBI-21-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226130140541','2026-08-13','3.060','2026-08-13','13:40:55','PLG0083502','6120000','6120000','0','6120000','6120000','kasir','2026-08-13 13:40:54','F22613014054');
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-13','F226130140541','2026-08-13','13:40:55','TIN','6120000','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-260813-0031','D','2026-08-13','13:40:55','kasir','PENJUALAN','F226130140541','13533017000','6120000','13539137000');
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 ('F226130157041','kasir','1',' MGA1G CM ','TOKO','SMBK-A','A1G-ZHXG-10-T','AT TINDIK BABY CM 8K ','OL','0.260','1','100.00','295000','0','0','15000','297000','0','5000','0','302000','TIN','T0082063','A1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZHXG-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='A1G-ZHXG-10-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226130157041','2026-08-13','0.260','2026-08-13','13:57:04','PLG0083503','297000','297000','5000','302000','302000','kasir','2026-08-13 13:57:04','F22613015704');
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-13','F226130157041','2026-08-13','13:57:04','TIN','302000','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-260813-0032','D','2026-08-13','13:57:04','kasir','PENJUALAN','F226130157041','13539137000','302000','13539439000');
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 ('F226130157571','kasir','1',' MGA1G CM ','TOKO','SMBK-A','A1G-ZHXG-8-T','AT TINDIK BABY CM 8K ','OL','0.260','1','100.00','295000','0','0','15000','297000','0','5000','0','302000','TIN','T0082061','A1G','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZHXG-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='A1G-ZHXG-8-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226130157571','2026-08-13','0.260','2026-08-13','13:57:57','PLG0083504','297000','297000','5000','302000','302000','kasir','2026-08-13 13:57:57','F22613015757');
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-13','F226130157571','2026-08-13','13:57:57','TIN','302000','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-260813-0033','D','2026-08-13','13:57:57','kasir','PENJUALAN','F226130157571','13539439000','302000','13539741000');
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 ('F226130211381','kasir','1',' MED2 X LG ','TOKO','SMBK-D','D2E-ZGCA-206-0','LT X MODEL MATA LG 8K ','OL','0.530','1','100.00','586000','0','0','15000','591000','0','5000','0','596000','LUS','00416292','D2E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZGCA-206-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-13' AND kode_barang='D2E-ZGCA-206-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226130211381','2026-08-13','0.530','2026-08-13','14:11:39','PLG0083505','591000','591000','5000','596000','596000','kasir','2026-08-13 14:11:38','F22613021138');
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-13','F226130211381','2026-08-13','14:11:39','LUS','596000','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-260813-0034','D','2026-08-13','14:11:39','kasir','PENJUALAN','F226130211381','13539741000','596000','13540337000');
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 ('F226130212091','kasir','1',' MFE2 KH 17','TOKO','SMBK-E','E2F-ZHAA-129-T','CC MODEL PAKU MATA 17 KH 8K ','OL','0.400','1','100.00','446000','0','0','15000','455000','0','5000','0','460000','LUS','T0082269','E2F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2F-ZHAA-129-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='E2F-ZHAA-129-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226130212091','2026-08-13','0.400','2026-08-13','14:12:09','PLG0083506','455000','455000','5000','460000','460000','kasir','2026-08-13 14:12:09','F22613021209');
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-13','F226130212091','2026-08-13','14:12:09','LUS','460000','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-260813-0035','D','2026-08-13','14:12:09','kasir','PENJUALAN','F226130212091','13540337000','460000','13540797000');
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 ('F226130224251','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-ZEAE-82-T','AT KLIP BANGKOK SLEP LG 8K ','OL','0.570','1','100.00','630000','0','0','15000','636000','0','5000','0','641000','LUS','T0079508','A1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZEAE-82-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-13' AND kode_barang='A1E-ZEAE-82-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226130224251','2026-08-13','0.570','2026-08-13','14:24:26','PLG0083507','636000','636000','5000','641000','641000','kasir','2026-08-13 14:24:25','F22613022425');
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-13','F226130224251','2026-08-13','14:24:26','LUS','641000','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-260813-0036','D','2026-08-13','14:24:26','kasir','PENJUALAN','F226130224251','13540797000','641000','13541438000');
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 ('F226130226221','kasir','1',' TDA1 HW ','TOKO','TBK-A','A1TD-ZGAG-32-T','AT MODEL ITALY VAR SLEP HW 17K ','OL','1.030','1','100.00','2039000','0','0','15000','2043000','0','7000','0','2050000','TIN','T0081255','A1TD','0','0','-','0','1980000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TD-ZGAG-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='A1TD-ZGAG-32-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226130226221','2026-08-13','1.030','2026-08-13','14:26:23','PLG0083508','2043000','2043000','7000','2050000','0','kasir','2026-08-13 14:26:22','F22613022622');
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-13','F226130226221','2026-08-13','14:26:23','TIN','2050000','7000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260813-0002','2026-08-13','2026-08-13 14:26:22','PENJUALAN : F226130226221','85768956767','BCA','2050000','2050000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260813-0003','D','2026-08-13','14:26:23','BCA','PENJUALAN','F226130226221','4695017888','2050000','4697067888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('85768956767','RETNO');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2050000' WHERE no_faktur_jual='F226130226221' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226130109071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226130109071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226130109071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226130120151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226130120151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226130120151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226130140541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226130140541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226130140541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226130157041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226130157041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226130157041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226130157571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226130157571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226130157571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226130211381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226130211381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226130211381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226130212091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226130212091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226130212091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226130224251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226130224251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226130224251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226130226221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226130226221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226130226221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226130830501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226130830501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226130830501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226130831281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226130831281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226130831281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226130834071' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226130834071' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226130834071';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226130834072' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226130834072' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226130834072';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226130838031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226130838031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226130838031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226130920181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226130920181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226130920181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131001131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131001131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131001131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131038581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131038581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131038581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131039401' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131039401' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131039401';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131046431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131046431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131046431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131047131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131047131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131047131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131106591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131106591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131106591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131108031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131108031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131108031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131129391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131129391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131129391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131129392' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131129392' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131129392';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131129393' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131129393' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131129393';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131129394' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131129394' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131129394';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131129395' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131129395' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131129395';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131130581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131130581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131130581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131130582' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131130582' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131130582';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131145591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131145591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131145591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131145592' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131145592' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131145592';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131145593' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131145593' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131145593';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131145594' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131145594' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131145594';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131149301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131149301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131149301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131209221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131209221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131209221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226131256161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226131256161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226131256161';
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 ('F226130233531','kasir','1',' MDA1D 10K ','TOKO','SMBK-A','A1D-ZHXD-46-T','AT DAISY MATA SLEP UB 8K ','','1.060','1','100.00','1139000','0','0','15000','1136000','0','10000','0','1146000','RHM','T0081884','A1D','0','0','-','1','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZHXD-46-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='A1D-ZHXD-46-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226130233531','2026-08-13','1.060','2026-08-13','14:33:54','PLG0083509','1136000','1136000','10000','1146000','0','kasir','2026-08-13 14:33:53','F22613023353');
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-13','F226130233531','2026-08-13','14:33:54','RHM','1146000','10000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260813-0003','2026-08-13','2026-08-13 14:33:53','PENJUALAN : F226130233531','65365368368368368','BCA','1146000','1146000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260813-0004','D','2026-08-13','14:33:54','BCA','PENJUALAN','F226130233531','4697067888','1146000','4698213888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('65365368368368368','HHHH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1146000' WHERE no_faktur_jual='F226130233531' 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 ('F226130235041','kasir','1',' MEH1E HW 4','TOKO','SMBK-H','H1E-ZHXG-63-T','KL SANTA BOLA ARESO SLEP HW 42 8K ','','1.940','1','100.00','2144000','0','0','15000','2118000','0','0','0','2118000','RHM','T0082116','H1E','0','0','-','1','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZHXG-63-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.940',berat_jual_asli=berat_jual_asli+'1.940',stock_jual='1',berat_akhir=berat_akhir-'1.940',berat_akhir_asli=berat_akhir_asli-'1.940',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='H1E-ZHXG-63-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226130235041','2026-08-13','1.940','2026-08-13','14:35:05','PLG0083510','2118000','2118000','0','2118000','0','kasir','2026-08-13 14:35:04','F22613023504');
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-13','F226130235041','2026-08-13','14:35:05','RHM','2118000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260813-0004','2026-08-13','2026-08-13 14:35:04','PENJUALAN : F226130235041','55468536368368386','BCA','2118000','2118000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260813-0005','D','2026-08-13','14:35:05','BCA','PENJUALAN','F226130235041','4698213888','2118000','4700331888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('55468536368368386','HHHH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2118000' WHERE no_faktur_jual='F226130235041' 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 ('F226130236051','kasir','1',' TEH1 KH 42','TOKO','TBK-H','H1TE-ZGAG-42-T','KL NORI KH 42 17K ','OL','2.080','1','100.00','4160000','0','0','15000','4166000','0','15000','0','4181000','TIN','T0081265','H1TE','0','0','-','0','2000000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TE-ZGAG-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='H1TE-ZGAG-42-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-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 ('F226130236051','2026-08-13','2.080','2026-08-13','14:36:05','PLG0083511','4166000','4166000','15000','4181000','0','kasir','2026-08-13 14:36:05','F22613023605');
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-13','F226130236051','2026-08-13','14:36:05','TIN','4181000','15000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260813-0005','2026-08-13','2026-08-13 14:36:05','PENJUALAN : F226130236051','76477677676','BCA','4181000','4181000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260813-0006','D','2026-08-13','14:36:05','BCA','PENJUALAN','F226130236051','4700331888','4181000','4704512888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('76477677676','RETNO');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='4181000' WHERE no_faktur_jual='F226130236051' 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 ('F226130236441','kasir','1',' MDD2D X LG','TOKO','SMBK-D','D2D-ZDAH-4-0','LT X MODEL HURUF MATA LG R 8K ','OL','1.080','1','100.00','1161000','0','0','15000','1164000','0','5000','0','1169000','TIN','00399705','D2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2D-ZDAH-4-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.080',berat_jual_asli=berat_jual_asli+'1.080',stock_jual='1',berat_akhir=berat_akhir-'1.080',berat_akhir_asli=berat_akhir_asli-'1.080',stock_akhir='0' WHERE tanggal='2026-08-13' AND kode_barang='D2D-ZDAH-4-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226130236441','2026-08-13','1.080','2026-08-13','14:36:45','PLG0083512','1164000','1164000','5000','1169000','1169000','kasir','2026-08-13 14:36:44','F22613023644');
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-13','F226130236441','2026-08-13','14:36:45','TIN','1169000','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-260813-0037','D','2026-08-13','14:36:45','kasir','PENJUALAN','F226130236441','13541438000','1169000','13542607000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226130233531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226130233531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226130233531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226130235041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226130235041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226130235041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226130236051' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226130236051' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226130236051';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226130236441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226130236441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226130236441';
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 ('F226130316151','kasir','1',' MEA1E X BW','TOKO','SMBK-A','A1E-ZHXG-19-0','AT X ITALY SLEP VAR BW 8K ','','0.530','1','100.00','586000','0','0','15000','586000','0','0','0','586000','LUS','00417438','A1E','0','0','-','0','1105000');
UPDATE tm_barang SET tgl_last_jual='2026-08-13', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZHXG-19-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-13' AND kode_barang='A1E-ZHXG-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-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 ('F226130316151','2026-08-13','0.530','2026-08-13','15:16:16','PLG0083513','586000','586000','0','586000','586000','kasir','2026-08-13 15:16:15','F22613031615');
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-13','F226130316151','2026-08-13','15:16:16','LUS','586000','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-260813-0038','D','2026-08-13','15:16:16','kasir','PENJUALAN','F226130316151','13542607000','586000','13543193000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226130316151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226130316151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226130316151';
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-00005625','X-00005625','AT KLIP C SLEP HW 8K','GR','---','A1D','BELI','BELI001','976000','2026-08-13','1.000','1','admin','2026-08-13 15:24:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1D','X-00005625','X-00005625');
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-260813-0001','F226121223291','NOV','1','BELI','BELI001','A1D', 'X-00005625', 'AT KLIP C SLEP HW 8K','1.000','1.000','100.00','1085000','976000','976000','1075000','1','976000','976000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-13' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260813-0001','2026-08-13','2026-08-13','15:24:28','NOV','---','1.000','976000','976000','976000','976000','976000','admin','2026-08-13 15:24:28','FB-260813-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260813-0001','ANI PUJILESTARI','','','','','admin','2026-08-13 15:24:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-13' 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-260813-0039','K','2026-08-13','15:24:28','admin','PEMBELIAN UMUM','FB-260813-0001','13543193000','976000','13542217000');
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-00005626','X-00005626','CC PIPA MODEL MATA VAR HTM 16 8K','GR','---','E1E','BELI','BELI001','398000','2026-08-13','0.450','1','admin','2026-08-13 15:24:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00005626','X-00005626');
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-260813-0002','F226210850042','NOV','2','BELI','BELI001','E1E', 'X-00005626', 'CC PIPA MODEL MATA VAR HTM 16 8K','0.530','0.450','100.00','640000','398000','884444','1105000','1','398000','398000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.450',berat_beli_asli=berat_beli_asli+'0.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.450',berat_akhir_asli=berat_akhir_asli+'0.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-13' 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-260813-0002','2026-08-13','2026-08-13','15:24:28','NOV','---','0.450','398000','398000','398000','398000','398000','admin','2026-08-13 15:24:28','FB-260813-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260813-0002','DIRA','PULUNG','','','','admin','2026-08-13 15:24:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-13' 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-260813-0040','K','2026-08-13','15:24:28','admin','PEMBELIAN UMUM','FB-260813-0002','13542217000','398000','13541819000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260813-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260813-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260813-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260813-0002';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-14','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-14';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-13';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-13';
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-13' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-13';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-13';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-13';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-13';
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-14' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-13' 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-260814-0001','D','2026-08-14','16:04:04','SYSTEM','SALDO AWAL','SALDO AWAL','0','13541819000','13541819000');
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-260814-0001','D','2026-08-14','16:04:04','BCA','SALDO AWAL','SALDO AWAL','0','4704512888','4704512888');
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-260814-0001','D','2026-08-14','16:04:04','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-260814-0001','D','2026-08-14','16:04:04','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260814-0001','D','2026-08-14','16:04:04','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
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-260814-0001','D','2026-08-14','16:04:04','','SALDO AWAL','SALDO AWAL','0','3346000','3346000');
UPDATE tp_system SET tgl_system='2026-08-14';