PHP integral Examples

Example #1

File: users.php Project: 554119220/kjrscrm

 // 固话
 $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'] = '顾客添加成功！';

Example #2

File: integral.php Project: 554119220/kjrscrm

<?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');