68c145101d18e: POST https://beta.jinchangxiao.com/vue/analysis/collect-list-export at 2025-09-10 05:29:52 pm by 114.246.239.150
Log Messages
总计32条数据
| Time | Level | Category | Message |
|---|---|---|---|
| 17:29:52.118 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
| 17:29:52.118 | trace | yii\base\Module::getModule | Loading module: debug |
| 17:29:52.119 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
| 17:29:52.119 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
| 17:29:52.119 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
| 17:29:52.119 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:29:52.119 | trace | yii\base\Module::getModule | Loading module: gii |
| 17:29:52.119 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
| 17:29:52.119 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
| 17:29:52.119 | trace | yii\web\Application::handleRequest | Route requested: 'vue/analysis/collect-list-export' |
| 17:29:52.119 | trace | yii\base\Module::getModule | Loading module: vue |
| 17:29:52.120 | info | yii\web\Session::open | Session started |
| 17:29:52.120 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 17:29:52.120 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 17:29:52.125 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:29:52.125 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:29:52.125 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:29:52.126 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:29:52.126 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 17:29:52.128 | trace | yii\base\Controller::runAction | Route to run: vue/analysis/collect-list-export |
| 17:29:52.128 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:29:52.129 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
| 17:29:52.129 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\vue\controllers\AnalysisController::actionCollectListExport() |
| 17:29:52.129 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:29:52.129 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:29:52.131 | info | yii\db\Command::query | SELECT "scp".* FROM (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1))) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.sales_contract_id as contract_id, r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.sales_contract_id as contract_id, 0 - r.amount as amount, t.created_at as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE (r.sales_contract_id is not null) AND ("t"."status" IN (2, 5, 1)) )) "sub") "scp" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "c" ON c.id = scp.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON c.from_project = p.id WHERE ("scp"."collected_date" >= '2025-01-01') AND ("scp"."collected_date" <= '2025-12-31') AND (p.id is not null) AND ("p"."created_by" IN ('1001', '1004', '1005', '1013', '5087', '5295', '5300', '5311', '5329', '5332', '5420', '5448', '5449')) ORDER BY scp.created_at DESC NULLS LAST, scp.id desc |
| 17:29:52.137 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
| 17:29:52.137 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
| 17:29:52.137 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (4112, 4131, 4129, 4094, 4083, 4082, 4099, 4086, 4047, 4048, 4016, 4068, 4065, 4064, 4050, 4049, 4043, 3926, 4009, 4027, 4028, 4029, 4054, 3931, 3925, 4024, 4046, 4044, 4005, 4021, 4022, 4036, 3646, 3202, 3960, 3286, 3915, 3854, 4002, 4008, 3924, 2851, 3979, 3980, 3984, 3972, 3421, 3995, 3978, 3998, 3959, 3997, 3664, 3989, 3954, 3943, 3942, 3930, 3935, 3966, 3965, 3861, 3916, 3626, 3953, 3941, 3952, 3958, 3967, 3887, 2927, 2996, 3060, 3905, 3919, 3912, 2991, 3795, 3892, 3895, 3879, 3878, 3910, 3920, 3735, 3705, 3899, 3900, 3736, 3864, 3872, 3886, 3881, 3897, 3871, 3868, 3764, 3865, 3855, 3851, 3849, 3832, 3835, 3831, 3875, 3844, 3679, 3866, 3842, 3797, 3857, 3812, 3342, 3816, 3792, 3005, 3477, 3803, 3805, 3841, 3838, 2925, 3567, 3833, 3822, 3829, 3243, 3418, 3724, 3763, 2961, 2978, 3811, 3629, 3796, 3345, 3745, 3809, 3808, 3758, 3759, 3782, 3778, 3496, 3791, 3790, 3783, 3777, 3703, 3738, 3368, 3787, 3767, 3697, 3770, 3691, 3693, 3694, 3710, 3711, 3734, 3729, 3761, 3502, 3755, 2977, 3771, 3733, 3725, 3381, 3468, 3548, 3656, 3497, 3746, 3737, 3744, 3486, 3487, 3488, 3748, 3749, 3325, 3701) |
| 17:29:52.140 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name", "budget", "bargain_date", "created_by", "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3926, 3745, 3149, 3411, 3774, 3785, 3770, 3512, 3845, 3875, 3924, 3928, 3929, 3882, 3352, 3417, 3389, 3578, 3562, 3588, 3566, 3628, 3636, 3637, 3602, 3635, 3642, 3644, 3672, 3609, 3659, 3641, 3710, 3696, 3666, 3700, 3694, 3663, 3732, 3738, 3736, 3741, 3742, 3753, 3735, 3734, 3768, 3723, 3721, 3719, 3749, 3767, 3547, 3757, 3764, 3744, 3756, 3752, 3657, 3720, 3699, 3765, 3763, 3759, 3760, 3766, 3786, 3750, 3783, 3788, 3809, 3772, 3771, 3791, 3776, 3801, 3806, 3773, 3775, 3782, 3777, 3792, 3761, 3762, 3781, 3769, 3805, 3789, 3802, 3794, 3800, 3815, 3811, 3793, 3804, 3808, 3812, 3821, 3825, 3816, 3826, 3828, 3829, 3853, 3851, 3814, 3799, 3850, 3877, 3872, 3823, 3797, 3858, 3859, 3803, 3869, 3824, 3857, 3856, 3865, 3855, 3860, 3847, 3862, 3798, 3863, 3822, 3876, 3879, 3866, 3912, 3873, 3903, 3870, 3852, 3836, 3893, 3892, 3885, 3886, 3890, 3889, 3249, 3831, 3899, 3902, 3916, 3901, 3827, 3894, 3834, 3871, 3898, 3918, 3896, 3913, 3900, 3920, 3925, 3874, 3919, 3322, 3308, 3299, 3355, 3319, 3367, 3294, 3940, 3784, 3941, 3948, 3910, 3883, 3927, 3936, 3849, 3431, 3917, 3810, 3930, 3835, 3950, 3956) |
| 17:29:52.142 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1005, 5300, 1001, 5087, 5295, 1004) |
| 17:29:52.142 | info | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (89, 1181, 3389, 918, 57, 2526, 3317, 93, 287, 12, 42, 2616, 2553, 107, 1172, 2021, 79, 2548, 3281, 3340, 3326, 4, 2736, 2094, 2545, 149, 1663, 2146, 1301, 1225, 2205, 2182, 94, 2585, 497, 48, 518, 3327, 3302, 97, 2136, 528, 3373, 3372, 2125, 3280, 189, 3333, 531, 2032, 2546, 3334, 2226, 20, 2007, 3359, 3304, 2729, 2091, 2842, 2727, 2117, 24, 2158, 2202, 3364, 2766, 1492, 2186, 31, 2845, 3366, 3357, 2177, 3367, 3383, 3377, 3376, 2596, 2594, 3363, 2762, 3286) |