public function excel() { Vendor('Excel.php-excel'); $map['id'] = array('in', $_REQUEST['id']); $orders = $this->dao->where($map)->select(); $xls = array(); $xls[0][0] = "编号"; $xls[0][1] = "金额"; $xls[0][2] = "运输方式"; $xls[0][3] = "运费"; $xls[0][4] = "手续费"; $xls[0][5] = "保险金"; $xls[0][6] = "付款方式"; $xls[0][7] = "购买时间"; $xls[0][8] = "附加留言"; $xls[0][9] = "IP地址"; $xls[0][10] = "邮箱"; $xls[0][11] = "姓"; $xls[0][12] = "名"; $xls[0][13] = "地址"; $xls[0][14] = "电话"; $xls[0][15] = "邮编"; $xls[0][16] = "城市"; $xls[0][17] = "省份"; $xls[0][18] = "国家"; $xls[0][19] = "订单状态"; $xls[0][20] = "快递方式"; $xls[0][21] = "重量"; $i = 1; foreach ($orders as $o) { $xls[$i][0] = $o['sn']; $xls[$i][1] = $o['orders_total']; $xls[$i][2] = $o['shipping_method']; $xls[$i][3] = $o['shippingmoney']; $xls[$i][4] = $o['paymoney']; $xls[$i][5] = $o['insurance']; $xls[$i][6] = $o['payment_module_code']; $xls[$i][7] = toDate($o['dateline']); $xls[$i][8] = $o['BuyNote']; $xls[$i][9] = $o['ip_address'] . "(" . get_ip_area($o['ip_address']) . ")"; $xls[$i][10] = $o['delivery_email']; $xls[$i][11] = $o['delivery_firstname']; $xls[$i][12] = $o['delivery_lastname']; $xls[$i][13] = $o['delivery_address']; $xls[$i][14] = $o['delivery_telephone']; $xls[$i][15] = $o['delivery_zip']; $xls[$i][16] = $o['delivery_city']; $xls[$i][17] = $o['delivery_state']; $xls[$i][18] = $o['delivery_country']; $xls[$i][19] = L('orders_status_' . $o['orders_status']); $xls[$i][20] = $o['shipping_method']; $xls[$i][21] = $o['total_weight']; $i++; } $xls_obj = new Excel_XML('UTF-8', false, 'SOP订单列表'); $xls_obj->addArray($xls); $xls_obj->generateXML("SOP"); }
$db->query("UPDATE " . table('members') . " SET qq_openid = '' WHERE uid='{$_SESSION[uid]}' LIMIT 1"); exit('解除腾讯QQ绑定成功!'); } elseif ($act == 'del_sina_binding') { $db->query("UPDATE " . table('members') . " SET sina_access_token = '' WHERE uid='{$_SESSION[uid]}' LIMIT 1"); exit('解除新浪微博绑定成功!'); } elseif ($act == 'del_taobao_binding') { $db->query("UPDATE " . table('members') . " SET taobao_access_token = '' WHERE uid='{$_SESSION[uid]}' LIMIT 1"); exit('解除淘宝账号绑定成功!'); } elseif ($act == 'login_log') { require_once QISHI_ROOT_PATH . 'include/fun_user.php'; require_once QISHI_ROOT_PATH . 'include/page.class.php'; $uid = intval($_SESSION['uid']); $smarty->assign('total', $db->get_total("SELECT COUNT(*) AS num FROM " . table('pms') . " WHERE (msgfromuid='{$uid}' OR msgtouid='{$uid}') AND `new`='1'")); $wheresql = " WHERE log_uid='{$_SESSION['uid']}' AND log_type='1001' "; $perpage = 15; $total_sql = "SELECT COUNT(*) AS num FROM " . table('members_log') . $wheresql; $total_val = $db->get_total($total_sql); $page = new page(array('total' => $total_val, 'perpage' => $perpage, 'getarray' => $_GET)); $currenpage = $page->nowindex; $offset = ($currenpage - 1) * $perpage; $smarty->assign('loginlog', get_user_loginlog($offset, $perpage, $wheresql)); $smarty->assign('page', $page->show(3)); $smarty->assign('title', '会员登录日志 - 企业会员中心 - ' . $_CFG['site_name']); $smarty->display('member_personal/personal_user_loginlog.htm'); } elseif ($act == 'demo') { require_once QISHI_ROOT_PATH . 'include/fun_user.php'; echo '<pre>'; print_r(get_ip_area('113.25.9.112')); echo '</pre>'; } unset($smarty);