Query_list on differents rows while table already in a left join

egw-cw 2007-12-18 15:18:00 UTC #1

Hi,

I use a “left join table egw_cal_user AS cu” in the main select statement for my get_rows.

That way, I get all the events in which the connected user was an attendee.

On my rows selection, I try to get (for one row) all names of the other attendees at this event (other people than the one connected).

To get the list of these people, I use query_list this way :
in my ui : $ids = parent::grab_attendees($cal_id,$userid);

in my bo :
function grab_attendees($cal_id,$userid)
{
if (!$cal_id || !$userid) return false;

	$condition = '( cu.cal_id = '. $cal_id;
$condition .= ' AND cu.cal_user_id != '. $userid;
$condition .= ' )';
$ids = $this->query_list($this->cu.cal_user_id,'',array($condition));

	return $ids;			
}

But I get no other attendes. It seems that it takes the first get_rows selection as egw_cal_user table instead of the overall table.

I tried a lot of things (ex : egw_cal_user.cal_id in my $condition, but I got an SQL error…) but I don’t the see the sun light in this tunnel.

How could I query_list other rows from this table, independantly from the main search ??

any idea welcome.

Thanks
eGw fan

Leithoff_Klaus 2007-12-18 16:48:46 UTC #2

Hi, have a look in infolog.
class.soinfolog.inc.php
function search.
first all infologs are retrieved, with a left join to join all userdefined
fields
after that we step through the resultset and grab all extra fields for the
infolog
entry and merge them with the original resultset.

Note, the query there uses a “native” db function
$this->db->select($this->extra_table,’*’,array(‘info_id’=>array_keys($ids)),LINE,FILE);

This should work for your query too.
Regards
Klaus

“eGw fan” egw@chipway.com schrieb:

Hi,

I use a “left join table egw_cal_user AS cu” in the main select statement
for my get_rows.

That way, I get all the events in which the connected user was an
attendee.

On my rows selection, I try to get (for one row) all names of the other
attendees at this event (other people than the one connected).

To get the list of these people, I use query_list this way :
in my ui : $ids = parent::grab_attendees($cal_id,$userid);

in my bo :
function grab_attendees($cal_id,$userid)
{
if (!$cal_id || !$userid) return false;
            $condition = '( cu.cal_id = '. $cal_id;
$condition .= ' AND cu.cal_user_id != '. $userid;
$condition .= ' )';
$ids = $this->query_list($this->cu.cal_user_id,'',array($condition));

            return $ids;                        
    }  
But I get no other attendes. It seems that it takes the first get_rows
selection as egw_cal_user table instead of the overall table.

I tried a lot of things (ex : egw_cal_user.cal_id in my $condition, but I
got an SQL error…) but I don’t the see the sun light in this tunnel.

How could I query_list other rows from this table, independantly from the
main search ??

any idea welcome.

Thanks
eGw fan

View this message in context:

http://www.nabble.com/query_list-on-differents-rows-while-table-already-in-a-left-join-tp14398896s3741p14398896.html

Sent from the egroupware-developers mailing list archive at Nabble.com.

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.

http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

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

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

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

egw-cw 2007-12-19 16:42:44 UTC #3

EDIT :
I solved it by putting an unset($this->data) in the read_ids function of my bo.

Thanks a lot, Ralf and Klaus, for your help !!

eGw Fan

Big thanks Klaus,

It works with the db function
$this->db->select(xxxx);

So, for an event, I can find

cal_user_id of every attendee in the egw_cal_user
for every cal_id, I can find name, address in the addressbook

Now I have just a problem with the 2) search : I can’t unset data of previous ids, so I have at the end, all attendees of all events selected.

I tried unset($ids); and $ids =’’; but I still have all that garbage.

I use foreach on the arrays.

Do you have an idea about cleaning my ids ??

Thank you.

Leithoff:

Hi, have a look in infolog.
class.soinfolog.inc.php
function search.
first all infologs are retrieved, with a left join to join all userdefined
fields
after that we step through the resultset and grab all extra fields for the
infolog
entry and merge them with the original resultset.

Note, the query there uses a “native” db function
$this->db->select($this->extra_table,’*’,array(‘info_id’=>array_keys($ids)),LINE,FILE);

This should work for your query too.
Regards
Klaus

