INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-23 ','08:04:40');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-23','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-22';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-22';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-22';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-10-22' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-22';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-22';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-22';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-22';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-23' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-22' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-10-23';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-23 ','08:05:32');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-23 ','08:14:28');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-23 ','09:44:52');
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-01233';
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-YJBC-1-0','00039279','DP-01233MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','885500','2025-10-23','885500','3.000','13.00','25','300000','2270000.00','1','0.14', 'input','2025-10-23 09:46:54','3.000','0','','16600.00','','TOKO','FREETAG','','10','','','PSN01233MM','1','RS 16','','DP-01233');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YJBC-1-0','00039279');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-23','PSPLT-YJBC-1-0','PSPLT','TOKO','MMPSN','13.00','3.000','3.000','1','3.000','3.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01233MM ');
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-01263';
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-YJBC-2-0','00039280','DP-01263MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','1234000','2025-10-23','1234000','4.180','13.00','25','300000','2270000.00','1','0.14', 'input','2025-10-23 09:48:23','4.180','0','','16600.00','','TOKO','FREETAG','','10','','','PSN01263MM','1','RS 19','','DP-01263');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-YJBC-2-0','00039280');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-23','PSPLT-YJBC-2-0','PSPLT','TOKO','MMPSN','13.00','4.180','4.180','1','4.180','4.180','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01263MM ');
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-01238';
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-YJBC-3-0','00039281','DP-01238BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','63000','2025-10-23','63000','1.050','100.00','925','350000','60000.00','1','0.14', 'input','2025-10-23 09:50:22','1.050','0','','16600.00','','TOKO','FREETAG','','2','','','PSN01238BIP','1','RS 18','','DP-01238');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-YJBC-3-0','00039281');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-23','PSPRT-YJBC-3-0','PSPRT','TOKO','PSNB','100.00','1.050','1.050','1','1.050','1.050','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01238BIP ');
UPDATE tm_group SET nama_group='DIAMOND',jenis_group='TUA',harga='2250000',status_berlian='1',edit_by='input',edit_date='2025-10-23 13:33:25' WHERE kode_group='DM';
UPDATE tm_barang SET harga_jual=  (kadar/100)*berat *'2250000' WHERE stock_on_hand*1> 0 AND kode_group='DM';
UPDATE tm_group SET nama_group='GOLD',jenis_group='TUA',harga='2250000',status_berlian='0',edit_by='input',edit_date='2025-10-23 13:33:36' WHERE kode_group='GOLD';
UPDATE tm_barang SET harga_jual=  (kadar/100)*berat *'2250000' WHERE stock_on_hand*1> 0 AND kode_group='GOLD';
UPDATE tm_group SET nama_group='PALADIUM',jenis_group='TUA',harga='2250000',status_berlian='0',edit_by='input',edit_date='2025-10-23 13:33:40' WHERE kode_group='PLD';
UPDATE tm_barang SET harga_jual=  (kadar/100)*berat *'2250000' WHERE stock_on_hand*1> 0 AND kode_group='PLD';
UPDATE tm_group SET nama_group='PSN BERLIAN ELCO',jenis_group='TUA',harga='2250000',status_berlian='1',edit_by='input',edit_date='2025-10-23 13:33:44' WHERE kode_group='PSBRE';
UPDATE tm_barang SET harga_jual=  (kadar/100)*berat *'2250000' WHERE stock_on_hand*1> 0 AND kode_group='PSBRE';
UPDATE tm_group SET nama_group='PSN BERLIAN LUXIA',jenis_group='TUA',harga='2250000',status_berlian='1',edit_by='input',edit_date='2025-10-23 13:33:48' WHERE kode_group='PSBRL';
UPDATE tm_barang SET harga_jual=  (kadar/100)*berat *'2250000' WHERE stock_on_hand*1> 0 AND kode_group='PSBRL';
UPDATE tm_group SET nama_group='PSN BERLIAN THIFA',jenis_group='TUA',harga='2250000',status_berlian='1',edit_by='input',edit_date='2025-10-23 13:33:52' WHERE kode_group='PSBRT';
UPDATE tm_barang SET harga_jual=  (kadar/100)*berat *'2250000' WHERE stock_on_hand*1> 0 AND kode_group='PSBRT';
UPDATE tm_group SET nama_group='PSN GOLD ELCO',jenis_group='TUA',harga='2250000',status_berlian='0',edit_by='input',edit_date='2025-10-23 13:33:57' WHERE kode_group='PSGE';
UPDATE tm_barang SET harga_jual=  (kadar/100)*berat *'2250000' WHERE stock_on_hand*1> 0 AND kode_group='PSGE';
UPDATE tm_group SET nama_group='PSN GOLD LUXIA',jenis_group='TUA',harga='2250000',status_berlian='0',edit_by='input',edit_date='2025-10-23 13:34:03' WHERE kode_group='PSGL';
UPDATE tm_barang SET harga_jual=  (kadar/100)*berat *'2250000' WHERE stock_on_hand*1> 0 AND kode_group='PSGL';
UPDATE tm_group SET nama_group='PSN GOLD THIFA',jenis_group='TUA',harga='2250000',status_berlian='0',edit_by='input',edit_date='2025-10-23 13:34:09' WHERE kode_group='PSGT';
UPDATE tm_barang SET harga_jual=  (kadar/100)*berat *'2250000' WHERE stock_on_hand*1> 0 AND kode_group='PSGT';
UPDATE tm_group SET nama_group='PSN PALADIUM ELCO',jenis_group='TUA',harga='2250000',status_berlian='0',edit_by='input',edit_date='2025-10-23 13:34:14' WHERE kode_group='PSPLE';
UPDATE tm_barang SET harga_jual=  (kadar/100)*berat *'2250000' WHERE stock_on_hand*1> 0 AND kode_group='PSPLE';
UPDATE tm_group SET nama_group='PSN PALADIUM LUXIA',jenis_group='TUA',harga='2250000',status_berlian='0',edit_by='input',edit_date='2025-10-23 13:34:18' WHERE kode_group='PSPLL';
UPDATE tm_barang SET harga_jual=  (kadar/100)*berat *'2250000' WHERE stock_on_hand*1> 0 AND kode_group='PSPLL';
UPDATE tm_group SET nama_group='PSN PALADIUM THIFA',jenis_group='TUA',harga='2250000',status_berlian='0',edit_by='input',edit_date='2025-10-23 13:34:22' WHERE kode_group='PSPLT';
UPDATE tm_barang SET harga_jual=  (kadar/100)*berat *'2250000' WHERE stock_on_hand*1> 0 AND kode_group='PSPLT';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-23 ','13:41:48');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-23 ','13:44:35');
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-01264';
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-YJBC-4-0','00039282','DP-01264BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','3940500','2025-10-23','3940500','2.110','83.00','75','300000','2250000.00','1','0.14', 'input','2025-10-23 15:25:16','2.110','0','','16600.00','','TOKO','FREETAG','','2','','','PSN01264BIP','1','RS 12','','DP-01264');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-YJBC-4-0','00039282');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2025-10-23','PSGT-YJBC-4-0','PSGT','TOKO','PSNB','83.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-01264BIP ');