Opensource.Platon.SK: phpMyEdit: Color Coding output question

Index » Projekty » phpMyEdit » Fórum » Color Coding output question

phpMyEdit General Color Coding output question

Odoslať novú tému Odpovedať na tému

ARADTech Založený: 03.10.2004 Príspevky: 3

Zaslal: 2004-10-03 21:20
Návrat hore Odpovedať s citátom

Ok here is what I want to do and I have no idea how it is best to achieve this.

In my table I have a enum field that has these 3 status's
AVAIL , PENDING , SOLD.

What I am trying to achieve is to have the page show a different color in the view for each of those status's so for instance the AVAIL would show up green , the PENDING yellow, and the SOLD red.

Any help would be much appreciated , please and thank you in advance :)

Peace and Creativity
Chris

ARADTech Založený: 03.10.2004 Príspevky: 3

Zaslal: 2004-10-03 22:56
Návrat hore Odpovedať s citátom

Kód:

$opts['fdd']['status'] = array(
'name' => 'Status',
'select' => 'T',
'escape' => false,
'maxlen' => 7,
'values' => array(
"avail",
"pending",
"sold"),
'default' => 'avail',
'sort' => true
);

$opts['fdd']['status']['sql|LF'] =
'if( status = "sold",
CONCAT("",
status, ""), status )';

This will color code the status to red, how do I make it do the rest ?

Any help is much appreciated :)

Peace and Creativity
Chris

ajh Založený: 17.12.2003 Príspevky: 236

Zaslal: 2004-10-04 22:07
Návrat hore Odpovedať s citátom

How about:

Kód:

$opts['fdd']['status']['sql|LF'] =
'CONCAT("", status, "")';

You need to check the exact syntax as I've probably introduced a typo...for your ref, this is the page in the MySQL manual:
http://dev.mysql.com/doc/mysql/en/Control_flow_functions.html

ARADTech Založený: 03.10.2004 Príspevky: 3

Zaslal: 2004-10-05 00:18
Návrat hore Odpovedať s citátom

Thanks bro that worked perfect, much appreciated!

Peace and Creativity
Chris

bentuinstra Založený: 12.09.2004 Príspevky: 29

Zaslal: 2005-02-16 10:41
Návrat hore Odpovedať s citátom

Hi,

I would like to do something with background color of a date field. I use this code:

Kód:

$opts['fdd']['DUEDATE'] = array(
'name' => 'DUEDATE',
'escape' => false,
'select' => 'T',
'calendar' => true,
'maxlen' => 10,
'sort' => true,
'sql|LF' => 'CONCAT("", PMEtable0.DUEDATE, "")'
);

The color always goes for the "ELSE" option, what do I do wrong?

Kind regards,

Ben

ajh Založený: 17.12.2003 Príspevky: 236

Zaslal: 2005-02-16 10:54
Návrat hore Odpovedať s citátom

Try this:

Kód:

$opts['fdd']['DUEDATE'] = array(
'name' => 'DUEDATE',
'escape' => false,
'select' => 'T',
'calendar' => true,
'maxlen' => 10,
'sort' => true,
'sql|LF' => 'CONCAT("", PMEtable0.DUEDATE, "")'
);

Again - check the syntax in the MySQL manual

bentuinstra Založený: 12.09.2004 Príspevky: 29

Zaslal: 2005-02-16 12:51
Návrat hore Odpovedať s citátom

Hi AJH,

This works fine. (Syntax oke ;-)

But it has a strange side effect. Since I sort on the dued[img]ate I now see that the records who are overdue (duedate<curdate) are sorted below the other records.

Do you have any idea what is happening here?

kind regards,

Ben

bentuinstra Založený: 12.09.2004 Príspevky: 29

Zaslal: 2005-02-16 12:55
Návrat hore Odpovedať s citátom

Found the solution.

It seems that the sorting is done on the whole field (including colorcode). Since the colorcode is earlier in the field....

So I have to change colors ;-)

Cheers Ben

ajh Založený: 17.12.2003 Príspevky: 236

Zaslal: 2005-02-16 14:47
Návrat hore Odpovedať s citátom

If you want the correct sort sequence, why don't you put an HTML comment just before the SPAN with the field data in it. That should fool PME:

Kód:

'sql|LF' => 'CONCAT("", PMEtable0.DUEDATE, "")'

PME will sort on whatever is in the comment, but will display whatever is in the SPAN.

bentuinstra Založený: 12.09.2004 Príspevky: 29

Zaslal: 2005-02-18 09:53
Návrat hore Odpovedať s citátom

I will test this next monday,

Kind regards Ben

bentuinstra Založený: 12.09.2004 Príspevky: 29

Zaslal: 2005-02-24 13:07
Návrat hore Odpovedať s citátom

Hi AJH,

Yhis code works fine, exactly like I wanted it to do,

Thanks a lot for your time and support,

Ben

westdesign Založený: 20.11.2006 Príspevky: 2

Zaslal: 2007-09-19 13:28
Návrat hore Odpovedať s citátom

bentuinstra Napísal:

Hi AJH,

Yhis code works fine, exactly like I wanted it to do,

Thanks a lot for your time and support,

Ben

At the actualy version is something changed ? I try in all the ways using the codes above, but I can't coloring in different way some value.
The <span.... code are displayed like text in the page... and is not change the style...

I think something if filtering the html codes....
Any help ?!
Thanx in advance...

bentuinstra Založený: 12.09.2004 Príspevky: 29

Zaslal: 2007-09-19 14:20
Návrat hore Odpovedať s citátom

Hi Westdesign,

This is the code I use:

Kód:

$opts['fdd']['DATUMGEREED'] = array(
'name' => 'GEREED',
'select' => 'T',
'calendar' => true,
'nowrap' => true,
'maxlen' => 10,
'escape' => false,
'sql|LF' => 'CONCAT("", PMEtable0.DATUMGEREED, "")',
'sort' => true
);

Hope this example helps.

The escape line is important.

Kind regards,

Ben

franciscohm Založený: 08.05.2008 Príspevky: 33

Zaslal: 2008-05-09 12:33
Návrat hore Odpovedať s citátom

Hi all,

I do not know why (maybe because I am using MySQL 5.1)

The expression CASE does not work for me like in:

Kód:

$opts['fdd']['provider']['sql|LF'] = 'CONCAT("", provider, "")';

However the expression IF works fine, like in:

Kód:

$opts['fdd']['provider']['sql|LF'] = 'if( provider= "Ferrari", CONCAT("", provider, ""), if( provider= "BMW", CONCAT("", provider, ""),provider))';

Maybe this is of interest for anyboy else... :-)

collegefootball Založený: 09.03.2024 Príspevky: 261

Zaslal: 2024-04-04 04:33
Návrat hore Odpovedať s citátom

Odoslať novú tému Odpovedať na tému



	Vedenie
	Aktivity
	Komercia
	Podpora
	História
	Kontakt



	Akcie
	Administrácia
	Rozličné
	Tipy a triky
	Vývojárske zdroje
	Tlačové správy



	ep
	fastcgi-gallery
	libcfg+
	Metafox
	mylist
	phpMyEdit
	phpWebFileManager
	PLaTos
	thinkpad-status
	Tučniak
	sendxmpp
	vimconfig



	Webhosting
	Doménový Backorder
	Nginx podpora
	MôjFax
	Heslo.sk
	Dostupnosť


Copyright © 2002-2006 Platon Group Stránka používa redakčný systém Metafox	Na začiatok · Odkazový formulár · Prihláška Upozorniť na chybu na PLATON.SK webstránke · Podmienky použitia · Ochrana osobných údajov