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;*/
}
