Projects Archives | X-Squared On Demand

Well, it took about ten minutes from the release of Email Inbox Version 1 for people to request additional features, screenshots, etc. Version 2 includes some neat icons, and this post has the multiple-times-requested screenshots we promised. First, a teaser screenshot. (There's a better one below the code.) Here's the updated Visualforce code:

&lt;apex:page controller=&quot;EmailMessageController&quot; action=&quot;{!ViewData}&quot;&gt;
    &lt;apex:sectionHeader title=&quot;Email Messages&quot; subtitle=&quot;&quot;&gt;&lt;/apex:sectionHeader&gt;
    &lt;apex:pageblock id=&quot;emailblock&quot;&gt;
        &lt;apex:facet name=&quot;header&quot;&gt;
            &lt;apex:form &gt;
                &lt;apex:panelGrid styleClass=&quot;list&quot;
                    columnClasses=&quot;pbTitle,pbButton,pbHelp&quot; columns=&quot;3&quot; border=&quot;0&quot;
                    cellpadding=&quot;0&quot; cellspacing=&quot;0&quot;&gt;
                    &lt;apex:outputLabel &gt;&lt;h3&gt;Messages&lt;/h3&gt;&lt;/apex:outputLabel&gt;
                    &lt;apex:commandButton value=&quot; Refresh &quot; styleClass=&quot;btn&quot;
                        action=&quot;{!ViewData}&quot; rerender=&quot;emailblock&quot;&gt;&lt;/apex:commandButton&gt;
                    &lt;apex:SelectList value=&quot;{!wheretext}&quot; size=&quot;1&quot;  id=&quot;controllerselectlist&quot;&gt;
                        &lt;apex:actionSupport event=&quot;onchange&quot; action=&quot;{!ViewData}&quot;
                            reRender=&quot;emailblock&quot;&gt;&lt;/apex:actionSupport&gt;
                        &lt;apex:selectOptions value=&quot;{!views}&quot; /&gt;
                    &lt;/apex:SelectList&gt;
                &lt;/apex:panelGrid&gt;
            &lt;/apex:form&gt;
        &lt;/apex:facet&gt;
        &lt;apex:form &gt;
            &lt;apex:pageblocktable value=&quot;{!Messages}&quot; var=&quot;e&quot; id=&quot;emailtable&quot;
                bgcolor=&quot;#F3F3EC&quot; styleClass=&quot;list&quot; rowClasses=&quot;dataRow&quot;
                onRowMouseOver=&quot;hiOn(this);&quot; onRowMouseOut=&quot;hiOff(this);&quot;&gt;
                &lt;apex:column &gt;
                    &lt;apex:facet name=&quot;header&quot;&gt;
                        &lt;apex:commandLink action=&quot;{!ViewData}&quot;
                            value=&quot;{!$ObjectType.EmailMessage.fields.Subject.label}{!IF(sortExpression=='Subject', 
                            IF(sortDirection='ASC','▼','▲'),'')}&quot;&gt;
                            &lt;apex:param value=&quot;Subject&quot; name=&quot;column&quot;
                                assignTo=&quot;{!sortExpression}&quot;&gt;&lt;/apex:param&gt;
                        &lt;/apex:commandLink&gt;
                    &lt;/apex:facet&gt;
                    &lt;apex:outputLink value=&quot;/{!e.Id}&quot; target=&quot;_blank&quot;&gt;{!e.Subject}&lt;/apex:outputLink&gt;
                &lt;/apex:column&gt;
                &lt;apex:column &gt;
                    &lt;apex:facet name=&quot;header&quot;&gt;
                    {!$ObjectType.Contact.fields.Name.label}
                    &lt;/apex:facet&gt;
                    &lt;apex:outputLink value=&quot;/{!e.Parent.ContactId}&quot; target=&quot;_blank&quot;
                        rendered=&quot;{!IF(e.Parent.ContactId != '',true,false)}&quot;&gt;{!e.FromName}&lt;/apex:outputLink&gt;
                    &lt;apex:outputtext value=&quot;{!e.FromName}&quot;
                        rendered=&quot;{!IF(e.Parent.ContactId != '',false,true)}&quot; /&gt;
                &lt;/apex:column&gt;
                &lt;apex:column &gt;
                    &lt;apex:facet name=&quot;header&quot;&gt;
                    {!$ObjectType.Account.fields.Name.label}
                    &lt;/apex:facet&gt;
                    &lt;apex:outputLink value=&quot;/{!e.Parent.AccountId}&quot; target=&quot;_blank&quot;&gt;{!e.Parent.Account.Name}&lt;/apex:outputLink&gt;
                &lt;/apex:column&gt;
                &lt;apex:column value=&quot;{!e.FromAddress}&quot;&gt;
                    &lt;apex:facet name=&quot;header&quot;&gt;
                        &lt;apex:commandLink action=&quot;{!ViewData}&quot;
                            value=&quot;{!$ObjectType.EmailMessage.fields.FromAddress.label}{!IF(sortExpression=='FromAddress', 
                            IF(sortDirection='ASC','▼','▲'),'')}&quot;&gt;
                            &lt;apex:param value=&quot;FromAddress&quot; name=&quot;column&quot;
                                assignTo=&quot;{!sortExpression}&quot;&gt;&lt;/apex:param&gt;
                        &lt;/apex:commandLink&gt;
                    &lt;/apex:facet&gt;
                &lt;/apex:column&gt;
                &lt;apex:column value=&quot;{!e.Status}&quot;&gt;
                    &lt;apex:facet name=&quot;header&quot;&gt;
                        &lt;apex:commandLink action=&quot;{!ViewData}&quot;
                            value=&quot;{!$ObjectType.EmailMessage.fields.Status.label}{!IF(sortExpression=='Status', 
                            IF(sortDirection='ASC','▼','▲'),'')}&quot;&gt;
                            &lt;apex:param value=&quot;Status&quot; name=&quot;column&quot;
                                assignTo=&quot;{!sortExpression}&quot;&gt;&lt;/apex:param&gt;
                        &lt;/apex:commandLink&gt;
                    &lt;/apex:facet&gt;
                &lt;/apex:column&gt;
                &lt;apex:column value=&quot;{!e.MessageDate}&quot;&gt;
                    &lt;apex:facet name=&quot;header&quot;&gt;
                        &lt;apex:commandLink action=&quot;{!ViewData}&quot;
                            value=&quot;{!$ObjectType.EmailMessage.fields.MessageDate.label}{!IF(sortExpression=='MessageDate', 
                            IF(sortDirection='ASC','▼','▲'),'')}&quot;&gt;
                            &lt;apex:param value=&quot;MessageDate&quot; name=&quot;column&quot;
                                assignTo=&quot;{!sortExpression}&quot;&gt;&lt;/apex:param&gt;
                        &lt;/apex:commandLink&gt;
                    &lt;/apex:facet&gt;
                &lt;/apex:column&gt;
                &lt;apex:column &gt;
                    &lt;apex:facet name=&quot;header&quot;&gt;
                        &lt;apex:commandLink action=&quot;{!ViewData}&quot;
                            value=&quot;Inbound/Outbound{!IF(sortExpression=='Incoming', 
                            IF(sortDirection='ASC','▼','▲'),'')}&quot;&gt;
                            &lt;apex:param value=&quot;Incoming&quot; name=&quot;column&quot;
                                assignTo=&quot;{!sortExpression}&quot;&gt;&lt;/apex:param&gt;
                        &lt;/apex:commandLink&gt;
                    &lt;/apex:facet&gt;
                    &lt;apex:image url=&quot;/img/emailInbound.gif&quot; rendered=&quot;{!e.Incoming}&quot; /&gt;
                    &lt;apex:image url=&quot;/img/emailOutbound.gif&quot; rendered=&quot;{!NOT(e.Incoming)}&quot; /&gt;
                    &lt;!--&lt;apex:outputfield value=&quot;{!e.Incoming}&quot; rendered=&quot;{!NOT(e.Incoming)}&quot; /&gt;--&gt;
                &lt;/apex:column&gt;
                &lt;apex:column &gt;
                    &lt;apex:facet name=&quot;header&quot;&gt;
                        &lt;apex:commandLink action=&quot;{!ViewData}&quot;
                            value=&quot;Attachment{!IF(sortExpression=='HasAttachment', 
                            IF(sortDirection='ASC','▼','▲'),'')}&quot;&gt;
                            &lt;apex:param value=&quot;HasAttachment&quot; name=&quot;column&quot;
                                assignTo=&quot;{!sortExpression}&quot;&gt;&lt;/apex:param&gt;
                        &lt;/apex:commandLink&gt;
                    &lt;/apex:facet&gt;
                    &lt;apex:image url=&quot;/img/emailHasAttach.gif&quot; rendered=&quot;{!e.HasAttachment}&quot;/&gt;
                    &lt;apex:outputfield value=&quot;{!e.HasAttachment}&quot; rendered=&quot;{!NOT(e.HasAttachment)}&quot; /&gt;
                &lt;/apex:column&gt;
                &lt;apex:column &gt;
                    &lt;apex:facet name=&quot;header&quot;&gt;
                        &lt;apex:commandLink action=&quot;{!ViewData}&quot;
                            value=&quot;{!$ObjectType.Case.fields.CaseNumber.label}{!IF(sortExpression=='ParentId', 
                            IF(sortDirection='ASC','▼','▲'),'')}&quot;&gt;
                            &lt;apex:param value=&quot;ParentId&quot; name=&quot;column&quot;
                                assignTo=&quot;{!sortExpression}&quot;&gt;&lt;/apex:param&gt;
                        &lt;/apex:commandLink&gt;
                    &lt;/apex:facet&gt;
                    &lt;apex:outputLink value=&quot;/{!e.ParentId}&quot;&gt;{!e.Parent.CaseNumber}&lt;/apex:outputLink&gt;

                &lt;/apex:column&gt;
                &lt;apex:column value=&quot;{!e.ToAddress}&quot;&gt;
                    &lt;apex:facet name=&quot;header&quot;&gt;
                        &lt;apex:commandLink action=&quot;{!ViewData}&quot;
                            value=&quot;{!$ObjectType.EmailMessage.fields.ToAddress.label}{!IF(sortExpression=='ToAddress', 
                            IF(sortDirection='ASC','▼','▲'),'')}&quot;&gt;
                            &lt;apex:param value=&quot;ToAddress&quot; name=&quot;column&quot;
                                assignTo=&quot;{!sortExpression}&quot;&gt;&lt;/apex:param&gt;
                        &lt;/apex:commandLink&gt;
                    &lt;/apex:facet&gt;
                &lt;/apex:column&gt;
            &lt;/apex:pageblocktable&gt;
        &lt;/apex:form&gt;
    &lt;/apex:pageblock&gt;
&lt;/apex:page&gt;

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

<apex:page controller="EmailMessageController" action="{!ViewData}">

<apex:sectionHeader title="Email Messages" subtitle=""></apex:sectionHeader>

<apex:pageblock id="emailblock">

<apex:facet name="header">

<apex:form >

<apex:panelGrid styleClass="list"

columnClasses="pbTitle,pbButton,pbHelp" columns="3" border="0"

cellpadding="0" cellspacing="0">

<apex:outputLabel ><h3>Messages</h3></apex:outputLabel>

<apex:commandButton value=" Refresh " styleClass="btn"

action="{!ViewData}" rerender="emailblock"></apex:commandButton>

<apex:SelectList value="{!wheretext}" size="1" id="controllerselectlist">

<apex:actionSupport event="onchange" action="{!ViewData}"

reRender="emailblock"></apex:actionSupport>

<apex:selectOptions value="{!views}" />

</apex:SelectList>

</apex:panelGrid>

</apex:form>

</apex:facet>

<apex:form >

<apex:pageblocktable value="{!Messages}" var="e" id="emailtable"

bgcolor="#F3F3EC" styleClass="list" rowClasses="dataRow"

onRowMouseOver="hiOn(this);" onRowMouseOut="hiOff(this);">

<apex:column >

<apex:facet name="header">

<apex:commandLink action="{!ViewData}"

value="{!$ObjectType.EmailMessage.fields.Subject.label}{!IF(sortExpression=='Subject',

IF(sortDirection='ASC','▼','▲'),'')}">