“eGw fan” egw@chipway.com schrieb:
Hi,

I use a “left join table egw_cal_user AS cu” in the main select statement
for my get_rows.

That way, I get all the events in which the connected user was an
attendee.

On my rows selection, I try to get (for one row) all names of the other
attendees at this event (other people than the one connected).

To get the list of these people, I use query_list this way :
in my ui : $ids = parent::grab_attendees($cal_id,$userid);

in my bo :
function grab_attendees($cal_id,$userid)
{
if (!$cal_id || !$userid) return false;
            $condition = '( cu.cal_id = '. $cal_id;
$condition .= ' AND cu.cal_user_id != '. $userid;
$condition .= ' )';
$ids = $this->query_list($this->cu.cal_user_id,'',array($condition));

            return $ids;                        
    }  
But I get no other attendes. It seems that it takes the first get_rows
selection as egw_cal_user table instead of the overall table.

I tried a lot of things (ex : egw_cal_user.cal_id in my $condition, but I
got an SQL error…) but I don’t the see the sun light in this tunnel.

How could I query_list other rows from this table, independantly from the
main search ??

any idea welcome.

Thanks
eGw fan

View this message in context:
http://www.nabble.com/query_list-on-differents-rows-while-table-already-in-a-left-join-tp14398896s3741p14398896.html

Sent from the egroupware-developers mailing list archive at Nabble.com.

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.

http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

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

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

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

Ralf_Becker_6 2007-12-19 17:28:27 UTC #4

Hi,

foreach($arr as $key => $val)
{
unset($arr[$key]);
}

in case that was the question

Foreach operates on a copy of $arr, so unsetting $val does not work.

Ralf

eGw fan schrieb:

Big thanks Klaus,

It works with the db function
$this->db->select(xxxx);

So, for an event, I can find

cal_user_id of every attendee in the egw_cal_user

for every cal_id, I can find name, address in the addressbook

Now I have just a problem with the 2) search : I can’t unset data of
previous ids, so I have at the end, all attendees of all events selected.

I tried unset($ids); and $ids =’’; but I still have all that garbage.

I use foreach on the arrays.

Do you have an idea about cleaning my ids ??

Thank you.

Leithoff, Klaus wrote:
Hi, have a look in infolog.
class.soinfolog.inc.php
function search.
first all infologs are retrieved, with a left join to join all userdefined
fields
after that we step through the resultset and grab all extra fields for the
infolog
entry and merge them with the original resultset.

Note, the query there uses a “native” db function
$this->db->select($this->extra_table,’*’,array(‘info_id’=>array_keys($ids)),LINE,FILE);

This should work for your query too.
Regards
Klaus

“eGw fan” egw@chipway.com schrieb:
Hi,

I use a “left join table egw_cal_user AS cu” in the main select
statement
for my get_rows.

That way, I get all the events in which the connected user was an
attendee.
On my rows selection, I try to get (for one row) all names of the other
attendees at this event (other people than the one connected).

To get the list of these people, I use query_list this way :
in my ui : $ids = parent::grab_attendees($cal_id,$userid);

in my bo :
function grab_attendees($cal_id,$userid)
{
if (!$cal_id || !$userid) return false;
            $condition = '( cu.cal_id = '. $cal_id;
$condition .= ' AND cu.cal_user_id != '. $userid;
$condition .= ' )';
$ids = $this->query_list($this->cu.cal_user_id,'',array($condition));

            return $ids;                        
    }  
But I get no other attendes. It seems that it takes the first get_rows
selection as egw_cal_user table instead of the overall table.

I tried a lot of things (ex : egw_cal_user.cal_id in my $condition, but I
got an SQL error…) but I don’t the see the sun light in this tunnel.

How could I query_list other rows from this table, independantly from the
main search ??

any idea welcome.

Thanks
eGw fan

View this message in context:
http://www.nabble.com/query_list-on-differents-rows-while-table-already-in-a-left-join-tp14398896s3741p14398896.html

Sent from the egroupware-developers mailing list archive at Nabble.com.

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.

http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

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

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

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

–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0

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

egw-cw 2007-12-19 20:34:37 UTC #5

Thank you Ralf for your answer.

In my mind it is the right question, but it doesn’t work. I tried calling array and key some different ways, but it still doesn’t work !

