INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-08-27 ','08:10:05');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-08-27','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-07-27';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-08-26';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-08-26';
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-08-26' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-08-26';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-08-26';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-08-26';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-08-26';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202507 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-07';
UPDATE tt_barang_saldo SET tanggal= '2025-08-27' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-08-26' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-08-27';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-08-27 ','10:30:34');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-08-27 ','11:09:15');
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,berat_atribut,kode_baki) VALUES ('MTAT-YHBG-1-0','00025907',' ','AT COR TDK BT SHB ','','GR','---','MT','MTAT','TOKO','INPUT1','3035500','2025-08-27','3035500','2.240','100.00','16','0','1355000.00','1','0.045', 'adminpusat','2025-08-27 11:11:53','2.230','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MTAT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MTAT','MTAT-YHBG-1-0','00025907');
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-08-27','MTAT-YHBG-1-0','MTAT','TOKO','INPUT1','100.00','2.240','2.230','1','2.240','2.230','1');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-08-27 ','11:16:44');
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-250827-0001','1','MTAT-YHBG-1-0','1','2.240','2.240','TOKO','INPUT1','TOKO','BKATMT');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKATMT' WHERE kode_barang='MTAT-YHBG-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-08-27','TOKO','BKATMT','MTAT','MTAT-YHBG-1-0','100.00','1','2.240','2.230','1','2.240','2.230');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.240',berat_out_asli=berat_out_asli+'2.230',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-08-27' AND kode_barang='MTAT-YHBG-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-250827-0001','2025-08-27','2025-08-27','11:16','2.24','adminpusat','2025-08-27 11:17:13');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-250827-0001','1','MTAT-YHBG-1-0','1','2.240','TOKO','BKATMT');
DELETE FROM tm_barang_export WHERE kode_barang='MTAT-YHBG-1-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MTAT-YHBG-1-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MTAT' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MTAT' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKATMT';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKATMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MTAT-YHBG-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.240',berat_out_asli='2.230', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.240',berat_akhir_asli =berat_akhir_asli-'2.230' WHERE kode_barang='MTAT-YHBG-1-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES ('EX-250827-0001','2025-08-27','2025-08-27','11:19','2.240','adminpusat','250827');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-08-27 ','14:13:47');
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,berat_atribut,kode_baki) VALUES ('MSCN-YHBG-2-0','00025908','EX ','CN COR BT MK ','','GR','---','MS','MSCN','TOKO','INPUT1','829500','2025-08-27','829500','1.030','100.00','9','0','805000.00','1','0.045', 'adminpusat','2025-08-27 14:37:42','1.020','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSCN' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSCN','MSCN-YHBG-2-0','00025908');
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-08-27','MSCN-YHBG-2-0','MSCN','TOKO','INPUT1','100.00','1.030','1.020','1','1.030','1.020','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MSGL-YHBG-3-0','00025909','EX ','GL PLINTIR SHB ','','GR','---','MS','MSGL','TOKO','INPUT1','1707000','2025-08-27','1707000','2.120','100.00','9','0','805000.00','1','0.045', 'adminpusat','2025-08-27 14:39:06','2.110','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSGL','MSGL-YHBG-3-0','00025909');
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-08-27','MSGL-YHBG-3-0','MSGL','TOKO','INPUT1','100.00','2.120','2.110','1','2.120','2.110','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,berat_atribut,kode_baki) VALUES ('MSGL-YHBG-4-0','00025910','EX ','GL BABY PLINTIR 2BEL SHB ','','GR','---','MS','MSGL','TOKO','INPUT1','2423500','2025-08-27','2423500','3.010','100.00','9','0','805000.00','1','0.045', 'adminpusat','2025-08-27 14:39:55','3.000','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSGL','MSGL-YHBG-4-0','00025910');
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-08-27','MSGL-YHBG-4-0','MSGL','TOKO','INPUT1','100.00','3.010','3.000','1','3.010','3.000','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MSGL-YHBG-5-0','00025911','EX ','GL PLINTIR SHB ','','GR','---','MS','MSGL','TOKO','INPUT1','7929500','2025-08-27','7929500','9.850','100.00','9','0','805000.00','1','0.045', 'adminpusat','2025-08-27 14:41:10','9.840','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSGL','MSGL-YHBG-5-0','00025911');
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-08-27','MSGL-YHBG-5-0','MSGL','TOKO','INPUT1','100.00','9.850','9.840','1','9.850','9.840','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,berat_atribut,kode_baki) VALUES ('MSGL-YHBG-6-0','00025912','EX ','GL FANCY DB MN5 17CM KKT PER SHB ','','GR','---','MS','MSGL','TOKO','INPUT1','1586000','2025-08-27','1586000','1.970','100.00','9','0','805000.00','1','0.045', 'adminpusat','2025-08-27 14:42:20','1.960','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSGL','MSGL-YHBG-6-0','00025912');
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-08-27','MSGL-YHBG-6-0','MSGL','TOKO','INPUT1','100.00','1.970','1.960','1','1.970','1.960','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MSKL-YHBG-7-0','00025913','EX ','KL ITALY ST 42CM KKT PER BLT SHB ','','GR','---','MS','MSKL','TOKO','INPUT1','2415000','2025-08-27','2415000','3.000','100.00','9','0','805000.00','1','0.045', 'adminpusat','2025-08-27 14:43:26','2.990','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-YHBG-7-0','00025913');
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-08-27','MSKL-YHBG-7-0','MSKL','TOKO','INPUT1','100.00','3.000','2.990','1','3.000','2.990','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,berat_atribut,kode_baki) VALUES ('MSKL-YHBG-8-0','00025914','EX ','KL MILANO PJG 60CM KKT S SHB ','','GR','---','MS','MSKL','TOKO','INPUT1','5635000','2025-08-27','5635000','7.000','100.00','9','0','805000.00','1','0.045', 'adminpusat','2025-08-27 14:44:25','6.990','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MSKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MSKL','MSKL-YHBG-8-0','00025914');
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-08-27','MSKL-YHBG-8-0','MSKL','TOKO','INPUT1','100.00','7.000','6.990','1','7.000','6.990','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-250827-0002','1','MSCN-YHBG-2-0','1','1.030','1.030','TOKO','INPUT1','TOKO','BCNMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BCNMS' WHERE kode_barang='MSCN-YHBG-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-08-27','TOKO','BCNMS','MSCN','MSCN-YHBG-2-0','100.00','1','1.030','1.020','1','1.030','1.020');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.030',berat_out_asli=berat_out_asli+'1.020',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-08-27' AND kode_barang='MSCN-YHBG-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-250827-0002','2025-08-27','2025-08-27','16:27','1.03','adminpusat','2025-08-27 16:28:06');
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-250827-0003','1','MSGL-YHBG-3-0','1','2.120','2.120','TOKO','INPUT1','TOKO','BGLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMS' WHERE kode_barang='MSGL-YHBG-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-08-27','TOKO','BGLMS','MSGL','MSGL-YHBG-3-0','100.00','1','2.120','2.110','1','2.120','2.110');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.120',berat_out_asli=berat_out_asli+'2.110',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-08-27' AND kode_barang='MSGL-YHBG-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-250827-0003','2','MSGL-YHBG-4-0','1','3.010','3.010','TOKO','INPUT1','TOKO','BGLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMS' WHERE kode_barang='MSGL-YHBG-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-08-27','TOKO','BGLMS','MSGL','MSGL-YHBG-4-0','100.00','1','3.010','3.000','1','3.010','3.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.010',berat_out_asli=berat_out_asli+'3.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-08-27' AND kode_barang='MSGL-YHBG-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-250827-0003','3','MSGL-YHBG-5-0','1','9.850','9.850','TOKO','INPUT1','TOKO','BGLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMS' WHERE kode_barang='MSGL-YHBG-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-08-27','TOKO','BGLMS','MSGL','MSGL-YHBG-5-0','100.00','1','9.850','9.840','1','9.850','9.840');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'9.850',berat_out_asli=berat_out_asli+'9.840',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-08-27' AND kode_barang='MSGL-YHBG-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-250827-0003','4','MSGL-YHBG-6-0','1','1.970','1.970','TOKO','INPUT1','TOKO','BGLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMS' WHERE kode_barang='MSGL-YHBG-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-08-27','TOKO','BGLMS','MSGL','MSGL-YHBG-6-0','100.00','1','1.970','1.960','1','1.970','1.960');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.970',berat_out_asli=berat_out_asli+'1.960',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-08-27' AND kode_barang='MSGL-YHBG-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-250827-0003','2025-08-27','2025-08-27','16:28','16.95','adminpusat','2025-08-27 16:28:34');
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-250827-0004','1','MSKL-YHBG-7-0','1','3.000','3.000','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-YHBG-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-08-27','TOKO','BKLMS','MSKL','MSKL-YHBG-7-0','100.00','1','3.000','2.990','1','3.000','2.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.000',berat_out_asli=berat_out_asli+'2.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-08-27' AND kode_barang='MSKL-YHBG-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-250827-0004','2','MSKL-YHBG-8-0','1','7.000','7.000','TOKO','INPUT1','TOKO','BKLMS');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMS' WHERE kode_barang='MSKL-YHBG-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-08-27','TOKO','BKLMS','MSKL','MSKL-YHBG-8-0','100.00','1','7.000','6.990','1','7.000','6.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'7.000',berat_out_asli=berat_out_asli+'6.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-08-27' AND kode_barang='MSKL-YHBG-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='INPUT1' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-250827-0004','2025-08-27','2025-08-27','16:28','10','adminpusat','2025-08-27 16:29:01');