/** * @Route("/search/mode/{mode}",defaults={"mode":"Do you want search empty?"}) * @Method("GET") * @Template() */ public function searchAction($mode) { $mode = $this->getRequest()->get('mode'); $mode = strip_tags($mode); $search_mode_list = $this->dealmodeArgs($mode); if (empty($search_mode_list)) { return $this->redirect('/search/mode'); } if (!empty($search_mode_list['mosquito'])) { return $this->redirect('/'); } $em = $this->getDoctrine()->getManager(); $c = new Common(); $current_month = $c->getCurrentMonth(); $em = $this->getDoctrine()->getManager(); $tags = $this->getTags($em); $page = $this->getRequest()->get("page", 1); $list_query = $em->getRepository("TarsierHomeBundle:article")->getArticleBySearch($search_mode_list); $paginator = $this->get('knp_paginator'); $pagination = $paginator->paginate($list_query, $page, 10); // 使用原生SQL // $list=$this->get("database_connection")->fetchAll("SELECT a.* FROM `tags` t LEFT JOIN article_tags at ON t.id=`at`.tags_id LEFT JOIN article a ON a.id=`at`.article_id WHERE t.`name`='$nav_tags';"); $hot_article = $em->getRepository("TarsierHomeBundle:article")->getHotArticle(); $data = ['nav_tags' => '', 'pagination' => $pagination, 'current_month' => $current_month, 'tags' => $tags, 'hot_article' => $hot_article, 'friendlink' => $this->getFriendLink()]; return $data; }
/** * @Route("/user/add",name="useradd") * @Template("TarsierAdminBundle:user:edit.html.twig") */ public function userAddAction() { if (!$this->isLogin()) { return $this->redirect($this->generateUrl('adminlogin')); } if (!$this->isAdmin()) { return $this->redirect($this->generateUrl('adminindex')); } $user = new user(); $userName = $this->getRequest()->cookies->get('userName'); $budiler = $this->createFormBuilder($user, ['attr' => ['id' => 'form-save', 'class' => 'form-save']]); $form = $budiler->add('username', 'text', ['data' => '', 'label_attr' => ['class' => ''], 'attr' => ['class' => 'form-control input-signin', 'placeholder' => "UserName"]])->add('password', 'password', ['data' => '', 'label_attr' => ['class' => ''], 'attr' => ['class' => 'form-control input-signin']])->add('status', 'choice', ['data' => '', 'choices' => ['0' => 'Delete', '1' => 'Pending', '2' => 'Effective'], 'label_attr' => ['class' => ''], 'attr' => ['class' => 'form-control input-signin']])->add('email', 'email', ['data' => '', 'label_attr' => ['class' => ''], 'attr' => ['class' => 'form-control input-signin']])->add('moon', 'text', ['label_attr' => ['class' => ''], 'attr' => ['class' => 'form-control input-signin'], 'required' => 0])->add('age', 'integer', ['label_attr' => ['class' => ''], 'attr' => ['class' => 'form-control input-signin'], 'required' => 0])->add('sex', 'choice', ['choices' => ['0' => 'Famle', '1' => 'Male'], 'label_attr' => ['class' => ''], 'attr' => ['class' => 'form-control input-signin'], 'required' => 0])->add('Save', 'submit', ['attr' => ['class' => 'btn btn-lg btn-primary btn-block form-save-btn']])->getForm(); $form->handleRequest($this->getRequest()); if ($form->isValid()) { $em = $this->getEm(); $ret_form = $this->getRequest()->get('form'); $c = new Common(); $user->setSalt($c->createRandStr()); $profile = new userprofile(); $profile->setMoon($ret_form['moon']); $profile->setAge($ret_form['age']); $profile->setSex($ret_form['sex']); $profile->setPacket(0); $em->persist($profile); $em->flush(); $user->setProfile($profile); $user->setPassword(md5($ret_form['password'] . $user->getSalt())); $em->persist($user); $em->flush(); return $this->redirect($this->generateUrl('userlist')); } $data = ['save_form' => $form->createView(), 'userName' => $userName, 'nav' => 'user']; return $data; }