<apex:param value="Subject" name="column"

assignTo="{!sortExpression}"></apex:param>

</apex:commandLink>

</apex:facet>

<apex:outputLink value="/{!e.Id}" target="_blank">{!e.Subject}</apex:outputLink>

</apex:column>

<apex:column >

<apex:facet name="header">

{!$ObjectType.Contact.fields.Name.label}

</apex:facet>

<apex:outputLink value="/{!e.Parent.ContactId}" target="_blank"

rendered="{!IF(e.Parent.ContactId != '',true,false)}">{!e.FromName}</apex:outputLink>

<apex:outputtext value="{!e.FromName}"

rendered="{!IF(e.Parent.ContactId != '',false,true)}" />

</apex:column>

<apex:column >

<apex:facet name="header">

{!$ObjectType.Account.fields.Name.label}

</apex:facet>

<apex:outputLink value="/{!e.Parent.AccountId}" target="_blank">{!e.Parent.Account.Name}</apex:outputLink>

</apex:column>

<apex:column value="{!e.FromAddress}">

<apex:facet name="header">

<apex:commandLink action="{!ViewData}"

value="{!$ObjectType.EmailMessage.fields.FromAddress.label}{!IF(sortExpression=='FromAddress',

IF(sortDirection='ASC','▼','▲'),'')}">