Could it come from the fact, that I have on foreach embedded in another foreach ??

I am wandering ??

Any other idea ?

Ralf Becker-3:

Hi,

foreach($arr as $key => $val)
{
unset($arr[$key]);
}

in case that was the question

Foreach operates on a copy of $arr, so unsetting $val does not work.

Ralf

eGw fan schrieb:
Big thanks Klaus,

It works with the db function
$this->db->select(xxxx);

So, for an event, I can find

cal_user_id of every attendee in the egw_cal_user

for every cal_id, I can find name, address in the addressbook

Now I have just a problem with the 2) search : I can’t unset data of
previous ids, so I have at the end, all attendees of all events selected.

I tried unset($ids); and $ids =’’; but I still have all that garbage.

I use foreach on the arrays.

Do you have an idea about cleaning my ids ??

Thank you.

Leithoff, Klaus wrote:
Hi, have a look in infolog.
class.soinfolog.inc.php
function search.
first all infologs are retrieved, with a left join to join all userdefined
fields
after that we step through the resultset and grab all extra fields for the
infolog
entry and merge them with the original resultset.

Note, the query there uses a “native” db function
$this->db->select($this->extra_table,’*’,array(‘info_id’=>array_keys($ids)),LINE,FILE);

This should work for your query too.
Regards
Klaus

“eGw fan” egw@chipway.com schrieb:
Hi,

I use a “left join table egw_cal_user AS cu” in the main select
statement
for my get_rows.

That way, I get all the events in which the connected user was an
attendee.
On my rows selection, I try to get (for one row) all names of the other
attendees at this event (other people than the one connected).

To get the list of these people, I use query_list this way :
in my ui : $ids = parent::grab_attendees($cal_id,$userid);

in my bo :
function grab_attendees($cal_id,$userid)
{
if (!$cal_id || !$userid) return false;
            $condition = '( cu.cal_id = '. $cal_id;
$condition .= ' AND cu.cal_user_id != '. $userid;
$condition .= ' )';
$ids = $this->query_list($this->cu.cal_user_id,'',array($condition));

            return $ids;                        
    }  
But I get no other attendes. It seems that it takes the first get_rows
selection as egw_cal_user table instead of the overall table.

I tried a lot of things (ex : egw_cal_user.cal_id in my $condition, but I
got an SQL error…) but I don’t the see the sun light in this tunnel.

How could I query_list other rows from this table, independantly from the
main search ??

any idea welcome.

Thanks
eGw fan

View this message in context:
http://www.nabble.com/query_list-on-differents-rows-while-table-already-in-a-left-join-tp14398896s3741p14398896.html

Sent from the egroupware-developers mailing list archive at Nabble.com.

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.

http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

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

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

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

Ralf_Becker_6 2007-12-19 21:04:29 UTC #6

foreach($arr as $key => $value)
{
foreach($value as $k => $val)
{
unset($arr[$key][$k]);
}
}

As $value is only a copy of $arr[$key], you have to do the unsets in the
outmost array.

Under php5 you might think to use a

foreach($arr as $key => &$value)

But if you unset $value, you unset the reference to $arr[$key], but not
$arr[$key]

Ralf

eGw fan schrieb:

Thank you Ralf for your answer.

In my mind it is the right question, but it doesn’t work. I tried calling
array and key some different ways, but it still doesn’t work !

Could it come from the fact, that I have on foreach embedded in another
foreach ??

I am wandering ??

Any other idea ?

Ralf Becker-3 wrote:
Hi,

foreach($arr as $key => $val)
{
unset($arr[$key]);
}

in case that was the question

Foreach operates on a copy of $arr, so unsetting $val does not work.

Ralf

eGw fan schrieb:
Big thanks Klaus,

It works with the db function
$this->db->select(xxxx);

So, for an event, I can find

cal_user_id of every attendee in the egw_cal_user

for every cal_id, I can find name, address in the addressbook

Now I have just a problem with the 2) search : I can’t unset data of
previous ids, so I have at the end, all attendees of all events selected.

I tried unset($ids); and $ids =’’; but I still have all that garbage.

I use foreach on the arrays.

Do you have an idea about cleaning my ids ??

Thank you.

