function ~public_file_name~_main() {~opt_public_display {~
- $id = _REQUEST_cut('~public_file_name~_id');
+ $id = _REQUEST_cut('id');
if($id) {
return ~file_name~_main_display($id);~opt_public_form unset {~
} else {
}~}~
-function ~file_name~_main(~opt_display unset {~~opt_public_form {~$new_only = false~}~~}~) {~opt_pass {~
+function ~file_name~_main() {~opt_pass {~
if(logged_in_as_admin()) {
tem_set('admin_privs');
} else {
return 'admin_login';
}
~}~~opt_db {~
- $id = _REQUEST_cut('~file_name~_edit_id');
+ $id = _REQUEST_cut('edit_id');
if($id) {
return ~file_name~_main_form($id);
}
return ~file_name~_main_delete($id);
}
- if(_REQUEST_cut('~file_name~_new')) {
+ if(_REQUEST_cut('new')) {
return ~file_name~_main_form();
}
~}~~opt_listing {~
- if(_REQUEST_cut('~file_name~_list')) {
+ if(_REQUEST_cut('list')) {
return ~file_name~_main_listing();
}
~}~~opt_display {~
- $id = _REQUEST_cut('~file_name~_id');
+ $id = _REQUEST_cut('id');
if($id) {
return ~file_name~_main_display($id);
}
~}~~opt_listing {~
+ if(_REQUEST_cut('download_csv')) {
+ return ~file_name~_csv_download();
+ }
+
if(isset($_POST['~always_field~'])) {
return ~file_name~_main_form();
}
return './~file_name~';
}~}~~opt_listing {~
+function ~file_name~_csv_download() {
+ require_once('code/wfpl/csv.php');
+ $rows = db_get_rows('~table_name~', 'id,'.~file_name upper~_DB_FIELDS, 'order by id');
+ array_unshift($rows, explode(',', 'id,'.~file_name upper~_DB_FIELDS));
+ array2d_to_csv_download($rows, '~file_name~.csv');
+}
+
function ~file_name~_main_listing() {
- $listing_rows = db_get_assocs('~table_name~', 'id~listing_fields_1 {~,~name~~}~', 'order by ~always_field~ limit 100');
- tem_set('listings', $listing_rows);
+ $data = array();
+ $desc = '';
+ $sort = _REQUEST_cut('sort');
+ if($sort && substr($sort, 0, 1) === '-') {
+ $sort = substr($sort, 1);
+ $desc = ' DESC ';
+ } else {
+ $data["sorting-by-$sort"] = '-';
+ }
+ $legal_sorts = explode(',', ~file_name upper~_DB_FIELDS);
+ if(!$sort || !in_array($sort, $legal_sorts)) {
+ $sort = '~always_field~';
+ }
+
+ $data['rows'] = db_get_assocs('~table_name~', 'id~listing_fields_1 {~,~name~~}~', "order by $sort $desc limit 1000");
+ tem_set('listings', $data);
}~}~
function ~file_name~_main_form($id = false) {~pulldowns {~
pulldown('~name~', ~pulldown_options~);~}~~has_pulldowns {~
~}~~opt_db {~
if($id) {
- # add hidden field for database id of row we're editing
- tem_set('~file_name~_edit_id', $id);
- tem_set('editing');
- tem_set('edit_msg');
- } else {
- tem_set('new_msg');
+ tem_set('id', $id);
}
~}~
if(isset($_POST['~always_field~'])) {
$to = $GLOBALS['~file_name~_form_recipient'];
$from = 'noreply@~this_domain~';
$reply_to = $to;
- if(isset($_REQUEST['email']) and valid_email($_REQUEST['email'])) {
- $reply_to = $_REQUEST['email'];
- if($_REQUEST['name'] and ereg('^[a-zA-Z0-9_\' -]*$', $_REQUEST['name']) !== false) {
- $reply_to = "$_REQUEST[name] <$reply_to>";
+ if(isset($data['email']) and valid_email($data['email'])) {
+ $reply_to = $data['email'];
+ if($data['name'] and ereg('^[a-zA-Z0-9_\' -]*$', $data['name']) !== false) {
+ $reply_to = "$data[name] <$reply_to>";
}
}
$subject = '~plural cap~ form submitted';
return './~file_name~~opt_db unset {~_thanks~}~';~}~
}
}
- # otherwise, we display the form again. ~file_name~_get_fields() has
- # already put the posted values back into the template engine, so they will
- # show up in the form fields. You should add some message asking people to
- # fix their entry in whatever way you require.~opt_db {~
+ # otherwise, we display the form again. We've got the form field
+ # values in $data and will put those back in the filds below. You
+ # should add some message asking people to fix their entry in
+ # whatever way you require.~opt_db {~
} elseif($id) {
# we've recieved an edit id, but no data. So we grab the values to be edited from the database
$data = db_get_assoc('~table_name~', ~file_name upper~_DB_FIELDS, 'where id=%i', $id);~}~
$data = array();
}~upload_max {~
- tem_set('upload_max_filesize', upload_max_filesize());~}~
+ tem_set('$upload_max_filesize', upload_max_filesize());~}~
tem_set('form', $data);~show_extra_headers {~
- tem_set('extra_headers');~}~
+ tem_set('$head');~}~
}