/** * Generates the form used for adding snippets * @return {Form} Form used to add snippets */ public function AddForm() { $sng = singleton('Snippet'); $fields = $sng->getCMSFields(); $validator = $sng->getCMSValidator(); $actions = new FieldList(FormAction::create('doAdd', _t('CodeBank.CREATE', '_Create'))->addExtraClass('ss-ui-action-constructive')->setAttribute('data-icon', 'accept')->setUseButtonTag(true)); $form = CMSForm::create($this, 'AddForm', $fields, $actions)->setHTMLID('Form_AddForm'); $form->setValidator($validator); $form->disableDefaultAction(); $form->addExtraClass('cms-add-form cms-edit-form'); $form->setResponseNegotiator($this->getResponseNegotiator()); $form->setTemplate($this->getTemplatesWithSuffix('_EditForm')); $form->addExtraClass('center ' . $this->BaseCSSClasses()); $form->setAttribute('data-pjax-fragment', 'CurrentForm'); //Handle Language id in url if ($this->request->getVar('LanguageID')) { $langField = $form->Fields()->dataFieldByName('LanguageID'); if ($langField && $langField->Value() == '') { $langField->setValue(intval(str_replace('language-', '', $this->request->getVar('LanguageID')))); } } //Handle folder id in url (or post) if ($this->request->getVar('FolderID')) { $folder = SnippetFolder::get()->byID(intval($this->request->getVar('FolderID'))); if (!empty($folder) && $folder !== false && $folder->ID != 0) { $langField = $form->Fields()->dataFieldByName('LanguageID')->setValue($folder->ParentID); $form->Fields()->replaceField('LanguageID', $langField->performReadonlyTransformation()); $form->Fields()->push(new HiddenField('FolderID', 'FolderID', $folder->ID)); } } else { if ($this->request->postVar('FolderID')) { $folder = SnippetFolder::get()->byID(intval($this->request->postVar('FolderID'))); if (!empty($folder) && $folder !== false && $folder->ID != 0) { $langField = $form->Fields()->dataFieldByName('LanguageID')->setValue($folder->ParentID); $form->Fields()->replaceField('LanguageID', $langField->performReadonlyTransformation()); $form->Fields()->push(new HiddenField('FolderID', 'FolderID', $folder->ID)); } } } $this->extend('updateAddForm', $form); //Display message telling user to run dev/build because the version numbers are out of sync if (CB_VERSION != '@@VERSION@@' && CodeBankConfig::CurrentConfig()->Version != CB_VERSION . ' ' . CB_BUILD_DATE) { $form->insertBefore(new LiteralField('<p class="message error">' . _t('CodeBank.UPDATE_NEEDED', '_A database upgrade is required please run {startlink}dev/build{endlink}.', array('startlink' => '<a href="dev/build?flush=all">', 'endlink' => '</a>')) . '</p>'), 'LanguageID'); } else { if ($this->hasOldTables()) { $form->insertBefore(new LiteralField('<p class="message warning">' . _t('CodeBank.MIGRATION_AVAILABLE', '_It appears you are upgrading from Code Bank 2.2.x, your old data can be migrated {startlink}click here to begin{endlink}, though it is recommended you backup your database first.', array('startlink' => '<a href="dev/tasks/CodeBankLegacyMigrate">', 'endlink' => '</a>')) . '</p>'), 'LanguageID'); } } $form->Actions()->push(new LiteralField('CodeBankVersion', '<p class="codeBankVersion">Code Bank: ' . $this->getVersion() . '</p>')); Requirements::javascript(CB_DIR . '/javascript/CodeBank.EditForm.js'); return $form; }
/** * @return Array Map of Snippet Folder IDs */ public function snippetFoldersIncluded() { if ($this->_cache_snippet_ids === null) { $this->populateSnippetIDs(); } if (empty($this->_cache_snippet_ids)) { return array(); } $ids = array(); $q = SnippetFolder::get(); if (isset($this->params['LanguageID']) && !empty($this->params['LanguageID'])) { $q = $q->filter('LanguageID', intval($this->params['LanguageID'])); } $q = $q->filter('Snippets.ID', array_keys($this->_cache_snippet_ids)); return $q->column('ID'); }
/** * Deletes a folder * @param {stdClass} $data Data passed from ActionScript * @return {array} Standard response base */ public function moveSnippet($data) { $response = CodeBank_ClientAPI::responseBase(); //Ensure logged in if (!Permission::check('CODE_BANK_ACCESS')) { $response['status'] = 'EROR'; $response['message'] = _t('CodeBankAPI.PERMISSION_DENINED', '_Permission Denied'); return $response; } $snippet = Snippet::get()->byID(intval($data->id)); if (empty($snippet) || $snippet === false || $snippet->ID == 0) { $response['status'] = "EROR"; $response['message'] = _t('CodeBankAPI.SNIPPET_NOT_FOUND', '_Snippet not found'); return $response; } if ($data->folderID != 0) { $snippetFolder = SnippetFolder::get()->byID(intval($data->folderID)); if (empty($snippetFolder) || $snippetFolder === false || $snippetFolder->ID == 0) { $response['status'] = "EROR"; $response['message'] = _t('CodeBankAPI.FOLDER_DOES_NOT_EXIST', '_Folder does not exist'); return $response; } if ($snippetFolder->LanguageID != $snippet->LanguageID) { $response['status'] = "EROR"; $response['message'] = _t('CodeBankAPI.LANGUAGE_NOT_SAME', '_Folder is not in the same language as the snippet'); return $response; } } try { $snippet->FolderID = $data->folderID; $snippet->write(); $response['status'] = "HELO"; } catch (Exception $e) { $response['status'] = "EROR"; $response['message'] = "Internal Server error occured"; } return $response; }
/** * Deletes a folder node */ public function deleteFolder() { $folder = SnippetFolder::get()->byID(intval(str_replace('folder-', '', $this->request->getVar('ID')))); if (empty($folder) || $folder === false || $folder->ID == 0) { $this->response->setStatusCode(404, _t('CodeBank.FOLDER_NOT_FOUND', '_Folder could not be found')); return; } $folder->delete(); return 'HELO'; }
/** * Processes the upload request * @param {array} $data Submitted data * @param {Form} $form Submitting form * @return {SS_HTTPResponse} Response */ public function doImportData($data, Form $form) { if (!Permission::check('ADMIN')) { Security::permissionFailure($this); return; } $fileData = $form->Fields()->dataFieldByName('ImportFile')->Value(); //Check that the file uploaded if (!array_key_exists('tmp_name', $fileData) || !file_exists($fileData['tmp_name'])) { $form->sessionMessage(_t('CodeBank.IMPORT_READ_ERROR', '_Could not read the file to be imported'), 'bad'); return $this->redirectBack(); } //Load the file into memory $fileData = file_get_contents($fileData['tmp_name']); if ($fileData === false || empty($fileData)) { $form->sessionMessage(_t('CodeBank.IMPORT_READ_ERROR', '_Could not read the file to be imported'), 'bad'); return $this->redirectBack(); } //Decode the json $fileData = json_decode($fileData); if ($fileData === false || !is_object($fileData)) { $form->sessionMessage(_t('CodeBank.IMPORT_READ_ERROR', '_Could not read the file to be imported'), 'bad'); return $this->redirectBack(); } //Verify the format is ToServer if ($fileData->format != 'ToServer') { $form->sessionMessage(_t('CodeBank.IMPORT_FILE_FORMAT_INCORRECT', '_Import file format is incorrect'), 'bad'); return $this->redirectBack(); } //Bump Up the time limit this may take time set_time_limit(480); //Start transaction if supported if (DB::getConn()->supportsTransactions()) { DB::getConn()->transactionStart(); } //If not appending empty the tables if (!isset($data['AppendData'])) { DB::query('DELETE FROM Snippet'); DB::query('DELETE FROM SnippetVersion'); DB::query('DELETE FROM SnippetLanguage'); DB::query('DELETE FROM SnippetPackage'); DB::query('DELETE FROM SnippetFolder'); } else { $langMap = array(); $pkgMap = array(); $folderMap = array(); $snipMap = array(); } //Import Languages foreach ($fileData->data->languages as $lang) { if (isset($data['AppendData'])) { $dbLang = SnippetLanguage::get()->filter('Name:ExactMatch:nocase', Convert::raw2sql($lang->language))->first(); if (!empty($dbLang) && $dbLang !== false && $dbLang->ID > 0) { $langMap['lang-' . $lang->id] = $dbLang->ID; } else { $newLang = new SnippetLanguage(); $newLang->Name = $lang->language; $newLang->FileExtension = $lang->file_extension; $newLang->HighlightCode = $lang->shjs_code; $newLang->UserLanguage = $lang->user_language; $newLang->write(); $langMap['lang-' . $lang->id] = $newLang->ID; unset($newLang); } } else { DB::query('INSERT INTO "SnippetLanguage" ("ID", "ClassName", "Created", "LastEdited", "Name", "FileExtension", "HighlightCode", "UserLanguage") ' . "VALUES(" . intval($lang->id) . ",'SnippetLanguage', '" . date('Y-m-d H:i:s') . "','" . date('Y-m-d H:i:s') . "','" . Convert::raw2sql($lang->language) . "','" . Convert::raw2sql($lang->file_extension) . "','" . Convert::raw2sql($lang->shjs_code) . "'," . intval($lang->user_language) . ")"); } } //Import Packages foreach ($fileData->data->packages as $pkg) { if (isset($data['AppendData'])) { $newPkg = new SnippetPackage(); $newPkg->Title = $pkg->title; $newPkg->write(); $pkgMap['pkg-' . $pkg->id] = $newPkg->ID; unset($newPkg); } else { DB::query('INSERT INTO "SnippetPackage" ("ID", "ClassName", "Created", "LastEdited", "Title") ' . "VALUES(" . intval($pkg->id) . ",'SnippetPackage', '" . date('Y-m-d H:i:s') . "','" . date('Y-m-d H:i:s') . "','" . Convert::raw2sql($pkg->title) . "')"); } } //Import Folders foreach ($fileData->data->folders as $folder) { if (isset($data['AppendData'])) { if (!isset($langMap['lang-' . $folder->fkLanguageId])) { if (DB::getConn()->supportsTransactions()) { DB::getConn()->transactionRollback(); } $form->sessionMessage(_t('CodeBank.IMPORT_LANG_NOT_FOUND', '_Import failed language not found'), 'bad'); return $this->redirectBack(); } $newFld = new SnippetFolder(); $newFld->Name = $folder->name; $newFld->ParentID = $folder->fkParentId > 0 && isset($folderMap['fld-' . $folder->fkParentId]) ? $folderMap['fld-' . $folder->fkParentId] : 0; $newFld->LanguageID = $langMap['lang-' . $folder->fkLanguageId]; $newFld->write(); $folderMap['fld-' . $folder->id] = $newFld->ID; unset($newFld); } else { DB::query('INSERT INTO "SnippetFolder" ("ID", "ClassName", "Created", "LastEdited", "Name", "ParentID", "LanguageID") ' . "VALUES(" . intval($folder->id) . ",'SnippetFolder', '" . date('Y-m-d H:i:s') . "','" . date('Y-m-d H:i:s') . "','" . Convert::raw2sql($folder->name) . "', " . intval($folder->fkParentId) . ", " . intval($folder->fkLanguageId) . ")"); } } //Import Snippets foreach ($fileData->data->snippets as $snip) { if (isset($data['AppendData'])) { if (!isset($langMap['lang-' . $snip->fkLanguage])) { if (DB::getConn()->supportsTransactions()) { DB::getConn()->transactionRollback(); } $form->sessionMessage(_t('CodeBank.IMPORT_LANG_NOT_FOUND', '_Import failed language not found'), 'bad'); return $this->redirectBack(); } $newSnip = new Snippet(); $newSnip->Title = $snip->title; $newSnip->Description = $snip->description; $newSnip->Tags = $snip->tags; $newSnip->LanguageID = $langMap['lang-' . $snip->fkLanguage]; $newSnip->CreatorID = Member::currentUserID(); $newSnip->LastEditorID = Member::currentUserID(); $newSnip->PackageID = $snip->fkPackageID > 0 && isset($pkgMap['pkg-' . $snip->fkPackageID]) ? $pkgMap['pkg-' . $snip->fkPackageID] : 0; $newSnip->FolderID = $snip->fkFolderID > 0 && isset($folderMap['fld-' . $snip->fkFolderID]) ? $folderMap['fld-' . $snip->fkFolderID] : 0; $newSnip->write(); $snipMap['snip-' . $snip->id] = $newSnip->ID; unset($newSnip); } else { DB::query('INSERT INTO "Snippet" ("ID", "ClassName", "Created", "LastEdited", "Title", "Description", "Tags", "LanguageID", "CreatorID", "LastEditorID", "PackageID", "FolderID") ' . "VALUES(" . intval($snip->id) . ",'Snippet', '" . date('Y-m-d H:i:s') . "','" . date('Y-m-d H:i:s') . "','" . Convert::raw2sql($snip->title) . "', '" . Convert::raw2sql($snip->description) . "', '" . Convert::raw2sql($snip->tags) . "', " . intval($snip->fkLanguage) . ", " . Member::currentUserID() . ", " . Member::currentUserID() . ", " . intval($snip->fkPackageID) . ", " . intval($snip->fkFolderID) . ")"); } } //Import Snippet Versions foreach ($fileData->data->versions as $ver) { if (isset($data['AppendData'])) { if (!isset($snipMap['snip-' . $ver->fkSnippit])) { if (DB::getConn()->supportsTransactions()) { DB::getConn()->transactionRollback(); } $form->sessionMessage(_t('CodeBank.IMPORT_SNIP_NOT_FOUND', '_Import failed snippet not found'), 'bad'); return $this->redirectBack(); } DB::query('INSERT INTO "SnippetVersion" ("ClassName", "Created", "LastEdited", "Text", "ParentID") ' . "VALUES('SnippetVersion', '" . Convert::raw2sql($ver->date) . "','" . Convert::raw2sql($ver->date) . "','" . Convert::raw2sql($ver->text) . "', " . intval($snipMap['snip-' . $ver->fkSnippit]) . ")"); } else { DB::query('INSERT INTO "SnippetVersion" ("ID", "ClassName", "Created", "LastEdited", "Text", "ParentID") ' . "VALUES(" . intval($ver->id) . ",'SnippetVersion', '" . Convert::raw2sql($ver->date) . "','" . Convert::raw2sql($ver->date) . "','" . Convert::raw2sql($ver->text) . "', " . intval($ver->fkSnippit) . ")"); } } //End transaction if supported if (DB::getConn()->supportsTransactions()) { DB::getConn()->transactionEnd(); } //Display success after redirecting back Session::set('reloadOnImportDialogClose', true); $form->sessionMessage(_t('CodeBank.IMPORT_COMPLETE', '_Import Completed'), 'good'); return $this->redirectBack(); }