6a4da904a7a56: POST https://beta.jinchangxiao.com/vue/erp-analysis/list-client-cost at 2026-07-08 09:33:56 am by 39.156.194.178
Log Messages
总计33条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 09:33:56.685 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 09:33:56.685 | trace | yii\base\Module::getModule | Loading module: debug |
| 09:33:56.686 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 09:33:56.686 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 09:33:56.687 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 09:33:56.687 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 09:33:56.688 | info | time tracing start | 1783474436688112128 |
| 09:33:56.688 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 09:33:56.688 | trace | yii\web\Application::handleRequest | Route requested: 'vue/erp-analysis/list-client-cost' |
| 09:33:56.688 | trace | yii\base\Module::getModule | Loading module: vue |
| 09:33:56.691 | info | yii\web\Session::open | Session started |
| 09:33:56.693 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 09:33:56.693 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 09:33:56.694 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 09:33:56.695 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 09:33:56.696 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 09:33:56.697 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 09:33:56.697 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 09:33:56.697 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 09:33:56.698 | trace | yii\base\Controller::runAction | Route to run: vue/erp-analysis/list-client-cost |
| 09:33:56.699 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 09:33:56.701 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 09:33:56.701 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\ErpAnalysisController::actionListClientCost() |
| 09:33:56.701 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 09:33:56.703 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 09:33:56.709 | 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"."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') AND (p.end_at IS NOT NULL) AND (p.end_at > p.start_at) AND (p.engineer_id IS NOT NULL)) UNION ALL ( SELECT i.id as ticket_id, 'implementRecords' as ticket_type, '实施' as ticket_type_name, i.ticket_no, i.case_id, c.case_no, COALESCE(i.client_id, c.client_id) as client_id, c.project_id, cl.sales_rep as sales_rep_id, c.last_engineer as engineer_id, i.arrived_at as start_at, i.left_at as end_at, date_trunc('month', i.arrived_at)::date as settle_month, EXTRACT(EPOCH FROM (i.left_at - i.arrived_at)) / 3600 as work_hours FROM "a57be577deb434"."tbl_implement_records" "i" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = i.case_id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON cl.id = COALESCE(i.client_id, c.client_id) WHERE (i.arrived_at IS NOT NULL) AND (("i"."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') AND (i.left_at IS NOT NULL) AND (i.left_at > i.arrived_at) AND (c.last_engineer IS NOT NULL) )) "ct" LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = ct.project_id 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 WHERE "c"."sales_rep"='1001' GROUP BY "c"."id") "c" ORDER BY "c"."updated_at" DESC) "c" |
| 09:33:56.729 | 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"."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') AND (p.end_at IS NOT NULL) AND (p.end_at > p.start_at) AND (p.engineer_id IS NOT NULL)) UNION ALL ( SELECT i.id as ticket_id, 'implementRecords' as ticket_type, '实施' as ticket_type_name, i.ticket_no, i.case_id, c.case_no, COALESCE(i.client_id, c.client_id) as client_id, c.project_id, cl.sales_rep as sales_rep_id, c.last_engineer as engineer_id, i.arrived_at as start_at, i.left_at as end_at, date_trunc('month', i.arrived_at)::date as settle_month, EXTRACT(EPOCH FROM (i.left_at - i.arrived_at)) / 3600 as work_hours FROM "a57be577deb434"."tbl_implement_records" "i" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON c.id = i.case_id LEFT JOIN "a57be577deb434"."tbl_clients" "cl" ON cl.id = COALESCE(i.client_id, c.client_id) WHERE (i.arrived_at IS NOT NULL) AND (("i"."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') AND (i.left_at IS NOT NULL) AND (i.left_at > i.arrived_at) AND (c.last_engineer IS NOT NULL) )) "ct" LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = ct.project_id 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 WHERE "c"."sales_rep"='1001' GROUP BY "c"."id") "c" ORDER BY "c"."updated_at" DESC LIMIT 40 |
| 09:33:56.768 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 09:33:56.771 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 09:33:56.771 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 09:33:56.772 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-analysis/list-client-cost', '{"sales_rep":["1001"],"created_at_period":"currentfascalyear","page":"1","pageSize":"40","listReload":"true","web_access_token":"ukNwOz-BjUcQL9I3n8iWo2JcLwCMuHVk"}', '{"code":2000,"result":{"list":[{"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-06-28 21:40:56","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":"1670.205","erp_sales_amount":"12703073","erp_other_income_amount":"0","erp_use_amount":"101","erp_profit_amount":"12701402.795","erp_j_profit_amount":"12701301.795","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"12701301.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":3315,"name":"\u822a\u5929\u79d1\u5de5206\u6240(\u91cd\u590d)","abbr":"","pinyin_shortcut":"htkg206scf","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":20,"client_type":6,"sales_rep":1001,"main_contact":"","created_by":1005,"created_at":"2024-10-27 21:53:27","updated_at":"2026-06-24 14:11:27","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":0,"visit_count":1,"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":3465,"name":"\u96f6\u552e001","abbr":"","pinyin_shortcut":"ls001","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":43,"client_industry":8,"client_type":3,"sales_rep":1001,"main_contact":"","created_by":1001,"created_at":"2026-06-09 17:08:39","updated_at":"2026-06-09 17:10:11","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-06-09 17:08: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":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":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":3364,"name":"\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","abbr":"","pinyin_shortcut":"bjjtsjxxjsyxgsgd","description":"","corp_rep":"\u738b\u4e95\u83b2","website":"","capital":"500","established_at":"2019-04-11","headcount":"","reg_address":"","working_address":"","telephone":"010-82723450","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-05-14 16:30:29","updated_at":"2026-06-05 17:59:52","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0\uff1a\u5317\u4eac\u6781\u901a\u4e16\u7eaa\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\n\u6ce8\u518c\u5730\u5740\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u5317\u4e09\u73af\u4e2d\u8def44\u53f757\u5e621\u5c42119\n\u7535\u8bdd\uff1a13269110935\n\u7a0e\u53f7\uff1a91110108MA004NJB20\n\u5f00\u6237\u884c\uff1a\u5174\u4e1a\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u4e0a\u5730\u652f\u884c\n\u8d26\u53f7\uff1a321090100100334313","logo":"","en_name":"","pick_at":"2025-05-14 16:30: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":5,"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":5957,"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":3462,"name":"\u5927\u59d1\u8bf4\u7684\u98ce\u683c","abbr":"","pinyin_shortcut":"dgsdfg","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":1,"client_class":1,"client_industry":1,"client_type":1,"sales_rep":1001,"main_contact":"","created_by":1001,"created_at":"2026-06-02 16:52:29","updated_at":"2026-06-05 17:35:57","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-06-02 16:52: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":0,"client_key_info_count":0,"contact_count":0,"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":"1","erp_profit_amount":"0","erp_j_profit_amount":"-1","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-1","collect_amount":"0","un_collect_amount":"3561000","project_count":"1","budget":"3561000","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-06-05 11:14:23","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":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":"800","project_count":"1","budget":"800","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-06-05 11:12:59","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":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":"900","project_count":"1","budget":"900","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-06-05 11:12:51","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":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":"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":"420000","project_count":"1","budget":"630000","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"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-05 10:06:41","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":0,"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":"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":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-06-03 22:57:02","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":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-06-02 23:12:40","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":"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":"20700","project_count":"3","budget":"20700","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":3463,"name":"3","abbr":"","pinyin_shortcut":"3","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":1,"client_class":1,"client_industry":57,"client_type":1,"sales_rep":1001,"main_contact":"","created_by":1001,"created_at":"2026-06-02 16:54:10","updated_at":"2026-06-02 16:54:10","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-06-02 16:54:10","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":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":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":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":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":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":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":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"}},{"id":3458,"name":"\u800c\u7279\u7279\u70ed\u7279\u70ed","abbr":"","pinyin_shortcut":"ettrtr","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":1,"client_industry":57,"client_type":1,"sales_rep":1001,"main_contact":"","created_by":1001,"created_at":"2026-04-08 15:42:23","updated_at":"2026-04-08 15:42:51","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-04-08 15:42:23","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":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":3457,"name":"\u65b0\u5bb6\u9500\u552e\u7ebf\u7d22\u6d4b\u8bd5-\u5206\u914d","abbr":"","pinyin_shortcut":"xjxsxscsfp","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":1,"client_class":1,"client_industry":57,"client_type":1,"sales_rep":1001,"main_contact":"","created_by":1001,"created_at":"2026-04-01 11:21:52","updated_at":"2026-04-01 11:30:25","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-04-01 11:21: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":0,"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":"","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":"557","un_collect_amount":"32776","project_count":"1","budget":"33333","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":2115,"name":"\u5409\u6797\u7701\u519c\u6751\u4fe1\u7528\u793e\u8054\u5408\u793e","abbr":"","pinyin_shortcut":"jlsncxyslhs","description":"","corp_rep":"\u9ad8\u58ee","website":"https:\/\/www.jlnls.com\/#\/foot","capital":"1200","established_at":"0200-11-29","headcount":"","reg_address":"","working_address":2635,"telephone":" 0431-89668009","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":1,"client_class":43,"client_industry":10,"client_type":6,"sales_rep":1001,"main_contact":"","created_by":1001,"created_at":"2021-11-10 15:07:47","updated_at":"2026-04-01 10:30:23","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2023-10-07 10:34:58","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":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":"-1","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":2219,"name":"\u5317\u4eac\u534e\u9896\u5229\u8fbe\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","abbr":"","pinyin_shortcut":"bjhyldkjyxgsgd","description":"","corp_rep":"\u9648\u8425\u6770","website":"http:\/\/www.lidanet.cn\/#\/","capital":"1020","established_at":"2006-06-19","headcount":"","reg_address":"","working_address":2761,"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":"2022-08-10 13:37:39","updated_at":"2026-03-10 16:57:32","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2022-08-10 13:37: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":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":3451,"name":"\u5c71\u897f\u534e\u521b\u667a\u884c\u6570\u5b57\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"sxhczxszkjyxgs","description":"","corp_rep":"\u8d3e\u6768\u8499","website":"","capital":"660","established_at":"2005-02-06","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-02-28 17:48:36","updated_at":"2026-03-04 16:01:44","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u540d\u79f0\uff1a\u5c71\u897f\u534e\u521b\u667a\u884c\u6570\u5b57\u79d1\u6280\u6709\u9650\u516c\u53f8\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a91140100770135171U\n\u5730\u5740\u53ca\u7535\u8bdd\uff1a\u592a\u539f\u5e02\u5c0f\u5e97\u533a\u4f53\u80b2\u8def22\u53f73\u5e62-1-2\u5c421007\u53f7 15333606988\n\u5f00\u6237\u884c\u53ca\u8d26\u53f7\uff1a\u4ea4\u901a\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5c71\u897f\u7701\u5206\u884c\u8425\u4e1a\u90e8 141000601018170305706","logo":"","en_name":"","pick_at":"2026-02-28 17:48:36","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":"91140100770135171U","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":"29800","project_count":"1","budget":"29800","erp_j_profit_pct":"","erp_profit_pct":"","erp_cost_pct":"","salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"qdyjhlkjyxgs","description":"","corp_rep":"\u738b\u6587\u521a ","website":"","capital":"800","established_at":"2002-04-29","headcount":"","reg_address":"","working_address":3111,"telephone":"0532-87098922","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":"2023-07-10 17:27:02","updated_at":"2026-01-19 14:25:54","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u5355\u4f4d\u540d\u79f0\uff1a\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8 \n\u5f00\u6237\u884c\uff1a\u62db\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u9752\u5c9b\u5d02\u5c71\u652f\u884c\n\u8d26\u53f7\uff1a532904190310201\n\u7a0e\u53f7\uff1a91370200737271235G\n\u5730\u5740\uff1a\u9752\u5c9b\u5e02\u5d02\u5c71\u533a\u540c\u5b89\u8def882-1\u53f7\u9e3f\u6cf0\u5927\u53a6A\u5ea7603\u5ba4\n\u7535\u8bdd\uff1a0532-87098922","logo":"","en_name":"","pick_at":"2023-07-10 17:27:02","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":6,"client_key_info_count":0,"contact_count":4,"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":"380","erp_sales_amount":"1400","erp_other_income_amount":"0","erp_use_amount":"1888.00","erp_profit_amount":"1020","erp_j_profit_amount":"-868.00","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-868","collect_amount":"0","un_collect_amount":"1400","project_count":"1","budget":"1400","erp_j_profit_pct":-62,"erp_profit_pct":72.86,"erp_cost_pct":134.86,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},{"id":3301,"name":"\u91d1\u878d\u65f6\u62a5\u793e","abbr":"","pinyin_shortcut":"jrsbs","description":"","corp_rep":"\u90a2\u65e9\u5fe0","website":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u4e2d\u5173\u6751\u5357\u5927\u8857\u753218\u53f7D\u5ea722\u5c42","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"010-82198082","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":1001,"created_at":"2024-09-06 17:10:37","updated_at":"2026-01-16 09:34:31","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u589e\u503c\u7a0e\u4e13\u7528\u53d1\u7968\n\u5f00\u6237\u94f6\u884c:\u4e2d\u56fd\u5de5\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u592a\u5e73\u6865\u652f\u884c\n\u94f6\u884c\u8d26\u6237:0200020309014412832\n\u6ce8\u518c\u5730\u5740:\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u4e2d\u5173\u6751\u5357\u5927\u8857\u753218\u53f7D\u5ea718-22\u5c42","logo":"","en_name":"","pick_at":"2024-09-06 17:10:37","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":2,"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":"37500","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":2207,"name":"\u5317\u4eac\u4e2d\u79d1\u5764\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"bjzkkykjyxgs","description":"","corp_rep":"","website":"http:\/\/www.zkkykj.cn\/#\/","capital":"1500","established_at":"2017-05-05","headcount":"","reg_address":"","working_address":2750,"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":"2022-07-15 10:10:30","updated_at":"2026-01-15 15:07:22","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2022-07-15 10:10:30","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":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":2511,"name":"\u5927\u8fde\u65e5\u4fe1\u8d44\u8baf\u7cfb\u7edf\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"dlrxzxxtyxgs","description":"","corp_rep":"\u738b\u6668\u667a","website":"http:\/\/www.nissin.com.cn","capital":"1000","established_at":"2003-12-19","headcount":"","reg_address":"","working_address":3049,"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":"2023-02-17 14:29:15","updated_at":"2026-01-15 14:56:11","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2023-02-17 14:29:15","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":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":3334,"name":"\u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","abbr":"","pinyin_shortcut":"bjrygdkjyxgsgd","description":"","corp_rep":"\u67f3\u98de","website":"www.rongyee-oe.com","capital":"5000","established_at":"2009-03-27","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":"2025-02-28 16:18:15","updated_at":"2026-01-14 10:55:30","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0\uff1a \u5317\u4eac\u878d\u9890\u5149\u7535\u79d1\u6280\u6709\u9650\u516c\u53f8 \n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a911101116876451701\n\u5730\u5740: \u5317\u4eac\u5e02\u987a\u4e49\u533a\u6f9c\u897f\u56ed\u56db\u533a26\u53f7\u697c2\u5c42238\u5ba4\uff08\u79d1\u6280\u521b\u65b0\u529f\u80fd\u533a\uff09\n\u7535\u8bdd\u53f7\u7801\uff1a13126522178","logo":"","en_name":"","pick_at":"2025-02-28 16:18:15","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":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":5980,"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":2117,"name":"\u6c5f\u82cf\u9ed1\u9a6c\u9ad8\u79d1\u80a1\u4efd\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"jshmgkgfyxgs","description":"","corp_rep":"\u6731\u56fd\u5cf0","website":"http:\/\/www.chinaueg.com","capital":"8480","established_at":"0199-10-29","headcount":"","reg_address":"","working_address":2641,"telephone":"025-83231369","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":1,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":1011,"created_at":"2021-11-22 11:11:50","updated_at":"2026-01-14 10:45:33","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u5355\u4f4d\u540d\u79f0\uff1a\u6c5f\u82cf\u9ed1\u9a6c\u9ad8\u79d1\u80a1\u4efd\u6709\u9650\u516c\u53f8\n\u7a0e\u53f7\uff1a91320000714091485M\n\u5f00\u6237\u884c\uff1a\u5357\u4eac\u5e02\u4e2d\u884c\u9f13\u697c\u652f\u884c\n\u8d26\u53f7\uff1a5352 5821 6490\n\u5730\u5740\u53ca\u7535\u8bdd\uff1a\u5357\u4eac\u5e02\u9ad8\u65b0\u533a\u4e3d\u666f\u8def2\u53f7\u7814\u53d1\u5927\u53a6A\u5ea715\u5c42025-83231369","logo":"","en_name":"","pick_at":"2021-11-22 11:11: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":0,"contact_count":1,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":true,"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":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"zzzcglszyxgs","description":"","corp_rep":"\u4e8e\u6d0b","website":"","capital":"10000","established_at":"2014-11-05","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":10,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":1011,"created_at":"2023-06-14 09:45:51","updated_at":"2026-01-14 10:24:28","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0: \u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8 \u7edf\u4e00\u793e\u4f1a\u4fe1\u7528\u4ee3\u7801: 91440300319560181N\n\u5730\u5740\u7535\u8bdd: \u6df1\u5733\u5e02\u524d\u6d77\u6df1\u6e2f\u5408\u4f5c\u533a\u524d\u6e7e\u4e00\u8def 1 \u53f7 A \u680b 201 \u5ba4(\u5165\u9a7b\u6df1\u5733\u5e02\u524d\u6d77\u5546\u52a1\u79d8\u4e66\u6709\u9650\u516c\u53f8) 17727932602\n\u5f00\u6237\u94f6\u884c\u53ca\u5e10\u53f7: \u62db\u5546\u94f6\u884c\u80a1\u4efd\u6709\u9650\u516c\u53f8\u6df1\u5733\u524d\u6d77\u5206\u884c 755923588110111","logo":"","en_name":"","pick_at":"2023-06-14 09:45:51","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":5,"client_key_info_count":0,"contact_count":1,"visit_count":0,"cooperate_count":4,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","erp_cost_amount":"0","erp_sales_amount":"0","erp_other_income_amount":"0","erp_use_amount":"1200","erp_profit_amount":"0","erp_j_profit_amount":"-1200","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-1200","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":2845,"name":"\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08PA\u8fc7\u5355\uff09","abbr":"","pinyin_shortcut":"bjhttlxxjsyxgsPAgd","description":"","corp_rep":"\u5f20\u6587\u9b41","website":"","capital":"2508","established_at":"2006-12-14","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-04-26 09:27:41","updated_at":"2026-01-14 10:14:16","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0\uff1a\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\n\u7a0e \u53f7\uff1a911101087967203014\n\u516c\u53f8\u5730\u5740\uff1a\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u5317\u6e05\u8def68\u53f7\u966221\u697c2\u5c4218\u5ba4\n\u7535 \u8bdd\uff1a010-82783839\n\u5f00 \u6237 \u884c\uff1a\u5e7f\u53d1\u94f6\u884c\u5317\u4eac\u4e0a\u5730\u652f\u884c\n\u5e10 \u53f7\uff1a137281516010000396","logo":"","en_name":"","pick_at":"2024-04-26 09:27: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":1,"visit_count":0,"cooperate_count":2,"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":3426,"name":"\u6df1\u5733\u5e02\u4fe1\u548c\u9886\u521b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","abbr":"","pinyin_shortcut":"szsxhlcxxjsyxgs","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":4,"client_class":43,"client_industry":13,"client_type":5,"sales_rep":1001,"main_contact":"","created_by":1011,"created_at":"2025-11-24 16:15:24","updated_at":"2026-01-07 11:23:38","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2025-11-24 16:15:24","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":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":"2693.79","erp_profit_amount":"0","erp_j_profit_amount":"-2693.79","erp_labor_cost_amount":"0","erp_j_profit_deduct_labor_amount":"-2693.79","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":3427,"name":"\u4e2d\u592e\u5ba3\u4f20\u90e8\u7535\u5f71\u6570\u5b57\u8282\u76ee\u7ba1\u7406\u4e2d\u5fc3","abbr":"","pinyin_shortcut":"zyxcbdyszjmglzx","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"010-86091218","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"","company_nature":3,"client_class":43,"client_industry":1,"client_type":6,"sales_rep":1001,"main_contact":"","created_by":1011,"created_at":"2025-11-26 16:05:45","updated_at":"2026-01-07 11:19:33","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u540d\u79f0\uff1a\u4e2d\u592e\u5ba3\u4f20\u90e8\u7535\u5f71\u6570\u5b57\u8282\u76ee\u7ba1\u7406\u4e2d\u5fc3\n\u7eb3\u7a0e\u4eba\u8bc6\u522b\u53f7\uff1a12100000717806474N\n\u5730\u5740\uff1a\u5317\u4eac\u5e02\u897f\u57ce\u533a\u590d\u5174\u95e8\u5916\u5927\u8857 2 \u53f7\n\u7535\u8bdd\uff1a010-86091218\n\u5f00\u6237\u884c\uff1a\u5de5\u5546\u94f6\u884c\u5317\u4eac\u957f\u5b89\u652f\u884c\n\u8d26\u53f7\uff1a0200003309200157967","logo":"","en_name":"","pick_at":"2025-11-26 16:05: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":2,"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":5912,"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":3327,"name":"\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","abbr":"","pinyin_shortcut":"xlzbqdgcjsyxgsgd","description":"","corp_rep":"\u738b\u8c26\u68ee","website":"","capital":"500","established_at":"2014-12-30","headcount":"","reg_address":"","working_address":"","telephone":"0532-68069137","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-12-17 16:37:43","updated_at":"2026-01-07 10:52:18","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"\u516c\u53f8\u540d\u79f0\uff1a\u4fe1\u8054\u6cfd\u90a6\uff08\u9752\u5c9b\uff09\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8\n\u5f00\u6237\u884c\uff1a\u4e2d\u4fe1\u94f6\u884c\u9752\u5c9b\u52b2\u677e\u8def\u652f\u884c \n\u884c\u53f7\uff1a3024 5203 6174\n\u8d26\u53f7\uff1a7361 4101 8260 0067 385\n\u6ce8\u518c\u5730\u5740\uff1a\u9752\u5c9b\u5e02\u5d02\u5c71\u533a\u682a\u6d32\u8def69\u53f7\u9ad8\u65b0\u56ed\u4e09\u671f7\u53f7 \n\u7a0e\u52a1\u767b\u8bb0\u8bc1\u53f7\uff1a91370212325941917P\n\u7535\u8bdd\uff1a0532-68069137","logo":"","en_name":"","pick_at":"2024-12-17 16:37:43","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":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"}}],"pagenation":{"totalcount":70,"thispage":1,"pagesize":40}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"39.156.194.178","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-08 09:33:56', 84318720) RETURNING "id" |
| 09:33:56.779 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 09:33:56.780 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |