ecshop二次开发秒杀、限时折扣、清仓等功能

转载 2015年07月07日 13:50:55

ecshop二次开发秒杀、限时折扣、清仓等功能

 限时抢购,秒杀商品的二次开发

1,先在后台admin/templates 中找goods_info.htm文件到促销部分,改为一个下拉列表的分别是促销,限时,秒杀,值分别是1,2,3
这样,代码如下:
复制代码
<!--                  限时抢购开始 liangfang edit-->
          <tr>
            <td class="label"><label for="is_promote">
                        <input type="checkbox" id="is_promote_switch" name="is_promote_switch" value="1" {if $goods.is_promote}checked="checked"{/if} onclick="handlePromote(this.checked);" /> 是否参加促销</label>
                        <select name="is_promote" id="is_promote">
                        <option value="1" {if $goods.is_promote eq 1}selected="selected"{/if} >{$lang.lab_promote_price}</option>
                        <option value="2" {if $goods.is_promote eq 2}selected="selected"{/if} >限时价:</option>
                        <option value="3" {if $goods.is_promote eq 3}selected="selected"{/if} >秒杀价:</option>
                        </select></td>
            <td id="promote_3"><input type="text" id="promote_1" name="promote_price" value="{$goods.promote_price}" size="20" /></td>
          </tr>
          <tr id="promote_4">
            <td class="label" id="promote_5">{$lang.lab_promote_date}</td>
            <td id="promote_6">
              <input name="promote_start_date" type="text" id="promote_start_date" size="15" value='{$goods.promote_start_date}' readonly="readonly" /><input name="selbtn1" type="button" id="selbtn1" onclick="return showCalendar('promote_start_date', '%Y-%m-%d %H:%M', '24', false, 'selbtn1');" value="{$lang.btn_select}" class="button"/> - <input name="promote_end_date" type="text" id="promote_end_date" size="15" value='{$goods.promote_end_date}' readonly="readonly" /><input name="selbtn2" type="button" id="selbtn2" onclick="return showCalendar('promote_end_date', '%Y-%m-%d %H:%M', '24', false, 'selbtn2');" value="{$lang.btn_select}" class="button"/>
            </td>
          </tr>
<!--                  限时抢购结束-->       
复制代码

 



其中对时间选择框进行了重新设置为显示小时和分钟。
2,把admin下的goods.php 改一句话,注释部分是原先的代码
        $is_promote = empty($promote_price) ? 0 : $_POST['is_promote'];//liangfang edit
   // $is_promote = empty($promote_price) ? 0 : 1;

3、把下面的方法复制到你需要调用的页面:(方法中的sql条件WHERE is_promote = '2'是控制调用促销/限时/秒杀的)

复制代码
/**
 * 获得分类下的秒杀-限时折扣
 *
 * @access  public
 * @param   string  $children
 * @return  array
 */
