WP-Plugins/glm-member-db-billing.git
7 years agoAdd new db field for settings
Steve Sutton [Sat, 17 Mar 2018 18:54:27 +0000 (14:54 -0400)]
Add new db field for settings

New setting days before invoice

7 years agoAdd account name search to account list page.
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.

7 years agoUpdate member only menu
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.

7 years agoUpdate invoice page to have links to member billing tab
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.

7 years agoFix add payment page
Steve Sutton [Fri, 16 Mar 2018 18:02:45 +0000 (14:02 -0400)]
Fix add payment page

Get simple list of accounts.

7 years agoAdding filters for pending and overdue
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.

7 years agoUpdating the getStats call
Steve Sutton [Fri, 16 Mar 2018 16:54:16 +0000 (12:54 -0400)]
Updating the getStats call

Passing $where part

7 years agoUpdate dateformat for account page
Steve Sutton [Fri, 16 Mar 2018 16:48:17 +0000 (12:48 -0400)]
Update dateformat for account page

Update the dateFormat for datepickers

7 years agoUpdate the dateFormat for datepicker
Steve Sutton [Fri, 16 Mar 2018 16:43:51 +0000 (12:43 -0400)]
Update the dateFormat for datepicker

Needs to be set.

7 years agoAdd total count to account list page.
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.

7 years agoUpdate list invoices to show total invoice count.
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.

7 years agoUpdate list views for sessions
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.

7 years agoUpdate text
Steve Sutton [Fri, 16 Mar 2018 15:32:40 +0000 (11:32 -0400)]
Update text

Had Events in there.

7 years agoFinish the create Invoice for MiGCSA
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.

7 years agoTrying to setup 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.

7 years agoStart setup of import script for migcsa to create invoices
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.

7 years agoUpdating invoice and statement list
Steve Sutton [Thu, 15 Mar 2018 19:01:55 +0000 (15:01 -0400)]
Updating invoice and statement list

Adding in the line items.

7 years agoAdd line items to invoice
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

7 years agoCreate indexes on tables.
Steve Sutton [Thu, 15 Mar 2018 16:08:45 +0000 (12:08 -0400)]
Create indexes on tables.

Creating indexes on the tables.

7 years agoUpdate databastract for accounts
Steve Sutton [Thu, 15 Mar 2018 15:43:51 +0000 (11:43 -0400)]
Update databastract for accounts

Add method for getting simple account list.

7 years agoUpdate name of create db script
Steve Sutton [Wed, 14 Mar 2018 19:52:25 +0000 (15:52 -0400)]
Update name of create db script

for newer version.

7 years agoUpdate dashboard to show list of invoices.
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.

7 years agoHide payment methods
Steve Sutton [Wed, 14 Mar 2018 17:38:33 +0000 (13:38 -0400)]
Hide payment methods

won't be used currently.

7 years agoFix bug in payments
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.

7 years agoUpdate account next anniversary date.
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.

7 years agoFix sending email notifications for payments and invoices
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.

7 years agoWIP work on notifications
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.

7 years agoWork on 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.

7 years agoUpdate the statements 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.

7 years agoSome code clean up and adding styles for text alignment.
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.

7 years agoUpdate payment form for validation.
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.

7 years agoAdd size suggestion for image
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.

7 years agoAdd the due date
Steve Sutton [Sat, 10 Mar 2018 14:17:40 +0000 (09:17 -0500)]
Add the due date

Adding Due Date to the printable invoice.

7 years agoAdd check for http in url
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.

7 years agoLast minute edits from work.
Steve Sutton [Sat, 10 Mar 2018 14:05:11 +0000 (09:05 -0500)]
Last minute edits from work.

invoices
Adding amount to invoice

7 years agoWIP: Invoice page, Create Payment (member side)
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.

7 years agoWIP setup form for adding custom line items.
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.

7 years agoDB Update, work on add invoice page.
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.

7 years agoUpdate list pages. Update invoices create page.
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.

7 years agoPayment form, filters and debugging.
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.

7 years agoAdding billing payment form
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.

7 years agoAdding account list page and update search filters invoices.
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.

7 years agoUpdate code
Steve Sutton [Tue, 6 Feb 2018 19:32:07 +0000 (14:32 -0500)]
Update code

adding docs

7 years agoAdd new Invoice now adds new account.
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.

7 years agoWIP for add account on 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.

7 years agoAdding list for pending and overdue to billing dashboard.
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.

7 years agoUpdate the edit invoice page for member account selection.
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.

7 years agoClean up code.
Steve Sutton [Tue, 30 Jan 2018 17:37:28 +0000 (12:37 -0500)]
Clean up code.

Removing test of notifications.

