Steve Sutton [Mon, 19 Mar 2018 16:26:57 +0000 (12:26 -0400)]
Add member type to the edit invoice
Adding the member type into setting for invoice types
Steve Sutton [Mon, 19 Mar 2018 15:40:16 +0000 (11:40 -0400)]
Adding new field for the member_type
Add new field to the invoice_type table.
Member Type
Will be used for creating new invoices based on member type.
Steve Sutton [Mon, 19 Mar 2018 15:39:40 +0000 (11:39 -0400)]
Update the order by for invoices
Order by due date and transaction time.
Due date asc
transaction time desc
Steve Sutton [Sat, 17 Mar 2018 18:55:08 +0000 (14:55 -0400)]
Update for getting settings
make sure the db version is set before getting any setting or management
Steve Sutton [Sat, 17 Mar 2018 18:54:27 +0000 (14:54 -0400)]
Add new db field for settings
New setting days before invoice
Steve Sutton [Fri, 16 Mar 2018 20:55:15 +0000 (16:55 -0400)]
Add account name search to account list page.
Can search by account name.
Steve Sutton [Fri, 16 Mar 2018 20:31:16 +0000 (16:31 -0400)]
Update member only menu
Add billing.
Don't allow editing of anniversary or renewal dates.
Steve Sutton [Fri, 16 Mar 2018 18:17:36 +0000 (14:17 -0400)]
Update invoice page to have links to member billing tab
Link each member name to their billing tab.
Steve Sutton [Fri, 16 Mar 2018 18:02:45 +0000 (14:02 -0400)]
Fix add payment page
Get simple list of accounts.
Steve Sutton [Fri, 16 Mar 2018 17:16:46 +0000 (13:16 -0400)]
Adding filters for pending and overdue
For the main index and invoice pages.
Steve Sutton [Fri, 16 Mar 2018 16:54:16 +0000 (12:54 -0400)]
Updating the getStats call
Passing $where part
Steve Sutton [Fri, 16 Mar 2018 16:48:17 +0000 (12:48 -0400)]
Update dateformat for account page
Update the dateFormat for datepickers
Steve Sutton [Fri, 16 Mar 2018 16:43:51 +0000 (12:43 -0400)]
Update the dateFormat for datepicker
Needs to be set.
Steve Sutton [Fri, 16 Mar 2018 16:36:17 +0000 (12:36 -0400)]
Add total count to account list page.
Adding the getStats to get total number of accounts.
Steve Sutton [Fri, 16 Mar 2018 16:17:47 +0000 (12:17 -0400)]
Update list invoices to show total invoice count.
Adding stats to list invoice pages.
Steve Sutton [Fri, 16 Mar 2018 15:55:38 +0000 (11:55 -0400)]
Update list views for sessions
Turn off the php sessions for paging for now.
Need to redo these.
Steve Sutton [Fri, 16 Mar 2018 15:32:40 +0000 (11:32 -0400)]
Update text
Had Events in there.
Steve Sutton [Fri, 16 Mar 2018 15:12:10 +0000 (11:12 -0400)]
Finish the create Invoice for MiGCSA
Pull data from migcsa current site and create invoices.
Steve Sutton [Thu, 15 Mar 2018 20:50:15 +0000 (16:50 -0400)]
Trying to setup create invoices
Finally got to output the create invoice view file.
Steve Sutton [Thu, 15 Mar 2018 20:31:47 +0000 (16:31 -0400)]
Start setup of import script for migcsa to create invoices
This needs to be done within the plugin to get access to the
billingSupport classes.
Steve Sutton [Thu, 15 Mar 2018 19:01:55 +0000 (15:01 -0400)]
Updating invoice and statement list
Adding in the line items.
Steve Sutton [Thu, 15 Mar 2018 18:49:42 +0000 (14:49 -0400)]
Add line items to invoice
If line_items_post is set to true
Steve Sutton [Thu, 15 Mar 2018 16:08:45 +0000 (12:08 -0400)]
Create indexes on tables.
Creating indexes on the tables.
Steve Sutton [Thu, 15 Mar 2018 15:43:51 +0000 (11:43 -0400)]
Update databastract for accounts
Add method for getting simple account list.
Steve Sutton [Wed, 14 Mar 2018 19:52:25 +0000 (15:52 -0400)]
Update name of create db script
for newer version.
Steve Sutton [Wed, 14 Mar 2018 19:44:49 +0000 (15:44 -0400)]
Update dashboard to show list of invoices.
Setup same as list invoices.
Steve Sutton [Wed, 14 Mar 2018 17:38:33 +0000 (13:38 -0400)]
Hide payment methods
won't be used currently.
Steve Sutton [Wed, 14 Mar 2018 14:53:09 +0000 (10:53 -0400)]
Fix bug in payments
When applying payment to invoice with an id make sure you substract the
balance from payment in each case. Then left over payments are applied
to any remaining invoices.
Steve Sutton [Wed, 14 Mar 2018 12:29:14 +0000 (08:29 -0400)]
Update account next anniversary date.
Fix date calculation for next occurrence of anniversary date.
Steve Sutton [Wed, 14 Mar 2018 00:02:10 +0000 (20:02 -0400)]
Fix sending email notifications for payments and invoices
Now sending out notifications for invoice creation and payment received.
Steve Sutton [Tue, 13 Mar 2018 21:26:04 +0000 (17:26 -0400)]
WIP work on notifications
Need to work on the notifications for payments and invoices.
Steve Sutton [Mon, 12 Mar 2018 20:22:56 +0000 (16:22 -0400)]
Work on payments and invoices
Payments:
Updating the payment processing to pass through the invoice id so it
marks that invoice as being paid.
Set select to use the balance instead of total_amount.
Invoices:
Fix issue where after adding an invoice the next page would not work and
was acting like edit invoice page.
Steve Sutton [Mon, 12 Mar 2018 20:19:31 +0000 (16:19 -0400)]
Update the statements page
Adding the Balance due for each invoice.
Removing the total on bottom.
Steve Sutton [Sun, 11 Mar 2018 15:58:34 +0000 (11:58 -0400)]
Some code clean up and adding styles for text alignment.
Get the forms to all output the labels right aligned when next to
inputs.
Steve Sutton [Sun, 11 Mar 2018 11:19:10 +0000 (07:19 -0400)]
Update payment form for validation.
Adding some validation into the htm5 markup in the form.
Steve Sutton [Sat, 10 Mar 2018 14:18:29 +0000 (09:18 -0500)]
Add size suggestion for image
Adding a sive suggestion for image in the invoice.
Steve Sutton [Sat, 10 Mar 2018 14:17:40 +0000 (09:17 -0500)]
Add the due date
Adding Due Date to the printable invoice.
Steve Sutton [Sat, 10 Mar 2018 14:17:06 +0000 (09:17 -0500)]
Add check for http in url
When updating or outputting the invoice_url make sure there's http in
front.
Steve Sutton [Sat, 10 Mar 2018 14:05:11 +0000 (09:05 -0500)]
Last minute edits from work.
invoices
Adding amount to invoice
Steve Sutton [Fri, 9 Mar 2018 19:37:12 +0000 (14:37 -0500)]
WIP: Invoice page, Create Payment (member side)
Fix issue with member billing payment page form not submitting.
Worked on the select for new invoice types.
Worked on adding new Account.
Now setting the billing account field and setting the next_ann date to
the due_date.
Steve Sutton [Wed, 7 Mar 2018 21:44:07 +0000 (16:44 -0500)]
WIP setup form for adding custom line items.
Tried to work in the custom line item into same form as the add line
item. But this won't work. Needs to be a separate form.
Steve Sutton [Wed, 7 Mar 2018 19:56:03 +0000 (14:56 -0500)]
DB Update, work on add invoice page.
Update db table line_item.
- Add three date fields
Working on being able to delete a line item once on the add invoice
form.
Steve Sutton [Wed, 7 Mar 2018 14:40:00 +0000 (09:40 -0500)]
Update list pages. Update invoices create page.
Invoice creation. Changing the select for members or accounts into
autocomplete. If they put something in that is not in the source for the
autocomplete it will empty the input field.
Add link to the account list that goes to the members billing dashboard.
Set width on the list pages for the ID field.
Steve Sutton [Tue, 6 Mar 2018 21:47:37 +0000 (16:47 -0500)]
Payment form, filters and debugging.
Going through and removing php notices when I find them.
Payment Form is now saving the payment and transactions and is working
with Authorize.net.
Need to replace the select for the member accounts on the add new
invoice page with autocomplete.
Steve Sutton [Fri, 2 Mar 2018 21:45:48 +0000 (16:45 -0500)]
Adding billing payment form
This is for the member to make a payment.
Steve Sutton [Fri, 2 Mar 2018 18:01:47 +0000 (13:01 -0500)]
Adding account list page and update search filters invoices.
Update search filters for invoices page.
Add account list and search for anniversary and renewal dates.
Steve Sutton [Tue, 6 Feb 2018 19:32:07 +0000 (14:32 -0500)]
Update code
adding docs
Steve Sutton [Tue, 6 Feb 2018 19:19:34 +0000 (14:19 -0500)]
Add new Invoice now adds new account.
Can now add a billing account from the add invoice page.
Steve Sutton [Mon, 5 Feb 2018 21:25:31 +0000 (16:25 -0500)]
WIP for add account on add invoice page.
Setup adding an account for members that have non when adding an
invoice.
Steve Sutton [Mon, 5 Feb 2018 16:29:51 +0000 (11:29 -0500)]
Adding list for pending and overdue to billing dashboard.
Adding pending and overdue list of invoices to the billing dashboard
with links to view the invoice.
Steve Sutton [Tue, 30 Jan 2018 21:59:46 +0000 (16:59 -0500)]
Update the edit invoice page for member account selection.
When selecting a member account it will update the due date to that
members new anniversary date.
Steve Sutton [Tue, 30 Jan 2018 17:37:28 +0000 (12:37 -0500)]
Clean up code.
Removing test of notifications.
Steve Sutton [Fri, 19 Jan 2018 21:56:57 +0000 (16:56 -0500)]
Don't remove the queue just mark it processed.
Will have to make more changes now.
Steve Sutton [Thu, 18 Jan 2018 18:02:16 +0000 (13:02 -0500)]
Remove the notification type test link
Removed.
Steve Sutton [Wed, 17 Jan 2018 21:54:08 +0000 (16:54 -0500)]
Setup crons for notifications and paging and search on invoices.
Starting setup of paging and search on invoices.
setup two cron task (admin ajax).
one for setupQueue
one for runQueue
Have to be unique names.
Steve Sutton [Mon, 15 Jan 2018 21:53:58 +0000 (16:53 -0500)]
Update the account edit page with new field.
Also added the field into the dataAbstract class for accounts.
Steve Sutton [Mon, 15 Jan 2018 21:29:54 +0000 (16:29 -0500)]
Add new field for accounts.
Adding renewal_date for the accounts.
Steve Sutton [Mon, 15 Jan 2018 20:42:42 +0000 (15:42 -0500)]
Setup 2 cron task style ajax models.
1 for storing id's into the queue.
2 for sending the queues.
Steve Sutton [Sat, 13 Jan 2018 13:15:21 +0000 (08:15 -0500)]
WIP Setting up cron action for getting notifications.
Still working on it.
Steve Sutton [Wed, 10 Jan 2018 21:48:46 +0000 (16:48 -0500)]
WIP billing notifications
working on the merge stuff. Grabbing the functions from registrations.
Steve Sutton [Thu, 28 Dec 2017 17:25:29 +0000 (12:25 -0500)]
Adding print button for the invoices.
Adding the PrintArea.js for the printing of the invoices.
Steve Sutton [Wed, 27 Dec 2017 21:33:10 +0000 (16:33 -0500)]
Working on setup for sending emails when creating invoices.
Steve Sutton [Wed, 27 Dec 2017 15:48:28 +0000 (10:48 -0500)]
initialize variable.
Initialize the invoiceHtml.
Steve Sutton [Wed, 27 Dec 2017 15:24:55 +0000 (10:24 -0500)]
Adding setting for payment_terms
Adding a new field for the settings table.
Payment Terms - Will output with each invoice just above the payment
coupon.
Steve Sutton [Fri, 22 Dec 2017 19:30:43 +0000 (14:30 -0500)]
Adding new table to save invoice payment data.
Working on adding another table for the billing plugin.
Adding table to record the payment amounts that get applied to an invoice.
This way When I show the invoice I can show the payments made to that invoice.
Steve Sutton [Thu, 21 Dec 2017 18:34:26 +0000 (13:34 -0500)]
Update dbversion and work on invoice.
Working on printable invoices.
Adding new total field to the line items table.
To be used for holding the amount times the qty.
Steve Sutton [Wed, 20 Dec 2017 21:57:46 +0000 (16:57 -0500)]
Update for the line items on invoice
Need the tr tag inside the foreach loop
Steve Sutton [Wed, 20 Dec 2017 21:48:42 +0000 (16:48 -0500)]
WIP for invoice view and print version.
Had to add some fields to the database for accounts table.
Figure this would be the best place to put in billing address.
This way I can pull this data to put in the invoice.
Steve Sutton [Mon, 18 Dec 2017 21:54:16 +0000 (16:54 -0500)]
WIP billing invoice template
Working on the billing invoice template.
Creating method in support class to generate the html.
Steve Sutton [Thu, 14 Dec 2017 21:41:24 +0000 (16:41 -0500)]
New code comments.
Commenting more of the code for notification types.
Steve Sutton [Thu, 14 Dec 2017 21:31:17 +0000 (16:31 -0500)]
Adding to the billing dashboard.
Setup count of pending (not overdue)
Setup count of over due.
Steve Sutton [Thu, 14 Dec 2017 17:51:52 +0000 (12:51 -0500)]
Setup emails from the notifications.
Send out notices.
I have a test link in settings > notification_types that allow test
sending of the notice. It's hard coded to the account with id 1 right
now.
Steve Sutton [Thu, 14 Dec 2017 11:29:45 +0000 (06:29 -0500)]
Updating the db scripts
Correcting: need to add field to transactions: account
Steve Sutton [Tue, 12 Dec 2017 21:59:01 +0000 (16:59 -0500)]
WIP for notifirations
For sending out emails.
Steve Sutton [Tue, 12 Dec 2017 20:36:17 +0000 (15:36 -0500)]
Moved this into management
Removing from settings.
Steve Sutton [Tue, 12 Dec 2017 20:33:28 +0000 (15:33 -0500)]
Save management settings. Payment Gateway settings.
Saving the gateway and payment options for billing into the management
db table.
Steve Sutton [Tue, 12 Dec 2017 19:52:54 +0000 (14:52 -0500)]
Adding new table for management, payments list, and add fpdf library.
Adding fpdf library for possible use.
Adding new management table for the payment gateways.
Add payments to the list for billing payment tab.
Steve Sutton [Mon, 11 Dec 2017 21:39:30 +0000 (16:39 -0500)]
updates for statements
Update the member statements for invoices and payments.
fix the db update script by naming it correctly.
Steve Sutton [Mon, 11 Dec 2017 18:26:56 +0000 (13:26 -0500)]
Creating methods in support class for member statements.
Creating the member statements and outputting the member statements in
their member billing tab.
Steve Sutton [Sun, 10 Dec 2017 18:09:08 +0000 (13:09 -0500)]
Setup the member statement model view and setup support class.
Setting up support class.
Created methods to record invoice and payment transactions.
Steve Sutton [Fri, 8 Dec 2017 21:48:31 +0000 (16:48 -0500)]
Adding payment library
also updating the member billing statement model view.
Steve Sutton [Thu, 7 Dec 2017 21:50:21 +0000 (16:50 -0500)]
WIP adding account form for member billing tab
Working on getting the member billing tab with management of the
account. If the member doesn't have an account it can add one. If
there's one already there it updates it.
Steve Sutton [Thu, 7 Dec 2017 17:54:30 +0000 (12:54 -0500)]
Due date and notes being saved now.
Adding notes to the invoice creation page.
Also I updated the data type for the due_date in the abstract class and
now the due_date is being saved.
Steve Sutton [Wed, 6 Dec 2017 21:53:16 +0000 (16:53 -0500)]
WIP invioces
Working on the invoices.
creating some invoices and adding line items for each one.
still working out how need to create member account entry when none exists.
This could be done on the create invoice page so they pick a member name and
fill in the account data. I don't think I have a field yet for their account
number. may need that.Working on the account part of the add invoice page.
also trying to add due date to the form but it's not being saved.
Steve Sutton [Wed, 6 Dec 2017 10:55:19 +0000 (05:55 -0500)]
Work on select for invoice line items and saving transaction time.
Put in transaction time and group the parent child line items in select
Steve Sutton [Tue, 5 Dec 2017 21:55:59 +0000 (16:55 -0500)]
WIP for adding invoice line items
Price calculation is being done for the items.
Need to work on the quantity.
Steve Sutton [Mon, 4 Dec 2017 21:39:37 +0000 (16:39 -0500)]
WIP for adding create invoice page
Working on the create invoice page.
Steve Sutton [Mon, 4 Dec 2017 17:42:37 +0000 (12:42 -0500)]
Update the edit form so it shows errors
Show update or insert errors or success messages.
Steve Sutton [Mon, 4 Dec 2017 10:33:12 +0000 (05:33 -0500)]
WIP work on the edit add page for notificationTypes
Further work on notificaton types for edit and add page.
Steve Sutton [Fri, 1 Dec 2017 21:43:56 +0000 (16:43 -0500)]
WIP for the edit part of notification types.
Moving them into their own view files.
Steve Sutton [Fri, 1 Dec 2017 20:02:16 +0000 (15:02 -0500)]
Update for the header links in billing tab
updating the header links in the billing tab.
Steve Sutton [Fri, 1 Dec 2017 15:05:24 +0000 (10:05 -0500)]
Output trigger for notifications on notification types list.
Showing when the notification is triggered by date or by an action.
Steve Sutton [Thu, 30 Nov 2017 21:40:57 +0000 (16:40 -0500)]
Update for adding notification types
Add the setting page for add/edit/delete notification types.
Steve Sutton [Thu, 30 Nov 2017 15:32:20 +0000 (10:32 -0500)]
Invoice types - parent ordering of invoice types
Now the invoice types can be order correctly based on parent they belong
to. Only the top level parent show in the drop down for parent
selection.
Steve Sutton [Wed, 29 Nov 2017 21:52:32 +0000 (16:52 -0500)]
WIP - work on invoice types add edit
Working currently on how to order it like the categories by hierarchy.
Steve Sutton [Wed, 29 Nov 2017 18:27:47 +0000 (13:27 -0500)]
Updating the settings for billing
Add the invoice types and line items into setting for billing.
Also updated the form for the invoice settings.
Steve Sutton [Wed, 29 Nov 2017 18:26:38 +0000 (13:26 -0500)]
Updating for the data classes
Updating data classes for name changes.
Steve Sutton [Wed, 29 Nov 2017 18:25:56 +0000 (13:25 -0500)]
Updating the database tables.
New db structure for the plugin.
Steve Sutton [Wed, 29 Nov 2017 18:24:57 +0000 (13:24 -0500)]
Rename files for payment to invoices
Renaming things from paymentTypes to invoiceTypes.
Steve Sutton [Wed, 22 Nov 2017 19:38:16 +0000 (14:38 -0500)]
WIP Setup billing tab
Setting up dashboard and list invoice pages for the billing.