123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960 |
- [pas:0.0.0.0:8877] [,] 2023-12-13 11:12:22.893 DEBUG 15248 [main] cn.cslg.pas.mapper.TreeNodeMapper.selectList ==> Preparing: SELECT id,name,type,parent_id,type_id,path,level,create_id,create_time,description FROM tree_node WHERE (id = ?)
- [pas:0.0.0.0:8877] [,] 2023-12-13 11:12:22.909 DEBUG 15248 [main] cn.cslg.pas.mapper.TreeNodeMapper.selectList ==> Parameters: [2023](ArrayList)
- [pas:0.0.0.0:8877] [,] 2023-12-13 11:12:22.921 DEBUG 15248 [main] cn.cslg.pas.mapper.TreeNodeMapper.selectList <== Total: 0
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:13:36.485 DEBUG 8600 [http-nio-8877-exec-4] cn.cslg.pas.mapper.CustomFieldMapper.getCustomField ==> Preparing: select id,name,description,project_id as projectId,type as type,status,create_id as createId,create_time as createTime from custom_field where project_id='101' limit 0,10
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:13:36.492 DEBUG 8600 [http-nio-8877-exec-4] cn.cslg.pas.mapper.CustomFieldMapper.getCustomField ==> Parameters:
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:13:36.514 DEBUG 8600 [http-nio-8877-exec-4] cn.cslg.pas.mapper.CustomFieldMapper.getCustomField <== Total: 6
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:13:36.516 DEBUG 8600 [http-nio-8877-exec-4] cn.cslg.pas.mapper.CustomFieldMapper.getCustomFieldCount ==> Preparing: select count(*) from custom_field where project_id='101'
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:13:36.517 DEBUG 8600 [http-nio-8877-exec-4] cn.cslg.pas.mapper.CustomFieldMapper.getCustomFieldCount ==> Parameters:
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:13:36.519 DEBUG 8600 [http-nio-8877-exec-4] cn.cslg.pas.mapper.CustomFieldMapper.getCustomFieldCount <== Total: 1
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:14:00.170 DEBUG 8600 [http-nio-8877-exec-9] cn.cslg.pas.mapper.SystemDictMapper.selectList ==> Preparing: SELECT id,label,value,type,group_type FROM os_system_dict WHERE (group_type = ?)
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:14:00.171 DEBUG 8600 [http-nio-8877-exec-9] cn.cslg.pas.mapper.SystemDictMapper.selectList ==> Parameters: ASSESS(String)
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:14:00.174 DEBUG 8600 [http-nio-8877-exec-9] cn.cslg.pas.mapper.SystemDictMapper.selectList <== Total: 20
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:14:00.191 DEBUG 8600 [http-nio-8877-exec-10] cn.cslg.pas.mapper.ReportProjectMapper.getReportProject ==> Preparing: select distinct p.id as id,p.name as name ,rp.sign_patent_no as signPatentNo,p.contract_no as contract_no,p.volume_number as volumeNumber,p.commission_case_day as commissionCaseDay,p.description as description,p.create_id as createId,p.create_time as createTime, rp.report_type as reportType ,p.head_id as headId,p.department_id as departmentId, p.entrust_type as entrustType,p.entrust_id as entrustId,rp.product_or_tech as productOrTech,rp.cron_description as cronDescription ,rp.status as status from report as rp left join project as p on rp.project_id =p.id left join asso_report_cron arc on p.id =arc.project_id left join asso_project_event as aspe on p.id =aspe.project_id order by p.create_time desc limit 0,10
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:14:00.192 DEBUG 8600 [http-nio-8877-exec-10] cn.cslg.pas.mapper.ReportProjectMapper.getReportProject ==> Parameters:
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:14:00.197 DEBUG 8600 [http-nio-8877-exec-10] cn.cslg.pas.mapper.ReportProjectMapper.getReportProject <== Total: 10
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:08.608 DEBUG 7368 [http-nio-8877-exec-3] cn.cslg.pas.mapper.SystemDictMapper.selectList ==> Preparing: SELECT id,label,value,type,group_type FROM os_system_dict WHERE (group_type = ?)
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:08.615 DEBUG 7368 [http-nio-8877-exec-3] cn.cslg.pas.mapper.SystemDictMapper.selectList ==> Parameters: ASSESS(String)
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:08.624 DEBUG 7368 [http-nio-8877-exec-3] cn.cslg.pas.mapper.SystemDictMapper.selectList <== Total: 20
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:08.659 DEBUG 7368 [http-nio-8877-exec-4] cn.cslg.pas.mapper.ReportProjectMapper.getReportProject ==> Preparing: select distinct p.id as id,p.name as name ,rp.sign_patent_no as signPatentNo,p.contract_no as contract_no,p.volume_number as volumeNumber,p.commission_case_day as commissionCaseDay,p.description as description,p.create_id as createId,p.create_time as createTime, rp.report_type as reportType ,p.head_id as headId,p.department_id as departmentId, p.entrust_type as entrustType,p.entrust_id as entrustId,rp.product_or_tech as productOrTech,rp.cron_description as cronDescription ,rp.status as status from report as rp left join project as p on rp.project_id =p.id left join asso_report_cron arc on p.id =arc.project_id left join asso_project_event as aspe on p.id =aspe.project_id order by p.create_time desc limit 0,10
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:08.660 DEBUG 7368 [http-nio-8877-exec-4] cn.cslg.pas.mapper.ReportProjectMapper.getReportProject ==> Parameters:
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:08.666 DEBUG 7368 [http-nio-8877-exec-4] cn.cslg.pas.mapper.ReportProjectMapper.getReportProject <== Total: 10
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:20.834 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProductCategoryMapper.getProductCategory ==> Preparing: select distinct category.id as id,category.name as name,category.license_rate as licenseRate,category.show_type as showType,category.description,category.create_id as createId,category.create_time as createTime, category.tenant from product_category as category left join product as product on category.id = product.category_id order by category.create_time desc limit 0,10
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:20.834 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProductCategoryMapper.getProductCategory ==> Parameters:
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:20.840 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProductCategoryMapper.getProductCategory <== Total: 5
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:20.842 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProductCategoryMapper.getProductCategoryCount ==> Preparing: select count(*) from (select distinct category.id as id from product_category as category left join product as product on category.id = product.category_id ) as c
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:20.842 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProductCategoryMapper.getProductCategoryCount ==> Parameters:
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:20.845 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProductCategoryMapper.getProductCategoryCount <== Total: 1
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:20.848 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.AssoProductCategoryFileMapper.selectList ==> Preparing: SELECT id,product_category_id,file_guid,create_id,create_time FROM asso_product_category_file WHERE (product_category_id IN (?,?,?,?,?))
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:20.849 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.AssoProductCategoryFileMapper.selectList ==> Parameters: 17(Integer), 16(Integer), 9(Integer), 8(Integer), 7(Integer)
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:20.850 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.AssoProductCategoryFileMapper.selectList <== Total: 3
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:22.883 DEBUG 7368 [http-nio-8877-exec-9] cn.cslg.pas.mapper.PatentProjectMapper.getPatentProject ==> Preparing: select distinct p.id as id,p.name as name ,p.contract_no as contract_no,p.volume_number as volumeNumber,p.commission_case_day as commissionCaseDay,p.description as description,p.create_id as createId,p.create_time as createTime,pp.if_update as ifUpdate,pp.crons as crons, p.entrust_type as entrustType,p.entrust_id as entrustId,p.head_id as headId,p.department_id as departmentId from patent_project as pp left join project as p on pp.project_id =p.id left join asso_project_tree_node as aspt on p.id =aspt.project_id left join asso_project_event as aspe on p.id = aspe.project_id order by p.create_time desc limit 0,10
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:22.884 DEBUG 7368 [http-nio-8877-exec-9] cn.cslg.pas.mapper.PatentProjectMapper.getPatentProject ==> Parameters:
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:22.888 DEBUG 7368 [http-nio-8877-exec-9] cn.cslg.pas.mapper.PatentProjectMapper.getPatentProject <== Total: 9
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:22.888 DEBUG 7368 [http-nio-8877-exec-9] cn.cslg.pas.mapper.PatentProjectMapper.getPatentProjectCount ==> Preparing: select count(*) from (select distinct p.id from patent_project as pp left join project as p on pp.project_id =p.id left join asso_project_tree_node as aspt on p.id =aspt.project_id left join asso_project_event as aspe on p.id =aspe.project_id ) as c
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:22.889 DEBUG 7368 [http-nio-8877-exec-9] cn.cslg.pas.mapper.PatentProjectMapper.getPatentProjectCount ==> Parameters:
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:22.891 DEBUG 7368 [http-nio-8877-exec-9] cn.cslg.pas.mapper.PatentProjectMapper.getPatentProjectCount <== Total: 1
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.414 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.EventMapper.getEvent ==> Preparing: select id,name,description,client_id as clientId,scenario_id as scenarioId,event_date as eventDate,create_id as createId,create_time as createTime from event order by create_time desc limit 0,10
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.415 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.EventMapper.getEvent ==> Parameters:
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.418 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.EventMapper.getEvent <== Total: 10
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.419 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.EventMapper.getEventCount ==> Preparing: select count(*) from event
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.419 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.EventMapper.getEventCount ==> Parameters:
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.421 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.EventMapper.getEventCount <== Total: 1
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.424 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.AssoEventFileMapper.selectList ==> Preparing: SELECT id,event_id,file_guid,create_id,create_time FROM asso_event_file WHERE (event_id IN (?,?,?,?,?,?,?,?,?,?))
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.424 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.AssoEventFileMapper.selectList ==> Parameters: 70(Integer), 69(Integer), 68(Integer), 67(Integer), 66(Integer), 65(Integer), 64(Integer), 62(Integer), 61(Integer), 60(Integer)
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.427 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.AssoEventFileMapper.selectList <== Total: 2
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.429 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.AssoProjectEventMapper.getEventProjectCount ==> Preparing: select event_id as eventId,project_type as projectType,count(*) as projectCount from pas_prod2.asso_project_event WHERE event_id in ( ? or ? or ? or ? or ? or ? or ? or ? or ? or ? ) group by event_id,project_type
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.430 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.AssoProjectEventMapper.getEventProjectCount ==> Parameters: 70(Integer), 69(Integer), 68(Integer), 67(Integer), 66(Integer), 65(Integer), 64(Integer), 62(Integer), 61(Integer), 60(Integer)
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:24.432 DEBUG 7368 [http-nio-8877-exec-2] cn.cslg.pas.mapper.AssoProjectEventMapper.getEventProjectCount <== Total: 0
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:28.104 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProjectTaskMapper.getProjectTask ==> Preparing: select id,name,project_id,type,handler,handler_type as handlerType,deadline_time as deadLineTime,finish_time as finishTime, description, last_task_id as lastTaskId,asso_task_id as assoTaskId,status,process_id as processId,progress,result,create_id as createId,create_time as createTime from project_task order by create_time desc limit 0,10
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:28.104 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProjectTaskMapper.getProjectTask ==> Parameters:
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:28.109 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProjectTaskMapper.getProjectTask <== Total: 10
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:28.110 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProjectTaskMapper.getProjectTaskCount ==> Preparing: select count(*) from project_task
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:28.110 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProjectTaskMapper.getProjectTaskCount ==> Parameters:
- [pas:0.0.0.0:8877] [,] 2023-12-20 16:17:28.112 DEBUG 7368 [http-nio-8877-exec-5] cn.cslg.pas.mapper.ProjectTaskMapper.getProjectTaskCount <== Total: 1
- [pas:0.0.0.0:8877] [,] 2023-12-26 10:10:57.794 DEBUG 18752 [http-nio-8877-exec-1] cn.cslg.pas.mapper.ReportAffairMapper.selectList ==> Preparing: SELECT id,affair_type,project_id,occurred_time,description,create_id,create_time FROM report_affair WHERE (project_id = ?)
- [pas:0.0.0.0:8877] [,] 2023-12-26 10:10:57.800 DEBUG 18752 [http-nio-8877-exec-1] cn.cslg.pas.mapper.ReportAffairMapper.selectList ==> Parameters: 101(Integer)
- [pas:0.0.0.0:8877] [,] 2023-12-26 10:10:57.809 DEBUG 18752 [http-nio-8877-exec-1] cn.cslg.pas.mapper.ReportAffairMapper.selectList <== Total: 0
- [pas:0.0.0.0:8877] [,] 2023-12-26 10:10:57.822 DEBUG 18752 [http-nio-8877-exec-2] cn.cslg.pas.mapper.ReportProjectMapper.getReportProject ==> Preparing: select distinct p.id as id,p.name as name ,rp.sign_patent_no as signPatentNo,p.contract_no as contract_no,p.volume_number as volumeNumber,p.commission_case_day as commissionCaseDay,p.description as description,p.create_id as createId,p.create_time as createTime, rp.report_type as reportType ,p.head_id as headId,p.department_id as departmentId, p.entrust_type as entrustType,p.entrust_id as entrustId,rp.product_or_tech as productOrTech,rp.cron_description as cronDescription ,rp.status as status from report as rp left join project as p on rp.project_id =p.id left join asso_report_cron arc on p.id =arc.project_id left join asso_project_event as aspe on p.id =aspe.project_id where p.id='101'
- [pas:0.0.0.0:8877] [,] 2023-12-26 10:10:57.823 DEBUG 18752 [http-nio-8877-exec-2] cn.cslg.pas.mapper.ReportProjectMapper.getReportProject ==> Parameters:
- [pas:0.0.0.0:8877] [,] 2023-12-26 10:10:57.830 DEBUG 18752 [http-nio-8877-exec-2] cn.cslg.pas.mapper.ReportProjectMapper.getReportProject <== Total: 1
|