EcShop充值卡功能插件(7)

最新推荐文章于 2013-06-13 22:17:07 发布

kefu699

最新推荐文章于 2013-06-13 22:17:07 发布

阅读量838

点赞数

分类专栏： ECShop

ECShop 专栏收录该内容

21 篇文章

订阅专栏

项目跟目录创建控制器文件 ktcard.php
用户储值卡管理
<?php

define('IN_ECS', true);

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

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

// 不需要登录的操作或自己验证是否登录（如ajax处理）的act
$not_login_arr = array('act_login','update_ktcard','next_ktcard');

$ui_arr = array('default');

if (empty($_SESSION['user_id']))
{
    if (!in_array($action, $not_login_arr))
    {
        if (in_array($action, $ui_arr))
        {
            if (!empty($_SERVER['QUERY_STRING']))
            {
                $back_act = 'ktcard.php?' . $_SERVER['QUERY_STRING'];
            }
            $action = 'default';
        }
        else
        {
            //未登录提交数据。非正常途径提交数据！
            die('已经记录此非法操作IP');
        }
    }
}

if ($action == 'default')
{

    assign_template();
    $smarty->assign('page_title', '用户储值卡管理');
    $smarty->assign('ur_here',    '储值卡');
    $smarty->assign('helps',      get_shop_help());
    $smarty->assign('act',    'act_login');
    $smarty->assign('action',      $action);
    $smarty->assign('back_act',      $back_act);

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

}

if ($action == 'act_login') {

    $card_sn    = isset($_REQUEST['card_sn'])? trim($_REQUEST['card_sn']): '0';

    $card_pwd   = isset($_REQUEST['card_pwd'])? trim($_REQUEST['card_pwd']): '0';

        if ($card_sn != '0')

        {

               $sql = "SELECT * FROM " .$ecs->table('kt_bcards').
                      " WHERE card_sn = '$card_sn'" .
                      " AND card_pwd = '$card_pwd'";

               $record_arr = $db->getRow($sql);

             if (empty($record_arr))

             {
                 show_message('卡号或密码错误');
                 return 0;
             }
             else
             {

                 assign_template();
                $smarty->assign('page_title', '用户储值卡管理');
                $smarty->assign('ur_here',    '储值卡');
                $smarty->assign('helps',      get_shop_help());
                $smarty->assign('act',    'next_ktcard');
                $smarty->assign('action',      $action);
                $smarty->assign('back_act',     $back_act);
                $smarty->assign('card_sn',      $card_sn);
                $smarty->assign('card_pwd',     $card_pwd);
                $smarty->assign('card_bonus',    $record_arr['card_bonus']);
                $smarty->assign('goods_list',    get_order_goods_list());
                $smarty->display('ktcard.dwt');

             }
        }

}

if ($action == 'next_ktcard')
{
    $arr       = array();
    $arr       = $_POST['goods'];
    $goods     = !empty($arr) ? join(",",$arr) : '0';

    $card_sn    = isset($_REQUEST['card_sn'])? trim($_REQUEST['card_sn']): '0';
    $card_pwd   = isset($_REQUEST['card_pwd'])? trim($_REQUEST['card_pwd']): '0';

    $sql = "SELECT * FROM " .$ecs->table('kt_bcards').
                      " WHERE card_sn = '$card_sn'" .
                      " AND card_pwd = '$card_pwd'";

    $record_arr = $db->getRow($sql);
    $card_bonus = $record_arr['card_bonus'];

    $sql = "SELECT SUM(shop_price) FROM " .$GLOBALS['ecs']->table('goods').
               " WHERE goods_id in ($goods)";
    $fee = $GLOBALS['db']->getOne($sql);

             if ($fee > $card_bonus)
             {
                 $order_msg = $fee - $card_bonus;
                 $order_msg = "订单超出储值卡余额 $order_msg 元,收货时还需补交 $order_msg 元.";
             }
            else
             {
                $order_msg = $card_bonus - $fee;
                 $order_msg = "订单总额: $fee 元,提交当前订单之后储值卡余额为: $order_msg 元.";
             }
             if (empty($record_arr))

             {
                 show_message('卡号或密码错误');
                 return 0;
             }
            if (empty($arr))
             {
                 show_message('请选择商品');
                 return 0;
             }

    assign_template();
    $smarty->assign('page_title', '用户储值卡管理');
    $smarty->assign('ur_here',    '储值卡');
    $smarty->assign('helps',      get_shop_help());
    $smarty->assign('act',    'update_ktcard');
    $smarty->assign('action',      $action);
    $smarty->assign('back_act',      $back_act);
    $smarty->assign('card_sn',      $card_sn);
    $smarty->assign('card_pwd',     $card_pwd);
    $smarty->assign('goods_id',     $goods);
    $smarty->assign('card_bonus',    $record_arr['card_bonus']);
    $smarty->assign('fee',    $fee);
    $smarty->assign('order_msg',    $order_msg);

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

}


