<?php
header("Content-Type: text/html; charset=utf-8");
require(dirname(__FILE__)."/"."global.php");
require_once(PHP168_PATH."php168/mysql_config.php");
require(PHP168_PATH."inc/exp_mysql.class.php");
$titleDB[title]="罗湖医院药品价格查询";
require(PHP168_PATH."inc/head.php");

global $dbname,$dbhost,$dbhost,$dbpw;

$db = new DB();
$db->connect($dbname,$dbhost,$dbuser,$dbpw);

$where = "1=1";
$code = $_POST['code'];
if($code){
	$where .=" and code like '%".$code."%'";
}
$title = $_POST['title'];
if($title){
	$where .=" and title like '%".$title."%'";
}

$sql ="select count(*) as cnt from exp_query_drugs where $where";
$rs = $db->find($sql);
/*分页代码*/
$total =$rs['cnt'];
$pagesize=20;
$pages=intval($total/$pagesize);

$page =$_GET['page'];
if(empty($page)){
	$page=1;
}else if($page > $pages){
	$page=$pages;
}
$url = "/query.php?";

$offset=$pagesize*($page - 1);

$sql ="select * from exp_query_drugs where $where order by zid limit $offset,$pagesize";
$list = $db->findAll($sql);
$showpage = $db->getpage($total,$pagesize,$page,$url,$pagesize);
?>
<link rel="stylesheet" type="text/css" href="images/jiuyi.css">
<div id="position"><b>您的位置：</b><a href="$webdb[www_url]/">罗湖人民医院</a>->药品价格查询</div>
<div id="queryform">
	<table width="100%" border="0" cellspacing="0" cellpadding="0"><form action="query.php" method="post" name="query">
  	<tr><td>
		<span class="pretitle">药品编码：</span><input name="code" type="text" maxlength="50" class="text" value="<?=$code?>" />
		<span class="pretitle">药品名称：</span><input name="title" type="text" class="text" maxlength="50" value="<?=$title?>" />&nbsp;
		<input type="submit" class="btn_blue2" value="查询">
		</td><td align="center"><a style="font-weight:bold; color:#009933; font-size:16px;" href="/query_s.php">罗湖人民医院服务价格查询</a></td></tr></form>	
	</table>
</div>
<div id="querylist">
<table width="100%" border="0" cellspacing="1" cellpadding="0">
  <tr><th>药品编码</th><th>药品名称</th><th>规格</th><th>大单位零售单价</th><th>小单位零售单价</th>
  </tr>
<?php
	foreach($list as $rs){
?> 
  <tr><td><?=$rs['code']?></td><td><?=$rs['title']?></td><td><?=$rs['spec']?></td><td><?=$rs['bigprice']?></td><td><?=$rs['bigprice']?></td></tr>
<?php
}
?>
</table>
<?=$showpage?>
</div>
<?php
require(PHP168_PATH."inc/foot.php");
?>