ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a4dd63da8278: POST https://beta.jinchangxiao.com/vue/sales-contract/get-filter at 2026-07-08 12:46:53 pm by 114.244.130.20

Log Messages

总计40条数据
TimeLevelCategoryMessage
 
12:46:53.687traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
12:46:53.687traceyii\base\Module::getModuleLoading module: debug
12:46:53.688traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
12:46:53.689traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
12:46:53.689traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
12:46:53.689traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:46:53.690infotime tracing start1783486013690094848
12:46:53.690traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
12:46:53.690traceyii\web\Application::handleRequestRoute requested: 'vue/sales-contract/get-filter'
12:46:53.690traceyii\base\Module::getModuleLoading module: vue
12:46:53.724infoyii\web\Session::openSession started
12:46:53.726infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
12:46:53.726infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
12:46:53.727traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:46:53.727traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
12:46:53.728infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
12:46:53.729traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:46:53.730traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
12:46:53.730infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
12:46:53.731traceyii\base\Controller::runActionRoute to run: vue/sales-contract/get-filter
12:46:53.731traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:46:53.733traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
12:46:53.733traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\SalesContractController::actionGetFilter()
12:46:53.735infoyii\db\Command::querySELECT "id" AS "key", "type" AS "name" FROM "a57be577deb434"."tbl_contract_types" WHERE "is_delete"=FALSE ORDER BY "sort"
12:46:53.736traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:46:53.737traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:46:53.739infoyii\db\Command::querySELECT "g"."id", "g"."id" AS "key", "g"."name" FROM "a57be577deb434"."tbl_groups" "g" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.group_id = g.id WHERE ("sgr"."sales_id" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND (g.id != 999999) GROUP BY "g"."id" ORDER BY "sort"
12:46:53.740traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:46:53.740traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
12:46:53.740infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_group_relationships" WHERE "group_id" IN (80, 1, 81, 83)
12:46:53.741infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "user_status", "pinyin_shortcut" FROM "a57be577deb434"."tbl_users" WHERE ("id" IN (1001, 5049, 5500, 5301, 5499, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5467, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 5476, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) AND ("user_status"='1') AND ("id" IN (5295, 5300, 5087, 5332, 1013, 5311, 1005, 5476, 5064, 1004, 5499, 1001, 5500)) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
12:46:53.742infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5500, 5499, 5332, 1001, 5087, 5300, 5311, 5295, 1013, 5476, 1004, 1005))
12:46:53.743infoyii\db\Command::querySELECT "created_by" FROM "a57be577deb434"."tbl_sales_contracts" GROUP BY "created_by"
12:46:53.744infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE ("user_status" IN ('1', '2')) AND ("id" IN (1028, 1000, 5089, 5412, 5311, 5295, 1002, 5359, 5364, 5015, 5300, 5329, 5309, 1011, 1006, 1001, 5299, 1010, 5096, 1005, 5063, 1004, 5250, 5294, 5087)) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
12:46:53.745infoyii\db\Command::querySELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "is_delete"=FALSE ORDER BY "order", "id"
12:46:53.747traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:46:53.747traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
12:46:53.747infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/sales-contract/get-filter', '{"web_access_token":"niM9Np1xaU2lIsoGJh5qM6IxT9naEHjn"}', '{"code":2000,"result":[{"key":"SalesContractSearch[contract_type]","name":"\u5408\u540c\u7c7b\u578b","value":[{"key":1,"name":"\u4ea7\u54c1\u9500\u552e"},{"key":2,"name":"\u8fd0\u7ef4\u670d\u52a1"}],"default":""},{"key":"SalesContractSearch[contract_scan]","name":"\u5408\u540c\u626b\u63cf","value":[{"key":0,"name":"\u672a\u4e0a\u4f20"},{"key":1,"name":"\u5df2\u4e0a\u4f20"}],"default":""},{"key":"SalesContractSearch[receipt_scan]","name":"\u7b7e\u6536\u5355","value":[{"key":0,"name":"\u672a\u4e0a\u4f20"},{"key":1,"name":"\u5df2\u4e0a\u4f20"}],"default":""},{"key":"SalesContractSearch[verify_scan]","name":"\u9a8c\u6536\u5355","value":[{"key":0,"name":"\u672a\u4e0a\u4f20"},{"key":1,"name":"\u5df2\u4e0a\u4f20"}],"default":""},{"key":"SalesContractSearch[is_outbound]","name":"\u51fa\u5e93\u72b6\u6001","value":[{"key":0,"name":"\u672a\u5b8c\u6210"},{"key":1,"name":"\u5df2\u5b8c\u6210"}],"default":"","type":"radio"},{"key":"SalesContractSearch[is_settle]","name":"\u5229\u6da6\u7387\u6838\u7b97","value":[{"key":0,"name":"\u672a\u5b8c\u6210"},{"key":1,"name":"\u5df2\u5b8c\u6210"}],"default":"","type":"radio"},{"key":"SalesContractSearch[is_deliver]","name":"\u4ea7\u54c1\u4ea4\u4ed8","value":[{"key":0,"name":"\u672a\u5b8c\u6210"},{"key":1,"name":"\u5df2\u5b8c\u6210"}],"default":"","type":"radio"},{"key":"SalesContractSearch[is_sales_order_ready]","name":"\u9500\u552e\u8bb0\u5f55","value":[{"key":-1,"name":"\u672a\u8bbe\u7f6e"},{"key":1,"name":"\u5df2\u5b8c\u5584"},{"key":0,"name":"\u672a\u5b8c\u5584"}],"default":""},{"key":"SalesContractSearch[group]","name":"\u5ba2\u6237\u7ecf\u7406","value":[{"id":80,"key":80,"name":"\u5408\u4f19\u4eba","child":[{"id":5087,"key":5087,"name":"\u5218\u5fae","user_status":"1","pinyin_shortcut":"lw","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","user_status":"1","pinyin_shortcut":"wjc","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}},{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","user_status":"1","pinyin_shortcut":"yjc","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","user_status":"1","pinyin_shortcut":"zmxsry","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}}]},{"id":1,"key":1,"name":"\u5218\u4eba\u8bda\u7ec4","child":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","user_status":"1","pinyin_shortcut":"lrc","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/\/avatar\/e868e40f-1256-329e-9b1c-74e095049622.png"}},{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","user_status":"1","pinyin_shortcut":"sqy","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","user_status":"1","pinyin_shortcut":"tskj","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","user_status":"1","pinyin_shortcut":"wzw","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}}]},{"id":81,"key":81,"name":"\u4f0a\u5cfb\u8fb0\u7ec4","child":[{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","user_status":"1","pinyin_shortcut":"hwc","avatar":{"id":148,"user_id":5332,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"}}]},{"id":83,"key":83,"name":"\u91d1\u7545\u900d","child":[{"id":5500,"key":5500,"name":"\u6d4b\u8bd5","user_status":"1","pinyin_shortcut":"cs","avatar":null},{"id":5499,"key":5499,"name":"\u9648\u8c46\u8c46","user_status":"1","pinyin_shortcut":"cdd","avatar":null},{"id":5476,"key":5476,"name":"\u6768\u5dcd","user_status":"1","pinyin_shortcut":"yw","avatar":null}]},{"key":0,"name":"\u516c\u6d77\u5ba2\u6237"}],"default":1001,"itemKey":"SalesContractSearch[handler]","type":"CascadeMultiple"},{"key":"SalesContractSearch[invoice_status]","name":"\u5f00\u7968\u72b6\u6001","value":[{"key":"0","name":"\u672a\u5f00\u7968\u5b8c\u6210"},{"key":"1","name":"\u5f00\u7968\u5b8c\u6210"}],"default":""},{"key":"SalesContractSearch[payment_status]","name":"\u6536\u6b3e\u72b6\u6001","value":[{"key":"0","name":"\u672a\u6536\u6b3e\u5b8c\u6210"},{"key":"1","name":"\u6536\u6b3e\u5b8c\u6210"}],"default":""},{"key":"SalesContractSearch[created_by]","name":"\u6210\u4ea4\u8005","value":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f"},{"id":5250,"key":5250,"name":"\u8463\u8363"},{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3"},{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},{"id":5087,"key":5087,"name":"\u5218\u5fae"},{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"},{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280"},{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"},{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}],"default":"","type":"SelectMultiple"},{"key":"SalesContractSearch[projectProductTypes]","name":"\u5546\u673a\u7c7b\u578b","value":[{"key":2,"name":"\u670d\u52a1\u5668"},{"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},{"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},{"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},{"key":88,"name":"\u79c1\u6709\u4e91"},{"key":8,"name":"\u4e91\u684c\u9762"},{"key":7,"name":"\u8f6f\u4ef6"},{"key":10,"name":"\u56fe\u5f62\u5de5\u4f5c\u7ad9"},{"key":69,"name":"\u5907\u4efd"},{"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},{"key":12,"name":"\u7b14\u8bb0\u672c"},{"key":13,"name":"\u6253\u5370\u673a"},{"key":14,"name":"UPS"},{"key":16,"name":"\u8fd0\u7ef4\u670d\u52a1"},{"key":17,"name":"\u5de5\u63a7\u673a"},{"key":18,"name":"\u673a\u623f\u8bbe\u5907"},{"key":19,"name":"\u6280\u672f\u670d\u52a1"},{"key":20,"name":"\u529e\u516c\u8bbe\u5907"},{"key":21,"name":"\u6570\u7801\u8bbe\u5907"},{"key":22,"name":"\u670d\u52a1"},{"key":23,"name":"\u793c\u54c1"},{"key":75,"name":"\u8f6f\u4ef6\u5f00\u53d1"},{"key":106,"name":"\u516c\u6709\u4e91"}],"checkType":"multiple","default":[]},{"custom":"1","key":"SalesContractSearch[invoice_from_date_period]","name":"\u5f00\u7968\u65e5\u671f","value":[{"key":"thisweek","name":"\u672c\u5468"},{"key":"lastweek","name":"\u4e0a\u5468"},{"key":"thismonth","name":"\u672c\u6708"},{"key":"lastmonth","name":"\u4e0a\u6708"},{"key":"custom","name":"\u81ea\u5b9a\u4e49"}],"default":""},{"key":"SalesContractSearch[contact_point_status]","name":"\u79ef\u5206\u6838\u9500\u72b6\u6001","value":[{"key":"0","name":"\u672a\u8bbe\u7f6e"},{"key":"1","name":"\u5df2\u6838\u9500"},{"key":"2","name":"\u672a\u6838\u9500"}],"default":""},{"key":"SalesContractSearch[collected_plan]","name":"\u6536\u6b3e\u8ba1\u5212\u72b6\u6001","value":[{"key":"0","name":"\u672a\u5b8c\u5584"},{"key":"1","name":"\u5df2\u5b8c\u5584"}],"default":""},{"key":"SalesContractSearch[is_verify]","name":"\u5408\u540c\u72b6\u6001","value":[{"key":0,"name":"\u6b63\u5e38"},{"key":1,"name":"\u5ba1\u6838\u4e2d"}],"default":""},{"key":"Filter[name]","name":"\u65f6\u95f4\u6392\u5e8f","value":[{"key":"updated_at","name":"\u66f4\u65b0\u65f6\u95f4"},{"key":"created_at","name":"\u521b\u5efa\u65f6\u95f4"},{"key":"signed_at","name":"\u7b7e\u8ba2\u65e5\u671f"},{"key":"expire_date","name":"\u670d\u52a1\u622a\u6b62\u65e5\u671f"},{"key":"amount","name":"\u603b\u989d"}],"default":"signed_at"},{"key":"Filter[sort]","name":"\u6392\u5e8f\u65b9\u5f0f","value":[{"key":"ASC","name":"\u6b63\u5e8f"},{"key":"DESC","name":"\u5012\u5e8f"}],"default":""},{"key":"SalesContractSearch[including_tax]","name":"\u662f\u5426\u542b\u7a0e","value":[{"key":1,"name":"\u662f"},{"key":0,"name":"\u5426"}],"default":""}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"114.244.130.20","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-08 12:46:53', 57525248) RETURNING "id"
12:46:53.750traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12:46:53.750traceyii\redis\Connection::executeCommandExecuting Redis Command: SET