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 ('F225120857061','kasir','1',' MEF1 UB 54','TOKO','SMBK-F','F1E-YLAX-55-T','GL COR OVAL MODEL C DM 54 UB 8K ','OL','2.190','1','100.00','2271000','0','0','15000','2317000','0','11000','0','2328000','TIN','T0075639','F1E','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2025-12-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YLAX-55-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.190',berat_jual_asli=berat_jual_asli+'2.190',stock_jual='1',berat_akhir=berat_akhir-'2.190',berat_akhir_asli=berat_akhir_asli-'2.190',stock_akhir='0' WHERE tanggal='2025-12-12' AND kode_barang='F1E-YLAX-55-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225120857061','2025-12-12','2.190','2025-12-12','08:57:07','PLG0075587','2317000','2317000','11000','2328000','2328000','kasir','2025-12-12 08:57:06','F22512085706');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-12','F225120857061','2025-12-12','08:57:07','TIN','2328000','11000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251212-0002','D','2025-12-12','08:57:07','kasir','PENJUALAN','F225120857061','3669951000','2328000','3672279000');
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 ('F225120900221','kasir','1',' MDE2 X CM ','TOKO','SMBK-E','E2D-YLXH-159-0','CC X SOLITAIRE MATA CM 14 8K ','','1.330','1','100.00','1347000','0','0','15000','1374000','0','0','0','1374000','RHM','00380281','E2D','0','0','-','0','1017000');
UPDATE tm_barang SET tgl_last_jual='2025-12-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YLXH-159-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.330',berat_jual_asli=berat_jual_asli+'1.330',stock_jual='1',berat_akhir=berat_akhir-'1.330',berat_akhir_asli=berat_akhir_asli-'1.330',stock_akhir='0' WHERE tanggal='2025-12-12' AND kode_barang='E2D-YLXH-159-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 ('F225120900221','2025-12-12','1.330','2025-12-12','09:00:22','PLG0075588','1374000','1374000','0','1374000','1374000','kasir','2025-12-12 09:00:22','F22512090022');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-12','F225120900221','2025-12-12','09:00:22','RHM','1374000','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-251212-0003','D','2025-12-12','09:00:22','kasir','PENJUALAN','F225120900221','3672279000','1374000','3673653000');
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 ('S1TG-YLAB-1-T','T0075707','TGS1 UB ','AS EXTENSION UB 17K ','','GR','---','TG','S1TG','TOKO','01-SEM','768000','2025-12-12','768000','0.400','100.00','17','','1920000.00','1','0.04', 'input','2025-12-12 09:10:12','0.400','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'S1TG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('S1TG','S1TG-YLAB-1-T','T0075707');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','S1TG-YLAB-1-T','S1TG','TOKO','01-SEM','100.00','0.400','0.400','1','0.400','0.400','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('S1TG-YLAB-2-T','T0075708','TGS1 UB ','AS EXTENSION UB 17K ','','GR','---','TG','S1TG','TOKO','01-SEM','960000','2025-12-12','960000','0.500','100.00','17','','1920000.00','1','0.04', 'input','2025-12-12 09:10:27','0.500','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'S1TG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('S1TG','S1TG-YLAB-2-T','T0075708');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','S1TG-YLAB-2-T','S1TG','TOKO','01-SEM','100.00','0.500','0.500','1','0.500','0.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-251212-0001','1','S1TG-YLAB-1-T','1','0.4','0','TOKO','01-SEM','TOKO','TBK-S');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-S' WHERE kode_barang = 'S1TG-YLAB-1-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-S','S1TG','S1TG-YLAB-1-T' , '1','0.4','0.4', '1','0.4','0.4','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.4',berat_out_asli=berat_out_asli+'0.4',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='S1TG-YLAB-1-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0001','2','S1TG-YLAB-2-T','1','0.5','0','TOKO','01-SEM','TOKO','TBK-S');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-S' WHERE kode_barang = 'S1TG-YLAB-2-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-S','S1TG','S1TG-YLAB-2-T' , '1','0.5','0.5', '1','0.5','0.5','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.5',berat_out_asli=berat_out_asli+'0.5',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='S1TG-YLAB-2-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-251212-0001','2025-12-12','2025-12-12','09:10','0.9','input','2025-12-12 09:11:09');
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 ('F225120911301','kasir','1',' MEF2 PM 56','TOKO','SMBK-F','F2E-YLAX-50-T','GL COR MODEL PIPA MATA 56 PM 8K ','OL','3.100','1','100.00','3215000','0','0','15000','3279000','0','16000','0','3295000','TIN','T0075634','F2E','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2025-12-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-YLAX-50-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.100',berat_jual_asli=berat_jual_asli+'3.100',stock_jual='1',berat_akhir=berat_akhir-'3.100',berat_akhir_asli=berat_akhir_asli-'3.100',stock_akhir='0' WHERE tanggal='2025-12-12' AND kode_barang='F2E-YLAX-50-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225120911301','2025-12-12','3.100','2025-12-12','09:11:30','PLG0075589','3279000','3279000','16000','3295000','0','kasir','2025-12-12 09:11:30','F22512091130');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-12','F225120911301','2025-12-12','09:11:30','TIN','3295000','16000');
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-251212-0001','2025-12-12','2025-12-12 09:11:30','PENJUALAN : F225120911301','123456456785','BCA','3295000','3295000','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-251212-0002','D','2025-12-12','09:11:30','BCA','PENJUALAN','F225120911301','4182171888','3295000','4185466888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('123456456785','SITI MAHMUDAH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3295000' WHERE no_faktur_jual='F225120911301' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('S1TG-YLAB-1-T','T0075707','T0075707','AS EXTENSION UB 17K ','AS X EXTENSION UB 17K','','','768000','768000',' 0','0','input','2025-12-12 09:12:37');
UPDATE tm_barang SET nama_barang='AS X EXTENSION UB 17K' ,nama_atribut='' ,kode_intern='TGS1 X UB ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='S1TG-YLAB-1-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('S1TG-YLAB-2-T','T0075708','T0075708','AS EXTENSION UB 17K ','AS X EXTENSION UB 17K','','','960000','960000',' 0','0','input','2025-12-12 09:12:56');
UPDATE tm_barang SET nama_barang='AS X EXTENSION UB 17K' ,nama_atribut='' ,kode_intern='TGS1 X UB ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='S1TG-YLAB-2-T' LIMIT 1;
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F1TE-YLAB-3-T','T0075709','TEF1 X YT 54 ','GL X OVAL C GELOMBANG 54 YT 17K ','','GR','---','TE','F1TE','TOKO','01-SEM','7764500','2025-12-12','7764500','4.130','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 09:21:42','4.130','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F1TE','F1TE-YLAB-3-T','T0075709');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','F1TE-YLAB-3-T','F1TE','TOKO','01-SEM','100.00','4.130','4.130','1','4.130','4.130','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F1TE-YLAB-4-T','T0075710','TEF1 X HK 42 ','GL X BK KACA ANAK 42 HK 17K ','','GR','---','TE','F1TE','TOKO','01-SEM','5772000','2025-12-12','5772000','3.070','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 09:31:57','3.070','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F1TE','F1TE-YLAB-4-T','T0075710');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','F1TE-YLAB-4-T','F1TE','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 ('F2TE-YLAB-5-T','T0075711','TEF2 LT 56 ','GL COR OVAL MODEL MATA 56 LT 17K ','','GR','---','TE','F2TE','TOKO','01-SEM','5659000','2025-12-12','5659000','3.010','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 09:33:20','3.010','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F2TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F2TE','F2TE-YLAB-5-T','T0075711');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','F2TE-YLAB-5-T','F2TE','TOKO','01-SEM','100.00','3.010','3.010','1','3.010','3.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 ('F2TE-YLAB-6-T','T0075712','TEF2 X UB 56 ','GL X COR OVAL MODEL MATA 56 UB 17K ','','GR','---','TE','F2TE','TOKO','01-SEM','7445000','2025-12-12','7445000','3.960','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 09:35:14','3.960','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F2TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F2TE','F2TE-YLAB-6-T','T0075712');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','F2TE-YLAB-6-T','F2TE','TOKO','01-SEM','100.00','3.960','3.960','1','3.960','3.960','1');
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('F2TE-YLAB-5-T','T0075711','T0075711','GL COR OVAL MODEL MATA 56 LT 17K ','GL X COR OVAL MODEL MATA 56 LT 17K','','','5659000','5659000',' 0','0','input','2025-12-12 09:35:43');
UPDATE tm_barang SET nama_barang='GL X COR OVAL MODEL MATA 56 LT 17K' ,nama_atribut='' ,kode_intern='TEF2 X LT 56 ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='F2TE-YLAB-5-T' LIMIT 1;
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F2TE-YLAB-7-T','T0075713','TEF2 X UB 40 ','GL X COR ANAK MODEL MATA 40 UB 17K ','','GR','---','TE','F2TE','TOKO','01-SEM','3572000','2025-12-12','3572000','1.900','100.00','17','0','1880000.00','1','0.04', 'input','2025-12-12 09:37:56','1.900','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F2TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F2TE','F2TE-YLAB-7-T','T0075713');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','F2TE-YLAB-7-T','F2TE','TOKO','01-SEM','100.00','1.900','1.900','1','1.900','1.900','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 ('F225120938081','kasir','1',' MEB1 X LG ','TOKO','SMBK-B','B1E-YIAE-151-0','GW X DAISY MATA LG PE 8K ','OLSG0MF3','0.500','1','100.00','516000','0','0','15000','542000','0','80000','0','622000','TIN','00369602','B1E','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2025-12-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YIAE-151-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-12-12' AND kode_barang='B1E-YIAE-151-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225120938081','2025-12-12','0.500','2025-12-12','09:38:09','PLG0075590','542000','542000','80000','622000','622000','kasir','2025-12-12 09:38:08','F22512093808');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-12','F225120938081','2025-12-12','09:38:09','TIN','622000','80000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251212-0004','D','2025-12-12','09:38:09','kasir','PENJUALAN','F225120938081','3673653000','622000','3674275000');
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 ('F3TE-YLAB-8-T','T0075714','TEF3 X UB ','GL X LADY G SLEP UB 17K ','','GR','---','TE','F3TE','TOKO','01-SEM','10866500','2025-12-12','10866500','5.780','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 09:40:39','5.780','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3TE','F3TE-YLAB-8-T','T0075714');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','F3TE-YLAB-8-T','F3TE','TOKO','01-SEM','100.00','5.780','5.780','1','5.780','5.780','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 ('F3TE-YLAB-9-T','T0075715','TEF3 X HW ','GL X SANTA SERUT ARESO VAR HW 17K ','','GR','---','TE','F3TE','TOKO','01-SEM','5358000','2025-12-12','5358000','2.850','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 09:42:21','2.850','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3TE','F3TE-YLAB-9-T','T0075715');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','F3TE-YLAB-9-T','F3TE','TOKO','01-SEM','100.00','2.850','2.850','1','2.850','2.850','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3TE-YLAB-10-T','T0075716','TEF3 X UB ','GL X TIFF HATI SERUT VAR UB 17K ','','GR','---','TE','F3TE','TOKO','01-SEM','3873000','2025-12-12','3873000','2.060','100.00','17','0','1880000.00','1','0.04', 'input','2025-12-12 09:46:11','2.060','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3TE','F3TE-YLAB-10-T','T0075716');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','F3TE-YLAB-10-T','F3TE','TOKO','01-SEM','100.00','2.060','2.060','1','2.060','2.060','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('F3TE-YLAB-11-T','T0075717','TEF3 X HW ','GL X TIFF VAR HW 17K ','','GR','---','TE','F3TE','TOKO','01-SEM','6430000','2025-12-12','6430000','3.420','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 09:47:55','3.420','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3TE','F3TE-YLAB-11-T','T0075717');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','F3TE-YLAB-11-T','F3TE','TOKO','01-SEM','100.00','3.420','3.420','1','3.420','3.420','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 ('F3TE-YLAB-12-T','T0075718','TEF3 X LT ','GL X TIFF VAR LT 17K ','','GR','---','TE','F3TE','TOKO','01-SEM','7445000','2025-12-12','7445000','3.960','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 09:48:47','3.960','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'F3TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('F3TE','F3TE-YLAB-12-T','T0075718');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','F3TE-YLAB-12-T','F3TE','TOKO','01-SEM','100.00','3.960','3.960','1','3.960','3.960','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-251212-0002','1','F1TE-YLAB-3-T','1','4.13','0','TOKO','01-SEM','TOKO','TBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-F' WHERE kode_barang = 'F1TE-YLAB-3-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-F','F1TE','F1TE-YLAB-3-T' , '1','4.13','4.13', '1','4.13','4.13','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.13',berat_out_asli=berat_out_asli+'4.13',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F1TE-YLAB-3-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0002','2','F1TE-YLAB-4-T','1','3.07','0','TOKO','01-SEM','TOKO','TBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-F' WHERE kode_barang = 'F1TE-YLAB-4-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-F','F1TE','F1TE-YLAB-4-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='F1TE-YLAB-4-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0002','3','F2TE-YLAB-5-T','1','3.01','0','TOKO','01-SEM','TOKO','TBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-F' WHERE kode_barang = 'F2TE-YLAB-5-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-F','F2TE','F2TE-YLAB-5-T' , '1','3.01','3.01', '1','3.01','3.01','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.01',berat_out_asli=berat_out_asli+'3.01',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F2TE-YLAB-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-251212-0002','4','F2TE-YLAB-6-T','1','3.96','0','TOKO','01-SEM','TOKO','TBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-F' WHERE kode_barang = 'F2TE-YLAB-6-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-F','F2TE','F2TE-YLAB-6-T' , '1','3.96','3.96', '1','3.96','3.96','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.96',berat_out_asli=berat_out_asli+'3.96',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F2TE-YLAB-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-251212-0002','5','F2TE-YLAB-7-T','1','1.9','0','TOKO','01-SEM','TOKO','TBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-F' WHERE kode_barang = 'F2TE-YLAB-7-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-F','F2TE','F2TE-YLAB-7-T' , '1','1.9','1.9', '1','1.9','1.9','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.9',berat_out_asli=berat_out_asli+'1.9',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F2TE-YLAB-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-251212-0002','6','F3TE-YLAB-10-T','1','2.06','0','TOKO','01-SEM','TOKO','TBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-F' WHERE kode_barang = 'F3TE-YLAB-10-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-F','F3TE','F3TE-YLAB-10-T' , '1','2.06','2.06', '1','2.06','2.06','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.06',berat_out_asli=berat_out_asli+'2.06',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3TE-YLAB-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-251212-0002','7','F3TE-YLAB-11-T','1','3.42','0','TOKO','01-SEM','TOKO','TBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-F' WHERE kode_barang = 'F3TE-YLAB-11-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-F','F3TE','F3TE-YLAB-11-T' , '1','3.42','3.42', '1','3.42','3.42','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.42',berat_out_asli=berat_out_asli+'3.42',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3TE-YLAB-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-251212-0002','8','F3TE-YLAB-12-T','1','3.96','0','TOKO','01-SEM','TOKO','TBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-F' WHERE kode_barang = 'F3TE-YLAB-12-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-F','F3TE','F3TE-YLAB-12-T' , '1','3.96','3.96', '1','3.96','3.96','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.96',berat_out_asli=berat_out_asli+'3.96',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3TE-YLAB-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-251212-0002','9','F3TE-YLAB-8-T','1','5.78','0','TOKO','01-SEM','TOKO','TBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-F' WHERE kode_barang = 'F3TE-YLAB-8-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-F','F3TE','F3TE-YLAB-8-T' , '1','5.78','5.78', '1','5.78','5.78','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.78',berat_out_asli=berat_out_asli+'5.78',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3TE-YLAB-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-251212-0002','10','F3TE-YLAB-9-T','1','2.85','0','TOKO','01-SEM','TOKO','TBK-F');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-F' WHERE kode_barang = 'F3TE-YLAB-9-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-F','F3TE','F3TE-YLAB-9-T' , '1','2.85','2.85', '1','2.85','2.85','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.85',berat_out_asli=berat_out_asli+'2.85',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='F3TE-YLAB-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-251212-0002','2025-12-12','2025-12-12','09:49','34.14','input','2025-12-12 09:49:33');
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 ('H1TE-YLAB-13-T','T0075719','TEH1 HW 44 ','KL SANTA 44 HW 17K ','','GR','---','TE','H1TE','TOKO','01-SEM','9438000','2025-12-12','9438000','5.020','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 10:08:26','5.020','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1TE','H1TE-YLAB-13-T','T0075719');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','H1TE-YLAB-13-T','H1TE','TOKO','01-SEM','100.00','5.020','5.020','1','5.020','5.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 ('H1TE-YLAB-14-T','T0075720','TEH1 HW 44 ','KL SANTA 44 HW 17K ','','GR','---','TE','H1TE','TOKO','01-SEM','15040000','2025-12-12','15040000','8.000','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 10:09:19','8.000','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1TE','H1TE-YLAB-14-T','T0075720');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','H1TE-YLAB-14-T','H1TE','TOKO','01-SEM','100.00','8.000','8.000','1','8.000','8.000','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 ('F225121010061','kasir','1',' MFD1 BW ','TOKO','SMBK-D','D1F-YJXF-94-T','LT MODEL LETTERA PLAT BW 8K ','OL','0.410','1','100.00','432000','0','0','15000','446000','0','5000','0','451000','TIN','T0073992','D1F','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2025-12-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YJXF-94-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2025-12-12' AND kode_barang='D1F-YJXF-94-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 ('F225121010061','2025-12-12','0.410','2025-12-12','10:10:06','PLG0075591','446000','446000','5000','451000','451000','kasir','2025-12-12 10:10:06','F22512101006');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-12','F225121010061','2025-12-12','10:10:06','TIN','451000','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-251212-0005','D','2025-12-12','10:10:06','kasir','PENJUALAN','F225121010061','3674275000','451000','3674726000');
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 ('H1TE-YLAB-15-T','T0075721','TEH1 HW 42 ','KL SANTA 42 HW 17K ','','GR','---','TE','H1TE','TOKO','01-SEM','7595500','2025-12-12','7595500','4.040','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 10:10:40','4.040','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1TE','H1TE-YLAB-15-T','T0075721');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','H1TE-YLAB-15-T','H1TE','TOKO','01-SEM','100.00','4.040','4.040','1','4.040','4.040','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1TE-YLAB-16-T','T0075722','TEH1 HW 46 ','KL SANTA 46 HW 17K ','','GR','---','TE','H1TE','TOKO','01-SEM','19007000','2025-12-12','19007000','10.110','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 10:11:45','10.110','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1TE','H1TE-YLAB-16-T','T0075722');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','H1TE-YLAB-16-T','H1TE','TOKO','01-SEM','100.00','10.110','10.110','1','10.110','10.110','1');
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('H1TE-YLAB-13-T','T0075719','T0075719','KL SANTA 44 HW 17K ','KL X SANTA 44 HW 17K','','','9438000','9438000',' 0','0','input','2025-12-12 10:14:05');
UPDATE tm_barang SET nama_barang='KL X SANTA 44 HW 17K' ,nama_atribut='' ,kode_intern='TEH1 X HW 44 ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='H1TE-YLAB-13-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('H1TE-YLAB-14-T','T0075720','T0075720','KL SANTA 44 HW 17K ','KL X SANTA 44 HW 17K','','','15040000','15040000',' 0','0','input','2025-12-12 10:14:21');
UPDATE tm_barang SET nama_barang='KL X SANTA 44 HW 17K' ,nama_atribut='' ,kode_intern='TEH1 X HW 44 ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='H1TE-YLAB-14-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('H1TE-YLAB-15-T','T0075721','T0075721','KL SANTA 42 HW 17K ','KL X SANTA 42 HW 17K','','','7595500','7595500',' 0','0','input','2025-12-12 10:14:37');
UPDATE tm_barang SET nama_barang='KL X SANTA 42 HW 17K' ,nama_atribut='' ,kode_intern='TEH1 X HW 42 ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='H1TE-YLAB-15-T' LIMIT 1;
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('H1TE-YLAB-16-T','T0075722','T0075722','KL SANTA 46 HW 17K ','KL X SANTA 46 HW 17K','','','19007000','19007000',' 0','0','input','2025-12-12 10:14:49');
UPDATE tm_barang SET nama_barang='KL X SANTA 46 HW 17K' ,nama_atribut='' ,kode_intern='TEH1 X HW 46 ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='H1TE-YLAB-16-T' LIMIT 1;
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1TE-YLAB-17-T','T0075723','TEH1 X UB 42 ','KL X MILANO 42 UB 17K ','','GR','---','TE','H1TE','TOKO','01-SEM','7558000','2025-12-12','7558000','4.020','100.00','17','0','1880000.00','1','0.04', 'input','2025-12-12 10:17:15','4.020','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1TE','H1TE-YLAB-17-T','T0075723');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','H1TE-YLAB-17-T','H1TE','TOKO','01-SEM','100.00','4.020','4.020','1','4.020','4.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 ('H1TE-YLAB-18-T','T0075724','TEH1 X UB 42 ','KL X MILANO 42 UB 17K ','','GR','---','TE','H1TE','TOKO','01-SEM','5772000','2025-12-12','5772000','3.070','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 10:18:10','3.070','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1TE','H1TE-YLAB-18-T','T0075724');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','H1TE-YLAB-18-T','H1TE','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 ('H1TE-YLAB-19-T','T0075725','TEH1 X UB 42 ','KL X MILANO 42 UB 17K ','','GR','---','TE','H1TE','TOKO','01-SEM','15096500','2025-12-12','15096500','8.030','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 10:19:20','8.030','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1TE','H1TE-YLAB-19-T','T0075725');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','H1TE-YLAB-19-T','H1TE','TOKO','01-SEM','100.00','8.030','8.030','1','8.030','8.030','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1TE-YLAB-20-T','T0075726','TEH1 X HW 42 ','KL X GUCI 42 HW 17K ','','GR','---','TE','H1TE','TOKO','01-SEM','3948000','2025-12-12','3948000','2.100','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 10:20:50','2.100','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1TE','H1TE-YLAB-20-T','T0075726');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','H1TE-YLAB-20-T','H1TE','TOKO','01-SEM','100.00','2.100','2.100','1','2.100','2.100','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1TE-YLAB-21-T','T0075727','TEH1 X HW 42 ','KL X GUCI 42 HW 17K ','','GR','---','TE','H1TE','TOKO','01-SEM','3610000','2025-12-12','3610000','1.920','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 10:21:48','1.920','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1TE','H1TE-YLAB-21-T','T0075727');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','H1TE-YLAB-21-T','H1TE','TOKO','01-SEM','100.00','1.920','1.920','1','1.920','1.920','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 ('H1TE-YLAB-22-T','T0075728','TEH1 X HW 44 ','KL X GUCI 44 HW 17K ','','GR','---','TE','H1TE','TOKO','01-SEM','3816500','2025-12-12','3816500','2.030','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 10:22:44','2.030','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1TE','H1TE-YLAB-22-T','T0075728');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','H1TE-YLAB-22-T','H1TE','TOKO','01-SEM','100.00','2.030','2.030','1','2.030','2.030','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1TE-YLAB-23-T','T0075729','TEH1 X HW 42 ','KL X SIEM SINGEL 42 HW 17K ','','GR','---','TE','H1TE','TOKO','01-SEM','2688500','2025-12-12','2688500','1.430','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 10:24:49','1.430','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1TE','H1TE-YLAB-23-T','T0075729');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','H1TE-YLAB-23-T','H1TE','TOKO','01-SEM','100.00','1.430','1.430','1','1.430','1.430','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H1TE-YLAB-24-T','T0075730','TEH1 X UB 42 ','KL X NORI 42 UB 17K ','','GR','---','TE','H1TE','TOKO','01-SEM','9513000','2025-12-12','9513000','5.060','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 10:32:43','5.060','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H1TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H1TE','H1TE-YLAB-24-T','T0075730');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','H1TE-YLAB-24-T','H1TE','TOKO','01-SEM','100.00','5.060','5.060','1','5.060','5.060','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H2TG-YLAB-25-T','T0075731','TGH2 X AU 48 ','KL X TRIXIE VAR 48 AU 18K ','','GR','---','TG','H2TG','TOKO','01-SEM','3686500','2025-12-12','3686500','1.920','100.00','17','','1920000.00','1','0.04', 'input','2025-12-12 10:37:03','1.920','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H2TG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H2TG','H2TG-YLAB-25-T','T0075731');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','H2TG-YLAB-25-T','H2TG','TOKO','01-SEM','100.00','1.920','1.920','1','1.920','1.920','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 ('H2TE-YLAB-26-T','T0075732','TEH2 HW 42 ','KL X SANTA ALPHA VAR 42 HW 17K ','','GR','---','TE','H2TE','TOKO','01-SEM','7388500','2025-12-12','7388500','3.930','100.00','17','0','1880000.00','1','0.04', 'input','2025-12-12 10:38:59','3.930','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H2TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H2TE','H2TE-YLAB-26-T','T0075732');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','H2TE-YLAB-26-T','H2TE','TOKO','01-SEM','100.00','3.930','3.930','1','3.930','3.930','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 ('H2TE-YLAB-27-T','T0075733','TEH2 X UB 40 ','KL X CD HURUF E 40 UB 17K ','','GR','---','TE','H2TE','TOKO','01-SEM','5320500','2025-12-12','5320500','2.830','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 10:41:00','2.830','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H2TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H2TE','H2TE-YLAB-27-T','T0075733');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','H2TE-YLAB-27-T','H2TE','TOKO','01-SEM','100.00','2.830','2.830','1','2.830','2.830','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 ('F225121041171','kasir','1',' MEA1 LG ','TOKO','SMBK-A','A1E-YJBI-110-T','AT MODEL PITA MATA LG 8K ','','0.540','1','100.00','558000','0','0','15000','569000','0','0','0','569000','RHM','T0074670','A1E','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2025-12-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-YJBI-110-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.540',berat_jual_asli=berat_jual_asli+'0.540',stock_jual='1',berat_akhir=berat_akhir-'0.540',berat_akhir_asli=berat_akhir_asli-'0.540',stock_akhir='0' WHERE tanggal='2025-12-12' AND kode_barang='A1E-YJBI-110-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225121041171','2025-12-12','0.540','2025-12-12','10:41:17','PLG0075592','569000','569000','0','569000','569000','kasir','2025-12-12 10:41:17','F22512104117');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-12','F225121041171','2025-12-12','10:41:17','RHM','569000','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-251212-0006','D','2025-12-12','10:41:17','kasir','PENJUALAN','F225121041171','3674726000','569000','3675295000');
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('H2TE-YLAB-26-T','T0075732','T0075732','KL X SANTA ALPHA VAR 42 HW 17K ','KL X SANTA ALPHA VAR 42 HW 17K','','','7388500','7388500',' 0','0','input','2025-12-12 10:41:26');
UPDATE tm_barang SET nama_barang='KL X SANTA ALPHA VAR 42 HW 17K' ,nama_atribut='' ,kode_intern='TEH2 X HW 42 ', kadar_cetak='17.00', potongan='0',tagid='FREETAG',harga_modal='0' WHERE kode_barang='H2TE-YLAB-26-T' LIMIT 1;
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal) VALUES ('H2TE-YLAB-28-T','T0075734','TEH2 X UB 40 ','KL X SANTA VAR MATA 40 UB 17K ','','GR','---','TE','H2TE','TOKO','01-SEM','10246000','2025-12-12','10246000','5.450','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 10:46:57','5.450','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H2TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H2TE','H2TE-YLAB-28-T','T0075734');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','H2TE-YLAB-28-T','H2TE','TOKO','01-SEM','100.00','5.450','5.450','1','5.450','5.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 ('H2TE-YLAB-29-T','T0075735','TEH2 X UB 40 ','KL X SANTA VAR MATA 40 UB 17K ','','GR','---','TE','H2TE','TOKO','01-SEM','8028000','2025-12-12','8028000','4.270','100.00','17','','1880000.00','1','0.04', 'input','2025-12-12 10:48:04','4.270','0','','15000','','TOKO','FREETAG','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'H2TE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('H2TE','H2TE-YLAB-29-T','T0075735');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-12-12','H2TE-YLAB-29-T','H2TE','TOKO','01-SEM','100.00','4.270','4.270','1','4.270','4.270','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-251212-0003','1','H1TE-YLAB-13-T','1','5.02','0','TOKO','01-SEM','TOKO','TBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-H' WHERE kode_barang = 'H1TE-YLAB-13-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-H','H1TE','H1TE-YLAB-13-T' , '1','5.02','5.02', '1','5.02','5.02','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.02',berat_out_asli=berat_out_asli+'5.02',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1TE-YLAB-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-251212-0003','2','H1TE-YLAB-14-T','1','8','0','TOKO','01-SEM','TOKO','TBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-H' WHERE kode_barang = 'H1TE-YLAB-14-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-H','H1TE','H1TE-YLAB-14-T' , '1','8','8', '1','8','8','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'8',berat_out_asli=berat_out_asli+'8',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1TE-YLAB-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-251212-0003','3','H1TE-YLAB-15-T','1','4.04','0','TOKO','01-SEM','TOKO','TBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-H' WHERE kode_barang = 'H1TE-YLAB-15-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-H','H1TE','H1TE-YLAB-15-T' , '1','4.04','4.04', '1','4.04','4.04','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.04',berat_out_asli=berat_out_asli+'4.04',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1TE-YLAB-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-251212-0003','4','H1TE-YLAB-16-T','1','10.11','0','TOKO','01-SEM','TOKO','TBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-H' WHERE kode_barang = 'H1TE-YLAB-16-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-H','H1TE','H1TE-YLAB-16-T' , '1','10.11','10.11', '1','10.11','10.11','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'10.11',berat_out_asli=berat_out_asli+'10.11',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1TE-YLAB-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-251212-0003','5','H1TE-YLAB-17-T','1','4.02','0','TOKO','01-SEM','TOKO','TBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-H' WHERE kode_barang = 'H1TE-YLAB-17-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-H','H1TE','H1TE-YLAB-17-T' , '1','4.02','4.02', '1','4.02','4.02','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.02',berat_out_asli=berat_out_asli+'4.02',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1TE-YLAB-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-251212-0003','6','H1TE-YLAB-18-T','1','3.07','0','TOKO','01-SEM','TOKO','TBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-H' WHERE kode_barang = 'H1TE-YLAB-18-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-H','H1TE','H1TE-YLAB-18-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='H1TE-YLAB-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-251212-0003','7','H1TE-YLAB-19-T','1','8.03','0','TOKO','01-SEM','TOKO','TBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-H' WHERE kode_barang = 'H1TE-YLAB-19-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-H','H1TE','H1TE-YLAB-19-T' , '1','8.03','8.03', '1','8.03','8.03','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'8.03',berat_out_asli=berat_out_asli+'8.03',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1TE-YLAB-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-251212-0003','8','H1TE-YLAB-20-T','1','2.1','0','TOKO','01-SEM','TOKO','TBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-H' WHERE kode_barang = 'H1TE-YLAB-20-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-H','H1TE','H1TE-YLAB-20-T' , '1','2.1','2.1', '1','2.1','2.1','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.1',berat_out_asli=berat_out_asli+'2.1',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1TE-YLAB-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-251212-0003','9','H1TE-YLAB-21-T','1','1.92','0','TOKO','01-SEM','TOKO','TBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-H' WHERE kode_barang = 'H1TE-YLAB-21-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-H','H1TE','H1TE-YLAB-21-T' , '1','1.92','1.92', '1','1.92','1.92','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.92',berat_out_asli=berat_out_asli+'1.92',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1TE-YLAB-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-251212-0003','10','H1TE-YLAB-22-T','1','2.03','0','TOKO','01-SEM','TOKO','TBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-H' WHERE kode_barang = 'H1TE-YLAB-22-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-H','H1TE','H1TE-YLAB-22-T' , '1','2.03','2.03', '1','2.03','2.03','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.03',berat_out_asli=berat_out_asli+'2.03',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1TE-YLAB-22-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0003','11','H1TE-YLAB-23-T','1','1.43','0','TOKO','01-SEM','TOKO','TBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-H' WHERE kode_barang = 'H1TE-YLAB-23-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-H','H1TE','H1TE-YLAB-23-T' , '1','1.43','1.43', '1','1.43','1.43','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.43',berat_out_asli=berat_out_asli+'1.43',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1TE-YLAB-23-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0003','12','H1TE-YLAB-24-T','1','5.06','0','TOKO','01-SEM','TOKO','TBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-H' WHERE kode_barang = 'H1TE-YLAB-24-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-H','H1TE','H1TE-YLAB-24-T' , '1','5.06','5.06', '1','5.06','5.06','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.06',berat_out_asli=berat_out_asli+'5.06',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H1TE-YLAB-24-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0003','13','H2TE-YLAB-26-T','1','3.93','0','TOKO','01-SEM','TOKO','TBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-H' WHERE kode_barang = 'H2TE-YLAB-26-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-H','H2TE','H2TE-YLAB-26-T' , '1','3.93','3.93', '1','3.93','3.93','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.93',berat_out_asli=berat_out_asli+'3.93',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H2TE-YLAB-26-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0003','14','H2TE-YLAB-27-T','1','2.83','0','TOKO','01-SEM','TOKO','TBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-H' WHERE kode_barang = 'H2TE-YLAB-27-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-H','H2TE','H2TE-YLAB-27-T' , '1','2.83','2.83', '1','2.83','2.83','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.83',berat_out_asli=berat_out_asli+'2.83',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H2TE-YLAB-27-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0003','15','H2TE-YLAB-28-T','1','5.45','0','TOKO','01-SEM','TOKO','TBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-H' WHERE kode_barang = 'H2TE-YLAB-28-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-H','H2TE','H2TE-YLAB-28-T' , '1','5.45','5.45', '1','5.45','5.45','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.45',berat_out_asli=berat_out_asli+'5.45',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H2TE-YLAB-28-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0003','16','H2TE-YLAB-29-T','1','4.27','0','TOKO','01-SEM','TOKO','TBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-H' WHERE kode_barang = 'H2TE-YLAB-29-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-H','H2TE','H2TE-YLAB-29-T' , '1','4.27','4.27', '1','4.27','4.27','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.27',berat_out_asli=berat_out_asli+'4.27',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H2TE-YLAB-29-T' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='01-SEM' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251212-0003','17','H2TG-YLAB-25-T','1','1.92','0','TOKO','01-SEM','TOKO','TBK-H');
UPDATE tm_barang SET berat_bandrol='0.04', kode_lokasi_gudang ='TOKO', kode_lokasi_toko = 'TBK-H' WHERE kode_barang = 'H2TG-YLAB-25-T' AND kode_lokasi_toko = '01-SEM';
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar ) VALUES ('2025-12-12','TOKO','TBK-H','H2TG','H2TG-YLAB-25-T' , '1','1.92','1.92', '1','1.92','1.92','100.00');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.92',berat_out_asli=berat_out_asli+'1.92',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE kode_barang='H2TG-YLAB-25-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-251212-0003','2025-12-12','2025-12-12','10:48','73.23','input','2025-12-12 10:48:50');
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 ('F225121050231','kasir','1',' MFD1 BW ','TOKO','SMBK-D','D1F-YJXF-94-T','LT MODEL LETTERA PLAT BW 8K ','OL','0.410','1','100.00','432000','0','0','15000','446000','0','5000','0','451000','TIN','T0073992','D1F','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2025-12-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YJXF-94-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2025-12-12' AND kode_barang='D1F-YJXF-94-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 ('F225121050231','2025-12-12','0.410','2025-12-12','10:50:23','PLG0075593','446000','446000','5000','451000','451000','kasir','2025-12-12 10:50:23','F22512105023');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-12','F225121050231','2025-12-12','10:50:23','TIN','451000','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-251212-0008','D','2025-12-12','10:50:23','kasir','PENJUALAN','F225121050231','3674844000','451000','3675295000');
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 ('F225121112271','kasir','1',' MEF3 UB ','TOKO','SMBK-F','F3E-YLXE-32-T','GL LEMES MODEL LONGLING UB 8K ','OL','0.970','1','100.00','1002000','0','0','15000','1031000','0','5000','0','1036000','RHM','T0075559','F3E','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2025-12-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLXE-32-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.970',berat_jual_asli=berat_jual_asli+'0.970',stock_jual='1',berat_akhir=berat_akhir-'0.970',berat_akhir_asli=berat_akhir_asli-'0.970',stock_akhir='0' WHERE tanggal='2025-12-12' AND kode_barang='F3E-YLXE-32-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='SMBK-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F225121112271','2025-12-12','0.970','2025-12-12','11:12:28','PLG0075594','1031000','1031000','5000','1036000','1036000','kasir','2025-12-12 11:12:27','F22512111227');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-12','F225121112271','2025-12-12','11:12:28','RHM','1036000','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-251212-0009','D','2025-12-12','11:12:28','kasir','PENJUALAN','F225121112271','3675295000','1036000','3676331000');
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 ('F225121135371','kasir','1',' MEE2 CM 8 ','TOKO','SMBK-E','E2E-YLXC-23-T','CC COR MODEL MATA CM 8K ','','0.500','1','100.00','516000','0','0','15000','527000','0','0','0','527000','RTA','T0075432','E2E','0','0','-','0','1030000');
UPDATE tm_barang SET tgl_last_jual='2025-12-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-YLXC-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2025-12-12' AND kode_barang='E2E-YLXC-23-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 ('F225121135371','2025-12-12','0.500','2025-12-12','11:35:37','PLG0075595','527000','527000','0','527000','527000','kasir','2025-12-12 11:35:37','F22512113537');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-12','F225121135371','2025-12-12','11:35:37','RTA','527000','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-251212-0010','D','2025-12-12','11:35:37','kasir','PENJUALAN','F225121135371','3676331000','527000','3676858000');
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 ('F225121216541','kasir','1',' MDE2 X UB ','TOKO','SMBK-E','E2D-YLXH-173-0','CC X MODEL MATA UB 14 8K ','OL','1.340','1','100.00','1357000','0','0','15000','1397000','0','7000','0','1404000','TIN','00380295','E2D','0','0','-','0','1017000');
UPDATE tm_barang SET tgl_last_jual='2025-12-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YLXH-173-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.340',berat_jual_asli=berat_jual_asli+'1.340',stock_jual='1',berat_akhir=berat_akhir-'1.340',berat_akhir_asli=berat_akhir_asli-'1.340',stock_akhir='0' WHERE tanggal='2025-12-12' AND kode_barang='E2D-YLXH-173-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 ('F225121216541','2025-12-12','1.340','2025-12-12','12:16:54','PLG0075596','1397000','1397000','7000','1404000','1404000','kasir','2025-12-12 12:16:54','F22512121654');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-12','F225121216541','2025-12-12','12:16:54','TIN','1404000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251212-0011','D','2025-12-12','12:16:54','kasir','PENJUALAN','F225121216541','3676858000','1404000','3678262000');
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 ('F225121259161','kasir','1',' TDA1 X LG ','TOKO','TBK-A','A1TD-YDBC-41-T','AT X JERSY SLEP LG 17K ','OL','1.020','1','100.00','1897000','0','0','15000','1931000','0','7000','0','1938000','TIN','T0068855','A1TD','0','0','-','0','1860000');
UPDATE tm_barang SET tgl_last_jual='2025-12-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1TD-YDBC-41-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2025-12-12' AND kode_barang='A1TD-YDBC-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 ('F225121259161','2025-12-12','1.020','2025-12-12','12:59:17','PLG0075597','1931000','1931000','7000','1938000','0','kasir','2025-12-12 12:59:16','F22512125916');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-12','F225121259161','2025-12-12','12:59:17','TIN','1938000','7000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251212-0002','2025-12-12','2025-12-12 12:59:16','PENJUALAN : F225121259161','345674567856','BCA','1938000','1938000','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-251212-0003','D','2025-12-12','12:59:17','BCA','PENJUALAN','F225121259161','4185466888','1938000','4187404888','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('345674567856','WINIH');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1938000' WHERE no_faktur_jual='F225121259161' 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 ('F225120143381','kasir','1',' TFD2 X YT ','TOKO','TBK-D','D2TF-YLAA-23-T','LT X COR MODEL SPECTRA YT 17K ','OL','0.380','1','100.00','722000','0','0','15000','744000','0','7000','0','751000','RHM','T0075681','D2TF','0','0','-','0','1900000');
UPDATE tm_barang SET tgl_last_jual='2025-12-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2TF-YLAA-23-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2025-12-12' AND kode_barang='D2TF-YLAA-23-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 ('F225120143381','2025-12-12','0.380','2025-12-12','13:43:39','PLG0075598','744000','744000','7000','751000','751000','kasir','2025-12-12 13:43:38','F22512014338');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-12','F225120143381','2025-12-12','13:43:39','RHM','751000','7000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251212-0012','D','2025-12-12','13:43:39','kasir','PENJUALAN','F225120143381','3678262000','751000','3679013000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120143381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120143381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120143381';
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 ('F225120240281','kasir','1',' MHB1 CM ','TOKO','SMBK-B','B1H-YKAG-2-T','GW TUSUK DAISY MATA CM 8K ','','0.260','1','100.00','284000','0','0','15000','289000','0','0','0','289000','RTA','T0075005','B1H','0','0','-','0','1093000');
UPDATE tm_barang SET tgl_last_jual='2025-12-12', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1H-YKAG-2-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-12-12' AND kode_barang='B1H-YKAG-2-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 ('F225120240281','2025-12-12','0.260','2025-12-12','14:40:28','PLG0075599','289000','289000','0','289000','289000','kasir','2025-12-12 14:40:28','F22512024028');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-12-12','F225120240281','2025-12-12','14:40:28','RTA','289000','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-251212-0013','D','2025-12-12','14:40:28','kasir','PENJUALAN','F225120240281','3679013000','289000','3679302000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00004908','X-00004908','CC MODEL MATA VAR CM 12 8K','GR','---','E2D','BELI','BELI001','814000','2025-12-12','0.900','1','kasir','2025-12-12 15:34:39');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00004908','X-00004908');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-251212-0001','F225270317241','TIN','1','BELI','BELI001','E2D', 'X-00004908', 'CC MODEL MATA VAR CM 12 8K','0.900','0.900','100.00','905000','814000','904444','1017000','1','814000','814000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-12-12' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-251212-0001','2025-12-12','2025-12-12','15:34:39','TIN','---','0.900','814000','814000','814000','814000','814000','kasir','2025-12-12 15:34:39','FB-251212-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-251212-0001','IMELIA','MAGUAN. SAMBIT','','','087878299082','kasir','2025-12-12 15:34:39');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-12-12' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-251212-0014','K','2025-12-12','15:34:39','kasir','PEMBELIAN UMUM','FB-251212-0001','3679302000','814000','3678488000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120240281' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120240281' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120240281';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120857061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120857061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120857061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120900221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120900221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120900221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120911301' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120911301' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120911301';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225120938081' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225120938081' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225120938081';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121041171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121041171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121041171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121050231' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121050231' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121050231';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121112271' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121112271' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121112271';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121135371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121135371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121135371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121216541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121216541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121216541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F225121259161' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F225121259161' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F225121259161';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-251212-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-251212-0001';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-13','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-12';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-12';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-12';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-12-12' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-12';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-12';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-12';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-12';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202511 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-11';
UPDATE tt_barang_saldo SET tanggal= '2025-12-13' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-12' 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-251213-0001','D','2025-12-13','16:12:25','SYSTEM','SALDO AWAL','SALDO AWAL','0','3678488000','3678488000');
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-251213-0001','D','2025-12-13','16:12:25','BCA','SALDO AWAL','SALDO AWAL','0','4187404888','4187404888');
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-251213-0001','D','2025-12-13','16:12:25','','SALDO AWAL','SALDO AWAL','0','1047000','1047000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-251213-0001','D','2025-12-13','16:12:25','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-251213-0001','D','2025-12-13','16:12:25','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-251213-0001','D','2025-12-13','16:12:25','BNI','SALDO AWAL','SALDO AWAL','0','4233000','4233000');
UPDATE tp_system SET tgl_system='2025-12-13';
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-20251213-0001','1','H1E-YLAA-55-0','1','2.230','2.230','TOKO','SBK-H','TOKO','SMBK-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-YLAA-55-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-YLAA-55-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='SMBK-H',tgl_last_beli='2025-12-13 16:20:57' WHERE kode_barang='H1E-YLAA-55-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-YLAA-55-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-12-13 16:20:57','TOKO','SMBK-H','H1E','H1E-YLAA-55-0','1','2.230','2.230','1','2.230','2.230','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' 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='H1E-YLAA-55-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-YLAA-55-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251213-0001','2025-12-13','16:20','2.230','input','2025-12-12 16:20:56');