ILIAS  release_6 Revision v6.24-5-g0c8bfefb3b8
class.ilADTDateSearchBridgeRange.php
Go to the documentation of this file.
1<?php
2
3require_once "Services/ADT/classes/Bridges/class.ilADTSearchBridgeRange.php";
4
6{
7 protected function isValidADTDefinition(ilADTDefinition $a_adt_def)
8 {
9 return ($a_adt_def instanceof ilADTDateDefinition);
10 }
11
12
13 // table2gui / filter
14
15 public function loadFilter()
16 {
17 $value = $this->readFilter();
18 if ($value !== null) {
19 if ($value["lower"]) {
20 $this->getLowerADT()->setDate(new ilDate($value["lower"], IL_CAL_DATE));
21 }
22 if ($value["upper"]) {
23 $this->getUpperADT()->setDate(new ilDate($value["upper"], IL_CAL_DATE));
24 }
25 }
26 }
27
28
29 // form
30
31 public function addToForm()
32 {
33 global $DIC;
34
35 $lng = $DIC['lng'];
36
37 if ($this->getForm() instanceof ilPropertyFormGUI) {
38 $check = new ilCustomInputGUI($this->getTitle());
39
40 $date_from = new ilDateTimeInputGUI($lng->txt('from'), $this->addToElementId("lower"));
41 $date_from->setShowTime(false);
42 $check->addSubItem($date_from);
43
44 if ($this->getLowerADT()->getDate() && !$this->getLowerADT()->isNull()) {
45 $date_from->setDate($this->getLowerADT()->getDate());
46 $checked = true;
47 }
48
49 $date_until = new ilDateTimeInputGUI($lng->txt('until'), $this->addToElementId("upper"));
50 $date_until->setShowTime(false);
51 $check->addSubItem($date_until);
52
53 if ($this->getUpperADT()->getDate() && !$this->getUpperADT()->isNull()) {
54 $date_until->setDate($this->getUpperADT()->getDate());
55 $checked = true;
56 }
57
58 $this->addToParentElement($check);
59 } else {
60 include_once("./Services/Form/classes/class.ilCombinationInputGUI.php");
61 include_once("./Services/Form/classes/class.ilDateTimeInputGUI.php");
62
63 $item = new ilCombinationInputGUI($this->getTitle(), $this->getElementId());
64
65 $lower = new ilDateTimeInputGUI("", $this->addToElementId("lower"));
66 $item->addCombinationItem("lower", $lower, $lng->txt("from"));
67
68 if ($this->getLowerADT()->getDate() && !$this->getLowerADT()->isNull()) {
69 $lower->setDate($this->getLowerADT()->getDate());
70 }
71
72 $upper = new ilDateTimeInputGUI("", $this->addToElementId("upper"));
73 $item->addCombinationItem("upper", $upper, $lng->txt("to"));
74
75 if ($this->getUpperADT()->getDate() && !$this->getUpperADT()->isNull()) {
76 $upper->setDate($this->getUpperADT()->getDate());
77 }
78
79 $item->setComparisonMode(ilCombinationInputGUI::COMPARISON_ASCENDING);
80
81 $this->addToParentElement($item);
82 }
83 }
84
85 protected function shouldBeImportedFromPost($a_post)
86 {
87 if ($this->getForm() instanceof ilPropertyFormGUI &&
88 !(bool) $this->text_input) {
89 return (bool) $a_post["tgl"];
90 }
91 return parent::shouldBeImportedFromPost($a_post);
92 }
93
94 public function importFromPost(array $a_post = null)
95 {
96 $post = $this->extractPostValues($a_post);
97
98 if ($post && $this->shouldBeImportedFromPost($post)) {
99 include_once "Services/Calendar/classes/class.ilCalendarUtil.php";
100 $start = ilCalendarUtil::parseIncomingDate($post["lower"]);
101 $end = ilCalendarUtil::parseIncomingDate($post["upper"]);
102
103 if ($start && $end && $start->get(IL_CAL_UNIX) > $end->get(IL_CAL_UNIX)) {
104 $tmp = $start;
105 $start = $end;
106 $end = $tmp;
107 }
108
109 if ($this->getForm() instanceof ilPropertyFormGUI) {
110 $item = $this->getForm()->getItemByPostVar($this->getElementId() . "[lower]");
111 $item->setDate($start);
112
113 $item = $this->getForm()->getItemByPostVar($this->getElementId() . "[upper]");
114 $item->setDate($end);
115 } elseif (array_key_exists($this->getElementId(), $this->table_filter_fields)) {
116 $this->table_filter_fields[$this->getElementId()]->getCombinationItem("lower")->setDate($start);
117 $this->table_filter_fields[$this->getElementId()]->getCombinationItem("upper")->setDate($end);
118 $this->writeFilter(array(
119 "lower" => (!$start || $start->isNull()) ? null: $start->get(IL_CAL_DATE),
120 "upper" => (!$end || $end->isNull()) ? null : $end->get(IL_CAL_DATE)
121 ));
122 }
123
124 $this->getLowerADT()->setDate($start);
125 $this->getUpperADT()->setDate($end);
126 } else {
127 $this->getLowerADT()->setDate();
128 $this->getUpperADT()->setDate();
129 }
130 }
131
132
133 // db
134
135 public function getSQLCondition($a_element_id)
136 {
137 global $DIC;
138
139 $ilDB = $DIC['ilDB'];
140
141 if (!$this->isNull() && $this->isValid()) {
142 $sql = array();
143 if (!$this->getLowerADT()->isNull()) {
144 $sql[] = $a_element_id . " >= " . $ilDB->quote($this->getLowerADT()->getDate()->get(IL_CAL_DATE), "date");
145 }
146 if (!$this->getUpperADT()->isNull()) {
147 $sql[] = $a_element_id . " <= " . $ilDB->quote($this->getUpperADT()->getDate()->get(IL_CAL_DATE), "date");
148 }
149 return "(" . implode(" AND ", $sql) . ")";
150 }
151 }
152
153 public function isInCondition(ilADT $a_adt)
154 {
155 assert($a_adt instanceof ilADTDate);
156
157 if (!$this->getLowerADT()->isNull() && !$this->getUpperADT()->isNull()) {
158 return $a_adt->isInbetweenOrEqual($this->getLowerADT(), $this->getUpperADT());
159 } elseif (!$this->getLowerADT()->isNull()) {
160 return $a_adt->isLargerOrEqual($this->getLowerADT());
161 } else {
162 return $a_adt->isSmallerOrEqual($this->getUpperADT());
163 }
164 }
165
166
167 // import/export
168
169 public function getSerializedValue()
170 {
171 if (!$this->isNull() && $this->isValid()) {
172 $res = array();
173 if (!$this->getLowerADT()->isNull()) {
174 $res["lower"] = $this->getLowerADT()->getDate()->get(IL_CAL_DATE);
175 }
176 if (!$this->getUpperADT()->isNull()) {
177 $res["upper"] = $this->getUpperADT()->getDate()->get(IL_CAL_DATE);
178 }
179 return serialize($res);
180 }
181 }
182
183 public function setSerializedValue($a_value)
184 {
185 $a_value = unserialize($a_value);
186 if (is_array($a_value)) {
187 if (isset($a_value["lower"])) {
188 $this->getLowerADT()->setDate(new ilDate($a_value["lower"], IL_CAL_DATE));
189 }
190 if (isset($a_value["upper"])) {
191 $this->getUpperADT()->setDate(new ilDate($a_value["upper"], IL_CAL_DATE));
192 }
193 }
194 }
195}
An exception for terminatinating execution or to throw for unit testing.
const IL_CAL_DATE
const IL_CAL_UNIX
setSerializedValue($a_value)
Set current value(s) in serialized form (for easy persisting)
addToForm()
Add ADT-specific fields to form.
loadFilter()
Load filter value(s) into ADT.
isValidADTDefinition(ilADTDefinition $a_adt_def)
Check if given ADT definition is valid.
shouldBeImportedFromPost($a_post)
Check if incoming values should be imported at all.
getSerializedValue()
Get current value(s) in serialized form (for easy persisting)
isInCondition(ilADT $a_adt)
Compare directly against ADT.
getSQLCondition($a_element_id)
Get SQL condition for current value(s)
importFromPost(array $a_post=null)
Import values from (search) form request POST data.
ADT definition base class.
readFilter()
Load value(s) from filter store (in session)
extractPostValues(array $a_post=null)
Extract data from (post) values.
addToElementId($a_add)
Add sub-element.
addToParentElement(ilFormPropertyGUI $a_field)
Add form field to parent element.
getElementId()
Get element id.
writeFilter($a_value=null)
Write value(s) to filter store (in session)
ADT base class.
Definition: class.ilADT.php:12
isSmallerOrEqual(ilADT $a_adt)
Check if given ADT is smaller or equal than self.
isLargerOrEqual(ilADT $a_adt)
Check if given ADT is larger or equal than self.
isInbetweenOrEqual(ilADT $a_adt_from, ilADT $a_adt_to)
Check if self is inbetween given ADTs (inclusive)
static parseIncomingDate($a_value, $a_add_time=null)
Try to parse incoming value to date object.
This class represents a number property in a property form.
This class represents a custom property in a property form.
This class represents a date/time property in a property form.
Class for single dates.
This class represents a property form user interface.
$lng
foreach($_POST as $key=> $value) $res
global $ilDB
$DIC
Definition: xapitoken.php:46