source: trunk/cgi-bin/newnode.cgi@ 748

Last change on this file since 748 was 517, checked in by Kris Deugau, 12 years ago

/trunk

Finally merge conversion to HTML::Template from /branches/htmlform

  • Node "hack" showed conflict due to having been added to all branches in parallel
  • editDisplay.html was apparently changed enough that the merged delete caused an irrelevant conflict

Closes #3.

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