/**
* 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;
}
