Custom Project - Part1 Apr 11 2013 11:06:10
Bütçe $900 AUD
When opening page, popup must appear with request to enter user sopic ID
That info is entered into a db table and used later in xml export.
Quote Number - Load
when user inputs quote number and clicks load, main quote view loads info from:
database: PQDB, table: quotes.
showing dxf filenames in a quote page as well.
columns mapping:
Quote# = QuoteID
Customer ID = ClientID
Description = QuoteLineItems\Description
Spec = QuoteLineItems\Spec
Thick = QuoteLineItems\Thick
Total =
Settings:
Original by date = Today + Laser lead time
Original ETA Date = Today + Laser lead time + Urgency
Freight Charges (dropdown list)- Store Freight Charge, fixed freight charge,freight forward, pickup , FIS.
Urgency (dropdown list) - Normal, In hurry - 1day, desperate - 2 days.
Delivery Area (dropdown list) - in town +1day, local courier + 1day, overnight + 2 days, Interstate + 6 days.
Warehouse (dropdown list) - Aucland, Christchurch.
Comments: user can input comment.
When customer entered all details, clicks “submit” gets popup confirmation screen.
Confirmation Popup.
Quote# - quote number that user loaded
Order Number# PO that user input on first page
Customer # - If customerID not = format, then load from sopicqecustomers.
Customer name - If customerID not = format, then load from sopicqecustomers.
customer address - If customerID not = format, then load from sopicqecustomers.
By Date = by date + eta date + Urgency
Job Items - loaded from psql
Jobs comments from user input on first page
Salesman - sopic id (that user enters at the beginning)
After verification user clicks confirm and all information entered into database and ready to be exported to xml.
Backend XML export Script.
automatic script that will export data from sql table to xml
XML Mapping
a. Customer number - Customer Number
b. Customer Reference - PO
c. Delivering stock Id -
d. Staff Id - sopc ID
e. Issuer Id -
f. Product code -
g. Quantity -
h. Header comment 1
i. Header comment 2
j. Header comment 3
k. Line comment 1
l. Line comment 2
m. Line comment 3
n. Include on Sopic documents