| | |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | <select id="queryPlanList" resultType="cn.hutool.json.JSONObject"> |
|---|
| | | select pp.`name` as pro_name, p.`name` ,p.number, p.output_number, concat(round(((p.output_number/p.number) * 100 ),0), '%') as complete_rate ,p.end_date |
|---|
| | | select pp.`name` as pro_name, p.`name` ,p.number, p.output_number, concat(round(((p.output_number/p.number) * 100 ),0), '%') as complete_rate ,p.end_date, |
|---|
| | | TIMESTAMPDIFF(DAY, NOW(),p.end_date) AS days_difference |
|---|
| | | from (SELECT * FROM pr_assembly_plan WHERE STATUS = 1 and deleted = 0) p |
|---|
| | | LEFT JOIN plt_product pp |
|---|
| | | on p.pro_id = pp.id |
|---|
