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 ('F225140952271','kasir','1',' MHB1 CM ','TOKO','SMBK-B','B1H-YEBX-8-T','GW TUSUK DAISY MATA CM 8K ','OL ','0.260','1','100.00','254000','0','0','15000','283000','0','5000','0','288000','RHM','T0069380','B1H','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-YEBX-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='B1H-YEBX-8-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 ('F225140952271','2025-10-14','0.260','2025-10-14','09:52:28','PLG0073626','283000','283000','5000','288000','288000','kasir','2025-10-14 09:52:27','F22514095227');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140952271','2025-10-14','09:52:28','RHM','288000','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-251014-0002','D','2025-10-14','09:52:28','kasir','PENJUALAN','F225140952271','1425654000','288000','1425942000');
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 ('F225140953331','kasir','1',' MGB1 LG ','TOKO','SMBK-B','B1G-YGAH-48-T','GW TUSUK MRICAN POLOS LG 8K ','OL ','0.330','1','100.00','317000','0','0','15000','352000','0','5000','0','357000','RHM','T0071079','B1G','0','0','-','0','1058000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-YGAH-48-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.330',berat_jual_asli=berat_jual_asli+'0.330',stock_jual='1',berat_akhir=berat_akhir-'0.330',berat_akhir_asli=berat_akhir_asli-'0.330',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='B1G-YGAH-48-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 ('F225140953331','2025-10-14','0.330','2025-10-14','09:53:34','PLG0073627','352000','352000','5000','357000','0','kasir','2025-10-14 09:53:33','F22514095333');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140953331','2025-10-14','09:53:34','RHM','357000','5000');
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-251014-0001','2025-10-14','2025-10-14 09:53:33','PENJUALAN : F225140953331','754853853863683','BCA','357000','357000','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-251014-0002','D','2025-10-14','09:53:34','BCA','PENJUALAN','F225140953331','4052575888','357000','4052932888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('754853853863683','HHHH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='357000' WHERE no_faktur_jual='F225140953331' 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 ('F225140954131','kasir','1',' MGB1 CM ','TOKO','SMBK-B','B1G-YIBI-52-T','GW TOGE MODEL HATI CM 8K ','OL ','0.310','1','100.00','298000','0','0','15000','331000','0','5000','0','336000','RHM','T0073365','B1G','0','0','-','0','1058000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-YIBI-52-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.310',berat_jual_asli=berat_jual_asli+'0.310',stock_jual='1',berat_akhir=berat_akhir-'0.310',berat_akhir_asli=berat_akhir_asli-'0.310',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='B1G-YIBI-52-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 ('F225140954131','2025-10-14','0.310','2025-10-14','09:54:13','PLG0073628','331000','331000','5000','336000','0','kasir','2025-10-14 09:54:13','F22514095413');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140954131','2025-10-14','09:54:13','RHM','336000','5000');
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-251014-0002','2025-10-14','2025-10-14 09:54:13','PENJUALAN : F225140954131','653764373446734673','BCA','336000','336000','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-251014-0003','D','2025-10-14','09:54:13','BCA','PENJUALAN','F225140954131','4052932888','336000','4053268888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('653764373446734673','HHH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='336000' WHERE no_faktur_jual='F225140954131' 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 ('F225140954541','kasir','1',' MHB1 CM ','TOKO','SMBK-B','B1H-YCXD-75-T','GW TUSUK DAISY MATA CM 8K ','OL ','0.260','1','100.00','254000','0','0','15000','283000','0','5000','0','288000','RHM','T0067618','B1H','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-YCXD-75-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='2025-10-14' AND kode_barang='B1H-YCXD-75-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 ('F225140954541','2025-10-14','0.260','2025-10-14','09:54:55','PLG0073629','283000','283000','5000','288000','0','kasir','2025-10-14 09:54:54','F22514095454');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140954541','2025-10-14','09:54:55','RHM','288000','5000');
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-251014-0003','2025-10-14','2025-10-14 09:54:54','PENJUALAN : F225140954541','6536743734573473','BCA','288000','288000','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-251014-0004','D','2025-10-14','09:54:55','BCA','PENJUALAN','F225140954541','4053268888','288000','4053556888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('6536743734573473','HHH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='288000' WHERE no_faktur_jual='F225140954541' 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 ('F225141022121','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YIBI-83-T','LT SLOBOK BALOK HURUF BG T 8K ','OL S 32AG','0.360','1','100.00','346000','0','0','15000','381000','0','73000','0','454000','RHM','T0073396','D1G','0','0','-','0','1058000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YIBI-83-T' 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='2025-10-14' AND kode_barang='D1G-YIBI-83-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 ('F225141022121','2025-10-14','0.360','2025-10-14','10:22:12','PLG0073630','381000','381000','73000','454000','454000','kasir','2025-10-14 10:22:12','F22514102212');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141022121','2025-10-14','10:22:12','RHM','454000','73000');
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-251014-0003','D','2025-10-14','10:22:12','kasir','PENJUALAN','F225141022121','1425942000','454000','1426396000');
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 ('F225141052171','kasir','1',' TDE2 LT 13','TOKO','TBK-E','E2TD-YHAC-178-T','CC MODEL MATA VAR LT 13 17K ','OL ','0.950','1','100.00','1542000','0','0','15000','1768000','0','7000','0','1775000','RHM','T0072318','E2TD','0','0','-','0','1623000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2TD-YHAC-178-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='E2TD-YHAC-178-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 ('F225141052171','2025-10-14','0.950','2025-10-14','10:52:18','PLG0073631','1768000','1768000','7000','1775000','1775000','kasir','2025-10-14 10:52:17','F22514105217');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141052171','2025-10-14','10:52:18','RHM','1775000','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-251014-0004','D','2025-10-14','10:52:18','kasir','PENJUALAN','F225141052171','1426396000','1775000','1428171000');
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 ('F225141055511','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-YJXD-21-T','AT GYPSY MRICAN VAR LG 8K ','OL ','0.530','1','100.00','517000','0','0','15000','553000','0','5000','0','558000','RHM','T0073835','A1E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJXD-21-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='A1E-YJXD-21-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 ('F225141055511','2025-10-14','0.530','2025-10-14','10:55:52','PLG0073632','553000','553000','5000','558000','558000','kasir','2025-10-14 10:55:51','F22514105551');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141055511','2025-10-14','10:55:52','RHM','558000','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-251014-0005','D','2025-10-14','10:55:52','kasir','PENJUALAN','F225141055511','1428171000','558000','1428729000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='558000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225141055511' 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 ('F225141055512','kasir',' 1',' MEE1 LG 12','TOKO','SMBK-E','E1E-YJXF-32-T','CC MODEL DAUN VAR LG 12 8K ','OL ','0.430','1','100.00','420000','0','0','15000','448000','0','5000','0','453000','RHM','T0073930','E1E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YJXF-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.430',berat_jual_asli=berat_jual_asli+'0.430',stock_jual='1',berat_akhir=berat_akhir-'0.430',berat_akhir_asli=berat_akhir_asli-'0.430',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='E1E-YJXF-32-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225141055512','2025-10-14','0.430','2025-10-14','10:55:52','PLG0073633','448000','448000','5000','453000','453000','kasir','2025-10-14 10:55:51','F22514105551');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141055512','2025-10-14','10:55:52','RHM','453000','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-251014-0006','D','2025-10-14','10:55:52','kasir','PENJUALAN','F225141055512','1428729000','453000','1429182000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='453000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225141055512' 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 ('F225141055513','kasir',' 1',' MEE2 HTM 1','TOKO','SMBK-E','E2E-YJXF-25-T','CC PIPA MODEL HATI MATA HTM 17 8K ','OL ','0.560','1','100.00','547000','0','0','15000','584000','0','5000','0','589000','RHM','T0073923','E2E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXF-25-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='E2E-YJXF-25-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 ('F225141055513','2025-10-14','0.560','2025-10-14','10:55:52','PLG0073634','584000','584000','5000','589000','589000','kasir','2025-10-14 10:55:51','F22514105551');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141055513','2025-10-14','10:55:52','RHM','589000','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-251014-0007','D','2025-10-14','10:55:52','kasir','PENJUALAN','F225141055513','1429182000','589000','1429771000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='589000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225141055513' 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 ('F225141055514','kasir',' 1',' MEE2 HTM 1','TOKO','SMBK-E','E2E-YJXF-29-T','CC PIPA MODEL HATI MATA HTM 19 8K ','OL ','0.580','1','100.00','567000','0','0','15000','605000','0','5000','0','610000','RHM','T0073927','E2E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXF-29-T' 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='2025-10-14' AND kode_barang='E2E-YJXF-29-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 ('F225141055514','2025-10-14','0.580','2025-10-14','10:55:52','PLG0073635','605000','605000','5000','610000','610000','kasir','2025-10-14 10:55:51','F22514105551');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141055514','2025-10-14','10:55:52','RHM','610000','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-251014-0008','D','2025-10-14','10:55:52','kasir','PENJUALAN','F225141055514','1429771000','610000','1430381000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='610000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225141055514' 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 ('F225141055515','kasir',' 1',' MHB1H X AV','TOKO','SMBK-B','B1H-YJXD-82-0','GW X MRICAN SLEP AV 8K ','OL ','0.260','1','100.00','270000','0','0','15000','287000','0','5000','0','292000','RHM','00372062','B1H','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-YJXD-82-0' 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='2025-10-14' AND kode_barang='B1H-YJXD-82-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 ('F225141055515','2025-10-14','0.260','2025-10-14','10:55:52','PLG0073636','287000','287000','5000','292000','292000','kasir','2025-10-14 10:55:51','F22514105551');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141055515','2025-10-14','10:55:52','RHM','292000','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-251014-0009','D','2025-10-14','10:55:52','kasir','PENJUALAN','F225141055515','1430381000','292000','1430673000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='292000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225141055515' 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 ('F225141055516','kasir',' 1',' MEF3 5K LT','TOKO','SMBK-F','F3E-YJXF-55-T','GL RANTAI HOLLOW P3 SLEP LT 8K ','OL ','1.050','1','100.00','1026000','0','0','15000','1090000','0','5000','0','1095000','RHM','T0073953','F3E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJXF-55-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='F3E-YJXF-55-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 ('F225141055516','2025-10-14','1.050','2025-10-14','10:55:52','PLG0073637','1090000','1090000','5000','1095000','1095000','kasir','2025-10-14 10:55:51','F22514105551');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141055516','2025-10-14','10:55:52','RHM','1095000','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-251014-0010','D','2025-10-14','10:55:52','kasir','PENJUALAN','F225141055516','1430673000','1095000','1431768000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1095000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225141055516' 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 ('F225141055517','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-YBXA-70-T','GL HARLEY HW 8K ','OL ','1.980','1','100.00','1835000','0','0','15000','2053000','0','10000','0','2063000','RHM','T0066457','F3E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YBXA-70-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.980',berat_jual_asli=berat_jual_asli+'1.980',stock_jual='1',berat_akhir=berat_akhir-'1.980',berat_akhir_asli=berat_akhir_asli-'1.980',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='F3E-YBXA-70-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 ('F225141055517','2025-10-14','1.980','2025-10-14','10:55:52','PLG0073638','2053000','2053000','10000','2063000','2063000','kasir','2025-10-14 10:55:51','F22514105551');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141055517','2025-10-14','10:55:52','RHM','2063000','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-251014-0011','D','2025-10-14','10:55:52','kasir','PENJUALAN','F225141055517','1431768000','2063000','1433831000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2063000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225141055517' 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 ('F225141055518','kasir',' 1',' MEF3E X YT','TOKO','SMBK-F','F3E-YIAE-203-0','GL X TIFF SPECTRA VAR YT 8K ','OL ','2.730','1','100.00','2757000','0','0','15000','2831000','0','14000','0','2845000','RHM','00369654','F3E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIAE-203-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.730',berat_jual_asli=berat_jual_asli+'2.730',stock_jual='1',berat_akhir=berat_akhir-'2.730',berat_akhir_asli=berat_akhir_asli-'2.730',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='F3E-YIAE-203-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 ('F225141055518','2025-10-14','2.730','2025-10-14','10:55:52','PLG0073639','2831000','2831000','14000','2845000','2845000','kasir','2025-10-14 10:55:51','F22514105551');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141055518','2025-10-14','10:55:52','RHM','2845000','14000');
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-251014-0012','D','2025-10-14','10:55:52','kasir','PENJUALAN','F225141055518','1433831000','2845000','1436676000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2845000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225141055518' 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 ('F225141057021','kasir','1',' MEE2 X LG ','TOKO','SMBK-E','E2E-YJAA-48-0','CC X MODEL MATA LG 14 8K ','OL ','0.500','1','100.00','505000','0','0','15000','521000','0','5000','0','526000','RHM','00372586','E2E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJAA-48-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='E2E-YJAA-48-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 ('F225141057021','2025-10-14','0.500','2025-10-14','10:57:02','PLG0073640','521000','521000','5000','526000','526000','kasir','2025-10-14 10:57:02','F22514105702');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141057021','2025-10-14','10:57:02','RHM','526000','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-251014-0013','D','2025-10-14','10:57:02','kasir','PENJUALAN','F225141057021','1436676000','526000','1437202000');
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 ('F225141110201','kasir','1',' MEF1 X YT ','TOKO','SMBK-F','F1E-YHBH-9-0','GL X OVAL C GELOMBANG YT 52 8K ','OL','3.450','1','100.00','3198000','0','0','15000','3530000','0','17000','0','3547000','TIN','00366995','F1E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YHBH-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.450',berat_jual_asli=berat_jual_asli+'3.450',stock_jual='1',berat_akhir=berat_akhir-'3.450',berat_akhir_asli=berat_akhir_asli-'3.450',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='F1E-YHBH-9-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 ('F225141110201','2025-10-14','3.450','2025-10-14','11:10:20','PLG0073641','3530000','3530000','17000','3547000','3547000','kasir','2025-10-14 11:10:20','F22514111020');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141110201','2025-10-14','11:10:20','TIN','3547000','17000');
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-251014-0014','D','2025-10-14','11:10:20','kasir','PENJUALAN','F225141110201','1437202000','3547000','1440749000');
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 ('F225141152261','kasir','1',' MDE2 8K CM','TOKO','SMBK-E','E2D-YJXA-55-T','CC MODEL SOLITAIRE MATA CM 12 8K ','','1.010','1','100.00','939000','0','0','15000','1020000','0','8000','0','1028000','RHM','T0073547','E2D','0','0','-','0','998000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YJXA-55-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='E2D-YJXA-55-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 ('F225141152261','2025-10-14','1.010','2025-10-14','11:52:27','PLG0073642','1020000','1020000','8000','1028000','1028000','kasir','2025-10-14 11:52:26','F22514115226');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141152261','2025-10-14','11:52:27','RHM','1028000','8000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251014-0015','D','2025-10-14','11:52:27','kasir','PENJUALAN','F225141152261','1440749000','1028000','1441777000');
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 ('F225141212511','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-YJXD-18-T','AT GYPSY HATI VAR LG 8K ','OL','0.550','1','100.00','536000','0','0','15000','-5000','0','5000','0','0','RHM','T0073832','A1E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJXD-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='A1E-YJXD-18-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 ('F225141212511','2025-10-14','0.550','2025-10-14','12:12:51','PLG0073643','-5000','-5000','5000','0','0','kasir','2025-10-14 12:12:51','F22514121251');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141212511','2025-10-14','12:12:51','RHM','0','5000');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225141212511' 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 ('F225141212512','kasir',' 1',' MEA1 BW ','TOKO','SMBK-A','A1E-YJXB-65-T','AT MODEL ITALY PANJANG VAR BW 8K ','OL','0.520','1','100.00','508000','0','0','15000','543000','0','5000','0','548000','RHM','T0073645','A1E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJXB-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='2025-10-14' AND kode_barang='A1E-YJXB-65-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 ('F225141212512','2025-10-14','0.520','2025-10-14','12:12:51','PLG0073644','543000','543000','5000','548000','548000','kasir','2025-10-14 12:12:51','F22514121251');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141212512','2025-10-14','12:12:51','RHM','548000','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-251014-0016','D','2025-10-14','12:12:51','kasir','PENJUALAN','F225141212512','1441777000','548000','1442325000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='548000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225141212512' 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 ('F225141212513','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YHBH-203-T','LT SLOBOK BALOK HURUF BG D 8K ','','0.370','1','100.00','356000','0','0','15000','401000','0','5000','0','406000','RHM','T0072699','D1G','0','0','-','0','1058000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YHBH-203-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='2025-10-14' AND kode_barang='D1G-YHBH-203-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 ('F225141212513','2025-10-14','0.370','2025-10-14','12:12:51','PLG0073645','401000','401000','5000','406000','406000','kasir','2025-10-14 12:12:51','F22514121251');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141212513','2025-10-14','12:12:51','RHM','406000','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-251014-0017','D','2025-10-14','12:12:51','kasir','PENJUALAN','F225141212513','1442325000','406000','1442731000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='406000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225141212513' 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 ('F225141212514','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YJXB-78-T','LT SLOBOK BOLA KRAWANG BG 8K ','OL','0.250','1','100.00','254000','0','0','15000','271000','0','5000','0','276000','RHM','T0073658','D1G','0','0','-','0','1058000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YJXB-78-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='2025-10-14' AND kode_barang='D1G-YJXB-78-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 ('F225141212514','2025-10-14','0.250','2025-10-14','12:12:51','PLG0073646','271000','271000','5000','276000','276000','kasir','2025-10-14 12:12:51','F22514121251');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141212514','2025-10-14','12:12:51','RHM','276000','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-251014-0018','D','2025-10-14','12:12:51','kasir','PENJUALAN','F225141212514','1442731000','276000','1443007000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='276000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225141212514' 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 ('F225141212515','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YJXB-80-T','LT SLOBOK BOLA KRAWANG BG 8K ','OL','0.250','1','100.00','254000','0','0','15000','271000','0','5000','0','276000','RHM','T0073660','D1G','0','0','-','0','1058000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YJXB-80-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='2025-10-14' AND kode_barang='D1G-YJXB-80-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 ('F225141212515','2025-10-14','0.250','2025-10-14','12:12:51','PLG0073647','271000','271000','5000','276000','276000','kasir','2025-10-14 12:12:51','F22514121251');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141212515','2025-10-14','12:12:51','RHM','276000','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-251014-0019','D','2025-10-14','12:12:51','kasir','PENJUALAN','F225141212515','1443007000','276000','1443283000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='276000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225141212515' 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 ('F225141212516','kasir',' 1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YJXB-81-T','LT SLOBOK BOLA KRAWANG BG 8K ','OL','0.260','1','100.00','264000','0','0','15000','282000','0','5000','0','287000','RHM','T0073661','D1G','0','0','-','0','1058000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YJXB-81-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='2025-10-14' AND kode_barang='D1G-YJXB-81-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 ('F225141212516','2025-10-14','0.260','2025-10-14','12:12:51','PLG0073648','282000','282000','5000','287000','287000','kasir','2025-10-14 12:12:51','F22514121251');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141212516','2025-10-14','12:12:51','RHM','287000','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-251014-0020','D','2025-10-14','12:12:51','kasir','PENJUALAN','F225141212516','1443283000','287000','1443570000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='287000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225141212516' 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 ('F225141212517','kasir',' 1',' MFD1F X LG','TOKO','SMBK-D','D1F-YIAB-78-0','LT X SLOBOK BOLA MATA LG 8K ','OL','0.890','1','100.00','840000','0','0','15000','943000','0','10000','0','953000','RHM','00368855','D1F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YIAB-78-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.890',berat_jual_asli=berat_jual_asli+'0.890',stock_jual='1',berat_akhir=berat_akhir-'0.890',berat_akhir_asli=berat_akhir_asli-'0.890',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='D1F-YIAB-78-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 ('F225141212517','2025-10-14','0.890','2025-10-14','12:12:51','PLG0073649','943000','943000','10000','953000','953000','kasir','2025-10-14 12:12:51','F22514121251');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141212517','2025-10-14','12:12:51','RHM','953000','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-251014-0021','D','2025-10-14','12:12:51','kasir','PENJUALAN','F225141212517','1443570000','953000','1444523000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='953000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225141212517' 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 ('F225141212518','kasir',' 1',' MGD1G X BG','TOKO','SMBK-D','D1G-YABX-35-0','LT X SLOBOK BALOK HURUF BG J 8K ','OL','0.380','1','100.00','365000','0','0','15000','412000','0','5000','0','417000','RHM','00335048','D1G','0','0','-','0','1058000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YABX-35-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='D1G-YABX-35-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 ('F225141212518','2025-10-14','0.380','2025-10-14','12:12:51','PLG0073650','412000','412000','5000','417000','417000','kasir','2025-10-14 12:12:51','F22514121251');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141212518','2025-10-14','12:12:51','RHM','417000','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-251014-0022','D','2025-10-14','12:12:51','kasir','PENJUALAN','F225141212518','1444523000','417000','1444940000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='417000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225141212518' 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 ('F225141212519','kasir',' 1',' MFH1 UB 46','TOKO','SMBK-H','H1F-YJXF-46-T','KL KOREA UB 46CM 8K ','OL','1.000','1','100.00','997000','0','0','15000','1060000','0','5000','0','1065000','RHM','T0073944','H1F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YJXF-46-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='2025-10-14' AND kode_barang='H1F-YJXF-46-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 ('F225141212519','2025-10-14','1.000','2025-10-14','12:12:51','PLG0073651','1060000','1060000','5000','1065000','1065000','kasir','2025-10-14 12:12:51','F22514121251');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141212519','2025-10-14','12:12:51','RHM','1065000','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-251014-0023','D','2025-10-14','12:12:51','kasir','PENJUALAN','F225141212519','1444940000','1065000','1446005000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1065000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225141212519' 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 ('F225141220571','kasir','1',' MFH1 UB 46','TOKO','SMBK-H','H1F-YJXF-44-T','KL KOREA UB 46CM 8K ','OL','1.000','1','100.00','997000','0','0','15000','1060000','0','5000','0','1065000','RHM','T0073942','H1F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YJXF-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='2025-10-14' AND kode_barang='H1F-YJXF-44-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 ('F225141220571','2025-10-14','1.000','2025-10-14','12:20:58','PLG0073652','1060000','1060000','5000','1065000','1065000','kasir','2025-10-14 12:20:57','F22514122057');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141220571','2025-10-14','12:20:58','RHM','1065000','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-251014-0024','D','2025-10-14','12:20:58','kasir','PENJUALAN','F225141220571','1446005000','1065000','1447070000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1065000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225141220571' 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 ('F225141220572','kasir',' 1',' MFH1 UB 46','TOKO','SMBK-H','H1F-YJXF-45-T','KL KOREA UB 46CM 8K ','OL','0.970','1','100.00','967000','0','0','15000','1033000','0','5000','0','1038000','RHM','T0073943','H1F','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YJXF-45-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='H1F-YJXF-45-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 ('F225141220572','2025-10-14','0.970','2025-10-14','12:20:58','PLG0073653','1033000','1033000','5000','1038000','1038000','kasir','2025-10-14 12:20:57','F22514122057');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141220572','2025-10-14','12:20:58','RHM','1038000','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-251014-0025','D','2025-10-14','12:20:58','kasir','PENJUALAN','F225141220572','1447070000','1038000','1448108000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1038000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225141220572' 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 ('F225141220573','kasir',' 1',' MEH1 X KH ','TOKO','SMBK-H','H1E-YIAB-208-0','KL X RANTAI HOLLOW KH 42 8K ','OL','2.060','1','100.00','1910000','0','0','15000','2143000','0','10000','0','2153000','RHM','00368985','H1E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YIAB-208-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.060',berat_jual_asli=berat_jual_asli+'2.060',stock_jual='1',berat_akhir=berat_akhir-'2.060',berat_akhir_asli=berat_akhir_asli-'2.060',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='H1E-YIAB-208-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 ('F225141220573','2025-10-14','2.060','2025-10-14','12:20:58','PLG0073654','2143000','2143000','10000','2153000','2153000','kasir','2025-10-14 12:20:57','F22514122057');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141220573','2025-10-14','12:20:58','RHM','2153000','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-251014-0026','D','2025-10-14','12:20:58','kasir','PENJUALAN','F225141220573','1448108000','2153000','1450261000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2153000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225141220573' 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 ('F225141223141','kasir','1',' MEB1 X LG ','TOKO','SMBK-B','B1E-YJXD-79-0','GW X MODEL MATA LG PE 8K ','OL','0.670','1','100.00','655000','0','0','15000','700000','0','5000','0','705000','TJ','00372059','B1E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJXD-79-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.670',berat_jual_asli=berat_jual_asli+'0.670',stock_jual='1',berat_akhir=berat_akhir-'0.670',berat_akhir_asli=berat_akhir_asli-'0.670',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='B1E-YJXD-79-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 ('F225141223141','2025-10-14','0.670','2025-10-14','12:23:15','PLG0073655','700000','700000','5000','705000','705000','kasir','2025-10-14 12:23:14','F22514122314');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141223141','2025-10-14','12:23:15','TJ','705000','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-251014-0027','D','2025-10-14','12:23:15','kasir','PENJUALAN','F225141223141','1450261000','705000','1450966000');
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 ('F225141223451','kasir','1',' MCB0C X DG','TOKO','SMBK-B','B0C-YJXD-147-0','GW X BOTORAN DG 8K ','OL','0.550','1','100.00','515000','0','0','15000','564000','0','5000','0','569000','TJ','00372127','B0C','0','0','-','0','937000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B0C-YJXD-147-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='B0C-YJXD-147-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225141223451','2025-10-14','0.550','2025-10-14','12:23:45','PLG0073656','564000','564000','5000','569000','569000','kasir','2025-10-14 12:23:45','F22514122345');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141223451','2025-10-14','12:23:45','TJ','569000','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-251014-0028','D','2025-10-14','12:23:45','kasir','PENJUALAN','F225141223451','1450966000','569000','1451535000');
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 ('F225141224211','kasir','1',' MEE1 X LG ','TOKO','SMBK-E','E1E-YGAG-184-0','CC X MODEL CAT HITAM LG 14 8K ','OL','0.480','1','100.00','485000','0','0','15000','502000','0','5000','0','507000','TJ','00361269','E1E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YGAG-184-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.480',berat_jual_asli=berat_jual_asli+'0.480',stock_jual='1',berat_akhir=berat_akhir-'0.480',berat_akhir_asli=berat_akhir_asli-'0.480',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='E1E-YGAG-184-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 ('F225141224211','2025-10-14','0.480','2025-10-14','12:24:21','PLG0073657','502000','502000','5000','507000','507000','kasir','2025-10-14 12:24:21','F22514122421');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141224211','2025-10-14','12:24:21','TJ','507000','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-251014-0029','D','2025-10-14','12:24:21','kasir','PENJUALAN','F225141224211','1451535000','507000','1452042000');
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 ('F225141225381','kasir','1',' MEF3E X UB','TOKO','SMBK-F','F3E-YJAA-162-0','GL X RANTAI DOBEL D SLEP UB 8K ','OL','2.080','1','100.00','2101000','0','0','15000','2153000','0','10000','0','2163000','TIN','00372700','F3E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJAA-162-0' 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='2025-10-14' AND kode_barang='F3E-YJAA-162-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 ('F225141225381','2025-10-14','2.080','2025-10-14','12:25:38','PLG0073658','2153000','2153000','10000','2163000','2163000','kasir','2025-10-14 12:25:38','F22514122538');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141225381','2025-10-14','12:25:38','TIN','2163000','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-251014-0030','D','2025-10-14','12:25:38','kasir','PENJUALAN','F225141225381','1452042000','2163000','1454205000');
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 ('F225141228281','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-YJXD-18-T','AT GYPSY HATI VAR LG 8K ','OL','0.550','1','100.00','536000','0','0','15000','575000','0','5000','0','580000','RHM','T0073832','A1E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJXD-18-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='A1E-YJXD-18-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 ('F225141228281','2025-10-14','0.550','2025-10-14','12:28:29','PLG0073659','575000','575000','5000','580000','580000','kasir','2025-10-14 12:28:28','F22514122828');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141228281','2025-10-14','12:28:29','RHM','580000','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-251014-0031','D','2025-10-14','12:28:29','kasir','PENJUALAN','F225141228281','1454205000','580000','1454785000');
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 ('F225141242021','kasir','1',' MEH1 X KH ','TOKO','SMBK-H','H1E-YIAB-209-0','KL X SANTA KH 42 8K ','OL','2.070','1','100.00','1919000','0','0','15000','2143000','0','10000','0','2153000','TIN','00368986','H1E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YIAB-209-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='H1E-YIAB-209-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 ('F225141242021','2025-10-14','2.070','2025-10-14','12:42:03','PLG0073660','2143000','2143000','10000','2153000','2153000','kasir','2025-10-14 12:42:02','F22514124202');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225141242021','2025-10-14','12:42:03','TIN','2153000','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-251014-0032','D','2025-10-14','12:42:03','kasir','PENJUALAN','F225141242021','1454785000','2153000','1456938000');
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 ('F225140109481','kasir','1',' MDE2 LG 16','TOKO','SMBK-E','E2D-YHAB-4-T','CC MODEL MATA VAR LG 16 8K ','','1.010','1','100.00','919000','0','0','15000','1020000','0','0','0','1020000','RTA','T0072211','E2D','0','0','-','0','998000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YHAB-4-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='E2D-YHAB-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 ('F225140109481','2025-10-14','1.010','2025-10-14','13:09:49','PLG0073661','1020000','1020000','0','1020000','0','kasir','2025-10-14 13:09:48','F22514010948');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140109481','2025-10-14','13:09:49','RTA','1020000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251014-0004','2025-10-14','2025-10-14 13:09:48','PENJUALAN : F225140109481','8787766765','BCA','1020000','1020000','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-251014-0005','D','2025-10-14','13:09:49','BCA','PENJUALAN','F225140109481','4053556888','1020000','4054576888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('8787766765','ALVI');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140109481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140109481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140109481';
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 ('F225140116321','kasir','1',' MDB1 X LG ','TOKO','SMBK-B','B1D-YIAE-148-0','GW X DAISY MATA LG PE 8K ','OL','1.010','1','100.00','919000','0','0','15000','1040000','0','15000','0','1055000','TIN','00369599','B1D','0','0','-','0','998000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-YIAE-148-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.010',berat_jual_asli=berat_jual_asli+'1.010',stock_jual='1',berat_akhir=berat_akhir-'1.010',berat_akhir_asli=berat_akhir_asli-'1.010',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='B1D-YIAE-148-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 ('F225140116321','2025-10-14','1.010','2025-10-14','13:16:32','PLG0073662','1040000','1040000','15000','1055000','1055000','kasir','2025-10-14 13:16:32','F22514011632');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140116321','2025-10-14','13:16:32','TIN','1055000','15000');
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-251014-0033','D','2025-10-14','13:16:32','kasir','PENJUALAN','F225140116321','1456938000','1055000','1457993000');
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 ('F225140146351','kasir','1',' MGB1 LG ','TOKO','SMBK-B','B1G-YCAE-40-T','GW TUSUK MRICAN POLOS LG 8K ','OLS 1VYS','0.360','1','100.00','346000','0','0','15000','392000','0','50000','0','442000','RHM','T0067783','B1G','0','0','-','0','1058000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-YCAE-40-T' 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='2025-10-14' AND kode_barang='B1G-YCAE-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 ('F225140146351','2025-10-14','0.360','2025-10-14','13:46:35','PLG0073663','392000','392000','50000','442000','442000','kasir','2025-10-14 13:46:35','F22514014635');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140146351','2025-10-14','13:46:35','RHM','442000','50000');
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-251014-0034','D','2025-10-14','13:46:35','kasir','PENJUALAN','F225140146351','1457993000','442000','1458435000');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJAD-1-T','T0074027','MEH1 UB 42 ','KL CASTELI UB 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','1995500','2025-10-14','1995500','1.960','100.00','8','0','1018000.00','1','0.04', 'input','2025-10-14 13:47:40','1.960','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJAD-1-T','T0074027');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','H1E-YJAD-1-T','H1E','TOKO','01-SEM','100.00','1.960','1.960','1','1.960','1.960','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJAD-2-T','T0074028','MEH1 KH 35 ','KL NORY ANAK KH 35CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','2128000','2025-10-14','2128000','2.090','100.00','8','0','1018000.00','1','0.04', 'input','2025-10-14 13:52:35','2.090','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJAD-2-T','T0074028');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','H1E-YJAD-2-T','H1E','TOKO','01-SEM','100.00','2.090','2.090','1','2.090','2.090','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJAD-3-T','T0074029','MEH1 UB 42 ','KL GUCI UB 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','2036000','2025-10-14','2036000','2.000','100.00','8','0','1018000.00','1','0.04', 'input','2025-10-14 13:55:28','2.000','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJAD-3-T','T0074029');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','H1E-YJAD-3-T','H1E','TOKO','01-SEM','100.00','2.000','2.000','1','2.000','2.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJAD-4-T','T0074030','MEH1 KH 42 ','KL SANTA KH 42 CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','2077000','2025-10-14','2077000','2.040','100.00','8','0','1018000.00','1','0.04', 'input','2025-10-14 13:59:13','2.040','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJAD-4-T','T0074030');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','H1E-YJAD-4-T','H1E','TOKO','01-SEM','100.00','2.040','2.040','1','2.040','2.040','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJAD-5-T','T0074031','MEH1 KH 44 ','KL SANTA KH 44CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','2117500','2025-10-14','2117500','2.080','100.00','8','','1018000.00','1','0.04', 'input','2025-10-14 14:02:07','2.080','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJAD-5-T','T0074031');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','H1E-YJAD-5-T','H1E','TOKO','01-SEM','100.00','2.080','2.080','1','2.080','2.080','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJAD-6-T','T0074032','MEH1 KH 44 ','KL SANTA KH 44CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','2067000','2025-10-14','2067000','2.030','100.00','8','','1018000.00','1','0.04', 'input','2025-10-14 14:03:18','2.030','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJAD-6-T','T0074032');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','H1E-YJAD-6-T','H1E','TOKO','01-SEM','100.00','2.030','2.030','1','2.030','2.030','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJAD-7-T','T0074033','MEH1 KH 42 ','KL SANTA KH 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','2046500','2025-10-14','2046500','2.010','100.00','8','','1018000.00','1','0.04', 'input','2025-10-14 14:04:41','2.010','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJAD-7-T','T0074033');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','H1E-YJAD-7-T','H1E','TOKO','01-SEM','100.00','2.010','2.010','1','2.010','2.010','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJAD-8-T','T0074034','MEH1 KH 44 ','KL HOLLOW KH 44CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','2097500','2025-10-14','2097500','2.060','100.00','8','','1018000.00','1','0.04', 'input','2025-10-14 14:08:16','2.060','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJAD-8-T','T0074034');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','H1E-YJAD-8-T','H1E','TOKO','01-SEM','100.00','2.060','2.060','1','2.060','2.060','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJAD-9-T','T0074035','MEH1 KH 42 ','KL HOLLOW KH 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','2107500','2025-10-14','2107500','2.070','100.00','8','','1018000.00','1','0.04', 'input','2025-10-14 14:10:11','2.070','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJAD-9-T','T0074035');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','H1E-YJAD-9-T','H1E','TOKO','01-SEM','100.00','2.070','2.070','1','2.070','2.070','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJAD-10-T','T0074036','MEH1 KH 44 ','KL HOLLOW KH 44CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','4143500','2025-10-14','4143500','4.070','100.00','8','','1018000.00','1','0.04', 'input','2025-10-14 14:12:03','4.070','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJAD-10-T','T0074036');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','H1E-YJAD-10-T','H1E','TOKO','01-SEM','100.00','4.070','4.070','1','4.070','4.070','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0001','1','H1E-YJAD-1-T','1','1.96','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJAD-1-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-H','H1E','H1E-YJAD-1-T' , '1','1.96','1.96', '1','1.96','1.96','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.96',berat_out_asli=berat_out_asli+'1.96',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJAD-1-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0001','2','H1E-YJAD-10-T','1','4.07','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJAD-10-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-H','H1E','H1E-YJAD-10-T' , '1','4.07','4.07', '1','4.07','4.07','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.07',berat_out_asli=berat_out_asli+'4.07',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJAD-10-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0001','3','H1E-YJAD-2-T','1','2.09','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJAD-2-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-H','H1E','H1E-YJAD-2-T' , '1','2.09','2.09', '1','2.09','2.09','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.09',berat_out_asli=berat_out_asli+'2.09',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJAD-2-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0001','4','H1E-YJAD-3-T','1','2','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJAD-3-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-H','H1E','H1E-YJAD-3-T' , '1','2','2', '1','2','2','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2',berat_out_asli=berat_out_asli+'2',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJAD-3-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0001','5','H1E-YJAD-4-T','1','2.04','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJAD-4-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-H','H1E','H1E-YJAD-4-T' , '1','2.04','2.04', '1','2.04','2.04','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.04',berat_out_asli=berat_out_asli+'2.04',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJAD-4-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0001','6','H1E-YJAD-5-T','1','2.08','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJAD-5-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-H','H1E','H1E-YJAD-5-T' , '1','2.08','2.08', '1','2.08','2.08','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.08',berat_out_asli=berat_out_asli+'2.08',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJAD-5-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0001','7','H1E-YJAD-6-T','1','2.03','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJAD-6-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-H','H1E','H1E-YJAD-6-T' , '1','2.03','2.03', '1','2.03','2.03','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.03',berat_out_asli=berat_out_asli+'2.03',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJAD-6-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0001','8','H1E-YJAD-7-T','1','2.01','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJAD-7-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-H','H1E','H1E-YJAD-7-T' , '1','2.01','2.01', '1','2.01','2.01','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.01',berat_out_asli=berat_out_asli+'2.01',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJAD-7-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0001','9','H1E-YJAD-8-T','1','2.06','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJAD-8-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-H','H1E','H1E-YJAD-8-T' , '1','2.06','2.06', '1','2.06','2.06','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.06',berat_out_asli=berat_out_asli+'2.06',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJAD-8-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0001','10','H1E-YJAD-9-T','1','2.07','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJAD-9-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-H','H1E','H1E-YJAD-9-T' , '1','2.07','2.07', '1','2.07','2.07','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.07',berat_out_asli=berat_out_asli+'2.07',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJAD-9-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-251014-0001','2025-10-14','2025-10-14','14:15','22.41','input','2025-10-14 14:15:45');
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 ('F225140229561','kasir','1',' MEA1 BW ','TOKO','SMBK-A','A1E-YJXC-75-T','AT MODEL ITALY PANJANG VAR BW 8K ','OL','0.530','1','100.00','517000','0','0','15000','554000','0','5000','0','559000','TIN','T0073796','A1E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJXC-75-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='A1E-YJXC-75-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 ('F225140229561','2025-10-14','0.530','2025-10-14','14:29:57','PLG0073664','554000','554000','5000','559000','559000','kasir','2025-10-14 14:29:56','F22514022956');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140229561','2025-10-14','14:29:57','TIN','559000','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-251014-0035','D','2025-10-14','14:29:57','kasir','PENJUALAN','F225140229561','1458435000','559000','1458994000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='559000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225140229561' 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 ('F225140229562','kasir',' 1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YJXD-72-T','GW TUSUK MODEL MATA VAR LG PE 8K ','OL','0.530','1','100.00','517000','0','0','15000','554000','0','5000','0','559000','TIN','T0073886','B1E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJXD-72-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='B1E-YJXD-72-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 ('F225140229562','2025-10-14','0.530','2025-10-14','14:29:57','PLG0073665','554000','554000','5000','559000','559000','kasir','2025-10-14 14:29:56','F22514022956');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140229562','2025-10-14','14:29:57','TIN','559000','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-251014-0036','D','2025-10-14','14:29:57','kasir','PENJUALAN','F225140229562','1458994000','559000','1459553000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='559000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225140229562' 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 ('F225140229563','kasir',' 1',' MEB1 CM ','TOKO','SMBK-B','B1E-YJXD-80-T','GW SUMPING MODEL DAUN VAR CM 8K ','OL','0.650','1','100.00','634000','0','0','15000','679000','0','5000','0','684000','TIN','T0073894','B1E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJXD-80-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='2025-10-14' AND kode_barang='B1E-YJXD-80-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 ('F225140229563','2025-10-14','0.650','2025-10-14','14:29:57','PLG0073666','679000','679000','5000','684000','684000','kasir','2025-10-14 14:29:56','F22514022956');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140229563','2025-10-14','14:29:57','TIN','684000','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-251014-0037','D','2025-10-14','14:29:57','kasir','PENJUALAN','F225140229563','1459553000','684000','1460237000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='684000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225140229563' 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 ('F225140229564','kasir',' 1',' MEB1 CM ','TOKO','SMBK-B','B1E-YJXD-82-T','GW SUMPING MODEL DAUN VAR CM 8K ','OL','0.660','1','100.00','643000','0','0','15000','690000','0','5000','0','695000','TIN','T0073896','B1E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YJXD-82-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.660',berat_jual_asli=berat_jual_asli+'0.660',stock_jual='1',berat_akhir=berat_akhir-'0.660',berat_akhir_asli=berat_akhir_asli-'0.660',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='B1E-YJXD-82-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 ('F225140229564','2025-10-14','0.660','2025-10-14','14:29:57','PLG0073667','690000','690000','5000','695000','695000','kasir','2025-10-14 14:29:56','F22514022956');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140229564','2025-10-14','14:29:57','TIN','695000','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-251014-0038','D','2025-10-14','14:29:57','kasir','PENJUALAN','F225140229564','1460237000','695000','1460932000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='695000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225140229564' 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 ('F225140229565','kasir',' 1',' MGD1 5K AY','TOKO','SMBK-D','D1G-YJXF-81-T','LT SLOBOK HATI PASIR AY 8K ','OL','0.320','1','100.00','325000','0','0','15000','347000','0','5000','0','352000','TIN','T0073979','D1G','0','0','-','0','1058000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YJXF-81-T' 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='2025-10-14' AND kode_barang='D1G-YJXF-81-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 ('F225140229565','2025-10-14','0.320','2025-10-14','14:29:57','PLG0073668','347000','347000','5000','352000','352000','kasir','2025-10-14 14:29:56','F22514022956');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140229565','2025-10-14','14:29:57','TIN','352000','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-251014-0039','D','2025-10-14','14:29:57','kasir','PENJUALAN','F225140229565','1460932000','352000','1461284000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='352000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225140229565' 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 ('F225140229566','kasir',' 1',' MED1 5K LG','TOKO','SMBK-D','D1E-YJXF-98-T','LT MODEL PLAT DOLLAR LG 8K ','OL','0.510','1','100.00','498000','0','0','15000','533000','0','5000','0','538000','TIN','T0073996','D1E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJXF-98-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='2025-10-14' AND kode_barang='D1E-YJXF-98-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 ('F225140229566','2025-10-14','0.510','2025-10-14','14:29:57','PLG0073669','533000','533000','5000','538000','538000','kasir','2025-10-14 14:29:56','F22514022956');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140229566','2025-10-14','14:29:57','TIN','538000','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-251014-0040','D','2025-10-14','14:29:57','kasir','PENJUALAN','F225140229566','1461284000','538000','1461822000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='538000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225140229566' 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 ('F225140229567','kasir',' 1',' MED1 CM ','TOKO','SMBK-D','D1E-YJXF-111-T','LT MODEL BUNGA VAR CM 8K ','OL','0.600','1','100.00','586000','0','0','15000','627000','0','5000','0','632000','TIN','T0074009','D1E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1E-YJXF-111-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='2025-10-14' AND kode_barang='D1E-YJXF-111-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 ('F225140229567','2025-10-14','0.600','2025-10-14','14:29:57','PLG0073670','627000','627000','5000','632000','632000','kasir','2025-10-14 14:29:56','F22514022956');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140229567','2025-10-14','14:29:57','TIN','632000','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-251014-0041','D','2025-10-14','14:29:57','kasir','PENJUALAN','F225140229567','1461822000','632000','1462454000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='632000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225140229567' 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 ('F225140229568','kasir',' 1',' MDE2 10K C','TOKO','SMBK-E','E2D-YIXB-28-T','CC WEDDING MATA CM 12 8K ','OL','2.020','1','100.00','1838000','0','0','15000','2101000','0','10000','0','2111000','TIN','T0072772','E2D','0','0','-','0','998000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIXB-28-T' 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='2025-10-14' AND kode_barang='E2D-YIXB-28-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 ('F225140229568','2025-10-14','2.020','2025-10-14','14:29:57','PLG0073671','2101000','2101000','10000','2111000','2111000','kasir','2025-10-14 14:29:56','F22514022956');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140229568','2025-10-14','14:29:57','TIN','2111000','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-251014-0042','D','2025-10-14','14:29:57','kasir','PENJUALAN','F225140229568','1462454000','2111000','1464565000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2111000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225140229568' 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 ('F225140231451','kasir','1',' MEF3E X LT','TOKO','SMBK-F','F3E-YJAA-161-0','GL X VERONICA SLEP LT 8K ','OL','1.030','1','100.00','1040000','0','0','15000','1071000','0','5000','0','1076000','TIN','00372699','F3E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJAA-161-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.030',berat_jual_asli=berat_jual_asli+'1.030',stock_jual='1',berat_akhir=berat_akhir-'1.030',berat_akhir_asli=berat_akhir_asli-'1.030',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='F3E-YJAA-161-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 ('F225140231451','2025-10-14','1.030','2025-10-14','14:31:46','PLG0073672','1071000','1071000','5000','1076000','1076000','kasir','2025-10-14 14:31:45','F22514023145');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140231451','2025-10-14','14:31:46','TIN','1076000','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-251014-0043','D','2025-10-14','14:31:46','kasir','PENJUALAN','F225140231451','1464565000','1076000','1465641000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1076000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225140231451' 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 ('F225140231452','kasir',' 1',' MEF3 LT ','TOKO','SMBK-F','F3E-YIBD-33-T','GL MODEL VERONA VAR LT 8K ','OL','1.050','1','100.00','992000','0','0','15000','1092000','0','5000','0','1097000','TIN','T0073295','F3E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YIBD-33-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='F3E-YIBD-33-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 ('F225140231452','2025-10-14','1.050','2025-10-14','14:31:46','PLG0073673','1092000','1092000','5000','1097000','1097000','kasir','2025-10-14 14:31:45','F22514023145');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140231452','2025-10-14','14:31:46','TIN','1097000','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-251014-0044','D','2025-10-14','14:31:46','kasir','PENJUALAN','F225140231452','1465641000','1097000','1466738000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1097000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225140231452' 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 ('F225140231453','kasir',' 1',' MGPF UB D5','TOKO','SMBK-P','PFG-YJXF-174-0','GL WG OVAL MODEL DAUN MATA VAR UB D56 8K ','OL','2.020','1','100.00','2070000','0','0','15000','2182000','0','10000','0','2192000','TIN','00372471','PFG','0','0','-','0','1058000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PFG-YJXF-174-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='2025-10-14' AND kode_barang='PFG-YJXF-174-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-P' 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 ('F225140231453','2025-10-14','2.020','2025-10-14','14:31:46','PLG0073674','2182000','2182000','10000','2192000','2192000','kasir','2025-10-14 14:31:45','F22514023145');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140231453','2025-10-14','14:31:46','TIN','2192000','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-251014-0045','D','2025-10-14','14:31:46','kasir','PENJUALAN','F225140231453','1466738000','2192000','1468930000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2192000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225140231453' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140116321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140116321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140116321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140146351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140146351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140146351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140229561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140229561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140229561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140229562' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140229562' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140229562';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140229563' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140229563' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140229563';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140229564' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140229564' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140229564';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140229565' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140229565' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140229565';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140229566' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140229566' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140229566';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140229567' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140229567' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140229567';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140229568' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140229568' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140229568';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140231451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140231451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140231451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140231452' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140231452' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140231452';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140231453' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140231453' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140231453';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140952271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140952271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140952271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140953331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140953331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140953331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140954131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140954131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140954131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140954541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140954541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140954541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141022121' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141022121' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141022121';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141052171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141052171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141052171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141055511' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141055511' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141055511';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141055512' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141055512' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141055512';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141055513' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141055513' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141055513';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141055514' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141055514' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141055514';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141055515' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141055515' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141055515';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141055516' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141055516' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141055516';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141055517' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141055517' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141055517';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141055518' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141055518' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141055518';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141057021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141057021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141057021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141110201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141110201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141110201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141152261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141152261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141152261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141212512' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141212512' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141212512';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141212513' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141212513' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141212513';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141212514' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141212514' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141212514';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141212515' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141212515' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141212515';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141212516' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141212516' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141212516';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141212517' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141212517' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141212517';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141212518' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141212518' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141212518';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141212519' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141212519' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141212519';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141220571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141220571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141220571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141220572' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141220572' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141220572';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141220573' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141220573' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141220573';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141223141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141223141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141223141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141223451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141223451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141223451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141224211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141224211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141224211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141225381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141225381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141225381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141228281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141228281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141228281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225141242021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225141242021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225141242021';
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 ('F225140234161','kasir','1',' MDE2 10K C','TOKO','SMBK-E','E2D-YIXB-28-T','CC WEDDING MATA CM 12 8K ','OL','2.020','1','100.00','1838000','0','0','15000','2101000','0','10000','0','2111000','TIN','T0072772','E2D','0','0','-','0','998000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YIXB-28-T' 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='2025-10-14' AND kode_barang='E2D-YIXB-28-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 ('F225140234161','2025-10-14','2.020','2025-10-14','14:34:17','PLG0073675','2101000','2101000','10000','2111000','2111000','kasir','2025-10-14 14:34:16','F22514023416');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140234161','2025-10-14','14:34:17','TIN','2111000','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-251014-0047','D','2025-10-14','14:34:17','kasir','PENJUALAN','F225140234161','1466819000','2111000','1468930000');
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 ('F225140234541','kasir','1',' MEH1 KH 42','TOKO','SMBK-H','H1E-YIBX-9-T','KL SANTA KH 42CM 8K ','OL','2.030','1','100.00','1882000','0','0','15000','2101000','0','10000','0','2111000','TIN','T0073107','H1E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YIBX-9-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.030',berat_jual_asli=berat_jual_asli+'2.030',stock_jual='1',berat_akhir=berat_akhir-'2.030',berat_akhir_asli=berat_akhir_asli-'2.030',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='H1E-YIBX-9-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 ('F225140234541','2025-10-14','2.030','2025-10-14','14:34:55','PLG0073676','2101000','2101000','10000','2111000','2111000','kasir','2025-10-14 14:34:54','F22514023454');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140234541','2025-10-14','14:34:55','TIN','2111000','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-251014-0048','D','2025-10-14','14:34:55','kasir','PENJUALAN','F225140234541','1468930000','2111000','1471041000');
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 ('F225140235321','kasir','1',' TDE1 LG 14','TOKO','TBK-E','E1TD-YHBF-24-T','CC MODEL DAUN SLEP VAR LG 14 17K ','OL','1.020','1','100.00','1655000','0','0','15000','1895000','0','7000','0','1902000','TIN','T0072587','E1TD','0','0','-','0','1623000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TD-YHBF-24-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='E1TD-YHBF-24-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 ('F225140235321','2025-10-14','1.020','2025-10-14','14:35:33','PLG0073677','1895000','1895000','7000','1902000','1902000','kasir','2025-10-14 14:35:32','F22514023532');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140235321','2025-10-14','14:35:33','TIN','1902000','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-251014-0049','D','2025-10-14','14:35:33','kasir','PENJUALAN','F225140235321','1471041000','1902000','1472943000');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJAD-11-T','T0074037','MEH1 HW 42 ','KL SANTA RIBBON VAR HW 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','2535000','2025-10-14','2535000','2.490','100.00','8','0','1018000.00','1','0.04', 'input','2025-10-14 14:44:59','2.490','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJAD-11-T','T0074037');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','H1E-YJAD-11-T','H1E','TOKO','01-SEM','100.00','2.490','2.490','1','2.490','2.490','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJAD-12-T','T0074038','MEH1 HW 42 ','KL SANTA RIBBON VAR HW 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','2525000','2025-10-14','2525000','2.480','100.00','8','','1018000.00','1','0.04', 'input','2025-10-14 14:45:16','2.480','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJAD-12-T','T0074038');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','H1E-YJAD-12-T','H1E','TOKO','01-SEM','100.00','2.480','2.480','1','2.480','2.480','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJAD-13-T','T0074039','MEH1 UB 42 ','KL SANTA DUBAI VAR UB 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','3410500','2025-10-14','3410500','3.350','100.00','8','','1018000.00','1','0.04', 'input','2025-10-14 14:47:26','3.350','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJAD-13-T','T0074039');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','H1E-YJAD-13-T','H1E','TOKO','01-SEM','100.00','3.350','3.350','1','3.350','3.350','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJAD-14-T','T0074040','MEH1 UB 42 ','KL SANTA DUBAI VAR UB 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','3492000','2025-10-14','3492000','3.430','100.00','8','','1018000.00','1','0.04', 'input','2025-10-14 14:48:04','3.430','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJAD-14-T','T0074040');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','H1E-YJAD-14-T','H1E','TOKO','01-SEM','100.00','3.430','3.430','1','3.430','3.430','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJAD-15-T','T0074041','MEH1 UB 42 ','KL SANTA DUBAI VAR UB 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','3156000','2025-10-14','3156000','3.100','100.00','8','','1018000.00','1','0.04', 'input','2025-10-14 14:48:40','3.100','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJAD-15-T','T0074041');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','H1E-YJAD-15-T','H1E','TOKO','01-SEM','100.00','3.100','3.100','1','3.100','3.100','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJAD-16-T','T0074042','MEH1 UB 42 ','KL SANTA DUBAI VAR UB 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','3197000','2025-10-14','3197000','3.140','100.00','8','','1018000.00','1','0.04', 'input','2025-10-14 14:49:19','3.140','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJAD-16-T','T0074042');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','H1E-YJAD-16-T','H1E','TOKO','01-SEM','100.00','3.140','3.140','1','3.140','3.140','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0002','1','H1E-YJAD-11-T','1','2.49','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJAD-11-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-H','H1E','H1E-YJAD-11-T' , '1','2.49','2.49', '1','2.49','2.49','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.49',berat_out_asli=berat_out_asli+'2.49',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJAD-11-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0002','2','H1E-YJAD-12-T','1','2.48','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJAD-12-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-H','H1E','H1E-YJAD-12-T' , '1','2.48','2.48', '1','2.48','2.48','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.48',berat_out_asli=berat_out_asli+'2.48',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJAD-12-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0002','3','H1E-YJAD-13-T','1','3.35','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJAD-13-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-H','H1E','H1E-YJAD-13-T' , '1','3.35','3.35', '1','3.35','3.35','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.35',berat_out_asli=berat_out_asli+'3.35',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJAD-13-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0002','4','H1E-YJAD-14-T','1','3.43','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJAD-14-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-H','H1E','H1E-YJAD-14-T' , '1','3.43','3.43', '1','3.43','3.43','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.43',berat_out_asli=berat_out_asli+'3.43',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJAD-14-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0002','5','H1E-YJAD-15-T','1','3.1','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJAD-15-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-H','H1E','H1E-YJAD-15-T' , '1','3.1','3.1', '1','3.1','3.1','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.1',berat_out_asli=berat_out_asli+'3.1',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJAD-15-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0002','6','H1E-YJAD-16-T','1','3.14','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJAD-16-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-H','H1E','H1E-YJAD-16-T' , '1','3.14','3.14', '1','3.14','3.14','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.14',berat_out_asli=berat_out_asli+'3.14',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJAD-16-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-251014-0002','2025-10-14','2025-10-14','14:51','17.99','input','2025-10-14 14:51:24');
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 ('F225140255481','kasir','1',' MDA1D X UB','TOKO','SMBK-A','A1D-YJAC-11-0','AT X HUGGIES C SLEP UB 8K ','OL','1.230','1','100.00','1228000','0','0','15000','1267000','0','6000','0','1273000','RTA','00372741','A1D','0','0','-','0','998000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YJAC-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.230',berat_jual_asli=berat_jual_asli+'1.230',stock_jual='1',berat_akhir=berat_akhir-'1.230',berat_akhir_asli=berat_akhir_asli-'1.230',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='A1D-YJAC-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225140255481','2025-10-14','1.230','2025-10-14','14:55:48','PLG0073678','1267000','1267000','6000','1273000','0','kasir','2025-10-14 14:55:48','F22514025548');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140255481','2025-10-14','14:55:48','RTA','1273000','6000');
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-251014-0005','2025-10-14','2025-10-14 14:55:48','PENJUALAN : F225140255481','99898988887','BCA','1273000','1273000','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-251014-0006','D','2025-10-14','14:55:48','BCA','PENJUALAN','F225140255481','4054576888','1273000','4055849888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('99898988887','YULI');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1273000' WHERE no_faktur_jual='F225140255481' LIMIT 1;
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJAD-17-T','T0074043','MEH1 KH ','GL KAKI SANTA KH 8K ','','GR','---','ME','H1E','TOKO','01-SEM','3085000','2025-10-14','3085000','3.030','100.00','8','0','1018000.00','1','0.04', 'input','2025-10-14 15:10:38','3.030','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJAD-17-T','T0074043');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','H1E-YJAD-17-T','H1E','TOKO','01-SEM','100.00','3.030','3.030','1','3.030','3.030','1');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00004737','X-00004737','CC X SOLITAIRE MATA CM 14 8K','GR','---','E2D','BELI','BELI001','1002000','2025-10-14','1.100','1','kasir','2025-10-14 15:13:18');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00004737','X-00004737');
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-251014-0001','F225110220121','RHM','1','BELI','BELI001','E2D', 'X-00004737', 'CC X SOLITAIRE MATA CM 14 8K','1.100','1.100','100.00','1089000','1002000','910909','998000','1','1002000','1002000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.100',berat_beli_asli=berat_beli_asli+'1.100',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.100',berat_akhir_asli=berat_akhir_asli+'1.100',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251014-0001','2025-10-14','2025-10-14','15:13:18','RHM','---','1.100','1002000','1002000','1002000','1002000','1002000','kasir','2025-10-14 15:13:18','FB-251014-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251014-0001','ZAENAL','BITING 2/3 BADEGAN','','','','kasir','2025-10-14 15:13:18');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-14' 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-251014-0050','K','2025-10-14','15:13:18','kasir','PEMBELIAN UMUM','FB-251014-0001','1472943000','1002000','1471941000');
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-00004738','X-00004738','GW MODEL TOUGE MATA HK 8K','GR','---','B1F','BELI','BELI001','239000','2025-10-14','0.330','1','kasir','2025-10-14 15:13:40');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1F','X-00004738','X-00004738');
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-251014-0002','F224280145501','RHM','1','BELI','BELI001','B1F', 'X-00004738', 'GW MODEL TOUGE MATA HK 8K','0.400','0.330','100.00','240000','239000','724242','1005000','1','239000','239000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.330',berat_beli_asli=berat_beli_asli+'0.330',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.330',berat_akhir_asli=berat_akhir_asli+'0.330',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-10-14' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1F' 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-251014-0002','2025-10-14','2025-10-14','15:13:39','RHM','---','0.330','239000','239000','239000','239000','239000','kasir','2025-10-14 15:13:40','FB-251014-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251014-0002','GENDIS','NGAMPEL BALONG 3/2','','','081775205604','kasir','2025-10-14 15:13:40');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-10-14' 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-251014-0051','K','2025-10-14','15:13:39','kasir','PEMBELIAN UMUM','FB-251014-0002','1471941000','239000','1471702000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140234161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140234161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140234161';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140234541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140234541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140234541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140235321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140235321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140235321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140255481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140255481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140255481';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251014-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251014-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251014-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251014-0002';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-YJAD-18-T','T0074044','MEF3 PM ','GL KREPYAK DAUN PM 8K ','','GR','---','ME','F3E','TOKO','01-SEM','3288500','2025-10-14','3288500','3.230','100.00','8','0','1018000.00','1','0.04', 'input','2025-10-14 15:26:53','3.230','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-YJAD-18-T','T0074044');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','F3E-YJAD-18-T','F3E','TOKO','01-SEM','100.00','3.230','3.230','1','3.230','3.230','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-YJAD-19-T','T0074045','MEF3 YT ','GL BUMBLE GUM YT 8K ','','GR','---','ME','F3E','TOKO','01-SEM','2576000','2025-10-14','2576000','2.530','100.00','8','','1018000.00','1','0.04', 'input','2025-10-14 15:30:12','2.530','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-YJAD-19-T','T0074045');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','F3E-YJAD-19-T','F3E','TOKO','01-SEM','100.00','2.530','2.530','1','2.530','2.530','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-YJAD-20-T','T0074046','MEF3 KH ','GL KAKI SANTA KH 8K ','','GR','---','ME','F3E','TOKO','01-SEM','3085000','2025-10-14','3085000','3.030','100.00','8','','1018000.00','1','0.04', 'input','2025-10-14 15:33:05','3.030','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-YJAD-20-T','T0074046');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','F3E-YJAD-20-T','F3E','TOKO','01-SEM','100.00','3.030','3.030','1','3.030','3.030','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F1E-YJAD-21-T','T0074047','MEF1 YT D54 ','GL OVAL C SLEP YT D54 8K ','','GR','---','ME','F1E','TOKO','01-SEM','2311000','2025-10-14','2311000','2.270','100.00','8','0','1018000.00','1','0.04', 'input','2025-10-14 15:36:36','2.270','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F1E','F1E-YJAD-21-T','T0074047');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','F1E-YJAD-21-T','F1E','TOKO','01-SEM','100.00','2.270','2.270','1','2.270','2.270','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F1E-YJAD-22-T','T0074048','MEF1 UB D54 ','GL OVAL C SLEP UB D54 8K ','','GR','---','ME','F1E','TOKO','01-SEM','2331500','2025-10-14','2331500','2.290','100.00','8','','1018000.00','1','0.04', 'input','2025-10-14 15:37:37','2.290','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F1E','F1E-YJAD-22-T','T0074048');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','F1E-YJAD-22-T','F1E','TOKO','01-SEM','100.00','2.290','2.290','1','2.290','2.290','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F1E-YJAD-23-T','T0074049','MEF1 UB D54 ','GL OVAL C SLEP UB D54 8K ','','GR','---','ME','F1E','TOKO','01-SEM','2270500','2025-10-14','2270500','2.230','100.00','8','','1018000.00','1','0.04', 'input','2025-10-14 15:38:00','2.230','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F1E','F1E-YJAD-23-T','T0074049');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-14','F1E-YJAD-23-T','F1E','TOKO','01-SEM','100.00','2.230','2.230','1','2.230','2.230','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0003','1','F1E-YJAD-21-T','1','2.27','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F1E-YJAD-21-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-F','F1E','F1E-YJAD-21-T' , '1','2.27','2.27', '1','2.27','2.27','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.27',berat_out_asli=berat_out_asli+'2.27',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F1E-YJAD-21-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0003','2','F1E-YJAD-22-T','1','2.29','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F1E-YJAD-22-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-F','F1E','F1E-YJAD-22-T' , '1','2.29','2.29', '1','2.29','2.29','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.29',berat_out_asli=berat_out_asli+'2.29',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F1E-YJAD-22-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0003','3','F1E-YJAD-23-T','1','2.23','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F1E-YJAD-23-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-F','F1E','F1E-YJAD-23-T' , '1','2.23','2.23', '1','2.23','2.23','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.23',berat_out_asli=berat_out_asli+'2.23',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F1E-YJAD-23-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0003','4','F3E-YJAD-18-T','1','3.23','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-YJAD-18-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-F','F3E','F3E-YJAD-18-T' , '1','3.23','3.23', '1','3.23','3.23','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.23',berat_out_asli=berat_out_asli+'3.23',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-YJAD-18-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0003','5','F3E-YJAD-19-T','1','2.53','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-YJAD-19-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-F','F3E','F3E-YJAD-19-T' , '1','2.53','2.53', '1','2.53','2.53','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.53',berat_out_asli=berat_out_asli+'2.53',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-YJAD-19-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0003','6','F3E-YJAD-20-T','1','3.03','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-YJAD-20-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-F','F3E','F3E-YJAD-20-T' , '1','3.03','3.03', '1','3.03','3.03','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.03',berat_out_asli=berat_out_asli+'3.03',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-YJAD-20-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251014-0003','7','H1E-YJAD-17-T','1','3.03','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'H1E-YJAD-17-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-14','TOKO','SMBK-F','H1E','H1E-YJAD-17-T' , '1','3.03','3.03', '1','3.03','3.03','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.03',berat_out_asli=berat_out_asli+'3.03',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJAD-17-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-251014-0003','2025-10-14','2025-10-14','15:42','18.61','input','2025-10-14 15:42:49');
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 ('F225140402271','kasir','1',' MEH1 KH 44','TOKO','SMBK-H','H1E-YHBC-39-0','KL RANTAI HOLLOW KH 44 8K','OL','2.070','1','100.00','1919000','0','0','15000','2143000','0','10000','0','2153000','TIN','00366743','H1E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YHBC-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='H1E-YHBC-39-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 ('F225140402271','2025-10-14','2.070','2025-10-14','16:02:28','PLG0073679','2143000','2143000','10000','2153000','2153000','kasir','2025-10-14 16:02:27','F22514040227');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140402271','2025-10-14','16:02:28','TIN','2153000','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-251014-0052','D','2025-10-14','16:02:28','kasir','PENJUALAN','F225140402271','1471702000','2153000','1473855000');
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 ('F225140402551','kasir','1',' MEE2 CM 14','TOKO','SMBK-E','E2E-YJXD-52-T','CC MODEL MATA VAR CM 14 8K ','OL','0.630','1','100.00','614000','0','0','15000','655000','0','5000','0','660000','TIN','T0073866','E2E','0','0','-','0','1018000');
UPDATE tm_barang SET tgl_last_jual='2025-10-14', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXD-52-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2025-10-14' AND kode_barang='E2E-YJXD-52-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 ('F225140402551','2025-10-14','0.630','2025-10-14','16:02:55','PLG0073680','655000','655000','5000','660000','660000','kasir','2025-10-14 16:02:55','F22514040255');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-14','F225140402551','2025-10-14','16:02:55','TIN','660000','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-251014-0053','D','2025-10-14','16:02:55','kasir','PENJUALAN','F225140402551','1473855000','660000','1474515000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140402271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140402271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140402271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225140402551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225140402551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225140402551';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-15','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-14';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-14';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-14';
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='2025-10-14' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-14';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-14';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-14';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-14';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-15' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-14' 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-251015-0001','D','2025-10-15','16:21:23','SYSTEM','SALDO AWAL','SALDO AWAL','0','1474515000','1474515000');
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-251015-0001','D','2025-10-15','16:21:23','BCA','SALDO AWAL','SALDO AWAL','0','4055849888','4055849888');
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-251015-0001','D','2025-10-15','16:21:23','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-251015-0001','D','2025-10-15','16:21:23','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-251015-0001','D','2025-10-15','16:21:23','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-251015-0001','D','2025-10-15','16:21:23','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2025-10-15';