function category_get_goods_zhekou($children, $brand, $min, $max, $ext, $size, $page, $sort, $order)
{
    $display = $GLOBALS['display'];
    $where = "g.is_on_sale = 1 AND g.is_alone_sale = 1 AND ".
            "g.is_delete = 0 AND ($children OR " . get_extension_goods($children) . ')';

    if ($brand > 0)
    {
        $where .=  "AND g.brand_id=$brand ";
    }

    if ($min > 0)
    {
        $where .= " AND g.shop_price >= $min ";
    }

    if ($max > 0)
    {
        $where .= " AND g.shop_price <= $max ";
    }

    /* 获得商品列表 */

            $now_time = gmtime();
             $sql = "SELECT g.goods_id,g.goods_thumb,g.goods_name,g.shop_price,g.promote_price,g.promote_start_date,g.promote_end_date FROM "
         .$GLOBALS['ecs']->table('goods'). ' AS g ' .
             'LEFT JOIN ' . $GLOBALS['ecs']->table('member_price') . ' AS mp ' .
                "ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' " .
          " WHERE is_promote = '2' and promote_start_date <= '$now_time' and  promote_end_date >= '$now_time' and is_on_sale = 1 and is_alone_sale = 1 and is_delete = 0 order by promote_start_date ";
    $res = $GLOBALS['db']->selectLimit($sql, $size, ($page - 1) * $size);

    $arr = array();
    while ($row = $GLOBALS['db']->fetchRow($res))
    {
        if ($row['promote_price'] > 0)
        {
            $promote_price = bargain_price($row['promote_price'], $row['promote_start_date'], $row['promote_end_date']);
        }
        else
        {
            $promote_price = 0;
        }

        /* 处理商品水印图片 */
        $watermark_img = '';

        if ($promote_price != 0)
        {
            $watermark_img = "watermark_promote_small";
        }
        elseif ($row['is_new'] != 0)
        {
            $watermark_img = "watermark_new_small";
        }
        elseif ($row['is_best'] != 0)
        {
            $watermark_img = "watermark_best_small";
        }
        elseif ($row['is_hot'] != 0)
        {
            $watermark_img = 'watermark_hot_small';
        }

        if ($watermark_img != '')
        {
            $arr[$row['goods_id']]['watermark_img'] =  $watermark_img;
        }

        $arr[$row['goods_id']]['goods_id']         = $row['goods_id'];
        if($display == 'grid')
        {
            $arr[$row['goods_id']]['goods_name']       = $GLOBALS['_CFG']['goods_name_length'] > 0 ? sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $row['goods_name'];
        }
        else
        {
            $arr[$row['goods_id']]['goods_name']       = $row['goods_name'];
        }
        $arr[$row['goods_id']]['name']             = $row['goods_name'];
        $arr[$row['goods_id']]['goods_brief']      = $row['goods_brief'];
        $arr[$row['goods_id']]['goods_style_name'] = add_style($row['goods_name'],$row['goods_name_style']);
        $arr[$row['goods_id']]['market_price']     = price_format($row['market_price']);
        $arr[$row['goods_id']]['shop_price']       = price_format($row['shop_price']);
        $arr[$row['goods_id']]['type']             = $row['goods_type'];
        $arr[$row['goods_id']]['promote_price']    = ($promote_price > 0) ? price_format($promote_price) : '';
        $arr[$row['goods_id']]['goods_thumb']      = get_image_path($row['goods_id'], $row['goods_thumb'], true);
        $arr[$row['goods_id']]['goods_img']        = get_image_path($row['goods_id'], $row['goods_img']);
        $arr[$row['goods_id']]['url']              = build_uri('goods', array('gid'=>$row['goods_id']), $row['goods_name']);
        
        $arr[$row['goods_id']]['keywords']             = $row['keywords'];
    }

    return $arr;
}
/**
 * 获得分类下的清仓捡耙活
 *
 * @access  public
 * @param   string  $children
 * @return  array
 */
function category_get_goods_clear($children, $brand, $min, $max, $ext, $size, $page, $sort, $order)
{
    $display = $GLOBALS['display'];
    $where = "g.is_on_sale = 1 AND g.is_alone_sale = 1 AND ".
            "g.is_delete = 0 AND ($children OR " . get_extension_goods($children) . ')';

    if ($brand > 0)
    {
        $where .=  "AND g.brand_id=$brand ";
    }

    if ($min > 0)
    {
        $where .= " AND g.shop_price >= $min ";
    }

    if ($max > 0)
    {
        $where .= " AND g.shop_price <= $max ";
    }

    /* 获得商品列表 */

            $now_time = gmtime();
             $sql = "SELECT g.goods_id,g.goods_thumb,g.goods_name,g.shop_price,g.promote_price,g.promote_start_date,g.promote_end_date FROM "
         .$GLOBALS['ecs']->table('goods'). ' AS g ' .
             'LEFT JOIN ' . $GLOBALS['ecs']->table('member_price') . ' AS mp ' .
                "ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' " .
          " WHERE is_promote = '3' and promote_start_date <= '$now_time' and  promote_end_date >= '$now_time' and is_on_sale = 1 and is_alone_sale = 1 and is_delete = 0 order by promote_start_date ";
    $res = $GLOBALS['db']->selectLimit($sql, $size, ($page - 1) * $size);

    $arr = array();
    while ($row = $GLOBALS['db']->fetchRow($res))
    {
        if ($row['promote_price'] > 0)
        {
            $promote_price = bargain_price($row['promote_price'], $row['promote_start_date'], $row['promote_end_date']);
        }
        else
        {
            $promote_price = 0;
        }

        /* 处理商品水印图片 */
        $watermark_img = '';

        if ($promote_price != 0)
        {
            $watermark_img = "watermark_promote_small";
        }
        elseif ($row['is_new'] != 0)
        {
            $watermark_img = "watermark_new_small";
        }
        elseif ($row['is_best'] != 0)
        {
            $watermark_img = "watermark_best_small";
        }
        elseif ($row['is_hot'] != 0)
        {
            $watermark_img = 'watermark_hot_small';
        }

        if ($watermark_img != '')
        {
            $arr[$row['goods_id']]['watermark_img'] =  $watermark_img;
        }

        $arr[$row['goods_id']]['goods_id']         = $row['goods_id'];
        if($display == 'grid')
        {
            $arr[$row['goods_id']]['goods_name']       = $GLOBALS['_CFG']['goods_name_length'] > 0 ? sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $row['goods_name'];
        }
        else
        {
            $arr[$row['goods_id']]['goods_name']       = $row['goods_name'];
        }
        $arr[$row['goods_id']]['name']             = $row['goods_name'];
        $arr[$row['goods_id']]['goods_brief']      = $row['goods_brief'];
        $arr[$row['goods_id']]['goods_style_name'] = add_style($row['goods_name'],$row['goods_name_style']);
        $arr[$row['goods_id']]['market_price']     = price_format($row['market_price']);
        $arr[$row['goods_id']]['shop_price']       = price_format($row['shop_price']);
        $arr[$row['goods_id']]['type']             = $row['goods_type'];
        $arr[$row['goods_id']]['promote_price']    = ($promote_price > 0) ? price_format($promote_price) : '';
        $arr[$row['goods_id']]['goods_thumb']      = get_image_path($row['goods_id'], $row['goods_thumb'], true);
        $arr[$row['goods_id']]['goods_img']        = get_image_path($row['goods_id'], $row['goods_img']);
        $arr[$row['goods_id']]['url']              = build_uri('goods', array('gid'=>$row['goods_id']), $row['goods_name']);
        
        $arr[$row['goods_id']]['keywords']             = $row['keywords'];
    }

    return $arr;
}
/**
 * 获得分类下的爆款促销
 *
 * @access  public
 * @param   string  $children
 * @return  array
 */
