Lead @CRM defaultlisting="main" order="state desc"
	<listing name="main">
		<tab name="all" label="Todos" />
		<tab name="state1" label="Nuevos" subset="state1" />
		<tab name="state12" label="Revisados" subset="state12" />
		<tab name="state2" label="Con Email" subset="state2" />
		<tab name="state3" label="Vistos" subset="state3" />
		<tab name="state4" label="Verificados" subset="state4" />
		<tab name="state5" label="Con keywords" subset="state5" />
		<tab name="state6" label="Con productos y precios" subset="state6" />
		<tab name="state7" label="Destacados" subset="state7" />
	</listing>
	
	<subset name="state12" order="lastStateDate desc">
		<condition field="state.id" value="12" />
	</subset>
	<subset name="state1" order="lastStateDate desc">
		<condition field="state.id" value="1" />
	</subset>
	<subset name="state2" order="lastStateDate desc">
		<condition field="state.id" value="2" />
	</subset>
	<subset name="state3" order="lastStateDate desc">
		<condition field="state.id" value="3" />
	</subset>
	<subset name="state4" order="lastStateDate desc">
		<condition field="state.id" value="4" />
	</subset>
	<subset name="state5" order="lastStateDate desc">
		<condition field="state.id" value="5" />
	</subset>
	<subset name="state6" order="lastStateDate desc">
		<condition field="state.id" value="6" />
	</subset>
	<subset name="state7" order="lastStateDate desc">
		<condition field="state.id" value="7" />
	</subset>

	<action name="sendTemplate" label="Enviar plantilla" location="listing" type="relatedentity" entity="SendTemplate" defaultset="forLeads" />
	<action name="setState" label="Cambiar Estado/Rubro" location="listing" type="relatedentity" entity="ChangeState" defaultset="forLeads"/>
	<action name="merge" label="Unificar" location="listing" type="relatedentity" entity="MergeLeads" defaultset="forLeads"/>
	
	<action name="google" label="Google" location="local" type="javascript" function="searchInGoogle" functionparams="name" />
	<action name="guia" label="Guia" location="local" type="javascript" function="viewInGuide" />
	<action name="form" label="Form" location="local" type="javascript" function="viewInForm" />
	<action name="addByMaps" label="Agregar por maps" location="listing" type="javascript" function="viewMaps" />
	
	<filter name="lead" display="primary" label= "Nombre">
		<condition field="name" like="concat('%', concat(lead, '%'))" />
	</filter>
	
	<filter name="leadTemplate" entity="LeadTemplate" label="Plantilla" display="primary">
		<restriction expr="EXISTS (FROM LeadEvent le WHERE le.leadTemplate = ? AND le.lead = me)">
			<param value="leadTemplate" />
		</restriction>
	</filter>
	<filter name="withoutLeadTemplate" entity="LeadTemplate" label="Sin plantilla" display="primary">
		<restriction expr="NOT EXISTS (FROM LeadEvent le WHERE le.leadTemplate = ? AND le.lead = me)">
			<param value="withoutLeadTemplate" />
		</restriction>
	</filter>

	<filter name="street" property="street" display="primary" />
	<filter name="state" property="state" display="primary" />
	<filter name="city" property="city" display="primary" />
	<filter name="leadCategory" property="leadCategory" display="primary" />
	<filter name="codes" property="codes" label="Con código" display="primary" flag="contains" />
	<filter name="withoutCodes" display="primary" label="Sin código">
		<or>
			<condition field="codes" isnull="isnull" />
			<restriction expr="codes NOT LIKE concat('%',?,'%')">
				<param value="withoutCodes" />
			</restriction>
		</or>
	</filter>
	<filter name="lastEmailBefore" label="Ultimo email antes" type="date" display="primary">
		<condition field="lastEmail" lt="lastEmailBefore" />
	</filter>
	<filter name="filters" label="Filtros" type="enum" enumset="LeadFilters" display="primary">
		<or>
			<restriction expr="(whatsapp IS NOT NULL AND ? = 'withWhatsapp')"><param value="filters" /></restriction>
			<restriction expr="(whatsapp IS NULL AND ? = 'withoutWhatsapp')"><param value="filters" /></restriction>
			<restriction expr="(instagram IS NOT NULL AND ? = 'withInstagram')"><param value="filters" /></restriction>
			<restriction expr="(instagram IS NULL AND ? = 'withoutInstragram')"><param value="filters" /></restriction>
		</or>
	</filter>
	<filter name="emailBounced" label="Email Rebotado" type="enum" enumset="LeadEmailBounced" display="primary">
		<or>
			<restriction expr="(bounced IS true AND ? = 'bounced')"><param value="emailBounced" /></restriction>
			<restriction expr="(bounced IS false AND ? = 'noBounced')"><param value="emailBounced" /></restriction>
		</or>
	</filter>
	

	#tab Datos
		shop Shop "Comercio"		
		logo
		name "Nombre" d
		state LeadState "Estado" ds default="LeadState:findOneBy('id', 1)"
		lastStateDate date "Fecha" ds fixed
		codes "ABCD" ds
		leadCategory "Rubro" LeadCategory ds
		leadCategory1 "Rubro1" LeadCategory ds
		leadCategory2 "Rubro2" LeadCategory ds
		province "Provincia" Province ds
		city "Ciudad" City ds subset="forProvince" subsetparams="province"
		withoutAddress boolean "Sin dirección"
		street "Calle" ds displayif="withoutAddress != 'true'" style="width:300px;"
		streetNumber "Número" ds displayif="withoutAddress != 'true'" 
		apartment "Local/Depto" displayif="withoutAddress != 'true'"
		whatsapp ds style="width:300px;"
		phone ds style="width:300px;"
		email ds style="width:300px;"
		bounced boolean "Email Rebotado"
		instagram ds style="width:300px;"
		facebook
		twitter
		website ds style="width:300px;"
		featured boolean "Destacar"
		bigBrand boolean "Marca Grande"
		time "Horario" text
		usesMeli boolean "Usa MercadoLibre?" 
		meliItem "URL Artículo MercadoLibre" displayif="usesMeli = 'true'" style="width:300px;"
		hasOnlineStore boolean "Tiene Tienda Online?"
		usesTiendaNube boolean "Usa TiendaNube?"
		lastTiendaNubeUpdate datetime fixed "Actualización TiendaNube" ds
		usesShopify boolean "Tiene shopify?" hidden
		scrapper Scrapper
		hash
		
		placeId fixed
		vicinity fixed ds
		businessStatus fixed
		types set fixed		
		latitude double fixed
		longitude double fixed
		
		url 
		rating double
		websiteUrls text
		googlePhotos text
		googleMapPhoto
		color
		
		instagramBio
		instagramPicture		
		instagramError boolean
		lastEmail "Ultimo email" type="datetime" fixed ds
		
	#tab Marcas y productos
		brands text "Marcas"
		products text "Productos" style="height:400px;"
		categories text "Categorias"
	
	#tab Eventos y mails
		<html><![CDATA[<h3>Eventos</h3>]]></html>
			<embeddedlisting name="events" subset="forLead" subsetparams="." entity="LeadEvent" />
		<html><![CDATA[<h3>Mails</h3>]]></html>
		emails "Emails enviados" integer formula="(SELECT COUNT(*) FROM email e WHERE e.lead = id)" fixed ds
			<embeddedlisting name="emails" subset="forLead" subsetparams="." entity="Email" />
		<html><![CDATA[<h3>Historial del estado</h3>]]></html>
			<embeddedlisting name="history" subset="forLead" subsetparams="." entity="LeadHistory" />
			
	#tab Productos
		<embeddedlisting name="products" subset="forLead" subsetparams="." entity="LeadProduct" />
	
