MS SQL integration with WordPress and WooCommerce Subscriptions

I need to tie some data to some MS SQL database tables very lightly with a WordPress/WooCommerce subscription purchasing process. So these modifications to the purchase process – are items #1-5 below. Then Item #6 describes a 4-tab dashboard that more thoroughly reads and writes to the MS SQL database from within the WordPress admin area. PLEASE DO NOT BID ON THIS PROJECT UNLESS YOU COMPLETELY UNDERSTAND THIS SO FAR AND UNDERSTAND THE REQUIREMENTS IN THE ATTACHED WORD DOC: I will provide a full copy of the MS SQL database, a full copy of the WordPress site and Administrative access to the live WordPress instance, however I cannot provide FTP access. OK, here are the detailed requirements: 1. Requirement: I need a new field on Subscription Signup: User Name – right above password field on sign up form – we need this for [login to view URL] table field, but we don't need to do anything with WordPress users – no WordPress database field needs to be added – just ignore this field until we get to inserting values in MS SQL (#2 below) 2. Requirement: When one of 3 subscriptions is purchased in WooCommerce, we need to insert a new routine to write a new [login to view URL] table record, and a new [login to view URL] table record in MS SQL, plus we need to learn the ClientID value we get back from MS SQL for our new record (it’s an auto increment field) and write that value to the order_items table in the WordPress db. 3. Requirement: IF a subscription other than these 3 Product IDs (78, 79, 80) is purchased – don’t touch the MS SQL database at all. 4. Requirement: When subscribers cancel their membership to one of the three products (78, 79, 80), we need to change a database table value in MS SQL to prevent app login. 5. Requirement: When subscribers have a credit card decline during RENEWAL – not initial purchase, but RENEWAL, we need to change a database table value in MS SQL to prevent app login. 6. Requirement: In the WordPress backend, we need an admin menu item ‘Simple Source CRM’ below Dashboard, and it should show us a list of our Subscribers similar to the WooCommerce view, but we need to add a link on each record o Clicking this link takes us to a 4 tab view: Settings (default), Users, Customers, and Jobs – o All 4 tabs will have some read-only information as well as forms and fields to update values in each tab. o The fields should asynchronously save, rather than needing a full page refresh, but you can make each form have a save button that saves all fields asynchronously. o The form should display the fields in-line, with 4-5 fields across. o Each field should have its label above the field to save room o Keep it tight and clean looking as much as possible o All asynchronous saves give user feedback = tiny spinning gif o For multi-select lists, I’d like to use the method demonstrated here: [login to view URL] All database field names and details are in the attached Word Doc o Settings tab: Gives basic configuration settings, as an editable asynchronous form  Company Name and Status are populated from and will update [login to view URL] table o Users tab: Gives basic list of Users for the chosen client (key on ClientID), sort by UserLastName DESC – each record is expandable with a (+) at the end of the record to an editable form  Collapsed view shows Nam,e and email as read-only values  Expanded view gives the editable form fields for the expanded User record o Customers tab: Gives basic list of Customers for the chosen client (key on ClientID), each expandable with a (+) at the end of the record to an editable form o Jobs tab: Gives basic list of Jobs for the chosen client (key on ClientID), each expandable with a (+) at the end of the record to an editable form