<?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); ?>