matthewpoer

-- select an account and its children
select parent.id,parent.name,child.parent_id,child.id,child.name from accounts parent
  left join accounts child on child.parent_id=parent.id
where parent.deleted=0 and (child.deleted=0 or child.deleted is null)
order by parent.name;

matthewpoer

// need to know which user we are because the User Preference drive the type of link
global $current_user;

$field = 'email1' // alternative is email2

// form the link, i.e. mailto: or javascript for the popup. $focus could be Lead, Contact, Target, etc...
// @see User::getEmailLink
$email_link = $current_user->getEmailLink($field,$focus,null,
$_REQUEST['module'],$_REQUEST['action'],$_REQUEST['record']);

matthewpoer

# aptitude install abcde lame
# from inspired by http://pinehead.tv/linux/solution-converting-flac-to-mp3/
alias mp3theseflacs='mkdir mp3;for file in *.flac; do flac -cd "$file" | lame -h - mp3/"${file%.flac}.mp3"; done'
alias flacthiscd='abcde -o "flac" -q "high"'

matthewpoer

update contacts
join (
  select accounts.id as accounts_id,accounts.assigned_user_id as accounts_assigned_user_id,
  accounts.team_id as accounts_team_id,accounts.team_set_id as accounts_team_set_id,
  contacts.id as contact_id,contacts.assigned_user_id as contacts_assigned_user_id,
  contacts.team_id as contacts_team_id,contacts.team_set_id as contacts_team_set_id
  from accounts
  join accounts_contacts on accounts.id = accounts_contacts.account_id
  join contacts on contacts.id = accounts_contacts.contact_id
  where accounts.deleted=0 and contacts.deleted=0 and accounts_contacts.deleted=0

matthewpoer

-- remove existing account/contact relationships for all records that we might update
update accounts_contacts ac
join (
  select contacts.id as contact_id,accounts.id as account_id from contacts
  join accounts on contacts.primary_address_street = accounts.shipping_address_street and
    contacts.primary_address_city = accounts.shipping_address_city and
    contacts.primary_address_state = accounts.shipping_address_state and
    contacts.primary_address_postalcode = accounts.shipping_address_postalcode
  where contacts.deleted=0 and accounts.deleted=0)
as tmp on tmp.account_id = ac.account_id and tmp.contact_id = ac.contact_id

matthewpoer

<?php
/*
 * You Need to set the $cookie param. Do so by logging into the partner portal 
 * at https://partners.sugarcrm.com, then log in. Then visit a the API page at
 * https://partners.sugarcrm.com/account/list/5/5 with your Dev Console open. 
 * If you review your Resources, you can find the cookie that the portal gave
 * your browser. Just copy-paste the entire set of cookies from the Request.
 */

$cookie = "";

matthewpoer

<?php
# /include/utils.php
# line 2980 opens function check_php_version
# just make it return 1

function check_php_version($sys_php_version = '')
{
    return '1';
    ...
}

matthewpoer

<cfset data ={  
	'application' : 'myCFMapp',
	'user_auth' : {
	  'user_name' : 'admin',
	  'password' : '#hash("admin")#'
	  },
	  'name_value_list' : 
		{
			'name' : 'notifyonsave'
		}  

matthewpoer

SugarCRM REST API (v4_1)

This document is intended to provide a language-neutral guide of using the SugarCRM Rest API v4_1 by displaying the HTTP POSTs used to send and request data. I believe that these POSTs are the best way to understand how these API calls work, since some information is carried in the POST and some as JSON-encoded arrays.

Please also note that SugarCRM offers a newer version of it's REST API, dubbed

matthewpoer

class myClass{

    public function myMethod($bean,$event,$arguments){

        // if we are using a legacy API or web-to-lead form, email address is in email1
        $GLOBALS['log']->fatal("email1 value: {$bean->email1}");

        // but if we're on that sugar7 API or sugar7 interface (which uses said API...)
        $sea = new SugarEmailAddress();
        $email = $sea->getPrimaryAddress($bean);