Пример #1
0
 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'];
 }
Пример #2
0
 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');
Пример #4
0
 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();
 }