搜索到
13
篇与
的结果
-
测试 <?php header('Content-Type: application/json'); header('Access-Control-Allow-Origin: *'); header('Access-Control-Allow-Methods: POST'); header('Access-Control-Allow-Headers: Content-Type'); try { $input = json_decode(file_get_contents('php://input'), true); if (!$input || !isset($input['data']) || empty($input['data'])) { throw new Exception('无效数据，请检查输入'); } $rawData = $input['data']; $workers = isset($input['workers']) ? intval($input['workers']) : 3; $productivity = isset($input['productivity']) ? intval($input['productivity']) : 70; $startDateStr = isset($input['startDate']) ? $input['startDate'] : null; if (!$startDateStr) { throw new Exception('请提供排产开始日期'); } // 数据库连接 $pdo = new PDO("mysql:host=localhost;dbname=ytpmc;charset=utf8", "ytpmc", "ytpmc321"); $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // 查询 sl 表 $slMap = []; $stmt = $pdo->query("SELECT productId, sl FROM text"); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) { $slMap[$row['productId']] = intval($row['sl']); } $dailyCapacity = $workers * $productivity; $scheduleData = []; $warningData = []; usort($rawData, function ($a, $b) { $dateDiff = strtotime($a['deliveryDate']) - strtotime($b['deliveryDate']); return $dateDiff !== 0 ? $dateDiff : ($a['originalQuantity'] - $b['originalQuantity']); }); $currentDate = new DateTime($startDateStr); $dailyRemaining = $dailyCapacity; $dailyProductionMap = []; // 每日产品排产汇总 $dailyProductCount = 0; $queue = $rawData; while (!empty($queue)) { $isAnyOrderScheduled = false; foreach ($queue as $key => &$item) { $productId = $item['productId']; $quantityRemaining = $item['quantity']; // 获取 sl，并同步 dailyMax if (isset($slMap[$productId])) { $sl = $slMap[$productId]; $item['dailyMax'] = min($item['dailyMax'], $sl); } else { $sl = $item['dailyMax']; } $alreadyProducedToday = $dailyProductionMap[$productId]['quantity'] ?? 0; // 还可排产量（不能超过 dailyMax，也不能超过日产能剩余） $maxAllocatable = min( $quantityRemaining, $item['dailyMax'] - $alreadyProducedToday, $dailyRemaining ); if ($maxAllocatable > 0) { // 累加数量 if (isset($dailyProductionMap[$productId])) { $dailyProductionMap[$productId]['quantity'] += $maxAllocatable; } else { $dailyProductionMap[$productId] = [ 'productId' => $productId, 'quantity' => $maxAllocatable, 'deliveryDate' => $item['deliveryDate'], 'dailyMax' => $item['dailyMax'], 'productionDate' => $currentDate->format('Y-m-d'), 'isLate' => strtotime($currentDate->format('Y-m-d')) > strtotime($item['deliveryDate']), 'sl' => $sl ]; } $item['quantity'] -= $maxAllocatable; $dailyRemaining -= $maxAllocatable; $dailyProductCount++; $isAnyOrderScheduled = true; if ($item['quantity'] <= 0) { unset($queue[$key]); } } if ($dailyProductCount >= 80) { break; } } // 保存每日排产记录 if (!empty($dailyProductionMap)) { foreach ($dailyProductionMap as $record) { $scheduleData[] = $record; } } // 下一天 $currentDate->modify('+1 day'); $dailyRemaining = $dailyCapacity; $dailyProductCount = 0; $dailyProductionMap = []; } // 预警检查 foreach ($rawData as $item) { $lastProdDate = null; foreach ($scheduleData as $schedule) { if ($schedule['productId'] === $item['productId'] && $schedule['deliveryDate'] === $item['deliveryDate']) { $lastProdDate = new DateTime($schedule['productionDate']); } } if ($lastProdDate && $lastProdDate > new DateTime($item['deliveryDate'])) { $lateDays = $lastProdDate->diff(new DateTime($item['deliveryDate']))->days; $warningData[] = [ 'productId' => $item['productId'], 'quantity' => $item['originalQuantity'], 'deliveryDate' => $item['deliveryDate'], 'dailyMax' => $item['dailyMax'], 'productionDate' => $lastProdDate->format('Y-m-d'), 'lateDays' => $lateDays ]; } } echo json_encode([ 'success' => true, 'scheduleData' => $scheduleData, 'warningData' => $warningData ]); } catch (Exception $e) { echo json_encode([ 'success' => false, 'message' => $e->getMessage() ]); } ?> -
test <!DOCTYPE html> <html lang="zh-CN"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>生产计划跟踪</title> <link href="https://cdn.bootcdn.net/ajax/libs/twitter-bootstrap/5.1.3/css/bootstrap.min.css" rel="stylesheet"> <style> .nav-tabs { border-bottom: 2px solid #0d6efd; } .tab-pane { padding: 20px 0; } .progress-bar { transition: width 0.3s ease; } input[type="number"] { max-width: 120px; } .card { box-shadow: 0 2px 8px rgba(0,0,0,0.1); } .table-hover tbody tr:hover { background-color: #f8f9fa; } </style> </head> <body class="bg-light"> <div class="container py-4"> <!-- 产品汇总标签页 --> <h3 class="mb-4 text-primary">生产计划总览</h3> <nav> <div class="nav nav-tabs" id="nav-tab" role="tablist"> <?php $conn = new mysqli("localhost", "ytpmc", "ytpmc321", "ytpmc"); $parts = $conn->query("SELECT num, sum(sl),ht as total FROM `ordert` where ht='缠布' GROUP BY num"); $parts2 = $conn->query("SELECT num,part,sl,pbsj,zt,ht FROM `ordert` where ht='缠布'"); $first = true; while($row = $parts->fetch_assoc()) { // $active = $first ? 'active' : ''; echo '<button class="nav-link '.$active.'" data-bs-toggle="tab" data-bs-target="#part'.$row['num'].'" type="button"> '.$row['num'].' <span class="badge bg-primary">'.$row['total'].'</span> </button>'; $first = false; } ?> </div> </nav> <!-- 明细内容区域 --> <div class="tab-content mt-3" id="nav-tabContent"> <?php $parts2 = $conn->query("SELECT num,part,sl,pbsj,zt,ht FROM `ordert` where ht='缠布'"); $parts2->data_seek(0); while($part = $parts2->fetch_assoc()) { $active = $part === reset($parts2) ? 'show active' : ''; echo '<div class="tab-pane fade '.$active.'" id="part'.$part['num'].'"> <div class="card"> <div class="card-header bg-white"> <h5>'.$part['num'].' - 生产明细</h5> </div> <div class="card-body"> <table class="table table-hover"> <thead> <tr> <th>产品编号</th> <th>需求数量</th> <th>完成数量</th> <th>操作</th> </tr> </thead> <tbody>'; $sql = "SELECT id,part,sl,wc_sl,zt,ht FROM `ordert` WHERE ht='缠布' AND num='{$part['num']}'"; $details = $conn->query($sql); while($row = $details->fetch_assoc()) { echo '<tr> <td>'.$row['part'].'</td> <td>'.$row['sl'].'</td> <td> <input type="number" class="form-control complete-input" min="0" max="'.$row['sl'].'" value="'.$row['wc_sl'].'" '.($row['zt'] == 'wc' ? 'disabled' : '').'> </td> <td> <button class="btn btn-sm '.($row['zt'] == 'wc' ? 'btn-success' : 'btn-primary').' save-btn" data-num="'.$row['part'].'" '.($row['zt'] == 'wc' ? 'disabled' : '').'> '.($row['zt'] == 'wc' ? '已完成' : '保存').' </button> </td> </tr>'; } echo '</tbody></table></div></div></div>'; } ?> </div> </div> <script src="https://cdn.bootcdn.net/ajax/libs/bootstrap/5.1.3/js/bootstrap.bundle.min.js"></script> <script> document.querySelectorAll('.save-btn').forEach(btn => { btn.addEventListener('click', async function() { const num = this.dataset.num; const wc_sl = this.closest('tr').querySelector('.complete-input').value; try { const response = await fetch('update.php', { method: 'POST', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify({ num, wc_sl }) }); const result = await response.json(); if(result.success) { alert('保存成功！'); location.reload(); } else { alert('保存失败：' + result.message); } } catch(error) { console.error('Error:', error); } }); }); </script> </body> </html>
-
悬停隐藏URL <a href="javascript:void(0);" onclick="redirectTo('https://example.com')">隐藏URL的链接</a> <script> function redirectTo(url) { window.location.href = url; } </script> 示例try { if (item.isHeader == "1") { str = "<li class='menu-header'>" + item.name + "</li>"; $(parent).append(str); if (item.childMenus != "") { initMenu(item.childMenus, parent); } } else { item.icon == "" ? item.icon = "" : item.icon = item.icon; if (item.childMenus == "") { // 修改普通菜单项的href为JavaScript伪协议，并用data-url存储真实地址 str = `<li><a href="javascript:void(0)" data-url="${item.url}"><i class='icon-font'>${item.icon}</i><span>${item.name}</span></a></li>`; $(parent).append(str); } else { // 父级菜单项移除真实href，保留点击功能用于展开 str = `<li><a href="javascript:void(0)"><i class='icon-font'>${item.icon}</i><span>${item.name}</span><i class='icon-font icon-right'></i></a> <ul class='menu-item-child' id='menu-child-${item.id}'></ul></li>`; $(parent).append(str); var childParent = $("#menu-child-" + item.id); initMenu(item.childMenus, childParent); } } } catch (e) { console.error(e); } // 在文档加载后绑定点击事件（放在代码末尾或单独脚本中） $(function() { // 普通菜单跳转逻辑 $('body').on('click', 'a[data-url]', function(e) { e.preventDefault(); window.location.href = $(this).data('url'); }); // 子菜单展开逻辑（根据现有功能补充，示例如下） $('body').on('click', 'li > a:has(+ .menu-item-child)', function(e) { e.preventDefault(); $(this).next('.menu-item-child').slideToggle(); }); });
-
-
批量更新SQL语句 $placeholders = implode(',', array_fill(0, count($receivedOrderNumbers), '?')); $sql = "UPDATE orders SET zt = CASE WHEN order_number IN ($placeholders) THEN 'open' ELSE 'close' END"; 快速模式 回答完成 这段代码的目的是生成一个 UPDATE SQL 查询，根据 order_number 的值动态更新 zt 字段为 'open' 或 'close'。以下是代码的详细解析和注意事项： 代码解析： $placeholders = implode(',', array_fill(0, count($receivedOrderNumbers), '?')): 生成一个包含 ? 占位符的字符串，占位符的数量与 $receivedOrderNumbers 数组的长度一致。 例如，如果 $receivedOrderNumbers 有 3 个元素，$placeholders 的值将是 '?,?,?'。 $sql = "UPDATE orders SET zt = CASE WHEN order_number IN ($placeholders) THEN 'open' ELSE 'close' END": 构建一个 UPDATE 查询，使用 CASE 语句动态更新 zt 字段。 如果 order_number 在 $receivedOrderNumbers 中，则将 zt 设置为 'open'，否则设置为 'close'。 生成的 SQL 示例： 假设 $receivedOrderNumbers 是 [101, 102, 103]，生成的 SQL 查询将是： sql Copy Code UPDATE orders SET zt = CASE WHEN order_number IN (?, ?, ?) THEN 'open' ELSE 'close' END 使用场景： 这段代码适用于批量更新数据库中某个字段的值，根据条件动态设置不同的值。例如： 将特定订单的状态更新为 'open'，其他订单的状态更新为 'close'。 注意事项： 参数绑定： 使用 ? 占位符时，必须将 $receivedOrderNumbers 的值作为参数绑定到查询中，以避免 SQL 注入风险。 示例（使用 PDO）： php Copy Code $stmt = $pdo->prepare($sql); $stmt->execute($receivedOrderNumbers); ELSE 的作用： 如果没有 ELSE，所有不满足 WHEN 条件的记录将不会被更新。 如果希望未匹配的记录保持原值，可以移除 ELSE 'close'。 性能问题： 如果 $receivedOrderNumbers 包含大量元素，生成的 SQL 可能会很长，影响性能。 可以考虑分批更新或优化查询逻辑。 改进建议： 如果只需要更新匹配的记录，可以简化查询： php Copy Code $placeholders = implode(',', array_fill(0, count($receivedOrderNumbers), '?')); $sql = "UPDATE orders SET zt = 'open' WHERE order_number IN ($placeholders)"; 这样只会更新 order_number 在 $receivedOrderNumbers 中的记录，其他记录不会被修改。
0:00