/**
* 根据查询条件 获取组件列表
*/
public function get_models($page = null, $mtypecond = null, $mnamecond = null, $midcond = null, $orderBy = null, $orderstr = null)
{
$this->load->helper('ourpage');
$pageno = 1;
$pagesize = 20;
$order = '';
if ($page['pageno']) {
$pageno = $page['pageno'];
}
$cond = "";
if ($mtypecond) {
if ($mtypecond != -1) {
$cond .= " and mod.\"MTID\" ='" . $mtypecond . "'";
}
}
if ($mnamecond) {
$cond .= " and mod.\"Name\" like '%" . $mnamecond . "%'";
}
if ($midcond) {
$cond .= " and mod.\"ID\" = " . $midcond;
}
if ($orderstr && $orderBy) {
$order = " order by mod.\"" . $orderBy . "\" " . $orderstr;
} else {
$order = " order by mod.ID desc ";
}
$countsql = "select count(*) from \"T_PPC_Module\" mod where 1=1 " . $cond;
// echo $countsql;
$querycount = $this->db->query($countsql);
$row = $querycount->row_array();
$totalcount = $row["COUNT(*)"];
if ($totalcount > 0) {
$totalpage = getTotalPage($totalcount, $pagesize);
$snumber = getStartNumber($pageno, $pagesize);
$enumber = getEndNumber($pageno, $pagesize);
$sql = "select * from (select t.*, rownum rn from ( select * from \"T_PPC_Module\" mod where 1=1 and isview=1 " . $cond . $order . " ) t where rownum <=" . $enumber . ") where rn > " . $snumber;
$query = $this->db->query($sql);
$result['list'] = $query->result_array();
$result['totalpage'] = $totalpage;
$result['totalcount'] = $totalcount;
$result['pageno'] = $pageno;
} else {
$result['list'] = array();
$result['totalpage'] = 0;
$result['totalcount'] = 0;
$result['pageno'] = 0;
}
$result['order'] = $orderstr;
$result['orderBy'] = $orderBy;
return $result;
}
public function get_productlines($page = null, $cond = null, $orderBy = null, $orderstr = null)
{
$this->load->helper('ourpage');
$pageno = 1;
$pagesize = 20;
if ($page['pageno'] == true) {
$pageno = $page['pageno'];
}
$condstr = "";
if ($cond) {
if ($cond['scond'] && $cond['scond'] != '-1') {
$condstr .= " and pl.\"SatCode\"='" . $cond['scond'] . "'";
}
if ($cond['plname']) {
$condstr .= " and pl.\"Alias\" like '%" . $cond['plname'] . "%'";
}
if ($cond['devcode'] && $cond['devcode'] != '-1') {
$condstr .= " and pl.\"DevCode\"='" . $cond['devcode'] . "'";
}
// $condstr .= " and ( mod.\"Caption\"='" . $cond . "' or mod.\"Code\" = '" . $cond . "' )";
}
if ($orderstr && $orderBy) {
$order = " order by pl.\"" . $orderBy . "\" " . $orderstr;
} else {
$order = " order by pl.ID desc ";
}
$countsql = "select count(*) from \"T_PPC_ProductLine\" pl where 1=1 " . $condstr;
//echo $countsql;
$totalcount = $this->getNumberCount($countsql);
if ($totalcount > 0) {
$totalpage = getTotalPage($totalcount, $pagesize);
$snumber = getStartNumber($pageno, $pagesize);
$enumber = getEndNumber($pageno, $pagesize);
$query = null;
$sql = "select * from (select t.*, rownum rn from (\n select * from \"T_PPC_ProductLine\" pl where 1=1 " . $condstr . $order . " ) t where rownum <=" . $enumber . ")\n where rn > " . $snumber;
$querydata = $this->db->query($sql);
$result['list'] = $querydata->result_array();
$result['totalpage'] = $totalpage;
$result['pageno'] = $pageno;
} else {
$result['list'] = array();
$result['totalpage'] = 0;
$result['pageno'] = 0;
}
$result['order'] = $orderstr;
$result['orderBy'] = $orderBy;
return $result;
}
public function get_cats($page = null, $cond1 = null, $orderBy = null, $orderstr = null)
{
$this->load->helper('ourpage');
$pageno = 1;
$pagesize = 10;
$order = '';
if ($page['pageno'] == true) {
$pageno = $page['pageno'];
if (!$pageno) {
$pageszie = 1;
}
// print "----".$pagesize;
}
$cond = "";
if ($cond1) {
$cond .= " and cat.\"MTName\" like '%" . $cond1 . "%'";
}
if ($orderstr && $orderBy) {
$order = " order by cat.\"" . $orderBy . "\" " . $orderstr;
} else {
$order = " order by cat.id desc ";
}
$countsql = "select count(*) from \"T_PPC_ModuleType\" cat where 1=1 " . $cond;
$query = $this->db->query($countsql);
$row = $query->result_array();
$totalcount = $row[0]["COUNT(*)"];
$totalpage = getTotalPage($totalcount, $pagesize);
$snumber = getStartNumber($pageno, $pagesize);
$enumber = getEndNumber($pageno, $pagesize);
$sql = "select * from (select t.*, rownum rn from ( select * from \"T_PPC_ModuleType\" cat where 1=1 " . $cond . $order . " ) t where rownum < =" . $enumber . ") where rn > " . $snumber;
//print $sql;
$query = $this->db->query($sql);
$result['list'] = $query->result_array();
$result['totalpage'] = $totalpage;
$result['pageno'] = $pageno;
$result['order'] = $orderstr;
$result['orderBy'] = $orderBy;
return $result;
}
