17:17:48.989 | trace | yii\base\Application::bootstrap | Bootstrap with yii\log\Dispatcher |
17:17:48.989 | trace | yii\base\Module::getModule | Loading module: debug |
17:17:48.990 | trace | yii\base\Application::bootstrap | Bootstrap with yii\debug\Module::bootstrap() |
17:17:48.990 | trace | yii\redis\Connection::open | Opening redis DB connection: redis.server.local:6379, database=1 |
17:17:48.990 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: SELECT |
17:17:48.990 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:17:48.990 | trace | yii\base\Module::getModule | Loading module: gii |
17:17:48.990 | trace | yii\base\Application::bootstrap | Bootstrap with yii\gii\Module::bootstrap() |
17:17:48.991 | trace | yii\web\UrlManager::parseRequest | No matching URL rules. Using default URL parsing logic. |
17:17:48.991 | trace | yii\web\Application::handleRequest | Route requested: 'v2/reimbursement/recognize' |
17:17:48.991 | trace | yii\base\Module::getModule | Loading module: v2 |
17:17:48.991 | info | yii\web\Session::open | Session started |
17:17:48.992 | info | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
17:17:48.994 | info | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='jHlpO8y0vHBbQ6l37r2-YY8AcmS4s8X9' |
17:17:48.999 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:17:48.999 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:17:48.999 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:17:48.999 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:17:49.000 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
17:17:49.002 | trace | yii\base\Controller::runAction | Route to run: v2/reimbursement/recognize |
17:17:49.002 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:17:49.003 | trace | uranus\rbac\DbManager::checkAccessFromCache | Checking role: Admin |
17:17:49.003 | trace | yii\base\InlineAction::runWithParams | Running action: app\modules\v2\controllers\ReimbursementController::actionRecognize() |
17:17:49.018 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:17:49.018 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:17:49.019 | 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/', '4cd8302b-c4e6-3584-b5fe-0fd6ffea14b6', '20250917171747.jpeg', 'jpeg', 'image/jpeg', 1902137, '223.104.42.217', NULL) RETURNING "id" |
17:17:49.021 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:17:49.021 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:17:49.021 | 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', 28166, 'a:10:{s:2:"id";i:28166;s:9:"orig_name";s:19:"20250917171747.jpeg";s:4:"path";s:57:"/var/www/beta/web/files/protected/a57be577deb434/2025/09/";s:4:"name";s:36:"4cd8302b-c4e6-3584-b5fe-0fd6ffea14b6";s:9:"extension";s:4:"jpeg";s:9:"file_size";i:1902137;s:10:"ip_address";s:14:"223.104.42.217";s:10:"created_by";N;s:10:"created_at";N;s:9:"file_type";s:10:"image/jpeg";}', '', 1000, '223.104.42.217') |
17:17:49.191 | info | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28166 |
17:17:50.323 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE ("op"='invoice') AND ("number"='110023313048853276')) |
17:17:50.324 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE ("op"='invoice') AND ("number"='110023313048853392')) |
17:17:50.325 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE ("op"='invoice') AND ("number"='01100230010501690943')) |
17:17:50.325 | info | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE ("op"='invoice') AND ("number"='25117000001107285189')) |
17:17:50.325 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: GET |
17:17:50.325 | trace | yii\redis\Connection::executeCommand | Executing Redis Command: MGET |
17:17:50.326 | 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":"1758100608","token":"ecd4108bd39078620d485323c80b4ac4","version_code":"1149"}', '{"code":200,"data":{"summary":{"invoice_count":4,"amount_count":165098},"list":[{"saler_name":"\u5317\u4eac\u5929\u9a70\u541b\u6cf0\u5f8b\u5e08\u4e8b\u52a1\u6240","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","serial_no":"110023313048853276","occurrence_at":"2024-07-17 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"15000.00","invoice_duplicated":false,"attachment_id":28166,"x0":102,"y0":59,"x1":558,"y1":53,"x2":585,"y2":819,"x3":131,"y3":826},{"saler_name":"\u5317\u4eac\u5929\u9a70\u541b\u6cf0\u5f8b\u5e08\u4e8b\u52a1\u6240","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","serial_no":"110023313048853392","occurrence_at":"2024-08-06 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"15000.00","invoice_duplicated":false,"attachment_id":28166,"x0":582,"y0":111,"x1":1009,"y1":107,"x2":1030,"y2":828,"x3":606,"y3":834},{"saler_name":"","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8\u5317\u4eac\u5e02\u4e30\u53f0\u533a\u4eba\u6c11\u653f\u5e9c\u65b0\u6751\u8857\u9053\u529e\u4e8b\u5904","serial_no":"01100230010501690943","occurrence_at":"2025-09-08 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"135048.00","invoice_duplicated":false,"attachment_id":28166,"x0":182,"y0":1534,"x1":929,"y1":1490,"x2":956,"y2":1923,"x3":205,"y3":1967},{"saler_name":"\u4e2d\u56fd\u79fb\u52a8\u901a\u4fe1\u96c6\u56e2\u5317\u4eac\u6709\u9650\u516c\u53f8","purchaser_name":"\u5317\u4eac\u62d3\u5b9e\u79d1\u6280\u6709\u9650\u516c\u53f8","serial_no":"25117000001107285189","occurrence_at":"2025-09-04 00:00:00","type":"\u589e\u503c\u7a0e\u53d1\u7968","op":"invoice","amount":"50.00","invoice_duplicated":false,"attachment_id":28166,"x0":561,"y0":847,"x1":1007,"y1":840,"x2":1016,"y2":1482,"x3":569,"y3":1487}]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-17 17:17:50') RETURNING "id" |