484 lines
19 KiB
PHP
Executable File
484 lines
19 KiB
PHP
Executable File
<?php
|
|
if (!defined('sugarEntry') || !sugarEntry) {
|
|
die('Not A Valid Entry Point');
|
|
}
|
|
/**
|
|
*
|
|
* SugarCRM Community Edition is a customer relationship management program developed by
|
|
* SugarCRM, Inc. Copyright (C) 2004-2013 SugarCRM Inc.
|
|
*
|
|
* SuiteCRM is an extension to SugarCRM Community Edition developed by SalesAgility Ltd.
|
|
* Copyright (C) 2011 - 2018 SalesAgility Ltd.
|
|
*
|
|
* This program is free software; you can redistribute it and/or modify it under
|
|
* the terms of the GNU Affero General Public License version 3 as published by the
|
|
* Free Software Foundation with the addition of the following permission added
|
|
* to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
|
|
* IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
|
|
* OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
|
|
*
|
|
* This program is distributed in the hope that it will be useful, but WITHOUT
|
|
* ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
|
|
* FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
|
|
* details.
|
|
*
|
|
* You should have received a copy of the GNU Affero General Public License along with
|
|
* this program; if not, see http://www.gnu.org/licenses or write to the Free
|
|
* Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
|
|
* 02110-1301 USA.
|
|
*
|
|
* You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
|
|
* SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
|
|
*
|
|
* The interactive user interfaces in modified source and object code versions
|
|
* of this program must display Appropriate Legal Notices, as required under
|
|
* Section 5 of the GNU Affero General Public License version 3.
|
|
*
|
|
* In accordance with Section 7(b) of the GNU Affero General Public License version 3,
|
|
* these Appropriate Legal Notices must retain the display of the "Powered by
|
|
* SugarCRM" logo and "Supercharged by SuiteCRM" logo. If the display of the logos is not
|
|
* reasonably feasible for technical reasons, the Appropriate Legal Notices must
|
|
* display the words "Powered by SugarCRM" and "Supercharged by SuiteCRM".
|
|
*/
|
|
|
|
|
|
|
|
|
|
#[\AllowDynamicProperties]
|
|
class OpportunityFormBase
|
|
{
|
|
public function checkForDuplicates($prefix)
|
|
{
|
|
require_once('include/formbase.php');
|
|
|
|
$focus = BeanFactory::newBean('Opportunities');
|
|
$query = '';
|
|
$baseQuery = 'select id, name, sales_stage,amount, date_closed from opportunities where deleted!=1 and (';
|
|
|
|
if (isset($_POST[$prefix.'name']) && !empty($_POST[$prefix.'name'])) {
|
|
$query = $baseQuery ." name like '%".$_POST[$prefix.'name']."%'";
|
|
$query .= getLikeForEachWord('name', $_POST[$prefix.'name']);
|
|
}
|
|
|
|
if (!empty($query)) {
|
|
$rows = array();
|
|
$db = DBManagerFactory::getInstance();
|
|
$result = $db->query($query.')');
|
|
$i=-1;
|
|
while (($row=$db->fetchByAssoc($result)) != null) {
|
|
$i++;
|
|
$rows[$i] = $row;
|
|
}
|
|
if ($i==-1) {
|
|
return null;
|
|
}
|
|
|
|
return $rows;
|
|
}
|
|
return null;
|
|
}
|
|
|
|
|
|
public function buildTableForm($rows, $mod='Opportunities')
|
|
{
|
|
if (!empty($mod)) {
|
|
global $current_language;
|
|
$mod_strings = return_module_language($current_language, $mod);
|
|
} else {
|
|
global $mod_strings;
|
|
}
|
|
global $app_strings;
|
|
$cols = (is_countable($rows[0]) ? count($rows[0]) : 0) * 2 + 1;
|
|
$form = '<table width="100%"><tr><td>'.$mod_strings['MSG_DUPLICATE']. '</td></tr><tr><td height="20"></td></tr></table>';
|
|
|
|
$form .= "<form action='index.php' method='post' name='dupOpps'><input type='hidden' name='selectedOpportunity' value=''>";
|
|
$form .= "<table width='100%' cellpadding='0' cellspacing='0' class='list view'>";
|
|
$form .= "<tr class='pagination'><td colspan='$cols'><table width='100%' cellspacing='0' cellpadding='0' border='0'><tr><td><input type='submit' class='button' name='ContinueOpportunity' value='{$mod_strings['LNK_NEW_OPPORTUNITY']}'></td></tr></table></td></tr><tr>";
|
|
$form .= "<tr><td scope='col'> </td>";
|
|
require_once('include/formbase.php');
|
|
$form .= getPostToForm();
|
|
if (isset($rows[0])) {
|
|
foreach ($rows[0] as $key=>$value) {
|
|
if ($key != 'id') {
|
|
$form .= "<td scope='col'>". $mod_strings[$mod_strings['db_'.$key]]. "</td>";
|
|
}
|
|
}
|
|
$form .= "</tr>";
|
|
}
|
|
|
|
$rowColor = 'oddListRowS1';
|
|
foreach ($rows as $row) {
|
|
$form .= "<tr class='$rowColor'>";
|
|
|
|
$form .= "<td width='1%' nowrap='nowrap'><a href='#' onclick='document.dupOpps.selectedOpportunity.value=\"{$row['id']}\";document.dupOpps.submit();'>[{$app_strings['LBL_SELECT_BUTTON_LABEL']}]</a> </td>";
|
|
$wasSet = false;
|
|
foreach ($row as $key=>$value) {
|
|
if ($key != 'id') {
|
|
if (!$wasSet) {
|
|
$form .= "<td scope='row'><a target='_blank' href='index.php?module=Opportunities&action=DetailView&record={$row['id']}'>$value</a></td>";
|
|
$wasSet = true;
|
|
} else {
|
|
$form .= "<td><a target='_blank' href='index.php?module=Opportunities&action=DetailView&record={$row['id']}'>$value</a></td>";
|
|
}
|
|
}
|
|
}
|
|
|
|
if ($rowColor == 'evenListRowS1') {
|
|
$rowColor = 'oddListRowS1';
|
|
} else {
|
|
$rowColor = 'evenListRowS1';
|
|
}
|
|
$form .= "</tr>";
|
|
}
|
|
$form .= "<tr class='pagination'><td colspan='$cols'><table width='100%' cellspacing='0' cellpadding='0' border='0'><tr><td><input type='submit' class='button' name='ContinueOpportunity' value='{$mod_strings['LNK_NEW_OPPORTUNITY']}'></td></tr></table></td></tr><tr>";
|
|
$form .= "</table><BR></form>";
|
|
|
|
return $form;
|
|
}
|
|
|
|
public function getForm($prefix, $mod='Opportunities')
|
|
{
|
|
if (!ACLController::checkAccess('Opportunities', 'edit', true)) {
|
|
return '';
|
|
}
|
|
if (!empty($mod)) {
|
|
global $current_language;
|
|
$mod_strings = return_module_language($current_language, $mod);
|
|
} else {
|
|
global $mod_strings;
|
|
}
|
|
global $app_strings;
|
|
global $sugar_version, $sugar_config;
|
|
|
|
|
|
$lbl_save_button_title = $app_strings['LBL_SAVE_BUTTON_TITLE'];
|
|
$lbl_save_button_key = $app_strings['LBL_SAVE_BUTTON_KEY'];
|
|
$lbl_save_button_label = $app_strings['LBL_SAVE_BUTTON_LABEL'];
|
|
|
|
|
|
$the_form = get_left_form_header($mod_strings['LBL_NEW_FORM_TITLE']);
|
|
$the_form .= <<<EOQ
|
|
<form name="{$prefix}OppSave" onSubmit="return check_form('{$prefix}OppSave')" method="POST" action="index.php">
|
|
<input type="hidden" name="{$prefix}module" value="Opportunities">
|
|
<input type="hidden" name="{$prefix}action" value="Save">
|
|
EOQ;
|
|
$the_form .= $this->getFormBody($prefix, $mod, "{$prefix}OppSave");
|
|
$the_form .= <<<EOQ
|
|
<input title="$lbl_save_button_title" accessKey="$lbl_save_button_key" class="button" type="submit" name="button" value=" $lbl_save_button_label " >
|
|
</form>
|
|
|
|
EOQ;
|
|
$the_form .= get_left_form_footer();
|
|
$the_form .= get_validate_record_js();
|
|
|
|
return $the_form;
|
|
}
|
|
|
|
public function getWideFormBody($prefix, $mod='Opportunities', $formname='', $lead='', $showaccount = true)
|
|
{
|
|
if (!ACLController::checkAccess('Opportunities', 'edit', true)) {
|
|
return '';
|
|
}
|
|
if (empty($lead)) {
|
|
$lead = BeanFactory::newBean('Leads');
|
|
}
|
|
global $mod_strings, $sugar_config;
|
|
$showaccount = $showaccount && $sugar_config['require_accounts'];
|
|
$temp_strings = $mod_strings;
|
|
if (!empty($mod)) {
|
|
global $current_language;
|
|
$mod_strings = return_module_language($current_language, $mod);
|
|
}
|
|
|
|
global $app_strings;
|
|
global $app_list_strings;
|
|
global $theme;
|
|
global $current_user;
|
|
global $timedate;
|
|
// Unimplemented until jscalendar language files are fixed
|
|
// global $current_language;
|
|
// global $default_language;
|
|
// global $cal_codes;
|
|
|
|
$lbl_required_symbol = $app_strings['LBL_REQUIRED_SYMBOL'];
|
|
$lbl_opportunity_name = $mod_strings['LBL_OPPORTUNITY_NAME'];
|
|
$lbl_sales_stage = $mod_strings['LBL_SALES_STAGE'];
|
|
$lbl_date_closed = $mod_strings['LBL_DATE_CLOSED'];
|
|
$lbl_amount = $mod_strings['LBL_AMOUNT'];
|
|
$lbl_probability = $mod_strings['LBL_PROBABILITY'];
|
|
$json = getJSONobj();
|
|
$prob_array = $json->encode($app_list_strings['sales_probability_dom']);
|
|
//$prePopProb = '';
|
|
//if(empty($this->bean->id))
|
|
$prePopProb = 'document.getElementsByName(\''.$prefix.'sales_stage\')[0].onchange();';
|
|
$probability_script=<<<EOQ
|
|
<script>
|
|
prob_array = $prob_array;
|
|
document.getElementsByName('{$prefix}sales_stage')[0].onchange = function() {
|
|
if(typeof(document.getElementsByName('{$prefix}sales_stage')[0].value) != "undefined" && prob_array[document.getElementsByName('{$prefix}sales_stage')[0].value]) {
|
|
document.getElementsByName('{$prefix}probability')[0].value = prob_array[document.getElementsByName('{$prefix}sales_stage')[0].value];
|
|
}
|
|
};
|
|
$prePopProb
|
|
</script>
|
|
EOQ;
|
|
|
|
$ntc_date_format = $timedate->get_user_date_format();
|
|
$cal_dateformat = $timedate->get_cal_date_format();
|
|
if (isset($lead->assigned_user_id)) {
|
|
$user_id=$lead->assigned_user_id;
|
|
} else {
|
|
$user_id = $current_user->id;
|
|
}
|
|
|
|
|
|
// Unimplemented until jscalendar language files are fixed
|
|
// $cal_lang = (empty($cal_codes[$current_language])) ? $cal_codes[$default_language] : $cal_codes[$current_language];
|
|
$cal_lang = "en";
|
|
|
|
$the_form="";
|
|
|
|
|
|
if (isset($lead->opportunity_amount)) {
|
|
$opp_amount=$lead->opportunity_amount;
|
|
} else {
|
|
$opp_amount='';
|
|
}
|
|
$the_form .= <<<EOQ
|
|
|
|
<input type="hidden" name="{$prefix}record" value="">
|
|
<input type="hidden" name="{$prefix}account_name">
|
|
<input type="hidden" name="{$prefix}assigned_user_id" value='{$user_id}'>
|
|
|
|
<table cellspacing="0" cellpadding="0" border="0" width="100%">
|
|
<tr>
|
|
<td width="20%" scope="row">$lbl_opportunity_name <span class="required">$lbl_required_symbol</span></td>
|
|
<td width="80%" scope="row">{$mod_strings['LBL_DESCRIPTION']}</td>
|
|
</tr>
|
|
<tr>
|
|
<td ><input name='{$prefix}name' type="text" value="{$lead->opportunity_name}"></td>
|
|
<td rowspan="7"><textarea name='{$prefix}description' rows='5' cols='50'></textarea></td>
|
|
</tr>
|
|
<tr>
|
|
<td scope="row">$lbl_date_closed <span class="required">$lbl_required_symbol</span></td>
|
|
</tr>
|
|
<tr>
|
|
<td ><input name='{$prefix}date_closed' onblur="parseDate(this, '$cal_dateformat');" size='12' maxlength='10' id='{$prefix}jscal_field' type="text" value=""> <!--not_in_theme!--><span class="suitepicon suitepicon-module-calendar"></span></td>
|
|
</tr>
|
|
EOQ;
|
|
if ($showaccount) {
|
|
$the_form .= <<<EOQ
|
|
<tr>
|
|
<td scope="row">{$mod_strings['LBL_ACCOUNT_NAME']} <span class="required">{$lbl_required_symbol}</span></td>
|
|
</tr>
|
|
<tr>
|
|
<td ><input readonly id='qc_account_name' name='account_name' type='text' value="" size="16"><input id='qc_account_id' name='account_id' type="hidden" value=''> <input title="{$app_strings['LBL_SELECT_BUTTON_TITLE']}" type="button" class="button" value='{$app_strings['LBL_SELECT_BUTTON_LABEL']}' name=btn1 LANGUAGE=javascript onclick='return window.open("index.php?module=Accounts&action=Popup&html=Popup_picker&form={$formname}&form_submit=false","","width=600,height=400,resizable=1,scrollbars=1");'></td>
|
|
</tr>
|
|
EOQ;
|
|
}
|
|
$the_form .= <<<EOQ
|
|
<tr>
|
|
<td scope="row">$lbl_sales_stage <span class="required">$lbl_required_symbol</span></td>
|
|
</tr>
|
|
<tr>
|
|
<td ><select name='{$prefix}sales_stage'>
|
|
EOQ;
|
|
$the_form .= get_select_options_with_id($app_list_strings['sales_stage_dom'], "");
|
|
$the_form .= <<<EOQ
|
|
</select></td>
|
|
</tr>
|
|
<tr>
|
|
<td scope="row">$lbl_amount <span class="required">$lbl_required_symbol</span></td>
|
|
</tr>
|
|
<tr>
|
|
<td ><input name='{$prefix}amount' type="text" value='{$opp_amount}'></td>
|
|
</tr>
|
|
EOQ;
|
|
//carry forward custom lead fields to opportunities during Lead Conversion
|
|
$tempOpp = BeanFactory::newBean('Opportunities');
|
|
if (method_exists($lead, 'convertCustomFieldsForm')) {
|
|
$lead->convertCustomFieldsForm($the_form, $tempOpp, $prefix);
|
|
}
|
|
unset($tempOpp);
|
|
|
|
$the_form .= <<<EOQ
|
|
|
|
</table>
|
|
|
|
<script type="text/javascript">
|
|
Calendar.setup ({
|
|
inputField : "{$prefix}jscal_field", ifFormat : "$cal_dateformat", showsTime : false, button : "{$prefix}jscal_trigger", singleClick : true, step : 1, weekNumbers:false
|
|
});
|
|
</script>
|
|
|
|
|
|
EOQ;
|
|
|
|
|
|
|
|
$javascript = new javascript();
|
|
$javascript->setFormName($formname);
|
|
$javascript->setSugarBean(BeanFactory::newBean('Opportunities'));
|
|
$javascript->addRequiredFields($prefix);
|
|
$the_form .=$javascript->getScript();
|
|
$mod_strings = $temp_strings;
|
|
return $the_form;
|
|
} // end getWideFormBody
|
|
|
|
public function getFormBody($prefix, $mod='Opportunities', $formname='')
|
|
{
|
|
if (!ACLController::checkAccess('Opportunities', 'edit', true)) {
|
|
return '';
|
|
}
|
|
if (!empty($mod)) {
|
|
global $current_language;
|
|
$mod_strings = return_module_language($current_language, $mod);
|
|
} else {
|
|
global $mod_strings;
|
|
}
|
|
global $app_strings;
|
|
global $app_list_strings;
|
|
global $theme;
|
|
global $current_user;
|
|
global $sugar_config;
|
|
global $timedate;
|
|
// Unimplemented until jscalendar language files are fixed
|
|
// global $current_language;
|
|
// global $default_language;
|
|
// global $cal_codes;
|
|
|
|
$json = null;
|
|
|
|
$lbl_required_symbol = $app_strings['LBL_REQUIRED_SYMBOL'];
|
|
$lbl_opportunity_name = $mod_strings['LBL_OPPORTUNITY_NAME'];
|
|
$lbl_sales_stage = $mod_strings['LBL_SALES_STAGE'];
|
|
$lbl_date_closed = $mod_strings['LBL_DATE_CLOSED'];
|
|
$lbl_amount = $mod_strings['LBL_AMOUNT'];
|
|
|
|
$ntc_date_format = $timedate->get_user_date_format();
|
|
$cal_dateformat = $timedate->get_cal_date_format();
|
|
|
|
$user_id = $current_user->id;
|
|
|
|
// Unimplemented until jscalendar language files are fixed
|
|
// $cal_lang = (empty($cal_codes[$current_language])) ? $cal_codes[$default_language] : $cal_codes[$current_language];
|
|
$cal_lang = "en";
|
|
|
|
$the_form = <<<EOQ
|
|
<p>
|
|
<input type="hidden" name="{$prefix}record" value="">
|
|
<input type="hidden" name="{$prefix}assigned_user_id" value='{$user_id}'>
|
|
|
|
$lbl_opportunity_name <span class="required">$lbl_required_symbol</span><br>
|
|
<input name='{$prefix}name' type="text" value="">
|
|
EOQ;
|
|
if ($sugar_config['require_accounts']) {
|
|
|
|
///////////////////////////////////////
|
|
///
|
|
/// SETUP ACCOUNT POPUP
|
|
|
|
$popup_request_data = array(
|
|
'call_back_function' => 'set_return',
|
|
'form_name' => "{$prefix}OppSave",
|
|
'field_to_name_array' => array(
|
|
'id' => 'account_id',
|
|
'name' => 'account_name',
|
|
),
|
|
);
|
|
|
|
$json = getJSONobj();
|
|
$encoded_popup_request_data = $json->encode($popup_request_data);
|
|
|
|
//
|
|
///////////////////////////////////////
|
|
|
|
$the_form .= <<<EOQ
|
|
{$mod_strings['LBL_ACCOUNT_NAME']} <span class="required">{$lbl_required_symbol}</span><br>
|
|
<input class='sqsEnabled' autocomplete='off' id='qc_account_name' name='account_name' type='text' value="" size="16"><input id='qc_account_id' name='account_id' type="hidden" value=''> <input title="{$app_strings['LBL_SELECT_BUTTON_TITLE']}" type="button" class="button" value='{$app_strings['LBL_SELECT_BUTTON_LABEL']}' name=btn1
|
|
onclick='open_popup("Accounts", 600, 400, "", true, false, {$encoded_popup_request_data});' /><br>
|
|
EOQ;
|
|
}
|
|
$the_form .= <<<EOQ
|
|
$lbl_date_closed <span class="required">$lbl_required_symbol</span> <br><span class="dateFormat">$ntc_date_format</span><br>
|
|
<input name='{$prefix}date_closed' size='12' maxlength='10' id='{$prefix}jscal_field' type="text" value=""> <!--not_in_theme!--><span class="suitepicon suitepicon-module-calendar"></span><br>
|
|
$lbl_sales_stage <span class="required">$lbl_required_symbol</span><br>
|
|
<select name='{$prefix}sales_stage'>
|
|
EOQ;
|
|
$the_form .= get_select_options_with_id($app_list_strings['sales_stage_dom'], "");
|
|
$the_form .= <<<EOQ
|
|
</select><br>
|
|
$lbl_amount <span class="required">$lbl_required_symbol</span><br>
|
|
<input name='{$prefix}amount' type="text"></p>
|
|
<input type='hidden' name='lead_source' value=''>
|
|
<script type="text/javascript">
|
|
Calendar.setup ({
|
|
inputField : "{$prefix}jscal_field", daFormat : "$cal_dateformat", ifFormat : "$cal_dateformat", showsTime : false, button : "jscal_trigger", singleClick : true, step : 1, weekNumbers:false
|
|
});
|
|
</script>
|
|
EOQ;
|
|
|
|
|
|
require_once('include/QuickSearchDefaults.php');
|
|
$qsd = QuickSearchDefaults::getQuickSearchDefaults();
|
|
$sqs_objects = array('qc_account_name' => $qsd->getQSParent());
|
|
$sqs_objects['qc_account_name']['populate_list'] = array('qc_account_name', 'qc_account_id');
|
|
$quicksearch_js = '<script type="text/javascript" language="javascript">sqs_objects = ' . $json->encode($sqs_objects) . '</script>';
|
|
$the_form .= $quicksearch_js;
|
|
|
|
|
|
|
|
$javascript = new javascript();
|
|
$javascript->setFormName($formname);
|
|
$javascript->setSugarBean(BeanFactory::newBean('Opportunities'));
|
|
$javascript->addRequiredFields($prefix);
|
|
$the_form .=$javascript->getScript();
|
|
|
|
|
|
return $the_form;
|
|
}
|
|
|
|
|
|
public function handleSave($prefix, $redirect=true, $useRequired=false)
|
|
{
|
|
global $current_user;
|
|
|
|
|
|
require_once('include/formbase.php');
|
|
|
|
$focus = BeanFactory::newBean('Opportunities');
|
|
if ($useRequired && !checkRequired($prefix, array_keys($focus->required_fields))) {
|
|
return null;
|
|
}
|
|
|
|
if (empty($_POST['currency_id'])) {
|
|
$currency_id = $current_user->getPreference('currency');
|
|
if (isset($currency_id)) {
|
|
$focus->currency_id = $currency_id;
|
|
}
|
|
}
|
|
$focus = populateFromPost($prefix, $focus);
|
|
if (!ACLController::checkAccess($focus->module_dir, 'edit', $focus->isOwner($current_user->id))) {
|
|
ACLController::displayNoAccess(true);
|
|
}
|
|
$check_notify = false;
|
|
if (isset($GLOBALS['check_notify'])) {
|
|
$check_notify = $GLOBALS['check_notify'];
|
|
}
|
|
|
|
$focus->save($check_notify);
|
|
|
|
if (!empty($_POST['duplicate_parent_id']) && (new \SuiteCRM\Utility\SuiteValidator())->isValidId($_POST['duplicate_parent_id'] ?? '')) {
|
|
clone_relationship($focus->db, array('opportunities_contacts'), 'opportunity_id', $focus->db->quote($_POST['duplicate_parent_id']), $focus->id);
|
|
}
|
|
$return_id = $focus->id;
|
|
|
|
$GLOBALS['log']->debug("Saved record with id of ".$return_id);
|
|
if ($redirect) {
|
|
handleRedirect($return_id, "Opportunities");
|
|
} else {
|
|
return $focus;
|
|
}
|
|
}
|
|
}
|