Write some Software

We are looking for a freelancer with a very good level of expertise in PHP, MySQL, Microsoft SQL Server, Apache, IIS 7.x and knowledge of open source software Process Maker . We want that all the software running under Windows Server. We have set up a dev server than you can access and work there. We need the Freelancer implement the following four stages: 1) We need to modify the open source software Process Maker so we can have single sign on when called from an iframe from DotNetNuke (DNN). DNN will pass a GUID through a post or get request in an IFRAME and Process Maker shall query a MS SQL (Microsoft SQL) database and get all user data and login in the Process Maker. If the user does not exist in the Process Maker, it must be created and upload all user data from the DNN through a store procedure, and also then login in Process Maker. After that it must load tables groups and user roles from DNN into the Process Maker user´s and group tables. ** 2) Modify the Process Maker to run from an Iframe. It Is not a native feature of the Process Maker to run in an Iframe 3) We need to install the Process Maker on an IIS 7.x (Microsoft web server) instead of an Apache. And also should document how PHP configurations and IIS and Process Maker are made. 4) Modify the Process Maker to run with MS SQL instead of MySql. ** Clarification of point 1) . The DotNetNuke (or DNN) is going to call through an Iframe (before we can try with an urn ) with a link to the Process Maker with a parameter called GUID in the url with a value (GUID) that belongs to the user that is impersonated in the DNN: [login to view URL] When the Process Maker loads, read the query string, reads the parameter GUID and get the value, in this example the parameter value is “GUID=7c9e6679-7425-40de-944b-e07fc1f90ae7 “, after that the Process Maker should execute a store procedure of the Microsoft SQL Database of the DotNetNuke (DNN) and receives a data set with all the user data that needs to login only or register and login in the Process Maker . You have to execute in the Process Maker the following Microsoft SQL Server Store Procedure with the parameter received in the url query string EXEC [dbo].[InnovActionGetUserFromToken] '103FC65F-A924-4EC7-8FAD-6F5E224B7783' This execution will respond with a date set like the following: GUIDToken UserID Username FirstName LastName Email DisplayName 103FC65F-A924-4EC7-8FAD-6F5E224B7783 6 OfeliaAlvarez ELSA OFELIA ALVAREZ - ELSA OFELIA ALVAREZ *The first column you do not need to use. Here we have two cases: 1) The users exists in the Process Maker, then the only thing that the new software have to do is to login and renew the user data (refresh the user data if there is any change, for example is the email was changed or another data of the user ) . 2) If the user does not exist in the Process Maker, the software should register the new user and then login in the system (creates and login). The last thing that we need is to get the users roles of the user and assign to the new user in the Process Maker. (We are going to clarify next)