Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision d1408ca1

Von Niclas Zimmermann vor mehr als 11 Jahren hinzugefügt

  • ID d1408ca13458a782cbde2b768cdd7abdbdcb9348
  • Vorgänger 2d881637
  • Nachfolger 3af5e2e0

chart_link in acc_trans

Erstellt ein neues Pflichtfeld chart_link in der Tabelle acc_trans.
Wird bisher nur beschrieben und noch an keiner Stelle ausgelesen.

Conflicts:

SL/AP.pm
        SL/AR.pm
        SL/IR.pm
        SL/IS.pm

Unterschiede anzeigen:

SL/GL.pm
157 157 
    if ($amount != 0) {
158 158 
      $query =
159 159 
        qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate,
160 
                                  source, memo, project_id, taxkey, ob_transaction, cb_transaction, tax_id)
160 
                                  source, memo, project_id, taxkey, ob_transaction, cb_transaction, tax_id, chart_link)
161 161 
           VALUES (?, (SELECT id FROM chart WHERE accno = ?),
162 
                   ?, ?, ?, ?, ?, ?, ?, ?, ?)|;
162 
                   ?, ?, ?, ?, ?, ?, ?, ?, ?, (SELECT link FROM chart WHERE accno = ?))|;
163 163 
      @values = (conv_i($form->{id}), $accno, $amount, conv_date($form->{transdate}),
164 
                 $form->{"source_$i"}, $form->{"memo_$i"}, $project_id, $taxkey, $form->{ob_transaction} ? 't' : 'f', $form->{cb_transaction} ? 't' : 'f', conv_i($form->{"tax_id_$i"}));
164 
                 $form->{"source_$i"}, $form->{"memo_$i"}, $project_id, $taxkey, $form->{ob_transaction} ? 't' : 'f', $form->{cb_transaction} ? 't' : 'f', conv_i($form->{"tax_id_$i"}), $accno);
165 165 
      do_query($form, $dbh, $query, @values);
166 166 
    }
167 167 

  		




  ......




  169
  169
  
    
      # add taxentry


  		




  170
  170
  
    
      $query =


  		




  171
  171
  
    
        qq|INSERT INTO acc_trans (trans_id, chart_id, amount, transdate,


  		




  172
  
  
    
                                  source, memo, project_id, taxkey, tax_id)


  		




  
  172
  
    
                                  source, memo, project_id, taxkey, tax_id, chart_link)


  		




  173
  173
  
    
           VALUES (?, (SELECT chart_id FROM tax WHERE id = ?),


  		




  174
  
  
    
                   ?, ?, ?, ?, ?, ?, ?)|;


  		




  
  174
  
    
                   ?, ?, ?, ?, ?, ?, ?, (SELECT link FROM chart WHERE accno = ?))|;


  		




  175
  175
  
    
      @values = (conv_i($form->{id}), conv_i($form->{"tax_id_$i"}),


  		




  176
  176
  
    
                 $tax, conv_date($form->{transdate}), $form->{"source_$i"},


  		




  177
  
  
    
                 $form->{"memo_$i"}, $project_id, $taxkey, conv_i($form->{"tax_id_$i"}));


  		




  
  177
  
    
                 $form->{"memo_$i"}, $project_id, $taxkey, conv_i($form->{"tax_id_$i"}), conv_i($form->{"tax_id_$i"}));


  		




  178
  178
  
    
      do_query($form, $dbh, $query, @values);


  		




  179
  179
  
    
    }


  		




  180
  180
  
    
  }


  		












Auch abrufbar als:  Unified diff