WP-Plugins/glm-member-db-billing.git
7 years agoOnly show pay invoice if payment is due
Steve Sutton [Wed, 11 Apr 2018 14:48:32 +0000 (10:48 -0400)]
Only show pay invoice if payment is due

Check if balance is not set.

7 years agono debug output
Steve Sutton [Wed, 11 Apr 2018 14:38:46 +0000 (10:38 -0400)]
no debug output

remove debug output

7 years agoUpdate for save card.
Steve Sutton [Wed, 11 Apr 2018 14:15:32 +0000 (10:15 -0400)]
Update for save card.

Can only be used if proc_method is Authorize.net

7 years agoSet the print and pay invoice buttons so there too far right.
Steve Sutton [Wed, 11 Apr 2018 10:51:49 +0000 (06:51 -0400)]
Set the print and pay invoice buttons so there too far right.

Setting a wrapper around them and setting a max width.

7 years agoAdd pay invoice button to invoice.
Steve Sutton [Wed, 11 Apr 2018 10:32:34 +0000 (06:32 -0400)]
Add pay invoice button to invoice.

For member view of the invoice. Adding a pay Invoice button.

7 years agoDb updates and testing renewal forms
Steve Sutton [Tue, 10 Apr 2018 20:54:59 +0000 (16:54 -0400)]
Db updates and testing renewal forms

Adding new field for invioces so we know which is used for renewals.
If account has one then don't show the renewal form.

7 years agoUpdating front end renewal form
Steve Sutton [Mon, 9 Apr 2018 20:56:33 +0000 (16:56 -0400)]
Updating front end renewal form

Update for how price total is setup

7 years agoWIP updating renewal form on front end.
Steve Sutton [Mon, 9 Apr 2018 09:42:03 +0000 (05:42 -0400)]
WIP updating renewal form on front end.

Updating front end renewal form.

7 years agoSaving Authorize.net CIM data
Steve Sutton [Fri, 6 Apr 2018 21:01:40 +0000 (17:01 -0400)]
Saving Authorize.net CIM data

Now billing saves the card profile for renewal.
Need to test pay invoice again and update front end renewal form to use
the new smarty template for payment section of the renewal payment form.

7 years agoUpdating db with payment fields for Authorize.net CIM
Steve Sutton [Fri, 6 Apr 2018 19:57:04 +0000 (15:57 -0400)]
Updating db with payment fields for Authorize.net CIM

CIM Authorize.net to save the credit card on authorize.net.

7 years agoFix conflict with same validAction ajax call as registrations.
Steve Sutton [Fri, 6 Apr 2018 15:03:53 +0000 (11:03 -0400)]
Fix conflict with same validAction ajax call as registrations.

Need to keep ajax admin call names unique.

7 years agoUpdate price format for total
Steve Sutton [Fri, 6 Apr 2018 13:32:37 +0000 (09:32 -0400)]
Update price format for total

Use money format.

7 years agoBilling updates for renewal form processing.
Steve Sutton [Thu, 5 Apr 2018 20:37:38 +0000 (16:37 -0400)]
Billing updates for renewal form processing.

Updating the text on the renewal form for Membership Renewal.
adding payment option for pay by check.
showing the invoice after the submit is done.
change name of submit button to Submit Membership Renewal.
adding table layout for the renewal form sections  for choosing
the member type and employees so prices line up.

Fix the issue with incorrect class was being pulled for employees.
Also updated the employee list so if they don't have a payable member
type then they won't show up in the renewal form.

7 years agoUpdate for database.
Steve Sutton [Thu, 5 Apr 2018 17:11:01 +0000 (13:11 -0400)]
Update for database.

Add account column for line items table.

7 years agoSet anniversary_date when adding accounts.
Steve Sutton [Thu, 5 Apr 2018 12:46:33 +0000 (08:46 -0400)]
Set anniversary_date when adding accounts.

When adding accouunts for employees need to set the anniversary date.

7 years agoIf no account found for front end renewal form give message.
Steve Sutton [Thu, 5 Apr 2018 12:07:38 +0000 (08:07 -0400)]
If no account found for front end renewal form give message.

Give a message that you must be logged in with member account.

7 years agoWIP: get accounts with renewal dates
Steve Sutton [Tue, 3 Apr 2018 20:56:21 +0000 (16:56 -0400)]
WIP: get accounts with renewal dates

Working on getting accounts for a notificition based on renewal date
before.

7 years agoUpdate for cron task
Steve Sutton [Tue, 3 Apr 2018 20:15:46 +0000 (16:15 -0400)]
Update for cron task

update cron task to get accounts by renewal dates.

7 years agoUpdate account search
Steve Sutton [Tue, 3 Apr 2018 15:43:47 +0000 (11:43 -0400)]
Update account search

Submit form when any filter is clicked.

7 years agoUpdating payment page for admin.
Steve Sutton [Tue, 3 Apr 2018 15:36:57 +0000 (11:36 -0400)]
Updating payment page for admin.

Adding lookup for account invoices.
Mark each invoice as paid.

7 years agoWIP working on generic payment page.
Steve Sutton [Mon, 2 Apr 2018 20:46:02 +0000 (16:46 -0400)]
WIP working on generic payment page.

Working on pulling in the unpaid invoices for an account when they look
up by account name. Getting the list of invoices.
Need to put into the payment form.

7 years agoUpdating the support class
Steve Sutton [Mon, 2 Apr 2018 20:45:21 +0000 (16:45 -0400)]
Updating the support class

Separate out the payment processing part.
Can now do multiple invoices.

7 years agoWorking on the members pay invoice page.
Steve Sutton [Mon, 2 Apr 2018 09:32:21 +0000 (05:32 -0400)]
Working on the members pay invoice page.

Need to separate the payment processing part.

7 years agoUpdate docs for each method in billing support class
Steve Sutton [Fri, 30 Mar 2018 18:53:32 +0000 (14:53 -0400)]
Update docs for each method in billing support class

Making sure to include php docblocks for each billingSupport method.

7 years agoUpdate view for the invoice.
Steve Sutton [Fri, 30 Mar 2018 13:49:54 +0000 (09:49 -0400)]
Update view for the invoice.

When getting the payment data for viewing invoice need to get payment
data not invoice_payment data.

7 years agoFor errors when processing renewal form.
Steve Sutton [Fri, 30 Mar 2018 13:25:22 +0000 (09:25 -0400)]
For errors when processing renewal form.

Give error messages when processing renewal form.

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