Transcript Application: Billing System

Implement An Online
Management System for PBX
Presented by: Bui Phuong Nhung
Advisor: Dr. Wei, Chao-Huang
Contents
1
Introduction
2
System Configuration
3
Communication protocol
4
Application
5
Conclusion
Introduction
Develop a server : flexibly applied
 Manage data
 Monitor status
 Control many kind of devices
Introduction
In this research:
Apply to PBX
PBX server
Manage information
concerning incoming
call & outgoing call
Send control massage
to PBX
Introduction
Conventional method
•Use RS232 interface for collecting data from the PBX
•Built a software to manage data got
Proposed method
•Get information of incoming call and outgoing call
•Record to MySQL database
•Provide web pages written in PHP and HTML
•On duty all the time
•Use an authentication method
Introduction
Application: Billing system
Practical for utilizing in hotels, office or
dormitories
System Configuration
Three tiers
 Bottom tier: PBX and
an Ethernet converter.
 Middle tier: MySQL
database,
Server-side, PHP scripts
based on Apache Web
server
 Top tier: Web Browser
Top tier
Web Browser
Internet
Middle tier
Web Server
PHP Scrips
Server-side
MySQL Database
Bottom tier
Ethernet
Converter
RS232
PBX
System Configuration
Bottom tier: PBX and Ethernet Converter
 Ethernet Converter: a medium to transfer data
from RS232 to Ethernet network.
 Communication interface
• PBX & the Ethernet Converter: RS-232
• Ethernet Converter & middle tier: TCP/IP protocol
System Configuration
Middle tier:




Apache Web Server
PHP is used to program scripts
C language is used to build up server-side
MySQL is used as a database server
System Configuration
Top tier: Web Browser
Communication Protocol
Kernel of the communication: TCP/IP
socket
Listening socket
Connected socket
Create a listening
socket on a
specific port
Waiting for
package
Listen connection
Package go in?
N
Y
Client request ?
Y
Create connection
Receive control
message
Close conection
N
Send/receive
package
Application: Billing System
Depend on the information recorded in
database
Implement in a PC installed Fedora Core
Takes the dormitory 6 of the Southern
Taiwan University of Technology, Tainan,
Taiwan as an example
Application: Billing System
To build up the billing system, MySQL
database must include many tables:






Telecom companies of Taiwan table
Cell phone price table
Long distance price table
International dial code table
International price of cell-phone table
International price of telephone table
Application: Billing System
authentication with PHP session control &
MySQL.
Application: Billing System
Application: Billing System
Conclusion
The proposed PBX server and its
application could be used instead of
management software for dormitories,
hotels or offices
This application eases to use at any
platform which is installed Web Brower
In the future, more function can be added
to PBX server such as monitoring and
control devices.
Introduction
PBX (Private Branch Exchange): make
connections among the internal
telephones of a private organization —
usually a business — and also connect
them to the public switched telephone
network (PSTN) via trunk lines.
System Configuration
Apache Web Server: A computer
program that is responsible for accepting
HTTP requests from web clients, and
serving them HTTP responses (web pages
such as HTML documents and linked
objects).
System Configuration
PHP is scripting language which is usually
used for web development and can be
embedded into HTML. It generally runs on
a web server, taking PHP code as its input
and creating web pages as output.