source: branches/htmlform/cgi-bin/newcity.cgi @ 459

Last change on this file since 459 was 459, checked in by Kris Deugau, 11 years ago

/branches/htmlform

Convert "new city" miniscript and page to template, move the "reload
parent" JavaScript? fragment into widgets.js. See #3.
Update calls from assign.tmpl and admin.cgi to point to newcity.cgi.

  • Property svn:executable set to *
  • Property svn:keywords set to Date Rev Author
File size: 1.9 KB
RevLine 
[139]1#!/usr/bin/perl
2# ipdb/cgi-bin/newcity.cgi
3# Add new city to database
4###
5# SVN revision info
6# $Date: 2010-08-04 20:08:41 +0000 (Wed, 04 Aug 2010) $
7# SVN revision $Rev: 459 $
8# Last update by $Author: kdeugau $
9###
[417]10# Copyright (C) 2004-2010 - Kris Deugau
[139]11
12use strict;
13use warnings;
14#use CGI::Carp qw(fatalsToBrowser);
[447]15use CGI::Simple;
[459]16use HTML::Template;
[139]17use DBI;
[459]18#use CommonWeb qw(:ALL);
[139]19#use POSIX qw(ceil);
20use NetAddr::IP;
21
22use Sys::Syslog;
23
[417]24# don't remove!  required for GNU/FHS-ish install from tarball
25##uselib##
26
27use MyIPDB;
28
[431]29openlog "IPDB","pid","$IPDB::syslog_facility";
[139]30
31# Collect the username from HTTP auth.  If undefined, we're in a test environment.
32my $authuser;
33if (!defined($ENV{'REMOTE_USER'})) {
34  $authuser = '__temptest';
35} else {
36  $authuser = $ENV{'REMOTE_USER'};
37}
38
[447]39# Set up the CGI object...
40my $q = new CGI::Simple;
41# ... and get query-string params as well as POST params if necessary
42$q->parse_query_string;
[139]43
[447]44# Convenience;  saves changing all references to %webvar
45##fixme:  tweak for handling <select multiple='y' size=3> (list with multiple selection)
46my %webvar = $q->Vars;
47
[142]48my ($dbh,$errstr) = connectDB_My;
[139]49my $sth;
50
[459]51$ENV{HTML_TEMPLATE_ROOT} = '../templates';
[139]52
[459]53my $page = HTML::Template->new(filename => "newcity.tmpl");
[139]54
[459]55if ($webvar{city}) {
56  if ($webvar{pop} eq 'on') {
57    $sth = $dbh->prepare("insert into cities (city,routing) values (?,'y')");
58  } else {
59    $sth = $dbh->prepare("insert into cities (city,routing) values (?,'n')");
60  }
61##fixme:  don't allow duplicate cities
62  $sth->execute($webvar{city});
63  $page->param(city => $webvar{city});
64  if ($sth->err) {
65    $page->param(err => $sth->errstr);
66    my $msg = "$authuser could not add city '$webvar{city}' to database: ".$sth->errstr;
67    mailNotify($dbh, 'f:nci', "IPDB city add failure", $msg);
68    syslog "err", $msg;
69  } else {
70    syslog "notice", "$authuser added city/location '$webvar{pop}'".
[139]71        (($webvar{pop} eq 'on') ? ' as POP location' : '');
[459]72  }
[139]73}
74
[459]75print "Content-type: text/html\n\n";
76
77print $page->output;
78
[139]79finish($dbh);
[459]80
Note: See TracBrowser for help on using the repository browser.