I installed this into a new Laravel installation and followed the command-line method and populated it with the sample data/seeded info. The dashboard loads and the queries execute successfully. (I have the Laravel Debugbar enabled)

However whenever I attempt to navigate to a page that is attempting to I assume list tickets into a DataTable -- they are failing to load with:

DataTables warning: table id=tickets-table - Ajax error. For more information about this error, please see http://datatables.net/tn/7

I had to go into TicketsController.php previous to this error as originally it wasn't even finding Yajra's DataTables class. I modified a line in TicketControllers.php (254) to read as camel-cased as opposed to lowercase:

$datatables = app(\Yajra\DataTables\DataTables::class);

Doing that got me passed the "Target class [Yajra\Datatables\Datatables] does not exist." error/stack trace but now I'm stuck with:

ErrorException
Invalid argument supplied for foreach()

Any help is greatly appreciated!

The dashboard loads with the sample data, so I know the SQL interaction is working as expected.

Using Laravel 7, when I run php artisan vendor:publish --tag=panichd-db I get an error message "Unable to locate publishable resources".

How can I reference my master view? Its on resources\views\layers\header.blade.php And its on materialize css Its going to affect bootstrap framework on ticket system?

Hello
I had a problem during the installation on laravel 8
It is not compatible with version 3 of dbal?

Problem 1
    - Root composer.json requires panichd/panichd ^0.20.0 -> satisfiable by panichd/panichd[v0.20.0].
    - panichd/panichd v0.20.0 requires doctrine/dbal ^2.10 -> found doctrine/dbal[v2.10.0, ..., 2.12.x-dev] but the package is fixed to 3.0.0 (lock file version) by a partial update and that version does not match. Make sure you list it as an argument for the update command.

Thank's

What is the best way you'd recommend for making panichd extend my own custom layouts.
This is so I can have a consistent navigation and look throughout my app

Why does some user don't get the emails?
Can't find any error message, but it seems like somehow the assigned agent doesn't receive an email when a ticket is created.

workin on clean install of laravel 5.8, ran make:auth, migrate and proceeded to register a user.
when running and db:seed command i get the following error:
ReflectionException : Class PanicHD\PanicHD\Seeds\SettingsTableSeeder does not exist

Hi,
I've followed all the mentioned steps to install panichd. It installed successfully, got no error.
But when I access /panichd url on my server, it says 404 not found.
Please assist me in this regard.

Hi,
When will it be compatible with laravel 7^?
I need your package for a project but it currently runs on laravel 7. I will like to know if there are plans to upgrade to support lastest Laravel version

When I runphp artisan vendor:publish --tag=panichd-public , I see (for example) that public/vendor/panichd/bootstrap populated with a css and a js file. However when I load the Ticket Edit page, I see requests for .js.map files and .css.map files.

By what process are these .map files created?????

Hi @xaviqv,

I'm back.. :-)

There is this view file called form.blade.php
vendor/panichd/panichd/src/Views/tickets/createedit/form.blade.php

I want to make changes in this file, I know what I have to change but I don't know how am I supposed to make that change. I have asked this before as well but I'm still confused.

I made changes in the above mentioned file directly in vendor folder and it worked. But I know that it is not the recommended way and I don't want my changes to vanish away on any updates

Can you please please guide me step by step (for once) on how to make changes to this file?

hello,

I can add pdf, rdf, excel format when opening a ticket.
But I can't add formats like png, jpeg, jpg. Ticket not registered

how can i solve this problem

thanks

Good evening,

I wanted to install panichd from a perfectly functional ticketit installation. Unfortunately I get this error just after clicking on "Install now" at this step. The access was working with ticket it before, I don't see what could block it.
I tried a php artisan cache:clear and to chmod 777 bootstrap and storage directories (for test of course) but it didn't work. Any ideas? Thanks

I can change the values of the settings, but nothing happens.
When i change the url of panichd , the new url doesnt work.

Is there anything to do so the new settings are reloaded?

