15:39:38.703 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
15:39:38.703 | trace | yii\base\Module::getModule | Loading module: debug |
15:39:38.704 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
15:39:38.704 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
15:39:38.704 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
15:39:38.704 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:39:38.704 | trace | yii\base\Module::getModule | Loading module: gii |
15:39:38.704 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
15:39:38.705 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
15:39:38.705 | trace | yii\web\Application::handleRequest | Route requested: 'v2/reimbursement/recognize' |
15:39:38.705 | trace | yii\base\Module::getModule | Loading module: v2 |
15:39:38.705 | info | yii\web\Session::open | Session started |
15:39:38.705 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
15:39:38.707 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='jHlpO8y0vHBbQ6l37r2-YY8AcmS4s8X9' |
15:39:38.710 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:39:38.710 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
15:39:38.711 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:39:38.711 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
15:39:38.711 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
15:39:38.712 | trace | yii\base\Controller::runAction | Route to run: v2/reimbursement/recognize |
15:39:38.713 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:39:38.713 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
15:39:38.714 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\ReimbursementController::actionRecognize() |
15:39:38.722 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:39:38.722 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
15:39:38.722 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000) |
15:39:38.723 | info | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_attachments" ("path", "name", "orig_name", "extension", "file_type", "file_size", "ip_address", "created_by") VALUES ('/var/www/beta/web/files/protected/a57be577deb434/2025/09/', '19e540e4-e75c-35dd-b873-7f559dd601d0', '20250918153926.jpeg', 'jpeg', 'image/jpeg', 12545535, '117.176.186.24', 1000) RETURNING "id" |
15:39:38.724 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:39:38.724 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
15:39:38.724 | info | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Attachments', 28214, 'a:10:{s:2:"id";i:28214;s:9:"orig_name";s:19:"20250918153926.jpeg";s:4:"path";s:57:"/var/www/beta/web/files/protected/a57be577deb434/2025/09/";s:4:"name";s:36:"19e540e4-e75c-35dd-b873-7f559dd601d0";s:9:"extension";s:4:"jpeg";s:9:"file_size";i:12545535;s:10:"ip_address";s:14:"117.176.186.24";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"file_type";s:10:"image/jpeg";}', '', 1000, '117.176.186.24') |
15:39:39.180 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28214 |
15:39:40.094 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE "number"='11100208115114867885') |
15:39:40.095 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE "number"='11100208115114867884') |
15:39:40.095 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
15:39:40.095 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
15:39:40.095 | info | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 2, 1149, 'v2/reimbursement/recognize', '{"access_token":"jHlpO8y0vHBbQ6l37r2-YY8AcmS4s8X9","device_type":"2","posttime":"1758181120","token":"5198ed3268b36fba04cab33e293c1120","version_code":"1149"}', '{"code":200,"data":{"summary":{"invoice_count":2,"amount_count":5},"list":[{"saler_name":"","purchaser_name":"","serial_no":"11100208115114867885","occurrence_at":"","type":"\u5b9a\u989d\u53d1\u7968","op":"quota_invoice","amount":"5.00","invoice_duplicated":false,"attachment_id":28214,"x0":542,"y0":56,"x1":1238,"y1":68,"x2":1222,"y2":1171,"x3":541,"y3":1152},{"saler_name":"","purchaser_name":"","serial_no":"11100208115114867884","occurrence_at":"","type":"\u5b9a\u989d\u53d1\u7968","op":"quota_invoice","amount":"","invoice_duplicated":false,"attachment_id":28214,"x0":1250,"y0":66,"x1":1598,"y1":80,"x2":1597,"y2":1157,"x3":1231,"y3":1145}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-18 15:39:40') RETURNING "id" |