Changeset 551 for trunk/Modules/Finance/Manage.php

Timestamp:

Jul 7, 2013, 9:26:44 PM (11 years ago)

Author:

chronos

Message:

• Přidáno: Automatické generování kódu dokladu při vytváření nové položky v IS a při importu z Fio banky.
• Odstraněno: Staré akce na stránce "Správa financí".

File:

• trunk/Modules/Finance/Manage.php (modified) (4 diffs)

trunk/Modules/Finance/Manage.php

@@ -9 +9 @@
   function Show()
   {
+    $Output = '';
     if(!$this->System->User->CheckPermission('Finance', 'Manage')) 
       return('Nemáte oprávnění');
@@ -14 +15 @@
     if(array_key_exists('Operation', $_GET)) $Operation = $_GET['Operation']; 
       else $Operation = '';
-    //$Operation = 'ImportOldData';
     switch($Operation)
     {
-      case 'Bills':
-        $Output = $this->BillManage();
-        break;
-      case 'ConvertPDFToFile':
-        $Output = $this->ConvertPDFDataToFiles();
-        break;
-      //case 'ImportOldData':
-      //  $Output = $this->ImportOldData();
-      //  break;
-      case 'NewPaymentInsert':
-        $Output = $this->ShowNewPaymentInsert();
-        break;
-      case 'NewPaymentForm':
-        $Output = $this->ShowNewPaymentForm();
-        break;
-      case 'NewInvoiceInsert':
-        $Output = $this->ShowNewInvoiceInsert();
-        break;
-      case 'NewInvoiceForm':
-        $Output = $this->ShowNewInvoiceForm();
-        break;
       case 'Recalculate':
         $Output = $this->System->Modules['Finance']->RecalculateSegmentParameters();
@@ -52 +31 @@
         break;
       default:
-        $Output = '<a href="?Operation=NewPaymentForm">Přidat novou platbu</a><br />';
-        $Output .= '<a href="?Operation=NewInvoiceForm">Přidat novou fakturu</a><br />';
-        $Output .= '<a href="?Operation=ConvertPDFToFile">Převést data z databáze do souborů</a><br />';
-        $Output .= '<a href="?Operation=Bills">Správa dokladů</a><br />';
         //$Output .= '<a href="?Operation=Recalculate">Přepočet financí</a><br />';
         $Output .= '<a href="?Operation=ShowMonthlyPayment">Měsíční vyúčtování</a><br />';
-        //$Output .= '<a href="clenove.php">Seznam členů</a><br />';
         $Output .= '<a href="'.$this->System->Link('/finance/zivnost/').'">Živnost</a><br />';
         $Output .= '<a href="?Operation=GenerateBills">Generovat chybějící doklady</a><br />';
@@ -64 +38 @@
     }
     return($Output);
-  }
-
-  function BillManage()
-  {
-    $Output = '';
-    if(array_key_exists('subject', $_GET))
-    {
-      $DbResult = $this->Database->select('FinanceBills', '*', 'Subject='.$_GET['subject']);
-      while($Item = $DbResult->fetch_array())
-      {
-        $Output .= '<a href="?Operation=Bills&amp;bill='.$Item['Id'].'">faktura '.$Item['Id'].'</a> <a href="?Operation=Bills&amp;billpdf='.$Item['Id'].'">Uložené PDF</a> <a href="?Operation=Bills&amp;billpdf2='.$Item['Id'].'">Generované PDF</a> <a href="?Operation=Bills&amp;regenerate='.$Item['Id'].'">Přegenerovat</a><br />';
-      }
-    } else
-    if(array_key_exists('billpdf', $_GET))
-    {
-      $Output .= $this->System->Modules['Bill']->ShowStoredBill($_GET['billpdf']);
-    } else
-    if(array_key_exists('billpdf2', $_GET))
-    {
-      $Output .= $this->System->Modules['Bill']->ShowGeneratedBill($_GET['billpdf2']);
-    } else
-    if(array_key_exists('regenerate', $_GET))
-    {
-      $Output .= $this->System->Modules['Bill']->RegeneratePDF($_GET['regenerate']);
-    } else
-    if(array_key_exists('bill', $_GET))
-    {
-      $Output .= $this->System->Modules['Bill']->GenerateBill($_GET['bill']);
-    } else
-    if(array_key_exists('generate', $_GET))
-    {
-      $Output .= $this->System->Modules['Bill']->CreateBill(1, array(array('Description' => 'Poplatek za připojení k Internetu', 'Price' => 1000, 'Quantity' => 1)), time(), time());
-    } else 
-    {
-      //ShowHeader('Faktury', 'Faktury');
-      $Output .= 'Faktury:<br />';
-      $DbResult = $this->Database->select('Subject', '*', '1 ORDER BY Name');
-      while($Subject = $DbResult->fetch_array())
-      {
-        $Output .= '<a href="?Operation=Bills&amp;subject='.$Subject['Id'].'">'.$Subject['Name'].'</a><br />';
-      }
-      //ShowFooter();
-    }
-    return($Output);
-  }
-
-  function CheckAdvancesAndLiabilities($Subject)
-  {
-    global $LastInsertTime;
-
-    do {
-      $DbResult = $this->Database->select('FinanceAdvances', 'SUM(Value)', 'Subject='.$Subject.' AND Direction = "In"');
-      $DbRow = $DbResult->fetch_array();
-      $Advances = $DbRow[0];
-      $DbResult = $this->Database->select('FinanceInvoice', '*', 'Subject='.$Subject.
-      ' AND TimePayment IS NULL AND Value > 0 ORDER BY TimeCreation LIMIT 1');
-      if($DbResult->num_rows > 0)
-      {
-        $OpenedClaim = $DbResult->fetch_array();
-        if($Advances > $OpenedClaim['Value'])
-        {
-          $this->Database->update('FinanceInvoice', 'Id='.$OpenedClaim['Id'], 
-            array('TimePayment' => TimeToMysqlDateTime($LastInsertTime)));
-          $this->Database->insert('FinanceAdvances', array('Subject' => 
-            $OpenedClaim['Subject'], 'Value' => -$OpenedClaim['Value'], 
-            'TimeCreation' => TimeToMysqlDateTime($LastInsertTime), 
-            'CashFlowId' => $OpenedClaim['Id'], 'Direction' => 'In'));
-        } else break;
-      } else break;
-    } while(($Advances > $OpenedClaim['Value']));
-  }
-
-  function InsertInvoice($Subject, $TimeCreation, $TimeDue, $Items, 
-    $DocumentLine, $PeriodFrom, $PeriodTo)
-  {
-    global $LastInsertTime;
-
-    $BillCode = $this->System->Modules['Finance']->GetNextDocumentLineNumber($DocumentLine);
-    $SumValue = 0;
-    foreach($Items as $Item)
-      $SumValue = $SumValue + $Item['Price'];
-    $this->Database->insert('FinanceInvoice', array( 
-      'Subject' => $Subject, 'TimeCreation' => TimeToMysqlDateTime($TimeCreation), 
-      'TimeDue' => TimeToMysqlDateTime($TimeDue), 'Value' => $SumValue, 'BillCode' => $BillCode,
-      'PeriodFrom' => TimeToMysqlDate($PeriodFrom), 'PeriodTo' => TimeToMysqlDate($PeriodTo),
-      'Generate' => 1));
-    $InvoiceId = $this->Database->insert_id;
-    foreach($Items as $Item)
-    $this->Database->insert('FinanceInvoiceItem', array('FinanceInvoice' => $InvoiceId, 
-      'Description' => $Item['Description'], 'Price' => $Item['Price'], 'Quantity' => $Item['Quantity'], 'VAT' => $Item['VAT']));
-    //$LastInsertTime = $Time;
-    //$this->CheckAdvancesAndLiabilities($Subject);
-    return($InvoiceId);
-  }
-
-  function InsertMoney($Subject, $Value, $Cash, $Taxable, $Time, $Text, $DocumentLine)
-  {
-    global $LastInsertTime;
-
-    $BillCode = $this->System->Modules['Finance']->GetNextDocumentLineNumber($DocumentLine);
-    $this->Database->insert('FinanceOperation', array('Text' => $Text, 'Subject' => $Subject, 'Cash' => $Cash, 'Value' => $Value, 'Time' => TimeToMysqlDateTime($Time), 'Taxable' => $Taxable, 'BillCode' => $BillCode));
-    /*if($Value >= 0)
-    {
-      $this->Database->insert('FinanceAdvances', array('Subject' => $Subject, 'Value' => $Value, 'TimeCreation' => TimeToMysqlDateTime($Time), 'CashFlowId' => $this->Database->insert_id, 'Direction' => 'In'));
-    }
-    $LastInsertTime = $Time;
-    */
-    //$this->CheckAdvancesAndLiabilities($Subject);
-  }
-
-    function ShowNewPaymentForm()
-  {
-    $Form = new Form($this->System->FormManager);
-    $Form->SetClass('NewPayment');
-    $Form->OnSubmit = '?Operation=NewPaymentInsert';
-    $Output = $Form->ShowEditForm();
-    return($Output);
-  }
-
-  function ShowNewPaymentInsert()
-  {
-    $Form = new Form($this->System->FormManager);
-    $Form->SetClass('NewPayment');
-    $Form->LoadValuesFromForm();
-    $this->InsertMoney($Form->Values['Subject'], $Form->Values['Value'], $Form->Values['Cash'], $Form->Values['Taxable'], $Form->Values['Time'], $Form->Values['Text'], $Form->Values['DocumentLine']);
-    $LastId = $this->Database->insert_id;
-    $DbResult = $this->Database->select('FinanceOperation', 'BillCode', 'Id='.$LastId);
-    $DbRow = $DbResult->fetch_assoc();
-    $Output = $this->SystemMessage('Finance', 'Platba vložena '.$DbRow['BillCode'].'.');
-    $this->System->ModuleManager->Modules['Log']->NewRecord('Finance', 'NewPaymentInserted');
-    return($Output);
-  }
-
-  function ShowNewInvoiceForm()
-  {
-    $Form = new Form($this->System->FormManager);
-    $Form->SetClass('NewInvoice');
-    $Form->OnSubmit = '?Operation=NewInvoiceInsert';
-    $Output = $Form->ShowEditForm();
-    return($Output);
-  }
-
-  function ShowNewInvoiceInsert()
-  {
-    $Form = new Form($this->System->FormManager);
-    $Form->SetClass('NewInvoice');
-    $Form->LoadvaluesFromForm();
-    $Items = array(array('Price' => $Form->Values['Value'], 
-      'Description' => $Form->Values['Text'], 'Quantity' => 1, 'VAT' => 21));
-    $LastId = $this->InsertInvoice($Form->Values['Subject'],  
-      $Form->Values['TimeCreation'], $Form->Values['TimeDue'], $Items, 
-      $Form->Values['DocumentLine'], NULL, NULL);
-    $DbResult = $this->Database->select('FinanceInvoice', 'BillCode', 'Id='.$LastId);
-    $DbRow = $DbResult->fetch_assoc();
-    $Output = $this->SystemMessage('Finance', 'Faktura vložena '.$DbRow['BillCode'].'.');
-    $this->System->ModuleManager->Modules['Log']->NewRecord('Finance', 'NewInvoiceInserted');
-    return($Output);
-  }
-  
-  function ConvertPDFDataToFiles()
-  {
-    $DbResult = $this->Database->query('SELECT * FROM FinanceBills');
-    while($Bill = $DbResult->fetch_assoc())
-    {
-      file_put_contents('doklady/doklad_'.$Bill['id'].'.pdf', $Bill['pdf']);
-      echo($Bill['id'].',');
-    }
-  }
-
-  function CheckPDFFiles()
-  {
-    global $InvoiceGenerator;
-
-    $DbResult = $this->Database->query('SELECT * FROM FinanceBills');
-    while($Bill = $DbResult->fetch_assoc())
-    {
-      file_put_contents('doklady2/doklad-'.$Bill['id'].'.pdf', file_get_contents('doklady/doklad-'.$Bill['id'].'.pdf'));
-      //echo($InvoiceGenerator->HasPDFFile($Bill['id']).',');
-    }
   }