Hello
I would like to have your opinion.
I would like to integrate panichd to an existing application that is used to manage stuff and from this stuff offer the possibility to create tickets and therefore have a link between this stuff and the associated tickets, to be able to list the tickets from the stuff and have a link in the tickets to the stuff.
I created a pivot table (ticket_id, stuff_id), I created a form in my application and I create the ticket as suggested in the wiki :

use PanicHD\PanicHD\Models\Ticket;

$ticket = new Ticket;
$ticket->subject = "Your ticket subject";
...
$ticket->save();

Then I insert a row in my pivot table.

The principle works, I can list the tickets created this way in my stuff.
But it will force me to rewrite a whole specific form and there will be the problem of the link from the ticket to my stuff ...

I thought that a solution would be to add two columns in the tickets table (linkable_type and linkable_id for example) and to be able to fill them in hidden fields of the ticket creation form by passing them in parameter when calling the form.

What do you think about it?
Any other ideas?

hello,
I installed the package and it works.but i have a problem

When I press the add button, the operation is successful.
but the process stays like this after.does not guide. No error or successful message.
sorry for my bad english
thanks

Symfony \ Component \ Debug \ Exception \ FatalErrorException (E_UNKNOWN)
Cannot make non static method App\User::isAdmin() static in class PanicHD\PanicHD\Models\Member

I just installer panichd but when accessing the installer page i've a 404 error.
Any idea?

I have a bug with the search field in the ticket list
In my case the departments feature is disabled and when I try to do a search I get this message

DataTables warning: table id=tickets-table - Exception Message:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'dep_ancestor.name' in 'where clause' (SQL: select count(*) as aggregate from (select `panichd_tickets`.`id`, `panichd_tickets`.`created_at`, `panichd_tickets`.`subject` as `subject`, `panichd_tickets`.`hidden` as `hidden`, `panichd_tickets`.`content` as `content`, `panichd_tickets`.`intervention` as `intervention`, `panichd_tickets`.`status_id` as `status_id`, `panichd_statuses`.`name` as `status`, `panichd_statuses`.`color` as `color_status`, `panichd_priorities`.`color` as `color_priority`, `panichd_categories`.`color` as `color_category`, `panichd_tickets`.`start_date` as `start_date`,  0-CONVERT(date_format(panichd_tickets.start_date, '%Y%m%d%h%i%s'), SIGNED INTEGER) as inverse_start_date, CASE panichd_tickets.limit_date WHEN NULL THEN 0 ELSE 1 END as has_limit, `panichd_tickets`.`limit_date` as `limit_date`,  0-CONVERT(date_format(panichd_tickets.limit_date, '%Y%m%d%h%i%s'), SIGNED INTEGER) as inverse_limit_date, `panichd_tickets`.`limit_date` as `calendar`, `panichd_tickets`.`updated_at` as `updated_at`, `panichd_tickets`.`completed_at` as `completed_at`, `panichd_tickets`.`agent_id`, `panichd_tickets`.`read_by_agent`, `agent`.`name` as `agent_name`, `panichd_priorities`.`name` as `priority`, `panichd_priorities`.`magnitude` as `priority_magnitude`, `members`.`name` as `owner_name`, `creator`.`name` as `creator_name`, `panichd_tickets`.`user_id`, `panichd_tickets`.`creator_id`, `panichd_categories`.`id` as `category_id`, `panichd_categories`.`name` as `category`, group_concat(panichd_tags.id) AS tags_id, group_concat(panichd_tags.name) AS tags, group_concat(panichd_tags.bg_color) AS tags_bg_color, group_concat(panichd_tags.text_color) AS tags_text_color, "" as dep_ancestor_name, (select count(*) from `panichd_attachments` where `panichd_tickets`.`id` = `panichd_attachments`.`ticket_id`) as `all_attachments_count`, (select count(*) from `panichd_comments` where `panichd_tickets`.`id` = `panichd_comments`.`ticket_id` and `type` in (reply, note, completetx) and `type` != note) as `comments_count`, (select count(*) from `panichd_comments` where `panichd_tickets`.`id` = `panichd_comments`.`ticket_id` and `type` in (reply, note, completetx) and `type` != note and `panichd_comments`.`updated_at` > 2021-04-28 00:00:00) as `recent_comments_count`, (select count(*) from `panichd_comments` where `panichd_tickets`.`id` = `panichd_comments`.`ticket_id` and `panichd_comments`.`type` = note) as `internal_notes_count` from `panichd_tickets` left join `users` on `users`.`id` = `panichd_tickets`.`user_id` left join `users` as `members` on `members`.`id` = `panichd_tickets`.`user_id` left join `users` as `creator` on `creator`.`id` = `panichd_tickets`.`creator_id` inner join `panichd_statuses` on `panichd_statuses`.`id` = `panichd_tickets`.`status_id` left join `users` as `agent` on `agent`.`id` = `panichd_tickets`.`agent_id` inner join `panichd_priorities` on `panichd_priorities`.`id` = `panichd_tickets`.`priority_id` inner join `panichd_categories` on `panichd_categories`.`id` = `panichd_tickets`.`category_id` left join `panichd_taggables` on `panichd_tickets`.`id` = `panichd_taggables`.`taggable_id` and `panichd_taggables`.`taggable_type` = PanicHD\PanicHD\Models\Ticket left join `panichd_tags` on `panichd_taggables`.`tag_id` = `panichd_tags`.`id` where `completed_at` is null and `status_id` = 1 and `agent_id` = 4 and (LOWER(`panichd_tickets`.`id`) LIKE %en% or LOWER(`panichd_tickets`.`updated_at`) LIKE %en% or LOWER(`dep_ancestor`.`name`) LIKE %en% or LOWER(`panichd_tickets`.`subject`) LIKE %en% or LOWER(`panichd_tickets`.`intervention`) LIKE %en% or LOWER(`panichd_statuses`.`name`) LIKE %en% or LOWER(`panichd_priorities`.`name`) LIKE %en% or LOWER(`users`.`name`) LIKE %en% or LOWER(`panichd_tickets`.`updated_at`) LIKE %en% or LOWER(`panichd_categories`.`name`) LIKE %en% or LOWER(`panichd_tags`.`name`) LIKE %en%) group by `panichd_tickets`.`id`) count_row_table)

