Subversion Repositories php_library

        <tr>

          <td>

             CHILD_KEY_INSERT_TAG

          </td>

          <td>

             String

          </td>

          <td>

             This value is used to indicate an insert from an edit of a child table. See note in "children" for a fuller explaination.

          </td>

          <td>

             define ( CHILD_KEY_INSERT_TAG, 'new');

          </td>

        </tr>

        <tr>

          <td>

             CHILD_KEY_DELIMITER

          </td>

          <td>

             String

          </td>

          <td>

             This value is used to separate components of INPUT names in an edit of a child table. See note in "children" for a fuller explaination.

          </td>

          <td>

             define ( CHILD_KEY_DELIMITER, '-' );

          </td>

        </tr>

        <tr>

          <td>

             CHILD_KEY_TAG

          </td>

          <td>

             String

          </td>

          <td>

             This value is used to indicate an update from an edit of a child table. See note in "children" for a fuller explaination.

          </td>

          <td>

             define ( CHILD_KEY_TAG, 'child_table' );

          </td>

        </tr>

       <tr>

          <td>

             new record indicator

          </td>

          <td>

             array of columns

          </td>

          <td>

             Array of columns, any one of which would indicate that a new record template had data entered into it. This should be one or more of the required fields, and is used as an indicator in function updateData when processing child tables that the single row used for adding a new entry had been updated and should be processed.

          </td>

          <td>

             'new record indicator' => array('value')

          </td>

        </tr>

    <p>To fix this, the library will give a unique name to each item, based on the column name, a constant (global constant CHILD_KEY_TAG), the table name from which the data is drawn, and the unique row-id (ie, a 'key field' entry) for the row being edited. These values are separated by a delimiter (global constant CHILD_KEY_DELIMITER).</p>

    <p>Additionally, a "blank" row is created in these circumstances to allow the user to enter a new record if they desire. This will take the same form as the previous paragraph, except that the row-id is replaced by a special indicator (global constant CHILD_KEY_INSERT_TAG)</p>

    <p>The name of the edit for an existing key is therefore calculated as:<br>

       <em>fieldname</em> . CHILD_KEY_DELIMITER . CHILD_KEY_TAG . CHILD_KEY_DELIMITER . <em>tablename</em> . CHILD_KEY_DELIMITER . <em>primary_key_value_of_row</em> <br>

      and the name for the single "blank" record is calculated as:<br>

      <em>fieldname</em> . CHILD_KEY_DELIMITER . CHILD_KEY_TAG . CHILD_KEY_DELIMITER . <em>tablename</em> . CHILD_KEY_DELIMITER . CHILD_KEY_INSERT_TAG

    </p>

    <p>

       This gives rise to entries on the HTML form as follows, the first being an edit of the username field of a child table <em>login</em> whose row id is 5, and the second being a blank record to add a new row.

    </p>

<ul><LI>       &lt;td&gt;&lt;input type='text' name='<em>username</em>-child_table-<em>login</em>-<em>5</em>' value='jane@example.com'&gt;</li><li>

       &lt;td&gt;&lt;input type='text' name='<em>username</em>-child_table-<em>login</em>-<em>new</em>' value=''&gt;

</LI></ul>

<p>The above example assumes the following definitions in yoru database definition file</p>

<pre>

   define ( CHILD_KEY_INSERT_TAG, 'new');

   define ( CHILD_KEY_DELIMITER, '-' );

   define ( CHILD_KEY_TAG, 'child_table' );

</pre>

