Projekt

Allgemein

Profil

« Zurück | Weiter » 

Revision fcde4c20

Von Kivitendo Admin vor etwa 8 Jahren hinzugefügt

  • ID fcde4c2096c1494984940ddc4650e49933471dd9
  • Vorgänger 8b2c6778
  • Nachfolger 73b9848f

Ware/Erzeugnis/Dienstleistung per parts.part_type unterscheiden 2

kivitendo Code angepasst.

Unterschiede anzeigen:

SL/IS.pm
1656 1656
  my ($dbh, $myconfig, $form, $position, $id, $totalqty) = @_;
1657 1657

  
1658 1658
  my $query =
1659
    qq|SELECT a.parts_id, a.qty, p.assembly, p.partnumber, p.description, p.unit,
1659
    qq|SELECT a.parts_id, a.qty, p.part_type, p.partnumber, p.description, p.unit,
1660 1660
         p.inventory_accno_id, p.income_accno_id, p.expense_accno_id
1661 1661
       FROM assembly a
1662 1662
       JOIN parts p ON (a.parts_id = p.id)
......
1797 1797

  
1798 1798
  # reverse inventory items
1799 1799
  my $query =
1800
    qq|SELECT i.id, i.parts_id, i.qty, i.assemblyitem, p.assembly, p.inventory_accno_id
1800
    qq|SELECT i.id, i.parts_id, i.qty, i.assemblyitem, p.part_type, p.inventory_accno_id
1801 1801
       FROM invoice i
1802 1802
       JOIN parts p ON (i.parts_id = p.id)
1803 1803
       WHERE i.trans_id = ?|;
......
2003 2003
           i.description, i.longdescription, i.qty, i.fxsellprice AS sellprice, i.discount, i.parts_id AS id, i.unit, i.deliverydate AS reqdate,
2004 2004
           i.project_id, i.serialnumber, i.pricegroup_id, i.ordnumber, i.donumber, i.transdate, i.cusordnumber, i.subtotal, i.lastcost,
2005 2005
           i.price_factor_id, i.price_factor, i.marge_price_factor, i.active_price_source, i.active_discount_source,
2006
           p.partnumber, p.assembly, p.notes AS partnotes, p.inventory_accno_id AS part_inventory_accno_id, p.formel, p.listprice,
2006
           p.partnumber, p.part_type, p.notes AS partnotes, p.inventory_accno_id AS part_inventory_accno_id, p.formel, p.listprice,
2007 2007
           pr.projectnumber, pg.partsgroup, prg.pricegroup
2008 2008

  
2009 2009
         FROM invoice i
......
2314 2314
         c3.new_chart_id AS expense_new_chart,
2315 2315
         date($transdate) - c3.valid_from AS expense_valid,
2316 2316

  
2317
         p.unit, p.assembly, p.onhand,
2317
         p.unit, p.part_type, p.onhand,
2318 2318
         p.notes AS partnotes, p.notes AS longdescription,
2319 2319
         p.not_discountable, p.formel, p.payment_id AS part_payment_id,
2320 2320
         p.price_factor_id, p.weight,

Auch abrufbar als: Unified diff