ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c90dbed772d: POST https://beta.jinchangxiao.com/vue/tax/sales-invoice-list at 2025-09-16 03:11:58 pm by 114.244.128.96

Log Messages

总计109条数据
TimeLevelCategoryMessage
 
15:11:58.880traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
15:11:58.880traceyii\base\Module::getModuleLoading module: debug
15:11:58.880traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
15:11:58.882traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
15:11:58.882traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
15:11:58.884traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:11:58.886traceyii\base\Module::getModuleLoading module: gii
15:11:58.886traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
15:11:58.886traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
15:11:58.886traceyii\web\Application::handleRequestRoute requested: 'vue/tax/sales-invoice-list'
15:11:58.886traceyii\base\Module::getModuleLoading module: vue
15:11:58.907infoyii\web\Session::openSession started
15:11:58.907infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1011
15:11:58.907infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:11:58.916traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:11:58.918traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:11:58.919traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:11:58.919traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:11:58.919infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
15:11:58.922traceyii\base\Controller::runActionRoute to run: vue/tax/sales-invoice-list
15:11:58.922traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:11:58.925traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:11:58.925traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewTaxManagement
15:11:58.925traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
15:11:58.925traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
15:11:58.925traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: CommercialAttache
15:11:58.925traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\TaxController::actionSalesInvoiceList()
15:11:58.926traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:11:58.926infoyii\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_sales_contract_invoices' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
15:11:58.931infoyii\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_sales_contract_invoices' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
15:11:58.936traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:11:58.936traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
15:11:58.937traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'group' in 'app\models\search\SalesContractInvoiceSearch'.
15:11:58.937traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'created_by' in 'app\models\search\SalesContractInvoiceSearch'.
15:11:58.937traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:11:58.937traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:11:58.938infoyii\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"."from_date" >= '2024-08-01 00:00') OR ("sci"."is_draft"=FALSE)) GROUP BY "sci"."id" ORDER BY sci.from_date DESC nulls last, sci.created_at DESC nulls last) "c"
15:11:58.941infoyii\db\Command::querySELECT 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"."from_date" >= '2024-08-01 00:00') OR ("sci"."is_draft"=FALSE)) GROUP BY "sci"."id" ORDER BY sci.from_date DESC nulls last, sci.created_at DESC nulls last LIMIT 20
15:11:58.945infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5252)
15:11:58.945infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5252, 1000))
15:11:58.946infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (6, 10)
15:11:58.946infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id" IN (2139, 2138, 2137, 2136, 2135, 2134, 2133, 2132, 2131, 2130, 2129, 2128, 2127, 2125, 2124, 2122, 2121, 2120, 2119, 2118))
15:11:58.949infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28108
15:11:58.949infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id" IN (2139, 2138, 2137, 2136, 2135, 2134, 2133, 2132, 2131, 2130, 2129, 2128, 2127, 2125, 2124, 2122, 2121, 2120, 2119, 2118))
15:11:58.951infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (27447, 27595, 27596, 27665, 27669, 27746, 27747, 27752, 27754, 27755, 27756, 27784, 27804, 27805, 27806, 27807, 27808, 27893, 27900, 28107)
15:11:58.952infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_invoice_reminders" WHERE "sales_invoice_id" IN (2139, 2138, 2137, 2136, 2135, 2134, 2133, 2132, 2131, 2130, 2129, 2128, 2127, 2125, 2124, 2122, 2121, 2120, 2119, 2118)
15:11:58.953infoyii\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 (2139, 2138, 2137, 2136, 2135, 2134, 2133, 2132, 2131, 2130, 2129, 2128, 2127, 2125, 2124, 2122, 2121, 2120, 2119, 2118) GROUP BY "sip"."id"
15:11:58.967traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:11:58.967infoyii\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_sales_invoice_products' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
15:11:58.971infoyii\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_sales_invoice_products' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
15:11:58.977traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:11:58.977traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
15:11:58.977infoyii\db\Command::querySELECT "id", "id" AS "key", "serial_no", "client_id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id" IN (4139, 4129, 4112, 4044, 4094, 4047, 4046, 4048, 4106, 4055, 4099, 2653, 4026, 4083, 4082, 4086)
15:11:58.979infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2182, 3378, 12, 2845, 3366, 3286, 2032, 189, 2553, 2125)
15:11:58.979infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 1001, 1004, 5295, 5087)
15:11:58.979infoyii\db\Command::querySELECT "id", "cover_invoice_id" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "cover_invoice_id" IN (2139, 2138, 2137, 2136, 2135, 2134, 2133, 2132, 2131, 2130, 2129, 2128, 2127, 2125, 2124, 2122, 2121, 2120, 2119, 2118) ORDER BY "id" DESC
15:11:58.980infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "red_invoice_id" IN (2139, 2138, 2137, 2136, 2135, 2134, 2133, 2132, 2131, 2130, 2129, 2128, 2127, 2125, 2124, 2122, 2121, 2120, 2119, 2118)
15:11:58.981infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5252
15:11:58.981infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5252)
15:11:58.981infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=6
15:11:58.981infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id"=2123)
15:11:58.983infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id"=2123)
15:11:58.985infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=27677
15:11:58.985infoyii\db\Command::querySELECT "id", "id" AS "key", "serial_no", "client_id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4055
15:11:58.986infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2553
15:11:58.986infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_invoice_reminders" WHERE "sales_invoice_id"=2123
15:11:58.986infoyii\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"=2123 GROUP BY "sip"."id"
15:11:58.988infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "new_invoice_id" IN (2139, 2138, 2137, 2136, 2135, 2134, 2133, 2132, 2131, 2130, 2129, 2128, 2127, 2125, 2124, 2122, 2121, 2120, 2119, 2118)
15:11:58.989traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: createSalesContract
15:11:58.989traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
15:11:58.989traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: ProjectManager
15:11:58.989traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: 电话销售
15:11:58.989traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: GM
15:11:58.989traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: CommercialAttache
15:11:58.989infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-09-01') AND ("is_settle"=TRUE)
15:11:58.990infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-08-01') AND ("is_settle"=TRUE)
15:11:58.990infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-08-01') AND ("is_settle"=TRUE)
15:11:58.990infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-08-01') AND ("is_settle"=TRUE)
15:11:58.991infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-08-01') AND ("is_settle"=TRUE)
15:11:58.991infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-08-01') AND ("is_settle"=TRUE)
15:11:58.991infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-08-01') AND ("is_settle"=TRUE)
15:11:58.991infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-08-01') AND ("is_settle"=TRUE)
15:11:58.992infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-08-01') AND ("is_settle"=TRUE)
15:11:58.992infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-08-01') AND ("is_settle"=TRUE)
15:11:58.992infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-08-01') AND ("is_settle"=TRUE)
15:11:58.992infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-08-01') AND ("is_settle"=TRUE)
15:11:58.993infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-08-01') AND ("is_settle"=TRUE)
15:11:58.993infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-08-01') AND ("is_settle"=TRUE)
15:11:58.993infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-08-01') AND ("is_settle"=TRUE)
15:11:58.993infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-08-01') AND ("is_settle"=TRUE)
15:11:58.994infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-08-01') AND ("is_settle"=TRUE)
15:11:58.994infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-08-01') AND ("is_settle"=TRUE)
15:11:58.994infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-08-01') AND ("is_settle"=TRUE)
15:11:58.994infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_tax_datas" WHERE ("date"='2025-08-01') AND ("is_settle"=TRUE)
15:11:58.995traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'group' in 'app\models\search\SalesContractInvoiceSearch'.
15:11:58.995traceyii\base\Model::onUnsafeAttributeFailed to set unsafe attribute 'created_by' in 'app\models\search\SalesContractInvoiceSearch'.
15:11:58.995infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "id" IN (SELECT "sci"."id" 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"."from_date" >= '2024-08-01 00:00') OR ("sci"."is_draft"=FALSE) GROUP BY "sci"."id")
15:11:58.996infoyii\db\Command::querySELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "id" IN (SELECT "sci"."id" 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"."from_date" >= '2024-08-01 00:00') OR ("sci"."is_draft"=FALSE) GROUP BY "sci"."id")
15:11:58.998infoyii\db\Command::querySELECT SUM(excluding_tax) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "id" IN (SELECT "sci"."id" 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"."from_date" >= '2024-08-01 00:00') OR ("sci"."is_draft"=FALSE) GROUP BY "sci"."id")
15:11:58.999infoyii\db\Command::querySELECT SUM(tax_amount) FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "id" IN (SELECT "sci"."id" 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"."from_date" >= '2024-08-01 00:00') OR ("sci"."is_draft"=FALSE) GROUP BY "sci"."id")
15:11:59.002traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:11:59.002traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:11:59.002infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1011) AND ("object_type"=10004) AND ("visit_date"='2025-09-16')
15:11:59.006traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:11:59.006traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
15:11:59.006infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=4, "last_visit_at"='now()' WHERE "id"=56602
15:11:59.008infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1011, 5, 'vue/tax/sales-invoice-list', '{"Filter":{"name":"from_date","sort":"DESC"},"SalesContractInvoiceSearch":{"from_date_period":"","created_at_period":"","group":"","created_by":"","is_cancel":"","is_match":"","is_draft":"","is_contract_cancel":""},"page":"1","web_access_token":"18_8RvXePAHKXb4kC8IN2O6XIdrtwTnd"}', '{"code":2000,"result":{"list":[{"id":2139,"contract_id":4139,"from_date":"2025-09-10","attachment_id":"","amount":"580000.00","created_by":1000,"created_at":"2025-09-11 11:03:06","description":"","invoice_num":"","invoice_type":"","is_match":false,"is_cancel":false,"is_used":false,"cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"tax_amount":"","excluding_tax":"","is_draft":true,"updated_at":"","need_match":false,"need_match_description":"","match_tax_amount":"","simple_match_tax_amount":"","is_settle":false,"is_contract_cancel":false,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"attachmentRelationships":[{"id":49501,"object_type":20,"object_id":2139,"attachment_id":28108,"attachment":{"id":28108,"key":28108,"name":"f802b978-d620-3548-97d9-1a01430ab752","extension":"jpg","path":"\/vue\/attachment\/view\/f802b978-d620-3548-97d9-1a01430ab752\/WechatIMG54800.jpg","orig_name":"WechatIMG54800.jpg"}}],"files":[{"id":49502,"object_type":102,"object_id":2139,"attachment_id":28107,"attachment":{"id":28107,"key":28107,"name":"cd70e8b1-6cb2-3336-8a13-c588b7abe5d6","extension":"pdf","path":"\/vue\/attachment\/view\/cd70e8b1-6cb2-3336-8a13-c588b7abe5d6\/InvSqrt.pdf","orig_name":"InvSqrt.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[],"contract":{"id":4139,"key":4139,"serial_no":"2025-09-10-005","client_id":2125,"client":{"id":2125,"key":2125,"name":"\u5317\u4eac\u822a\u661f\u673a\u5668\u5236\u9020\u6709\u9650\u516c\u53f8239\u5382","sales_rep":5087,"salesRep":{"id":5087,"key":5087,"name":"\u5218\u5fae"}}},"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"","including_tax":0,"number":0,"tax_rate":[],"un_match_tax_amount":0,"except_simple_match_tax_amount":0,"salesInvoiceProductList":[],"ready_match":true,"can_update":true,"can_delete":true,"settle_month":"","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,"is_new":false},{"id":2138,"contract_id":4129,"from_date":"2025-08-28","attachment_id":"","amount":"1360.00","created_by":5252,"created_at":"2025-08-28 16:23:43","description":"","invoice_num":"25112000000181904050","invoice_type":1,"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":"156.46","excluding_tax":"1203.54","is_draft":false,"updated_at":"2025-08-28 16:24:20","need_match":true,"need_match_description":"","match_tax_amount":"237.68","simple_match_tax_amount":"0","is_settle":false,"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":49204,"object_type":102,"object_id":2138,"attachment_id":27900,"attachment":{"id":27900,"key":27900,"name":"723bed8f-aa0b-3ff8-b0d3-8efaf589ce84","extension":"pdf","path":"\/vue\/attachment\/view\/723bed8f-aa0b-3ff8-b0d3-8efaf589ce84\/dzfp_25112000000181904050_\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8_20250828162258.pdf","orig_name":"dzfp_25112000000181904050_\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8_20250828162258.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":892,"sales_invoice_id":2138,"title":"EWP-WA6522H-LI-FIT","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u65e0\u7ebf","number":"2","outbound":"2","unit":"\u53f0","amount":"1360","tax_rate":"13","including_tax":"0","excluding_tax":"1203.54","tax_amount":"156.46","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0}],"contract":{"id":4129,"key":4129,"serial_no":"TS-SQY-2025082701","client_id":2182,"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}}},"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":2,"tax_rate":["13"],"un_match_tax_amount":-81.22,"except_simple_match_tax_amount":-81.22,"salesInvoiceProductList":[{"tax_rate":13,"amount":1360,"excluding_tax":1203.54,"tax_amount":156.46,"list":[{"id":892,"sales_invoice_id":2138,"title":"EWP-WA6522H-LI-FIT","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u65e0\u7ebf","number":"2","outbound":"2","unit":"\u53f0","amount":"1360","tax_rate":"13","including_tax":"0","excluding_tax":"1203.54","tax_amount":"156.46","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0}]}],"ready_match":false,"can_update":true,"can_delete":true,"settle_month":"","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,"is_new":false},{"id":2137,"contract_id":4112,"from_date":"2025-08-28","attachment_id":"","amount":"21224.00","created_by":5252,"created_at":"2025-08-28 13:49:33","description":"","invoice_num":"25112000000181616655","invoice_type":1,"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":"2441.7","excluding_tax":"18782.3","is_draft":false,"updated_at":"2025-08-28 13:50:43","need_match":true,"need_match_description":"","match_tax_amount":"2243.59","simple_match_tax_amount":"0","is_settle":false,"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":49194,"object_type":102,"object_id":2137,"attachment_id":27893,"attachment":{"id":27893,"key":27893,"name":"e95e6e4a-463b-345f-82f2-772550058cff","extension":"pdf","path":"\/vue\/attachment\/view\/e95e6e4a-463b-345f-82f2-772550058cff\/dzfp_25112000000181616655_\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8_20250828134825.pdf","orig_name":"dzfp_25112000000181616655_\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8_20250828134825.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":891,"sales_invoice_id":2137,"title":"PAN-SOFTWARE-NGFW-CR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"14","outbound":"14","unit":"\u4e2a","amount":"21224","tax_rate":"13","including_tax":"0","excluding_tax":"18782.3","tax_amount":"2441.7","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0}],"contract":{"id":4112,"key":4112,"serial_no":"PO2500925\/PO2500926","client_id":3286,"client":{"id":3286,"key":3286,"name":"\u826f\u56fe\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}},"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":14,"tax_rate":["13"],"un_match_tax_amount":198.11,"except_simple_match_tax_amount":198.11,"salesInvoiceProductList":[{"tax_rate":13,"amount":21224,"excluding_tax":18782.3,"tax_amount":2441.7,"list":[{"id":891,"sales_invoice_id":2137,"title":"PAN-SOFTWARE-NGFW-CR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"14","outbound":"14","unit":"\u4e2a","amount":"21224","tax_rate":"13","including_tax":"0","excluding_tax":"18782.3","tax_amount":"2441.7","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0}]}],"ready_match":false,"can_update":true,"can_delete":true,"settle_month":"","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,"is_new":false},{"id":2136,"contract_id":4044,"from_date":"2025-08-25","attachment_id":"","amount":"50000.00","created_by":5252,"created_at":"2025-08-25 15:55:02","description":"","invoice_num":"25112000000178956802","invoice_type":1,"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":"2830.19","excluding_tax":"47169.81","is_draft":false,"updated_at":"2025-08-25 15:56:05","need_match":true,"need_match_description":"","match_tax_amount":"558.39","simple_match_tax_amount":"371.6","is_settle":false,"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":48890,"object_type":102,"object_id":2136,"attachment_id":27808,"attachment":{"id":27808,"key":27808,"name":"fda98940-e733-3651-a2e8-76bfe918abb9","extension":"pdf","path":"\/vue\/attachment\/view\/fda98940-e733-3651-a2e8-76bfe918abb9\/dzfp_25112000000178956802_\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8_20250825155401.pdf","orig_name":"dzfp_25112000000178956802_\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8_20250825155401.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":890,"sales_invoice_id":2136,"title":"","description":"*\u4fe1\u606f\u7cfb\u7edf\u670d\u52a1*\u6280\u672f\u670d\u52a1\u8d39","number":"1","outbound":"1","unit":"","amount":"50000","tax_rate":"6","including_tax":"0","excluding_tax":"47169.81","tax_amount":"2830.19","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0}],"contract":{"id":4044,"key":4044,"serial_no":"PO-2025-07-0006","client_id":2182,"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}}},"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":1,"tax_rate":["6"],"un_match_tax_amount":2271.8,"except_simple_match_tax_amount":2643.4,"salesInvoiceProductList":[{"tax_rate":6,"amount":50000,"excluding_tax":47169.81,"tax_amount":2830.19,"list":[{"id":890,"sales_invoice_id":2136,"title":"","description":"*\u4fe1\u606f\u7cfb\u7edf\u670d\u52a1*\u6280\u672f\u670d\u52a1\u8d39","number":"1","outbound":"1","unit":"","amount":"50000","tax_rate":"6","including_tax":"0","excluding_tax":"47169.81","tax_amount":"2830.19","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0}]}],"ready_match":false,"can_update":true,"can_delete":true,"settle_month":"","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,"is_new":false},{"id":2135,"contract_id":4094,"from_date":"2025-08-25","attachment_id":"","amount":"17500.00","created_by":5252,"created_at":"2025-08-25 15:52:05","description":"","invoice_num":"25112000000178945755","invoice_type":1,"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":"2013.26","excluding_tax":"15486.74","is_draft":false,"updated_at":"2025-08-25 15:52:55","need_match":true,"need_match_description":"","match_tax_amount":"1326.24","simple_match_tax_amount":"0","is_settle":false,"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":48888,"object_type":102,"object_id":2135,"attachment_id":27807,"attachment":{"id":27807,"key":27807,"name":"336c5762-27ff-352d-9a2a-7cb31130d8dc","extension":"pdf","path":"\/vue\/attachment\/view\/336c5762-27ff-352d-9a2a-7cb31130d8dc\/dzfp_25112000000178945755_\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8_20250825155031.pdf","orig_name":"dzfp_25112000000178945755_\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8_20250825155031.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":886,"sales_invoice_id":2135,"title":"PAN-SVC-BKLN-440-R","description":"*\u8f6f\u4ef6*PaloAlto\u8f6f\u4ef6","number":"1","outbound":"1","unit":"\u5957","amount":"3034","tax_rate":"13","including_tax":"0","excluding_tax":"2684.96","tax_amount":"349.04","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":887,"sales_invoice_id":2135,"title":"PAN-PA-440-ADVURL-R","description":"*\u8f6f\u4ef6*PaloAlto\u8f6f\u4ef6","number":"1","outbound":"1","unit":"\u5957","amount":"4822","tax_rate":"13","including_tax":"0","excluding_tax":"4267.26","tax_amount":"554.74","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":888,"sales_invoice_id":2135,"title":"PAN-PA-440-ATP-R","description":"*\u8f6f\u4ef6*PaloAlto\u8f6f\u4ef6","number":"1","outbound":"1","unit":"\u5957","amount":"4822","tax_rate":"13","including_tax":"0","excluding_tax":"4267.26","tax_amount":"554.74","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":889,"sales_invoice_id":2135,"title":"PAN-PA-440-AWF-R","description":"*\u8f6f\u4ef6*PaloAlto\u8f6f\u4ef6","number":"1","outbound":"1","unit":"\u5957","amount":"4822","tax_rate":"13","including_tax":"0","excluding_tax":"4267.26","tax_amount":"554.74","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0}],"contract":{"id":4094,"key":4094,"serial_no":"PO-2025-08-0002","client_id":2182,"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}}},"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":4,"tax_rate":["13"],"un_match_tax_amount":687.02,"except_simple_match_tax_amount":687.02,"salesInvoiceProductList":[{"tax_rate":13,"amount":17500,"excluding_tax":15486.74,"tax_amount":2013.26,"list":[{"id":886,"sales_invoice_id":2135,"title":"PAN-SVC-BKLN-440-R","description":"*\u8f6f\u4ef6*PaloAlto\u8f6f\u4ef6","number":"1","outbound":"1","unit":"\u5957","amount":"3034","tax_rate":"13","including_tax":"0","excluding_tax":"2684.96","tax_amount":"349.04","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":887,"sales_invoice_id":2135,"title":"PAN-PA-440-ADVURL-R","description":"*\u8f6f\u4ef6*PaloAlto\u8f6f\u4ef6","number":"1","outbound":"1","unit":"\u5957","amount":"4822","tax_rate":"13","including_tax":"0","excluding_tax":"4267.26","tax_amount":"554.74","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":888,"sales_invoice_id":2135,"title":"PAN-PA-440-ATP-R","description":"*\u8f6f\u4ef6*PaloAlto\u8f6f\u4ef6","number":"1","outbound":"1","unit":"\u5957","amount":"4822","tax_rate":"13","including_tax":"0","excluding_tax":"4267.26","tax_amount":"554.74","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":889,"sales_invoice_id":2135,"title":"PAN-PA-440-AWF-R","description":"*\u8f6f\u4ef6*PaloAlto\u8f6f\u4ef6","number":"1","outbound":"1","unit":"\u5957","amount":"4822","tax_rate":"13","including_tax":"0","excluding_tax":"4267.26","tax_amount":"554.74","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0}]}],"ready_match":false,"can_update":true,"can_delete":true,"settle_month":"","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,"is_new":false},{"id":2134,"contract_id":4047,"from_date":"2025-08-25","attachment_id":"","amount":"19427.00","created_by":5252,"created_at":"2025-08-25 15:48:42","description":"","invoice_num":"25112000000178916366","invoice_type":1,"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":"2234.96","excluding_tax":"17192.04","is_draft":false,"updated_at":"2025-08-25 15:49:24","need_match":true,"need_match_description":"","match_tax_amount":"920.36","simple_match_tax_amount":"0","is_settle":false,"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":48886,"object_type":102,"object_id":2134,"attachment_id":27806,"attachment":{"id":27806,"key":27806,"name":"a9431f4b-69c9-39ea-a0f5-328e43c79102","extension":"pdf","path":"\/vue\/attachment\/view\/a9431f4b-69c9-39ea-a0f5-328e43c79102\/dzfp_25112000000178916366_\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8_20250825154724.pdf","orig_name":"dzfp_25112000000178916366_\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8_20250825154724.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":883,"sales_invoice_id":2134,"title":"LS-5500V2-28C-EI","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u4ea4\u6362\u673a","number":"1","outbound":"1","unit":"\u53f0","amount":"7088","tax_rate":"13","including_tax":"0","excluding_tax":"6272.57","tax_amount":"815.43","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":884,"sales_invoice_id":2134,"title":"EWP-WA7230-LI-FIT","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u65e0\u7ebf\u63a5\u5165\u70b9","number":"2","outbound":"2","unit":"\u53f0","amount":"8586","tax_rate":"13","including_tax":"0","excluding_tax":"7598.23","tax_amount":"987.77","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":885,"sales_invoice_id":2134,"title":"EWP-WX2510X-PWR-LI","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u65e0\u7ebf\u63a7\u5236\u5668","number":"1","outbound":"1","unit":"\u53f0","amount":"3753","tax_rate":"13","including_tax":"0","excluding_tax":"3321.24","tax_amount":"431.76","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0}],"contract":{"id":4047,"key":4047,"serial_no":"PO-2025-07-0012","client_id":2182,"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}}},"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":4,"tax_rate":["13"],"un_match_tax_amount":1314.6,"except_simple_match_tax_amount":1314.6,"salesInvoiceProductList":[{"tax_rate":13,"amount":19427,"excluding_tax":17192.04,"tax_amount":2234.96,"list":[{"id":883,"sales_invoice_id":2134,"title":"LS-5500V2-28C-EI","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u4ea4\u6362\u673a","number":"1","outbound":"1","unit":"\u53f0","amount":"7088","tax_rate":"13","including_tax":"0","excluding_tax":"6272.57","tax_amount":"815.43","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":884,"sales_invoice_id":2134,"title":"EWP-WA7230-LI-FIT","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u65e0\u7ebf\u63a5\u5165\u70b9","number":"2","outbound":"2","unit":"\u53f0","amount":"8586","tax_rate":"13","including_tax":"0","excluding_tax":"7598.23","tax_amount":"987.77","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":885,"sales_invoice_id":2134,"title":"EWP-WX2510X-PWR-LI","description":"*\u8ba1\u7b97\u673a\u7f51\u7edc\u8bbe\u5907*\u65e0\u7ebf\u63a7\u5236\u5668","number":"1","outbound":"1","unit":"\u53f0","amount":"3753","tax_rate":"13","including_tax":"0","excluding_tax":"3321.24","tax_amount":"431.76","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0}]}],"ready_match":false,"can_update":true,"can_delete":true,"settle_month":"","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,"is_new":false},{"id":2133,"contract_id":4046,"from_date":"2025-08-25","attachment_id":"","amount":"5900.00","created_by":5252,"created_at":"2025-08-25 15:41:55","description":"","invoice_num":"25112000000178924589","invoice_type":1,"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":"678.75","excluding_tax":"5221.25","is_draft":false,"updated_at":"2025-08-25 15:42:35","need_match":true,"need_match_description":"","match_tax_amount":"552.1","simple_match_tax_amount":"0","is_settle":false,"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":48884,"object_type":102,"object_id":2133,"attachment_id":27805,"attachment":{"id":27805,"key":27805,"name":"57ae4bed-85b4-3a84-a764-c884fa831ea8","extension":"pdf","path":"\/vue\/attachment\/view\/57ae4bed-85b4-3a84-a764-c884fa831ea8\/dzfp_25112000000178924589_\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8_20250825154050.pdf","orig_name":"dzfp_25112000000178924589_\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8_20250825154050.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":878,"sales_invoice_id":2133,"title":"DH-IPC-HDW9443T-A-IL","description":"*\u516c\u5171\u5b89\u5168\u8bbe\u5907*\u7f51\u7edc\u6444\u50cf\u673a","number":"2","outbound":"2","unit":"\u53f0","amount":"864","tax_rate":"13","including_tax":"0","excluding_tax":"764.6","tax_amount":"99.4","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":879,"sales_invoice_id":2133,"title":"DH-NVR2106-4P-M","description":"*\u516c\u5171\u5b89\u5168\u8bbe\u5907*\u7f51\u7edc\u5f55\u50cf\u673a","number":"1","outbound":"1","unit":"\u53f0","amount":"365","tax_rate":"13","including_tax":"0","excluding_tax":"323.01","tax_amount":"41.99","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":880,"sales_invoice_id":2133,"title":"ST4000VM005","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u673a\u68b0\u786c\u76d8","number":"1","outbound":"1","unit":"\u5757","amount":"786","tax_rate":"13","including_tax":"0","excluding_tax":"695.58","tax_amount":"90.42","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":881,"sales_invoice_id":2133,"title":"DH-LM32-F200","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u76d1\u89c6\u5668","number":"1","outbound":"1","unit":"\u53f0","amount":"1775","tax_rate":"13","including_tax":"0","excluding_tax":"1570.8","tax_amount":"204.2","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":882,"sales_invoice_id":2133,"title":"DH-PFM1920I-5EUN","description":"*\u7535\u7ebf\u7535\u7f06*\u7f51\u7ebf","number":"1","outbound":"1","unit":"\u7bb1","amount":"2110","tax_rate":"13","including_tax":"0","excluding_tax":"1867.26","tax_amount":"242.74","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0}],"contract":{"id":4046,"key":4046,"serial_no":"PO-2025-07-0007","client_id":2182,"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}}},"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":6,"tax_rate":["13"],"un_match_tax_amount":126.65,"except_simple_match_tax_amount":126.65,"salesInvoiceProductList":[{"tax_rate":13,"amount":5900,"excluding_tax":5221.25,"tax_amount":678.75,"list":[{"id":878,"sales_invoice_id":2133,"title":"DH-IPC-HDW9443T-A-IL","description":"*\u516c\u5171\u5b89\u5168\u8bbe\u5907*\u7f51\u7edc\u6444\u50cf\u673a","number":"2","outbound":"2","unit":"\u53f0","amount":"864","tax_rate":"13","including_tax":"0","excluding_tax":"764.6","tax_amount":"99.4","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":879,"sales_invoice_id":2133,"title":"DH-NVR2106-4P-M","description":"*\u516c\u5171\u5b89\u5168\u8bbe\u5907*\u7f51\u7edc\u5f55\u50cf\u673a","number":"1","outbound":"1","unit":"\u53f0","amount":"365","tax_rate":"13","including_tax":"0","excluding_tax":"323.01","tax_amount":"41.99","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":880,"sales_invoice_id":2133,"title":"ST4000VM005","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u673a\u68b0\u786c\u76d8","number":"1","outbound":"1","unit":"\u5757","amount":"786","tax_rate":"13","including_tax":"0","excluding_tax":"695.58","tax_amount":"90.42","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":881,"sales_invoice_id":2133,"title":"DH-LM32-F200","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u76d1\u89c6\u5668","number":"1","outbound":"1","unit":"\u53f0","amount":"1775","tax_rate":"13","including_tax":"0","excluding_tax":"1570.8","tax_amount":"204.2","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":882,"sales_invoice_id":2133,"title":"DH-PFM1920I-5EUN","description":"*\u7535\u7ebf\u7535\u7f06*\u7f51\u7ebf","number":"1","outbound":"1","unit":"\u7bb1","amount":"2110","tax_rate":"13","including_tax":"0","excluding_tax":"1867.26","tax_amount":"242.74","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0}]}],"ready_match":false,"can_update":true,"can_delete":true,"settle_month":"","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,"is_new":false},{"id":2132,"contract_id":4048,"from_date":"2025-08-25","attachment_id":"","amount":"56862.00","created_by":5252,"created_at":"2025-08-25 15:38:25","description":"","invoice_num":"25112000000178952487","invoice_type":1,"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":"6541.65","excluding_tax":"50320.35","is_draft":false,"updated_at":"2025-08-25 15:39:16","need_match":true,"need_match_description":"","match_tax_amount":"5734.73","simple_match_tax_amount":"0","is_settle":false,"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":48882,"object_type":102,"object_id":2132,"attachment_id":27804,"attachment":{"id":27804,"key":27804,"name":"b74eb1a0-75b0-3212-b0f1-019335f06746","extension":"pdf","path":"\/vue\/attachment\/view\/b74eb1a0-75b0-3212-b0f1-019335f06746\/dzfp_25112000000178952487_\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8_20250825153705.pdf","orig_name":"dzfp_25112000000178952487_\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8_20250825153705.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":877,"sales_invoice_id":2132,"title":"ThinkBook14","description":"*\u7535\u5b50\u8ba1\u7b97\u673a*\u7b14\u8bb0\u672c\u7535\u8111","number":"6","outbound":"6","unit":"\u53f0","amount":"56862","tax_rate":"13","including_tax":"0","excluding_tax":"50320.35","tax_amount":"6541.65","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0}],"contract":{"id":4048,"key":4048,"serial_no":"PO-2025-07-0011","client_id":2182,"client":{"id":2182,"key":2182,"name":"\u5317\u4eac\u5357\u65b9\u65af\u5948\u514b\u739b\u6da1\u8f6e\u6280\u672f\u6709\u9650\u516c\u53f8","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}}},"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":6,"tax_rate":["13"],"un_match_tax_amount":806.92,"except_simple_match_tax_amount":806.92,"salesInvoiceProductList":[{"tax_rate":13,"amount":56862,"excluding_tax":50320.35,"tax_amount":6541.65,"list":[{"id":877,"sales_invoice_id":2132,"title":"ThinkBook14","description":"*\u7535\u5b50\u8ba1\u7b97\u673a*\u7b14\u8bb0\u672c\u7535\u8111","number":"6","outbound":"6","unit":"\u53f0","amount":"56862","tax_rate":"13","including_tax":"0","excluding_tax":"50320.35","tax_amount":"6541.65","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0}]}],"ready_match":false,"can_update":true,"can_delete":true,"settle_month":"","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,"is_new":false},{"id":2131,"contract_id":4106,"from_date":"2025-08-25","attachment_id":"","amount":"15340.00","created_by":5252,"created_at":"2025-08-25 09:19:52","description":"","invoice_num":"25112000000178287486","invoice_type":1,"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":"1764.78","excluding_tax":"13575.22","is_draft":false,"updated_at":"2025-08-25 09:22:10","need_match":true,"need_match_description":"","match_tax_amount":"1676.54","simple_match_tax_amount":"0","is_settle":false,"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":48851,"object_type":102,"object_id":2131,"attachment_id":27784,"attachment":{"id":27784,"key":27784,"name":"7094c861-b4a1-396a-aac0-ed2c295c9b1c","extension":"pdf","path":"\/vue\/attachment\/view\/7094c861-b4a1-396a-aac0-ed2c295c9b1c\/dzfp_25112000000178287486_\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8_20250825091813.pdf","orig_name":"dzfp_25112000000178287486_\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8_20250825091813.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":876,"sales_invoice_id":2131,"title":"PAN-SVC-BKLN-1410-R","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"1","outbound":"1","unit":"\u4e2a","amount":"15340","tax_rate":"13","including_tax":"0","excluding_tax":"13575.22","tax_amount":"1764.78","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0}],"contract":{"id":4106,"key":4106,"serial_no":"TS-LRC-2025081901","client_id":2845,"client":{"id":2845,"key":2845,"name":"\u5317\u4eac\u6052\u6cf0\u901a\u529b\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8\uff08PA\u8fc7\u5355\uff09","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}},"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":1,"tax_rate":["13"],"un_match_tax_amount":88.24,"except_simple_match_tax_amount":88.24,"salesInvoiceProductList":[{"tax_rate":13,"amount":15340,"excluding_tax":13575.22,"tax_amount":1764.78,"list":[{"id":876,"sales_invoice_id":2131,"title":"PAN-SVC-BKLN-1410-R","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"1","outbound":"1","unit":"\u4e2a","amount":"15340","tax_rate":"13","including_tax":"0","excluding_tax":"13575.22","tax_amount":"1764.78","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0}]}],"ready_match":false,"can_update":true,"can_delete":true,"settle_month":"","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,"is_new":false},{"id":2130,"contract_id":4055,"from_date":"2025-08-22","attachment_id":"","amount":"178669.60","created_by":5252,"created_at":"2025-08-22 10:46:22","description":"","invoice_num":"25112000000176721771","invoice_type":1,"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":"20554.91","excluding_tax":"158114.69","is_draft":false,"updated_at":"2025-08-22 10:50:53","need_match":true,"need_match_description":"","match_tax_amount":"25368.78","simple_match_tax_amount":"16690.17","is_settle":false,"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":48815,"object_type":102,"object_id":2130,"attachment_id":27756,"attachment":{"id":27756,"key":27756,"name":"b84a7681-216f-3314-81d9-febaf99b168e","extension":"pdf","path":"\/vue\/attachment\/view\/b84a7681-216f-3314-81d9-febaf99b168e\/dzfp_25112000000176721771_\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8_20250822101053.pdf","orig_name":"dzfp_25112000000176721771_\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8_20250822101053.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":871,"sales_invoice_id":2130,"title":"PAN-PA-445","description":"*\u4fe1\u606f\u5b89\u5168\u4ea7\u54c1*PALOALTO\u9632\u706b\u5899","number":"2","outbound":"2","unit":"\u53f0","amount":"44274","tax_rate":"13","including_tax":"0","excluding_tax":"39180.53","tax_amount":"5093.47","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":872,"sales_invoice_id":2130,"title":"PAN-PA-400-POEPWR-150W","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALO ALTO\u7535\u6e90","number":"4","outbound":"4","unit":"\u53f0","amount":"8048","tax_rate":"13","including_tax":"0","excluding_tax":"7122.12","tax_amount":"925.88","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":873,"sales_invoice_id":2130,"title":"PAN-PA-400-POERACKTRAY","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALOALTO\u652f\u67b6","number":"2","outbound":"2","unit":"\u53f0","amount":"6624","tax_rate":"13","including_tax":"0","excluding_tax":"5861.95","tax_amount":"762.05","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":874,"sales_invoice_id":2130,"title":"PAN-PA-445-BND-CORESEC3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"2","outbound":"2","unit":"\u53f0","amount":"88434","tax_rate":"13","including_tax":"0","excluding_tax":"78260.18","tax_amount":"10173.82","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":875,"sales_invoice_id":2130,"title":"PAN-SVC-PREM445-3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"2","outbound":"2","unit":"\u53f0","amount":"31289.6","tax_rate":"13","including_tax":"0","excluding_tax":"27689.91","tax_amount":"3599.69","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0}],"contract":{"id":4055,"key":4055,"serial_no":"W-KJ-CG-KXMTYB-20250729-01","client_id":2553,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}},"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":12,"tax_rate":["13"],"un_match_tax_amount":-4813.87,"except_simple_match_tax_amount":11876.3,"salesInvoiceProductList":[{"tax_rate":13,"amount":178669.6,"excluding_tax":158114.69,"tax_amount":20554.91,"list":[{"id":871,"sales_invoice_id":2130,"title":"PAN-PA-445","description":"*\u4fe1\u606f\u5b89\u5168\u4ea7\u54c1*PALOALTO\u9632\u706b\u5899","number":"2","outbound":"2","unit":"\u53f0","amount":"44274","tax_rate":"13","including_tax":"0","excluding_tax":"39180.53","tax_amount":"5093.47","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":872,"sales_invoice_id":2130,"title":"PAN-PA-400-POEPWR-150W","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALO ALTO\u7535\u6e90","number":"4","outbound":"4","unit":"\u53f0","amount":"8048","tax_rate":"13","including_tax":"0","excluding_tax":"7122.12","tax_amount":"925.88","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":873,"sales_invoice_id":2130,"title":"PAN-PA-400-POERACKTRAY","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALOALTO\u652f\u67b6","number":"2","outbound":"2","unit":"\u53f0","amount":"6624","tax_rate":"13","including_tax":"0","excluding_tax":"5861.95","tax_amount":"762.05","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":874,"sales_invoice_id":2130,"title":"PAN-PA-445-BND-CORESEC3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"2","outbound":"2","unit":"\u53f0","amount":"88434","tax_rate":"13","including_tax":"0","excluding_tax":"78260.18","tax_amount":"10173.82","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":875,"sales_invoice_id":2130,"title":"PAN-SVC-PREM445-3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"2","outbound":"2","unit":"\u53f0","amount":"31289.6","tax_rate":"13","including_tax":"0","excluding_tax":"27689.91","tax_amount":"3599.69","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0}]}],"ready_match":false,"can_update":true,"can_delete":true,"settle_month":"","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,"is_new":false},{"id":2129,"contract_id":4055,"from_date":"2025-08-22","attachment_id":"","amount":"178669.60","created_by":5252,"created_at":"2025-08-22 10:46:08","description":"","invoice_num":"25112000000176706921","invoice_type":1,"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":"20554.91","excluding_tax":"158114.69","is_draft":false,"updated_at":"2025-08-22 10:49:36","need_match":true,"need_match_description":"","match_tax_amount":"20475.94","simple_match_tax_amount":"11619.47","is_settle":false,"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":48814,"object_type":102,"object_id":2129,"attachment_id":27755,"attachment":{"id":27755,"key":27755,"name":"d1d6c839-7aae-3f97-8a9c-959306cddd44","extension":"pdf","path":"\/vue\/attachment\/view\/d1d6c839-7aae-3f97-8a9c-959306cddd44\/dzfp_25112000000176706921_\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8_20250822100051.pdf","orig_name":"dzfp_25112000000176706921_\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8_20250822100051.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":866,"sales_invoice_id":2129,"title":"PAN-PA-445","description":"*\u4fe1\u606f\u5b89\u5168\u4ea7\u54c1*PALOALTO\u9632\u706b\u5899","number":"2","outbound":"2","unit":"\u53f0","amount":"44274","tax_rate":"13","including_tax":"0","excluding_tax":"39180.53","tax_amount":"5093.47","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":867,"sales_invoice_id":2129,"title":"PAN-PA-400-POEPWR-150W","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALO ALTO\u7535\u6e90","number":"4","outbound":"4","unit":"\u53f0","amount":"8048","tax_rate":"13","including_tax":"0","excluding_tax":"7122.12","tax_amount":"925.88","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":868,"sales_invoice_id":2129,"title":"PAN-PA-400-POERACKTRAY","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALOALTO\u652f\u67b6","number":"2","outbound":"2","unit":"\u53f0","amount":"6624","tax_rate":"13","including_tax":"0","excluding_tax":"5861.95","tax_amount":"762.05","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":869,"sales_invoice_id":2129,"title":"PAN-PA-445-BND-CORESEC3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"2","outbound":"2","unit":"\u53f0","amount":"88434","tax_rate":"13","including_tax":"0","excluding_tax":"78260.18","tax_amount":"10173.82","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":870,"sales_invoice_id":2129,"title":"PAN-SVC-PREM445-3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"2","outbound":"2","unit":"\u53f0","amount":"31289.6","tax_rate":"13","including_tax":"0","excluding_tax":"27689.91","tax_amount":"3599.69","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0}],"contract":{"id":4055,"key":4055,"serial_no":"W-KJ-CG-KXMTYB-20250729-01","client_id":2553,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}},"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":12,"tax_rate":["13"],"un_match_tax_amount":78.970000000001,"except_simple_match_tax_amount":11698.44,"salesInvoiceProductList":[{"tax_rate":13,"amount":178669.6,"excluding_tax":158114.69,"tax_amount":20554.91,"list":[{"id":866,"sales_invoice_id":2129,"title":"PAN-PA-445","description":"*\u4fe1\u606f\u5b89\u5168\u4ea7\u54c1*PALOALTO\u9632\u706b\u5899","number":"2","outbound":"2","unit":"\u53f0","amount":"44274","tax_rate":"13","including_tax":"0","excluding_tax":"39180.53","tax_amount":"5093.47","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":867,"sales_invoice_id":2129,"title":"PAN-PA-400-POEPWR-150W","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALO ALTO\u7535\u6e90","number":"4","outbound":"4","unit":"\u53f0","amount":"8048","tax_rate":"13","including_tax":"0","excluding_tax":"7122.12","tax_amount":"925.88","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":868,"sales_invoice_id":2129,"title":"PAN-PA-400-POERACKTRAY","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALOALTO\u652f\u67b6","number":"2","outbound":"2","unit":"\u53f0","amount":"6624","tax_rate":"13","including_tax":"0","excluding_tax":"5861.95","tax_amount":"762.05","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":869,"sales_invoice_id":2129,"title":"PAN-PA-445-BND-CORESEC3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"2","outbound":"2","unit":"\u53f0","amount":"88434","tax_rate":"13","including_tax":"0","excluding_tax":"78260.18","tax_amount":"10173.82","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":870,"sales_invoice_id":2129,"title":"PAN-SVC-PREM445-3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"2","outbound":"2","unit":"\u53f0","amount":"31289.6","tax_rate":"13","including_tax":"0","excluding_tax":"27689.91","tax_amount":"3599.69","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0}]}],"ready_match":false,"can_update":true,"can_delete":true,"settle_month":"","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,"is_new":false},{"id":2128,"contract_id":4055,"from_date":"2025-08-22","attachment_id":"","amount":"178669.60","created_by":5252,"created_at":"2025-08-22 10:45:53","description":"","invoice_num":"25112000000176715706","invoice_type":1,"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":"20554.91","excluding_tax":"158114.69","is_draft":false,"updated_at":"2025-08-22 10:48:13","need_match":true,"need_match_description":"","match_tax_amount":"17068.56","simple_match_tax_amount":"8034.23","is_settle":false,"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":48813,"object_type":102,"object_id":2128,"attachment_id":27754,"attachment":{"id":27754,"key":27754,"name":"8770fa49-0aca-344a-a479-5bb2cfae7a72","extension":"pdf","path":"\/vue\/attachment\/view\/8770fa49-0aca-344a-a479-5bb2cfae7a72\/dzfp_25112000000176715706_\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8_20250822095932.pdf","orig_name":"dzfp_25112000000176715706_\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8_20250822095932.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":861,"sales_invoice_id":2128,"title":"PAN-PA-445","description":"*\u4fe1\u606f\u5b89\u5168\u4ea7\u54c1*PALOALTO\u9632\u706b\u5899","number":"2","outbound":"2","unit":"\u53f0","amount":"44274","tax_rate":"13","including_tax":"0","excluding_tax":"39180.53","tax_amount":"5093.47","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":862,"sales_invoice_id":2128,"title":"PAN-PA-400-POEPWR-150W","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALO ALTO\u7535\u6e90","number":"4","outbound":"4","unit":"\u53f0","amount":"8048","tax_rate":"13","including_tax":"0","excluding_tax":"7122.12","tax_amount":"925.88","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":863,"sales_invoice_id":2128,"title":"PAN-PA-400-POERACKTRAY","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALOALTO\u652f\u67b6","number":"2","outbound":"2","unit":"\u53f0","amount":"6624","tax_rate":"13","including_tax":"0","excluding_tax":"5861.95","tax_amount":"762.05","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":864,"sales_invoice_id":2128,"title":"PAN-PA-445-BND-CORESEC3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"2","outbound":"2","unit":"\u53f0","amount":"88434","tax_rate":"13","including_tax":"0","excluding_tax":"78260.18","tax_amount":"10173.82","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":865,"sales_invoice_id":2128,"title":"PAN-SVC-PREM445-3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"2","outbound":"2","unit":"\u53f0","amount":"31289.6","tax_rate":"13","including_tax":"0","excluding_tax":"27689.91","tax_amount":"3599.69","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0}],"contract":{"id":4055,"key":4055,"serial_no":"W-KJ-CG-KXMTYB-20250729-01","client_id":2553,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}},"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":12,"tax_rate":["13"],"un_match_tax_amount":3486.35,"except_simple_match_tax_amount":11520.58,"salesInvoiceProductList":[{"tax_rate":13,"amount":178669.6,"excluding_tax":158114.69,"tax_amount":20554.91,"list":[{"id":861,"sales_invoice_id":2128,"title":"PAN-PA-445","description":"*\u4fe1\u606f\u5b89\u5168\u4ea7\u54c1*PALOALTO\u9632\u706b\u5899","number":"2","outbound":"2","unit":"\u53f0","amount":"44274","tax_rate":"13","including_tax":"0","excluding_tax":"39180.53","tax_amount":"5093.47","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":862,"sales_invoice_id":2128,"title":"PAN-PA-400-POEPWR-150W","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALO ALTO\u7535\u6e90","number":"4","outbound":"4","unit":"\u53f0","amount":"8048","tax_rate":"13","including_tax":"0","excluding_tax":"7122.12","tax_amount":"925.88","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":863,"sales_invoice_id":2128,"title":"PAN-PA-400-POERACKTRAY","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALOALTO\u652f\u67b6","number":"2","outbound":"2","unit":"\u53f0","amount":"6624","tax_rate":"13","including_tax":"0","excluding_tax":"5861.95","tax_amount":"762.05","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":864,"sales_invoice_id":2128,"title":"PAN-PA-445-BND-CORESEC3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"2","outbound":"2","unit":"\u53f0","amount":"88434","tax_rate":"13","including_tax":"0","excluding_tax":"78260.18","tax_amount":"10173.82","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":865,"sales_invoice_id":2128,"title":"PAN-SVC-PREM445-3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"2","outbound":"2","unit":"\u53f0","amount":"31289.6","tax_rate":"13","including_tax":"0","excluding_tax":"27689.91","tax_amount":"3599.69","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0}]}],"ready_match":false,"can_update":true,"can_delete":true,"settle_month":"","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,"is_new":false},{"id":2127,"contract_id":4055,"from_date":"2025-08-22","attachment_id":"","amount":"349291.20","created_by":5252,"created_at":"2025-08-22 10:42:01","description":"","invoice_num":"25112000000176686956","invoice_type":1,"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":"40183.96","excluding_tax":"309107.24","is_draft":false,"updated_at":"2025-08-22 10:46:46","need_match":true,"need_match_description":"","match_tax_amount":"29847.27","simple_match_tax_amount":"12146.74","is_settle":false,"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":48812,"object_type":102,"object_id":2127,"attachment_id":27752,"attachment":{"id":27752,"key":27752,"name":"32353754-1232-3103-8cf9-072f01f3291d","extension":"pdf","path":"\/vue\/attachment\/view\/32353754-1232-3103-8cf9-072f01f3291d\/dzfp_25112000000176686956_\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8_20250822095506.pdf","orig_name":"dzfp_25112000000176686956_\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8_20250822095506.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":856,"sales_invoice_id":2127,"title":"PAN-PA-445","description":"*\u4fe1\u606f\u5b89\u5168\u4ea7\u54c1*PALOALTO\u9632\u706b\u5899","number":"4","outbound":"4","unit":"\u53f0","amount":"88548","tax_rate":"13","including_tax":"0","excluding_tax":"78361.06","tax_amount":"10186.94","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":857,"sales_invoice_id":2127,"title":"PAN-PA-400-POEPWR-150W","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALO ALTO\u7535\u6e90","number":"4","outbound":"4","unit":"\u53f0","amount":"8048","tax_rate":"13","including_tax":"0","excluding_tax":"7122.12","tax_amount":"925.88","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":858,"sales_invoice_id":2127,"title":"PAN-PA-400-POERACKTRAY","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALOALTO\u652f\u67b6","number":"4","outbound":"4","unit":"\u53f0","amount":"13248","tax_rate":"13","including_tax":"0","excluding_tax":"11723.89","tax_amount":"1524.11","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":859,"sales_invoice_id":2127,"title":"PAN-PA-445-BND-CORESEC3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"4","outbound":"4","unit":"\u53f0","amount":"176868","tax_rate":"13","including_tax":"0","excluding_tax":"156520.35","tax_amount":"20347.65","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":860,"sales_invoice_id":2127,"title":"PAN-SVC-PREM445-3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"4","outbound":"4","unit":"\u53f0","amount":"62579.2","tax_rate":"13","including_tax":"0","excluding_tax":"55379.82","tax_amount":"7199.38","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0}],"contract":{"id":4055,"key":4055,"serial_no":"W-KJ-CG-KXMTYB-20250729-01","client_id":2553,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}},"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":20,"tax_rate":["13"],"un_match_tax_amount":10336.69,"except_simple_match_tax_amount":22483.43,"salesInvoiceProductList":[{"tax_rate":13,"amount":349291.2,"excluding_tax":309107.24,"tax_amount":40183.96,"list":[{"id":856,"sales_invoice_id":2127,"title":"PAN-PA-445","description":"*\u4fe1\u606f\u5b89\u5168\u4ea7\u54c1*PALOALTO\u9632\u706b\u5899","number":"4","outbound":"4","unit":"\u53f0","amount":"88548","tax_rate":"13","including_tax":"0","excluding_tax":"78361.06","tax_amount":"10186.94","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":857,"sales_invoice_id":2127,"title":"PAN-PA-400-POEPWR-150W","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALO ALTO\u7535\u6e90","number":"4","outbound":"4","unit":"\u53f0","amount":"8048","tax_rate":"13","including_tax":"0","excluding_tax":"7122.12","tax_amount":"925.88","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":858,"sales_invoice_id":2127,"title":"PAN-PA-400-POERACKTRAY","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALOALTO\u652f\u67b6","number":"4","outbound":"4","unit":"\u53f0","amount":"13248","tax_rate":"13","including_tax":"0","excluding_tax":"11723.89","tax_amount":"1524.11","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":859,"sales_invoice_id":2127,"title":"PAN-PA-445-BND-CORESEC3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"4","outbound":"4","unit":"\u53f0","amount":"176868","tax_rate":"13","including_tax":"0","excluding_tax":"156520.35","tax_amount":"20347.65","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":860,"sales_invoice_id":2127,"title":"PAN-SVC-PREM445-3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"4","outbound":"4","unit":"\u53f0","amount":"62579.2","tax_rate":"13","including_tax":"0","excluding_tax":"55379.82","tax_amount":"7199.38","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0}]}],"ready_match":false,"can_update":true,"can_delete":true,"settle_month":"","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,"is_new":false},{"id":2125,"contract_id":4055,"from_date":"2025-08-22","attachment_id":"","amount":619710,"created_by":5252,"created_at":"2025-08-22 10:26:07","description":"","invoice_num":"25112000000176157908","invoice_type":-1,"is_match":false,"is_cancel":false,"is_used":false,"cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":true,"tax_amount":71294.07,"excluding_tax":548415.93,"is_draft":false,"updated_at":"2025-08-22 10:26:07","need_match":false,"need_match_description":"","match_tax_amount":"0","simple_match_tax_amount":"0","is_settle":false,"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":48800,"object_type":102,"object_id":2125,"attachment_id":27747,"attachment":{"id":27747,"key":27747,"name":"1f1f9f4e-38ed-3ab8-af7f-f3d2b7ff2b93","extension":"pdf","path":"\/vue\/attachment\/view\/1f1f9f4e-38ed-3ab8-af7f-f3d2b7ff2b93\/dzfp_25112000000176157908_\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8_20250822094746.pdf","orig_name":"dzfp_25112000000176157908_\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8_20250822094746.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":842,"sales_invoice_id":2125,"title":"PAN-PA-400-POEPWR-150W","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALO ALTO\u7535\u6e90","number":"11.2","outbound":"0","unit":"\u53f0","amount":"-22534.4","tax_rate":"13","including_tax":"0","excluding_tax":"-19941.95","tax_amount":"-2592.45","need_match":false,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":843,"sales_invoice_id":2125,"title":"PAN-PA-400-POERACKTRAY","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALOALTO\u652f\u67b6","number":"7","outbound":"0","unit":"\u53f0","amount":"-23184","tax_rate":"13","including_tax":"0","excluding_tax":"-20516.81","tax_amount":"-2667.19","need_match":false,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":844,"sales_invoice_id":2125,"title":"PAN-PA-445-BND-CORESEC3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"7","outbound":"0","unit":"\u53f0","amount":"-309519","tax_rate":"13","including_tax":"0","excluding_tax":"-273910.62","tax_amount":"-35608.38","need_match":false,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":845,"sales_invoice_id":2125,"title":"PAN-SVC-PREM445-3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"7","outbound":"0","unit":"\u53f0","amount":"-109513.6","tax_rate":"13","including_tax":"0","excluding_tax":"-96914.69","tax_amount":"-12598.91","need_match":false,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":846,"sales_invoice_id":2125,"title":"PAN-PA-445","description":"*\u4fe1\u606f\u5b89\u5168\u4ea7\u54c1*PALOALTO\u9632\u706b\u5899","number":"7","outbound":"0","unit":"\u53f0","amount":"-154959","tax_rate":"13","including_tax":"0","excluding_tax":"-137131.86","tax_amount":"-17827.14","need_match":false,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0}],"contract":{"id":4055,"key":4055,"serial_no":"W-KJ-CG-KXMTYB-20250729-01","client_id":2553,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8","sales_rep":1001,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}}},"coverInvoices":[{"id":2123,"cover_invoice_id":2125}],"cancelInvoice":{"id":2123,"contract_id":4055,"from_date":"2025-08-21","attachment_id":"","amount":"619710.00","created_by":5252,"created_at":"2025-08-21 10:23:31","description":"","invoice_num":"25112000000175871861","invoice_type":1,"is_match":false,"is_cancel":true,"is_used":false,"cancel_description":"","cover_invoice_id":2125,"red_invoice_id":2125,"new_invoice_id":"","need_new_invoice":false,"tax_amount":"71294.07","excluding_tax":"548415.93","is_draft":false,"updated_at":"2025-08-21 10:24:39","need_match":true,"need_match_description":"","match_tax_amount":"0","simple_match_tax_amount":"0","is_settle":false,"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":48707,"object_type":102,"object_id":2123,"attachment_id":27677,"attachment":{"id":27677,"key":27677,"name":"e1d415fd-aadf-3346-8175-a271d069468f","extension":"pdf","path":"\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2025\/08\/","orig_name":"dzfp_25112000000175871861_\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8_20250821102233.pdf"}}],"contract":{"id":4055,"key":4055,"serial_no":"W-KJ-CG-KXMTYB-20250729-01","client_id":2553,"client":{"id":2553,"key":2553,"name":"\u9752\u5c9b\u9890\u6770\u9e3f\u5229\u79d1\u6280\u6709\u9650\u516c\u53f8"}},"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":836,"sales_invoice_id":2123,"title":"PAN-PA-445","description":"*\u4fe1\u606f\u5b89\u5168\u4ea7\u54c1*PALOALTO\u9632\u706b\u5899","number":"7","outbound":"0","unit":"\u53f0","amount":"154959","tax_rate":"13","including_tax":"0","excluding_tax":"137131.86","tax_amount":"17827.14","need_match":true,"inventory_count":""},{"id":837,"sales_invoice_id":2123,"title":"PAN-PA-400-POEPWR-150W","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALO ALTO\u7535\u6e90","number":"11.2","outbound":"0","unit":"\u53f0","amount":"22534.4","tax_rate":"13","including_tax":"0","excluding_tax":"19941.95","tax_amount":"2592.45","need_match":true,"inventory_count":""},{"id":838,"sales_invoice_id":2123,"title":"PAN-PA-400-POERACKTRAY","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALOALTO\u652f\u67b6","number":"7","outbound":"0","unit":"\u53f0","amount":"23184","tax_rate":"13","including_tax":"0","excluding_tax":"20516.81","tax_amount":"2667.19","need_match":true,"inventory_count":""},{"id":839,"sales_invoice_id":2123,"title":"PAN-PA-445-BND-CORESEC3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"7","outbound":"0","unit":"\u53f0","amount":"309519","tax_rate":"13","including_tax":"0","excluding_tax":"273910.62","tax_amount":"35608.38","need_match":true,"inventory_count":""},{"id":840,"sales_invoice_id":2123,"title":"PAN-SVC-PREM445-3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"7","outbound":"0","unit":"\u53f0","amount":"109513.6","tax_rate":"13","including_tax":"0","excluding_tax":"96914.69","tax_amount":"12598.91","need_match":true,"inventory_count":""}]},"redInvoice":{},"invoice_type_display":"\u7ea2\u5b57\u53d1\u7968","including_tax":0,"number":39.2,"tax_rate":["13"],"un_match_tax_amount":-71294.07,"except_simple_match_tax_amount":-71294.07,"salesInvoiceProductList":[{"tax_rate":13,"amount":-619710,"excluding_tax":-548415.93,"tax_amount":-71294.07,"list":[{"id":842,"sales_invoice_id":2125,"title":"PAN-PA-400-POEPWR-150W","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALO ALTO\u7535\u6e90","number":"11.2","outbound":"0","unit":"\u53f0","amount":"-22534.4","tax_rate":"13","including_tax":"0","excluding_tax":"-19941.95","tax_amount":"-2592.45","need_match":false,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":843,"sales_invoice_id":2125,"title":"PAN-PA-400-POERACKTRAY","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*PALOALTO\u652f\u67b6","number":"7","outbound":"0","unit":"\u53f0","amount":"-23184","tax_rate":"13","including_tax":"0","excluding_tax":"-20516.81","tax_amount":"-2667.19","need_match":false,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":844,"sales_invoice_id":2125,"title":"PAN-PA-445-BND-CORESEC3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"7","outbound":"0","unit":"\u53f0","amount":"-309519","tax_rate":"13","including_tax":"0","excluding_tax":"-273910.62","tax_amount":"-35608.38","need_match":false,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":845,"sales_invoice_id":2125,"title":"PAN-SVC-PREM445-3YR","description":"*\u8f6f\u4ef6*PALOALTO\u8bb8\u53ef","number":"7","outbound":"0","unit":"\u53f0","amount":"-109513.6","tax_rate":"13","including_tax":"0","excluding_tax":"-96914.69","tax_amount":"-12598.91","need_match":false,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":846,"sales_invoice_id":2125,"title":"PAN-PA-445","description":"*\u4fe1\u606f\u5b89\u5168\u4ea7\u54c1*PALOALTO\u9632\u706b\u5899","number":"7","outbound":"0","unit":"\u53f0","amount":"-154959","tax_rate":"13","including_tax":"0","excluding_tax":"-137131.86","tax_amount":"-17827.14","need_match":false,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0}]}],"ready_match":false,"can_update":true,"can_delete":true,"settle_month":"","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":true,"is_new":false},{"id":2124,"contract_id":4099,"from_date":"2025-08-22","attachment_id":"","amount":"750.00","created_by":5252,"created_at":"2025-08-22 10:23:07","description":"","invoice_num":"25112000000176781027","invoice_type":1,"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":"86.28","excluding_tax":"663.72","is_draft":false,"updated_at":"2025-08-22 10:25:09","need_match":true,"need_match_description":"","match_tax_amount":"34.51","simple_match_tax_amount":"0","is_settle":false,"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":48799,"object_type":102,"object_id":2124,"attachment_id":27746,"attachment":{"id":27746,"key":27746,"name":"0149c27f-f2bd-31db-bedf-07501d9b1a11","extension":"pdf","path":"\/vue\/attachment\/view\/0149c27f-f2bd-31db-bedf-07501d9b1a11\/dzfp_25112000000176781027_\u5317\u4eac\u6052\u4fe1\u901a\u7535\u4fe1\u670d\u52a1\u6709\u9650\u516c\u53f8_20250822102224.pdf","orig_name":"dzfp_25112000000176781027_\u5317\u4eac\u6052\u4fe1\u901a\u7535\u4fe1\u670d\u52a1\u6709\u9650\u516c\u53f8_20250822102224.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":841,"sales_invoice_id":2124,"title":"16G","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5185\u5b58","number":"1","outbound":"1","unit":"\u6761","amount":"750","tax_rate":"13","including_tax":"0","excluding_tax":"663.72","tax_amount":"86.28","need_match":true,"inventory_count":"3","matchPurchaseInvoice":[],"inventory":3}],"contract":{"id":4099,"key":4099,"serial_no":"TS-WZW-20250820-01","client_id":3366,"client":{"id":3366,"key":3366,"name":"\u8fc7\u5355-\u5317\u4eac\u4e2d\u4f01\u6613\u4ed8\u5546\u52a1\u670d\u52a1\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u6052\u4fe1\u901a\u7535\u4fe1\u670d\u52a1\u6709\u9650\u516c\u53f8\uff09","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}}},"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":1,"tax_rate":["13"],"un_match_tax_amount":51.77,"except_simple_match_tax_amount":51.77,"salesInvoiceProductList":[{"tax_rate":13,"amount":750,"excluding_tax":663.72,"tax_amount":86.28,"list":[{"id":841,"sales_invoice_id":2124,"title":"16G","description":"*\u8ba1\u7b97\u673a\u914d\u5957\u4ea7\u54c1*\u5185\u5b58","number":"1","outbound":"1","unit":"\u6761","amount":"750","tax_rate":"13","including_tax":"0","excluding_tax":"663.72","tax_amount":"86.28","need_match":true,"inventory_count":"3","matchPurchaseInvoice":[],"inventory":3}]}],"ready_match":true,"can_update":true,"can_delete":true,"settle_month":"","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,"is_new":false},{"id":2122,"contract_id":2653,"from_date":"2025-08-21","attachment_id":"","amount":"-3877.50","created_by":5252,"created_at":"2025-08-21 09:21:28","description":"","invoice_num":"25112000000175315478","invoice_type":1,"is_match":false,"is_cancel":false,"is_used":false,"cancel_description":"","cover_invoice_id":"","red_invoice_id":"","new_invoice_id":"","need_new_invoice":false,"tax_amount":"-219.48","excluding_tax":"-3658.02","is_draft":false,"updated_at":"2025-08-21 09:25:16","need_match":false,"need_match_description":"","match_tax_amount":"0","simple_match_tax_amount":"0","is_settle":false,"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":48696,"object_type":102,"object_id":2122,"attachment_id":27669,"attachment":{"id":27669,"key":27669,"name":"36247d83-d65a-38e7-9ea4-3a5b91223def","extension":"pdf","path":"\/vue\/attachment\/view\/36247d83-d65a-38e7-9ea4-3a5b91223def\/dzfp_25112000000175315478_\u5317\u4eac\u4eac\u897f\u5b66\u6821_20250821091930.pdf","orig_name":"dzfp_25112000000175315478_\u5317\u4eac\u4eac\u897f\u5b66\u6821_20250821091930.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":835,"sales_invoice_id":2122,"title":"","description":"*\u4fe1\u606f\u6280\u672f\u670d\u52a1*\u6280\u672f\u670d\u52a1\u8d39","number":"-38775","outbound":"0","unit":"\u6b21","amount":"-3877.5","tax_rate":"6","including_tax":"0","excluding_tax":"-3658.02","tax_amount":"-219.48","need_match":false,"inventory_count":"2","matchPurchaseInvoice":[],"inventory":2}],"contract":{"id":2653,"key":2653,"serial_no":"TS-WZW-2023051704","client_id":189,"client":{"id":189,"key":189,"name":"\u5317\u4eac\u4eac\u897f\u5b66\u6821","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}}},"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":-38775,"tax_rate":["6"],"un_match_tax_amount":-219.48,"except_simple_match_tax_amount":-219.48,"salesInvoiceProductList":[{"tax_rate":6,"amount":-3877.5,"excluding_tax":-3658.02,"tax_amount":-219.48,"list":[{"id":835,"sales_invoice_id":2122,"title":"","description":"*\u4fe1\u606f\u6280\u672f\u670d\u52a1*\u6280\u672f\u670d\u52a1\u8d39","number":"-38775","outbound":"0","unit":"\u6b21","amount":"-3877.5","tax_rate":"6","including_tax":"0","excluding_tax":"-3658.02","tax_amount":"-219.48","need_match":false,"inventory_count":"2","matchPurchaseInvoice":[],"inventory":2}]}],"ready_match":true,"can_update":true,"can_delete":true,"settle_month":"","can_match":false,"can_cancel_match":false,"can_simple_match":false,"can_need_match":false,"can_cancel":true,"can_red_cancel":true,"can_new_invoice":false,"is_new":false},{"id":2121,"contract_id":4026,"from_date":"2025-08-20","attachment_id":"","amount":"184000.00","created_by":5252,"created_at":"2025-08-20 17:47:47","description":"","invoice_num":"25112000000175512703","invoice_type":1,"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":"21168.14","excluding_tax":"162831.86","is_draft":false,"updated_at":"2025-08-20 17:49:05","need_match":true,"need_match_description":"","match_tax_amount":"14095.69","simple_match_tax_amount":"0","is_settle":false,"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":48690,"object_type":102,"object_id":2121,"attachment_id":27665,"attachment":{"id":27665,"key":27665,"name":"57c6de89-ceac-31fc-980b-9a761aa5ea4c","extension":"pdf","path":"\/vue\/attachment\/view\/57c6de89-ceac-31fc-980b-9a761aa5ea4c\/dzfp_25112000000175512703_\u5317\u4eac\u4e16\u7eaa\u98de\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8_20250820174709.pdf","orig_name":"dzfp_25112000000175512703_\u5317\u4eac\u4e16\u7eaa\u98de\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8_20250820174709.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":832,"sales_invoice_id":2121,"title":"CON-SNT-UCSC48S","description":"*\u52b3\u52a1*\u6280\u672f\u652f\u6301\u670d\u52a1","number":"2","outbound":"2","unit":"\u5957","amount":"14000","tax_rate":"13","including_tax":"0","excluding_tax":"12389.38","tax_amount":"1610.62","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":833,"sales_invoice_id":2121,"title":"CON-SNT-N9504B1","description":"*\u52b3\u52a1*\u6280\u672f\u652f\u6301\u670d\u52a1","number":"2","outbound":"2","unit":"\u5957","amount":"110000","tax_rate":"13","including_tax":"0","excluding_tax":"97345.13","tax_amount":"12654.87","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":834,"sales_invoice_id":2121,"title":"CON-SNT-3172TQXL","description":"*\u52b3\u52a1*\u6280\u672f\u652f\u6301\u670d\u52a1","number":"4","outbound":"4","unit":"\u5957","amount":"60000","tax_rate":"13","including_tax":"0","excluding_tax":"53097.35","tax_amount":"6902.65","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0}],"contract":{"id":4026,"key":4026,"serial_no":"TSKJ20250702-YJC-01","client_id":3378,"client":{"id":3378,"key":3378,"name":"\u5317\u4eac\u4e16\u7eaa\u98de\u8baf\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09","sales_rep":1004,"salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}}},"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":8,"tax_rate":["13"],"un_match_tax_amount":7072.45,"except_simple_match_tax_amount":7072.45,"salesInvoiceProductList":[{"tax_rate":13,"amount":184000,"excluding_tax":162831.86,"tax_amount":21168.14,"list":[{"id":832,"sales_invoice_id":2121,"title":"CON-SNT-UCSC48S","description":"*\u52b3\u52a1*\u6280\u672f\u652f\u6301\u670d\u52a1","number":"2","outbound":"2","unit":"\u5957","amount":"14000","tax_rate":"13","including_tax":"0","excluding_tax":"12389.38","tax_amount":"1610.62","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":833,"sales_invoice_id":2121,"title":"CON-SNT-N9504B1","description":"*\u52b3\u52a1*\u6280\u672f\u652f\u6301\u670d\u52a1","number":"2","outbound":"2","unit":"\u5957","amount":"110000","tax_rate":"13","including_tax":"0","excluding_tax":"97345.13","tax_amount":"12654.87","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0},{"id":834,"sales_invoice_id":2121,"title":"CON-SNT-3172TQXL","description":"*\u52b3\u52a1*\u6280\u672f\u652f\u6301\u670d\u52a1","number":"4","outbound":"4","unit":"\u5957","amount":"60000","tax_rate":"13","including_tax":"0","excluding_tax":"53097.35","tax_amount":"6902.65","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0}]}],"ready_match":false,"can_update":true,"can_delete":true,"settle_month":"","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,"is_new":false},{"id":2120,"contract_id":4083,"from_date":"2025-08-18","attachment_id":"","amount":"299.00","created_by":5252,"created_at":"2025-08-18 15:14:39","description":"","invoice_num":"01-25112000000173249923","invoice_type":1,"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":"34.4","excluding_tax":"264.6","is_draft":false,"updated_at":"2025-08-18 15:23:02","need_match":true,"need_match_description":"","match_tax_amount":"1.29","simple_match_tax_amount":"0","is_settle":false,"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":48587,"object_type":102,"object_id":2120,"attachment_id":27596,"attachment":{"id":27596,"key":27596,"name":"6950207e-72bd-3e16-832b-a68bc0c71c43","extension":"pdf","path":"\/vue\/attachment\/view\/6950207e-72bd-3e16-832b-a68bc0c71c43\/dzfp_25112000000173249923_SMC(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8_20250818151310.pdf","orig_name":"dzfp_25112000000173249923_SMC(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8_20250818151310.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":830,"sales_invoice_id":2120,"title":"256G","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u786c\u76d8","number":"1","outbound":"1","unit":"\u5757","amount":"299","tax_rate":"13","including_tax":"0","excluding_tax":"264.6","tax_amount":"34.4","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0}],"contract":{"id":4083,"key":4083,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25081871","client_id":12,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}}},"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":1,"tax_rate":["13"],"un_match_tax_amount":33.11,"except_simple_match_tax_amount":33.11,"salesInvoiceProductList":[{"tax_rate":13,"amount":299,"excluding_tax":264.6,"tax_amount":34.4,"list":[{"id":830,"sales_invoice_id":2120,"title":"256G","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u786c\u76d8","number":"1","outbound":"1","unit":"\u5757","amount":"299","tax_rate":"13","including_tax":"0","excluding_tax":"264.6","tax_amount":"34.4","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0}]}],"ready_match":false,"can_update":true,"can_delete":true,"settle_month":"","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,"is_new":false},{"id":2119,"contract_id":4082,"from_date":"2025-08-18","attachment_id":"","amount":"598.00","created_by":5252,"created_at":"2025-08-18 15:13:53","description":"","invoice_num":"02-25112000000173249923","invoice_type":1,"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":"68.79","excluding_tax":"529.21","is_draft":false,"updated_at":"2025-08-18 15:20:40","need_match":true,"need_match_description":"","match_tax_amount":"2.57","simple_match_tax_amount":"0","is_settle":false,"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":48586,"object_type":102,"object_id":2119,"attachment_id":27595,"attachment":{"id":27595,"key":27595,"name":"a410f50d-423c-3b3e-95a3-b7dceee7a92e","extension":"pdf","path":"\/vue\/attachment\/view\/a410f50d-423c-3b3e-95a3-b7dceee7a92e\/dzfp_25112000000173249923_SMC(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8_20250818151310.pdf","orig_name":"dzfp_25112000000173249923_SMC(\u5929\u6d25)\u5236\u9020\u6709\u9650\u516c\u53f8_20250818151310.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":831,"sales_invoice_id":2119,"title":"256G","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u786c\u76d8","number":"2","outbound":"2","unit":"\u5757","amount":"598","tax_rate":"13","including_tax":"0","excluding_tax":"529.21","tax_amount":"68.79","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0}],"contract":{"id":4082,"key":4082,"serial_no":"SMC\u5929\u6d25\u8ba2\u5355POTJ25080879","client_id":12,"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8","sales_rep":5300,"salesRep":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"}}},"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":2,"tax_rate":["13"],"un_match_tax_amount":66.22,"except_simple_match_tax_amount":66.22,"salesInvoiceProductList":[{"tax_rate":13,"amount":598,"excluding_tax":529.21,"tax_amount":68.79,"list":[{"id":831,"sales_invoice_id":2119,"title":"256G","description":"*\u8ba1\u7b97\u673a\u5916\u90e8\u8bbe\u5907*\u786c\u76d8","number":"2","outbound":"2","unit":"\u5757","amount":"598","tax_rate":"13","including_tax":"0","excluding_tax":"529.21","tax_amount":"68.79","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0}]}],"ready_match":false,"can_update":true,"can_delete":true,"settle_month":"","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,"is_new":false},{"id":2118,"contract_id":4086,"from_date":"2025-08-11","attachment_id":"","amount":"11779.00","created_by":5252,"created_at":"2025-08-11 16:32:44","description":"","invoice_num":"25112000000168064532","invoice_type":1,"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":"1049.17","excluding_tax":"10729.83","is_draft":false,"updated_at":"2025-08-11 16:34:39","need_match":true,"need_match_description":"","match_tax_amount":"650.59","simple_match_tax_amount":"0","is_settle":false,"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":48324,"object_type":102,"object_id":2118,"attachment_id":27447,"attachment":{"id":27447,"key":27447,"name":"f5e3484b-0219-3cb2-b63f-2560a262e106","extension":"pdf","path":"\/vue\/attachment\/view\/f5e3484b-0219-3cb2-b63f-2560a262e106\/dzfp_25112000000168064532_\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8_20250811163159.pdf","orig_name":"dzfp_25112000000168064532_\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8_20250811163159.pdf"}}],"salesInvoiceReminders":[],"salesInvoiceProducts":[{"id":828,"sales_invoice_id":2118,"title":"","description":"*\u4fe1\u606f\u7cfb\u7edf\u670d\u52a1*\u670d\u52a1\u8d39","number":"1","outbound":"1","unit":"","amount":"5235","tax_rate":"6","including_tax":"0","excluding_tax":"4938.68","tax_amount":"296.32","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0},{"id":829,"sales_invoice_id":2118,"title":"\u9002\u7528\u4e8eAC-1000- B1400","description":"*\u8f6f\u4ef6*\u6df1\u4fe1\u670dURL\u7cfb\u7edf\u8f6f\u4ef6V5.0","number":"1","outbound":"1","unit":"\u5957","amount":"6544","tax_rate":"13","including_tax":"0","excluding_tax":"5791.15","tax_amount":"752.85","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0}],"contract":{"id":4086,"key":4086,"serial_no":"TS-WZW-2025080401","client_id":2032,"client":{"id":2032,"key":2032,"name":"\u91cd\u5e86\u7075\u72d0\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8(\u9752\u5c9b\u7075\u72d0\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8\/\u5317\u4eac\u4f18\u54c1\u6548\u9500\u79d1\u6280\u6709\u9650\u516c\u53f8)","sales_rep":5295,"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"}}},"coverInvoices":[],"cancelInvoice":{},"redInvoice":{},"invoice_type_display":"\u6570\u7535\u4e13\u7968","including_tax":0,"number":2,"tax_rate":["6","13"],"un_match_tax_amount":398.58,"except_simple_match_tax_amount":398.58,"salesInvoiceProductList":[{"tax_rate":13,"amount":6544,"excluding_tax":5791.15,"tax_amount":752.85,"list":[{"id":829,"sales_invoice_id":2118,"title":"\u9002\u7528\u4e8eAC-1000- B1400","description":"*\u8f6f\u4ef6*\u6df1\u4fe1\u670dURL\u7cfb\u7edf\u8f6f\u4ef6V5.0","number":"1","outbound":"1","unit":"\u5957","amount":"6544","tax_rate":"13","including_tax":"0","excluding_tax":"5791.15","tax_amount":"752.85","need_match":true,"inventory_count":"0","matchPurchaseInvoice":[],"inventory":0}]},{"tax_rate":6,"amount":5235,"excluding_tax":4938.68,"tax_amount":296.32,"list":[{"id":828,"sales_invoice_id":2118,"title":"","description":"*\u4fe1\u606f\u7cfb\u7edf\u670d\u52a1*\u670d\u52a1\u8d39","number":"1","outbound":"1","unit":"","amount":"5235","tax_rate":"6","including_tax":"0","excluding_tax":"4938.68","tax_amount":"296.32","need_match":true,"inventory_count":"","matchPurchaseInvoice":[],"inventory":0}]}],"ready_match":false,"can_update":true,"can_delete":true,"settle_month":"","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,"is_new":false}],"can_create":true,"count":{"count":383,"amount":"83345707.03","excluding_tax":"73558311.08","tax_amount":"8893295.95"},"pagenation":{"totalcount":317,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-16 15:11:59') RETURNING "id"
15:11:59.011traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15:11:59.011traceyii\redis\Connection::executeCommandExecuting Redis Command: SET