modules/Tasks/Task.php

   1 <?php
   2 if(!defined('sugarEntry') || !sugarEntry) die('Not A Valid Entry Point');
   3 /*********************************************************************************
   4  * SugarCRM Community Edition is a customer relationship management program developed by
   5  * SugarCRM, Inc. Copyright (C) 2004-2011 SugarCRM Inc.
   6  *
   7  * This program is free software; you can redistribute it and/or modify it under
   8  * the terms of the GNU Affero General Public License version 3 as published by the
   9  * Free Software Foundation with the addition of the following permission added
  10  * to Section 15 as permitted in Section 7(a): FOR ANY PART OF THE COVERED WORK
  11  * IN WHICH THE COPYRIGHT IS OWNED BY SUGARCRM, SUGARCRM DISCLAIMS THE WARRANTY
  12  * OF NON INFRINGEMENT OF THIRD PARTY RIGHTS.
  13  *
  14  * This program is distributed in the hope that it will be useful, but WITHOUT
  15  * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
  16  * FOR A PARTICULAR PURPOSE.  See the GNU Affero General Public License for more
  17  * details.
  18  *
  19  * You should have received a copy of the GNU Affero General Public License along with
  20  * this program; if not, see http://www.gnu.org/licenses or write to the Free
  21  * Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA
  22  * 02110-1301 USA.
  23  *
  24  * You can contact SugarCRM, Inc. headquarters at 10050 North Wolfe Road,
  25  * SW2-130, Cupertino, CA 95014, USA. or at email address contact@sugarcrm.com.
  26  *
  27  * The interactive user interfaces in modified source and object code versions
  28  * of this program must display Appropriate Legal Notices, as required under
  29  * Section 5 of the GNU Affero General Public License version 3.
  30  *
  31  * In accordance with Section 7(b) of the GNU Affero General Public License version 3,
  32  * these Appropriate Legal Notices must retain the display of the "Powered by
  33  * SugarCRM" logo. If the display of the logo is not reasonably feasible for
  34  * technical reasons, the Appropriate Legal Notices must display the words
  35  * "Powered by SugarCRM".
  36  ********************************************************************************/
  37
  38
  39 // Task is used to store customer information.
  40 class Task extends SugarBean {
  41         var $field_name_map;
  42
  43         // Stored fields
  44         var $id;
  45         var $date_entered;
  46         var $date_modified;
  47         var $assigned_user_id;
  48         var $modified_user_id;
  49         var $created_by;
  50         var $created_by_name;
  51         var $modified_by_name;
  52         var $description;
  53         var $name;
  54         var $status;
  55         var $date_due_flag;
  56         var $date_due;
  57         var $time_due;
  58         var $date_start_flag;
  59         var $date_start;
  60         var $time_start;
  61         var $priority;
  62         var $parent_type;
  63         var $parent_id;
  64         var $contact_id;
  65
  66         var $parent_name;
  67         var $contact_name;
  68         var $contact_phone;
  69         var $contact_email;
  70         var $assigned_user_name;
  71
  72 //bug 28138 todo
  73 //      var $default_task_name_values = array('Assemble catalogs', 'Make travel arrangements', 'Send a letter', 'Send contract', 'Send fax', 'Send a follow-up letter', 'Send literature', 'Send proposal', 'Send quote', 'Call to schedule meeting', 'Setup evaluation', 'Get demo feedback', 'Arrange introduction', 'Escalate support request', 'Close out support request', 'Ship product', 'Arrange reference call', 'Schedule training', 'Send local user group information', 'Add to mailing list');
  74
  75         var $table_name = "tasks";
  76
  77         var $object_name = "Task";
  78         var $module_dir = 'Tasks';
  79
  80         var $importable = true;
  81         // This is used to retrieve related fields from form posts.
  82         var $additional_column_fields = Array('assigned_user_name', 'assigned_user_id', 'contact_name', 'contact_phone', 'contact_email', 'parent_name');
  83
  84
  85         function Task() {
  86                 parent::SugarBean();
  87         }
  88
  89         var $new_schema = true;
  90
  91     function save($check_notify = FALSE)
  92     {
  93         if (empty($this->status) ) {
  94             $this->status = $this->getDefaultStatus();
  95         }
  96         return parent::save($check_notify);
  97     }
  98
  99         function get_summary_text()
 100         {
 101                 return "$this->name";
 102         }
 103
 104     function create_export_query(&$order_by, &$where, $relate_link_join='')
 105     {
 106         $custom_join = $this->custom_fields->getJOIN(true, true,$where);
 107                 if($custom_join)
 108                                 $custom_join['join'] .= $relate_link_join;
 109                 $contact_required = stristr($where,"contacts");
 110                 if($contact_required)
 111                 {
 112                         $query = "SELECT tasks.*, contacts.first_name, contacts.last_name, users.user_name as assigned_user_name ";
 113                         if($custom_join){
 114                                                         $query .= $custom_join['select'];
 115                                                 }
 116                         $query .= " FROM contacts, tasks ";
 117                         $where_auto = "tasks.contact_id = contacts.id AND tasks.deleted=0 AND contacts.deleted=0";
 118                 }
 119                 else
 120                 {
 121                         $query = 'SELECT tasks.*, users.user_name as assigned_user_name ';
 122                         if($custom_join){
 123                                                         $query .= $custom_join['select'];
 124                                                 }
 125                         $query .= ' FROM tasks ';
 126                         $where_auto = "tasks.deleted=0";
 127                 }
 128
 129
 130                                 if($custom_join){
 131                                         $query .= $custom_join['join'];
 132                                 }
 133                 $query .= "  LEFT JOIN users ON tasks.assigned_user_id=users.id ";
 134
 135                 if($where != "")
 136                         $query .= "where $where AND ".$where_auto;
 137                 else
 138                         $query .= "where ".$where_auto;
 139
 140                 if($order_by != "")
 141                         $query .=  " ORDER BY ". $this->process_order_by($order_by, null);
 142                 else
 143                         $query .= " ORDER BY tasks.name";
 144                 return $query;
 145
 146         }
 147
 148
 149
 150         function fill_in_additional_list_fields()
 151         {
 152
 153         }
 154
 155         function fill_in_additional_detail_fields()
 156         {
 157         parent::fill_in_additional_detail_fields();
 158                 global $app_strings;
 159
 160                 if (isset($this->contact_id)) {
 161
 162                         $contact = new Contact();
 163                         $contact->retrieve($this->contact_id);
 164
 165                         if($contact->id != "") {
 166                                 $this->contact_name = $contact->full_name;
 167                                 $this->contact_name_owner = $contact->assigned_user_id;
 168                                 $this->contact_name_mod = 'Contacts';
 169                                 $this->contact_phone = $contact->phone_work;
 170                                 $this->contact_email = $contact->emailAddress->getPrimaryAddress($contact);
 171                         } else {
 172                                 $this->contact_name_mod = '';
 173                                 $this->contact_name_owner = '';
 174                                 $this->contact_name='';
 175                                 $this->contact_email = '';
 176                                 $this->contact_id='';
 177                         }
 178
 179                 }
 180
 181                 $this->fill_in_additional_parent_fields();
 182         }
 183
 184         function fill_in_additional_parent_fields()
 185         {
 186
 187                 $this->parent_name = '';
 188                 global $app_strings, $beanFiles, $beanList, $locale;
 189                 if ( ! isset($beanList[$this->parent_type]))
 190                 {
 191                         $this->parent_name = '';
 192                         return;
 193                 }
 194
 195             $beanType = $beanList[$this->parent_type];
 196                 require_once($beanFiles[$beanType]);
 197                 $parent = new $beanType();
 198
 199                 if (is_subclass_of($parent, 'Person')) {
 200                         $query = "SELECT first_name, last_name, assigned_user_id parent_name_owner from $parent->table_name where id = '$this->parent_id'";
 201                 }
 202                 else if (is_subclass_of($parent, 'File')) {
 203                         $query = "SELECT document_name, assigned_user_id parent_name_owner from $parent->table_name where id = '$this->parent_id'";
 204                 }
 205                 else {
 206
 207                         $query = "SELECT name ";
 208                         if(isset($parent->field_defs['assigned_user_id'])){
 209                                 $query .= " , assigned_user_id parent_name_owner ";
 210                         }else{
 211                                 $query .= " , created_by parent_name_owner ";
 212                         }
 213                         $query .= " from $parent->table_name where id = '$this->parent_id'";
 214                 }
 215                 $result = $this->db->query($query,true," Error filling in additional detail fields: ");
 216
 217                 // Get the id and the name.
 218                 $row = $this->db->fetchByAssoc($result);
 219
 220                 if ($row && !empty($row['parent_name_owner'])){
 221                         $this->parent_name_owner = $row['parent_name_owner'];
 222                         $this->parent_name_mod = $this->parent_type;
 223                 }
 224                 if (is_subclass_of($parent, 'Person') and $row != null)
 225                 {
 226                         $this->parent_name = $locale->getLocaleFormattedName(stripslashes($row['first_name']), stripslashes($row['last_name']));
 227                 }
 228                 else if (is_subclass_of($parent, 'File') && $row != null) {
 229                         $this->parent_name = $row['document_name'];
 230                 }
 231                 elseif($row != null)
 232                 {
 233                         $this->parent_name = stripslashes($row['name']);
 234                 }
 235                 else {
 236                         $this->parent_name = '';
 237                 }
 238         }
 239
 240
 241
 242
 243         function get_list_view_data(){
 244                 global $action, $currentModule, $focus, $current_module_strings, $app_list_strings, $timedate;
 245
 246                 $override_date_for_subpanel = false;
 247                 if(!empty($_REQUEST['module']) && $_REQUEST['module'] !='Calendar' && $_REQUEST['module'] !='Tasks' && $_REQUEST['module'] !='Home'){
 248                         //this is a subpanel list view, so override the due date with start date so that collections subpanel works as expected
 249                         $override_date_for_subpanel = true;
 250                 }
 251
 252                 $today = $timedate->nowDbDate();
 253                 $task_fields = $this->get_list_view_array();
 254                 $dbtime = $timedate->to_db($task_fields['DATE_DUE']);
 255                 if($override_date_for_subpanel){
 256                         $dbtime = $timedate->to_db($task_fields['DATE_START']);
 257                 }
 258
 259         $task_fields['TIME_DUE'] = $timedate->to_display_time($dbtime);
 260         $task_fields['DATE_DUE'] = $timedate->to_display_date($dbtime);
 261
 262
 263         $date_due = $task_fields['DATE_DUE'];
 264
 265                 if (!empty($this->priority))
 266                         $task_fields['PRIORITY'] = $app_list_strings['task_priority_dom'][$this->priority];
 267                 if (isset($this->parent_type))
 268                         $task_fields['PARENT_MODULE'] = $this->parent_type;
 269                 if ($this->status != "Completed" && $this->status != "Deferred" )
 270                 {
 271                         $setCompleteUrl = "<a onclick='SUGAR.util.closeActivityPanel.show(\"{$this->module_dir}\",\"{$this->id}\",\"Completed\",\"listview\",\"1\");'>";
 272                     $task_fields['SET_COMPLETE'] = $setCompleteUrl . SugarThemeRegistry::current()->getImage("close_inline","title=".translate('LBL_LIST_CLOSE','Tasks')." border='0'")."</a>";
 273                 }
 274
 275         $dd = $timedate->to_db_date($date_due, false);
 276                 if ($dd < $today){
 277                         $task_fields['DATE_DUE']= "<font class='overdueTask'>".$date_due."</font>";
 278                         if($override_date_for_subpanel){
 279                                 $task_fields['DATE_START']= "<font class='overdueTask'>".$date_due."</font>";
 280                         }
 281                 }else if( $dd   == $today ){
 282                         $task_fields['DATE_DUE'] = "<font class='todaysTask'>".$date_due."</font>";
 283                         if($override_date_for_subpanel){
 284                                 $task_fields['DATE_START'] = "<font class='todaysTask'>".$date_due."</font>";
 285                         }
 286                 }else{
 287                         $task_fields['DATE_DUE'] = "<font class='futureTask'>".$date_due."</font>";
 288                         if($override_date_for_subpanel){
 289                                 $task_fields['DATE_START'] = "<font class='futureTask'>".$date_due."</font>";
 290                         }
 291                 }
 292
 293                 //make sure we grab the localized version of the contact name, if a contact is provided
 294                 if (!empty($this->contact_id)) {
 295             // Bug# 46125 - make first name, last name, salutation and title of Contacts respect field level ACLs
 296             $contact = new Contact();
 297                         $contact->retrieve($this->contact_id);
 298                         if(isset($contact->id)) {
 299                             $this->contact_name = $contact->full_name;
 300                 $this->contact_phone = $contact->phone_work;
 301                         }
 302                 }
 303
 304                 $task_fields['CONTACT_NAME']= $this->contact_name;
 305                 $task_fields['CONTACT_PHONE']= $this->contact_phone;
 306                 $task_fields['TITLE'] = '';
 307                 if (!empty($task_fields['CONTACT_NAME'])) {
 308                         $task_fields['TITLE'] .= $current_module_strings['LBL_LIST_CONTACT'].": ".$task_fields['CONTACT_NAME'];
 309                 }
 310                 if (!empty($this->parent_name)) {
 311                         $task_fields['TITLE'] .= "\n".$app_list_strings['parent_type_display'][$this->parent_type].": ".$this->parent_name;
 312                         $task_fields['PARENT_NAME']=$this->parent_name;
 313                 }
 314
 315                 return $task_fields;
 316         }
 317
 318         function set_notification_body($xtpl, $task)
 319         {
 320                 global $app_list_strings;
 321         global $timedate;
 322         $notifyUser = $task->current_notify_user;
 323         $prefDate = $notifyUser->getUserDateTimePreferences();
 324                 $xtpl->assign("TASK_SUBJECT", $task->name);
 325                 //MFH #13507
 326                 $xtpl->assign("TASK_PRIORITY", (isset($task->priority)?$app_list_strings['task_priority_dom'][$task->priority]:""));
 327                 $duedate = $timedate->fromDb($task->date_due);
 328         $duedate = !empty($duedate) ? ($timedate->asUser($duedate, $notifyUser)." ".TimeDate::userTimezoneSuffix($duedate, $notifyUser)) : '';
 329                 $xtpl->assign("TASK_DUEDATE", $duedate);
 330                 $xtpl->assign("TASK_STATUS", (isset($task->status)?$app_list_strings['task_status_dom'][$task->status]:""));
 331                 $xtpl->assign("TASK_DESCRIPTION", $task->description);
 332
 333                 return $xtpl;
 334         }
 335
 336         function bean_implements($interface){
 337                 switch($interface){
 338                         case 'ACL':return true;
 339                 }
 340                 return false;
 341         }
 342         function listviewACLHelper(){
 343                 $array_assign = parent::listviewACLHelper();
 344                 $is_owner = false;
 345                 if(!empty($this->parent_name)){
 346                         if(!empty($this->parent_name_owner)){
 347                                 global $current_user;
 348                                 $is_owner = $current_user->id == $this->parent_name_owner;
 349                         }
 350                 }
 351
 352                         if(!ACLController::moduleSupportsACL($this->parent_type) || ACLController::checkAccess($this->parent_type, 'view', $is_owner)){
 353                                 $array_assign['PARENT'] = 'a';
 354                         }else{
 355                                 $array_assign['PARENT'] = 'span';
 356                         }
 357                 $is_owner = false;
 358                 if(!empty($this->contact_name)){
 359                         if(!empty($this->contact_name_owner)){
 360                                 global $current_user;
 361                                 $is_owner = $current_user->id == $this->contact_name_owner;
 362                         }
 363                 }
 364
 365                 if( ACLController::checkAccess('Contacts', 'view', $is_owner)){
 366                                 $array_assign['CONTACT'] = 'a';
 367                 }else{
 368                                 $array_assign['CONTACT'] = 'span';
 369                 }
 370
 371                 return $array_assign;
 372         }
 373
 374         public function getDefaultStatus()
 375     {
 376          $def = $this->field_defs['status'];
 377          if (isset($def['default'])) {
 378              return $def['default'];
 379          } else {
 380             $app = return_app_list_strings_language($GLOBALS['current_language']);
 381             if (isset($def['options']) && isset($app[$def['options']])) {
 382                 $keys = array_keys($app[$def['options']]);
 383                 return $keys[0];
 384             }
 385         }
 386         return '';
 387     }
 388
 389 }