搜索到
179
篇与
的结果
-
缺件排产代码备份 <!DOCTYPE html><meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>缺件排产</title> <script src="https://cdn.jsdelivr.net/npm/xlsx@0.18.5/dist/xlsx.full.min.js"></script> <style> body { font-family: Arial, sans-serif; margin: 20px; line-height: 1.6; } .container { max-width: 1200px; margin: 0 auto; } h1, h2 { color: #333; } .section { margin-bottom: 30px; padding: 20px; border: 1px solid #ddd; border-radius: 5px; background-color: #f9f9f9; } table { width: 100%; border-collapse: collapse; margin-top: 15px; } th, td { border: 1px solid #ddd; padding: 8px; text-align: left; } th { background-color: #f2f2f2; } tr:nth-child(even) { background-color: #f9f9f9; } .warning { color: #d9534f; font-weight: bold; } .input-group { margin-bottom: 15px; } label { display: inline-block; width: 200px; margin-right: 10px; } input, button { padding: 8px; margin-right: 10px; } button { background-color: #4CAF50; color: white; border: none; cursor: pointer; border-radius: 4px; } button:hover { background-color: #45a049; } #fileInput { display: none; } .file-upload { display: inline-block; padding: 8px 12px; background: #337ab7; color: white; border-radius: 4px; cursor: pointer; } .file-upload:hover { background: #286090; } #loading { display: none; margin-left: 10px; color: #337ab7; font-weight: bold; } .summary { margin-top: 15px; padding: 10px; background-color: #e7f3fe; border-left: 5px solid #2196F3; } </style> <div class="container"> <h1>缺件排产分析工具</h1> <div class="section"> <h2>产能设置</h2> <div class="input-group"> <label for="workers">每日生产人数:</label> <input type="number" id="workers" value="3" min="1"> </div> <div class="input-group"> <label for="productivity">每人每日产量:</label> <input type="number" id="productivity" value="70" min="1"> </div> <div class="input-group"> <label for="startDate">排产开始日期:</label> <input type="date" id="startDate"> </div> </div> <div class="section"> <h2>数据导入</h2> <div class="input-group"> <label>Excel数据导入:</label> <label for="fileInput" class="file-upload">选择Excel文件</label> <input type="file" id="fileInput" accept=".xlsx, .xls" onchange="handleFileUpload(this.files)"> <span id="fileName" style="margin-left:10px;"></span> </div> <div class="input-group"> <label>Excel格式要求:</label> <span>第一列:产品编号, 第二列:交付日期, 第三列:缺件数量</span> </div> </div> <div class="section"> <h2>原始数据</h2> <div id="rawDataSummary" class="summary"></div> <table id="rawDataTable"> <thead> <tr> <th>产品编号</th> <th>交付日期</th> <th>缺件数量</th> </tr> </thead> <tbody></tbody> </table> </div> <div class="section"> <h2>排产计划</h2> <button onclick="generateSchedule()" id="generateBtn">生成排产计划</button> <span id="loading">正在计算中，请稍候...</span> <div id="scheduleSummary" class="summary"></div> <table id="scheduleTable"> <thead> <tr> <th>产品编号</th> <th>缺件数量</th> <th>交付日期</th> <th>排产日期</th> <th>是否超期</th> </tr> </thead> <tbody></tbody> </table> </div> <div class="section"> <h2>预警清单</h2> <div id="warningSummary" class="summary"></div> <table id="warningTable"> <thead> <tr> <th>产品编号</th> <th>缺件数量</th> <th>交付日期</th> <th>预计排产日期</th> <th>超期天数</th> </tr> </thead> <tbody></tbody> </table> </div> </div> <script> // 全局变量 let rawData = []; let scheduleData = []; let warningData = []; // 页面加载时设置默认日期为今天 window.onload = function() { const today = new Date(); const formattedDate = today.toISOString().split('T')[0]; document.getElementById('startDate').value = formattedDate; }; // 解析Excel日期数字 function parseExcelDate(excelDate) { // Excel日期是从1900年1月1日开始的天数 // 注意：Excel错误地认为1900年是闰年，所以需要调整 const utcDays = Math.floor(excelDate - 25569); const utcValue = utcDays * 86400 * 1000; let date = new Date(utcValue); // 处理Excel的1900年闰年错误 if (excelDate >= 60) { date.setTime(date.getTime() - 86400 * 1000); } return date.toISOString().split('T')[0]; } // 处理Excel文件上传 function handleFileUpload(files) { if (files.length === 0) return; const file = files[0]; document.getElementById('fileName').textContent = file.name; const reader = new FileReader(); reader.onload = function(e) { try { const data = new Uint8Array(e.target.result); const workbook = XLSX.read(data, { type: 'array' }); // 假设数据在第一个工作表 const firstSheet = workbook.Sheets[workbook.SheetNames[0]]; const jsonData = XLSX.utils.sheet_to_json(firstSheet, { header: 1 }); // 提取数据 (假设第一行是标题) rawData = []; for (let i = 1; i < jsonData.length; i++) { if (jsonData[i].length >= 3) { // 处理日期 - 可能是数字或字符串 let deliveryDate = ''; const dateValue = jsonData[i][1]; if (typeof dateValue === 'number') { // Excel数字日期 deliveryDate = parseExcelDate(dateValue); } else if (dateValue instanceof Date) { // 已经是Date对象 deliveryDate = dateValue.toISOString().split('T')[0]; } else if (typeof dateValue === 'string') { // 尝试解析字符串日期 const parsedDate = new Date(dateValue); if (!isNaN(parsedDate.getTime())) { deliveryDate = parsedDate.toISOString().split('T')[0]; } } // 处理数量 let quantity = 0; if (typeof jsonData[i][2] === 'number') { quantity = Math.floor(jsonData[i][2]); } else if (typeof jsonData[i][2] === 'string') { quantity = parseInt(jsonData[i][2]) || 0; } rawData.push({ productId: String(jsonData[i][0] || ''), deliveryDate: deliveryDate, quantity: quantity }); } } console.log("解析后的数据:", rawData); displayRawData(); updateRawDataSummary(); } catch (error) { console.error("解析Excel文件时出错:", error); alert('解析Excel文件时出错: ' + error.message); } }; reader.onerror = function() { alert('读取文件时出错'); }; reader.readAsArrayBuffer(file); } // 显示原始数据 function displayRawData() { const tbody = document.querySelector('#rawDataTable tbody'); tbody.innerHTML = ''; rawData.forEach(item => { const row = document.createElement('tr'); row.innerHTML = ` <td>${item.productId}</td> <td>${item.deliveryDate}</td> <td>${item.quantity}</td> `; tbody.appendChild(row); }); } // 更新原始数据摘要 function updateRawDataSummary() { const summary = document.getElementById('rawDataSummary'); const totalItems = rawData.length; const totalQuantity = rawData.reduce((sum, item) => sum + item.quantity, 0); summary.innerHTML = ` 共 ${totalItems} 条记录，总缺件数量: ${totalQuantity} 件 ${rawData.some(item => !item.deliveryDate) ? '<span class="warning"> (警告: 部分记录缺少交付日期)</span>' : ''} `; } // 生成排产计划 function generateSchedule() { const btn = document.getElementById('generateBtn'); const loading = document.getElementById('loading'); btn.disabled = true; loading.style.display = 'inline'; // 使用setTimeout让UI有机会更新 setTimeout(() => { try { console.log("开始生成排产计划..."); if (rawData.length === 0) { alert('请先导入Excel数据'); return; } // 检查无效数据 const invalidData = rawData.filter(item => !item.deliveryDate || isNaN(new Date(item.deliveryDate).getTime()) || isNaN(item.quantity) ); if (invalidData.length > 0) { console.error("无效数据:", invalidData); alert(`发现 ${invalidData.length} 条无效记录，请检查数据`); return; } const workers = parseInt(document.getElementById('workers').value) || 3; const productivity = parseInt(document.getElementById('productivity').value) || 70; const startDateStr = document.getElementById('startDate').value; if (!startDateStr) { alert('请设置排产开始日期'); return; } const dailyCapacity = workers * productivity; let currentDate = new Date(startDateStr); let dailyRemaining = dailyCapacity; scheduleData = []; warningData = []; // 按交付日期排序 const sortedData = [...rawData].sort((a, b) => { return new Date(a.deliveryDate) - new Date(b.deliveryDate); }); console.log("排序后的数据:", sortedData); // 分配生产日期 for (const item of sortedData) { let productionDate = new Date(currentDate); let quantityRemaining = item.quantity; while (quantityRemaining > 0) { if (dailyRemaining === 0) { // 转到下一天 currentDate.setDate(currentDate.getDate() + 1); dailyRemaining = dailyCapacity; productionDate = new Date(currentDate); console.log(`转到下一天: ${productionDate.toISOString().split('T')[0]}, 剩余产能: ${dailyRemaining}`); } const allocate = Math.min(quantityRemaining, dailyRemaining); const isLate = productionDate > new Date(item.deliveryDate); scheduleData.push({ productId: item.productId, quantity: allocate, deliveryDate: item.deliveryDate, productionDate: productionDate.toISOString().split('T')[0], isLate: isLate }); quantityRemaining -= allocate; dailyRemaining -= allocate; console.log(`分配 ${allocate} 件, 剩余 ${quantityRemaining} 件, 当日剩余产能: ${dailyRemaining}`); } } // 生成预警清单 generateWarnings(); // 显示结果 displaySchedule(); displayWarnings(); updateSummary(); console.log("排产计划生成完成"); console.log("排产数据:", scheduleData); console.log("预警数据:", warningData); } catch (error) { console.error("生成排产计划时出错:", error); alert('生成排产计划时出错: ' + error.message); } finally { btn.disabled = false; loading.style.display = 'none'; } }, 100); } // 生成预警清单 function generateWarnings() { warningData = []; // 按产品分组 const productGroups = scheduleData.reduce((groups, item) => { if (!groups[item.productId]) { groups[item.productId] = []; } groups[item.productId].push(item); return groups; }, {}); // 检查每个产品的最后生产日期 for (const productId in productGroups) { const items = productGroups[productId]; const lastItem = items.reduce((latest, curr) => { return new Date(curr.productionDate) > new Date(latest.productionDate) ? curr : latest; }); if (lastItem.isLate) { const lateDays = Math.ceil( (new Date(lastItem.productionDate) - new Date(lastItem.deliveryDate)) / (1000 * 60 * 60 * 24) ); warningData.push({ productId: productId, quantity: items.reduce((sum, item) => sum + item.quantity, 0), deliveryDate: lastItem.deliveryDate, productionDate: lastItem.productionDate, lateDays: lateDays }); } } } // 更新摘要信息 function updateSummary() { const scheduleSummary = document.getElementById('scheduleSummary'); const warningSummary = document.getElementById('warningSummary'); const totalItems = scheduleData.length; const totalQuantity = scheduleData.reduce((sum, item) => sum + item.quantity, 0); const lateItems = scheduleData.filter(item => item.isLate).length; scheduleSummary.innerHTML = ` 共 ${totalItems} 条排产记录，总排产量: ${totalQuantity} 件，超期项目: ${lateItems} 个 `; const warningCount = warningData.length; const warningQuantity = warningData.reduce((sum, item) => sum + item.quantity, 0); warningSummary.innerHTML = ` 共 ${warningCount} 个产品需要预警，总数量: ${warningQuantity} 件 `; } // 显示排产计划 function displaySchedule() { const tbody = document.querySelector('#scheduleTable tbody'); tbody.innerHTML = ''; scheduleData.forEach(item => { const row = document.createElement('tr'); if (item.isLate) { row.classList.add('warning'); } row.innerHTML = ` <td>${item.productId}</td> <td>${item.quantity}</td> <td>${item.deliveryDate}</td> <td>${item.productionDate}</td> <td>${item.isLate ? '是' : '否'}</td> `; tbody.appendChild(row); }); } // 显示预警清单 function displayWarnings() { const tbody = document.querySelector('#warningTable tbody'); tbody.innerHTML = ''; // 按产品分组，只显示每个产品的最后一条记录 const groupedWarnings = warningData.reduce((acc, curr) => { acc[curr.productId] = curr; return acc; }, {}); Object.values(groupedWarnings).forEach(item => { const row = document.createElement('tr'); row.classList.add('warning'); row.innerHTML = ` <td>${item.productId}</td> <td>${item.quantity}</td> <td>${item.deliveryDate}</td> <td>${item.productionDate}</td> <td>${item.lateDays}</td> `; tbody.appendChild(row); }); } </script> -
Climate change could affect timekeeping, study says {mp3 name="听力" url="http://v-hls.chinadaily.com.cn/stream/607212/903f9e1b-f05d-485d-b69c-e37ae16606b4/571fde86-381d-4d12-8cf6-bc045c95a981.mp3" cover="https://img2.chinadaily.com.cn/images/202404/08/66139dd2a31082fc2b6bcb5b.jpeg" theme="#f0ad4e" autoplay="autoplay"/}Climate change is affecting the speed of the Earth's rotation and could impact how we keep time, a study says.一项研究称，气候变化正在影响地球的自转速度，并可能影响人类的计时方式。"Global warming is already affecting global timekeeping," says the study, published in the journal Nature.这项发表在《自然》（Nature）杂志上的研究指出："全球变暖已经在影响全球计时。"Coordinated Universal Time (UTC) - which is used by most of the world to regulate clocks and time - is calculated by the Earth's rotation."协调世界时"（UTC）是根据地球自转计算出来的，世界上大多数国家都用它来管理时钟和时间。But the Earth's rotation rate is not constant and can therefore have an effect on how long our days and nights are.但地球的自转速度并不是恒定的，因此会对我们的昼夜长短产生影响。Changes to the planet's liquid core have meant the Earth has been spinning slightly quicker.地球液态内核的变化意味着地球自转速度略快。Since the 1970s, to correct for this, about 27 leap seconds have been added to the global clock, with timekeepers planning on subtracting a second for the first time in 2026. This is known as a "negative leap second."自 20 世纪 70 年代以来，为了纠正这一现象，全球时钟已经增加了约 27 个闰秒，计时员计划将在 2026 年首次减少一秒。这被称为 "负闰秒"。However, the study finds that ice melting caused by climate change has partly offset that acceleration.然而，研究发现，气候变化导致的冰雪融化部分抵消了这一加速。Ice sheets are now losing mass five times faster than they were 30 years ago, meaning that the negative leap second change will not be needed until 2029, the study suggests.研究表明，冰盖现在的质量损失速度是30年前的5倍，这意味着可能直到2029年才需要负闰秒的变化。"It's kind of impressive, even to me, we've done something that measurably changes how fast the Earth rotates," Duncan Agnew, the author of the study, told NBC News.这项研究的作者邓肯•阿格纽告诉美国全国广播公司新闻（NBC News）："即使对我来说，我们已经做了一些可以适度地改变地球旋转速度的事情，这也是令人印象深刻的。""Things are happening that are unprecedented.""正在发生的事情是前所未有的。"The negative leap second has never been used before and, according to the study, its use "will pose an unprecedented problem" for computer systems across the world.负闰秒以前从未使用过，根据这项研究，负闰秒的使用将给全球计算机系统 "带来前所未有的问题"。"This has never happened before, and poses a major challenge to making sure that all parts of the global timing infrastructure show the same time," Mr Agnew, who is a researcher at the University of California, San Diego told AFP news agency.加利福尼亚大学圣迭戈分校的研究员阿格纽先生告诉法新社记者："这种情况以前从未发生过，这对确保全球计时基础设施的所有部分都显示相同的时间构成了重大挑战。""Many computer programs for leap seconds assume they are all positive, so these would have to be rewritten," he added.他补充说："许多计算闰秒的计算机程序都假定它们都是正数，因此这些程序必须重写。"There has been some skepticism of the study, however.然而，也有一些人对这项研究持怀疑态度。Demetrios Matsakis, former chief scientist for time services at the US Naval Observatory, told AFP that "Earth is too unpredictable to be sure" if a negative leap second would be needed any time soon.美国海军天文台负责时间服务的前首席科学家德米特里奥斯•马萨基斯告诉法新社说，"地球太不可预测了，无法确定是否在不久的将来就需要负闰秒。"Human activities like burning fossil fuels are causing world temperatures to rise.燃烧化石燃料等人类活动正在导致全球气温上升。That temperature rise is having a huge effect on the environment, including the rapid melting of glaciers and ice sheets.气温上升对环境产生了巨大影响，包括冰川和冰盖的迅速融化。
-
mysql配置外网权限 好久不用都忘记了，这次再整理一下，方便以后查找。查看所有用户：SELECT user, host FROM mysql.user;查看特定用户的权限：SHOW GRANTS FOR 'username'@'hostname';查看用户的连接信息和权限：SELECT user, host, authentication_string FROM mysql.user;查看当前登录的用户：SELECT USER();查询所有用户的权限信息，使用以下命令：SHOW GRANTS;使用以下步骤来创建用户并授权外网访问：使用root用户登录到MySQL服务器上。如果尚未设置root密码，请使用以下命令更改或设置root密码：ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';创建新用户并授予外网访问权限。假设要创建一个名为new_user，允许从任何主机（'%'）访问数据库，并设置密码为user_password，可以使用以下命令：CREATE USER 'new_user'@'%' IDENTIFIED BY 'user_password';授予新用户对数据库的访问权限。例如，如果希望new_user用户有SELECT, INSERT, UPDATE和DELETE权限：GRANT SELECT, INSERT, UPDATE, DELETE ON database_name.* TO 'new_user'@'%';替换database_name为实际数据库的名称。刷新权限使更改生效：FLUSH PRIVILEGES;
-
-
Ivory Coast celebrates oil find as west turns away from fossil fuels Ivorians celebrated when Italian energy group Eni revealed that it had discovered up to A 2bn barrels of oil in waters off the west African country’s coast — the first big find in two decades.Ivorians celebrated when Italian energy group Eni revealed that it had discovered up to 2bn barrels of oil in waters off the west African country’s coast — the first big find in two decades.“It’s a great discovery,” said Abdourahmane Cissé, secretary-general of the Ivorian presidency, of last month’s find. “The preliminary results show that, in terms of oil reserves, it is approximately 10 times what we have at the moment,” he said, referring to initial estimates of between 1.5bn and 2bn barrels of oil as well as between 1.8tn and 2.4tn cubic feet of associated gas.Oil could start flowing within four years, boosting exports from a country that is already the world’s biggest grower of cocoa. “This will be good for the country,” said Cissé.But not everyone shares his confidence. Ivory Coast has struck oil just as much of the developed world has begun to call time on fossil fuels and some financial institutions are reluctant to take carbon-emitting projects on to their balance sheets.“People say: ‘We’ve found oil, we’ve found gas, we’re all going to get rich’,” said Kingsmill Bond, an energy strategist at think-tank Carbon Tracker. “But getting involved in extraction of fossil fuels is much riskier than it used to be and much riskier than it is perceived to be.”While Ivory Coast is already pumping small quantities of oil, Bond said the risk was that it would bring more “on stream at a time when the market is already in decline”. As advanced economies made the switch to electric vehicles and moved rapidly to renewable energy, demand for oil would fall and only the lowest-cost producers would survive, he added.Production costs of offshore African oil, especially in deep water, were relatively high, Bond said. Ivory Coast’s discovery is at about 1,200 metres. Despite the surge in oil and gas prices this autumn, many analysts argue that declining demand will eventually force prices down, making higher-cost oil uncompetitive.‘We’re not the polluters, the others are’The Ivorian find also taps into a broader debate about what it is reasonable to expect of developing countries that are reliant on fossil fuels.As the COP26 UN climate change summit in Glasgow approaches and many rich countries accelerate their shift towards clean energy, some governments in Africa — particularly hydrocarbon producers such as Nigeria and Equatorial Guinea — are calling for a “just energy transition” that allows for a slower switch to other fuels.Governments in Africa, which are responsible for at most 3 per cent of global emissions, object to being pressured by banks and donors to abandon the fossil fuels on which they say their industrialisation and development depends. Many, including Ghana, Senegal and Mauritania, are only now gearing up their hydrocarbon production.“We’re going to do what is in the interests of our country,” said Alassane Ouattara, president of Ivory Coast, in an interview, adding that Abidjan intended to exploit its hydrocarbons for the benefit of its people.Countries such as the US, where carbon emissions were nearly 40 times higher per capita than in Ivory Coast, were in no position to lecture, he said. “We are not the polluters. The others are,” he added.Powering the nation: ‘We will need gas’Alessandro Puliti, Eni’s chief operating officer for natural resources, said the Ivorian discovery met the Italian company’s criteria for investment. This was partly because the associated gas could be fed into existing infrastructure that already supplied Ivory Coast with 60 per cent of its electricity, he said.In Ivory Coast, a relatively high three-quarters of people have electricity and it has one of west Africa’s most reliable power grids. It exports electricity to Ghana, Mali, Benin, Togo and Burkina Faso.Energy minister Thomas Camara said that by 2030 the Ivorian government intended to increase the mix of renewable energy — currently entirely hydro — from 40 per cent to 42 per cent of a much larger energy pie.There were plans to add solar, including from a floating solar farm on a lake, as well as biomass energy made from waste in the palm oil and cocoa industries, he said. “But we envisage our energy needs will go up significantly by 2030 and for that we will need gas.”Africa without oil?There was a danger the world was transitioning towards green energy without taking into account the huge development needs in Africa and other poorer regions, said Kenny Fihla, chief executive of wholesale clients at Standard Bank, Africa’s biggest lender.Older petrol and diesel vehicles would be on the road much longer in Africa, where most countries relied on second-hand imports for the bulk of their fleet, he added. “It is nearly impossible to talk about Africa without oil at this stage,” he said. “Even in 2050, there will still be some oil utilisation, as other types of fuel will not have developed adequately to be able to replace it.”Bond from Carbon Tracker urged African governments to look with more urgency at developing solar and wind power which, he said, would prove to be both more abundant and cheaper than fossil fuels.“The way I see it, it is really daft to advise people to invest in the dying technology of fossil fuels when we ourselves are moving to far superior renewable technologies,” he said. “Africa missed out on the fossil fuel-driven energy system and all the wealth that flowed from that. But they don’t need to miss out on this one.”Still, in the interim, Ivory Coast was not about to let its big oil find go to waste, said Cissé. Asked if he thought developers would have any difficulty with securing bank lending to develop the oilfield, he said: “Now they’ve found it, trust me, there won’t be any issues of financing.”
0:00