1: <?php
 2: /*****************************************************************************************
 3:  * X2Engine Open Source Edition is a customer relationship management program developed by
 4:  * X2Engine, Inc. Copyright (C) 2011-2016 X2Engine Inc.
 5:  * 
 6:  * This program is free software; you can redistribute it and/or modify it under
 7:  * the terms of the GNU Affero General Public License version 3 as published by the
 8:  * Free Software Foundation with the addition of the following permission added
 9:  * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
10:  * IN WHICH THE COPYRIGHT IS OWNED BY X2ENGINE, X2ENGINE DISCLAIMS THE WARRANTY
11:  * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
12:  * 
13:  * This program is distributed in the hope that it will be useful, but WITHOUT
14:  * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
15:  * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
16:  * details.
17:  * 
18:  * You should have received a copy of the GNU Affero General Public License along with
19:  * this program; if not, see http://www.gnu.org/licenses or write to the Free
20:  * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
21:  * 02110-1301 USA.
22:  * 
23:  * You can contact X2Engine, Inc. P.O. Box 66752, Scotts Valley,
24:  * California 95067, USA. or at email address [email protected].
25:  * 
26:  * The interactive user interfaces in modified source and object code versions
27:  * of this program must display Appropriate Legal Notices, as required under
28:  * Section 5 of the GNU Affero General Public License version 3.
29:  * 
30:  * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
31:  * these Appropriate Legal Notices must retain the display of the "Powered by
32:  * X2Engine" logo. If the display of the logo is not reasonably feasible for
33:  * technical reasons, the Appropriate Legal Notices must display the words
34:  * "Powered by X2Engine".
35:  *****************************************************************************************/
36: 
37: /**
38:  * Class for rendering the "reminders" widget
39:  * 
40:  * @package application.components 
41:  */
42: class Reminders extends X2Widget {
43:     public function init() {
44:         parent::init();
45:     }
46: 
47:     public function run() {
48:         $today = array();
49:         $tomorrow = array();
50:         $nextDay = array();
51:         $name = Yii::app()->user->getName();
52:         $tD = mktime(0,0,0,date("m"),date("d"),date("Y"));
53:         $tM = mktime(0,0,0,date("m"),date("d")+1,date("Y"));
54:         $nD = mktime(0,0,0,date("m"),date("d")+2,date("Y"));
55:         $query = "SELECT * FROM x2_actions WHERE assignedTo = '".$name."' OR 'Anyone'";
56:         $command = Yii::app()->db->createCommand($query);
57:         $result = $command->queryAll();
58:         foreach ($result as $row){
59:             $dueDate = $row['dueDate'];
60:             if ($row['dueDate'] == $tD){$today[] = $row;}
61:             else if($row['dueDate'] == $tM){$tomorrow[] = $row;}
62:             else if($row['dueDate'] == $nD){$nextDay[] = $row;}
63:         }
64:         $this->render('reminders',array(
65:             'tD' => $tD,
66:             'today'=>$today,
67:             'tomorrow'=>$tomorrow,
68:             'nextDay'=>$nextDay,
69:         ));
70:     }
71: }
72: ?>
73: