Commit Graph

300 Commits

Author SHA1 Message Date
drigato 6fa7ddba9a CC-5896: Store cloud files in separate table, inherited from cc_files
Added delete on cascade for cloud files
2014-07-28 16:03:57 -04:00
drigato f1ea100411 CC-5896: Store cloud files in separate table, inherited from cc_files 2014-07-24 16:56:15 -04:00
drigato 41ff0cce67 CC-5896: Store cloud files in separate table, inherited from cc_files
Using Class Table Inheritance - delegate behaviour, created a cloud_file
table to store cloud files
2014-07-23 15:22:42 -04:00
drigato 72841de714 CC-5895: Upgrade Propel to 1.7
Used composer to download Propel 1.7
The Propel library will no longer be stored in the Airtime repo
2014-07-23 15:03:51 -04:00
drigato aeb3bb7aa0 SAAS-447: Cloud Storage
Added resource_id column to cc_files table
2014-07-04 16:34:00 -04:00
Naomi fe20cc7f63 Merge branch '2.5.x' into cc-5709-airtime-analyzer
Conflicts:
	airtime_mvc/locale/de_DE/LC_MESSAGES/airtime.po
	airtime_mvc/locale/es_ES/LC_MESSAGES/airtime.po
	airtime_mvc/locale/hr_HR/LC_MESSAGES/airtime.po
	airtime_mvc/locale/hu_HU/LC_MESSAGES/airtime.po
	airtime_mvc/locale/sr_RS/LC_MESSAGES/airtime.po
	airtime_mvc/locale/sr_RS@latin/LC_MESSAGES/airtime.po
2014-04-23 15:58:39 -04:00
Naomi 578f758274 CC-5810 : Installation can have race conditions with the cache
Preferences.php is used to set values since it will save the value to cache there as well.

defaultdata.sql is used where possible.
2014-04-23 15:41:15 -04:00
drigato 70228a675e Changed default import_status value on cc_files table to 1 (pending) 2014-04-01 11:28:33 -04:00
Albert Santoni 6e6d20d3fc Merge branch '2.5.x-serbian-croatian' of https://github.com/danielhjames/Airtime into 2.5.x
Conflicts:
	airtime_mvc/locale/hr_HR/LC_MESSAGES/airtime.mo
	airtime_mvc/locale/hr_HR/LC_MESSAGES/airtime.po
	airtime_mvc/locale/hu_HU/LC_MESSAGES/airtime.mo
	airtime_mvc/locale/hu_HU/LC_MESSAGES/airtime.po
	airtime_mvc/locale/sr_RS/LC_MESSAGES/airtime.mo
	airtime_mvc/locale/sr_RS/LC_MESSAGES/airtime.po
	airtime_mvc/locale/sr_RS@latin/LC_MESSAGES/airtime.mo
	airtime_mvc/locale/sr_RS@latin/LC_MESSAGES/airtime.po
2014-04-01 10:30:00 -04:00
Albert Santoni 8f7ecafcf6 CC-5709: Airtime Analyzer
* A bunch of changes that somehow didn't make it into my last commit...
* confused
2014-03-21 14:03:17 -04:00
Albert Santoni 878dd11ccc CC-5709: Airtime Analyzer
* Overhauled Add Media screen, now shows state of recent uploads
* Dropped old unused "state" column, added new file_import column to cc_files
* New PluploadController methods
* Save the filename as the track title for unprocessed uploads
* Hide pending files from the library until they've been processed.
* Don't overwrite files with duplicate names, we rename them instead.
2014-03-21 13:22:00 -04:00
Daniel James eb35dcac5f Added Serbian Cyrillic, Serbian Latin and Croatian, thanks Zsolt! 2014-01-29 17:54:28 +00:00
Albert Santoni fe9beec778 CC-5651: Unit Test the Scheduler
* Added runtests.sh script for unit tests
* Use the airtime_test database config in Config.php, propel
* First unit test passes! :-)
2014-01-13 11:43:17 -05:00
Naomi 7d739a0f66 CC-5316 : Playout History: Doesn't support webstream
adding the webstream metadata to the history table.
2013-09-30 13:56:27 -04:00
Naomi 075342c637 don't delete a history item if a show instance is removed from the database. 2013-08-30 16:43:05 -04:00
Naomi 4fd37a4fa0 Merge branch '2.4.x' into ryerson-history 2013-08-30 16:07:41 -04:00
Naomi 5aa983be36 adding an instance id to the playout history table. 2013-08-28 17:15:36 -04:00
Naomi 969889859b improper naming of propel tables in php caused cc_mount_name to not get any generated files, double declaration of some variables for cc_timestamp. 2013-08-28 13:07:55 -04:00
Naomi 27b079ace9 adding a label to the form fields (Datatables column headers) 2013-08-07 17:55:18 -04:00
Naomi 7ca3048f36 can add a new list item using the template.
set a default item template

