36 lines
1.2 KiB
JavaScript
36 lines
1.2 KiB
JavaScript
(function () {
|
|
const result = [];
|
|
const dictId = "1970693001990479873";
|
|
const dictType = "alarm_type";
|
|
let children = document.querySelector("#doc").children;
|
|
if (children) {
|
|
children = Array.from(children);
|
|
}
|
|
if (children && children.length) {
|
|
children.forEach((dom) => {
|
|
const tdList = dom.querySelectorAll("td");
|
|
const id = tdList[0];
|
|
const desc = tdList[1];
|
|
result.push({
|
|
id: id?.innerText,
|
|
desc: desc?.innerText,
|
|
});
|
|
});
|
|
}
|
|
// 生产sql
|
|
let fullSql = ``;
|
|
if (result && result.length) {
|
|
let sort = 10;
|
|
for (const v of result) {
|
|
// 随机id 当前时间戳 + 6位数数字随机
|
|
const id = new Date().getTime() + Math.floor(Math.random() * 1000000);
|
|
const sql = `
|
|
INSERT INTO jhkjx.sys_dict_item (id, dict_id, item_value, label, dict_type, description, sort_order, create_by, update_by, create_time, update_time, remarks, del_flag, tenant_id) VALUES (${id}, ${dictId}, '${v.id}', '${v.desc}', '${dictType}', '${v.desc}', ${sort}, ' ', ' ', '2019-03-19 11:08:59', '2019-03-25 12:49:13', '', '0', 1);`;
|
|
// 换行
|
|
fullSql = fullSql + sql + "\n";
|
|
sort += 10;
|
|
}
|
|
}
|
|
console.log(fullSql);
|
|
})();
|