Leithoff, Klaus wrote:
Hi, have a look in infolog.
class.soinfolog.inc.php
function search.
first all infologs are retrieved, with a left join to join all
userdefined
fields
after that we step through the resultset and grab all extra fields for
the
infolog
entry and merge them with the original resultset.

Note, the query there uses a “native” db function
$this->db->select($this->extra_table,’*’,array(‘info_id’=>array_keys($ids)),LINE,FILE);

This should work for your query too.
Regards
Klaus

“eGw fan” egw@chipway.com schrieb:
Hi,

I use a “left join table egw_cal_user AS cu” in the main select
statement
for my get_rows.

That way, I get all the events in which the connected user was an
attendee.
On my rows selection, I try to get (for one row) all names of the other
attendees at this event (other people than the one connected).

To get the list of these people, I use query_list this way :
in my ui : $ids = parent::grab_attendees($cal_id,$userid);

in my bo :
function grab_attendees($cal_id,$userid)
{
if (!$cal_id || !$userid) return false;
            $condition = '( cu.cal_id = '. $cal_id;
$condition .= ' AND cu.cal_user_id != '. $userid;
$condition .= ' )';
$ids =
$this->query_list($this->cu.cal_user_id,’’,array($condition));
            return $ids;                        
    }  
But I get no other attendes. It seems that it takes the first get_rows
selection as egw_cal_user table instead of the overall table.

I tried a lot of things (ex : egw_cal_user.cal_id in my $condition, but
I
got an SQL error…) but I don’t the see the sun light in this tunnel.

How could I query_list other rows from this table, independantly from
the
main search ??

any idea welcome.

Thanks
eGw fan

View this message in context:
http://www.nabble.com/query_list-on-differents-rows-while-table-already-in-a-left-join-tp14398896s3741p14398896.html

Sent from the egroupware-developers mailing list archive at Nabble.com.

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.

http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

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

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

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

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

egw-cw 2007-12-20 08:34:15 UTC #7

Hi Ralf,

I am in that case (no direct relation between $value and second foreach)

foreach($arr as $key => $value)
{
$attendees = parent::search_attendees_ids($cal_id);

    foreach($attendees as $k => $val)
{
	unset($arr[$key][$k]);  --> Fatal error: Cannot unset string offsets
}

or here unset($arr[$key]); --> do not clear my ids, as you stated.
}

Thank you for your help.

Ralf Becker-3:

foreach($arr as $key => $value)
{
foreach($value as $k => $val)
{
unset($arr[$key][$k]);
}
}

As $value is only a copy of $arr[$key], you have to do the unsets in the
outmost array.

Under php5 you might think to use a

foreach($arr as $key => &$value)

But if you unset $value, you unset the reference to $arr[$key], but not
$arr[$key]

Ralf

eGw fan schrieb:
Thank you Ralf for your answer.

In my mind it is the right question, but it doesn’t work. I tried calling
array and key some different ways, but it still doesn’t work !

Could it come from the fact, that I have on foreach embedded in another
foreach ??

I am wandering ??

Any other idea ?

Ralf Becker-3 wrote:
Hi,

foreach($arr as $key => $val)
{
unset($arr[$key]);
}

in case that was the question

Foreach operates on a copy of $arr, so unsetting $val does not work.

Ralf

eGw fan schrieb:
Big thanks Klaus,

It works with the db function
$this->db->select(xxxx);

So, for an event, I can find

cal_user_id of every attendee in the egw_cal_user

for every cal_id, I can find name, address in the addressbook

Now I have just a problem with the 2) search : I can’t unset data of
previous ids, so I have at the end, all attendees of all events selected.

I tried unset($ids); and $ids =’’; but I still have all that garbage.

I use foreach on the arrays.

Do you have an idea about cleaning my ids ??

Thank you.

Leithoff, Klaus wrote:
Hi, have a look in infolog.
class.soinfolog.inc.php
function search.
first all infologs are retrieved, with a left join to join all
userdefined
fields
after that we step through the resultset and grab all extra fields for
the
infolog
entry and merge them with the original resultset.

Note, the query there uses a “native” db function
$this->db->select($this->extra_table,’*’,array(‘info_id’=>array_keys($ids)),LINE,FILE);

This should work for your query too.
Regards
Klaus

