• Alaa
  • Alaa
  • Senior Member
  • Offline
  • From: Jordan
  • Registered: 03/27/2015
  • Posts: 156

Topic: View_po.php

Hello,,
in this view
purchasing/view/view_po.php
i'd like to show long_description instead of item_description .. but it seems that the long description is stored in stock_master table..

is there an easy way to replace this code line 69

label_cell($stock_item->item_description);

so it'd show the long description??

Regards.

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,089

Re: View_po.php

The $stock_item is an element of $purchase_order->line_items. The $purchase_order object gets populated from the function read_po() defined in purchasing/includes/db/po_db.inc. The stock_master table provides only the units field in the sql in the function read_po_items it calls therefrom. Extend it by appending long_description and use it where you want.

Alter line 210 in purchasing/includes/db/po_db.php:

    $sql = "SELECT poline.*, units

to be:

    $sql = "SELECT poline.*, units, long_description

and then use it in the view_po.php file.

apmuthu's Website

  • Alaa
  • Alaa
  • Senior Member
  • Offline
  • From: Jordan
  • Registered: 03/27/2015
  • Posts: 156

Re: View_po.php

Thanks a lot.