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-2012 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     protected function formatStartAndDueDates(&$task_fields, $dbtime, $override_date_for_subpanel)
 242     {
 243         global $timedate;
 244
 245         if(empty($dbtime)) return;
 246
 247         $today = $timedate->nowDbDate();
 248
 249         $task_fields['TIME_DUE'] = $timedate->to_display_time($dbtime);
 250         $task_fields['DATE_DUE'] = $timedate->to_display_date($dbtime);
 251
 252         $date_due = $task_fields['DATE_DUE'];
 253
 254         $dd = $timedate->to_db_date($date_due, false);
 255         $taskClass = 'futureTask';
 256                 if ($dd < $today){
 257             $taskClass = 'overdueTask';
 258                 }else if( $dd   == $today ){
 259             $taskClass = 'todaysTask';
 260                 }
 261         $task_fields['DATE_DUE']= "<font class='$taskClass'>$date_due</font>";
 262         if($override_date_for_subpanel){
 263             $task_fields['DATE_START']= "<font class='$taskClass'>$date_due</font>";
 264         }
 265     }
 266
 267         function get_list_view_data(){
 268                 global $action, $currentModule, $focus, $current_module_strings, $app_list_strings, $timedate;
 269
 270                 $override_date_for_subpanel = false;
 271                 if(!empty($_REQUEST['module']) && $_REQUEST['module'] !='Calendar' && $_REQUEST['module'] !='Tasks' && $_REQUEST['module'] !='Home'){
 272                         //this is a subpanel list view, so override the due date with start date so that collections subpanel works as expected
 273                         $override_date_for_subpanel = true;
 274                 }
 275
 276                 $today = $timedate->nowDb();
 277                 $task_fields = $this->get_list_view_array();
 278                 $dbtime = $timedate->to_db($task_fields['DATE_DUE']);
 279                 if($override_date_for_subpanel){
 280                         $dbtime = $timedate->to_db($task_fields['DATE_START']);
 281                 }
 282
 283         if(!empty($dbtime))
 284         {
 285             $task_fields['TIME_DUE'] = $timedate->to_display_time($dbtime);
 286             $task_fields['DATE_DUE'] = $timedate->to_display_date($dbtime);
 287             $this->formatStartAndDueDates($task_fields, $dbtime, $override_date_for_subpanel);
 288         }
 289
 290                 if (!empty($this->priority))
 291                         $task_fields['PRIORITY'] = $app_list_strings['task_priority_dom'][$this->priority];
 292                 if (isset($this->parent_type))
 293                         $task_fields['PARENT_MODULE'] = $this->parent_type;
 294                 if ($this->status != "Completed" && $this->status != "Deferred" )
 295                 {
 296                         $setCompleteUrl = "<a id='{$this->id}' onclick='SUGAR.util.closeActivityPanel.show(\"{$this->module_dir}\",\"{$this->id}\",\"Completed\",\"listview\",\"1\");'>";
 297                     $task_fields['SET_COMPLETE'] = $setCompleteUrl . SugarThemeRegistry::current()->getImage("close_inline","title=".translate('LBL_LIST_CLOSE','Tasks')." border='0'",null,null,'.gif',translate('LBL_LIST_CLOSE','Tasks'))."</a>";
 298                 }
 299
 300                 //make sure we grab the localized version of the contact name, if a contact is provided
 301                 if (!empty($this->contact_id)) {
 302             // Bug# 46125 - make first name, last name, salutation and title of Contacts respect field level ACLs
 303             $contact = BeanFactory::getBean("Contacts", $this->contact_id);
 304                         if(isset($contact->id)) {
 305                             $this->contact_name = $contact->full_name;
 306                 $this->contact_phone = $contact->phone_work;
 307                         }
 308                 }
 309
 310                 $task_fields['CONTACT_NAME']= $this->contact_name;
 311                 $task_fields['CONTACT_PHONE']= $this->contact_phone;
 312                 $task_fields['TITLE'] = '';
 313                 if (!empty($task_fields['CONTACT_NAME'])) {
 314                         $task_fields['TITLE'] .= $current_module_strings['LBL_LIST_CONTACT'].": ".$task_fields['CONTACT_NAME'];
 315                 }
 316                 if (!empty($this->parent_name)) {
 317                         $task_fields['TITLE'] .= "\n".$app_list_strings['parent_type_display'][$this->parent_type].": ".$this->parent_name;
 318                         $task_fields['PARENT_NAME']=$this->parent_name;
 319                 }
 320
 321                 return $task_fields;
 322         }
 323
 324         function set_notification_body($xtpl, $task)
 325         {
 326                 global $app_list_strings;
 327         global $timedate;
 328         $notifyUser = $task->current_notify_user;
 329         $prefDate = $notifyUser->getUserDateTimePreferences();
 330                 $xtpl->assign("TASK_SUBJECT", $task->name);
 331                 //MFH #13507
 332                 $xtpl->assign("TASK_PRIORITY", (isset($task->priority)?$app_list_strings['task_priority_dom'][$task->priority]:""));
 333
 334         if(!empty($task->date_due))
 335         {
 336                     $duedate = $timedate->fromDb($task->date_due);
 337             $xtpl->assign("TASK_DUEDATE", $timedate->asUser($duedate, $notifyUser)." ".TimeDate::userTimezoneSuffix($duedate, $notifyUser));
 338         } else {
 339             $xtpl->assign("TASK_DUEDATE", '');
 340         }
 341
 342                 $xtpl->assign("TASK_STATUS", (isset($task->status)?$app_list_strings['task_status_dom'][$task->status]:""));
 343                 $xtpl->assign("TASK_DESCRIPTION", $task->description);
 344
 345                 return $xtpl;
 346         }
 347
 348         function bean_implements($interface){
 349                 switch($interface){
 350                         case 'ACL':return true;
 351                 }
 352                 return false;
 353         }
 354         function listviewACLHelper(){
 355                 $array_assign = parent::listviewACLHelper();
 356                 $is_owner = false;
 357                 if(!empty($this->parent_name)){
 358                         if(!empty($this->parent_name_owner)){
 359                                 global $current_user;
 360                                 $is_owner = $current_user->id == $this->parent_name_owner;
 361                         }
 362                 }
 363
 364                         if(!ACLController::moduleSupportsACL($this->parent_type) || ACLController::checkAccess($this->parent_type, 'view', $is_owner)){
 365                                 $array_assign['PARENT'] = 'a';
 366                         }else{
 367                                 $array_assign['PARENT'] = 'span';
 368                         }
 369                 $is_owner = false;
 370                 if(!empty($this->contact_name)){
 371                         if(!empty($this->contact_name_owner)){
 372                                 global $current_user;
 373                                 $is_owner = $current_user->id == $this->contact_name_owner;
 374                         }
 375                 }
 376
 377                 if( ACLController::checkAccess('Contacts', 'view', $is_owner)){
 378                                 $array_assign['CONTACT'] = 'a';
 379                 }else{
 380                                 $array_assign['CONTACT'] = 'span';
 381                 }
 382
 383                 return $array_assign;
 384         }
 385
 386         public function getDefaultStatus()
 387     {
 388          $def = $this->field_defs['status'];
 389          if (isset($def['default'])) {
 390              return $def['default'];
 391          } else {
 392             $app = return_app_list_strings_language($GLOBALS['current_language']);
 393             if (isset($def['options']) && isset($app[$def['options']])) {
 394                 $keys = array_keys($app[$def['options']]);
 395                 return $keys[0];
 396             }
 397         }
 398         return '';
 399     }
 400
 401 }