예제 #1
0
 public function __construct()
 {
     parent::__construct();
     $this->getBaseCriteria()->cols(['CustomerId' => 'customerId', 'FirstName' => 'firstName', 'LastName' => 'lastName', 'Company' => 'company', 'Address' => 'address', 'City' => 'city', 'State' => 'state', 'Country' => 'country', 'PostalCode' => 'postalCode', 'Phone' => 'phone', 'Fax' => 'fax', 'Email' => 'email', 'SupportRepId' => 'supportRepId'])->from('customers');
 }
예제 #2
0
 public function __construct()
 {
     parent::__construct();
     $this->getBaseCriteria()->cols(['a.AlbumId' => 'albumId', 'a.Title' => 'title', 'a.ArtistId' => 'artistId'])->from('albums as a');
 }
예제 #3
0
 public function __construct()
 {
     parent::__construct();
     $this->getBaseCriteria()->cols(['ArtistId' => 'artistId', 'Name' => 'name'])->from('artists');
 }
예제 #4
0
 public function __construct()
 {
     parent::__construct();
     $this->getBaseCriteria()->cols(['TrackId' => 'trackId', 'Name' => 'name', 'AlbumId' => 'albumId', 'MediaTypeId' => 'mediaTypeId', 'GenreId' => 'genreId', 'Composer' => 'composer', 'Milliseconds' => 'milliseconds', 'Bytes' => 'bytes', 'UnitPrice' => 'unitPrice'])->from('tracks');
 }