public function do_rule()
{
global $_GP;
$xc_zjp = mysqld_select("SELECT * FROM " . table('xc_zjp_reply') . " LIMIT 1");
$member = get_member_account(true, intval($xc_zjp['needreg']) == 1);
$openid = $member['openid'];
$myuser = mysqld_select("SELECT id,points,count FROM " . table('xc_zjp_user') . " WHERE open_id = '{$openid}' ");
include addons_page('rule');
}
//移动端版本兼容
if(/Android (\d+\.\d+)/.test(navigator.userAgent)){
var version = parseFloat(RegExp.$1);
if(version>2.3){
var phoneScale = parseInt(window.screen.width)/640;
document.write('<meta name="viewport" content="width=640, minimum-scale = '+ phoneScale +', maximum-scale = '+ phoneScale +', target-densitydpi=device-dpi">');
}else{
document.write('<meta name="viewport" content="width=640, target-densitydpi=device-dpi">');
}
}else{
document.write('<meta name="viewport" content="width=640, user-scalable=no, target-densitydpi=device-dpi">');
}
</script>
<?php
include addons_page('share');
?>
<link rel="stylesheet" type="text/css" href="<?php
echo WEBSITE_ROOT;
?>
/addons/addon10/resource/21/assets/styles/app.min.css?ver=3.6"/>
</head>
<body class="app" data-app-id="5261" data-ad="1">
<span style="display:none;" id="activity_id">5261</span>
<img style='display:none;' src="<?php
echo WEBSITE_ROOT;
?>
/addons/addon10/resource/20/res/img/loading_large.gif" />
<?php
<?php
$operation = !empty($_GP['op']) ? $_GP['op'] : 'display';
if ($operation == 'delete') {
mysqld_delete('addon10_scene_subscribe', array("id" => intval($_GP['id'])));
message("删除成功！", "refresh", "success");
}
$subscribe_list = mysqld_selectall("SELECT subscribe.*,sl.title FROM " . table('addon10_scene_subscribe') . " subscribe left join " . table('addon10_scene_list') . " sl on sl.id=subscribe.list_id ");
include addons_page('subscribe');
// | WE CAN DO IT JUST FREE
// +----------------------------------------------------------------------
// | Copyright (c) 2015 http://www.baijiacms.com All rights reserved.
// +----------------------------------------------------------------------
// | Author: °Ù¼ÒÍþÐÅ <QQ:2752555327> <http://www.baijiacms.com>
// +----------------------------------------------------------------------
$condition = "";
$pindex = max(1, intval($_GP['page']));
$psize = 20;
if (!empty($_GP['start_time']) && !empty($_GP['end_time'])) {
$start_time = strtotime($_GP['start_time'] . " 00:00:01");
$end_time = strtotime($_GP['end_time'] . " 23:59:59");
} else {
$start_time = strtotime(date('Y-m-01 00:00:01', time()));
$end_time = strtotime(date('Y-m-t 23:59:59', time()));
}
$condition = " and orders.createtime>=" . $start_time . " and orders.createtime<=" . $end_time;
if (!empty($_GP['saledetailsEXP01'])) {
$psize = 9999;
$pindex = 1;
}
$list = mysqld_selectall("SELECT ordergoods.price,ordergoods.total,(select title from " . table('shop_goods') . " goods where ordergoods.goodsid=goods.id) titles,orders.createtime,orders.ordersn from " . table('shop_order_goods') . " ordergoods left join " . table('shop_order') . " orders on orders.id=ordergoods.orderid where 1=1 {$condition} order by orders.createtime desc LIMIT " . ($pindex - 1) * $psize . ',' . $psize);
$total = mysqld_selectcolumn("SELECT count(ordergoods.id) from " . table('shop_order_goods') . " ordergoods left join " . table('shop_order') . " orders on orders.id=ordergoods.orderid where 1=1 {$condition} order by orders.createtime desc");
$pager = pagination($total, $pindex, $psize);
if (!empty($_GP['saledetailsEXP01'])) {
$report = "saledetails";
require_once 'report.php';
exit;
}
include addons_page('saledetails');
}
if (!empty($parentid)) {
$parent = mysqld_select("SELECT id, name FROM " . table('addon8_article_category') . " WHERE id = '{$parentid}'");
if (empty($parent)) {
message('抱歉，上级分类不存在或是已经被删除！', web_url('post'), 'error');
}
}
if (checksubmit('submit')) {
if (empty($_GP['catename'])) {
message('抱歉，请输入分类名称！');
}
$data = array('name' => $_GP['catename'], 'deleted' => 0, 'displayorder' => intval($_GP['displayorder']), 'icon' => $_GP['icon'], 'parentid' => intval($parentid));
if (!empty($id)) {
unset($data['parentid']);
mysqld_update('addon8_article_category', $data, array('id' => $id));
} else {
mysqld_insert('addon8_article_category', $data);
$id = mysqld_insertid();
}
message('更新分类成功！', web_url('category', array('op' => 'display')), 'success');
}
include addons_page('category');
} elseif ($operation == 'delete') {
$id = intval($_GP['id']);
$category = mysqld_select("SELECT id, parentid FROM " . table('addon8_article_category') . " WHERE id = '{$id}' and deleted=0 ");
if (empty($category)) {
message('抱歉，分类不存在或是已经被删除！', web_url('category', array('op' => 'display')), 'error');
}
mysqld_update('addon8_article_category', array('deleted' => 1), array('id' => $id, 'parentid' => $id), 'OR');
message('分类删除成功！', web_url('category', array('op' => 'display')), 'success');
}
<?php
$awardlist = mysqld_selectall("select award.awardtype,award.gold,request.id,request.realname,request.mobile,request.address,award.title,award.credit_cost,award.price,request.createtime FROM " . table('addon7_request') . " request left join " . table('addon7_award') . " award on award.id=request.award_id where status=0");
include addons_page('applyed');
} else {
$insert['param'] = '';
}
if ($item == false) {
$temp = mysqld_insert('addon10_scene_page', $insert);
} else {
$temp = mysqld_update('addon10_scene_page', $insert, array('id' => $item['id']));
}
if ($temp == false) {
$this->ajaxmessage('数据提交失败');
} else {
$this->ajaxmessage('数据提交成功', web_url('scene_page', array('listid' => $list_id, 'op' => 'display')), 'success');
}
}
$uploadfolder = WEB_ROOT . '/attachment/image/addon10/';
mkdirs($uploadfolder);
$tmpfoldername = random(15);
copy(ADDONS_ROOT . 'addon10/style/img/default_bg.jpg', $uploadfolder . $tmpfoldername . 'jpg');
$tmpfoldername2 = random(15);
copy(ADDONS_ROOT . 'addon10/style/img/default_btn.png', $uploadfolder . $tmpfoldername2 . 'png');
if ($item == false) {
$item = array('listorder' => 0, 'thumb' => 'image/addon10/' . $tmpfoldername . 'jpg');
$data = array();
} else {
$data = $this->iunserializer($item['param']);
}
if (empty($data['btnimg'])) {
$data['btnimg'] = 'image/addon10/' . $tmpfoldername2 . 'png';
}
include addons_page('themes/' . $list['theme'] . '/page');
<?php
$awardlist = mysqld_selectall("select * FROM " . table('addon7_award') . " where deleted=0");
include addons_page('awardlist');
}
if (!empty($_GP['bg_music_url_del'])) {
$data['bg_music_url'] = '';
}
if (!empty($_FILES['bg_music_url']['tmp_name'])) {
$upload = file_upload($_FILES['bg_music_url'], 'music');
if (is_error($upload)) {
message($upload['message'], '', 'error');
}
$data['bg_music_url'] = $upload['path'];
}
mysqld_update('addon10_scene_list', $data, array('id' => $_GP['id']));
message("修改成功", "refresh", "success");
}
}
include addons_page('themes/' . $theme . '/scene_post');
exit;
}
if ($operation == 'delete') {
mysqld_delete('addon10_scene_page', array("list_id" => intval($_GP['id'])));
mysqld_delete('addon10_scene_subscribe', array("list_id" => intval($_GP['id'])));
mysqld_delete('addon10_scene_list', array("id" => intval($_GP['id'])));
message("删除成功！", "refresh", "success");
}
if ($operation == 'post') {
include addons_page('scene');
exit;
}
$scene_list = mysqld_selectall("SELECT * FROM " . table('addon10_scene_list'));
include addons_page('scene_list');
$operation = !empty($_GP['op']) ? $_GP['op'] : 'display';
$list = mysqld_selectall("SELECT * FROM " . table('xc_zjp_award'));
if ($operation == 'post') {
$id = intval($_GP['id']);
if (checksubmit('submit')) {
$data = array('title' => $_GP['title'], 'probalilty' => intval($_GP['probalilty']), 'total' => intval($_GP['total']));
if (!empty($_FILES['description']['tmp_name'])) {
$upload = file_upload($_FILES['description']);
if (is_error($upload)) {
message($upload['message'], '', 'error');
}
$data['description'] = $upload['path'];
}
if (!empty($id)) {
mysqld_update('xc_zjp_award', $data, array('id' => $id));
} else {
mysqld_insert('xc_zjp_award', $data);
}
message('操作成功！', web_url('prizelist'), 'success');
}
$item = mysqld_select("select * from " . table('xc_zjp_award') . " where id=:id limit 1", array(":id" => $id));
include addons_page('prize');
exit;
}
if ($operation == 'delete') {
$id = intval($_GP['id']);
mysqld_delete('xc_zjp_award', array('id' => $id));
message('奖品删除成功！', web_url('prizelist'), 'success');
}
include addons_page('prizelist');
<?php
// +----------------------------------------------------------------------
// | WE CAN DO IT JUST FREE
// +----------------------------------------------------------------------
// | Copyright (c) 2015 http://www.baijiacms.com All rights reserved.
// +----------------------------------------------------------------------
// | Author: °Ù¼Òcms <QQ:1987884799> <http://www.baijiacms.com>
// +----------------------------------------------------------------------
$goodslist = mysqld_selectall("SELECT goods.id,goods.sales from " . table('shop_goods') . " goods ");
foreach ($goodslist as $gooditem) {
$goodtotal = mysqld_selectcolumn("SELECT sum(goodorder.total) FROM " . table('shop_order_goods') . " goodorder left join " . table('shop_order') . " orders on orders.id=goodorder.orderid WHERE goodorder.goodsid = :id and orders.status>=1", array(':id' => $gooditem['id']));
if ($goodtotal > 0 && $goodslist['sales'] != $goodtotal && !empty($goodtotal)) {
mysqld_update('shop_goods', array('sales' => $goodtotal), array('id' => $gooditem['id']));
}
}
$list = mysqld_selectall("SELECT goods.*,0 as cpersent,goods.sales salescount from " . table('shop_goods') . " goods order by salescount desc ");
foreach ($list as $id => $displayorder) {
$list[$id]['cpersent'] = round($list[$id]['salescount'] / ($list[$id]['viewcount'] == 0 ? 1 : $list[$id]['viewcount']) * 100, 2);
if (empty($list[$id]['viewcount'])) {
$list[$id]['viewcount'] = 0;
}
if (empty($list[$id]['salescount'])) {
$list[$id]['salescount'] = 0;
}
if (empty($list[$id]['cpersent'])) {
$list[$id]['cpersent'] = 0;
}
}
include addons_page('productsalestatistics');
}
if (!empty($_GP['addressname'])) {
$addressname = $_GP['addressname'];
$condition .= " and t1.tdrealname='" . $addressname . "'";
}
if (!empty($_GP['ordersn'])) {
$ordersn = $_GP['ordersn'];
$condition .= " and t1.ordersn='" . $ordersn . "'";
}
if ($isstatus == 1) {
$conditionOrderStatus = "and orders.status>=1";
} else {
$conditionOrderStatus = "and orders.status=3";
}
if (!empty($_GP['orderstatisticsEXP01'])) {
$psize = 9999;
$pindex = 1;
}
$list = mysqld_selectall("select t1.* from (SELECT orders.status,orders.id,orders.createtime,orders.ordersn,orders.price,orders.dispatchprice,orders.paytype,(orders.address_realname ) tdrealname,(concat(orders.address_province,orders.address_city,orders.address_area,orders.address_address) ) tdaddress,(orders.address_mobile ) tdmobile from " . table('shop_order') . " orders where 1=1 {$conditionOrderStatus} order by orders.createtime desc) t1 where 1=1 {$condition} LIMIT " . ($pindex - 1) * $psize . ',' . $psize);
foreach ($list as $id => $displayorder) {
$list[$id]['ordergoods'] = mysqld_selectall("SELECT (select category.name\tfrom" . table('shop_category') . " category where (0=goods.ccate and category.id=goods.pcate) or (0!=goods.ccate and category.id=goods.ccate) ) as categoryname,goods.thumb,ordersgoods.price,ordersgoods.total,goods.title,ordersgoods.optionname from " . table('shop_order_goods') . " ordersgoods left join " . table('shop_goods') . " goods on goods.id=ordersgoods.goodsid where ordersgoods.orderid=:oid order by ordersgoods.createtime desc ", array(':oid' => $list[$id]['id']));
}
$total = mysqld_selectcolumn("select count(t1.id) from (SELECT orders.* from " . table('shop_order') . " orders where 1=1 {$conditionOrderStatus} order by orders.createtime desc) t1 where 1=1 {$condition} ");
$pager = pagination($total, $pindex, $psize);
if (!empty($_GP['orderstatisticsEXP01'])) {
$report = "orderstatistics";
require_once 'report.php';
exit;
}
include addons_page('orderstatistics');
<?php
$singlepage = mysqld_select("SELECT * FROM " . table('addon9_singlepage') . " where id=:id ", array(":id" => intval($_GP['id'])));
$cfg = globaSetting();
include addons_page('singlepage');
<?php
$operation = !empty($_GP['op']) ? $_GP['op'] : 'display';
if ($operation == 'delete') {
mysqld_delete('addon9_singlepage', array("id" => intval($_GP['id'])));
message("删除成功！", "refresh", "success");
}
if ($operation == 'post') {
$singlepage = mysqld_select("SELECT * FROM " . table('addon9_singlepage') . " where id='" . intval($_GP['id']) . "' ");
if (checksubmit('submit')) {
if (empty($_GP['id'])) {
$data = array('createtime' => time(), 'title' => $_GP['title'], 'open_footer' => intval($_GP['open_footer']), 'content' => htmlspecialchars_decode($_GP['content']));
mysqld_insert('addon9_singlepage', $data);
message("添加成功", create_url('site', array('name' => 'addon9', 'do' => 'singlepage', 'op' => 'post', 'id' => mysqld_insertid())), "success");
} else {
$data = array('title' => $_GP['title'], 'open_footer' => intval($_GP['open_footer']), 'content' => htmlspecialchars_decode($_GP['content']));
mysqld_update('addon9_singlepage', $data, array('id' => $_GP['id']));
message("修改成功", "refresh", "success");
}
}
include addons_page('singlepage');
exit;
}
$singlepage_list = mysqld_selectall("SELECT * FROM " . table('addon9_singlepage'));
include addons_page('singlepage_list');
message($upload['message'], '', 'error');
}
$data['thumb'] = $upload['path'];
}
mysqld_insert('addon8_article', $data);
message("添加成功", create_url('site', array('name' => 'addon8', 'do' => 'article', 'op' => 'post', 'id' => mysqld_insertid())), "success");
} else {
$data = array('createtime' => time(), 'pcate' => intval($_GP['pcate']), 'ccate' => intval($_GP['ccate']), 'iscommend' => intval($_GP['iscommend']), 'ishot' => intval($_GP['ishot']), 'mobileTheme' => intval($_GP['mobileTheme']), 'title' => $_GP['title'], 'readcount' => intval($_GP['readcount']), 'description' => $_GP['description'], 'content' => htmlspecialchars_decode($_GP['content']), 'displayorder' => intval($_GP['displayorder']));
if (!empty($_GP['thumb_del'])) {
$data['thumb'] = '';
}
if (!empty($_FILES['thumb']['tmp_name'])) {
file_delete($_GP['thumb_old']);
$upload = file_upload($_FILES['thumb']);
if (is_error($upload)) {
message($upload['message'], '', 'error');
}
$data['thumb'] = $upload['path'];
}
mysqld_update('addon8_article', $data, array('id' => $_GP['id']));
message("修改成功", "refresh", "success");
}
}
include addons_page('article');
exit;
}
$article_list = mysqld_selectall("SELECT * FROM " . table('addon8_article') . " order by displayorder desc");
$category_pcate = mysqld_selectall("SELECT * FROM " . table('addon8_article_category') . " where parentid=0 ", array(), 'id');
$category_ccate = mysqld_selectall("SELECT * FROM " . table('addon8_article_category') . " where parentid!=0 ", array(), 'id');
include addons_page('article_list');
<?php
$setting = mysqld_select("SELECT * FROM " . table('addon7_config'));
if (checksubmit("submit")) {
$cfg = array('title' => $_GP['title']);
mysqld_delete('addon7_config', array());
mysqld_insert('addon7_config', $cfg);
message('保存成功', 'refresh', 'success');
}
include addons_page('setting');
<?php
$operation = !empty($_GP['op']) ? $_GP['op'] : 'display';
if ($operation == 'delete') {
mysqld_delete('addon10_scene_page', array("id" => intval($_GP['id'])));
message("删除成功！", "refresh", "success");
}
$scene_page_list = mysqld_selectall("SELECT * FROM " . table('addon10_scene_page') . " where list_id=:list_id", array("list_id" => intval($_GP['listid'])));
$scene = mysqld_select("SELECT * FROM " . table('addon10_scene_list') . " where id='" . intval($_GP['listid']) . "' ");
if (!empty($scene['id'])) {
$theme = $scene['theme'];
}
$list_id = intval($_GP['listid']);
include addons_page('themes/' . $theme . '/scene_page_list');
$dayordercount = 0;
}
$daydatas[$dayindex]['day'] = $day;
$daydatas[$dayindex]['count'] = $dayordercount;
$dayindex = $dayindex + 1;
$dayallcount = $dayallcount + $dayordercount;
if ($daytopcount < $dayordercount) {
$daytopcount = $dayordercount;
}
}
foreach ($daydatas as $index => $row) {
if ($dayallcount > 0) {
$daydatas[$index]['persent'] = round($daydatas[$index]['count'] / $dayallcount, 2) * 100;
} else {
$daydatas[$index]['persent'] = 0;
}
}
if (!empty($_GP['salereportEXP01'])) {
$report = "salereport01";
$list = $datas;
require_once 'report.php';
exit;
}
if (!empty($_GP['salereportEXP02'])) {
$report = "salereport02";
$list = $daydatas;
require_once 'report.php';
exit;
}
include addons_page('salereport');
?>
" />
<input type="hidden" value="<?php
echo $item['thumb'];
?>
" name="thumb" id="pureimg" />
<span class="help-inline"><button name="button" class="btn select_img" type="button">传图</button><span class="help-inline">（建议尺寸:宽640像素,高960像素或等比图片）</span></span>
</div>
</div>
</div>
<?php
if (is_array($mtypelist)) {
foreach ($mtypelist as $row) {
?>
<?php
include addons_page('sucai/' . $row['type']);
?>
<?php
}
}
?>
<span class="help-block margin-top10"></span>
</div>
</div>
<div class="form-actions">
<button type="submit" class="btn btn-primary">保存</button>
<button type="button" class="btn" onclick="window.history.go(-1)">取消</button>
</div>
</div>
</form>
</div>
<?php
$article = mysqld_select("SELECT * FROM " . table('addon8_article') . " where id=:id ", array(":id" => intval($_GP['id'])));
if (!empty($article['id'])) {
mysqld_update('addon8_article', array('readcount' => intval($article['readcount']) + 1), array('id' => intval($_GP['id'])));
}
$cfg = globaSetting();
if (empty($article['mobileTheme'])) {
include addons_page('article');
} else {
include addons_page('article' . $article['mobileTheme']);
}
<?php
if (checksubmit("submit")) {
$insert = array('title' => $_GP['title'], 'amount' => intval($_GP['amount']), 'endtime' => strtotime($_GP['endtime']), 'price' => $_GP['price'], 'gold' => $_GP['gold'], 'awardtype' => intval($_GP['awardtype']), 'credit_cost' => intval($_GP['credit_cost']), 'createtime' => time(), "deleted" => 0, 'content' => htmlspecialchars_decode($_GP['content']));
if (!empty($_FILES['logo']['tmp_name'])) {
$upload = file_upload($_FILES['logo']);
if (is_error($upload)) {
message($upload['message'], '', 'error');
}
$logo = $upload['path'];
}
if (!empty($logo)) {
$insert['logo'] = $logo;
}
mysqld_insert('addon7_award', $insert);
message('保存成功', web_url('awardlist'), 'success');
}
include addons_page('award');
<?php
$id = intval($_GP['id']);
$list = mysqld_select('SELECT * FROM' . table('addon10_scene_list') . ' WHERE `id`=:id ', array(':id' => $id));
$theme = "";
if (!empty($list['id'])) {
$theme = $list['theme'];
if (empty($_SESSION['addon10_' . $list['id']])) {
mysqld_update('addon10_scene_list', array('hits' => $list['hits'] + 1), array('id' => $list['id']));
$_SESSION['addon10_' . $list['id']] = 1;
}
if (strpos($_SERVER['HTTP_USER_AGENT'], 'MicroMessenger')) {
$signPackage = $this->getSignPackage($list['id']);
}
}
$items = mysqld_selectall('SELECT * FROM' . table('addon10_scene_page') . ' WHERE `list_id`=:list_id ORDER BY `listorder` desc,id asc', array(':list_id' => $list['id']));
if (!empty($theme)) {
include addons_page('themes/' . $theme . '/show');
}
exit;
$chart1data = mysqld_select("SELECT count(*) as counts,'" . $time . "' as dates FROM " . table('member') . " WHERE istemplate = 0 {$conditionflag} and " . $condtitiontime . ">=" . $start_time . " and " . $condtitiontime . "<=" . $end_time);
$chartdata2[$index]['counts'] = $chart1data['counts'];
$chartdata2[$index]['dates'] = $dateindex;
$chartdata2[$index]['index'] = $index;
$index = $index + 1;
}
$index = 0;
$chartdata3 = array();
$dropMonthForYaer2 = $_GP['dropMonthForYaer2'] ? $_GP['dropMonthForYaer2'] : $nowyear;
$dropMonthForYaer2 = intval($dropMonthForYaer2);
$years2 = array(array('year' => $nowyear - 3, 'checked' => 0), array('year' => $nowyear - 2, 'checked' => 0), array('year' => $nowyear - 1, 'checked' => 0), array('year' => $nowyear, 'checked' => 1));
foreach ($years2 as $id => $displayorder) {
if ($years2[$id]['year'] == $dropMonthForYaer2) {
$years2[$id]['checked'] = 1;
} else {
$years2[$id]['checked'] = 0;
}
}
for ($dateindex = 1; $dateindex <= 12; $dateindex++) {
$lastday = date('t', strtotime($dropMonthForYaer2 . "-" . $dateindex . "-1"));
$time = $dropMonthForYaer2 . "-" . $dateindex;
$start_time = strtotime($time . "-1" . " 00:00:01");
$end_time = strtotime($time . "-" . $lastday . " 23:59:59");
$chart1data = mysqld_select("SELECT count(*) as counts,'" . $time . "' as dates FROM " . table('member') . " WHERE istemplate = 0{$conditionflag} and " . $condtitiontime . ">=" . $start_time . " and " . $condtitiontime . "<=" . $end_time);
$chartdata3[$index]['counts'] = $chart1data['counts'];
$chartdata3[$index]['dates'] = $chart1data['dates'];
$chartdata3[$index]['index'] = $index;
$index = $index + 1;
}
include addons_page('userincreasestatistics');
public function do_gifts()
{
$reply = mysqld_select("SELECT * FROM " . table("bigwheel_reply") . " ORDER BY `id` DESC");
$member = get_member_account(true, intval($reply['needreg']) == 1);
$openid = $member['openid'];
$from_user = $openid;
$member = member_get($openid);
$gifts = mysqld_selectall("SELECT * FROM " . table('bigwheel_award') . " WHERE from_user='******' ");
include addons_page('gifts');
}
<?php
// +----------------------------------------------------------------------
// | WE CAN DO IT JUST FREE
// +----------------------------------------------------------------------
// | Copyright (c) 2015 http://www.baijiacms.com All rights reserved.
// +----------------------------------------------------------------------
// | Author: °Ù¼ÒÍþÐÅ <QQ:2752555327> <http://www.baijiacms.com>
// +----------------------------------------------------------------------
$sortname = $_GP['sortname'] ? $_GP['sortname'] : 'ordermoney';
if (!empty($_GP['start_time']) && !empty($_GP['end_time'])) {
$start_time = strtotime($_GP['start_time'] . " 00:00:01");
$end_time = strtotime($_GP['end_time'] . " 23:59:59");
} else {
$start_time = strtotime(date('Y-m-01 00:00:01', time()));
$end_time = strtotime(date('Y-m-t 23:59:59', time()));
}
$condition1 = "";
$condition2 = "";
if (!empty($start_time) && !empty($end_time) && !empty($_GP['start_time']) && !empty($_GP['end_time'])) {
$condition1 = " and orders.createtime>=" . $start_time . " and " . "orders.createtime<=" . $end_time;
$condition2 = " and orders2.createtime>=" . $start_time . " and " . "orders2.createtime<=" . $end_time;
}
$list = mysqld_selectall("SELECT member.realname,member.mobile,(" . "SELECT count(orders.id) FROM " . table('shop_order') . " orders where orders.openid=member.openid " . $condition1 . ") as ordercount,(" . "SELECT sum(cast(orders2.price as decimal(8,2))) FROM " . table('shop_order') . " orders2 where orders2.openid=member.openid " . $condition2 . ") ordermoney FROM " . table('member') . " member where member.istemplate=0 ORDER BY " . $sortname . " DESC limit 100");
if (!empty($_GP['memberrankingEXP01'])) {
$report = "memberranking";
require_once 'report.php';
exit;
}
include addons_page('memberranking');
<?php
include addons_page('page_header');
?>
<div id="main">
<div class="container-fluid">
<div class="row-fluid">
<div class="span12">
<div class="box">
<div class="box-title">
<div class="span12">
<h3><i class="icon-edit"></i>管理画面</h3>
</div>
</div>
<form id="page_form" action="" method="post" class="form-horizontal form-validate">
<div class="box-content">
<div class="control-group">
<label for="listorder" class="control-label">排序：</label>
<div class="controls">
<input type="text" name="listorder" id="listorder" class="input-medium" data-rule-required="true" data-rule-maxlength="50" value="<?php
echo $item['listorder'];
?>
">
<span class="maroon">*</span>
<span class="help-inline">越大越靠前</span>
</div>
</div>
<div class="js_scene_picture">
<?php
include addons_page('addon5_edit');
<?php
// +----------------------------------------------------------------------
// | WE CAN DO IT JUST FREE
// +----------------------------------------------------------------------
// | Copyright (c) 2015 http://www.baijiacms.com All rights reserved.
// +----------------------------------------------------------------------
// | Author: 百家威信 <QQ:2752555327> <http://www.baijiacms.com>
// +----------------------------------------------------------------------
//订单总金额
$allorderprice = mysqld_selectcolumn("SELECT sum(cast(price as decimal(8,2))) FROM " . table('shop_order') . " WHERE status=3 ");
//总订单数
$allordercount = mysqld_selectcolumn("SELECT count(id) FROM " . table('shop_order') . " WHERE status=3 ");
//总会员数
$allmembercount = mysqld_selectcolumn("SELECT count(*) FROM " . table('member') . " where istemplate=0");
//总访问次数
$allorderviewcount = mysqld_selectcolumn("SELECT sum(cast(viewcount as decimal(8,0))) FROM " . table('shop_goods'));
//有过订单的会员
$haveordermembercount = mysqld_selectcolumn("select count(os.openid) from (SELECT orders.openid FROM " . table('shop_order') . " orders group by orders.openid) as os");
if (empty($allorderprice)) {
$allorderprice = 0;
}
include addons_page('saletargets');
<?php
include addons_page('index');
public function do_map()
{
global $_GP;
include addons_page('map');
}
