ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68a436917c79e: POST https://beta.jinchangxiao.com/vue/tax/sales-invoice-get-edit at 2025-08-19 04:32:17 pm by 223.104.44.8

Performance Profiling

Total processing time: 64 ms; Peak memory: 5.671 MB. Show Profiling Timeline

总计62条数据
TimeDurationCategoryInfo
  
16:32:17.5643.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=10004) AND ("visit_date"='2025-08-19')
16:32:17.5322.6 msyii\db\Command::querySELECT "sip".*, sum(inventory) as inventory_count FROM "a57be577deb434"."tbl_sales_invoice_products" "sip" LEFT JOIN "a57be577deb434"."tbl_inventory_products" "ip" ON lower(ip.title) = lower(sip.title) AND lower(ip.description) = lower(sip.description) WHERE "sip"."sales_invoice_id"=1979 GROUP BY "sip"."id"
16:32:17.5132.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:32:17.5202.2 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT sci.* FROM "a57be577deb434"."tbl_sales_contract_invoices" "sci" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = sci.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id WHERE (sci.cover_invoice_id is null) AND (("sci"."invoice_type"='2')) GROUP BY "sci"."id") "c"
16:32:17.5692.2 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/tax/sales-invoice-get-edit', '{"SalesContractInvoiceSearch":{"invoice_type":["2"],"from_date_period":"","created_at_period":"","group":"","created_by":"","is_cancel":"","is_match":"","is_draft":"","is_contract_cancel":""},"Filter":{"name":"from_date","sort":"DESC"},"id":"1979","web_access_token":"239qcuu_ToIhJtTt60gp-9_fllLTtTgq"}', '{"code":2000,"result":{"model":{"id":1979,"contract_id":3811,"from_date":"2025-03-14","attachment_id":"","amount":"3150.00","created_by":5252,"created_at":"2025-03-14 10:20:07","description":"","invoice_num":"25112000000050933384","invoice_type":2,"is_match":true,"is_cancel":false,"is_used":true,"cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"tax_amount":"362.39","excluding_tax":"2787.61","is_draft":false,"updated_at":"2025-03-14 14:38:50","need_match":true,"need_match_description":"","match_tax_amount":"149.56","simple_match_tax_amount":"0","is_settle":true,"is_contract_cancel":false,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"attachmentRelationships":[],"files":[{"id":32899,"object_type":102,"object_id":1979,"attachment_id":24542,"attachment":{"id":24542,"key":24542,"name":"4974f2a1-62b1-32e9-ac1c-15fc300eb35c","extension":"pdf","path":"\/vue\/attachment\/view\/4974f2a1-62b1-32e9-ac1c-15fc300eb35c\/dzfp_25112000000050933384_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250314101355.pdf","orig_name":"dzfp_25112000000050933384_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250314101355.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":537,"sales_invoice_id":1979,"title":"1.8T","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u786c\u76d8","number":"1","outbound":"1","unit":"\u4e2a","amount":"3150","tax_rate":"13","including_tax":"0","excluding_tax":"2787.61","tax_amount":"362.39","need_match":true,"inventory_count":"","spents":[{"id":1047,"sales_product_id":537,"build_group_id":"","inventory_product_id":1336,"outbound":"1","number":"0","sales_invoice_id":"","inventoryProduct":{"id":1336,"purchase_invoice_id":2159,"purchase_product_id":1333,"title":"1.8T","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u786c\u76d8","number":"1","unit":"\u5757","outbound":"1","inventory":"0","amount":"1300","tax_rate":"13","including_tax":"0","excluding_tax":"1150.44","tax_amount":"149.56","is_build":false,"build_group_id":"","created_at":"2025-03-07 09:45:58","purchaseInvoice":{"id":2159,"contract_id":3814,"amount":"1300","attachment_id":"","from_date":"2025-03-07","created_by":5360,"created_at":"2025-03-07 09:44:46","description":"","invoice_num":"25112000000045378206","invoice_type":1,"handler":5360,"is_verify":true,"is_cancel":false,"paid_amount":"1300","tax_amount":"149.56","excluding_tax":"1150.44","verify_at":"2025-03-31 00:00:00","is_used":true,"updated_at":"2025-03-07 09:45:58","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":678,"is_contract_cancel":false},"buildGroup":{}}}],"matchPurchaseInvoice":[{"id":2159,"contract_id":3814,"amount":"1300","attachment_id":"","from_date":"2025-03-07","created_by":5360,"created_at":"2025-03-07 09:44:46","description":"","invoice_num":"25112000000045378206","invoice_type":1,"handler":5360,"is_verify":true,"is_cancel":false,"paid_amount":"1300","tax_amount":"149.56","excluding_tax":"1150.44","verify_at":"2025-03-31 00:00:00","is_used":true,"updated_at":"2025-03-07 09:45:58","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":678,"is_contract_cancel":false}],"inventory":0}],"spents":[],"contract":{"id":3811,"key":3811,"serial_no":"TS-SQY-20250305001","client_id":531,"project_id":3791,"client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587"}},"project":{"id":3791,"key":3791,"name":"\u786c\u76d81.8T1\u5757-K-2025"}},"cancelInvoice":{},"redInvoice":{"id":1978,"contract_id":3811,"from_date":"2025-03-14","attachment_id":"","amount":"-3150.00","created_by":5252,"created_at":"2025-03-14 10:19:30","description":"","invoice_num":"25112000000049433908","invoice_type":-1,"is_match":false,"is_cancel":false,"is_used":false,"cancel_description":"","cover_invoice_id":1979,"red_invoice_id":"","new_invoice_id":1979,"need_new_invoice":true,"tax_amount":"-362.39","excluding_tax":"-2787.61","is_draft":false,"updated_at":"2025-03-14 10:19:30","need_match":false,"need_match_description":"","match_tax_amount":"0","simple_match_tax_amount":"0","is_settle":true,"is_contract_cancel":false},"coverInvoices":[{"id":1979,"contract_id":3811,"from_date":"2025-03-14","attachment_id":"","amount":"3150.00","created_by":5252,"created_at":"2025-03-14 10:20:07","description":"","invoice_num":"25112000000050933384","invoice_type":2,"is_match":true,"is_cancel":false,"is_used":true,"cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"tax_amount":"362.39","excluding_tax":"2787.61","is_draft":false,"updated_at":"2025-03-14 14:38:50","need_match":true,"need_match_description":"","match_tax_amount":"149.56","simple_match_tax_amount":"0","is_settle":true,"is_contract_cancel":false,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"attachmentRelationships":[],"files":[{"id":32899,"object_type":102,"object_id":1979,"attachment_id":24542,"attachment":{"id":24542,"key":24542,"name":"4974f2a1-62b1-32e9-ac1c-15fc300eb35c","extension":"pdf","path":"\/vue\/attachment\/view\/4974f2a1-62b1-32e9-ac1c-15fc300eb35c\/dzfp_25112000000050933384_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250314101355.pdf","orig_name":"dzfp_25112000000050933384_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250314101355.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":537,"sales_invoice_id":1979,"title":"1.8T","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u786c\u76d8","number":"1","outbound":"1","unit":"\u4e2a","amount":"3150","tax_rate":"13","including_tax":"0","excluding_tax":"2787.61","tax_amount":"362.39","need_match":true,"inventory_count":"","spents":[{"id":1047,"sales_product_id":537,"build_group_id":"","inventory_product_id":1336,"outbound":"1","number":"0","sales_invoice_id":"","inventoryProduct":{"id":1336,"purchase_invoice_id":2159,"purchase_product_id":1333,"title":"1.8T","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u786c\u76d8","number":"1","unit":"\u5757","outbound":"1","inventory":"0","amount":"1300","tax_rate":"13","including_tax":"0","excluding_tax":"1150.44","tax_amount":"149.56","is_build":false,"build_group_id":"","created_at":"2025-03-07 09:45:58","purchaseInvoice":{"id":2159,"contract_id":3814,"amount":"1300","attachment_id":"","from_date":"2025-03-07","created_by":5360,"created_at":"2025-03-07 09:44:46","description":"","invoice_num":"25112000000045378206","invoice_type":1,"handler":5360,"is_verify":true,"is_cancel":false,"paid_amount":"1300","tax_amount":"149.56","excluding_tax":"1150.44","verify_at":"2025-03-31 00:00:00","is_used":true,"updated_at":"2025-03-07 09:45:58","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":678,"is_contract_cancel":false},"buildGroup":{}}}],"matchPurchaseInvoice":[{"id":2159,"contract_id":3814,"amount":"1300","attachment_id":"","from_date":"2025-03-07","created_by":5360,"created_at":"2025-03-07 09:44:46","description":"","invoice_num":"25112000000045378206","invoice_type":1,"handler":5360,"is_verify":true,"is_cancel":false,"paid_amount":"1300","tax_amount":"149.56","excluding_tax":"1150.44","verify_at":"2025-03-31 00:00:00","is_used":true,"updated_at":"2025-03-07 09:45:58","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":678,"is_contract_cancel":false}],"inventory":0}],"spents":[],"contract":{"id":3811,"key":3811,"serial_no":"TS-SQY-20250305001","client_id":531,"project_id":3791,"client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587"}},"project":{"id":3791,"key":3791,"name":"\u786c\u76d81.8T1\u5757-K-2025"}},"cancelInvoice":{},"redInvoice":{"id":1978,"contract_id":3811,"from_date":"2025-03-14","attachment_id":"","amount":"-3150.00","created_by":5252,"created_at":"2025-03-14 10:19:30","description":"","invoice_num":"25112000000049433908","invoice_type":-1,"is_match":false,"is_cancel":false,"is_used":false,"cancel_description":"","cover_invoice_id":1979,"red_invoice_id":"","new_invoice_id":1979,"need_new_invoice":true,"tax_amount":"-362.39","excluding_tax":"-2787.61","is_draft":false,"updated_at":"2025-03-14 10:19:30","need_match":false,"need_match_description":"","match_tax_amount":"0","simple_match_tax_amount":"0","is_settle":true,"is_contract_cancel":false},"is_new":true,"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":1,"tax_rate":["13"],"un_match_tax_amount":212.83,"except_simple_match_tax_amount":212.83,"salesInvoiceProductList":[{"tax_rate":13,"amount":3150,"excluding_tax":2787.61,"tax_amount":362.39,"list":[{"id":537,"sales_invoice_id":1979,"title":"1.8T","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u786c\u76d8","number":"1","outbound":"1","unit":"\u4e2a","amount":"3150","tax_rate":"13","including_tax":"0","excluding_tax":"2787.61","tax_amount":"362.39","need_match":true,"inventory_count":"","spents":[{"id":1047,"sales_product_id":537,"build_group_id":"","inventory_product_id":1336,"outbound":"1","number":"0","sales_invoice_id":"","inventoryProduct":{"id":1336,"purchase_invoice_id":2159,"purchase_product_id":1333,"title":"1.8T","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u786c\u76d8","number":"1","unit":"\u5757","outbound":"1","inventory":"0","amount":"1300","tax_rate":"13","including_tax":"0","excluding_tax":"1150.44","tax_amount":"149.56","is_build":false,"build_group_id":"","created_at":"2025-03-07 09:45:58","purchaseInvoice":{"id":2159,"contract_id":3814,"amount":"1300","attachment_id":"","from_date":"2025-03-07","created_by":5360,"created_at":"2025-03-07 09:44:46","description":"","invoice_num":"25112000000045378206","invoice_type":1,"handler":5360,"is_verify":true,"is_cancel":false,"paid_amount":"1300","tax_amount":"149.56","excluding_tax":"1150.44","verify_at":"2025-03-31 00:00:00","is_used":true,"updated_at":"2025-03-07 09:45:58","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":678,"is_contract_cancel":false},"buildGroup":{}}}],"matchPurchaseInvoice":[{"id":2159,"contract_id":3814,"amount":"1300","attachment_id":"","from_date":"2025-03-07","created_by":5360,"created_at":"2025-03-07 09:44:46","description":"","invoice_num":"25112000000045378206","invoice_type":1,"handler":5360,"is_verify":true,"is_cancel":false,"paid_amount":"1300","tax_amount":"149.56","excluding_tax":"1150.44","verify_at":"2025-03-31 00:00:00","is_used":true,"updated_at":"2025-03-07 09:45:58","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":678,"is_contract_cancel":false}],"inventory":0}]}],"spent_amount":0,"spent_number":0,"spent_excluding_tax":0,"spent_tax_amount":0,"ready_match":false,"can_update":false,"can_delete":false,"settle_month":"03\u6708","can_match":false,"can_cancel_match":true,"can_simple_match":true,"can_need_match":false,"can_cancel":true,"can_red_cancel":true,"can_new_invoice":false,"title":"\u65b0\u5f00\u53d1\u7968"},{"id":1978,"contract_id":3811,"from_date":"2025-03-14","attachment_id":"","amount":3150,"created_by":5252,"created_at":"2025-03-14 10:19:30","description":"","invoice_num":"25112000000049433908","invoice_type":-1,"is_match":false,"is_cancel":false,"is_used":false,"cancel_description":"","cover_invoice_id":1979,"red_invoice_id":"","new_invoice_id":1979,"need_new_invoice":true,"tax_amount":362.39,"excluding_tax":2787.61,"is_draft":false,"updated_at":"2025-03-14 10:19:30","need_match":false,"need_match_description":"","match_tax_amount":"0","simple_match_tax_amount":"0","is_settle":true,"is_contract_cancel":false,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"attachmentRelationships":[],"files":[{"id":32884,"object_type":102,"object_id":1978,"attachment_id":24541,"attachment":{"id":24541,"key":24541,"name":"38801acf-9469-312a-8a19-cb4c57246891","extension":"pdf","path":"\/vue\/attachment\/view\/38801acf-9469-312a-8a19-cb4c57246891\/dzfp_25112000000049433908_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250314101729.pdf","orig_name":"dzfp_25112000000049433908_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250314101729.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":536,"sales_invoice_id":1978,"title":"1.8T","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u786c\u76d8","number":"1","outbound":"0","unit":"\u4e2a","amount":"-3150","tax_rate":"13","including_tax":"0","excluding_tax":"-2787.61","tax_amount":"-362.39","need_match":false,"inventory_count":"","spents":[],"matchPurchaseInvoice":[],"inventory":0}],"contract":{"id":3811,"key":3811,"serial_no":"TS-SQY-20250305001","client_id":531,"project_id":3791,"client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587"}},"project":{"id":3791,"key":3791,"name":"\u786c\u76d81.8T1\u5757-K-2025"}},"cancelInvoice":{"id":1971,"contract_id":3811,"from_date":"2025-03-07","attachment_id":"","amount":"3150.00","created_by":5252,"created_at":"2025-03-07 09:50:20","description":"","invoice_num":"25112000000045420958","invoice_type":1,"is_match":false,"is_cancel":true,"is_used":false,"cancel_description":"","cover_invoice_id":1979,"red_invoice_id":1978,"new_invoice_id":"","need_new_invoice":false,"tax_amount":"362.39","excluding_tax":"2787.61","is_draft":false,"updated_at":"2025-03-07 09:50:56","need_match":true,"need_match_description":"","match_tax_amount":"0","simple_match_tax_amount":"0","is_settle":true,"is_contract_cancel":false,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"attachment":{},"attachmentRelationships":[],"files":[{"id":32726,"object_type":102,"object_id":1971,"attachment_id":24432,"attachment":{"id":24432,"key":24432,"name":"dff9deda-3114-397c-95f4-432d3284169a","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2025\/03\/","orig_name":"dzfp_25112000000045420958_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250307094835.pdf"}}],"contract":{"id":3811,"key":3811,"serial_no":"TS-SQY-20250305001","client_id":531,"client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)"}},"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":522,"sales_invoice_id":1971,"title":"1.8T","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u786c\u76d8","number":"1","outbound":"0","unit":"\u4e2a","amount":"3150","tax_rate":"13","including_tax":"0","excluding_tax":"2787.61","tax_amount":"362.39","need_match":true,"inventory_count":""}]},"redInvoice":{},"spents":[],"invoice_type_display":"\u7ea2\u5b57\u53d1\u7968","including_tax":0,"number":1,"tax_rate":["13"],"un_match_tax_amount":-362.39,"except_simple_match_tax_amount":-362.39,"salesInvoiceProductList":[{"tax_rate":13,"amount":-3150,"excluding_tax":-2787.61,"tax_amount":-362.39,"list":[{"id":536,"sales_invoice_id":1978,"title":"1.8T","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u786c\u76d8","number":"1","outbound":"0","unit":"\u4e2a","amount":"-3150","tax_rate":"13","including_tax":"0","excluding_tax":"-2787.61","tax_amount":"-362.39","need_match":false,"inventory_count":"","spents":[],"matchPurchaseInvoice":[],"inventory":0}]}],"spent_amount":0,"spent_number":0,"spent_excluding_tax":0,"spent_tax_amount":0,"ready_match":false,"can_update":false,"can_delete":false,"settle_month":"03\u6708","can_match":false,"can_cancel_match":false,"can_simple_match":false,"can_need_match":false,"can_cancel":false,"can_red_cancel":false,"can_new_invoice":false,"title":"\u7ea2\u5b57\u53d1\u7968:25112000000049433908"},{"id":1971,"contract_id":3811,"from_date":"2025-03-07","attachment_id":"","amount":"3150.00","created_by":5252,"created_at":"2025-03-07 09:50:20","description":"","invoice_num":"25112000000045420958","invoice_type":1,"is_match":false,"is_cancel":true,"is_used":false,"cancel_description":"","cover_invoice_id":1979,"red_invoice_id":1978,"new_invoice_id":"","need_new_invoice":false,"tax_amount":"362.39","excluding_tax":"2787.61","is_draft":false,"updated_at":"2025-03-07 09:50:56","need_match":true,"need_match_description":"","match_tax_amount":"0","simple_match_tax_amount":"0","is_settle":true,"is_contract_cancel":false,"createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"attachmentRelationships":[],"files":[{"id":32726,"object_type":102,"object_id":1971,"attachment_id":24432,"attachment":{"id":24432,"key":24432,"name":"dff9deda-3114-397c-95f4-432d3284169a","extension":"pdf","path":"\/vue\/attachment\/view\/dff9deda-3114-397c-95f4-432d3284169a\/dzfp_25112000000045420958_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250307094835.pdf","orig_name":"dzfp_25112000000045420958_\u5317\u4eac\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8_20250307094835.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":522,"sales_invoice_id":1971,"title":"1.8T","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u786c\u76d8","number":"1","outbound":"0","unit":"\u4e2a","amount":"3150","tax_rate":"13","including_tax":"0","excluding_tax":"2787.61","tax_amount":"362.39","need_match":true,"inventory_count":"","spents":[],"matchPurchaseInvoice":[],"inventory":0}],"contract":{"id":3811,"key":3811,"serial_no":"TS-SQY-20250305001","client_id":531,"project_id":3791,"client":{"id":531,"key":531,"name":"\u5317\u4eac\u9996\u4e1c\u7269\u4e1a\u7ba1\u7406\u6709\u9650\u516c\u53f8(\u9996\u4e1c\u56fd\u9645\u6295\u8d44\u6709\u9650\u516c\u53f8)","sales_rep":5311,"salesRep":{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587"}},"project":{"id":3791,"key":3791,"name":"\u786c\u76d81.8T1\u5757-K-2025"}},"cancelInvoice":{},"redInvoice":{},"spents":[],"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":1,"tax_rate":["13"],"un_match_tax_amount":362.39,"except_simple_match_tax_amount":362.39,"salesInvoiceProductList":[{"tax_rate":13,"amount":3150,"excluding_tax":2787.61,"tax_amount":362.39,"list":[{"id":522,"sales_invoice_id":1971,"title":"1.8T","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u786c\u76d8","number":"1","outbound":"0","unit":"\u4e2a","amount":"3150","tax_rate":"13","including_tax":"0","excluding_tax":"2787.61","tax_amount":"362.39","need_match":true,"inventory_count":"","spents":[],"matchPurchaseInvoice":[],"inventory":0}]}],"spent_amount":0,"spent_number":0,"spent_excluding_tax":0,"spent_tax_amount":0,"ready_match":false,"can_update":false,"can_delete":false,"settle_month":"03\u6708","can_match":true,"can_cancel_match":false,"can_simple_match":false,"can_need_match":true,"can_cancel":false,"can_red_cancel":false,"can_new_invoice":false,"title":"\u88ab\u7ea2\u51b2\u84dd\u5b57\u6570\u7535\u7968\u53f7\u7801:25112000000045420958"}],"is_new":true,"invoice_type_display":"\u6570\u7535\u666e\u7968","including_tax":0,"number":1,"tax_rate":["13"],"un_match_tax_amount":212.83,"except_simple_match_tax_amount":212.83,"salesInvoiceProductList":[{"tax_rate":13,"amount":3150,"excluding_tax":2787.61,"tax_amount":362.39,"list":[{"id":537,"sales_invoice_id":1979,"title":"1.8T","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u786c\u76d8","number":"1","outbound":"1","unit":"\u4e2a","amount":"3150","tax_rate":"13","including_tax":"0","excluding_tax":"2787.61","tax_amount":"362.39","need_match":true,"inventory_count":"","spents":[{"id":1047,"sales_product_id":537,"build_group_id":"","inventory_product_id":1336,"outbound":"1","number":"0","sales_invoice_id":"","inventoryProduct":{"id":1336,"purchase_invoice_id":2159,"purchase_product_id":1333,"title":"1.8T","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u786c\u76d8","number":"1","unit":"\u5757","outbound":"1","inventory":"0","amount":"1300","tax_rate":"13","including_tax":"0","excluding_tax":"1150.44","tax_amount":"149.56","is_build":false,"build_group_id":"","created_at":"2025-03-07 09:45:58","purchaseInvoice":{"id":2159,"contract_id":3814,"amount":"1300","attachment_id":"","from_date":"2025-03-07","created_by":5360,"created_at":"2025-03-07 09:44:46","description":"","invoice_num":"25112000000045378206","invoice_type":1,"handler":5360,"is_verify":true,"is_cancel":false,"paid_amount":"1300","tax_amount":"149.56","excluding_tax":"1150.44","verify_at":"2025-03-31 00:00:00","is_used":true,"updated_at":"2025-03-07 09:45:58","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":678,"is_contract_cancel":false},"buildGroup":{}}}],"matchPurchaseInvoice":[{"id":2159,"contract_id":3814,"amount":"1300","attachment_id":"","from_date":"2025-03-07","created_by":5360,"created_at":"2025-03-07 09:44:46","description":"","invoice_num":"25112000000045378206","invoice_type":1,"handler":5360,"is_verify":true,"is_cancel":false,"paid_amount":"1300","tax_amount":"149.56","excluding_tax":"1150.44","verify_at":"2025-03-31 00:00:00","is_used":true,"updated_at":"2025-03-07 09:45:58","cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"is_draft":false,"is_settle":true,"supplier_id":678,"is_contract_cancel":false}],"inventory":0}]}],"spent_amount":0,"spent_number":0,"spent_excluding_tax":0,"spent_tax_amount":0,"ready_match":false,"can_update":false,"can_delete":false,"settle_month":"03\u6708","can_match":false,"can_cancel_match":true,"can_simple_match":true,"can_need_match":false,"can_cancel":true,"can_red_cancel":true,"can_new_invoice":false},"id":"1979","index":1,"count":2,"options":{"SalesContractInvoices[invoice_type]":{"key":"SalesContractInvoices[invoice_type]","name":"\u53d1\u7968\u7c7b\u578b","value":[{"id":1,"key":1,"name":"\u6570\u7535\u4e13\u7968"},{"id":2,"key":2,"name":"\u6570\u7535\u666e\u7968"},{"id":3,"key":3,"name":"\u7eb8\u8d28\u4e13\u7528\u53d1\u7968"},{"id":4,"key":4,"name":"\u7eb8\u8d28\u666e\u901a\u53d1\u7968"}],"default":""},"SalesContractInvoices[salesInvoiceReminders]":{"search":"1","key":"SalesContractInvoices[salesInvoiceReminders]","name":"\u63d0\u9192\u4eba","value":[{"id":4,"key":4,"name":"\u603b\u7ecf\u7406","child":[{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","department_id":4,"pinyin_shortcut":"lrc","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}]},{"id":1,"key":1,"name":"\u9500\u552e\u90e8","child":[{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","department_id":1,"pinyin_shortcut":"hwc","avatar":{"id":148,"user_id":5332,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3a3eda91-ddc9-3633-8071-70a4c3d7180c.png"}},{"id":5087,"key":5087,"name":"\u5218\u5fae","department_id":1,"pinyin_shortcut":"lw","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","department_id":1,"pinyin_shortcut":"sqy","avatar":{"id":141,"user_id":5300,"name":"\/files\/cdn\/a57be577deb434\/avatar\/14dfd1a0-6df5-354a-8afd-f0a76fa8e852.png"}},{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","department_id":1,"pinyin_shortcut":"wzw","avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","department_id":1,"pinyin_shortcut":"yjc","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","department_id":1,"pinyin_shortcut":"zhy","avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},{"id":5449,"key":5449,"name":"\u5468\u4e3d\u98de","department_id":1,"pinyin_shortcut":"zlf","avatar":{}}]},{"id":2,"key":2,"name":"\u6280\u672f\u90e8","child":[{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","department_id":2,"pinyin_shortcut":"cmf","avatar":{"id":8,"user_id":1017,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e538f0fe-48a7-33da-a512-b252266c9e91.jpg"}},{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","department_id":2,"pinyin_shortcut":"hdy","avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/3b53061b-3148-3c6a-a16d-763f381ad1b6.jpg"}},{"id":5311,"key":5311,"name":"\u62d3\u5c0f\u6587","department_id":2,"pinyin_shortcut":"txw","avatar":{"id":149,"user_id":5311,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1a32eee2-9465-3c88-9077-5c6d1cc5e8b3.jpg"}},{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99","department_id":2,"pinyin_shortcut":"wjl","avatar":{"id":135,"user_id":5248,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b4458545-7f88-3479-97be-6f43b2b50454.png"}},{"id":1015,"key":1015,"name":"\u5434\u660a","department_id":2,"pinyin_shortcut":"wh","avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"}},{"id":1022,"key":1022,"name":"\u5f90\u7855","department_id":2,"pinyin_shortcut":"xs","avatar":{"id":6,"user_id":1022,"name":"\/files\/cdn\/a57be577deb434\/avatar\/2b5ec94d-d83c-38b4-ac3a-38720c369f91.png"}},{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","department_id":2,"pinyin_shortcut":"zzj","avatar":{"id":4,"user_id":1023,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1023.jpg"}}]},{"id":3,"key":3,"name":"\u5546\u52a1\u90e8","child":[{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","department_id":3,"pinyin_shortcut":"hyf","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","department_id":3,"pinyin_shortcut":"zhf","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}]},{"id":9,"key":9,"name":"\u9879\u76ee\u90e8","child":[]},{"id":8,"key":8,"name":"\u4eba\u529b\u8d44\u6e90","child":[{"id":5446,"key":5446,"name":"\u5218\u5a1f","department_id":8,"pinyin_shortcut":"lj","avatar":{"id":164,"user_id":5446,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5631bbfb-fa6e-308e-b87c-b159e8042209.jpg"}}]},{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8","child":[{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","department_id":6,"pinyin_shortcut":"wxx","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","department_id":6,"pinyin_shortcut":"yyx","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}]},{"id":7,"key":7,"name":"\u5e93\u623f\u90e8","child":[{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","department_id":7,"pinyin_shortcut":"wjc","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}]},{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1","child":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","department_id":10,"pinyin_shortcut":"cys","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"}},{"id":5250,"key":5250,"name":"\u8463\u8363","department_id":10,"pinyin_shortcut":"dr","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}},{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","department_id":10,"pinyin_shortcut":"gjy","avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}},{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf","department_id":10,"pinyin_shortcut":"yxc","avatar":{"id":38,"user_id":5064,"name":"\/files\/cdn\/a57be577deb434\/avatar\/5bec09dc-1f7a-3542-89a2-cedfefb3fded.png"}}]}]}},"disableMonth":["2024-08","2024-09","2024-10","2024-07","2024-11","2024-12","2025-01","2025-02","2025-03","2025-04","2025-05","2025-06"]},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-19 16:32:17') RETURNING "id"
16:32:17.5432.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (1978, 1971))
16:32:17.5402.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (1978, 1971))
16:32:17.5452.0 msyii\db\Command::querySELECT "sip".*, sum(inventory) as inventory_count FROM "a57be577deb434"."tbl_sales_invoice_products" "sip" LEFT JOIN "a57be577deb434"."tbl_inventory_products" "ip" ON lower(ip.title) = lower(sip.title) AND lower(ip.description) = lower(sip.description) WHERE "sip"."sales_invoice_id" IN (1978, 1971) GROUP BY "sip"."id"
16:32:17.5551.9 msyii\db\Command::querySELECT "sip".*, sum(inventory) as inventory_count FROM "a57be577deb434"."tbl_sales_invoice_products" "sip" LEFT JOIN "a57be577deb434"."tbl_inventory_products" "ip" ON lower(ip.title) = lower(sip.title) AND lower(ip.description) = lower(sip.description) WHERE "sip"."sales_invoice_id"=1971 GROUP BY "sip"."id"
16:32:17.5271.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id"=1979)
16:32:17.5111.8 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:32:17.5291.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id"=1979)
16:32:17.5231.7 msyii\db\Command::querySELECT sub.* FROM (SELECT ROW_NUMBER() OVER (ORDER BY sub.from_date DESC nulls last, sub.created_at DESC nulls last) as idx, sub.* FROM (SELECT sci.* FROM "a57be577deb434"."tbl_sales_contract_invoices" "sci" LEFT JOIN "a57be577deb434"."tbl_sales_contracts" "sc" ON sc.id = sci.contract_id LEFT JOIN "a57be577deb434"."tbl_projects" "p" ON p.id = sc.from_project LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id WHERE (sci.cover_invoice_id is null) AND (("sci"."invoice_type"='2')) GROUP BY "sci"."id") "sub") "sub" WHERE "id"='1979'
16:32:17.5511.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id"=1971)
16:32:17.5521.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id"=1971)
16:32:17.5161.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:32:17.5680.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=69, "last_visit_at"='now()' WHERE "id"=55336
16:32:17.5620.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "department_id", "pinyin_shortcut" FROM "a57be577deb434"."tbl_users" WHERE ("user_status"='1') AND ("department_id" IN (4, 1, 2, 3, 9, 8, 6, 7, 10)) 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
16:32:17.5350.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "id"=2159
16:32:17.5260.7 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5252)
16:32:17.5390.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "cover_invoice_id"=1979 ORDER BY "id" DESC
16:32:17.5380.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "new_invoice_id"=1979
16:32:17.5380.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "red_invoice_id"=1979
16:32:17.5570.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "new_invoice_id" IN (1978, 1971)
16:32:17.5490.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "red_invoice_id" IN (1978, 1971)
16:32:17.5580.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-03-01') AND ("is_settle"=TRUE)
16:32:17.5310.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=24542
16:32:17.5340.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_product_id"=537
16:32:17.5350.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_inventory_products" WHERE "id"=1336
16:32:17.5610.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" ORDER BY "order"
16:32:17.5260.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=6
16:32:17.5580.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_invoice_id" IN (1978, 1971)
16:32:17.5240.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "id"='1979'
16:32:17.5250.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5252
16:32:17.5480.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_product_id" IN (522, 536)
16:32:17.5370.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=531
16:32:17.5630.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1000, 1017, 5250, 5016, 1011, 5085, 5332, 5446, 1001, 5087, 5300, 5311, 5252, 5295, 5248, 1013, 1015, 1022, 5388, 5064, 1004, 5360, 1005, 5449, 1023))
16:32:17.5360.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_invoice_id"=1979
16:32:17.5310.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_invoice_reminders" WHERE "sales_invoice_id"=1979
16:32:17.5450.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (24432, 24541)
16:32:17.5400.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5252)
16:32:17.5370.2 msyii\db\Command::querySELECT "id", "id" AS "key", "serial_no", "client_id", "project_id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=3811
16:32:17.5380.2 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id"=3791
16:32:17.5480.2 msyii\db\Command::querySELECT "id", "id" AS "key", "serial_no", "client_id", "project_id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=3811
16:32:17.5500.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5252)
16:32:17.5600.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-03-01') AND ("is_settle"=TRUE)
16:32:17.5480.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id"=531
16:32:17.5500.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5252
16:32:17.5400.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5252
16:32:17.5490.2 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id"=3791
16:32:17.5370.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5311
16:32:17.5550.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=531
16:32:17.5490.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5311
16:32:17.5540.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=24432
16:32:17.5540.2 msyii\db\Command::querySELECT "id", "id" AS "key", "serial_no", "client_id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=3811
16:32:17.5610.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-03-01') AND ("is_settle"=TRUE)
16:32:17.5610.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-03-01') AND ("is_settle"=TRUE)
16:32:17.5630.2 msyii\db\Command::querySELECT "date" FROM "a57be577deb434"."tbl_tax_datas" WHERE is_settle = true
16:32:17.5550.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_invoice_reminders" WHERE "sales_invoice_id"=1971
16:32:17.5400.1 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=6
16:32:17.5500.1 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=6
16:32:17.5450.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_invoice_reminders" WHERE "sales_invoice_id" IN (1978, 1971)