{"id":1,"date":"2025-10-24T15:33:46","date_gmt":"2025-10-24T07:33:46","guid":{"rendered":"http:\/\/wiki.tengwangyun.com\/?p=1"},"modified":"2026-04-09T14:05:54","modified_gmt":"2026-04-09T06:05:54","slug":"hello-world","status":"publish","type":"post","link":"https:\/\/wiki.tengwangyun.com\/?p=1","title":{"rendered":"\u667a\u9020\u7cfb\u7edf\u5e38\u89c1\u64cd\u4f5c\u95ee\u9898\u6c47\u603b"},"content":{"rendered":"\n

1\u3001\u7ba1\u7406\u5458\u8d26\u53f7\u6743\u9650\u4e3a\u7a7a\uff0c\u793a\u4f8b\u5982\u4e0b\uff1a<\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

\u89e3\u51b3\uff1a<\/p>\n\n\n\n

1\u3001\u7528\u53e6\u4e00\u4e2a\u6709\u6743\u7684\u7684\u8d26\u53f7\u5206\u914d\uff1b<\/p>\n\n\n\n

2\u3001\u6216\u8005\u627e\u5f00\u53d1\u4ece\u6570\u636e\u5e93\u6dfb\u52a0\uff1a\u8868\u540d\uff1amodel_has_roles\uff0c\u5982\u4e0b\u63d2\u5165\u4e00\u6761\u6570\u636e\uff1a<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n\n\n\n\n

2\u3001\u91c7\u8d2d\u6a21\u5757\u5173\u8054\u5220\u9664\u6570\u636e<\/h2>\n\n\n\n

1\u3001\u901a\u8fc7\u8ba2\u5355\u53f7\uff1a<\/p>\n\n\n\n

php artisan test — filter=”test_batch_delete_by_supply_serial_code$”
2\u3001\u901a\u8fc7\u8ba2\u5355\u521b\u5efa\u65f6\u95f4\uff1a<\/p>\n\n\n\n

php artisan test –filter=”test_batch_delete_supply_order_data_by_date$”<\/p>\n\n\n\n

\u793a\u4f8b\u56fe\u7247\uff1a<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u4ee3\u7801\u8d44\u6599\uff1a\u5982\u672c\u5730\u6ca1\u6709\u5219\u65b0\u5efa\u5230\u672c\u5730\u6587\u4ef6\u9879\u76ee\u91cc\u9762\uff1a<\/p>\n\n\n\n

<?php\nnamespace Tests\\Unit;\nuse Illuminate\\Support\\Facades\\DB;\nuse Illuminate\\Support\\Facades\\Log;\nuse Tests\\TestCase;\n\nclass DeleteSupplyOrderDataTest extends TestCase\n{\n    \n    public function test_delete_supply_order_data(array $orderIds = [], bool $dryRun = true, bool $deleteOrders = false, string $source = ''){\n   if (empty($orderIds)) {\n        $this->outputInfo(\"\u6ca1\u6709\u627e\u5230\u9700\u8981\u5220\u9664\u7684\u8ba2\u5355\");\n        return;\n    }\n\n    $orderIdsStr = implode(',', $orderIds);\n    $this->outputInfo(\"\u627e\u5230 \" . count($orderIds) . \" \u4e2a\u8ba2\u5355\uff0cID: {$orderIdsStr}\");\n\n    if ($dryRun) {\n        $this->outputInfo(\"\u3010\u9884\u89c8\u6a21\u5f0f\u3011\u4ee5\u4e0b\u4e3a\u5c06\u8981\u5220\u9664\u7684\u6570\u636e\uff1a\");\n        $this->showAffectedData($orderIds, $deleteOrders);\n        return;\n    }\n\n    $this->outputWarning(\"\u8b66\u544a\uff1a\u6b64\u64cd\u4f5c\u5c06\u6c38\u4e45\u5220\u9664\u76f8\u5173\u6570\u636e\uff0c\u65e0\u6cd5\u6062\u590d\uff01\");\n    if ($deleteOrders) {\n        $this->outputWarning(\"\u26a0\ufe0f  \u5c06\u5220\u9664\u91c7\u8d2d\u8ba2\u5355\u4e3b\u8868\u6570\u636e\uff01\");\n    }\n\n    try {\n       DB::beginTransaction();\n       $this->outputInfo(\"\u5f00\u59cb\u5220\u9664\u6570\u636e...\");\n\n       \/\/ \u6267\u884c\u5220\u9664\u64cd\u4f5c\n       $this->deleteSupplyOrderData($orderIds, $deleteOrders);\n       DB::commit();\n       $this->outputSuccess(\"\u5220\u9664\u64cd\u4f5c\u5b8c\u6210\uff01\");\n       $logMessage = \"\u5220\u9664\u91c7\u8d2d\u8ba2\u5355\u6570\u636e\u547d\u4ee4\u6267\u884c\u6210\u529f\uff0c\u5220\u9664\u8ba2\u5355ID: {$orderIdsStr}\";\n        if (!empty($source)) {\n            $logMessage .= \" (\u6765\u6e90: {$source})\";\n        }\n        Log::info($logMessage);\n\n    } catch (\\Exception $e) {\n        DB::rollBack();\n        $this->outputError(\"\u64cd\u4f5c\u5931\u8d25\uff1a\" . $e->getMessage());\n        Log::error(\"\u5220\u9664\u91c7\u8d2d\u8ba2\u5355\u6570\u636e\u547d\u4ee4\u6267\u884c\u5931\u8d25\uff1a\" . $e->getMessage());\n    }\n}\n\n    \/**\n     * \u901a\u8fc7\u65e5\u671f\u83b7\u53d6\u8ba2\u5355ID\u5e76\u5220\u9664\u6570\u636e\n     * @param string $date \u5220\u9664\u8be5\u65e5\u671f\u4e4b\u540e\u7684\u6570\u636e\uff0c\u683c\u5f0f\uff1aYYYY-MM-DD\n     * @param bool $dryRun \u662f\u5426\u9884\u89c8\u6a21\u5f0f\uff0c\u53ea\u663e\u793a\u4e0d\u5b9e\u9645\u5220\u9664\n     * @param bool $deleteOrders \u662f\u5426\u5220\u9664\u91c7\u8d2d\u8ba2\u5355\u4e3b\u8868\u6570\u636e\n     *\/\n    public function test_delete_supply_order_data_by_date($date = '2025-10-01', $dryRun = true, $deleteOrders = false){\n    $startDate = $date . ' 00:00:00';\n    $this->outputInfo(\"\u5f00\u59cb\u67e5\u8be2 {$startDate} \u4e4b\u540e\u521b\u5efa\u7684\u8ba2\u5355...\");\n\n        \/\/ \u67e5\u8be2\u9700\u8981\u5220\u9664\u7684\u8ba2\u5355ID\n    $orderIds = DB::table('supply_orders')\n        ->where('created_at', '>=', $startDate)\n        ->pluck('id')\n        ->toArray();\n\n    $this->test_delete_supply_order_data($orderIds, $dryRun, $deleteOrders, \"\u65e5\u671f: {$startDate}\");\n}\n\n    \/**\n     * \u901a\u8fc7\u8ba2\u5355\u7f16\u53f7\u83b7\u53d6\u8ba2\u5355ID\u5e76\u5220\u9664\u6570\u636e\n     *\n     * @param string|array $serialCodes \u8ba2\u5355\u7f16\u53f7\u6216\u7f16\u53f7\u6570\u7ec4\n     * @param bool $dryRun \u662f\u5426\u9884\u89c8\u6a21\u5f0f\uff0c\u53ea\u663e\u793a\u4e0d\u5b9e\u9645\u5220\u9664\n     * @param bool $deleteOrders \u662f\u5426\u5220\u9664\u91c7\u8d2d\u8ba2\u5355\u4e3b\u8868\u6570\u636e\n     *\/\n    public function test_delete_supply_order_data_by_serial_code($serialCodes = [], $dryRun = true, $deleteOrders = false){\n    \/\/ \u652f\u6301\u5b57\u7b26\u4e32\u6216\u6570\u7ec4\u683c\u5f0f\u7684\u8ba2\u5355\u7f16\u53f7\n    if (is_string($serialCodes)) {\n        $serialCodes = [$serialCodes];\n    }\n\n    if (empty($serialCodes)) {\n        \/\/ \u5982\u679c\u6ca1\u6709\u63d0\u4f9b\u8ba2\u5355\u7f16\u53f7\uff0c\u4f7f\u7528\u9ed8\u8ba4\u7684\u6d4b\u8bd5\u6570\u636e\n        $serialCodes = ['PO20250001', 'PO20250002', 'PO20250003'];\n        $this->outputInfo(\"\u4f7f\u7528\u9ed8\u8ba4\u6d4b\u8bd5\u8ba2\u5355\u7f16\u53f7: \" . implode(', ', $serialCodes));\n    }\n\n    $this->outputInfo(\"\u5f00\u59cb\u67e5\u8be2\u8ba2\u5355\u7f16\u53f7\u4e3a [\" . implode(', ', $serialCodes) . \"] \u7684\u8ba2\u5355...\");\n\n    \/\/ \u67e5\u8be2\u9700\u8981\u5220\u9664\u7684\u8ba2\u5355ID\n    $orderIds = DB::table('supply_orders')\n        ->whereIn('serial_code', $serialCodes)\n        ->pluck('id')\n        ->toArray();\n\n    $this->test_delete_supply_order_data($orderIds, $dryRun, $deleteOrders, \"\u8ba2\u5355\u7f16\u53f7: \" . implode(', ', $serialCodes));\n    }\n\n    \/**\n     * \u901a\u8fc7\u8ba2\u5355ID\u76f4\u63a5\u5220\u9664\u6570\u636e\n     *\n     * @param string|array $orderIds \u8ba2\u5355ID\u6216ID\u6570\u7ec4\n     * @param bool $dryRun \u662f\u5426\u9884\u89c8\u6a21\u5f0f\uff0c\u53ea\u663e\u793a\u4e0d\u5b9e\u9645\u5220\u9664\n     * @param bool $deleteOrders \u662f\u5426\u5220\u9664\u91c7\u8d2d\u8ba2\u5355\u4e3b\u8868\u6570\u636e\n     *\/\n    public function test_delete_supply_order_data_by_ids($orderIds = [], $dryRun = true, $deleteOrders = false){\n    \/\/ \u652f\u6301\u5b57\u7b26\u4e32\u6216\u6570\u7ec4\u683c\u5f0f\u7684\u8ba2\u5355ID\n    if (is_string($orderIds)) {\n        $orderIds = array_map('intval', explode(',', $orderIds));\n    }\n\n    if (empty($orderIds)) {\n        \/\/ \u5982\u679c\u6ca1\u6709\u63d0\u4f9b\u8ba2\u5355ID\uff0c\u4f7f\u7528\u9ed8\u8ba4\u7684\u6d4b\u8bd5\u6570\u636e\n        $orderIds = [174, 175];\n        $this->outputInfo(\"\u4f7f\u7528\u9ed8\u8ba4\u6d4b\u8bd5\u8ba2\u5355ID: \" . implode(', ', $orderIds));\n    }\n\n    $this->outputInfo(\"\u5f00\u59cb\u5904\u7406\u8ba2\u5355ID: [\" . implode(', ', $orderIds) . \"]\");\n\n    $this->test_delete_supply_order_data($orderIds, $dryRun, $deleteOrders, \"\u8ba2\u5355ID: \" . implode(', ', $orderIds));\n}\n\n    \/**\n     * \u663e\u793a\u53d7\u5f71\u54cd\u7684\u6570\u636e\uff08\u9884\u89c8\u6a21\u5f0f\uff09\n     *\/\n    private function showAffectedData(array $orderIds, bool $deleteOrders = false){\n    $orderIdsStr = implode(',', $orderIds);\n    $this->outputInfo(\"\u5c06\u8981\u5220\u9664\u7684\u6570\u636e\u8868\uff08\u6309\u5220\u9664\u987a\u5e8f\uff09\uff1a\");\n\n    \/\/ \u6309\u7167\u5220\u9664\u987a\u5e8f\u663e\u793a\n    $tables = [\n        'invoice_received' => \"SELECT COUNT(*) as count FROM invoice_received WHERE id IN (SELECT bill_id FROM invoice_received_items WHERE supply_order_id IN ({$orderIdsStr}) GROUP BY bill_id)\",'invoice_received_items' => \"SELECT COUNT(*) as count FROM invoice_received_items WHERE supply_order_id IN ({$orderIdsStr})\",'payments' => \"SELECT COUNT(*) as count FROM payments WHERE id IN (SELECT bill_id FROM payment_items WHERE finance_stockin_id IN (SELECT id FROM finance_stockin_details WHERE order_id IN ({$orderIdsStr}) AND order_type_key = 1) GROUP BY bill_id)\",\n'payment_items' => \"SELECT COUNT(*) as count FROM payment_items WHERE finance_stockin_id IN (SELECT id FROM finance_stockin_details WHERE order_id IN ({$orderIdsStr}) AND order_type_key = 1)\",'supply_acccheck' => \"SELECT COUNT(*) as count FROM supply_acccheck WHERE id IN (SELECT bill_id FROM supply_acccheck_items WHERE finance_stockin_id IN (SELECT id FROM finance_stockin_details WHERE order_id IN ({$orderIdsStr}) AND order_type_key = 1) GROUP BY bill_id)\",\n'supply_acccheck_items' => \"SELECT COUNT(*) as count FROM supply_acccheck_items WHERE finance_stockin_id IN (SELECT id FROM finance_stockin_details WHERE order_id IN ({$orderIdsStr}) AND order_type_key = 1)\",'finance_stockin_details' => \"SELECT COUNT(*) as count FROM finance_stockin_details WHERE order_id IN ({$orderIdsStr}) AND order_type_key = 1\",'supply_stockin_items' => \"SELECT COUNT(*) as count FROM supply_stockin_items WHERE order_id IN ({$orderIdsStr})\",\n'supply_stockin' => \"SELECT COUNT(*) as count FROM supply_stockin WHERE ori_bill_id IN ({$orderIdsStr})\",\n'to_stockin_lists' => \"SELECT COUNT(*) as count FROM to_stockin_lists WHERE ori_bill_type = 'App\/Models\/SupplyOrder' AND ori_bill_id IN ({$orderIdsStr})\", 'qc_tasks' => \"SELECT COUNT(*) as count FROM qc_tasks WHERE scope = 'caigoulailiao' AND ori_bill_id IN ({$orderIdsStr})\",'supply_incoming_materials' => \"SELECT COUNT(*) as count FROM supply_incoming_materials WHERE id IN (SELECT bill_id FROM supply_incoming_material_items WHERE ori_bill_id IN ({$orderIdsStr}) GROUP BY bill_id)\",'supply_incoming_material_items' => \"SELECT COUNT(*) as count FROM supply_incoming_material_items WHERE ori_bill_id IN ({$orderIdsStr})\",'supply_order_items' => \"SELECT COUNT(*) as count FROM supply_order_items WHERE order_id IN ({$orderIdsStr})\",'supply_orders' => \"SELECT COUNT(*) as count FROM supply_orders WHERE id IN ({$orderIdsStr})\",];\n\n    \/\/ \u5982\u679c\u542f\u7528\u5220\u9664\u8ba2\u5355\u4e3b\u8868\uff0c\u6dfb\u52a0\u91c7\u8d2d\u8ba2\u5355\u8868\u7684\u7edf\u8ba1\n    if (!$deleteOrders) {\n        \/\/ \u5982\u679c\u4e0d\u5220\u9664\u8ba2\u5355\u4e3b\u8868\uff0c\u5219\u79fb\u9664\u91c7\u8d2d\u8ba2\u5355\u4e3b\u8868\u548c\u660e\u7ec6\u8868\u7684\u7edf\u8ba1\n        unset($tables['supply_order_items']);\n        unset($tables['supply_orders']);\n    }\n\n    $order = 1;\n    foreach ($tables as $tableName => $sql) {\n        try {\n            $count = DB::select($sql)[0]->count ?? 0;\n            $this->outputLine(\"   {$order}. \u8868 {$tableName}: {$count} \u6761\u8bb0\u5f55\");\n            $order++;\n        } catch (\\Exception $e) {\n            $this->outputError(\"   \u67e5\u8be2\u8868 {$tableName} \u5931\u8d25: \" . $e->getMessage());\n        }\n    }\n}\n\n    \/**\n     * \u6267\u884c\u5220\u9664\u64cd\u4f5c\uff08\u6309\u7167\u6307\u5b9a\u987a\u5e8f\uff09\n     *\/\n    private function deleteSupplyOrderData(array $orderIds, bool $deleteOrders = false){\n    $orderIdsStr = implode(',', $orderIds);\n    $step = 1;\n\n    $this->outputInfo(\"{$step}. \u5220\u9664\u91c7\u8d2d\u53d1\u7968\u4e3b\u8868...\");\n    DB::statement(\"DELETE FROM invoice_received WHERE id IN (SELECT bill_id FROM invoice_received_items WHERE supply_order_id IN ({$orderIdsStr}) GROUP BY bill_id)\");\n    $step++;\n\n    $this->outputInfo(\"{$step}. \u5220\u9664\u91c7\u8d2d\u53d1\u7968\u660e\u7ec6...\");\n    DB::statement(\"DELETE FROM invoice_received_items WHERE supply_order_id IN ({$orderIdsStr})\");\n    $step++;\n\n    $this->outputInfo(\"{$step}. \u5220\u9664\u4ed8\u6b3e\u4e3b\u8868...\");\n    DB::statement(\"DELETE FROM payments WHERE id IN (SELECT bill_id FROM payment_items WHERE finance_stockin_id IN (SELECT id FROM finance_stockin_details WHERE order_id IN ({$orderIdsStr}) AND order_type_key = 1) GROUP BY bill_id)\");\n    $step++;\n\n    $this->outputInfo(\"{$step}. \u5220\u9664\u4ed8\u6b3e\u660e\u7ec6...\");\n    DB::statement(\"DELETE FROM payment_items WHERE finance_stockin_id IN (SELECT id FROM finance_stockin_details WHERE order_id IN ({$orderIdsStr}) AND order_type_key = 1)\");\n    $step++;\n\n    $this->outputInfo(\"{$step}. \u5220\u9664\u91c7\u8d2d\u5bf9\u8d26\u4e3b\u8868...\");\n    DB::statement(\"DELETE FROM supply_acccheck WHERE id IN (SELECT bill_id FROM supply_acccheck_items WHERE finance_stockin_id IN (SELECT id FROM finance_stockin_details WHERE order_id IN ({$orderIdsStr}) AND order_type_key = 1) GROUP BY bill_id)\");\n    $step++;\n\n    $this->outputInfo(\"{$step}. \u5220\u9664\u91c7\u8d2d\u5bf9\u8d26\u660e\u7ec6...\");\n    DB::statement(\"DELETE FROM supply_acccheck_items WHERE finance_stockin_id IN (SELECT id FROM finance_stockin_details WHERE order_id IN ({$orderIdsStr}) AND order_type_key = 1)\");\n    $step++;\n\n    $this->outputInfo(\"{$step}. \u5220\u9664\u8d22\u52a1\u5165\u5e93\u660e\u7ec6...\");\n    DB::statement(\"DELETE FROM finance_stockin_details WHERE order_id IN ({$orderIdsStr}) AND order_type_key = 1\");\n    $step++;\n\n    $this->outputInfo(\"{$step}. \u5220\u9664\u91c7\u8d2d\u5165\u5e93\u660e\u7ec6...\");\n    DB::statement(\"DELETE FROM supply_stockin_items WHERE order_id IN ({$orderIdsStr})\");\n    $step++;\n\n    $this->outputInfo(\"{$step}. \u5220\u9664\u91c7\u8d2d\u5165\u5e93\u4e3b\u8868...\");\n    DB::statement(\"DELETE FROM supply_stockin WHERE ori_bill_id IN ({$orderIdsStr})\");\n    $step++;\n\n    $this->outputInfo(\"{$step}. \u5220\u9664\u5f85\u5165\u5e93\u5217\u8868...\");\n    DB::statement(\"DELETE FROM to_stockin_lists WHERE ori_bill_type = 'App\/Models\/SupplyOrder' AND ori_bill_id IN ({$orderIdsStr})\");\n    $step++;\n\n    $this->outputInfo(\"{$step}. \u5220\u9664\u91c7\u8d2d\u6765\u6599\u8d28\u68c0\u4efb\u52a1...\");\n    DB::statement(\"DELETE FROM qc_tasks WHERE scope = 'caigoulailiao' AND ori_bill_id IN ({$orderIdsStr})\");\n    $step++;\n\n    $this->outputInfo(\"{$step}. \u5220\u9664\u91c7\u8d2d\u6765\u6599\u4e3b\u8868...\");\n    DB::statement(\"DELETE FROM supply_incoming_materials WHERE id IN (SELECT bill_id FROM supply_incoming_material_items WHERE ori_bill_id IN ({$orderIdsStr}) GROUP BY bill_id)\");\n    $step++;\n\n    $this->outputInfo(\"{$step}. \u5220\u9664\u91c7\u8d2d\u6765\u6599\u660e\u7ec6...\");\n    DB::statement(\"DELETE FROM supply_incoming_material_items WHERE ori_bill_id IN ({$orderIdsStr})\");\n    $step++;\n\n    \/\/ \u6700\u540e\u5220\u9664\u91c7\u8d2d\u8ba2\u5355\u8868\u6570\u636e\uff08\u5982\u679c\u542f\u7528\uff09\n    if ($deleteOrders) {\n        $this->outputInfo(\"{$step}. \u5220\u9664\u91c7\u8d2d\u8ba2\u5355\u660e\u7ec6\u8868...\");\n        DB::statement(\"DELETE FROM supply_order_items WHERE order_id IN ({$orderIdsStr})\");\n        $step++;\n\n        $this->outputInfo(\"{$step}. \u5220\u9664\u91c7\u8d2d\u8ba2\u5355\u4e3b\u8868...\");\n        DB::statement(\"DELETE FROM supply_orders WHERE id IN ({$orderIdsStr})\");\n        $step++;\n    }\n\n    $this->outputSuccess(\"\u6240\u6709\u64cd\u4f5c\u5b8c\u6210\uff01\u5171\u6267\u884c {$step} \u4e2a\u6b65\u9aa4\");\n}\n\n    \/**\n     * \u6279\u91cf\u5220\u9664\u6d4b\u8bd5 - \u901a\u8fc7\u65e5\u671f\n     *\/\n    public function test_batch_delete_supply_order_data_by_date(){\n    \/\/ \u53ef\u4ee5\u901a\u8fc7\u73af\u5883\u53d8\u91cf\u8bbe\u7f6e\u65e5\u671f\u548c\u6570\u91cf\n    $startDate = $_ENV['DELETE_SUPPLY_START_DATE'] ?? '2025-08-01';\n    \/\/ \u662f\u5426\u9884\u89c8\u6a21\u5f0f\uff0c\u53ea\u663e\u793a\u4e0d\u5b9e\u9645\u5220\u9664\n    $dryRun = $_ENV['DELETE_SUPPLY_DRY_RUN'] ?? false;\n    \/\/ \u662f\u5426\u5220\u9664\u8ba2\u5355\u8868\u6570\u636e\uff08\u9ed8\u8ba4 false\uff09\n    $deleteOrders = $_ENV['DELETE_SUPPLY_ORDERS'] ?? true;\n\n    $this->test_delete_supply_order_data_by_date($startDate, $dryRun, $deleteOrders);\n}\n\n    \/**\n     * \u6279\u91cf\u5220\u9664\u6d4b\u8bd5 - \u901a\u8fc7\u8ba2\u5355\u7f16\u53f7\n     *\/\n    public function test_batch_delete_by_supply_serial_code(){\n    \/\/ \u662f\u5426\u9884\u89c8\u6a21\u5f0f\uff0c\u53ea\u663e\u793a\u4e0d\u5b9e\u9645\u5220\u9664\n    $dryRun = $_ENV['DELETE_SUPPLY_DRY_RUN'] ?? false;\n    \/\/ \u662f\u5426\u5220\u9664\u8ba2\u5355\u8868\u6570\u636e\uff08\u9ed8\u8ba4 false\uff09\n    $deleteOrders = $_ENV['DELETE_SUPPLY_ORDERS'] ?? false;\n\n    $serialCodes = 'SO251001001,SO251002001,SO251001002,SO251002002,SO251001003,SO251002003';\n    \/\/ \u5c06\u9017\u53f7\u5206\u9694\u7684\u8ba2\u5355\u7f16\u53f7\u8f6c\u6362\u4e3a\u6570\u7ec4\n    $serialCodeArray = [];\n    if (!empty($serialCodes)) {\n        $serialCodeArray = array_map('trim', explode(',', $serialCodes));\n    }\n\n    $this->test_delete_supply_order_data_by_serial_code($serialCodeArray, $dryRun, $deleteOrders);\n}\n\n    \/**\n     * \u6279\u91cf\u5220\u9664\u6d4b\u8bd5 - \u901a\u8fc7\u8ba2\u5355ID\n     *\/\npublic function test_batch_delete_by_supply_ids(){\n    \/\/ \u53ef\u4ee5\u901a\u8fc7\u73af\u5883\u53d8\u91cf\u8bbe\u7f6e\u8ba2\u5355ID\u548c\u5220\u9664\u9009\u9879\n    $orderIds = $_ENV['DELETE_SUPPLY_ORDER_IDS'] ?? '';\n    $dryRun = ($_ENV['DELETE_SUPPLY_DRY_RUN'] ?? 'true') === 'false';\n    $deleteOrders = ($_ENV['DELETE_SUPPLY_ORDERS'] ?? 'false') === 'true';\n\n    $this->test_delete_supply_order_data_by_ids($orderIds, $dryRun, $deleteOrders);\n}\n\n    \/**\n     * \u8f93\u51fa\u4fe1\u606f\uff08\u767d\u8272\uff09\n     *\/\nprivate function outputInfo(string $message){\n    echo \"\\033[0;37m[INFO] \" . $message . \"\\033[0m\" . PHP_EOL;\n}\n\n    \/**\n     * \u8f93\u51fa\u6210\u529f\u4fe1\u606f\uff08\u7eff\u8272\uff09\n     *\/\nprivate function outputSuccess(string $message){\n    echo \"\\033[0;32m[SUCCESS] \" . $message . \"\\033[0m\" . PHP_EOL;\n}\n\n    \/**\n     * \u8f93\u51fa\u8b66\u544a\u4fe1\u606f\uff08\u9ec4\u8272\uff09\n     *\/\nprivate function outputWarning(string $message){\n    echo \"\\033[1;33m[WARNING] \" . $message . \"\\033[0m\" . PHP_EOL;\n}\n\n    \/**\n     * \u8f93\u51fa\u9519\u8bef\u4fe1\u606f\uff08\u7ea2\u8272\uff09\n     *\/\nprivate function outputError(string $message){\n    echo \"\\033[0;31m[ERROR] \" . $message . \"\\033[0m\" . PHP_EOL;\n}\n\n    \/**\n     * \u8f93\u51fa\u666e\u901a\u884c\n     *\/\nprivate function outputLine(string $message){\n    echo $message . PHP_EOL;\n}\n}\n<\/code><\/pre>\n\n\n\n
<\/p>\n\n\n\n
3\u3001\u5ba1\u6279\u6d41\u4e2d\u6d41\u7a0b\u8282\u70b9\uff08\u5224\u65ad\u6761\u4ef6\uff09\u600e\u4e48\u8bbe\u7f6e\uff1f<\/p>\n\n\n\n
\u6761\u4ef6\u8868\u8fbe\u5f0f\u7684\u7f16\u5199:
        1.\u652f\u6301\u5b57\u6bb5: \u4ec5\u652f\u6301\u4e1a\u52a1\u5355\u636e\u4e3b\u8868\u4e2d\u5df2\u5b58\u5728\u7684\u5b57\u6bb5,\u5982\u201c\u5ba2\u6237\u6863\u6848\u201d\u8868\u4e2d\u7684id,name,company_id\u2026<\/p>\n\n\n\n
        2.\u652f\u6301\u7684\u6bd4\u8f83\u3001\u7b97\u672f\u8fd0\u7b97\u7b26+\uff0c-*\uff0c\/\uff0c%\uff0c=\uff0c!=\uff0c>\uff0c<\uff0c>=\uff0c<=<\/p>\n\n\n\n
        3.\u652f\u6301\u7684\u903b\u8f91\u8fd0\u7b97\u7b26:\u4e0e and \uff0c\u6216 or
        4.\u652f\u6301\u4f7f\u7528\u62ec\u53f7()\u5c06\u6761\u4ef6\u5206\u7ec4
        5.php\u5185\u7f6e\u51fd\u6570\u652f\u6301:php_is_nu11\uff0cphp_is_numeric \uff0c\u5206\u522b\u5bf9\u5e94php\u4e2d\u7684      is_null,is_numeric\u51fd\u6570\u3002\u6d89\u53ca\u5230\u4ee3\u7801\u5b89\u5168\uff0c\u6839\u636e\u5b9e\u9645\u9700\u6c42\u5f00\u653e\u3002<\/p>\n\n\n\n
\u7f51\u5173\u6761\u4ef6\u8868\u8fbe\u5f0f\u7f16\u5199\u793a\u4f8b:<\/p>\n\n\n\n
        (id >20 and name ==’test’)or parent id ==1<\/p>\n\n\n\n
        \u6b64\u8868\u8fbe\u5f0f\u6307:\u5355\u636eid\u5927\u4e8e20\u65e5name\u7b49\u4e8etest'\u6216\u8005<\/code>parent id \u7b49\u4e8e1’\u65f6 \u6ee1\u8db3\u6761\u4ef6<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
4\u3001\u914d\u7f6e\u597d\u4e86\u91c7\u8d2d\u5f85\u5165\u5e93\u7684\u5ba1\u6838\u6d88\u606f\u63d0\u9192\uff0c\u4f46\u662f\u6ca1\u6709\u53cd\u5e94\uff1f<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u89e3\u51b3\uff1a\u5f85\u529e\u9700\u670d\u52a1\u5668\u4e0a\u5f00\u542f\u961f\u5217<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
5\u3001\u62a5\u5de5\u7684\u8d28\u68c0\u5458\u80fd\u4e0d\u80fd\u6307\u5b9a\u4e00\u4e9b\u4eba\uff0c\u73b0\u5728\u4e00\u9009\u62e9\u4f1a\u51fa\u73b0\u6240\u6709\u4eba\u7684\u540d\u5b57\uff1f<\/p>\n\n\n\n
\u89e3\u51b3\uff1a\u9009\u62e9\u7528\u6237\u662f\u6839\u636e\u5f53\u524d\u8d26\u53f7\u7684\u7528\u6237\u6570\u636e\u8303\u56f4\u6743\u9650\u663e\u793a\u7684—–\u6570\u636e\u6743\u9650\uff1a\u672c\u4eba\uff0c\u672c\u90e8\u95e8…<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
1\u3001\u7ba1\u7406\u5458\u8d26\u53f7\u6743\u9650\u4e3a\u7a7a\uff0c\u793a\u4f8b\u5982\u4e0b\uff1a \u89e3\u51b3\uff1a 1\u3001\u7528\u53e6\u4e00\u4e2a\u6709\u6743\u7684\u7684\u8d26\u53f7\u5206\u914d\uff1b 2\u3001\u6216\u8005\u627e\u5f00\u53d1\u4ece\u6570\u636e\u5e93\u6dfb\u52a0\uff1a\u8868\u540d\uff1a […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-1","post","type-post","status-publish","format-standard","hentry","category-twy"],"_links":{"self":[{"href":"https:\/\/wiki.tengwangyun.com\/index.php?rest_route=\/wp\/v2\/posts\/1","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wiki.tengwangyun.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wiki.tengwangyun.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wiki.tengwangyun.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wiki.tengwangyun.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1"}],"version-history":[{"count":7,"href":"https:\/\/wiki.tengwangyun.com\/index.php?rest_route=\/wp\/v2\/posts\/1\/revisions"}],"predecessor-version":[{"id":129,"href":"https:\/\/wiki.tengwangyun.com\/index.php?rest_route=\/wp\/v2\/posts\/1\/revisions\/129"}],"wp:attachment":[{"href":"https:\/\/wiki.tengwangyun.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wiki.tengwangyun.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wiki.tengwangyun.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}