689aef17e0e5d: POST https://beta.jinchangxiao.com/vue/project/list-all-status at 2025-08-12 03:36:55 pm by 124.64.23.198
Log Messages
总计83条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 15:36:55.920 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 15:36:55.920 | trace | yii\base\Module::getModule | Loading module: debug |
| 15:36:55.921 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 15:36:55.921 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 15:36:55.921 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 15:36:55.922 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:36:55.922 | trace | yii\base\Module::getModule | Loading module: gii |
| 15:36:55.922 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 15:36:55.922 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 15:36:55.922 | trace | yii\web\Application::handleRequest | Route requested: 'vue/project/list-all-status' |
| 15:36:55.922 | trace | yii\base\Module::getModule | Loading module: vue |
| 15:36:55.923 | info | yii\web\Session::open | Session started |
| 15:36:55.923 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=5016 |
| 15:36:55.923 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 15:36:55.928 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:36:55.929 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:36:55.929 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:36:55.929 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:36:55.929 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016 |
| 15:36:55.931 | trace | yii\base\Controller::runAction | Route to run: vue/project/list-all-status |
| 15:36:55.931 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:36:55.932 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 15:36:55.932 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\ProjectController::actionListAllStatus() |
| 15:36:55.935 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:36:55.935 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:36:55.936 | trace | yii\base\Model::onUnsafeAttribute | Failed to set unsafe attribute 'from_contact_name' in 'app\models\search\ProjectSearch'. |
| 15:36:55.942 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:36:55.942 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:36:55.944 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND (p.budget > COALESCE(p.collected_plan, 0)) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 15:36:55.988 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND (p.budget > COALESCE(p.collected_plan, 0)) AND ("p"."project_status"=3) AND ("p"."project_status"=1) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 15:36:55.992 | info | yii\db\Command::query | SELECT SUM(budget) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND (p.budget > COALESCE(p.collected_plan, 0)) AND ("p"."project_status"=3) AND ("p"."project_status"=1) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 15:36:55.996 | info | yii\db\Command::query | SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND (p.budget > COALESCE(p.collected_plan, 0)) AND ("p"."project_status"=3) AND ("p"."project_status"=1) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20 |
| 15:36:56.002 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND (p.budget > COALESCE(p.collected_plan, 0)) AND ("p"."project_status"=3) AND ("p"."project_status"=2) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 15:36:56.006 | info | yii\db\Command::query | SELECT SUM(budget) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND (p.budget > COALESCE(p.collected_plan, 0)) AND ("p"."project_status"=3) AND ("p"."project_status"=2) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 15:36:56.010 | info | yii\db\Command::query | SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND (p.budget > COALESCE(p.collected_plan, 0)) AND ("p"."project_status"=3) AND ("p"."project_status"=2) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20 |
| 15:36:56.015 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND (p.budget > COALESCE(p.collected_plan, 0)) AND ("p"."project_status"=3) AND (p.budget > p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 15:36:56.030 | info | yii\db\Command::query | SELECT SUM(budget) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND (p.budget > COALESCE(p.collected_plan, 0)) AND ("p"."project_status"=3) AND (p.budget > p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 15:36:56.044 | info | yii\db\Command::query | SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND (p.budget > COALESCE(p.collected_plan, 0)) AND ("p"."project_status"=3) AND (p.budget > p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20 |
| 15:36:56.061 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (15, 518) |
| 15:36:56.061 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (15, 518) |
| 15:36:56.062 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 1004) |
| 15:36:56.062 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5295, 1004)) |
| 15:36:56.063 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3256, 3935) |
| 15:36:56.064 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (1, 164, 179, 142, 184, 200, 356, 374, 2, 189, 349)) ORDER BY "sort" |
| 15:36:56.065 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3 |
| 15:36:56.065 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (4, 6) |
| 15:36:56.066 | info | yii\db\Command::query | SELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (3256, 3935) |
| 15:36:56.066 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 1005) |
| 15:36:56.066 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 1005)) |
| 15:36:56.067 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND (p.budget > COALESCE(p.collected_plan, 0)) AND ("p"."project_status"=3) AND ("p"."project_status"=4) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 15:36:56.071 | info | yii\db\Command::query | SELECT SUM(budget) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND (p.budget > COALESCE(p.collected_plan, 0)) AND ("p"."project_status"=3) AND ("p"."project_status"=4) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 15:36:56.075 | info | yii\db\Command::query | SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND (p.budget > COALESCE(p.collected_plan, 0)) AND ("p"."project_status"=3) AND ("p"."project_status"=4) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20 |
| 15:36:56.080 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND (p.budget > COALESCE(p.collected_plan, 0)) AND ("p"."project_status"=3) AND ("p"."project_status"=5) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 15:36:56.084 | info | yii\db\Command::query | SELECT SUM(budget) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND (p.budget > COALESCE(p.collected_plan, 0)) AND ("p"."project_status"=3) AND ("p"."project_status"=5) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 15:36:56.087 | info | yii\db\Command::query | SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND (p.budget > COALESCE(p.collected_plan, 0)) AND ("p"."project_status"=3) AND ("p"."project_status"=5) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20 |
| 15:36:56.093 | info | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND (p.budget > COALESCE(p.collected_plan, 0)) AND ("p"."project_status"=3) AND (p.budget <= p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 15:36:56.116 | info | yii\db\Command::query | SELECT SUM(budget) FROM (SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND (p.budget > COALESCE(p.collected_plan, 0)) AND ("p"."project_status"=3) AND (p.budget <= p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC) "c" |
| 15:36:56.133 | info | yii\db\Command::query | SELECT p.*, (p.budget / 100 * p.profit_pct) as profits, now() - status_updated_at as remain, now() - progress_updated_at as progress_remain, now() - forecast_updated_at as forecast_remain, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, max(sl.end_at) as last_contact, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(arrive.end_at) as last_arrive, case when p.end_at IS NOT NULL THEN p.end_at - p.created_at ELSE now() - p.created_at END as duration, (SELECT sum(amount) FROM a57be577deb434.tbl_invoices i WHERE i.project_id = p.id) as issued_invoices FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN "a57be577deb434"."tbl_project_remind_receivers" "prr" ON prr.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_clients" "usedclient" ON p.used_client = usedclient.id LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.project_id = p.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "a57be577deb434"."tbl_work_logs" "sl" ON sl.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = p.id AND ttr.term_id = 10 LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr2" ON ttr2.object_id = p.id AND ttr2.term_id = 13 LEFT JOIN "a57be577deb434"."tbl_project_architects" "pa" ON "pa"."project_id" = "p"."id" LEFT JOIN "a57be577deb434"."tbl_engineer_group_relationships" "egr" ON egr.engineer_id = pa.engineer_id WHERE ("c"."deleted"=FALSE) AND (c.id is not null) AND ((c.sales_rep IS NULL) OR ("c"."sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("prr"."user_id"=5016) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5016))) AND (p.budget > COALESCE(p.collected_plan, 0)) AND ("p"."project_status"=3) AND (p.budget <= p.collected) AND ("p"."project_status"=3) GROUP BY "p"."id" ORDER BY "p"."bargain_date" DESC, "p"."created_at" DESC LIMIT 20 |
| 15:36:56.158 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "logo", "client_type", "client_class", "client_industry", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2545, 2805, 2819, 2150, 2532, 20, 2744, 2130, 2170, 2592, 2492, 2574, 14, 2511, 2136, 2207, 48) |
| 15:36:56.159 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (149, 1192) |
| 15:36:56.160 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2545, 2805, 2819, 2150, 2532, 20, 2744, 2130, 2170, 2592, 2492, 2574, 14, 2511, 2136, 2207, 48) |
| 15:36:56.161 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5295, 1004, 5087, 1001, 5311) |
| 15:36:56.161 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5295, 5311, 1005, 5087, 1004)) |
| 15:36:56.161 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3599, 3477, 3483, 3458, 3433, 3423, 3402, 3381, 3250, 3379, 3315, 3357, 3320, 3165, 3300, 3239, 3276, 3252, 3231, 3141) |
| 15:36:56.163 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "description" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (229, 135, 5, 1, 140, 2, 226, 215, 164, 179, 165, 181, 167, 183, 194, 196, 204, 205, 184, 189, 198, 202, 197, 199, 185, 191, 307, 203, 168, 128, 132, 340, 130, 129, 133, 172, 324, 349, 352, 354, 356, 359, 369, 377, 374, 348, 332, 323)) ORDER BY "sort" |
| 15:36:56.164 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3 |
| 15:36:56.164 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_progress" AS "name", "description" FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (6, 9, 10, 49, 7) |
| 15:36:56.164 | info | yii\db\Command::query | SELECT "id", "user_id", "user_id" AS "key", "project_id" FROM "a57be577deb434"."tbl_project_remind_receivers" WHERE "project_id" IN (3599, 3477, 3483, 3458, 3433, 3423, 3402, 3381, 3250, 3379, 3315, 3357, 3320, 3165, 3300, 3239, 3276, 3252, 3231, 3141) |
| 15:36:56.165 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 15:36:56.165 | info | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
| 15:36:56.166 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:36:56.167 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:36:56.167 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=5016) AND ("object_type"=1) AND ("visit_date"='2025-08-12') |
| 15:36:56.170 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:36:56.170 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:36:56.170 | info | yii\db\Command::query | SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_visit_module_histories' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 15:36:56.175 | info | yii\db\Command::query | select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_visit_module_histories' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 15:36:56.179 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 15:36:56.179 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |
| 15:36:56.179 | info | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=64, "last_visit_at"='now()' WHERE "id"=55248 |
| 15:36:56.181 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5016, 5, 'vue/project/list-all-status', '{"ProjectSearch":{"group":"","project_status":"","creator":"","purchaseType":"","engineer_group":"","period":"","budget":"","profit_pct":"","invoice_status":"","payment_status":"","collected_plan":"0","project_progress":"","salesForecast":"","projectProductTypes":"","contact_point_status":"","from_contact_name":"","from_contact":"","contract_type":"","is_sales_order_ready":"","created_period":""},"Filter":{"name":"bargain_date","sort":"DESC","Tsort":"","Tname":""},"page":"1","web_access_token":"4RM83q8EsNpDENhO_BQCdCa8jTBNRgKp"}', '{"code":2000,"result":{"list1count":0,"list1sum":"","list2count":0,"list2sum":"","list3count":2,"list3sum":"71336","list4count":0,"list4sum":"","list5count":0,"list5sum":"","list6count":749,"list6sum":"200102077.21","list1":[],"list2":[],"list3":[{"id":3256,"client_id":15,"project_status":3,"project_progress":4,"budget":"67886","profit_pct":"99.46","bargain_date":"2025-08-01","description":"\u4e09\u53f0\u8054\u60f3SR650\u670d\u52a1\u5668+\u4e00\u5957FAS2750\u5b58\u50a8\uff0c\u505a\u6210\u865a\u62df\u5316\u73af\u5883\uff0c\u505a\u6d4b\u8bd5\u4f7f\u7528\u3002","created_by":1004,"created_at":"2023-07-16 18:28:54","updated_at":"2025-08-12 15:07:16","engineer_id":"","project_title":"\u865a\u62df\u5316\u6d4b\u8bd5\u96c6\u7fa4","collected":"0","status_updated_at":"2025-08-12 14:47:11.029547+08","success_rate":"","comment":"\u4e09\u53f0\u8054\u60f3SR650\u670d\u52a1\u5668+\u4e00\u5957FAS2750\u5b58\u50a8\uff0c\u505a\u6210\u865a\u62df\u5316\u73af\u5883\uff0c\u505a\u6d4b\u8bd5\u4f7f\u7528\u3002\r\n","contract_type":1,"progress_updated_at":"2024-05-12 19:16:55.612323+08","forecast_updated_at":"2025-08-12 15:06:45.800825+08","end_at":"","pinyin_shortcut":"xnhcsjq","creator":1004,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":968,"is_sales_order_ready":false,"collected_plan":"33943","change_status_to":"","is_verify":false,"profits":"67519.415600000000000000","remain":"00:49:45.016004","progress_remain":"456 days 20:20:00.433228","forecast_remain":"00:30:10.244726","lost_contact_days":"476.228426453137","last_contact":"2024-04-23 10:08:00","last_arrive_days":"","last_arrive":"","duration":"757 days 21:08:01.354703","issued_invoices":"","client":{"id":15,"key":15,"name":"\u4e2d\u51b6\u4eac\u8bda\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8(\u5317\u4eac\u4eac\u8bda\u745e\u8fbe\u7535\u6c14\u5de5\u7a0b\u6280\u672f\u6709\u9650\u516c\u53f8)(\u5317\u4eac\u4eac\u8bda\u8d5b\u745e\u56fe\u6587\u4fe1\u606f\u79d1\u6280\u6709\u9650\u516c\u53f8)","logo":"","client_type":6,"client_class":47,"client_industry":1,"sales_rep":1004},"usedClient":{},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":4,"key":4,"name":"\u786e\u8ba4\u65b9\u6848","description":"\u5b9a\u4e49\uff1a\u6839\u636e\u5ba2\u6237\u7684\u53cd\u9988\uff0c\u4e0d\u65ad\u4f18\u5316\u89e3\u51b3\u65b9\u6848\uff0c\u76f4\u5230\u5ba2\u6237\u53e3\u5934\u6216\u4e66\u9762\u8ba4\u53ef\u65b9\u6848\u3002 \n\u65b9\u6cd5\uff1a\u4f7f\u7528\u573a\u666f\uff0c\u95ee\u9898\uff0c\u9700\u6c42\uff0c\u4ea7\u54c1\u53ca\u529f\u80fd\u7684\u65b9\u6cd5\u8bb2\u89e3\u65b9\u6848\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","can_update":true,"can_delete":true},{"id":3935,"client_id":518,"project_status":3,"project_progress":6,"budget":"3450","profit_pct":"10","bargain_date":"2025-07-30","description":"","created_by":5295,"created_at":"2025-07-30 11:46:03","updated_at":"2025-08-12 14:37:52","engineer_id":"","project_title":"\u65b0\u8d2d\u9632\u706b\u5899SSL VPN\u6388\u6743","collected":"0","status_updated_at":"2025-07-30 21:47:27.040422+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2025-07-30 11:46:03.457029+08","forecast_updated_at":"2025-08-12 14:37:52.399237+08","end_at":"","pinyin_shortcut":"xgfhqSSLVPNsq","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":967,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"345.0000000000000000","remain":"12 days 17:49:29.005129","progress_remain":"13 days 03:50:52.588522","forecast_remain":"00:59:03.646314","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"13 days 03:50:52.588522","issued_invoices":"","client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8","logo":"","client_type":1,"client_class":80,"client_industry":57,"sales_rep":5295},"usedClient":{},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesForecast":{"id":142,"key":142,"name":"\u6211\u4e0e\u5ba2\u6237\u8054\u624b","description":"\u4e0e\u5ba2\u6237\u8054\u624b\u5411\u5382\u5546\u4e89\u53d6\u6700\u4f18\u60e0\u4ef7\u683c\u3002\u5229\u6da6\u540450%\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},"projectRemindReceivers":[{"id":1707,"user_id":1001,"key":1001,"project_id":3935,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},{"id":1708,"user_id":1005,"key":1005,"project_id":3935,"user":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}}],"is_only_cp":false,"project_status_display":"\u5546\u673a\u6210\u4ea4","is_collected":false,"bgcolor":"#53cd02","can_update":true,"can_delete":true}],"list4":[],"list5":[],"list6":[{"id":3599,"client_id":2545,"project_status":3,"project_progress":6,"budget":"38000","profit_pct":"13.45","bargain_date":"2024-07-16","description":"","created_by":1001,"created_at":"2024-07-16 17:00:45","updated_at":"2025-01-09 10:47:11","engineer_id":"","project_title":"\u8054\u60f3SR650\u4e8c\u624b\u670d\u52a1\u5668\u91c7\u8d2d\u9879\u76ee\u4e8c","collected":"38000","status_updated_at":"2024-07-18 11:02:34.435078+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-07-16 17:00:45.181291+08","forecast_updated_at":"2024-07-16 17:00:45.181291+08","end_at":"2024-07-18 15:27:07","pinyin_shortcut":"lxSR650esfwqcgxme","creator":1001,"used_client":"","from_contact":"","total_contact_point":"7000","paid_contact_point":"7000","project_product_version_id":489,"is_sales_order_ready":true,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"5111.000000000000000000","remain":"390 days 04:34:21.699282","progress_remain":"391 days 22:36:10.953069","forecast_remain":"391 days 22:36:10.953069","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"1 day 22:26:22.61864","issued_invoices":"38000.00","client":{"id":2545,"key":2545,"name":"\u8d44\u821f\u8d44\u4ea7\u7ba1\u7406(\u6df1\u5733)\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":10,"sales_rep":1001},"usedClient":{},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesForecast":{"id":172,"key":172,"name":"\u6211\u4e0e\u5382\u5546\u8054\u624b","description":"\u4e0e\u5382\u5546\u8054\u624b\u5171\u540c\u641e\u5b9a\u5ba2\u6237\uff0c\u5229\u6da6\u5404\u536050%"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":6,"key":6,"name":"\u63a8\u52a8\u6210\u4ea4","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u786e\u8ba4\u4e86\u65b9\u6848\uff0c\u4e86\u89e3\u4e86\u6210\u4ea4\u4ef7\u683c\u3002 \n\u65b9\u6cd5\uff1a\u901a\u8fc7\u5229\u76ca\u5206\u4eab\uff0c\u5b9e\u529b\u8bc1\u660e\uff0c\u9ad8\u5c42\u62dc\u8bbf\uff0c\u5382\u5546\u62dc\u8bbf\uff0c\u6848\u4f8b\u53c2\u89c2\uff0c\u7a81\u51fa\u6211\u65b9\u4f18\u52bf\uff0c\u6253\u51fb\u5bf9\u624b\u52a3\u52bf\u3002"},"projectRemindReceivers":[{"id":1131,"user_id":1001,"key":1001,"project_id":3599,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"is_only_cp":false,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"can_update":true,"can_delete":true},{"id":3477,"client_id":2805,"project_status":3,"project_progress":9,"budget":"93606","profit_pct":"11.05","bargain_date":"2024-04-01","description":"","created_by":5295,"created_at":"2024-03-21 22:14:51","updated_at":"2024-05-21 10:02:32","engineer_id":"","project_title":"\u901f\u77f3\u4ea7\u54c1\u65b0\u8d2d-C","collected":"93606","status_updated_at":"2024-03-22 17:20:39.334523+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-03-22 17:19:49.752761+08","forecast_updated_at":"2024-03-21 22:14:51.534905+08","end_at":"2024-04-15 13:32:25","pinyin_shortcut":"sscpxgC","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":316,"is_sales_order_ready":true,"collected_plan":"85714","change_status_to":"","is_verify":false,"profits":"10343.463000000000000000","remain":"507 days 22:16:16.799837","progress_remain":"507 days 22:17:06.381599","forecast_remain":"508 days 17:22:04.599455","lost_contact_days":"507.979816369907","last_contact":"2024-03-22 16:06:00","last_arrive_days":"","last_arrive":"","duration":"24 days 15:17:33.64124","issued_invoices":"93606.00","client":{"id":2805,"key":2805,"name":"\u5317\u4eac\u65e0\u95ee\u82af\u7a79\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u4e0a\u6d77\u65e0\u95ee\u82af\u7a79\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09(EDA)","logo":"","client_type":5,"client_class":43,"client_industry":57,"sales_rep":5295},"usedClient":{},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectRemindReceivers":[{"id":960,"user_id":1001,"key":1001,"project_id":3477,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"is_only_cp":false,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"can_update":true,"can_delete":true},{"id":3483,"client_id":2819,"project_status":3,"project_progress":10,"budget":"36900","profit_pct":"24.17","bargain_date":"2024-03-26","description":"","created_by":5364,"created_at":"2024-03-26 23:51:09","updated_at":"2024-11-14 11:50:28","engineer_id":"","project_title":"\u534e\u4e3a\u4ea4\u6362\u673a","collected":"36900","status_updated_at":"2024-04-08 17:11:04.134019+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-04-08 17:11:04.134019+08","forecast_updated_at":"2024-04-08 17:11:04.134019+08","end_at":"2024-04-29 10:14:13","pinyin_shortcut":"hwjhj","creator":5364,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":622,"is_sales_order_ready":true,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"8918.730000000000000000","remain":"490 days 22:25:52.000341","progress_remain":"490 days 22:25:52.000341","forecast_remain":"490 days 22:25:52.000341","lost_contact_days":"476.150649703241","last_contact":"2024-04-23 12:00:00","last_arrive_days":"","last_arrive":"","duration":"33 days 10:23:04.431641","issued_invoices":"36900.00","client":{"id":2819,"key":2819,"name":"\u5317\u4eac\u4e03\u7ef4\u65f6\u4ee3\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":"","client_industry":13,"sales_rep":""},"usedClient":{},"salesRep":"","salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"can_update":true,"can_delete":true},{"id":3458,"client_id":2150,"project_status":3,"project_progress":9,"budget":"34115","profit_pct":"-0.58","bargain_date":"2024-03-07","description":"","created_by":5295,"created_at":"2024-02-29 11:07:46","updated_at":"2024-08-22 18:23:02","engineer_id":"","project_title":"\uff08\u8fc7\u5355\uff09\u65b0\u8d2dPA440\u9632\u706b\u5899-C","collected":"34115","status_updated_at":"2024-02-29 11:07:46.080464+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-02-29 11:07:46.080464+08","forecast_updated_at":"2024-02-29 11:07:46.080464+08","end_at":"2024-03-26 12:01:01","pinyin_shortcut":"gdxgPA440fhqC","creator":5295,"used_client":"","from_contact":"","total_contact_point":"8716","paid_contact_point":"8716","project_product_version_id":293,"is_sales_order_ready":true,"collected_plan":"33042","change_status_to":"","is_verify":false,"profits":"-197.867000000000000000","remain":"530 days 04:29:10.053896","progress_remain":"530 days 04:29:10.053896","forecast_remain":"530 days 04:29:10.053896","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"26 days 00:53:15.626984","issued_invoices":"34115.00","client":{"id":2150,"key":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)","logo":"","client_type":3,"client_class":43,"client_industry":57,"sales_rep":5295},"usedClient":{},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectRemindReceivers":[{"id":937,"user_id":1001,"key":1001,"project_id":3458,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"is_only_cp":false,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"can_update":true,"can_delete":true},{"id":3433,"client_id":2532,"project_status":3,"project_progress":49,"budget":"1371800","profit_pct":"12.36","bargain_date":"2024-01-23","description":"","created_by":5087,"created_at":"2024-01-22 18:01:06","updated_at":"2024-10-17 16:29:46","engineer_id":"","project_title":"\u4f53\u7cfb\u6548\u80fd\u7cbe\u51c6\u9884\u793a\u4e0e\u7efc\u5408\u5206\u6790\u7cfb\u7edf-K1","collected":"1371800","status_updated_at":"2024-01-29 17:49:59.347723+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2024-01-29 17:49:59.347723+08","forecast_updated_at":"2024-01-29 17:49:59.347723+08","end_at":"2024-04-16 15:42:11","pinyin_shortcut":"txxnjzysyzhfxxtK1","creator":1001,"used_client":"","from_contact":"","total_contact_point":"40000","paid_contact_point":"40000","project_product_version_id":322,"is_sales_order_ready":true,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"169554.48000000000000","remain":"560 days 21:46:56.786637","progress_remain":"560 days 21:46:56.786637","forecast_remain":"560 days 21:46:56.786637","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"84 days 21:41:05.556823","issued_invoices":"1371800.00","client":{"id":2532,"key":2532,"name":"\u5317\u4eac\u65b9\u5dde\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":"","client_type":6,"client_class":43,"client_industry":5,"sales_rep":5087},"usedClient":{},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":49,"key":49,"name":"\u6536\u6b3e\u4e2d","description":"\u5b9a\u4e49\uff1a\u5f00\u53d1\u7968\uff0c\u5b8c\u6210\u6536\u6b3e \u3002\n\u65b9\u6cd5\uff1a\u5411\u8d22\u52a1\u7533\u8bf7\u5f00\u53d1\u7968\u3002"},"projectRemindReceivers":[{"id":969,"user_id":1001,"key":1001,"project_id":3433,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"is_only_cp":false,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"can_update":true,"can_delete":true},{"id":3423,"client_id":20,"project_status":3,"project_progress":7,"budget":"117000","profit_pct":"27.38","bargain_date":"2024-01-22","description":"","created_by":1005,"created_at":"2024-01-15 11:55:34","updated_at":"2025-01-17 13:50:21","engineer_id":"","project_title":"MSS2024\u5e74\u670d\u52a1\u7eed\u7b7e","collected":"117000","status_updated_at":"2024-01-25 13:42:49.940293+08","success_rate":"","comment":"","contract_type":2,"progress_updated_at":"2024-01-15 11:55:34.641398+08","forecast_updated_at":"2024-01-15 11:55:34.641398+08","end_at":"2024-03-12 16:42:05","pinyin_shortcut":"MSS2024nfwxq","creator":1005,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":223,"is_sales_order_ready":true,"collected_plan":"116000","change_status_to":"","is_verify":false,"profits":"32034.600000000000000000","remain":"565 days 01:54:06.194067","progress_remain":"575 days 03:41:21.492962","forecast_remain":"575 days 03:41:21.492962","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"57 days 04:46:30.432475","issued_invoices":"117000.00","client":{"id":20,"key":20,"name":"\u4e2d\u56fd\u91cd\u578b\u673a\u68b0\u6709\u9650\u516c\u53f8\u3001\u56fd\u673a\u91cd\u578b\u88c5\u5907(\u67ec\u57d4\u5be8\u8fbe\u5cb1\u6c34\u7535\u6709\u9650\u516c\u53f8)","logo":"","client_type":6,"client_class":47,"client_industry":5,"sales_rep":1005},"usedClient":{},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":7,"key":7,"name":"\u8fbe\u6210\u610f\u5411","description":"\u4e89\u53d6\u5ba2\u6237\u5728\u53e3\u5934\u4e0a\u8868\u8fbe\u610f\u613f\u3002\u6316\u6398\u5ba2\u6237\u987e\u8651\u3002\u6253\u6d88\u5ba2\u6237\u987e\u8651\u3002\n"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"can_update":true,"can_delete":true},{"id":3402,"client_id":2744,"project_status":3,"project_progress":7,"budget":"204240","profit_pct":"0.13","bargain_date":"2023-12-26","description":"","created_by":1005,"created_at":"2023-12-21 12:21:25","updated_at":"2024-05-13 14:28:50","engineer_id":"","project_title":"\u4e00\u6240\u6df1\u4fe1\u670d\u7ec8\u7aef\u5b89\u5168\u76d1\u6d4b","collected":"204240","status_updated_at":"2023-12-21 12:21:25.606946+08","success_rate":"","comment":"\u738b\u660e\u4eae\u8fc7\u5355\u9879\u76ee\n\u75591.554\u4e07\u7684\u5229\u6da6\u3002\n20.424-7-1.554=11.87w\uff0c\u8fd9\u90e8\u5206\u8981\u901a\u8fc7\u670d\u52a1\u5916\u5305\u8fc1\u51fa\uff0c\u5bf9\u65b9\u7ed9\u4f60\u4eec\u5f006%\u7684\u7968\u3002\u8003\u8651\u52307\u4e2a\u70b9\u7684\u635f\u8017\uff0c\u5b9e\u9645\u8fc1\u51fa11.87*0.93=11.0391w\u3002\u6700\u540e\u5408\u540c\u5b9a\u4e8611\u4e07\n\u56de\u6b3e\u5468\u671f2\u5468\n\u5ba2\u6237\u7684\u8d39\u7528\u8981\u4ece\u91cc\u8fb9\u51fa","contract_type":1,"progress_updated_at":"2023-12-21 12:21:25.606946+08","forecast_updated_at":"2023-12-21 12:21:25.606946+08","end_at":"2024-04-09 11:28:51","pinyin_shortcut":"yssxfzdaqjc","creator":1005,"used_client":149,"from_contact":4844,"total_contact_point":"","paid_contact_point":"","project_product_version_id":156,"is_sales_order_ready":true,"collected_plan":"204220","change_status_to":"","is_verify":false,"profits":"265.512000000000000000","remain":"600 days 03:15:30.527414","progress_remain":"600 days 03:15:30.527414","forecast_remain":"600 days 03:15:30.527414","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"109 days 23:07:25.557843","issued_invoices":"204240.00","client":{"id":2744,"key":2744,"name":"\u5317\u4eac\u4f73\u534e\u4e09\u516d\u4e94\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":"","client_type":1,"client_class":43,"client_industry":1,"sales_rep":1005},"usedClient":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)\uff08\u71d5\u4eac\uff09"},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":7,"key":7,"name":"\u8fbe\u6210\u610f\u5411","description":"\u4e89\u53d6\u5ba2\u6237\u5728\u53e3\u5934\u4e0a\u8868\u8fbe\u610f\u613f\u3002\u6316\u6398\u5ba2\u6237\u987e\u8651\u3002\u6253\u6d88\u5ba2\u6237\u987e\u8651\u3002\n"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"can_update":true,"can_delete":true},{"id":3381,"client_id":2130,"project_status":3,"project_progress":49,"budget":"15620","profit_pct":"35.5","bargain_date":"2023-12-13","description":"","created_by":5087,"created_at":"2023-12-03 21:13:29","updated_at":"2024-01-30 15:51:37","engineer_id":"","project_title":"\u78c1\u7535\u9879\u76ee\u589e\u9879","collected":"15620","status_updated_at":"2023-12-03 21:15:57.312343+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2023-12-03 21:13:29.451288+08","forecast_updated_at":"2023-12-03 21:13:29.451288+08","end_at":"2024-01-25 15:22:07","pinyin_shortcut":"cdxmzx","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":64,"is_sales_order_ready":false,"collected_plan":"15000","change_status_to":"","is_verify":false,"profits":"5545.10000000000000000","remain":"617 days 18:20:58.822017","progress_remain":"617 days 18:23:26.683072","forecast_remain":"617 days 18:23:26.683072","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"52 days 18:08:38.142577","issued_invoices":"15620.00","client":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","logo":"","client_type":6,"client_class":47,"client_industry":5,"sales_rep":5087},"usedClient":{},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":49,"key":49,"name":"\u6536\u6b3e\u4e2d","description":"\u5b9a\u4e49\uff1a\u5f00\u53d1\u7968\uff0c\u5b8c\u6210\u6536\u6b3e \u3002\n\u65b9\u6cd5\uff1a\u5411\u8d22\u52a1\u7533\u8bf7\u5f00\u53d1\u7968\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"can_update":true,"can_delete":true},{"id":3250,"client_id":2130,"project_status":3,"project_progress":9,"budget":"101306","profit_pct":"17.12","bargain_date":"2023-12-13","description":"","created_by":1004,"created_at":"2023-07-10 15:26:20","updated_at":"2024-09-12 15:30:37","engineer_id":"","project_title":"\u5c71\u897f\u78c1\u7535\u5e03\u7ebf","collected":"101306","status_updated_at":"2023-08-30 17:00:36.174565+08","success_rate":"","comment":"","contract_type":1,"progress_updated_at":"2023-08-28 11:28:33.60975+08","forecast_updated_at":"2023-08-28 11:28:33.60975+08","end_at":"2024-04-08 17:17:54","pinyin_shortcut":"sxcdbx","creator":5087,"used_client":"","from_contact":"","total_contact_point":"10000","paid_contact_point":"10000","project_product_version_id":62,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"17343.587200000000000000","remain":"712 days 22:36:19.959795","progress_remain":"715 days 04:08:22.52461","forecast_remain":"715 days 04:08:22.52461","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"273 days 01:51:34.323047","issued_invoices":"101306.00","client":{"id":2130,"key":2130,"name":"\u5317\u4eac\u4eac\u822a\u8ba1\u7b97\u901a\u8baf\u7814\u7a76\u6240304","logo":"","client_type":6,"client_class":47,"client_industry":5,"sales_rep":5087},"usedClient":{},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"can_update":true,"can_delete":true},{"id":3379,"client_id":2170,"project_status":3,"project_progress":9,"budget":"10500","profit_pct":"8.62","bargain_date":"2023-12-04","description":"","created_by":5295,"created_at":"2023-11-30 22:55:28","updated_at":"2025-01-21 13:09:44","engineer_id":"","project_title":"\u65b0\u8d2d\u534e\u4e09\u4ea4\u6362\u673a-G","collected":"10500","status_updated_at":"2023-12-05 10:59:54.474409+08","success_rate":"","comment":"4\u53f0\u534e\u4e09\u4ea4\u6362\u673a","contract_type":1,"progress_updated_at":"2023-11-30 22:55:28.390233+08","forecast_updated_at":"2023-11-30 22:55:28.390233+08","end_at":"2023-12-05 14:20:09","pinyin_shortcut":"xghsjhjG","creator":5295,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":178,"is_sales_order_ready":true,"collected_plan":"10200","change_status_to":"","is_verify":false,"profits":"905.100000000000000000","remain":"616 days 04:37:01.659951","progress_remain":"620 days 16:41:27.744127","forecast_remain":"620 days 16:41:27.744127","lost_contact_days":"616.038844147685","last_contact":"2023-12-05 14:41:00","last_arrive_days":"616.038844147685","last_arrive":"2023-12-05 14:41:00+08","duration":"4 days 15:24:40.625778","issued_invoices":"10500.00","client":{"id":2170,"key":2170,"name":"\u5c71\u9b48\u6620\u753b\u89c6\u6548\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":18,"sales_rep":5311},"usedClient":{},"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","sex":"F","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectRemindReceivers":[{"id":827,"user_id":1001,"key":1001,"project_id":3379,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"is_only_cp":false,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"can_update":true,"can_delete":true},{"id":3315,"client_id":2592,"project_status":3,"project_progress":7,"budget":"180000","profit_pct":"-8.57","bargain_date":"2023-11-13","description":"","created_by":1005,"created_at":"2023-09-22 14:41:44","updated_at":"2024-02-28 15:50:36","engineer_id":"","project_title":"\u62a4\u7f51\u4eba\u5de5\u670d\u52a1-\uff08\u9752\u85e4\u8fc7\u5355\uff09","collected":"180000","status_updated_at":"2023-11-27 13:23:20.925572+08","success_rate":"","comment":"\u9752\u85e4\u5b89\u5168\u670d\u52a1\n\u8303\u946b\u660a\u8fc7\u5355\u9879\u76ee\n\u6210\u672c176625\n\u5408\u540c\u5df2\u7ecf\u6536\u5230","contract_type":2,"progress_updated_at":"2023-09-22 14:41:44.459876+08","forecast_updated_at":"2023-09-22 14:41:44.459876+08","end_at":"2024-01-11 09:43:33","pinyin_shortcut":"hwrgfwqtgd","creator":1005,"used_client":1192,"from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":249,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"-15426.000000000000000000","remain":"624 days 02:13:35.208788","progress_remain":"690 days 00:55:11.674484","forecast_remain":"690 days 00:55:11.674484","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"110 days 19:01:49.46118","issued_invoices":"180000.00","client":{"id":2592,"key":2592,"name":"\u542f\u660e\u661f\u8fb0\u4fe1\u606f\u6280\u672f\u96c6\u56e2\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":"","client_type":5,"client_class":43,"client_industry":20,"sales_rep":1005},"usedClient":{"id":1192,"key":1192,"name":"(\u592e\u4f01)\u4e2d\u56fd\u673a\u68b0\u5de5\u4e1a\u96c6\u56e2\u6709\u9650\u516c\u53f8"},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":7,"key":7,"name":"\u8fbe\u6210\u610f\u5411","description":"\u4e89\u53d6\u5ba2\u6237\u5728\u53e3\u5934\u4e0a\u8868\u8fbe\u610f\u613f\u3002\u6316\u6398\u5ba2\u6237\u987e\u8651\u3002\u6253\u6d88\u5ba2\u6237\u987e\u8651\u3002\n"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"can_update":true,"can_delete":true},{"id":3357,"client_id":2492,"project_status":3,"project_progress":49,"budget":"50800","profit_pct":"-5.81","bargain_date":"2023-11-09","description":"","created_by":5087,"created_at":"2023-11-10 13:16:33","updated_at":"2025-06-04 09:15:34","engineer_id":"","project_title":"\u667a\u80fd\u9662\u7167\u76f8\u5668\u6750\u91c7\u8d2d-K","collected":"50800","status_updated_at":"2023-11-10 13:18:07.937245+08","success_rate":"","comment":"\u515a\u7fa4\u4eba\u529b\u90e8 \u505a\u5ba3\u4f20\u5236\u4f5c\u4f7f\u7528\u3002","contract_type":1,"progress_updated_at":"2023-11-10 13:16:33.538727+08","forecast_updated_at":"2023-11-10 13:16:33.538727+08","end_at":"2024-12-12 09:52:19","pinyin_shortcut":"znyzxqccgK","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":215,"is_sales_order_ready":true,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"-2951.480000000000000000","remain":"641 days 02:18:48.197115","progress_remain":"641 days 02:20:22.595633","forecast_remain":"641 days 02:20:22.595633","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"397 days 20:35:45.8664","issued_invoices":"50800.00","client":{"id":2492,"key":2492,"name":"\u822a\u5929\u79d1\u5de5\u96c6\u56e2\u667a\u80fd\u79d1\u6280\u7814\u7a76\u9662\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":47,"client_industry":5,"sales_rep":5087},"usedClient":{},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":49,"key":49,"name":"\u6536\u6b3e\u4e2d","description":"\u5b9a\u4e49\uff1a\u5f00\u53d1\u7968\uff0c\u5b8c\u6210\u6536\u6b3e \u3002\n\u65b9\u6cd5\uff1a\u5411\u8d22\u52a1\u7533\u8bf7\u5f00\u53d1\u7968\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"can_update":true,"can_delete":true},{"id":3320,"client_id":2574,"project_status":3,"project_progress":7,"budget":"64000","profit_pct":"21.49","bargain_date":"2023-10-18","description":"","created_by":1005,"created_at":"2023-09-25 15:35:05","updated_at":"2024-01-31 14:09:35","engineer_id":"","project_title":"\u4e2d\u56fd\u534e\u7535\u96c6\u56e2\u6709\u9650\u516c\u53f8\u5317\u4eac\u6570\u5b57\u79d1\u6280\u5206\u516c\u53f8\u653f\u52a1\u4fe1\u606f\u7cfb\u7edf\u57fa\u7840\u8d44\u6e90\u53ca\u5b89\u5168\u670d\u52a1\u91c7\u8d2d\u9879\u76ee","collected":"64000","status_updated_at":"2023-10-22 17:25:50.871295+08","success_rate":"","comment":"\u5f20\u78ca\u9879\u76ee\uff0c9\u6708\u5e95\u4e0b\u5355\uff0c10\u6708\u548c\u5ba2\u6237\u7b7e\uff0c\u548c\u603b\u4ee3\u89812\u4e2a\u6708\u8d26\u671f","contract_type":1,"progress_updated_at":"2023-09-25 15:35:05.607487+08","forecast_updated_at":"2023-09-25 15:35:05.607487+08","end_at":"2023-12-04 17:33:25","pinyin_shortcut":"zghdjtyxgsbjszkjfgszwxxxtjczyjaqfwcgxm","creator":1005,"used_client":"","from_contact":4854,"total_contact_point":"12624","paid_contact_point":"12624","project_product_version_id":96,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"13753.600000000000000000","remain":"659 days 22:11:05.263065","progress_remain":"687 days 00:01:50.526873","forecast_remain":"687 days 00:01:50.526873","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"70 days 01:58:20.295755","issued_invoices":"64000.00","client":{"id":2574,"key":2574,"name":"\u4e2d\u56fd\u8f6f\u4ef6\u4e0e\u6280\u672f\u670d\u52a1\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","logo":"","client_type":6,"client_class":43,"client_industry":20,"sales_rep":1005},"usedClient":{},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":7,"key":7,"name":"\u8fbe\u6210\u610f\u5411","description":"\u4e89\u53d6\u5ba2\u6237\u5728\u53e3\u5934\u4e0a\u8868\u8fbe\u610f\u613f\u3002\u6316\u6398\u5ba2\u6237\u987e\u8651\u3002\u6253\u6d88\u5ba2\u6237\u987e\u8651\u3002\n"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"can_update":true,"can_delete":true},{"id":3165,"client_id":14,"project_status":3,"project_progress":9,"budget":"558000","profit_pct":"25.84","bargain_date":"2023-09-27","description":"\u8054\u60f3\u5de5\u4f5c\u7ad9 i7-11700K(3.6G\u516b\u6838\u5fc3)\uff0c32G \u5185\u5b58\uff0c512G\u56fa\u6001\u786c\u76d8+2T \u786c\u76d8\uff0cRX 6800 \u663e\u5361*19\u53f0\uff0c\u540c\u65b9\u98de\u817e\u5e73\u53f0-D2000\/8\u5904\u7406\u5668\uff0c32G\u5185\u5b58\uff0c512G\u56fa\u6001\u786c\u76d8\uff0c2T\u673a\u68b0\u786c\u76d8\uff0c\u94f6\u6cb3\u9e92\u9e9f\u684c\u9762V10\u7cfb\u7edf\uff0c\u666f\u5609\u5faeJM7201 1G\u663e\u5361*2\uff0c\u8054\u60f3\u663e\u793a\u5668*27\u53f0\uff0c\u5de5\u4f5c\u684c\u3001\u5de5\u4f5c\u6905\u3001\u8d27\u67b6\u82e5\u5e72\uff0c\u5e03\u7ebf\u7b49","created_by":1004,"created_at":"2023-03-27 16:47:42","updated_at":"2025-01-21 13:10:03","engineer_id":"","project_title":"\u591a\u529f\u80fd\u6559\u5ba4","collected":"558000","status_updated_at":"2023-09-04 10:22:29.761032+08","success_rate":"","comment":"\u8054\u60f3\u5de5\u4f5c\u7ad9 i7-11700K(3.6G\u516b\u6838\u5fc3)\uff0c32G \u5185\u5b58\uff0c512G\u56fa\u6001\u786c\u76d8+2T \u786c\u76d8\uff0cRX 6800 \u663e\u5361*19\u53f0\uff0c\u540c\u65b9\u98de\u817e\u5e73\u53f0-D2000\/8\u5904\u7406\u5668\uff0c32G\u5185\u5b58\uff0c512G\u56fa\u6001\u786c\u76d8\uff0c2T\u673a\u68b0\u786c\u76d8\uff0c\u94f6\u6cb3\u9e92\u9e9f\u684c\u9762V10\u7cfb\u7edf\uff0c\u666f\u5609\u5faeJM7201 1G\u663e\u5361*2\uff0c\u8054\u60f3\u663e\u793a\u5668*27\u53f0\uff0c\u5de5\u4f5c\u684c\u3001\u5de5\u4f5c\u6905\u3001\u8d27\u67b6\u82e5\u5e72\uff0c\u5e03\u7ebf\u7b49\r\n","contract_type":1,"progress_updated_at":"2023-09-04 10:22:29.761032+08","forecast_updated_at":"2023-09-04 10:22:29.761032+08","end_at":"2024-03-27 15:30:36","pinyin_shortcut":"dgnjs","creator":1004,"used_client":"","from_contact":"","total_contact_point":"46940","paid_contact_point":"46940","project_product_version_id":204,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"144187.200000000000000000","remain":"708 days 05:14:26.373328","progress_remain":"708 days 05:14:26.373328","forecast_remain":"708 days 05:14:26.373328","lost_contact_days":"818.082594147685","last_contact":"2023-05-17 13:38:00","last_arrive_days":"","last_arrive":"","duration":"365 days 22:42:53.111401","issued_invoices":"558000.00","client":{"id":14,"key":14,"name":"\u5317\u4eac\u5317\u65b9\u8f66\u8f86\u96c6\u56e2\u6709\u9650\u516c\u53f8","logo":"","client_type":6,"client_class":47,"client_industry":5,"sales_rep":1004},"usedClient":{},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"can_update":true,"can_delete":true},{"id":3300,"client_id":2511,"project_status":3,"project_progress":9,"budget":"3000","profit_pct":"60.33","bargain_date":"2023-08-28","description":"","created_by":1001,"created_at":"2023-08-28 15:59:43","updated_at":"2024-01-25 17:29:48","engineer_id":"","project_title":"\u4ea4\u6362\u673a\u8c03\u8bd5\u4e00\u6b21\u6027\u670d\u52a1","collected":"3000","status_updated_at":"2023-08-28 15:59:43.007222+08","success_rate":"","comment":"3\u6708\u4efd\u5df2\u5b8c\u6210\u9879\u76ee","contract_type":2,"progress_updated_at":"2023-08-28 15:59:43.007222+08","forecast_updated_at":"2023-08-28 15:59:43.007222+08","end_at":"2023-09-15 14:04:09","pinyin_shortcut":"jhjtsycxfw","creator":1001,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":25,"is_sales_order_ready":true,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"1809.900000000000000000","remain":"714 days 23:37:13.127138","progress_remain":"714 days 23:37:13.127138","forecast_remain":"714 days 23:37:13.127138","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"17 days 22:04:26.803656","issued_invoices":"3000.00","client":{"id":2511,"key":2511,"name":"\u5927\u8fde\u65e5\u4fe1\u8d44\u8baf\u7cfb\u7edf\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001},"usedClient":{},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectRemindReceivers":[{"id":690,"user_id":1001,"key":1001,"project_id":3300,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"is_only_cp":false,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"can_update":true,"can_delete":true},{"id":3239,"client_id":2136,"project_status":3,"project_progress":49,"budget":"24000","profit_pct":"29.52","bargain_date":"2023-08-22","description":"\u4e2d\u5b5a\u6d89\u5bc6\u8ba1\u7b97\u673a\u53ca\u79fb\u52a8\u5b58\u50a8\u4ecb\u8d28\u4fdd\u5bc6\u7ba1\u7406\u7cfb\u7edf\uff0c\u6269\u70b9\u3002","created_by":5087,"created_at":"2023-07-03 14:56:45","updated_at":"2024-01-25 17:49:42","engineer_id":"","project_title":"\u4e2d\u5b5a\u7aef\u70b9\u5b89\u5168\u6269\u5bb9-K","collected":"24000","status_updated_at":"2023-08-28 00:40:04.776314+08","success_rate":"","comment":"\u4e2d\u5b5a\u6d89\u5bc6\u8ba1\u7b97\u673a\u53ca\u79fb\u52a8\u5b58\u50a8\u4ecb\u8d28\u4fdd\u5bc6\u7ba1\u7406\u7cfb\u7edf\uff0c\u6269\u70b9\u3002\r\n","contract_type":1,"progress_updated_at":"2023-08-28 00:40:04.776314+08","forecast_updated_at":"2023-08-28 00:40:04.776314+08","end_at":"2023-11-20 14:44:08","pinyin_shortcut":"zfddaqkrK","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":72,"is_sales_order_ready":true,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"7084.800000000000000000","remain":"715 days 14:56:51.358046","progress_remain":"715 days 14:56:51.358046","forecast_remain":"715 days 14:56:51.358046","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"139 days 23:47:23.000428","issued_invoices":"24000.00","client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240","logo":"","client_type":6,"client_class":47,"client_industry":5,"sales_rep":5087},"usedClient":{},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":49,"key":49,"name":"\u6536\u6b3e\u4e2d","description":"\u5b9a\u4e49\uff1a\u5f00\u53d1\u7968\uff0c\u5b8c\u6210\u6536\u6b3e \u3002\n\u65b9\u6cd5\uff1a\u5411\u8d22\u52a1\u7533\u8bf7\u5f00\u53d1\u7968\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"can_update":true,"can_delete":true},{"id":3276,"client_id":2207,"project_status":3,"project_progress":9,"budget":"10000","profit_pct":"57.47","bargain_date":"2023-07-27","description":"12\u5757900G SSD \u5237\u56fa\u4ef6\uff0c\u6570\u636e\u6062\u590d\u3002","created_by":1001,"created_at":"2023-08-01 15:32:02","updated_at":"2024-01-29 14:47:37","engineer_id":"","project_title":"FAS8040 900G SSD\u786c\u76d8\u6570\u636e\u6062\u590d","collected":"10000","status_updated_at":"2023-08-01 15:32:02.328997+08","success_rate":"","comment":"12\u5757900G SSD \u5237\u56fa\u4ef6\uff0c\u6570\u636e\u6062\u590d\u3002\r\n","contract_type":2,"progress_updated_at":"2023-08-01 15:32:02.328997+08","forecast_updated_at":"2023-08-01 15:32:02.328997+08","end_at":"2023-08-02 17:31:47","pinyin_shortcut":"FAS8040900GSSDypsjhf","creator":1001,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":213,"is_sales_order_ready":true,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"5747.000000000000000000","remain":"742 days 00:04:53.805363","progress_remain":"742 days 00:04:53.805363","forecast_remain":"742 days 00:04:53.805363","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"1 day 01:59:44.945229","issued_invoices":"10000.00","client":{"id":2207,"key":2207,"name":"\u5317\u4eac\u4e2d\u79d1\u5764\u5143\u79d1\u6280\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":43,"client_industry":13,"sales_rep":1001},"usedClient":{},"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectRemindReceivers":[{"id":671,"user_id":1001,"key":1001,"project_id":3276,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"is_only_cp":false,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"can_update":true,"can_delete":true},{"id":3252,"client_id":2136,"project_status":3,"project_progress":49,"budget":"19200","profit_pct":"12.3","bargain_date":"2023-07-13","description":"","created_by":5087,"created_at":"2023-07-13 13:51:49","updated_at":"2024-01-11 11:22:19","engineer_id":"","project_title":"oracle\u4fee\u590d","collected":"19200","status_updated_at":"2023-07-13 13:55:27.128116+08","success_rate":"","comment":"","contract_type":2,"progress_updated_at":"2023-07-13 13:51:49.386708+08","forecast_updated_at":"2023-07-13 13:51:49.386708+08","end_at":"2023-11-15 09:22:28","pinyin_shortcut":"oraclexf","creator":5087,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":73,"is_sales_order_ready":false,"collected_plan":"19000","change_status_to":"","is_verify":false,"profits":"2361.60000000000000000","remain":"761 days 01:41:29.006244","progress_remain":"761 days 01:45:06.747652","forecast_remain":"761 days 01:45:06.747652","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"124 days 19:30:39.306348","issued_invoices":"19200.00","client":{"id":2136,"key":2136,"name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240","logo":"","client_type":6,"client_class":47,"client_industry":5,"sales_rep":5087},"usedClient":{},"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":49,"key":49,"name":"\u6536\u6b3e\u4e2d","description":"\u5b9a\u4e49\uff1a\u5f00\u53d1\u7968\uff0c\u5b8c\u6210\u6536\u6b3e \u3002\n\u65b9\u6cd5\uff1a\u5411\u8d22\u52a1\u7533\u8bf7\u5f00\u53d1\u7968\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"can_update":true,"can_delete":true},{"id":3231,"client_id":48,"project_status":3,"project_progress":9,"budget":"50404.1","profit_pct":"73.93","bargain_date":"2023-07-12","description":"Vmware+netapp+\u670d\u52a1\u5668\u7b49\u8fd0\u7ef4\u670d\u52a1\u3002\n\u4e0eTS-YJC-2023062103-2\u4e3a\u540c\u4e00\u4e2a\u5408\u540c","created_by":1004,"created_at":"2023-06-18 20:44:40","updated_at":"2024-07-26 13:40:43","engineer_id":"","project_title":"2023\u5e74\u8fd0\u7ef4\u670d\u52a1G","collected":"50404.1","status_updated_at":"2023-07-16 18:43:00.673285+08","success_rate":"","comment":"Vmware+netapp+\u670d\u52a1\u5668\u7b49\u8fd0\u7ef4\u670d\u52a1\u3002\n\u4e0eTS-YJC-2023062103-2\u4e3a\u540c\u4e00\u4e2a\u5408\u540c\r\n","contract_type":2,"progress_updated_at":"2023-07-16 18:43:00.673285+08","forecast_updated_at":"2023-07-16 18:43:00.673285+08","end_at":"2023-07-28 15:13:19","pinyin_shortcut":"2023nywfwG","creator":1004,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":237,"is_sales_order_ready":false,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"37263.751130000000000000","remain":"757 days 20:53:55.461075","progress_remain":"757 days 20:53:55.461075","forecast_remain":"757 days 20:53:55.461075","lost_contact_days":"","last_contact":"","last_arrive_days":"","last_arrive":"","duration":"39 days 18:28:39.599929","issued_invoices":"50404.10","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004},"usedClient":{},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":9,"key":9,"name":"\u7b7e\u8ba2\u5408\u540c","description":"\u5b9a\u4e49\uff1a\u786e\u8ba4\u4ea7\u54c1\u914d\u7f6e\uff0c\u4ea7\u54c1\u6570\u91cf\uff0c\u4ea7\u54c1\u4ef7\u683c\uff0c\u4ed8\u6b3e\u65b9\u5f0f\uff0c\u5230\u8d27\u65e5\u671f\uff0c\u8fdd\u7ea6\u6761\u6b3e\uff0c\u9a8c\u6536\u6807\u51c6\u3002 \n\u65b9\u6cd5\uff1a\u6309\u7167\u516c\u53f8\u5408\u540c\u8303\u672c\u6216\u6309\u7167\u5ba2\u6237\u8303\u672c\u7b7e\u8ba2\u5408\u540c\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"can_update":true,"can_delete":true},{"id":3141,"client_id":48,"project_status":3,"project_progress":10,"budget":"3000","profit_pct":"43.45","bargain_date":"2023-07-12","description":"HP 2T sata\u786c\u76d8\u00d72\n\u4e0eTS-YJC-2023062103-1\u4e3a\u540c\u4e00\u4e2a\u5408\u540c","created_by":1004,"created_at":"2023-03-09 09:52:31","updated_at":"2024-01-26 17:50:31","engineer_id":"","project_title":"P2000\u786c\u76d8\u6269\u5bb9","collected":"3000","status_updated_at":"2023-03-09 10:03:45.079641+08","success_rate":"","comment":"HP 2T sata\u786c\u76d8\u00d72\n\u4e0eTS-YJC-2023062103-1\u4e3a\u540c\u4e00\u4e2a\u5408\u540c\r\n","contract_type":1,"progress_updated_at":"2023-03-09 09:52:31.295773+08","forecast_updated_at":"2023-03-09 09:52:31.295773+08","end_at":"2023-07-28 15:13:34","pinyin_shortcut":"P2000ypkr","creator":1004,"used_client":"","from_contact":"","total_contact_point":"","paid_contact_point":"","project_product_version_id":17,"is_sales_order_ready":true,"collected_plan":"","change_status_to":"","is_verify":false,"profits":"1303.500000000000000000","remain":"887 days 05:33:11.054719","progress_remain":"887 days 05:44:24.838587","forecast_remain":"887 days 05:44:24.838587","lost_contact_days":"887.188844147685","last_contact":"2023-03-09 11:05:00","last_arrive_days":"","last_arrive":"","duration":"141 days 05:21:03.233055","issued_invoices":"3000.00","client":{"id":48,"key":48,"name":"\u4e2d\u90fd\u6570\u79d1\u4f9b\u5e94\u94fe\u7ba1\u7406\u6709\u9650\u516c\u53f8","logo":"","client_type":5,"client_class":47,"client_industry":8,"sales_rep":1004},"usedClient":{},"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"salesForecast":{"id":181,"key":181,"name":"\u6211\u81ea\u5df1\u505a\u5e84","description":"\u5382\u5546\u542c\u6211\u652f\u914d\uff0c\u7ed9\u6211\u597d\u4ef7\u683c\u3002\n\u5ba2\u6237\u542c\u6211\u652f\u914d\uff0c\u6309\u7167\u6211\u7684\u65b9\u5f0f\u91c7\u8d2d\u3002"},"projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"projectProgress":{"id":10,"key":10,"name":"\u4ea4\u8d27\u4e2d","description":"\u5b9a\u4e49\uff1a\u5ba2\u6237\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c\u7b7e\u7f72\u9a8c\u6536\u5355 \n\u65b9\u6cd5\uff1a\u8d27\u5230\u5ba2\u6237\u6307\u5b9a\u5730\u70b9\u7b7e\u7f72\u7b7e\u6536\u5355\uff0c \u5b89\u88c5\u90e8\u7f72\u5b8c\u6210\u7b7e\u7f72\u9a8c\u6536\u5355\u3002"},"projectRemindReceivers":[],"is_only_cp":false,"project_status_display":"\u6536\u6b3e\u5b8c\u6210","is_collected":true,"can_update":true,"can_delete":true}],"thisUser":"","can_create":true,"pagenation":{"totalcount":751,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-12 15:36:56') RETURNING "id" |
| 15:36:56.184 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 15:36:56.184 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SET |