Example #1
0
        $admin_list = $db->query($sql_select);
        $admin_list = fetch_assoc($admin_list);
        $list = array();
        foreach ($admin_list as $a) {
            $list[] = $a['user_id'];
        }
        $admin_list = implode(',', $list);
        $sql_select = 'SELECT final_amount FROM ' . $GLOBALS['ecs']->table('order_info') . " WHERE order_id={$order_id}";
        $order_amount = $GLOBALS['db']->getOne($sql_select);
        if ($order_amount < 800) {
            $sql_update = 'UPDATE ' . $ecs->table('users') . ' u,' . $GLOBALS['ecs']->table('admin_user') . " a SET u.admin_id={$admin_id},u.order_time={$order_time},u.admin_name=a.user_name,u.role_id=a.role_id," . 'u.group_id=a.group_id,u.assign_time=UNIX_TIMESTAMP(),a.counter=a.counter+1 WHERE u.admin_id IN (' . "{$admin_list}) AND u.user_id={$res['user_id']} AND a.user_id={$admin_id}";
        } else {
            $sql_update = 'UPDATE ' . $ecs->table('users') . ' u,' . $GLOBALS['ecs']->table('admin_user') . ' a SET u.admin_id=4,u.admin_name=a.user_name,u.assign_time=UNIX_TIMESTAMP(),u.group_id=a.group_id,' . "u.role_id=a.role_id, u.order_time={$order_time}, a.counter=a.counter+1 WHERE u.admin_id IN (" . "{$admin_list}) AND u.user_id={$res['user_id']} AND a.user_id=4";
        }
        $db->query($sql_update);
        update_taking_time($order_id);
        unset($admin_list);
        $sql_select = 'SELECT rec_id,is_package FROM `crm_order_goods`' . " WHERE order_id={$val['order_id']}";
        $goods_list = $db->query($sql_select);
        $goods_list = fetch_assoc($goods_list);
        foreach ($goods_list as $v) {
            if ($v['is_package']) {
                $sql_update = 'UPDATE `crm_packing` p,`crm_order_goods` o SET ' . "o.taking_time=o.goods_number*p.take_days*24*3600 WHERE o.rec_id={$v['rec_id']}";
                $db->query($sql_update);
            } else {
                $sql_update = 'UPDATE `crm_goods` g,`crm_order_goods` o SET ' . "o.taking_time=o.goods_number*g.take_days WHERE o.rec_id={$v['rec_id']}";
                $db->query($sql_update);
            }
        }
    }
}
Example #2
0
             if ($parent_id > 0) {
                 //推荐送积分规则是否开启
                 $sql_select = 'SELECT integral_id,scale FROM ' . $GLOBALS['ecs']->table('integral') . ' WHERE integral_way=2 AND available=1 AND present_end>' . time() . " AND {$order['final_amount']}=>min_consume";
                 $integral_info = $GLOBALS['db']->getRow($sql_select);
                 //加入未确认表
                 $sql_insert = 'INSERT INTO ' . $GLOBALS['ecs']->table('user_integral') . '(integral_id,points,source_id,user_id,admin_id,exchange_points)VALUES' . "({$integral_info['integral_id']},{$integral_info['scale']},{$order['order_id']},{$_SESSION['admin_id']},{$integral_info['scale']})";
                 $GLOBALS['db']->query($sql_insert);
             }
         }
         assign_user($order_id);
         //确认收货转顾客,发货时间在2016-01-04之前
         //$sql_select = 'SELECT shipping_time FROM '.$GLOBALS['ecs']->table('order_info')." WHERE order_id=$order_id";
         //$shipping_time = $GLOBALS['db']->getOne($sql_select);
         //if ($shipping_time < strtotime(date('Y-m-d','2016-01-05'))) {
         //}
         update_taking_time();
         // 更新商品可服用时间
         if (in_array($user['customer_type'], array(1, 12, 6, 7, 8, 13, 14, 15, 16, 17))) {
             // 将成交的顾客转到已购买顾客中
             $sql_update = 'UPDATE ' . $GLOBALS['ecs']->table('users') . " SET customer_type=IF(customer_type<>1,2,1) WHERE user_id={$user['user_id']}";
             $GLOBALS['db']->query($sql_update);
             file_put_contents('../batch_user.log', date('Y-m-d H:i:s') . $_SESSION['admin_name'] . '成交顾客转到已购' . PHP_EOL . $sql_update . PHP_EOL, FILE_APPEND);
         }
         $res['timeout'] = 2000;
         $res['message'] = '确认收货已完成!';
         die($json->encode($res));
     }
 } else {
     $receive_status = intval($_REQUEST['receive_status']);
     $others = '';
     if (!empty($_REQUEST['others'])) {