templates/xml/member/member_list_booking.xml

   1 <?xml version="1.0" encoding="UTF-8" ?>
   2 <!--
   3 This template provides meta data for listing member's booking
   4
   5 @author         Roland Haeder <webmaster@mxchange.org>
   6 @version        0.2.1-FINAL
   7 @copyright      (c) 2003 - 2009 by Roland Haeder
   8 @copyright      (c) 2009 - 2016 by Mailer Developer Team
   9 @license        GNU GPL 2.0 or any newer version
  10 @link           http://mxchange.org
  11
  12 This program is free software; you can redistribute it and/or modify
  13 it under the terms of the GNU General Public License as published by
  14 the Free Software Foundation; either version 2 of the License, or
  15 (at your option) any later version.
  16
  17 This program is distributed in the hope that it will be useful,
  18 but WITHOUT ANY WARRANTY; without even the implied warranty of
  19 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  20 GNU General Public License for more details.
  21
  22 You should have received a copy of the GNU General Public License
  23 along with this program; if not, write to the Free Software
  24 Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,
  25 MA  02110-1301  USA
  26 //-->
  27 <member-list-data>
  28         <!--
  29         Call-back function, the extracted data from this XML will then be re-read
  30         from that function. The most common function this XML uses is
  31         doGenericListEntries() so mostly you can leave this alone unless you have JOINs.
  32         //-->
  33         <callback-function type="string" value="doGenericListEntries" />
  34         <!--
  35         Now we need information which template should be loaded and which functions
  36         shall be called back. So lets start with the main list template. This mostly
  37         requires no call-back function.
  38         //-->
  39         <list-template type="string" value="member_list_booking" />
  40         <!--
  41         The template for all rows, mostly this name has a '_row' suffix and again,
  42         no call-back function is usually required.
  43         //-->
  44         <list-row-template type="string" value="member_list_booking_row" />
  45         <!--
  46         Message id to display if no entry could be found
  47         //-->
  48         <no-entry-found-message type="string" value="MEMBER_BOOKING_404" />
  49         <!--
  50         The table(s) we shall grab the data from, all as list.
  51         //-->
  52         <data-tables>
  53                 <!--
  54                 A single table entry, with alias and without the configurable
  55                 _MYSQL_PREFIX. You can specify the table's name or alias later on.
  56                 //-->
  57                 <data-table type="string" alias="" value="user_booking" />
  58                 <!--
  59                 Columns to perform the SELECT statement on, with alias and name plus which table.
  60                 //-->
  61                 <select-data-from-list>
  62                         <!--
  63                         A single entry with table name (can be left empty), value (must
  64                         always be set), alias (again can be left empty) and SQL function
  65                         (can also be left empty) which shall be applied on the column.
  66                         //-->
  67                         <select-data-from-list-entry type="string" table="" value="subject" alias="" function="" />
  68                         <select-data-from-list-entry type="string" table="" value="points_mode" alias="" function="" />
  69                         <select-data-from-list-entry type="string" table="" value="points_account_type" alias="" function="" />
  70                         <select-data-from-list-entry type="string" table="" value="points" alias="" function="" />
  71                         <select-data-from-list-entry type="string" table="" value="comments" alias="" function="" />
  72                         <select-data-from-list-entry type="string" table="" value="recorded" alias="recorded" function="UNIX_TIMESTAMP" />
  73                 </select-data-from-list>
  74                 <!--
  75                 And the column list to perform the WHERE statement on.
  76                 //-->
  77                 <where-select-from-list>
  78                         <!--
  79                         Search for current user's booking
  80                         //-->
  81                         <where-select-from-list-entry type="string" table="" value="userid" condition="EQUALS" look-for="{%pipe,getMemberId%}" />
  82                 </where-select-from-list>
  83                 <!--
  84                 Columns to perform the ORDER BY statement (GROUP BY is not yet supported)
  85                 //-->
  86                 <order-by-list>
  87                         <!--
  88                         A single entry to perform the ORDER BY statement on, see above WHERE entry for details.
  89                         //-->
  90                         <order-by-list-entry type="string" table="" order="recorded" value="DESC" />
  91                 </order-by-list>
  92         </data-tables>
  93         <!--
  94         List all column names from the 'select-data-from-list' node here, but now
  95         with call-back informations. The list must only contain those entries where
  96         a call-back function shall be called for.
  97         //-->
  98         <column-callback-list>
  99                 <!--
 100                 Another column, now we need a second parameter here because
 101                 generateDateTime() expects two parameters (first is always the data
 102                 from column).
 103                 //-->
 104                 <column-callback-list-entry>
 105                         <!--
 106                         The actual data, again.
 107                         //-->
 108                         <column-callback-data type="string" value="recorded" callback="generateDateTime" />
 109                         <!--
 110                         More parameters, remember that the first parameter is always given
 111                         and that it is the data from column.
 112                         //-->
 113                         <callback-extra-parameter-list>
 114                                 <!--
 115                                 A single parameter, 'type' can be one of 'float', 'int',
 116                                 'bool', 'string'. 'array' is not yet supported.
 117                                 //-->
 118                                 <callback-extra-parameter-list-entry type="int" column="recorded" value="2" />
 119                         </callback-extra-parameter-list>
 120                 </column-callback-list-entry>
 121         </column-callback-list>
 122 </member-list-data>