7 years agoDon't remove the queue just mark it processed.
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.

7 years agoRemove the notification type test link
Steve Sutton [Thu, 18 Jan 2018 18:02:16 +0000 (13:02 -0500)]
Remove the notification type test link

Removed.

7 years agoSetup crons for notifications and paging and search on invoices.
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.

7 years agoUpdate the account edit page with new field.
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.

7 years agoAdd new field 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.

7 years agoSetup 2 cron task style ajax models.
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.

7 years agoWIP Setting up cron action for getting notifications.
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.

7 years agoWIP billing notifications
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.

7 years agoAdding print button for the invoices.
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.

7 years agoWorking on setup for sending emails when creating invoices.
Steve Sutton [Wed, 27 Dec 2017 21:33:10 +0000 (16:33 -0500)]
Working on setup for sending emails when creating invoices.

7 years agoinitialize variable.
Steve Sutton [Wed, 27 Dec 2017 15:48:28 +0000 (10:48 -0500)]
initialize variable.

Initialize the invoiceHtml.

7 years agoAdding setting for payment_terms
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.

7 years agoAdding new table to save invoice payment data.
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.

7 years agoUpdate dbversion and work on 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.

7 years agoUpdate for the line items on invoice
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

7 years agoWIP for invoice view and print version.
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.

7 years agoWIP billing invoice template
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.

7 years agoNew code comments.
Steve Sutton [Thu, 14 Dec 2017 21:41:24 +0000 (16:41 -0500)]
New code comments.

Commenting more of the code for notification types.

7 years agoAdding to the billing dashboard.
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.

7 years agoSetup emails from the notifications.
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.

7 years agoUpdating the db scripts
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

7 years agoWIP for notifirations
Steve Sutton [Tue, 12 Dec 2017 21:59:01 +0000 (16:59 -0500)]
WIP for notifirations

For sending out emails.

7 years agoMoved this into management
Steve Sutton [Tue, 12 Dec 2017 20:36:17 +0000 (15:36 -0500)]
Moved this into management

Removing from settings.

7 years agoSave management settings. Payment Gateway 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.

7 years agoAdding new table for management, payments list, and add fpdf library.
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.

7 years agoupdates for statements
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.

7 years agoCreating methods in support class for member statements.
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.

7 years agoSetup the member statement model view and setup support class.
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.

7 years agoAdding payment library
Steve Sutton [Fri, 8 Dec 2017 21:48:31 +0000 (16:48 -0500)]
Adding payment library

also updating the member billing statement model view.

7 years agoWIP adding account form for member billing tab
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.

7 years agoDue date and notes being saved now.
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.

7 years agoWIP invioces
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.

7 years agoWork on select for invoice line items and saving transaction time.
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

7 years agoWIP for adding invoice line items
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.

7 years agoWIP for adding create invoice page
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.

7 years agoUpdate the edit form so it shows errors
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.

7 years agoWIP work on the edit add page for notificationTypes
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.

7 years agoWIP for the edit part of notification types.
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.

7 years agoUpdate for the header links in billing tab
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.

7 years agoOutput trigger for notifications on notification types list.
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.

7 years agoUpdate for adding notification types
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.

7 years agoInvoice types - parent ordering of invoice 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.

7 years agoWIP - work on invoice types add edit
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.

7 years agoUpdating the settings for billing
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.

7 years agoUpdating for the data classes
Steve Sutton [Wed, 29 Nov 2017 18:26:38 +0000 (13:26 -0500)]
Updating for the data classes

Updating data classes for name changes.

7 years agoUpdating the database tables.
Steve Sutton [Wed, 29 Nov 2017 18:25:56 +0000 (13:25 -0500)]
Updating the database tables.

New db structure for the plugin.

7 years agoRename files for payment to invoices
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.

7 years agoWIP Setup billing tab
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.

7 years agoUpdate field data type for payment_types.qcode
Steve Sutton [Wed, 22 Nov 2017 17:01:15 +0000 (12:01 -0500)]
Update field data type for payment_types.qcode

make it tinytext and not required.

7 years agoUpdate the view file for payment types
Steve Sutton [Wed, 22 Nov 2017 16:50:23 +0000 (11:50 -0500)]
Update the view file for payment types

Update for getting the dynamic flag to save.

7 years agoPayment Types now added to settings page.
Steve Sutton [Tue, 21 Nov 2017 21:34:55 +0000 (16:34 -0500)]
Payment Types now added to settings page.

Can now List, Add, Edit, Delete payment types.

7 years agoUpdate the management into settings.
Steve Sutton [Tue, 21 Nov 2017 19:05:50 +0000 (14:05 -0500)]
Update the management into settings.

Adding two new fields for from and message for notifications.