ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c3d8d35cf2e: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-sales-cost at 2025-09-12 04:24:51 pm by 114.246.237.213

Log Messages

总计43条数据
TimeLevelCategoryMessage
 
16:24:51.380traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
16:24:51.380traceyii\base\Module::getModuleLoading module: debug
16:24:51.380traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
16:24:51.380traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
16:24:51.380traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
16:24:51.381traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:24:51.381traceyii\base\Module::getModuleLoading module: gii
16:24:51.381traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
16:24:51.381traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
16:24:51.381traceyii\web\Application::handleRequestRoute requested: 'vue/erp-analysis/list-sales-cost'
16:24:51.381traceyii\base\Module::getModuleLoading module: vue
16:24:51.381infoyii\web\Session::openSession started
16:24:51.382infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:24:51.382infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:24:51.386traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:24:51.386traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:24:51.387traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:24:51.387traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:24:51.387infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:24:51.389traceyii\base\Controller::runActionRoute to run: vue/erp-analysis/list-sales-cost
16:24:51.389traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:24:51.390traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
16:24:51.390traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\ErpAnalysisController::actionListSalesCost()
16:24:51.390traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:24:51.390traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:24:51.392infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT "p".* FROM (SELECT p.id, p.project_title, p.client_id, p.budget, p.updated_at, p.created_at, p.bargain_date, p.collected, p.budget - p.collected AS un_collected, p.pinyin_shortcut, p.description, (p.id::varchar || pd.user_id::varchar) as id, p.id as id2, (CASE WHEN pd.user_id IS NOT NULL THEN pd.user_id ELSE p.created_by END) as created_by, (COALESCE(sum(o.outbound_cost), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cost_amount, (COALESCE(sum(o.outbound_amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_sales_amount, (COALESCE(sum(ecta.amount), 0) + COALESCE(sum(ecctasc.amount), 0) + COALESCE(sum(eccrta.amount), 0) + COALESCE(sum(esgs.amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_use_amount, (COALESCE(sum(o.outbound_amount - o.outbound_cost), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_profit_amount, (COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) - COALESCE(sum(ecta.amount), 0) - COALESCE(sum(ecctasc.amount), 0) - COALESCE(sum(eccrta.amount), 0) - COALESCE(sum(esgs.amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_j_profit_amount FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN (SELECT t.project_id, r.user_id, sum(r.pct) as pct FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "r" ON t.id = r.erp_profit_distribute_id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id", "r"."user_id") "pd" ON pd.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = pd.user_id LEFT JOIN "a57be577deb434"."tbl_users" "u2" ON u2.id = p.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN (SELECT t.project_id, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "o" ON p.id = o.project_id LEFT JOIN (SELECT t.project_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "ecta" ON p.id = ecta.project_id LEFT JOIN (SELECT sc.from_project as project_id, COALESCE(sum(t.amount),0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND (sc.from_project IS NOT NULL) GROUP BY "sc"."from_project") "ecctasc" ON p.id = ecctasc.project_id LEFT JOIN (SELECT sc.from_project as project_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND (sc.from_project IS NOT NULL) GROUP BY "sc"."from_project") "eccrta" ON p.id = eccrta.project_id LEFT JOIN (SELECT t.project_id, COALESCE(sum(eipss.actual_total_amount - eipss.total_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "esgs" ON p.id = esgs.project_id WHERE ("project_status"=3) AND ("p"."bargain_date" >= '2025-01-01 00:00:00') AND ("p"."bargain_date" <= '2025-12-31 23:59:59') GROUP BY "p"."id", "pd"."user_id", "pd"."pct") "p" LEFT JOIN "a57be577deb434"."tbl_users" "u2" ON u2.id = p.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id ORDER BY p.bargain_date ASC NULLS LAST, p.updated_at DESC) "c"
16:24:51.402infoyii\db\Command::querySELECT "p".* FROM (SELECT p.id, p.project_title, p.client_id, p.budget, p.updated_at, p.created_at, p.bargain_date, p.collected, p.budget - p.collected AS un_collected, p.pinyin_shortcut, p.description, (p.id::varchar || pd.user_id::varchar) as id, p.id as id2, (CASE WHEN pd.user_id IS NOT NULL THEN pd.user_id ELSE p.created_by END) as created_by, (COALESCE(sum(o.outbound_cost), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_cost_amount, (COALESCE(sum(o.outbound_amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_sales_amount, (COALESCE(sum(ecta.amount), 0) + COALESCE(sum(ecctasc.amount), 0) + COALESCE(sum(eccrta.amount), 0) + COALESCE(sum(esgs.amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_use_amount, (COALESCE(sum(o.outbound_amount - o.outbound_cost), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_profit_amount, (COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) - COALESCE(sum(ecta.amount), 0) - COALESCE(sum(ecctasc.amount), 0) - COALESCE(sum(eccrta.amount), 0) - COALESCE(sum(esgs.amount), 0)) * (CASE WHEN pd.pct IS NOT NULL THEN pd.pct / 100 ELSE 1 END) as erp_j_profit_amount FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN (SELECT t.project_id, r.user_id, sum(r.pct) as pct FROM "a57be577deb434"."tbl_erp_profit_distributes" "t" LEFT JOIN "a57be577deb434"."tbl_erp_profit_distribute_pcts" "r" ON t.id = r.erp_profit_distribute_id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id", "r"."user_id") "pd" ON pd.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = pd.user_id LEFT JOIN "a57be577deb434"."tbl_users" "u2" ON u2.id = p.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN (SELECT t.project_id, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "o" ON p.id = o.project_id LEFT JOIN (SELECT t.project_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "ecta" ON p.id = ecta.project_id LEFT JOIN (SELECT sc.from_project as project_id, COALESCE(sum(t.amount),0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND (sc.from_project IS NOT NULL) GROUP BY "sc"."from_project") "ecctasc" ON p.id = ecctasc.project_id LEFT JOIN (SELECT sc.from_project as project_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = t.sales_contract_id WHERE ("t"."status"=2) AND (sc.from_project IS NOT NULL) GROUP BY "sc"."from_project") "eccrta" ON p.id = eccrta.project_id LEFT JOIN (SELECT t.project_id, COALESCE(sum(eipss.actual_total_amount - eipss.total_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND (t.project_id IS NOT NULL) GROUP BY "t"."project_id") "esgs" ON p.id = esgs.project_id WHERE ("project_status"=3) AND ("p"."bargain_date" >= '2025-01-01 00:00:00') AND ("p"."bargain_date" <= '2025-12-31 23:59:59') GROUP BY "p"."id", "pd"."user_id", "pd"."pct") "p" LEFT JOIN "a57be577deb434"."tbl_users" "u2" ON u2.id = p.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id ORDER BY p.bargain_date ASC NULLS LAST, p.updated_at DESC LIMIT 40
16:24:51.412traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:24:51.412traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:24:51.412infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (20, 918, 79, 2545, 2021, 149, 2616, 12, 3327, 2182, 1301, 1121, 107, 189, 3329, 97, 518, 48, 3333, 2546, 3281, 3334, 4, 531, 3326, 2736, 2032, 1172, 2226)
16:24:51.413infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5295, 1001, 5300, 5087, 1004)
16:24:51.414infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 1005, 5087, 1004, 5300))
16:24:51.414infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1)
16:24:51.415infoyii\db\Command::querySELECT "id", "from_project", "is_outbound" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3721, 3757, 3759, 3760, 3763, 3547, 3764, 3766, 3765, 3767, 3745, 3768, 3684, 3762, 3770, 3780, 3761, 3773, 3775, 3774, 3772, 3776, 3777, 3783, 3785, 3782, 3771, 3786, 3789, 3791, 3769, 3792, 3794, 3793, 3788, 3800, 3781, 3809, 3801, 3802)
16:24:51.417traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:24:51.417traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:24:51.417infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-09-12')
16:24:51.421traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:24:51.421traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:24:51.421infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=221, "last_visit_at"='now()' WHERE "id"=56537
16:24:51.422infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-analysis/list-sales-cost', '{"created_at_period":"currentfascalyear","created_by":"","Filter":{"name":"bargain_date","sort":"ASC"},"page":"1","web_access_token":"S7OJrULURAq348jTGnVvRiAMpe10N7Zn"}', '{"code":2000,"result":{"list":[{"id":3721,"project_title":"MSS24-25\u5e74\u7eed\u4fdd","client_id":20,"budget":"117000","updated_at":"2025-08-19 12:54:08","created_at":"2024-11-24 19:54:17","bargain_date":"2025-01-03","collected":"117000","un_collected":0,"pinyin_shortcut":"MSS2425nxb","description":"","id2":3721,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"84.62","erp_profit_amount":"0","erp_j_profit_amount":"-84.62","client":{"id":20,"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3745,"from_project":3721,"is_outbound":true},"buildContract":{"id":3745,"from_project":3721,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3757,"project_title":"H3C\u670d\u52a1\u5668\u786c\u76d8\u6362\u65b0","client_id":918,"budget":"700","updated_at":"2025-02-11 15:20:29","created_at":"2025-01-03 13:49:53","bargain_date":"2025-01-03","collected":"700","un_collected":0,"pinyin_shortcut":"H3Cfwqyphx","description":"","id2":3757,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":918,"key":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3744,"from_project":3757,"is_outbound":true},"buildContract":{"id":3744,"from_project":3757,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3759,"project_title":"2024\u6df1\u4fe1\u670d\u9632\u706b\u5899\u7eed\u4fdd","client_id":79,"budget":"20700","updated_at":"2025-02-11 10:56:22","created_at":"2025-01-07 19:45:38","bargain_date":"2025-01-07","collected":"20700","un_collected":0,"pinyin_shortcut":"2024sxffhqxb","description":"","id2":3759,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":79,"key":79,"name":"\u5317\u4eac\u79c0\u6c34\u8857\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8(\u5317\u4eac\u79c0\u6c34\u8857\u5e02\u573a\u6709\u9650\u516c\u53f8)"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3748,"from_project":3759,"is_outbound":true},"buildContract":{"id":3748,"from_project":3759,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3760,"project_title":"\u8054\u60f33\u5957\u4e8c\u624b\u670d\u52a1\u5668SR650\u91c7\u8d2d\u9879\u76ee","client_id":2545,"budget":"121890","updated_at":"2025-08-22 15:17:13","created_at":"2025-01-09 10:12:48","bargain_date":"2025-01-08","collected":"121890","un_collected":0,"pinyin_shortcut":"lx3tesfwqSR650cgxm","description":"","id2":3760,"created_by":1001,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"301.82","erp_profit_amount":"0","erp_j_profit_amount":"-301.82","client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":3746,"from_project":3760,"is_outbound":true},"buildContract":{"id":3746,"from_project":3760,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3763,"project_title":"\u786c\u76d8SAS300GB10K-G-2025","client_id":2021,"budget":"600","updated_at":"2025-02-11 15:20:25","created_at":"2025-01-09 18:29:21","bargain_date":"2025-01-09","collected":"600","un_collected":0,"pinyin_shortcut":"ypSAS300GB10KG2025","description":"","id2":3763,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":2021,"key":2021,"name":"\u65b0\u7586\u535a\u4f17\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3749,"from_project":3763,"is_outbound":true},"buildContract":{"id":3749,"from_project":3763,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3547,"project_title":"\u79d1\u7814\u7ecf\u8d39\u8f6f\u4ef6\u5f00\u53d1\u9879\u76ee","client_id":149,"budget":"205900","updated_at":"2025-06-06 13:24:25","created_at":"2024-05-21 11:57:54","bargain_date":"2025-01-13","collected":"61770","un_collected":144130,"pinyin_shortcut":"kyjfrjkfxm","description":"","id2":3547,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)\uff08\u71d5\u4eac\uff09"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3764,"from_project":3547,"is_outbound":true},"buildContract":{"id":3764,"from_project":3547,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3764,"project_title":"PA1410 \u4e24\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","client_id":2616,"budget":"122000","updated_at":"2025-02-20 09:08:25","created_at":"2025-01-13 16:58:51","bargain_date":"2025-01-13","collected":"122000","un_collected":0,"pinyin_shortcut":"PA1410ltsbcgxm","description":"","id2":3764,"created_by":1001,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":2616,"key":2616,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":3755,"from_project":3764,"is_outbound":true},"buildContract":{"id":3755,"from_project":3764,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3766,"project_title":"POTJ25013202-\u534e\u4e09\u7f51\u7edc\u8bbe\u5907-G-2025","client_id":12,"budget":"20560","updated_at":"2025-02-26 11:32:21","created_at":"2025-01-14 18:03:36","bargain_date":"2025-01-14","collected":"20560","un_collected":0,"pinyin_shortcut":"POTJ25013202hswlsbG2025","description":"","id2":3766,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"144.00","erp_profit_amount":"0","erp_j_profit_amount":"-144.00","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3759,"from_project":3766,"is_outbound":true},"buildContract":{"id":3759,"from_project":3766,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3765,"project_title":"POTJ25013200-\u534e\u4e09\u7f51\u7edc\u8bbe\u59072-G-2025","client_id":12,"budget":"7156","updated_at":"2025-02-24 11:50:41","created_at":"2025-01-14 18:02:02","bargain_date":"2025-01-14","collected":"7156","un_collected":0,"pinyin_shortcut":"POTJ25013200hswlsb2G2025","description":"","id2":3765,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3758,"from_project":3765,"is_outbound":true},"buildContract":{"id":3758,"from_project":3765,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3767,"project_title":"PA440 2\u53f0\u8bbe\u5907\u65b0\u8d2d\u9879\u76ee\u4e8c","client_id":3327,"budget":"121361","updated_at":"2025-04-22 12:20:17","created_at":"2025-01-16 10:05:08","bargain_date":"2025-01-16","collected":"121361","un_collected":0,"pinyin_shortcut":"PA4402tsbxgxme","description":"","id2":3767,"created_by":1001,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":3327,"key":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":3763,"from_project":3767,"is_outbound":true},"buildContract":{"id":3763,"from_project":3767,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3745,"project_title":"netapp\u5b58\u50a8\u7b2c\u4e09\u65b9\u7ef4\u4fdd1\u5e74-2024","client_id":2182,"budget":"76000","updated_at":"2025-02-17 22:18:24","created_at":"2024-12-20 19:44:08","bargain_date":"2025-01-16","collected":"76000","un_collected":0,"pinyin_shortcut":"netappccdsfwb1n2024","description":"","id2":3745,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3761,"from_project":3745,"is_outbound":true},"buildContract":{"id":3761,"from_project":3745,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3768,"project_title":"\u670d\u52a1\u5668\u66f4\u6362\u914d\u4ef6","client_id":1301,"budget":"1320","updated_at":"2025-04-07 14:06:23","created_at":"2025-01-20 10:56:24","bargain_date":"2025-01-20","collected":"1320","un_collected":0,"pinyin_shortcut":"fwqghpj","description":"","id2":3768,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"53.83","erp_profit_amount":"0","erp_j_profit_amount":"-53.83","client":{"id":1301,"key":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3767,"from_project":3768,"is_outbound":true},"buildContract":{"id":3767,"from_project":3768,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3684,"project_title":"2024\u7f51\u7edc\u8bbe\u5907\u7eed\u4fdd","client_id":1121,"budget":"83081","updated_at":"2025-03-10 19:57:57","created_at":"2024-10-15 10:36:10","bargain_date":"2025-01-20","collected":"0","un_collected":83081,"pinyin_shortcut":"2024wlsbxb","description":"","id2":3684,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":1121,"key":1121,"name":"\u5317\u4eac\u4e1c\u65b9\u8ba1\u91cf\u6d4b\u8bd5\u7814\u7a76\u6240"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3768,"from_project":3684,"is_outbound":false},"buildContract":{"id":3768,"from_project":3684,"is_outbound":false},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3762,"project_title":"2025veeam\u8f6f\u4ef6\u7eed\u4fdd","client_id":107,"budget":"74738.2","updated_at":"2025-07-07 16:36:35","created_at":"2025-01-09 11:20:54","bargain_date":"2025-01-22","collected":"74738.2","un_collected":0,"pinyin_shortcut":"2025veeamrjxb","description":"","id2":3762,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"321.95","erp_profit_amount":"0","erp_j_profit_amount":"-321.95","client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3771,"from_project":3762,"is_outbound":true},"buildContract":{"id":3771,"from_project":3762,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3770,"project_title":"\u5353\u8c6a\u7ec8\u7aef\u7ba1\u63a7\u8f6f\u4ef6","client_id":189,"budget":"22200","updated_at":"2025-04-08 15:37:28","created_at":"2025-01-23 20:59:40","bargain_date":"2025-02-07","collected":"22200","un_collected":0,"pinyin_shortcut":"zhzdgkrj","description":"","id2":3770,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":189,"key":189,"name":"\u5317\u4eac\u4eac\u897f\u5b66\u6821"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3790,"from_project":3770,"is_outbound":true},"buildContract":{"id":3790,"from_project":3770,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3780,"project_title":"59\u6240\u56fd\u4ea7\u670d\u52a1\u5668\u91c7\u8d2d -k","client_id":3329,"budget":"277500","updated_at":"2025-08-31 22:56:20","created_at":"2025-02-23 08:25:28","bargain_date":"2025-02-10","collected":"0","un_collected":277500,"pinyin_shortcut":"59sgcfwqcgk","description":"\u7528\u6237\uff1a\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240\uff0c\u4e0b\u5355\u91d1\u989d\uff1a5\u4e07*6=30\u4e07\n\u9f50\u5fc3\u6263\u9664\u5e73\u53f0\u70b97.5\u70b9\u540e\uff0c\u7ed3\u7b97277500","id2":3780,"created_by":5087,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"61.04","erp_profit_amount":"0","erp_j_profit_amount":"-61.04","client":{"id":3329,"key":3329,"name":"\u6df1\u5733\u9f50\u5fc3\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8 (\u8fc7\u5355\uff09"},"createdBy":{"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"}},"buildContract2":{"id":3789,"from_project":3780,"is_outbound":true},"buildContract":{"id":3789,"from_project":3780,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3761,"project_title":"2025\u65b0\u8d2d\u6280\u672f\u670d\u52a1","client_id":107,"budget":"30000","updated_at":"2025-08-19 12:47:56","created_at":"2025-01-09 11:19:50","bargain_date":"2025-02-10","collected":"30000","un_collected":0,"pinyin_shortcut":"2025xgjsfw","description":"","id2":3761,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"283.36","erp_profit_amount":"0","erp_j_profit_amount":"-283.36","client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3777,"from_project":3761,"is_outbound":true},"buildContract":{"id":3777,"from_project":3761,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3773,"project_title":"POBJ25020936-\u56fa\u6001\u786c\u76d8-G-2025","client_id":12,"budget":"1533","updated_at":"2025-02-24 11:50:48","created_at":"2025-02-10 13:26:02","bargain_date":"2025-02-10","collected":"1533","un_collected":0,"pinyin_shortcut":"POBJ25020936gtypG2025","description":"","id2":3773,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3778,"from_project":3773,"is_outbound":true},"buildContract":{"id":3778,"from_project":3773,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3775,"project_title":"POTJ25021715-\u7535\u6e90\u9644\u4ef6-G-2025","client_id":12,"budget":"556","updated_at":"2025-03-12 23:29:18","created_at":"2025-02-11 17:38:49","bargain_date":"2025-02-11","collected":"556","un_collected":0,"pinyin_shortcut":"POTJ25021715dyfjG2025","description":"","id2":3775,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3782,"from_project":3775,"is_outbound":true},"buildContract":{"id":3782,"from_project":3775,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3774,"project_title":"\u6280\u672f\u670d\u52a11\u6b21-G-2025","client_id":97,"budget":"1000","updated_at":"2025-03-07 14:52:08","created_at":"2025-02-10 15:07:47","bargain_date":"2025-02-11","collected":"1000","un_collected":0,"pinyin_shortcut":"jsfw1cG2025","description":"","id2":3774,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":97,"key":97,"name":"\u534e\u745e\u4e16\u7eaa\u63a7\u80a1\u96c6\u56e2\u6709\u9650\u516c\u53f8(\u5c71\u897f\u534e\u745e\u7164\u4e1a\u6709\u9650\u516c\u53f8)"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3787,"from_project":3774,"is_outbound":true},"buildContract":{"id":3787,"from_project":3774,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3772,"project_title":"2025\u65b0\u8d2d4090\u663e\u5361-K","client_id":518,"budget":"28000","updated_at":"2025-07-22 14:48:22","created_at":"2025-02-10 10:23:13","bargain_date":"2025-02-17","collected":"28000","un_collected":0,"pinyin_shortcut":"2025xg4090xkK","description":"","id2":3772,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"58.30","erp_profit_amount":"0","erp_j_profit_amount":"-58.30","client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3796,"from_project":3772,"is_outbound":true},"buildContract":{"id":3796,"from_project":3772,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3776,"project_title":"\u7ea2\u886b\u5b58\u50a8\u786c\u76d8","client_id":48,"budget":"3200","updated_at":"2025-02-26 11:35:01","created_at":"2025-02-12 21:11:37","bargain_date":"2025-02-17","collected":"3200","un_collected":0,"pinyin_shortcut":"hsccyp","description":"","id2":3776,"created_by":1004,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"365.39","erp_profit_amount":"0","erp_j_profit_amount":"-365.39","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3783,"from_project":3776,"is_outbound":true},"buildContract":{"id":3783,"from_project":3776,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3777,"project_title":"2025\u65b0\u8d2d\u6df1\u4fe1\u670dEDR-K","client_id":107,"budget":"35100","updated_at":"2025-08-22 15:18:54","created_at":"2025-02-17 10:18:34","bargain_date":"2025-02-20","collected":"35100","un_collected":0,"pinyin_shortcut":"2025xgsxfEDRK","description":"","id2":3777,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"200.00","erp_profit_amount":"0","erp_j_profit_amount":"-200.00","client":{"id":107,"key":107,"name":"\u84dd\u661f\u4e1c\u4e3d\u819c\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3808,"from_project":3777,"is_outbound":true},"buildContract":{"id":3808,"from_project":3777,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3783,"project_title":"\u58f9\u8fdb\u5236\u8f6f\u4ef6\u8fc7\u5355","client_id":3333,"budget":"2310000","updated_at":"2025-07-07 15:44:00","created_at":"2025-02-26 10:18:25","bargain_date":"2025-02-21","collected":"693000","un_collected":1617000,"pinyin_shortcut":"yjzrjgd","description":"","id2":3783,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":3333,"key":3333,"name":"\u822a\u5929\u56db\u521b\u79d1\u6280\u6709\u9650\u8d23\u4efb\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3795,"from_project":3783,"is_outbound":true},"buildContract":{"id":3795,"from_project":3783,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3785,"project_title":"2025\u65b0\u8d2dUPS","client_id":2546,"budget":"10800","updated_at":"2025-04-07 19:22:52","created_at":"2025-02-27 10:13:36","bargain_date":"2025-02-21","collected":"10800","un_collected":0,"pinyin_shortcut":"2025xgUPS","description":"","id2":3785,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":2546,"key":2546,"name":"\u5317\u4eac\u534e\u4e9a\u4e16\u7eaa\u7535\u5b50\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3797,"from_project":3785,"is_outbound":true},"buildContract":{"id":3797,"from_project":3785,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3782,"project_title":"POBJ25024486-\u56fa\u6001\u786c\u76d8-G-2025","client_id":12,"budget":"629","updated_at":"2025-08-20 17:56:25","created_at":"2025-02-24 11:45:40","bargain_date":"2025-02-24","collected":"629","un_collected":0,"pinyin_shortcut":"POBJ25024486gtypG2025","description":"","id2":3782,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3792,"from_project":3782,"is_outbound":true},"buildContract":{"id":3792,"from_project":3782,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3771,"project_title":"\u6269\u5bb9\u901f\u77f31\u53f0\u8ba1\u7b97\u8282\u70b9","client_id":3281,"budget":"5869.5","updated_at":"2025-04-08 17:02:14","created_at":"2025-01-23 21:10:43","bargain_date":"2025-02-24","collected":"5869.5","un_collected":0,"pinyin_shortcut":"krss1tjsjd","description":"","id2":3771,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":3281,"key":3281,"name":"\u5bd2\u5e8f\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08EDA\uff09"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3791,"from_project":3771,"is_outbound":true},"buildContract":{"id":3791,"from_project":3771,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3786,"project_title":"\u8fdc\u9274\u8f6f\u4ef6-\u8fc7\u7a0b\u76d1\u63a7\u4ea7\u54c1","client_id":3334,"budget":"3048204","updated_at":"2025-03-31 15:45:04","created_at":"2025-02-28 16:22:00","bargain_date":"2025-02-28","collected":"3048204","un_collected":0,"pinyin_shortcut":"yjrjgcjkcp","description":"","id2":3786,"created_by":1001,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":3334,"key":3334,"name":"\u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"buildContract2":{"id":3803,"from_project":3786,"is_outbound":true},"buildContract":{"id":3803,"from_project":3786,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3789,"project_title":"\u7535\u6e90-netapp-FAS2240-2\u5757-G-2025","client_id":4,"budget":"1700","updated_at":"2025-07-15 16:16:20","created_at":"2025-03-04 10:28:11","bargain_date":"2025-03-04","collected":"1700","un_collected":0,"pinyin_shortcut":"dynetappFAS22402kG2025","description":"","id2":3789,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":4,"key":4,"name":"\u6cb3\u5317\u9ad8\u7891\u5e97\u5e02\u5b9c\u4f73\u65fa\u5546\u8d38\u6709\u9650\u516c\u53f8\/\u6cb3\u5317\u5c1a\u548c\u5546\u8d38\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3809,"from_project":3789,"is_outbound":true},"buildContract":{"id":3809,"from_project":3789,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3791,"project_title":"\u786c\u76d81.8T1\u5757-K-2025","client_id":531,"budget":"3150","updated_at":"2025-04-07 11:28:04","created_at":"2025-03-05 17:28:13","bargain_date":"2025-03-05","collected":"3150","un_collected":0,"pinyin_shortcut":"yp18T1kK2025","description":"","id2":3791,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3811,"from_project":3791,"is_outbound":true},"buildContract":{"id":3811,"from_project":3791,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3769,"project_title":"\u897f\u660c\u7f51\u5173-\u589e\u52a0\u670d\u52a1\u8d39","client_id":3326,"budget":"32000","updated_at":"2025-03-31 14:06:31","created_at":"2025-01-21 13:13:23","bargain_date":"2025-03-05","collected":"32000","un_collected":0,"pinyin_shortcut":"xcwgzjfwf","description":"","id2":3769,"created_by":5087,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":3326,"key":3326,"name":"\u4fdd\u5b9a\u6c90\u69ff\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08304\u8fc7\u5355\uff09"},"createdBy":{"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"}},"buildContract2":{"id":3770,"from_project":3769,"is_outbound":true},"buildContract":{"id":3770,"from_project":3769,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3792,"project_title":"IBM\u7535\u6e90\u66f4\u6362","client_id":20,"budget":"500","updated_at":"2025-04-07 11:28:10","created_at":"2025-03-06 09:00:53","bargain_date":"2025-03-06","collected":"500","un_collected":0,"pinyin_shortcut":"IBMdygh","description":"","id2":3792,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":20,"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3812,"from_project":3792,"is_outbound":true},"buildContract":{"id":3812,"from_project":3792,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3794,"project_title":"POBJ25031110-\u56fa\u6001\u786c\u76d8-G-2025","client_id":12,"budget":"511","updated_at":"2025-03-20 17:24:57","created_at":"2025-03-06 19:44:56","bargain_date":"2025-03-06","collected":"511","un_collected":0,"pinyin_shortcut":"POBJ25031110gtypG2025","description":"","id2":3794,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3816,"from_project":3794,"is_outbound":true},"buildContract":{"id":3816,"from_project":3794,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3793,"project_title":"\u9632\u706b\u5899\u6545\u969c\u5904\u7f6e\u548c\u79df\u8d41-G-2025","client_id":2736,"budget":"2500","updated_at":"2025-05-29 10:44:05","created_at":"2025-03-06 16:53:08","bargain_date":"2025-03-10","collected":"2500","un_collected":0,"pinyin_shortcut":"fhqgzczhzlG2025","description":"","id2":3793,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"114.94","erp_profit_amount":"0","erp_j_profit_amount":"-114.94","client":{"id":2736,"key":2736,"name":"\u5317\u4eac\u4e2d\u6570\u521b\u65b0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u7f51\u6839\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8)"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3822,"from_project":3793,"is_outbound":true},"buildContract":{"id":3822,"from_project":3793,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3788,"project_title":"\u65b0\u8d2d\u670d\u52a1\u5668\u786c\u76d8","client_id":518,"budget":"1200","updated_at":"2025-05-30 15:08:42","created_at":"2025-03-03 17:13:54","bargain_date":"2025-03-17","collected":"1200","un_collected":0,"pinyin_shortcut":"xgfwqyp","description":"","id2":3788,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3805,"from_project":3788,"is_outbound":true},"buildContract":{"id":3805,"from_project":3788,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3800,"project_title":"25\u5e74\u9632\u706b\u5899\u7eed\u4fdd","client_id":2032,"budget":"3900","updated_at":"2025-06-09 11:35:45","created_at":"2025-03-17 18:28:37","bargain_date":"2025-03-18","collected":"3900","un_collected":0,"pinyin_shortcut":"25nfhqxb","description":"","id2":3800,"created_by":5295,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3829,"from_project":3800,"is_outbound":true},"buildContract":{"id":3829,"from_project":3800,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3781,"project_title":"\u6df1\u4fe1\u670dAC\u7eed\u4fdd","client_id":1172,"budget":"19100","updated_at":"2025-04-09 16:56:37","created_at":"2025-02-24 09:32:46","bargain_date":"2025-03-18","collected":"19100","un_collected":0,"pinyin_shortcut":"sxfACxb","description":"","id2":3781,"created_by":1004,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":1172,"key":1172,"name":"\u5317\u4eac\u4e2d\u90fd\u661f\u5fbd\u7269\u6d41\u6709\u9650\u516c\u53f8"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3844,"from_project":3781,"is_outbound":true},"buildContract":{"id":3844,"from_project":3781,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3809,"project_title":"\u601d\u4eab\u6df1\u4fe1\u670dEDR2025\u5e74\u7eed\u4fdd","client_id":2226,"budget":"50000","updated_at":"2025-04-08 09:37:11","created_at":"2025-03-27 14:28:53","bargain_date":"2025-03-18","collected":"50000","un_collected":0,"pinyin_shortcut":"sxsxfEDR2025nxb","description":"","id2":3809,"created_by":1005,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":2226,"key":2226,"name":"\u5317\u4eac\u767e\u8fbe\u4fe1\u901a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","department_id":1,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3842,"from_project":3809,"is_outbound":true},"buildContract":{"id":3842,"from_project":3809,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3801,"project_title":"POTJ25034534-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-2025","client_id":12,"budget":"594","updated_at":"2025-04-17 16:25:02","created_at":"2025-03-19 20:04:27","bargain_date":"2025-03-19","collected":"594","un_collected":0,"pinyin_shortcut":"POTJ25034534gtypnct2025","description":"","id2":3801,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3831,"from_project":3801,"is_outbound":true},"buildContract":{"id":3831,"from_project":3801,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""},{"id":3802,"project_title":"POTJ25034538-\u56fa\u6001\u786c\u76d8+\u5185\u5b58\u6761-2025","client_id":12,"budget":"594","updated_at":"2025-04-17 16:24:56","created_at":"2025-03-19 20:08:35","bargain_date":"2025-03-19","collected":"594","un_collected":0,"pinyin_shortcut":"POTJ25034538gtypnct2025","description":"","id2":3802,"created_by":5300,"erp_cost_amount":"0","erp_sales_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","department_id":1,"avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"buildContract2":{"id":3832,"from_project":3802,"is_outbound":true},"buildContract":{"id":3832,"from_project":3802,"is_outbound":true},"erp_profit_pct":"","erp_j_profit_pct":""}],"pagenation":{"totalcount":162,"thispage":1,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-12 16:24:51') RETURNING "id"
16:24:51.427traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:24:51.427traceyii\redis\Connection::executeCommandExecuting Redis Command: SET