working on sql to get a table with unified columns for file md and manually entered metadata without a file.
2013-07-30 19:24:05 -04:00
Naomi 06e21029d0 saving a template to the DB. 2013-07-29 17:35:07 -04:00
Naomi 8eecbb18c0 propel rename done for template fields, template name input. 2013-07-29 17:21:46 -04:00
Naomi 16581088d9 working on configuring an item template UI.
modified db to have fields concept for templates.
2013-07-29 16:31:01 -04:00
Naomi 69afc715d1 creating templates for validation. 2013-07-22 18:11:44 -04:00
Naomi 328c1f3cac IM-733 Create Development timetable for Airtime Development
IM-777
Database structure for new History Feature
2013-07-03 15:19:05 -04:00
denise dc664ad9ff CC-5156: Hungarian language is shown in strange font on login page 2013-05-17 11:05:38 -04:00
denise f4d313a67c Hungarian translation locale option 2013-05-16 12:50:12 -04:00
Naomi 92ef0608d6 Merge branch 'master' into CC-2301 2013-05-01 11:04:14 -04:00
Naomi 0db557a570 CC-2301 : fades editor saving offset to database for playlists and smart blocks. 2013-04-30 15:32:43 -04:00
Naomi 410d298272 CC-2301 : creating an offset column to help create crossfades in the playlist.
changing default fade to be a separate default fade in/out
2013-04-29 16:55:08 -04:00
denise 71526a94cc Merge branch 'cc-4961-show-linking'
Conflicts:
	airtime_mvc/application/controllers/ScheduleController.php
2013-04-29 15:35:16 -04:00
Martin Konecny 3a931f27bf CC-4417: Opus codec support 2013-04-26 17:54:29 -04:00
Martin Konecny 6cc366b100 CC-5069:
Airtime 2.4 upgrade scripts

-initial commit
2013-04-26 13:43:40 -04:00
denise 52655ab375 CC-4961: Show linking 2013-04-26 13:43:30 -04:00
Naomi 13c8e5f146 CC-2301 : showing waveform cue/fade editors inside of a jquery dialog box. 2013-04-16 14:37:08 -04:00
denise 9b4a0ba9c1 CC-4961: Show linking
Removed stamp tables
2013-04-12 10:52:13 -04:00
denise 9b2fb3bece CC-4961: Show linking 2013-04-09 15:55:18 -04:00
denise 76bfce21b1 CC-4961: Show linking
-modified db
2013-04-08 14:42:37 -04:00
denise cfee74693b CC-4961: Show linking
moved move-show to calendar service
2013-04-05 17:44:30 -04:00
denise 62d1b22fcc CC-4961: Show linking
created new cc_show_stamp table
2013-04-05 12:27:54 -04:00
denise f9d7167638 CC-4961: Show linking 2013-04-04 16:30:33 -04:00
denise b40306cb1b Add comment to schema.xml to indicate what the broadcasted column is of cc_schedule 2013-04-03 16:21:30 -04:00
Martin Konecny 563f5b64d2 Merge branch '2.3.x' into devel
Conflicts:
	debian/postinst