InstagramPost @
	lead Lead ds
	instagramId ds
	text
	thumbnail ds 
	datetime ds
	lastUpdate datetime
			
Shop @ order="name"
	name d
	logo ds

LeadProduct @Products
	<subset name="forLead">
		<param name="lead" entity="Lead"/>
		<condition field="lead" value="lead" />
	</subset>
	
	code ds
	lead Lead d
	title d r 
	description text 
	price d double
	discount d integer
	picture image d
	category LeadProductCategory 
	link
	itemGroupId
	disabled boolean
	outOfStock boolean
	lastUpdate datetime
	
LeadVariation @Products
	leadProduct LeadProduct
	code ds
	title d
	price double d
	discount d integer
	disabled boolean
	outOfStock boolean
	lastUpdate datetime
		
LeadProductCategory @Products
	lead Lead ds
	name d
	picture image d 
	link
	productsCount integer

Province @Configuración
	name "Nombre" d
	code "Codigo"
	featured "Destacado" boolean

City @Configuración order="name"
	<filter name="province" property="province" display="primary" />

	<subset name="forProvince" order="name">
		<param name="province" entity="Province" />
		<condition field="province" value="province" />
	</subset>

	name "Nombre" d
	province "Provincia" Province ds
	featured "Destacado" boolean
	url

