X-Git-Url: https://jasonwoof.com/gitweb/?a=blobdiff_plain;f=metaform%2Ftemplate.php;h=7a09ae2ddb5132884c02efe9f8406794ca990880;hb=15459c86d0996ab3037b1738a8be6efd378c1258;hp=5ebf77c205bd81a17d4fa95ba4b80638fb473099;hpb=59c2d4dd864a724f0940405fed4d61bb8aa1864c;p=wfpl.git diff --git a/metaform/template.php b/metaform/template.php index 5ebf77c..7a09ae2 100644 --- a/metaform/template.php +++ b/metaform/template.php @@ -1,139 +1,255 @@ +$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 +# +# 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 # location of this script. IT MUST END WITH A SLASH $GLOBALS['upload_directory'] = 'uploads/'; - -# To save results to a database, you'll need to create the ~form_name~ table -# (the file ~form_name~.sql should help with this), and create a file called -# 'db_connect.php' which calls db_connect() see: -# code/wfpl/examples/db_connect.php - -if(!file_exists('code/wfpl/template.php')) { die('This form requires wfpl.'); } -require_once('code/wfpl/template.php'); -require_once('code/wfpl/format.php'); -require_once('code/wfpl/messages.php'); -require_once('code/wfpl/email.php'); -require_once('code/wfpl/db.php'); -require_once('code/wfpl/upload.php'); - -function ~form_name~_get_fields() { - $fields = array(); - - $~name~ = format_~format~($_REQUEST['~name~']); - $~name~ = save_uploaded_image('~name~', $GLOBALS['upload_directory']); - - tem_set('~name~', $~name~); - - return array(~php_fields~); -} +~}~~file_settings {~ +$GLOBALS['~name~_file_name'] = uniqid() . getmypid() . '.txt'; # comment this out to use uploader's filename +~}~~image_settings {~ +$GLOBALS['~name~_max_width'] = '400'; +$GLOBALS['~name~_max_height'] = '400';~thumb_settings {~ +$GLOBALS['~name~_thumb_max_width'] = '70'; +$GLOBALS['~name~_thumb_max_height'] = '70'; +$GLOBALS['~name~_file_name'] = uniqid() . getmypid() . '.jpg'; # comment this out to use uploader's filename +~}~~}~ + +require_once(__DIR__.'/'.'inc/wfpl/format.php');~opt_email {~ +require_once(__DIR__.'/'.'inc/wfpl/email.php');~}~~uploads_include {~ +require_once(__DIR__.'/'.'inc/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 {~ + $data['~name~'] = format_~format~(_REQUEST_cut('~name~')~pulldown_format_extra {~, '~name~'~}~);~}~~image_upload {~ + + if ($_FILES['~name~'] && $_FILES['~name~']['error'] == 0) { + $data['~name~'] = convert_uploaded_image('~name~', $GLOBALS['upload_directory'] . $GLOBALS['~name~_file_name'], $GLOBALS['~name~_max_width'], $GLOBALS['~name~_max_height']~thumb_upload_params {~, $GLOBALS['~name~_thumb_max_width'], $GLOBALS['~name~_thumb_max_height']~}~); + } else { + if (_REQUEST_cut('delete_~name~') == 'Yes') { + $data['~name~'] = ''; + } else { + $data['~name~'] = format_image_w_h~thumb_w_h {~_thumb_w_h~}~(_REQUEST_cut('old_~name~')); + } + } + unset($_FILES['~name~']);~}~~file_upload {~ -function ~form_name~() { - $edit_id = format_int($_REQUEST['~form_name~_edit_id']); - unset($_REQUEST['~form_name~_edit_id']); - if($edit_id) { - # add hidden field for database id of row we're editing - tem_set('~form_name~_edit_id', $edit_id); - tem_sub('editing'); - tem_sub('edit_msg'); + $~name~_filename_tmp = $GLOBALS['~name~_file_name']; + if (!$~name~_filename_tmp) { + $~name~_filename_tmp = format_filename(_REQUEST_cut('~name~')); } + if ($_FILES['~name~'] && $_FILES['~name~']['error'] == 0) { + $data['~name~'] = save_uploaded_file('~name~', $GLOBALS['upload_directory'] . $~name~_filename_tmp); + } else { + if (_REQUEST_cut('delete_~name~') == 'Yes') { + $data['~name~'] = ''; + } else { + $data['~name~'] = format_path(_REQUEST_cut('old_~name~')); + } + } + unset($_FILES['~name~']);~}~ + + return $data; +}~opt_public_something {~ - $delete_id = format_int($_REQUEST['~form_name~_delete_id']); - unset($_REQUEST['~form_name~_delete_id']); - if($delete_id) { - db_delete('~form_name~', 'where id=%i', $delete_id); - message('Entry deleted.'); - # FIXME: what to do after delete? - return; +function ~public_file_name~_main() {~opt_public_display {~ + $id = _REQUEST_cut('id'); + if ($id) { + return ~file_name~_main_display($id);~opt_public_form unset {~ + } else { + message("Error: Broken Link (~singular cap~ #$id not found)"); + return './'; # FIXME where should this go?~}~ + }~}~~opt_public_form {~ + return ~file_name~_main_form();~}~ +}~}~ + + +function ~file_name~_main() {~opt_pass {~ + if (logged_in_as_admin()) { + tem_set('admin_privs'); + } else { + $_REQUEST['url'] = this_url(); + return 'admin_login'; + } +~}~~opt_db {~ + $id = _REQUEST_cut('edit_id'); + if ($id) { + return ~file_name~_main_form($id); } - if(!$edit_id && !$delet_id) { - tem_sub('new_msg'); + $id = _REQUEST_cut('~file_name~_delete_id'); + if ($id) { + return ~file_name~_main_delete($id); } - if(isset($_REQUEST['~always_field~'])) { - list(~php_fields~) = ~form_name~_get_fields(); + if (_REQUEST_cut('new')) { + return ~file_name~_main_form(); + } +~}~~opt_listing {~ + if (_REQUEST_cut('list')) { + return ~file_name~_main_listing(); + } +~}~~opt_display {~ + $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("you're happy with the POSTed values") { - # to enable saving to a database, create a file called 'db_connect.php' - # see: code/wfpl/examples/db_connect.php - if(file_exists('db_connect.php') || file_exists('code/db_connect.php')) { - if(file_exists('db_connect.php') { - require_once('db_connect.php'); - } else { - require_once('code/db_connect.php'); - } - if($edit_id) { - # uploading nothing means leaving it as is. - if(!$~name~ && $delete_~name~ != 'Yes') { - $~name~ = db_get_value('~form_name~', '~name~', 'where id=%i', $edit_id); - } - - db_update('~form_name~', '~db_fields~', ~php_fields~, 'where id=%i', $edit_id); - message('Entry updated.'); - } else { - db_insert('~form_name~', '~db_fields~', ~php_fields~); - message('Entry saved.'); - } - } - if($GLOBALS['~form_name~_form_recipient'] != "fixme@example.com") { - $to = $GLOBALS['~form_name~_form_recipient']; - if(isset($_REQUEST['email']) and valid_email($_REQUEST['email'])) { - $from = $_REQUEST['email']; - if($_REQUEST['name'] and ereg('^[a-zA-Z0-9_\' -]*$', $_REQUEST['name']) !== false) { - $from = "$_REQUEST[name] <$from>"; + if (isset($_POST['~always_field~'])) { + return ~file_name~_main_form(); + } + + # default action: + return ~file_name~_main_listing();~}~~opt_listing unset {~ + return ~file_name~_main_form();~}~ +}~opt_display {~ + +function ~file_name~_main_display($id) { + $data = db_get_assoc('~table_name~', 'id,'.~file_name upper~_DB_FIELDS, 'where id=%i', $id); + if (!$data) { + message("Error: Broken Link (~singular cap~ #$id not found)");~opt_public_something {~ + return './' . $GLOBALS['wfpl_basename'];~}~~opt_public_something unset {~ + return './~file_name~';~}~ + } + tem_set('display', $data); +}~}~~opt_db {~ + +function ~file_name~_main_delete($id) { + db_delete('~table_name~', 'where id=%i', $id); + message('~singular cap~ deleted.'); + return './~file_name~'; +}~}~~opt_listing {~ + +function ~file_name~_csv_download() { + require_once(__DIR__.'/'.'inc/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() { + $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) { + tem_set('id', $id); + } +~}~ + if (isset($_POST['~always_field~'])) { + $data = ~file_name~_get_fields(); + + if ("you're happy with the POSTed values") {~opt_db {~ + if ($id) { + db_update_assoc('~table_name~', $data, 'where id=%i', $id); + message('~singular cap~ updated.'); + } else { + db_insert_assoc('~table_name~', $data); + message('~singular cap~ saved.'); + }~}~~opt_email {~ + if ($GLOBALS['~file_name~_form_recipient'] != 'fixme@example.com') { + $to = $GLOBALS['~file_name~_form_recipient']; + $from = 'noreply@~this_domain~'; + $reply_to = $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>"; } - } else { - $from = $to; } - $subject = '~form_name~ form submitted'; - $message = tem_run('~form_name~.email.txt'); + $subject = '~plural cap~ form submitted'; + $email_template = new tem(); + $email_template->load('~public_file_name~.email.txt'); + $email_template->sets($data); + $message = $email_template->run(); $cc = ''; $bcc = ''; - if(email($from, $to, $subject, $message, $cc, $bcc)) { - tem_set('error_message', 'Due to an internal error, your message could not be sent. Please try again later.'); - tem_sub('error'); + if (email($from, $to, $subject, $message, $reply_to, $cc, $bcc)) { + message('Due to an internal error, your message could not be sent. Please try again later.'); $error = true; + } else { + message('Message sent'); } - } - if($error !== true) { - tem_load('~form_name~.html'); - tem_sub('thankyou'); - tem_output(); - exit(); + }~}~ + if ($error !== true) {~opt_public_something {~ + if ($GLOBALS['wfpl_basename'] == '~file_name~') { + return './~file_name~'; + } else { + # FIXME create this page or change this to go elsewhere + return './~public_file_name~_thanks'; + }~}~~opt_public_something unset {~~opt_db unset {~ + # FIXME create this page or change this to go elsewhere~}~ + return './~file_name~~opt_db unset {~_thanks~}~';~}~ } } - # otherwise, we display the form again. ~form_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. - } elseif($edit_id) { + # 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 - list(~php_fields~) = db_get_row('~form_name~', '~db_fields~', 'where id=%i', $edit_id); - ~tem_sets.tab~ + $data = db_get_assoc('~table_name~', ~file_name upper~_DB_FIELDS, 'where id=%i', $id);~}~ } else { # form not submitted, you can set default values like so: - #tem_set('~always_field~', 'Yes'); - } + #$data = array('~always_field~' => 'Yes'); + $data = array(); + }~upload_max {~ - tem_set('upload_max_filesize', upload_max_filesize()); + tem_set('$upload_max_filesize', upload_max_filesize());~}~ - tem_sub('form'); + tem_set('form', $data);~show_extra_headers {~ + tem_set('$head');~}~ } - -?>