This repository is dedicated to UTS 2023 Autumn Assignment 3 in the course 41889 & 42889 Application Development in the iOS Environment.
The assignment focuses on developing an online booking app for restaurants and completed by Nuo Chen as a group of one.
The GitHub repository link for the project is: https://github.com/Nuo27/iOS_Assignment3
The presentation video is in the repo root folder, nuo_13945466_a3.mp4
- 2023 iOS Dev Assignment3 repo
I used a free online database as the backend support, this app might be running slow due to the physical distance between the database and the app.
Please wait after clicking the button, and the app will respond. should be approximately 260-300ms delay, since db4free is based in Austria.
That is also to say, the app may not work properly after the database is closed.
If took too long to respond, please try to run the app on backup database
alternative, you can run the app on backup or your own database I've also created a backup database, refer to Usage in case the original database is closed/too slow. You can access it, by changing the user configuration in BookingViewController.swift, DateViewController.swift, ConfirmViewController.swift
If using own database:
let user = MySQLConfiguration(
user: "your user name",
password: "your password",
serverName: "ip/localhost",
dbName: "your database name",
port: 3306,
socket: "/mysql/mysql.sock")
and create a table with the following structure
CREATE TABLE `customer` (
`RID` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`phonenumber` varchar(255) NOT NULL,
`emailaddress` varchar(255) NOT NULL,
`timeslot` varchar(255) NOT NULL,
`partySize` int(11) NOT NULL,
`date` varchar(255) NOT NULL,
PRIMARY KEY (`RID`)
)
AUTO_INCREMENT=1
DEFAULT CHARSET=utf8mb4
--- issue might triggered when ios version is different ---
If you r facing: directory not found for option '~/iOS_Assignment3/OHMySQL/lib/MySQL.xcframework/ios-arm64'
The correct path should be: ~/iOS_Assignment3/Pods/OHMySQL/lib/MySQL.xcframework/ios-arm64
This is because the modification of OHMYSQL Cocoapods implementation
try:
- Root Folder ->modify the podfile to ur target ios version
- run
$ pop update updatein terminal - Product ->clean and build
if still not working:
- clean the cocoapods implementation and re-install it
- Implement the OHMYSQL manually, follow Cocoapods:
- link the arm64 build on build settings manually
This app is designed for customers who want to make restaurant reservations and staff members who need to efficiently manage those reservations. It aims to eliminate the inconvenience of traditional reservation systems by providing an intuitive online platform for both parties to easily book and cancel reservations.
Xcode 14.3(14E222b)
Deployment: iOS 16.4
Build system: Xcode Build System
Bundle Identifier: au.edu.uts.iOS-Assignment3
Customer
Free to use as guest
View/Clear Local store receipts ID in Settings -> Print/Clear
Staff account login:
account: admin
password: admin
Database:
user = MySQLConfiguration(
user: "grouphd",
password: "grouphd1",
serverName: "db4free.net",
dbName: "iosgroupass",
port: 3306,
socket: "/mysql/mysql.sock")
backup database
backupuser = MySQLConfiguration(
user: "epiz_34282737",
password: "IPREzbZobF",
serverName: "sql109.epizy.com",
dbName: "epiz_34282737_iosassignment",
port: 3306,
socket: "/mysql/mysql.sock")
- Select Date and time Slot
- check time Slot availability
- Place booking with customer details
- Confirm details printed out for double checked
- view/clear maded booking records and details
- cancel maded booking records
- Login/Logout with admin username and password
- Select Date and time Slot
- View all booking records
- View any record with its details
- Cancel any booking
- manage local store receipts ID
- input validation null check and format check
- auto-adjust partySize according to the availability but limited to 10
- edit admin account details
- previours filled details
- auto fetch data
- etc...
Start with a defining all the features that the app should have, then design the UI and the flow of the app.
Then enter the my iteration cycle from:
- sum up bugs left or possible improvement from last iteration
- define new features that the app should have
- implement functions
- test and debug
- sum up bugs left or possible improvement from this iteration
I have 4 iterations in total, and an approximate timeline in header of each iteration.
where the overall length of project is about 20 days.
- setup the project
- plan for features and functions
- plan for workflow
- plan for iterations
- create views and UI
- create basic view crossing functions
- test and debug
- create Model customer
- create Controllers
- implement local logic customer booking functions
- test and debug
- implement cocoaPods and OHMySQL -> connect to database
- rewrite/create all local logic customer booking functions to database functions
- input validation
- restructure the project features and views
- test and debug
- sum up bugs left or possible improvement from last iteration
- design UI visual
- implement UI visual
- test and debug
- update final readme.md and presentation
- submit
- presentation done
- readme.md updated
- submit
In order to enhance the functionality of the app, the following external tools were utilized:
Cocoapods is a dependency manager for iOS projects. The official Cocoapods website can be found at https://cocoapods.org/.
OHMySQL is an open-source Objective-C library that allows developers to connect their iOS apps to MySQL databases. The OHMySQL library can be found on GitHub at https://github.com/oleghnidets/OHMySQL.
db4free is a free MySQL database hosting service. The db4free website can be accessed at https://www.db4free.net/.
❤️ This is a special thanks from Nuo to the developers of these tools. ❤️
It is important to note that this app is created solely for educational purposes as part of an assignment. The records stored in the database used by the app are entirely fictional and do not represent any real-life individuals. The app and its contents are not intended for commercial use, copying for future assignments, or any other purposes beyond the scope of this assignment.