Пример #1
0
 /**
  * Given a set of content items, this method will persist
  * them to the data store, if they already exists then this
  * method should update the values in the data store.
  *
  * @param \Swiftriver\Core\ObjectModel\Content[] $content
  */
 public static function SaveContent($content)
 {
     //initiate the redbean dal contoller
     $rb = RedBeanController::RedBean();
     //loop throught each oitem of content
     foreach ($content as $item) {
         $potentials = RedBeanController::Finder()->where("contentitems", "textid = :id limit 1", array(":id" => $item->GetId()));
         if (isset($potentials) && is_array($potentials)) {
             //set the content to be the one from the DB
             $i = $potentials[1];
             //1 base - how silly ?!?!?!
         } else {
             //tell the dal what table we are dealing with
             $i = $rb->dispense("contentitems");
             //copy over the properties
             $i->textId = $item->GetId();
         }
         $i->state = $item->GetState();
         $i->title = $item->GetTitle();
         $i->link = $item->GetLink();
         //comit the content to the DB
         $rb->store($i);
         //First remove all existing text
         $textToRemove = RedBeanController::GetRelatedBeans($i, "content_text");
         if (isset($textToRemove) && is_array($textToRemove)) {
             foreach ($textToRemove as $ttr) {
                 $rb->trash($ttr);
             }
         }
         //Then add the nest text
         foreach ($item->GetText() as $text) {
             //initiare the db table
             $t = $rb->dispense("content_text");
             //extratc the text
             $t->text = $text;
             //store the text
             $rb->store($t);
             //Assocate the text with the content
             RedBeanController::Associate($t, $i);
         }
         //first remove the existing tags
         $tagsToRemove = RedBeanController::GetRelatedBeans($i, "content_tags");
         if (isset($tagsToRemove) && is_array($tagsToRemove)) {
             foreach ($tagsToRemove as $ttr) {
                 $rb->trash($ttr);
             }
         }
         //then add all new tags
         foreach ($item->GetTags() as $tag) {
             //initiate the tags db table
             $t = $rb->dispense("content_tags");
             //get the tag properties
             $t->type = $tag->GetType();
             $t->text = $tag->GetText();
             //store the tag
             $rb->store($t);
             //Associate the tag with the content
             RedBeanController::Associate($t, $i);
         }
         //first remove all existing difcollection and their difs
         $difCollectionsToRemove = RedBeanController::GetRelatedBeans($i, "dif_collections");
         if (isset($difCollectionsToRemove) && is_array($difCollectionsToRemove)) {
             foreach ($difCollectionsToRemove as $dctr) {
                 $rb->trash($dctr);
             }
         }
         //loop through the DFICollections
         foreach ($item->GetDifs() as $collection) {
             //initiate the dif collection db table
             $c = $rb->dispense("dif_collections");
             //Get the properties
             $c->name = $collection->GetName();
             //store the collection
             $rb->store($c);
             //Associate the collection with the contet
             RedBeanController::Associate($c, $i);
             //Loop through the difs
             foreach ($collection->GetDifs() as $dif) {
                 //initiate the dif db table
                 $d = $rb->dispense("difs");
                 //Get the properties
                 $d->type = $dif->GetType();
                 $d->value = $dif->GetValue();
                 //store the dif
                 $rb->store($d);
                 //associate the dif with the collection
                 RedBeanController::Associate($d, $c);
             }
         }
     }
 }
Пример #2
0
 /**
  * Given an array of content is's, this function will
  * fetch the content objects from the data store.
  *
  * @param string[] $ids
  * @return \Swiftriver\Core\ObjectModel\Content[]
  */
 public static function GetContent($ids, $orderby = null)
 {
     $logger = \Swiftriver\Core\Setup::GetLogger();
     $logger->log("Core::Modules::DataContext::MySQL_V1::DataContext::GetContent [Method invoked]", \PEAR_LOG_DEBUG);
     //if no $orderby is sent
     if (!$orderby || $orderby == null) {
         $logger->log("Core::Modules::DataContext::MySQL_V1::DataContext::GetContent [No Order By clause set, setting to 'date desc']", \PEAR_LOG_DEBUG);
         //Set it to the default - date DESC
         $orderby = "date desc";
     }
     //set up the return array
     $content = array();
     //If the $ids array is blank or empty, return the empty array
     if (!isset($ids) || !is_array($ids) || count($ids) < 1) {
         $logger->log("Core::Modules::DataContext::MySQL_V1::DataContext::GetContent [No IDs sent to method]", \PEAR_LOG_DEBUG);
         $logger->log("Core::Modules::DataContext::MySQL_V1::DataContext::GetContent [Method finsiehd]", \PEAR_LOG_DEBUG);
         return $content;
     }
     $logger->log("Core::Modules::DataContext::MySQL_V1::DataContext::GetContent [START: Building the RedBean Query]", \PEAR_LOG_DEBUG);
     //set up the array to hold the ids
     $queryIds = array();
     //start to build the sql
     $query = "textId in (";
     /*//for each content item, add to the query and the ids array
       for($i=0; $i<count($ids); $i++) {
           $query .= ":id$i,";
           $queryIds[":id$i"] = $ids[$i];
       }*/
     $counter = 0;
     foreach ($ids as $id) {
         $query .= ":id{$counter},";
         $queryIds[":id{$counter}"] = $id;
         $counter++;
     }
     //tidy up the query
     $query = rtrim($query, ",") . ") order by " . $orderby;
     $logger->log("Core::Modules::DataContext::MySQL_V1::DataContext::GetContent [END: Building the RedBean Query]", \PEAR_LOG_DEBUG);
     $logger->log("Core::Modules::DataContext::MySQL_V1::DataContext::GetContent [START: Running RedBean Query]", \PEAR_LOG_DEBUG);
     //Get the finder
     $finder = RedBeanController::Finder();
     //Find the content
     $dbContent = $finder->where("content", $query, $queryIds);
     $logger->log("Core::Modules::DataContext::MySQL_V1::DataContext::GetContent [FINISHED: Running RedBean Query]", \PEAR_LOG_DEBUG);
     //set up the return array
     $content = array();
     //set up the red bean
     $rb = RedBeanController::RedBean();
     $logger->log("Core::Modules::DataContext::MySQL_V1::DataContext::GetContent [START: Constructing Content and Source items]", \PEAR_LOG_DEBUG);
     //loop through the db content
     foreach ($dbContent as $key => $dbItem) {
         //get the associated source
         $s = reset($rb->batch("source", RedBeanController::GetRelatedBeans($dbItem, "source")));
         //Create the source from the db json
         $source = \Swiftriver\Core\ObjectModel\ObjectFactories\SourceFactory::CreateSourceFromJSON($s->json);
         //get the json for the content
         $json = $dbItem->json;
         //create the content
         $item = \Swiftriver\Core\ObjectModel\ObjectFactories\ContentFactory::CreateContent($source, $json);
         //add it to the array
         $content[] = $item;
     }
     $logger->log("Core::Modules::DataContext::MySQL_V1::DataContext::GetContent [END: Constructing Content and Source items]", \PEAR_LOG_DEBUG);
     $logger->log("Core::Modules::DataContext::MySQL_V1::DataContext::GetContent [Method finished]", \PEAR_LOG_DEBUG);
     //return the content
     return $content;
 }