PHP Espo\Core\ORM\Repositories RDB::handleSelectParams示例

示例#1

文件： Contact.php 项目： naushrambo/espocrm

 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        ";
 }

示例#2

文件： Lead.php 项目： lucasmattos/crm

 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";
 }