2013-04-02 12:31:48 -04:00
Daniel James 860524a873 Added locales for English localizations 2013-04-02 17:19:48 +01:00
Daniel James ebbb9f1b9c Added Austrian German localization, thanks Hoerich! 2013-04-02 17:06:16 +01:00
denise ec159131a8 Merge branch '2.3.x' into devel 2013-02-13 16:09:53 -05:00
denise 93017b8477 Added Greek datatables and plupload language files
Added Greek to locale db table
2013-02-07 16:43:24 -05:00
denise 7cf45afd16 Changed 'Polish' to 'Polski' 2013-02-06 17:03:01 -05:00
denise 532ea09eed Added Polish datatables and plupload translation files
Added Polish to upgrade script and default data
2013-02-06 16:46:12 -05:00
denise 23c29455d9 Modified schema.xml - made cue_in and cue_out required columns in cc_scheuled and removed default values 2013-02-05 13:18:25 -05:00
denise 8309593a0f CC-4904: Library -> Sort by status doesn't work
- added 2 columns to cc_files (is_scheduled, is_playlist)
- split library status column into two columns (scheduled, playlist)
- is_scheduled gets updated when a track plays out, or when a file gets added/removed from/to a show
- is_playlist gets updated when a file gets added/removed from/to a playlist/block, when a playlist/block gets deleted, or when a playlist/block's contents is cleared
2013-02-01 17:47:07 -05:00
drigato c13188d0e1 Added Czech and Brazilian Portuguese language options 2013-01-21 14:56:27 -05:00
James ed7b22118c Merge branch 'silan-script' into devel 2013-01-18 11:54:10 -05:00
denise b7fb7a4166 Removed English-US language option 2013-01-16 11:49:04 -05:00
denise bbedce2951 Changed default base directory in airtime.conf and api_client.cfg 2013-01-15 13:47:35 -05:00
James bb2f9316af CC-4841: Silan script
- temp commit
2013-01-15 11:16:50 -05:00
denise 1c0d8abd4c CC-4807: Names of languages need to be localized
-done
2013-01-11 14:44:14 -05:00
James 55fa8b8dc1 Merge branch 'devel' of dev.sourcefabric.org:airtime into devel 2013-01-10 14:52:45 -05:00
James 048ee05030 CC-4821: Add option to disable ReplayGain
- done
2013-01-10 13:49:41 -05:00
denise 690a6d2654 Removed user id from cc_pref keystr value 2013-01-10 12:04:27 -05:00
James 1263c04621 CC-4796: Listener Stat: Authentication exception happens but no warning message on UI
- done
2013-01-08 17:32:27 -05:00
James adda497bbb CC-4812: Property "off_air_meta" will block airtime-liquidsoap to start
- fixed
2013-01-08 15:52:11 -05:00
James 6e241fd3ec CC-4512: Allow changing stream "Offline" message via Web UI
- fixed
2013-01-07 18:14:57 -05:00
James 5d76bb2d17 Merge branch 'devel' of dev.sourcefabric.org:airtime into devel 2013-01-03 18:00:33 -05:00
James ae7b6fe092 CC-4732: Ask for admin username + password in Stream Settings page
- done
2013-01-03 17:58:50 -05:00
denise e2c87ed8b6 CC-4781: Store localization settings on a per-user basis
-done
2013-01-03 16:19:02 -05:00
James a1837366be Merge branch 'cc-3018-silence-detection' into devel 2013-01-03 14:08:21 -05:00
James b8f80866cf CC-3018: Automatically strip out silence from audio tracks
- done
2013-01-03 14:02:06 -05:00
denise a725148832 CC-4775: Add option for Italian language in preferences
-done
2013-01-02 12:10:16 -05:00
denise 93ea912d54 CC-4774: Add option for Chinese in preferences
-done
2013-01-02 11:50:10 -05:00
denise 854537f387 CC-4745: Add Russian language option to preferences 2012-12-17 14:33:14 -05:00
denise 83ae677301 -added german, and spanish locales into locale table 2012-12-04 12:07:29 -05:00
denise 4515ac2aef - added french .po file
- added french translations for datatables and plupload plugins
2012-12-03 18:15:08 -05:00
denise 2f0c6b702a CC-1960: Internationalize Airtime / Support translations
- created locale table
- create locale model
- set default locale in pref table
2012-11-29 18:21:03 -05:00
denise 0e3525180e CC-1960: Internationalize Airtime / Support translations
-added default locale into cc_pref
2012-11-29 10:57:59 -05:00
James 7300b608cf Merge branch 'cc-4661-listener-statistics' into devel
Conflicts:
	python_apps/api_clients/api_client.py
