<if test=" startSignTime != null">
and c.sign_time >= DATE_FORMAT(#{startSignTime},'%Y-%m-%d 00:00:00')
</if>
<if test=" endSignTime != null">
and c.sign_time <= DATE_FORMAT(#{endSignTime},'%Y-%m-%d 23:59:59')
</if>
<if test=" startSignTime != null">
and c.sign_time >= DATE_FORMAT(#{startSignTime},'%Y-%m-%d 00:00:00')
</if>
<if test=" endSignTime != null">
and c.sign_time <= DATE_FORMAT(#{endSignTime},'%Y-%m-%d 23:59:59')
</if>