<?php
|
|
/*
|
+-----------------------------------------------------------------------+
|
| program/steps/addressbook/save.inc |
|
| |
|
| This file is part of the RoundCube Webmail client |
|
| Copyright (C) 2005, RoundCube Dev. - Switzerland |
|
| Licensed under the GNU GPL |
|
| |
|
| PURPOSE: |
|
| Save a contact entry or to add a new one |
|
| |
|
+-----------------------------------------------------------------------+
|
| Author: Thomas Bruederli <roundcube@gmail.com> |
|
+-----------------------------------------------------------------------+
|
|
$Id$
|
|
*/
|
|
|
$a_save_cols = array('name', 'firstname', 'surname', 'email');
|
|
|
// check input
|
if (empty($_POST['_name']) || empty($_POST['_email']))
|
{
|
show_message('formincomplete', 'warning');
|
rcmail_overwrite_action($_POST['_cid'] ? 'show' : 'add');
|
return;
|
}
|
|
|
// update an existing contact
|
if ($_POST['_cid'])
|
{
|
$a_write_sql = array();
|
|
foreach ($a_save_cols as $col)
|
{
|
$fname = '_'.$col;
|
if (!isset($_POST[$fname]))
|
continue;
|
|
$a_write_sql[] = sprintf("%s=%s", $DB->quoteIdentifier($col), $DB->quote(strip_tags($_POST[$fname])));
|
}
|
|
if (sizeof($a_write_sql))
|
{
|
$DB->query("UPDATE ".get_table_name('contacts')."
|
SET changed=now(), ".join(', ', $a_write_sql)."
|
WHERE contact_id=?
|
AND user_id=?
|
AND del<>'1'",
|
$_POST['_cid'],
|
$_SESSION['user_id']);
|
|
$updated = $DB->affected_rows();
|
}
|
|
if ($updated)
|
{
|
$_action = 'show';
|
show_message('successfullysaved', 'confirmation');
|
|
if ($_POST['_framed'])
|
{
|
// define list of cols to be displayed
|
$a_show_cols = array('name', 'email');
|
$a_js_cols = array();
|
|
$sql_result = $DB->query("SELECT * FROM ".get_table_name('contacts')."
|
WHERE contact_id=?
|
AND user_id=?
|
AND del<>'1'",
|
$_POST['_cid'],
|
$_SESSION['user_id']);
|
|
$sql_arr = $DB->fetch_assoc($sql_result);
|
foreach ($a_show_cols as $col)
|
$a_js_cols[] = (string)$sql_arr[$col];
|
|
// update the changed col in list
|
$OUTPUT->add_script(sprintf("if(parent.%s)parent.%s.update_contact_row('%d', %s);",
|
$JS_OBJECT_NAME,
|
$JS_OBJECT_NAME,
|
$_POST['_cid'],
|
array2js($a_js_cols)));
|
|
// show confirmation
|
show_message('successfullysaved', 'confirmation');
|
}
|
}
|
else
|
{
|
// show error message
|
show_message('errorsaving', 'error');
|
rcmail_overwrite_action('show');
|
}
|
}
|
|
// insert a new contact
|
else
|
{
|
$a_insert_cols = $a_insert_values = array();
|
|
// check for existing contacts
|
$sql_result = $DB->query("SELECT 1 FROM ".get_table_name('contacts')."
|
WHERE user_id=?
|
AND email=?
|
AND del<>'1'",
|
$_SESSION['user_id'],
|
$_POST['_email']);
|
|
// show warning message
|
if ($DB->num_rows($sql_result))
|
{
|
show_message('contactexists', 'warning');
|
$_action = 'add';
|
return;
|
}
|
|
foreach ($a_save_cols as $col)
|
{
|
$fname = '_'.$col;
|
if (!isset($_POST[$fname]))
|
continue;
|
|
$a_insert_cols[] = $col;
|
$a_insert_values[] = $DB->quote(strip_tags($_POST[$fname]));
|
}
|
|
if (sizeof($a_insert_cols))
|
{
|
$DB->query("INSERT INTO ".get_table_name('contacts')."
|
(user_id, changed, ".join(', ', $a_insert_cols).")
|
VALUES (?, now(), ".join(', ', $a_insert_values).")",
|
$_SESSION['user_id']);
|
|
$insert_id = $DB->insert_id();
|
}
|
|
if ($insert_id)
|
{
|
$_action = 'show';
|
$_GET['_cid'] = $insert_id;
|
|
if ($_POST['_framed'])
|
{
|
// add contact row or jump to the page where it should appear
|
$commands = sprintf("if(parent.%s)parent.", $JS_OBJECT_NAME);
|
$sql_result = $DB->query("SELECT * FROM ".get_table_name('contacts')."
|
WHERE contact_id=?
|
AND user_id=?",
|
$insert_id,
|
$_SESSION['user_id']);
|
$commands .= rcmail_js_contacts_list($sql_result, $JS_OBJECT_NAME);
|
|
$commands .= sprintf("if(parent.%s)parent.%s.select('%d');\n",
|
$JS_OBJECT_NAME,
|
$JS_OBJECT_NAME,
|
$insert_id);
|
|
// update record count display
|
$commands .= sprintf("if(parent.%s)parent.%s.set_rowcount('%s');\n",
|
$JS_OBJECT_NAME,
|
$JS_OBJECT_NAME,
|
rcmail_get_rowcount_text());
|
|
$OUTPUT->add_script($commands);
|
|
// show confirmation
|
show_message('successfullysaved', 'confirmation');
|
}
|
}
|
else
|
{
|
// show error message
|
show_message('errorsaving', 'error');
|
rcmail_overwrite_action('add');
|
}
|
}
|
|
|
?>
|
