order-period-adjust-range.php 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390
  1. <?php
  2. declare(strict_types=1);
  3. date_default_timezone_set('Africa/Lagos');
  4. set_time_limit(0);
  5. require __DIR__ . '/../../../vendor/autoload.php';
  6. require __DIR__ . '/../../../vendor/yiisoft/yii2/Yii.php';
  7. require __DIR__ . '/../../../common/config/bootstrap.php';
  8. require __DIR__ . '/../../config/bootstrap.php';
  9. $config = yii\helpers\ArrayHelper::merge(
  10. require __DIR__ . '/../../../common/config/main.php',
  11. require __DIR__ . '/../config/main.php'
  12. );
  13. $app = new \yii\web\Application($config);
  14. $defaults = [
  15. 'start_time' => date('Y-m-01 00:00:00'),
  16. 'end_time' => date('Y-m-d H:i:s'),
  17. 'period_num' => (string)((new \common\models\Period())->getNowPeriodNum()),
  18. 'operate_user' => 'admin_dba',
  19. ];
  20. $result = null;
  21. $errors = [];
  22. $submitted = false;
  23. if (\Yii::$app->request->isPost) {
  24. $submitted = true;
  25. $formModel = new \common\models\forms\OrderPeriodAdjustRangeForm();
  26. $formModel->scenario = 'orderPeriodAdjustRange';
  27. if ($formModel->load(\Yii::$app->request->post(), '') && ($result = $formModel->periodAdjustRange())) {
  28. // success
  29. } else {
  30. $errors = $formModel->getErrors();
  31. if (!$errors && $formModel->orders === []) {
  32. $errors = ['form' => ['No result returned from execution.']];
  33. }
  34. }
  35. } else {
  36. $formModel = new \common\models\forms\OrderPeriodAdjustRangeForm();
  37. $formModel->start_time = $defaults['start_time'];
  38. $formModel->end_time = $defaults['end_time'];
  39. $formModel->period_num = $defaults['period_num'];
  40. $formModel->operate_user = $defaults['operate_user'];
  41. }
  42. function e($value): string
  43. {
  44. return htmlspecialchars((string)$value, ENT_QUOTES, 'UTF-8');
  45. }
  46. function renderList(array $items): string
  47. {
  48. if (!$items) {
  49. return '<div class="muted">None</div>';
  50. }
  51. $html = '<ul class="list">';
  52. foreach ($items as $item) {
  53. $html .= '<li>' . e($item) . '</li>';
  54. }
  55. $html .= '</ul>';
  56. return $html;
  57. }
  58. function renderErrorMap(array $errorMap): string
  59. {
  60. if (!$errorMap) {
  61. return '<div class="muted">None</div>';
  62. }
  63. $html = '<div class="error-map">';
  64. foreach ($errorMap as $orderSn => $messages) {
  65. $html .= '<div class="error-item">';
  66. $html .= '<div><strong>' . e($orderSn) . '</strong></div>';
  67. foreach ((array)$messages as $field => $messageList) {
  68. $html .= '<div class="muted">' . e($field) . ': ' . e(is_array($messageList) ? implode('; ', $messageList) : $messageList) . '</div>';
  69. }
  70. $html .= '</div>';
  71. }
  72. $html .= '</div>';
  73. return $html;
  74. }
  75. ?>
  76. <!doctype html>
  77. <html lang="zh-CN">
  78. <head>
  79. <meta charset="utf-8">
  80. <meta name="viewport" content="width=device-width, initial-scale=1">
  81. <title>Order Period Adjust Range Tool</title>
  82. <style>
  83. :root {
  84. --bg: #f3f5f7;
  85. --card: #ffffff;
  86. --text: #1f2937;
  87. --muted: #6b7280;
  88. --accent: #2563eb;
  89. --accent-soft: #dbeafe;
  90. --danger: #b91c1c;
  91. --success: #15803d;
  92. --border: #e5e7eb;
  93. }
  94. body {
  95. margin: 0;
  96. font-family: -apple-system, BlinkMacSystemFont, "Segoe UI", Arial, sans-serif;
  97. background: linear-gradient(180deg, #eef2ff 0%, var(--bg) 40%, #f8fafc 100%);
  98. color: var(--text);
  99. }
  100. .wrap {
  101. max-width: 1120px;
  102. margin: 0 auto;
  103. padding: 28px 18px 48px;
  104. }
  105. .hero {
  106. margin-bottom: 18px;
  107. padding: 20px 22px;
  108. background: rgba(255,255,255,.86);
  109. border: 1px solid rgba(148,163,184,.2);
  110. border-radius: 18px;
  111. box-shadow: 0 10px 30px rgba(15,23,42,.08);
  112. }
  113. .hero h1 {
  114. margin: 0 0 8px;
  115. font-size: 26px;
  116. }
  117. .hero p {
  118. margin: 6px 0;
  119. color: var(--muted);
  120. line-height: 1.6;
  121. }
  122. .grid {
  123. display: grid;
  124. grid-template-columns: 1.2fr .8fr;
  125. gap: 18px;
  126. }
  127. .card {
  128. background: var(--card);
  129. border: 1px solid var(--border);
  130. border-radius: 18px;
  131. box-shadow: 0 10px 30px rgba(15,23,42,.06);
  132. overflow: hidden;
  133. }
  134. .card h2 {
  135. margin: 0;
  136. padding: 16px 18px;
  137. border-bottom: 1px solid var(--border);
  138. font-size: 18px;
  139. }
  140. .card-body {
  141. padding: 18px;
  142. }
  143. .field {
  144. margin-bottom: 14px;
  145. }
  146. .field label {
  147. display: block;
  148. margin-bottom: 6px;
  149. font-weight: 600;
  150. font-size: 14px;
  151. }
  152. .field input {
  153. width: 100%;
  154. box-sizing: border-box;
  155. padding: 11px 12px;
  156. border: 1px solid var(--border);
  157. border-radius: 12px;
  158. font-size: 14px;
  159. outline: none;
  160. }
  161. .field input:focus {
  162. border-color: var(--accent);
  163. box-shadow: 0 0 0 3px var(--accent-soft);
  164. }
  165. .btn {
  166. display: inline-flex;
  167. align-items: center;
  168. justify-content: center;
  169. padding: 11px 16px;
  170. border: none;
  171. border-radius: 12px;
  172. background: var(--accent);
  173. color: #fff;
  174. font-weight: 700;
  175. cursor: pointer;
  176. }
  177. .btn:hover {
  178. opacity: .95;
  179. }
  180. .summary {
  181. display: grid;
  182. grid-template-columns: repeat(4, minmax(0, 1fr));
  183. gap: 10px;
  184. margin-bottom: 14px;
  185. }
  186. .stat {
  187. border: 1px solid var(--border);
  188. border-radius: 14px;
  189. padding: 12px 14px;
  190. background: #fafafa;
  191. }
  192. .stat .label {
  193. color: var(--muted);
  194. font-size: 12px;
  195. margin-bottom: 6px;
  196. }
  197. .stat .value {
  198. font-size: 18px;
  199. font-weight: 700;
  200. }
  201. .muted {
  202. color: var(--muted);
  203. }
  204. .section {
  205. margin-bottom: 16px;
  206. padding-bottom: 16px;
  207. border-bottom: 1px dashed var(--border);
  208. }
  209. .section:last-child {
  210. margin-bottom: 0;
  211. padding-bottom: 0;
  212. border-bottom: 0;
  213. }
  214. .badge {
  215. display: inline-block;
  216. margin-left: 8px;
  217. padding: 2px 8px;
  218. border-radius: 999px;
  219. background: var(--accent-soft);
  220. color: var(--accent);
  221. font-size: 12px;
  222. font-weight: 700;
  223. }
  224. .success {
  225. color: var(--success);
  226. }
  227. .danger {
  228. color: var(--danger);
  229. }
  230. .list {
  231. margin: 8px 0 0;
  232. padding-left: 18px;
  233. }
  234. .error-map .error-item {
  235. margin-top: 10px;
  236. padding: 10px 12px;
  237. border: 1px solid #fee2e2;
  238. background: #fffafa;
  239. border-radius: 12px;
  240. }
  241. pre {
  242. margin: 0;
  243. padding: 14px;
  244. overflow: auto;
  245. background: #0f172a;
  246. color: #e2e8f0;
  247. border-radius: 14px;
  248. font-size: 12px;
  249. line-height: 1.6;
  250. }
  251. @media (max-width: 900px) {
  252. .grid, .summary {
  253. grid-template-columns: 1fr;
  254. }
  255. }
  256. </style>
  257. </head>
  258. <body>
  259. <div class="wrap">
  260. <div class="hero">
  261. <h1>Order Period Adjust Range Tool</h1>
  262. <p>Use this page to batch adjust orders by <code>start_time</code>, <code>end_time</code>, <code>period_num</code> and <code>operate_user</code>.</p>
  263. <p>Time zone: Africa/Lagos. The result panel shows successful, failed and skipped order numbers after execution.</p>
  264. </div>
  265. <div class="grid">
  266. <div class="card">
  267. <h2>Execution Form</h2>
  268. <div class="card-body">
  269. <form method="post">
  270. <div class="field">
  271. <label for="start_time">start_time</label>
  272. <input id="start_time" name="start_time" value="<?= e($formModel->start_time ?? $defaults['start_time']) ?>">
  273. </div>
  274. <div class="field">
  275. <label for="end_time">end_time</label>
  276. <input id="end_time" name="end_time" value="<?= e($formModel->end_time ?? $defaults['end_time']) ?>">
  277. </div>
  278. <div class="field">
  279. <label for="period_num">period_num</label>
  280. <input id="period_num" name="period_num" value="<?= e($formModel->period_num ?? $defaults['period_num']) ?>">
  281. </div>
  282. <div class="field">
  283. <label for="operate_user">operate_user</label>
  284. <input id="operate_user" name="operate_user" value="<?= e($formModel->operate_user ?? $defaults['operate_user']) ?>">
  285. </div>
  286. <button class="btn" type="submit">Execute</button>
  287. </form>
  288. </div>
  289. </div>
  290. <div class="card">
  291. <h2>Configuration</h2>
  292. <div class="card-body">
  293. <div class="section">
  294. <div class="muted">Default start_time</div>
  295. <div><?= e($defaults['start_time']) ?></div>
  296. </div>
  297. <div class="section">
  298. <div class="muted">Default end_time</div>
  299. <div><?= e($defaults['end_time']) ?></div>
  300. </div>
  301. <div class="section">
  302. <div class="muted">Default period_num</div>
  303. <div><?= e($defaults['period_num']) ?></div>
  304. </div>
  305. <div class="section">
  306. <div class="muted">Default operate_user</div>
  307. <div><?= e($defaults['operate_user']) ?></div>
  308. </div>
  309. </div>
  310. </div>
  311. </div>
  312. <?php if ($submitted): ?>
  313. <div class="card" style="margin-top: 18px;">
  314. <h2>Execution Result</h2>
  315. <div class="card-body">
  316. <?php if ($result): ?>
  317. <div class="summary">
  318. <div class="stat">
  319. <div class="label">Total</div>
  320. <div class="value"><?= e($result['total_count'] ?? 0) ?></div>
  321. </div>
  322. <div class="stat">
  323. <div class="label success">Success</div>
  324. <div class="value success"><?= e($result['success_count'] ?? 0) ?></div>
  325. </div>
  326. <div class="stat">
  327. <div class="label danger">Failed</div>
  328. <div class="value danger"><?= e($result['failed_count'] ?? 0) ?></div>
  329. </div>
  330. <div class="stat">
  331. <div class="label">Skipped</div>
  332. <div class="value"><?= e($result['skipped_count'] ?? 0) ?></div>
  333. </div>
  334. </div>
  335. <div class="section">
  336. <div><strong>Success order numbers</strong><span class="badge"><?= e($result['success_count'] ?? 0) ?></span></div>
  337. <?= renderList($result['success_order_sn_list'] ?? []) ?>
  338. </div>
  339. <div class="section">
  340. <div><strong>Failed order numbers</strong><span class="badge"><?= e($result['failed_count'] ?? 0) ?></span></div>
  341. <?= renderList($result['failed_order_sn_list'] ?? []) ?>
  342. <div style="margin-top: 12px;">
  343. <strong>Failure details</strong>
  344. <?= renderErrorMap($result['failed_detail_map'] ?? []) ?>
  345. </div>
  346. </div>
  347. <div class="section">
  348. <div><strong>Skipped order numbers</strong><span class="badge"><?= e($result['skipped_count'] ?? 0) ?></span></div>
  349. <?= renderList($result['skipped_order_sn_list'] ?? []) ?>
  350. </div>
  351. <div class="section">
  352. <div><strong>Raw payload</strong></div>
  353. <pre><?= e(json_encode($result, JSON_UNESCAPED_UNICODE | JSON_PRETTY_PRINT)) ?></pre>
  354. </div>
  355. <?php else: ?>
  356. <div class="danger"><strong>Execution failed.</strong></div>
  357. <?php if ($errors): ?>
  358. <div style="margin-top: 12px;">
  359. <strong>Validation errors</strong>
  360. <pre><?= e(json_encode($errors, JSON_UNESCAPED_UNICODE | JSON_PRETTY_PRINT)) ?></pre>
  361. </div>
  362. <?php endif; ?>
  363. <?php endif; ?>
  364. </div>
  365. </div>
  366. <?php endif; ?>
  367. </div>
  368. </body>
  369. </html>