我有一个城市和选民实体在一个或多个关系中。我想把实体字段(一个下拉列表中有数千条记录)转换为文本输入,这样当用户开始输入2 letters.After时,我就可以实现letters.After自动完成。我成功地创建了将实体字段转换为文本input.Now的DataTransformer。我的问题是,我仍然在学习JQuery/Ajax,并且不知道如何在Symfony2表单中实现它。
//formtype.php
private $entityManager;
public function __construct(ObjectManager $entityManager)
{
$this->entityManager = $entityManager;
}
$builder
->add('address', null, array(
'error_bubbling' => true
))
->add('city', 'text', array(
'label' => 'Type your city',
//'error_bubbling' => true,
'invalid_message' => 'That city you entered is not listed',
))
$builder->get('city')
->addModelTransformer(new CityAutocompleteTransformer($this->entityManager));
//datatransformer.php
class CityAutocompleteTransformer implements DataTransformerInterface
{
private $entityManager;
public function __construct(ObjectManager $entityManager)
{
$this->entityManager = $entityManager;
}
public function transform($city)
{
if (null === $city) {
return '';
}
return $city->getName();
}
public function reverseTransform($cityName)
{
if (!$cityName) {
return;
}
$city = $this->entityManager
->getRepository('DuterteBundle:City')->findOneBy(array('name' => $cityName));
if (null === $city) {
throw new TransformationFailedException(sprintf('There is no "%s" exists',
$cityName
));
}
return $city;
}
}//controller.php er.php
public function createAction(Request $request)
{
$entity = new Voters();
$form = $this->createCreateForm($entity);
$form->handleRequest($request);
$validator = $this->get('validator');
$errors = $validator->validate($entity);
if ($form->isValid()) {
$em = $this->getDoctrine()->getManager();
$em->persist($entity);
$em->flush();
$this->addFlash('danger', 'You are successfully added!, Welcome to the growing Supporters, dont forget to share and invite this to your friends and relatives, click share buttons below, have a magical day!');
//return $this->redirect($this->generateUrl('voters_show', array('id' => $entity->getId())));
return $this->redirect($this->generateUrl('voters_list'));
} else {
$this->addFlash('danger', 'Oppss somethings went wrong, check errors buddy!');
return $this->render('DuterteBundle:Voters:neww.html.twig', array(
'entity' => $entity,
'form' => $form->createView(),
));
}
}
/**
* Creates a form to create a Voters entity.
*
* @param Voters $entity The entity
*
* @return \Symfony\Component\Form\Form The form
*/
private function createCreateForm(Voters $entity)
{
$entityManager = $this->getDoctrine()->getManager();
$form = $this->createForm(new VotersType($entityManager), $entity, //here i passed the entity manager to make it work
array(
'action' => $this->generateUrl('voters_create'),
'method' => 'POST',
));
$form->add('submit', 'submit', array(
'label' => 'I Will Vote Mayor Duterte'
));
return $form;
}使用这段代码,我可以成功地创建一个新的投票者,并且当用户输入一个与我现在缺少的城市名称不匹配的城市名时,我会抛出验证错误(invalid_message格式)--当用户输入至少两个字母时,我想实现JQuery自动完成。
Twig部分
//twig.php
{{ form_start(form, {attr: {novalidate: 'novalidate'}} ) }}
{{ form_errors(form) }}
{{ form_row(form.comments,{'attr': {'placeholder': 'Why You Want '}}) }}
{{ form_row(form.email,{'attr': {'placeholder': 'Email is optional, you may leave it blank.But if you want to include your email, make sure it is your valid email '}}) }}
{{ form_end(form) }}

