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 ('F225110819391','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-YLXE-12-T','AT COR MODEL MATA DAISY LG 8K ','OL','0.500','1','100.00','516000','0','0','15000','526000','0','5000','0','531000','RTA','T0075539','A1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLXE-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-12-11' AND kode_barang='A1E-YLXE-12-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 ('F225110819391','2025-12-11','0.500','2025-12-11','08:19:39','PLG0075561','526000','526000','5000','531000','531000','kasir','2025-12-11 08:19:39','F22511081939');
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-12-11','F225110819391','2025-12-11','08:19:39','RTA','531000','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-251211-0002','D','2025-12-11','08:19:39','kasir','PENJUALAN','F225110819391','3668294000','531000','3668825000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='531000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110819391' 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 ('F225110819392','kasir',' 1',' MGB1 LG ','TOKO','SMBK-B','B1G-YGAH-45-T','GW TUSUK MRICAN POLOS LG 8K ','OL','0.350','1','100.00','376000','0','0','15000','382000','0','5000','0','387000','RTA','T0071076','B1G','0','0','-','0','1077000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-YGAH-45-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2025-12-11' AND kode_barang='B1G-YGAH-45-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 ('F225110819392','2025-12-11','0.350','2025-12-11','08:19:39','PLG0075562','382000','382000','5000','387000','387000','kasir','2025-12-11 08:19:39','F22511081939');
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-12-11','F225110819392','2025-12-11','08:19:39','RTA','387000','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-251211-0003','D','2025-12-11','08:19:39','kasir','PENJUALAN','F225110819392','3668825000','387000','3669212000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='387000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110819392' 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 ('F225110819393','kasir',' 1',' MEB1 LG PE','TOKO','SMBK-B','B1E-YHBH-156-T','GW TUSUK DAISY MATA LG PE 8K ','OL','0.500','1','100.00','516000','0','0','15000','526000','0','5000','0','531000','RTA','T0072652','B1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YHBH-156-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-12-11' AND kode_barang='B1E-YHBH-156-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 ('F225110819393','2025-12-11','0.500','2025-12-11','08:19:39','PLG0075563','526000','526000','5000','531000','531000','kasir','2025-12-11 08:19:39','F22511081939');
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-12-11','F225110819393','2025-12-11','08:19:39','RTA','531000','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-251211-0004','D','2025-12-11','08:19:39','kasir','PENJUALAN','F225110819393','3669212000','531000','3669743000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='531000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110819393' 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 ('F225110819394','kasir',' 1',' MEF3 HW ','TOKO','SMBK-F','F3E-YLXD-41-T','GL RANTE LEMES VAR HW 8K ','','1.450','1','100.00','1498000','0','0','15000','1518000','0','7000','0','1525000','RTA','T0075509','F3E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLXD-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.450',berat_jual_asli=berat_jual_asli+'1.450',stock_jual='1',berat_akhir=berat_akhir-'1.450',berat_akhir_asli=berat_akhir_asli-'1.450',stock_akhir='0' WHERE tanggal='2025-12-11' AND kode_barang='F3E-YLXD-41-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 ('F225110819394','2025-12-11','1.450','2025-12-11','08:19:39','PLG0075564','1518000','1518000','7000','1525000','1525000','kasir','2025-12-11 08:19:39','F22511081939');
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-12-11','F225110819394','2025-12-11','08:19:39','RTA','1525000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251211-0005','D','2025-12-11','08:19:39','kasir','PENJUALAN','F225110819394','3669743000','1525000','3671268000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1525000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110819394' 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 ('F225110931191','kasir','1',' MEF3 LT ','TOKO','SMBK-F','F3E-YKBH-50-T','GL MODEL HATI VAR LT 8K ','OL','1.530','1','100.00','1581000','0','0','15000','1602000','0','8000','0','1610000','TIN','T0075282','F3E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKBH-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.530',berat_jual_asli=berat_jual_asli+'1.530',stock_jual='1',berat_akhir=berat_akhir-'1.530',berat_akhir_asli=berat_akhir_asli-'1.530',stock_akhir='0' WHERE tanggal='2025-12-11' AND kode_barang='F3E-YKBH-50-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 ('F225110931191','2025-12-11','1.530','2025-12-11','09:31:20','PLG0075565','1602000','1602000','8000','1610000','1610000','kasir','2025-12-11 09:31:19','F22511093119');
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-12-11','F225110931191','2025-12-11','09:31:20','TIN','1610000','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-251211-0006','D','2025-12-11','09:31:20','kasir','PENJUALAN','F225110931191','3671268000','1610000','3672878000');
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-251211-0001','1','F1TE-YFAF-7-T','1','5.060','5.060','TOKO','TBK-F','TOKO','PTBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='PTBK-F' WHERE kode_barang='F1TE-YFAF-7-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TBK-F';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-12-11','TOKO','PTBK-F','F1TE','F1TE-YFAF-7-T','100.00','1','5.060','5.060','1','5.060','5.060');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.060',berat_out_asli=berat_out_asli+'5.060',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-12-11' AND kode_barang='F1TE-YFAF-7-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TBK-F' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-251211-0001','2025-12-11','2025-12-11','09:57','5.06','admin','2025-12-11 10:01:17');
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 ('F225111025351','kasir','1',' MGB1G X LG','TOKO','SMBK-B','B1G-YFXC-42-0','GW X TUSUK DAISY MATA LG 8K ','','0.360','1','100.00','386000','0','0','15000','388000','0','0','0','388000','TIN','00356060','B1G','0','0','-','0','1077000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1G-YFXC-42-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2025-12-11' AND kode_barang='B1G-YFXC-42-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 ('F225111025351','2025-12-11','0.360','2025-12-11','10:25:36','PLG0075566','388000','388000','0','388000','388000','kasir','2025-12-11 10:25:35','F22511102535');
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-12-11','F225111025351','2025-12-11','10:25:36','TIN','388000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251211-0007','D','2025-12-11','10:25:36','kasir','PENJUALAN','F225111025351','3672878000','388000','3673266000');
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 ('F225111117301','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-YLXE-34-T','GL LEMES MODEL LONGLING UB 8K ','OLSF75GA','0.970','1','100.00','1002000','0','0','15000','1040000','0','72000','0','1112000','TIN','T0075561','F3E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLXE-34-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-12-11' AND kode_barang='F3E-YLXE-34-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 ('F225111117301','2025-12-11','0.970','2025-12-11','11:17:31','PLG0075567','1040000','1040000','72000','1112000','1112000','kasir','2025-12-11 11:17:30','F22511111730');
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-12-11','F225111117301','2025-12-11','11:17:31','TIN','1112000','72000');
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-251211-0008','D','2025-12-11','11:17:31','kasir','PENJUALAN','F225111117301','3673266000','1112000','3674378000');
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 ('F225111143001','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-YLXC-54-T','AT COR MODEL BK KLIP LG 8K ','OLHK','0.510','1','100.00','527000','0','0','15000','534000','0','10000','0','544000','RHM','T0075463','A1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLXC-54-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-12-11' AND kode_barang='A1E-YLXC-54-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225111143001','2025-12-11','0.510','2025-12-11','11:43:01','PLG0075568','534000','534000','10000','544000','544000','kasir','2025-12-11 11:43:00','F22511114300');
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-12-11','F225111143001','2025-12-11','11:43:01','RHM','544000','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-251211-0009','D','2025-12-11','11:43:01','kasir','PENJUALAN','F225111143001','3674378000','544000','3674922000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='544000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111143001' 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 ('F225111143002','kasir',' 1',' MEA1 LG ','TOKO','SMBK-A','A1E-YLXC-56-T','AT COR MODEL BK KLIP LG 8K ','OLHK','0.570','1','100.00','589000','0','0','15000','597000','0','10000','0','607000','RHM','T0075465','A1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLXC-56-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2025-12-11' AND kode_barang='A1E-YLXC-56-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 ('F225111143002','2025-12-11','0.570','2025-12-11','11:43:01','PLG0075569','597000','597000','10000','607000','607000','kasir','2025-12-11 11:43:00','F22511114300');
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-12-11','F225111143002','2025-12-11','11:43:01','RHM','607000','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-251211-0010','D','2025-12-11','11:43:01','kasir','PENJUALAN','F225111143002','3674922000','607000','3675529000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='607000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111143002' 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 ('F225111143003','kasir',' 1',' MEA1 LG ','TOKO','SMBK-A','A1E-YLXC-55-T','AT COR MODEL BK KLIP LG 8K ','OLHK','0.580','1','100.00','599000','0','0','15000','608000','0','10000','0','618000','RHM','T0075464','A1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLXC-55-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-12-11' AND kode_barang='A1E-YLXC-55-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 ('F225111143003','2025-12-11','0.580','2025-12-11','11:43:01','PLG0075570','608000','608000','10000','618000','618000','kasir','2025-12-11 11:43:00','F22511114300');
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-12-11','F225111143003','2025-12-11','11:43:01','RHM','618000','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-251211-0011','D','2025-12-11','11:43:01','kasir','PENJUALAN','F225111143003','3675529000','618000','3676147000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='618000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111143003' 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 ('F225111143004','kasir',' 1',' MDA1 LG ','TOKO','SMBK-A','A1D-YIXH-24-T','AT JERSY MRICAN HATI VAR LG 8K ','OLHK','1.050','1','100.00','1064000','0','0','15000','1078000','0','11000','0','1089000','RHM','T0073033','A1D','0','0','-','0','1017000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YIXH-24-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-12-11' AND kode_barang='A1D-YIXH-24-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 ('F225111143004','2025-12-11','1.050','2025-12-11','11:43:01','PLG0075571','1078000','1078000','11000','1089000','1089000','kasir','2025-12-11 11:43:00','F22511114300');
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-12-11','F225111143004','2025-12-11','11:43:01','RHM','1089000','11000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251211-0012','D','2025-12-11','11:43:01','kasir','PENJUALAN','F225111143004','3676147000','1089000','3677236000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1089000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111143004' 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 ('F225111143005','kasir',' 1',' MEB1E X LG','TOKO','SMBK-B','B1E-YLXF-185-0','GW X TIFF MATA VAR LG 8K ','OLHK','0.580','1','100.00','599000','0','0','15000','608000','0','10000','0','618000','RHM','00380001','B1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YLXF-185-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.580',berat_jual_asli=berat_jual_asli+'0.580',stock_jual='1',berat_akhir=berat_akhir-'0.580',berat_akhir_asli=berat_akhir_asli-'0.580',stock_akhir='0' WHERE tanggal='2025-12-11' AND kode_barang='B1E-YLXF-185-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 ('F225111143005','2025-12-11','0.580','2025-12-11','11:43:01','PLG0075572','608000','608000','10000','618000','618000','kasir','2025-12-11 11:43:00','F22511114300');
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-12-11','F225111143005','2025-12-11','11:43:01','RHM','618000','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-251211-0013','D','2025-12-11','11:43:01','kasir','PENJUALAN','F225111143005','3677236000','618000','3677854000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='618000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111143005' 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 ('F225111143006','kasir',' 1',' MJF4 KH ','TOKO','SMBK-F','F4J-YHBE-30-T','GL JEDAR KH 9K ','OLHK','0.600','1','100.00','680000','0','0','15000','689000','0','10000','0','699000','RHM','T0072515','F4J','0','0','-','0','1133000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F4J-YHBE-30-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-12-11' AND kode_barang='F4J-YHBE-30-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225111143006','2025-12-11','0.600','2025-12-11','11:43:01','PLG0075573','689000','689000','10000','699000','699000','kasir','2025-12-11 11:43:00','F22511114300');
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-12-11','F225111143006','2025-12-11','11:43:01','RHM','699000','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-251211-0014','D','2025-12-11','11:43:01','kasir','PENJUALAN','F225111143006','3677854000','699000','3678553000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='699000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111143006' 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 ('F225111143007','kasir',' 1',' MJF4 KH ','TOKO','SMBK-F','F4J-YHBE-29-T','GL JEDAR KH 9K ','OLHK','0.610','1','100.00','691000','0','0','15000','701000','0','10000','0','711000','RHM','T0072514','F4J','0','0','-','0','1133000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F4J-YHBE-29-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2025-12-11' AND kode_barang='F4J-YHBE-29-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225111143007','2025-12-11','0.610','2025-12-11','11:43:01','PLG0075574','701000','701000','10000','711000','711000','kasir','2025-12-11 11:43:00','F22511114300');
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-12-11','F225111143007','2025-12-11','11:43:01','RHM','711000','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-251211-0015','D','2025-12-11','11:43:01','kasir','PENJUALAN','F225111143007','3678553000','711000','3679264000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='711000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111143007' 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 ('F225111143008','kasir',' 1',' MEF3 5K LT','TOKO','SMBK-F','F3E-YJXF-56-T','GL RANTAI HOLLOW P3 SLEP LT 8K ','OLHK','1.050','1','100.00','1085000','0','0','15000','1099000','0','11000','0','1110000','RHM','T0073954','F3E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YJXF-56-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-12-11' AND kode_barang='F3E-YJXF-56-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 ('F225111143008','2025-12-11','1.050','2025-12-11','11:43:01','PLG0075575','1099000','1099000','11000','1110000','1110000','kasir','2025-12-11 11:43:00','F22511114300');
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-12-11','F225111143008','2025-12-11','11:43:01','RHM','1110000','11000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251211-0016','D','2025-12-11','11:43:01','kasir','PENJUALAN','F225111143008','3679264000','1110000','3680374000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1110000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111143008' 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 ('F225111146251','kasir','1',' MEF3 10K K','TOKO','SMBK-F','F3E-YKXA-71-T','GL RANTAI HOLLOW P3 SLEP KH 8K ','OLHK','2.100','1','100.00','2169000','0','0','15000','2199000','0','21000','0','2220000','RHM','T0074866','F3E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YKXA-71-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.100',berat_jual_asli=berat_jual_asli+'2.100',stock_jual='1',berat_akhir=berat_akhir-'2.100',berat_akhir_asli=berat_akhir_asli-'2.100',stock_akhir='0' WHERE tanggal='2025-12-11' AND kode_barang='F3E-YKXA-71-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 ('F225111146251','2025-12-11','2.100','2025-12-11','11:46:25','PLG0075576','2199000','2199000','21000','2220000','2220000','kasir','2025-12-11 11:46:25','F22511114625');
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-12-11','F225111146251','2025-12-11','11:46:25','RHM','2220000','21000');
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-251211-0017','D','2025-12-11','11:46:25','kasir','PENJUALAN','F225111146251','3680374000','2220000','3682594000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2220000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111146251' 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 ('F225111146252','kasir',' 1',' MFH1 UB 42','TOKO','SMBK-H','H1F-YLAX-38-T','KL RANTE HOLLOW 42 UB 8K ','OLHK','0.780','1','100.00','821000','0','0','15000','835000','0','10000','0','845000','RHM','T0075622','H1F','0','0','-','0','1053000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YLAX-38-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.780',berat_jual_asli=berat_jual_asli+'0.780',stock_jual='1',berat_akhir=berat_akhir-'0.780',berat_akhir_asli=berat_akhir_asli-'0.780',stock_akhir='0' WHERE tanggal='2025-12-11' AND kode_barang='H1F-YLAX-38-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225111146252','2025-12-11','0.780','2025-12-11','11:46:25','PLG0075577','835000','835000','10000','845000','845000','kasir','2025-12-11 11:46:25','F22511114625');
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-12-11','F225111146252','2025-12-11','11:46:25','RHM','845000','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-251211-0018','D','2025-12-11','11:46:25','kasir','PENJUALAN','F225111146252','3682594000','845000','3683439000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='845000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111146252' 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 ('F225111146253','kasir',' 1',' MFH1 UB 42','TOKO','SMBK-H','H1F-YLAX-41-T','KL RANTE HOLLOW 42 UB 8K ','OLHK','0.780','1','100.00','821000','0','0','15000','835000','0','10000','0','845000','RHM','T0075625','H1F','0','0','-','0','1053000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YLAX-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.780',berat_jual_asli=berat_jual_asli+'0.780',stock_jual='1',berat_akhir=berat_akhir-'0.780',berat_akhir_asli=berat_akhir_asli-'0.780',stock_akhir='0' WHERE tanggal='2025-12-11' AND kode_barang='H1F-YLAX-41-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 ('F225111146253','2025-12-11','0.780','2025-12-11','11:46:25','PLG0075578','835000','835000','10000','845000','845000','kasir','2025-12-11 11:46:25','F22511114625');
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-12-11','F225111146253','2025-12-11','11:46:25','RHM','845000','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-251211-0019','D','2025-12-11','11:46:25','kasir','PENJUALAN','F225111146253','3683439000','845000','3684284000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='845000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225111146253' 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 ('F225111157591','kasir','1',' MEF3 HW ','TOKO','SMBK-F','F3E-YLXE-42-T','GL LEMES TIFFANY VAR HW 8K ','OL','1.350','1','100.00','1395000','0','0','15000','1420000','0','7000','0','1427000','TIN','T0075569','F3E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLXE-42-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.350',berat_jual_asli=berat_jual_asli+'1.350',stock_jual='1',berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350',stock_akhir='0' WHERE tanggal='2025-12-11' AND kode_barang='F3E-YLXE-42-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 ('F225111157591','2025-12-11','1.350','2025-12-11','11:58:00','PLG0075579','1420000','1420000','7000','1427000','1427000','kasir','2025-12-11 11:57:59','F22511115759');
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-12-11','F225111157591','2025-12-11','11:58:00','TIN','1427000','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-251211-0020','D','2025-12-11','11:58:00','kasir','PENJUALAN','F225111157591','3684284000','1427000','3685711000');
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 ('F225111253101','kasir','1',' MDA1D X LG','TOKO','SMBK-A','A1D-YEAD-376-0','AT X MODEL MATA LG 8K ','OL','1.000','1','100.00','1013000','0','0','15000','1032000','0','5000','0','1037000','RTA','00353575','A1D','0','0','-','0','1017000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YEAD-376-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2025-12-11' AND kode_barang='A1D-YEAD-376-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 ('F225111253101','2025-12-11','1.000','2025-12-11','12:53:11','PLG0075580','1032000','1032000','5000','1037000','1037000','kasir','2025-12-11 12:53:10','F22511125310');
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-12-11','F225111253101','2025-12-11','12:53:11','RTA','1037000','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-251211-0021','D','2025-12-11','12:53:11','kasir','PENJUALAN','F225111253101','3685711000','1037000','3686748000');
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 ('A1TD-YLAA-1-T','T0075659','TDA1 LG ','AT COR MODEL JERSEY MRICAN LG 17K ','','GR','---','TD','A1TD','TOKO','01-SEM','1879000','2025-12-11','1879000','1.010','100.00','17','0','1860000.00','1','0.04', 'input','2025-12-11 12:57:41','1.010','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1TD','A1TD-YLAA-1-T','T0075659');
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-12-11','A1TD-YLAA-1-T','A1TD','TOKO','01-SEM','100.00','1.010','1.010','1','1.010','1.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 ('A1TE-YLAA-2-T','T0075660','TEA1 LG ','AT COR MODEL JERSEY SLEP LG 17K ','','GR','---','TE','A1TE','TOKO','01-SEM','959000','2025-12-11','959000','0.510','100.00','17','0','1880000.00','1','0.04', 'input','2025-12-11 13:16:00','0.510','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1TE','A1TE-YLAA-2-T','T0075660');
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-12-11','A1TE-YLAA-2-T','A1TE','TOKO','01-SEM','100.00','0.510','0.510','1','0.510','0.510','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 ('A1TE-YLAA-3-T','T0075661','TEA1 LG ','AT COR MODEL JERSEY SLEP LG 17K ','','GR','---','TE','A1TE','TOKO','01-SEM','1034500','2025-12-11','1034500','0.550','100.00','17','','1880000.00','1','0.04', 'input','2025-12-11 13:16:34','0.550','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1TE','A1TE-YLAA-3-T','T0075661');
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-12-11','A1TE-YLAA-3-T','A1TE','TOKO','01-SEM','100.00','0.550','0.550','1','0.550','0.550','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 ('A1TE-YLAA-4-T','T0075662','TEA1 LG ','AT COR MODEL MATA LG 17K ','','GR','---','TE','A1TE','TOKO','01-SEM','1166000','2025-12-11','1166000','0.620','100.00','17','','1880000.00','1','0.04', 'input','2025-12-11 13:17:32','0.620','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1TE','A1TE-YLAA-4-T','T0075662');
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-12-11','A1TE-YLAA-4-T','A1TE','TOKO','01-SEM','100.00','0.620','0.620','1','0.620','0.620','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 ('A1TE-YLAA-5-T','T0075663','TEA1 LG ','AT COR DAISY MATA LG 17K ','','GR','---','TE','A1TE','TOKO','01-SEM','996500','2025-12-11','996500','0.530','100.00','17','0','1880000.00','1','0.04', 'input','2025-12-11 13:19:57','0.530','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1TE','A1TE-YLAA-5-T','T0075663');
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-12-11','A1TE-YLAA-5-T','A1TE','TOKO','01-SEM','100.00','0.530','0.530','1','0.530','0.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 ('A1TE-YLAA-6-T','T0075664','TEA1 LG ','AT COR DAISY MATA LG 17K ','','GR','---','TE','A1TE','TOKO','01-SEM','996500','2025-12-11','996500','0.530','100.00','17','0','1880000.00','1','0.04', 'input','2025-12-11 13:20:15','0.530','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1TE','A1TE-YLAA-6-T','T0075664');
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-12-11','A1TE-YLAA-6-T','A1TE','TOKO','01-SEM','100.00','0.530','0.530','1','0.530','0.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 ('A1TE-YLAA-7-T','T0075665','TEA1 UB ','AT COR MODEL HATI VAR UB 17K ','','GR','---','TE','A1TE','TOKO','01-SEM','1241000','2025-12-11','1241000','0.660','100.00','17','0','1880000.00','1','0.04', 'input','2025-12-11 13:21:53','0.660','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1TE','A1TE-YLAA-7-T','T0075665');
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-12-11','A1TE-YLAA-7-T','A1TE','TOKO','01-SEM','100.00','0.660','0.660','1','0.660','0.660','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 ('A1TE-YLAA-8-T','T0075666','TEA1 HK ','AT COR MODEL MATA HK 17K ','','GR','---','TE','A1TE','TOKO','01-SEM','1222000','2025-12-11','1222000','0.650','100.00','17','0','1880000.00','1','0.04', 'input','2025-12-11 13:23:36','0.650','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1TE','A1TE-YLAA-8-T','T0075666');
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-12-11','A1TE-YLAA-8-T','A1TE','TOKO','01-SEM','100.00','0.650','0.650','1','0.650','0.650','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 ('A1TD-YLAA-9-T','T0075667','TDA1 LG ','AT COR MODEL MATA LG 17K ','','GR','---','TD','A1TD','TOKO','01-SEM','2623000','2025-12-11','2623000','1.410','100.00','17','0','1860000.00','1','0.04', 'input','2025-12-11 13:25:12','1.410','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1TD','A1TD-YLAA-9-T','T0075667');
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-12-11','A1TD-YLAA-9-T','A1TD','TOKO','01-SEM','100.00','1.410','1.410','1','1.410','1.410','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 ('A1TD-YLAA-10-T','T0075668','TDA1 LG ','AT COR MODEL BK SLEP LG 17K ','','GR','---','TD','A1TD','TOKO','01-SEM','2009000','2025-12-11','2009000','1.080','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 13:33:24','1.080','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'A1TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('A1TD','A1TD-YLAA-10-T','T0075668');
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-12-11','A1TD-YLAA-10-T','A1TD','TOKO','01-SEM','100.00','1.080','1.080','1','1.080','1.080','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-251211-0002','1','A1TD-YLAA-1-T','1','1.01','0','TOKO','01-SEM','TOKO','TBK-A');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-A' WHERE kode_barang = 'A1TD-YLAA-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-12-11','TOKO','TBK-A','A1TD','A1TD-YLAA-1-T' , '1','1.01','1.01', '1','1.01','1.01','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.01',berat_out_asli=berat_out_asli+'1.01',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='A1TD-YLAA-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-251211-0002','2','A1TD-YLAA-10-T','1','1.08','0','TOKO','01-SEM','TOKO','TBK-A');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-A' WHERE kode_barang = 'A1TD-YLAA-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-12-11','TOKO','TBK-A','A1TD','A1TD-YLAA-10-T' , '1','1.08','1.08', '1','1.08','1.08','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.08',berat_out_asli=berat_out_asli+'1.08',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='A1TD-YLAA-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-251211-0002','3','A1TD-YLAA-9-T','1','1.41','0','TOKO','01-SEM','TOKO','TBK-A');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-A' WHERE kode_barang = 'A1TD-YLAA-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-12-11','TOKO','TBK-A','A1TD','A1TD-YLAA-9-T' , '1','1.41','1.41', '1','1.41','1.41','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.41',berat_out_asli=berat_out_asli+'1.41',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='A1TD-YLAA-9-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-251211-0002','4','A1TE-YLAA-2-T','1','0.51','0','TOKO','01-SEM','TOKO','TBK-A');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-A' WHERE kode_barang = 'A1TE-YLAA-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-12-11','TOKO','TBK-A','A1TE','A1TE-YLAA-2-T' , '1','0.51','0.51', '1','0.51','0.51','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.51',berat_out_asli=berat_out_asli+'0.51',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='A1TE-YLAA-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-251211-0002','5','A1TE-YLAA-3-T','1','0.55','0','TOKO','01-SEM','TOKO','TBK-A');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-A' WHERE kode_barang = 'A1TE-YLAA-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-12-11','TOKO','TBK-A','A1TE','A1TE-YLAA-3-T' , '1','0.55','0.55', '1','0.55','0.55','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.55',berat_out_asli=berat_out_asli+'0.55',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='A1TE-YLAA-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-251211-0002','6','A1TE-YLAA-4-T','1','0.62','0','TOKO','01-SEM','TOKO','TBK-A');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-A' WHERE kode_barang = 'A1TE-YLAA-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-12-11','TOKO','TBK-A','A1TE','A1TE-YLAA-4-T' , '1','0.62','0.62', '1','0.62','0.62','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.62',berat_out_asli=berat_out_asli+'0.62',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='A1TE-YLAA-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-251211-0002','7','A1TE-YLAA-5-T','1','0.53','0','TOKO','01-SEM','TOKO','TBK-A');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-A' WHERE kode_barang = 'A1TE-YLAA-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-12-11','TOKO','TBK-A','A1TE','A1TE-YLAA-5-T' , '1','0.53','0.53', '1','0.53','0.53','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.53',berat_out_asli=berat_out_asli+'0.53',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='A1TE-YLAA-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-251211-0002','8','A1TE-YLAA-6-T','1','0.53','0','TOKO','01-SEM','TOKO','TBK-A');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-A' WHERE kode_barang = 'A1TE-YLAA-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-12-11','TOKO','TBK-A','A1TE','A1TE-YLAA-6-T' , '1','0.53','0.53', '1','0.53','0.53','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.53',berat_out_asli=berat_out_asli+'0.53',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='A1TE-YLAA-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-251211-0002','9','A1TE-YLAA-7-T','1','0.66','0','TOKO','01-SEM','TOKO','TBK-A');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-A' WHERE kode_barang = 'A1TE-YLAA-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-12-11','TOKO','TBK-A','A1TE','A1TE-YLAA-7-T' , '1','0.66','0.66', '1','0.66','0.66','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.66',berat_out_asli=berat_out_asli+'0.66',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='A1TE-YLAA-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-251211-0002','10','A1TE-YLAA-8-T','1','0.65','0','TOKO','01-SEM','TOKO','TBK-A');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-A' WHERE kode_barang = 'A1TE-YLAA-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-12-11','TOKO','TBK-A','A1TE','A1TE-YLAA-8-T' , '1','0.65','0.65', '1','0.65','0.65','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.65',berat_out_asli=berat_out_asli+'0.65',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='A1TE-YLAA-8-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-251211-0002','2025-12-11','2025-12-11','13:35','7.55','input','2025-12-11 13:35:39');
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 ('B1TD-YLAA-11-T','T0075669','TDB1 UB ','GW COR MODEL TUSUK MATA UB 17K ','','GR','---','TD','B1TD','TOKO','01-SEM','2139000','2025-12-11','2139000','1.150','100.00','17','0','1860000.00','1','0.04', 'input','2025-12-11 13:42:57','1.150','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1TD','B1TD-YLAA-11-T','T0075669');
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-12-11','B1TD-YLAA-11-T','B1TD','TOKO','01-SEM','100.00','1.150','1.150','1','1.150','1.150','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 ('B1TD-YLAA-12-T','T0075670','TDB1 LG PE ','GC COR MODEL MATA PE LG 17K ','','GR','---','TD','B1TD','TOKO','01-SEM','2976000','2025-12-11','2976000','1.600','100.00','17','0','1860000.00','1','0.04', 'input','2025-12-11 13:44:17','1.600','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1TD','B1TD-YLAA-12-T','T0075670');
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-12-11','B1TD-YLAA-12-T','B1TD','TOKO','01-SEM','100.00','1.600','1.600','1','1.600','1.600','1');
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('B1TD-YLAA-12-T','T0075670','T0075670','GC COR MODEL MATA PE LG 17K ','GW COR MODEL MATA PE LG 17K','','','2976000','2976000',' 0','0','input','2025-12-11 13:45:03');
UPDATE tm_barang SET nama_barang='GW COR MODEL MATA PE LG 17K' ,nama_atribut='' ,kode_intern='TDB1 LG PE ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='B1TD-YLAA-12-T' 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 ('B1TD-YLAA-13-T','T0075671','TDB1 LG PE ','GW TUSUK COR MODEL PE LG 17K ','','GR','---','TD','B1TD','TOKO','01-SEM','800000','2025-12-11','800000','0.430','100.00','17','0','1860000.00','1','0.04', 'input','2025-12-11 13:49:34','0.430','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1TD','B1TD-YLAA-13-T','T0075671');
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-12-11','B1TD-YLAA-13-T','B1TD','TOKO','01-SEM','100.00','0.430','0.430','1','0.430','0.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 ('B1TF-YLAA-14-T','T0075672','TFB1 LG PE ','GW TUSUK MRICAN PE LG 17K ','','GR','---','TF','B1TF','TOKO','01-SEM','817000','2025-12-11','817000','0.430','100.00','17','','1900000.00','1','0.04', 'input','2025-12-11 13:55:23','0.430','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1TF' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1TF','B1TF-YLAA-14-T','T0075672');
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-12-11','B1TF-YLAA-14-T','B1TF','TOKO','01-SEM','100.00','0.430','0.430','1','0.430','0.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 ('B1TE-YLAA-15-T','T0075673','TEB1 X HK ','GW X MODEL TOGE MATA HK 17K ','','GR','---','TE','B1TE','TOKO','01-SEM','940000','2025-12-11','940000','0.500','100.00','17','','1880000.00','1','0.04', 'input','2025-12-11 14:08:00','0.500','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1TE','B1TE-YLAA-15-T','T0075673');
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-12-11','B1TE-YLAA-15-T','B1TE','TOKO','01-SEM','100.00','0.500','0.500','1','0.500','0.500','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 ('B1TE-YLAA-16-T','T0075674','TEB1 X HK ','GW X MODEL TOGE MATA HK 17K ','','GR','---','TE','B1TE','TOKO','01-SEM','959000','2025-12-11','959000','0.510','100.00','17','','1880000.00','1','0.04', 'input','2025-12-11 14:08:59','0.510','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'B1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('B1TE','B1TE-YLAA-16-T','T0075674');
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-12-11','B1TE-YLAA-16-T','B1TE','TOKO','01-SEM','100.00','0.510','0.510','1','0.510','0.510','1');
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('B1TD-YLAA-11-T','T0075669','T0075669','GW COR MODEL TUSUK MATA UB 17K ','GW X COR MODEL TUSUK MATA UB 17K','','','2139000','2139000',' 0','0','input','2025-12-11 14:09:58');
UPDATE tm_barang SET nama_barang='GW X COR MODEL TUSUK MATA UB 17K' ,nama_atribut='' ,kode_intern='TDB1 X UB ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='B1TD-YLAA-11-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('B1TD-YLAA-12-T','T0075670','T0075670','GW COR MODEL MATA PE LG 17K','GW X COR MODEL MATA PE LG 17K','','','2976000','2976000',' 0','0','input','2025-12-11 14:10:20');
UPDATE tm_barang SET nama_barang='GW X COR MODEL MATA PE LG 17K' ,nama_atribut='' ,kode_intern='TDB1 X LG PE ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='B1TD-YLAA-12-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('B1TD-YLAA-13-T','T0075671','T0075671','GW TUSUK COR MODEL PE LG 17K ','GW X TUSUK COR MODEL PE LG 17K','','','800000','800000',' 0','0','input','2025-12-11 14:10:35');
UPDATE tm_barang SET nama_barang='GW X TUSUK COR MODEL PE LG 17K' ,nama_atribut='' ,kode_intern='TDB1 X LG PE ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='B1TD-YLAA-13-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('B1TF-YLAA-14-T','T0075672','T0075672','GW TUSUK MRICAN PE LG 17K ','GW X TUSUK MRICAN PE LG 17K','','','817000','817000',' 0','0','input','2025-12-11 14:10:49');
UPDATE tm_barang SET nama_barang='GW X TUSUK MRICAN PE LG 17K' ,nama_atribut='' ,kode_intern='TFB1 X LG PE ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='B1TF-YLAA-14-T' 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-251211-0003','1','B1TD-YLAA-11-T','1','1.15','0','TOKO','01-SEM','TOKO','TBK-B');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-B' WHERE kode_barang = 'B1TD-YLAA-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-12-11','TOKO','TBK-B','B1TD','B1TD-YLAA-11-T' , '1','1.15','1.15', '1','1.15','1.15','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.15',berat_out_asli=berat_out_asli+'1.15',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='B1TD-YLAA-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-251211-0003','2','B1TD-YLAA-12-T','1','1.6','0','TOKO','01-SEM','TOKO','TBK-B');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-B' WHERE kode_barang = 'B1TD-YLAA-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-12-11','TOKO','TBK-B','B1TD','B1TD-YLAA-12-T' , '1','1.6','1.6', '1','1.6','1.6','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.6',berat_out_asli=berat_out_asli+'1.6',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='B1TD-YLAA-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-251211-0003','3','B1TD-YLAA-13-T','1','0.43','0','TOKO','01-SEM','TOKO','TBK-B');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-B' WHERE kode_barang = 'B1TD-YLAA-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-12-11','TOKO','TBK-B','B1TD','B1TD-YLAA-13-T' , '1','0.43','0.43', '1','0.43','0.43','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.43',berat_out_asli=berat_out_asli+'0.43',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='B1TD-YLAA-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-251211-0003','4','B1TE-YLAA-15-T','1','0.5','0','TOKO','01-SEM','TOKO','TBK-B');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-B' WHERE kode_barang = 'B1TE-YLAA-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-12-11','TOKO','TBK-B','B1TE','B1TE-YLAA-15-T' , '1','0.5','0.5', '1','0.5','0.5','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.5',berat_out_asli=berat_out_asli+'0.5',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='B1TE-YLAA-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-251211-0003','5','B1TE-YLAA-16-T','1','0.51','0','TOKO','01-SEM','TOKO','TBK-B');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-B' WHERE kode_barang = 'B1TE-YLAA-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-12-11','TOKO','TBK-B','B1TE','B1TE-YLAA-16-T' , '1','0.51','0.51', '1','0.51','0.51','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.51',berat_out_asli=berat_out_asli+'0.51',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='B1TE-YLAA-16-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-251211-0003','6','B1TF-YLAA-14-T','1','0.43','0','TOKO','01-SEM','TOKO','TBK-B');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-B' WHERE kode_barang = 'B1TF-YLAA-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-12-11','TOKO','TBK-B','B1TF','B1TF-YLAA-14-T' , '1','0.43','0.43', '1','0.43','0.43','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.43',berat_out_asli=berat_out_asli+'0.43',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='B1TF-YLAA-14-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-251211-0003','2025-12-11','2025-12-11','14:11','4.62','input','2025-12-11 14:11:31');
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('A1TD-YLAA-1-T','T0075659','T0075659','AT COR MODEL JERSEY MRICAN LG 17K ','AT X COR MODEL JERSEY MRICAN LG 17K','','','1879000','1879000',' 0','0','input','2025-12-11 14:15:17');
UPDATE tm_barang SET nama_barang='AT X COR MODEL JERSEY MRICAN LG 17K' ,nama_atribut='' ,kode_intern='TDA1 X LG ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='A1TD-YLAA-1-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('A1TE-YLAA-2-T','T0075660','T0075660','AT COR MODEL JERSEY SLEP LG 17K ','AT X COR MODEL JERSEY SLEP LG 17K','','','959000','959000',' 0','0','input','2025-12-11 14:15:36');
UPDATE tm_barang SET nama_barang='AT X COR MODEL JERSEY SLEP LG 17K' ,nama_atribut='' ,kode_intern='TEA1 X LG ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='A1TE-YLAA-2-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('A1TE-YLAA-3-T','T0075661','T0075661','AT COR MODEL JERSEY SLEP LG 17K ','AT X COR MODEL JERSEY SLEP LG 17K','','','1034500','1034500',' 0','0','input','2025-12-11 14:15:51');
UPDATE tm_barang SET nama_barang='AT X COR MODEL JERSEY SLEP LG 17K' ,nama_atribut='' ,kode_intern='TEA1 X LG ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='A1TE-YLAA-3-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('A1TE-YLAA-4-T','T0075662','T0075662','AT COR MODEL MATA LG 17K ','AT X COR MODEL MATA LG 17K','','','1166000','1166000',' 0','0','input','2025-12-11 14:16:06');
UPDATE tm_barang SET nama_barang='AT X COR MODEL MATA LG 17K' ,nama_atribut='' ,kode_intern='TEA1 X LG ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='A1TE-YLAA-4-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('A1TE-YLAA-5-T','T0075663','T0075663','AT COR DAISY MATA LG 17K ','AT X COR DAISY MATA LG 17K','','','996500','996500',' 0','0','input','2025-12-11 14:16:21');
UPDATE tm_barang SET nama_barang='AT X COR DAISY MATA LG 17K' ,nama_atribut='' ,kode_intern='TEA1 X LG ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='A1TE-YLAA-5-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('A1TE-YLAA-6-T','T0075664','T0075664','AT COR DAISY MATA LG 17K ','AT X COR DAISY MATA LG 17K','','','996500','996500',' 0','0','input','2025-12-11 14:16:53');
UPDATE tm_barang SET nama_barang='AT X COR DAISY MATA LG 17K' ,nama_atribut='' ,kode_intern='TEA1 X LG ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='A1TE-YLAA-6-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('A1TE-YLAA-7-T','T0075665','T0075665','AT COR MODEL HATI VAR UB 17K ','AT X COR MODEL HATI VAR UB 17K','','','1241000','1241000',' 0','0','input','2025-12-11 14:17:08');
UPDATE tm_barang SET nama_barang='AT X COR MODEL HATI VAR UB 17K' ,nama_atribut='' ,kode_intern='TEA1 X UB ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='A1TE-YLAA-7-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('A1TE-YLAA-8-T','T0075666','T0075666','AT COR MODEL MATA HK 17K ','AT X COR MODEL MATA HK 17K','','','1222000','1222000',' 0','0','input','2025-12-11 14:17:24');
UPDATE tm_barang SET nama_barang='AT X COR MODEL MATA HK 17K' ,nama_atribut='' ,kode_intern='TEA1 X HK ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='A1TE-YLAA-8-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('A1TD-YLAA-9-T','T0075667','T0075667','AT COR MODEL MATA LG 17K ','AT X COR MODEL MATA LG 17K','','','2623000','2623000',' 0','0','input','2025-12-11 14:17:36');
UPDATE tm_barang SET nama_barang='AT X COR MODEL MATA LG 17K' ,nama_atribut='' ,kode_intern='TDA1 X LG ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='A1TD-YLAA-9-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('A1TD-YLAA-10-T','T0075668','T0075668','AT COR MODEL BK SLEP LG 17K ','AT X COR MODEL BK SLEP LG 17K','','','2009000','2009000',' 0','0','input','2025-12-11 14:17:52');
UPDATE tm_barang SET nama_barang='AT X COR MODEL BK SLEP LG 17K' ,nama_atribut='' ,kode_intern='TDA1 X LG ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='A1TD-YLAA-10-T' 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 ('D2TD-YLAA-17-T','T0075675','TDD2 X LG ','LT X COR MATA HURUF A LG 17K ','','GR','---','TD','D2TD','TOKO','01-SEM','1916000','2025-12-11','1916000','1.030','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 14:28:03','1.030','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D2TD','D2TD-YLAA-17-T','T0075675');
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-12-11','D2TD-YLAA-17-T','D2TD','TOKO','01-SEM','100.00','1.030','1.030','1','1.030','1.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 ('D2TD-YLAA-18-T','T0075676','TDD2 X UB ','LT X COR MODEL MATA UB 17K ','','GR','---','TD','D2TD','TOKO','01-SEM','2697000','2025-12-11','2697000','1.450','100.00','17','0','1860000.00','1','0.04', 'input','2025-12-11 14:28:52','1.450','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D2TD','D2TD-YLAA-18-T','T0075676');
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-12-11','D2TD-YLAA-18-T','D2TD','TOKO','01-SEM','100.00','1.450','1.450','1','1.450','1.450','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 ('D2TD-YLAA-19-T','T0075677','TDD2 X UB ','LT X COR MODEL MATA UB 17K ','','GR','---','TD','D2TD','TOKO','01-SEM','2790000','2025-12-11','2790000','1.500','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 14:29:30','1.500','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D2TD','D2TD-YLAA-19-T','T0075677');
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-12-11','D2TD-YLAA-19-T','D2TD','TOKO','01-SEM','100.00','1.500','1.500','1','1.500','1.500','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 ('D2TD-YLAA-20-T','T0075678','TDD2 X UB ','LT X COR MODEL MATA UB 17K ','','GR','---','TD','D2TD','TOKO','01-SEM','1581000','2025-12-11','1581000','0.850','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 14:29:54','0.850','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D2TD','D2TD-YLAA-20-T','T0075678');
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-12-11','D2TD-YLAA-20-T','D2TD','TOKO','01-SEM','100.00','0.850','0.850','1','0.850','0.850','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 ('D2TE-YLAA-21-T','T0075679','TED2 X LG ','LT X COR MATA HURUF A LG 17K ','','GR','---','TE','D2TE','TOKO','01-SEM','1278500','2025-12-11','1278500','0.680','100.00','17','','1880000.00','1','0.04', 'input','2025-12-11 14:31:32','0.680','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D2TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D2TE','D2TE-YLAA-21-T','T0075679');
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-12-11','D2TE-YLAA-21-T','D2TE','TOKO','01-SEM','100.00','0.680','0.680','1','0.680','0.680','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 ('D2TE-YLAA-22-T','T0075680','TED2 X BM ','LT X SLOBOK MATA BM 17K ','','GR','---','TE','D2TE','TOKO','01-SEM','1504000','2025-12-11','1504000','0.800','100.00','17','','1880000.00','1','0.04', 'input','2025-12-11 14:33:41','0.800','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D2TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D2TE','D2TE-YLAA-22-T','T0075680');
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-12-11','D2TE-YLAA-22-T','D2TE','TOKO','01-SEM','100.00','0.800','0.800','1','0.800','0.800','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 ('D2TF-YLAA-23-T','T0075681','TFD2 X YT ','LT X COR MODEL SPECTRA YT 17K ','','GR','---','TF','D2TF','TOKO','01-SEM','722000','2025-12-11','722000','0.380','100.00','17','','1900000.00','1','0.04', 'input','2025-12-11 14:39:23','0.380','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D2TF' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D2TF','D2TF-YLAA-23-T','T0075681');
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-12-11','D2TF-YLAA-23-T','D2TF','TOKO','01-SEM','100.00','0.380','0.380','1','0.380','0.380','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 ('D1TE-YLAA-24-T','T0075682','TED1 UB ','LT COR MODEL ARESO UB 17K ','','GR','---','TE','D1TE','TOKO','01-SEM','1241000','2025-12-11','1241000','0.660','100.00','17','','1880000.00','1','0.04', 'input','2025-12-11 14:40:53','0.660','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'D1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('D1TE','D1TE-YLAA-24-T','T0075682');
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-12-11','D1TE-YLAA-24-T','D1TE','TOKO','01-SEM','100.00','0.660','0.660','1','0.660','0.660','1');
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('D1TE-YLAA-24-T','T0075682','T0075682','LT COR MODEL ARESO UB 17K ','LT X COR MODEL ARESO UB 17K','','','1241000','1241000',' 0','0','input','2025-12-11 14:41:30');
UPDATE tm_barang SET nama_barang='LT X COR MODEL ARESO UB 17K' ,nama_atribut='' ,kode_intern='TED1 X UB ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='D1TE-YLAA-24-T' 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-251211-0004','1','D1TE-YLAA-24-T','1','0.66','0','TOKO','01-SEM','TOKO','TBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-D' WHERE kode_barang = 'D1TE-YLAA-24-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-12-11','TOKO','TBK-D','D1TE','D1TE-YLAA-24-T' , '1','0.66','0.66', '1','0.66','0.66','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.66',berat_out_asli=berat_out_asli+'0.66',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D1TE-YLAA-24-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-251211-0004','2','D2TD-YLAA-17-T','1','1.03','0','TOKO','01-SEM','TOKO','TBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-D' WHERE kode_barang = 'D2TD-YLAA-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-12-11','TOKO','TBK-D','D2TD','D2TD-YLAA-17-T' , '1','1.03','1.03', '1','1.03','1.03','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.03',berat_out_asli=berat_out_asli+'1.03',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D2TD-YLAA-17-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-251211-0004','3','D2TD-YLAA-18-T','1','1.45','0','TOKO','01-SEM','TOKO','TBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-D' WHERE kode_barang = 'D2TD-YLAA-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-12-11','TOKO','TBK-D','D2TD','D2TD-YLAA-18-T' , '1','1.45','1.45', '1','1.45','1.45','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.45',berat_out_asli=berat_out_asli+'1.45',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D2TD-YLAA-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-251211-0004','4','D2TD-YLAA-19-T','1','1.5','0','TOKO','01-SEM','TOKO','TBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-D' WHERE kode_barang = 'D2TD-YLAA-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-12-11','TOKO','TBK-D','D2TD','D2TD-YLAA-19-T' , '1','1.5','1.5', '1','1.5','1.5','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.5',berat_out_asli=berat_out_asli+'1.5',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D2TD-YLAA-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-251211-0004','5','D2TD-YLAA-20-T','1','0.85','0','TOKO','01-SEM','TOKO','TBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-D' WHERE kode_barang = 'D2TD-YLAA-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-12-11','TOKO','TBK-D','D2TD','D2TD-YLAA-20-T' , '1','0.85','0.85', '1','0.85','0.85','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.85',berat_out_asli=berat_out_asli+'0.85',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D2TD-YLAA-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-251211-0004','6','D2TE-YLAA-21-T','1','0.68','0','TOKO','01-SEM','TOKO','TBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-D' WHERE kode_barang = 'D2TE-YLAA-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-12-11','TOKO','TBK-D','D2TE','D2TE-YLAA-21-T' , '1','0.68','0.68', '1','0.68','0.68','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.68',berat_out_asli=berat_out_asli+'0.68',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D2TE-YLAA-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-251211-0004','7','D2TE-YLAA-22-T','1','0.8','0','TOKO','01-SEM','TOKO','TBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-D' WHERE kode_barang = 'D2TE-YLAA-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-12-11','TOKO','TBK-D','D2TE','D2TE-YLAA-22-T' , '1','0.8','0.8', '1','0.8','0.8','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.8',berat_out_asli=berat_out_asli+'0.8',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D2TE-YLAA-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-251211-0004','8','D2TF-YLAA-23-T','1','0.38','0','TOKO','01-SEM','TOKO','TBK-D');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-D' WHERE kode_barang = 'D2TF-YLAA-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-12-11','TOKO','TBK-D','D2TF','D2TF-YLAA-23-T' , '1','0.38','0.38', '1','0.38','0.38','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.38',berat_out_asli=berat_out_asli+'0.38',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='D2TF-YLAA-23-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-251211-0004','2025-12-11','2025-12-11','14:41','7.35','input','2025-12-11 14:42:08');
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 ('F225110244171','kasir','1',' MEE1 AY 14','TOKO','SMBK-E','E1E-YHXE-100-T','CC MODEL SLEP VAR AY 14 8K ','','0.710','1','100.00','733000','0','0','15000','737000','0','0','0','737000','RHM','T0071889','E1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YHXE-100-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.710',berat_jual_asli=berat_jual_asli+'0.710',stock_jual='1',berat_akhir=berat_akhir-'0.710',berat_akhir_asli=berat_akhir_asli-'0.710',stock_akhir='0' WHERE tanggal='2025-12-11' AND kode_barang='E1E-YHXE-100-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 ('F225110244171','2025-12-11','0.710','2025-12-11','14:44:17','PLG0075581','737000','737000','0','737000','737000','kasir','2025-12-11 14:44:17','F22511024417');
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-12-11','F225110244171','2025-12-11','14:44:17','RHM','737000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251211-0022','D','2025-12-11','14:44:17','kasir','PENJUALAN','F225110244171','3686748000','737000','3687485000');
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 ('E2TD-YLAA-25-T','T0075683','TDE2 X UB 13 ','CC X COR MODEL MATA 13 UB 17K ','','GR','---','TD','E2TD','TOKO','01-SEM','3832000','2025-12-11','3832000','2.060','100.00','17','0','1860000.00','1','0.04', 'input','2025-12-11 14:54:12','2.060','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2TD','E2TD-YLAA-25-T','T0075683');
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-12-11','E2TD-YLAA-25-T','E2TD','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 ('E2TD-YLAA-26-T','T0075684','TDE2 X MJ 12 ','CC X COR MODEL MATA 12 MJ 17K ','','GR','---','TD','E2TD','TOKO','01-SEM','2418000','2025-12-11','2418000','1.300','100.00','17','0','1860000.00','1','0.04', 'input','2025-12-11 14:55:25','1.300','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2TD','E2TD-YLAA-26-T','T0075684');
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-12-11','E2TD-YLAA-26-T','E2TD','TOKO','01-SEM','100.00','1.300','1.300','1','1.300','1.300','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 ('E2TD-YLAA-27-T','T0075685','TDE2 X CM 12 ','CC X COR MODEL MATA 12 CM 17K ','','GR','---','TD','E2TD','TOKO','01-SEM','2102000','2025-12-11','2102000','1.130','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 14:56:54','1.130','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2TD','E2TD-YLAA-27-T','T0075685');
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-12-11','E2TD-YLAA-27-T','E2TD','TOKO','01-SEM','100.00','1.130','1.130','1','1.130','1.130','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 ('E2TD-YLAA-28-T','T0075686','TDE2 X LG 14 ','CC X COR MODEL MATA 14 LG 17K ','','GR','---','TD','E2TD','TOKO','01-SEM','3683000','2025-12-11','3683000','1.980','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:01:39','1.980','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2TD','E2TD-YLAA-28-T','T0075686');
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-12-11','E2TD-YLAA-28-T','E2TD','TOKO','01-SEM','100.00','1.980','1.980','1','1.980','1.980','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 ('E2TD-YLAA-29-T','T0075687','TDE2 X BW 15 ','CC X COR MODEL MATA 15 BW 17K ','','GR','---','TD','E2TD','TOKO','01-SEM','3869000','2025-12-11','3869000','2.080','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:04:40','2.080','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2TD','E2TD-YLAA-29-T','T0075687');
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-12-11','E2TD-YLAA-29-T','E2TD','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 ('E2TD-YLAA-30-T','T0075688','TDE2 X YT 13 ','CC X COR MODEL MATA 13 YT 17K ','','GR','---','TD','E2TD','TOKO','01-SEM','3906000','2025-12-11','3906000','2.100','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:05:40','2.100','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2TD','E2TD-YLAA-30-T','T0075688');
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-12-11','E2TD-YLAA-30-T','E2TD','TOKO','01-SEM','100.00','2.100','2.100','1','2.100','2.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 ('E2TD-YLAA-31-T','T0075689','TDE2 X MJ 13 ','CC X COR MODEL MATA 13 MJ 17K ','','GR','---','TD','E2TD','TOKO','01-SEM','3255000','2025-12-11','3255000','1.750','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:06:40','1.750','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2TD','E2TD-YLAA-31-T','T0075689');
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-12-11','E2TD-YLAA-31-T','E2TD','TOKO','01-SEM','100.00','1.750','1.750','1','1.750','1.750','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 ('E2TD-YLAA-32-T','T0075690','TDE2 X MJ 19 ','CC X COR MODEL MATA 19 MJ 17K ','','GR','---','TD','E2TD','TOKO','01-SEM','3441000','2025-12-11','3441000','1.850','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:07:40','1.850','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2TD','E2TD-YLAA-32-T','T0075690');
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-12-11','E2TD-YLAA-32-T','E2TD','TOKO','01-SEM','100.00','1.850','1.850','1','1.850','1.850','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 ('E2TD-YLAA-33-T','T0075691','TDE2 X UB 13 ','CC X COR MODEL MATA 13 UB 17K ','','GR','---','TD','E2TD','TOKO','01-SEM','2883000','2025-12-11','2883000','1.550','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:08:43','1.550','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2TD','E2TD-YLAA-33-T','T0075691');
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-12-11','E2TD-YLAA-33-T','E2TD','TOKO','01-SEM','100.00','1.550','1.550','1','1.550','1.550','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 ('E2TD-YLAA-34-T','T0075692','TDE2 X CM 15 ','CC X COR MODEL MATA 15 CM 17K ','','GR','---','TD','E2TD','TOKO','01-SEM','2344000','2025-12-11','2344000','1.260','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:10:00','1.260','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2TD','E2TD-YLAA-34-T','T0075692');
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-12-11','E2TD-YLAA-34-T','E2TD','TOKO','01-SEM','100.00','1.260','1.260','1','1.260','1.260','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 ('E2TD-YLAA-35-T','T0075693','TDE2 X UB 12 ','CC X COR MODEL MATA 12 UB 17K ','','GR','---','TD','E2TD','TOKO','01-SEM','2604000','2025-12-11','2604000','1.400','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:10:51','1.400','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2TD','E2TD-YLAA-35-T','T0075693');
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-12-11','E2TD-YLAA-35-T','E2TD','TOKO','01-SEM','100.00','1.400','1.400','1','1.400','1.400','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 ('E2TD-YLAA-36-T','T0075694','TDE2 X CM 12 ','CC X COR MODEL MATA 12 CM 17K ','','GR','---','TD','E2TD','TOKO','01-SEM','2269500','2025-12-11','2269500','1.220','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:11:39','1.220','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2TD','E2TD-YLAA-36-T','T0075694');
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-12-11','E2TD-YLAA-36-T','E2TD','TOKO','01-SEM','100.00','1.220','1.220','1','1.220','1.220','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 ('E2TD-YLAA-37-T','T0075695','TDE2 X LG 14 ','CC X COR MODEL MATA 14 LG 17K ','','GR','---','TD','E2TD','TOKO','01-SEM','1581000','2025-12-11','1581000','0.850','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:12:44','0.850','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2TD','E2TD-YLAA-37-T','T0075695');
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-12-11','E2TD-YLAA-37-T','E2TD','TOKO','01-SEM','100.00','0.850','0.850','1','0.850','0.850','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 ('E2TD-YLAA-38-T','T0075696','TDE2 X MJ 12 ','CC X COR MODEL MATA 12 MJ 17K ','','GR','---','TD','E2TD','TOKO','01-SEM','2102000','2025-12-11','2102000','1.130','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:15:31','1.130','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2TD','E2TD-YLAA-38-T','T0075696');
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-12-11','E2TD-YLAA-38-T','E2TD','TOKO','01-SEM','100.00','1.130','1.130','1','1.130','1.130','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 ('E2TD-YLAA-39-T','T0075697','TDE2 X MJ 12 ','CC X COR MODEL MATA 12 MJ 17K ','','GR','---','TD','E2TD','TOKO','01-SEM','2511000','2025-12-11','2511000','1.350','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:16:14','1.350','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2TD','E2TD-YLAA-39-T','T0075697');
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-12-11','E2TD-YLAA-39-T','E2TD','TOKO','01-SEM','100.00','1.350','1.350','1','1.350','1.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 ('E2TD-YLAA-40-T','T0075698','TDE2 X HK 12 ','CC X COR MODEL MATA 12 HK 17K ','','GR','---','TD','E2TD','TOKO','01-SEM','2809000','2025-12-11','2809000','1.510','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:17:09','1.510','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2TD','E2TD-YLAA-40-T','T0075698');
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-12-11','E2TD-YLAA-40-T','E2TD','TOKO','01-SEM','100.00','1.510','1.510','1','1.510','1.510','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 ('E2TD-YLAA-41-T','T0075699','TDE2 X YT 10 ','CC X COR MODEL SPECTRA 10 YT 17K ','','GR','---','TD','E2TD','TOKO','01-SEM','2604000','2025-12-11','2604000','1.400','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:18:18','1.400','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E2TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E2TD','E2TD-YLAA-41-T','T0075699');
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-12-11','E2TD-YLAA-41-T','E2TD','TOKO','01-SEM','100.00','1.400','1.400','1','1.400','1.400','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-00004900','X-00004900','GL X SHOGUN POLOS DW D6','GR','---','F1TE','BELI','BELI001','9660000','2025-12-11','6.900','1','kasir','2025-12-11 15:21:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1TE','X-00004900','X-00004900');
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-251211-0001','F221110816571','TIN','1','BELI','BELI001','F1TE', 'X-00004900', 'GL X SHOGUN POLOS DW D6','7.020','6.900','100.00','5146000','9660000','1400000','1880000','1','9660000','9660000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'6.900',berat_beli_asli=berat_beli_asli+'6.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'6.900',berat_akhir_asli=berat_akhir_asli+'6.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1TE' 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-251211-0001','2025-12-11','2025-12-11','15:21:30','TIN','---','6.900','9660000','9660000','9660000','9660000','9660000','kasir','2025-12-11 15:21:30','FB-251211-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251211-0001','B UMU CHOLIFAH','BRAHU 40 SIMAN','','','082337566441','kasir','2025-12-11 15:21:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-11' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251211-0023','K','2025-12-11','15:21:30','kasir','PEMBELIAN UMUM','FB-251211-0001','3687485000','9660000','3677825000');
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-00004901','X-00004901','CC MODEL BUNGA CLOVER VAR YT 13 8K','GR','---','E1D','BELI','BELI001','787000','2025-12-11','1.050','1','kasir','2025-12-11 15:21:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00004901','X-00004901');
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-251211-0002','F225210207141','TIN','2','BELI','BELI001','E1D', 'X-00004901', 'CC MODEL BUNGA CLOVER VAR YT 13 8K','1.200','1.050','100.00','980000','787000','749524','1017000','1','787000','787000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251211-0002','2025-12-11','2025-12-11','15:21:30','TIN','---','1.050','787000','787000','787000','787000','787000','kasir','2025-12-11 15:21:30','FB-251211-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251211-0002','KURNIA','SUKOSARI','','','085731114196','kasir','2025-12-11 15:21:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-11' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251211-0024','K','2025-12-11','15:21:30','kasir','PEMBELIAN UMUM','FB-251211-0002','3677825000','787000','3677038000');
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-00004902','X-00004902','CC X WEDDING C SLEP BM 22 8K','GR','---','E2D','BELI','BELI001','974000','2025-12-11','1.020','1','kasir','2025-12-11 15:21:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00004902','X-00004902');
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-251211-0003','F225101143042','TIN','3','BELI','BELI001','E2D', 'X-00004902', 'CC X WEDDING C SLEP BM 22 8K','1.020','1.020','100.00','1037000','974000','954902','1017000','1','974000','974000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.020',berat_beli_asli=berat_beli_asli+'1.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.020',berat_akhir_asli=berat_akhir_asli+'1.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-11' 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-251211-0003','2025-12-11','2025-12-11','15:21:30','TIN','---','1.020','974000','974000','974000','974000','974000','kasir','2025-12-11 15:21:30','FB-251211-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251211-0003','AYU','KRADINAN MLILIR BBD','','','085649689607','kasir','2025-12-11 15:21:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-11' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251211-0025','K','2025-12-11','15:21:30','kasir','PEMBELIAN UMUM','FB-251211-0003','3677038000','974000','3676064000');
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-00004903','X-00004903','CC VELG POLOS CM 12 8K','GR','---','E1D','BELI','BELI001','1003000','2025-12-11','1.050','1','kasir','2025-12-11 15:21:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00004903','X-00004903');
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-251211-0004','F225101143041','TIN','4','BELI','BELI001','E1D', 'X-00004903', 'CC VELG POLOS CM 12 8K','1.050','1.050','100.00','1068000','1003000','955238','1017000','1','1003000','1003000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251211-0004','2025-12-11','2025-12-11','15:21:30','TIN','---','1.050','1003000','1003000','1003000','1003000','1003000','kasir','2025-12-11 15:21:30','FB-251211-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251211-0004','AYU','KRADINAN MLILIR BBD','','','085649689607','kasir','2025-12-11 15:21:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-11' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251211-0026','K','2025-12-11','15:21:30','kasir','PEMBELIAN UMUM','FB-251211-0004','3676064000','1003000','3675061000');
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-00004904','X-00004904','AT MODEL ITALY PANJANG VAR BW 8K','GR','---','A1E','BELI','BELI001','424000','2025-12-11','0.530','1','kasir','2025-12-11 15:21:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00004904','X-00004904');
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-251211-0005','F225071014013','TIN','5','BELI','BELI001','A1E', 'X-00004904', 'AT MODEL ITALY PANJANG VAR BW 8K','0.530','0.530','100.00','530000','424000','800000','1037000','1','424000','424000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251211-0005','2025-12-11','2025-12-11','15:21:30','TIN','---','0.530','424000','424000','424000','424000','424000','kasir','2025-12-11 15:21:30','FB-251211-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251211-0005','TRI WAHYUNI','DOLOPO','','','081392385177','kasir','2025-12-11 15:21:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-11' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251211-0027','K','2025-12-11','15:21:30','kasir','PEMBELIAN UMUM','FB-251211-0005','3675061000','424000','3674637000');
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 ('E1TD-YLAA-42-T','T0075700','TDE2 X YS 13 ','CC COR VELG KACA 13 YS 17K ','','GR','---','TD','E1TD','TOKO','01-SEM','1934500','2025-12-11','1934500','1.040','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:22:38','1.040','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1TD','E1TD-YLAA-42-T','T0075700');
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-12-11','E1TD-YLAA-42-T','E1TD','TOKO','01-SEM','100.00','1.040','1.040','1','1.040','1.040','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-00004905','X-00004905','CC MODEL PITA SLEP CM 13 8K','GR','---','E1E','BELI','BELI001','730000','2025-12-11','0.780','1','kasir','2025-12-11 15:22:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00004905','X-00004905');
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-251211-0006','F225180207062','RTA','1','BELI','BELI001','E1E', 'X-00004905', 'CC MODEL PITA SLEP CM 13 8K','0.780','0.780','100.00','842000','730000','935897','1037000','1','730000','730000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.780',berat_beli_asli=berat_beli_asli+'0.780',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.780',berat_akhir_asli=berat_akhir_asli+'0.780',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251211-0006','2025-12-11','2025-12-11','15:22:42','RTA','---','0.780','730000','730000','730000','730000','730000','kasir','2025-12-11 15:22:43','FB-251211-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251211-0006','DWI PURWATI','PONOROGO','','','','kasir','2025-12-11 15:22:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-11' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251211-0028','K','2025-12-11','15:22:42','kasir','PEMBELIAN UMUM','FB-251211-0006','3674637000','730000','3673907000');
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-00004906','X-00004906','GL RANTAI HOLLOW SIRIP UB 17K','GR','---','F3TE','BELI','BELI001','4991000','2025-12-11','3.050','1','kasir','2025-12-11 15:22:43');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3TE','X-00004906','X-00004906');
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-251211-0007','F225050820512','RTA','2','BELI','BELI001','F3TE', 'X-00004906', 'GL RANTAI HOLLOW SIRIP UB 17K','3.050','3.050','100.00','5546000','4991000','1636393','1880000','1','4991000','4991000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.050',berat_beli_asli=berat_beli_asli+'3.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.050',berat_akhir_asli=berat_akhir_asli+'3.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3TE' 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-251211-0007','2025-12-11','2025-12-11','15:22:42','RTA','---','3.050','4991000','4991000','4991000','4991000','4991000','kasir','2025-12-11 15:22:43','FB-251211-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251211-0007','TIKA SITI FAZDLIYA','','','','','kasir','2025-12-11 15:22:43');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-11' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251211-0029','K','2025-12-11','15:22:42','kasir','PEMBELIAN UMUM','FB-251211-0007','3673907000','4991000','3668916000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110244171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110244171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110244171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110819391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110819391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110819391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110819392' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110819392' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110819392';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110819393' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110819393' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110819393';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110819394' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110819394' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110819394';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110931191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110931191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110931191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111025351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111025351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111025351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111117301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111117301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111117301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111143001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111143001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111143001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111143002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111143002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111143002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111143003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111143003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111143003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111143004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111143004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111143004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111143005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111143005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111143005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111143006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111143006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111143006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111143007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111143007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111143007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111143008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111143008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111143008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111146251' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111146251' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111146251';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111146252' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111146252' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111146252';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111146253' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111146253' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111146253';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111157591' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111157591' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111157591';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225111253101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225111253101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225111253101';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251211-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251211-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251211-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251211-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251211-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251211-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251211-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251211-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251211-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251211-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251211-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251211-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251211-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251211-0007';
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 ('E1TD-YLAA-43-T','T0075701','TDE2 X YS 19 ','CC COR VELG KACA 19 YS 17K ','','GR','---','TD','E1TD','TOKO','01-SEM','1860000','2025-12-11','1860000','1.000','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:27:16','1.000','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1TD','E1TD-YLAA-43-T','T0075701');
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-12-11','E1TD-YLAA-43-T','E1TD','TOKO','01-SEM','100.00','1.000','1.000','1','1.000','1.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 ('E1TD-YLAA-44-T','T0075702','TDE2 X YS 16 ','CC COR VELG KACA 16 YS 17K ','','GR','---','TD','E1TD','TOKO','01-SEM','1916000','2025-12-11','1916000','1.030','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:28:06','1.030','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1TD','E1TD-YLAA-44-T','T0075702');
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-12-11','E1TD-YLAA-44-T','E1TD','TOKO','01-SEM','100.00','1.030','1.030','1','1.030','1.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 ('E1TD-YLAA-45-T','T0075703','TDE2 X CM 20 ','CC COR VELG POLOS 20 CM 17K ','','GR','---','TD','E1TD','TOKO','01-SEM','3720000','2025-12-11','3720000','2.000','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:29:43','2.000','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1TD','E1TD-YLAA-45-T','T0075703');
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-12-11','E1TD-YLAA-45-T','E1TD','TOKO','01-SEM','100.00','2.000','2.000','1','2.000','2.000','1');
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('E1TD-YLAA-42-T','T0075700','T0075700','CC COR VELG KACA 13 YS 17K ','CC COR VELG KACA 13 YS 17K','','','1934500','1934500',' 0','0','input','2025-12-11 15:31:13');
UPDATE tm_barang SET nama_barang='CC COR VELG KACA 13 YS 17K' ,nama_atribut='' ,kode_intern='TDE1 X YS 13 ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='E1TD-YLAA-42-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('E1TD-YLAA-43-T','T0075701','T0075701','CC COR VELG KACA 19 YS 17K ','CC COR VELG KACA 19 YS 17K','','','1860000','1860000',' 0','0','input','2025-12-11 15:31:28');
UPDATE tm_barang SET nama_barang='CC COR VELG KACA 19 YS 17K' ,nama_atribut='' ,kode_intern='TDE1 X YS 19 ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='E1TD-YLAA-43-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('E1TD-YLAA-44-T','T0075702','T0075702','CC COR VELG KACA 16 YS 17K ','CC COR VELG KACA 16 YS 17K','','','1916000','1916000',' 0','0','input','2025-12-11 15:31:42');
UPDATE tm_barang SET nama_barang='CC COR VELG KACA 16 YS 17K' ,nama_atribut='' ,kode_intern='TDE1 X YS 16 ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='E1TD-YLAA-44-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('E1TD-YLAA-45-T','T0075703','T0075703','CC COR VELG POLOS 20 CM 17K ','CC COR VELG POLOS 20 CM 17K','','','3720000','3720000',' 0','0','input','2025-12-11 15:31:54');
UPDATE tm_barang SET nama_barang='CC COR VELG POLOS 20 CM 17K' ,nama_atribut='' ,kode_intern='TDE1 X CM 20 ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='E1TD-YLAA-45-T' 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 ('E1TD-YLAA-46-T','T0075704','TDE1 X CM 16 ','CC COR VELG SLEP 16 CM 17K ','','GR','---','TD','E1TD','TOKO','01-SEM','3739000','2025-12-11','3739000','2.010','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:33:05','2.010','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1TD','E1TD-YLAA-46-T','T0075704');
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-12-11','E1TD-YLAA-46-T','E1TD','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 ('E1TD-YLAA-47-T','T0075705','TDE1 X OR 18 ','CC COR VELG SLEP 18 OR 17K ','','GR','---','TD','E1TD','TOKO','01-SEM','1767000','2025-12-11','1767000','0.950','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:34:29','0.950','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1TD','E1TD-YLAA-47-T','T0075705');
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-12-11','E1TD-YLAA-47-T','E1TD','TOKO','01-SEM','100.00','0.950','0.950','1','0.950','0.950','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 ('E1TD-YLAA-48-T','T0075706','TDE1 X BM 16 ','CC COR VELG MATA SLEP 16 BM 17K ','','GR','---','TD','E1TD','TOKO','01-SEM','5543000','2025-12-11','5543000','2.980','100.00','17','','1860000.00','1','0.04', 'input','2025-12-11 15:35:44','2.980','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1TD' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1TD','E1TD-YLAA-48-T','T0075706');
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-12-11','E1TD-YLAA-48-T','E1TD','TOKO','01-SEM','100.00','2.980','2.980','1','2.980','2.980','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-251211-0005','1','E1TD-YLAA-42-T','1','1.04','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E1TD-YLAA-42-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-12-11','TOKO','TBK-E','E1TD','E1TD-YLAA-42-T' , '1','1.04','1.04', '1','1.04','1.04','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.04',berat_out_asli=berat_out_asli+'1.04',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1TD-YLAA-42-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-251211-0005','2','E1TD-YLAA-43-T','1','1','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E1TD-YLAA-43-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-12-11','TOKO','TBK-E','E1TD','E1TD-YLAA-43-T' , '1','1','1', '1','1','1','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1',berat_out_asli=berat_out_asli+'1',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1TD-YLAA-43-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-251211-0005','3','E1TD-YLAA-44-T','1','1.03','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E1TD-YLAA-44-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-12-11','TOKO','TBK-E','E1TD','E1TD-YLAA-44-T' , '1','1.03','1.03', '1','1.03','1.03','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.03',berat_out_asli=berat_out_asli+'1.03',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1TD-YLAA-44-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-251211-0005','4','E1TD-YLAA-45-T','1','2','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E1TD-YLAA-45-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-12-11','TOKO','TBK-E','E1TD','E1TD-YLAA-45-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='E1TD-YLAA-45-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-251211-0005','5','E1TD-YLAA-46-T','1','2.01','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E1TD-YLAA-46-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-12-11','TOKO','TBK-E','E1TD','E1TD-YLAA-46-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='E1TD-YLAA-46-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-251211-0005','6','E1TD-YLAA-47-T','1','0.95','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E1TD-YLAA-47-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-12-11','TOKO','TBK-E','E1TD','E1TD-YLAA-47-T' , '1','0.95','0.95', '1','0.95','0.95','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.95',berat_out_asli=berat_out_asli+'0.95',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1TD-YLAA-47-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-251211-0005','7','E1TD-YLAA-48-T','1','2.98','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E1TD-YLAA-48-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-12-11','TOKO','TBK-E','E1TD','E1TD-YLAA-48-T' , '1','2.98','2.98', '1','2.98','2.98','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.98',berat_out_asli=berat_out_asli+'2.98',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E1TD-YLAA-48-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-251211-0005','8','E2TD-YLAA-25-T','1','2.06','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E2TD-YLAA-25-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-12-11','TOKO','TBK-E','E2TD','E2TD-YLAA-25-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='E2TD-YLAA-25-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-251211-0005','9','E2TD-YLAA-26-T','1','1.3','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E2TD-YLAA-26-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-12-11','TOKO','TBK-E','E2TD','E2TD-YLAA-26-T' , '1','1.3','1.3', '1','1.3','1.3','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.3',berat_out_asli=berat_out_asli+'1.3',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2TD-YLAA-26-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-251211-0005','10','E2TD-YLAA-27-T','1','1.13','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E2TD-YLAA-27-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-12-11','TOKO','TBK-E','E2TD','E2TD-YLAA-27-T' , '1','1.13','1.13', '1','1.13','1.13','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.13',berat_out_asli=berat_out_asli+'1.13',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2TD-YLAA-27-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-251211-0005','11','E2TD-YLAA-28-T','1','1.98','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E2TD-YLAA-28-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-12-11','TOKO','TBK-E','E2TD','E2TD-YLAA-28-T' , '1','1.98','1.98', '1','1.98','1.98','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.98',berat_out_asli=berat_out_asli+'1.98',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2TD-YLAA-28-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-251211-0005','12','E2TD-YLAA-29-T','1','2.08','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E2TD-YLAA-29-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-12-11','TOKO','TBK-E','E2TD','E2TD-YLAA-29-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='E2TD-YLAA-29-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-251211-0005','13','E2TD-YLAA-30-T','1','2.1','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E2TD-YLAA-30-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-12-11','TOKO','TBK-E','E2TD','E2TD-YLAA-30-T' , '1','2.1','2.1', '1','2.1','2.1','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.1',berat_out_asli=berat_out_asli+'2.1',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2TD-YLAA-30-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-251211-0005','14','E2TD-YLAA-31-T','1','1.75','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E2TD-YLAA-31-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-12-11','TOKO','TBK-E','E2TD','E2TD-YLAA-31-T' , '1','1.75','1.75', '1','1.75','1.75','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.75',berat_out_asli=berat_out_asli+'1.75',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2TD-YLAA-31-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-251211-0005','15','E2TD-YLAA-32-T','1','1.85','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E2TD-YLAA-32-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-12-11','TOKO','TBK-E','E2TD','E2TD-YLAA-32-T' , '1','1.85','1.85', '1','1.85','1.85','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.85',berat_out_asli=berat_out_asli+'1.85',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2TD-YLAA-32-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-251211-0005','16','E2TD-YLAA-33-T','1','1.55','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E2TD-YLAA-33-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-12-11','TOKO','TBK-E','E2TD','E2TD-YLAA-33-T' , '1','1.55','1.55', '1','1.55','1.55','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.55',berat_out_asli=berat_out_asli+'1.55',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2TD-YLAA-33-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-251211-0005','17','E2TD-YLAA-34-T','1','1.26','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E2TD-YLAA-34-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-12-11','TOKO','TBK-E','E2TD','E2TD-YLAA-34-T' , '1','1.26','1.26', '1','1.26','1.26','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.26',berat_out_asli=berat_out_asli+'1.26',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2TD-YLAA-34-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-251211-0005','18','E2TD-YLAA-35-T','1','1.4','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E2TD-YLAA-35-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-12-11','TOKO','TBK-E','E2TD','E2TD-YLAA-35-T' , '1','1.4','1.4', '1','1.4','1.4','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.4',berat_out_asli=berat_out_asli+'1.4',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2TD-YLAA-35-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-251211-0005','19','E2TD-YLAA-36-T','1','1.22','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E2TD-YLAA-36-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-12-11','TOKO','TBK-E','E2TD','E2TD-YLAA-36-T' , '1','1.22','1.22', '1','1.22','1.22','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.22',berat_out_asli=berat_out_asli+'1.22',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2TD-YLAA-36-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-251211-0005','20','E2TD-YLAA-37-T','1','0.85','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E2TD-YLAA-37-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-12-11','TOKO','TBK-E','E2TD','E2TD-YLAA-37-T' , '1','0.85','0.85', '1','0.85','0.85','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.85',berat_out_asli=berat_out_asli+'0.85',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2TD-YLAA-37-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-251211-0005','21','E2TD-YLAA-38-T','1','1.13','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E2TD-YLAA-38-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-12-11','TOKO','TBK-E','E2TD','E2TD-YLAA-38-T' , '1','1.13','1.13', '1','1.13','1.13','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.13',berat_out_asli=berat_out_asli+'1.13',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2TD-YLAA-38-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-251211-0005','22','E2TD-YLAA-39-T','1','1.35','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E2TD-YLAA-39-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-12-11','TOKO','TBK-E','E2TD','E2TD-YLAA-39-T' , '1','1.35','1.35', '1','1.35','1.35','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.35',berat_out_asli=berat_out_asli+'1.35',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2TD-YLAA-39-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-251211-0005','23','E2TD-YLAA-40-T','1','1.51','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E2TD-YLAA-40-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-12-11','TOKO','TBK-E','E2TD','E2TD-YLAA-40-T' , '1','1.51','1.51', '1','1.51','1.51','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.51',berat_out_asli=berat_out_asli+'1.51',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2TD-YLAA-40-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-251211-0005','24','E2TD-YLAA-41-T','1','1.4','0','TOKO','01-SEM','TOKO','TBK-E');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-E' WHERE kode_barang = 'E2TD-YLAA-41-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-12-11','TOKO','TBK-E','E2TD','E2TD-YLAA-41-T' , '1','1.4','1.4', '1','1.4','1.4','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.4',berat_out_asli=berat_out_asli+'1.4',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='E2TD-YLAA-41-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-251211-0005','2025-12-11','2025-12-11','15:36','36.93','input','2025-12-11 15:36:41');
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 ('F225110357541','kasir','1',' MEA1 BM ','TOKO','SMBK-A','A1E-YLXD-11-T','AT COR MODEL ITALY BM 8K ','','0.600','1','100.00','620000','0','0','15000','624000','0','0','0','624000','RHM','T0075479','A1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLXD-11-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-12-11' AND kode_barang='A1E-YLXD-11-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 ('F225110357541','2025-12-11','0.600','2025-12-11','15:57:55','PLG0075582','624000','624000','0','624000','624000','kasir','2025-12-11 15:57:54','F22511035754');
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-12-11','F225110357541','2025-12-11','15:57:55','RHM','624000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251211-0030','D','2025-12-11','15:57:55','kasir','PENJUALAN','F225110357541','3668916000','624000','3669540000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='624000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110357541' 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 ('F225110357542','kasir',' 1',' MEA1 BM ','TOKO','SMBK-A','A1E-YLXD-2-T','AT COR MODEL ITALY BM 8K ','','0.570','1','100.00','589000','0','0','15000','593000','0','0','0','593000','RHM','T0075470','A1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YLXD-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.570',berat_jual_asli=berat_jual_asli+'0.570',stock_jual='1',berat_akhir=berat_akhir-'0.570',berat_akhir_asli=berat_akhir_asli-'0.570',stock_akhir='0' WHERE tanggal='2025-12-11' AND kode_barang='A1E-YLXD-2-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 ('F225110357542','2025-12-11','0.570','2025-12-11','15:57:55','PLG0075583','593000','593000','0','593000','593000','kasir','2025-12-11 15:57:54','F22511035754');
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-12-11','F225110357542','2025-12-11','15:57:55','RHM','593000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251211-0031','D','2025-12-11','15:57:55','kasir','PENJUALAN','F225110357542','3669540000','593000','3670133000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='593000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110357542' 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 ('F225110357543','kasir',' 1',' MEA1 BW ','TOKO','SMBK-A','A1E-YKBH-108-T','AT MODEL ITALY PANJANG VAR BW 8K ','','0.530','1','100.00','548000','0','0','15000','551000','0','0','0','551000','RHM','T0075340','A1E','0','0','-','0','1037000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YKBH-108-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-12-11' AND kode_barang='A1E-YKBH-108-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 ('F225110357543','2025-12-11','0.530','2025-12-11','15:57:55','PLG0075584','551000','551000','0','551000','551000','kasir','2025-12-11 15:57:54','F22511035754');
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-12-11','F225110357543','2025-12-11','15:57:55','RHM','551000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251211-0032','D','2025-12-11','15:57:55','kasir','PENJUALAN','F225110357543','3670133000','551000','3670684000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='551000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110357543' 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 ('F225110357544','kasir',' 1',' MFA1F HW ','TOKO','SMBK-A','A1F-YJBC-37-T','AT MODEL HATI ARESO HW 8K ','','0.660','1','100.00','695000','0','0','15000','700000','0','0','0','700000','RHM','T0074410','A1F','0','0','-','0','1053000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-YJBC-37-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-12-11' AND kode_barang='A1F-YJBC-37-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 ('F225110357544','2025-12-11','0.660','2025-12-11','15:57:55','PLG0075585','700000','700000','0','700000','700000','kasir','2025-12-11 15:57:54','F22511035754');
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-12-11','F225110357544','2025-12-11','15:57:55','RHM','700000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251211-0033','D','2025-12-11','15:57:55','kasir','PENJUALAN','F225110357544','3670684000','700000','3671384000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='700000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110357544' 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 ('F225110357545','kasir',' 1',' MFA1F HW ','TOKO','SMBK-A','A1F-YJBC-36-T','AT MODEL HATI ARESO HW 8K ','','0.700','1','100.00','737000','0','0','15000','742000','0','0','0','742000','RHM','T0074409','A1F','0','0','-','0','1053000');
UPDATE tm_barang SET tgl_last_jual='2025-12-11', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1F-YJBC-36-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2025-12-11' AND kode_barang='A1F-YJBC-36-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 ('F225110357545','2025-12-11','0.700','2025-12-11','15:57:55','PLG0075586','742000','742000','0','742000','742000','kasir','2025-12-11 15:57:54','F22511035754');
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-12-11','F225110357545','2025-12-11','15:57:55','RHM','742000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-251211-0034','D','2025-12-11','15:57:55','kasir','PENJUALAN','F225110357545','3671384000','742000','3672126000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='742000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225110357545' LIMIT 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-00004907','X-00004907','CC VELG KACA CM 14','GR','---','E1TE','BELI','BELI001','2175000','2025-12-11','1.450','1','kasir','2025-12-11 16:01:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1TE','X-00004907','X-00004907');
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-251211-0008','F224070111291','TIN','1','BELI','BELI001','E1TE', 'X-00004907', 'CC VELG KACA CM 14','1.480','1.450','100.00','1273000','2175000','1500000','1880000','1','2175000','2175000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.450',berat_beli_asli=berat_beli_asli+'1.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.450',berat_akhir_asli=berat_akhir_asli+'1.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-11' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1TE' 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-251211-0008','2025-12-11','2025-12-11','16:01:03','TIN','---','1.450','2175000','2175000','2175000','2175000','2175000','kasir','2025-12-11 16:01:03','FB-251211-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251211-0008','MB IMA','JL SINGASARI KADIPATEN','','','','kasir','2025-12-11 16:01:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-11' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251211-0035','K','2025-12-11','16:01:03','kasir','PEMBELIAN UMUM','FB-251211-0008','3672126000','2175000','3669951000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110357541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110357541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110357541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110357542' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110357542' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110357542';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110357543' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110357543' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110357543';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110357544' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110357544' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110357544';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225110357545' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225110357545' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225110357545';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251211-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251211-0008';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-12','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-11';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-11';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-11';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-12-11' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-11';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-11';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-11';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-11';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-12' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-11' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251212-0001','D','2025-12-12','16:14:58','SYSTEM','SALDO AWAL','SALDO AWAL','0','3669951000','3669951000');
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-251212-0001','D','2025-12-12','16:14:58','BCA','SALDO AWAL','SALDO AWAL','0','4182171888','4182171888');
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-251212-0001','D','2025-12-12','16:14:58','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-251212-0001','D','2025-12-12','16:14:58','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-251212-0001','D','2025-12-12','16:14:58','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-251212-0001','D','2025-12-12','16:14:58','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2025-12-12';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251212-0001','1','F1TE-YFAF-7-T','1','5.060','TOKO','PTBK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F1TE-YFAF-7-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F1TE-YFAF-7-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_group_export WHERE kode_group='TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_group_export SELECT * FROM tm_group WHERE kode_group='TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_dept_export WHERE kode_dept='F1TE' LIMIT 1;
INSERT INTO db_nagagold_dewigold3.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F1TE' LIMIT 1;
DELETE FROM db_nagagold_dewigold3.tm_lokasi_toko_export WHERE kode_lokasi_toko='PTBK-F';
INSERT INTO db_nagagold_dewigold3.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PTBK-F';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='F1TE-YFAF-7-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.060',berat_out_asli='5.060', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.060',berat_akhir_asli =berat_akhir_asli-'5.060' WHERE kode_barang='F1TE-YFAF-7-T' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-251212-0001','2025-12-12','2025-12-12','16:42','5.060','input','251212');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251212-0001','1','F3F-YKXD-105-0','1','0.520','0.520','TOKO','SBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3F-YKXD-105-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3F-YKXD-105-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2025-12-12 16:43:53' WHERE kode_barang='F3F-YKXD-105-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3F-YKXD-105-0' LIMIT 1;
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-12-12 16:43:53','TOKO','SMBK-F','F3F','F3F-YKXD-105-0','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3F-YKXD-105-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3F-YKXD-105-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251212-0001','1','F3E-YKBH-96-0','1','2.070','2.070','TOKO','SBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YKBH-96-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YKBH-96-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2025-12-12 16:43:53' WHERE kode_barang='F3E-YKBH-96-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YKBH-96-0' LIMIT 1;
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-12-12 16:43:53','TOKO','SMBK-F','F3E','F3E-YKBH-96-0','1','2.070','2.070','1','2.070','2.070','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-YKBH-96-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YKBH-96-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251212-0001','2025-12-12','16:43','2.590','input','2025-12-11 16:43:52');