INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-20','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-19';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-19';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-19';
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-07-19' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-19';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-19';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-19';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-19';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-20' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-19' 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-260720-0001','D','2026-07-20','08:28:17','SYSTEM','SALDO AWAL','SALDO AWAL','0','12254927000','12254927000');
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-260720-0001','D','2026-07-20','08:28:17','','SALDO AWAL','SALDO AWAL','0','2260000','2260000');
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-260720-0001','D','2026-07-20','08:28:17','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-260720-0001','D','2026-07-20','08:28:17','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-260720-0001','D','2026-07-20','08:28:17','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-260720-0001','D','2026-07-20','08:28:17','BCA','SALDO AWAL','SALDO AWAL','0','4625075888','4625075888');
UPDATE tp_system SET tgl_system='2026-07-20';
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 ('F226200829261','kasir','1',' MEB1 X LG ','TOKO','SMBK-B','B1E-ZGAG-32-0','GW X MODEL APEL LG PE 8K ','OL','0.470','1','100.00','491000','0','0','15000','496000','0','5000','0','501000','TIN','00413868','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGAG-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.470',berat_jual_asli=berat_jual_asli+'0.470',stock_jual='1',berat_akhir=berat_akhir-'0.470',berat_akhir_asli=berat_akhir_asli-'0.470',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='B1E-ZGAG-32-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 ('F226200829261','2026-07-20','0.470','2026-07-20','08:29:27','PLG0082352','496000','496000','5000','501000','501000','kasir','2026-07-20 08:29:26','F22620082926');
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-07-20','F226200829261','2026-07-20','08:29:27','TIN','501000','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-260720-0002','D','2026-07-20','08:29:27','kasir','PENJUALAN','F226200829261','12254927000','501000','12255428000');
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 ('F226200837491','kasir','1',' MEF2E CM 5','TOKO','SMBK-F','F2E-ZGAX-39-T','GL OVAL HATI MATA SLEP CM 55 8K ','','1.160','1','100.00','1212000','0','0','15000','1212000','0','0','0','1212000','LUS','T0080999','F2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZGAX-39-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.160',berat_jual_asli=berat_jual_asli+'1.160',stock_jual='1',berat_akhir=berat_akhir-'1.160',berat_akhir_asli=berat_akhir_asli-'1.160',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='F2E-ZGAX-39-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 ('F226200837491','2026-07-20','1.160','2026-07-20','08:37:49','PLG0082353','1212000','1212000','0','1212000','1212000','kasir','2026-07-20 08:37:49','F22620083749');
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-07-20','F226200837491','2026-07-20','08:37:49','LUS','1212000','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-260720-0003','D','2026-07-20','08:37:49','kasir','PENJUALAN','F226200837491','12255428000','1212000','12256640000');
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 ('F226200841311','kasir','1',' TFA1 X UB ','TOKO','TBK-A','A1TF-WFBX-11-T','AT X ITALY PANJANG ARESO VAR UB ','','1.170','1','100.00','2258000','0','0','15000','2258000','0','0','0','2258000','LUS','T0045357','A1TF','0','0','-','0','1930000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TF-WFBX-11-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.170',berat_jual_asli=berat_jual_asli+'1.170',stock_jual='1',berat_akhir=berat_akhir-'1.170',berat_akhir_asli=berat_akhir_asli-'1.170',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='A1TF-WFBX-11-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226200841311','2026-07-20','1.170','2026-07-20','08:41:32','PLG0082354','2258000','2258000','0','2258000','2258000','kasir','2026-07-20 08:41:31','F22620084131');
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-07-20','F226200841311','2026-07-20','08:41:32','LUS','2258000','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-260720-0004','D','2026-07-20','08:41:32','kasir','PENJUALAN','F226200841311','12256640000','2258000','12258898000');
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 ('F226200916421','kasir','1',' MED2E LG A','TOKO','SMBK-D','D2E-ZGAD-12-T','LT HURUF MATA LG A 8K ','OLS 764D7','0.570','1','100.00','596000','0','0','15000','633000','0','115000','0','748000','TIN','T0081089','D2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZGAD-12-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-07-20' AND kode_barang='D2E-ZGAD-12-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 ('F226200916421','2026-07-20','0.570','2026-07-20','09:16:42','PLG0082355','633000','633000','115000','748000','748000','kasir','2026-07-20 09:16:42','F22620091642');
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-07-20','F226200916421','2026-07-20','09:16:42','TIN','748000','115000');
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-260720-0005','D','2026-07-20','09:16:42','kasir','PENJUALAN','F226200916421','12258898000','748000','12259646000');
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 ('F226200944041','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZGAA-31-T','CC WEDDING MATA SLEP CM 12 8K ','','1.600','1','100.00','1640000','0','0','15000','1640000','0','10000','0','1650000','LUS','T0081042','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGAA-31-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.600',berat_jual_asli=berat_jual_asli+'1.600',stock_jual='1',berat_akhir=berat_akhir-'1.600',berat_akhir_asli=berat_akhir_asli-'1.600',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='E2D-ZGAA-31-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 ('F226200944041','2026-07-20','1.600','2026-07-20','09:44:04','PLG0082356','1640000','1640000','10000','1650000','1650000','kasir','2026-07-20 09:44:04','F22620094404');
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-07-20','F226200944041','2026-07-20','09:44:04','LUS','1650000','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-260720-0006','D','2026-07-20','09:44:04','kasir','PENJUALAN','F226200944041','12259646000','1650000','12261296000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1650000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226200944041' 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 ('F226200944042','kasir',' 1',' MEF1E TD 5','TOKO','SMBK-F','F1E-ZGAX-31-T','GL MODEL C SLEP TD 54 8K ','','2.960','1','100.00','3093000','0','0','15000','3093000','0','0','0','3093000','LUS','T0080991','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGAX-31-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.960',berat_jual_asli=berat_jual_asli+'2.960',stock_jual='1',berat_akhir=berat_akhir-'2.960',berat_akhir_asli=berat_akhir_asli-'2.960',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='F1E-ZGAX-31-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 ('F226200944042','2026-07-20','2.960','2026-07-20','09:44:04','PLG0082357','3093000','3093000','0','3093000','3093000','kasir','2026-07-20 09:44:04','F22620094404');
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-07-20','F226200944042','2026-07-20','09:44:04','LUS','3093000','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-260720-0007','D','2026-07-20','09:44:04','kasir','PENJUALAN','F226200944042','12261296000','3093000','12264389000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='3093000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226200944042' 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 ('F226201009331','kasir','1',' MED2E X LG','TOKO','SMBK-D','D2E-ZCAD-54-0','LT X MODEL MATA LG 8K ','OL','0.520','1','100.00','543000','0','0','15000','549000','0','5000','0','554000','LUS','00394182','D2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZCAD-54-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='D2E-ZCAD-54-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 ('F226201009331','2026-07-20','0.520','2026-07-20','10:09:33','PLG0082358','549000','549000','5000','554000','554000','kasir','2026-07-20 10:09:33','F22620100933');
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-07-20','F226201009331','2026-07-20','10:09:33','LUS','554000','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-260720-0008','D','2026-07-20','10:09:33','kasir','PENJUALAN','F226201009331','12264389000','554000','12264943000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='554000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201009331' 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 ('F226201009332','kasir',' 1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZGAX-29-0','KL SANTA KH 42 8K ','OL','2.020','1','100.00','2111000','0','0','15000','2121000','0','10000','0','2131000','LUS','00413105','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGAX-29-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='H1E-ZGAX-29-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 ('F226201009332','2026-07-20','2.020','2026-07-20','10:09:33','PLG0082359','2121000','2121000','10000','2131000','2131000','kasir','2026-07-20 10:09:33','F22620100933');
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-07-20','F226201009332','2026-07-20','10:09:33','LUS','2131000','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-260720-0009','D','2026-07-20','10:09:33','kasir','PENJUALAN','F226201009332','12264943000','2131000','12267074000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2131000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201009332' 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 ('F226201010191','kasir','1',' MFD1F X LG','TOKO','SMBK-D','D1F-ZGXI-32-0','LT X SLOBOK KUPU SLEP LG 8K ','OL','0.350','1','100.00','373000','0','0','15000','378000','0','5000','0','383000','LUS','00412751','D1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGXI-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='D1F-ZGXI-32-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 ('F226201010191','2026-07-20','0.350','2026-07-20','10:10:19','PLG0082360','378000','378000','5000','383000','383000','kasir','2026-07-20 10:10:19','F22620101019');
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-07-20','F226201010191','2026-07-20','10:10:19','LUS','383000','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-260720-0010','D','2026-07-20','10:10:19','kasir','PENJUALAN','F226201010191','12267074000','383000','12267457000');
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 ('F226201013291','kasir','1',' MGA1G DG ','TOKO','SMBK-A','A1G-ZGAE-53-T','AT TINDIK BABY DG 8K ','OL','0.250','1','100.00','271000','0','0','15000','275000','0','5000','0','280000','LUS','T0081198','A1G','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZGAE-53-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-07-20' AND kode_barang='A1G-ZGAE-53-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 ('F226201013291','2026-07-20','0.250','2026-07-20','10:13:29','PLG0082361','275000','275000','5000','280000','280000','kasir','2026-07-20 10:13:29','F22620101329');
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-07-20','F226201013291','2026-07-20','10:13:29','LUS','280000','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-260720-0011','D','2026-07-20','10:13:29','kasir','PENJUALAN','F226201013291','12267457000','280000','12267737000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='280000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201013291' 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 ('F226201013292','kasir',' 1',' MGA1G DG ','TOKO','SMBK-A','A1G-ZGAE-54-T','AT TINDIK BABY DG 8K ','OL','0.250','1','100.00','271000','0','0','15000','275000','0','5000','0','280000','LUS','T0081199','A1G','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZGAE-54-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-07-20' AND kode_barang='A1G-ZGAE-54-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 ('F226201013292','2026-07-20','0.250','2026-07-20','10:13:29','PLG0082362','275000','275000','5000','280000','280000','kasir','2026-07-20 10:13:29','F22620101329');
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-07-20','F226201013292','2026-07-20','10:13:29','LUS','280000','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-260720-0012','D','2026-07-20','10:13:29','kasir','PENJUALAN','F226201013292','12267737000','280000','12268017000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='280000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201013292' 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 ('F226201013293','kasir',' 1',' MGA1G DG ','TOKO','SMBK-A','A1G-ZGAE-51-T','AT TINDIK BABY DG 8K ','OL','0.250','1','100.00','271000','0','0','15000','275000','0','5000','0','280000','LUS','T0081196','A1G','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZGAE-51-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-07-20' AND kode_barang='A1G-ZGAE-51-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 ('F226201013293','2026-07-20','0.250','2026-07-20','10:13:29','PLG0082363','275000','275000','5000','280000','280000','kasir','2026-07-20 10:13:29','F22620101329');
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-07-20','F226201013293','2026-07-20','10:13:29','LUS','280000','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-260720-0013','D','2026-07-20','10:13:29','kasir','PENJUALAN','F226201013293','12268017000','280000','12268297000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='280000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201013293' 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 ('F226201013294','kasir',' 1',' MGA1G DG ','TOKO','SMBK-A','A1G-ZGAE-49-T','AT TINDIK BABY DG 8K ','OL','0.260','1','100.00','282000','0','0','15000','286000','0','5000','0','291000','LUS','T0081194','A1G','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1G-ZGAE-49-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='A1G-ZGAE-49-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 ('F226201013294','2026-07-20','0.260','2026-07-20','10:13:29','PLG0082364','286000','286000','5000','291000','291000','kasir','2026-07-20 10:13:29','F22620101329');
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-07-20','F226201013294','2026-07-20','10:13:29','LUS','291000','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-260720-0014','D','2026-07-20','10:13:29','kasir','PENJUALAN','F226201013294','12268297000','291000','12268588000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='291000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201013294' 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 ('F226201013295','kasir',' 1',' MFD1F 5K B','TOKO','SMBK-D','D1F-ZFBD-46-T','LT SLOBOK CHARM SLEP BG 8K ','OL','0.480','1','100.00','511000','0','0','15000','518000','0','5000','0','523000','LUS','T0080734','D1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZFBD-46-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-07-20' AND kode_barang='D1F-ZFBD-46-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 ('F226201013295','2026-07-20','0.480','2026-07-20','10:13:29','PLG0082365','518000','518000','5000','523000','523000','kasir','2026-07-20 10:13:29','F22620101329');
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-07-20','F226201013295','2026-07-20','10:13:29','LUS','523000','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-260720-0015','D','2026-07-20','10:13:29','kasir','PENJUALAN','F226201013295','12268588000','523000','12269111000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='523000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201013295' 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 ('F226201013296','kasir',' 1',' MFD1F 5K B','TOKO','SMBK-D','D1F-ZFBD-43-T','LT SLOBOK CHARM SLEP BG 8K ','OL','0.500','1','100.00','532000','0','0','15000','540000','0','5000','0','545000','LUS','T0080731','D1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZFBD-43-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-07-20' AND kode_barang='D1F-ZFBD-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 ('F226201013296','2026-07-20','0.500','2026-07-20','10:13:29','PLG0082366','540000','540000','5000','545000','545000','kasir','2026-07-20 10:13:29','F22620101329');
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-07-20','F226201013296','2026-07-20','10:13:29','LUS','545000','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-260720-0016','D','2026-07-20','10:13:29','kasir','PENJUALAN','F226201013296','12269111000','545000','12269656000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='545000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201013296' 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 ('F226201015341','kasir','1',' MEB1 X 5K ','TOKO','SMBK-B','B1E-ZGAD-5-T','GW X MODEL APEL CAT SLEP LG PE 8K ','OL','0.490','1','100.00','512000','0','0','15000','519000','0','5000','0','524000','LUS','T0081082','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGAD-5-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.490',berat_jual_asli=berat_jual_asli+'0.490',stock_jual='1',berat_akhir=berat_akhir-'0.490',berat_akhir_asli=berat_akhir_asli-'0.490',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='B1E-ZGAD-5-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 ('F226201015341','2026-07-20','0.490','2026-07-20','10:15:35','PLG0082367','519000','519000','5000','524000','524000','kasir','2026-07-20 10:15:34','F22620101534');
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-07-20','F226201015341','2026-07-20','10:15:35','LUS','524000','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-260720-0017','D','2026-07-20','10:15:35','kasir','PENJUALAN','F226201015341','12269656000','524000','12270180000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='524000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201015341' 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 ('F226201015342','kasir',' 1',' MEB1 X 5K ','TOKO','SMBK-B','B1E-ZGAD-4-T','GW X MODEL PITA CAT SLEP LG PE 8K ','OL','0.510','1','100.00','533000','0','0','15000','541000','0','5000','0','546000','LUS','T0081081','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGAD-4-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-07-20' AND kode_barang='B1E-ZGAD-4-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 ('F226201015342','2026-07-20','0.510','2026-07-20','10:15:35','PLG0082368','541000','541000','5000','546000','546000','kasir','2026-07-20 10:15:34','F22620101534');
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-07-20','F226201015342','2026-07-20','10:15:35','LUS','546000','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-260720-0018','D','2026-07-20','10:15:35','kasir','PENJUALAN','F226201015342','12270180000','546000','12270726000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='546000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201015342' 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 ('F226201015343','kasir',' 1',' MFE1 X KH ','TOKO','SMBK-E','E1F-ZGAG-131-0','CC X MODEL SLEP KH 10 8K ','OL','0.350','1','100.00','373000','0','0','15000','378000','0','5000','0','383000','LUS','00413967','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGAG-131-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='E1F-ZGAG-131-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 ('F226201015343','2026-07-20','0.350','2026-07-20','10:15:35','PLG0082369','378000','378000','5000','383000','383000','kasir','2026-07-20 10:15:34','F22620101534');
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-07-20','F226201015343','2026-07-20','10:15:35','LUS','383000','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-260720-0019','D','2026-07-20','10:15:35','kasir','PENJUALAN','F226201015343','12270726000','383000','12271109000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='383000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201015343' 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 ('F226201015344','kasir',' 1',' MFE1 X KH ','TOKO','SMBK-E','E1F-ZGAG-132-0','CC X MODEL SLEP KH 14 8K ','OL','0.360','1','100.00','383000','0','0','15000','389000','0','5000','0','394000','LUS','00413968','E1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZGAG-132-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='E1F-ZGAG-132-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 ('F226201015344','2026-07-20','0.360','2026-07-20','10:15:35','PLG0082370','389000','389000','5000','394000','394000','kasir','2026-07-20 10:15:34','F22620101534');
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-07-20','F226201015344','2026-07-20','10:15:35','LUS','394000','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-260720-0020','D','2026-07-20','10:15:35','kasir','PENJUALAN','F226201015344','12271109000','394000','12271503000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='394000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201015344' 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 ('F226201017341','kasir','1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZGAE-43-T','GL KOREA UB 8K ','OL','0.900','1','100.00','940000','0','0','15000','955000','0','5000','0','960000','LUS','T0081188','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGAE-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.900',berat_jual_asli=berat_jual_asli+'0.900',stock_jual='1',berat_akhir=berat_akhir-'0.900',berat_akhir_asli=berat_akhir_asli-'0.900',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='F3E-ZGAE-43-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 ('F226201017341','2026-07-20','0.900','2026-07-20','10:17:35','PLG0082371','955000','955000','5000','960000','960000','kasir','2026-07-20 10:17:34','F22620101734');
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-07-20','F226201017341','2026-07-20','10:17:35','LUS','960000','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-260720-0021','D','2026-07-20','10:17:35','kasir','PENJUALAN','F226201017341','12271503000','960000','12272463000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='960000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201017341' 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 ('F226201017342','kasir',' 1',' MEF3E UB ','TOKO','SMBK-F','F3E-ZGAG-68-T','GL LONGLING SLEP UB 8K ','OL','1.000','1','100.00','1045000','0','0','15000','1055000','0','5000','0','1060000','LUS','T0081291','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGAG-68-T' 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-07-20' AND kode_barang='F3E-ZGAG-68-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 ('F226201017342','2026-07-20','1.000','2026-07-20','10:17:35','PLG0082372','1055000','1055000','5000','1060000','1060000','kasir','2026-07-20 10:17:34','F22620101734');
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-07-20','F226201017342','2026-07-20','10:17:35','LUS','1060000','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-260720-0022','D','2026-07-20','10:17:35','kasir','PENJUALAN','F226201017342','12272463000','1060000','12273523000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1060000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201017342' 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 ('F226201017343','kasir',' 1',' MEF3E YT ','TOKO','SMBK-F','F3E-ZGAE-44-T','GL KOREA YT 8K ','OL','1.000','1','100.00','1045000','0','0','15000','1055000','0','5000','0','1060000','LUS','T0081189','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGAE-44-T' 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-07-20' AND kode_barang='F3E-ZGAE-44-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 ('F226201017343','2026-07-20','1.000','2026-07-20','10:17:35','PLG0082373','1055000','1055000','5000','1060000','1060000','kasir','2026-07-20 10:17:34','F22620101734');
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-07-20','F226201017343','2026-07-20','10:17:35','LUS','1060000','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-260720-0023','D','2026-07-20','10:17:35','kasir','PENJUALAN','F226201017343','12273523000','1060000','12274583000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1060000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201017343' 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 ('F226201017344','kasir',' 1',' MEF3 LT ','TOKO','SMBK-F','F3E-ZCXB-7-T','GL MODEL VERONA VAR LT 8K ','OL','1.550','1','100.00','1620000','0','0','15000','1635000','0','8000','0','1643000','LUS','T0077641','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZCXB-7-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='F3E-ZCXB-7-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 ('F226201017344','2026-07-20','1.550','2026-07-20','10:17:35','PLG0082374','1635000','1635000','8000','1643000','1643000','kasir','2026-07-20 10:17:34','F22620101734');
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-07-20','F226201017344','2026-07-20','10:17:35','LUS','1643000','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-260720-0024','D','2026-07-20','10:17:35','kasir','PENJUALAN','F226201017344','12274583000','1643000','12276226000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1643000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201017344' 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 ('F226201017345','kasir',' 1',' MEF3 11K K','TOKO','SMBK-F','F3E-ZFXD-30-T','GL RANTAI P3 SLEP KH 8K ','OL','2.080','1','100.00','2174000','0','0','15000','2195000','0','10000','0','2205000','LUS','T0080195','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXD-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.080',berat_jual_asli=berat_jual_asli+'2.080',stock_jual='1',berat_akhir=berat_akhir-'2.080',berat_akhir_asli=berat_akhir_asli-'2.080',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='F3E-ZFXD-30-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 ('F226201017345','2026-07-20','2.080','2026-07-20','10:17:35','PLG0082375','2195000','2195000','10000','2205000','2205000','kasir','2026-07-20 10:17:34','F22620101734');
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-07-20','F226201017345','2026-07-20','10:17:35','LUS','2205000','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-260720-0025','D','2026-07-20','10:17:35','kasir','PENJUALAN','F226201017345','12276226000','2205000','12278431000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2205000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201017345' 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 ('F226201132301','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YIXC-48-0','LT SLOBOK HURUF BALOK BG I 8K ','OLS GQTMJ','0.320','1','100.00','347000','0','0','15000','368000','0','60000','0','428000','TIN','00367730','D1G','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YIXC-48-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-07-20' AND kode_barang='D1G-YIXC-48-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 ('F226201132301','2026-07-20','0.320','2026-07-20','11:32:31','PLG0082376','368000','368000','60000','428000','428000','kasir','2026-07-20 11:32:30','F22620113230');
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-07-20','F226201132301','2026-07-20','11:32:31','TIN','428000','60000');
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-260720-0026','D','2026-07-20','11:32:31','kasir','PENJUALAN','F226201132301','12278431000','428000','12278859000');
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 ('F226201136571','kasir','1',' TEE1 LG 16','TOKO','TBK-E','E1TE-ZGAG-14-T','CC MODEL ISYANA SLEP LG 16 17K ','OL','0.760','1','100.00','1452000','0','0','15000','1459000','0','7000','0','1466000','LUS','T0081237','E1TE','0','0','-','0','1910000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-ZGAG-14-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.760',berat_jual_asli=berat_jual_asli+'0.760',stock_jual='1',berat_akhir=berat_akhir-'0.760',berat_akhir_asli=berat_akhir_asli-'0.760',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='E1TE-ZGAG-14-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 ('F226201136571','2026-07-20','0.760','2026-07-20','11:36:57','PLG0082377','1459000','1459000','7000','1466000','1466000','kasir','2026-07-20 11:36:57','F22620113657');
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-07-20','F226201136571','2026-07-20','11:36:57','LUS','1466000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260720-0027','D','2026-07-20','11:36:57','kasir','PENJUALAN','F226201136571','12278859000','1466000','12280325000');
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 ('F226201138081','kasir','1',' MEF1E UB 6','TOKO','SMBK-F','F1E-ZGAH-64-T','GL OVAL C SLEP UB 60 8K ','OL','2.330','1','100.00','2435000','0','0','15000','2458000','0','12000','0','2470000','LUS','T0081369','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZGAH-64-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.330',berat_jual_asli=berat_jual_asli+'2.330',stock_jual='1',berat_akhir=berat_akhir-'2.330',berat_akhir_asli=berat_akhir_asli-'2.330',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='F1E-ZGAH-64-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 ('F226201138081','2026-07-20','2.330','2026-07-20','11:38:09','PLG0082378','2458000','2458000','12000','2470000','2470000','kasir','2026-07-20 11:38:08','F22620113808');
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-07-20','F226201138081','2026-07-20','11:38:09','LUS','2470000','12000');
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-260720-0028','D','2026-07-20','11:38:09','kasir','PENJUALAN','F226201138081','12280325000','2470000','12282795000');
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 ('F226201138441','kasir','1',' MGB1G X CM','TOKO','SMBK-B','B1G-ZGAG-34-0','GW X TUSUK DAISY MATA CM 8K ','OL','0.270','1','100.00','293000','0','0','15000','297000','0','5000','0','302000','LUS','00413870','B1G','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-ZGAG-34-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.270',berat_jual_asli=berat_jual_asli+'0.270',stock_jual='1',berat_akhir=berat_akhir-'0.270',berat_akhir_asli=berat_akhir_asli-'0.270',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='B1G-ZGAG-34-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 ('F226201138441','2026-07-20','0.270','2026-07-20','11:38:45','PLG0082379','297000','297000','5000','302000','302000','kasir','2026-07-20 11:38:44','F22620113844');
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-07-20','F226201138441','2026-07-20','11:38:45','LUS','302000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260720-0029','D','2026-07-20','11:38:45','kasir','PENJUALAN','F226201138441','12282795000','302000','12283097000');
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 ('F226201139591','kasir','1',' MFB1F LG ','TOKO','SMBK-B','B1F-ZGAE-63-T','GW DAISY MATA LG 8K ','OL','0.370','1','100.00','394000','0','0','15000','400000','0','5000','0','405000','LUS','T0081208','B1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1F-ZGAE-63-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='B1F-ZGAE-63-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 ('F226201139591','2026-07-20','0.370','2026-07-20','11:40:00','PLG0082380','400000','400000','5000','405000','405000','kasir','2026-07-20 11:39:59','F22620113959');
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-07-20','F226201139591','2026-07-20','11:40:00','LUS','405000','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-260720-0030','D','2026-07-20','11:40:00','kasir','PENJUALAN','F226201139591','12283097000','405000','12283502000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='405000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201139591' 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 ('F226201139592','kasir',' 1',' MEF3E X UB','TOKO','SMBK-F','F3E-ZGAG-166-0','GL X SHANIA SLEP UB 8K ','OL','0.580','1','100.00','606000','0','0','15000','615000','0','5000','0','620000','LUS','00414002','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGAG-166-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='F3E-ZGAG-166-0' 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 ('F226201139592','2026-07-20','0.580','2026-07-20','11:40:00','PLG0082381','615000','615000','5000','620000','620000','kasir','2026-07-20 11:39:59','F22620113959');
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-07-20','F226201139592','2026-07-20','11:40:00','LUS','620000','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-260720-0031','D','2026-07-20','11:40:00','kasir','PENJUALAN','F226201139592','12283502000','620000','12284122000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='620000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201139592' 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 ('F226201140511','kasir','1',' MEB1 X BW ','TOKO','SMBK-B','B1E-ZGAG-33-0','GW X MODEL KUPU SLEP BW 8K ','OL','0.450','1','100.00','470000','0','0','15000','477000','0','5000','0','482000','LUS','00413869','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGAG-33-0' 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-07-20' AND kode_barang='B1E-ZGAG-33-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 ('F226201140511','2026-07-20','0.450','2026-07-20','11:40:52','PLG0082382','477000','477000','5000','482000','482000','kasir','2026-07-20 11:40:51','F22620114051');
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-07-20','F226201140511','2026-07-20','11:40:52','LUS','482000','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-260720-0032','D','2026-07-20','11:40:52','kasir','PENJUALAN','F226201140511','12284122000','482000','12284604000');
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 ('F226201223431','kasir','1',' TEF1 YT 58','TOKO','TBK-F','F1TE-ZGAG-27-T','GL OVAL C SLEP YT 58 17K ','OL','2.970','1','100.00','5673000','0','0','15000','5696000','0','21000','0','5717000','LUS','T0081250','F1TE','0','0','-','0','1910000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-ZGAG-27-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.970',berat_jual_asli=berat_jual_asli+'2.970',stock_jual='1',berat_akhir=berat_akhir-'2.970',berat_akhir_asli=berat_akhir_asli-'2.970',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='F1TE-ZGAG-27-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226201223431','2026-07-20','2.970','2026-07-20','12:23:44','PLG0082383','5696000','5696000','21000','5717000','5717000','kasir','2026-07-20 12:23:43','F22620122343');
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-07-20','F226201223431','2026-07-20','12:23:44','LUS','5717000','21000');
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-260720-0033','D','2026-07-20','12:23:44','kasir','PENJUALAN','F226201223431','12284604000','5717000','12290321000');
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 ('F226201232481','kasir','1',' TEF1 UB 54','TOKO','TBK-F','F1TE-ZFXE-106-T','GL OVAL C SLEP UB 54 17K ','OL','2.940','1','100.00','5615000','0','0','15000','5624000','0','21000','0','5645000','TIN','T0080408','F1TE','0','0','-','0','1910000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1TE-ZFXE-106-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.940',berat_jual_asli=berat_jual_asli+'2.940',stock_jual='1',berat_akhir=berat_akhir-'2.940',berat_akhir_asli=berat_akhir_asli-'2.940',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='F1TE-ZFXE-106-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F226201232481','2026-07-20','2.940','2026-07-20','12:32:48','PLG0082384','5624000','5624000','21000','5645000','0','kasir','2026-07-20 12:32:48','F22620123248');
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-07-20','F226201232481','2026-07-20','12:32:48','TIN','5645000','21000');
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-260720-0001','2026-07-20','2026-07-20 12:32:48','PENJUALAN : F226201232481','098765432','BCA','5645000','5645000','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-260720-0002','D','2026-07-20','12:32:48','BCA','PENJUALAN','F226201232481','4625075888','5645000','4630720888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('098765432','DEWI');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201232481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201232481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201232481';
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 ('F226201234581','kasir','1',' TEE1 LG 16','TOKO','TBK-E','E1TE-ZGAG-15-T','CC MODEL ISYANA SLEP LG 16 17K ','OL','0.730','1','100.00','1394000','0','0','15000','1402000','0','7000','0','1409000','TIN','T0081238','E1TE','0','0','-','0','1910000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-ZGAG-15-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='E1TE-ZGAG-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 ('F226201234581','2026-07-20','0.730','2026-07-20','12:34:59','PLG0082385','1402000','1402000','7000','1409000','0','kasir','2026-07-20 12:34:58','F22620123458');
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-07-20','F226201234581','2026-07-20','12:34:59','TIN','1409000','7000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260720-0002','2026-07-20','2026-07-20 12:34:58','PENJUALAN : F226201234581','0987654321','BCA','1409000','1409000','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-260720-0003','D','2026-07-20','12:34:59','BCA','PENJUALAN','F226201234581','4630720888','1409000','4632129888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0987654321','DEWI');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201234581' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201234581' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201234581';
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 ('F226201240521','kasir','1',' MFD1 X BG ','TOKO','SMBK-D','D1F-ZFBB-118-0','LT X SLOBOK BAMBOO BG 8K ','','0.600','1','100.00','639000','0','0','15000','640000','0','0','0','640000','TIN','00409697','D1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZFBB-118-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='D1F-ZFBB-118-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 ('F226201240521','2026-07-20','0.600','2026-07-20','12:40:53','PLG0082386','640000','640000','0','640000','640000','kasir','2026-07-20 12:40:52','F22620124052');
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-07-20','F226201240521','2026-07-20','12:40:53','TIN','640000','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-260720-0034','D','2026-07-20','12:40:53','kasir','PENJUALAN','F226201240521','12290321000','640000','12290961000');
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 ('F226201242311','kasir','1',' MEF3E PM ','TOKO','SMBK-F','F3E-ZGAG-74-T','GL MODEL VERONA SLEP PM 8K ','','3.160','1','100.00','3302000','0','0','15000','3302000','0','0','0','3302000','LUS','T0081297','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGAG-74-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.160',berat_jual_asli=berat_jual_asli+'3.160',stock_jual='1',berat_akhir=berat_akhir-'3.160',berat_akhir_asli=berat_akhir_asli-'3.160',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='F3E-ZGAG-74-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 ('F226201242311','2026-07-20','3.160','2026-07-20','12:42:32','PLG0082387','3302000','3302000','0','3302000','3302000','kasir','2026-07-20 12:42:31','F22620124231');
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-07-20','F226201242311','2026-07-20','12:42:32','LUS','3302000','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-260720-0035','D','2026-07-20','12:42:32','kasir','PENJUALAN','F226201242311','12290961000','3302000','12294263000');
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 ('F226201251381','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZGAH-2-T','CC WEDDING MATA SLEP CM 24 8K ','OL','1.510','1','100.00','1548000','0','0','15000','1553000','0','10000','0','1563000','TIN','T0081307','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGAH-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='E2D-ZGAH-2-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 ('F226201251381','2026-07-20','1.510','2026-07-20','12:51:38','PLG0082388','1553000','1553000','10000','1563000','0','kasir','2026-07-20 12:51:38','F22620125138');
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-07-20','F226201251381','2026-07-20','12:51:38','TIN','1563000','10000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260720-0003','2026-07-20','2026-07-20 12:51:38','PENJUALAN : F226201251381','0987654321','BCA','1563000','1563000','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-260720-0004','D','2026-07-20','12:51:38','BCA','PENJUALAN','F226201251381','4632129888','1563000','4633692888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('0987654321','RIANTI');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201251381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201251381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201251381';
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 ('F226201254351','kasir','1',' MEB1E CM P','TOKO','SMBK-B','B1E-ZGAH-40-T','GW MODEL PASIR VAR SLEP CM PE 8K ','OL','0.610','1','100.00','637000','0','0','15000','645000','0','5000','0','650000','TIN','T0081345','B1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGAH-40-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-07-20' AND kode_barang='B1E-ZGAH-40-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 ('F226201254351','2026-07-20','0.610','2026-07-20','12:54:35','PLG0082389','645000','645000','5000','650000','650000','kasir','2026-07-20 12:54:35','F22620125435');
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-07-20','F226201254351','2026-07-20','12:54:35','TIN','650000','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-260720-0036','D','2026-07-20','12:54:35','kasir','PENJUALAN','F226201254351','12294263000','650000','12294913000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='650000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201254351' 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 ('F226201254352','kasir',' 1',' MFD1F 5K B','TOKO','SMBK-D','D1F-ZGAH-56-T','LT CHARM BULAN BINTANG SLEP BG 8K ','OL','0.520','1','100.00','554000','0','0','15000','559000','0','5000','0','564000','TIN','T0081361','D1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGAH-56-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-07-20' AND kode_barang='D1F-ZGAH-56-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 ('F226201254352','2026-07-20','0.520','2026-07-20','12:54:35','PLG0082390','559000','559000','5000','564000','564000','kasir','2026-07-20 12:54:35','F22620125435');
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-07-20','F226201254352','2026-07-20','12:54:35','TIN','564000','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-260720-0037','D','2026-07-20','12:54:35','kasir','PENJUALAN','F226201254352','12294913000','564000','12295477000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='564000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201254352' 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 ('F226201254353','kasir',' 1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZGAX-35-0','KL RANTAI HOLLOW KH 44 8K ','OL','2.000','1','100.00','2090000','0','0','15000','2100000','0','10000','0','2110000','TIN','00413111','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGAX-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='H1E-ZGAX-35-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 ('F226201254353','2026-07-20','2.000','2026-07-20','12:54:35','PLG0082391','2100000','2100000','10000','2110000','2110000','kasir','2026-07-20 12:54:35','F22620125435');
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-07-20','F226201254353','2026-07-20','12:54:35','TIN','2110000','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-260720-0038','D','2026-07-20','12:54:35','kasir','PENJUALAN','F226201254353','12295477000','2110000','12297587000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2110000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226201254353' 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 ('F226200126311','kasir','1',' MEF3 11K K','TOKO','SMBK-F','F3E-ZFBD-6-T','GL RANTAI HOLLOW P3 SLEP KH 8K ','OL','2.100','1','100.00','2194000','0','0','15000','2205000','0','11000','0','2216000','TIN','T0080694','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFBD-6-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='F3E-ZFBD-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 ('F226200126311','2026-07-20','2.100','2026-07-20','13:26:32','PLG0082392','2205000','2205000','11000','2216000','2216000','kasir','2026-07-20 13:26:31','F22620012631');
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-07-20','F226200126311','2026-07-20','13:26:32','TIN','2216000','11000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260720-0039','D','2026-07-20','13:26:32','kasir','PENJUALAN','F226200126311','12297587000','2216000','12299803000');
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 ('F226200158201','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-ZGAH-4-T','CC WEDDING MATA SLEP CM 16 8K ','','1.550','1','100.00','1589000','0','0','15000','1589000','0','10000','0','1599000','LUS','T0081309','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGAH-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='E2D-ZGAH-4-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 ('F226200158201','2026-07-20','1.550','2026-07-20','13:58:20','PLG0082393','1589000','1589000','10000','1599000','1599000','kasir','2026-07-20 13:58:20','F22620015820');
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-07-20','F226200158201','2026-07-20','13:58:20','LUS','1599000','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-260720-0040','D','2026-07-20','13:58:20','kasir','PENJUALAN','F226200158201','12299803000','1599000','12301402000');
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 ('F226200204251','kasir','1',' MEH1E UB 3','TOKO','SMBK-H','H1E-ZFBE-69-T','KL TIFF SPECTRA SLEP UB 39 8K ','OL','2.250','1','100.00','2351000','0','0','15000','2374000','0','11000','0','2385000','LUS','T0080811','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFBE-69-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.250',berat_jual_asli=berat_jual_asli+'2.250',stock_jual='1',berat_akhir=berat_akhir-'2.250',berat_akhir_asli=berat_akhir_asli-'2.250',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='H1E-ZFBE-69-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 ('F226200204251','2026-07-20','2.250','2026-07-20','14:04:26','PLG0082394','2374000','2374000','11000','2385000','2385000','kasir','2026-07-20 14:04:25','F22620020425');
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-07-20','F226200204251','2026-07-20','14:04:26','LUS','2385000','11000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260720-0041','D','2026-07-20','14:04:26','kasir','PENJUALAN','F226200204251','12301402000','2385000','12303787000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200126311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200126311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200126311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200158201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200158201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200158201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200204251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200204251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200204251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200829261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200829261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200829261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200837491' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200837491' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200837491';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200841311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200841311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200841311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200916421' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200916421' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200916421';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200944041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200944041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200944041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200944042' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200944042' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200944042';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201009331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201009331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201009331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201009332' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201009332' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201009332';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201010191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201010191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201010191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201013291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201013291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201013291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201013292' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201013292' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201013292';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201013293' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201013293' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201013293';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201013294' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201013294' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201013294';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201013295' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201013295' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201013295';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201013296' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201013296' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201013296';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201015341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201015341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201015341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201015342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201015342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201015342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201015343' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201015343' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201015343';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201015344' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201015344' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201015344';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201017341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201017341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201017341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201017342' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201017342' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201017342';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201017343' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201017343' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201017343';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201017344' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201017344' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201017344';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201017345' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201017345' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201017345';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201132301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201132301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201132301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201136571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201136571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201136571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201138081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201138081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201138081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201138441' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201138441' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201138441';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201139591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201139591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201139591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201139592' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201139592' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201139592';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201140511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201140511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201140511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201223431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201223431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201223431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201240521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201240521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201240521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201242311' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201242311' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201242311';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201254351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201254351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201254351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201254352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201254352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201254352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226201254353' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226201254353' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226201254353';
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 ('F226200236241','admin','1',' MEH1 15K U','TOKO','SMBK-H','H1E-ZDBX-1-T','KL ANAK SANTA BONEKA CAT VAR UB 8K ','OL','2.530','1','100.00','2644000','0','0','15000','2654000','0','15000','0','2669000','TIN','T0078736','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZDBX-1-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.530',berat_jual_asli=berat_jual_asli+'2.530',stock_jual='1',berat_akhir=berat_akhir-'2.530',berat_akhir_asli=berat_akhir_asli-'2.530',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='H1E-ZDBX-1-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 ('F226200236241','2026-07-20','2.530','2026-07-20','14:36:24','PLG0082395','2654000','2654000','15000','2669000','2669000','admin','2026-07-20 14:36:24','F22620023624');
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-07-20','F226200236241','2026-07-20','14:36:24','TIN','2669000','15000');
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-260720-0042','D','2026-07-20','14:36:24','admin','PENJUALAN','F226200236241','12303787000','2669000','12306456000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2669000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226200236241' 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 ('F226200236242','admin',' 1',' MED2E LG R','TOKO','SMBK-D','D2E-ZGAH-43-T','LT HURUF MATA LG R 8K ','OL','0.600','1','100.00','627000','0','0','15000','633000','0','5000','0','638000','TIN','T0081348','D2E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZGAH-43-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='D2E-ZGAH-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 ('F226200236242','2026-07-20','0.600','2026-07-20','14:36:24','PLG0082396','633000','633000','5000','638000','638000','admin','2026-07-20 14:36:24','F22620023624');
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-07-20','F226200236242','2026-07-20','14:36:24','TIN','638000','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-260720-0043','D','2026-07-20','14:36:24','admin','PENJUALAN','F226200236242','12306456000','638000','12307094000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='638000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226200236242' 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 ('F226200236243','admin',' 1',' MFD1F X HW','TOKO','SMBK-D','D1F-ZGXI-37-0','LT X SLOBOK RIBBON SLEP HW 8K ','OL','0.340','1','100.00','362000','0','0','15000','366000','0','5000','0','371000','TIN','00412756','D1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGXI-37-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.340',berat_jual_asli=berat_jual_asli+'0.340',stock_jual='1',berat_akhir=berat_akhir-'0.340',berat_akhir_asli=berat_akhir_asli-'0.340',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='D1F-ZGXI-37-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 ('F226200236243','2026-07-20','0.340','2026-07-20','14:36:24','PLG0082397','366000','366000','5000','371000','371000','admin','2026-07-20 14:36:24','F22620023624');
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-07-20','F226200236243','2026-07-20','14:36:24','TIN','371000','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-260720-0044','D','2026-07-20','14:36:24','admin','PENJUALAN','F226200236243','12307094000','371000','12307465000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='371000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226200236243' 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 ('F226200237151','admin','1',' MEH1E KH 4','TOKO','SMBK-H','H1E-ZGAH-30-T','KL SIEM COBRA KH 42 8K ','OL','1.300','1','100.00','1358000','0','0','15000','1365000','0','7000','0','1372000','TIN','T0081335','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZGAH-30-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.300',berat_jual_asli=berat_jual_asli+'1.300',stock_jual='1',berat_akhir=berat_akhir-'1.300',berat_akhir_asli=berat_akhir_asli-'1.300',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='H1E-ZGAH-30-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 ('F226200237151','2026-07-20','1.300','2026-07-20','14:37:15','PLG0082398','1365000','1365000','7000','1372000','1372000','admin','2026-07-20 14:37:15','F22620023715');
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-07-20','F226200237151','2026-07-20','14:37:15','TIN','1372000','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-260720-0045','D','2026-07-20','14:37:15','admin','PENJUALAN','F226200237151','12307465000','1372000','12308837000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1372000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226200237151' 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 ('F226200237152','admin',' 1',' MFD1F 5K B','TOKO','SMBK-D','D1F-ZGAE-37-T','LT CHARM PITA SLEP BG 8K ','OL','0.650','1','100.00','692000','0','0','15000','699000','0','5000','0','704000','TIN','T0081182','D1F','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-ZGAE-37-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.650',berat_jual_asli=berat_jual_asli+'0.650',stock_jual='1',berat_akhir=berat_akhir-'0.650',berat_akhir_asli=berat_akhir_asli-'0.650',stock_akhir='0' WHERE tanggal='2026-07-20' AND kode_barang='D1F-ZGAE-37-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 ('F226200237152','2026-07-20','0.650','2026-07-20','14:37:15','PLG0082399','699000','699000','5000','704000','704000','admin','2026-07-20 14:37:15','F22620023715');
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-07-20','F226200237152','2026-07-20','14:37:15','TIN','704000','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-260720-0046','D','2026-07-20','14:37:15','admin','PENJUALAN','F226200237152','12308837000','704000','12309541000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='704000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F226200237152' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200236241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200236241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200236241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200236242' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200236242' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200236242';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200236243' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200236243' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200236243';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200237151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200237151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200237151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200237152' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200237152' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200237152';
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-00005551','X-00005551','GW X DAISY MATA CM PE 8K','GR','---','B1E','BELI','BELI001','217000','2026-07-20','0.300','1','admin','2026-07-20 14:41:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00005551','X-00005551');
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-260720-0001','F225260925391','RHM','1','BELI','BELI001','B1E', 'X-00005551', 'GW X DAISY MATA CM PE 8K','0.500','0.300','100.00','418000','217000','723333','1045000','1','217000','217000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.300',berat_beli_asli=berat_beli_asli+'0.300',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.300',berat_akhir_asli=berat_akhir_asli+'0.300',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260720-0001','2026-07-20','2026-07-20','14:41:24','RHM','---','0.300','217000','217000','217000','217000','217000','admin','2026-07-20 14:41:25','FB-260720-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260720-0001','AYU','BETON SIMAN','','','085648315788','admin','2026-07-20 14:41:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-20' 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-260720-0047','K','2026-07-20','14:41:24','admin','PEMBELIAN UMUM','FB-260720-0001','12309541000','217000','12309324000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260720-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260720-0001';
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 ('F226200309451','kasir','1',' MED1E LG ','TOKO','SMBK-D','D1E-ZGAA-65-T','LT MODEL PITA SLEP LG 8K ','','0.520','1','100.00','543000','0','0','15000','543000','0','0','0','543000','TIN','T0081076','D1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-ZGAA-65-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-07-20' AND kode_barang='D1E-ZGAA-65-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 ('F226200309451','2026-07-20','0.520','2026-07-20','15:09:45','PLG0082400','543000','543000','0','543000','543000','kasir','2026-07-20 15:09:45','F22620030945');
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-07-20','F226200309451','2026-07-20','15:09:45','TIN','543000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260720-0048','D','2026-07-20','15:09:45','kasir','PENJUALAN','F226200309451','12309324000','543000','12309867000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F226200309451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F226200309451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F226200309451';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-21','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-20';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-20';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-20';
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-07-20' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-20';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-20';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-20';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-20';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-21' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-20' 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-260721-0001','D','2026-07-21','16:02:02','SYSTEM','SALDO AWAL','SALDO AWAL','0','12309867000','12309867000');
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-260721-0001','D','2026-07-21','16:02:02','BCA','SALDO AWAL','SALDO AWAL','0','4633692888','4633692888');
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-260721-0001','D','2026-07-21','16:02:02','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-260721-0001','D','2026-07-21','16:02:02','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-260721-0001','D','2026-07-21','16:02:02','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-260721-0001','D','2026-07-21','16:02:02','','SALDO AWAL','SALDO AWAL','0','2260000','2260000');
UPDATE tp_system SET tgl_system='2026-07-21';