ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6868c1aad9786: POST https://beta.jinchangxiao.com/vue/analysis/project-list at 2025-07-05 02:09:46 pm by 223.72.35.175

Log Messages

总计41条数据
TimeLevelCategoryMessage
 
14:09:46.890traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
14:09:46.890traceyii\base\Module::getModuleLoading module: debug
14:09:46.890traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
14:09:46.890traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
14:09:46.890traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
14:09:46.891traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:09:46.891traceyii\base\Module::getModuleLoading module: gii
14:09:46.891traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
14:09:46.891traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
14:09:46.891traceyii\web\Application::handleRequestRoute requested: 'vue/analysis/project-list'
14:09:46.891traceyii\base\Module::getModuleLoading module: vue
14:09:46.891infoyii\web\Session::openSession started
14:09:46.892infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5250
14:09:46.892infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:09:46.896traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:09:46.896traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:09:46.897traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:09:46.897traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:09:46.897infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250
14:09:46.899traceyii\base\Controller::runActionRoute to run: vue/analysis/project-list
14:09:46.899traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:09:46.899traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
14:09:46.899traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\AnalysisController::actionProjectList()
14:09:46.900infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT (final.pstime + final.irtime) AS service_time, (final.pscount + final.ircount) AS service_count, final.* FROM (SELECT CASE WHEN tmp1.pre_sales_counts IS NULL THEN 0 ELSE tmp1.pre_sales_counts END AS pscount, CASE WHEN tmp2.implement_counts IS NULL THEN 0 ELSE tmp2.implement_counts END AS ircount, CASE WHEN tmp1.pre_sales_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp1.pre_sales_times)/3600 ELSE 0 END AS pstime, CASE WHEN tmp2.implement_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp2.implement_times)/3600 ELSE 0 END AS irtime, CASE WHEN tmp3.points IS NOT NULL THEN tmp3.points ELSE 0 END AS points, CASE WHEN tmp4.work_times IS NOT NULL THEN tmp4.work_times ELSE '00:00:00'::interval END AS work_time, CASE WHEN tmp4.work_count IS NOT NULL THEN tmp4.work_count ELSE 0 END AS work_count, CASE WHEN tmp5.reimbursement_amount IS NOT NULL THEN tmp5.reimbursement_amount ELSE 0 END AS reimbursement_amount, p.*, p.budget * profit_pct / 100 AS profits, p.budget - p.collected AS un_collected FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN (SELECT sub1.project_id, count(sub1.id) as pre_sales_counts, sum(sub1.pre_sales_time) as pre_sales_times FROM (SELECT "ps"."id", "c"."project_id", (ps.end_at - ps.start_at) as pre_sales_time FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE "ps"."is_draft"=FALSE) "sub1" GROUP BY "sub1"."project_id") "tmp1" ON tmp1.project_id = p.id LEFT JOIN (SELECT sub2.project_id, count(sub2.id) as implement_counts, sum(sub2.implement_time) as implement_times FROM (SELECT "ir"."id", "c"."project_id", (ir.left_at - ir.arrived_at) as implement_time FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE "ir"."is_draft"=FALSE) "sub2" GROUP BY "sub2"."project_id") "tmp2" ON tmp2.project_id = p.id LEFT JOIN (SELECT sub3.project_id, sum(sub3.points) as points FROM (SELECT "c"."project_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id GROUP BY "c"."id") "sub3" GROUP BY "sub3"."project_id") "tmp3" ON tmp3.project_id = p.id LEFT JOIN (SELECT sub4.project_id, count(sub4.id) as work_count, sum(sub4.work_time) as work_times FROM (SELECT "wl"."id", "wl"."project_id", (wl.end_at - wl.start_at) as work_time FROM "a57be577deb434"."tbl_work_logs" "wl" WHERE ("wl"."is_draft"=FALSE) AND ("wl"."location_in_id" IS NOT NULL) AND ("wl"."location_out_id" IS NOT NULL) AND ("wl"."client_id" IS NOT NULL)) "sub4" GROUP BY "sub4"."project_id") "tmp4" ON tmp4.project_id = p.id LEFT JOIN (SELECT sub5.project_id, sum(sub5.reimbursement_amount) as reimbursement_amount FROM (SELECT "r"."project_id", "r"."amount" AS "reimbursement_amount" FROM "a57be577deb434"."tbl_reimbursements" "r" WHERE "r"."status" IN (2, 3)) "sub5" GROUP BY "sub5"."project_id") "tmp5" ON tmp5.project_id = p.id WHERE ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("p"."project_status"='4')) "final" ORDER BY "bargain_date" DESC) "c"
14:09:46.904infoyii\db\Command::querySELECT SUM(budget) FROM (SELECT (final.pstime + final.irtime) AS service_time, (final.pscount + final.ircount) AS service_count, final.* FROM (SELECT CASE WHEN tmp1.pre_sales_counts IS NULL THEN 0 ELSE tmp1.pre_sales_counts END AS pscount, CASE WHEN tmp2.implement_counts IS NULL THEN 0 ELSE tmp2.implement_counts END AS ircount, CASE WHEN tmp1.pre_sales_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp1.pre_sales_times)/3600 ELSE 0 END AS pstime, CASE WHEN tmp2.implement_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp2.implement_times)/3600 ELSE 0 END AS irtime, CASE WHEN tmp3.points IS NOT NULL THEN tmp3.points ELSE 0 END AS points, CASE WHEN tmp4.work_times IS NOT NULL THEN tmp4.work_times ELSE '00:00:00'::interval END AS work_time, CASE WHEN tmp4.work_count IS NOT NULL THEN tmp4.work_count ELSE 0 END AS work_count, CASE WHEN tmp5.reimbursement_amount IS NOT NULL THEN tmp5.reimbursement_amount ELSE 0 END AS reimbursement_amount, p.*, p.budget * profit_pct / 100 AS profits, p.budget - p.collected AS un_collected FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN (SELECT sub1.project_id, count(sub1.id) as pre_sales_counts, sum(sub1.pre_sales_time) as pre_sales_times FROM (SELECT "ps"."id", "c"."project_id", (ps.end_at - ps.start_at) as pre_sales_time FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE "ps"."is_draft"=FALSE) "sub1" GROUP BY "sub1"."project_id") "tmp1" ON tmp1.project_id = p.id LEFT JOIN (SELECT sub2.project_id, count(sub2.id) as implement_counts, sum(sub2.implement_time) as implement_times FROM (SELECT "ir"."id", "c"."project_id", (ir.left_at - ir.arrived_at) as implement_time FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE "ir"."is_draft"=FALSE) "sub2" GROUP BY "sub2"."project_id") "tmp2" ON tmp2.project_id = p.id LEFT JOIN (SELECT sub3.project_id, sum(sub3.points) as points FROM (SELECT "c"."project_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id GROUP BY "c"."id") "sub3" GROUP BY "sub3"."project_id") "tmp3" ON tmp3.project_id = p.id LEFT JOIN (SELECT sub4.project_id, count(sub4.id) as work_count, sum(sub4.work_time) as work_times FROM (SELECT "wl"."id", "wl"."project_id", (wl.end_at - wl.start_at) as work_time FROM "a57be577deb434"."tbl_work_logs" "wl" WHERE ("wl"."is_draft"=FALSE) AND ("wl"."location_in_id" IS NOT NULL) AND ("wl"."location_out_id" IS NOT NULL) AND ("wl"."client_id" IS NOT NULL)) "sub4" GROUP BY "sub4"."project_id") "tmp4" ON tmp4.project_id = p.id LEFT JOIN (SELECT sub5.project_id, sum(sub5.reimbursement_amount) as reimbursement_amount FROM (SELECT "r"."project_id", "r"."amount" AS "reimbursement_amount" FROM "a57be577deb434"."tbl_reimbursements" "r" WHERE "r"."status" IN (2, 3)) "sub5" GROUP BY "sub5"."project_id") "tmp5" ON tmp5.project_id = p.id WHERE ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("p"."project_status"='4')) "final" ORDER BY "bargain_date" DESC) "c"
14:09:46.906infoyii\db\Command::querySELECT SUM(budget / 100 * profit_pct) FROM (SELECT (final.pstime + final.irtime) AS service_time, (final.pscount + final.ircount) AS service_count, final.* FROM (SELECT CASE WHEN tmp1.pre_sales_counts IS NULL THEN 0 ELSE tmp1.pre_sales_counts END AS pscount, CASE WHEN tmp2.implement_counts IS NULL THEN 0 ELSE tmp2.implement_counts END AS ircount, CASE WHEN tmp1.pre_sales_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp1.pre_sales_times)/3600 ELSE 0 END AS pstime, CASE WHEN tmp2.implement_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp2.implement_times)/3600 ELSE 0 END AS irtime, CASE WHEN tmp3.points IS NOT NULL THEN tmp3.points ELSE 0 END AS points, CASE WHEN tmp4.work_times IS NOT NULL THEN tmp4.work_times ELSE '00:00:00'::interval END AS work_time, CASE WHEN tmp4.work_count IS NOT NULL THEN tmp4.work_count ELSE 0 END AS work_count, CASE WHEN tmp5.reimbursement_amount IS NOT NULL THEN tmp5.reimbursement_amount ELSE 0 END AS reimbursement_amount, p.*, p.budget * profit_pct / 100 AS profits, p.budget - p.collected AS un_collected FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN (SELECT sub1.project_id, count(sub1.id) as pre_sales_counts, sum(sub1.pre_sales_time) as pre_sales_times FROM (SELECT "ps"."id", "c"."project_id", (ps.end_at - ps.start_at) as pre_sales_time FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE "ps"."is_draft"=FALSE) "sub1" GROUP BY "sub1"."project_id") "tmp1" ON tmp1.project_id = p.id LEFT JOIN (SELECT sub2.project_id, count(sub2.id) as implement_counts, sum(sub2.implement_time) as implement_times FROM (SELECT "ir"."id", "c"."project_id", (ir.left_at - ir.arrived_at) as implement_time FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE "ir"."is_draft"=FALSE) "sub2" GROUP BY "sub2"."project_id") "tmp2" ON tmp2.project_id = p.id LEFT JOIN (SELECT sub3.project_id, sum(sub3.points) as points FROM (SELECT "c"."project_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id GROUP BY "c"."id") "sub3" GROUP BY "sub3"."project_id") "tmp3" ON tmp3.project_id = p.id LEFT JOIN (SELECT sub4.project_id, count(sub4.id) as work_count, sum(sub4.work_time) as work_times FROM (SELECT "wl"."id", "wl"."project_id", (wl.end_at - wl.start_at) as work_time FROM "a57be577deb434"."tbl_work_logs" "wl" WHERE ("wl"."is_draft"=FALSE) AND ("wl"."location_in_id" IS NOT NULL) AND ("wl"."location_out_id" IS NOT NULL) AND ("wl"."client_id" IS NOT NULL)) "sub4" GROUP BY "sub4"."project_id") "tmp4" ON tmp4.project_id = p.id LEFT JOIN (SELECT sub5.project_id, sum(sub5.reimbursement_amount) as reimbursement_amount FROM (SELECT "r"."project_id", "r"."amount" AS "reimbursement_amount" FROM "a57be577deb434"."tbl_reimbursements" "r" WHERE "r"."status" IN (2, 3)) "sub5" GROUP BY "sub5"."project_id") "tmp5" ON tmp5.project_id = p.id WHERE ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("p"."project_status"='4')) "final" ORDER BY "bargain_date" DESC) "c"
14:09:46.909infoyii\db\Command::querySELECT SUM(collected) FROM (SELECT (final.pstime + final.irtime) AS service_time, (final.pscount + final.ircount) AS service_count, final.* FROM (SELECT CASE WHEN tmp1.pre_sales_counts IS NULL THEN 0 ELSE tmp1.pre_sales_counts END AS pscount, CASE WHEN tmp2.implement_counts IS NULL THEN 0 ELSE tmp2.implement_counts END AS ircount, CASE WHEN tmp1.pre_sales_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp1.pre_sales_times)/3600 ELSE 0 END AS pstime, CASE WHEN tmp2.implement_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp2.implement_times)/3600 ELSE 0 END AS irtime, CASE WHEN tmp3.points IS NOT NULL THEN tmp3.points ELSE 0 END AS points, CASE WHEN tmp4.work_times IS NOT NULL THEN tmp4.work_times ELSE '00:00:00'::interval END AS work_time, CASE WHEN tmp4.work_count IS NOT NULL THEN tmp4.work_count ELSE 0 END AS work_count, CASE WHEN tmp5.reimbursement_amount IS NOT NULL THEN tmp5.reimbursement_amount ELSE 0 END AS reimbursement_amount, p.*, p.budget * profit_pct / 100 AS profits, p.budget - p.collected AS un_collected FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN (SELECT sub1.project_id, count(sub1.id) as pre_sales_counts, sum(sub1.pre_sales_time) as pre_sales_times FROM (SELECT "ps"."id", "c"."project_id", (ps.end_at - ps.start_at) as pre_sales_time FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE "ps"."is_draft"=FALSE) "sub1" GROUP BY "sub1"."project_id") "tmp1" ON tmp1.project_id = p.id LEFT JOIN (SELECT sub2.project_id, count(sub2.id) as implement_counts, sum(sub2.implement_time) as implement_times FROM (SELECT "ir"."id", "c"."project_id", (ir.left_at - ir.arrived_at) as implement_time FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE "ir"."is_draft"=FALSE) "sub2" GROUP BY "sub2"."project_id") "tmp2" ON tmp2.project_id = p.id LEFT JOIN (SELECT sub3.project_id, sum(sub3.points) as points FROM (SELECT "c"."project_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id GROUP BY "c"."id") "sub3" GROUP BY "sub3"."project_id") "tmp3" ON tmp3.project_id = p.id LEFT JOIN (SELECT sub4.project_id, count(sub4.id) as work_count, sum(sub4.work_time) as work_times FROM (SELECT "wl"."id", "wl"."project_id", (wl.end_at - wl.start_at) as work_time FROM "a57be577deb434"."tbl_work_logs" "wl" WHERE ("wl"."is_draft"=FALSE) AND ("wl"."location_in_id" IS NOT NULL) AND ("wl"."location_out_id" IS NOT NULL) AND ("wl"."client_id" IS NOT NULL)) "sub4" GROUP BY "sub4"."project_id") "tmp4" ON tmp4.project_id = p.id LEFT JOIN (SELECT sub5.project_id, sum(sub5.reimbursement_amount) as reimbursement_amount FROM (SELECT "r"."project_id", "r"."amount" AS "reimbursement_amount" FROM "a57be577deb434"."tbl_reimbursements" "r" WHERE "r"."status" IN (2, 3)) "sub5" GROUP BY "sub5"."project_id") "tmp5" ON tmp5.project_id = p.id WHERE ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("p"."project_status"='4')) "final" ORDER BY "bargain_date" DESC) "c"
14:09:46.911infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT (final.pstime + final.irtime) AS service_time, (final.pscount + final.ircount) AS service_count, final.* FROM (SELECT CASE WHEN tmp1.pre_sales_counts IS NULL THEN 0 ELSE tmp1.pre_sales_counts END AS pscount, CASE WHEN tmp2.implement_counts IS NULL THEN 0 ELSE tmp2.implement_counts END AS ircount, CASE WHEN tmp1.pre_sales_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp1.pre_sales_times)/3600 ELSE 0 END AS pstime, CASE WHEN tmp2.implement_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp2.implement_times)/3600 ELSE 0 END AS irtime, CASE WHEN tmp3.points IS NOT NULL THEN tmp3.points ELSE 0 END AS points, CASE WHEN tmp4.work_times IS NOT NULL THEN tmp4.work_times ELSE '00:00:00'::interval END AS work_time, CASE WHEN tmp4.work_count IS NOT NULL THEN tmp4.work_count ELSE 0 END AS work_count, CASE WHEN tmp5.reimbursement_amount IS NOT NULL THEN tmp5.reimbursement_amount ELSE 0 END AS reimbursement_amount, p.*, p.budget * profit_pct / 100 AS profits, p.budget - p.collected AS un_collected FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN (SELECT sub1.project_id, count(sub1.id) as pre_sales_counts, sum(sub1.pre_sales_time) as pre_sales_times FROM (SELECT "ps"."id", "c"."project_id", (ps.end_at - ps.start_at) as pre_sales_time FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE "ps"."is_draft"=FALSE) "sub1" GROUP BY "sub1"."project_id") "tmp1" ON tmp1.project_id = p.id LEFT JOIN (SELECT sub2.project_id, count(sub2.id) as implement_counts, sum(sub2.implement_time) as implement_times FROM (SELECT "ir"."id", "c"."project_id", (ir.left_at - ir.arrived_at) as implement_time FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE "ir"."is_draft"=FALSE) "sub2" GROUP BY "sub2"."project_id") "tmp2" ON tmp2.project_id = p.id LEFT JOIN (SELECT sub3.project_id, sum(sub3.points) as points FROM (SELECT "c"."project_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id GROUP BY "c"."id") "sub3" GROUP BY "sub3"."project_id") "tmp3" ON tmp3.project_id = p.id LEFT JOIN (SELECT sub4.project_id, count(sub4.id) as work_count, sum(sub4.work_time) as work_times FROM (SELECT "wl"."id", "wl"."project_id", (wl.end_at - wl.start_at) as work_time FROM "a57be577deb434"."tbl_work_logs" "wl" WHERE ("wl"."is_draft"=FALSE) AND ("wl"."location_in_id" IS NOT NULL) AND ("wl"."location_out_id" IS NOT NULL) AND ("wl"."client_id" IS NOT NULL)) "sub4" GROUP BY "sub4"."project_id") "tmp4" ON tmp4.project_id = p.id LEFT JOIN (SELECT sub5.project_id, sum(sub5.reimbursement_amount) as reimbursement_amount FROM (SELECT "r"."project_id", "r"."amount" AS "reimbursement_amount" FROM "a57be577deb434"."tbl_reimbursements" "r" WHERE "r"."status" IN (2, 3)) "sub5" GROUP BY "sub5"."project_id") "tmp5" ON tmp5.project_id = p.id WHERE ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("p"."project_status"='4')) "final" ORDER BY "bargain_date" DESC) "c"
14:09:46.913infoyii\db\Command::querySELECT (final.pstime + final.irtime) AS service_time, (final.pscount + final.ircount) AS service_count, final.* FROM (SELECT CASE WHEN tmp1.pre_sales_counts IS NULL THEN 0 ELSE tmp1.pre_sales_counts END AS pscount, CASE WHEN tmp2.implement_counts IS NULL THEN 0 ELSE tmp2.implement_counts END AS ircount, CASE WHEN tmp1.pre_sales_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp1.pre_sales_times)/3600 ELSE 0 END AS pstime, CASE WHEN tmp2.implement_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp2.implement_times)/3600 ELSE 0 END AS irtime, CASE WHEN tmp3.points IS NOT NULL THEN tmp3.points ELSE 0 END AS points, CASE WHEN tmp4.work_times IS NOT NULL THEN tmp4.work_times ELSE '00:00:00'::interval END AS work_time, CASE WHEN tmp4.work_count IS NOT NULL THEN tmp4.work_count ELSE 0 END AS work_count, CASE WHEN tmp5.reimbursement_amount IS NOT NULL THEN tmp5.reimbursement_amount ELSE 0 END AS reimbursement_amount, p.*, p.budget * profit_pct / 100 AS profits, p.budget - p.collected AS un_collected FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN (SELECT sub1.project_id, count(sub1.id) as pre_sales_counts, sum(sub1.pre_sales_time) as pre_sales_times FROM (SELECT "ps"."id", "c"."project_id", (ps.end_at - ps.start_at) as pre_sales_time FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE "ps"."is_draft"=FALSE) "sub1" GROUP BY "sub1"."project_id") "tmp1" ON tmp1.project_id = p.id LEFT JOIN (SELECT sub2.project_id, count(sub2.id) as implement_counts, sum(sub2.implement_time) as implement_times FROM (SELECT "ir"."id", "c"."project_id", (ir.left_at - ir.arrived_at) as implement_time FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE "ir"."is_draft"=FALSE) "sub2" GROUP BY "sub2"."project_id") "tmp2" ON tmp2.project_id = p.id LEFT JOIN (SELECT sub3.project_id, sum(sub3.points) as points FROM (SELECT "c"."project_id", sum(ca.points) as points FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id GROUP BY "c"."id") "sub3" GROUP BY "sub3"."project_id") "tmp3" ON tmp3.project_id = p.id LEFT JOIN (SELECT sub4.project_id, count(sub4.id) as work_count, sum(sub4.work_time) as work_times FROM (SELECT "wl"."id", "wl"."project_id", (wl.end_at - wl.start_at) as work_time FROM "a57be577deb434"."tbl_work_logs" "wl" WHERE ("wl"."is_draft"=FALSE) AND ("wl"."location_in_id" IS NOT NULL) AND ("wl"."location_out_id" IS NOT NULL) AND ("wl"."client_id" IS NOT NULL)) "sub4" GROUP BY "sub4"."project_id") "tmp4" ON tmp4.project_id = p.id LEFT JOIN (SELECT sub5.project_id, sum(sub5.reimbursement_amount) as reimbursement_amount FROM (SELECT "r"."project_id", "r"."amount" AS "reimbursement_amount" FROM "a57be577deb434"."tbl_reimbursements" "r" WHERE "r"."status" IN (2, 3)) "sub5" GROUP BY "sub5"."project_id") "tmp5" ON tmp5.project_id = p.id WHERE ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420')) AND ("p"."project_status"='4')) "final" ORDER BY "bargain_date" DESC LIMIT 20
14:09:46.939infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2241, 2196, 3320, 3306, 3318, 2716, 2240, 2504, 1509, 2565, 656, 121, 2805, 93, 528, 2130, 402, 2125, 2806)
14:09:46.940infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 1004, 5300, 5329, 1005, 5087)
14:09:46.940infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 5329, 1005, 5087, 1004, 5300))
14:09:46.941traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:09:46.942traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:09:46.942infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5250) AND ("object_type"=23) AND ("visit_date"='2025-07-05')
14:09:46.945traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:09:46.945traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:09:46.945infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=189, "last_visit_at"='now()' WHERE "id"=49799
14:09:46.947infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5250, 5, 'vue/analysis/project-list', '{"dataUserId":"1001,1004,1005,1013,5087,5295,5300,5311,5329,5332,5420","page":"1","status":"status4","web_access_token":"lF6lDSiCl5CRIFfE8shlx2wSeme229Hs"}', '{"code":2000,"result":{"list":[{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":2967,"client_id":2241,"project_status":4,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":"Netapp\u5b58\u50a8FAS8300","created_by":5295,"created_at":"2022-08-30 11:53:43","updated_at":"2022-09-05 19:06:04","engineer_id":null,"project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2022-09-05 19:06:04.880814+08","success_rate":null,"comment":"Netapp\u5b58\u50a8FAS8300\r\n","contract_type":null,"progress_updated_at":"2022-08-30 11:53:43.050918+08","forecast_updated_at":"2022-08-30 11:53:43.050918+08","end_at":"2022-09-05 19:06:04","pinyin_shortcut":"wsz","creator":1011,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"0.00000000000000000000","un_collected":"0","client":{"id":2241,"key":2241,"name":"\u5317\u4eac\u667a\u82af\u4eff\u771f\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":13},"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"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":2871,"client_id":2196,"project_status":4,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":"RS820+ ","created_by":5295,"created_at":"2022-06-13 14:59:22","updated_at":"2022-06-15 10:04:23","engineer_id":null,"project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2022-06-15 10:04:23.618069+08","success_rate":null,"comment":"RS820+ \r\n","contract_type":null,"progress_updated_at":"2022-06-13 14:59:22.472093+08","forecast_updated_at":"2022-06-13 14:59:22.472093+08","end_at":"2022-06-15 10:04:23","pinyin_shortcut":"wsz","creator":5015,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"0.00000000000000000000","un_collected":"0","client":{"id":2196,"key":2196,"name":"\u5317\u4eac\u4e09\u805a\u73af\u4fdd\u65b0\u6750\u6599\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":20},"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"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":3715,"client_id":3320,"project_status":4,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":null,"created_by":1004,"created_at":"2024-11-14 12:52:56","updated_at":"2024-11-17 18:02:34","engineer_id":null,"project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2024-11-17 18:02:34.43606+08","success_rate":null,"comment":"\u7fa4\u6656\u5b58\u50a8\u5916\u52a0\u5185\u5b58\u548c\u786c\u76d8","contract_type":null,"progress_updated_at":"2024-11-14 12:52:56.657952+08","forecast_updated_at":"2024-11-14 12:52:56.657952+08","end_at":"2024-11-17 18:02:34","pinyin_shortcut":"wsz","creator":5413,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"0.00000000000000000000","un_collected":"0","client":{"id":3320,"key":3320,"name":"\u56fd\u5bb6\u6c14\u5019\u4e2d\u5fc3","logo":null,"client_type":null,"client_class":null,"client_industry":null},"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\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":1.23,"work_count":1,"reimbursement_amount":"47","id":3668,"client_id":3306,"project_status":4,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":null,"created_by":5300,"created_at":"2024-09-23 10:22:46","updated_at":"2024-10-17 14:53:48","engineer_id":null,"project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2024-09-29 18:46:27.236074+08","success_rate":null,"comment":"\u5185\u5bb9\u9632\u62a4\uff0c\u9632\u5fa1\uff0c\u706b\u773c","contract_type":null,"progress_updated_at":"2024-09-23 10:22:46.834714+08","forecast_updated_at":"2024-09-23 10:22:46.834714+08","end_at":"2024-09-29 18:46:27","pinyin_shortcut":"wsz","creator":5413,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"0.00000000000000000000","un_collected":"0","client":{"id":3306,"key":3306,"name":"\u5317\u4eac\u534e\u6052\u4fe1\u5b89\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":null,"client_class":null,"client_industry":null},"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"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":3711,"client_id":3318,"project_status":4,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":null,"created_by":1004,"created_at":"2024-11-12 11:31:02","updated_at":"2024-11-17 18:02:27","engineer_id":null,"project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2024-11-17 18:02:27.68113+08","success_rate":null,"comment":"\u5b58\u50a8\u8bbe\u5907","contract_type":null,"progress_updated_at":"2024-11-12 11:31:02.097807+08","forecast_updated_at":"2024-11-12 11:31:02.097807+08","end_at":"2024-11-17 18:02:27","pinyin_shortcut":"wsz","creator":5413,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"0.00000000000000000000","un_collected":"0","client":{"id":3318,"key":3318,"name":"\u4f5c\u5bb6\u51fa\u7248\u793e\u6709\u9650\u516c\u53f8","logo":null,"client_type":null,"client_class":null,"client_industry":null},"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\/fc8d836d-8085-35fc-8a48-54a276f664a6.png"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":3369,"client_id":2716,"project_status":4,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":null,"created_by":5329,"created_at":"2023-11-22 10:38:58","updated_at":"2023-11-27 10:52:17","engineer_id":null,"project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2023-11-27 10:52:17.158561+08","success_rate":null,"comment":"\u7fa4\u6656\u786c\u76d8\n","contract_type":null,"progress_updated_at":"2023-11-22 10:38:58.184873+08","forecast_updated_at":"2023-11-22 10:38:58.184873+08","end_at":"2023-11-27 10:52:17","pinyin_shortcut":"wsz","creator":5015,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"0.00000000000000000000","un_collected":"0","client":{"id":2716,"key":2716,"name":"\u4e2d\u56fd\u91d1\u878d\u57f9\u8bad\u4e2d\u5fc3","logo":null,"client_type":null,"client_class":null,"client_industry":null},"createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","department_id":1,"avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":2966,"client_id":2240,"project_status":4,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":"\u5355\u4f4d\u8981\u505a\u7f51\u7edc\u5b89\u5168\u7684\u90e8\u7f72\uff0c2023\u5e74\u4e0a\u534a\u5e74\u9700\u8981\u91c7\u8d2d\u9632\u706b\u5899\u548c\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\uff0c\u7528\u4e8e\u6570\u636e\u4e2d\u5fc3\u5b89\u5168\u52a0\u56fa\uff0c10\u53f0\u5de6\u53f3\u670d\u52a1\u5668\uff0c\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u4e3b\u8981\u89e3\u51b3\u4e0a\u7f51\u884c\u4e3a\u5ba1\u8ba1\u3001\u6d41\u91cf\u9650\u5236\u3001\u6587\u4ef6\u9632\u6cc4\u5bc6\uff0c\u7ba1\u63a7300\u4e2a\u4fe1\u606f\u70b9\u5185\uff0c\u5e26\u5bbd\u662f500\u5146\uff0c\u8003\u8651\u6df1\u4fe1\u670d\u4ea7\u54c1\uff1b\u5e74\u5e95\u505a\u8ba1\u5212\uff0c\u9884\u7b9750\u4e07\u5de6\u53f3","created_by":5295,"created_at":"2022-08-30 09:23:04","updated_at":"2022-09-05 19:06:41","engineer_id":null,"project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2022-09-05 19:06:41.544038+08","success_rate":null,"comment":"\u5355\u4f4d\u8981\u505a\u7f51\u7edc\u5b89\u5168\u7684\u90e8\u7f72\uff0c2023\u5e74\u4e0a\u534a\u5e74\u9700\u8981\u91c7\u8d2d\u9632\u706b\u5899\u548c\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\uff0c\u7528\u4e8e\u6570\u636e\u4e2d\u5fc3\u5b89\u5168\u52a0\u56fa\uff0c10\u53f0\u5de6\u53f3\u670d\u52a1\u5668\uff0c\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406\u4e3b\u8981\u89e3\u51b3\u4e0a\u7f51\u884c\u4e3a\u5ba1\u8ba1\u3001\u6d41\u91cf\u9650\u5236\u3001\u6587\u4ef6\u9632\u6cc4\u5bc6\uff0c\u7ba1\u63a7300\u4e2a\u4fe1\u606f\u70b9\u5185\uff0c\u5e26\u5bbd\u662f500\u5146\uff0c\u8003\u8651\u6df1\u4fe1\u670d\u4ea7\u54c1\uff1b\u5e74\u5e95\u505a\u8ba1\u5212\uff0c\u9884\u7b9750\u4e07\u5de6\u53f3\r\n","contract_type":null,"progress_updated_at":"2022-08-30 09:23:04.941315+08","forecast_updated_at":"2022-08-30 09:23:04.941315+08","end_at":"2022-09-05 19:06:41","pinyin_shortcut":"wsz","creator":5298,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"0.00000000000000000000","un_collected":"0","client":{"id":2240,"key":2240,"name":"\u5317\u4eac\u4e2d\u5e86\u878d\u901a\u6295\u8d44\u57fa\u91d1\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":null,"client_type":null,"client_class":null,"client_industry":null},"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"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":3094,"client_id":2504,"project_status":4,"project_progress":2,"budget":"0","profit_pct":"0","bargain_date":null,"description":"\u7269\u8054\u7f51\u5b89\u5168\n","created_by":1005,"created_at":"2023-01-31 10:07:58","updated_at":"2023-02-06 17:47:26","engineer_id":null,"project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2023-02-06 17:46:56.197168+08","success_rate":null,"comment":"\u7269\u8054\u7f51\u5b89\u5168\n\r\n\u8054\u7cfb\u4e0d\u4e0a\u5ba2\u6237","contract_type":null,"progress_updated_at":"2023-02-05 22:24:30.988626+08","forecast_updated_at":"2023-02-06 17:46:56.197168+08","end_at":"2023-02-06 17:47:26","pinyin_shortcut":"wsz","creator":5015,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"0.00000000000000000000","un_collected":"0","client":{"id":2504,"key":2504,"name":"\u6d77\u5c14\u79d1\u6280","logo":null,"client_type":null,"client_class":null,"client_industry":null},"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"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":1.07,"work_count":1,"reimbursement_amount":"0","id":2675,"client_id":1509,"project_status":4,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":"vmware\u865a\u62df\u5316\u96c6\u7fa4","created_by":5329,"created_at":"2021-10-27 12:06:59","updated_at":"2022-10-24 16:15:07","engineer_id":null,"project_title":"\u89e3\u51b3\u670d\u52a1\u5668\u96be\u7ba1\u7406\u95ee\u9898","collected":"0","status_updated_at":"2022-10-24 16:15:07.719968+08","success_rate":null,"comment":"vmware\u865a\u62df\u5316\u96c6\u7fa4\r\n10\u53f0\u8001\u65e7\u8bbe\u5907\uff0c\u4e3b\u8981\u505a\u8f6f\u4ef6\u6d4b\u8bd5\u5f00\u53d1\uff0c\u7ba1\u7406\u96be\u5ea6\u5927\u3002","contract_type":null,"progress_updated_at":"2022-05-20 17:13:02.176769+08","forecast_updated_at":"2022-05-20 17:13:02.176769+08","end_at":"2022-10-24 16:15:07","pinyin_shortcut":"jjfwqnglwt","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"0.00000000000000000000","un_collected":"0","client":{"id":1509,"key":1509,"name":"\u4e2d\u79d1\u5927\u8111","logo":null,"client_type":6,"client_class":43,"client_industry":1},"createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","department_id":1,"avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":3262,"client_id":2565,"project_status":4,"project_progress":null,"budget":"0","profit_pct":"0","bargain_date":null,"description":"\u7fa4\u6656\u5b58\u50a8","created_by":5329,"created_at":"2023-07-20 09:31:32","updated_at":"2024-01-26 18:11:35","engineer_id":null,"project_title":"(\u672a\u8bbe\u7f6e)","collected":"0","status_updated_at":"2023-07-24 11:02:58.578771+08","success_rate":null,"comment":"\u7fa4\u6656\u5b58\u50a8\r\n","contract_type":null,"progress_updated_at":"2023-07-20 09:31:32.375546+08","forecast_updated_at":"2023-07-20 09:31:32.375546+08","end_at":"2024-01-26 18:11:35","pinyin_shortcut":"wsz","creator":5015,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":true,"collected_plan":null,"profits":"0.00000000000000000000","un_collected":"0","client":{"id":2565,"key":2565,"name":"\u4e2d\u56fd\u4fe1\u606f\u79d1\u5b66\u4e2d\u5fc3\uff08\u96c6\u6210\u5546\uff09","logo":null,"client_type":5,"client_class":43,"client_industry":20},"createdBy":{"id":5329,"key":5329,"name":"\u9ad8\u5ce5","sex":"M","department_id":1,"avatar":{"id":147,"user_id":5329,"name":"\/files\/cdn\/a57be577deb434\/avatar\/0d79e7ec-ac2a-3ab6-8cf3-b8c7ee1d0b71.png"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":2648,"client_id":656,"project_status":4,"project_progress":1,"budget":"30000","profit_pct":"10","bargain_date":null,"description":"\u6df1\u4fe1\u670d\u9632\u706b\u5899 1\u53f0 \u9884\u7b9730000","created_by":5300,"created_at":"2021-09-06 15:47:07","updated_at":"2021-09-06 17:09:51","engineer_id":null,"project_title":"\u6df1\u4fe1\u670dAF","collected":"0","status_updated_at":"2021-09-06 17:09:51.32576+08","success_rate":null,"comment":"\u6df1\u4fe1\u670d\u9632\u706b\u5899 1\u53f0 \u9884\u7b9730000\r\n\u51b3\u7b56\u6d41\u7a0b\uff1a\n\u89e3\u51b3\u4ec0\u4e48\u95ee\u9898\uff1a\n\u7ade\u4e89\u5bf9\u624b\uff1a","contract_type":1,"progress_updated_at":"2021-09-06 15:47:07.395216+08","forecast_updated_at":"2021-09-06 15:47:07.395216+08","end_at":"2021-09-06 17:09:51","pinyin_shortcut":"sxfAF","creator":5300,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"3000.0000000000000000","un_collected":"30000","client":{"id":656,"key":656,"name":"\u5317\u4eac\u58f0\u8fc5\u7535\u5b50\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":43,"client_industry":20},"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"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":2559,"client_id":121,"project_status":4,"project_progress":2,"budget":"549696","profit_pct":"20","bargain_date":null,"description":"\u601d\u79d1\u539f\u5382\u7eed\u4fdd","created_by":5295,"created_at":"2021-05-31 14:27:22","updated_at":"2022-04-06 12:57:08","engineer_id":null,"project_title":"\u601d\u79d1\u539f\u5382\u7eed\u4fdd","collected":"0","status_updated_at":"2022-04-06 12:57:08.67104+08","success_rate":null,"comment":"\u601d\u79d1\u539f\u5382\u7eed\u4fdd\r\n\u5931\u8d25\u539f\u56e0\uff1a\u4ef7\u683c\u9ad8\uff0c\u540e\u671f\u8bbe\u5907\u4e0d\u7528\u4e86","contract_type":2,"progress_updated_at":"2021-05-31 14:27:22.118932+08","forecast_updated_at":"2021-07-12 14:52:39.058352+08","end_at":"2022-04-06 12:57:08","pinyin_shortcut":"skycxb","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"109939.200000000000","un_collected":"549696","client":{"id":121,"key":121,"name":"\u56db\u5ddd\u6d77\u5e95\u635e\u9910\u996e\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u9890\u6d77(\u4e0a\u6d77)\u98df\u54c1\u6709\u9650\u516c\u53f8\u3001\u6d77\u9e3f\u8fbe\u3001\u90d1\u5dde\u8700\u6d77)","logo":null,"client_type":1,"client_class":80,"client_industry":6},"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"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":3787,"client_id":2805,"project_status":4,"project_progress":4,"budget":"100000","profit_pct":"10","bargain_date":"2025-05-31","description":null,"created_by":5295,"created_at":"2025-03-03 09:56:33","updated_at":"2025-03-17 10:54:03","engineer_id":null,"project_title":"\u65b0\u8d2d\u548c\u7eed\u4fdd\u901f\u77f3\u8f6f\u4ef6","collected":"0","status_updated_at":"2025-03-17 10:54:03.744261+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2025-03-03 09:56:33.964579+08","forecast_updated_at":"2025-03-17 10:54:03.744261+08","end_at":"2025-03-17 10:54:03","pinyin_shortcut":"xghxbssrj","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"10000.0000000000000000","un_collected":"100000","client":{"id":2805,"key":2805,"name":"\u5317\u4eac\u65e0\u95ee\u82af\u7a79\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u4e0a\u6d77\u65e0\u95ee\u82af\u7a79\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09(EDA)","logo":null,"client_type":5,"client_class":43,"client_industry":57},"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"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":2.55,"work_count":1,"reimbursement_amount":"0","id":3702,"client_id":93,"project_status":4,"project_progress":4,"budget":"700000","profit_pct":"15","bargain_date":"2025-05-01","description":null,"created_by":1005,"created_at":"2024-10-27 21:13:01","updated_at":"2025-03-10 11:56:25","engineer_id":null,"project_title":"\u7b2c\u4e8c\u56ed\u533a\u5185\u7f51\u9632\u706b\u5899-PA","collected":"0","status_updated_at":"2025-03-10 11:56:25.978057+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-10-27 21:47:41.442924+08","forecast_updated_at":"2025-02-17 10:53:22.589222+08","end_at":"2025-03-10 11:56:25","pinyin_shortcut":"deyqnwfhqPA","creator":1005,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":true,"collected_plan":null,"profits":"105000.000000000000","un_collected":"700000","client":{"id":93,"key":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":3,"client_class":47,"client_industry":5},"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"}}},{"service_time":"56.25","service_count":10,"pscount":0,"ircount":10,"pstime":"0","irtime":"56.25","points":"565","work_time":0,"work_count":0,"reimbursement_amount":"122","id":3594,"client_id":528,"project_status":4,"project_progress":3,"budget":"50000","profit_pct":"10","bargain_date":"2025-04-30","description":null,"created_by":5295,"created_at":"2024-07-12 16:55:31","updated_at":"2025-01-20 15:50:58","engineer_id":null,"project_title":"\u65b0\u8d2d\u9752\u85e4\u6f0f\u6d1e\u65e0\u6548\u5316\u4ea7\u54c1","collected":"0","status_updated_at":"2025-01-20 15:50:58.714838+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-07-12 16:55:31.728914+08","forecast_updated_at":"2025-01-20 15:50:58.714838+08","end_at":"2025-01-20 15:50:58","pinyin_shortcut":"xgqtldwxhcp","creator":5295,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":true,"collected_plan":null,"profits":"5000.0000000000000000","un_collected":"50000","client":{"id":528,"key":528,"name":"\u5317\u4eac\u8bfa\u8bda\u5065\u534e\u533b\u836f\u79d1\u6280\u6709\u9650\u516c\u53f8(\u5357\u4eac\u5929\u5370\u5065\u534e\u533b\u836f\u79d1\u6280\u6709\u9650\u516c\u53f8;\u5317\u4eac\u5929\u8bda\u533b\u836f\u79d1\u6280\u6709\u9650\u516c\u53f8;\u5317\u4eac\u6c47\u8bda\u5065\u534e)","logo":null,"client_type":1,"client_class":80,"client_industry":5},"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"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"3184.71","id":2777,"client_id":2130,"project_status":4,"project_progress":5,"budget":"250000","profit_pct":"22","bargain_date":"2025-03-31","description":"\u5de5\u63a7\u673a22\u53f0 \u89e6\u63a7\u5c4f\u5e558\u53f0 \u4e00\u4f53\u673a16\u53f0","created_by":5087,"created_at":"2022-03-07 11:48:43","updated_at":"2024-12-16 00:44:05","engineer_id":null,"project_title":"\u6218\u652f\u5de5\u63a7\u673a\u623f\u8bbe\u5907\u91c7\u8d2d","collected":"0","status_updated_at":"2024-12-16 00:44:05.070017+08","success_rate":null,"comment":"\u5de5\u63a7\u673a22\u53f0 \u89e6\u63a7\u5c4f\u5e558\u53f0 \u4e00\u4f53\u673a16\u53f0\r\n","contract_type":1,"progress_updated_at":"2024-12-16 00:44:05.070017+08","forecast_updated_at":"2024-12-16 00:44:05.070017+08","end_at":"2023-01-09 14:14:20","pinyin_shortcut":"zzgkjfsbcg","creator":5087,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"55000.000000000000","un_collected":"250000","client":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","logo":null,"client_type":6,"client_class":47,"client_industry":5},"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"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0.67,"work_count":1,"reimbursement_amount":"36","id":3754,"client_id":402,"project_status":4,"project_progress":5,"budget":"60000","profit_pct":"15","bargain_date":"2025-01-31","description":null,"created_by":5300,"created_at":"2024-12-30 10:13:32","updated_at":"2025-02-26 11:33:11","engineer_id":null,"project_title":"\u6df1\u4fe1\u670d\u5b89\u5168\u8bbe\u5907\u7ef4\u4fdd1\u5e74-2025","collected":"0","status_updated_at":"2025-01-20 16:02:15.306467+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-12-30 10:13:32.112142+08","forecast_updated_at":"2025-01-20 16:02:15.306467+08","end_at":"2025-01-20 16:02:15","pinyin_shortcut":"sxfaqsbwb1n2025","creator":5300,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"9000.0000000000000000","un_collected":"60000","client":{"id":402,"key":402,"name":"\u5317\u4eac\u6676\u6fb3\u592a\u9633\u80fd\u5149\u4f0f\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":5,"client_class":47,"client_industry":5},"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"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"287.00","id":3747,"client_id":2125,"project_status":4,"project_progress":5,"budget":"424000","profit_pct":"17.3","bargain_date":"2024-12-22","description":null,"created_by":5087,"created_at":"2024-12-22 22:27:31","updated_at":"2024-12-31 11:20:18","engineer_id":null,"project_title":"\u66f4\u6362\u6838\u5fc3\u4ea4\u6362\u673a-K","collected":"0","status_updated_at":"2024-12-23 11:24:01.392014+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-12-22 22:52:52.121621+08","forecast_updated_at":"2024-12-23 11:24:01.392014+08","end_at":"2024-12-23 11:24:01","pinyin_shortcut":"ghhxjhjK","creator":5087,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"73352.000000000000","un_collected":"424000","client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382","logo":null,"client_type":6,"client_class":47,"client_industry":20},"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"}}},{"service_time":"0","service_count":0,"pscount":0,"ircount":0,"pstime":"0","irtime":"0","points":0,"work_time":0,"work_count":0,"reimbursement_amount":"0","id":3748,"client_id":2130,"project_status":4,"project_progress":6,"budget":"60000","profit_pct":"45","bargain_date":"2024-12-22","description":null,"created_by":5087,"created_at":"2024-12-22 22:30:48","updated_at":"2025-01-19 09:28:03","engineer_id":null,"project_title":"306\u6240\u6570\u636e\u5e93\u8fd0\u7ef4-K","collected":"0","status_updated_at":"2024-12-23 11:32:26.875111+08","success_rate":null,"comment":"\u6570\u636e\u5e93\u8fd0\u7ef4\uff0c6\u6b21\u4e0a\u95e8","contract_type":2,"progress_updated_at":"2024-12-22 22:30:48.067318+08","forecast_updated_at":"2024-12-23 11:32:26.875111+08","end_at":"2024-12-23 11:32:26","pinyin_shortcut":"306ssjkywK","creator":5087,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"27000.000000000000","un_collected":"60000","client":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","logo":null,"client_type":6,"client_class":47,"client_industry":5},"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"}}},{"service_time":"0.92","service_count":1,"pscount":1,"ircount":0,"pstime":"0.916388888888889","irtime":"0","points":"50","work_time":16.97,"work_count":9,"reimbursement_amount":"447","id":3542,"client_id":2806,"project_status":4,"project_progress":3,"budget":"200000","profit_pct":"20","bargain_date":"2024-10-31","description":null,"created_by":5300,"created_at":"2024-05-20 11:21:53","updated_at":"2024-10-28 16:08:22","engineer_id":null,"project_title":"\u4ee3\u7801\u9632\u6cc4\u6f0f\u9879\u76ee","collected":"0","status_updated_at":"2024-10-28 16:08:22.675846+08","success_rate":null,"comment":"","contract_type":1,"progress_updated_at":"2024-05-20 11:21:53.17602+08","forecast_updated_at":"2024-10-28 16:08:22.675846+08","end_at":"2024-10-28 16:08:22","pinyin_shortcut":"dmfxlxm","creator":5364,"used_client":null,"from_contact":null,"total_contact_point":null,"paid_contact_point":null,"project_product_version_id":null,"is_sales_order_ready":false,"collected_plan":null,"profits":"40000.000000000000","un_collected":"200000","client":{"id":2806,"key":2806,"name":"\u4e00\u6c7d(\u5317\u4eac)\u8f6f\u4ef6\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":null,"client_type":6,"client_class":47,"client_industry":5},"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"}}}],"count":270,"sumBudget":"114540816.00","sumProfit":18829805.18,"sumCollect":"0","pagenation":{"totalcount":270,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-05 14:09:46') RETURNING "id"
14:09:46.949traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:09:46.950traceyii\redis\Connection::executeCommandExecuting Redis Command: SET