dmulvi

DROP DATABASE IF EXISTS twitter_test;
CREATE DATABASE twitter_test;

USE twitter_test;

DROP TABLE IF EXISTS follwers;
CREATE TABLE followers (
	id varchar(16),
	screen_name VARCHAR(32),
	name VARCHAR(32),

dmulvi

SELECT f.id, f.screen_name, l.location
FROM followers AS f
LEFT OUTER JOIN location AS l
    ON l.id = f.id
LIMIT 100;

dmulvi

/*
 * This will pull out our results inserted on Task 1 and display them in a table.
 */
public function pull_twitter_users()
{
	try {
	    	$sql = "SELECT f.id, f.screen_name, l.location
	    		FROM followers AS f
	    		LEFT OUTER JOIN location AS l
	    			ON l.id = f.id

dmulvi

/*
 * Task 2 - fetch some db results via ajax call and display in a table.
 */
var admixt_task2 = {
	url: '/followers',

	fetch: function(){
		var self = this;

		$.get(this.url)

dmulvi

<?php
if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');

$module = "YOUR_MODULE";
$viewdefs[$module]['base']['view']['subpanel-list'] = array(
    'template' => 'recordlist',
    'favorite' => true,
    'rowactions' => array(
        'actions' => array(
            array(

dmulvi

<?php

/*  This will make a field readonly. Create this file here:
    /custom/Extension/modules/MODULE/Ext/Dependencies/
    and then Quick Repair/Rebuild */

$dependencies['MODULE']['FIELD_NAME_readonly'] = array(
    'hooks' => array('edit'),
    'trigger' => 'true',
    'triggerFields' => array('FIELD_NAME'),

dmulvi

<?php

/*  This will turn off duplicate checking for the module. 
    Put the file in this directory:
    custom/Extension/modules/MODULE/Ext/Vardefs/
    and Quick Repair/Rebuild */
    
$dictionary['MODULE']['duplicate_check']['FilterDuplicateCheck']['filter_template'] = array();

dmulvi

<?php

// place this file in custom/Extension/modules/Contacts/Ext/Language

$mod_strings['LNK_NEW_LAYOUT_LINK'] = 'New Layout Link';

dmulvi

<?php

// file location: /custom/Extension/modules/Contacts/Ext/clients/base/filters/basic/filterContactsFromRelatedAccounts.php

$viewdefs['Contacts']['base']['filter']['basic']['filters'][] = array(
    'id' => 'filterContactsFromRelatedAccount',
    'name' => 'Contacts of Related Account',
    'filter_definition' => array(
        array(
            'account_id' => ''

dmulvi

<?php

require_once('modules/Emails/Email.php');
require_once('include/SugarPHPMailer.php');
$emailObj   = new Email();
$mail       = new SugarPHPMailer();

// Create an id for the email
$emailObj->id          = create_guid();
$emailObj->new_with_id = true;