/** * addContent * * Add content. * * @param array $data */ public function addContent($data) { $auth = Zend_Auth::getInstance(); // Create a new row $content = $this->createRow(); //Zend_Debug::dump($content, $label=null, $echo=true); // Set data to row $content->id_cty_cnt = $data['content_type']; $content->title_cnt = htmlspecialchars($data['content_header']); $content->lead_cnt = htmlspecialchars($data['content_textlead']); $content->body_cnt = htmlspecialchars($data['content_text']); if (isset($data['content_research'])) { $content->research_question_cnt = htmlspecialchars($data['content_research']); } if (isset($data['content_opportunity'])) { $content->opportunity_cnt = htmlspecialchars($data['content_opportunity']); } if (isset($data['content_threat'])) { $content->threat_cnt = htmlspecialchars($data['content_threat']); } if (isset($data['content_solution'])) { $content->solution_cnt = htmlspecialchars($data['content_solution']); } $content->references_cnt = $data['content_references']; $content->published_cnt = $data['publish']; $content->created_cnt = new Zend_Db_Expr('NOW()'); $content->modified_cnt = new Zend_Db_Expr('NOW()'); $content->language_cnt = $data['content_language']; if (!$content->save()) { $return = false; } else { // If save was successful, content id is returned, because it is needed // when redirecting $return = $content->id_cnt; /*if($_FILES['content_file_upload']['size'] != 0) { $files = new Default_Model_Files(); $files->newFile($content->id_cnt, $auth->getIdentity()->user_id); }*/ $filesModel = new Default_Model_Files(); $filesModel->newFiles($content->id_cnt, "content", $data['files']); } // What is this used for //$contentTypes = new Default_Model_ContentTypes(); //$content_type = $contentTypes->getTypeById($data['content_type']); if ($data['content_relatesto_id'] != 0) { $contentHasContent = new Default_Model_ContentHasContent(); $contentHasContent->addContentToContent($data['content_relatesto_id'], $content->id_cnt); } // Add user to content $contentHasUser = new Default_Model_ContentHasUser(); $contentHasUser->addUserToContent($content->id_cnt, $data['User']['id_usr'], 1); // Check if user has given keywords if (!empty($data['content_keywords'])) { $tagModel = new Default_Model_Tags(); $tagModel->addTagsToContent($content->id_cnt, $data['content_keywords']); // Go through all given keywords // This should be in Tags model /* foreach($data['content_keywords'] as $tag) { $tagRow = new Default_Model_Tags(); $tag = strip_tags($tag); // Check if given keyword does not exists in database if($tagRow->tagExists($tag)) { // Create new keyword $tag = $tagRow->createTag($tag); } else { // Get keyword $tag = $tagRow->getTag($tag); } // end else // echo '<pre>';echo $tag->id_tag.' '.$content->id_cnt;echo '</pre>'; //die(); // Add keywords to content $contentHasTag = new Default_Model_ContentHasTag(); $contentHasTag->addTagToContent($tag->id_tag, $content->id_cnt); } // end foreach */ } // end if // Check if user has given related companies if (!empty($data['content_related_companies'])) { $recModel = new Default_Model_RelatedCompanies(); $recModel->addRelatedCompaniesToContent($content->id_cnt, $data['content_related_companies']); // Go through all given related companies // FIX: This should be in RelatedCompanies model /*foreach($data['content_related_companies'] as $relComp) { $relCompRow = new Default_Model_RelatedCompanies(); $relComp = strip_tags($relComp); // Check if given related company does not exists in database if($relCompRow->relCompExists($relComp)) { // Create new related company $relComp = $relCompRow->createRelComp($relComp); } else { // Get related company $relComp = $relCompRow->getRelComp($relComp); } // end else // echo '<pre>';echo $tag->id_tag.' '.$content->id_cnt;echo '</pre>'; //die(); // Add related companies to content $contentHasRelatedCompany = new Default_Model_ContentHasRelatedCompany(); $contentHasRelatedCompany->addRelCompToContent($relComp->id_rec, $content->id_cnt); } // end foreach */ } // end if // Check if user has given campaigns if (!empty($data['content_campaigns'])) { $cmpModel = new Default_Model_Campaigns(); $cmpModel->addCampaignsToContent($content->id_cnt, $data['content_campaigns']); // Go through all given campaigns // FIX: This should be in Campaigns model /*foreach($data['content_campaigns'] as $campaign) { $campaignRow = new Default_Model_Campaigns(); $campaign = strip_tags($campaign); // Check if given campaign does not exists in database if($campaignRow->campaignExists($campaign)) { // Create new campaign $campaign = $campaignRow->createCampaign($campaign); } else { // Get campaign $campaign = $campaignRow->getCampaign($campaign); } // end else // echo '<pre>';echo $tag->id_tag.' '.$content->id_cnt;echo '</pre>'; //die(); // Add related companies to content $contentHasCampaign = new Default_Model_ContentHasCampaign(); $contentHasCampaign->addCampaignToContent($campaign->id_cmp, $content->id_cnt); } // end foreach */ } // end if // Add industry to content /*$contentHasIndustry = new Default_Model_ContentHasIndustries(); if(isset($data['content_industry'])) { $id_ind = 0; if($data['content_class'] != 0) { $id_ind = $data['content_class']; } elseif($data['content_group'] != 0) { $id_ind = $data['content_group']; } elseif($data['content_division'] != 0) { $id_ind = $data['content_division']; } elseif($data['content_industry'] != 0) { $id_ind = $data['content_industry']; } } if($id_ind != 0) { $contentHasIndustry->addIndustryToContent($content->id_cnt, $id_ind); } */ // Add future info classification to content if (isset($data['content_finfo_class'])) { if ($data['content_finfo_class'] != 0) { $contentHasFutureinfoClass = new Default_Model_ContentHasFutureinfoClasses(); $contentHasFutureinfoClass->addFutureinfoClassToContent($content->id_cnt, $data['content_finfo_class']); } } // Add innovation type to content if (isset($data['innovation_type'])) { if ($data['innovation_type'] != 0) { $contentHasInnovationType = new Default_Model_ContentHasInnovationTypes(); $contentHasInnovationType->addInnovationTypeToContent($content->id_cnt, $data['innovation_type']); } } return $return; }
/** * removeContent * Removes specified content from the database and all related stuff * * @param int id_cnt The id of content to be removed * @return boolean array $contentRemoveChecker * @author Mikko Korpinen */ public function removeContentAndDepending($id_cnt = 0) { $contentRemoveChecker = array('removeContentFromContent' => true, 'removeContentFromFutureinfoClasses' => true, 'removeContentFromIndustries' => true, 'removeContentFromInnovationTypes' => true, 'removeContentFromRelatedCompanies' => true, 'removeContentRelatedCompanies' => true, 'removeContentFromTags' => true, 'removeContentTags' => true, 'removeContentFromUser' => true, 'removeContentViews' => true, 'removeContentFlags' => true, 'removeContentCommentFlags' => true, 'removeContentRatings' => true, 'removeContentFiles' => true, 'removeUserFromFavorites' => true, 'removeContent' => true, 'removeContentComments' => true); // cnt_has_cnt $cntHasCnt = new Default_Model_ContentHasContent(); if (!$cntHasCnt->removeContentFromContents($id_cnt)) { $contentRemoveChecker['removeContentFromContent'] = false; } // cnt_has_fic $cntHasFic = new Default_Model_ContentHasFutureinfoClasses(); if (!$cntHasFic->removeFutureinfoClassesFromContent($id_cnt)) { $contentRemoveChecker['removeContentFromFutureinfoClasses'] = false; } // cnt_has_grp // Not used? // cnt_has_ind $cntHasInd = new Default_Model_ContentHasIndustries(); if (!$cntHasInd->removeIndustriesFromContent($id_cnt)) { $contentRemoveChecker['removeContentFromIndustries'] = false; } // cnt_has_ivt $cntHasIvt = new Default_Model_ContentHasInnovationTypes(); if (!$cntHasIvt->removeInnovationTypesFromContent($id_cnt)) { $contentRemoveChecker['removeContentFromInnovationTypes'] = false; } // related_companies_rec and cnt_has_rec $cntHasRec = new Default_Model_ContentHasRelatedCompany(); $recs = $cntHasRec->getContentRelComps($id_cnt); $rec = new Default_Model_RelatedCompanies(); foreach ($recs as $id_rec) { if (!$cntHasRec->checkIfOtherContentHasRelComp($id_rec['id_rec'], $id_cnt)) { if (!$rec->removeRelComp($id_rec['id_rec'])) { $contentRemoveChecker['removeRelatedCompanies'] = false; } } } if (!$cntHasRec->removeContentRelComps($id_cnt)) { $contentRemoveChecker['removeContentFromRelatedCompanies'] = false; } // tags_tag and cnt_has_tag $cntHasTag = new Default_Model_ContentHasTag(); $tags = $cntHasTag->getContentTags($id_cnt); $tag = new Default_Model_Tags(); foreach ($tags as $id_tag) { if (!$cntHasTag->checkIfOtherContentHasTag($id_tag['id_tag'], $id_cnt)) { if (!$tag->removeTag($id_tag['id_tag'])) { $contentRemoveChecker['removeTags'] = false; } } } if (!$cntHasTag->removeContentTags($id_cnt)) { $contentRemoveChecker['removeContentFromTags'] = false; } // cnt_has_usr $cntHasUsr = new Default_Model_ContentHasUser(); if (!$cntHasUsr->removeUserFromContent($id_cnt)) { $contentRemoveChecker['removeContentFromUser'] = false; } // cnt_publish_times_pbt // Not used? // cnt_views_vws $cntWiewsVws = new Default_Model_ContentViews(); if (!$cntWiewsVws->removeContentViews($id_cnt)) { $contentRemoveChecker['removeContentViews'] = false; } // Flags from content_flags_cfl $contentflagmodel = new Default_Model_ContentFlags(); $cnfl_ids = $contentflagmodel->getFlagsByContentId($id_cnt); if (is_array($cnfl_ids)) { foreach ($cnfl_ids as $cfl_id) { if (!$contentflagmodel->removeFlag($cfl_id)) { $contentRemoveChecker['removeContentFlags'] = false; } } } // Flags from comment_flags_cfl $commentflagmodel = new Default_Model_CommentFlags(); $cmfl_ids = $commentflagmodel->getFlagsByContentId($id_cnt); if (is_array($cmfl_ids)) { foreach ($cmfl_ids as $cfl_id) { if (!$commentflagmodel->removeFlag($cfl_id)) { $contentRemoveChecker['removeContentCommentFlags'] = false; } } } // content_ratings_crt $contentRatingRct = new Default_Model_ContentRatings(); if (!$contentRatingRct->removeContentRatings($id_cnt)) { $contentRemoveChecker['removeContentRatings'] = false; } // files_fil $files = new Default_Model_Files(); if (!$files->removeContentFiles($id_cnt)) { $contentRemoveChecker['removeContentFiles'] = false; } // links_lnk // Not used? // usr_has_fvr $usrHasFvr = new Default_Model_UserHasFavourites(); if (!$usrHasFvr->removeAllContentFromFavouritesByContentId($id_cnt)) { $contentRemoveChecker['removeUserFromFavorites'] = false; } // contents_cnt $contentmodel = new Default_Model_Content(); if (!$contentmodel->removeContent($id_cnt)) { $contentRemoveChecker['removeContent'] = false; } // coments_cmt $commentmodel = new Default_Model_Comments(); if (!$commentmodel->removeAllContentComments($id_cnt)) { $contentRemoveChecker['removeContentComments'] = false; } return $contentRemoveChecker; }