INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-22 ','08:06:28');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-20','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-19';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-19';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-19';
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-19' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-19';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-19';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-19';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-19';
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-20' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-19' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-12-20';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-22 ','08:07:06');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-21','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-20';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-20';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-20';
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-20' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-20';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-20';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-20';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-20';
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-21' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-20' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-12-21';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-22 ','08:07:26');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-12-22','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-11-21';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-12-21';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-12-21';
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-21' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-12-21';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-12-21';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-12-21';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-12-21';
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-22' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-12-21' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-12-22';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-22 ','08:07:48');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01493';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSGT-YLBB-1-0','00040651','DP-01493MM ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','MMPSN','4019500','2025-12-22','4019500','2.100','83.00','75','300000','2306000.00','1','0.14', 'input','2025-12-22 08:31:06','2.100','0','','16750.00','','TOKO','FREETAG','','2','','','PSN01493MM','1','RS 18','','DP-01493');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-YLBB-1-0','00040651');
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-22','PSGT-YLBB-1-0','PSGT','TOKO','MMPSN','83.00','2.100','2.100','1','2.100','2.100','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-01493MM ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01504';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-YLBB-2-0','00040652','DP-01504MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','743500','2025-12-22','743500','2.480','13.00','25','300000','2306000.00','1','0.14', 'input','2025-12-22 08:32:30','2.480','0','','16750.00','','TOKO','FREETAG','','10','','','PSN01504MM','1','RS 25 5','','DP-01504');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YLBB-2-0','00040652');
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-22','PSPLT-YLBB-2-0','PSPLT','TOKO','MMPSN','13.00','2.480','2.480','1','2.480','2.480','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01504MM ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01494';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-YLBB-3-0','00040653','DP-01494MM ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','235500','2025-12-22','235500','3.920','100.00','925','350000','60000.00','1','0.14', 'input','2025-12-22 08:33:53','3.920','0','','16750.00','','TOKO','FREETAG','','2','','','PSN01494MM','1','RS 21','','DP-01494');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YLBB-3-0','00040653');
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-22','PSPRT-YLBB-3-0','PSPRT','TOKO','MMPSN','100.00','3.920','3.920','1','3.920','3.920','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01494MM ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PLDMM-YLBB-4-0','00040654','PLDMM-00008 ','CINCIN PALADIUM PLDMM-00008 ','','GR','---','PLD','PLDMM','TOKO','MMPLD','360000','2025-12-22','360000','2.600','6.00','10','100000','2306000.00','1','0.04', 'input','2025-12-22 08:41:16','2.600','0','','16750.00','','TOKO','FREETAG','','10','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PLDMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLDMM','PLDMM-YLBB-4-0','00040654');
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-22','PLDMM-YLBB-4-0','PLDMM','TOKO','MMPLD','6.00','2.600','2.600','1','2.600','2.600','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PLDMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLDMM','PLDMM-00008 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PLDMM-YLBB-5-0','00040655','PLDMM-00009 ','CINCIN PALADIUM PLDMM-00009 ','','GR','---','PLD','PLDMM','TOKO','MMPLD','216000','2025-12-22','216000','1.560','6.00','10','100000','2306000.00','1','0.04', 'input','2025-12-22 08:41:58','1.560','0','','16750.00','','TOKO','FREETAG','','10','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PLDMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLDMM','PLDMM-YLBB-5-0','00040655');
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-22','PLDMM-YLBB-5-0','PLDMM','TOKO','MMPLD','6.00','1.560','1.560','1','1.560','1.560','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PLDMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLDMM','PLDMM-00009 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PLDMM-YLBB-6-0','00040656','PLDMM-00010 ','CINCIN PALADIUM PLDMM-00010 ','','GR','---','PLD','PLDMM','TOKO','MMPLD','333500','2025-12-22','333500','2.410','6.00','10','100000','2306000.00','1','0.04', 'input','2025-12-22 08:42:36','2.410','0','','16750.00','','TOKO','FREETAG','','10','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PLDMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLDMM','PLDMM-YLBB-6-0','00040656');
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-22','PLDMM-YLBB-6-0','PLDMM','TOKO','MMPLD','6.00','2.410','2.410','1','2.410','2.410','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PLDMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLDMM','PLDMM-00010 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PLDMM-YLBB-7-0','00040657','PLDMM-00011 ','CINCIN PALADIUM PLDMM-00011 ','','GR','---','PLD','PLDMM','TOKO','MMPLD','278500','2025-12-22','278500','2.010','6.00','10','100000','2306000.00','1','0.04', 'input','2025-12-22 08:43:14','2.010','0','','16750.00','','TOKO','FREETAG','','10','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PLDMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLDMM','PLDMM-YLBB-7-0','00040657');
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-22','PLDMM-YLBB-7-0','PLDMM','TOKO','MMPLD','6.00','2.010','2.010','1','2.010','2.010','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PLDMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLDMM','PLDMM-00011 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PLDMM-YLBB-8-0','00040658','PLDMM-00012 ','CINCIN PALADIUM PLDMM-00012 ','','GR','---','PLD','PLDMM','TOKO','MMPLD','500000','2025-12-22','500000','3.610','6.00','10','100000','2306000.00','1','0.04', 'input','2025-12-22 08:44:03','3.610','0','','16750.00','','TOKO','FREETAG','','10','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PLDMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLDMM','PLDMM-YLBB-8-0','00040658');
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-22','PLDMM-YLBB-8-0','PLDMM','TOKO','MMPLD','6.00','3.610','3.610','1','3.610','3.610','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PLDMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLDMM','PLDMM-00012 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PLDMM-YLBB-9-0','00040659','PLDMM-00013 ','CINCIN PALADIUM PLDMM-00013 ','','GR','---','PLD','PLDMM','TOKO','MMPLD','504000','2025-12-22','504000','3.640','6.00','10','100000','2306000.00','1','0.04', 'input','2025-12-22 08:44:24','3.640','0','','16750.00','','TOKO','FREETAG','','10','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PLDMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLDMM','PLDMM-YLBB-9-0','00040659');
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-22','PLDMM-YLBB-9-0','PLDMM','TOKO','MMPLD','6.00','3.640','3.640','1','3.640','3.640','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PLDMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLDMM','PLDMM-00013 ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251222-0001','1','PLDMM-YLBB-4-0','1','2.600','TOKO','MMPLD');
DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-YLBB-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-YLBB-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-YLBB-4-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-YLBB-4-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-YLBB-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.600',berat_out_asli='2.600', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.600',berat_akhir_asli =berat_akhir_asli-'2.600' WHERE kode_barang='PLDMM-YLBB-4-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251222-0001','2','PLDMM-YLBB-5-0','1','1.560','TOKO','MMPLD');
DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-YLBB-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-YLBB-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-YLBB-5-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-YLBB-5-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-YLBB-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.560',berat_out_asli='1.560', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.560',berat_akhir_asli =berat_akhir_asli-'1.560' WHERE kode_barang='PLDMM-YLBB-5-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251222-0001','3','PLDMM-YLBB-6-0','1','2.410','TOKO','MMPLD');
DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-YLBB-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-YLBB-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-YLBB-6-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-YLBB-6-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-YLBB-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.410',berat_out_asli='2.410', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.410',berat_akhir_asli =berat_akhir_asli-'2.410' WHERE kode_barang='PLDMM-YLBB-6-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251222-0001','4','PLDMM-YLBB-7-0','1','2.010','TOKO','MMPLD');
DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-YLBB-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-YLBB-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-YLBB-7-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-YLBB-7-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-YLBB-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.010',berat_out_asli='2.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.010',berat_akhir_asli =berat_akhir_asli-'2.010' WHERE kode_barang='PLDMM-YLBB-7-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251222-0001','5','PLDMM-YLBB-8-0','1','3.610','TOKO','MMPLD');
DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-YLBB-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-YLBB-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-YLBB-8-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-YLBB-8-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-YLBB-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.610',berat_out_asli='3.610', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.610',berat_akhir_asli =berat_akhir_asli-'3.610' WHERE kode_barang='PLDMM-YLBB-8-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251222-0001','6','PLDMM-YLBB-9-0','1','3.640','TOKO','MMPLD');
DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-YLBB-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-YLBB-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-YLBB-9-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-YLBB-9-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-YLBB-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.640',berat_out_asli='3.640', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.640',berat_akhir_asli =berat_akhir_asli-'3.640' WHERE kode_barang='PLDMM-YLBB-9-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-251222-0001','2025-12-22','2025-12-22','08:52','3.640','input','2025-12-22 08:52:55','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251222-0002','1','PSGT-YLBB-1-0','1','2.100','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-YLBB-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-YLBB-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-YLBB-1-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-YLBB-1-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-YLBB-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.100',berat_out_asli='2.100', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.100',berat_akhir_asli =berat_akhir_asli-'2.100' WHERE kode_barang='PSGT-YLBB-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-251222-0002','2','PSPLT-YLBB-2-0','1','2.480','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YLBB-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-YLBB-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-YLBB-2-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-YLBB-2-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-YLBB-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.480',berat_out_asli='2.480', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.480',berat_akhir_asli =berat_akhir_asli-'2.480' WHERE kode_barang='PSPLT-YLBB-2-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251222-0002','3','PSPRT-YLBB-3-0','1','3.920','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YLBB-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YLBB-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YLBB-3-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YLBB-3-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-YLBB-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.920',berat_out_asli='3.920', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.920',berat_akhir_asli =berat_akhir_asli-'3.920' WHERE kode_barang='PSPRT-YLBB-3-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-251222-0002','2025-12-22','2025-12-22','08:53','3.920','input','2025-12-22 08:53:04','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-22 ','08:55:28');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-22 ','09:26:02');
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='2412000',harga_beli ='2412000' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='4885500',harga_beli ='4885500' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='190000',harga_beli ='190000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='2764000',harga_beli ='2764000' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='6119500',harga_beli ='6119500' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='2292500',harga_beli ='2292500' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='2193000',harga_beli ='2193000' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='2232500',harga_beli ='2232500' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='5322500',harga_beli ='5322500' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='19653500',harga_beli ='19653500' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='2734500',harga_beli ='2734500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='2709500',harga_beli ='2709500' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='2560500',harga_beli ='2560500' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='2660000',harga_beli ='2660000' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='2635000',harga_beli ='2635000' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='7396500',harga_beli ='7396500' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='2832000',harga_beli ='2832000' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='10144500',harga_beli ='10144500' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='3659500',harga_beli ='3659500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='4301500',harga_beli ='4301500' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='4418500',harga_beli ='4418500' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='5197000',harga_beli ='5197000' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='4204500',harga_beli ='4204500' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='6014500',harga_beli ='6014500' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='7182500',harga_beli ='7182500' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='8661500',harga_beli ='8661500' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='7007000',harga_beli ='7007000' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='1460000',harga_beli ='1460000' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='2705500',harga_beli ='2705500' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='4126500',harga_beli ='4126500' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='3737500',harga_beli ='3737500' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='2141500',harga_beli ='2141500' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='2063500',harga_beli ='2063500' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='6326000',harga_beli ='6326000' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='7591000',harga_beli ='7591000' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='3387000',harga_beli ='3387000' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='6715000',harga_beli ='6715000' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='5333500',harga_beli ='5333500' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='2589000',harga_beli ='2589000' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='2199500',harga_beli ='2199500' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='5002500',harga_beli ='5002500' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='3503500',harga_beli ='3503500' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='5193500',harga_beli ='5193500' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='6695500',harga_beli ='6695500' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='10141000',harga_beli ='10141000' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='9148000',harga_beli ='9148000' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='3348000',harga_beli ='3348000' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='5216500',harga_beli ='5216500' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='7279500',harga_beli ='7279500' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='6637500',harga_beli ='6637500' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='6832000',harga_beli ='6832000' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='7844000',harga_beli ='7844000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='15649000',harga_beli ='15649000' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='1596500',harga_beli ='1596500' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='1596500',harga_beli ='1596500' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='1518500',harga_beli ='1518500' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='1460000',harga_beli ='1460000' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='4827000',harga_beli ='4827000' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='8291500',harga_beli ='8291500' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='9479000',harga_beli ='9479000' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='8058000',harga_beli ='8058000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='7552000',harga_beli ='7552000' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='8272500',harga_beli ='8272500' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='7377000',harga_beli ='7377000' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='4399000',harga_beli ='4399000' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='52805000',harga_beli ='52805000' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='8214000',harga_beli ='8214000' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='7591000',harga_beli ='7591000' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='5625000',harga_beli ='5625000' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='10802500',harga_beli ='10802500' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='12536000',harga_beli ='12536000' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='7202000',harga_beli ='7202000' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='5820000',harga_beli ='5820000' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='6384500',harga_beli ='6384500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='5002500',harga_beli ='5002500' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2345000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2345000','input','2025-12-22 11:28:49');
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='16444500',harga_beli ='16444500' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='9647500',harga_beli ='9647500' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='5083000',harga_beli ='5083000' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='5123000',harga_beli ='5123000' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='5945000',harga_beli ='5945000' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='4512500',harga_beli ='4512500' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='11207000',harga_beli ='11207000' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='3440000',harga_beli ='3440000' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='12897500',harga_beli ='12897500' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='6131500',harga_beli ='6131500' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2345000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2345000','input','2025-12-22 11:28:55');
UPDATE tm_group SET harga='2345000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2345000','input','2025-12-22 11:29:28');
UPDATE tm_group SET harga='2345000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2345000','input','2025-12-22 11:29:32');
UPDATE tm_group SET harga='2345000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2345000','input','2025-12-22 11:29:35');
UPDATE tm_group SET harga='2345000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2345000','input','2025-12-22 11:29:38');
UPDATE tm_group SET harga='2345000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2345000','input','2025-12-22 11:29:42');
UPDATE tm_group SET harga='2345000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2345000','input','2025-12-22 11:29:47');
UPDATE tm_barang SET harga_skrg ='2345000',harga_jual='3542500',harga_beli ='3542500' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2345000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2345000','input','2025-12-22 11:29:51');
UPDATE tm_group SET harga='2345000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2345000','input','2025-12-22 11:29:55');
UPDATE tm_group SET harga='2345000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','2345000','input','2025-12-22 11:30:05');
UPDATE tm_group SET harga='2345000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','2345000','input','2025-12-22 11:30:10');
UPDATE tm_group SET harga='2345000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','2345000','input','2025-12-22 11:30:13');
UPDATE tp_curr SET rp= '16800.00' WHERE curr = 'USD' LIMIT 1;
INSERT INTO th_troy_curr(curr,rp,input_by,input_date) VALUES ('USD', '16800.00', 'input','2025-12-22 11:30:21');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-22 ','13:15:03');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-12-22 ','14:19:20');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01507';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSGT-YLBB-10-0','00040660','DP-01507BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','2870000','2025-12-22','2870000','2.110','58.00','50','300000','2345000.00','1','0.14', 'input','2025-12-22 16:28:40','2.110','0','','16800.00','','TOKO','FREETAG','','2','','','PSN01507BIP','1','RS 9 5','','DP-01507');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-YLBB-10-0','00040660');
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-22','PSGT-YLBB-10-0','PSGT','TOKO','PSNB','58.00','2.110','2.110','1','2.110','2.110','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-01507BIP ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01508';
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,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-YLBB-11-0','00040661','DP-01508BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','141000','2025-12-22','141000','2.350','100.00','925','350000','60000.00','1','0.14', 'input','2025-12-22 16:30:23','2.350','0','','16800.00','','TOKO','FREETAG','','2','','','PSN01508BIP','1','RS 12','','DP-01508');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YLBB-11-0','00040661');
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-22','PSPRT-YLBB-11-0','PSPRT','TOKO','PSNB','100.00','2.350','2.350','1','2.350','2.350','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01508BIP ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251222-0003','1','PSGT-YLBB-10-0','1','2.110','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-YLBB-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-YLBB-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-YLBB-10-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-YLBB-10-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-YLBB-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.110',berat_out_asli='2.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.110',berat_akhir_asli =berat_akhir_asli-'2.110' WHERE kode_barang='PSGT-YLBB-10-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-251222-0003','2','PSPRT-YLBB-11-0','1','2.350','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YLBB-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-YLBB-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-YLBB-11-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-YLBB-11-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-YLBB-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.350',berat_out_asli='2.350', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.350',berat_akhir_asli =berat_akhir_asli-'2.350' WHERE kode_barang='PSPRT-YLBB-11-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-251222-0003','2025-12-22','2025-12-22','16:32','2.350','input','2025-12-22 16:32:27','THIFA');