ILIAS  release_9 Revision v9.13-25-g2c18ec4c24f
Public Member Functions | Protected Member Functions | Protected Attributes
ilPRGAssignmentFilter Class Reference
+ Collaboration diagram for ilPRGAssignmentFilter:

Public Member Functions

 __construct (ilLanguage $lng)
 
 withValues (array $values)
 
 toConditions ()
 
 getItemConfig ()
 

Protected Member Functions

 getCleanedValues ()
 

Protected Attributes

ilLanguage $lng
 
array $values = []
 

Detailed Description

Definition at line 21 of file ilPRGAssignmentFilter.php.

Constructor & Destructor Documentation

◆ __construct()

ilPRGAssignmentFilter::__construct ( ilLanguage  $lng)

Definition at line 26 of file ilPRGAssignmentFilter.php.

References $lng, and ILIAS\Repository\lng().

28  {
29  $this->lng = $lng;
30  }
+ Here is the call graph for this function:

Member Function Documentation

◆ getCleanedValues()

ilPRGAssignmentFilter::getCleanedValues ( )
protected

Definition at line 113 of file ilPRGAssignmentFilter.php.

References $id, ilTable2GUI\FILTER_CHECKBOX, ilTable2GUI\FILTER_DATE_RANGE, ilTable2GUI\FILTER_SELECT, ilTable2GUI\FILTER_TEXT, getItemConfig(), and ilStudyProgrammeUserTable\OPTION_ALL.

Referenced by toConditions().

113  : array
114  {
115  $ret = [];
116  foreach ($this->getItemConfig() as list($id, $type, $options)) {
117  if (array_key_exists($id, $this->values)) {
118  if ($type === ilTable2GUI::FILTER_SELECT
119  && (
120  $this->values[$id] == ilStudyProgrammeUserTable::OPTION_ALL
121  || $this->values[$id] === false
122  )
123  ) {
124  continue;
125  }
126  if ($type === ilTable2GUI::FILTER_TEXT
127  && $this->values[$id] == ''
128  ) {
129  continue;
130  }
131  if ($type === ilTable2GUI::FILTER_CHECKBOX
132  && ($this->values[$id] == false || is_null($this->values[$id]))
133  ) {
134  continue;
135  }
136  if ($type === ilTable2GUI::FILTER_DATE_RANGE
137  && $this->values[$id]['from'] == []
138  && $this->values[$id]['to'] == []
139  ) {
140  continue;
141  }
142  $ret[$id] = $this->values[$id];
143  }
144  };
145  return $ret;
146  }
$id
$id
plugin.php for ilComponentBuildPluginInfoObjectiveTest::testAddPlugins
Definition: plugin.php:23
+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ getItemConfig()

ilPRGAssignmentFilter::getItemConfig ( )
Returns
array <string $id, string $type, null | array $options>

Definition at line 151 of file ilPRGAssignmentFilter.php.

References ilTable2GUI\FILTER_CHECKBOX, ilTable2GUI\FILTER_DATE_RANGE, ilTable2GUI\FILTER_SELECT, ilTable2GUI\FILTER_TEXT, ILIAS\Repository\lng(), ilStudyProgrammeUserTable\OPTION_ALL, ilStudyProgrammeUserTable\OPTION_USR_ACTIVE, ilStudyProgrammeUserTable\OPTION_USR_INACTIVE, ilPRGAssignmentDBRepository\PROGRESS_FIELD_DEADLINE, ilPRGAssignmentDBRepository\PROGRESS_FIELD_INVALIDATED, ilPRGAssignmentDBRepository\PROGRESS_FIELD_STATUS, ilPRGAssignmentDBRepository\PROGRESS_FIELD_VQ_DATE, ilPRGProgress\STATUS_ACCREDITED, ilPRGProgress\STATUS_COMPLETED, ilPRGProgress\STATUS_FAILED, ilPRGProgress\STATUS_IN_PROGRESS, ilPRGProgress\STATUS_NOT_RELEVANT, ilStudyProgrammeUserTable\VALIDITY_OPTION_INVALID, and ilStudyProgrammeUserTable\VALIDITY_OPTION_VALID.

Referenced by getCleanedValues().

151  : array
152  {
153  $items = [];
154 
155  $items[] = [
156  ilPRGAssignmentDBRepository::PROGRESS_FIELD_INVALIDATED, //invalidated
157  ilTable2GUI::FILTER_SELECT,
158  [
159  ilStudyProgrammeUserTable::OPTION_ALL => $this->lng->txt("all"),
160  ilStudyProgrammeUserTable::VALIDITY_OPTION_VALID => $this->lng->txt("prg_still_valid"),
161  ilStudyProgrammeUserTable::VALIDITY_OPTION_INVALID => $this->lng->txt("prg_not_valid")
162  ],
163  $this->lng->txt('prg_validity')
164  ];
165 
166  $items[] = [
167  ilPRGAssignmentDBRepository::PROGRESS_FIELD_STATUS, //status
168  ilTable2GUI::FILTER_SELECT,
169  [
170  ilStudyProgrammeUserTable::OPTION_ALL => $this->lng->txt("all"),
171  ilPRGProgress::STATUS_IN_PROGRESS => $this->lng->txt("prg_status_in_progress"),
172  ilPRGProgress::STATUS_COMPLETED => $this->lng->txt("prg_status_completed"),
173  ilPRGProgress::STATUS_ACCREDITED => $this->lng->txt("prg_status_accredited"),
174  ilPRGProgress::STATUS_NOT_RELEVANT => $this->lng->txt("prg_status_not_relevant"),
175  ilPRGProgress::STATUS_FAILED => $this->lng->txt("prg_status_failed")
176  ],
177  ''
178  ];
179 
180  $items[] = ['prg_status_hide_irrelevant', ilTable2GUI::FILTER_CHECKBOX, null, ''];
181 
182  $items[] = [
183  'usr_active',
184  ilTable2GUI::FILTER_SELECT,
185  [
186  ilStudyProgrammeUserTable::OPTION_ALL => $this->lng->txt("all"),
187  ilStudyProgrammeUserTable::OPTION_USR_ACTIVE => $this->lng->txt("active_only"),
188  ilStudyProgrammeUserTable::OPTION_USR_INACTIVE => $this->lng->txt("inactive_only")
189  ],
190  ''
191  ];
192 
193  $items[] = ['name', ilTable2GUI::FILTER_TEXT, null, ''];
194 
195  $items[] = [
196  ilPRGAssignmentDBRepository::PROGRESS_FIELD_VQ_DATE,
197  ilTable2GUI::FILTER_DATE_RANGE,
198  null,
199  ''
200  ];
201 
202  $items[] = [
203  ilPRGAssignmentDBRepository::PROGRESS_FIELD_DEADLINE,
204  ilTable2GUI::FILTER_DATE_RANGE,
205  null,
206  ''
207  ];
208 
209  return $items;
210  }
+ Here is the call graph for this function:
+ Here is the caller graph for this function:

◆ toConditions()

ilPRGAssignmentFilter::toConditions ( )

Definition at line 39 of file ilPRGAssignmentFilter.php.

References getCleanedValues(), IL_CAL_DATE, ilStudyProgrammeUserTable\OPTION_USR_ACTIVE, ilStudyProgrammeUserTable\OPTION_USR_INACTIVE, ilPRGAssignmentDBRepository\PROGRESS_FIELD_INVALIDATED, ilPRGAssignmentDBRepository\PROGRESS_FIELD_STATUS, ilPRGProgress\STATUS_ACCREDITED, ilPRGProgress\STATUS_COMPLETED, ilPRGProgress\STATUS_NOT_RELEVANT, ilStudyProgrammeUserTable\VALIDITY_OPTION_INVALID, and ilStudyProgrammeUserTable\VALIDITY_OPTION_VALID.