<p><strong>Note:</strong> You are responsible for ensuring the CHILD_KEY_DELIMITER is not found within field or table names. If you tend to use underscores in your field or table names (like I do), you can not use them as the delimiter. This needs to be a delimiter which is legitimate as the name of an HTML entity and is not  found in the table name, column name or key field value</p>

   define ( CHILD_KEY_INSERT_TAG, 'new');

   define ( CHILD_KEY_DELIMITER, '-' );

   define ( CHILD_KEY_TAG, 'child_table' );

   define ( DEFAULT_TEXTAREA_HEIGHT, 5 ); // number of rows a textarea will default to

   define ( DEFAULT_TABLE, 'client');     // the table that will show up in doAdmin by default

                      'client_id' => array( 'type' => 'lookup',   // this is the field type, and must be ints

                                            'table' => 'client',    // remote table name

                                            'keyfield' => 'client_id',  // keyfield in remote table, ie category.category_id 

                                            'display_field' => 'name' // this is the column displayed to the user

                                          ),

                      'name' => array('type' => 'string' , 'width' => 64),

                      'notes' => array('type' => 'text', 'width'=> 80 ),

                      'removed_date' => array('type' => 'date', 'default' => 'null' )

                      'device_id' => array('keyfield' => 1 , 'required' => true , 'readonly' => true , 'type' => 'int' , 'width' => 10),

                      'name' => array('required' => true , 'default' => '' , 'type' => 'string' , 'width' => 255),

                                            'display_field' => 'name', // this is the column displayed to the user

                                            'null_ok' => true

                                          ),

                      'device_type_id' => array( 'type' => 'lookup',   // this is the field type, and must be ints

                                            'table' => 'device_type',    // remote table name

                                            'keyfield' => 'device_type_id',  // keyfield in remote table, ie category.category_id 

                      'site_id' =>  array( 'type' => 'lookup',   // this is the field type, and must be ints

                                            'query' => "select site_id,concat(client.name, ' - ', site.name) from site join client on site.client_id = client.client_id order by client.name,site.name",

                                            'table' => 'site',    // remote table name

                                            'keyfield' => 'site_id',  // keyfield in remote table, ie category.category_id 

                                            'display_field' => 'name' // this is the column displayed to the user

                      'added_date' => array('type' => 'date', 'default' => date('Y-m-d H:i:s')),

                      'removed_date' => array('type' => 'date', 'default' => 'null')

       'child tables' => array ( 

             'device_attrib' => array( 'table name' => 'device_attrib' ) 

       )

    ),

      'device_attrib' => array( 

              'display name' => 'Device Attributes',

              'table name' => 'device_attrib',

              'key field' => 'device_attrib_id',

              'new record indicator' => array('value'),

              'display columns' => array('name'),

              'display query' => 'select device_attrib_id,attrib.name, device_attrib.value from device_attrib join attrib using (attrib_id)',

              'field info' => array(

                      'device_attrib_id' => array('keyfield' => 1 , 

                                                  'required' => true , 

                                                  'readonly' => true , 

                                                  'type' => 'int' , 

                                                  'width' => 10,

                                                  'display name' => 'ID'

                                                  ),

                      'device_id' => array ( 'type' => 'lookup',   // this is the field type, and must be ints

                                            'table' => 'device',    // remote table name

                                            'keyfield' => 'device_id',  // keyfield in remote table, ie category.category_id 

                                            'display_field' => 'name', // this is the column displayed to the user

                                            'null_ok' => false,

                                            'display name' => 'Device'),

                      'attrib_id' => array( 'type' => 'lookup',   // this is the field type, and must be ints

                                            'table' => 'attrib',    // remote table name

                                            'keyfield' => 'attrib_id',  // keyfield in remote table, ie category.category_id 

                                            'display_field' => 'name', // this is the column displayed to the user

                                            'null_ok' => false,

                                            'display name' => 'Attribute'

                                          ),

                      'value' => array('type' => 'text', 'required' => true, 'width'=> 40, 'height' => 1, 'display name' => 'Value' ),

                      'added_date' => array('type' => 'date', 'default' => date('Y-m-d H:i:s'), 'display name' => 'Date Added'),

                      'removed_date' => array('type' => 'date', 'default' => 'null', 'display name' => 'Date Removed')

              )