6a1cff4867793: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-client-cost at 2026-06-01 11:40:56 am by 221.216.117.119
Log Messages
总计32条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 11:40:56.423 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 11:40:56.423 | trace | yii\base\Module::getModule | Loading module: debug |
| 11:40:56.423 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 11:40:56.424 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 11:40:56.424 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 11:40:56.424 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 11:40:56.424 | info | time tracing start | 1780285256424582912 |
| 11:40:56.424 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 11:40:56.424 | trace | yii\web\Application::handleRequest | Route requested: 'vue/erp-analysis/list-client-cost' |
| 11:40:56.424 | trace | yii\base\Module::getModule | Loading module: vue |
| 11:40:56.425 | info | yii\web\Session::open | Session started |
| 11:40:56.425 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 11:40:56.425 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 11:40:56.427 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 11:40:56.427 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 11:40:56.427 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 11:40:56.428 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 11:40:56.428 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 11:40:56.429 | trace | yii\base\Controller::runAction | Route to run: vue/erp-analysis/list-client-cost |
| 11:40:56.429 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 11:40:56.430 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 11:40:56.430 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\ErpAnalysisController::actionListClientCost() |
| 11:40:56.432 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT c.*, CASE WHEN erp_sales_amount != 0 THEN erp_j_profit_amount / erp_sales_amount ELSE NULL END as erp_j_profit_pct, CASE WHEN erp_sales_amount != 0 THEN erp_profit_amount / erp_sales_amount ELSE NULL END as erp_profit_pct, CASE WHEN erp_sales_amount + erp_other_income_amount != 0 THEN erp_use_amount / (erp_sales_amount + erp_other_income_amount) ELSE NULL END as erp_cost_pct FROM (SELECT c.*, COALESCE(sum(o.outbound_cost), 0) as erp_cost_amount, COALESCE(sum(o.outbound_amount), 0) as erp_sales_amount, COALESCE(sum(eoi.amount), 0) as erp_other_income_amount, COALESCE(sum(ect.amount), 0) + COALESCE(sum(ect2.amount), 0) + COALESCE(sum(ecct.amount), 0) + COALESCE(sum(ecctcpc.amount), 0) + COALESCE(sum(eccrt.amount), 0) + COALESCE(sum(esgs.amount), 0) as erp_use_amount, COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) as erp_profit_amount, COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) + COALESCE(sum(eoi.amount), 0) - (COALESCE(sum(ect.amount), 0) + COALESCE(sum(ect2.amount), 0) + COALESCE(sum(ecct.amount), 0) + COALESCE(sum(ecctcpc.amount), 0) + COALESCE(sum(eccrt.amount), 0) + COALESCE(sum(esgs.amount), 0)) as erp_j_profit_amount, COALESCE(sum(ctlc.erp_labor_cost_amount), 0) as erp_labor_cost_amount, COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) + COALESCE(sum(eoi.amount), 0) - (COALESCE(sum(ect.amount), 0) + COALESCE(sum(ect2.amount), 0) + COALESCE(sum(ecct.amount), 0) + COALESCE(sum(ecctcpc.amount), 0) + COALESCE(sum(eccrt.amount), 0) + COALESCE(sum(esgs.amount), 0) + COALESCE(sum(ctlc.erp_labor_cost_amount), 0)) as erp_j_profit_deduct_labor_amount, COALESCE(sum(ectt.amount), 0) - COALESCE(sum(ept.amount), 0) as collect_amount, COALESCE(sum(scs.un_collect_amount), 0) as un_collect_amount, COALESCE(sum(p.project_count), 0) as project_count, COALESCE(sum(scs.budget), 0) as budget FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN (SELECT t.client_id, count(distinct t.id) as project_count FROM "a57be577deb434"."tbl_projects" "t" WHERE ("t"."project_status"=3) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "p" ON c.id = p.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "o" ON c.id = o.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ect" ON c.id = ect.client_id LEFT JOIN (SELECT c.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_contacts" "c" ON c.id = t.contact_id WHERE ("t"."status"=2) AND (c.client_id IS NOT NULL) GROUP BY "c"."client_id") "ect2" ON c.id = ect2.client_id LEFT JOIN (SELECT t.client_id as client_id, COALESCE(sum(t.amount),0) as amount FROM "a57be577deb434"."tbl_erp_other_income_tickets" "t" WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "eoi" ON c.id = eoi.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_ticket_client_project_costs" "cpc" ON cpc.erp_cash_cost_ticket_id = t.id WHERE ("t"."status"=2) AND (cpc.id IS NULL) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ecct" ON c.id = ecct.client_id LEFT JOIN (SELECT cpc.client_id, COALESCE(sum(cpc.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_client_project_costs" "cpc" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON cpc.erp_cash_cost_ticket_id = t.id WHERE ("t"."status"=2) AND (cpc.client_id IS NOT NULL) GROUP BY "cpc"."client_id") "ecctcpc" ON c.id = ecctcpc.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ectt" ON c.id = ectt.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "eccrt" ON c.id = eccrt.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_payment_tickets" "t" WHERE ("t"."status"=2) AND ("t"."is_payment_settle"=TRUE) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ept" ON c.id = ept.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(eipss.actual_total_amount - eipss.total_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "esgs" ON c.id = esgs.client_id LEFT JOIN (SELECT ct.client_id as client_id, COALESCE(sum(CASE WHEN ct.work_hours > 0 THEN COALESCE(payroll.amount, 0) / GREATEST(( SELECT COUNT(1) FROM generate_series(ct.settle_month::timestamp, (ct.settle_month + interval '1 month - 1 day')::timestamp, interval '1 day') AS work_dates(work_date) LEFT JOIN a57be577deb434.tbl_legal_holidays lh ON lh.edate = work_dates.work_date::date LEFT JOIN a57be577deb434.tbl_punch_strategy_schedules pss ON pss.edate = work_dates.work_date::date AND pss.punch_strategy_id = ps.id WHERE CASE WHEN ps.id IS NULL THEN EXTRACT(ISODOW FROM work_dates.work_date)::integer BETWEEN 1 AND 5 WHEN pss.id IS NOT NULL THEN pss.need_work WHEN ps.legal_holiday AND lh.id IS NOT NULL THEN lh.is_exchange ELSE (ps.week::integer & (1 << (EXTRACT(ISODOW FROM work_dates.work_date)::integer - 1))) <> 0 END ), 1) / GREATEST((CASE WHEN ps.id IS NULL THEN 8 WHEN ps.punch_type = 0 THEN 8 WHEN ps.work_hour IS NOT NULL AND ps.work_hour > 0 THEN ps.work_hour ELSE 8 END), 1) * ct.work_hours ELSE 0 END), 0) as erp_labor_cost_amount FROM ((SELECT p.id as ticket_id, 'preSales' as ticket_type, '售前' as ticket_type_name, p.ticket_no, p.case_id, c.case_no, COALESCE(p.client_id, c.client_id) as client_id, c.project_id, cl.sales_rep as sales_rep_id, p.engineer_id, p.start_at, p.end_at, date_trunc('month', p.start_at)::date as settle_month, EXTRACT(EPOCH FROM (p.end_at - p.start_at)) / 3600 as work_hours FROM "a57be577deb434"."tbl_pre_sales" "p" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = p.case_id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON cl.id = COALESCE(p.client_id, c.client_id) WHERE (p.start_at IS NOT NULL) AND (p.end_at IS NOT NULL) AND (p.end_at > p.start_at) AND (p.engineer_id IS NOT NULL) AND (("p"."is_draft"=FALSE) OR (p.is_draft IS NULL))) UNION ALL ( SELECT i.id as ticket_id, 'implementRecords' as ticket_type, '实施' as ticket_type_name, i.ticket_no, i.case_id, c.case_no, COALESCE(i.client_id, c.client_id) as client_id, c.project_id, cl.sales_rep as sales_rep_id, c.last_engineer as engineer_id, i.arrived_at as start_at, i.left_at as end_at, date_trunc('month', i.arrived_at)::date as settle_month, EXTRACT(EPOCH FROM (i.left_at - i.arrived_at)) / 3600 as work_hours FROM "a57be577deb434"."tbl_implement_records" "i" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = i.case_id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON cl.id = COALESCE(i.client_id, c.client_id) WHERE (i.arrived_at IS NOT NULL) AND (i.left_at IS NOT NULL) AND (i.left_at > i.arrived_at) AND (c.last_engineer IS NOT NULL) AND (("i"."is_draft"=FALSE) OR (i.is_draft IS NULL)) )) "ct" LEFT JOIN (SELECT pay.user_id, pay.settle_month, COALESCE(sum(pay.amount), 0) as amount FROM ((SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_wage_ticket_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON am.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month") UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_personal_tax_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON am.erp_personal_tax_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" )) "pay" GROUP BY "pay"."user_id", "pay"."settle_month") "payroll" ON payroll.user_id = ct.engineer_id AND payroll.settle_month = ct.settle_month LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.user_id = ct.engineer_id LEFT JOIN "a57be577deb434"."tbl_punch_strategies" "ps" ON ps.id = psrr.punch_strategy_id WHERE ct.client_id IS NOT NULL GROUP BY "ct"."client_id") "ctlc" ON c.id = ctlc.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as budget, COALESCE(sum(t.erp_un_settle_amount), 0) as un_collect_amount FROM "a57be577deb434"."tbl_sales_contracts" "t" WHERE ("t"."build_by_project"=TRUE) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "scs" ON c.id = scs.client_id GROUP BY "c"."id") "c" ORDER BY erp_labor_cost_amount DESC NULLS LAST, c.updated_at DESC) "c" |
| 11:40:56.727 | info | yii\db\Command::query | SELECT c.*, CASE WHEN erp_sales_amount != 0 THEN erp_j_profit_amount / erp_sales_amount ELSE NULL END as erp_j_profit_pct, CASE WHEN erp_sales_amount != 0 THEN erp_profit_amount / erp_sales_amount ELSE NULL END as erp_profit_pct, CASE WHEN erp_sales_amount + erp_other_income_amount != 0 THEN erp_use_amount / (erp_sales_amount + erp_other_income_amount) ELSE NULL END as erp_cost_pct FROM (SELECT c.*, COALESCE(sum(o.outbound_cost), 0) as erp_cost_amount, COALESCE(sum(o.outbound_amount), 0) as erp_sales_amount, COALESCE(sum(eoi.amount), 0) as erp_other_income_amount, COALESCE(sum(ect.amount), 0) + COALESCE(sum(ect2.amount), 0) + COALESCE(sum(ecct.amount), 0) + COALESCE(sum(ecctcpc.amount), 0) + COALESCE(sum(eccrt.amount), 0) + COALESCE(sum(esgs.amount), 0) as erp_use_amount, COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) as erp_profit_amount, COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) + COALESCE(sum(eoi.amount), 0) - (COALESCE(sum(ect.amount), 0) + COALESCE(sum(ect2.amount), 0) + COALESCE(sum(ecct.amount), 0) + COALESCE(sum(ecctcpc.amount), 0) + COALESCE(sum(eccrt.amount), 0) + COALESCE(sum(esgs.amount), 0)) as erp_j_profit_amount, COALESCE(sum(ctlc.erp_labor_cost_amount), 0) as erp_labor_cost_amount, COALESCE(sum(o.outbound_amount - o.outbound_cost), 0) + COALESCE(sum(eoi.amount), 0) - (COALESCE(sum(ect.amount), 0) + COALESCE(sum(ect2.amount), 0) + COALESCE(sum(ecct.amount), 0) + COALESCE(sum(ecctcpc.amount), 0) + COALESCE(sum(eccrt.amount), 0) + COALESCE(sum(esgs.amount), 0) + COALESCE(sum(ctlc.erp_labor_cost_amount), 0)) as erp_j_profit_deduct_labor_amount, COALESCE(sum(ectt.amount), 0) - COALESCE(sum(ept.amount), 0) as collect_amount, COALESCE(sum(scs.un_collect_amount), 0) as un_collect_amount, COALESCE(sum(p.project_count), 0) as project_count, COALESCE(sum(scs.budget), 0) as budget FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN (SELECT t.client_id, count(distinct t.id) as project_count FROM "a57be577deb434"."tbl_projects" "t" WHERE ("t"."project_status"=3) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "p" ON c.id = p.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(eipss.actual_total_amount), 0) as outbound_cost, COALESCE(sum(eipss.total_amount), 0) as outbound_amount FROM "a57be577deb434"."tbl_erp_sales_outbounds" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_outbound_id = t.id WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "o" ON c.id = o.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ect" ON c.id = ect.client_id LEFT JOIN (SELECT c.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_contacts" "c" ON c.id = t.contact_id WHERE ("t"."status"=2) AND (c.client_id IS NOT NULL) GROUP BY "c"."client_id") "ect2" ON c.id = ect2.client_id LEFT JOIN (SELECT t.client_id as client_id, COALESCE(sum(t.amount),0) as amount FROM "a57be577deb434"."tbl_erp_other_income_tickets" "t" WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "eoi" ON c.id = eoi.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_ticket_client_project_costs" "cpc" ON cpc.erp_cash_cost_ticket_id = t.id WHERE ("t"."status"=2) AND (cpc.id IS NULL) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ecct" ON c.id = ecct.client_id LEFT JOIN (SELECT cpc.client_id, COALESCE(sum(cpc.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_client_project_costs" "cpc" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON cpc.erp_cash_cost_ticket_id = t.id WHERE ("t"."status"=2) AND (cpc.client_id IS NOT NULL) GROUP BY "cpc"."client_id") "ecctcpc" ON c.id = ecctcpc.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_collect_tickets" "t" WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ectt" ON c.id = ectt.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_cost_convert_tickets" "t" WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "eccrt" ON c.id = eccrt.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_payment_tickets" "t" WHERE ("t"."status"=2) AND ("t"."is_payment_settle"=TRUE) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "ept" ON c.id = ept.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(eipss.actual_total_amount - eipss.total_amount), 0) as amount FROM "a57be577deb434"."tbl_erp_sales_gifts" "t" LEFT JOIN "a57be577deb434"."tbl_erp_inventory_product_spents" "eipss" ON eipss.erp_sales_gift_id = t.id WHERE ("t"."status"=2) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "esgs" ON c.id = esgs.client_id LEFT JOIN (SELECT ct.client_id as client_id, COALESCE(sum(CASE WHEN ct.work_hours > 0 THEN COALESCE(payroll.amount, 0) / GREATEST(( SELECT COUNT(1) FROM generate_series(ct.settle_month::timestamp, (ct.settle_month + interval '1 month - 1 day')::timestamp, interval '1 day') AS work_dates(work_date) LEFT JOIN a57be577deb434.tbl_legal_holidays lh ON lh.edate = work_dates.work_date::date LEFT JOIN a57be577deb434.tbl_punch_strategy_schedules pss ON pss.edate = work_dates.work_date::date AND pss.punch_strategy_id = ps.id WHERE CASE WHEN ps.id IS NULL THEN EXTRACT(ISODOW FROM work_dates.work_date)::integer BETWEEN 1 AND 5 WHEN pss.id IS NOT NULL THEN pss.need_work WHEN ps.legal_holiday AND lh.id IS NOT NULL THEN lh.is_exchange ELSE (ps.week::integer & (1 << (EXTRACT(ISODOW FROM work_dates.work_date)::integer - 1))) <> 0 END ), 1) / GREATEST((CASE WHEN ps.id IS NULL THEN 8 WHEN ps.punch_type = 0 THEN 8 WHEN ps.work_hour IS NOT NULL AND ps.work_hour > 0 THEN ps.work_hour ELSE 8 END), 1) * ct.work_hours ELSE 0 END), 0) as erp_labor_cost_amount FROM ((SELECT p.id as ticket_id, 'preSales' as ticket_type, '售前' as ticket_type_name, p.ticket_no, p.case_id, c.case_no, COALESCE(p.client_id, c.client_id) as client_id, c.project_id, cl.sales_rep as sales_rep_id, p.engineer_id, p.start_at, p.end_at, date_trunc('month', p.start_at)::date as settle_month, EXTRACT(EPOCH FROM (p.end_at - p.start_at)) / 3600 as work_hours FROM "a57be577deb434"."tbl_pre_sales" "p" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = p.case_id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON cl.id = COALESCE(p.client_id, c.client_id) WHERE (p.start_at IS NOT NULL) AND (p.end_at IS NOT NULL) AND (p.end_at > p.start_at) AND (p.engineer_id IS NOT NULL) AND (("p"."is_draft"=FALSE) OR (p.is_draft IS NULL))) UNION ALL ( SELECT i.id as ticket_id, 'implementRecords' as ticket_type, '实施' as ticket_type_name, i.ticket_no, i.case_id, c.case_no, COALESCE(i.client_id, c.client_id) as client_id, c.project_id, cl.sales_rep as sales_rep_id, c.last_engineer as engineer_id, i.arrived_at as start_at, i.left_at as end_at, date_trunc('month', i.arrived_at)::date as settle_month, EXTRACT(EPOCH FROM (i.left_at - i.arrived_at)) / 3600 as work_hours FROM "a57be577deb434"."tbl_implement_records" "i" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = i.case_id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON cl.id = COALESCE(i.client_id, c.client_id) WHERE (i.arrived_at IS NOT NULL) AND (i.left_at IS NOT NULL) AND (i.left_at > i.arrived_at) AND (c.last_engineer IS NOT NULL) AND (("i"."is_draft"=FALSE) OR (i.is_draft IS NULL)) )) "ct" LEFT JOIN (SELECT pay.user_id, pay.settle_month, COALESCE(sum(pay.amount), 0) as amount FROM ((SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_wage_ticket_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON am.erp_wage_ticket_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month") UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_social_insurance_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON am.erp_social_insurance_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_provident_fund_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON am.erp_provident_fund_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" ) UNION ALL ( SELECT am.user_id, t.settle_month::date as settle_month, COALESCE(sum(am.amount), 0) as amount FROM "a57be577deb434"."tbl_erp_personal_tax_amounts" "am" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON am.erp_personal_tax_id = t.id WHERE ("t"."status"=2) AND (am.user_id IS NOT NULL) GROUP BY "am"."user_id", "t"."settle_month" )) "pay" GROUP BY "pay"."user_id", "pay"."settle_month") "payroll" ON payroll.user_id = ct.engineer_id AND payroll.settle_month = ct.settle_month LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.user_id = ct.engineer_id LEFT JOIN "a57be577deb434"."tbl_punch_strategies" "ps" ON ps.id = psrr.punch_strategy_id WHERE ct.client_id IS NOT NULL GROUP BY "ct"."client_id") "ctlc" ON c.id = ctlc.client_id LEFT JOIN (SELECT t.client_id, COALESCE(sum(t.amount), 0) as budget, COALESCE(sum(t.erp_un_settle_amount), 0) as un_collect_amount FROM "a57be577deb434"."tbl_sales_contracts" "t" WHERE ("t"."build_by_project"=TRUE) AND (t.client_id IS NOT NULL) GROUP BY "t"."client_id") "scs" ON c.id = scs.client_id GROUP BY "c"."id") "c" ORDER BY erp_labor_cost_amount DESC NULLS LAST, c.updated_at DESC LIMIT 40 |
| 11:40:57.133 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5087, 1004, 5300, 5295, 1001) |
| 11:40:57.134 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 11:40:57.135 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 11:40:57.139 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 11:40:57.139 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 11:40:57.140 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-analysis/list-client-cost', '{"created_at_period":"","sales_rep":"","created_at_to":"","created_at_from":"","Filter":{"name":"erp_labor_cost_amount","sort":"DESC"},"page":"1","pageSize":"40","listReload":"true","web_access_token":"YNQKwEYJYN8muCSh8ExnNlBf2oepDAlv"}', '{"code":2000,"result":{"list":[{"id":918,"name":"\u4e2d\u56fd\u571f\u6728\u5de5\u7a0b\u96c6\u56e2\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"zgtmgcjtyxgs","description":"H3C\u7535\u8bdd\uff1a400-826-5511\uff0cH3C\u5927\u5ba2\u6237ID\uff1a0901111","corp_rep":"\u8d75\u4f43\u9f99","website":"http:\/\/bpm.ccecc.com.cn","capital":"300000","established_at":"1979-06-01","headcount":"5000","reg_address":"","working_address":"","telephone":"010-63263864","fax":"","scale":"","branch":"\u6d77\u59163000\u4eba\uff0c\u56fd\u51852000\u4eba","purchase_scale_per_yr":"0","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":5,"client_type":6,"sales_rep":1005,"main_contact":"","created_by":1005,"created_at":"2018-03-07 18:08:32","updated_at":"2026-03-22 19:46:17","main_business":"\u5efa\u7b51","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"China Civil Engineering Construction Corporation","pick_at":"2021-06-03 15:44:50","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":7,"client_key_info_count":2,"contact_count":6,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":7,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"475543.96","erp_sales_amount":"504650","erp_other_income_amount":"0","erp_use_amount":"32078.02","erp_profit_amount":"29106.04","erp_j_profit_amount":"-2971.98","erp_labor_cost_amount":"257.684963768116","erp_j_profit_deduct_labor_amount":"-3229.66496376811","collect_amount":"9992695.00","un_collect_amount":"180475","project_count":"14","budget":"10173170.00","erp_j_profit_pct":-0.59,"erp_profit_pct":5.77,"erp_cost_pct":6.36,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},{"id":2762,"name":"\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","abbr":"","pinyin_shortcut":"shhxwlxtyxgsgd","description":"","corp_rep":"\u5f20\u4e3a\u6c11","website":"www.eccom.com","capital":"12000","established_at":"2000-08-02","headcount":"","reg_address":"","working_address":"","telephone":"021-61372888","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":5087,"main_contact":"","created_by":5364,"created_at":"2023-12-25 16:27:20","updated_at":"2026-04-22 15:46:14","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u4f01\u4e1a\u540d\u79f0\uff1a\u4e0a\u6d77\u534e\u8baf\u7f51\u7edc\u7cfb\u7edf\u6709\u9650\u516c\u53f8 \n\u4f01\u4e1a\u7a0e\u53f7\uff1a913101151345129170 \n\u4f01\u4e1a\u5730\u5740\uff1a\u4e2d\u56fd\uff08\u4e0a\u6d77\uff09\u81ea\u7531\u8d38\u6613\u8bd5\u9a8c\u533a\u78a7\u6ce2\u8def456\u53f7B402-4\u5ba4 \n\u7535\u8bdd\u53f7\u7801\uff1a021-61372888 \n\u5f00\u6237\u94f6\u884c\uff1a\u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u4e0a\u6d77\u5206\u884c\u9646\u5bb6\u5634\u8f6f\u4ef6\u56ed\u652f\u884c \n\u94f6\u884c\u8d26\u6237\uff1a1001189719006819014","logo":"","en_name":"","pick_at":"2025-07-09 11:02:00","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":7,"client_key_info_count":0,"contact_count":3,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"2217117","erp_sales_amount":"3003980","erp_other_income_amount":"0","erp_use_amount":"18895.66","erp_profit_amount":"786863","erp_j_profit_amount":"767967.34","erp_labor_cost_amount":"159.761050724638","erp_j_profit_deduct_labor_amount":"767807.578949275","collect_amount":"3003980","un_collect_amount":"0","project_count":"1","budget":"3003980","erp_j_profit_pct":25.56,"erp_profit_pct":26.19,"erp_cost_pct":0.63,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},{"id":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)","abbr":"","pinyin_shortcut":"zgzxjxyxgsgjzxzbjpzddsdyxgs","description":"","corp_rep":"\u8096\u5e73","website":"www.chmc.cc","capital":"100000","established_at":"1981-01-30","headcount":"244","reg_address":38,"working_address":647,"telephone":"010-68296106","fax":"","scale":"","branch":"\u56fd\u5de5\u57fa\u5730\uff0c\u91d1\u8fb9","purchase_scale_per_yr":"","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":5,"client_type":6,"sales_rep":1005,"main_contact":"","created_by":1005,"created_at":"2017-02-09 11:54:30","updated_at":"2026-03-31 13:59:53","main_business":"\u627f\u5305\u56fd\u5916\u5de5\u7a0b\u9879\u76ee","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"China National Heavy Machinery Corporation","pick_at":"2021-06-03 15:44:50","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":7,"client_key_info_count":2,"contact_count":7,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":5,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"755846.0","erp_sales_amount":"983200","erp_other_income_amount":"0","erp_use_amount":"13292.1699999998","erp_profit_amount":"227354.0","erp_j_profit_amount":"214061.8300000002","erp_labor_cost_amount":"120.410144927536","erp_j_profit_deduct_labor_amount":"213941.419855073","collect_amount":"9301830.00","un_collect_amount":"2000000","project_count":"42","budget":"11301830.00","erp_j_profit_pct":21.77,"erp_profit_pct":23.12,"erp_cost_pct":1.35,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},{"id":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8","abbr":"","pinyin_shortcut":"bnkjbjyxgsshrnzgdzxtgcdejsyxgssdyyyjsshyxzrgs","description":"","corp_rep":"\u9093\u5929\u656c","website":"","capital":"1800","established_at":"2006-01-06","headcount":"","reg_address":125,"working_address":"","telephone":"010-80768000","fax":"","scale":"","branch":"","purchase_scale_per_yr":"50","purchase_freq":"","company_nature":6,"client_class":47,"client_industry":5,"client_type":5,"sales_rep":1005,"main_contact":"","created_by":1006,"created_at":"2017-02-14 12:28:19","updated_at":"2026-03-22 19:54:27","main_business":"\u7814\u7a76\u3001\u5f00\u53d1\u751f\u7269\u5236\u836f\u4ea7\u54c1\u53ca\u539f\u6599\u3001\u5316\u5b66\u533b\u836f\u4ea7\u54c1\u53ca\u539f\u6599\u3001\u533b\u7597\u5668\u68b0\u4ea7\u54c1\u53ca\u90e8\u4ef6\u3001\u533b\u5b66\u8bca\u65ad\u4ea7\u54c1\u53ca\u8bd5\u5242\u539f\u6599\uff1b","deleted":false,"capital_currency":"usd","invoice_info":"91110000783203401M","logo":"","en_name":"","pick_at":"2021-07-28 10:10:55","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":6,"client_key_info_count":1,"contact_count":13,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":1,"is_overdue_remind":true,"from_contact":"","tax_no":"","erp_cost_amount":"43700","erp_sales_amount":"61750","erp_other_income_amount":"0","erp_use_amount":"104516.835","erp_profit_amount":"18050","erp_j_profit_amount":"-86466.835","erp_labor_cost_amount":"68.0027173913043","erp_j_profit_deduct_labor_amount":"-86534.8377173913","collect_amount":"9028920.00","un_collect_amount":"48000","project_count":"81","budget":"9076920.00","erp_j_profit_pct":-140.03,"erp_profit_pct":29.23,"erp_cost_pct":169.26,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},{"id":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"zdskgylglyxgs","description":"\u66fe\u7528\u540d\uff1a\u4e2d\u90fd\u7269\u6d41\u6709\u9650\u516c\u53f8","corp_rep":"\u5f20\u96ea\u6885","website":"http:\/\/www.capital-logistics.cn\/","capital":"45000","established_at":"2008-01-08","headcount":"200","reg_address":68,"working_address":"","telephone":"010-89401168","fax":"","scale":"","branch":"\u6709","purchase_scale_per_yr":"150","purchase_freq":"\u591a\u6b21","company_nature":1,"client_class":47,"client_industry":8,"client_type":5,"sales_rep":1004,"main_contact":"","created_by":1003,"created_at":"2017-02-11 23:21:36","updated_at":"2026-04-15 10:29:05","main_business":"\u65b0\u8f66\u7269\u6d41\uff0c\u5927\u578b\u8bbe\u5907\u7269\u6d41\u8fd0\u8f93","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2021-06-03 15:44:50","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":7,"client_key_info_count":2,"contact_count":9,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":1,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"8540","erp_sales_amount":"30046.5","erp_other_income_amount":"0","erp_use_amount":"15411.73","erp_profit_amount":"21506.5","erp_j_profit_amount":"6094.77","erp_labor_cost_amount":"66.9146739130435","erp_j_profit_deduct_labor_amount":"6027.85532608696","collect_amount":"2216503.16","un_collect_amount":"0","project_count":"42","budget":"2216503.16","erp_j_profit_pct":20.28,"erp_profit_pct":71.58,"erp_cost_pct":51.29,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},{"id":402,"name":"\u5317\u4eac\u6676\u6fb3\u592a\u9633\u80fd\u5149\u4f0f\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjjatyngfkjyxgs","description":"","corp_rep":"\u6768\u7231\u9752","website":"http:\/\/www.jasolar.com","capital":"50000","established_at":"2014-04-14","headcount":"10000","reg_address":710,"working_address":711,"telephone":"","fax":"","scale":"413\u4ebf","branch":"","purchase_scale_per_yr":"0","purchase_freq":"","company_nature":2,"client_class":47,"client_industry":5,"client_type":5,"sales_rep":5300,"main_contact":"","created_by":5096,"created_at":"2017-07-05 19:54:54","updated_at":"2026-03-24 23:44:17","main_business":"ERP","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2022-06-22 17:50:11","it_budget":"","deployment_mode":"","it_per_num":"9\u4eba","public_relations_difficulty":"","it_status":"","decision_process":"\u6280\u672f\u9009\u578b \u91c7\u8d2d\u90e8\u91c7\u8d2d","coach":"","competitor":"","peers":"\u4e2d\u8282\u80fd\u3001\u901a\u5a01","supplier":"","main_product":"2007\u5e74\u4e0a\u5e02\uff0c\u53bb\u5e74\u9500\u552e\u989d413\u4ebf\uff0c\u603b\u90e8\u5728\u5317\u4eac\u4e30\u53f0\n\u4e3b\u8425\u4e1a\u52a1\uff1a\u5236\u9020\u592a\u9633\u80fd\u5149\u4f0f\u677f\uff0c\u4ea7\u4e1a\u94fe\u6709\u7845\u7247\u3001\u7535\u6c60\u3001\u7ec4\u4ef6\u3001\u5149\u4f0f\u7535\u7ad9\u3002\uff08\u5982\uff0c\u5c45\u6c11\u4f4f\u5b85\u3001\u5de5\u5546\u4e1a\u5c4b\u9876\u548c\u5730\u9762\u5149\u4f0f\u7535\u7ad9\u4e2d\u7684\u5149\u4f0f\u7ec4\u4ef6\uff09\n\u4e0a\u6e38\u5ba2\u6237\u662f\u653f\u5e9c\n\u5168\u7403\u6709\u7ecf\u9500\u5546\uff1a\u7f8e\u56fd\u3001\u5fb7\u56fd\u3001\u6fb3\u5927\u5229\u4e9a\u3001\u5df4\u897f\u3001\u65e5\u672c\u3001\u97e9\u56fd\u3001\u4e0a\u6d77...\n\u5168\u7403\u670912\u4e2a\u751f\u4ea7\u57fa\u5730\uff1a\u8d8a\u5357\u3001\u9a6c\u6765\u897f\u4e9a\u3001\u6cb3\u5317\u3001\u5185\u8499\u3001\u5b89\u5fbd\u3001\u4e91\u5357\u3001\u6c5f\u82cf\u3001\u6d59\u6c5f","client_base_info_count":5,"client_key_info_count":7,"contact_count":8,"visit_count":4,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"35100","erp_sales_amount":"58000","erp_other_income_amount":"0","erp_use_amount":"12632.87","erp_profit_amount":"22900","erp_j_profit_amount":"10267.13","erp_labor_cost_amount":"57.1222826086957","erp_j_profit_deduct_labor_amount":"10210.0077173913","collect_amount":"286525.00","un_collect_amount":"0","project_count":"3","budget":"286525","erp_j_profit_pct":17.7,"erp_profit_pct":39.48,"erp_cost_pct":21.78,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},{"id":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"smczgyxgsSMCbjzzyxgs","description":"","corp_rep":"\u8584\u4e95\u90c1\u4e8c","website":"http:\/\/www.smc.com.cn","capital":"125632.5","established_at":"1994-09-02","headcount":"4054","reg_address":26,"working_address":"","telephone":" 010-67885566","fax":"010-67881837","scale":"","branch":"\uff33\uff2d\uff23(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u6280\u672f\u7814\u53d1\u4e2d\u5fc3","purchase_scale_per_yr":"200","purchase_freq":"","company_nature":6,"client_class":80,"client_industry":5,"client_type":5,"sales_rep":5300,"main_contact":"","created_by":1003,"created_at":"2017-02-08 17:23:15","updated_at":"2026-03-24 09:51:43","main_business":"\u673a\u68b0\u5236\u9020\u6c7d\u7f38","deleted":false,"capital_currency":"rmb","invoice_info":"\u7edf\u4e00\u793e\u4f1a\u4fe1\u7528\u4ee3\u7801\uff1a \t9111030260002492XA ","logo":"","en_name":"","pick_at":"2022-10-12 15:39:34","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":9,"client_key_info_count":2,"contact_count":17,"visit_count":5,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":4,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"125731.56","erp_sales_amount":"208326","erp_other_income_amount":"0","erp_use_amount":"28054.1825","erp_profit_amount":"82594.44","erp_j_profit_amount":"54540.2575","erp_labor_cost_amount":"47.7832427536232","erp_j_profit_deduct_labor_amount":"54492.4742572464","collect_amount":"9948801.83","un_collect_amount":"0","project_count":"213","budget":"11519562.32","erp_j_profit_pct":26.18,"erp_profit_pct":39.65,"erp_cost_pct":13.47,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},{"id":2128,"name":"\u5317\u4eac\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjkjyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":20,"client_type":6,"sales_rep":5087,"main_contact":"","created_by":5087,"created_at":"2021-12-19 21:44:13","updated_at":"2026-05-27 19:24:26","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2021-12-19 21:44:13","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":7,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":3,"case_implement_count":10,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"310796","erp_sales_amount":"631660","erp_other_income_amount":"0","erp_use_amount":"9552.10","erp_profit_amount":"320864","erp_j_profit_amount":"311311.90","erp_labor_cost_amount":"46.8765398550725","erp_j_profit_deduct_labor_amount":"311265.023460145","collect_amount":"1450077","un_collect_amount":"31583","project_count":"3","budget":"1481660","erp_j_profit_pct":49.28,"erp_profit_pct":50.8,"erp_cost_pct":1.51,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},{"id":5,"name":"\u4e2d\u7535\u79d1\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"zdktltxkjyxgs","description":"\u66fe\u7528\u540d\uff1a\u5317\u4eac\u666e\u5929\u592a\u529b\u901a\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","corp_rep":"\u738b\u7acb\u56fd","website":"http:\/\/www.putiantaili.com","capital":"3783.56","established_at":"1992-09-01","headcount":"2200","reg_address":7,"working_address":"","telephone":"010-62683399","fax":"","scale":"1000000000","branch":"","purchase_scale_per_yr":"500","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":6,"client_type":6,"sales_rep":1004,"main_contact":"","created_by":1004,"created_at":"2017-02-08 15:59:11","updated_at":"2026-03-24 06:59:47","main_business":"\u4e3b\u8981\u4ece\u4e8b\u79fb\u52a8\u901a\u4fe1\u4ea7\u54c1\u7684\u9500\u552e\u548c\u670d\u52a1\uff0c\u662f\u4e2d\u56fd\u6700\u5927\u7684\u79fb\u52a8\u901a\u4fe1\u4ea7\u54c1\u5206\u9500\u5546\u4e4b\u4e00\u3002","deleted":false,"capital_currency":"rmb","invoice_info":"\u7edf\u4e00\u793e\u4f1a\u4fe1\u7528\u4ee3\u7801\uff1a91110108101972028F","logo":"","en_name":"","pick_at":"2021-06-03 15:44:50","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":7,"client_key_info_count":3,"contact_count":9,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":12,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"93281.55","erp_profit_amount":"0","erp_j_profit_amount":"-93281.55","erp_labor_cost_amount":"40.7109601449275","erp_j_profit_deduct_labor_amount":"-93322.2609601449","collect_amount":"59561038.00","un_collect_amount":"0","project_count":"35","budget":"59561038.00","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},{"id":89,"name":"\u5c71\u4e1c\u91d1\u8f6f\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u62db\u91d1\u77ff\u4e1a\u80a1\u4efd\u6709\u9650\u516c\u53f8)","abbr":"","pinyin_shortcut":"sdjrkjgfyxgszjkygfyxgs","description":"","corp_rep":"\u738b\u6653\u6770","website":"","capital":"3000","established_at":"2011-09-27","headcount":"","reg_address":198,"working_address":"","telephone":" 0535-8250678","fax":"0535-8250673","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":16,"client_type":6,"sales_rep":1005,"main_contact":"","created_by":1006,"created_at":"2017-02-20 10:27:44","updated_at":"2026-04-22 15:46:15","main_business":"\u62db\u91d1\u96c6\u56e26\u4e2a\u4e0b\u5c5e\u516c\u53f8\u7684\u4fe1\u606f\u5316\u5efa\u8bbe\u3002\u5b89\u5168\u6280\u672f\u9632\u8303\u5de5\u7a0b\u8bbe\u8ba1\u53ca\u65bd\u5de5\uff1b\u901a\u4fe1\u53ca\u8ba1\u7b97\u673a\u8f6f\u786c\u4ef6\u6280\u672f\u5f00\u53d1\uff1b\u8ba1\u7b97\u673a\u7cfb\u7edf\u8bbe\u8ba1\uff1b\u8ba1\u7b97\u673a\u6280\u672f\u670d\u52a1\u4e0e\u6280\u672f\u54a8\u8be2\uff1b","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2021-08-05 09:43:21","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":6,"client_key_info_count":1,"contact_count":25,"visit_count":1,"cooperate_count":1,"case_pre_sales_count":3,"case_implement_count":7,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"15000","erp_sales_amount":"18600","erp_other_income_amount":"0","erp_use_amount":"238034.72","erp_profit_amount":"3600","erp_j_profit_amount":"-234434.72","erp_labor_cost_amount":"38.0815217391304","erp_j_profit_deduct_labor_amount":"-234472.801521739","collect_amount":"15012500.00","un_collect_amount":"18600","project_count":"23","budget":"15031100.00","erp_j_profit_pct":-1260.4,"erp_profit_pct":19.35,"erp_cost_pct":1279.76,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},{"id":2526,"name":"\u5317\u4eac\u822a\u5929\u6d4b\u63a7\u6280\u672f\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjhtckjsyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":3,"client_class":43,"client_industry":5,"client_type":6,"sales_rep":5087,"main_contact":"","created_by":5087,"created_at":"2023-04-20 00:02:55","updated_at":"2026-03-22 20:23:03","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2023-04-20 00:02:55","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":11,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":1,"case_implement_count":6,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"18130","erp_sales_amount":"24700","erp_other_income_amount":"0","erp_use_amount":"3093.65","erp_profit_amount":"6570","erp_j_profit_amount":"3476.35","erp_labor_cost_amount":"36.4494565217391","erp_j_profit_deduct_labor_amount":"3439.90054347826","collect_amount":"77780","un_collect_amount":"69570","project_count":"14","budget":"167850","erp_j_profit_pct":14.07,"erp_profit_pct":26.6,"erp_cost_pct":12.52,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},{"id":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)(\u71d5\u4eac)","abbr":"","pinyin_shortcut":"gabdyyjsfzbyj","description":"100\u4e07\u4ee5\u4e0b\u534f\u8bae\u4f9b\u8d27\uff0c50\u4e07\u4ee5\u4e0b\u7f51\u4e0a\u7ade\u4ef7\uff0c100\u4e07\u4ee5\u4e0a\u516c\u5f00\u62db\u6807\u3002\u8bc1\u4ef6\u5904\u5904\u957f\u90ed\u5c0f\u6ce2\uff0c\u526f\u5904\u5218\u6797\u3002","corp_rep":"\u4ec7\u4fdd\u5229","website":"www.ciepe.com","capital":"317062","established_at":"","headcount":"","reg_address":330,"working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"50","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":1,"client_type":1,"sales_rep":1005,"main_contact":"","created_by":1005,"created_at":"2017-03-08 07:25:32","updated_at":"2026-04-22 15:46:14","main_business":"\u5b89\u5168","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2021-06-03 15:44:50","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":4,"client_key_info_count":1,"contact_count":22,"visit_count":0,"cooperate_count":2,"case_pre_sales_count":0,"case_implement_count":11,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"40800","erp_other_income_amount":"0","erp_use_amount":"92844.63","erp_profit_amount":"40800","erp_j_profit_amount":"-52044.63","erp_labor_cost_amount":"32.9133152173913","erp_j_profit_deduct_labor_amount":"-52077.5433152174","collect_amount":"15582974.00","un_collect_amount":"40800","project_count":"40","budget":"15623774.00","erp_j_profit_pct":-127.56,"erp_profit_pct":100,"erp_cost_pct":227.56,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},{"id":2492,"name":"\u822a\u5929\u79d1\u5de5\u96c6\u56e2\u667a\u80fd\u79d1\u6280\u7814\u7a76\u9662\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"htkgjtznkjyjyyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":3,"client_class":47,"client_industry":5,"client_type":6,"sales_rep":5087,"main_contact":"","created_by":5087,"created_at":"2022-11-27 23:38:59","updated_at":"2026-03-22 20:22:15","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2022-11-27 23:38:59","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":8,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":1,"case_implement_count":2,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"9651.52","erp_profit_amount":"0","erp_j_profit_amount":"-9651.52","erp_labor_cost_amount":"28.0171195652174","erp_j_profit_deduct_labor_amount":"-9679.53711956522","collect_amount":"50800","un_collect_amount":"0","project_count":"1","budget":"50800","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},{"id":85,"name":"\u5317\u4eac\u52a8\u529b\u673a\u68b0\u7814\u7a76\u624031\u6240","abbr":"","pinyin_shortcut":"bjdljxyjs31s","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":194,"working_address":824,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":5,"client_type":1,"sales_rep":5087,"main_contact":"","created_by":1005,"created_at":"2017-02-20 09:32:47","updated_at":"2026-04-22 15:46:13","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2022-01-13 09:04:07","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":7,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":1,"case_implement_count":1,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"8861.09","erp_profit_amount":"0","erp_j_profit_amount":"-8861.09","erp_labor_cost_amount":"23.2115942028985","erp_j_profit_deduct_labor_amount":"-8884.3015942029","collect_amount":"1047000.00","un_collect_amount":"23500","project_count":"6","budget":"1070500","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},{"id":304,"name":"\u5317\u4eac\u5317\u65b9\u534e\u521b\u771f\u7a7a\u6280\u672f\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjbfhczkjsyxgs","description":"1.\u51b3\u7b56\u6d41\u7a0b \u6280\u672f\u63d0\u9700\u6c42\uff0c\u6280\u672f\u9009\u578b\uff0c\u603b\u7ecf\u7406\u5ba1\u6279\uff0c\u7ec4\u7ec7\u9080\u6807\n2.\u5173\u952e\u70b9 \u6280\u672f\u63d0\u9700\u6c42 \u5173\u952e\u4eba \u5218\u6770\n3.\u4e1a\u52a1\u53d1\u5c55\u65b9\u5411 \n4.\u63a8\u8350\u7684\u4ea7\u54c1 \u865a\u62df\u684c\u9762\u6269\u5bb9 \n5.\u9879\u76ee\u5173\u952e\u4eba \u9ad8\u4fca\n\n\n\u7b2c\u4e8c\u5b63\u5ea6\u5ba2\u6237\u5173\u6000\uff1a\n \u65f6\u95f4 \u8054\u7cfb\u4eba \u5ba2\u6237\u53cd\u9988\n 2018\u5e746\u670828\u65e5 \u5218\u6770 \u65e0\u4e0d\u826f\u53cd\u9988\n\n\n\u7b2c\u4e09\u5b63\u5ea6\u5ba2\u6237\u5173\u6000\uff1a\n \u65f6\u95f4 \u8054\u7cfb\u4eba \u5ba2\u6237\u53cd\u9988\n 2018\u5e7410\u67089\u65e5 \u5218\u6770 \u7535\u8bdd\u4e00\u76f4\u672a\u63a5\u901a\n\n1.\u6f14\u793a\u4ea7\u54c1\uff1a\u6df1\u4fe1\u670d\u6001\u52bf\u611f\u77e5\n2.\u6f14\u793a\u65e5\u671f\uff1a2018\u5e7410\u670818\u65e5 13\uff1a30\n3.\u6f14\u793a\u5de5\u7a0b\u5e08\uff1a\u803f\u7a0b\u6797\n4.\u6548\u679c\u8bc4\u4f30\uff1a\u6f14\u793a\u6548\u679c\u6bd4\u8f83\u597d\uff0c\u5ba2\u6237\u76ee\u524d\u6709\u5b9d\u5229\u901a\u7684\u89c6\u9891\u4f1a\u8bae\uff0c\u6682\u65f6\u6ca1\u6709\u592a\u5173\u6ce8\u6b64\u4ea7\u54c1\n\n\n\u7b2c\u56db\u5b63\u5ea6\u5ba2\u6237\u5173\u6000\uff1a\n \u65f6\u95f4 \u8054\u7cfb\u4eba \u5ba2\u6237\u53cd\u9988\n 2019\u5e741\u67083\u65e5 \u5218\u6770 \u65e0\u4e0d\u826f\u53cd\u9988\uff0c\u6709\u4e9b\u5c0f\u95ee\u9898\uff0c\u5de5\u7a0b\u5e08\u5df2\u7ecf\u8fdc\u7a0b\u89e3\u51b3\n\n2019\u5e74\u7b2c\u4e00\u5b63\u5ea6\u5ba2\u6237\u5173\u6000\uff1a\n \u65f6\u95f4 \u8054\u7cfb\u4eba \u5ba2\u6237\u53cd\u9988\n 2019\u5e743\u670827\u65e5 \u5218\u6770 \u65e0\u4e0d\u826f\u53cd\u9988\n\u5ba2\u6237\u8f6c\u79fb\u8bb0\u5f55\uff1a2019-05-27 13:01 \u6b64\u5ba2\u6237\u88ab\u6d41\u8f6c\u81f3\u5b59\u5a77\u5a77\u3002\u64cd\u4f5c\u4eba\uff1a\u5b59\u5a77\u5a77\n\n2019\u5e74\u7b2c\u4e8c\u5b63\u5ea6\u5ba2\u6237\u5173\u6000\uff1a\n \u65f6\u95f4 \u8054\u7cfb\u4eba \u5ba2\u6237\u53cd\u9988\n 2019\u5e747\u67083\u65e5 \u9ad8\u4fca \u65e0\u4e0d\u826f\u53cd\u9988\n\n2019\u5e74\u7b2c\u4e09\u5b63\u5ea6\u5ba2\u6237\u5173\u6000\uff1a\n \u65f6\u95f4 \u8054\u7cfb\u4eba \u5ba2\u6237\u53cd\u9988\n 2019\u5e7410\u67089\u65e5 \u5218\u6770 \u65e0\u4e0d\u826f\u53cd\u9988\n\n2020\u5e74\u7b2c\u4e00\u5b63\u5ea6\u5ba2\u6237\u5173\u6000\uff1a\n \u65f6\u95f4 \u8054\u7cfb\u4eba \u5ba2\u6237\u53cd\u9988\n 2020\u5e743\u670825\u65e5 \u5218\u6770 \u65e0\u4e0d\u826f\u53cd\u9988\n\u5ba2\u6237\u8f6c\u79fb\u8bb0\u5f55\uff1a2020-04-19 23:12 \u6b64\u5ba2\u6237\u88ab\u6d41\u8f6c\u81f3\u516c\u6d77\u3002\u64cd\u4f5c\u4eba\uff1a\u5b59\u5a77\u5a77\n\n2020\u5e74\u7b2c\u4e8c\u5b63\u5ea6\u5ba2\u6237\u5173\u6000\uff1a\n \u65f6\u95f4 \u8054\u7cfb\u4eba \u5ba2\u6237\u53cd\u9988\n 2020\u5e747\u67089\u65e5 \u5218\u6770 Vcenter\u8fdb\u4e0d\u53bb\uff0c\u5df2\u544a\u77e5\u9500\u552e\n","corp_rep":"\u987e\u4e3a\u7fa4","website":"www.naura.com","capital":"5700","established_at":"2017-01-10","headcount":"200-300\u4eba","reg_address":"","working_address":1339,"telephone":"57846789","fax":"","scale":"\u51e0\u4e2a\u4ebf","branch":"","purchase_scale_per_yr":"","purchase_freq":"2","company_nature":2,"client_class":80,"client_industry":5,"client_type":1,"sales_rep":5295,"main_contact":"","created_by":5089,"created_at":"2017-05-15 20:00:28","updated_at":"2026-03-25 20:03:09","main_business":"SAP\u3001OA\uff0c\u6838\u5fc3\u5185\u7f51\u4e1a\u52a1\u90fd\u548c\u96c6\u56e2\u76f8\u8fde","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2021-06-03 15:44:50","it_budget":"\u6bcf\u5e74\u5bf9\u4e8e\u786c\u4ef6\u7684IT\u6295\u5165\u5f88\u5c11","deployment_mode":"\u672c\u5730\u90e8\u7f72","it_per_num":"5-6\u4eba","public_relations_difficulty":"","it_status":"\u76ee\u524d\u4e1a\u52a1\u90fd\u5f52\u603b\u90e8\u7edf\u4e00\u7ba1\u7406\uff0c\u53ea\u6709\u5916\u7f51\u7684\u90e8\u5206\u4e1a\u52a1\u5728\u672c\u5730\u30027\u53f0\u7269\u7406\u670d\u52a1\u5668\u3002VMware\u865a\u62df\u5316\uff0c\u9632\u706b\u5899\uff0c20\u4e2a\u70b9\u7684\u865a\u62df\u684c\u9762\u3002","decision_process":"\u6280\u672f\u9009\u578b\u2014\u9886\u5bfc\u51b3\u5b9a\u91c7\u8d2d\uff0c\u91c7\u8d2d\u662f\u603b\u90e8\u63d0\u51fa\u4e0a\u65b0\u8981\u6c42\uff0c\u5206\u5b50\u516c\u53f8\u81ea\u5df1\u91c7\u8d2d\u3002","coach":"\u65e0","competitor":"","peers":"","supplier":"\u9488\u5bf9\u884c\u4e1a\u7684\u673a\u68b0\u52a0\u5de5\u4f01\u4e1a","main_product":"\u534a\u5bfc\u4f53\u88c5\u5907\u3001\u771f\u7a7a\u88c5\u5907\u3001\u65b0\u80fd\u6e90\u9502\u7535\u88c5\u5907\u53ca\u7cbe\u5bc6\u5143\u5668\u4ef6\u4e1a\u52a1","client_base_info_count":6,"client_key_info_count":11,"contact_count":2,"visit_count":2,"cooperate_count":4,"case_pre_sales_count":0,"case_implement_count":7,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"343035.80","erp_sales_amount":"446714","erp_other_income_amount":"0","erp_use_amount":"11445.10","erp_profit_amount":"103678.20","erp_j_profit_amount":"92233.10","erp_labor_cost_amount":"23.2115942028985","erp_j_profit_deduct_labor_amount":"92209.8884057971","collect_amount":"1067634.00","un_collect_amount":"0","project_count":"7","budget":"1067634","erp_j_profit_pct":20.65,"erp_profit_pct":23.21,"erp_cost_pct":2.56,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},{"id":1492,"name":"\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u751f\u7269\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u8d1d\u745e\u548c\u5eb7\u533b\u5b66\u68c0\u9a8c\u5b9e\u9a8c\u5ba4\u6709\u9650\u516c\u53f8)","abbr":"","pinyin_shortcut":"bjbrhkswjsyxgsbjbrhkyxjysysyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":5,"client_type":5,"sales_rep":1005,"main_contact":"","created_by":5015,"created_at":"2019-09-04 17:17:36","updated_at":"2026-03-24 11:57:36","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2021-07-28 10:10:44","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":12,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":5,"is_overdue_remind":true,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"80125.30","erp_profit_amount":"0","erp_j_profit_amount":"-80125.30","erp_labor_cost_amount":"22.9395833333333","erp_j_profit_deduct_labor_amount":"-80148.2395833333","collect_amount":"9206160.00","un_collect_amount":"425000","project_count":"14","budget":"9631160.00","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},{"id":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","abbr":"","pinyin_shortcut":"slsccbxzgyxgsslsccbxzgyxgsbjfgs","description":"\u603b\u90e8\u5728\u745e\u58eb","corp_rep":"\u4e8e\u7490\u5dcd","website":"www.baoxian999.cn","capital":"92200","established_at":"2013-07-02","headcount":"500","reg_address":670,"working_address":"","telephone":"021-20895500","fax":"","scale":"10\u4ebf","branch":"","purchase_scale_per_yr":"100","purchase_freq":"2","company_nature":6,"client_class":1,"client_industry":10,"client_type":1,"sales_rep":5295,"main_contact":"","created_by":1006,"created_at":"2017-02-21 11:34:20","updated_at":"2026-03-25 16:32:13","main_business":"\u7406\u8d54\u5728\u7ebf\u62a5\u6848\u7cfb\u7edf\uff0c\u4fdd\u5355\u67e5\u8be2\u7cfb\u7edf\uff0cOA\u7cfb\u7edf\uff0c\u8d22\u52a1\u7cfb\u7edf\u3002","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2021-06-03 15:44:50","it_budget":"200\u4e07","deployment_mode":"\u672c\u5730\u90e8\u7f72","it_per_num":"3-4\u4eba","public_relations_difficulty":"","it_status":"IBM\uff0fDELL\u670d\u52a1\u5668\uff0c\u5c0f\u578b\u673a\uff0cNETAPP\u5b58\u50a8\uff0cPA\u9632\u706b\u5899\uff0c\u7528\u7684\u90fd\u662f\u56fd\u5916\u54c1\u724c","decision_process":"\u6280\u672f\u2014\u9886\u5bfc\u2014\u6280\u672f","coach":"\u5b59\u51ef","competitor":"\u65e0","peers":"","supplier":"\u65e0","main_product":"1.\u8d22\u4ea7\u4fdd\u9669\uff1a\u5bf9\u4eba\u6216\u4f01\u4e1a\u7684\u7269\u8d44\u8d22\u4ea7\u8fdb\u884c\u4fdd\u9669\n2.\u8d23\u4efb\u4fdd\u9669\uff1a\u6bd4\u5982\u8f66\u9669\u5c31\u662f\u8d23\u4efb\u4fdd\u9669\u7684\u4e00\u79cd\uff0c\u5c31\u662f\u66ff\u4eba\u8d54\u507f\u5e94\u627f\u62c5\u8d23\u4efb\u7684\u94b1\u3002\n3.\u77ed\u671f\u5065\u5eb7\u4fdd\u9669\uff1a\u5c31\u662f\u4eba\u7684\u610f\u5916\u4f24\u5bb3\u4fdd\u9669","client_base_info_count":6,"client_key_info_count":12,"contact_count":6,"visit_count":4,"cooperate_count":2,"case_pre_sales_count":0,"case_implement_count":6,"is_overdue_remind":true,"from_contact":"","tax_no":"","erp_cost_amount":"232103.96","erp_sales_amount":"352528","erp_other_income_amount":"0","erp_use_amount":"82093.38","erp_profit_amount":"120424.04","erp_j_profit_amount":"38330.66","erp_labor_cost_amount":"21.7608695652174","erp_j_profit_deduct_labor_amount":"38308.8991304348","collect_amount":"4852577.00","un_collect_amount":"0","project_count":"36","budget":"4852577.00","erp_j_profit_pct":10.87,"erp_profit_pct":34.16,"erp_cost_pct":23.29,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},{"id":2166,"name":"\u6c5f\u539f\u521b\u82af\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\/\u6df1\u5733\u6c5f\u539f\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"jycxkjbjyxgsszjykjyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"0","company_nature":3,"client_class":43,"client_industry":5,"client_type":1,"sales_rep":5300,"main_contact":"","created_by":5015,"created_at":"2022-03-21 16:38:39","updated_at":"2026-04-15 15:56:38","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2022-03-21 16:38:39","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":2,"visit_count":9,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":1,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"100000.00","erp_sales_amount":"148320","erp_other_income_amount":"0","erp_use_amount":"2365.20","erp_profit_amount":"48320.00","erp_j_profit_amount":"45954.80","erp_labor_cost_amount":"19.0407608695652","erp_j_profit_deduct_labor_amount":"45935.7592391304","collect_amount":"148320","un_collect_amount":"0","project_count":"1","budget":"148320","erp_j_profit_pct":30.98,"erp_profit_pct":32.58,"erp_cost_pct":1.59,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},{"id":97,"name":"\u534e\u745e\u4e16\u7eaa\u63a7\u80a1\u96c6\u56e2\u6709\u9650\u516c\u53f8(\u5c71\u897f\u534e\u745e\u7164\u4e1a\u6709\u9650\u516c\u53f8)","abbr":"","pinyin_shortcut":"hrsjkgjtyxgssxhrmyyxgs","description":"","corp_rep":"\u9648\u5a77\u5a77","website":"","capital":"50000","established_at":"2007-04-06","headcount":"1000","reg_address":680,"working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":5,"client_class":43,"client_industry":16,"client_type":5,"sales_rep":5300,"main_contact":"","created_by":1006,"created_at":"2017-02-22 16:52:38","updated_at":"2026-03-24 09:51:43","main_business":"\u79d1\u6280\uff0c\u91d1\u878d\uff0c\u6587\u65c5\uff0c\u533b\u7597\u3002","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2025-02-10 13:22:57","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":4,"client_key_info_count":2,"contact_count":3,"visit_count":2,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":2,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"1000","erp_other_income_amount":"0","erp_use_amount":"495.00","erp_profit_amount":"1000","erp_j_profit_amount":"505.00","erp_labor_cost_amount":"19.0407608695652","erp_j_profit_deduct_labor_amount":"485.959239130435","collect_amount":"151200.00","un_collect_amount":"0","project_count":"7","budget":"151200.00","erp_j_profit_pct":50.5,"erp_profit_pct":100,"erp_cost_pct":49.5,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},{"id":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"zzzcglszyxgs","description":"","corp_rep":"\u4e8e\u6d0b","website":"","capital":"10000","established_at":"2014-11-05","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":10,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":1011,"created_at":"2023-06-14 09:45:51","updated_at":"2026-01-14 10:24:28","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0: \u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8 \u7edf\u4e00\u793e\u4f1a\u4fe1\u7528\u4ee3\u7801: 91440300319560181N\n\u5730\u5740\u7535\u8bdd: \u6df1\u5733\u5e02\u524d\u6d77\u6df1\u6e2f\u5408\u4f5c\u533a\u524d\u6e7e\u4e00\u8def 1 \u53f7 A \u680b 201 \u5ba4(\u5165\u9a7b\u6df1\u5733\u5e02\u524d\u6d77\u5546\u52a1\u79d8\u4e66\u6709\u9650\u516c\u53f8) 17727932602\n\u5f00\u6237\u94f6\u884c\u53ca\u5e10\u53f7: \u62db\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u6df1\u5733\u524d\u6d77\u5206\u884c 755923588110111","logo":"","en_name":"","pick_at":"2023-06-14 09:45:51","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":5,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":4,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"1807.33","erp_profit_amount":"0","erp_j_profit_amount":"-1807.33","erp_labor_cost_amount":"19.0407608695652","erp_j_profit_deduct_labor_amount":"-1826.37076086957","collect_amount":"898318","un_collect_amount":"0","project_count":"10","budget":"898318","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":24,"name":"\u4e2d\u822a\u946b\u6e2f\u62c5\u4fdd\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"zhxgdbyxgs","description":"1. \u516c\u53f8\u4e1a\u52a1 \u56fd\u4f01 \u91d1\u878d\u884c\u4e1a \u822a\u7a7a\u516c\u53f8\u9500\u552e\u62c5\u4fdd\n2. \u8425\u4e1a\u6536\u5165 3000\u591a\u4e07\n3. IT\u90e8\u95e8\u4eba\u6570 \u65e0\n4. \u529e\u516c\u4eba\u6570 \u65e0\n5. \u4e1a\u52a1\u7cfb\u7edf \u65e0\n6. \u529e\u516c\u73af\u5883\u7684\u75db\u70b9 \u65e0\n7. \u4e1a\u52a1\u73af\u5883\u7684\u75db\u70b9 \u65e0","corp_rep":"\u674e\u6811\u82f1","website":"","capital":"50000","established_at":"2004-09-02","headcount":"","reg_address":42,"working_address":675,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":3,"client_class":43,"client_industry":10,"client_type":1,"sales_rep":5300,"main_contact":"","created_by":5045,"created_at":"2017-02-09 16:33:10","updated_at":"2026-03-23 11:13:48","main_business":"\u822a\u7a7a\u8fd0\u8f93\u9500\u552e\u62c5\u4fdd\uff08\u822a\u7a7a\u5ba2\u8fd0\u9500\u552e\u4ee3\u7406\u7ed3\u7b97\u62c5\u4fdd\u3001\u822a\u7a7a\u8d27\u8fd0\u9500\u552e\u4ee3\u7406\u7ed3\u7b97\u62c5\u4fdd\u3001\u5de5\u7a0b\u7c7b\u62c5\u4fdd\u7b49\u3002\uff09","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2022-06-22 17:50:11","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":4,"client_key_info_count":1,"contact_count":2,"visit_count":0,"cooperate_count":3,"case_pre_sales_count":0,"case_implement_count":1,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"95600","erp_sales_amount":"107200","erp_other_income_amount":"0","erp_use_amount":"2134.43","erp_profit_amount":"11600","erp_j_profit_amount":"9465.57","erp_labor_cost_amount":"16.0486413043478","erp_j_profit_deduct_labor_amount":"9449.52135869565","collect_amount":"1086278.00","un_collect_amount":"0","project_count":"17","budget":"1086278.00","erp_j_profit_pct":8.83,"erp_profit_pct":10.82,"erp_cost_pct":1.99,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},{"id":2221,"name":"(\u8fc7\u5355)\u4e2d\u5efa\u65b0\u79d1\u88c5\u9970\u5de5\u7a0b\u6709\u9650\u516c\u53f8\uff08\u4e2d\u5efa\u65b0\u79d1\u5efa\u8bbe\u53d1\u5c55\u6709\u9650\u516c\u53f8\uff09","abbr":"","pinyin_shortcut":"gdzjxkzsgcyxgszjxkjsfzyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":20,"client_type":5,"sales_rep":5295,"main_contact":"","created_by":5295,"created_at":"2022-08-12 21:25:22","updated_at":"2026-01-16 14:03:00","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2025-10-22 11:11:38","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":2,"is_overdue_remind":true,"from_contact":"","tax_no":"","erp_cost_amount":"1487","erp_sales_amount":"5050","erp_other_income_amount":"0","erp_use_amount":"327.82","erp_profit_amount":"3563","erp_j_profit_amount":"3235.18","erp_labor_cost_amount":"13.6005434782609","erp_j_profit_deduct_labor_amount":"3221.57945652174","collect_amount":"34829","un_collect_amount":"0","project_count":"2","budget":"34829","erp_j_profit_pct":64.06,"erp_profit_pct":70.55,"erp_cost_pct":6.49,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},{"id":2125,"name":"\u5317\u4eac\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjjqzzyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":20,"client_type":6,"sales_rep":5087,"main_contact":"","created_by":5087,"created_at":"2021-12-19 18:01:00","updated_at":"2026-04-22 15:46:14","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2021-12-19 18:01:00","it_budget":"","deployment_mode":"","it_per_num":"19\u4eba","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":1,"contact_count":6,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":3,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"286525","erp_sales_amount":"333880","erp_other_income_amount":"0","erp_use_amount":"34596.48","erp_profit_amount":"47355","erp_j_profit_amount":"12758.52","erp_labor_cost_amount":"10.8804347826087","erp_j_profit_deduct_labor_amount":"12747.6395652174","collect_amount":"3282783","un_collect_amount":"491047","project_count":"2","budget":"3773830","erp_j_profit_pct":3.82,"erp_profit_pct":14.18,"erp_cost_pct":10.36,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},{"id":1172,"name":"\u5317\u4eac\u4e2d\u90fd\u661f\u5fbd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjzdxhskgylglyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":8,"client_type":5,"sales_rep":1004,"main_contact":"","created_by":1003,"created_at":"2018-10-24 14:48:49","updated_at":"2026-03-25 11:23:53","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2021-06-03 15:44:50","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":5,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":2,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"9195","erp_sales_amount":"12700","erp_other_income_amount":"0","erp_use_amount":"3365.79","erp_profit_amount":"3505","erp_j_profit_amount":"139.21","erp_labor_cost_amount":"10.8804347826087","erp_j_profit_deduct_labor_amount":"128.329565217392","collect_amount":"472974.18","un_collect_amount":"21104.99","project_count":"14","budget":"494079.17","erp_j_profit_pct":1.1,"erp_profit_pct":27.6,"erp_cost_pct":26.5,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},{"id":497,"name":"\u5317\u4eac\u7ea2\u661f\u80a1\u4efd\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjhxgfyxgs","description":"","corp_rep":"\u5468\u6cd5\u7530","website":"http:\/\/www.redstarwine.com","capital":"56000","established_at":"2000-08-29","headcount":"400","reg_address":"","working_address":"","telephone":"","fax":"","scale":"2-4\u4ebf","branch":"\u5c71\u897f\uff0c\u5929\u6d25\uff0c\u6000\u67d4","purchase_scale_per_yr":"10","purchase_freq":"","company_nature":3,"client_class":1,"client_industry":5,"client_type":1,"sales_rep":5300,"main_contact":"","created_by":5096,"created_at":"2017-09-20 23:16:25","updated_at":"2026-03-23 11:20:28","main_business":"sap,crm,sfa,wms,tms","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"Beijing Red Star (Stock) Ltd.,co.","pick_at":"2021-12-06 17:34:55","it_budget":"","deployment_mode":"\u6570\u636e\u4e2d\u5fc3","it_per_num":"","public_relations_difficulty":"","it_status":"\u534e\u4e3aS6720\u4ea4\u6362\u673a\u4e8c\u53f0\uff0cSFP-GE-SX-MM850-A\u6a21\u57572\u4e2a\uff0c1000BASE-T-GT\u6a21\u57572\u4e2a\uff0cOMXD30000\u5149\u6a21\u575712\u4e2a\nPA-220\u9632\u706b\u5899\u4e09\u53f0\uff0c PA-820\u9632\u706b\u5899\u4e00\u53f0\nDELL R940:XEON gold5118*2\/DDR4 16GB*16\/SAS 600GB*2,1600W*2\/12GB \u53cc\u53e3HBA\u5361*2\u3001\u4e09\u53f0\uff0c\n\u601d\u79d19148\u4ea4\u6362\u673a2\u53f0\uff0c\nDELL MD3800F\u5b58\u50a8\u4e00\u5957\uff0cDELL SCV3020\u5b58\u50a8\u4e00\u5957","decision_process":"\u5546\u5f6c\u9700\u6c42\u2014\u5b54\u90e8\u957f\u2014\u5f20\u603b","coach":"\u5546\u5f6c","competitor":"\u5e38\u5fb7\u4e07\u4f17","peers":"","supplier":"","main_product":"\u7ea2\u661f\u4e8c\u9505\u5934","client_base_info_count":6,"client_key_info_count":9,"contact_count":3,"visit_count":1,"cooperate_count":2,"case_pre_sales_count":0,"case_implement_count":4,"is_overdue_remind":true,"from_contact":"","tax_no":"","erp_cost_amount":"28183","erp_sales_amount":"116619","erp_other_income_amount":"0","erp_use_amount":"32615.9725","erp_profit_amount":"88436","erp_j_profit_amount":"55820.0275","erp_labor_cost_amount":"10.8804347826087","erp_j_profit_deduct_labor_amount":"55809.1470652174","collect_amount":"2614790.00","un_collect_amount":"0","project_count":"13","budget":"2614790.00","erp_j_profit_pct":47.87,"erp_profit_pct":75.83,"erp_cost_pct":27.97,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},{"id":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjgkhykjgfyxgsEDAxmqwxxjsyxgs","description":"","corp_rep":"\u5f20\u5584\u4ece","website":" http:\/\/www.ucas.com.cn","capital":"3750","established_at":"2004-11-25","headcount":"300\u4eba\u5de6\u53f3","reg_address":"","working_address":"","telephone":"010-82122848","fax":"","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":1,"client_class":80,"client_industry":57,"client_type":1,"sales_rep":5295,"main_contact":"","created_by":5089,"created_at":"2017-10-09 11:24:04","updated_at":"2026-03-23 11:16:33","main_business":"\u516c\u53f8\u76ee\u524d\u5e94\u7528\u90fd\u5728\u963f\u91cc\u5df4\u5df4\u516c\u6709\u4e91\u4e0a\u8dd1\uff0c\u5171\u670940\u4e2a\u5e94\u7528\uff0c\u5747\u4e3a\u5c0f\u578b\u4e1a\u52a1","deleted":false,"capital_currency":"rmb","invoice_info":"91110108769356188B","logo":"","en_name":"","pick_at":"2021-06-03 15:44:50","it_budget":"10\u4e07","deployment_mode":"\u516c\u6709\u4e91","it_per_num":"5-6\u4eba","public_relations_difficulty":"","it_status":"\u516c\u53f8\u76ee\u524d\u5e94\u7528\u90fd\u5728\u963f\u91cc\u5df4\u5df4\u516c\u6709\u4e91\u4e0a\u8dd1\uff0c\u5171\u670940\u4e2a\u5e94\u7528\uff0c\u5747\u4e3a\u5c0f\u578b\u4e1a\u52a1","decision_process":"\u6280\u672f\u2014\u9ad8\u5c42\u9886\u5bfc\u2014\u6280\u672f","coach":"\u90ed","competitor":"\u65e0","peers":"","supplier":"","main_product":"OpenVPX\u3001SmartATE\u4ea7\u54c1\uff0c\u661f\u8f7d\u9886\u57df\u3001\u673a\u8f7d\u9886\u57df\u5f39\u8f7d\u9886\u57df\u3001\u8f66\u8239\u9886\u57df\u7b49","client_base_info_count":7,"client_key_info_count":10,"contact_count":7,"visit_count":5,"cooperate_count":5,"case_pre_sales_count":0,"case_implement_count":2,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"151500","erp_sales_amount":"243250","erp_other_income_amount":"0","erp_use_amount":"30408.13","erp_profit_amount":"91750","erp_j_profit_amount":"61341.87","erp_labor_cost_amount":"8.16032608695652","erp_j_profit_deduct_labor_amount":"61333.709673913","collect_amount":"2598566.00","un_collect_amount":"0","project_count":"15","budget":"2613766","erp_j_profit_pct":25.22,"erp_profit_pct":37.72,"erp_cost_pct":12.5,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},{"id":3391,"name":"\u5317\u4eac\u7231\u80b2\u534e\u533b\u9662\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjayhyyyxgs","description":"","corp_rep":"\u51af\u6bbf\u6ce2","website":"www.aiyuhua.com","capital":"21864","established_at":"2003-09-22","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"0","company_nature":4,"client_class":43,"client_industry":3,"client_type":5,"sales_rep":5300,"main_contact":"","created_by":1011,"created_at":"2025-09-18 12:39:41","updated_at":"2026-03-23 10:55:46","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u4f01\u4e1a\u540d\u79f0\uff1a\u5317\u4eac\u7231\u80b2\u534e\u533b\u9662\u6709\u9650\u516c\u53f8 \n\u4f01\u4e1a\u7a0e\u53f7\uff1a91110302753301270Q \n\u4f01\u4e1a\u5730\u5740\uff1a\u5317\u4eac\u5e02\u5317\u4eac\u7ecf\u6d4e\u6280\u672f\u5f00\u53d1\u533a\u666f\u56ed\u5357\u88572\u53f7 \n\u7535\u8bdd\u53f7\u7801\uff1a010-69079017","logo":"","en_name":"","pick_at":"2025-09-18 12:39:41","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":6,"client_key_info_count":0,"contact_count":1,"visit_count":1,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":1,"is_overdue_remind":false,"from_contact":"","tax_no":"91110302753301270Q","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"326.20","erp_profit_amount":"0","erp_j_profit_amount":"-326.20","erp_labor_cost_amount":"7.52563405797101","erp_j_profit_deduct_labor_amount":"-333.725634057971","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},{"id":93,"name":"\u5eb7\u9f99\u5316\u6210(\u5317\u4eac)\u65b0\u836f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"klhcbjxyjsgfyxgs","description":"\u7535\u8bdd\u53ef\u4ee5\u63a5\u901a\uff0c\u4f46\u662f\u90a3\u8fb9\u4fe1\u53f7\u4e0d\u597d\u8fd8\u662f\u600e\u4e48\uff0c\u8054\u7cfb\u4e24\u6b21\u90fd\u662f\u540c\u6837\u7684\u60c5\u51b5\uff0c\u545c\u545c\u5566\u5566\u6ca1\u4eba\u8bf4\u8bdd\u3002","corp_rep":"\u697c\u67cf\u826f ","website":"http:\/\/www.pharmaron.com\/","capital":"59066.3575","established_at":"2004-07-01","headcount":"1200","reg_address":203,"working_address":"","telephone":"010-57330000 ","fax":"","scale":"","branch":"\u5eb7\u9f99\u5316\u6210\uff08\u5317\u4eac\uff09\u65b0\u836f\u6280\u672f\u6709\u9650\u516c\u53f8\u901a\u5dde\u5206\u516c\u53f8","purchase_scale_per_yr":"50","purchase_freq":"","company_nature":6,"client_class":47,"client_industry":5,"client_type":3,"sales_rep":1005,"main_contact":"","created_by":5096,"created_at":"2017-02-21 12:42:50","updated_at":"2026-04-22 15:46:14","main_business":"\u533b\u836f\u751f\u4ea7","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2023-07-10 10:54:08","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":7,"client_key_info_count":2,"contact_count":12,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":5,"is_overdue_remind":true,"from_contact":"","tax_no":"","erp_cost_amount":"340000","erp_sales_amount":"545000","erp_other_income_amount":"0","erp_use_amount":"95129.620","erp_profit_amount":"205000","erp_j_profit_amount":"109870.380","erp_labor_cost_amount":"7.2536231884058","erp_j_profit_deduct_labor_amount":"109863.126376812","collect_amount":"4183000","un_collect_amount":"0","project_count":"4","budget":"4183000","erp_j_profit_pct":20.16,"erp_profit_pct":37.61,"erp_cost_pct":17.45,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},{"id":1301,"name":"\u591a\u7ef4\u8054\u5408\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8(\u591a\u7ef4\u7eff\u5efa\u79d1\u6280(\u5929\u6d25)\u6709\u9650\u516c\u53f8\u3001\u5317\u4eac\u591a\u7ef4\u827e\u65af\u7279\u56fd\u9645\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)","abbr":"","pinyin_shortcut":"dwlhjtgfyxgsdwljkjtjyxgsbjdwastgjgcjsyxgs","description":"","corp_rep":"\u591a\u7ef4\u5bbd","website":"http:\/\/www.duowei.net.cn","capital":"23600","established_at":"2001-02-26","headcount":"300","reg_address":"","working_address":"","telephone":"010-56305030","fax":"","scale":"25\u4ebf","branch":"","purchase_scale_per_yr":"0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":5,"client_type":1,"sales_rep":5295,"main_contact":"","created_by":5096,"created_at":"2019-06-05 16:51:27","updated_at":"2026-03-25 19:46:40","main_business":"\u8d22\u52a1\u3001OA\u3001\u7eff\u8272\u5efa\u7b51\u94a2\u7ed3\u6784\u7cfb\u7edf\u3001\u91d1\u5c5e\u56f4\u62a4\u7cfb\u7edf","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2021-06-17 20:06:19","it_budget":"\u65e0\u56fa\u5b9aIT\u9884\u7b97","deployment_mode":"\u672c\u5730\u90e8\u7f72","it_per_num":"2\u4eba","public_relations_difficulty":"","it_status":"\u751f\u4ea7\u7f51\uff1a10\u6765\u53f0\u670d\u52a1\u5668\uff08HP\u3001DELL\uff09\u30011\u53f0DELL\u5b58\u50a8\u3001\u6df1\u4fe1\u670d\u9632\u706b\u5899\u3001\u8d1f\u8f7d\u5747\u8861\n\u529e\u516c\u7f51\uff1a\u5c0f\u9c7c\u89c6\u9891\u4f1a\u8bae\u3001\u4e0a\u7f51\u884c\u4e3a\u7ba1\u7406","decision_process":"\u5404\u90e8\u95e8\u63d0\u9700\u6c42--\u6280\u672f\u90e8\u63d0\u65b9\u6848--\u9886\u5bfc\u5ba1\u6279--\u91c7\u8d2d","coach":"\u5f20\u656c\u5b9d","competitor":"\u767e\u5ea6\u4e91\u3001\u6613\u8fc5\u901a","peers":"","supplier":"","main_product":"\u94a2\u7ed3\u6784\u53ca\u94a2\u7ef4\u62a4\u4ea7\u54c1\u8bbe\u8ba1\u3001\u751f\u4ea7\u3001\u9500\u552e","client_base_info_count":6,"client_key_info_count":11,"contact_count":10,"visit_count":1,"cooperate_count":11,"case_pre_sales_count":0,"case_implement_count":4,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"77770.00","erp_sales_amount":"121370","erp_other_income_amount":"0","erp_use_amount":"23162.09","erp_profit_amount":"43600.00","erp_j_profit_amount":"20437.91","erp_labor_cost_amount":"6.70960144927536","erp_j_profit_deduct_labor_amount":"20431.2003985507","collect_amount":"1463790.00","un_collect_amount":"0","project_count":"34","budget":"1463790.00","erp_j_profit_pct":16.84,"erp_profit_pct":35.92,"erp_cost_pct":19.08,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},{"id":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjnfsnkmwljsyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"0","company_nature":6,"client_class":80,"client_industry":20,"client_type":5,"sales_rep":5300,"main_contact":"","created_by":5015,"created_at":"2022-04-22 15:54:27","updated_at":"2026-03-25 15:23:28","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2022-04-22 15:54:27","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":5,"case_implement_count":20,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"17008","erp_sales_amount":"150760","erp_other_income_amount":"0","erp_use_amount":"33222.07","erp_profit_amount":"133752","erp_j_profit_amount":"100529.93","erp_labor_cost_amount":"5.44021739130435","erp_j_profit_deduct_labor_amount":"100524.489782609","collect_amount":"627329","un_collect_amount":"74500","project_count":"15","budget":"701829","erp_j_profit_pct":66.68,"erp_profit_pct":88.72,"erp_cost_pct":22.04,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},{"id":1663,"name":"\u5317\u4eac\u8f66\u4e4b\u5bb6\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\u3010\u6c7d\u8f66\u4e4b\u5bb6-\u5317\u4eac\u76ae\u5c14\u5e03\u83b1\u5c3c\u8f6f\u4ef6\u6709\u9650\u516c\u53f8-\u5317\u4eac\u9f50\u5c14\u5e03\u83b1\u7279\u79d1\u6280\u6709\u9650\u516c\u53f8-\u5317\u4eac\u8f66\u667a\u8d62\u79d1\u6280\u6709\u9650\u516c\u53f8\u3011","abbr":"","pinyin_shortcut":"bjczjxxjsyxgsqczjbjpeblnrjyxgsbjqebltkjyxgsbjczykjyxgs","description":"\u5317\u4eac\u76ae\u5c14\u5e03\u83b1\u5c3c\u8f6f\u4ef6\u6709\u9650\u516c\u53f8","corp_rep":"\u9f99\u6cc9","website":"http:\/\/www.autohome.com.cn","capital":"1000","established_at":"2006-08-28","headcount":"","reg_address":"","working_address":2477,"telephone":"59857014","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"0","company_nature":2,"client_class":80,"client_industry":5,"client_type":5,"sales_rep":5300,"main_contact":"","created_by":5089,"created_at":"2020-07-05 22:34:33","updated_at":"2026-03-23 11:08:26","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":6,"client_key_info_count":0,"contact_count":7,"visit_count":2,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":16,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"133000","erp_sales_amount":"140000","erp_other_income_amount":"0","erp_use_amount":"2692.46","erp_profit_amount":"7000","erp_j_profit_amount":"4307.54","erp_labor_cost_amount":"5.44021739130435","erp_j_profit_deduct_labor_amount":"4302.0997826087","collect_amount":"2725800.1","un_collect_amount":"0","project_count":"10","budget":"2725800.1","erp_j_profit_pct":3.08,"erp_profit_pct":5,"erp_cost_pct":1.92,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}},{"id":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240","abbr":"","pinyin_shortcut":"bjtzjxyjs59s","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":5,"client_type":6,"sales_rep":5087,"main_contact":"","created_by":5087,"created_at":"2021-12-31 22:14:02","updated_at":"2026-03-22 20:14:24","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2021-12-31 22:14:02","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":1,"client_key_info_count":0,"contact_count":5,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":1,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"69464.00","erp_sales_amount":"137240","erp_other_income_amount":"0","erp_use_amount":"13698.37","erp_profit_amount":"67776.00","erp_j_profit_amount":"54077.63","erp_labor_cost_amount":"5.44021739130435","erp_j_profit_deduct_labor_amount":"54072.1897826087","collect_amount":"1818373.6","un_collect_amount":"753206.4","project_count":"14","budget":"2571580","erp_j_profit_pct":39.4,"erp_profit_pct":49.39,"erp_cost_pct":9.98,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},{"id":101,"name":"\u4e2d\u56fd\u516c\u8def\u5de5\u7a0b\u54a8\u8be2\u96c6\u56e2\u6709\u9650\u516c\u53f8(\u4e2d\u54a8\u6570\u636e\u6709\u9650\u516c\u53f8)","abbr":"","pinyin_shortcut":"zgglgczxjtyxgszzsjyxgs","description":"","corp_rep":"\u4e0a\u5b98\u7526","website":"","capital":"74976.46615","established_at":"1984-04-10","headcount":"709","reg_address":215,"working_address":641,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":1,"client_class":47,"client_industry":1,"client_type":6,"sales_rep":1005,"main_contact":"","created_by":1005,"created_at":"2017-02-23 15:14:41","updated_at":"2026-03-22 19:51:34","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"China Highway Engineering Consulting Group Co., Ltd.","pick_at":"2021-06-03 15:44:50","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":4,"client_key_info_count":1,"contact_count":3,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":2,"is_overdue_remind":true,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"256000","erp_other_income_amount":"0","erp_use_amount":"99317.405","erp_profit_amount":"256000","erp_j_profit_amount":"156682.595","erp_labor_cost_amount":"5.44021739130435","erp_j_profit_deduct_labor_amount":"156677.154782609","collect_amount":"1296500.00","un_collect_amount":"392500","project_count":"7","budget":"1689000","erp_j_profit_pct":61.2,"erp_profit_pct":100,"erp_cost_pct":38.8,"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}},{"id":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","abbr":"","pinyin_shortcut":"zgxxaqyjs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"01062305540","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0","purchase_freq":"","company_nature":3,"client_class":1,"client_industry":4,"client_type":6,"sales_rep":1001,"main_contact":"","created_by":5076,"created_at":"2018-05-16 18:55:46","updated_at":"2026-05-25 11:18:55","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2024-06-27 14:45:57","it_budget":"800","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":2,"client_key_info_count":1,"contact_count":62,"visit_count":1,"cooperate_count":5,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"782.205","erp_sales_amount":"12703072","erp_other_income_amount":"0","erp_use_amount":"3912.41","erp_profit_amount":"12702289.795","erp_j_profit_amount":"12698377.385","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"12698377.385","collect_amount":"2486953.00","un_collect_amount":"12812634","project_count":"6","budget":"15299587","erp_j_profit_pct":99.96,"erp_profit_pct":99.99,"erp_cost_pct":0.03,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":3389,"name":"\u4e2d\u56fd\u8bc1\u5238\u62a5\u6709\u9650\u8d23\u4efb\u516c\u53f8","abbr":"","pinyin_shortcut":"zgzqbyxzrgs","description":"","corp_rep":"\u5f90\u5bff\u677e","website":"www.cs.com.cn","capital":"5000","established_at":"1993-03-18","headcount":"","reg_address":"","working_address":"","telephone":"010-63070225","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":18,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":1011,"created_at":"2025-08-21 12:22:51","updated_at":"2026-05-25 10:12:46","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2025-08-21 12:22:51","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":6,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":3,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":5912,"tax_no":"91110000400012043F","erp_cost_amount":"261901","erp_sales_amount":"288000","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"26099","erp_j_profit_amount":"26099","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"26099","collect_amount":"180000","un_collect_amount":"110700","project_count":"4","budget":"290700","erp_j_profit_pct":9.06,"erp_profit_pct":9.06,"erp_cost_pct":0,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":3304,"name":"\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","abbr":"","pinyin_shortcut":"bjyckjyxgsgd","description":"","corp_rep":"\u5409\u5a1f","website":"","capital":"500","established_at":"2020-06-03","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":1001,"created_at":"2024-09-19 15:34:42","updated_at":"2026-05-25 10:11:37","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0\uff1a\u5317\u4eac\u6708\u521d\u79d1\u6280\u6709\u9650\u516c\u53f8\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a91110111MA01RP4H80\n\u5f00\u6237\u94f6\u884c\uff1a\u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5174\u5b9c\u652f\u884c\n\u94f6\u884c\u8d26\u53f7\uff1a0200 3014 0910 0054 430\n\u5730\u5740\uff1a\u5317\u4eac\u5e02\u623f\u5c71\u533a\u62f1\u8fb0\u8857\u9053\u6708\u534e\u5927\u88571\u53f7A8-667\n\u7535\u8bdd\uff1a13717705170","logo":"","en_name":"","pick_at":"2024-09-19 15:34:42","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":5,"client_key_info_count":0,"contact_count":2,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":1262,"tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","collect_amount":"479483.89","un_collect_amount":"0","project_count":"2","budget":"479483.89","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":2150,"name":"\u5317\u4eac\u5730\u5e73\u7ebf\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u5b89\u4ead\u5730\u5e73\u7ebf\u667a\u80fd\u4ea4\u901a\u6280\u672f\u6709\u9650\u516c\u53f8\/\u4e0a\u6d77\u7ea2\u897f\u74dc\u534a\u5bfc\u4f53\u6709\u9650\u516c\u53f8\/\u5b81\u6ce2\u5730\u5e73\u7ebf\u98d2\u817e\u79d1\u6280\u6709\u9650\u516c\u53f8(EDA)","abbr":"","pinyin_shortcut":"bjdpxxxjsyxgsshatdpxznjtjsyxgsshhxgbdtyxgsnbdpxstkjyxgsEDA","description":"\u7a0e\u53f7\uff1a91110108MA002R5L5Y","corp_rep":"\u4f59\u51ef","website":"https:\/\/www.horizon.ai\/","capital":"35000","established_at":"2015-12-28","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":6,"client_class":43,"client_industry":57,"client_type":3,"sales_rep":1001,"main_contact":"","created_by":1011,"created_at":"2022-02-16 10:45:21","updated_at":"2026-05-22 17:08:02","main_business":"","deleted":false,"capital_currency":"usd","invoice_info":"","logo":"","en_name":"","pick_at":"2026-03-23 09:31:39","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":5,"client_key_info_count":0,"contact_count":5,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"2391.00","erp_profit_amount":"0","erp_j_profit_amount":"-2391.00","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-2391","collect_amount":"2081561.88","un_collect_amount":"0","project_count":"8","budget":"2291559.88","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":3009,"name":"\u540c\u65b9\u77e5\u7f51(\u5317\u4eac)\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(\u5149\u76d8\u7248)\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"tfzwbjjsyxgstfzwszcbjsgfyxgszgxsqkgpbdzzzsyxgs","description":"\u540d\u79f0\uff1a\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a91110108710924451B\n\u5730\u5740\u3001\u7535\u8bdd\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u5c0f\u53e3\u8def66\u53f7\u4e2d\u5173\u6751\u4e1c\u5347\u79d1\u6280\u56edB-2\u53f7\u697c\u4e8c\u5c42B201-B203\u3001B205-B210\u5ba4(\u4e1c\u5347\u5730\u533a) 62969002-8076\n\u5f00\u6237\u884c\u53ca\u8d26\u53f7\uff1a\u5efa\u884c\u6e05\u534e\u5927\u5b66\u652f\u884c11001029000052500014\n\n\u540d\u79f0\uff1a\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a\uff08\u5149\u76d8\u7248\uff09\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a911101086337298973\n\u5730\u5740\u3001\u7535\u8bdd\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u6e05\u534e\u56ed\u6e05\u534e\u5927\u5b6636\u533a1407\u30011408\u30011409 62969002-8079\n\u5f00\u6237\u884c\u53ca\u8d26\u53f7\uff1a\u62db\u5546\u94f6\u884c\u6e05\u534e\u56ed\u652f\u884c866780465610001\n\n\u540d\u79f0\uff1a\u540c\u65b9\u77e5\u7f51\uff08\u5317\u4eac\uff09\u6280\u672f\u6709\u9650\u516c\u53f8\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a911101087693507203\n\u5730\u5740\u3001\u7535\u8bdd\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u5c0f\u53e3\u8def66\u53f7\u4e1c\u5347\u79d1\u6280\u56ed\u5317\u9886\u5730A\u533a\u7b2c2\u53f7\u697c 62969002-8076\n\u5f00\u6237\u884c\u53ca\u8d26\u53f7\uff1a\u5efa\u884c\u6e05\u534e\u5927\u5b66\u652f\u884c11001029000059809201\n","corp_rep":"\u5218\u957f\u6b23","website":"www.cnki.net","capital":"826.41","established_at":"2004-11-18","headcount":"","reg_address":"","working_address":3501,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":3,"client_class":43,"client_industry":18,"client_type":6,"sales_rep":1001,"main_contact":"","created_by":1011,"created_at":"2024-05-07 16:42:41","updated_at":"2026-05-22 16:49:10","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2024-05-07 16:42:41","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":5,"client_key_info_count":0,"contact_count":3,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","collect_amount":"1898400","un_collect_amount":"0","project_count":"2","budget":"1898400","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":2593,"name":"\u56fd\u5bcc\u745e\u6570\u636e\u7cfb\u7edf\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","abbr":"","pinyin_shortcut":"gfrsjxtyxgsgd","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":3,"client_class":43,"client_industry":10,"client_type":6,"sales_rep":1001,"main_contact":"","created_by":1005,"created_at":"2023-09-24 21:17:42","updated_at":"2026-05-22 16:48:10","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-04-15 16:53:08","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":0,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"0","erp_j_profit_amount":"0","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"0","collect_amount":"49500","un_collect_amount":"0","project_count":"1","budget":"49500","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":1188,"name":"\u4e2d\u56fd\u7164\u70ad\u5730\u8d28\u603b\u5c40","abbr":"","pinyin_shortcut":"zgmtdzzj","description":"","corp_rep":"\u8d75\u5e73\uff08\u515a\u59d4\u6570\u636e\uff0c\u5c40\u957f\uff09","website":"http:\/\/www.ccgc.cn\/","capital":"","established_at":"1953-01-01","headcount":"","reg_address":"","working_address":1612,"telephone":"010-63903775 010-63903982 ","fax":"010-63903707","scale":"2020\u5e74269.92\u4ebf\uff0c2019\u5e74242.10\u4ebf","branch":"\u662f\u56fd\u52a1\u9662\u56fd\u8d44\u59d4\u76f4\u63a5\u7ba1\u7406\u7684\u4e2d\u592e\u4f01\u4e1a\uff0c\u4e0b\u8f96\u4e2d\u5316\u5730\u8d28\u77ff\u5c71\u603b\u5c40\u3001\u4e13\u4e1a\u76f4\u5c5e\u5c40\u3001\u7701\uff08\u533a\uff09\u7164\u70ad\u5730\u8d28\u5c40\u4ee5\u53ca\u4e2d\u5fc3\u3001\u9662\uff08\u961f\uff09\u7b49\u5355\u4f4d200\u4f59\u5bb6\uff0c\u5206\u5e03\u5728\u5168\u56fd22\u4e2a\u7701\uff08\u5e02\u3001\u533a\uff09","purchase_scale_per_yr":"0","purchase_freq":"","company_nature":1,"client_class":"","client_industry":16,"client_type":6,"sales_rep":1005,"main_contact":"","created_by":5096,"created_at":"2018-11-06 18:49:53","updated_at":"2026-05-21 17:21:08","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"China National Administration of Coal Geology","pick_at":"2025-05-26 17:35:34","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":7,"client_key_info_count":1,"contact_count":3,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"41734.00","erp_profit_amount":"0","erp_j_profit_amount":"-41734.00","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-41734","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}}],"pagenation":{"totalcount":1991,"thispage":1,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-01 11:40:57', 715208192) RETURNING "id" |
| 11:40:57.145 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 11:40:57.145 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |