id,
Num_ID,
User_ID,
Organization,
User_name,
Terminal_ID,
Operate_Name,
Operate_Type,
Operate_Time,
Operate_Condition,
Operate_Result,
syncStatus
select t1.id,
'20190816114900025' as Reg_ID,
ifnull(Num_ID, '') Num_ID,
ifnull(User_ID, '') User_ID,
ifnull(Organization, '') Organization,
ifnull(t2.organCode,'') Organization_ID,
ifnull(User_name, '') User_name,
ifnull(Terminal_ID, '') Terminal_ID,
ifnull(Operate_Name, '') Operate_Name,
ifnull(Operate_Type, '') Operate_Type,
ifnull(Operate_Time, '') Operate_Time,
ifnull(Operate_Condition, '') Operate_Condition,
ifnull(Operate_Result, '') Operate_Result,
syncStatus
from log_audit t1
left join sp_se_user t2 on t1.user_id = t2.username
where syncStatus is null
order by Operate_Time
LIMIT #{limits}
update log_audit
set syncStatus=#{updatedSyncStatus}
where id in
#{item}
select
id,
'20190816114900025' as Reg_ID,
ifnull(Num_ID, '') Num_ID,
ifnull(User_ID, '') User_ID,
ifnull(Organization, '') Organization,
ifnull(User_name, '') User_name,
ifnull(Terminal_ID, '') Terminal_ID,
ifnull(Operate_Name, '') Operate_Name,
ifnull(Operate_Type, '') Operate_Type,
ifnull(Operate_Time, '') Operate_Time,
ifnull(Operate_Condition, '') Operate_Condition,
ifnull(Operate_Result, '无') Operate_Result,
syncStatus
from log_audit
WHERE 1=1
and Operate_Time>=#{startDate}
and User_ID=#{userId}
and (
Terminal_ID like concat(concat('%',#{keyword}),'%')
or Operate_Name like concat(concat('%',#{keyword}),'%')
or Organization like concat(concat('%',#{keyword}),'%')
or user_Name like concat(concat('%',#{keyword}),'%')
)
order by Operate_Time desc
limit #{iDisplayStart},#{iDisplayLength}
select
count(id)
from log_audit
WHERE 1=1
and Operate_Time>=#{startDate}
and User_ID=#{userId}
and (
Terminal_ID like concat(concat('%',#{keyword}),'%')
or Operate_Name like concat(concat('%',#{keyword}),'%')
or Organization like concat(concat('%',#{keyword}),'%')
or user_Name like concat(concat('%',#{keyword}),'%')
)
order by Operate_Time desc
select
count(id)
from log_operate
WHERE 1=1
and addTime>=#{startDate}
and userId=#{userId}
and result=#{result}
and province=#{province}
and city=#{city}
and area=#{area}
and (
ip like concat(concat('%',#{keyword}),'%')
or menuName like concat(concat('%',#{keyword}),'%')
or operateObj like concat(concat('%',#{keyword}),'%')
or operateType like concat(concat('%',#{keyword}),'%')
or userName like concat(concat('%',#{keyword}),'%')
)