Edit file File name : OpportunityFormBase.php Content :<?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". */ 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 = count($rows[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; $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'])) { clone_relationship($focus->db, array('opportunities_contacts'), 'opportunity_id', $_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; } } } Save