Share My Creation [Web] Support Ticketing System

Current version: 1.03
Status: Released
Price: $150

What's new?

Spoiler: Version 1.03

1. Performance improvement when querying for tickets using vw_tickets view.
   This view is automatically created if it does not exist in old database.
2. Many new functions in DatabaseBuilder class such as IfNull, Create2, setSelect2, SelectFromView, ViewExists and ViewExists2.
3. Added "Delete Ticket" button for Staff ticket view.
4. Some enhancements in User Login page.
5. Some changes in JavaScripts files.
6. Updated firebird.example to use MaxPoolSize=0 by default
7. Updated firebird.sql script file to create vw_tickets view

Spoiler: Version 1.02

1. Changes in firebird.example - DbToolPath to set path of isql, UseScript, ScriptFile
2. Changes in postgresql.example - DbToolPath to set path of createdb
3. Updated firebird.sql script file
4. Fix issue creating tables for Firebird, articles table must be created after topics table
5. Fix search engine on top of page for Firebird to support case-insensitive keyword search

Spoiler: Version 1.01

1. WYSIWYG editor, using summernote plugin
2. Toast message, using toastr plugin, replacing the ugly javascript alert
3. SessionStorage is used to show toast message after page reload
4. Email notification added for client registration and ticket status changes by staff or client
5. HTML file generated for previewing emails instead of sending actual email
6. Bug fixed in JavaScript document ready calling functions in wrong order (Ajax/event loop issue)
7. Bug fixed in SQLite, missing "server" tag in build configuration causing unexpected database closed
8. Bug fixed in SQLite message table created date (DatabaseBuilder)
9. Add size to some text fields in tables like tickets, messages and articles (no affects to SQLite database)
10. Disable/Enable cascading drop-down lists when selecting equipments (Type->Brand->Model)
11. Some code cleanup and renaming
12. Some modification in database config example file
13. Missing additional jars for Velocity library 2.01 has been uploaded under B4J (shortcut back to version 1.00)
14. Moved some js files to plugins folder
15. Minor UI changes in login forms (client and staff)
16. Updated jQuery validation to validate maxlength of some name and description fields
17. jQuery validation also validate WYSIWYG editor which has default text even the content is empty
18. Limit client from deleting their attachments (Error message toast and page reloads)

Spoiler: Version 1.00

1. Based on Web API Server Template version 2.08 (improved version)
2. Supporting databases: SQLite, MySQL/MariaDB, Firebird 3+, PostgreSQL and MS SQL Server 2019
3. DatabaseBuilder and DatabaseConnector classes (more powerful than MiniORM)
4. Separate config files e.g sqlite.ini for different database engine (in addition to existing config.ini)
5. More organized and reusable code (DRY principle)
6. More user-friendly logs and debug experience (click the colourful log to jump to the correct verb method)
7. Display date and time based on client side local timezone using JavaScript if database time is save as UTC (can be disabled)
8. Improved jQuery Uploader with confirmation dialog (prevent user accidentally delete or download an attachment)
9. Uploaded attachment retain it's original file name and file is organized with subfolders according to upload date and time
10. API version changed from v2 to v1 (Try clear browser cache due to updated JavaScript if you have run previous version before)
11. Comment link to export project as zip file using WinRAR (like B4XPages project)

Preview

Demo Video

Spoiler: v1.03 (Client Login)

Spoiler: v1.03 (Create Ticket)

Spoiler: v1.03 (Create Article)

Spoiler: Demo

Spoiler: Staff

Spoiler: Client

FAQs

Spoiler: About this project

1. Server: jServer (For production, it is a compiled jar to run on Linux or Windows VPS)
2. Backend: Powered by EndsMeet framework and Web API Template 2 which produces JSON format REST API. Business logic coded with B4J.
3. Database: MySQL, SQL Server, PostgreSQL, Firebird and SQLite. No additional SQL knowledge required for specific database since queries are handled by DatabaseBuilder class. Same code works for all databases.
4. Template: AdminLTE3 (Bootstrap 4) powered by Velocity Template Engine works perfectly on mobile or desktop browser.
5. File Uploader: jquery-uploader with nice image viewer.
6. Security: Session and password hashing. SQL prepared statements to prevent SQL injection.
7. Email: SMTP with jNet library for new ticket creation, client registration, reset and change password.
8. Knowledge: Skills in web development are not required unless you want to modify the frontend.
9. SEO: Pretty URL routes

