ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c7c2d6a06ac: POST https://beta.jinchangxiao.com/vue/analysis/sales-data-list at 2025-09-15 03:40:06 pm by 114.246.237.213

Log Messages

总计77条数据
TimeLevelCategoryMessage
 
15:40:06.656traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
15:40:06.656traceyii\base\Module::getModuleLoading module: debug
15:40:06.656traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
15:40:06.657traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
15:40:06.657traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
15:40:06.657traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:40:06.657traceyii\base\Module::getModuleLoading module: gii
15:40:06.657traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
15:40:06.657traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
15:40:06.657traceyii\web\Application::handleRequestRoute requested: 'vue/analysis/sales-data-list'
15:40:06.657traceyii\base\Module::getModuleLoading module: vue
15:40:06.658infoyii\web\Session::openSession started
15:40:06.658infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:40:06.658infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:40:06.663traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:40:06.663traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:40:06.663traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:40:06.663traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:40:06.663infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:40:06.665traceyii\base\Controller::runActionRoute to run: vue/analysis/sales-data-list
15:40:06.665traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:40:06.668traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:40:06.668traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\AnalysisController::actionSalesDataList()
15:40:06.668traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:40:06.669traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:40:06.670traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:40:06.670traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:40:06.671infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT p.*, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, (p.budget * p.profit_pct / 100) as profit, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND ("p"."bargain_date" >= '2024-01-01') AND (p.bargain_date < TIMESTAMP '2024-12-31' + INTERVAL '1 second') AND ("p"."project_status"='3') AND ("p"."created_by"='1001') AND ("p"."bargain_date" >= '2024-01-01 00:00:00') AND (p.bargain_date < TIMESTAMP '2024-12-31 23:59:59' + INTERVAL '1 second') GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c"
15:40:06.683infoyii\db\Command::querySELECT p.*, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, (p.budget * p.profit_pct / 100) as profit, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND ("p"."bargain_date" >= '2024-01-01') AND (p.bargain_date < TIMESTAMP '2024-12-31' + INTERVAL '1 second') AND ("p"."project_status"='3') AND ("p"."created_by"='1001') AND ("p"."bargain_date" >= '2024-01-01 00:00:00') AND (p.bargain_date < TIMESTAMP '2024-12-31 23:59:59' + INTERVAL '1 second') GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20
15:40:06.692infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2553, 3327, 3304, 2538, 3301, 3311, 2845, 3286, 2205, 3296, 2545, 3278, 3009)
15:40:06.692infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id" IN (5, 6)
15:40:06.693infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "notice_days", "color" FROM "a57be577deb434"."tbl_client_classes" WHERE "id" IN (43, 47)
15:40:06.693infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id" IN (13, 18, 10, 20, 19)
15:40:06.694infoyii\db\Command::querySELECT "project_id", "contribution" AS "value", "engineer_id" AS "key", "u"."name" FROM "a57be577deb434"."tbl_project_architects" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON engineer_id = u.id WHERE "a57be577deb434"."tbl_project_architects"."project_id" IN (3752, 3744, 3723, 3714, 3679, 3653, 3686, 3661, 3660, 3652, 3644, 3553, 3633, 3599, 3591, 3590, 3589, 3577, 3576, 3568)
15:40:06.694traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:40:06.695traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:40:06.695infoyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3
15:40:06.695infoyii\db\Command::querySELECT "id", "id" AS "key", "project_progress" AS "name" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (9, 6, 5)
15:40:06.696infoyii\db\Command::querySELECT id, product_type_id, product_type_id as key, name, coalesce(budget, 0) as budget, coalesce(pct, 0) as pct, coalesce(profit, 0) as profit, project_id FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (3752, 3744, 3723, 3714, 3679, 3653, 3686, 3661, 3660, 3652, 3644, 3553, 3633, 3599, 3591, 3590, 3589, 3577, 3576, 3568)
15:40:06.697infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3752, 3744, 3723, 3714, 3679, 3653, 3686, 3661, 3660, 3652, 3644, 3553, 3633, 3599, 3591, 3590, 3589, 3577, 3576, 3568)
15:40:06.697infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (165, 232, 2, 1, 226, 5, 172, 164, 160, 140, 197, 199, 183, 187, 194, 184, 189, 185, 192, 205, 191, 204, 139, 348, 181, 142, 265, 129, 136, 349, 350, 354, 359, 369, 372, 377, 340, 356)) ORDER BY "sort"
15:40:06.698infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3752, 3744, 3723, 3714, 3679, 3653, 3686, 3661, 3660, 3652, 3644, 3553, 3633, 3599, 3591, 3590, 3589, 3577, 3576, 3568)
15:40:06.699infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (165, 232, 2, 1, 226, 5, 172, 164, 160, 140, 197, 199, 183, 187, 194, 184, 189, 185, 192, 205, 191, 204, 139, 348, 181, 142, 265, 129, 136, 349, 350, 354, 359, 369, 372, 377, 340, 356)) ORDER BY "sort"
15:40:06.700infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3752, 3744, 3723, 3714, 3679, 3653, 3686, 3661, 3660, 3652, 3644, 3553, 3633, 3599, 3591, 3590, 3589, 3577, 3576, 3568)
15:40:06.700infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (165, 232, 2, 1, 226, 5, 172, 164, 160, 140, 197, 199, 183, 187, 194, 184, 189, 185, 192, 205, 191, 204, 139, 348, 181, 142, 265, 129, 136, 349, 350, 354, 359, 369, 372, 377, 340, 356)) ORDER BY "sort"
15:40:06.701infoyii\db\Command::querySELECT "id", "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "id"=1
15:40:06.701infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:40:06.702infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
15:40:06.703infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4
15:40:06.703infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2553, 3327, 3304, 2538, 3301, 3311, 2845, 3286, 2205, 3296, 2545, 3278, 3009)
15:40:06.704infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1005)
15:40:06.704infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1005))
15:40:06.705infoyii\db\Command::querySELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=1) AND (("location_in_id" IS NOT NULL) AND ("location_out_id" IS NOT NULL) AND ("client_id" IS NOT NULL)) AND ("project_id" IN (3752, 3744, 3723, 3714, 3679, 3653, 3686, 3661, 3660, 3652, 3644, 3553, 3633, 3599, 3591, 3590, 3589, 3577, 3576, 3568)) GROUP BY "project_id"
15:40:06.705infoyii\db\Command::querySELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(left_at - arrived_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_implement_records" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=2) AND ("c"."project_id" IN (3752, 3744, 3723, 3714, 3679, 3653, 3686, 3661, 3660, 3652, 3644, 3553, 3633, 3599, 3591, 3590, 3589, 3577, 3576, 3568)) GROUP BY "c"."project_id"
15:40:06.707infoyii\db\Command::querySELECT "c"."project_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_pre_sales" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=1) AND ("c"."project_id" IN (3752, 3744, 3723, 3714, 3679, 3653, 3686, 3661, 3660, 3652, 3644, 3553, 3633, 3599, 3591, 3590, 3589, 3577, 3576, 3568)) GROUP BY "c"."project_id"
15:40:06.709infoyii\db\Command::querySELECT "project_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=2) AND ("project_id" IN (3752, 3744, 3723, 3714, 3679, 3653, 3686, 3661, 3660, 3652, 3644, 3553, 3633, 3599, 3591, 3590, 3589, 3577, 3576, 3568)) GROUP BY "project_id"
15:40:06.709infoyii\db\Command::querySELECT "project_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("project_id" IN (3752, 3744, 3723, 3714, 3679, 3653, 3686, 3661, 3660, 3652, 3644, 3553, 3633, 3599, 3591, 3590, 3589, 3577, 3576, 3568)) GROUP BY "project_id"
15:40:06.711infoyii\db\Command::querySELECT "id", "from_project", "payment_collection_remind_ahead", "serial_no", "erp_settle_amount" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project" IN (3752, 3744, 3723, 3714, 3679, 3653, 3686, 3661, 3660, 3652, 3644, 3553, 3633, 3599, 3591, 3590, 3589, 3577, 3576, 3568)
15:40:06.713infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value" FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) )) "sub") "r" WHERE "contract_id" IN (3392, 3364, 3348, 3363, 3388, 3415, 3384, 3426, 3502, 3525, 3537, 3549, 3550, 3493, 3620, 3598, 3661, 3703, 3724, 3725) ORDER BY "id" DESC
15:40:06.716infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "amount" AS "value", "attachment_id", "from_date" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id" IN (3392, 3364, 3348, 3363, 3388, 3415, 3384, 3426, 3502, 3525, 3537, 3549, 3550, 3493, 3620, 3598, 3661, 3703, 3724, 3725) ORDER BY "id"
15:40:06.717infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id" IN (3392, 3364, 3348, 3363, 3388, 3415, 3384, 3426, 3502, 3525, 3537, 3549, 3550, 3493, 3620, 3598, 3661, 3703, 3724, 3725) ORDER BY "remind_date"
15:40:06.718infoyii\db\Command::querySELECT sum(p.budget * p.profit_pct / 100) AS profits, sum(p.budget) AS currents, sum(p.collected) AS collected, count(distinct p.client_id) as clients, count(p.id) AS count_current FROM "a57be577deb434"."tbl_projects" "p" WHERE ("p"."project_status"=3) AND ("p"."created_by"='1001') AND ("p"."bargain_date" >= '2024-01-01 00:00:00') AND (p.bargain_date < TIMESTAMP '2024-12-31 23:59:59' + INTERVAL '1 second')
15:40:06.719infoyii\db\Command::querySELECT sum(case when p.budget >= p.collected THEN p.budget - p.collected ELSE 0 END) AS un_collected FROM "a57be577deb434"."tbl_projects" "p" WHERE ("p"."project_status"=3) AND ("p"."created_by"='1001')
15:40:06.720infoyii\db\Command::querySELECT sum(c.erp_settle_amount) AS collected FROM "a57be577deb434"."tbl_sales_contracts" "c" LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON c.from_project = p.id WHERE ("p"."project_status"=3) AND ("p"."created_by"='1001')
15:40:06.720traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:40:06.721traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:40:06.721infoyii\db\Command::querySELECT sum(sci.amount) AS invoices FROM "a57be577deb434"."tbl_sales_contract_invoices" "sci" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "c" ON c.id = sci.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON c.project_id = p.id WHERE "p"."created_by"='1001'
15:40:06.722infoyii\db\Command::querySELECT sum(sub.invoices) as invoices FROM (SELECT sc.id, CASE WHEN sc.including_tax = false or sum(sci.amount) > sc.amount THEN 0 ELSE sc.amount - (CASE WHEN SUM ( sci.amount ) IS NOT NULL THEN SUM ( sci.amount ) ELSE 0 END) END as invoices FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_sales_contract_invoices" "sci" ON sc.id = sci.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON sc.project_id = p.id WHERE ("sc"."including_tax"=TRUE) AND ("p"."created_by"='1001') GROUP BY "sc"."id") "sub"
15:40:06.725traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:40:06.725traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:40:06.725infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-09-15')
15:40:06.729traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:40:06.729traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:40:06.729infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=16, "last_visit_at"='now()' WHERE "id"=56570
15:40:06.731infoyii\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/analysis/sales-data-list', '{"period":"fascal2024","viewMode":"month","dataUserId":"1001","id":"","page":"1","to":"","from":"","project_status":"3","web_access_token":"S7OJrULURAq348jTGnVvRiAMpe10N7Zn"}', '{"code":2000,"result":{"counts":[{"name":"\u9500\u552e\u5229\u6da6","key":"profits","value":2.99,"unit":"\u4e07","valueEx":"","unitEx":"","color":"#98c450","link":[]},{"name":"\u9500\u552e\u6d41\u6c34","key":"currents","value":1148.1,"unit":"\u4e07","valueEx":"","unitEx":"","color":"#98c450","link":[]},{"name":"\u5408\u4f5c\u5ba2\u6237\u6570\/\u5546\u673a\u6570","key":"clients","value":16,"unit":"\u4e2a","valueEx":28,"unitEx":"\u4e2a","color":"#98c450","link":[]},{"name":"\u5df2\u6536\u6b3e\/\u672a\u6536\u6b3e\u91d1\u989d","key":"payment","value":5270.35,"unit":"\u4e07","valueEx":175.65,"unitEx":"\u4e07","color":"#e75a4a","link":[]},{"name":"\u5df2\u5f00\/\u672a\u5f00\u53d1\u7968\u91d1\u989d","key":"invoices","value":5354.54,"unit":"\u4e07","valueEx":94.94,"unitEx":"\u4e07","color":"#e75a4a","link":[]}],"list":[{"id":3752,"client_id":2553,"project_status":3,"project_progress":9,"budget":"87000","profit_pct":"0.61","bargain_date":"2024-12-25","description":"","created_by":1001,"created_at":"2024-12-25 14:21:20","updated_at":"2025-02-25 10:54:34","engineer_id":"","project_title":"PA440 ATP\/AWF\/ADVURL \u6388\u6743\u65b0\u8d2d\u9879\u76ee","collected":"87000","status_updated_at":"2024-12-25 14:21:20.796572+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-12-25 14:21:20.796572+08","forecast_updated_at":"2024-12-25 14:21:20.796572+08","end_at":"2025-01-21 09:55:18","pinyin_shortcut":"PA440ATPAWFADVURLsqxgxm","creator":1001,"used_client":"","from_contact":1262,"total_contact_point":"24805.5","paid_contact_point":"24805.5","project_product_version_id":728,"is_sales_order_ready":true,"collected_plan":"87000","change_status_to":"","is_verify":false,"remain":"264 days 01:18:45.887856","progress_remain":"264 days 01:18:45.887856","forecast_remain":"264 days 01:18:45.887856","profit":"530.7000000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"26 days 19:33:57.994147","issued_invoices":"87000.00","client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"87000.00","pct":"0.61","profit":"530.7","project_id":3752}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3725,"from_project":3752,"payment_collection_remind_ahead":"2 days","serial_no":"W-KJ-CG-HS-20241224-01","erp_settle_amount":"87000","salesContractPayments":[{"id":"1235","key":"1235","contract_id":3725,"value":"87000"}],"salesContractInvoices":[{"id":1915,"key":1915,"contract_id":3725,"value":"87000.00","attachment_id":"","from_date":"2024-12-30","attachment":{}},{"id":1917,"key":1917,"contract_id":3725,"value":"-87000.00","attachment_id":"","from_date":"2024-12-30","attachment":{}},{"id":1926,"key":1926,"contract_id":3725,"value":"87000.00","attachment_id":"","from_date":"2025-01-03","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2232,"key":2232,"contract_id":3725,"name":"2025-01-30","value":"87000","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":264,"progress_remain_display":264,"forecast_remain_display":264,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":530.7,"can_change_status":true,"budget_display":"8.7\u4e07"},{"id":3744,"client_id":3327,"project_status":3,"project_progress":9,"budget":"126009","profit_pct":"0.65","bargain_date":"2024-12-25","description":"","created_by":1001,"created_at":"2024-12-17 17:03:55","updated_at":"2025-04-14 09:52:21","engineer_id":"","project_title":"PA440 2\u53f0\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","collected":"126009","status_updated_at":"2024-12-25 13:59:01.83268+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-12-17 17:03:55.937462+08","forecast_updated_at":"2024-12-17 17:03:55.937462+08","end_at":"2025-03-12 17:16:52","pinyin_shortcut":"PA4402tsbcgxm","creator":1001,"used_client":"","from_contact":1262,"total_contact_point":"41291","paid_contact_point":"41291","project_product_version_id":727,"is_sales_order_ready":true,"collected_plan":"126009.0","change_status_to":"","is_verify":false,"remain":"264 days 01:41:04.851748","progress_remain":"271 days 22:36:10.746966","forecast_remain":"271 days 22:36:10.746966","profit":"819.0585000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"85 days 00:12:56.261973","issued_invoices":"126009.00","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","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"126009.00","pct":"0.65","profit":"819.0585","project_id":3744}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3724,"from_project":3744,"payment_collection_remind_ahead":"2 days","serial_no":"TS-LRC-2024122501","erp_settle_amount":"126009","salesContractPayments":[{"id":"1304","key":"1304","contract_id":3724,"value":"12600.9"},{"id":"1277","key":"1277","contract_id":3724,"value":"88206.3"},{"id":"1276","key":"1276","contract_id":3724,"value":"25201.8"}],"salesContractInvoices":[{"id":1964,"key":1964,"contract_id":3724,"value":"126009.00","attachment_id":"","from_date":"2025-02-27","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2229,"key":2229,"contract_id":3724,"name":"2025-01-10","value":"25201.7","overdue_days":""},{"id":2230,"key":2230,"contract_id":3724,"name":"2025-02-28","value":"88206.3","overdue_days":""},{"id":2231,"key":2231,"contract_id":3724,"name":"2025-03-10","value":"12601","overdue_days":2}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":264,"progress_remain_display":271,"forecast_remain_display":271,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":819.06,"can_change_status":true,"budget_display":"12.6\u4e07"},{"id":3723,"client_id":3304,"project_status":3,"project_progress":6,"budget":"319460.45","profit_pct":"0.36","bargain_date":"2024-12-11","description":"","created_by":1001,"created_at":"2024-11-26 10:22:44","updated_at":"2025-03-03 10:24:33","engineer_id":"","project_title":"PAN-M-300\u8bbe\u5907\u91c7\u8d2d\u9879\u76ee","collected":"319460.45","status_updated_at":"2024-12-11 10:33:14.82619+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-11-26 10:22:44.148711+08","forecast_updated_at":"2024-11-26 10:22:44.148711+08","end_at":"2025-02-24 10:15:41","pinyin_shortcut":"PANM300sbcgxm","creator":1001,"used_client":"","from_contact":1262,"total_contact_point":"14351","paid_contact_point":"14351","project_product_version_id":703,"is_sales_order_ready":true,"collected_plan":"319460.45","change_status_to":"","is_verify":false,"remain":"278 days 05:06:51.858238","progress_remain":"293 days 05:17:22.535717","forecast_remain":"293 days 05:17:22.535717","profit":"1150.0576200000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"89 days 23:52:57.128544","issued_invoices":"319460.45","client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"319460.45","pct":"0.36","profit":"1150.05762","project_id":3723}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3703,"from_project":3723,"payment_collection_remind_ahead":"2 days","serial_no":"TS-LRC-20241211001","erp_settle_amount":"319460.45","salesContractPayments":[{"id":"1206","key":"1206","contract_id":3703,"value":"319460.45"}],"salesContractInvoices":[{"id":1942,"key":1942,"contract_id":3703,"value":"319460.45","attachment_id":"","from_date":"2025-01-17","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2301,"key":2301,"contract_id":3703,"name":"2025-02-22","value":"319460.45","overdue_days":2}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":278,"progress_remain_display":293,"forecast_remain_display":293,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":1150.06,"can_change_status":true,"budget_display":"31.95\u4e07"},{"id":3714,"client_id":2538,"project_status":3,"project_progress":6,"budget":"175370","profit_pct":"0.55","bargain_date":"2024-11-13","description":"","created_by":1001,"created_at":"2024-11-13 10:22:53","updated_at":"2025-01-17 10:09:06","engineer_id":"","project_title":"PA VM\u865a\u62df\u5899(\u897f\u4e91\u6570\u636e)\u91c7\u8d2d\u9879\u76ee","collected":"175370","status_updated_at":"2024-11-14 10:10:45.422774+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-11-13 10:22:53.340658+08","forecast_updated_at":"2024-11-13 10:22:53.340658+08","end_at":"2024-12-09 16:50:46","pinyin_shortcut":"PAVMxnqxysjcgxm","creator":1001,"used_client":"","from_contact":1262,"total_contact_point":"39902","paid_contact_point":"39902","project_product_version_id":667,"is_sales_order_ready":true,"collected_plan":"175370","change_status_to":"","is_verify":false,"remain":"305 days 05:29:21.261654","progress_remain":"306 days 05:17:13.34377","forecast_remain":"306 days 05:17:13.34377","profit":"964.5350000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"26 days 06:27:53.593299","issued_invoices":"175370.00","client":{"id":2538,"key":2538,"name":"\uff08\u8fc7\u5355\uff09\u5317\u4eac\u6606\u4ed1\u8054\u901a\u79d1\u6280\u53d1\u5c55\u80a1\u4efd\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":20,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4"},"projectProductTypes":[{"id":5,"product_type_id":5,"key":5,"name":"\u5b89\u5168\u8bbe\u5907","budget":"175370.00","pct":"0.55","profit":"964.535","project_id":3714}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3661,"from_project":3714,"payment_collection_remind_ahead":"1 day","serial_no":"TSKJ20241113-LRC-001","erp_settle_amount":"175370","salesContractPayments":[{"id":"1177","key":"1177","contract_id":3661,"value":"175370"}],"salesContractInvoices":[{"id":1869,"key":1869,"contract_id":3661,"value":"175370.00","attachment_id":"","from_date":"2024-11-21","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2148,"key":2148,"contract_id":3661,"name":"2024-11-29","value":"175370","overdue_days":10}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":305,"progress_remain_display":306,"forecast_remain_display":306,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":964.54,"can_change_status":true,"budget_display":"17.54\u4e07"},{"id":3679,"client_id":3301,"project_status":3,"project_progress":5,"budget":"175000","profit_pct":"1.57","bargain_date":"2024-10-23","description":"","created_by":1001,"created_at":"2024-10-10 13:22:40","updated_at":"2024-12-25 10:18:29","engineer_id":"","project_title":"\u5b89\u5168\u68c0\u6d4b\u4e0e\u54cd\u5e94\u5e73\u53f0\u670d\u52a1\u9879\u76ee\uff08\u8fc7\u5355\uff09","collected":"175000","status_updated_at":"2024-10-23 15:21:58.527894+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-10-10 13:22:40.735169+08","forecast_updated_at":"2024-10-10 13:22:40.735169+08","end_at":"2024-12-25 09:53:12","pinyin_shortcut":"aqjcyxyptfwxmgd","creator":1001,"used_client":"","from_contact":5912,"total_contact_point":"","paid_contact_point":"","project_product_version_id":717,"is_sales_order_ready":true,"collected_plan":"175000","change_status_to":"","is_verify":false,"remain":"327 days 00:18:08.156534","progress_remain":"340 days 02:17:25.949259","forecast_remain":"340 days 02:17:25.949259","profit":"2747.5000000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"75 days 20:30:31.421892","issued_invoices":"175000.00","client":{"id":3301,"key":3301,"name":"\u91d1\u878d\u65f6\u62a5\u793e","logo":"","client_type":6,"client_class":43,"client_industry":18,"sales_rep":1001,"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":18,"key":18,"name":"\u5a92\u4f53"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":5,"key":5,"name":"\u5546\u52a1\u62a5\u4ef7"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"175000.00","pct":"1.57","profit":"2747.5","project_id":3679}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355"},"opportunityFrom":{},"purchaseType":{"id":129,"key":129,"name":"\u7279\u7ea6\u9080\u6807"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":3679,"sum":"500.00"},"buildContract":{"id":3620,"from_project":3679,"payment_collection_remind_ahead":"00:00:00","serial_no":"jrsbht2024126","erp_settle_amount":"175000","salesContractPayments":[{"id":"1192","key":"1192","contract_id":3620,"value":"175000"}],"salesContractInvoices":[{"id":1906,"key":1906,"contract_id":3620,"value":"175000.00","attachment_id":"","from_date":"2024-12-18","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2094,"key":2094,"contract_id":3620,"name":"2024-12-31","value":"175000","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":327,"progress_remain_display":340,"forecast_remain_display":340,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":2747.5,"can_change_status":true,"budget_display":"17.5\u4e07"},{"id":3653,"client_id":3301,"project_status":3,"project_progress":9,"budget":"172700","profit_pct":"2.35","bargain_date":"2024-10-17","description":"","created_by":1001,"created_at":"2024-09-06 17:12:21","updated_at":"2024-12-25 10:18:36","engineer_id":"","project_title":"\u6df1\u4fe1\u670dAD-1000-B1800-TP 2\u53f0\u91c7\u8d2d\u9879\u76ee\uff08\u8fc7\u5355\uff09","collected":"172700","status_updated_at":"2024-09-06 17:12:21.176596+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-09-06 17:12:21.176596+08","forecast_updated_at":"2024-10-10 13:23:16.685145+08","end_at":"2024-12-24 17:05:59","pinyin_shortcut":"sxfAD1000B1800TP2tcgxmgd","creator":1001,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":629,"is_sales_order_ready":true,"collected_plan":"172700","change_status_to":"","is_verify":false,"remain":"373 days 22:27:45.507832","progress_remain":"373 days 22:27:45.507832","forecast_remain":"340 days 02:16:49.999283","profit":"4058.4500000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"108 days 23:53:38.088878","issued_invoices":"172700.00","client":{"id":3301,"key":3301,"name":"\u91d1\u878d\u65f6\u62a5\u793e","logo":"","client_type":6,"client_class":43,"client_industry":18,"sales_rep":1001,"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":18,"key":18,"name":"\u5a92\u4f53"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"172700.00","pct":"2.35","profit":"4058.45","project_id":3653}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355"},"opportunityFrom":{},"purchaseType":{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3525,"from_project":3653,"payment_collection_remind_ahead":"00:00:00","serial_no":"jrsbht2024115","erp_settle_amount":"172700","salesContractPayments":[{"id":"1191","key":"1191","contract_id":3525,"value":"172700"}],"salesContractInvoices":[{"id":1833,"key":1833,"contract_id":3525,"value":"172700.00","attachment_id":"","from_date":"2024-10-22","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2070,"key":2070,"contract_id":3525,"name":"2024-11-30","value":"172700","overdue_days":24}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":373,"progress_remain_display":373,"forecast_remain_display":340,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":4058.45,"can_change_status":true,"budget_display":"17.27\u4e07"},{"id":3686,"client_id":3311,"project_status":3,"project_progress":9,"budget":"75760","profit_pct":"21.84","bargain_date":"2024-10-15","description":"","created_by":1001,"created_at":"2024-10-16 11:11:45","updated_at":"2024-11-29 13:52:19","engineer_id":"","project_title":"\u7fa4\u6656\u5b58\u50a8DS923+\u91c7\u8d2d\u9879\u76ee","collected":"75760","status_updated_at":"2024-10-16 11:11:45.588104+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-10-16 11:11:45.588104+08","forecast_updated_at":"2024-10-16 11:11:45.588104+08","end_at":"2024-10-21 13:23:26","pinyin_shortcut":"qhccDS923cgxm","creator":1001,"used_client":"","from_contact":4838,"total_contact_point":"","paid_contact_point":"","project_product_version_id":620,"is_sales_order_ready":true,"collected_plan":"75760","change_status_to":"","is_verify":false,"remain":"334 days 04:28:21.096324","progress_remain":"334 days 04:28:21.096324","forecast_remain":"334 days 04:28:21.096324","profit":"16545.984000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"5 days 02:11:40.857469","issued_invoices":"75760.00","client":{"id":3311,"key":3311,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"75760.00","pct":"21.84","profit":"16545.984","project_id":3686}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3598,"from_project":3686,"payment_collection_remind_ahead":"2 days","serial_no":"TSKJ20241015","erp_settle_amount":"75760","salesContractPayments":[{"id":"1138","key":"1138","contract_id":3598,"value":"75760"}],"salesContractInvoices":[{"id":1832,"key":1832,"contract_id":3598,"value":"75760.00","attachment_id":"","from_date":"2024-10-22","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2080,"key":2080,"contract_id":3598,"name":"2024-10-31","value":"75760","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":334,"progress_remain_display":334,"forecast_remain_display":334,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":16545.98,"can_change_status":true,"budget_display":"7.58\u4e07"},{"id":3661,"client_id":3304,"project_status":3,"project_progress":9,"budget":"160023.44","profit_pct":"0.43","bargain_date":"2024-09-19","description":"","created_by":1001,"created_at":"2024-09-19 15:36:45","updated_at":"2024-11-12 17:01:53","engineer_id":"","project_title":"4\u53f0 PA440\u5957\u5305\u4ea7\u54c1\u91c7\u8d2d\u9879\u76ee","collected":"160023.44","status_updated_at":"2024-09-19 15:36:45.35974+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-09-19 15:36:45.35974+08","forecast_updated_at":"2024-09-19 15:36:45.35974+08","end_at":"2024-12-05 09:15:32","pinyin_shortcut":"4tPA440tbcpcgxm","creator":1001,"used_client":"","from_contact":1262,"total_contact_point":"17577","paid_contact_point":"17577","project_product_version_id":589,"is_sales_order_ready":true,"collected_plan":"160023.44","change_status_to":"","is_verify":false,"remain":"361 days 00:03:21.324688","progress_remain":"361 days 00:03:21.324688","forecast_remain":"361 days 00:03:21.324688","profit":"688.1007920000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"76 days 17:38:47.452472","issued_invoices":"160023.44","client":{"id":3304,"key":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"160023.44","pct":"0.43","profit":"688.100792","project_id":3661}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3550,"from_project":3661,"payment_collection_remind_ahead":"2 days","serial_no":"TS-LRC-20240919002","erp_settle_amount":"160023.44","salesContractPayments":[{"id":"1123","key":"1123","contract_id":3550,"value":"160023.44"}],"salesContractInvoices":[{"id":1849,"key":1849,"contract_id":3550,"value":"160023.44","attachment_id":"","from_date":"2024-11-04","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2089,"key":2089,"contract_id":3550,"name":"2024-12-09","value":"160023.44","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":361,"progress_remain_display":361,"forecast_remain_display":361,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":688.1,"can_change_status":true,"budget_display":"16\u4e07"},{"id":3660,"client_id":2845,"project_status":3,"project_progress":9,"budget":"85527.78","profit_pct":"0.39","bargain_date":"2024-09-19","description":"","created_by":1001,"created_at":"2024-09-19 13:39:55","updated_at":"2024-12-25 10:18:39","engineer_id":"","project_title":"Panorama\u8bbe\u5907\u53ca\u914d\u4ef6\u91c7\u8d2d\u9879\u76ee","collected":"85527.78","status_updated_at":"2024-09-19 13:39:55.898709+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-09-19 13:39:55.898709+08","forecast_updated_at":"2024-09-19 13:39:55.898709+08","end_at":"2024-11-27 16:23:50","pinyin_shortcut":"Panoramasbjpjcgxm","creator":1001,"used_client":"","from_contact":1262,"total_contact_point":"6367.5","paid_contact_point":"6367.5","project_product_version_id":588,"is_sales_order_ready":true,"collected_plan":"85527.78","change_status_to":"","is_verify":false,"remain":"361 days 02:00:10.785719","progress_remain":"361 days 02:00:10.785719","forecast_remain":"361 days 02:00:10.785719","profit":"333.5583420000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"69 days 02:43:54.246777","issued_invoices":"85527.78","client":{"id":2845,"key":2845,"name":"\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08PA\u8fc7\u5355\uff09","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"85527.78","pct":"0.39","profit":"333.558342","project_id":3660}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3549,"from_project":3660,"payment_collection_remind_ahead":"2 days","serial_no":"TS-LRC-20240919001","erp_settle_amount":"85527.78","salesContractPayments":[{"id":"1169","key":"1169","contract_id":3549,"value":"85527.78"}],"salesContractInvoices":[{"id":1848,"key":1848,"contract_id":3549,"value":"85527.78","attachment_id":"","from_date":"2024-11-04","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2102,"key":2102,"contract_id":3549,"name":"2024-11-25","value":"74393.85","overdue_days":2},{"id":2103,"key":2103,"contract_id":3549,"name":"2024-12-13","value":"11133.93","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":361,"progress_remain_display":361,"forecast_remain_display":361,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":333.56,"can_change_status":true,"budget_display":"8.55\u4e07"},{"id":3652,"client_id":3286,"project_status":3,"project_progress":6,"budget":"35315.61","profit_pct":"0.46","bargain_date":"2024-09-11","description":"","created_by":1001,"created_at":"2024-09-06 15:07:14","updated_at":"2024-11-19 17:23:56","engineer_id":"","project_title":"PA \u8f6f\u4ef6\u9632\u706b\u5899","collected":"35315.61","status_updated_at":"2024-09-11 11:32:13.606596+08","success_rate":"","comment":"PAN-SOFTWARE-NGFW-CR (Standard)","contract_type":1,"progress_updated_at":"2024-09-06 15:07:14.409227+08","forecast_updated_at":"2024-09-06 15:07:14.409227+08","end_at":"2024-11-25 16:54:03","pinyin_shortcut":"PArjfhq","creator":1001,"used_client":"","from_contact":1262,"total_contact_point":"4893","paid_contact_point":"4893","project_product_version_id":677,"is_sales_order_ready":true,"collected_plan":"35315.61","change_status_to":"","is_verify":false,"remain":"369 days 04:07:53.077832","progress_remain":"374 days 00:32:52.275201","forecast_remain":"374 days 00:32:52.275201","profit":"162.4518060000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"80 days 01:46:49.01044","issued_invoices":"35315.61","client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"35315.61","pct":"0.46","profit":"162.451806","project_id":3652}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3537,"from_project":3652,"payment_collection_remind_ahead":"2 days","serial_no":"PO2400845-Rev1","erp_settle_amount":"35315.61","salesContractPayments":[{"id":"1160","key":"1160","contract_id":3537,"value":"35315.61"}],"salesContractInvoices":[{"id":1845,"key":1845,"contract_id":3537,"value":"35315.61","attachment_id":"","from_date":"2024-10-29","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2120,"key":2120,"contract_id":3537,"name":"2024-11-30","value":"35315.61","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":369,"progress_remain_display":374,"forecast_remain_display":374,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":162.45,"can_change_status":true,"budget_display":"3.53\u4e07"},{"id":3644,"client_id":2553,"project_status":3,"project_progress":6,"budget":"120000","profit_pct":"0.39","bargain_date":"2024-08-28","description":"","created_by":1001,"created_at":"2024-08-28 11:57:23","updated_at":"2024-12-27 14:55:45","engineer_id":"","project_title":"PA820\u9632\u706b\u58993\u5e74\u670d\u52a1\u91c7\u8d2d\u9879\u76ee","collected":"120000","status_updated_at":"2024-08-28 11:57:23.285881+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-08-28 11:57:23.285881+08","forecast_updated_at":"2024-08-28 11:57:23.285881+08","end_at":"2025-01-24 10:45:27","pinyin_shortcut":"PA820fhq3nfwcgxm","creator":1001,"used_client":"","from_contact":1262,"total_contact_point":"8719","paid_contact_point":"8719","project_product_version_id":548,"is_sales_order_ready":true,"collected_plan":"120000","change_status_to":"","is_verify":false,"remain":"383 days 03:42:43.398547","progress_remain":"383 days 03:42:43.398547","forecast_remain":"383 days 03:42:43.398547","profit":"468.0000000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"148 days 22:48:03.747875","issued_invoices":"120000.00","client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"120000.00","pct":"0.39","profit":"468","project_id":3644}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3502,"from_project":3644,"payment_collection_remind_ahead":"2 days","serial_no":"W-KJ-CG-ZBL-20240902-01","erp_settle_amount":"120000","salesContractPayments":[{"id":"1243","key":"1243","contract_id":3502,"value":"120000"}],"salesContractInvoices":[{"id":1846,"key":1846,"contract_id":3502,"value":"120000.00","attachment_id":"","from_date":"2024-10-30","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":1970,"key":1970,"contract_id":3502,"name":"2024-11-15","value":"120000","overdue_days":70}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":383,"progress_remain_display":383,"forecast_remain_display":383,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":468,"can_change_status":true,"budget_display":"12\u4e07"},{"id":3553,"client_id":2205,"project_status":3,"project_progress":6,"budget":"117000","profit_pct":"0.7","bargain_date":"2024-08-26","description":"","created_by":1001,"created_at":"2024-05-31 17:12:46","updated_at":"2024-09-03 14:16:21","engineer_id":"","project_title":"PA3220\u9632\u706b\u5899\u4e00\u5e74\u7eed\u4fdd\u670d\u52a1-2024\u5e74","collected":"117000","status_updated_at":"2024-07-23 16:23:09.118513+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-05-31 17:12:46.209708+08","forecast_updated_at":"2024-05-31 17:12:46.209708+08","end_at":"2024-09-13 14:48:52","pinyin_shortcut":"PA3220fhqynxbfw2024n","creator":1001,"used_client":"","from_contact":1262,"total_contact_point":"","paid_contact_point":"","project_product_version_id":494,"is_sales_order_ready":true,"collected_plan":"117000","change_status_to":"","is_verify":false,"remain":"418 days 23:16:57.565915","progress_remain":"471 days 22:27:20.47472","forecast_remain":"471 days 22:27:20.47472","profit":"819.0000000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"104 days 21:36:06.508687","issued_invoices":"117000.00","client":{"id":2205,"key":2205,"name":"\u5317\u4eac\u6613\u8f66\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":47,"client_industry":19,"sales_rep":1005,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":47,"key":47,"name":"\u76ee\u6807\u5ba2\u6237","notice_days":30,"color":"#EB13C3"},"clientIndustry":{"id":19,"key":19,"name":"OTT"}},"projectArchitects":[{"project_id":3553,"value":"1","key":1017,"name":"\u8f66\u660e\u98de"}],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"117000","pct":"0.7","profit":"819","project_id":3553}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3426,"from_project":3553,"payment_collection_remind_ahead":"","serial_no":"TS-HYF-2024062501-002","erp_settle_amount":"117000","salesContractPayments":[{"id":"191","key":"191","contract_id":3426,"value":"117000"}],"salesContractInvoices":[{"id":1726,"key":1726,"contract_id":3426,"value":"117000.00","attachment_id":"","from_date":"2024-07-25","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":1959,"key":1959,"contract_id":3426,"name":"2024-08-29","value":"117000","overdue_days":15}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":418,"progress_remain_display":471,"forecast_remain_display":471,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":819,"can_change_status":true,"budget_display":"11.7\u4e07"},{"id":3633,"client_id":3296,"project_status":3,"project_progress":6,"budget":"5494736.8","profit_pct":"-0.26","bargain_date":"2024-08-19","description":"","created_by":1001,"created_at":"2024-08-22 15:36:13","updated_at":"2024-10-30 11:14:07","engineer_id":"","project_title":"\u8bed\u97f3\u5408\u6210\u7cfb\u7edf\u8f6f\u4ef6\u9879\u76ee\uff08\u8fc7\u5355\uff09","collected":"5494736.8","status_updated_at":"2024-08-26 15:44:32.127819+08","success_rate":"","comment":"\u7d2b\u5149\u6768\u603b\u8054\u7cfb\u8fc7\u5355\u7684","contract_type":1,"progress_updated_at":"2024-08-22 15:36:13.571817+08","forecast_updated_at":"2024-08-22 15:36:13.571817+08","end_at":"2024-10-30 11:07:44","pinyin_shortcut":"yyhcxtrjxmgd","creator":1001,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":543,"is_sales_order_ready":true,"collected_plan":"5494736.8","change_status_to":"","is_verify":false,"remain":"384 days 23:55:34.556609","progress_remain":"389 days 00:03:53.112611","forecast_remain":"389 days 00:03:53.112611","profit":"-14286.315680000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"68 days 19:31:31.316065","issued_invoices":"5494736.80","client":{"id":3296,"key":3296,"name":"\u62d3\u5c14\u601d\u4fe1\u606f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4"},"projectProductTypes":[{"id":65,"product_type_id":65,"key":65,"name":"\u5546\u4e1a\u8f6f\u4ef6","budget":"5494736.80","pct":"-0.26","profit":"-14286.31568","project_id":3633}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3493,"from_project":3633,"payment_collection_remind_ahead":"2 days","serial_no":"WG2024-406-OT1031","erp_settle_amount":"5494736.8","salesContractPayments":[{"id":"1124","key":"1124","contract_id":3493,"value":"5494736.8"}],"salesContractInvoices":[{"id":1844,"key":1844,"contract_id":3493,"value":"5494736.80","attachment_id":"","from_date":"2024-10-28","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2082,"key":2082,"contract_id":3493,"name":"2024-09-25","value":"5494736.8","overdue_days":35}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":384,"progress_remain_display":389,"forecast_remain_display":389,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":-14286.32,"can_change_status":true,"budget_display":"549.47\u4e07"},{"id":3599,"client_id":2545,"project_status":3,"project_progress":6,"budget":"38000","profit_pct":"13.45","bargain_date":"2024-07-16","description":"","created_by":1001,"created_at":"2024-07-16 17:00:45","updated_at":"2025-01-09 10:47:11","engineer_id":"","project_title":"\u8054\u60f3SR650\u4e8c\u624b\u670d\u52a1\u5668\u91c7\u8d2d\u9879\u76ee\u4e8c","collected":"38000","status_updated_at":"2024-07-18 11:02:34.435078+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-07-16 17:00:45.181291+08","forecast_updated_at":"2024-07-16 17:00:45.181291+08","end_at":"2024-07-18 15:27:07","pinyin_shortcut":"lxSR650esfwqcgxme","creator":1001,"used_client":"","from_contact":"","total_contact_point":"7000","paid_contact_point":"7000","project_product_version_id":489,"is_sales_order_ready":true,"collected_plan":"","change_status_to":"","is_verify":false,"remain":"424 days 04:37:32.24935","progress_remain":"425 days 22:39:21.503137","forecast_remain":"425 days 22:39:21.503137","profit":"5111.0000000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"1 day 22:26:22.61864","issued_invoices":"38000.00","client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":10,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4"},"projectProductTypes":[{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"38000.00","pct":"13.45","profit":"5111","project_id":3599}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":3599,"sum":"41.44"},"buildContract":{"id":3415,"from_project":3599,"payment_collection_remind_ahead":"1 day","serial_no":"TSC-LRC-2024071601","erp_settle_amount":"38000","salesContractPayments":[{"id":"152","key":"152","contract_id":3415,"value":"38000"}],"salesContractInvoices":[{"id":1722,"key":1722,"contract_id":3415,"value":"38000.00","attachment_id":"","from_date":"2024-07-24","attachment":{}}],"salesContractPaymentCollectionRemindDates":[]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":424,"progress_remain_display":425,"forecast_remain_display":425,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":5111,"can_change_status":true,"budget_display":"3.8\u4e07"},{"id":3591,"client_id":2553,"project_status":3,"project_progress":9,"budget":"19800","profit_pct":"1.17","bargain_date":"2024-07-09","description":"","created_by":1001,"created_at":"2024-07-09 13:59:32","updated_at":"2024-12-27 14:56:10","engineer_id":"","project_title":"\u5149\u6a21\u5757\u91c7\u8d2d\u9879\u76ee","collected":"19800","status_updated_at":"2024-07-09 13:59:32.720351+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-07-09 13:59:32.720351+08","forecast_updated_at":"2024-07-09 13:59:32.720351+08","end_at":"2024-08-22 16:00:05","pinyin_shortcut":"gmkcgxm","creator":1001,"used_client":"","from_contact":1262,"total_contact_point":"9894","paid_contact_point":"9894","project_product_version_id":475,"is_sales_order_ready":true,"collected_plan":"19800","change_status_to":"","is_verify":false,"remain":"433 days 01:40:33.964077","progress_remain":"433 days 01:40:33.964077","forecast_remain":"433 days 01:40:33.964077","profit":"231.6600000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"44 days 02:00:32.909094","issued_invoices":"19800.00","client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"19800.00","pct":"1.17","profit":"231.66","project_id":3591}],"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3392,"from_project":3591,"payment_collection_remind_ahead":"2 days","serial_no":"W-KJ-CG-ZBL-20240715-01","erp_settle_amount":"19800","salesContractPayments":[{"id":"154","key":"154","contract_id":3392,"value":"19800"}],"salesContractInvoices":[{"id":1719,"key":1719,"contract_id":3392,"value":"19800.00","attachment_id":"","from_date":"2024-07-22","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":1893,"key":1893,"contract_id":3392,"name":"2024-08-22","value":"19800","overdue_days":0}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":433,"progress_remain_display":433,"forecast_remain_display":433,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":231.66,"can_change_status":true,"budget_display":"1.98\u4e07"},{"id":3590,"client_id":2545,"project_status":3,"project_progress":9,"budget":"42600","profit_pct":"10.96","bargain_date":"2024-07-05","description":"","created_by":1001,"created_at":"2024-07-05 11:58:18","updated_at":"2024-08-27 09:49:02","engineer_id":"","project_title":"\u8054\u60f3\u670d\u52a1\u5668\u4e0a\u7528\u4e07\u5146\u7f51\u53612\u5757\u91c7\u8d2d\u9879\u76ee","collected":"42600","status_updated_at":"2024-07-05 11:58:18.029201+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-07-05 11:58:18.029201+08","forecast_updated_at":"2024-07-05 11:58:18.029201+08","end_at":"2024-07-09 09:38:43","pinyin_shortcut":"lxfwqsywzwk2kcgxm","creator":1001,"used_client":"","from_contact":"","total_contact_point":"7000","paid_contact_point":"7000","project_product_version_id":473,"is_sales_order_ready":true,"collected_plan":"42600","change_status_to":"","is_verify":false,"remain":"437 days 03:41:48.655227","progress_remain":"437 days 03:41:48.655227","forecast_remain":"437 days 03:41:48.655227","profit":"4668.9600000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"3 days 21:40:25.163942","issued_invoices":"42600.00","client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":10,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"42600.00","pct":"10.96","profit":"4668.96","project_id":3590}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":3590,"sum":"36.18"},"buildContract":{"id":3388,"from_project":3590,"payment_collection_remind_ahead":"2 days","serial_no":"TSC-LRC-2024070501","erp_settle_amount":"42600","salesContractPayments":[{"id":"113","key":"113","contract_id":3388,"value":"42600"}],"salesContractInvoices":[{"id":1709,"key":1709,"contract_id":3388,"value":"42600.00","attachment_id":"","from_date":"2024-07-09","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":1819,"key":1819,"contract_id":3388,"name":"2024-07-10","value":"42600","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":437,"progress_remain_display":437,"forecast_remain_display":437,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":4668.96,"can_change_status":true,"budget_display":"4.26\u4e07"},{"id":3589,"client_id":3286,"project_status":3,"project_progress":9,"budget":"208444.26","profit_pct":"-0.66","bargain_date":"2024-07-03","description":"","created_by":1001,"created_at":"2024-07-03 17:49:53","updated_at":"2024-09-20 09:58:55","engineer_id":"","project_title":"PaloAlto PA1420\u9632\u706b\u5899\u91c7\u8d2d\u9879\u76ee","collected":"208444.26","status_updated_at":"2024-07-03 17:49:53.610587+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-07-03 17:49:53.610587+08","forecast_updated_at":"2024-07-03 17:49:53.610587+08","end_at":"2024-08-20 16:59:55","pinyin_shortcut":"PaloAltoPA1420fhqcgxm","creator":1001,"used_client":"","from_contact":1262,"total_contact_point":"36575","paid_contact_point":"36575","project_product_version_id":468,"is_sales_order_ready":true,"collected_plan":"208444.26","change_status_to":"","is_verify":false,"remain":"438 days 21:50:13.073841","progress_remain":"438 days 21:50:13.073841","forecast_remain":"438 days 21:50:13.073841","profit":"-1375.7321160000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"47 days 23:10:01.857458","issued_invoices":"208444.26","client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"208444.26","pct":"-0.66","profit":"-1375.732116","project_id":3589}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3384,"from_project":3589,"payment_collection_remind_ahead":"7 days","serial_no":"PO2400474-Rev0","erp_settle_amount":"208444.26","salesContractPayments":[{"id":"199","key":"199","contract_id":3384,"value":"208444.26"}],"salesContractInvoices":[{"id":1732,"key":1732,"contract_id":3384,"value":"208444.26","attachment_id":"","from_date":"2024-07-26","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":1863,"key":1863,"contract_id":3384,"name":"2024-09-30","value":"208444.26","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":438,"progress_remain_display":438,"forecast_remain_display":438,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":-1375.73,"can_change_status":true,"budget_display":"20.84\u4e07"},{"id":3577,"client_id":3278,"project_status":3,"project_progress":9,"budget":"198354","profit_pct":"-0.71","bargain_date":"2024-06-25","description":"","created_by":1001,"created_at":"2024-06-26 10:50:35","updated_at":"2025-09-05 11:16:23","engineer_id":"","project_title":"PA1410\u9632\u706b\u58992\u5957\u65b0\u8d2d\u9879\u76ee","collected":"198354","status_updated_at":"2024-06-26 10:50:35.474112+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-06-26 10:50:35.474112+08","forecast_updated_at":"2024-06-26 10:50:35.474112+08","end_at":"2024-09-24 13:35:40","pinyin_shortcut":"PA1410fhq2txgxm","creator":1001,"used_client":"","from_contact":1262,"total_contact_point":"26476","paid_contact_point":"26476","project_product_version_id":523,"is_sales_order_ready":true,"collected_plan":"198354","change_status_to":"","is_verify":false,"remain":"446 days 04:49:31.210316","progress_remain":"446 days 04:49:31.210316","forecast_remain":"446 days 04:49:31.210316","profit":"-1408.3134000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"90 days 02:45:04.663669","issued_invoices":"198354.00","client":{"id":3278,"key":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":13,"key":13,"name":"SI\/ISV"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":87,"product_type_id":87,"key":87,"name":"\u5b89\u5168","budget":"198354.00","pct":"-0.71","profit":"-1408.3134","project_id":3577}],"salesForecast":{"id":232,"key":232,"name":"\u5382\u5546\u8fc7\u5355"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3364,"from_project":3577,"payment_collection_remind_ahead":"7 days","serial_no":"TS-HYF-2024062501","erp_settle_amount":"198354","salesContractPayments":[{"id":"1115","key":"1115","contract_id":3364,"value":"198354"}],"salesContractInvoices":[{"id":1740,"key":1740,"contract_id":3364,"value":"198354.00","attachment_id":"","from_date":"2024-08-05","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":2010,"key":2010,"contract_id":3364,"name":"2024-09-19","value":"198354","overdue_days":5}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":446,"progress_remain_display":446,"forecast_remain_display":446,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":-1408.31,"can_change_status":true,"budget_display":"19.84\u4e07"},{"id":3576,"client_id":2545,"project_status":3,"project_progress":9,"budget":"38000","profit_pct":"13.45","bargain_date":"2024-06-25","description":"","created_by":1001,"created_at":"2024-06-26 09:21:41","updated_at":"2025-01-09 10:47:21","engineer_id":"","project_title":"\u8054\u60f3SR650\u4e8c\u624b\u670d\u52a1\u5668\u91c7\u8d2d\u9879\u76ee","collected":"38000","status_updated_at":"2024-06-26 09:21:41.482129+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-06-26 09:21:41.482129+08","forecast_updated_at":"2024-06-26 09:21:41.482129+08","end_at":"2024-06-26 13:53:32","pinyin_shortcut":"lxSR650esfwqcgxm","creator":1001,"used_client":"","from_contact":"","total_contact_point":"7000","paid_contact_point":"7000","project_product_version_id":454,"is_sales_order_ready":true,"collected_plan":"38000","change_status_to":"","is_verify":false,"remain":"446 days 06:18:25.202299","progress_remain":"446 days 06:18:25.202299","forecast_remain":"446 days 06:18:25.202299","profit":"5111.0000000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"04:31:50.814576","issued_invoices":"38000.00","client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":10,"sales_rep":1001,"clientType":{"id":5,"key":5,"name":"\u5546\u4e1a"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":86,"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","budget":"38000.00","pct":"13.45","profit":"5111","project_id":3576}],"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{"project_id":3576,"sum":"61.95"},"buildContract":{"id":3363,"from_project":3576,"payment_collection_remind_ahead":"1 day","serial_no":"TSC-LRC-2024062501","erp_settle_amount":"38000","salesContractPayments":[{"id":"134","key":"134","contract_id":3363,"value":"38000"}],"salesContractInvoices":[{"id":1699,"key":1699,"contract_id":3363,"value":"38000.00","attachment_id":"","from_date":"2024-06-28","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":1782,"key":1782,"contract_id":3363,"name":"2024-07-05","value":"38000","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":446,"progress_remain_display":446,"forecast_remain_display":446,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":5111,"can_change_status":true,"budget_display":"3.8\u4e07"},{"id":3568,"client_id":3009,"project_status":3,"project_progress":9,"budget":"949200","profit_pct":"0.61","bargain_date":"2024-06-13","description":"","created_by":1001,"created_at":"2024-06-13 10:45:30","updated_at":"2025-01-20 16:02:12","engineer_id":"","project_title":"\u6df1\u4fe1\u670d\u5206\u5e03\u5f0f\u5b58\u50a8\u91c7\u8d2d\u9879\u76ee","collected":"949200","status_updated_at":"2024-06-13 10:45:30.859303+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-06-13 10:45:30.859303+08","forecast_updated_at":"2024-06-13 10:45:30.859303+08","end_at":"2024-09-19 16:29:39","pinyin_shortcut":"sxffbscccgxm","creator":1001,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":449,"is_sales_order_ready":true,"collected_plan":"949200","change_status_to":"","is_verify":false,"remain":"459 days 04:54:35.825125","progress_remain":"459 days 04:54:35.825125","forecast_remain":"459 days 04:54:35.825125","profit":"5790.1200000000000000","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"98 days 05:44:09.039528","issued_invoices":"949200.00","client":{"id":3009,"key":3009,"name":"\u540c\u65b9\u77e5\u7f51\uff08\u5317\u4eac\uff09\u6280\u672f\u6709\u9650\u516c\u53f8\/\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a\uff08\u5149\u76d8\u7248\uff09\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":43,"client_industry":18,"sales_rep":1001,"clientType":{"id":6,"key":6,"name":"\u592e\u4f01"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC"},"clientIndustry":{"id":18,"key":18,"name":"\u5a92\u4f53"}},"projectArchitects":[],"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c"},"projectProductTypes":[{"id":3,"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","budget":"949200.00","pct":"0.61","profit":"5790.12","project_id":3568}],"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84"},"opportunityFrom":{},"purchaseType":{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},"contractType":{"id":1,"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},"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"}},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesTimeCount":{},"implementTimeCount":{},"presalesTimeCount":{},"engineerTimeCount":{},"reimbursementAmountSum":{},"buildContract":{"id":3348,"from_project":3568,"payment_collection_remind_ahead":"7 days","serial_no":"2024SZCB-0795-220893","erp_settle_amount":"949200","salesContractPayments":[{"id":"196","key":"196","contract_id":3348,"value":"949200"}],"salesContractInvoices":[{"id":1749,"key":1749,"contract_id":3348,"value":"949200.00","attachment_id":"","from_date":"2024-08-14","attachment":{}}],"salesContractPaymentCollectionRemindDates":[{"id":1919,"key":1919,"contract_id":3348,"name":"2024-09-28","value":"949200","overdue_days":""}]},"lost_contact_days_display":"","unissued_invoice":0,"is_exceeded":false,"can_update":true,"can_delete":true,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"bgcolor":"#6200fe","remain_display":459,"progress_remain_display":459,"forecast_remain_display":459,"contract_type_display":"\u4ea7\u54c1\u9500\u552e","currents":5790.12,"can_change_status":true,"budget_display":"94.92\u4e07"}],"thisUser":"","can_create":true,"can_create_work_log":true,"can_create_schedule":true,"pagenation":{"totalcount":28,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-15 15:40:06') RETURNING "id"
15:40:06.735traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:40:06.735traceyii\redis\Connection::executeCommandExecuting Redis Command: SET