Example #1
0
 public function actionRemoveDuplicates($params)
 {
     \GO::setMaxExecutionTime(300);
     \GO::setMemoryLimit(1024);
     $this->render('externalHeader');
     $tasklist = \GO\Tasks\Model\Tasklist::model()->findByPk($params['tasklist_id']);
     if (!$tasklist) {
         throw new \GO\Base\Exception\NotFound();
     }
     \GO\Base\Fs\File::setAllowDeletes(false);
     //VERY IMPORTANT:
     \GO\Files\Model\Folder::$deleteInDatabaseOnly = true;
     \GO::session()->closeWriting();
     //close writing otherwise concurrent requests are blocked.
     $checkModels = array("GO\\Tasks\\Model\\Task" => array('name', 'start_time', 'due_time', 'rrule', 'user_id', 'tasklist_id'));
     foreach ($checkModels as $modelName => $checkFields) {
         if (empty($params['model']) || $modelName == $params['model']) {
             echo '<h1>' . \GO::t('removeDuplicates') . '</h1>';
             $checkFieldsStr = 't.' . implode(', t.', $checkFields);
             $findParams = \GO\Base\Db\FindParams::newInstance()->ignoreAcl()->select('t.id, count(*) AS n, ' . $checkFieldsStr)->group($checkFields)->having('n>1');
             $findParams->getCriteria()->addCondition('tasklist_id', $tasklist->id);
             $stmt1 = \GO::getModel($modelName)->find($findParams);
             echo '<table border="1">';
             echo '<tr><td>ID</th><th>' . implode('</th><th>', $checkFields) . '</th></tr>';
             $count = 0;
             while ($dupModel = $stmt1->fetch()) {
                 $select = 't.id';
                 if (\GO::getModel($modelName)->hasFiles()) {
                     $select .= ', t.files_folder_id';
                 }
                 $findParams = \GO\Base\Db\FindParams::newInstance()->ignoreAcl()->select($select . ', ' . $checkFieldsStr)->order('id', 'ASC');
                 $findParams->getCriteria()->addCondition('tasklist_id', $tasklist->id);
                 foreach ($checkFields as $field) {
                     $findParams->getCriteria()->addCondition($field, $dupModel->getAttribute($field));
                 }
                 $stmt = \GO::getModel($modelName)->find($findParams);
                 $first = true;
                 while ($model = $stmt->fetch()) {
                     echo '<tr><td>';
                     if (!$first) {
                         echo '<span style="color:red">';
                     }
                     echo $model->id;
                     if (!$first) {
                         echo '</span>';
                     }
                     echo '</th>';
                     foreach ($checkFields as $field) {
                         echo '<td>' . $model->getAttribute($field, 'html') . '</td>';
                     }
                     echo '</tr>';
                     if (!$first) {
                         if (!empty($params['delete'])) {
                             if ($model->hasLinks() && $model->countLinks()) {
                                 echo '<tr><td colspan="99">' . \GO::t('skippedDeleteHasLinks') . '</td></tr>';
                             } elseif (($filesFolder = $model->getFilesFolder(false)) && ($filesFolder->hasFileChildren() || $filesFolder->hasFolderChildren())) {
                                 echo '<tr><td colspan="99">' . \GO::t('skippedDeleteHasFiles') . '</td></tr>';
                             } else {
                                 $model->delete();
                             }
                         }
                         $count++;
                     }
                     $first = false;
                 }
             }
             echo '</table>';
             echo '<p>' . sprintf(\GO::t('foundDuplicates'), $count) . '</p>';
             echo '<br /><br /><a href="' . \GO::url('tasks/tasklist/removeDuplicates', array('delete' => true, 'tasklist_id' => $tasklist->id)) . '">' . \GO::t('clickToDeleteDuplicates') . '</a>';
         }
     }
     $this->render('externalFooter');
 }
