public function run($mode = 'test')
{
$testMode = $mode == 'test';
$message = "";
$projectlist = new ProjectListModel();
$projectlist->read();
$projectIds = array_map(function ($e) {
return $e['id'];
}, $projectlist->entries);
$projectsChanged = 0;
foreach ($projectlist->entries as $projectParams) {
// foreach existing project
$projectId = $projectParams['id'];
$project = new ProjectModel($projectId);
if ($project->siteName == '') {
$sfproject = new SfchecksProjectModel($projectId);
$sfproject->themeName = "jamaicanpsalms";
$message .= "Changed the " . $sfproject->projectName . " to be a sfchecks/scriptureforge project with jamaican psalms theme\n";
if (!$testMode) {
$sfproject->write();
}
$projectsChanged++;
}
}
if ($projectsChanged > 0) {
$message .= "\n\nChanged {$projectsChanged} projects to be of sfchecks type under scriptureforge and jamaicanpsalms theme \n\n";
} else {
$message .= "\n\nNo projects were found/changed \n\n";
}
return $message;
}
/**
* Create or update project
* @param string $projectId
* @param string $userId
* @param array<projectModel> $object
* @throws UserUnauthorizedException
* @throws \Exception
* @return string projectId
*/
public static function updateProject($projectId, $userId, $object)
{
$project = new SfchecksProjectModel($projectId);
if (!$project->hasRight($userId, Domain::USERS + Operation::EDIT)) {
throw new UserUnauthorizedException("Insufficient privileges to update project in method 'updateProject'");
}
$oldDBName = $project->databaseName();
$object['id'] = $projectId;
JsonDecoder::decode($project, $object);
$newDBName = $project->databaseName();
if ($oldDBName != '' && $oldDBName != $newDBName) {
if (MongoStore::hasDB($newDBName)) {
throw new \Exception("Cannot rename '{$oldDBName}' to '{$newDBName}'. New project name {$newDBName} already exists. Not renaming.");
}
MongoStore::renameDB($oldDBName, $newDBName);
}
$projectId = $project->write();
return $projectId;
}
public function run($mode = 'test')
{
$testMode = $mode != 'run';
$message = "";
$templateList = new GlobalQuestionTemplateListModel();
$templateList->read();
if (count($templateList->entries) > 0) {
} else {
$message .= "There are no global templates to migrate\n\n";
}
$templatesMoved = 0;
$projectlist = new ProjectListModel();
$projectlist->read();
$project = null;
foreach ($projectlist->entries as $projectParams) {
// foreach existing project
$projectId = $projectParams['id'];
$p = new SfchecksProjectModel($projectId);
if ($p->databaseName() == 'sf_jamaican_psalms') {
$project = $p;
}
}
if (!is_null($project)) {
$message .= "Migrating global templates to the '" . $project->projectName . "' project\n\n";
foreach ($templateList->entries as $globalTemplate) {
$template = new QuestionTemplateModel($project);
$template->title = $globalTemplate['title'];
$template->description = $globalTemplate['description'];
$message .= "Moving '" . $template->title . "'\n";
if (!$testMode) {
$template->write();
$gt = new GlobalQuestionTemplateModel($globalTemplate['id']);
$gt->remove();
}
$templatesMoved++;
}
$message .= "\n\nMoved {$templatesMoved} global templates to the specified project\n\n";
} else {
$message .= "Error: cound not find the Jamaican Psalms project on this server\n\n";
}
return $message;
}
/**
* @param string $projectId
* @param string $userId
* @returns array - the DTO array
*/
public static function encode($projectId, $userId)
{
$userModel = new UserModel($userId);
$projectModel = new SfchecksProjectModel($projectId);
$textList = new TextListModel($projectModel);
$textList->read();
$list = $projectModel->listUsers();
$data = array();
$data['count'] = count($list->entries);
$data['entries'] = array_values($list->entries);
// re-index array
$data['project'] = ProjectSettingsDtoEncoder::encode($projectModel);
unset($data['project']['users']);
$data['archivedTexts'] = array();
foreach ($textList->entries as $entry) {
$textModel = new TextModel($projectModel, $entry['id']);
if ($textModel->isArchived) {
$questionList = $textModel->listQuestionsWithAnswers();
// Just want count of questions and responses, not whole list
$entry['questionCount'] = $questionList->count;
$responseCount = 0;
// "Responses" = answers + comments
foreach ($questionList->entries as $q) {
foreach ($q['answers'] as $a) {
$commentCount = count($a['comments']);
$responseCount += $commentCount + 1;
// +1 for this answer
}
}
$entry['responseCount'] = $responseCount;
$entry['dateModified'] = $textModel->dateModified->format(\DateTime::RFC2822);
$data['archivedTexts'][] = $entry;
}
}
$data['rights'] = RightsHelper::encode($userModel, $projectModel);
$data['bcs'] = BreadCrumbHelper::encode('settings', $projectModel, null, null);
return $data;
}
public function run($mode = 'test')
{
$testMode = $mode != 'run';
$message = "";
$projectlist = new ProjectListModel();
$projectlist->read();
$textsExamined = 0;
$textsUpdated = 0;
// foreach existing project
foreach ($projectlist->entries as $projectParams) {
$projectId = $projectParams['id'];
if ($projectParams['projectName'] == 'Jamaican Psalms') {
$project = new SfchecksProjectModel($projectId);
$textlist = new TextListModel($project);
$textlist->read();
// foreach text in project
foreach ($textlist->entries as $textParams) {
$textsExamined++;
$textId = $textParams['id'];
$legacyText = new TextModel_sf_v0_9_18($project, $textId);
$fileName = '';
if ($legacyText->audioUrl) {
$text = new TextModel($project, $textId);
if (!$testMode) {
if (!$text->audioFileName) {
// legacy audioUrl format "assets/<projectId>/<textId>_<fileName>"
$fileNamePrefix = $textId . '_';
$pos = strpos($legacyText->audioUrl, $fileNamePrefix);
$text->audioFileName = substr($legacyText->audioUrl, $pos + strlen($fileNamePrefix));
}
$text->write();
}
$message .= "Changed text: {$text->title}\n";
$textsUpdated++;
}
}
if (!$testMode) {
TextModel_sf_v0_9_18::removeAudioProperty($project->databaseName());
$message .= "Removed 'audioUrl' property from project: {$project->projectName}\n";
}
}
}
if ($textsUpdated > 0) {
$message .= "\n\nChanged {$textsUpdated} legacy texts to only store audio filename\n\n";
} else {
$message .= "\n\nNo legacy text audio were found/changed. {$textsExamined} texts examined.\n\n";
}
// re-arrange assets folder
// - remove <siteName> from path for LF
// - add <appName> to path for SF and change <projectId> in path to <projectSlug (databaseName)>
$message .= "\n\nRe-arrange assets folder\n~~~~~~~~~~~~~~~~~~~~~~~~\n\n";
$project = new SfchecksProjectModel();
$assetsFolderPath = APPPATH . "assets";
$assetsSubfolders = glob($assetsFolderPath . '/*');
@mkdir($assetsFolderPath . '/lexicon');
@mkdir($assetsFolderPath . '/sfchecks');
foreach ($assetsSubfolders as $assetsSubfolder) {
if (file_exists($assetsSubfolder) && is_dir($assetsSubfolder)) {
$assetsSubfolderName = basename($assetsSubfolder);
if (strpos($assetsSubfolderName, 'languageforge') !== false) {
$message .= "Move into lexicon: {$assetsSubfolderName}\n";
$oldFolderPath = $assetsSubfolder . '/lexicon';
$newFolderPath = $assetsFolderPath . '/lexicon';
} elseif ($assetsSubfolderName == 'lexicon' || $assetsSubfolderName == 'sfchecks') {
$message .= "No change: {$assetsSubfolderName}\n";
$oldFolderPath = '';
$newFolderPath = '';
$assetsSubfolder = '';
} elseif ($project->exists($assetsSubfolderName)) {
$message .= "Move into sfchecks: {$assetsSubfolderName}\n";
$oldFolderPath = $assetsSubfolder;
$project->read($assetsSubfolderName);
$projectSlug = $project->databaseName();
$newFolderPath = $assetsFolderPath . "/sfchecks/{$projectSlug}";
if (!$testMode) {
}
} else {
$message .= "Delete: {$assetsSubfolderName}\n";
$oldFolderPath = '';
$newFolderPath = '';
}
if (!$testMode) {
if (file_exists($oldFolderPath) && is_dir($oldFolderPath)) {
if (!@rename($oldFolderPath, $newFolderPath)) {
$oldFiles = glob($oldFolderPath . '/*');
foreach ($oldFiles as $oldFile) {
$newFile = $newFolderPath . '/' . basename($oldFile);
rename($oldFile, $newFile);
}
}
}
if (file_exists($assetsSubfolder) && is_dir($assetsSubfolder)) {
$this->recursiveRemoveFolder($assetsSubfolder);
}
}
}
}
return $message;
}
public function testGetRightsArray_Ok()
{
$userId = MongoTestEnvironment::mockId();
$project = new SfchecksProjectModel();
$project->addUser($userId, ProjectRoles::MANAGER);
$result = $project->getRightsArray($userId);
$this->assertIsA($result, 'array');
$this->assertTrue(in_array(Domain::QUESTIONS + Operation::CREATE, $result));
}
/**
* Upload a file
*
* @param string $projectId
* @param string $mediaType
* @param string $tmpFilePath
* @throws \Exception
* @return \Api\Model\Shared\Command\UploadResponse
*/
public static function uploadFile($projectId, $mediaType, $tmpFilePath)
{
if ($mediaType != 'audio') {
throw new \Exception("Unsupported upload type: {$mediaType}");
}
if (!$tmpFilePath) {
throw new \Exception("Upload controller did not move the uploaded file.");
}
$textId = $_POST['textId'];
$file = $_FILES['file'];
$fileName = $file['name'];
$finfo = finfo_open(FILEINFO_MIME_TYPE);
$fileType = finfo_file($finfo, $tmpFilePath);
finfo_close($finfo);
$fileName = FileUtilities::replaceSpecialCharacters($fileName);
$fileExt = false === ($pos = strrpos($fileName, '.')) ? '' : substr($fileName, $pos);
// allowed types: documented, observed
$allowedTypes = array("audio/mpeg", "audio/mp3");
$allowedExtensions = array(".mp3");
$response = new UploadResponse();
if (in_array(strtolower($fileType), $allowedTypes) && in_array(strtolower($fileExt), $allowedExtensions)) {
// make the folders if they don't exist
$project = new SfchecksProjectModel($projectId);
$folderPath = $project->getAssetsFolderPath();
FileUtilities::createAllFolders($folderPath);
// cleanup previous files of any allowed extension
self::cleanupFiles($folderPath, $textId, $allowedExtensions);
// move uploaded file from tmp location to assets
$filePath = self::mediaFilePath($folderPath, $textId, $fileName);
$moveOk = copy($tmpFilePath, $filePath);
@unlink($tmpFilePath);
// update database with file location
$text = new TextModel($project, $textId);
$text->audioFileName = '';
if ($moveOk) {
$text->audioFileName = $fileName;
}
$text->write();
// construct server response
if ($moveOk && $tmpFilePath) {
$data = new MediaResult();
$data->path = $project->getAssetsRelativePath();
$data->fileName = $fileName;
$response->result = true;
} else {
$data = new ErrorResult();
$data->errorType = 'UserMessage';
$data->errorMessage = "{$fileName} could not be saved to the right location. Contact your Site Administrator.";
$response->result = false;
}
} else {
$allowedExtensionsStr = implode(", ", $allowedExtensions);
$data = new ErrorResult();
$data->errorType = 'UserMessage';
if (count($allowedExtensions) < 1) {
$data->errorMessage = "{$fileName} is not an allowed audio file. No audio file formats are currently enabled, contact your Site Administrator.";
} elseif (count($allowedExtensions) == 1) {
$data->errorMessage = "{$fileName} is not an allowed audio file. Ensure the file is a {$allowedExtensionsStr}.";
} else {
$data->errorMessage = "{$fileName} is not an allowed audio file. Ensure the file is one of the following types: {$allowedExtensionsStr}.";
}
$response->result = false;
}
$response->data = $data;
return $response;
}
