function updateAddress($addr, $keep_photo = true)
{
global $keep_history, $domain_id, $base_from_where, $table, $table_grp_adr, $table_groups;
$addresses = new Addresses($addr['id']);
$resultsnumber = $addresses->count();
$homepage = str_replace('http://', '', $addr['homepage']);
$is_valid = $resultsnumber > 0;
if ($is_valid) {
if ($keep_history) {
// Get current photo, if "$keep_photo"
if ($keep_photo) {
$r = $addresses->nextAddress()->getData();
$addr['photo'] = $r['photo'];
}
$sql = "UPDATE {$table}\r\n\t SET deprecated = now()\r\n\t\t WHERE deprecated is null\r\n\t\t AND id\t = '" . $addr['id'] . "'\r\n\t\t AND domain_id = '" . $domain_id . "';";
$result = mysql_query($sql);
saveAddress($addr);
} else {
$sql = "UPDATE {$table} SET firstname = '" . $addr['firstname'] . "'\r\n\t , lastname = '" . $addr['lastname'] . "'\r\n\t , nickname = '" . $addr['nickname'] . "'\r\n\t , company = '" . $addr['company'] . "'\r\n\t , title = '" . $addr['title'] . "'\r\n\t , address = '" . $addr['address'] . "'\r\n\t , home = '" . $addr['home'] . "'\r\n\t , mobile = '" . $addr['mobile'] . "'\r\n\t , work = '" . $addr['work'] . "'\r\n\t , fax = '" . $addr['fax'] . "'\r\n\t , email = '" . $addr['email'] . "'\r\n\t , email2 = '" . $addr['email2'] . "'\r\n\t , email3 = '" . $addr['email3'] . "'\r\n\t , homepage = '" . $addr['homepage'] . "'\r\n\t , aday = '" . $addr['aday'] . "'\r\n\t , amonth = '" . $addr['amonth'] . "'\r\n\t , ayear = '" . $addr['ayear'] . "'\r\n\t , bday = '" . $addr['bday'] . "'\r\n\t , bmonth = '" . $addr['bmonth'] . "'\r\n\t , byear = '" . $addr['byear'] . "'\r\n\t , address2 = '" . $addr['address2'] . "'\r\n\t , phone2 = '" . $addr['phone2'] . "'\r\n\t , notes = '" . $addr['notes'] . "'\r\n\t " . ($keep_photo ? "" : ", photo = '" . $addr['photo'] . "'") . "\r\n\t , modified = now()\r\n\t\t WHERE id = '" . $addr['id'] . "'\r\n\t\t AND domain_id = '{$domain_id}';";
$result = mysql_query($sql);
}
// header("Location: view?id=$id");
}
return $is_valid;
}
function saveNewSupplier($handler, $vendor, $name, $tel, $fax, $info, $dumptime, $line1, $line2, $city, $state, $zip, $box)
{
$tel = cleanPhoneNumber(mysql_real_escape_string($tel));
$fax = cleanPhoneNumber(mysql_real_escape_string($fax));
$addressId = saveAddress($handler, $line1, $line2, $city, $state, $zip, $box);
$supplierQuery = "INSERT INTO supplier (vendorId,supplierName,supplierTel,supplierFax,addressId,supplierInfo,supplierDumptime)\n\tvalues ('{$vendor}','{$name}','{$tel}','{$fax}','{$addressId}','{$info}','{$dumptime}')";
mysql_query($supplierQuery, $handler);
return mysql_insert_id();
}
$addr['phone2'] = $phone2;
$addr['notes'] = $notes;
if (isset($_FILES["photo"]) && $_FILES["photo"]["error"] <= 0) {
$file_tmp_name = $_FILES["photo"]["tmp_name"];
$file_name = $_FILES["photo"]["name"];
$photo = new Photo($file_tmp_name);
$photo->scaleToMaxSide(150);
$addr['photo'] = $photo->getBase64();
}
if (isset($table_groups) and $table_groups != "") {
if (!$is_fix_group) {
$g_name = $new_group;
} else {
$g_name = $group_name;
}
saveAddress($addr, $g_name);
echo "<br /><div class='msgbox'>Information entered into address book.";
echo "<br /><i><a href='edit{$page_ext}'>add next</a> or return to <a href='index{$page_ext}'>home page</a>.</i></div>";
}
} else {
echo "<br /><div class='msgbox'>Editing is disabled.</div>\n";
}
} else {
if ($update) {
if (!$read_only) {
$addr['id'] = $id;
$addr['firstname'] = $firstname;
$addr['middlename'] = $middlename;
$addr['lastname'] = $lastname;
$addr['nickname'] = $nickname;
$addr['title'] = $title;
</form>
<br><br>
<i>Sample (.csv, .xls): <a href="import_sample.csv">import_sample.csv</a></i>
<?php
} else {
if ($_FILES["file"]["error"] > 0 || $read_only) {
echo "Error: " . $_FILES["file"]["error"] . "<br />";
} else {
$file_tmp_name = $_FILES["file"]["tmp_name"];
$file_lines = file($file_tmp_name, FILE_IGNORE_NEW_LINES);
$file_name = $_FILES["file"]["name"];
include "include/import.common.php";
//
// Save the group & addresses
//
$file_group_name = "";
if (count($ab) > 0) {
$file_group_name = "@IMPORT-" . $file_name . "-" . Date("Y-m-j_H:i:s");
saveGroup($file_group_name);
}
foreach ($ab as $addressbook) {
saveAddress($addressbook, $file_group_name);
echo "- <b><i>" . getIfSet($addressbook, 'firstname') . trim(" " . getIfSet($addressbook, 'middlename')) . ", " . getIfSet($addressbook, 'lastname') . "</i></b>, " . getIfSet($addressbook, 'email') . ", " . getIfSet($addressbook, 'email2') . ", " . getIfSet($addressbook, 'company') . "<br>";
}
echo "<br/><br/><div class='msgbox'>The " . $import_type . "-file '" . $_FILES["file"]["name"] . "' is imported into " . count($ab) . " records<br/>";
echo "<i>of the new group <a href='index{$page_ext}?group_name=" . $file_group_name . "'>" . $file_group_name . "</a></i></div>";
//*/
}
}
// end if(!$submit)
include "include/footer.inc.php";
/**
* Called when a message has been changed on the mobile.
* This functionality is not available for emails.
*
* @param string $folderid id of the folder
* @param string $id id of the message
* @param SyncXXX $message the SyncObject containing a message
*
* @access public
* @return array same return value as StatMessage()
* @throws StatusException could throw specific SYNC_STATUS_* exceptions
*/
public function ChangeMessage($folderid, $id, $message)
{
ZLog::Write(LOGLEVEL_DEBUG, 'PhpAddr::ChangeMessage(' . $folderid . ', ' . $id . ', ..)');
debugLog('PhpAddr::ChangeMessage(FolderID: ' . $folderid . ', ID: ' . $id . ', ..)' . json_encode($message));
global $keep_history, $domain_id;
$addr['firstname'] = $message->title != "" ? $message->title . " " : "";
$addr['firstname'] .= $message->firstname . ($message->middlename != "" ? " " . $message->middlename : "");
$addr['firstname'] .= $message->suffix != "" ? " " . $message->suffix : "";
$addr['lastname'] = $message->lastname;
$addr['nickname'] = $message->nickname;
$addr['company'] = $message->companyname;
$addr['title'] = $message->jobtitle;
// 'jobtitle' => 'ROLE',
// ';;homestreet;homecity;homestate;homepostalcode;homecountry' => 'ADR;HOME',
$addr['home'] = $message->homephonenumber;
$addr['mobile'] = $message->mobilephonenumber;
$addr['work'] = $message->businessphonenumber;
$addr['fax'] = $message->businessfaxnumber != "" ? $message->businessfaxnumber : $message->homefaxnumber;
$addr['phone2'] = $message->home2phonenumber;
// 'business2phonenumber' => 'TEL;WORK',
// 'businessfaxnumber' => 'TEL;WORK;FAX',
// 'home2phonenumber' => 'TEL;HOME',
// 'homefaxnumber' => 'TEL;HOME;FAX',
// 'carphonenumber' => 'TEL;CAR',
// 'pagernumber' => 'TEL;PAGER',
if (!empty($message->picture)) {
$addr['photo'] .= 'PHOTO;ENCODING=BASE64;TYPE=JPEG:' . "\n\t" . substr(chunk_split($message->picture, 50, "\n\t"), 0, -1);
}
$addr['email'] = $message->email1address;
$addr['email2'] = $message->email2address;
$addr['email3'] = $message->email3address;
$addr['homepage'] = $message->webpage;
// if($message->birthday !== FALSE) {
if ($message->birthday != 0) {
$addr['bday'] = date('j', $message->birthday);
$addr['bmonth'] = date('F', $message->birthday);
$addr['byear'] = date('Y', $message->birthday);
}
// if($message->anniversary !== FALSE) {
if ($message->anniversary != 0) {
$addr['aday'] = date('j', $message->anniversary);
$addr['amonth'] = date('F', $message->anniversary);
$addr['ayear'] = date('Y', $message->anniversary);
}
// ->anniversary
/*
// if($message->birthday > 0) {
debugLog('PhpAddr::Birthday(Birthday: '.$message->birthday.', Day: '.$addr['bday']);
}
debugLog('PhpAddr::Birthday(Birthday: '.$message->birthday);
*/
// ';;businessstreet;businesscity;businessstate;businesspostalcode;businesscountry' => 'ADR;WORK',
// ';;otherstreet;othercity;otherstate;otherpostalcode;othercountry' => 'ADR',
$addr['notes'] = $message->body;
// assistantname, assistnamephonenumber, children, department, officelocation, radiophonenumber, spouse, rtf
$addr['address'] = $message->homestreet . "\n" . $message->homepostalcode . " " . $message->homecity . "\n" . $message->homecountry;
// $message->homestate = $addr_parts['city'];
$addr['address2'] = $message->businessstreet . "\n" . $message->businesspostalcode . " " . $message->businesscity . "\n" . $message->businesscountry;
// $message->businessstate = $addr_parts['city'];
//2 $this->_phpaddr->connect();
if ($id == "") {
$id = saveAddress($addr);
debugLog('PhpAddr::ChangedMessage(FolderID: ' . $folderid . ', ID: ' . $id . ', ..)');
} else {
$addr['id'] = intval($id);
updateAddress($addr);
}
//2 $this->_phpaddr->disconnect();
/*
$mapping = array(
);
$data = "BEGIN:VCARD\nVERSION:2.1\nPRODID:Z-Push\n";
foreach($mapping as $k => $v){
$val = '';
$ks = explode(';', $k);
foreach($ks as $i){
if(!empty($message->$i))
$val .= $this->escape($message->$i);
$val.=';';
}
if(empty($val))
continue;
$val = substr($val,0,-1);
if(strlen($val)>50){
$data .= $v.":\n\t".substr(chunk_split($val, 50, "\n\t"), 0, -1);
}else{
$data .= $v.':'.$val."\n";
}
}
if(!empty($message->categories))
$data .= 'CATEGORIES:'.implode(',', $this->escape($message->categories))."\n";
if(!empty($message->picture))
$data .= 'PHOTO;ENCODING=BASE64;TYPE=JPEG:'."\n\t".substr(chunk_split($message->picture, 50, "\n\t"), 0, -1);
if(isset($message->birthday))
$data .= 'BDAY:'.date('Y-m-d', $message->birthday)."\n";
$data .= "END:VCARD";
// not supported: anniversary, assistantname, assistnamephonenumber, children, department, officelocation, radiophonenumber, spouse, rtf
if(!$id){
if(!empty($message->fileas)){
$name = u2wi($message->fileas);
}elseif(!empty($message->lastname)){
$name = $name = u2wi($message->lastname);
}elseif(!empty($message->firstname)){
$name = $name = u2wi($message->firstname);
}elseif(!empty($message->companyname)){
$name = $name = u2wi($message->companyname);
}else{
$name = 'unknown';
}
$name = preg_replace('/[^a-z0-9 _-]/i', '', $name);
$id = $name.'.vcf';
$i = 0;
while(file_exists($this->getPath().'/'.$id)){
$i++;
$id = $name.$i.'.vcf';
}
}
// file_put_contents($this->getPath().'/'.$id, $data);
*/
return $this->StatMessage($folderid, $id);
}
