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']);
}