<apex:param value="FromAddress" name="column"

assignTo="{!sortExpression}"></apex:param>

</apex:commandLink>

</apex:facet>

</apex:column>

<apex:column value="{!e.Status}">

<apex:facet name="header">

<apex:commandLink action="{!ViewData}"

value="{!$ObjectType.EmailMessage.fields.Status.label}{!IF(sortExpression=='Status',

IF(sortDirection='ASC','▼','▲'),'')}">

<apex:param value="Status" name="column"

assignTo="{!sortExpression}"></apex:param>

</apex:commandLink>

</apex:facet>

</apex:column>

<apex:column value="{!e.MessageDate}">

<apex:facet name="header">

<apex:commandLink action="{!ViewData}"

value="{!$ObjectType.EmailMessage.fields.MessageDate.label}{!IF(sortExpression=='MessageDate',

IF(sortDirection='ASC','▼','▲'),'')}">

<apex:param value="MessageDate" name="column"

assignTo="{!sortExpression}"></apex:param>

</apex:commandLink>

</apex:facet>

</apex:column>

<apex:column >

<apex:facet name="header">

<apex:commandLink action="{!ViewData}"

value="Inbound/Outbound{!IF(sortExpression=='Incoming',

IF(sortDirection='ASC','▼','▲'),'')}">

