]po[ CRM Status Engine Example

The CRM Status engine allows advance users to classify customers and other web users according to their dynamic behaviour. This module requires knowledge about SQL and the ]project-open[ database structure.

Transitions

From	To	Condition
Bad User	Deleted	users.user_state = 'deleted'	insert after edit
Intranet Pooper	Deleted	users.user_state = 'deleted'	insert after edit
	Intranet User	crm_intranet_activity_since (users.user_id, sysdate-15) > 0	insert after edit
Intranet User	Deleted	users.user_state = 'deleted'	insert after edit
	Intranet Pooper	crm_intranet_activity_since (users.user_id, sysdate-15) = 0	insert after edit
registered	Intranet User	crm_intranet_activity_since (users.user_id, sysdate-120) > 0	insert after edit
	Deleted	users.user_state = 'deleted'	insert after edit
	Bad User	users.email = 'owen@permafrost.net'	insert after edit