package com.haochen.electricity.mapper;
import java.text.MessageFormat;
import java.util.List;
import java.util.Map;
import org.apache.ibatis.jdbc.SQL;
import com.haochen.electricity.entity.InspectionTaskDetail;
import com.haochen.electricity.entity.InspectorDetail;
import com.haochen.electricity.entity.SolverDetail;
import com.haochen.electricity.entity.SolvetaskDetail;
public class DynamitSqlProvider {
// ***************************************巡检任务主表****************************************
public String selectInspectionTaskByCondition(Map<Object,Object> condition){
return new SQL(){
{
SELECT("*");
FROM("ps_inspectiontask_main");
StringBuilder sql=new StringBuilder();
StringBuilder page=new StringBuilder();
sql.append(" 1=1 ");
if(condition.get("inspectionTaskCode")!=null){
sql.append(" and inspectionTaskCode like '%"+condition.get("inspectionTaskCode")+"%'");
}
if(condition.get("lineCode")!=null){
sql.append(" and lineCode like '%"+condition.get("lineCode")+"%'");
}
if(condition.get("taskStatus")!=null){
sql.append(" and taskStatus = "+condition.get("taskStatus"));
}
if(condition.get("issuedByName")!=null){
sql.append(" and issuedByName like '%"+condition.get("issuedByName")+"%'");
}
if(condition.get("byStartTime")!=null){
sql.append(" and issuedTime >= '"+condition.get("byStartTime")+"'");
}
if(condition.get("byEndTime")!=null){
sql.append(" and issuedTime <= '"+condition.get("byEndTime")+"'");
}
if(condition.get("pageNo")!=null && condition.get("pageSize")!=null){
page.append(" id asc limit "+condition.get("pageNo")+","+condition.get("pageSize"));
}
WHERE(sql.toString());
if(condition.get("pageNo")!=null && condition.get("pageSize")!=null){
ORDER_BY(page.toString());
}
}
}.toString();
}
}