コード例 #1
0
 /**
  * 返回更新国家信息
  * @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);
 }