ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6896e8dbde153: GET https://beta.jinchangxiao.com/vue/analysis/purchase-collected-payment-collection at 2025-08-09 02:21:15 pm by 114.119.146.195

Log Messages

总计42条数据
TimeLevelCategoryMessage
 
14:21:15.909traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
14:21:15.909traceyii\base\Module::getModuleLoading module: debug
14:21:15.909traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
14:21:15.909traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
14:21:15.909traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
14:21:15.909traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:21:15.910traceyii\base\Module::getModuleLoading module: gii
14:21:15.910traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
14:21:15.910traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
14:21:15.910traceyii\web\Application::handleRequestRoute requested: 'vue/analysis/purchase-collected-payment-collection'
14:21:15.910traceyii\base\Module::getModuleLoading module: vue
14:21:15.911infoyii\web\Session::openSession started
14:21:15.911infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:21:15.911infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:21:15.916traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:21:15.917traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:21:15.917traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:21:15.917traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:21:15.917infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:21:15.919traceyii\base\Controller::runActionRoute to run: vue/analysis/purchase-collected-payment-collection
14:21:15.919traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:21:15.920traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
14:21:15.920traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\AnalysisController::actionPurchaseCollectedPaymentCollection()
14:21:15.925infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT sc.*, scp.collected, sci.invoiced, a.approve_amount, sc.amount - a.approve_amount as un_approve_amount, (sc.amount - scp.collected) as uncollected, CASE WHEN sc.including_tax = true THEN (sc.amount - sci.invoiced) ELSE 0 END as uninvoiced, (od_total_this - od_collected) as overdue, CASE WHEN od.remind_date IS NOT NULL THEN 0 WHEN (sc.amount - scp.collected) > 0 THEN 1 ELSE 2 END AS status, CASE WHEN sc.amount - scp.collected > 0 THEN ( CASE WHEN od_total_this - od_collected > 0 THEN max_date ELSE min_date END ) ELSE null END AS sort_date FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_suppliers" "c" ON sc.supplier_id = c.id LEFT JOIN (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1) )) "sub") "scp2" ON scp2.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, t0.erp_settle_amount AS collected FROM "a57be577deb434"."tbl_purchase_contracts" "t0" GROUP BY "t0"."id") "scp" ON scp.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS invoiced FROM "a57be577deb434"."tbl_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT COALESCE(sum(r.amount), 0) as approve_amount, r.purchase_contract_id as contract_id FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (dt1.taxonomy_id = 2100000000) AND ("r"."status"=2) GROUP BY "contract_id") "a" ON a.contract_id = sc.id LEFT JOIN (SELECT max(sub.total_this) as od_total_this, max(sub.collected) as od_collected, max(sub.remind_date) as remind_date, sub.id FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT "id" AS "contract_id", "erp_settle_amount" AS "collected" FROM "a57be577deb434"."tbl_purchase_contracts" GROUP BY "id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id WHERE remind_date <= '2025-08-09') "sub" WHERE collected < total_this GROUP BY "sub"."id") "od" ON od.id = sc.id LEFT JOIN (SELECT sub.id, min(sub.remind_date) min_date FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT "id" AS "contract_id", "erp_settle_amount" AS "collected" FROM "a57be577deb434"."tbl_purchase_contracts" GROUP BY "id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id) "sub" WHERE (collected < total_this) AND (remind_date > now()) GROUP BY "sub"."id") "mind" ON mind.id = sc.id LEFT JOIN (SELECT sub.id, max(sub.remind_date) max_date FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT "id" AS "contract_id", "erp_settle_amount" AS "collected" FROM "a57be577deb434"."tbl_purchase_contracts" GROUP BY "id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id) "sub" WHERE (collected < total_this) AND (remind_date <= '2025-08-09') GROUP BY "sub"."id") "maxd" ON maxd.id = sc.id WHERE (sc.is_draft = false) AND (sc.is_refuse = false) GROUP BY "sc"."id", "scp"."collected", "sci"."invoiced", "od"."od_total_this", "od"."od_collected", "od"."remind_date", "sort_date", "a"."approve_amount" ORDER BY "sc"."signed_at" DESC, "sc"."created_at" DESC) "c"
14:21:16.018infoyii\db\Command::querySELECT sc.*, scp.collected, sci.invoiced, a.approve_amount, sc.amount - a.approve_amount as un_approve_amount, (sc.amount - scp.collected) as uncollected, CASE WHEN sc.including_tax = true THEN (sc.amount - sci.invoiced) ELSE 0 END as uninvoiced, (od_total_this - od_collected) as overdue, CASE WHEN od.remind_date IS NOT NULL THEN 0 WHEN (sc.amount - scp.collected) > 0 THEN 1 ELSE 2 END AS status, CASE WHEN sc.amount - scp.collected > 0 THEN ( CASE WHEN od_total_this - od_collected > 0 THEN max_date ELSE min_date END ) ELSE null END AS sort_date FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_suppliers" "c" ON sc.supplier_id = c.id LEFT JOIN (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1) )) "sub") "scp2" ON scp2.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, t0.erp_settle_amount AS collected FROM "a57be577deb434"."tbl_purchase_contracts" "t0" GROUP BY "t0"."id") "scp" ON scp.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS invoiced FROM "a57be577deb434"."tbl_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT COALESCE(sum(r.amount), 0) as approve_amount, r.purchase_contract_id as contract_id FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (dt1.taxonomy_id = 2100000000) AND ("r"."status"=2) GROUP BY "contract_id") "a" ON a.contract_id = sc.id LEFT JOIN (SELECT max(sub.total_this) as od_total_this, max(sub.collected) as od_collected, max(sub.remind_date) as remind_date, sub.id FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT "id" AS "contract_id", "erp_settle_amount" AS "collected" FROM "a57be577deb434"."tbl_purchase_contracts" GROUP BY "id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id WHERE remind_date <= '2025-08-09') "sub" WHERE collected < total_this GROUP BY "sub"."id") "od" ON od.id = sc.id LEFT JOIN (SELECT sub.id, min(sub.remind_date) min_date FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT "id" AS "contract_id", "erp_settle_amount" AS "collected" FROM "a57be577deb434"."tbl_purchase_contracts" GROUP BY "id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id) "sub" WHERE (collected < total_this) AND (remind_date > now()) GROUP BY "sub"."id") "mind" ON mind.id = sc.id LEFT JOIN (SELECT sub.id, max(sub.remind_date) max_date FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT "id" AS "contract_id", "erp_settle_amount" AS "collected" FROM "a57be577deb434"."tbl_purchase_contracts" GROUP BY "id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id) "sub" WHERE (collected < total_this) AND (remind_date <= '2025-08-09') GROUP BY "sub"."id") "maxd" ON maxd.id = sc.id WHERE (sc.is_draft = false) AND (sc.is_refuse = false) GROUP BY "sc"."id", "scp"."collected", "sci"."invoiced", "od"."od_total_this", "od"."od_collected", "od"."remind_date", "sort_date", "a"."approve_amount" ORDER BY "sc"."signed_at" DESC, "sc"."created_at" DESC LIMIT 20
14:21:16.102traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:21:16.103infoyii\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_purchase_contracts' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
14:21:16.111infoyii\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_purchase_contracts' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
14:21:16.128traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:21:16.128traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
14:21:16.128infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 138, 608, 262, 236, 505, 478, 626, 280)
14:21:16.129infoyii\db\Command::querySELECT "id", "id" AS "key", "contract_id", "remind_date" AS "name", "amount" AS "value", "overdue_days" FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE "contract_id" IN (4073, 4079, 4077, 4072, 4070, 4069, 4067, 4066, 4063, 4062, 4060, 4059, 4058, 4057, 4053, 4052, 4051, 4045, 4042, 4041) ORDER BY "remind_date"
14:21:16.130infoyii\db\Command::querySELECT sum(amount) as amount, sum(collected) as collected, sum(approve_amount) as approve_amount, sum(amount - collected) as uncollected FROM (SELECT sc.*, scp.collected, sci.invoiced, a.approve_amount, sc.amount - a.approve_amount as un_approve_amount, (sc.amount - scp.collected) as uncollected, CASE WHEN sc.including_tax = true THEN (sc.amount - sci.invoiced) ELSE 0 END as uninvoiced, (od_total_this - od_collected) as overdue, CASE WHEN od.remind_date IS NOT NULL THEN 0 WHEN (sc.amount - scp.collected) > 0 THEN 1 ELSE 2 END AS status, CASE WHEN sc.amount - scp.collected > 0 THEN ( CASE WHEN od_total_this - od_collected > 0 THEN max_date ELSE min_date END ) ELSE null END AS sort_date FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_suppliers" "c" ON sc.supplier_id = c.id LEFT JOIN (SELECT * FROM ((SELECT '1' || r.id::varchar as id, 1 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1)) UNION ALL ( SELECT '2' || r.id::varchar as id, 2 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1) ) UNION ALL ( SELECT '3' || r.id::varchar as id, 3 as ticket_type, r.purchase_contract_id as contract_id, r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1) ) UNION ALL ( SELECT '4' || r.id::varchar as id, 4 as ticket_type, r.purchase_contract_id as contract_id, 0 - r.amount as amount, t.created_at::timestamp without time zone as collected_date, t.created_at, t.created_by, t.abstract as description FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE "t"."status" IN (2, 5, 1) )) "sub") "scp2" ON scp2.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, t0.erp_settle_amount AS collected FROM "a57be577deb434"."tbl_purchase_contracts" "t0" GROUP BY "t0"."id") "scp" ON scp.contract_id = sc.id LEFT JOIN (SELECT t0.id AS contract_id, COALESCE(sum(t1.amount), 0) AS invoiced FROM "a57be577deb434"."tbl_purchase_contracts" "t0" LEFT JOIN "a57be577deb434"."tbl_purchase_contract_invoices" "t1" ON t0.id = t1.contract_id GROUP BY "t0"."id") "sci" ON sci.contract_id = sc.id LEFT JOIN (SELECT COALESCE(sum(r.amount), 0) as approve_amount, r.purchase_contract_id as contract_id FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 WHERE (dt1.taxonomy_id = 2100000000) AND ("r"."status"=2) GROUP BY "contract_id") "a" ON a.contract_id = sc.id LEFT JOIN (SELECT max(sub.total_this) as od_total_this, max(sub.collected) as od_collected, max(sub.remind_date) as remind_date, sub.id FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT "id" AS "contract_id", "erp_settle_amount" AS "collected" FROM "a57be577deb434"."tbl_purchase_contracts" GROUP BY "id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id WHERE remind_date <= '2025-08-09') "sub" WHERE collected < total_this GROUP BY "sub"."id") "od" ON od.id = sc.id LEFT JOIN (SELECT sub.id, min(sub.remind_date) min_date FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT "id" AS "contract_id", "erp_settle_amount" AS "collected" FROM "a57be577deb434"."tbl_purchase_contracts" GROUP BY "id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id) "sub" WHERE (collected < total_this) AND (remind_date > now()) GROUP BY "sub"."id") "mind" ON mind.id = sc.id LEFT JOIN (SELECT sub.id, max(sub.remind_date) max_date FROM (SELECT ( SELECT sum(scpcrdsub.amount) as total_this FROM a57be577deb434.tbl_purchase_contract_payment_collection_remind_dates scpcrdsub where scpcrdsub.remind_date <= scpcrd.remind_date and scpcrdsub.contract_id = scpcrd.contract_id ), scpcrd.remind_date, sc.collected, sc.id FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" "scpcrd" LEFT JOIN (SELECT sc.*, case when scp.collected is not null then scp.collected else 0 end as collected FROM "a57be577deb434"."tbl_purchase_contracts" "sc" LEFT JOIN (SELECT "id" AS "contract_id", "erp_settle_amount" AS "collected" FROM "a57be577deb434"."tbl_purchase_contracts" GROUP BY "id") "scp" ON scp.contract_id = sc.id GROUP BY "sc"."id", "scp"."collected") "sc" ON scpcrd.contract_id = sc.id) "sub" WHERE (collected < total_this) AND (remind_date <= '2025-08-09') GROUP BY "sub"."id") "maxd" ON maxd.id = sc.id WHERE (sc.is_draft = false) AND (sc.is_refuse = false) GROUP BY "sc"."id", "scp"."collected", "sci"."invoiced", "od"."od_total_this", "od"."od_collected", "od"."remind_date", "sort_date", "a"."approve_amount" ORDER BY "signed_at" DESC) "sub"
14:21:16.209traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:21:16.209traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:21:16.209infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-08-09')
14:21:16.215traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:21:16.215traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
14:21:16.215infoyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=42, "last_visit_at"='now()' WHERE "id"=54996
14:21:16.217infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/purchase-collected-payment-collection', '[]', '{"code":2000,"result":{"list":[{"id":4073,"supplier_id":431,"contract_type":4,"signed_at":"2025-08-08","amount":"9343","handler":1013,"description":"","contract_scan":"","created_by":5252,"created_at":"2025-08-04 11:50:12","updated_at":"2025-08-07 11:56:35","client_id":"","project_id":"","sales_rep":"","serial_no":"\u6d4b\u8bd5\u6d4b\u8bd5","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":"","is_chargeback":true,"cost_type":2,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"5000","erp_un_settle_amount":"4343","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"collected":"5000","invoiced":"1.00","approve_amount":"","un_approve_amount":"","uncollected":"4343","uninvoiced":"9342.00","overdue":"","status":1,"sort_date":"","supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u8d39\u7528\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":4079,"supplier_id":431,"contract_type":1,"signed_at":"2025-08-07","amount":"23323","handler":1011,"description":"\u6d4b\u8bd5","contract_scan":"","created_by":1001,"created_at":"2025-08-07 11:40:00","updated_at":"2025-08-07 11:40:00","client_id":"","project_id":"","sales_rep":"","serial_no":"\u6d4b\u8bd5","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"1","erp_un_settle_amount":"23322","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"collected":"1","invoiced":"0","approve_amount":"","un_approve_amount":"","uncollected":"23322","uninvoiced":"23323","overdue":"","status":1,"sort_date":"","supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":4077,"supplier_id":431,"contract_type":1,"signed_at":"2025-08-05","amount":"3000","handler":1011,"description":"","contract_scan":"","created_by":1001,"created_at":"2025-08-05 17:21:29","updated_at":"2025-08-05 17:21:29","client_id":"","project_id":"","sales_rep":"","serial_no":"","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"3000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"collected":"0","invoiced":"0","approve_amount":"","un_approve_amount":"","uncollected":"3000","uninvoiced":"3000","overdue":"","status":1,"sort_date":"","supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":4072,"supplier_id":431,"contract_type":1,"signed_at":"2025-08-04","amount":"53400","handler":1011,"description":"","contract_scan":"","created_by":5252,"created_at":"2025-08-04 11:00:32","updated_at":"2025-08-04 12:35:51","client_id":"","project_id":"","sales_rep":"","serial_no":"\u6d4b\u8bd5\u8c01\u662f\u8c01","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":false,"save_collection_at":"","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"7292","erp_un_settle_amount":"46108","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"collected":"7292","invoiced":"4.00","approve_amount":"6224","un_approve_amount":"47176","uncollected":"46108","uninvoiced":"53396.00","overdue":"","status":1,"sort_date":"","supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":4070,"supplier_id":138,"contract_type":1,"signed_at":"2025-07-25","amount":"18000.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-25 17:04:56","updated_at":"2025-07-28 10:08:54","client_id":"","project_id":"","sales_rep":"","serial_no":"H202507255159","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-25 17:05:06","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"18000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"collected":"0","invoiced":"0","approve_amount":"18000","un_approve_amount":"0.00","uncollected":"18000.00","uninvoiced":"18000.00","overdue":"18000","status":0,"sort_date":"2025-07-28","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":807,"key":807,"contract_id":4070,"name":"2025-07-28","value":"18000","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f12\u5929","overdue_amount":18000,"remind_date":"2025-07-28"},{"id":4069,"supplier_id":608,"contract_type":1,"signed_at":"2025-07-25","amount":"130.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-25 16:45:53","updated_at":"2025-07-25 16:46:01","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4651203278745161702\t","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-25 16:46:01","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"130","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"collected":"0","invoiced":"130","approve_amount":"130","un_approve_amount":"0.00","uncollected":"130.00","uninvoiced":"0.00","overdue":"130","status":0,"sort_date":"2025-07-31","supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseContractPaymentCollectionRemindDates":[{"id":806,"key":806,"contract_id":4069,"name":"2025-07-31","value":"130","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f9\u5929","overdue_amount":130,"remind_date":"2025-07-31"},{"id":4067,"supplier_id":262,"contract_type":1,"signed_at":"2025-07-24","amount":"397.01","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-24 14:55:07","updated_at":"2025-07-24 14:55:19","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7\uff1a327559652672","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-24 14:55:19","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"397.01","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"collected":"0","invoiced":"397.01","approve_amount":"397.01","un_approve_amount":"0.00","uncollected":"397.01","uninvoiced":"0.00","overdue":"397.01","status":0,"sort_date":"2025-07-25","supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseContractPaymentCollectionRemindDates":[{"id":805,"key":805,"contract_id":4067,"name":"2025-07-25","value":"397.01","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f15\u5929","overdue_amount":397.01,"remind_date":"2025-07-25"},{"id":4066,"supplier_id":608,"contract_type":1,"signed_at":"2025-07-24","amount":"520.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-07-24 13:51:17","updated_at":"2025-07-24 13:51:34","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4649415087350592710","payment_collection_remind_ahead":"2 days","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-24 13:51:34","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"520","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"collected":"0","invoiced":"520","approve_amount":"520","un_approve_amount":"0.00","uncollected":"520.00","uninvoiced":"0.00","overdue":"520","status":0,"sort_date":"2025-08-08","supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseContractPaymentCollectionRemindDates":[{"id":804,"key":804,"contract_id":4066,"name":"2025-08-08","value":"520","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f1\u5929","overdue_amount":520,"remind_date":"2025-08-08"},{"id":4063,"supplier_id":236,"contract_type":3,"signed_at":"2025-07-23","amount":"3000.00","handler":1011,"description":"PA\u914d\u7f6e\u7ffb\u8bd1\uff1b\n\u66ff\u6362\u8bbe\u5907\u5b9e\u65bd\uff08\u5468\u672b\uff09","contract_scan":"","created_by":1011,"created_at":"2025-07-23 14:42:05","updated_at":"2025-07-23 14:42:15","client_id":"","project_id":"","sales_rep":"","serial_no":"","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-23 14:42:15","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"3000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"collected":"0","invoiced":"0","approve_amount":"","un_approve_amount":"","uncollected":"3000.00","uninvoiced":"3000.00","overdue":"3000","status":0,"sort_date":"2025-07-28","supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":802,"key":802,"contract_id":4063,"name":"2025-07-28","value":"3000","overdue_days":""}],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f12\u5929","overdue_amount":3000,"remind_date":"2025-07-28"},{"id":4062,"supplier_id":262,"contract_type":1,"signed_at":"2025-07-22","amount":"2000.00","handler":1011,"description":"\u5151\u4ed8\u79ef\u5206\u8f6c\u793c\u54c1\u5361\u91c7\u8d2d\u5408\u540c","contract_scan":"","created_by":1011,"created_at":"2025-07-23 10:52:39","updated_at":"2025-07-23 10:52:50","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7\uff1a 327609705325","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-23 10:52:50","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"2000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"collected":"0","invoiced":"2000","approve_amount":"2000","un_approve_amount":"0.00","uncollected":"2000.00","uninvoiced":"0.00","overdue":"2000","status":0,"sort_date":"2025-07-25","supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseContractPaymentCollectionRemindDates":[{"id":801,"key":801,"contract_id":4062,"name":"2025-07-25","value":"2000","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f15\u5929","overdue_amount":2000,"remind_date":"2025-07-25"},{"id":4060,"supplier_id":505,"contract_type":1,"signed_at":"2025-07-21","amount":"49848.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-07-22 09:19:29","updated_at":"2025-07-22 09:19:50","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250721-ZHF-002","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-22 09:19:50","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"49848","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"collected":"0","invoiced":"0","approve_amount":"","un_approve_amount":"","uncollected":"49848.00","uninvoiced":"49848.00","overdue":"","status":1,"sort_date":"2025-08-22","supplier":{"id":505,"key":505,"name":"\u795e\u5dde\u6167\u667a\uff08\u5317\u4eac\uff09\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":797,"key":797,"contract_id":4060,"name":"2025-08-22","value":"49848","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":"2025-08-22"},{"id":4059,"supplier_id":236,"contract_type":1,"signed_at":"2025-07-21","amount":"47000.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-07-21 17:15:57","updated_at":"2025-07-21 17:16:08","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250721-ZHF-001","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-21 17:16:08","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"47000","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"collected":"47000","invoiced":"0","approve_amount":"47000","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"47000.00","overdue":"","status":2,"sort_date":"","supplier":{"id":236,"key":236,"name":"\u5317\u4eac\u5929\u4fe1\u5b8f\u8fbe\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":796,"key":796,"contract_id":4059,"name":"2025-07-22","value":"47000","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":4058,"supplier_id":478,"contract_type":1,"signed_at":"2025-07-21","amount":"250.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-21 16:32:24","updated_at":"2025-07-22 10:53:23","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250721-HYF-003","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-22 10:53:23","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"250","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"collected":"0","invoiced":"0","approve_amount":"","un_approve_amount":"","uncollected":"250.00","uninvoiced":"250.00","overdue":"","status":1,"sort_date":"2025-08-21","supplier":{"id":478,"key":478,"name":"\u5317\u4eac\u957f\u987a\u7f51\u8054\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":799,"key":799,"contract_id":4058,"name":"2025-08-21","value":"250","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":"2025-08-21"},{"id":4057,"supplier_id":626,"contract_type":1,"signed_at":"2025-07-21","amount":"520.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-21 16:31:30","updated_at":"2025-07-22 13:26:17","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250721-HYF-002","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-22 13:26:17","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"520","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"collected":"0","invoiced":"0","approve_amount":"","un_approve_amount":"","uncollected":"520.00","uninvoiced":"520.00","overdue":"","status":1,"sort_date":"2025-08-21","supplier":{"id":626,"key":626,"name":"\u5317\u4eac\u6167\u79d1\u5929\u6b63\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":800,"key":800,"contract_id":4057,"name":"2025-08-21","value":"520","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":"2025-08-21"},{"id":4053,"supplier_id":280,"contract_type":1,"signed_at":"2025-07-21","amount":"8000.00","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-07-21 13:22:15","updated_at":"2025-07-21 13:22:30","client_id":"","project_id":"","sales_rep":"","serial_no":"A20250721","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-21 13:22:30","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"8000","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"collected":"0","invoiced":"0","approve_amount":"","un_approve_amount":"","uncollected":"8000.00","uninvoiced":"8000.00","overdue":"","status":1,"sort_date":"2025-08-21","supplier":{"id":280,"key":280,"name":"\u5317\u4eac\u6210\u6d77\u661f\u6cb3\u79d1\u6280\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":791,"key":791,"contract_id":4053,"name":"2025-08-21","value":"8000","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":"2025-08-21"},{"id":4052,"supplier_id":608,"contract_type":1,"signed_at":"2025-07-21","amount":"658.63","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-07-21 11:21:01","updated_at":"2025-07-21 11:21:21","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4643512058994592710\/4643515981688592710","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-21 11:21:21","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"658.63","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"collected":"0","invoiced":"260","approve_amount":"658.63","un_approve_amount":"0.00","uncollected":"658.63","uninvoiced":"398.63","overdue":"658.63","status":0,"sort_date":"2025-07-31","supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseContractPaymentCollectionRemindDates":[{"id":790,"key":790,"contract_id":4052,"name":"2025-07-31","value":"658.63","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f9\u5929","overdue_amount":658.63,"remind_date":"2025-07-31"},{"id":4051,"supplier_id":138,"contract_type":3,"signed_at":"2025-07-21","amount":"900.00","handler":1011,"description":"","contract_scan":"","created_by":1011,"created_at":"2025-07-21 11:18:14","updated_at":"2025-07-25 09:02:47","client_id":"","project_id":"","sales_rep":"","serial_no":"TSKJ20250721-HYF-001","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-21 11:18:58","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"900","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"collected":"900","invoiced":"900","approve_amount":"900","un_approve_amount":"0.00","uncollected":"0.00","uninvoiced":"0.00","overdue":"","status":2,"sort_date":"","supplier":{"id":138,"key":138,"name":"\u6df1\u4fe1\u670d\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"purchaseContractPaymentCollectionRemindDates":[{"id":788,"key":788,"contract_id":4051,"name":"2025-07-21","value":"900","overdue_days":1}],"contract_type_display":"\u670d\u52a1\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""},{"id":4045,"supplier_id":608,"contract_type":1,"signed_at":"2025-07-17","amount":"197.75","handler":5360,"description":"","contract_scan":"","created_by":5360,"created_at":"2025-07-17 13:18:04","updated_at":"2025-07-17 13:18:21","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4635961815999592710","payment_collection_remind_ahead":"1 day","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-17 13:18:21","is_chargeback":false,"cost_type":1,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"197.75","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":false,"erp_cash_cost_ticket_is_verify":false,"collected":"0","invoiced":"0","approve_amount":"197.75","un_approve_amount":"0.00","uncollected":"197.75","uninvoiced":"197.75","overdue":"197.75","status":0,"sort_date":"2025-07-25","supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseContractPaymentCollectionRemindDates":[{"id":786,"key":786,"contract_id":4045,"name":"2025-07-25","value":"197.75","overdue_days":""}],"contract_type_display":"\u4ea7\u54c1\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f15\u5929","overdue_amount":197.75,"remind_date":"2025-07-25"},{"id":4042,"supplier_id":608,"contract_type":4,"signed_at":"2025-07-16","amount":"2147.52","handler":1011,"description":"\u6280\u672f\u90e8\u81ea\u7528-\u84dd\u5149\u5149\u9a71","contract_scan":"","created_by":1011,"created_at":"2025-07-16 15:47:04","updated_at":"2025-08-07 12:03:24","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7: 4634557275452161702","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-07-16 15:47:17","is_chargeback":false,"cost_type":2,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"0","erp_un_settle_amount":"2147.52","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"collected":"0","invoiced":"260.52","approve_amount":"260.52","un_approve_amount":"1887.00","uncollected":"2147.52","uninvoiced":"1887.00","overdue":"260.52","status":0,"sort_date":"2025-07-18","supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseContractPaymentCollectionRemindDates":[{"id":784,"key":784,"contract_id":4042,"name":"2025-07-18","value":"260.52","overdue_days":""}],"contract_type_display":"\u8d39\u7528\u5408\u540c","collect_status_display":"\u672a\u5b8c\u6210","overdue_display":"\u903e\u671f22\u5929","overdue_amount":260.52,"remind_date":"2025-07-18"},{"id":4041,"supplier_id":262,"contract_type":4,"signed_at":"2025-07-16","amount":"108.46","handler":1011,"description":"\u6280\u672f\u90e8\u81ea\u7528-\u5149\u76d8","contract_scan":"","created_by":1011,"created_at":"2025-07-16 15:45:43","updated_at":"2025-08-07 12:39:48","client_id":"","project_id":"","sales_rep":"","serial_no":"\u8ba2\u5355\u53f7\uff1a 326492438280","payment_collection_remind_ahead":"00:00:00","including_tax":true,"is_save_collection":true,"save_collection_at":"2025-08-07 12:23:12","is_chargeback":false,"cost_type":2,"is_draft":false,"is_verify":false,"is_refuse":false,"erp_settle_amount":"108.46","erp_un_settle_amount":"0","erp_payment_ticket_is_verify":false,"erp_collect_ticket_is_verify":"","erp_cash_cost_ticket_is_verify":false,"collected":"108.46","invoiced":"107.46","approve_amount":"107.46","un_approve_amount":"1.00","uncollected":"0.00","uninvoiced":"1.00","overdue":"","status":2,"sort_date":"","supplier":{"id":262,"key":262,"name":"\u4eac\u4e1c\u5546\u57ce"},"purchaseContractPaymentCollectionRemindDates":[{"id":810,"key":810,"contract_id":4041,"name":"2025-07-18","value":"107.46","overdue_days":20}],"contract_type_display":"\u8d39\u7528\u5408\u540c","collect_status_display":"\u5df2\u5b8c\u6210","overdue_display":"","overdue_amount":0,"remind_date":""}],"count":{"amount":"482920406.62","collected":"218673118.15","approve_amount":"31467162.90","uncollected":"264247288.47","un_approve_amount":451453243.72},"pagenation":{"totalcount":2011,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-09 14:21:16') RETURNING "id"
14:21:16.219traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14:21:16.219traceyii\redis\Connection::executeCommandExecuting Redis Command: SET