WP-Plugins/glm-member-db-billing.git
7 years agoUpdating the export account popup.
Steve Sutton [Fri, 30 Mar 2018 12:25:34 +0000 (08:25 -0400)]
Updating the export account popup.

Make the default csv output not html.

7 years agoUpdate list views
Steve Sutton [Fri, 30 Mar 2018 12:20:51 +0000 (08:20 -0400)]
Update list views

Get rid of checkboxes for the invoices page.
Set the autocomplete to submit form on invoices list.

7 years agoUpdate for changes to the dataAbstract
Steve Sutton [Thu, 29 Mar 2018 19:19:50 +0000 (15:19 -0400)]
Update for changes to the dataAbstract

Deal with changes after dataAbstract pointer is updated.

7 years agoFix the memory issue
Steve Sutton [Thu, 29 Mar 2018 18:44:10 +0000 (14:44 -0400)]
Fix the memory issue

remove force_list option from dataAbstract

7 years agoDeal with out of memory issues.
Steve Sutton [Thu, 29 Mar 2018 18:34:55 +0000 (14:34 -0400)]
Deal with out of memory issues.

Give third parameter of true to keep from getting all member data in
pointer type.

7 years agoUpdate the dataAbstract class for accounts.
Steve Sutton [Thu, 29 Mar 2018 18:25:58 +0000 (14:25 -0400)]
Update the dataAbstract class for accounts.

Put the post processing part in if statement to check for it needing to
be used.

7 years agoWhen member account name search changes then submit the form.
Steve Sutton [Thu, 29 Mar 2018 16:08:33 +0000 (12:08 -0400)]
When member account name search changes then submit the form.

Submit form also when it changes and it is empty.

7 years agoAdding settings for allow_employees and membeship_choice
Steve Sutton [Thu, 29 Mar 2018 15:40:28 +0000 (11:40 -0400)]
Adding settings for allow_employees and membeship_choice

Adding two settings.
allow_employees - setup for migcsa
allow_membership_choice - on renew form allow member to choice the
membership level.

7 years agoAdd shortcode for front end renewal form.
Steve Sutton [Thu, 29 Mar 2018 15:02:41 +0000 (11:02 -0400)]
Add shortcode for front end renewal form.

Add the renewal form to the front end.

7 years agoRemove tmux log
Steve Sutton [Thu, 29 Mar 2018 13:05:10 +0000 (09:05 -0400)]
Remove tmux log

Not needed here.

7 years agoUpdate dashboard and account list for php notices.
Steve Sutton [Thu, 29 Mar 2018 13:04:20 +0000 (09:04 -0400)]
Update dashboard and account list for php notices.

Get rid of undefined notices.

7 years agoMore styles for form. Bug fix for invoice creation.
Steve Sutton [Thu, 29 Mar 2018 12:57:48 +0000 (08:57 -0400)]
More styles for form. Bug fix for invoice creation.

When creating invoice for one with emploees make sure not to overwrite
the account_id variable.
Styles for the renew form to have half columns.

7 years agoForm and db updates
Steve Sutton [Wed, 28 Mar 2018 23:44:33 +0000 (19:44 -0400)]
Form and db updates

Update the last db script so the defaults get set for the new fields.
Adding some form styles.

7 years agoUpdate for when employees have no account setup.
Steve Sutton [Wed, 28 Mar 2018 20:50:40 +0000 (16:50 -0400)]
Update for when employees have no account setup.

Create an account for the employee member.

7 years agoUpdate dashboard and account list with filters.
Steve Sutton [Wed, 28 Mar 2018 19:33:58 +0000 (15:33 -0400)]
Update dashboard and account list with filters.

Adding filters for account list.
Adding Active filter.

7 years agoRenew form now is creating invoice and payment to invoice.
Steve Sutton [Wed, 28 Mar 2018 17:10:59 +0000 (13:10 -0400)]
Renew form now is creating invoice and payment to invoice.

Creates an invoice for the membership renewal.
Creates a payment and applies it to that invoice.
Updates the members renewal date.

7 years agoMore database updates
Steve Sutton [Wed, 28 Mar 2018 14:11:38 +0000 (10:11 -0400)]
More database updates