2012-11-07 17:20:12 -05:00
Martin Konecny 080c3ec944 CC-4661: Listener Statistics
-factor out mountname into it's own table
2012-11-05 15:38:35 -05:00
Martin Konecny d467abe509 Merge branch 'cc-4585' of https://github.com/rgrinberg/Airtime into devel 2012-11-05 11:27:34 -05:00
James 8b70136dd6 CC-4661: Listener Statistics
- db change commit
2012-11-02 17:44:06 -04:00
Rudi Grinberg 5cb83909d8 Merge remote-tracking branch 'sf/2.2.x' into cc-4585 2012-11-02 16:00:09 -04:00
denise 135aadf16b Merge branch '2.2.x' into devel
Conflicts:
	airtime_mvc/application/controllers/LibraryController.php
	airtime_mvc/application/views/scripts/library/library.phtml
	airtime_mvc/public/js/airtime/showbuilder/builder.js
	airtime_mvc/public/js/airtime/showbuilder/main_builder.js
2012-11-02 12:28:21 -04:00
Martin Konecny 3478797744 cc-4661: new database tables for listener stats 2012-11-02 11:32:02 -04:00
James feb6c9d6f5 CC-4636: Exception happens when trying to remove user that have created some smart block
- doing delete cascade on cc_block on deleting users
2012-11-01 17:45:28 -04:00
Rudi Grinberg 4cca80fe44 Added schema changes 2012-10-31 16:23:12 -04:00
Rudi Grinberg a3a2edc3f1 Added column for files that have been deleted by user 2012-10-31 14:53:36 -04:00
Rudi Grinberg dc00528cd5 Merged baseUrl related conflicts 2012-10-29 11:56:20 -04:00
Martin Konecny 2d6be404d4 cc-4304: fixed ticket by deleting playlists when user is deleted. also removed useless index on file_exists
-regen propel files
2012-10-23 13:45:15 -04:00
Rudi Grinberg 50d09d09d3 cc-4304: fixed ticket by deleting playlists when user is deleted. also removed useless index on file_exists 2012-10-23 12:08:01 -04:00
Martin Konecny 8b9b005708 CC-4612: Create index for cc_schedule during upgrade to improve the performance when cc_schedule's getting bigger
- also create one during fresh install
2012-10-22 17:29:26 -04:00
denise d32495d100 CC-2184: Hardcoded CSS path should be relative path instead 2012-10-19 11:09:34 -04:00
James ba37bb4327 CC-4005: Tag files with Last Played date and number of times played
- done for files and webstreams
2012-09-10 18:01:36 -04:00
James 4d3c624607 CC-4380: Show ReplayGain value in the Library page
- temp commit
2012-09-10 12:35:32 -04:00
Martin Konecny 4b09d5eff2 CC-4199: Webstream: Please show warning when the URL is too long
-upped max webstream length to 512
-show warning if > 512 characters
2012-09-04 16:18:18 -04:00
Martin Konecny cd49f99f4b CC-3412: Icecast stream name not defined
-ensure upgrade
2012-08-30 11:29:23 -04:00
Martin Konecny 859445c766 CC-3301: Add ability to switch stereo/mono stream in stream settings
-fixed
2012-08-29 17:39:24 -04:00
James bc660c4cdf -removing type column from cc_playlist 2012-08-24 17:12:52 -04:00
Rudi Grinberg 4efdf71aea cc-3936: Made phpName of foreign key conform to Fk prefix convention. 2012-08-24 11:10:05 -04:00
Rudi Grinberg 60803e5146 cc-3936:
Name of foreign key was given for easier access through propel. Also renamed phpName for ownerId
to fit the existing convention.
2012-08-24 10:20:59 -04:00
Rudi Grinberg 996dcfd35f cc-3936: Ran propgen to generate schema changes 2012-08-24 10:20:59 -04:00
Rudi Grinberg e2d9f220f8 cc-3936:
Changed schema so that owner_id is not required for every file.
2012-08-24 10:20:59 -04:00
Rudi Grinberg dcfa865f7d cc-3936:
Ran propel-gen to commit schema changes.
2012-08-24 10:20:58 -04:00
Rudi Grinberg 4f88543de2 cc-3936:
Updated schema so that every file has an owner.
2012-08-24 10:20:58 -04:00
Martin Konecny f3f9ef80ff CC-4119: zendphp.log is not rotated
-fixed
2012-08-20 16:05:25 -04:00
Martin Konecny f6a4732e87 CC-4119: zendphp.log is not rotated
-fixed
2012-08-20 15:54:10 -04:00
Martin Konecny 2a1ea33362 CC-1665: Scheduled stream rebroadcasting and recording
-store Liquidsoap metadata in cc_schedule instead of cc_webstream
2012-08-17 15:07:58 -04:00
denise ea621fd9dc CC-4223: Smart playlists: BPM criteria should have numeric modifiers
-done
2012-08-15 16:40:04 -04:00
Martin Konecny d773dcd112 CC-1665: Scheduled stream rebroadcasting and recording
-send stream name back to Airtime: [("url","http://idobiradio.com/"), ("title","Good Charlotte - Like It's Her Birthday")]
2012-08-15 15:12:44 -04:00
Martin Konecny fe3f4ea678 CC-1665: Scheduled stream rebroadcasting and recording
-capture stream mime type and store in db.
2012-08-10 00:57:03 -04:00
Martin Konecny 688051b59e CC-1665: Scheduled stream rebroadcasting and recording
-Remove sX_name from being inserted into DB
2012-08-03 18:45:43 -04:00
Martin Konecny f901e13a84 CC-1665: Scheduled stream rebroadcasting and recording
-Make playlist builder show creator name instead of creator id
2012-08-03 18:06:47 -04:00
denise 483ffdf6af CC-84: Smart Playlists
- increased size of criteria column
- it was too smallf for some fields
2012-08-01 16:25:59 -04:00
Martin Konecny 7e433b61fb CC-1665: Scheduled stream rebroadcasting and recording
-improve working with "webstreams"
2012-07-30 21:48:04 -04:00
James 5becd70ab1 CC-84: Smart Playlists
- drag and drop playlist that contains block
- audio preview of playlist that contains static block
2012-07-27 11:51:50 -04:00
James 8f2339f109 Merge branch 'devel' of dev.sourcefabric.org:airtime into devel
Conflicts:
	airtime_mvc/application/models/airtime/map/CcPlaylistcontentsTableMap.php
	airtime_mvc/build/schema.xml
	airtime_mvc/build/sql/schema.sql
