Example #1
0
 public function indexAction()
 {
     if ($this->view->login->group_id != 1) {
         $this->error("权限不够", "操作权限不够");
     }
     $query = Doctrine_Query::create();
     $query->from('DBModel_User u');
     $query->leftJoin('u.Department dp');
     $query->leftJoin('u.Group gp');
     $query->orderBy('u.id desc');
     $gp = $_GET['page'];
     if (Zend_Validate::is($gp, 'Int')) {
         $curPage = $gp;
     } else {
         $curPage = 1;
     }
     $page = new Das_Page();
     $page->setPerPage(10);
     $page->setCurPage($curPage);
     $page->setQuery($query);
     $page->setView($this->view);
     $page->setModName("user");
     $page->process();
     $this->view->render("user.html");
     $query->free();
 }
Example #2
0
 public function indexAction()
 {
     //$dv = new Das_ViewUtil();
     //$params = array('a'=>'test','id'=>1);
     //$dv->url("xfile" , "edit" , $params);
     //
     //$this->view->render("index.html");
     //die("searching");
     $k = $_POST['q'];
     //die($k);
     $gp = $_GET['page'];
     if (Zend_Validate::is($gp, 'Int')) {
         $curPage = $gp;
     } else {
         $curPage = 1;
     }
     $q = Doctrine_Query::create();
     $q->from("DBModel_XFile f");
     $q->leftJoin('f.Department d');
     $q->leftJoin('f.FileAccept ac');
     $q->addWhere("f.title LIKE '%" . $k . "%' ");
     if ($this->view->login->group_id == 3) {
         //确保登录用户能看见自己的信息
         $q->addWhere("department_id = ? ", $this->view->login->department_id);
         //确保信息被发送到登录用户所属部门
         if ($this->view->login->group_id == 3) {
             $added_sql = "FIND_IN_SET('%s',sendto) > 0 ";
             $added_sql = sprintf($added_sql, $this->view->login->department_id);
             $q->orWhere($added_sql);
         }
         $q->andWhere("is_xfwj = 0");
         $q->orderBy('f.id desc');
     } else {
         $q->addWhere("is_xfwj = 0");
         $q->orderBy('f.id desc');
     }
     $page = new Das_Page();
     $page->setPerPage(10);
     $page->setCurPage($curPage);
     $page->setModName("xfile");
     $page->setQuery($q);
     $page->setView($this->view);
     $page->process();
     $this->view->render("xfile.html");
     $q->free();
 }
Example #3
0
 public function showAction()
 {
     $query = Doctrine_Query::create();
     $query->from('DBModel_Note n');
     $query->orderBy('n.id desc');
     $gp = $_GET['page'];
     if (Zend_Validate::is($gp, 'Int')) {
         $curPage = $gp;
     } else {
         $curPage = 1;
     }
     $page = new Das_Page();
     $page->setPerPage(10);
     $page->setCurPage($curPage);
     $page->setModName("note");
     $page->setQuery($query);
     $page->setView($this->view);
     $page->process();
     $this->view->render("shownote.html");
     $query->free();
 }
Example #4
0
 public function indexAction()
 {
     if ($this->view->login->group_id != 1) {
         $this->error("权限不够", "操作权限不够");
     }
     $gp = $_GET['page'];
     if (Zend_Validate::is($gp, 'Int')) {
         $curPage = $gp;
     } else {
         $curPage = 1;
     }
     $q = Doctrine_Query::create();
     $q->from('DBModel_AcceptType');
     $page = new Das_Page();
     $page->setPerPage(10);
     $page->setCurPage($curPage);
     $page->setModName("Atype");
     $page->setQuery($q);
     $page->setView($this->view);
     $page->process();
     $this->view->render("accepttype.html");
     $q->free();
 }
Example #5
0
 public function catindexAction()
 {
     $query = Doctrine_Query::create();
     $query->from('DBModel_GovPublicCat d');
     $gp = $_GET['page'];
     if (Zend_Validate::is($gp, 'Int')) {
         $curPage = $gp;
     } else {
         $curPage = 1;
     }
     $page = new Das_Page();
     $page->setPerPage(10);
     $page->setCurPage($curPage);
     $page->setModName("gov");
     $page->setQuery($query);
     $page->setView($this->view);
     $page->process();
     $this->view->render("govpubliccat.html");
 }
Example #6
0
 public function xiafawenjianAction()
 {
     $query = Doctrine_Query::create();
     $query->from('DBModel_XFile f');
     $query->leftJoin('f.Department d');
     $query->leftJoin('f.FileAccept ac');
     $query->orderBy('f.id desc');
     if ($this->view->login->group_id == 3) {
         // 确保登录用户能看见自己的信息
         // $query->addWhere("department_id = ? ", $this->view->login->department_id);
         // 确保信息被发送到登录用户所属部门
         if ($this->view->login->group_id == 3) {
             $added_sql = "FIND_IN_SET('%s',sendto) > 0 ";
             $added_sql = sprintf($added_sql, $this->view->login->department_id);
             $query->orWhere($added_sql);
         }
         $query->andWhere("is_xfwj = 1");
         $query->orderBy('f.id desc');
     } else {
         $query->addWhere("is_xfwj = 1");
         $query->orderBy('f.id desc');
     }
     $gp = $_GET['page'];
     if (Zend_Validate::is($gp, 'Int')) {
         $curPage = $gp;
     } else {
         $curPage = 1;
     }
     $page = new Das_Page();
     $page->setPerPage(10);
     $page->setCurPage($curPage);
     $page->setModName("Xfile");
     $page->setQuery($query);
     $page->setView($this->view);
     $page->process();
     $this->view->render("xfile.html");
     $query->free();
 }