hi sir or madam,
I really like this laravel package ,its working perfectly in laravel framework 6 and 7.
i have installed in local server and i am using laravel 7 +.so i need a help to integrate panichd app with ldap (active
directory).
i am using this panichd app in my company. we already have our users in ldap . How i can authentication my
company users in ldap server with panichd app.help me to add ldap authentication in this panichd app.

I am attempting to install with laravel 8.x and I am running into this error ...

Generating optimized autoload files
> Illuminate\Foundation\ComposerScripts::postAutoloadDump
> @php artisan package:discover --ansi

   Illuminate\Database\QueryException

  could not find driver (SQL: select * from information_schema.tables where table_schema = pp_website and table_name = migrations and table_type = 'BASE TABLE')

  at vendor/laravel/framework/src/Illuminate/Database/Connection.php:678
     674▕         // If an exception occurs when attempting to run a query, we'll format the error
     675▕         // message to include the bindings with SQL, which will make this exception a
     676▕         // lot more helpful to the developer instead of just the database's errors.
     677▕         catch (Exception $e) {
  ➜ 678▕             throw new QueryException(
     679▕                 $query, $this->prepareBindings($bindings), $e
     680▕             );
     681▕         }
     682▕

  1   [internal]:0
      Illuminate\Foundation\Application::Illuminate\Foundation\{closure}()

      +2 vendor frames
  4   [internal]:0
      Illuminate\Foundation\Application::Illuminate\Foundation\{closure}()
Script @php artisan package:discover --ansi handling the post-autoload-dump event returned with error code 1

Installation failed, reverting ./composer.json and ./composer.lock to their original content.

Hello,

Is this package still maintained ? if so is an upgrading to laravel 9 possible ?

Thanks

"Trying to get property 'lang' of non-object (View: C:\xampp\htdocs\laravel\ticketit\vendor\panichd\panichd\src\Views\shared\nav.blade.php) (View: C:\xampp\htdoc ▶"

Hi,
When accessing the 'Members' page on admin, this error showed up:

