include/export_utils.php

   1 <?php
   2 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
   3 /*********************************************************************************
   4  * SugarCRM Community Edition is a customer relationship management program developed by
   5  * SugarCRM, Inc. Copyright (C) 2004-2013 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  * Description:
  41  * Portions created by SugarCRM are Copyright (C) SugarCRM, Inc. All Rights
  42  * Reserved. Contributor(s): ______________________________________..
  43  * *******************************************************************************/
  44
  45 /**
  46  * gets the system default delimiter or an user-preference based override
  47  * @return string the delimiter
  48  */
  49 function getDelimiter() {
  50     global $sugar_config;
  51     global $current_user;
  52
  53     $delimiter = ','; // default to "comma"
  54     $userDelimiter = $current_user->getPreference('export_delimiter');
  55     $delimiter = empty($sugar_config['export_delimiter']) ? $delimiter : $sugar_config['export_delimiter'];
  56     $delimiter = empty($userDelimiter) ? $delimiter : $userDelimiter;
  57
  58     return $delimiter;
  59 }
  60
  61
  62 /**
  63  * builds up a delimited string for export
  64  * @param string type the bean-type to export
  65  * @param array records an array of records if coming directly from a query
  66  * @return string delimited string for export
  67  */
  68 function export($type, $records = null, $members = false, $sample=false) {
  69     global $locale;
  70     global $beanList;
  71     global $beanFiles;
  72     global $current_user;
  73     global $app_strings;
  74     global $app_list_strings;
  75     global $timedate;
  76     global $mod_strings;
  77     global $current_language;
  78     $sampleRecordNum = 5;
  79     $contact_fields = array(
  80         "id"=>"Contact ID"
  81         ,"lead_source"=>"Lead Source"
  82         ,"date_entered"=>"Date Entered"
  83         ,"date_modified"=>"Date Modified"
  84         ,"first_name"=>"First Name"
  85         ,"last_name"=>"Last Name"
  86         ,"salutation"=>"Salutation"
  87         ,"birthdate"=>"Lead Source"
  88         ,"do_not_call"=>"Do Not Call"
  89         ,"email_opt_out"=>"Email Opt Out"
  90         ,"title"=>"Title"
  91         ,"department"=>"Department"
  92         ,"birthdate"=>"Birthdate"
  93         ,"do_not_call"=>"Do Not Call"
  94         ,"phone_home"=>"Phone (Home)"
  95         ,"phone_mobile"=>"Phone (Mobile)"
  96         ,"phone_work"=>"Phone (Work)"
  97         ,"phone_other"=>"Phone (Other)"
  98         ,"phone_fax"=>"Fax"
  99         ,"email1"=>"Email"
 100         ,"email2"=>"Email (Other)"
 101         ,"assistant"=>"Assistant"
 102         ,"assistant_phone"=>"Assistant Phone"
 103         ,"primary_address_street"=>"Primary Address Street"
 104         ,"primary_address_city"=>"Primary Address City"
 105         ,"primary_address_state"=>"Primary Address State"
 106         ,"primary_address_postalcode"=>"Primary Address Postalcode"
 107         ,"primary_address_country"=>"Primary Address Country"
 108         ,"alt_address_street"=>"Other Address Street"
 109         ,"alt_address_city"=>"Other Address City"
 110         ,"alt_address_state"=>"Other Address State"
 111         ,"alt_address_postalcode"=>"Other Address Postalcode"
 112         ,"alt_address_country"=>"Other Address Country"
 113         ,"description"=>"Description"
 114     );
 115
 116     $account_fields = array(
 117         "id"=>"Account ID",
 118         "name"=>"Account Name",
 119         "website"=>"Website",
 120         "industry"=>"Industry",
 121         "account_type"=>"Type",
 122         "ticker_symbol"=>"Ticker Symbol",
 123         "employees"=>"Employees",
 124         "ownership"=>"Ownership",
 125         "phone_office"=>"Phone",
 126         "phone_fax"=>"Fax",
 127         "phone_alternate"=>"Other Phone",
 128         "email1"=>"Email",
 129         "email2"=>"Other Email",
 130         "rating"=>"Rating",
 131         "sic_code"=>"SIC Code",
 132         "annual_revenue"=>"Annual Revenue",
 133         "billing_address_street"=>"Billing Address Street",
 134         "billing_address_city"=>"Billing Address City",
 135         "billing_address_state"=>"Billing Address State",
 136         "billing_address_postalcode"=>"Billing Address Postalcode",
 137         "billing_address_country"=>"Billing Address Country",
 138         "shipping_address_street"=>"Shipping Address Street",
 139         "shipping_address_city"=>"Shipping Address City",
 140         "shipping_address_state"=>"Shipping Address State",
 141         "shipping_address_postalcode"=>"Shipping Address Postalcode",
 142         "shipping_address_country"=>"Shipping Address Country",
 143         "description"=>"Description"
 144     );
 145     //Array of fields that should not be exported, and are only used for logic
 146     $remove_from_members = array("ea_deleted", "ear_deleted", "primary_address");
 147     $focus = 0;
 148
 149     $bean = $beanList[$type];
 150     require_once($beanFiles[$bean]);
 151     $focus = new $bean;
 152     $searchFields = array();
 153     $db = DBManagerFactory::getInstance();
 154
 155     if($records) {
 156         $records = explode(',', $records);
 157         $records = "'" . implode("','", $records) . "'";
 158         $where = "{$focus->table_name}.id in ($records)";
 159     } elseif (isset($_REQUEST['all']) ) {
 160         $where = '';
 161     } else {
 162         if(!empty($_REQUEST['current_post'])) {
 163             $ret_array = generateSearchWhere($type, $_REQUEST['current_post']);
 164
 165             $where = $ret_array['where'];
 166             $searchFields = $ret_array['searchFields'];
 167         } else {
 168             $where = '';
 169         }
 170     }
 171     $order_by = "";
 172     if($focus->bean_implements('ACL')){
 173         if(!ACLController::checkAccess($focus->module_dir, 'export', true)){
 174             ACLController::displayNoAccess();
 175             sugar_die('');
 176         }
 177         if(ACLController::requireOwner($focus->module_dir, 'export')){
 178             if(!empty($where)){
 179                 $where .= ' AND ';
 180             }
 181             $where .= $focus->getOwnerWhere($current_user->id);
 182         }
 183
 184     }
 185     // Export entire list was broken because the where clause already has "where" in it
 186     // and when the query is built, it has a "where" as well, so the query was ill-formed.
 187     // Eliminating the "where" here so that the query can be constructed correctly.
 188     if($members == true){
 189            $query = $focus->create_export_members_query($records);
 190     }else{
 191         $beginWhere = substr(trim($where), 0, 5);
 192         if ($beginWhere == "where")
 193             $where = substr(trim($where), 5, strlen($where));
 194         $ret_array = create_export_query_relate_link_patch($type, $searchFields, $where);
 195         if(!empty($ret_array['join'])) {
 196             $query = $focus->create_export_query($order_by,$ret_array['where'],$ret_array['join']);
 197         } else {
 198             $query = $focus->create_export_query($order_by,$ret_array['where']);
 199         }
 200     }
 201
 202     $result = '';
 203     $populate = false;
 204     if($sample) {
 205        $result = $db->limitQuery($query, 0, $sampleRecordNum, true, $app_strings['ERR_EXPORT_TYPE'].$type.": <BR>.".$query);
 206         if( $focus->_get_num_rows_in_query($query)<1 ){
 207             $populate = true;
 208         }
 209     }
 210     else {
 211         $result = $db->query($query, true, $app_strings['ERR_EXPORT_TYPE'].$type.": <BR>.".$query);
 212     }
 213
 214
 215     $fields_array = $db->getFieldsArray($result,true);
 216
 217     //set up the order on the header row
 218     $fields_array = get_field_order_mapping($focus->module_dir, $fields_array);
 219
 220
 221
 222     //set up labels to be used for the header row
 223     $field_labels = array();
 224     foreach($fields_array as $key=>$dbname){
 225         //Remove fields that are only used for logic
 226         if($members && (in_array($dbname, $remove_from_members)))
 227             continue;
 228
 229         //default to the db name of label does not exist
 230         $field_labels[$key] = translateForExport($dbname,$focus);
 231     }
 232
 233     $user_agent = isset($_SERVER['HTTP_USER_AGENT']) ? $_SERVER['HTTP_USER_AGENT'] : '';
 234     if ($locale->getExportCharset() == 'UTF-8' &&
 235         ! preg_match('/macintosh|mac os x|mac_powerpc/i', $user_agent)) // Bug 60377 - Mac Excel doesn't support UTF-8
 236     {
 237         //Bug 55520 - add BOM to the exporting CSV so any symbols are displayed correctly in Excel
 238         $BOM = "\xEF\xBB\xBF";
 239         $content = $BOM;
 240     }
 241     else
 242     {
 243         $content = '';
 244     }
 245
 246     // setup the "header" line with proper delimiters
 247     $content .= "\"".implode("\"".getDelimiter()."\"", array_values($field_labels))."\"\r\n";
 248     $pre_id = '';
 249
 250     if($populate){
 251         //this is a sample request with no data, so create fake datarows
 252          $content .= returnFakeDataRow($focus,$fields_array,$sampleRecordNum);
 253     }else{
 254         $records = array();
 255
 256         //process retrieved record
 257         while($val = $db->fetchByAssoc($result, false)) {
 258
 259             //order the values in the record array
 260             $val = get_field_order_mapping($focus->module_dir,$val);
 261
 262             $new_arr = array();
 263                 if($members){
 264                         if($pre_id == $val['id'])
 265                                 continue;
 266                         if($val['ea_deleted']==1 || $val['ear_deleted']==1){
 267                                 $val['primary_email_address'] = '';
 268                         }
 269                         unset($val['ea_deleted']);
 270                         unset($val['ear_deleted']);
 271                         unset($val['primary_address']);
 272                 }
 273                 $pre_id = $val['id'];
 274
 275                 foreach ($val as $key => $value)
 276                 {
 277             //getting content values depending on their types
 278             $fieldNameMapKey = $fields_array[$key];
 279
 280             if (isset($focus->field_name_map[$fieldNameMapKey])  && $focus->field_name_map[$fieldNameMapKey]['type'])
 281             {
 282                 $fieldType = $focus->field_name_map[$fieldNameMapKey]['type'];
 283                 switch ($fieldType)
 284                 {
 285                     //if our value is a currency field, then apply the users locale
 286                     case 'currency':
 287                         require_once('modules/Currencies/Currency.php');
 288                         $value = currency_format_number($value);
 289                         break;
 290
 291                     //if our value is a datetime field, then apply the users locale
 292                     case 'datetime':
 293                     case 'datetimecombo':
 294                         $value = $timedate->to_display_date_time($db->fromConvert($value, 'datetime'));
 295                         $value = preg_replace('/([pm|PM|am|AM]+)/', ' \1', $value);
 296                         break;
 297
 298                     //kbrill Bug #16296
 299                     case 'date':
 300                         $value = $timedate->to_display_date($db->fromConvert($value, 'date'), false);
 301                         break;
 302
 303                     // Bug 32463 - Properly have multienum field translated into something useful for the client
 304                     case 'multienum':
 305                         $value = str_replace("^","",$value);
 306                         if (isset($focus->field_name_map[$fields_array[$key]]['options']) && isset($app_list_strings[$focus->field_name_map[$fields_array[$key]]['options']]) )
 307                         {
 308                             $valueArray = explode(",",$value);
 309                             foreach ($valueArray as $multikey => $multivalue )
 310                             {
 311                                 if (isset($app_list_strings[$focus->field_name_map[$fields_array[$key]]['options']][$multivalue]) )
 312                                 {
 313                                     $valueArray[$multikey] = $app_list_strings[$focus->field_name_map[$fields_array[$key]]['options']][$multivalue];
 314                                 }
 315                             }
 316                             $value = implode(",",$valueArray);
 317                         }
 318                         break;
 319                 }
 320             }
 321
 322
 323             // Keep as $key => $value for post-processing
 324             $new_arr[$key] = preg_replace("/\"/","\"\"", $value);
 325         }
 326
 327         // Use Bean ID as key for records
 328         $records[$pre_id] = $new_arr;
 329     }
 330
 331         // Check if we're going to export non-primary emails
 332         if ($focus->hasEmails() && in_array('email_addresses_non_primary', $fields_array))
 333         {
 334             // $records keys are bean ids
 335             $keys = array_keys($records);
 336
 337             // Split the ids array into chunks of size 100
 338             $chunks = array_chunk($keys, 100);
 339
 340             foreach ($chunks as $chunk)
 341             {
 342                 // Pick all the non-primary mails for the chunk
 343                 $query =
 344                     "
 345                       SELECT eabr.bean_id, ea.email_address
 346                       FROM email_addr_bean_rel eabr
 347                       LEFT JOIN email_addresses ea ON ea.id = eabr.email_address_id
 348                       WHERE eabr.bean_module = '{$focus->module_dir}'
 349                       AND eabr.primary_address = '0'
 350                       AND eabr.bean_id IN ('" . implode("', '", $chunk) . "')
 351                       AND eabr.deleted != '1'
 352                       ORDER BY eabr.bean_id, eabr.reply_to_address, eabr.primary_address DESC
 353                     ";
 354
 355                 $result = $db->query($query, true, $app_strings['ERR_EXPORT_TYPE'] . $type . ": <BR>." . $query);
 356
 357                 while ($val = $db->fetchByAssoc($result, false)) {
 358                     if (empty($records[$val['bean_id']]['email_addresses_non_primary'])) {
 359                         $records[$val['bean_id']]['email_addresses_non_primary'] = $val['email_address'];
 360                     } else {
 361                         // No custom non-primary mail delimeter yet, use semi-colon
 362                         $records[$val['bean_id']]['email_addresses_non_primary'] .= ';' . $val['email_address'];
 363                     }
 364                 }
 365             }
 366         }
 367
 368         foreach($records as $record)
 369         {
 370             $line = implode("\"" . getDelimiter() . "\"", $record);
 371             $line = "\"" . $line;
 372             $line .= "\"\r\n";
 373             $content .= $line;
 374         }
 375
 376     }
 377
 378         return $content;
 379
 380 }
 381
 382
 383 function generateSearchWhere($module, $query) {//this function is similar with function prepareSearchForm() in view.list.php
 384     $seed = loadBean($module);
 385     if(file_exists('modules/'.$module.'/SearchForm.html')){
 386         if(file_exists('modules/' . $module . '/metadata/SearchFields.php')) {
 387             require_once('include/SearchForm/SearchForm.php');
 388             $searchForm = new SearchForm($module, $seed);
 389         }
 390         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.
 391         // Currently, massupdate will not generate the where sql. It will use the sql stored in the SESSION. But this will cause bug 24722, and it cannot be avoided now.
 392             $where = $_SESSION['export_where'];
 393             $whereArr = explode (" ", trim($where));
 394             if ($whereArr[0] == trim('where')) {
 395                 $whereClean = array_shift($whereArr);
 396             }
 397             $where = implode(" ", $whereArr);
 398             //rrs bug: 31329 - previously this was just returning $where, but the problem is the caller of this function
 399             //expects the results in an array, not just a string. So rather than fixing the caller, I felt it would be best for
 400             //the function to return the results in a standard format.
 401             $ret_array['where'] = $where;
 402             $ret_array['searchFields'] =array();
 403             return $ret_array;
 404         }
 405         else {
 406             return;
 407         }
 408     }
 409     else{
 410         require_once('include/SearchForm/SearchForm2.php');
 411
 412         if(file_exists('custom/modules/'.$module.'/metadata/metafiles.php')){
 413             require('custom/modules/'.$module.'/metadata/metafiles.php');
 414         }elseif(file_exists('modules/'.$module.'/metadata/metafiles.php')){
 415             require('modules/'.$module.'/metadata/metafiles.php');
 416         }
 417
 418         if (file_exists('custom/modules/'.$module.'/metadata/searchdefs.php'))
 419         {
 420             require_once('custom/modules/'.$module.'/metadata/searchdefs.php');
 421         }
 422         elseif (!empty($metafiles[$module]['searchdefs']))
 423         {
 424             require_once($metafiles[$module]['searchdefs']);
 425         }
 426         elseif (file_exists('modules/'.$module.'/metadata/searchdefs.php'))
 427         {
 428             require_once('modules/'.$module.'/metadata/searchdefs.php');
 429         }
 430
 431         //fixing bug #48483: Date Range search on custom date field then export ignores range filter
 432         // first of all custom folder should be checked
 433         if(file_exists('custom/modules/'.$module.'/metadata/SearchFields.php'))
 434         {
 435             require_once('custom/modules/'.$module.'/metadata/SearchFields.php');
 436         }
 437         elseif(!empty($metafiles[$module]['searchfields']))
 438         {
 439             require_once($metafiles[$module]['searchfields']);
 440         }
 441         elseif(file_exists('modules/'.$module.'/metadata/SearchFields.php'))
 442         {
 443             require_once('modules/'.$module.'/metadata/SearchFields.php');
 444         }
 445         if(empty($searchdefs) || empty($searchFields)) {
 446            //for some modules, such as iframe, it has massupdate, but it doesn't have search function, the where sql should be empty.
 447             return;
 448         }
 449         $searchForm = new SearchForm($seed, $module);
 450         $searchForm->setup($searchdefs, $searchFields, 'SearchFormGeneric.tpl');
 451     }
 452     $searchForm->populateFromArray(unserialize(base64_decode($query)));
 453     $where_clauses = $searchForm->generateSearchWhere(true, $module);
 454     if (count($where_clauses) > 0 )$where = '('. implode(' ) AND ( ', $where_clauses) . ')';
 455         $GLOBALS['log']->info("Export Where Clause: {$where}");
 456     $ret_array['where'] = $where;
 457     $ret_array['searchFields'] = $searchForm->searchFields;
 458     return $ret_array;
 459 }
 460 /**
 461   * calls export method to build up a delimited string and some sample instructional text on how to use this file
 462   * @param string type the bean-type to export
 463   * @return string delimited string for export with some tutorial text
 464   */
 465      function exportSample($type) {
 466          global $app_strings;
 467
 468          //first grab the
 469          $_REQUEST['all']=true;
 470
 471          //retrieve the export content
 472          $content = export($type, null, false, true);
 473
 474          // Add a new row and add details on removing the sample data
 475          // Our Importer will stop after he gets to the new row, ignoring the text below
 476          return $content . "\n" . $app_strings['LBL_IMPORT_SAMPLE_FILE_TEXT'];
 477
 478      }
 479  //this function will take in the bean and field mapping and return a proper value
 480  function returnFakeDataRow($focus,$field_array,$rowsToReturn = 5){
 481
 482     if(empty($focus) || empty($field_array))
 483      return ;
 484
 485      //include the file that defines $sugar_demodata
 486      include('install/demoData.en_us.php');
 487
 488     $person_bean = false;
 489     if( isset($focus->first_name)){
 490         $person_bean = true;
 491     }
 492
 493      global $timedate;
 494      $returnContent = '';
 495      $counter = 0;
 496      $new_arr = array();
 497
 498      //iterate through the record creation process as many times as defined.  Each iteration will create a new row
 499      while($counter < $rowsToReturn){
 500          $counter++;
 501          //go through each field and populate with dummy data if possible
 502          foreach($field_array as $field_name){
 503
 504             if(empty($focus->field_name_map[$field_name]) || empty($focus->field_name_map[$field_name]['type'])){
 505                 //type is not set, fill in with empty string and continue;
 506                 $returnContent .= '"",';
 507                 continue;
 508             }
 509             $field = $focus->field_name_map[$field_name];
 510                          //fill in value according to type
 511             $type = $field['type'];
 512
 513              switch ($type) {
 514
 515                  case "id":
 516                  case "assigned_user_name":
 517                      //return new guid string
 518                     $returnContent .= '"'.create_guid().'",';
 519                      break;
 520                  case "int":
 521                      //return random number`
 522                     $returnContent .= '"'.mt_rand(0,4).'",';
 523                      break;
 524                  case "name":
 525                      //return first, last, user name, or random name string
 526                      if($field['name'] == 'first_name'){
 527                          $count = count($sugar_demodata['first_name_array']) - 1;
 528                         $returnContent .= '"'.$sugar_demodata['last_name_array'][mt_rand(0,$count)].'",';
 529                      }elseif($field['name'] == 'last_name'){
 530                          $count = count($sugar_demodata['last_name_array']) - 1;
 531                          $returnContent .= '"'.$sugar_demodata['last_name_array'][mt_rand(0,$count)].'",';
 532                      }elseif($field['name'] == 'user_name'){
 533                        $count = count($sugar_demodata['first_name_array']) - 1;
 534                         $returnContent .= '"'.$sugar_demodata['last_name_array'][mt_rand(0,$count)].'_'.mt_rand(1,111).'",';
 535                      }else{
 536                          //return based on bean
 537                          if($focus->module_dir =='Accounts'){
 538                              $count = count($sugar_demodata['company_name_array']) - 1;
 539                             $returnContent .= '"'.$sugar_demodata['company_name_array'][mt_rand(0,$count)].'",';
 540
 541                          }elseif($focus->module_dir =='Bugs'){
 542                              $count = count($sugar_demodata['bug_seed_names']) - 1;
 543                             $returnContent .= '"'.$sugar_demodata['bug_seed_names'][mt_rand(0,$count)].'",';
 544                          }elseif($focus->module_dir =='Notes'){
 545                              $count = count($sugar_demodata['note_seed_names_and_Descriptions']) - 1;
 546                             $returnContent .= '"'.$sugar_demodata['note_seed_names_and_Descriptions'][mt_rand(0,$count)].'",';
 547
 548                          }elseif($focus->module_dir =='Calls'){
 549                               $count = count($sugar_demodata['call_seed_data_names']) - 1;
 550                             $returnContent .= '"'.$sugar_demodata['call_seed_data_names'][mt_rand(0,$count)].'",';
 551
 552                          }elseif($focus->module_dir =='Tasks'){
 553                              $count = count($sugar_demodata['task_seed_data_names']) - 1;
 554                            $returnContent .= '"'.$sugar_demodata['task_seed_data_names'][mt_rand(0,$count)].'",';
 555
 556                          }elseif($focus->module_dir =='Meetings'){
 557                              $count = count($sugar_demodata['meeting_seed_data_names']) - 1;
 558                            $returnContent .= '"'.$sugar_demodata['meeting_seed_data_names'][mt_rand(0,$count)].'",';
 559
 560                          }elseif($focus->module_dir =='ProductCategories'){
 561                              $count = count($sugar_demodata['productcategory_seed_data_names']) - 1;
 562                            $returnContent .= '"'.$sugar_demodata['productcategory_seed_data_names'][mt_rand(0,$count)].'",';
 563
 564
 565                          }elseif($focus->module_dir =='ProductTypes'){
 566                              $count = count($sugar_demodata['producttype_seed_data_names']) - 1;
 567                            $returnContent .= '"'.$sugar_demodata['producttype_seed_data_names'][mt_rand(0,$count)].'",';
 568
 569
 570                          }elseif($focus->module_dir =='ProductTemplates'){
 571                              $count = count($sugar_demodata['producttemplate_seed_data']) - 1;
 572                            $returnContent .= '"'.$sugar_demodata['producttemplate_seed_data'][mt_rand(0,$count)].'",';
 573
 574                          }else{
 575                            $returnContent .= '"Default Name for '.$focus->module_dir.'",';
 576
 577                          }
 578
 579                      }
 580                     break;
 581                  case "relate":
 582                      if($field['name'] == 'team_name'){
 583                          //apply team names and user_name
 584                          $teams_count = count($sugar_demodata['teams']) - 1;
 585                          $users_count = count($sugar_demodata['users']) - 1;
 586
 587                      $returnContent .= '"'.$sugar_demodata['teams'][mt_rand(0,$teams_count)]['name'].','.$sugar_demodata['users'][mt_rand(0,$users_count)]['user_name'].'",';
 588
 589                      }else{
 590                          //apply GUID
 591                          $returnContent .= '"'.create_guid().'",';
 592                      }
 593                      break;
 594                  case "bool":
 595                      //return 0 or 1
 596                      $returnContent .= '"'.mt_rand(0,1).'",';
 597                      break;
 598
 599                  case "text":
 600                      //return random text
 601                      $returnContent .= '"Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Maecenas porttitor congue massa. Fusce posuere, magna sed pulvinar ultricies, purus lectus malesuada libero, sit amet commodo magna eros quis urna",';
 602                      break;
 603
 604                  case "team_list":
 605                      $teams_count = count($sugar_demodata['teams']) - 1;
 606                      //give fake team names (East,West,North,South)
 607                      $returnContent .= '"'.$sugar_demodata['teams'][mt_rand(0,$teams_count)]['name'].'",';
 608                      break;
 609
 610                  case "date":
 611                      //return formatted date
 612                      $timeStamp = strtotime('now');
 613                      $value =    date($timedate->dbDayFormat, $timeStamp);
 614                      $returnContent .= '"'.$timedate->to_display_date_time($value).'",';
 615                      break;
 616
 617                  case "datetime":
 618                  case "datetimecombo":
 619                      //return formatted date time
 620                      $timeStamp = strtotime('now');
 621                      //Start with db date
 622                      $value =    date($timedate->dbDayFormat.' '.$timedate->dbTimeFormat, $timeStamp);
 623                      //use timedate to convert to user display format
 624                      $value = $timedate->to_display_date_time($value);
 625                      //finally forma the am/pm to have a space so it can be recognized as a date field in excel
 626                      $value = preg_replace('/([pm|PM|am|AM]+)/', ' \1', $value);
 627                      $returnContent .= '"'.$value.'",';
 628
 629                      break;
 630                 case "phone":
 631                     $value = '('.mt_rand(300,999).') '.mt_rand(300,999).'-'.mt_rand(1000,9999);
 632                       $returnContent .= '"'.$value.'",';
 633                      break;
 634                  case "varchar":
 635                                      //process varchar for possible values
 636                                      if($field['name'] == 'first_name'){
 637                                          $count = count($sugar_demodata['first_name_array']) - 1;
 638                                         $returnContent .= '"'.$sugar_demodata['last_name_array'][mt_rand(0,$count)].'",';
 639                                      }elseif($field['name'] == 'last_name'){
 640                                          $count = count($sugar_demodata['last_name_array']) - 1;
 641                                          $returnContent .= '"'.$sugar_demodata['last_name_array'][mt_rand(0,$count)].'",';
 642                                      }elseif($field['name'] == 'user_name'){
 643                                        $count = count($sugar_demodata['first_name_array']) - 1;
 644                                         $returnContent .= '"'.$sugar_demodata['last_name_array'][mt_rand(0,$count)].'_'.mt_rand(1,111).'",';
 645                                      }elseif($field['name'] == 'title'){
 646                                          $count = count($sugar_demodata['titles']) - 1;
 647                                          $returnContent .= '"'.$sugar_demodata['titles'][mt_rand(0,$count)].'",';
 648                                      }elseif(strpos($field['name'],'address_street')>0){
 649                                        $count = count($sugar_demodata['street_address_array']) - 1;
 650                                         $returnContent .= '"'.$sugar_demodata['street_address_array'][mt_rand(0,$count)].'",';
 651                                      }elseif(strpos($field['name'],'address_city')>0){
 652                                        $count = count($sugar_demodata['city_array']) - 1;
 653                                         $returnContent .= '"'.$sugar_demodata['city_array'][mt_rand(0,$count)].'",';
 654                                      }elseif(strpos($field['name'],'address_state')>0){
 655                                          $state_arr = array('CA','NY','CO','TX','NV');
 656                                        $count = count($state_arr) - 1;
 657                                         $returnContent .= '"'.$state_arr[mt_rand(0,$count)].'",';
 658                                      }elseif(strpos($field['name'],'address_postalcode')>0){
 659                                         $returnContent .= '"'.mt_rand(12345,99999).'",';
 660                                      }else{
 661                                          $returnContent .= '"",';
 662
 663                                      }
 664                      break;
 665                 case "url":
 666                      $returnContent .= '"https://www.sugarcrm.com",';
 667                      break;
 668
 669                 case "enum":
 670                     //get the associated enum if available
 671                     global $app_list_strings;
 672
 673                     if(isset($focus->field_name_map[$field_name]['type']) && !empty($focus->field_name_map[$field_name]['options'])){
 674                         if ( !empty($app_list_strings[$focus->field_name_map[$field_name]['options']]) ) {
 675
 676                             //get the values into an array
 677                             $dd_values = $app_list_strings[$focus->field_name_map[$field_name]['options']];
 678                             $dd_values = array_values($dd_values);
 679
 680                             //grab the count
 681                             $count = count($dd_values) - 1;
 682
 683                             //choose one at random
 684                             $returnContent .= '"'.$dd_values[mt_rand(0,$count)].'",';
 685                             } else{
 686                                 //name of enum options array was found but is empty, return blank
 687                                 $returnContent .= '"",';
 688                             }
 689                     }else{
 690                         //name of enum options array was not found on field, return blank
 691                         $returnContent .= '"",';
 692                     }
 693                      break;
 694                 default:
 695                     //type is not matched, fill in with empty string and continue;
 696                     $returnContent .= '"",';
 697
 698              }
 699          }
 700          $returnContent .= "\r\n";
 701      }
 702      return $returnContent;
 703  }
 704
 705
 706
 707
 708  //expects the field name to translate and a bean of the type being translated (to access field map and mod_strings)
 709  function translateForExport($field_db_name,$focus){
 710      global $mod_strings,$app_strings;
 711
 712      if (empty($field_db_name) || empty($focus)){
 713         return false;
 714      }
 715
 716     //grab the focus module strings
 717     $temp_mod_strings = $mod_strings;
 718     global $current_language;
 719     $mod_strings = return_module_language($current_language, $focus->module_dir);
 720     $fieldLabel = '';
 721
 722      //!! first check to see if we are overriding the label for export.
 723      if (!empty($mod_strings['LBL_EXPORT_'.strtoupper($field_db_name)])){
 724          //entry exists which means we are overriding this value for exporting, use this label
 725          $fieldLabel = $mod_strings['LBL_EXPORT_'.strtoupper($field_db_name)];
 726
 727      }
 728      //!! next check to see if we are overriding the label for export on app_strings.
 729      elseif (!empty($app_strings['LBL_EXPORT_'.strtoupper($field_db_name)])){
 730          //entry exists which means we are overriding this value for exporting, use this label
 731          $fieldLabel = $app_strings['LBL_EXPORT_'.strtoupper($field_db_name)];
 732
 733      }//check to see if label exists in mapping and in mod strings
 734      elseif (!empty($focus->field_name_map[$field_db_name]['vname']) && !empty($mod_strings[$focus->field_name_map[$field_db_name]['vname']])){
 735          $fieldLabel = $mod_strings[$focus->field_name_map[$field_db_name]['vname']];
 736
 737      }//check to see if label exists in mapping and in app strings
 738      elseif (!empty($focus->field_name_map[$field_db_name]['vname']) && !empty($app_strings[$focus->field_name_map[$field_db_name]['vname']])){
 739          $fieldLabel = $app_strings[$focus->field_name_map[$field_db_name]['vname']];
 740
 741      }//field is not in mapping, so check to see if db can be uppercased and found in mod strings
 742      elseif (!empty($mod_strings['LBL_'.strtoupper($field_db_name)])){
 743          $fieldLabel = $mod_strings['LBL_'.strtoupper($field_db_name)];
 744
 745      }//check to see if db can be uppercased and found in app strings
 746      elseif (!empty($app_strings['LBL_'.strtoupper($field_db_name)])){
 747          $fieldLabel = $app_strings['LBL_'.strtoupper($field_db_name)];
 748
 749      }else{
 750          //we could not find the label in mod_strings or app_strings based on either a mapping entry
 751          //or on the db_name itself or being overwritten, so default to the db name as a last resort
 752          $fieldLabel = $field_db_name;
 753
 754      }
 755      //strip the label of any columns
 756      $fieldLabel= preg_replace("/([:]|\xEF\xBC\x9A)[\\s]*$/", '', trim($fieldLabel));
 757
 758      //reset the bean mod_strings back to original import strings
 759      $mod_strings = $temp_mod_strings;
 760      return $fieldLabel;
 761
 762  }
 763
 764 //call this function to return the desired order to display columns for export in.
 765 //if you pass in an array, it will reorder the array and send back to you.  It expects the array
 766 //to have the db names as key values, or as labels
 767 function get_field_order_mapping($name='',$reorderArr = '', $exclude = true){
 768
 769     //define the ordering of fields, note that the key value is what is important, and should be the db field name
 770     $field_order_array = array();
 771     $field_order_array['accounts'] = array( 'name'=>'Name', 'id'=>'ID', 'website'=>'Website', 'email_address' =>'Email Address', 'email_addresses_non_primary' => 'Non Primary E-mails', 'phone_office' =>'Office Phone', 'phone_alternate' => 'Alternate Phone', 'phone_fax' => 'Fax', 'billing_address_street' => 'Billing Street', 'billing_address_city' => 'Billing City', 'billing_address_state' => 'Billing State', 'billing_address_postalcode' => 'Billing Postal Code', 'billing_address_country' => 'Billing Country', 'shipping_address_street' => 'Shipping Street', 'shipping_address_city' => 'Shipping City', 'shipping_address_state' => 'Shipping State', 'shipping_address_postalcode' => 'Shipping Postal Code', 'shipping_address_country' => 'Shipping Country', 'description' => 'Description', 'account_type' => 'Type', 'industry' =>'Industry', 'annual_revenue' => 'Annual Revenue', 'employees' => 'Employees', 'sic_code' => 'SIC Code', 'ticker_symbol' => 'Ticker Symbol', 'parent_id' => 'Parent Account ID', 'ownership' =>'Ownership', 'campaign_id' =>'Campaign ID', 'rating' =>'Rating', 'assigned_user_name' =>'Assigned to',  'assigned_user_id' =>'Assigned User ID', 'team_id' =>'Team Id', 'team_name' =>'Teams', 'team_set_id' =>'Team Set ID', 'date_entered' =>'Date Created', 'date_modified' =>'Date Modified', 'modified_user_id' =>'Modified By', 'created_by' =>'Created By', 'deleted' =>'Deleted');
 772     $field_order_array['contacts'] = array( 'first_name' => 'First Name', 'last_name' => 'Last Name', 'id'=>'ID', 'salutation' => 'Salutation', 'title' => 'Title', 'department' => 'Department', 'account_name' => 'Account Name', 'email_address' => 'Email Address', 'email_addresses_non_primary' => 'Non Primary E-mails for Import', 'phone_mobile' => 'Phone Mobile','phone_work' => 'Phone Work', 'phone_home' => 'Phone Home',  'phone_other' => 'Phone Other','phone_fax' => 'Phone Fax', 'primary_address_street' => 'Primary Address Street', 'primary_address_city' => 'Primary Address City', 'primary_address_state' => 'Primary Address State', 'primary_address_postalcode' => 'Primary Address Postal Code', 'primary_address_country' => 'Primary Address Country', 'alt_address_street' => 'Alternate Address Street', 'alt_address_city' => 'Alternate Address City', 'alt_address_state' => 'Alternate Address State', 'alt_address_postalcode' => 'Alternate Address Postal Code', 'alt_address_country' => 'Alternate Address Country', 'description' => 'Description', 'birthdate' => 'Birthdate', 'lead_source' => 'Lead Source', 'campaign_id' => 'campaign_id', 'do_not_call' => 'Do Not Call', 'portal_name' => 'Portal Name', 'portal_active' => 'Portal Active', 'portal_password' => 'Portal Password', 'portal_app' => 'Portal Application', 'reports_to_id' => 'Reports to ID', 'assistant' => 'Assistant', 'assistant_phone' => 'Assistant Phone', 'picture' => 'Picture', 'assigned_user_name' => 'Assigned User Name', 'assigned_user_id' => 'Assigned User ID', 'team_name' => 'Teams', 'team_id' => 'Team id', 'team_set_id' => 'Team Set ID', 'date_entered' =>'Date Created', 'date_modified' =>'Date Modified', 'modified_user_id' =>'Modified By', 'created_by' =>'Created By', 'deleted' =>'Deleted');
 773     $field_order_array['leads']    = array( 'first_name' => 'First Name', 'last_name' => 'Last Name', 'id'=>'ID', 'salutation' => 'Salutation', 'title' => 'Title', 'department' => 'Department', 'account_name' => 'Account Name', 'account_description' =>  'Account Description', 'website' =>  'Website', 'email_address' =>  'Email Address', 'email_addresses_non_primary' => 'Non Primary E-mails for Import', 'phone_mobile' =>  'Phone Mobile', 'phone_work' =>  'Phone Work', 'phone_home' =>  'Phone Home', 'phone_other' =>  'Phone Other', 'phone_fax' =>  'Phone Fax', 'primary_address_street' =>  'Primary Address Street', 'primary_address_city' =>  'Primary Address City', 'primary_address_state' =>  'Primary Address State', 'primary_address_postalcode' =>  'Primary Address Postal Code', 'primary_address_country' =>  'Primary Address Country', 'alt_address_street' =>  'Alt Address Street', 'alt_address_city' =>  'Alt Address City', 'alt_address_state' =>  'Alt Address State', 'alt_address_postalcode' =>  'Alt Address Postalcode', 'alt_address_country' =>  'Alt Address Country', 'status' =>  'Status', 'status_description' =>  'Status Description', 'lead_source' =>  'Lead Source', 'lead_source_description' =>  'Lead Source Description', 'description'=>'Description', 'converted' =>  'Converted', 'opportunity_name' =>  'Opportunity Name', 'opportunity_amount' =>  'Opportunity Amount', 'refered_by' =>  'Referred By', 'campaign_id' =>  'campaign_id', 'do_not_call' =>  'Do Not Call', 'portal_name' =>  'Portal Name', 'portal_app' =>  'Portal Application', 'reports_to_id' =>  'Reports To ID', 'assistant' =>  'Assistant', 'assistant_phone' =>  'Assistant Phone', 'birthdate'=>'Birthdate', 'contact_id' =>  'Contact ID', 'account_id' =>  'Account ID', 'opportunity_id' =>  'Opportunity ID',  'assigned_user_name' =>  'Assigned User Name', 'assigned_user_id' =>  'Assigned User ID', 'team_name' =>  'Teams', 'team_id' =>  'Team id', 'team_set_id' =>  'Team Set ID', 'date_entered' =>  'Date Created', 'date_modified' =>  'Date Modified', 'created_by' =>  'Created By ID', 'modified_user_id' =>  'Modified By ID', 'deleted' =>  'Deleted');
 774     $field_order_array['opportunities'] = array( 'name' => 'Opportunity Name', 'id'=>'ID', 'amount' => 'Opportunity Amount', 'currency_id' => 'Currency', 'date_closed' => 'Expected Close Date', 'sales_stage' => 'Sales Stage', 'probability' => 'Probability (%)', 'next_step' => 'Next Step', 'opportunity_type' => 'Opportunity Type', 'account_name' => 'Account Name', 'description' => 'Description', 'amount_usdollar' => 'Amount', 'lead_source' => 'Lead Source', 'campaign_id' => 'campaign_id', 'assigned_user_name' => 'Assigned User Name', 'assigned_user_id' => 'Assigned User ID', 'team_name' => 'Teams', 'team_id' => 'Team id', 'team_set_id' => 'Team Set ID', 'date_entered' => 'Date Created', 'date_modified' => 'Date Modified', 'created_by' => 'Created By ID', 'modified_user_id' => 'Modified By ID', 'deleted' => 'Deleted');
 775     $field_order_array['notes'] =         array( 'name' => 'Name', 'id'=>'ID', 'description' => 'Description', 'filename' => 'Attachment', 'parent_type' => 'Parent Type', 'parent_id' => 'Parent ID', 'contact_id' => 'Contact ID', 'portal_flag' => 'Display in Portal?', 'assigned_user_name' =>'Assigned to', 'assigned_user_id' => 'assigned_user_id', 'team_id' => 'Team id', 'team_set_id' => 'Team Set ID', 'date_entered' => 'Date Created', 'date_modified' => 'Date Modified',  'created_by' => 'Created By ID', 'modified_user_id' => 'Modified By ID', 'deleted' => 'Deleted' );
 776     $field_order_array['bugs'] =   array('bug_number' => 'Bug Number', 'id'=>'ID', 'name' => 'Subject', 'description' => 'Description', 'status' => 'Status', 'type' => 'Type', 'priority' => 'Priority', 'resolution' => 'Resolution', 'work_log' => 'Work Log', 'found_in_release' => 'Found In Release', 'fixed_in_release' => 'Fixed In Release', 'found_in_release_name' => 'Found In Release Name', 'fixed_in_release_name' => 'Fixed In Release', 'product_category' => 'Category', 'source' => 'Source', 'portal_viewable' => 'Portal Viewable', 'system_id' => 'System ID', 'assigned_user_id' => 'Assigned User ID', 'assigned_user_name' => 'Assigned User Name', 'team_name'=>'Teams', 'team_id' => 'Team id', 'team_set_id' => 'Team Set ID', 'date_entered' =>'Date Created', 'date_modified' =>'Date Modified', 'modified_user_id' =>'Modified By', 'created_by' =>'Created By', 'deleted' =>'Deleted');
 777     $field_order_array['tasks'] =   array( 'name'=>'Subject', 'id'=>'ID', 'description'=>'Description', 'status'=>'Status', 'date_start'=>'Date Start', 'date_due'=>'Date Due','priority'=>'Priority', 'parent_type'=>'Parent Type', 'parent_id'=>'Parent ID', 'contact_id'=>'Contact ID', 'assigned_user_name' =>'Assigned to', 'assigned_user_id'=>'Assigned User ID', 'team_name'=>'Teams', 'team_id'=>'Team id', 'team_set_id'=>'Team Set ID', 'date_entered'=>'Date Created', 'date_modified'=>'Date Modified', 'created_by'=>'Created By ID', 'modified_user_id'=>'Modified By ID', 'deleted'=>'Deleted');
 778     $field_order_array['calls'] =   array( 'name'=>'Subject', 'id'=>'ID', 'description'=>'Description', 'status'=>'Status', 'direction'=>'Direction', 'date_start'=>'Date', 'date_end'=>'Date End', 'duration_hours'=>'Duration Hours', 'duration_minutes'=>'Duration Minutes', 'reminder_time'=>'Reminder Time', 'parent_type'=>'Parent Type', 'parent_id'=>'Parent ID', 'outlook_id'=>'Outlook ID', 'assigned_user_name' =>'Assigned to', 'assigned_user_id'=>'Assigned User ID', 'team_name'=>'Teams', 'team_id'=>'Team id', 'team_set_id'=>'Team Set ID', 'date_entered'=>'Date Created', 'date_modified'=>'Date Modified', 'created_by'=>'Created By ID', 'modified_user_id'=>'Modified By ID', 'deleted'=>'Deleted');
 779     $field_order_array['meetings'] =array( 'name'=>'Subject', 'id'=>'ID', 'description'=>'Description', 'status'=>'Status', 'location'=>'Location', 'date_start'=>'Date', 'date_end'=>'Date End', 'duration_hours'=>'Duration Hours', 'duration_minutes'=>'Duration Minutes', 'reminder_time'=>'Reminder Time', 'type'=>'Meeting Type', 'external_id'=>'External ID', 'password'=>'Meeting Password', 'join_url'=>'Join Url', 'host_url'=>'Host Url', 'displayed_url'=>'Displayed Url', 'creator'=>'Meeting Creator', 'parent_type'=>'Related to', 'parent_id'=>'Related to', 'outlook_id'=>'Outlook ID','assigned_user_name' =>'Assigned to','assigned_user_id' => 'Assigned User ID', 'team_name' => 'Teams', 'team_id' => 'Team id', 'team_set_id' => 'Team Set ID', 'date_entered' => 'Date Created', 'date_modified' => 'Date Modified', 'created_by' => 'Created By ID', 'modified_user_id' => 'Modified By ID', 'deleted' => 'Deleted');
 780     $field_order_array['cases'] =array( 'case_number'=>'Case Number', 'id'=>'ID', 'name'=>'Subject', 'description'=>'Description', 'status'=>'Status', 'type'=>'Type', 'priority'=>'Priority', 'resolution'=>'Resolution', 'work_log'=>'Work Log', 'portal_viewable'=>'Portal Viewable', 'account_name'=>'Account Name', 'account_id'=>'Account ID', 'assigned_user_id'=>'Assigned User ID', 'team_name'=>'Teams', 'team_id'=>'Team id', 'team_set_id'=>'Team Set ID', 'date_entered'=>'Date Created', 'date_modified'=>'Date Modified', 'created_by'=>'Created By ID', 'modified_user_id'=>'Modified By ID', 'deleted'=>'Deleted');
 781     $field_order_array['prospects'] =array( 'first_name'=>'First Name', 'last_name'=>'Last Name', 'id'=>'ID', 'salutation'=>'Salutation', 'title'=>'Title', 'department'=>'Department', 'account_name'=>'Account Name', 'email_address'=>'Email Address', 'email_addresses_non_primary' => 'Non Primary E-mails for Import', 'phone_mobile' => 'Phone Mobile', 'phone_work' => 'Phone Work', 'phone_home' => 'Phone Home', 'phone_other' => 'Phone Other', 'phone_fax' => 'Phone Fax',  'primary_address_street' => 'Primary Address Street', 'primary_address_city' => 'Primary Address City', 'primary_address_state' => 'Primary Address State', 'primary_address_postalcode' => 'Primary Address Postal Code', 'primary_address_country' => 'Primary Address Country', 'alt_address_street' => 'Alternate Address Street', 'alt_address_city' => 'Alternate Address City', 'alt_address_state' => 'Alternate Address State', 'alt_address_postalcode' => 'Alternate Address Postal Code', 'alt_address_country' => 'Alternate Address Country', 'description' => 'Description', 'birthdate' => 'Birthdate', 'assistant'=>'Assistant', 'assistant_phone'=>'Assistant Phone', 'campaign_id'=>'campaign_id', 'tracker_key'=>'Tracker Key', 'do_not_call'=>'Do Not Call', 'lead_id'=>'Lead Id', 'assigned_user_name'=>'Assigned User Name', 'assigned_user_id'=>'Assigned User ID', 'team_id' =>'Team Id', 'team_name' =>'Teams', 'team_set_id' =>'Team Set ID', 'date_entered' =>'Date Created', 'date_modified' =>'Date Modified', 'modified_user_id' =>'Modified By', 'created_by' =>'Created By', 'deleted' =>'Deleted');
 782
 783     $fields_to_exclude = array();
 784     $fields_to_exclude['accounts'] = array('account_name');
 785     $fields_to_exclude['bugs'] = array('system_id');
 786     $fields_to_exclude['cases'] = array('system_id', 'modified_by_name', 'modified_by_name_owner', 'modified_by_name_mod', 'created_by_name', 'created_by_name_owner', 'created_by_name_mod', 'assigned_user_name', 'assigned_user_name_owner', 'assigned_user_name_mod', 'team_count', 'team_count_owner', 'team_count_mod', 'team_name_owner', 'team_name_mod', 'account_name_owner', 'account_name_mod', 'modified_user_name',  'modified_user_name_owner', 'modified_user_name_mod');
 787     $fields_to_exclude['notes'] = array('first_name','last_name', 'file_mime_type','embed_flag');
 788     $fields_to_exclude['tasks'] = array('date_start_flag', 'date_due_flag');
 789
 790     //of array is passed in for reordering, process array
 791     if(!empty($name) && !empty($reorderArr) && is_array($reorderArr)){
 792
 793         //make sure reorderArr has values as keys, if not then iterate through and assign the value as the key
 794         $newReorder = array();
 795         foreach($reorderArr as $rk=> $rv){
 796             if(is_int($rk)){
 797                 $newReorder[$rv]=$rv;
 798             }else{
 799                 $newReorder[$rk]=$rv;
 800             }
 801         }
 802
 803         //if module is not defined, lets default the order to another module of the same type
 804         //this would apply mostly to custom modules
 805         if(!isset($field_order_array[strtolower($name)]) && isset($_REQUEST['module'])){
 806
 807             $exemptModuleList = array('ProspectLists');
 808             if(in_array($name, $exemptModuleList))
 809                 return $newReorder;
 810
 811             //get an instance of the bean
 812             global $beanList;
 813             global $beanFiles;
 814
 815             $bean = $beanList[$_REQUEST['module']];
 816             require_once($beanFiles[$bean]);
 817             $focus = new $bean;
 818
 819
 820             //if module is of type person
 821             if($focus instanceof Person){
 822                 $name = 'contacts';
 823             }
 824             //if module is of type company
 825             else if ($focus instanceof Company){
 826                 $name = 'accounts';
 827             }
 828             //if module is of type Sale
 829             else if ($focus instanceof Sale){
 830                 $name = 'opportunities';
 831             }//if module is of type File
 832             else if ($focus instanceof Issue){
 833                 $name = 'bugs';
 834             }//all others including type File can use basic
 835             else{
 836                 $name = 'Notes';
 837             }
 838
 839         }
 840
 841         //lets iterate through and create a reordered temporary array using
 842         //the  newly formatted copy of passed in array
 843         $temp_result_arr = array();
 844         $lname = strtolower($name);
 845         if(!empty($field_order_array[$lname])) {
 846                 foreach($field_order_array[$lname] as $fk=> $fv){
 847
 848                     //if the value exists as a key in the passed in array, add to temp array and remove from reorder array.
 849                     //Do not force into the temp array as we don't want to violate acl's
 850                     if(array_key_exists($fk,$newReorder)){
 851                         $temp_result_arr[$fk] = $newReorder[$fk];
 852                         unset($newReorder[$fk]);
 853                     }
 854                 }
 855         }
 856         //add in all the left over values that were not in our ordered list
 857         //array_splice($temp_result_arr, count($temp_result_arr), 0, $newReorder);
 858         foreach($newReorder as $nrk=>$nrv){
 859             $temp_result_arr[$nrk] = $nrv;
 860         }
 861
 862
 863         if($exclude){
 864             //Some arrays have values we wish to exclude
 865             if (isset($fields_to_exclude[$lname])){
 866                 foreach($fields_to_exclude[$lname] as $exclude_field){
 867                     unset($temp_result_arr[$exclude_field]);
 868                 }
 869             }
 870         }
 871
 872         //return temp ordered list
 873         return $temp_result_arr;
 874     }
 875
 876     //if no array was passed in, pass back either the list of ordered columns by module, or the entireorder array
 877     if(empty($name)){
 878         return $field_order_array;
 879     }else{
 880         return $field_order_array[strtolower($name)];
 881     }
 882
 883 }
 884 ?>