public static function get_department($dep_id) { if ($dep_id == 0) { return '无'; } $department_table = new DepartmentTable(); $result = $department_table->select($dep_id); return $result['dep_name']; }
public function modifyInfo($user_id = null) { if ($user_id != null && $user_id != SessionUtil::get('user_id')) { // 如果是要修改其它用户的信息,需检查是否有权限10 if (!Util::has_authority(10)) { $this->error(3); } } else { $user_id = SessionUtil::get('user_id'); } $user_info = $this->model->select($user_id); $department_table = new DepartmentTable(); $deps = $department_table->select_all(); $view_data = array('id' => $user_id, 'sex' => $user_info['user_sex'], 'phone' => $user_info['user_phone'], 'email' => $user_info['user_email'], 'qq' => $user_info['user_qq'], 'department' => $user_info['user_department'], 'departments' => $deps, 'dormitory' => $user_info['user_dormitory'], 'major' => $user_info['user_major'], 'birthplace' => $user_info['user_birthplace'], 'birthday' => $user_info['user_birthday']); $this->my_render('modify_info', $view_data); }
* @license http://www.gnu.org/licenses/lgpl.txt LGPL * @version 0.4.0, 2009-01-27 */ /** Zend_Db */ require_once 'Zend/Db.php'; /** Zend_Db_Table */ require_once 'Zend/Db/Table.php'; /** Setup database */ require_once 'db.inc.php'; // Create data source $departments = null; require_once 'departments.inc.php'; $createTables = ' CREATE TABLE departments ( Id INTEGER NOT NULL PRIMARY KEY, Name VARCHAR(100) ); '; $db->query($createTables); foreach ($departments as $department) { $db->insert('departments', (array) $department); } // DepartmentTable class class DepartmentTable extends Zend_Db_Table { protected $_name = 'departments'; // table name protected $_primary = 'Id'; } $departmentTable = new DepartmentTable(array('db' => $db)); $departmentTable->setRowClass('Department');
public function updateDepartment($id) { $this->authority(20); $name = Util::fetch_post('name'); $info = Util::fetch_post('info'); if ($name == null || $info == null) { $this->error(2); } $department_table = new DepartmentTable(); $department_table->update($id, $name, $info); Util::go_back(); }