Đã hoàn thành

6833 Sales Report

This script will only read from the mysql database. No mysql data will be changed. The scipt will create a report of all sales within the specified time period + total sales within taxable states. 1) Identify date range. Start Date = End Date = 2) Identify States which are taxable. There may be multiple states. States will be identified using their 2 letter abreviation. (example New York = NY) 3) Identify email address that report will be sent to. 4) Look in table "tracking" under field tracking_status. If tracking_status = "NS", "W", "PS", or "C" then include it below. (anything else can be skipped) Pending Shipment:NS Warehouse Processing:W Partially Shipped:PS Completed:C 5) Create a CSV report listing each order as documented in "[url removed, login to view]" (use date formation Month-Day-Year for title of file) tracking_date = copy from mySQL tracking_id = copy from mySQL tracking_stateprovtax = copy from mySQL tracking_total = copy from mySQL TOTAL_TAXABLE = SUM of all rows with tracking_stateprovtax = "State identified in Step 3)" * tracking_total TOTAL_SALES = SUM of all tracking_total 6) Email CSV to specified email address + save a copy on the server.

Kĩ năng: Bất kì công việc gì, MySQL, Perl

Xem nhiều hơn: only ny, it sales new york, report example, report w, ns-2, ns#, mysql report, create report, script multiple pending order, multiple warehouse, save report, report table, table tracking, table perl, perl table, report using, database warehouse, sales end, create report using mysql database, save data table file, perl script read file data, range mysql script, csv create save, sales order table database, letter use database

Về Bên Thuê:
( 5 nhận xét )

ID dự án: #1757704

Được trao cho:


Will be done today. Sincerely, Nikita Savin

$35 USD trong 0 ngày
(0 Đánh Giá)