public function findByIdAndDelete($id)
{
// Create basic query
$qb = $this->createQueryBuilder('u')->leftJoin('u.accountContacts', 'accountContacts')->leftJoin('accountContacts.account', 'account')->leftJoin('u.contactAddresses', 'contactAddresses')->leftJoin('contactAddresses.address', 'addresses')->leftJoin('addresses.contactAddresses', 'addressContactAddresses')->leftJoin('addresses.accountAddresses', 'addressAccountAddresses')->leftJoin('addressContactAddresses.contact', 'addressContacts')->leftJoin('addressAccountAddresses.account', 'addressAccounts')->leftJoin('addresses.country', 'country')->leftJoin('addresses.addressType', 'addressType')->leftJoin('u.locales', 'locales')->leftJoin('u.emails', 'emails')->leftJoin('emails.contacts', 'emailsContacts')->leftJoin('emails.accounts', 'emailsAccounts')->leftJoin('emails.emailType', 'emailType')->leftJoin('u.notes', 'notes')->leftJoin('u.phones', 'phones')->leftJoin('phones.contacts', 'phonesContacts')->leftJoin('phones.accounts', 'phonesAccounts')->leftJoin('phones.phoneType', 'phoneType')->leftJoin('u.faxes', 'faxes')->leftJoin('faxes.contacts', 'faxesContacts')->leftJoin('faxes.accounts', 'faxesAccounts')->leftJoin('faxes.faxType', 'faxType')->leftJoin('u.tags', 'tags')->leftJoin('u.urls', 'urls')->leftJoin('u.title', 'title')->leftJoin('accountContacts.position', 'position')->addSelect('position')->addSelect('title')->addSelect('urls')->addSelect('tags')->addSelect('accountContacts')->addSelect('account')->addSelect('locales')->addSelect('emails')->addSelect('emailType')->addSelect('faxes')->addSelect('faxType')->addSelect('phones')->addSelect('phoneType')->addSelect('contactAddresses')->addSelect('addressContactAddresses')->addSelect('addressAccountAddresses')->addSelect('addresses')->addSelect('country')->addSelect('addressType')->addSelect('emailsContacts')->addSelect('faxesContacts')->addSelect('phonesContacts')->addSelect('addressContacts')->addSelect('emailsAccounts')->addSelect('faxesAccounts')->addSelect('phonesAccounts')->addSelect('addressAccounts')->addSelect('notes')->where('u.id=:id');
$query = $qb->getQuery();
$query->setParameter('id', $id);
try {
$contact = $query->getSingleResult();
return $contact;
} catch (NoResultException $nre) {
return;
}
}