Example #2
0
 protected function actionUpgrade($params)
 {
     if (!$this->isCli()) {
         echo '<pre>';
     }
     if (!version_compare(phpversion(), "5.3", ">=")) {
         exit("You are running a PHP version older than 5.3. PHP 5.3 or greater is required to run Group-Office " . \GO::config()->version);
     }
     $this->lockAction();
     GO::setIgnoreAclPermissions(true);
     GO::session()->runAsRoot();
     \GO::clearCache();
     \GO\Base\Db\Columns::$forceLoad = true;
     //don't be strict in upgrade process
     \GO::getDbConnection()->query("SET sql_mode=''");
     $v3 = $this->_checkV3();
     $logDir = new \GO\Base\Fs\Folder(\GO::config()->file_storage_path . 'log/upgrade/');
     $logDir->create();
     global $logFile;
     $logFile = $logDir->path() . '/' . date('Ymd_Gi') . '.log';
     touch($logFile);
     if (!is_writable($logFile)) {
         die('Fatal error: Could not write to log file');
     }
     ob_start("GO\\Core\\Controller\\MaintenanceController::ob_upgrade_log");
     echo "Updating " . \GO::config()->product_name . " database\n";
     //build an array of all update files. The queries are indexed by timestamp
     //so they will all be executed in the right order.
     $u = array();
     require \GO::config()->root_path . 'install/updates.php';
     //put the updates in an extra array dimension so we know to which module
     //they belong too.
     foreach ($updates as $timestamp => $updatequeries) {
         $u["{$timestamp}"]['core'] = $updatequeries;
     }
     $modules = \GO::modules()->getAllModules();
     while ($module = array_shift($modules)) {
         if ($module->isAvailable()) {
             $updatesFile = $module->path . 'install/updates.php';
             if (!file_exists($updatesFile)) {
                 $updatesFile = $module->path . 'install/updates.inc.php';
             }
             if (file_exists($updatesFile)) {
                 $updates = array();
                 require $updatesFile;
                 //put the updates in an extra array dimension so we know to which module
                 //they belong too.
                 foreach ($updates as $timestamp => $updatequeries) {
                     $u["{$timestamp}"][$module->id] = $updatequeries;
                 }
             }
         }
     }
     //sort the array by timestamp
     ksort($u);
     //
     //		var_dump($u);
     //		exit();
     $currentCoreVersion = \GO::config()->get_setting('version');
     if (!$currentCoreVersion) {
         $currentCoreVersion = 0;
     }
     $counts = array();
     foreach ($u as $timestamp => $updateQuerySet) {
         foreach ($updateQuerySet as $module => $queries) {
             //echo "Getting updates for ".$module."\n";
             if (!is_array($queries)) {
                 exit("Invalid queries in module: " . $module);
             }
             if ($module == 'core') {
                 $currentVersion = $currentCoreVersion;
             } else {
                 $currentVersion = \GO::modules()->{$module}->version;
             }
             if (!isset($counts[$module])) {
                 $counts[$module] = 0;
             }
             foreach ($queries as $query) {
                 $counts[$module]++;
                 if ($counts[$module] > $currentVersion) {
                     if (substr($query, 0, 7) == 'script:') {
                         if ($module == 'core') {
                             $updateScript = \GO::config()->root_path . 'install/updatescripts/' . substr($query, 7);
                         } else {
                             $updateScript = \GO::modules()->{$module}->path . 'install/updatescripts/' . substr($query, 7);
                         }
                         if (!file_exists($updateScript)) {
                             die($updateScript . ' not found!');
                         }
                         //if(!$quiet)
                         echo 'Running ' . $updateScript . "\n";
                         flush();
                         if (empty($params['test'])) {
                             require_once $updateScript;
                         }
                     } else {
                         echo 'Excuting query: ' . $query . "\n";
                         flush();
                         if (empty($params['test'])) {
                             try {
                                 if (!empty($query)) {
                                     \GO::getDbConnection()->query($query);
                                 }
                             } catch (PDOException $e) {
                                 //var_dump($e);
                                 echo $e->getMessage() . "\n";
                                 echo "Query: " . $query;
                                 //									if ($e->getCode() == 1091 || $e->getCode() == 1060) {
                                 //										//duplicate and drop errors. Ignore those on updates
                                 //									} else {
                                 //										die();
                                 //									}
                             }
                         }
                     }
                     if (empty($params['test'])) {
                         if ($module == 'core') {
                             \GO::config()->save_setting('version', $counts[$module]);
                         } else {
                             //echo $module.' updated to '.$counts[$module]."\n";
                             $moduleModel = \GO::modules()->{$module};
                             $moduleModel->version = $counts[$module];
                             $moduleModel->save();
                         }
                         ob_flush();
                     }
                 }
             }
         }
     }
     if (empty($params['test'])) {
         echo "Database updated to version " . \GO::config()->mtime, "\n";
         ob_flush();
         \GO::config()->save_setting('upgrade_mtime', \GO::config()->mtime);
     } else {
         echo "Ran in test mode\n";
     }
     echo "Removing cached javascripts...\n\n";
     //in some exceptions alowed deletes is still on false here.
     \GO\Base\Fs\File::setAllowDeletes(true);
     \GO::clearCache();
     //rebuild listeners
     \GO\Base\Observable::cacheListeners();
     if ($v3) {
         //			if(\GO::modules()->isInstalled('projects') && \GO::modules()->isInstalled('files')){
         //				echo "Renaming projects folder temporarily for new project paths\n";
         //				$folder = \GO\Files\Model\Folder::model()->findByPath('projects');
         //				if($folder){
         //					$folder->name='oldprojects';
         //					$folder->systemSave=true;
         //					$folder->save();
         //				}
         //			}
         //			echo "Checking database after version 3.7 upgrade.\n";
         //			$this->actionCheckDatabase($params);
         //			echo "Done\n\n";
         //			ob_flush();
         $versioningFolder = new \GO\Base\Fs\Folder(\GO::config()->file_storage_path . 'versioning');
         if ($versioningFolder->exists()) {
             $versioningFolder->rename("versioning_backup_3_7");
         }
         if (!$this->isCli()) {
             echo '</pre>';
         }
         echo "Building search cache after version 3.7 upgrade.\n";
         ob_flush();
         $this->run("buildsearchcache", $params);
         ob_flush();
         if (!$this->isCli()) {
             echo '<pre>';
         }
     }
     echo "All Done!\n";
     if (!$this->isCli() && basename($_SERVER['PHP_SELF']) != 'upgrade.php') {
         echo '</pre><br /><br />';
         echo '<a href="' . \GO::config()->host . '">' . \GO::t('cmdContinue') . '</a>';
     }
     ob_end_flush();
     \GO\Base\Db\Columns::$forceLoad = false;
     //return $response;
 }
