shop/admin/seller_domain.php

<?php

/* 
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

define('IN_ECS', true);

require(dirname(__FILE__) . '/includes/init.php');
if($_REQUEST['act'] == 'list'){
    assign_query_info();
   
    $smarty->assign('ur_here',     $_LANG['seller_domain']);
//    $smarty->assign('action_link', array('text' => $_LANG['articlecat_add'], 'href' => 'articlecat.php?act=add'));
     $adminru = get_admin_ru_id();
     
    $smarty->assign('ru_id',     $adminru['ru_id']);
    $domain_list=get_pzd_list($adminru);
    foreach($domain_list['pzd_list'] as $k=>$v){
        if($v['validity_time'] > 0){
            $domain_list['pzd_list'][$k]['validity_time'] = local_date("Y-m-d", $v['validity_time']);
        }else{
            $domain_list['pzd_list'][$k]['validity_time']='';
        }
    }
    $smarty->assign('card_list', $domain_list['pzd_list']);
    $smarty->assign('filter', $domain_list['filter']);
    $smarty->assign('record_count', $domain_list['record_count']);
    $smarty->assign('page_count', $domain_list['page_count']);
    $smarty->assign('full_page', 1);
    $smarty->display("seller_domain.htm");
}
/* ------------------------------------------------------ */
//-- 翻页，排序
/* ------------------------------------------------------ */ 
elseif ($_REQUEST['act'] == 'query') {
    //获取信息列表  
    admin_priv('seller_dimain');
    assign_query_info();
     $smarty->assign('ur_here',     $_LANG['seller_domain']);
    $domain_list=get_pzd_list();
    $adminru = get_admin_ru_id();
    $smarty->assign('ru_id',     $adminru['ru_id']);
    $smarty->assign('card_list', $domain_list['pzd_list']);
    $smarty->assign('filter', $domain_list['filter']);
    $smarty->assign('record_count', $domain_list['record_count']);
    $smarty->assign('page_count', $domain_list['page_count']);
//跳转页面  
    make_json_result($smarty->fetch('seller_domain.htm'), '', array('filter' => $domain_list['filter'], 'page_count' => $domain_list['page_count']));
}
elseif($_REQUEST['act'] == 'edit'){
    admin_priv('seller_dimain');
    $smarty->assign('ur_here',     $_LANG['seller_domain_edit']);
    $smarty->assign('action_link', array('text' => $_LANG['seller_domain'], 'href' => 'seller_domain.php?act=list'));
    $id=!empty($_REQUEST['id']) ? $_REQUEST['id']:'0';
    $domain=$db->getRow( "SELECT is_enable,validity_time FROM ".$ecs->table("seller_domain")." WHERE id = ".$id);
    if($domain['validity_time'] == 0){
        $domain['validity_time'] = '';
    }else{
        $domain['validity_time']=local_date("Y-m-d",$domain['validity_time']);
    }
    $smarty->assign('domian',$domain);
    
    if($_POST['sub']){
        $domain_name=!empty($_POST['domain_name']) ? $_POST['domain_name']:'';
        $is_enable=!empty($_POST['is_enable']) ? $_POST['is_enable']:'0';
        $validity_time=!empty($_POST['validity_time']) ? strtotime($_POST['validity_time']):'0';
        $sql=" UPDATE".$ecs->table('seller_domain')." SET domain_name = '$domain_name' , is_enable= '$is_enable' ,validity_time='$validity_time'  WHERE id =".$id;
        if($db->query($sql) == true){
            $links = array(array('href' => 'seller_domain.php?act=list', 'text' => $_LANG['seller_domain']));
            sys_msg($_LANG['domain_edit'], 0, $links);
        }
    }
    $smarty->display("seller_domain_info.htm");
}
/*页面编辑*/

elseif($_REQUEST['act'] == 'is_enable'){
    admin_priv('seller_dimain');
    $id = intval($_REQUEST['id']);
    $sql = "SELECT id, is_enable
            FROM " . $ecs->table('seller_domain') . "
            WHERE id = '$id'";
    $seller = $db->getRow($sql, TRUE);
    if ($seller['id'])
    {
        $seller['is_enable'] = $seller['is_enable']<>1 ? 1 : 0;
        $db->autoExecute($ecs->table('seller_domain'),$seller, '', "id = '$id'");
        clear_cache_files();
        make_json_result($seller['is_enable']);
    }
    exit;
}
/*分页*/
function get_pzd_list() {
    $result = get_filter();
    $adminru = get_admin_ru_id();
    if ($result === false)
    {
        if($adminru['ru_id'] > 0){
            $sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('seller_domain')." WHERE ru_id = ".$adminru['ru_id'];
            $where = " WHERE a.ru_id = ".$adminru['ru_id'];
        }else{
            $sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('seller_domain');
        }
        $filter['record_count'] = $GLOBALS['db']->getOne($sql);
        $filter = page_and_size($filter);
        /* 获活动数据 */
           $sql="SELECT a.*,b.shop_name FROM".$GLOBALS['ecs']->table('seller_domain'). " as a LEFT JOIN ".$GLOBALS['ecs']->table("seller_shopinfo")." as b ON a.ru_id = b.ru_id $where  ORDER BY a.id ASC LIMIT " . $filter['start'] . "," . $filter['page_size'];
            $filter['keywords'] = stripslashes($filter['keywords']);
            set_filter($filter, $sql);
             }
    else
    {
        $sql    = $result['sql'];
        $filter = $result['filter'];
    }
            $row = $GLOBALS['db']->getAll($sql);
        
        $arr = array('pzd_list' => $row, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
        return $arr;
}