<#if ( jeecgP3demo.createName )?? && jeecgP3demo.createName ?length gt 0> /* 创建人名称 */ and jp.create_name like CONCAT('%', :jeecgP3demo.createName ,'%') <#if ( jeecgP3demo.createBy )?? && jeecgP3demo.createBy ?length gt 0> /* 创建人登录名称 */ and jp.create_by like CONCAT('%', :jeecgP3demo.createBy ,'%') <#if ( jeecgP3demo.createDate )??> /* 创建日期 */ and jp.create_date = :jeecgP3demo.createDate <#if ( jeecgP3demo.updateName )?? && jeecgP3demo.updateName ?length gt 0> /* 更新人名称 */ and jp.update_name like CONCAT('%', :jeecgP3demo.updateName ,'%') <#if ( jeecgP3demo.updateBy )?? && jeecgP3demo.updateBy ?length gt 0> /* 更新人登录名称 */ and jp.update_by like CONCAT('%', :jeecgP3demo.updateBy ,'%') <#if ( jeecgP3demo.updateDate )??> /* 更新日期 */ and jp.update_date = :jeecgP3demo.updateDate <#if ( jeecgP3demo.sysOrgCode )?? && jeecgP3demo.sysOrgCode ?length gt 0> /* 所属部门 */ and jp.sys_org_code like CONCAT('%', :jeecgP3demo.sysOrgCode ,'%') <#if ( jeecgP3demo.sysCompanyCode )?? && jeecgP3demo.sysCompanyCode ?length gt 0> /* 所属公司 */ and jp.sys_company_code like CONCAT('%', :jeecgP3demo.sysCompanyCode ,'%') <#if ( jeecgP3demo.bpmStatus )?? && jeecgP3demo.bpmStatus ?length gt 0> /* 流程状态 */ and jp.bpm_status like CONCAT('%', :jeecgP3demo.bpmStatus ,'%') <#if ( jeecgP3demo.name )?? && jeecgP3demo.name ?length gt 0> /* 姓名 */ and jp.name like CONCAT('%', :jeecgP3demo.name ,'%') <#if ( jeecgP3demo.sex )?? && jeecgP3demo.sex ?length gt 0> /* 性别 */ and jp.sex like CONCAT('%', :jeecgP3demo.sex ,'%') <#if ( jeecgP3demo.age )?? && jeecgP3demo.age ?length gt 0> /* 年龄 */ and jp.age like CONCAT('%', :jeecgP3demo.age ,'%') <#if ( jeecgP3demo.address )?? && jeecgP3demo.address ?length gt 0> /* 地址 */ and jp.address like CONCAT('%', :jeecgP3demo.address ,'%') <#if ( jeecgP3demo.phone )?? && jeecgP3demo.phone ?length gt 0> /* 电话 */ and jp.phone like CONCAT('%', :jeecgP3demo.phone ,'%') <#if ( jeecgP3demo.memo )?? && jeecgP3demo.memo ?length gt 0> /* 备注 */ and jp.memo like CONCAT('%', :jeecgP3demo.memo ,'%')