/**
* 返回国家列表
* @access public
*/
function index()
{
$floor_1 = get_post_value('floor_1');
$floor_2 = get_post_value('floor_2');
$floor_3 = get_post_value('floor_3');
$field = array('floor_2.floor_1_id', 'floor_2.floor_2_id', 'floor_2.floor_2_cn', 'floor_2.floor_2_th', 'floor_3.floor_3_id', 'floor_3.floor_3_cn', 'floor_3.floor_3_th', 'floor_3.orders', 'floor_3.status', 'floor_3.created', 'floor_3.created_name', 'floor_3.audit_name', 'floor_3.start_time', 'floor_3.end_time');
$m = new Floor();
$m->clear();
$m->setField($field);
$m->setTable('vcb_product_floor_3 AS floor_3');
$m->setJoin('vcb_product_floor_2 as floor_2', 'floor_2.floor_2_id=floor_3.floor_2_id');
$m->setWhere('floor_3.status', '!=', '60000');
if ($floor_1 != '') {
$m->setWhere('floor_3.floor_1_id', '=', $floor_1);
}
if ($floor_2 != '') {
$m->setWhere('floor_3.floor_2_id', '=', $floor_2);
}
if ($floor_2 != '') {
$m->setWhere('floor_3.floor_3_cn', 'LIKE', '%' . $floor_3 . '%', 'AND', '(');
$m->setWhere('floor_3.floor_3_th', 'LIKE', '%' . $floor_3 . '%', 'OR', ')');
}
$m->setOrderBy(array('floor_2.orders' => 'ASC', 'floor_3.orders' => 'ASC'));
$count = $m->getRowsCount();
$page = new Page($count);
$parameter = array('floor_1' => $floor_1, 'floor_2' => $floor_2, 'floor_3' => $floor_3);
$page->setParameter($parameter);
$showPage = $page->showPage();
$showTotal = $page->showTotal();
$m->setPage();
/*$page->setListRows(5);
$m->setLimit($page->listRows);*/
$data = $m->select();
//状态标题
$count = count($data);
for ($i = 0; $i < $count; $i++) {
$status = $data[$i]['status'];
$data[$i]['status_cn'] = $m->getStatus('cn', $status);
$data[$i]['status_th'] = $m->getStatus('th', $status);
$data[$i]['floor_1'] = $m->getFloor_1($data[$i]['floor_1_id']);
}
$this->assign('data', $data);
$this->assign('showPage', $showPage);
//输出分页
$this->assign('showTotal', $showTotal);
//输出分页合计
if ($floor_1 != '') {
$c_2 = $m->getFloor_2($floor_1);
$this->assign('floor_2', $c_2);
} else {
$this->assign('floor_2', array());
}
}
/**
* 返回国家列表
* @access public
*/
function index()
{
$floor_1 = get_post_value('floor_1');
$floor_2 = get_post_value('floor_2');
$field = array('floor_1_id', 'floor_2_id', 'floor_2_cn', 'floor_2_th', 'orders', 'status', 'created', 'created_name', 'audit_name');
$m = new Floor();
$m->clear();
$m->setField($field);
$m->setTable('vcb_product_floor_2');
$m->setWhere('status', '!=', '60000');
if ($floor_1 != '') {
$m->setWhere('floor_1_id', '=', $floor_1);
}
if ($floor_2 != '') {
$m->setWhere('floor_2_cn', 'LIKE', '%' . $floor_2 . '%', 'AND', '(');
$m->setWhere('floor_2_th', 'LIKE', '%' . $floor_2 . '%', 'OR', ')');
}
$m->setOrderBy('orders');
$count = $m->getRowsCount();
$page = new Page($count);
$parameter = array('floor_1' => $floor_1, 'floor_2' => $floor_2);
$page->setParameter($parameter);
$showPage = $page->showPage();
$showTotal = $page->showTotal();
$m->setPage();
$data = $m->select();
//状态标题
$count = count($data);
for ($i = 0; $i < $count; $i++) {
$status = $data[$i]['status'];
$data[$i]['status_cn'] = $m->getStatus('cn', $status);
$data[$i]['status_th'] = $m->getStatus('th', $status);
$data[$i]['floor_1'] = $m->getFloor_1($data[$i]['floor_1_id']);
}
$this->assign('data', $data);
$this->assign('showPage', $showPage);
//输出分页
$this->assign('showTotal', $showTotal);
//输出分页合计
}