2012-07-26 14:54:47 -04:00
James a51b04e422 CC-84: Smart Playlists
- db schema change for type column on playlistcontents
2012-07-26 14:49:42 -04:00
Martin Konecny c90495d2d3 CC-1665: Scheduled stream rebroadcasting and recording
-getting closer to being able to schedule a webstream
2012-07-26 14:49:32 -04:00
Martin Konecny 3735579378 -remove cc_access table and gunid usage 2012-07-26 14:49:32 -04:00
Martin Konecny 8b2facaa96 CC-1665: Scheduled stream rebroadcasting and recording
-playlists load contents now correctly identify tracks vs streams
2012-07-26 14:49:32 -04:00
Martin Konecny a16a1f5033 CC-1665: Scheduled stream rebroadcasting and recording
-Webstreams now appearing in the library
2012-07-26 14:49:31 -04:00
James 1f3cbd8aba CC-84: Smart Playlists
- introducing smart-block
2012-07-25 12:44:37 -04:00
James ef64ce2b73 CC-4112: Smart Playlist: Cannot search Long string
- added length validator
- extra fix: Due to lazy loading, aggregated field on playlist was not
updated properly.
2012-07-20 15:32:46 -04:00
James 9516771099 Merge branch 'cc-84-smart-playlist' into devel
Conflicts:
	airtime_mvc/application/controllers/PlaylistController.php
	airtime_mvc/application/models/Scheduler.php