<apex:param value="Incoming" name="column"

assignTo="{!sortExpression}"></apex:param>

</apex:commandLink>

</apex:facet>

<apex:image url="/img/emailInbound.gif" rendered="{!e.Incoming}" />

<apex:image url="/img/emailOutbound.gif" rendered="{!NOT(e.Incoming)}" />

</apex:column>

<apex:column >

<apex:facet name="header">

<apex:commandLink action="{!ViewData}"

value="Attachment{!IF(sortExpression=='HasAttachment',

IF(sortDirection='ASC','▼','▲'),'')}">

<apex:param value="HasAttachment" name="column"

assignTo="{!sortExpression}"></apex:param>

</apex:commandLink>

</apex:facet>

<apex:image url="/img/emailHasAttach.gif" rendered="{!e.HasAttachment}"/>

<apex:outputfield value="{!e.HasAttachment}" rendered="{!NOT(e.HasAttachment)}" />

</apex:column>

<apex:column >

<apex:facet name="header">

<apex:commandLink action="{!ViewData}"

value="{!$ObjectType.Case.fields.CaseNumber.label}{!IF(sortExpression=='ParentId',

IF(sortDirection='ASC','▼','▲'),'')}">

<apex:param value="ParentId" name="column"

assignTo="{!sortExpression}"></apex:param>

</apex:commandLink>

</apex:facet>

<apex:outputLink value="/{!e.ParentId}">{!e.Parent.CaseNumber}</apex:outputLink>

</apex:column>

<apex:column value="{!e.ToAddress}">

<apex:facet name="header">

<apex:commandLink action="{!ViewData}"

value="{!$ObjectType.EmailMessage.fields.ToAddress.label}{!IF(sortExpression=='ToAddress',

IF(sortDirection='ASC','▼','▲'),'')}">

<apex:param value="ToAddress" name="column"

assignTo="{!sortExpression}"></apex:param>

</apex:commandLink>

</apex:facet>

</apex:column>

</apex:pageblocktable>

</apex:form>

</apex:pageblock>

</apex:page>

The […]

Overload Apex Class to be Controller AND Extension

Email Inbox Version 2

Visualforce Email Inbox

X-Squared featured in Inc.com article on drop.io

Zip to City & State Integration – Proof of Concept

Like Us on Facebook

Share This Page

Find Us Online

Subscribe

Subscribe via Email