“eGw fan” egw@chipway.com schrieb:
Hi,

I use a “left join table egw_cal_user AS cu” in the main select
statement
for my get_rows.

That way, I get all the events in which the connected user was an
attendee.
On my rows selection, I try to get (for one row) all names of the other
attendees at this event (other people than the one connected).

To get the list of these people, I use query_list this way :
in my ui : $ids = parent::grab_attendees($cal_id,$userid);

in my bo :
function grab_attendees($cal_id,$userid)
{
if (!$cal_id || !$userid) return false;
            $condition = '( cu.cal_id = '. $cal_id;
$condition .= ' AND cu.cal_user_id != '. $userid;
$condition .= ' )';
$ids =
$this->query_list($this->cu.cal_user_id,’’,array($condition));
            return $ids;                        
    }  
But I get no other attendes. It seems that it takes the first get_rows
selection as egw_cal_user table instead of the overall table.

I tried a lot of things (ex : egw_cal_user.cal_id in my $condition, but
I
got an SQL error…) but I don’t the see the sun light in this tunnel.

How could I query_list other rows from this table, independantly from
the
main search ??

any idea welcome.

Thanks
eGw fan

View this message in context:
http://www.nabble.com/query_list-on-differents-rows-while-table-already-in-a-left-join-tp14398896s3741p14398896.html

Sent from the egroupware-developers mailing list archive at Nabble.com.

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.

http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

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

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

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

Leithoff_Klaus 2007-12-20 13:56:05 UTC #8

Not knowing what you do, its hard to give advise
$ids=array();
But if you try to unset or reinitialize global Vars from within a funktion
you
may only reinitalize the local var. This is probably your problem with
unset().
Try collecting the desired data first in an local array and merge this with
the result returned to the frontend only if your datacollection fits
your needs.
The local var should be deleteable/unsettable within/at the beginning of the
foreach
loops, as you step into dataprocessing.
Regards
Klaus

“eGw fan” egw@chipway.com schrieb:

Big thanks Klaus,

It works with the db function
$this->db->select(xxxx);

So, for an event, I can find

cal_user_id of every attendee in the egw_cal_user

for every cal_id, I can find name, address in the addressbook

Now I have just a problem with the 2) search : I can’t unset data of
previous ids, so I have at the end, all attendees of all events selected.

I tried unset($ids); and $ids =’’; but I still have all that garbage.

I use foreach on the arrays.

Do you have an idea about cleaning my ids ??

Thank you.

Leithoff, Klaus wrote:

Hi, have a look in infolog.
class.soinfolog.inc.php
function search.
first all infologs are retrieved, with a left join to join all
userdefined

fields
after that we step through the resultset and grab all extra fields for
the

infolog
entry and merge them with the original resultset.

Note, the query there uses a “native” db function

$this->db->select($this->extra_table,’*’,array(‘info_id’=>array_keys($ids)),LINE,FILE);

This should work for your query too.
Regards
Klaus

“eGw fan” egw@chipway.com schrieb:
Hi,

I use a “left join table egw_cal_user AS cu” in the main select
statement
for my get_rows.

That way, I get all the events in which the connected user was an
attendee.

On my rows selection, I try to get (for one row) all names of the other
attendees at this event (other people than the one connected).

To get the list of these people, I use query_list this way :
in my ui : $ids = parent::grab_attendees($cal_id,$userid);

in my bo :
function grab_attendees($cal_id,$userid)
{
if (!$cal_id || !$userid) return false;
            $condition = '( cu.cal_id = '. $cal_id;
$condition .= ' AND cu.cal_user_id != '. $userid;
$condition .= ' )';
$ids =

$this->query_list($this->cu.cal_user_id,’’,array($condition));

            return $ids;                        
    }  
But I get no other attendes. It seems that it takes the first get_rows
selection as egw_cal_user table instead of the overall table.

I tried a lot of things (ex : egw_cal_user.cal_id in my $condition, but
I
got an SQL error…) but I don’t the see the sun light in this tunnel.

How could I query_list other rows from this table, independantly from
the

main search ??

any idea welcome.

Thanks
eGw fan

View this message in context:

http://www.nabble.com/query_list-on-differents-rows-while-table-already-in-a-left-join-tp14398896s3741p14398896.html

