Spaces:
No application file
No application file
File size: 1,236 Bytes
d2897cd |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 |
<?php
namespace MauticPlugin\MauticCrmBundle\Integration\Salesforce;
use MauticPlugin\MauticCrmBundle\Integration\Salesforce\Exception\NoObjectsToFetchException;
class QueryBuilder
{
/**
* @throws NoObjectsToFetchException
*/
public static function getLeadQuery(array $fields, array $ids): string
{
if (empty($ids)) {
throw new NoObjectsToFetchException();
}
$fieldString = self::getFieldString($fields);
$idString = implode("','", $ids);
return ($idString) ? "SELECT $fieldString from Lead where Id in ('$idString') and ConvertedContactId = NULL" : '';
}
/**
* @throws NoObjectsToFetchException
*/
public static function getContactQuery(array $fields, array $ids): string
{
if (empty($ids)) {
throw new NoObjectsToFetchException();
}
$fieldString = self::getFieldString($fields);
$idString = implode("','", $ids);
return ($idString) ? "SELECT $fieldString from Contact where Id in ('$idString')" : '';
}
private static function getFieldString(array $fields): string
{
$fields[] = 'Id';
return implode(', ', array_unique($fields));
}
}
|