/**
* Deletes a package
* @param {stdClass} $data Data passed from ActionScript
* @return {array} Standard response base
*/
public function deletePackage($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;
}
$package = SnippetPackage::get()->byID(intval($data->id));
if (!empty($package) && $package !== false && $package->ID != 0) {
$package->delete();
$response['status'] = 'HELO';
} else {
$response['status'] = 'EROR';
$response['message'] = _t('CodeBankAPI.PACKAGE_NOT_FOUND', '_Package not found');
}
return $response;
}
/**
* Gets fields used in the cms
* @return {FieldList} Fields to be used
*/
public function getCMSFields()
{
$langGridConfig = GridFieldConfig_RecordEditor::create(30);
$langGridConfig->getComponentByType('GridFieldDetailForm')->setItemRequestClass('CodeBankGridField_ItemRequest');
$langGridConfig->getComponentByType('GridFieldDataColumns')->setFieldCasting(array('UserLanguage' => 'Boolean->Nice', 'Hidden' => 'Boolean->Nice'));
$packageGridConfig = GridFieldConfig_RecordEditor::create(30);
$packageGridConfig->addComponent(new ExportPackageButton());
$packageGridConfig->getComponentByType('GridFieldDetailForm')->setItemRequestClass('CodeBankGridField_ItemRequest')->setItemEditFormCallback(function (Form $form, GridFieldDetailForm_ItemRequest $itemRequest) {
Requirements::javascript(CB_DIR . '/javascript/SnippetPackages.ItemEditForm.js');
if ($form->getRecord() && $form->getRecord()->ID > 0) {
$form->Actions()->push(FormAction::create('doExportPackage', _t('CodeBank.EXPORT', '_Export'))->setForm($form));
}
$form->addExtraClass('CodeBankPackages');
});
if (Permission::check('ADMIN')) {
$fields = new FieldList(new TabSet('Root', new Tab('Main', _t('CodeBankConfig.MAIN', '_IP Message'), HtmlEditorField::create('IPMessage', _t('CodeBankConfig.IP_MESSAGE', '_Intellectual Property Message'))->addExtraClass('stacked')), new Tab('Languages', _t('CodeBankConfig.LANGUAGES', '_Languages'), new GridField('Languages', _t('CodeBankConfig.LANGUAGES', '_Languages'), SnippetLanguage::get(), $langGridConfig)), new Tab('Packages', _t('CodeBank.PACKAGES', '_Packages'), new GridField('Packages', _t('CodeBankConfig.MANAGE_PACKAGES', '_Manage Packages'), SnippetPackage::get(), $packageGridConfig))));
} else {
$fields = new FieldList(new TabSet('Root', new Tab('Packages', _t('CodeBank.PACKAGES', '_Packages'), new GridField('Packages', _t('CodeBankConfig.MANAGE_PACKAGES', '_Manage Packages'), SnippetPackage::get(), $packageGridConfig))));
}
return $fields;
}
/**
* 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();
}
/**
* Return children from the stage site
*
* @param showAll Inlcude all of the elements, even those not shown in the menus.
* (only applicable when extension is applied to {@link SiteTree}).
* @return SS_List
*/
public function stageChildren($showAll = false)
{
$baseClass = ClassInfo::baseDataClass($this->owner->class);
if ($baseClass == 'SnippetPackage') {
if ($this->owner->ID == 0) {
$staged = SnippetPackage::get();
}
} else {
if ($baseClass == 'SnippetLanguage') {
if ($this->owner->ID == 0) {
$staged = SnippetLanguage::get();
} else {
$staged = ArrayList::create(array_merge($this->owner->Folders()->toArray(), $this->owner->Snippets()->filter('FolderID', 0)->toArray()));
}
} else {
if ($baseClass == 'SnippetFolder') {
$staged = ArrayList::create(array_merge($this->owner->Folders()->toArray(), $this->owner->Snippets()->toArray()));
} else {
$staged = new ArrayList();
}
}
}
$this->owner->extend("augmentStageChildren", $staged, $showAll);
return $staged;
}
/**
* Gets fields used in the cms
* @return {FieldList} Fields to be used
*/
public function getCMSFields()
{
$fields = new FieldList(new TabSet('Root', new Tab('Main', _t('Snippet.MAIN', '_Main'), DropdownField::create('LanguageID', _t('Snippet.LANGUAGE', '_Language'), SnippetLanguage::get()->where('"SnippetLanguage"."Hidden"=0 OR "SnippetLanguage"."ID"=' . ($this->LanguageID ? $this->LanguageID : 0))->map('ID', 'Title'))->setEmptyString('---'), new TextField('Title', _t('Snippet.TITLE', '_Title'), null, 300), TextareaField::create('Description', _t('Snippet.DESCRIPTION', '_Description'))->setRows(5), PackageSelectionField::create('PackageID', _t('Snippet.PACKAGE', '_Package'), SnippetPackage::get()->map('ID', 'Title'))->setEmptyString(_t('Snippet.NOT_IN_PACKAGE', '_Not Part of a Package')), TextareaField::create('Text', _t('Snippet.CODE', '_Code'), $this->getSnippetText())->setRows(30)->addExtraClass('codeBankFullWidth')->addExtraClass('stacked'), TextareaField::create('Tags', _t('Snippet.TAGS', '_Tags (comma separate)'))->setRows(2))));
return $fields;
}
