Changeset 295 for trunk/finance/manage.php

Timestamp:

Oct 2, 2010, 7:40:25 PM (14 years ago)

Author:

george

Message:

• Přidáno: Funkce pro zpožděné generování chybějících dokladů.

File:

• trunk/finance/manage.php (modified) (4 diffs)

trunk/finance/manage.php

@@ -54 +54 @@
       case 'MonthlyPayment':
         $Output = $this->ShowMonthlyPayment();
+        break;
+      case 'GenerateBills':
+        $Output = $this->GenerateBills();
         break;
       default:
@@ -68 +71 @@
         $Output .= '<a href="clenove.php">Seznam členů</a><br />';
         $Output .= '<a href="zivnost.php">Živnost</a><br />';
+        $Output .= '<a href="?Operation=GenerateBills">Generovat chybějící doklady</a><br />';
     }
     return($Output);
@@ -538 +542 @@
           $BillCode = $Finance->GetNextDocumentLineNumber(6); // Faktury vydané
           $BillId = $this->System->Modules['Bill']->CreateBill($Member['Subject'], array(array('Description' => 'Připojení k síti', 'Price' => $PayPerPeriod, 'Quantity' => 1)), $Period['From'], $Period['To'], $BillCode);
-          $this->Database->insert('FinanceClaimsLiabilities', array('Value' => $PayPerPeriod, 'Subject' => $Member['Subject'], 'TimeCreation' => 'NOW()', 'Text' => 'Připojení k síti za období '.$TimePeriodText, 'Bill' => 0, 'BillCode' => $BillCode));
+          $this->Database->insert('FinanceClaimsLiabilities', array('Value' => $PayPerPeriod, 'Subject' => $Member['Subject'], 'TimeCreation' => 'NOW()', 'TimeDue' => 'DATE_ADD(NOW(), INTERVAL 15 DAY)', 'Text' => 'Připojení k síti za období '.$TimePeriodText, 'Bill' => 0, 'BillCode' => $BillCode));
           $Output .= $this->SendPaymentEmail($Member['Id']);
           $this->Database->update('Member', 'Id='.$Member['Id'], array('BillingPeriodLastDate' => TimeToMysqlDateTime($Period['To'])));
@@ -616 +620 @@
     } else $Output = 'Uživatel '.$User['Name'].' nemá email.';
   }
+  
+  function GenerateBills()
+  {
+    // FinanceClaimsLiablities
+    $DbResult = $this->Database->query('SELECT * FROM FinanceClaimsLiabilities WHERE (BillCode <> "") AND (Value >= 0)');
+    while($Row = $DbResult->fetch_assoc())
+    {
+      $BillId = $this->System->Modules['Bill']->CreateBill($Row['Subject'], array(array('Description' => $Row['Text'], 'Price' => $Row['Value'], 'Quantity' => 1)), MysqlDateTimeToTime($Row['TimeCreation']), MysqlDateTimeToTime($Row['TimeDue']), $Row['BillCode']);
+      $this->Database->update('FinanceClaimsLiabilities', 'Id='.$Row['Id'], array('Bill' => $BillId));
+      echo('.');
+    }
+
+    // FinanceOperations
+  }
 }