SELECT
*
FROM
sp_approve
WHERE
activityId = #{value}
and logicDel = '0'
ORDER BY id DESC
SELECT
*
FROM
sp_approve
WHERE
activityId = #{value}
and approve is not null
and approveType = '30'
and logicDel = '0'
and isActive = '1'
ORDER BY id DESC
SELECT
*
FROM
sp_approve
WHERE
activityId = #{value}
and approveType = '30'
and logicDel = '0'
ORDER BY id desc
SELECT
*
FROM
sp_approve
WHERE
activityId = #{activityId}
and approveType = #{approveType}
and logicDel = '0'
and isActive = '1'
ORDER BY id desc
SELECT
*
FROM
sp_approve
WHERE
activityId = #{activityId}
and approveType = #{approveType}
and logicDel = '0'
and isActive = '1'
and seq = 1
ORDER BY id desc
limit 1
SELECT
*
FROM
sp_approve
WHERE
activityId = #{param1}
and approveType = '30'
and approve is not null
and logicDel = '0'
ORDER BY seq
SELECT
b.realName
FROM
sp_approve a,sp_se_user b
WHERE a.userId = b.id
and a.activityId = #{param1}
and a.approve is not null
and a.logicDel = '0'
and a.isActive = '1'
ORDER BY seq limit 1
SELECT
a.userId
FROM
sp_approve a
WHERE
a.logicDel = '0'
AND a.activityId = #{value}
ORDER BY
a.id DESC
SELECT
IF(a.approve = 'SL10','受理中',IF(a.approve = 'SL20','不受理',IF(a.approve = 'SL30','受理通过',IF(a.approve = 'NONE','未审核',IF(a.approve = 'IN','审核中',IF(a.approve = 'YES','许可',IF(a.approve = 'NO','不许可',IF(a.approve = 'REJECT','打回',IF(a.approve = 'TRANSFER','转交',IF(a.approve = '10','初审中',IF(a.approve = '15','承办方申请重评',IF(a.approve = '20','初审修改',IF(a.approve = '30','初审通过',''))))))))))))) AS approveName
,DATE_FORMAT(a.addTime,'%Y-%m-%d %H:%i:%s') AS addTime
,b.workflowVersion AS serialNumber
,(SELECT r.alias FROM base_region r WHERE r.id=( SELECT IFNULL(w.area,IFNULL(w.city,w.province)) FROM sp_workflow w WHERE w.version = b.workflowVersion LIMIT 1 )) AS permissionOrg
,(SELECT IF(ap.gradeRank = '1','一级',IF(ap.gradeRank = '1','二级',IF(ap.gradeRank = '1','三级',''))) FROM sp_approve ap WHERE ap.approveType = '10' AND ap.activityId = b.id AND ap.isActive = '1' AND ap.logicDel = '0' ORDER BY ap.id desc LIMIT 1) AS gradeRank
,(SELECT am.pgbg FROM sp_activity_material am WHERE am.activityId = b.id) AS pgbg
,(SELECT am.aqgzfa FROM sp_activity_material am WHERE am.activityId = b.id) AS aqgzfa
FROM
sp_approve a,sp_activity b
WHERE a.activityId = b.id
AND a.activityId = #{activityId}
AND a.isActive = '1'
AND a.logicDel = '0'
ORDER BY a.id desc limit 1;
delete from sp_approve where activityId = #{activityId} and approveType = #{approveType}
update sp_approve set isActive = 0 where activityId = #{activityId} and approveType = #{approveType}