programs_info/三资项目/章敏/修改流程主题名称语法.txt

UPDATE flow_main
LEFT JOIN apply_change_project apply ON apply.id = flow_main.form_id
LEFT JOIN pro_main ON pro_main.id = apply.pro_id
LEFT JOIN frame_user ON frame_user.id = flow_main.created_by 
SET flow_main.apply_theme = concat( ifnull( frame_user.truename, '' ), '_', pro_main.proName, '_', flow_main.flow_name ) 
WHERE
	flow_main.flow_type IN ( 'change_project' );
UPDATE flow_main
LEFT JOIN apply_project apply ON apply.id = flow_main.form_id
LEFT JOIN pro_main ON pro_main.id = apply.pro_id
LEFT JOIN frame_user ON frame_user.id = flow_main.created_by 
SET flow_main.apply_theme = concat( ifnull( frame_user.truename, '' ), '_', pro_main.proName, '_', flow_main.flow_name ) 
WHERE
	flow_main.flow_type IN ( 'start_project' );
UPDATE flow_main
LEFT JOIN apply_end_project apply ON apply.id = flow_main.form_id
LEFT JOIN pro_main ON pro_main.id = apply.table_pro_main_id
LEFT JOIN frame_user ON frame_user.id = flow_main.created_by 
SET flow_main.apply_theme = concat( ifnull( frame_user.truename, '' ), '_', pro_main.proName, '_', flow_main.flow_name ) 
WHERE
	flow_main.flow_type IN ( 'end_project' );
UPDATE flow_main
LEFT JOIN apply_change_project_proposal apply ON apply.id = flow_main.form_id
LEFT JOIN pro_main ON pro_main.id = apply.table_pro_main_id
LEFT JOIN frame_user ON frame_user.id = flow_main.created_by 
SET flow_main.apply_theme = concat( ifnull( frame_user.truename, '' ), '_', pro_main.proName, '_', flow_main.flow_name ) 
WHERE
	flow_main.flow_type IN ( 'change_project_proposal', 'change_project_proposal1' );
UPDATE flow_main
LEFT JOIN apply_project_proposal apply ON apply.id = flow_main.form_id
LEFT JOIN pro_main ON pro_main.id = apply.table_pro_main_id
LEFT JOIN frame_user ON frame_user.id = flow_main.created_by 
SET flow_main.apply_theme = concat( ifnull( frame_user.truename, '' ), '_', pro_main.proName, '_', flow_main.flow_name ) 
WHERE
	flow_main.flow_type IN ( 'project_proposal', 'project_proposal1' );