public function handleSelectParams(&$params) { parent::handleSelectParams($params); if (empty($params['customJoin'])) { $params['customJoin'] = ''; } $params['customJoin'] .= "\n LEFT JOIN `account_contact` AS accountContact\n ON accountContact.contact_id = contact.id AND accountContact.account_id = contact.account_id AND accountContact.deleted = 0\n "; }
public function handleSelectParams(&$params) { parent::handleSelectParams($params); if (empty($params['customJoin'])) { $params['customJoin'] = ''; } $params['customJoin'] .= " \n\t\t\tLEFT JOIN currency ON currency.id = lead.opportunity_amount_currency\n\t\t"; }