function category_get_goods_cuxiao($children, $brand, $min, $max, $ext, $size, $page, $sort, $order)
{
    $display = $GLOBALS['display'];
    $where = "g.is_on_sale = 1 AND g.is_alone_sale = 1 AND ".
            "g.is_delete = 0 AND ($children OR " . get_extension_goods($children) . ')';

    if ($brand > 0)
    {
        $where .=  "AND g.brand_id=$brand ";
    }

    if ($min > 0)
    {
        $where .= " AND g.shop_price >= $min ";
    }

    if ($max > 0)
    {
        $where .= " AND g.shop_price <= $max ";
    }

    /* 获得商品列表 */

            $now_time = gmtime();
             $sql = "SELECT g.goods_id,g.goods_thumb,g.goods_name,g.shop_price,g.promote_price,g.promote_start_date,g.promote_end_date FROM "
         .$GLOBALS['ecs']->table('goods'). ' AS g ' .
             'LEFT JOIN ' . $GLOBALS['ecs']->table('member_price') . ' AS mp ' .
                "ON mp.goods_id = g.goods_id AND mp.user_rank = '$_SESSION[user_rank]' " .
          " WHERE is_promote = '1' and promote_start_date <= '$now_time' and  promote_end_date >= '$now_time' and is_on_sale = 1 and is_alone_sale = 1 and is_delete = 0 order by promote_start_date ";
    $res = $GLOBALS['db']->selectLimit($sql, $size, ($page - 1) * $size);

    $arr = array();
    while ($row = $GLOBALS['db']->fetchRow($res))
    {
        if ($row['promote_price'] > 0)
        {
            $promote_price = bargain_price($row['promote_price'], $row['promote_start_date'], $row['promote_end_date']);
        }
        else
        {
            $promote_price = 0;
        }

        /* 处理商品水印图片 */
        $watermark_img = '';

        if ($promote_price != 0)
        {
            $watermark_img = "watermark_promote_small";
        }
        elseif ($row['is_new'] != 0)
        {
            $watermark_img = "watermark_new_small";
        }
        elseif ($row['is_best'] != 0)
        {
            $watermark_img = "watermark_best_small";
        }
        elseif ($row['is_hot'] != 0)
        {
            $watermark_img = 'watermark_hot_small';
        }

        if ($watermark_img != '')
        {
            $arr[$row['goods_id']]['watermark_img'] =  $watermark_img;
        }

        $arr[$row['goods_id']]['goods_id']         = $row['goods_id'];
        if($display == 'grid')
        {
            $arr[$row['goods_id']]['goods_name']       = $GLOBALS['_CFG']['goods_name_length'] > 0 ? sub_str($row['goods_name'], $GLOBALS['_CFG']['goods_name_length']) : $row['goods_name'];
        }
        else
        {
            $arr[$row['goods_id']]['goods_name']       = $row['goods_name'];
        }
        $arr[$row['goods_id']]['name']             = $row['goods_name'];
        $arr[$row['goods_id']]['goods_brief']      = $row['goods_brief'];
        $arr[$row['goods_id']]['goods_style_name'] = add_style($row['goods_name'],$row['goods_name_style']);
        $arr[$row['goods_id']]['market_price']     = price_format($row['market_price']);
        $arr[$row['goods_id']]['shop_price']       = price_format($row['shop_price']);
        $arr[$row['goods_id']]['type']             = $row['goods_type'];
        $arr[$row['goods_id']]['promote_price']    = ($promote_price > 0) ? price_format($promote_price) : '';
        $arr[$row['goods_id']]['goods_thumb']      = get_image_path($row['goods_id'], $row['goods_thumb'], true);
        $arr[$row['goods_id']]['goods_img']        = get_image_path($row['goods_id'], $row['goods_img']);
        $arr[$row['goods_id']]['url']              = build_uri('goods', array('gid'=>$row['goods_id']), $row['goods_name']);
        
        $arr[$row['goods_id']]['keywords']             = $row['keywords'];
    }

    return $arr;
}
复制代码

 

