ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a4cc9600e5cb: POST https://beta.jinchangxiao.com/vue/erp-sales-gift/get-edit at 2026-07-07 05:39:44 pm by 114.244.130.20

Log Messages

总计116条数据
TimeLevelCategoryMessage
 
17:39:44.057traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
17:39:44.057traceyii\base\Module::getModuleLoading module: debug
17:39:44.058traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
17:39:44.059traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
17:39:44.059traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
17:39:44.060traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:39:44.060infotime tracing start1783417184060772864
17:39:44.061traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
17:39:44.061traceyii\web\Application::handleRequestRoute requested: 'vue/erp-sales-gift/get-edit'
17:39:44.061traceyii\base\Module::getModuleLoading module: vue
17:39:44.063infoyii\web\Session::openSession started
17:39:44.065infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:39:44.065infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:39:44.075traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:39:44.076traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:39:44.077infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
17:39:44.078traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:39:44.079traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:39:44.079infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
17:39:44.087traceyii\base\Controller::runActionRoute to run: vue/erp-sales-gift/get-edit
17:39:44.087traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:39:44.091traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewErp
17:39:44.091traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
17:39:44.091traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: FinancialAudit
17:39:44.091traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: CommercialAttache
17:39:44.091traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:39:44.091traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ErpSalesGiftController::actionGetEdit()
17:39:44.091traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:39:44.091traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:39:44.093traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'erp_store_id' in 'app\models\search\ErpSalesGiftSearch'.
17:39:44.094traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:39:44.096traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:39:44.098infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" ORDER BY "id"
17:39:44.100infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT r.*, min( CASE WHEN 1 = r.verify_type THEN ( CASE WHEN rvr.status = 0 THEN 1 WHEN rsvr.status = 0 THEN 2 ELSE 4 END ) ELSE ( CASE WHEN rvr.status = 0 AND r.next_verify_user = 1001 THEN 1 WHEN rsvr.status = 0 AND r.next_stop_verify_user = 1001 THEN 2 ELSE 4 END ) END) AS need_verify_sort FROM "a57be577deb434"."tbl_erp_sales_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_gift_verify_rels" "rvr" ON rvr.erp_sales_gift_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gift_stop_verify_rels" "rsvr" ON rsvr.erp_sales_gift_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gift_products" "epop" ON epop.erp_sales_gift_id = r.id LEFT JOIN "a57be577deb434"."tbl_products" "product" ON epop.product_id = product.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id WHERE (("client"."sales_rep"=1001) OR ("r"."created_by"=1001) OR ("rvr"."user_id"=1001) OR ("r"."created_by" IN (1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1025, 1026, 1027, 1028, 1029, 1030, 5015, 5016, 5022, 5023, 5024, 5025, 5026, 5027, 5028, 5029, 5030, 5031, 5032, 5033, 5037, 5043, 5044, 5045, 5047, 5048, 5049, 5050, 5062, 5063, 5064, 5065, 5066, 5069, 5070, 5071, 5072, 5073, 5074, 5075, 5076, 5078, 5079, 5080, 5081, 5082, 5083, 5085, 5086, 5087, 5088, 5089, 5093, 5094, 5095, 5096, 5101, 5102, 5104, 5105, 5123, 5124, 5125, 5126, 5128, 5135, 5203, 5208, 5209, 5229, 5230, 5247, 5248, 5249, 5250, 5252, 5258, 5259, 5293, 5294, 5295, 5296, 5297, 5298, 5299, 5300, 5301, 5302, 5303, 5304, 5305, 5309, 5311, 5329, 5332, 5333, 5351, 5356, 5357, 5358, 5359, 5360, 5364, 5388, 5393, 5404, 5409, 5411, 5412, 5413, 5419, 5420, 5440, 5445, 5446, 5448, 5449, 5461, 5467, 5476, 5497, 5499, 5500))) AND (("r"."status" != 0) OR (("r"."status"=0) AND ("r"."created_by"=1001))) GROUP BY "r"."id") "c"
17:39:44.106infoyii\db\Command::querySELECT sub.* FROM (SELECT ROW_NUMBER() OVER (ORDER BY need_verify_sort ASC, created_at DESC) as idx, sub.* FROM (SELECT r.*, min( CASE WHEN 1 = r.verify_type THEN ( CASE WHEN rvr.status = 0 THEN 1 WHEN rsvr.status = 0 THEN 2 ELSE 4 END ) ELSE ( CASE WHEN rvr.status = 0 AND r.next_verify_user = 1001 THEN 1 WHEN rsvr.status = 0 AND r.next_stop_verify_user = 1001 THEN 2 ELSE 4 END ) END) AS need_verify_sort FROM "a57be577deb434"."tbl_erp_sales_gifts" "r" LEFT JOIN "a57be577deb434"."tbl_erp_sales_gift_verify_rels" "rvr" ON rvr.erp_sales_gift_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gift_stop_verify_rels" "rsvr" ON rsvr.erp_sales_gift_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_sales_gift_products" "epop" ON epop.erp_sales_gift_id = r.id LEFT JOIN "a57be577deb434"."tbl_products" "product" ON epop.product_id = product.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id WHERE (("client"."sales_rep"=1001) OR ("r"."created_by"=1001) OR ("rvr"."user_id"=1001) OR ("r"."created_by" IN (1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1018, 1019, 1020, 1021, 1022, 1023, 1025, 1026, 1027, 1028, 1029, 1030, 5015, 5016, 5022, 5023, 5024, 5025, 5026, 5027, 5028, 5029, 5030, 5031, 5032, 5033, 5037, 5043, 5044, 5045, 5047, 5048, 5049, 5050, 5062, 5063, 5064, 5065, 5066, 5069, 5070, 5071, 5072, 5073, 5074, 5075, 5076, 5078, 5079, 5080, 5081, 5082, 5083, 5085, 5086, 5087, 5088, 5089, 5093, 5094, 5095, 5096, 5101, 5102, 5104, 5105, 5123, 5124, 5125, 5126, 5128, 5135, 5203, 5208, 5209, 5229, 5230, 5247, 5248, 5249, 5250, 5252, 5258, 5259, 5293, 5294, 5295, 5296, 5297, 5298, 5299, 5300, 5301, 5302, 5303, 5304, 5305, 5309, 5311, 5329, 5332, 5333, 5351, 5356, 5357, 5358, 5359, 5360, 5364, 5388, 5393, 5404, 5409, 5411, 5412, 5413, 5419, 5420, 5440, 5445, 5446, 5448, 5449, 5461, 5467, 5476, 5497, 5499, 5500))) AND (("r"."status" != 0) OR (("r"."status"=0) AND ("r"."created_by"=1001))) GROUP BY "r"."id") "sub") "sub" WHERE "id"='121'
17:39:44.112infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_gifts" WHERE "id"='121'
17:39:44.113infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
17:39:44.114infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011)
17:39:44.116infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=3
17:39:44.116infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
17:39:44.117infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087)
17:39:44.117infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
17:39:44.118infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2125
17:39:44.118infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "bargain_date" FROM "a57be577deb434"."tbl_projects" WHERE "id"=4113
17:39:44.119infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_gift_carbon_copy_rels" WHERE "erp_sales_gift_id"=121
17:39:44.120infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_gift_verify_rels" WHERE "erp_sales_gift_id"=121 ORDER BY "id"
17:39:44.120infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1011, 1013)
17:39:44.121infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1013, 1011, 1001))
17:39:44.121infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_gift_verify_rels" WHERE ("status"=0) AND ("erp_sales_gift_id"=121) ORDER BY "id"
17:39:44.122infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_gift_verify_rels" WHERE ("status" != 0) AND ("erp_sales_gift_id"=121) ORDER BY "id"
17:39:44.122infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_gift_verify_rels" WHERE ("status" = 0) AND ("user_id"=1001) AND ("erp_sales_gift_id"=121)
17:39:44.123infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20017) AND ("object_id"=121)
17:39:44.127infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20018) AND ("object_id"=121)
17:39:44.130infoyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"=1
17:39:44.131infoyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_send_types" WHERE "id"=1
17:39:44.131infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_gift_products" WHERE "erp_sales_gift_id"=121
17:39:44.132infoyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_stores" WHERE "id"=1
17:39:44.132infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (2263, 2264)
17:39:44.134infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id"=21
17:39:44.134infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id"=229
17:39:44.135infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=285
17:39:44.136infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1782
17:39:44.136infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
17:39:44.137infoyii\db\Command::querySELECT eip.product_id, sum(outbound) as outbound, sum(number) as number, sum(CASE WHEN eip.erp_purchase_inbound_id IS NOT NULL THEN eip.number ELSE 0 END) as purchase_inbound, sum(sales_outbound) as sales_outbound, sum(CASE WHEN eip.erp_inventory_overflow_id IS NOT NULL THEN eip.number ELSE 0 END) as overflow_inbound, sum(lost_outbound) as lost_outbound, sum(CASE WHEN eip.erp_inventory_disassemble_id IS NOT NULL THEN eip.number ELSE 0 END) as disassemble_inbound, sum(disassemble_spent_outbound) as disassemble_spent_outbound, sum(sales_gift_outbound) as sales_gift_outbound, sum(CASE WHEN eip.erp_inventory_build_id IS NOT NULL THEN eip.number ELSE 0 END) as build_inbound, sum(build_spent_outbound) as build_spent_outbound, sum(CASE WHEN eip.erp_inventory_transfer_id IS NOT NULL THEN eip.number ELSE 0 END) as transfer_inbound, sum(transfer_spent_outbound) as transfer_spent_outbound, sum(inventory) as inventory, avg(actual_amount) as avg_amount, avg(actual_amount * inventory) as avg_total_amount, sum(actual_amount * inventory) as amount FROM "a57be577deb434"."tbl_erp_inventory_products" "eip" WHERE "product_id" IN (2263, 2264) GROUP BY "eip"."product_id"
17:39:44.139infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_gift_spent_products" WHERE "erp_sales_gift_product_id" IN (148, 149)
17:39:44.140infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (2263, 2264)
17:39:44.140infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id"=21
17:39:44.141infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id"=229
17:39:44.141infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=285
17:39:44.142infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1782
17:39:44.142infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
17:39:44.143infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_gift_spent_product_sns" WHERE "erp_sales_gift_spent_product_id" IN (175, 176)
17:39:44.143infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_product_spents" WHERE "erp_sales_gift_spent_product_id" IN (175, 176)
17:39:44.144infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id" IN (459, 458)
17:39:44.146infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE "id"=194
17:39:44.147infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_gift_stop_verify_rels" WHERE "erp_sales_gift_id"=121 ORDER BY "id"
17:39:44.148infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_gift_stop_verify_rels" WHERE ("status"=0) AND ("erp_sales_gift_id"=121) ORDER BY "id"
17:39:44.148infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_gift_stop_verify_rels" WHERE ("status" != 0) AND ("erp_sales_gift_id"=121) ORDER BY "id"
17:39:44.148infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_gift_stop_verify_rels" WHERE ("status" = 0) AND ("user_id"=1001) AND ("erp_sales_gift_id"=121)
17:39:44.149infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_sales_gift_spent_products" WHERE "erp_sales_gift_id"=121
17:39:44.149infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id" IN (2263, 2264)
17:39:44.150infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "id"=21
17:39:44.150infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_components" WHERE "id"=229
17:39:44.151infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_brands" WHERE "id"=285
17:39:44.151infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_series" WHERE "id"=1782
17:39:44.152infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3
17:39:44.152infoyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=20011) AND ("object_id"=121) GROUP BY "object_id"
17:39:44.216infoyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=20011) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id"=121) GROUP BY "object_id"
17:39:44.266traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewTicketLog
17:39:44.266traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:39:44.267traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewErpSalesGift
17:39:44.267traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
17:39:44.267traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:39:44.267traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewProduct
17:39:44.267traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
17:39:44.267traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:39:44.267traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: createErpSalesGift
17:39:44.267traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
17:39:44.267traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:39:44.267traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:39:44.270traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:39:44.273infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE "id"=10
17:39:44.286infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE ("id"='1001') AND ("user_status"='1') ORDER BY array_position(array[1001], id)
17:39:44.295infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
17:39:44.308infoyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_stores" WHERE "is_delete"=FALSE ORDER BY "sort", "id"
17:39:44.322infoyii\db\Command::querySELECT "id", "id" AS "key", "title" AS "name" FROM "a57be577deb434"."tbl_erp_send_types" WHERE "is_delete"=FALSE ORDER BY "sort", "id"
17:39:44.340infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE ("id" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("user_status"='1') ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
17:39:44.354infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (SELECT "department_id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1') ORDER BY "order"
17:39:44.366infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "department_id", "pinyin_shortcut" FROM "a57be577deb434"."tbl_users" WHERE ("user_status"='1') AND ("department_id" IN (4, 1, 2, 3, 9, 8, 6, 7, 10)) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
17:39:44.375infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1000, 5500, 5499, 5250, 5016, 1011, 5085, 5332, 5446, 1001, 5087, 5300, 5311, 5252, 5295, 5248, 1013, 1015, 5461, 1022, 5476, 5064, 1004, 5360, 1005, 1023))
17:39:44.388infoyii\db\Command::querySELECT MAX(end_date) FROM "a57be577deb434"."tbl_erp_settles" WHERE "is_settle"=TRUE
17:39:44.394traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:39:44.394traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:39:44.395infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-sales-gift/get-edit', '{"Filter":{"name":"default","sort":"DESC"},"ErpSalesGiftSearch":{"wrote_date_period":"","created_at_period":"","status":"","erp_store_id":"","is_sales_order_ready":"","handler":"","created_by":"","number_range_to":"","number_range_from":"","amount_range_to":"","amount_range_from":""},"id":"121","web_access_token":"niM9Np1xaU2lIsoGJh5qM6IxT9naEHjn"}', '{"code":2000,"result":{"model":{"id":121,"serial_no":"ZSD-20260320-00001","from_date":"","wrote_date":"2026-03-20","handler":5087,"erp_sales_order_id":"","supplier_id":"","client_id":2125,"project_id":4113,"erp_store_id":1,"status":2,"erp_send_type_id":1,"abstract":"\u672a\u7a0e\uff0c\u8d60\u9001\uff1b\u6536\u4ef6\u4eba\uff1a\u56fd\u96f7\u519b","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-03-20 17:32:03","stop_at":"","refuse_description":"","is_resubmitted":false,"number":"4","amount":"0","created_by":1011,"stop_description":"","outbound_status":false,"is_settle":false,"created_at":"2026-03-20 15:16:21","updated_at":"2026-03-20 17:32:03","print_times":1,"is_sales_order_ready":false,"need_handler":true,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"handlerPerson":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","department_id":1,"avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"supplier":{},"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8"},"project":{"id":4113,"key":4113,"name":"\u4f1a\u8bae\u5ba4\u7cfb\u7edf-K","bargain_date":"2026-01-28"},"erpSalesGiftCarbonCopyRels":[],"erpSalesGiftVerifyRels":[{"id":520,"erp_sales_gift_id":121,"user_id":1001,"status":1,"description":"","verify_at":"2026-03-20 15:27:08","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}},{"id":521,"erp_sales_gift_id":121,"user_id":1011,"status":1,"description":"","verify_at":"2026-03-20 17:30:30","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},{"id":522,"erp_sales_gift_id":121,"user_id":1013,"status":1,"description":"","verify_at":"2026-03-20 17:32:03","user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"lastErpSalesGiftVerifyRel":{},"haveErpSalesGiftVerifyRel":{"id":520,"erp_sales_gift_id":121,"user_id":1001,"status":1,"description":"","verify_at":"2026-03-20 15:27:08"},"selfErpSalesGiftVerifyRel":{},"attachmentRelationships":[],"files":[],"erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"},"erpSendType":{"id":1,"key":1,"name":"\u5feb\u9012"},"erpSalesGiftProducts":[{"id":148,"erp_sales_gift_id":121,"erp_store_id":1,"product_id":2263,"description":"","outbound":"0","number":"3","amount":"0","total_amount":"0.00","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"},"product":{"id":2263,"name":"\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8","product_type":21,"product_component":229,"product_brand":285,"product_serie":1782,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:32:00","updated_at":"2026-03-20 15:16:21","pinyin_shortcut":"xptymb100c","product_unit":3,"is_renew":false,"in_out_at":"2026-03-20 15:16:21.988041+08","productType":{"id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907"},"productComponent":{"id":229,"key":229,"name":"\u6570\u7801\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":285,"key":285,"name":"\u867e\u76ae"},"productSerie":{"id":1782,"key":1782,"name":"\u6295\u5f71\u5e55\u5e03"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"erpInventoryCount":{"product_id":2263,"outbound":"3","number":"3","purchase_inbound":"3","sales_outbound":"3","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"164.0000000000000000","avg_total_amount":"0.00000000000000000000","amount":"0"}},"erpSalesGiftSpentProducts":[{"id":175,"erp_sales_gift_id":121,"erp_sales_gift_product_id":148,"erp_inventory_product_id":459,"product_id":2263,"description":"","number":"3","amount":"0","total_amount":"0","cancel_number":"","cancel_amount":"","cancel_total_amount":"","product":{"id":2263,"name":"\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8","product_type":21,"product_component":229,"product_brand":285,"product_serie":1782,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:32:00","updated_at":"2026-03-20 15:16:21","pinyin_shortcut":"xptymb100c","product_unit":3,"is_renew":false,"in_out_at":"2026-03-20 15:16:21.988041+08","productType":{"id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907"},"productComponent":{"id":229,"key":229,"name":"\u6570\u7801\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":285,"key":285,"name":"\u867e\u76ae"},"productSerie":{"id":1782,"key":1782,"name":"\u6295\u5f71\u5e55\u5e03"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesGiftSpentProductSns":[],"spent":{"id":665,"erp_purchase_order_id":"","erp_purchase_inbound_id":"","erp_inventory_product_id":459,"wrote_date":"2026-03-20","actual_amount":"164","actual_total_amount":"492","outbound":"3","amount":"0","total_amount":"0","lost_outbound":"","erp_inventory_lost_product_id":"","erp_inventory_lost_id":"","erp_inventory_start_id":"","erp_inventory_build_id":"","build_spent_outbound":"","erp_inventory_build_spent_product_id":"","erp_inventory_build_spent_id":"","sales_outbound":"3","erp_sales_outbound_spent_product_id":"","erp_sales_outbound_id":"","erp_purchase_gift_id":"","sales_gift_outbound":"","erp_sales_gift_spent_product_id":175,"erp_sales_gift_id":121,"erp_inventory_disassemble_id":"","disassemble_spent_outbound":"","erp_inventory_disassemble_spent_product_id":"","erp_inventory_disassemble_spent_id":"","erp_inventory_overflow_id":"","erp_inventory_transfer_spent_id":"","erp_inventory_transfer_spent_product_id":"","transfer_spent_outbound":"","erpInventoryProduct":{"id":459,"product_id":2263,"erp_purchase_inbound_id":194,"erp_purchase_order_id":2201,"erp_purchase_inbound_product_id":401,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-03-20","number":"3","outbound":"3","inventory":"0","amount":"164","total_amount":"492.00","actual_amount":"164","actual_total_amount":"0","is_build":false,"created_at":"2026-03-20 15:12:59","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"3","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":"","erp_inventory_transfer_id":"","erp_inventory_transfer_product_id":"","transfer_spent_outbound":"","erpPurchaseInbound":{"id":194,"serial_no":"CGRKD-20260320-00001","from_date":"","wrote_date":"2026-03-20","handler":1011,"erp_purchase_order_id":2201,"supplier_id":262,"purchase_contract_id":4440,"erp_store_id":1,"status":2,"abstract":"\u542b\u7a0e\uff0c\u666e\u7968","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-03-20 15:12:59","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"number":"4","amount":"644.54","cancel_number":"","cancel_amount":"","created_by":1011,"stop_description":"","is_used":true,"is_settle":false,"created_at":"2026-03-20 14:47:46","updated_at":"2026-03-20 15:12:59","print_times":1},"erpPurchaseGift":{},"erpInventoryStart":{},"erpInventoryBuild":{},"erpInventoryDisassemble":{},"erpInventoryOverflow":{}}}}],"spent_total_amount":492,"avg_spent_amount":164,"pct":""},{"id":149,"erp_sales_gift_id":121,"erp_store_id":1,"product_id":2264,"description":"","outbound":"0","number":"1","amount":"0","total_amount":"0.00","hardware_from":"","software_from":"","maintenance_from":"","hardware_to":"","software_to":"","maintenance_to":"","erpStore":{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"},"product":{"id":2264,"name":"\u867e\u76ae\u6295\u5f71\u5e55\u5e0372\u5bf8","product_type":21,"product_component":229,"product_brand":285,"product_serie":1782,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:32:27","updated_at":"2026-03-20 15:16:21","pinyin_shortcut":"xptymb72c","product_unit":3,"is_renew":false,"in_out_at":"2026-03-20 15:16:21.988041+08","productType":{"id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907"},"productComponent":{"id":229,"key":229,"name":"\u6570\u7801\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":285,"key":285,"name":"\u867e\u76ae"},"productSerie":{"id":1782,"key":1782,"name":"\u6295\u5f71\u5e55\u5e03"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"},"erpInventoryCount":{"product_id":2264,"outbound":"1","number":"1","purchase_inbound":"1","sales_outbound":"1","overflow_inbound":"0","lost_outbound":"","disassemble_inbound":"0","disassemble_spent_outbound":"","sales_gift_outbound":"","build_inbound":"0","build_spent_outbound":"","transfer_inbound":"0","transfer_spent_outbound":"","inventory":"0","avg_amount":"152.5400000000000000","avg_total_amount":"0.00000000000000000000","amount":"0.00"}},"erpSalesGiftSpentProducts":[{"id":176,"erp_sales_gift_id":121,"erp_sales_gift_product_id":149,"erp_inventory_product_id":458,"product_id":2264,"description":"","number":"1","amount":"0","total_amount":"0","cancel_number":"","cancel_amount":"","cancel_total_amount":"","product":{"id":2264,"name":"\u867e\u76ae\u6295\u5f71\u5e55\u5e0372\u5bf8","product_type":21,"product_component":229,"product_brand":285,"product_serie":1782,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:32:27","updated_at":"2026-03-20 15:16:21","pinyin_shortcut":"xptymb72c","product_unit":3,"is_renew":false,"in_out_at":"2026-03-20 15:16:21.988041+08","productType":{"id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907"},"productComponent":{"id":229,"key":229,"name":"\u6570\u7801\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":285,"key":285,"name":"\u867e\u76ae"},"productSerie":{"id":1782,"key":1782,"name":"\u6295\u5f71\u5e55\u5e03"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}},"erpSalesGiftSpentProductSns":[],"spent":{"id":666,"erp_purchase_order_id":"","erp_purchase_inbound_id":"","erp_inventory_product_id":458,"wrote_date":"2026-03-20","actual_amount":"152.54","actual_total_amount":"152.54","outbound":"1","amount":"0","total_amount":"0","lost_outbound":"","erp_inventory_lost_product_id":"","erp_inventory_lost_id":"","erp_inventory_start_id":"","erp_inventory_build_id":"","build_spent_outbound":"","erp_inventory_build_spent_product_id":"","erp_inventory_build_spent_id":"","sales_outbound":"1","erp_sales_outbound_spent_product_id":"","erp_sales_outbound_id":"","erp_purchase_gift_id":"","sales_gift_outbound":"","erp_sales_gift_spent_product_id":176,"erp_sales_gift_id":121,"erp_inventory_disassemble_id":"","disassemble_spent_outbound":"","erp_inventory_disassemble_spent_product_id":"","erp_inventory_disassemble_spent_id":"","erp_inventory_overflow_id":"","erp_inventory_transfer_spent_id":"","erp_inventory_transfer_spent_product_id":"","transfer_spent_outbound":"","erpInventoryProduct":{"id":458,"product_id":2264,"erp_purchase_inbound_id":194,"erp_purchase_order_id":2201,"erp_purchase_inbound_product_id":400,"erp_purchase_order_product_id":"","erp_store_id":1,"wrote_date":"2026-03-20","number":"1","outbound":"1","inventory":"0","amount":"152.54","total_amount":"152.54","actual_amount":"152.54","actual_total_amount":"0","is_build":false,"created_at":"2026-03-20 15:12:59","lost_outbound":"","erp_inventory_start_id":"","erp_inventory_start_product_id":"","erp_inventory_build_id":"","erp_inventory_build_product_id":"","build_spent_outbound":"","sales_outbound":"1","erp_purchase_gift_id":"","erp_purchase_gift_product_id":"","sales_gift_outbound":"","erp_inventory_disassemble_id":"","erp_inventory_disassemble_product_id":"","disassemble_spent_outbound":"","erp_inventory_overflow_id":"","erp_inventory_overflow_product_id":"","erp_inventory_transfer_id":"","erp_inventory_transfer_product_id":"","transfer_spent_outbound":"","erpPurchaseInbound":{"id":194,"serial_no":"CGRKD-20260320-00001","from_date":"","wrote_date":"2026-03-20","handler":1011,"erp_purchase_order_id":2201,"supplier_id":262,"purchase_contract_id":4440,"erp_store_id":1,"status":2,"abstract":"\u542b\u7a0e\uff0c\u666e\u7968","description":"","verify_type":2,"next_verify_user":"","next_stop_verify_user":"","verify_at":"2026-03-20 15:12:59","stop_at":"","cancel_at":"","refuse_description":"","is_resubmitted":false,"number":"4","amount":"644.54","cancel_number":"","cancel_amount":"","created_by":1011,"stop_description":"","is_used":true,"is_settle":false,"created_at":"2026-03-20 14:47:46","updated_at":"2026-03-20 15:12:59","print_times":1},"erpPurchaseGift":{},"erpInventoryStart":{},"erpInventoryBuild":{},"erpInventoryDisassemble":{},"erpInventoryOverflow":{}}}}],"spent_total_amount":152.54,"avg_spent_amount":152.54,"pct":""}],"erpSalesGiftStopVerifyRels":[],"lastErpSalesGiftStopVerifyRel":"","haveErpSalesGiftStopVerifyRel":"","selfErpSalesGiftStopVerifyRel":"","erpSalesGiftSpentProducts":[{"id":175,"erp_sales_gift_id":121,"erp_sales_gift_product_id":148,"erp_inventory_product_id":459,"product_id":2263,"description":"","number":"3","amount":"0","total_amount":"0","cancel_number":"","cancel_amount":"","cancel_total_amount":"","product":{"id":2263,"name":"\u867e\u76ae\u6295\u5f71\u5e55\u5e03100\u5bf8","product_type":21,"product_component":229,"product_brand":285,"product_serie":1782,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:32:00","updated_at":"2026-03-20 15:16:21","pinyin_shortcut":"xptymb100c","product_unit":3,"is_renew":false,"in_out_at":"2026-03-20 15:16:21.988041+08","productType":{"id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907"},"productComponent":{"id":229,"key":229,"name":"\u6570\u7801\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":285,"key":285,"name":"\u867e\u76ae"},"productSerie":{"id":1782,"key":1782,"name":"\u6295\u5f71\u5e55\u5e03"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}},{"id":176,"erp_sales_gift_id":121,"erp_sales_gift_product_id":149,"erp_inventory_product_id":458,"product_id":2264,"description":"","number":"1","amount":"0","total_amount":"0","cancel_number":"","cancel_amount":"","cancel_total_amount":"","product":{"id":2264,"name":"\u867e\u76ae\u6295\u5f71\u5e55\u5e0372\u5bf8","product_type":21,"product_component":229,"product_brand":285,"product_serie":1782,"product_misc":"","product_qa":"","pn":"","description":"","created_by":1013,"created_at":"2026-03-20 14:32:27","updated_at":"2026-03-20 15:16:21","pinyin_shortcut":"xptymb72c","product_unit":3,"is_renew":false,"in_out_at":"2026-03-20 15:16:21.988041+08","productType":{"id":21,"key":21,"name":"\u6570\u7801\u8bbe\u5907"},"productComponent":{"id":229,"key":229,"name":"\u6570\u7801\u8bbe\u5907\u914d\u4ef6"},"productBrand":{"id":285,"key":285,"name":"\u867e\u76ae"},"productSerie":{"id":1782,"key":1782,"name":"\u6295\u5f71\u5e55\u5e03"},"productUnit":{"id":3,"key":3,"name":"\u4e2a"}}}],"commentCount":{"object_id":121,"comment":4},"unreadComments":{},"cost":644.54,"unread":0,"can_update":false,"can_update_sn":true,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_stop":true,"can_stop_verify":false,"can_stop_refuse":false,"can_create_erp_sales_return":true,"bgcolor":"#4B7902","status_display":"\u5df2\u901a\u8fc7","can_view_product":true,"can_make_sales_order":true,"sales_order_ready_display":false,"sales_order_un_ready_display":true,"erpSalesGiftVerifyUsers":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}],"erpSalesGiftCarbonCopyUsers":[],"approval_workflow":"system","copy_workflow":"custom"},"options":{"ErpSalesGifts[erp_store_id]":{"key":"ErpSalesGifts[erp_store_id]","name":"\u4ed3\u5e93","value":[{"id":1,"key":1,"name":"\u62d3\u5b9e\u4ed3\u5e93"},{"id":2,"key":2,"name":"\u96f6\u914d\u4ef6"}]},"ErpSalesGifts[erp_send_type_id]":{"key":"ErpSalesGifts[erp_send_type_id]","name":"\u4ea4\u8d27\u65b9\u5f0f","value":[{"id":1,"key":1,"name":"\u5feb\u9012"},{"id":2,"key":2,"name":"\u7269\u6d41"},{"id":3,"key":3,"name":"\u9001\u8d27"},{"id":4,"key":4,"name":"\u81ea\u63d0"},{"id":5,"key":5,"name":"\u7535\u5b50\u90ae\u4ef6"}]},"ErpSalesGifts[handler]":{"key":"ErpSalesGifts[handler]","name":"\u5ba2\u6237\u7ecf\u7406","value":[{"key":5500,"name":"\u6d4b\u8bd5"},{"key":5499,"name":"\u9648\u8c46\u8c46"},{"key":5332,"name":"\u970d\u536b\u8d85"},{"key":1001,"name":"\u5218\u4eba\u8bda"},{"key":5087,"name":"\u5218\u5fae"},{"key":5300,"name":"\u82cf\u6e05\u4e91"},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280"},{"key":5295,"name":"\u9b4f\u6cfd\u6587"},{"key":1013,"name":"\u7fc1\u5bb6\u6210"},{"key":5476,"name":"\u6768\u5dcd"},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}],"default":""},"ErpSalesGifts[erpSalesGiftVerifyRels]":{"search":"1","key":"ErpSalesGifts[erpSalesGiftVerifyRels]","name":"\u5ba1\u6279\u4eba","value":[{"id":4,"key":4,"name":"\u603b\u7ecf\u7406","child":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","department_id":4,"pinyin_shortcut":"lrc","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}]},{"id":1,"key":1,"name":"\u9500\u552e\u90e8","child":[{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","department_id":1,"pinyin_shortcut":"hwc","avatar":{"id":148,"user_id":5332,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"}},{"id":5087,"key":5087,"name":"\u5218\u5fae","department_id":1,"pinyin_shortcut":"lw","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","department_id":1,"pinyin_shortcut":"sqy","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","department_id":1,"pinyin_shortcut":"wzw","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},{"id":5476,"key":5476,"name":"\u6768\u5dcd","department_id":1,"pinyin_shortcut":"yw","avatar":{}},{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","department_id":1,"pinyin_shortcut":"yjc","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","department_id":1,"pinyin_shortcut":"zmxsry","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}]},{"id":2,"key":2,"name":"\u6280\u672f\u90e8","child":[{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","department_id":2,"pinyin_shortcut":"hdy","avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"}},{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99","department_id":2,"pinyin_shortcut":"wjl","avatar":{"id":135,"user_id":5248,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b4458545-7f88-3479-97be-6f43b2b50454.png"}},{"id":1015,"key":1015,"name":"\u5434\u660a","department_id":2,"pinyin_shortcut":"wh","avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"}},{"id":1022,"key":1022,"name":"\u5f90\u7855","department_id":2,"pinyin_shortcut":"xs","avatar":{"id":6,"user_id":1022,"name":"\/files\/cdn\/a57be577deb434\/avatar\/2b5ec94d-d83c-38b4-ac3a-38720c369f91.png"}},{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","department_id":2,"pinyin_shortcut":"zzj","avatar":{"id":4,"user_id":1023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg"}}]},{"id":3,"key":3,"name":"\u5546\u52a1\u90e8","child":[{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","department_id":3,"pinyin_shortcut":"hyf","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","department_id":3,"pinyin_shortcut":"zhf","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}]},{"id":9,"key":9,"name":"\u9879\u76ee\u90e8","child":[{"id":5500,"key":5500,"name":"\u6d4b\u8bd5","department_id":9,"pinyin_shortcut":"cs","avatar":{}},{"id":5499,"key":5499,"name":"\u9648\u8c46\u8c46","department_id":9,"pinyin_shortcut":"cdd","avatar":{}},{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","department_id":9,"pinyin_shortcut":"tskj","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}]},{"id":8,"key":8,"name":"\u4eba\u529b\u8d44\u6e90","child":[{"id":5446,"key":5446,"name":"\u5218\u5a1f","department_id":8,"pinyin_shortcut":"lj","avatar":{"id":164,"user_id":5446,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5631bbfb-fa6e-308e-b87c-b159e8042209.jpg"}}]},{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8","child":[{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","department_id":6,"pinyin_shortcut":"wxx","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}]},{"id":7,"key":7,"name":"\u5e93\u623f\u90e8","child":[{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","department_id":7,"pinyin_shortcut":"wjc","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}]},{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1","child":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","department_id":10,"pinyin_shortcut":"cys","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"}},{"id":5250,"key":5250,"name":"\u8463\u8363","department_id":10,"pinyin_shortcut":"dr","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}},{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","department_id":10,"pinyin_shortcut":"gjy","avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}},{"id":5461,"key":5461,"name":"\u8096\u5e05","department_id":10,"pinyin_shortcut":"xs","avatar":{"id":165,"user_id":5461,"name":"\/files\/cdn\/\/avatar\/5f0c67fa-c4d4-3b8c-abca-523e5598dc8c.png"}},{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","department_id":10,"pinyin_shortcut":"yxc","avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}}]}]},"ErpSalesGifts[erpSalesGiftCarbonCopyRels]":{"search":"1","key":"ErpSalesGifts[erpSalesGiftCarbonCopyRels]","name":"\u6284\u9001","value":[{"id":4,"key":4,"name":"\u603b\u7ecf\u7406","child":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","department_id":4,"pinyin_shortcut":"lrc","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}}]},{"id":1,"key":1,"name":"\u9500\u552e\u90e8","child":[{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","department_id":1,"pinyin_shortcut":"hwc","avatar":{"id":148,"user_id":5332,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"}},{"id":5087,"key":5087,"name":"\u5218\u5fae","department_id":1,"pinyin_shortcut":"lw","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","department_id":1,"pinyin_shortcut":"sqy","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","department_id":1,"pinyin_shortcut":"wzw","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},{"id":5476,"key":5476,"name":"\u6768\u5dcd","department_id":1,"pinyin_shortcut":"yw","avatar":{}},{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","department_id":1,"pinyin_shortcut":"yjc","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","department_id":1,"pinyin_shortcut":"zmxsry","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}]},{"id":2,"key":2,"name":"\u6280\u672f\u90e8","child":[{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","department_id":2,"pinyin_shortcut":"hdy","avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"}},{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99","department_id":2,"pinyin_shortcut":"wjl","avatar":{"id":135,"user_id":5248,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b4458545-7f88-3479-97be-6f43b2b50454.png"}},{"id":1015,"key":1015,"name":"\u5434\u660a","department_id":2,"pinyin_shortcut":"wh","avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"}},{"id":1022,"key":1022,"name":"\u5f90\u7855","department_id":2,"pinyin_shortcut":"xs","avatar":{"id":6,"user_id":1022,"name":"\/files\/cdn\/a57be577deb434\/avatar\/2b5ec94d-d83c-38b4-ac3a-38720c369f91.png"}},{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","department_id":2,"pinyin_shortcut":"zzj","avatar":{"id":4,"user_id":1023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg"}}]},{"id":3,"key":3,"name":"\u5546\u52a1\u90e8","child":[{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","department_id":3,"pinyin_shortcut":"hyf","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","department_id":3,"pinyin_shortcut":"zhf","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}]},{"id":9,"key":9,"name":"\u9879\u76ee\u90e8","child":[{"id":5500,"key":5500,"name":"\u6d4b\u8bd5","department_id":9,"pinyin_shortcut":"cs","avatar":{}},{"id":5499,"key":5499,"name":"\u9648\u8c46\u8c46","department_id":9,"pinyin_shortcut":"cdd","avatar":{}},{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","department_id":9,"pinyin_shortcut":"tskj","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}}]},{"id":8,"key":8,"name":"\u4eba\u529b\u8d44\u6e90","child":[{"id":5446,"key":5446,"name":"\u5218\u5a1f","department_id":8,"pinyin_shortcut":"lj","avatar":{"id":164,"user_id":5446,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5631bbfb-fa6e-308e-b87c-b159e8042209.jpg"}}]},{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8","child":[{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","department_id":6,"pinyin_shortcut":"wxx","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}]},{"id":7,"key":7,"name":"\u5e93\u623f\u90e8","child":[{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","department_id":7,"pinyin_shortcut":"wjc","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}]},{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1","child":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","department_id":10,"pinyin_shortcut":"cys","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"}},{"id":5250,"key":5250,"name":"\u8463\u8363","department_id":10,"pinyin_shortcut":"dr","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}},{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","department_id":10,"pinyin_shortcut":"gjy","avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}},{"id":5461,"key":5461,"name":"\u8096\u5e05","department_id":10,"pinyin_shortcut":"xs","avatar":{"id":165,"user_id":5461,"name":"\/files\/cdn\/\/avatar\/5f0c67fa-c4d4-3b8c-abca-523e5598dc8c.png"}},{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","department_id":10,"pinyin_shortcut":"yxc","avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}}]}]}},"index":10,"count":129,"disableMonth":{"minTime":"2025-08-31","maxTime":"","disabledRanges":[]}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"114.244.130.20","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-07 17:39:44', 334536960) RETURNING "id"
17:39:44.400traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:39:44.401traceyii\redis\Connection::executeCommandExecuting Redis Command: SET