| @@ 147-176 (lines=30) @@ | ||
| 144 | * page from client cookie ({@link COOKIE_FIELDS_PAGE}) and updates it, if it's out of valid range. |
|
| 145 | * @return CRecordset Recordset with list of fields. |
|
| 146 | */ |
|
| 147 | function fields_list ($id, &$sort, &$page) |
|
| 148 | { |
|
| 149 | debug_write_log(DEBUG_TRACE, '[fields_list]'); |
|
| 150 | debug_write_log(DEBUG_DUMP, '[fields_list] $id = ' . $id); |
|
| 151 | ||
| 152 | $sort_modes = array |
|
| 153 | ( |
|
| 154 | 1 => 'field_order asc', |
|
| 155 | 2 => 'field_name asc', |
|
| 156 | 3 => 'field_type asc, field_name asc', |
|
| 157 | 4 => 'is_required asc, field_name asc', |
|
| 158 | 5 => 'guest_access asc, field_name asc', |
|
| 159 | 6 => 'field_order desc', |
|
| 160 | 7 => 'field_name desc', |
|
| 161 | 8 => 'field_type desc, field_name desc', |
|
| 162 | 9 => 'is_required desc, field_name desc', |
|
| 163 | 10 => 'guest_access desc, field_name desc', |
|
| 164 | ); |
|
| 165 | ||
| 166 | $sort = try_request('sort', try_cookie(COOKIE_FIELDS_SORT, 1)); |
|
| 167 | $sort = ustr2int($sort, 1, count($sort_modes)); |
|
| 168 | ||
| 169 | $page = try_request('page', try_cookie(COOKIE_FIELDS_PAGE)); |
|
| 170 | $page = ustr2int($page, 1, MAXINT); |
|
| 171 | ||
| 172 | save_cookie(COOKIE_FIELDS_SORT, $sort); |
|
| 173 | save_cookie(COOKIE_FIELDS_PAGE, $page); |
|
| 174 | ||
| 175 | return dal_query('fields/list.sql', $id, $sort_modes[$sort]); |
|
| 176 | } |
|
| 177 | ||
| 178 | /** |
|
| 179 | * Returns number of fields for specified state. |
|
| @@ 123-152 (lines=30) @@ | ||
| 120 | * page from client cookie ({@link COOKIE_STATES_PAGE}) and updates it, if it's out of valid range. |
|
| 121 | * @return CRecordset Recordset with list of states. |
|
| 122 | */ |
|
| 123 | function states_list ($id, &$sort, &$page) |
|
| 124 | { |
|
| 125 | debug_write_log(DEBUG_TRACE, '[states_list]'); |
|
| 126 | debug_write_log(DEBUG_DUMP, '[states_list] $id = ' . $id); |
|
| 127 | ||
| 128 | $sort_modes = array |
|
| 129 | ( |
|
| 130 | 1 => 'state_name asc', |
|
| 131 | 2 => 'state_abbr asc', |
|
| 132 | 3 => 'state_type asc, state_name asc', |
|
| 133 | 4 => 'responsible asc, state_name asc', |
|
| 134 | 5 => 'next_state asc, state_name asc', |
|
| 135 | 6 => 'state_name desc', |
|
| 136 | 7 => 'state_abbr desc', |
|
| 137 | 8 => 'state_type desc, state_name desc', |
|
| 138 | 9 => 'responsible desc, state_name desc', |
|
| 139 | 10 => 'next_state desc, state_name desc', |
|
| 140 | ); |
|
| 141 | ||
| 142 | $sort = try_request('sort', try_cookie(COOKIE_STATES_SORT, 3)); |
|
| 143 | $sort = ustr2int($sort, 1, count($sort_modes)); |
|
| 144 | ||
| 145 | $page = try_request('page', try_cookie(COOKIE_STATES_PAGE)); |
|
| 146 | $page = ustr2int($page, 1, MAXINT); |
|
| 147 | ||
| 148 | save_cookie(COOKIE_STATES_SORT, $sort); |
|
| 149 | save_cookie(COOKIE_STATES_PAGE, $page); |
|
| 150 | ||
| 151 | return dal_query('states/list.sql', $id, $sort_modes[$sort]); |
|
| 152 | } |
|
| 153 | ||
| 154 | /** |
|
| 155 | * Validates state information before creation or modification. |
|
| @@ 97-126 (lines=30) @@ | ||
| 94 | * page from client cookie ({@link COOKIE_TEMPLATES_PAGE}) and updates it, if it's out of valid range. |
|
| 95 | * @return CRecordset Recordset with list of templates. |
|
| 96 | */ |
|
| 97 | function templates_list ($id, &$sort, &$page) |
|
| 98 | { |
|
| 99 | debug_write_log(DEBUG_TRACE, '[templates_list]'); |
|
| 100 | debug_write_log(DEBUG_DUMP, '[templates_list] $id = ' . $id); |
|
| 101 | ||
| 102 | $sort_modes = array |
|
| 103 | ( |
|
| 104 | 1 => 'template_name asc', |
|
| 105 | 2 => 'template_prefix asc', |
|
| 106 | 3 => 'critical_age asc, template_name asc', |
|
| 107 | 4 => 'frozen_time asc, template_name asc', |
|
| 108 | 5 => 'description asc, template_name asc', |
|
| 109 | 6 => 'template_name desc', |
|
| 110 | 7 => 'template_prefix desc', |
|
| 111 | 8 => 'critical_age desc, template_name desc', |
|
| 112 | 9 => 'frozen_time desc, template_name desc', |
|
| 113 | 10 => 'description desc, template_name desc', |
|
| 114 | ); |
|
| 115 | ||
| 116 | $sort = try_request('sort', try_cookie(COOKIE_TEMPLATES_SORT)); |
|
| 117 | $sort = ustr2int($sort, 1, count($sort_modes)); |
|
| 118 | ||
| 119 | $page = try_request('page', try_cookie(COOKIE_TEMPLATES_PAGE)); |
|
| 120 | $page = ustr2int($page, 1, MAXINT); |
|
| 121 | ||
| 122 | save_cookie(COOKIE_TEMPLATES_SORT, $sort); |
|
| 123 | save_cookie(COOKIE_TEMPLATES_PAGE, $page); |
|
| 124 | ||
| 125 | return dal_query('templates/list.sql', $id, $sort_modes[$sort]); |
|
| 126 | } |
|
| 127 | ||
| 128 | /** |
|
| 129 | * Validates template information before creation or modification. |
|