Change the field name from days to create invoice to days to allow
renewal.
Add one for days after renewal to expire membership.

7 years agoUpdate database
Steve Sutton [Wed, 28 Mar 2018 13:10:34 +0000 (09:10 -0400)]
Update database

Adding new field to accounts
archived boolean - marks the account archive.

7 years agoWIP renewal payment processing.
Steve Sutton [Tue, 27 Mar 2018 20:41:31 +0000 (16:41 -0400)]
WIP renewal payment processing.

Create the invoice,
Process Payment,
mark invoice paid and add payment.

7 years agoSetup the account export
Steve Sutton [Tue, 27 Mar 2018 18:05:43 +0000 (14:05 -0400)]
Setup the account export

Con now export billing accounts from dashbeard and the account list
page.

7 years agoWork on setting up member as line item
Steve Sutton [Mon, 26 Mar 2018 11:04:10 +0000 (07:04 -0400)]
Work on setting up member as line item

working on the renewal process.

7 years agoWIP: Renew member process
Steve Sutton [Fri, 23 Mar 2018 20:46:28 +0000 (16:46 -0400)]
WIP: Renew member process

Working on the process for renew member and their employees.

7 years agoAdding renew page.
Steve Sutton [Fri, 23 Mar 2018 19:19:58 +0000 (15:19 -0400)]
Adding renew page.

Working on the renew page for members.
Showing their employees.
Select unselecting them will update the total amount for the page.

7 years agoFix notice
Steve Sutton [Thu, 22 Mar 2018 17:46:46 +0000 (13:46 -0400)]
Fix notice

This is to fix a notice from logs.

7 years agoUpdate the billing dashboard and search.
Steve Sutton [Wed, 21 Mar 2018 20:50:08 +0000 (16:50 -0400)]
Update the billing dashboard and search.

Now the dash board shows member accounts pending and overdue.
The search for the dashboard and billing are now in it's own template.
I added filter search for expired accounts.

7 years agoStart for create invoice scripting.
Steve Sutton [Tue, 20 Mar 2018 19:54:10 +0000 (15:54 -0400)]
Start for create invoice scripting.

This will be for the ajax cron task.

7 years agoUpdate create db script
Steve Sutton [Tue, 20 Mar 2018 19:53:08 +0000 (15:53 -0400)]
Update create db script

Fix error in create script

7 years agoUpdate order by and list for dashboard
Steve Sutton [Tue, 20 Mar 2018 18:00:35 +0000 (14:00 -0400)]
Update order by and list for dashboard

Updating the doashboard list to match the invoice order by.

7 years agoMake member name a link to member billing in dashboard.
Steve Sutton [Tue, 20 Mar 2018 17:42:41 +0000 (13:42 -0400)]
Make member name a link to member billing in dashboard.

Add member links to the list.

7 years agoUpdate the dash board back.
Steve Sutton [Tue, 20 Mar 2018 13:28:52 +0000 (09:28 -0400)]
Update the dash board back.

Adding the search for invoices into the dashboard.

7 years agoRemove billing create invoices.
Steve Sutton [Mon, 19 Mar 2018 17:23:05 +0000 (13:23 -0400)]
Remove billing create invoices.

This will become a cron tasks.

7 years agoUpdate name search on the account list page.
Steve Sutton [Mon, 19 Mar 2018 17:06:29 +0000 (13:06 -0400)]
Update name search on the account list page.

Now will search text string in member name.

7 years agoHide name search until it is complete
Steve Sutton [Mon, 19 Mar 2018 16:55:19 +0000 (12:55 -0400)]
Hide name search until it is complete

Getting ready for show to client

7 years agoAlign right the th labels
Steve Sutton [Mon, 19 Mar 2018 16:35:59 +0000 (12:35 -0400)]
Align right the th labels

Text alignment for the add or edit labels.

7 years agoUpdate table name
Steve Sutton [Mon, 19 Mar 2018 16:32:47 +0000 (12:32 -0400)]
Update table name

member_type

7 years agoAdd member type to the edit invoice
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

7 years agoAdding new field for the member_type
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.

7 years agoUpdate the order by for invoices
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

7 years agoUpdate for getting settings
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

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.