Example #3
0
 public function checkModelFolder(\GO\Base\Db\ActiveRecord $model, $saveModel = false, $mustExist = false)
 {
     $oldAllowDeletes = \GO\Base\Fs\File::setAllowDeletes(false);
     $folder = false;
     if ($model->files_folder_id > 0) {
         GO::debug('Model has files_folder_id ' . $model->files_folder_id);
         $folder = \GO\Files\Model\Folder::model()->findByPk($model->files_folder_id, false, true);
         //record has an ID but the folder is missing from the database. Attempt to create new one.
         $mustExist = true;
     }
     if ($folder) {
         GO::debug('Folder exists in database');
         $model->files_folder_id = $this->_checkExistingModelFolder($model, $folder, $mustExist);
         if ($saveModel && $model->isModified()) {
             $model->save(true);
         }
     } elseif (isset($model->acl_id) && !$model->aclOverwrite() || $mustExist) {
         GO::debug('Folder does not exist in database. Will create it.');
         //this model has an acl_id. So we should create a shared folder with this acl.
         //this folder should always exist.
         //only new models that have it's own acl field should always have a folder.
         //otherwise it will be created when first accessed.
         $model->files_folder_id = $this->_createNewModelFolder($model);
         if ($saveModel && $model->isModified()) {
             $model->save(true);
         }
     }
     if (empty($model->files_folder_id)) {
         $model->files_folder_id = 0;
     }
     \GO\Base\Fs\File::setAllowDeletes($oldAllowDeletes);
     $this->fireEvent('checkmodelfolder', array($model, $folder));
     return $model->files_folder_id;
 }