<?php

/**
 * ECSHOP 报价单
 * ============================================================================
 * * 版权所有 2005-2018 上海商派网络科技有限公司，并保留所有权利。
 * 网站地址: http://www.ecshop.com；
 * ----------------------------------------------------------------------------
 * 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
 * 使用；不允许对程序代码以任何形式任何目的的再发布。
 * ============================================================================
 * $Author: liubo $
 * $Id: quotation.php 17217 2011-01-19 06:29:08Z liubo $
*/
define('IN_ECTOUCH', true);

require(dirname(__FILE__) . '/include/init.php');

$sql = 'DELETE FROM '.$GLOBALS['ecs']->table('products')." WHERE goods_attr= 'Array'";
$GLOBALS['db']->query($sql);



$action  = isset($_REQUEST['act']) ? trim($_REQUEST['act']) : 'default';
if ($action == 'print_quotation')
{

    $smarty->template_dir = DATA_DIR;
    $smarty->assign('shop_name', $_CFG['shop_title']);
    $smarty->assign('cfg',       $_CFG);
    $where = get_quotation_where($_POST);

    $sql = "SELECT g.goods_id, g.goods_name, g.shop_price, g.promote_price, g.goods_number, g.goods_sn, g.goods_thumb, c.cat_name AS goods_category,p.product_id,p.product_number,p.goods_attr".
    " FROM " . $ecs->table('goods') . " AS g LEFT JOIN " . $ecs->table('category') . " AS c ON g.cat_id = c.cat_id LEFT JOIN ".$ecs->table('products')."as p  On g.goods_id=p.goods_id" .
            " LEFT JOIN " . $GLOBALS['ecs']->table('member_price') . " AS mp ".
                    "ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' ".
    $where . " AND is_on_sale = 1 AND is_alone_sale = 1 GROUP BY g.goods_id ";
    $goods_list = $db->getAll($sql);

    foreach($goods_list as $key=>$val)
    {
        $goods_id = $val['goods_id'];
        if(!empty($val['product_id']))
        {
           $product_info=product_info($val['goods_attr'],$val['goods_id']);
           $goods_list[$key]['members_price']  = $val['shop_price'];
           $goods_list[$key]['product_name']=$product_info['attr_value'];
           $goods_list[$key]['attr_price']  =$product_info['attr_price'];
        }
        else
        {
           $goods_list[$key]['members_price']  = $val['shop_price'];
           $goods_list[$key]['product_name']='&nbsp;';
           $goods_list[$key]['product_price']=0;
        }
        $goods_list[$key]['thumb']        = get_image_path($val['goods_id'], $val['goods_thumb'], true);
        $properties = get_goods_properties($val['goods_id']);  // 获得商品的规格和属性
        $goods_list[$key]['specification']        = $properties['spe'];
        
        /* 获得有规格属性的商品的销售价格范围 */
        $sql = "SELECT SUM(max_attr_price) AS max_price FROM (SELECT MAX(attr_price+0) AS max_attr_price FROM " . $GLOBALS['ecs']->table('goods_attr') .
        " WHERE goods_id = '".$goods_id."' GROUP BY attr_id) AS a";
        $max_price = $GLOBALS['db']->getOne($sql);
        if($max_price > 0)
        {
            if ($val['promote_price'] > 0)
            {
            $goods_max_price = $max_price + $val['promote_price'];
            $goods_list[$key]['shop_price'] = number_format($val['promote_price'], 2)." – ".number_format($goods_max_price, 2);            
            }
            else
            {
            $goods_max_price = $max_price + $val['shop_price'];
            $goods_list[$key]['shop_price'] = number_format($val['shop_price'], 2)." – ".number_format($goods_max_price, 2);
            }
        }
        
        $goods_list[$key]['goods_key']=$key;
    }
    $user_rank = $db->getAll("SELECT * FROM " .$ecs->table('user_rank') . "WHERE show_price = 1 OR rank_id = '$_SESSION[user_rank]'");
    $rank_point = 0;
    if (!empty($_SESSION['user_id']))
    {
        $rank_point = $db->getOne("SELECT rank_points FROM " . $ecs->table('users') . " WHERE user_id = '$_SESSION[user_id]'");
    }
    $user_rank = calc_user_rank($user_rank, $rank_point);
    $user_men = serve_user($goods_list);
    $smarty->assign('extend_price', $user_rank['ext_price']);
    $smarty->assign('extend_rank', $user_men);
    $smarty->assign('goods_list', $goods_list);

    $html = $smarty->fetch('quotation_print.html');
    exit($html);
}

