Dan Dembinski
|
733226650f
|
added a commented out section allowing for hardcoded invoice date
|
2022-01-18 16:06:31 -05:00 |
|
Dan Dembinski
|
b83e181c47
|
Fix bat file argument. Adding Company Name to address block. Add option to "un-send" an email. This marks the InvoiceSent column as False. You can then re-test and re-send the mail. This doesn't remove the original email history from the SentInvoice table, and resending the email will add a new record to the table. Orders can be un-sent via the Invoice Number or Order Number
|
2021-05-28 16:26:05 -04:00 |
|
Dan Dembinski
|
64d913572c
|
Matt is gone. Changed email to Carla. Changed test emails. Added argument position to bat file. Updated main.py to take bat arguement as xlsx fileName. Can now drag and drop invoice spreadsheet onto the bat file to load it into the database.
|
2021-05-28 12:33:51 -04:00 |
|
Dan Dembinski
|
909b12ff6c
|
Added bat file to source correct venv and run script. Reorganized db connection stuff and added check to create db/tables if they don't exist. Uncommented email section and set mark_sent method to only be called if not testing.
|
2021-04-08 10:58:01 -04:00 |
|
Dan Dembinski
|
82ad72007c
|
Commented out sendmail parts for testing. Added SentInvoice table that tracks when invoices were sent. Added InvoiceID and InvoiceSent columns to Invoice table. Now tracks which invoices haven't been sent and only sends those. Once hte invoice has been sent it marks it has having been sent in the database and adds the date to the SentInvoice table. Started adding parts to allow xlsx filent not to be hardcoded. Updated TableSetup using the PyCharm autogeneric SQL thing.
|
2021-04-01 15:52:47 -04:00 |
|
Dan Dembinski
|
ae4d6c1a1f
|
Added Printing Concepts relay as the smtp server and switched my cc email back to gll domain. All works now
|
2021-03-24 14:26:46 -04:00 |
|
Dan Dembinski
|
bf2d1b3f99
|
updated the main menu loop so that it's possible to send live emails. Converting the OrderDate variable to a time object it can be formatted in the email body. Switched to send_message to handle Cc and Bcc better. Now sending from Matt's email. Test email set to external address. Matt cannot use mail relay for external mail, waiting for Keystone to advise.
|
2021-03-23 15:23:52 -04:00 |
|
Dan Dembinski
|
56722752ac
|
Added shipping information. Pulls list of all documentIDs per Order. Looks up individual DocumentID information. Added Address Block and Item Detail Block to Invoice HTML. Added BCC and CC testing addresses.
|
2021-03-20 00:25:58 -04:00 |
|
Dan Dembinski
|
5720ac4dbb
|
Added some comments
|
2021-03-19 02:28:08 -04:00 |
|
Dan Dembinski
|
12c4722fe9
|
Initial commit. Loads XLSX file from accounting into sqlite database. Sends HTML email. Started adding variable parts to body pulled from database.
|
2021-03-19 02:22:53 -04:00 |
|