ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
686771e0be3a4: POST https://beta.jinchangxiao.com/v2/work-log/save-edit at 2025-07-04 02:17:04 pm by 114.254.1.137

Log Messages

总计152条数据
TimeLevelCategoryMessage
 
14:17:04.778traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
14:17:04.778traceyii\base\Module::getModuleLoading module: debug
14:17:04.779traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
14:17:04.779traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
14:17:04.779traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
14:17:04.779traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.779traceyii\base\Module::getModuleLoading module: gii
14:17:04.779traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
14:17:04.780traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
14:17:04.780traceyii\web\Application::handleRequestRoute requested: 'v2/work-log/save-edit'
14:17:04.780traceyii\base\Module::getModuleLoading module: v2
14:17:04.780infoyii\web\Session::openSession started
14:17:04.781infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:17:04.784infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd'
14:17:04.788traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.788traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:17:04.788traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.789traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:17:04.789infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
14:17:04.791traceyii\base\Controller::runActionRoute to run: v2/work-log/save-edit
14:17:04.791traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.792traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
14:17:04.792traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\WorkLogController::actionSaveEdit()
14:17:04.792infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_logs" WHERE "id"='37028'
14:17:04.793traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.793traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:17:04.793traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.794traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.795infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_contacts" WHERE "work_log_id"=37028
14:17:04.798traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.798traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:17:04.799traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'location_out_distance' in 'app\models\WorkLogs'.
14:17:04.799traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'form_workLogVerifyRels' in 'app\models\WorkLogs'.
14:17:04.799traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'id' in 'app\models\WorkLogs'.
14:17:04.799traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'workLogContacts' in 'app\models\WorkLogs'.
14:17:04.799traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'location_in_distance' in 'app\models\WorkLogs'.
14:17:04.799traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.799traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:17:04.799infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_location" WHERE "id"='19222'
14:17:04.800traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.801traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:17:04.801infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Location', 19222, 'a:0:{}', '', 1000, '114.254.1.137')
14:17:04.803infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_location" WHERE "id"='19223'
14:17:04.804infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_location" SET "geolocation"='(116.289045,39.960427)', "updated_at"='2025-07-04 14:17:03' WHERE "id"=19223
14:17:04.805infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Location', 19223, 'a:1:{s:11:"geolocation";s:22:"(116.289045,39.960427)";}', '', 1000, '114.254.1.137')
14:17:04.807traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.807traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:17:04.807infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'location_out_id', 37028, 19, 1000, 'now()', '["(116.289045,39.960427)"]', '["(116.289045,39.960427)"]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u7b7e\u9000\u5b9a\u4f4d","d4":[""]}')
14:17:04.808infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Location', 19223, 'a:0:{}', '', 1000, '114.254.1.137')
14:17:04.810infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815')
14:17:04.811infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3805')
14:17:04.812infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_location" WHERE "id"='19222')
14:17:04.812infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_location" WHERE "id"=19223)
14:17:04.812infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000)
14:17:04.813infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_work_log_scenario_options" WHERE "id"='66')
14:17:04.813infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_work_log_scenarios" WHERE "id"='1')
14:17:04.814infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
14:17:04.815infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
14:17:04.816infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'end_at', 37028, 19, 1000, 'now()', '["2025-07-04 14:17:03"]', '["2025-07-04 14:16:34"]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u7ed3\u675f\u65f6\u95f4","d4":["2025-07-04 14:16:34 <b>\u53d8\u4e3a<\/b> 2025-07-04 14:17:03"]}'), (2, 'escort', 37028, 19, 1000, 'now()', '["ncnncj"]', '[""]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u966a\u540c\u4eba\u5458","d4":["ncnncj"]}'), (2, 'indistance', 37028, 19, 1000, 'now()', '["968"]', '[968.27259627562]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u7b7e\u5230\u8ddd\u79bb","d4":["968.27259627562 <b>\u53d8\u4e3a<\/b> 968"]}'), (2, 'outdistance', 37028, 19, 1000, 'now()', '["968.983787958388"]', '[968.27259627562]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u7b7e\u9000\u8ddd\u79bb","d4":["968.27259627562 <b>\u53d8\u4e3a<\/b> 968.983787958388"]}')
14:17:04.817infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815')
14:17:04.818infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3805')
14:17:04.818infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_location" WHERE "id"='19222')
14:17:04.819infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_location" WHERE "id"=19223)
14:17:04.819infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000)
14:17:04.819infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_work_log_scenario_options" WHERE "id"='66')
14:17:04.820infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_work_log_scenarios" WHERE "id"='1')
14:17:04.820infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_work_logs" SET "client_id"=2815, "scenario_id"=1, "scenario_option_id"=66, "end_at"='2025-07-04 14:17:03', "updated_at"='now()', "start_at"='2025-07-04 14:16:27', "escort"='ncnncj', "is_draft"=FALSE, "project_id"=3805, "location_in_id"=19222, "indistance"=968, "outdistance"=968.98378795839 WHERE "id"=37028
14:17:04.821infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\WorkLogs', 37028, 'a:6:{s:6:"end_at";s:19:"2025-07-04 14:17:03";s:8:"start_at";s:19:"2025-07-04 14:16:27";s:10:"indistance";s:3:"968";s:11:"outdistance";s:16:"968.983787958388";s:6:"escort";s:6:"ncnncj";s:8:"is_draft";s:1:"0";}', '', 1000, '114.254.1.137')
14:17:04.823infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815'
14:17:04.824traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.824traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:17:04.824infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND ("object_id"=37028)
14:17:04.827infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND ("object_id"=37028)
14:17:04.829infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_contacts" WHERE "work_log_id"=37028
14:17:04.831infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id"=5245
14:17:04.832traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.832infoyii\db\Command::querySELECT 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_contacts' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
14:17:04.842infoyii\db\Command::queryselect 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_contacts' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
14:17:04.852traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:17:04.852traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
14:17:04.852infoyii\db\Command::querySELECT "contact_id" FROM "a57be577deb434"."tbl_work_log_contacts" WHERE "work_log_id"=37028
14:17:04.854infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_carbon_copy_rels" WHERE "work_log_id"=37028
14:17:04.855infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_work_log_carbon_copy_rels" WHERE "work_log_id"=37028
14:17:04.856infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_verify_rels" WHERE "work_log_id"=37028 ORDER BY "id"
14:17:04.856traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.856traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:17:04.857infoyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_work_log_verify_rels" WHERE "work_log_id"=37028
14:17:04.858infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_work_log_verify_rels" ("work_log_id", "user_id", "status") VALUES (37028, 1000, 0)
14:17:04.859infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_carbon_copy_rels" WHERE "work_log_id"=37028
14:17:04.859infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_verify_rels" WHERE "work_log_id"=37028 ORDER BY "id"
14:17:04.860infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_scenario_options" WHERE "id"='66'
14:17:04.860traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.861traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:17:04.861traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.861traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:17:04.861infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_logs" WHERE "id"=37028
14:17:04.861infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000)
14:17:04.862infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1000, '19', 37028, '曹永生更新了一条客情增进的工作日志', TRUE, 'hcnnc') RETURNING "id"
14:17:04.863infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 170263, 'a:11:{s:2:"id";i:170263;s:9:"object_id";i:37028;s:11:"object_type";s:2:"19";s:6:"parent";N;s:11:"description";s:51:"曹永生更新了一条客情增进的工作日志";s:10:"created_by";i:1000;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:1;s:8:"for_user";N;s:12:"description2";s:5:"hcnnc";}', '', 1000, '114.254.1.137')
14:17:04.864infoyii\db\Command::querySELECT "channel_id" FROM "global"."tbl_logins" WHERE (0=1) AND ("id" != 1000) AND (channel_id IS NOT NULL)
14:17:04.864infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815'
14:17:04.865infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=2815
14:17:04.867infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2815) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
14:17:04.875traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.875traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:17:04.875infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2815, 1004, 'now()', NULL) RETURNING "id"
14:17:04.876infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 165114, 'a:5:{s:2:"id";i:165114;s:9:"client_id";i:2815;s:9:"sales_rep";i:1004;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1000, '114.254.1.137')
14:17:04.877infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 2815, 'a:0:{}', '', 1000, '114.254.1.137')
14:17:04.878infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
14:17:04.879infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 2815, 10, 37028, 19, 1000, '[37028]', '[37028]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u5ba2\u60c5\u589e\u8fdb"]}') RETURNING "id"
14:17:04.880infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 510080, 'a:13:{s:2:"id";i:510080;s:9:"object_id";s:4:"2815";s:11:"object_type";i:10;s:9:"target_id";i:37028;s:18:"target_object_type";i:19;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:7:"[37028]";s:9:"new_value";s:7:"[37028]";s:11:"description";s:119:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u5ba2\u60c5\u589e\u8fdb"]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '114.254.1.137')
14:17:04.880infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815'
14:17:04.881infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
14:17:04.881traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.881traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:17:04.882infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "users", "description") VALUES (2, 'update', 2815, 10, 37028, 19, 1000, '37028', '37028', array[1004,1000], '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u5ba2\u60c5\u589e\u8fdb"]}') RETURNING "id"
14:17:04.883infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\UserActionLogs', 136971, 'a:15:{s:2:"id";i:136971;s:9:"object_id";s:4:"2815";s:11:"object_type";i:10;s:9:"target_id";i:37028;s:18:"target_object_type";i:19;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"37028";s:9:"new_value";s:5:"37028";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:16:"array[1004,1000]";s:6:"params";a:0:{}}s:11:"description";s:119:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u5ba2\u60c5\u589e\u8fdb"]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1000, '114.254.1.137')
14:17:04.884traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.884traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:17:04.884infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3805'
14:17:04.885infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=3805
14:17:04.886infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3805) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
14:17:04.887traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.888traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:17:04.888infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3805, 'a:0:{}', '', 1000, '114.254.1.137')
14:17:04.888infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815
14:17:04.889infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
14:17:04.889infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 3805, 1, 37028, 19, 1000, '[37028]', '[37028]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u5ba2\u60c5\u589e\u8fdb"]}') RETURNING "id"
14:17:04.890infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 510081, 'a:13:{s:2:"id";i:510081;s:9:"object_id";s:4:"3805";s:11:"object_type";i:1;s:9:"target_id";i:37028;s:18:"target_object_type";i:19;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:7:"[37028]";s:9:"new_value";s:7:"[37028]";s:11:"description";s:119:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u5ba2\u60c5\u589e\u8fdb"]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '114.254.1.137')
14:17:04.891infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3805'
14:17:04.891infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815
14:17:04.892infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
14:17:04.892infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "users", "description") VALUES (2, 'update', 3805, 1, 37028, 19, 1000, '37028', '37028', array[1004], '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u5ba2\u60c5\u589e\u8fdb"]}') RETURNING "id"
14:17:04.893infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\UserActionLogs', 136972, 'a:15:{s:2:"id";i:136972;s:9:"object_id";s:4:"3805";s:11:"object_type";i:1;s:9:"target_id";i:37028;s:18:"target_object_type";i:19;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"37028";s:9:"new_value";s:5:"37028";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:11:"array[1004]";s:6:"params";a:0:{}}s:11:"description";s:119:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5de5\u4f5c\u65e5\u5fd7","d4":["\u5ba2\u60c5\u589e\u8fdb"]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1000, '114.254.1.137')
14:17:04.894infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815'
14:17:04.895infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=1) AND ("location_out_id" IS NOT NULL) AND ("location_in_id" IS NOT NULL) AND ("created_at" >= '2025-01-01 00:00:00') AND ("created_at" <= '2025-12-31 23:59:59') AND ("client_id"=2815)
14:17:04.896infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2815) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
14:17:04.904infoyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2815, 1004, 'now()', NULL) RETURNING "id"
14:17:04.906infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 165115, 'a:5:{s:2:"id";i:165115;s:9:"client_id";i:2815;s:9:"sales_rep";i:1004;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1000, '114.254.1.137')
14:17:04.907infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 2815, 'a:0:{}', '', 1000, '114.254.1.137')
14:17:04.908traceyii\redis\Connection::executeCommandExecuting Redis Command: INCR
14:17:04.908traceyii\redis\Connection::executeCommandExecuting Redis Command: HSET
14:17:04.908traceyii\redis\Connection::executeCommandExecuting Redis Command: LPUSH
14:17:04.908infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_work_log_verify_rels" WHERE "work_log_id"=37028 ORDER BY "id"
14:17:04.909infoyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=19) AND ("object_id"=37028) AND ("created_by"=1000))
14:17:04.928infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_work_log_verify_rels" SET "status"=1 WHERE "id"=14313
14:17:04.929infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\WorkLogVerifyRels', 14313, 'a:1:{s:6:"status";i:1;}', '', 1000, '114.254.1.137')
14:17:04.930infoyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\WorkLogs', 37028, 'a:0:{}', '', 1000, '114.254.1.137')
14:17:04.931infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815'
14:17:04.932traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:17:04.932traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:17:04.932infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 0, 261, 'v2/work-log/save-edit', '{"access_token":"Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd","WorkLogs":{"location_out_distance":"968.983787958388","scenario_id":"1","form_workLogCarbonCopyRels":"","location_out_lat":"39.960427","location_out_lng":"116.289045","form_workLogVerifyRels":["1000"],"location_out_updated_at":"2025-07-04 14:17:03","location_in_updated_at":"2025-07-04 14:16:27","client_id":"2815","id":"37028","location_out_id":"19223","workLogContacts":["5245"],"location_in_address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u9876\u8def2\u53f7\u9760\u8fd1\u91d1\u6e90\u65f6\u4ee3\u5546\u52a1\u4e2d\u5fc3","location_in_id":"19222","location_in_distance":"968","description":"hcnnc","is_draft":"0","escort":"ncnncj","start_at":"2025-07-04 14:16","location_out_address":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u897f\u9876\u8def2\u53f7\u9760\u8fd1\u91d1\u6e90\u65f6\u4ee3\u5546\u52a1\u4e2d\u5fc3","scenario_option_id":"66","end_at":"2025-07-04 14:17","project_id":"3805","location_in_lat":"39.960424","location_in_lng":"116.28903"},"device_type":"0","version_code":"261","token":"fb65682cb78a6fcd1da72f4a24ff8c64","posttime":"1751609826"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u5de5\u4f5c\u65e5\u5fd7\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}]}', FALSE, '2025-07-04 14:17:04') RETURNING "id"