assign_template();

$position = assign_ur_here(0, $_LANG['quotation']);
$smarty->assign('page_title', $position['title']);   // 页面标题
$smarty->assign('ur_here',    $position['ur_here']); // 当前位置

$smarty->assign('cat_list', cat_list());
$smarty->assign('brand_list',   get_brand_list());

if (is_null($smarty->get_template_vars('helps')))
{
    $smarty->assign('helps', get_shop_help()); // 网店帮助
}

$smarty->display('quotation.dwt');

function get_quotation_where($filter)
{
    include_once(ROOT_PATH . ADMIN_PATH . '/includes/lib_main.php');
    $_filter = new StdClass();
    $_filter->cat_id = $filter['cat_id'];
    $_filter->brand_id = $filter['brand_id'];
    $where = get_where_sql($_filter);
    $_filter->keyword = $filter['keyword'];
    $where .= isset($_filter->keyword) && trim($_filter->keyword) != '' ? " AND (g.goods_name LIKE '%" . mysql_like_quote($_filter->keyword) . "%' OR g.goods_sn LIKE '%" . mysql_like_quote($_filter->keyword) . "%' OR g.goods_id LIKE '%" . mysql_like_quote($_filter->keyword) . "%') " : '';
    return $where;
}

function calc_user_rank($rank, $rank_point)
{
    $_tmprank = array();
    foreach($rank as $_rank)
    {
        if ($_rank['show_price'])
        {
            $_tmprank['ext_price'][] = $_rank['rank_name'];
            $_tmprank['ext_rank'][] = $_rank['discount'];
        }
        else
        {
            if (!empty($_SESSION['user_id']) && ($rank_point >= $_rank['min_points']))
            {
                $_tmprank['ext_price'][] = $_rank['rank_name'];
                $_tmprank['ext_rank'][] = $_rank['discount'];
            }
        }
    }
    return $_tmprank;
}

function serve_user($goods_list)
{
    foreach ( $goods_list as $key=> $all_list )
    {
        $goods_id = $all_list['goods_id'];
        $goods_key =$all_list['goods_key'];
        $price = $all_list['members_price'];
        $sql = "SELECT rank_id, IFNULL(mp.user_price, r.discount * $price / 100) AS price, r.rank_name, r.discount " .
                'FROM ' . $GLOBALS['ecs']->table('user_rank') . ' AS r ' .
                'LEFT JOIN ' . $GLOBALS['ecs']->table('member_price') . " AS mp ".
                "ON mp.goods_id = '$goods_id' AND mp.user_rank = r.rank_id " .
                "WHERE r.show_price = 1 OR r.rank_id = '$_SESSION[user_rank]'";
        $res = $GLOBALS['db']->getAll($sql);

        foreach ( $res as $row )
        {
            $arr[$row['rank_id']] = array(
                      'rank_name' => htmlspecialchars($row['rank_name']),
                      'price'     => price_format($row['price']+$all_list['attr_price']));

        }
        $arr_list[$goods_key] = $arr;
    }
    return $arr_list;
}
function product_info($goods_attr,$goods_id)
{
    $goods_attr=str_replace('|',' OR goods_attr_id=',$goods_attr);
    $sql="SELECT attr_value,attr_price FROM ". $GLOBALS['ecs']->table('goods_attr') ." WHERE goods_id='$goods_id' AND (goods_attr_id = $goods_attr)";
    $result =$GLOBALS['db']->getAll($sql);
    $i=1;
    $count=count($result);
    foreach ($result as $val)
    {
        $i==$count?$f='':$f='/';
        $product_info['attr_value'].=$val['attr_value'].$f;
        $product_info['attr_price']+=$val['attr_price'];
        $i++;
    }
    return($product_info);
}
?>