[Summary view] [Print] [Text view]

   1  <?php
   2  /*+***********************************************************************************
   3   * The contents of this file are subject to the vtiger CRM Public License Version 1.0
   4   * ("License"); You may not use this file except in compliance with the License
   5   * The Original Code is:  vtiger CRM Open Source
   6   * The Initial Developer of the Original Code is vtiger.
   7   * Portions created by vtiger are Copyright (C) vtiger.
   8   * All Rights Reserved.
   9   *************************************************************************************/
  10  
  11  class Settings_MenuEditor_Module_Model extends Settings_Vtiger_Module_Model {
  12      
  13      var $name = 'MenuEditor';
  14  
  15      /**
  16       * Function to save the menu structure
  17       */
  18  	public function saveMenuStruncture() {
  19          $db = PearDatabase::getInstance();
  20          $selectedModulesList = $this->get('selectedModulesList');
  21  
  22          $updateQuery = "UPDATE vtiger_tab SET tabsequence = CASE tabid ";
  23  
  24          foreach ($selectedModulesList as $sequence => $tabId) {
  25              $updateQuery .= " WHEN $tabId THEN $sequence ";
  26          }
  27          $updateQuery .= "ELSE -1 END";
  28  
  29          $db->pquery($updateQuery, array());
  30      }
  31  }