www.gusucode.com > mcms手机网站系统 v3.1源码程序 > mcms_v3.1.0/upload/app/admin/points.php

    <?php
/*
 * MCMS Copyright (c) 2012-2013 ZhangYiYeTai Inc.
 *
 *  http://www.mcms.cc
 *
 * The program developed by loyjers core architecture, individual all rights reserved,
 * if you have any questions please contact loyjers@126.com
 */

require_once(dirname(__FILE__) . "/../../init.php"); //公用引导启动文件
check_login();
check_level('B03',AJAX);
$time_start = H :: getmicrotime(); //开始时间

// 动作处理
call_mfunc();

// 模板处理
require_once(assign_tpl(basename(__FILE__), 'admin'));

// ******************************************************* 函数方法 *******************************************************
function m__list(){
    global $dbm,$result,$p,$U;
    $_GET = H::sqlxss($_GET);
    $params['where'] = " 1=1";
    $login_name = isset($_GET['login_name']) ? trim($_GET['login_name']) : '';
    $point_min = isset($_GET['point_min']) ? intval($_GET['point_min']) : 0;
    $point_max = isset($_GET['point_max']) ? intval($_GET['point_max']) : 0;
    $start_time = isset($_GET['start_time']) ? trim($_GET['start_time']) : '';
    $end_time = isset($_GET['end_time']) ? trim($_GET['end_time']) : '';
    if($login_name!='') {
        $user_info=$U->get($login_name,'*',2);
        if($user_info) $params['where'] .=" and  uid=".$user_info['uid'];
    }
    if($point_min>0 && $point_max>0)  $params['where'] .=" and point>=".$point_min." and point<=".$point_max;
    if($point_min>0 && $point_max<=0)  $params['where'] .=" and point>=".$point_min;
    if($point_min<=0 && $point_max>0)  $params['where'] .=" and point<=".$point_max;
    if($start_time!='' && $end_time!='') $params['where'] .=" and create_time>=".strtotime($start_time)." and create_time<=".strtotime($end_time);
    if($start_time!='' && $end_time=='') $params['where'] .=" and create_time>=".strtotime($start_time);
    if($start_time=='' && $end_time!='') $params['where'] .=" and create_time<=".strtotime($end_time);
    $params['table_name'] = TB_PRE . "point";
    $params['count'] = 1 ;
    $params['suffix'] = " order by point_id desc ";
    $params['pagesize'] = get_pagesize(PAGESIZE_ADMIN);
    $params['suffix'] .= $dbm -> get_limit_sql($params['pagesize'], $p);
    $result = $dbm -> single_query($params);
    foreach($result['list'] as $k=>$v) {
        $user=$U->get($v['uid']);
        $result['list'][$k]['uname'] = $user['login_name'];
    }
    $sql = "select uid,login_name from ".TB_PRE."user";
    $us = $dbm->query($sql);
    $result['user'] = array();
    $result['user'][0] = array('txt'=>'选择用户','value'=>'0');
    foreach($us['list'] as $k=>$v) {
        $k++;
        $result['user'][$k] = array('txt'=>$v['login_name'],'value'=>$v['uid']);
    }
}

//批量保存修改
function m__save_all(){
    global $dbm;
    check_level('C0502',AJAX);
    $_POST=H::sqlxss($_POST);
    foreach($_POST['params'] as $v){
        $point_id=intval($v['id']);unset($v[0]);unset($v['id']);
        if(!is_numeric($v['point'])) die('{"code":"1","msg":"积分必须是数字"}');
        //if(!is_numeric($v['point_type'])) die('{"code":"1","msg":"获取积分必须是数字"}');
        $dbm->single_update(TB_PRE."point",$v,"point_id='$point_id'");
    }
    die('{"code":"0","msg":"操作成功"}');
}

//会员充值积分
function m__save(){
    global $dbm;
    check_level('C0503',AJAX);
    $fields = array();
    $fields['uid'] = isset($_POST['user'])?intval($_POST['user']):0;
    $fields['point'] = isset($_POST['point'])?intval($_POST['point']):0;
    if($fields['uid']==0) die('{"code":"1","msg":"请选择会员","id":"user"}');
    if($fields['point']==0) die('{"code":"2","msg":"请输入积分数","id":"point"}');
    $ret = $dbm->single_insert(TB_PRE."point",$fields);
    if($ret['error']=='') die('{"code":"0","msg":"充值成功"}');
}
//批量移除积分
function m__del(){
    global $dbm,$C;
    check_level('C0501',AJAX);
    $_POST=H::sqlxss($_POST);
    $_POST['params']=isset($_POST['params'])?trim($_POST['params']):'';
    $_POST['params']=explode(',',$_POST['params']);
    foreach($_POST['params'] as $v){
        $point_id=intval($v);
        if($point_id <=0) continue;
            $sql="delete from ".TB_PRE."point where point_id='$point_id'";
            $rs=$dbm->query_update($sql);
    }
    die('{"code":"0","msg":"操作成功"}');
}

?>