All Latest
6944c9c0e9c87: POST https://beta.jinchangxiao.com/vue/erp-sales-outbound/make-sales-order at 2025-12-19 11:42:56 am by 223.72.15.22

Database Queries

总计94条数据
TimeDurationTypeQuery
  
11:42:56.9612.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

11:42:56.9640.5 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

11:42:56.9651.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

11:42:56.9680.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_sales_outbounds" WHERE "id"='76'

11:42:56.9690.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "id"=167

11:42:56.9690.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id"=167

11:42:56.9700.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_product_sns" WHERE "erp_sales_outbound_spent_product_id"=221

11:42:56.9700.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=227

11:42:56.9720.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "id"=172

11:42:56.9730.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE "id"=88

11:42:56.9740.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1

11:42:56.9750.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE 0=1

11:42:56.9750.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2166

11:42:56.9791.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661

11:42:56.9817.1 msINSERTINSERT INTO "a57be577deb434"."tbl_sales_order_items" ("erp_sales_outbound_id", "client_id", "project_id", "product_id", "amount", "is_system", "sales_date", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to", "new_hardware_deadline", "new_software_deadline", "new_maintenance_deadline", "is_renew", "number", "is_merge", "need_sn", "sn", "created_by", "sales_rep", "updated_at") VALUES (76, 1661, 4048, 2166, '4554', TRUE, '2025-12-19', 721, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, FALSE, 1, FALSE, TRUE, NULL, 1001, 1001, 'now()') RETURNING "id"

11:42:56.9891.1 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\SalesOrderItems', 13656, 'a:46:{s:2:"id";i:13656;s:14:"sales_order_id";N;s:10:"product_id";i:2166;s:6:"parent";N;s:2:"sn";N;s:11:"supplier_id";i:721;s:5:"order";N;s:10:"created_by";i:1001;s:10:"created_at";N;s:10:"updated_at";s:19:"1970-01-01 08:00:00";s:2:"pn";N;s:12:"product_type";N;s:17:"product_component";N;s:13:"product_brand";N;s:13:"product_serie";N;s:12:"product_misc";N;s:13:"hardware_from";s:0:"";s:13:"software_from";s:0:"";s:16:"maintenance_from";s:0:"";s:11:"hardware_to";s:0:"";s:11:"software_to";s:0:"";s:14:"maintenance_to";s:0:"";s:21:"new_hardware_deadline";s:0:"";s:21:"new_software_deadline";s:0:"";s:24:"new_maintenance_deadline";s:0:"";s:9:"client_id";i:1661;s:10:"project_id";i:4048;s:9:"sales_rep";i:1001;s:10:"sales_date";s:10:"2025-12-19";s:11:"description";N;s:17:"software_reminded";N;s:17:"hardware_reminded";N;s:20:"maintenance_reminded";N;s:25:"software_advance_reminded";N;s:25:"hardware_advance_reminded";N;s:28:"maintenance_advance_reminded";N;s:9:"is_system";b:1;s:6:"amount";s:4:"4554";s:4:"cost";N;s:8:"is_renew";b:0;s:28:"renew_to_sales_order_item_id";N;s:6:"number";i:1;s:8:"is_merge";b:0;s:7:"need_sn";b:1;s:21:"erp_sales_outbound_id";i:76;s:17:"erp_sales_gift_id";N;}', '', 1001, '223.72.15.22')

11:42:56.9914.3 msSELECTSELECT 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_order_item_remind_receivers' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;

11:42:56.9968.9 msSELECTselect 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_order_item_remind_receivers' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum

11:42:57.0054.8 msINSERTINSERT INTO "a57be577deb434"."tbl_sales_order_item_remind_receivers" ("sales_order_item_id", "user_id") VALUES (13656, 1001) RETURNING "id"

11:42:57.0100.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\SalesOrderItemRemindReceivers', 12385, 'a:3:{s:2:"id";i:12385;s:19:"sales_order_item_id";i:13656;s:7:"user_id";i:1001;}', '', 1001, '223.72.15.22')

11:42:57.0110.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_order_items" WHERE "id"=13656

11:42:57.0121.1 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 13656, 34, 1001, '2025-12-19 11:42:56', '{"id":13656,"sales_order_id":null,"product_id":2166,"parent":null,"sn":null,"supplier_id":721,"order":0,"created_by":1001,"created_at":"2025-12-19 11:42:56","updated_at":"2025-12-19 11:42:56","pn":null,"product_type":null,"product_component":null,"product_brand":null,"product_serie":null,"product_misc":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"new_hardware_deadline":null,"new_software_deadline":null,"new_maintenance_deadline":null,"client_id":1661,"project_id":4048,"sales_rep":1001,"sales_date":"2025-12-19","description":null,"software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"4554","cost":null,"is_renew":false,"renew_to_sales_order_item_id":null,"number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":76,"erp_sales_gift_id":null}', '{"id":13656,"sales_order_id":null,"product_id":2166,"parent":null,"sn":null,"supplier_id":721,"order":0,"created_by":1001,"created_at":"2025-12-19 11:42:56","updated_at":"2025-12-19 11:42:56","pn":null,"product_type":null,"product_component":null,"product_brand":null,"product_serie":null,"product_misc":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"new_hardware_deadline":null,"new_software_deadline":null,"new_maintenance_deadline":null,"client_id":1661,"project_id":4048,"sales_rep":1001,"sales_date":"2025-12-19","description":null,"software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"4554","cost":null,"is_renew":false,"renew_to_sales_order_item_id":null,"number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":76,"erp_sales_gift_id":null}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":[]}') RETURNING "id"

