public function __construct($upload_id) { parent::__construct('commercialauditing', $upload_id); $regions = Config::get('plr.frontend.filter_order.commercial-auditing.region'); $regions = array_pluck($regions, 'dbLabel'); $this->string('country')->position(0); $this->string('reference')->position(1)->insert(); $this->string('company')->position(2)->insert(); $this->string('brand')->position(3)->insert(); $this->string('product')->position(4)->insert(); $this->integer('spots')->position(5)->insert(); $this->seconds('airtime')->position(6)->insert(); $this->enum('region', $regions)->position(7); $this->string('channel')->position(8); $this->string('season')->position(9); $this->integer('productcategory_id')->insert(); $this->integer('territory_id')->insert(); $this->integer('channel_id')->insert(); $this->integer('upload_id')->insert(); $this->integer('season_id')->insert(); $this->datetime('created_at', 'Y-m-d H:i:s')->insert(); $this->datetime('updated_at', 'Y-m-d H:i:s')->insert(); $this->relation('productcategories', 'productcategory_id')->field('name', 'product')->onBeforeInsert([$this, 'makeTimestamps']); $this->relation('territories', 'territory_id')->field('name', 'country')->field('region', 'region')->onBeforeInsert([$this, 'makeAbb'])->onBeforeInsert([$this, 'makeTimestamps']); $this->relation('channels', 'channel_id')->field('name', 'channel')->onBeforeInsert([$this, 'addUploadId'])->onBeforeInsert([$this, 'makeAbb'])->onBeforeInsert([$this, 'makeTimestamps']); $this->relation('seasons', 'season_id')->field('name', 'season')->onBeforeInsert([$this, 'makeTimestamps']); $this->on('parsed', [$this, 'makeTimestamps']); }
public function __construct($upload_id) { parent::__construct('matches', $upload_id); $this->string('competition')->position(0); $this->date('date', 'd/m/Y')->position(1); $this->string('day')->position(2); $this->time('time', 'H:i:s')->position(3); $this->string('home_club')->position(4); $this->string('away_club')->position(5); $this->integer('attendance')->position(6)->insert(); $this->integer('capacity')->position(7)->insert(); $this->string('broadcaster')->position(8); $this->string('season')->position(9); $this->date('start', 'Y-m-d H:i:s')->insert(); $this->integer('competition_id')->insert(); $this->integer('season_id')->insert(); $this->integer('broadcaster_id')->insert(); $this->integer('home_club_id')->insert(); $this->integer('away_club_id')->insert(); $this->integer('upload_id')->insert(); $this->relation('competitions', 'competition_id')->field('name', 'competition')->onBeforeInsert(array($this, 'makeAbb'))->onBeforeInsert(array($this, 'makeTimestamps')); $this->relation('clubs', 'home_club_id')->field('name', 'home_club')->onBeforeInsert(array($this, 'makeAbb'))->onBeforeInsert(array($this, 'makeTimestamps')); $this->relation('clubs', 'away_club_id')->field('name', 'away_club')->onBeforeInsert(array($this, 'makeAbb'))->onBeforeInsert(array($this, 'makeTimestamps')); $this->relation('seasons', 'season_id')->field('name', 'season')->onBeforeInsert(array($this, 'makeTimestamps')); $this->relation('broadcasters', 'broadcaster_id')->field('name', 'broadcaster')->onBeforeInsert(array($this, 'makeTimestamps')); $this->on('parsed', function ($row) { $row['start'] = $row['date'] . ' ' . $row['time']; return $row; }); $this->on('parsed', [$this, 'makeTimestamps']); }
/** * @see Subjects::__construct() */ public function __construct() { \tao_helpers_Context::load('STANDALONE_MODE'); parent::__construct(); }
public function __construct() { parent::__construct(); $this->layout = 'registered'; $this->ctrlpath = 'user/' . $this->router->fetch_class(); }
public function __construct($upload_id) { parent::__construct('broadcasts', $upload_id); $this->string('type', '/^(CDT|OVN)$/')->position(0)->insert(); $this->string('competition')->position(1); $this->string('home_club')->position(2); $this->string('away_club')->position(3); $this->string('programme_type')->position(4); $this->integer('timeslot_id')->position(5)->insert(); $this->string('package', '/^[A-Z]?$/')->position(6)->insert(); $this->date('date', 'd/m/Y')->position(7); $this->string('season')->position(8); $this->string('day')->position(9); $this->string('programme_title')->position(10); $this->string('channel')->position(11); $this->string('broadcaster')->position(12); $this->time('time', 'H:i:s')->position(13); $this->time('end', 'H:i:s')->position(14); $this->seconds('duration')->position(15)->insert(); $this->float('aud_4_000')->position(16)->insert(); $this->float('aud_4_tvr')->position(17)->insert(); $this->float('aud_4_share')->position(18)->insert(); $this->float('aud_4_peak')->position(19)->insert(); $this->float('aud_16_34_000')->position(20)->insert(); $this->float('aud_16_34_tvr')->position(21)->insert(); $this->float('aud_16_34_share')->position(22)->insert(); $this->float('aud_16_34_peak')->position(23)->insert(); $this->float('aud_16_000')->position(24)->insert(); $this->float('aud_16_tvr')->position(25)->insert(); $this->float('aud_16_share')->position(26)->insert(); $this->float('aud_16_peak')->position(27)->insert(); $this->date('start', 'Y-m-d H:i:s')->insert(); $this->integer('competition_id')->insert(); $this->integer('home_club_id')->insert(); $this->integer('away_club_id')->insert(); $this->integer('season_id')->insert(); $this->integer('programme_id')->insert(); $this->integer('channel_id')->insert(); $this->integer('upload_id')->insert(); $this->relation('competitions', 'competition_id')->field('name', 'competition')->onBeforeInsert(array($this, 'makeAbb'))->onBeforeInsert(array($this, 'makeTimestamps')); $this->relation('clubs', 'home_club_id')->field('name', 'home_club')->onBeforeInsert(array($this, 'makeAbb'))->onBeforeInsert(array($this, 'makeTimestamps')); $this->relation('clubs', 'away_club_id')->field('name', 'away_club')->onBeforeInsert(array($this, 'makeAbb'))->onBeforeInsert(array($this, 'makeTimestamps')); $this->relation('seasons', 'season_id')->field('name', 'season')->onBeforeInsert(array($this, 'makeTimestamps')); $this->relation('programmes', 'programme_id')->field('name', 'programme_title')->field('type', 'programme_type')->onBeforeInsert(array($this, 'makeTimestamps')); $this->relation('channels', 'channel_id')->field('name', 'channel')->onBeforeInsert(array($this, 'makeAbb'))->onBeforeInsert(array($this, 'makeTimestamps')); $this->on('parsed', function ($row) { $row['start'] = $row['date'] . ' ' . $row['time']; $row['aud_4_000'] = $row['aud_4_000'] * 1000; $row['aud_4_tvr'] = $row['aud_4_tvr'] * 1000; $row['aud_4_share'] = $row['aud_4_share'] * 1000; $row['aud_4_peak'] = $row['aud_4_peak'] * 1000; $row['aud_16_34_000'] = $row['aud_16_34_000'] * 1000; $row['aud_16_34_tvr'] = $row['aud_16_34_tvr'] * 1000; $row['aud_16_34_share'] = $row['aud_16_34_share'] * 1000; $row['aud_16_34_peak'] = $row['aud_16_34_peak'] * 1000; $row['aud_16_000'] = $row['aud_16_000'] * 1000; $row['aud_16_tvr'] = $row['aud_16_tvr'] * 1000; $row['aud_16_share'] = $row['aud_16_share'] * 1000; $row['aud_16_peak'] = $row['aud_16_peak'] * 1000; return $row; }); $this->on('parsed', [$this, 'makeTimestamps']); }