INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-11-19 ','08:06:08');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-19','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-19';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-18';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-18';
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-11-18' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-18';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-18';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-18';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-18';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-19' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-18' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-11-19';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2025-11-19 ','10:38:55');
UPDATE tm_group SET harga='1005000' WHERE kode_group = 'MD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MD','1005000','admin','2025-11-19 10:39:28');
UPDATE tm_group SET harga='1005000' WHERE kode_group = 'MS' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MS','1005000','admin','2025-11-19 10:39:34');
UPDATE tm_group SET harga='1720000' WHERE kode_group = 'MT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('MT','1720000','admin','2025-11-19 10:39:43');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-11-19 ','13:03:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2025-11-19 ','13:07:09');
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 ('MDGL-YKAI-1-0','00026871',' ','GL FANCY SRT 19CM KKT PER UBS ','','GR','---','MD','MDGL','TOKO','INPUT1','1920000','2025-11-19','1920000','1.910','100.00','8','0','1005000.00','1','0.045', 'adminpusat','2025-11-19 13:10:09','1.900','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YKAI-1-0','00026871');
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-11-19','MDGL-YKAI-1-0','MDGL','TOKO','INPUT1','100.00','1.910','1.900','1','1.910','1.900','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 ('MDGL-YKAI-2-0','00026872',' ','GL FANCY DB MN 12 17CM KKT PER UBS ','','GR','---','MD','MDGL','TOKO','INPUT1','7296500','2025-11-19','7296500','7.260','100.00','8','0','1005000.00','1','0.045', 'adminpusat','2025-11-19 13:11:12','7.250','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDGL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDGL','MDGL-YKAI-2-0','00026872');
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-11-19','MDGL-YKAI-2-0','MDGL','TOKO','INPUT1','100.00','7.260','7.250','1','7.260','7.250','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 ('MDKL-YKAI-3-0','00026873',' ','KL FANCY 49CM KKT PER BLT UBS ','','GR','---','MD','MDKL','TOKO','INPUT1','5075500','2025-11-19','5075500','5.050','100.00','8','0','1005000.00','1','0.045', 'adminpusat','2025-11-19 13:12:14','5.040','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-YKAI-3-0','00026873');
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-11-19','MDKL-YKAI-3-0','MDKL','TOKO','INPUT1','100.00','5.050','5.040','1','5.050','5.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,berat_atribut,kode_baki) VALUES ('MDKL-YKAI-4-0','00026874','EX ','KL HL RT PAPRAS 44CM KKT S UBS ','','GR','---','MD','MDKL','TOKO','INPUT1','8120500','2025-11-19','8120500','8.080','100.00','8','0','1005000.00','1','0.045', 'adminpusat','2025-11-19 13:14:20','8.070','0','','0','','TOKO','FREETAG','','0','','0','');
DELETE FROM tp_barang WHERE kode_dept = 'MDKL' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('MDKL','MDKL-YKAI-4-0','00026874');
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-11-19','MDKL-YKAI-4-0','MDKL','TOKO','INPUT1','100.00','8.080','8.070','1','8.080','8.070','1');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-251119-0001','1','MDGL-YKAI-1-0','1','1.910','1.910','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YKAI-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-11-19','TOKO','BGLMD','MDGL','MDGL-YKAI-1-0','100.00','1','1.910','1.900','1','1.910','1.900');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.910',berat_out_asli=berat_out_asli+'1.900',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-19' AND kode_barang='MDGL-YKAI-1-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-251119-0001','2','MDGL-YKAI-2-0','1','7.260','7.260','TOKO','INPUT1','TOKO','BGLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BGLMD' WHERE kode_barang='MDGL-YKAI-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-11-19','TOKO','BGLMD','MDGL','MDGL-YKAI-2-0','100.00','1','7.260','7.250','1','7.260','7.250');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'7.260',berat_out_asli=berat_out_asli+'7.250',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-19' AND kode_barang='MDGL-YKAI-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-251119-0001','2025-11-19','2025-11-19','13:23','9.17','adminpusat','2025-11-19 13:23:41');
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-251119-0002','1','MDKL-YKAI-3-0','1','5.050','5.050','TOKO','INPUT1','TOKO','BKLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-YKAI-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-11-19','TOKO','BKLMD','MDKL','MDKL-YKAI-3-0','100.00','1','5.050','5.040','1','5.050','5.040');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.050',berat_out_asli=berat_out_asli+'5.040',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-19' AND kode_barang='MDKL-YKAI-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-251119-0002','2','MDKL-YKAI-4-0','1','8.080','8.080','TOKO','INPUT1','TOKO','BKLMD');
UPDATE tm_barang SET kode_lokasi_gudang='TOKO', kode_lokasi_toko='BKLMD' WHERE kode_barang='MDKL-YKAI-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-11-19','TOKO','BKLMD','MDKL','MDKL-YKAI-4-0','100.00','1','8.080','8.070','1','8.080','8.070');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'8.080',berat_out_asli=berat_out_asli+'8.070',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-11-19' AND kode_barang='MDKL-YKAI-4-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-251119-0002','2025-11-19','2025-11-19','13:23','13.13','adminpusat','2025-11-19 13:24:17');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251119-0001','1','MDGL-YKAI-1-0','1','1.910','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKAI-1-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKAI-1-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BGLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BGLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDGL-YKAI-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.910',berat_out_asli='1.900', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.910',berat_akhir_asli =berat_akhir_asli-'1.900' WHERE kode_barang='MDGL-YKAI-1-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251119-0001','2','MDGL-YKAI-2-0','1','7.260','TOKO','BGLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDGL-YKAI-2-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDGL-YKAI-2-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDGL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDGL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BGLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BGLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDGL-YKAI-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='7.260',berat_out_asli='7.250', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'7.260',berat_akhir_asli =berat_akhir_asli-'7.250' WHERE kode_barang='MDGL-YKAI-2-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-251119-0001','2025-11-19','2025-11-19','13:24','7.260','adminpusat','251119');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251119-0002','1','MDKL-YKAI-3-0','1','5.050','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKAI-3-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKAI-3-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKAI-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.050',berat_out_asli='5.040', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.050',berat_akhir_asli =berat_akhir_asli-'5.040' WHERE kode_barang='MDKL-YKAI-3-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251119-0002','2','MDKL-YKAI-4-0','1','8.080','TOKO','BKLMD');
DELETE FROM tm_barang_export WHERE kode_barang='MDKL-YKAI-4-0' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='MDKL-YKAI-4-0' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_group_export WHERE kode_group='MD' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_group_export SELECT * FROM tm_group WHERE kode_group='MD' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_dept_export WHERE kode_dept='MDKL' LIMIT 1;
INSERT INTO db_nagagold_sahabatgold1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='MDKL' LIMIT 1;
DELETE FROM db_nagagold_sahabatgold1.tm_lokasi_toko_export WHERE kode_lokasi_toko='BKLMD';
INSERT INTO db_nagagold_sahabatgold1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='BKLMD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='MDKL-YKAI-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='8.080',berat_out_asli='8.070', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'8.080',berat_akhir_asli =berat_akhir_asli-'8.070' WHERE kode_barang='MDKL-YKAI-4-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-251119-0002','2025-11-19','2025-11-19','13:24','8.080','adminpusat','251119');