LeadState @Configuración
	name "Estado" d r
	color
	rating ds integer
	
LeadCategory @Configuración order="name" defaultlisting="itemList"

	<filter name="category" property="name" display="primary" label="Categoria o Rubro"/>
	<filter name="type" property="type" display="primary" label="Tipo"/>

	<listing name="itemList">
		<tab name="all" label="Todos"/>
		<tab name="showing" label="Mostrando" subset="forShow"/>
		<tab name="noShow" label="No mostrar" subset="forNoShow"/>
	</listing>
	
	<subset name="forShow" order="name">
		<condition field="noShow" value="false"/>
	</subset>
	<subset name="forNoShow" order="name">
		<condition field="noShow" value="true"/>
	</subset>
	

	name "Name" d
	keywords text
	featured boolean
	type LeadCategoryType ds
	noShow boolean "No mostrar"
	icon
	url 
	
LeadCategoryType @Configuración order="name"
	name d 
	icon
	url
	orderBy "Ordenar" integer
	showItem "mostrar" boolean
	
GooglePlaceType @Configuración order="name"
	name "Name" d fixed
	category LeadCategory ds
	
LeadTemplate @CRM
	<subset name="enabled">
		<condition field="enabled" value="true" />
	</subset>

	name "Nombre" d
	enabled "Habilitado" boolean
	media type="enum" ds \
		<enum value="email">Email</enum>
		<enum value="printable">Printable</enum>
		<enum value="whatsapp">Whatsapp</enum>
		<enum value="sms">SMS</enum>
	addNewLines "Agregar saltos de líneas" boolean
	useHTML "Usar HTML" boolean displayif="media = 'email'"
	from "Remitente" displayif="media = 'email'"
	subject "Asunto" displayif="media = 'email'"
	alternativeSubjects "Asuntos alternativos" set displayif="media = 'email'" 
	
	text "Texto" style="height:350px;"
	attachments text "Adjuntos" displayif="media = 'email'"
	code ds
	delivered integer ds fixed "Enviados"
	validated integer ds fixed "Validados"
	rate ds fixed "Conversión"
	
LeadHistory @Eventos order="id desc"
	
	<filter name="datetime" label="Fecha" display="primary" type="date" >
		<condition field="datetime" ge="datetime" />
	</filter>
	<filter name="state" label="Estado" property="state" display="primary" />

	<subset name="forLead">
		<param name="lead" entity="Lead"/>
		<condition field="lead" value="lead"/>
	</subset>

	datetime "Fecha" fixed ds
	lead Lead fixed ds
	state LeadState fixed ds
	
LeadEventType @Eventos order="name"
	name d r

LeadEvent @Eventos order="id desc"
	<filter name="datetime" label="Fecha" display="primary" type="date">
		<condition field="datetime" ge="datetime" />
	</filter>
	<filter name="state" label="Estado" property="state" display="primary" />
	<filter name="leadTemplate" label="Template" property="leadTemplate" display="primary" />
	<filter name="leadType" label="Type" property="type" display="primary" />
	
	<subset name="forLead">
		<param name="lead" entity="Lead"/>
		<condition field="lead" value="lead" />
	</subset>
	
	lead Lead fixed d
	type LeadEventType fixed d
	datetime fixed d
	state LeadState fixed d
	leadTemplate LeadTemplate d fixed
	ip fixed
	userAgent fixed
	result fixed ds
	comments fixed ds
	log fixed text
	