11:42:57.0130.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 591563, 'a:13:{s:2:"id";i:591563;s:9:"object_id";i:13656;s:11:"object_type";i:34;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:1001:"{"id":13656,"sales_order_id":null,"product_id":2166,"parent":null,"sn":null,"supplier_id":721,"order":0,"created_by":1001,"created_at":"2025-12-19 11:42:56","updated_at":"2025-12-19 11:42:56","pn":null,"product_type":null,"product_component":null,"product_brand":null,"product_serie":null,"product_misc":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"new_hardware_deadline":null,"new_software_deadline":null,"new_maintenance_deadline":null,"client_id":1661,"project_id":4048,"sales_rep":1001,"sales_date":"2025-12-19","description":null,"software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"4554","cost":null,"is_renew":false,"renew_to_sales_order_item_id":null,"number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":76,"erp_sales_gift_id":null}";s:9:"new_value";s:1001:"{"id":13656,"sales_order_id":null,"product_id":2166,"parent":null,"sn":null,"supplier_id":721,"order":0,"created_by":1001,"created_at":"2025-12-19 11:42:56","updated_at":"2025-12-19 11:42:56","pn":null,"product_type":null,"product_component":null,"product_brand":null,"product_serie":null,"product_misc":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"new_hardware_deadline":null,"new_software_deadline":null,"new_maintenance_deadline":null,"client_id":1661,"project_id":4048,"sales_rep":1001,"sales_date":"2025-12-19","description":null,"software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"4554","cost":null,"is_renew":false,"renew_to_sales_order_item_id":null,"number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":76,"erp_sales_gift_id":null}";s:11:"description";s:93:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-12-19 11:42:56";s:9:"is_delete";N;}', '', 1001, '223.72.15.22')

11:42:57.0140.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661

11:42:57.0221.1 msUPDATEUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=1661

11:42:57.02419.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=1661) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1

11:42:57.0442.7 msSELECTSELECT 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_client_am_change_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;

11:42:57.0477.9 msSELECTselect 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_client_am_change_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum

11:42:57.0555.6 msINSERTINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (1661, 1001, 'now()', NULL) RETURNING "id"

11:42:57.0611.6 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 187471, 'a:5:{s:2:"id";i:187471;s:9:"client_id";i:1661;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '223.72.15.22')

11:42:57.0630.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 1661, 'a:0:{}', '', 1001, '223.72.15.22')

11:42:57.0640.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2166

11:42:57.0640.8 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 1661, 10, 13656, 34, 1001, '[13656]', '[13656]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":["Q28-100G-A5H"]}') RETURNING "id"

11:42:57.0650.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 591564, 'a:13:{s:2:"id";i:591564;s:9:"object_id";i:1661;s:11:"object_type";i:10;s:9:"target_id";i:13656;s:18:"target_object_type";i:34;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:7:"[13656]";s:9:"new_value";s:7:"[13656]";s:11:"description";s:107:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":["Q28-100G-A5H"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '223.72.15.22')

11:42:57.0660.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4048

11:42:57.0671.1 msUPDATEUPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=4048

11:42:57.0691.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4048) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1

