@@ -42,7 +42,6 @@ |
||
| 42 | 42 | /** |
| 43 | 43 | * @method FuncApp App() |
| 44 | 44 | * @method AppCustomFieldSet getParentSet() |
| 45 | - |
|
| 46 | 45 | * @property string $name |
| 47 | 46 | * @property string $fieldname |
| 48 | 47 | * @property string $description |
@@ -52,7 +52,6 @@ |
||
| 52 | 52 | * @method AppCustomField request(mixed $criteria) |
| 53 | 53 | * @method AppCustomField[]|ORMMySqlIterator select(ORMCriteria $criteria) |
| 54 | 54 | * @method AppCustomField newRecord() |
| 55 | - |
|
| 56 | 55 | * @property ORMStringField $name |
| 57 | 56 | * @property ORMStringField $fieldname |
| 58 | 57 | * @property ORMTextField $description |
@@ -77,51 +77,51 @@ discard block |
||
| 77 | 77 | */ |
| 78 | 78 | function app_genericSetEditor(ORMRecordSet $set) |
| 79 | 79 | { |
| 80 | - /** @var FuncLibOrm $O */ |
|
| 81 | - $O = BabFunctionality::get('LibOrm'); |
|
| 82 | - $O->init(); |
|
| 83 | - $W = bab_Widgets(); |
|
| 84 | - $layout = $W->VBoxLayout(); |
|
| 85 | - $layout->setVerticalSpacing(1, 'em'); |
|
| 86 | - |
|
| 87 | - |
|
| 88 | - $fields = $set->getFields(); |
|
| 89 | - |
|
| 90 | - foreach ($fields as $field) { |
|
| 91 | - $description = $field->getDescription(); |
|
| 92 | - if (empty($description)) { |
|
| 93 | - $description = $field->getName(); |
|
| 94 | - } |
|
| 95 | - $fieldLabel = $W->Label($description . ':'); |
|
| 96 | - |
|
| 97 | - if ($field instanceof ORMDateField) { |
|
| 98 | - $widget = $W->DateEdit(); |
|
| 99 | - } else if ($field instanceof ORMTimeField) { |
|
| 100 | - $widget = $W->LineEdit()->setMaxSize(5)->setSize(5)->addClass('widget-timepicker'); |
|
| 101 | - } else if ($field instanceof ORMStringField) { |
|
| 102 | - $widget = $W->LineEdit()->setSize(min(array(80, $field->getMaxLength()))); |
|
| 103 | - } else if ($field instanceof ORMEnumField) { |
|
| 104 | - $widget = $W->Select(); |
|
| 105 | - $widget->addOption('', ''); |
|
| 106 | - foreach ($field->getValues() as $key => $text) { |
|
| 107 | - $widget->addOption($key, $text); |
|
| 108 | - } |
|
| 109 | - } else if ($field instanceof ORMIntField) { |
|
| 110 | - $widget = $W->LineEdit()->setSize(9); |
|
| 111 | - } else if ($field instanceof ORMTextField) { |
|
| 112 | - $widget = $W->TextEdit()->setColumns(80)->setLines(5); |
|
| 113 | - } else if ($field instanceof ORMRecordSet) { |
|
| 114 | - $widget = app_genericSetEditor($field); |
|
| 115 | - $widget->addClass('sub-form'); |
|
| 116 | - } else { |
|
| 117 | - $widget = null; |
|
| 118 | - } |
|
| 119 | - if (isset($widget)) { |
|
| 120 | - $layout->addItem($W->VBoxLayout()->addItem($fieldLabel)->addItem($widget)); |
|
| 121 | - } |
|
| 122 | - } |
|
| 123 | - |
|
| 124 | - return $layout; |
|
| 80 | + /** @var FuncLibOrm $O */ |
|
| 81 | + $O = BabFunctionality::get('LibOrm'); |
|
| 82 | + $O->init(); |
|
| 83 | + $W = bab_Widgets(); |
|
| 84 | + $layout = $W->VBoxLayout(); |
|
| 85 | + $layout->setVerticalSpacing(1, 'em'); |
|
| 86 | + |
|
| 87 | + |
|
| 88 | + $fields = $set->getFields(); |
|
| 89 | + |
|
| 90 | + foreach ($fields as $field) { |
|
| 91 | + $description = $field->getDescription(); |
|
| 92 | + if (empty($description)) { |
|
| 93 | + $description = $field->getName(); |
|
| 94 | + } |
|
| 95 | + $fieldLabel = $W->Label($description . ':'); |
|
| 96 | + |
|
| 97 | + if ($field instanceof ORMDateField) { |
|
| 98 | + $widget = $W->DateEdit(); |
|
| 99 | + } else if ($field instanceof ORMTimeField) { |
|
| 100 | + $widget = $W->LineEdit()->setMaxSize(5)->setSize(5)->addClass('widget-timepicker'); |
|
| 101 | + } else if ($field instanceof ORMStringField) { |
|
| 102 | + $widget = $W->LineEdit()->setSize(min(array(80, $field->getMaxLength()))); |
|
| 103 | + } else if ($field instanceof ORMEnumField) { |
|
| 104 | + $widget = $W->Select(); |
|
| 105 | + $widget->addOption('', ''); |
|
| 106 | + foreach ($field->getValues() as $key => $text) { |
|
| 107 | + $widget->addOption($key, $text); |
|
| 108 | + } |
|
| 109 | + } else if ($field instanceof ORMIntField) { |
|
| 110 | + $widget = $W->LineEdit()->setSize(9); |
|
| 111 | + } else if ($field instanceof ORMTextField) { |
|
| 112 | + $widget = $W->TextEdit()->setColumns(80)->setLines(5); |
|
| 113 | + } else if ($field instanceof ORMRecordSet) { |
|
| 114 | + $widget = app_genericSetEditor($field); |
|
| 115 | + $widget->addClass('sub-form'); |
|
| 116 | + } else { |
|
| 117 | + $widget = null; |
|
| 118 | + } |
|
| 119 | + if (isset($widget)) { |
|
| 120 | + $layout->addItem($W->VBoxLayout()->addItem($fieldLabel)->addItem($widget)); |
|
| 121 | + } |
|
| 122 | + } |
|
| 123 | + |
|
| 124 | + return $layout; |
|
| 125 | 125 | } |
| 126 | 126 | |
| 127 | 127 | |
@@ -134,50 +134,50 @@ discard block |
||
| 134 | 134 | */ |
| 135 | 135 | function app_genericSetFilterForm(ORMRecordSet $set) |
| 136 | 136 | { |
| 137 | - /** @var FuncLibOrm $O */ |
|
| 138 | - $O = BabFunctionality::get('LibOrm'); |
|
| 139 | - $O->init(); |
|
| 140 | - $W = bab_Widgets(); |
|
| 141 | - $layout = $W->FlowLayout(); |
|
| 142 | - $layout->setVerticalSpacing(1, 'em')->setHorizontalSpacing(1, 'em'); |
|
| 143 | - |
|
| 144 | - $fields = $set->getFields(); |
|
| 145 | - |
|
| 146 | - foreach ($fields as $field) { |
|
| 147 | - $description = $field->getDescription(); |
|
| 148 | - if (empty($description)) { |
|
| 149 | - $description = $field->getName(); |
|
| 150 | - } |
|
| 151 | - $fieldLabel = $W->Label($description . ':'); |
|
| 152 | - |
|
| 153 | - if ($field instanceof ORMDateField) { |
|
| 154 | - $widget = $W->PeriodEdit(); |
|
| 155 | - } else if ($field instanceof ORMTimeField) { |
|
| 156 | - $widget = $W->TimePicker(); |
|
| 157 | - } else if ($field instanceof ORMStringField) { |
|
| 158 | - $widget = $W->LineEdit()->setSize(min(array(15, $field->getMaxLength()))); |
|
| 159 | - } else if ($field instanceof ORMEnumField) { |
|
| 160 | - $widget = $W->Select(); |
|
| 161 | - $widget->addOption('', ''); |
|
| 162 | - foreach ($field->getValues() as $key => $text) { |
|
| 163 | - $widget->addOption($key, $text); |
|
| 164 | - } |
|
| 165 | - } else if ($field instanceof ORMIntField) { |
|
| 166 | - $widget = $W->LineEdit()->setSize(9); |
|
| 167 | - } else if ($field instanceof ORMTextField) { |
|
| 168 | - $widget = $widget = $W->LineEdit()->setSize(15); |
|
| 169 | - } else if ($field instanceof ORMRecordSet) { |
|
| 170 | - $widget = app_genericSetFilterForm($field); |
|
| 171 | - $widget->addClass('sub-form'); |
|
| 172 | - } else { |
|
| 173 | - $widget = null; |
|
| 174 | - } |
|
| 175 | - if (isset($widget)) { |
|
| 176 | - $layout->addItem($W->VBoxLayout()->addItem($fieldLabel)->addItem($widget)); |
|
| 177 | - } |
|
| 178 | - } |
|
| 179 | - |
|
| 180 | - return $layout; |
|
| 137 | + /** @var FuncLibOrm $O */ |
|
| 138 | + $O = BabFunctionality::get('LibOrm'); |
|
| 139 | + $O->init(); |
|
| 140 | + $W = bab_Widgets(); |
|
| 141 | + $layout = $W->FlowLayout(); |
|
| 142 | + $layout->setVerticalSpacing(1, 'em')->setHorizontalSpacing(1, 'em'); |
|
| 143 | + |
|
| 144 | + $fields = $set->getFields(); |
|
| 145 | + |
|
| 146 | + foreach ($fields as $field) { |
|
| 147 | + $description = $field->getDescription(); |
|
| 148 | + if (empty($description)) { |
|
| 149 | + $description = $field->getName(); |
|
| 150 | + } |
|
| 151 | + $fieldLabel = $W->Label($description . ':'); |
|
| 152 | + |
|
| 153 | + if ($field instanceof ORMDateField) { |
|
| 154 | + $widget = $W->PeriodEdit(); |
|
| 155 | + } else if ($field instanceof ORMTimeField) { |
|
| 156 | + $widget = $W->TimePicker(); |
|
| 157 | + } else if ($field instanceof ORMStringField) { |
|
| 158 | + $widget = $W->LineEdit()->setSize(min(array(15, $field->getMaxLength()))); |
|
| 159 | + } else if ($field instanceof ORMEnumField) { |
|
| 160 | + $widget = $W->Select(); |
|
| 161 | + $widget->addOption('', ''); |
|
| 162 | + foreach ($field->getValues() as $key => $text) { |
|
| 163 | + $widget->addOption($key, $text); |
|
| 164 | + } |
|
| 165 | + } else if ($field instanceof ORMIntField) { |
|
| 166 | + $widget = $W->LineEdit()->setSize(9); |
|
| 167 | + } else if ($field instanceof ORMTextField) { |
|
| 168 | + $widget = $widget = $W->LineEdit()->setSize(15); |
|
| 169 | + } else if ($field instanceof ORMRecordSet) { |
|
| 170 | + $widget = app_genericSetFilterForm($field); |
|
| 171 | + $widget->addClass('sub-form'); |
|
| 172 | + } else { |
|
| 173 | + $widget = null; |
|
| 174 | + } |
|
| 175 | + if (isset($widget)) { |
|
| 176 | + $layout->addItem($W->VBoxLayout()->addItem($fieldLabel)->addItem($widget)); |
|
| 177 | + } |
|
| 178 | + } |
|
| 179 | + |
|
| 180 | + return $layout; |
|
| 181 | 181 | } |
| 182 | 182 | |
| 183 | 183 | |
@@ -190,26 +190,26 @@ discard block |
||
| 190 | 190 | */ |
| 191 | 191 | function app_LabelledWidget($labelText, WidgetDisplayableInterface $widget) |
| 192 | 192 | { |
| 193 | - $W = bab_Widgets(); |
|
| 194 | - |
|
| 195 | - $label = $W->Label($labelText); |
|
| 196 | - if ($widget instanceof WidgetInputWidget) { |
|
| 197 | - $label->setAssociatedWidget($widget); |
|
| 198 | - } |
|
| 199 | - |
|
| 200 | - if ($widget instanceof WidgetCheckBox) { |
|
| 201 | - $layout = $W->HBoxItems( |
|
| 202 | - $widget->setSizePolicy(WidgetSizePolicy::MINIMUM), |
|
| 203 | - $label |
|
| 204 | - )->setVerticalAlign('middle')->setHorizontalSpacing(0.5, 'em'); |
|
| 205 | - } else { |
|
| 206 | - $layout = $W->VBoxItems( |
|
| 207 | - $label, |
|
| 208 | - $widget |
|
| 209 | - )->setVerticalSpacing(0.5, 'em'); |
|
| 210 | - } |
|
| 211 | - |
|
| 212 | - return $layout; |
|
| 193 | + $W = bab_Widgets(); |
|
| 194 | + |
|
| 195 | + $label = $W->Label($labelText); |
|
| 196 | + if ($widget instanceof WidgetInputWidget) { |
|
| 197 | + $label->setAssociatedWidget($widget); |
|
| 198 | + } |
|
| 199 | + |
|
| 200 | + if ($widget instanceof WidgetCheckBox) { |
|
| 201 | + $layout = $W->HBoxItems( |
|
| 202 | + $widget->setSizePolicy(WidgetSizePolicy::MINIMUM), |
|
| 203 | + $label |
|
| 204 | + )->setVerticalAlign('middle')->setHorizontalSpacing(0.5, 'em'); |
|
| 205 | + } else { |
|
| 206 | + $layout = $W->VBoxItems( |
|
| 207 | + $label, |
|
| 208 | + $widget |
|
| 209 | + )->setVerticalSpacing(0.5, 'em'); |
|
| 210 | + } |
|
| 211 | + |
|
| 212 | + return $layout; |
|
| 213 | 213 | } |
| 214 | 214 | |
| 215 | 215 | /** |
@@ -217,177 +217,177 @@ discard block |
||
| 217 | 217 | */ |
| 218 | 218 | function app_LabelledCheckbox($labelText, $checkboxName, $options = null) |
| 219 | 219 | { |
| 220 | - $W = bab_Widgets(); |
|
| 220 | + $W = bab_Widgets(); |
|
| 221 | 221 | |
| 222 | - $label = $W->Label($labelText)->colon(false); |
|
| 223 | - $checkbox = $W->Checkbox()->setName($checkboxName); |
|
| 224 | - $label->setAssociatedWidget($checkbox); |
|
| 225 | - if (isset($options)) { |
|
| 226 | - $label->setSizePolicy(WidgetSizePolicy::FIXED)->setCanvasOptions($options); |
|
| 227 | - } |
|
| 222 | + $label = $W->Label($labelText)->colon(false); |
|
| 223 | + $checkbox = $W->Checkbox()->setName($checkboxName); |
|
| 224 | + $label->setAssociatedWidget($checkbox); |
|
| 225 | + if (isset($options)) { |
|
| 226 | + $label->setSizePolicy(WidgetSizePolicy::FIXED)->setCanvasOptions($options); |
|
| 227 | + } |
|
| 228 | 228 | |
| 229 | - $layout = $W->HBoxItems( |
|
| 230 | - $checkbox->setSizePolicy(WidgetSizePolicy::MINIMUM), |
|
| 231 | - $label |
|
| 232 | - )->setVerticalAlign('middle')->setHorizontalSpacing(0.5, 'em'); |
|
| 229 | + $layout = $W->HBoxItems( |
|
| 230 | + $checkbox->setSizePolicy(WidgetSizePolicy::MINIMUM), |
|
| 231 | + $label |
|
| 232 | + )->setVerticalAlign('middle')->setHorizontalSpacing(0.5, 'em'); |
|
| 233 | 233 | |
| 234 | - return $layout; |
|
| 234 | + return $layout; |
|
| 235 | 235 | } |
| 236 | 236 | |
| 237 | 237 | function app_LabelledOrmSelect(ORMMySqlIterator $iterator, $fieldName, $selectName, $label, $hidden = false, $groupFieldName = null) |
| 238 | 238 | { |
| 239 | - $W = bab_Widgets(); |
|
| 240 | - |
|
| 241 | - if (isset($groupFieldName)) { |
|
| 242 | - $groupPathElements = explode('/', $groupFieldName); |
|
| 243 | - } |
|
| 244 | - |
|
| 245 | - $select = $W->Select()->setName($selectName); |
|
| 246 | - |
|
| 247 | - $select->addOption('', ''); |
|
| 248 | - |
|
| 249 | - $nbOptions = 0; |
|
| 250 | - foreach ($iterator as $record) { |
|
| 251 | - if (isset($record->code)) { |
|
| 252 | - $optionText = $record->code . ' - ' . $record->$fieldName; |
|
| 253 | - } else { |
|
| 254 | - $optionText = $record->$fieldName; |
|
| 255 | - } |
|
| 256 | - if (isset($groupFieldName)) { |
|
| 257 | - $group = $record; |
|
| 258 | - foreach ($groupPathElements as $groupPathElement) { |
|
| 259 | - $group = $group->$groupPathElement; |
|
| 260 | - } |
|
| 261 | - $select->addOption($record->id, $optionText, $group); |
|
| 262 | - } else { |
|
| 263 | - $select->addOption($record->id, $optionText); |
|
| 264 | - } |
|
| 265 | - $nbOptions++; |
|
| 266 | - $lastId = $record->id; |
|
| 267 | - } |
|
| 268 | - |
|
| 269 | - if ($nbOptions == 1) { |
|
| 270 | - $select->setValue($lastId); |
|
| 271 | - } |
|
| 272 | - |
|
| 273 | - |
|
| 274 | - return app_LabelledWidget($label, $select); |
|
| 239 | + $W = bab_Widgets(); |
|
| 240 | + |
|
| 241 | + if (isset($groupFieldName)) { |
|
| 242 | + $groupPathElements = explode('/', $groupFieldName); |
|
| 243 | + } |
|
| 244 | + |
|
| 245 | + $select = $W->Select()->setName($selectName); |
|
| 246 | + |
|
| 247 | + $select->addOption('', ''); |
|
| 248 | + |
|
| 249 | + $nbOptions = 0; |
|
| 250 | + foreach ($iterator as $record) { |
|
| 251 | + if (isset($record->code)) { |
|
| 252 | + $optionText = $record->code . ' - ' . $record->$fieldName; |
|
| 253 | + } else { |
|
| 254 | + $optionText = $record->$fieldName; |
|
| 255 | + } |
|
| 256 | + if (isset($groupFieldName)) { |
|
| 257 | + $group = $record; |
|
| 258 | + foreach ($groupPathElements as $groupPathElement) { |
|
| 259 | + $group = $group->$groupPathElement; |
|
| 260 | + } |
|
| 261 | + $select->addOption($record->id, $optionText, $group); |
|
| 262 | + } else { |
|
| 263 | + $select->addOption($record->id, $optionText); |
|
| 264 | + } |
|
| 265 | + $nbOptions++; |
|
| 266 | + $lastId = $record->id; |
|
| 267 | + } |
|
| 268 | + |
|
| 269 | + if ($nbOptions == 1) { |
|
| 270 | + $select->setValue($lastId); |
|
| 271 | + } |
|
| 272 | + |
|
| 273 | + |
|
| 274 | + return app_LabelledWidget($label, $select); |
|
| 275 | 275 | } |
| 276 | 276 | |
| 277 | 277 | |
| 278 | 278 | function app_OrmWidget(ORMField $field) |
| 279 | 279 | { |
| 280 | 280 | |
| 281 | - $W = bab_Widgets(); |
|
| 282 | - if ($field instanceof ORMDateField) { |
|
| 283 | - $widget = $W->DateEdit(); |
|
| 284 | - } else if ($field instanceof ORMTimeField) { |
|
| 285 | - $widget = $W->TimeEdit(); //->setMaxSize(5)->setSize(5)->addClass('widget-timepicker'); |
|
| 286 | - } else if ($field instanceof ORMDatetimeField) { |
|
| 287 | - $widget = $W->DateTimePicker(); //->setMaxSize(5)->setSize(5)->addClass('widget-timepicker'); |
|
| 288 | - } else if ($field instanceof ORMEnumField) { |
|
| 289 | - $widget = $W->Select(); |
|
| 290 | - //// $widget = $W->MultiSelect()->setSingleSelect(); |
|
| 291 | - $widget->addOption('', ''); |
|
| 292 | - $values = $field->getValues(); |
|
| 293 | - foreach ($values as $key => $value) { |
|
| 294 | - $widget->addOption($key, $value); |
|
| 295 | - } |
|
| 296 | - } else if ($field instanceof ORMSetField) { |
|
| 297 | - $widget = $W->MultiSelect()->setSelectedList(2); |
|
| 298 | - $values = $field->getValues(); |
|
| 299 | - foreach ($values as $key => $value) { |
|
| 300 | - $widget->addOption($key, $value); |
|
| 301 | - } |
|
| 302 | - } else if ($field instanceof ORMUserField) { |
|
| 303 | - $widget = $W->SuggestUser() |
|
| 304 | - ->setMinChars(0) |
|
| 305 | - ->setSizePolicy(FuncIcons::ICON_LEFT_16); |
|
| 306 | - } else if ($field instanceof ORMCurrencyField) { |
|
| 307 | - $widget = $W->LineEdit()->setSize(6)->addClass('widget-input-currency'); |
|
| 308 | - } else if ($field instanceof ORMBoolField) { |
|
| 309 | - $widget = $W->CheckBox()->setCheckedValue('1'); |
|
| 310 | - } else if ($field instanceof ORMIntField) { |
|
| 311 | - $widget = $W->LineEdit() |
|
| 312 | - ->setSize(6)->addClass('widget-input-numeric'); |
|
| 313 | - } else if ($field instanceof ORMEmailField) { |
|
| 314 | - $widget = $W->EmailLineEdit() |
|
| 315 | - ->setMaxSize($field->getMaxLength()); |
|
| 316 | - } else if ($field instanceof ORMFileField) { |
|
| 317 | - $widget = $W->FilePicker(); |
|
| 318 | - } else if ($field instanceof ORMStringField) { |
|
| 319 | - $widget = $W->LineEdit() |
|
| 320 | - ->setMaxSize($field->getMaxLength()); |
|
| 321 | - } else if ($field instanceof ORMTextField) { |
|
| 322 | - $widget = $W->TextEdit() |
|
| 323 | - ->addClass('widget-autoresize'); |
|
| 324 | - } else if ($field instanceof ORMPkField) { |
|
| 325 | - $widget = $W->Hidden(); |
|
| 326 | - } else if ($field instanceof ORMFkField) { |
|
| 327 | - |
|
| 328 | - $fieldName = $field->getName(); |
|
| 329 | - /** @var AppRecordSet $parentSet */ |
|
| 330 | - $parentSet = clone $field->getParentSet(); |
|
| 331 | - $parentSet->join($fieldName); |
|
| 332 | - $set = $parentSet->$fieldName; |
|
| 333 | - $records = $set->select(); |
|
| 334 | - $pkName = $set->getPrimaryKey(); |
|
| 335 | - if ($set->fieldExist("name")) { |
|
| 336 | - $displayField = $set->name->getName(); |
|
| 337 | - } else if (method_exists($set, "getDisplayNameField")) { |
|
| 338 | - $displayField = $set->getDisplayNameField()->getName(); |
|
| 339 | - } else { |
|
| 340 | - $displayField = $pkName; |
|
| 341 | - } |
|
| 342 | - $records->orderAsc($set->$displayField); |
|
| 343 | - if ($records->count() > 50) { |
|
| 344 | - $widget = bab_Widgets()->select2(); |
|
| 345 | - $widget->setDataSource($set->getController()->search()); |
|
| 346 | - } else { |
|
| 347 | - $widget = $W->Select(); |
|
| 348 | - $widget->addOption('', ''); |
|
| 349 | - foreach ($records as $record) { |
|
| 350 | - $widget->addOption($record->$pkName, $record->$displayField); |
|
| 351 | - } |
|
| 352 | - } |
|
| 353 | - } else if ($field instanceof ORMRecordSet) { |
|
| 354 | - $widget = $W->Select(); |
|
| 355 | - //// $widget = $W->MultiSelect()->setSingleSelect(); |
|
| 356 | - // $fieldName = $field->getName(); |
|
| 357 | - // $parentSet = $field->getParentSet(); |
|
| 358 | - // $parentSet->join($fieldName); |
|
| 359 | - // $set = $parentSet->$fieldName; |
|
| 360 | - $records = $field->select(); |
|
| 361 | - $records->orderAsc($field->name); |
|
| 362 | - $pkName = $field->getPrimaryKey(); |
|
| 363 | - $widget->addOption('', ''); |
|
| 364 | - foreach ($records as $record) { |
|
| 365 | - $widget->addOption($record->$pkName, $record->name); |
|
| 366 | - } |
|
| 367 | - } else { |
|
| 368 | - $widget = $W->LineEdit(); |
|
| 369 | - } |
|
| 370 | - $widget->setName($field->getName()); |
|
| 371 | - return $widget; |
|
| 281 | + $W = bab_Widgets(); |
|
| 282 | + if ($field instanceof ORMDateField) { |
|
| 283 | + $widget = $W->DateEdit(); |
|
| 284 | + } else if ($field instanceof ORMTimeField) { |
|
| 285 | + $widget = $W->TimeEdit(); //->setMaxSize(5)->setSize(5)->addClass('widget-timepicker'); |
|
| 286 | + } else if ($field instanceof ORMDatetimeField) { |
|
| 287 | + $widget = $W->DateTimePicker(); //->setMaxSize(5)->setSize(5)->addClass('widget-timepicker'); |
|
| 288 | + } else if ($field instanceof ORMEnumField) { |
|
| 289 | + $widget = $W->Select(); |
|
| 290 | + //// $widget = $W->MultiSelect()->setSingleSelect(); |
|
| 291 | + $widget->addOption('', ''); |
|
| 292 | + $values = $field->getValues(); |
|
| 293 | + foreach ($values as $key => $value) { |
|
| 294 | + $widget->addOption($key, $value); |
|
| 295 | + } |
|
| 296 | + } else if ($field instanceof ORMSetField) { |
|
| 297 | + $widget = $W->MultiSelect()->setSelectedList(2); |
|
| 298 | + $values = $field->getValues(); |
|
| 299 | + foreach ($values as $key => $value) { |
|
| 300 | + $widget->addOption($key, $value); |
|
| 301 | + } |
|
| 302 | + } else if ($field instanceof ORMUserField) { |
|
| 303 | + $widget = $W->SuggestUser() |
|
| 304 | + ->setMinChars(0) |
|
| 305 | + ->setSizePolicy(FuncIcons::ICON_LEFT_16); |
|
| 306 | + } else if ($field instanceof ORMCurrencyField) { |
|
| 307 | + $widget = $W->LineEdit()->setSize(6)->addClass('widget-input-currency'); |
|
| 308 | + } else if ($field instanceof ORMBoolField) { |
|
| 309 | + $widget = $W->CheckBox()->setCheckedValue('1'); |
|
| 310 | + } else if ($field instanceof ORMIntField) { |
|
| 311 | + $widget = $W->LineEdit() |
|
| 312 | + ->setSize(6)->addClass('widget-input-numeric'); |
|
| 313 | + } else if ($field instanceof ORMEmailField) { |
|
| 314 | + $widget = $W->EmailLineEdit() |
|
| 315 | + ->setMaxSize($field->getMaxLength()); |
|
| 316 | + } else if ($field instanceof ORMFileField) { |
|
| 317 | + $widget = $W->FilePicker(); |
|
| 318 | + } else if ($field instanceof ORMStringField) { |
|
| 319 | + $widget = $W->LineEdit() |
|
| 320 | + ->setMaxSize($field->getMaxLength()); |
|
| 321 | + } else if ($field instanceof ORMTextField) { |
|
| 322 | + $widget = $W->TextEdit() |
|
| 323 | + ->addClass('widget-autoresize'); |
|
| 324 | + } else if ($field instanceof ORMPkField) { |
|
| 325 | + $widget = $W->Hidden(); |
|
| 326 | + } else if ($field instanceof ORMFkField) { |
|
| 327 | + |
|
| 328 | + $fieldName = $field->getName(); |
|
| 329 | + /** @var AppRecordSet $parentSet */ |
|
| 330 | + $parentSet = clone $field->getParentSet(); |
|
| 331 | + $parentSet->join($fieldName); |
|
| 332 | + $set = $parentSet->$fieldName; |
|
| 333 | + $records = $set->select(); |
|
| 334 | + $pkName = $set->getPrimaryKey(); |
|
| 335 | + if ($set->fieldExist("name")) { |
|
| 336 | + $displayField = $set->name->getName(); |
|
| 337 | + } else if (method_exists($set, "getDisplayNameField")) { |
|
| 338 | + $displayField = $set->getDisplayNameField()->getName(); |
|
| 339 | + } else { |
|
| 340 | + $displayField = $pkName; |
|
| 341 | + } |
|
| 342 | + $records->orderAsc($set->$displayField); |
|
| 343 | + if ($records->count() > 50) { |
|
| 344 | + $widget = bab_Widgets()->select2(); |
|
| 345 | + $widget->setDataSource($set->getController()->search()); |
|
| 346 | + } else { |
|
| 347 | + $widget = $W->Select(); |
|
| 348 | + $widget->addOption('', ''); |
|
| 349 | + foreach ($records as $record) { |
|
| 350 | + $widget->addOption($record->$pkName, $record->$displayField); |
|
| 351 | + } |
|
| 352 | + } |
|
| 353 | + } else if ($field instanceof ORMRecordSet) { |
|
| 354 | + $widget = $W->Select(); |
|
| 355 | + //// $widget = $W->MultiSelect()->setSingleSelect(); |
|
| 356 | + // $fieldName = $field->getName(); |
|
| 357 | + // $parentSet = $field->getParentSet(); |
|
| 358 | + // $parentSet->join($fieldName); |
|
| 359 | + // $set = $parentSet->$fieldName; |
|
| 360 | + $records = $field->select(); |
|
| 361 | + $records->orderAsc($field->name); |
|
| 362 | + $pkName = $field->getPrimaryKey(); |
|
| 363 | + $widget->addOption('', ''); |
|
| 364 | + foreach ($records as $record) { |
|
| 365 | + $widget->addOption($record->$pkName, $record->name); |
|
| 366 | + } |
|
| 367 | + } else { |
|
| 368 | + $widget = $W->LineEdit(); |
|
| 369 | + } |
|
| 370 | + $widget->setName($field->getName()); |
|
| 371 | + return $widget; |
|
| 372 | 372 | } |
| 373 | 373 | |
| 374 | 374 | function app_LabelledOrmWidget(ORMField $field, $label = null, $hidden = false) |
| 375 | 375 | { |
| 376 | - $W = bab_Widgets(); |
|
| 376 | + $W = bab_Widgets(); |
|
| 377 | 377 | |
| 378 | - if ($hidden) { |
|
| 379 | - $widget = $W->Hidden(); |
|
| 380 | - $widget->setName($field->getName()); |
|
| 381 | - return $widget; |
|
| 382 | - } |
|
| 378 | + if ($hidden) { |
|
| 379 | + $widget = $W->Hidden(); |
|
| 380 | + $widget->setName($field->getName()); |
|
| 381 | + return $widget; |
|
| 382 | + } |
|
| 383 | 383 | |
| 384 | - if (is_null($label)) { |
|
| 385 | - $label = $field->getDescription(); |
|
| 386 | - } |
|
| 384 | + if (is_null($label)) { |
|
| 385 | + $label = $field->getDescription(); |
|
| 386 | + } |
|
| 387 | 387 | |
| 388 | - $widget = app_OrmWidget($field); |
|
| 388 | + $widget = app_OrmWidget($field); |
|
| 389 | 389 | |
| 390 | - return app_LabelledWidget($label, $widget); |
|
| 390 | + return app_LabelledWidget($label, $widget); |
|
| 391 | 391 | } |
| 392 | 392 | |
| 393 | 393 | /** |
@@ -400,16 +400,16 @@ discard block |
||
| 400 | 400 | function app_dateTime(ORMField $field, $value) |
| 401 | 401 | { |
| 402 | 402 | |
| 403 | - $W = bab_Widgets(); |
|
| 404 | - $name = $field->getName(); |
|
| 405 | - $label = $W->Label($field->getDescription()); |
|
| 403 | + $W = bab_Widgets(); |
|
| 404 | + $name = $field->getName(); |
|
| 405 | + $label = $W->Label($field->getDescription()); |
|
| 406 | 406 | |
| 407 | - $frame = app_dateTimeField($name, $label, $value); |
|
| 407 | + $frame = app_dateTimeField($name, $label, $value); |
|
| 408 | 408 | |
| 409 | - return $W->VBoxItems( |
|
| 410 | - $label, |
|
| 411 | - $frame |
|
| 412 | - ); |
|
| 409 | + return $W->VBoxItems( |
|
| 410 | + $label, |
|
| 411 | + $frame |
|
| 412 | + ); |
|
| 413 | 413 | } |
| 414 | 414 | |
| 415 | 415 | /** |
@@ -422,22 +422,22 @@ discard block |
||
| 422 | 422 | */ |
| 423 | 423 | function app_dateTimeField($fieldName, WidgetLabel $label, $value = null) |
| 424 | 424 | { |
| 425 | - $W = bab_Widgets(); |
|
| 425 | + $W = bab_Widgets(); |
|
| 426 | 426 | |
| 427 | - $datepart = $W->DateEdit()->setAssociatedLabel($label)->setName('date'); |
|
| 428 | - $timepart = $W->TimePicker()->setName('time'); |
|
| 427 | + $datepart = $W->DateEdit()->setAssociatedLabel($label)->setName('date'); |
|
| 428 | + $timepart = $W->TimePicker()->setName('time'); |
|
| 429 | 429 | |
| 430 | - if (isset($value)) { |
|
| 430 | + if (isset($value)) { |
|
| 431 | 431 | |
| 432 | - $value = explode(' ', $value); |
|
| 432 | + $value = explode(' ', $value); |
|
| 433 | 433 | |
| 434 | - $datepart->setValue($value[0]); |
|
| 435 | - $timepart->setValue($value[1]); |
|
| 436 | - } |
|
| 434 | + $datepart->setValue($value[0]); |
|
| 435 | + $timepart->setValue($value[1]); |
|
| 436 | + } |
|
| 437 | 437 | |
| 438 | - $datetime = $W->Frame(null, $W->HBoxLayout())->setName($fieldName) |
|
| 439 | - ->addItem($datepart) |
|
| 440 | - ->addItem($timepart); |
|
| 438 | + $datetime = $W->Frame(null, $W->HBoxLayout())->setName($fieldName) |
|
| 439 | + ->addItem($datepart) |
|
| 440 | + ->addItem($timepart); |
|
| 441 | 441 | |
| 442 | - return $datetime; |
|
| 442 | + return $datetime; |
|
| 443 | 443 | } |