@@ 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. |