function Websites_0_8_4_Streams_mysql()
{
$app = Q_Config::expect('Q', 'app');
// allow inserting images in articles
$r = new Streams_RelatedTo();
$r->toPublisherId = $app;
$r->toStreamName = 'Websites/article/';
$r->type = 'images';
$r->fromPublisherId = $app;
$r->fromStreamName = 'Streams/image/';
$r->save();
}
function Streams_0_8_6_Streams_mysql()
{
$app = Q_Config::expect('Q', 'app');
// access for managing communities
$access = new Streams_Access();
$access->publisherId = $app;
$access->streamName = 'Streams/community*';
$access->ofUserId = '';
$access->ofContactLabel = "{$app}/admins";
$access->readLevel = Streams::$READ_LEVEL['messages'];
$access->writeLevel = Streams::$WRITE_LEVEL['edit'];
$access->adminLevel = Streams::$ADMIN_LEVEL['manage'];
$access->save();
// access for managing categories
$access = new Streams_Access();
$access->publisherId = $app;
$access->streamName = 'Streams/category/';
$access->ofUserId = '';
$access->ofContactLabel = "{$app}/admins";
$access->readLevel = Streams::$READ_LEVEL['messages'];
$access->writeLevel = Streams::$WRITE_LEVEL['close'];
$access->adminLevel = Streams::$ADMIN_LEVEL['manage'];
$access->save();
// template to help users relate things to Streams/category streams
Streams_Stream::insert(array('publisherId' => '', 'name' => 'Streams/category/', 'type' => 'Streams/template', 'title' => 'Untitled Category', 'icon' => 'Streams/category', 'content' => '', 'attributes' => null, 'readLevel' => Streams::$READ_LEVEL['messages'], 'writeLevel' => Streams::$WRITE_LEVEL['relate'], 'adminLevel' => Streams::$ADMIN_LEVEL['invite']))->execute();
// template to help users create subcategories for things
Streams_RelatedTo::insert(array('toPublisherId' => '', 'toStreamName' => 'Streams/category/', 'type' => 'subcategories', 'fromPublisherId' => '', 'fromStreamName' => 'Streams/category/'))->execute();
}
function Websites_0_9_1_Streams_mysql()
{
$userId = Users::communityId();
$ofUserId = '';
$ofContactLabel = 'Websites/admins';
$grantedByUserId = null;
$streams = array("Websites/presentation/" => array('type' => "Streams/template", "title" => "Untitled Presentation", "icon" => "{{baseUrl}}/plugins/Websites/img/icons/Websites/presentation", "content" => "", "deletable" => true), "Websites/slide/" => array('type' => "Streams/template", "title" => "Untitled Slide", "icon" => "{{baseUrl}}/plugins/Websites/img/icons/Websites/presentation", "content" => "", "deletable" => true));
$readLevel = Streams::$READ_LEVEL['messages'];
$adminLevel = Streams::$ADMIN_LEVEL['own'];
$rows = array();
foreach ($streams as $streamName => $stream) {
$publisherId = substr($streamName, -1) == '/' ? '' : $userId;
$level = !empty($stream['deletable']) ? 'close' : 'edit';
$writeLevel = Streams::$WRITE_LEVEL[!empty($stream['deletable']) ? 'close' : 'edit'];
$rows[] = compact('publisherId', 'streamName', 'ofUserId', 'ofContactLabel', 'grantedByUserId', 'readLevel', 'writeLevel', 'adminLevel');
}
Streams_Access::insertManyAndExecute($rows);
$attributes = null;
$closedTime = null;
$readLevel = Streams::$READ_LEVEL['messages'];
$writeLevel = Streams::$WRITE_LEVEL['join'];
$adminLevel = Streams::$ADMIN_LEVEL['invite'];
$inheritAccess = null;
$rows = array();
foreach ($streams as $name => $s) {
extract($s);
$publisherId = substr($name, -1) == '/' ? '' : $userId;
$rows[] = compact('publisherId', 'name', 'type', 'title', 'icon', 'content', 'attributes', 'readLevel', 'writeLevel', 'adminLevel', 'inheritAccess');
}
Streams_Stream::insertManyAndExecute($rows);
Streams_RelatedTo::insert(array('toPublisherId' => '', 'toStreamName' => 'Websites/presentation/', 'type' => 'slides', 'fromPublisherId' => '', 'fromStreamName' => 'Websites/slide/'))->execute();
}
function Streams_after_Streams_message_Streams_relatedTo($params)
{
$message = $params['message'];
$type = $message->getInstruction('type', null);
$stream = $params['stream'];
$rtypes = Q_Config::get('Streams', 'categorize', 'relationTypes', array());
$stypes = Q_Config::get('Streams', 'categorize', 'streamTypes', array());
if (!in_array($type, $rtypes) or !in_array($stream->type, $stypes)) {
return;
}
$c = new Streams_Category();
$c->publisherId = $stream->publisherId;
$c->streamName = $stream->name;
$fromPublisherId = $message->getInstruction('fromPublisherId', null);
$fromStreamName = $message->getInstruction('fromStreamName', null);
if (!isset($fromPublisherId) or !isset($fromStreamName)) {
return;
}
// Begin database transaction
$relatedTo = $c->retrieve(null, array('ignoreCache' => true, 'begin' => true)) ? json_decode($c->relatedTo, true) : array();
$weight = (double) $message->getInstruction('weight', null);
if (!isset($weight)) {
$rt = new Streams_RelatedTo();
$rt->toPublisherId = $stream->publisherId;
$rt->toStreamName = $stream->name;
$rt->type = $type;
$rt->fromPublisherId = $fromPublisherId;
$rt->fromStreamName = $fromStreamName;
$rt->retrieve(null, null, array('ignoreCache' => true));
$weight = $rt->weight;
}
$fs = Streams::fetchOne($message->byUserId, $fromPublisherId, $fromStreamName);
$weight = floor($weight);
$relatedTo[$type][$weight] = array($fromPublisherId, $fromStreamName, $fs->title, $fs->icon);
$c->relatedTo = Q::json_encode($relatedTo);
$c->save(false, true);
// End database transaction
}
function Websites_0_8_Streams_mysql()
{
$userId = Q_Config::get("Websites", "user", "id", null);
if (!$userId) {
throw new Q_Exception('Websites: Please fill in the config field "Websites"/"user"/"id"');
}
// $now = Streams::db()->toDateTime(Streams::db()->getCurrentTimestamp());
$ofUserId = '';
$ofContactLabel = 'Websites/admins';
$grantedByUserId = null;
$streams = array("Streams/images/" => array('type' => "Streams/template", "title" => "Images", "icon" => "default", "content" => "", "deletable" => true), "Streams/image/" => array('type' => "Streams/template", "title" => "Untitled Image", "icon" => "Streams/image", "content" => "", "deletable" => true), "Streams/file/" => array('type' => "Streams/template", "title" => "Untitled File", "icon" => "files/_blank", "content" => "", "deletable" => true), "Websites/article/" => array('type' => "Streams/template", "title" => "Untitled Article", "icon" => "default", "content" => "", "deletable" => true), "Websites/seo/" => array('type' => "Streams/template", "title" => "Website SEO", "icon" => Q_Html::themedUrl("plugins/Websites/img/seo"), "content" => "", "deletable" => true), "Websites/header" => array('type' => "Streams/image/icon", "title" => "Header image", "icon" => Q_Html::themedUrl("plugins/Websites/img/header"), "content" => ""), "Websites/slogan" => array('type' => "Streams/text/small", "title" => "Website slogan", "icon" => "default", "content" => "The coolest website"), "Websites/title" => array('type' => "Streams/text/small", "title" => "Website title", "icon" => "default", "content" => "Website Title"), "Websites/menu" => array('type' => "Streams/category", "title" => "Website Menu", "icon" => "default", "content" => ""), "Websites/articles" => array('type' => "Streams/category", "title" => "Articles", "icon" => "default", "content" => "Articles"), "Websites/images" => array('type' => "Streams/category", "title" => "Images", "icon" => "default", "content" => "Articles"));
$readLevel = Streams::$READ_LEVEL['messages'];
$writeLevel = Streams::$WRITE_LEVEL['edit'];
$adminLevel = Streams::$ADMIN_LEVEL['own'];
$rows = array();
foreach ($streams as $streamName => $stream) {
$publisherId = substr($streamName, -1) == '/' ? '' : $userId;
$writeLevel = !empty($stream['deletable']) ? 40 : 30;
$rows[] = compact('publisherId', 'streamName', 'ofUserId', 'ofContactLabel', 'grantedByUserId', 'readLevel', 'writeLevel', 'adminLevel');
}
Streams_Access::insertManyAndExecute($rows);
$attributes = null;
$closedTime = null;
$readLevel = Streams::$READ_LEVEL['messages'];
$writeLevel = Streams::$WRITE_LEVEL['join'];
$adminLevel = Streams::$ADMIN_LEVEL['invite'];
$inheritAccess = null;
$rows = array();
foreach ($streams as $name => $s) {
extract($s);
if (substr($name, 0, 9) != 'Websites/') {
continue;
// this tempate was already added by Streams install script
}
$publisherId = substr($name, -1) == '/' ? '' : $userId;
$rows[] = compact('publisherId', 'name', 'type', 'title', 'icon', 'content', 'attributes', 'readLevel', 'writeLevel', 'adminLevel', 'inheritAccess');
}
Streams_Stream::insertManyAndExecute($rows);
Streams_RelatedTo::insert(array('toPublisherId' => '', 'toStreamName' => 'Streams/images/', 'type' => 'images', 'fromPublisherId' => '', 'fromStreamName' => 'Streams/image/'))->execute();
Streams_RelatedTo::insert(array('toPublisherId' => '', 'toStreamName' => 'Streams/category/', 'type' => 'articles', 'fromPublisherId' => '', 'fromStreamName' => 'Websites/article/'))->execute();
Streams_RelatedTo::insert(array('toPublisherId' => '', 'toStreamName' => 'Streams/category/', 'type' => 'announcements', 'fromPublisherId' => '', 'fromStreamName' => 'Websites/article/'))->execute();
}
/**
* Updates the weight on a relation
* @param {string} $asUserId
* The id of the user on whose behalf the app will be updating the relation
* @param {string} $toPublisherId
* The publisher of the stream on the 'to' end of the reltion
* @param {string} $toStreamName
* The name of the stream on the 'to' end of the relation
* @param {string} $type
* The type of the relation
* @param {string} $fromPublisherId
* The publisher of the stream on the 'from' end of the reltion
* @param {string} $fromStreamName
* The name of the stream on the 'from' end of the reltion
* @param {double} $weight
* The new weight
* @param {double} $adjustWeights=null
* The amount to move the other weights by, to make room for this one
* @param {array} $options=array()
* An array of options that can include:
* "skipAccess" => Defaults to false. If true, skips the access checks and just updates the weight on the relation
* @return {array|boolean}
* Returns false if the operation was canceled by a hook
* Otherwise returns array with key "to" and value of type Streams_Message
*/
static function updateRelation($asUserId, $toPublisherId, $toStreamName, $type, $fromPublisherId, $fromStreamName, $weight, $adjustWeights = null, $options = array())
{
self::getRelation($asUserId, $toPublisherId, $toStreamName, $type, $fromPublisherId, $fromStreamName, $relatedTo, $relatedFrom, $category, $stream, $options);
if (!$relatedTo->retrieve()) {
throw new Q_Exception_MissingRow(array('table' => 'relatedTo', 'criteria' => 'with those fields'), array('publisherId', 'name', 'type', 'toPublisherId', 'to_name'));
}
// if (!$relatedFrom->retrieve()) {
// throw new Q_Exception_MissingRow(
// array('table' => 'relatedFrom', 'criteria' => 'those fields'),
// array('publisherId', 'name', 'type', 'fromPublisherId', 'from_name')
// );
// }
if (empty($options['skipAccess'])) {
if (!$category->testWriteLevel('relations')) {
throw new Users_Exception_NotAuthorized();
}
}
/**
* @event Streams/updateRelation/$streamType {before}
* @param {string} relatedTo
* @param {string} relatedFrom
* @param {string} asUserId
* @param {double} weight
* @param {double} previousWeight
*/
$previousWeight = $relatedTo->weight;
$adjustWeightsBy = $weight < $previousWeight ? $adjustWeights : -$adjustWeights;
if (Q::event("Streams/updateRelation/{$stream->type}", compact('relatedTo', 'relatedFrom', 'type', 'weight', 'previousWeight', 'adjustWeightsBy', 'asUserId'), 'before') === false) {
return false;
}
if (!empty($adjustWeights) and is_numeric($adjustWeights) and $weight !== $previousWeight) {
$criteria = array('toPublisherId' => $toPublisherId, 'toStreamName' => $toStreamName, 'type' => $type, 'weight' => $weight < $previousWeight ? new Db_Range($weight, true, false, $previousWeight) : new Db_Range($previousWeight, false, true, $weight));
Streams_RelatedTo::update()->set(array('weight' => new Db_Expression("weight + " . $adjustWeightsBy)))->where($criteria)->execute();
}
$relatedTo->weight = $weight;
$relatedTo->save();
// Send Streams/updatedRelateTo message to the category stream
// node server will be notified by Streams_Message::post
$message = Streams_Message::post($asUserId, $toPublisherId, $toStreamName, array('type' => 'Streams/updatedRelateTo', 'instructions' => Q::json_encode(compact('fromPublisherId', 'fromStreamName', 'type', 'weight', 'previousWeight', 'adjustWeightsBy', 'asUserId'))), true);
// TODO: We are not yet sending Streams/updatedRelateFrom message to the other stream
// because we might be changing a lot of weights, and we'd have to message a lot of streams.
// This is better done in the background using Node.js after selecting using $criteria
// When we implement this, we can introduce weight again in the relatedFrom table.
/**
* @event Streams/updateRelation/$streamType {after}
* @param {string} relatedTo
* @param {string} relatedFrom
* @param {string} asUserId
* @param {double} weight
* @param {double} previousWeight
*/
Q::event("Streams/updateRelation/{$stream->type}", compact('relatedTo', 'relatedFrom', 'type', 'weight', 'previousWeight', 'adjustWeightsBy', 'asUserId'), 'after');
return $message;
}
/**
* Updates the weight on a relation
* @param {string} $asUserId
* The id of the user on whose behalf the app will be updating the relation
* @param {string} $toPublisherId
* The publisher of the stream on the 'to' end of the reltion
* @param {string} $toStreamName
* The name of the stream on the 'to' end of the relation
* @param {string} $type
* The type of the relation
* @param {string} $fromPublisherId
* The publisher of the stream on the 'from' end of the reltion
* @param {string} $fromStreamName
* The name of the stream on the 'from' end of the reltion
* @param {double} $weight
* The new weight
* @param {double} [$adjustWeights=1]
* The amount to move the other weights by, to make room for this one.
* This should be a positive number - the direction of the shift is determined automatically.
* Or, set to 0 to prevent moving the other weights.
* @param {array} $options=array()
* @param {boolean} [$options.skipAccess=false] If true, skips the access checks and just unrelates the stream from the category
* @return {array|boolean}
* Returns false if the operation was canceled by a hook
* Otherwise returns array with key "to" and value of type Streams_Message
*/
static function updateRelation($asUserId, $toPublisherId, $toStreamName, $type, $fromPublisherId, $fromStreamName, $weight, $adjustWeights = 1, $options = array())
{
self::getRelations($asUserId, $toPublisherId, $toStreamName, $type, $fromPublisherId, $fromStreamName, $relatedTo, $relatedFrom, $categories, $streams, $arrayField, $options);
$relatedTo = reset($relatedTo);
$relatedFrom = reset($relatedFrom);
$category = reset($categories);
$stream = reset($streams);
if (!$relatedTo) {
throw new Q_Exception_MissingRow(array('table' => 'relatedTo', 'criteria' => 'with those fields'), array('publisherId', 'name', 'type', 'toPublisherId', 'to_name'));
}
// if (!$relatedFrom->retrieve()) {
// throw new Q_Exception_MissingRow(
// array('table' => 'relatedFrom', 'criteria' => 'those fields'),
// array('publisherId', 'name', 'type', 'fromPublisherId', 'from_name')
// );
// }
if (empty($options['skipAccess'])) {
if (!$category->testWriteLevel('relations')) {
throw new Users_Exception_NotAuthorized();
}
}
/**
* @event Streams/updateRelation/$streamType {before}
* @param {string} relatedTo
* @param {string} relatedFrom
* @param {string} asUserId
* @param {double} weight
* @param {double} previousWeight
*/
$previousWeight = $relatedTo->weight;
if (empty($adjustWeights)) {
$adjustWeights = 0;
}
if (!is_numeric($adjustWeights) or $adjustWeights < 0) {
throw new Q_Exception_WrongType(array('fields' => 'adjustWeights', 'type' => 'a non-negative number'));
}
$adjustWeightsBy = $weight < $previousWeight ? $adjustWeights : -$adjustWeights;
if (Q::event("Streams/updateRelation/{$stream->type}", compact('relatedTo', 'relatedFrom', 'type', 'weight', 'previousWeight', 'adjustWeightsBy', 'asUserId'), 'before') === false) {
return false;
}
if ($adjustWeights and $weight !== $previousWeight) {
$criteria = array('toPublisherId' => $toPublisherId, 'toStreamName' => $toStreamName, 'type' => $type, 'weight' => $weight < $previousWeight ? new Db_Range($weight, true, false, $previousWeight) : new Db_Range($previousWeight, false, true, $weight));
Streams_RelatedTo::update()->set(array('weight' => new Db_Expression("weight + " . $adjustWeightsBy)))->where($criteria)->execute();
}
$relatedTo->weight = $weight;
$relatedTo->save();
// Send Streams/updatedRelateTo message to the category stream
// node server will be notified by Streams_Message::post
$message = Streams_Message::post($asUserId, $toPublisherId, $toStreamName, array('type' => 'Streams/updatedRelateTo', 'instructions' => compact('fromPublisherId', 'fromStreamName', 'type', 'weight', 'previousWeight', 'adjustWeightsBy', 'asUserId')), true);
/**
* @event Streams/updateRelation/$categoryType {after}
* @param {string} relatedTo
* @param {string} relatedFrom
* @param {string} asUserId
* @param {double} weight
* @param {double} previousWeight
*/
Q::event("Streams/updateRelation/{$category->type}", compact('relatedTo', 'relatedFrom', 'type', 'weight', 'previousWeight', 'adjustWeightsBy', 'asUserId'), 'after');
return $message;
}
/**
* Get current relation of shipment stream to Shipping/shipments category stream
* @method getShipmentRelation
* @static
* @param object $stream shipment stream object
* @param boolean $returnTitle flag which define what to return, if true - return relation title from config, else - return value from DB
* @return string
*/
static function getShipmentRelation($stream, $returnTitle = false)
{
$env = self::getVars();
$type = Streams_RelatedTo::select(array("type"))->where(array('toPublisherId' => $env->communityId, 'toStreamName' => $env->shipmentsStreamName, 'fromPublisherId' => $stream->publisherId, 'fromStreamName' => $stream->name))->execute()->fetchAll(PDO::FETCH_ASSOC)[0]["type"];
if (!$returnTitle) {
return $type;
}
$states = Q_Config::expect('Shipping', 'states');
foreach ($states as $state) {
if ($state["type"] == $type) {
return $state["title"];
}
}
}
