From 9f922ba5ae0ac34d4aa2d2fcbca77d80d1618c11 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 12 Oct 1998 07:19:11 +0000 Subject: Initial revision --- TODO | 530 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 530 insertions(+) create mode 100644 TODO (limited to 'TODO') diff --git a/TODO b/TODO new file mode 100644 index 000000000..0171c3230 --- /dev/null +++ b/TODO @@ -0,0 +1,530 @@ +If you are interested in helping with any of these, please join the mailing +list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid +duplication of effort. + +-- 1.1.x -- + +postgres can't deal with NULL! + +svc_acct.import should recognize "UNIX" in the RADIUS password file as null. + +radius logfile parsing and perl expression check. + +mailing list archive, faq, cvs + +(test cust_main.pm with cybercash v2 and v3) + +Fix in cust_bill BUGS: +There is an off-by-one error in print_text which causes a visual error (Page 1 +of 2 printed on some single-page invoices). + +FIX It doesn't properly inherit/override FS::Record yet, so no more replace vs +rep silliness! + +fields should be a method against a FS::Record or derived object, as well as +being something you can call as FS::Record::fields('tablename'). Might +even be able to handle both in the same routine (that would be neato). +Get rid of hfields and other assorted silliness. +Clean up hfields/sfields/fields crap. yuck. + +$lpr in cust_main.pm (from Bill.pm) should become /var/spool/freeside/conf/lpr + +Override FS::Record new, add, rep and del (create, insert, replace and +delete) in all derived classes. +IE create, insert, delete and replace from derived classes should override new, +add, del and rep (respectively) from FS::Record. Depriciate old names. + +Allow a cancelled/suspended/active status from packages to bubble up to +the customer lists. Put active, then suspended, then cancelled accounts. +Similar ordering on the package listing inside a single customer. + +Add the ability for services to filter information up to the package level +for invoices and web screens, so you can select a particlar package based +on username or domain name, etc. + +You can't delete the stuff under administration yet. Add this, +_including_ making sure the thing you are deleting is not in use! + +Immediate removal of incorrectly entered check payments (can't take too +long to do this, or accounting is fubared). + +Add code to move from one service to another (POP to SLIP/PPP, etc.). +This _should_ be possible by working off the rules in part_svc rather than +hardcoding anything in. The rules in part_svc may need some elaboration, +perhaps. + +Use ut_ FS::Record methods in all derived classes (possibly some from dbdef?... eventually all from dbdef??? - but then `dbdef-create' would be impossible as there would be metadata we couldn't ask the backend for. hmm.) + +(bring back from fsold, ) Generalize config-sending stuff and make more configurable. +Expand the HylaFAX interface (also possibly generalize for other fax +softwar ie .comfaxe); allow things like arbitrary faxes of sales +literature, specific troubleshooting documents and so on. Maybe even +allow users to do this (though that might not belong in Freeside). +misc/sendconfig.cgi +misc/process/sendconfig.cgi +Configure fax recipients via a separate box rather than using the finger +name or first+last from cust_main. + +move all phone number logic out of Freeside - let HylaFAX or whatever +handle it. + +soundex searches for customer name and company? where are free soundex tools? (standard Text::Soundex duh) + +should be able to link on (username, domain name, some field in email alias) instead of svcnum only. (username done, what else?) + +(done but clean up) change svc_domain.pm mail sending from a pipe to "/usr/lib/sendmail" to Mail::Mailer or Net::SMTP or something. also is the complete text of the registration agreement needed in there (it used to be)? + +generalize and make configurable new invoice printing scheme in FS::Bill::collect (past due) + +deleting an svc_domain should delete all associated svc_acct_sm records. +same with a svc_acct. + +periodic password encrypter + +Automated, configurable notification, suspension and cancellation of +defunct accounts. +... +expire cron job +... +Allow for a future setup date on accounts. + +one-time/per-customer/? changes in rates and descriptions ('remembered +invoices'): implement by creating a new package on the fly... but it isn't +associated with any agent types so it won't show up for other customers to buy. + +if CGI::Base will not have redirect fixed (cgifix.html), should migrate to +CGI.pm insetead? It is >1 year newer. + +library repetitve stuff from Bill.pm Invoice.pm and friends (calculating +previous balances etc etc) + + +sub AUTOLOAD in FS::Record should warn? die? if used with a non-existant column +name? + +edit (not just import, export and allow default/fixed) arbitrary radius stuff +in svc_acct + +edit/svc_acct.cgi and edit/process/svc_acct.cgi should deal with arbitrary radius stuff + +radius import should take DEFAULT entry and put it in /var/spool/freeside/conf/radius-default ; svc_acct.export should use it (and doc) + +FS::Invoice and FS::Bill should merge with the classes they're derived from + +in UI, s/State/State\/Provence/go and s/County/County\/Locality/go + +.us domains and others! + +what else (besides l10n) for i18n? + +audit htdocs/* for things that should be libraried and things that should be +new methods on the objects (need to do this before implementing a new UI) +all the big things are done + +some places we die() where we should &FS::CGI::idiot (and perhaps vice-versa). +Decide based on whether or not the "error" should show up in logs. + +all .cgi's should use standard header/footer and idiot() subroutines. maybe HTML:: perl modules +for HTML creation. CGI.pm instead. + +library the conf reading stuff; bin/svc_acct.export version with missing-filename checking is good +library conf stuff -> check all the conf stuff to make sure they close filehandles. + +When running bin/bill, Fix this (Annoying but harmless): +Use of uninitialized value at /usr/local/lib/site_perl/FS/cust_pkg.pm line 99,
chunk 4. +Use of uninitialized value at /usr/local/lib/site_perl/FS/cust_pkg.pm line 102,
chunk 4. +Use of uninitialized value at /usr/local/lib/site_perl/FS/cust_pkg.pm line 105,
chunk 4. + +all cgi (but internal to the isp) places where package names are listed should also have +comment (like agent_type) + +clean up $recref and other silliness and use -> calls where possible, or +one other alternative. clean up everything else. +should FS::Record use Tie::Hash? That would be very clean, but where do we +store the other information? Maybe you could ask any FS::Record object for a +tied hash? + +change all htdocs/edit/process/* loops to look like: (library this sort of thing!!!!) + +my($new) = create FS::svc_acct_sm ( { + map { + ($_, scalar($req->param($_))); + } qw(svcnum pkgnum svcpart domuser domuid domsvc) +} ); + +to avoid form errors causing too much silliness + +add this code to all svc_*.pm (already in acct and acct_sm and domain): (library!) + + #get part_svc + my($svcpart); + my($svcnum)=$self->getfield('svcnum'); + if ($svcnum) { + my($cust_svc)=qsearchs('cust_svc',{'svcnum'=>$svcnum}); + return "Unknown svcnum" unless $cust_svc; + $svcpart=$cust_svc->svcpart; + } else { + $svcpart=$self->getfield('svcpart'); + } + my($part_svc)=qsearchs('part_svc',{'svcpart'=>$svcpart}); + return "Unkonwn svcpart" unless $part_svc; + + #set fixed fields from part_svc + my($field); + foreach $field ( fields('svc_acct') ) { + if ( $part_svc->getfield('svc_acct__'. $field. '_flag') eq 'F' ) { + $self->setfield($field,$part_svc->getfield('svc_acct__'. $field) ); + } + } + +change all file access from regular open(FILE,) stuff to OO, because of +problems scoping and passing filehandles like that. + +svc_domain.pm mail sending uses Date::Format which doesn't seem to pick up +correct timezone. + +view/svc_domain.cgi needs to know the domain might be unaudited (cosmetic) + +Check everything into CVS. + +--- 1.1.x or 1.2 or later + +the web interface should create a new object and use it instead of a blank +form for new records. the create method of svc_ objects should set defaults +(from part_svc). + +sub check in man FS::table_name should be rewriteen. Get rid of $recref +stuff. Make sure all fields that refer to other database are checked. + +Integration with signup disks (are there any free ones? Netscape?). + +One-button cancel (+refund) for lusers who can't get online. + +Keep information on virtual web servers (hostname, IP, host machine, +directory, etc.) and export this information for importation into the ISPs +web farm. + +Remove requirement that the first mail alias be the catchall? Still make +sure only one catchall per domain is defined in any case, of course. + +Ability to move cust_pkg records from one customer to another? (proably +will need to cancel the old and create a new like when we move services +between packages). + +Auto-increment expired cards one year, and try again? + +Lay out the forms a bit better. + +More non-US stuff - zip codes, country codes, foreign currencies, etc. + +cust_refund.{cgi.pm} need to do cards xaxtions. (now we only have cust_credit) + +Nicer set of integrated reporting possibilities, like weekly sales totals +by customer, package, agent, referral, etc., aging reports sorted by lots +of different things, and so on. + +Client/server setup for users to modify their own passwords, shells, etc, +via passwd or secure web interface (prelminary passwd/chfn/chsh +replacement done). Complicated by the fact that we don't want to allow +incoming connections to the machine running Freeside, so we probably need +to have a daemon on each external shell or web machine that is contacted +by the Freeside machine. Be very very careful for both traditional +security issues and DoS problems. + +An extension of the above to allow users to modify selected parts of their +own information, order and cancel services. A web interface for new +customers. + +Expand domain name stuff to house all domain information. Export +named.boot/named.conf (primary and secondary) and named.{domain} files. +Add more registries (not just InterNIC's com org net edu) + +Nice postscript paper invoices, rather than current ASCII invoices. + + +think about race-condititions in FS::Record and derived ->check ->insert +and so on, uid and username checks in svc_acct, etc. + +Move to rsync over ssh file exportation rather than scp. + +check 'n fix the proactive password checker. (cracklib?) + +refunds of "BILL" payments: generate pseudo-check. + +write batch senders and batch parsers for the different credit card processors +people use/ +More CC processors/methods. + +In FS::Record, the counter dir should have .datasrc appended to it like the +dbdef does, which should place all the (most of) the DB metadata in unique +files and let me run concurrent .datasrc's. Maybe do something similar for +user, password and datasrc itself? (or something to get the out of the source +files) and then we're set. (secrets file also needs .datasrc appended, or maybe +"/var/spool/freeside".datasrc + +you should be able to fiddle the setup date in cust_pkg. (at least initially) + +cych v3 and v2 support + +delete options in administration section + +write a generic batch senders and batch parsers. + +need a way to override svc_acct export on a per-machine basis; just use config files based on machine name i suppose; document that. + +you should be able to get column types as a method against an FS::Record object +as well as dbdef->table($table)->column($column)->type + +move to perl module for fuzzy and soundex searching. + +make fs-setup option to add sample data so you can click on "New Customer" right away? so people understand what this stuff is? + +package view needs to list extraneous services; we need to prevent the +creation of them so this never happens (and mark it as such in the source) +(the creation problem should be fixed - though they will still happen if people +fsck around in the data manually, so list them anyway) + +add attribute dictionary to fs-setup as a menu, plus analyze users file to +decide automatically + +Check for and report on duplicate billing accounts (cust_main, though many +will have a need for these so probably don't disable them outright.) + +create a ->warn as well as a ->check method for all FS::table classes? +(see above) + +something to automate making a release and updating the web demo + +export a debian-style (also redhat and?) /etc/group file aswell! + +seems to be an off-by-one error in the ascii invoice formatting which is saying +"1 of 2" pages when there is only one. + +get rid of agrep? needs the (non-free) glimpse distribution. agrep used to +be free? what else can do fuzzy searching? + +site_perl/svc_domain.cgi (hmm... or maybe should have a button? or maybe svc_domain.pm should handle this) should set $whois_hack for non-internic domains, so you can add them... + +svc_acct_sm.import qmail import should pull in recipientmap people too. + +.pm's like svc_acct.pm which need to do time-consuming things like ssh remotely +should fork and do them in a child. + +i18n/l10n: take ALL messages and catalog them in english.txt or in database or something, so we can eventually go int'l. int'l currency support would be a help aswell. + +get some of { city, county, state, zip } from the missing bits if +possible (where can i get the data to do this? usps.gov?) + +additional interfaces (perltk? java?) + +Put the GPL notice in all files. + +-- 1.2 or later -- + +$cust_bill->owed database field to be eliminated, replaced by a method call +that calculates on the fly. make sure to grep for ->(get|set)field('owed') +same for cust_credit->credited + +Export quota information. + +move all configuration to a central place. maybe in blob's in the +database. maybe even things like the code to execute when a username is +changed can be in there, so less of the distributed scripts change between +different sites. + +Implement setup and recurring fees as Safe perl expressions rather than +numbers, to allow for variable-rate services. Backwards compatibility is +obtained because { 43 } in perl is still 43. :) Define API to pass +starting and ending dates and any other necessary data to expression +(fees are currently evaluated as Safe expressions but more work needs to +be done to define an opmask for various needs, write examples +(usage-based billing, etc.) and so on). +... +Add the ability to modify the next billing date in cust_pkg, and take +appropriate action. This will allow the implementation of pro-rate/1st of +the month billing as well as the ability to manually fiddle with +anniversary dates in cust_pkg, so you can sync a customer's anniversary +date even if you're using anniversary billing (manually or automatically). +(now with above, we need to have a way to automatically pro-rate /^(\d+)$/ +charges - anything more complicated should figure it out itself given +starting and ending dates [document that!]) +... +Daily Radius log parsing into database; other logfile formats? +... +Callbacks to enforce hourly limits on accounts (suspend until the end of +the billing period?), for those who limit customers rather than tack on +extra charges. + +Flag packages (part_pkg) as taxable or non/taxable as some ISPs (for +example) need to charge tax on equipment but not service (separate flags +for setup and recurring fee... or perhaps a setup_tax, setup_notax, +recur_tax and recur_notax fees, and possibly something more flexible if +there is need). + +Allow for a variable number of invoices for customers who need multiple +copies. + +Add a mail alias service with table svc_acct (not domain mail aliasing +which is domain with svc_acct_sm) + +(bring back from fsold) Change customer comment field from its current kludge to something more +workable. + +Better work orders with more information. Should eventually open a ticket +when we have such a thing. +edit/svc_wo.cgi +edit/process/svc_wo.cgi +Call tracking and trouble tickets. + +use mod_perl and Apache::AuthDBI instead of mod_auth_mysql when we do local +users +More accoutability for complimentary accounts: approval, expiration, term +(no more than x months in advance) and notification. +Flag particular users (or all users, for that matter) as having their +passwords hidden and/or locked from users of Freeside (maybe need Freeside +security levels first?). +... +Better Freeside-level configurable access, for those ISP's who have +employees they can't trust. Right now you're "stuck" with setting up +.htaccess stuff yourself. This should really just be integrated. + +update site_perl/table_template* (pry out of date) + +/var/spool/freeside/conf (and whatever else /var/spool/freeside we can) +in database (except secrets), then web interface, +make /var/spool/freeside a configurable directory (probably as part of +some automated installation process?) + +add a table with column of export services (passwd, shadow, master.passwd, .qmail file update, dns update, etc.) and rows machine groups and whether or not to export that (and any necessary parameters). wasn't matt (vunderkid, not matt@michweb) working on this? find him? each machine goes in a group of its own as well as a group based on function. add a table with only svcpart and machine group. now, when you import from each machine, it can get its own accounts with one svcpart and universal accounts with another svcpart. (though that does make the username duplicate checking more interesting) + +password and slipip stuff in svc_acct.pm store need to be split into two fields or something, so the silliness in svc_acct.pm and svc_acct.export with looking at the data to decide what to do with it can be fixed (1.2) + +This requires some serious magic in FS::Record: +ok, if date_type in fs-setup is to be something besides int, +now we need to create wrappers +for them so they behave identically across RDBMS's, ie date pops out as as +UNIX timestamp (or an object of some sort? maybe even a blessed $obj which +is a string not a hashref for backwards compatibility?) and so on. (remember +to treat '0' as Not a Date instead of 1/1/70. + +Add Freeside-level transactions for RDBMS's which don't support +transcations? (Currently we assume a minimal RDBMS which has no rollback, +transactions or atomic updates). Or just require a RDBMS that supports +rollback and/or atomic updates and get rid of the work-arounds? The /rdb +interface had this kludge on top of it but is a technical dead-end in most +other ways, unless it can gain an SQL parser and DBD interface. + +Better automated comparison of our CC records with processors (CyberCash, +at least, has not always had 100% accuracy, though recent versions are +much better) + +Expect or other pty based login check, where we actually connect to a +terminal server or shell machine and test logging in as the user (if we +are keeping a cleartext password for that user) (This is something tech +support often needs for new customers) + +Use cust_main table for pre-sales tracking as well? + +Automatic commision report and check generation via freq and prog (to +become a Safe perl expression) fields in agent table, and possibly others. + +Database and add a mailed-out date and method for disk/CD mailing, so a +customer can call and you can say, "sent on xx/xx/xx via {US Mail, Fedex, +UPS, etc}" + +Inventory tracking for physical items such as routers (for sale or +lease... probably doesn't make a difference in the ordering... but if you +cancel a router lease the inventory should come back. hmm.) + +-- Matt's wishlist --- + +From matt@michweb.net Fri Feb 20 16:39:53 1998 +Date: Thu, 19 Feb 1998 23:20:11 -0500 +From: Matt Simerson +Reply-To: quadran-developer@netgoth.com +To: quadran-developer@netgoth.com +Subject: Re: Welcome to quadran-developer + +>Whats it based on and what is it supposed to do? I'm interested, but +>unfortunatly, I don't have that much time to help on the project (I'm busily +>working on one of my own based around MySQL and Qt right now -- don't know +>if it will be GPL'ed or not yet -- we'll probably just use it in house since +>it is designed around our system)... + +That's what I set out to find, but didn't find anything on the web site. +I'm looking for something that will do the following: + +Single point of entry for users on a secure system: + Creates account on user (public) systems + update /etc/passwd/master.passwd file + update radius database (if necessary) + Set up up disk quotas (although I hacked adduser to do this) + Option for adding user to a mailing list(s) + Export of new user info to customizable report (for automated entry +into + accounting software, etc...) + +Automated billing: + Export credit card info for batch processing and have hooks built + in for other forms of electronic processing. + Batch-Payment (apply payments from formatted text file). + Customizable reports for manual entry/importing into Accounting +software + Email or laser print invoices + Sanity checks credit card numbers before processing (code available) + +Simple method for disabling an account. + Arbitrary Expiration Dates (on a given day, in x days) + Remove from radius. + Changing password to '*' + Virtual customers disabling dns, http server, log processing, etc.. + +Billing for different account types: + Dialup monthly flat rate. Prorates for partial months. + Dialup monthly flat rate for x hours + hourly usage. + Dialup email only + Email only accounts + Virtual Web accounts - w/multiple mailboxes + Leased line accounts + Disk space used over quota. + Tech support minimum + hourly charges + Other for misc stuff (modem, RAM, etc...) + +Per user definable RADIUS attributes (ties in with above) + Fixed IP + Simultaneous Use + IP filters (for dialup email only) + +Keep logs of modem usage generated daily from radius accounting logs stored +on multiple radius servers. + +Keep logs of disk usage generated from quota. + +Method of adding virtual domains to your system: + Automatically grabs an IP address from a preassigned pool. + Creates a domain.com database file from database fields + Updates /etc/named.conf or /etc/named.boot and reloads named. + Add's virtual.com to /etc/sendmail.cw or qmail control files. + Edits your web servers httpd.conf file and restarts http server. + An optional section for adding vif's can be added if the users OS + supports adding them on the fly. Otherwise it's up to the end + user. Make a hook that can run a custom script that the user + tweaks for his system. + Update or create the config file your web stats analyzer needs. I've + done this for analog (free) and http-analyze. Probably + should only officially support analog and let users hack + it to their hearts desire. +I've already written scripts that do most of the virtual web stuff on my +system...in bash. Shouldn't be hard for a perlmeister to convert. In fact, +as long as all the info was stored in the database (username, domain name, +and ip pool) this could easily just be run as an external script that the +user tweaks to match his system. + +We use a great accounting software (M.Y.O.B) that does all the AP, AR, +Payroll, Tax stuff, and most everything else we could need. It's already +set up for the type of checks we have, etc, etc... I just need something to +do the billing part. I can import/export sales and payments directly once +the billing part is done. You can't write accounting software as good as +M.Y.O.B. for $120. + + -- cgit v1.2.1 From 3d2b831027b88b277e1bf23f6621a98214723d06 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 12 Oct 1998 08:59:22 +0000 Subject: Commiting sample change. --- TODO | 2 ++ 1 file changed, 2 insertions(+) (limited to 'TODO') diff --git a/TODO b/TODO index 0171c3230..3b6dfa39a 100644 --- a/TODO +++ b/TODO @@ -4,6 +4,8 @@ duplication of effort. -- 1.1.x -- +figure out this cvs thing. :) + postgres can't deal with NULL! svc_acct.import should recognize "UNIX" in the RADIUS password file as null. -- cgit v1.2.1 From f9debbc3e19cf0ba48461a2d99b38b8ac6a0b845 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 12 Oct 1998 09:07:30 +0000 Subject: Test keyword substitution --- TODO | 2 ++ 1 file changed, 2 insertions(+) (limited to 'TODO') diff --git a/TODO b/TODO index 3b6dfa39a..d44b17c68 100644 --- a/TODO +++ b/TODO @@ -1,3 +1,5 @@ +$Id: TODO,v 1.3 1998-10-12 09:07:30 ivan Exp $ + If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid duplication of effort. -- cgit v1.2.1 From 005d5e42579ed3214489353fdd480177811da516 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 12 Oct 1998 09:09:00 +0000 Subject: Id to Header --- TODO | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index d44b17c68..79c903574 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.3 1998-10-12 09:07:30 ivan Exp $ +$Header: /home/cvs/cvsroot/freeside/Attic/TODO,v 1.4 1998-10-12 09:09:00 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid -- cgit v1.2.1 From 467b7543da64e11752070cbbbad387e34b46ea64 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 12 Oct 1998 09:09:32 +0000 Subject: *** empty log message *** --- TODO | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 79c903574..8aa01cfe0 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Header: /home/cvs/cvsroot/freeside/Attic/TODO,v 1.4 1998-10-12 09:09:00 ivan Exp $ +$Id: TODO,v 1.5 1998-10-12 09:09:32 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid -- cgit v1.2.1 From b5e836b011ce996df3edb3efca3e3f197dc49092 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 12 Oct 1998 09:12:29 +0000 Subject: remove adding cvs from the todo --- TODO | 8 ++------ 1 file changed, 2 insertions(+), 6 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index 8aa01cfe0..07f6b5e50 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.5 1998-10-12 09:09:32 ivan Exp $ +$Id: TODO,v 1.6 1998-10-12 09:12:29 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,15 +6,13 @@ duplication of effort. -- 1.1.x -- -figure out this cvs thing. :) - postgres can't deal with NULL! svc_acct.import should recognize "UNIX" in the RADIUS password file as null. radius logfile parsing and perl expression check. -mailing list archive, faq, cvs +mailing list archive, faq (test cust_main.pm with cybercash v2 and v3) @@ -189,8 +187,6 @@ correct timezone. view/svc_domain.cgi needs to know the domain might be unaudited (cosmetic) -Check everything into CVS. - --- 1.1.x or 1.2 or later the web interface should create a new object and use it instead of a blank -- cgit v1.2.1 From f0600c721e4f33ae9aa97453e71fba8aaa076d31 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 12 Oct 1998 21:15:28 +0000 Subject: *** empty log message *** --- TODO | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 07f6b5e50..63dae2b48 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.6 1998-10-12 09:12:29 ivan Exp $ +$Id: TODO,v 1.7 1998-10-12 21:15:28 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,8 @@ duplication of effort. -- 1.1.x -- +one-off package edits! + postgres can't deal with NULL! svc_acct.import should recognize "UNIX" in the RADIUS password file as null. -- cgit v1.2.1 From 0e0e1020a163c280eb0471532e77663cbca83e9f Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 12 Oct 1998 21:22:59 +0000 Subject: *** empty log message *** --- TODO | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index 63dae2b48..9222c821c 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.7 1998-10-12 21:15:28 ivan Exp $ +$Id: TODO,v 1.8 1998-10-12 21:22:59 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,8 +6,6 @@ duplication of effort. -- 1.1.x -- -one-off package edits! - postgres can't deal with NULL! svc_acct.import should recognize "UNIX" in the RADIUS password file as null. @@ -323,6 +321,9 @@ Put the GPL notice in all files. -- 1.2 or later -- +one-off package edits! : need a cust_pkgs or cust_part_pkgs or something table, +with custnum and partpkg (like type_pkgs) + $cust_bill->owed database field to be eliminated, replaced by a method call that calculates on the fly. make sure to grep for ->(get|set)field('owed') same for cust_credit->credited -- cgit v1.2.1 From 123a59969f1c66c9f923a480badf9634d5349996 Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 13 Oct 1998 09:17:20 +0000 Subject: *** empty log message *** --- TODO | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index 9222c821c..c82d5cb4e 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.8 1998-10-12 21:22:59 ivan Exp $ +$Id: TODO,v 1.9 1998-10-13 09:17:20 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,8 +6,6 @@ duplication of effort. -- 1.1.x -- -postgres can't deal with NULL! - svc_acct.import should recognize "UNIX" in the RADIUS password file as null. radius logfile parsing and perl expression check. -- cgit v1.2.1 From d4e9b3b0b80a25992fa7194464efa06deb484185 Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 13 Oct 1998 12:07:51 +0000 Subject: Assigns password from the shadow file for RADIUS password "UNIX" --- TODO | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index c82d5cb4e..56e78c270 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.9 1998-10-13 09:17:20 ivan Exp $ +$Id: TODO,v 1.10 1998-10-13 12:07:49 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,8 +6,6 @@ duplication of effort. -- 1.1.x -- -svc_acct.import should recognize "UNIX" in the RADIUS password file as null. - radius logfile parsing and perl expression check. mailing list archive, faq -- cgit v1.2.1 From 11586a5995866292b90c669e4aaa2e68ef202a8e Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 13 Oct 1998 12:49:50 +0000 Subject: *** empty log message *** --- TODO | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index 56e78c270..9e6f40130 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.10 1998-10-13 12:07:49 ivan Exp $ +$Id: TODO,v 1.11 1998-10-13 12:49:50 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -25,8 +25,6 @@ even be able to handle both in the same routine (that would be neato). Get rid of hfields and other assorted silliness. Clean up hfields/sfields/fields crap. yuck. -$lpr in cust_main.pm (from Bill.pm) should become /var/spool/freeside/conf/lpr - Override FS::Record new, add, rep and del (create, insert, replace and delete) in all derived classes. IE create, insert, delete and replace from derived classes should override new, -- cgit v1.2.1 From 0ac8d86e9f241bbca5c87826e56756157b7a432b Mon Sep 17 00:00:00 2001 From: ivan Date: Sat, 7 Nov 1998 08:25:10 +0000 Subject: *** empty log message *** --- TODO | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 9e6f40130..71535acc9 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.11 1998-10-13 12:49:50 ivan Exp $ +$Id: TODO,v 1.12 1998-11-07 08:25:10 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,9 @@ duplication of effort. -- 1.1.x -- +qsearch[s] (or just put in new?) in FS::Record should bless the object +into the appropriate derived class automagically, if possible? + radius logfile parsing and perl expression check. mailing list archive, faq -- cgit v1.2.1 From 0bf5ad9ff0a65195db88ed0bac3aa11c33ec1ad3 Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 13 Nov 1998 09:56:57 +0000 Subject: change configuration file layout to support multiple distinct databases (with own set of config files, export, etc.) --- TODO | 19 +++++++++---------- 1 file changed, 9 insertions(+), 10 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index 71535acc9..1d21d81ad 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.12 1998-11-07 08:25:10 ivan Exp $ +$Id: TODO,v 1.13 1998-11-13 09:56:33 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,14 +6,18 @@ duplication of effort. -- 1.1.x -- -qsearch[s] (or just put in new?) in FS::Record should bless the object -into the appropriate derived class automagically, if possible? +remove whois_hack set to 1 for svc_domain.pm? add all known registries and +whois accordingly. + +get rid of all relative URL's (have to make them on the fly) - see doc for +->redirect in CGI.pm radius logfile parsing and perl expression check. -mailing list archive, faq +faq -(test cust_main.pm with cybercash v2 and v3) +(test cust_main.pm with cybercash v2 and v3, especially with the callback + stuff) Fix in cust_bill BUGS: There is an off-by-one error in print_text which causes a visual error (Page 1 @@ -25,8 +29,6 @@ rep silliness! fields should be a method against a FS::Record or derived object, as well as being something you can call as FS::Record::fields('tablename'). Might even be able to handle both in the same routine (that would be neato). -Get rid of hfields and other assorted silliness. -Clean up hfields/sfields/fields crap. yuck. Override FS::Record new, add, rep and del (create, insert, replace and delete) in all derived classes. @@ -297,9 +299,6 @@ export a debian-style (also redhat and?) /etc/group file aswell! seems to be an off-by-one error in the ascii invoice formatting which is saying "1 of 2" pages when there is only one. -get rid of agrep? needs the (non-free) glimpse distribution. agrep used to -be free? what else can do fuzzy searching? - site_perl/svc_domain.cgi (hmm... or maybe should have a button? or maybe svc_domain.pm should handle this) should set $whois_hack for non-internic domains, so you can add them... svc_acct_sm.import qmail import should pull in recipientmap people too. -- cgit v1.2.1 From ef834d58bfd2ce38c8bea73262c8091a5d88388f Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 18 Nov 1998 09:01:44 +0000 Subject: i18n! i18n! --- TODO | 16 +++++----------- 1 file changed, 5 insertions(+), 11 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index 1d21d81ad..0e70ba453 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.13 1998-11-13 09:56:33 ivan Exp $ +$Id: TODO,v 1.14 1998-11-18 09:01:30 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,8 @@ duplication of effort. -- 1.1.x -- +test and document libapache-dbi-logger (woo!) + remove whois_hack set to 1 for svc_domain.pm? add all known registries and whois accordingly. @@ -254,22 +256,14 @@ write batch senders and batch parsers for the different credit card processors people use/ More CC processors/methods. -In FS::Record, the counter dir should have .datasrc appended to it like the -dbdef does, which should place all the (most of) the DB metadata in unique -files and let me run concurrent .datasrc's. Maybe do something similar for -user, password and datasrc itself? (or something to get the out of the source -files) and then we're set. (secrets file also needs .datasrc appended, or maybe -"/var/spool/freeside".datasrc - you should be able to fiddle the setup date in cust_pkg. (at least initially) -cych v3 and v2 support - delete options in administration section write a generic batch senders and batch parsers. -need a way to override svc_acct export on a per-machine basis; just use config files based on machine name i suppose; document that. +need a way to override svc_acct export on a per-machine basis; just use config files based on machine name i suppose; document that. (no, import desync_hosts +type stuff from cerkit) you should be able to get column types as a method against an FS::Record object as well as dbdef->table($table)->column($column)->type -- cgit v1.2.1 From 320d43cc303284435bd94b5b283471609c4a8eac Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 2 Dec 1998 01:23:48 +0000 Subject: *** empty log message *** --- TODO | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 0e70ba453..a4e4710e0 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.14 1998-11-18 09:01:30 ivan Exp $ +$Id: TODO,v 1.15 1998-12-02 01:23:47 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,11 @@ duplication of effort. -- 1.1.x -- +int'l stuff in web interface (not on david's time) + +admin web interface for titles (Dr., Mrs.) and default in fs-setup +(not on david's time) + test and document libapache-dbi-logger (woo!) remove whois_hack set to 1 for svc_domain.pm? add all known registries and -- cgit v1.2.1 From 21e5d64e7b583db49895a03ae7f485fcde3bcf88 Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 16 Dec 1998 05:38:39 +0000 Subject: *** empty log message *** --- TODO | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index a4e4710e0..24461b621 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.15 1998-12-02 01:23:47 ivan Exp $ +$Id: TODO,v 1.16 1998-12-16 05:38:39 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -316,6 +316,8 @@ Put the GPL notice in all files. -- 1.2 or later -- +integrate w/IDEA's signup server + one-off package edits! : need a cust_pkgs or cust_part_pkgs or something table, with custnum and partpkg (like type_pkgs) -- cgit v1.2.1 From 1f2d8690193476319d61b20b78461eb1a3ff106e Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 29 Dec 1998 11:59:58 +0000 Subject: mostly properly OO, some work still to be done with svc_ stuff --- TODO | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 24461b621..5c8e02cef 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.16 1998-12-16 05:38:39 ivan Exp $ +$Id: TODO,v 1.17 1998-12-29 11:59:32 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,14 @@ duplication of effort. -- 1.1.x -- +check all .pm's for numeric comparisons done as `eq' + +FS::cust_pkg _require_'s FS::$svc, but this won't work with %FS::UID::callback +loading of configuration. (pry need same idea, but will run immediately if +context allows). Looks like error is masked by 'use FS::cust_svc' which in +turn 'use's FS::{svc_acct, svc_acct_sm, svc_domain}' which is now explicit +w/comments in source + int'l stuff in web interface (not on david's time) admin web interface for titles (Dr., Mrs.) and default in fs-setup -- cgit v1.2.1 From d51c41b94bfa87d6c779ac666495151bf6fc3913 Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 30 Dec 1998 23:03:34 +0000 Subject: bugfixes; fields isn't exported by derived classes --- TODO | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index 5c8e02cef..349b2bf12 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.17 1998-12-29 11:59:32 ivan Exp $ +$Id: TODO,v 1.18 1998-12-30 23:03:19 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,7 +6,8 @@ duplication of effort. -- 1.1.x -- -check all .pm's for numeric comparisons done as `eq' +check all .pm's for numeric comparisons done as `eq' - works fine now because +only used with integers that aren't space-padded. FS::cust_pkg _require_'s FS::$svc, but this won't work with %FS::UID::callback loading of configuration. (pry need same idea, but will run immediately if -- cgit v1.2.1 From 65a4f2fb7d37996f89b5e22dac831e57d467d050 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 18 Jan 1999 23:05:00 +0000 Subject: update TODO for stuff that was done etc. --- TODO | 190 ++++++++++++++++++++++++------------------------------------------- 1 file changed, 67 insertions(+), 123 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index 349b2bf12..d53dab078 100644 --- a/TODO +++ b/TODO @@ -1,13 +1,17 @@ -$Id: TODO,v 1.18 1998-12-30 23:03:19 ivan Exp $ +$Id: TODO,v 1.19 1999-01-18 23:05:00 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid duplication of effort. --- 1.1.x -- +-- before 1.2b1 -- -check all .pm's for numeric comparisons done as `eq' - works fine now because -only used with integers that aren't space-padded. +Lay out the forms a bit better. + +view/cust_main.cgi should show country + +add doc on mod_perl: upgrade to current CGI.pm +doc Apache::AuthDBI as well FS::cust_pkg _require_'s FS::$svc, but this won't work with %FS::UID::callback loading of configuration. (pry need same idea, but will run immediately if @@ -15,53 +19,71 @@ context allows). Looks like error is masked by 'use FS::cust_svc' which in turn 'use's FS::{svc_acct, svc_acct_sm, svc_domain}' which is now explicit w/comments in source -int'l stuff in web interface (not on david's time) +libwww regression test - since it will create sample data, can also use this +for the web demo +make fs-setup option to add sample data so you can click on "New Customer" right away? so people understand what this stuff is? -admin web interface for titles (Dr., Mrs.) and default in fs-setup -(not on david's time) +Allow a cancelled/suspended/active status from packages to bubble up to +the customer lists. Put active, then suspended, then cancelled accounts. +Similar ordering on the package listing inside a single customer. -test and document libapache-dbi-logger (woo!) +Add the ability for services to filter information up to the package level +for invoices and web screens, so you can select a particlar package based +on username or domain name, etc. + +You can't delete the stuff under administration yet. Add this, +_including_ making sure the thing you are deleting is not in use! + +(Test this) +one-time/per-customer/? changes in rates and descriptions ('remembered +invoices'): implement by creating a new package on the fly... but it isn't +associated with any agent types so it won't show up for other customers to buy. +(but also... make sure they go away when the customer does! - need this? : + one-off package edits! : need a cust_pkgs or cust_part_pkgs or something table, + with custnum and partpkg (like type_pkgs) + +update site_perl/table_template* (pry out of date) + +-- before or after --- + +svc_domain.pm mail sending uses Date::Format which doesn't seem to pick up +correct timezone. + +view/svc_domain.cgi needs to know the domain might be unaudited (cosmetic) remove whois_hack set to 1 for svc_domain.pm? add all known registries and whois accordingly. +.us domains and others! +site_perl/svc_domain.cgi (hmm... or maybe should have a button? or maybe svc_domain.pm should handle this) should set $whois_hack for non-internic domains, so you can add them... -get rid of all relative URL's (have to make them on the fly) - see doc for -->redirect in CGI.pm +(test cust_main.pm with cybercash v2 and v3, especially with the callback + stuff AND with mod_perl w/cybercash v2 kludge in package main) +(callback stuff should be eliminated by now) -radius logfile parsing and perl expression check. +-- after -- faq -(test cust_main.pm with cybercash v2 and v3, especially with the callback - stuff) +cust_bill.pm uses '==' comparison on dates because they're currently ints + +config file for allowed card types + +write instructions for adding new services w/svc_Common.pm. Get rid of all +places where svc_* tables are hardcoded (rename svc_acct_pop to part_pop so +we can do that) + +test and document libapache-dbi-logger (woo!) + +radius logfile parsing and perl expression check. Fix in cust_bill BUGS: There is an off-by-one error in print_text which causes a visual error (Page 1 of 2 printed on some single-page invoices). -FIX It doesn't properly inherit/override FS::Record yet, so no more replace vs -rep silliness! - fields should be a method against a FS::Record or derived object, as well as being something you can call as FS::Record::fields('tablename'). Might even be able to handle both in the same routine (that would be neato). -Override FS::Record new, add, rep and del (create, insert, replace and -delete) in all derived classes. -IE create, insert, delete and replace from derived classes should override new, -add, del and rep (respectively) from FS::Record. Depriciate old names. - -Allow a cancelled/suspended/active status from packages to bubble up to -the customer lists. Put active, then suspended, then cancelled accounts. -Similar ordering on the package listing inside a single customer. - -Add the ability for services to filter information up to the package level -for invoices and web screens, so you can select a particlar package based -on username or domain name, etc. - -You can't delete the stuff under administration yet. Add this, -_including_ making sure the thing you are deleting is not in use! - Immediate removal of incorrectly entered check payments (can't take too long to do this, or accounting is fubared). @@ -85,13 +107,12 @@ name or first+last from cust_main. move all phone number logic out of Freeside - let HylaFAX or whatever handle it. -soundex searches for customer name and company? where are free soundex tools? (standard Text::Soundex duh) +soundex searches for customer name and company? where are free soundex tools? (standard Text::Soundex duh) - I could have sworn I saw Text::Soundex on CPAN?! -should be able to link on (username, domain name, some field in email alias) instead of svcnum only. (username done, what else?) +should be able to link on some field in email alias (right now you can link +on username or domain with a fallback to svcnum) -(done but clean up) change svc_domain.pm mail sending from a pipe to "/usr/lib/sendmail" to Mail::Mailer or Net::SMTP or something. also is the complete text of the registration agreement needed in there (it used to be)? - -generalize and make configurable new invoice printing scheme in FS::Bill::collect (past due) +generalize and make configurable new invoice printing scheme in FS::cust_main::collect (past due) deleting an svc_domain should delete all associated svc_acct_sm records. same with a svc_acct. @@ -105,34 +126,18 @@ expire cron job ... Allow for a future setup date on accounts. -one-time/per-customer/? changes in rates and descriptions ('remembered -invoices'): implement by creating a new package on the fly... but it isn't -associated with any agent types so it won't show up for other customers to buy. - -if CGI::Base will not have redirect fixed (cgifix.html), should migrate to -CGI.pm insetead? It is >1 year newer. - -library repetitve stuff from Bill.pm Invoice.pm and friends (calculating -previous balances etc etc) - - sub AUTOLOAD in FS::Record should warn? die? if used with a non-existant column name? edit (not just import, export and allow default/fixed) arbitrary radius stuff in svc_acct - edit/svc_acct.cgi and edit/process/svc_acct.cgi should deal with arbitrary radius stuff radius import should take DEFAULT entry and put it in /var/spool/freeside/conf/radius-default ; svc_acct.export should use it (and doc) -FS::Invoice and FS::Bill should merge with the classes they're derived from - in UI, s/State/State\/Provence/go and s/County/County\/Locality/go -.us domains and others! - -what else (besides l10n) for i18n? +what else (besides l10n) for i18n? (money!) audit htdocs/* for things that should be libraried and things that should be new methods on the objects (need to do this before implementing a new UI) @@ -142,10 +147,7 @@ some places we die() where we should &FS::CGI::idiot (and perhaps vice-versa). Decide based on whether or not the "error" should show up in logs. all .cgi's should use standard header/footer and idiot() subroutines. maybe HTML:: perl modules -for HTML creation. CGI.pm instead. - -library the conf reading stuff; bin/svc_acct.export version with missing-filename checking is good -library conf stuff -> check all the conf stuff to make sure they close filehandles. +for HTML creation. Maybe Embperl or something along those lines. ? When running bin/bill, Fix this (Annoying but harmless): Use of uninitialized value at /usr/local/lib/site_perl/FS/cust_pkg.pm line 99,
chunk 4. @@ -161,49 +163,9 @@ should FS::Record use Tie::Hash? That would be very clean, but where do we store the other information? Maybe you could ask any FS::Record object for a tied hash? -change all htdocs/edit/process/* loops to look like: (library this sort of thing!!!!) - -my($new) = create FS::svc_acct_sm ( { - map { - ($_, scalar($req->param($_))); - } qw(svcnum pkgnum svcpart domuser domuid domsvc) -} ); - -to avoid form errors causing too much silliness - -add this code to all svc_*.pm (already in acct and acct_sm and domain): (library!) - - #get part_svc - my($svcpart); - my($svcnum)=$self->getfield('svcnum'); - if ($svcnum) { - my($cust_svc)=qsearchs('cust_svc',{'svcnum'=>$svcnum}); - return "Unknown svcnum" unless $cust_svc; - $svcpart=$cust_svc->svcpart; - } else { - $svcpart=$self->getfield('svcpart'); - } - my($part_svc)=qsearchs('part_svc',{'svcpart'=>$svcpart}); - return "Unkonwn svcpart" unless $part_svc; - - #set fixed fields from part_svc - my($field); - foreach $field ( fields('svc_acct') ) { - if ( $part_svc->getfield('svc_acct__'. $field. '_flag') eq 'F' ) { - $self->setfield($field,$part_svc->getfield('svc_acct__'. $field) ); - } - } - change all file access from regular open(FILE,) stuff to OO, because of problems scoping and passing filehandles like that. -svc_domain.pm mail sending uses Date::Format which doesn't seem to pick up -correct timezone. - -view/svc_domain.cgi needs to know the domain might be unaudited (cosmetic) - ---- 1.1.x or 1.2 or later - the web interface should create a new object and use it instead of a blank form for new records. the create method of svc_ objects should set defaults (from part_svc). @@ -228,8 +190,6 @@ between packages). Auto-increment expired cards one year, and try again? -Lay out the forms a bit better. - More non-US stuff - zip codes, country codes, foreign currencies, etc. cust_refund.{cgi.pm} need to do cards xaxtions. (now we only have cust_credit) @@ -256,7 +216,6 @@ Add more registries (not just InterNIC's com org net edu) Nice postscript paper invoices, rather than current ASCII invoices. - think about race-condititions in FS::Record and derived ->check ->insert and so on, uid and username checks in svc_acct, etc. @@ -278,14 +237,14 @@ write a generic batch senders and batch parsers. need a way to override svc_acct export on a per-machine basis; just use config files based on machine name i suppose; document that. (no, import desync_hosts type stuff from cerkit) +... +add a table with column of export services (passwd, shadow, master.passwd, .qmail file update, dns update, etc.) and rows machine groups and whether or not to export that (and any necessary parameters). wasn't matt (vunderkid, not matt@michweb) working on this? find him? each machine goes in a group of its own as well as a group based on function. add a table with only svcpart and machine group. now, when you import from each machine, it can get its own accounts with one svcpart and universal accounts with another svcpart. (though that does make the username duplicate checking more interesting) you should be able to get column types as a method against an FS::Record object as well as dbdef->table($table)->column($column)->type move to perl module for fuzzy and soundex searching. -make fs-setup option to add sample data so you can click on "New Customer" right away? so people understand what this stuff is? - package view needs to list extraneous services; we need to prevent the creation of them so this never happens (and mark it as such in the source) (the creation problem should be fixed - though they will still happen if people @@ -304,11 +263,6 @@ something to automate making a release and updating the web demo export a debian-style (also redhat and?) /etc/group file aswell! -seems to be an off-by-one error in the ascii invoice formatting which is saying -"1 of 2" pages when there is only one. - -site_perl/svc_domain.cgi (hmm... or maybe should have a button? or maybe svc_domain.pm should handle this) should set $whois_hack for non-internic domains, so you can add them... - svc_acct_sm.import qmail import should pull in recipientmap people too. .pm's like svc_acct.pm which need to do time-consuming things like ssh remotely @@ -323,13 +277,8 @@ additional interfaces (perltk? java?) Put the GPL notice in all files. --- 1.2 or later -- - integrate w/IDEA's signup server -one-off package edits! : need a cust_pkgs or cust_part_pkgs or something table, -with custnum and partpkg (like type_pkgs) - $cust_bill->owed database field to be eliminated, replaced by a method call that calculates on the fly. make sure to grep for ->(get|set)field('owed') same for cust_credit->credited @@ -385,8 +334,6 @@ edit/svc_wo.cgi edit/process/svc_wo.cgi Call tracking and trouble tickets. -use mod_perl and Apache::AuthDBI instead of mod_auth_mysql when we do local -users More accoutability for complimentary accounts: approval, expiration, term (no more than x months in advance) and notification. Flag particular users (or all users, for that matter) as having their @@ -397,14 +344,11 @@ Better Freeside-level configurable access, for those ISP's who have employees they can't trust. Right now you're "stuck" with setting up .htaccess stuff yourself. This should really just be integrated. -update site_perl/table_template* (pry out of date) - -/var/spool/freeside/conf (and whatever else /var/spool/freeside we can) -in database (except secrets), then web interface, -make /var/spool/freeside a configurable directory (probably as part of -some automated installation process?) - -add a table with column of export services (passwd, shadow, master.passwd, .qmail file update, dns update, etc.) and rows machine groups and whether or not to export that (and any necessary parameters). wasn't matt (vunderkid, not matt@michweb) working on this? find him? each machine goes in a group of its own as well as a group based on function. add a table with only svcpart and machine group. now, when you import from each machine, it can get its own accounts with one svcpart and universal accounts with another svcpart. (though that does make the username duplicate checking more interesting) +configuration/setup should get web interface +... +/usr/local/etc/freeside should be configurable +... +(probably as part of some automated installation process?) password and slipip stuff in svc_acct.pm store need to be split into two fields or something, so the silliness in svc_acct.pm and svc_acct.export with looking at the data to decide what to do with it can be fixed (1.2) -- cgit v1.2.1 From 6e5eed5d49163fdb06f16c735ab43486c047011d Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 25 Jan 1999 12:10:00 +0000 Subject: yet more mod_perl stuff --- TODO | 48 ++++++++++++++++++++++++++++++++++++------------ 1 file changed, 36 insertions(+), 12 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index d53dab078..363c42adb 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.19 1999-01-18 23:05:00 ivan Exp $ +$Id: TODO,v 1.20 1999-01-25 12:09:48 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,18 +6,9 @@ duplication of effort. -- before 1.2b1 -- -Lay out the forms a bit better. - -view/cust_main.cgi should show country - -add doc on mod_perl: upgrade to current CGI.pm -doc Apache::AuthDBI as well +Can't use [e]idiot with mod_perl. -FS::cust_pkg _require_'s FS::$svc, but this won't work with %FS::UID::callback -loading of configuration. (pry need same idea, but will run immediately if -context allows). Looks like error is masked by 'use FS::cust_svc' which in -turn 'use's FS::{svc_acct, svc_acct_sm, svc_domain}' which is now explicit -w/comments in source +Lay out the forms a bit better. libwww regression test - since it will create sample data, can also use this for the web demo @@ -41,11 +32,24 @@ associated with any agent types so it won't show up for other customers to buy. (but also... make sure they go away when the customer does! - need this? : one-off package edits! : need a cust_pkgs or cust_part_pkgs or something table, with custnum and partpkg (like type_pkgs) +(what happens if you hit "custom pricing" but the pricing is already custom?) update site_perl/table_template* (pry out of date) +update web demo + -- before or after --- +FS::cust_pkg _require_'s FS::$svc, but this won't work with %FS::UID::callback +loading of configuration. (pry need same idea, but will run immediately if +context allows). Looks like error is masked by 'use FS::cust_svc' which in +turn 'use's FS::{svc_acct, svc_acct_sm, svc_domain}' which is now explicit +w/comments in source + +Allow a cancelled/suspended/active status from packages to bubble up to +the customer lists. Put active, then suspended, then cancelled accounts. +Similar ordering on the package listing inside a single customer. + svc_domain.pm mail sending uses Date::Format which doesn't seem to pick up correct timezone. @@ -62,6 +66,19 @@ site_perl/svc_domain.cgi (hmm... or maybe should have a button? or maybe svc_do -- after -- +bah, table/itable/*table in FS::CGI is silly. + +doc Apache::AuthDBI as well +.. +Provide sample httpd.conf files. + +hey look: Tie::DBI! Check that out. Override its commit with something that +does perl-side caching for ? a performance improvement and as an emulation +layer to plug in f.ex mysql's atomic transactions +.. +Record.pm uses does some non-portable DBI things. MySQL and Pg seem fine. +Fix it anyway unless we migrate to Tie::DBI. + faq cust_bill.pm uses '==' comparison on dates because they're currently ints @@ -366,6 +383,13 @@ transactions or atomic updates). Or just require a RDBMS that supports rollback and/or atomic updates and get rid of the work-arounds? The /rdb interface had this kludge on top of it but is a technical dead-end in most other ways, unless it can gain an SQL parser and DBD interface. +... +if i'm really bored, find the /rdb interface in fsold and port it to NoSQL, +and while I'm add it add interfaces for AnyDBM_File tied hash.. hmm. Shouldn't +an FS::Record have something to do with a tied hash? But we don't want +performance to go gaga... maybe something with commit to help out here? +... +Ok: FS::Record gives you a tied hash, and you get methods for commit, etc. Better automated comparison of our CC records with processors (CyberCash, at least, has not always had 100% accuracy, though recent versions are -- cgit v1.2.1 From 899b323ee2feeaf78afdb40526eb75995fe72cad Mon Sep 17 00:00:00 2001 From: ivan Date: Sat, 6 Feb 1999 22:43:24 +0000 Subject: don't use [e]idiot; display error messages on the form page --- TODO | 24 ++++++++++++++++++++++-- 1 file changed, 22 insertions(+), 2 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index 363c42adb..920e160ab 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.20 1999-01-25 12:09:48 ivan Exp $ +$Id: TODO,v 1.21 1999-02-06 22:43:24 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,7 +6,25 @@ duplication of effort. -- before 1.2b1 -- -Can't use [e]idiot with mod_perl. +Can't use [e]idiot with mod_perl (not with forms and `press back button' and +expire=>now, anyway). + +"popurlidiot" is not exported by the FS::CGI module at htdocs/misc/process/link.cgi line 27 +Content-type: text/html + +

Software error:

+Can't continue after import errors at htdocs/misc/process/link.cgi line 27 +BEGIN failed--compilation aborted at htdocs/misc/process/link.cgi line 27. + +

+For help, please send mail to this site's webmaster, giving this error message +and the time and date of the error. + +[Fri Feb 5 02:26:23 1999] link.cgi: Can't continue after import errors at htdocs/misc/process/link.cgi line 27 +[Fri Feb 5 02:26:23 1999] link.cgi: BEGIN failed--compilation aborted at htdocs/misc/process/link.cgi line 27. + + +clean up view/cust_pkg and view/svc_* yuck! Lay out the forms a bit better. @@ -40,6 +58,8 @@ update web demo -- before or after --- +add links on view/cust_main.cgi to setup services, like view/cust_pkg.cgi + FS::cust_pkg _require_'s FS::$svc, but this won't work with %FS::UID::callback loading of configuration. (pry need same idea, but will run immediately if context allows). Looks like error is masked by 'use FS::cust_svc' which in -- cgit v1.2.1 From e0da34d97b1463b55a334e8dae10cd55796e2312 Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 7 Feb 1999 09:59:44 +0000 Subject: more mod_perl fixes, and bugfixes Peter Wemm sent via email --- TODO | 33 ++++++++++----------------------- 1 file changed, 10 insertions(+), 23 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index 920e160ab..869e13d4a 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.21 1999-02-06 22:43:24 ivan Exp $ +$Id: TODO,v 1.22 1999-02-07 09:59:12 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,23 +6,9 @@ duplication of effort. -- before 1.2b1 -- -Can't use [e]idiot with mod_perl (not with forms and `press back button' and -expire=>now, anyway). - -"popurlidiot" is not exported by the FS::CGI module at htdocs/misc/process/link.cgi line 27 -Content-type: text/html - -

Software error:

-Can't continue after import errors at htdocs/misc/process/link.cgi line 27 -BEGIN failed--compilation aborted at htdocs/misc/process/link.cgi line 27. - -

-For help, please send mail to this site's webmaster, giving this error message -and the time and date of the error. - -[Fri Feb 5 02:26:23 1999] link.cgi: Can't continue after import errors at htdocs/misc/process/link.cgi line 27 -[Fri Feb 5 02:26:23 1999] link.cgi: BEGIN failed--compilation aborted at htdocs/misc/process/link.cgi line 27. +missed popurl in (at least) search/cust_pkg.cgi +one-screen new customer entry clean up view/cust_pkg and view/svc_* yuck! @@ -40,9 +26,6 @@ Add the ability for services to filter information up to the package level for invoices and web screens, so you can select a particlar package based on username or domain name, etc. -You can't delete the stuff under administration yet. Add this, -_including_ making sure the thing you are deleting is not in use! - (Test this) one-time/per-customer/? changes in rates and descriptions ('remembered invoices'): implement by creating a new package on the fly... but it isn't @@ -56,7 +39,10 @@ update site_perl/table_template* (pry out of date) update web demo --- before or after --- +-- release 1.2b1 --- + +You can't delete the stuff under administration yet. Add this, +_including_ making sure the thing you are deleting is not in use! add links on view/cust_main.cgi to setup services, like view/cust_pkg.cgi @@ -80,12 +66,13 @@ whois accordingly. .us domains and others! site_perl/svc_domain.cgi (hmm... or maybe should have a button? or maybe svc_domain.pm should handle this) should set $whois_hack for non-internic domains, so you can add them... +turn on the depriciation warnings for [e]idiot in FS::CGI. Stop using [e]idiot +the last places it is (htdocs/search/ htdocs/misc/ htdocs/misc/process) + (test cust_main.pm with cybercash v2 and v3, especially with the callback stuff AND with mod_perl w/cybercash v2 kludge in package main) (callback stuff should be eliminated by now) --- after -- - bah, table/itable/*table in FS::CGI is silly. doc Apache::AuthDBI as well -- cgit v1.2.1 From 56db918b73539ac0e06bc056528ead7efb928d52 Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 9 Feb 1999 09:56:34 +0000 Subject: *** empty log message *** --- TODO | 31 +++++++++++++++++++------------ 1 file changed, 19 insertions(+), 12 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index 869e13d4a..32961b6a9 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.22 1999-02-07 09:59:12 ivan Exp $ +$Id: TODO,v 1.23 1999-02-09 09:56:34 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,11 +6,9 @@ duplication of effort. -- before 1.2b1 -- -missed popurl in (at least) search/cust_pkg.cgi - one-screen new customer entry -clean up view/cust_pkg and view/svc_* yuck! +clean up view/cust_pkg and view/svc_* yuck (popurl and visual)! Lay out the forms a bit better. @@ -18,14 +16,6 @@ libwww regression test - since it will create sample data, can also use this for the web demo make fs-setup option to add sample data so you can click on "New Customer" right away? so people understand what this stuff is? -Allow a cancelled/suspended/active status from packages to bubble up to -the customer lists. Put active, then suspended, then cancelled accounts. -Similar ordering on the package listing inside a single customer. - -Add the ability for services to filter information up to the package level -for invoices and web screens, so you can select a particlar package based -on username or domain name, etc. - (Test this) one-time/per-customer/? changes in rates and descriptions ('remembered invoices'): implement by creating a new package on the fly... but it isn't @@ -41,6 +31,23 @@ update web demo -- release 1.2b1 --- +(is this missing on any web screens? (easy with $cust_svc->label) +Add the ability for services to filter information up to the package level +for web screens, so you can select a particlar package based +on username or domain name, etc. + +Allow a cancelled/suspended/active status from packages to bubble up to +the customer lists. Put active, then suspended, then cancelled accounts. +Similar ordering on the package listing inside a single customer. + +false laziness: some of search/svc_acct_sm.cgi was copied to search/svc_domain.cgi. but web interface in general needs to be rewritten in a mucho cleaner way. + +Portability: in FS::Record, $sth->execute does not return a number of rows for all DBD's. see man DBI + +subroutine the where clause (eventually all SQL) as OO perhaps (has anyone done this?) + +add a select method to + You can't delete the stuff under administration yet. Add this, _including_ making sure the thing you are deleting is not in use! -- cgit v1.2.1 From 9b6448c43836802b019043e4c20ecf6328af3f1b Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 10 Feb 1999 08:27:55 +0000 Subject: *** empty log message *** --- TODO | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 32961b6a9..93f9ed88d 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.23 1999-02-09 09:56:34 ivan Exp $ +$Id: TODO,v 1.24 1999-02-10 08:27:55 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -31,6 +31,11 @@ update web demo -- release 1.2b1 --- +edit/cust_main.cgi gives an uninformative error message: +> Can't call method "agentnum" without a package or object reference at +> /usr/local/apache-ssl/htdocs/freeside/edit/cust_main.cgi line 116. +if there are no agents. + (is this missing on any web screens? (easy with $cust_svc->label) Add the ability for services to filter information up to the package level for web screens, so you can select a particlar package based -- cgit v1.2.1 From 510d2f9647c0651a82760e456b46505e8050d6ed Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 23 Feb 1999 08:09:27 +0000 Subject: beginnings of one-screen new customer entry and some other miscellania --- TODO | 27 +++++++++++++++++++++++---- 1 file changed, 23 insertions(+), 4 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index 93f9ed88d..611f83ec5 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.24 1999-02-10 08:27:55 ivan Exp $ +$Id: TODO,v 1.25 1999-02-23 08:09:18 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,8 @@ duplication of effort. -- before 1.2b1 -- +TEST email invoices + one-screen new customer entry clean up view/cust_pkg and view/svc_* yuck (popurl and visual)! @@ -15,6 +17,8 @@ Lay out the forms a bit better. libwww regression test - since it will create sample data, can also use this for the web demo make fs-setup option to add sample data so you can click on "New Customer" right away? so people understand what this stuff is? +(in sample data [ AND DOCUMENT! ] all svc_acct services should have a default + or fixed shell ) (Test this) one-time/per-customer/? changes in rates and descriptions ('remembered @@ -27,10 +31,24 @@ associated with any agent types so it won't show up for other customers to buy. update site_perl/table_template* (pry out of date) +remove "records identical" warning? gets in the way of more important stuff. + update web demo -- release 1.2b1 --- +password and slipip stuff in svc_acct.pm store need to be split into two fields or something, so the silliness in svc_acct.pm and svc_acct.export with looking at the data to decide what to do with it can be fixed + +i10n: Apache::Language + +Apache::Session? Other useful Apache::* ? + +email invoices are only sent for the BILL payby. If setup, should statements +(since they're not invoices) be sent for COMP and CARD as well? + +$cgi->keywords is causing the (hard to trace) error: + Use of uninitialized value at (eval 5) line 5 + edit/cust_main.cgi gives an uninformative error message: > Can't call method "agentnum" without a package or object reference at > /usr/local/apache-ssl/htdocs/freeside/edit/cust_main.cgi line 116. @@ -45,13 +63,16 @@ Allow a cancelled/suspended/active status from packages to bubble up to the customer lists. Put active, then suspended, then cancelled accounts. Similar ordering on the package listing inside a single customer. +false laziness: edit/cust_main.cgi got some parts copied from edit/svc_acct.cgi +the web interface in general needs to be redone in a more abstract way. + false laziness: some of search/svc_acct_sm.cgi was copied to search/svc_domain.cgi. but web interface in general needs to be rewritten in a mucho cleaner way. Portability: in FS::Record, $sth->execute does not return a number of rows for all DBD's. see man DBI subroutine the where clause (eventually all SQL) as OO perhaps (has anyone done this?) -add a select method to +add a select method to ? You can't delete the stuff under administration yet. Add this, _including_ making sure the thing you are deleting is not in use! @@ -386,8 +407,6 @@ configuration/setup should get web interface ... (probably as part of some automated installation process?) -password and slipip stuff in svc_acct.pm store need to be split into two fields or something, so the silliness in svc_acct.pm and svc_acct.export with looking at the data to decide what to do with it can be fixed (1.2) - This requires some serious magic in FS::Record: ok, if date_type in fs-setup is to be something besides int, now we need to create wrappers -- cgit v1.2.1 From f54abd440ef3d4d480eba185df1c5e65b0affd4c Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 8 Apr 1999 13:03:02 +0000 Subject: *** empty log message *** --- TODO | 53 +++++++++++++++++++++++++++-------------------------- 1 file changed, 27 insertions(+), 26 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index 611f83ec5..7b1a5143d 100644 --- a/TODO +++ b/TODO @@ -1,41 +1,34 @@ -$Id: TODO,v 1.25 1999-02-23 08:09:18 ivan Exp $ +$Id: TODO,v 1.26 1999-04-08 13:03:02 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid duplication of effort. --- before 1.2b1 -- +--- -TEST email invoices +javascript (yuck!) "are you sure?" confirmation on cancelations, etc. +(view/cust_pkg and view/svc_*) -one-screen new customer entry +get rid of time2str("%D") which formats dates in a non-y2k-safe looking fashion +(all the actual date handling uses UNIX timestamps and is fine) -clean up view/cust_pkg and view/svc_* yuck (popurl and visual)! +uncomment expire in view/cust_pkg.cgi and find the expire cron from fsold -Lay out the forms a bit better. - -libwww regression test - since it will create sample data, can also use this -for the web demo -make fs-setup option to add sample data so you can click on "New Customer" right away? so people understand what this stuff is? -(in sample data [ AND DOCUMENT! ] all svc_acct services should have a default - or fixed shell ) - -(Test this) -one-time/per-customer/? changes in rates and descriptions ('remembered -invoices'): implement by creating a new package on the fly... but it isn't -associated with any agent types so it won't show up for other customers to buy. -(but also... make sure they go away when the customer does! - need this? : - one-off package edits! : need a cust_pkgs or cust_part_pkgs or something table, - with custnum and partpkg (like type_pkgs) -(what happens if you hit "custom pricing" but the pricing is already custom?) - -update site_perl/table_template* (pry out of date) +Lay out any remaining ugly forms better. remove "records identical" warning? gets in the way of more important stuff. +or fix logic which tries to update identical records?? +1.2 should be quiet enough that the error log is useful, hopefully. -update web demo +Postgres has a maximum column length of 31 characters (but see NAMEDATALEN in +postgres_ext.h). part_svc has columns like: svc_acct__radius_Attribute_flag +(22 characters!) It seems that stuff over the limit is silently ignored, +so we get 4 characters back. So, Radius_Attributes are max 13 characters with +stock Postgres. see rfc2138 for what's affected +What's a good fix? (besides recompiling postgres with NAMEDATALEN 64) +(mysql has a 64 character max column length. others?) --- release 1.2b1 --- +look at DBIx::Recordset! (and Tie::DBI, and...) password and slipip stuff in svc_acct.pm store need to be split into two fields or something, so the silliness in svc_acct.pm and svc_acct.export with looking at the data to decide what to do with it can be fixed @@ -72,7 +65,15 @@ Portability: in FS::Record, $sth->execute does not return a number of rows for a subroutine the where clause (eventually all SQL) as OO perhaps (has anyone done this?) -add a select method to ? +add a select method to FS::Record? + +one-time/per-customer/? changes in rates and descriptions ('remembered +invoices'): implement by creating a new package on the fly... but it isn't +associated with any agent types so it won't show up for other customers to buy. +(but also... make sure they go away when the customer does! - need this? : + one-off package edits! : need a cust_pkgs or cust_part_pkgs or something table, + with custnum and partpkg (like type_pkgs) +(what happens if you hit "custom pricing" but the pricing is already custom?) You can't delete the stuff under administration yet. Add this, _including_ making sure the thing you are deleting is not in use! -- cgit v1.2.1 From 639f53025c49248c598a324814f6d77739bdfd89 Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 9 Apr 1999 03:52:16 +0000 Subject: *** empty log message *** --- TODO | 23 ++++++++++++++++++++++- 1 file changed, 22 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 7b1a5143d..6d57aa09c 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.26 1999-04-08 13:03:02 ivan Exp $ +$Id: TODO,v 1.27 1999-04-09 03:52:16 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -14,6 +14,15 @@ get rid of time2str("%D") which formats dates in a non-y2k-safe looking fashion uncomment expire in view/cust_pkg.cgi and find the expire cron from fsold +(Test this) +one-time/per-customer/? changes in rates and descriptions ('remembered +invoices'): implement by creating a new package on the fly... but it isn't +associated with any agent types so it won't show up for other customers to buy. +(but also... make sure they go away when the customer does! - need this? : + one-off package edits! : need a cust_pkgs or cust_part_pkgs or something table, + with custnum and partpkg (like type_pkgs) +(what happens if you hit "custom pricing" but the pricing is already custom?) + Lay out any remaining ugly forms better. remove "records identical" warning? gets in the way of more important stuff. @@ -28,8 +37,20 @@ stock Postgres. see rfc2138 for what's affected What's a good fix? (besides recompiling postgres with NAMEDATALEN 64) (mysql has a 64 character max column length. others?) +[Mon Mar 29 06:57:56 1999] -e: Use of uninitialized value at /usr/lib/perl5/Date/Format.pm line 333. +(when sending mail in cust_main.pm::bill or svc_domain.pm) + look at DBIx::Recordset! (and Tie::DBI, and...) +undefined conf/lpr gives this uninfomative error: +[Fri Feb 26 16:42:36 1999] bill.cgi: Can't do bidirectional pipe at +/usr/lib/per +l5/site_perl/FS/cust_main.pm line 629. +[Fri Feb 26 16:42:38 1999] bill.cgi: Error closing : Broken pipe at +/usr/lib/per +l5/site_perl/FS/cust_main.pm line 631. +So give a meaningful error! + password and slipip stuff in svc_acct.pm store need to be split into two fields or something, so the silliness in svc_acct.pm and svc_acct.export with looking at the data to decide what to do with it can be fixed i10n: Apache::Language -- cgit v1.2.1 From 65c463c724448543666035f3ec967a0c14be8960 Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 14 Apr 1999 08:58:59 +0000 Subject: *** empty log message *** --- TODO | 13 ++++++++++++- 1 file changed, 12 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 6d57aa09c..f6eaf5ed1 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.27 1999-04-09 03:52:16 ivan Exp $ +$Id: TODO,v 1.28 1999-04-14 08:58:59 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,17 @@ duplication of effort. --- +hmm... maybe svc_acct__shell should check off the legal shells list if +applicable? yeah... cool. + +payinfo field should me much larger than 16 + +default (and ordering) state/county/country config file + +[Mon Apr 12 20:31:21 1999] [error] [Mon Apr 12 20:31:21 1999] null: Error closing true: Broken pipe at /usr/local/lib/site_perl/FS/cust_main.pm line 615. + +configuration option to show passwords + javascript (yuck!) "are you sure?" confirmation on cancelations, etc. (view/cust_pkg and view/svc_*) -- cgit v1.2.1 From 6c44581c70239fcf331b072bbfb4b2e08ef04166 Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 14 Apr 1999 11:27:06 +0000 Subject: showpasswords config option to show passwords --- TODO | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index f6eaf5ed1..114e010ae 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.28 1999-04-14 08:58:59 ivan Exp $ +$Id: TODO,v 1.29 1999-04-14 11:27:06 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -15,8 +15,6 @@ default (and ordering) state/county/country config file [Mon Apr 12 20:31:21 1999] [error] [Mon Apr 12 20:31:21 1999] null: Error closing true: Broken pipe at /usr/local/lib/site_perl/FS/cust_main.pm line 615. -configuration option to show passwords - javascript (yuck!) "are you sure?" confirmation on cancelations, etc. (view/cust_pkg and view/svc_*) -- cgit v1.2.1 From ff9083f7660a3397d73377efec15feff432d5958 Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 14 Apr 1999 13:14:54 +0000 Subject: configuration option to edit referrals of existing customers --- TODO | 9 +++++++-- 1 file changed, 7 insertions(+), 2 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index 114e010ae..5dbfab256 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.29 1999-04-14 11:27:06 ivan Exp $ +$Id: TODO,v 1.30 1999-04-14 13:14:54 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,12 +6,17 @@ duplication of effort. --- +default (and ordering) state/county/country config file +expand the +cust_main_county table to provide a preferred ordering, so the most common +entries would be at the top of the selection box. automatically, based on +recent selections? + hmm... maybe svc_acct__shell should check off the legal shells list if applicable? yeah... cool. payinfo field should me much larger than 16 -default (and ordering) state/county/country config file [Mon Apr 12 20:31:21 1999] [error] [Mon Apr 12 20:31:21 1999] null: Error closing true: Broken pipe at /usr/local/lib/site_perl/FS/cust_main.pm line 615. -- cgit v1.2.1 From 014ccf7cfed0db6c06e92d76de5825ccd19b6cbe Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 29 Apr 1999 09:37:45 +0000 Subject: *** empty log message *** --- TODO | 76 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++- 1 file changed, 75 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 5dbfab256..251aa8907 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.30 1999-04-14 13:14:54 ivan Exp $ +$Id: TODO,v 1.31 1999-04-29 09:37:45 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,80 @@ duplication of effort. --- +> Second, when trying to add a new user I get two types of errors; first one +> is when I place an e-mail address and select the "submit," Freeside +> complains with "Error: Unknown local account (specified literally)" +. +You probably put a (local) email address in for email invoices. Freeside +stores these as references to the database records, so (for example) they +follow username changes. +. +I'm guessing you put in the email address that you were creating, and got +that error because it didn't exist yet. Sounds like a buglet to me. I'll +try to fix that soon; in the meantime you can add the invoicing email +address afterwords. + +Postgres `money' time sucks rocks anyway. I'll probably just require 6.5 +and use the numeric types, which *finally* work right. +On Sat, Apr 24, 1999 at 12:52:00PM -0700, Mr. Poet wrote: +> Software error: +> Error creating cust_bill record: ERROR: parser: +> attribute 'charged' is of type 'money' but expression +> is of type 'float8' You will need to rewrite or cast +> the expression ! Check updated but unbilled packages +> for customer1 +. +Postgres `money' time sucks rocks anyway. I'll probably just require 6.5 +and use the numeric types, which *finally* work right (well, according to +the web site, anyway). +. +In the mean-time, this could probably be fixed with the reverse of +the kludge in FS::Record::new. This removes `$' and `,' from money fields +coming out of the database. Something which fixed up the data so Postgres +was happy with it could go in FS::Record::_quote, for data going into the +database. + +our data display problem might be a Freeside problem wrt not using +Oracle-compatible DBI syntax (uses the return value from $sth->execute as +a number of rows). Fixing this is on the TODO. + +hooks for arbitrary commands out of configuration files +svc_acct.pm svc_acct_sm.pm etc. + +Add this to a FAQ, along with doing it for middle names: + + +> What I'm finding difficult is how to easily +> customize fields. For example, I am trying to add a "middle name" field +> to the Customer Edit, view, etc. If I'm going about it right, it appears +> I have to edit the cust_main.cgi under edit and edit/process and the +> site_perl/cust_main.pm, as well as other things. Perhaps you could shed +> some light on the best way of doing this. + +You have the basic idea. To implement that completely, I would: +- Add the new field to bin/fs-setup for new users +- Document the field in htdocs/docs/schema.html +- Document the change in a new file, htdocs/docs/upgrade4.html +* Run bin/dbdef-create +* Add the new field to edit/cust_main.cgi and edit/process/cust_main.cgi + +For bonus points, I'd grep around for the various bits which use "$first +$last" or "$last, $first" and replace them with a method call in cust_main.pm, + , like search/cust_main.cgi + +document security model: +Don't forget about Apache usernames - since, via the mapsecrets file, each +user can login to the SQL database with a different username and +password, you can utitilize the security model of the SQL database as +well. Also, each username here can point to a different configuration +directory where you could store user-specific configuration info. Then +you could link each username to one-to-many agents. +(The web demo works using a trivial version of this.) + +Yes, queue processing or the equivalent via checkpoint fields on various +talbes (which you pick up via a pretty simple SELECT) would be really +nice too. + default (and ordering) state/county/country config file expand the cust_main_county table to provide a preferred ordering, so the most common -- cgit v1.2.1 From a1438f1181c842889fc9bab5b8a24bcbbe31a6a3 Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 8 Jul 1999 01:02:24 +0000 Subject: *** empty log message *** --- TODO | 14 +++++++++++++- 1 file changed, 13 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 251aa8907..9641831c1 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.31 1999-04-29 09:37:45 ivan Exp $ +$Id: TODO,v 1.32 1999-07-08 01:02:24 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,18 @@ duplication of effort. --- +Multiple tax rates by geographic region (county, state, and county) are +supported; just choose View/Edit tax rates from the main menu. + +Multiple tax rates by package are not (yet) supported. + +On Wed, Jul 07, 1999 at 12:13:36PM -0400, Shaun Batterton wrote: +> How would you handle something like multiple tax rates and multiple +> states? For example in Connecticut, they just changed computer and/or +> data processing services to 3% (whatever that is), and everything else +> is 6%. + + > Second, when trying to add a new user I get two types of errors; first one > is when I place an e-mail address and select the "submit," Freeside > complains with "Error: Unknown local account (specified literally)" -- cgit v1.2.1 From 7613e14fd13aabb2a44bb26ca8640053f44930ea Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 8 Jul 1999 11:40:40 +0000 Subject: *** empty log message *** --- TODO | 130 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++- 1 file changed, 129 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 9641831c1..44358e938 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.32 1999-07-08 01:02:24 ivan Exp $ +$Id: TODO,v 1.33 1999-07-08 11:40:40 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,134 @@ duplication of effort. --- +grep 'uncomment this to encrypt password immediately' site_perl/svc_acct.pm +Not to say that it shouldn't be a configurable option. + +in site_perl/cust_main_invoice.pm (elsewhere?), error out if mydomain config file is gone +(at least until the idea of a default domain goes away) + +FS::Record::qsearch does an eval every loop iteration (which is itself not +guaranteed to work across all DBD's and should be fixed). This has got to be +slow. Fix it. (I think recent Perls might have a way to accept a variable +there, no eval needed?) + +Could you have added /bin/sync, /sbin/shutdown, and /bin/halt to the +`shells' configuration file before importing, and removed them afterwords? +(even better if svc_acct.import did that automatically - it could just +munge and restore @FS::svc_acct::shells... hmm.) + +> BTW, Ivan, I am trying to verify in an additional database table that a +> particular user doesn't exist. This database is used to store email aliases a$ +> additional POP boxes for our customers (kinda like AOL allows). I have toyed +> with the idea of just writing the aliases to an email only svc_acct that +> doesn't write to the password file, but that isn't really how I want to do it. + +Actually, I think that's a pretty good way to do it. Cerkit contributed +support a little while back for svc_acct.pm and svc_acct.export for +multiple export targets. It needs to be cleaned up and documented, which +I'll try to get to soon. For this to work correctly, the svc_acct_sm +table should go away, along with the concept of a "default" domain. + +default setting for new packages should allow all agents to purchase them... +with a config file for the old behaviour + +replace Term::Query with Quiz::Question? + +Check config file reading stuff from CPAN + +Authorizenet module from CPAN! + + has a good y2k complience +statement! + + I'm hoping Freeside can support arbitrailly complex pricing plans + because of a simple concept: all prices are perl expressions. So if + you use `19.95' for example, perl evalates that to be `19.95'. But if + you need to do a complex pricing scheme, you just need to write an + appropriate perl expression, which will most likely pull data from the + database to return pricing. Some things will already log to SQL; for + example most RADIUS servers can or have a patch available. Getting + Freeside to bill based on any sort of data then becomes a matter of + importing the data into the database. + + There are some issues involved with pro-rating, partial month charges, + that sort of thing. Expressions will need a standard way to have the + applicable time/data ranges passed to them. Also the expressions are + currently running under the Safe perl module, and the opmask might not + be right in all situations. I'll try to spend some time working on + this if you are using it. + +> 2. can customers view their bills on-line. + +Not yet; it needs to be proxied from Freeside to a customer web server in +a secure way using something not completely unlike the fs_passwd, +fs_passwdd, fs_passwd_server trio. + + +> Lastly, if someone over pays on an invoice, the credit part does not flow +> over to other invoices.. + +The total balance flows over correctly, but individual payments don't. +The code you're looking for is in FS::cust_pay::insert + +The question of what to do with overpayments that don't have another +invoice to flow into (yet.. or possibly not) is still an open one. The +legacy system Freeside replaced long ago had a separate place for this +(payments waiting for an invoice) for each customer, and it gave our +bookeeper fits. + + +option to relax username uniqueness in favor of username+domain or mail/shell +vs. radius to ease import for isp's with namespace problems or who buy others. + +do i have to store anything for radius realms besides regular radius attributes +(which are handled fine now)? + +warn or complain or something when invoice_from is empty (and we use it) + +Right now Freeside uses the `freq' field of a package definition as a +number of months. The specific section of code you're looking for is in +FS::cust_main::bill: + + #change this bit to use Date::Manip? + #$sdate=$cust_pkg->bill || time; + #$sdate=$cust_pkg->bill || $time; + $sdate = $cust_pkg->bill || $cust_pkg->setup || $time; + my ($sec,$min,$hour,$mday,$mon,$year) = + (localtime($sdate) )[0,1,2,3,4,5]; + $mon += $part_pkg->getfield('freq'); + until ( $mon < 12 ) { $mon -= 12; $year++; } + $cust_pkg->setfield('bill', + timelocal($sec,$min,$hour,$mday,$mon,$year)); + $cust_pkg_mod_flag = 1; + +..and when I went poking for this, looks like it tells us just what needs +to be done! Hehehe... + +Date::Manip can handle cool things like "+ 1 month" (actually the current +case of /^(\d+)$/ would have to be added as a special case of "+ $1 +month") and "+ 30 days" (what you need) and even "+ 5 business days" ! + + +On Wed, Apr 28, 1999 at 08:38:16PM +0000, Kristian Hoffmann wrote: +> I can't quite seem to figure out how this exporting works. From what I +> understand, when you run svc_acct.export, it rewrites the /etc/passwd, +> /etc/shadow, etc. files. Is this only for initial setups with the +> export hooks being in the pm's? + +You can use both, or just one method. The configuration files control +this. One of the things in the TODO is to take out the last few things +that aren't customizable wrt this and put them in config files. + +http://www.daemonnews.org/199905/user-mgmt.html + +Term::Query doesn't install out of the box from CPAN. Fix it (and get it +submitted upstream!), or remove requirement from bin/svc_acct.import and +bin/svc_acct_sm.import and take it out of the install instructions. + +use this cool link to explain the Freeside API +ftp://cpan.nas.nasa.gov/pub/perl/CPAN/doc/FMTEYEWTK/easy_objects.html + Multiple tax rates by geographic region (county, state, and county) are supported; just choose View/Edit tax rates from the main menu. -- cgit v1.2.1 From 76cfe14729d0313365206e4f55882a09f1a68890 Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 15 Jul 1999 23:50:42 +0000 Subject: *** empty log message *** --- TODO | 13 ++++++++++++- 1 file changed, 12 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 44358e938..61a8d318d 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.33 1999-07-08 11:40:40 ivan Exp $ +$Id: TODO,v 1.34 1999-07-15 23:50:42 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,17 @@ duplication of effort. --- +middle names and titles + +On Wed, Jul 07, 1999 at 01:11:40PM -0400, Frank Nazario wrote: +> Playing and entering information to Freeside i encountered the following +> missing reports: +> +> View Customers by Agent +> +> View Pending Invoices +> + grep 'uncomment this to encrypt password immediately' site_perl/svc_acct.pm Not to say that it shouldn't be a configurable option. -- cgit v1.2.1 From 518adbd51689c6b8be42891485648fccd650f8cb Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 16 Jul 1999 00:20:53 +0000 Subject: *** empty log message *** --- TODO | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 61a8d318d..e24c9935a 100644 --- a/TODO +++ b/TODO @@ -1,10 +1,14 @@ -$Id: TODO,v 1.34 1999-07-15 23:50:42 ivan Exp $ +$Id: TODO,v 1.35 1999-07-16 00:20:53 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid duplication of effort. --- +Put this in the doc (quoting Mark Wells ): +>Of course, thanks to the sheer coolness of SQL and MyODBC, you can do +>whatever reports you want in basically whatever application you want. +>There's no need for Freeside itself to do any reports at all. middle names and titles -- cgit v1.2.1 From 53437ddeba0439876f496eae235700d46ea7645f Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 29 Jul 1999 19:13:06 +0000 Subject: *** empty log message *** --- TODO | 19 ++++++++++++++++++- 1 file changed, 18 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index e24c9935a..670201602 100644 --- a/TODO +++ b/TODO @@ -1,10 +1,27 @@ -$Id: TODO,v 1.35 1999-07-16 00:20:53 ivan Exp $ +$Id: TODO,v 1.36 1999-07-29 19:13:06 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid duplication of effort. --- + +A web version of the fs_passwd stuff would be nifty. + +If you have Cistron authenticating directly from MySQL, you can replicate +in real-time instead of exporting periodically. See +. + +these go in docs: +, and + + +and http://www.sisd.com/freeside/list-archive/msg00423.html + +> > 5: Is there anyway to get freeside to send a sysadmin a warning when a +> > credit card has expired? +No, but there should be. + Put this in the doc (quoting Mark Wells ): >Of course, thanks to the sheer coolness of SQL and MyODBC, you can do >whatever reports you want in basically whatever application you want. -- cgit v1.2.1 From 9f2781f5d45997c856e1930757daa2cb1d5cddcc Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 3 Aug 1999 07:43:33 +0000 Subject: use Net::Whois; --- TODO | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 670201602..12bacc8c5 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.36 1999-07-29 19:13:06 ivan Exp $ +$Id: TODO,v 1.37 1999-08-03 07:43:33 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,9 @@ duplication of effort. --- +take the GPL'ed whois proxy stuff at www.geektools.com and turn it into +intelligence for Net::Whois. + A web version of the fs_passwd stuff would be nifty. If you have Cistron authenticating directly from MySQL, you can replicate -- cgit v1.2.1 From 8baa6fc6b5ce7373cf2bb68ae2686a70935d47aa Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 27 Aug 1999 06:25:56 +0000 Subject: *** empty log message *** --- TODO | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 12bacc8c5..f7d95d697 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.37 1999-08-03 07:43:33 ivan Exp $ +$Id: TODO,v 1.38 1999-08-27 06:25:56 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,12 @@ duplication of effort. --- +> So is there anyway it could be setup to allow you to select a "primary +> service" from each package? This service would be the one you were prompted +> for. Could the signup server then be expanded to allow users to go into +> their package and "turn-on" the remaining non-primary services(using the +> primary account.) + take the GPL'ed whois proxy stuff at www.geektools.com and turn it into intelligence for Net::Whois. -- cgit v1.2.1 From 145eb4372ae27ef1b884a80666b70283eadfbaf8 Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 22 Sep 1999 22:06:34 +0000 Subject: ya todo update --- TODO | 61 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++- 1 file changed, 60 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index f7d95d697..1e4774e12 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.38 1999-08-27 06:25:56 ivan Exp $ +$Id: TODO,v 1.39 1999-09-22 22:06:34 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,65 @@ duplication of effort. --- +Your suggested script with back up /usr/local/etc/freeside, but will miss +any database not named `freeside'. Both of our scripts are specific to +MySQL. If you're interested in contributing to Freeside, maybe you could +work on a script which: reads the mapsecrets configuration file and then +each secrets file to find out what specific database engine(s) (MySQL, +PostgreSQL, etc.) and database(s) need to be backed up, then does so, +serializing backups of the same engine, i.e. stop mysql, do all the mysql +backups, start mysql, stop postgresql, do all the postgresql backups, +start postgresql, etc. +> #!/bin/sh +> apachectl stop +> mysqldump -t freeside > fs-backup.sql +> apachectl start +> tar -Pzcvf fs-backup-`date +%y%m%d%H%M%S`.tgz fs-backup.sql /usr/local/etc/freeside/ +> rm fs-backup.sql + +I chose to use counters in the filesystem because there is no standard way +to get the value of an auto-incrementing keyfield which is common across +all databases (as seen through DBI/DBD). +. +It certainly wouldn't be a bad idea to use the database-specific methods, +when available. + +htdocs/edit/svc_acct.cgi: +(Does the `*HIDDEN*' show up when you are adding a new account, and +specify the password, then receive an error and are returned to the form?) + +more DOC: +Thought some of you might be interested in this: + + has CyberCash compatibility modules for +Paymentnet and Authorizenet + which should allow you process transactions +using those services as well as CyberCash. + +The files are named CCLib.pm.paymentnet and CCLib.pm_authorizenet, +respectively, and are installed by renaming to CCLib.pm and moving to your +site_perl directory. Otherwise, follow the directions for Cybercash v2 in +htdocs/docs/config.html + +DOC: +fs_passwd/ is a client-server replacement for the `passwd', `chfn' and +`chsh' commands that updates the Freeside database. (so for that to be +useful, you'd have to be exporting that data periodically) + +fs_radlog/ is a client-server RADIUS log parser that stuffs the data into +SQL. It isn't finished, and probably won't be unless someone who I can't +convince to use one of the RADIUS daemons that logs to SQL directly pays +me money or something. + +fs_signup/ is a client-server signup server. i'm just finishing it up +now; probably isn't on your machine yet. + + +http://www.sisd.com/freeside/list-archive/msg00812.html + +package definitions should be implicit allow wrt agent types, not implicit deny +(with the old behavior possible via a config file) + > So is there anyway it could be setup to allow you to select a "primary > service" from each package? This service would be the one you were prompted > for. Could the signup server then be expanded to allow users to go into -- cgit v1.2.1 From 0c31694b965b242281d6970f517376b8ea9b2d58 Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 27 Jan 2000 00:27:50 +0000 Subject: update TODO --- TODO | 36 ++++++++++++++++++++++++++++++++++-- 1 file changed, 34 insertions(+), 2 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index 1e4774e12..b93c91650 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.39 1999-09-22 22:06:34 ivan Exp $ +$Id: TODO,v 1.40 2000-01-27 00:27:50 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,38 @@ duplication of effort. --- +There's no way to do this currently, though it would be pretty +straightforward to modify the source - specifically, the _collect_ +subroutine in FS::cust_main. +> +On Mon, Dec 13, 1999 at 04:05:32PM -0700, Jeff Garner wrote: +> Freeside will e-mail my users when they are billed if they are setup as +> billing. +> +> When setup by credit card it does not e-mail them. Is there a way to +> turn on e-mail invoices for those who are billed via credit card? Kind +> of like a recipt of billing.... + + +doc: http://www.softagency.co.jp/mysql/qmail.en.html + +sql1992.txt standard is 18 character column names. shoot for that, not just +32 (postgresql default) + +Also note that (AFAIK) Freeside won't display any package that has more +than one service on the "Add Customer" page. The reason for this is +because there's no way to dynamically alter the displayed html form +based on which package is selected. One possible solution would be to +make an additional page that's used in the signup process that would +display the form for each package, like a MS-style "Wizard". The first +page lets you select the package, then the second page has the custom +form with fields for each service in that package and a save button. Of +course, that would require a little perl work. +. +Later, +Scott Cruzen + + Your suggested script with back up /usr/local/etc/freeside, but will miss any database not named `freeside'. Both of our scripts are specific to MySQL. If you're interested in contributing to Freeside, maybe you could @@ -137,7 +169,7 @@ table should go away, along with the concept of a "default" domain. default setting for new packages should allow all agents to purchase them... with a config file for the old behaviour -replace Term::Query with Quiz::Question? +fix or replace Term::Query (Quiz::Question doesn't do what i need) Check config file reading stuff from CPAN -- cgit v1.2.1 From fe10321b9a9fa1025af12aeb61e7b08e9ba25cb2 Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 30 Jan 2000 06:11:09 +0000 Subject: . --- TODO | 42 +++++++++++++++++++++++++++--------------- 1 file changed, 27 insertions(+), 15 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index b93c91650..ae39d824e 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.40 2000-01-27 00:27:50 ivan Exp $ +$Id: TODO,v 1.41 2000-01-30 06:11:09 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,31 @@ duplication of effort. --- + + CVS via SSH (Score:1) + by platinum (jedgar at fxp dot org) on Thursday September 30, @07:13PM EDT (#4) + (User Info) http://www.fxp.org/~jedgar + The links above are your best bet for basic cvs server configuration. Once you have a pserver set up, you + may consider using cvs via ssh. All you need to do is the following: + + 1) Have ssh and sshd set up on the client and server machines + 2) Set CVSROOT="joe@example.com:/home/ncvs" + 3) Set CVS_RSH="/usr/local/bin/ssh" + 4) Use cvs normally + (Obviously, insert the proper host/paths above) + + You can also set up cvs/ssh to not need a password every time (similiar to an initial 'cvs login'): + + 1) run ssh-keygen on client machine using no passphrase. + 2) copy/add ~/.ssh/identity.pub on the client to ~/.ssh/authorized_keys on the server + (man ssh for more details) + + The main reason I mentio + CVS via SSH (Score:1) + by platinum (jedgar at fxp dot org) on Thursday September 30, @07:13PM EDT (#4) + (User Info) http://www.fxp.org/~jedgar + + There's no way to do this currently, though it would be pretty straightforward to modify the source - specifically, the _collect_ subroutine in FS::cust_main. @@ -291,20 +316,7 @@ that error because it didn't exist yet. Sounds like a buglet to me. I'll try to fix that soon; in the meantime you can add the invoicing email address afterwords. -Postgres `money' time sucks rocks anyway. I'll probably just require 6.5 -and use the numeric types, which *finally* work right. -On Sat, Apr 24, 1999 at 12:52:00PM -0700, Mr. Poet wrote: -> Software error: -> Error creating cust_bill record: ERROR: parser: -> attribute 'charged' is of type 'money' but expression -> is of type 'float8' You will need to rewrite or cast -> the expression ! Check updated but unbilled packages -> for customer1 -. -Postgres `money' time sucks rocks anyway. I'll probably just require 6.5 -and use the numeric types, which *finally* work right (well, according to -the web site, anyway). -. +(workaround for postgres before 6.5) (unlikely to ever be implemented) In the mean-time, this could probably be fixed with the reverse of the kludge in FS::Record::new. This removes `$' and `,' from money fields coming out of the database. Something which fixed up the data so Postgres -- cgit v1.2.1 From 236d0a0f93ffa2f7609f930c8af2c507741060ad Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 6 Mar 2000 14:12:57 +0000 Subject: ICRADIUS export support --- TODO | 40 +++++++++++++++++++++++++++++++++++++++- 1 file changed, 39 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index ae39d824e..19baa7228 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.41 2000-01-30 06:11:09 ivan Exp $ +$Id: TODO,v 1.42 2000-03-06 14:12:56 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,44 @@ duplication of effort. --- +more email which should make it into a more organized TODO list: +. +I would also love to see Freeside support bandwidth billing by reading the +Cisco NetFlow Accounting data so we and other ISP's could automatically bill +co-located servers and even potentially other virtually hosted sites like +MUD, Palace Chat, IRC Chat, etc based on the bandwidth they use or average +sustained rates or whatever. I'm not much of a programmer so I don't know +what all this entails but I did download a NetFlow client agent/whatever for +Linux though. + . +It would also be nice to see Freeside be able to read Apache log files and +bill customers for web traffic that way as an option also. Plus an option to +bill for excessive disk usage without having to use quotas if you didn't +want to, would be a nice feature as well. So you could monitor with a script +or something to see how much disk space a user was using then get some +average and charge a certain amount for anything above some preset limit for +that account type. I might be able to hack something like this up, but I'm +not 100% sure where to start or if there is something out there that could +be modified or not. +. +Do you think that you will ever support the HKS CCVS (Hell's Kitchen +Software Credit Card Verification Software) since Red Hat bought them out +and is going to be including that for credit card processing when you buy +the professional version? What about possibly supporting the OpenCCVS which +is a GNU/GPL version of a credit card program? I haven't had time to comb +through the Freeside code to see how hard it would be to add support for +these as externally called programs. +. +Also any thoughts on help desk, and knowledge base stuff? Any thoughts on +this stuff, and how possible and what kinds of work or time frame would be +involved? +. +Tim Jung +System Admin +Internet Gateway Inc. +tjung@igateway.net + + CVS via SSH (Score:1) by platinum (jedgar at fxp dot org) on Thursday September 30, @07:13PM EDT (#4) -- cgit v1.2.1 From 62a808f08c065aa5a29fb9cbf6b7108fe4cb8d15 Mon Sep 17 00:00:00 2001 From: ivan Date: Sat, 13 May 2000 21:57:56 +0000 Subject: add print_batch script from Joel Griffiths --- TODO | 68 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++---- 1 file changed, 64 insertions(+), 4 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index 19baa7228..f3fc919ea 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.42 2000-03-06 14:12:56 ivan Exp $ +$Id: TODO,v 1.43 2000-05-13 21:57:56 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,67 @@ duplication of effort. --- +pro-rating, fiddling dates + +It looks like svc_acct.import doesn't deal well with comments and +multi-attribute lines. + +ivan@rootwood:~/freeside_current$ rgrep -r domuid * | cut -d: -f1 | sort | +uniq +CVS/Base/TODO +TODO +bin/fs-setup +bin/svc_acct_sm.export +bin/svc_acct_sm.import +htdocs/docs/man/svc_acct_sm.txt +htdocs/docs/schema.html +htdocs/edit/CVS/Base/part_svc.cgi +htdocs/edit/part_svc.cgi +htdocs/edit/process/svc_acct_sm.cgi +htdocs/edit/svc_acct_sm.cgi +htdocs/search/svc_acct_sm.cgi +htdocs/view/svc_acct_sm.cgi +site_perl/svc_acct_sm.pm + +rootwood:COMPLETEHOST/TODO + +Currently, you set a value in the %FS::UID::callback hash with a coderef +of the code you want to execute, but this was bad design and will shortly +be changed to a subroutine to which you pass your coderef to register it. + +This is not a bug, it is how the system is currently designed. After +defining a new package, you need to specifically allow agent types to +purchase packages. You can do this from the edit screen of the new agent +type. +. +It wouldn't be a bad idea to add a configuration value that makes new +packages available for all currently existing agent types automatically. +. +On Fri, Apr 07, 2000 at 10:50:35AM -0500, David Morton wrote: +> For some reason, the type_pkgs table didn't get updated when I tried to +> create a domain service and package... insert into type_pkgs values +> (4,1); fixed it up so that I could actually order the package. + + +From: Chuck Cochems +. +1) automated generating of late notices. So far the only way I know to +generate one is to re-invoice manually. +. +2) smart credit card rejection handling. It should e-mail a note at +least, explainig that it did't go through, and why. +. +3)coment field in the main customer record. +. +4) streamlined payment entry feature. the current scheme has it fairly +buried. +. +5) queries to show al customers who owe money,and such stuff as that. + + +credits aren't counted against past invoices? hmm. something needs to be +done to "apply payment" genericly. and zero out invoices etc. + more email which should make it into a more organized TODO list: . I would also love to see Freeside support bandwidth billing by reading the @@ -176,10 +237,9 @@ in real-time instead of exporting periodically. See . these go in docs: -, and - + (was 546), and -and http://www.sisd.com/freeside/list-archive/msg00423.html +and http://www.sisd.com/freeside/list-archive/msg00421.html (was 423) > > 5: Is there anyway to get freeside to send a sysadmin a warning when a > > credit card has expired? -- cgit v1.2.1 From 387f0b6a7ab855203fa88c08d1cb85ccb976e526 Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 15 Jun 2000 14:45:38 +0000 Subject: text updates --- TODO | 25 ++++++++++++++++++++++++- 1 file changed, 24 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index f3fc919ea..aaa90d452 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.43 2000-05-13 21:57:56 ivan Exp $ +$Id: TODO,v 1.44 2000-06-15 14:45:38 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,29 @@ duplication of effort. --- +update the cybercash links in config.html and in the homepage. add more explicit support for other payment types. etc. + +From "Tim Jung" +. +Automatic CC Decline Notices via email +Block Time billing for prepaid internet cards (400 hours or whatever block +time of hours) +Trouble Ticket System with simple search function for Knowledge Base feature +Employee Timecards +Credit Card System support for Red Hat's CCVS, and other Linux credit card +programs +Contact Manager/Lead Tracking +Pre-Sale Quotes +Cisco NetFlow Account for IP traffic billing +VoIP and FoIP billing +Roaming per minute billing based on Radius Proxy support or number they +dialed into from Radius logs (800# etc) +Support for OpenSRS Domain Registration +Support for TUCOWS signup CDs + + +dbdef-create for postgres + pro-rating, fiddling dates It looks like svc_acct.import doesn't deal well with comments and -- cgit v1.2.1 From b4a403644cb80a612dd028882f971bdd20839275 Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 23 Jun 2000 12:25:59 +0000 Subject: FS::Record::qsearch - more portable, doesn't depend on $sth->execute returning a number of rows, uses placeholders and prepare_cached --- TODO | 8 +++----- 1 file changed, 3 insertions(+), 5 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index aaa90d452..5478707ef 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.44 2000-06-15 14:45:38 ivan Exp $ +$Id: TODO,v 1.45 2000-06-23 12:25:59 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -445,8 +445,8 @@ was happy with it could go in FS::Record::_quote, for data going into the database. our data display problem might be a Freeside problem wrt not using -Oracle-compatible DBI syntax (uses the return value from $sth->execute as -a number of rows). Fixing this is on the TODO. +Oracle-compatible DBI syntax (fixed using the return value from $sth->execute +as a number of rows - something else?). hooks for arbitrary commands out of configuration files svc_acct.pm svc_acct_sm.pm etc. @@ -575,8 +575,6 @@ the web interface in general needs to be redone in a more abstract way. false laziness: some of search/svc_acct_sm.cgi was copied to search/svc_domain.cgi. but web interface in general needs to be rewritten in a mucho cleaner way. -Portability: in FS::Record, $sth->execute does not return a number of rows for all DBD's. see man DBI - subroutine the where clause (eventually all SQL) as OO perhaps (has anyone done this?) add a select method to FS::Record? -- cgit v1.2.1 From 2ba21fef7cc361ccd58045d490d36dab8f25a892 Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 27 Jun 2000 12:15:50 +0000 Subject: i18n --- TODO | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 5478707ef..0e5c89bb9 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.45 2000-06-23 12:25:59 ivan Exp $ +$Id: TODO,v 1.46 2000-06-27 12:15:50 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,11 @@ duplication of effort. --- +zip code i18n is not very good :( but at least US, CA, HU, ? + +ut_phonen doesn't check data length. several +orthogonal cleanup projects here. *sigh* + update the cybercash links in config.html and in the homepage. add more explicit support for other payment types. etc. From "Tim Jung" -- cgit v1.2.1 From bd26886dfcdb71027f0a3393993df383e72475b5 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 3 Jul 2000 09:03:14 +0000 Subject: added sendmailrestart and sendmailconfigpath config files --- TODO | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 0e5c89bb9..0d16f157a 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.46 2000-06-27 12:15:50 ivan Exp $ +$Id: TODO,v 1.47 2000-07-03 09:03:14 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,9 @@ duplication of effort. --- +Bug: during the linking process apparantly you can link too many services to +a package. *sigh* + zip code i18n is not very good :( but at least US, CA, HU, ? ut_phonen doesn't check data length. several -- cgit v1.2.1 From 61fc4e61c6644d2e0abdffe8cbdfafd4b092e84b Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 6 Jul 2000 08:57:28 +0000 Subject: support for radius check attributes (except importing). poorly documented. --- TODO | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 0d16f157a..99c0b2690 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.47 2000-07-03 09:03:14 ivan Exp $ +$Id: TODO,v 1.48 2000-07-06 08:57:27 ivan Exp $ If you are interested in helping with any of these, please join the mailing list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid @@ -6,6 +6,10 @@ duplication of effort. --- +hmm - if you delete an account in svc_acct somehow that a mail alias points to, +svc_acct_sm.export will fail. make sure this can't be done using +the web interface. + Bug: during the linking process apparantly you can link too many services to a package. *sigh* -- cgit v1.2.1 From ec9e52e13c2fa488e190db6ce2cacfcf3f978676 Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 9 Aug 2000 11:30:41 +0000 Subject: templatable invoices --- TODO | 61 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++---- 1 file changed, 57 insertions(+), 4 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index 99c0b2690..f95014bfc 100644 --- a/TODO +++ b/TODO @@ -1,11 +1,64 @@ -$Id: TODO,v 1.48 2000-07-06 08:57:27 ivan Exp $ +$Id: TODO,v 1.49 2000-08-09 11:30:40 ivan Exp $ -If you are interested in helping with any of these, please join the mailing -list (send a blank message to ivan-freeside-subscribe@sisd.com) to avoid -duplication of effort. +If you are interested in helping with any of these, please join the +*development* mailing list (send a blank message to +ivan-freeside-devel-subscribe@sisd.com) to avoid duplication of effort. --- +http://www.ipmeter.com/ integration would be useful + +http://tangram.sourceforge.net/ +Tie::DBI + +mmm, http://pootpoot.com/~dlowe/DBIx-Table/ + +The cybercash links in htdocs/docs/config.html are b0rken. + +Yes. Which is what I've been trying to tell you. (destination user, +destination domainname) would be represented by the svcnum of a record in +svc_acct. (In retrospect, using the uid instead of the svcnum was a bad +choice). (domuser, domain name) would be part of the svc_acct_sm record, +as domuser and domsvc. +. +Upon further consideration, I'll probably eliminate the svc_acct_sm table +completely, and just add a field for the svcnum of a domain and the svcnum +of a destination mailbox to svc_acct (or perhaps a one-to-many +relationship - multiple svcnum(s) for multiple destination mailboxes. +hmm.) + +> > > > Longer-term, I need to do something about the length of the +> > > > column names - +> > > > The SQL1992 standard defines 18 character column names, +> > > > which would be a +> > > > reasonable goal. +> > > +> > > Maybe the thing to do would be to separate these out to separate +> > > tables. +> > > then we could simply use something like id, attrib_name, +> > attrib_value +> > > to +> > > store all of the radius values. +> > +> > Hmm, no, that's not quite right. You don't want to store the actual +> > strings in the records for each account. Probably need a table that +> > corresponds to the RADIUS dictionary file, with a list of +> > attributes and +> > attribute id's, then reference the attribute by id and not name. +> > +> > The more difficult bit is handling the service definitions +> > correctly - +> > part_svc and it's effects. +> +> Yes that could be a bit tricky. Perhaps just one "radius" field in +> part_svc that held a list of id's from the radius table that applied +> that particular service? +. +No, that wouldn't let you set defaults or fixed values for each attribute, +like part_svc currently does. + + + hmm - if you delete an account in svc_acct somehow that a mail alias points to, svc_acct_sm.export will fail. make sure this can't be done using the web interface. -- cgit v1.2.1 From f01fe96a27912381d4b30ccad3d355d74f76f505 Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 24 Aug 2000 07:26:50 +0000 Subject: untaint template source --- TODO | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index f95014bfc..7241c49cd 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.49 2000-08-09 11:30:40 ivan Exp $ +$Id: TODO,v 1.50 2000-08-24 07:26:50 ivan Exp $ If you are interested in helping with any of these, please join the *development* mailing list (send a blank message to @@ -6,6 +6,9 @@ ivan-freeside-devel-subscribe@sisd.com) to avoid duplication of effort. --- +"first package" and email invoice (?) not sticky on errors in new/edit customer +screen. + http://www.ipmeter.com/ integration would be useful http://tangram.sourceforge.net/ -- cgit v1.2.1 From bf2ad8bc2e8ed387f50ec1993da46ca234e8a423 Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 15 Oct 2000 12:58:25 +0000 Subject: roo --- TODO | 30 +++++++++++++++++++++++++++++- 1 file changed, 29 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 7241c49cd..d6fa5678f 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.50 2000-08-24 07:26:50 ivan Exp $ +$Id: TODO,v 1.51 2000-10-15 12:58:25 ivan Exp $ If you are interested in helping with any of these, please join the *development* mailing list (send a blank message to @@ -6,6 +6,34 @@ ivan-freeside-devel-subscribe@sisd.com) to avoid duplication of effort. --- +this is awfully vauge, perhaps email for more info? don't want to alientate +someone with accounting experience, but i just don't have time right now. +. +Hi Ivan, +. +Thanks for the information. It took me a little while to figure it out, but I ++was +able to create an invoice. As a lamer and an accountant, may I make a few +suggestions? +. +On the Customer view page: +1) Layout the information in the manner the invoicing process is conducted. + a) Customer information + b) Package Ordering + c) Add a "Create & Edit Invoice" section - this allows auditing of the +invoice before it is processed. + d) then put the billing section to actually process the invoice + e) then put payment history information +. +Thanks, +Mark Roberts + + +new overdue code might be overzealous. test carefully. + +Port Freeside to use the modules that were abstracted from it: +Net::SSH, Net::SCP, DBIx::DataSource and DBIx::DBSchema, at least. + "first package" and email invoice (?) not sticky on errors in new/edit customer screen. -- cgit v1.2.1 From 52b07e8abd3946578a6c2701ec9e5195ec6b17e6 Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 27 Oct 2000 20:15:50 +0000 Subject: session monitor --- TODO | 20 +++++++++++++++++++- 1 file changed, 19 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index d6fa5678f..c6d7e4362 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.51 2000-10-15 12:58:25 ivan Exp $ +$Id: TODO,v 1.52 2000-10-27 20:15:50 ivan Exp $ If you are interested in helping with any of these, please join the *development* mailing list (send a blank message to @@ -6,6 +6,24 @@ ivan-freeside-devel-subscribe@sisd.com) to avoid duplication of effort. --- +> 1. A Web Form to the user get his account added automatically . The +> /etc/raddb/users and /etc/passwd would be updated automatically (these +> file are on the same machine Freeside is). I guess the the Add +> Customer +> page with some customization could be the work. +> 2. A Canceling Account Web Form available to user cancel his account +> at +> any time he wants. +> 3. A Password Changing Web Form where the user could change your +> password by sending your username, old and new password. +> 4. Additional POP Accounts Creation where the user supply only his +> main +> username/password (probably provided from a PPP Account already +> created) +> and his POP username/password for this specific account. +(actually need something more general i guess - probably need some way to say +which accounts (svc_acct) can log in and make changes per customer (cust_main) ) + this is awfully vauge, perhaps email for more info? don't want to alientate someone with accounting experience, but i just don't have time right now. . -- cgit v1.2.1 From b90f8cdac9371c219a72dda16f8deecc7c44fc28 Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 3 Dec 2000 20:25:20 +0000 Subject: session monitor updates --- TODO | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index c6d7e4362..4d0a0ba5f 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.52 2000-10-27 20:15:50 ivan Exp $ +$Id: TODO,v 1.53 2000-12-03 20:25:20 ivan Exp $ If you are interested in helping with any of these, please join the *development* mailing list (send a blank message to @@ -6,6 +6,8 @@ ivan-freeside-devel-subscribe@sisd.com) to avoid duplication of effort. --- +first package select field in edit/cust_main.cgi isn't sticky on errors, yuck + > 1. A Web Form to the user get his account added automatically . The > /etc/raddb/users and /etc/passwd would be updated automatically (these > file are on the same machine Freeside is). I guess the the Add -- cgit v1.2.1 From 95ff27e612e0357c6ec44036b30c77d16b173690 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 11 Dec 2000 01:10:15 +0000 Subject: ancient stuff out of my inbox --- TODO | 81 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++- 1 file changed, 80 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 4d0a0ba5f..84e57dce6 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.53 2000-12-03 20:25:20 ivan Exp $ +$Id: TODO,v 1.54 2000-12-11 01:10:15 ivan Exp $ If you are interested in helping with any of these, please join the *development* mailing list (send a blank message to @@ -6,6 +6,85 @@ ivan-freeside-devel-subscribe@sisd.com) to avoid duplication of effort. --- +wishlist wrt projects/consulting from jivko@ijs.com: +>The other thing, which is the serious part, is the following: We do not +>offer dial-up services and that part of the system does not have to work, +>but we have many customer, for which we do both hosting and consulting work. +. +>The hosting can be handled by freeside fine, but in the little time I spent +>on it I could not see how exactly to solve the consulting problem. What I +>would love to see there is a way to create 'projects' for each customer and +>ability to follow up on those (I mean to be able to add new comments, +>descriptions, progress updates etc.). You already have the feature, which +>allows multiple people to access the system with different access rights so +>it should be possible to make it keep track of who and when updated given +>'project' so we could have the developers access the database and update +>the projects they are working on. +. +Hmm. Is this accurate: Each project is related to a single customer, and +zero or more packages (billing items). Each project has a name, due date, +and zero or more log entries consisting of date, user, and a text field +(for "new comments, descriptions, progress updates etc." - would you like +anything more specific?) + +In conjunction with that it looks like you need the ability to create +"one-off" packages on the fly for arbitrary charges. + +> Additionally it would be nice to have a page, where all open projects can +> be listed and not only that but be able list them by date too. (Say I want +> to find out which projects are due today or two days from today, or which +> projects are running late) +. +Browse/search project by date and customer. +. +> Finally it would be real nice if the billing script could add the cost for +> all completed projects (or work done by the hour) to the monthly bill along +> with the hosting information and using the description of the work from the +> 'project' table. +. +Can you be more specific about your needs here? +. +> This is a lot of work, unless you disagree :-), and I would not expect you +> to do all of it - we can work on it too - but I would hope for you to lead +> the effort. +. +I'm trying to get a handle on specifically what you need. +. +> Oh, and there is one more thing, but that should be simple to do. I would +> like to be able to give the customers access to selected information from +> their account. I want them to be able to monitor the progress of their +> projects and the status of their accounts. +. +Ok. +. +> Does all this make sense? It must be close to what you need at your office +> though or at least I think so. +. +Yes, but we're small and have been tracking projects manually. +. +. +>You may have this already .. what I have in mind is the following. Say you +>have a customer for which you do hosting and some consulting (CGI, JAVA +>etc) At the end of the month you need to bill the customer for the hosting, +>35hours of Java programming and 10 hours of HTML authoring. The last two +>are not because the project is over but because the work was done during +>that month. +> +>So the way I see it, and it could be wrong, is that during the month the +>people who work on particular project enter their comments and time spent +>on the project. At the end of the month the billing script generates +>invoices in which besides the hosting charges there are also charges for +>work done during the period. +> +>Currently we do this in a very stupid way by maintaining a customer file, +>in which a script saves things to be invoiced. At the end of the month a +>script goes through these files and generates invoices with all items from +>the files, which have not been flagged as 'paid'. The convenience of this +>is that no one needs to worry about the invoices containing the items they +>need to contain. + + + first package select field in edit/cust_main.cgi isn't sticky on errors, yuck > 1. A Web Form to the user get his account added automatically . The -- cgit v1.2.1 From 8d5af30dc53cc6c74054b9fce94e45d90f2a48ed Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 11 Dec 2000 01:30:11 +0000 Subject: more ancient todo stuff from my inbox --- TODO | 15 ++++++++++++++- 1 file changed, 14 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 84e57dce6..a1d3bdaa4 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.54 2000-12-11 01:10:15 ivan Exp $ +$Id: TODO,v 1.55 2000-12-11 01:30:11 ivan Exp $ If you are interested in helping with any of these, please join the *development* mailing list (send a blank message to @@ -6,6 +6,19 @@ ivan-freeside-devel-subscribe@sisd.com) to avoid duplication of effort. --- +wishlist from drenalin@ultimanet.com: +* delete button for customers +- 15th of the month billing +- field for customer referrals (naming who it is) and automatically crediting ++that account +- ability to edit referrals +- catch expired credit cards and notify via email when they are expiring +* show passwords +- set default shell to /bin/false when adding ppp account +- import list of POPs from Megapop (see www.ultimanet.com and click on locations ++from text in index page) + + wishlist wrt projects/consulting from jivko@ijs.com: >The other thing, which is the serious part, is the following: We do not >offer dial-up services and that part of the system does not have to work, -- cgit v1.2.1 From 263a8097a88a1808e354cbd3062f21c91fe305c0 Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 26 Dec 2000 23:51:40 +0000 Subject: statedefault & referraldefault config files --- TODO | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index a1d3bdaa4..54a00a111 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.55 2000-12-11 01:30:11 ivan Exp $ +$Id: TODO,v 1.56 2000-12-26 23:51:40 ivan Exp $ If you are interested in helping with any of these, please join the *development* mailing list (send a blank message to @@ -6,6 +6,13 @@ ivan-freeside-devel-subscribe@sisd.com) to avoid duplication of effort. --- +Use this for email checking: +libemail-valid-perl - Check validity of Internet email addresses +. +This module determines whether an email address is well-formed, and +optionally, whether a mail host exists for the domain. + + wishlist from drenalin@ultimanet.com: * delete button for customers - 15th of the month billing -- cgit v1.2.1 From d746dfce2e320169ec8217cb09b9dbb0d403675d Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 31 Jan 2001 07:21:00 +0000 Subject: fix tyops --- TODO | 49 ++++++++++++++++++++++++++++++++++++++++++++++++- 1 file changed, 48 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 54a00a111..9c9de34ea 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.56 2000-12-26 23:51:40 ivan Exp $ +$Id: TODO,v 1.57 2001-01-31 07:21:00 ivan Exp $ If you are interested in helping with any of these, please join the *development* mailing list (send a blank message to @@ -6,6 +6,52 @@ ivan-freeside-devel-subscribe@sisd.com) to avoid duplication of effort. --- +(future templating) +. +(at least) These questions need to be answered for Mason, Apache::ASP and +eperl. If eperl becomes too much of a pain, I'm okay with forgetting +about it - it's not well-maintained. The answers below are for Mason. +. +How do you interpolate a value? <% $value %> +. +How do you interpolate a value without escaping HTML? <% $value |n %> +. +How do you interpolate a (possibly non-stand-alone, non-interpolated) +control structure? With an inital % - for example: +. + % for each $value ( @values ) { + + % } +. +This is one of the things I worry that the webmonkey HTML editors will not +like about Mason. That and the <%INIT> and <%PERL> tags. + + +in the context of a state machine (& MySQL and Pg locking) for LDAP export: +. +Also note that Pg locks are for the duration of the transaction, so +Freeside needs to start using transactions for this to happen. +FS::UID::adminsuidsetup should explicitly set AutoCommit false and export +some functions to begin and end transactions on $FS::UID::dbh. (Well, +eventually FS::UID should be an overloaded subclass of a DBI handle, but +we don't have to worry about that until perl threads + mod_perl + threaded +Apache 2.0 is stable, i.e. quite some time). + +Postfix +also supports virtual domains in a way that's somewhat similar (but not +compatible with) the way sendmail does. In the postfix world, all virtual +domain info is contained in one file (similar to the virtusertable), but +is formatted as such: +bar.com virtual +foo@bar.com some@other.net +quux@bar.com localuser1 +... +and so on. After the file is generated, it gets compiled into a hash db +using, "postmap /etc/postfix/virtual". + + +steal all the play-nice-with-cache stuff back from RT + Use this for email checking: libemail-valid-perl - Check validity of Internet email addresses . @@ -106,6 +152,7 @@ Yes, but we're small and have been tracking projects manually. first package select field in edit/cust_main.cgi isn't sticky on errors, yuck +(also referral isn't sticky either? yuck) > 1. A Web Form to the user get his account added automatically . The > /etc/raddb/users and /etc/passwd would be updated automatically (these -- cgit v1.2.1 From 0281069f3cd7f8caab7768cd818b088991b62117 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 9 Apr 2001 15:50:50 +0000 Subject: rar --- TODO | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 9c9de34ea..081c48149 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.57 2001-01-31 07:21:00 ivan Exp $ +$Id: TODO,v 1.58 2001-04-09 15:50:50 ivan Exp $ If you are interested in helping with any of these, please join the *development* mailing list (send a blank message to @@ -6,6 +6,8 @@ ivan-freeside-devel-subscribe@sisd.com) to avoid duplication of effort. --- +write some sample billing expressions with libcflow-perl :) + (future templating) . (at least) These questions need to be answered for Mason, Apache::ASP and -- cgit v1.2.1 From 15f65a0c56cbce6951d9cb4f71119725a2009f79 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 9 Apr 2001 23:05:16 +0000 Subject: Transactions Part I!!! --- TODO | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 081c48149..a9b3f64c1 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.58 2001-04-09 15:50:50 ivan Exp $ +$Id: TODO,v 1.59 2001-04-09 23:05:15 ivan Exp $ If you are interested in helping with any of these, please join the *development* mailing list (send a blank message to @@ -6,6 +6,9 @@ ivan-freeside-devel-subscribe@sisd.com) to avoid duplication of effort. --- +anything doing transactions in the web interface should likely move into *.pm. +(transactions are here woo!) + write some sample billing expressions with libcflow-perl :) (future templating) -- cgit v1.2.1 From 0bdd3c05c6a3664d7ed9a191ef8ae4ade2162109 Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 15 Apr 2001 10:33:40 +0000 Subject: better docs for the worst bit, finally --- TODO | 22 +++++++++++++++++++++- 1 file changed, 21 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index a9b3f64c1..308da8824 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.59 2001-04-09 23:05:15 ivan Exp $ +$Id: TODO,v 1.60 2001-04-15 10:33:40 ivan Exp $ If you are interested in helping with any of these, please join the *development* mailing list (send a blank message to @@ -6,6 +6,26 @@ ivan-freeside-devel-subscribe@sisd.com) to avoid duplication of effort. --- +******** +for 1.3.0: +******** + +move to DBIx::DBSchema. (gets non-MySQL-specific dbdef-create) + +finish transactions (svc_*.pm, fs_register/) + +Pg-style or universal-style locking in fs_sessmon FS/FS/nas.pm, or rewrite it +to use a database expression that won't need it, or just dump the locking +entirely as nas_heartbeat stuff doesn't need to be accurate; it's just informational. + +radius + +test with MySQL+Sleepycat? + +******** +unclassified, probably either done already or post-1.3.0 +******** + anything doing transactions in the web interface should likely move into *.pm. (transactions are here woo!) -- cgit v1.2.1 From 018f6678557506e68cc6b8643862143cc332f7da Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 15 Apr 2001 12:56:31 +0000 Subject: s/dbdef/DBIx::DBSchema/ --- TODO | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index 308da8824..d0276531c 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.60 2001-04-15 10:33:40 ivan Exp $ +$Id: TODO,v 1.61 2001-04-15 12:56:30 ivan Exp $ If you are interested in helping with any of these, please join the *development* mailing list (send a blank message to @@ -10,8 +10,6 @@ ivan-freeside-devel-subscribe@sisd.com) to avoid duplication of effort. for 1.3.0: ******** -move to DBIx::DBSchema. (gets non-MySQL-specific dbdef-create) - finish transactions (svc_*.pm, fs_register/) Pg-style or universal-style locking in fs_sessmon FS/FS/nas.pm, or rewrite it -- cgit v1.2.1 From ec50de2b78ef1796085f4949265fbe6bc0564086 Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 15 Apr 2001 13:56:54 +0000 Subject: *** empty log message *** --- TODO | 20 +------------------- 1 file changed, 1 insertion(+), 19 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index d0276531c..52b88fdce 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.61 2001-04-15 12:56:30 ivan Exp $ +$Id: TODO,v 1.62 2001-04-15 13:56:54 ivan Exp $ If you are interested in helping with any of these, please join the *development* mailing list (send a blank message to @@ -6,24 +6,6 @@ ivan-freeside-devel-subscribe@sisd.com) to avoid duplication of effort. --- -******** -for 1.3.0: -******** - -finish transactions (svc_*.pm, fs_register/) - -Pg-style or universal-style locking in fs_sessmon FS/FS/nas.pm, or rewrite it -to use a database expression that won't need it, or just dump the locking -entirely as nas_heartbeat stuff doesn't need to be accurate; it's just informational. - -radius - -test with MySQL+Sleepycat? - -******** -unclassified, probably either done already or post-1.3.0 -******** - anything doing transactions in the web interface should likely move into *.pm. (transactions are here woo!) -- cgit v1.2.1 From 35b2311e5702c32381a662b8172354603ea9ed1d Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 22 Apr 2001 01:38:39 +0000 Subject: svc_domain needs to import dbh sub from Record view/cust_main.cgi needs to use ->owed method, not check (depriciated) owed field search/cust_bill.cgi redirect error when there's only one invoice --- TODO | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 52b88fdce..593f4e989 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.62 2001-04-15 13:56:54 ivan Exp $ +$Id: TODO,v 1.63 2001-04-22 01:38:38 ivan Exp $ If you are interested in helping with any of these, please join the *development* mailing list (send a blank message to @@ -6,6 +6,11 @@ ivan-freeside-devel-subscribe@sisd.com) to avoid duplication of effort. --- +Things that would be nice but probably won't happen: testing with +MySQL+Sleepycat, a fix for the long-RADIUS-attributes-with Pg problem, +passive session monitoring with RADIUS (tailing a log file or monitoring a +database, as opposed to using a RADIUS with proper callbacks). + anything doing transactions in the web interface should likely move into *.pm. (transactions are here woo!) -- cgit v1.2.1 From 8c7bd747b39f0fec96689236f4bc879cf4171360 Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 3 Jun 2001 14:15:52 +0000 Subject: yes yes --- TODO | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index 593f4e989..eb18860b3 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.63 2001-04-22 01:38:38 ivan Exp $ +$Id: TODO,v 1.64 2001-06-03 14:15:52 ivan Exp $ If you are interested in helping with any of these, please join the *development* mailing list (send a blank message to @@ -6,6 +6,15 @@ ivan-freeside-devel-subscribe@sisd.com) to avoid duplication of effort. --- +"Andrew Wafula" : +> Following my recent questions on money_char, i would like to suggest that +> money_char be used as well in cust_bill.cgi and cust_main.cgi so that the +> charges are seen in whatever money_char is used in a particular country +> instead of the default dollar currecny. This would make it such that the +> system has one monetary unit in its entirety rather than only for the +> invoicing part. I guess this would be something others would appreciate as +> well. + Things that would be nice but probably won't happen: testing with MySQL+Sleepycat, a fix for the long-RADIUS-attributes-with Pg problem, passive session monitoring with RADIUS (tailing a log file or monitoring a -- cgit v1.2.1 From 44c6304b150b8c68cf6e40976a60b761ec19451c Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 6 Jun 2001 22:22:13 +0000 Subject: templating thoughts --- TODO | 21 ++++++++++++++++++++- 1 file changed, 20 insertions(+), 1 deletion(-) (limited to 'TODO') diff --git a/TODO b/TODO index eb18860b3..6f29f2262 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.64 2001-06-03 14:15:52 ivan Exp $ +$Id: TODO,v 1.65 2001-06-06 22:22:13 ivan Exp $ If you are interested in helping with any of these, please join the *development* mailing list (send a blank message to @@ -6,6 +6,25 @@ ivan-freeside-devel-subscribe@sisd.com) to avoid duplication of effort. --- +random templating thoughts: +for starters, read the "Template Syntax" section of Text::Template +that sums up the starting philosophy pretty well +> Text::Template is unsuitable because it's backwards, but don't worry about ++that quite yet. everything in that section applies +.. +then ttp://forum.swarthmore.edu/epigone/modperl/frahthonbror/19990525144012.8806.qmail@plover.com +.. +then: given that as background, freside will use a simple template syntax designed ++to interact well with the webmonkey html editors, and will export to Mason ++and Apache::ASP for starters, and eventually any "right-side-out" "eval" ++templating system + + +make svc_acct.import complain if you try to use a local file + +make the invoices configurable such that: +> Also, Can you change FreeSide so that it says "GST" instead of TAX? + "Andrew Wafula" : > Following my recent questions on money_char, i would like to suggest that > money_char be used as well in cust_bill.cgi and cust_main.cgi so that the -- cgit v1.2.1 From 3ce08c3b7960b2ade75126885186dd6bcfea3c9b Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 30 Jul 2001 07:13:34 +0000 Subject: todocruft --- TODO | 26 +++++++++++++++++++++----- 1 file changed, 21 insertions(+), 5 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index 6f29f2262..f9e685528 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.65 2001-06-06 22:22:13 ivan Exp $ +$Id: TODO,v 1.66 2001-07-30 07:13:34 ivan Exp $ If you are interested in helping with any of these, please join the *development* mailing list (send a blank message to @@ -6,6 +6,13 @@ ivan-freeside-devel-subscribe@sisd.com) to avoid duplication of effort. --- +> Does Freeside currently support notification to the customer that their +> credit card on file is about to expire? +> What about notification that their +> credit card was declined after they sign up, say like in 5 months when it +> fails? + + random templating thoughts: for starters, read the "Template Syntax" section of Text::Template that sums up the starting philosophy pretty well @@ -48,18 +55,27 @@ write some sample billing expressions with libcflow-perl :) . (at least) These questions need to be answered for Mason, Apache::ASP and eperl. If eperl becomes too much of a pain, I'm okay with forgetting -about it - it's not well-maintained. The answers below are for Mason. +about it - it's not well-maintained. . -How do you interpolate a value? <% $value %> +How do you interpolate a value? +mason: <% $value %> +apache-asp(don't think there is a "with-escaping-HTML" way?): <%= $value %> . -How do you interpolate a value without escaping HTML? <% $value |n %> +How do you interpolate a value without escaping HTML? +mason: <% $value |n %> +apache-asp??: <%= $value %> . How do you interpolate a (possibly non-stand-alone, non-interpolated) control structure? With an inital % - for example: . - % for each $value ( @values ) { +mason: + % foreach $value ( @values ) { % } +apache-asp: + <% foreach $value ( @values ) { %> + + <% } %> . This is one of the things I worry that the webmonkey HTML editors will not like about Mason. That and the <%INIT> and <%PERL> tags. -- cgit v1.2.1 From 7ab7ab8ce4ce69456224fc70043b83d4fd2ace97 Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 19 Aug 2001 09:08:18 +0000 Subject: this is what i fed to RT, might as well check it in. no further modifications to TODO. everything is in the ticketing system now. --- TODO | 100 ++++++++++++++++++++++++++++++++++++++++++++++++++----------------- 1 file changed, 75 insertions(+), 25 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index f9e685528..6aee3e790 100644 --- a/TODO +++ b/TODO @@ -1,4 +1,4 @@ -$Id: TODO,v 1.66 2001-07-30 07:13:34 ivan Exp $ +$Id: TODO,v 1.67 2001-08-19 09:08:18 ivan Exp $ If you are interested in helping with any of these, please join the *development* mailing list (send a blank message to @@ -6,6 +6,58 @@ ivan-freeside-devel-subscribe@sisd.com) to avoid duplication of effort. --- +Does Freeside currently support notification to the customer that their +credit card on file is about to expire? What about notification that their +credit card was declined after they sign up, say like in 5 months when it +fails? If not are these options being planned to be added in the next +release? I think they would be nice options to see Freeside support. +. +Tim Jung +System Admin +Internet Gateway Inc. +tjung@igateway.net + +deleting an account doesn't remove any references to it in cust_main_invoice. +it should, or error perhaps? ("this account is used as an invoice destination, +remove that first?") or the cust_main_invoice should be changed to literal. +it'll bounce, but that seems reasonable... + +also cust_main_invoice uses `mydomain' in a way that will have to be changed +when jeff's branch merges + +> I can't use the built in agent mechanism to do ACLs for things like +> suspension and cancellation, but I can use it for selecting which +> package types the marketing types are allowed to sign up. Problem is, +> I can't seem to figure out the rules as to how cust_main.cgi figures +> out which packages to stick in the list of packages available for new +> customers. +. +Currently, only packages with a single service with table `svc_acct' +appear on the `New Customer' screen. Other packages may be ordered from +the `Order and cancel packages' link on the main `Customer View' screen. +. +Perhaps the `New Customer' UI could be changed like the new `Service Edit' +screen in CVS, to support all available packages, not just those with a +single service with table `svc_acct'. + +> +---------- +> | Thank you for the response.That being the case do you have any +> | recommendations as to the most effective way to add prior balances? +> +---------- +> +> You could create a package called 'Starting Balance' and sell it +> to them. Adjust the price as neccessary. +. +Yes, this is what to do with the current system. +. +In the future, this is what the database would do internally, but +eventually I'd like the user-interface and the Perl API to offer a +one-step way to "add a starting balance" that does this underneath. +. +I'm also thinking it might be necessary for accouting reasons to add a +flag to these charges and payments against them, so you can run totals and +reports ignoring them. Not sure about this. + > Does Freeside currently support notification to the customer that their > credit card on file is about to expire? > What about notification that their @@ -530,12 +582,12 @@ specify the password, then receive an error and are returned to the form?) more DOC: Thought some of you might be interested in this: - +. has CyberCash compatibility modules for Paymentnet and Authorizenet which should allow you process transactions using those services as well as CyberCash. - +. The files are named CCLib.pm.paymentnet and CCLib.pm_authorizenet, respectively, and are installed by renaming to CCLib.pm and moving to your site_perl directory. Otherwise, follow the directions for Cybercash v2 in @@ -658,7 +710,7 @@ statement! this if you are using it. > 2. can customers view their bills on-line. - +. Not yet; it needs to be proxied from Freeside to a customer web server in a secure way using something not completely unlike the fs_passwd, fs_passwdd, fs_passwd_server trio. @@ -666,10 +718,10 @@ fs_passwdd, fs_passwd_server trio. > Lastly, if someone over pays on an invoice, the credit part does not flow > over to other invoices.. - +. The total balance flows over correctly, but individual payments don't. The code you're looking for is in FS::cust_pay::insert - +. The question of what to do with overpayments that don't have another invoice to flow into (yet.. or possibly not) is still an open one. The legacy system Freeside replaced long ago had a separate place for this @@ -688,7 +740,7 @@ warn or complain or something when invoice_from is empty (and we use it) Right now Freeside uses the `freq' field of a package definition as a number of months. The specific section of code you're looking for is in FS::cust_main::bill: - +. #change this bit to use Date::Manip? #$sdate=$cust_pkg->bill || time; #$sdate=$cust_pkg->bill || $time; @@ -700,10 +752,10 @@ FS::cust_main::bill: $cust_pkg->setfield('bill', timelocal($sec,$min,$hour,$mday,$mon,$year)); $cust_pkg_mod_flag = 1; - +. ..and when I went poking for this, looks like it tells us just what needs to be done! Hehehe... - +. Date::Manip can handle cool things like "+ 1 month" (actually the current case of /^(\d+)$/ would have to be added as a special case of "+ $1 month") and "+ 30 days" (what you need) and even "+ 5 business days" ! @@ -714,7 +766,7 @@ On Wed, Apr 28, 1999 at 08:38:16PM +0000, Kristian Hoffmann wrote: > understand, when you run svc_acct.export, it rewrites the /etc/passwd, > /etc/shadow, etc. files. Is this only for initial setups with the > export hooks being in the pm's? - +. You can use both, or just one method. The configuration files control this. One of the things in the TODO is to take out the last few things that aren't customizable wrt this and put them in config files. @@ -768,8 +820,6 @@ hooks for arbitrary commands out of configuration files svc_acct.pm svc_acct_sm.pm etc. Add this to a FAQ, along with doing it for middle names: - - > What I'm finding difficult is how to easily > customize fields. For example, I am trying to add a "middle name" field > to the Customer Edit, view, etc. If I'm going about it right, it appears @@ -783,7 +833,7 @@ You have the basic idea. To implement that completely, I would: - Document the change in a new file, htdocs/docs/upgrade4.html * Run bin/dbdef-create * Add the new field to edit/cust_main.cgi and edit/process/cust_main.cgi - +. For bonus points, I'd grep around for the various bits which use "$first $last" or "$last, $first" and replace them with a method call in cust_main.pm, , like search/cust_main.cgi @@ -1281,23 +1331,23 @@ lease... probably doesn't make a difference in the ordering... but if you cancel a router lease the inventory should come back. hmm.) -- Matt's wishlist --- - +. From matt@michweb.net Fri Feb 20 16:39:53 1998 Date: Thu, 19 Feb 1998 23:20:11 -0500 From: Matt Simerson Reply-To: quadran-developer@netgoth.com To: quadran-developer@netgoth.com Subject: Re: Welcome to quadran-developer - +. >Whats it based on and what is it supposed to do? I'm interested, but >unfortunatly, I don't have that much time to help on the project (I'm busily >working on one of my own based around MySQL and Qt right now -- don't know >if it will be GPL'ed or not yet -- we'll probably just use it in house since >it is designed around our system)... - +. That's what I set out to find, but didn't find anything on the web site. I'm looking for something that will do the following: - +. Single point of entry for users on a secure system: Creates account on user (public) systems update /etc/passwd/master.passwd file @@ -1307,7 +1357,7 @@ Single point of entry for users on a secure system: Export of new user info to customizable report (for automated entry into accounting software, etc...) - +. Automated billing: Export credit card info for batch processing and have hooks built in for other forms of electronic processing. @@ -1316,13 +1366,13 @@ Automated billing: software Email or laser print invoices Sanity checks credit card numbers before processing (code available) - +. Simple method for disabling an account. Arbitrary Expiration Dates (on a given day, in x days) Remove from radius. Changing password to '*' Virtual customers disabling dns, http server, log processing, etc.. - +. Billing for different account types: Dialup monthly flat rate. Prorates for partial months. Dialup monthly flat rate for x hours + hourly usage. @@ -1333,17 +1383,17 @@ Billing for different account types: Disk space used over quota. Tech support minimum + hourly charges Other for misc stuff (modem, RAM, etc...) - +. Per user definable RADIUS attributes (ties in with above) Fixed IP Simultaneous Use IP filters (for dialup email only) - +. Keep logs of modem usage generated daily from radius accounting logs stored on multiple radius servers. - +. Keep logs of disk usage generated from quota. - +. Method of adding virtual domains to your system: Automatically grabs an IP address from a preassigned pool. Creates a domain.com database file from database fields @@ -1363,7 +1413,7 @@ system...in bash. Shouldn't be hard for a perlmeister to convert. In fact, as long as all the info was stored in the database (username, domain name, and ip pool) this could easily just be run as an external script that the user tweaks to match his system. - +. We use a great accounting software (M.Y.O.B) that does all the AP, AR, Payroll, Tax stuff, and most everything else we could need. It's already set up for the type of checks we have, etc, etc... I just need something to -- cgit v1.2.1 From 2be8d274de7dd4a600b2500cb36ca4272bfc0efa Mon Sep 17 00:00:00 2001 From: ivan Date: Sat, 16 Feb 2002 18:14:23 +0000 Subject: now in RT2! --- TODO | 1423 +----------------------------------------------------------------- 1 file changed, 4 insertions(+), 1419 deletions(-) (limited to 'TODO') diff --git a/TODO b/TODO index 6aee3e790..4c582c9d7 100644 --- a/TODO +++ b/TODO @@ -1,1424 +1,9 @@ -$Id: TODO,v 1.67 2001-08-19 09:08:18 ivan Exp $ +$Id: TODO,v 1.68 2002-02-16 18:14:23 ivan Exp $ + +The TODO list / bug-tracking is now kept in a database. See +http://pouncequick.420.am/rt/ If you are interested in helping with any of these, please join the *development* mailing list (send a blank message to ivan-freeside-devel-subscribe@sisd.com) to avoid duplication of effort. ---- - -Does Freeside currently support notification to the customer that their -credit card on file is about to expire? What about notification that their -credit card was declined after they sign up, say like in 5 months when it -fails? If not are these options being planned to be added in the next -release? I think they would be nice options to see Freeside support. -. -Tim Jung -System Admin -Internet Gateway Inc. -tjung@igateway.net - -deleting an account doesn't remove any references to it in cust_main_invoice. -it should, or error perhaps? ("this account is used as an invoice destination, -remove that first?") or the cust_main_invoice should be changed to literal. -it'll bounce, but that seems reasonable... - -also cust_main_invoice uses `mydomain' in a way that will have to be changed -when jeff's branch merges - -> I can't use the built in agent mechanism to do ACLs for things like -> suspension and cancellation, but I can use it for selecting which -> package types the marketing types are allowed to sign up. Problem is, -> I can't seem to figure out the rules as to how cust_main.cgi figures -> out which packages to stick in the list of packages available for new -> customers. -. -Currently, only packages with a single service with table `svc_acct' -appear on the `New Customer' screen. Other packages may be ordered from -the `Order and cancel packages' link on the main `Customer View' screen. -. -Perhaps the `New Customer' UI could be changed like the new `Service Edit' -screen in CVS, to support all available packages, not just those with a -single service with table `svc_acct'. - -> +---------- -> | Thank you for the response.That being the case do you have any -> | recommendations as to the most effective way to add prior balances? -> +---------- -> -> You could create a package called 'Starting Balance' and sell it -> to them. Adjust the price as neccessary. -. -Yes, this is what to do with the current system. -. -In the future, this is what the database would do internally, but -eventually I'd like the user-interface and the Perl API to offer a -one-step way to "add a starting balance" that does this underneath. -. -I'm also thinking it might be necessary for accouting reasons to add a -flag to these charges and payments against them, so you can run totals and -reports ignoring them. Not sure about this. - -> Does Freeside currently support notification to the customer that their -> credit card on file is about to expire? -> What about notification that their -> credit card was declined after they sign up, say like in 5 months when it -> fails? - - -random templating thoughts: -for starters, read the "Template Syntax" section of Text::Template -that sums up the starting philosophy pretty well -> Text::Template is unsuitable because it's backwards, but don't worry about -+that quite yet. everything in that section applies -.. -then ttp://forum.swarthmore.edu/epigone/modperl/frahthonbror/19990525144012.8806.qmail@plover.com -.. -then: given that as background, freside will use a simple template syntax designed -+to interact well with the webmonkey html editors, and will export to Mason -+and Apache::ASP for starters, and eventually any "right-side-out" "eval" -+templating system - - -make svc_acct.import complain if you try to use a local file - -make the invoices configurable such that: -> Also, Can you change FreeSide so that it says "GST" instead of TAX? - -"Andrew Wafula" : -> Following my recent questions on money_char, i would like to suggest that -> money_char be used as well in cust_bill.cgi and cust_main.cgi so that the -> charges are seen in whatever money_char is used in a particular country -> instead of the default dollar currecny. This would make it such that the -> system has one monetary unit in its entirety rather than only for the -> invoicing part. I guess this would be something others would appreciate as -> well. - -Things that would be nice but probably won't happen: testing with -MySQL+Sleepycat, a fix for the long-RADIUS-attributes-with Pg problem, -passive session monitoring with RADIUS (tailing a log file or monitoring a -database, as opposed to using a RADIUS with proper callbacks). - -anything doing transactions in the web interface should likely move into *.pm. -(transactions are here woo!) - -write some sample billing expressions with libcflow-perl :) - -(future templating) -. -(at least) These questions need to be answered for Mason, Apache::ASP and -eperl. If eperl becomes too much of a pain, I'm okay with forgetting -about it - it's not well-maintained. -. -How do you interpolate a value? -mason: <% $value %> -apache-asp(don't think there is a "with-escaping-HTML" way?): <%= $value %> -. -How do you interpolate a value without escaping HTML? -mason: <% $value |n %> -apache-asp??: <%= $value %> -. -How do you interpolate a (possibly non-stand-alone, non-interpolated) -control structure? With an inital % - for example: -. -mason: - % foreach $value ( @values ) { - - % } -apache-asp: - <% foreach $value ( @values ) { %> - - <% } %> -. -This is one of the things I worry that the webmonkey HTML editors will not -like about Mason. That and the <%INIT> and <%PERL> tags. - - -in the context of a state machine (& MySQL and Pg locking) for LDAP export: -. -Also note that Pg locks are for the duration of the transaction, so -Freeside needs to start using transactions for this to happen. -FS::UID::adminsuidsetup should explicitly set AutoCommit false and export -some functions to begin and end transactions on $FS::UID::dbh. (Well, -eventually FS::UID should be an overloaded subclass of a DBI handle, but -we don't have to worry about that until perl threads + mod_perl + threaded -Apache 2.0 is stable, i.e. quite some time). - -Postfix -also supports virtual domains in a way that's somewhat similar (but not -compatible with) the way sendmail does. In the postfix world, all virtual -domain info is contained in one file (similar to the virtusertable), but -is formatted as such: -bar.com virtual -foo@bar.com some@other.net -quux@bar.com localuser1 -... -and so on. After the file is generated, it gets compiled into a hash db -using, "postmap /etc/postfix/virtual". - - -steal all the play-nice-with-cache stuff back from RT - -Use this for email checking: -libemail-valid-perl - Check validity of Internet email addresses -. -This module determines whether an email address is well-formed, and -optionally, whether a mail host exists for the domain. - - -wishlist from drenalin@ultimanet.com: -* delete button for customers -- 15th of the month billing -- field for customer referrals (naming who it is) and automatically crediting -+that account -- ability to edit referrals -- catch expired credit cards and notify via email when they are expiring -* show passwords -- set default shell to /bin/false when adding ppp account -- import list of POPs from Megapop (see www.ultimanet.com and click on locations -+from text in index page) - - -wishlist wrt projects/consulting from jivko@ijs.com: ->The other thing, which is the serious part, is the following: We do not ->offer dial-up services and that part of the system does not have to work, ->but we have many customer, for which we do both hosting and consulting work. -. ->The hosting can be handled by freeside fine, but in the little time I spent ->on it I could not see how exactly to solve the consulting problem. What I ->would love to see there is a way to create 'projects' for each customer and ->ability to follow up on those (I mean to be able to add new comments, ->descriptions, progress updates etc.). You already have the feature, which ->allows multiple people to access the system with different access rights so ->it should be possible to make it keep track of who and when updated given ->'project' so we could have the developers access the database and update ->the projects they are working on. -. -Hmm. Is this accurate: Each project is related to a single customer, and -zero or more packages (billing items). Each project has a name, due date, -and zero or more log entries consisting of date, user, and a text field -(for "new comments, descriptions, progress updates etc." - would you like -anything more specific?) - -In conjunction with that it looks like you need the ability to create -"one-off" packages on the fly for arbitrary charges. - -> Additionally it would be nice to have a page, where all open projects can -> be listed and not only that but be able list them by date too. (Say I want -> to find out which projects are due today or two days from today, or which -> projects are running late) -. -Browse/search project by date and customer. -. -> Finally it would be real nice if the billing script could add the cost for -> all completed projects (or work done by the hour) to the monthly bill along -> with the hosting information and using the description of the work from the -> 'project' table. -. -Can you be more specific about your needs here? -. -> This is a lot of work, unless you disagree :-), and I would not expect you -> to do all of it - we can work on it too - but I would hope for you to lead -> the effort. -. -I'm trying to get a handle on specifically what you need. -. -> Oh, and there is one more thing, but that should be simple to do. I would -> like to be able to give the customers access to selected information from -> their account. I want them to be able to monitor the progress of their -> projects and the status of their accounts. -. -Ok. -. -> Does all this make sense? It must be close to what you need at your office -> though or at least I think so. -. -Yes, but we're small and have been tracking projects manually. -. -. ->You may have this already .. what I have in mind is the following. Say you ->have a customer for which you do hosting and some consulting (CGI, JAVA ->etc) At the end of the month you need to bill the customer for the hosting, ->35hours of Java programming and 10 hours of HTML authoring. The last two ->are not because the project is over but because the work was done during ->that month. -> ->So the way I see it, and it could be wrong, is that during the month the ->people who work on particular project enter their comments and time spent ->on the project. At the end of the month the billing script generates ->invoices in which besides the hosting charges there are also charges for ->work done during the period. -> ->Currently we do this in a very stupid way by maintaining a customer file, ->in which a script saves things to be invoiced. At the end of the month a ->script goes through these files and generates invoices with all items from ->the files, which have not been flagged as 'paid'. The convenience of this ->is that no one needs to worry about the invoices containing the items they ->need to contain. - - - -first package select field in edit/cust_main.cgi isn't sticky on errors, yuck -(also referral isn't sticky either? yuck) - -> 1. A Web Form to the user get his account added automatically . The -> /etc/raddb/users and /etc/passwd would be updated automatically (these -> file are on the same machine Freeside is). I guess the the Add -> Customer -> page with some customization could be the work. -> 2. A Canceling Account Web Form available to user cancel his account -> at -> any time he wants. -> 3. A Password Changing Web Form where the user could change your -> password by sending your username, old and new password. -> 4. Additional POP Accounts Creation where the user supply only his -> main -> username/password (probably provided from a PPP Account already -> created) -> and his POP username/password for this specific account. -(actually need something more general i guess - probably need some way to say -which accounts (svc_acct) can log in and make changes per customer (cust_main) ) - -this is awfully vauge, perhaps email for more info? don't want to alientate -someone with accounting experience, but i just don't have time right now. -. -Hi Ivan, -. -Thanks for the information. It took me a little while to figure it out, but I -+was -able to create an invoice. As a lamer and an accountant, may I make a few -suggestions? -. -On the Customer view page: -1) Layout the information in the manner the invoicing process is conducted. - a) Customer information - b) Package Ordering - c) Add a "Create & Edit Invoice" section - this allows auditing of the -invoice before it is processed. - d) then put the billing section to actually process the invoice - e) then put payment history information -. -Thanks, -Mark Roberts - - -new overdue code might be overzealous. test carefully. - -Port Freeside to use the modules that were abstracted from it: -Net::SSH, Net::SCP, DBIx::DataSource and DBIx::DBSchema, at least. - -"first package" and email invoice (?) not sticky on errors in new/edit customer -screen. - -http://www.ipmeter.com/ integration would be useful - -http://tangram.sourceforge.net/ -Tie::DBI - -mmm, http://pootpoot.com/~dlowe/DBIx-Table/ - -The cybercash links in htdocs/docs/config.html are b0rken. - -Yes. Which is what I've been trying to tell you. (destination user, -destination domainname) would be represented by the svcnum of a record in -svc_acct. (In retrospect, using the uid instead of the svcnum was a bad -choice). (domuser, domain name) would be part of the svc_acct_sm record, -as domuser and domsvc. -. -Upon further consideration, I'll probably eliminate the svc_acct_sm table -completely, and just add a field for the svcnum of a domain and the svcnum -of a destination mailbox to svc_acct (or perhaps a one-to-many -relationship - multiple svcnum(s) for multiple destination mailboxes. -hmm.) - -> > > > Longer-term, I need to do something about the length of the -> > > > column names - -> > > > The SQL1992 standard defines 18 character column names, -> > > > which would be a -> > > > reasonable goal. -> > > -> > > Maybe the thing to do would be to separate these out to separate -> > > tables. -> > > then we could simply use something like id, attrib_name, -> > attrib_value -> > > to -> > > store all of the radius values. -> > -> > Hmm, no, that's not quite right. You don't want to store the actual -> > strings in the records for each account. Probably need a table that -> > corresponds to the RADIUS dictionary file, with a list of -> > attributes and -> > attribute id's, then reference the attribute by id and not name. -> > -> > The more difficult bit is handling the service definitions -> > correctly - -> > part_svc and it's effects. -> -> Yes that could be a bit tricky. Perhaps just one "radius" field in -> part_svc that held a list of id's from the radius table that applied -> that particular service? -. -No, that wouldn't let you set defaults or fixed values for each attribute, -like part_svc currently does. - - - -hmm - if you delete an account in svc_acct somehow that a mail alias points to, -svc_acct_sm.export will fail. make sure this can't be done using -the web interface. - -Bug: during the linking process apparantly you can link too many services to -a package. *sigh* - -zip code i18n is not very good :( but at least US, CA, HU, ? - -ut_phonen doesn't check data length. several -orthogonal cleanup projects here. *sigh* - -update the cybercash links in config.html and in the homepage. add more explicit support for other payment types. etc. - -From "Tim Jung" -. -Automatic CC Decline Notices via email -Block Time billing for prepaid internet cards (400 hours or whatever block -time of hours) -Trouble Ticket System with simple search function for Knowledge Base feature -Employee Timecards -Credit Card System support for Red Hat's CCVS, and other Linux credit card -programs -Contact Manager/Lead Tracking -Pre-Sale Quotes -Cisco NetFlow Account for IP traffic billing -VoIP and FoIP billing -Roaming per minute billing based on Radius Proxy support or number they -dialed into from Radius logs (800# etc) -Support for OpenSRS Domain Registration -Support for TUCOWS signup CDs - - -dbdef-create for postgres - -pro-rating, fiddling dates - -It looks like svc_acct.import doesn't deal well with comments and -multi-attribute lines. - -ivan@rootwood:~/freeside_current$ rgrep -r domuid * | cut -d: -f1 | sort | -uniq -CVS/Base/TODO -TODO -bin/fs-setup -bin/svc_acct_sm.export -bin/svc_acct_sm.import -htdocs/docs/man/svc_acct_sm.txt -htdocs/docs/schema.html -htdocs/edit/CVS/Base/part_svc.cgi -htdocs/edit/part_svc.cgi -htdocs/edit/process/svc_acct_sm.cgi -htdocs/edit/svc_acct_sm.cgi -htdocs/search/svc_acct_sm.cgi -htdocs/view/svc_acct_sm.cgi -site_perl/svc_acct_sm.pm - -rootwood:COMPLETEHOST/TODO - -Currently, you set a value in the %FS::UID::callback hash with a coderef -of the code you want to execute, but this was bad design and will shortly -be changed to a subroutine to which you pass your coderef to register it. - -This is not a bug, it is how the system is currently designed. After -defining a new package, you need to specifically allow agent types to -purchase packages. You can do this from the edit screen of the new agent -type. -. -It wouldn't be a bad idea to add a configuration value that makes new -packages available for all currently existing agent types automatically. -. -On Fri, Apr 07, 2000 at 10:50:35AM -0500, David Morton wrote: -> For some reason, the type_pkgs table didn't get updated when I tried to -> create a domain service and package... insert into type_pkgs values -> (4,1); fixed it up so that I could actually order the package. - - -From: Chuck Cochems -. -1) automated generating of late notices. So far the only way I know to -generate one is to re-invoice manually. -. -2) smart credit card rejection handling. It should e-mail a note at -least, explainig that it did't go through, and why. -. -3)coment field in the main customer record. -. -4) streamlined payment entry feature. the current scheme has it fairly -buried. -. -5) queries to show al customers who owe money,and such stuff as that. - - -credits aren't counted against past invoices? hmm. something needs to be -done to "apply payment" genericly. and zero out invoices etc. - -more email which should make it into a more organized TODO list: -. -I would also love to see Freeside support bandwidth billing by reading the -Cisco NetFlow Accounting data so we and other ISP's could automatically bill -co-located servers and even potentially other virtually hosted sites like -MUD, Palace Chat, IRC Chat, etc based on the bandwidth they use or average -sustained rates or whatever. I'm not much of a programmer so I don't know -what all this entails but I did download a NetFlow client agent/whatever for -Linux though. - . -It would also be nice to see Freeside be able to read Apache log files and -bill customers for web traffic that way as an option also. Plus an option to -bill for excessive disk usage without having to use quotas if you didn't -want to, would be a nice feature as well. So you could monitor with a script -or something to see how much disk space a user was using then get some -average and charge a certain amount for anything above some preset limit for -that account type. I might be able to hack something like this up, but I'm -not 100% sure where to start or if there is something out there that could -be modified or not. -. -Do you think that you will ever support the HKS CCVS (Hell's Kitchen -Software Credit Card Verification Software) since Red Hat bought them out -and is going to be including that for credit card processing when you buy -the professional version? What about possibly supporting the OpenCCVS which -is a GNU/GPL version of a credit card program? I haven't had time to comb -through the Freeside code to see how hard it would be to add support for -these as externally called programs. -. -Also any thoughts on help desk, and knowledge base stuff? Any thoughts on -this stuff, and how possible and what kinds of work or time frame would be -involved? -. -Tim Jung -System Admin -Internet Gateway Inc. -tjung@igateway.net - - - - CVS via SSH (Score:1) - by platinum (jedgar at fxp dot org) on Thursday September 30, @07:13PM EDT (#4) - (User Info) http://www.fxp.org/~jedgar - The links above are your best bet for basic cvs server configuration. Once you have a pserver set up, you - may consider using cvs via ssh. All you need to do is the following: - - 1) Have ssh and sshd set up on the client and server machines - 2) Set CVSROOT="joe@example.com:/home/ncvs" - 3) Set CVS_RSH="/usr/local/bin/ssh" - 4) Use cvs normally - (Obviously, insert the proper host/paths above) - - You can also set up cvs/ssh to not need a password every time (similiar to an initial 'cvs login'): - - 1) run ssh-keygen on client machine using no passphrase. - 2) copy/add ~/.ssh/identity.pub on the client to ~/.ssh/authorized_keys on the server - (man ssh for more details) - - The main reason I mentio - CVS via SSH (Score:1) - by platinum (jedgar at fxp dot org) on Thursday September 30, @07:13PM EDT (#4) - (User Info) http://www.fxp.org/~jedgar - - -There's no way to do this currently, though it would be pretty -straightforward to modify the source - specifically, the _collect_ -subroutine in FS::cust_main. -> -On Mon, Dec 13, 1999 at 04:05:32PM -0700, Jeff Garner wrote: -> Freeside will e-mail my users when they are billed if they are setup as -> billing. -> -> When setup by credit card it does not e-mail them. Is there a way to -> turn on e-mail invoices for those who are billed via credit card? Kind -> of like a recipt of billing.... - - -doc: http://www.softagency.co.jp/mysql/qmail.en.html - -sql1992.txt standard is 18 character column names. shoot for that, not just -32 (postgresql default) - -Also note that (AFAIK) Freeside won't display any package that has more -than one service on the "Add Customer" page. The reason for this is -because there's no way to dynamically alter the displayed html form -based on which package is selected. One possible solution would be to -make an additional page that's used in the signup process that would -display the form for each package, like a MS-style "Wizard". The first -page lets you select the package, then the second page has the custom -form with fields for each service in that package and a save button. Of -course, that would require a little perl work. -. -Later, -Scott Cruzen - - -Your suggested script with back up /usr/local/etc/freeside, but will miss -any database not named `freeside'. Both of our scripts are specific to -MySQL. If you're interested in contributing to Freeside, maybe you could -work on a script which: reads the mapsecrets configuration file and then -each secrets file to find out what specific database engine(s) (MySQL, -PostgreSQL, etc.) and database(s) need to be backed up, then does so, -serializing backups of the same engine, i.e. stop mysql, do all the mysql -backups, start mysql, stop postgresql, do all the postgresql backups, -start postgresql, etc. -> #!/bin/sh -> apachectl stop -> mysqldump -t freeside > fs-backup.sql -> apachectl start -> tar -Pzcvf fs-backup-`date +%y%m%d%H%M%S`.tgz fs-backup.sql /usr/local/etc/freeside/ -> rm fs-backup.sql - -I chose to use counters in the filesystem because there is no standard way -to get the value of an auto-incrementing keyfield which is common across -all databases (as seen through DBI/DBD). -. -It certainly wouldn't be a bad idea to use the database-specific methods, -when available. - -htdocs/edit/svc_acct.cgi: -(Does the `*HIDDEN*' show up when you are adding a new account, and -specify the password, then receive an error and are returned to the form?) - -more DOC: -Thought some of you might be interested in this: -. - has CyberCash compatibility modules for -Paymentnet and Authorizenet - which should allow you process transactions -using those services as well as CyberCash. -. -The files are named CCLib.pm.paymentnet and CCLib.pm_authorizenet, -respectively, and are installed by renaming to CCLib.pm and moving to your -site_perl directory. Otherwise, follow the directions for Cybercash v2 in -htdocs/docs/config.html - -DOC: -fs_passwd/ is a client-server replacement for the `passwd', `chfn' and -`chsh' commands that updates the Freeside database. (so for that to be -useful, you'd have to be exporting that data periodically) - -fs_radlog/ is a client-server RADIUS log parser that stuffs the data into -SQL. It isn't finished, and probably won't be unless someone who I can't -convince to use one of the RADIUS daemons that logs to SQL directly pays -me money or something. - -fs_signup/ is a client-server signup server. i'm just finishing it up -now; probably isn't on your machine yet. - - -http://www.sisd.com/freeside/list-archive/msg00812.html - -package definitions should be implicit allow wrt agent types, not implicit deny -(with the old behavior possible via a config file) - -> So is there anyway it could be setup to allow you to select a "primary -> service" from each package? This service would be the one you were prompted -> for. Could the signup server then be expanded to allow users to go into -> their package and "turn-on" the remaining non-primary services(using the -> primary account.) - -take the GPL'ed whois proxy stuff at www.geektools.com and turn it into -intelligence for Net::Whois. - -A web version of the fs_passwd stuff would be nifty. - -If you have Cistron authenticating directly from MySQL, you can replicate -in real-time instead of exporting periodically. See -. - -these go in docs: - (was 546), and - -and http://www.sisd.com/freeside/list-archive/msg00421.html (was 423) - -> > 5: Is there anyway to get freeside to send a sysadmin a warning when a -> > credit card has expired? -No, but there should be. - -Put this in the doc (quoting Mark Wells ): ->Of course, thanks to the sheer coolness of SQL and MyODBC, you can do ->whatever reports you want in basically whatever application you want. ->There's no need for Freeside itself to do any reports at all. - -middle names and titles - -On Wed, Jul 07, 1999 at 01:11:40PM -0400, Frank Nazario wrote: -> Playing and entering information to Freeside i encountered the following -> missing reports: -> -> View Customers by Agent -> -> View Pending Invoices -> - -grep 'uncomment this to encrypt password immediately' site_perl/svc_acct.pm -Not to say that it shouldn't be a configurable option. - -in site_perl/cust_main_invoice.pm (elsewhere?), error out if mydomain config file is gone -(at least until the idea of a default domain goes away) - -FS::Record::qsearch does an eval every loop iteration (which is itself not -guaranteed to work across all DBD's and should be fixed). This has got to be -slow. Fix it. (I think recent Perls might have a way to accept a variable -there, no eval needed?) - -Could you have added /bin/sync, /sbin/shutdown, and /bin/halt to the -`shells' configuration file before importing, and removed them afterwords? -(even better if svc_acct.import did that automatically - it could just -munge and restore @FS::svc_acct::shells... hmm.) - -> BTW, Ivan, I am trying to verify in an additional database table that a -> particular user doesn't exist. This database is used to store email aliases a$ -> additional POP boxes for our customers (kinda like AOL allows). I have toyed -> with the idea of just writing the aliases to an email only svc_acct that -> doesn't write to the password file, but that isn't really how I want to do it. - -Actually, I think that's a pretty good way to do it. Cerkit contributed -support a little while back for svc_acct.pm and svc_acct.export for -multiple export targets. It needs to be cleaned up and documented, which -I'll try to get to soon. For this to work correctly, the svc_acct_sm -table should go away, along with the concept of a "default" domain. - -default setting for new packages should allow all agents to purchase them... -with a config file for the old behaviour - -fix or replace Term::Query (Quiz::Question doesn't do what i need) - -Check config file reading stuff from CPAN - -Authorizenet module from CPAN! - - has a good y2k complience -statement! - - I'm hoping Freeside can support arbitrailly complex pricing plans - because of a simple concept: all prices are perl expressions. So if - you use `19.95' for example, perl evalates that to be `19.95'. But if - you need to do a complex pricing scheme, you just need to write an - appropriate perl expression, which will most likely pull data from the - database to return pricing. Some things will already log to SQL; for - example most RADIUS servers can or have a patch available. Getting - Freeside to bill based on any sort of data then becomes a matter of - importing the data into the database. - - There are some issues involved with pro-rating, partial month charges, - that sort of thing. Expressions will need a standard way to have the - applicable time/data ranges passed to them. Also the expressions are - currently running under the Safe perl module, and the opmask might not - be right in all situations. I'll try to spend some time working on - this if you are using it. - -> 2. can customers view their bills on-line. -. -Not yet; it needs to be proxied from Freeside to a customer web server in -a secure way using something not completely unlike the fs_passwd, -fs_passwdd, fs_passwd_server trio. - - -> Lastly, if someone over pays on an invoice, the credit part does not flow -> over to other invoices.. -. -The total balance flows over correctly, but individual payments don't. -The code you're looking for is in FS::cust_pay::insert -. -The question of what to do with overpayments that don't have another -invoice to flow into (yet.. or possibly not) is still an open one. The -legacy system Freeside replaced long ago had a separate place for this -(payments waiting for an invoice) for each customer, and it gave our -bookeeper fits. - - -option to relax username uniqueness in favor of username+domain or mail/shell -vs. radius to ease import for isp's with namespace problems or who buy others. - -do i have to store anything for radius realms besides regular radius attributes -(which are handled fine now)? - -warn or complain or something when invoice_from is empty (and we use it) - -Right now Freeside uses the `freq' field of a package definition as a -number of months. The specific section of code you're looking for is in -FS::cust_main::bill: -. - #change this bit to use Date::Manip? - #$sdate=$cust_pkg->bill || time; - #$sdate=$cust_pkg->bill || $time; - $sdate = $cust_pkg->bill || $cust_pkg->setup || $time; - my ($sec,$min,$hour,$mday,$mon,$year) = - (localtime($sdate) )[0,1,2,3,4,5]; - $mon += $part_pkg->getfield('freq'); - until ( $mon < 12 ) { $mon -= 12; $year++; } - $cust_pkg->setfield('bill', - timelocal($sec,$min,$hour,$mday,$mon,$year)); - $cust_pkg_mod_flag = 1; -. -..and when I went poking for this, looks like it tells us just what needs -to be done! Hehehe... -. -Date::Manip can handle cool things like "+ 1 month" (actually the current -case of /^(\d+)$/ would have to be added as a special case of "+ $1 -month") and "+ 30 days" (what you need) and even "+ 5 business days" ! - - -On Wed, Apr 28, 1999 at 08:38:16PM +0000, Kristian Hoffmann wrote: -> I can't quite seem to figure out how this exporting works. From what I -> understand, when you run svc_acct.export, it rewrites the /etc/passwd, -> /etc/shadow, etc. files. Is this only for initial setups with the -> export hooks being in the pm's? -. -You can use both, or just one method. The configuration files control -this. One of the things in the TODO is to take out the last few things -that aren't customizable wrt this and put them in config files. - -http://www.daemonnews.org/199905/user-mgmt.html - -Term::Query doesn't install out of the box from CPAN. Fix it (and get it -submitted upstream!), or remove requirement from bin/svc_acct.import and -bin/svc_acct_sm.import and take it out of the install instructions. - -use this cool link to explain the Freeside API -ftp://cpan.nas.nasa.gov/pub/perl/CPAN/doc/FMTEYEWTK/easy_objects.html - -Multiple tax rates by geographic region (county, state, and county) are -supported; just choose View/Edit tax rates from the main menu. - -Multiple tax rates by package are not (yet) supported. - -On Wed, Jul 07, 1999 at 12:13:36PM -0400, Shaun Batterton wrote: -> How would you handle something like multiple tax rates and multiple -> states? For example in Connecticut, they just changed computer and/or -> data processing services to 3% (whatever that is), and everything else -> is 6%. - - -> Second, when trying to add a new user I get two types of errors; first one -> is when I place an e-mail address and select the "submit," Freeside -> complains with "Error: Unknown local account (specified literally)" -. -You probably put a (local) email address in for email invoices. Freeside -stores these as references to the database records, so (for example) they -follow username changes. -. -I'm guessing you put in the email address that you were creating, and got -that error because it didn't exist yet. Sounds like a buglet to me. I'll -try to fix that soon; in the meantime you can add the invoicing email -address afterwords. - -(workaround for postgres before 6.5) (unlikely to ever be implemented) -In the mean-time, this could probably be fixed with the reverse of -the kludge in FS::Record::new. This removes `$' and `,' from money fields -coming out of the database. Something which fixed up the data so Postgres -was happy with it could go in FS::Record::_quote, for data going into the -database. - -our data display problem might be a Freeside problem wrt not using -Oracle-compatible DBI syntax (fixed using the return value from $sth->execute -as a number of rows - something else?). - -hooks for arbitrary commands out of configuration files -svc_acct.pm svc_acct_sm.pm etc. - -Add this to a FAQ, along with doing it for middle names: -> What I'm finding difficult is how to easily -> customize fields. For example, I am trying to add a "middle name" field -> to the Customer Edit, view, etc. If I'm going about it right, it appears -> I have to edit the cust_main.cgi under edit and edit/process and the -> site_perl/cust_main.pm, as well as other things. Perhaps you could shed -> some light on the best way of doing this. - -You have the basic idea. To implement that completely, I would: -- Add the new field to bin/fs-setup for new users -- Document the field in htdocs/docs/schema.html -- Document the change in a new file, htdocs/docs/upgrade4.html -* Run bin/dbdef-create -* Add the new field to edit/cust_main.cgi and edit/process/cust_main.cgi -. -For bonus points, I'd grep around for the various bits which use "$first -$last" or "$last, $first" and replace them with a method call in cust_main.pm, - , like search/cust_main.cgi - -document security model: -Don't forget about Apache usernames - since, via the mapsecrets file, each -user can login to the SQL database with a different username and -password, you can utitilize the security model of the SQL database as -well. Also, each username here can point to a different configuration -directory where you could store user-specific configuration info. Then -you could link each username to one-to-many agents. -(The web demo works using a trivial version of this.) - -Yes, queue processing or the equivalent via checkpoint fields on various -talbes (which you pick up via a pretty simple SELECT) would be really -nice too. - -default (and ordering) state/county/country config file -expand the -cust_main_county table to provide a preferred ordering, so the most common -entries would be at the top of the selection box. automatically, based on -recent selections? - -hmm... maybe svc_acct__shell should check off the legal shells list if -applicable? yeah... cool. - -payinfo field should me much larger than 16 - - -[Mon Apr 12 20:31:21 1999] [error] [Mon Apr 12 20:31:21 1999] null: Error closing true: Broken pipe at /usr/local/lib/site_perl/FS/cust_main.pm line 615. - -javascript (yuck!) "are you sure?" confirmation on cancelations, etc. -(view/cust_pkg and view/svc_*) - -get rid of time2str("%D") which formats dates in a non-y2k-safe looking fashion -(all the actual date handling uses UNIX timestamps and is fine) - -uncomment expire in view/cust_pkg.cgi and find the expire cron from fsold - -(Test this) -one-time/per-customer/? changes in rates and descriptions ('remembered -invoices'): implement by creating a new package on the fly... but it isn't -associated with any agent types so it won't show up for other customers to buy. -(but also... make sure they go away when the customer does! - need this? : - one-off package edits! : need a cust_pkgs or cust_part_pkgs or something table, - with custnum and partpkg (like type_pkgs) -(what happens if you hit "custom pricing" but the pricing is already custom?) - -Lay out any remaining ugly forms better. - -remove "records identical" warning? gets in the way of more important stuff. -or fix logic which tries to update identical records?? -1.2 should be quiet enough that the error log is useful, hopefully. - -Postgres has a maximum column length of 31 characters (but see NAMEDATALEN in -postgres_ext.h). part_svc has columns like: svc_acct__radius_Attribute_flag -(22 characters!) It seems that stuff over the limit is silently ignored, -so we get 4 characters back. So, Radius_Attributes are max 13 characters with -stock Postgres. see rfc2138 for what's affected -What's a good fix? (besides recompiling postgres with NAMEDATALEN 64) -(mysql has a 64 character max column length. others?) - -[Mon Mar 29 06:57:56 1999] -e: Use of uninitialized value at /usr/lib/perl5/Date/Format.pm line 333. -(when sending mail in cust_main.pm::bill or svc_domain.pm) - -look at DBIx::Recordset! (and Tie::DBI, and...) - -undefined conf/lpr gives this uninfomative error: -[Fri Feb 26 16:42:36 1999] bill.cgi: Can't do bidirectional pipe at -/usr/lib/per -l5/site_perl/FS/cust_main.pm line 629. -[Fri Feb 26 16:42:38 1999] bill.cgi: Error closing : Broken pipe at -/usr/lib/per -l5/site_perl/FS/cust_main.pm line 631. -So give a meaningful error! - -password and slipip stuff in svc_acct.pm store need to be split into two fields or something, so the silliness in svc_acct.pm and svc_acct.export with looking at the data to decide what to do with it can be fixed - -i10n: Apache::Language - -Apache::Session? Other useful Apache::* ? - -email invoices are only sent for the BILL payby. If setup, should statements -(since they're not invoices) be sent for COMP and CARD as well? - -$cgi->keywords is causing the (hard to trace) error: - Use of uninitialized value at (eval 5) line 5 - -edit/cust_main.cgi gives an uninformative error message: -> Can't call method "agentnum" without a package or object reference at -> /usr/local/apache-ssl/htdocs/freeside/edit/cust_main.cgi line 116. -if there are no agents. - -(is this missing on any web screens? (easy with $cust_svc->label) -Add the ability for services to filter information up to the package level -for web screens, so you can select a particlar package based -on username or domain name, etc. - -Allow a cancelled/suspended/active status from packages to bubble up to -the customer lists. Put active, then suspended, then cancelled accounts. -Similar ordering on the package listing inside a single customer. - -false laziness: edit/cust_main.cgi got some parts copied from edit/svc_acct.cgi -the web interface in general needs to be redone in a more abstract way. - -false laziness: some of search/svc_acct_sm.cgi was copied to search/svc_domain.cgi. but web interface in general needs to be rewritten in a mucho cleaner way. - -subroutine the where clause (eventually all SQL) as OO perhaps (has anyone done this?) - -add a select method to FS::Record? - -one-time/per-customer/? changes in rates and descriptions ('remembered -invoices'): implement by creating a new package on the fly... but it isn't -associated with any agent types so it won't show up for other customers to buy. -(but also... make sure they go away when the customer does! - need this? : - one-off package edits! : need a cust_pkgs or cust_part_pkgs or something table, - with custnum and partpkg (like type_pkgs) -(what happens if you hit "custom pricing" but the pricing is already custom?) - -You can't delete the stuff under administration yet. Add this, -_including_ making sure the thing you are deleting is not in use! - -add links on view/cust_main.cgi to setup services, like view/cust_pkg.cgi - -FS::cust_pkg _require_'s FS::$svc, but this won't work with %FS::UID::callback -loading of configuration. (pry need same idea, but will run immediately if -context allows). Looks like error is masked by 'use FS::cust_svc' which in -turn 'use's FS::{svc_acct, svc_acct_sm, svc_domain}' which is now explicit -w/comments in source - -Allow a cancelled/suspended/active status from packages to bubble up to -the customer lists. Put active, then suspended, then cancelled accounts. -Similar ordering on the package listing inside a single customer. - -svc_domain.pm mail sending uses Date::Format which doesn't seem to pick up -correct timezone. - -view/svc_domain.cgi needs to know the domain might be unaudited (cosmetic) - -remove whois_hack set to 1 for svc_domain.pm? add all known registries and -whois accordingly. -.us domains and others! -site_perl/svc_domain.cgi (hmm... or maybe should have a button? or maybe svc_domain.pm should handle this) should set $whois_hack for non-internic domains, so you can add them... - -turn on the depriciation warnings for [e]idiot in FS::CGI. Stop using [e]idiot -the last places it is (htdocs/search/ htdocs/misc/ htdocs/misc/process) - -(test cust_main.pm with cybercash v2 and v3, especially with the callback - stuff AND with mod_perl w/cybercash v2 kludge in package main) -(callback stuff should be eliminated by now) - -bah, table/itable/*table in FS::CGI is silly. - -doc Apache::AuthDBI as well -.. -Provide sample httpd.conf files. - -hey look: Tie::DBI! Check that out. Override its commit with something that -does perl-side caching for ? a performance improvement and as an emulation -layer to plug in f.ex mysql's atomic transactions -.. -Record.pm uses does some non-portable DBI things. MySQL and Pg seem fine. -Fix it anyway unless we migrate to Tie::DBI. - -faq - -cust_bill.pm uses '==' comparison on dates because they're currently ints - -config file for allowed card types - -write instructions for adding new services w/svc_Common.pm. Get rid of all -places where svc_* tables are hardcoded (rename svc_acct_pop to part_pop so -we can do that) - -test and document libapache-dbi-logger (woo!) - -radius logfile parsing and perl expression check. - -Fix in cust_bill BUGS: -There is an off-by-one error in print_text which causes a visual error (Page 1 -of 2 printed on some single-page invoices). - -fields should be a method against a FS::Record or derived object, as well as -being something you can call as FS::Record::fields('tablename'). Might -even be able to handle both in the same routine (that would be neato). - -Immediate removal of incorrectly entered check payments (can't take too -long to do this, or accounting is fubared). - -Add code to move from one service to another (POP to SLIP/PPP, etc.). -This _should_ be possible by working off the rules in part_svc rather than -hardcoding anything in. The rules in part_svc may need some elaboration, -perhaps. - -Use ut_ FS::Record methods in all derived classes (possibly some from dbdef?... eventually all from dbdef??? - but then `dbdef-create' would be impossible as there would be metadata we couldn't ask the backend for. hmm.) - -(bring back from fsold, ) Generalize config-sending stuff and make more configurable. -Expand the HylaFAX interface (also possibly generalize for other fax -softwar ie .comfaxe); allow things like arbitrary faxes of sales -literature, specific troubleshooting documents and so on. Maybe even -allow users to do this (though that might not belong in Freeside). -misc/sendconfig.cgi -misc/process/sendconfig.cgi -Configure fax recipients via a separate box rather than using the finger -name or first+last from cust_main. - -move all phone number logic out of Freeside - let HylaFAX or whatever -handle it. - -soundex searches for customer name and company? where are free soundex tools? (standard Text::Soundex duh) - I could have sworn I saw Text::Soundex on CPAN?! - -should be able to link on some field in email alias (right now you can link -on username or domain with a fallback to svcnum) - -generalize and make configurable new invoice printing scheme in FS::cust_main::collect (past due) - -deleting an svc_domain should delete all associated svc_acct_sm records. -same with a svc_acct. - -periodic password encrypter - -Automated, configurable notification, suspension and cancellation of -defunct accounts. -... -expire cron job -... -Allow for a future setup date on accounts. - -sub AUTOLOAD in FS::Record should warn? die? if used with a non-existant column -name? - -edit (not just import, export and allow default/fixed) arbitrary radius stuff -in svc_acct -edit/svc_acct.cgi and edit/process/svc_acct.cgi should deal with arbitrary radius stuff - -radius import should take DEFAULT entry and put it in /var/spool/freeside/conf/radius-default ; svc_acct.export should use it (and doc) - -in UI, s/State/State\/Provence/go and s/County/County\/Locality/go - -what else (besides l10n) for i18n? (money!) - -audit htdocs/* for things that should be libraried and things that should be -new methods on the objects (need to do this before implementing a new UI) -all the big things are done - -some places we die() where we should &FS::CGI::idiot (and perhaps vice-versa). -Decide based on whether or not the "error" should show up in logs. - -all .cgi's should use standard header/footer and idiot() subroutines. maybe HTML:: perl modules -for HTML creation. Maybe Embperl or something along those lines. ? - -When running bin/bill, Fix this (Annoying but harmless): -Use of uninitialized value at /usr/local/lib/site_perl/FS/cust_pkg.pm line 99,

chunk 4. -Use of uninitialized value at /usr/local/lib/site_perl/FS/cust_pkg.pm line 102,
chunk 4. -Use of uninitialized value at /usr/local/lib/site_perl/FS/cust_pkg.pm line 105,
chunk 4. - -all cgi (but internal to the isp) places where package names are listed should also have -comment (like agent_type) - -clean up $recref and other silliness and use -> calls where possible, or -one other alternative. clean up everything else. -should FS::Record use Tie::Hash? That would be very clean, but where do we -store the other information? Maybe you could ask any FS::Record object for a -tied hash? - -change all file access from regular open(FILE,) stuff to OO, because of -problems scoping and passing filehandles like that. - -the web interface should create a new object and use it instead of a blank -form for new records. the create method of svc_ objects should set defaults -(from part_svc). - -sub check in man FS::table_name should be rewriteen. Get rid of $recref -stuff. Make sure all fields that refer to other database are checked. - -Integration with signup disks (are there any free ones? Netscape?). - -One-button cancel (+refund) for lusers who can't get online. - -Keep information on virtual web servers (hostname, IP, host machine, -directory, etc.) and export this information for importation into the ISPs -web farm. - -Remove requirement that the first mail alias be the catchall? Still make -sure only one catchall per domain is defined in any case, of course. - -Ability to move cust_pkg records from one customer to another? (proably -will need to cancel the old and create a new like when we move services -between packages). - -Auto-increment expired cards one year, and try again? - -More non-US stuff - zip codes, country codes, foreign currencies, etc. - -cust_refund.{cgi.pm} need to do cards xaxtions. (now we only have cust_credit) - -Nicer set of integrated reporting possibilities, like weekly sales totals -by customer, package, agent, referral, etc., aging reports sorted by lots -of different things, and so on. - -Client/server setup for users to modify their own passwords, shells, etc, -via passwd or secure web interface (prelminary passwd/chfn/chsh -replacement done). Complicated by the fact that we don't want to allow -incoming connections to the machine running Freeside, so we probably need -to have a daemon on each external shell or web machine that is contacted -by the Freeside machine. Be very very careful for both traditional -security issues and DoS problems. - -An extension of the above to allow users to modify selected parts of their -own information, order and cancel services. A web interface for new -customers. - -Expand domain name stuff to house all domain information. Export -named.boot/named.conf (primary and secondary) and named.{domain} files. -Add more registries (not just InterNIC's com org net edu) - -Nice postscript paper invoices, rather than current ASCII invoices. - -think about race-condititions in FS::Record and derived ->check ->insert -and so on, uid and username checks in svc_acct, etc. - -Move to rsync over ssh file exportation rather than scp. - -check 'n fix the proactive password checker. (cracklib?) - -refunds of "BILL" payments: generate pseudo-check. - -write batch senders and batch parsers for the different credit card processors -people use/ -More CC processors/methods. - -you should be able to fiddle the setup date in cust_pkg. (at least initially) - -delete options in administration section - -write a generic batch senders and batch parsers. - -need a way to override svc_acct export on a per-machine basis; just use config files based on machine name i suppose; document that. (no, import desync_hosts -type stuff from cerkit) -... -add a table with column of export services (passwd, shadow, master.passwd, .qmail file update, dns update, etc.) and rows machine groups and whether or not to export that (and any necessary parameters). wasn't matt (vunderkid, not matt@michweb) working on this? find him? each machine goes in a group of its own as well as a group based on function. add a table with only svcpart and machine group. now, when you import from each machine, it can get its own accounts with one svcpart and universal accounts with another svcpart. (though that does make the username duplicate checking more interesting) - -you should be able to get column types as a method against an FS::Record object -as well as dbdef->table($table)->column($column)->type - -move to perl module for fuzzy and soundex searching. - -package view needs to list extraneous services; we need to prevent the -creation of them so this never happens (and mark it as such in the source) -(the creation problem should be fixed - though they will still happen if people -fsck around in the data manually, so list them anyway) - -add attribute dictionary to fs-setup as a menu, plus analyze users file to -decide automatically - -Check for and report on duplicate billing accounts (cust_main, though many -will have a need for these so probably don't disable them outright.) - -create a ->warn as well as a ->check method for all FS::table classes? -(see above) - -something to automate making a release and updating the web demo - -export a debian-style (also redhat and?) /etc/group file aswell! - -svc_acct_sm.import qmail import should pull in recipientmap people too. - -.pm's like svc_acct.pm which need to do time-consuming things like ssh remotely -should fork and do them in a child. - -i18n/l10n: take ALL messages and catalog them in english.txt or in database or something, so we can eventually go int'l. int'l currency support would be a help aswell. - -get some of { city, county, state, zip } from the missing bits if -possible (where can i get the data to do this? usps.gov?) - -additional interfaces (perltk? java?) - -Put the GPL notice in all files. - -integrate w/IDEA's signup server - -$cust_bill->owed database field to be eliminated, replaced by a method call -that calculates on the fly. make sure to grep for ->(get|set)field('owed') -same for cust_credit->credited - -Export quota information. - -move all configuration to a central place. maybe in blob's in the -database. maybe even things like the code to execute when a username is -changed can be in there, so less of the distributed scripts change between -different sites. - -Implement setup and recurring fees as Safe perl expressions rather than -numbers, to allow for variable-rate services. Backwards compatibility is -obtained because { 43 } in perl is still 43. :) Define API to pass -starting and ending dates and any other necessary data to expression -(fees are currently evaluated as Safe expressions but more work needs to -be done to define an opmask for various needs, write examples -(usage-based billing, etc.) and so on). -... -Add the ability to modify the next billing date in cust_pkg, and take -appropriate action. This will allow the implementation of pro-rate/1st of -the month billing as well as the ability to manually fiddle with -anniversary dates in cust_pkg, so you can sync a customer's anniversary -date even if you're using anniversary billing (manually or automatically). -(now with above, we need to have a way to automatically pro-rate /^(\d+)$/ -charges - anything more complicated should figure it out itself given -starting and ending dates [document that!]) -... -Daily Radius log parsing into database; other logfile formats? -... -Callbacks to enforce hourly limits on accounts (suspend until the end of -the billing period?), for those who limit customers rather than tack on -extra charges. - -Flag packages (part_pkg) as taxable or non/taxable as some ISPs (for -example) need to charge tax on equipment but not service (separate flags -for setup and recurring fee... or perhaps a setup_tax, setup_notax, -recur_tax and recur_notax fees, and possibly something more flexible if -there is need). - -Allow for a variable number of invoices for customers who need multiple -copies. - -Add a mail alias service with table svc_acct (not domain mail aliasing -which is domain with svc_acct_sm) - -(bring back from fsold) Change customer comment field from its current kludge to something more -workable. - -Better work orders with more information. Should eventually open a ticket -when we have such a thing. -edit/svc_wo.cgi -edit/process/svc_wo.cgi -Call tracking and trouble tickets. - -More accoutability for complimentary accounts: approval, expiration, term -(no more than x months in advance) and notification. -Flag particular users (or all users, for that matter) as having their -passwords hidden and/or locked from users of Freeside (maybe need Freeside -security levels first?). -... -Better Freeside-level configurable access, for those ISP's who have -employees they can't trust. Right now you're "stuck" with setting up -.htaccess stuff yourself. This should really just be integrated. - -configuration/setup should get web interface -... -/usr/local/etc/freeside should be configurable -... -(probably as part of some automated installation process?) - -This requires some serious magic in FS::Record: -ok, if date_type in fs-setup is to be something besides int, -now we need to create wrappers -for them so they behave identically across RDBMS's, ie date pops out as as -UNIX timestamp (or an object of some sort? maybe even a blessed $obj which -is a string not a hashref for backwards compatibility?) and so on. (remember -to treat '0' as Not a Date instead of 1/1/70. - -Add Freeside-level transactions for RDBMS's which don't support -transcations? (Currently we assume a minimal RDBMS which has no rollback, -transactions or atomic updates). Or just require a RDBMS that supports -rollback and/or atomic updates and get rid of the work-arounds? The /rdb -interface had this kludge on top of it but is a technical dead-end in most -other ways, unless it can gain an SQL parser and DBD interface. -... -if i'm really bored, find the /rdb interface in fsold and port it to NoSQL, -and while I'm add it add interfaces for AnyDBM_File tied hash.. hmm. Shouldn't -an FS::Record have something to do with a tied hash? But we don't want -performance to go gaga... maybe something with commit to help out here? -... -Ok: FS::Record gives you a tied hash, and you get methods for commit, etc. - -Better automated comparison of our CC records with processors (CyberCash, -at least, has not always had 100% accuracy, though recent versions are -much better) - -Expect or other pty based login check, where we actually connect to a -terminal server or shell machine and test logging in as the user (if we -are keeping a cleartext password for that user) (This is something tech -support often needs for new customers) - -Use cust_main table for pre-sales tracking as well? - -Automatic commision report and check generation via freq and prog (to -become a Safe perl expression) fields in agent table, and possibly others. - -Database and add a mailed-out date and method for disk/CD mailing, so a -customer can call and you can say, "sent on xx/xx/xx via {US Mail, Fedex, -UPS, etc}" - -Inventory tracking for physical items such as routers (for sale or -lease... probably doesn't make a difference in the ordering... but if you -cancel a router lease the inventory should come back. hmm.) - --- Matt's wishlist --- -. -From matt@michweb.net Fri Feb 20 16:39:53 1998 -Date: Thu, 19 Feb 1998 23:20:11 -0500 -From: Matt Simerson -Reply-To: quadran-developer@netgoth.com -To: quadran-developer@netgoth.com -Subject: Re: Welcome to quadran-developer -. ->Whats it based on and what is it supposed to do? I'm interested, but ->unfortunatly, I don't have that much time to help on the project (I'm busily ->working on one of my own based around MySQL and Qt right now -- don't know ->if it will be GPL'ed or not yet -- we'll probably just use it in house since ->it is designed around our system)... -. -That's what I set out to find, but didn't find anything on the web site. -I'm looking for something that will do the following: -. -Single point of entry for users on a secure system: - Creates account on user (public) systems - update /etc/passwd/master.passwd file - update radius database (if necessary) - Set up up disk quotas (although I hacked adduser to do this) - Option for adding user to a mailing list(s) - Export of new user info to customizable report (for automated entry -into - accounting software, etc...) -. -Automated billing: - Export credit card info for batch processing and have hooks built - in for other forms of electronic processing. - Batch-Payment (apply payments from formatted text file). - Customizable reports for manual entry/importing into Accounting -software - Email or laser print invoices - Sanity checks credit card numbers before processing (code available) -. -Simple method for disabling an account. - Arbitrary Expiration Dates (on a given day, in x days) - Remove from radius. - Changing password to '*' - Virtual customers disabling dns, http server, log processing, etc.. -. -Billing for different account types: - Dialup monthly flat rate. Prorates for partial months. - Dialup monthly flat rate for x hours + hourly usage. - Dialup email only - Email only accounts - Virtual Web accounts - w/multiple mailboxes - Leased line accounts - Disk space used over quota. - Tech support minimum + hourly charges - Other for misc stuff (modem, RAM, etc...) -. -Per user definable RADIUS attributes (ties in with above) - Fixed IP - Simultaneous Use - IP filters (for dialup email only) -. -Keep logs of modem usage generated daily from radius accounting logs stored -on multiple radius servers. -. -Keep logs of disk usage generated from quota. -. -Method of adding virtual domains to your system: - Automatically grabs an IP address from a preassigned pool. - Creates a domain.com database file from database fields - Updates /etc/named.conf or /etc/named.boot and reloads named. - Add's virtual.com to /etc/sendmail.cw or qmail control files. - Edits your web servers httpd.conf file and restarts http server. - An optional section for adding vif's can be added if the users OS - supports adding them on the fly. Otherwise it's up to the end - user. Make a hook that can run a custom script that the user - tweaks for his system. - Update or create the config file your web stats analyzer needs. I've - done this for analog (free) and http-analyze. Probably - should only officially support analog and let users hack - it to their hearts desire. -I've already written scripts that do most of the virtual web stuff on my -system...in bash. Shouldn't be hard for a perlmeister to convert. In fact, -as long as all the info was stored in the database (username, domain name, -and ip pool) this could easily just be run as an external script that the -user tweaks to match his system. -. -We use a great accounting software (M.Y.O.B) that does all the AP, AR, -Payroll, Tax stuff, and most everything else we could need. It's already -set up for the type of checks we have, etc, etc... I just need something to -do the billing part. I can import/export sales and payments directly once -the billing part is done. You can't write accounting software as good as -M.Y.O.B. for $120. - - -- cgit v1.2.1