Visual Online Theatre Seat Reservation
| Project number: | 134928 |
| Opened by: | jsheu |
| Opened on: | 星期一, 七月 14, 2014 - 3:51下午 |
| Last modified: | 星期二, 九月 11, 2018 - 11:26上午 |
| Operations: | add Case | view all project cases |
- Project: To create an online ticket/seat reservation for the upcoming October concert. The plan is to purchase a commercial software and NCA will configure and maintain the software.
- Project kickoff: Project is approved on 7/11/2014
- Project system: osConcert Visual Theatre Seat Reservation
- Contact: Gordon Farmer @ osConcert (webmaster@osconcert.com)
- Software architects: Vincent <vincenttchang@hotmail.com>, Cheng Che <cchen1_2000@yahoo.com>, Winston <wchen@marvell.com>, Nancy <njen98@yahoo.com>
- Ticket flow: http://goo.gl/3XaLmA
- PayPal Fees: 2.2% + $0.30 per transaction
- SVN: http://tcnw-events.us.tzuchi.org/tcnw-osconcert
- Seat diagram of Center for the Performing Art
- Seating chart of McAfee Performing Arts and Lecture Center
- Seating chart of TCNW Gratitude Hall
- jQuery Language Switcher: (http://jsfiddle.net/jmcglone/dqL8m/)
- Admin page: http://tcnw-events.us.tzuchi.org/admin/login.php
- Frontend page: http://tcnw-events.us.tzuchi.org/
Settings:
| Item | Value | Description | |
|---|---|---|---|
| 1 | Site URL |
e.g. http://nca-performance.us.tzuchi.org/, http://nca-concert.us.tzuchi.org/ |
|
| 2 | Store Name | e.g. Tzu Chi in NCA | |
| 3 | Store Owner | e.g. Tzu Chi | |
| 4 | Email Address | email address for users to email to if they have questions and problems | |
| 5 | Email From | ||
| 6 | Send Admin Confirmation and Extra Order Emails to | email address that the system will cc. when customers have confirmed the orders | |
| 7 | Store Address and Phone | Tzu Chi's address and phone that customers can write to and call to | |
| 8 | Customer account Fields |
First Name, Last Name, Username, Phone, Email, |
Information that you want customers to leave (please cut to minimum) |
| 9 | Ticket image | ||
| 10 | Reserved seats | VIP, handicap,... | Any seats need to be reserved (not for public sale) |
| 11 | Auto Return URL | http://www.us.tzuchi.org/us/index.php?option=com_content&view=article&id=4023 |
Customization
https://tcnw-events.us.tzuchi.org/admin
- login:
- password:
- configure prices, colors, types of seats through "Products" (http://goo.gl/3XaLmA)
- configure front-landing page through CMS->Homepage
- configure tickets through TICKET->Tickets osConcert
- manual: http://tcnw-events.us.tzuchi.org/docs/osconcert-user-manual.pdf
- custom groups: 3-in-1, 贊助, 榮董
http://tcnw_events.us.tzuchi.org/tcnw-osconcert
- this is the subversion URL
- login:
- password:
-
check out the installation directory of osConcert through
- create a directory, e.g. tcnw-osconcert
- select "tcnw-osconcert"->right-button click->SVN Checkout
- enter the above subversion information
- get the whole repository to your local pc
-
modify php or css files as needed
- templates/cartzone/css/stylesheet.min.css
- templates/cartzone/css/seatplan.min.css
- includes/seatplan.php
-
modify banner
- templates/cartzone/images/header.jpg
-
modify the background of the seat plan
- templates/cartzone/bg.png (notice of transparency)
-
fix bugs (color_code bugs)
- admin/includes/tweak/display/productsMainpage.php
- commit/push the changes back to the repository
- please note that any contents pushed to the repository is in real time
importing db
- we'll receive the mySQL db delivered from osConcert
- once the mySQL is imported, the seat plan would show up in the system
- go to step configuration step to configure all seats
- check with 3-in-1, ticketing staffs to reserve designated seats
Seating Plan
| Date | Price | Voucher # | Event Name |
|---|---|---|---|
| November 2018 | $125 | invoice 06-09-2018-BTCF004 | 2018-11-10 Circle of Love |
| October 2016 | $200 | NCA-IT-16013 | 2016-10-13 慈濟五十行願之路慈善音樂會 |
| October 2015 | $170 | NCA-IT-150009 | 2015-10-04 VOX玩聲樂團 |
| November 2014 | $190 | NCA-IT-140009 | 2014-11-23 李壽全+VOX玩聲樂團 |
| October 2014 | $235 | NCA-IT-140008 | 2014-10-05 周華健-大愛慈善募款音樂會 |
Concert Details:
-
周華健-大愛慈善募款音樂會, 10/5/2014, 3 PM
not-for-sell: 1,061
$50: seat * 756, sold * 693
$100: seat * 372, sold * 364
$150: seat * 476, sold * 419 -
李壽全+VOX玩聲樂團, 11/23/2014, 3 PM - 5 PM, @ McAfee Center
$30: seat * 246, sold * 231
$50: seat * 161, sold * 161
$500: seat * 162, sold * 153 -
VOX玩聲樂團, Performance-1, 10/4/2015, 3 PM - 5 PM, @ Tzu Chi, seat plan
$60: seat * 210, sold * 188
$100: seat * 90, sold * 85
$1000: seat * 162, sold * 133 -
VOX玩聲樂團, Performance-2, 10/4/2015, 7:30 PM - 9:30 PM, @ Tzu Chi, seat plan
$60: seat * 210, sold * 188
$100: seat * 114, sold * 108
$1000: seat * 138, sold * 115 -
2016 Tzu Chi Charity Concert I, 10/22/2016, 3 PM - 5 PM, @ Tzu Chi, invoice
not-for-sell: 102
$100: seat * 96, sold * 94 -
2016 Tzu Chi Charity Concert II, 10/22/2016, 7:30 PM - 9:30 PM, @ Tzu Chi, invoice
not-for-sell: 92
$100: seat * 106, sold * 106 -
2016 Tzu Chi Charity Concert III, 10/23/2016, 3 PM - 5 PM, @ Tzu Chi, invoice
not-for-sell: 88
$100: seat * 110, sold * 110 - 2018 Tzu Chi Charity Concert I, 11/10/2018, seat plan, invoice
- 2018 Tzu Chi Charity Concert II, 11/11/2018, seat plan, invoice
Log:
- 9/10/2018: submitted PayPal $125 to Gordon Farmer cybergord@hotmail.com
- 9/6/2016: fixed db making the product id starts with 118 so it won't conflict with existing products
- 9/2/2016: seat db delivered
- 8/18/2016: submitted invoice of osConcert to Finance
- 8/15/2016: submitted Purchasing Request of $200 for osConcert for vows-50 concert on 10/22,23/2016. ID = "NCA-IT-16013"
- 9/1/2015: system has gone public for selling tickets http://tcnw-events.us.tzuchi.org/
- 8/26/2015: raw system is up http://tcnw-events.us.tzuchi.org/
- 8/25/2015: received database of the seating chart
- 8/12/2015: submitted seating chart to osConcert. Paymnet Authorization was also submiited
- 8/4/2015: submitted Purchasing Request of $170 for osConcert seat plan for VOX concert on 10/4/2015. ID = "NCA-IT-150009"
- 11/4/2014: goes online
- 11/2/2014: new seat plan delivered
- 10/27/2014: submitted Purchasing Request of $190 for osConcert seat plan for Mr. Lee's concert on 11/23/2014. ID = "NCA-IT-140009"
- 10/5/2014: concert day (Total Sale: $134,500)
- 9/5/2014: system opened to public order
- 8/22/2014: PayPal problems resolved
- 8/16/2014: PayPal problems identified (payment went through, tickets not delivered)
- 8/13/2014: one seat "Row-26, Seat-56" missing from the database
- 8/11/2014: software downloaded and installed. initial setup done
- 8/10/2014: payment made through bank wire
- 8/7/2014: submitted PO, invoice received
- 8/4/2014: submitted Payment Authorization of $235 to replace the two-times payments in order to reduce bank fee
- 7/28/2014: communicated with Sister Dora regarding bank wire transfer. Sister Dora will communicate with LA HQ regarding the bank fee.
- 7/25/2014: submitted Payment Authorization of $120 as the prepayment to osConcert
- 7/17/2014: submitted Purchasing Request of $235 for osConcert software. ID = "NCA-IT-140008"
- 7/11/2014: Tzu Chi meeting has decided to purchase osConcert
Groups:
