(.*)<\/b>/";
}
preg_match($str, $content, $p);
if (is_array($p)) {
$pages = explode("/", $p[1]);
return array('totalpage' => $pages[1]);
}
return array('totalpage' => 0);
}
private function get_page_content($url = '', $pageNo = 1)
{
load()->func('communication');
if (empty($url)) {
return array("totalpage" => 0);
}
$url = $this->get_pageno_url($url, $pageNo);
$url = $this->getRealURL($url);
$response = ihttp_get($url);
if (!isset($response['content'])) {
return array("result" => 0);
}
return $response['content'];
}
private function get_pageno_url($url = '', $pageNo = 1)
{
$url .= "/search.htm?pageNo=" . $pageNo;
return $url;
}
private function getRealURL($url)
{
if (function_exists("stream_context_set_default")) {
stream_context_set_default(array('http' => array('method' => 'HEAD')));
}
$header = $this->get_url_headers($url, 1);
if (strpos($header[0], '301') || strpos($header[0], '302')) {
if (is_array($header['Location'])) {
return $header['Location'][count($header['Location']) - 1];
} else {
return $header['Location'];
}
} else {
return $url;
}
}
private function get_page_items($pageContent = '')
{
$str = '/data-id="(.*)"/U';
preg_match_all($str, $pageContent, $items);
if (isset($items[1])) {
return $items[1];
}
return array();
}
private function get_url_headers($url, $timeout = 10)
{
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_HEADER, true);
curl_setopt($ch, CURLOPT_NOBODY, true);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_TIMEOUT, $timeout);
$data = curl_exec($ch);
$data = preg_split('/\n/', $data);
$data = array_filter(array_map(function ($data) {
$data = trim($data);
if ($data) {
$data = preg_split('/:\s/', trim($data), 2);
$length = count($data);
switch ($length) {
case 2:
return array($data[0] => $data[1]);
break;
case 1:
return $data;
break;
default:
break;
}
}
}, $data));
sort($data);
foreach ($data as $key => $value) {
$arrt = array_keys($value);
$itemKey = $arrt[0];
if (is_int($itemKey)) {
$data[$key] = $value[$itemKey];
} elseif (is_string($itemKey)) {
$data[$itemKey] = $value[$itemKey];
unset($data[$key]);
}
}
return $data;
}
private function getCollectionType($type)
{
$types = array(0 => '试用采集', 1 => '会员采集', 2 => '导入分销', 3 => '导出信息', 4 => '用户登录', 5 => '更新会员', 6 => '新增会员');
return $types[intval($type)];
}
private function getStockType($stock)
{
$status = pdo_fetch("select status from " . tablename('wwx_fxxt_shop_collection_status') . " where stock='{$stock}' limit 1 ");
if (!empty($status)) {
$for = "label-danger";
} else {
$for = "label-success";
}
return $for;
}
private function getStatusType($stock)
{
$status = pdo_fetch("select status from " . tablename('wwx_fxxt_shop_collection_status') . " where stock='{$stock}' limit 1 ");
if (!empty($status)) {
$for = $status['status'];
} else {
$for = 0;
}
return $for;
}
protected function redauth()
{
global $_W;
session_start();
$openid = $_SESSION['__:proxy:openid'];
require_once WWX_FXXT_ROOT . '/class/Fans.class.php';
$f = new Fans();
if (!empty($openid)) {
$exists = $f->getOne($openid, true);
if (!empty($exists)) {
return $exists;
}
}
$api = $this->module['config']['api'];
if (empty($api)) {
message('活动还未开放，商家没有配置好API');
}
$modulePublic = '../addons/wwx_fxxt/style/static/';
require_once WWX_FXXT_ROOT . '/class/Activity.class.php';
$forceSubscribe = true;
$openid = $this->getFromUser();
if (!empty($openid) && strlen($openid) > 10) {
$fans = pdo_fetch('SELECT fans.openid openid, fans.follow follow, member.* FROM ' . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member WHERE fans.uniacid = :uniacid AND fans.openid = :openid AND fans.uid=member.uid LIMIT 1", array(':uniacid' => $_W['uniacid'], ':openid' => $openid));
if (is_array($fans) && !empty($fans['openid'])) {
$user = array();
$user['uniacid'] = $_W['uniacid'];
$user['openid'] = $fans['openid'];
$user['nickname'] = $fans['nickname'];
$user['gender'] = $fans['gender'];
$user['city'] = $fans['residecity'];
$user['state'] = $fans['resideprovince'];
$user['avatar'] = $fans['avatar'];
$user['country'] = $fans['nationality'];
$f->save($user);
$_SESSION['__:proxy:openid'] = $user['openid'];
}
}
$exists = $f->getOne($openid, true);
if (!empty($exists)) {
return $exists;
}
}
protected function prepareActivity($activity, $verifyParams = array())
{
if (empty($activity)) {
return error(-1, '访问错误
');
}
if (is_error($activity)) {
return $activity;
}
if ($activity['start'] > TIMESTAMP) {
return error(-2, '不要着急, 活动还未开始, 敬请期待
本次活动时间为:
' . date('Y-m-d H:i', $activity['start']) . '
' . date('Y-m-d H:i', $activity['end']) . '
');
}
if ($activity['end'] < TIMESTAMP) {
return error(-2, '手慢了, 本次活动已经结束, 请关注我们期待下次活动
本次活动时间为:
' . date('Y-m-d H:i', $activity['start']) . '
' . date('Y-m-d H:i', $activity['end']) . '
');
}
if (!empty($activity['limit'])) {
if (!empty($activity['limit']['range']) && !empty($verifyParams['user'])) {
$valid = false;
$pieces = explode(';', $activity['limit']['range']);
if (is_array($pieces)) {
foreach ($pieces as $district) {
if ($valid) {
break;
}
$district = trim($district);
$districts = explode('-', $district);
$area = array();
$area['state'] = trim($districts[0]);
$area['city'] = trim($districts[1]);
if (!empty($area['state']) && !empty($area['city'])) {
if ($area['state'] == $verifyParams['user']['state'] && $area['city'] == $verifyParams['user']['city']) {
$valid = true;
}
} elseif (!empty($area['state'])) {
if ($area['state'] == $verifyParams['user']['state']) {
$valid = true;
}
}
}
}
if (!$valid) {
return error(-3, "你的位置是: {$verifyParams['range']['state']}-{$verifyParams['range']['city']}
不在本次活动范围. 请关注并期待我们下一次活动
");
}
}
if (!empty($activity['limit']['gender']) && !empty($verifyParams['user'])) {
if ($activity['limit']['gender'] != $verifyParams['user']['gender']) {
return error(-3, "抱歉哦: 本次活动只在 {$activity['limit']['gender']} 性朋友范围内举行
");
}
}
if (!empty($activity['limit']['amount'])) {
if ($activity['amount'] >= $activity['limit']['amount']) {
return error(-4, "哎呀, 手慢了. 本次活动所有红包已发完
本次活动已经结束, 请关注我们期待下一次活动
");
}
}
}
if ($activity['type'] == 'game') {
if ($activity['tag']['pool'] <= $activity['tag']['threshold']) {
return error(-4, "哎呀, 手慢了. 本次活动所有红包已发完
本次活动已经结束, 请关注我们期待下一次活动
");
}
}
return $activity;
}
public function checkSubscribe()
{
global $_W;
session_start();
if (empty($_W['openid']) || empty($_W['acid'])) {
return false;
}
if (empty($_SESSION['__:subscribe'])) {
$account = WeAccount::create($_W['acid']);
if (!empty($account)) {
$ainfo = $account->fetchAccountInfo();
if (!empty($ainfo['secret']) && !empty($ainfo['key'])) {
$fans = $account->fansQueryInfo($_W['openid']);
if (!is_error($fans) && !empty($fans) && !empty($fans['subscribe'])) {
$_SESSION['__:subscribe'] = true;
return true;
}
} else {
$_SESSION['__:subscribe'] = true;
return true;
}
}
} else {
return true;
}
return false;
}
protected function redsend($activity, $record, $user)
{
global $_W,$_GPC;
load()->func('communication');
$uniacid = $_W['uniacid'];
$api = $this->module['config']['api'];
if (empty($api)) {
return error(-2, '系统还未开放');
}
require_once WWX_FXXT_ROOT . '/class/Activity.class.php';
require_once WWX_FXXT_ROOT . '/class/Gift.class.php';
$a = new Activity();
if (empty($record) || $record['status'] == 'complete') {
return error(-1, '没有获得现金红包或已经领取过这个现金红包了');
}
$g = new Gift();
$gift = $g->getOne($record['gift']);
if (empty($gift) && $gift['type'] != 'cash') {
return error(-1, '没有获得现金红包');
}
$fee = floatval($record['fee']) * 100;
$url = 'https://api.mch.weixin.qq.com/mmpaymkttransfers/sendredpack';
$pars = array();
$pars['nonce_str'] = random(32);
$pars['mch_billno'] = $api['api_QrCode'] . date('Ymd') . sprintf('%010d', $record['id']);
$pars['mch_id'] = $api['api_QrCode'];
$pars['wxappid'] = $api['api_appid'];
//$pars['nick_name'] = $gift['tag']['provider'];
//$pars['send_name'] = $gift['tag']['provider'];
$pars['send_name'] =$_GPC['shopname'];
$pars['re_openid'] = $user['openid'];
$pars['total_amount'] = $fee;
//$pars['min_value'] = $pars['total_amount'];
//$pars['max_value'] = $pars['total_amount'];
$pars['total_num'] = 1;
$pars['wishing'] = $gift['tag']['wish'];
$pars['client_ip'] = $api['api_ip'];
$pars['act_name'] = $activity['title'];
$pars['remark'] = $gift['tag']['remark'];
//$pars['logo_imgurl'] = tomedia($gift['tag']['image']);
//$pars['share_content'] = $gift['tag']['content'];
//$pars['share_imgurl'] = tomedia($gift['tag']['image']);
//$pars['share_url'] = $_W['siteroot'] . 'app/' . substr($this->createMobileUrl('redentry', array('owner' => $user['uid'], 'actid' => $activity['actid'])), 2);
ksort($pars, SORT_STRING);
$string1 = '';
foreach ($pars as $k => $v) {
$string1 .= "{$k}={$v}&";
}
$string1 .= "key={$api['api_QrKey']}";
$pars['sign'] = strtoupper(md5($string1));
$xml = array2xml($pars);
$extras = array();
$extras['CURLOPT_CAINFO'] = WWX_FXXT_ROOT . '/cert/rootca.pem.' . $uniacid;
$extras['CURLOPT_SSLCERT'] = WWX_FXXT_ROOT . '/cert/apiclient_cert.pem.' . $uniacid;
$extras['CURLOPT_SSLKEY'] = WWX_FXXT_ROOT . '/cert/apiclient_key.pem.' . $uniacid;
$procResult = null;
$resp = ihttp_request($url, $xml, $extras);
if (is_error($resp)) {
$procResult = $resp;
} else {
$xml = '' . $resp['content'];
$dom = new \DOMDocument();
if ($dom->loadXML($xml)) {
$xpath = new \DOMXPath($dom);
$code = $xpath->evaluate('string(//xml/return_code)');
$ret = $xpath->evaluate('string(//xml/result_code)');
if (strtolower($code) == 'success' && strtolower($ret) == 'success') {
$procResult = true;
} else {
$error = $xpath->evaluate('string(//xml/err_code_des)');
$procResult = error(-2, $error);
}
} else {
$procResult = error(-1, 'error response');
}
}
if (is_error($procResult)) {
$filters = array();
$filters['uniacid'] = $uniacid;
$filters['id'] = $record['id'];
$rec = array();
$rec['log'] = $procResult['message'];
pdo_update('wwx_fxxt_red_records', $rec, $filters);
return $procResult;
} else {
$a->confirm($record['id'], sprintf('%.2f', $fee / 100));
return true;
}
}
protected function wxsend($user)
{
global $_W;
load()->func('communication');
$uniacid = $_W['uniacid'];
$api = $this->module['config']['api'];
if (empty($api)) {
return error(-2, '系统还未开放');
}
$fee = floatval($user['fee']) * 100;
$url = 'https://api.mch.weixin.qq.com/mmpaymkttransfers/promotion/transfers';
$pars = array();
$pars['mch_appid'] = $api['api_appid'];
$pars['mchid'] = $api['api_QrCode'];
$pars['nonce_str'] = random(32);
$pars['partner_trade_no'] = $api['api_QrCode'] . date('YmdHi') . random(6, 1);
$pars['openid'] = $user['openid'];
$pars['check_name'] = 'NO_CHECK';
$pars['re_user_name'] = $user['realname'];
$pars['amount'] = $fee;
$pars['desc'] = $user['desc'];
$pars['spbill_create_ip'] = $api['api_ip'];
ksort($pars, SORT_STRING);
$string1 = '';
foreach ($pars as $k => $v) {
$string1 .= "{$k}={$v}&";
}
$string1 .= "key={$api['api_QrKey']}";
$pars['sign'] = strtoupper(md5($string1));
$xml = array2xml($pars);
$extras = array();
$extras['CURLOPT_CAINFO'] = WWX_FXXT_ROOT . '/cert/rootca.pem.' . $uniacid;
$extras['CURLOPT_SSLCERT'] = WWX_FXXT_ROOT . '/cert/apiclient_cert.pem.' . $uniacid;
$extras['CURLOPT_SSLKEY'] = WWX_FXXT_ROOT . '/cert/apiclient_key.pem.' . $uniacid;
$procResult = null;
$resp = ihttp_request($url, $xml, $extras);
if (is_error($resp)) {
$procResult = $resp;
} else {
$xml = '' . $resp['content'];
$dom = new \DOMDocument();
if ($dom->loadXML($xml)) {
$xpath = new \DOMXPath($dom);
$code = $xpath->evaluate('string(//xml/return_code)');
$ret = $xpath->evaluate('string(//xml/result_code)');
if (strtolower($code) == 'success' && strtolower($ret) == 'success') {
$procResult = true;
} else {
$error = $xpath->evaluate('string(//xml/err_code_des)');
$procResult = error(-2, $error);
}
} else {
$procResult = error(-1, 'error response');
}
}
if (is_error($procResult)) {
return $procResult;
} else {
return true;
}
}
public function getDzdid($dzduid = 0)
{
global $_W;
if (!empty($dzduid)) {
return $dzduid;
}
return $_COOKIE['dzdid_' . WWX_FXXT_VERSION . $_W['uniacid']];
}
public function isDzdMode($profile, $dzduid = 0)
{
global $_W;
if (empty($profile['id'])) {
$profile = $this->getProfile();
}
if (!empty($dzduid)) {
if ($profile['id'] == $dzduid) {
return true;
}
if ($dzduid == -1) {
$theone = pdo_fetch('SELECT ischeck FROM ' . tablename('wwx_fxxt_rules') . ' WHERE uniacid = :uniacid', array(':uniacid' => $_W['uniacid']));
if ($profile['dzdflag'] == 1 && $profile['flag'] == 1 && $theone['ischeck'] == 2) {
return true;
}
return false;
}
if ($profile['id'] != $dzduid) {
return false;
}
}
if (!empty($_COOKIE['dzdid_' . WWX_FXXT_VERSION . $_W['uniacid']])) {
if ($_COOKIE['dzdid_' . WWX_FXXT_VERSION . $_W['uniacid']] == $profile['id']) {
return true;
} else {
return false;
}
}
$theone = pdo_fetch('SELECT ischeck FROM ' . tablename('wwx_fxxt_rules') . ' WHERE uniacid = :uniacid', array(':uniacid' => $_W['uniacid']));
if ($profile['dzdflag'] == 1 && $profile['flag'] == 1 && $theone['ischeck'] == 2) {
return true;
}
return false;
}
public function getDzdname($id)
{
global $_W;
if ($_COOKIE['dzdid_' . WWX_FXXT_VERSION . $_W['uniacid']] == $id) {
return '我的小店';
}
if (!empty($_COOKIE['dzdid_' . WWX_FXXT_VERSION . $_W['uniacid']])) {
$users = $this->getMember($_COOKIE['dzdid_' . WWX_FXXT_VERSION . $_W['uniacid']]);
if (!empty($users['dzdtitle'])) {
return $users['dzdtitle'];
}
}
return $_W['account']['name'];
}
private function getFromFlagID($from_user)
{
global $_W;
$profile = pdo_fetch('SELECT id FROM ' . tablename('wwx_fxxt_member') . " WHERE uniacid = :uniacid AND from_user = :from_user", array(':uniacid' => $_W['uniacid'], ':from_user' => $from_user));
if (!empty($profile['id'])) {
return $profile['id'];
} else {
return 0;
}
}
private function getFromAddress($username)
{
global $_W;
$address = pdo_fetchall("SELECT id FROM " . tablename('wwx_fxxt_address') . " WHERE (realname LIKE '%{$username}%' OR mobile LIKE '%{$username}%') AND uniacid = " . $_W['uniacid']);
if (!empty($address)) {
return $address;
} else {
return '';
}
}
private function getFromDate($time)
{
$time = date('Y-m-d H:i:s', $time);
$str = str_replace(chr(32), "
", $time);
return $str;
}
private function getFromflagsum($from_user, $cun = 1)
{
global $_W;
$cfg = $this->module['config'];
if (empty($from_user) && $cun == 10) {
return array('count_huiyuan_1' => 0, 'count_huiyuan_2' => 0, 'count_huiyuan_3' => 0, 'commissionTotal' => 0, 'priceTotal' => 0, 'count_daili_1' => 0, 'count_daili_2' => 0, 'count_daili_3' => 0, 'followcount' => 0, 'huiyuan_zong' => 0, 'daili_zong' => 0, 'huiyuan_daili' => 0);
}
if (empty($from_user)) {
return 0;
}
$profile = pdo_fetch('SELECT id FROM ' . tablename('wwx_fxxt_member') . " WHERE uniacid = :uniacid AND from_user = :from_user", array(':uniacid' => $_W['uniacid'], ':from_user' => $from_user));
if (empty($profile['id']) && $cun == 10) {
return array('count_huiyuan_1' => 0, 'count_huiyuan_2' => 0, 'count_huiyuan_3' => 0, 'commissionTotal' => 0, 'priceTotal' => 0, 'count_daili_1' => 0, 'count_daili_2' => 0, 'count_daili_3' => 0, 'followcount' => 0, 'huiyuan_zong' => 0, 'daili_zong' => 0, 'huiyuan_daili' => 0);
}
if (empty($profile['id'])) {
return 0;
}
$count_huiyuan_1 = 0;
$count_huiyuan_2 = 0;
$count_huiyuan_3 = 0;
$commissionTotal = 0;
$priceTotal = 0;
$count_daili_1 = 0;
$count_daili_2 = 0;
$count_daili_3 = 0;
$followcount = 0;
$huiyuan_zong = 0;
$daili_zong = 0;
$huiyuan_daili = 0;
$sql1_member = "select mber1.from_user from " . tablename('wwx_fxxt_member') . " mber1 where mber1.realname<>'' and mber1.id!=mber1.shareid and mber1.shareid = " . $profile['id'];
$followcount = pdo_fetchcolumn("select count(*) from " . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member where fans.follow=1 and fans.openid!='{$from_user}' and ( fans.openid in (" . $sql1_member . ") ) and fans.uid=member.uid and fans.uniacid={$_W['uniacid']} ");
if ($cun == 9) {
return $followcount;
}
$count1 = pdo_fetchcolumn(" select count(*) from " . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member, " . tablename('wwx_fxxt_member') . " member2 where fans.openid!='{$from_user}' and ( fans.openid in (" . $sql1_member . " and mber1.flag=0) ) and fans.uid=member.uid and fans.openid=member2.from_user and fans.uniacid={$_W['uniacid']}");
$count1_1 = pdo_fetchcolumn(" select count(*) from " . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member, " . tablename('wwx_fxxt_member') . " member2 where fans.openid!='{$from_user}' and ( fans.openid in (" . $sql1_member . " and mber1.flag=1) ) and fans.uid=member.uid and fans.openid=member2.from_user and fans.uniacid={$_W['uniacid']}");
$commission1_1 = pdo_fetchcolumn("SELECT sum((g.commission*g.total)) FROM " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid WHERE o.shareid=" . $profile['id'] . " and o.uniacid = " . $_W['uniacid'] . " and o.status = 3 and o.from_user != '{$from_user}' and g.createtime>='{$profile['flagtime']}'");
$price1_1 = pdo_fetchcolumn("SELECT sum(price) FROM " . tablename('wwx_fxxt_order') . " WHERE shareid=" . $profile['id'] . " and uniacid = " . $_W['uniacid'] . " and status = 3 and from_user != '{$from_user}' and createtime>='{$profile['flagtime']}'");
if ($cfg['globalCommissionLevel'] >= 2) {
$level2 = "select level2m.id from " . tablename('wwx_fxxt_member') . " level2m where level2m.id!=level2m.shareid and level2m.shareid = " . $profile['id'];
$sql2_member = "select mber2.from_user from " . tablename('wwx_fxxt_member') . " mber2 where mber2.realname<>'' and mber2.id!=mber2.shareid and mber2.shareid in (" . $level2 . ") ";
$count2 = pdo_fetchcolumn(" select count(*) from " . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member, " . tablename('wwx_fxxt_member') . " member2 where fans.openid!='{$from_user}' and ( fans.openid in (" . $sql2_member . " and mber2.flag=0)) and (fans.openid not in (" . $sql1_member . " and mber1.flag=0) ) and fans.uid=member.uid and fans.openid=member2.from_user and fans.uniacid={$_W['uniacid']}");
$count2_1 = pdo_fetchcolumn(" select count(*) from " . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member, " . tablename('wwx_fxxt_member') . " member2 where fans.openid!='{$from_user}' and ( fans.openid in (" . $sql2_member . " and mber2.flag=1)) and (fans.openid not in (" . $sql1_member . " and mber1.flag=1) ) and fans.uid=member.uid and fans.openid=member2.from_user and fans.uniacid={$_W['uniacid']}");
$commission2_1 = pdo_fetchcolumn("SELECT sum((g.commission2*g.total)) FROM " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid WHERE o.shareid2=" . $profile['id'] . " and o.uniacid = " . $_W['uniacid'] . " and o.status = 3 and o.from_user != '{$from_user}' and g.createtime>='{$profile['flagtime']}'");
$price2_1 = pdo_fetchcolumn("SELECT sum(price) FROM " . tablename('wwx_fxxt_order') . " WHERE shareid2=" . $profile['id'] . " and uniacid = " . $_W['uniacid'] . " and status = 3 and from_user != '{$from_user}' and createtime>='{$profile['flagtime']}'");
} else {
$str = 0;
}
if ($cfg['globalCommissionLevel'] >= 3) {
$level3 = "select level3m.id from " . tablename('wwx_fxxt_member') . " level3m where level3m.id!=level3m.shareid and level3m.shareid in( " . $level2 . ")";
$sql3_member = "select mber3.from_user from " . tablename('wwx_fxxt_member') . " mber3 where mber3.realname<>'' and mber3.id!=mber3.shareid and mber3.shareid in (" . $level3 . ") ";
$count3 = pdo_fetchcolumn(" select count(*) from " . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member, " . tablename('wwx_fxxt_member') . " member2 where fans.openid!='{$from_user}' and (fans.openid in (" . $sql3_member . " and mber3.flag=0)) and (fans.openid not in (" . $sql1_member . " and mber1.flag=0)) and (fans.openid not in (" . $sql2_member . " and mber2.flag=0)) and fans.uid=member.uid and fans.openid=member2.from_user and fans.uniacid={$_W['uniacid']}");
$count3_1 = pdo_fetchcolumn(" select count(*) from " . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member, " . tablename('wwx_fxxt_member') . " member2 where fans.openid!='{$from_user}' and (fans.openid in (" . $sql3_member . " and mber3.flag=1)) and (fans.openid not in (" . $sql1_member . " and mber1.flag=1)) and (fans.openid not in (" . $sql2_member . " and mber2.flag=1)) and fans.uid=member.uid and fans.openid=member2.from_user and fans.uniacid={$_W['uniacid']}");
$commission3_1 = pdo_fetchcolumn("SELECT sum((g.commission3*g.total)) FROM " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid WHERE o.shareid3=" . $profile['id'] . " and o.uniacid = " . $_W['uniacid'] . " and o.status = 3 and o.from_user != '{$from_user}' and g.createtime>='{$profile['flagtime']}'");
$price3_1 = pdo_fetchcolumn("SELECT sum(price) FROM " . tablename('wwx_fxxt_order') . " WHERE shareid3=" . $profile['id'] . " and uniacid = " . $_W['uniacid'] . " and status = 3 and from_user != '{$from_user}' and createtime>='{$profile['flagtime']}'");
} else {
$str3 = 0;
}
$count_huiyuan_1 = $count1;
$count_huiyuan_2 = $count2;
$count_huiyuan_3 = $count3;
$commissionTotal = $commission1_1 + $commission2_1 + $commission3_1;
$priceTotal = $price1_1 + $price2_1 + $price3_1;
$count_daili_1 = $count1_1;
$count_daili_2 = $count2_1;
$count_daili_3 = $count3_1;
$huiyuan_zong = $count1 + $count2 + $count3;
$daili_zong = $count1_1 + $count2_1 + $count3_1;
$huiyuan_daili = $huiyuan_zong + $daili_zong;
$zong = array('count_huiyuan_1' => $count_huiyuan_1, 'count_huiyuan_2' => $count_huiyuan_2, 'count_huiyuan_3' => $count_huiyuan_3, 'commissionTotal' => $commissionTotal, 'priceTotal' => $priceTotal, 'count_daili_1' => $count_daili_1, 'count_daili_2' => $count_daili_2, 'count_daili_3' => $count_daili_3, 'followcount' => $followcount, 'huiyuan_zong' => $huiyuan_zong, 'daili_zong' => $daili_zong, 'huiyuan_daili' => $huiyuan_daili);
if ($cun == 1) {
return $count_huiyuan_1;
} elseif ($cun == 2) {
return $count_huiyuan_2;
} elseif ($cun == 3) {
return $count_huiyuan_3;
} elseif ($cun == 4) {
return $commissionTotal;
} elseif ($cun == 5) {
return $priceTotal;
} elseif ($cun == 6) {
return $count_daili_1;
} elseif ($cun == 7) {
return $count_daili_2;
} elseif ($cun == 8) {
return $count_daili_3;
} elseif ($cun == 10) {
return $zong;
} elseif ($cun == 11) {
return $huiyuan_zong;
} elseif ($cun == 12) {
return $daili_zong;
} elseif ($cun == 13) {
return $huiyuan_daili;
} else {
return 0;
}
}
private function getFromordersum($id = '', $from_user = '')
{
global $_W;
if (!empty($from_user)) {
$profile = pdo_fetch('SELECT id FROM ' . tablename('wwx_fxxt_member') . " WHERE uniacid = :uniacid AND from_user = :from_user", array(':uniacid' => $_W['uniacid'], ':from_user' => $from_user));
$id = $profile['id'];
}
if (empty($id)) {
return 0;
}
$count = 0;
$count = pdo_fetchcolumn("select count(*) from " . tablename('wwx_fxxt_order') . " where uniacid = '{$_W['uniacid']}' AND (shareid = '{$id}' or shareid2 = '{$id}' or shareid3 = '{$id}') ");
return $count;
}
private function getFromUserOrderSum($id = '', $from_user = '')
{
global $_W;
if (!empty($id)) {
$profile = pdo_fetch('SELECT from_user FROM ' . tablename('wwx_fxxt_member') . " WHERE uniacid = :uniacid AND id = :id", array(':uniacid' => $_W['uniacid'], ':id' => $id));
$from_user = $profile['from_user'];
}
if (empty($from_user)) {
return 0;
}
$count = 0;
$count = pdo_fetchcolumn("select count(*) from " . tablename('wwx_fxxt_order') . " where uniacid = '{$_W['uniacid']}' AND from_user = '{$from_user}' ");
return $count;
}
public function autocancelorder($needcheck = false)
{
global $_W;
if (empty($_COOKIE['ordercancel_' . WWX_FXXT_VERSION . $_W['uniacid']]) || $needcheck == true) {
$settings = $this->module['config'];
if (!empty($settings['ordertime']) && intval($settings['ordertime']) > 0) {
$rules = pdo_fetch('SELECT autocanceltime FROM ' . tablename('wwx_fxxt_rules') . ' WHERE uniacid = :uniacid', array(':uniacid' => $_W['uniacid']));
if (empty($rules['autocanceltime']) || intval($rules['autocanceltime']) <= TIMESTAMP) {
$autocanceltime = time() - intval($settings['ordertime']) * 60;
$orders = pdo_fetchall('SELECT * FROM ' . tablename('wwx_fxxt_order') . ' where status=0 and paytype<>3 and createtime<:createtime and uniacid = :uniacid', array(':uniacid' => $_W['uniacid'], ':createtime' => $autocanceltime));
foreach ($orders as $order) {
pdo_delete('wwx_fxxt_order', array('status' => 0, 'uniacid' => $_W['uniacid'], 'id' => $order['id']));
}
pdo_update('wwx_fxxt_rules', array('autocanceltime' => TIMESTAMP + 10 * 60), array('uniacid' => $_W['uniacid']));
}
}
if ($needcheck == false) {
setcookie('ordercancel_' . WWX_FXXT_VERSION . $_W['uniacid'], 1, TIMESTAMP + 5 * 60);
}
}
}
private function getFromNoticeeMail($noticee)
{
global $_W;
load()->func('communication');
if (!empty($this->module['config']['noticeemail']) || !empty($noticee)) {
$address = pdo_fetch("SELECT * FROM " . tablename('wwx_fxxt_address') . " WHERE id = :id", array(':id' => $noticee['addressid']));
$body = "购买商品清单
";
if (!empty($noticee['bodygoods'])) {
$body .= $noticee['bodygoods'];
}
$body .= "
总金额：{$noticee['price']}元 （货到付款）
";
$body .= "购买用户详情
";
$body .= "真实姓名：{$address[realname]}
";
$body .= "地区：{$address[province]} - {$address[city]} - {$address[area]}
";
$body .= "详细地址：{$address[address]}
";
$body .= "手机：{$address[mobile]}
";
ihttp_email($this->module['config']['noticeemail'], "{$_W['account']['name']}商城订单提醒", $body);
}
}
private function getFansSum($id)
{
global $_W;
$condition = '';
$list = pdo_fetch("SELECT * FROM " . tablename('wwx_fxxt_member_shipgrade') . " WHERE id = '{$id}'");
$condition .= " AND (tb.price >= '" . $list['member_turnover'] . "' OR tb.orsum >= '" . $list['member_motercount'] . "')";
if ($list['promoterstate'] == 1) {
$status .= " AND orders.status = 3 ";
} else {
$status .= " AND orders.status > 0 ";
}
$membercount = pdo_fetchcolumn("SELECT count(member.id) from " . tablename('wwx_fxxt_member') . " member WHERE member.uniacid = '{$_W['uniacid']}' and member.from_user in (SELECT tb.from_user FROM (SELECT orders.uniacid as uniacid,orders.from_user as from_user,sum(orders.price) as price,count(orders.id) as orsum FROM " . tablename('wwx_fxxt_order') . " orders WHERE orders.uniacid = '{$_W['uniacid']}' {$status} group by orders.from_user) tb where tb.uniacid = '{$_W['uniacid']}' {$condition} group by tb.from_user)");
return $membercount;
}
private function getFansZongSum($id)
{
global $_W;
$membercount = pdo_fetchcolumn("SELECT count(id) FROM " . tablename('wwx_fxxt_member') . " WHERE uniacid = '{$_W['uniacid']}' and usergrade = '{$id}'");
return $membercount;
}
private function getFlagSum($id)
{
global $_W;
$condition = '';
$list = pdo_fetch("SELECT * FROM " . tablename('wwx_fxxt_member_flaggrade') . " WHERE id = '{$id}'");
if ($list['promoterstate'] == 1) {
$status .= " AND orders.status = 3 AND (orders.shareid = member.id or orders.shareid2 = member.id or orders.shareid3 = member.id)";
} else {
$status .= " AND orders.status > 0 AND (orders.shareid = member.id or orders.shareid2 = member.id or orders.shareid3 = member.id)";
}
$membercount = pdo_fetchcolumn("SELECT count(member.id) from " . tablename('wwx_fxxt_member') . " member WHERE member.uniacid = '{$_W['uniacid']}' and (member.zhifu >= '{$list['flag_money']}' OR (SELECT sum(orders.price) as price FROM " . tablename('wwx_fxxt_order') . " orders WHERE orders.uniacid = '{$_W['uniacid']}' {$status} group by orders.uniacid) >= '{$list['flag_totalmoney']}' OR (SELECT count(member.id) as memsum FROM " . tablename('wwx_fxxt_member') . " member2 WHERE member2.uniacid = '{$_W['uniacid']}' AND member2.shareid = member.id group by member2.uniacid) >= '{$list['flag_count']}')");
return $membercount;
}
private function getFlagZongSum($id)
{
global $_W;
$membercount = pdo_fetchcolumn("SELECT count(id) FROM " . tablename('wwx_fxxt_member') . " WHERE uniacid = '{$_W['uniacid']}' and flaggrade = '{$id}'");
return $membercount;
}
private function autouserflag($profile)
{
global $_W;
$cfg = $this->module['config'];
if (!empty($profile) && $profile['flag'] == 1) {
$flagcount = $this->getFromflagsum($profile['from_user'], 13);
if (!empty($flagcount)) {
pdo_update('wwx_fxxt_member', array('flagcount' => $flagcount), array('uniacid' => $_W['uniacid'], 'from_user' => $profile['from_user']));
}
}
if (!empty($profile) && $cfg['fansupgrade'] == 1) {
$condition = '';
if ($profile['usergradeauto'] == 0) {
$shipgrade = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_member_shipgrade') . " WHERE uniacid = '{$_W['uniacid']}'");
if (!empty($shipgrade)) {
foreach ($shipgrade as $ship) {
$condition .= " AND (tb.price >= '" . $ship['member_turnover'] . "' OR tb.orsum >= '" . $ship['member_motercount'] . "')";
if ($ship['promoterstate'] == 1) {
$status .= " AND orders.status = 3 AND orders.from_user = '{$profile['from_user']}'";
} else {
$status .= " AND orders.status > 0 AND orders.from_user = '{$profile['from_user']}'";
}
$membercount = pdo_fetchcolumn("SELECT count(member.id) from " . tablename('wwx_fxxt_member') . " member WHERE member.uniacid = '{$_W['uniacid']}' and member.from_user in (SELECT tb.from_user FROM (SELECT orders.uniacid as uniacid,orders.from_user as from_user,sum(orders.price) as price,count(orders.id) as orsum FROM " . tablename('wwx_fxxt_order') . " orders WHERE orders.uniacid = '{$_W['uniacid']}' {$status} group by orders.from_user) tb where tb.uniacid = '{$_W['uniacid']}' {$condition} group by tb.from_user)");
if (!empty($membercount)) {
pdo_update('wwx_fxxt_member', array('usergrade' => $ship['displayorder']), array('uniacid' => $_W['uniacid'], 'from_user' => $profile['from_user']));
}
}
}
}
}
if (!empty($profile) && $cfg['agentupgrade'] == 1) {
$condition = '';
if ($profile['flaggradeauto'] == 0) {
$flaggrade = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_member_flaggrade') . " WHERE uniacid = '{$_W['uniacid']}'");
if (!empty($flaggrade)) {
foreach ($flaggrade as $flag) {
if ($flag['promoterstate'] == 1) {
$status2 .= " AND orders.status = 3 AND (orders.shareid = '{$profile['id']}' or orders.shareid2 = '{$profile['id']}' or orders.shareid3 = '{$profile['id']}')";
} else {
$status2 .= " AND orders.status > 0 AND (orders.shareid = '{$profile['id']}' or orders.shareid2 = '{$profile['id']}' or orders.shareid3 = '{$profile['id']}')";
}
$membercount2 = pdo_fetchcolumn("SELECT count(member.id) from " . tablename('wwx_fxxt_member') . " member WHERE member.uniacid = '{$_W['uniacid']}' and (member.zhifu >= '{$flag['flag_money']}' OR (SELECT sum(orders.price) as price FROM " . tablename('wwx_fxxt_order') . " orders WHERE orders.uniacid = '{$_W['uniacid']}' {$status2} group by orders.uniacid) >= '{$flag['flag_totalmoney']}' OR {$profile['flagcount']} >= {$flag['flag_count']}) AND member.id = '{$profile['id']}'");
if (!empty($membercount2)) {
pdo_update('wwx_fxxt_member', array('flaggrade' => $flag['displayorder']), array('uniacid' => $_W['uniacid'], 'from_user' => $profile['from_user']));
}
}
}
}
}
}
private function autouserInformation()
{
global $_W;
$index = 0;
$lists = pdo_fetchall("select * from " . tablename('wwx_fxxt_member') . " where uniacid = " . $_W['uniacid'] . " and status = 1");
if (!empty($lists)) {
foreach ($lists as $list) {
$this->autouserflag($list);
$index = $index + 1;
}
}
message('更新会员等级、代理等级、代理数量完成,成功处理' . $index . '个用户！', referer(), 'success');
}
public function doWebOrder()
{
global $_W, $_GPC;
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$cfg = $this->module['config'];
$operation = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
if ($operation == 'display') {
$pindex = max(1, intval($_GPC['page']));
$psize = 50;
$status = !isset($_GPC['status']) ? 1 : $_GPC['status'];
$sendtype = !isset($_GPC['sendtype']) ? 0 : $_GPC['sendtype'];
$condition = '';
$param_flagid = $_GPC['flagid'];
if (!empty($_GPC['flagid'])) {
$flagid = intval($_GPC['flagid']);
$flaguser = $this->getMember($flagid);
if (empty($flaguser)) {
message("没有此用户的任何信息，请重新查询！", referer(), 'error');
}
$condition .= " AND (shareid = '" . $flagid . "' or shareid2 = '" . $flagid . "' or shareid3 = '" . $flagid . "') AND createtime>=" . $flaguser['flagtime'] . " AND from_user<>'" . $flaguser['from_user'] . "'";
}
$param_userid = $_GPC['userid'];
if (!empty($_GPC['userid'])) {
$userid = intval($_GPC['userid']);
$useriduser = $this->getMember($userid);
if (empty($useriduser)) {
message("没有此用户的任何信息，请重新查询！", referer(), 'error');
}
$condition .= " AND from_user='" . $useriduser['from_user'] . "'";
}
$param_username = $_GPC['username'];
if (!empty($_GPC['username'])) {
$useraddress = $this->getFromAddress($_GPC['username']);
if (empty($useraddress)) {
message("没有此用户的任何订单，请重新查询！", referer(), 'error');
}
$condition .= " AND (1<>1";
foreach ($useraddress as $ress) {
$condition .= " OR addressid='" . intval($ress['id']) . "'";
}
$condition .= ")";
}
$param_ordersn = $_GPC['ordersn'];
if (!empty($_GPC['ordersn'])) {
$condition .= " AND ordersn LIKE '%{$_GPC['ordersn']}%'";
}
if (!empty($_GPC['cate_2'])) {
$cid = intval($_GPC['cate_2']);
$condition .= " AND ccate = '{$cid}'";
} elseif (!empty($_GPC['cate_1'])) {
$cid = intval($_GPC['cate_1']);
$condition .= " AND pcate = '{$cid}'";
}
if ($status == '3') {
$condition .= ' and ( status = 3 or status = -5 or status = -6)';
} else {
if ($status != '-99') {
$condition .= " AND status = '" . intval($status) . "'";
}
}
if (!empty($_GPC['from_user'])) {
$fromuser = pdo_fetch("select * from " . tablename('wwx_fxxt_member') . " where from_user = '" . $_GPC['from_user'] . "' and uniacid = " . $_W['uniacid']);
$condition .= " AND from_user = '{$_GPC['from_user']}'";
}
if (!empty($_GPC['shareid'])) {
$shareid = intval($_GPC['shareid']);
$user = $this->getMember($shareid);
$condition .= " AND (shareid = '" . $shareid . "' or shareid2 = '" . $shareid . "' or shareid3 = '" . $shareid . "') AND createtime>=" . $user['flagtime'] . " AND from_user<>'" . $user['from_user'] . "'";
}
if (!empty($sendtype)) {
$condition .= " AND sendtype = '" . intval($sendtype) . "' AND status != '3'";
}
if (checksubmit('sendbatexpress')) {
if (empty($_GPC['check'])) {
message('没有选择操作订单，请返回重新操作！', referer(), 'error');
}
foreach ($_GPC['check'] as $k) {
$isexpress = $_GPC['express' . $k];
if ($isexpress != '-1' && empty($_GPC['expressno' . $k])) {
message('有订单没有快递单号，请填写完整！');
}
}
$index = 0;
foreach ($_GPC['check'] as $k) {
$item = pdo_fetch('SELECT transid FROM ' . tablename('wwx_fxxt_order') . ' WHERE id = :id', array(':id' => $k));
$express = $_GPC['express' . $k];
if ($express == '-1') {
$express == '';
}
if (!empty($item['transid'])) {
$this->changeWechatSend($k, 1);
}
pdo_update('wwx_fxxt_order', array('status' => 2, 'sendtime' => TIMESTAMP, 'express' => $express, 'expresscom' => $_GPC['expresscom' . $k], 'expresssn' => $_GPC['expressno' . $k]), array('id' => $k));
$index = $index + 1;
}
message('批量发货操作完成,成功处理' . $index . '条订单', referer(), 'success');
}
if (!empty($_GPC['orderstatisticsEXP01'])) {
$report = 'orderstatistics';
$condition = '';
if (!empty($_GPC['flagid'])) {
$condition .= " AND (t1.shareid = " . $_GPC['flagid'] . " or t1.shareid2 = " . $_GPC['flagid'] . " or t1.shareid3 = " . $_GPC['flagid'] . ")";
}
if (!empty($_GPC['ordersn'])) {
$condition .= " AND t1.ordersn LIKE '%{$_GPC['ordersn']}%'";
}
if (!empty($_GPC['shareid'])) {
$shareid = $_GPC['shareid'];
$user = pdo_fetch('select * from ' . tablename('wwx_fxxt_member') . ' where id = ' . $shareid . ' and uniacid = ' . $_W['uniacid']);
$condition .= ' AND t1.shareid = \'' . intval($_GPC['shareid']) . '\' AND t1.createtime>=' . $user['flagtime'] . ' AND t1.from_user<>\'' . $user['from_user'] . '\'';
}
if ($status == '3') {
$condition .= ' and ( t1.status = 3 or t1.status = -5 or t1.status = -6)';
}else{
if($status != '-99'){
$condition .= ' AND t1.status = \'' . intval($status) . '\'';
}
}
if (!empty($_GPC['orderstatisticsEXP01'])) {
$psize = 9999;
$pindex = 1;
}
$list = pdo_fetchall('select t1.* from (SELECT orders.from_user,orders.zhifutime,orders.status,orders.sendtype,orders.uniacid,orders.id,orders.createtime,orders.ordersn,orders.price,orders.dispatchprice,orders.paytype,orders.shareid,(select member.realname from ' . tablename('wwx_fxxt_member') . ' member where member.from_user=orders.from_user and orders.uniacid=member.uniacid limit 1 ) realnamestr,(select taddress.realname from ' . tablename('wwx_fxxt_address') . ' taddress where taddress.id=orders.addressid and orders.uniacid=taddress.uniacid limit 1 ) tdrealname,(select concat(taddress.province,taddress.city,taddress.area,taddress.address) from ' . tablename('wwx_fxxt_address') . ' taddress where taddress.id=orders.addressid and orders.uniacid=taddress.uniacid limit 1 ) tdaddress,(select taddress.mobile from ' . tablename('wwx_fxxt_address') . ' taddress where taddress.id=orders.addressid and orders.uniacid=taddress.uniacid limit 1 ) tdmobile from ' . tablename('wwx_fxxt_order') . " orders where orders.uniacid = :uniacid {$conditionOrderStatus} order by orders.createtime desc) t1 where t1.uniacid = :uniacid {$condition} LIMIT " . ($pindex - 1) * $psize . ',' . $psize, array(':uniacid' => $_W['uniacid']));
foreach ($list as $id => $displayorder) {
$list[$id]['ordergoods'] = pdo_fetchall('SELECT (select category.name from' . tablename('wwx_fxxt_category') . ' category where (0=goods.ccate and category.id=goods.pcate) or (0!=goods.ccate and category.id=goods.ccate) ) as categoryname,(select category.sn from' . tablename('wwx_fxxt_category') . ' category where (0=goods.ccate and category.id=goods.pcate) or (0!=goods.ccate and category.id=goods.ccate) ) as categorysn,goods.thumb,ordersgoods.price,ordersgoods.total,goods.title,ordersgoods.optionname from ' . tablename('wwx_fxxt_order_goods') . ' ordersgoods left join ' . tablename('wwx_fxxt_goods') . ' goods on goods.id=ordersgoods.goodsid where ordersgoods.uniacid = :uniacid and ordersgoods.orderid=:oid order by ordersgoods.createtime desc ', array(':uniacid' => $_W['uniacid'], ':oid' => $list[$id]['id']));
}
require_once 'report.php';
die;
}
$list = pdo_fetchall('SELECT * FROM ' . tablename('wwx_fxxt_order') . " WHERE uniacid = '{$_W['uniacid']}' {$condition} ORDER BY createtime DESC LIMIT " . ($pindex - 1) * $psize . ',' . $psize);
$total = pdo_fetchcolumn('SELECT COUNT(*) FROM ' . tablename('wwx_fxxt_order') . " WHERE uniacid = '{$_W['uniacid']}' {$condition}");
$pager = pagination($total, $pindex, $psize);
if (!empty($list)) {
foreach ($list as $key => $l) {
$commissions = pdo_fetchall('select total,commission as commission, commission2 as commission2, commission3 as commission3 from ' . tablename('wwx_fxxt_order_goods') . ' where orderid = ' . $l['id']);
foreach ($commissions as $commission) {
$list[$key]['commission'] = $commission['commission'] * $commission['total'];
if ($cfg['globalCommissionLevel'] >= 2) {
$list[$key]['commission2'] = $commission['commission2'] * $commission['total'];
} else {
$list[$key]['commission2'] = 0;
}
if ($cfg['globalCommissionLevel'] >= 3) {
$list[$key]['commission3'] = $commission['commission3'] * $commission['total'];
} else {
$list[$key]['commission3'] = 0;
}
}
}
}
if (!empty($list)) {
foreach ($list as &$row) {
!empty($row['addressid']) && ($addressids[$row['addressid']] = $row['addressid']);
$row['dispatch'] = pdo_fetch("SELECT * FROM " . tablename('wwx_fxxt_dispatch') . " WHERE id = :id", array(':id' => $row['dispatch']));
}
unset($row);
}
if (!empty($addressids)) {
$address = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_address') . " WHERE id IN ('" . implode("','", $addressids) . "')", array(), 'id');
}
} elseif ($operation == 'detail') {
$members = pdo_fetchall('select id, realname from ' . tablename('wwx_fxxt_member'));
$member = array();
foreach ($members as $m) {
$member[$m['id']] = $m['realname'];
}
$id = intval($_GPC['id']);
$item = pdo_fetch("SELECT * FROM " . tablename('wwx_fxxt_order') . " WHERE id = :id", array(':id' => $id));
if (empty($item)) {
message("抱歉，订单不存在!", referer(), "error");
}
$membername = pdo_fetch("select id, realname from " . tablename('wwx_fxxt_member') . " where from_user = '" . $item['from_user'] . "' and uniacid = " . $_W['uniacid'] . " and status = 1");
$membersname1 = pdo_fetch("select id, realname, shareid from " . tablename('wwx_fxxt_member') . " where id = " . $item['shareid'] . " and uniacid = " . $_W['uniacid'] . " and status = 1");
if (empty($membersname1)) {
$membersname1['shareid'] = 0;
}
$membersname2 = pdo_fetch("select id, realname, shareid from " . tablename('wwx_fxxt_member') . " where id = " . $membersname1['shareid'] . " and uniacid = " . $_W['uniacid'] . " and status = 1");
if (empty($membersname2)) {
$membersname2['shareid'] = 0;
}
$membersname3 = pdo_fetch("select id, realname from " . tablename('wwx_fxxt_member') . " where id = " . $membersname2['shareid'] . " and uniacid = " . $_W['uniacid'] . " and status = 1");
if (checksubmit('confirmsend')) {
if (!empty($_GPC['isexpress']) && empty($_GPC['expresssn'])) {
message('请输入快递单号！');
}
$item = pdo_fetch("SELECT * FROM " . tablename('wwx_fxxt_order') . " WHERE id = :id", array(':id' => $id));
if (!empty($item['transid'])) {
$this->changeWechatSend($id, 1);
}
pdo_update('wwx_fxxt_order', array('status' => 2, 'remark' => $_GPC['remark'], 'express' => $_GPC['express'], 'expresscom' => $_GPC['expresscom'], 'expresssn' => $_GPC['expresssn'], 'sendtime' => TIMESTAMP), array('id' => $id));
message('发货操作成功！', referer(), 'success');
}
if (checksubmit('cancelsend')) {
$item = pdo_fetch("SELECT transid FROM " . tablename('wwx_fxxt_order') . " WHERE id = :id", array(':id' => $id));
if (!empty($item['transid'])) {
$this->changeWechatSend($id, 0, $_GPC['cancelreson']);
}
pdo_update('wwx_fxxt_order', array('status' => 1, 'remark' => $_GPC['remark'], 'express' => '', 'expresscom' => '', 'expresssn' => ''), array('id' => $id));
message('取消发货操作成功！', referer(), 'success');
}
if (checksubmit('finish')) {
$this->setOrderCredit($id, $_W['uniacid']);
pdo_update('wwx_fxxt_order', array('status' => 3, 'updatetime' => time(), 'remark' => $_GPC['remark']), array('id' => $id));
message('订单操作成功！', referer(), 'success');
}
if (checksubmit('cancelpay')) {
pdo_update('wwx_fxxt_order', array('status' => 0, 'remark' => $_GPC['remark']), array('id' => $id));
$this->setOrderStock($id, false);
message('取消订单付款操作成功！', referer(), 'success');
}
if (checksubmit('confrimpay')) {
pdo_update('wwx_fxxt_order', array('status' => 1, 'paytype' => 2, 'remark' => $_GPC['remark']), array('id' => $id));
$this->setOrderStock($id);
message('确认订单付款操作成功！', referer(), 'success');
}
if (checksubmit('beizhu')) {
pdo_update('wwx_fxxt_order', array('remark' => $_GPC['remark']), array('id' => $id));
message('订单备注操作成功！', referer(), 'success');
}
if (checksubmit('close')) {
$item = pdo_fetch("SELECT transid FROM " . tablename('wwx_fxxt_order') . " WHERE id = :id", array(':id' => $id));
if (!empty($item['transid'])) {
$this->changeWechatSend($id, 0, $_GPC['reson']);
}
pdo_update('wwx_fxxt_order', array('status' => -1, 'remark' => $_GPC['remark']), array('id' => $id));
message('订单关闭操作成功！', referer(), 'success');
}
if (checksubmit('open')) {
pdo_update('wwx_fxxt_order', array('status' => 0, 'remark' => $_GPC['remark']), array('id' => $id));
message('开启订单操作成功！', referer(), 'success');
}
if (checksubmit('cancelreturn')) {
$item = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_order') . ' WHERE id = :id', array(':id' => $id));
$ostatus = 3;
if ($item['status'] == -2) {
$ostatus = 1;
}
if ($item['status'] == -3) {
$ostatus = 3;
}
if ($item['status'] == -4) {
$ostatus = 3;
}
pdo_update('wwx_fxxt_order', array('status' => $ostatus), array('id' => $id));
message('退回操作成功！', referer(), 'success');
}
if (checksubmit('returnpay')) {
$item = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_order') . ' WHERE id = :id', array(':id' => $id));
if ($item['paytype'] == 3) {
message('货到付款订单不能进行退款操作!', referer(), 'error');
}
pdo_update('wwx_fxxt_order', array('status' => -6), array('id' => $id));
$this->setOrderStock($id, false);
$this->setMemberCredit2($item['from_user'], $item['price'], 'addgold', '订单:' . $item['ordersn'] . '退款返还余额');
message('退款操作成功！', referer(), 'success');
}
if (checksubmit('returngood')) {
$item = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_order') . ' WHERE id = :id', array(':id' => $id));
pdo_update('wwx_fxxt_order', array('status' => -5), array('id' => $id));
$this->setOrderStock($id, false);
$this->setOrderCredit($id, $_W['uniacid'], false);
$this->setMemberCredit2($item['from_user'], $item['price'], 'addgold', '订单:' . $item['ordersn'] . '退货返还余额');
message('退货操作成功！', referer(), 'success');
}
$dispatch = pdo_fetch("SELECT * FROM " . tablename('wwx_fxxt_dispatch') . " WHERE id = :id", array(':id' => $item['dispatch']));
if (!empty($dispatch) && !empty($dispatch['express'])) {
$express = pdo_fetch("select * from " . tablename('wwx_fxxt_express') . " WHERE id=:id limit 1", array(":id" => $dispatch['express']));
}
$item['user'] = pdo_fetch("SELECT * FROM " . tablename('wwx_fxxt_address') . " WHERE id = {$item['addressid']}");
$goods = pdo_fetchall("SELECT g.id,o.total,o.commission,o.commission2,o.commission3, g.title, g.status,g.thumb, g.unit,g.goodssn,g.productsn,g.marketprice,o.total,g.type,o.optionname,o.optionid,o.price as orderprice FROM " . tablename('wwx_fxxt_order_goods') . " o left join " . tablename('wwx_fxxt_goods') . " g on o.goodsid=g.id " . " WHERE o.orderid='{$id}'");
$item['goods'] = $goods;
}
if ($operation == 'normal_print') {
$id = intval($_GPC['print_orderid']);
$item = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_order') . ' WHERE id = :id', array(':id' => $id));
$address = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_address') . ' WHERE id = :id', array(':id' => $item['addressid']));
$pid = intval($_GPC['print_modle_id']);
$entry = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_printer') . ' WHERE id=:id', array(':id' => $pid));
$buyer = '';
$wwx_fxxt_member = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_member') . ' WHERE uniacid=:uniacid and from_user=:from_user', array(':uniacid' => $_W['uniacid'], ':from_user' => $item['from_user']));
$buyer = $wwx_fxxt_member['realname'];
if (empty($buyer)) {
$buyer = $address['realname'];
}
echo "
";
$previewtmp = $entry['printerconfig'];
for ($i = 1; $i < 3; $i++) {
$previewtmp = str_replace('{buyer}', $buyer, $previewtmp);
$previewtmp = str_replace('{consignee}', $address['realname'], $previewtmp);
$previewtmp = str_replace('{tel}', $address['mobile'], $previewtmp);
$previewtmp = str_replace('{address}', $address['province'] . $address['city'] . $address['area'] . $address['address'], $previewtmp);
$previewtmp = str_replace('{pay_type}', $item['paytype'] == 1 ? '余额支付' : ($item['paytype'] == 2 ? '在线支付' : ($item['paytype'] == 3 ? '货到付款' : '')), $previewtmp);
$previewtmp = str_replace('{dispatch_type}', $item['expresscom'], $previewtmp);
$previewtmp = str_replace('{dispatch_sn}', $item['expresssn'], $previewtmp);
$previewtmp = str_replace('{order_sn}', $item['ordersn'], $previewtmp);
$previewtmp = str_replace('{time}', date('Y-m-d H:i:s', $item['createtime']), $previewtmp);
$previewtmp = str_replace('{order_price}', $item['price'], $previewtmp);
$previewtmp = str_replace('{dispatch_price}', $item['dispatchprice'], $previewtmp);
$previewtmp = str_replace('{good_price}', $item['goodsprice'], $previewtmp);
$previewtmp = str_replace('{print_time}', date('Y-m-d H:i:s', time()), $previewtmp);
$good_line = '
| 商品名称 |
价格 |
数量 |
小计 |
';
$goods = pdo_fetchall('SELECT g.*,o.price as \'order_price\' ,o.total as \'order_total\',o.optionname as \'order_optionname\' FROM ' . tablename('wwx_fxxt_order_goods') . ' o left join ' . tablename('wwx_fxxt_goods') . ' g on o.goodsid=g.id ' . " WHERE o.orderid='{$id}'");
$goodsmoney = 0;
foreach ($goods as $good) {
$goodmoney = $good['order_price'] * $good['order_total'];
$goodsmoney = $goodsmoney + $goodmoney;
$good_line = $good_line . '
| ' . $good['title'] . ' ' . $good['order_optionname'] . ' |
￥' . $good['order_price'] . '元 |
' . $good['order_total'] . ' |
￥' . $goodmoney . '元 |
';
}
$good_line = $good_line . '
| 商品总金额：￥' . $goodsmoney . '元 |
';
$previewtmp = str_replace('{good_line}', $good_line, $previewtmp);
}
echo htmlspecialchars_decode($previewtmp);
echo '';
die;
}
if ($operation == 'express_print') {
$id = intval($_GPC['print_express_orderid']);
$item = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_order') . ' WHERE id = :id', array(':id' => $id));
$address = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_address') . ' WHERE id = :id', array(':id' => $item['addressid']));
$pid = intval($_GPC['print_modle_id']);
$entry = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_printer') . ' WHERE id=:id', array(':id' => $pid));
$buyer = '';
$wwx_fxxt_member = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_member') . ' WHERE uniacid=:uniacid and from_user=:from_user', array(':uniacid' => $_W['uniacid'], ':from_user' => $item['from_user']));
$buyer = $wwx_fxxt_member['realname'];
$previewtmp = $entry['printerconfig'];
if (!empty($entry['expressconfig'])) {
$t_expressconfig = iunserializer($entry['expressconfig']);
$entry['print_from_compy'] = $t_expressconfig['print_from_compy'];
$entry['print_from_uname'] = $t_expressconfig['print_from_uname'];
$entry['print_from_addr'] = $t_expressconfig['print_from_addr'];
$entry['print_from_tel'] = $t_expressconfig['print_from_tel'];
}
for ($i = 1; $i < 3; $i++) {
$previewtmp = str_replace('购货人', $buyer, $previewtmp);
$previewtmp = str_replace('收货姓名', $address['realname'], $previewtmp);
$previewtmp = str_replace('收货电话', $address['mobile'], $previewtmp);
$previewtmp = str_replace('收货地址', $address['province'] . $address['city'] . $address['area'] . $address['address'], $previewtmp);
$previewtmp = str_replace('支付方式', $item['paytype'] == 1 ? '余额支付' : ($item['paytype'] == 2 ? '在线支付' : ($item['paytype'] == 3 ? '货到付款' : '')), $previewtmp);
$previewtmp = str_replace('配送方式', $item['expresscom'], $previewtmp);
$previewtmp = str_replace('发货单号', $item['expresssn'], $previewtmp);
$previewtmp = str_replace('订单编号', $item['ordersn'], $previewtmp);
$previewtmp = str_replace('下单时间', date('Y-m-d H:i:s', $item['createtime']), $previewtmp);
$previewtmp = str_replace('订单金额', $item['price'], $previewtmp);
$previewtmp = str_replace('配送费用', $item['dispatchprice'], $previewtmp);
$previewtmp = str_replace('商品金额', $item['goodsprice'], $previewtmp);
$previewtmp = str_replace('打印时间', date('Y-m-d H:i:s', time()), $previewtmp);
$previewtmp = str_replace('寄件公司', $entry['print_from_compy'], $previewtmp);
$previewtmp = str_replace('寄件人', $entry['print_from_uname'], $previewtmp);
$previewtmp = str_replace('寄件地址', $entry['print_from_addr'], $previewtmp);
$previewtmp = str_replace('寄件电话', $entry['print_from_tel'], $previewtmp);
$previewtmp = str_replace('年', date('Y', time()), $previewtmp);
$previewtmp = str_replace('月', date('m', time()), $previewtmp);
$previewtmp = str_replace('日', date('d', time()), $previewtmp);
}
$onlyprint = true;
include $this->template('printer_express_print');
die;
}
$normal_order_list = pdo_fetchall('SELECT * FROM ' . tablename('wwx_fxxt_printer') . ' WHERE uniacid = :uniacid and printertype=0 order by isdefault desc', array(':uniacid' => $_W['uniacid']));
$express_order_list = pdo_fetchall('SELECT * FROM ' . tablename('wwx_fxxt_printer') . ' WHERE uniacid = :uniacid and printertype=1 order by isdefault desc', array(':uniacid' => $_W['uniacid']));
if (!empty($_GPC['dobatch'])) {
include $this->template('orderbat');
die;
}
include $this->template('order');
}
public function doWebCharge()
{
global $_GPC, $_W;
set_time_limit(0);
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$pindex = max(1, intval($_GPC['page']));
$psize = 50;
$uniacid = $_W['uniacid'];
$op = $operation = trim($_GPC['op']) ? trim($_GPC['op']) : 'list';
if ($op == 'list') {
if (!empty($_GPC['memberstatisticsEXP01'])) {
$report = 'memberstatistics';
$condition = '';
$gpmobile = $_GPC['mobile'];
$gprealname = $_GPC['realname'];
$gpuserid = $_GPC['userid'];
$gpflagid = $_GPC['flagid'];
$gpThecharts = $_GPC['Thecharts'];
$sql_member = "select count(order1.id) from " . tablename('wwx_fxxt_order') . " order1 where uniacid = '{$_W['uniacid']}' AND order1.from_user = flag.from_user ";
$condition .= empty($_GPC['mobile']) ? '' : " AND member.mobile LIKE '%" . trim($_GPC['mobile']) . "%'";
$condition .= empty($_GPC['realname']) ? '' : " AND (( member.realname LIKE '%" . trim($_GPC['realname']) . "%' ) OR ( member.nickname LIKE '%" . trim($_GPC['realname']) . "%' )) ";
$condition .= empty($_GPC['userid']) ? '' : " AND flag.id = '" . trim($_GPC['userid']) . "'";
$condition .= empty($_GPC['flagid']) ? '' : " AND flag.shareid = '" . trim($_GPC['flagid']) . "'";
$condition .= empty($_GPC['Thecharts']) ? '' : " AND ((" . $sql_member . ")>0)";
if (!empty($_GPC['memberstatisticsEXP01'])) {
$psize = 9999;
$pindex = 1;
}
$list = pdo_fetchall("select flag.id as flagid,fans.openid as from_user,fans.follow,member.* from " . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member, " . tablename('wwx_fxxt_member') . " flag where fans.openid=flag.from_user and fans.uniacid=flag.uniacid and fans.uid=member.uid " . $condition . " and fans.uniacid=member.uniacid and fans.uniacid={$_W['uniacid']} ORDER BY flag.id DESC");
require_once 'report.php';
die;
}
if ($_GPC['submit'] == '搜 索') {
$condition = '';
$gpmobile = $_GPC['mobile'];
$gprealname = $_GPC['realname'];
$gpuserid = $_GPC['userid'];
$gpflagid = $_GPC['flagid'];
$gpThecharts = $_GPC['Thecharts'];
$gpusergrade = $_GPC['usergrade'];
$sql_member = "select count(order1.id) from " . tablename('wwx_fxxt_order') . " order1 where uniacid = '{$_W['uniacid']}' AND order1.from_user = flag.from_user ";
$condition .= empty($_GPC['mobile']) ? '' : " AND member.mobile LIKE '%" . trim($_GPC['mobile']) . "%'";
$condition .= empty($_GPC['realname']) ? '' : " AND (( member.realname LIKE '%" . trim($_GPC['realname']) . "%' ) OR ( member.nickname LIKE '%" . trim($_GPC['realname']) . "%' )) ";
$condition .= empty($_GPC['userid']) ? '' : " AND flag.id = '" . trim($_GPC['userid']) . "'";
$condition .= empty($_GPC['flagid']) ? '' : " AND flag.shareid = '" . trim($_GPC['flagid']) . "'";
$condition .= empty($_GPC['Thecharts']) ? '' : " AND ((" . $sql_member . ")>0)";
$condition .= empty($_GPC['usergrade']) ? '' : " AND flag.usergrade = '" . trim($_GPC['usergrade']) . "'";
$userexp = pdo_fetchall("select * from " . tablename('wwx_fxxt_member_shipgrade') . " WHERE uniacid = '{$_W['uniacid']}' ORDER BY displayorder ASC");
$list = pdo_fetchall("select flag.id as flagid,fans.openid as from_user, member.* from " . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member, " . tablename('wwx_fxxt_member') . " flag where fans.openid=flag.from_user and fans.uniacid=flag.uniacid and fans.uid=member.uid " . $condition . " and fans.uniacid=member.uniacid and fans.uniacid={$_W['uniacid']} ORDER BY flag.id DESC limit " . ($pindex - 1) * $psize . ',' . $psize);
$total = pdo_fetchcolumn("SELECT COUNT(*) from " . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member, " . tablename('wwx_fxxt_member') . " flag where fans.openid=flag.from_user and fans.uniacid=flag.uniacid and fans.uid=member.uid " . $condition . " and fans.uniacid=member.uniacid and fans.uniacid={$_W['uniacid']} ORDER BY flag.id DESC");
$pager = pagination($total, $pindex, $psize);
include $this->template('charge');
die;
}
$userexp = pdo_fetchall("select * from " . tablename('wwx_fxxt_member_shipgrade') . " WHERE uniacid = '{$_W['uniacid']}' ORDER BY displayorder ASC");
$list = pdo_fetchall("SELECT flag.id as flagid,fans.openid as from_user, member.* FROM " . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member, " . tablename('wwx_fxxt_member') . " flag WHERE fans.openid=flag.from_user and fans.uniacid=flag.uniacid and fans.uid=member.uid and fans.uniacid=member.uniacid and fans.uniacid={$_W['uniacid']} ORDER BY flag.id DESC LIMIT " . ($pindex - 1) * $psize . "," . $psize);
$total = pdo_fetchcolumn("SELECT COUNT(*) from " . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member, " . tablename('wwx_fxxt_member') . " flag where fans.openid=flag.from_user and fans.uniacid=flag.uniacid and fans.uid=member.uid and fans.uniacid=member.uniacid and fans.uniacid={$_W['uniacid']}");
$pager = pagination($total, $pindex, $psize);
include $this->template('charge');
}
if ($op == 'delete') {
if (empty($_GPC['from_user'])) {
message('请选择会员！', create_url('site/entry', array('do' => 'charge', 'op' => 'list', 'm' => 'wwx_fxxt', 'uniacid' => $_W['uniacid'])), 'success');
}
$delmember = pdo_fetch('SELECT * FROM ' . tablename('mc_mapping_fans') . ' WHERE uniacid=:uniacid and openid=:openid', array(':uniacid' => $_W['uniacid'], ':openid' => $_GPC['from_user']));
if (empty($delmember)) {
message('不存在此会员！', create_url('site/entry', array('do' => 'charge', 'op' => 'list', 'm' => 'wwx_fxxt', 'uniacid' => $_W['uniacid'])), 'success');
}
$member_order = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_order') . ' WHERE uniacid=:uniacid and status>0 and from_user=:from_user', array(':uniacid' => $_W['uniacid'], ':from_user' => $_GPC['from_user']));
if (!empty($member_order['id'])) {
message('此会员已有订单信息，不能删除，可至代理管理其权限！', create_url('site/entry', array('do' => 'charge', 'op' => 'list', 'm' => 'wwx_fxxt', 'uniacid' => $_W['uniacid'])), 'error');
}
pdo_delete('mc_members', array('uid' => $_GPC['uid'], 'uniacid' => $_W['uniacid']));
pdo_delete('mc_mapping_fans', array('uid' => $_GPC['uid'], 'uniacid' => $_W['uniacid']));
pdo_delete('wwx_fxxt_member', array('from_user' => $_GPC['from_user'], 'uniacid' => $_W['uniacid']));
pdo_delete('wwx_fxxt_share_history', array('from_user' => $_GPC['from_user'], 'uniacid' => $_W['uniacid']));
message('成功删除会员！', create_url('site/entry', array('do' => 'charge', 'op' => 'list', 'm' => 'wwx_fxxt', 'uniacid' => $_W['uniacid'])), 'success');
}
if ($op == 'post') {
if (empty($_GPC['from_user'])) {
message('请选择会员！', create_url('site/entry', array('do' => 'charge', 'op' => 'list', 'm' => 'wwx_fxxt', 'uniacid' => $_W['uniacid'])), 'success');
}
if (checksubmit()) {
if ($_GPC['chargeType'] == 'credit2') {
$chargenum = round($_GPC['chargenum'], 2);
if ($chargenum) {
pdo_query("update " . tablename('mc_members') . " SET credit2=credit2+'" . $chargenum . "' WHERE uid='" . $_GPC['uid'] . "' AND uniacid=" . $_W['uniacid'] . " ");
$paylog = array('uid' => $_GPC['uid'], 'credittype' => 'credit2', 'uniacid' => $uniacid, 'num' => $chargenum, 'createtime' => TIMESTAMP, 'operator' => $_W['uid'], 'remark' => '后台充值' . $chargenum . '元');
pdo_insert('mc_credits_record', $paylog);
message('充值成功！', referer(), 'success');
}
}
if ($_GPC['chargeType'] == 'credit1') {
if (is_int($_GPC['credit1num'])) {
message("充值积分必须是整数！", referer(), 'error');
}
if (intval($_GPC['credit1num']) <= 0) {
message("充值积分不能为负数或者0", referer(), 'error');
}
$credit1num = intval($_GPC['credit1num']);
if ($credit1num) {
pdo_query("update " . tablename('mc_members') . " SET credit1=credit1+'" . $credit1num . "' WHERE uid='" . $_GPC['uid'] . "' AND uniacid=" . $_W['uniacid'] . " ");
$paylog = array('uid' => $_GPC['uid'], 'credittype' => 'credit1', 'uniacid' => $uniacid, 'num' => $credit1num, 'createtime' => TIMESTAMP, 'operator' => $_W['uid'], 'remark' => '充值' . $credit1num . '积分');
pdo_insert('mc_credits_record', $paylog);
message('充值成功！', referer(), 'success');
}
}
}
$profile = pdo_fetch("select flag.id as flagid,fans.openid as from_user, member.* from " . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member, " . tablename('wwx_fxxt_member') . " flag where fans.openid=flag.from_user and fans.uniacid=flag.uniacid and fans.uid = member.uid and fans.uniacid = member.uniacid and fans.uniacid = :uniacid AND fans.openid=:openid limit 1", array(':uniacid' => $_W['uniacid'], ':openid' => $_GPC['from_user']));
if (!$profile) {
message('请选择会员！', create_url('site/entry', array('do' => 'charge', 'op' => 'list', 'm' => 'wwx_fxxt', 'uniacid' => $_W['uniacid'])), 'success');
}
$total = pdo_fetchcolumn("SELECT COUNT(*) FROM " . tablename('mc_credits_record') . " WHERE uid='" . $_GPC['uid'] . "' AND credittype='" . $_GPC['chargeType'] . "' AND `uniacid` = " . $_W['uniacid']);
$pager = pagination($total, $pindex, $psize);
$list = pdo_fetchall("SELECT * FROM " . tablename('mc_credits_record') . " WHERE uid='" . $_GPC['uid'] . "' AND credittype='" . $_GPC['chargeType'] . "' AND uniacid=" . $_W['uniacid'] . " ORDER BY createtime DESC LIMIT " . ($pindex - 1) * $psize . "," . $psize);
$mlist = pdo_fetchall("SELECT `name`,`title` FROM " . tablename('modules'));
$mtype = array();
foreach ($mlist as $k => $v) {
$mtype[$v['name']] = $v['title'];
}
if ($_GPC['chargeType'] == 'credit2') {
include $this->template('charge_post');
}
if ($_GPC['chargeType'] == 'credit1') {
include $this->template('charge_post_credit1');
}
}
}
public function doWebMembershipGrade()
{
global $_W, $_GPC;
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$uniacid = $_W['uniacid'];
$op = $operation = $_GPC['op'] ? $_GPC['op'] : 'display';
if ($operation == 'display') {
$children = array();
$list = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_member_shipgrade') . " WHERE uniacid = '{$_W['uniacid']}' ORDER BY displayorder desc");
include $this->template('membershipgrade');
} elseif ($operation == 'post') {
$id = intval($_GPC['id']);
$membership = pdo_fetch("SELECT * FROM " . tablename('wwx_fxxt_member_shipgrade') . " WHERE id = '{$id}'");
if ($_GPC['submit'] == '提交') {
if (empty($_GPC['member_name'])) {
message('抱歉，请输入等级名称！');
}
$data = array('uniacid' => $_W['uniacid'], 'displayorder' => intval($_GPC['displayorder']), 'member_name' => $_GPC['member_name'], 'member_turnover' => intval($_GPC['member_turnover']), 'member_motercount' => intval($_GPC['member_motercount']), 'member_commission' => intval($_GPC['member_commission']), 'promoterstate' => $_GPC['promoterstate']);
if (!empty($id)) {
pdo_update('wwx_fxxt_member_shipgrade', $data, array('id' => $id, 'uniacid' => $_W['uniacid']));
} else {
pdo_insert('wwx_fxxt_member_shipgrade', $data);
$id = pdo_insertid();
}
message('更新会员等级成功！', $this->createWebUrl('membershipgrade', array('op' => 'display')), 'success');
}
include $this->template('membershipgrade');
} elseif ($operation == 'delete') {
$id = intval($_GPC['id']);
$category = pdo_fetch("SELECT id FROM " . tablename('wwx_fxxt_member_shipgrade') . " WHERE id = '{$id}'");
if (empty($category)) {
message('抱歉，会员等级不存在或是已经被删除！', $this->createWebUrl('membershipgrade', array('op' => 'display')), 'error');
}
pdo_delete('wwx_fxxt_member_shipgrade', array('id' => $id, 'uniacid' => $_W['uniacid']));
message('会员等级删除成功！', $this->createWebUrl('membershipgrade', array('op' => 'display')), 'success');
}
}
public function doWebfansmanager()
{
global $_W, $_GPC;
set_time_limit(0);
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$uniacid = $_W['uniacid'];
$op = $operation = $_GPC['op'] ? $_GPC['op'] : 'display';
$cfg = $this->module['config'];
if ($op == 'autouser') {
$this->autouserInformation();
die;
}
if ($op == 'delflag') {
pdo_update('wwx_fxxt_member', array('flag' => intval($_GPC['isstatus'])), array('id' => $_GPC['id'], 'uniacid' => $_W['uniacid']));
$op = 'display';
}
if ($op == 'delstatus') {
pdo_update('wwx_fxxt_member', array('status' => intval($_GPC['isstatus'])), array('id' => $_GPC['id'], 'uniacid' => $_W['uniacid']));
$op = 'display';
}
if (!empty($_GPC['fansstatisticsEXP01'])) {
$report = 'fansstatistics';
$condition = '';
$gpmobile = $_GPC['mobile'];
$gprealname = $_GPC['realname'];
$gpuserid = $_GPC['userid'];
$gpflagid = $_GPC['flagid'];
$gpThecharts = $_GPC['Thecharts'];
$sql_member = "select count(order1.id) from " . tablename('wwx_fxxt_order') . " order1 where uniacid = '{$_W['uniacid']}' AND (order1.shareid = qmxk.id or order1.shareid2 = qmxk.id or order1.shareid3 = qmxk.id) ";
$condition .= empty($_GPC['mobile']) ? '' : " AND qmxk.mobile LIKE '%" . trim($_GPC['mobile']) . "%'";
$condition .= empty($_GPC['realname']) ? '' : " AND ( qmxk.realname LIKE '%" . trim($_GPC['realname']) . "%' ) ";
$condition .= empty($_GPC['userid']) ? '' : " AND qmxk.id = '" . trim($_GPC['userid']) . "'";
$condition .= empty($_GPC['flagid']) ? '' : " AND qmxk.shareid = '" . trim($_GPC['flagid']) . "'";
$condition .= empty($_GPC['Thecharts']) ? '' : " AND ((" . $sql_member . ")>0)";
if (!empty($_GPC['fansstatisticsEXP01'])) {
$psize = 9999;
$pindex = 1;
}
if ($_GPC['opp'] == 'nocheck') {
$status = 0;
} else {
$status = 1;
}
$list = pdo_fetchall("select qmxk.*,member.credit1 as credit1,member.credit2 as creditmany,fans.follow,member.nickname,member.gender,member.nationality,member.resideprovince,member.residecity,(select shar.realname from " . tablename('wwx_fxxt_member') . " shar where shar.id=qmxk.shareid and qmxk.uniacid=shar.uniacid limit 1) sharname,(select sum(cast(sumorder.price as decimal(8,2))) from " . tablename('wwx_fxxt_order') . " sumorder where sumorder.shareid=qmxk.id and qmxk.uniacid=sumorder.uniacid and status=3 limit 1) sharprice,(select count(id) from " . tablename('wwx_fxxt_member') . " sumflag where sumflag.shareid=qmxk.id and qmxk.uniacid=sumflag.uniacid limit 1) zhituisum from " . tablename('wwx_fxxt_member') . " qmxk," . tablename('mc_mapping_fans') . " fans," . tablename('mc_members') . " member where qmxk.uniacid=fans.uniacid and qmxk.from_user=fans.openid and fans.uid=member.uid " . $condition . " and qmxk.flag = " . $status . " and qmxk.uniacid = " . $_W['uniacid'] . " order by qmxk.id desc limit " . ($pindex - 1) * $psize . ',' . $psize);
foreach ($list as $id => $displayorder) {
$share1tuan = pdo_fetchall("select id,from_user from " . tablename('wwx_fxxt_member') . " where uniacid=" . $_W['uniacid'] . " and shareid={$displayorder['id']} and flag = 1");
$tuanxiaoshou = 0;
foreach ($share1tuan as $tuanshu) {
$commission = pdo_fetchcolumn("SELECT sum(price) FROM " . tablename('wwx_fxxt_order') . " WHERE shareid = '{$tuanshu['id']}' AND uniacid = '{$_W['uniacid']}' AND from_user != '{$tuanshu['from_user']}' AND ((paytype=3 and (status =3)) or ((paytype=1 or paytype=2 ) and status=3))");
$tuanxiaoshou = $tuanxiaoshou + $commission;
}
$list[$id]['tuanxiaoshou'] = $tuanxiaoshou;
}
require_once 'report.php';
die;
}
if ($op == 'display') {
$pindex = max(1, intval($_GPC['page']));
$psize = 50;
$flagexp = pdo_fetchall("select * from " . tablename('wwx_fxxt_member_flaggrade') . " WHERE uniacid = '{$_W['uniacid']}' ORDER BY displayorder ASC");
$list = pdo_fetchall("select qmxk.*,member.credit1 as credit1,member.credit2 as credit2 from " . tablename('wwx_fxxt_member') . " qmxk," . tablename('mc_mapping_fans') . " fans," . tablename('mc_members') . " member where qmxk.uniacid=fans.uniacid and qmxk.from_user=fans.openid and fans.uid=member.uid and qmxk.flag = 1 and qmxk.uniacid = " . $_W['uniacid'] . " and qmxk.realname<>'' order by qmxk.id desc limit " . ($pindex - 1) * $psize . ',' . $psize);
$total = pdo_fetchcolumn("select count(qmxk.id) from " . tablename('wwx_fxxt_member') . " qmxk," . tablename('mc_mapping_fans') . " fans," . tablename('mc_members') . " member where qmxk.uniacid=fans.uniacid and qmxk.from_user=fans.openid and fans.uid=member.uid and qmxk.flag = 1 and qmxk.uniacid = " . $_W['uniacid'] . " and qmxk.realname<>'' ");
$pager = pagination($total, $pindex, $psize);
}
if ($op == 'nocheck') {
$pindex = max(1, intval($_GPC['page']));
$psize = 50;
$flagexp = pdo_fetchall("select * from " . tablename('wwx_fxxt_member_flaggrade') . " WHERE uniacid = '{$_W['uniacid']}' ORDER BY displayorder ASC");
$list = pdo_fetchall("select qmxk.*,member.credit1 as credit1,member.credit2 as credit2 from " . tablename('wwx_fxxt_member') . " qmxk," . tablename('mc_mapping_fans') . " fans," . tablename('mc_members') . " member where qmxk.uniacid=fans.uniacid and qmxk.from_user=fans.openid and fans.uid=member.uid and qmxk.flag = 0 and qmxk.uniacid = " . $_W['uniacid'] . " and qmxk.realname<>'' order by qmxk.id desc limit " . ($pindex - 1) * $psize . ',' . $psize);
$total = pdo_fetchcolumn("select count(id) from" . tablename('wwx_fxxt_member') . "where flag = 0 and realname<>'' and uniacid =" . $_W['uniacid']);
$pager = pagination($total, $pindex, $psize);
include $this->template('fansmanager');
die;
}
if ($op == 'sort') {
$pindex = max(1, intval($_GPC['page']));
$psize = 50;
$condition = '';
$gpmobile = $_GPC['mobile'];
$gprealname = $_GPC['realname'];
$gpuserid = $_GPC['userid'];
$gpflagid = $_GPC['flagid'];
$gpThecharts = $_GPC['Thecharts'];
$gpflaggrade = $_GPC['flaggrade'];
$sql_member = "select count(order1.id) from " . tablename('wwx_fxxt_order') . " order1 where uniacid = '{$_W['uniacid']}' AND (order1.shareid = qmxk.id or order1.shareid2 = qmxk.id or order1.shareid3 = qmxk.id) ";
$condition .= empty($_GPC['mobile']) ? '' : " AND qmxk.mobile LIKE '%" . trim($_GPC['mobile']) . "%'";
$condition .= empty($_GPC['realname']) ? '' : " AND ( qmxk.realname LIKE '%" . trim($_GPC['realname']) . "%' ) ";
$condition .= empty($_GPC['userid']) ? '' : " AND qmxk.id = '" . trim($_GPC['userid']) . "'";
$condition .= empty($_GPC['flagid']) ? '' : " AND qmxk.shareid = '" . trim($_GPC['flagid']) . "'";
$condition .= empty($_GPC['Thecharts']) ? '' : " AND ((" . $sql_member . ")>0)";
$condition .= empty($_GPC['flaggrade']) ? '' : " AND qmxk.flaggrade = '" . trim($_GPC['flaggrade']) . "'";
if ($_GPC['opp'] == 'nocheck') {
$status = 0;
} else {
$status = 1;
}
$flagexp = pdo_fetchall("select * from " . tablename('wwx_fxxt_member_flaggrade') . " WHERE uniacid = '{$_W['uniacid']}' ORDER BY displayorder ASC");
$list = pdo_fetchall("select qmxk.*,member.credit1 as credit1,member.credit2 as credit2 from " . tablename('wwx_fxxt_member') . " qmxk," . tablename('mc_mapping_fans') . " fans," . tablename('mc_members') . " member where qmxk.uniacid=fans.uniacid and qmxk.from_user=fans.openid and fans.uid=member.uid " . $condition . " and qmxk.flag = " . $status . " and qmxk.uniacid = " . $_W['uniacid'] . " order by qmxk.id desc limit " . ($pindex - 1) * $psize . ',' . $psize);
$total = pdo_fetchcolumn("select count(qmxk.id) from " . tablename('wwx_fxxt_member') . " qmxk," . tablename('mc_mapping_fans') . " fans," . tablename('mc_members') . " member where qmxk.uniacid=fans.uniacid and qmxk.from_user=fans.openid and fans.uid=member.uid " . $condition . " and qmxk.flag = " . $status . " and qmxk.uniacid = " . $_W['uniacid']);
$pager = pagination($total, $pindex, $psize);
if ($_GPC['opp'] == 'nocheck') {
include $this->template('fansmanager');
die;
}
}
if ($op == 'user') {
$from_user = $_GPC['from_user'];
$fans = pdo_fetch("select b.nickname,b.createtime,b.credit1 from " . tablename('mc_mapping_fans') . " a, " . tablename('mc_members') . " b where a.openid=:openid and a.uniacid=:uniacid and a.uid=b.uid", array(':openid' => $from_user, ':uniacid' => $_W['uniacid']));
$myheadimg = pdo_fetchcolumn("select avatar from " . tablename('mc_mapping_fans') . " a, " . tablename('mc_members') . " b where a.openid=:openid and a.uniacid=:uniacid and a.uid=b.uid", array(':openid' => $from_user, ':uniacid' => $_W['uniacid']));
$fans['avatar'] = $myheadimg;
$profile = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_member') . " WHERE uniacid = :uniacid AND from_user = :from_user", array(':uniacid' => $_W['uniacid'], ':from_user' => $from_user));
if (!empty($profile['id'])) {
$mylist = pdo_fetchall("select d.createtime createtime, d.nickname nickname, d.avatar avatar from " . tablename('wwx_fxxt_share_history') . " a," . tablename('mc_mapping_fans') . " b," . tablename('wwx_fxxt_member') . " c," . tablename('mc_members') . " d where a.from_user = b.openid and a.uniacid=b.uniacid and a.sharemid=c.id and a.from_user!=:leader and a.uniacid=:uniacid ", array(':leader' => $from_user, ':uniacid' => $_W['uniacid']));
$count = 0;
if (true) {
$sql1_member = "select mber1.from_user from " . tablename('wwx_fxxt_member') . " mber1 where mber1.realname<>'' and mber1.id!=mber1.shareid and mber1.shareid = " . $profile['id'];
$count1 = pdo_fetchcolumn(" select count(*) from " . tablename('mc_mapping_fans') . " fans where openid!='{$from_user}' and (fans.openid in (" . $sql1_member . ")) and fans.uniacid={$_W['uniacid']}");
$mylist1 = pdo_fetchall(" select *,1 as level from " . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member where fans.openid!='{$from_user}' and (fans.openid in (" . $sql1_member . ") ) and fans.uid=member.uid and fans.uniacid=member.uniacid and fans.uniacid={$_W['uniacid']}");
}
if (true && $cfg['globalCommissionLevel'] >= 2) {
$level2 = pdo_fetchall("select id from " . tablename('wwx_fxxt_member') . " where id!=shareid and shareid = " . $profile['id']);
$rowindex = 0;
$str = "";
foreach ($level2 as &$citem) {
$str = $str . $citem['id'] . ',';
}
$str = $str . '-1';
$sql2_member = "select mber2.from_user from " . tablename('wwx_fxxt_member') . " mber2 where mber2.realname<>'' and mber2.id!=mber2.shareid and mber2.shareid in (" . $str . ") ";
$count2 = pdo_fetchcolumn(" select count(*) from " . tablename('mc_mapping_fans') . " fans where openid!='{$from_user}' and (fans.openid in (" . $sql2_member . ")) and (fans.openid not in (" . $sql1_member . ")) and fans.uniacid={$_W['uniacid']}");
$mylist2 = pdo_fetchall(" select *,2 as level from " . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member where fans.openid!='{$from_user}' and (fans.openid in (" . $sql2_member . ")) and fans.uid=member.uid and (fans.openid not in (" . $sql1_member . ")) and fans.uniacid={$_W['uniacid']}");
}
if (true && $cfg['globalCommissionLevel'] >= 3) {
$level3 = pdo_fetchall("select id from " . tablename('wwx_fxxt_member') . " where id!=shareid and shareid in( " . $str . ")");
$rowindex = 0;
$str3 = "";
foreach ($level3 as &$citem) {
$str3 = $str3 . $citem['id'] . ',';
}
$str3 = $str3 . '-1';
$sql3_member = "select mber3.from_user from " . tablename('wwx_fxxt_member') . " mber3 where mber3.realname<>'' and mber3.id!=mber3.shareid and mber3.shareid in (" . $str3 . ") ";
$count3 = pdo_fetchcolumn(" select count(*) from " . tablename('mc_mapping_fans') . " fans where fans.openid!='{$from_user}' and (fans.openid in (" . $sql3_member . ")) and (fans.openid not in (" . $sql1_member . ")) and (fans.openid not in (" . $sql2_member . ")) and fans.uniacid={$_W['uniacid']}");
$mylist3 = pdo_fetchall(" select *,3 as level from " . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member where fans.openid!='{$from_user}' and (fans.openid in (" . $sql3_member . ")) and fans.uid=member.uid and (fans.openid not in (" . $sql1_member . ")) and (fans.openid not in (" . $sql2_member . ")) and fans.uniacid={$_W['uniacid']}");
}
$count = $count1 + $count2 + $count3;
} else {
$count = 0;
}
if (!empty($_GPC['sharestatisticsEXP01'])) {
$report = 'sharestatistics';
$list = array_merge($mylist1, $mylist2, $mylist3);
if (empty($profile['id']) || empty($list)) {
message('代理为空或者代理不存在！', referer(), 'error');
}
foreach ($list as $id => $displayorder) {
$fanslist = pdo_fetch("select * from " . tablename('wwx_fxxt_member') . " where uniacid=" . $_W['uniacid'] . " and from_user='{$displayorder['openid']}'");
$sharname = pdo_fetch('SELECT realname FROM ' . tablename('wwx_fxxt_member') . " WHERE uniacid = :uniacid AND id = :id", array(':uniacid' => $_W['uniacid'], ':id' => $fanslist['shareid']));
$list[$id]['sharname'] = $sharname['realname'];
$list[$id]['member'] = $fanslist;
}
require_once 'report.php';
die;
}
if (!empty($_GPC['shangpinstatisticsEXP01'])) {
$report = 'shangpinstatistics';
if (!empty($_GPC['shangpinstatisticsEXP01'])) {
$psize = 9999;
$pindex = 1;
}
if (empty($profile['id'])) {
message('代理为空或者代理不存在！', referer(), 'error');
}
$list = pdo_fetchall('SELECT * FROM ' . tablename('wwx_fxxt_order') . " WHERE uniacid = '{$_W['uniacid']}' AND (shareid = '" . intval($profile['id']) . "' or shareid2 = '" . intval($profile['id']) . "' or shareid3 = '" . intval($profile['id']) . "') AND from_user<>'" . $profile['from_user'] . "' ORDER BY createtime DESC LIMIT " . ($pindex - 1) * $psize . ',' . $psize);
if (!empty($list)) {
foreach ($list as $key => $l) {
$commissions = pdo_fetchall('select total,commission as commission, commission2 as commission2, commission3 as commission3 from ' . tablename('wwx_fxxt_order_goods') . ' where orderid = ' . $l['id']);
foreach ($commissions as $commission) {
$list[$key]['commission'] = $commission['commission'] * $commission['total'];
$list[$key]['shareopen1'] = $this->getShareId($l['from_user']);
if ($cfg['globalCommissionLevel'] >= 2) {
$list[$key]['commission2'] = $commission['commission2'] * $commission['total'];
$list[$key]['shareopen2'] = $this->getShareId($l['from_user'], 2);
} else {
$list[$key]['commission2'] = 0;
$list[$key]['shareopen2'] = 0;
}
if ($cfg['globalCommissionLevel'] >= 3) {
$list[$key]['commission3'] = $commission['commission3'] * $commission['total'];
$list[$key]['shareopen3'] = $this->getShareId($l['from_user'], 3);
} else {
$list[$key]['commission3'] = 0;
$list[$key]['shareopen3'] = 0;
}
}
}
}
if (!empty($list)) {
foreach ($list as &$row) {
!empty($row['addressid']) && ($addressids[$row['addressid']] = $row['addressid']);
$row['dispatch'] = pdo_fetch("SELECT * FROM " . tablename('wwx_fxxt_dispatch') . " WHERE id = :id", array(':id' => $row['dispatch']));
}
unset($row);
}
if (!empty($addressids)) {
$address = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_address') . " WHERE id IN ('" . implode("','", $addressids) . "')", array(), 'id');
}
require_once 'report.php';
die;
}
include $this->template('clicklog');
die;
}
if ($op == 'delete') {
if (empty($_GPC['id'])) {
message('请选择代理！', referer(), 'error');
}
$member_open = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_member') . ' WHERE uniacid=:uniacid and id=:id', array(':uniacid' => $_W['uniacid'], ':id' => $_GPC['id']));
$member_fans = pdo_fetch("select fans.openid as from_user, member.* from " . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member where fans.uid = member.uid and fans.uniacid = member.uniacid and fans.uniacid = :uniacid AND fans.openid=:openid limit 1", array(':uniacid' => $_W['uniacid'], ':openid' => $member_open['from_user']));
if (empty($member_open['from_user'])) {
message('没有此代理！', referer(), 'error');
}
$member_order = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_order') . ' WHERE uniacid=:uniacid and status>0 and from_user=:from_user', array(':uniacid' => $_W['uniacid'], ':from_user' => $member_fans['from_user']));
if (!empty($member_order['id'])) {
message('此代理已有订单信息，不能删除，请设置其权限即可！', referer(), 'error');
}
pdo_delete('mc_members', array('uid' => $member_fans['uid'], 'uniacid' => $_W['uniacid']));
pdo_delete('mc_mapping_fans', array('uid' => $member_fans['uid'], 'uniacid' => $_W['uniacid']));
pdo_delete('wwx_fxxt_member', array('from_user' => $member_order['from_user'], 'uniacid' => $_W['uniacid']));
pdo_delete('wwx_fxxt_share_history', array('from_user' => $member_order['from_user'], 'uniacid' => $_W['uniacid']));
if ($_GPC['opp'] == 'nocheck') {
message('代理删除成功！', $this->createWebUrl('fansmanager', array('op' => 'nocheck')), 'success');
} else {
message('代理删除成功！', $this->createWebUrl('fansmanager'), 'success');
}
}
if ($op == 'detail') {
$id = intval($_GPC['id']);
$fromuser = $_GPC['from_user'];
if (!empty($id)) {
$user = pdo_fetch("select * from " . tablename('wwx_fxxt_member') . " where id = " . $id);
} elseif (!empty($fromuser)) {
$user = pdo_fetch("select * from " . tablename('wwx_fxxt_member') . " where from_user = '{$fromuser}'");
}
if (empty($user['id'])) {
message('用户信息不存在！', referer(), 'error');
}
if (!empty($user['shareid'])) {
$user1 = pdo_fetch("select * from " . tablename('wwx_fxxt_member') . " where flag=1 and id = " . $user['shareid']);
}
if (!empty($user1['shareid'])) {
$user2 = pdo_fetch("select * from " . tablename('wwx_fxxt_member') . " where flag=1 and id = " . $user1['shareid']);
}
if (!empty($user2['shareid'])) {
$user3 = pdo_fetch("select * from " . tablename('wwx_fxxt_member') . " where flag=1 and id = " . $user2['shareid']);
}
$userexp = pdo_fetchall("select * from " . tablename('wwx_fxxt_member_shipgrade') . " WHERE uniacid = '{$_W['uniacid']}' ORDER BY displayorder ASC");
$flagexp = pdo_fetchall("select * from " . tablename('wwx_fxxt_member_flaggrade') . " WHERE uniacid = '{$_W['uniacid']}' ORDER BY displayorder ASC");
if ($_GPC['opp'] == 'nocheck') {
include $this->template('fansmanagered_detail');
die;
} else {
include $this->template('fansmanager_detail');
die;
}
}
if ($op == 'status') {
if (empty($_GPC['id'])) {
message('参数非法！', $this->createWebUrl('fansmanager'), 'error');
}
$status = array('status' => $_GPC['status'], 'flag' => $_GPC['flag'], 'usergrade' => $_GPC['usergrade'], 'usergradeauto' => $_GPC['usergradeauto'], 'flaggrade' => $_GPC['flaggrade'], 'flaggradeauto' => $_GPC['flaggradeauto'], 'content' => trim($_GPC['content']));
if (!empty($_GPC['usershareid'])) {
$status['shareid'] = $_GPC['usershareid'];
$shareuser = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_member') . " WHERE uniacid = '{$_W['uniacid']}' AND id = '{$status['shareid']}'");
if (empty($shareuser['id'])) {
message('没有此分销上级，请重新设置！', referer(), 'error');
}
$seidmember = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_member') . " WHERE uniacid = '{$_W['uniacid']}' AND id = '{$_GPC['id']}'");
$seidshare = pdo_fetch("SELECT sharemid FROM " . tablename('wwx_fxxt_share_history') . " WHERE from_user=:from_user and uniacid=:uniacid", array(':from_user' => $seidmember['from_user'], ':uniacid' => $_W['uniacid']));
$seiddata = array('uniacid' => $_W['uniacid'], 'from_user' => $seidmember['from_user'], 'sharemid' => $status['shareid'], 'joinway' => 0);
if (empty($seidshare['sharemid'])) {
pdo_insert('wwx_fxxt_share_history', $seiddata);
} else {
pdo_delete('wwx_fxxt_share_history', array('from_user' => $seidmember['from_user'], 'uniacid' => $_W['uniacid']));
pdo_insert('wwx_fxxt_share_history', $seiddata);
}
}
if ($_GPC['opp'] == 'nocheck' && $_GPC['flag'] == 1) {
$status['flagtime'] = TIMESTAMP;
}
pdo_update('wwx_fxxt_member', $status, array('id' => $_GPC['id']));
if ($_GPC['opp'] == 'nocheck') {
message('设置用户成功！', $this->createWebUrl('fansmanager', array('op' => 'detail', 'opp' => 'nocheck', 'id' => $_GPC['id'])), 'success');
} else {
message('设置用户成功！', $this->createWebUrl('fansmanager', array('op' => 'detail', 'id' => $_GPC['id'])), 'success');
}
}
if ($op == 'recharge') {
$pindex = max(1, intval($_GPC['page']));
$psize = 20;
$id = $_GPC['id'];
$chargenum = round($_GPC['chargenum'], 2);
if ($_GPC['opp'] == 'recharged') {
if (!is_numeric($chargenum)) {
message('佣金请输入合法数字！', '', 'error');
}
if ($_GPC['realname'] == "") {
$_GPC['realname'] = "未设置";
}
if (strlen($_GPC['from_user']) < 10) {
message('此用户不是微信端用户，不能使用微信打款！', $this->createWebUrl('fansmanager', array('op' => 'recharge', 'id' => $_GPC['id'])), 'error');
}
$senduser = array('openid' => $_GPC['from_user'], 'fee' => $chargenum, 'realname' => $_GPC['realname'], 'desc' => '意虎补充付款', 'id' => $_GPC['id']);
$wxret = $this->wxsend($senduser);
if (is_error($wxret)) {
message('微信打款失败：' . $wxret['message'], $this->createWebUrl('fansmanager', array('op' => 'recharge', 'id' => $_GPC['id'])), 'error');
}
pdo_query('update ' . tablename('wwx_fxxt_member') . ' SET zhifu=zhifu+\'' . $chargenum . "' WHERE from_user='" . $_GPC['from_user'] . "' AND uniacid=" . $_W['uniacid'] . " ");
$paylog = array('type' => 'zhifu', 'uniacid' => $_W['uniacid'], 'openid' => $_GPC['from_user'], 'tid' => date('Y-m-d H:i:s'), 'fee' => $chargenum, 'module' => 'wwx_fxxt', 'tag' => ' 后台微信补充打款' . $chargenum . '元,' . $_GPC['content'] . '!');
pdo_insert('core_paylog', $paylog);
message('打款成功！', $this->createWebUrl('fansmanager', array('op' => 'recharge', 'id' => $_GPC['id'])), 'success');
}
$user = pdo_fetch("select * from " . tablename('wwx_fxxt_member') . " where id = " . $id);
$total = pdo_fetchcolumn("SELECT COUNT(*) FROM " . tablename('core_paylog') . " WHERE openid='" . $user['from_user'] . "' AND type='zhifu' AND `uniacid` = " . $_W['uniacid']);
$pager = pagination($total, $pindex, $psize);
$list = pdo_fetchall("SELECT * FROM " . tablename('core_paylog') . " WHERE openid='" . $user['from_user'] . "' AND type='zhifu' AND uniacid=" . $_W['uniacid'] . " ORDER BY plid DESC LIMIT " . ($pindex - 1) * $psize . "," . $psize);
include $this->template('fansmanager_recharge');
die;
}
include $this->template('fansmanager');
}
public function doWebMemberflagGrade()
{
global $_W, $_GPC;
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$cfg = $this->module['config'];
$uniacid = $_W['uniacid'];
$op = $operation = $_GPC['op'] ? $_GPC['op'] : 'flagdisplay';
if ($operation == 'flagdisplay') {
$children = array();
$list = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_member_flaggrade') . " WHERE uniacid = '{$_W['uniacid']}' ORDER BY displayorder desc");
include $this->template('memberflaggrade');
} elseif ($operation == 'post') {
$id = intval($_GPC['id']);
$memberflag = pdo_fetch("SELECT * FROM " . tablename('wwx_fxxt_member_flaggrade') . " WHERE id = '{$id}'");
if ($_GPC['submit'] == '提交') {
if (empty($_GPC['flag_name'])) {
message('抱歉，请输入等级名称！');
}
$data = array('uniacid' => $_W['uniacid'], 'displayorder' => intval($_GPC['displayorder']), 'flag_name' => $_GPC['flag_name'], 'flag_commission1' => intval($_GPC['flag_commission1']), 'flag_commission2' => intval($_GPC['flag_commission2']), 'flag_commission3' => intval($_GPC['flag_commission3']), 'flag_money' => $_GPC['flag_money'], 'flag_totalmoney' => $_GPC['flag_totalmoney'], 'flag_count' => intval($_GPC['flag_count']), 'promoterstate' => $_GPC['promoterstate']);
if (!empty($id)) {
pdo_update('wwx_fxxt_member_flaggrade', $data, array('id' => $id, 'uniacid' => $_W['uniacid']));
} else {
pdo_insert('wwx_fxxt_member_flaggrade', $data);
$id = pdo_insertid();
}
message('更新代理等级成功！', $this->createWebUrl('memberflaggrade', array('op' => 'flagdisplay')), 'success');
}
include $this->template('memberflaggrade');
} elseif ($operation == 'delete') {
$id = intval($_GPC['id']);
$category = pdo_fetch("SELECT id FROM " . tablename('wwx_fxxt_member_flaggrade') . " WHERE id = '{$id}'");
if (empty($category)) {
message('抱歉，代理等级不存在或是已经被删除！', $this->createWebUrl('memberflaggrade', array('op' => 'flagdisplay')), 'error');
}
pdo_delete('wwx_fxxt_member_flaggrade', array('id' => $id, 'uniacid' => $_W['uniacid']));
message('代理等级删除成功！', $this->createWebUrl('memberflaggrade', array('op' => 'flagdisplay')), 'success');
}
}
public function doWebCommission()
{
global $_W, $_GPC;
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$cfg = $this->module['config'];
$uniacid = $_W['uniacid'];
$op = $operation = $_GPC['op'] ? $_GPC['op'] : 'display';
$members = pdo_fetchall("select id, realname, mobile from " . tablename('wwx_fxxt_member') . " where uniacid = " . $_W['uniacid'] . " and status = 1");
$member = array();
foreach ($members as $m) {
$member['realname'][$m['id']] = $m['realname'];
$member['mobile'][$m['id']] = $m['mobile'];
}
if ($op == 'display') {
if ($_GPC['opp'] == 'check') {
$level = $_GPC['level'];
$zhifucommission = $cfg['zhifuCommission'];
if (!$zhifucommission) {
message('请先在参数设置，设置佣金打款限额！', $this->createWebUrl('Commission'), 'success');
}
$shareid = $_GPC['shareid'];
$user = pdo_fetch("select * from " . tablename('wwx_fxxt_member') . " where id = " . $_GPC['shareid']);
if (empty($level)) {
message('提交错误');
}
if ($level == 1) {
$status = 'og.status,';
$conditionCommission = 'og.commission*og.total as commissionsum';
}
if ($level == 2) {
$status = 'og.status2 as status,';
$conditionCommission = 'og.commission2*og.total as commissionsum';
}
if ($level == 3) {
$status = 'og.status3 as status,';
$conditionCommission = 'og.commission3*og.total as commissionsum';
}
if (!empty($user['shareid'])) {
$user2 = pdo_fetch("select * from " . tablename('wwx_fxxt_member') . " where flag=1 and id = " . $user['shareid']);
}
if (!empty($user2['shareid'])) {
$user3 = pdo_fetch("select * from " . tablename('wwx_fxxt_member') . " where flag=1 and id = " . $user2['shareid']);
}
$info = pdo_fetch("select og.id,og.orderid,og.total,og.price," . $status . $conditionCommission . ", og.commission, og.commission2,og.commission3,og.applytime,og.content,g.title from " . tablename('wwx_fxxt_order_goods') . " as og left join " . tablename('wwx_fxxt_goods') . " as g on og.goodsid = g.id and og.uniacid = g.uniacid where og.id = " . $_GPC['id']);
$order = pdo_fetch("select * from " . tablename('wwx_fxxt_order') . " where id = " . $info['orderid']);
include $this->template('applying_detail');
die;
}
if ($_GPC['opp'] == 'autocheck') {
$zhifucommission = $cfg['zhifuCommission'];
if (!$zhifucommission) {
message('请先在参数设置，设置佣金打款限额！', $this->createWebUrl('Commission'), 'success');
}
$shareid = $_GPC['shareid'];
$user = pdo_fetch("select * from " . tablename('wwx_fxxt_member') . " where id = " . $_GPC['shareid']);
$list = pdo_fetchall("select 1 as level,o.shareid,o.status,g.id,g.applytime,g.commission*g.total as commission,g.checktime as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status = 1) and (o.shareid in (" . $shareid . ")) union all (select 2 as level,o.shareid2 as shareid, o.status, g.id, g.applytime2 as applytime,g.commission2*g.total as commission,g.checktime2 as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status2 = 1) and (o.shareid2 in (" . $shareid . "))) union all (select 3 as level,o.shareid3 as shareid, o.status, g.id, g.applytime3 as applytime,g.commission3*g.total as commission,g.checktime3 as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status3 = 1) and (o.shareid3 in (" . $shareid . "))) order by applytime desc");
$total = sizeof($list);
$commissionsum = 0;
foreach ($list as $k => $array) {
if ($array['commission'] > 0) {
$commissionsum += $array['commission'];
}
}
include $this->template('applying_autodetail');
die;
}
if ($_GPC['opp'] == 'autochecked') {
$shareid = $_GPC['shareid'];
$list = pdo_fetchall("select 1 as level,o.shareid,o.status,g.id,g.applytime,g.commission*g.total as commission,g.checktime as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status = 1) and (o.shareid in (" . $shareid . ")) union all (select 2 as level,o.shareid2 as shareid, o.status, g.id, g.applytime2 as applytime,g.commission2*g.total as commission,g.checktime2 as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status2 = 1) and (o.shareid2 in (" . $shareid . "))) union all (select 3 as level,o.shareid3 as shareid, o.status, g.id, g.applytime3 as applytime,g.commission3*g.total as commission,g.checktime3 as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status3 = 1) and (o.shareid3 in (" . $shareid . "))) order by applytime desc");
if ($_GPC['status'] >= 2) {
if ($_GPC['commission'] > 0) {
if ($_GPC['status'] == 2) {
$checkbak = "银行打款";
}
if ($_GPC['status'] == 3) {
$checkbak = "支付宝打款";
}
if ($_GPC['status'] == 4) {
$checkbak = "微信打款";
}
$commissionmem = pdo_fetch("select from_user,commission,realname from " . tablename('wwx_fxxt_member') . " where id = " . $shareid);
if ($_GPC['status'] == 4) {
if (strlen($commissionmem['from_user']) < 10) {
message('此用户不是微信端用户，不能使用微信打款！', $this->createWebUrl('commission', array('opp' => 'autocheck', 'shareid' => $_GPC['shareid'])), 'error');
}
if ($commissionmem['realname'] == "") {
$commissionmem['realname'] = "未设置";
}
$senduser = array('openid' => $commissionmem['from_user'], 'fee' => $_GPC['commission'], 'realname' => $commissionmem['realname'], 'desc' => '意虎统一付款', 'id' => $shareid);
$wxret = $this->wxsend($senduser);
if (is_error($wxret)) {
message('微信打款失败：' . $wxret['message'], $this->createWebUrl('commission', array('opp' => 'autocheck', 'shareid' => $_GPC['shareid'])), 'error');
}
}
foreach ($list as $k => $array) {
if ($array['level'] == 1) {
$checked = array('status' => $_GPC['status'], 'checktime' => time());
}
if ($array['level'] == 2) {
$checked = array('status2' => $_GPC['status'], 'checktime2' => time());
}
if ($array['level'] == 3) {
$checked = array('status3' => $_GPC['status'], 'checktime3' => time());
}
$ogid = $array['id'];
pdo_update('wwx_fxxt_member', array('commission' => $commissionmem['commission'] + $array['commission']), array('id' => $shareid));
pdo_query('update ' . tablename('wwx_fxxt_member') . ' SET zhifu=zhifu+\'' . $array['commission'] . "' WHERE id='" . $shareid . "' AND uniacid=" . $_W['uniacid'] . " ");
$paylog = array('type' => 'zhifu', 'uniacid' => $_W['uniacid'], 'openid' => $commissionmem['from_user'], 'tid' => date('Y-m-d H:i:s'), 'fee' => $array['commission'], 'module' => 'wwx_fxxt', 'tag' => ' 后台' . $checkbak . '：' . $_GPC['commission'] . '元【' . $array['level'] . '级会员佣金】');
pdo_insert('core_paylog', $paylog);
$temp = pdo_update('wwx_fxxt_order_goods', $checked, array('id' => $ogid));
}
$this->sendsjytktz($_GPC['commission'], "全部分佣订单", $commissionmem['from_user']);
}
message('打款完成！', $this->createWebUrl('commission'), 'success');
}
foreach ($list as $k => $array) {
if ($array['level'] == 1) {
$checked = array('status' => $_GPC['status'], 'checktime' => time());
}
if ($array['level'] == 2) {
$checked = array('status2' => $_GPC['status'], 'checktime2' => time());
}
if ($array['level'] == 3) {
$checked = array('status3' => $_GPC['status'], 'checktime3' => time());
}
$ogid = $array['id'];
$temp = pdo_update('wwx_fxxt_order_goods', $checked, array('id' => $ogid));
}
if (empty($temp)) {
message('审核失败，请重新审核！', $this->createWebUrl('commission', array('opp' => 'autocheck', 'shareid' => $_GPC['shareid'])), 'error');
} else {
message('审核成功！', $this->createWebUrl('commission'), 'success');
}
}
if ($_GPC['opp'] == 'checked') {
$level = $_GPC['level'];
if (empty($level)) {
message('提交错误');
}
if ($level == 1) {
$checked = array('status' => $_GPC['status'], 'checktime' => time());
}
if ($level == 2) {
$checked = array('status2' => $_GPC['status'], 'checktime2' => time());
}
if ($level == 3) {
$checked = array('status3' => $_GPC['status'], 'checktime3' => time());
}
if ($_GPC['status'] >= 2) {
$shareid = $_GPC['shareid'];
$ogid = $_GPC['id'];
if ($_GPC['commission'] > 0) {
if ($_GPC['status'] == 2) {
$checkbak = "银行打款";
}
if ($_GPC['status'] == 3) {
$checkbak = "支付宝打款";
}
if ($_GPC['status'] == 4) {
$checkbak = "微信打款";
}
$commissionmem = pdo_fetch("select from_user,commission,realname from " . tablename('wwx_fxxt_member') . " where id = " . $shareid);
if ($_GPC['status'] == 4) {
if (strlen($commissionmem['from_user']) < 10) {
message('此用户不是微信端用户，不能使用微信打款！', $this->createWebUrl('commission', array('opp' => 'check', 'shareid' => $_GPC['shareid'], 'id' => $_GPC['id'])), 'error');
}
if ($commissionmem['realname'] == "") {
$commissionmem['realname'] = "未设置";
}
$senduser = array('openid' => $commissionmem['from_user'], 'fee' => $_GPC['commission'], 'realname' => $commissionmem['realname'], 'desc' => '意虎付款', 'id' => $_GPC['id']);
$wxret = $this->wxsend($senduser);
if (is_error($wxret)) {
message('微信打款失败：' . $wxret['message'], $this->createWebUrl('commission', array('opp' => 'check', 'shareid' => $_GPC['shareid'], 'id' => $_GPC['id'], 'level' => $level)), 'error');
}
}
pdo_update('wwx_fxxt_member', array('commission' => $commissionmem['commission'] + $_GPC['commission']), array('id' => $shareid));
pdo_query('update ' . tablename('wwx_fxxt_member') . ' SET zhifu=zhifu+\'' . $_GPC['commission'] . "' WHERE id='" . $shareid . "' AND uniacid=" . $_W['uniacid'] . " ");
$paylog = array('type' => 'zhifu', 'uniacid' => $_W['uniacid'], 'openid' => $commissionmem['from_user'], 'tid' => date('Y-m-d H:i:s'), 'fee' => $_GPC['commission'], 'module' => 'wwx_fxxt', 'tag' => ' 后台' . $checkbak . '：' . $_GPC['commission'] . '元【' . $level . '级会员佣金】');
pdo_insert('core_paylog', $paylog);
$temp = pdo_update('wwx_fxxt_order_goods', $checked, array('id' => $_GPC['id']));
$this->sendsjytktz($_GPC['commission'], $level, $commissionmem['from_user']);
}
message('打款完成！', $this->createWebUrl('commission'), 'success');
}
$temp = pdo_update('wwx_fxxt_order_goods', $checked, array('id' => $_GPC['id']));
if (empty($temp)) {
message('审核失败，请重新审核！', $this->createWebUrl('commission', array('opp' => 'check', 'shareid' => $_GPC['shareid'], 'id' => $_GPC['id'], 'level' => $level)), 'error');
} else {
message('审核成功！', $this->createWebUrl('commission'), 'success');
}
}
if ($_GPC['opp'] == 'sort') {
$sort = array('realname' => $_GPC['realname'], 'mobile' => $_GPC['mobile']);
$shareid = "select id from " . tablename('wwx_fxxt_member') . " where uniacid = " . $_W['uniacid'] . " and realname like '%" . $sort['realname'] . "%' and mobile like '%" . $sort['mobile'] . "%'";
$list = pdo_fetchall("select 1 as level,o.shareid,o.status,g.id,g.applytime,g.commission*g.total as commission,g.checktime as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status = 1) and (o.shareid in (" . $shareid . ")) union all (select 2 as level,o.shareid2 as shareid, o.status, g.id, g.applytime2 as applytime,g.commission2*g.total as commission,g.checktime2 as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status2 = 1) and (o.shareid2 in (" . $shareid . "))) union all (select 3 as level,o.shareid3 as shareid, o.status, g.id, g.applytime3 as applytime,g.commission3*g.total as commission,g.checktime3 as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status3 = 1) and (o.shareid3 in (" . $shareid . "))) order by applytime desc");
$total = sizeof($list);
} else {
$pindex = max(1, intval($_GPC['page']));
$psize = 50;
$list = pdo_fetchall("select 1 as level,o.shareid,o.status,g.id,g.applytime,g.commission*g.total as commission,g.checktime as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status = 1 and o.shareid!=0) " . " union all (select 2 as level,o.shareid2 as shareid,o.status, g.id, g.applytime2 as applytime,g.commission2*g.total as commission,g.checktime2 as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status2 = 1 and o.shareid2!=0) )" . " union all (select 3 as level,o.shareid3 as shareid,o.status, g.id, g.applytime3 as applytime,g.commission3*g.total as commission,g.checktime3 as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status3 = 1 and o.shareid3!=0) ) order by applytime desc limit " . ($pindex - 1) * $psize . "," . $psize);
$total = pdo_fetchcolumn('select count(o.id) from ' . tablename('wwx_fxxt_order') . ' as o left join ' . tablename('wwx_fxxt_order_goods') . ' as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = ' . $_W['uniacid'] . ' and (o.shareid!=0 ) and (g.status = 1 )');
$total2 = pdo_fetchcolumn('select count(o.id) from ' . tablename('wwx_fxxt_order') . ' as o left join ' . tablename('wwx_fxxt_order_goods') . ' as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = ' . $_W['uniacid'] . ' and (o.shareid2!=0 ) and (g.status2 = 1 )');
$total3 = pdo_fetchcolumn('select count(o.id) from ' . tablename('wwx_fxxt_order') . ' as o left join ' . tablename('wwx_fxxt_order_goods') . ' as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = ' . $_W['uniacid'] . ' and (o.shareid3!=0 ) and (g.status3 = 1 )');
$total = $total + $total2 + $total3;
$pager = pagination($total, $pindex, $psize);
}
if (!empty($list)) {
foreach ($list as $key => $l) {
$user = pdo_fetch("select id,shareid from " . tablename('wwx_fxxt_member') . " where flag=1 and id = " . $l['shareid']);
if (empty($user['id'])) {
$list[$key]['commission'] = 0;
$list[$key]['commission2'] = 0;
$list[$key]['commission3'] = 0;
} else {
$user2 = pdo_fetch("select id,shareid from " . tablename('wwx_fxxt_member') . " where flag=1 and id = " . $user['shareid']);
if (empty($user2['id'])) {
$list[$key]['commission2'] = 0;
$list[$key]['commission3'] = 0;
} else {
$user3 = pdo_fetch("select id from " . tablename('wwx_fxxt_member') . " where flag=1 and id = " . $user2['shareid']);
if (empty($user3['id'])) {
$list[$key]['commission3'] = 0;
}
}
}
}
}
include $this->template('applying');
die;
}
if ($op == 'applyed') {
if ($_GPC['opp'] == 'jieyong') {
$shareid = $_GPC['shareid'];
$user = pdo_fetch("select * from " . tablename('wwx_fxxt_member') . " where id = " . $_GPC['shareid']);
$level = $_GPC['level'];
if (empty($level)) {
message('提交错误');
}
if ($level == 1) {
$status = 'og.status,';
$conditionCommission = '(og.commission*og.total) as commissionsum';
}
if ($level == 2) {
$status = 'og.status2 as status,';
$conditionCommission = '(og.commission2*og.total) as commissionsum';
}
if ($level == 3) {
$status = 'og.status3 as status,';
$conditionCommission = '(og.commission3*og.total) as commissionsum';
}
if (!empty($user['shareid'])) {
$user2 = pdo_fetch("select * from " . tablename('wwx_fxxt_member') . " where flag=1 and id = " . $user['shareid']);
}
if (!empty($user2['shareid'])) {
$user3 = pdo_fetch("select * from " . tablename('wwx_fxxt_member') . " where flag=1 and id = " . $user2['shareid']);
}
$info = pdo_fetch("select og.id,og.orderid,og.total,og.price," . $status . $conditionCommission . ", og.commission, og.commission2,og.commission3,og.applytime,og.content,g.title from " . tablename('wwx_fxxt_order_goods') . " as og left join " . tablename('wwx_fxxt_goods') . " as g on og.goodsid = g.id and og.uniacid = g.uniacid where og.id = " . $_GPC['id']);
$order = pdo_fetch("select * from " . tablename('wwx_fxxt_order') . " where id = " . $info['orderid']);
include $this->template('applyed_detail');
die;
}
if ($_GPC['opp'] == 'sort') {
$sort = array('realname' => $_GPC['realname'], 'mobile' => $_GPC['mobile']);
$shareid = "select id from " . tablename('wwx_fxxt_member') . " where uniacid = " . $_W['uniacid'] . " and realname like '%" . $sort['realname'] . "%' and mobile like '%" . $sort['mobile'] . "%'";
$list = pdo_fetchall("select 1 as level,o.shareid,o.status,g.id,g.applytime,g.commission*g.total as commission,g.checktime as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status >= 2) and (o.shareid in (" . $shareid . ")) union all (select 2 as level,o.shareid2 as shareid, o.status, g.id, g.applytime2 as applytime,g.commission2*g.total as commission,g.checktime2 as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status2 >= 2) and (o.shareid2 in (" . $shareid . "))) union all (select 3 as level,o.shareid3 as shareid, o.status, g.id, g.applytime3 as applytime,g.commission3*g.total as commission,g.checktime3 as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status3 >= 2) and (o.shareid3 in (" . $shareid . "))) order by applytime desc ");
$total = sizeof($list);
} else {
$pindex = max(1, intval($_GPC['page']));
$psize = 50;
$list = pdo_fetchall("select 1 as level,o.shareid,o.status,g.id,g.applytime,g.commission*g.total as commission,g.checktime as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status >= 2 and o.shareid!=0) union all (select 2 as level,o.shareid2 as shareid,o.status,g.id,g.applytime2 as applytime,g.commission2*g.total as commission,g.checktime2 as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status2 >= 2 and o.shareid2!=0) )union all (select 3 as level,o.shareid3 as shareid,o.status,g.id,g.applytime3 as applytime,g.commission3*g.total as commission,g.checktime3 as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status3 >= 2 and o.shareid3!=0) ) order by applytime desc limit " . ($pindex - 1) * $psize . "," . $psize);
$total = pdo_fetchcolumn("select count(o.id) from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (o.shareid!=0 ) and (g.status = 2 )");
$total2 = pdo_fetchcolumn("select count(o.id) from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (o.shareid2!=0 ) and (g.status2 = 2 )");
$total3 = pdo_fetchcolumn("select count(o.id) from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (o.shareid3!=0 ) and (g.status3 = 2 )");
$total = $total + $total2 + $total3;
$pager = pagination($total, $pindex, $psize);
}
if (!empty($list)) {
foreach ($list as $key => $l) {
$user = pdo_fetch("select id,shareid from " . tablename('wwx_fxxt_member') . " where flag=1 and id = " . $l['shareid']);
if (empty($user['id'])) {
$list[$key]['commission'] = 0;
$list[$key]['commission2'] = 0;
$list[$key]['commission3'] = 0;
} else {
$user2 = pdo_fetch("select id,shareid from " . tablename('wwx_fxxt_member') . " where flag=1 and id = " . $user['shareid']);
if (empty($user2['id'])) {
$list[$key]['commission2'] = 0;
$list[$key]['commission3'] = 0;
} else {
$user3 = pdo_fetch("select id from " . tablename('wwx_fxxt_member') . " where flag=1 and id = " . $user2['shareid']);
if (empty($user3['id'])) {
$list[$key]['commission3'] = 0;
}
}
}
}
}
include $this->template('applyed');
die;
}
if ($op == 'invalid') {
if ($_GPC['opp'] == 'delete') {
$level = $_GPC['level'];
if (empty($level)) {
message('提交错误');
}
if ($level == 1) {
$delete = array('status' => -2, 'checktime' => time());
}
if ($level == 2) {
$delete = array('status2' => -2, 'checktime2' => time());
}
if ($level == 3) {
$delete = array('status3' => -2, 'checktime3' => time());
}
$temp = pdo_update('wwx_fxxt_order_goods', $delete, array('id' => $_GPC['id']));
if (empty($temp)) {
message('删除失败，请重新删除！', $this->createWebUrl('commission', array('op' => 'invalid')), 'error');
} else {
message('删除成功！', $this->createWebUrl('commission', array('op' => 'invalid')), 'success');
}
}
if ($_GPC['opp'] == 'sort') {
$sort = array('realname' => $_GPC['realname'], 'mobile' => $_GPC['mobile']);
$shareid = "select id from " . tablename('wwx_fxxt_member') . " where uniacid = " . $_W['uniacid'] . " and realname like '%" . $sort['realname'] . "%' and mobile like '%" . $sort['mobile'] . "%'";
$list = pdo_fetchall("select 1 as level,o.shareid, o.status, g.id, g.applytime,g.commission*g.total as commission,g.checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status = -1) and (o.shareid in (" . $shareid . ")) union all (select 2 as level,o.shareid2 as shareid, o.status, g.id, g.applytime2 as applytime,g.commission2*g.total as commission,g.checktime2 as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status2 = -1) and (o.shareid2 in (" . $shareid . "))) union all (select 3 as level,o.shareid3 as shareid, o.status, g.id, g.applytime3 as applytime,g.commission3*g.total as commission,g.checktime3 as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status3 = -1) and (o.shareid3 in (" . $shareid . "))) order by applytime desc ");
$total = sizeof($list);
} else {
$pindex = max(1, intval($_GPC['page']));
$psize = 50;
$list = pdo_fetchall("select 1 as level,o.shareid,o.status, g.id, g.applytime,g.commission*g.total as commission,g.checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status = -1 and o.shareid!=0) union all (select 2 as level,o.shareid2 as shareid,o.status, g.id, g.applytime2 as applytime,g.commission2*g.total as commission,g.checktime2 as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status2 = -1 and o.shareid2!=0) )union all (select 3 as level,o.shareid3 as shareid,o.status, g.id, g.applytime3 as applytime,g.commission3*g.total as commission,g.checktime3 as checktime from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (g.status3 = -1 and o.shareid3!=0) ) order by applytime desc limit " . ($pindex - 1) * $psize . "," . $psize);
$total = pdo_fetchcolumn("select count(o.id) from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (o.shareid!=0 ) and (g.status = -1 )");
$total2 = pdo_fetchcolumn("select count(o.id) from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (o.shareid2!=0 ) and (g.status2 = -1 )");
$total3 = pdo_fetchcolumn("select count(o.id) from " . tablename('wwx_fxxt_order') . " as o left join " . tablename('wwx_fxxt_order_goods') . " as g on o.id = g.orderid and o.uniacid = g.uniacid where o.uniacid = " . $_W['uniacid'] . " and (o.shareid3!=0 ) and (g.status3 = -1 )");
$total = $total + $total2 + $total3;
$pager = pagination($total, $pindex, $psize);
}
include $this->template('invalid');
die;
}
}
public function doWebZhifu()
{
global $_GPC, $_W;
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$pindex = max(1, intval($_GPC['page']));
$psize = 50;
$uniacid = $_W['uniacid'];
$from_user = $_GPC['from_user'];
$op = trim($_GPC['op']) ? trim($_GPC['op']) : 'list';
$cfg = $this->module['config'];
$zhifucommission = $cfg['zhifuCommission'];
if (!$zhifucommission) {
message('请先在参数设置，设置佣金打款限额！', $this->createWebUrl('Commission'), 'success');
}
if (empty($_GPC['mobile'])) {
$mobile = "";
} else {
$mobile = $_GPC['mobile'];
}
if ($op == 'list') {
if ($_GPC['submit'] == '搜 索') {
$sort = array('realname' => $_GPC['realname'], 'mobile' => $_GPC['mobile']);
$list = pdo_fetchall("select * from " . tablename('wwx_fxxt_member') . " where mobile like '%" . $sort['mobile'] . "%' and realname like '%" . $sort['realname'] . "%' and status = 1 and flag = 1 and uniacid = " . $_W['uniacid'] . " order by commission desc");
$total = count($list);
$pager = pagination($total, $pindex, $psize);
include $this->template('zhifu');
die;
}
$total = pdo_fetchcolumn("SELECT COUNT(*) FROM " . tablename('wwx_fxxt_member') . " WHERE status = 1 and flag = 1 AND `uniacid` = :uniacid", array(':uniacid' => $_W['uniacid']));
$pager = pagination($total, $pindex, $psize);
$list = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_member') . " WHERE uniacid=" . $_W['uniacid'] . " AND status = 1 and flag = 1 ORDER BY commission DESC LIMIT " . ($pindex - 1) * $psize . "," . $psize);
include $this->template('zhifu');
}
if ($op == 'post') {
if (empty($_GPC['from_user'])) {
message('请选择会员！', create_url('site/entry', array('do' => 'zhifu', 'op' => 'list', 'm' => 'wwx_fxxt', 'uniacid' => $_W['uniacid'])), 'success');
}
if (checksubmit()) {
$chargenum = round($_GPC['chargenum'], 2);
if (strlen($_GPC['from_user']) < 10) {
message('此用户不是微信端用户，不能使用微信打款！', $this->createWebUrl('zhifu', array('op' => 'post', 'm' => $wwx_fxxt, 'uniacid' => $_W['uniacid'], 'from_user' => $_GPC['from_user'])), 'error');
}
if ($_GPC['realname'] == "") {
$_GPC['realname'] = "未设置";
}
$senduser = array('openid' => $_GPC['from_user'], 'fee' => $chargenum, 'realname' => $_GPC['realname'], 'desc' => '意虎补充付款', 'id' => $_GPC['id']);
$wxret = $this->wxsend($senduser);
if (is_error($wxret)) {
message('微信打款失败：' . $wxret['message'], $this->createWebUrl('zhifu', array('op' => 'post', 'm' => $wwx_fxxt, 'uniacid' => $_W['uniacid'], 'from_user' => $_GPC['from_user'])), 'error');
}
pdo_query('update ' . tablename('wwx_fxxt_member') . ' SET zhifu=zhifu+\'' . $chargenum . "' WHERE from_user='" . $_GPC['from_user'] . "' AND uniacid=" . $_W['uniacid'] . " ");
$paylog = array('type' => 'zhifu', 'uniacid' => $uniacid, 'openid' => $_GPC['from_user'], 'tid' => date('Y-m-d H:i:s'), 'fee' => $chargenum, 'module' => 'wwx_fxxt', 'tag' => ' 后台微信补充打款' . $chargenum . '元,' . $_GPC['content'] . '!');
pdo_insert('core_paylog', $paylog);
message('打款成功！', referer(), 'success');
}
$from_user = $_GPC['from_user'];
$profile = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_member') . " WHERE uniacid = :uniacid AND from_user = :from_user", array(':uniacid' => $_W['uniacid'], ':from_user' => $from_user));
if (!$profile) {
message('请选择会员！', create_url('site/entry', array('do' => 'zhifu', 'op' => 'list', 'm' => 'wwx_fxxt', 'uniacid' => $_W['uniacid'])), 'success');
}
$total = pdo_fetchcolumn("SELECT COUNT(*) FROM " . tablename('core_paylog') . " WHERE openid='" . $_GPC['from_user'] . "' AND type='zhifu' AND `uniacid` = " . $_W['uniacid']);
$pager = pagination($total, $pindex, $psize);
$list = pdo_fetchall("SELECT * FROM " . tablename('core_paylog') . " WHERE openid='" . $_GPC['from_user'] . "' AND type='zhifu' AND uniacid=" . $_W['uniacid'] . " ORDER BY plid DESC LIMIT " . ($pindex - 1) * $psize . "," . $psize);
$mlist = pdo_fetchall("SELECT `name`,`title` FROM " . tablename('modules'));
$mtype = array();
foreach ($mlist as $k => $v) {
$mtype[$v['name']] = $v['title'];
}
include $this->template('zhifu_post');
}
}
public function doWebGoods()
{
global $_GPC, $_W;
load()->func('tpl');
load()->func('file');
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$cfg = $this->module['config'];
$category = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_category') . " WHERE uniacid = '{$_W['uniacid']}' ORDER BY parentid ASC, displayorder DESC", array(), 'id');
if (!empty($category)) {
$children = '';
foreach ($category as $cid => $cate) {
if (!empty($cate['parentid'])) {
$children[$cate['parentid']][$cate['id']] = array($cate['id'], $cate['name']);
}
}
}
$operation = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
if ($operation == 'post') {
$id = intval($_GPC['id']);
if (!empty($id)) {
$item = pdo_fetch("SELECT * FROM " . tablename('wwx_fxxt_goods') . " WHERE id = :id", array(':id' => $id));
if (empty($item)) {
message('抱歉，商品不存在或是已经删除！', '', 'error');
}
$allspecs = pdo_fetchall("select * from " . tablename('wwx_fxxt_spec') . " where goodsid=:id order by displayorder asc", array(":id" => $id));
foreach ($allspecs as &$s) {
$s['items'] = pdo_fetchall("select * from " . tablename('wwx_fxxt_spec_item') . " where specid=:specid order by displayorder asc", array(":specid" => $s['id']));
}
unset($s);
$params = pdo_fetchall("select * from " . tablename('wwx_fxxt_goods_param') . " where goodsid=:id order by displayorder asc", array(':id' => $id));
$piclist = unserialize($item['thumb_url']);
$html = "";
$options = pdo_fetchall("select * from " . tablename('wwx_fxxt_goods_option') . " where goodsid=:id order by id asc", array(':id' => $id));
$specs = array();
if (count($options) > 0) {
$specitemids = explode("_", $options[0]['specs']);
foreach ($specitemids as $itemid) {
foreach ($allspecs as $ss) {
$items = $ss['items'];
foreach ($items as $it) {
if ($it['id'] == $itemid) {
$specs[] = $ss;
break;
}
}
}
}
$html = '';
$html .= '';
$html .= '';
$html .= '';
$len = count($specs);
$newlen = 1;
$h = array();
$rowspans = array();
for ($i = 0; $i < $len; $i++) {
$html .= "| " . $specs[$i]['title'] . " | ";
$itemlen = count($specs[$i]['items']);
if ($itemlen <= 0) {
$itemlen = 1;
}
$newlen *= $itemlen;
$h = array();
for ($j = 0; $j < $newlen; $j++) {
$h[$i][$j] = array();
}
$l = count($specs[$i]['items']);
$rowspans[$i] = 1;
for ($j = $i + 1; $j < $len; $j++) {
$rowspans[$i] *= count($specs[$j]['items']);
}
}
$html .= ' | ';
$html .= ' | ';
$html .= ' | ';
$html .= ' | ';
$html .= ' | ';
$html .= '
';
for ($m = 0; $m < $len; $m++) {
$k = 0;
$kid = 0;
$n = 0;
for ($j = 0; $j < $newlen; $j++) {
$rowspan = $rowspans[$m];
if ($j % $rowspan == 0) {
$h[$m][$j] = array("html" => "" . $specs[$m]['items'][$kid]['title'] . " | ", "id" => $specs[$m]['items'][$kid]['id']);
} else {
$h[$m][$j] = array("html" => "", "id" => $specs[$m]['items'][$kid]['id']);
}
$n++;
if ($n == $rowspan) {
$kid++;
if ($kid > count($specs[$m]['items']) - 1) {
$kid = 0;
}
$n = 0;
}
}
}
$hh = "";
for ($i = 0; $i < $newlen; $i++) {
$hh .= "";
$ids = array();
for ($j = 0; $j < $len; $j++) {
$hh .= $h[$j][$i]['html'];
$ids[] = $h[$j][$i]['id'];
}
$ids = implode("_", $ids);
$val = array("id" => "", "title" => "", "stock" => "", "costprice" => "", "productprice" => "", "marketprice" => "", "weight" => "");
foreach ($options as $o) {
if ($ids === $o['specs']) {
$val = array("id" => $o['id'], "title" => $o['title'], "stock" => $o['stock'], "costprice" => $o['costprice'], "productprice" => $o['productprice'], "marketprice" => $o['marketprice'], "weight" => $o['weight']);
break;
}
}
$hh .= '| ';
$hh .= ' | ';
$hh .= '';
$hh .= '';
$hh .= '';
$hh .= '';
$hh .= ' | ';
$hh .= ' | ';
$hh .= ' | ';
$hh .= ' | ';
$hh .= '
';
}
$html .= $hh;
$html .= "
";
}
}
if (empty($category)) {
message('抱歉，请您先添加商品分类！', $this->createWebUrl('category', array('op' => 'post')), 'error');
}
if (checksubmit('submit')) {
if (empty($_GPC['goodsname'])) {
message('请输入商品名称！');
}
if (empty($_GPC['pcate'])) {
message('请选择商品分类！');
}
if (empty($_GPC['thumbs'])) {
$_GPC['thumbs'] = array();
}
$data = array('uniacid' => intval($_W['uniacid']), 'displayorder' => intval($_GPC['displayorder']), 'title' => $_GPC['goodsname'], 'pcate' => intval($_GPC['pcate']), 'ccate' => intval($_GPC['ccate']), 'thumb' => $_GPC['thumb'], 'type' => intval($_GPC['type']), 'isrecommand' => intval($_GPC['isrecommand']), 'ishot' => intval($_GPC['ishot']), 'isnew' => intval($_GPC['isnew']), 'isdiscount' => intval($_GPC['isdiscount']), 'istime' => intval($_GPC['istime']), 'issendfree' => intval($_GPC['issendfree']), 'timestart' => strtotime($_GPC['timestart']), 'timeend' => strtotime($_GPC['timeend']), 'description' => $_GPC['description'], 'content' => htmlspecialchars_decode($_GPC['content']), 'goodssn' => $_GPC['goodssn'], 'unit' => $_GPC['unit'], 'createtime' => TIMESTAMP, 'total' => intval($_GPC['total']), 'totalcnf' => intval($_GPC['totalcnf']), 'marketprice' => $_GPC['marketprice'], 'weight' => $_GPC['weight'], 'costprice' => $_GPC['costprice'], 'productprice' => $_GPC['productprice'], 'productsn' => $_GPC['productsn'], 'credit' => intval($_GPC['credit']), 'maxbuy' => intval($_GPC['maxbuy']),'usermaxbuy'=>intval($_GPC['usermaxbuy']), 'commission' => intval($_GPC['commission']), 'commission2' => intval($_GPC['commission2']), 'commission3' => intval($_GPC['commission3']), 'hasoption' => intval($_GPC['hasoption']), 'sales' => intval($_GPC['sales']), 'status' => intval($_GPC['status']), 'xsthumb' => $_GPC['xsthumb']);
if (is_array($_GPC['thumbs'])) {
$data['thumb_url'] = serialize($_GPC['thumbs']);
}
if (empty($id)) {
pdo_insert('wwx_fxxt_goods', $data);
$id = pdo_insertid();
} else {
unset($data['createtime']);
pdo_update('wwx_fxxt_goods', $data, array('id' => $id));
}
$totalstocks = 0;
$param_ids = $_POST['param_id'];
$param_titles = $_POST['param_title'];
$param_values = $_POST['param_value'];
$param_displayorders = $_POST['param_displayorder'];
$len = count($param_ids);
$paramids = array();
for ($k = 0; $k < $len; $k++) {
$param_id = "";
$get_param_id = $param_ids[$k];
$a = array("title" => $param_titles[$k], "value" => $param_values[$k], "displayorder" => $k, "goodsid" => $id);
if (!is_numeric($get_param_id)) {
pdo_insert("wwx_fxxt_goods_param", $a);
$param_id = pdo_insertid();
} else {
pdo_update('wwx_fxxt_goods_param', $a, array('id' => $get_param_id));
$param_id = $get_param_id;
}
$paramids[] = $param_id;
}
if (count($paramids) > 0) {
pdo_query("delete from " . tablename('wwx_fxxt_goods_param') . " where goodsid={$id} and id not in ( " . implode(',', $paramids) . ")");
} else {
pdo_query('delete from ' . tablename('wwx_fxxt_goods_param') . " where goodsid={$id}");
}
$files = $_FILES;
$spec_ids = $_POST['spec_id'];
$spec_titles = $_POST['spec_title'];
$specids = array();
$len = count($spec_ids);
$specids = array();
$spec_items = array();
for ($k = 0; $k < $len; $k++) {
$spec_id = "";
$get_spec_id = $spec_ids[$k];
$a = array("uniacid" => $_W['uniacid'], "goodsid" => $id, "displayorder" => $k, "title" => $spec_titles[$get_spec_id]);
if (is_numeric($get_spec_id)) {
pdo_update("wwx_fxxt_spec", $a, array("id" => $get_spec_id));
$spec_id = $get_spec_id;
} else {
pdo_insert('wwx_fxxt_spec', $a);
$spec_id = pdo_insertid();
}
$spec_item_ids = $_POST["spec_item_id_" . $get_spec_id];
$spec_item_titles = $_POST["spec_item_title_" . $get_spec_id];
$spec_item_shows = $_POST["spec_item_show_" . $get_spec_id];
$spec_item_thumbs = $_POST["spec_item_thumb_" . $get_spec_id];
$spec_item_oldthumbs = $_POST["spec_item_oldthumb_" . $get_spec_id];
$itemlen = count($spec_item_ids);
$itemids = array();
for ($n = 0; $n < $itemlen; $n++) {
$item_id = "";
$get_item_id = $spec_item_ids[$n];
$d = array("uniacid" => $_W['uniacid'], "goodsid" => $id, "specid" => $spec_id, "displayorder" => $n, "title" => $spec_item_titles[$n], "show" => $spec_item_shows[$n], "thumb" => $spec_item_thumbs[$n]);
$f = "spec_item_thumb_" . $get_item_id;
if (is_numeric($get_item_id)) {
pdo_update("wwx_fxxt_spec_item", $d, array("id" => $get_item_id));
$item_id = $get_item_id;
} else {
pdo_insert('wwx_fxxt_spec_item', $d);
$item_id = pdo_insertid();
}
$itemids[] = $item_id;
$d['get_id'] = $get_item_id;
$d['id'] = $item_id;
$spec_items[] = $d;
}
if (count($itemids) > 0) {
pdo_query("delete from " . tablename('wwx_fxxt_spec_item') . " where uniacid={$_W['uniacid']} and specid={$spec_id} and id not in (" . implode(",", $itemids) . ")");
} else {
pdo_query('delete from ' . tablename('wwx_fxxt_spec_item') . " where uniacid={$_W['uniacid']} and specid={$spec_id}");
}
pdo_update('wwx_fxxt_spec', array('content' => serialize($itemids)), array("id" => $spec_id));
$specids[] = $spec_id;
}
if (count($specids) > 0) {
pdo_query("delete from " . tablename('wwx_fxxt_spec') . " where uniacid={$_W['uniacid']} and goodsid={$id} and id not in (" . implode(",", $specids) . ")");
} else {
pdo_query('delete from ' . tablename('wwx_fxxt_spec') . " where uniacid={$_W['uniacid']} and goodsid={$id}");
}
$option_idss = $_POST['option_ids'];
$option_productprices = $_POST['option_productprice'];
$option_marketprices = $_POST['option_marketprice'];
$option_costprices = $_POST['option_costprice'];
$option_stocks = $_POST['option_stock'];
$option_weights = $_POST['option_weight'];
$len = count($option_idss);
$optionids = array();
for ($k = 0; $k < $len; $k++) {
$option_id = "";
$get_option_id = $_GPC['option_id_' . $ids][0];
$ids = $option_idss[$k];
$idsarr = explode("_", $ids);
$newids = array();
foreach ($idsarr as $key => $ida) {
foreach ($spec_items as $it) {
if ($it['get_id'] == $ida) {
$newids[] = $it['id'];
break;
}
}
}
$newids = implode("_", $newids);
$a = array("title" => $_GPC['option_title_' . $ids][0], "productprice" => $_GPC['option_productprice_' . $ids][0], "costprice" => $_GPC['option_costprice_' . $ids][0], "marketprice" => $_GPC['option_marketprice_' . $ids][0], "stock" => $_GPC['option_stock_' . $ids][0], "weight" => $_GPC['option_weight_' . $ids][0], "goodsid" => $id, "specs" => $newids);
$totalstocks += $a['stock'];
if (empty($get_option_id)) {
pdo_insert("wwx_fxxt_goods_option", $a);
$option_id = pdo_insertid();
} else {
pdo_update('wwx_fxxt_goods_option', $a, array('id' => $get_option_id));
$option_id = $get_option_id;
}
$optionids[] = $option_id;
}
if (count($optionids) > 0) {
pdo_query("delete from " . tablename('wwx_fxxt_goods_option') . " where goodsid={$id} and id not in ( " . implode(',', $optionids) . ")");
} else {
pdo_query('delete from ' . tablename('wwx_fxxt_goods_option') . " where goodsid={$id}");
}
if ($totalstocks > 0) {
pdo_update("wwx_fxxt_goods", array("total" => $totalstocks), array("id" => $id));
}
message('商品更新成功！', $this->createWebUrl('goods', array('op' => 'post', 'id' => $id)), 'success');
}
} elseif ($operation == 'display') {
$pindex = max(1, intval($_GPC['page']));
$psize = 50;
$condition = '';
if (!empty($_GPC['keyword'])) {
$condition .= " AND title LIKE '%{$_GPC['keyword']}%'";
}
if (!empty($_GPC['cate_2'])) {
$cid = intval($_GPC['cate_2']);
$condition .= " AND ccate = '{$cid}'";
} elseif (!empty($_GPC['cate_1'])) {
$cid = intval($_GPC['cate_1']);
$condition .= " AND pcate = '{$cid}'";
}
if (isset($_GPC['status'])) {
$condition .= " AND status = '" . intval($_GPC['status']) . "'";
}
$list = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_goods') . " WHERE uniacid = '{$_W['uniacid']}' and deleted=0 {$condition} ORDER BY status DESC, displayorder DESC, id DESC LIMIT " . ($pindex - 1) * $psize . ',' . $psize);
$total = pdo_fetchcolumn('SELECT COUNT(*) FROM ' . tablename('wwx_fxxt_goods') . " WHERE uniacid = '{$_W['uniacid']}' and deleted=0 {$condition}");
$pager = pagination($total, $pindex, $psize);
} elseif ($operation == 'delete') {
$id = intval($_GPC['id']);
$row = pdo_fetch("SELECT id,thumb FROM " . tablename('wwx_fxxt_goods') . " WHERE id = :id", array(':id' => $id));
if (empty($row)) {
message('抱歉，商品不存在或是已经被删除！');
}
pdo_query('delete from ' . tablename('wwx_fxxt_goods') . " where uniacid={$_W['uniacid']} and id={$id}");
pdo_query('delete from ' . tablename('wwx_fxxt_goods_option') . " where goodsid={$id}");
pdo_query('delete from ' . tablename('wwx_fxxt_goods_param') . " where goodsid={$id}");
pdo_query('delete from ' . tablename('wwx_fxxt_spec') . " where uniacid={$_W['uniacid']} and goodsid={$id}");
pdo_query('delete from ' . tablename('wwx_fxxt_spec_item') . " where uniacid={$_W['uniacid']} and goodsid={$id}");
message('删除成功！', referer(), 'success');
}
include $this->template('goods');
}
public function doWebCategory()
{
global $_W, $_GPC;
load()->func('tpl');
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$uniacid = $_W['uniacid'];
$op = $operation = $_GPC['op'] ? $_GPC['op'] : 'display';
$modules = 'category';
$operation = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
if ($operation == 'display') {
if (!empty($_GPC['displayorder'])) {
foreach ($_GPC['displayorder'] as $id => $displayorder) {
pdo_update('wwx_fxxt_category', array('displayorder' => $displayorder), array('id' => $id));
}
message('分类排序更新成功！', $this->createWebUrl('category', array('op' => 'display')), 'success');
}
$children = array();
$category = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_category') . " WHERE uniacid = '{$_W['uniacid']}' ORDER BY parentid ASC, displayorder DESC");
foreach ($category as $index => $row) {
if (!empty($row['parentid'])) {
$children[$row['parentid']][] = $row;
unset($category[$index]);
}
}
include $this->template('category');
} elseif ($operation == 'post') {
$parentid = intval($_GPC['parentid']);
$id = intval($_GPC['id']);
if (!empty($id)) {
$category = pdo_fetch("SELECT * FROM " . tablename('wwx_fxxt_category') . " WHERE id = '{$id}'");
} else {
$category = array('displayorder' => 0);
}
if (!empty($parentid)) {
$parent = pdo_fetch("SELECT id, name FROM " . tablename('wwx_fxxt_category') . " WHERE id = '{$parentid}'");
if (empty($parent)) {
message('抱歉，上级分类不存在或是已经被删除！', $this->createWebUrl('post'), 'error');
}
}
if (checksubmit('submit')) {
if (empty($_GPC['catename'])) {
message('抱歉，请输入分类名称！');
}
$data = array('uniacid' => $_W['uniacid'], 'name' => $_GPC['catename'], 'enabled' => intval($_GPC['enabled']), 'displayorder' => intval($_GPC['displayorder']), 'isrecommand' => intval($_GPC['isrecommand']), 'description' => $_GPC['description'], 'parentid' => intval($parentid));
$data['thumb'] = $_GPC['thumb'];
if (!empty($id)) {
unset($data['parentid']);
pdo_update('wwx_fxxt_category', $data, array('id' => $id, 'uniacid' => $_W['uniacid']));
} else {
pdo_insert('wwx_fxxt_category', $data);
$id = pdo_insertid();
}
message('更新分类成功！', $this->createWebUrl('category', array('op' => 'display')), 'success');
}
include $this->template('category');
} elseif ($operation == 'delete') {
$id = intval($_GPC['id']);
$category = pdo_fetch("SELECT id, parentid FROM " . tablename('wwx_fxxt_category') . " WHERE id = '{$id}' and uniacid = '{$_W['uniacid']}'");
if (empty($category)) {
message('抱歉，分类不存在或是已经被删除！', $this->createWebUrl('category', array('op' => 'display')), 'error');
}
pdo_delete('wwx_fxxt_category', array('id' => $id, 'parentid' => $id), 'OR');
message('分类删除成功！', $this->createWebUrl('category', array('op' => 'display')), 'success');
}
}
public function doWebSetGoodsProperty()
{
global $_GPC, $_W;
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$id = intval($_GPC['id']);
$type = $_GPC['type'];
$data = intval($_GPC['data']);
empty($data) ? $data = 1 : ($data = 0);
if (!in_array($type, array('new', 'hot', 'recommand', 'discount', 'status', 'sendfree'))) {
die(json_encode(array("result" => 0)));
}
if ($_GPC['type'] == 'status') {
pdo_update("wwx_fxxt_goods", array($type => $data), array("id" => $id, "uniacid" => $_W['uniacid']));
} else {
pdo_update('wwx_fxxt_goods', array('is' . $type => $data), array("id" => $id, "uniacid" => $_W['uniacid']));
}
die(json_encode(array('result' => 1, 'data' => $data)));
}
public function doWebSpec()
{
global $_GPC;
$spec = array("id" => random(32), "title" => $_GPC['title']);
include $this->template('spec');
}
public function doWebSpecItem()
{
global $_GPC;
load()->func('tpl');
$spec = array("id" => $_GPC['specid']);
$specitem = array("id" => random(32), "title" => $_GPC['title'], "show" => 1);
include $this->template('spec_item');
}
public function doWebParam()
{
$tag = random(32);
global $_GPC;
include $this->template('param');
}
public function doWebShopadmin()
{
global $_GPC, $_W;
load()->func('tpl');
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$operation = empty($_GPC['op']) ? 'display' : $_GPC['op'];
$operation = in_array($operation, array('display')) ? $operation : 'display';
$cfg = $this->module['config'];
if ($_W['ispost']) {
set_time_limit(0);
$ret = array();
$url = $_GPC['url'];
$pcate = intval($_GPC['pcate']);
$ccate = intval($_GPC['ccate']);
$into_shop = intval($_GPC['into_shop']);
if (is_numeric($url)) {
$itemid = $url;
$url = "https://item.taobao.com/item.htm?id=" . $itemid;
} else {
preg_match('/id\\=(\\d+)/i', $url, $matches);
if (isset($matches[1])) {
$itemid = $matches[1];
$url = "https://item.taobao.com/item.htm?id=" . $itemid;
}
}
if (empty($itemid)) {
die(json_encode(array("result" => 0, "error" => "未获取到 itemid!")));
}
if ($_W['user']['collection'] < 1) {
die(json_encode(array("result" => 0, "error" => "您的采集数不足，请充值后继续操作!")));
}
die(json_encode($this->get_item_taobao($itemid, $into_shop, $url, $pcate, $ccate)));
}
$category = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_category') . " WHERE uniacid = '{$_W['uniacid']}' ORDER BY parentid ASC, displayorder DESC", array(), 'id');
if (!empty($category)) {
$children = '';
foreach ($category as $cid => $cate) {
if (!empty($cate['parentid'])) {
$children[$cate['parentid']][$cate['id']] = array($cate['id'], $cate['name']);
}
}
}
if (empty($category)) {
message('抱歉，请您先添加商品分类！', $this->createWebUrl('category', array('op' => 'post')), 'error');
}
include $this->template('shopadmin');
}
public function doWebShopmany()
{
global $_W;
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$category = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_category') . " WHERE uniacid = '{$_W['uniacid']}' ORDER BY parentid ASC, displayorder DESC", array(), 'id');
if (!empty($category)) {
$children = '';
foreach ($category as $cid => $cate) {
if (!empty($cate['parentid'])) {
$children[$cate['parentid']][$cate['id']] = array($cate['id'], $cate['name']);
}
}
}
if (empty($category)) {
message('抱歉，请您先添加商品分类！', $this->createWebUrl('category', array('op' => 'post')), 'error');
}
include $this->template('shopmany');
}
public function doWebShopwhole()
{
set_time_limit(0);
global $_W, $_GPC;
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$op = $_GPC['op'];
include $this->template('shopwhole');
}
public function doWebShopgoods()
{
global $_GPC, $_W;
load()->func('tpl');
load()->func('file');
$cfg = $this->module['config'];
$this->doWebAuth();
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$category = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_category') . " WHERE uniacid = '{$_W['uniacid']}' ORDER BY parentid ASC, displayorder DESC", array(), 'id');
if (!empty($category)) {
$children = '';
foreach ($category as $cid => $cate) {
if (!empty($cate['parentid'])) {
$children[$cate['parentid']][$cate['id']] = array($cate['id'], $cate['name']);
}
}
}
$operation = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
if ($operation == 'post') {
$id = intval($_GPC['id']);
if (!empty($id)) {
$item = pdo_fetch("SELECT * FROM " . tablename('wwx_fxxt_shop_goods') . " WHERE id = :id", array(':id' => $id));
if (empty($item)) {
message('抱歉，商品不存在或是已经删除！', '', 'error');
}
$allspecs = pdo_fetchall("select * from " . tablename('wwx_fxxt_shop_spec') . " where goodsid=:id order by displayorder asc", array(":id" => $id));
foreach ($allspecs as &$s) {
$s['items'] = pdo_fetchall("select * from " . tablename('wwx_fxxt_shop_spec_item') . " where specid=:specid order by displayorder asc", array(":specid" => $s['id']));
}
unset($s);
$params = pdo_fetchall("select * from " . tablename('wwx_fxxt_shop_goods_param') . " where goodsid=:id order by displayorder asc", array(':id' => $id));
$piclist = unserialize($item['thumb_url']);
$html = "";
$options = pdo_fetchall("select * from " . tablename('wwx_fxxt_shop_goods_option') . " where goodsid=:id order by id asc", array(':id' => $id));
$specs = array();
if (count($options) > 0) {
$specitemids = explode("_", $options[0]['specs']);
foreach ($specitemids as $itemid) {
foreach ($allspecs as $ss) {
$items = $ss['items'];
foreach ($items as $it) {
if ($it['id'] == $itemid) {
$specs[] = $ss;
break;
}
}
}
}
$html = '';
$html .= '';
$html .= '';
$html .= '';
$len = count($specs);
$newlen = 1;
$h = array();
$rowspans = array();
for ($i = 0; $i < $len; $i++) {
$html .= "| " . $specs[$i]['title'] . " | ";
$itemlen = count($specs[$i]['items']);
if ($itemlen <= 0) {
$itemlen = 1;
}
$newlen *= $itemlen;
$h = array();
for ($j = 0; $j < $newlen; $j++) {
$h[$i][$j] = array();
}
$l = count($specs[$i]['items']);
$rowspans[$i] = 1;
for ($j = $i + 1; $j < $len; $j++) {
$rowspans[$i] *= count($specs[$j]['items']);
}
}
$html .= ' | ';
$html .= ' | ';
$html .= ' | ';
$html .= ' | ';
$html .= ' | ';
$html .= '
';
for ($m = 0; $m < $len; $m++) {
$k = 0;
$kid = 0;
$n = 0;
for ($j = 0; $j < $newlen; $j++) {
$rowspan = $rowspans[$m];
if ($j % $rowspan == 0) {
$h[$m][$j] = array("html" => "" . $specs[$m]['items'][$kid]['title'] . " | ", "id" => $specs[$m]['items'][$kid]['id']);
} else {
$h[$m][$j] = array("html" => "", "id" => $specs[$m]['items'][$kid]['id']);
}
$n++;
if ($n == $rowspan) {
$kid++;
if ($kid > count($specs[$m]['items']) - 1) {
$kid = 0;
}
$n = 0;
}
}
}
$hh = "";
for ($i = 0; $i < $newlen; $i++) {
$hh .= "";
$ids = array();
for ($j = 0; $j < $len; $j++) {
$hh .= $h[$j][$i]['html'];
$ids[] = $h[$j][$i]['id'];
}
$ids = implode("_", $ids);
$val = array("id" => "", "title" => "", "stock" => "", "costprice" => "", "productprice" => "", "marketprice" => "", "weight" => "");
foreach ($options as $o) {
if ($ids === $o['specs']) {
$val = array("id" => $o['id'], "title" => $o['title'], "stock" => $o['stock'], "costprice" => $o['costprice'], "productprice" => $o['productprice'], "marketprice" => $o['marketprice'], "weight" => $o['weight']);
break;
}
}
$hh .= '| ';
$hh .= ' | ';
$hh .= '';
$hh .= '';
$hh .= '';
$hh .= '';
$hh .= ' | ';
$hh .= ' | ';
$hh .= ' | ';
$hh .= ' | ';
$hh .= '
';
}
$html .= $hh;
$html .= "
";
}
}
if (empty($category)) {
message('抱歉，请您先添加商品分类！', $this->createWebUrl('category', array('op' => 'post')), 'error');
}
if (checksubmit('submit')) {
if (empty($_GPC['goodsname'])) {
message('请输入商品名称！');
}
if (empty($_GPC['pcate'])) {
message('请选择商品分类！');
}
if (empty($_GPC['thumbs'])) {
$_GPC['thumbs'] = array();
}
$data = array('uniacid' => intval($_W['uniacid']), 'displayorder' => intval($_GPC['displayorder']), 'title' => $_GPC['goodsname'], 'pcate' => intval($_GPC['pcate']), 'ccate' => intval($_GPC['ccate']), 'thumb' => $_GPC['thumb'], 'type' => intval($_GPC['type']), 'isrecommand' => intval($_GPC['isrecommand']), 'ishot' => intval($_GPC['ishot']), 'isnew' => intval($_GPC['isnew']), 'isdiscount' => intval($_GPC['isdiscount']), 'istime' => intval($_GPC['istime']), 'issendfree' => intval($_GPC['issendfree']), 'timestart' => strtotime($_GPC['timestart']), 'timeend' => strtotime($_GPC['timeend']), 'description' => $_GPC['description'], 'content' => htmlspecialchars_decode($_GPC['content']), 'goodssn' => $_GPC['goodssn'], 'unit' => $_GPC['unit'], 'createtime' => TIMESTAMP, 'total' => intval($_GPC['total']), 'totalcnf' => intval($_GPC['totalcnf']), 'marketprice' => $_GPC['marketprice'], 'weight' => $_GPC['weight'], 'costprice' => $_GPC['costprice'], 'productprice' => $_GPC['productprice'], 'productsn' => $_GPC['productsn'], 'credit' => intval($_GPC['credit']), 'maxbuy' => intval($_GPC['maxbuy']), 'usermaxbuy' => intval($_GPC['usermaxbuy']),'commission' => intval($_GPC['commission']), 'commission2' => intval($_GPC['commission2']), 'commission3' => intval($_GPC['commission3']), 'hasoption' => intval($_GPC['hasoption']), 'sales' => intval($_GPC['sales']), 'status' => intval($_GPC['status']), 'xsthumb' => $_GPC['xsthumb']);
if (is_array($_GPC['thumbs'])) {
$data['thumb_url'] = serialize($_GPC['thumbs']);
}
if (empty($id)) {
pdo_insert('wwx_fxxt_shop_goods', $data);
$id = pdo_insertid();
} else {
unset($data['createtime']);
pdo_update('wwx_fxxt_shop_goods', $data, array('id' => $id));
}
$totalstocks = 0;
$param_ids = $_POST['param_id'];
$param_titles = $_POST['param_title'];
$param_values = $_POST['param_value'];
$param_displayorders = $_POST['param_displayorder'];
$len = count($param_ids);
$paramids = array();
for ($k = 0; $k < $len; $k++) {
$param_id = "";
$get_param_id = $param_ids[$k];
$a = array("title" => $param_titles[$k], "value" => $param_values[$k], "displayorder" => $k, "goodsid" => $id);
if (!is_numeric($get_param_id)) {
pdo_insert("wwx_fxxt_shop_goods_param", $a);
$param_id = pdo_insertid();
} else {
pdo_update('wwx_fxxt_shop_goods_param', $a, array('id' => $get_param_id));
$param_id = $get_param_id;
}
$paramids[] = $param_id;
}
if (count($paramids) > 0) {
pdo_query("delete from " . tablename('wwx_fxxt_shop_goods_param') . " where goodsid={$id} and id not in ( " . implode(',', $paramids) . ")");
} else {
pdo_query('delete from ' . tablename('wwx_fxxt_shop_goods_param') . " where goodsid={$id}");
}
$files = $_FILES;
$spec_ids = $_POST['spec_id'];
$spec_titles = $_POST['spec_title'];
$specids = array();
$len = count($spec_ids);
$specids = array();
$spec_items = array();
for ($k = 0; $k < $len; $k++) {
$spec_id = "";
$get_spec_id = $spec_ids[$k];
$a = array("uniacid" => $_W['uniacid'], "goodsid" => $id, "displayorder" => $k, "title" => $spec_titles[$get_spec_id]);
if (is_numeric($get_spec_id)) {
pdo_update("wwx_fxxt_shop_spec", $a, array("id" => $get_spec_id));
$spec_id = $get_spec_id;
} else {
pdo_insert('wwx_fxxt_shop_spec', $a);
$spec_id = pdo_insertid();
}
$spec_item_ids = $_POST["spec_item_id_" . $get_spec_id];
$spec_item_titles = $_POST["spec_item_title_" . $get_spec_id];
$spec_item_shows = $_POST["spec_item_show_" . $get_spec_id];
$spec_item_thumbs = $_POST["spec_item_thumb_" . $get_spec_id];
$spec_item_oldthumbs = $_POST["spec_item_oldthumb_" . $get_spec_id];
$itemlen = count($spec_item_ids);
$itemids = array();
for ($n = 0; $n < $itemlen; $n++) {
$item_id = "";
$get_item_id = $spec_item_ids[$n];
$d = array("uniacid" => $_W['uniacid'], "goodsid" => $id, "specid" => $spec_id, "displayorder" => $n, "title" => $spec_item_titles[$n], "show" => $spec_item_shows[$n], "thumb" => $spec_item_thumbs[$n]);
$f = "spec_item_thumb_" . $get_item_id;
if (is_numeric($get_item_id)) {
pdo_update("wwx_fxxt_shop_spec_item", $d, array("id" => $get_item_id));
$item_id = $get_item_id;
} else {
pdo_insert('wwx_fxxt_shop_spec_item', $d);
$item_id = pdo_insertid();
}
$itemids[] = $item_id;
$d['get_id'] = $get_item_id;
$d['id'] = $item_id;
$spec_items[] = $d;
}
if (count($itemids) > 0) {
pdo_query("delete from " . tablename('wwx_fxxt_shop_spec_item') . " where uniacid={$_W['uniacid']} and specid={$spec_id} and id not in (" . implode(",", $itemids) . ")");
} else {
pdo_query('delete from ' . tablename('wwx_fxxt_shop_spec_item') . " where uniacid={$_W['uniacid']} and specid={$spec_id}");
}
pdo_update('wwx_fxxt_shop_spec', array('content' => serialize($itemids)), array("id" => $spec_id));
$specids[] = $spec_id;
}
if (count($specids) > 0) {
pdo_query("delete from " . tablename('wwx_fxxt_shop_spec') . " where uniacid={$_W['uniacid']} and goodsid={$id} and id not in (" . implode(",", $specids) . ")");
} else {
pdo_query('delete from ' . tablename('wwx_fxxt_shop_spec') . " where uniacid={$_W['uniacid']} and goodsid={$id}");
}
$option_idss = $_POST['option_ids'];
$option_productprices = $_POST['option_productprice'];
$option_marketprices = $_POST['option_marketprice'];
$option_costprices = $_POST['option_costprice'];
$option_stocks = $_POST['option_stock'];
$option_weights = $_POST['option_weight'];
$len = count($option_idss);
$optionids = array();
for ($k = 0; $k < $len; $k++) {
$option_id = "";
$get_option_id = $_GPC['option_id_' . $ids][0];
$ids = $option_idss[$k];
$idsarr = explode("_", $ids);
$newids = array();
foreach ($idsarr as $key => $ida) {
foreach ($spec_items as $it) {
if ($it['get_id'] == $ida) {
$newids[] = $it['id'];
break;
}
}
}
$newids = implode("_", $newids);
$a = array("title" => $_GPC['option_title_' . $ids][0], "productprice" => $_GPC['option_productprice_' . $ids][0], "costprice" => $_GPC['option_costprice_' . $ids][0], "marketprice" => $_GPC['option_marketprice_' . $ids][0], "stock" => $_GPC['option_stock_' . $ids][0], "weight" => $_GPC['option_weight_' . $ids][0], "goodsid" => $id, "specs" => $newids);
$totalstocks += $a['stock'];
if (empty($get_option_id)) {
pdo_insert("wwx_fxxt_shop_goods_option", $a);
$option_id = pdo_insertid();
} else {
pdo_update('wwx_fxxt_shop_goods_option', $a, array('id' => $get_option_id));
$option_id = $get_option_id;
}
$optionids[] = $option_id;
}
if (count($optionids) > 0) {
pdo_query("delete from " . tablename('wwx_fxxt_shop_goods_option') . " where goodsid={$id} and id not in ( " . implode(',', $optionids) . ")");
} else {
pdo_query('delete from ' . tablename('wwx_fxxt_shop_goods_option') . " where goodsid={$id}");
}
if ($totalstocks > 0) {
pdo_update("wwx_fxxt_shop_goods", array("total" => $totalstocks), array("id" => $id));
}
message('商品更新成功！', $this->createWebUrl('shopgoods', array('op' => 'post', 'id' => $id)), 'success');
}
} elseif ($operation == 'display') {
$pindex = max(1, intval($_GPC['page']));
$psize = 50;
$condition = '';
if (!empty($_GPC['keyword'])) {
$condition .= " AND title LIKE '%{$_GPC['keyword']}%'";
}
if (!empty($_GPC['cate_2'])) {
$cid = intval($_GPC['cate_2']);
$condition .= " AND ccate = '{$cid}'";
} elseif (!empty($_GPC['cate_1'])) {
$cid = intval($_GPC['cate_1']);
$condition .= " AND pcate = '{$cid}'";
}
if (isset($_GPC['status'])) {
$condition .= " AND status = '" . intval($_GPC['status']) . "'";
}
$list = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_shop_goods') . " WHERE uniacid = '{$_W['uniacid']}' and deleted=0 {$condition} ORDER BY status DESC, displayorder DESC, id DESC LIMIT " . ($pindex - 1) * $psize . ',' . $psize);
$total = pdo_fetchcolumn('SELECT COUNT(*) FROM ' . tablename('wwx_fxxt_shop_goods') . " WHERE uniacid = '{$_W['uniacid']}' and deleted=0 {$condition}");
$pager = pagination($total, $pindex, $psize);
} elseif ($operation == 'delete') {
$id = intval($_GPC['id']);
$row = pdo_fetch("SELECT id,thumb,status FROM " . tablename('wwx_fxxt_shop_goods') . " WHERE id = :id", array(':id' => $id));
if (empty($row)) {
message('抱歉，商品不存在或是已经被删除！');
}
$picedel = pdo_fetchall("select * from " . tablename("wwx_fxxt_shop_picture_address") . " where uniacid={$_W['uniacid']} and goodsid=:goodsid order by id asc", array(":goodsid" => $id));
foreach ($picedel as $del) {
if (file_exists($del['thumb'])) {
if (empty($row['status'])) {
unlink($del['thumb']);
}
}
pdo_query('delete from ' . tablename('wwx_fxxt_shop_picture_address') . " where id={$del['id']}");
}
pdo_query('delete from ' . tablename('wwx_fxxt_shop_goods') . " where uniacid={$_W['uniacid']} and id={$id}");
pdo_query('delete from ' . tablename('wwx_fxxt_shop_goods_option') . " where goodsid={$id}");
pdo_query('delete from ' . tablename('wwx_fxxt_shop_goods_param') . " where goodsid={$id}");
pdo_query('delete from ' . tablename('wwx_fxxt_shop_spec') . " where uniacid={$_W['uniacid']} and goodsid={$id}");
pdo_query('delete from ' . tablename('wwx_fxxt_shop_spec_item') . " where uniacid={$_W['uniacid']} and goodsid={$id}");
message('删除成功！', referer(), 'success');
} elseif ($operation == 'deleteout') {
$rowshop = pdo_fetchall("SELECT id,thumb,status FROM " . tablename('wwx_fxxt_shop_goods') . " WHERE uniacid = :uniacid", array(':uniacid' => $_W['uniacid']));
if (empty($rowshop)) {
message('抱歉，商品不存在或是已经被删除！');
}
foreach ($rowshop as $shopid) {
$picedel = pdo_fetchall("select * from " . tablename("wwx_fxxt_shop_picture_address") . " where uniacid={$_W['uniacid']} and goodsid=:goodsid order by id asc", array(":goodsid" => $shopid['id']));
foreach ($picedel as $del) {
if (file_exists($del['thumb'])) {
if (empty($shopid['status'])) {
unlink($del['thumb']);
}
}
pdo_query('delete from ' . tablename('wwx_fxxt_shop_picture_address') . " where id={$del['id']}");
}
pdo_query('delete from ' . tablename('wwx_fxxt_shop_goods') . " where uniacid={$_W['uniacid']} and id={$shopid['id']}");
pdo_query('delete from ' . tablename('wwx_fxxt_shop_goods_option') . " where goodsid={$shopid['id']}");
pdo_query('delete from ' . tablename('wwx_fxxt_shop_goods_param') . " where goodsid={$shopid['id']}");
pdo_query('delete from ' . tablename('wwx_fxxt_shop_spec') . " where uniacid={$_W['uniacid']} and goodsid={$shopid['id']}");
pdo_query('delete from ' . tablename('wwx_fxxt_shop_spec_item') . " where uniacid={$_W['uniacid']} and goodsid={$shopid['id']}");
}
message('删除成功！', referer(), 'success');
} elseif ($operation == 'copy') {
$id = intval($_GPC['id']);
$idArr = $_GPC['idArr'];
if (empty($id) && empty($idArr)) {
$this->message("参数错误!");
}
if (!empty($id)) {
$this->copy_goods($id);
message('宝贝导入成功!', referer(), 'success');
} else {
if (!empty($idArr)) {
foreach ($_GPC['idArr'] as $k => $id) {
$id = intval($id);
$this->copy_goods($id);
}
$this->message('宝贝已经批量导入成功！', '', 0);
}
}
}
include $this->template('shopgoods');
}
public function doWebShopcollection()
{
global $_W, $_GPC;
$accountname = $_GPC['accountname'];
$accountsum = intval($_GPC['accountsum']);
$id = intval($_GPC['id']);
$operation = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
if (!$_W['isfounder']) {
message('不能访问,此功能只有站长才有操作权限.');
}
if ($operation == 'chongzhi') {
if ($accountsum < 1) {
message('充值点数错误,请返回重新填写.');
}
$accountuid = pdo_fetch("select uid,collection from " . tablename('users') . " where username='{$accountname}' limit 1 ");
if (empty($accountuid)) {
message('没有找到此用户,请检查.');
}
pdo_update('users', array('collection' => $accountuid['collection'] + $accountsum), array("uid" => $accountuid['uid']));
message('充值点数成功！', $this->createWebUrl('shopcollection', array('op' => 'display')), 'success');
} elseif ($operation == 'delete') {
$row = pdo_fetch("SELECT id FROM " . tablename('wwx_fxxt_shop_collection') . " WHERE id = :id", array(':id' => $id));
if (empty($row)) {
message('抱歉，记录不存在或是已经被删除！');
}
pdo_delete('wwx_fxxt_shop_collection', array('uniacid' => $_W['uniacid'], 'id' => $id));
message('删除成功！', referer(), 'success');
} elseif ($operation == 'display') {
$pindex = max(1, intval($_GPC['page']));
$psize = 50;
$list = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_shop_collection') . " WHERE uniacid = '{$_W['uniacid']}' ORDER BY createtime DESC LIMIT " . ($pindex - 1) * $psize . ',' . $psize);
$total = pdo_fetchcolumn('SELECT COUNT(*) FROM ' . tablename('wwx_fxxt_shop_collection') . " WHERE uniacid = '{$_W['uniacid']}'");
$pager = pagination($total, $pindex, $psize);
} elseif ($_GPC['op'] == 'deleteout') {
pdo_delete('wwx_fxxt_shop_collection', array('uniacid' => $_W['uniacid']));
message('全部清空成功!', $this->createWebUrl('shopcollection', array('op' => 'display')), 'success');
die;
}
include $this->template('shopcollection');
}
public function doWebSetShopProperty()
{
global $_GPC, $_W;
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$stock = $_GPC['stock'];
$data = intval($_GPC['data']);
$type = $_GPC['type'];
if ($type == "username") {
$statustype = 3;
} elseif ($type == "shopip") {
$statustype = 1;
} elseif ($type == "shopmachine") {
$statustype = 2;
}
$st = pdo_fetch("select status from " . tablename('wwx_fxxt_shop_collection_status') . " where stock='{$stock}' limit 1 ");
if ($st['status'] == 0) {
pdo_insert('wwx_fxxt_shop_collection_status', array('uniacid' => $_W['uniacid'], 'status' => $statustype, 'stock' => $stock, 'createtime' => time()));
} else {
pdo_delete('wwx_fxxt_shop_collection_status', array('uniacid' => $_W['uniacid'], "stock" => $stock));
}
$st1 = pdo_fetch("select status from " . tablename('wwx_fxxt_shop_collection_status') . " where stock='{$stock}' limit 1 ");
if (empty($st1['status'])) {
$st1['status'] = 0;
}
if ($st1['status'] == $data) {
die(json_encode(array("result" => 0, "data" => $st1['status'])));
} else {
die(json_encode(array('result' => 1, 'data' => $st1['status'])));
}
}
public function doWebShopCollectionList()
{
global $_GPC, $_W;
$operation = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
$id = intval($_GPC['id']);
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
if (!$_W['isfounder']) {
message('不能访问,此功能只有站长才有操作权限.');
}
if ($operation == 'display') {
$pindex = max(1, intval($_GPC['page']));
$psize = 50;
$list = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_shop_collection_status') . " WHERE uniacid = '{$_W['uniacid']}' ORDER BY createtime DESC LIMIT " . ($pindex - 1) * $psize . ',' . $psize);
$total = pdo_fetchcolumn('SELECT COUNT(*) FROM ' . tablename('wwx_fxxt_shop_collection_status') . " WHERE uniacid = '{$_W['uniacid']}'");
$pager = pagination($total, $pindex, $psize);
} elseif ($operation == 'delete') {
$row = pdo_fetch("SELECT id FROM " . tablename('wwx_fxxt_shop_collection_status') . " WHERE id = :id", array(':id' => $id));
if (empty($row)) {
message('抱歉，信息不存在或是已经被删除！');
}
pdo_delete('wwx_fxxt_shop_collection_status', array('uniacid' => $_W['uniacid'], 'id' => $id));
message('删除成功！', referer(), 'success');
} elseif ($_GPC['op'] == 'deleteout') {
pdo_delete('wwx_fxxt_shop_collection_status', array('uniacid' => $_W['uniacid']));
message('全部清空成功!', $this->createWebUrl('shopcollectionlist', array('op' => 'display')), 'success');
die;
}
include $this->template('shopcollectionlist');
}
public function doWebStatistics()
{
global $_W, $_GPC;
load()->func('tpl');
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$needfixcount = pdo_fetchcolumn("SELECT count(id) FROM " . tablename('wwx_fxxt_member') . " WHERE flag=1 and flagtime=0");
if ($needfixcount > 0) {
pdo_update('wwx_fxxt_member', array('flagtime' => TIMESTAMP), array('flag' => 1, 'flagtime' => 0));
}
$op = $_GPC['op'] ? $_GPC['op'] : 'salereport';
if ($op == 'salereport') {
$nowyear = intval(date('Y', time()));
$nowmonth = intval(date('m', time()));
$years = array(array('year' => $nowyear - 3, 'checked' => 0), array('year' => $nowyear - 2, 'checked' => 0), array('year' => $nowyear - 1, 'checked' => 0), array('year' => $nowyear, 'checked' => 1));
$dropMonthForYaer = $_GPC['dropMonthForYaer'] ? $_GPC['dropMonthForYaer'] : $nowyear;
$radioMonthForSaleType = $_GPC['radioMonthForSaleType'] ? $_GPC['radioMonthForSaleType'] : '0';
$dropMonthForYaer = intval($dropMonthForYaer);
$selectmonthSale = $_GPC['selectmonthSale'] ? $_GPC['selectmonthSale'] : $nowmonth;
$radiodayForSaleType = $_GPC['radiodayForSaleType'] ? $_GPC['radiodayForSaleType'] : '0';
$dropdayForYaer = $_GPC['dropdayForYaer'] ? $_GPC['dropdayForYaer'] : $nowyear;
$dropdayForYaer = intval($dropdayForYaer);
foreach ($years as $id => $displayorder) {
if ($years[$id]['year'] == $dropMonthForYaer) {
$years[$id]['checked'] = 1;
} else {
$years[$id]['checked'] = 0;
}
}
$datas = array(array());
$index = 0;
$allcount = 0;
$topcount = 0;
for ($month = 1; $month <= 12; $month++) {
$datas[$index]['month'] = $month;
$lastday = date('t', strtotime($dropMonthForYaer . "-" . $month . "-1"));
if ($radioMonthForSaleType == '0') {
$ordercount = pdo_fetchcolumn("SELECT count(id) FROM " . tablename('wwx_fxxt_order') . " WHERE uniacid = '{$_W['uniacid']}' and createtime >=" . strtotime($dropMonthForYaer . "-" . $month . "-1" . " 00:00:01") . " and createtime <=" . strtotime($dropMonthForYaer . "-" . $month . "-" . $lastday . " 23:59:59"));
}
if ($radioMonthForSaleType == '1') {
$ordercount = pdo_fetchcolumn("SELECT sum(cast(price as decimal(8,2))) FROM " . tablename('wwx_fxxt_order') . " WHERE uniacid = '{$_W['uniacid']}' and createtime >=" . strtotime($dropMonthForYaer . "-" . $month . "-1" . " 00:00:01") . " and createtime <=" . strtotime($dropMonthForYaer . "-" . $month . "-" . $lastday . " 23:59:59"));
}
if (empty($ordercount)) {
$ordercount = 0;
}
if ($topcount < $ordercount) {
$topcount = $ordercount;
}
$datas[$index]['month'] = $month;
$datas[$index]['count'] = $ordercount;
$allcount = $allcount + $ordercount;
$index = $index + 1;
if ($nowyear == $dropMonthForYaer) {
if ($nowmonth == $month) {
$month = 13;
}
}
}
foreach ($datas as $index => $row) {
if ($allcount > 0) {
$datas[$index]['persent'] = round($datas[$index]['count'] / $allcount, 2) * 100;
} else {
$datas[$index]['persent'] = 0;
}
}
$dayallcount = 0;
$daytopcount = 0;
$daydatas = array(array());
$dayindex = 0;
$lastday = date('t', strtotime($dropdayForYaer . "-" . $selectmonthSale . "-1"));
for ($day = 1; $day <= $lastday; $day++) {
if ($radiodayForSaleType == '0') {
$dayordercount = pdo_fetchcolumn("SELECT count(id) FROM " . tablename('wwx_fxxt_order') . " WHERE uniacid = '{$_W['uniacid']}' and createtime >=" . strtotime($dropdayForYaer . "-" . $selectmonthSale . "-" . $day . " 00:00:01") . " and createtime <=" . strtotime($dropdayForYaer . "-" . $selectmonthSale . "-" . $day . " 23:59:59"));
}
if ($radiodayForSaleType == '1') {
$dayordercount = pdo_fetchcolumn("SELECT sum(cast(price as decimal(8,2))) FROM " . tablename('wwx_fxxt_order') . " WHERE uniacid = '{$_W['uniacid']}' and createtime >=" . strtotime($dropdayForYaer . "-" . $selectmonthSale . "-" . $day . " 00:00:01") . " and createtime <=" . strtotime($dropdayForYaer . "-" . $selectmonthSale . "-" . $day . " 23:59:59"));
}
if (empty($dayordercount)) {
$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($_GPC['salereportEXP01'])) {
$report = "salereport01";
$list = $datas;
require_once 'report.php';
die;
}
if (!empty($_GPC['salereportEXP02'])) {
$report = "salereport02";
$list = $daydatas;
require_once 'report.php';
die;
}
include $this->template('salereport');
die;
}
if ($op == 'memberranking') {
$sortname = $_GPC['sortname'] ? $_GPC['sortname'] : 'ordermoney';
if (!empty($_GPC['time']['start']) && !empty($_GPC['time']['end'])) {
$start_time = strtotime($_GPC['time']['start'] . " 00:00:01");
$end_time = strtotime($_GPC['time']['end'] . " 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($_GPC['time']['start']) && !empty($_GPC['time']['end'])) {
$condition1 = " and orders.createtime>=" . $start_time . " and " . "orders.createtime<=" . $end_time;
$condition2 = " and orders2.createtime>=" . $start_time . " and " . "orders2.createtime<=" . $end_time;
}
$list = pdo_fetchall("SELECT member.realname,(" . "SELECT count(orders.id) FROM " . tablename('wwx_fxxt_order') . " orders where orders.from_user=member.from_user and orders.uniacid=member.uniacid " . $condition1 . ") as ordercount,(" . "SELECT sum(cast(orders2.price as decimal(8,2))) FROM " . tablename('wwx_fxxt_order') . " orders2 where orders2.from_user=member.from_user and member.uniacid=orders2.uniacid " . $condition2 . ") ordermoney FROM " . tablename('wwx_fxxt_member') . " member WHERE member.uniacid = '{$_W['uniacid']}' ORDER BY " . $sortname . " DESC limit 100");
if (!empty($_GPC['memberrankingEXP01'])) {
$report = "memberranking";
require_once 'report.php';
die;
}
include $this->template('memberranking');
die;
}
if ($op == 'fansrange') {
$list = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_member') . " WHERE uniacid = :uniacid order by flagcount desc limit 30", array(':uniacid' => $_W['uniacid']));
include $this->template('fansrange');
die;
}
if ($op == 'productsalestatistics') {
$list = pdo_fetchall("SELECT goods.*,0 as cpersent,(select sum(ordergoods.total) from " . tablename('wwx_fxxt_order_goods') . " ordergoods where ordergoods.goodsid=goods.id and ordergoods.uniacid=goods.uniacid ) salescount from " . tablename('wwx_fxxt_goods') . " goods where goods.uniacid = :uniacid order by (salescount/goods.viewcount) desc ", array(':uniacid' => $_W['uniacid']));
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 $this->template('productsalestatistics');
die;
}
if ($op == 'userincreasestatistics') {
$usertype = $_GPC['usertype'] ? $_GPC['usertype'] : 'user';
$condtitiontime = '';
$conditionflag = '';
if ($usertype == 'agent') {
$conditionflag = ' and flag=1';
$condtitiontime = 'flagtime';
} else {
$condtitiontime = 'createtime';
}
$list = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_member') . " WHERE uniacid = '{$_W['uniacid']}' ");
$nowyear = intval(date('Y', time()));
$nowmonth = intval(date('m', time()));
$years = array(array('year' => $nowyear - 3, 'checked' => 0), array('year' => $nowyear - 2, 'checked' => 0), array('year' => $nowyear - 1, 'checked' => 0), array('year' => $nowyear, 'checked' => 1));
$nowday = date('t', time());
$chartdata1 = array();
$index = 0;
for ($dateindex = 7; $dateindex >= 0; $dateindex--) {
if ($dateindex == 0) {
$time = date("Y-m-d", time());
} else {
$time = date("Y-m-d", strtotime("-" . $dateindex . " day"));
}
$start_time = strtotime($time . " 00:00:01");
$end_time = strtotime($time . " 23:59:59");
$chart1data = pdo_fetch("SELECT count(*) as counts,'" . $time . "' as dates FROM " . tablename('wwx_fxxt_member') . " WHERE uniacid = '{$_W['uniacid']}' {$conditionflag} and " . $condtitiontime . ">=" . $start_time . " and " . $condtitiontime . "<=" . $end_time);
$chartdata1[$index]['counts'] = $chart1data['counts'];
$chartdata1[$index]['dates'] = $chart1data['dates'];
$chartdata1[$index]['index'] = $index;
$index = $index + 1;
}
$index = 0;
$chartdata2 = array();
$dropMonthForYaer = $_GPC['dropMonthForYaer'] ? $_GPC['dropMonthForYaer'] : $nowyear;
$dropMonthForYaer = intval($dropMonthForYaer);
$selectmonthSale = $_GPC['selectmonthSale'] ? $_GPC['selectmonthSale'] : $nowmonth;
$lastday = date('t', strtotime($dropMonthForYaer . "-" . $selectmonthSale . "-1"));
foreach ($years as $id => $displayorder) {
if ($years[$id]['year'] == $dropMonthForYaer) {
$years[$id]['checked'] = 1;
} else {
$years[$id]['checked'] = 0;
}
}
for ($dateindex = 1; $dateindex <= $lastday; $dateindex++) {
$time = $dropMonthForYaer . "-" . $selectmonthSale . "-" . $dateindex;
$start_time = strtotime($time . " 00:00:01");
$end_time = strtotime($time . " 23:59:59");
$chart1data = pdo_fetch("SELECT count(*) as counts,'" . $time . "' as dates FROM " . tablename('wwx_fxxt_member') . " WHERE uniacid = '{$_W['uniacid']}' {$conditionflag} and " . $condtitiontime . ">=" . $start_time . " and " . $condtitiontime . "<=" . $end_time);
$chartdata2[$index]['counts'] = $chart1data['counts'];
$chartdata2[$index]['dates'] = $chart1data['dates'];
$chartdata2[$index]['index'] = $index;
$index = $index + 1;
}
$index = 0;
$chartdata3 = array();
$dropMonthForYaer2 = $_GPC['dropMonthForYaer2'] ? $_GPC['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 = pdo_fetch("SELECT count(*) as counts,'" . $time . "' as dates FROM " . tablename('wwx_fxxt_member') . " WHERE uniacid = '{$_W['uniacid']}' {$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 $this->template('userincreasestatistics');
die;
}
if ($op == 'saletargets') {
$allorderprice = pdo_fetchcolumn("SELECT sum(cast(price as decimal(8,2))) FROM " . tablename('wwx_fxxt_order') . " WHERE status=3 and uniacid = '{$_W['uniacid']}' ");
$allordercount = pdo_fetchcolumn("SELECT count(id) FROM " . tablename('wwx_fxxt_order') . " WHERE status=3 and uniacid = '{$_W['uniacid']}' ");
$allmembercount = pdo_fetchcolumn("SELECT count(*) FROM " . tablename('wwx_fxxt_member') . " WHERE uniacid = '{$_W['uniacid']}' ");
$allorderviewcount = pdo_fetchcolumn("SELECT sum(cast(viewcount as decimal(8,0))) FROM " . tablename('wwx_fxxt_goods') . " WHERE uniacid = '{$_W['uniacid']}' ");
$haveordermembercount = pdo_fetchcolumn("SELECT count(member.id) from " . tablename('wwx_fxxt_member') . " member WHERE member.uniacid = '{$_W['uniacid']}' and member.from_user in (SELECT orders.from_user FROM" . tablename('wwx_fxxt_order') . " orders where orders.uniacid = '{$_W['uniacid']}' group by orders.from_user)");
include $this->template('saletargets');
die;
}
if ($op == 'productsaleranking') {
$condition = "";
if (!empty($_GPC['time']['start']) && !empty($_GPC['time']['end'])) {
$start_time = strtotime($_GPC['time']['start'] . " 00:00:01");
$end_time = strtotime($_GPC['time']['end'] . " 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 ordergoods.createtime>=" . $start_time . " and ordergoods.createtime<=" . $end_time;
$list = pdo_fetchall("SELECT goods.*,0 as cpersent,(select sum((ordergoods.price*ordergoods.total)) from " . tablename('wwx_fxxt_order_goods') . " ordergoods where ordergoods.goodsid=goods.id and ordergoods.uniacid=goods.uniacid {$condition}) salesmoney,(select sum(ordergoods.total) from " . tablename('wwx_fxxt_order_goods') . " ordergoods where ordergoods.goodsid=goods.id and ordergoods.uniacid=goods.uniacid {$condition}) salescount from " . tablename('wwx_fxxt_goods') . " goods where goods.uniacid = :uniacid order by salesmoney desc", array(':uniacid' => $_W['uniacid']));
if (!empty($_GPC['productsalerankingEXP01'])) {
$report = "productsaleranking";
require_once 'report.php';
die;
}
include $this->template('productsaleranking');
die;
}
if ($op == 'saledetails') {
$condition = "";
$pindex = max(1, intval($_GPC['page']));
$psize = 20;
if (!empty($_GPC['time']['start']) && !empty($_GPC['time']['end'])) {
$start_time = strtotime($_GPC['time']['start'] . " 00:00:01");
$end_time = strtotime($_GPC['time']['end'] . " 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;
$list = pdo_fetchall("SELECT ordergoods.price,ordergoods.total,(select title from " . tablename('wwx_fxxt_goods') . " goods where ordergoods.goodsid=goods.id) titles,orders.createtime,orders.ordersn from " . tablename('wwx_fxxt_order_goods') . " ordergoods left join " . tablename('wwx_fxxt_order') . " orders on orders.id=ordergoods.orderid where orders.uniacid = :uniacid {$condition} order by orders.createtime desc LIMIT " . ($pindex - 1) * $psize . ',' . $psize, array(':uniacid' => $_W['uniacid']));
$total = pdo_fetchcolumn("SELECT count(ordergoods.id) from " . tablename('wwx_fxxt_order_goods') . " ordergoods left join " . tablename('wwx_fxxt_order') . " orders on orders.id=ordergoods.orderid where orders.uniacid = :uniacid {$condition} order by orders.createtime desc", array(':uniacid' => $_W['uniacid']));
$pager = pagination($total, $pindex, $psize);
if (!empty($_GPC['saledetailsEXP01'])) {
$report = "saledetails";
require_once 'report.php';
die;
}
include $this->template('saledetails');
die;
}
if ($op == 'orderstatistics') {
$condition = "";
$pindex = max(1, intval($_GPC['page']));
$psize = 20;
if (!empty($_GPC['time']['start']) && !empty($_GPC['time']['end'])) {
$start_time = strtotime($_GPC['time']['start'] . " 00:00:01");
$end_time = strtotime($_GPC['time']['end'] . " 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 t1.createtime>=" . $start_time . " and t1.createtime<=" . $end_time;
if (!empty($_GPC['realname'])) {
$realname = $_GPC['realname'];
$condition .= " and t1.realnamestr='" . $realname . "'";
}
if (!empty($_GPC['addressname'])) {
$addressname = $_GPC['addressname'];
$condition .= " and t1.tdrealname='" . $addressname . "'";
}
if (!empty($_GPC['ordersn'])) {
$ordersn = $_GPC['ordersn'];
$condition .= " and t1.ordersn='" . $ordersn . "'";
}
$list = pdo_fetchall("select t1.* from (SELECT orders.status,orders.uniacid,orders.id,orders.createtime,orders.zhifutime,orders.ordersn,orders.price,orders.dispatchprice,orders.paytype,(select member.realname from " . tablename('wwx_fxxt_member') . " member where member.from_user=orders.from_user and orders.uniacid=member.uniacid limit 1 ) realnamestr,(select taddress.realname from " . tablename('wwx_fxxt_address') . " taddress where taddress.id=orders.addressid and orders.uniacid=taddress.uniacid limit 1 ) tdrealname from " . tablename('wwx_fxxt_order') . " orders where orders.uniacid = :uniacid and orders.status=3 order by orders.createtime desc) t1 where t1.uniacid = :uniacid {$condition} LIMIT " . ($pindex - 1) * $psize . ',' . $psize, array(':uniacid' => $_W['uniacid']));
foreach ($list as $id => $displayorder) {
$list[$id]['ordergoods'] = pdo_fetchall("SELECT goods.thumb,ordersgoods.price,ordersgoods.total,goods.title,ordersgoods.optionname from " . tablename('wwx_fxxt_order_goods') . " ordersgoods left join " . tablename('wwx_fxxt_goods') . " goods on goods.id=ordersgoods.goodsid where ordersgoods.uniacid = :uniacid and ordersgoods.orderid=:oid order by ordersgoods.createtime desc ", array(':uniacid' => $_W['uniacid'], ':oid' => $list[$id]['id']));
}
$total = pdo_fetchcolumn("select count(t1.id) from (SELECT orders.uniacid,orders.id,orders.createtime,orders.zhifutime,orders.ordersn,orders.price,orders.dispatchprice,orders.paytype,(select member.realname from " . tablename('wwx_fxxt_member') . " member where member.from_user=orders.from_user and orders.uniacid=member.uniacid limit 1 ) realnamestr,(select taddress.realname from " . tablename('wwx_fxxt_address') . " taddress where taddress.id=orders.addressid and orders.uniacid=taddress.uniacid limit 1 ) tdrealname from " . tablename('wwx_fxxt_order') . " orders where orders.uniacid = :uniacid and orders.status=3 order by orders.createtime desc) t1 where t1.uniacid = :uniacid {$condition} ", array(':uniacid' => $_W['uniacid']));
$pager = pagination($total, $pindex, $psize);
if (!empty($_GPC['orderstatisticsEXP01'])) {
$report = "orderstatistics";
require_once 'report.php';
die;
}
include $this->template('orderstatistics');
die;
}
}
public function doWebSpread()
{
global $_W, $_GPC;
load()->func('tpl');
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$op = empty($_GPC['op']) ? 'leaflet' : $_GPC['op'];
$rulekeywordcount = pdo_fetchcolumn("SELECT count(id) FROM " . tablename('rule_keyword') . " WHERE uniacid=:uniacid and module='wwx_fxxt' and content='二维码'", array(":uniacid" => $_W['uniacid']));
$boolrule = false;
if ($rulekeywordcount >= 1) {
$boolrule = true;
}
if ($op == 'checkspreadrule') {
if (!empty($_GPC['boolrule'])) {
$rulekeywordcount = pdo_fetchall("SELECT rid FROM " . tablename('rule_keyword') . " WHERE uniacid=:uniacid and module='wwx_fxxt' and content='二维码'", array(":uniacid" => $_W['uniacid']));
foreach ($rulekeywordcount as $k => $v) {
pdo_delete('rule', array('id' => $v['rid'], 'uniacid' => $_W['uniacid'], 'module' => 'wwx_fxxt'));
}
pdo_delete('rule_keyword', array('module' => 'wwx_fxxt', 'uniacid' => $_W['uniacid'], 'content' => '二维码'));
$insert = array('uniacid' => $_W['uniacid'], 'name' => '二维码(系统维护)', 'module' => 'wwx_fxxt', 'displayorder' => 0, 'status' => 1);
pdo_insert('rule', $insert);
$rid = pdo_insertid();
$insert = array('uniacid' => $_W['uniacid'], 'rid' => $rid, 'module' => 'wwx_fxxt', 'content' => '二维码', 'type' => 1, 'displayorder' => 0, 'status' => 1);
pdo_insert('rule_keyword', $insert);
message('设置分销专属二维码成功,请进入自定义菜单绑定关键字\'二维码\'！', referer(), 'success');
} else {
if ($boolrule == true) {
$rulekeywordcount = pdo_fetchall("SELECT rid FROM " . tablename('rule_keyword') . " WHERE uniacid=:uniacid and module='wwx_fxxt' and content='二维码'", array(":uniacid" => $_W['uniacid']));
foreach ($rulekeywordcount as $k => $v) {
pdo_delete('rule', array('id' => $v['rid'], 'uniacid' => $_W['uniacid'], 'module' => 'wwx_fxxt'));
}
pdo_delete('rule_keyword', array('module' => 'wwx_fxxt', 'uniacid' => $_W['uniacid'], 'content' => '二维码'));
message('系统已去除分销专属\'二维码\'关键字触发', referer(), 'success');
}
}
$op = 'leaflet';
}
if ($op == 'delete') {
pdo_update('wwx_fxxt_channel', array('isdel' => 1, 'createtime' => time()), array('channel' => $_GPC['channel'], "uniacid" => $_W['uniacid']));
message('删除成功', referer(), 'success');
} else {
if ($op == 'leaflet') {
$mylist = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_channel') . " WHERE uniacid=:uniacid and isdel=0", array(":uniacid" => $_W['uniacid']));
} else {
if ($op == 'active') {
$channel = intval($_GPC['channel']);
pdo_update('wwx_fxxt_channel', array('active' => 0), array('uniacid' => $_W['uniacid']));
pdo_update('wwx_fxxt_channel', array('createtime' => time()), array('uniacid' => $_W['uniacid'], 'channel' => $channel));
pdo_update('wwx_fxxt_channel', array('createtime' => time(), 'active' => 1), array('uniacid' => $_W['uniacid'], 'channel' => $channel));
message('设定当前活跃传单成功', referer(), 'success');
} else {
if ($op == 'post') {
$item = array();
if (!empty($_GPC['channel'])) {
$item = pdo_fetch("SELECT * FROM " . tablename('wwx_fxxt_channel') . " WHERE uniacid=:uniacid AND channel=:channel", array(":uniacid" => $_W['uniacid'], ":channel" => $_GPC['channel']));
}
$item = $this->decode_channel_param($item, $item['bgparam']);
if (checksubmit('submit')) {
$tagArr = explode('.', $_GPC['bg']);
$tagArr = end($tagArr);
if (strcasecmp('jpg', $tagArr) != 0) {
message('传单背景图必须是jpg格式。不支持png等其他格式。', referer(), 'error');
}
$bgparam = $this->encode_channel_param($_GPC);
$msgtype = empty($_GPC['msgtype']) ? 1 : $_GPC['msgtype'];
if (!empty($_GPC['channel'])) {
pdo_delete('wwx_fxxt_qr', array('uniacid' => $_W['uniacid']));
pdo_update('wwx_fxxt_channel', array('title' => $_GPC['title'], 'createtime' => time(), 'bg' => $_GPC['bg'], 'msgtype' => $msgtype, 'bgparam' => $bgparam, 'notice' => $_GPC['notice']), array('channel' => $_GPC['channel'], 'uniacid' => $_W['uniacid']));
pdo_update('wwx_fxxt_qr', array('expiretime' => 1), array('channel' => $_GPC['channel']));
message('更新成功', referer(), 'success');
} else {
$list_count = pdo_fetchcolumn("SELECT COUNT(*) FROM " . tablename('wwx_fxxt_channel') . " WHERE uniacid=:uniacid and isdel=0", array(":uniacid" => $_W['uniacid']));
$active = $list_count == 0;
pdo_insert('wwx_fxxt_channel', array('title' => $_GPC['title'], 'createtime' => time(), 'notice' => $_GPC['notice'], 'msgtype' => $msgtype, 'bg' => $_GPC['bg'], 'bgparam' => $bgparam, 'active' => $active, 'isdel' => 0, 'uniacid' => $_W['uniacid']));
message('新建成功', $this->createWebUrl('spread', array('op' => 'leaflet')), 'success');
}
}
} else {
if ($op == 'log') {
$pindex = max(1, intval($_GPC['page']));
$psize = 100;
$my_follows_sql = "select l.createtime createtime, l.nickname, l.avatar, v.openid,v.follower_count from " . tablename('mc_members') . " l,(select a.uid, a.openid, count(b.from_user) follower_count from " . tablename('mc_mapping_fans') . " a left join " . tablename('wwx_fxxt_share_history') . " b on b.uniacid=a.uniacid and b.sharemid=(select x.id from " . tablename('wwx_fxxt_member') . " x where x.uniacid=:uniacid and x.from_user=a.openid limit 1) and b.from_user!=a.openid where a.openid in(
select from_user from " . tablename('mc_mapping_fans') . " where uniacid=:uniacid and follow=1 UNION (select from_user from " . tablename('wwx_fxxt_share_history') . " where uniacid=:uniacid )
UNION (select m.from_user from " . tablename('wwx_fxxt_member') . " m where m.uniacid = :uniacid))) v where l.uid=v.uid group by v.openid ORDER BY follower_count DESC LIMIT " . ($pindex - 1) * $psize . ",{$psize}";
$mylist = pdo_fetchall($my_follows_sql, array(':uniacid' => $_W['uniacid']));
if (!empty($mylist)) {
$total = pdo_fetchcolumn("SELECT COUNT(*) FROM " . tablename('mc_mapping_fans') . " a, " . tablename('mc_members') . " b WHERE a.uniacid=:uniacid and a.uid=b.uid", array(':uniacid' => $_W['uniacid']));
$pager = pagination($total, $pindex, $psize);
}
} else {
if ($op == 'user') {
$from_user = $_GPC['from_user'];
$fans = fans_search($from_user, array('nickname', 'createtime', 'credit1'));
$myheadimg = pdo_fetchcolumn('SELECT avatar FROM ' . tablename('mc_mapping_fans') . " a, " . tablename('mc_members') . " b WHERE a.uniacid = :uniacid AND a.openid = :openid and a.uid=b.uid LIMIT 1", array(':uniacid' => $_W['uniacid'], ':openid' => $from_user));
$fans['avatar'] = $myheadimg;
$mylist = pdo_fetchall("select d.createtime d.createtime, d.nickname, d.avatar from " . tablename('mc_members') . " d,(SELECT b.uid uid FROM " . tablename('wwx_fxxt_share_history') . " a LEFT JOIN " . tablename('mc_mapping_fans') . " b ON a.uniacid=b.uniacid and a.from_user = b.openid WHERE a.sharemid = (select id from " . tablename('wwx_fxxt_member') . " c where c.from_user=:leader and c.uniacid=:uniacid limit 1) and a.from_user!=:leader AND a.uniacid=:uniacid) e where d.uid=e.uid ", array(':leader' => $from_user, ':uniacid' => $_W['uniacid']));
} else {
message('error!', '', 'error');
}
}
}
}
}
}
include $this->template('spread');
}
public function doWebAward()
{
global $_W, $_GPC;
load()->func('tpl');
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$operation = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
if ($operation == 'post') {
$award_id = intval($_GPC['award_id']);
if (!empty($award_id)) {
$item = pdo_fetch("SELECT * FROM " . tablename('wwx_fxxt_credit_award') . " WHERE award_id = :award_id", array(':award_id' => $award_id));
if (empty($item)) {
message('抱歉，兑换商品不存在或是已经删除！', '', 'error');
}
}
if (checksubmit('submit')) {
if (empty($_GPC['title'])) {
message('请输入兑换商品名称！');
}
if (empty($_GPC['credit_cost'])) {
message('请输入兑换商品需要消耗的积分数量！');
}
if (empty($_GPC['price'])) {
message('请输入商品实际价值！');
}
$credit_cost = intval($_GPC['credit_cost']);
$price = intval($_GPC['price']);
$amount = intval($_GPC['amount']);
$data = array('uniacid' => $_W['uniacid'], 'title' => $_GPC['title'], 'logo' => $_GPC['logo'], 'deadline' => $_GPC['deadline'], 'amount' => $amount, 'credit_cost' => $credit_cost, 'price' => $price, 'content' => $_GPC['content'], 'createtime' => TIMESTAMP);
if (!empty($award_id)) {
pdo_update('wwx_fxxt_credit_award', $data, array('award_id' => $award_id));
} else {
pdo_insert('wwx_fxxt_credit_award', $data);
}
message('商品更新成功！', create_url('site/entry/award', array('m' => 'wwx_fxxt', 'op' => 'display')), 'success');
}
} else {
if ($operation == 'delete') {
$award_id = intval($_GPC['award_id']);
$row = pdo_fetch("SELECT award_id FROM " . tablename('wwx_fxxt_credit_award') . " WHERE award_id = :award_id", array(':award_id' => $award_id));
if (empty($row)) {
message('抱歉，商品' . $award_id . '不存在或是已经被删除！');
}
pdo_delete('wwx_fxxt_credit_award', array('award_id' => $award_id));
message('删除成功！', referer(), 'success');
} else {
if ($operation == 'display') {
$condition = '';
$list = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_credit_award') . " WHERE uniacid = '{$_W['uniacid']}' {$condition} ORDER BY createtime DESC");
}
}
}
include $this->template('credit_award');
}
public function doWebCredit()
{
global $_W, $_GPC;
load()->func('tpl');
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$operation = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
$modules = 'credit';
if ($operation == 'delete') {
$id = intval($_GPC['id']);
$row = pdo_fetch("SELECT id FROM " . tablename('wwx_fxxt_credit_request') . " WHERE id = :id", array(':id' => $id));
if (empty($row)) {
message('抱歉，编号为' . $id . '的兑换请求不存在或是已经被删除！');
}
pdo_delete('wwx_fxxt_credit_request', array('id' => $id));
message('删除成功！', referer(), 'success');
} else {
if ($operation == 'display') {
$condition = '';
$sql = "SELECT * FROM " . tablename('wwx_fxxt_credit_award') . " as t1," . tablename('wwx_fxxt_credit_request') . "as t2 WHERE t1.award_id=t2.award_id AND t1.uniacid = '{$_W['uniacid']}' ORDER BY t2.createtime DESC";
$list = pdo_fetchall($sql);
$ar = pdo_fetchall($sql, array(), 'from_user');
$arrayAR = array_keys($ar);
$fans = pdo_fetchall("SELECT fans.openid as from_user,member.realname as realname,mobile,credit1,residedist FROM " . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member WHERE fans.uid=member.uid and fans.openid IN ('" . implode("','", $arrayAR) . "') and member.uniacid = '{$_W['uniacid']}'", array(), 'from_user');
}
}
include $this->template('credit_request');
}
public function doWebDispatch()
{
global $_W, $_GPC;
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$setting = uni_setting($_W['uniacid'], array('payment', 'creditbehaviors'));
$operation = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
$operExp = $_GPC['do'];
if ($operation == 'display') {
$list = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_dispatch') . " WHERE uniacid = '{$_W['uniacid']}' ORDER BY displayorder ");
} elseif ($operation == 'post') {
$id = intval($_GPC['id']);
if (checksubmit('submit')) {
$data = array('uniacid' => $_W['uniacid'], 'displayorder' => intval($_GPC['displayorder']), 'dispatchtype' => intval($_GPC['dispatchtype']), 'dispatchname' => $_GPC['dispatchname'], 'express' => $_GPC['express'], 'firstprice' => $_GPC['firstprice'], 'firstweight' => $_GPC['firstweight'], 'secondprice' => $_GPC['secondprice'], 'secondweight' => $_GPC['secondweight'], 'description' => $_GPC['description']);
if (!empty($id)) {
pdo_update('wwx_fxxt_dispatch', $data, array('id' => $id));
} else {
pdo_insert('wwx_fxxt_dispatch', $data);
$id = pdo_insertid();
}
message('更新配送方式成功！', $this->createWebUrl('dispatch', array('op' => 'display')), 'success');
}
$dispatch = pdo_fetch("SELECT * FROM " . tablename('wwx_fxxt_dispatch') . " WHERE id = '{$id}' and uniacid = '{$_W['uniacid']}'");
$express = pdo_fetchall("select * from " . tablename('wwx_fxxt_express') . " WHERE uniacid = '{$_W['uniacid']}' ORDER BY displayorder DESC");
} elseif ($operation == 'delete') {
$id = intval($_GPC['id']);
$dispatch = pdo_fetch("SELECT id FROM " . tablename('wwx_fxxt_dispatch') . " WHERE id = '{$id}' AND uniacid=" . $_W['uniacid'] . "");
if (empty($dispatch)) {
message('抱歉，配送方式不存在或是已经被删除！', $this->createWebUrl('dispatch', array('op' => 'display')), 'error');
}
pdo_delete('wwx_fxxt_dispatch', array('id' => $id));
message('配送方式删除成功！', $this->createWebUrl('dispatch', array('op' => 'display')), 'success');
} else {
message('请求方式不存在');
}
include $this->template('dispatch', TEMPLATE_INCLUDEPATH, true);
}
public function doWebExpress()
{
global $_W, $_GPC;
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$operation = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
$operExp = $_GPC['do'];
if ($operation == 'display') {
$list = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_express') . " WHERE uniacid = '{$_W['uniacid']}' ORDER BY displayorder asc");
} elseif ($operation == 'post') {
$id = intval($_GPC['id']);
if (checksubmit('submit')) {
if (empty($_GPC['express_name'])) {
message('抱歉，请输入物流名称！');
}
$data = array('uniacid' => $_W['uniacid'], 'displayorder' => intval($_GPC['displayorder']), 'express_name' => $_GPC['express_name'], 'express_url' => $_GPC['express_url'], 'express_area' => $_GPC['express_area']);
if (!empty($id)) {
unset($data['parentid']);
pdo_update('wwx_fxxt_express', $data, array('id' => $id));
} else {
pdo_insert('wwx_fxxt_express', $data);
$id = pdo_insertid();
}
message('更新物流成功！', $this->createWebUrl('express', array('op' => 'display')), 'success');
}
$express = pdo_fetch("SELECT * FROM " . tablename('wwx_fxxt_express') . " WHERE id = '{$id}' and uniacid = '{$_W['uniacid']}'");
} elseif ($operation == 'delete') {
$id = intval($_GPC['id']);
$express = pdo_fetch("SELECT id FROM " . tablename('wwx_fxxt_express') . " WHERE id = '{$id}' AND uniacid=" . $_W['uniacid'] . "");
if (empty($express)) {
message('抱歉，物流方式不存在或是已经被删除！', $this->createWebUrl('express', array('op' => 'display')), 'error');
}
pdo_delete('wwx_fxxt_express', array('id' => $id));
message('物流方式删除成功！', $this->createWebUrl('express', array('op' => 'display')), 'success');
} else {
message('请求方式不存在');
}
include $this->template('express', TEMPLATE_INCLUDEPATH, true);
}
public function doWebAdv()
{
global $_W, $_GPC;
load()->func('tpl');
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$modules = 'adv';
$operation = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
if ($operation == 'display') {
$list = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_adv') . " WHERE uniacid = '{$_W['uniacid']}' ORDER BY displayorder DESC");
} elseif ($operation == 'post') {
$id = intval($_GPC['id']);
if (checksubmit('submit')) {
$data = array('uniacid' => $_W['uniacid'], 'advname' => $_GPC['advname'], 'link' => $_GPC['link'], 'enabled' => intval($_GPC['enabled']), 'displayorder' => intval($_GPC['displayorder']));
if (!empty($_GPC['thumb'])) {
$data['thumb'] = $_GPC['thumb'];
}
if (!empty($id)) {
pdo_update('wwx_fxxt_adv', $data, array('id' => $id));
} else {
pdo_insert('wwx_fxxt_adv', $data);
$id = pdo_insertid();
}
message('更新幻灯片成功！', $this->createWebUrl('adv', array('op' => 'display')), 'success');
}
$adv = pdo_fetch("select * from " . tablename('wwx_fxxt_adv') . " where id=:id and uniacid=:uniacid limit 1", array(":id" => $id, ":uniacid" => $_W['uniacid']));
} elseif ($operation == 'delete') {
$id = intval($_GPC['id']);
$adv = pdo_fetch("SELECT id FROM " . tablename('wwx_fxxt_adv') . " WHERE id = '{$id}' AND uniacid=" . $_W['uniacid'] . "");
if (empty($adv)) {
message('抱歉，幻灯片不存在或是已经被删除！', $this->createWebUrl('adv', array('op' => 'display')), 'error');
}
pdo_delete('wwx_fxxt_adv', array('id' => $id));
message('幻灯片删除成功！', $this->createWebUrl('adv', array('op' => 'display')), 'success');
} else {
message('请求方式不存在');
}
include $this->template('adv', TEMPLATE_INCLUDEPATH, true);
}
public function doWebPromotion()
{
global $_W, $_GPC;
load()->func('tpl');
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$modules = 'promotion';
$operation = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
if ($operation == 'display') {
$prolist = pdo_fetchall('select * from ' . tablename('wwx_fxxt_pormotions') . "where uniacid='{$_W['uniacid']}' order by id desc");
} else {
if ($operation == 'post') {
$id = intval($_GPC['id']);
if (checksubmit('submit')) {
$data = array('uniacid' => $_W['uniacid'], 'promoteType' => $_GPC['radioPromotionType'], 'condition' => (int) intval($_GPC['promotionmoney']), 'pname' => $_GPC['promotionname'], 'starttime' => strtotime($_GPC['start_time']), 'endtime' => strtotime($_GPC['end_time']), 'description' => $GPC['description']);
if ($data['starttime'] > $data['endtime']) {
message('设置错误，开始时间不能大于结束时间', $this->createWebUrl('promotion', array('op' => 'post', 'stup' => 1)), 'error');
return;
}
if (empty($data['pname'])) {
message('请输入活动名称', $this->createWebUrl('promotion', array('op' => 'post', 'stup' => 1)), 'error');
return;
}
if (empty($data['condition'])) {
message('请输入满额(件)数量', $this->createWebUrl('promotion', array('op' => 'post', 'stup' => 1)), 'error');
return;
}
if (!empty($id)) {
pdo_update('wwx_fxxt_pormotions', $data, array('id' => $id, 'uniacid' => $_W['uniacid']));
} else {
pdo_insert('wwx_fxxt_pormotions', $data);
$id = pdo_insertid();
}
message('更新促销活动内容成功！', $this->createWebUrl('promotion', array('op' => 'display'), 'success'));
}
$pro = pdo_fetch('select * from ' . tablename('wwx_fxxt_pormotions') . 'where id=:id and uniacid=:uniacid limit 1', array(':id' => $id, ':uniacid' => $_W['uniacid']));
} else {
if ($operation == 'delete') {
$id = intval($_GPC['id']);
$pro = pdo_fetch('select id from' . tablename('wwx_fxxt_pormotions') . "where id='{$id}' and uniacid=" . $_W['uniacid'] . '');
if (empty($pro['id'])) {
message('促销活动不存在或者已被删除', $this->createWebUrl('promotion', array('op' => 'display', 'stup' => 2)), 'error');
}
pdo_delete('wwx_fxxt_pormotions', array('id' => $id, 'uniacid' => $_W['uniacid']));
message('删除成功', $this->createWebUrl('promotion', array('op' => 'display', 'stup' => 2)), 'success');
} else {
message('请求方法不存在');
}
}
}
include $this->template('promotion', TEMPLATE_INCLUDEPATH, true);
}
public function doWebRules()
{
global $_W, $_GPC;
load()->func('tpl');
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$uniacid = $_W['uniacid'];
$op = $operation = $_GPC['op'] ? $_GPC['op'] : 'display';
$theone = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_rules') . " WHERE uniacid = :uniacid", array(':uniacid' => $_W['uniacid']));
$id = $theone['id'];
if (checksubmit('submit')) {
$insert = array('uniacid' => $_W['uniacid'], 'terms' => htmlspecialchars_decode($_GPC['terms']), 'commtime' => 0, 'ischeck' => $_GPC['ischeck'], 'createtime' => TIMESTAMP);
if (empty($id)) {
pdo_insert('wwx_fxxt_rules', $insert);
!pdo_insertid() ? message('保存失败, 请稍后重试.', 'error') : '';
} else {
if (pdo_update('wwx_fxxt_rules', $insert, array('id' => $id)) === false) {
message('更新失败, 请稍后重试.', 'error');
}
}
message('更新成功！', $this->createWebUrl('rules'), 'success');
}
include $this->template('rules');
}
public function doWebPrinter()
{
global $_W, $_GPC;
load()->func('file');
load()->func('tpl');
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$op = !empty($_GPC['op']) ? $_GPC['op'] : 'express';
if ($op == 'preview_express') {
$id = intval($_GPC['id']);
$entry = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_printer') . ' WHERE uniacid = :uniacid and printertype=1 and id=:id', array(':uniacid' => $_W['uniacid'], ':id' => $id));
$previewtmp = $entry['printerconfig'];
for ($i = 1; $i < 3; $i++) {
$previewtmp = str_replace('购货人', '张三同志', $previewtmp);
$previewtmp = str_replace('收货姓名', '张三', $previewtmp);
$previewtmp = str_replace('收货电话', '021-88885555', $previewtmp);
$previewtmp = str_replace('收货地址', '上海市青浦区xxxxx', $previewtmp);
$previewtmp = str_replace('支付方式', '在线支付', $previewtmp);
$previewtmp = str_replace('配送方式', '申通快递', $previewtmp);
$previewtmp = str_replace('发货单号', '115345585233', $previewtmp);
$previewtmp = str_replace('订单编号', '8774675533', $previewtmp);
$previewtmp = str_replace('下单时间', date('Y-m-d H:i:s', time() - 1000), $previewtmp);
$previewtmp = str_replace('订单金额', '920.0', $previewtmp);
$previewtmp = str_replace('配送费用', '10.0', $previewtmp);
$previewtmp = str_replace('商品金额', '910.0', $previewtmp);
$previewtmp = str_replace('打印时间', date('Y-m-d H:i:s', time()), $previewtmp);
$previewtmp = str_replace('寄件公司', '寄件公司X', $previewtmp);
$previewtmp = str_replace('寄件人', '寄件人A', $previewtmp);
$previewtmp = str_replace('寄件地址', '上海xxxxxx', $previewtmp);
$previewtmp = str_replace('寄件电话', '13333333333', $previewtmp);
$previewtmp = str_replace('年', date('Y', time()), $previewtmp);
$previewtmp = str_replace('月', date('m', time()), $previewtmp);
$previewtmp = str_replace('日', date('d', time()), $previewtmp);
}
include $this->template('printer_express_print');
die;
}
if ($op == 'express') {
$list = pdo_fetchall('SELECT * FROM ' . tablename('wwx_fxxt_printer') . ' WHERE uniacid = :uniacid and printertype=1', array(':uniacid' => $_W['uniacid']));
include $this->template('printer_express');
die;
}
if ($op == 'set_express') {
$id = intval($_GPC['id']);
if (empty($id)) {
message('请选择一条记录');
}
pdo_update('wwx_fxxt_printer', array('isdefault' => 0), array('uniacid' => $_W['uniacid'], 'printertype' => 1));
pdo_update('wwx_fxxt_printer', array('isdefault' => 1), array('uniacid' => $_W['uniacid'], 'id' => $id, 'printertype' => 1));
message('设置成功!', referer(), 'success');
}
if ($op == 'priview_express') {
$id = intval($_GPC['id']);
$entry = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_printer') . ' WHERE uniacid = :uniacid and id=:id', array(':uniacid' => $_W['uniacid'], ':id' => $id));
include $this->template('printer_express_print');
}
if ($op == 'create_express') {
if (checksubmit('delpic')) {
$entry = array();
$entry['expresscode'] = $_GPC['expresscode'];
$entry['name'] = $_GPC['print_name'];
$entry['printerconfig'] = $_GPC['printerconfig'];
include $this->template('printer_express_detail');
die;
}
if (checksubmit('picupload')) {
$entry = array();
if (!empty($_FILES['expresspic']['tmp_name'])) {
file_delete($_GPC['old_expresspic']);
$expresspic = file_upload($_FILES['expresspic']);
$entry['expresspic'] = $expresspic['path'];
}
$entry['print_from_compy'] = $_GPC['print_from_compy'];
$entry['print_from_uname'] = $_GPC['print_from_uname'];
$entry['print_from_addr'] = $_GPC['print_from_addr'];
$entry['print_from_tel'] = $_GPC['print_from_tel'];
$entry['expresscode'] = $_GPC['expresscode'];
$entry['name'] = $_GPC['print_name'];
$entry['printerconfig'] = $_GPC['printerconfig'];
include $this->template('printer_express_detail');
die;
}
if (checksubmit('submit')) {
$expressconfig = array();
$expressconfig['print_from_compy'] = $_GPC['print_from_compy'];
$expressconfig['print_from_uname'] = $_GPC['print_from_uname'];
$expressconfig['print_from_addr'] = $_GPC['print_from_addr'];
$expressconfig['print_from_tel'] = $_GPC['print_from_tel'];
pdo_insert('wwx_fxxt_printer', array('expresspic' => $_GPC['old_expresspic'], 'expressconfig' => iserializer($expressconfig), 'printerconfig' => $_GPC['printerconfig'], 'expresscode' => $_GPC['expresscode'], 'expressdaxiao' => $_GPC['expressdaxiao'], 'expressziti' => $_GPC['expressziti'], 'isdefault' => 0, 'createtime' => time(), 'printertype' => 1, 'uniacid' => $_W['uniacid'], 'name' => $_GPC['print_name']));
message('保存成功!', $this->createWebUrl('printer', array('op' => 'express')), 'success');
}
include $this->template('printer_express_detail');
die;
}
if ($op == 'edit_express') {
$id = intval($_GPC['id']);
if (empty($id)) {
message('请选择一条记录');
}
if (checksubmit('picupload')) {
$data = array('expresscode' => $_GPC['expresscode'], 'expressdaxiao' => $_GPC['expressdaxiao'], 'expressziti' => $_GPC['expressziti'], 'printerconfig' => $_GPC['printerconfig'], 'createtime' => time(), 'printertype' => 1, 'name' => $_GPC['print_name']);
$expressconfig = array();
$expressconfig['print_from_compy'] = $_GPC['print_from_compy'];
$expressconfig['print_from_uname'] = $_GPC['print_from_uname'];
$expressconfig['print_from_addr'] = $_GPC['print_from_addr'];
$expressconfig['print_from_tel'] = $_GPC['print_from_tel'];
$data['expressconfig'] = iserializer($expressconfig);
if (!empty($_FILES['expresspic']['tmp_name'])) {
file_delete($_GPC['old_expresspic']);
$expresspic = file_upload($_FILES['expresspic']);
$data['expresspic'] = $expresspic['path'];
}
pdo_update('wwx_fxxt_printer', $data, array('id' => $id, 'uniacid' => $_W['uniacid']));
header('Location:' . $this->createWebUrl('printer', array('op' => 'edit_express', 'id' => $id)));
die;
}
if (checksubmit('submit')) {
$expressconfig = array();
$expressconfig['print_from_compy'] = $_GPC['print_from_compy'];
$expressconfig['print_from_uname'] = $_GPC['print_from_uname'];
$expressconfig['print_from_addr'] = $_GPC['print_from_addr'];
$expressconfig['print_from_tel'] = $_GPC['print_from_tel'];
pdo_update('wwx_fxxt_printer', array('expresscode' => $_GPC['expresscode'], 'expressdaxiao' => $_GPC['expressdaxiao'], 'expressziti' => $_GPC['expressziti'], 'printerconfig' => $_GPC['printerconfig'], 'createtime' => time(), 'expressconfig' => iserializer($expressconfig), 'printertype' => 1, 'name' => $_GPC['print_name']), array('id' => $id, 'uniacid' => $_W['uniacid']));
message('保存成功!', referer(), 'success');
}
$entry = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_printer') . ' WHERE uniacid = :uniacid and id=:id', array(':uniacid' => $_W['uniacid'], ':id' => $id));
if (!empty($entry['expressconfig'])) {
$t_expressconfig = iunserializer($entry['expressconfig']);
$entry['print_from_compy'] = $t_expressconfig['print_from_compy'];
$entry['print_from_uname'] = $t_expressconfig['print_from_uname'];
$entry['print_from_addr'] = $t_expressconfig['print_from_addr'];
$entry['print_from_tel'] = $t_expressconfig['print_from_tel'];
}
if (checksubmit('delpic')) {
file_delete($_GPC['old_expresspic']);
$data = array();
$data['expresspic'] = '';
pdo_update('wwx_fxxt_printer', $data, array('id' => $id, 'uniacid' => $_W['uniacid']));
}
include $this->template('printer_express_detail');
die;
}
if ($op == 'del_express') {
$id = intval($_GPC['id']);
if (empty($id)) {
message('请选择一条记录');
}
pdo_delete('wwx_fxxt_printer', array('uniacid' => $_W['uniacid'], 'id' => $id, 'printertype' => 1));
message('删除成功!', $this->createWebUrl('printer', array('op' => 'express')), 'success');
die;
}
if ($op == 'set_normal') {
$id = intval($_GPC['id']);
if (empty($id)) {
message('请选择一条记录');
}
pdo_update('wwx_fxxt_printer', array('isdefault' => 0), array('uniacid' => $_W['uniacid'], 'printertype' => 0));
pdo_update('wwx_fxxt_printer', array('isdefault' => 1), array('uniacid' => $_W['uniacid'], 'id' => $id, 'printertype' => 0));
message('设置成功!', referer(), 'success');
}
if ($op == 'create_normal' || $op == 'printview_normal' || $op == 'edit_normal') {
if (checksubmit('printview') || $op == 'printview_normal') {
echo '
';
$previewtmp = $_GPC['previewtmp'];
if ($op == 'printview_normal') {
$entry = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_printer') . ' WHERE id=:id', array(':id' => $_GPC['id']));
$previewtmp = $entry['printerconfig'];
}
for ($i = 1; $i < 3; $i++) {
$previewtmp = str_replace('{buyer}', '张三同志', $previewtmp);
$previewtmp = str_replace('{consignee}', '张三', $previewtmp);
$previewtmp = str_replace('{tel}', '021-88885555', $previewtmp);
$previewtmp = str_replace('{address}', '上海市青浦区xxxxx', $previewtmp);
$previewtmp = str_replace('{pay_type}', '在线支付', $previewtmp);
$previewtmp = str_replace('{dispatch_type}', '申通快递', $previewtmp);
$previewtmp = str_replace('{dispatch_sn}', '115345585233', $previewtmp);
$previewtmp = str_replace('{order_sn}', '8774675533', $previewtmp);
$previewtmp = str_replace('{time}', date('Y-m-d H:i:s', time() - 1000), $previewtmp);
$previewtmp = str_replace('{order_price}', '920.0', $previewtmp);
$previewtmp = str_replace('{dispatch_price}', '10.0', $previewtmp);
$previewtmp = str_replace('{good_price}', '910.0', $previewtmp);
$previewtmp = str_replace('{print_time}', date('Y-m-d H:i:s', time()), $previewtmp);
$good_line = '
| 商品名称 |
价格 |
数量 |
小计 |
| 商务翻领休闲直筒修身男装夹克 |
￥300.00元 |
2 |
￥600.00元 |
| 淑女粉色九分袖獭兔毛外套 |
￥310.00元 |
1 |
￥310.00元 |
| 商品总金额：￥910.00元 |
';
$previewtmp = str_replace('{good_line}', $good_line, $previewtmp);
}
echo htmlspecialchars_decode($previewtmp);
echo '';
die;
}
}
if ($op == 'create_normal') {
if (checksubmit('submit')) {
pdo_insert('wwx_fxxt_printer', array('printerconfig' => $_GPC['gmsptz'], 'isdefault' => 0, 'createtime' => time(), 'printertype' => 0, 'uniacid' => $_W['uniacid'], 'name' => $_GPC['print_name']));
message('保存成功!', $this->createWebUrl('printer', array('op' => 'normal')), 'success');
}
if (checksubmit('预设模板')) {
$entry['printerconfig'] = '';
$entry['printerconfig'] = $this->curl_printerconfig(1);
}
include $this->template('printer_normal_detail');
die;
}
if ($op == 'edit_normal') {
$id = intval($_GPC['id']);
if (empty($id)) {
message('请选择一条记录');
}
$entry = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_printer') . ' WHERE uniacid = :uniacid and id=:id', array(':uniacid' => $_W['uniacid'], ':id' => $id));
if (checksubmit('submit')) {
pdo_update('wwx_fxxt_printer', array('printerconfig' => $_GPC['gmsptz'], 'createtime' => time(), 'printertype' => 0, 'name' => $_GPC['print_name']), array('id' => $id, 'uniacid' => $_W['uniacid']));
message('保存成功!', referer(), 'success');
}
if (checksubmit('预设模板')) {
$entry['printerconfig'] = '';
$entry['printerconfig'] = $this->curl_printerconfig(1);
}
include $this->template('printer_normal_detail');
die;
}
if ($op == 'del_normal') {
$id = intval($_GPC['id']);
if (empty($id)) {
message('请选择一条记录');
}
pdo_delete('wwx_fxxt_printer', array('uniacid' => $_W['uniacid'], 'id' => $id, 'printertype' => 0));
message('删除成功!', $this->createWebUrl('printer', array('op' => 'normal')), 'success');
die;
}
if ($op == 'normal') {
$list = pdo_fetchall('SELECT * FROM ' . tablename('wwx_fxxt_printer') . ' WHERE uniacid = :uniacid and printertype=0', array(':uniacid' => $_W['uniacid']));
include $this->template('printer_normal');
die;
}
include $this->template('printer');
}
public function doWebMessagetmp()
{
global $_W, $_GPC;
load()->func('tpl');
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$uniacid = $_W['uniacid'];
$settings = $this->module['config'];
$op = $operation = $_GPC['op'] ? $_GPC['op'] : 'display';
$salers = array();
if (isset($settings['msgtmp']['openid'])) {
if (!empty($settings['msgtmp']['openid'])) {
$openids = array();
$strsopenids = explode(',', $settings['msgtmp']['openid']);
foreach ($strsopenids as $openid) {
$openids[] = '\'' . $openid . '\'';
}
$salers = pdo_fetchall("select member2.id, member2.nickname, member.avatar, fans.openid from " . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member, " . tablename('wwx_fxxt_member') . " member2 where fans.openid in (" . implode(',', $openids) . ") and fans.uid=member.uid and fans.openid=member2.from_user and fans.uniacid={$_W['uniacid']}");
}
}
$msgtemplate = array();
$tmsgtemplate = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_msg_template') . ' WHERE uniacid = :uniacid and tkey = :key', array(':uniacid' => $_W['uniacid'], ':key' => 'zndxxtz'));
if (!empty($tmsgtemplate['id'])) {
$msgtemplate['zndxxtz'] = $tmsgtemplate['template'];
$msgtemplate['zndxxtzenable'] = $tmsgtemplate['tenable'];
}
$tmsgtemplate = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_msg_template') . ' WHERE uniacid = :uniacid and tkey = :key', array(':uniacid' => $_W['uniacid'], ':key' => 'gmsptz'));
if (!empty($tmsgtemplate['id'])) {
$msgtemplate['gmsptz'] = $tmsgtemplate['template'];
$msgtemplate['gmsptzenable'] = $tmsgtemplate['tenable'];
}
$tmsgtemplate = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_msg_template') . ' WHERE uniacid = :uniacid and tkey = :key', array(':uniacid' => $_W['uniacid'], ':key' => 'tjrtz'));
if (!empty($tmsgtemplate['id'])) {
$msgtemplate['tjrtz'] = $tmsgtemplate['template'];
$msgtemplate['tjrtzenable'] = $tmsgtemplate['tenable'];
}
$tmsgtemplate = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_msg_template') . ' WHERE uniacid = :uniacid and tkey = :key', array(':uniacid' => $_W['uniacid'], ':key' => 'tjrtzewm'));
if (!empty($tmsgtemplate['id'])) {
$msgtemplate['tjrtzewm'] = $tmsgtemplate['template'];
$msgtemplate['tjrtzewmenable'] = $tmsgtemplate['tenable'];
}
$tmsgtemplate = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_msg_template') . ' WHERE uniacid = :uniacid and tkey = :key', array(':uniacid' => $_W['uniacid'], ':key' => 'tjrtzdl'));
if (!empty($tmsgtemplate['id'])) {
$msgtemplate['tjrtzdl'] = $tmsgtemplate['template'];
$msgtemplate['tjrtzdlenable'] = $tmsgtemplate['tenable'];
}
$tmsgtemplate = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_msg_template') . ' WHERE uniacid = :uniacid and tkey = :key', array(':uniacid' => $_W['uniacid'], ':key' => 'xjdlshtz'));
if (!empty($tmsgtemplate['id'])) {
$msgtemplate['xjdlshtz'] = $tmsgtemplate['template'];
$msgtemplate['xjdlshtzenable'] = $tmsgtemplate['tenable'];
}
$tmsgtemplate = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_msg_template') . ' WHERE uniacid = :uniacid and tkey = :key', array(':uniacid' => $_W['uniacid'], ':key' => 'yjsqtz'));
if (!empty($tmsgtemplate['id'])) {
$msgtemplate['yjsqtz'] = $tmsgtemplate['template'];
$msgtemplate['yjsqtzenable'] = $tmsgtemplate['tenable'];
}
$tmsgtemplate = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_msg_template') . ' WHERE uniacid = :uniacid and tkey = :key', array(':uniacid' => $_W['uniacid'], ':key' => 'sjytktz'));
if (!empty($tmsgtemplate['id'])) {
$msgtemplate['sjytktz'] = $tmsgtemplate['template'];
$msgtemplate['sjytktzenable'] = $tmsgtemplate['tenable'];
}
if (checksubmit('submit') || checksubmit('submit2')) {
$settings['noticeemail'] = $_GPC['noticeemail'];
$settings['noticeewechat'] = $_GPC['noticeewechat'];
$settings['msgtmp']['neworder'] = $_GPC['neworder'];
$settings['msgtmp']['newtype'] = $_GPC['newtype'];
$settings['msgtmp']['openid'] = '';
if (is_array($_GPC['openids'])) {
$settings['msgtmp']['openid'] = implode(',', $_GPC['openids']);
}
$this->saveSettings($settings);
$tmsgtemplate = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_msg_template') . ' WHERE uniacid = :uniacid and tkey = :key', array(':uniacid' => $_W['uniacid'], ':key' => 'zndxxtz'));
if (empty($tmsgtemplate['id'])) {
$datas = array('uniacid' => $_W['uniacid'], 'tkey' => 'zndxxtz', 'template' => $_GPC['zndxxtz'], 'tenable' => intval($_GPC['zndxxtzenable']));
pdo_insert('wwx_fxxt_msg_template', $datas);
} else {
$datas = array('template' => $_GPC['zndxxtz'], 'tenable' => intval($_GPC['zndxxtzenable']));
pdo_update('wwx_fxxt_msg_template', $datas, array('id' => $tmsgtemplate['id']));
}
$tmsgtemplate = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_msg_template') . ' WHERE uniacid = :uniacid and tkey = :key', array(':uniacid' => $_W['uniacid'], ':key' => 'gmsptz'));
if (empty($tmsgtemplate['id'])) {
$datas = array('uniacid' => $_W['uniacid'], 'tkey' => 'gmsptz', 'template' => $_GPC['gmsptz'], 'tenable' => intval($_GPC['gmsptzenable']));
pdo_insert('wwx_fxxt_msg_template', $datas);
} else {
$datas = array('template' => $_GPC['gmsptz'], 'tenable' => intval($_GPC['gmsptzenable']));
pdo_update('wwx_fxxt_msg_template', $datas, array('id' => $tmsgtemplate['id']));
}
$tmsgtemplate = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_msg_template') . ' WHERE uniacid = :uniacid and tkey = :key', array(':uniacid' => $_W['uniacid'], ':key' => 'tjrtz'));
if (empty($tmsgtemplate['id'])) {
$datas = array('uniacid' => $_W['uniacid'], 'tkey' => 'tjrtz', 'template' => $_GPC['tjrtz'], 'tenable' => intval($_GPC['tjrtzenable']));
pdo_insert('wwx_fxxt_msg_template', $datas);
} else {
$datas = array('template' => $_GPC['tjrtz'], 'tenable' => intval($_GPC['tjrtzenable']));
pdo_update('wwx_fxxt_msg_template', $datas, array('id' => $tmsgtemplate['id']));
}
$tmsgtemplate = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_msg_template') . ' WHERE uniacid = :uniacid and tkey = :key', array(':uniacid' => $_W['uniacid'], ':key' => 'tjrtzewm'));
if (empty($tmsgtemplate['id'])) {
$datas = array('uniacid' => $_W['uniacid'], 'tkey' => 'tjrtzewm', 'template' => $_GPC['tjrtzewm'], 'tenable' => intval($_GPC['tjrtzewmenable']));
pdo_insert('wwx_fxxt_msg_template', $datas);
} else {
$datas = array('template' => $_GPC['tjrtzewm'], 'tenable' => intval($_GPC['tjrtzewmenable']));
pdo_update('wwx_fxxt_msg_template', $datas, array('id' => $tmsgtemplate['id']));
}
$tmsgtemplate = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_msg_template') . ' WHERE uniacid = :uniacid and tkey = :key', array(':uniacid' => $_W['uniacid'], ':key' => 'tjrtzdl'));
if (empty($tmsgtemplate['id'])) {
$datas = array('uniacid' => $_W['uniacid'], 'tkey' => 'tjrtzdl', 'template' => $_GPC['tjrtzdl'], 'tenable' => intval($_GPC['tjrtzdlenable']));
pdo_insert('wwx_fxxt_msg_template', $datas);
} else {
$datas = array('template' => $_GPC['tjrtzdl'], 'tenable' => intval($_GPC['tjrtzdlenable']));
pdo_update('wwx_fxxt_msg_template', $datas, array('id' => $tmsgtemplate['id']));
}
$tmsgtemplate = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_msg_template') . ' WHERE uniacid = :uniacid and tkey = :key', array(':uniacid' => $_W['uniacid'], ':key' => 'xjdlshtz'));
if (empty($tmsgtemplate['id'])) {
$datas = array('uniacid' => $_W['uniacid'], 'tkey' => 'xjdlshtz', 'template' => $_GPC['xjdlshtz'], 'tenable' => intval($_GPC['xjdlshtzenable']));
pdo_insert('wwx_fxxt_msg_template', $datas);
} else {
$datas = array('template' => $_GPC['xjdlshtz'], 'tenable' => intval($_GPC['xjdlshtzenable']));
pdo_update('wwx_fxxt_msg_template', $datas, array('id' => $tmsgtemplate['id']));
}
$tmsgtemplate = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_msg_template') . ' WHERE uniacid = :uniacid and tkey = :key', array(':uniacid' => $_W['uniacid'], ':key' => 'yjsqtz'));
if (empty($tmsgtemplate['id'])) {
$datas = array('uniacid' => $_W['uniacid'], 'tkey' => 'yjsqtz', 'template' => $_GPC['yjsqtz'], 'tenable' => intval($_GPC['yjsqtzenable']));
pdo_insert('wwx_fxxt_msg_template', $datas);
} else {
$datas = array('template' => $_GPC['yjsqtz'], 'tenable' => intval($_GPC['yjsqtzenable']));
pdo_update('wwx_fxxt_msg_template', $datas, array('id' => $tmsgtemplate['id']));
}
$tmsgtemplate = pdo_fetch('SELECT * FROM ' . tablename('wwx_fxxt_msg_template') . ' WHERE uniacid = :uniacid and tkey = :key', array(':uniacid' => $_W['uniacid'], ':key' => 'sjytktz'));
if (empty($tmsgtemplate['id'])) {
$datas = array('uniacid' => $_W['uniacid'], 'tkey' => 'sjytktz', 'template' => $_GPC['sjytktz'], 'tenable' => intval($_GPC['sjytktzenable']));
pdo_insert('wwx_fxxt_msg_template', $datas);
} else {
$datas = array('template' => $_GPC['sjytktz'], 'tenable' => intval($_GPC['sjytktzenable']));
pdo_update('wwx_fxxt_msg_template', $datas, array('id' => $tmsgtemplate['id']));
}
message('更新成功！', $this->createWebUrl('messagetmp'), 'success');
}
include $this->template('messagetmp');
}
public function doWebNotice()
{
global $_GPC, $_W;
load()->func('tpl');
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$operation = empty($_GPC['op']) ? 'display' : $_GPC['op'];
$operation = in_array($operation, array('display')) ? $operation : 'display';
$cfg = $this->module['config'];
if ($_GPC['op'] == 'delete') {
$id = intval($_GPC['id']);
if (empty($id)) {
message('请选择一条记录');
}
pdo_delete('wwx_fxxt_feedback', array('uniacid' => $_W['uniacid'], 'id' => $id));
message('删除成功!', $this->createWebUrl('notice', array('op' => 'display')), 'success');
die;
}
if ($_GPC['op'] == 'deleteout') {
pdo_delete('wwx_fxxt_feedback', array('uniacid' => $_W['uniacid']));
message('全部清空成功!', $this->createWebUrl('notice', array('op' => 'display')), 'success');
die;
}
$adminmsg = '';
if (!empty($cfg['noticeewechat'])) {
$adminopenid = pdo_fetch('SELECT from_user FROM ' . tablename('wwx_fxxt_member') . " WHERE uniacid = :uniacid AND id = :id LIMIT 1", array(':uniacid' => $_W['uniacid'], ':id' => $cfg['noticeewechat']));
if (!empty($adminopenid['from_user'])) {
$adminmsg = $adminopenid['from_user'];
}
}
$pindex = max(1, intval($_GPC['page']));
$psize = 30;
$starttime = empty($_GPC['starttime']) ? strtotime('-1 month') : strtotime($_GPC['starttime']);
$endtime = empty($_GPC['endtime']) ? TIMESTAMP : strtotime($_GPC['endtime']) + 86399;
$where .= " WHERE `uniacid` = :uniacid AND `createtime` >= :starttime AND `createtime` < :endtime";
$paras = array(':uniacid' => $_W['uniacid'], ':starttime' => $starttime, ':endtime' => $endtime);
$keyword = $_GPC['keyword'];
$where .= empty($keyword) ? '' : " AND (( reason LIKE '%" . trim($keyword) . "%' ) OR ( solution LIKE '%" . trim($keyword) . "%' )) ";
$type = empty($_GPC['type']) ? -1 : $_GPC['type'];
$type = intval($type);
if ($type != -1) {
$where .= " AND `type`=:type";
$paras[':type'] = $type;
}
$status = empty($_GPC['status']) ? 5 : intval($_GPC['status']);
$status = intval($status);
if ($status != 5) {
$where .= " AND `status` = :status";
$paras[':status'] = $status;
}
$total = pdo_fetchcolumn("SELECT COUNT(*) FROM " . tablename('wwx_fxxt_feedback') . $where, $paras);
$list = pdo_fetchall("SELECT * FROM " . tablename('wwx_fxxt_feedback') . $where . " ORDER BY id DESC LIMIT " . ($pindex - 1) * $psize . ',' . $psize, $paras);
$pager = pagination($total, $pindex, $psize);
include $this->template('notice');
}
public function doWebRedActivity()
{
global $_W, $_GPC;
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$modulePublic = '../addons/wwx_fxxt/style/static/';
$foo = $_GPC['foo'];
$foos = array('list', 'create', 'modify', 'delete', 'records');
$foo = in_array($foo, $foos) ? $foo : 'list';
require_once WWX_FXXT_ROOT . '/class/Activity.class.php';
if ($foo == 'create') {
if ($_W['ispost']) {
$input = $_GPC;
$input['rules'] = htmlspecialchars_decode($input['rules']);
$input['start'] = strtotime($input['time']['start'] . ':00');
$input['end'] = strtotime($input['time']['end'] . ':59');
$input['share'] = serialize($input['share']);
$input['limit'] = serialize($input['limit']);
if ($input['type'] == 'game') {
$input['tag'] = serialize($input['game']);
} elseif ($input['type'] == 'shared') {
$input['tag'] = serialize($input['shared']);
} else {
$input['tag'] = serialize($input['tag']);
}
$gifts = array();
foreach ($input['gifts']['id'] as $k => $v) {
$gifts[] = array('gift' => $v, 'quantity' => $input['gifts']['quantity'][$k], 'rate' => $input['gifts']['rate'][$k]);
}
$a = new Activity();
$ret = $a->create($input, $gifts);
if (is_error($ret)) {
message($ret['message']);
} else {
message('成功创建活动', $this->createWebUrl('redactivity'));
}
}
$activity = array();
$time = array();
$time['start'] = date('Y-m-d 00:00');
$time['end'] = date('Y-m-d 15:00');
$activity['gifts'] = array();
$activity['type'] = 'shared';
load()->func('tpl');
include $this->template('redactivity_form');
}
if ($foo == 'modify') {
$id = $_GPC['id'];
$id = intval($id);
$a = new Activity();
$activity = $a->getOne($id);
if (empty($activity)) {
$this->error('访问错误');
}
if ($_W['ispost']) {
$input = $_GPC;
$input['rules'] = htmlspecialchars_decode($input['rules']);
$input['start'] = strtotime($input['time']['start'] . ':00');
$input['end'] = strtotime($input['time']['end'] . ':59');
$input['share'] = serialize($input['share']);
$input['limit'] = serialize($input['limit']);
if ($input['type'] == 'game') {
$input['tag'] = serialize($input['game']);
} elseif ($input['type'] == 'shared') {
$input['tag'] = serialize($input['shared']);
} else {
$input['tag'] = serialize($input['tag']);
}
$gifts = array();
foreach ($input['gifts']['id'] as $k => $v) {
$gifts[] = array('gift' => $v, 'quantity' => $input['gifts']['quantity'][$k], 'rate' => $input['gifts']['rate'][$k]);
}
$a = new Activity();
$ret = $a->modify($id, $input, $gifts);
if (is_error($ret)) {
message($ret['message']);
} else {
message('成功编辑活动', $this->createWebUrl('redactivity'));
}
}
$time = array();
$time['start'] = date('Y-m-d H:i', $activity['start']);
$time['end'] = date('Y-m-d H:i', $activity['end']);
if ($activity['type'] == 'game') {
$game = $activity['tag'];
} elseif ($activity['type'] == 'shared') {
$shared = $activity['tag'];
}
load()->func('tpl');
include $this->template('redactivity_form');
}
if ($foo == 'records') {
$id = $_GPC['id'];
$id = intval($id);
$a = new Activity();
$activity = $a->getOne($id);
if (empty($activity)) {
$this->error('访问错误');
}
$filters = array();
$filters['activity'] = $id;
$filters['nickname'] = $_GPC['nickname'];
$pindex = intval($_GPC['page']);
$pindex = max($pindex, 1);
$psize = 20;
$total = 0;
$ds = $a->getRecords($filters, $pindex, $psize, $total);
$pager = pagination($total, $pindex, $psize);
include $this->template('redactivity_records');
}
if ($foo == 'delete') {
$id = $_GPC['id'];
$id = intval($id);
$a = new Activity();
$ret = $a->remove($id);
if (is_error($ret)) {
message($ret['message']);
} else {
message('操作成功', $this->createWebUrl('redactivity'));
}
}
if ($foo == 'list') {
$a = new Activity();
$ds = $a->getAll(array());
if (is_array($ds)) {
foreach ($ds as &$row) {
$url = $this->createMobileUrl('redactivity', array('actid' => $row['actid']));
$row['surl'] = $url;
$url = substr($url, 2);
$url = $_W['siteroot'] . 'app/' . $url;
$row['url'] = $url;
$row['count'] = $a->calcCount($row['actid']);
}
unset($row);
}
include $this->template('redactivity_list');
}
}
public function doWebRedGifts()
{
global $_W, $_GPC;
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
$modulePublic = '../addons/wwx_fxxt/style/static/';
$foo = $_GPC['foo'];
$foos = array('list', 'create', 'modify', 'delete', 'search');
$foo = in_array($foo, $foos) ? $foo : 'list';
require_once WWX_FXXT_ROOT . '/class/Gift.class.php';
if ($foo == 'search') {
$fuzzy = $_GPC['fuzzy'];
$filters = array();
$filters['title'] = $fuzzy;
$g = new Gift();
$ds = $g->getAll($filters, 1, 20);
$rs = array();
if (!empty($ds)) {
foreach ($ds as $row) {
$rs[] = array_elements(array('id', 'type', 'title'), $row);
}
}
die(json_encode($rs));
}
if ($foo == 'create') {
if ($_W['ispost']) {
$input = array_elements(array('title', 'type', 'remark'), $_GPC);
$input['remark'] = htmlspecialchars_decode($input['remark']);
if ($input['type'] == 'cash') {
$input['tag'] = serialize($_GPC['cash']);
} else {
$input['tag'] = '';
}
$g = new Gift();
$ret = $g->create($input);
if (is_error($ret)) {
message($ret['message']);
} else {
message('成功保存礼品信息', $this->createWebUrl('redgifts'));
}
}
$entity = array();
$entity['type'] = 'cash';
$entity['tag'] = array();
load()->func('tpl');
include $this->template('redgifts_form');
}
if ($foo == 'modify') {
$id = $_GPC['id'];
$g = new Gift();
$entity = $g->getOne($id);
if (empty($entity)) {
message('访问错误');
}
if ($_W['ispost']) {
$input = array_elements(array('title', 'type', 'remark'), $_GPC);
$input['remark'] = htmlspecialchars_decode($input['remark']);
if ($input['type'] == 'cash') {
$input['tag'] = serialize($_GPC['cash']);
} else {
$input['tag'] = '';
}
$g = new Gift();
$ret = $g->modify($id, $input);
if (is_error($ret)) {
message($ret['message']);
} else {
message('成功保存礼品信息', $this->createWebUrl('redgifts'));
}
}
load()->func('tpl');
include $this->template('redgifts_form');
}
if ($foo == 'delete') {
$id = $_GPC['id'];
$g = new Gift();
$g->remove($id);
message('成功删除礼品信息', $this->createWebUrl('redgifts'));
}
if ($foo == 'list') {
$a = new Gift();
$ds = $a->getAll(array());
include $this->template('redgifts_list');
}
}
public function doWebRedQr()
{
global $_GPC;
$raw = @base64_decode($_GPC['raw']);
if (!empty($raw)) {
include WWX_FXXT_ROOT . '/class/phpqrcode.php';
QRcode::png($raw, false, QR_ECLEVEL_Q, 4);
}
}
public function doWebRedEntry()
{
global $_W;
if (!$_W['ispost']) {
$this->doWebAuth();
checklogin();
}
include $this->template('redentry');
}
public function doWebRedSend()
{
global $_W, $_GPC;
require_once WWX_FXXT_ROOT . '/class/Fans.class.php';
$f = new Fans();
$uid = intval($_GPC['uid']);
$user = $f->getOne($uid);
if (empty($user)) {
die('错误的访问');
}
$ret = $this->redsend($user);
if (is_error($ret)) {
die($ret['message']);
} else {
die('success');
}
}
public function doWebQuery()
{
global $_W, $_GPC;
$kwd = trim($_GPC['keyword']);
$params = array();
$condition = ' ';
if (!empty($kwd)) {
$condition .= " AND ((member2.nickname LIKE '%" . trim($kwd) . "%') or (member2.realname LIKE '%" . trim($kwd) . "%') or (member2.mobile LIKE '%" . trim($kwd) . "%'))";
}
$ds = pdo_fetchall("select member2.id, member2.nickname, member2.realname, member.avatar, member.mobile, fans.openid from " . tablename('mc_mapping_fans') . " fans, " . tablename('mc_members') . " member, " . tablename('wwx_fxxt_member') . " member2 where fans.uniacid={$_W['uniacid']} {$condition} and fans.uid=member.uid and fans.openid=member2.from_user order by member2.createtime desc");
include $this->template('query');
}
public function doWebQcookie()
{
global $_W;
if (!$_W['isfounder']) {
message('只有创始人才可以使用此功能.');
}
message('清空数据库成功！', '', 'success');
}
}