测试的sql语句放到mysql中没问题,但是就是放到软件里面就报错,不知道咋解决,求大神指导。
SELECT
a.card_number,
a.customer_name,
a.mobile_phone,
a.customer_address,
a.fault_desc,
a.finisher,
a.receiver,
a.service_home_time,
a.remarks,
a.station_name,
a.finish_time,
b.service_project,
b.old_gasmeter_type,
b.old_gasmeter_number,
b.old_gasmeter_code,
b.new_gasmeter_type,
b.new_gasmeter_number,
b.new_meter_direct,
b.meter_direct,
b.handle_result
FROM
wo_workorder a
INNER JOIN wo_workorder_service b
WHERE
1=1 ${if(len(ssdz)==0,"","and a.station_name='"+ssdz+"'")}
${if(len(fwxm)==0,"","and b.service_project='"+fwxm+"'")}
${if(len(kssj)==0,"","and a.finish_time>='"+kssj+"'")}
${if(len(jssj)==0,"","and a.finish_time<='"+jssj+"'")}
${if(len(cljg)==0,"",(cljg=='实际上门'),"and b.handle_result not in ('电话指导好','重复工单') and a.visit_worst_time is null",
"and b.handle_result in ('电话指导好') and a.visit_worst_time is not null")
}
and a.id = b.workorder_id AND a.finisher IS NOT NULL
ORDER BY
a.station_name DESC, a.service_home_time DESC, a.finish_time DESC
报错信息
78246