Illuminate\Routing\Exceptions\UrlGenerationException Missing required parameters for [Route: panichd.member.update] [URI: panichd/member/{member}].

does this relate to 'user_route' config? the default value is 'disabled', I tried to change to 'user' or 'enabled'. it seems not helping.
my app is typical laravel app and uses the default 'user' for members.

Thanks,

apologize in advance, I am having a problem here while doing the installation, the user_id in my users table is in the form of a string and does not allow the find query to be done, is there a solution for the user_id type string like me?

Hi!

I can see that I can enable the departments feature, but there is no where in the interface where I can specify new departments. And I don't see where I can assign Agents to a department either?

Can you elaborate on how the Departments Feature is suppose to be used?

Thanks!

Hi,
Thanks for making panichelpdesk available, nice work. I'm an integrator with just moderate coding knowledge. How do we add new custom fields eg. Site Code, Device type, etc to tickets?

Regards,

How to remove panichd in the URL?
thank you.

Hello
I've started testing PanicHD and it looks pretty good.
However, I am encountering some errors on the dashboard:

Uncaught Error: Autoload failed with: SyntaxError: JSON.parse: expected property name or '}' at line 2 column 13 of the JSON data
Nc https://www.google.com/jsapi?autoload={ 'modules':[{ 'name':'visualization', 'version':'1', 'packages':['corechart'] }] }:130
Lc https://www.google.com/jsapi?autoload={ 'modules':[{ 'name':'visualization', 'version':'1', 'packages':['corechart'] }] }:129
https://www.google.com/jsapi?autoload={ 'modules':[{ 'name':'visualization', 'version':'1', 'packages':['corechart'] }] }:143
https://www.google.com/jsapi?autoload={ 'modules':[{ 'name':'visualization', 'version':'1', 'packages':['corechart'] }] }:143
jsapi:130:275
Uncaught Error: Must call google.charts.load before google.charts.setOnLoadCallback
X https://www.google.com/jsapi?autoload={ 'modules':[{ 'name':'visualization', 'version':'1', 'packages':['corechart'] }] }:136
http://localhost:8080/panichd/dashboard:492

I searched in the issues but I didn't find anything similar.
Am I the only one to encounter these errors?

We do not use the typical Laravel namespace scheme. App/Model and App/Http/Controller are hard coded throughout system. Can these be made into parameters or able to read composer.json:autoload:psr-4 ???

I supose I coule create a fork but would rather not. Other ideas for a workaround????

Thanks
Jim

I got this Error. How to fix this error? I followed the installation instructions. Thanks

Please help

{"draw":4,"recordsTotal":0,"recordsFiltered":0,"data":[],"error":"Exception Message:\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column '0' in 'field list' (SQL: select count(*) as aggregate from (select panichd_tickets.id, panichd_tickets.created_at, panichd_tickets.subjectassubject, panichd_tickets.hiddenashidden, panichd_tickets.contentascontent, panichd_tickets.interventionasintervention, panichd_tickets.status_idasstatus_id, panichd_statuses.nameasstatus, panichd_statuses.colorascolor_status, panichd_priorities.colorascolor_priority, panichd_categories.colorascolor_category, panichd_tickets.start_dateasstart_date, 0-CONVERT(date_format(panichd_tickets.start_date, '%Y%m%d%h%i%s'), SIGNED INTEGER) as inverse_start_date, CASE panichd_tickets.limit_date WHEN NULL THEN 0 ELSE 1 END as has_limit, panichd_tickets.limit_dateaslimit_date, 0-CONVERT(date_format(panichd_tickets.limit_date, '%Y%m%d%h%i%s'), SIGNED INTEGER) as inverse_limit_date, panichd_tickets.limit_dateascalendar, panichd_tickets.updated_atasupdated_at, panichd_tickets.completed_atascompleted_at, panichd_tickets.agent_id, group_concat(agent.name) AS agent_name, panichd_priorities.nameaspriority, panichd_priorities.magnitudeaspriority_magnitude, panichd_members.nameasowner_name, panichd_tickets.user_id, panichd_tickets.creator_id, panichd_tickets.category_id, panichd_categories.nameascategory, group_concat(panichd_tags.id) AS tags_id, group_concat(panichd_tags.name) AS tags, group_concat(panichd_tags.bg_color) AS tags_bg_color, group_concat(panichd_tags.text_color) AS tags_text_color, 0asdeleted_owner, (select count(*) from panichd_attachmentswherepanichd_tickets.id=panichd_attachments.ticket_id) as all_attachments_count, (select count(*) from panichd_commentswherepanichd_tickets.id=panichd_comments.ticket_idandtypein (reply, note, completetx) andtypein (reply, complete, completetx, reopen)) ascomments_count, (select count(*) from panichd_commentswherepanichd_tickets.id=panichd_comments.ticket_idandtypein (reply, note, completetx) andtypein (reply, complete, completetx, reopen) andpanichd_comments.updated_at> 2018-04-07 00:00:00) asrecent_comments_countfrompanichd_ticketsinner joinusersonusers.id=panichd_tickets.user_idinner joinpanichd_membersonpanichd_members.id=panichd_tickets.user_idinner joinpanichd_statusesonpanichd_statuses.id=panichd_tickets.status_idinner joinpanichd_membersasagentonagent.id=panichd_tickets.agent_idinner joinpanichd_prioritiesonpanichd_priorities.id=panichd_tickets.priority_idinner joinpanichd_categoriesonpanichd_categories.id=panichd_tickets.category_idleft joinpanichd_taggablesonpanichd_tickets.id=panichd_taggables.taggable_idandpanichd_taggables.taggable_type= PanicHD\\PanicHD\\Models\\Ticket left joinpanichd_tagsonpanichd_taggables.tag_id=panichd_tags.idwherecompleted_atis null anduser_id= 1 andhidden= 0 anduser_id= 1 andhidden= 0 group bypanichd_tickets.id) count_row_table)"}

After following all the steps (using command line), when I go to mydomain/panichd I got:

ErrorException
Undefined variable: setting (View: /var/www/vendor/panichd/panichd/src/Views/install/status.blade.php)

Not sure what I did wrong. Does anyone faced this problem before? I'm using laravel/framework "^8.75" (specifically"v8.83.18")

Hello guys, I'm new in this world and I'm learning about laravel. Now, I'have a problem loading tables of tickets. My browser says:

"DataTables warning: table id=tickets-table - Ajax error. For more information about this error, please see http://datatables.net/tn/7"

In web browser console I get this errors:

"jQuery.Deferred exception: $(...).tooltip is not a function TypeError: $(...).tooltip is not a function
at HTMLDocument."

"jquery-3.3.1.min.js:2 Uncaught TypeError: $(...).tooltip is not a function
at HTMLDocument."

And with this I get a 500 error code
"tickets/data/active?draw=1&columns%5B0......... 500"

What should I do?

Hi!
I have installed laravel 8
then installed laravel/breeze
then ran npm install && npm run dev
artisan migrate
open http://your-laravel-app-URL/panichd
after a short installation: Error Class 'App\User' not found

What can you do next?

while creating a ticket as user the window doesn't close after clicking add
I checked the console and it throws a jquery error

jquery-3.4.1.min.js:2 POST http://127.0.0.1:8000/tickets 500 (Internal Server Error)
send @ jquery-3.4.1.min.js:2
ajax @ jquery-3.4.1.min.js:2
ajax_form_submit @ create:380
(anonymous) @ create:361
dispatch @ jquery-3.4.1.min.js:2
v.handle @ jquery-3.4.1.min.js:2

is there any reason why App\User is not configurable , instead of forcing user to follow a structure ?

The 'users' table in our system has first_name and last_name in separate cols, however I think panichd is assuming there is a name col. See attached.

Hello,
the screen stays fixed when the Mail Server cannot be reached?
What should I do to give a warning when the Mail Server cannot be reached and complete the registration?

Hi, I am changing the language to Spanish. At first there where some words that were not included in the package, but I added them into lang.php and it worked almosto for all, but it did not when I try to get datetime-text and minute-abbr.

I got a "panichd::lang.datetime-text" and "panichd::lang.minute-abbr", instead of the calendar and last update info.

Any idea on how to solve it? Thanks!