21 Commits

Author	SHA1	Message	Date
johnnyq	cf2c9c2d9b	Let clients pay the card fee - turn on Clients pay the card fee on Stripe in Admin > Payment Providers with Stripe's percent and fixed rate, and each card payment in the client portal, through an invoice's link, by autopay or from Charge Saved Card is grossed up so Stripe's fee comes out of it, with one fee per payment shared over its invoices; the fee is shown before paying (Pay invoices, checkout, the guest pay page, invoice pages, autopay and the Charge Saved Card window) and goes on each invoice as a Card Fee line with no tax when the payment is booked, carried in the PaymentIntent's itflow_fees metadata and checked against the amount received to the cent; a client can be let off it with No card fee on their Billing tab, refunding a card payment takes its Card Fee line back off, autopay and Charge Saved Card now compare cents instead of whole dollars, database 3.5.6 adds the provider and client columns, changelog updated	2026-11-05 12:47:06 -05:00
johnnyq	e472c95a11	Record Stripe fees every 15 minutes instead of once a night - a new Payment Provider Fees cron job runs the fee recorder that Nightly Tasks used to, Nightly Tasks no longer does, the recorder holds a lock so the job and Record fees now can't both record the same fee, and the payment provider screens no longer say fees are recorded each night	2026-11-04 14:38:32 -05:00
johnnyq	8d3fbcb2ab	Payment Providers stage 3: the providers list shows card payments in the last 30 days with their total and the last payment date, and fees recorded in 30 days with a count of payments whose fee is still to record, flagged once more than two days old; adds Check connection, which reports the Stripe account the saved key belongs to or why it is not connected, and Record fees now, which runs the nightly fee reconciliation on demand through the same shared function the nightly job now uses; Settings > Invoices and billing shows how card payments stand under Paid online, and the Settings overview flags test keys, card payments going into an archived account, and Stripe fees not being recorded, with the Invoices and billing tile showing whether cards are on; overview warnings keep their button beside the text where there is room	2026-10-20 16:17:32 -04:00
johnnyq	a165189cc3	Payment Providers stage 1: list rebuilt in the standard pattern showing on or off, live or test mode from the keys, where payments go, the card limit, whether fees are recorded, saved cards with autopay and the last card payment; providers can be turned off and on, and delete states the saved cards, autopay and client links that go with it; Add and Edit share one window that no longer shows the secret key and checks the keys, the live and test mode match, the card limit and the fee vendor and category, and checks new keys with Stripe before anything is saved, showing problems beside each field; fees use a single record-fees switch with vendor and category; changes are logged from old to new value with keys logged only as changed; fixes a rejected Stripe key being saved, the empty provider name and PHP warnings on edit, the ignored enable expense switch, and the stale Online Payment path in the account archive message	2026-10-20 14:16:27 -04:00
Wrongecho	5a925f8784	Move payment provider post vars to a model to reduce repetition	2026-08-30 15:12:14 +01:00
Wrongecho	318eb7cf77	Stripe - Warn the user if the secret key is not valid during provider add/edit	2026-08-30 15:06:32 +01:00
johnnyq	75d8b4d37c	Fix get FieldByID spots	2026-07-29 16:16:32 -04:00
johnnyq	af51c4316f	Updated validateCSRFToken to automatically grab and compare get or post csrf token no longer need to pass an argument to the function which fixed the issue if no hash was present	2026-07-24 13:40:37 -04:00
johnnyq	5402578ce6	Remove Static payment processing fees from database and update field hints with useful info when adding / editing payment provider	2026-07-22 17:32:01 -04:00
johnnyq	b8873039a4	Rename Functions: flash_alert, sanitizeFilename and display_folder_options using camelCase instead to match other custom php functions	2026-07-14 17:41:41 -04:00
johnnyq	f1836c70cd	Replace Function logAction() with logAudit()	2026-07-14 17:35:23 -04:00
johnnyq	b57ddc0e5c	Replace Function sanitizeInput() with just escapeSql() and update all instances throughout	2026-07-14 17:17:50 -04:00
johnnyq	27fde82aff	Fixed Adding Payment provider not adding an account, now adding you can customize the income/expense account, expense category, and Expense vendor. Moved Saved Payment Provider Methods into Payment Providers as a link instead of on the admin side nav. Same with AI Provider and AI Models.	2025-12-12 16:42:09 -05:00
johnnyq	aba5ed9271	Add Back Delete Payment Provider, the db will cascade delete all related recurring payments, related saved cards and client payment provider relation	2025-11-16 17:12:02 -05:00
wrongecho	6d3351b2f7	Payment providers bug-fixing	2025-09-22 11:53:49 +01:00
wrongecho	c016b67c3a	Fix typo in sql query field, matching develop back to master because we screwed up the flow	2025-09-08 15:26:57 +01:00
johnnyq	535078b0ab	Fix Bad vars in PAyment Providers listing, add check to see if payment provider already exists	2025-08-27 16:27:54 -04:00
johnnyq	fae7e76721	Remove logging comments as its implied in admin also if returning 1 field for logging use getFieldById Function	2025-08-01 18:08:02 -04:00
johnnyq	012b0f1a77	Update Admin posts to use new functions flash_alert and getFieldById which greatly cleans up and reduces the code also removed logging comments as implied by the function logAction	2025-08-01 17:21:35 -04:00
johnnyq	d2dac1915d	Update admin, user, guest and client post to use new redirect function	2025-08-01 15:25:52 -04:00
johnnyq	0494bfc1cf	Moved admin_ to /admin, user_ to user report_ to /reports each have their own post includes modals directories created seperate headers and footer. Also did the same for xcustom, more work to me done	2025-07-28 13:32:28 -04:00