11:42:57.0710.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4048, 'a:0:{}', '', 1001, '223.72.15.22')

11:42:57.0720.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661

11:42:57.0720.8 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 4048, 1, 13656, 34, 1001, '[13656]', '[13656]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":["Q28-100G-A5H"]}') RETURNING "id"

11:42:57.0730.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 591565, 'a:13:{s:2:"id";i:591565;s:9:"object_id";i:4048;s:11:"object_type";i:1;s:9:"target_id";i:13656;s:18:"target_object_type";i:34;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:7:"[13656]";s:9:"new_value";s:7:"[13656]";s:11:"description";s:107:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":["Q28-100G-A5H"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '223.72.15.22')

11:42:57.0740.8 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 721, 12, 13656, 34, 1001, '[13656]', '[13656]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":["Q28-100G-A5H"]}') RETURNING "id"

11:42:57.0750.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 591566, 'a:13:{s:2:"id";i:591566;s:9:"object_id";i:721;s:11:"object_type";i:12;s:9:"target_id";i:13656;s:18:"target_object_type";i:34;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:7:"[13656]";s:9:"new_value";s:7:"[13656]";s:11:"description";s:107:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":["Q28-100G-A5H"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '223.72.15.22')

11:42:57.0760.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "id"=166

11:42:57.0760.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_products" WHERE "erp_sales_outbound_product_id"=166

11:42:57.0760.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_spent_product_sns" WHERE "erp_sales_outbound_spent_product_id"=220

11:42:57.0770.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_inventory_products" WHERE "id"=230

11:42:57.0770.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbound_products" WHERE "id"=178

11:42:57.0770.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_inbounds" WHERE "id"=91

11:42:57.0780.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_inventory_start_products" WHERE 0=1

11:42:57.0780.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_purchase_gift_products" WHERE 0=1

11:42:57.0780.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=1774

11:42:57.0790.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661

11:42:57.0791.8 msINSERTINSERT INTO "a57be577deb434"."tbl_sales_order_items" ("erp_sales_outbound_id", "client_id", "project_id", "product_id", "amount", "is_system", "sales_date", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to", "new_hardware_deadline", "new_software_deadline", "new_maintenance_deadline", "is_renew", "number", "is_merge", "need_sn", "sn", "created_by", "sales_rep", "updated_at") VALUES (76, 1661, 4048, 1774, '5345', TRUE, '2025-12-19', 431, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, FALSE, 1, FALSE, TRUE, NULL, 1001, 1001, 'now()') RETURNING "id"

11:42:57.0810.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\SalesOrderItems', 13657, 'a:46:{s:2:"id";i:13657;s:14:"sales_order_id";N;s:10:"product_id";i:1774;s:6:"parent";N;s:2:"sn";N;s:11:"supplier_id";i:431;s:5:"order";N;s:10:"created_by";i:1001;s:10:"created_at";N;s:10:"updated_at";s:19:"1970-01-01 08:00:00";s:2:"pn";N;s:12:"product_type";N;s:17:"product_component";N;s:13:"product_brand";N;s:13:"product_serie";N;s:12:"product_misc";N;s:13:"hardware_from";s:0:"";s:13:"software_from";s:0:"";s:16:"maintenance_from";s:0:"";s:11:"hardware_to";s:0:"";s:11:"software_to";s:0:"";s:14:"maintenance_to";s:0:"";s:21:"new_hardware_deadline";s:0:"";s:21:"new_software_deadline";s:0:"";s:24:"new_maintenance_deadline";s:0:"";s:9:"client_id";i:1661;s:10:"project_id";i:4048;s:9:"sales_rep";i:1001;s:10:"sales_date";s:10:"2025-12-19";s:11:"description";N;s:17:"software_reminded";N;s:17:"hardware_reminded";N;s:20:"maintenance_reminded";N;s:25:"software_advance_reminded";N;s:25:"hardware_advance_reminded";N;s:28:"maintenance_advance_reminded";N;s:9:"is_system";b:1;s:6:"amount";s:4:"5345";s:4:"cost";N;s:8:"is_renew";b:0;s:28:"renew_to_sales_order_item_id";N;s:6:"number";i:1;s:8:"is_merge";b:0;s:7:"need_sn";b:1;s:21:"erp_sales_outbound_id";i:76;s:17:"erp_sales_gift_id";N;}', '', 1001, '223.72.15.22')

11:42:57.0820.8 msINSERTINSERT INTO "a57be577deb434"."tbl_sales_order_item_remind_receivers" ("sales_order_item_id", "user_id") VALUES (13657, 1001) RETURNING "id"

11:42:57.0830.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\SalesOrderItemRemindReceivers', 12386, 'a:3:{s:2:"id";i:12386;s:19:"sales_order_item_id";i:13657;s:7:"user_id";i:1001;}', '', 1001, '223.72.15.22')

11:42:57.0840.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_order_items" WHERE "id"=13657

11:42:57.0850.8 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 13657, 34, 1001, '2025-12-19 11:42:57', '{"id":13657,"sales_order_id":null,"product_id":1774,"parent":null,"sn":null,"supplier_id":431,"order":0,"created_by":1001,"created_at":"2025-12-19 11:42:57","updated_at":"2025-12-19 11:42:57","pn":null,"product_type":null,"product_component":null,"product_brand":null,"product_serie":null,"product_misc":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"new_hardware_deadline":null,"new_software_deadline":null,"new_maintenance_deadline":null,"client_id":1661,"project_id":4048,"sales_rep":1001,"sales_date":"2025-12-19","description":null,"software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"5345","cost":null,"is_renew":false,"renew_to_sales_order_item_id":null,"number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":76,"erp_sales_gift_id":null}', '{"id":13657,"sales_order_id":null,"product_id":1774,"parent":null,"sn":null,"supplier_id":431,"order":0,"created_by":1001,"created_at":"2025-12-19 11:42:57","updated_at":"2025-12-19 11:42:57","pn":null,"product_type":null,"product_component":null,"product_brand":null,"product_serie":null,"product_misc":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"new_hardware_deadline":null,"new_software_deadline":null,"new_maintenance_deadline":null,"client_id":1661,"project_id":4048,"sales_rep":1001,"sales_date":"2025-12-19","description":null,"software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"5345","cost":null,"is_renew":false,"renew_to_sales_order_item_id":null,"number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":76,"erp_sales_gift_id":null}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":[]}') RETURNING "id"

