projects
/
platal.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Adds delete method for phone and address classes.
[platal.git]
/
classes
/
phone.php
diff --git
a/classes/phone.php
b/classes/phone.php
index
32eb168
..
948894f
100644
(file)
--- a/
classes/phone.php
+++ b/
classes/phone.php
@@
-105,6
+105,11
@@
class Phone
return $this->search;
}
return $this->search;
}
+ public function setId($id)
+ {
+ $this->id = $id;
+ }
+
/** Returns the unique ID of a phone.
* This ID will allow to link it to an address, a user or a job.
* The format is address_addressId_phoneId (where phoneId is the id
/** Returns the unique ID of a phone.
* This ID will allow to link it to an address, a user or a job.
* The format is address_addressId_phoneId (where phoneId is the id
@@
-302,6
+307,13
@@
class Phone
}
}
}
}
+ public function delete()
+ {
+ XDB::execute('DELETE FROM profile_phones
+ WHERE pid = {?} AND link_type = {?} AND link_id = {?} AND tel_id = {?}',
+ $this->pid, $this->link_type, $this->link_id, $this->id);
+ }
+
static public function deletePhones($pid, $link_type, $link_id = null)
{
$where = '';
static public function deletePhones($pid, $link_type, $link_id = null)
{
$where = '';
@@
-399,8
+411,8
@@
class PhoneIterator implements PlIterator
$sql = 'SELECT search_tel AS search, display_tel AS display, comment, link_id,
tel_type AS type, link_type, tel_id AS id, pid, pub
FROM profile_phones
$sql = 'SELECT search_tel AS search, display_tel AS display, comment, link_id,
tel_type AS type, link_type, tel_id AS id, pid, pub
FROM profile_phones
-
WHERE ' . implode(' AND ', $where
) . '
- ORDER BY link_id, tel_id';
+
' . ((count($where) > 0) ? 'WHERE ' . implode(' AND ', $where) : ''
) . '
+ ORDER BY
pid,
link_id, tel_id';
$this->dbiter = XDB::iterator($sql);
}
$this->dbiter = XDB::iterator($sql);
}