public function actionData($params) { $response = array('success' => true, 'data' => array()); try { $customCssFolder = new Folder(GO::config()->file_storage_path . 'customcss'); if (!$customCssFolder->exists()) { $customCssFolder->create(0755); } $cssFile = new File(GO::config()->file_storage_path . 'customcss/style.css'); $jsFile = new File(GO::config()->file_storage_path . 'customcss/javascript.js'); if (Http::isPostRequest()) { if (isset($_POST['css'])) { $cssFile->putContents($_POST['css']); } if (isset($_POST['javascript'])) { $jsFile->putContents($_POST['javascript']); } } if ($cssFile->exists()) { $response['data']['css'] = $cssFile->getContents(); } else { $response['data']['css'] = '/* * Put custom styles here that will be applied to Group-Office. You can use the select file button to upload your logo and insert the URL in to this stylesheet. */ /* this will override the logo at the top right */ #headerLeft{ background-image:url(/insert/url/here) !important; } /* this will override the logo at the login screen */ .go-app-logo { background-image:url(/insert/url/here) !important; }'; } if ($jsFile->exists()) { $response['data']['javascript'] = $jsFile->getContents(); } } catch (Exception $e) { $response['feedback'] = $e->getMessage(); $response['success'] = false; } echo $this->renderJson($response); }
/** * Get the cache folder for cached scripts. * * @return \Fs\Folder */ public function getCacheFolder($autoCreate = true) { if (empty($this->cachefolder)) { $this->cachefolder = $this->orig_tmpdir . 'cache/'; } $folder = new Fs\Folder($this->cachefolder); if ($autoCreate) { $folder->create(0777); } return $folder; }
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; }
protected function actionUpload($params) { $tmpFolder = new \GO\Base\Fs\Folder(GO::config()->tmpdir . 'uploadqueue'); // $tmpFolder->delete(); $tmpFolder->create(); $files = \GO\Base\Fs\File::moveUploadedFiles($_FILES['attachments'], $tmpFolder); $relativeFiles = array(); foreach ($files as $file) { $relativeFiles[] = str_replace(GO::config()->tmpdir, '', $file->path()); } return array('success' => true, 'files' => $relativeFiles); }
public function install() { // Install the notification cron for income contracts \GO\Projects2\Projects2Module::createDefaultIncomeContractNotificationCron(); // if(!GO::modules()->isInstalled('projects')){ GO::getDbConnection()->query("SET sql_mode=''"); if (!Utils::tableExists("pm_projects")) { parent::install(); $defaultType = new Type(); $defaultType->name = GO::t('default'); $defaultType->save(); $defaultStatus = new Status(); $defaultStatus->name = GO::t('ongoing', 'projects2'); $defaultStatus->show_in_tree = true; $defaultStatus->save(); $noneStatus = new Status(); $noneStatus->name = GO::t('none', 'projects2'); $noneStatus->show_in_tree = true; $noneStatus->filterable = true; $noneStatus->save(); $status = new Status(); $status->name = GO::t('complete', 'projects2'); $status->complete = true; $status->show_in_tree = false; $status->save(); $folder = new \GO\Base\Fs\Folder(GO::config()->file_storage_path . 'projects2/template-icons'); $folder->create(); if (!$folder->child('folder.png')) { $file = new \GO\Base\Fs\File(GO::modules()->projects2->path . 'install/images/folder.png'); $file->copy($folder); } if (!$folder->child('project.png')) { $file = new \GO\Base\Fs\File(GO::modules()->projects2->path . 'install/images/project.png'); $file->copy($folder); } $template = new Template(); $template->name = GO::t('projectsFolder', 'projects2'); $template->default_status_id = $noneStatus->id; $template->default_type_id = $defaultType->id; $template->icon = $folder->stripFileStoragePath() . '/folder.png'; $template->project_type = Template::PROJECT_TYPE_CONTAINER; $template->save(); $template->acl->addGroup(GO::config()->group_everyone); $template = new Template(); $template->name = GO::t('standardProject', 'projects2'); $template->default_status_id = $defaultStatus->id; $template->default_type_id = $defaultType->id; $template->project_type = Template::PROJECT_TYPE_PROJECT; $template->fields = 'responsible_user_id,status_date,customer,budget_fees,contact,expenses'; $template->icon = $folder->stripFileStoragePath() . '/project.png'; $template->save(); $template->acl->addGroup(GO::config()->group_everyone); } else { GO::setMaxExecutionTime(0); $oldModelTypeId = \GO\Base\Model\ModelType::model()->findByModelName("GO\\Projects\\Model\\Project"); $modelTypeId = \GO\Base\Model\ModelType::model()->findByModelName("GO\\Projects2\\Model\\Project"); //copy old projects module tables $stmt = GO::getDbConnection()->query('SHOW TABLES'); while ($r = $stmt->fetch()) { $tableName = $r[0]; if (substr($tableName, 0, 9) == 'go_links_' && !is_numeric(substr($tableName, 9, 1))) { try { $sql = "ALTER TABLE `{$tableName}` ADD `ctime` INT NOT NULL DEFAULT '0';"; GO::getDbConnection()->query($sql); } catch (Exception $e) { } $sql = "DELETE FROM `{$tableName}` WHERE model_type_id=" . intval($modelTypeId); GO::debug($sql); GO::getDbConnection()->query($sql); $sql = "INSERT IGNORE INTO `{$tableName}` SELECT id,folder_id, model_id,'{$modelTypeId}', description, ctime FROM `{$tableName}` WHERE model_type_id={$oldModelTypeId}"; GO::debug($sql); GO::getDbConnection()->query($sql); } if (strpos($tableName, 'pm_') !== false) { //some GLOBAL2000 tables we do not want to copy if (!in_array($tableName, array('pm_employees', 'pm_resources', 'pm_employment_agreements'))) { $newTable = str_replace('pm_', "pr2_", $tableName); $sql = "DROP TABLE IF EXISTS `{$newTable}`"; GO::getDbConnection()->query($sql); $sql = "CREATE TABLE `{$newTable}` LIKE `{$tableName}`"; GO::getDbConnection()->query($sql); $sql = "INSERT INTO `{$newTable}` SELECT * FROM `{$tableName}`"; GO::getDbConnection()->query($sql); } } } $sql = "update pr2_projects set name = replace(name, '/','-')"; GO::getDbConnection()->query($sql); // $sql = "update pr2_projects set files_folder_id=0"; // GO::getDbConnection()->query($sql); $sql = "select version from go_modules where id='projects'"; $stmt = GO::getDbConnection()->query($sql); $record = $stmt->fetch(PDO::FETCH_ASSOC); GO::modules()->projects2->version = $record['version']; GO::modules()->projects2->save(); // GO::modules()->projects->acl->copyPermissions(GO::modules()->projects2->acl); //start files // $sql = "UPDATE pr2_projects SET files_folder_id=(SELECT files_folder_id FROM pm_projects WHERE pm_projects.id=pr2_projects.id);"; // GO::getDbConnection()->query($sql); $fsFolder = new GO\Base\Fs\Folder(GO::config()->file_storage_path . 'projects2'); if ($fsFolder->exists()) { $fsFolder->rename('projects2-' . date('c')); } $folder = \GO\Files\Model\Folder::model()->findByPath('projects'); $folder->name = 'projects2'; $folder->acl_id = GO::modules()->projects2->acl_id; $folder->save(); // $sql = "UPDATE pm_projects SET files_folder_id=0;"; // GO::getDbConnection()->query($sql); $sql = "update `pr2_templates` set icon = replace(icon, 'projects/', 'projects2/');"; GO::getDbConnection()->query($sql); //end files //upgrade database ob_start(); $mc = new \GO\Core\Controller\MaintenanceController(); $mc->run("upgrade", array(), false); ob_end_clean(); //create new acl's // $types = \GO\Projects\Model\Type::model()->find(); // foreach($types as $type){ // $type2 = Model\Type::model()->findByPk($type->id); // $type2->setNewAcl($type->user_id); // $type->acl->copyPermissions($type2->acl); // $type2->save(); // } $sql = "ALTER TABLE `pr2_hours` CHANGE `income_id` `old_income_id` INT( 11 ) NULL DEFAULT NULL ;"; GO::getDbConnection()->query($sql); $sql = "ALTER TABLE `pr2_hours` ADD `income_id` INT( 11 ) NULL AFTER `old_income_id` ;"; GO::getDbConnection()->query($sql); $sql = "UPDATE `pr2_hours` SET old_income_id=-1*old_income_id;"; GO::getDbConnection()->query($sql); if (\GO\Base\Db\Utils::tableExists("pm_employment_agreements")) { //GLOBAL 2000 version $sql = "replace into pr2_employees (user_id, external_fee, internal_fee) select employee_id, max(external_fee),max(internal_fee) from pm_employment_agreements group by employee_id"; GO::getDbConnection()->query($sql); $sql = "replace into pr2_resources (user_id,project_id, external_fee, internal_fee) select user_id,project_id, external_fee, internal_fee from pm_resources"; GO::getDbConnection()->query($sql); // No longer necessary because of $updates['201310041023'] in updates.inc.php : // //untested // $sql = "ALTER TABLE `pr2_hours` CHANGE `external_value` `external_fee` DOUBLE NOT NULL DEFAULT '0'"; // GO::getDbConnection()->query($sql); } else { $sql = "insert ignore into pr2_employees (user_id, external_fee, internal_fee) select user_id, max(ext_fee_value), max(int_fee_value) from pm_hours group by user_id"; GO::getDbConnection()->query($sql); $sql = "insert ignore into pr2_resources (user_id,project_id, external_fee, internal_fee) select user_id,project_id, max(ext_fee_value), max(int_fee_value) from pm_hours group by user_id, project_id"; GO::getDbConnection()->query($sql); } $sql = "update pr2_templates set project_type=1"; GO::getDbConnection()->query($sql); if (GO::modules()->customfields) { // require(dirname(__FILE__).'/install/migrate/models.php'); // \GO\Customfields\CustomfieldsModule::replaceRecords("GO\Projects\Model\Project", "GO\Projects2\Model\Project"); // \GO\Customfields\CustomfieldsModule::replaceRecords("GO\Projects\Model\Hour", "GO\Projects2\Model\TimeEntry"); //$sql = "RENAME TABLE `cf_pm_projects` TO `cf_pr2_projects` "; //GO::getDbConnection()->query($sql); //$sql = "RENAME TABLE `cf_pm_hours` TO `cf_pr2_hours` "; //GO::getDbConnection()->query($sql); $sql = "update `cf_categories` set extends_model = 'GO\\\\Projects2\\\\Model\\\\Project' where extends_model = 'GO\\\\Projects\\\\Model\\\\Project';"; GO::getDbConnection()->query($sql); $sql = "update `cf_categories` set extends_model = 'GO\\\\Projects2\\\\Model\\\\Hour' where extends_model = 'GO\\\\Projects\\\\Model\\\\Hour';"; GO::getDbConnection()->query($sql); } // Now, let's make sure that all the projects have a template. $folder = new Folder(GO::config()->file_storage_path . 'projects2/template-icons'); $folder->create(); if (!$folder->child('folder.png')) { $file = new File(GO::modules()->projects2->path . 'install/images/folder.png'); $file->copy($folder); } if (!$folder->child('project.png')) { $file = new File(GO::modules()->projects2->path . 'install/images/project.png'); $file->copy($folder); } if (\GO::modules()->files) { $fileFolder = \GO\Files\Model\Folder::model()->findByPath('projects2/template-icons', true); if (!$fileFolder->acl_id != \GO::modules()->projects2->acl_id) { $oldIgnore = \GO::$ignoreAclPermissions; \GO::$ignoreAclPermissions = true; $fileFolder->acl_id = \GO::modules()->projects2->acl_id; $fileFolder->save(); \GO::$ignoreAclPermissions = $oldIgnore; } //for icons added after install $fileFolder->syncFilesystem(); } $normalTemplate = new Template(); $normalTemplate->name = GO::t('normalProject', 'projects2'); $normalTemplate->project_type = Template::PROJECT_TYPE_PROJECT; $normalTemplate->fields = 'responsible_user_id,status_date,customer,budget_fees,contact,expenses'; $normalTemplate->icon = $folder->stripFileStoragePath() . '/project.png'; $normalTemplate->save(); GO\Base\Db\Columns::$forceLoad = true; $noTemplateProjectsStmt = Project::model()->find(FindParams::newInstance()->criteria(FindCriteria::newInstance()->addCondition('template_id', 0))); GO\Base\Db\Columns::$forceLoad = false; foreach ($noTemplateProjectsStmt as $noTemplateProjectModel) { $noTemplateProjectModel->template_id = $normalTemplate->id; $noTemplateProjectModel->save(); } // Upgrade closed weeks ob_start(); $pc = new \GO\Projects2\Controller\ProjectController(); $pc->run("v1toV2Upgrade", array(), false); ob_end_clean(); } }
* Copyright Intermesh * * This file is part of Group-Office. You should have received a copy of the * Group-Office license along with Group-Office. See the file /LICENSE.TXT * * If you have questions write an e-mail to info@intermesh.nl * */ namespace GO\Base\Mail; use GO; use GO\Base\Fs\Folder; use Exception; //make sure temp dir exists $cacheFolder = new Folder(GO::config()->tmpdir); $cacheFolder->create(); /** * This class is used to parse and write RFC822 compliant recipient lists * * @package GO.base.mail * @version $Id: RFC822.class.inc 7536 2011-05-31 08:37:36Z mschering $ * @author Merijn Schering <*****@*****.**> * @copyright Copyright Intermesh BV. */ class Message extends \Swift_Message { private $_loadedBody; /** * The path in where the temporary attachments are stored * * @var boolean/string
/** * Get the file with groups info for Prosody * * @return \GO\Base\Fs\File */ public static function getGroupsFile() { $folder = new GO\Base\Fs\Folder(GO::config()->file_storage_path . 'chat'); $folder->create(); $file = $folder->createChild('groups.txt'); return $file; }