metaform: enter captions and optionally field names

[wfpl.git] / metaform / template.php

diff --git a/metaform/template.php b/metaform/template.php
index fa05c07..49e6b74 100644 (file)
--- a/metaform/template.php
+++ b/metaform/template.php
@@ -13,13 +13,10 @@
 # To send results by e-mail, all you have to do is set your e-mail address here:
 $GLOBALS['~file_name~_form_recipient'] = 'fixme@example.com';
 ~}~~opt_db {~
-# To save results to a database, you'll need to create the ~table_name~ table
-# (the file ~file_name~.sql should help with this), and create the file
-# 'code/db_connect.php' which calls db_connect() see:
-# code/wfpl/examples/db_connect.php
+# To save results to a database, you'll need to create the ~table_name~ table.
+# The file ~file_name~.sql should help with this
 #
 # if you rename any of the database fields, you'll need to update this:
-
 define('~file_name upper~_DB_FIELDS', '~db_fields~');
 ~}~~upload_settings {~
 # Set this to the path to your uploads directory. It can be relative to the
@@ -39,6 +36,10 @@ require_once('code/wfpl/format.php');
 require_once('code/wfpl/email.php');~uploads_include {~
 require_once('code/wfpl/upload.php');~}~
 
+$GLOBALS['~file_name~_field_to_caption'] = array(~name_to_caption {~
+       '~name~' => '~caption phpsq~'~ sep {~,~}~~}~
+);
+
 function ~file_name~_get_fields() {
        $data = array();
 ~formats {~
@@ -117,6 +118,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,9 +147,39 @@ 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');
+       $fields = explode(',', 'id,'.~file_name upper~_DB_FIELDS);
+       $header = array();
+       foreach ($fields as $field) {
+               if (isset($GLOBALS['~file_name~_field_to_caption'][$field])) {
+                       $header[] = $GLOBALS['~file_name~_field_to_caption'][$field];
+               } else {
+                       $header[] = $field;
+               }
+       }
+       array_unshift($rows, $header);
+       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 1000');
-       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 {~