| | |
|---|
| | | left join (select pap.id,pap.`name` as plan_name,pp.`name` as pro_name |
|---|
| | | from pr_assembly_plan pap, plt_product pp where pap.pro_id = pp.id) p on t.plan_id = p.id |
|---|
| | | left JOIN ba_user u on u.id=t.updated_by), |
|---|
| | | WITH assistants_total as (select t.device_no,t.curr_node,t.node_content,t.number,p.pro_name, p.plan_name,u.id user_id,u.`name` user_name |
|---|
| | | assistants_total as (select t.device_no,t.curr_node,t.node_content,t.number,p.pro_name, p.plan_name,u.id user_id,u.`name` user_name |
|---|
| | | FROM |
|---|
| | | ( SELECT a.*,SUBSTRING_INDEX( SUBSTRING_INDEX( a.assistants, ',', b.help_topic_id + 1 ), ',', - 1 ) AS assistant FROM |
|---|
| | | (select DISTINCT device_no,plan_id,station_id,curr_node,node_content,number,updated_by,assistants from sta_device_production_log_past |
|---|
| | |
|---|
| | | FROM |
|---|
| | | (SELECT COUNT(DISTINCT user_id) AS count_user,'require_attend' AS title FROM total WHERE user_id !='' |
|---|
| | | UNION |
|---|
| | | SELECT COUNT(DISTINCT user_id) AS count_user,'actual_attend' AS title FROM total WHERE user_id !='' AND login_time <![CDATA[ < ]]> #{todayDt,jdbcType=TIMESTAMP}) record |
|---|
| | | SELECT COUNT(DISTINCT user_id) AS count_user,'actual_attend' AS title FROM total WHERE user_id !='' AND login_time <![CDATA[ > ]]> #{todayDt,jdbcType=TIMESTAMP}) record |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | <delete id="deleteByPrimaryKey" parameterType="java.lang.Long"> |
|---|
