Categories, displaying

TSH-2 2009-07-28 16:39:33 UTC #1

Hello,
I’ve been working on my new screen, which shows photo and full name.
Now I would like to display more information on the same screen.
I would like to display category data.
Specifically, category name, icon and color
They are located in a table called egw_categories and the names
are cat_name and cat_data.
Is there a way to put these names into eTemplate and have them
seen, I have tried just the name alone and it cannot seem to find them.

Thank you, Tom

Nathan_Gray-2 2009-07-28 16:46:21 UTC #2

…
I would like to display category data.
…
Is there a way to put these names into eTemplate

Just the name is easy, use a read-only select category widget.

If you want more, you can get the information out of $GLOBALS[‘egw’]-

categories object.
Source is at /hpgwapi/inc/class.categories.inc.php.

Nathan Gray
nathan at goarctic dot com

Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what’s new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

TSH-2 2009-07-28 19:14:45 UTC #3

Hello,
Thank you for such a quick reply.
I’m still having some trouble displaying the category name.
I’ve got to be missing something

I’m in eTemplate
’type’ select category
’name’ cat_name
’read only’ checked

This shows nothing, not even an empty box.
When I get this working, I’d like the text to be bold,
would that be an option also?

Thank you, Tom

Nathan_Gray-2 2009-07-28 19:53:33 UTC #4

Hello,
Thank you for such a quick reply.
I’m still having some trouble displaying the category name.
I’ve got to be missing something

I’m in eTemplate
’type’ select category
’name’ cat_name
’read only’ checked

This shows nothing, not even an empty box.

What’s the value of cat_name? It should be an integer, the desired
category ID. In addressbook records, I think it’s called cat_id.
Turn read only off until you get it displaying what you want, it’s a
little easier to figure out.

When I get this working, I’d like the text to be bold,
would that be an option also?

Probably, via CSS.

Nathan Gray
nathan at goarctic dot com

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

TSH-2 2009-07-29 17:00:18 UTC #5

Hello,
I’m still having trouble displaying category name, which is all I need to finish
this project. I’m in a little over my head yet.
The end goal is a simple label on my screen showing in bold the category name
In my function, the only code I thought I needed was

$content = array();
$contact_id = $_GET[‘contact_id’] ? $_GET[‘contact_id’] :
((int)$_GET[‘account_id’] ? ‘account:’.(int)$_GET[‘account_id’] : 0);
if ($contact_id && is_array($content = $this->read($contact_id)))
{
$contact_id = $content[‘id’];
}
$this->tmpl->read(‘addressbook.view.idcard’);
$this->tmpl->exec(‘addressbook.addressbook_ui.view.idcard’,
$content,$sel_options,$readonlys,$content, 2);
This gets me access to display the photo, the full name, and the contact id…
The only thing left is the category text that this contact is in.
The category ‘cat_id’ for this contact is a varchar which comes up as 15, which is correct
The category ‘cat_name’ is a varchar which should come up as the text ‘employee’, and is stored in the table eqw_categories. When I try to reference this via a simple echo or in etemplate label, the cat_name is empty or not found.

I’m sure I’m looking right at the problem and not seeing it.

Thank you for all your help during this project, Tom

Ralf_Becker_6 2009-07-29 17:08:02 UTC #6

Hi Tom,

if you use addressbook_bo::read(), you have to use ‘cat_id’ as name for
the category-select widget - not ‘cat_name’!

Ralf

Tom Hassold schrieb:

Hello,
 I'm still having trouble displaying category name, which is all I
need to finish
 this project.  I'm in a little over my head yet.
 The end goal is a simple label on my screen showing in bold the
category name
 In my function, the only code I thought I needed was
*$content* *=* *array*();
*$contact_id* *=* *$_GET*['contact_id'] ? *$_GET*['contact_id'] :
  ((*int*)*$_GET*['account_id'] ?
'account:'*.*(*int*)*$_GET*['account_id'] : 0);
*if* (*$contact_id* *&&* *is_array*(*$content* *=*
*$this->read*(*$contact_id*)))
{
*  $contact_id* *=* *$content*['id'];
}
*$this->*tmpl*->read*('addressbook.view.idcard');
*$this->*tmpl*->exec*('addressbook.addressbook_ui.view.idcard',
*  $content*,*$sel_options*,*$readonlys*,*$content*, 2);
This gets me access to display the photo, the full name, and the
contact id.
The only thing left is the category text that this contact is in.
The category 'cat_id' for this contact is a varchar which comes up
as 15, which is correct
The category 'cat_name' is a varchar which should come up as the
text 'employee', and is stored in the table eqw_categories. When I
try to reference this via a simple echo or in etemplate label, the
cat_name is empty or not found.
 
I'm sure I'm looking right at the problem and not seeing it.

Thank you for all your help during this project, Tom
 

> Hello,
>  Thank you for such a quick reply.
>  I'm still having some trouble displaying the category name.
>  I've got to be missing something
>
> I'm in eTemplate
>  'type'        select category
>  'name'      cat_name
>  'read only' checked
>
>  This shows nothing, not even an empty box.

What's the value of cat_name?  It should be an integer, the desired 
category ID.  In addressbook records, I think it's called cat_id.
Turn read only off until you get it displaying what you want, it's a 
little easier to figure out.

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers

–
Ralf Becker
Director Software Development

Stylite GmbH
[open style of IT]

Morschheimer Strasse 15
67292 Kirchheimbolanden

fon +49 (0) 6352 70629-0
fax +49 (0) 6352 70629-30
mailto: rb@stylite.de

www.stylite.de
www.egroupware.org

Geschäftsführer Andre Keller, Gudrun Müller,
Nigel Vickers und Ralf Becker
Registergericht Kaiserslautern HRB 30575
Umsatzsteuer-Id / VAT-Id: DE214280951

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers