Devam Ediyor

485936 osCommerce Script Update

I have a heavily modded osCommerce store with a custom report script for Monthly Stats.

I need only the Monthly Stats updated.

Custom script for catalog/admin/[url removed, login to view] is attached.

Right now for totals by Customer Group it sorts by ALL CUSTOMERS, RETAIL ONLY, or NON-RETAIL only.

It currently gets this information by reading the database for the "orders" table, then it references the "customers" table to determine the Customer Group.

THE PROBLEM: Some customer records have been deleted so the report is no longer accurate because it does not include any orders where there is no customer record in the database.

THE REPORT NEEDS TO CHANGE TO HAVE IT DETERMINE THE CUSTOMER GROUP FROM THE ORDERS TABLE DIRECTLY USING THE CUSTOM FIELD ALREADY IN PLACE CALLED "group_letter"

So for RETAIL orders it would select all with group_letter R and for NON-RETAIL it would be all other orders where group_letter != R.

This is not a very complex project so please keep the bids reasonable.

Beceriler: Her şey Kabul, e-Ticaret, MySQL, OSCommerce, PHP, Kabuk Betiği

Daha fazlasını görün: select group, problem stats, update store, retail catalog, script place pending orders, keep stats, ecommerce retail, customer record php, oscommerce table, custom script catalog, monthly update, customer record, update store information, group script php, retail place orders, oscommerce database script, update customer database, bids oscommerce, custom field oscommerce, oscommerce report custom, php complex report script, oscommerce project report, database monthly report, field update, script pending orders

İşveren Hakkında:
( 30 değerlendirme ) Penticton, Canada

Proje NO: #2231846