. */ /** * @brief Delete a structure * * * @file * @author Claire Figueras * @date $date$ * @version $Revision$ * @ingroup admin */ require_once("apps".DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_contacts_v2.php"); $contact = new contacts_v2(); $core_tools = new core_tools(''); $return = $core_tools->test_admin('admin_contacts', 'apps', false); if (!$return) { $return = $core_tools->test_admin('create_contacts', 'apps', false); } if (!$return) { $return = $core_tools->test_admin('my_contacts', 'apps', false); } if (!$return) { $return = $core_tools->test_admin('my_contacts_menu', 'apps', false); } if (!$return) { $_SESSION['error'] = _SERVICE . ' ' . _UNKNOWN; ?> load_lang(); $db = new dbquery(); $db2 = new dbquery(); /****************Management of the location bar ************/ $init = false; if (isset($_REQUEST['reinit']) && $_REQUEST['reinit'] == "true") { $init = true; } $level = ""; if (isset($_REQUEST['level']) && ($_REQUEST['level'] == 2 || $_REQUEST['level'] == 3 || $_REQUEST['level'] == 4 || $_REQUEST['level'] == 1) ) { $level = $_REQUEST['level']; } $pagePath = $_SESSION['config']['businessappurl'] . 'index.php?page=contact_addresses_del'; $pageLabel = _ADDRESS_DEL; $pageId = "contact_addresses_del"; $core_tools->manage_location_bar($pagePath, $pageLabel, $pageId, $init, $level); /***********************************************************/ if(isset($_GET['id'])){ $id = addslashes($db->wash($_GET['id'], "no", _THE_CONTACT_ADDRESS)); } else{ $id = ""; } if(isset($_GET['mycontact']) && $_GET['mycontact'] <> ''){ $admin = false; } else { $admin = true; } if ($_REQUEST['valid']) { $id = $_POST['id']; if ($_POST['new'] && $_POST['new_contact_id']){ $newid = $_POST['new']; $new_contact_id = $_POST['new_contact_id']; $db->connect(); $db2->connect(); // delete contact types $db->query("DELETE FROM ".$_SESSION['tablename']['contact_addresses']." WHERE id = ".$id); $db->query("SELECT res_id, exp_contact_id, dest_contact_id FROM mlb_coll_ext WHERE address_id = ".$id); while($res = $db->fetch_object()){ if ($res->exp_contact_id <> "") { $db2->query("UPDATE mlb_coll_ext SET exp_contact_id = ".$new_contact_id." WHERE res_id = ".$res->res_id); } else { $db2->query("UPDATE mlb_coll_ext SET dest_contact_id = ".$new_contact_id." WHERE res_id = ".$res->res_id); } } $db->query("UPDATE mlb_coll_ext SET address_id = ".$newid." WHERE address_id = ".$id); $db->query("UPDATE contacts_res SET contact_id = ".$new_contact_id.", address_id = ".$newid." WHERE address_id = ".$id); if($_SESSION['history']['contact_addresses_del'] == "true") { require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_history.php"); $users = new history(); $users->add($_SESSION['tablename']['contact_addresses'], $id,"DEL",'contact_addresses_del', _ADDRESS_DEL." ".strtolower(_NUM).$id."", $_SESSION['config']['databasetype']); } $_SESSION['error'] = _DELETED_ADDRESS."."; unset($_SESSION['m_admin']); ?> type_purpose_address_del($id, $admin, $_SESSION['tablename']['contact_addresses'], 'contact_address', _DELETED_ADDRESS, _WARNING_MESSAGE_DEL_CONTACT_ADDRESS, _ADDRESS_DEL, _CONTACT_ADDRESS_REAFFECT, _NEW_ADDRESS, _CHOOSE_CONTACT_ADDRESS, 'contacts_v2_up', 'contact_addresses_del', _CONTACT_ADDRESS); } else if (!$_POST['new']) { $_SESSION['error'] = _NEW_ADDRESS.' '._IS_EMPTY.". ". _USE_AUTOCOMPLETION; $contact->type_purpose_address_del($id, $admin, $_SESSION['tablename']['contact_addresses'], 'contact_address', _DELETED_ADDRESS, _WARNING_MESSAGE_DEL_CONTACT_ADDRESS, _ADDRESS_DEL, _CONTACT_ADDRESS_REAFFECT, _NEW_ADDRESS, _CHOOSE_CONTACT_ADDRESS, 'contacts_v2_up', 'contact_addresses_del', _CONTACT_ADDRESS); } } else if($_REQUEST['move']) { $id = $_POST['id']; if ($_POST['new_contact_id_reaffect']) { $db->query("UPDATE contact_addresses set contact_id = ".$_POST['new_contact_id_reaffect']." WHERE id = ".$id); $db->query("UPDATE contacts_res set contact_id = '".$_POST['new_contact_id_reaffect']."' WHERE address_id = ".$id); $db->query("SELECT res_id, exp_contact_id, dest_contact_id FROM mlb_coll_ext WHERE address_id = ".$id); while($res = $db->fetch_object()){ if ($res->exp_contact_id <> "") { $db2->query("UPDATE mlb_coll_ext SET exp_contact_id = ".$_POST['new_contact_id_reaffect']." WHERE res_id = ".$res->res_id); } else { $db2->query("UPDATE mlb_coll_ext SET dest_contact_id = ".$_POST['new_contact_id_reaffect']." WHERE res_id = ".$res->res_id); } } if($_SESSION['history']['contact_addresses_del'] == "true") { require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_history.php"); $users = new history(); $users->add($_SESSION['tablename']['contact_addresses'], $id,"DEL",'contact_addresses_del', _ADDRESS_MOVED." ".strtolower(_NUM).$id."", $_SESSION['config']['databasetype']); } $_SESSION['error'] = _ADDRESS_MOVED."."; unset($_SESSION['m_admin']); ?> type_purpose_address_del($id, $admin, $_SESSION['tablename']['contact_addresses'], 'contact_address', _DELETED_ADDRESS, _WARNING_MESSAGE_DEL_CONTACT_ADDRESS, _ADDRESS_DEL, _CONTACT_ADDRESS_REAFFECT, _NEW_ADDRESS, _CHOOSE_CONTACT_ADDRESS, 'contacts_v2_up', 'contact_addresses_del', _CONTACT_ADDRESS); } } else if($_REQUEST['delete']) { $id = $_POST['id']; $db->query("DELETE FROM contact_addresses WHERE id = ".$id); if($_SESSION['history']['contact_addresses_del'] == "true") { require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_history.php"); $users = new history(); $users->add($_SESSION['tablename']['contact_addresses'], $id,"DEL",'contact_addresses_del', _ADDRESS_DEL." ".strtolower(_NUM).$id."", $_SESSION['config']['databasetype']); } $_SESSION['error'] = _DELETED_ADDRESS."."; unset($_SESSION['m_admin']); ?> type_purpose_address_del($id, $admin, $_SESSION['tablename']['contact_addresses'], 'contact_address', _DELETED_ADDRESS, _WARNING_MESSAGE_DEL_CONTACT_ADDRESS, _ADDRESS_DEL, _CONTACT_ADDRESS_REAFFECT, _NEW_ADDRESS, _CHOOSE_CONTACT_ADDRESS, 'contacts_v2_up', 'contact_addresses_del', _CONTACT_ADDRESS); } ?>