public static function createPotentialRelatedTo($relatedto, $campaignid)
{
global $adb, $current_user;
$checkrs = $adb->pquery('select 1
from vtiger_potential
inner join vtiger_crmentity on crmid=potentialid
where deleted=0 and related_to=? and campaignid=?', array($relatedto, $campaignid));
if ($adb->num_rows($checkrs) == 0) {
require_once 'modules/Potentials/Potentials.php';
$entity = new Potentials();
$entity->mode = '';
$cname = getEntityName('Campaigns', $campaignid);
$cname = $cname[$campaignid] . ' - ';
$setype = getSalesEntityType($relatedto);
$rname = getEntityName($setype, $relatedto);
$rname = $rname[$relatedto];
$cbMapid = GlobalVariable::getVariable('BusinessMapping_PotentialOnCampaignRelation', cbMap::getMapIdByName('PotentialOnCampaignRelation'));
if ($cbMapid) {
$cmp = CRMEntity::getInstance('Campaigns');
$cmp->retrieve_entity_info($campaignid, 'Campaigns');
if ($setype == 'Accounts') {
$cmp->column_fields['AccountName'] = $rname;
$cmp->column_fields['ContactName'] = '';
} else {
$cmp->column_fields['AccountName'] = '';
$cmp->column_fields['ContactName'] = $rname;
}
$cbMap = cbMap::getMapByID($cbMapid);
$entity->column_fields = $cbMap->Mapping($cmp->column_fields, array());
}
if (empty($entity->column_fields['assigned_user_id'])) {
$entity->column_fields['assigned_user_id'] = $current_user->id;
}
$entity->column_fields['related_to'] = $relatedto;
$entity->column_fields['campaignid'] = $campaignid;
if (empty($entity->column_fields['closingdate'])) {
$dt = new DateTimeField();
$entity->column_fields['closingdate'] = $dt->getDisplayDate();
}
if (empty($entity->column_fields['potentialname'])) {
$entity->column_fields['potentialname'] = $cname . $rname;
}
if (empty($entity->column_fields['sales_stage'])) {
$entity->column_fields['sales_stage'] = 'Prospecting';
}
$_REQUEST['assigntype'] = 'U';
$_REQUEST['assigned_user_id'] = $entity->column_fields['assigned_user_id'];
$entity->save('Potentials');
}
}
$opp = new Potentials();
$opp->column_fields["assigned_user_id"] = $assigned_user_id;
$opp->column_fields["potentialname"] = $account_name . " - 1000 units";
$opp->column_fields["closingdate"] =& create_date();
$key = array_rand($comboFieldArray['leadsource_dom']);
$opp->column_fields["leadsource"] = $comboFieldArray['leadsource_dom'][$key];
$comboSalesStageArray = array("Closed Won", "Needs Analysis", "Value Proposition", "Qualification", "Prospecting", "Id. Decision Makers");
$key = array_rand($comboSalesStageArray);
$opp->column_fields["sales_stage"] = $comboSalesStageArray[$key];
$key = array_rand($comboFieldArray['opportunity_type_dom']);
$opp->column_fields["opportunity_type"] = $comboFieldArray['opportunity_type_dom'][$key];
$amount = array("10000", "25000", "50000", "75000");
$key = array_rand($amount);
$opp->column_fields["amount"] = $amount[$key];
$opp->column_fields["related_to"] = $account->id;
$opp->save("Potentials");
$opportunity_ids[] = $opp->id;
}
for ($i = 0; $i < 10; $i++) {
$contact = new Contacts();
$contact->column_fields["firstname"] = ucfirst(strtolower($first_name_array[$i]));
$contact->column_fields["lastname"] = ucfirst(strtolower($last_name_array[$i]));
$contact->column_fields["assigned_user_id"] = $assigned_user_id;
$contact->column_fields["email"] = strtolower($contact->column_fields["firstname"]) . "_" . strtolower($contact->column_fields["lastname"]) . "@company.com";
$contact->column_fields["phone"] = create_phone_number();
$contact->column_fields["homephone"] = create_phone_number();
$contact->column_fields["mobile"] = create_phone_number();
// Fill in a bogus address
$key = array_rand($street_address_array);
$contact->column_fields["mailingstreet"] = $street_address_array[$key];
$key = array_rand($city_array);