include/MassUpdate.php

   1 <?php
   2 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
   3 /*********************************************************************************
   4  * SugarCRM is a customer relationship management program developed by
   5  * SugarCRM, Inc. Copyright (C) 2004-2011 SugarCRM Inc.
   6  *
   7  * This program is free software; you can redistribute it and/or modify it under
   8  * the terms of the GNU Affero General Public License version 3 as published by the
   9  * Free Software Foundation with the addition of the following permission added
  10  * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
  11  * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
  12  * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
  13  *
  14  * This program is distributed in the hope that it will be useful, but WITHOUT
  15  * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
  16  * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
  17  * details.
  18  *
  19  * You should have received a copy of the GNU Affero General Public License along with
  20  * this program; if not, see http://www.gnu.org/licenses or write to the Free
  21  * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
  22  * 02110-1301 USA.
  23  *
  24  * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
  25  * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
  26  *
  27  * The interactive user interfaces in modified source and object code versions
  28  * of this program must display Appropriate Legal Notices, as required under
  29  * Section 5 of the GNU Affero General Public License version 3.
  30  *
  31  * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
  32  * these Appropriate Legal Notices must retain the display of the "Powered by
  33  * SugarCRM" logo. If the display of the logo is not reasonably feasible for
  34  * technical reasons, the Appropriate Legal Notices must display the words
  35  * "Powered by SugarCRM".
  36  ********************************************************************************/
  37
  38
  39
  40
  41 /**
  42  * MassUpdate class for updating multiple records at once
  43  */
  44  require_once('include/EditView/EditView2.php');
  45 class MassUpdate
  46 {
  47         /*
  48          * internal sugarbean reference
  49          */
  50         var $sugarbean = null;
  51
  52         /**
  53           * set the sugar bean to its internal member
  54           * @param sugar bean reference
  55           */
  56         function setSugarBean($sugar)
  57         {
  58                 $this->sugarbean = $sugar;
  59         }
  60
  61         /**
  62          * get the massupdate form
  63          * @param bool boolean need to execute the massupdate form or not
  64          * @param multi_select_popup booleanif it is a multi-select value
  65          */
  66         function getDisplayMassUpdateForm($bool, $multi_select_popup = false)
  67         {
  68
  69                 require_once('include/formbase.php');
  70
  71                 if(!$multi_select_popup)
  72                 $form = '<form action="index.php" method="post" name="displayMassUpdate" id="displayMassUpdate">' . "\n";
  73                 else
  74                 $form = '<form action="index.php" method="post" name="MassUpdate" id="MassUpdate">' . "\n";
  75
  76                 if($bool)
  77                 {
  78                         $form .= '<input type="hidden" name="mu" value="false" />' . "\n";
  79                 }
  80                 else
  81                 {
  82                         $form .= '<input type="hidden" name="mu" value="true" />' . "\n";
  83                 }
  84
  85                 $form .= getAnyToForm('mu', true);
  86                 if(!$multi_select_popup) $form .= "</form>\n";
  87
  88                 return $form;
  89         }
  90         /**
  91          * returns the mass update's html form header
  92          * @param multi_select_popup boolean if it is a mult-select or not
  93          */
  94         function getMassUpdateFormHeader($multi_select_popup = false)
  95         {
  96                 global $sugar_version;
  97                 global $sugar_config;
  98                 global $current_user;
  99
 100                 $temp = array_merge($_GET, $_POST);
 101         unset($temp['current_query_by_page']);
 102                 $query = base64_encode(serialize($temp));
 103
 104         $bean = loadBean($_REQUEST['module']);
 105        $order_by_name = $bean->module_dir.'2_'.strtoupper($bean->object_name).'_ORDER_BY' ;
 106        $lvso = isset($_REQUEST['lvso'])?$_REQUEST['lvso']:"";
 107        $request_order_by_name = isset($_REQUEST[$order_by_name])?$_REQUEST[$order_by_name]:"";
 108        $action = isset($_REQUEST['action'])?$_REQUEST['action']:"";
 109        $module = isset($_REQUEST['module'])?$_REQUEST['module']:"";
 110                 if($multi_select_popup)
 111                 $tempString = '';
 112                 else
 113                 $tempString = "<form action='index.php' method='post' name='MassUpdate'  id='MassUpdate' onsubmit=\"return check_form('MassUpdate');\">\n"
 114                 . "<input type='hidden' name='return_action' value='{$action}' />\n"
 115         . "<input type='hidden' name='return_module' value='{$module}' />\n"
 116                 . "<input type='hidden' name='massupdate' value='true' />\n"
 117                 . "<input type='hidden' name='delete' value='false' />\n"
 118                 . "<input type='hidden' name='merge' value='false' />\n"
 119         . "<input type='hidden' name='current_query_by_page' value='{$query}' />\n"
 120         . "<input type='hidden' name='module' value='{$module}' />\n"
 121         . "<input type='hidden' name='action' value='MassUpdate' />\n"
 122         . "<input type='hidden' name='lvso' value='{$lvso}' />\n"
 123         . "<input type='hidden' name='{$order_by_name}' value='{$request_order_by_name}' />\n";
 124
 125                 // cn: bug 9103 - MU navigation in emails is broken
 126                 if($_REQUEST['module'] == 'Emails') {
 127                         $type = "";
 128                         // determine "type" - inbound, archive, etc.
 129                         if (isset($_REQUEST['type'])) {
 130                                 $type = $_REQUEST['type'];
 131                         }
 132                         // determine owner
 133                         $tempString .=<<<eoq
 134                                 <input type='hidden' name='type' value="{$type}" />
 135                                 <input type='hidden' name='ie_assigned_user_id' value="{$current_user->id}" />
 136 eoq;
 137                 }
 138
 139                 return $tempString;
 140         }
 141
 142         /**
 143           * Executes the massupdate form
 144           * @param displayname Name to display in the popup window
 145       * @param varname name of the variable
 146           */
 147         function handleMassUpdate(){
 148
 149                 require_once('include/formbase.php');
 150                 global $current_user, $db;
 151
 152                 /*
 153                  C.L. - Commented this out... not sure why it's here
 154                 if(!is_array($this->sugarbean) && $this->sugarbean->bean_implements('ACL') && !ACLController::checkAccess($this->sugarbean->module_dir, 'edit', true))
 155                 {
 156
 157                 }
 158         */
 159
 160                 foreach($_POST as $post=>$value){
 161                         if(is_array($value)){
 162                                 if(empty($value)){
 163                                         unset($_POST[$post]);
 164                                 }
 165                         }elseif(strlen($value) == 0){
 166                                 if( isset($this->sugarbean->field_defs[$post]) && $this->sugarbean->field_defs[$post]['type'] == 'radioenum' && isset($_POST[$post]) ){
 167                                         $_POST[$post] = '';
 168                                 }else{
 169                                 unset($_POST[$post]);
 170                         }
 171                         }
 172                         if(is_string($value)
 173                                  && isset($this->sugarbean->field_defs[$post]) &&
 174                                  ($this->sugarbean->field_defs[$post]['type'] == 'bool'
 175                                         || (!empty($this->sugarbean->field_defs[$post]['custom_type']) && $this->sugarbean->field_defs[$post]['custom_type'] == 'bool'
 176                                         ))){
 177
 178
 179                                                 if(strcmp($value, '2') == 0)$_POST[$post] = 0;
 180                                                 if(!empty($this->sugarbean->field_defs[$post]['dbType']) && strcmp($this->sugarbean->field_defs[$post]['dbType'], 'varchar') == 0 ){
 181                                                         if(strcmp($value, '1') == 0 )$_POST[$post] = 'on';
 182                                                         if(strcmp($value, '2') == 0)$_POST[$post] = 'off';
 183                                                 }
 184                         }
 185                         if(is_string($value)
 186                                  && isset($this->sugarbean->field_defs[$post]) && $this->sugarbean->field_defs[$post]['type'] == 'radioenum' && isset($_POST[$post]) && strlen($value) == 0){
 187                                 $_POST[$post] = '';
 188                         }
 189                 }
 190
 191                 if(!empty($_REQUEST['uid'])) $_POST['mass'] = explode(',', $_REQUEST['uid']); // coming from listview
 192                 elseif(isset($_REQUEST['entire']) && empty($_POST['mass'])) {
 193                         if(empty($order_by))$order_by = '';
 194                         $ret_array = create_export_query_relate_link_patch($_REQUEST['module'], $this->searchFields, $this->where_clauses);
 195                         if(!isset($ret_array['join'])) {
 196                                 $ret_array['join'] = '';
 197                         }
 198                         $query = $this->sugarbean->create_export_query($order_by, $ret_array['where'], $ret_array['join']);
 199                         $result = $db->query($query,true);
 200                         $new_arr = array();
 201                         while($val = $db->fetchByAssoc($result,-1,false))
 202                         {
 203                                 array_push($new_arr, $val['id']);
 204                         }
 205                         $_POST['mass'] = $new_arr;
 206                 }
 207
 208                 if(isset($_POST['mass']) && is_array($_POST['mass'])  && $_REQUEST['massupdate'] == 'true'){
 209                         $count = 0;
 210
 211
 212                         foreach($_POST['mass'] as $id){
 213                 if(empty($id)) {
 214                     continue;
 215                 }
 216                                 if(isset($_POST['Delete'])){
 217                                         $this->sugarbean->retrieve($id);
 218                                         if($this->sugarbean->ACLAccess('Delete')){
 219                                         //Martin Hu Bug #20872
 220                                                 if($this->sugarbean->object_name == 'EmailMan'){
 221                                                         $query = "DELETE FROM emailman WHERE id = '" . $this->sugarbean->id . "'";
 222                                                         $db->query($query);
 223                                                 } else {
 224
 225                                                         $this->sugarbean->mark_deleted($id);
 226                                                 }
 227                                         }
 228                                 }
 229                                 else {
 230                                         if($this->sugarbean->object_name == 'Contact' && isset($_POST['Sync'])){ // special for contacts module
 231                                                 if($_POST['Sync'] == 'true') {
 232                                                         $this->sugarbean->retrieve($id);
 233                                                         if($this->sugarbean->ACLAccess('Save')){
 234                                                                 if($this->sugarbean->object_name == 'Contact'){
 235
 236                                                                         $this->sugarbean->contacts_users_id = $current_user->id;
 237                                                                         $this->sugarbean->save(false);
 238                                                                 }
 239                                                         }
 240                                                 }
 241                                                 elseif($_POST['Sync'] == 'false') {
 242                                                         $this->sugarbean->retrieve($id);
 243                                                         if($this->sugarbean->ACLAccess('Save')){
 244                                                                 if($this->sugarbean->object_name == 'Contact'){
 245                                                                         if (!isset($this->sugarbean->users))
 246                                                                         {
 247                                                                                 $this->sugarbean->load_relationship('user_sync');
 248                                                                         }
 249                                                                         $this->sugarbean->contacts_users_id = null;
 250                                                                         $this->sugarbean->user_sync->delete($this->sugarbean->id, $current_user->id);
 251                                                                 }
 252                                                         }
 253                                                 }
 254                                         } //end if for special Contact handling
 255
 256                                         if($count++ != 0) {
 257                                            //Create a new instance to clear values and handle additional updates to bean's 2,3,4...
 258                        $className = get_class($this->sugarbean);
 259                        $this->sugarbean = new $className();
 260                                         }
 261
 262                                         $this->sugarbean->retrieve($id);
 263
 264                                         foreach($_POST as $field=>$value){
 265                         if (isset($this->sugarbean->field_defs[$field])) {
 266                             if($this->sugarbean->field_defs[$field]['type'] == 'datetime') {
 267                                 $_POST[$field] = $this->date_to_dateTime($field, $value);
 268                             }
 269                             if($this->sugarbean->field_defs[$field]['type'] == 'datetimecombo') {
 270                                 if(!empty($_POST[$field]) && strlen($_POST[$field]) > 10 ){
 271                                                                 $dateValue = $_POST[$field];
 272                                                                 $_POST[$field] = $dateValue;
 273                                                         }else{
 274                                                                 unset($_POST[$field]);
 275                                                         }
 276                             }
 277                             if ($this->sugarbean->field_defs[$field]['type'] == 'bool') {
 278                                 $this->checkClearField($field, $value);
 279                             }
 280                         }
 281                     }
 282
 283
 284                                         if($this->sugarbean->ACLAccess('Save')){
 285                                                 $_POST['record'] = $id;
 286                                                 $_GET['record'] = $id;
 287                                                 $_REQUEST['record'] = $id;
 288                                                 $newbean=$this->sugarbean;
 289
 290                                                 $old_reports_to_id = null;
 291                                                 if(!empty($_POST['reports_to_id']) && $newbean->reports_to_id != $_POST['reports_to_id']) {
 292                                                    $old_reports_to_id = empty($newbean->reports_to_id) ? 'null' : $newbean->reports_to_id;
 293                                                 }
 294
 295                                                 $check_notify = FALSE;
 296
 297                                                 if (isset( $this->sugarbean->assigned_user_id)) {
 298                                                         $old_assigned_user_id = $this->sugarbean->assigned_user_id;
 299                                                         if (!empty($_POST['assigned_user_id'])
 300                                                         && ($old_assigned_user_id != $_POST['assigned_user_id'])
 301                                                         && ($_POST['assigned_user_id'] != $current_user->id)) {
 302                                                                 $check_notify = TRUE;
 303                                                         }
 304                                                 }
 305
 306                                                 //Call include/formbase.php, but do not call retrieve again
 307                                                 populateFromPost('', $newbean, true);
 308                                                 $newbean->save_from_post = false;
 309
 310                                                 if (!isset($_POST['parent_id'])) {
 311                                                         $newbean->parent_type = null;
 312                                                 }
 313
 314                                                 $email_address_id = '';
 315                             if (!empty($_POST['optout_primary'])) {
 316                                 $optout_flag_value = 0;
 317                                 if ($_POST['optout_primary'] == 'true') {
 318                                         $optout_flag_value = 1;
 319                                 } // if
 320                                 if (isset($this->sugarbean->emailAddress)) {
 321                                         if (!empty($this->sugarbean->emailAddress->addresses)) {
 322                                                 foreach($this->sugarbean->emailAddress->addresses as $key =>$emailAddressRow) {
 323                                                         if ($emailAddressRow['primary_address'] == '1') {
 324                                                                 $email_address_id = $emailAddressRow['email_address_id'];
 325                                                                 break;
 326                                                                                 } // if
 327                                                                         } // foreach
 328                                                                 } // if
 329
 330                                                         } // if
 331                             } // if
 332
 333
 334                                                 $newbean->save($check_notify);
 335                                                 if (!empty($email_address_id)) {
 336                                                 $query = "UPDATE email_addresses SET opt_out = {$optout_flag_value} where id = '{$emailAddressRow['email_address_id']}'";
 337                                                 $GLOBALS['db']->query($query);
 338
 339                                                 } // if
 340
 341                                                 if(!empty($old_reports_to_id) && method_exists($newbean, 'update_team_memberships')) {
 342                                                    $old_id = $old_reports_to_id == 'null' ? '' : $old_reports_to_id;
 343                                                 }
 344                                         }
 345                                 }
 346                         }
 347
 348                 }
 349
 350         }
 351         /**
 352           * Displays the massupdate form
 353           */
 354         function getMassUpdateForm(
 355             $hideDeleteIfNoFieldsAvailable = false
 356             )
 357         {
 358                 global $app_strings;
 359                 global $current_user;
 360
 361                 if($this->sugarbean->bean_implements('ACL') && !ACLController::checkAccess($this->sugarbean->module_dir, 'edit', true)){
 362                         return '';
 363                 }
 364                 $lang_delete = translate('LBL_DELETE');
 365                 $lang_update = translate('LBL_UPDATE');
 366                 $lang_confirm= translate('NTC_DELETE_CONFIRMATION_MULTIPLE');
 367                 $lang_sync = translate('LBL_SYNC_CONTACT');
 368                 $lang_oc_status = translate('LBL_OC_STATUS');
 369                 $lang_unsync = translate('LBL_UNSYNC');
 370                 $lang_archive = translate('LBL_ARCHIVE');
 371                 $lang_optout_primaryemail = $app_strings['LBL_OPT_OUT_FLAG_PRIMARY'];
 372
 373
 374
 375 //              if(!isset($this->sugarbean->field_defs) || count($this->sugarbean->field_defs) == 0) {
 376 //                      $html = "<table cellpadding='0' cellspacing='0' border='0' width='100%'><tr><td>";
 377 //
 378 //                      if($this->sugarbean->ACLAccess('Delete', true) ){
 379 //                              $html .= "<input type='submit' name='Delete' value='{$lang_delete}' onclick=\"return confirm('{$lang_confirm}')\" class='button'>";
 380 //                      }
 381 //                      $html .= "</td></tr></table>";
 382 //                      return $html;
 383 //              }
 384
 385
 386                 $should_use = false;
 387                 $html = "<div id='massupdate_form' style='display:none;'><table width='100%' cellpadding='0' cellspacing='0' border='0' class='formHeader h3Row'><tr><td nowrap><h3><span>" . $app_strings['LBL_MASS_UPDATE']."</h3></td></tr></table>";
 388                 $html .= "<div id='mass_update_div'><table cellpadding='0' cellspacing='1' border='0' width='100%' class='edit view' id='mass_update_table'>";
 389
 390                 $even = true;
 391                 if($this->sugarbean->object_name == 'Contact'){
 392                         $html .= "<tr><td width='15%' scope='row'>$lang_sync</td><td width='35%' class='dataField'><select name='Sync'><option value=''>{$GLOBALS['app_strings']['LBL_NONE']}</option><option value='false'>{$GLOBALS['app_list_strings']['checkbox_dom']['2']}</option><option value='true'>{$GLOBALS['app_list_strings']['checkbox_dom']['1']}</option></select></td>";
 393                         $even = false;
 394                 }
 395
 396                 if($this->sugarbean->object_name == 'Employee'){
 397                         $this->sugarbean->field_defs['employee_status']['type'] = 'enum';
 398                         $this->sugarbean->field_defs['employee_status']['massupdate'] = true;
 399                         $this->sugarbean->field_defs['employee_status']['options'] = 'employee_status_dom';
 400                 }
 401                 if($this->sugarbean->object_name == 'InboundEmail'){
 402                         $this->sugarbean->field_defs['status']['type'] = 'enum';
 403                         $this->sugarbean->field_defs['status']['options'] = 'user_status_dom';
 404                 }
 405
 406                 static $banned = array('date_modified'=>1, 'date_entered'=>1, 'created_by'=>1, 'modified_user_id'=>1, 'deleted'=>1,'modified_by_name'=>1,);
 407                 foreach($this->sugarbean->field_defs as $field){
 408
 409                          if(!isset($banned[$field['name']]) && (!isset($field['massupdate']) || !empty($field['massupdate']))){
 410                                 $newhtml = '';
 411                                 if($even){
 412                                         $newhtml .= "<tr>";
 413                                 }
 414                                 if(isset($field['vname'])){
 415                                         $displayname = translate($field['vname']);
 416                                 }else{
 417                                         $displayname = '';
 418
 419                                 }
 420                                 if(isset($field['type']) && $field['type'] == 'relate' && isset($field['id_name']) && $field['id_name'] == 'assigned_user_id')
 421                                         $field['type'] = 'assigned_user_name';
 422                                 if(isset($field['custom_type']))$field['type'] = $field['custom_type'];
 423                                 if(isset($field['type']))
 424                                 {
 425                                         switch($field["type"]){
 426                                                 case "relate":
 427                                                     // bug 14691: avoid laying out an empty cell in the <table>
 428                                                         $handleRelationship = $this->handleRelationship($displayname, $field);
 429                                                         if ($handleRelationship != '') {
 430                                                                 $even = !$even;
 431                                                                 $newhtml .= $handleRelationship;
 432                                                         }
 433                                                         break;
 434                                                 case "parent":$even = !$even; $newhtml .=$this->addParent($displayname, $field); break;
 435                                                 case "int":
 436                                                         if(!empty($field['massupdate']) && empty($field['auto_increment'])){
 437                                                                 $even = !$even; $newhtml .=$this->addInputType($displayname, $field);
 438                                                         }
 439                                                          break;
 440                                                 case "contact_id":$even = !$even; $newhtml .=$this->addContactID($displayname, $field["name"]); break;
 441                                                 case "assigned_user_name":$even = !$even; $newhtml .= $this->addAssignedUserID($displayname,  $field["name"]); break;
 442                                                 case "account_id":$even = !$even; $newhtml .= $this->addAccountID($displayname,  $field["name"]); break;
 443                                                 case "account_name":$even = !$even; $newhtml .= $this->addAccountID($displayname,  $field["id_name"]); break;
 444                                                 case "bool": $even = !$even; $newhtml .= $this->addBool($displayname,  $field["name"]); break;
 445                                                 case "enum":
 446                                                 case "multienum":
 447                                                         if(!empty($field['isMultiSelect'])){
 448                                                                 $even = !$even; $newhtml .= $this->addStatusMulti($displayname,  $field["name"], translate($field["options"])); break;
 449                                                         }else if(!empty($field['options'])) {
 450                                                                 $even = !$even; $newhtml .= $this->addStatus($displayname,  $field["name"], translate($field["options"])); break;
 451                                                         }else if(!empty($field['function'])){
 452                                                                 $functionValue = $this->getFunctionValue($this->sugarbean, $field);
 453                                                                 $even = !$even; $newhtml .= $this->addStatus($displayname,  $field["name"], $functionValue); break;
 454                                                         }
 455                                                         break;
 456                                                 case "radioenum":
 457                                                 $even = !$even; $newhtml .= $this->addRadioenum($displayname,  $field["name"] , translate($field["options"])); break;
 458                                                 case "datetimecombo":
 459                                                 $even = !$even; $newhtml .= $this->addDatetime($displayname,  $field["name"]); break;
 460                                                 case "datetime":
 461                                                 case "date":$even = !$even; $newhtml .= $this->addDate($displayname,  $field["name"]); break;
 462                                         }
 463                                 }
 464                                 if($even){
 465                                         $newhtml .="</tr>";
 466                                 }else{
 467                                         $should_use = true;
 468                                 }
 469                                 if(!in_array($newhtml, array('<tr>', '</tr>', '<tr></tr>', '<tr><td></td></tr>'))){
 470                                         $html.=$newhtml;
 471                                 }
 472                         }
 473                 }
 474
 475
 476                 if ($this->sugarbean->object_name == 'Contact' ||
 477                         $this->sugarbean->object_name == 'Account' ||
 478                         $this->sugarbean->object_name == 'Lead' ||
 479                         $this->sugarbean->object_name == 'Prospect') {
 480
 481                         $html .= "<tr><td width='15%'  scope='row' class='dataLabel'>$lang_optout_primaryemail</td><td width='35%' class='dataField'><select name='optout_primary'><option value=''>{$GLOBALS['app_strings']['LBL_NONE']}</option><option value='false'>{$GLOBALS['app_list_strings']['checkbox_dom']['2']}</option><option value='true'>{$GLOBALS['app_list_strings']['checkbox_dom']['1']}</option></select></td></tr>";
 482
 483                         }
 484                 $html .="</table>";
 485
 486                  $html .= "<table cellpadding='0' cellspacing='0' border='0' width='100%'><tr><td class='buttons'><input onclick='return sListView.send_mass_update(\"selected\", \"{$app_strings['LBL_LISTVIEW_NO_SELECTED']}\")' type='submit' id='update_button' name='Update' value='{$lang_update}' class='button'>&nbsp;<input onclick='javascript:toggleMassUpdateForm();' type='button' id='cancel_button' name='Cancel' value='{$GLOBALS['app_strings']['LBL_CANCEL_BUTTON_LABEL']}' class='button'>";
 487                 // TODO: allow ACL access for Delete to be set false always for users
 488 //              if($this->sugarbean->ACLAccess('Delete', true) && $this->sugarbean->object_name != 'User') {
 489 //                      global $app_list_strings;
 490 //                      $html .=" <input id='delete_button' type='submit' name='Delete' value='{$lang_delete}' onclick='return confirm(\"{$lang_confirm}\") && sListView.send_mass_update(\"selected\", \"{$app_strings['LBL_LISTVIEW_NO_SELECTED']}\", 1)' class='button'>";
 491 //              }
 492
 493                 // only for My Inbox views - to allow CSRs to have an "Archive" emails feature to get the email "out" of their inbox.
 494                 if($this->sugarbean->object_name == 'Email'
 495                 && (isset($_REQUEST['assigned_user_id']) && !empty($_REQUEST['assigned_user_id']))
 496                 && (isset($_REQUEST['type']) && !empty($_REQUEST['type']) && $_REQUEST['type'] == 'inbound')) {
 497                         $html .=<<<eoq
 498                         <input type='button' name='archive' value="{$lang_archive}" class='button' onClick='setArchived();'>
 499                         <input type='hidden' name='ie_assigned_user_id' value="{$current_user->id}">
 500                         <input type='hidden' name='ie_type' value="inbound">
 501 eoq;
 502                 }
 503
 504                 $html .= "</td></tr></table></div></div>";
 505
 506                 $html .= <<<EOJS
 507 <script>
 508 function toggleMassUpdateForm(){
 509     document.getElementById('massupdate_form').style.display = 'none';
 510 }
 511 </script>
 512 EOJS;
 513                 if($should_use){
 514                         return $html;
 515                 }else{
 516                         if($this->sugarbean->ACLAccess('Delete', true) && !$hideDeleteIfNoFieldsAvailable){
 517                                 return "<table cellpadding='0' cellspacing='0' border='0' width='100%'><tr><td><input type='submit' name='Delete' value='$lang_delete' onclick=\"return confirm('{$lang_confirm}')\" class='button'></td></tr></table>";
 518                         }else{
 519                                 return '';
 520                         }
 521                 }
 522         }
 523
 524         function getFunctionValue($focus, $vardef){
 525                 $function = $vardef['function'];
 526             if(is_array($function) && isset($function['name'])){
 527                 $function = $vardef['function']['name'];
 528             }else{
 529                 $function = $vardef['function'];
 530             }
 531                 if(!empty($vardef['function']['returns']) && $vardef['function']['returns'] == 'html'){
 532                         if(!empty($vardef['function']['include'])){
 533                                 require_once($vardef['function']['include']);
 534                         }
 535                         return $function($focus, $vardef['name'], '', 'MassUpdate');
 536                 }else{
 537                         return $function($focus, $vardef['name'], '', 'MassUpdate');
 538                 }
 539         }
 540
 541         /**
 542           * Returns end of the massupdate form
 543           */
 544         function endMassUpdateForm(){
 545                 return '</form>';
 546         }
 547
 548         /**
 549           * Decides which popup HTML code is needed for mass updating
 550           * @param displayname Name to display in the popup window
 551           * @param field name of the field to update
 552           */
 553         function handleRelationship($displayname, $field)
 554         {
 555                 $ret_val = '';
 556                 if(isset($field['module']))
 557                 {
 558                         if ($field['name'] == 'reports_to_name' && ($field['module'] == 'Users' || $field['module'] == 'Employee') )
 559                             return $this->addUserName($displayname, $field['name'], $field['id_name'], $field['module']);
 560
 561                     switch($field['module'])
 562                         {
 563                                 case 'Accounts':
 564                                         $ret_val = $this->addAccountID($displayname, $field['name'], $field['id_name']);
 565                                         break;
 566                                 case 'Contacts':
 567                                         $ret_val = $this->addGenericModuleID($displayname, $field['name'], $field['id_name'], "Contacts");
 568                                         break;
 569                                 case 'Users':
 570                                         $ret_val = $this->addGenericModuleID($displayname, $field['name'], $field['id_name'], "Users");
 571                                         break;
 572                                 case 'Employee':
 573                                         $ret_val = $this->addGenericModuleID($displayname, $field['name'], $field['id_name'], "Employee");
 574                                         break;
 575                                 case 'Releases':
 576                                         $ret_val = $this->addGenericModuleID($displayname, $field['name'], $field['id_name'], "Releases");
 577                                         break;
 578                                 default:
 579                                         if(!empty($field['massupdate'])){
 580                                                 $ret_val = $this->addGenericModuleID($displayname, $field['name'], $field['id_name'], $field['module']);
 581                                         }
 582                                         break;
 583                         }
 584                 }
 585
 586                 return $ret_val;
 587         }
 588         /**
 589           * Add a parent selection popup window
 590           * @param displayname Name to display in the popup window
 591           * @param field_name name of the field
 592           */
 593         function addParent($displayname, $field){
 594                 global $app_strings, $app_list_strings;
 595
 596                 ///////////////////////////////////////
 597                 ///
 598                 /// SETUP POPUP
 599
 600                 $popup_request_data = array(
 601                 'call_back_function' => 'set_return',
 602                 'form_name' => 'MassUpdate',
 603                 'field_to_name_array' => array(
 604                         'id' => "parent_id",
 605                         'name' => "parent_name",
 606                         ),
 607                         );
 608
 609                         $json = getJSONobj();
 610                         $encoded_popup_request_data = $json->encode($popup_request_data);
 611
 612             $qsName = array(
 613                                     'form' => 'MassUpdate',
 614                                                 'method' => 'query',
 615                         'modules' => array("Accounts"),
 616                         'group' => 'or',
 617                                                 'field_list' => array('name', 'id'),
 618                                                 'populate_list' => array("mass_parent_name", "mass_parent_id"),
 619                                                 'conditions' => array(array('name'=>'name','op'=>'like_custom','end'=>'%','value'=>'')),
 620                                                 'limit' => '30','no_match_text' => $app_strings['ERR_SQS_NO_MATCH']);
 621                 $qsName = $json->encode($qsName);
 622
 623                         //
 624                         ///////////////////////////////////////
 625
 626                         $change_parent_button = "<span class='id-ff'><button title='".$app_strings['LBL_SELECT_BUTTON_TITLE']."' accessKey='".$app_strings['LBL_SELECT_BUTTON_KEY']."'  type='button' class='button' value='".$app_strings['LBL_SELECT_BUTTON_LABEL']
 627                         ."' name='button_parent_name' onclick='open_popup(document.MassUpdate.{$field['type_name']}.value, 600, 400, \"\", true, false, {$encoded_popup_request_data});'><img src='".SugarThemeRegistry::current()->getImageURL('id-ff-select.png')."'></button></span>";
 628                         $parent_type = $field['parent_type'];
 629             $parent_types = $app_list_strings[$parent_type];
 630             $disabled_parent_types = ACLController::disabledModuleList($parent_types,false, 'list');
 631             foreach($disabled_parent_types as $disabled_parent_type) {
 632                             unset($parent_types[$disabled_parent_type]);
 633             }
 634                         $types = get_select_options_with_id($parent_types, '');
 635                         //BS Fix Bug 17110
 636                         $pattern = "/\n<OPTION.*".$app_strings['LBL_NONE']."<\/OPTION>/";
 637                         $types = preg_replace($pattern, "", $types);
 638                         // End Fix
 639
 640             $json = getJSONobj();
 641             $disabled_parent_types = $json->encode($disabled_parent_types);
 642
 643                         return <<<EOHTML
 644 <td width="15%" scope="row">{$displayname} </td>
 645 <td>
 646     <table width='100%' border='0' cellspacing='0' cellpadding='0'>
 647     <tr>
 648         <td valign='top'>
 649             <select name='{$field['type_name']}' id='mass_{$field['type_name']}'>
 650                 $types
 651             </select>
 652         </td>
 653         <td valign='top'>
 654                         <input name='{$field['id_name']}' id='mass_{$field['id_name']}' type='hidden' value=''>
 655                         <input name='parent_name' id='mass_parent_name' class='sqsEnabled' autocomplete='off'
 656                 type='text' value=''>
 657             $change_parent_button
 658         </td>
 659     </tr>
 660     </table>
 661 </td>
 662 <script type="text/javascript">
 663 <!--
 664 var disabledModules='{$disabled_parent_types}';
 665 if(typeof sqs_objects == 'undefined'){
 666     var sqs_objects = new Array;
 667 }
 668 sqs_objects['MassUpdate_parent_name'] = $qsName;
 669 registerSingleSmartInputListener(document.getElementById('mass_parent_name'));
 670 addToValidateBinaryDependency('MassUpdate', 'parent_name', 'alpha', false, '{$app_strings['ERR_SQS_NO_MATCH_FIELD']} {$app_strings['LBL_ASSIGNED_TO']}','parent_id');
 671
 672 document.getElementById('mass_{$field['type_name']}').onchange = function()
 673 {
 674     document.MassUpdate.parent_name.value="";
 675     document.MassUpdate.parent_id.value="";
 676
 677         new_module = document.forms["MassUpdate"].elements["parent_type"].value;
 678
 679         if(typeof(disabledModules[new_module]) != 'undefined') {
 680                 sqs_objects["MassUpdate_parent_name"]["disable"] = true;
 681                 document.forms["MassUpdate"].elements["parent_name"].readOnly = true;
 682         } else {
 683                 sqs_objects["MassUpdate_parent_name"]["disable"] = false;
 684                 document.forms["MassUpdate"].elements["parent_name"].readOnly = false;
 685         }
 686         sqs_objects["MassUpdate_parent_name"]["modules"] = new Array(new_module);
 687     enableQS(false);
 688
 689     checkParentType(document.MassUpdate.parent_type.value, document.MassUpdate.button_parent_name);
 690 }
 691 -->
 692 </script>
 693 EOHTML;
 694         }
 695
 696         /**
 697           * Add a generic input type='text' field
 698           * @param displayname Name to display in the popup window
 699           * @param field_name name of the field
 700           */
 701         function addInputType($displayname, $varname){
 702                 $html = <<<EOQ
 703         <td scope="row" width="20%">$displayname</td>
 704         <td class='dataField' width="30%"><input type="text" name='$varname' size="12" id='{$varname}' maxlength='10' value=""></td>
 705         <script> addToValidate('MassUpdate','$varname','int',false,'$displayname');</script>
 706 EOQ;
 707                 return $html;
 708
 709         }
 710
 711     /**
 712           * Add a generic widget to lookup Users.
 713           * @param displayname Name to display in the popup window
 714           * @param varname name of the variable
 715           * @param id_name name of the id in vardef
 716           * @param mod_type name of the module, either "Contact" or "Releases" currently
 717           */
 718         function addUserName($displayname, $varname, $id_name='', $mod_type){
 719                 global $app_strings;
 720
 721                 if(empty($id_name))
 722                 $id_name = strtolower($mod_type)."_id";
 723
 724                 ///////////////////////////////////////
 725                 ///
 726                 /// SETUP POPUP
 727         $reportsDisplayName = showFullName() ? 'name' : 'user_name';
 728                 $popup_request_data = array(
 729                         'call_back_function' => 'set_return',
 730                         'form_name' => 'MassUpdate',
 731                         'field_to_name_array' => array(
 732                                 'id' => "{$id_name}",
 733                                 "$reportsDisplayName" => "{$varname}",
 734                                 ),
 735                                 );
 736
 737                                 $json = getJSONobj();
 738                                 $encoded_popup_request_data = $json->encode($popup_request_data);
 739
 740                 $qsName = array(
 741                                     'form' => 'MassUpdate',
 742                                                 'method' => 'get_user_array',
 743                         'modules' => array("{$mod_type}"),
 744                         'group' => 'or',
 745                                                 'field_list' => array('user_name', 'id'),
 746                                                 'populate_list' => array("mass_{$varname}", "mass_{$id_name}"),
 747                                                 'conditions' => array(array('name'=>'name','op'=>'like_custom','end'=>'%','value'=>'')),
 748                                                 'limit' => '30','no_match_text' => $app_strings['ERR_SQS_NO_MATCH']);
 749                 $qsName = $json->encode($qsName);
 750                                 //
 751                                 ///////////////////////////////////////
 752
 753             return <<<EOHTML
 754 <td width='15%'  scope='row' class='dataLabel'>$displayname</td>
 755 <td width='35%' class='dataField'>
 756     <input name='{$varname}' id='mass_{$varname}' class='sqsEnabled' autocomplete='off' type='text' value=''>
 757     <input name='{$id_name}' id='mass_{$id_name}' type='hidden' value=''>&nbsp;
 758     <input title='{$app_strings['LBL_SELECT_BUTTON_TITLE']}'
 759         accessKey='{$app_strings['LBL_SELECT_BUTTON_KEY']}'
 760         type='button' class='button' value='{$app_strings['LBL_SELECT_BUTTON_LABEL']}' name='button'
 761         onclick='open_popup("$mod_type", 600, 400, "", true, false, {$encoded_popup_request_data});'
 762         />
 763 </td>
 764 <script type="text/javascript">
 765 <!--
 766 if(typeof sqs_objects == 'undefined'){
 767     var sqs_objects = new Array;
 768 }
 769 sqs_objects['MassUpdate_{$varname}'] = $qsName;
 770 registerSingleSmartInputListener(document.getElementById('mass_{$varname}'));
 771 addToValidateBinaryDependency('MassUpdate', '{$varname}', 'alpha', false, '{$app_strings['ERR_SQS_NO_MATCH_FIELD']} {$app_strings['LBL_ASSIGNED_TO']}','{$id_name}');
 772 -->
 773 </script>
 774 EOHTML;
 775         }
 776
 777
 778         /**
 779           * Add a generic module popup selection popup window HTML code.
 780           * Currently supports Contact and Releases
 781           * @param displayname Name to display in the popup window
 782           * @param varname name of the variable
 783           * @param id_name name of the id in vardef
 784           * @param mod_type name of the module, either "Contact" or "Releases" currently
 785           */
 786         function addGenericModuleID($displayname, $varname, $id_name='', $mod_type){
 787                 global $app_strings;
 788
 789                 if(empty($id_name))
 790                 $id_name = strtolower($mod_type)."_id";
 791
 792                 ///////////////////////////////////////
 793                 ///
 794                 /// SETUP POPUP
 795
 796                 $popup_request_data = array(
 797                         'call_back_function' => 'set_return',
 798                         'form_name' => 'MassUpdate',
 799                         'field_to_name_array' => array(
 800                                 'id' => "{$id_name}",
 801                                 'name' => "{$varname}",
 802                                 ),
 803                                 );
 804
 805                                 $json = getJSONobj();
 806                                 $encoded_popup_request_data = $json->encode($popup_request_data);
 807
 808                 $qsName = array(
 809                                     'form' => 'MassUpdate',
 810                                                 'method' => 'query',
 811                         'modules' => array("{$mod_type}"),
 812                         'group' => 'or',
 813                                                 'field_list' => array('name', 'id'),
 814                                                 'populate_list' => array("mass_{$varname}", "mass_{$id_name}"),
 815                                                 'conditions' => array(array('name'=>'name','op'=>'like_custom','end'=>'%','value'=>'')),
 816                                                 'limit' => '30','no_match_text' => $app_strings['ERR_SQS_NO_MATCH']);
 817                 $qsName = $json->encode($qsName);
 818                                 $img = SugarThemeRegistry::current()->getImageURL("id-ff-select.png");
 819                                 //
 820                                 ///////////////////////////////////////
 821
 822             return <<<EOHTML
 823 <td width='15%'  scope='row' class='dataLabel'>$displayname</td>
 824 <td width='35%' class='dataField'>
 825     <input name='{$varname}' id='mass_{$varname}' class='sqsEnabled' autocomplete='off' type='text' value=''>
 826     <input name='{$id_name}' id='mass_{$id_name}' type='hidden' value=''>
 827         <span class="id-ff multiple">
 828     <button title='{$app_strings['LBL_SELECT_BUTTON_TITLE']}'
 829         accessKey='{$app_strings['LBL_SELECT_BUTTON_KEY']}'
 830         type='button' class='button' value='{$app_strings['LBL_SELECT_BUTTON_LABEL']}' name='button'
 831         onclick='open_popup("$mod_type", 600, 400, "", true, false, {$encoded_popup_request_data});'
 832         /><img src="$img"></button></span>
 833 </td>
 834 <script type="text/javascript">
 835 <!--
 836 if(typeof sqs_objects == 'undefined'){
 837     var sqs_objects = new Array;
 838 }
 839 sqs_objects['MassUpdate_{$varname}'] = $qsName;
 840 registerSingleSmartInputListener(document.getElementById('mass_{$varname}'));
 841 addToValidateBinaryDependency('MassUpdate', '{$varname}', 'alpha', false, '{$app_strings['ERR_SQS_NO_MATCH_FIELD']} {$app_strings['LBL_ASSIGNED_TO']}','{$id_name}');
 842 -->
 843 </script>
 844 EOHTML;
 845         }
 846         /**
 847           * Add Account selection popup window HTML code
 848           * @param displayname Name to display in the popup window
 849           * @param varname name of the variable
 850           * @param id_name name of the id in vardef
 851           */
 852         function addAccountID($displayname, $varname, $id_name=''){
 853                 global $app_strings;
 854
 855                 $json = getJSONobj();
 856
 857                 if(empty($id_name))
 858                 $id_name = "account_id";
 859
 860                 ///////////////////////////////////////
 861                 ///
 862                 /// SETUP POPUP
 863
 864                 $popup_request_data = array(
 865                         'call_back_function' => 'set_return',
 866                         'form_name' => 'MassUpdate',
 867                         'field_to_name_array' => array(
 868                                 'id' => "{$id_name}",
 869                                 'name' => "{$varname}",
 870                                 ),
 871                                 );
 872
 873                                 $encoded_popup_request_data = $json->encode($popup_request_data);
 874
 875                                 //
 876                                 ///////////////////////////////////////
 877
 878                                 $qsParent = array(
 879                                                         'form' => 'MassUpdate',
 880                                                         'method' => 'query',
 881                                                         'modules' => array('Accounts'),
 882                                                         'group' => 'or',
 883                                                         'field_list' => array('name', 'id'),
 884                                                         'populate_list' => array('parent_name', 'parent_id'),
 885                                                         'conditions' => array(array('name'=>'name','op'=>'like_custom','end'=>'%','value'=>'')),
 886                                                         'order' => 'name',
 887                                                         'limit' => '30',
 888                                                         'no_match_text' => $app_strings['ERR_SQS_NO_MATCH']
 889                                                         );
 890                                                         $qsParent['populate_list'] = array('mass_'. $varname, 'mass_' . $id_name);
 891                                                         $img = SugarThemeRegistry::current()->getImageURL("id-ff-select.png");
 892                                                         $html = '<td scope="row">' . $displayname . " </td>\n"
 893                                                         . '<td><input class="sqsEnabled" type="text" autocomplete="off" id="mass_' . $varname .'" name="' . $varname . '" value="" /><input id="mass_' . $id_name . '" type="hidden" name="'
 894                                                         . $id_name . '" value="" />&nbsp;<span class="id-ff multiple"><button type="button" name="btn1" class="button" title="'
 895                                                         . $app_strings['LBL_SELECT_BUTTON_LABEL'] . '" accesskey="'
 896                                                         . $app_strings['LBL_SELECT_BUTTON_KEY'] . '" value="' . $app_strings['LBL_SELECT_BUTTON_LABEL'] . '" onclick='
 897                                                         . "'open_popup(\"Accounts\",600,400,\"\",true,false,{$encoded_popup_request_data});' /><img src=\"$img\"></button></span></td>\n";
 898                                                         $html .= '<script type="text/javascript" language="javascript">if(typeof sqs_objects == \'undefined\'){var sqs_objects = new Array;}sqs_objects[\'MassUpdate_' . $varname . '\'] = ' .
 899                                                         $json->encode($qsParent) . '; registerSingleSmartInputListener(document.getElementById(\'mass_' . $varname . '\'));
 900                                         addToValidateBinaryDependency(\'MassUpdate\', \''.$varname.'\', \'alpha\', false, \'' . $app_strings['ERR_SQS_NO_MATCH_FIELD'] . $app_strings['LBL_ACCOUNT'] . '\',\''.$id_name.'\');
 901                                         </script>';
 902
 903                                                         return $html;
 904         }
 905
 906         /**
 907           * Add AssignedUser popup window HTML code
 908           * @param displayname Name to display in the popup window
 909           * @param varname name of the variable
 910           */
 911         function addAssignedUserID($displayname, $varname){
 912                 global $app_strings;
 913
 914                 $json = getJSONobj();
 915
 916                 $popup_request_data = array(
 917                 'call_back_function' => 'set_return',
 918                 'form_name' => 'MassUpdate',
 919                 'field_to_name_array' => array(
 920                         'id' => 'assigned_user_id',
 921                         'user_name' => 'assigned_user_name',
 922                         ),
 923                         );
 924                         $encoded_popup_request_data = $json->encode($popup_request_data);
 925                         $qsUser = array(
 926                                     'form' => 'MassUpdate',
 927                                                 'method' => 'get_user_array', // special method
 928                                                 'field_list' => array('user_name', 'id'),
 929                                                 'populate_list' => array('assigned_user_name', 'assigned_user_id'),
 930                                                 'conditions' => array(array('name'=>'user_name','op'=>'like_custom','end'=>'%','value'=>'')),
 931                                                 'limit' => '30','no_match_text' => $app_strings['ERR_SQS_NO_MATCH']);
 932
 933                                                 $qsUser['populate_list'] = array('mass_assigned_user_name', 'mass_assigned_user_id');
 934                                                 $img = SugarThemeRegistry::current()->getImageURL("id-ff-select.png");
 935                                                 $html = <<<EOQ
 936                 <td width="15%" scope="row">$displayname</td>
 937                 <td ><input class="sqsEnabled" autocomplete="off" id="mass_assigned_user_name" name='assigned_user_name' type="text" value=""><input id='mass_assigned_user_id' name='assigned_user_id' type="hidden" value="" />
 938                 <span class="id-ff multiple"><button title="{$app_strings['LBL_SELECT_BUTTON_TITLE']}" accessKey="{$app_strings['LBL_SELECT_BUTTON_KEY']}" type="button" class="button" value='{$app_strings['LBL_SELECT_BUTTON_LABEL']}' name=btn1
 939                                 onclick='open_popup("Users", 600, 400, "", true, false, $encoded_popup_request_data);' /><img src="$img"></button></span>
 940                 </td>
 941 EOQ;
 942                                                 $html .= '<script type="text/javascript" language="javascript">if(typeof sqs_objects == \'undefined\'){var sqs_objects = new Array;}sqs_objects[\'MassUpdate_assigned_user_name\'] = ' .
 943                                                 $json->encode($qsUser) . '; registerSingleSmartInputListener(document.getElementById(\'mass_assigned_user_name\'));
 944                                 addToValidateBinaryDependency(\'MassUpdate\', \'assigned_user_name\', \'alpha\', false, \'' . $app_strings['ERR_SQS_NO_MATCH_FIELD'] . $app_strings['LBL_ASSIGNED_TO'] . '\',\'assigned_user_id\');
 945                                 </script>';
 946
 947                                                 return $html;
 948         }
 949         /**
 950           * Add Status selection popup window HTML code
 951           * @param displayname Name to display in the popup window
 952           * @param varname name of the variable
 953           * @param options array of options for status
 954           */
 955         function addStatus($displayname, $varname, $options){
 956                 global $app_strings, $app_list_strings;
 957
 958                 // cn: added "mass_" to the id tag to diffentieate from the status id in StoreQuery
 959                 $html = '<td scope="row" width="15%">'.$displayname.'</td><td>';
 960                 if(is_array($options)){
 961                         if(!isset($options['']) && !isset($options['0'])){
 962                            $new_options = array();
 963                            $new_options[''] = '';
 964                            foreach($options as $key=>$value) {
 965                                    $new_options[$key] = $value;
 966                            }
 967                            $options = $new_options;
 968                         }
 969                         $options = get_select_options_with_id_separate_key($options, $options, '', true);;
 970                         $html .= '<select id="mass_'.$varname.'" name="'.$varname.'">'.$options.'</select>';
 971                 }else{
 972                         $html .= $options;
 973                 }
 974                 $html .= '</td>';
 975                 return $html;
 976         }
 977
 978 /**
 979           * Add Status selection popup window HTML code
 980           * @param displayname Name to display in the popup window
 981           * @param varname name of the variable
 982           * @param options array of options for status
 983           */
 984         function addBool($displayname, $varname){
 985                 global $app_strings, $app_list_strings;
 986                 return $this->addStatus($displayname, $varname, $app_list_strings['checkbox_dom']);
 987         }
 988         function addStatusMulti($displayname, $varname, $options){
 989                 global $app_strings, $app_list_strings;
 990
 991                 if(!isset($options['']) && !isset($options['0'])){
 992                    $new_options = array();
 993                    $new_options[''] = '';
 994                    foreach($options as $key=>$value) {
 995                            $new_options[$key] = $value;
 996                    }
 997                    $options = $new_options;
 998                 }
 999                 $options = get_select_options_with_id_separate_key($options, $options, '', true);;
1000
1001                 // cn: added "mass_" to the id tag to diffentieate from the status id in StoreQuery
1002                 $html = '<td scope="row" width="15%">'.$displayname.'</td>
1003                          <td><select id="mass_'.$varname.'" name="'.$varname.'[]" size="5" MULTIPLE>'.$options.'</select></td>';
1004                 return $html;
1005         }
1006         /**
1007           * Add Date selection popup window HTML code
1008           * @param displayname Name to display in the popup window
1009           * @param varname name of the variable
1010           */
1011         function addDate($displayname, $varname){
1012                 global $timedate;
1013                 $userformat = '('. $timedate->get_user_date_format().')';
1014                 $cal_dateformat = $timedate->get_cal_date_format();
1015                 global $app_strings, $app_list_strings, $theme;
1016
1017                 $javascriptend = <<<EOQ
1018                  <script type="text/javascript">
1019                 Calendar.setup ({
1020                         inputField : "${varname}jscal_field", daFormat : "$cal_dateformat", ifFormat : "$cal_dateformat", showsTime : false, button : "${varname}jscal_trigger", singleClick : true, step : 1, weekNumbers:false
1021                 });
1022                 </script>
1023 EOQ;
1024         $jscalendarImage = SugarThemeRegistry::current()->getImageURL('jscalendar.gif');
1025                 $html = <<<EOQ
1026         <td scope="row" width="20%">$displayname</td>
1027         <td class='dataField' width="30%"><input onblur="parseDate(this, '$cal_dateformat')" type="text" name='$varname' size="12" id='{$varname}jscal_field' maxlength='10' value="">
1028     <img src="$jscalendarImage" id="{$varname}jscal_trigger" align="absmiddle" title="{$app_strings['LBL_MASSUPDATE_DATE']}" alt='{$app_strings['LBL_MASSUPDATE_DATE']}'>&nbsp;<span class="dateFormat">$userformat</span>
1029         $javascriptend</td>
1030         <script> addToValidate('MassUpdate','$varname','date',false,'$displayname');</script>
1031 EOQ;
1032                 return $html;
1033
1034         }
1035
1036         function addRadioenumItem($name, $value, $output) {
1037                 $_output = '';
1038                 $_output .= '<label>';
1039                 $_output .= '<input type="radio" name="'
1040                 . $name . '" value="'
1041                 . $value. '"';
1042
1043             $_output .= ' />' . ($output == '' ? $GLOBALS['app_strings']['LBL_LINK_NONE'] : $output);
1044             $_output .= '</label><br />';
1045             return $_output;
1046         }
1047
1048         function addRadioenum($displayname, $varname, $options){
1049                  foreach ($options as $_key=>$_val){
1050             $_html_result[] = $this->addRadioenumItem($varname, $_key, $_val);
1051         }
1052
1053                 $html = '<td scope="row" width="15%">'.$displayname.'</td>
1054                          <td>'.implode("\n",$_html_result).'</td>';
1055                 return $html;
1056         }
1057         /**
1058           * Add Datetime selection popup window HTML code
1059           * @param displayname Name to display in the popup window
1060           * @param varname name of the variable
1061           */
1062         function addDatetime($displayname, $varname){
1063                 global $timedate;
1064                 $userformat = $timedate->get_user_time_format();
1065                 $cal_dateformat = $timedate->get_cal_date_format();
1066                 global $app_strings, $app_list_strings, $theme;
1067                 $jscalendarImage = SugarThemeRegistry::current()->getImageURL('jscalendar.gif');
1068
1069                 $javascriptend = <<<EOQ
1070                  <script type="text/javascript">
1071                 Calendar.setup ({
1072                         inputField : "{$varname}_date",
1073                         daFormat : "$cal_dateformat",
1074                         ifFormat : "$cal_dateformat",
1075                         showsTime : false,
1076                         button : "{$varname}_trigger",
1077                         singleClick : true,
1078                         step : 1,
1079                         weekNumbers:false
1080                 });
1081                 </script>
1082 EOQ;
1083
1084                 $html = <<<EOQ
1085                 <td scope="row" width="20%">$displayname</td>
1086                 <td class='dataField' width="30%"><input onblur="parseDate(this, '$cal_dateformat')" type="text" name='$varname' size="12" id='{$varname}_date' maxlength='10' value="">
1087                 <img border="0" src="$jscalendarImage" alt='{$app_strings['LBL_MASSUPDATE_DATE']}' id="{$varname}_trigger" title="{$app_strings['LBL_MASSUPDATE_DATE']}"  align="absmiddle">&nbsp;$javascriptend
1088
1089                 <span id="{$varname}_time_section"></span>
1090                 </td>
1091                 <input type="hidden" id="{$varname}" name="{$varname}">
1092                 <script type="text/javascript" src="include/SugarFields/Fields/Datetimecombo/Datetimecombo.js"></script>
1093                 <script type="text/javascript">
1094                 var combo_{$varname} = new Datetimecombo(" ", "$varname", "$userformat", '','','',1);
1095                 //Render the remaining widget fields
1096                 text = combo_{$varname}.html('');
1097                 document.getElementById('{$varname}_time_section').innerHTML = text;
1098
1099                 //Call eval on the update function to handle updates to calendar picker object
1100                 eval(combo_{$varname}.jsscript(''));
1101
1102                 function update_{$varname}_available() {
1103                       YAHOO.util.Event.onAvailable("{$varname}_date", this.handleOnAvailable, this);
1104                 }
1105
1106                 update_{$varname}_available.prototype.handleOnAvailable = function(me) {
1107                         Calendar.setup ({
1108                         onClose : update_{$varname},
1109                         inputField : "{$varname}_date",
1110                         daFormat : "$cal_dateformat",
1111                         ifFormat : "$cal_dateformat",
1112                         button : "{$varname}_trigger",
1113                         singleClick : true,
1114                         step : 1,
1115                         weekNumbers:false
1116                         });
1117
1118                         //Call update for first time to round hours and minute values
1119                         combo_{$varname}.update();
1120                 }
1121
1122                 var obj_{$varname} = new update_{$varname}_available();
1123                 </script>
1124
1125                 <script> addToValidate('MassUpdate','{$varname}_date','date',false,'$displayname');
1126                 addToValidateBinaryDependency('MassUpdate', '{$varname}_hours', 'alpha', false, "{$app_strings['ERR_MISSING_REQUIRED_FIELDS']}", '{$varname}_date');
1127                 addToValidateBinaryDependency('MassUpdate', '{$varname}_minutes', 'alpha', false, "{$app_strings['ERR_MISSING_REQUIRED_FIELDS']}", '{$varname}_date');
1128                 addToValidateBinaryDependency('MassUpdate', '{$varname}_meridiem', 'alpha', false, "{$app_strings['ERR_MISSING_REQUIRED_FIELDS']}", '{$varname}_date');
1129                 </script>
1130
1131 EOQ;
1132                 return $html;
1133         }
1134
1135         function date_to_dateTime($field, $value) {
1136                 global $timedate;
1137             //Check if none was set
1138         if (isset($this->sugarbean->field_defs[$field]['group'])) {
1139             $group =  $this->sugarbean->field_defs[$field]['group'];
1140             if (isset($this->sugarbean->field_defs[$group."_flag"]) && isset($_POST[$group."_flag"])
1141                 && $_POST[$group."_flag"] == 1) {
1142                 return "";
1143             }
1144         }
1145
1146         $oldDateTime = $this->sugarbean->$field;
1147         $oldTime = explode(" ", $oldDateTime);
1148         if (isset($oldTime[1])) {
1149                 $oldTime = $oldTime[1];
1150         } else {
1151                 $oldTime = $timedate->to_display_time($timedate->get_gmt_db_datetime());
1152         }
1153         $value = explode(" ", $value);
1154         $value = $value[0];
1155             return $value." ".$oldTime;
1156         }
1157
1158         function checkClearField($field, $value) {
1159             if ($value == 1 && strpos($field, '_flag')) {
1160                 $fName = substr($field, -5);
1161             if (isset($this->sugarbean->field_defs[$field]['group'])) {
1162                 $group =  $this->sugarbean->field_defs[$field]['group'];
1163                 if (isset($this->sugarbean->field_defs[$group])) {
1164                     $_POST[$group] = "";
1165                 }
1166             }
1167             }
1168         }
1169
1170     function generateSearchWhere($module, $query) {//this function is similar with function prepareSearchForm() in view.list.php
1171         $seed = loadBean($module);
1172         $this->use_old_search = true;
1173         if(file_exists('modules/'.$module.'/SearchForm.html')){
1174             if(file_exists('modules/' . $module . '/metadata/SearchFields.php')) {
1175                 require_once('include/SearchForm/SearchForm.php');
1176                 $searchForm = new SearchForm($module, $seed);
1177             }
1178             elseif(!empty($_SESSION['export_where'])) { //bug 26026, sometimes some module doesn't have a metadata/SearchFields.php, the searchfrom is generated in the ListView.php.
1179             //So currently massupdate will not gernerate the where sql. It will use the sql stored in the SESSION. But this will cause bug 24722, and it cannot be avoided now.
1180                 $where = $_SESSION['export_where'];
1181                 $whereArr = explode (" ", trim($where));
1182                 if ($whereArr[0] == trim('where')) {
1183                     $whereClean = array_shift($whereArr);
1184                 }
1185                 $this->where_clauses = implode(" ", $whereArr);
1186                 return;
1187             }
1188             else {
1189                 $this->where_clauses = '';
1190                 return;
1191             }
1192         }
1193         else{
1194             $this->use_old_search = false;
1195             require_once('include/SearchForm/SearchForm2.php');
1196
1197             if(file_exists('custom/modules/'.$module.'/metadata/metafiles.php')){
1198                 require('custom/modules/'.$module.'/metadata/metafiles.php');
1199             }elseif(file_exists('modules/'.$module.'/metadata/metafiles.php')){
1200                 require('modules/'.$module.'/metadata/metafiles.php');
1201             }
1202
1203             if (file_exists('custom/modules/'.$module.'/metadata/searchdefs.php'))
1204             {
1205                 require_once('custom/modules/'.$module.'/metadata/searchdefs.php');
1206             }
1207             elseif (!empty($metafiles[$module]['searchdefs']))
1208             {
1209                 require_once($metafiles[$module]['searchdefs']);
1210             }
1211             elseif (file_exists('modules/'.$module.'/metadata/searchdefs.php'))
1212             {
1213                 require_once('modules/'.$module.'/metadata/searchdefs.php');
1214             }
1215
1216
1217             if(!empty($metafiles[$module]['searchfields']))
1218                 require_once($metafiles[$module]['searchfields']);
1219             elseif(file_exists('modules/'.$module.'/metadata/SearchFields.php'))
1220                 require_once('modules/'.$module.'/metadata/SearchFields.php');
1221             if(empty($searchdefs) || empty($searchFields)) {
1222                $this->where_clauses = ''; //for some modules, such as iframe, it has massupdate, but it doesn't have search function, the where sql should be empty.
1223                return;
1224             }
1225             $searchForm = new SearchForm($seed, $module);
1226             $searchForm->setup($searchdefs, $searchFields, 'include/SearchForm/tpls/SearchFormGeneric.tpl');
1227         }
1228         $searchForm->populateFromArray(unserialize(base64_decode($query)));
1229         $this->searchFields = $searchForm->searchFields;
1230         $where_clauses = $searchForm->generateSearchWhere(true, $module);
1231         if (count($where_clauses) > 0 ) {
1232             $this->where_clauses = '('. implode(' ) AND ( ', $where_clauses) . ')';
1233             $GLOBALS['log']->info("MassUpdate Where Clause: {$this->where_clauses}");
1234         }
1235     }
1236
1237     /**
1238      * This is kinda a hack how it is implimented, but will tell us whether or not a focus has
1239      * fields for Mass Update
1240      *
1241      * @return bool
1242      */
1243     public function doMassUpdateFieldsExistForFocus()
1244     {
1245         static $banned = array('date_modified'=>1, 'date_entered'=>1, 'created_by'=>1, 'modified_user_id'=>1, 'deleted'=>1,'modified_by_name'=>1,);
1246         foreach($this->sugarbean->field_defs as $field) {
1247             if(!isset($banned[$field['name']]) && (!isset($field['massupdate']) || !empty($field['massupdate']))){
1248                 if(isset($field['type']) && $field['type'] == 'relate' && isset($field['id_name']) && $field['id_name'] == 'assigned_user_id')
1249                     $field['type'] = 'assigned_user_name';
1250                 if(isset($field['custom_type']))$field['type'] = $field['custom_type'];
1251                 if(isset($field['type']))
1252                 {
1253                     switch($field["type"]){
1254                     case "relate":
1255                     case "parent":
1256                     case "int":
1257                     case "contact_id":
1258                     case "assigned_user_name":
1259                     case "account_id":
1260                     case "account_name":
1261                     case "bool":
1262                     case "enum":
1263                     case "multienum":
1264                     case "radioenum":
1265                     case "datetimecombo":
1266                     case "datetime":
1267                     case "date":
1268                         return true;
1269                         break;
1270                     }
1271                 }
1272             }
1273         }
1274
1275         return false;
1276     }
1277 }
1278
1279 ?>