projekt kivitendo

    qq|  a.duedate, a.netamount, a.amount, a.paid, | .

    qq|  a.invoice, a.datepaid, a.terms, a.notes, a.shipvia, | .

    qq|  a.shippingpoint, a.storno, a.globalproject_id, | .

    qq|  pr.projectnumber AS globalprojectnumber, | .

    qq|  c.name, | .

    qq|  e.name AS employee | .

    $where .= " AND a.department_id = ?";

    push(@values, $department_id);

  }

    if ($form->{$column}) {

      $where .= " AND a.$column ILIKE ?";

      push(@values, $form->like($form->{$column}));

                salesman_id = ?,

                storno = ?,

                globalproject_id = ?,

              WHERE id = ?|;

  @values = ($form->{"invnumber"}, $form->{"ordnumber"}, $form->{"quonumber"}, $form->{"cusordnumber"},

             conv_date($form->{"invdate"}), conv_date($form->{"orddate"}), conv_date($form->{"quodate"}),

             conv_i($form->{"delivery_customer_id"}), conv_i($form->{"delivery_vendor_id"}),

             conv_i($form->{"employee_id"}), conv_i($form->{"salesman_id"}),

             $form->{"storno"} ? 't' : 'f', conv_i($form->{"globalproject_id"}),

             conv_i($form->{"id"}));

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

           a.duedate, a.taxincluded, a.curr AS currency, a.shipto_id, a.cp_id,

           a.employee_id, a.salesman_id, a.payment_id,

           a.language_id, a.delivery_customer_id, a.delivery_vendor_id, a.type,

           e.name AS employee

         FROM ar a

         LEFT JOIN employee e ON (e.id = a.employee_id)

	  <th align=right nowrap>| . $locale->text('Order Number') . qq|</th>

	  <td colspan=3><input name=ordnumber size=20></td>

	</tr>

	<tr>

	  <th align=right nowrap>| . $locale->text('Notes') . qq|</th>

	  <td colspan=3><input name=notes size=40></td>

		<td nowrap>| . $locale->text('Subtotal') . qq|</td>

		<td align=right><input name="l_globalprojectnumber" class=checkbox type=checkbox value=Y></td>

		<td nowrap>| . $locale->text('Project Number') . qq|</td>

	      </tr>

	    </table>

	  </td>

    $option .= "\n<br>" if $option;

    $option .= $locale->text('Notes') . " : $form->{notes}";

  }

  if ($form->{transdatefrom}) {

    $callback .= "&transdatefrom=$form->{transdatefrom}";

  @columns =

    qw(transdate id type invnumber ordnumber name netamount tax amount paid

       globalprojectnumber);

  $form->{"l_type"} = "Y";

    . "</a></th>";

  $column_header{globalprojectnumber} =

    qq|<th class="listheading">| . $locale->text('Project Number') . qq|</th>|;

  $form->{title} = $locale->text('AR Transactions');

    $column_data{employee}      = "<td>$ar->{employee}&nbsp;</td>";

    $column_data{globalprojectnumber}  =

      "<td>" . H($ar->{globalprojectnumber}) . "</td>";

    $i++;

    $i %= 2;

	      <tr>

		<th align="right" nowrap>| . $locale->text('Ship via') . qq|</th>

		<td colspan="3"><input name="shipvia" size="35" value="$form->{shipvia}"></td>

#               <tr>

#                 <td colspan=4>

#                   <table>

  'The \'tag\' field must only consist of alphanumeric characters or the carachters - _ ( )' => 'Das Feld \'tag\' darf nur aus alphanumerischen Zeichen und den Zeichen - _ ( ) bestehen.',

  'Total'                       => 'Summe',

  'Transaction deleted!'        => 'Buchung gel?scht!',

  'Transaction posted!'         => 'Buchung verbucht!',

  'Trying to call a sub without a name' => 'Es wurde versucht, eine Unterfunktion ohne Namen aufzurufen.',

  'Type'                        => 'Typ',

  'The \'tag\' field must only consist of alphanumeric characters or the carachters - _ ( )' => 'Das Feld \'tag\' darf nur aus alphanumerischen Zeichen und den Zeichen - _ ( ) bestehen.',

  'Total'                       => 'Summe',

  'Trade Discount'              => 'Rabatt',

  'Trying to call a sub without a name' => 'Es wurde versucht, eine Unterfunktion ohne Namen aufzurufen.',

  'Unit'                        => 'Einheit',

  'Unknown dependency \'%s\'.'  => 'Unbekannte Abhängigkeit \'%s\'.',