Database Tickets / Support

[Heosforo]

Please consider:

- This includes templates that are ready to work.
- No language strings at the moment so if you need to change some text it will have to be manually. Nothing special.
- Once installed, set permissions for each field.

Use this topic or send me a pm If you need help, or if you have any ideas to improve it. I'll be happy to help you.

Thanks to @Herofiles ★ ?

Edited July 31, 2018 by Heosforo

[kmk]

What's the difference vs ips support? 

O qué es lo hace este dB que no puede hacer ips support? 

Edited August 2, 2018 by kmk

[Heosforo]

Hello @kmk

I think both were made with Pages, there should not be much difference.

Creo que ambas estan hechas con Pages, asi que no deberia haber mucha diferencia.

[kmk]

We can think about that, if ips support only for admin, qué tal this is a ticket support for site members use? Example, if site members use my forum and classified or others app to offer services or products, then they need this ticket system to give support to their clients. 

[Warzone]

IPS Support are in the Commerce app. 
This is made with Pages

Then you have to create member groups for each "ticket" database, then set the permission on who can use it - but then again,
u have to make ALOT of groups for each "seller and each buyer" OR the easiest way, like here on ips, make a forum for support. 



 

[Heosforo]

Yes, it should be able to use without problems for any member, setting db view permissions and some small details.
Sí, se debería poder usar sin problemas para cualquier miembro, estableciendo permisos de vista en la db y algunos pequeños detalles.

Do you plan to give it some special use?
Planeas darle un uso especial?

2 minutes ago, Herofiles ★ said:

IPS Support are in the Commerce app. 
This is made with Pages

Then you have to create member groups for each "ticket" database, then set the permission on who can use it - but then again,
u have to make ALOT of groups for each "seller and each buyer" OR the easiest way, like here on ips, make a forum for support. 



 

Thanks for the clarification, I knew that I was missing something ?

[Heosforo]

I've added a simple block, maybe you wanna play with it
 

 

See changelog.

[kmk]

The Image work or not? I try place an image, pero no muestra.....

 

[Heosforo]

Hello @kmk

Yes it was removed.

I can include it again, how would you like it to be displayed?

[kmk]

I think maybe use it to displayed the issue content more attractive. And let admin set a by default image. 

[Heosforo]

@kmk

I've made some changes, you'll need to replace the Record template code with this new one:
record_template.zip

Just go to:
- Pages -> Templates
- Open Database Tickets Display ?
- Open Records and replace.

Should look like this:

Let me know if this is close to what you had in mind.

Edited August 6, 2018 by Heosforo

[Daddy]

Even with permission, I cannot click on any tickets. The title appears hidden. Not sure what I did wrong.

[Heosforo]

Hello @iDeath

Please would you mind to send me a URL to check? (privately if you want)

[Daddy]

@Heosforo It's working now. Seems I was using an old version of the templates.

[Heosforo]

Great ?

[Daddy]

Seems I cannot get them to show for guests. I assume you did that on purpose? I want them to show for guests otherwise it's a blank page ?

[Heosforo]

1 hour ago, iDeath said:

Seems I cannot get them to show for guests. I assume you did that on purpose? I want them to show for guests otherwise it's a blank page ?

Yes ?
Edit each category and change this:

Probably you'll need to configure the database permissions (if you didn't do it before)

Edited August 5, 2018 by Heosforo

[Daddy]

@Heosforo Yeah I want it so you can only see your own records, I mean guests cannot see the categories despite my configuration.

[Heosforo]

@iDeath I see.

Try this:

- Pages -> Templates
- Open Database Tickets Category ?
- Open categoryRow and replace all code with this:
category_code.zip

 

[Daddy]

@Heosforo Sorry, I'm not a complete noob but for whatever reason, your templates saved as random numbers so I wasn't actually sure where the template was.

 

For anyone who would like to still show categories for guests and trigger login on Create Ticket button feel free to use the code below. Database Tickets Category -> CategoryRow

{{$RecordsClass = $category::$contentItemClass;}}
{{$lastPost = $category->lastPost();}}
<div class='ipsGrid_span3 ipsBox ipsPad_half ipsSpacer_top ipsSpacer_bottom ipsDataItem ipsDataItem_responsivePhoto ipsClearfix' data-categoryID="{$category->_id}">
<h4 class='ipsType_sectionTitle ipsType_sectionTitle ipsType_center'>
  <a href="{$category->url()}">{$category->_title}</a>
</h4>
<div class='ipsSpacer_top ipsClearfix'>
<p class='ipsType_center ipsPad'>{$category->_description|raw}</p>
</div>
{{if $category->can('add')}}
<a class="ipsButton ipsButton_medium ipsButton_important ipsButton_fullWidth" href="{$category->url()->setQueryString( array( 'do' => 'form', 'd' => \IPS\cms\Databases\Dispatcher::i()->databaseId ) )}">{lang="cms_add_new_record_button" sprintf="\IPS\cms\Databases::load( $category->database_id )->recordWord( 1 )"}</a>
{{else}}
<a class="ipsButton ipsButton_medium ipsButton_important ipsButton_fullWidth" href="/login" data-ipsmenu-closeonclick="false" data-ipsmenu="" id="elUserSignIn">{lang="cms_add_new_record_button" sprintf="\IPS\cms\Databases::load( $category->database_id )->recordWord( 1 )"}</a>
{{endif}}  
</div>

 

Edited August 6, 2018 by iDeath

[Heosforo]

I don't know what happened, but thanks

[NaisA-]

I get an error on installation.

3C145/3 Something went wrong. Please try again.

 

[Heosforo]

19 minutes ago, The Asian said:

I get an error on installation.

3C145/3 Something went wrong. Please try again.

 

Hello.

Did you use the installation instructions included in the package?

[NaisA-]

On 8/7/2018 at 1:30 PM, Heosforo said:

Hello.

Did you use the installation instructions included in the package?

The first step was to upload the .xml file. That's the error I got in return.

[Heosforo]

Hello @The Asian

It seems that you are installing as a plugin.

This works with Pages App.
Page Management -> Databases -> Add Database -> Upload database.