// 固话 $sql_insert_assign = sprintf($sql_insert, $user_id, 'tel', $userinfo['home_phone'], 1, 'tel', $userinfo['home_phone']); $db->query($sql_insert_assign); // 手机号码 $sql_insert_assign = sprintf($sql_insert, $user_id, 'mobile', $userinfo['mobile_phone'], 1, 'mobile', $userinfo['mobile_phone']); $db->query($sql_insert_assign); // QQ $sql_insert_assign = sprintf($sql_insert, $user_id, 'qq', $userinfo['qq'], 1, 'qq', $userinfo['qq']); $db->query($sql_insert_assign); // aliww $sql_insert_assign = sprintf($sql_insert, $user_id, 'aliww', $userinfo['aliww'], 1, 'aliww', $userinfo['aliww']); $db->query($sql_insert_assign); /* 推荐顾客赠送积分 */ if (!empty($userinfo['parent_id'])) { include_once './includes/cls_integral.php'; $integ = new integral($ecs->table('integral'), $db); $integral = $integ->countIntegral($userinfo['role_id'], 1); $validity = strtotime(date('Ym', time()) + intval($integral['validity'])); if ($integral['integral_way'] == 1) { $sql = 'INSERT INTO ' . $ecs->table('user_integral') . '(integral_id,exchange_points,source,source_id,receive_time,validity,user_id,admin_id)' . "VALUES('{$integral['integral_id']}','{$integral['scale']}','users','{$user_id}'," . " UNIX_TIMESTAMP(),{$validity},'{$userinfo['parent_id']}',{$_SESSION['admin_id']})"; $db->query($sql); } } /* 记录管理员操作 */ admin_log($_POST['username'], 'add', 'users'); $uname = implode('', $_REQUEST['uname']); if (!empty($uname)) { insertSocial(); } $res['code'] = 1; $res['message'] = '顾客添加成功!';
<?php define('IN_ECS', true); require dirname(__FILE__) . '/includes/init.php'; require 'includes/cls_integral.php'; date_default_timezone_set('Aisa/Shanghai'); $nowtime = time() + 28800; $allow_action = array('list', 'add', 'insert', 'edit', 'update', 'remove'); $_REQUEST['act'] = in_array($_REQUEST['act'], $allow_action) ? $_REQUEST['act'] : 'list'; if ($_REQUEST['act'] == 'list') { $integral = new integral($GLOBALS['ecs']->table('integral'), $GLOBALS['db']); $list = $integral->getIntegralList(); foreach ($list as &$val) { $sql = 'SELECT SUM(integral) FROM ' . $GLOBALS['ecs']->table('user_integral') . " WHERE validity>{$nowtime} AND integral_id={$val['integral_id']}"; $val['hadsent'] = $GLOBALS['db']->getOne($sql); } /* 模板赋值 */ $smarty->assign('full_page', 1); $smarty->assign('ur_here', $_LANG['041_marketing']); $smarty->assign('action_link', array('href' => 'integral.php?act=add', 'text' => $_LANG['add_integral_rule'])); $smarty->assign('filter', $list['filter']); $smarty->assign('record_count', $list['record_count']); $smarty->assign('page_count', $list['page_count']); $smarty->assign('list', $list); $sort_flag = sort_flag($list['filter']); $smarty->assign($sort_flag['tag'], $sort_flag['img']); /* 显示商品列表页面 */ assign_query_info(); $smarty->display('integral_list.htm'); } elseif ($_REQUEST['act'] == 'add') { admin_priv('marketing');