Spoiler: What this project is not about

1. Not PHP, .NET, Python
2. No drag-and-drop tool for front-end web UI included
3. No B4X UI Views
4. Not a low code/no code app generator
5. No ABM, BANano, BVAD3, SithasoDaisy
6. No Vue, Angular, ReactJS
7. Not PWA
8. No NPM, Composer or package.json
9. No obfuscated JavaScript or CSS
10. No virtual environment or docker
11. Not working in shared hosting
12. No cookie, localstorage and JWT used
13. Web API is not suitable for B4A or B4i clients*
14. Not multilanguage such as Italian, only English.

* I decided to remove the complexity of JWT and only focus on server session (stateful). However, it is possible to support mobile clients (stateless) with some modification but this is out of the scope of this project.

Spoiler: Why you should get this source code?

1. This is the first complete web app for Ticketing System in the forum ever made.
2. It is powered by EndsMeet, a web development framework with libraries build from the ground up such as Web API template and Velocity library.
3. 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.
4. You want to use a simple yet powerful template engine, Velocity.
5. Frontend is based on the most popular AdminLTE dashboard template.
6. You want to write simple B4X code that work with 5 most popular database engines.
7. You want to start developing with the lightweight SQLite and migrate to other database engine such as MySQL, SQL Server, Firebird or PostgreSQL in the future.
8. You plan to build a REST API server which can be reused for your mobile or desktop apps.
9. You want to learn how to build a front-end that provide good user interface and experience (UI/UX) for desktop and mobile users.
10. You want to know how to manage login sessions or restrict user access in jServer web app.
11. You want to know how to use SMTP or jNET library for sending email during user registration, activation, change password and reset password.
12. You can modify this project to build app for e-commerce, inventory, e-learning, ERP, CRM, project management, data collection, dashboard, etc.

Then, get this source code at a very low price while it last!

Spoiler: Sample Code

Private Sub GetClients
    ' #Version = v1
    ' #Desc = List all clients
    Try
        If UserAuthorize(Array As String("staff")) = False Then
            ReturnHtmlPageAuthorizationRequired
            Return
        End If
        DB.Table = "tbl_clients"
        DB.Query
        HRM.ResponseCode = 200
        HRM.ResponseData = DB.Results
    Catch
        HRM.ResponseCode = 422
        HRM.ResponseError = "Error execute query"
    End Try
    DB.Close
    ReturnApiResponse
End Sub

 

[Mashiane]

This is awesome! Have you decided on the selling price?

 

[aeric]

This is awesome! Have you decided on the selling price?

Hmm...
$120 before discount.

 

[aeric]

Important: Please ask questions before making order.

Please make sure everyone is clear and understand how this system works before proceed.

To clarify, the front-end UI is modified from AdminLTE 3 template, which is based on Bootstrap 4 front-end framework (HTML, CSS and jQuery).

The project depends on Velocity library.

Please understand, that this is a Web app built with the abovementioned front-end technology consuming REST API (JSON) from B4J backend.

Please don't misunderstand. This project does not convert B4X UI Views like B4XTable to HTML table.

This is not ABM or BANano Web app project.

Please refer to my Web API Template for more details.

 

[Xfood]

This is awesome! Have you decided on the selling price?

the idea is similar water color that you should have made in BANanoVuetifyAD3
tree, remember?

 

[aeric]

Current version: 0.08 beta
Status: Under development
Price: $120 $60 (50% discount until 31/07/2023)

Note: Shops (and Linked Shops) module is removed

 

[Magma]

1) Please understand, that this is a Web app built with the abovementioned Front-end technology consuming REST API (JSON) from B4X backend.

2) Please don't misunderstand that B4X UI Views like B4XTable can be converted to HTML table. This is not ABM or BANano Web app project.

1) that means ... that we must run at vps server a b4x app - right ?

2) ...i misunderstand... mean that those nice table are html and javascript (i understand that is just html and javascript/jquery)... or b4x code ?

 

[aeric]

1) that means ... that we must run at vps server a b4x app - right ?

2) ...i misunderstand... mean that those nice table are html and javascript (i understand that is just html and javascript/jquery)... or b4xcode ?

1. Yes. It is a B4J Server app for the Back-end. No PHP or .NET.
2. I don't know there is a programming language called b4xcode, do you mean it is a company name? ?

