includes/ui/simple_crud_class.inc

   1 <?php
   2 /**********************************************************************
   3     Copyright (C) FrontAccounting, LLC.
   4         Released under the terms of the GNU General Public License, GPL,
   5         as published by the Free Software Foundation, either version 3
   6         of the License, or (at your option) any later version.
   7     This program is distributed in the hope that it will be useful,
   8     but WITHOUT ANY WARRANTY; without even the implied warranty of
   9     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
  10     See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
  11 ***********************************************************************/
  12 //
  13 //      Template for simple table editors
  14 //
  15 class simple_crud {
  16         var $name;
  17         var $Mode;
  18         var $selected_id;
  19         var $_none = ''; // selector value when no item is selected
  20         var $pre_handlers; // control buttons and related methods called before view display
  21         var $views;
  22         var $data = array();
  23         var $fields;
  24         var $tool_buttons;
  25         var $options;
  26         var $dec;
  27         //
  28         //
  29         function __construct($name, $fields = null)
  30         {
  31                 $this->name = $name;
  32                 $this->pre_handlers = array(
  33                         'Edit' => '_edit',
  34                         'Delete' => '_delete',
  35                         'NEW' => '_edit',
  36                         'ADD' => '_add',
  37                         'UPDATE' => '_update',
  38                         'RESET' => '_cancel',
  39                         'CLONE' => '_cloning'
  40                         );
  41                 $this->views = array(
  42                         '' => 'list_view',                      // default view
  43                         'Edit' => 'editor_view',
  44                         'Delete' => 'list_view',
  45                         'NEW' => 'editor_view',
  46                         'ADD' => 'editor_view',
  47                         'UPDATE' => 'editor_view',
  48                         'RESET' => 'list_view',
  49                         'CLONE' => 'editor_view'
  50                         );
  51                 $this->tool_buttons['Edit'] =
  52                         array(_('Edit'), _('Edit document line'), ICON_EDIT, '');
  53                 $this->tool_buttons['Delete'] =
  54                         array(_('Delete'), _('Remove line from document'), ICON_DELETE, '');
  55                 $this->tool_buttons['UPDATE'] =
  56                         array(_('Update'), _('Confirm changes'), ICON_UPDATE, '');
  57                 $this->tool_buttons['RESET'] =
  58                         array(_('Cancel'), _('Cancel changes'), ICON_CANCEL, '');
  59
  60                 $this->fields = $fields;
  61                 $this->selected_id = $this->_none;
  62         }
  63         /*
  64                 Input/output formatters - convert values between php/user domains.
  65         */
  66         function _format_input($value, $fmt)
  67         {
  68                 switch($fmt) {
  69                         case 'stock':
  70                                 $this->dec = get_qty_dec($value);
  71                                 return $value;
  72                         case 'price':
  73                         case 'qty':
  74                         case 'number':
  75                                     return user_numeric($value);
  76                         case 'percent':
  77                                         return user_numeric($value)/100;
  78                         case 'text':
  79                         case 'date':
  80                         default:
  81                                 return $value;
  82                 }
  83         }
  84
  85         function _format_output($value, $fmt)
  86         {
  87                 switch($fmt) {
  88                         case 'price':
  89                                 return price_format($value);
  90                         case 'qty':
  91                                 return number_format2($value, $this->dec);
  92                         case 'number':
  93                                 return number_format2($value);
  94                         case 'percent':
  95                                 return percent_format($value*100);
  96                         case 'stock':
  97                                 $this->dec = get_qty_dec($value); // retrieve dec for use in later qty fields
  98                         case 'text':
  99                         case 'date':
 100                         default:
 101                                 return $value;
 102                 }
 103         }
 104
 105         function _check_mode()
 106         {
 107                 global $Ajax;
 108
 109                 // list controls lookup
 110                 foreach (array_keys($this->pre_handlers) as $m) {
 111                         if (isset($_POST[$this->name.$m])) {
 112                                 unset($_POST['_focus']); // focus on first form entry
 113                                 $Ajax->activate($this->name.'_div');
 114                                 $val = @key($_POST[$this->name.$m]);
 115                                 $this->selected_id = $val!==null ? @quoted_printable_decode($val) : $this->_none;
 116                                 return $m;
 117                         }
 118                 }
 119                 $mod = get_post($this->name.'Mode', '');
 120                 if ($mod) {
 121                         $val = @key($mod);
 122                         $this->selected_id = $val!==null ? @quoted_printable_decode($val) : $this->_none;
 123                         return $mod[$val];
 124                 }
 125                 return '';
 126         }
 127
 128         //
 129         //      Set record for edition
 130         //
 131         function _edit($mode)
 132         {
 133                 if ($this->Mode != $mode) {
 134                         if ($this->selected_id != $this->_none) {
 135                                 $this->data = $this->db_read();
 136                         }
 137                         $this->set_posts($this->data);
 138                 }
 139                 $this->Mode = $mode;
 140         }
 141         //
 142         //      Update record after edition
 143         //
 144         function _update($mode)
 145         {
 146                 $this->get_posts();
 147                 if ($this->update_check()) {
 148                         if ($this->db_update()) {
 149                                 $this->selected_id = $this->_none;
 150                                 $this->Mode = '';
 151                                 return;
 152                         }
 153                 }
 154                 $this->Mode = $mode;
 155         }
 156         //
 157         //      Add new record
 158         //
 159         function _add($mode)
 160         {
 161                 $this->get_posts();
 162                 if ($this->insert_check()) {
 163                         $this->db_insert();
 164                         $this->_cancel();
 165                         return;
 166                 }
 167                 $this->Mode = $mode;
 168         }
 169         //
 170         //      Delete selected  record
 171         //
 172         function _delete()
 173         {
 174                 if ($this->delete_check())
 175                         $this->db_delete();
 176                 $this->_cancel();
 177         }
 178         //
 179         //      Return to listing view
 180         //
 181         function _cancel()
 182         {
 183                 $this->selected_id = $this->_none;
 184                 $this->db_cancel();
 185                 $this->Mode = '';
 186         }
 187         //
 188         // Clone record for new edition
 189         //
 190         function _cloning()
 191         {
 192                 $this->Mode = '';
 193                 $this->_edit('Edit');
 194                 $this->selected_id = $this->_none;
 195         }
 196         /*
 197                 Generate form controls
 198         */
 199         function _bottom_controls()
 200         {
 201                 $clone = $this->selected_id != $this->_none;
 202
 203                 $title=false;
 204                 $async='both';
 205                 $base=$this->name;
 206
 207                 $cancel = $async;
 208
 209                 if ($async === 'both') {
 210                         $async = 'default'; $cancel = 'cancel';
 211                 }
 212                 elseif ($async === 'default')
 213                         $cancel = true;
 214                 elseif ($async === 'cancel')
 215                         $async = true;
 216                 echo "<center>";
 217
 218                 if ($this->Mode == '' || $this->Mode == 'RESET')
 219                         submit("{$base}NEW", _("Add new"), true, $title, $async);
 220                 else {
 221                         if ($this->Mode == 'NEW' || $this->selected_id==$this->_none)
 222
 223                                 submit("{$base}ADD", _("Add"), true, $title, $async);
 224                         else {
 225                                 submit("{$base}UPDATE[{$this->selected_id}]", _("Update"), true, _('Submit changes'), $async);
 226                                 if ($clone)
 227                                         submit("{$base}CLONE[{$this->selected_id}]", _("Clone"), true, _('Edit new record with current data'), $async);
 228                         }
 229                         submit("{$base}RESET", _("Cancel"), true, _('Cancel edition'), $cancel);
 230                 }
 231                 echo "</center>";
 232         }
 233         //===========================================================================
 234         // Public functions
 235         //
 236
 237         function tool_button($name, $selected_id=null, $params='')
 238         {
 239                 $b = $this->tool_buttons[$name];
 240
 241                 return "<td align='center' $params>"
 242                         .button( "{$this->name}$name"
 243                                 .($selected_id === null || $selected_id === $this->_none ? '': "[$selected_id]"),
 244                                 $b[0], $b[1], $b[2], $b[3])."</td>";
 245         }
 246
 247         function set_posts()
 248         {
 249                 foreach($this->fields as $name => $fmt) {
 250                         if (is_int($name)) {
 251                                 $name = $fmt;
 252                                 $fmt = array();
 253                         }
 254                         $post = isset($fmt['post']) ? $fmt['post'] : $name;
 255                         $fld = isset($fmt['fld']) ? $fmt['fld'] : $name;
 256
 257                         $value = $this->selected_id == $this->_none ? @$fmt['dflt'] :
 258                                 (is_array($this->data) ? $this->data[$fld]: $this->data->$fld);
 259
 260                         $_POST[$post] = $this->_format_output($value, @$fmt['fmt']);
 261                 }
 262         }
 263         //--------------------------
 264         //
 265         //      Get editor POST variables.
 266         //
 267         function get_posts() {
 268                 foreach ($this->fields as $name => $fmt) {
 269                         if (is_int($name)) {
 270                                 $name = $fmt;
 271                                 $fmt = array();
 272                         }
 273                         $post = isset($fmt['post']) ? $fmt['post'] : $name;
 274                         $fld = isset($fmt['fld']) ? $fmt['fld'] : $name;
 275
 276                         $value = $this->_format_input(@$_POST[$post], @$fmt['fmt']);
 277                         if (is_array($this->data))
 278                                 $this->data[$fld] = $value;
 279                         else
 280                                 $this->data->$fld = $value;
 281                 }
 282         }
 283         //      Main function - display current CRUD editor content
 284         //
 285         function show()
 286         {
 287                 if (!isset($_POST[$this->name.'Mode']))
 288                         $this->set_posts();
 289
 290                 $Mode = $this->_check_mode(true);
 291                 div_start($this->name.'_div');
 292
 293                 if (array_key_exists($Mode, $this->pre_handlers)) {
 294                         $fun = $this->pre_handlers[$Mode];
 295                         $this->$fun($Mode);
 296                 }
 297
 298                 if (isset($this->views[$this->Mode]))
 299                         $this->{$this->views[$this->Mode]}();
 300                 else
 301                         $this->{$this->views['']}(); // default view
 302
 303                 $this->_bottom_controls();
 304                 // this is needed only when we use temporary crud object together with ajax screen updates
 305                 hidden($this->name.'Mode'.'['.$this->selected_id.']', $this->Mode);
 306                 div_end();
 307         }
 308
 309         //===========================================================================
 310         //      Database functions placeholders
 311
 312         //
 313         //      Read record from db for edition
 314         //
 315         function db_read() {
 316                 display_notification(__FUNCTION__. ' is not defined...');
 317                 return array();
 318         }
 319         //
 320         //      Update record in db after edition
 321         //
 322         function db_update()
 323         {
 324                 $this->db_insert();
 325         }
 326         //
 327         //      Delete record
 328         //
 329         function db_delete() {
 330                 display_notification(__FUNCTION__. ' is not defined...');
 331         }
 332         //
 333         //      Insert record
 334         //
 335         function db_insert()
 336         {
 337                 display_notification(__FUNCTION__. ' is not defined...');
 338         }
 339         //
 340         //      Cancel edition
 341         //      Optional things like focus set.
 342         //
 343         function db_cancel()
 344         {
 345         }
 346
 347
 348         function delete_check() {
 349                 display_notification(__FUNCTION__. ' is not defined...');
 350                 return true;
 351         }
 352
 353         function insert_check() {
 354                 return true;
 355         }
 356
 357         function update_check()
 358         {
 359                 return $this->insert_check();
 360         }
 361
 362         //
 363         //      Show database content in pager/table
 364         //
 365         function list_view() {
 366                 display_notification(__FUNCTION__. ' is not defined...');
 367         }
 368
 369         //
 370         //      Show record editor screen content
 371         //
 372         function editor_view() {
 373                 display_notification(__FUNCTION__. ' is not defined...');
 374         }
 375 };
 376