SugarCRM::SugarQuery:: Join with custom module

sugarquery_join_custom_module.php

<?php
$sugarQuery = new SugarQuery();
$sugarQuery->select(array('id', 'name', 'precio'));
$precioBean = BeanFactory::newBean('MXC06_Precio');

$sugarQuery->from($precioBean);

$sugarQuery->join('mxc06_precio_accounts');
$sugarQuery->join('mxc06_precio_producttemplates');
$sugarQuery->where()
->equals('mxc06_precio_accountsaccounts_ida', $pedido->cmx03_pedidos_accountsaccounts_ida)
->equals('mxc06_precio_producttemplatesproducttemplates_ida', $bean->cmx03_detallespedido_producttemplatesproducttemplates_ida);


$GLOBALS['log']->debug("QuoteLogicHook::getPrecio query:" . print_r($sugarQuery->compileSql(), true) );

$result = $sugarQuery->execute();

Hi, I'm curious about this. Where do you keep this file and how do you use it?
I need to do a similar thing with custom modules.

Hi rszczypka,

what do you exactly need to do?

This is a little snippet, you can use it on jobs, logic hooks, apis.