LeadPrintable @Eventos
	<action name="print" type="javascript" function="printPrintable" label="Imprimir" location="local,form" />
	<action name="printWhatsapp" type="javascript" function="printWhatsapp" label="Whatsapp" location="local,form" />

	datetime fixed d
	leadTemplate LeadTemplate d fixed
	leads Lead set fixed ds
	totalLeads integer ds fixed
	sended "Enviado" boolean ds 
	
SendTemplate @Acciones transient="transient"
	<defaultset name="forLeads">
		<param name="leads" entity="Lead" collection="set" />
		<default name="leads" value="leads" />
	</defaultset>
	
	leads Lead set fixed
	leadTemplate LeadTemplate subset="enabled"
	subject "Asunto" readonly="readonly" \
		<dynamicvalue expr="leadTemplateParam.subject">
			<param name="leadTemplateParam" entity="LeadTemplate" value="leadTemplate" />
		</dynamicvalue>
	
	text "plantilla" style="height:350px" readonly="readonly" \
		<dynamicvalue expr="leadTemplateParam.text">
			<param name="leadTemplateParam" entity="LeadTemplate" value="leadTemplate"/>
		</dynamicvalue>
	
EmailTemplate @Configuración
	<filter name="code" label="Code" display="primary">
		<condition field="code" like="concat('%', concat(code, '%'))" />
	</filter>
	
	<filter name="subject" label="Asunto" display="primary">
		<condition field="subject" like="concat('%', concat(subject, '%'))" />
	</filter>

	code d r
	subject d r
	emailFrom d 
	isHTML boolean
	text style="height:300px;width:700px;"
	
ScheduledEmail @Eventos order="id desc"
	lead Lead fixed ds
	datetime fixed ds
	template LeadTemplate fixed ds
	sent boolean fixed ds
	
Email @Configuración stereotype="Email" order="id desc"

 	<filter name="datetime" label="Fecha" display="primary" type="date">
 		<condition field="emailDate" ge="datetime"/>
 	</filter>
 	
 	<filter name="subject" label="Asunto" display="primary">
		<condition field="subject" like="concat('%', concat(subject, '%'))" />
	</filter>
 	
	<subset name="forLead">
		<param name="lead" entity="Lead"/>
		<condition field="lead" value="lead" />
	</subset>
	
    <property collection="set" label="Recipients" name="recipients"/>
    <property display="primary" label="From" name="emailFrom"/>
    <property hidden="hidden" label="Reply-To " name="replyTo"/>
    <property display="primary" label="Subject" name="subject" required="required"/>
    <property collection="set" hidden="hidden" label="Attachment" name="attachmentUrls"/>
    <property label="Message" name="txtBody" type="text"/>
    <property label="Message" name="htmlBody" type="text"/>
    <property default="now" display="primary" fixed="fixed" hidden="hidden" label="Date" name="emailDate" required="required" type="datetime"/>
    <property default="false" display="primary" hidden="hidden" label="Sent" name="sent" type="boolean"/>
    <property display="primary" hidden="hidden" label="Read" name="wasRead" type="boolean"/>
    <property display="primary" hidden="hidden" label="Read" name="failed" type="boolean"/>
    lead Lead fixed
 
ChangeState @Acciones transient="transient"
	<defaultset name="forLeads">
		<param name="leads" entity="Lead" collection="set" />
		<default name="leads" value="leads" />
	</defaultset>
	
	leads Lead set fixed
	state "Estado" LeadState
	leadCategory "Rubro" LeadCategory
	
MergeLeads @Acciones transient="transient" &Unificar
	<defaultset name="forLeads">
		<param name="leads" entity="Lead" collection="list" />
		<default name="leads" value="leads" />
	</defaultset>
	
	leads Lead list fixed
	
   
Scrapper @Scrappers
	name d
	javaClass ds