39  : array
40  {
41  $conditions = [];
42  foreach ($this->getCleanedValues() as $field => $value) {
43  switch ($field) {
44  case 'status':
45  if ($value) {
46  $conditions[] = ilPRGAssignmentDBRepository::PROGRESS_FIELD_STATUS . '=' . $value;
47  }
48  break;
49  case 'prg_status_hide_irrelevant':
50  $conditions[] = ilPRGAssignmentDBRepository::PROGRESS_FIELD_STATUS . '<>' . ilPRGProgress::STATUS_NOT_RELEVANT;
51  break;
52  case 'name':
53  $conditions[] = '('
54  . 'memberdata.firstname LIKE \'%' . $value . '%\' OR' . PHP_EOL
55  . 'memberdata.lastname LIKE \'%' . $value . '%\' OR' . PHP_EOL
56  . 'memberdata.login LIKE \'%' . $value . '%\'' . PHP_EOL
57  . ')';
58  break;
59  case 'invalidated':
60  if ((int) $value == ilStudyProgrammeUserTable::VALIDITY_OPTION_INVALID) {
61  $conditions[] = ilPRGAssignmentDBRepository::PROGRESS_FIELD_INVALIDATED . ' = 1';
62  }
63  if ((int) $value == ilStudyProgrammeUserTable::VALIDITY_OPTION_VALID) {
64  $conditions[] = ilPRGAssignmentDBRepository::PROGRESS_FIELD_INVALIDATED . ' = 0';
65  $conditions[] = '('
66  . ilPRGAssignmentDBRepository::PROGRESS_FIELD_STATUS . '=' . ilPRGProgress::STATUS_COMPLETED
67  . ' OR '
68  . ilPRGAssignmentDBRepository::PROGRESS_FIELD_STATUS . '=' . ilPRGProgress::STATUS_ACCREDITED
69  . ')';
70  }
71  break;
72 
73  case 'usr_active':
74  if ((int) $value === ilStudyProgrammeUserTable::OPTION_USR_ACTIVE) {
75  $conditions[] = 'memberdata.active = 1';
76  }
77  if ((int) $value === ilStudyProgrammeUserTable::OPTION_USR_INACTIVE) {
78  $conditions[] = 'memberdata.active = 0';
79  }
80  break;
81  case 'vq_date':
82  list($from, $to) = array_values($value);
83  if ($from) {
84  $from = $from->get(IL_CAL_DATE);
85  $conditions[] = 'vq_date >= \'' . $from . ' 00:00:00\'';
86  }
87  if ($to) {
88  $to = $to->get(IL_CAL_DATE);
89  $conditions[] = 'vq_date <= \'' . $to . ' 23:59:59\'';
90  }
91  break;
92  case 'deadline':
93  list($from, $to) = array_values($value);
94  if ($to || $from) {
95  $conditions[] = 'deadline IS NOT NULL';
96  }
97  if ($from) {
98  $from = $from->get(IL_CAL_DATE);
99  $conditions[] = 'deadline >= \'' . $from . '\'';
100  }
101  if ($to) {
102  $to = $to->get(IL_CAL_DATE);
103  $conditions[] = 'deadline <= \'' . $to . '\'';
104  }
105  break;
106  default:
107  throw new ilException("missing field in filter (to condition): " . $field, 1);
108  }
109  }
110  return $conditions;
111  }
IL_CAL_DATE
const IL_CAL_DATE
Definition: class.ilDateTime.php:8
+ Here is the call graph for this function:

◆ withValues()

ilPRGAssignmentFilter::withValues ( array  $values)

Definition at line 32 of file ilPRGAssignmentFilter.php.

References $values.

32  : self
33  {
34  $clone = clone $this;
35  $clone->values = $values;
36  return $clone;
37  }

Field Documentation

◆ $lng

ilLanguage ilPRGAssignmentFilter::$lng
protected

Definition at line 23 of file ilPRGAssignmentFilter.php.

Referenced by __construct().

◆ $values

array ilPRGAssignmentFilter::$values = []
protected

Definition at line 24 of file ilPRGAssignmentFilter.php.

Referenced by withValues().

The documentation for this class was generated from the following file: