Exemplo n.º 1
0
 def index(self):
     """
     Simply returns the more-or-less static index.mako template.
     The actual data loading etc. is done in Javascript once the page has
     loaded (see getitems() further down).
     """
     print "index() called"
     c.pagetitle = "DOB/DOA Tracker"
     c.itemcount = self.item_q.count()
     return render('/index.mako')
Exemplo n.º 2
0
    def logout(self):
        """
        Logout the user and display a confirmation message
        """
        if 'user' in session:
            del session['user']
            session.save()

        c.pagetitle = "Please Log In"
        return render('login.mako')
Exemplo n.º 3
0
    def submit(self):
        """
        Verify username and password
        """

        # Both fields filled?
        form_username = str(request.params.get('username')).lower()
        form_password = str(request.params.get('password'))

        # Get user data from database
        #db_user = model.WebUser.query(User).get_by(name=form_username)
        #if db_user is None: # User does not exist
        valid_users = {
                "admin": "luminous",
                "hsbc": "rainwater",
                "tesco": "lightning",
                "hbos": "autumn",
                "specsavers": "blossom",
                "lloyds": "orchard",
                "boots": "cluster1"
                }

        try:
            valid_users[form_username]
        except KeyError:
            c.pagetitle = "Incorrect Username"
            return render('login.mako')

        # Wrong password? (MD5 hashes used here)
        #if db_user.passwd != md5.md5(form_password).hexdigest():
        if form_password != valid_users[form_username]:
            c.pagetitle = "Incorrect Password"
            return render('login.mako')

        # Mark user as logged in
        session['user'] = form_username
        session.save()

        # Send user back to the page he originally wanted to get to
        if session.get('path_before_login'):
            return redirect(session['path_before_login'])
        else: # if previous target is unknown, send the user to a welcome page
            return redirect("/")
Exemplo n.º 4
0
 def rtsform(self, id):
     import datetime
     c.item = self.item_q.filter_by(rep=id).first()
     repstring = "REP{0:0=7}".format(c.item.rep)
     c.printrep = repstring[0:6] + " " + repstring[6:10]
     c.pagetitle = "RTS form for # %s" % c.item.rep
     now = datetime.datetime.now()
     if not c.item.rtsdate:
         c.item.rtsdate = "%s/%s/%s" % (now.day, now.month, now.year)
     Session.commit()
     return render("/rtsform.mako")
Exemplo n.º 5
0
    def upload(self):
        """
        Really nasty CSV importer that does minimal error checking and
        expects everything to be laid out in a particular manner.
        """
        import csv
        csvfile = request.POST['csvfile']
        csvreader = csv.reader(csvfile.file, delimiter="\t", quotechar='"')

        rowsadded = 0
        repsadded = []
        c.duplicatereps = []
        c.unknowncustomers = []

        for row in csvreader:
            rep = row[3][3:][:7]
            if rep == '':
                rep = rowsadded

            # Skip over duplicate REP numbers
            if rep not in repsadded:
                newitem = Item(rep=int(rep),
                               kind=row[0].decode('utf-8', 'ignore')[:3],
                               initials=row[1].decode('utf-8', 'ignore')[:3],
                               customer=row[4].decode('utf-8', 'ignore')[:30],
                               costcentre=row[6].decode('utf-8', 'ignore')[:20],
                               ordernum=row[7].decode('utf-8', 'ignore')[:20],
                               make=row[8].decode('utf-8', 'ignore')[:30],
                               model=row[9].decode('utf-8', 'ignore')[:50],
                               part=row[10].decode('utf-8', 'ignore')[:30],
                               serial=row[11].decode('utf-8', 'ignore')[:30],
                               asset=row[12].decode('utf-8', 'ignore')[:30],
                               issue=row[14].decode('utf-8', 'ignore')[:300],
                               state=row[15].decode('utf-8', 'ignore')[:300],
                               location=row[16].decode('utf-8', 'ignore')[:300],
                               solution=row[17].decode('utf-8', 'ignore')[:300],
                               sap=row[18].decode('utf-8', 'ignore')[:8],
                               grn=row[19].decode('utf-8', 'ignore')[:8])

                # Sometimes Excel doesn't include the last column (or the CSV
                # reader doesn't read it properly).
                if len(row) >= 21:
                    # Sometimes the Folio column has non-numbers in it
                    try:
                        newitem.folio = int(row[21])
                    except ValueError:
                        newitem.folio = 0

                # Ditto for Value column, particularly items added long ago
                # by a certain "JH".
                try:
                    f = float(row[5])
                except ValueError:
                    f = 0.0

                # Store values as integers
                r = round(f, 2)
                newitem.value = int(r*100)

                newitem.datein = parsedate(row[2].decode('utf-8', 'ignore')[:20])
                newitem.warranty = parsedate(row[13].decode('utf-8', 'ignore')[:20])
                newitem.rtsdate = parsedate(row[20].decode('utf-8', 'ignore')[:20])

                # Return
                custs = ["TESCO", "HSBC", "SPECSAVERS", "HBOS", "RBSG"]
                def detectcust(cust):
                    for acust in custs:
                        if cust[:len(acust)] == acust:
                            return acust
                    if cust != "UNKNOWN":
                        c.unknowncustomers.append({"rep": newitem.rep,
                                                   "customer": cust})
                    return "UNKNOWN"

                newcust = detectcust(newitem.customer)

                # If there's a "/" in the customer name, assume it's owned
                # by Fujitsu if the character after the "/" is an "F"
                slash = newitem.customer.find("/")
                if slash != -1:
                    if newitem.customer[slash + 1] == "F":
                        newitem.fujitsuowned = True
                    else:
                        newitem.fujitsuowned = False

                newitem.customer = newcust

                Session.add(newitem)
                rowsadded = rowsadded + 1
                repsadded += [rep]
            else:
                c.duplicatereps += [rep]
                print "[dobtrack] Ignoring duplicate rep of %s" % rep

        Session.commit()
        print "[dobtrack] Unrecognised 'customer' entries:"
        print c.unknowncustomers

        c.rowsadded = rowsadded
        c.pagetitle = "CSV file uploaded successfully"
        return render('/upload.mako')
Exemplo n.º 6
0
 def importcsv(self):
     c.pagetitle = "Import data from CSV file"
     return render('/importcsv.mako')
Exemplo n.º 7
0
 def tableprint(self):
     c.pagetitle = "DOB/DOA Tracker"
     return render("/tableprint.mako")
Exemplo n.º 8
0
 def login(self):
     """
     Show login form.
     """
     c.pagetitle = "Please Log In"
     return render("login.mako")