Sent from the egroupware-developers mailing list archive at Nabble.com.

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.

http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

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

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.

http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

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

–
View this message in context:

http://www.nabble.com/query_list-on-differents-rows-while-table-already-in-a-left-join-tp14398896s3741p14420346.html

Sent from the egroupware-developers mailing list archive at Nabble.com.

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.

http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

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

–
Stylite GmbH
[ open style of IT ]

Morschheimer Strasse 15
D - 67292 Kirchheimbolanden

fon 06352 . 70629-0
fax 06352 . 70629-30
email kl@stylite.de

www.stylite.de

Geschäftsführer: Nigel John Vickers, Andre Keller
Registergericht Kaiserslautern, HRB 12087

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

egw-cw 2007-12-20 17:45:04 UTC #9

EDIT :
I solved it by putting an unset($this->data) in the read function of my bo, that was called by the first foreach (the embedding one).

Thanks a lot Ralf, for your help, that put me on the right track … that I follow a long time before finding where and what to unset.

eGw Fan

Ralf Becker-3:

foreach($arr as $key => $value)
{
foreach($value as $k => $val)
{
unset($arr[$key][$k]);
}
}

As $value is only a copy of $arr[$key], you have to do the unsets in the
outmost array.

Under php5 you might think to use a

foreach($arr as $key => &$value)

But if you unset $value, you unset the reference to $arr[$key], but not
$arr[$key]

Ralf

eGw fan schrieb:
Thank you Ralf for your answer.

In my mind it is the right question, but it doesn’t work. I tried calling
array and key some different ways, but it still doesn’t work !

Could it come from the fact, that I have on foreach embedded in another
foreach ??

I am wandering ??

Any other idea ?

Ralf Becker-3 wrote:
Hi,

foreach($arr as $key => $val)
{
unset($arr[$key]);
}

in case that was the question

Foreach operates on a copy of $arr, so unsetting $val does not work.

Ralf

eGw fan schrieb:
Big thanks Klaus,

It works with the db function
$this->db->select(xxxx);

So, for an event, I can find

cal_user_id of every attendee in the egw_cal_user

for every cal_id, I can find name, address in the addressbook

Now I have just a problem with the 2) search : I can’t unset data of
previous ids, so I have at the end, all attendees of all events selected.

I tried unset($ids); and $ids =’’; but I still have all that garbage.

I use foreach on the arrays.

Do you have an idea about cleaning my ids ??

Thank you.

Leithoff, Klaus wrote:
Hi, have a look in infolog.
class.soinfolog.inc.php
function search.
first all infologs are retrieved, with a left join to join all
userdefined
fields
after that we step through the resultset and grab all extra fields for
the
infolog
entry and merge them with the original resultset.

Note, the query there uses a “native” db function
$this->db->select($this->extra_table,’*’,array(‘info_id’=>array_keys($ids)),LINE,FILE);

This should work for your query too.
Regards
Klaus

“eGw fan” egw@chipway.com schrieb:
Hi,

I use a “left join table egw_cal_user AS cu” in the main select
statement
for my get_rows.

That way, I get all the events in which the connected user was an
attendee.
On my rows selection, I try to get (for one row) all names of the other
attendees at this event (other people than the one connected).

To get the list of these people, I use query_list this way :
in my ui : $ids = parent::grab_attendees($cal_id,$userid);

in my bo :
function grab_attendees($cal_id,$userid)
{
if (!$cal_id || !$userid) return false;
            $condition = '( cu.cal_id = '. $cal_id;
$condition .= ' AND cu.cal_user_id != '. $userid;
$condition .= ' )';
$ids =
$this->query_list($this->cu.cal_user_id,’’,array($condition));
            return $ids;                        
    }  
But I get no other attendes. It seems that it takes the first get_rows
selection as egw_cal_user table instead of the overall table.

I tried a lot of things (ex : egw_cal_user.cal_id in my $condition, but
I
got an SQL error…) but I don’t the see the sun light in this tunnel.

How could I query_list other rows from this table, independantly from
the
main search ??

any idea welcome.

Thanks
eGw fan

View this message in context:
http://www.nabble.com/query_list-on-differents-rows-while-table-already-in-a-left-join-tp14398896s3741p14398896.html

Sent from the egroupware-developers mailing list archive at Nabble.com.

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.

http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

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

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

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

Ralf_Becker_6 2007-12-20 17:56:32 UTC #10

Hi,

the object also has an init() method of that purpose.

Ralf

eGw fan schrieb:

EDIT :
I solved it by putting an unset($this->data) in the read function of my bo,
that was called by the first foreach (the embedding one).

Thanks a lot Ralf, for your help, that put me on the right track … that I
follow a long time before finding where and what to unset.

eGw Fan

Ralf Becker-3 wrote:
foreach($arr as $key => $value)
{
foreach($value as $k => $val)
{
unset($arr[$key][$k]);
}
}

As $value is only a copy of $arr[$key], you have to do the unsets in the
outmost array.

Under php5 you might think to use a

foreach($arr as $key => &$value)

But if you unset $value, you unset the reference to $arr[$key], but not
$arr[$key]

Ralf

eGw fan schrieb:
Thank you Ralf for your answer.

In my mind it is the right question, but it doesn’t work. I tried calling
array and key some different ways, but it still doesn’t work !

Could it come from the fact, that I have on foreach embedded in another
foreach ??

I am wandering ??

Any other idea ?

Ralf Becker-3 wrote:
Hi,

foreach($arr as $key => $val)
{
unset($arr[$key]);
}

in case that was the question

Foreach operates on a copy of $arr, so unsetting $val does not work.

Ralf

eGw fan schrieb:
Big thanks Klaus,

It works with the db function
$this->db->select(xxxx);

So, for an event, I can find

cal_user_id of every attendee in the egw_cal_user

for every cal_id, I can find name, address in the addressbook

Now I have just a problem with the 2) search : I can’t unset data of
previous ids, so I have at the end, all attendees of all events
selected.

I tried unset($ids); and $ids =’’; but I still have all that garbage.

I use foreach on the arrays.

Do you have an idea about cleaning my ids ??

Thank you.

Leithoff, Klaus wrote:
Hi, have a look in infolog.
class.soinfolog.inc.php
function search.
first all infologs are retrieved, with a left join to join all
userdefined
fields
after that we step through the resultset and grab all extra fields for
the
infolog
entry and merge them with the original resultset.

Note, the query there uses a “native” db function
$this->db->select($this->extra_table,’*’,array(‘info_id’=>array_keys($ids)),LINE,FILE);

This should work for your query too.
Regards
Klaus

“eGw fan” egw@chipway.com schrieb:
Hi,

I use a “left join table egw_cal_user AS cu” in the main select
statement
for my get_rows.

That way, I get all the events in which the connected user was an
attendee.
On my rows selection, I try to get (for one row) all names of the
other
attendees at this event (other people than the one connected).

To get the list of these people, I use query_list this way :
in my ui : $ids = parent::grab_attendees($cal_id,$userid);

in my bo :
function grab_attendees($cal_id,$userid)
{
if (!$cal_id || !$userid) return false;
            $condition = '( cu.cal_id = '. $cal_id;
$condition .= ' AND cu.cal_user_id != '. $userid;
$condition .= ' )';
$ids =
$this->query_list($this->cu.cal_user_id,’’,array($condition));
            return $ids;                        
    }  
But I get no other attendes. It seems that it takes the first
get_rows
selection as egw_cal_user table instead of the overall table.

I tried a lot of things (ex : egw_cal_user.cal_id in my $condition,
but
I
got an SQL error…) but I don’t the see the sun light in this
tunnel.

How could I query_list other rows from this table, independantly from
the
main search ??

any idea welcome.

Thanks
eGw fan

View this message in context:
http://www.nabble.com/query_list-on-differents-rows-while-table-already-in-a-left-join-tp14398896s3741p14398896.html

Sent from the egroupware-developers mailing list archive at
Nabble.com.

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.

http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

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

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
–
Ralf Becker
eGroupWare Training & Support ==> http://www.egroupware-support.de
Outdoor Unlimited Training GmbH [www.outdoor-training.de]
Handelsregister HRB Kaiserslautern 3587
Geschäftsführer Birgit und Ralf Becker
Leibnizstr. 17, 67663 Kaiserslautern, Germany
Telefon +49 (0)631 31657-0

SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It’s the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

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

This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft® Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/

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