Find Jobs
Hire Freelancers

Changes to Dealer Order Entry Page

$30-100 USD

已完成
已发布超过 19 年前

$30-100 USD

货到付款
We'd like these changes to be made to our existing Dealer Order Entry Website: A: The processing is done with PHP. Reformat the body of the email confirmation to Dealer & to us to make it easier to read and to prepare the emails for our automatic processing of data. B: We’d also like the program to gather / sort the data from the SQL database on the website, put it into an Excel page (or something like it in PHP), and automatically upload an .HTM copy to the Dealer’s page (it’s easier to view in Excel). As an example, they should be able to view it at their assigned page. We'll also be using that same copy to generate our internal work orders until the process is better automated. C: We need to add a specific box on our Admin form where we can send a short “broadcast message?? to alert Dealers about order delays or Holiday work days. The message should only be sent to dealers who have open orders with us (otherwise, it becomes spam). D: The order entry form should look a bit more like the original form I requested, with multi-lines for data entry. E: On the Admin sign-in page, after you sign in it says, "You know where to go from here, right?". I'd like that replaced with a link I can click (like on the Dealer Oreder entry pages) or you may have it take me there automatically, please. ## Deliverables (1) We'd like these changes to be made to our Dealer Order Entry Website: A: Reformat the body of the email confirmation to Dealer & to us to make it easier to read and to prepare the emails for our automatic processing of data. The revised format of a typical email order should look like this: Superior, 909 Swanson Ave, DeSoto MO 43612 PO#1234567 | 1 set (3 pieces) | Grey - Madeira 1041 on Black tape | Wording: R. BARCLAY | Comments: 1/2" BLOCK LETTERS PO #7654321 | 2 sets (6 pieces) | Olive - Madeira 1357 (not drab) on Black tape | Wording: R. BARCLAY | Comments:1/2" BLOCK LETTERS Note how the “pipe?? symbol, “|??, is used as a delimiter. These will aide us in the next step where we transform the raw data into a work order. If you have a better symbol to use, we'll consider that. B: We’d also like a program to gather / sort the data from the SQL database on the website, put it into an Excel page (or PHP), and automatically upload an .HTM copy to the Dealer’s page (it’s easier to view in Excel). As an example, they should be able to view it at their assigned page. We'll also be using that same copy to generate our internal work orders until the process is better automated. We currently do the same thing manually for a customer, and you can view a sample of what we'd expect by looking at: <[login to view URL]> C: We need to add a specific box on our Admin form where we can send a short “broadcast message?? to alert Dealers about order delays or Holiday work days. The message should only be sent to dealers who have open orders with us (otherwise, it becomes spam). D: The order entry form should look a bit more like the original form I requested, with multi-lines for data entry. Entering one name at a time is slow and frustrating for the customers. A picture of the original form requested in the original bid request is shown here: <[login to view URL]> I don’t think the form needs to be as long as the one in the picture, but it should allow up to 15 names to be entered. After the 15 names are entered, it should offer the option to enter more names by looping back to enter more names as part of the same order. E: On the Admin sign-in page, after you sign in it says, "You know where to go from here, right?". I'd like that replaced with a link I can click or you may have it take me there automatically, please. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform PHP & MySQL on a UNIX server
项目 ID: 3421620

关于此项目

1条提案
远程项目
活跃19 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
See private message.
$85 USD 在26天之内
4.9 (53条评论)
5.2
5.2

关于客户

UNITED STATES的国旗
United States
3.1
3
会员自10月 3, 2003起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。