` and the ``. ## Examples ### Single Class ``` priority class="priority-field" status class="status-indicator" ``` ### Multiple Classes ``` important class="highlight bold large" ``` ### With CSS Definition **Demo.txt:** ``` category class="highlight-field" ``` **Main.css:** ```css .highlight-field { background-color: #ffffcc; border: 2px solid #ffcc00; } .highlight-field input { font-weight: bold; } .highlight-field label { color: #cc9900; } ``` ## Common Use Cases ### Highlighting Important Fields ``` requiredField class="required-highlight" optionalField class="optional-field" ``` ### Field Categories ``` personalInfo class="personal-data" financialInfo class="financial-data sensitive" ``` ### Responsive Layouts ``` shortField class="col-4" longField class="col-8" fullWidth class="col-12" ``` ### Status Indicators ``` status class="status-badge" priority class="priority-indicator" ``` ## Built-in CSS Classes JFaster automatically adds these classes: | Applied To | Description | |------------|-------------| | Wrapper div | All properties | | Input element | All inputs | | Wrapper div | Label position | | Input | Text inputs | | Input | Numeric inputs | | Textarea | Text areas | | Select | Dropdowns | ## See Also - [property@style](property-style.md) - Inline CSS styles - property@labelposition - Label positioning # property@collection The `collection` attribute specifies that a property holds multiple values. ## Syntax ```xml ``` **Shorthand:** Collection type keywords can be used directly: ``` emails set // collection="set" phones list // collection="list" tags sortedset // collection="sortedset" ``` ## Description The `collection` attribute creates a **multi-valued property** that can hold multiple values instead of a single value. It determines: 1. **Java collection type** - The Java interface/class used 2. **Database structure** - Creates a separate table for the values 3. **HTML widget** - Multi-line input table or entity selection list ## Available Collection Types | Type | Java Interface | Implementation | Ordering | Duplicates | |------|----------------|----------------|----------|------------| | `set` | `Set` | `HashSet` | No guaranteed order | No | | `list` | `List` | `ArrayList` | Insertion order preserved | Yes | | `sortedset` | `SortedSet` | `TreeSet` | Natural or custom order | No | ## Generated Code ### Set of Strings **Source:** ``` emails set ``` **Java:** ```java private java.util.Set emails = new java.util.HashSet(); public java.util.Set getEmails() { return emails; } public void setEmails(java.util.Set emails) { this.emails = emails; } ``` ### List of Strings **Source:** ``` phones list ``` **Java:** ```java private java.util.List phones = new java.util.ArrayList(); public java.util.List getPhones() { return phones; } public void setPhones(java.util.List phones) { this.phones = phones; } ``` ### SortedSet of Strings **Source:** ``` tags sortedset ``` **Java:** ```java private java.util.SortedSet tags = new java.util.TreeSet(); public java.util.SortedSet getTags() { return tags; } public void setTags(java.util.SortedSet tags) { this.tags = tags; } ``` ### Set of Entities (Many-to-Many) When using a collection of entities **without** `childproperty`, JFaster creates a many-to-many relationship: **Source:** ``` skills Skill set ``` **Java:** ```java private java.util.Set skills = new java.util.HashSet(); public java.util.Set getSkills() { return skills; } public void setSkills(java.util.Set skills) { this.skills = skills; } ``` **Database:** Creates a join table `person_skills(person BIGINT, skills BIGINT)` ### Embedded Entity Collection (One-to-Many with `ei x childproperty`) When using a collection with `embedded="inline"`, `extendable`, and `childproperty`, JFaster creates an embedded editable table: **Source:** ``` addresses Address set ei x childproperty="person" ``` **Java:** ```java private java.util.Set

addresses = new java.util.HashSet

(); public java.util.Set

getAddresses() { return addresses; } public void setAddresses(java.util.Set

addresses) { this.addresses = addresses; } ``` ## Examples ### Set of Primitive Values ``` Person @CRM name d r emails set // Set phones list // List tags sortedset // SortedSet ``` ### Many-to-Many Relationship ``` Person @CRM name d r skills Skill set // Many-to-many (creates join table) languages Language set // Many-to-many Skill @Config name d r Language @Config name d r ``` ### Master-Detail Pattern (One-to-Many) Use `ei x childproperty` for embedded editing: ``` Invoice @Sales invoiceNumber d fixed customer Customer d r lines InvoiceLine set ei x childproperty="invoice" InvoiceLine @ invoice Invoice // Back-reference to parent product Product d r quantity integer r price double ``` | Attribute | Meaning | |-----------|---------| | `set` | Collection type | | `ei` | `embedded="inline"` - Show inline in form | | `x` | `extendable="extendable"` - Allow adding/removing rows | | `childproperty` | Property in child that references parent | ### List with Index Use `list` when order matters: ``` Recipe @Cooking name d r steps set list // Ordered list of strings (steps) ``` ## Collection Attributes | Attribute | Applies To | Description | |-----------|------------|-------------| | `childproperty` | Entity collections | Back-reference property in child | | `setorder` | `set` | HQL ORDER BY clause | | `sort` | `sortedset` | Java Comparator class | | `sortexpr` | `sortedset` | Sort expression | | `listindex` | `list` | Column storing list position | | `maxrows` | All | Maximum number of items | | `minrows` | All | Minimum number of items | ## Common Patterns ### Tags/Labels ``` Article @Blog title d r tags set // Simple string tags ``` ### Categories (Many-to-Many) ``` Product @Catalog name d r categories Category set // Creates product_categories join table ``` ### Addresses (One-to-Many) ``` Person @CRM name d r addresses Address set ei x childproperty="person" Address @ person Person // Back-reference (required for childproperty) street d r city r postalCode ``` ### Order Lines (One-to-Many) ``` Order @Sales orderNumber d fixed customer Customer r lines OrderLine set ei x childproperty="order" OrderLine @ order Order // Back-reference product Product r quantity integer r default="1" unitPrice double ``` ## Without childproperty If you omit `childproperty`, JFaster creates a **many-to-many** relationship: ``` // Many-to-many (no childproperty) - creates join table Person @CRM skills Skill set // One-to-many (with childproperty) - Address has person FK Person @CRM addresses Address set ei x childproperty="person" ``` ## See Also - [property@entity](property-entity.md) - Entity relationships - [property@childproperty](property-childproperty.md) - Back-reference for one-to-many - property@embedded - Embedding options - property@extendable - Allow adding rows - [embeddedlisting](embeddedlisting.md) - Alternative for large collections # property@default The `default` attribute sets the initial value for a property when creating new records. ## Syntax ```xml ``` **Shorthand:** Use the `default="value"` attribute directly: ``` status default="active" count integer default="0" active boolean default="true" createdAt datetime default="now" ``` ## Description The `default` attribute provides an initial value for new records. It affects: 1. **Form initialization** - New forms pre-populate with the default value 2. **Java entity** - Field is initialized with the default value 3. **Database** - May create DEFAULT constraint (depending on configuration) ## Value Types ### String Literals ``` status default="pending" country default="USA" currency default="USD" ``` ### Numeric Values ``` quantity integer default="1" price double default="0.0" discount integer default="0" ``` ### Boolean Values ``` active boolean default="true" published boolean default="false" featured boolean default="false" ``` ### Date/Time Values | Value | Description | |-------|-------------| | `now` | Current date/time | | `today` | Current date (midnight) | ``` createdAt datetime default="now" startDate date default="today" ``` ### Entity References Reference another entity using the pattern `Entity:method(params)`: ``` author User default="User:find(userId)" company Company default="Company:find(companyId)" status Status default="Status:findOneBy('code', 'PENDING')" ``` Common patterns: - `User:find(userId)` - Current logged-in user - `Entity:find(id)` - Find by ID - `Entity:findOneBy('property', value)` - Find by property ### Expressions ``` code default="generateCode()" sequence integer default="nextSequence()" ``` ## Examples ### Basic Defaults ``` Task @Projects title d r status default="pending" priority default="medium" createdAt datetime default="now" fixed createdBy User default="User:find(userId)" fixed ``` ### Audit Fields ``` Article @Blog title d r content text // Audit fields with defaults createdAt datetime default="now" fixed createdBy User default="User:find(userId)" fixed updatedAt datetime default="now" updatedBy User default="User:find(userId)" ``` ### Status Workflow ``` Order @Sales orderNumber d fixed formula="id" customer Customer r status OrderStatus default="OrderStatus:findOneBy('code', 'NEW')" orderDate date default="today" ``` ### Counters and Sequences ``` Invoice @Sales invoiceNumber integer default="nextInvoiceNumber()" fixed invoiceDate date default="today" ``` ### Boolean Flags ``` Product @Catalog name d r active boolean default="true" featured boolean default="false" taxable boolean default="true" ``` ### Related Entity Defaults ``` Person @CRM name d r company Company country Country default="Country:findOneBy('code', 'US')" ``` ## Defaults in Defaultsets For context-dependent defaults, use ``: ``` Person @CRM name d r company Company country Country currency Currency ``` Usage: ``` ``` ## Generated Code ### Java Entity **Source:** ``` active boolean default="true" status default="pending" ``` **Java:** ```java public class Product { private Boolean active = true; private String status = "pending"; // getters and setters... } ``` ### Date Default **Source:** ``` createdAt datetime default="now" ``` **Java:** ```java public class Entity { private GregorianCalendar createdAt = new GregorianCalendar(); } ``` ### Entity Reference Default **Source:** ``` author User default="User:find(userId)" ``` ## Default vs Fixed | Attribute | Editable | Initial Value | |-----------|----------|---------------| | `default` only | Yes | Set on new records | | `fixed` only | No | Empty | | `default` + `fixed` | No | Set and locked | ``` // Editable with default status default="pending" // Read-only, no default approvedBy User fixed // Read-only with default (common for audit) createdAt datetime default="now" fixed createdBy User default="User:find(userId)" fixed ``` ## Common Patterns ### Timestamp Fields ``` Entity @ createdAt datetime default="now" fixed ds updatedAt datetime default="now" ds ``` Update `updatedAt` in Java: ```java @Override public Long store(String id, Entity entity) { entity.setUpdatedAt(new GregorianCalendar()); return super.store(id, entity); } ``` ### User Tracking ``` Document @ createdBy User default="User:find(userId)" fixed modifiedBy User default="User:find(userId)" ``` ### Sequential Numbers ``` Invoice @Sales number integer default="nextNumber('invoice')" fixed d ``` Implement `nextNumber()` in a utility class. ### Default Status ``` Ticket @Support status TicketStatus default="TicketStatus:findOneBy('code', 'OPEN')" ``` ### Inherited Defaults ``` OrderLine @ ``` ## See Also - [property@fixed](property-fixed.md) - Read-only fields - [defaultset](defaultset.md) - Context-dependent defaults - [property@formula](property-formula.md) - Computed values - property@calculated - Calculated fields # property@disabled The `disabled` attribute makes a form input non-interactive. ## Syntax ```xml ``` **Shorthand:** ``` status disabled ``` ## Description The `disabled` attribute adds `disabled="disabled"` to the HTML input element. A disabled field: 1. **Cannot be edited** - User cannot change the value 2. **Visually grayed out** - Browser shows disabled styling 3. **Not submitted** - Value is NOT sent with form submission 4. **Still in database** - Property is persisted normally ## Comparison with Other Read-Only Attributes | Attribute | HTML Element | Editable | Submitted | Visual | |-----------|--------------|----------|-----------|--------| | *(none)* | `` | Yes | Yes | Normal | | `disabled` | `` | No | No | Grayed out | | `readonly` | `` | No | Yes | Looks editable | | `fixed` | `` | No | Yes | Plain text | ## Generated Code **Source:** ``` status disabled default="'active'" ``` ## Examples ### Basic Disabled Field ``` Person @CRM name d r status disabled default="'pending'" createdAt datetime disabled default="now" ``` ### Disabled Relationship ``` OrderLine @Sales order Order disabled // Cannot change which order this belongs to product Product r quantity integer r ``` ### Combined with Default ``` Document @Files title d r status disabled default="'draft'" author User disabled default="User:find(userId)" ``` ## Use Cases ### System-Managed Fields Fields that are set by the system and should not be changed by the user: ``` Entity @ status disabled default="'active'" version integer disabled default="1" ``` ### Conditional Disabling For conditional disabling, use `disabledif` instead: ``` discount double disabledif="customerType != 'VIP'" ``` ## See Also - property@readonly - Read-only but still submitted - [property@fixed](property-fixed.md) - Display as text - property@disabledif - Conditional disabling - [property@default](property-default.md) - Default values # property@display The `display` attribute controls how a property appears in listings and entity descriptions. ## Syntax ```xml ``` **Shorthand:** ``` name d // display="primary" email ds // display="secondary" ``` ## Description The `display` attribute determines: 1. **Entity description** - Properties with `display="primary"` form the text shown when the entity is referenced elsewhere (in dropdowns, listings, etc.) 2. **Listing columns** - Which properties appear in the entity's list view 3. **Search results** - What's shown in autocomplete and search results ## Values | Value | Shorthand | In Listings | In Dropdowns | Description | |-------|-----------|-------------|--------------|-------------| | `primary` | `d` | Yes | Yes | Main identifier/description | | `secondary` | `ds` | Yes | No | Additional info in listings only | | *(none)* | - | No | No | Only shown in forms | ## Examples ### Basic Entity Description ``` Country @Config name d // "Argentina", "Brazil", "Chile" code // "AR", "BR", "CL" - not shown in dropdowns population integer ``` ### Multiple Primary Properties ``` Person @CRM firstName d // Both combine for description lastName d // "John Smith", "Jane Doe" email phone ``` ### Primary and Secondary ``` Product @Catalog code d // Primary: shown in dropdowns name d // Primary: shown in dropdowns price double ds // Secondary: shown in listings only stock integer ds // Secondary: shown in listings only description text // Neither: only in form ``` **In a dropdown:** ``` PRD001 - Widget PRD002 - Gadget ``` **In the listing (table):** | Code | Name | Price | Stock | |------|------|-------|-------| | PRD001 | Widget | $9.99 | 150 | | PRD002 | Gadget | $19.99 | 75 | ### Display in Related Entity When displaying a related entity in another entity's listing: ``` Order @Sales orderNumber d fixed orderDate date ds customer Customer ds // Shows customer's display="primary" properties total double ds Customer @CRM name d // This is what shows in Order listing email ``` **Order listing shows:** | Order # | Date | Customer | Total | |---------|------|----------|-------| | 1001 | 2024-01-15 | Acme Corp | $500.00 | | 1002 | 2024-01-16 | Tech Inc | $750.00 | ### Fixed Display Properties ``` Invoice @Sales invoiceNumber d fixed // Primary and read-only invoiceDate date ds fixed // Secondary and read-only customer Customer d // Primary, editable ``` ### Computed Display Properties ``` Company @CRM name d employeeCount integer ds formula="(SELECT COUNT(*) FROM person WHERE company = id)" ``` ## Listings Configuration ### Default Behavior By default, all `display="primary"` and `display="secondary"` properties appear in listings. ### Custom Display Properties Override with `displayproperties`: ``` Person @CRM name d lastName d email ds phone ds address text ``` ### Per-Tab Display ``` Person @CRM ``` ## Generated Code ### HTML Listing Only properties with `display="primary"` or `display="secondary"` appear in listings. **Source:** ``` Person firstName d // display="primary" lastName d // display="primary" email // no display - not in listing ``` ### REST API Marshalling JFaster generates two marshal methods: **`marshal()` - For listings (only display properties):** ```java public void marshal(Writer writer, String nodeName, Person obj, Boolean showSecondary) { writeProperty(writer, "firstName", escape(obj.getFirstName())); writeProperty(writer, "lastName", escape(obj.getLastName())); // email not included - no display attribute } ``` **`marshalFull()` - For forms (all properties):** ```java public void marshalFull(Writer writer, String nodeName, Person obj, Boolean foo) { writeProperty(writer, "firstName", escape(obj.getFirstName())); writeProperty(writer, "lastName", escape(obj.getLastName())); writeProperty(writer, "email", escape(obj.getEmail())); // All properties included } ``` ### Java toString() The `toString()` method includes only `display="primary"` properties: ```java @Override public String toString() { StringBuffer buf = new StringBuffer(); buf.append(firstName + " "); buf.append(lastName + " "); return buf.toString(); } ``` ## Common Patterns ### Code + Name Pattern ``` Product @Catalog code d // "PRD001" name d // "Widget" // Displays as: "PRD001 - Widget" or "PRD001 Widget" ``` ### Name Only ``` Category @Config name d // Simple single-field description ``` ### Computed Description When you need custom description logic, override in Java: ```java public class Person { public String getDisplayName() { return getLastName() + ", " + getFirstName(); } } ``` And use `comboproperty`: ``` person Person comboproperty="displayName" ``` ### Status Indicators ``` Task @Projects title d status ds // Shows status in listing priority ds // Shows priority in listing dueDate date ds // Shows due date in listing description text // Only in form ``` ## Display Sets For more control, use ``: ``` Person @CRM ``` Use in property: ``` manager Person subset="forDropdown" ``` ## See Also - [property@name](property-name.md) - Property identifier - [listing](listing.md) - Listing configuration - displayset - Custom display sets - [property@formula](property-formula.md) - Computed properties # property@entity The `entity` attribute creates a relationship between two entities (foreign key). ## Syntax ```xml ``` **Shorthand:** Any PascalCase word on a property line is interpreted as an entity reference: ``` company Company // entity="Company" country Country // entity="Country" manager Person // entity="Person" (self-reference) ``` ## Description The `entity` attribute establishes a **many-to-one** relationship between entities. It determines: 1. **Java type** - The property type becomes the referenced entity class 2. **Database foreign key** - Creates a foreign key column referencing the related table 3. **HTML widget** - Renders as a `` 2. **Cannot be modified** - No user interaction possible 3. **Still submits** - Value is included in form submission 4. **Visually distinct** - Clearly appears as non-editable ## Comparison | Attribute | HTML Element | User Can Edit | Visually Editable | Submits Value | |-----------|--------------|---------------|-------------------|---------------| | *(none)* | `` | Yes | Yes | Yes | | `disabled` | `` | No | Grayed out | No | | `readonly` | `` | No | Looks editable | Yes | | `fixed` | `` | No | Clearly read-only | Yes | ## Examples ### Basic Fixed Fields ``` Order @Sales orderNumber d fixed // Auto-generated, never editable orderDate date fixed // Set once, never changes customer Customer fixed // Cannot change after creation status // Editable ``` ### Fixed with Default Common pattern for auto-populated fields: ``` Document @Files title d r createdAt datetime fixed default="now" createdBy User fixed default="User:find(userId)" updatedAt datetime default="now" ``` ### Fixed with Formula Computed values are typically fixed: ``` Invoice @Sales invoiceNumber d fixed formula="id" subtotal double fixed formula="(SELECT SUM(quantity * price) FROM invoice_line WHERE invoice = id)" tax double fixed formula="(SELECT SUM(quantity * price * 0.21) FROM invoice_line WHERE invoice = id)" total double fixed formula="(SELECT SUM(quantity * price * 1.21) FROM invoice_line WHERE invoice = id)" ``` ### Fixed Relationship ``` InvoiceLine @Sales invoice Invoice fixed // Back-reference, set on creation product Product d // Can be changed quantity integer r price double ``` ### Fixed in Master-Detail The parent reference in detail records is typically fixed: ``` Order @Sales orderNumber d fixed customer Customer r lines OrderLine set ei x childproperty="order" OrderLine @ order Order fixed // Cannot change which order this belongs to product Product r quantity integer r ``` ## Generated Code ### HTML Form **Source:** ``` createdAt datetime fixed default="now" ``` ## Common Patterns ### Audit Fields ``` Entity @ // Creation audit (fixed) createdAt datetime fixed default="now" ds createdBy User fixed default="User:find(userId)" ds // Update audit (not fixed, updated on each save) updatedAt datetime default="now" ds updatedBy User default="User:find(userId)" ds ``` ### Status Display ``` Order @Sales orderNumber d fixed status OrderStatus fixed // Changed via actions, not directly ``` ### Inherited Values ``` OrderLine @Sales order Order fixed currency fixed \ // Inherited from order, cannot override ``` ### Computed Display ``` Person @CRM firstName d r lastName d r fullName fixed formula="CONCAT(firstName, ' ', lastName)" ``` ### Sequential Numbers ``` Invoice @Sales invoiceNumber integer d fixed default="nextInvoiceNumber()" ``` ### Fixed with Display ``` Product @Catalog code d fixed // Primary display, not editable name d r // Primary display, editable price double ds // Secondary display, editable ``` ## Conditional Fixed Use `readonlyif` for conditional read-only behavior: ``` Order @Sales status OrderStatus customer Customer readonlyif="status != 'DRAFT'" // Customer becomes read-only once order is not draft ``` Or use ``: ``` customer Customer \ ``` ## Styling Fixed Fields ### CSS ```css .fixed-field { display: inline-block; padding: 6px 12px; background-color: #f5f5f5; border: 1px solid #ddd; border-radius: 4px; color: #555; } ``` ### Custom Style ``` orderNumber fixed style="font-weight: bold; font-size: 18px;" ``` ## Fixed vs Hidden | Use Case | Attribute | |----------|-----------| | User should see but not edit | `fixed` | | User should not see at all | `hidden` | | Technical field, not for users | `hidden` or `invisible` | ``` // User sees order number but can't edit orderNumber d fixed // Internal tracking ID, not shown internalId hidden // Completely invisible (not even in HTML) systemFlag invisible ``` ## See Also - [property@default](property-default.md) - Default values - [property@formula](property-formula.md) - Computed values - property@readonly - Read-only inputs - [property@disabled](property-disabled.md) - Disabled inputs - [property@hidden](property-hidden.md) - Hidden fields - property@readonlyif - Conditional read-only # property@formula The `formula` attribute defines a SQL expression that computes the property value at the database level. ## Syntax ```xml ``` **In shorthand:** ``` addressCount integer formula="(SELECT COUNT(*) FROM address WHERE person = id)" ``` ## Description The `formula` attribute maps to Hibernate's formula feature. It: 1. **Computes at database level** - SQL executed when entity is loaded 2. **Not stored** - No column created, value is computed 3. **Read-only** - Cannot be set directly 4. **Exists in Java** - Property generated in entity class 5. **Updated on load** - Recalculated each time entity is fetched ## Generated Code **Source:** ``` addressCount integer formula="(SELECT COUNT(*) FROM address WHERE person = id)" ``` **Java:** ```java private Integer addressCount; public Integer getAddressCount() { return addressCount; } public void setAddressCount(Integer addressCount) { this.addressCount = addressCount; } ``` **Hibernate (Person.hbm.xml):** ```xml ``` Note: JFaster wraps the formula in extra parentheses for Hibernate compatibility. ## Examples ### Count Related Records ``` Person @CRM name d r addresses Address set childproperty="person" addressCount integer formula="(SELECT COUNT(*) FROM address WHERE person = id)" ``` ### Sum of Related Values ``` Invoice @Sales customer Customer r lines InvoiceLine set ei x childproperty="invoice" subtotal double formula="(SELECT COALESCE(SUM(quantity * price), 0) FROM invoice_line WHERE invoice = id)" tax double formula="(SELECT COALESCE(SUM(quantity * price * 0.21), 0) FROM invoice_line WHERE invoice = id)" total double formula="(SELECT COALESCE(SUM(quantity * price * 1.21), 0) FROM invoice_line WHERE invoice = id)" ``` ### Concatenation ``` Person @CRM firstName r lastName r fullName formula="CONCAT(firstName, ' ', lastName)" ``` ### Conditional Value ``` Order @Sales orderDate date status isOverdue boolean formula="(CASE WHEN status != 'COMPLETED' AND orderDate < CURDATE() - INTERVAL 30 DAY THEN 1 ELSE 0 END)" ``` ### Latest Related Record ``` Customer @CRM name d r orders Order set childproperty="customer" lastOrderDate date formula="(SELECT MAX(orderDate) FROM orders WHERE customer = id)" ``` ### Average ``` Product @Catalog name d r reviews Review set childproperty="product" avgRating double formula="(SELECT AVG(rating) FROM review WHERE product = id)" ``` ## Formula vs Transient vs Calculated | Attribute | Computed Where | Stored | Updated | |-----------|---------------|--------|---------| | `formula` | Database (SQL) | No | On load | | `transient` | Java code | No | Manual | | `calculated` | JavaScript | No | On form change | ## Common SQL Functions | Function | Example | Description | |----------|---------|-------------| | `COUNT(*)` | Count related records | `(SELECT COUNT(*) FROM child WHERE parent = id)` | | `SUM()` | Sum values | `(SELECT SUM(amount) FROM lines WHERE parent = id)` | | `AVG()` | Average | `(SELECT AVG(rating) FROM reviews WHERE product = id)` | | `MAX()` | Maximum | `(SELECT MAX(date) FROM events WHERE entity = id)` | | `MIN()` | Minimum | `(SELECT MIN(date) FROM events WHERE entity = id)` | | `COALESCE()` | Default value | `COALESCE(SUM(amount), 0)` | | `CONCAT()` | Concatenation | `CONCAT(firstName, ' ', lastName)` | | `CASE WHEN` | Conditional | `CASE WHEN status = 'A' THEN 1 ELSE 0 END` | ## Best Practices 1. **Use COALESCE** - Handle NULL values with `COALESCE(expr, default)` 2. **Wrap in parentheses** - JFaster adds extra parens, but be explicit 3. **Test performance** - Complex formulas can slow down queries 4. **Consider indexes** - Ensure related tables are properly indexed 5. **Use for display** - Best for read-only display values ## See Also - [property@transient](property-transient.md) - Java-only computed values - property@calculated - Client-side calculations - [property@fixed](property-fixed.md) - Read-only display # property@hidden The `hidden` attribute hides a property from the form while still including it in the data model. ## Syntax ```xml ``` **Shorthand:** ``` internalCode hidden trackingId hidden ``` ## Description The `hidden` attribute makes a property **invisible in forms**: 1. **Still exists in Java** - Property is generated in entity class 2. **Still in database** - Column is created in table 3. **Not in HTML form** - Not rendered in the form 4. **Included in REST API** - Property is marshalled in XML/JSON responses 5. **Can be set programmatically** - Via server-side code or defaultsets ## Comparison | Attribute | In Form | In HTML | In REST API | In Database | In Java | |-----------|---------|---------|-------------|-------------|---------| | *(none)* | Visible | `` | Yes | Yes | Yes | | `hidden` | Hidden | No | Yes | Yes | Yes | | `invisible` | Hidden | No | No | Yes | Yes | | `transient` | Visible | `` | Yes | No | Yes | ## hidden vs invisible The key difference is in the REST API response: **hidden** - Property IS included in XML/JSON: ``` reviews integer hidden ``` ```xml Product A 5 ``` **invisible** - Property is NOT included in XML/JSON: ``` reviews integer invisible ``` ```xml Product A ``` **When to use each:** - Use `hidden` when client code needs access to the value via REST API - Use `invisible` for sensitive or internal data that should never leave the server ## Examples ### Basic Hidden Field ``` Order @Sales orderNumber d customer Customer r internalCode hidden // Set by system, not shown to user processingStatus hidden // Internal tracking ``` ### Hidden with Default ``` Document @Files title d r content text createdBy User hidden default="User:find(userId)" version integer hidden default="1" ``` ### Hidden Tracking Fields ``` Lead @CRM name d r email r source hidden // Set by marketing system campaign hidden // Set by marketing system utmSource hidden utmMedium hidden utmCampaign hidden ``` ### Hidden Foreign Keys ``` OrderLine @Sales order Order hidden // Set automatically, user doesn't see it product Product d r quantity integer r ``` ### Hidden Computed Values ``` Invoice @Sales lines InvoiceLine set ei x childproperty="invoice" subtotal double hidden formula="(SELECT SUM(quantity*price) FROM invoice_line WHERE invoice=id)" taxAmount double hidden formula="(SELECT SUM(quantity*price*0.21) FROM invoice_line WHERE invoice=id)" total double ds formula="(SELECT SUM(quantity*price*1.21) FROM invoice_line WHERE invoice=id)" ``` ## Generated Code ### Java Entity Same as any other property: ```java private String trackingId; public String getTrackingId() { return trackingId; } public void setTrackingId(String trackingId) { this.trackingId = trackingId; } ``` ## Setting Hidden Values ### Via Defaultset ``` Order @Sales sourceQuote Quote hidden internalCode hidden ``` ### Via Server-Side Code ```java @Override public Long store(String id, Order order) throws ServiceException { if (order.getInternalCode() == null) { order.setInternalCode(generateInternalCode()); } return super.store(id, order); } ``` ## Common Patterns ### System-Generated IDs ``` Entity @ publicId hidden default="generatePublicId()" legacyId hidden // Imported from old system ``` ### Workflow State ``` Document @ title d r content text workflowState hidden default="DRAFT" workflowStep integer hidden default="0" ``` ### Integration Keys ``` Customer @CRM name d r email r salesforceId hidden // Sync with Salesforce hubspotId hidden // Sync with HubSpot stripeCustomerId hidden // Payment processing ``` ### Soft Delete ``` Entity @ // ... visible fields ... deleted boolean hidden default="false" deletedAt datetime hidden deletedBy User hidden ``` ### Versioning ``` Document @ title d r content text version integer hidden default="1" previousVersion Document hidden ``` ### Audit Trail ``` Entity @ // ... visible fields ... ipAddress hidden userAgent hidden sessionId hidden ``` ## Conditional Visibility Use `displayif` to conditionally show/hide visible fields: ``` advancedOptions text displayif="showAdvanced = 'true'" showAdvanced boolean ``` Or use `visibleif`: ``` taxId visibleif="isBusiness = 'true'" isBusiness boolean ``` ## See Also - property@invisible - Hidden and not in REST API - [property@fixed](property-fixed.md) - Read-only display - property@displayif - Conditional display - [property@default](property-default.md) - Default values - [property@transient](property-transient.md) - Not persisted # property@name The `name` attribute defines the identifier for a property within an entity. ## Syntax ``` ``` **Shorthand:** The property name is always the first word on a property line and **must start with a lowercase letter**. ``` propertyName // name="propertyName" propertyName d r // name="propertyName" display="primary" required="required" ``` ## Description The `name` attribute is **required** for every property. It determines: 1. **Java field name** - The property name becomes a private field in the generated entity class 2. **Database column name** - By default, the column name matches the property name (can be overridden with `column` attribute) 3. **HTML element IDs** - Form inputs get IDs like `EntityName_propertyName` 4. **REST API field** - The property name is used in XML/JSON serialization 5. **Default label** - If no label is specified, one is auto-generated from the name using camelCase splitting ## Naming Conventions - **Must start with lowercase letter** - This is required by the preprocessor - Use **camelCase**: `firstName`, `lastName`, `dateOfBirth` - Use descriptive names that reflect the data - For relationships, use the singular form of the related entity: `company` (not `companies`) for a single relationship ## Generated Code For a property named `firstName`: **Java (Person.java):** ```java private String firstName; public String getFirstName() { return firstName; } public void setFirstName(String firstName) { this.firstName = firstName; } ``` **Hibernate (Person.hbm.xml):** ```xml ``` ## Examples ### Basic Properties ``` Person @CRM firstName d r // Simple string property lastName d r age integer // Integer property email // Optional string property ``` ### Relationship Properties ``` Person @CRM company Company // Many-to-one relationship (property name = "company") country Country manager Person // Self-referential relationship ``` ### Multi-valued Properties ``` Person @CRM emails set // Set of strings (property name = "emails", plural) phones list // List of strings addresses Address set // Set of Address entities ``` ### Property with Custom Column Name When the database column name differs from the property name: ```xml ``` ## Auto-generated Labels If no `label` attribute is provided, the label is generated from the property name: | Property Name | Generated Label | |---------------|-----------------| | `firstName` | "First Name" | | `lastName` | "Last Name" | | `dateOfBirth` | "Date Of Birth" | | `email` | "Email" | | `companyAddress` | "Company Address" | ## See Also - property@label - Custom display label - property@column - Custom database column name - [property@type](property-type.md) - Property data type - [property@entity](property-entity.md) - Entity relationships # property@pattern The `pattern` attribute defines a regex pattern for formatting values in the REST API marshaller. ## Syntax ```xml ``` **In shorthand:** ``` code pattern="[A-Z]{3}-[0-9]{4}" ``` ## Description The `pattern` attribute affects how values are marshalled (serialized) in the REST API. Instead of using the standard `escape()` method, the marshaller uses `pattern()` with the specified regex. This is used for: 1. **Format validation** - Ensuring values match a pattern 2. **Data formatting** - Transforming output format 3. **API consistency** - Enforcing consistent data formats ## Generated Code **Source:** ``` code pattern="[A-Z]{3}-[0-9]{4}" ``` **DefaultMarshaller.java:** ```java public void marshalFull(Writer writer, String nodeName, Person obj, Boolean foo) throws Exception { // ... other properties use escape() writeProperty(writer, "firstName", escape(obj.getFirstName())); writeProperty(writer, "lastName", escape(obj.getLastName())); // Property with pattern uses pattern() instead of escape() writeProperty(writer, "code", pattern("[A-Z]{3}-[0-9]{4}", obj.getCode())); // ... rest of properties } ``` ## Examples ### Product Code ``` Product @Catalog code pattern="[A-Z]{2}-[0-9]{6}" d r // e.g., "AB-123456" name d r ``` ### Phone Number Format ``` Person @CRM phone pattern="[0-9]{3}-[0-9]{3}-[0-9]{4}" // e.g., "555-123-4567" ``` ### License Plate ``` Vehicle @Fleet plate pattern="[A-Z]{3}-[0-9]{3}" d r // e.g., "ABC-123" ``` ### Postal Code ``` Address @ postalCode pattern="[0-9]{5}(-[0-9]{4})?" // e.g., "12345" or "12345-6789" ``` ## Common Patterns | Pattern | Example | Description | |---------|---------|-------------| | `[A-Z]{3}-[0-9]{4}` | ABC-1234 | Code format | | `[0-9]{3}-[0-9]{3}-[0-9]{4}` | 555-123-4567 | US phone | | `[0-9]{5}` | 12345 | US ZIP code | | `[A-Z0-9]{8}` | AB12CD34 | Alphanumeric ID | | `[0-9]{4}-[0-9]{2}-[0-9]{2}` | 2024-01-15 | Date format | ## See Also - property@mask - Input mask for data entry - property@maxlength - Maximum input length - property@checkif - Validation conditions # property@placeholder The `placeholder` attribute adds placeholder text to an HTML input field. ## Syntax ```xml ``` **In shorthand:** ``` email placeholder="Enter your email" ``` ## Description The `placeholder` attribute adds an HTML5 `placeholder` attribute to the input element. The placeholder text: 1. **Shows when empty** - Displayed when the field has no value 2. **Disappears on focus** - Hidden when user starts typing 3. **Provides hints** - Helps users understand expected input 4. **Not a label** - Should not replace the field label ## Generated Code **Source:** ``` email placeholder="Enter your email" ``` ## Examples ### Basic Placeholder ``` Person @CRM firstName d r placeholder="First name" lastName d r placeholder="Last name" email email placeholder="email@example.com" phone phone placeholder="+1 (555) 123-4567" ``` ### Format Hints ``` code placeholder="ABC-1234" date date placeholder="YYYY-MM-DD" creditCard placeholder="1234 5678 9012 3456" ``` ### Search Fields ``` Search @ transient="transient" query placeholder="Search..." location placeholder="City or ZIP code" ``` ### Instructions ``` bio text placeholder="Tell us about yourself..." notes text placeholder="Add any additional notes here" ``` ## Best Practices 1. **Keep it short** - Placeholders should be concise 2. **Show format** - Use for format examples (e.g., phone, date) 3. **Don't replace labels** - Labels are still needed for accessibility 4. **Use for hints** - Not for critical information ## Comparison with Other Attributes | Attribute | Purpose | Visibility | |-----------|---------|------------| | `label` | Field name | Always visible | | `placeholder` | Input hint | Only when empty | | `hint` | Help text | Below the field | | `tooltip` | Extended help | On hover | ## See Also - property@hint - Help text below field - property@tooltip - Hover tooltip - property@label - Field label # property@required The `required` attribute marks a property as mandatory. ## Syntax ```xml ``` **Shorthand:** ``` email r // required="required" email required // required="required" (alternative) ``` ## Description The `required` attribute enforces that a property must have a value. It affects: 1. **HTML validation** - Adds `required` attribute to form inputs 2. **Client-side validation** - JavaScript validates before submission 3. **Database constraint** - Column is marked NOT NULL (for most types) **Note:** Empty strings in HTML form fields are converted to `null` by the REST API, so they will fail client-side validation for required fields. ## Examples ### Basic Required Fields ``` Person @CRM firstName r // Required lastName r // Required email // Optional phone // Optional ``` ### Required with Other Attributes ``` Person @CRM name d r // Display + Required email r // Required company Company r // Required relationship birthDate date r // Required date ``` ### Required in Master-Detail ``` Invoice @Sales invoiceNumber d r fixed customer Customer d r lines InvoiceLine set ei x childproperty="invoice" InvoiceLine @ invoice Invoice r // Required back-reference product Product r // Required quantity integer r // Required price double // Optional (may be auto-filled) ``` ## Generated Code ### HTML Form **Source:** ``` firstName d r ``` **Note:** The `required` validation is in the `validate` attribute, not the HTML5 `required` attribute. JFaster uses its own client-side validation system. ### Database Schema **SQL:** ```sql CREATE TABLE person ( id BIGINT PRIMARY KEY AUTO_INCREMENT, firstName VARCHAR(255) NOT NULL, -- required lastName VARCHAR(255) NOT NULL, -- required email VARCHAR(255), -- optional (nullable) phone VARCHAR(255) -- optional (nullable) ); ``` ## Validation Behavior ### Client-Side 1. Form cannot be submitted if required fields are empty 2. Browser shows native validation message 3. Custom JavaScript validation runs before submission ### Server-Side Validation JFaster does not add server-side validation by default. To add validation, override the `store()` method in your `*Services.java` file: ```java @Override public Long store(String id, Person person) throws ServiceException { if (person.getEmail() == null || person.getEmail().isEmpty()) { throw new ServiceException("Email is required"); } return super.store(id, person); } ``` ## Conditional Required For fields that are conditionally required, handle validation in the `*Services.store()` method: ```java @Override public Long store(String id, Person person) throws ServiceException { if (person.getHasCompany() && person.getCompany() == null) { throw new ServiceException("Company is required when 'Has Company' is checked"); } return super.store(id, person); } ``` ## Required + Display A common pattern is combining `display` and `required`: ``` name d r // Common pattern: primary display + required ``` ## Required Relationships ``` order Order r // Must select an order category Category r // Must select a category ``` ## Common Patterns ### Basic Entity ``` Product @Catalog code d r // Required identifier name d r // Required name price double r // Required price description text // Optional description category Category // Optional category ``` ### User Registration ``` User @Users username d r email r password password r firstName r lastName r phone // Optional address text // Optional ``` ### Required with Default ``` Order @Sales orderNumber d fixed formula="id" orderDate date r default="now" status r default="pending" customer Customer r ``` ### Transient Entity (Action) ``` SendEmail @ transient="transient" recipient r // Must specify recipient subject r // Must have subject body text r // Must have body ``` ## See Also - [property@name](property-name.md) - Property identifier - [property@default](property-default.md) - Default values - [property@fixed](property-fixed.md) - Read-only fields # property@style The `style` attribute adds inline CSS styles to the HTML input element. ## Syntax ```xml ``` **In shorthand:** ``` notes style="width: 300px; background-color: #f0f0f0;" ``` ## Description The `style` attribute adds a `style="..."` attribute directly to the HTML input element. This allows for custom styling of individual form fields. ## Generated Code **Source:** ``` notes style="width: 300px; background-color: #f0f0f0;" ``` ## Examples ### Custom Width ``` description text style="width: 500px;" shortCode style="width: 100px;" ``` ### Custom Colors ``` priority style="background-color: #ffcccc;" notes style="background-color: #f5f5f5; color: #333;" ``` ### Multiple Styles ``` largeInput style="width: 400px; height: 100px; font-size: 14px;" ``` ### Textarea Sizing ``` content text style="width: 100%; height: 200px;" ``` ## Common Style Properties | Property | Example | Description | |----------|---------|-------------| | `width` | `width: 200px;` | Field width | | `height` | `height: 100px;` | Field height (for textarea) | | `background-color` | `background-color: #f0f0f0;` | Background color | | `color` | `color: #333;` | Text color | | `font-size` | `font-size: 14px;` | Text size | | `border` | `border: 1px solid red;` | Border styling | | `padding` | `padding: 10px;` | Inner spacing | ## Best Practices 1. **Prefer CSS classes** - Use the `class` attribute for reusable styles 2. **Use for one-off styling** - Inline styles are good for unique cases 3. **Keep it simple** - Complex styling should be in CSS files ## See Also - [property@class](property-class.md) - CSS class for reusable styles - property@width - Width attribute - property@height - Height attribute # property@subset The `subset` attribute filters the available options for a related entity property. ## Syntax **Simple subset (no parameters):** ```xml ``` **Shorthand:** ``` company Company subset="active" ``` **Parametrized subset:** ```xml ``` **Shorthand:** ``` province Province subset="forCountry" subsetparams="country" ``` ## Description The `subset` attribute restricts which records from a related entity are available for selection. It's used with: 1. **Dropdown filtering** - Only shows matching options in `` | *(empty)* | Short text | | `email` | `String` | `` | `email` | Email with validation | | `phone` | `String` | `` | `phone` | Phone number | | `password` | `String` | `` | `password` | Masked password field | ### Numeric Types | Type | Java | HTML | Validate | Description | |------|------|------|----------|-------------| | `integer` | `Integer` | `` | `integer` | Whole numbers | | `long` | `Long` | `` | `long` | Large whole numbers | | `float` | `Float` | `` | `float` | Decimal (single precision) | | `double` | `Double` | `` | `double` | Decimal (double precision) | ### Date/Time Types | Type | Java | HTML | Validate | Description | |------|------|------|----------|-------------| | `date` | `GregorianCalendar` | `` | `date` | Date only | | `datetime` | `GregorianCalendar` | `` | `datetime` | Date and time | ### Boolean Type | Type | Java | HTML | Validate | Description | |------|------|------|----------|-------------| | `boolean` | `Boolean` | `` | `boolean` | True/false checkbox | ### Long Text Types | Type | Java | HTML | Validate | Description | |------|------|------|----------|-------------| | `text` | `String` | `

### File Types

| Type | Java | HTML | Validate | Description |
|------|------|------|----------|-------------|
| `file` | `String` | File upload widget | `file` | Any file |
| `image` | `String` | Image upload + preview | `image` | Image files with preview |

### Enumeration Type

| Type | Java | HTML | Validate | Description |
|------|------|------|----------|-------------|
| `enum` | `String` | `<select>` | - | Enumerated values |

## Generated Code Examples

### Integer Property

**Source:**
```
age integer
```

**Java:**
```java
private Integer age;

public Integer getAge() { return age; }
public void setAge(Integer age) { this.age = age; }
```

### Date Property

**Source:**
```
birthDate date
```

**Java:**
```java
private java.util.GregorianCalendar birthDate;

public java.util.GregorianCalendar getBirthDate() { return birthDate; }
public void setBirthDate(java.util.GregorianCalendar birthDate) { this.birthDate = birthDate; }
```

### Boolean Property

**Source:**
```
active boolean
```

**Java:**
```java
private Boolean active;

public Boolean getActive() { return active; }
public void setActive(Boolean active) { this.active = active; }
```

### Text Property

**Source:**
```
bio text
```

**Java:**
```java
private String bio;

public String getBio() { return bio; }
public void setBio(String bio) { this.bio = bio; }
```

### Password Property

**Source:**
```
secret password
```

### File Property

**Source:**
```
resume file
```

**Java:**
```java
private String resume;  // Stores the file path/name

public String getResume() { return resume; }
public void setResume(String resume) { this.resume = resume; }
```

### Image Property

**Source:**
```
photo image
```

### Enum Property

**Source:**
```xml
<enumset name="Priority">
   <enum value="low">Low</enum>
   <enum value="medium">Medium</enum>
   <enum value="high">High</enum>
</enumset>
```

```
priority enum enumset="Priority" default="medium"
```

## Examples

### Numeric Properties

```
Product @Products
   quantity integer default="0"
   price double r
   weight float
```

### Text Properties

```
Article @Content
   title r                      // defaults to string
   summary text                 // TEXT column, textarea
   content longtext             // LONGTEXT for very large content
```

### Date Properties

```
Event @Calendar
   eventDate date r
   startTime datetime
   createdAt datetime fixed default="now"
```

### Boolean Properties

```
User @Users
   active boolean default="true"
   verified boolean
   newsletter boolean
```

### File Properties

```
Document @Documents
   title d r
   attachment file r
   thumbnail image
```

### Password Property

```
User @Users
   username d r
   password password r
```

## Default Values by Type

Use the `default` attribute to set initial values:

```
status default="active"
count integer default="0"
createdAt datetime default="now"
active boolean default="true"
```

## Widget Override

The default widget can be overridden with the `widget` attribute:

```
birthDate date widget="jdatepicker"     // jQuery datepicker
description text widget="html"          // Rich text editor
active boolean widget="select"          // Dropdown instead of checkbox
```

## See Also

- [property@name](property-name.md) - Property identifier
- [property@entity](property-entity.md) - Entity relationships
- property@widget - Custom widgets
- [property@default](property-default.md) - Default values
- enumset - Defining enumerations

# restriction

The `<restriction>` element specifies a complex HQL/SQL condition that cannot be expressed with simple `<condition>` elements.

## Syntax

```xml
<restriction expr="email IS NOT NULL" />

<restriction expr="email LIKE CONCAT('%', ?, '%')">
    <param value="domain" />
</restriction>
```

## Description

A restriction:

1. **Uses raw HQL/SQL** - Write the condition expression directly
2. **Supports placeholders** - Use `?` for parameter values
3. **References current entity** - Use `me` alias for the entity
4. **Enables complex queries** - EXISTS, subqueries, functions

## Attributes

| Attribute | Required | Type | Description |
|-----------|----------|------|-------------|
| `expr` | Yes | string | HQL/SQL expression (use `?` for parameters, `me` for current entity) |
| `usedistinct` | No | string | Use DISTINCT in query |

## Child Elements

| Element | Description |
|---------|-------------|
| `<param>` | Provides values for `?` placeholders (in order) |

## Generated Code

### Simple Restriction (No Parameters)

**Source:**
```xml
<restriction expr="email IS NOT NULL" />
```

**Hibernate DAO:**
```java
Object[] paramsN65715 = new Object[0];
filter = filter.and(new HibernateFilter("email IS NOT NULL", paramsN65715, false));
```

### Restriction with Parameter

**Source:**
```xml
<subset name="emailContains">
    <param name="domain" type="string" />
    <restriction expr="email LIKE CONCAT('%', ?, '%')">
        <param value="domain" />
    </restriction>
</subset>
```

**Hibernate DAO:**
```java
public Filter getEmailContainsSubsetFilter(String domain) {
    Map<String, Object> map = new HashMap<String, Object>();
    map.put("domain", domain);

Filter filter = new HibernateFilter();

Object[] paramsN65728 = new Object[1];
    paramsN65728[0] = el.evaluate("${domain}", map);
    filter = filter.and(new HibernateFilter("email LIKE CONCAT('%', ?, '%')", paramsN65728, false));

return filter;
}
```

## Examples

### IS NULL / IS NOT NULL

```xml
<restriction expr="email IS NOT NULL" />
<restriction expr="deletedAt IS NULL" />
```

### LIKE with Parameter

```xml
<subset name="searchByName">
    <param name="searchTerm" type="string" />
    <restriction expr="LOWER(me.name) LIKE LOWER(CONCAT('%', ?, '%'))">
        <param value="searchTerm" />
    </restriction>
</subset>
```

### EXISTS Subquery

```xml
<subset name="withOrders">
    <restriction expr="EXISTS (FROM Order o WHERE o.customer = me)" />
</subset>
```

### NOT EXISTS Subquery

```xml
<subset name="withoutOrders">
    <restriction expr="NOT EXISTS (FROM Order o WHERE o.customer = me)" />
</subset>
```

### EXISTS with Parameter

```xml
<subset name="orderedProduct">
    <param name="product" entity="Product" />
    <restriction expr="EXISTS (FROM OrderLine ol WHERE ol.order.customer = me AND ol.product = ?)">
        <param value="product" />
    </restriction>
</subset>
```

### Date Functions

```xml
<subset name="recentlyCreated">
    <restriction expr="me.createdAt > DATE_SUB(CURRENT_DATE(), INTERVAL 30 DAY)" />
</subset>
```

### Multiple Parameters

```xml
<subset name="dateRange">
    <param name="startDate" type="date" />
    <param name="endDate" type="date" />
    <restriction expr="me.orderDate BETWEEN ? AND ?">
        <param value="startDate" />
        <param value="endDate" />
    </restriction>
</subset>
```

Parameters are matched to `?` placeholders in order.

### CASE Expression

```xml
<subset name="highPriority">
    <restriction expr="CASE WHEN me.priority = 'HIGH' THEN 1 WHEN me.urgent = true THEN 1 ELSE 0 END = 1" />
</subset>
```

### JOIN Conditions

```xml
<subset name="inActiveCompany">
    <restriction expr="me.company.active = true" />
</subset>
```

### Aggregate Subquery

```xml
<subset name="bigCustomers">
    <restriction expr="(SELECT COUNT(*) FROM Order o WHERE o.customer = me) > 10" />
</subset>
```

## Combining with Conditions

You can mix `<restriction>` with `<condition>`:

```xml
<subset name="activeWithEmail">
    <condition field="active" value="true" />
    <restriction expr="email IS NOT NULL" />
</subset>
```

## When to Use Restriction vs Condition

| Scenario | Use |
|----------|-----|
| Simple field comparison | `<condition>` |
| NULL check | `<restriction>` |
| EXISTS/NOT EXISTS | `<restriction>` |
| Subqueries | `<restriction>` |
| LIKE with functions | `<restriction>` |
| Date functions | `<restriction>` |
| Complex expressions | `<restriction>` |

## See Also

- [subset](subset.md) - Parent element
- [condition](condition.md) - Simple field comparisons
- [param](param.md) - Parameter declarations

# subset

The `<subset>` element defines a filtered view of entity records that can be reused in listings, property dropdowns, and REST API endpoints.

## Syntax

```xml
<subset name="active">
    <condition field="active" value="true" />
</subset>
```

## Description

A subset:

1. **Filters records** - Defines conditions to filter entity records
2. **Generates methods** - Creates `findSubsetName()` methods in Service and DAO
3. **REST endpoint** - Exposes as `/xml/Entity/subsetName`
4. **Reusable** - Can be referenced in listings, properties, actions
5. **Composable** - Can extend other subsets with `basesubset`

## Attributes

| Attribute | Required | Type | Description |
|-----------|----------|------|-------------|
| `name` | Yes | string | Unique identifier for the subset |
| `basesubset` | No | string | Parent subset to extend |
| `order` | No | string | Default sort order (e.g., `"name asc"`) |
| `displayproperties` | No | string | Properties to display (comma-separated) |
| `displayset` | No | string | Display set name |
| `hints` | No | string | Query hints |

## Child Elements

| Element | Description |
|---------|-------------|
| [`<param>`](param.md) | Declares a parameter |
| [`<condition>`](condition.md) | Simple field comparison |
| [`<restriction>`](restriction.md) | Complex HQL/SQL expression |
| [`<and>`](and.md) | Combines conditions with AND |
| [`<or>`](or.md) | Combines conditions with OR |
| `<restrict>` | Access control |

## Generated Code

### Subset with No Parameters

**Source:**
```xml
<subset name="active">
    <condition field="active" value="true" />
</subset>
```

**REST Endpoint:** `GET /xml/Person/active`

**Service (PersonServicesAbstract.java):**
```java
public Collection<Person> findSubsetActive(Map<String, String> params) {
    Map<String, Object> map = buildParamsMap(params);
    Filter filters = dao.buildFiltersFromMap(map);
    // ... pagination handling ...
    int count = dao.count(filters.and(dao.getActiveSubsetFilter()));
    List<Person> list = dao.findActive(filters, order, first, max);
    return new Page<Person>(list, pageNumber, (count-1)/max+1, count, pageSize);
}
```

**DAO Interface (PersonDAOAbstract.java):**
```java
public List<Person> findActive();
public List<Person> findActive(Filter filters, String order, int first, int max);
public Filter getActiveSubsetFilter();
```

**Hibernate DAO (HibernatePersonDAOAbstract.java):**
```java
public Filter getActiveSubsetFilter() {
    Map<String, Object> map = new HashMap<String, Object>();
    Filter filter = new HibernateFilter();
    filter = filter.and(new HibernateFilter("me.active = ?", el.evaluate("${true}", map)));
    return filter;
}
```

### Subset with One Parameter

**Source:**
```xml
<subset name="forCompany">
    <param name="company" entity="Company" />
    <condition field="company" value="company" />
</subset>
```

**REST Endpoint:** `GET /xml/Person/forCompany?company={companyId}`

**Service:**
```java
public Collection<Person> findSubsetForCompany(String companyId, Map<String, String> params) {
    Company company = Company.DAO().findById(companyId);
    // ...
    List<Person> list = dao.findForCompany(company, filters, order, first, max);
    return new Page<Person>(list, pageNumber, (count-1)/max+1, count, pageSize);
}
```

**DAO:**
```java
public List<Person> findForCompany(Company company);
public Filter getForCompanySubsetFilter(Company company);
```

### Subset with Two Parameters

**Source:**
```xml
<subset name="forCompanyAndStatus">
    <param name="company" entity="Company" />
    <param name="status" type="string" />
    <condition field="company" value="company" />
    <condition field="status" value="status" />
</subset>
```

**REST Endpoint:** `GET /xml/Person/forCompanyAndStatus?company={companyId}&status={status}`

**Service:**
```java
public Collection<Person> findSubsetForCompanyAndStatus(String companyId, String statusId, Map<String, String> params) {
    Company company = Company.DAO().findById(companyId);
    String status = statusId == null ? null : String.valueOf(statusId);
    // ...
}
```

### Subset Extending Another Subset

**Source:**
```xml
<subset name="activeForCompany" basesubset="active">
    <param name="company" entity="Company" />
    <condition field="company" value="company" />
</subset>
```

**Hibernate DAO:**
```java
public Filter getActiveForCompanySubsetFilter(Company company) {
    Map<String, Object> map = new HashMap<String, Object>();
    map.put("company", company);

Filter filter = new HibernateFilter();
    filter = filter.and(getActiveSubsetFilter());  // Includes base subset
    filter = filter.and(new HibernateFilter("me.company = ?", el.evaluate("${company}", map)));
    return filter;
}
```

## Examples

### Simple Filter (No Parameters)

```xml
<subset name="active">
    <condition field="active" value="true" />
</subset>
```

### Entity Parameter

```xml
<subset name="forCompany">
    <param name="company" entity="Company" />
    <condition field="company" value="company" />
</subset>
```

### Primitive Parameter

```xml
<subset name="byStatus">
    <param name="status" type="string" />
    <condition field="status" value="status" />
</subset>
```

### Multiple Conditions (AND)

```xml
<subset name="activeAdults">
    <condition field="active" value="true" />
    <condition field="age" ge="18" />
</subset>
```

Multiple `<condition>` elements are combined with AND.

### OR Conditions

```xml
<subset name="activeOrPending">
    <or>
        <condition field="status" value="'active'" />
        <condition field="status" value="'pending'" />
    </or>
</subset>
```

### Using Restriction (HQL)

```xml
<subset name="withEmail">
    <restriction expr="email IS NOT NULL" />
</subset>
```

### Restriction with Parameter

```xml
<subset name="emailContains">
    <param name="domain" type="string" />
    <restriction expr="email LIKE CONCAT('%', ?, '%')">
        <param value="domain" />
    </restriction>
</subset>
```

### Extending a Base Subset

```xml
<subset name="activeForCompany" basesubset="active">
    <param name="company" entity="Company" />
    <condition field="company" value="company" />
</subset>
```

### With Custom Order

```xml
<subset name="recentOrders" order="orderDate desc">
    <condition field="status" value="'completed'" />
</subset>
```

## Usage in Properties

Reference a subset in a property to filter dropdown options:

```
company Company subset="active"
```

With parameters:

```
contact Person subset="forCompany" subsetparams="."
```

The `.` refers to the current entity.

## Usage in Listings

```xml
<listing name="main">
    <tab name="all" label="All" />
    <tab name="active" label="Active" subset="active" />
    <tab name="pending" label="Pending" subset="byStatus" subsetparams="'pending'" />
</listing>
```

## Usage in Embedded Listings

```xml
<embeddedlisting
    name="contacts"
    entity="Person"
    subset="forCompany"
    subsetparams="." />
```

## See Also

- [condition](condition.md) - Simple field comparisons
- [restriction](restriction.md) - Complex HQL expressions
- [param](param.md) - Parameter declarations
- [or](or.md) - OR logical operator
- [and](and.md) - AND logical operator

# tab

The `<tab>` element defines a tab within a listing, optionally filtering records by a subset.

## Syntax

```xml
<listing name="main">
    <tab name="all" label="All" />
    <tab name="active" label="Active" subset="active" />
    <tab name="pending" label="Pending" subset="pending" displayactions="approve" />
</listing>
```

## Description

A tab within a listing:

1. **Shows filtered data** - Can use a subset to filter records
2. **Generates tab heading** - Creates clickable tab in UI
3. **Separate data source** - Each tab loads from its own REST endpoint
4. **Custom actions** - Can specify different actions per tab

## Attributes

| Attribute | Required | Type | Description |
|-----------|----------|------|-------------|
| `name` | Yes | string | Tab identifier |
| `label` | No | string | Display label (shown in tab heading) |
| `subset` | No | string | Subset to filter records |
| `subsetparams` | No | string | Parameters for the subset |
| `displayproperties` | No | string | Properties to display |
| `displayset` | No | string | Display set name |
| `displayactions` | No | string | Actions to display |
| `displayactiongroups` | No | string | Action groups to display |
| `mainaction` | No | string | Default row action |
| `displayif` | No | string | Display condition |
| `class` | No | string | CSS class |

## Generated Code

**Source:**
```xml
<listing name="main">
    <tab name="all" label="All" />
    <tab name="active" label="Active" subset="active" />
    <tab name="inactive" label="Inactive" subset="inactive" />
</listing>
```

## Examples

### Basic Tabs

```
Person @CRM
    name d r
    active boolean

<listing name="main">
        <tab name="all" label="All" />
        <tab name="active" label="Active" subset="active" />
        <tab name="inactive" label="Inactive" subset="inactive" />
    </listing>
```

### Tabs with Different Actions

```
Order @Sales
    orderNumber d
    status

<listing name="main">
        <tab name="all" label="All Orders" />
        <tab name="pending" label="Pending" subset="pending" displayactions="approve,reject" />
        <tab name="completed" label="Completed" subset="completed" displayactions="archive,export" />
    </listing>
```

### Tab with Subset Parameters

```
Person @CRM
    name d r
    company Company

<listing name="byCompany">
        <tab name="company1" label="Company A" subset="forCompany" subsetparams="1" />
        <tab name="company2" label="Company B" subset="forCompany" subsetparams="2" />
    </listing>
```

### Tab with Display Condition

```
Order @Sales
    orderNumber d

<listing name="main">
        <tab name="all" label="All" />
        <tab name="admin" label="Admin View" displayif="hasPrivilege('ADMIN')" />
    </listing>
```

### Single Tab Listing

Even with one tab, using `<tab>` creates a consistent structure:

```
Person @CRM
    name d r

<listing name="simple">
        <tab name="all" label="All People" />
    </listing>
```

## Tab Behavior

| Configuration | REST Endpoint | Description |
|---------------|---------------|-------------|
| No subset | `/xml/Person` | Shows all records |
| `subset="active"` | `/xml/Person/active` | Shows filtered records |
| `subset="forCompany" subsetparams="5"` | `/xml/Person/forCompany?company=5` | Shows records with parameter |

## First Tab is Active

The first tab is always active (visible) by default:
- First tab: `class="active"` and content visible
- Other tabs: No active class and `style="display: none;"`

## See Also

- [listing](listing.md) - Parent element
- [subset](subset.md) - Data filtering
- displayset - Display property sets

```
ExpensesScheduleMethod @Rendición_de_Gastos &Método_Rendición order="name asc"
	name "Método" r d
	prefix "Prefijo" ds
	usesDetailedPaymentMethod boolean
	
ExpensesSchedule @Rendición_de_Gastos &Rendición_de_Gastos
	<listing name="re01" noadd="noadd" noremove="noremove" displayactions="" />
	<listing name="forCase" noadd="noadd" noremove="noremove" />
	<listing name="main" noremove="noremove">
		<tab name="pending" subset="pending" label="En Proceso" />
		<tab name="approvalPending" subset="approvalPending" label="Esperando Aprobación" />		
		<tab name="approved" subset="approved" label="Cerradas" />
	</listing>
	<listing name="mainAdmin" noremove="noremove" noadd="noadd">
		<tab name="pendingAdmin" subset="pending" label="En Proceso" />
		<tab name="approvalPendingAdmin" subset="approvalPending" label="Esperando Aprobación" />		
		<tab name="approvedAdmin" subset="approved" label="Cerradas" />
	</listing>
	
	<subset name="pending" order="id desc">
		<condition field="sent" value="false" />
		<or>
			<condition field="author" value="User:find(userId)" />
			<condition field="user" value="User:find(userId)" />
		</or>
	</subset>
	<subset name="approvalPending" order="id desc">
		<condition field="sent" value="true" />
		<condition field="approved" value="false" />
		<or>
			<condition field="author" value="User:find(userId)" />
			<condition field="user" value="User:find(userId)" />
		</or>
	</subset>
	<subset name="approved" order="id desc">
		<condition field="approved" value="true" />
		<or>
			<condition field="author" value="User:find(userId)" />
			<condition field="user" value="User:find(userId)" />
		</or>
	</subset>
	<subset name="pendingAdmin" order="id desc">
		<condition field="sent" value="false" />
	</subset>
	<subset name="approvalPendingAdmin" order="id desc">
		<condition field="sent" value="true" />
		<condition field="approved" value="false" />
	</subset>
	<subset name="approvedAdmin" order="id desc">
		<condition field="approved" value="true" />
	</subset>
	<subset name="forCase">
		<param name="insuranceCase" entity="InsuranceCase" />
		<restriction expr="EXISTS (FROM ExpensesScheduleRef r WHERE r.schedule = me AND r.ref = ?)">
			<param value="insuranceCase.refNumber" />
		</restriction>
	</subset>
	<subset name="forId" order="id desc">
		<param name="id" type="long" />
		<restriction expr="id = ?">
			<param value="id" />
		</restriction>
	</subset>
	
	isUpg boolean hidden
	author User "Autor" fixed default="User:find(userId)"
	user User "Usuario" d default="User:find(userId)" subset="loadTEFor"
	schedulePrefix "C" fixed d displayif="schedulePrefix!=''"
	scheduleNumber "Nro_Rendición" integer fixed d displayif="scheduleNumber!=''"
	date "Fecha_Rendición" ds fixed displayif="date!=''"
	sent "Enviada" boolean hidden default="false"
	approved "Aprobada" boolean hidden default="false"
	method ExpensesScheduleMethod "Método" ds displayif="isUpg='true'"
	reason "Motivo" style="width:400px;" d r
	usesDetailedPaymentMethod displayif="reason='aaa111'" \
		<dynamicvalue expr="method.usesDetailedPaymentMethod"><param name="method" value="method" entity="ExpensesScheduleMethod" /></dynamicvalue>
	currency CurrencyName "Moneda" d r
	amount double "Monto" d r
	
	refs "Refs" ExpensesScheduleRef set ei x childproperty="schedule"
	concepts "Conceptos" ExpensesScheduleConcept set ei x childproperty="schedule"
	
	detail ExpensesDetail "Detalle" list ei x childproperty="schedule" listindex="n"
	
	pdfFile hidden
	xlsxFile hidden
	
	<action name="send" type="relatedentity" entity="SendExpensesSchedule" label="Enviar" location="local" />
	
SendExpensesSchedule @ transient="transient" &Enviar_Rendición
	schedule ExpensesSchedule hidden 
	user User "Usuario" fixed
	reason "Motivo" fixed
	currency CurrencyName "Moneda" fixed
	amount double "Monto" fixed

ExpensesScheduleRef @ &Rendición_de_Gastos
	schedule ExpensesSchedule 
	ref 
	insured "Asegurado" \
		<dynamicvalue expr="InsuranceCase:findOneBy('refNumber', ref).insured">
			<param name="ref" value="ref" />
		</dynamicvalue>
	percentage "%" double

ExpensesScheduleConcept @ &Concepto_Gastos
	schedule ExpensesSchedule 
	concept ExpensesScheduleConceptName "Concepto"
	department Department "Departamento" subset="forSpecificUser" subsetparams="schedule.user"
	percentage "%" double
	
ExpensesScheduleConceptName @Configuracion order="name" &Concepto_Rendicion_Gastos
	name d "Concepto" r
	
ExpensesDetail @
	<subset name="forSchedule">
		<param name="schedule" entity="ExpensesSchedule" />
		<condition field="schedule" value="schedule" />
	</subset>

schedule ExpensesSchedule hidden
	usesInvoice transient \
		<dynamicvalue expr="invoiceType.usesInvoice"><param name="invoiceType" value="invoiceType" entity="ExpensesDetailType" /></dynamicvalue>
	usesDetailedInvoice transient \
		<dynamicvalue expr="invoiceType.usesDetailedInvoice"><param name="invoiceType" value="invoiceType" entity="ExpensesDetailType" /></dynamicvalue>
	usesKm transient \
		<dynamicvalue expr="invoiceType.usesKm"><param name="invoiceType" value="invoiceType" entity="ExpensesDetailType" /></dynamicvalue>
	n integer fixed
	revised "OK" displayif="schedule.isUpg='true'" boolean
	date "Fecha" widget="jdatepicker" style="width:80px;"
	invoiceType "Tipo" ExpensesDetailType r
	invoiceNumber "Número" visibleif="usesInvoice='true'"
	cuit "CUIT" style="width:80px;" visibleif="usesInvoice='true'"
	company "Proveedor" visibleif="usesInvoice='true'" \
		<dynamicvalue expr="Cuit:findOneBy('cuit', cuit).razonSocial">
			<param name="cuit" value="cuit" />
		</dynamicvalue>
	kms integer "Kms_Recorridos" visibleif="usesKm='true'"
	kmPrice "Valor_Km" double style="width:60px;" visibleif="usesKm='true'" \
		<dynamicvalue expr="''"><param name="invoiceType" value="invoiceType" entity="ExpensesDetailType" /></dynamicvalue>
	description "Detalle" r
	currency CurrencyName "Moneda" visibleif="usesInvoice='true'"
	taxedAmount "Gravado" double style="width:80px;" visibleif="usesDetailedInvoice='true'"
	notTaxedAmount "No_Gravado" double style="width:80px;" visibleif="usesInvoice='true'"
	vatPercent "IVA_%" double style="width:80px;" visibleif="usesDetailedInvoice='true'"
	vat "IVA" double style="width:80px;" visibleif="usesDetailedInvoice='true'"
	perceptionGanancias "Percep._Ganancias" double style="width:80px;" visibleif="usesDetailedInvoice='true'"
	percepcionIibb "Percep._IIBB" double style="width:80px;" visibleif="usesDetailedInvoice='true'"
	total double  style="width:80px;"
	paymentMethod "Método_de_Pago" ExpensesScheduleMethod displayif="schedule.usesDetailedPaymentMethod='true'"
	file "Comprobante" visibleif="usesInvoice='true'"
	
ExpensesDetailType @Configuracion order="name" &Tipo_Gastos
	name d r "Tipo"
	usesInvoice "Usa_Factura" boolean
	usesDetailedInvoice "Usa_Factura_Detallada" boolean
	usesKm "Usa_Km" boolean

Cuit @
	cuit
	razonSocial d
```

```
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>

#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" />

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"

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" />

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
```

```
Employee @RRHH & order="username asc"

<action name="viewUser" entity="ViewEmployee" label="Ver" location="local,main" type="relatedentity" />
	
	
	
	<filter name="fileNumber" property="fileNumber" display="primary" />
	<filter name="username" property="username" display="primary" />
	<filter name="firstName" property="firstName" display="primary" />
	<filter name="lastName" property="lastName" display="primary" />
	<filter name="office" display="primary" label="Oficina" entity="Office" subset="active">
		<condition field="user.office" value="office" />
	</filter>
	<filter name="department" display="primary" label="Departamento" entity="Department">
		<condition field="user.department" value="department" />
	</filter>
	
	user User fixed hidden ds
	
	#tab Legajo
		<property label="Foto" name="picture" type="image" transient="transient" />
		lastNameEmployee ds "Apellido(s)"
		firstNameEmployee ds "Nombre(s)"

fileNumber "Legajo Nro"
		
		entryDate date "Fecha_Ingreso" ds widget="jdatepicker"
		entryAge "Antiguedad" integer ds fixed
		exitDate date "Fecha egreso" ds widget="jdatepicker"
        cuil
        <property name="birthDate" label="Fecha de Nacimiento" type="date" widget="jdatepicker" />

#tab Datos Personales
        dni
        <property label="Dirección" name="street" type="text" style="height:40px;" />
        <property label="Ciudad" name="city"/>
        <property label="Localidad" name="locality"/>
        <property entity="State" label="Provincia" name="state" subset="forCountry" subsetparams="country"/>
        <property label="CP" name="postalCode"/>
		<property entity="Country" label="País" name="country"/>

#tab Salud y Emergencias

medicalProvider "Obra social"
    	medicalProviderId "Nro. Afiliado" style="width:200px;"
    	medicalProviderContact "Teléfono emergencias" style="width:200px;"

comments text "Comentarios" style="height:40px;"
    	emergencyContact "Contacto_Emergencia"
    	relacion
    	<box name="emergencyInfo">
	    	<property name="emergencyCountryCode" label="Celular" labelposition="left"  />
	    	<property name="emergencyAreaCode" label=" " labelposition="left" />
	    	<property name="emergencyMobile" label="" labelposition="left"  />
    	</box>

#tab Licencias
	
		tags LeaveTag set "Etiquetas" ds widget="checkbox"
		<embeddedlisting label="Extras" name="extras" entity="EmployeeLeaveTypeExtra" subset="forEmployee" subsetparams="." defaultset="newForEmployee" defaultsetparams="." />
		
		<embeddedlisting label="Solicitar" name="leaveTypes" entity="EmployeeLeaveType" subset="requestableForEmployee" subsetparams="." defaultset="newForEmployee" defaultsetparams="." />
		<embeddedlisting label="Pedidos de Licencia" name="leaves" entity="LeaveRequest" subset="forEmployee" subsetparams="." defaultset="newForEmployee" defaultsetparams="." />	
	
	#tab Familia
		spouse
		children Child ei x set childproperty="employee"

#tab Bancarios
		cbu text

#tab Otros
    	<property name="phone" label="Teléfono Interno" transient="transient" />
    	mobileLineByCompany "Línea Empresa" boolean
    	mobileDeviceByCompany "Equipo Empresa" boolean
    	hasKey "Tiene Llave" boolean
    	hasNotebook "Tiene Notebook" boolean
    	hasCarLicense "Tiene Cédula Azul Auto Empresa" boolean
		<property name="calendars" entity="EventCalendar" collection="set" label="Calendarios" transient="transient" subset="forEmployee" subsetparams="." />
        paymentMethod PaymentMethod set "Metodos de Pago Habilitados" ds widget="checkbox" subset="forEmployee" subsetparams="."

#tab Datos Intranet
        firstName expr="this.user.firstName" fixed ds "Nombre"
		lastName expr="this.user.lastName" ds fixed "Apellido"
		username d r fixed
		office Office expr="this.user.office" fixed "Oficina"
    	<property name="jobFunction" label="Función" type="text" style="height:40px;" />
        <property name="roleTE" label="Rol TE" entity="Role" />
		supervisor User subset="active"
    	<property name="departments" label="Departamentos" collection="list" entity="Department" fixed="fixed" />

Child @
	employee Employee hidden
	firstName d "Nombre"
	lastName d "Apellido"
	birthdate date widget="jdatepicker" "Fecha_de_Nacimiento"

LeaveTag @RRHH &Etiqueta
	
	name d "Etiqueta" r

AssignTags @ &Asignar_Etiquetas transient="transient"
	<defaultset name="forEmployees">
		<param name="employees" entity="Employee" collection="set" />
		<default name="employees" value="employees" />
	</defaultset>

employees set Employee "Empleados" fixed
	tag LeaveTag "Etiqueta" r

LeaveType @RRHH &Tipo_Licencia order="name"
	<filter name="country" property="country" display="primary" />
	<filter name="tags" property="tags" display="primary" />

editable boolean hidden
	name "Nombre" d r disabledif="editable='false'"
	active "Activo" default="true" boolean disabledif="editable='false'"
	country Country ds "País" subset="userOffices" r disabledif="editable='false'"
	daysPerEvent "Días_por_Evento" integer ds disabledif="editable='false'"
	daysPerYear "Días_por_Año" integer ds disabledif="editable='false'"
	enableOnMonth "Mes en que se habilita" integer tooltip="Por ej. mes 10 para vacaciones." ds disabledif="editable='false'"
	enableOnAnniversary "Habilitar en el aniversario" boolean ds disabledif="editable='false'"
    fractionatedLeave "Periodos fraccionados" boolean ds disabledif="editable='false'" default="false"
    daysFractionated "Días minimos por periodo fraccionado (separar por coma)" displayif="fractionatedLeave='true'"
	format "Formato" enum r ds disabledif="editable='false'" \
		<enum value="run">Días corridos</enum>
		<enum value="business">Días hábiles</enum>
		<enum value="slots">Turnos</enum>
        <enum value="unique">Día único</enum>
	requiredAge "Antiguedad_mínima" integer disabledif="editable='false'"
	allEmployees "Aplica_a_todos?" boolean disabledif="editable='false'" default="true"
	tags LeaveTag set widget="checkbox" ds displayif="allEmployees='false'" disabledif="editable='false'"
	rules "Reglas" LeaveRules set ei x setorder="fromAge" childproperty="type"
	maximum integer "Máximo" disabledif="editable='false'"
	requirements text "Requerimientos" disabledif="editable='false'"
	allowFile boolean "Permitir_adjunto" disabledif="editable='false'" default="false"
	requireFile boolean "Requerir_adjunto" disabledif="editable='false'" default="false"
	cumulative boolean "Acumulables?" ds disabledif="editable='false'" default="false"
	manual boolean "Manual?" ds disabledif="editable='false'" default="true"
    allowOverlap boolean "Permitir_Superposicion?" disabledif="editable='false'" default="false"
	requestableByEmployee boolean "Solicitable_por_Empleado?" disabledif="editable='false'" default="true"
	requestableByAdmin boolean "Solicitable_por_Admin?" disabledif="editable='false'" default="true"
	noOOO boolean "No_activa_OOO" disabledif="editable='false'" default="false"
	availableFrom "Vigencia_desde" date widget="jdatepicker" disabledif="editable='false'"
	availableTo "Vigencia_hasta" date widget="jdatepicker" disabledif="editable='false'"
	style "Estilo" disabledif="editable='false'"

LeaveRules @
	type LeaveType "Licencia"
	fromAge integer 
	toAge integer
	days integer
	
EmployeeLeaveTypeExtra @ &Extras order="since"	
	<subset name="forEmployee" order="since">
		<param name="employee" entity="Employee" />
		<condition field="employee" value="employee" />
	</subset>
	<defaultset name="newForEmployee">
		<param name="employee" entity="Employee" />
		<default name="employee" value="employee" />
		<default name="country" value="employee.country" />
	</defaultset>
	
	employee Employee "Empleado" fixed
	country Country hidden \
	    <dynamicvalue expr="employee.country"><param name="employee" value="employee" entity="Employee" /></dynamicvalue>
	office Office hidden \
        <dynamicvalue expr="employee.office"><param name="employee" value="employee" entity="Employee" /></dynamicvalue>

type LeaveType "Tipo" ds subset="forEmployee" subsetparams="employee"
	since "Desde_(año)" integer ds r 
	extras integer ds r

EmployeeLeaveType @ &Licencia_Habilitada noadd="noadd" noremove="noremove" order="type.name asc"
	<listing name="forEmployee" noadd="noadd" noremove="noremove" />
	
	<subset name="requestableForEmployee" order="type.name asc">
		<param name="employee" entity="Employee" />
		<condition field="employee" value="employee" />
		
		<condition field="type.requestableByEmployee" value="true" />
        <condition field="type.active" value="true" />
        <condition field="type.country" value="employee.office.country" />
		<restriction expr="(type.availableFrom IS NULL OR type.availableFrom <= NOW())" />
		<restriction expr="(type.availableTo IS NULL OR type.availableTo >= NOW())" />
	</subset>

<subset name="forEmployee">
		<param name="employee" entity="Employee" />
		<condition field="employee" value="employee" />
		
	</subset>
	<defaultset name="newForEmployee">
		<param name="employee" entity="Employee" />
		<default name="employee" value="employee" />
		<default name="editable" value="true" />
		<default name="country" value="employee.country" />
	</defaultset>
	
	editable boolean hidden
	employee Employee "Empleado" fixed
	country Country hidden \
        <dynamicvalue expr="employee.country"><param name="employee" value="employee" entity="Employee" /></dynamicvalue>
    office Office hidden \
        <dynamicvalue expr="employee.office"><param name="employee" value="employee" entity="Employee" /></dynamicvalue>
	type LeaveType "Tipo" fixed ds subset="manualForCountry" subsetparams="employee.office.country"
	 
	<property name="available" label="Disponible" type="integer" fixed="fixed" display="secondary" />
	
	<embeddedlisting name="year" entity="EmployeeLeaveTypeYear" subset="forEmployeeLeaveType" subsetparams="." defaultset="newForEmployeeLeaveType" defaultsetparams="." />
	
	<action name="requestLeave" type="relatedentity" entity="RequestLeave" location="local" label="Solicitar" defaultset="forEmployeeLeaveType" displayclass="canRequest"/>
	
EmployeeLeaveTypeYear @ &Licencia_Habilitada noadd="noadd"

<subset name="forEmployeeLeaveType" order="year desc">
		<param name="elt" entity="EmployeeLeaveType" />
		<condition field="employee" value="elt.employee" />
		<condition field="type" value="elt.type" />
	</subset>
	
	<defaultset name="newForEmployeeLeaveType">
		<param name="elt" entity="EmployeeLeaveType" />
		<default name="employee" value="elt.employee" />
		<default name="type" value="elt.type" />
	</defaultset>
	
	editable boolean hidden
	employee Employee "Empleado" fixed
	country Country hidden
    office Office hidden \
        <dynamicvalue expr="employee.office"><param name="employee" value="employee" entity="Employee" /></dynamicvalue>
	type LeaveType "Tipo" disabledif="editable='false'" ds subset="manualForCountry" subsetparams="employee.office.country"
	year "Año" ds integer disabledif="editable='false'"
	<property name="perYear" label="Por año" type="integer" fixed="fixed" display="secondary" formula="(SELECT SUM(COALESCE(ru.days, lt.daysperyear)) FROM leavetype lt INNER JOIN employee emp LEFT OUTER JOIN leaverules ru ON ru.type = lt.id AND emp.entryage BETWEEN ru.fromage AND ru.toage WHERE lt.id = type AND emp.id = employee)" />
	<property name="perEvent" label="Por evento" type="integer" fixed="fixed" display="secondary" formula="(SELECT lt.daysperevent FROM leavetype lt WHERE lt.id = type)" />
	<property name="extra" label="Extra" type="integer" fixed="fixed" display="secondary" formula="(SELECT elte.extras FROM employeeleavetypeextra elte WHERE elte.type = type AND elte.employee = employee AND elte.since <= year ORDER BY elte.since DESC LIMIT 1)" />
	pending "Pendientes de años anteriores" integer ds
	<property name="taken" label="Tomado" type="integer" fixed="fixed" display="secondary" formula="(SELECT SUM(COALESCE(lry.totaldays,0)) FROM leaverequestyear lry INNER JOIN leaverequest lr ON lr.id = lry.leaverequest INNER JOIN leaverequeststate state ON state.id = lr.state WHERE state.takes = 1 AND lr.type = type AND lr.employee = employee AND lry.year = year)" />
	maximum "Máximo" integer fixed ds formula="(SELECT lt.maximum FROM leavetype lt WHERE lt.id = type)"
	<property name="available" label="Disponible" type="integer" fixed="fixed" display="secondary" />
	comments text "Comentarios" disabledif="editable='false'"
	style hidden expr="this.type.style"
	
LeaveRequestState @RRHH &Estado order="name"
	name "Estado" d r
	style
	takes boolean
	approved boolean
	pending boolean
	
CancelLeave @ transient="transient" &Cancelar_Pedido_de_Licencia
	<next type="function" function="nextCancelLeave" />

leaveRequest LeaveRequest hidden
	employee Employee "Empleado" fixed
	type LeaveType "Tipo" fixed
	fromDate date "Desde" fixed
	toDate date "Hasta" fixed
	totalDays integer "Días" fixed
	
ApproveLeave @ transient="transient" &Aprobar_Pedido_de_Licencia
	<next type="function" function="nextCancelLeave" />

leaveRequest LeaveRequest hidden
	employee Employee "Empleado" fixed
	type LeaveType "Tipo" fixed
	fromDate date "Desde" fixed
	toDate date "Hasta" fixed
	totalDays integer "Días" fixed
	
DenyLeave @ transient="transient" &Denegar_Pedido_de_Licencia
	<next type="function" function="nextCancelLeave" />

LeaveRequest @RRHH &Pedidos_de_Licencia order="fromDate desc" defaultlisting="main" noadd="noadd" noremove="noremove"
	<action name="cancel" label="Cancelar" type="relatedentity" entity="CancelLeave" defaultset="forLeaveRequest" location="local" displayclass="cancelLeave" />
	<action name="approve" label="Aprobar" type="relatedentity" entity="ApproveLeave" defaultset="forLeaveRequest" location="local" displayclass="approveLeave"/>
	<action name="deny" label="Denegar" type="relatedentity" entity="DenyLeave" defaultset="forLeaveRequest" location="local" displayclass="denyLeave"/>
	<action name="edit" label="Modificar" type="relatedentity" entity="EditLeave" defaultset="forLeaveRequest" location="local" displayclass="editLeave" />

requestDate "Solicitado" date fixed ds
	employee Employee "Empleado" fixed r ds
	country Country transient expr="this.employee.country" hidden
    office Office hidden \
        <dynamicvalue expr="employee.office"><param name="employee" value="employee" entity="Employee" /></dynamicvalue>
	type LeaveType "Tipo" ds subset="manualForCountry" subsetparams="employee.office.country" r disabled
	fromDate date "Desde" ds widget="jdatepicker" r disabled
	toDate date "Hasta" ds widget="jdatepicker" r disabled
	totalDays integer "Días" ds r disabled \
			<dynamicvalue expr="''"><param name="employee" value="employee" entity="Employee" /><param name="fromDate" value="fromDate" type="date" /><param name="toDate" value="toDate" type="date" /><param name="type" value="type" /><param name="leaveRequest" value="." /></dynamicvalue>
	comments text "Comentarios" disabled
	denialReason "Motivos Rechazo" text displayif="denialReason != ''"
	file "Adjunto"
	state LeaveRequestState "Estado" ds r fixed
	reviser Employee "Aprobador" ds fixed
	style hidden expr="this.state.style"
	notifiedStart boolean hidden
	notifiedEnd boolean hidden
	
	<embeddedlisting name="years" entity="LeaveRequestYear" subset="forLeaveRequest" subsetparams="." />
	
LeaveRequestYear @ noadd="noadd" noremove="noremove"
	<subset name="forLeaveRequest" order="year">
		<param name="leaveRequest" entity="LeaveRequest" />
		<condition field="leaveRequest" value="leaveRequest" />
	</subset>

leaveRequest LeaveRequest fixed d
	year integer fixed d
	totalDays integer fixed d
	
EditEmployeeInfo @Cuenta &Información_RRHH transient="transient"

employee hidden Employee
 	<property name="firstName" label="Nombre" fixed="fixed" />
	<property name="lastName" label="Apellido" fixed="fixed" />
	<property name="username" label="Iniciales" fixed="fixed" />
	fileNumber "Legajo" fixed
	<property name="entryDate" label="Fecha de Ingreso" fixed="fixed" type="date" />
	<property name="phone" label="Teléfono Interno" />
	<row>
    	<property name="mobileCountryCode" label="Celular" labelposition="left"  />
    	<property name="mobileAreaCode" label="" labelposition="left" />
    	<property name="mobile" label="" labelposition="left"  />
	</row>
	<property entity="Country" label="País" name="country"/>
    <property entity="State" label="Provincia" name="state" subset="forCountry" subsetparams="country"/>
    <property label="Ciudad" name="city"/>
    <property label="Localidad" name="locality"/>
    <property label="Dirección" name="street" type="text" />
    <property label="CP" name="postalCode"/>
	<property name="birthDate" label="Fecha de Nacimiento" fixed="fixed" type="date" />
	<property name="jobFunction" label="Función" type="text" fixed="fixed"/>
    <property name="office" label="Oficina" entity="Office" fixed="fixed" />
    <property name="departments" label="Departamentos" collection="list" entity="Department" fixed="fixed" />

spouse "Cónyuge/Pareja_conviviente"
	children "Hijos" Child ei x set

cbu text
		
EditEmployeeLicences @Cuenta &Licencias transient="transient"  
	employee fixed Employee "Empleado"
	 	
	<embeddedlisting label="Solicitar Licencias" name="leaveTypes" entity="EmployeeLeaveType" listing="forEmployee" subset="requestableForEmployee" subsetparams="employee" defaultset="newForEmployee" defaultsetparams="employee" />
	<embeddedlisting label="Licencias Solicitadas" name="leaves" entity="LeaveRequest" listing="mine" subset="mine" defaultset="newForEmployee" defaultsetparams="employee" />	
	  
ViewTeamLeaves @RRHH &Mi_Equipo_Licencias transient="transient"
    #tab name="myTeam" label="Mi equipo"
        <embeddedlisting name="team" entity="Employee" listing="team" subset="team" />
    #tab name="myTeamLeaves" label="Licencias de mi equipo"
        <embeddedlisting label="Licencias Pendientes de Aprobación" name="pendingLeaves" entity="LeaveRequest" listing="myTeamPending" subset="myTeamPending" />
        <embeddedlisting label="Historial de Licencias" name="leaves" entity="LeaveRequest" listing="myTeamHistory" subset="myTeamHistory" />
	
ViewEmployee @ &Datos_de_Contacto transient="transient"	
	
	<action name="close" label="Cerrar" location="form" type="javascript" function="closeWindow" />
	
	#tab Datos
		employee Employee hidden
		showLeaves boolean hidden
        
        <property label="Foto" name="picture" type="image" fixed="fixed" />    
     	<property name="firstName" label="Nombre" fixed="fixed" />
    	<property name="lastName" label="Apellido" fixed="fixed"/>
    	<property name="username" label="Iniciales" fixed="fixed" />
    	<property name="office" label="Oficina" entity="Office" fixed="fixed" />
    	<property name="email" label="Email" fixed="fixed" />
    	<property name="phone" label="Teléfono Interno" fixed="fixed" />
    	<property name="mobile" label="Celular" fixed="fixed"/>
        
    	<property name="birthDate" label="Fecha de Nacimiento" fixed="fixed" type="date" />
    	<property name="jobFunction" label="Función" type="text" fixed="fixed" />
    	<property name="departments" label="Departamentos" collection="list" entity="Department" fixed="fixed" />
    	<property name="entryDate" label="Fecha de Ingreso" fixed="fixed" type="date" />
    	
    #tab name="leaves" label="Licencias" displayif="showLeaves='true'"
    	<embeddedlisting label="Solicitar Licencias" name="leaveTypes" entity="EmployeeLeaveType" listing="forEmployee" subset="requestableForEmployee" subsetparams="employee" defaultset="newForEmployee" defaultsetparams="employee" />
    	<embeddedlisting label="Pedidos de Licencia" name="leaves" entity="LeaveRequest" subset="forEmployeeApproved" subsetparams="employee" />
  
RequestLeave @ transient="transient" &Solicitar_Licencia

amISupervisor boolean
	hasPerEvent boolean hidden
	employee Employee "Empleado" fixed
	type LeaveType "Tipo_de_Licencia" fixed
	reviser Employee "Aprobador" fixed	
	available "Días Disponibles" integer fixed displayif="available!=''"
	availablePerEvent "Días Disponibles por Evento" fixed integer displayif="hasPerEvent='true'"
	requirements text "Requerimientos" displayif="requirements!=''" fixed
	allowFile boolean hidden
	allowOverlap boolean hidden
	file "Adjunto" displayif="allowFile='true'"
	format "Formato" enum fixed \
		<enum value="run">Días corridos</enum>
		<enum value="business">Días hábiles</enum>
		<enum value="slots">Turnos</enum>
        <enum value="unique">Día único</enum>
	dateFrom date "Desde" r widget="jdatepicker"
	dateTo date "Hasta" widget="jdatepicker"
	slots Slot set widget="checkbox" "Turno" displayif="format = 'slots'"
	totalDays "Total Días" integer disabled \
		<dynamicvalue expr="''"><param name="employee" value="employee" entity="Employee" /><param name="dateFrom" value="dateFrom" type="date" /><param name="dateTo" value="dateTo" type="date" /><param name="format" value="format" /><param name="slots" value="slots" /></dynamicvalue>
	comments text "Comentarios"

EditLeave @ transient="transient" &Editar_Licencia
	<next type="function" function="nextRequestLeave" />

leaveRequest LeaveRequest hidden
	requestDate "Solicitado" date fixed ds
	employee Employee "Empleado" fixed r
	country Country transient expr="this.employee.country" hidden
    office Office hidden \
        <dynamicvalue expr="employee.office"><param name="employee" value="employee" entity="Employee" /></dynamicvalue>
	type LeaveType "Tipo" ds subset="manualForCountry" subsetparams="employee.office.country" r
	fromDate date "Desde" ds widget="jdatepicker" r
	toDate date "Hasta" ds widget="jdatepicker" r
	totalDays integer "Días" ds r  \
			<dynamicvalue expr="''"><param name="employee" value="employee" entity="Employee" /><param name="fromDate" value="fromDate" type="date" /><param name="toDate" value="toDate" type="date" /><param name="type" value="type" /><param name="leaveRequest" value="leaveRequest" /></dynamicvalue>
	comments text "Comentarios"
	denialReason "Motivos Rechazo" text displayif="denialReason != ''"
	file "Adjunto"
	state LeaveRequestState "Estado" ds r fixed
	reviser Employee "Aprobador" ds fixed
	style hidden expr="this.state.style"

Slot @RRHH &Turno
	name "Turno" d
```

```
<enumset name="Trigger">
    <enum value="CREACION">Creación de Ticket</enum>
    <enum value="ESTADO">Cambio de Estado</enum>
    <enum value="CRITICIDAD">Cambio de Criticidad</enum>
    <enum value="MENSAJE">Nuevo Mensaje</enum>
    <enum value="MENSAJE_INTERNO">Nuevo Mensaje Interno</enum>
    <enum value="ASIGNACION">Asignación/Reasignación</enum>
    <enum value="CIERRE">Cierre de Ticket</enum>
</enumset>

Ticket @ noadd="noadd" noremove="noremove" order="id desc"
    
    <listing name="usuario" layout="simple" noadd="noadd" noremove="noremove" displayfilters="numero,titulo,categoria,subcategoria,criticidad, encargado, solicitante, grupo" displayactions="" >
        <tab name="todos" label="Todos" subset="visibles" displayactions="reasignar,cerrar" />
        <tab name="iniciados" label="Iniciados" subset="iniciados" displayactions="reasignar, cerrar"/>
        <tab name="aceptados" label="Aceptados" subset="aceptados" displayactions="cerrar"/>
        <tab name="enProceso" label="En Proceso" subset="enProceso" displayactions="cerrar"/>
        <tab name="cerrados" label="Cerrados" subset="cerrados" displayactions="reabrir"/>
    </listing>
    
    <listing name="encargado" layout="simple" noadd="noadd" noremove="noremove" displayfilters="numero,titulo,categoria,subcategoria,criticidad, encargado, solicitante, grupo" displayactions="">
        <tab name="todos" label="Todos" subset="visiblesEncargado" displayactions="reasignar,cerrar"/>
        <tab name="iniciados" label="Iniciados" subset="iniciadosEncargado" displayactions="reasignar, cerrar"/>
        <tab name="aceptados" label="Aceptados" subset="aceptadosEncargado" displayactions="pasarAEnProceso, cerrar"/>
        <tab name="enProceso" label="En Proceso" subset="enProcesoEncargado" displayactions="cerrar"/>
        <tab name="cerrados" label="Cerrados" subset="cerradosEncargado" displayactions="reabrir"/>
    </listing>

<tab label="Principal">
        <box class="cols">
            <box>
                numero fixed d formula="id"
                fechaApertura datetime ds fixed default="now"
                fechaCierre datetime ds fixed displayif="fechaCierre != ''"
                titulo d text r style="width:500px;height:45px;" "Título"
                <embeddedlisting name="campos" entity="CampoValor" listing="paraTicket" subset="paraTicket" subsetparams="." defaultset="paraTicketDefault" defaultsetparams="."  />
                detalle text style="width:500px;height:140px;" widget="html" required="required"
                <box class="cols" style="margin-top: 10px;">
                    <box>
                        categoria Categoria ds disabledif="esAdmin !='true' and esEncargado != 'true'" required="required"
                        subCategoria SubCategoria ds disabledif="esAdmin !='true' and esEncargado != 'true'" subset="paraCategoria" subsetparams="categoria" whennotinsubset="donotshow" required="required" \
                            <displaycondition expr="categoria.tieneSubcategorias">
                                <param entity="Categoria" name="categoria" value="categoria"/>
                            </displaycondition>
                        grupo Grupo ds disabledif="esAdmin !='true' and esEncargado != 'true'" required="required"
                        criticidad Criticidad ds disabledif="esAdmin !='true' and esEncargado != 'true'" required="required"
                    </box>
                    <box>
                        solicitante User ds "Solicitante" disabled
                        encargado User ds "Encargado" disabledif="esAdmin !='true' and esEncargado != 'true'" subset="delGrupo" subsetparams="."
                        estado Estado ds disabledif="esAdmin !='true' and esEncargado != 'true'"
                    </box>
                </box>
                referencia ds
                print image
                adjunto file
                documentosAsociados file

esAdmin boolean hidden default="false" transient
                esEncargado boolean hidden default="false" transient
                esInterno boolean hidden default="false" transient

</box>
            <box>
                <embeddedlisting name="registro" entity="Registro" listing="paraTicket" subset="paraTicket" subsetparams="." defaultset="nuevoParaTicket" defaultsetparams="."  />
            </box>
        </box>
    </tab>
    <tab label="Enlaces" name="enlaces" displayif="esAdmin = 'true' or esEncargado = 'true'">
            <box>
                <embeddedlisting name="enlaces" entity="Enlace" listing="paraTicket" subset="paraTicket" subsetparams="." defaultset="nuevoParaTicket" defaultsetparams="."/>
            </box>
    </tab>
    <tab label="Registro de acciones" name="registroAcciones" displayif="esAdmin = 'true' or esInterno = 'true'">
        <box>
            usuariosInternos User set subset="activos"
            <embeddedlisting name="registroInterno" entity="Registro" listing="paraTicketInterno" subset="paraTicketInterno" subsetparams="." defaultset="nuevoParaTicketInterno" defaultsetparams="." />
        </box>
    </tab>

CrearTicket @Tickets transient="transient"

categoria Categoria "Categoría" required="required"
    subCategoria SubCategoria ds subset="paraCategoria" subsetparams="categoria" "Subcategoría" required="required"
    criticidad Criticidad required="required"
	titulo text style="width:500px;height:45px;" "Título" required="required"
	campos ei set CampoValor \
        <dynamicforeach select="Campo:findManyBy('subCategoria', subCategoria)" setproperty="campo">
            <param entity="SubCategoria" name="subCategoria" value="subCategoria"/>
        </dynamicforeach>
    detalle text style="width:500px;height:140px;" widget="html" required="required"
    
    <box class="cols">
		<box>
			fecha hidden
		</box>
	</box>

referencia \
		<displaycondition expr="subCategoria.requiereReferencia == true">
			<param name="subCategoria" value="subCategoria" entity="SubCategoria" />
		</displaycondition>
	print image style="max-width: 500px; max-height: 190px;" \
        <displaycondition expr="subCategoria.requierePrint == true">
            <param name="subCategoria" value="subCategoria" entity="SubCategoria" />
        </displaycondition>
	adjunto file \
        <displaycondition expr="subCategoria.requiereAdjunto == true">
            <param name="subCategoria" value="subCategoria" entity="SubCategoria" />
        </displaycondition>
    documentosAsociados file

Grupo @Configuración
	grupo d
	encargado set User ds subset="activos"
	admin set User ds subset="activos"
	oficina set Oficina ds
	icono

Criticidad @Configuración
	criticidad d
	tiempoDeResolucion integer
	estilo text

Estado @Configuración
	estado d
    permitePasarAEnProceso boolean default="false"
    permiteCerrar boolean default="false"
    permiteReabrir boolean default="false"
    permiteAsignar boolean default="false"

Categoria @Configuración
	categoria d
	tieneSubcategorias boolean hidden formula="EXISTS ( SELECT 1 FROM subcategoria sc WHERE sc.categoria = id)"

SubCategoria @Configuración
	<subset name="paraCategoria">
		<param name="categoria" entity="Categoria" />
		<condition field="categoria" value="categoria" />
	</subset>

categoria Categoria ds
	subCategoria d
	grupos set Grupo ds
	requiereTexto boolean
	requiereReferencia boolean
	requierePrint boolean
	requiereAdjunto boolean

Campo @Configuración order="subCategoria asc, orden asc"
	<subset name="paraSubCategoria">
		<param name="subCategoria" entity="SubCategoria" />
		<condition field="subCategoria" value="subCategoria" />
	</subset>

subCategoria SubCategoria ds
	nombre d "Campo"
	tipo enum \
		<enum value="texto">texto</enum>
		<enum value="textomultirenglon">textomultirenglon</enum>
		<enum value="numeroInt">numero</enum>
		<enum value="print">print</enum>
		<enum value="adjunto">adjunto</enum>
        <enum value="checkbox">checkbox</enum>

orden integer ds

CampoValor @Logs order="campo asc"
	<subset name="paraTicket" order="campo asc">
		<param name="ticket" entity="Ticket" />
		<condition field="ticket" value="ticket" />
	</subset>

campo Campo fixed d
	tipo hidden transient
	texto displayif="tipo = 'texto'" d
	numeroInt integer displayif="tipo = 'numeroInt'" d
	textoMultilinea text displayif="tipo = 'textomultirenglon'" d
	print image displayif="tipo = 'print'" d
	adjunto file displayif="tipo = 'adjunto'" d
	checkbox displayif="tipo = 'checkbox'" boolean d
	ticket Ticket hidden fixed

Registro @Logs order="id desc"
	<subset name="paraTicket" order="id desc">
		<param name="ticket" entity="Ticket" />
		<condition field="ticket" value="ticket" />
        <condition field="tipoRegistro.interno" value="false" />
	</subset>

ticket Ticket d fixed
	tipoRegistro TipoRegistro d fixed
	autor "Autor" User d fixed	
    fecha datetime ds default="now" fixed
	criticidad Criticidad fixed
	estado Estado fixed
	categoria Categoria fixed
	subCategoria SubCategoria fixed
	encargado User fixed
	grupo Grupo fixed
	mensaje ds text
	leyenda d transient fixed
	adjuntos file set ds
	editado boolean default="false" ds fixed
	borrado boolean default="false" ds fixed
	cc User set d subset="activos"
	esEditable boolean default="false" ds fixed transient

Enlace @Logs order="id desc" mainaction="abrirTicketEnlace"
    <subset name="paraTicket" order="id desc">
        <param name="ticket" entity="Ticket" />
        <condition field="ticket" value="ticket" />
    </subset>

ticket Ticket d fixed
    ticketEnlazado Ticket d fixed
	
EnviarMensaje @ transient="transient"
	<defaultset name="nuevoParaTicket">
		<param name="ticket" entity="Ticket" />
		<default name="ticket" value="ticket" />
		<default name="autor" value="User:find(userId)" />
        <default name="notificarAdmins" value="false" />
	</defaultset>
		
	ticket Ticket fixed
	autor "Autor" User d fixed
	cc User set subset="activos"
	notificarAdmins boolean default="false" ds
	mensaje text html widget="html" required="required"
	adjuntos file set
	
	<next type="function" function="nextEnviarMensaje" />

EditarMensaje @ transient="transient"
	<defaultset name="nuevoParaRegistro">
		<param name="registro" entity="Registro" />
		<default name="registro" value="registro" />
	</defaultset>
	registro Registro ds fixed
	nuevoMensaje text ds style="width:500px;height:140px;" widget="html"
	adjuntos file set

EliminarMensaje @ transient="transient"
	<defaultset name="nuevoParaRegistro">
		<param name="registro" entity="Registro" />
		<default name="registro" value="registro" />
	</defaultset>
	registro Registro ds fixed

EnviarMensajeInterno @ transient="transient"
	<defaultset name="nuevoParaTicket">
		<param name="ticket" entity="Ticket" />
		<default name="ticket" value="ticket" />
		<default name="autor" value="User:find(userId)" />
	</defaultset>

ticket Ticket fixed
	autor "Autor" User d fixed
	cc User set subset="activos"
	mensaje text html widget="html" required="required"
	adjuntos file set

EnlazarTicket @ transient="transient"
    <defaultset name="nuevoParaTicket">
        <param name="ticket" entity="Ticket" />
        <param name="ticketEnlazado" entity="Ticket" />
        <default name="ticket" value="ticket" />
        <default name="ticketEnlazado" value="ticketEnlazado" />
    </defaultset>

ticket Ticket fixed
    ticketEnlazado Ticket fixed

ReasignarTicket @ transient="transient"
	<defaultset name="nuevoParaTicket">
		<param name="ticket" entity="Ticket" />
		<default name="ticket" value="ticket" />
	</defaultset>
    asignarA User ds subset="delGrupo" subsetparams="ticket"
	ticket Ticket ds fixed
	mensaje text d style="width:500px;height:140px;" widget="html"

CerrarTicket @ transient="transient"
	<defaultset name="nuevoParaTicket">
		<param name="ticket" entity="Ticket" />
		<default name="ticket" value="ticket" />
	</defaultset>
	ticket Ticket ds fixed
    mensaje text ds r style="width:500px;height:140px;" widget="html"

ReabrirTicket @ transient="transient"
	<defaultset name="nuevoParaTicket">
		<param name="ticket" entity="Ticket" />
		<default name="ticket" value="ticket" />
	</defaultset>
	ticket Ticket ds fixed
    mensaje text ds style="width:500px;height:140px;" widget="html"

PasarAEnProceso @ transient="transient"
	<defaultset name="nuevoParaTicket">
		<param name="ticket" entity="Ticket" />
		<default name="ticket" value="ticket" />
	</defaultset>
	ticket Ticket ds fixed
	mensaje text ds style="width:500px;height:140px;" widget="html"

Plantilla @Configuración
    <filter name="trigger" label="Trigger" property="triggers" display="primary" />
    <filter name="nombre" label="Nombre" display="primary" >
        <condition field="nombre" like="concat('%', concat(nombre, '%')) "/>
    </filter>
	<box class="cols">
        <box>
            nombre d text r style="width: 500px;" "Nombre de la Plantilla"
            asunto d text style="width: 500px;" "Asunto" required="required"
            texto d text style="width: 500px; height: 400px;" widget="html" "Contenido del Email" required="required"

<box class="cols">
                <box>
                    grupo set Grupo ds "Grupo (opcional)"
                    categoria set Categoria ds "Categoría (opcional)"
                    subcategoria set SubCategoria ds "Subcategoría (opcional)" subset="paraCategoria" subsetparams="categoria"
                </box>
                <box>
                    gruposExcluidos set Grupo ds "Grupos a excluir"
                    excluirRemitente boolean ds default="false" "Excluir remitente"
                    activa boolean ds default="true" "Plantilla Activa"
                    estado set Estado ds "Estado (opcional)"
                    criticidad set Criticidad ds "Criticidad (opcional)"
                </box>
            </box>

<box class="cols" style="margin-top: 15px;margin-bottom: 15px;">
                <box>
                    <property name="triggers" type="enum" widget="checkbox" collection="set">
                            <enum value="CREACION">Creación de Ticket</enum>
                    		<enum value="ESTADO">Cambio de Estado</enum>
                            <enum value="CRITICIDAD">Cambio de Criticidad</enum>
                    		<enum value="MENSAJE">Nuevo Mensaje</enum>
                    		<enum value="MENSAJE_INTERNO">Nuevo Mensaje Interno</enum>
                            <enum value="ASIGNACION">Asignación/Reasignación</enum>
                    		<enum value="CIERRE">Cierre de Ticket</enum>
                    </property>
                </box>
                <box>
                    <property name="destinatarios" type="enum" widget="checkbox" collection="set">
                            <enum value="GRUPO">Encargados y Admins del Grupo</enum>
                            <enum value="ADMINSGRUPO">Admins del Grupo</enum>
                            <enum value="SOLICITANTE">Solicitante</enum>
                            <enum value="ENCARGADOS">Encargado</enum>
                            <enum value="INTERNOS">Usuarios Privados</enum>
                            <enum value="CC">CC (en mensajes)</enum>
                            <enum value="ADMIN">Master Admin</enum>
                    </property>
                </box>
            </box>
            emailsAdicionales d text style="width: 500px;" "Emails Adicionales (separados por coma)"
        </box>
    </box>

VariableDePlantilla @Configuración
    <filter name="codigo" label="Codigo" display="primary" >
        <condition field="codigo" like="concat('%', concat(codigo, '%')) "/>
    </filter>
    codigo d
    texto d text
    ejemplo d text

Email @Notificaciones stereotype="Email"
	recipients set ds
	emailFrom ds
	subject ds
	txtBody text
	htmlBody text
	emailDate datetime ds
	sent boolean default="false"
	
Notificacion @Notificaciones mainaction="abrirTicket"

<subset name="paraUsuarioActual" order="id desc">
        <condition field="userNotificado" value="User:find(userId)" />
        <condition field="fechaLectura" isnull="isnull" />
    </subset>
    
    <subset name="sinEmail">
    	<condition field="email" isnull="isnull" />
    </subset>
    
    registro Registro d disabled
    userNotificado User ds disabled
    fechaLectura datetime ds disabled
    <property name="email" entity="Email" invisible="invisible" />
    <action name="abrirTicket" label="Abrir Ticket" type="javascript" location="main" function="abrirTicket" />

TipoRegistro @Logs
    nombre d
    leyenda text ds
    interno boolean default="false"
```