domainmod /
domainmod
| @@ 146-207 (lines=62) @@ | ||
| 143 | FROM fees |
|
| 144 | WHERE fee_fixed = '0'")->fetchAll(); |
|
| 145 | ||
| 146 | if ($result) { |
|
| 147 | ||
| 148 | $stmt = $pdo->prepare(" |
|
| 149 | UPDATE domains |
|
| 150 | SET fee_id = :fee_id |
|
| 151 | WHERE registrar_id = :registrar_id |
|
| 152 | AND tld = :tld |
|
| 153 | AND fee_fixed = '0'"); |
|
| 154 | $stmt->bindParam('fee_id', $bind_fee_id, \PDO::PARAM_INT); |
|
| 155 | $stmt->bindParam('registrar_id', $bind_registrar_id, \PDO::PARAM_INT); |
|
| 156 | $stmt->bindParam('tld', $bind_tld, \PDO::PARAM_STR); |
|
| 157 | ||
| 158 | $stmt2 = $pdo->prepare(" |
|
| 159 | UPDATE domains d |
|
| 160 | JOIN fees f ON d.fee_id = f.id |
|
| 161 | SET d.fee_fixed = '1', |
|
| 162 | d.total_cost = f.renewal_fee + f.privacy_fee + f.misc_fee |
|
| 163 | WHERE d.registrar_id = :registrar_id |
|
| 164 | AND d.tld = :tld |
|
| 165 | AND d.privacy = '1'"); |
|
| 166 | $stmt2->bindParam('registrar_id', $bind_registrar_id, \PDO::PARAM_INT); |
|
| 167 | $stmt2->bindParam('tld', $bind_tld, \PDO::PARAM_STR); |
|
| 168 | ||
| 169 | $stmt3 = $pdo->prepare(" |
|
| 170 | UPDATE domains d |
|
| 171 | JOIN fees f ON d.fee_id = f.id |
|
| 172 | SET d.fee_fixed = '1', |
|
| 173 | d.total_cost = f.renewal_fee + f.misc_fee |
|
| 174 | WHERE d.registrar_id = :registrar_id |
|
| 175 | AND d.tld = :tld |
|
| 176 | AND d.privacy = '0'"); |
|
| 177 | $stmt3->bindParam('registrar_id', $bind_registrar_id, \PDO::PARAM_INT); |
|
| 178 | $stmt3->bindParam('tld', $bind_tld, \PDO::PARAM_STR); |
|
| 179 | ||
| 180 | $stmt4 = $pdo->prepare(" |
|
| 181 | UPDATE fees |
|
| 182 | SET fee_fixed = '1', |
|
| 183 | update_time = :update_time |
|
| 184 | WHERE registrar_id = :registrar_id |
|
| 185 | AND tld = :tld"); |
|
| 186 | $timestamp = $this->time->stamp(); |
|
| 187 | $stmt4->bindValue('update_time', $timestamp, \PDO::PARAM_STR); |
|
| 188 | $stmt4->bindParam('registrar_id', $bind_registrar_id, \PDO::PARAM_INT); |
|
| 189 | $stmt4->bindParam('tld', $bind_tld, \PDO::PARAM_STR); |
|
| 190 | ||
| 191 | foreach ($result as $row) { |
|
| 192 | ||
| 193 | $bind_fee_id = $row->id; |
|
| 194 | $bind_registrar_id = $row->registrar_id; |
|
| 195 | $bind_tld = $row->tld; |
|
| 196 | ||
| 197 | $stmt->execute(); |
|
| 198 | ||
| 199 | $stmt2->execute(); |
|
| 200 | ||
| 201 | $stmt3->execute(); |
|
| 202 | ||
| 203 | $stmt4->execute(); |
|
| 204 | ||
| 205 | } |
|
| 206 | ||
| 207 | } |
|
| 208 | } |
|
| 209 | ||
| 210 | public function updateDomainFee($domain_id) |
|
| @@ 261-322 (lines=62) @@ | ||
| 258 | ||
| 259 | $result = $stmt->fetchAll(); |
|
| 260 | ||
| 261 | if ($result) { |
|
| 262 | ||
| 263 | $stmt = $pdo->prepare(" |
|
| 264 | UPDATE domains |
|
| 265 | SET fee_id = :fee_id |
|
| 266 | WHERE registrar_id = :registrar_id |
|
| 267 | AND tld = :tld |
|
| 268 | AND fee_fixed = '0'"); |
|
| 269 | $stmt->bindParam('fee_id', $bind_fee_id, \PDO::PARAM_INT); |
|
| 270 | $stmt->bindParam('registrar_id', $bind_registrar_id, \PDO::PARAM_INT); |
|
| 271 | $stmt->bindParam('tld', $bind_tld, \PDO::PARAM_STR); |
|
| 272 | ||
| 273 | $stmt2 = $pdo->prepare(" |
|
| 274 | UPDATE domains d |
|
| 275 | JOIN fees f ON d.fee_id = f.id |
|
| 276 | SET d.fee_fixed = '1', |
|
| 277 | d.total_cost = f.renewal_fee + f.privacy_fee + f.misc_fee |
|
| 278 | WHERE d.registrar_id = :registrar_id |
|
| 279 | AND d.tld = :tld |
|
| 280 | AND d.privacy = '1'"); |
|
| 281 | $stmt2->bindParam('registrar_id', $bind_registrar_id, \PDO::PARAM_INT); |
|
| 282 | $stmt2->bindParam('tld', $bind_tld, \PDO::PARAM_STR); |
|
| 283 | ||
| 284 | $stmt3 = $pdo->prepare(" |
|
| 285 | UPDATE domains d |
|
| 286 | JOIN fees f ON d.fee_id = f.id |
|
| 287 | SET d.fee_fixed = '1', |
|
| 288 | d.total_cost = f.renewal_fee + f.misc_fee |
|
| 289 | WHERE d.registrar_id = :registrar_id |
|
| 290 | AND d.tld = :tld |
|
| 291 | AND d.privacy = '0'"); |
|
| 292 | $stmt3->bindParam('registrar_id', $bind_registrar_id, \PDO::PARAM_INT); |
|
| 293 | $stmt3->bindParam('tld', $bind_tld, \PDO::PARAM_STR); |
|
| 294 | ||
| 295 | $stmt4 = $pdo->prepare(" |
|
| 296 | UPDATE fees |
|
| 297 | SET fee_fixed = '1', |
|
| 298 | update_time = :update_time |
|
| 299 | WHERE registrar_id = :registrar_id |
|
| 300 | AND tld = :tld"); |
|
| 301 | $timestamp = $this->time->stamp(); |
|
| 302 | $stmt4->bindValue('update_time', $timestamp, \PDO::PARAM_STR); |
|
| 303 | $stmt4->bindParam('registrar_id', $bind_registrar_id, \PDO::PARAM_INT); |
|
| 304 | $stmt4->bindParam('tld', $bind_tld, \PDO::PARAM_STR); |
|
| 305 | ||
| 306 | foreach ($result as $row) { |
|
| 307 | ||
| 308 | $bind_fee_id = $row->id; |
|
| 309 | $bind_registrar_id = $row->registrar_id; |
|
| 310 | $bind_tld = $row->tld; |
|
| 311 | ||
| 312 | $stmt->execute(); |
|
| 313 | ||
| 314 | $stmt2->execute(); |
|
| 315 | ||
| 316 | $stmt3->execute(); |
|
| 317 | ||
| 318 | $stmt4->execute(); |
|
| 319 | ||
| 320 | } |
|
| 321 | ||
| 322 | } |
|
| 323 | } |
|
| 324 | ||
| 325 | public function updateSslFees() |
|
