Current version: 0.18
Status: Released
Database: MySQL, Firebird, PostgreSQL, SQLite
Price: $120
Preview
Demo
Status: Released
Database: MySQL, Firebird, PostgreSQL, SQLite
Price: $120
Preview
Demo
- Server: jServer (For production, it is a compiled jar to run on Linux or Windows VPS)
- Backend: Powered by EndsMeet framework and Web API Template 2 which produces JSON format REST API. Business logic coded with B4X.
- Database: MySQL, Firebird and SQLite. Other DBMS may be added in the future. MiniORM as query builder.
- Template: AdminLTE3 (Bootstrap 4) powered by Velocity Template Engine.
- File Uploader: jquery-uploader with nice image viewer.
- Security: Session and password hashing. SQL prepared statements to prevent SQL injection.
- Email: SMTP with jNet library for new ticket creation, client registration, reset and change password.
- Knowledge: Required basic skills in web development such as HTML, CSS and JavaScript (jQuery).
- SEO: Pretty URL routes
- Not PHP, .NET, Python
- No Drag-and-drop tool for front-end web UI included
- No B4X Views like B4XTable, XCustomListview, B4XSearchTemplate can be use (this is a B4J non-UI app)
- Not a low code/no code app generator
- No BANano, BVAD3, SithasoDaisy
- No Vue, Angular, ReactJS
- Not PWA
- No NPM, Composer or package.json
- No compiled JavaScript or CSS
- No virtual environment or docker
- Not working in shared hosting
- No cookie, localstorage and JWT used
- Web API is not suitable for B4A or B4i clients*
- This is the first complete web app for Ticketing System in the forum ever made.
- It is powered by EndsMeet, a web development framework with libraries build from the ground up such as Web API template and Velocity library.
- You don't want to use PHP or C# but choose B4X as your backend programming language hosted on the high performance jServer powered by Jetty.
- You want to use a simple yet powerful template engine and you don't want to use Java Spring, this project shows how you can use Velocity template engine with complex layouts.
- The most popular AdminLTE template is included as a starting point. If you have found a nice HTML dashboard template in themeforest, colorlib, envato, templatemonster, etc for your upcoming projects, you can switch to it with some modifications.
- You want to see how MiniORM can simplify the way to build SQL queries.
- You want to start develop with the lightweight SQLite and migrate to other database engine such as MySQL, SQL Server, Firebird or PostgreSQL in the future.
- You plan to build a REST API server which can be reused for your mobile or desktop apps.
- You want to figure out how the front-end UI such as collapsible panel, cascading dropdown list, responsive layout are made with JavaScript or jQuery and how to call REST API using jQuery Ajax. This provide a good user interface and experience for desktop and mobile users.
- You want to know how sessions work in jServer web app. How to route end users and administrator login to different pages.
- You want to know how emails are sent using SMTP or jNET library for user registration, activation, change password and reset password.
- You have an idea to build other web apps such as e-commerce, shopping cart, inventory, e-learning, ERP, CRM, project management, data collection, dashboard, etc then this project can be used as a base template.
Return JSON response using MiniORM:
Private Sub GetClients
#region Documentation
' #Version = v2
' #Desc = List all clients
#End region
Try
If Not(user_type = "staff") Then
HRM.ResponseCode = 401
HRM.ResponseError = "Authorization required"
ReturnApiResponse
Return
End If
Dim DB As MiniORM
DB.Initialize(Main.DBOpen, Main.DBEngine)
DB.Table = "tbl_clients"
DB.Query
HRM.ResponseCode = 200
HRM.ResponseData = DB.Results
Catch
LogError(LastException.Message)
HRM.ResponseCode = 422
HRM.ResponseError = "Error execute query"
End Try
DB.Close
ReturnApiResponse
End Sub
Last edited:
