How to edit Customer Information Panel in New Phone TKT

[scotanderson78]

I'm trying to figure out how to display other information from the Customer_User table on the Customer Information Panel within a New Phone Ticket.

I have created a new Access Code column in the Customer_User Table and I have edited the AdminCustomerUser and it displays the new column. I would like this to also show this new column in the Customer Information Panel within a new phone ticket when the agent selects the customer in the "From Customer" field. As of right now it only shows the following information. Any help is greatly appreciated.

Customer Information
Firstname:
Lastname:
Username:
Email:
Phone:
Mobile:
Street:
Location
Open Tickets (1)

[MichaelR]

Inside CustomerUserDataGet add the functionality to return the access code.
Inside AgentCustomerViewTable add support to display the access code.

[scotanderson78]

Thank you for the instructions. I should have said that I'm a novice in my first post. I'm not sure where to find those two items or what to do exactly if I did find them. Any help is greatly appreciated.

[MichaelR]

This is all from the top of my head and is no way 100% accurate

- Inside CustomerUserDataGet add the functionality to return the access code.
This will be inside customer.pm in the system folder, just find where it queries the database and select the other column
Once you have the data return it in the $customer hashmap or whatever it will use

- Inside AgentCustomerViewTable add support to display the access code.
This is a .pm file in either modules or Output/HTML/
Change it to use the extra column we have returned in the $customer hashmap

That's about as far as I can remember without going into the code and figuring everything else out!

[scotanderson78]

This is all from the top of my head and is no way 100% accurate

- Inside CustomerUserDataGet add the functionality to return the access code.
This will be inside customer.pm in the system folder, just find where it queries the database and select the other column
Once you have the data return it in the $customer hashmap or whatever it will use

- Inside AgentCustomerViewTable add support to display the access code.
This is a .pm file in either modules or Output/HTML/
Change it to use the extra column we have returned in the $customer hashmap

That's about as far as I can remember without going into the code and figuring everything else out!

Thank you for the help