6a1d3dc017a91: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-client-cost at 2026-06-01 04:07:28 pm by 221.216.117.119
Log Messages
总计32条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 16:07:28.096 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 16:07:28.096 | trace | yii\base\Module::getModule | Loading module: debug |
| 16:07:28.096 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 16:07:28.097 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 16:07:28.097 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 16:07:28.097 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:07:28.097 | info | time tracing start | 1780301248097382912 |
| 16:07:28.097 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 16:07:28.097 | trace | yii\web\Application::handleRequest | Route requested: 'vue/erp-analysis/list-client-cost' |
| 16:07:28.097 | trace | yii\base\Module::getModule | Loading module: vue |
| 16:07:28.098 | info | yii\web\Session::open | Session started |
| 16:07:28.098 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5064 |
| 16:07:28.098 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 16:07:28.099 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:07:28.099 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:07:28.100 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:07:28.100 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:07:28.100 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064 |
| 16:07:28.101 | trace | yii\base\Controller::runAction | Route to run: vue/erp-analysis/list-client-cost |
| 16:07:28.101 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:07:28.102 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 16:07:28.102 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\ErpAnalysisController::actionListClientCost() |
| 16:07:28.102 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:07:28.103 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:07:28.112 | 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"."bargain_date" >= '2026-01-01 00:00:00') AND ("t"."bargain_date" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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 ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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 ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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 ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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)) AND ("p"."start_at" >= '2026-01-01 00:00:00') AND ("p"."start_at" <= '2026-12-31 23:59:59')) 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)) AND ("i"."arrived_at" >= '2026-01-01 00:00:00') AND ("i"."arrived_at" <= '2026-12-31 23:59:59') )) "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) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') GROUP BY "t"."client_id") "scs" ON c.id = scs.client_id GROUP BY "c"."id") "c" ORDER BY "c"."updated_at" DESC) "c" |
| 16:07:28.123 | 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"."bargain_date" >= '2026-01-01 00:00:00') AND ("t"."bargain_date" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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 ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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 ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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 ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') 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)) AND ("p"."start_at" >= '2026-01-01 00:00:00') AND ("p"."start_at" <= '2026-12-31 23:59:59')) 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)) AND ("i"."arrived_at" >= '2026-01-01 00:00:00') AND ("i"."arrived_at" <= '2026-12-31 23:59:59') )) "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) AND ("t"."created_at" >= '2026-01-01 00:00:00') AND ("t"."created_at" <= '2026-12-31 23:59:59') GROUP BY "t"."client_id") "scs" ON c.id = scs.client_id GROUP BY "c"."id") "c" ORDER BY "c"."updated_at" DESC LIMIT 40 |
| 16:07:28.165 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5087, 1005, 5295, 5300, 1004) |
| 16:07:28.167 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:07:28.167 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 16:07:28.168 | 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', 5064, 5, 'vue/erp-analysis/list-client-cost', '{"created_at_period":"currentfascalyear","sales_rep":"","page":"1","pageSize":"40","listReload":"true","web_access_token":"66P66ib-3t6D-JRCTEPzE250hI-J5OEu"}', '{"code":2000,"result":{"list":[{"id":3311,"name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjhcykjyxgs","description":"","corp_rep":"\u6d2a\u79d1","website":"http:\/\/www.bjhdd.com","capital":"100","established_at":"2009-11-04","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-10-16 11:09:32","updated_at":"2026-06-01 12:46:45","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2024-10-16 11:09:32","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":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":4838,"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":"201.068783068783","erp_j_profit_deduct_labor_amount":"-201.068783068783","collect_amount":"0","un_collect_amount":"88221","project_count":"1","budget":"88221","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"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":"2248.74","erp_profit_amount":"320864","erp_j_profit_amount":"318615.26","erp_labor_cost_amount":"661.446306818182","erp_j_profit_deduct_labor_amount":"317953.813693182","collect_amount":"600077","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":50.44,"erp_profit_pct":50.8,"erp_cost_pct":0.36,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},{"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":"101","erp_profit_amount":"12702289.795","erp_j_profit_amount":"12702188.795","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"12702188.795","collect_amount":"103","un_collect_amount":"12812634","project_count":"5","budget":"12812737","erp_j_profit_pct":99.99,"erp_profit_pct":99.99,"erp_cost_pct":0,"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":"1","erp_sales_amount":"18000","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"17999","erp_j_profit_amount":"17999","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"17999","collect_amount":"0","un_collect_amount":"20700","project_count":"3","budget":"20700","erp_j_profit_pct":99.99,"erp_profit_pct":99.99,"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":"0","un_collect_amount":"0","project_count":"0","budget":"0","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":"333","erp_profit_amount":"0","erp_j_profit_amount":"-333","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-333","collect_amount":"2","un_collect_amount":"0","project_count":"0","budget":"210000","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":"0","un_collect_amount":"0","project_count":"0","budget":"0","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":"0","un_collect_amount":"0","project_count":"0","budget":"0","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":"41490","erp_profit_amount":"0","erp_j_profit_amount":"-41490","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-41490","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"}},{"id":1933,"name":"SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8(\u91cd\u590d\u5ba2\u6237)","abbr":"","pinyin_shortcut":"SMCbjzzyxgscfkh","description":"smc\u4e2d\u56fd\u516c\u53f8\u5317\u4eac\u5206\u5382","corp_rep":"\u8d75\u5f64","website":"","capital":"","established_at":"2000-12-31","headcount":"3000","reg_address":"","working_address":2303,"telephone":"80480101","fax":"","scale":"10","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":6,"client_class":43,"client_industry":5,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":1003,"created_at":"2020-09-29 09:58:29","updated_at":"2026-05-18 14:33:52","main_business":"\u5236\u9020\u5de5\u4e1a\u81ea\u52a8\u5316\u5143\u4ef6","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2024-10-28 17:59:19","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":3,"contact_count":3,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":6,"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":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":399,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240\u4e2d\u76fe(\u8fc7\u5355\u516c\u53f8)","abbr":"","pinyin_shortcut":"gabdyyjszdgdgs","description":"","corp_rep":"\u9648\u671d\u6b66","website":"","capital":"18000","established_at":"1992-06-23","headcount":"","reg_address":"","working_address":634,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":1,"client_class":43,"client_industry":1,"client_type":1,"sales_rep":1005,"main_contact":"","created_by":1001,"created_at":"2017-07-04 15:14:12","updated_at":"2026-05-18 13:48:27","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"\/files\/cdn\/a57be577deb434\/logo\/6fc2ad20-226c-311c-9f64-96f95d6c6bdd.png","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":0,"contact_count":4,"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":"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"}},{"id":3429,"name":"\u5e7f\u5dde\u4e16\u5b89\u4fe1\u606f\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"gzsaxxjsgfyxgs","description":"","corp_rep":"\u9648\u5fd7\u8363","website":"www.gzsa.net","capital":"2000","established_at":"2004-02-18","headcount":"","reg_address":"","working_address":"","telephone":"020-87563180","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":1011,"created_at":"2025-12-04 15:48:49","updated_at":"2026-05-15 13:07:30","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2025-12-04 15:48:49","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":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":6029,"tax_no":"91440116757793663E","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":"3587784","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":1111,"name":"\u4e2d\u56fd\u79d1\u5b66\u9662\u884c\u653f\u7ba1\u7406\u5c40","abbr":"","pinyin_shortcut":"zgkxyxzglj","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":1522,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":1,"client_class":"","client_industry":1,"client_type":6,"sales_rep":5295,"main_contact":"","created_by":1006,"created_at":"2018-08-27 11:47:28","updated_at":"2026-05-13 15:00:43","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2025-10-21 09:55:29","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":4,"cooperate_count":1,"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":"117","erp_profit_amount":"0","erp_j_profit_amount":"-117","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-117","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},{"id":3432,"name":"\u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662","abbr":"","pinyin_shortcut":"zgmhglgbxy","description":"","corp_rep":"\u4e8e\u5251","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"010-64720239","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":3,"client_class":80,"client_industry":1,"client_type":1,"sales_rep":1001,"main_contact":"","created_by":1011,"created_at":"2025-12-19 13:31:40","updated_at":"2026-05-12 13:48:50","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u540d\u79f0\uff1a \u4e2d\u56fd\u6c11\u822a\u7ba1\u7406\u5e72\u90e8\u5b66\u9662\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a 121000004008366672\n\u5f00\u6237\u94f6\u884c\uff1a \u5de5\u5546\u94f6\u884c\u5317\u4eac\u56db\u5143\u6865\u652f\u884c\n\u94f6\u884c\u8d26\u53f7\uff1a 0200080509026401168\n\u5730\u5740\uff1a \u5317\u4eac\u5e02\u671d\u9633\u533a\u82b1\u5bb6\u5730\u4e1c\u8def3\u53f7\n\u8054\u7cfb\u7535\u8bdd\uff1a 010-64720239","logo":"","en_name":"","pick_at":"2025-12-19 13:31:40","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":3,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":2,"case_pre_sales_count":1,"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":"5","erp_profit_amount":"0","erp_j_profit_amount":"-5","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-5","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":2616,"name":"\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","abbr":"","pinyin_shortcut":"bjydsbkjyxgsgd","description":"","corp_rep":"\u9648\u84c9","website":"","capital":"1000","established_at":"2010-02-01","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":1001,"main_contact":"","created_by":5359,"created_at":"2023-10-23 21:18:16","updated_at":"2026-05-09 18:11:24","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0\uff1a\u5317\u4eac\u6e90\u70b9\u601d\u535a\u79d1\u6280\u6709\u9650\u516c\u53f8 \n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a911101085514397148\n\u5730\u5740\uff0c\u7535\u8bdd\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u5317\u4e09\u73af\u897f\u8def32\u53f7\u697c16\u5c421806\u5ba4 010-82095611\n\u5f00\u6237\u884c\u53ca\u5e10\u53f7\uff1a\u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5317\u592a\u5e73\u5e84\u652f\u884c 0200010019200496640","logo":"","en_name":"","pick_at":"2025-01-13 16:21:22","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":1,"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":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":2538,"name":"(\u8fc7\u5355)\u5317\u4eac\u6606\u4ed1\u8054\u901a\u79d1\u6280\u53d1\u5c55\u80a1\u4efd\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"gdbjklltkjfzgfyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":3089,"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":1001,"main_contact":"","created_by":5295,"created_at":"2023-05-18 11:35:22","updated_at":"2026-05-09 18:10:57","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2024-11-13 10:19:31","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":0,"cooperate_count":1,"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":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":146,"name":"smc(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8-(\u91cd\u590d\u5ba2\u6237)","abbr":"","pinyin_shortcut":"smctjzzyxgscfkh","description":"smc\u5206\u516c\u53f8","corp_rep":"\u8d75\u5f64","website":"","capital":"200000.000000","established_at":"2016-04-18","headcount":"500","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"20","purchase_freq":"3","company_nature":6,"client_class":43,"client_industry":5,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":1003,"created_at":"2017-03-06 15:44:05","updated_at":"2026-05-09 17:18:35","main_business":"\u6c14\u538b\u52a8\u529b\u673a\u68b0\u53ca\u90e8\u4ef6\u3001\u5de5\u4e1a\u81ea\u52a8\u5316\u63a7\u5236\u8bbe\u5907\u53ca\u90e8\u4ef6\u7684\u5236\u9020\u3001","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2024-10-30 09:56: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":3,"client_key_info_count":2,"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":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":2803,"name":"\u62d3\u5b9e\u603b\u76d1\u4f1a","abbr":"","pinyin_shortcut":"tszjh","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":3438,"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":1011,"created_at":"2024-03-04 13:47:14","updated_at":"2026-05-09 17:11:06","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2024-03-04 13:47:14","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":10,"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":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":1661,"name":"\u5317\u4eac\u7f51\u4fe1\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjwxykjyxgs","description":"\u6881\u5b87\u4ecb\u7ecd","corp_rep":"\u674e\u4e1c","website":"http:\/\/www.netcell.cn","capital":"500","established_at":"2005-11-18","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":1011,"created_at":"2020-06-23 16:16:09","updated_at":"2026-05-09 17:07:04","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":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":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"222","erp_profit_amount":"0","erp_j_profit_amount":"-222","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-222","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":3456,"name":"\u5317\u4eac\u521b\u601d\u7acb\u4fe1\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjcslxkjyxgs","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":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":5295,"main_contact":"","created_by":1011,"created_at":"2026-03-20 13:38:56","updated_at":"2026-05-09 09:47:38","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-03-20 13:38:56","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":2,"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":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},{"id":3319,"name":"\u4e2d\u79d1\u4fe1\u606f\u5b89\u5168\u5171\u6027\u6280\u672f\u56fd\u5bb6\u5de5\u7a0b\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"zkxxaqgxjsgjgcyxgs","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":"","client_industry":13,"client_type":5,"sales_rep":"","main_contact":"","created_by":5420,"created_at":"2024-11-12 15:16:45","updated_at":"2026-04-30 13:52:47","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2024-11-12 15:16:45","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":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":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":""},{"id":3377,"name":"\u5317\u4eac\u5a01\u53d1\u65b0\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","abbr":"","pinyin_shortcut":"bjwfxsjxxjsyxgsgd","description":"\u6ce8\u518c\u5730\u5740\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u7d2b\u7af9\u9662\u8def\u5e7f\u6e90\u95f85\u53f75\u5c425132","corp_rep":"\u9648\u9521\u5f3a","website":"www.wafersystems.com","capital":"1500","established_at":"2001-01-12","headcount":"","reg_address":"","working_address":"","telephone":"010-85184988","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":1011,"created_at":"2025-07-02 09:55:22","updated_at":"2026-04-30 13:49:40","main_business":"","deleted":false,"capital_currency":"usd","invoice_info":"","logo":"","en_name":"","pick_at":"2026-01-12 09:41:29","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":3,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":4137,"tax_no":"","erp_cost_amount":"1046515","erp_sales_amount":"1630000","erp_other_income_amount":"0","erp_use_amount":"389712","erp_profit_amount":"583485","erp_j_profit_amount":"193773","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"193773","collect_amount":"0","un_collect_amount":"1629001","project_count":"1","budget":"1630000","erp_j_profit_pct":11.89,"erp_profit_pct":35.8,"erp_cost_pct":23.91,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":3435,"name":"\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjzbszkjyxgs","description":"","corp_rep":"\u853a\u5b5d\u8f89","website":"","capital":"1000","established_at":"2024-06-28","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":1011,"created_at":"2026-01-22 11:50:06","updated_at":"2026-04-30 13:48:32","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u540d\u79f0\uff1a\u5317\u4eac\u4e2d\u535a\u6570\u667a\u79d1\u6280\u6709\u9650\u516c\u53f8\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a91110108MADPU4EL94\n\u5730\u5740\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u519c\u5927\u5357\u8def1\u53f7\u96622\u53f7\u697c2\u5c42\u529e\u516cA-205\n\u7535\u8bdd\uff1a13911694094\n\u5f00\u6237\u94f6\u884c\uff1a\u62db\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u4e0a\u5730\u652f\u884c\n\u94f6\u884c\u8d26\u53f7\uff1a110963366510001","logo":"","en_name":"","pick_at":"2026-01-22 11:50:06","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":0,"contact_count":1,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"91110108MADPU4EL94","erp_cost_amount":"0","erp_sales_amount":"29800","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"29800","erp_j_profit_amount":"29800","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"29800","collect_amount":"29800","un_collect_amount":"0","project_count":"1","budget":"29800","erp_j_profit_pct":100,"erp_profit_pct":100,"erp_cost_pct":0,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","abbr":"","pinyin_shortcut":"bjjhjstxyjs304","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-24 06:21:13","updated_at":"2026-04-29 18:13:44","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2023-09-18 16:36:05","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":21,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":3,"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":"120","erp_profit_amount":"0","erp_j_profit_amount":"-120","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-120","collect_amount":"195300","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},{"id":1956,"name":"\u5ea6\u5c0f\u6ee1\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"dxmkjbjyxgs","description":"","corp_rep":"\u8bb8\u4e1c\u4eae","website":"","capital":"1111200","established_at":"2015-01-19","headcount":"","reg_address":"","working_address":2320,"telephone":"010-61951001","fax":"010-61951002","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":1,"client_class":43,"client_industry":10,"client_type":5,"sales_rep":"","main_contact":"","created_by":1001,"created_at":"2020-11-06 09:35:00","updated_at":"2026-04-23 16:20:14","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":2,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":1,"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":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":""},{"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":"32901.47","erp_profit_amount":"3600","erp_j_profit_amount":"-29301.47","erp_labor_cost_amount":"2532.13465909091","erp_j_profit_deduct_labor_amount":"-31833.6046590909","collect_amount":"0","un_collect_amount":"18600","project_count":"1","budget":"18600","erp_j_profit_pct":-157.53,"erp_profit_pct":19.35,"erp_cost_pct":176.89,"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":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"12788.64","erp_profit_amount":"0","erp_j_profit_amount":"-12788.64","erp_labor_cost_amount":"40.1565340909091","erp_j_profit_deduct_labor_amount":"-12828.7965340909","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},{"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":"17711.46","erp_profit_amount":"47355","erp_j_profit_amount":"29643.54","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"29643.54","collect_amount":"227328","un_collect_amount":"151552","project_count":"1","budget":"378880","erp_j_profit_pct":8.88,"erp_profit_pct":14.18,"erp_cost_pct":5.3,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},{"id":2191,"name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjtskjyxgs","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":4,"client_class":"","client_industry":"","client_type":"","sales_rep":"","main_contact":"","created_by":5064,"created_at":"2022-05-10 13:56:33","updated_at":"2026-04-22 15:46:14","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2022-05-10 13:56:33","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":"4391.2033333332","erp_profit_amount":"0","erp_j_profit_amount":"-4391.2033333332","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-4391.2033333332","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":""},{"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":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"14556.950","erp_profit_amount":"0","erp_j_profit_amount":"-14556.950","erp_labor_cost_amount":"334.890340909091","erp_j_profit_deduct_labor_amount":"-14891.8403409091","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"}},{"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":"0","erp_other_income_amount":"0","erp_use_amount":"4344.40","erp_profit_amount":"0","erp_j_profit_amount":"-4344.40","erp_labor_cost_amount":"417.476420454546","erp_j_profit_deduct_labor_amount":"-4761.87642045455","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"}},{"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":"454.12","erp_profit_amount":"0","erp_j_profit_amount":"-454.12","erp_labor_cost_amount":"90.9204545454545","erp_j_profit_deduct_labor_amount":"-545.040454545455","collect_amount":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}},{"id":3278,"name":"\u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjcagtkjfzyxgs","description":"","corp_rep":"\u675c\u78ca","website":"","capital":"200","established_at":"2016-06-20","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":1011,"created_at":"2024-06-26 10:41:52","updated_at":"2026-04-20 14:20:08","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0\uff1a \u5317\u4eac\u521b\u5b89\u5149\u901a\u79d1\u6280\u53d1\u5c55\u6709\u9650\u516c\u53f8 \n\u7edf\u4e00\u793e\u4f1a\u4fe1\u7528\u4ee3\u7801\uff1a 91110114MA006F0W2X \n\u5730\u5740\u7535\u8bdd\uff1a \u5317\u4eac\u5e02\u660c\u5e73\u533a\u57ce\u5357\u8857\u9053\u9f99\u6c34\u8def28\u53f7\u697c-1\u81f32\u5c42028-3\u5185-1\u5c42B101 010-58444180 \n\u5f00\u6237\u94f6\u884c\u53ca\u5e10\u53f7\uff1a \u5174\u4e1a\u94f6\u884c\u5317\u4eac\u5206\u884c\u957f\u5b89\u652f\u884c 321120100100304908 ","logo":"","en_name":"","pick_at":"2024-06-26 10:41:52","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":1,"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":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":3424,"name":"\u5317\u4eac\u888b\u9f20\u4e91\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjdsykjyxgs","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":4,"client_class":43,"client_industry":19,"client_type":5,"sales_rep":"","main_contact":"","created_by":1011,"created_at":"2025-11-18 14:53:54","updated_at":"2026-04-18 16:55:28","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":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":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":""},{"id":3454,"name":"\u7a37\u5c71\u53bf\u5b89\u536b\u58eb\u7535\u5b50\u6280\u672f\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"jsxawsdzjsyxgs","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":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":5295,"main_contact":"","created_by":1011,"created_at":"2026-03-10 13:49:38","updated_at":"2026-04-16 10:36:45","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-03-10 13:49: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":0,"client_key_info_count":0,"contact_count":0,"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":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}},{"id":2737,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6240\u529e)","abbr":"","pinyin_shortcut":"gabdyyjssb","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":1,"client_type":1,"sales_rep":1005,"main_contact":"","created_by":1004,"created_at":"2023-12-18 17:36:53","updated_at":"2026-04-15 16:55:04","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-04-15 16:55:04","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":4,"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":"4599.31","erp_profit_amount":"0","erp_j_profit_amount":"-4599.31","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-4599.31","collect_amount":"1275850","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"}},{"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":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"222","erp_profit_amount":"0","erp_j_profit_amount":"-222","erp_labor_cost_amount":"136.380681818182","erp_j_profit_deduct_labor_amount":"-358.380681818182","collect_amount":"148320","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":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":"520","erp_sales_amount":"2000","erp_other_income_amount":"0","erp_use_amount":"319.75","erp_profit_amount":"1480","erp_j_profit_amount":"1160.25","erp_labor_cost_amount":"137.896022727273","erp_j_profit_deduct_labor_amount":"1022.35397727273","collect_amount":"2000","un_collect_amount":"0","project_count":"1","budget":"2000","erp_j_profit_pct":58.01,"erp_profit_pct":74,"erp_cost_pct":15.99,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},{"id":73,"name":"\u5317\u4eac\u5e02\u653f\u4ea4\u901a\u4e00\u5361\u901a\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjszjtyktyxgs","description":"","corp_rep":"\u71d5\u6e05 ","website":" http:\/\/www.bmac.com.cn","capital":"20292","established_at":"2000-10-23","headcount":"500","reg_address":162,"working_address":640,"telephone":" 010-88087755","fax":"","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":1,"client_class":"","client_industry":1,"client_type":1,"sales_rep":"","main_contact":"","created_by":1005,"created_at":"2017-02-16 17:10:25","updated_at":"2026-04-09 17:13:23","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2023-06-08 23:02:32","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"\u5e02\u653f\u4ea4\u901a\u4e00\u5361\u901a\u3001\u5317\u4eac\u4e92\u901a\u5361\u3001\u5e02\u90ca\u94c1\u8def\u4e00\u5361\u901a\u3001\u6587\u5316\u521b\u610f\u5361\u3001\u516c\u5171\u670d\u52a1\u5361","client_base_info_count":6,"client_key_info_count":2,"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":"0","un_collect_amount":"0","project_count":"0","budget":"0","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":""},{"id":3286,"name":"\u826f\u56fe\u79d1\u6280(\u4e0a\u6d77)\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"ltkjshyxgs","description":"\u53d1\u7968\u5bc4\u9001\u5730\u5740\uff1a\u4e0a\u6d77\u5e02\u9759\u5b89\u533a\u6c5f\u573a\u897f\u8def299\u5f0449\u53f7\u4e2d\u94c1\u4e2d\u73af\u65f6\u4ee3\u5e7f\u573a1\u53f7\u697c1201B \u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8 \u8d22\u52a1\u4e18\u794e\u7a0b 021-61421866","corp_rep":"CHIA HONG LOONG ERIC","website":"","capital":"1000","established_at":"2006-04-09","headcount":"","reg_address":"","working_address":3793,"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-07-03 14:38:20","updated_at":"2026-04-08 15:49:36","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0: \u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8\n\u7edf\u4e00\u793e\u4f1a\u4fe1\u7528\u4ee3\u7801\uff1a 91310000786707955D\n\u516c\u53f8\u5730\u5740\u53ca\u7535\u8bdd:\u3000\u4e0a\u6d77\u5e02\u9759\u5b89\u533a\u6c5f\u573a\u897f\u8def299\u5f0449\u53f71201-3\u30011201-4\u30011201-5\u5ba4\u00a0\u00a0\u00a0 021-61421866\n\u5f00\u6237\u94f6\u884c\u3001\u8d26\u53f7\uff1a\u4ea4\u901a\u94f6\u884c\u5e02\u5317\u5de5\u4e1a\u533a\u652f\u884c\u00a0 310066247018160174864\u00a0 ","logo":"","en_name":"","pick_at":"2024-07-03 14:38:20","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":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":1262,"tax_no":"","erp_cost_amount":"158798.2","erp_sales_amount":"176442","erp_other_income_amount":"0","erp_use_amount":"0","erp_profit_amount":"17643.8","erp_j_profit_amount":"17643.8","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"17643.8","collect_amount":"0","un_collect_amount":"309425.78","project_count":"1","budget":"309425.78","erp_j_profit_pct":10,"erp_profit_pct":10,"erp_cost_pct":0,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}],"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_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/148.0.0.0 Safari\/537.36"}', FALSE, '2026-06-01 16:07:28', 70652160) RETURNING "id" |
| 16:07:28.171 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 16:07:28.171 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |