Jeff Douglas – Technology, Coding and Bears… OH MY!

public static Map<String, Schema.DescribeFieldResult> getFieldMetaData(
  Schema.DescribeSObjectResult dsor, Set<String> fields) {
 
  // the map to be returned with the final data
  Map<String,Schema.DescribeFieldResult> finalMap = 
    new Map<String, Schema.DescribeFieldResult>();
  // map of all fields in the object
  Map<String, Schema.SObjectField> objectFields = dsor.fields.getMap();
 
  // iterate over the requested fields and get the describe info for each one. 
  // add it to a map with field name as key
  for(String field : fields){
    // skip fields that are not part of the object
    if (objectFields.containsKey(field)) {
      Schema.DescribeFieldResult dr = objectFields.get(field).getDescribe();
      // add the results to the map to be returned
      finalMap.put(field, dr); 
    }
  }
  return finalMap;
}

// field to return -- skips fields not actually part of the sobject
Set<String> fields = new Set<String>{'name','annualrevenue','BADFIELD'};
 
Map<String, Schema.DescribeFieldResult> finalMap = 
  Utils.getFieldMetaData(Account.getSObjectType().getDescribe(), fields);
 
// only print out the 'good' fields
for (String field : new Set<String>{'name','annualrevenue'}) {
  System.debug(finalMap.get(field).getName()); // field name
  System.debug(finalMap.get(field).getType()); // field type
  System.debug(finalMap.get(field).getLength()); // field length
}

package controllers;
 
import play.*;
import play.mvc.*;
import java.util.*;
 
import models.*;
import service.*;
import com.sforce.soap.partner.*;
import com.sforce.ws.ConnectionException;
import com.sforce.soap.partner.sobject.SObject;
 
public class Account extends Controller {
 
  public static void create() {
    render();
  }
 
  // create the record in salesforce
  public static void createSubmit() {
 
    SaveResult[] results = null;
 
    // populate the new opportunity
    SObject a = new SObject();
    a.setType("Account");
    a.setField("Name", params.get("name"));
    a.setField("BillingCity", params.get("city"));
    a.setField("BillingState", params.get("state"));
    a.setField("Phone", params.get("phone"));
    a.setField("Website", params.get("website"));
 
    SObject[] accounts = {a};
 
    // get a reference to the connection
    PartnerConnection connection = ConnectionManager.getConnectionManager().getConnection();
 
    try {
      results = connection.create(accounts);
 
      // check for any errors
      if ( results[0].isSuccess() ) {
         System.out.println("Successfully created Account: " + results[0].getId());
      } else {
         System.out.println("Error: could not create Accout: " + results[0].getErrors()[0].getMessage());
      }
 
    } catch (ConnectionException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
 
    redirect("/account/"+results[0].getId() );
  }
 
  // fetch the account and all related opportunities to display
  public static void display() {
 
    if (params.get("id") != null) {
 
      // add the account id to the array to be retrieved
      String[] accountIds = { params.get("id") };
 
      SObject[] accounts = null;
      QueryResult result = null;
 
      // get a reference to the connection
      PartnerConnection connection = ConnectionManager.getConnectionManager().getConnection();
 
      try {
        accounts = connection.retrieve("Id, Name, Phone, BillingCity, BillingState, Website","Account", accountIds);
        result = connection.query("Select id, name, stagename, amount, closeDate, probability, ordernumber__c from Opportunity where AccountId = '"+params.get("id")+"'");
      } catch (ConnectionException e) {
        e.printStackTrace();
      } catch (NullPointerException npe) {
        System.out.println("NullPointerException: "+npe.getCause().toString());
      }
 
      renderArgs.put("account", accounts[0]);
      renderArgs.put("opportunities", result.getRecords());
 
    }
 
    render();
  }
 
  // fetch the account so we can show the edit form with data
  public static void edit() {
 
    if (params.get("id") != null) {
 
      // add the account id to the array to be retrieved
      String[] accountIds = { params.get("id") };
      SObject[] accounts = null;
 
      // get a reference to the connection
      PartnerConnection connection = ConnectionManager.getConnectionManager().getConnection();
 
      try {
        accounts = connection.retrieve("Id, Name, Phone, BillingCity, BillingState, Website","Account", accountIds);
      } catch (ConnectionException e) {
        e.printStackTrace();
      } catch (NullPointerException npe) {
        System.out.println("NullPointerException: "+npe.getCause().toString());
      }
 
      renderArgs.put("account", accounts[0]);
 
    }
 
    render();
  }
 
  // update the record in salesforce
  public static void editSubmit() {
 
    SaveResult[] results = null;
 
    // populate the account to update
    SObject a = new SObject();
    a.setType("Account");
    a.setId(params.get("id"));
    a.setField("Billingcity", params.get("BillingCity"));
 
    SObject[] accounts = {a};
 
    // get a reference to the connection
    PartnerConnection connection = ConnectionManager.getConnectionManager().getConnection();
 
    try {
      results = connection.update(accounts);
 
      // check for any errors
      if ( results[0].isSuccess() ) {
         System.out.println("Successfully updated Account: " + results[0].getId());
      } else {
         System.out.println("Error: could not update Account: " + results[0].getErrors()[0].getMessage());
      }
 
    } catch (ConnectionException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
 
    redirect("/account/"+params.get("id") );
  }
 
}

#{extends 'main.html' /}
#{set title:'Account Details' /}
 
<span class="nav"><a href="/opportunity">Search</a></span><p/>
<span class="title">Account Display</span>
<p/>
 
<table id="fancytable">
  <tr>
    <td class="label">Name</td>
    <td>${ account.getField("Name") }</td>
  </tr>
  <tr>
    <td class="label">City</td>
    <td>${ account.getField("BillingCity") }</td>
  </tr>
  <tr>
    <td class="label">State</td>
    <td>${ account.getField("BillingState") }</td>
  </tr>
  <tr>
    <td class="label">Phone</td>
    <td>${ account.getField("Phone") }</td>
  </tr>
  <tr>
    <td class="label">Website</td>
    <td>${ account.getField("Website") }</td>
  </tr>  
</table>
 
<br><a href="/opportunity/create/${ account.getField("Id") }">Create a new Opportunity</a> 
or <a href="/account/${ account.getField("Id") }/edit">edit this Account</a><p/>  
 
%{ if (opportunities.length > 0) { }%
 
  <p/><span class="heading">Opportunities for ${ account.getField("Name") }</span><br><p/>
 
  <table id="fancytable">
  <tr>
    <td class="label">Name</td>
    <td class="label">Amount</td>
    <td class="label">Stage</td>
    <td class="label">Probability</td>
    <td class="label">Close Date</td>
    <td class="label">Order</td>
  </tr>
  #{list items:opportunities, as:'o' }
    <tr>
      <td nowrap>${ o.getField("Name") }</td>
      <td>$${ o.getField("Amount") }</td>
      <td>${ o.getField("StageName") }</td>
      <td>${ o.getField("Probability") }</td>
      <td>${ o.getField("CloseDate") }</td>
      <td>${ o.getField("OrderNumber__c") }</td>
    </tr>
  #{/list}
  </table>
 
%{ } else { }%
  <p/><span class="heading">No Opportunities found for ${ account.getField("Name") }</span>
%{ } }%

package com.jeffdouglas.emailer;
 
[removed imports]
 
/**
 * MailServlet.java - a simple, schedulable servlet for sending mail
 * with salesforce.com
 * @author Jeff Douglas
 * @version 1.0
 * @see http://code.google.com/appengine/docs/java/mail/overview.html
 * for more details on using Mail with App Engine
 */
 
@SuppressWarnings("serial")
public class MailServlet extends HttpServlet {
 
    private static final Logger logger = Logger.getLogger(ConnectionManager.class.getName());
    private String jabberRecipient = "jeffdonthemic@gmail.com";
 
    public void doGet(HttpServletRequest req, HttpServletResponse resp)
            throws IOException {
 
        resp.setContentType("text/html");
        String mailerMsg = "No contact found to email!!";
        QueryResult result = null;
 
        // get a reference to the salesforce connection
        PartnerConnection connection = ConnectionManager.getConnectionManager().getConnection();
 
        try {
            // query for contacts based upon some criteria -- emailNotSent boolean
            result = connection.query("Select Id, FirstName, LastName, Email " +
            		"FROM Contact Where Email = 'jeff@jeffdouglas.com' Limit 1");
        } catch (ConnectionException e) {
            e.printStackTrace();
            logger.severe(e.getCause().toString());
        } catch (NullPointerException npe) {
            npe.printStackTrace();
            logger.severe(npe.getCause().toString());
        }
 
        // if records were returned then send out email
        if (result != null) {
 
          for (SObject contact : result.getRecords()) {
 
            // construct the 'name' for the email recipient
            String contactName = contact.getField("FirstName").toString() + " " + 
              contact.getField("LastName").toString();
 
            logger.info("Sending emil to " + contactName + " at " + 
              contact.getField("Email").toString());
 
            /// send the email
            mailerMsg = sendMail(contact.getField("Email").toString(), contactName);
 
            // send a jabber notification of the status
            sendJabberNotification(jabberRecipient, mailerMsg);
 
          }
 
          // TODO - make a call back into salesforce and update these records
          // as having their emails sent. Implementation is up to you.
 
        } else {
          logger.warning("No results returned from salesforce");
        }
 
        resp.getOutputStream().println(mailerMsg);
 
    }  
 
    /**  
     * Sends an email
     * @param toAddress the email address of the recipient
     * @param toName the name that appears for the recipeint in their email client  
     * @return A String representing the status of the email sent  
     */  
    private String sendMail(String toAddress, String toName) {
 
      String msg = "Email sent successfully to " + toAddress;
      Properties props = new Properties();
      Session session = Session.getDefaultInstance(props, null); 
 
      String messageBody = "This is the body of my email";
 
      try {
 
          Message emailMessage = new MimeMessage(session);
          //  must be the email address of an administrator for the application. see docs
          emailMessage.setFrom(new InternetAddress("jeffdonthemic@gmail.com","Jeff Douglas"));
          emailMessage.addRecipient(Message.RecipientType.TO, 
            new InternetAddress(toAddress, toName));
          emailMessage.setSubject("My Email Subject");
          emailMessage.setText(messageBody);
          Transport.send(emailMessage);
 
      } catch (AddressException e) {
          msg = e.toString();
      } catch (MessagingException e) {
          msg = e.toString();
      } catch (UnsupportedEncodingException e) {
          msg = e.toString();
      }
 
      return msg;
    }
 
    /**  
     * Sends a message to any XMPP-compatible chat messaging service (google talk). 
     * See http://code.google.com/appengine/docs/java/xmpp/overview.html
     * for more detils
     * @param recipient the jid of the jabber recipient of the notification
     * @param msgBody the body of the message to be sent  
     */  
    private void sendJabberNotification(String recipient, String msgBody) {
 
      JID jid = new JID(recipient);
 
      com.google.appengine.api.xmpp.Message msg = new MessageBuilder()
          .withRecipientJids(jid)
          .withBody(msgBody)
          .build();
 
      boolean messageSent = false;
      XMPPService xmpp = XMPPServiceFactory.getXMPPService();
 
      if (xmpp.getPresence(jid).isAvailable()) {
          SendResponse status = xmpp.sendMessage(msg);
          messageSent = (status.getStatusMap().get(jid) == SendResponse.Status.SUCCESS);
      }
 
      logger.info("Jabber notifiation sent: " + messageSent);
 
    }
 
}