laraveldaily/laravel-support-ticketing

Laravel 6 Project for Support Tickets. Partly generated with QuickAdminPanel.

Demo support ticketing project based on Laravel 8.

Project is partly generated with QuickAdminPanel

---

---

---

---

---

---

---

How to use

• Clone the repository with git clone
• Copy .env.example file to .env and edit database credentials there
• Run composer install
• Run php artisan key:generate
• Run php artisan migrate --seed (it has some seeded data for your testing)
• That's it: launch the main URL
• If you want to login, click Login on top-right and use credentials [email protected] - password
• Agent's credentials are [email protected] - password

---

License

Basically, feel free to use and re-use any way you want.

---

More from our LaravelDaily Team

• Check out our adminpanel generator QuickAdminPanel
• Read our Blog with Laravel Tutorials
• FREE E-book: 50 Laravel Quick Tips (and counting)
• Subscribe to our YouTube channel Laravel Business
• Enroll in our Laravel Online Courses

laravel-support-ticketing's Issues

Migration Fail

SQLSTATE[HY000]: General error: 1005 Can't create table untfo.role_user (errno: 150 "Foreign key constraint is incorrectly formed") (SQL: alter table role_user add constraint user_id_fk_583559 foreign key (user_id) references users (id) on delete cascade)

PHP Version 8.2.0
Laravel 9.47
Server type: MariaDB
Server charset: UTF-8 Unicode (utf8mb4)

error

I am not able to run php artisan migrate --seed, seems like I am missing some details. Is laravel the db name?

Images are not being saved to the database (media table)

I'm testing the Quick Admin Panel and the images I upload when creating the ticket are not being saved in the database, being available only in storage/uploads

Support To Calculate Total Time Spent On A Ticket From Open To Closed

Hi, can we add a feature that calculate total time spent on a ticket from open status until closed status?

File: 2019_11_10_000001_create_media_table.php

When executing the "command php artisan migrate --seed" the following error message appears (see picture)

MariaDB 10.1 issues

Looks like a nice project!

Testing environment: Windows XAMPP Apache 2.4 Php 7.3 MariaDB 10.1

I had to update \app\Providers\AppServiceProvider.php to get past a 'key was too long' error when running php artisan migrate --seed:

Added at the top:

use Illuminate\Support\Facades\Schema;

and:

    public function boot()
    {
        Schema::defaultStringLength(191);
    }

Ref: laravel/framework#17508

Next error occurs at: Migrating: 2019_11_10_000001_create_media_table
An SQL syntax error near 'json not null, custom_properties json not null, responsive_images json not n'. Looks like MariaDB JSON Datatype is available from Version 10.2.7+. I replaced 'json' with 'text', deleted all database tables and re-ran artisan.

Ref: laravel/framework#13622 (comment)

Seems to be working now even with old MariaDB 10.1, which I should upgrade!

Support with this sofware

Hello, firstly I would like to commend the team who put this up together. Brilliant work and creative minds. However, I encountered some challenges and i'll try to state them with check boxes:

• I get an error when trying to submit a new ticket: {Swift_TransportException. Cannot send message without a sender address}. I'll attach a screenshot to show this error.

• Secondly, I would need help creating a menu for REPORTING on the dashboard, where I can download it as excel, pdf or any other format

• I would like to change the LARAVEL showing at the top left corner of the application with something of my preferred choice. If I can get directions as to where to see the code for that, I would be grateful

• I would also like to have an image on the login screen as well as the page where the user has to submit a ticket as well as have a logo on the header.
  I would really appreciate help with the stated issues

Not able to get language translation in laravel website

Have developed a website in laravel and need to give language translation option. Have updated all changes in but the dropdown is not working.

403 403 Forbidden

Trying to connect to [email protected] and a get : 403
403 Forbidden
and -> DataTables warning: table id=DataTables_Table_0 - Ajax error. For more information about this error, please see http://datatables.net/tn/7

Issue in submitting a ticket

After I have cloned the repo and followed the steps, I have open the web app as shown in the image:
https://drive.google.com/file/d/1xdRP9wuPKWV7Z1fkvzXCdbrT7DdPX1ko/view?usp=sharing

But when I'm trying to submit a ticket, I got the error shown in the image.

any help?

regards

Adding a new content for the home form

i was having a issue in adding a new content for the forms like contact number. i keep getting a SQLSTATEHY000 General error: 1364. as this project isn't using a models where can i put the indicated db addition to make up my needs?

Swift_TransportException

I cloned the packaged, followed instructions and put on a working custom smtp...but I still have this when i tried to create a ticket without logging in:

Swift_TransportException
Expected response code 250 but got code "530", with message "530 5.7.1 Authentication required
"
http://localhost:8000/tickets

can you please help?

Your project is really promising :)