function viewTaskList($due_on = 'today', $access = 'Private') { $this->access = $access; $this->tasks_due_on = $due_on; $OfuzList = new OfuzList($this); $OfuzList->setMultiSelect(true); $OfuzList->displayList(); }
function autoLoadContactsOnScrollDown(EventControler $event_controler) { /*echo 'searchkey: '.$event_controler->searchkey; echo 'filter: '.$event_controler->filter;*/ $OfuzList = new OfuzList($this); $OfuzList->setMultiSelect(true); if (trim($event_controler->searchkey)) { if ($this->contact_count >= $this->sql_qry_start) { $this->sql_qry_start = $this->sql_qry_start + $this->sql_view_limit; $this->clearSearch(); $this->search_keyword = $event_controler->searchkey; $this->setSqlQuery("SELECT contact.idcontact as idcontact,contact.firstname as firstname,contact.lastname as lastname,contact.company as company,contact.idcompany as idcompany,contact.position as position,contact.picture as picture,contact.email_address as email_address, contact.phone_number, contact.tags as tags\n FROM " . $this->getSqlViewName() . " as contact\n WHERE \n ( contact.firstname LIKE '%" . $this->search_keyword . "%'\n OR contact.lastname LIKE '%" . $this->search_keyword . "%'\n OR contact.company LIKE '%" . $this->search_keyword . "%')\n GROUP BY contact.idcontact\n ORDER BY " . $this->sql_view_order . " LIMIT " . $this->sql_qry_start . "," . $this->sql_view_limit); $this->query(); //$this->view_list_contacts(); $OfuzList->displayList(); } } elseif ($event_controler->filter) { if ($this->contact_count >= $this->sql_qry_start) { $this->sql_qry_start = $this->sql_qry_start + $this->sql_view_limit; $this->clearSearch(); $filter = $event_controler->filter; $sql_search = "SELECT contact.idcontact as idcontact, contact.firstname as firstname, contact.lastname as lastname,contact.company as company,contact.idcompany as idcompany, contact.position as position, contact.email_address as email_address, contact.phone_number,contact.picture as picture,contact.tags as tags FROM " . $this->getSqlViewName() . " AS contact"; if (!empty($filter)) { switch ($filter) { case "add": $sql_search .= " ORDER BY first_created DESC LIMIT " . $this->sql_qry_start . "," . $this->sql_view_limit; break; case "modify": $sql_search .= " ORDER BY last_update DESC LIMIT " . $this->sql_qry_start . "," . $this->sql_view_limit; break; case "view": $sql_search .= ", `breadcrumb` AS b WHERE b.`type`='" . $this->getTable() . "' and b.`id`=contact.idcontact AND b.iduser="******"\n GROUP BY contact.idcontact ORDER BY b.`when` DESC LIMIT " . $this->sql_qry_start . "," . $this->sql_view_limit; break; case "active": $sql_search .= " ORDER BY last_activity DESC LIMIT " . $this->sql_qry_start . "," . $this->sql_view_limit; break; case "alpha": $sql_search .= " ORDER BY lastname, firstname LIMIT " . $this->sql_qry_start . "," . $this->sql_view_limit; break; default: $sql_search .= " ORDER BY " . $this->sql_view_order . " LIMIT " . $this->sql_qry_start . "," . $this->sql_view_limit; } $this->filter = $filter; $this->setSqlQuery($sql_search); } else { $sql_search .= " ORDER BY " . $this->sql_view_order . " LIMIT " . $this->sql_qry_start . ',' . $this->sql_view_limit; $this->setSqlQuery($sql_search); } $this->query(); //$this->view_list_contacts(); $OfuzList->displayList(); //echo $this->getSqlQuery(); } } else { if ($this->contact_count >= $this->sql_qry_start) { $this->sql_qry_start = $this->sql_qry_start + $this->sql_view_limit; $this->clearSearch(); $sql_search = "SELECT contact.idcontact as idcontact, contact.firstname as firstname, contact.lastname as lastname,contact.company as company,contact.idcompany as idcompany, contact.position as position, contact.email_address as email_address, contact.phone_number,contact.picture as picture,contact.tags as tags FROM " . $this->getSqlViewName() . " AS contact"; $sql_search .= " ORDER BY " . $this->sql_view_order . " LIMIT " . $this->sql_qry_start . ',' . $this->sql_view_limit; $this->setSqlQuery($sql_search); $this->query(); //$this->view_list_contacts(); $OfuzList->displayList(); //echo $this->getSqlQuery(); } } }
/** * Function to view the project task using ListObject * @param string $access * @see ListObject */ function viewProjectTasks($access = 'Private') { $this->access = $access; $OfuzList = new OfuzList($this); $OfuzList->setMultiSelect(true); $OfuzList->displayList(); /*$do_contact = new Contact(); $html = '<ul id="project_tasks">'; while ($this->next()) { $contact_full_name = ""; if($this->idcontact) { $contact_full_name = ' ('.$do_contact->getContactName($this->idcontact).')'; } $progress_pixels = $this->progress; $strike_class = ''; if($this->status == 'closed'){ $strike_class = ' class="ptask_closed"'; } if (!is_numeric($progress_pixels) || $progress_pixels < 0 || $progress_pixels > 100) $progress_pixels = '0'; if($access == 'Public'){ $html .= '<li id="pt_'.$this->idtask.'">'. '<div class="ptask_name"><span class="task_category">'.$this->task_category.'</span> <span'.$strike_class.'><a href="/PublicTask/'.$this->idproject_task.'">'.$this->task_description.'</a>'.$contact_full_name.'</span></div>'. '<div class="ptask_progbar1">'; }else{ $html .= '<li id="pt_'.$this->idtask.'">'. '<div class="ptask_name"><span class="task_category">'.$this->task_category.'</span> <span'.$strike_class.'><a href="/Task/'.$this->idproject_task.'">'.$this->task_description.'</a>'.$contact_full_name.'</span></div>'. '<div class="ptask_progbar1">'; } if ($this->status == 'closed') { $html .= _('closed').'<div class="ptask_progbar3" style="width: 100px;"></div></div>'."\n"; } else { $html .= _('progress').'<div class="ptask_progbar2" style="width: '.$progress_pixels.'px;"></div></div>'."\n"; } if($access != 'Public'){ $html .= '<div class="ptask_handle"></div>'; } $html .= '</li>'."\n"; } $html .= '</ul>'; return $html;*/ }