$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); } } } }
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'])) {