/** * 返回更新国家信息 * @access public */ function update() { $id = get_post_value('id'); $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_url', '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'); $m->setWhere('floor_3.floor_3_id', '=', $id); $m->setOrderBy(array('floor_2.orders' => 'ASC', 'floor_3.orders' => 'ASC')); $data = $m->select(); $this->assign('data', $data); $floor_1_id = $data[0]['floor_1_id']; $m->clear(); $field = array('floor_2_id', 'floor_2_cn'); $m->clear(); $m->setField($field); $m->setTable('vcb_product_floor_2'); $m->setWhere('status', '!=', '60000'); $m->setWhere('floor_1_id', '=', $floor_1_id); $m->setOrderBy('orders'); $data = $m->select(); $this->assign('floor_2', $data); }