2012-07-18 12:23:57 -04:00
Martin Konecny 312f35ae48 CC-430: Audio normalization (Replaygain Support)
-change default database value to null
2012-07-16 12:10:42 -04:00
Martin Konecny 583695f98c CC-430: Audio normalization (Replaygain Support)
-values are now written through to database
2012-07-15 22:22:42 -04:00
James 3bce6b4999 CC-84: Smart Playlists
- db inserting into cc_playlistcriteria
- error validations
2012-07-12 17:58:44 -04:00
Martin Konecny ce755d409b cc-84: smart playlist
-added new database table defs
2012-07-11 15:48:11 -04:00
Martin Konecny 24349e64d8 CC-430: Audio normalization (Replaygain Support)
-some minor fixes for default value (should be 0 dB not 1dB)
2012-07-05 23:30:53 -04:00
Martin Konecny ce698d4123 CC-430: Audio normalization (Replaygain Support)
-Added support on server side
2012-07-05 22:37:40 -04:00
denise 9cabd4d32c CC-3921: Add mobile phone number field to user record
-done
2012-06-13 13:39:54 -04:00
denise f3b925daa2 CC-3412: Icecast stream name not defined
-done
2012-06-12 17:08:36 -04:00
James 6da923ace1 CC-3859: Playout History: Filter out songs that are not played out
- db change and upgrade.
2012-05-22 16:11:25 -04:00
denise 195d0d8311 SAAS-223: Airtime Usage Metric: Amount of time spent broadcasting
-calculated scheduled usage
2012-05-11 16:09:36 -04:00
denise bcf11bcb95 - removed default value from cc_live_log - end_time column 2012-05-11 16:09:35 -04:00
denise b448d188ea SAAS-223: Airtime Usage Metric: Amount of time spent broadcasting
-modified db schema
2012-05-11 16:06:28 -04:00
denise e347819c77 SAAS-223: Airtime Usage Metric: Amount of time spent broadcasting
-created cc_live_log table
2012-05-11 16:06:28 -04:00
denise 678e573e7a SAAS-157: Automated metrics: gather info about soundcloud usage
-done
2012-05-07 11:24:40 -04:00
James 8bd3a35789 CC-3683: Upgraded database not equivalent to fresh install database part 1
- fixed
2012-04-19 11:24:30 -04:00
Naomi Aro a0fb607d30 Merge branch 'CC-3174' into devel 2012-04-16 16:40:02 +02:00
Naomi Aro c96c60dc5a CC-3620 : Calendar -> Unresponsive script warning when trying to add 300 ogg files
improving speed of js rendering,
datatables config is loaded from localstorage,
removed aggregate propel behaviour on cc_show_instances time_filled.
2012-04-16 16:33:32 +02:00
Martin Konecny 8442932b7d CC-3520: Change default password of monit
-fix names
2012-04-13 17:07:59 -04:00
Naomi Aro 428d04d77f CC-3605 : Create 2.1 upgrades 2012-04-10 18:07:39 +02:00
James a49a3a1d2e CC-3482: Live Stream: UI Design for Source Stream panel on dashboard
- master panel UI integration
2012-04-03 11:58:48 -04:00
james 478cb57228 CC-3527: Airtime reinstallation-> it would be better to have 'Scheduled Play'
thread enabled

- set default data for this switch
2012-03-28 09:48:45 -04:00
Naomi Aro 4904a16ebb CC-3534 : Check Scheduling Edge Cases
extracting out error checking in scheduling, added created column to cc_showinstances
2012-03-28 14:23:25 +02:00
Martin Konecny d7b05827e6 CC-3477: Apache complains the # symbol is deprecated. Use ; instead
-done
2012-03-19 17:35:20 -04:00
Martin Konecny 9be6f1bd0e CC-3464: Playout forward cache should be configurable
-Done
2012-03-17 14:53:15 -04:00
James 540f262a77 CC-3224: "On-the-fly" stream rebroadcasting
- removed "Allow override" checkbox from show live stream section.
- removed "auto enable live stream" checkbox from stream setting page.
- implemented authentication functionality of live dj source connection.
2012-03-14 14:43:10 -04:00
James 48bb19d758 CC-3224: "On-the-fly" stream rebroadcasting
- web interface
- auth script for liquidsoap
- DB changes
2012-03-14 14:41:00 -04:00
Naomi Aro 6c749075ac CC-3369 : Ability to identify tracks that are actually inside a show in the schedule table
chaning column name to playout_status
2012-03-02 12:22:08 +01:00
Naomi Aro 0f9800a6bd CC-3369 : Ability to identify tracks that are actually inside a show in the schedule table 2012-03-01 14:59:06 +01:00