function exportData() { $ht = array('编号', '标识', '标题', '排序', '上级编号'); $map['module'] = I('module'); $list = M('common_category')->where($map)->field('id,name,title,sort,pid')->limit(10000)->select(); $arr[0] = $ht; if (!empty($list)) { $arr = array_merge($arr, $list); } outExcel($arr, $map['module']); }
public function common_export($model = null, $order = 'id desc', $return = false) { set_time_limit(0); // 获取模型信息 is_array($model) || ($model = $this->getModel($model)); // 解析列表规则 $list_data = $this->_list_grid($model); $grids = $list_data['list_grids']; $fields = $list_data['fields']; foreach ($grids as $v) { if ($v['title'] == '操作') { array_pop($grids); } else { $arr = explode('|', $v['field']); if (count($arr) > 1) { $fun[$arr[0]] = $arr[1]; } $ht[$arr[0]] = $v['title']; } } $dataArr[0] = $ht; // 搜索条件 $map = $this->_search_map($model, $fields); $name = parse_name(get_table_name($model['id']), true); $data = M($name)->field(empty($fields) ? true : $fields)->where($map)->order($order)->select(); if ($data) { foreach ($data as &$vo) { foreach ($vo as $name => &$vv) { if (isset($fun[$name])) { if ($fun[$name] == 'get_name_by_status') { $vv = get_name_by_status($vv, $name, $model['id']); } else { $vv = call_user_func($fun[$name], $vv); } } } foreach ($ht as $key => $val) { $newArr[$key] = empty($vo[$key]) ? ' ' : $vo[$key]; } $vo = $newArr; } $dataArr = array_merge($dataArr, $data); } if ($return) { return $dataArr; } else { outExcel($dataArr, $map['module']); } }
function export() { set_time_limit(0); $id = $hpmap['id'] = I('id'); $info = D('Coupon')->getInfo($id); $dataArr[0] = array(0 => "用户", 1 => " 详细信息", 2 => " SN码", 3 => "工作人员", 4 => "核销时间"); $px = C('DB_PREFIX'); $page = I('p', 1, 'intval'); // 默认显示第一页数据 // 搜索条件 $where = "is_use=1 AND addon='Coupon' AND target_id=" . $id; $start_time = I('start_time'); if ($start_time) { $where .= " AND s.use_time>" . strtotime($start_time); } $end_time = I('end_time'); if ($end_time) { $where .= " AND s.use_time<" . strtotime($end_time); } $search_nickname = I('search_nickname'); if (!empty($search_nickname)) { $where .= " AND s.uid IN(" . D('Common/User')->searchUser($search_nickname) . ")"; } // 读取模型数据列表 $data = D('Common/SnCode')->field(true)->where($where)->order('use_time DESC')->limit(5000)->select(); // dump ( $data ); foreach ($data as $k => $vo) { $vo['content'] = '核销优惠券: ' . $info['title']; $dataArr[$k + 1] = array(0 => get_nickname($vo['uid']), 1 => $vo['content'], 2 => $vo['sn'], 3 => get_nickname($vo['admin_uid']), 4 => time_format($vo['use_time'])); } outExcel($dataArr, 'Coupon_' . $id); }
function export() { set_time_limit(0); $umap['u.status'] = array('gt', 0); $umap['f.token'] = get_token(); $gid = I('id', 0); if ($gid) { $map['group_id'] = $gid; $uids = M('auth_group_access')->where($map)->getFields('uid'); if (!empty($uids)) { $umap['u.uid'] = array('in', $uids); } else { $umap['u.uid'] = 0; } } $order = 'u.uid asc'; $px = C('DB_PREFIX'); $field = 'u.uid,nickname,truename,mobile,sex,province,city,score,experience,f.openid'; $data = M()->table($px . 'public_follow as f')->join($px . 'user as u ON f.uid=u.uid')->field($field)->where($umap)->order($order)->select(); $sexArr = array(0 => '保密', 1 => '男', 2 => '女'); foreach ($data as $k => &$vo) { $vo['sex'] = $sexArr[$vo['sex']]; $vo['nickname'] = deal_emoji($vo['nickname'], 1); } $ht = array('用户编号', '昵称', '姓名', '联系电话', '性别', '省份', '城市', '金币值', '经验值', 'OpenID'); $dataArr[0] = $ht; $dataArr = array_merge($dataArr, (array) $data); // dump($dataArr); outExcel($dataArr, $map['module']); // vendor ( 'out-csv' ); // export_csv ( $dataArr, 'user_export' ); }
function export() { set_time_limit(0); // 获取模型信息 $model = $this->model; // 解析列表规则 $list_data = $this->_list_grid($model); $grids = $list_data['list_grids']; $fields = $list_data['fields']; foreach ($grids as $v) { if ($v['title'] == '操作') { array_pop($grids); } else { $arr = explode('|', $v['field'][0]); if (count($arr) > 1) { $fun[$arr[0]] = $arr[1]; } $ht[$arr[0]] = $v['title']; } } $dataArr[0] = $ht; // 搜索条件 $map = $this->_search_map($model, $fields); $map['ask_id'] = $this->ask_id; $name = parse_name(get_table_name($model['id']), true); $data = M($name)->field(empty($fields) ? true : $fields)->where($map)->order($order)->select(); if ($data) { $qdao = D('AskQuestion'); foreach ($data as &$vv) { $user = get_followinfo($vv['uid']); $vv['nickname'] = $user['nickname']; $vv['times'] += 1; $vv['question_id'] = $qdao->getQuestionTitle($vv['question_id'], $this->ask_id); $vv['answer'] = implode(', ', unserialize($vv['answer'])); $vv['is_correct'] = $vv['is_correct'] == 1 ? '是' : '否'; } foreach ($data as &$vo) { foreach ($vo as $name => &$vv) { if (isset($fun[$name])) { if ($fun[$name] == 'get_name_by_status') { $vv = get_name_by_status($vv, $name, $model['id']); } else { $vv = call_user_func($fun[$name], $vv); } } } foreach ($ht as $key => $val) { $newArr[$key] = empty($vo[$key]) ? ' ' : $vo[$key]; } $vo = $newArr; } $dataArr = array_merge($dataArr, $data); } if ($return) { return $dataArr; } else { outExcel($dataArr, $map['module']); } }
function output() { $model = $this->model; $map['token'] = get_token(); $orders = D('Addons://Shop/Order')->where($map)->getFields('order_number,id'); $follows = M('public_follow')->where($map)->getFields('openid,uid'); $payStatus = I('get.pay_status'); if ($payStatus) { if ($payStatus == 3) { $map['status'] = 0; } else { $map['status'] = $payStatus; } } $payType = I('get.pay_type'); if ($payType) { $map['paytype'] = $payType; } $isPrice = I('get.is_price'); if ($isPrice) { $minVal = I('get.min_value', 0, 'intval'); $maxVal = I('get.max_value', 0, 'intval'); if ($minVal && $maxVal) { $minVal < $maxVal && ($map['price'] = array('between', array($minVal, $maxVal))); $minVal > $maxVal && ($map['price'] = array('between', array($maxVal, $minVal))); $minVal == $maxVal && ($map['price'] = $minVal); } else { if (!empty($minVal)) { $map['price'] = array('egt', $minVal); } else { if (!empty($maxVal)) { $map['price'] = array('elt', $maxVal); } } } } $search = $_REQUEST['single_orderid']; if ($search) { $this->assign('search', $search); $map['single_orderid'] = array('like', '%' . htmlspecialchars($search) . '%'); unset($_REQUEST['single_orderid']); } session('common_condition', $map); $list_data = $this->_get_model_list($this->model); foreach ($list_data['list_grids'] as $v) { $titleArr[] = $v['title']; } $dataArr[] = $titleArr; $paytypearr = array('Weixin' => '微信支付', 'Alipaytype' => '支付宝支付', 'Tenpay' => '财付通WAP支付', 'TenpayComputer' => '财付通支付', 'Quickpay' => '银联支付'); foreach ($list_data['list_data'] as &$vo) { $vo['wecha_id'] = get_userinfo($follows[$vo['wecha_id']], 'nickname'); $vo['orderName'] = urldecode($vo['orderName']); $vo['price'] = '¥' . wp_money_format($vo['price']); $vo['status'] = $vo['status'] == 0 ? '未支付' : '已支付'; $vo['paytype'] = $paytypearr[$vo['paytype']]; $param['id'] = $orders[$vo['single_orderid']]; $vo['single_orderid'] = $vo['single_orderid']; unset($vo['id']); $dataArr[] = $vo; } outExcel($dataArr, $map['module']); }