Cancelled

Filter 3 Sales Reports -- OScom CREloaded

I enter some orders as status equals Quote and I do not want those to show up as sales in the sales reports.

I have added field order_type to the order_status table.

I have set order_type to 0 (zero) for the statii that are really sales. Any other settings 1,2,3 etc will be excluded from sales reports.

So I need you to filter the sales reports on that.

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

The query for the sales reports would just need to be modified to include a where order_type = 0 . Other Future reports will key that field too.

Skills: PHP

See more: other sales, n equals, sales`, filter, as 3, sales field, table filter, want sales, equals, reports sales need, sales orders, php show table, oscom, field sales, equals php, creloaded filter, php filter, php creloaded, creloaded modified, jpgus, reports php, php reports

About the Employer:
( 16 reviews ) houston, United States

Project ID: #15003

3 freelancers are bidding on average $33 for this job

baber

Hi, We feel honor in stating that we are an experiened team having more than 5+ years experience and have very strong skills in PHP/MYSQL. Please have a look at our portfolio and we would request to give us a chance to More

$20 USD in 2 days
(5 Reviews)
3.6
RTigger

I have lots of experience with database integration and PHP scripting. Feel free to browse my latest project on www.rtradio.net. I don't expect any difficulties in meeting your design requirements in a quick and effi More

$20 USD in 2 days
(0 Reviews)
0.0
KirtiJDeshkar

I will deliver this within the period.

$60 USD in 5 days
(0 Reviews)
0.0