PHP exchange::drop方法代码示例

    $region_type = $region['region_type'];
    $delete_region[] = $id;
    $new_region_id = $id;
    if ($region_type < 6) {
        for ($i = 1; $i < 6 - $region_type; $i++) {
            $new_region_id = new_region_id($new_region_id);
            if (count($new_region_id)) {
                $delete_region = array_merge($delete_region, $new_region_id);
            } else {
                continue;
            }
        }
    }
    $sql = "DELETE FROM " . $ecs->table("region") . "WHERE region_id" . db_create_in($delete_region);
    $db->query($sql);
    if ($exc->drop($id)) {
        admin_log(addslashes($region['region_name']), 'remove', 'area');
        /* 获取地区列表 */
        $region_arr = area_list($region['parent_id']);
        $smarty->assign('region_arr', $region_arr);
        $smarty->assign('region_type', $region['region_type']);
        make_json_result($smarty->fetch('area_list.htm'));
    } else {
        make_json_error($db->error());
    }
}
function new_region_id($region_id)
{
    $regions_id = array();
    if (empty($region_id)) {
        return $regions_id;

} elseif ($_REQUEST['act'] == 'query') {
    $msg_list = msg_list();
    $smarty->assign('msg_list', $msg_list['msg_list']);
    $smarty->assign('filter', $msg_list['filter']);
    $smarty->assign('record_count', $msg_list['record_count']);
    $smarty->assign('page_count', $msg_list['page_count']);
    $sort_flag = sort_flag($msg_list['filter']);
    $smarty->assign($sort_flag['tag'], $sort_flag['img']);
    make_json_result($smarty->fetch('msg_list.htm'), '', array('filter' => $msg_list['filter'], 'page_count' => $msg_list['page_count']));
} elseif ($_REQUEST['act'] == 'remove') {
    $msg_id = intval($_REQUEST['id']);
    /* 检查权限 */
    check_authz_json('feedback_priv');
    $msg_title = $exc->get_name($msg_id);
    $img = $exc->get_name($msg_id, 'message_img');
    if ($exc->drop($msg_id)) {
        /* 删除图片 */
        if (!empty($img)) {
            @unlink(ROOT_PATH . DATA_DIR . '/feedbackimg/' . $img);
        }
        $sql = "DELETE FROM " . $ecs->table('feedback') . " WHERE parent_id = '{$msg_id}' LIMIT 1";
        $db->query($sql, 'SILENT');
        admin_log(addslashes($msg_title), 'remove', 'message');
        $url = 'user_msg.php?act=query&' . str_replace('act=remove', '', $_SERVER['QUERY_STRING']);
        ecs_header("Location: {$url}\n");
        exit;
    } else {
        make_json_error($GLOBALS['db']->error());
    }
}
/*------------------------------------------------------ */

            clear_cache_files();
            make_json_result(stripslashes($link_name));
        } else {
            make_json_error($db->error());
        }
    }
} elseif ($_REQUEST['act'] == 'remove') {
    check_authz_json('friendlink');
    $id = intval($_GET['id']);
    /* 获取链子LOGO,并删除 */
    $link_logo = $exc->get_name($id, "link_logo");
    if (strpos($link_logo, 'http://') === false && strpos($link_logo, 'https://') === false) {
        $img_name = basename($link_logo);
        @unlink(ROOT_PATH . DATA_DIR . '/afficheimg/' . $img_name);
    }
    $exc->drop($id);
    clear_cache_files();
    admin_log('', 'remove', 'friendlink');
    $url = 'friend_link.php?act=query&' . str_replace('act=remove', '', $_SERVER['QUERY_STRING']);
    ecs_header("Location: {$url}\n");
    exit;
} elseif ($_REQUEST['act'] == 'edit_show_order') {
    check_authz_json('friendlink');
    $id = intval($_POST['id']);
    $order = json_str_iconv(trim($_POST['val']));
    /* 检查输入的值是否合法 */
    if (!preg_match("/^[0-9]+\$/", $order)) {
        make_json_error(sprintf($_LANG['enter_int'], $order));
    } else {
        if ($exc->edit("show_order = '{$order}'", $id)) {
            clear_cache_files();

        if (!$exc->is_only('max_points', intval($_POST['max_points']))) {
            sys_msg(sprintf($_LANG['integral_max_exists'], intval($_POST['max_points'])));
        }
    }
    $sql = "INSERT INTO " . $ecs->table('user_rank') . "( " . "rank_name, min_points, max_points, discount, special_rank, show_price" . ") VALUES (" . "'{$_POST['rank_name']}', '" . intval($_POST['min_points']) . "', '" . intval($_POST['max_points']) . "', " . "'{$_POST['discount']}', '{$special_rank}', '" . intval($_POST['show_price']) . "')";
    $db->query($sql);
    /* 管理员日志 */
    admin_log(trim($_POST['rank_name']), 'add', 'user_rank');
    clear_cache_files();
    $lnk[] = array('text' => $_LANG['back_list'], 'href' => 'user_rank.php?act=list');
    $lnk[] = array('text' => $_LANG['add_continue'], 'href' => 'user_rank.php?act=add');
    sys_msg($_LANG['add_rank_success'], 0, $lnk);
} elseif ($_REQUEST['act'] == 'remove') {
    check_authz_json('user_rank');
    $rank_id = intval($_GET['id']);
    if ($exc->drop($rank_id)) {
        /* 更新会员表的等级字段 */
        $exc_user->edit("user_rank = 0", $rank_id);
        $rank_name = $exc->get_name($rank_id);
        admin_log(addslashes($rank_name), 'remove', 'user_rank');
        clear_cache_files();
    }
    $url = 'user_rank.php?act=query&' . str_replace('act=remove', '', $_SERVER['QUERY_STRING']);
    ecs_header("Location: {$url}\n");
    exit;
} elseif ($_REQUEST['act'] == 'edit_name') {
    $id = intval($_REQUEST['id']);
    $val = empty($_REQUEST['val']) ? '' : json_str_iconv(trim($_REQUEST['val']));
    check_authz_json('user_rank');
    if ($exc->is_only('rank_name', $val, $id)) {
        if ($exc->edit("rank_name = '{$val}'", $id)) {

    /* 检查是否存在重名的会员注册项 */
    if ($_POST['reg_field_name'] != $_POST['old_field_name'] && !$exc->is_only('reg_field_name', trim($_POST['reg_field_name']))) {
        sys_msg(sprintf($_LANG['field_name_exist'], trim($_POST['reg_field_name'])), 1);
    }
    $sql = "UPDATE " . $ecs->table('reg_fields') . " SET `reg_field_name` = '{$_POST['reg_field_name']}', `dis_order` = '{$_POST['reg_field_order']}', `display` = '{$_POST['reg_field_display']}', `is_need` = '{$_POST['reg_field_need']}' WHERE `id` = '{$_POST['id']}'";
    $db->query($sql);
    /* 管理员日志 */
    admin_log(trim($_POST['reg_field_name']), 'edit', 'reg_fields');
    clear_cache_files();
    $lnk[] = array('text' => $_LANG['back_list'], 'href' => 'reg_fields.php?act=list');
    sys_msg($_LANG['update_field_success'], 0, $lnk);
} elseif ($_REQUEST['act'] == 'remove') {
    check_authz_json('reg_fields');
    $field_id = intval($_GET['id']);
    $field_name = $exc->get_name($field_id);
    if ($exc->drop($field_id)) {
        /* 删除会员扩展信息表的相应信息 */
        $sql = "DELETE FROM " . $GLOBALS['ecs']->table('reg_extend_info') . " WHERE reg_field_id = '" . $field_id . "'";
        @$GLOBALS['db']->query($sql);
        admin_log(addslashes($field_name), 'remove', 'reg_fields');
        clear_cache_files();
    }
    $url = 'reg_fields.php?act=query&' . str_replace('act=remove', '', $_SERVER['QUERY_STRING']);
    ecs_header("Location: {$url}\n");
    exit;
} elseif ($_REQUEST['act'] == 'edit_name') {
    $id = intval($_REQUEST['id']);
    $val = empty($_REQUEST['val']) ? '' : json_str_iconv(trim($_REQUEST['val']));
    check_authz_json('reg_fields');
    if ($exc->is_only('reg_field_name', $val, $id)) {
        if ($exc->edit("reg_field_name = '{$val}'", $id)) {

    if (!preg_match("/^[0-9]+\$/", $order)) {
        make_json_result('', sprintf($_LANG['enter_int'], $order));
    } else {
        if ($exc_cat->edit("sort_order = '{$order}'", $id)) {
            clear_cache_files();
            make_json_result(stripslashes($order));
        }
    }
} elseif ($_REQUEST['act'] == 'remove') {
    check_authz_json('shophelp_manage');
    $id = intval($_GET['id']);
    /* 非空的分类不允许删除 */
    if ($exc_article->num('cat_id', $id) != 0) {
        make_json_error(sprintf($_LANG['not_emptycat']));
    } else {
        $exc_cat->drop($id);
        clear_cache_files();
        admin_log('', 'remove', 'shophelpcat');
    }
    $url = 'shophelp.php?act=query&' . str_replace('act=remove', '', $_SERVER['QUERY_STRING']);
    ecs_header("Location: {$url}\n");
    exit;
} elseif ($_REQUEST['act'] == 'remove_art') {
    check_authz_json('shophelp_manage');
    $id = intval($_GET['id']);
    $cat_id = $db->getOne('SELECT cat_id FROM ' . $ecs->table('article') . " WHERE article_id='{$id}'");
    if ($exc_article->drop($id)) {
        /* 清除缓存 */
        clear_cache_files();
        admin_log('', 'remove', 'shophelp');
    } else {

 }
 /* 删除商品图片和轮播图片 */
 /*add by hg for date 2014-04-21 只有管理员添加的商品才能删除图片*/
 if ($goods['admin_agency_id'] == '0') {
     if (!empty($goods['goods_thumb'])) {
         @unlink('../' . $goods['goods_thumb']);
     }
     if (!empty($goods['goods_img'])) {
         @unlink('../' . $goods['goods_img']);
     }
     if (!empty($goods['original_img'])) {
         @unlink('../' . $goods['original_img']);
     }
 }
 /* 删除商品 */
 $exc->drop($goods_id);
 /* 删除商品的货品记录 */
 $sql = "DELETE FROM " . $ecs->table('products') . " WHERE goods_id = '{$goods_id}'";
 $db->query($sql);
 /* 记录日志 */
 admin_log(addslashes($goods['goods_name']), 'remove', 'goods');
 /* 删除商品相册 */
 $sql = "SELECT img_url, thumb_url, img_original " . "FROM " . $ecs->table('goods_gallery') . " WHERE goods_id = '{$goods_id}'";
 $res = $db->query($sql);
 /*add by hg for date 2014-04-21 只有管理员添加的商品才能删除图片*/
 if ($goods['admin_agency_id'] == '0') {
     while ($row = $db->fetchRow($res)) {
         if (!empty($row['img_url'])) {
             @unlink('../' . $row['img_url']);
         }
         if (!empty($row['thumb_url'])) {

} elseif ($_REQUEST['act'] == 'query') {
    $cards_list = cards_list();
    $smarty->assign('card_list', $cards_list['card_list']);
    $smarty->assign('filter', $cards_list['filter']);
    $smarty->assign('record_count', $cards_list['record_count']);
    $smarty->assign('page_count', $cards_list['page_count']);
    $sort_flag = sort_flag($cards_list['filter']);
    $smarty->assign($sort_flag['tag'], $sort_flag['img']);
    make_json_result($smarty->fetch('card_list.htm'), '', array('filter' => $cards_list['filter'], 'page_count' => $cards_list['page_count']));
} elseif ($_REQUEST['act'] == 'remove') {
    /* 检查权限 */
    check_authz_json('card_manage');
    $card_id = empty($_REQUEST['id']) ? 0 : intval($_REQUEST['id']);
    $name = $exc->get_name($card_id);
    $img = $exc->get_name($card_id, 'card_img');
    if ($exc->drop($card_id)) {
        /* 删除图片 */
        if (!empty($img)) {
            @unlink('../' . DATA_DIR . '/cardimg/' . $img);
        }
        admin_log(addslashes($name), 'remove', 'card');
        $url = 'card.php?act=query&' . str_replace('act=remove', '', $_SERVER['QUERY_STRING']);
        ecs_header("Location: {$url}\n");
        exit;
    } else {
        make_json_error($db->error());
    }
} elseif ($_REQUEST['act'] == 'add') {
    /* 权限判断 */
    admin_priv('card_manage');
    /*初始化显示*/

     $data['office_phone'] = empty($_REQUEST['office_phone']) ? '' : trim($_REQUEST['office_phone']);
     $data['office_mobile'] = empty($_REQUEST['office_mobile']) ? '' : trim($_REQUEST['office_mobile']);
     $data['dept_id'] = empty($_REQUEST['dept']) ? '' : trim($_REQUEST['dept']);
     $data['level'] = empty($_REQUEST['posts']) ? '' : trim($_REQUEST['posts']);
     $data['remark'] = empty($_REQUEST['remark']) ? '' : trim($_REQUEST['remark']);
     $city_code = intval($_REQUEST['city']);
     $re = $db_write->autoExecute('hr_employees', $data, 'UPDATE', "id='" . $data['id'] . "'");
     $links[0]['text'] = '返回员工管理';
     $links[0]['href'] = 'employee.php?act=list';
     if ($re) {
         sys_msg('员工编辑成功！', 0, $links);
     }
     break;
 case 'remove':
     $id = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : '0';
     $excg->drop($id);
     $url = "employee.php?act=query&" . str_replace('act=remove', '', $_SERVER['QUERY_STRING']);
     los_header("Location: {$url}\n");
     exit;
     break;
 default:
     $sql = "SELECT station_id,station_name FROM ship_station  where station_id = '" . trim($_SESSION['station']) . "'";
     $stations = $db_read->getAll($sql);
     if ($stations) {
         $smarty->assign('Current', 'Current');
         $smarty->assign('stations', $stations);
         $_REQUEST['stations'] = $stations[0]['station_id'];
     } else {
         $stations = $db_read->getAll("SELECT station_id,station_name FROM ship_station where city_code {$city_code} ");
         $smarty->assign('stations', $stations);
     }

/**
 * 删除品牌
 *
 * @param array $post POST数据
 */
function API_DeleteBrand($post)
{
    require_once ROOT_PATH . ADMIN_PATH . '/includes/cls_exchange.php';
    admin_privilege('brand_manage');
    $brand_id = intval($_POST['Id']);
    $exc = new exchange($GLOBALS['ecs']->table("brand"), $GLOBALS['db'], 'brand_id', 'brand_name');
    $brand = $GLOBALS['db']->getRow("SELECT brand_logo FROM " . $GLOBALS['ecs']->table('brand') . " WHERE brand_id='{$brand_id}'");
    if (!empty($brand['brand_logo'])) {
        @unlink(ROOT_PATH . '/brandlogo/' . $brand['brand_logo']);
    }
    $exc->drop($brand_id);
    /* 更新商品的品牌编号 */
    $sql = "UPDATE " . $GLOBALS['ecs']->table('goods') . " SET brand_id=0 WHERE brand_id='{$brand_id}'";
    $GLOBALS['db']->query($sql);
    client_show_message(0, true);
}

    check_authz_json('vote_priv');
    $id = intval($_GET['id']);
    if ($exc->drop($id)) {
        /* 同时删除调查选项 */
        $db->query("DELETE FROM " . $ecs->table('vote_option') . " WHERE vote_id = '{$id}'");
        clear_cache_files();
        admin_log('', 'remove', 'ads_position');
    }
    $url = 'vote.php?act=query&' . str_replace('act=remove', '', $_SERVER['QUERY_STRING']);
    ecs_header("Location: {$url}\n");
    exit;
} elseif ($_REQUEST['act'] == 'remove_option') {
    check_authz_json('vote_priv');
    $id = intval($_GET['id']);
    $vote_id = $db->getOne('SELECT vote_id FROM ' . $ecs->table('vote_option') . " WHERE option_id='{$id}'");
    if ($exc_opn->drop($id)) {
        clear_cache_files();
        admin_log('', 'remove', 'vote');
    }
    $url = 'vote.php?act=query_option&vid=' . $vote_id . '&' . str_replace('act=remove_option', '', $_SERVER['QUERY_STRING']);
    ecs_header("Location: {$url}\n");
    exit;
}
/* 获取在线调查数据列表 */
function get_votelist()
{
    $filter = array();
    /* 记录总数以及页数 */
    $sql = 'SELECT COUNT(*) FROM ' . $GLOBALS['ecs']->table('vote');
    $filter['record_count'] = $GLOBALS['db']->getOne($sql);
    $filter = page_and_size($filter);

        clear_cache_files();
    }
    $url = 'article.php?act=query_sjs&' . str_replace('act=remove_sjs', '', $_SERVER['QUERY_STRING']);
    ecs_header("Location: {$url}\n");
    exit;
} elseif ($_REQUEST['act'] == 'remove_jg') {
    check_authz_json('article_manage');
    $id = intval($_GET['id']);
    /* 删除原来的文件 */
    $sql = "SELECT file_url FROM " . $ecs->table('article') . " WHERE article_id = '{$id}'";
    $old_url = $db->getOne($sql);
    if ($old_url != '' && strpos($old_url, 'http://') === false && strpos($old_url, 'https://') === false) {
        @unlink(ROOT_PATH . $old_url);
    }
    $name = $exc2->get_name($id);
    if ($exc2->drop($id)) {
        $db->query("DELETE FROM " . $ecs->table('comment') . " WHERE " . "comment_type = 1 AND id_value = {$id}");
        admin_log(addslashes($name), 'remove', 'article');
        clear_cache_files();
    }
    $url = 'article.php?act=query_jg&' . str_replace('act=remove_jg', '', $_SERVER['QUERY_STRING']);
    ecs_header("Location: {$url}\n");
    exit;
} elseif ($_REQUEST['act'] == 'add_link_goods') {
    include_once ROOT_PATH . 'includes/cls_json.php';
    $json = new JSON();
    check_authz_json('article_manage');
    $add_ids = $json->decode($_GET['add_ids']);
    $args = $json->decode($_GET['JSON']);
    $article_id = $args[0];
    if ($article_id == 0) {

         $db_write->autoExecute('sh_address', $data, 'UPDATE', 'id=' . intval($_REQUEST['id']));
         $links[0]['text'] = '返回地址点管理列表';
         $links[0]['href'] = 'area.php?act=list';
     } else {
         $data['area_name'] = empty($_POST['area_name']) ? '' : trim($_POST['area_name']);
         $data['region_id'] = empty($_POST['region_id']) ? '' : trim($_POST['region_id']);
         $data['route_id'] = empty($_POST['route_id']) ? '' : trim($_POST['route_id']);
         $db_write->autoExecute('ship_area', $data, 'UPDATE', 'area_id=' . intval($_REQUEST['id']));
         $links[0]['text'] = '返回地址点管理列表';
         $links[0]['href'] = 'area.php?act=list';
     }
     sys_msg('地址点编辑成功！', 0, $links);
     break;
 case 'remove':
     $id = isset($_REQUEST['id']) ? intval($_REQUEST['id']) : '0';
     city_location() ? $excg1->drop($id) : $excg2->drop($id);
     $url = "area.php?act=query&" . str_replace('act=remove', '', $_SERVER['QUERT_STRING']);
     los_header("Location: {$url}\n");
     break;
 case 'batchAdd':
     //print_r($_REQUEST);
     //print_r($_FILES);
     batchInsertAdress('text/plain', '120000', $_SESSION['city_group']);
     break;
 default:
     $region_list = get_region_list();
     $station_list = get_station_list();
     $area_list = get_area_list();
     $smarty->assign('full_page', 1);
     $smarty->assign('ur_here', '地址点管理');
     $smarty->assign('action_link', array('href' => 'area.php?act=add', 'text' => '添加地址点'));

    admin_priv('supplier_tag');
    /* 检查是否存在重名的会员等级 */
    if (!$exc->is_only('tag_name', trim($_POST['tag_name']))) {
        sys_msg(sprintf($_LANG['tag_name_exists'], trim($_POST['tag_name'])), 1);
    }
    $sql = "INSERT INTO " . $ecs->table('supplier_tag') . "( " . "tag_name,  is_groom,  sort_order" . ") VALUES (" . "'{$_POST['tag_name']}', '" . intval($_POST['is_groom']) . "' ,'" . intval($_POST['sort_order']) . "')";
    $db->query($sql);
    /* 管理员日志 */
    clear_cache_files();
    $lnk[] = array('text' => $_LANG['back_list'], 'href' => 'supplier_tag.php?act=list');
    $lnk[] = array('text' => $_LANG['add_continue'], 'href' => 'supplier_tag.php?act=add');
    sys_msg($_LANG['add_tag_success'], 0, $lnk);
} elseif ($_REQUEST['act'] == 'remove') {
    check_authz_json('supplier_tag');
    $tag_id = intval($_GET['id']);
    if ($exc->drop($tag_id)) {
        /* 更新会员表的等级字段 */
        clear_cache_files();
    }
    $url = 'supplier_tag.php?act=query&' . str_replace('act=remove', '', $_SERVER['QUERY_STRING']);
    ecs_header("Location: {$url}\n");
    exit;
} elseif ($_REQUEST['act'] == 'edit_name') {
    check_authz_json('supplier_tag');
    $id = intval($_REQUEST['id']);
    $val = empty($_REQUEST['val']) ? '' : json_str_iconv(trim($_REQUEST['val']));
    if ($exc->is_only('tag_name', $val, $id)) {
        if ($exc->edit("tag_name = '{$val}'", $id)) {
            /* 管理员日志 */
            clear_cache_files();
            make_json_result(stripcslashes($val));