/** * 返回国家列表 * @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); //输出分页合计 }