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
113
114
115
|
<?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 TalkModel extends BaseModel {
public function __construct() {
$this->_tables = 'talk';
$this->_idFields = 'id_talk';
$this->_where=array(
'id_hard' => 'talk',
'has_confirmed' => 'regusers',
'-deleted' => 'regusers',
);
$this->orderBy = 'talk.id_talk desc';
$this->strongConditions['insert'] = array(
"checkLength|99" => 'title',
"+checkNotEmpty" => 'message',
"++checkLength|5000" => 'message',
);
parent::__construct();
}
public function pUpdate($id)
{
return parent::update($id);
}
public function insert()
{
if (parent::insert())
{
//update the history
$this->updateHistory('talk_ins');
if (strcmp($this->values['id_hard'],0) !== 0)
{
$clean['id_hard'] = (int)$this->values['id_hard'];
$clean['created_by'] = (int)$this->values['created_by'];
$hard = new HardwareModel();
$users = $hard->select('username,e_mail')
->where(array('id_hard'=>$clean['id_hard'],'has_confirmed'=>0,'deleted'=>'no'))
->toList('regusers.username','regusers.e_mail')
->send('Boxes');
$talkUsers = $this->select('username,e_mail')
->from('talk inner join regusers')
->on('talk.created_by = regusers.id_user')
->where(array('id_hard'=>$clean['id_hard'],'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::sendTalkNotice($myName,$ffusers,$clean['id_hard']);
header('Refresh: 0;url=http://'.DOMAIN_NAME.$_SERVER['REQUEST_URI']);
exit;
}
}
}
public $formStruct = array(
'entries' => array(
'title' => array(),
'message' => array('type'=>'Textarea'),
'id_talk' => array(
'type' => 'Hidden'
)
),
);
}
|
