<?php
require_once(dirname(__FILE__) . '/app.php');
$today = strtotime(date('Y-m-d'));
$sql = "SELECT p.title,p.mobile,p.phone,p.address FROM `team` t,`partner` p WHERE t.partner_id = p.id AND t.end_time >= ".$today." group by t.partner_id";
$result = DB::GetQueryResult($sql,false);
$kn = array(
'title' => '商户名称',
'mobile' => '商户电话',
'address' => '商户地址',
);
foreach($result As $k=>$row) {
$o['title'] = $row['title'];
$o['mobile'] = $row['mobile'].'/'.$row['phone'];
$o['address'] = $row['address'];
$bizers[$k] = $o;
}
$name = "_bizer_".date('Ymd');
down_xls($bizers, $kn, $name);
?>
$orders = DB::LimitQuery('order', array('condition' => $oc, 'order' => 'ORDER BY pay_time DESC, id DESC'));
$kn = array('buy_id' => '支付序号', 'username' => '用户名', 'email' => '用户邮箱', 'realname' => '姓名', 'mobile' => '手机号码', 'address' => '地址', 'quantity' => '数量', 'condbuy' => '选项', 'remark' => '备注', 'date' => '支付时间');
foreach ($orders as $k => $o) {
$o['date'] = date('Y-m-d H:i', $o['pay_time']);
$orders[$k] = $o;
}
$name = "team_{$id}_" . date('Ymd');
down_xls($orders, $kn, $name);
} else {
$cc = array('team_id' => $id);
$coupons = DB::LimitQuery('coupon', array('condition' => $cc, 'order' => 'ORDER BY create_time ASC'));
$users = Table::Fetch('user', Utility::GetColumn($coupons, 'user_id'));
$orders = Table::Fetch('order', Utility::GetColumn($coupons, 'order_id'));
$kn = array('buy_id' => '支付序号', 'username' => '用户名', 'email' => '用户邮箱', 'realname' => '姓名', 'mobile' => '手机号码', 'condbuy' => '选项', 'id' => "{$INI['system']['couponname']}编号", 'secret' => "{$INI['system']['couponname']}密码", 'cmobile' => '消费手机', 'date' => '生成时间', 'remark' => '备注');
foreach ($coupons as $k => $o) {
$u = $users[$o['user_id']];
$r = $orders[$o['order_id']];
$o['buy_id'] = $r['buy_id'];
$o['username'] = $u['username'];
$o['realname'] = $u['realname'];
$o['condbuy'] = $r['condbuy'];
$o['mobile'] = $u['mobile'];
$o['email'] = $u['email'];
$o['cmobile'] = $r['mobile'] ? $r['mobile'] : $u['mobile'];
$o['date'] = date('Y-m-d H:i', $o['create_time']);
$o['remark'] = $r['remark'];
$coupons[$k] = $o;
}
$name = "team_{$id}_" . date('Ymd');
down_xls($coupons, $kn, $name);
}
<?php
require_once (dirname(dirname(dirname(__FILE__))) . '/app.php');
$partnerList = DB::LimitQuery('partner',array(
'condition'=>array('fid'=>0),
));
//商户名称，电话，地址，负责人手机号码，最近多少时间内做个团购
$kn = array(
'id' => '商家ID',
'title' => '商家名称',
'mobile' => '商家电话',
'address' => '地址',
'phone' => '负责人电话',
'team_create' => '最近团购时间',
);
foreach($partnerList as $k=>$partner){
$sql = "SELECT * FROM `team` WHERE `partner_id`=".$partner['id'].' ORDER BY id DESC';
$team = DB::GetQueryResult($sql,true);
$partner['team_create'] = date('Y-m-d',$team['begin_time']);
$partnerList[$k] = $partner;
}
$name = "milituan_partner_".date('Ymd');
down_xls($partnerList, $kn, $name);
?>
need_manager();
if ($_POST) {
$city_id = $_POST['city_id'];
$source = $_POST['source'];
if (empty($city_id)) {
die('-ERR ERR_NO_DATA');
}
if (empty($source)) {
die('-ERR ERR_NO_DATA');
}
$emails = array();
if (in_array('user', $source)) {
$rows = DB::LimitQuery('user', array('condition' => array('city_id' => $city_id), 'select' => 'email'));
foreach ($rows as $one) {
$emails[] = array('email' => $one['email']);
}
}
if (in_array('subscribe', $source)) {
$rows = DB::LimitQuery('subscribe', array('condition' => array('city_id' => $city_id), 'select' => 'email'));
foreach ($rows as $one) {
$emails[] = array('email' => $one['email']);
}
}
if ($emails) {
$kn = array('email' => 'Email');
$name = "email_" . date('Ymd');
down_xls($emails, $kn, $name);
}
die('-ERR ERR_NO_DATA');
}
include template('manage_market_downemail');
<?php
die;
require_once dirname(dirname(__FILE__)) . '/app.php';
$today = strtotime(date('Y-m-d'));
$itemList = DB::LimitQuery('team', array('condition' => array('is_car' => 1)));
$kn = array('id' => 'ID', 'title' => '车型', 'car_yh' => '优惠政策');
foreach ($itemList as $k => $row) {
$o['id'] = $row['id'];
$o['title'] = $row['title'];
$o['car_yh'] = $row['car_yh'];
$itemList[$k] = $o;
}
$name = "_car_" . date('Ymd');
down_xls($itemList, $kn, $name);
<?php
require_once dirname(dirname(dirname(__FILE__))) . '/app.php';
need_manager();
need_auth('market');
$id = abs(intval($_GET['id']));
$team = Table::Fetch('team', $id);
if ($team['delivery'] == 'express') {
$oc = array('state' => 'pay', 'team_id' => $id);
$orders = DB::LimitQuery('order', array('condition' => $oc));
$kn = array('username' => '用户名', 'email' => '用户邮箱', 'realname' => '姓名', 'mobile' => '手机号码', 'address' => '地址');
$name = "team_{$id}_" . date('Ymd');
down_xls($orders, $kn, $name);
} else {
$cc = array('team_id' => $id);
$coupons = DB::LimitQuery('coupon', array('condition' => $cc));
$users = Table::Fetch('user', Utility::GetColumn($coupons, 'user_id'));
$kn = array('username' => '用户名', 'email' => '用户邮箱', 'realname' => '姓名', 'mobile' => '手机号码', 'id' => "{$INI['system']['couponname']}编号", 'secret' => "{$INI['system']['couponname']}密码");
$ecs = array();
foreach ($coupons as $o) {
$u = $users[$o['user_id']];
$ecs[] = array('id' => $o['id'], 'secret' => $o['secret'], 'mobile' => $u['mobile'], 'email' => $u['email']);
}
$name = "team_{$id}_" . date('Ymd');
down_xls($ecs, $kn, $name);
}
$condition = array('service' => $service, 'state' => $state, 'team_id' => $team_id);
$orders = DB::LimitQuery('order', array('condition' => $condition, 'order' => 'ORDER BY id DESC'));
if (!$orders) {
die('-ERR ERR_NO_DATA');
}
$team = Table::Fetch('team', $team_id);
$name = 'order_' . date('Ymd');
$kn = array('id' => '订单号', 'pay_id' => '支付号', 'service' => '支付方式', 'price' => '单价', 'quantity' => '数量', 'fare' => '运费', 'origin' => '总金额', 'money' => '支付款', 'credit' => '余额付款', 'state' => '支付状态', 'remark' => '备注', 'express' => '快递信息', 'username' => '用户名', 'useremail' => '用户邮箱', 'usermobile' => '用户手机');
if ($team['delivery'] == 'express') {
$kn = array_merge($kn, array('realname' => '收件人', 'mobile' => '手机号码', 'zipcode' => '邮政编码', 'address' => '送货地址'));
}
$pay = array('alipay' => '支付宝', 'tenpay' => '财付通', 'chinabank' => '网银在线', 'credit' => '余额付款', 'cash' => '现金支付', '' => '其他');
$state = array('unpay' => '未支付', 'pay' => '已支付');
$eorders = array();
$expresses = option_category('express');
$users = Table::Fetch('user', Utility::GetColumn($orders, 'user_id'));
foreach ($orders as $one) {
$oneuser = $users[$one['user_id']];
$one['username'] = $oneuser['username'];
$one['useremail'] = $oneuser['email'];
$one['usermobile'] = $oneuser['mobile'];
$one['fare'] = $one['delivery'] == 'express' ? $one['fare'] : 0;
$one['service'] = $pay[$one['service']];
$one['price'] = $team['market_price'];
$one['state'] = $state[$one['state']];
$one['express'] = $one['express_id'] && $one['express_no'] ? $expresses[$one['express_id']] . ":" . $one['express_no'] : "";
$eorders[] = $one;
}
down_xls($eorders, $kn, $name);
}
include template('manage_market_downorder');
/* end */
$count = Table::Count('paycard', $condition);
list($pagesize, $offset, $pagestring) = pagestring($count, 50);
if ( strval($_GET['download'])) { $offset = 0; $pagesize = 100000; }
$cards = DB::LimitQuery('paycard', array(
'condition' => $condition,
'size' => $pagesize,
'offset' => $offset,
'order' => 'ORDER BY consume DESC, expire_time DESC',
));
$user_ids = Utility::GetColumn($cards, 'user_id');
$users = Table::Fetch('user', $user_ids);
if ( strval($_GET['download'])) {
$name = "paycard_{$state}_".date('Ymd');
$kn = array(
'id' => '密码',
'value' => '金额',
);
foreach($cards AS $cid => $one) {
$one['id'] = '#'.$one['id'];
$one['value'] = moneyit($one['value']);
$cards[$cid] = $one;
}
down_xls($cards, $kn, $name);
}
include template('manage_coupon_paycard');
<?php
require_once dirname(dirname(dirname(__FILE__))) . '/app.php';
need_manager();
need_auth('market');
if ($_POST) {
$city_id = $_POST['city_id'];
$users = DB::LimitQuery('user', array('condition' => array('city_id' => $city_id, 'mobile > 0'), 'select' => 'email, realname, mobile'));
if ($users) {
$kn = array('email' => '用户Email', 'realname' => '真实姓名', 'mobile' => '手机号码');
$name = "mobile_" . date('Ymd');
down_xls($users, $kn, $name);
}
die('-ERR ERR_NO_DATA');
}
include template('manage_market_downsms');
);
$teamList = DB::LimitQuery('team',array(
'condition'=>$condition,
));
$partners = Table::Fetch('partner',Utility::GetColumn($teamList,'partner_id'));
//商户名称，电话，地址，负责人手机号码，最近多少时间内做个团购
$kn = array(
'id' => '商家ID',
'title' => '商家名称',
'mobile' => '商家电话',
'address' => '地址',
'phone' => '负责人电话',
'team_create' => '最近团购时间',
);
foreach($partners as $k=>$partner){
$sql = "SELECT * FROM `team` WHERE `partner_id`=".$partner['id'].' ORDER BY id DESC';
$team = DB::GetQueryResult($sql,true);
$partner['team_create'] = date('Y-m-d',$team['begin_time']);
$partners[$k] = $partner;
}
$name = "milituan_6_month_partner_".date('Ymd');
down_xls($partners, $kn, $name);
?>
