Skip to content

Instantly share code, notes, and snippets.

@laspluviosillas
Forked from mayra-cabrera/gist:10418475
Last active August 29, 2015 13:59
Show Gist options
  • Save laspluviosillas/10488388 to your computer and use it in GitHub Desktop.
Save laspluviosillas/10488388 to your computer and use it in GitHub Desktop.

Problem with Products & Offerings

  • These products are included in the wsProducts script, but not in wsOfferings script. As a result, the home page shows the following products with a price of zero:

Total: 48 from 117

OSG ID Name
247 Office Ergonomics
215 Defensive Driving Course
214 Front End Loader Training
213 Safe Chainsaw Handling
212 Advanced Industrial Ergonomics Training
211 Ergonomic Assessment
207 Skid Steer Evaluation
206 Safe Operation of Hoists Evaluation
205 Safe Operation of Hoists
204 Safe Operation of a Telehandler Lift Truck Train-the-Trainer Evaluation
203 Safe Operation of a Telehandler Lift Truck Evaluation
202 Safe Operation of a Telehandler Lift Truck Train-the-Trainer
201 Safe Operation of a Telehandler Lift Truck
200 Safe Operation of a Bucket Truck Train-the-Trainer Evaluation
199 Safe Operation of a Bucket Truck Evaluation
198 Safe Operation of a Bucket Truck Train-the-Trainer
197 Safe Operation of a Bucket Truck
196 Safe Operation of a Mobile Boom Crane Evaluation (up to 8 tonnes)
195 Safe Operation of a Mobile Boom Crane Train-the-Trainer Evaluation (up to 8 tonnes)
194 Safe Operation of a Mobile Boom Crane Train-the-Trainer (up to 8 tonnes)
193 Safe Operation of a Mobile Boom Crane (up to 8 tonnes)
172 Workplace Violence and Harassment Program Development
171 Workplace Violence Risk Assessment
159 Noise Sampling
158 Air Sampling (Indoor Air Quality Testing)
128 Skid Steer Training
116 Respirator Fit Testing
111 Policies & Procedures Training & Development
108 Overhead Crane Evaluation
107 Overhead Crane Train-the-Trainer Evaluation
94 Lift Truck Train-the-Trainer Re-Evaluation
93 Lift Truck Train-the-Trainer Evaluation
91 Lift Truck Re-Evaluation
90 Lift Truck Evaluation
54 Electric Pallet Truck Train-the-Trainer Evaluation
51 Electric Pallet Truck Evaluation
42 Course Customization
33 Aerial Work Platforms Train-the-Trainer Evaluation
31 Aerial Work Platforms Evaluation
26 Standard First Aid & CPR Recert-1 Day
24 Emergency First Aid and CPR-1 Day
20 Workplace Inspection Hazard Audit
15 Pre-Workwell Audit
13 Physical Demands Analysis
12 Meeting
11 Lockout Consulting
8 GAP Audit
4 Confined Space Consulting

Problem with Offerings

  • From wsOfferings we are ignoring offerings with
    • baseprice <= 0
    • nonexisting product
    • offertypecode == "OS" (Currently there are no OS Offerings sold on the cart)

Ignored Offerings: 47 from 515:

Offering ID Problem
 Nonexistent product  Price OfferTypeCode
O277 222
O278 222
O279 222
O280 222
O281 222
O282 222
O283 222
O284 222
O445 222
O446 222
O447 222
O448 222
O449 222
O450 222
O451 222
O452 222
O543 0.0
O591 0.0
O744 216
O755 0.0
O757 0.0
O758 0.0
O759 0.0
O760 220
O761 220
O762 220
O763 220
O764 220
O765 220
O766 220
O767 220
O768 220
O769 221
O770 221
O772 221
O773 221
O774 221
O775 221
O776 221
O777 221
O778 221
O779 0.0
O798 216
O799 216
O800 216
O801 243
O802 216

Problem with courses

  • From wsCourses we are ignoring courses with
    • nonexisting products and locations (currently every course we exclude is because it is not associated to a product)

Ignored courses 3 from 61

Course ID Nonexist Product Nonexisting locations
CS602 188
CS636 208
CS1129 209
  • Also we valid a proper date in start_dateand end_date, all the courses with invalid dates (e.g. February 30th) are going to be ignored)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment