public function getPerTimeHeader($is_admin = false)
{
$metadata = new Metadata($this->adapter);
$header = $metadata->getColumnNames($this->table);
// return ($is_admin) ? $header : array_diff($header, $this->adminFields);
return $is_admin ? $header : $header;
}
protected function _insertInto($table, array $data, $columns = null)
{
if (!$data) {
return;
}
if ($columns === null) {
$columns = $this->_metadata->getColumnNames($table);
}
$insertStmt = new InsertMultiple($table);
if ($columns !== null) {
$insertStmt->columns($columns);
}
foreach ($data as $row) {
$insertStmt->values($row, InsertMultiple::VALUES_MERGE);
}
$sql = $this->_sql->buildSqlString($insertStmt);
$this->_db->query($sql, Adapter::QUERY_MODE_EXECUTE);
}
/**
* @param $filter
* @param $orderBy
* @param $order
* @param string $source
* @return Paginator
* @throws \Exception
*/
public function paginate($filter, $orderBy, $order, $source = '')
{
try {
$metadata = new Metadata($this->adapter);
if (empty($source)) {
$source = $this->table;
}
$columns = $metadata->getColumnNames($source);
$select = new Select($source);
$select->order($orderBy . ' ' . $order);
if (!empty($filter)) {
$query = "CONCAT_WS(' '," . implode(',', $columns) . ') LIKE ?';
$where = new Where();
$where->literal($query, '%' . $filter . '%');
$select->where($where);
}
$paginatorAdapter = new DbSelect($select, $this->adapter);
return new Paginator($paginatorAdapter);
} catch (\Exception $ex) {
throw $ex;
}
}
public function getPerTimeHeaderPrivateExchange()
{
$metadata = new Metadata($this->adapter);
$header = $metadata->getColumnNames('PublisherImpressionsAndSpendHourly');
return array_values(array_diff($header, $this->domainAdminFields));
}
public function getPerTimeHeader($is_admin = false)
{
$metadata = new Metadata($this->adapter);
$header = $metadata->getColumnNames('buySideHourlyBidsPerTime');
return $is_admin ? $header : array_values(array_diff($header, $this->adminFields));
}
public function getPerTimeHeader($is_admin = false)
{
$metadata = new Metadata($this->adapter);
$header = $metadata->getColumnNames('PublisherImpressionsAndSpendHourly');
return $is_admin ? $header : array_values(array_diff($header, $this->adminFields));
}
public function getUserImpressionsSpendHeadersAdmin()
{
$metadata = new Metadata($this->adapter);
return $metadata->getColumnNames('userImpressionsSpendAdmin');
}
/**
* Get tables' columns
*
* @param type $table
* @return array
*/
public function getCols($table)
{
$metadata = new Metadata($this->getAdapter());
return $metadata->getColumnNames($table);
}
public function getAverageHeaderAdmin()
{
$metadata = new Metadata($this->adapter);
return $metadata->getColumnNames('buySideHourlyBidsAvarageAdmin');
}