11:42:57.0850.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 591567, 'a:13:{s:2:"id";i:591567;s:9:"object_id";i:13657;s:11:"object_type";i:34;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:1001:"{"id":13657,"sales_order_id":null,"product_id":1774,"parent":null,"sn":null,"supplier_id":431,"order":0,"created_by":1001,"created_at":"2025-12-19 11:42:57","updated_at":"2025-12-19 11:42:57","pn":null,"product_type":null,"product_component":null,"product_brand":null,"product_serie":null,"product_misc":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"new_hardware_deadline":null,"new_software_deadline":null,"new_maintenance_deadline":null,"client_id":1661,"project_id":4048,"sales_rep":1001,"sales_date":"2025-12-19","description":null,"software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"5345","cost":null,"is_renew":false,"renew_to_sales_order_item_id":null,"number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":76,"erp_sales_gift_id":null}";s:9:"new_value";s:1001:"{"id":13657,"sales_order_id":null,"product_id":1774,"parent":null,"sn":null,"supplier_id":431,"order":0,"created_by":1001,"created_at":"2025-12-19 11:42:57","updated_at":"2025-12-19 11:42:57","pn":null,"product_type":null,"product_component":null,"product_brand":null,"product_serie":null,"product_misc":null,"hardware_from":null,"software_from":null,"maintenance_from":null,"hardware_to":null,"software_to":null,"maintenance_to":null,"new_hardware_deadline":null,"new_software_deadline":null,"new_maintenance_deadline":null,"client_id":1661,"project_id":4048,"sales_rep":1001,"sales_date":"2025-12-19","description":null,"software_reminded":false,"hardware_reminded":false,"maintenance_reminded":false,"software_advance_reminded":false,"hardware_advance_reminded":false,"maintenance_advance_reminded":false,"is_system":true,"amount":"5345","cost":null,"is_renew":false,"renew_to_sales_order_item_id":null,"number":1,"is_merge":false,"need_sn":true,"erp_sales_outbound_id":76,"erp_sales_gift_id":null}";s:11:"description";s:93:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-12-19 11:42:57";s:9:"is_delete";N;}', '', 1001, '223.72.15.22')

11:42:57.0860.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661

11:42:57.0870.8 msUPDATEUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=1661

11:42:57.0889.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=1661) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1