如您所见,表单本身是由许多字段组成的,除了城市field.Here之外,城市字段是一个下拉列表,它由来自数据库的一千多个条目组成。我可以使用DataTransformer.So成功地将这个下拉列表转换为textfield。这里的问题是如何在这个表单中用许多字段实现JQuery自动完成。
任何帮助都是非常感谢的。
更新
根据用户Frankbeen的回答,我在控制器内添加了一个操作
public function autocompleteAction(Request $request)
{
$names = array();
$term = trim(strip_tags($request->get('term')));
$em = $this->getDoctrine()->getManager();
$entities = $em->getRepository('DuterteBundle:City')->createQueryBuilder('c')
->where('c.name LIKE :name')
->setParameter('name', '%'.$term.'%')
->getQuery()
->getResult();
foreach ($entities as $entity)
{
$names[] = $entity->getName()."({$entity->getProvince()})";
}
$response = new JsonResponse();
$response->setData($names);
return $response;
}还有js文件
{% block javascripts %}
{{ parent() }}
<script src="//code.jquery.com/ui/1.10.3/jquery-ui.js"></script>
<script>
$(function() {
function log( message ) {
$( "<div>" ).text( message ).prependTo( "#log" );
$( "#log" ).scrollTop( 0 );
}
$( "#project_bundle_dutertebundle_voters_city").autocomplete({
source: "{{ path('city_autocomplete') }}",
minLength: 2,
select: function( event, ui ) {
log( ui.item ?
"Selected: " + ui.item.value + " aka " + ui.item.id :
"Nothing selected, input was " + this.value );
}
});
});
</script>
{% endblock %}在这种情况下,
$( "#project_bundle_dutertebundle_voters_city").autocomplete({部件实际上是Symfony2在呈现form.The JQuery自动完成时提供的默认id,但问题是,我无法保存所选选项,在FormType.php中创建的invalid_message验证将被触发,当单击提交按钮时将触发JQuery脚本。
选定: Basista (潘加西南省),又名未定
,它表明所选值的Id未定义。
$( "#project_bundle_dutertebundle_voters_city").autocomplete({
source: "{{ path('city_autocomplete') }}",
minLength: 2,
select: function( event, ui ) {
log( ui.item ?
"Selected: " + ui.item.value + " aka " + ui.item.id ://this throw undefined
"Nothing selected, input was " + this.value );
}
});发布于 2015-09-01 22:08:25
首先,您必须开始创建返回json数据的路由和操作。JQuery的自动完成远程为您提供了一个索引为“术语”的$_GET变量,并希望返回JSON。下面是一个使用名称为City的实体和属性$name的示例
namespace AppBundle\Controller;
use Sensio\Bundle\FrameworkExtraBundle\Configuration\Route;
use Symfony\Bundle\FrameworkBundle\Controller\Controller;
use Symfony\Component\HttpFoundation\Request;
use Symfony\Component\HttpFoundation\JsonResponse;
/**
* City controller.
*
* @Route("/city")
*/
class CityController extends Controller
{
/**
* @Route("/autocomplete", name="city_autocomplete")
*/
public function autocompleteAction(Request $request)
{
$names = array();
$term = trim(strip_tags($request->get('term')));
$em = $this->getDoctrine()->getManager();
$entities = $em->getRepository('AppBundle:City')->createQueryBuilder('c')
->where('c.name LIKE :name')
->setParameter('name', '%'.$term.'%')
->getQuery()
->getResult();
foreach ($entities as $entity)
{
$names[] = $entity->getName();
}
$response = new JsonResponse();
$response->setData($names);
return $response;
}
}第二,您可以创建一个细枝视图,就像jQuery的自动完成的源代码一样。唯一的区别是autocomplete()函数中的源变量。在这里,您必须使用路由键(如city_autocomplete. )指定twig的path()函数
(此视图需要另一条路径和另一个(正常)操作。)
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>jQuery UI Autocomplete - Remote datasource</title>
<link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css">
<script src="//code.jquery.com/jquery-1.10.2.js"></script>
<script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script>
<link rel="stylesheet" href="/resources/demos/style.css">
<style>
.ui-autocomplete-loading {
background: white url("images/ui-anim_basic_16x16.gif") right center no-repeat;
}
</style>
<script>
$(function() {
function log( message ) {
$( "<div>" ).text( message ).prependTo( "#log" );
$( "#log" ).scrollTop( 0 );
}
$( "#birds" ).autocomplete({
source: "{{ path('city_autocomplete') }}",
minLength: 2,
select: function( event, ui ) {
log( ui.item ?
"Selected: " + ui.item.value + " aka " + ui.item.id :
"Nothing selected, input was " + this.value );
}
});
});
</script>
</head>
<body>
<div class="ui-widget">
<label for="birds">Birds: </label>
<input id="birds">
</div>
<div class="ui-widget" style="margin-top:2em; font-family:Arial">
Result:
<div id="log" style="height: 200px; width: 300px; overflow: auto;" class="ui-widget-content"></div>
</div>
</body>
</html>最后,您可以稍微改变这个视图,并使用您自己的形式。
发布于 2015-09-03 10:45:31
最后,在深入研究了我的Symfony代码之后,我终于找到了solution.Using --用户Frankbeen提供的代码--我为JQuery添加了一些“微调”,最终work.The的罪魁祸首在控制器中。
$names[] = $entity->getName()."({$entity->getProvince()})";城市实体在一对多的relationship.Since中与省实体相关,城市实体有数千个名称(记录),一些值可能具有相同的名称,因此附加相关的省有助于避免用户的混淆。
旧金山(俄罗斯省)、旧金山(中国省)、旧金山(葡萄牙省)

现在,由于已经保存在数据库中的名称中现在“不同”的名称,invalid_message验证将触发errors.My解决方案,即在将用户提交的值与数据库中的值进行比较之前,通过删除附加的省份来“清理”提交的数据。在DataTransformer内部,我添加了一些代码
public function reverseTransform($cityNameConcat)
{
$cityName = preg_replace("/\([^)]+\)/", "", $cityNameConcat);
if (!$cityName) {
return;
}
$city = $this->entityManager
->getRepository('DuterteBundle:City')->findOneBy(array('name' => $cityName));
if (null === $city) {
throw new TransformationFailedException(sprintf('There is no "%s" exists',
$cityName
));
}
return $city;
}现在JQuery终于开始工作了,保存到数据库的同时也是successful.And。
$( "#project_bundle_dutertebundle_voters_city").autocomplete({
source: "{{ path('city_autocomplete') }}",
minLength: 2,
select: function( event, ui ) {
log( ui.item ?
"Selected: " + ui.item.value + " aka " + ui.item.id ://this throw undefined
"Nothing selected, input was " + this.value );
}
});被更改为
<script>
$(function() {
function log( message ) {
$( "<div>" ).text( message ).prependTo( "#log" );
$( "#log" ).scrollTop( 0 );
}
$( "#project_bundle_dutertebundle_voters_city").autocomplete({
source: "{{ path('city_autocomplete') }}",
minLength: 2,
select: function( event, ui ) {
log( ui.item ?
"Selected: " + ui.item.value + " aka " + ui.item.label:
"Nothing selected, input was " + this.value );
$("#project_bundle_dutertebundle_voters_city").val(ui.item.label);
$("#project_bundle_dutertebundle_voters_city").val(ui.item.value);
return false;
},
change: function( event, ui ) {
$( "#project_bundle_dutertebundle_voters_city" ).val( ui.item? ui.item.value : 0 );
}
});
});
</script>现在,“未定义”错误消失了。
发布于 2017-06-22 17:56:28
这里,添加一个关于Symfony控制器给出的响应的字段的解决方案。成功时,通过返回对象添加所需字段。然后,在select中,您可以通过ui.item.fields访问它
$('#mySelector').autocomplete({
source : function(requete, reponse) {
lettre = {
lettre: $('#lettre').val()
};
$.ajax({
url: Routing.generate('chargementSource'),
dataType: 'json',
data : lettre,
success: function (donnee) {
reponse(
$.map(donnee, function (objet) {
return {
value: '' + objet.nom + ' ' + objet.prenom +', '+ objet.adresse +' '+ objet.codepostal +', '+ objet.ville + '',
id: objet.id
}
})
);
}
});
},
select: function (event, ui) {
$('#myId').val(ui.item.id);
//alert(ui.item.id);
//$('#myId').val(ui.elem.value);
return false;
}
});
https://stackoverflow.com/questions/32334289
复制相似问题