User:Ryan52/old todo

o hai

Because I don't like trac. I probably don't like any project management program for that matter. Using this because I loose TODO files on my system too easily. :p

features wanted

list of features wanted, most from a discussion with kc8pxy (some will be taken care of by him/his coders), others need my help.

• settings page (admin password, everything in the defaults table, metadata too..)
• 01:17 <kc8pxy> volunteer certification trancking
  • 01:17 <Ryan52> aka contact_types? :)
  • 01:18 <kc8pxy> btu i don't want unilateral designation.
  • 01:18 <kc8pxy> i want to have 2 or 3 people to "vote" them competent.

todo list - a bunch of crap that nobody cares about

i'm working on

• vhost based routes for separating fgdb and library, and having a setup page. I'm working on this at a glaciers pace, but I'm still working on it. (integrated with settings page, sort of)
• library
• reports over time

for next sprint

• "search sales and donations by cashier"
• 14:26 < WormRunner> Ryan52: printme report 7883 does not show the hard drive size. Debian Lenny on G4
• disable certain gizmo_types
• add the report RiFraS requested
• covered condition for gizmo reports
• deadbeat discounts weren't setting occured_at -- fixed, but need to clean up data again...
• update the documentation (meh, not *that* important)
• add notes via gui (I think I can get this one in)
  • also link to the systems summary page thing
• contract choosing in spec_sheets form doens't use the label field

for next release

• covered condition (extra)
  • so we can see either. we don't need side by side numbers at this point, but who knows???
• updated_at always being set?
  • on the disbursements table, at least, it is always set to something...investigate!
• speed up the regex in the vhosting stuff wrt printme, so that it caches results.
• coveredness without contracts is broken -- no big deal
• figure out a more convenient way of upgrading to a new sprint
• "power user" multiple systems per line item
• switch to rspec
  • and get tests that work
• gizmo_types changes (#581)
  • wait for the others
  • wait for richard
• finish library stuff
  • Lookup books from library of congress or similar
  • Check out books to people
  • Track checkout history
  • Print labels
  • Inventory list (so we can check to see what's missing, etc.)
  • Looking up all overdue books
  • (this may not be a complete list)
• security fixing
  • CSRF (use rails' protect_from_forgery and verify methods)
    • Look at this: [1] looks really kewl!
  • check for SQL injection, we won't have to worry about this in most places since we use active record, but the reports where we use SQL directly should be checked.
  • Rails Security Guide

things left for git

• gitweb on devo (currently have it on my vps...)
• trac (or switch to ticgit)
• cruise control (useless since all of the tests are broken)
• rewrite the commit email script -- it sucks (I can live with it now)
• figure out somewhere for the devel data to live that is faster than the horrible freegeek dsl (maybe on my home server?) (I don't care -- sneakernet ftw!)
• ticgit

should do soonish

• make it work with rails 2.2.2
• interface for adding contracts
• a way to disable contracts

for a rainy day

• look closer at the XSS stuff (safe erb) -- I got a lot of em
  • the on_display stuff for contact searches is an XSS bug, sort of. regardless, it should be cleaned up.
• remove cruft from that ajax helper thing
• get rid of duplicated data in code
  • conditions stuff is all over the place
  • permissions for various controllers are split between the sidebar and the controller itself
• fgss generic regexps
  • 18:44 < aSmig> this should match everything but 31: ([0]{5,}|123456789|^.{1,4}$|^[^0-9]*$)
    • false positives still exist ... figure it out
• move the vendor/plugins to their own submodules...maybe I shoulda done this first, since it's gonna get even more messy with the git bug...anyway, too late for that, whatever. I'll work it out :)
  • update them

SQL

#581

-- TVs should be a type of monitor:
    UPDATE gizmo_types SET gizmo_category_id = 2 WHERE id = 44;

-- printers and miscellaneous should have low ranks:
    UPDATE gizmo_types SET rank = 99 WHERE gizmo_category_id IN (3,4);

-- set ranks:
-- TVs:
    UPDATE gizmo_types SET rank = 1 WHERE id IN (44);

-- CRTs, monitors:
    UPDATE gizmo_types SET rank = 2 WHERE id IN (49,1,21,3);

-- integrated system/CRTs:
    UPDATE gizmo_types SET rank = 3 WHERE id IN (5,50);

-- Macs:
    UPDATE gizmo_types SET rank = 4 WHERE id IN (39);

-- LCDs:
    UPDATE gizmo_types SET rank = 5 WHERE id IN (39);

-- Laptops:
    UPDATE gizmo_types SET rank = 6 WHERE id IN (18,6);

-- Systems:
    UPDATE gizmo_types SET rank = 7 WHERE id IN (47,4);

-- covered items all have reasonable ranks, uncovered items are set to 99
    UPDATE gizmo_types SET covered = true WHERE rank < 99; UPDATE gizmo_types SET covered = false WHERE rank = 99;

what I did today

Moved to ChangeLog