The Front-end is pure HTML5, CSS3, jQuery 3.6. No "modern" framework or compiled/minified javascript (except the minified CSS and JS bundled with Bootstrap). Yes, it is powered by Bootstrap 4 framework! (BS4 is not a modern framework right?)

 

[Magma]

sorry i mean b4x code

 

[aeric]

Please don't misunderstand that B4X UI Views like B4XTable can be converted to HTML table.

I mean I don't know it is possible use B4X UI Views in Web App. If you know, please let me know.
Maybe you want to refer to Adobe Flash or Silverlight.
Even you use PHP, .NET, Python, Ruby or Java, the output is still HTML, CSS and JavaScript.

 

[amorosik]

I did not undertand well
Suppose there is a software house A (produce of projects K, W, Z), and customer B (project K), customer C (project K), customer D (project W)
Does the project also include the part dedicated to entering tickets for the customers or is it a dedicated project that can only be used by the software house?

 

[aeric]

I did not undertand well
Suppose there is a software house A (produce of projects K, W, Z), and customer B (project K), customer C (project K), customer D (project W)
Does the project also include the part dedicated to entering tickets for the customers or is it a dedicated project that can only be used by the software house?

I am offering a basic minimum system at a very low price.
Different people will have different needs.
What suited you may not suited for the rest.
However, if you have the source code, you can make addition with less effort since the basic structure is already there for you.
If you want me to customize for you, that is additional charges.

 

[NGUYEN TUAN ANH]

I am offering a basic minimum system at a very low price.
Different people will have different needs.
What suited you may not suited for the rest.
However, if you have the source code, you can make addition with less effort since the basic structure is already there for you.
If you want me to customize for you, that is additional charges.

Did you use B4J and BANanoVuetifyAD3 in your project ?

 

[aeric]

Did you use B4J and BANanoVuetifyAD3 in your project ?

B4J: yes

The backend is build with jServer and Web API Template 2 to output the data in JSON format.
I also make use of Velocity library as the template engine to generate the HTML front-end.
If anyone is familiar with developing web apps using PHP Laravel or Python Django/Flask, what I am doing with B4J is the back-end.

BANanoVuetifyAD3: no

This project is mainly for demonstrating the Web API Template I have developed.
I decided to use AdminLTE template which is already have (almost) all the layouts designed.
Unless there is a demand to use BVAD3 or SithasoDaisy, I can develop another one with these libraries.

 

[aeric]

Amended first post with some explanations.

 

[aeric]

If anyone is interested to check a live demo, please start a conversation with me for the link.

 

[amorosik]

If the system was foreseen to allow the customer to enter the ticket directly and then the various entries were visible, searchable, sortable, in the main system, then I would be interested in trying it, and if the price were low, also buying it

 

[aeric]

allow the customer to enter the ticket directly

Yes, it is designed as such behavior, provided he/she is a registered client, login with an activated account.

the various entries were visible

what kind of entries?
You may check the spoiler for some screenshots. Customer can input the category and priority. Once ticket is created, he/she can check the ticket creation date, status and staff assigned to the ticket. He/she can send message to the staff. He/she also can add product (equipments) with Type, Brand, model and Serial Number.

searchable, sortable,

This features are planned to be added in the future.

if the price were low

If you still don't consider the early bird discount price now is low, I don't know what to say. This price will not be offered again once the promotion ends.

 

[aeric]

Is this source code for you?
Check the "Why you should get this source code" spoiler in the first post.

 

[amorosik]

Yes, it is designed as such behavior, provided he/she is a registered client, login with an activated account.


what kind of entries?
You may check the spoiler for some screenshots. Customer can input the category and priority. Once ticket is created, he/she can check the ticket creation date, status and staff assigned to the ticket. He/she can send message to the staff. He/she also can add product (equipments) with Type, Brand, model and Serial Number.


This features are planned to be added in the future.


If you still don't consider the early bird discount price now is low, I don't know what to say. This price will not be offered again once the promotion ends.

Yes, of course I think the login with a user already registered and present in the archive is also acceptable, and therefore the first registration with a user must be performed by the manufacturer/supplier staff

From my point of view, the end user should be able to add (only add, not delete) a new ticket, and choose (only select, not add) the category or priority It should also be able to filter tickets and display only those with certain characteristics, for example by description, by category, by priority, by date, etc.

Ok

Yes of course, for 'low price' I consider a figure around 50 euros acceptable, and therefore, the proposal of 120 euros discounted at 50% is perfectly in line with my idea of 'low price'