Merge branch 'development' into h-node

1 files changed, 319 insertions, 0 deletions

diff --git a/Application/Models/WikiModel.php b/Application/Models/WikiModel.php
new file mode 100644
index 0000000..bb60b66
--- /dev/null
+++ b/Application/Models/WikiModel.php
@@ -0,0 +1,319 @@
+<?php
+
+// h-source, a web software to build a community of people that want to share their hardware information.
+// Copyright (C) 2010  Antonio Gallo (h-source-copyright.txt)
+//
+// This file is part of h-source
+//
+// h-source is free software: you can redistribute it and/or modify
+// it under the terms of the GNU General Public License as published by
+// the Free Software Foundation, either version 3 of the License, or
+// (at your option) any later version.
+// 
+// h-source is distributed in the hope that it will be useful,
+// but WITHOUT ANY WARRANTY; without even the implied warranty of
+// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+// GNU General Public License for more details.
+// 
+// You should have received a copy of the GNU General Public License
+// along with h-source.  If not, see <http://www.gnu.org/licenses/>.
+
+if (!defined('EG')) die('Direct access not allowed!');
+
+class WikiModel extends Model_Map {
+
+	public $id_user = 0;
+	public $lastId = 0; //the id of the last record inserted
+	public $lastTitle = null; //the title of the last page inserted
+	public $lastTitleClean = null; //the cleaned title of the last page inserted
+
+	public $diffFields = array();
+	public $fieldsWithBreaks = array();
+	
+	public function __construct() {
+		$this->_tables='wiki,regusers,wiki_users';
+		$this->_idFields='id_wiki,id_user';
+		$this->_where=array(
+			'username'			=>	'regusers',
+			'id_user'			=>	'regusers',
+			'has_confirmed'		=>	'regusers',
+			'deleted'			=>	'regusers',
+			'-deleted'			=>	'wiki',
+			'-blocked'			=>	'wiki',
+		);
+		
+		$this->printAssError = "no";
+
+		$this->diffFields = array(
+			'title' 		=>	gtext("the title"),
+			'page'		 	=>	gtext('the text of the wiki page'),
+		);
+
+		$this->fieldsWithBreaks = array(gtext('the text of the wiki page'));
+
+		$this->strongConditions['insert'] = array(
+			"checkNotEmpty"		=>	'title',
+			"checkLength|99"	=>	'title|'.gtext('title is too long'),
+			"+checkNotEmpty"	=>	'page',
+			"+checkLength|49900"	=>	'page|'.gtext('the page text is too long'),
+		);
+
+		$this->strongConditions['update'] = array(
+			"checkNotEmpty"		=>	'title',
+			"checkLength|99"	=>	'title|'.gtext('title is too long'),
+			"+checkNotEmpty"	=>	'page',
+			"+checkLength|49900"	=>	'page|'.gtext('the page text is too long'),
+		);
+
+		$this->databaseConditions['insert'] = array(
+			"checkUnique"		=>	'title|'.gtext('a page with the same title already exists'),
+		);
+
+		$this->databaseConditions['update'] = array(
+			"checkUniqueCompl"	=>	'title|'.gtext('a page with the same title already exists'),
+		);
+		
+		parent::__construct();
+	}
+
+	public function pUpdate($id)
+	{
+		return parent::update($id);
+	}
+
+	public function insert()
+	{
+		$this->values['created_by'] = (int)$this->id_user;
+		$this->values['update_date'] = date('Y-m-d H:i:s');
+		
+		//random ID
+		$randomId = md5(uniqid(mt_rand(),true));
+		$this->values["title_clean"] = $randomId;
+
+		parent::insert();
+		
+		//associate the user to the record
+		if ($this->queryResult)
+		{
+			$resId =  $this->select()->where(array('title_clean'=>$randomId))->send();
+			$clean['id'] = $resId[0]['wiki']['id_wiki'];
+			$this->lastId = $clean['id'];
+			$this->lastTitle = $resId[0]['wiki']['title'];
+			$this->lastTitleClean = titleForRedirect($resId[0]['wiki']['title']);
+			$this->db->update('wiki','title_clean',array(encodeUrl(sanitizeDb($resId[0]['wiki']['title']))),'id_wiki='.$clean['id']);
+
+			//update the history table
+			$this->updateHistory('insert');
+			
+			$this->associate($clean['id']);
+		}
+		 
+	}
+
+	public function update($id = null, $where = null)
+	{
+		$clean['id'] = (int)$id;
+
+		$this->values['created_by'] = (int)$this->id_user;
+		$this->values['update_date'] = date('Y-m-d H:i:s');
+		$this->values['title_clean'] = encodeUrl($this->values['title']);
+		
+		//save the old fields in the revisions table
+		$this->setWhereQueryClause(array('id_wiki'	=>	$clean['id']));
+		$oldStruct = $this->getFields($this->fields.',title_clean,created_by,update_date,id_wiki');
+		
+		if (count($oldStruct > 0))
+		{
+			$oldValues = $oldStruct[0]['wiki'];
+
+			$revisions = new WikirevisionsModel();
+			$revisions->values = $oldValues;
+			
+			$revisions->sanitize();
+			
+			if ($revisions->insert())
+			{
+				
+				if ($this->isMain($clean['id']))
+				{
+					$this->values['title'] = 'Main Page';
+					$this->values['title_clean'] = 'Main-Page';
+				}
+				
+				parent::update($clean['id']);
+				if ($this->queryResult)
+				{
+					$this->lastId = $clean['id'];
+					$this->lastTitle = $this->values['title'];
+					$this->lastTitleClean = html_entity_decode($this->values['title_clean'],ENT_QUOTES,DEFAULT_CHARSET);
+					
+					//update the history table
+					$this->updateHistory('update');
+
+					if (!$this->checkAssociation($clean['id'],(int)$this->id_user))
+					{
+						$this->associate($clean['id']);
+					}
+				}
+			}
+		}
+	}
+
+	public function makeCurrent($id_rev)
+	{
+		
+		$clean['id_rev'] = (int)$id_rev;
+		
+		$revisions = new WikirevisionsModel();
+		
+		$clean['id_wiki'] = (int)$revisions->getIdPage($clean['id_rev']);
+		
+		//save the old fields in the revisions table
+		$this->where(array('id_wiki'=>$clean['id_wiki']));
+		$oldStruct = $this->getFields($this->fields.',title_clean,created_by,update_date,id_wiki');
+		
+		if (count($oldStruct > 0))
+		{
+			//get the values of the revision
+			$revisions->where(array('id_rev'=>$clean['id_rev']));
+			$newStruct = $revisions->getFields($this->fields.',title_clean,created_by,update_date');
+
+			if (count($newStruct > 0))
+			{
+				$revisions->values = $oldStruct[0]['wiki'];
+				$revisions->sanitize();
+				
+				$this->values = $newStruct[0]['wiki_revisions'];
+				$this->values['created_by'] = (int)$this->id_user;
+				$this->values['update_date'] = date('Y-m-d H:i:s');
+
+				$this->sanitize();
+				
+				if ($this->isMain($clean['id_wiki']))
+				{
+					$this->values['title'] = 'Main Page';
+					$this->values['title_clean'] = 'Main-Page';
+				}
+				
+				if ($revisions->insert())
+				{
+					if (parent::update($clean['id_wiki']))
+					{
+						$this->lastId = $clean['id_wiki'];
+						$this->lastTitle = $this->values['title'];
+						$this->lastTitleClean = html_entity_decode($this->values['title_clean'],ENT_QUOTES,DEFAULT_CHARSET);
+						
+						//update the history table
+						$this->updateHistory('update');
+
+						if (!$this->checkAssociation($clean['id_wiki'],(int)$this->id_user))
+						{
+							$this->associate($clean['id_wiki']);
+						}
+					}
+				}
+			}
+		}
+		
+	}
+
+	public function associate($id_record = null, $idGroup = null)
+	{
+		return parent::associate((int)$id_record,(int)$this->id_user);
+	}
+
+	//get the model name
+	public function getTheModelName($id, $cleaned = false)
+	{
+		$clean['id'] = (int)$id;
+		$this->setWhereQueryClause(array('id_wiki' => $clean['id']));
+		$res = $this->getFields('title,title_clean');
+		$name = '';
+		if (count($res) > 0)
+		{
+			if ($cleaned)
+			{
+				$name = $res[0]['wiki']['title_clean'];
+			}
+			else
+			{
+				$name = $res[0]['wiki']['title'];
+			}
+		}
+		return $name;
+	}
+
+	//save in the history all the action carried out by users
+	protected function updateHistory($action)
+	{
+		$translations = array(
+			'insert'		=>	'inserted',
+			'update'		=>	'updated',
+		);
+
+		$allowedActions = array('insert','update');
+
+		if (in_array($action,$allowedActions))
+		{
+			$users = new UsersModel();
+
+			$clean['user'] = sanitizeAll($users->getUser($this->id_user));
+			
+			$history = new HistoryModel();
+			$history->values = array(
+				'created_by' 	=>	$this->id_user,
+				'type'			=>	'wiki',
+				'action'		=>	$action,
+				'id'			=>	$this->lastId,
+				'message'		=>	'The wiki page having id='.$this->lastId.' has been '.$translations[$action].' by the user ' . $clean['user'] . ' (id_user='.$this->id_user.') ',
+				'gr'			=>	'registered',
+			);
+			$history->insert();
+		}
+	}
+
+	public function isMain($id)
+	{
+		$clean['id'] = (int)$id;
+		$res = $this->select('is_main')->where(array('id_wiki'=>$clean['id']))->send();
+		if ( count($res) > 0 )
+		{
+			return strcmp($res[0]['wiki']['is_main'],'no') === 0 ? false : true;
+		}
+		return false;
+	}
+
+	public function isDeleted($id)
+	{
+		$clean['id'] = (int)$id;
+		$res = $this->select('wiki.deleted')->where(array('id_wiki'=>$clean['id']))->send();
+		if ( count($res) > 0 )
+		{
+			return strcmp($res[0]['wiki']['deleted'],'no') === 0 ? false : true;
+		}
+		return false;
+	}
+
+	public function isBlocked($id)
+	{
+		$clean['id'] = (int)$id;
+		$res = $this->select('blocked')->where(array('id_wiki'=>$clean['id']))->send();
+		if ( count($res) > 0 )
+		{
+			return strcmp($res[0]['wiki']['blocked'],'no') === 0 ? false : true;
+		}
+		return false;
+	}
+
+	public function toWikiPage($id)
+	{
+		$clean['id'] = (int)$id;
+		$title = $this->getTheModelName($clean['id'], true);
+		return Url::getRoot()."wiki/page/".Lang::$current."/".$title;
+	}
+
+	public function getDiffArray($oldArray, $newArray)
+	{
+		return getDiffArray($this->diffFields, $oldArray, $newArray);
+	}
+}
\ No newline at end of file