0 #end #if ($criteria.nwsn_networknodeid || $criteria.nwn_networkid) and po_code = nwsn_id #end #if ($criteria.nwn_networkid) and nwsn_networknodeid = nwn_id #end #if ($criteria.phone_number) and cl_no_as400 = billing_number #end #if ($criteria.macaddress || $criteria.serialno || $criteria.speedcode) and client.cl_no = customernumber #if ($rawValue.criteria.statut_equipement == 'actif') and ((disableddate is null) OR (disableddate > { fn NOW() })) #elseif ($rawValue.criteria.statut_equipement == 'inactif') and ((disableddate is not null) AND (disableddate <= { fn NOW() })) #end #end #if ($criteria.macaddress || $criteria.serialno) and equipmentshistory.noequipment = equipments.noequipment #end #if ($criteria.ip_complet) and client.cl_no = ip_util.cl_no #end #if ($criteria.login_alias) and (exists ( select * from acces where client.cl_no = acces.cl_no and ac_login #if ($rawValue.criteria.login_alias_operator == "egale") = $criteria.login_alias #else like '%$rawValue.criteria.login_alias%' {escape '\'} #end #if ($rawValue.criteria.statut_login_alias == 'actif') and ((ac_inactif is null) or (ac_inactif > { fn NOW() })) #elseif ($rawValue.criteria.statut_login_alias == 'inactif') and ((ac_inactif is not null) and (ac_inactif <= { fn NOW() })) #end ) or exists ( select * from alias where client.cl_no = alias.cl_no and al_alias #if ($rawValue.criteria.login_alias_operator == "egale") = $criteria.login_alias #else like '%$rawValue.criteria.login_alias%' {escape '\'} #end #if ($rawValue.criteria.statut_login_alias == 'actif') and ((al_inactif is null) or (al_inactif > { fn NOW() })) #elseif ($rawValue.criteria.statut_login_alias == 'inactif') and ((al_inactif is not null) and (al_inactif <= { fn NOW() })) #end )) #end #if ($rawValue.criteria.statut_client == 'actif') and client.cl_no = multimedia.cl_no and ((mu_inactif is null) or (mu_inactif > { fn NOW() })) #elseif ($rawValue.criteria.statut_client == 'inactif') and client.cl_no = multimedia.cl_no and ((mu_inactif is not null) and (mu_inactif <= { fn NOW() })) #end #if ($criteria.cl_telephone) #if ($rawValue.criteria.cl_telephone_operator == "egale") and cl_telephone = $criteria.cl_telephone #else and (cl_telephone is not null and cl_telephone like '%$rawValue.criteria.cl_telephone%' {escape '\'}) #end #end #if ($criteria.cl_client) and (cl_client is not null and cl_client like '%$rawValue.criteria.cl_client%' {escape '\'}) #end #if ($criteria.cl_rue) and (cl_rue is not null and cl_rue like '%$rawValue.criteria.cl_rue%' {escape '\'}) #end #if ($criteria.macaddress) and (macaddress is not null and macaddress like '%$rawValue.criteria.macaddress%' {escape '\'}) #end #if ($criteria.serialno) and (serialno is not null and serialno like '%$rawValue.criteria.serialno%' {escape '\'}) #end #if ($criteria.ip_complet) and (ip_complet is not null and ip_complet like '%$rawValue.criteria.ip_complet%' {escape '\'}) #end and ($defaultWhereClause) ]]>