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:  * Widget class for rendering a user's actions widget.
39:  * 
40:  * Renders the actions widget with action statistics, i.e. how many actions total,
41:  * how many actions complete, how many incomplete, titled "My Actions"
42:  * @package application.components 
43:  */
44: class ActionMenu extends X2Widget {
45: 
46:     public $visibility;
47:     public function init() {
48:         parent::init();
49:     }
50: 
51:     /**
52:      * Creates the widget. 
53:      */
54:     public function run() {
55:         list ($assignedToCondition, $params) = Actions::model()->getAssignedToCondition (); 
56:         $total = Yii::app()->db->createCommand ("
57:             select count(*)
58:             from x2_actions
59:             where $assignedToCondition and (type='' or type is null)
60:         ")->queryScalar ($params);
61:         $incomplete = Yii::app()->db->createCommand ("
62:             select count(*)
63:             from x2_actions
64:             where $assignedToCondition and (type='' or type is null) and complete='No'
65:         ")->queryScalar ($params);
66: 
67:         $overdue = Actions::model()->countByAttributes(
68:             array(
69:                 'assignedTo' => Yii::app()->user->getName(),
70:                 'complete' => 'No'
71:             ),
72:             'dueDate < '.time().' AND (type="" OR type IS NULL)');
73: 
74:         $complete = Actions::model()->countByAttributes(
75:             array(
76:                 'completedBy' => Yii::app()->user->getName(),
77:                 'complete' => 'Yes'
78:             ),
79:             'type="" OR type IS NULL'
80:         );
81: 
82: 
83:         $this->render('actionMenu', array(
84:             'total' => $total,
85:             'unfinished' => $incomplete,
86:             'overdue' => $overdue,
87:             'complete' => $complete,
88:         ));
89:     }
90: 
91: }
92: 
93: ?>
94: