aboutsummaryrefslogtreecommitdiff
path: root/Application/Models/WikitalkModel.php
blob: 7dee896c508a86ea5aa0c2d885fb82f79929759f (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
<?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 WikitalkModel extends BaseModel
{

	public function __construct() {
		$this->_tables = 'wiki_talk';
		$this->_idFields = 'id_talk';

		$this->_where=array(
			'id_wiki'			=>	'wiki_talk',
			'has_confirmed'		=>	'regusers',
			'-deleted'			=>	'regusers',
		);
		
		$this->orderBy = 'wiki_talk.id_talk';
		
		$this->strongConditions['insert'] = array(
			"checkLength|99"	=>	'title',
			"+checkLength|5000"	=>	'message',
		);
		
		parent::__construct();
	}

	public function pUpdate($id)
	{
		return parent::update($id);
	}

	public function insert()
	{
		if (parent::insert())
		{
			//update the history
			$this->updateHistory('wiki_talk_ins');

			$clean['id_wiki'] = (int)$this->values['id_wiki'];
			$clean['created_by'] = (int)$this->values['created_by'];

			$hard = new WikiModel();
			$users = $hard->select('username,e_mail')
				->where(array('id_wiki'=>$clean['id_wiki'],'has_confirmed'=>0,'deleted'=>'no'))
				->toList('regusers.username','regusers.e_mail')
				->send('Boxes');

			$talkUsers = $this->select('username,e_mail')
				->inner('regusers')
				->on('wiki_talk.created_by = regusers.id_user')
				->where(array('id_wiki'=>$clean['id_wiki'],'has_confirmed'=>0,'-deleted'=>'no'))
				->toList('regusers.username','regusers.e_mail')
				->send();

			$allUsers = array_merge($users,$talkUsers);

			$userObj = new UsersModel();
			$myName = $userObj->getUser($clean['created_by']);

			$arrayE = new ArrayExt();
			$fusers = $arrayE->subsetComplementary($allUsers,$myName);

			//remove users that do not want the email notification
			$inString = "'".implode("','",array_keys($fusers))."'";
			$profile = new ProfileModel();
			$ffusers = $profile->select('username,e_mail')
				->from('regusers inner join profile')
				->on('regusers.id_user = profile.created_by')
				->where(array('send_notification'=>'yes','username'=>"in($inString)"))
				->toList('regusers.username','regusers.e_mail')
				->send();

			$ffusers = array_flip($ffusers);

			//send the notice
			Account::sendWikiTalkNotice($myName,$ffusers,$clean['id_wiki']);

			header('Refresh: 0;url='.Url::getRoot()."wiki/talk/".Lang::$current."/".$clean['id_wiki']);
			exit;
		}
	}
	
	public $formStruct = array(
		'entries' 	=> 	array(
			'title'	=> 	array(),
			'message'	=> 	array('type'=>'Textarea'),
			'id_talk'		=>	array(
				'type'		=>	'Hidden'	
			)
		),
	);

}