BaseCcFilesQuery.php 111 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623
  1. <?php
  2. /**
  3. * Base class that represents a query for the 'cc_files' table.
  4. *
  5. *
  6. *
  7. * @method CcFilesQuery orderByDbId($order = Criteria::ASC) Order by the id column
  8. * @method CcFilesQuery orderByDbName($order = Criteria::ASC) Order by the name column
  9. * @method CcFilesQuery orderByDbMime($order = Criteria::ASC) Order by the mime column
  10. * @method CcFilesQuery orderByDbFtype($order = Criteria::ASC) Order by the ftype column
  11. * @method CcFilesQuery orderByDbDirectory($order = Criteria::ASC) Order by the directory column
  12. * @method CcFilesQuery orderByDbFilepath($order = Criteria::ASC) Order by the filepath column
  13. * @method CcFilesQuery orderByDbState($order = Criteria::ASC) Order by the state column
  14. * @method CcFilesQuery orderByDbCurrentlyaccessing($order = Criteria::ASC) Order by the currentlyaccessing column
  15. * @method CcFilesQuery orderByDbEditedby($order = Criteria::ASC) Order by the editedby column
  16. * @method CcFilesQuery orderByDbMtime($order = Criteria::ASC) Order by the mtime column
  17. * @method CcFilesQuery orderByDbUtime($order = Criteria::ASC) Order by the utime column
  18. * @method CcFilesQuery orderByDbLPtime($order = Criteria::ASC) Order by the lptime column
  19. * @method CcFilesQuery orderByDbMd5($order = Criteria::ASC) Order by the md5 column
  20. * @method CcFilesQuery orderByDbTrackTitle($order = Criteria::ASC) Order by the track_title column
  21. * @method CcFilesQuery orderByDbArtistName($order = Criteria::ASC) Order by the artist_name column
  22. * @method CcFilesQuery orderByDbBitRate($order = Criteria::ASC) Order by the bit_rate column
  23. * @method CcFilesQuery orderByDbSampleRate($order = Criteria::ASC) Order by the sample_rate column
  24. * @method CcFilesQuery orderByDbFormat($order = Criteria::ASC) Order by the format column
  25. * @method CcFilesQuery orderByDbLength($order = Criteria::ASC) Order by the length column
  26. * @method CcFilesQuery orderByDbAlbumTitle($order = Criteria::ASC) Order by the album_title column
  27. * @method CcFilesQuery orderByDbGenre($order = Criteria::ASC) Order by the genre column
  28. * @method CcFilesQuery orderByDbComments($order = Criteria::ASC) Order by the comments column
  29. * @method CcFilesQuery orderByDbYear($order = Criteria::ASC) Order by the year column
  30. * @method CcFilesQuery orderByDbTrackNumber($order = Criteria::ASC) Order by the track_number column
  31. * @method CcFilesQuery orderByDbChannels($order = Criteria::ASC) Order by the channels column
  32. * @method CcFilesQuery orderByDbUrl($order = Criteria::ASC) Order by the url column
  33. * @method CcFilesQuery orderByDbBpm($order = Criteria::ASC) Order by the bpm column
  34. * @method CcFilesQuery orderByDbRating($order = Criteria::ASC) Order by the rating column
  35. * @method CcFilesQuery orderByDbEncodedBy($order = Criteria::ASC) Order by the encoded_by column
  36. * @method CcFilesQuery orderByDbDiscNumber($order = Criteria::ASC) Order by the disc_number column
  37. * @method CcFilesQuery orderByDbMood($order = Criteria::ASC) Order by the mood column
  38. * @method CcFilesQuery orderByDbLabel($order = Criteria::ASC) Order by the label column
  39. * @method CcFilesQuery orderByDbComposer($order = Criteria::ASC) Order by the composer column
  40. * @method CcFilesQuery orderByDbEncoder($order = Criteria::ASC) Order by the encoder column
  41. * @method CcFilesQuery orderByDbChecksum($order = Criteria::ASC) Order by the checksum column
  42. * @method CcFilesQuery orderByDbLyrics($order = Criteria::ASC) Order by the lyrics column
  43. * @method CcFilesQuery orderByDbOrchestra($order = Criteria::ASC) Order by the orchestra column
  44. * @method CcFilesQuery orderByDbConductor($order = Criteria::ASC) Order by the conductor column
  45. * @method CcFilesQuery orderByDbLyricist($order = Criteria::ASC) Order by the lyricist column
  46. * @method CcFilesQuery orderByDbOriginalLyricist($order = Criteria::ASC) Order by the original_lyricist column
  47. * @method CcFilesQuery orderByDbRadioStationName($order = Criteria::ASC) Order by the radio_station_name column
  48. * @method CcFilesQuery orderByDbInfoUrl($order = Criteria::ASC) Order by the info_url column
  49. * @method CcFilesQuery orderByDbArtistUrl($order = Criteria::ASC) Order by the artist_url column
  50. * @method CcFilesQuery orderByDbAudioSourceUrl($order = Criteria::ASC) Order by the audio_source_url column
  51. * @method CcFilesQuery orderByDbRadioStationUrl($order = Criteria::ASC) Order by the radio_station_url column
  52. * @method CcFilesQuery orderByDbBuyThisUrl($order = Criteria::ASC) Order by the buy_this_url column
  53. * @method CcFilesQuery orderByDbIsrcNumber($order = Criteria::ASC) Order by the isrc_number column
  54. * @method CcFilesQuery orderByDbCatalogNumber($order = Criteria::ASC) Order by the catalog_number column
  55. * @method CcFilesQuery orderByDbOriginalArtist($order = Criteria::ASC) Order by the original_artist column
  56. * @method CcFilesQuery orderByDbCopyright($order = Criteria::ASC) Order by the copyright column
  57. * @method CcFilesQuery orderByDbReportDatetime($order = Criteria::ASC) Order by the report_datetime column
  58. * @method CcFilesQuery orderByDbReportLocation($order = Criteria::ASC) Order by the report_location column
  59. * @method CcFilesQuery orderByDbReportOrganization($order = Criteria::ASC) Order by the report_organization column
  60. * @method CcFilesQuery orderByDbSubject($order = Criteria::ASC) Order by the subject column
  61. * @method CcFilesQuery orderByDbContributor($order = Criteria::ASC) Order by the contributor column
  62. * @method CcFilesQuery orderByDbLanguage($order = Criteria::ASC) Order by the language column
  63. * @method CcFilesQuery orderByDbFileExists($order = Criteria::ASC) Order by the file_exists column
  64. * @method CcFilesQuery orderByDbSoundcloudId($order = Criteria::ASC) Order by the soundcloud_id column
  65. * @method CcFilesQuery orderByDbSoundcloudErrorCode($order = Criteria::ASC) Order by the soundcloud_error_code column
  66. * @method CcFilesQuery orderByDbSoundcloudErrorMsg($order = Criteria::ASC) Order by the soundcloud_error_msg column
  67. * @method CcFilesQuery orderByDbSoundcloudLinkToFile($order = Criteria::ASC) Order by the soundcloud_link_to_file column
  68. * @method CcFilesQuery orderByDbSoundCloundUploadTime($order = Criteria::ASC) Order by the soundcloud_upload_time column
  69. * @method CcFilesQuery orderByDbReplayGain($order = Criteria::ASC) Order by the replay_gain column
  70. * @method CcFilesQuery orderByDbOwnerId($order = Criteria::ASC) Order by the owner_id column
  71. * @method CcFilesQuery orderByDbCuein($order = Criteria::ASC) Order by the cuein column
  72. * @method CcFilesQuery orderByDbCueout($order = Criteria::ASC) Order by the cueout column
  73. * @method CcFilesQuery orderByDbSilanCheck($order = Criteria::ASC) Order by the silan_check column
  74. * @method CcFilesQuery orderByDbHidden($order = Criteria::ASC) Order by the hidden column
  75. * @method CcFilesQuery orderByDbIsScheduled($order = Criteria::ASC) Order by the is_scheduled column
  76. * @method CcFilesQuery orderByDbIsPlaylist($order = Criteria::ASC) Order by the is_playlist column
  77. *
  78. * @method CcFilesQuery groupByDbId() Group by the id column
  79. * @method CcFilesQuery groupByDbName() Group by the name column
  80. * @method CcFilesQuery groupByDbMime() Group by the mime column
  81. * @method CcFilesQuery groupByDbFtype() Group by the ftype column
  82. * @method CcFilesQuery groupByDbDirectory() Group by the directory column
  83. * @method CcFilesQuery groupByDbFilepath() Group by the filepath column
  84. * @method CcFilesQuery groupByDbState() Group by the state column
  85. * @method CcFilesQuery groupByDbCurrentlyaccessing() Group by the currentlyaccessing column
  86. * @method CcFilesQuery groupByDbEditedby() Group by the editedby column
  87. * @method CcFilesQuery groupByDbMtime() Group by the mtime column
  88. * @method CcFilesQuery groupByDbUtime() Group by the utime column
  89. * @method CcFilesQuery groupByDbLPtime() Group by the lptime column
  90. * @method CcFilesQuery groupByDbMd5() Group by the md5 column
  91. * @method CcFilesQuery groupByDbTrackTitle() Group by the track_title column
  92. * @method CcFilesQuery groupByDbArtistName() Group by the artist_name column
  93. * @method CcFilesQuery groupByDbBitRate() Group by the bit_rate column
  94. * @method CcFilesQuery groupByDbSampleRate() Group by the sample_rate column
  95. * @method CcFilesQuery groupByDbFormat() Group by the format column
  96. * @method CcFilesQuery groupByDbLength() Group by the length column
  97. * @method CcFilesQuery groupByDbAlbumTitle() Group by the album_title column
  98. * @method CcFilesQuery groupByDbGenre() Group by the genre column
  99. * @method CcFilesQuery groupByDbComments() Group by the comments column
  100. * @method CcFilesQuery groupByDbYear() Group by the year column
  101. * @method CcFilesQuery groupByDbTrackNumber() Group by the track_number column
  102. * @method CcFilesQuery groupByDbChannels() Group by the channels column
  103. * @method CcFilesQuery groupByDbUrl() Group by the url column
  104. * @method CcFilesQuery groupByDbBpm() Group by the bpm column
  105. * @method CcFilesQuery groupByDbRating() Group by the rating column
  106. * @method CcFilesQuery groupByDbEncodedBy() Group by the encoded_by column
  107. * @method CcFilesQuery groupByDbDiscNumber() Group by the disc_number column
  108. * @method CcFilesQuery groupByDbMood() Group by the mood column
  109. * @method CcFilesQuery groupByDbLabel() Group by the label column
  110. * @method CcFilesQuery groupByDbComposer() Group by the composer column
  111. * @method CcFilesQuery groupByDbEncoder() Group by the encoder column
  112. * @method CcFilesQuery groupByDbChecksum() Group by the checksum column
  113. * @method CcFilesQuery groupByDbLyrics() Group by the lyrics column
  114. * @method CcFilesQuery groupByDbOrchestra() Group by the orchestra column
  115. * @method CcFilesQuery groupByDbConductor() Group by the conductor column
  116. * @method CcFilesQuery groupByDbLyricist() Group by the lyricist column
  117. * @method CcFilesQuery groupByDbOriginalLyricist() Group by the original_lyricist column
  118. * @method CcFilesQuery groupByDbRadioStationName() Group by the radio_station_name column
  119. * @method CcFilesQuery groupByDbInfoUrl() Group by the info_url column
  120. * @method CcFilesQuery groupByDbArtistUrl() Group by the artist_url column
  121. * @method CcFilesQuery groupByDbAudioSourceUrl() Group by the audio_source_url column
  122. * @method CcFilesQuery groupByDbRadioStationUrl() Group by the radio_station_url column
  123. * @method CcFilesQuery groupByDbBuyThisUrl() Group by the buy_this_url column
  124. * @method CcFilesQuery groupByDbIsrcNumber() Group by the isrc_number column
  125. * @method CcFilesQuery groupByDbCatalogNumber() Group by the catalog_number column
  126. * @method CcFilesQuery groupByDbOriginalArtist() Group by the original_artist column
  127. * @method CcFilesQuery groupByDbCopyright() Group by the copyright column
  128. * @method CcFilesQuery groupByDbReportDatetime() Group by the report_datetime column
  129. * @method CcFilesQuery groupByDbReportLocation() Group by the report_location column
  130. * @method CcFilesQuery groupByDbReportOrganization() Group by the report_organization column
  131. * @method CcFilesQuery groupByDbSubject() Group by the subject column
  132. * @method CcFilesQuery groupByDbContributor() Group by the contributor column
  133. * @method CcFilesQuery groupByDbLanguage() Group by the language column
  134. * @method CcFilesQuery groupByDbFileExists() Group by the file_exists column
  135. * @method CcFilesQuery groupByDbSoundcloudId() Group by the soundcloud_id column
  136. * @method CcFilesQuery groupByDbSoundcloudErrorCode() Group by the soundcloud_error_code column
  137. * @method CcFilesQuery groupByDbSoundcloudErrorMsg() Group by the soundcloud_error_msg column
  138. * @method CcFilesQuery groupByDbSoundcloudLinkToFile() Group by the soundcloud_link_to_file column
  139. * @method CcFilesQuery groupByDbSoundCloundUploadTime() Group by the soundcloud_upload_time column
  140. * @method CcFilesQuery groupByDbReplayGain() Group by the replay_gain column
  141. * @method CcFilesQuery groupByDbOwnerId() Group by the owner_id column
  142. * @method CcFilesQuery groupByDbCuein() Group by the cuein column
  143. * @method CcFilesQuery groupByDbCueout() Group by the cueout column
  144. * @method CcFilesQuery groupByDbSilanCheck() Group by the silan_check column
  145. * @method CcFilesQuery groupByDbHidden() Group by the hidden column
  146. * @method CcFilesQuery groupByDbIsScheduled() Group by the is_scheduled column
  147. * @method CcFilesQuery groupByDbIsPlaylist() Group by the is_playlist column
  148. *
  149. * @method CcFilesQuery leftJoin($relation) Adds a LEFT JOIN clause to the query
  150. * @method CcFilesQuery rightJoin($relation) Adds a RIGHT JOIN clause to the query
  151. * @method CcFilesQuery innerJoin($relation) Adds a INNER JOIN clause to the query
  152. *
  153. * @method CcFilesQuery leftJoinFkOwner($relationAlias = '') Adds a LEFT JOIN clause to the query using the FkOwner relation
  154. * @method CcFilesQuery rightJoinFkOwner($relationAlias = '') Adds a RIGHT JOIN clause to the query using the FkOwner relation
  155. * @method CcFilesQuery innerJoinFkOwner($relationAlias = '') Adds a INNER JOIN clause to the query using the FkOwner relation
  156. *
  157. * @method CcFilesQuery leftJoinCcSubjsRelatedByDbEditedby($relationAlias = '') Adds a LEFT JOIN clause to the query using the CcSubjsRelatedByDbEditedby relation
  158. * @method CcFilesQuery rightJoinCcSubjsRelatedByDbEditedby($relationAlias = '') Adds a RIGHT JOIN clause to the query using the CcSubjsRelatedByDbEditedby relation
  159. * @method CcFilesQuery innerJoinCcSubjsRelatedByDbEditedby($relationAlias = '') Adds a INNER JOIN clause to the query using the CcSubjsRelatedByDbEditedby relation
  160. *
  161. * @method CcFilesQuery leftJoinCcMusicDirs($relationAlias = '') Adds a LEFT JOIN clause to the query using the CcMusicDirs relation
  162. * @method CcFilesQuery rightJoinCcMusicDirs($relationAlias = '') Adds a RIGHT JOIN clause to the query using the CcMusicDirs relation
  163. * @method CcFilesQuery innerJoinCcMusicDirs($relationAlias = '') Adds a INNER JOIN clause to the query using the CcMusicDirs relation
  164. *
  165. * @method CcFilesQuery leftJoinCcShowInstances($relationAlias = '') Adds a LEFT JOIN clause to the query using the CcShowInstances relation
  166. * @method CcFilesQuery rightJoinCcShowInstances($relationAlias = '') Adds a RIGHT JOIN clause to the query using the CcShowInstances relation
  167. * @method CcFilesQuery innerJoinCcShowInstances($relationAlias = '') Adds a INNER JOIN clause to the query using the CcShowInstances relation
  168. *
  169. * @method CcFilesQuery leftJoinCcPlaylistcontents($relationAlias = '') Adds a LEFT JOIN clause to the query using the CcPlaylistcontents relation
  170. * @method CcFilesQuery rightJoinCcPlaylistcontents($relationAlias = '') Adds a RIGHT JOIN clause to the query using the CcPlaylistcontents relation
  171. * @method CcFilesQuery innerJoinCcPlaylistcontents($relationAlias = '') Adds a INNER JOIN clause to the query using the CcPlaylistcontents relation
  172. *
  173. * @method CcFilesQuery leftJoinCcBlockcontents($relationAlias = '') Adds a LEFT JOIN clause to the query using the CcBlockcontents relation
  174. * @method CcFilesQuery rightJoinCcBlockcontents($relationAlias = '') Adds a RIGHT JOIN clause to the query using the CcBlockcontents relation
  175. * @method CcFilesQuery innerJoinCcBlockcontents($relationAlias = '') Adds a INNER JOIN clause to the query using the CcBlockcontents relation
  176. *
  177. * @method CcFilesQuery leftJoinCcSchedule($relationAlias = '') Adds a LEFT JOIN clause to the query using the CcSchedule relation
  178. * @method CcFilesQuery rightJoinCcSchedule($relationAlias = '') Adds a RIGHT JOIN clause to the query using the CcSchedule relation
  179. * @method CcFilesQuery innerJoinCcSchedule($relationAlias = '') Adds a INNER JOIN clause to the query using the CcSchedule relation
  180. *
  181. * @method CcFilesQuery leftJoinCcPlayoutHistory($relationAlias = '') Adds a LEFT JOIN clause to the query using the CcPlayoutHistory relation
  182. * @method CcFilesQuery rightJoinCcPlayoutHistory($relationAlias = '') Adds a RIGHT JOIN clause to the query using the CcPlayoutHistory relation
  183. * @method CcFilesQuery innerJoinCcPlayoutHistory($relationAlias = '') Adds a INNER JOIN clause to the query using the CcPlayoutHistory relation
  184. *
  185. * @method CcFiles findOne(PropelPDO $con = null) Return the first CcFiles matching the query
  186. * @method CcFiles findOneOrCreate(PropelPDO $con = null) Return the first CcFiles matching the query, or a new CcFiles object populated from the query conditions when no match is found
  187. *
  188. * @method CcFiles findOneByDbId(int $id) Return the first CcFiles filtered by the id column
  189. * @method CcFiles findOneByDbName(string $name) Return the first CcFiles filtered by the name column
  190. * @method CcFiles findOneByDbMime(string $mime) Return the first CcFiles filtered by the mime column
  191. * @method CcFiles findOneByDbFtype(string $ftype) Return the first CcFiles filtered by the ftype column
  192. * @method CcFiles findOneByDbDirectory(int $directory) Return the first CcFiles filtered by the directory column
  193. * @method CcFiles findOneByDbFilepath(string $filepath) Return the first CcFiles filtered by the filepath column
  194. * @method CcFiles findOneByDbState(string $state) Return the first CcFiles filtered by the state column
  195. * @method CcFiles findOneByDbCurrentlyaccessing(int $currentlyaccessing) Return the first CcFiles filtered by the currentlyaccessing column
  196. * @method CcFiles findOneByDbEditedby(int $editedby) Return the first CcFiles filtered by the editedby column
  197. * @method CcFiles findOneByDbMtime(string $mtime) Return the first CcFiles filtered by the mtime column
  198. * @method CcFiles findOneByDbUtime(string $utime) Return the first CcFiles filtered by the utime column
  199. * @method CcFiles findOneByDbLPtime(string $lptime) Return the first CcFiles filtered by the lptime column
  200. * @method CcFiles findOneByDbMd5(string $md5) Return the first CcFiles filtered by the md5 column
  201. * @method CcFiles findOneByDbTrackTitle(string $track_title) Return the first CcFiles filtered by the track_title column
  202. * @method CcFiles findOneByDbArtistName(string $artist_name) Return the first CcFiles filtered by the artist_name column
  203. * @method CcFiles findOneByDbBitRate(int $bit_rate) Return the first CcFiles filtered by the bit_rate column
  204. * @method CcFiles findOneByDbSampleRate(int $sample_rate) Return the first CcFiles filtered by the sample_rate column
  205. * @method CcFiles findOneByDbFormat(string $format) Return the first CcFiles filtered by the format column
  206. * @method CcFiles findOneByDbLength(string $length) Return the first CcFiles filtered by the length column
  207. * @method CcFiles findOneByDbAlbumTitle(string $album_title) Return the first CcFiles filtered by the album_title column
  208. * @method CcFiles findOneByDbGenre(string $genre) Return the first CcFiles filtered by the genre column
  209. * @method CcFiles findOneByDbComments(string $comments) Return the first CcFiles filtered by the comments column
  210. * @method CcFiles findOneByDbYear(string $year) Return the first CcFiles filtered by the year column
  211. * @method CcFiles findOneByDbTrackNumber(int $track_number) Return the first CcFiles filtered by the track_number column
  212. * @method CcFiles findOneByDbChannels(int $channels) Return the first CcFiles filtered by the channels column
  213. * @method CcFiles findOneByDbUrl(string $url) Return the first CcFiles filtered by the url column
  214. * @method CcFiles findOneByDbBpm(int $bpm) Return the first CcFiles filtered by the bpm column
  215. * @method CcFiles findOneByDbRating(string $rating) Return the first CcFiles filtered by the rating column
  216. * @method CcFiles findOneByDbEncodedBy(string $encoded_by) Return the first CcFiles filtered by the encoded_by column
  217. * @method CcFiles findOneByDbDiscNumber(string $disc_number) Return the first CcFiles filtered by the disc_number column
  218. * @method CcFiles findOneByDbMood(string $mood) Return the first CcFiles filtered by the mood column
  219. * @method CcFiles findOneByDbLabel(string $label) Return the first CcFiles filtered by the label column
  220. * @method CcFiles findOneByDbComposer(string $composer) Return the first CcFiles filtered by the composer column
  221. * @method CcFiles findOneByDbEncoder(string $encoder) Return the first CcFiles filtered by the encoder column
  222. * @method CcFiles findOneByDbChecksum(string $checksum) Return the first CcFiles filtered by the checksum column
  223. * @method CcFiles findOneByDbLyrics(string $lyrics) Return the first CcFiles filtered by the lyrics column
  224. * @method CcFiles findOneByDbOrchestra(string $orchestra) Return the first CcFiles filtered by the orchestra column
  225. * @method CcFiles findOneByDbConductor(string $conductor) Return the first CcFiles filtered by the conductor column
  226. * @method CcFiles findOneByDbLyricist(string $lyricist) Return the first CcFiles filtered by the lyricist column
  227. * @method CcFiles findOneByDbOriginalLyricist(string $original_lyricist) Return the first CcFiles filtered by the original_lyricist column
  228. * @method CcFiles findOneByDbRadioStationName(string $radio_station_name) Return the first CcFiles filtered by the radio_station_name column
  229. * @method CcFiles findOneByDbInfoUrl(string $info_url) Return the first CcFiles filtered by the info_url column
  230. * @method CcFiles findOneByDbArtistUrl(string $artist_url) Return the first CcFiles filtered by the artist_url column
  231. * @method CcFiles findOneByDbAudioSourceUrl(string $audio_source_url) Return the first CcFiles filtered by the audio_source_url column
  232. * @method CcFiles findOneByDbRadioStationUrl(string $radio_station_url) Return the first CcFiles filtered by the radio_station_url column
  233. * @method CcFiles findOneByDbBuyThisUrl(string $buy_this_url) Return the first CcFiles filtered by the buy_this_url column
  234. * @method CcFiles findOneByDbIsrcNumber(string $isrc_number) Return the first CcFiles filtered by the isrc_number column
  235. * @method CcFiles findOneByDbCatalogNumber(string $catalog_number) Return the first CcFiles filtered by the catalog_number column
  236. * @method CcFiles findOneByDbOriginalArtist(string $original_artist) Return the first CcFiles filtered by the original_artist column
  237. * @method CcFiles findOneByDbCopyright(string $copyright) Return the first CcFiles filtered by the copyright column
  238. * @method CcFiles findOneByDbReportDatetime(string $report_datetime) Return the first CcFiles filtered by the report_datetime column
  239. * @method CcFiles findOneByDbReportLocation(string $report_location) Return the first CcFiles filtered by the report_location column
  240. * @method CcFiles findOneByDbReportOrganization(string $report_organization) Return the first CcFiles filtered by the report_organization column
  241. * @method CcFiles findOneByDbSubject(string $subject) Return the first CcFiles filtered by the subject column
  242. * @method CcFiles findOneByDbContributor(string $contributor) Return the first CcFiles filtered by the contributor column
  243. * @method CcFiles findOneByDbLanguage(string $language) Return the first CcFiles filtered by the language column
  244. * @method CcFiles findOneByDbFileExists(boolean $file_exists) Return the first CcFiles filtered by the file_exists column
  245. * @method CcFiles findOneByDbSoundcloudId(int $soundcloud_id) Return the first CcFiles filtered by the soundcloud_id column
  246. * @method CcFiles findOneByDbSoundcloudErrorCode(int $soundcloud_error_code) Return the first CcFiles filtered by the soundcloud_error_code column
  247. * @method CcFiles findOneByDbSoundcloudErrorMsg(string $soundcloud_error_msg) Return the first CcFiles filtered by the soundcloud_error_msg column
  248. * @method CcFiles findOneByDbSoundcloudLinkToFile(string $soundcloud_link_to_file) Return the first CcFiles filtered by the soundcloud_link_to_file column
  249. * @method CcFiles findOneByDbSoundCloundUploadTime(string $soundcloud_upload_time) Return the first CcFiles filtered by the soundcloud_upload_time column
  250. * @method CcFiles findOneByDbReplayGain(string $replay_gain) Return the first CcFiles filtered by the replay_gain column
  251. * @method CcFiles findOneByDbOwnerId(int $owner_id) Return the first CcFiles filtered by the owner_id column
  252. * @method CcFiles findOneByDbCuein(string $cuein) Return the first CcFiles filtered by the cuein column
  253. * @method CcFiles findOneByDbCueout(string $cueout) Return the first CcFiles filtered by the cueout column
  254. * @method CcFiles findOneByDbSilanCheck(boolean $silan_check) Return the first CcFiles filtered by the silan_check column
  255. * @method CcFiles findOneByDbHidden(boolean $hidden) Return the first CcFiles filtered by the hidden column
  256. * @method CcFiles findOneByDbIsScheduled(boolean $is_scheduled) Return the first CcFiles filtered by the is_scheduled column
  257. * @method CcFiles findOneByDbIsPlaylist(boolean $is_playlist) Return the first CcFiles filtered by the is_playlist column
  258. *
  259. * @method array findByDbId(int $id) Return CcFiles objects filtered by the id column
  260. * @method array findByDbName(string $name) Return CcFiles objects filtered by the name column
  261. * @method array findByDbMime(string $mime) Return CcFiles objects filtered by the mime column
  262. * @method array findByDbFtype(string $ftype) Return CcFiles objects filtered by the ftype column
  263. * @method array findByDbDirectory(int $directory) Return CcFiles objects filtered by the directory column
  264. * @method array findByDbFilepath(string $filepath) Return CcFiles objects filtered by the filepath column
  265. * @method array findByDbState(string $state) Return CcFiles objects filtered by the state column
  266. * @method array findByDbCurrentlyaccessing(int $currentlyaccessing) Return CcFiles objects filtered by the currentlyaccessing column
  267. * @method array findByDbEditedby(int $editedby) Return CcFiles objects filtered by the editedby column
  268. * @method array findByDbMtime(string $mtime) Return CcFiles objects filtered by the mtime column
  269. * @method array findByDbUtime(string $utime) Return CcFiles objects filtered by the utime column
  270. * @method array findByDbLPtime(string $lptime) Return CcFiles objects filtered by the lptime column
  271. * @method array findByDbMd5(string $md5) Return CcFiles objects filtered by the md5 column
  272. * @method array findByDbTrackTitle(string $track_title) Return CcFiles objects filtered by the track_title column
  273. * @method array findByDbArtistName(string $artist_name) Return CcFiles objects filtered by the artist_name column
  274. * @method array findByDbBitRate(int $bit_rate) Return CcFiles objects filtered by the bit_rate column
  275. * @method array findByDbSampleRate(int $sample_rate) Return CcFiles objects filtered by the sample_rate column
  276. * @method array findByDbFormat(string $format) Return CcFiles objects filtered by the format column
  277. * @method array findByDbLength(string $length) Return CcFiles objects filtered by the length column
  278. * @method array findByDbAlbumTitle(string $album_title) Return CcFiles objects filtered by the album_title column
  279. * @method array findByDbGenre(string $genre) Return CcFiles objects filtered by the genre column
  280. * @method array findByDbComments(string $comments) Return CcFiles objects filtered by the comments column
  281. * @method array findByDbYear(string $year) Return CcFiles objects filtered by the year column
  282. * @method array findByDbTrackNumber(int $track_number) Return CcFiles objects filtered by the track_number column
  283. * @method array findByDbChannels(int $channels) Return CcFiles objects filtered by the channels column
  284. * @method array findByDbUrl(string $url) Return CcFiles objects filtered by the url column
  285. * @method array findByDbBpm(int $bpm) Return CcFiles objects filtered by the bpm column
  286. * @method array findByDbRating(string $rating) Return CcFiles objects filtered by the rating column
  287. * @method array findByDbEncodedBy(string $encoded_by) Return CcFiles objects filtered by the encoded_by column
  288. * @method array findByDbDiscNumber(string $disc_number) Return CcFiles objects filtered by the disc_number column
  289. * @method array findByDbMood(string $mood) Return CcFiles objects filtered by the mood column
  290. * @method array findByDbLabel(string $label) Return CcFiles objects filtered by the label column
  291. * @method array findByDbComposer(string $composer) Return CcFiles objects filtered by the composer column
  292. * @method array findByDbEncoder(string $encoder) Return CcFiles objects filtered by the encoder column
  293. * @method array findByDbChecksum(string $checksum) Return CcFiles objects filtered by the checksum column
  294. * @method array findByDbLyrics(string $lyrics) Return CcFiles objects filtered by the lyrics column
  295. * @method array findByDbOrchestra(string $orchestra) Return CcFiles objects filtered by the orchestra column
  296. * @method array findByDbConductor(string $conductor) Return CcFiles objects filtered by the conductor column
  297. * @method array findByDbLyricist(string $lyricist) Return CcFiles objects filtered by the lyricist column
  298. * @method array findByDbOriginalLyricist(string $original_lyricist) Return CcFiles objects filtered by the original_lyricist column
  299. * @method array findByDbRadioStationName(string $radio_station_name) Return CcFiles objects filtered by the radio_station_name column
  300. * @method array findByDbInfoUrl(string $info_url) Return CcFiles objects filtered by the info_url column
  301. * @method array findByDbArtistUrl(string $artist_url) Return CcFiles objects filtered by the artist_url column
  302. * @method array findByDbAudioSourceUrl(string $audio_source_url) Return CcFiles objects filtered by the audio_source_url column
  303. * @method array findByDbRadioStationUrl(string $radio_station_url) Return CcFiles objects filtered by the radio_station_url column
  304. * @method array findByDbBuyThisUrl(string $buy_this_url) Return CcFiles objects filtered by the buy_this_url column
  305. * @method array findByDbIsrcNumber(string $isrc_number) Return CcFiles objects filtered by the isrc_number column
  306. * @method array findByDbCatalogNumber(string $catalog_number) Return CcFiles objects filtered by the catalog_number column
  307. * @method array findByDbOriginalArtist(string $original_artist) Return CcFiles objects filtered by the original_artist column
  308. * @method array findByDbCopyright(string $copyright) Return CcFiles objects filtered by the copyright column
  309. * @method array findByDbReportDatetime(string $report_datetime) Return CcFiles objects filtered by the report_datetime column
  310. * @method array findByDbReportLocation(string $report_location) Return CcFiles objects filtered by the report_location column
  311. * @method array findByDbReportOrganization(string $report_organization) Return CcFiles objects filtered by the report_organization column
  312. * @method array findByDbSubject(string $subject) Return CcFiles objects filtered by the subject column
  313. * @method array findByDbContributor(string $contributor) Return CcFiles objects filtered by the contributor column
  314. * @method array findByDbLanguage(string $language) Return CcFiles objects filtered by the language column
  315. * @method array findByDbFileExists(boolean $file_exists) Return CcFiles objects filtered by the file_exists column
  316. * @method array findByDbSoundcloudId(int $soundcloud_id) Return CcFiles objects filtered by the soundcloud_id column
  317. * @method array findByDbSoundcloudErrorCode(int $soundcloud_error_code) Return CcFiles objects filtered by the soundcloud_error_code column
  318. * @method array findByDbSoundcloudErrorMsg(string $soundcloud_error_msg) Return CcFiles objects filtered by the soundcloud_error_msg column
  319. * @method array findByDbSoundcloudLinkToFile(string $soundcloud_link_to_file) Return CcFiles objects filtered by the soundcloud_link_to_file column
  320. * @method array findByDbSoundCloundUploadTime(string $soundcloud_upload_time) Return CcFiles objects filtered by the soundcloud_upload_time column
  321. * @method array findByDbReplayGain(string $replay_gain) Return CcFiles objects filtered by the replay_gain column
  322. * @method array findByDbOwnerId(int $owner_id) Return CcFiles objects filtered by the owner_id column
  323. * @method array findByDbCuein(string $cuein) Return CcFiles objects filtered by the cuein column
  324. * @method array findByDbCueout(string $cueout) Return CcFiles objects filtered by the cueout column
  325. * @method array findByDbSilanCheck(boolean $silan_check) Return CcFiles objects filtered by the silan_check column
  326. * @method array findByDbHidden(boolean $hidden) Return CcFiles objects filtered by the hidden column
  327. * @method array findByDbIsScheduled(boolean $is_scheduled) Return CcFiles objects filtered by the is_scheduled column
  328. * @method array findByDbIsPlaylist(boolean $is_playlist) Return CcFiles objects filtered by the is_playlist column
  329. *
  330. * @package propel.generator.airtime.om
  331. */
  332. abstract class BaseCcFilesQuery extends ModelCriteria
  333. {
  334. /**
  335. * Initializes internal state of BaseCcFilesQuery object.
  336. *
  337. * @param string $dbName The dabase name
  338. * @param string $modelName The phpName of a model, e.g. 'Book'
  339. * @param string $modelAlias The alias for the model in this query, e.g. 'b'
  340. */
  341. public function __construct($dbName = 'airtime', $modelName = 'CcFiles', $modelAlias = null)
  342. {
  343. parent::__construct($dbName, $modelName, $modelAlias);
  344. }
  345. /**
  346. * Returns a new CcFilesQuery object.
  347. *
  348. * @param string $modelAlias The alias of a model in the query
  349. * @param Criteria $criteria Optional Criteria to build the query from
  350. *
  351. * @return CcFilesQuery
  352. */
  353. public static function create($modelAlias = null, $criteria = null)
  354. {
  355. if ($criteria instanceof CcFilesQuery) {
  356. return $criteria;
  357. }
  358. $query = new CcFilesQuery();
  359. if (null !== $modelAlias) {
  360. $query->setModelAlias($modelAlias);
  361. }
  362. if ($criteria instanceof Criteria) {
  363. $query->mergeWith($criteria);
  364. }
  365. return $query;
  366. }
  367. /**
  368. * Find object by primary key
  369. * Use instance pooling to avoid a database query if the object exists
  370. * <code>
  371. * $obj = $c->findPk(12, $con);
  372. * </code>
  373. * @param mixed $key Primary key to use for the query
  374. * @param PropelPDO $con an optional connection object
  375. *
  376. * @return CcFiles|array|mixed the result, formatted by the current formatter
  377. */
  378. public function findPk($key, $con = null)
  379. {
  380. if ((null !== ($obj = CcFilesPeer::getInstanceFromPool((string) $key))) && $this->getFormatter()->isObjectFormatter()) {
  381. // the object is alredy in the instance pool
  382. return $obj;
  383. } else {
  384. // the object has not been requested yet, or the formatter is not an object formatter
  385. $criteria = $this->isKeepQuery() ? clone $this : $this;
  386. $stmt = $criteria
  387. ->filterByPrimaryKey($key)
  388. ->getSelectStatement($con);
  389. return $criteria->getFormatter()->init($criteria)->formatOne($stmt);
  390. }
  391. }
  392. /**
  393. * Find objects by primary key
  394. * <code>
  395. * $objs = $c->findPks(array(12, 56, 832), $con);
  396. * </code>
  397. * @param array $keys Primary keys to use for the query
  398. * @param PropelPDO $con an optional connection object
  399. *
  400. * @return PropelObjectCollection|array|mixed the list of results, formatted by the current formatter
  401. */
  402. public function findPks($keys, $con = null)
  403. {
  404. $criteria = $this->isKeepQuery() ? clone $this : $this;
  405. return $this
  406. ->filterByPrimaryKeys($keys)
  407. ->find($con);
  408. }
  409. /**
  410. * Filter the query by primary key
  411. *
  412. * @param mixed $key Primary key to use for the query
  413. *
  414. * @return CcFilesQuery The current query, for fluid interface
  415. */
  416. public function filterByPrimaryKey($key)
  417. {
  418. return $this->addUsingAlias(CcFilesPeer::ID, $key, Criteria::EQUAL);
  419. }
  420. /**
  421. * Filter the query by a list of primary keys
  422. *
  423. * @param array $keys The list of primary key to use for the query
  424. *
  425. * @return CcFilesQuery The current query, for fluid interface
  426. */
  427. public function filterByPrimaryKeys($keys)
  428. {
  429. return $this->addUsingAlias(CcFilesPeer::ID, $keys, Criteria::IN);
  430. }
  431. /**
  432. * Filter the query on the id column
  433. *
  434. * @param int|array $dbId The value to use as filter.
  435. * Accepts an associative array('min' => $minValue, 'max' => $maxValue)
  436. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  437. *
  438. * @return CcFilesQuery The current query, for fluid interface
  439. */
  440. public function filterByDbId($dbId = null, $comparison = null)
  441. {
  442. if (is_array($dbId) && null === $comparison) {
  443. $comparison = Criteria::IN;
  444. }
  445. return $this->addUsingAlias(CcFilesPeer::ID, $dbId, $comparison);
  446. }
  447. /**
  448. * Filter the query on the name column
  449. *
  450. * @param string $dbName The value to use as filter.
  451. * Accepts wildcards (* and % trigger a LIKE)
  452. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  453. *
  454. * @return CcFilesQuery The current query, for fluid interface
  455. */
  456. public function filterByDbName($dbName = null, $comparison = null)
  457. {
  458. if (null === $comparison) {
  459. if (is_array($dbName)) {
  460. $comparison = Criteria::IN;
  461. } elseif (preg_match('/[\%\*]/', $dbName)) {
  462. $dbName = str_replace('*', '%', $dbName);
  463. $comparison = Criteria::LIKE;
  464. }
  465. }
  466. return $this->addUsingAlias(CcFilesPeer::NAME, $dbName, $comparison);
  467. }
  468. /**
  469. * Filter the query on the mime column
  470. *
  471. * @param string $dbMime The value to use as filter.
  472. * Accepts wildcards (* and % trigger a LIKE)
  473. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  474. *
  475. * @return CcFilesQuery The current query, for fluid interface
  476. */
  477. public function filterByDbMime($dbMime = null, $comparison = null)
  478. {
  479. if (null === $comparison) {
  480. if (is_array($dbMime)) {
  481. $comparison = Criteria::IN;
  482. } elseif (preg_match('/[\%\*]/', $dbMime)) {
  483. $dbMime = str_replace('*', '%', $dbMime);
  484. $comparison = Criteria::LIKE;
  485. }
  486. }
  487. return $this->addUsingAlias(CcFilesPeer::MIME, $dbMime, $comparison);
  488. }
  489. /**
  490. * Filter the query on the ftype column
  491. *
  492. * @param string $dbFtype The value to use as filter.
  493. * Accepts wildcards (* and % trigger a LIKE)
  494. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  495. *
  496. * @return CcFilesQuery The current query, for fluid interface
  497. */
  498. public function filterByDbFtype($dbFtype = null, $comparison = null)
  499. {
  500. if (null === $comparison) {
  501. if (is_array($dbFtype)) {
  502. $comparison = Criteria::IN;
  503. } elseif (preg_match('/[\%\*]/', $dbFtype)) {
  504. $dbFtype = str_replace('*', '%', $dbFtype);
  505. $comparison = Criteria::LIKE;
  506. }
  507. }
  508. return $this->addUsingAlias(CcFilesPeer::FTYPE, $dbFtype, $comparison);
  509. }
  510. /**
  511. * Filter the query on the directory column
  512. *
  513. * @param int|array $dbDirectory The value to use as filter.
  514. * Accepts an associative array('min' => $minValue, 'max' => $maxValue)
  515. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  516. *
  517. * @return CcFilesQuery The current query, for fluid interface
  518. */
  519. public function filterByDbDirectory($dbDirectory = null, $comparison = null)
  520. {
  521. if (is_array($dbDirectory)) {
  522. $useMinMax = false;
  523. if (isset($dbDirectory['min'])) {
  524. $this->addUsingAlias(CcFilesPeer::DIRECTORY, $dbDirectory['min'], Criteria::GREATER_EQUAL);
  525. $useMinMax = true;
  526. }
  527. if (isset($dbDirectory['max'])) {
  528. $this->addUsingAlias(CcFilesPeer::DIRECTORY, $dbDirectory['max'], Criteria::LESS_EQUAL);
  529. $useMinMax = true;
  530. }
  531. if ($useMinMax) {
  532. return $this;
  533. }
  534. if (null === $comparison) {
  535. $comparison = Criteria::IN;
  536. }
  537. }
  538. return $this->addUsingAlias(CcFilesPeer::DIRECTORY, $dbDirectory, $comparison);
  539. }
  540. /**
  541. * Filter the query on the filepath column
  542. *
  543. * @param string $dbFilepath The value to use as filter.
  544. * Accepts wildcards (* and % trigger a LIKE)
  545. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  546. *
  547. * @return CcFilesQuery The current query, for fluid interface
  548. */
  549. public function filterByDbFilepath($dbFilepath = null, $comparison = null)
  550. {
  551. if (null === $comparison) {
  552. if (is_array($dbFilepath)) {
  553. $comparison = Criteria::IN;
  554. } elseif (preg_match('/[\%\*]/', $dbFilepath)) {
  555. $dbFilepath = str_replace('*', '%', $dbFilepath);
  556. $comparison = Criteria::LIKE;
  557. }
  558. }
  559. return $this->addUsingAlias(CcFilesPeer::FILEPATH, $dbFilepath, $comparison);
  560. }
  561. /**
  562. * Filter the query on the state column
  563. *
  564. * @param string $dbState The value to use as filter.
  565. * Accepts wildcards (* and % trigger a LIKE)
  566. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  567. *
  568. * @return CcFilesQuery The current query, for fluid interface
  569. */
  570. public function filterByDbState($dbState = null, $comparison = null)
  571. {
  572. if (null === $comparison) {
  573. if (is_array($dbState)) {
  574. $comparison = Criteria::IN;
  575. } elseif (preg_match('/[\%\*]/', $dbState)) {
  576. $dbState = str_replace('*', '%', $dbState);
  577. $comparison = Criteria::LIKE;
  578. }
  579. }
  580. return $this->addUsingAlias(CcFilesPeer::STATE, $dbState, $comparison);
  581. }
  582. /**
  583. * Filter the query on the currentlyaccessing column
  584. *
  585. * @param int|array $dbCurrentlyaccessing The value to use as filter.
  586. * Accepts an associative array('min' => $minValue, 'max' => $maxValue)
  587. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  588. *
  589. * @return CcFilesQuery The current query, for fluid interface
  590. */
  591. public function filterByDbCurrentlyaccessing($dbCurrentlyaccessing = null, $comparison = null)
  592. {
  593. if (is_array($dbCurrentlyaccessing)) {
  594. $useMinMax = false;
  595. if (isset($dbCurrentlyaccessing['min'])) {
  596. $this->addUsingAlias(CcFilesPeer::CURRENTLYACCESSING, $dbCurrentlyaccessing['min'], Criteria::GREATER_EQUAL);
  597. $useMinMax = true;
  598. }
  599. if (isset($dbCurrentlyaccessing['max'])) {
  600. $this->addUsingAlias(CcFilesPeer::CURRENTLYACCESSING, $dbCurrentlyaccessing['max'], Criteria::LESS_EQUAL);
  601. $useMinMax = true;
  602. }
  603. if ($useMinMax) {
  604. return $this;
  605. }
  606. if (null === $comparison) {
  607. $comparison = Criteria::IN;
  608. }
  609. }
  610. return $this->addUsingAlias(CcFilesPeer::CURRENTLYACCESSING, $dbCurrentlyaccessing, $comparison);
  611. }
  612. /**
  613. * Filter the query on the editedby column
  614. *
  615. * @param int|array $dbEditedby The value to use as filter.
  616. * Accepts an associative array('min' => $minValue, 'max' => $maxValue)
  617. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  618. *
  619. * @return CcFilesQuery The current query, for fluid interface
  620. */
  621. public function filterByDbEditedby($dbEditedby = null, $comparison = null)
  622. {
  623. if (is_array($dbEditedby)) {
  624. $useMinMax = false;
  625. if (isset($dbEditedby['min'])) {
  626. $this->addUsingAlias(CcFilesPeer::EDITEDBY, $dbEditedby['min'], Criteria::GREATER_EQUAL);
  627. $useMinMax = true;
  628. }
  629. if (isset($dbEditedby['max'])) {
  630. $this->addUsingAlias(CcFilesPeer::EDITEDBY, $dbEditedby['max'], Criteria::LESS_EQUAL);
  631. $useMinMax = true;
  632. }
  633. if ($useMinMax) {
  634. return $this;
  635. }
  636. if (null === $comparison) {
  637. $comparison = Criteria::IN;
  638. }
  639. }
  640. return $this->addUsingAlias(CcFilesPeer::EDITEDBY, $dbEditedby, $comparison);
  641. }
  642. /**
  643. * Filter the query on the mtime column
  644. *
  645. * @param string|array $dbMtime The value to use as filter.
  646. * Accepts an associative array('min' => $minValue, 'max' => $maxValue)
  647. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  648. *
  649. * @return CcFilesQuery The current query, for fluid interface
  650. */
  651. public function filterByDbMtime($dbMtime = null, $comparison = null)
  652. {
  653. if (is_array($dbMtime)) {
  654. $useMinMax = false;
  655. if (isset($dbMtime['min'])) {
  656. $this->addUsingAlias(CcFilesPeer::MTIME, $dbMtime['min'], Criteria::GREATER_EQUAL);
  657. $useMinMax = true;
  658. }
  659. if (isset($dbMtime['max'])) {
  660. $this->addUsingAlias(CcFilesPeer::MTIME, $dbMtime['max'], Criteria::LESS_EQUAL);
  661. $useMinMax = true;
  662. }
  663. if ($useMinMax) {
  664. return $this;
  665. }
  666. if (null === $comparison) {
  667. $comparison = Criteria::IN;
  668. }
  669. }
  670. return $this->addUsingAlias(CcFilesPeer::MTIME, $dbMtime, $comparison);
  671. }
  672. /**
  673. * Filter the query on the utime column
  674. *
  675. * @param string|array $dbUtime The value to use as filter.
  676. * Accepts an associative array('min' => $minValue, 'max' => $maxValue)
  677. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  678. *
  679. * @return CcFilesQuery The current query, for fluid interface
  680. */
  681. public function filterByDbUtime($dbUtime = null, $comparison = null)
  682. {
  683. if (is_array($dbUtime)) {
  684. $useMinMax = false;
  685. if (isset($dbUtime['min'])) {
  686. $this->addUsingAlias(CcFilesPeer::UTIME, $dbUtime['min'], Criteria::GREATER_EQUAL);
  687. $useMinMax = true;
  688. }
  689. if (isset($dbUtime['max'])) {
  690. $this->addUsingAlias(CcFilesPeer::UTIME, $dbUtime['max'], Criteria::LESS_EQUAL);
  691. $useMinMax = true;
  692. }
  693. if ($useMinMax) {
  694. return $this;
  695. }
  696. if (null === $comparison) {
  697. $comparison = Criteria::IN;
  698. }
  699. }
  700. return $this->addUsingAlias(CcFilesPeer::UTIME, $dbUtime, $comparison);
  701. }
  702. /**
  703. * Filter the query on the lptime column
  704. *
  705. * @param string|array $dbLPtime The value to use as filter.
  706. * Accepts an associative array('min' => $minValue, 'max' => $maxValue)
  707. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  708. *
  709. * @return CcFilesQuery The current query, for fluid interface
  710. */
  711. public function filterByDbLPtime($dbLPtime = null, $comparison = null)
  712. {
  713. if (is_array($dbLPtime)) {
  714. $useMinMax = false;
  715. if (isset($dbLPtime['min'])) {
  716. $this->addUsingAlias(CcFilesPeer::LPTIME, $dbLPtime['min'], Criteria::GREATER_EQUAL);
  717. $useMinMax = true;
  718. }
  719. if (isset($dbLPtime['max'])) {
  720. $this->addUsingAlias(CcFilesPeer::LPTIME, $dbLPtime['max'], Criteria::LESS_EQUAL);
  721. $useMinMax = true;
  722. }
  723. if ($useMinMax) {
  724. return $this;
  725. }
  726. if (null === $comparison) {
  727. $comparison = Criteria::IN;
  728. }
  729. }
  730. return $this->addUsingAlias(CcFilesPeer::LPTIME, $dbLPtime, $comparison);
  731. }
  732. /**
  733. * Filter the query on the md5 column
  734. *
  735. * @param string $dbMd5 The value to use as filter.
  736. * Accepts wildcards (* and % trigger a LIKE)
  737. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  738. *
  739. * @return CcFilesQuery The current query, for fluid interface
  740. */
  741. public function filterByDbMd5($dbMd5 = null, $comparison = null)
  742. {
  743. if (null === $comparison) {
  744. if (is_array($dbMd5)) {
  745. $comparison = Criteria::IN;
  746. } elseif (preg_match('/[\%\*]/', $dbMd5)) {
  747. $dbMd5 = str_replace('*', '%', $dbMd5);
  748. $comparison = Criteria::LIKE;
  749. }
  750. }
  751. return $this->addUsingAlias(CcFilesPeer::MD5, $dbMd5, $comparison);
  752. }
  753. /**
  754. * Filter the query on the track_title column
  755. *
  756. * @param string $dbTrackTitle The value to use as filter.
  757. * Accepts wildcards (* and % trigger a LIKE)
  758. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  759. *
  760. * @return CcFilesQuery The current query, for fluid interface
  761. */
  762. public function filterByDbTrackTitle($dbTrackTitle = null, $comparison = null)
  763. {
  764. if (null === $comparison) {
  765. if (is_array($dbTrackTitle)) {
  766. $comparison = Criteria::IN;
  767. } elseif (preg_match('/[\%\*]/', $dbTrackTitle)) {
  768. $dbTrackTitle = str_replace('*', '%', $dbTrackTitle);
  769. $comparison = Criteria::LIKE;
  770. }
  771. }
  772. return $this->addUsingAlias(CcFilesPeer::TRACK_TITLE, $dbTrackTitle, $comparison);
  773. }
  774. /**
  775. * Filter the query on the artist_name column
  776. *
  777. * @param string $dbArtistName The value to use as filter.
  778. * Accepts wildcards (* and % trigger a LIKE)
  779. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  780. *
  781. * @return CcFilesQuery The current query, for fluid interface
  782. */
  783. public function filterByDbArtistName($dbArtistName = null, $comparison = null)
  784. {
  785. if (null === $comparison) {
  786. if (is_array($dbArtistName)) {
  787. $comparison = Criteria::IN;
  788. } elseif (preg_match('/[\%\*]/', $dbArtistName)) {
  789. $dbArtistName = str_replace('*', '%', $dbArtistName);
  790. $comparison = Criteria::LIKE;
  791. }
  792. }
  793. return $this->addUsingAlias(CcFilesPeer::ARTIST_NAME, $dbArtistName, $comparison);
  794. }
  795. /**
  796. * Filter the query on the bit_rate column
  797. *
  798. * @param int|array $dbBitRate The value to use as filter.
  799. * Accepts an associative array('min' => $minValue, 'max' => $maxValue)
  800. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  801. *
  802. * @return CcFilesQuery The current query, for fluid interface
  803. */
  804. public function filterByDbBitRate($dbBitRate = null, $comparison = null)
  805. {
  806. if (is_array($dbBitRate)) {
  807. $useMinMax = false;
  808. if (isset($dbBitRate['min'])) {
  809. $this->addUsingAlias(CcFilesPeer::BIT_RATE, $dbBitRate['min'], Criteria::GREATER_EQUAL);
  810. $useMinMax = true;
  811. }
  812. if (isset($dbBitRate['max'])) {
  813. $this->addUsingAlias(CcFilesPeer::BIT_RATE, $dbBitRate['max'], Criteria::LESS_EQUAL);
  814. $useMinMax = true;
  815. }
  816. if ($useMinMax) {
  817. return $this;
  818. }
  819. if (null === $comparison) {
  820. $comparison = Criteria::IN;
  821. }
  822. }
  823. return $this->addUsingAlias(CcFilesPeer::BIT_RATE, $dbBitRate, $comparison);
  824. }
  825. /**
  826. * Filter the query on the sample_rate column
  827. *
  828. * @param int|array $dbSampleRate The value to use as filter.
  829. * Accepts an associative array('min' => $minValue, 'max' => $maxValue)
  830. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  831. *
  832. * @return CcFilesQuery The current query, for fluid interface
  833. */
  834. public function filterByDbSampleRate($dbSampleRate = null, $comparison = null)
  835. {
  836. if (is_array($dbSampleRate)) {
  837. $useMinMax = false;
  838. if (isset($dbSampleRate['min'])) {
  839. $this->addUsingAlias(CcFilesPeer::SAMPLE_RATE, $dbSampleRate['min'], Criteria::GREATER_EQUAL);
  840. $useMinMax = true;
  841. }
  842. if (isset($dbSampleRate['max'])) {
  843. $this->addUsingAlias(CcFilesPeer::SAMPLE_RATE, $dbSampleRate['max'], Criteria::LESS_EQUAL);
  844. $useMinMax = true;
  845. }
  846. if ($useMinMax) {
  847. return $this;
  848. }
  849. if (null === $comparison) {
  850. $comparison = Criteria::IN;
  851. }
  852. }
  853. return $this->addUsingAlias(CcFilesPeer::SAMPLE_RATE, $dbSampleRate, $comparison);
  854. }
  855. /**
  856. * Filter the query on the format column
  857. *
  858. * @param string $dbFormat The value to use as filter.
  859. * Accepts wildcards (* and % trigger a LIKE)
  860. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  861. *
  862. * @return CcFilesQuery The current query, for fluid interface
  863. */
  864. public function filterByDbFormat($dbFormat = null, $comparison = null)
  865. {
  866. if (null === $comparison) {
  867. if (is_array($dbFormat)) {
  868. $comparison = Criteria::IN;
  869. } elseif (preg_match('/[\%\*]/', $dbFormat)) {
  870. $dbFormat = str_replace('*', '%', $dbFormat);
  871. $comparison = Criteria::LIKE;
  872. }
  873. }
  874. return $this->addUsingAlias(CcFilesPeer::FORMAT, $dbFormat, $comparison);
  875. }
  876. /**
  877. * Filter the query on the length column
  878. *
  879. * @param string $dbLength The value to use as filter.
  880. * Accepts wildcards (* and % trigger a LIKE)
  881. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  882. *
  883. * @return CcFilesQuery The current query, for fluid interface
  884. */
  885. public function filterByDbLength($dbLength = null, $comparison = null)
  886. {
  887. if (null === $comparison) {
  888. if (is_array($dbLength)) {
  889. $comparison = Criteria::IN;
  890. } elseif (preg_match('/[\%\*]/', $dbLength)) {
  891. $dbLength = str_replace('*', '%', $dbLength);
  892. $comparison = Criteria::LIKE;
  893. }
  894. }
  895. return $this->addUsingAlias(CcFilesPeer::LENGTH, $dbLength, $comparison);
  896. }
  897. /**
  898. * Filter the query on the album_title column
  899. *
  900. * @param string $dbAlbumTitle The value to use as filter.
  901. * Accepts wildcards (* and % trigger a LIKE)
  902. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  903. *
  904. * @return CcFilesQuery The current query, for fluid interface
  905. */
  906. public function filterByDbAlbumTitle($dbAlbumTitle = null, $comparison = null)
  907. {
  908. if (null === $comparison) {
  909. if (is_array($dbAlbumTitle)) {
  910. $comparison = Criteria::IN;
  911. } elseif (preg_match('/[\%\*]/', $dbAlbumTitle)) {
  912. $dbAlbumTitle = str_replace('*', '%', $dbAlbumTitle);
  913. $comparison = Criteria::LIKE;
  914. }
  915. }
  916. return $this->addUsingAlias(CcFilesPeer::ALBUM_TITLE, $dbAlbumTitle, $comparison);
  917. }
  918. /**
  919. * Filter the query on the genre column
  920. *
  921. * @param string $dbGenre The value to use as filter.
  922. * Accepts wildcards (* and % trigger a LIKE)
  923. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  924. *
  925. * @return CcFilesQuery The current query, for fluid interface
  926. */
  927. public function filterByDbGenre($dbGenre = null, $comparison = null)
  928. {
  929. if (null === $comparison) {
  930. if (is_array($dbGenre)) {
  931. $comparison = Criteria::IN;
  932. } elseif (preg_match('/[\%\*]/', $dbGenre)) {
  933. $dbGenre = str_replace('*', '%', $dbGenre);
  934. $comparison = Criteria::LIKE;
  935. }
  936. }
  937. return $this->addUsingAlias(CcFilesPeer::GENRE, $dbGenre, $comparison);
  938. }
  939. /**
  940. * Filter the query on the comments column
  941. *
  942. * @param string $dbComments The value to use as filter.
  943. * Accepts wildcards (* and % trigger a LIKE)
  944. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  945. *
  946. * @return CcFilesQuery The current query, for fluid interface
  947. */
  948. public function filterByDbComments($dbComments = null, $comparison = null)
  949. {
  950. if (null === $comparison) {
  951. if (is_array($dbComments)) {
  952. $comparison = Criteria::IN;
  953. } elseif (preg_match('/[\%\*]/', $dbComments)) {
  954. $dbComments = str_replace('*', '%', $dbComments);
  955. $comparison = Criteria::LIKE;
  956. }
  957. }
  958. return $this->addUsingAlias(CcFilesPeer::COMMENTS, $dbComments, $comparison);
  959. }
  960. /**
  961. * Filter the query on the year column
  962. *
  963. * @param string $dbYear The value to use as filter.
  964. * Accepts wildcards (* and % trigger a LIKE)
  965. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  966. *
  967. * @return CcFilesQuery The current query, for fluid interface
  968. */
  969. public function filterByDbYear($dbYear = null, $comparison = null)
  970. {
  971. if (null === $comparison) {
  972. if (is_array($dbYear)) {
  973. $comparison = Criteria::IN;
  974. } elseif (preg_match('/[\%\*]/', $dbYear)) {
  975. $dbYear = str_replace('*', '%', $dbYear);
  976. $comparison = Criteria::LIKE;
  977. }
  978. }
  979. return $this->addUsingAlias(CcFilesPeer::YEAR, $dbYear, $comparison);
  980. }
  981. /**
  982. * Filter the query on the track_number column
  983. *
  984. * @param int|array $dbTrackNumber The value to use as filter.
  985. * Accepts an associative array('min' => $minValue, 'max' => $maxValue)
  986. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  987. *
  988. * @return CcFilesQuery The current query, for fluid interface
  989. */
  990. public function filterByDbTrackNumber($dbTrackNumber = null, $comparison = null)
  991. {
  992. if (is_array($dbTrackNumber)) {
  993. $useMinMax = false;
  994. if (isset($dbTrackNumber['min'])) {
  995. $this->addUsingAlias(CcFilesPeer::TRACK_NUMBER, $dbTrackNumber['min'], Criteria::GREATER_EQUAL);
  996. $useMinMax = true;
  997. }
  998. if (isset($dbTrackNumber['max'])) {
  999. $this->addUsingAlias(CcFilesPeer::TRACK_NUMBER, $dbTrackNumber['max'], Criteria::LESS_EQUAL);
  1000. $useMinMax = true;
  1001. }
  1002. if ($useMinMax) {
  1003. return $this;
  1004. }
  1005. if (null === $comparison) {
  1006. $comparison = Criteria::IN;
  1007. }
  1008. }
  1009. return $this->addUsingAlias(CcFilesPeer::TRACK_NUMBER, $dbTrackNumber, $comparison);
  1010. }
  1011. /**
  1012. * Filter the query on the channels column
  1013. *
  1014. * @param int|array $dbChannels The value to use as filter.
  1015. * Accepts an associative array('min' => $minValue, 'max' => $maxValue)
  1016. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1017. *
  1018. * @return CcFilesQuery The current query, for fluid interface
  1019. */
  1020. public function filterByDbChannels($dbChannels = null, $comparison = null)
  1021. {
  1022. if (is_array($dbChannels)) {
  1023. $useMinMax = false;
  1024. if (isset($dbChannels['min'])) {
  1025. $this->addUsingAlias(CcFilesPeer::CHANNELS, $dbChannels['min'], Criteria::GREATER_EQUAL);
  1026. $useMinMax = true;
  1027. }
  1028. if (isset($dbChannels['max'])) {
  1029. $this->addUsingAlias(CcFilesPeer::CHANNELS, $dbChannels['max'], Criteria::LESS_EQUAL);
  1030. $useMinMax = true;
  1031. }
  1032. if ($useMinMax) {
  1033. return $this;
  1034. }
  1035. if (null === $comparison) {
  1036. $comparison = Criteria::IN;
  1037. }
  1038. }
  1039. return $this->addUsingAlias(CcFilesPeer::CHANNELS, $dbChannels, $comparison);
  1040. }
  1041. /**
  1042. * Filter the query on the url column
  1043. *
  1044. * @param string $dbUrl The value to use as filter.
  1045. * Accepts wildcards (* and % trigger a LIKE)
  1046. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1047. *
  1048. * @return CcFilesQuery The current query, for fluid interface
  1049. */
  1050. public function filterByDbUrl($dbUrl = null, $comparison = null)
  1051. {
  1052. if (null === $comparison) {
  1053. if (is_array($dbUrl)) {
  1054. $comparison = Criteria::IN;
  1055. } elseif (preg_match('/[\%\*]/', $dbUrl)) {
  1056. $dbUrl = str_replace('*', '%', $dbUrl);
  1057. $comparison = Criteria::LIKE;
  1058. }
  1059. }
  1060. return $this->addUsingAlias(CcFilesPeer::URL, $dbUrl, $comparison);
  1061. }
  1062. /**
  1063. * Filter the query on the bpm column
  1064. *
  1065. * @param int|array $dbBpm The value to use as filter.
  1066. * Accepts an associative array('min' => $minValue, 'max' => $maxValue)
  1067. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1068. *
  1069. * @return CcFilesQuery The current query, for fluid interface
  1070. */
  1071. public function filterByDbBpm($dbBpm = null, $comparison = null)
  1072. {
  1073. if (is_array($dbBpm)) {
  1074. $useMinMax = false;
  1075. if (isset($dbBpm['min'])) {
  1076. $this->addUsingAlias(CcFilesPeer::BPM, $dbBpm['min'], Criteria::GREATER_EQUAL);
  1077. $useMinMax = true;
  1078. }
  1079. if (isset($dbBpm['max'])) {
  1080. $this->addUsingAlias(CcFilesPeer::BPM, $dbBpm['max'], Criteria::LESS_EQUAL);
  1081. $useMinMax = true;
  1082. }
  1083. if ($useMinMax) {
  1084. return $this;
  1085. }
  1086. if (null === $comparison) {
  1087. $comparison = Criteria::IN;
  1088. }
  1089. }
  1090. return $this->addUsingAlias(CcFilesPeer::BPM, $dbBpm, $comparison);
  1091. }
  1092. /**
  1093. * Filter the query on the rating column
  1094. *
  1095. * @param string $dbRating The value to use as filter.
  1096. * Accepts wildcards (* and % trigger a LIKE)
  1097. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1098. *
  1099. * @return CcFilesQuery The current query, for fluid interface
  1100. */
  1101. public function filterByDbRating($dbRating = null, $comparison = null)
  1102. {
  1103. if (null === $comparison) {
  1104. if (is_array($dbRating)) {
  1105. $comparison = Criteria::IN;
  1106. } elseif (preg_match('/[\%\*]/', $dbRating)) {
  1107. $dbRating = str_replace('*', '%', $dbRating);
  1108. $comparison = Criteria::LIKE;
  1109. }
  1110. }
  1111. return $this->addUsingAlias(CcFilesPeer::RATING, $dbRating, $comparison);
  1112. }
  1113. /**
  1114. * Filter the query on the encoded_by column
  1115. *
  1116. * @param string $dbEncodedBy The value to use as filter.
  1117. * Accepts wildcards (* and % trigger a LIKE)
  1118. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1119. *
  1120. * @return CcFilesQuery The current query, for fluid interface
  1121. */
  1122. public function filterByDbEncodedBy($dbEncodedBy = null, $comparison = null)
  1123. {
  1124. if (null === $comparison) {
  1125. if (is_array($dbEncodedBy)) {
  1126. $comparison = Criteria::IN;
  1127. } elseif (preg_match('/[\%\*]/', $dbEncodedBy)) {
  1128. $dbEncodedBy = str_replace('*', '%', $dbEncodedBy);
  1129. $comparison = Criteria::LIKE;
  1130. }
  1131. }
  1132. return $this->addUsingAlias(CcFilesPeer::ENCODED_BY, $dbEncodedBy, $comparison);
  1133. }
  1134. /**
  1135. * Filter the query on the disc_number column
  1136. *
  1137. * @param string $dbDiscNumber The value to use as filter.
  1138. * Accepts wildcards (* and % trigger a LIKE)
  1139. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1140. *
  1141. * @return CcFilesQuery The current query, for fluid interface
  1142. */
  1143. public function filterByDbDiscNumber($dbDiscNumber = null, $comparison = null)
  1144. {
  1145. if (null === $comparison) {
  1146. if (is_array($dbDiscNumber)) {
  1147. $comparison = Criteria::IN;
  1148. } elseif (preg_match('/[\%\*]/', $dbDiscNumber)) {
  1149. $dbDiscNumber = str_replace('*', '%', $dbDiscNumber);
  1150. $comparison = Criteria::LIKE;
  1151. }
  1152. }
  1153. return $this->addUsingAlias(CcFilesPeer::DISC_NUMBER, $dbDiscNumber, $comparison);
  1154. }
  1155. /**
  1156. * Filter the query on the mood column
  1157. *
  1158. * @param string $dbMood The value to use as filter.
  1159. * Accepts wildcards (* and % trigger a LIKE)
  1160. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1161. *
  1162. * @return CcFilesQuery The current query, for fluid interface
  1163. */
  1164. public function filterByDbMood($dbMood = null, $comparison = null)
  1165. {
  1166. if (null === $comparison) {
  1167. if (is_array($dbMood)) {
  1168. $comparison = Criteria::IN;
  1169. } elseif (preg_match('/[\%\*]/', $dbMood)) {
  1170. $dbMood = str_replace('*', '%', $dbMood);
  1171. $comparison = Criteria::LIKE;
  1172. }
  1173. }
  1174. return $this->addUsingAlias(CcFilesPeer::MOOD, $dbMood, $comparison);
  1175. }
  1176. /**
  1177. * Filter the query on the label column
  1178. *
  1179. * @param string $dbLabel The value to use as filter.
  1180. * Accepts wildcards (* and % trigger a LIKE)
  1181. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1182. *
  1183. * @return CcFilesQuery The current query, for fluid interface
  1184. */
  1185. public function filterByDbLabel($dbLabel = null, $comparison = null)
  1186. {
  1187. if (null === $comparison) {
  1188. if (is_array($dbLabel)) {
  1189. $comparison = Criteria::IN;
  1190. } elseif (preg_match('/[\%\*]/', $dbLabel)) {
  1191. $dbLabel = str_replace('*', '%', $dbLabel);
  1192. $comparison = Criteria::LIKE;
  1193. }
  1194. }
  1195. return $this->addUsingAlias(CcFilesPeer::LABEL, $dbLabel, $comparison);
  1196. }
  1197. /**
  1198. * Filter the query on the composer column
  1199. *
  1200. * @param string $dbComposer The value to use as filter.
  1201. * Accepts wildcards (* and % trigger a LIKE)
  1202. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1203. *
  1204. * @return CcFilesQuery The current query, for fluid interface
  1205. */
  1206. public function filterByDbComposer($dbComposer = null, $comparison = null)
  1207. {
  1208. if (null === $comparison) {
  1209. if (is_array($dbComposer)) {
  1210. $comparison = Criteria::IN;
  1211. } elseif (preg_match('/[\%\*]/', $dbComposer)) {
  1212. $dbComposer = str_replace('*', '%', $dbComposer);
  1213. $comparison = Criteria::LIKE;
  1214. }
  1215. }
  1216. return $this->addUsingAlias(CcFilesPeer::COMPOSER, $dbComposer, $comparison);
  1217. }
  1218. /**
  1219. * Filter the query on the encoder column
  1220. *
  1221. * @param string $dbEncoder The value to use as filter.
  1222. * Accepts wildcards (* and % trigger a LIKE)
  1223. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1224. *
  1225. * @return CcFilesQuery The current query, for fluid interface
  1226. */
  1227. public function filterByDbEncoder($dbEncoder = null, $comparison = null)
  1228. {
  1229. if (null === $comparison) {
  1230. if (is_array($dbEncoder)) {
  1231. $comparison = Criteria::IN;
  1232. } elseif (preg_match('/[\%\*]/', $dbEncoder)) {
  1233. $dbEncoder = str_replace('*', '%', $dbEncoder);
  1234. $comparison = Criteria::LIKE;
  1235. }
  1236. }
  1237. return $this->addUsingAlias(CcFilesPeer::ENCODER, $dbEncoder, $comparison);
  1238. }
  1239. /**
  1240. * Filter the query on the checksum column
  1241. *
  1242. * @param string $dbChecksum The value to use as filter.
  1243. * Accepts wildcards (* and % trigger a LIKE)
  1244. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1245. *
  1246. * @return CcFilesQuery The current query, for fluid interface
  1247. */
  1248. public function filterByDbChecksum($dbChecksum = null, $comparison = null)
  1249. {
  1250. if (null === $comparison) {
  1251. if (is_array($dbChecksum)) {
  1252. $comparison = Criteria::IN;
  1253. } elseif (preg_match('/[\%\*]/', $dbChecksum)) {
  1254. $dbChecksum = str_replace('*', '%', $dbChecksum);
  1255. $comparison = Criteria::LIKE;
  1256. }
  1257. }
  1258. return $this->addUsingAlias(CcFilesPeer::CHECKSUM, $dbChecksum, $comparison);
  1259. }
  1260. /**
  1261. * Filter the query on the lyrics column
  1262. *
  1263. * @param string $dbLyrics The value to use as filter.
  1264. * Accepts wildcards (* and % trigger a LIKE)
  1265. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1266. *
  1267. * @return CcFilesQuery The current query, for fluid interface
  1268. */
  1269. public function filterByDbLyrics($dbLyrics = null, $comparison = null)
  1270. {
  1271. if (null === $comparison) {
  1272. if (is_array($dbLyrics)) {
  1273. $comparison = Criteria::IN;
  1274. } elseif (preg_match('/[\%\*]/', $dbLyrics)) {
  1275. $dbLyrics = str_replace('*', '%', $dbLyrics);
  1276. $comparison = Criteria::LIKE;
  1277. }
  1278. }
  1279. return $this->addUsingAlias(CcFilesPeer::LYRICS, $dbLyrics, $comparison);
  1280. }
  1281. /**
  1282. * Filter the query on the orchestra column
  1283. *
  1284. * @param string $dbOrchestra The value to use as filter.
  1285. * Accepts wildcards (* and % trigger a LIKE)
  1286. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1287. *
  1288. * @return CcFilesQuery The current query, for fluid interface
  1289. */
  1290. public function filterByDbOrchestra($dbOrchestra = null, $comparison = null)
  1291. {
  1292. if (null === $comparison) {
  1293. if (is_array($dbOrchestra)) {
  1294. $comparison = Criteria::IN;
  1295. } elseif (preg_match('/[\%\*]/', $dbOrchestra)) {
  1296. $dbOrchestra = str_replace('*', '%', $dbOrchestra);
  1297. $comparison = Criteria::LIKE;
  1298. }
  1299. }
  1300. return $this->addUsingAlias(CcFilesPeer::ORCHESTRA, $dbOrchestra, $comparison);
  1301. }
  1302. /**
  1303. * Filter the query on the conductor column
  1304. *
  1305. * @param string $dbConductor The value to use as filter.
  1306. * Accepts wildcards (* and % trigger a LIKE)
  1307. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1308. *
  1309. * @return CcFilesQuery The current query, for fluid interface
  1310. */
  1311. public function filterByDbConductor($dbConductor = null, $comparison = null)
  1312. {
  1313. if (null === $comparison) {
  1314. if (is_array($dbConductor)) {
  1315. $comparison = Criteria::IN;
  1316. } elseif (preg_match('/[\%\*]/', $dbConductor)) {
  1317. $dbConductor = str_replace('*', '%', $dbConductor);
  1318. $comparison = Criteria::LIKE;
  1319. }
  1320. }
  1321. return $this->addUsingAlias(CcFilesPeer::CONDUCTOR, $dbConductor, $comparison);
  1322. }
  1323. /**
  1324. * Filter the query on the lyricist column
  1325. *
  1326. * @param string $dbLyricist The value to use as filter.
  1327. * Accepts wildcards (* and % trigger a LIKE)
  1328. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1329. *
  1330. * @return CcFilesQuery The current query, for fluid interface
  1331. */
  1332. public function filterByDbLyricist($dbLyricist = null, $comparison = null)
  1333. {
  1334. if (null === $comparison) {
  1335. if (is_array($dbLyricist)) {
  1336. $comparison = Criteria::IN;
  1337. } elseif (preg_match('/[\%\*]/', $dbLyricist)) {
  1338. $dbLyricist = str_replace('*', '%', $dbLyricist);
  1339. $comparison = Criteria::LIKE;
  1340. }
  1341. }
  1342. return $this->addUsingAlias(CcFilesPeer::LYRICIST, $dbLyricist, $comparison);
  1343. }
  1344. /**
  1345. * Filter the query on the original_lyricist column
  1346. *
  1347. * @param string $dbOriginalLyricist The value to use as filter.
  1348. * Accepts wildcards (* and % trigger a LIKE)
  1349. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1350. *
  1351. * @return CcFilesQuery The current query, for fluid interface
  1352. */
  1353. public function filterByDbOriginalLyricist($dbOriginalLyricist = null, $comparison = null)
  1354. {
  1355. if (null === $comparison) {
  1356. if (is_array($dbOriginalLyricist)) {
  1357. $comparison = Criteria::IN;
  1358. } elseif (preg_match('/[\%\*]/', $dbOriginalLyricist)) {
  1359. $dbOriginalLyricist = str_replace('*', '%', $dbOriginalLyricist);
  1360. $comparison = Criteria::LIKE;
  1361. }
  1362. }
  1363. return $this->addUsingAlias(CcFilesPeer::ORIGINAL_LYRICIST, $dbOriginalLyricist, $comparison);
  1364. }
  1365. /**
  1366. * Filter the query on the radio_station_name column
  1367. *
  1368. * @param string $dbRadioStationName The value to use as filter.
  1369. * Accepts wildcards (* and % trigger a LIKE)
  1370. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1371. *
  1372. * @return CcFilesQuery The current query, for fluid interface
  1373. */
  1374. public function filterByDbRadioStationName($dbRadioStationName = null, $comparison = null)
  1375. {
  1376. if (null === $comparison) {
  1377. if (is_array($dbRadioStationName)) {
  1378. $comparison = Criteria::IN;
  1379. } elseif (preg_match('/[\%\*]/', $dbRadioStationName)) {
  1380. $dbRadioStationName = str_replace('*', '%', $dbRadioStationName);
  1381. $comparison = Criteria::LIKE;
  1382. }
  1383. }
  1384. return $this->addUsingAlias(CcFilesPeer::RADIO_STATION_NAME, $dbRadioStationName, $comparison);
  1385. }
  1386. /**
  1387. * Filter the query on the info_url column
  1388. *
  1389. * @param string $dbInfoUrl The value to use as filter.
  1390. * Accepts wildcards (* and % trigger a LIKE)
  1391. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1392. *
  1393. * @return CcFilesQuery The current query, for fluid interface
  1394. */
  1395. public function filterByDbInfoUrl($dbInfoUrl = null, $comparison = null)
  1396. {
  1397. if (null === $comparison) {
  1398. if (is_array($dbInfoUrl)) {
  1399. $comparison = Criteria::IN;
  1400. } elseif (preg_match('/[\%\*]/', $dbInfoUrl)) {
  1401. $dbInfoUrl = str_replace('*', '%', $dbInfoUrl);
  1402. $comparison = Criteria::LIKE;
  1403. }
  1404. }
  1405. return $this->addUsingAlias(CcFilesPeer::INFO_URL, $dbInfoUrl, $comparison);
  1406. }
  1407. /**
  1408. * Filter the query on the artist_url column
  1409. *
  1410. * @param string $dbArtistUrl The value to use as filter.
  1411. * Accepts wildcards (* and % trigger a LIKE)
  1412. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1413. *
  1414. * @return CcFilesQuery The current query, for fluid interface
  1415. */
  1416. public function filterByDbArtistUrl($dbArtistUrl = null, $comparison = null)
  1417. {
  1418. if (null === $comparison) {
  1419. if (is_array($dbArtistUrl)) {
  1420. $comparison = Criteria::IN;
  1421. } elseif (preg_match('/[\%\*]/', $dbArtistUrl)) {
  1422. $dbArtistUrl = str_replace('*', '%', $dbArtistUrl);
  1423. $comparison = Criteria::LIKE;
  1424. }
  1425. }
  1426. return $this->addUsingAlias(CcFilesPeer::ARTIST_URL, $dbArtistUrl, $comparison);
  1427. }
  1428. /**
  1429. * Filter the query on the audio_source_url column
  1430. *
  1431. * @param string $dbAudioSourceUrl The value to use as filter.
  1432. * Accepts wildcards (* and % trigger a LIKE)
  1433. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1434. *
  1435. * @return CcFilesQuery The current query, for fluid interface
  1436. */
  1437. public function filterByDbAudioSourceUrl($dbAudioSourceUrl = null, $comparison = null)
  1438. {
  1439. if (null === $comparison) {
  1440. if (is_array($dbAudioSourceUrl)) {
  1441. $comparison = Criteria::IN;
  1442. } elseif (preg_match('/[\%\*]/', $dbAudioSourceUrl)) {
  1443. $dbAudioSourceUrl = str_replace('*', '%', $dbAudioSourceUrl);
  1444. $comparison = Criteria::LIKE;
  1445. }
  1446. }
  1447. return $this->addUsingAlias(CcFilesPeer::AUDIO_SOURCE_URL, $dbAudioSourceUrl, $comparison);
  1448. }
  1449. /**
  1450. * Filter the query on the radio_station_url column
  1451. *
  1452. * @param string $dbRadioStationUrl The value to use as filter.
  1453. * Accepts wildcards (* and % trigger a LIKE)
  1454. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1455. *
  1456. * @return CcFilesQuery The current query, for fluid interface
  1457. */
  1458. public function filterByDbRadioStationUrl($dbRadioStationUrl = null, $comparison = null)
  1459. {
  1460. if (null === $comparison) {
  1461. if (is_array($dbRadioStationUrl)) {
  1462. $comparison = Criteria::IN;
  1463. } elseif (preg_match('/[\%\*]/', $dbRadioStationUrl)) {
  1464. $dbRadioStationUrl = str_replace('*', '%', $dbRadioStationUrl);
  1465. $comparison = Criteria::LIKE;
  1466. }
  1467. }
  1468. return $this->addUsingAlias(CcFilesPeer::RADIO_STATION_URL, $dbRadioStationUrl, $comparison);
  1469. }
  1470. /**
  1471. * Filter the query on the buy_this_url column
  1472. *
  1473. * @param string $dbBuyThisUrl The value to use as filter.
  1474. * Accepts wildcards (* and % trigger a LIKE)
  1475. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1476. *
  1477. * @return CcFilesQuery The current query, for fluid interface
  1478. */
  1479. public function filterByDbBuyThisUrl($dbBuyThisUrl = null, $comparison = null)
  1480. {
  1481. if (null === $comparison) {
  1482. if (is_array($dbBuyThisUrl)) {
  1483. $comparison = Criteria::IN;
  1484. } elseif (preg_match('/[\%\*]/', $dbBuyThisUrl)) {
  1485. $dbBuyThisUrl = str_replace('*', '%', $dbBuyThisUrl);
  1486. $comparison = Criteria::LIKE;
  1487. }
  1488. }
  1489. return $this->addUsingAlias(CcFilesPeer::BUY_THIS_URL, $dbBuyThisUrl, $comparison);
  1490. }
  1491. /**
  1492. * Filter the query on the isrc_number column
  1493. *
  1494. * @param string $dbIsrcNumber The value to use as filter.
  1495. * Accepts wildcards (* and % trigger a LIKE)
  1496. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1497. *
  1498. * @return CcFilesQuery The current query, for fluid interface
  1499. */
  1500. public function filterByDbIsrcNumber($dbIsrcNumber = null, $comparison = null)
  1501. {
  1502. if (null === $comparison) {
  1503. if (is_array($dbIsrcNumber)) {
  1504. $comparison = Criteria::IN;
  1505. } elseif (preg_match('/[\%\*]/', $dbIsrcNumber)) {
  1506. $dbIsrcNumber = str_replace('*', '%', $dbIsrcNumber);
  1507. $comparison = Criteria::LIKE;
  1508. }
  1509. }
  1510. return $this->addUsingAlias(CcFilesPeer::ISRC_NUMBER, $dbIsrcNumber, $comparison);
  1511. }
  1512. /**
  1513. * Filter the query on the catalog_number column
  1514. *
  1515. * @param string $dbCatalogNumber The value to use as filter.
  1516. * Accepts wildcards (* and % trigger a LIKE)
  1517. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1518. *
  1519. * @return CcFilesQuery The current query, for fluid interface
  1520. */
  1521. public function filterByDbCatalogNumber($dbCatalogNumber = null, $comparison = null)
  1522. {
  1523. if (null === $comparison) {
  1524. if (is_array($dbCatalogNumber)) {
  1525. $comparison = Criteria::IN;
  1526. } elseif (preg_match('/[\%\*]/', $dbCatalogNumber)) {
  1527. $dbCatalogNumber = str_replace('*', '%', $dbCatalogNumber);
  1528. $comparison = Criteria::LIKE;
  1529. }
  1530. }
  1531. return $this->addUsingAlias(CcFilesPeer::CATALOG_NUMBER, $dbCatalogNumber, $comparison);
  1532. }
  1533. /**
  1534. * Filter the query on the original_artist column
  1535. *
  1536. * @param string $dbOriginalArtist The value to use as filter.
  1537. * Accepts wildcards (* and % trigger a LIKE)
  1538. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1539. *
  1540. * @return CcFilesQuery The current query, for fluid interface
  1541. */
  1542. public function filterByDbOriginalArtist($dbOriginalArtist = null, $comparison = null)
  1543. {
  1544. if (null === $comparison) {
  1545. if (is_array($dbOriginalArtist)) {
  1546. $comparison = Criteria::IN;
  1547. } elseif (preg_match('/[\%\*]/', $dbOriginalArtist)) {
  1548. $dbOriginalArtist = str_replace('*', '%', $dbOriginalArtist);
  1549. $comparison = Criteria::LIKE;
  1550. }
  1551. }
  1552. return $this->addUsingAlias(CcFilesPeer::ORIGINAL_ARTIST, $dbOriginalArtist, $comparison);
  1553. }
  1554. /**
  1555. * Filter the query on the copyright column
  1556. *
  1557. * @param string $dbCopyright The value to use as filter.
  1558. * Accepts wildcards (* and % trigger a LIKE)
  1559. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1560. *
  1561. * @return CcFilesQuery The current query, for fluid interface
  1562. */
  1563. public function filterByDbCopyright($dbCopyright = null, $comparison = null)
  1564. {
  1565. if (null === $comparison) {
  1566. if (is_array($dbCopyright)) {
  1567. $comparison = Criteria::IN;
  1568. } elseif (preg_match('/[\%\*]/', $dbCopyright)) {
  1569. $dbCopyright = str_replace('*', '%', $dbCopyright);
  1570. $comparison = Criteria::LIKE;
  1571. }
  1572. }
  1573. return $this->addUsingAlias(CcFilesPeer::COPYRIGHT, $dbCopyright, $comparison);
  1574. }
  1575. /**
  1576. * Filter the query on the report_datetime column
  1577. *
  1578. * @param string $dbReportDatetime The value to use as filter.
  1579. * Accepts wildcards (* and % trigger a LIKE)
  1580. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1581. *
  1582. * @return CcFilesQuery The current query, for fluid interface
  1583. */
  1584. public function filterByDbReportDatetime($dbReportDatetime = null, $comparison = null)
  1585. {
  1586. if (null === $comparison) {
  1587. if (is_array($dbReportDatetime)) {
  1588. $comparison = Criteria::IN;
  1589. } elseif (preg_match('/[\%\*]/', $dbReportDatetime)) {
  1590. $dbReportDatetime = str_replace('*', '%', $dbReportDatetime);
  1591. $comparison = Criteria::LIKE;
  1592. }
  1593. }
  1594. return $this->addUsingAlias(CcFilesPeer::REPORT_DATETIME, $dbReportDatetime, $comparison);
  1595. }
  1596. /**
  1597. * Filter the query on the report_location column
  1598. *
  1599. * @param string $dbReportLocation The value to use as filter.
  1600. * Accepts wildcards (* and % trigger a LIKE)
  1601. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1602. *
  1603. * @return CcFilesQuery The current query, for fluid interface
  1604. */
  1605. public function filterByDbReportLocation($dbReportLocation = null, $comparison = null)
  1606. {
  1607. if (null === $comparison) {
  1608. if (is_array($dbReportLocation)) {
  1609. $comparison = Criteria::IN;
  1610. } elseif (preg_match('/[\%\*]/', $dbReportLocation)) {
  1611. $dbReportLocation = str_replace('*', '%', $dbReportLocation);
  1612. $comparison = Criteria::LIKE;
  1613. }
  1614. }
  1615. return $this->addUsingAlias(CcFilesPeer::REPORT_LOCATION, $dbReportLocation, $comparison);
  1616. }
  1617. /**
  1618. * Filter the query on the report_organization column
  1619. *
  1620. * @param string $dbReportOrganization The value to use as filter.
  1621. * Accepts wildcards (* and % trigger a LIKE)
  1622. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1623. *
  1624. * @return CcFilesQuery The current query, for fluid interface
  1625. */
  1626. public function filterByDbReportOrganization($dbReportOrganization = null, $comparison = null)
  1627. {
  1628. if (null === $comparison) {
  1629. if (is_array($dbReportOrganization)) {
  1630. $comparison = Criteria::IN;
  1631. } elseif (preg_match('/[\%\*]/', $dbReportOrganization)) {
  1632. $dbReportOrganization = str_replace('*', '%', $dbReportOrganization);
  1633. $comparison = Criteria::LIKE;
  1634. }
  1635. }
  1636. return $this->addUsingAlias(CcFilesPeer::REPORT_ORGANIZATION, $dbReportOrganization, $comparison);
  1637. }
  1638. /**
  1639. * Filter the query on the subject column
  1640. *
  1641. * @param string $dbSubject The value to use as filter.
  1642. * Accepts wildcards (* and % trigger a LIKE)
  1643. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1644. *
  1645. * @return CcFilesQuery The current query, for fluid interface
  1646. */
  1647. public function filterByDbSubject($dbSubject = null, $comparison = null)
  1648. {
  1649. if (null === $comparison) {
  1650. if (is_array($dbSubject)) {
  1651. $comparison = Criteria::IN;
  1652. } elseif (preg_match('/[\%\*]/', $dbSubject)) {
  1653. $dbSubject = str_replace('*', '%', $dbSubject);
  1654. $comparison = Criteria::LIKE;
  1655. }
  1656. }
  1657. return $this->addUsingAlias(CcFilesPeer::SUBJECT, $dbSubject, $comparison);
  1658. }
  1659. /**
  1660. * Filter the query on the contributor column
  1661. *
  1662. * @param string $dbContributor The value to use as filter.
  1663. * Accepts wildcards (* and % trigger a LIKE)
  1664. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1665. *
  1666. * @return CcFilesQuery The current query, for fluid interface
  1667. */
  1668. public function filterByDbContributor($dbContributor = null, $comparison = null)
  1669. {
  1670. if (null === $comparison) {
  1671. if (is_array($dbContributor)) {
  1672. $comparison = Criteria::IN;
  1673. } elseif (preg_match('/[\%\*]/', $dbContributor)) {
  1674. $dbContributor = str_replace('*', '%', $dbContributor);
  1675. $comparison = Criteria::LIKE;
  1676. }
  1677. }
  1678. return $this->addUsingAlias(CcFilesPeer::CONTRIBUTOR, $dbContributor, $comparison);
  1679. }
  1680. /**
  1681. * Filter the query on the language column
  1682. *
  1683. * @param string $dbLanguage The value to use as filter.
  1684. * Accepts wildcards (* and % trigger a LIKE)
  1685. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1686. *
  1687. * @return CcFilesQuery The current query, for fluid interface
  1688. */
  1689. public function filterByDbLanguage($dbLanguage = null, $comparison = null)
  1690. {
  1691. if (null === $comparison) {
  1692. if (is_array($dbLanguage)) {
  1693. $comparison = Criteria::IN;
  1694. } elseif (preg_match('/[\%\*]/', $dbLanguage)) {
  1695. $dbLanguage = str_replace('*', '%', $dbLanguage);
  1696. $comparison = Criteria::LIKE;
  1697. }
  1698. }
  1699. return $this->addUsingAlias(CcFilesPeer::LANGUAGE, $dbLanguage, $comparison);
  1700. }
  1701. /**
  1702. * Filter the query on the file_exists column
  1703. *
  1704. * @param boolean|string $dbFileExists The value to use as filter.
  1705. * Accepts strings ('false', 'off', '-', 'no', 'n', and '0' are false, the rest is true)
  1706. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1707. *
  1708. * @return CcFilesQuery The current query, for fluid interface
  1709. */
  1710. public function filterByDbFileExists($dbFileExists = null, $comparison = null)
  1711. {
  1712. if (is_string($dbFileExists)) {
  1713. $file_exists = in_array(strtolower($dbFileExists), array('false', 'off', '-', 'no', 'n', '0')) ? false : true;
  1714. }
  1715. return $this->addUsingAlias(CcFilesPeer::FILE_EXISTS, $dbFileExists, $comparison);
  1716. }
  1717. /**
  1718. * Filter the query on the soundcloud_id column
  1719. *
  1720. * @param int|array $dbSoundcloudId The value to use as filter.
  1721. * Accepts an associative array('min' => $minValue, 'max' => $maxValue)
  1722. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1723. *
  1724. * @return CcFilesQuery The current query, for fluid interface
  1725. */
  1726. public function filterByDbSoundcloudId($dbSoundcloudId = null, $comparison = null)
  1727. {
  1728. if (is_array($dbSoundcloudId)) {
  1729. $useMinMax = false;
  1730. if (isset($dbSoundcloudId['min'])) {
  1731. $this->addUsingAlias(CcFilesPeer::SOUNDCLOUD_ID, $dbSoundcloudId['min'], Criteria::GREATER_EQUAL);
  1732. $useMinMax = true;
  1733. }
  1734. if (isset($dbSoundcloudId['max'])) {
  1735. $this->addUsingAlias(CcFilesPeer::SOUNDCLOUD_ID, $dbSoundcloudId['max'], Criteria::LESS_EQUAL);
  1736. $useMinMax = true;
  1737. }
  1738. if ($useMinMax) {
  1739. return $this;
  1740. }
  1741. if (null === $comparison) {
  1742. $comparison = Criteria::IN;
  1743. }
  1744. }
  1745. return $this->addUsingAlias(CcFilesPeer::SOUNDCLOUD_ID, $dbSoundcloudId, $comparison);
  1746. }
  1747. /**
  1748. * Filter the query on the soundcloud_error_code column
  1749. *
  1750. * @param int|array $dbSoundcloudErrorCode The value to use as filter.
  1751. * Accepts an associative array('min' => $minValue, 'max' => $maxValue)
  1752. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1753. *
  1754. * @return CcFilesQuery The current query, for fluid interface
  1755. */
  1756. public function filterByDbSoundcloudErrorCode($dbSoundcloudErrorCode = null, $comparison = null)
  1757. {
  1758. if (is_array($dbSoundcloudErrorCode)) {
  1759. $useMinMax = false;
  1760. if (isset($dbSoundcloudErrorCode['min'])) {
  1761. $this->addUsingAlias(CcFilesPeer::SOUNDCLOUD_ERROR_CODE, $dbSoundcloudErrorCode['min'], Criteria::GREATER_EQUAL);
  1762. $useMinMax = true;
  1763. }
  1764. if (isset($dbSoundcloudErrorCode['max'])) {
  1765. $this->addUsingAlias(CcFilesPeer::SOUNDCLOUD_ERROR_CODE, $dbSoundcloudErrorCode['max'], Criteria::LESS_EQUAL);
  1766. $useMinMax = true;
  1767. }
  1768. if ($useMinMax) {
  1769. return $this;
  1770. }
  1771. if (null === $comparison) {
  1772. $comparison = Criteria::IN;
  1773. }
  1774. }
  1775. return $this->addUsingAlias(CcFilesPeer::SOUNDCLOUD_ERROR_CODE, $dbSoundcloudErrorCode, $comparison);
  1776. }
  1777. /**
  1778. * Filter the query on the soundcloud_error_msg column
  1779. *
  1780. * @param string $dbSoundcloudErrorMsg The value to use as filter.
  1781. * Accepts wildcards (* and % trigger a LIKE)
  1782. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1783. *
  1784. * @return CcFilesQuery The current query, for fluid interface
  1785. */
  1786. public function filterByDbSoundcloudErrorMsg($dbSoundcloudErrorMsg = null, $comparison = null)
  1787. {
  1788. if (null === $comparison) {
  1789. if (is_array($dbSoundcloudErrorMsg)) {
  1790. $comparison = Criteria::IN;
  1791. } elseif (preg_match('/[\%\*]/', $dbSoundcloudErrorMsg)) {
  1792. $dbSoundcloudErrorMsg = str_replace('*', '%', $dbSoundcloudErrorMsg);
  1793. $comparison = Criteria::LIKE;
  1794. }
  1795. }
  1796. return $this->addUsingAlias(CcFilesPeer::SOUNDCLOUD_ERROR_MSG, $dbSoundcloudErrorMsg, $comparison);
  1797. }
  1798. /**
  1799. * Filter the query on the soundcloud_link_to_file column
  1800. *
  1801. * @param string $dbSoundcloudLinkToFile The value to use as filter.
  1802. * Accepts wildcards (* and % trigger a LIKE)
  1803. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1804. *
  1805. * @return CcFilesQuery The current query, for fluid interface
  1806. */
  1807. public function filterByDbSoundcloudLinkToFile($dbSoundcloudLinkToFile = null, $comparison = null)
  1808. {
  1809. if (null === $comparison) {
  1810. if (is_array($dbSoundcloudLinkToFile)) {
  1811. $comparison = Criteria::IN;
  1812. } elseif (preg_match('/[\%\*]/', $dbSoundcloudLinkToFile)) {
  1813. $dbSoundcloudLinkToFile = str_replace('*', '%', $dbSoundcloudLinkToFile);
  1814. $comparison = Criteria::LIKE;
  1815. }
  1816. }
  1817. return $this->addUsingAlias(CcFilesPeer::SOUNDCLOUD_LINK_TO_FILE, $dbSoundcloudLinkToFile, $comparison);
  1818. }
  1819. /**
  1820. * Filter the query on the soundcloud_upload_time column
  1821. *
  1822. * @param string|array $dbSoundCloundUploadTime The value to use as filter.
  1823. * Accepts an associative array('min' => $minValue, 'max' => $maxValue)
  1824. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1825. *
  1826. * @return CcFilesQuery The current query, for fluid interface
  1827. */
  1828. public function filterByDbSoundCloundUploadTime($dbSoundCloundUploadTime = null, $comparison = null)
  1829. {
  1830. if (is_array($dbSoundCloundUploadTime)) {
  1831. $useMinMax = false;
  1832. if (isset($dbSoundCloundUploadTime['min'])) {
  1833. $this->addUsingAlias(CcFilesPeer::SOUNDCLOUD_UPLOAD_TIME, $dbSoundCloundUploadTime['min'], Criteria::GREATER_EQUAL);
  1834. $useMinMax = true;
  1835. }
  1836. if (isset($dbSoundCloundUploadTime['max'])) {
  1837. $this->addUsingAlias(CcFilesPeer::SOUNDCLOUD_UPLOAD_TIME, $dbSoundCloundUploadTime['max'], Criteria::LESS_EQUAL);
  1838. $useMinMax = true;
  1839. }
  1840. if ($useMinMax) {
  1841. return $this;
  1842. }
  1843. if (null === $comparison) {
  1844. $comparison = Criteria::IN;
  1845. }
  1846. }
  1847. return $this->addUsingAlias(CcFilesPeer::SOUNDCLOUD_UPLOAD_TIME, $dbSoundCloundUploadTime, $comparison);
  1848. }
  1849. /**
  1850. * Filter the query on the replay_gain column
  1851. *
  1852. * @param string|array $dbReplayGain The value to use as filter.
  1853. * Accepts an associative array('min' => $minValue, 'max' => $maxValue)
  1854. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1855. *
  1856. * @return CcFilesQuery The current query, for fluid interface
  1857. */
  1858. public function filterByDbReplayGain($dbReplayGain = null, $comparison = null)
  1859. {
  1860. if (is_array($dbReplayGain)) {
  1861. $useMinMax = false;
  1862. if (isset($dbReplayGain['min'])) {
  1863. $this->addUsingAlias(CcFilesPeer::REPLAY_GAIN, $dbReplayGain['min'], Criteria::GREATER_EQUAL);
  1864. $useMinMax = true;
  1865. }
  1866. if (isset($dbReplayGain['max'])) {
  1867. $this->addUsingAlias(CcFilesPeer::REPLAY_GAIN, $dbReplayGain['max'], Criteria::LESS_EQUAL);
  1868. $useMinMax = true;
  1869. }
  1870. if ($useMinMax) {
  1871. return $this;
  1872. }
  1873. if (null === $comparison) {
  1874. $comparison = Criteria::IN;
  1875. }
  1876. }
  1877. return $this->addUsingAlias(CcFilesPeer::REPLAY_GAIN, $dbReplayGain, $comparison);
  1878. }
  1879. /**
  1880. * Filter the query on the owner_id column
  1881. *
  1882. * @param int|array $dbOwnerId The value to use as filter.
  1883. * Accepts an associative array('min' => $minValue, 'max' => $maxValue)
  1884. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1885. *
  1886. * @return CcFilesQuery The current query, for fluid interface
  1887. */
  1888. public function filterByDbOwnerId($dbOwnerId = null, $comparison = null)
  1889. {
  1890. if (is_array($dbOwnerId)) {
  1891. $useMinMax = false;
  1892. if (isset($dbOwnerId['min'])) {
  1893. $this->addUsingAlias(CcFilesPeer::OWNER_ID, $dbOwnerId['min'], Criteria::GREATER_EQUAL);
  1894. $useMinMax = true;
  1895. }
  1896. if (isset($dbOwnerId['max'])) {
  1897. $this->addUsingAlias(CcFilesPeer::OWNER_ID, $dbOwnerId['max'], Criteria::LESS_EQUAL);
  1898. $useMinMax = true;
  1899. }
  1900. if ($useMinMax) {
  1901. return $this;
  1902. }
  1903. if (null === $comparison) {
  1904. $comparison = Criteria::IN;
  1905. }
  1906. }
  1907. return $this->addUsingAlias(CcFilesPeer::OWNER_ID, $dbOwnerId, $comparison);
  1908. }
  1909. /**
  1910. * Filter the query on the cuein column
  1911. *
  1912. * @param string $dbCuein The value to use as filter.
  1913. * Accepts wildcards (* and % trigger a LIKE)
  1914. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1915. *
  1916. * @return CcFilesQuery The current query, for fluid interface
  1917. */
  1918. public function filterByDbCuein($dbCuein = null, $comparison = null)
  1919. {
  1920. if (null === $comparison) {
  1921. if (is_array($dbCuein)) {
  1922. $comparison = Criteria::IN;
  1923. } elseif (preg_match('/[\%\*]/', $dbCuein)) {
  1924. $dbCuein = str_replace('*', '%', $dbCuein);
  1925. $comparison = Criteria::LIKE;
  1926. }
  1927. }
  1928. return $this->addUsingAlias(CcFilesPeer::CUEIN, $dbCuein, $comparison);
  1929. }
  1930. /**
  1931. * Filter the query on the cueout column
  1932. *
  1933. * @param string $dbCueout The value to use as filter.
  1934. * Accepts wildcards (* and % trigger a LIKE)
  1935. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1936. *
  1937. * @return CcFilesQuery The current query, for fluid interface
  1938. */
  1939. public function filterByDbCueout($dbCueout = null, $comparison = null)
  1940. {
  1941. if (null === $comparison) {
  1942. if (is_array($dbCueout)) {
  1943. $comparison = Criteria::IN;
  1944. } elseif (preg_match('/[\%\*]/', $dbCueout)) {
  1945. $dbCueout = str_replace('*', '%', $dbCueout);
  1946. $comparison = Criteria::LIKE;
  1947. }
  1948. }
  1949. return $this->addUsingAlias(CcFilesPeer::CUEOUT, $dbCueout, $comparison);
  1950. }
  1951. /**
  1952. * Filter the query on the silan_check column
  1953. *
  1954. * @param boolean|string $dbSilanCheck The value to use as filter.
  1955. * Accepts strings ('false', 'off', '-', 'no', 'n', and '0' are false, the rest is true)
  1956. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1957. *
  1958. * @return CcFilesQuery The current query, for fluid interface
  1959. */
  1960. public function filterByDbSilanCheck($dbSilanCheck = null, $comparison = null)
  1961. {
  1962. if (is_string($dbSilanCheck)) {
  1963. $silan_check = in_array(strtolower($dbSilanCheck), array('false', 'off', '-', 'no', 'n', '0')) ? false : true;
  1964. }
  1965. return $this->addUsingAlias(CcFilesPeer::SILAN_CHECK, $dbSilanCheck, $comparison);
  1966. }
  1967. /**
  1968. * Filter the query on the hidden column
  1969. *
  1970. * @param boolean|string $dbHidden The value to use as filter.
  1971. * Accepts strings ('false', 'off', '-', 'no', 'n', and '0' are false, the rest is true)
  1972. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1973. *
  1974. * @return CcFilesQuery The current query, for fluid interface
  1975. */
  1976. public function filterByDbHidden($dbHidden = null, $comparison = null)
  1977. {
  1978. if (is_string($dbHidden)) {
  1979. $hidden = in_array(strtolower($dbHidden), array('false', 'off', '-', 'no', 'n', '0')) ? false : true;
  1980. }
  1981. return $this->addUsingAlias(CcFilesPeer::HIDDEN, $dbHidden, $comparison);
  1982. }
  1983. /**
  1984. * Filter the query on the is_scheduled column
  1985. *
  1986. * @param boolean|string $dbIsScheduled The value to use as filter.
  1987. * Accepts strings ('false', 'off', '-', 'no', 'n', and '0' are false, the rest is true)
  1988. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  1989. *
  1990. * @return CcFilesQuery The current query, for fluid interface
  1991. */
  1992. public function filterByDbIsScheduled($dbIsScheduled = null, $comparison = null)
  1993. {
  1994. if (is_string($dbIsScheduled)) {
  1995. $is_scheduled = in_array(strtolower($dbIsScheduled), array('false', 'off', '-', 'no', 'n', '0')) ? false : true;
  1996. }
  1997. return $this->addUsingAlias(CcFilesPeer::IS_SCHEDULED, $dbIsScheduled, $comparison);
  1998. }
  1999. /**
  2000. * Filter the query on the is_playlist column
  2001. *
  2002. * @param boolean|string $dbIsPlaylist The value to use as filter.
  2003. * Accepts strings ('false', 'off', '-', 'no', 'n', and '0' are false, the rest is true)
  2004. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  2005. *
  2006. * @return CcFilesQuery The current query, for fluid interface
  2007. */
  2008. public function filterByDbIsPlaylist($dbIsPlaylist = null, $comparison = null)
  2009. {
  2010. if (is_string($dbIsPlaylist)) {
  2011. $is_playlist = in_array(strtolower($dbIsPlaylist), array('false', 'off', '-', 'no', 'n', '0')) ? false : true;
  2012. }
  2013. return $this->addUsingAlias(CcFilesPeer::IS_PLAYLIST, $dbIsPlaylist, $comparison);
  2014. }
  2015. /**
  2016. * Filter the query by a related CcSubjs object
  2017. *
  2018. * @param CcSubjs $ccSubjs the related object to use as filter
  2019. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  2020. *
  2021. * @return CcFilesQuery The current query, for fluid interface
  2022. */
  2023. public function filterByFkOwner($ccSubjs, $comparison = null)
  2024. {
  2025. return $this
  2026. ->addUsingAlias(CcFilesPeer::OWNER_ID, $ccSubjs->getDbId(), $comparison);
  2027. }
  2028. /**
  2029. * Adds a JOIN clause to the query using the FkOwner relation
  2030. *
  2031. * @param string $relationAlias optional alias for the relation
  2032. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  2033. *
  2034. * @return CcFilesQuery The current query, for fluid interface
  2035. */
  2036. public function joinFkOwner($relationAlias = '', $joinType = Criteria::LEFT_JOIN)
  2037. {
  2038. $tableMap = $this->getTableMap();
  2039. $relationMap = $tableMap->getRelation('FkOwner');
  2040. // create a ModelJoin object for this join
  2041. $join = new ModelJoin();
  2042. $join->setJoinType($joinType);
  2043. $join->setRelationMap($relationMap, $this->useAliasInSQL ? $this->getModelAlias() : null, $relationAlias);
  2044. if ($previousJoin = $this->getPreviousJoin()) {
  2045. $join->setPreviousJoin($previousJoin);
  2046. }
  2047. // add the ModelJoin to the current object
  2048. if($relationAlias) {
  2049. $this->addAlias($relationAlias, $relationMap->getRightTable()->getName());
  2050. $this->addJoinObject($join, $relationAlias);
  2051. } else {
  2052. $this->addJoinObject($join, 'FkOwner');
  2053. }
  2054. return $this;
  2055. }
  2056. /**
  2057. * Use the FkOwner relation CcSubjs object
  2058. *
  2059. * @see useQuery()
  2060. *
  2061. * @param string $relationAlias optional alias for the relation,
  2062. * to be used as main alias in the secondary query
  2063. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  2064. *
  2065. * @return CcSubjsQuery A secondary query class using the current class as primary query
  2066. */
  2067. public function useFkOwnerQuery($relationAlias = '', $joinType = Criteria::LEFT_JOIN)
  2068. {
  2069. return $this
  2070. ->joinFkOwner($relationAlias, $joinType)
  2071. ->useQuery($relationAlias ? $relationAlias : 'FkOwner', 'CcSubjsQuery');
  2072. }
  2073. /**
  2074. * Filter the query by a related CcSubjs object
  2075. *
  2076. * @param CcSubjs $ccSubjs the related object to use as filter
  2077. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  2078. *
  2079. * @return CcFilesQuery The current query, for fluid interface
  2080. */
  2081. public function filterByCcSubjsRelatedByDbEditedby($ccSubjs, $comparison = null)
  2082. {
  2083. return $this
  2084. ->addUsingAlias(CcFilesPeer::EDITEDBY, $ccSubjs->getDbId(), $comparison);
  2085. }
  2086. /**
  2087. * Adds a JOIN clause to the query using the CcSubjsRelatedByDbEditedby relation
  2088. *
  2089. * @param string $relationAlias optional alias for the relation
  2090. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  2091. *
  2092. * @return CcFilesQuery The current query, for fluid interface
  2093. */
  2094. public function joinCcSubjsRelatedByDbEditedby($relationAlias = '', $joinType = Criteria::LEFT_JOIN)
  2095. {
  2096. $tableMap = $this->getTableMap();
  2097. $relationMap = $tableMap->getRelation('CcSubjsRelatedByDbEditedby');
  2098. // create a ModelJoin object for this join
  2099. $join = new ModelJoin();
  2100. $join->setJoinType($joinType);
  2101. $join->setRelationMap($relationMap, $this->useAliasInSQL ? $this->getModelAlias() : null, $relationAlias);
  2102. if ($previousJoin = $this->getPreviousJoin()) {
  2103. $join->setPreviousJoin($previousJoin);
  2104. }
  2105. // add the ModelJoin to the current object
  2106. if($relationAlias) {
  2107. $this->addAlias($relationAlias, $relationMap->getRightTable()->getName());
  2108. $this->addJoinObject($join, $relationAlias);
  2109. } else {
  2110. $this->addJoinObject($join, 'CcSubjsRelatedByDbEditedby');
  2111. }
  2112. return $this;
  2113. }
  2114. /**
  2115. * Use the CcSubjsRelatedByDbEditedby relation CcSubjs object
  2116. *
  2117. * @see useQuery()
  2118. *
  2119. * @param string $relationAlias optional alias for the relation,
  2120. * to be used as main alias in the secondary query
  2121. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  2122. *
  2123. * @return CcSubjsQuery A secondary query class using the current class as primary query
  2124. */
  2125. public function useCcSubjsRelatedByDbEditedbyQuery($relationAlias = '', $joinType = Criteria::LEFT_JOIN)
  2126. {
  2127. return $this
  2128. ->joinCcSubjsRelatedByDbEditedby($relationAlias, $joinType)
  2129. ->useQuery($relationAlias ? $relationAlias : 'CcSubjsRelatedByDbEditedby', 'CcSubjsQuery');
  2130. }
  2131. /**
  2132. * Filter the query by a related CcMusicDirs object
  2133. *
  2134. * @param CcMusicDirs $ccMusicDirs the related object to use as filter
  2135. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  2136. *
  2137. * @return CcFilesQuery The current query, for fluid interface
  2138. */
  2139. public function filterByCcMusicDirs($ccMusicDirs, $comparison = null)
  2140. {
  2141. return $this
  2142. ->addUsingAlias(CcFilesPeer::DIRECTORY, $ccMusicDirs->getId(), $comparison);
  2143. }
  2144. /**
  2145. * Adds a JOIN clause to the query using the CcMusicDirs relation
  2146. *
  2147. * @param string $relationAlias optional alias for the relation
  2148. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  2149. *
  2150. * @return CcFilesQuery The current query, for fluid interface
  2151. */
  2152. public function joinCcMusicDirs($relationAlias = '', $joinType = Criteria::LEFT_JOIN)
  2153. {
  2154. $tableMap = $this->getTableMap();
  2155. $relationMap = $tableMap->getRelation('CcMusicDirs');
  2156. // create a ModelJoin object for this join
  2157. $join = new ModelJoin();
  2158. $join->setJoinType($joinType);
  2159. $join->setRelationMap($relationMap, $this->useAliasInSQL ? $this->getModelAlias() : null, $relationAlias);
  2160. if ($previousJoin = $this->getPreviousJoin()) {
  2161. $join->setPreviousJoin($previousJoin);
  2162. }
  2163. // add the ModelJoin to the current object
  2164. if($relationAlias) {
  2165. $this->addAlias($relationAlias, $relationMap->getRightTable()->getName());
  2166. $this->addJoinObject($join, $relationAlias);
  2167. } else {
  2168. $this->addJoinObject($join, 'CcMusicDirs');
  2169. }
  2170. return $this;
  2171. }
  2172. /**
  2173. * Use the CcMusicDirs relation CcMusicDirs object
  2174. *
  2175. * @see useQuery()
  2176. *
  2177. * @param string $relationAlias optional alias for the relation,
  2178. * to be used as main alias in the secondary query
  2179. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  2180. *
  2181. * @return CcMusicDirsQuery A secondary query class using the current class as primary query
  2182. */
  2183. public function useCcMusicDirsQuery($relationAlias = '', $joinType = Criteria::LEFT_JOIN)
  2184. {
  2185. return $this
  2186. ->joinCcMusicDirs($relationAlias, $joinType)
  2187. ->useQuery($relationAlias ? $relationAlias : 'CcMusicDirs', 'CcMusicDirsQuery');
  2188. }
  2189. /**
  2190. * Filter the query by a related CcShowInstances object
  2191. *
  2192. * @param CcShowInstances $ccShowInstances the related object to use as filter
  2193. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  2194. *
  2195. * @return CcFilesQuery The current query, for fluid interface
  2196. */
  2197. public function filterByCcShowInstances($ccShowInstances, $comparison = null)
  2198. {
  2199. return $this
  2200. ->addUsingAlias(CcFilesPeer::ID, $ccShowInstances->getDbRecordedFile(), $comparison);
  2201. }
  2202. /**
  2203. * Adds a JOIN clause to the query using the CcShowInstances relation
  2204. *
  2205. * @param string $relationAlias optional alias for the relation
  2206. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  2207. *
  2208. * @return CcFilesQuery The current query, for fluid interface
  2209. */
  2210. public function joinCcShowInstances($relationAlias = '', $joinType = Criteria::LEFT_JOIN)
  2211. {
  2212. $tableMap = $this->getTableMap();
  2213. $relationMap = $tableMap->getRelation('CcShowInstances');
  2214. // create a ModelJoin object for this join
  2215. $join = new ModelJoin();
  2216. $join->setJoinType($joinType);
  2217. $join->setRelationMap($relationMap, $this->useAliasInSQL ? $this->getModelAlias() : null, $relationAlias);
  2218. if ($previousJoin = $this->getPreviousJoin()) {
  2219. $join->setPreviousJoin($previousJoin);
  2220. }
  2221. // add the ModelJoin to the current object
  2222. if($relationAlias) {
  2223. $this->addAlias($relationAlias, $relationMap->getRightTable()->getName());
  2224. $this->addJoinObject($join, $relationAlias);
  2225. } else {
  2226. $this->addJoinObject($join, 'CcShowInstances');
  2227. }
  2228. return $this;
  2229. }
  2230. /**
  2231. * Use the CcShowInstances relation CcShowInstances object
  2232. *
  2233. * @see useQuery()
  2234. *
  2235. * @param string $relationAlias optional alias for the relation,
  2236. * to be used as main alias in the secondary query
  2237. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  2238. *
  2239. * @return CcShowInstancesQuery A secondary query class using the current class as primary query
  2240. */
  2241. public function useCcShowInstancesQuery($relationAlias = '', $joinType = Criteria::LEFT_JOIN)
  2242. {
  2243. return $this
  2244. ->joinCcShowInstances($relationAlias, $joinType)
  2245. ->useQuery($relationAlias ? $relationAlias : 'CcShowInstances', 'CcShowInstancesQuery');
  2246. }
  2247. /**
  2248. * Filter the query by a related CcPlaylistcontents object
  2249. *
  2250. * @param CcPlaylistcontents $ccPlaylistcontents the related object to use as filter
  2251. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  2252. *
  2253. * @return CcFilesQuery The current query, for fluid interface
  2254. */
  2255. public function filterByCcPlaylistcontents($ccPlaylistcontents, $comparison = null)
  2256. {
  2257. return $this
  2258. ->addUsingAlias(CcFilesPeer::ID, $ccPlaylistcontents->getDbFileId(), $comparison);
  2259. }
  2260. /**
  2261. * Adds a JOIN clause to the query using the CcPlaylistcontents relation
  2262. *
  2263. * @param string $relationAlias optional alias for the relation
  2264. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  2265. *
  2266. * @return CcFilesQuery The current query, for fluid interface
  2267. */
  2268. public function joinCcPlaylistcontents($relationAlias = '', $joinType = Criteria::LEFT_JOIN)
  2269. {
  2270. $tableMap = $this->getTableMap();
  2271. $relationMap = $tableMap->getRelation('CcPlaylistcontents');
  2272. // create a ModelJoin object for this join
  2273. $join = new ModelJoin();
  2274. $join->setJoinType($joinType);
  2275. $join->setRelationMap($relationMap, $this->useAliasInSQL ? $this->getModelAlias() : null, $relationAlias);
  2276. if ($previousJoin = $this->getPreviousJoin()) {
  2277. $join->setPreviousJoin($previousJoin);
  2278. }
  2279. // add the ModelJoin to the current object
  2280. if($relationAlias) {
  2281. $this->addAlias($relationAlias, $relationMap->getRightTable()->getName());
  2282. $this->addJoinObject($join, $relationAlias);
  2283. } else {
  2284. $this->addJoinObject($join, 'CcPlaylistcontents');
  2285. }
  2286. return $this;
  2287. }
  2288. /**
  2289. * Use the CcPlaylistcontents relation CcPlaylistcontents object
  2290. *
  2291. * @see useQuery()
  2292. *
  2293. * @param string $relationAlias optional alias for the relation,
  2294. * to be used as main alias in the secondary query
  2295. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  2296. *
  2297. * @return CcPlaylistcontentsQuery A secondary query class using the current class as primary query
  2298. */
  2299. public function useCcPlaylistcontentsQuery($relationAlias = '', $joinType = Criteria::LEFT_JOIN)
  2300. {
  2301. return $this
  2302. ->joinCcPlaylistcontents($relationAlias, $joinType)
  2303. ->useQuery($relationAlias ? $relationAlias : 'CcPlaylistcontents', 'CcPlaylistcontentsQuery');
  2304. }
  2305. /**
  2306. * Filter the query by a related CcBlockcontents object
  2307. *
  2308. * @param CcBlockcontents $ccBlockcontents the related object to use as filter
  2309. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  2310. *
  2311. * @return CcFilesQuery The current query, for fluid interface
  2312. */
  2313. public function filterByCcBlockcontents($ccBlockcontents, $comparison = null)
  2314. {
  2315. return $this
  2316. ->addUsingAlias(CcFilesPeer::ID, $ccBlockcontents->getDbFileId(), $comparison);
  2317. }
  2318. /**
  2319. * Adds a JOIN clause to the query using the CcBlockcontents relation
  2320. *
  2321. * @param string $relationAlias optional alias for the relation
  2322. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  2323. *
  2324. * @return CcFilesQuery The current query, for fluid interface
  2325. */
  2326. public function joinCcBlockcontents($relationAlias = '', $joinType = Criteria::LEFT_JOIN)
  2327. {
  2328. $tableMap = $this->getTableMap();
  2329. $relationMap = $tableMap->getRelation('CcBlockcontents');
  2330. // create a ModelJoin object for this join
  2331. $join = new ModelJoin();
  2332. $join->setJoinType($joinType);
  2333. $join->setRelationMap($relationMap, $this->useAliasInSQL ? $this->getModelAlias() : null, $relationAlias);
  2334. if ($previousJoin = $this->getPreviousJoin()) {
  2335. $join->setPreviousJoin($previousJoin);
  2336. }
  2337. // add the ModelJoin to the current object
  2338. if($relationAlias) {
  2339. $this->addAlias($relationAlias, $relationMap->getRightTable()->getName());
  2340. $this->addJoinObject($join, $relationAlias);
  2341. } else {
  2342. $this->addJoinObject($join, 'CcBlockcontents');
  2343. }
  2344. return $this;
  2345. }
  2346. /**
  2347. * Use the CcBlockcontents relation CcBlockcontents object
  2348. *
  2349. * @see useQuery()
  2350. *
  2351. * @param string $relationAlias optional alias for the relation,
  2352. * to be used as main alias in the secondary query
  2353. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  2354. *
  2355. * @return CcBlockcontentsQuery A secondary query class using the current class as primary query
  2356. */
  2357. public function useCcBlockcontentsQuery($relationAlias = '', $joinType = Criteria::LEFT_JOIN)
  2358. {
  2359. return $this
  2360. ->joinCcBlockcontents($relationAlias, $joinType)
  2361. ->useQuery($relationAlias ? $relationAlias : 'CcBlockcontents', 'CcBlockcontentsQuery');
  2362. }
  2363. /**
  2364. * Filter the query by a related CcSchedule object
  2365. *
  2366. * @param CcSchedule $ccSchedule the related object to use as filter
  2367. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  2368. *
  2369. * @return CcFilesQuery The current query, for fluid interface
  2370. */
  2371. public function filterByCcSchedule($ccSchedule, $comparison = null)
  2372. {
  2373. return $this
  2374. ->addUsingAlias(CcFilesPeer::ID, $ccSchedule->getDbFileId(), $comparison);
  2375. }
  2376. /**
  2377. * Adds a JOIN clause to the query using the CcSchedule relation
  2378. *
  2379. * @param string $relationAlias optional alias for the relation
  2380. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  2381. *
  2382. * @return CcFilesQuery The current query, for fluid interface
  2383. */
  2384. public function joinCcSchedule($relationAlias = '', $joinType = Criteria::LEFT_JOIN)
  2385. {
  2386. $tableMap = $this->getTableMap();
  2387. $relationMap = $tableMap->getRelation('CcSchedule');
  2388. // create a ModelJoin object for this join
  2389. $join = new ModelJoin();
  2390. $join->setJoinType($joinType);
  2391. $join->setRelationMap($relationMap, $this->useAliasInSQL ? $this->getModelAlias() : null, $relationAlias);
  2392. if ($previousJoin = $this->getPreviousJoin()) {
  2393. $join->setPreviousJoin($previousJoin);
  2394. }
  2395. // add the ModelJoin to the current object
  2396. if($relationAlias) {
  2397. $this->addAlias($relationAlias, $relationMap->getRightTable()->getName());
  2398. $this->addJoinObject($join, $relationAlias);
  2399. } else {
  2400. $this->addJoinObject($join, 'CcSchedule');
  2401. }
  2402. return $this;
  2403. }
  2404. /**
  2405. * Use the CcSchedule relation CcSchedule object
  2406. *
  2407. * @see useQuery()
  2408. *
  2409. * @param string $relationAlias optional alias for the relation,
  2410. * to be used as main alias in the secondary query
  2411. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  2412. *
  2413. * @return CcScheduleQuery A secondary query class using the current class as primary query
  2414. */
  2415. public function useCcScheduleQuery($relationAlias = '', $joinType = Criteria::LEFT_JOIN)
  2416. {
  2417. return $this
  2418. ->joinCcSchedule($relationAlias, $joinType)
  2419. ->useQuery($relationAlias ? $relationAlias : 'CcSchedule', 'CcScheduleQuery');
  2420. }
  2421. /**
  2422. * Filter the query by a related CcPlayoutHistory object
  2423. *
  2424. * @param CcPlayoutHistory $ccPlayoutHistory the related object to use as filter
  2425. * @param string $comparison Operator to use for the column comparison, defaults to Criteria::EQUAL
  2426. *
  2427. * @return CcFilesQuery The current query, for fluid interface
  2428. */
  2429. public function filterByCcPlayoutHistory($ccPlayoutHistory, $comparison = null)
  2430. {
  2431. return $this
  2432. ->addUsingAlias(CcFilesPeer::ID, $ccPlayoutHistory->getDbFileId(), $comparison);
  2433. }
  2434. /**
  2435. * Adds a JOIN clause to the query using the CcPlayoutHistory relation
  2436. *
  2437. * @param string $relationAlias optional alias for the relation
  2438. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  2439. *
  2440. * @return CcFilesQuery The current query, for fluid interface
  2441. */
  2442. public function joinCcPlayoutHistory($relationAlias = '', $joinType = Criteria::LEFT_JOIN)
  2443. {
  2444. $tableMap = $this->getTableMap();
  2445. $relationMap = $tableMap->getRelation('CcPlayoutHistory');
  2446. // create a ModelJoin object for this join
  2447. $join = new ModelJoin();
  2448. $join->setJoinType($joinType);
  2449. $join->setRelationMap($relationMap, $this->useAliasInSQL ? $this->getModelAlias() : null, $relationAlias);
  2450. if ($previousJoin = $this->getPreviousJoin()) {
  2451. $join->setPreviousJoin($previousJoin);
  2452. }
  2453. // add the ModelJoin to the current object
  2454. if($relationAlias) {
  2455. $this->addAlias($relationAlias, $relationMap->getRightTable()->getName());
  2456. $this->addJoinObject($join, $relationAlias);
  2457. } else {
  2458. $this->addJoinObject($join, 'CcPlayoutHistory');
  2459. }
  2460. return $this;
  2461. }
  2462. /**
  2463. * Use the CcPlayoutHistory relation CcPlayoutHistory object
  2464. *
  2465. * @see useQuery()
  2466. *
  2467. * @param string $relationAlias optional alias for the relation,
  2468. * to be used as main alias in the secondary query
  2469. * @param string $joinType Accepted values are null, 'left join', 'right join', 'inner join'
  2470. *
  2471. * @return CcPlayoutHistoryQuery A secondary query class using the current class as primary query
  2472. */
  2473. public function useCcPlayoutHistoryQuery($relationAlias = '', $joinType = Criteria::LEFT_JOIN)
  2474. {
  2475. return $this
  2476. ->joinCcPlayoutHistory($relationAlias, $joinType)
  2477. ->useQuery($relationAlias ? $relationAlias : 'CcPlayoutHistory', 'CcPlayoutHistoryQuery');
  2478. }
  2479. /**
  2480. * Exclude object from result
  2481. *
  2482. * @param CcFiles $ccFiles Object to remove from the list of results
  2483. *
  2484. * @return CcFilesQuery The current query, for fluid interface
  2485. */
  2486. public function prune($ccFiles = null)
  2487. {
  2488. if ($ccFiles) {
  2489. $this->addUsingAlias(CcFilesPeer::ID, $ccFiles->getDbId(), Criteria::NOT_EQUAL);
  2490. }
  2491. return $this;
  2492. }
  2493. } // BaseCcFilesQuery