private function createSearchBuilder()
{
$builder = new Builder();
$builder->columns(['ping.id', 'ping.batchId', 'ping.proxyId', 'ping.httpCode', 'ping.duration', 'ping.createdAt', 'ping.updatedAt', 'ping.error', 'b.urlId', 'b.name', 'u.address as urlAddress', 'pr.address as proxyAddress']);
$builder->addFrom('ping');
$builder->innerJoin('proxy', 'pr.id = ping.proxyId', 'pr');
$builder->innerJoin('batch', 'b.id = ping.batchId', 'b');
$builder->innerJoin('url', 'u.id = b.urlId', 'u');
return $builder;
}
/**
* Get builder associated with table of this model.
*
* @param string|null $tableAlias Table alias to use in query.
*
* @return Builder
*/
public static function getBuilder($tableAlias = null)
{
$builder = new Builder();
$table = get_called_class();
if (!$tableAlias) {
$builder->from($table);
} else {
$builder->addFrom($table, $tableAlias);
}
return $builder;
}
private function createSearchBuilder()
{
$builder = new Builder();
$builder->columns(['ping.id as pingId', 'ping.httpCode', 'ping.duration', 'b.id as batchId', 'b.name', 'c.id as countryId', 'c.code as proxyCountryCode', 'u.id as urlId', 'u.address as urlAddress', 'pr.id as proxyId', 'pr.address as proxyAddress']);
$builder->addFrom('ping');
$builder->innerJoin('proxy', 'pr.id = ping.proxyId', 'pr');
$builder->innerJoin('country', 'c.id = pr.countryId', 'c');
$builder->innerJoin('batch', 'b.id = ping.batchId', 'b');
$builder->innerJoin('url', 'u.id = b.urlId', 'u');
return $builder;
}
