#! /usr/bin/python

import types
from base import NetMapObject

class Owner( NetMapObject ):
    def __init__( self ):
        NetMapObject.__init__( self )
        self.attribute_map = {
            'first_name'     :'^\w*$',
            'last_name'      :'^\w*$',
            'email'          :'^[\w-]*\@[\w.-]+',
            'pager'          :'^([\w-]*\@[\w.-]+|[\d-]*)$',
            'phone'          :'^[\d-]*$',
            'wireless_phone' :'^[\d-]*$'
            }

    def commit( self ):
        print '''INSERT INTO owners (first_name, last_name, email, pager, phone, wireless_phone)
                 VALUES (?,?,?,?,?,?)'''


def search( email ):
    print '''SELECT * FROM owners WHERE email = ? '''


def print_table( owners ):
    print '''<form action=network-map.cgi>
<table class="map-table">
  <tr class="table-head">
    <td><a name="owners"></a>Owners</td>
  </tr>
  <tr class="table-buttons">
    <td colspan=5><input type=submit name="action" value="Add Owner"></td>
  </tr>
  <tr class="table-label">
    <td>Name</td>
    <td>Email</td>
    <td>Pager</td>
    <td>Phone</td>
    <td>Wireless Phone</td>
  </tr>'''
    print_rows( owners )
    print '</table>'
    print '</form>'


def print_rows( owners ):
    if type(owners) == types.ListType:
        for owner in owners:
            print_row( owner )
    else:
        print_row( owners )


def print_row( owner ):
    print '  <tr class="table-item">'
    print '    <td><a href="network-map.cgi&action=Show+Owner&owner=%s">%s %s</a></td>' % ( owner['email'], owner['first_name'], owner['last_name'] )
    print '    <td><a id="owner-%s"></a>%s</td>' % ( owner['email'], owner['email'] )
    print '    <td>%s</td>' % owner['pager']
    print '    <td>%s</td>' % owner['phone']
    print '    <td>%s</td>' % owner['wireless_phone']
    print '  </tr>'