<?php

define('IN_SSE', true);
require(str_replace('\\', '/',dirname(__FILE__)) . '/includes/init_includes.php');
require(str_replace('\\', '/',dirname(__FILE__)) . '/webcon/dataset.php');
$act=isset($_REQUEST['act'])?trim($_REQUEST['act']):'';
if($act=='list' || $act==''){
	$cid = isset($_REQUEST['cid']) ? intval($_REQUEST['cid']) : 0;
	if($cid){
		$sql = 'select pc_name from '.$sse->table('procat').' where pc_id = '.$cid;
		$pcname = $db->getOne($sql);
		$smarty->assign('pcname',$pcname);

		$sql = 'select pc_id from '.$sse->table('procat').' where pc_upid = '.$cid;
		$idsarr=$db->getAll($sql);
		foreach($idsarr as $val){
			$tmpidsarr[]=$val['pc_id'];
		}
		if($tmpidsarr){
			$ids=implode(",",$tmpidsarr);
		}
	}
	
		/*分页开始*/	
	$page = isset($_REQUEST['page']) ? intval($_REQUEST['page']) : 1;
	/* 获取记录条数 */
	$size = isset($_REQUEST['size']) ? intval($_REQUEST['size']):$_lang['data']['conf_store_admin_page_size'];
	$size = 8;
	if($page > 1){
		$pagetemp=$page-1;
		$p = $size*$pagetemp;
		$limit = " limit ".$p.",".$size;
	}else{
		$pagetemp=$page-1;
		$p = $size*$pagetemp;
		$limit = " limit 0,".$size;	
	}
	
	if($ids){
		$where=" where p_catid in (".$ids.") ";
		$url['cid']=$cid;
	}elseif($cid){
		$where .= " where p_catid = ".$cid;
		$url['cid']=$cid;
	}else{
		$where=" where 1 ";
	}

    if(isset($_REQUEST['keywords']) && !empty($_REQUEST['keywords'])){
        $searchkey = $_REQUEST['keywords'];
        $where .= " and (p.p_name LIKE '%".$searchkey."%') ";
    }

	$sql="select COUNT(*) from ".$sse->table('pro')." as p left join ".$sse->table('procat')." as pc on p.p_catid=pc.pc_id ".$where;
	$record_count = $db->getOne($sql);
	//分页函数
	$url['size'] = $size;
	$pager = get_pager('pro.shtml',$url,$record_count, $page,$size);
	$smarty->assign('pager', $pager);
	$smarty->assign('pagersize', $size);
	/*分页结束*/

    $smarty->assign('prolist',get_prolist($where,$limit));
    // print_r(get_level_cat());die;
    //$smarty->assign('pclist',get_level_cat());
	    $smarty->assign('pclist',getCategoryList());
    $smarty->assign('searchkey',$searchkey);
    $smarty->display('pro_list.htm');
}

function get_prolist($where,$limit){
	global $db,$sse,$_lang;

	$sql="select p.*,pc.pc_name from ".$sse->table('pro')." as p left join ".$sse->table('procat')." as pc on p.p_catid=pc.pc_id ".$where." order by p_sort desc,p_id desc".$limit;
	$res = $db->query($sql);
	$i=0;
	$content=array();
	while ($row = $db->fetchRow($res))
	{
		$content[$i]['p_id']=$row['p_id'];
		$content[$i]['p_name']=$row['p_name'];
		$content[$i]['p_catid']=$row['p_catid'];
		$content[$i]['p_catname']=$row['pc_name'];
		$content[$i]['p_isshow']=$row['p_isshow'];
        //获取当前会员价格
        $content[$i]['currenthy_price'] = get_currenthy_price($row['p_id'],$row['p_price']);
        //获取当前的最低价格
        $content[$i]['lowest_price'] = get_lowest_price($row['p_id']);
		$content[$i]['p_pic']=$row['p_pic'];
        $content[$i]['p_market_price']=$row['p_market_price'];
        $content[$i]['p_price']=$row['p_price'];
        $content[$i]['p_ispin']=$row['p_ispin'];
        $pr = get_prorank_price($row['p_id']);
        if($rankinfo){
    		$content[$i]['p_hy_price']=$pr[$rankinfo['u_rank']]['pr_price'];
        }else{
            $content[$i]['p_hy_price']=$row['p_price'];
        }
		$content[$i]['p_desc']=$row['p_desc'];
		$content[$i]['p_number']=$row['p_number'];
		$content[$i]['p_add_time']=local_date($GLOBALS['_lang']['data']['conf_store_day_style'],$row['p_add_time']);
		$content[$i]['p_last_time']=local_date($GLOBALS['_lang']['data']['conf_store_day_style'],$row['p_last_time']);
		$i++;
	}
	return $content;
}

function get_level_cat($level = 0){
	global $db,$sse,$_lang;
	$sql = 'select * from '.$sse->table('procat').' where pc_level = '.$level.' order by pc_sort desc,pc_id desc ';
	$res = $db->query($sql);
	$i=0;
	$content=array();
	while ($row = $db->fetchRow($res))
	{
		$content[$i]['pc_id']=$row['pc_id'];
		$content[$i]['pc_name']=$row['pc_name'];
		$i++;
	}
	return $content;
}