4、在下面这句代码下加入调用的代码;
$smarty->assign('goods_list',       $goodslist);
复制代码
/**清仓捡耙活商品列表**/
        $goodslist_clear = category_get_goods_clear($children, $brand, $price_min, $price_max, $ext, $size, $page, $sort, $order);
        if($display == 'grid')
        {
            if(count($goodslist_clear) % 2 != 0)
            {
                $goodslist_clear[] = array();
            }
        }
        $smarty->assign('goodslist_clear',       $goodslist_clear);
        /**清仓捡耙活商品列表**/
        /**爆款促销列表**/
        $goodslist_cx = category_get_goods_cuxiao($children, $brand, $price_min, $price_max, $ext, $size, $page, $sort, $order);
        if($display == 'grid')
        {
            if(count($goodslist_cx) % 2 != 0)
            {
                $goodslist_cx[] = array();
            }
        }
        $smarty->assign('goodslist_cx',       $goodslist_cx);
        /**爆款促销列表**/
            /**限时折扣列表**/
        $goodslist_zhekou = category_get_goods_zhekou($children, $brand, $price_min, $price_max, $ext, $size, $page, $sort, $order);
        if($display == 'grid')
        {
            if(count($goodslist_zhekou) % 2 != 0)
            {
                $goodslist_zhekou[] = array();
            }
        }
        $smarty->assign('goodslist_zhekou',       $goodslist_zhekou);
        /**限时折扣列表**/
复制代码

 

相关文章推荐

ecshop 中添加限时抢购功能(倒计时)

第一步:在后台admin/templates/goods_info.htm中找到大概165行修改

ecshop二次开发秒杀

1.进入后台系统管理-》自定义导航栏-》添加一个秒杀活动 2.点击秒杀活动 3. ...

ecshop二次开发——为用户提供商品批注功能

需求: 每个登录的用户都可以对商品进行批注
  • donhao
  • donhao
  • 2013年11月26日 10:48
  • 1964

[OK]ecshop二次开发:商品分类添加图片显示功能

ecshop的分类添加分类图片的功能,下面归类一下: 1、最关键的就是在数据的category表里面加入category_img字段,用来保存咱们的图片地址,类型就是varchar就可以了。 2...
  • ximo
  • ximo
  • 2012年09月18日 10:21
  • 1929

Ecshop实现后台二次开发后功能模块仍然可以分配权限

我们对ec后台进行二次开发在可以在左面菜单栏加入新的功能模块有关如何加入我在之前帖子有说过 今天我们要分析的是功能模块加了以后如何在管理员列表也可以实现管理权限分配的管理。     首先我们了解一下...

ECSHOP二次开发中关于文档后台菜单的功能说明

在ecshop二次开发中看到关于文档后台菜单时,常常会遇到不解,下面是关于如何实现文档后台菜单的功能说明,将对你在ecshop二次开发中会有所帮助。 Themes 模板目录 商品管理   商品列...

ecshop二次开发--购物时为每件商品添加备注信息

目标: 用户在选购商品加入购物车前可以为商品添加备注信息加入购物车后可以在购物车查看备注信息店主在查看订单时可以看到用户为商品添加的备注信息用户在个人中心中可以看到商品的备注信息 目标一: ...
  • ximo
  • ximo
  • 2011年08月22日 10:44
  • 933

ecshop二次开发时的版权信息

  • 2013年03月28日 18:01
  • 1KB
  • 下载
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:ecshop二次开发秒杀、限时折扣、清仓等功能
举报原因:
原因补充:

(最多只允许输入30个字)