function affiliate_separate_all($db, $affiliate, $separate_by)
{
$logdb = get_affiliate_ck();
foreach ($logdb['logdb'] as $val) {
if ($val['is_separate'] == '0') {
$row = $db->getRow("SELECT o.order_sn, o.is_separate, (o.goods_amount - o.discount) AS goods_amount, o.user_id FROM " . $GLOBALS['ecs']->table('order_info') . " o" . " LEFT JOIN " . $GLOBALS['ecs']->table('users') . " u ON o.user_id = u.user_id" . " WHERE order_id = " . $val['order_id']);
affiliate_separate($db, $row, $val['order_id'], $affiliate, $separate_by);
}
}
}
if ($_REQUEST['act'] == 'list') {
$logdb = get_affiliate_ck();
$smarty->assign('full_page', 1);
$smarty->assign('ur_here', $_LANG['affiliate_ck']);
$smarty->assign('on', $separate_on);
$smarty->assign('logdb', $logdb['logdb']);
$smarty->assign('filter', $logdb['filter']);
$smarty->assign('record_count', $logdb['record_count']);
$smarty->assign('page_count', $logdb['page_count']);
if (!empty($_GET['auid'])) {
$smarty->assign('action_link', array('text' => $_LANG['back_note'], 'href' => "users.php?act=edit&id={$_GET['auid']}"));
}
assign_query_info();
$smarty->display('affiliate_ck_list.htm');
} elseif ($_REQUEST['act'] == 'query') {
$logdb = get_affiliate_ck();
$smarty->assign('logdb', $logdb['logdb']);
$smarty->assign('on', $separate_on);
$smarty->assign('filter', $logdb['filter']);
$smarty->assign('record_count', $logdb['record_count']);
$smarty->assign('page_count', $logdb['page_count']);
$sort_flag = sort_flag($logdb['filter']);
$smarty->assign($sort_flag['tag'], $sort_flag['img']);
make_json_result($smarty->fetch('affiliate_ck_list.htm'), '', array('filter' => $logdb['filter'], 'page_count' => $logdb['page_count']));
} elseif ($_REQUEST['act'] == 'del') {
$oid = (int) $_REQUEST['oid'];
$stat = $db->getOne("SELECT is_separate FROM " . $GLOBALS['ecs']->table('order_info') . " WHERE order_id = '{$oid}'");
if (empty($stat)) {
$sql = "UPDATE " . $GLOBALS['ecs']->table('order_info') . " SET is_separate = 2" . " WHERE order_id = '{$oid}'";
$db->query($sql);
}
if ($value['level'] == 5) {
$wxid = $value['wxid'];
$value['head_url'] = $GLOBALS['db']->getOne("SELECT headimgurl FROM wxch_user WHERE wxid = '{$wxid}'");
$value['nickname'] = $GLOBALS['db']->getOne("SELECT nickname FROM wxch_user WHERE wxid = '{$wxid}'");
$new_arr[] = $value;
}
}
$count = count($new_arr);
$smarty->assign('count', $count);
$smarty->assign('user_list', $new_arr);
$smarty->display('distribute.dwt');
} elseif ($action == 'myorder') {
//显示分成记录
$user_id = $_GET['user_id'];
$level = $_GET['level'];
$logdb = get_affiliate_ck($user_id, $level);
$smarty->assign('logdb', $logdb['logdb']);
$smarty->assign('level', $level);
//显示分成记录结束
$smarty->display('user_clips.dwt');
} elseif ($action == 'myorder_detail') {
include_once ROOT_PATH . 'include/lib_transaction.php';
include_once ROOT_PATH . 'include/lib_payment.php';
include_once ROOT_PATH . 'include/lib_order.php';
include_once ROOT_PATH . 'include/lib_clips.php';
$order_id = isset($_GET['order_id']) ? intval($_GET['order_id']) : 0;
/* 订单详情 */
$order = get_order_detail_new($order_id, $user_id);
if ($order === false) {
$err->show($_LANG['back_home_lnk'], './');
exit;
if ($_REQUEST['act'] == 'list') {
$smarty->assign('ur_here', $_LANG['order_list']);
//显示分成记录
$user_id = intval($_GET['user_id']);
$uid = intval($_GET['uid']);
$level = intval($_GET['level']);
$logdb = get_affiliate_ck($user_id);
$smarty->assign('logdb', $logdb['logdb']);
$smarty->assign('filter', $logdb['filter']);
$smarty->assign('record_count', $logdb['record_count']);
$smarty->assign('page_count', $logdb['page_count']);
$smarty->assign('full_page', 1);
$smarty->assign('action_link', array('href' => 'user_grade.php?act=list&user_id=' . $uid . '&level=' . $level, 'text' => $_LANG['back']));
$smarty->display('distrib_order.htm');
} elseif ($_REQUEST['act'] == 'query') {
$logdb = get_affiliate_ck($user_id);
$smarty->assign('logdb', $logdb['logdb']);
$smarty->assign('filter', $logdb['filter']);
$smarty->assign('record_count', $logdb['record_count']);
$smarty->assign('page_count', $logdb['page_count']);
make_json_result($smarty->fetch('distrib_order.htm'), '', array('filter' => $user_list['filter'], 'page_count' => $user_list['page_count']));
}
//定义，显示某个会员下面的分成订单情况
function get_affiliate_ck($user_id)
{
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('order_info') . " o" . " LEFT JOIN" . $GLOBALS['ecs']->table('users') . " u ON o.user_id = u.user_id" . " LEFT JOIN " . $GLOBALS['ecs']->table('affiliate_log') . " a ON o.order_id = a.order_id" . " WHERE o.user_id > 0 AND a.user_id = '{$user_id}' AND o.is_separate > 0 AND a.separate_type = 0";
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
$logdb = array();
/* 分页大小 */
$filter = page_and_size($filter);
$sql = "SELECT o.*, a.log_id,a.user_id as suid, a.user_name as auser, a.money, a.point, a.separate_type,u.parent_id as up FROM " . $GLOBALS['ecs']->table('order_info') . " o" . " LEFT JOIN" . $GLOBALS['ecs']->table('users') . " u ON o.user_id = u.user_id" . " LEFT JOIN " . $GLOBALS['ecs']->table('affiliate_log') . " a ON o.order_id = a.order_id" . " WHERE o.user_id > 0 AND a.user_id = '{$user_id}' AND o.is_separate > 0 AND a.separate_type = 0" . " ORDER BY order_id DESC";
