/**
* @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;
}
