INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-07 ','08:03:04');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-07','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-07';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-06';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-06';
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='2026-02-06' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-06';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-06';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-06';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-06';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202601 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
UPDATE tt_barang_saldo SET tanggal= '2026-02-07' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-06' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-02-07';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-02-07 ','10:39:48');
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-ZBXG-1-0','00027806',' ','KL FANCY VAR BT 42CM KKT S SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','4468000','2026-02-07','4468000','3.560','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-07 10:42:37','3.550','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-ZBXG-1-0','00027806');
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 ('2026-02-07','MDKL-ZBXG-1-0','MDKL','TOKO','INPUT1','100.00','3.560','3.550','1','3.560','3.550','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-ZBXG-2-0','00027807',' ','KL FANCY VAR BT 42CM KKT S SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','4317500','2026-02-07','4317500','3.440','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-07 10:43:33','3.430','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-ZBXG-2-0','00027807');
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 ('2026-02-07','MDKL-ZBXG-2-0','MDKL','TOKO','INPUT1','100.00','3.440','3.430','1','3.440','3.430','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDKL-ZBXG-3-0','00027808',' ','KL FANCY DB 43CM KKT S SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','11295000','2026-02-07','11295000','9.000','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-07 10:45:41','8.990','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-ZBXG-3-0','00027808');
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 ('2026-02-07','MDKL-ZBXG-3-0','MDKL','TOKO','INPUT1','100.00','9.000','8.990','1','9.000','8.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 ('MDKL-ZBXG-4-0','00027809',' ','KL FANCY DB 43CM KKT S SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','11308000','2026-02-07','11308000','9.010','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-07 10:46:42','9.000','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-ZBXG-4-0','00027809');
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 ('2026-02-07','MDKL-ZBXG-4-0','MDKL','TOKO','INPUT1','100.00','9.010','9.000','1','9.010','9.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 ('MDKL-ZBXG-5-0','00027810',' ','KL FANCY DB PJG 64CM KKT S SHB ','','GR','---','MD','MDKL','TOKO','INPUT1','12123500','2026-02-07','12123500','9.660','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-07 10:48:07','9.650','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-ZBXG-5-0','00027810');
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 ('2026-02-07','MDKL-ZBXG-5-0','MDKL','TOKO','INPUT1','100.00','9.660','9.650','1','9.660','9.650','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-ZBXG-6-0','00027811',' ','KL PAJERO 50CM KKT PER LC2 ','','GR','---','MD','MDKL','TOKO','INPUT1','29003500','2026-02-07','29003500','23.110','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-07 10:50:47','23.100','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-ZBXG-6-0','00027811');
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 ('2026-02-07','MDKL-ZBXG-6-0','MDKL','TOKO','INPUT1','100.00','23.110','23.100','1','23.110','23.100','1');
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,kode_baki) VALUES ('MDKL-ZBXG-7-0','00027812','EX ','KL PAJERO 50CM KKT PER LC2 ','','GR','---','MD','MDKL','TOKO','INPUT1','30321000','2026-02-07','30321000','24.160','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-07 10:52:13','24.150','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-ZBXG-7-0','00027812');
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 ('2026-02-07','MDKL-ZBXG-7-0','MDKL','TOKO','INPUT1','100.00','24.160','24.150','1','24.160','24.150','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-ZBXG-8-0','00027813',' ','KL FORTUNE PJG 75CM KKT PER LC2 ','','GR','---','MD','MDKL','TOKO','INPUT1','62261000','2026-02-07','62261000','49.610','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-07 10:54:41','49.600','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-ZBXG-8-0','00027813');
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 ('2026-02-07','MDKL-ZBXG-8-0','MDKL','TOKO','INPUT1','100.00','49.610','49.600','1','49.610','49.600','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-ZBXG-9-0','00027814',' ','KL FORTUNE 21CM KKT PER LC2 ','','GR','---','MD','MDKL','TOKO','INPUT1','40198000','2026-02-07','40198000','32.030','100.00','8','0','1255000.00','1','0.045', 'adminpusat','2026-02-07 10:56:26','32.020','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-ZBXG-9-0','00027814');
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 ('2026-02-07','MDKL-ZBXG-9-0','MDKL','TOKO','INPUT1','100.00','32.030','32.020','1','32.030','32.020','1');