Help please Adressbook.boadressbook.search

Lili_42 2008-11-19 08:59:27 UTC #1

 * @param array $param
 * @param int $param['start']=0 starting number of the range, if $param['limit'] != 0
 * @param int $param['limit']=0 max. number of entries to return, 0=all
 * @param array $param['fields']=null fields to return or null for all stock fields, fields are in the values (!)
 * @param string $param['query']='' search pattern or '' for none
 * @param string $param['filter']='' filters with syntax like <name>=<value>,<name2>=<value2>,<name3>=!'' for not empty
 * @param string $param['sort']='' sorting: ASC or DESC
 * @param string $param['order']='' column to order, default ('') n_family,n_given,email ASC
 * @param int $param['lastmod']=-1 return only values modified after given timestamp, default (-1) return all
 * @param string $param['cquery']='' return only entries starting with given character, default ('') all
 * @param string $param['customfields']=true return the customfields too, default yes
 * @return array of contacts

an example please ?

Thank you

Nathan_Gray-2 2008-11-19 15:19:20 UTC #2

Hi

@param array $param

@param int $param[‘start’]=0 starting number of the range, if
$param[‘limit’] != 0

@param int $param[‘limit’]=0 max. number of entries to return,
0=all

@param array $param[‘fields’]=null fields to return or null for
all
stock fields, fields are in the values (!)

@param string $param[‘query’]=’’ search pattern or ‘’ for none

@param string $param[‘filter’]=’’ filters with syntax like
=,=,=!’’ for not empty

@param string $param[‘sort’]=’’ sorting: ASC or DESC

@param string $param[‘order’]=’’ column to order, default (’’)
n_family,n_given,email ASC

@param int $param[‘lastmod’]=-1 return only values modified
after given
timestamp, default (-1) return all

@param string $param[‘cquery’]=’’ return only entries starting
with
given character, default (’’) all

@param string $param[‘customfields’]=true return the
customfields too,
default yes

@return array of contacts

an example please ?

$param = array(
‘start’ => 10,
‘limit’ => 10,
‘query’ => ‘gray’,
‘sort’ => ‘ASC’,
‘order’ => ‘n_given’,
‘cquery’ => ‘n’,
);

Should return the second 10 records where the name contains ‘gray’,
starts with ‘n’, sorted by given name ascending.

Nathan Gray
nathan at goarctic dot com

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

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

Lili_42 2008-11-20 15:11:53 UTC #3

Thank you for your example

My exampe :

$param1 = array(‘start’ => ‘0’,‘limit’=>‘0’
,‘query’=>$_GET[‘details’]
,‘sort’=>‘asc’
,‘order’=>‘n_given’
,‘cquery’=>’’);

But I would like to know why in my example the field idem did not go back? How to make ?

Thank you

Nathan_Gray-2 2008-11-20 15:32:13 UTC #4

Hi

Thank you for your example

My exampe :

$param1 = array(‘start’ => ‘0’,‘limit’=>‘0’
,‘query’=>$_GET[‘details’]
,‘sort’=>‘asc’
,‘order’=>‘n_given’
,‘cquery’=>’’);

But I would like to know why in my example the field idem did not go
back?

Why are start and limit strings instead of integers?
What is in $_GET[‘details’]?
What is in your database that you expect to get back?

Nathan Gray
nathan at goarctic dot com

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

Lili_42 2008-11-21 08:04:46 UTC #5

Why are start and limit strings instead of integers?

because I would like all the records

What is in $_GET[‘details’]?

a key word for instance : a name, a tel, an address

What is in your database that you expect to get back?

contact_id, n_family, n_given, org_name, adr_one_street, adr_one_street2, adr_one_localite, adr_one_longitude, adr_one_latitude, tel_work

Nathan Gray:

On 20-Nov-08, at 8:11 AM, Lili_42 wrote:

Hi

Thank you for your example

My exampe :