11:42:57.0980.9 msINSERTINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (1661, 1001, 'now()', NULL) RETURNING "id"

11:42:57.0990.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 187472, 'a:5:{s:2:"id";i:187472;s:9:"client_id";i:1661;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '223.72.15.22')

11:42:57.1000.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 1661, 'a:0:{}', '', 1001, '223.72.15.22')

11:42:57.1000.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=1774

11:42:57.1010.8 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 1661, 10, 13657, 34, 1001, '[13657]', '[13657]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":["\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248"]}') RETURNING "id"

11:42:57.1020.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 591568, 'a:13:{s:2:"id";i:591568;s:9:"object_id";i:1661;s:11:"object_type";i:10;s:9:"target_id";i:13657;s:18:"target_object_type";i:34;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:7:"[13657]";s:9:"new_value";s:7:"[13657]";s:11:"description";s:156:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":["\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '223.72.15.22')

11:42:57.1020.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4048

11:42:57.1040.8 msUPDATEUPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=4048

11:42:57.1041.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4048) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1

11:42:57.1060.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4048, 'a:0:{}', '', 1001, '223.72.15.22')

11:42:57.1070.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661

11:42:57.1070.7 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 4048, 1, 13657, 34, 1001, '[13657]', '[13657]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":["\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248"]}') RETURNING "id"

11:42:57.1080.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 591569, 'a:13:{s:2:"id";i:591569;s:9:"object_id";i:4048;s:11:"object_type";i:1;s:9:"target_id";i:13657;s:18:"target_object_type";i:34;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:7:"[13657]";s:9:"new_value";s:7:"[13657]";s:11:"description";s:156:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":["\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '223.72.15.22')

11:42:57.1090.7 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 431, 12, 13657, 34, 1001, '[13657]', '[13657]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":["\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248"]}') RETURNING "id"

11:42:57.1100.9 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 591570, 'a:13:{s:2:"id";i:591570;s:9:"object_id";i:431;s:11:"object_type";i:12;s:9:"target_id";i:13657;s:18:"target_object_type";i:34;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:7:"[13657]";s:9:"new_value";s:7:"[13657]";s:11:"description";s:156:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":["\u901f\u77f3\u8ba1\u7b97\u4e91\u670d\u52a1-\u4f01\u4e1a\u7248"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '223.72.15.22')

11:42:57.1110.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_outbound_id"=76

11:42:57.1112.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_order_items" WHERE "erp_sales_outbound_id"=76

11:42:57.1140.9 msUPDATEUPDATE "a57be577deb434"."tbl_erp_sales_outbounds" SET "is_sales_order_ready"=TRUE WHERE "id"=76

11:42:57.1150.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOutbounds', 76, 'a:0:{}', '', 1001, '223.72.15.22')

11:42:57.1160.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4048

11:42:57.1160.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4048

11:42:57.1160.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4048 ORDER BY "id"

11:42:57.1192.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("project_id"=4048) AND (erp_sales_outbound_id is not null)

11:42:57.1221.0 msUPDATEUPDATE "a57be577deb434"."tbl_projects" SET "is_sales_order_ready"=TRUE WHERE "id"=4048

11:42:57.1231.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4048) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1

11:42:57.1240.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4048, 'a:0:{}', '', 1001, '223.72.15.22')

11:42:57.1250.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=1661

11:42:57.1250.8 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'sales_outbound', 76, 20008, 1001, 'now()', '[]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u751f\u6210\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":[]}'), (1, 'sales_outbound', 4048, 1, 1001, 'now()', '[]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u751f\u6210\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":[]}')

11:42:57.1273.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-12-19')

11:42:57.1310.7 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=93, "last_visit_at"='now()' WHERE "id"=59605

11:42:57.1321.0 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-sales-outbound/make-sales-order', '{"id":"76","items":{"166":{"is_merge":"0","hardware_from":"","hardware_to":"","software_from":"","software_to":"","maintenance_from":"","maintenance_to":""},"167":{"is_merge":"0","hardware_from":"","hardware_to":"","software_from":"","software_to":"","maintenance_from":"","maintenance_to":""}},"web_access_token":"yb8YvQDqCxvGUQWSJnYL2S9XtkD7pVRr"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"223.72.15.22","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko\/20100101 Firefox\/146.0"}', FALSE, '2025-12-19 11:42:57') RETURNING "id"