X-Git-Url: https://jasonwoof.com/gitweb/?a=blobdiff_plain;f=metaform%2Ftemplate.php;h=e233f36817e2ef7bbc12b40f283f309f89c43b11;hb=83b8f0d0aa999a5074e885e9e7ecd072df6ca56c;hp=4db9dad8df3b14cdb7609d659f6cc1f508136f06;hpb=96eb63cbbc2873d0f64979422a323e174a7d5f12;p=wfpl.git

diff --git a/metaform/template.php b/metaform/template.php
index 4db9dad..e233f36 100644
--- a/metaform/template.php
+++ b/metaform/template.php
@@ -117,6 +117,10 @@ function ~file_name~_main() {~opt_pass {~
 		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();
 	}
@@ -142,21 +146,37 @@ function ~file_name~_main_delete($id) {
 	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('id', $id);
-		tem_set('editing');
-		tem_set('edit_msg');
-	} else {
-		tem_set('new_msg');
 	}
 ~}~
 	if(isset($_POST['~always_field~'])) {
@@ -174,10 +194,10 @@ function ~file_name~_main_form($id = false) {~pulldowns {~
 				$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';
@@ -205,10 +225,10 @@ function ~file_name~_main_form($id = false) {~pulldowns {~
 				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);~}~
@@ -218,7 +238,7 @@ function ~file_name~_main_form($id = false) {~pulldowns {~
 		$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('$head');~}~