<?php
require_once 'public.php';
$condition = "where 1 = 1 ";
$case = array();
$sortid = isset($_GET['sortid']) ? (int)$_GET['sortid'] : "";
$p->file = 'case.php5';
if(!empty($sortid)){
	$condition .= " and a.sortid in($sortid)";
	$p->setvar(array('sortid'=>$sortid));
}
$p->pvar="page";
$pagesize = 10;
$num = $db->result($db->query("select count(*) from ".TABLEPRE."cases as a $condition"),0);
$p->set($pagesize,$num,$page);
$case = $db->query_row("select a.*,b.`name` as `catename` from ".TABLEPRE."cases  as a left join ".TABLEPRE."case_type as b on (b.id =a.sortid) $condition order by a.id desc limit ".$p->limit(),MYSQL_ASSOC);
require_once DOCUMENTROOT.'/templates/case.htm';
unset($condition,$case,$pagesize,$num);
?>