INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-11','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-10';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-10';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-10';
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-05-10' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-10';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-10';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-10';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-10';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-11' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-10' 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-260511-0001','D','2026-05-11','08:10:35','SYSTEM','SALDO AWAL','SALDO AWAL','0','9419656000','9419656000');
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-260511-0001','D','2026-05-11','08:10:35','BCA','SALDO AWAL','SALDO AWAL','0','4409248888','4409248888');
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-260511-0001','D','2026-05-11','08:10:35','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-260511-0001','D','2026-05-11','08:10:35','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-260511-0001','D','2026-05-11','08:10:35','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-260511-0001','D','2026-05-11','08:10:35','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2026-05-11';
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 ('F226110838261','kasir','1',' MEH1 X KH ','TOKO','SMBK-H','H1E-YFAC-31-0','KL X CASTELI UB KH 42 8K ','','3.030','1','100.00','3424000','0','0','15000','3424000','0','0','0','3424000','RHM','00357146','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YFAC-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.030',berat_jual_asli=berat_jual_asli+'3.030',stock_jual='1',berat_akhir=berat_akhir-'3.030',berat_akhir_asli=berat_akhir_asli-'3.030',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='H1E-YFAC-31-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 ('F226110838261','2026-05-11','3.030','2026-05-11','08:38:27','PLG0079860','3424000','3424000','0','3424000','3424000','kasir','2026-05-11 08:38:26','F22611083826');
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-05-11','F226110838261','2026-05-11','08:38:27','RHM','3424000','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-260511-0002','D','2026-05-11','08:38:27','kasir','PENJUALAN','F226110838261','9419656000','3424000','9423080000');
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 ('F226110856121','kasir','1',' MHS1 LG ','TOKO','SMBK-S','S1G-ZDBB-14-T','AS EXTENSION LG 8K ','OLS SX85','0.200','1','100.00','234000','0','0','15000','241000','0','33000','0','274000','TIN','T0078804','S1G','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZDBB-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='S1G-ZDBB-14-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226110856121','2026-05-11','0.200','2026-05-11','08:56:13','PLG0079861','241000','241000','33000','274000','274000','kasir','2026-05-11 08:56:12','F22611085612');
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-05-11','F226110856121','2026-05-11','08:56:13','TIN','274000','33000');
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-260511-0003','D','2026-05-11','08:56:13','kasir','PENJUALAN','F226110856121','9423080000','274000','9423354000');
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 ('F226110857201','kasir','1',' MDA1D X UB','TOKO','SMBK-A','A1D-ZDAX-102-0','AT X HUGGIES HATI VAR UB 8K ','OLS QUMQ','1.000','1','100.00','1110000','0','0','15000','1145000','0','75000','0','1220000','TIN','00398872','A1D','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZDAX-102-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='A1D-ZDAX-102-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 ('F226110857201','2026-05-11','1.000','2026-05-11','08:57:20','PLG0079862','1145000','1145000','75000','1220000','1220000','kasir','2026-05-11 08:57:20','F22611085720');
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-05-11','F226110857201','2026-05-11','08:57:20','TIN','1220000','75000');
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-260511-0004','D','2026-05-11','08:57:20','kasir','PENJUALAN','F226110857201','9423354000','1220000','9424574000');
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 ('F226110953491','kasir','1',' TDE1 CM 18','TOKO','TBK-E','E1TD-ZDXF-15-T','CC VELG POLOS CM 18 17K ','','1.060','1','100.00','2141000','0','0','15000','2141000','0','0','0','2141000','NS','T0078477','E1TD','0','0','-','0','2020000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-ZDXF-15-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-05-11' AND kode_barang='E1TD-ZDXF-15-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 ('F226110953491','2026-05-11','1.060','2026-05-11','09:53:50','PLG0079863','2141000','2141000','0','2141000','2141000','kasir','2026-05-11 09:53:49','F22611095349');
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-05-11','F226110953491','2026-05-11','09:53:50','NS','2141000','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-260511-0005','D','2026-05-11','09:53:50','kasir','PENJUALAN','F226110953491','9424574000','2141000','9426715000');
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 ('F226111005111','kasir','1',' MEB1 LG ','TOKO','SMBK-B','B1E-ZDAC-42-T','GW TRIXIE PANJANG MODEL MATA LG 8K ','OL','0.550','1','100.00','621000','0','0','15000','630000','0','5000','0','635000','RTA','T0078661','B1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZDAC-42-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-05-11' AND kode_barang='B1E-ZDAC-42-T' 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 ('F226111005111','2026-05-11','0.550','2026-05-11','10:05:12','PLG0079864','630000','630000','5000','635000','635000','kasir','2026-05-11 10:05:11','F22611100511');
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-05-11','F226111005111','2026-05-11','10:05:12','RTA','635000','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-260511-0006','D','2026-05-11','10:05:12','kasir','PENJUALAN','F226111005111','9426715000','635000','9427350000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='635000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111005111' 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 ('F226111005112','kasir',' 1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZEXA-22-T','LT SLOBOK MICKEY ARESO VAR LG 8K ','OL','0.310','1','100.00','363000','0','0','15000','367000','0','5000','0','372000','RTA','T0079134','D1G','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZEXA-22-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='D1G-ZEXA-22-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 ('F226111005112','2026-05-11','0.310','2026-05-11','10:05:12','PLG0079865','367000','367000','5000','372000','372000','kasir','2026-05-11 10:05:11','F22611100511');
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-05-11','F226111005112','2026-05-11','10:05:12','RTA','372000','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-260511-0007','D','2026-05-11','10:05:12','kasir','PENJUALAN','F226111005112','9427350000','372000','9427722000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='372000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111005112' 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 ('F226111005113','kasir',' 1',' MFD1F X LG','TOKO','SMBK-D','D1F-ZDBG-57-0','LT X SLOBOK KUPU SLEP LG 8K ','OL','0.320','1','100.00','368000','0','0','15000','373000','0','5000','0','378000','RTA','00401300','D1F','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZDBG-57-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.320',berat_jual_asli=berat_jual_asli+'0.320',stock_jual='1',berat_akhir=berat_akhir-'0.320',berat_akhir_asli=berat_akhir_asli-'0.320',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='D1F-ZDBG-57-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 ('F226111005113','2026-05-11','0.320','2026-05-11','10:05:12','PLG0079866','373000','373000','5000','378000','378000','kasir','2026-05-11 10:05:11','F22611100511');
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-05-11','F226111005113','2026-05-11','10:05:12','RTA','378000','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-260511-0008','D','2026-05-11','10:05:12','kasir','PENJUALAN','F226111005113','9427722000','378000','9428100000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='378000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111005113' 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 ('F226111005114','kasir',' 1',' MEE1 LG 22','TOKO','SMBK-E','E1E-ZEXH-47-T','CC BANGKOK SLEP LG 22 8K ','OL','0.560','1','100.00','633000','0','0','15000','641000','0','5000','0','646000','RTA','T0079346','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXH-47-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='E1E-ZEXH-47-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 ('F226111005114','2026-05-11','0.560','2026-05-11','10:05:12','PLG0079867','641000','641000','5000','646000','646000','kasir','2026-05-11 10:05:11','F22611100511');
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-05-11','F226111005114','2026-05-11','10:05:12','RTA','646000','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-260511-0009','D','2026-05-11','10:05:12','kasir','PENJUALAN','F226111005114','9428100000','646000','9428746000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='646000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111005114' 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 ('F226111005115','kasir',' 1',' MDE1 X CM ','TOKO','SMBK-E','E1D-ZDAX-347-0','CC X VELG C SLEP CM 18 8K ','OL','1.020','1','100.00','1132000','0','0','15000','1143000','0','5000','0','1148000','RTA','00399117','E1D','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDAX-347-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='E1D-ZDAX-347-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 ('F226111005115','2026-05-11','1.020','2026-05-11','10:05:12','PLG0079868','1143000','1143000','5000','1148000','1148000','kasir','2026-05-11 10:05:11','F22611100511');
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-05-11','F226111005115','2026-05-11','10:05:12','RTA','1148000','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-260511-0010','D','2026-05-11','10:05:12','kasir','PENJUALAN','F226111005115','9428746000','1148000','9429894000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1148000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111005115' 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 ('F226111005116','kasir',' 1',' MDE1 CM 14','TOKO','SMBK-E','E1D-ZDXG-30-T','CC MODEL C CM 14 8K ','OL','1.050','1','100.00','1165000','0','0','15000','1176000','0','5000','0','1181000','RTA','T0078570','E1D','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDXG-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='E1D-ZDXG-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 ('F226111005116','2026-05-11','1.050','2026-05-11','10:05:12','PLG0079869','1176000','1176000','5000','1181000','1181000','kasir','2026-05-11 10:05:11','F22611100511');
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-05-11','F226111005116','2026-05-11','10:05:12','RTA','1181000','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-260511-0011','D','2026-05-11','10:05:12','kasir','PENJUALAN','F226111005116','9429894000','1181000','9431075000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1181000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111005116' 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 ('F226111005117','kasir',' 1',' MDE1 CM 22','TOKO','SMBK-E','E1D-ZDBC-40-T','CC MODEL C CM 22 8K ','OL','1.060','1','100.00','1177000','0','0','15000','1188000','0','5000','0','1193000','RTA','T0078921','E1D','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDBC-40-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-05-11' AND kode_barang='E1D-ZDBC-40-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 ('F226111005117','2026-05-11','1.060','2026-05-11','10:05:12','PLG0079870','1188000','1188000','5000','1193000','1193000','kasir','2026-05-11 10:05:11','F22611100511');
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-05-11','F226111005117','2026-05-11','10:05:12','RTA','1193000','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-260511-0012','D','2026-05-11','10:05:12','kasir','PENJUALAN','F226111005117','9431075000','1193000','9432268000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1193000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111005117' 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 ('F226111005118','kasir',' 1',' MDE1 5K CM','TOKO','SMBK-E','E1D-ZDBC-43-T','CC BANGKOK SLEP VAR CM 22 8K ','OL','1.120','1','100.00','1243000','0','0','15000','1254000','0','6000','0','1260000','RTA','T0078924','E1D','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDBC-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.120',berat_jual_asli=berat_jual_asli+'1.120',stock_jual='1',berat_akhir=berat_akhir-'1.120',berat_akhir_asli=berat_akhir_asli-'1.120',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='E1D-ZDBC-43-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 ('F226111005118','2026-05-11','1.120','2026-05-11','10:05:12','PLG0079871','1254000','1254000','6000','1260000','1260000','kasir','2026-05-11 10:05:11','F22611100511');
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-05-11','F226111005118','2026-05-11','10:05:12','RTA','1260000','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-260511-0013','D','2026-05-11','10:05:12','kasir','PENJUALAN','F226111005118','9432268000','1260000','9433528000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1260000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111005118' 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 ('F226111006431','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZEXG-28-T','GL KOREA UB 8K ','OL','0.870','1','100.00','983000','0','0','15000','996000','0','5000','0','1001000','RTA','T0079293','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXG-28-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.870',berat_jual_asli=berat_jual_asli+'0.870',stock_jual='1',berat_akhir=berat_akhir-'0.870',berat_akhir_asli=berat_akhir_asli-'0.870',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='F3E-ZEXG-28-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 ('F226111006431','2026-05-11','0.870','2026-05-11','10:06:44','PLG0079872','996000','996000','5000','1001000','1001000','kasir','2026-05-11 10:06:43','F22611100643');
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-05-11','F226111006431','2026-05-11','10:06:44','RTA','1001000','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-260511-0014','D','2026-05-11','10:06:44','kasir','PENJUALAN','F226111006431','9433528000','1001000','9434529000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1001000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111006431' 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 ('F226111006432','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZEXF-10-T','GL SANTA SERUT KUPU MATA VAR UB 8K ','OL','1.470','1','100.00','1661000','0','0','15000','1676000','0','7000','0','1683000','RTA','T0079171','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXF-10-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.470',berat_jual_asli=berat_jual_asli+'1.470',stock_jual='1',berat_akhir=berat_akhir-'1.470',berat_akhir_asli=berat_akhir_asli-'1.470',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='F3E-ZEXF-10-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 ('F226111006432','2026-05-11','1.470','2026-05-11','10:06:44','PLG0079873','1676000','1676000','7000','1683000','1683000','kasir','2026-05-11 10:06:43','F22611100643');
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-05-11','F226111006432','2026-05-11','10:06:44','RTA','1683000','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-260511-0015','D','2026-05-11','10:06:44','kasir','PENJUALAN','F226111006432','9434529000','1683000','9436212000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1683000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111006432' 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 ('F226111006433','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZEXF-11-T','GL SANTA SERUT KUPU MATA VAR UB 8K ','OL','1.640','1','100.00','1853000','0','0','15000','1870000','0','8000','0','1878000','RTA','T0079172','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXF-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.640',berat_jual_asli=berat_jual_asli+'1.640',stock_jual='1',berat_akhir=berat_akhir-'1.640',berat_akhir_asli=berat_akhir_asli-'1.640',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='F3E-ZEXF-11-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 ('F226111006433','2026-05-11','1.640','2026-05-11','10:06:44','PLG0079874','1870000','1870000','8000','1878000','1878000','kasir','2026-05-11 10:06:43','F22611100643');
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-05-11','F226111006433','2026-05-11','10:06:44','RTA','1878000','8000');
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-260511-0016','D','2026-05-11','10:06:44','kasir','PENJUALAN','F226111006433','9436212000','1878000','9438090000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1878000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111006433' 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 ('F226111017021','kasir','1',' MEH1 UB 45','TOKO','SMBK-H','H1E-ZEXF-80-T','KL RANTAI HOLLOW UB 45CM 8K ','OL','1.010','1','100.00','1141000','0','0','15000','1151000','0','5000','0','1156000','NS','T0079241','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEXF-80-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-05-11' AND kode_barang='H1E-ZEXF-80-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 ('F226111017021','2026-05-11','1.010','2026-05-11','10:17:02','PLG0079875','1151000','1151000','5000','1156000','1156000','kasir','2026-05-11 10:17:02','F22611101702');
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-05-11','F226111017021','2026-05-11','10:17:02','NS','1156000','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-260511-0017','D','2026-05-11','10:17:02','kasir','PENJUALAN','F226111017021','9438090000','1156000','9439246000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1156000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111017021' 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 ('F226111017022','kasir',' 1',' MEH1 UB 45','TOKO','SMBK-H','H1E-ZEXF-82-T','KL RANTAI HOLLOW UB 45CM 8K ','OL','1.030','1','100.00','1164000','0','0','15000','1175000','0','5000','0','1180000','NS','T0079243','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEXF-82-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-05-11' AND kode_barang='H1E-ZEXF-82-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 ('F226111017022','2026-05-11','1.030','2026-05-11','10:17:02','PLG0079876','1175000','1175000','5000','1180000','1180000','kasir','2026-05-11 10:17:02','F22611101702');
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-05-11','F226111017022','2026-05-11','10:17:02','NS','1180000','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-260511-0018','D','2026-05-11','10:17:02','kasir','PENJUALAN','F226111017022','9439246000','1180000','9440426000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1180000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111017022' 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 ('F226111017023','kasir',' 1',' MEH1 UB 45','TOKO','SMBK-H','H1E-ZEXF-81-T','KL RANTAI HOLLOW UB 45CM 8K ','OL','1.030','1','100.00','1164000','0','0','15000','1175000','0','5000','0','1180000','NS','T0079242','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEXF-81-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-05-11' AND kode_barang='H1E-ZEXF-81-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 ('F226111017023','2026-05-11','1.030','2026-05-11','10:17:02','PLG0079877','1175000','1175000','5000','1180000','1180000','kasir','2026-05-11 10:17:02','F22611101702');
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-05-11','F226111017023','2026-05-11','10:17:02','NS','1180000','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-260511-0019','D','2026-05-11','10:17:02','kasir','PENJUALAN','F226111017023','9440426000','1180000','9441606000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1180000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111017023' 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 ('F226111017024','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZEXF-26-T','GL LONG LING UB 8K ','OL','1.030','1','100.00','1164000','0','0','15000','1175000','0','5000','0','1180000','NS','T0079187','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXF-26-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-05-11' AND kode_barang='F3E-ZEXF-26-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 ('F226111017024','2026-05-11','1.030','2026-05-11','10:17:02','PLG0079878','1175000','1175000','5000','1180000','1180000','kasir','2026-05-11 10:17:02','F22611101702');
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-05-11','F226111017024','2026-05-11','10:17:02','NS','1180000','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-260511-0020','D','2026-05-11','10:17:02','kasir','PENJUALAN','F226111017024','9441606000','1180000','9442786000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1180000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111017024' 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 ('F226111017025','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZEXG-27-T','GL KOREA UB 8K ','OL','0.860','1','100.00','972000','0','0','15000','985000','0','5000','0','990000','NS','T0079292','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXG-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='F3E-ZEXG-27-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 ('F226111017025','2026-05-11','0.860','2026-05-11','10:17:02','PLG0079879','985000','985000','5000','990000','990000','kasir','2026-05-11 10:17:02','F22611101702');
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-05-11','F226111017025','2026-05-11','10:17:02','NS','990000','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-260511-0021','D','2026-05-11','10:17:02','kasir','PENJUALAN','F226111017025','9442786000','990000','9443776000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='990000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111017025' 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 ('F226111017026','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZEXG-29-T','GL KOREA UB 8K ','OL','0.860','1','100.00','972000','0','0','15000','985000','0','5000','0','990000','NS','T0079294','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXG-29-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.860',berat_jual_asli=berat_jual_asli+'0.860',stock_jual='1',berat_akhir=berat_akhir-'0.860',berat_akhir_asli=berat_akhir_asli-'0.860',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='F3E-ZEXG-29-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 ('F226111017026','2026-05-11','0.860','2026-05-11','10:17:02','PLG0079880','985000','985000','5000','990000','990000','kasir','2026-05-11 10:17:02','F22611101702');
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-05-11','F226111017026','2026-05-11','10:17:02','NS','990000','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-260511-0022','D','2026-05-11','10:17:02','kasir','PENJUALAN','F226111017026','9443776000','990000','9444766000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='990000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111017026' 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 ('F226111018271','kasir','1',' MEF1 UB D5','TOKO','SMBK-F','F1E-ZEXH-23-T','GL OVAL MODEL C UB D52 8K ','OL','2.160','1','100.00','2441000','0','0','15000','2462000','0','11000','0','2473000','NS','T0079322','F1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEXH-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.160',berat_jual_asli=berat_jual_asli+'2.160',stock_jual='1',berat_akhir=berat_akhir-'2.160',berat_akhir_asli=berat_akhir_asli-'2.160',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='F1E-ZEXH-23-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 ('F226111018271','2026-05-11','2.160','2026-05-11','10:18:28','PLG0079881','2462000','2462000','11000','2473000','2473000','kasir','2026-05-11 10:18:27','F22611101827');
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-05-11','F226111018271','2026-05-11','10:18:28','NS','2473000','11000');
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-260511-0023','D','2026-05-11','10:18:28','kasir','PENJUALAN','F226111018271','9444766000','2473000','9447239000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2473000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111018271' 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 ('F226111018272','kasir',' 1',' MEF1 UB D5','TOKO','SMBK-F','F1E-ZDCX-4-T','GL OVAL MODEL C UB D58 8K ','OL','2.160','1','100.00','2441000','0','0','15000','2462000','0','11000','0','2473000','NS','T0079073','F1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZDCX-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.160',berat_jual_asli=berat_jual_asli+'2.160',stock_jual='1',berat_akhir=berat_akhir-'2.160',berat_akhir_asli=berat_akhir_asli-'2.160',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='F1E-ZDCX-4-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 ('F226111018272','2026-05-11','2.160','2026-05-11','10:18:28','PLG0079882','2462000','2462000','11000','2473000','2473000','kasir','2026-05-11 10:18:27','F22611101827');
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-05-11','F226111018272','2026-05-11','10:18:28','NS','2473000','11000');
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-260511-0024','D','2026-05-11','10:18:28','kasir','PENJUALAN','F226111018272','9447239000','2473000','9449712000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2473000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111018272' 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 ('F226111018273','kasir',' 1',' MEF1 UB D5','TOKO','SMBK-F','F1E-ZDCX-3-T','GL OVAL MODEL C UB D54 8K ','OL ','2.350','1','100.00','2655000','0','0','15000','2680000','0','12000','0','2692000','NS','T0079072','F1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZDCX-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.350',berat_jual_asli=berat_jual_asli+'2.350',stock_jual='1',berat_akhir=berat_akhir-'2.350',berat_akhir_asli=berat_akhir_asli-'2.350',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='F1E-ZDCX-3-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 ('F226111018273','2026-05-11','2.350','2026-05-11','10:18:28','PLG0079883','2680000','2680000','12000','2692000','2692000','kasir','2026-05-11 10:18:27','F22611101827');
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-05-11','F226111018273','2026-05-11','10:18:28','NS','2692000','12000');
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-260511-0025','D','2026-05-11','10:18:28','kasir','PENJUALAN','F226111018273','9449712000','2692000','9452404000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2692000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111018273' 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 ('F226111018274','kasir',' 1',' MEF1 UB D5','TOKO','SMBK-F','F1E-ZEXH-22-T','GL OVAL MODEL C UB D56 8K ','OL','2.290','1','100.00','2588000','0','0','15000','2611000','0','11000','0','2622000','NS','T0079321','F1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZEXH-22-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.290',berat_jual_asli=berat_jual_asli+'2.290',stock_jual='1',berat_akhir=berat_akhir-'2.290',berat_akhir_asli=berat_akhir_asli-'2.290',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='F1E-ZEXH-22-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 ('F226111018274','2026-05-11','2.290','2026-05-11','10:18:28','PLG0079884','2611000','2611000','11000','2622000','2622000','kasir','2026-05-11 10:18:27','F22611101827');
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-05-11','F226111018274','2026-05-11','10:18:28','NS','2622000','11000');
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-260511-0026','D','2026-05-11','10:18:28','kasir','PENJUALAN','F226111018274','9452404000','2622000','9455026000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2622000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111018274' 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 ('F226111050441','kasir','1',' MED1 5K LG','TOKO','SMBK-D','D1E-ZDBB-6-T','LT MODEL APEL CAT VAR LG 8K ','OL ','0.510','1','100.00','576000','0','0','15000','581000','0','5000','0','586000','RHM','T0078796','D1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZDBB-6-T' 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-05-11' AND kode_barang='D1E-ZDBB-6-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 ('F226111050441','2026-05-11','0.510','2026-05-11','10:50:44','PLG0079885','581000','581000','5000','586000','586000','kasir','2026-05-11 10:50:44','F22611105044');
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-05-11','F226111050441','2026-05-11','10:50:44','RHM','586000','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-260511-0027','D','2026-05-11','10:50:44','kasir','PENJUALAN','F226111050441','9455026000','586000','9455612000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='586000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111050441' 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 ('F226111050442','kasir',' 1',' MEH1 KH 42','TOKO','SMBK-H','H1E-ZDCX-38-T','KL SIEM COBRA KH 42CM 8K ','OL ','1.250','1','100.00','1412000','0','0','15000','1419000','0','6000','0','1425000','RHM','T0079107','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDCX-38-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.250',berat_jual_asli=berat_jual_asli+'1.250',stock_jual='1',berat_akhir=berat_akhir-'1.250',berat_akhir_asli=berat_akhir_asli-'1.250',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='H1E-ZDCX-38-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 ('F226111050442','2026-05-11','1.250','2026-05-11','10:50:44','PLG0079886','1419000','1419000','6000','1425000','1425000','kasir','2026-05-11 10:50:44','F22611105044');
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-05-11','F226111050442','2026-05-11','10:50:44','RHM','1425000','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-260511-0028','D','2026-05-11','10:50:44','kasir','PENJUALAN','F226111050442','9455612000','1425000','9457037000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1425000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111050442' 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 ('F226111050443','kasir',' 1',' MEH1 UB 45','TOKO','SMBK-H','H1E-ZCAB-29-T','KL KOREA UB 45CM 8K ','OL ','1.980','1','100.00','2237000','0','0','15000','2247000','0','10000','0','2257000','RHM','T0078100','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCAB-29-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='H1E-ZCAB-29-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 ('F226111050443','2026-05-11','1.980','2026-05-11','10:50:44','PLG0079887','2247000','2247000','10000','2257000','2257000','kasir','2026-05-11 10:50:44','F22611105044');
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-05-11','F226111050443','2026-05-11','10:50:44','RHM','2257000','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-260511-0029','D','2026-05-11','10:50:44','kasir','PENJUALAN','F226111050443','9457037000','2257000','9459294000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2257000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111050443' 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 ('F226111100011','kasir','1',' MEE1 UB 14','TOKO','SMBK-E','E1E-YKAI-43-T','CC MODEL DAUN VAR UB 14 8K ','','0.910','1','100.00','1028000','0','0','15000','1028000','0','0','0','1028000','NS','T0075144','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YKAI-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.910',berat_jual_asli=berat_jual_asli+'0.910',stock_jual='1',berat_akhir=berat_akhir-'0.910',berat_akhir_asli=berat_akhir_asli-'0.910',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='E1E-YKAI-43-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 ('F226111100011','2026-05-11','0.910','2026-05-11','11:00:01','PLG0079888','1028000','1028000','0','1028000','1028000','kasir','2026-05-11 11:00:01','F22611110001');
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-05-11','F226111100011','2026-05-11','11:00:01','NS','1028000','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-260511-0030','D','2026-05-11','11:00:01','kasir','PENJUALAN','F226111100011','9459294000','1028000','9460322000');
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 ('F226111115031','kasir','1',' MEB1 5K LG','TOKO','SMBK-B','B1E-ZEXH-20-T','GW TUSUK APEL CAT VAR LG PE 8K ','OL','0.470','1','100.00','531000','0','0','15000','536000','0','5000','0','541000','TIN','T0079319','B1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZEXH-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='B1E-ZEXH-20-T' 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 ('F226111115031','2026-05-11','0.470','2026-05-11','11:15:03','PLG0079889','536000','536000','5000','541000','541000','kasir','2026-05-11 11:15:03','F22611111503');
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-05-11','F226111115031','2026-05-11','11:15:03','TIN','541000','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-260511-0031','D','2026-05-11','11:15:03','kasir','PENJUALAN','F226111115031','9460322000','541000','9460863000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='541000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111115031' 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 ('F226111115032','kasir',' 1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YKBH-32-T','GW TUSUK HATI MATA VAR LG PE 8K ','OL','0.620','1','100.00','701000','0','0','15000','707000','0','5000','0','712000','TIN','T0075264','B1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YKBH-32-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-05-11' AND kode_barang='B1E-YKBH-32-T' 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 ('F226111115032','2026-05-11','0.620','2026-05-11','11:15:03','PLG0079890','707000','707000','5000','712000','712000','kasir','2026-05-11 11:15:03','F22611111503');
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-05-11','F226111115032','2026-05-11','11:15:03','TIN','712000','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-260511-0032','D','2026-05-11','11:15:03','kasir','PENJUALAN','F226111115032','9460863000','712000','9461575000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='712000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111115032' 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 ('F226111120171','kasir','1',' MED2 CM ','TOKO','SMBK-D','D2E-ZCXB-41-T','LT MODEL HATI MATA VAR CM 8K ','','0.750','1','100.00','847000','0','0','15000','848000','0','0','0','848000','RHM','T0077675','D2E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZCXB-41-T' 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-05-11' AND kode_barang='D2E-ZCXB-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 ('F226111120171','2026-05-11','0.750','2026-05-11','11:20:18','PLG0079891','848000','848000','0','848000','0','kasir','2026-05-11 11:20:17','F22611112017');
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-05-11','F226111120171','2026-05-11','11:20:18','RHM','848000','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-260511-0001','2026-05-11','2026-05-11 11:20:17','PENJUALAN : F226111120171','675367346734673463','BCA','848000','848000','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-260511-0002','D','2026-05-11','11:20:18','BCA','PENJUALAN','F226111120171','4409248888','848000','4410096888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('675367346734673463','HHHH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='848000' WHERE no_faktur_jual='F226111120171' 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 ('F226111138461','kasir','1',' MEB1 X YT ','TOKO','SMBK-B','B1E-ZBAD-106-0','GW X MODEL SLEP YT 8K ','OL ','0.480','1','100.00','542000','0','0','15000','550000','0','5000','0','555000','RHM','00389712','B1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZBAD-106-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='B1E-ZBAD-106-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 ('F226111138461','2026-05-11','0.480','2026-05-11','11:38:47','PLG0079892','550000','550000','5000','555000','555000','kasir','2026-05-11 11:38:46','F22611113846');
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-05-11','F226111138461','2026-05-11','11:38:47','RHM','555000','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-260511-0033','D','2026-05-11','11:38:47','kasir','PENJUALAN','F226111138461','9461575000','555000','9462130000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='555000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111138461' 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 ('F226111138462','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZEXF-70-T','CC MODEL PITA PASIR VAR CM 16 8K ','OL ','0.770','1','100.00','870000','0','0','15000','882000','0','5000','0','887000','RHM','T0079231','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXF-70-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='E1E-ZEXF-70-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 ('F226111138462','2026-05-11','0.770','2026-05-11','11:38:47','PLG0079893','882000','882000','5000','887000','887000','kasir','2026-05-11 11:38:46','F22611113846');
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-05-11','F226111138462','2026-05-11','11:38:47','RHM','887000','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-260511-0034','D','2026-05-11','11:38:47','kasir','PENJUALAN','F226111138462','9462130000','887000','9463017000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='887000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111138462' 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 ('F226111138463','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZEXG-6-T','GL RANTAI HOLLOW PLAT UB 8K ','OL ','0.880','1','100.00','994000','0','0','15000','1008000','0','5000','0','1013000','RHM','T0079271','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXG-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.880',berat_jual_asli=berat_jual_asli+'0.880',stock_jual='1',berat_akhir=berat_akhir-'0.880',berat_akhir_asli=berat_akhir_asli-'0.880',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='F3E-ZEXG-6-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 ('F226111138463','2026-05-11','0.880','2026-05-11','11:38:47','PLG0079894','1008000','1008000','5000','1013000','1013000','kasir','2026-05-11 11:38:46','F22611113846');
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-05-11','F226111138463','2026-05-11','11:38:47','RHM','1013000','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-260511-0035','D','2026-05-11','11:38:47','kasir','PENJUALAN','F226111138463','9463017000','1013000','9464030000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1013000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111138463' 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 ('F226111138464','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-ZEXF-15-T','GL FLIK MODEL BINTANG VAR HW 8K ','OL ','1.560','1','100.00','1763000','0','0','15000','1778000','0','8000','0','1786000','RHM','T0079176','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXF-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.560',berat_jual_asli=berat_jual_asli+'1.560',stock_jual='1',berat_akhir=berat_akhir-'1.560',berat_akhir_asli=berat_akhir_asli-'1.560',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='F3E-ZEXF-15-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 ('F226111138464','2026-05-11','1.560','2026-05-11','11:38:47','PLG0079895','1778000','1778000','8000','1786000','1786000','kasir','2026-05-11 11:38:46','F22611113846');
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-05-11','F226111138464','2026-05-11','11:38:47','RHM','1786000','8000');
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-260511-0036','D','2026-05-11','11:38:47','kasir','PENJUALAN','F226111138464','9464030000','1786000','9465816000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1786000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111138464' 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 ('F226111138465','kasir',' 1',' MEH1 HW ','TOKO','SMBK-H','H1E-ZEXH-3-T','KL SANTA MODEL HATI ARESO HW 8K ','OL ','1.850','1','100.00','2090000','0','0','15000','2109000','0','9000','0','2118000','RHM','T0079302','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEXH-3-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.850',berat_jual_asli=berat_jual_asli+'1.850',stock_jual='1',berat_akhir=berat_akhir-'1.850',berat_akhir_asli=berat_akhir_asli-'1.850',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='H1E-ZEXH-3-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 ('F226111138465','2026-05-11','1.850','2026-05-11','11:38:47','PLG0079896','2109000','2109000','9000','2118000','2118000','kasir','2026-05-11 11:38:46','F22611113846');
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-05-11','F226111138465','2026-05-11','11:38:47','RHM','2118000','9000');
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-260511-0037','D','2026-05-11','11:38:47','kasir','PENJUALAN','F226111138465','9465816000','2118000','9467934000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2118000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111138465' 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 ('F226111145581','kasir','1',' MEE1 LG 16','TOKO','SMBK-E','E1E-ZEXF-61-T','CC MODEL LINEA LG 14 8K ','OL','0.480','1','100.00','542000','0','0','15000','550000','0','5000','0','555000','NS','T0079222','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXF-61-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-05-11' AND kode_barang='E1E-ZEXF-61-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 ('F226111145581','2026-05-11','0.480','2026-05-11','11:45:59','PLG0079897','550000','550000','5000','555000','555000','kasir','2026-05-11 11:45:58','F22611114558');
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-05-11','F226111145581','2026-05-11','11:45:59','NS','555000','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-260511-0038','D','2026-05-11','11:45:59','kasir','PENJUALAN','F226111145581','9467934000','555000','9468489000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='555000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111145581' 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 ('F226111145582','kasir',' 1',' MDA1 CM ','TOKO','SMBK-A','A1D-ZDBE-6-T','AT KLIP MODEL DAUN VAR CM 8K ','OL','1.010','1','100.00','1121000','0','0','15000','1131000','0','5000','0','1136000','NS','T0078975','A1D','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZDBE-6-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-05-11' AND kode_barang='A1D-ZDBE-6-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 ('F226111145582','2026-05-11','1.010','2026-05-11','11:45:59','PLG0079898','1131000','1131000','5000','1136000','1136000','kasir','2026-05-11 11:45:58','F22611114558');
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-05-11','F226111145582','2026-05-11','11:45:59','NS','1136000','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-260511-0039','D','2026-05-11','11:45:59','kasir','PENJUALAN','F226111145582','9468489000','1136000','9469625000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1136000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111145582' 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 ('F226111145583','kasir',' 1',' MDA1 UB ','TOKO','SMBK-A','A1D-ZEXA-9-T','AT KLIP MODEL C UB 8K ','OL','1.080','1','100.00','1199000','0','0','15000','1210000','0','5000','0','1215000','NS','T0079121','A1D','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZEXA-9-T' 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-05-11' AND kode_barang='A1D-ZEXA-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 ('F226111145583','2026-05-11','1.080','2026-05-11','11:45:59','PLG0079899','1210000','1210000','5000','1215000','1215000','kasir','2026-05-11 11:45:58','F22611114558');
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-05-11','F226111145583','2026-05-11','11:45:59','NS','1215000','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-260511-0040','D','2026-05-11','11:45:59','kasir','PENJUALAN','F226111145583','9469625000','1215000','9470840000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1215000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111145583' 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 ('F226111145584','kasir',' 1',' MGD1 LG ','TOKO','SMBK-D','D1G-ZDBB-51-T','LT MODEL PITA VAR LG 8K ','OL','0.350','1','100.00','409000','0','0','15000','415000','0','5000','0','420000','NS','T0078841','D1G','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-ZDBB-51-T' 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-05-11' AND kode_barang='D1G-ZDBB-51-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 ('F226111145584','2026-05-11','0.350','2026-05-11','11:45:59','PLG0079900','415000','415000','5000','420000','420000','kasir','2026-05-11 11:45:58','F22611114558');
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-05-11','F226111145584','2026-05-11','11:45:59','NS','420000','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-260511-0041','D','2026-05-11','11:45:59','kasir','PENJUALAN','F226111145584','9470840000','420000','9471260000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='420000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111145584' 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 ('F226111145585','kasir',' 1',' MED1 LG ','TOKO','SMBK-D','D1E-ZEXG-18-T','LT MODEL HATI POLOS LG 8K ','OL','0.520','1','100.00','588000','0','0','15000','595000','0','5000','0','600000','NS','T0079283','D1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZEXG-18-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-05-11' AND kode_barang='D1E-ZEXG-18-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 ('F226111145585','2026-05-11','0.520','2026-05-11','11:45:59','PLG0079901','595000','595000','5000','600000','600000','kasir','2026-05-11 11:45:58','F22611114558');
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-05-11','F226111145585','2026-05-11','11:45:59','NS','600000','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-260511-0042','D','2026-05-11','11:45:59','kasir','PENJUALAN','F226111145585','9471260000','600000','9471860000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='600000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111145585' 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 ('F226111145586','kasir',' 1',' MEE1 LG 14','TOKO','SMBK-E','E1E-ZEXF-56-T','CC MODEL LINEA LG 12 8K ','OL','0.450','1','100.00','508000','0','0','15000','515000','0','5000','0','520000','NS','T0079217','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXF-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='E1E-ZEXF-56-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 ('F226111145586','2026-05-11','0.450','2026-05-11','11:45:59','PLG0079902','515000','515000','5000','520000','520000','kasir','2026-05-11 11:45:58','F22611114558');
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-05-11','F226111145586','2026-05-11','11:45:59','NS','520000','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-260511-0043','D','2026-05-11','11:45:59','kasir','PENJUALAN','F226111145586','9471860000','520000','9472380000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='520000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111145586' 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 ('F226111145587','kasir',' 1',' MEE1 LG 12','TOKO','SMBK-E','E1E-ZEXF-57-T','CC MODEL LINEA LG 12 8K ','OL','0.460','1','100.00','520000','0','0','15000','527000','0','5000','0','532000','NS','T0079218','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXF-57-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-05-11' AND kode_barang='E1E-ZEXF-57-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 ('F226111145587','2026-05-11','0.460','2026-05-11','11:45:59','PLG0079903','527000','527000','5000','532000','532000','kasir','2026-05-11 11:45:58','F22611114558');
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-05-11','F226111145587','2026-05-11','11:45:59','NS','532000','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-260511-0044','D','2026-05-11','11:45:59','kasir','PENJUALAN','F226111145587','9472380000','532000','9472912000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='532000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226111145587' 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 ('F226111146561','kasir','1',' MEF3 KH ','TOKO','SMBK-F','F3E-ZDAC-20-T','GL MODEL RANTAI HOLLOW DOUBLE KH 8K ','OL','4.970','1','100.00','5616000','0','0','15000','5666000','0','25000','0','5691000','NS','T0078639','F3E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZDAC-20-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.970',berat_jual_asli=berat_jual_asli+'4.970',stock_jual='1',berat_akhir=berat_akhir-'4.970',berat_akhir_asli=berat_akhir_asli-'4.970',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='F3E-ZDAC-20-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 ('F226111146561','2026-05-11','4.970','2026-05-11','11:46:56','PLG0079904','5666000','5666000','25000','5691000','5691000','kasir','2026-05-11 11:46:56','F22611114656');
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-05-11','F226111146561','2026-05-11','11:46:56','NS','5691000','25000');
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-260511-0045','D','2026-05-11','11:46:56','kasir','PENJUALAN','F226111146561','9472912000','5691000','9478603000');
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 ('F226111209431','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZEXG-13-T','CC WEDDING MATA CM 20 8K ','','1.520','1','100.00','1687000','0','0','15000','1687000','0','10000','0','1697000','RTA','T0079278','E2D','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZEXG-13-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='E2D-ZEXG-13-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 ('F226111209431','2026-05-11','1.520','2026-05-11','12:09:43','PLG0079905','1687000','1687000','10000','1697000','1697000','kasir','2026-05-11 12:09:43','F22611120943');
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-05-11','F226111209431','2026-05-11','12:09:43','RTA','1697000','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-260511-0046','D','2026-05-11','12:09:43','kasir','PENJUALAN','F226111209431','9478603000','1697000','9480300000');
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 ('F226111215581','kasir','1',' MEH1 HW ','TOKO','SMBK-H','H1E-ZEXF-98-T','KL SANTA MODEL HATI ARESO HW 8K ','OL','1.870','1','100.00','2113000','0','0','15000','2132000','0','9000','0','2141000','RTA','T0079259','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEXF-98-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-05-11' AND kode_barang='H1E-ZEXF-98-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 ('F226111215581','2026-05-11','1.870','2026-05-11','12:15:58','PLG0079906','2132000','2132000','9000','2141000','2141000','kasir','2026-05-11 12:15:58','F22611121558');
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-05-11','F226111215581','2026-05-11','12:15:58','RTA','2141000','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-260511-0047','D','2026-05-11','12:15:58','kasir','PENJUALAN','F226111215581','9480300000','2141000','9482441000');
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 ('F226111256271','kasir','1',' MDB1 X LG ','TOKO','SMBK-B','B1D-YHAC-147-0','GW X MODEL PANJANG MATA LG 8K ','OL','1.060','1','100.00','1177000','0','0','15000','1188000','0','5000','0','1193000','NS','00365518','B1D','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-YHAC-147-0' 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-05-11' AND kode_barang='B1D-YHAC-147-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 ('F226111256271','2026-05-11','1.060','2026-05-11','12:56:28','PLG0079907','1188000','1188000','5000','1193000','1193000','kasir','2026-05-11 12:56:27','F22611125627');
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-05-11','F226111256271','2026-05-11','12:56:28','NS','1193000','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-260511-0048','D','2026-05-11','12:56:28','kasir','PENJUALAN','F226111256271','9482441000','1193000','9483634000');
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 ('F226110133021','kasir','1',' MEA1E X BW','TOKO','SMBK-A','A1E-ZCCX-444-0','AT X ITALY SLEP BW 8K ','OL','0.560','1','100.00','633000','0','0','15000','636000','0','5000','0','641000','RTA','00397098','A1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZCCX-444-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='A1E-ZCCX-444-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 ('F226110133021','2026-05-11','0.560','2026-05-11','13:33:03','PLG0079908','636000','636000','5000','641000','641000','kasir','2026-05-11 13:33:02','F22611013302');
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-05-11','F226110133021','2026-05-11','13:33:03','RTA','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,status_valid) VALUES ('KM-260511-0049','D','2026-05-11','13:33:03','kasir','PENJUALAN','F226110133021','9483634000','641000','9484275000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='641000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226110133021' 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 ('F226110133022','kasir',' 1',' MEA1 HW ','TOKO','SMBK-A','A1E-ZCAA-5-T','AT MODEL ITALY PANJANG VAR HW 8K ','OL','0.610','1','100.00','689000','0','0','15000','692000','0','5000','0','697000','RTA','T0078004','A1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZCAA-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='A1E-ZCAA-5-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 ('F226110133022','2026-05-11','0.610','2026-05-11','13:33:03','PLG0079909','692000','692000','5000','697000','697000','kasir','2026-05-11 13:33:02','F22611013302');
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-05-11','F226110133022','2026-05-11','13:33:03','RTA','697000','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-260511-0050','D','2026-05-11','13:33:03','kasir','PENJUALAN','F226110133022','9484275000','697000','9484972000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='697000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226110133022' 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 ('F226110133023','kasir',' 1',' MGB1 LG ','TOKO','SMBK-B','B1G-ZEXF-103-T','GW TUSUK MRICAN POLOS LG 8K ','OL','0.250','1','100.00','292000','0','0','15000','294000','0','5000','0','299000','RTA','T0079264','B1G','0','0','-','0','1170000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZEXF-103-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.250',berat_jual_asli=berat_jual_asli+'0.250',stock_jual='1',berat_akhir=berat_akhir-'0.250',berat_akhir_asli=berat_akhir_asli-'0.250',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='B1G-ZEXF-103-T' 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 ('F226110133023','2026-05-11','0.250','2026-05-11','13:33:03','PLG0079910','294000','294000','5000','299000','299000','kasir','2026-05-11 13:33:02','F22611013302');
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-05-11','F226110133023','2026-05-11','13:33:03','RTA','299000','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-260511-0051','D','2026-05-11','13:33:03','kasir','PENJUALAN','F226110133023','9484972000','299000','9485271000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='299000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226110133023' 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 ('F226110205121','kasir','1',' MEE1 LG 12','TOKO','SMBK-E','E1E-ZEXH-32-T','CC BANGKOK SLEP LG 12 8K ','OL','0.500','1','100.00','565000','0','0','15000','570000','0','5000','0','575000','TIN','T0079331','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXH-32-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-05-11' AND kode_barang='E1E-ZEXH-32-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 ('F226110205121','2026-05-11','0.500','2026-05-11','14:05:12','PLG0079911','570000','570000','5000','575000','575000','kasir','2026-05-11 14:05:12','F22611020512');
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-05-11','F226110205121','2026-05-11','14:05:12','TIN','575000','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-260511-0052','D','2026-05-11','14:05:12','kasir','PENJUALAN','F226110205121','9485271000','575000','9485846000');
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 ('F226110207351','kasir','1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZBAX-58-T','LT MODEL BALLERINA PASIR BG 8K ','ol','0.410','1','100.00','471000','0','0','15000','478000','0','5000','0','483000','TIN','T0077173','D1F','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZBAX-58-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='D1F-ZBAX-58-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 ('F226110207351','2026-05-11','0.410','2026-05-11','14:07:36','PLG0079912','478000','478000','5000','483000','483000','kasir','2026-05-11 14:07:35','F22611020735');
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-05-11','F226110207351','2026-05-11','14:07:36','TIN','483000','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-260511-0053','D','2026-05-11','14:07:36','kasir','PENJUALAN','F226110207351','9485846000','483000','9486329000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='483000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226110207351' 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 ('F226110207352','kasir',' 1',' MFD1 5K BG','TOKO','SMBK-D','D1F-ZDBE-43-T','LT MODEL BALLERINA PASIR VAR BG 8K ','ol','0.550','1','100.00','632000','0','0','15000','641000','0','5000','0','646000','TIN','T0079012','D1F','0','0','-','0','1150000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZDBE-43-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-05-11' AND kode_barang='D1F-ZDBE-43-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 ('F226110207352','2026-05-11','0.550','2026-05-11','14:07:36','PLG0079913','641000','641000','5000','646000','646000','kasir','2026-05-11 14:07:35','F22611020735');
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-05-11','F226110207352','2026-05-11','14:07:36','TIN','646000','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-260511-0054','D','2026-05-11','14:07:36','kasir','PENJUALAN','F226110207352','9486329000','646000','9486975000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='646000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226110207352' 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 ('F226110207353','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZEXF-66-T','CC MODEL PLAT PASIR VAR CM 10 8K ','ol','0.450','1','100.00','508000','0','0','15000','515000','0','5000','0','520000','TIN','T0079227','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXF-66-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='E1E-ZEXF-66-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 ('F226110207353','2026-05-11','0.450','2026-05-11','14:07:36','PLG0079914','515000','515000','5000','520000','520000','kasir','2026-05-11 14:07:35','F22611020735');
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-05-11','F226110207353','2026-05-11','14:07:36','TIN','520000','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-260511-0055','D','2026-05-11','14:07:36','kasir','PENJUALAN','F226110207353','9486975000','520000','9487495000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='520000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226110207353' 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 ('F226110207354','kasir',' 1',' MEE1 LG 16','TOKO','SMBK-E','E1E-ZEXF-60-T','CC MODEL LINEA LG 16 8K ','ol','0.500','1','100.00','565000','0','0','15000','573000','0','5000','0','578000','TIN','T0079221','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXF-60-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-05-11' AND kode_barang='E1E-ZEXF-60-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 ('F226110207354','2026-05-11','0.500','2026-05-11','14:07:36','PLG0079915','573000','573000','5000','578000','578000','kasir','2026-05-11 14:07:35','F22611020735');
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-05-11','F226110207354','2026-05-11','14:07:36','TIN','578000','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-260511-0056','D','2026-05-11','14:07:36','kasir','PENJUALAN','F226110207354','9487495000','578000','9488073000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='578000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226110207354' 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 ('F226110207355','kasir',' 1',' MEE1 LG 18','TOKO','SMBK-E','E1E-ZEXF-58-T','CC MODEL LINEA LG 18 8K ','ol','0.530','1','100.00','599000','0','0','15000','607000','0','5000','0','612000','TIN','T0079219','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXF-58-T' 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-05-11' AND kode_barang='E1E-ZEXF-58-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 ('F226110207355','2026-05-11','0.530','2026-05-11','14:07:36','PLG0079916','607000','607000','5000','612000','612000','kasir','2026-05-11 14:07:35','F22611020735');
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-05-11','F226110207355','2026-05-11','14:07:36','TIN','612000','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-260511-0057','D','2026-05-11','14:07:36','kasir','PENJUALAN','F226110207355','9488073000','612000','9488685000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='612000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226110207355' 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 ('F226110207356','kasir',' 1',' MEE1 5K CM','TOKO','SMBK-E','E1E-ZEXF-67-T','CC MODEL PLAT PASIR VAR CM 12 8K ','ol','0.570','1','100.00','644000','0','0','15000','653000','0','5000','0','658000','TIN','T0079228','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEXF-67-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-05-11' AND kode_barang='E1E-ZEXF-67-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 ('F226110207356','2026-05-11','0.570','2026-05-11','14:07:36','PLG0079917','653000','653000','5000','658000','658000','kasir','2026-05-11 14:07:35','F22611020735');
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-05-11','F226110207356','2026-05-11','14:07:36','TIN','658000','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-260511-0058','D','2026-05-11','14:07:36','kasir','PENJUALAN','F226110207356','9488685000','658000','9489343000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='658000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226110207356' 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 ('F226110207357','kasir',' 1',' MEE1 CM 15','TOKO','SMBK-E','E1E-ZDBB-68-T','CC MODEL RANTAI SLEP CM 15 8K ','ol','0.610','1','100.00','689000','0','0','15000','698000','0','5000','0','703000','TIN','T0078858','E1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBB-68-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='E1E-ZDBB-68-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 ('F226110207357','2026-05-11','0.610','2026-05-11','14:07:36','PLG0079918','698000','698000','5000','703000','703000','kasir','2026-05-11 14:07:35','F22611020735');
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-05-11','F226110207357','2026-05-11','14:07:36','TIN','703000','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-260511-0059','D','2026-05-11','14:07:36','kasir','PENJUALAN','F226110207357','9489343000','703000','9490046000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='703000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226110207357' 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 ('F226110207358','kasir',' 1',' MEE2 X CM ','TOKO','SMBK-E','E2E-ZDBX-338-0','CC X MODEL MATA CM 12 8K ','ol','0.620','1','100.00','701000','0','0','15000','710000','0','5000','0','715000','TIN','00400275','E2E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZDBX-338-0' 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-05-11' AND kode_barang='E2E-ZDBX-338-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 ('F226110207358','2026-05-11','0.620','2026-05-11','14:07:36','PLG0079919','710000','710000','5000','715000','715000','kasir','2026-05-11 14:07:35','F22611020735');
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-05-11','F226110207358','2026-05-11','14:07:36','TIN','715000','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-260511-0060','D','2026-05-11','14:07:36','kasir','PENJUALAN','F226110207358','9490046000','715000','9490761000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='715000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226110207358' 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 ('F226110208391','kasir','1',' MDE1 CM 16','TOKO','SMBK-E','E1D-ZDBB-87-T','CC MODEL HATI SLEP VAR CM 16 8K ','ol','1.250','1','100.00','1387000','0','0','15000','1400000','0','6000','0','1406000','TIN','T0078877','E1D','0','0','-','0','1110000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDBB-87-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.250',berat_jual_asli=berat_jual_asli+'1.250',stock_jual='1',berat_akhir=berat_akhir-'1.250',berat_akhir_asli=berat_akhir_asli-'1.250',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='E1D-ZDBB-87-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 ('F226110208391','2026-05-11','1.250','2026-05-11','14:08:40','PLG0079920','1400000','1400000','6000','1406000','1406000','kasir','2026-05-11 14:08:39','F22611020839');
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-05-11','F226110208391','2026-05-11','14:08:40','TIN','1406000','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-260511-0061','D','2026-05-11','14:08:40','kasir','PENJUALAN','F226110208391','9490761000','1406000','9492167000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1406000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226110208391' 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 ('F226110208392','kasir',' 1',' MEH1 UB 45','TOKO','SMBK-H','H1E-ZEXF-85-T','KL RANTAI HOLLOW UB 45CM 8K ','ol','1.020','1','100.00','1153000','0','0','15000','1163000','0','5000','0','1168000','TIN','T0079246','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZEXF-85-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='H1E-ZEXF-85-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 ('F226110208392','2026-05-11','1.020','2026-05-11','14:08:40','PLG0079921','1163000','1163000','5000','1168000','1168000','kasir','2026-05-11 14:08:39','F22611020839');
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-05-11','F226110208392','2026-05-11','14:08:40','TIN','1168000','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-260511-0062','D','2026-05-11','14:08:40','kasir','PENJUALAN','F226110208392','9492167000','1168000','9493335000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1168000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226110208392' 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 ('F226110208393','kasir',' 1',' MEH1 HW ','TOKO','SMBK-H','H1E-ZDBC-24-T','KL SANTA MODEL HATI ARESO HW 8K ','ol','1.890','1','100.00','2136000','0','0','15000','2155000','0','9000','0','2164000','TIN','T0078905','H1E','0','0','-','0','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDBC-24-T' 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-05-11' AND kode_barang='H1E-ZDBC-24-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 ('F226110208393','2026-05-11','1.890','2026-05-11','14:08:40','PLG0079922','2155000','2155000','9000','2164000','2164000','kasir','2026-05-11 14:08:39','F22611020839');
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-05-11','F226110208393','2026-05-11','14:08:40','TIN','2164000','9000');
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-260511-0063','D','2026-05-11','14:08:40','kasir','PENJUALAN','F226110208393','9493335000','2164000','9495499000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2164000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226110208393' 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 ('F226110304211','kasir','1',' MEA1 UB ','TOKO','SMBK-A','A1E-ZCAH-17-T','AT MODEL ITALY PANJANG VAR UB 8K ','','0.960','1','100.00','1085000','0','0','15000','1080000','0','0','0','1080000','RTA','T0078205','A1E','0','0','-','1','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZCAH-17-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-05-11' AND kode_barang='A1E-ZCAH-17-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 ('F226110304211','2026-05-11','0.960','2026-05-11','15:04:21','PLG0079923','1080000','1080000','0','1080000','1080000','kasir','2026-05-11 15:04:21','F22611030421');
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-05-11','F226110304211','2026-05-11','15:04:21','RTA','1080000','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-260511-0064','D','2026-05-11','15:04:21','kasir','PENJUALAN','F226110304211','9495499000','1080000','9496579000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110133021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110133021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110133021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110133022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110133022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110133022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110133023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110133023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110133023';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110205121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110205121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110205121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110207351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110207351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110207351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110207352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110207352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110207352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110207353' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110207353' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110207353';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110207354' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110207354' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110207354';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110207355' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110207355' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110207355';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110207356' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110207356' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110207356';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110207357' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110207357' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110207357';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110207358' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110207358' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110207358';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110208391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110208391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110208391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110208392' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110208392' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110208392';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110208393' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110208393' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110208393';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110304211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110304211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110304211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110838261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110838261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110838261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110856121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110856121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110856121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110857201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110857201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110857201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110953491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110953491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110953491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111005111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111005111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111005111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111005112' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111005112' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111005112';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111005113' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111005113' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111005113';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111005114' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111005114' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111005114';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111005115' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111005115' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111005115';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111005116' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111005116' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111005116';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111005117' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111005117' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111005117';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111005118' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111005118' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111005118';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111006431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111006431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111006431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111006432' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111006432' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111006432';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111006433' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111006433' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111006433';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111017021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111017021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111017021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111017022' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111017022' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111017022';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111017023' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111017023' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111017023';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111017024' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111017024' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111017024';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111017025' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111017025' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111017025';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111017026' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111017026' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111017026';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111018271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111018271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111018271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111018272' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111018272' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111018272';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111018273' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111018273' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111018273';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111018274' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111018274' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111018274';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111050441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111050441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111050441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111050442' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111050442' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111050442';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111050443' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111050443' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111050443';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111100011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111100011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111100011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111115031' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111115031' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111115031';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111115032' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111115032' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111115032';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111120171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111120171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111120171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111138461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111138461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111138461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111138462' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111138462' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111138462';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111138463' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111138463' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111138463';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111138464' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111138464' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111138464';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111138465' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111138465' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111138465';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111145581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111145581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111145581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111145582' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111145582' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111145582';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111145583' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111145583' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111145583';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111145584' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111145584' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111145584';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111145585' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111145585' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111145585';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111145586' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111145586' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111145586';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111145587' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111145587' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111145587';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111146561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111146561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111146561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111209431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111209431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111209431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111215581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111215581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111215581';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226111256271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226111256271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226111256271';
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-00005344','X-00005344','GL MODEL CAPELA VAR HW 8K','GR','---','F3E','BELI','BELI001','1386000','2026-05-11','1.370','1','admin','2026-05-11 15:27:55');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00005344','X-00005344');
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-260511-0001','F226201207381','RTA','1','BELI','BELI001','F3E', 'X-00005344', 'GL MODEL CAPELA VAR HW 8K','1.370','1.370','100.00','1630000','1386000','1011679','1130000','1','1386000','1386000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.370',berat_beli_asli=berat_beli_asli+'1.370',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.370',berat_akhir_asli=berat_akhir_asli+'1.370',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260511-0001','2026-05-11','2026-05-11','15:27:54','RTA','---','1.370','1386000','1386000','1386000','1386000','1386000','admin','2026-05-11 15:27:55','FB-260511-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260511-0001','AMELIA RISKI','BANGUNREJO 3/3 SUKOREJO','','','','admin','2026-05-11 15:27:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-11' 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-260511-0065','K','2026-05-11','15:27:54','admin','PEMBELIAN UMUM','FB-260511-0001','9496579000','1386000','9495193000');
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-00005345','X-00005345','GL MODEL FLIK HW 8K','GR','---','F3E','BELI','BELI001','1370000','2026-05-11','1.350','1','admin','2026-05-11 15:28:28');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00005345','X-00005345');
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-260511-0002','F226070323301','RHM','1','BELI','BELI001','F3E', 'X-00005345', 'GL MODEL FLIK HW 8K','1.350','1.350','100.00','1526000','1370000','1014815','1130000','1','1370000','1370000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.350',berat_beli_asli=berat_beli_asli+'1.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.350',berat_akhir_asli=berat_akhir_asli+'1.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260511-0002','2026-05-11','2026-05-11','15:28:28','RHM','---','1.350','1370000','1370000','1370000','1370000','1370000','admin','2026-05-11 15:28:28','FB-260511-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260511-0002','ANA','SIMAN','','','','admin','2026-05-11 15:28:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-11' 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-260511-0066','K','2026-05-11','15:28:28','admin','PEMBELIAN UMUM','FB-260511-0002','9495193000','1370000','9493823000');
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-00005346','X-00005346','CC MODEL KEPANG VAR CM 14 8K','GR','---','E1D','BELI','BELI001','1099000','2026-05-11','1.210','1','admin','2026-05-11 15:29:19');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00005346','X-00005346');
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-260511-0003','F225170105211','RTA','1','BELI','BELI001','E1D', 'X-00005346', 'CC MODEL KEPANG VAR CM 14 8K','1.210','1.210','100.00','1222000','1099000','908264','1110000','1','1099000','1099000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.210',berat_beli_asli=berat_beli_asli+'1.210',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.210',berat_akhir_asli=berat_akhir_asli+'1.210',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-05-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' 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-260511-0003','2026-05-11','2026-05-11','15:29:18','RTA','---','1.210','1099000','1099000','1099000','1099000','1099000','admin','2026-05-11 15:29:19','FB-260511-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260511-0003','SITI RUKAYAH','TAJUG SIMAN','','','','admin','2026-05-11 15:29:19');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-05-11' 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-260511-0067','K','2026-05-11','15:29:18','admin','PEMBELIAN UMUM','FB-260511-0003','9493823000','1099000','9492724000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260511-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260511-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260511-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260511-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260511-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260511-0003';
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 ('F226110409171','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-ZAAF-242-0','CC X MODEL MATA CM 16 8K ','','1.100','1','100.00','1221000','0','0','15000','1216000','0','0','0','1216000','RHM','00385693','E2D','0','0','-','1','1110000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZAAF-242-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='E2D-ZAAF-242-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 ('F226110409171','2026-05-11','1.100','2026-05-11','16:09:18','PLG0079924','1216000','1216000','0','1216000','1216000','kasir','2026-05-11 16:09:17','F22611040917');
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-05-11','F226110409171','2026-05-11','16:09:18','RHM','1216000','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-260511-0068','D','2026-05-11','16:09:18','kasir','PENJUALAN','F226110409171','9492724000','1216000','9493940000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1216000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226110409171' 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 ('F226110409172','kasir',' 1',' MEF3 UB ','TOKO','SMBK-F','F3E-ZEXG-5-T','GL RANTAI HOLLOW PLAT UB 8K ','','0.880','1','100.00','994000','0','0','15000','990000','0','0','0','990000','RHM','T0079270','F3E','0','0','-','1','1130000');
UPDATE tm_barang SET tgl_last_jual='2026-05-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXG-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.880',berat_jual_asli=berat_jual_asli+'0.880',stock_jual='1',berat_akhir=berat_akhir-'0.880',berat_akhir_asli=berat_akhir_asli-'0.880',stock_akhir='0' WHERE tanggal='2026-05-11' AND kode_barang='F3E-ZEXG-5-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 ('F226110409172','2026-05-11','0.880','2026-05-11','16:09:18','PLG0079925','990000','990000','0','990000','990000','kasir','2026-05-11 16:09:17','F22611040917');
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-05-11','F226110409172','2026-05-11','16:09:18','RHM','990000','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-260511-0069','D','2026-05-11','16:09:18','kasir','PENJUALAN','F226110409172','9493940000','990000','9494930000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='990000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226110409172' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110409171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110409171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110409171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226110409172' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226110409172' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226110409172';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-05-12','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-04-11';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-05-11';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-05-11';
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-05-11' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-05-11';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-05-11';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-05-11';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-05-11';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202604 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-04';
UPDATE tt_barang_saldo SET tanggal= '2026-05-12' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-05-11' 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-260512-0001','D','2026-05-12','16:21:38','SYSTEM','SALDO AWAL','SALDO AWAL','0','9494930000','9494930000');
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-260512-0001','D','2026-05-12','16:21:38','BCA','SALDO AWAL','SALDO AWAL','0','4410096888','4410096888');
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-260512-0001','D','2026-05-12','16:21:38','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
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-260512-0001','D','2026-05-12','16:21:38','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-260512-0001','D','2026-05-12','16:21:38','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-260512-0001','D','2026-05-12','16:21:38','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2026-05-12';