BaseCcShowQuery.php 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730
  1. <?php
  2. /**
  3. * Base class that represents a query for the 'cc_show' table.
  4. *
  5. *
  6. *
  7. * @method CcShowQuery orderByDbId($order = Criteria::ASC) Order by the id column
  8. * @method CcShowQuery orderByDbName($order = Criteria::ASC) Order by the name column
  9. * @method CcShowQuery orderByDbUrl($order = Criteria::ASC) Order by the url column
  10. * @method CcShowQuery orderByDbGenre($order = Criteria::ASC) Order by the genre column
  11. * @method CcShowQuery orderByDbDescription($order = Criteria::ASC) Order by the description column
  12. * @method CcShowQuery orderByDbColor($order = Criteria::ASC) Order by the color column
  13. * @method CcShowQuery orderByDbBackgroundColor($order = Criteria::ASC) Order by the background_color column
  14. * @method CcShowQuery orderByDbLiveStreamUsingAirtimeAuth($order = Criteria::ASC) Order by the live_stream_using_airtime_auth column
  15. * @method CcShowQuery orderByDbLiveStreamUsingCustomAuth($order = Criteria::ASC) Order by the live_stream_using_custom_auth column
  16. * @method CcShowQuery orderByDbLiveStreamUser($order = Criteria::ASC) Order by the live_stream_user column
  17. * @method CcShowQuery orderByDbLiveStreamPass($order = Criteria::ASC) Order by the live_stream_pass column
  18. * @method CcShowQuery orderByDbLinked($order = Criteria::ASC) Order by the linked column
  19. * @method CcShowQuery orderByDbIsLinkable($order = Criteria::ASC) Order by the is_linkable column
  20. *
  21. * @method CcShowQuery groupByDbId() Group by the id column
  22. * @method CcShowQuery groupByDbName() Group by the name column
  23. * @method CcShowQuery groupByDbUrl() Group by the url column
  24. * @method CcShowQuery groupByDbGenre() Group by the genre column
  25. * @method CcShowQuery groupByDbDescription() Group by the description column
  26. * @method CcShowQuery groupByDbColor() Group by the color column
  27. * @method CcShowQuery groupByDbBackgroundColor() Group by the background_color column
  28. * @method CcShowQuery groupByDbLiveStreamUsingAirtimeAuth() Group by the live_stream_using_airtime_auth column
  29. * @method CcShowQuery groupByDbLiveStreamUsingCustomAuth() Group by the live_stream_using_custom_auth column
  30. * @method CcShowQuery groupByDbLiveStreamUser() Group by the live_stream_user column
  31. * @method CcShowQuery groupByDbLiveStreamPass() Group by the live_stream_pass column
  32. * @method CcShowQuery groupByDbLinked() Group by the linked column
  33. * @method CcShowQuery groupByDbIsLinkable() Group by the is_linkable column
  34. *
  35. * @method CcShowQuery leftJoin($relation) Adds a LEFT JOIN clause to the query
  36. * @method CcShowQuery rightJoin($relation) Adds a RIGHT JOIN clause to the query
  37. * @method CcShowQuery innerJoin($relation) Adds a INNER JOIN clause to the query
  38. *
  39. * @method CcShowQuery leftJoinCcShowInstances($relationAlias = '') Adds a LEFT JOIN clause to the query using the CcShowInstances relation
  40. * @method CcShowQuery rightJoinCcShowInstances($relationAlias = '') Adds a RIGHT JOIN clause to the query using the CcShowInstances relation
  41. * @method CcShowQuery innerJoinCcShowInstances($relationAlias = '') Adds a INNER JOIN clause to the query using the CcShowInstances relation
  42. *
  43. * @method CcShowQuery leftJoinCcShowDays($relationAlias = '') Adds a LEFT JOIN clause to the query using the CcShowDays relation
  44. * @method CcShowQuery rightJoinCcShowDays($relationAlias = '') Adds a RIGHT JOIN clause to the query using the CcShowDays relation
  45. * @method CcShowQuery innerJoinCcShowDays($relationAlias = '') Adds a INNER JOIN clause to the query using the CcShowDays relation
  46. *
  47. * @method CcShowQuery leftJoinCcShowRebroadcast($relationAlias = '') Adds a LEFT JOIN clause to the query using the CcShowRebroadcast relation
  48. * @method CcShowQuery rightJoinCcShowRebroadcast($relationAlias = '') Adds a RIGHT JOIN clause to the query using the CcShowRebroadcast relation
  49. * @method CcShowQuery innerJoinCcShowRebroadcast($relationAlias = '') Adds a INNER JOIN clause to the query using the CcShowRebroadcast relation
  50. *
  51. * @method CcShowQuery leftJoinCcShowHosts($relationAlias = '') Adds a LEFT JOIN clause to the query using the CcShowHosts relation
  52. * @method CcShowQuery rightJoinCcShowHosts($relationAlias = '') Adds a RIGHT JOIN clause to the query using the CcShowHosts relation
  53. * @method CcShowQuery innerJoinCcShowHosts($relationAlias = '') Adds a INNER JOIN clause to the query using the CcShowHosts relation
  54. *
  55. * @method CcShow findOne(PropelPDO $con = null) Return the first CcShow matching the query
  56. * @method CcShow findOneOrCreate(PropelPDO $con = null) Return the first CcShow matching the query, or a new CcShow object populated from the query conditions when no match is found
  57. *
  58. * @method CcShow findOneByDbId(int $id) Return the first CcShow filtered by the id column
  59. * @method CcShow findOneByDbName(string $name) Return the first CcShow filtered by the name column
  60. * @method CcShow findOneByDbUrl(string $url) Return the first CcShow filtered by the url column
  61. * @method CcShow findOneByDbGenre(string $genre) Return the first CcShow filtered by the genre column
  62. * @method CcShow findOneByDbDescription(string $description) Return the first CcShow filtered by the description column
  63. * @method CcShow findOneByDbColor(string $color) Return the first CcShow filtered by the color column
  64. * @method CcShow findOneByDbBackgroundColor(string $background_color) Return the first CcShow filtered by the background_color column
  65. * @method CcShow findOneByDbLiveStreamUsingAirtimeAuth(boolean $live_stream_using_airtime_auth) Return the first CcShow filtered by the live_stream_using_airtime_auth column
  66. * @method CcShow findOneByDbLiveStreamUsingCustomAuth(boolean $live_stream_using_custom_auth) Return the first CcShow filtered by the live_stream_using_custom_auth column
  67. * @method CcShow findOneByDbLiveStreamUser(string $live_stream_user) Return the first CcShow filtered by the live_stream_user column
  68. * @method CcShow findOneByDbLiveStreamPass(string $live_stream_pass) Return the first CcShow filtered by the live_stream_pass column
  69. * @method CcShow findOneByDbLinked(boolean $linked) Return the first CcShow filtered by the linked column
  70. * @method CcShow findOneByDbIsLinkable(boolean $is_linkable) Return the first CcShow filtered by the is_linkable column
  71. *
  72. * @method array findByDbId(int $id) Return CcShow objects filtered by the id column
  73. * @method array findByDbName(string $name) Return CcShow objects filtered by the name column
  74. * @method array findByDbUrl(string $url) Return CcShow objects filtered by the url column
  75. * @method array findByDbGenre(string $genre) Return CcShow objects filtered by the genre column
  76. * @method array findByDbDescription(string $description) Return CcShow objects filtered by the description column
  77. * @method array findByDbColor(string $color) Return CcShow objects filtered by the color column
  78. * @method array findByDbBackgroundColor(string $background_color) Return CcShow objects filtered by the background_color column
  79. * @method array findByDbLiveStreamUsingAirtimeAuth(boolean $live_stream_using_airtime_auth) Return CcShow objects filtered by the live_stream_using_airtime_auth column
  80. * @method array findByDbLiveStreamUsingCustomAuth(boolean $live_stream_using_custom_auth) Return CcShow objects filtered by the live_stream_using_custom_auth column
  81. * @method array findByDbLiveStreamUser(string $live_stream_user) Return CcShow objects filtered by the live_stream_user column
  82. * @method array findByDbLiveStreamPass(string $live_stream_pass) Return CcShow objects filtered by the live_stream_pass column
  83. * @method array findByDbLinked(boolean $linked) Return CcShow objects filtered by the linked column
  84. * @method array findByDbIsLinkable(boolean $is_linkable) Return CcShow objects filtered by the is_linkable column
  85. *
  86. * @package propel.generator.airtime.om
  87. */
  88. abstract class BaseCcShowQuery extends ModelCriteria
  89. {
  90. /**
  91. * Initializes internal state of BaseCcShowQuery object.
  92. *
  93. * @param string $dbName The dabase name
  94. * @param string $modelName The phpName of a model, e.g. 'Book'
  95. * @param string $modelAlias The alias for the model in this query, e.g. 'b'
  96. */
  97. public function __construct($dbName = 'airtime', $modelName = 'CcShow', $modelAlias = null)
  98. {
  99. parent::__construct($dbName, $modelName, $modelAlias);
  100. }
  101. /**
  102. * Returns a new CcShowQuery object.
  103. *
  104. * @param string $modelAlias The alias of a model in the query
  105. * @param Criteria $criteria Optional Criteria to build the query from
  106. *
  107. * @return CcShowQuery
  108. */
  109. public static function create($modelAlias = null, $criteria = null)
  110. {
  111. if ($criteria instanceof CcShowQuery) {
  112. return $criteria;
  113. }
  114. $query = new CcShowQuery();
  115. if (null !== $modelAlias) {
  116. $query->setModelAlias($modelAlias);
  117. }
  118. if ($criteria instanceof Criteria) {
  119. $query->mergeWith($criteria);
  120. }
  121. return $query;
  122. }
  123. /**
  124. * Find object by primary key
  125. * Use instance pooling to avoid a database query if the object exists
  126. * <code>
  127. * $obj = $c->findPk(12, $con);
  128. * </code>
  129. * @param mixed $key Primary key to use for the query
  130. * @param PropelPDO $con an optional connection object
  131. *
  132. * @return CcShow|array|mixed the result, formatted by the current formatter
  133. */
  134. public function findPk($key, $con = null)
  135. {
  136. if ((null !== ($obj = CcShowPeer::getInstanceFromPool((string) $key))) && $this->getFormatter()->isObjectFormatter()) {
  137. // the object is alredy in the instance pool
  138. return $obj;
  139. } else {
  140. // the object has not been requested yet, or the formatter is not an object formatter
  141. $criteria = $this->isKeepQuery() ? clone $this : $this;
  142. $stmt = $criteria
  143. ->filterByPrimaryKey($key)
  144. ->getSelectStatement($con);
  145. return $criteria->getFormatter()->init($criteria)->formatOne($stmt);
  146. }
  147. }
  148. /**
  149. * Find objects by primary key
  150. * <code>
  151. * $objs = $c->findPks(array(12, 56, 832), $con);
  152. * </code>
  153. * @param array $keys Primary keys to use for the query
  154. * @param PropelPDO $con an optional connection object
  155. *
  156. * @return PropelObjectCollection|array|mixed the list of results, formatted by the current formatter
  157. */
  158. public function findPks($keys, $con = null)
  159. {
  160. $criteria = $this->isKeepQuery() ? clone $this : $this;
  161. return $this
  162. ->filterByPrimaryKeys($keys)
  163. ->find($con);
  164. }
  165. /**
  166. * Filter the query by primary key
  167. *
  168. * @param mixed $key Primary key to use for the query
  169. *
  170. * @return CcShowQuery The current query, for fluid interface
  171. */
  172. public function filterByPrimaryKey($key)
  173. {
  174. return $this->addUsingAlias(CcShowPeer::ID, $key, Criteria::EQUAL);
  175. }
  176. /**
  177. * Filter the query by a list of primary keys
  178. *
  179. * @param array $keys The list of primary key to use for the query
  180. *
  181. * @return CcShowQuery The current query, for fluid interface
  182. */
  183. public function filterByPrimaryKeys($keys)
  184. {
  185. return $this->addUsingAlias(CcShowPeer::ID, $keys, Criteria::IN);
  186. }
  187. /**
  188. * Filter the query on the id column
  189. *
  190. * @param int|array $dbId The value to use as filter.
  191. * Accepts an associative array('min' => $minValue, 'max' => $maxValue)
  192. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  193. *
  194. * @return CcShowQuery The current query, for fluid interface
  195. */
  196. public function filterByDbId($dbId = null, $comparison = null)
  197. {
  198. if (is_array($dbId) && null === $comparison) {
  199. $comparison = Criteria::IN;
  200. }
  201. return $this->addUsingAlias(CcShowPeer::ID, $dbId, $comparison);
  202. }
  203. /**
  204. * Filter the query on the name column
  205. *
  206. * @param string $dbName The value to use as filter.
  207. * Accepts wildcards (* and % trigger a LIKE)
  208. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  209. *
  210. * @return CcShowQuery The current query, for fluid interface
  211. */
  212. public function filterByDbName($dbName = null, $comparison = null)
  213. {
  214. if (null === $comparison) {
  215. if (is_array($dbName)) {
  216. $comparison = Criteria::IN;
  217. } elseif (preg_match('/[\%\*]/', $dbName)) {
  218. $dbName = str_replace('*', '%', $dbName);
  219. $comparison = Criteria::LIKE;
  220. }
  221. }
  222. return $this->addUsingAlias(CcShowPeer::NAME, $dbName, $comparison);
  223. }
  224. /**
  225. * Filter the query on the url column
  226. *
  227. * @param string $dbUrl The value to use as filter.
  228. * Accepts wildcards (* and % trigger a LIKE)
  229. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  230. *
  231. * @return CcShowQuery The current query, for fluid interface
  232. */
  233. public function filterByDbUrl($dbUrl = null, $comparison = null)
  234. {
  235. if (null === $comparison) {
  236. if (is_array($dbUrl)) {
  237. $comparison = Criteria::IN;
  238. } elseif (preg_match('/[\%\*]/', $dbUrl)) {
  239. $dbUrl = str_replace('*', '%', $dbUrl);
  240. $comparison = Criteria::LIKE;
  241. }
  242. }
  243. return $this->addUsingAlias(CcShowPeer::URL, $dbUrl, $comparison);
  244. }
  245. /**
  246. * Filter the query on the genre column
  247. *
  248. * @param string $dbGenre The value to use as filter.
  249. * Accepts wildcards (* and % trigger a LIKE)
  250. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  251. *
  252. * @return CcShowQuery The current query, for fluid interface
  253. */
  254. public function filterByDbGenre($dbGenre = null, $comparison = null)
  255. {
  256. if (null === $comparison) {
  257. if (is_array($dbGenre)) {
  258. $comparison = Criteria::IN;
  259. } elseif (preg_match('/[\%\*]/', $dbGenre)) {
  260. $dbGenre = str_replace('*', '%', $dbGenre);
  261. $comparison = Criteria::LIKE;
  262. }
  263. }
  264. return $this->addUsingAlias(CcShowPeer::GENRE, $dbGenre, $comparison);
  265. }
  266. /**
  267. * Filter the query on the description column
  268. *
  269. * @param string $dbDescription The value to use as filter.
  270. * Accepts wildcards (* and % trigger a LIKE)
  271. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  272. *
  273. * @return CcShowQuery The current query, for fluid interface
  274. */
  275. public function filterByDbDescription($dbDescription = null, $comparison = null)
  276. {
  277. if (null === $comparison) {
  278. if (is_array($dbDescription)) {
  279. $comparison = Criteria::IN;
  280. } elseif (preg_match('/[\%\*]/', $dbDescription)) {
  281. $dbDescription = str_replace('*', '%', $dbDescription);
  282. $comparison = Criteria::LIKE;
  283. }
  284. }
  285. return $this->addUsingAlias(CcShowPeer::DESCRIPTION, $dbDescription, $comparison);
  286. }
  287. /**
  288. * Filter the query on the color column
  289. *
  290. * @param string $dbColor The value to use as filter.
  291. * Accepts wildcards (* and % trigger a LIKE)
  292. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  293. *
  294. * @return CcShowQuery The current query, for fluid interface
  295. */
  296. public function filterByDbColor($dbColor = null, $comparison = null)
  297. {
  298. if (null === $comparison) {
  299. if (is_array($dbColor)) {
  300. $comparison = Criteria::IN;
  301. } elseif (preg_match('/[\%\*]/', $dbColor)) {
  302. $dbColor = str_replace('*', '%', $dbColor);
  303. $comparison = Criteria::LIKE;
  304. }
  305. }
  306. return $this->addUsingAlias(CcShowPeer::COLOR, $dbColor, $comparison);
  307. }
  308. /**
  309. * Filter the query on the background_color column
  310. *
  311. * @param string $dbBackgroundColor The value to use as filter.
  312. * Accepts wildcards (* and % trigger a LIKE)
  313. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  314. *
  315. * @return CcShowQuery The current query, for fluid interface
  316. */
  317. public function filterByDbBackgroundColor($dbBackgroundColor = null, $comparison = null)
  318. {
  319. if (null === $comparison) {
  320. if (is_array($dbBackgroundColor)) {
  321. $comparison = Criteria::IN;
  322. } elseif (preg_match('/[\%\*]/', $dbBackgroundColor)) {
  323. $dbBackgroundColor = str_replace('*', '%', $dbBackgroundColor);
  324. $comparison = Criteria::LIKE;
  325. }
  326. }
  327. return $this->addUsingAlias(CcShowPeer::BACKGROUND_COLOR, $dbBackgroundColor, $comparison);
  328. }
  329. /**
  330. * Filter the query on the live_stream_using_airtime_auth column
  331. *
  332. * @param boolean|string $dbLiveStreamUsingAirtimeAuth The value to use as filter.
  333. * Accepts strings ('false', 'off', '-', 'no', 'n', and '0' are false, the rest is true)
  334. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  335. *
  336. * @return CcShowQuery The current query, for fluid interface
  337. */
  338. public function filterByDbLiveStreamUsingAirtimeAuth($dbLiveStreamUsingAirtimeAuth = null, $comparison = null)
  339. {
  340. if (is_string($dbLiveStreamUsingAirtimeAuth)) {
  341. $live_stream_using_airtime_auth = in_array(strtolower($dbLiveStreamUsingAirtimeAuth), array('false', 'off', '-', 'no', 'n', '0')) ? false : true;
  342. }
  343. return $this->addUsingAlias(CcShowPeer::LIVE_STREAM_USING_AIRTIME_AUTH, $dbLiveStreamUsingAirtimeAuth, $comparison);
  344. }
  345. /**
  346. * Filter the query on the live_stream_using_custom_auth column
  347. *
  348. * @param boolean|string $dbLiveStreamUsingCustomAuth The value to use as filter.
  349. * Accepts strings ('false', 'off', '-', 'no', 'n', and '0' are false, the rest is true)
  350. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  351. *
  352. * @return CcShowQuery The current query, for fluid interface
  353. */
  354. public function filterByDbLiveStreamUsingCustomAuth($dbLiveStreamUsingCustomAuth = null, $comparison = null)
  355. {
  356. if (is_string($dbLiveStreamUsingCustomAuth)) {
  357. $live_stream_using_custom_auth = in_array(strtolower($dbLiveStreamUsingCustomAuth), array('false', 'off', '-', 'no', 'n', '0')) ? false : true;
  358. }
  359. return $this->addUsingAlias(CcShowPeer::LIVE_STREAM_USING_CUSTOM_AUTH, $dbLiveStreamUsingCustomAuth, $comparison);
  360. }
  361. /**
  362. * Filter the query on the live_stream_user column
  363. *
  364. * @param string $dbLiveStreamUser The value to use as filter.
  365. * Accepts wildcards (* and % trigger a LIKE)
  366. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  367. *
  368. * @return CcShowQuery The current query, for fluid interface
  369. */
  370. public function filterByDbLiveStreamUser($dbLiveStreamUser = null, $comparison = null)
  371. {
  372. if (null === $comparison) {
  373. if (is_array($dbLiveStreamUser)) {
  374. $comparison = Criteria::IN;
  375. } elseif (preg_match('/[\%\*]/', $dbLiveStreamUser)) {
  376. $dbLiveStreamUser = str_replace('*', '%', $dbLiveStreamUser);
  377. $comparison = Criteria::LIKE;
  378. }
  379. }
  380. return $this->addUsingAlias(CcShowPeer::LIVE_STREAM_USER, $dbLiveStreamUser, $comparison);
  381. }
  382. /**
  383. * Filter the query on the live_stream_pass column
  384. *
  385. * @param string $dbLiveStreamPass The value to use as filter.
  386. * Accepts wildcards (* and % trigger a LIKE)
  387. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  388. *
  389. * @return CcShowQuery The current query, for fluid interface
  390. */
  391. public function filterByDbLiveStreamPass($dbLiveStreamPass = null, $comparison = null)
  392. {
  393. if (null === $comparison) {
  394. if (is_array($dbLiveStreamPass)) {
  395. $comparison = Criteria::IN;
  396. } elseif (preg_match('/[\%\*]/', $dbLiveStreamPass)) {
  397. $dbLiveStreamPass = str_replace('*', '%', $dbLiveStreamPass);
  398. $comparison = Criteria::LIKE;
  399. }
  400. }
  401. return $this->addUsingAlias(CcShowPeer::LIVE_STREAM_PASS, $dbLiveStreamPass, $comparison);
  402. }
  403. /**
  404. * Filter the query on the linked column
  405. *
  406. * @param boolean|string $dbLinked The value to use as filter.
  407. * Accepts strings ('false', 'off', '-', 'no', 'n', and '0' are false, the rest is true)
  408. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  409. *
  410. * @return CcShowQuery The current query, for fluid interface
  411. */
  412. public function filterByDbLinked($dbLinked = null, $comparison = null)
  413. {
  414. if (is_string($dbLinked)) {
  415. $linked = in_array(strtolower($dbLinked), array('false', 'off', '-', 'no', 'n', '0')) ? false : true;
  416. }
  417. return $this->addUsingAlias(CcShowPeer::LINKED, $dbLinked, $comparison);
  418. }
  419. /**
  420. * Filter the query on the is_linkable column
  421. *
  422. * @param boolean|string $dbIsLinkable The value to use as filter.
  423. * Accepts strings ('false', 'off', '-', 'no', 'n', and '0' are false, the rest is true)
  424. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  425. *
  426. * @return CcShowQuery The current query, for fluid interface
  427. */
  428. public function filterByDbIsLinkable($dbIsLinkable = null, $comparison = null)
  429. {
  430. if (is_string($dbIsLinkable)) {
  431. $is_linkable = in_array(strtolower($dbIsLinkable), array('false', 'off', '-', 'no', 'n', '0')) ? false : true;
  432. }
  433. return $this->addUsingAlias(CcShowPeer::IS_LINKABLE, $dbIsLinkable, $comparison);
  434. }
  435. /**
  436. * Filter the query by a related CcShowInstances object
  437. *
  438. * @param CcShowInstances $ccShowInstances the related object to use as filter
  439. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  440. *
  441. * @return CcShowQuery The current query, for fluid interface
  442. */
  443. public function filterByCcShowInstances($ccShowInstances, $comparison = null)
  444. {
  445. return $this
  446. ->addUsingAlias(CcShowPeer::ID, $ccShowInstances->getDbShowId(), $comparison);
  447. }
  448. /**
  449. * Adds a JOIN clause to the query using the CcShowInstances relation
  450. *
  451. * @param string $relationAlias optional alias for the relation
  452. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  453. *
  454. * @return CcShowQuery The current query, for fluid interface
  455. */
  456. public function joinCcShowInstances($relationAlias = '', $joinType = Criteria::INNER_JOIN)
  457. {
  458. $tableMap = $this->getTableMap();
  459. $relationMap = $tableMap->getRelation('CcShowInstances');
  460. // create a ModelJoin object for this join
  461. $join = new ModelJoin();
  462. $join->setJoinType($joinType);
  463. $join->setRelationMap($relationMap, $this->useAliasInSQL ? $this->getModelAlias() : null, $relationAlias);
  464. if ($previousJoin = $this->getPreviousJoin()) {
  465. $join->setPreviousJoin($previousJoin);
  466. }
  467. // add the ModelJoin to the current object
  468. if($relationAlias) {
  469. $this->addAlias($relationAlias, $relationMap->getRightTable()->getName());
  470. $this->addJoinObject($join, $relationAlias);
  471. } else {
  472. $this->addJoinObject($join, 'CcShowInstances');
  473. }
  474. return $this;
  475. }
  476. /**
  477. * Use the CcShowInstances relation CcShowInstances object
  478. *
  479. * @see useQuery()
  480. *
  481. * @param string $relationAlias optional alias for the relation,
  482. * to be used as main alias in the secondary query
  483. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  484. *
  485. * @return CcShowInstancesQuery A secondary query class using the current class as primary query
  486. */
  487. public function useCcShowInstancesQuery($relationAlias = '', $joinType = Criteria::INNER_JOIN)
  488. {
  489. return $this
  490. ->joinCcShowInstances($relationAlias, $joinType)
  491. ->useQuery($relationAlias ? $relationAlias : 'CcShowInstances', 'CcShowInstancesQuery');
  492. }
  493. /**
  494. * Filter the query by a related CcShowDays object
  495. *
  496. * @param CcShowDays $ccShowDays the related object to use as filter
  497. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  498. *
  499. * @return CcShowQuery The current query, for fluid interface
  500. */
  501. public function filterByCcShowDays($ccShowDays, $comparison = null)
  502. {
  503. return $this
  504. ->addUsingAlias(CcShowPeer::ID, $ccShowDays->getDbShowId(), $comparison);
  505. }
  506. /**
  507. * Adds a JOIN clause to the query using the CcShowDays relation
  508. *
  509. * @param string $relationAlias optional alias for the relation
  510. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  511. *
  512. * @return CcShowQuery The current query, for fluid interface
  513. */
  514. public function joinCcShowDays($relationAlias = '', $joinType = Criteria::INNER_JOIN)
  515. {
  516. $tableMap = $this->getTableMap();
  517. $relationMap = $tableMap->getRelation('CcShowDays');
  518. // create a ModelJoin object for this join
  519. $join = new ModelJoin();
  520. $join->setJoinType($joinType);
  521. $join->setRelationMap($relationMap, $this->useAliasInSQL ? $this->getModelAlias() : null, $relationAlias);
  522. if ($previousJoin = $this->getPreviousJoin()) {
  523. $join->setPreviousJoin($previousJoin);
  524. }
  525. // add the ModelJoin to the current object
  526. if($relationAlias) {
  527. $this->addAlias($relationAlias, $relationMap->getRightTable()->getName());
  528. $this->addJoinObject($join, $relationAlias);
  529. } else {
  530. $this->addJoinObject($join, 'CcShowDays');
  531. }
  532. return $this;
  533. }
  534. /**
  535. * Use the CcShowDays relation CcShowDays object
  536. *
  537. * @see useQuery()
  538. *
  539. * @param string $relationAlias optional alias for the relation,
  540. * to be used as main alias in the secondary query
  541. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  542. *
  543. * @return CcShowDaysQuery A secondary query class using the current class as primary query
  544. */
  545. public function useCcShowDaysQuery($relationAlias = '', $joinType = Criteria::INNER_JOIN)
  546. {
  547. return $this
  548. ->joinCcShowDays($relationAlias, $joinType)
  549. ->useQuery($relationAlias ? $relationAlias : 'CcShowDays', 'CcShowDaysQuery');
  550. }
  551. /**
  552. * Filter the query by a related CcShowRebroadcast object
  553. *
  554. * @param CcShowRebroadcast $ccShowRebroadcast the related object to use as filter
  555. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  556. *
  557. * @return CcShowQuery The current query, for fluid interface
  558. */
  559. public function filterByCcShowRebroadcast($ccShowRebroadcast, $comparison = null)
  560. {
  561. return $this
  562. ->addUsingAlias(CcShowPeer::ID, $ccShowRebroadcast->getDbShowId(), $comparison);
  563. }
  564. /**
  565. * Adds a JOIN clause to the query using the CcShowRebroadcast relation
  566. *
  567. * @param string $relationAlias optional alias for the relation
  568. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  569. *
  570. * @return CcShowQuery The current query, for fluid interface
  571. */
  572. public function joinCcShowRebroadcast($relationAlias = '', $joinType = Criteria::INNER_JOIN)
  573. {
  574. $tableMap = $this->getTableMap();
  575. $relationMap = $tableMap->getRelation('CcShowRebroadcast');
  576. // create a ModelJoin object for this join
  577. $join = new ModelJoin();
  578. $join->setJoinType($joinType);
  579. $join->setRelationMap($relationMap, $this->useAliasInSQL ? $this->getModelAlias() : null, $relationAlias);
  580. if ($previousJoin = $this->getPreviousJoin()) {
  581. $join->setPreviousJoin($previousJoin);
  582. }
  583. // add the ModelJoin to the current object
  584. if($relationAlias) {
  585. $this->addAlias($relationAlias, $relationMap->getRightTable()->getName());
  586. $this->addJoinObject($join, $relationAlias);
  587. } else {
  588. $this->addJoinObject($join, 'CcShowRebroadcast');
  589. }
  590. return $this;
  591. }
  592. /**
  593. * Use the CcShowRebroadcast relation CcShowRebroadcast object
  594. *
  595. * @see useQuery()
  596. *
  597. * @param string $relationAlias optional alias for the relation,
  598. * to be used as main alias in the secondary query
  599. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  600. *
  601. * @return CcShowRebroadcastQuery A secondary query class using the current class as primary query
  602. */
  603. public function useCcShowRebroadcastQuery($relationAlias = '', $joinType = Criteria::INNER_JOIN)
  604. {
  605. return $this
  606. ->joinCcShowRebroadcast($relationAlias, $joinType)
  607. ->useQuery($relationAlias ? $relationAlias : 'CcShowRebroadcast', 'CcShowRebroadcastQuery');
  608. }
  609. /**
  610. * Filter the query by a related CcShowHosts object
  611. *
  612. * @param CcShowHosts $ccShowHosts the related object to use as filter
  613. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  614. *
  615. * @return CcShowQuery The current query, for fluid interface
  616. */
  617. public function filterByCcShowHosts($ccShowHosts, $comparison = null)
  618. {
  619. return $this
  620. ->addUsingAlias(CcShowPeer::ID, $ccShowHosts->getDbShow(), $comparison);
  621. }
  622. /**
  623. * Adds a JOIN clause to the query using the CcShowHosts relation
  624. *
  625. * @param string $relationAlias optional alias for the relation
  626. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  627. *
  628. * @return CcShowQuery The current query, for fluid interface
  629. */
  630. public function joinCcShowHosts($relationAlias = '', $joinType = Criteria::INNER_JOIN)
  631. {
  632. $tableMap = $this->getTableMap();
  633. $relationMap = $tableMap->getRelation('CcShowHosts');
  634. // create a ModelJoin object for this join
  635. $join = new ModelJoin();
  636. $join->setJoinType($joinType);
  637. $join->setRelationMap($relationMap, $this->useAliasInSQL ? $this->getModelAlias() : null, $relationAlias);
  638. if ($previousJoin = $this->getPreviousJoin()) {
  639. $join->setPreviousJoin($previousJoin);
  640. }
  641. // add the ModelJoin to the current object
  642. if($relationAlias) {
  643. $this->addAlias($relationAlias, $relationMap->getRightTable()->getName());
  644. $this->addJoinObject($join, $relationAlias);
  645. } else {
  646. $this->addJoinObject($join, 'CcShowHosts');
  647. }
  648. return $this;
  649. }
  650. /**
  651. * Use the CcShowHosts relation CcShowHosts object
  652. *
  653. * @see useQuery()
  654. *
  655. * @param string $relationAlias optional alias for the relation,
  656. * to be used as main alias in the secondary query
  657. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  658. *
  659. * @return CcShowHostsQuery A secondary query class using the current class as primary query
  660. */
  661. public function useCcShowHostsQuery($relationAlias = '', $joinType = Criteria::INNER_JOIN)
  662. {
  663. return $this
  664. ->joinCcShowHosts($relationAlias, $joinType)
  665. ->useQuery($relationAlias ? $relationAlias : 'CcShowHosts', 'CcShowHostsQuery');
  666. }
  667. /**
  668. * Exclude object from result
  669. *
  670. * @param CcShow $ccShow Object to remove from the list of results
  671. *
  672. * @return CcShowQuery The current query, for fluid interface
  673. */
  674. public function prune($ccShow = null)
  675. {
  676. if ($ccShow) {
  677. $this->addUsingAlias(CcShowPeer::ID, $ccShow->getDbId(), Criteria::NOT_EQUAL);
  678. }
  679. return $this;
  680. }
  681. } // BaseCcShowQuery