@@ -16,27 +16,27 @@ discard block |
||
| 16 | 16 | class m5_end_date extends \phpbb\db\migration\migration |
| 17 | 17 | { |
| 18 | 18 | /** |
| 19 | - * {@inheritDoc} |
|
| 20 | - */ |
|
| 19 | + * {@inheritDoc} |
|
| 20 | + */ |
|
| 21 | 21 | public function effectively_installed() |
| 22 | 22 | { |
| 23 | 23 | return $this->db_tools->sql_column_exists($this->table_prefix . 'ads', 'end_date'); |
| 24 | 24 | } |
| 25 | 25 | |
| 26 | 26 | /** |
| 27 | - * {@inheritDoc} |
|
| 28 | - */ |
|
| 27 | + * {@inheritDoc} |
|
| 28 | + */ |
|
| 29 | 29 | static public function depends_on() |
| 30 | 30 | { |
| 31 | 31 | return array('\phpbb\admanagement\migrations\v10x\m4_indexes'); |
| 32 | 32 | } |
| 33 | 33 | |
| 34 | 34 | /** |
| 35 | - * Add the end date to ads table |
|
| 36 | - * |
|
| 37 | - * @return array Array of table schema |
|
| 38 | - * @access public |
|
| 39 | - */ |
|
| 35 | + * Add the end date to ads table |
|
| 36 | + * |
|
| 37 | + * @return array Array of table schema |
|
| 38 | + * @access public |
|
| 39 | + */ |
|
| 40 | 40 | public function update_schema() |
| 41 | 41 | { |
| 42 | 42 | return array( |
@@ -49,11 +49,11 @@ discard block |
||
| 49 | 49 | } |
| 50 | 50 | |
| 51 | 51 | /** |
| 52 | - * Drop the end date from ads table |
|
| 53 | - * |
|
| 54 | - * @return array Array of table schema |
|
| 55 | - * @access public |
|
| 56 | - */ |
|
| 52 | + * Drop the end date from ads table |
|
| 53 | + * |
|
| 54 | + * @return array Array of table schema |
|
| 55 | + * @access public |
|
| 56 | + */ |
|
| 57 | 57 | public function revert_schema() |
| 58 | 58 | { |
| 59 | 59 | return array( |
@@ -22,12 +22,12 @@ discard block |
||
| 22 | 22 | protected $ad_locations_table; |
| 23 | 23 | |
| 24 | 24 | /** |
| 25 | - * Constructor |
|
| 26 | - * |
|
| 27 | - * @param \phpbb\db\driver\driver_interface $db DB driver interface |
|
| 28 | - * @param string $ads_table Ads table |
|
| 29 | - * @param string $ad_locations_table Ad locations table |
|
| 30 | - */ |
|
| 25 | + * Constructor |
|
| 26 | + * |
|
| 27 | + * @param \phpbb\db\driver\driver_interface $db DB driver interface |
|
| 28 | + * @param string $ads_table Ads table |
|
| 29 | + * @param string $ad_locations_table Ad locations table |
|
| 30 | + */ |
|
| 31 | 31 | public function __construct(\phpbb\db\driver\driver_interface $db, $ads_table, $ad_locations_table) |
| 32 | 32 | { |
| 33 | 33 | $this->db = $db; |
@@ -36,11 +36,11 @@ discard block |
||
| 36 | 36 | } |
| 37 | 37 | |
| 38 | 38 | /** |
| 39 | - * Get specific ad |
|
| 40 | - * |
|
| 41 | - * @param int $ad_id Advertisement ID |
|
| 42 | - * @return array Advertisement data |
|
| 43 | - */ |
|
| 39 | + * Get specific ad |
|
| 40 | + * |
|
| 41 | + * @param int $ad_id Advertisement ID |
|
| 42 | + * @return array Advertisement data |
|
| 43 | + */ |
|
| 44 | 44 | public function get_ad($ad_id) |
| 45 | 45 | { |
| 46 | 46 | $sql = 'SELECT * |
@@ -54,11 +54,11 @@ discard block |
||
| 54 | 54 | } |
| 55 | 55 | |
| 56 | 56 | /** |
| 57 | - * Get one ad per every location |
|
| 58 | - * |
|
| 59 | - * @param array $ad_locations List of ad locations to fetch ads for |
|
| 60 | - * @return array List of ad codes for each location |
|
| 61 | - */ |
|
| 57 | + * Get one ad per every location |
|
| 58 | + * |
|
| 59 | + * @param array $ad_locations List of ad locations to fetch ads for |
|
| 60 | + * @return array List of ad codes for each location |
|
| 61 | + */ |
|
| 62 | 62 | public function get_ads($ad_locations) |
| 63 | 63 | { |
| 64 | 64 | $sql = 'SELECT location_id, ad_code |
@@ -82,10 +82,10 @@ discard block |
||
| 82 | 82 | } |
| 83 | 83 | |
| 84 | 84 | /** |
| 85 | - * Get all advertisements |
|
| 86 | - * |
|
| 87 | - * @return array List of all ads |
|
| 88 | - */ |
|
| 85 | + * Get all advertisements |
|
| 86 | + * |
|
| 87 | + * @return array List of all ads |
|
| 88 | + */ |
|
| 89 | 89 | public function get_all_ads() |
| 90 | 90 | { |
| 91 | 91 | $sql = 'SELECT ad_id, ad_name, ad_enabled, ad_end_date |
@@ -98,11 +98,11 @@ discard block |
||
| 98 | 98 | } |
| 99 | 99 | |
| 100 | 100 | /** |
| 101 | - * Insert new advertisement to the database |
|
| 102 | - * |
|
| 103 | - * @param array $data New ad data |
|
| 104 | - * @return int New advertisement ID |
|
| 105 | - */ |
|
| 101 | + * Insert new advertisement to the database |
|
| 102 | + * |
|
| 103 | + * @param array $data New ad data |
|
| 104 | + * @return int New advertisement ID |
|
| 105 | + */ |
|
| 106 | 106 | public function insert_ad($data) |
| 107 | 107 | { |
| 108 | 108 | $data = $this->intersect_ad_data($data); |
@@ -114,12 +114,12 @@ discard block |
||
| 114 | 114 | } |
| 115 | 115 | |
| 116 | 116 | /** |
| 117 | - * Update advertisement |
|
| 118 | - * |
|
| 119 | - * @param int $ad_id Advertisement ID |
|
| 120 | - * @param array $data List of data to update in the database |
|
| 121 | - * @return int Number of affected rows. Can be used to determine if any ad has been updated. |
|
| 122 | - */ |
|
| 117 | + * Update advertisement |
|
| 118 | + * |
|
| 119 | + * @param int $ad_id Advertisement ID |
|
| 120 | + * @param array $data List of data to update in the database |
|
| 121 | + * @return int Number of affected rows. Can be used to determine if any ad has been updated. |
|
| 122 | + */ |
|
| 123 | 123 | public function update_ad($ad_id, $data) |
| 124 | 124 | { |
| 125 | 125 | $data = $this->intersect_ad_data($data); |
@@ -133,11 +133,11 @@ discard block |
||
| 133 | 133 | } |
| 134 | 134 | |
| 135 | 135 | /** |
| 136 | - * Delete advertisement |
|
| 137 | - * |
|
| 138 | - * @param int $ad_id Advertisement ID |
|
| 139 | - * @return int Number of affected rows. Can be used to determine if any ad has been deleted. |
|
| 140 | - */ |
|
| 136 | + * Delete advertisement |
|
| 137 | + * |
|
| 138 | + * @param int $ad_id Advertisement ID |
|
| 139 | + * @return int Number of affected rows. Can be used to determine if any ad has been deleted. |
|
| 140 | + */ |
|
| 141 | 141 | public function delete_ad($ad_id) |
| 142 | 142 | { |
| 143 | 143 | $sql = 'DELETE FROM ' . $this->ads_table . ' |
@@ -148,11 +148,11 @@ discard block |
||
| 148 | 148 | } |
| 149 | 149 | |
| 150 | 150 | /** |
| 151 | - * Get all locations for specified advertisement |
|
| 152 | - * |
|
| 153 | - * @param int $ad_id Advertisement ID |
|
| 154 | - * @return array List of template locations for specified ad |
|
| 155 | - */ |
|
| 151 | + * Get all locations for specified advertisement |
|
| 152 | + * |
|
| 153 | + * @param int $ad_id Advertisement ID |
|
| 154 | + * @return array List of template locations for specified ad |
|
| 155 | + */ |
|
| 156 | 156 | public function get_ad_locations($ad_id) |
| 157 | 157 | { |
| 158 | 158 | $ad_locations = array(); |
@@ -171,12 +171,12 @@ discard block |
||
| 171 | 171 | } |
| 172 | 172 | |
| 173 | 173 | /** |
| 174 | - * Insert advertisement locations |
|
| 175 | - * |
|
| 176 | - * @param int $ad_id Advertisement ID |
|
| 177 | - * @param array $ad_locations List of template locations for this ad |
|
| 178 | - * @return void |
|
| 179 | - */ |
|
| 174 | + * Insert advertisement locations |
|
| 175 | + * |
|
| 176 | + * @param int $ad_id Advertisement ID |
|
| 177 | + * @param array $ad_locations List of template locations for this ad |
|
| 178 | + * @return void |
|
| 179 | + */ |
|
| 180 | 180 | public function insert_ad_locations($ad_id, $ad_locations) |
| 181 | 181 | { |
| 182 | 182 | $sql_ary = array(); |
@@ -191,11 +191,11 @@ discard block |
||
| 191 | 191 | } |
| 192 | 192 | |
| 193 | 193 | /** |
| 194 | - * Delete advertisement locations |
|
| 195 | - * |
|
| 196 | - * @param int $ad_id Advertisement ID |
|
| 197 | - * @return void |
|
| 198 | - */ |
|
| 194 | + * Delete advertisement locations |
|
| 195 | + * |
|
| 196 | + * @param int $ad_id Advertisement ID |
|
| 197 | + * @return void |
|
| 198 | + */ |
|
| 199 | 199 | public function delete_ad_locations($ad_id) |
| 200 | 200 | { |
| 201 | 201 | $sql = 'DELETE FROM ' . $this->ad_locations_table . ' |
@@ -204,11 +204,11 @@ discard block |
||
| 204 | 204 | } |
| 205 | 205 | |
| 206 | 206 | /** |
| 207 | - * Make sure only necessary data make their way to SQL query |
|
| 208 | - * |
|
| 209 | - * @param array $data List of data to query the database |
|
| 210 | - * @return array Cleaned data that contain only valid keys |
|
| 211 | - */ |
|
| 207 | + * Make sure only necessary data make their way to SQL query |
|
| 208 | + * |
|
| 209 | + * @param array $data List of data to query the database |
|
| 210 | + * @return array Cleaned data that contain only valid keys |
|
| 211 | + */ |
|
| 212 | 212 | protected function intersect_ad_data($data) |
| 213 | 213 | { |
| 214 | 214 | return array_intersect_key($data, array( |
@@ -221,10 +221,10 @@ discard block |
||
| 221 | 221 | } |
| 222 | 222 | |
| 223 | 223 | /** |
| 224 | - * Get the random statement for this database layer |
|
| 225 | - * |
|
| 226 | - * @return string Random statement for current database layer |
|
| 227 | - */ |
|
| 224 | + * Get the random statement for this database layer |
|
| 225 | + * |
|
| 226 | + * @return string Random statement for current database layer |
|
| 227 | + */ |
|
| 228 | 228 | protected function sql_random() |
| 229 | 229 | { |
| 230 | 230 | switch ($this->db->get_sql_layer()) |