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":"操作成功"}'); } ?>