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 ('F225300838041','kasir','1',' MEF1 X CM ','TOKO','SMBK-F','F1E-XJBH-71-0','GL X OSROT TINJU ANAK CM 8K ','OL','2.650','1','100.00','2663000','0','0','15000','2690000','0','13000','0','2703000','NS','00324352','F1E','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-XJBH-71-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.650',berat_jual_asli=berat_jual_asli+'2.650',stock_jual='1',berat_akhir=berat_akhir-'2.650',berat_akhir_asli=berat_akhir_asli-'2.650',stock_akhir='0' WHERE tanggal='2025-10-30' AND kode_barang='F1E-XJBH-71-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225300838041','2025-10-30','2.650','2025-10-30','08:38:05','PLG0074216','2690000','2690000','13000','2703000','2703000','kasir','2025-10-30 08:38:04','F22530083804');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-30','F225300838041','2025-10-30','08:38:05','NS','2703000','13000');
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-251030-0002','D','2025-10-30','08:38:05','kasir','PENJUALAN','F225300838041','2078381000','2703000','2081084000');
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 ('F225301040041','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YJXF-86-T','LT SLOBOK BALOK HURUF BG P 8K ','OL','0.420','1','100.00','439000','0','0','15000','443000','0','5000','0','448000','TJ','T0073984','D1G','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2025-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YJXF-86-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.420',berat_jual_asli=berat_jual_asli+'0.420',stock_jual='1',berat_akhir=berat_akhir-'0.420',berat_akhir_asli=berat_akhir_asli-'0.420',stock_akhir='0' WHERE tanggal='2025-10-30' AND kode_barang='D1G-YJXF-86-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225301040041','2025-10-30','0.420','2025-10-30','10:40:04','PLG0074217','443000','443000','5000','448000','448000','kasir','2025-10-30 10:40:04','F22530104004');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-30','F225301040041','2025-10-30','10:40:04','TJ','448000','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-251030-0003','D','2025-10-30','10:40:04','kasir','PENJUALAN','F225301040041','2081084000','448000','2081532000');
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 ('F225301040411','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YJBI-133-T','LT SLOBOK BULAT HURUF BG S 8K','OL','0.450','1','100.00','470000','0','0','15000','473000','0','5000','0','478000','TJ','T0074693','D1G','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2025-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YJBI-133-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.450',berat_jual_asli=berat_jual_asli+'0.450',stock_jual='1',berat_akhir=berat_akhir-'0.450',berat_akhir_asli=berat_akhir_asli-'0.450',stock_akhir='0' WHERE tanggal='2025-10-30' AND kode_barang='D1G-YJBI-133-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225301040411','2025-10-30','0.450','2025-10-30','10:40:41','PLG0074218','473000','473000','5000','478000','0','kasir','2025-10-30 10:40:41','F22530104041');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-30','F225301040411','2025-10-30','10:40:41','TJ','478000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251030-0001','2025-10-30','2025-10-30 10:40:41','PENJUALAN : F225301040411','8945708450','BCA','478000','478000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251030-0002','D','2025-10-30','10:40:41','BCA','PENJUALAN','F225301040411','4097577888','478000','4098055888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('8945708450','WIDYA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='478000' WHERE no_faktur_jual='F225301040411' 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 ('F225301041101','kasir','1',' MGD1 5K BG','TOKO','SMBK-D','D1G-YJBI-132-T','LT SLOBOK BULAT HURUF BG W 8K','OL','0.720','1','100.00','752000','0','0','15000','756000','0','5000','0','761000','TJ','T0074692','D1G','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2025-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YJBI-132-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.720',berat_jual_asli=berat_jual_asli+'0.720',stock_jual='1',berat_akhir=berat_akhir-'0.720',berat_akhir_asli=berat_akhir_asli-'0.720',stock_akhir='0' WHERE tanggal='2025-10-30' AND kode_barang='D1G-YJBI-132-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225301041101','2025-10-30','0.720','2025-10-30','10:41:11','PLG0074219','756000','756000','5000','761000','0','kasir','2025-10-30 10:41:10','F22530104110');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-30','F225301041101','2025-10-30','10:41:11','TJ','761000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251030-0002','2025-10-30','2025-10-30 10:41:10','PENJUALAN : F225301041101','87502494809','BCA','761000','761000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251030-0003','D','2025-10-30','10:41:11','BCA','PENJUALAN','F225301041101','4098055888','761000','4098816888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('87502494809','WIDYA');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='761000' WHERE no_faktur_jual='F225301041101' 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 ('F225301100521','kasir','1',' MEE2 HTM 1','TOKO','SMBK-E','E2E-YIBI-194-0','CC PIPA MODEL MATA VAR HTM 18 8K ','','0.500','1','100.00','502000','0','0','15000','500000','0','0','0','500000','RTA','00371065','E2E','0','0','-','1','1005000');
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 ('F225301102561','kasir','1',' MEE2E HW 1','TOKO','SMBK-E','E2E-YJBC-7-T','CC MODEL PITA MATA HW 17 8K ','','0.500','1','100.00','502000','0','0','15000','500000','0','0','0','500000','RTA','T0074380','E2E','0','0','-','1','1005000');
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 ('F225301104321','kasir','1',' MEE2E HW 1','TOKO','SMBK-E','E2E-YJBC-7-T','CC MODEL PITA MATA HW 17 8K ','','0.500','1','100.00','502000','0','0','15000','500000','0','0','0','500000','RTA','T0074380','E2E','0','0','-','1','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJBC-7-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-10-30' AND kode_barang='E2E-YJBC-7-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 ('F225301104321','2025-10-30','0.500','2025-10-30','11:04:33','PLG0074222','500000','500000','0','500000','0','kasir','2025-10-30 11:04:32','F22530110432');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-30','F225301104321','2025-10-30','11:04:33','RTA','500000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251030-0003','2025-10-30','2025-10-30 11:04:32','PENJUALAN : F225301104321','878776676565','BCA','500000','500000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251030-0004','D','2025-10-30','11:04:33','BCA','PENJUALAN','F225301104321','4098816888','500000','4099316888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('878776676565','INTAN');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='500000' WHERE no_faktur_jual='F225301104321' 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 ('F225301105341','kasir','1',' MEE2 HTM 1','TOKO','SMBK-E','E2E-YIBI-194-0','CC PIPA MODEL MATA VAR HTM 18 8K ','','0.500','1','100.00','502000','0','0','15000','500000','0','0','0','500000','RTA','00371065','E2E','0','0','-','1','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YIBI-194-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-10-30' AND kode_barang='E2E-YIBI-194-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225301105341','2025-10-30','0.500','2025-10-30','11:05:34','PLG0074223','500000','500000','0','500000','0','kasir','2025-10-30 11:05:34','F22530110534');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-30','F225301105341','2025-10-30','11:05:34','RTA','500000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251030-0004','2025-10-30','2025-10-30 11:05:34','PENJUALAN : F225301105341','878767665','BCA','500000','500000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251030-0005','D','2025-10-30','11:05:34','BCA','PENJUALAN','F225301105341','4099316888','500000','4099816888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('878767665','INTAN');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='500000' WHERE no_faktur_jual='F225301105341' 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-251030-0001','1','F3E-YJAF-12-T','1','3.160','3.160','TOKO','SMBK-F','TOKO','BK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='BK-F' WHERE kode_barang='F3E-YJAF-12-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-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-10-30','TOKO','BK-F','F3E','F3E-YJAF-12-T','100.00','1','3.160','3.160','1','3.160','3.160');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.160',berat_out_asli=berat_out_asli+'3.160',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-30' AND kode_barang='F3E-YJAF-12-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SMBK-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-251030-0001','2025-10-30','2025-10-30','11:16','3.16','admin','2025-10-30 11:16:52');
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 ('E1F-YJCX-1-T','T0074705','MFE1 UB 12 ','CC MODEL GELOMBANG VAR UB 12 8K ','','GR','---','MF','E1F','TOKO','01-SEM','738000','2025-10-30','738000','0.680','100.00','8','0','1085000.00','1','0.04', 'input','2025-10-30 11:27:40','0.680','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1F','E1F-YJCX-1-T','T0074705');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','E1F-YJCX-1-T','E1F','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 ('E1F-YJCX-2-T','T0074706','MFE1 UB 14 ','CC MODEL GELOMBANG VAR UB 14 8K ','','GR','---','MF','E1F','TOKO','01-SEM','781500','2025-10-30','781500','0.720','100.00','8','0','1085000.00','1','0.04', 'input','2025-10-30 11:27:50','0.720','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1F','E1F-YJCX-2-T','T0074706');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','E1F-YJCX-2-T','E1F','TOKO','01-SEM','100.00','0.720','0.720','1','0.720','0.720','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 ('E1F-YJCX-3-T','T0074707','MFE1 UB 14 ','CC MODEL GELOMBANG VAR UB 14 8K ','','GR','---','MF','E1F','TOKO','01-SEM','781500','2025-10-30','781500','0.720','100.00','8','0','1085000.00','1','0.04', 'input','2025-10-30 11:27:56','0.720','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1F','E1F-YJCX-3-T','T0074707');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','E1F-YJCX-3-T','E1F','TOKO','01-SEM','100.00','0.720','0.720','1','0.720','0.720','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 ('E1F-YJCX-4-T','T0074708','MFE1 UB 14 ','CC MODEL GELOMBANG VAR UB 14 8K ','','GR','---','MF','E1F','TOKO','01-SEM','781500','2025-10-30','781500','0.720','100.00','8','0','1085000.00','1','0.04', 'input','2025-10-30 11:28:02','0.720','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'E1F' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('E1F','E1F-YJCX-4-T','T0074708');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','E1F-YJCX-4-T','E1F','TOKO','01-SEM','100.00','0.720','0.720','1','0.720','0.720','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-YJCX-5-T','T0074709','MEF3 KH ','GL RANTAI HOLLOW DOUBLE KH 8K ','','GR','---','ME','F3E','TOKO','01-SEM','3085500','2025-10-30','3085500','3.070','100.00','8','0','1005000.00','1','0.04', 'input','2025-10-30 11:28:50','3.070','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-YJCX-5-T','T0074709');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','F3E-YJCX-5-T','F3E','TOKO','01-SEM','100.00','3.070','3.070','1','3.070','3.070','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-YJCX-6-T','T0074710','MEF3 HW ','GL MODEL FLIK P3 SLEP VAR HW 8K ','','GR','---','ME','F3E','TOKO','01-SEM','2583000','2025-10-30','2583000','2.570','100.00','8','0','1005000.00','1','0.04', 'input','2025-10-30 11:30:10','2.570','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-YJCX-6-T','T0074710');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','F3E-YJCX-6-T','F3E','TOKO','01-SEM','100.00','2.570','2.570','1','2.570','2.570','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-YJCX-7-T','T0074711','MEF3 HW ','GL MODEL FLIK P3 SLEP VAR HW 8K ','','GR','---','ME','F3E','TOKO','01-SEM','2583000','2025-10-30','2583000','2.570','100.00','8','0','1005000.00','1','0.04', 'input','2025-10-30 11:30:19','2.570','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-YJCX-7-T','T0074711');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','F3E-YJCX-7-T','F3E','TOKO','01-SEM','100.00','2.570','2.570','1','2.570','2.570','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-YJCX-8-T','T0074712','MEF3 HW ','GL RANTAI HOLLOW FLIK VAR HW 8K ','','GR','---','ME','F3E','TOKO','01-SEM','1306500','2025-10-30','1306500','1.300','100.00','8','0','1005000.00','1','0.04', 'input','2025-10-30 11:31:04','1.300','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-YJCX-8-T','T0074712');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','F3E-YJCX-8-T','F3E','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 ('F3E-YJCX-9-T','T0074713','MEF3 HW ','GL RANTAI HOLLOW FLIK VAR HW 8K ','','GR','---','ME','F3E','TOKO','01-SEM','1317000','2025-10-30','1317000','1.310','100.00','8','0','1005000.00','1','0.04', 'input','2025-10-30 11:31:11','1.310','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-YJCX-9-T','T0074713');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','F3E-YJCX-9-T','F3E','TOKO','01-SEM','100.00','1.310','1.310','1','1.310','1.310','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-YJCX-10-T','T0074714','MEF3 HW ','GL RANTAI HOLLOW FLIK VAR HW 8K ','','GR','---','ME','F3E','TOKO','01-SEM','1357000','2025-10-30','1357000','1.350','100.00','8','0','1005000.00','1','0.04', 'input','2025-10-30 11:31:46','1.350','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-YJCX-10-T','T0074714');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','F3E-YJCX-10-T','F3E','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 ('F3E-YJCX-11-T','T0074715','MEF3 HW ','GL RANTAI HOLLOW FLIK VAR HW 8K ','','GR','---','ME','F3E','TOKO','01-SEM','1377000','2025-10-30','1377000','1.370','100.00','8','0','1005000.00','1','0.04', 'input','2025-10-30 11:32:07','1.370','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-YJCX-11-T','T0074715');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','F3E-YJCX-11-T','F3E','TOKO','01-SEM','100.00','1.370','1.370','1','1.370','1.370','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3E-YJCX-12-T','T0074716','MEF3 HW ','GL RANTAI HOLLOW CAPELA VAR HW 8K ','','GR','---','ME','F3E','TOKO','01-SEM','1507500','2025-10-30','1507500','1.500','100.00','8','0','1005000.00','1','0.04', 'input','2025-10-30 11:32:34','1.500','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-YJCX-12-T','T0074716');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','F3E-YJCX-12-T','F3E','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 ('F3E-YJCX-13-T','T0074717','MEF3 HW ','GL RANTAI HOLLOW CAPELA VAR HW 8K ','','GR','---','ME','F3E','TOKO','01-SEM','1507500','2025-10-30','1507500','1.500','100.00','8','0','1005000.00','1','0.04', 'input','2025-10-30 11:32:41','1.500','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3E','F3E-YJCX-13-T','T0074717');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','F3E-YJCX-13-T','F3E','TOKO','01-SEM','100.00','1.500','1.500','1','1.500','1.500','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-251030-0002','1','E1F-YJCX-1-T','1','0.680','0.680','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-E' WHERE kode_barang='E1F-YJCX-1-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
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-10-30','TOKO','SMBK-E','E1F','E1F-YJCX-1-T','100.00','1','0.680','0.680','1','0.680','0.680');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.680',berat_out_asli=berat_out_asli+'0.680',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-30' AND kode_barang='E1F-YJCX-1-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
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-251030-0002','2','E1F-YJCX-2-T','1','0.720','0.720','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-E' WHERE kode_barang='E1F-YJCX-2-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
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-10-30','TOKO','SMBK-E','E1F','E1F-YJCX-2-T','100.00','1','0.720','0.720','1','0.720','0.720');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.720',berat_out_asli=berat_out_asli+'0.720',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-30' AND kode_barang='E1F-YJCX-2-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
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-251030-0002','3','E1F-YJCX-3-T','1','0.720','0.720','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-E' WHERE kode_barang='E1F-YJCX-3-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
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-10-30','TOKO','SMBK-E','E1F','E1F-YJCX-3-T','100.00','1','0.720','0.720','1','0.720','0.720');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.720',berat_out_asli=berat_out_asli+'0.720',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-30' AND kode_barang='E1F-YJCX-3-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
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-251030-0002','4','E1F-YJCX-4-T','1','0.720','0.720','TOKO','01-SEM','TOKO','SMBK-E');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-E' WHERE kode_barang='E1F-YJCX-4-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
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-10-30','TOKO','SMBK-E','E1F','E1F-YJCX-4-T','100.00','1','0.720','0.720','1','0.720','0.720');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.720',berat_out_asli=berat_out_asli+'0.720',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-30' AND kode_barang='E1F-YJCX-4-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' 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-251030-0002','2025-10-30','2025-10-30','11:33','2.84','input','2025-10-30 11:33:16');
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-251030-0003','1','F3E-YJCX-10-T','1','1.35','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-YJCX-10-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-30','TOKO','SMBK-F','F3E','F3E-YJCX-10-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='F3E-YJCX-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-251030-0003','2','F3E-YJCX-11-T','1','1.37','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-YJCX-11-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-30','TOKO','SMBK-F','F3E','F3E-YJCX-11-T' , '1','1.37','1.37', '1','1.37','1.37','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.37',berat_out_asli=berat_out_asli+'1.37',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-YJCX-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-251030-0003','3','F3E-YJCX-12-T','1','1.5','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-YJCX-12-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-30','TOKO','SMBK-F','F3E','F3E-YJCX-12-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='F3E-YJCX-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-251030-0003','4','F3E-YJCX-13-T','1','1.5','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-YJCX-13-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-30','TOKO','SMBK-F','F3E','F3E-YJCX-13-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='F3E-YJCX-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-251030-0003','5','F3E-YJCX-5-T','1','3.07','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-YJCX-5-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-30','TOKO','SMBK-F','F3E','F3E-YJCX-5-T' , '1','3.07','3.07', '1','3.07','3.07','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.07',berat_out_asli=berat_out_asli+'3.07',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-YJCX-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-251030-0003','6','F3E-YJCX-6-T','1','2.57','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-YJCX-6-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-30','TOKO','SMBK-F','F3E','F3E-YJCX-6-T' , '1','2.57','2.57', '1','2.57','2.57','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.57',berat_out_asli=berat_out_asli+'2.57',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-YJCX-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-251030-0003','7','F3E-YJCX-7-T','1','2.57','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-YJCX-7-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-30','TOKO','SMBK-F','F3E','F3E-YJCX-7-T' , '1','2.57','2.57', '1','2.57','2.57','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.57',berat_out_asli=berat_out_asli+'2.57',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-YJCX-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-251030-0003','8','F3E-YJCX-8-T','1','1.3','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-YJCX-8-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-30','TOKO','SMBK-F','F3E','F3E-YJCX-8-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='F3E-YJCX-8-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251030-0003','9','F3E-YJCX-9-T','1','1.31','0','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-F' WHERE kode_barang = 'F3E-YJCX-9-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-30','TOKO','SMBK-F','F3E','F3E-YJCX-9-T' , '1','1.31','1.31', '1','1.31','1.31','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.31',berat_out_asli=berat_out_asli+'1.31',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3E-YJCX-9-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('PB-251030-0003','2025-10-30','2025-10-30','11:33','16.54','input','2025-10-30 11:33:54');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJCX-14-T','T0074718','MEH1 UB 42 ','KL GUCCI UB 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','2010000','2025-10-30','2010000','2.000','100.00','8','0','1005000.00','1','0.04', 'input','2025-10-30 12:02:44','2.000','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJCX-14-T','T0074718');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','H1E-YJCX-14-T','H1E','TOKO','01-SEM','100.00','2.000','2.000','1','2.000','2.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJCX-15-T','T0074719','MEH1 UB 42 ','KL GUCCI UB 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','2010000','2025-10-30','2010000','2.000','100.00','8','0','1005000.00','1','0.04', 'input','2025-10-30 12:02:52','2.000','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJCX-15-T','T0074719');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','H1E-YJCX-15-T','H1E','TOKO','01-SEM','100.00','2.000','2.000','1','2.000','2.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJCX-16-T','T0074720','MEH1 LT 40 ','KL NORY LT 40CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','1015500','2025-10-30','1015500','1.010','100.00','8','0','1005000.00','1','0.04', 'input','2025-10-30 12:03:58','1.010','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJCX-16-T','T0074720');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','H1E-YJCX-16-T','H1E','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 ('H1E-YJCX-17-T','T0074721','MEH1 LT 40 ','KL NORY LT 40CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','1025500','2025-10-30','1025500','1.020','100.00','8','0','1005000.00','1','0.04', 'input','2025-10-30 12:04:09','1.020','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJCX-17-T','T0074721');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','H1E-YJCX-17-T','H1E','TOKO','01-SEM','100.00','1.020','1.020','1','1.020','1.020','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJCX-18-T','T0074722','MEH1 LT 42 ','KL NORY LT 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','1538000','2025-10-30','1538000','1.530','100.00','8','0','1005000.00','1','0.04', 'input','2025-10-30 12:04:43','1.530','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJCX-18-T','T0074722');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','H1E-YJCX-18-T','H1E','TOKO','01-SEM','100.00','1.530','1.530','1','1.530','1.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 ('H1E-YJCX-19-T','T0074723','MEH1 LT 42 ','KL NORY LT 42CM 8K ','','GR','---','ME','H1E','TOKO','01-SEM','1538000','2025-10-30','1538000','1.530','100.00','8','0','1005000.00','1','0.04', 'input','2025-10-30 12:04:52','1.530','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJCX-19-T','T0074723');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','H1E-YJCX-19-T','H1E','TOKO','01-SEM','100.00','1.530','1.530','1','1.530','1.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 ('H1H-YJCX-20-T','T0074724','MHH1 UB 42 ','KL LONG LING UB 42CM 8K ','','GR','---','MH','H1H','TOKO','01-SEM','2140000','2025-10-30','2140000','2.000','100.00','8','0','1070000.00','1','0.04', 'input','2025-10-30 12:05:47','2.000','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1H' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1H','H1H-YJCX-20-T','T0074724');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','H1H-YJCX-20-T','H1H','TOKO','01-SEM','100.00','2.000','2.000','1','2.000','2.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1H-YJCX-21-T','T0074725','MHH1 UB 42 ','KL LONG LING UB 42CM 8K ','','GR','---','MH','H1H','TOKO','01-SEM','2140000','2025-10-30','2140000','2.000','100.00','8','0','1070000.00','1','0.04', 'input','2025-10-30 12:05:55','2.000','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1H' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1H','H1H-YJCX-21-T','T0074725');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','H1H-YJCX-21-T','H1H','TOKO','01-SEM','100.00','2.000','2.000','1','2.000','2.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1H-YJCX-22-T','T0074726','MHH1 UB 42 ','KL LONG LING UB 42CM 8K ','','GR','---','MH','H1H','TOKO','01-SEM','2215000','2025-10-30','2215000','2.070','100.00','8','0','1070000.00','1','0.04', 'input','2025-10-30 12:06:06','2.070','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1H' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1H','H1H-YJCX-22-T','T0074726');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','H1H-YJCX-22-T','H1H','TOKO','01-SEM','100.00','2.070','2.070','1','2.070','2.070','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251030-0004','1','H1E-YJCX-14-T','1','2','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJCX-14-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-30','TOKO','SMBK-H','H1E','H1E-YJCX-14-T' , '1','2','2', '1','2','2','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2',berat_out_asli=berat_out_asli+'2',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJCX-14-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251030-0004','2','H1E-YJCX-15-T','1','2','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJCX-15-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-30','TOKO','SMBK-H','H1E','H1E-YJCX-15-T' , '1','2','2', '1','2','2','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2',berat_out_asli=berat_out_asli+'2',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJCX-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-251030-0004','3','H1E-YJCX-16-T','1','1.01','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJCX-16-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-30','TOKO','SMBK-H','H1E','H1E-YJCX-16-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='H1E-YJCX-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-251030-0004','4','H1E-YJCX-17-T','1','1.02','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJCX-17-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-30','TOKO','SMBK-H','H1E','H1E-YJCX-17-T' , '1','1.02','1.02', '1','1.02','1.02','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.02',berat_out_asli=berat_out_asli+'1.02',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJCX-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-251030-0004','5','H1E-YJCX-18-T','1','1.53','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJCX-18-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-30','TOKO','SMBK-H','H1E','H1E-YJCX-18-T' , '1','1.53','1.53', '1','1.53','1.53','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.53',berat_out_asli=berat_out_asli+'1.53',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJCX-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-251030-0004','6','H1E-YJCX-19-T','1','1.53','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJCX-19-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-30','TOKO','SMBK-H','H1E','H1E-YJCX-19-T' , '1','1.53','1.53', '1','1.53','1.53','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.53',berat_out_asli=berat_out_asli+'1.53',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJCX-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-251030-0004','7','H1H-YJCX-20-T','1','2','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1H-YJCX-20-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-30','TOKO','SMBK-H','H1H','H1H-YJCX-20-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='H1H-YJCX-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-251030-0004','8','H1H-YJCX-21-T','1','2','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1H-YJCX-21-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-30','TOKO','SMBK-H','H1H','H1H-YJCX-21-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='H1H-YJCX-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-251030-0004','9','H1H-YJCX-22-T','1','2.07','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1H-YJCX-22-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-10-30','TOKO','SMBK-H','H1H','H1H-YJCX-22-T' , '1','2.07','2.07', '1','2.07','2.07','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.07',berat_out_asli=berat_out_asli+'2.07',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1H-YJCX-22-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-251030-0004','2025-10-30','2025-10-30','12:07','15.16','input','2025-10-30 12:07:14');
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 ('F225301214501','kasir','1',' MEH1 UB ','TOKO','SMBK-H','H1E-YJBI-2-T','KL TRIXIE MODEL PITA KRAWANG VAR UB 8K ','OL','2.650','1','100.00','2663000','0','0','15000','2677000','0','13000','0','2690000','TIN','T0074562','H1E','0','0','-','0','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-YJBI-2-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.650',berat_jual_asli=berat_jual_asli+'2.650',stock_jual='1',berat_akhir=berat_akhir-'2.650',berat_akhir_asli=berat_akhir_asli-'2.650',stock_akhir='0' WHERE tanggal='2025-10-30' AND kode_barang='H1E-YJBI-2-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 ('F225301214501','2025-10-30','2.650','2025-10-30','12:14:51','PLG0074224','2677000','2677000','13000','2690000','2690000','kasir','2025-10-30 12:14:50','F22530121450');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-30','F225301214501','2025-10-30','12:14:51','TIN','2690000','13000');
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-251030-0004','D','2025-10-30','12:14:51','kasir','PENJUALAN','F225301214501','2081532000','2690000','2084222000');
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 ('S1G-YJCX-23-T','T0074727','MGS1 UB ','AS EXTENSION UB 8K ','','GR','---','MG','S1G','TOKO','01-SEM','470500','2025-10-30','470500','0.450','100.00','8','0','1045000.00','1','0.04', 'input','2025-10-30 12:39:16','0.450','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'S1G' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('S1G','S1G-YJCX-23-T','T0074727');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','S1G-YJCX-23-T','S1G','TOKO','01-SEM','100.00','0.450','0.450','1','0.450','0.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 ('S1G-YJCX-24-T','T0074728','MGS1 UB ','AS EXTENSION UB 8K ','','GR','---','MG','S1G','TOKO','01-SEM','481000','2025-10-30','481000','0.460','100.00','8','0','1045000.00','1','0.04', 'input','2025-10-30 12:39:24','0.460','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'S1G' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('S1G','S1G-YJCX-24-T','T0074728');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','S1G-YJCX-24-T','S1G','TOKO','01-SEM','100.00','0.460','0.460','1','0.460','0.460','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 ('F2E-YJCX-25-T','T0074729','MEF2 10K PM D56 ','GL PIPA MODEL MATA SLEP PM D56 8K ','','GR','---','ME','F2E','TOKO','01-SEM','3980000','2025-10-30','3980000','3.960','100.00','8','0','1005000.00','1','0.04', 'input','2025-10-30 12:41:06','3.960','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F2E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F2E','F2E-YJCX-25-T','T0074729');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','F2E-YJCX-25-T','F2E','TOKO','01-SEM','100.00','3.960','3.960','1','3.960','3.960','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F2E-YJCX-26-T','T0074730','MEF2 10K PM D56 ','GL PIPA MODEL MATA SLEP PM D56 8K ','','GR','---','ME','F2E','TOKO','01-SEM','4010000','2025-10-30','4010000','3.990','100.00','8','0','1005000.00','1','0.04', 'input','2025-10-30 12:41:31','3.990','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F2E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F2E','F2E-YJCX-26-T','T0074730');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','F2E-YJCX-26-T','F2E','TOKO','01-SEM','100.00','3.990','3.990','1','3.990','3.990','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-251030-0005','1','S1G-YJCX-23-T','1','0.450','0.450','TOKO','01-SEM','TOKO','SMBK-S');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-S' WHERE kode_barang='S1G-YJCX-23-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
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-10-30','TOKO','SMBK-S','S1G','S1G-YJCX-23-T','100.00','1','0.450','0.450','1','0.450','0.450');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.450',berat_out_asli=berat_out_asli+'0.450',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-30' AND kode_barang='S1G-YJCX-23-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
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-251030-0005','2','S1G-YJCX-24-T','1','0.460','0.460','TOKO','01-SEM','TOKO','SMBK-S');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-S' WHERE kode_barang='S1G-YJCX-24-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
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-10-30','TOKO','SMBK-S','S1G','S1G-YJCX-24-T','100.00','1','0.460','0.460','1','0.460','0.460');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.460',berat_out_asli=berat_out_asli+'0.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-30' AND kode_barang='S1G-YJCX-24-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' 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-251030-0005','2025-10-30','2025-10-30','12:41','0.91','input','2025-10-30 12:41:57');
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-251030-0006','1','F2E-YJCX-25-T','1','3.960','3.960','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-F' WHERE kode_barang='F2E-YJCX-25-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
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-10-30','TOKO','SMBK-F','F2E','F2E-YJCX-25-T','100.00','1','3.960','3.960','1','3.960','3.960');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.960',berat_out_asli=berat_out_asli+'3.960',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-30' AND kode_barang='F2E-YJCX-25-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0;
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-251030-0006','2','F2E-YJCX-26-T','1','3.990','3.990','TOKO','01-SEM','TOKO','SMBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SMBK-F' WHERE kode_barang='F2E-YJCX-26-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM';
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-10-30','TOKO','SMBK-F','F2E','F2E-YJCX-26-T','100.00','1','3.990','3.990','1','3.990','3.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.990',berat_out_asli=berat_out_asli+'3.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-30' AND kode_barang='F2E-YJCX-26-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' 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-251030-0006','2025-10-30','2025-10-30','12:41','7.95','input','2025-10-30 12:42:29');
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 ('F225300118501','kasir','1',' MEE2 CM 16','TOKO','SMBK-E','E2E-YJXF-12-T','CC MODEL HATI MATA CM 16 8K ','','0.600','1','100.00','603000','0','0','15000','600000','0','0','0','600000','RHM','T0073910','E2E','0','0','-','1','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXF-12-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.600',berat_jual_asli=berat_jual_asli+'0.600',stock_jual='1',berat_akhir=berat_akhir-'0.600',berat_akhir_asli=berat_akhir_asli-'0.600',stock_akhir='0' WHERE tanggal='2025-10-30' AND kode_barang='E2E-YJXF-12-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 ('F225300118501','2025-10-30','0.600','2025-10-30','13:18:51','PLG0074225','600000','600000','0','600000','600000','kasir','2025-10-30 13:18:50','F22530011850');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-30','F225300118501','2025-10-30','13:18:51','RHM','600000','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-251030-0005','D','2025-10-30','13:18:51','kasir','PENJUALAN','F225300118501','2084222000','600000','2084822000');
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 ('F225300119431','kasir','1',' MEE2 X CM ','TOKO','SMBK-E','E2E-YJXB-167-0','CC X MODEL AUREL MATA CM 18 8K ','','0.770','1','100.00','774000','0','0','15000','770000','0','0','0','770000','RHM','00371751','E2E','0','0','-','1','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXB-167-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2025-10-30' AND kode_barang='E2E-YJXB-167-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225300119431','2025-10-30','0.770','2025-10-30','13:19:44','PLG0074226','770000','770000','0','770000','770000','kasir','2025-10-30 13:19:43','F22530011943');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-30','F225300119431','2025-10-30','13:19:44','RHM','770000','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-251030-0006','D','2025-10-30','13:19:44','kasir','PENJUALAN','F225300119431','2084822000','770000','2085592000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='770000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225300119431' 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 ('F225300119432','kasir',' 1',' MEE2 CM 18','TOKO','SMBK-E','E2E-YJXF-19-T','CC MODEL HATI MATA CM 18 8K ','','0.630','1','100.00','633000','0','0','15000','630000','0','0','0','630000','RHM','T0073917','E2E','0','0','-','1','1005000');
UPDATE tm_barang SET tgl_last_jual='2025-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YJXF-19-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2025-10-30' AND kode_barang='E2E-YJXF-19-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 ('F225300119432','2025-10-30','0.630','2025-10-30','13:19:44','PLG0074227','630000','630000','0','630000','630000','kasir','2025-10-30 13:19:43','F22530011943');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-30','F225300119432','2025-10-30','13:19:44','RHM','630000','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-251030-0007','D','2025-10-30','13:19:44','kasir','PENJUALAN','F225300119432','2085592000','630000','2086222000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='630000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225300119432' LIMIT 1;
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1E-YJCX-27-T','T0074731','MEH1 UB ','KL TRIXIE MODEL PITA KRAWANG VAR UB 8K ','','GR','---','ME','H1E','TOKO','01-SEM','2673500','2025-10-30','2673500','2.660','100.00','8','0','1005000.00','1','0.04', 'input','2025-10-30 13:52:01','2.660','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1E' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1E','H1E-YJCX-27-T','T0074731');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-30','H1E-YJCX-27-T','H1E','TOKO','01-SEM','100.00','2.660','2.660','1','2.660','2.660','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-251030-0007','1','H1E-YJCX-27-T','1','2.66','0','TOKO','01-SEM','TOKO','SMBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'SMBK-H' WHERE kode_barang = 'H1E-YJCX-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-10-30','TOKO','SMBK-H','H1E','H1E-YJCX-27-T' , '1','2.66','2.66', '1','2.66','2.66','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.66',berat_out_asli=berat_out_asli+'2.66',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1E-YJCX-27-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-251030-0007','2025-10-30','2025-10-30','13:52','2.66','input','2025-10-30 13:52:21');
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 ('F225300242471','kasir','1',' TFH1 X HW ','TOKO','TBK-H','H1TF-YIXD-97-T','KL X SANTA HW 42CM 17K ','','4.010','1','100.00','7298000','0','0','15000','7218000','0','0','0','7218000','RTA','T0072949','H1TF','0','0','-','1','1820000');
UPDATE tm_barang SET tgl_last_jual='2025-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TF-YIXD-97-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.010',berat_jual_asli=berat_jual_asli+'4.010',stock_jual='1',berat_akhir=berat_akhir-'4.010',berat_akhir_asli=berat_akhir_asli-'4.010',stock_akhir='0' WHERE tanggal='2025-10-30' AND kode_barang='H1TF-YIXD-97-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225300242471','2025-10-30','4.010','2025-10-30','14:42:47','PLG0074228','7218000','7218000','0','7218000','7218000','kasir','2025-10-30 14:42:47','F22530024247');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-30','F225300242471','2025-10-30','14:42:47','RTA','7218000','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-251030-0008','D','2025-10-30','14:42:47','kasir','PENJUALAN','F225300242471','2086222000','7218000','2093440000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='7218000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225300242471' 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 ('F225300242472','kasir',' 1',' TED2 LG A ','TOKO','TBK-D','D2TE-XIBF-26-T','LT MODEL HURUF MATA LG A 17K','','0.780','1','100.00','1404000','0','0','15000','1388000','0','0','0','1388000','RTA','T0062309','D2TE','0','0','-','1','1800000');
UPDATE tm_barang SET tgl_last_jual='2025-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2TE-XIBF-26-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-10-30' AND kode_barang='D2TE-XIBF-26-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225300242472','2025-10-30','0.780','2025-10-30','14:42:47','PLG0074229','1388000','1388000','0','1388000','1388000','kasir','2025-10-30 14:42:47','F22530024247');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-30','F225300242472','2025-10-30','14:42:47','RTA','1388000','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-251030-0009','D','2025-10-30','14:42:47','kasir','PENJUALAN','F225300242472','2093440000','1388000','2094828000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1388000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225300242472' 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 ('F225300242473','kasir',' 1',' TFA1 X UB ','TOKO','TBK-A','A1TF-YIXD-41-T','AT X MODEL ITALY PANJANG VAR UB 17K ','','1.100','1','100.00','2002000','0','0','15000','1980000','0','0','0','1980000','RTA','T0072893','A1TF','0','0','-','1','1820000');
UPDATE tm_barang SET tgl_last_jual='2025-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TF-YIXD-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2025-10-30' AND kode_barang='A1TF-YIXD-41-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225300242473','2025-10-30','1.100','2025-10-30','14:42:47','PLG0074230','1980000','1980000','0','1980000','1980000','kasir','2025-10-30 14:42:47','F22530024247');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-30','F225300242473','2025-10-30','14:42:47','RTA','1980000','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-251030-0010','D','2025-10-30','14:42:47','kasir','PENJUALAN','F225300242473','2094828000','1980000','2096808000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1980000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225300242473' 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 ('F225300245451','kasir','1',' TFH1 X HW ','TOKO','TBK-H','H1TF-YIXD-96-T','KL X SANTA HW 42CM 17K ','','3.050','1','100.00','5551000','0','0','15000','5490000','0','0','0','5490000','RTA','T0072948','H1TF','0','0','-','1','1820000');
UPDATE tm_barang SET tgl_last_jual='2025-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1TF-YIXD-96-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.050',berat_jual_asli=berat_jual_asli+'3.050',stock_jual='1',berat_akhir=berat_akhir-'3.050',berat_akhir_asli=berat_akhir_asli-'3.050',stock_akhir='0' WHERE tanggal='2025-10-30' AND kode_barang='H1TF-YIXD-96-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225300245451','2025-10-30','3.050','2025-10-30','14:45:46','PLG0074231','5490000','5490000','0','5490000','5490000','kasir','2025-10-30 14:45:45','F22530024545');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-30','F225300245451','2025-10-30','14:45:46','RTA','5490000','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-251030-0011','D','2025-10-30','14:45:46','kasir','PENJUALAN','F225300245451','2096808000','5490000','2102298000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='5490000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225300245451' 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 ('F225300245452','kasir',' 1',' TED2 LG N ','TOKO','TBK-D','D2TE-YGBD-78-T','LT MODEL HURUF MATA LG N 17K ','','0.730','1','100.00','1314000','0','0','15000','1300000','0','0','0','1300000','RTA','T0071506','D2TE','0','0','-','1','1800000');
UPDATE tm_barang SET tgl_last_jual='2025-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2TE-YGBD-78-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2025-10-30' AND kode_barang='D2TE-YGBD-78-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225300245452','2025-10-30','0.730','2025-10-30','14:45:46','PLG0074232','1300000','1300000','0','1300000','1300000','kasir','2025-10-30 14:45:45','F22530024545');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-30','F225300245452','2025-10-30','14:45:46','RTA','1300000','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-251030-0012','D','2025-10-30','14:45:46','kasir','PENJUALAN','F225300245452','2102298000','1300000','2103598000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1300000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F225300245452' 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 ('F225300307331','kasir','1',' MHB1 LG ','TOKO','SMBK-B','B1H-YJBI-22-T','GW TUSUK MRICAN POLOS LG 8K ','OL','0.260','1','100.00','277000','0','0','15000','280000','0','5000','0','285000','RTA','T0074582','B1H','0','0','-','0','1070000');
UPDATE tm_barang SET tgl_last_jual='2025-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-YJBI-22-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.260',berat_jual_asli=berat_jual_asli+'0.260',stock_jual='1',berat_akhir=berat_akhir-'0.260',berat_akhir_asli=berat_akhir_asli-'0.260',stock_akhir='0' WHERE tanggal='2025-10-30' AND kode_barang='B1H-YJBI-22-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 ('F225300307331','2025-10-30','0.260','2025-10-30','15:07:34','PLG0074233','280000','280000','5000','285000','285000','kasir','2025-10-30 15:07:33','F22530030733');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-30','F225300307331','2025-10-30','15:07:34','RTA','285000','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-251030-0013','D','2025-10-30','15:07:34','kasir','PENJUALAN','F225300307331','2103598000','285000','2103883000');
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 ('F225300333451','admin','1',' MGD1 LG ','TOKO','SMBK-D','D1G-YJBI-142-T','LT SLOBOK PITA ARESO LG 8K ','','0.300','1','100.00','313000','0','0','15000','312000','0','0','0','312000','TIN','T0074702','D1G','0','0','-','1','1045000');
UPDATE tm_barang SET tgl_last_jual='2025-10-30', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YJBI-142-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.300',berat_jual_asli=berat_jual_asli+'0.300',stock_jual='1',berat_akhir=berat_akhir-'0.300',berat_akhir_asli=berat_akhir_asli-'0.300',stock_akhir='0' WHERE tanggal='2025-10-30' AND kode_barang='D1G-YJBI-142-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225300333451','2025-10-30','0.300','2025-10-30','15:33:46','PLG0074234','312000','312000','0','312000','312000','admin','2025-10-30 15:33:45','F22530033345');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-10-30','F225300333451','2025-10-30','15:33:46','TIN','312000','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-251030-0014','D','2025-10-30','15:33:46','admin','PENJUALAN','F225300333451','2103883000','312000','2104195000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225300118501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225300118501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225300118501';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225300119431' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225300119431' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225300119431';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225300119432' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225300119432' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225300119432';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225300242471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225300242471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225300242471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225300242472' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225300242472' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225300242472';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225300242473' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225300242473' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225300242473';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225300245451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225300245451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225300245451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225300245452' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225300245452' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225300245452';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225300307331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225300307331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225300307331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225300333451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225300333451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225300333451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225300838041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225300838041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225300838041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225301040041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225301040041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225301040041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225301040411' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225301040411' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225301040411';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225301041101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225301041101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225301041101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225301104321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225301104321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225301104321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225301105341' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225301105341' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225301105341';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225301214501' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225301214501' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225301214501';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-31','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-30';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-30';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-30';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-10-30' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-30';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-30';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-30';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-30';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-31' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-30' 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-251031-0001','D','2025-10-31','16:08:21','SYSTEM','SALDO AWAL','SALDO AWAL','0','2104195000','2104195000');
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-251031-0001','D','2025-10-31','16:08:21','BCA','SALDO AWAL','SALDO AWAL','0','4099816888','4099816888');
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-251031-0001','D','2025-10-31','16:08:21','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-251031-0001','D','2025-10-31','16:08:21','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-251031-0001','D','2025-10-31','16:08:21','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-251031-0001','D','2025-10-31','16:08:21','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
UPDATE tp_system SET tgl_system='2025-10-31';
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-20251031-0001','1','B1E-YJBA-102-0','1','0.480','0.480','TOKO','SBK-B','TOKO','SMBK-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-YJBA-102-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-YJBA-102-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-B',tgl_last_beli='2025-10-31 16:32:36' WHERE kode_barang='B1E-YJBA-102-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-YJBA-102-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-10-31 16:32:36','TOKO','SMBK-B','B1E','B1E-YJBA-102-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' 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='B1E-YJBA-102-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-YJBA-102-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251031-0001','2025-10-31','16:32','0.480','input','2025-10-30 16:32:36');
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-20251031-0001','1','D2D-XJAB-70-0','1','0.960','0.960','TOKO','SBK-D','TOKO','SMBK-D');
DELETE FROM tm_barang WHERE kode_barang='D2D-XJAB-70-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D2D-XJAB-70-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-D',tgl_last_beli='2025-10-31 16:32:56' WHERE kode_barang='D2D-XJAB-70-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D2D-XJAB-70-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-10-31 16:32:56','TOKO','SMBK-D','D2D','D2D-XJAB-70-0','1','0.960','0.960','1','0.960','0.960','100.00');
DELETE FROM tm_dept WHERE kode_dept='D2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D2D-XJAB-70-0';
DELETE FROM tm_barang_export WHERE kode_barang='D2D-XJAB-70-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251031-0001','2025-10-31','16:32','0.960','input','2025-10-30 16:32:56');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251031-0001','1','F3E-YJAF-12-T','1','3.160','TOKO','BK-F');
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YJAF-12-T' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='F3E-YJAF-12-T' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_group_export WHERE kode_group='ME' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='ME' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO db_nagagold_dewigold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM db_nagagold_dewigold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BK-F';
INSERT INTO db_nagagold_dewigold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BK-F';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='F3E-YJAF-12-T';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.160',berat_out_asli='3.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.160',berat_akhir_asli =berat_akhir_asli-'3.160' WHERE kode_barang='F3E-YJAF-12-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-251031-0001','2025-10-31','2025-10-31','16:37','3.160','input','251031');
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-20251031-0001','1','F3E-YJAC-141-0','1','3.010','3.010','TOKO','SSBK-F','TOKO','SMBK-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-YJAC-141-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-YJAC-141-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-F',tgl_last_beli='2025-10-31 16:37:37' WHERE kode_barang='F3E-YJAC-141-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-YJAC-141-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-10-31 16:37:37','TOKO','SMBK-F','F3E','F3E-YJAC-141-0','1','3.010','3.010','1','3.010','3.010','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-YJAC-141-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-YJAC-141-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251031-0001','2025-10-31','16:37','3.010','input','2025-10-30 16:37:36');