if ($action == 'update_ktcard')
{
    $order_user    = isset($_REQUEST['order_user'])? trim($_REQUEST['order_user']): '0';
    $order_address    = isset($_REQUEST['order_address'])? trim($_REQUEST['order_address']): '0';
    $order_tel    = isset($_REQUEST['order_tel'])? trim($_REQUEST['order_tel']): '0';
    $order_phone    = isset($_REQUEST['order_phone'])? trim($_REQUEST['order_phone']): '0';
    $order_bak    = isset($_REQUEST['order_bak'])? trim($_REQUEST['order_bak']): '0';
    $shipping_time    = isset($_REQUEST['shipping_time'])? trim($_REQUEST['shipping_time']): '0';
    $order_clr     = !empty($_REQUEST['order_clr'])    ? intval($_REQUEST['order_clr'])    : 0;


$card_sn    = isset($_REQUEST['card_sn'])? trim($_REQUEST['card_sn']): '0';
    $card_pwd   = isset($_REQUEST['card_pwd'])? trim($_REQUEST['card_pwd']): '0';

    $goods   = isset($_REQUEST['goods'])? trim($_REQUEST['goods']): '0';

    $order_sn = get_order_sn();
$order_time = gmtime();

$sql = "SELECT * FROM " .$ecs->table('kt_bcards').
                      " WHERE card_sn = '$card_sn'" .
                      " AND card_pwd = '$card_pwd'";

    $record_arr = $db->getRow($sql);
    $card_bonus = $record_arr['card_bonus'];

$sql = "SELECT SUM(shop_price) FROM " .$GLOBALS['ecs']->table('goods').
               " WHERE goods_id in ($goods)";
$fee = $GLOBALS['db']->getOne($sql);

            if (empty($order_user) OR (empty($order_tel) AND empty($order_phone)))
             {
                 show_message('联系人为必填项,电话任选其一.');
                 return 0;
             }

              if ($card_sn != '0')
            {

               $sql = "SELECT * FROM " .$ecs->table('kt_bcards').
                      " WHERE card_sn = '$card_sn'" .
                      " AND card_pwd = '$card_pwd'";

               $record_arr = $db->getRow($sql);

             if (empty($record_arr))

             {
                 show_message('卡号或密码错误');
                 return 0;
             }
             else
             {
                 $card_id = intval($record_arr['card_id']);

                     if ($fee > $card_bonus)
                     {
                         $order_exc = $fee - $card_bonus;
                         $sql = "UPDATE " .$ecs->table('kt_bcards'). " SET ".
                      "card_bonus         = 0 ".
                      " WHERE card_sn = '$card_sn'" .
                      " AND card_pwd = '$card_pwd'";
                      $db->query($sql);
                      $order_clr = 0;
                     }
                     else
                      {
                         $order_exc = 0;
                         $card_bonus_last = $card_bonus - $fee;
                      $sql = "UPDATE " .$ecs->table('kt_bcards'). " SET ".
                      "card_bonus         = '$card_bonus_last' ".
                      " WHERE card_sn = '$card_sn'" .
                      " AND card_pwd = '$card_pwd'";
                      $db->query($sql);
                                             if($order_clr <> 0)
                                            {
                                                   $order_clr = $card_bonus_last;
                                                   $sql = "UPDATE " .$ecs->table('kt_bcards'). " SET ".
                      "card_bonus         = 0 ".
                      " WHERE card_sn = '$card_sn'" .
                      " AND card_pwd = '$card_pwd'";
                      $db->query($sql);

                                            }
                       }


                 $GLOBALS['db']->query("INSERT INTO ".$GLOBALS['ecs']->table('kt_order')." (card_id, order_sn, order_fee, order_exc, order_clr, order_user, order_address, order_tel, order_phone, order_bak, shipping_time, order_time, order_goods, order_status) VALUES($card_id,'$order_sn','$fee','$order_exc','$order_clr','$order_user','$order_address','$order_tel','$order_phone','$order_bak','$shipping_time','$order_time','$goods',0)");

                $sql = "UPDATE " .$ecs->table('kt_bcards'). " SET ".
                      "used_time         = '$order_time' ".
                      " WHERE card_sn = '$card_sn'" .
                      " AND card_pwd = '$card_pwd'";

                $db->query($sql);
               $action = 'default';
                 show_message('已经成功提交订单!', '返回储值卡管理', 'ktcard.php','default');
             }
           }
echo 'asdfasdffffffffffffffffffffffffffffffffffffffff';
}

function get_order_sn()
{

    mt_srand((double) microtime() * 1000000);

    return date('Ymd') . str_pad(mt_rand(1, 99999), 5, '0', STR_PAD_LEFT);
}

function get_order_goods_list()
{


    $sql = "SELECT * FROM " .$GLOBALS['ecs']->table('goods') . " WHERE is_on_sale = 1 ORDER BY goods_id desc" ;

    $result = $GLOBALS['db']->getAll($sql);
    $goods = array();

    foreach ($result AS $idx => $row)
    {
        $goods[$idx]['goods_id']           = $row['goods_id'];
        $goods[$idx]['goods_name']         = $row['goods_name'];
        $goods[$idx]['shop_price']         = $row['shop_price'];
    }

return $goods;
}

function get_goods_name($id)

{
    $sql = "SELECT goods_name FROM " .$GLOBALS['ecs']->table('goods').
               " WHERE goods_id = '$id'";
$result = $GLOBALS['db']->getOne($sql);

return $result;

}

function get_goods_bak($id)

{
    $sql = "SELECT seller_note FROM " .$GLOBALS['ecs']->table('goods').
               " WHERE goods_id = '$id'";
$result = $GLOBALS['db']->getOne($sql);

return $result;

}

?>