Changeset 882 for trunk


Ignore:
Timestamp:
Sep 8, 2020, 5:00:04 PM (4 years ago)
Author:
chronos
Message:
  • Fixed: New monthly payment was not working after upgrade of to new SQL server.
Location:
trunk
Files:
4 edited

Legend:

Unmodified
Added
Removed
  • trunk/Application/UpdateTrace.php

    r881 r882  
    21232123  $Manager->Execute('ALTER TABLE `User` CHANGE `LastIpAddress` `LastIpAddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT "";');
    21242124  $Manager->Execute('ALTER TABLE `Log` CHANGE `IPAddress` `IPAddress` VARCHAR(45) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;');
     2125}
     2126
     2127function UpdateTo882($Manager)
     2128{
     2129  $Manager->Execute('ALTER TABLE `FinanceMonthlyOverall` CHANGE `Investment` `Investment` INT(11) NOT NULL DEFAULT "0";');
    21252130}
    21262131
     
    22272232      870 => array('Revision' => 878, 'Function' => 'UpdateTo878'),
    22282233      878 => array('Revision' => 880, 'Function' => 'UpdateTo880'),
     2234      880 => array('Revision' => 882, 'Function' => 'UpdateTo882'),
    22292235    );
    22302236  }
  • trunk/Application/Version.php

    r881 r882  
    11<?php
    22
    3 $Revision = 881; // Subversion revision
    4 $DatabaseRevision = 880; // SQL structure revision
    5 $ReleaseTime = strtotime('2020-09-04');
     3$Revision = 882; // Subversion revision
     4$DatabaseRevision = 882; // SQL structure revision
     5$ReleaseTime = strtotime('2020-09-08');
  • trunk/Modules/EmailQueue/EmailQueue.php

    r874 r882  
    7777  {
    7878    $Values = array('To' => $To,
    79       'Subject' => $Subject, 'Content' => $Content, 'Time' => 'NOW()',
     79      'Subject' => $Subject, 'Content' => $Content, 'Time' => 'NOW()', 'Headers' => '',
    8080      'From' => $From);
    8181    if ($AttachmentFileId != '') $Values['AttachmentFile'] = $AttachmentFileId;
  • trunk/Modules/Finance/Manage.php

    r874 r882  
    291291    $DateParts = explode('-', $Overall['Date']);
    292292    $MonthLast = $DateParts[1];
     293    $YearLast = $DateParts[0];
    293294    $MonthCurrent = date('m') + 0;
     295    $YearCurrent = date('Y') + 0;
    294296
    295297    $Output .= $Finance->RecalculateMemberPayment();
     
    311313    // Zkontrolovat odečtení měsíčního poplatku
    312314    $Output .= 'Kontrola odečtení poplatků: Poslední měsíc-'.$MonthLast.' Aktuální měsíc-'.$MonthCurrent."\n";
    313     if ($MonthCurrent != $MonthLast)
     315    if (($MonthCurrent != $MonthLast) or ($YearCurrent != $YearLast))
    314316    {
    315317      $Output .= 'Odečítám pravidelný poplatek...'."\n";
Note: See TracChangeset for help on using the changeset viewer.