protected function onlyCustomer($query, $request)
{
if (isset($request['onlyCustomer'])) {
$modelOrder = \Simple\Factory::model('order', 'O');
$queryJoin = \Simple\Factory::queryJoin($modelUser, $modelOrder);
$query->join('left', $queryJoin);
$query->where($modelOrder->field($modelOrder->pk()), 'NULL', 'IS NOT');
}
}
public function testQueryJoinWithArray()
{
$modelA = \Simple\Factory::model('superA', 'A');
$modelB = \Simple\Factory::model('hiperB', 'B');
$queryJoin = \Simple\Factory::queryJoin($modelA, array('hiperB', 'B'));
$queryJoin->where($modelB->field('name'), 'john');
$query = \Simple\Factory::query(array('superA', 'A'));
$query->select($modelA->field('*'));
$query->join('left', $queryJoin);
$this->assertEquals('SELECT A.* FROM superA AS A LEFT JOIN hiperB AS B ON A.idSuperA = B.idSuperA AND B.name = (?)', $query->sqlSelect());
}
