Published on 佛教慈濟基金會 (https://glossary.tcnw.org/)

首頁 > Case Tracker > Visual Online Theatre Seat Reservation

Visual Online Theatre Seat Reservation

Project number:134928
Opened by:jsheu
Opened on:週一, 七月 14, 2014 - 3:51pm
Last modified:週二, 九月 11, 2018 - 11:26am
Operations:add Case | view all project cases

Settings:

  Item Value Description
1 Site URL  

http://<NAME>.us.tzuchi.org

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, Address, City, Country 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

  1. login:
  2. password:
  3. configure prices, colors, types of seats through "Products" (http://goo.gl/3XaLmA)
  4. configure front-landing page through CMS->Homepage
  5. configure tickets through TICKET->Tickets osConcert
  6. manual: http://tcnw-events.us.tzuchi.org/docs/osconcert-user-manual.pdf
  7. custom groups: 3-in-1, 贊助, 榮董

http://tcnw_events.us.tzuchi.org/tcnw-osconcert

  1. this is the subversion URL
  2. login:
  3. password: 
  4. check out the installation directory of osConcert through
    1. create a directory, e.g. tcnw-osconcert
    2. select "tcnw-osconcert"->right-button click->SVN Checkout 
    3. enter the above subversion information 
    4. get the whole repository to your local pc 
  5. modify php or css files as needed
    1. templates/cartzone/css/stylesheet.min.css
    2. templates/cartzone/css/seatplan.min.css
    3. includes/seatplan.php
  6. modify banner
    1. templates/cartzone/images/header.jpg
  7. modify the background of the seat plan
    1. templates/cartzone/bg.png (notice of transparency)
  8. fix bugs (color_code bugs)
    1. admin/includes/tweak/display/productsMainpage.php
  9. commit/push the changes back to the repository
  10. please note that any contents pushed to the repository is in real time 

importing db

  1. we'll receive the mySQL db delivered from osConcert
  2. once the mySQL is imported, the seat plan would show up in the system
  3. go to step configuration step to configure all seats
  4. 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:

  1.  周華健-大愛慈善募款音樂會, 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
  2. 李壽全+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
  3. 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
  4. 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
  5.  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
  6. 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
  7. 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
  8. 2018 Tzu Chi Charity Concert I, 11/10/2018, seat plan, invoice
  9. 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

Source URL: https://glossary.tcnw.org//zh-hant/content/casetrackerbasicproject/visual-online-theatre-seat-reservation