$param1 = array(‘start’ => ‘0’,‘limit’=>‘0’
,‘query’=>$_GET[‘details’]
,‘sort’=>‘asc’
,‘order’=>‘n_given’
,‘cquery’=>’’);

But I would like to know why in my example the field idem did not go
back?

Why are start and limit strings instead of integers?
What is in $_GET[‘details’]?
What is in your database that you expect to get back?

Nathan Gray
nathan at goarctic dot com

This SF.Net email is sponsored by the Moblin Your Move Developer’s challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

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

Nathan_Gray-2 2008-11-21 15:23:04 UTC #6

What is in $_GET[‘details’]?

a key word for instance : a name, a tel, an address

What is in your database that you expect to get back?

contact_id, n_family, n_given, org_name, adr_one_street,
adr_one_street2,
adr_one_localite, adr_one_longitude, adr_one_latitude, tel_work

From what you sent, it looks like the problem is with your query
parameter. I think the commas (,) and spaces may be affecting your
results.
Search for only one at a time: ‘a name’ , then ‘a tel’, then ‘an
address’ instead of ‘a name, a tel, an address’. ‘an’ won’t match
anything, but ‘a’, ‘name’, ‘tel’ and ‘address’ will.

It’s very uncommon to use table names as sample data. You should make
up some addresses instead.

Nathan Gray
nathan at goarctic dot com

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

Lili_42 2008-11-24 08:16:22 UTC #7

Hi,

In my example, I search to a key word (who can be a zip code or such or an address), to see a list of fields of which the primary key of the table.

And I have the field contact_id only if this contact is not attached to an user count.

What is to be done?

Thank you

Nathan_Gray-2 2008-11-24 17:27:06 UTC #8

Hi,

In my example, I search to a key word (who can be a zip code or such
or an
address), to see a list of fields of which the primary key of the
table.

And I have the field contact_id only if this contact is not attached
to an
user count.

I’m sorry, it appears the language barrier is in the way.
It doesn’t seem like you are understanding what I’m writing, you are
answering different questions from what I ask.

I can only suggest that you go very carefully through the program
flow, and try simple examples until you understand how it works.

Nathan Gray
nathan at goarctic dot com

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

Lili_42 2008-11-25 08:06:14 UTC #9

Desolate I speak English well.

I would just like waited result to be the style of following request:

select contact_id, n_family, n_given, org_name, adr_one_street, adr_one_street2, adr_one_localite, adr_one_longitude, adr_one_latitude, tel_work from egw_addressbook where
adr_one_localite like ‘%$champ%’ or org_name like '%$champ%'
order by contact_id desc

Thank you

Lili_42 2009-01-08 08:41:38 UTC #10

Hi,

Is what in the managerProject, they can make of the xmlrpc?
So yes, how?
Otherwise is what you have of lanes?

Thank you in advance

Lili_42 2009-01-15 16:37:03 UTC #11

Hi,

Is what following code is correct ?

$function1 = ‘addressbook.boaddressbook.search’;
$param1 = array(‘start’ => ‘0’,‘limit’=>‘0’
,‘query’=>$_GET[‘searchs’]
,‘sort’=>‘asc’
,‘order’=>‘n_fileas’
,‘cquery’ =>’’
,‘include_users’ => ‘all’);
$res1= test($function1,$param1,$auth1);

test is a function

function test($function,$param, $auth)
{
$request = xmlrpc_encode_request($function,$param);

if($auth!='') $auth = "\nAuthorization: Basic $auth";

$context = stream_context_create(array('http' => array(
'method' => "POST",
'header' => "Content-Type:text/xml" . $auth,
'content' => $request
)));

$file = file_get_contents("http://gwdev.zoomacom.org/xmlrpc.php", false, $context);

$response = xmlrpc_decode($file);
if (xmlrpc_is_fault($response)) {
	trigger_error("xmlrpc: $response[faultString] ($response[faultCode])");
} 
return($response);

}

because I do not succeed read have the primary key of the table ?

Thanks you