purchasing/inquiry/po_search_completed.php

   1 <?php
   2
   3 $page_security = 2;
   4 $path_to_root="../..";
   5 include($path_to_root . "/includes/db_pager.inc");
   6 include($path_to_root . "/includes/session.inc");
   7
   8 include($path_to_root . "/purchasing/includes/purchasing_ui.inc");
   9 include_once($path_to_root . "/reporting/includes/reporting.inc");
  10 $js = "";
  11 if ($use_popup_windows)
  12         $js .= get_js_open_window(900, 500);
  13 if ($use_date_picker)
  14         $js .= get_js_date_picker();
  15 page(_("Search Purchase Orders"), false, false, "", $js);
  16
  17 if (isset($_GET['order_number']))
  18 {
  19         $order_number = $_GET['order_number'];
  20 }
  21
  22 //-----------------------------------------------------------------------------------
  23 // Ajax updates
  24 //
  25 if (get_post('SearchOrders'))
  26 {
  27         $Ajax->activate('orders_tbl');
  28 } elseif (get_post('_order_number_changed'))
  29 {
  30         $disable = get_post('order_number') !== '';
  31
  32         $Ajax->addDisable(true, 'OrdersAfterDate', $disable);
  33         $Ajax->addDisable(true, 'OrdersToDate', $disable);
  34         $Ajax->addDisable(true, 'StockLocation', $disable);
  35         $Ajax->addDisable(true, '_SelectStockFromList_edit', $disable);
  36         $Ajax->addDisable(true, 'SelectStockFromList', $disable);
  37
  38         if ($disable) {
  39                 $Ajax->addFocus(true, 'order_number');
  40         } else
  41                 $Ajax->addFocus(true, 'OrdersAfterDate');
  42
  43         $Ajax->activate('orders_tbl');
  44 }
  45 //---------------------------------------------------------------------------------------------
  46
  47 start_form(false, true);
  48
  49 start_table("class='tablestyle_noborder'");
  50 start_row();
  51 ref_cells(_("#:"), 'order_number', '',null, '', true);
  52
  53 date_cells(_("from:"), 'OrdersAfterDate', '', null, -30);
  54 date_cells(_("to:"), 'OrdersToDate');
  55
  56 locations_list_cells(_("into location:"), 'StockLocation', null, true);
  57
  58 stock_items_list_cells(_("for item:"), 'SelectStockFromList', null, true);
  59
  60 submit_cells('SearchOrders', _("Search"),'',_('Select documents'), true);
  61 end_row();
  62 end_table();
  63
  64 end_form();
  65
  66 //---------------------------------------------------------------------------------------------
  67 if (isset($_POST['order_number']))
  68 {
  69         $order_number = $_POST['order_number'];
  70 }
  71
  72 if (isset($_POST['SelectStockFromList']) &&     ($_POST['SelectStockFromList'] != "") &&
  73         ($_POST['SelectStockFromList'] != reserved_words::get_all()))
  74 {
  75         $selected_stock_item = $_POST['SelectStockFromList'];
  76 }
  77 else
  78 {
  79         unset($selected_stock_item);
  80 }
  81
  82 //---------------------------------------------------------------------------------------------
  83 function trans_view($trans)
  84 {
  85         return get_trans_view_str(systypes::po(), $trans["order_no"]);
  86 }
  87
  88 function prt_link($row)
  89 {
  90         return print_document_link($row['order_no'], _("Print"), true, 18);
  91 }
  92
  93 //---------------------------------------------------------------------------------------------
  94
  95 $sql = "SELECT
  96         porder.order_no,
  97         porder.reference,
  98         supplier.supp_name,
  99         location.location_name,
 100         porder.requisition_no,
 101         porder.ord_date,
 102         supplier.curr_code,
 103         Sum(line.unit_price*line.quantity_ordered) AS OrderValue,
 104         porder.into_stock_location
 105         FROM ".TB_PREF."purch_orders as porder, "
 106                 .TB_PREF."purch_order_details as line, "
 107                 .TB_PREF."suppliers as supplier, "
 108                 .TB_PREF."locations as location
 109         WHERE porder.order_no = line.order_no
 110         AND porder.supplier_id = supplier.supplier_id
 111         AND location.loc_code = porder.into_stock_location ";
 112
 113 if (isset($order_number) && $order_number != "")
 114 {
 115         $sql .= "AND porder.reference LIKE '%". $order_number . "%'";
 116 }
 117 else
 118 {
 119
 120         $data_after = date2sql($_POST['OrdersAfterDate']);
 121         $date_before = date2sql($_POST['OrdersToDate']);
 122
 123         $sql .= " AND porder.ord_date >= '$data_after'";
 124         $sql .= " AND porder.ord_date <= '$date_before'";
 125
 126         if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != reserved_words::get_all())
 127         {
 128                 $sql .= " AND porder.into_stock_location = '". $_POST['StockLocation'] . "' ";
 129         }
 130         if (isset($selected_stock_item))
 131         {
 132                 $sql .= " AND line.item_code='". $selected_stock_item ."' ";
 133         }
 134
 135 } //end not order number selected
 136
 137 $sql .= " GROUP BY porder.order_no";
 138
 139 $cols = array(
 140                 _("#") => array('fun'=>'trans_view', 'ord'=>''),
 141                 _("Reference"),
 142                 _("Supplier") => array('ord'=>''),
 143                 _("Location"),
 144                 _("Supplier's Reference"),
 145                 _("Order Date") => array('type'=>'date', 'ord'=>'desc'),
 146                 _("Currency") => array('align'=>'center'),
 147                 _("Order Total") => 'amount',
 148                 array('insert'=>true, 'fun'=>'prt_link'),
 149 );
 150
 151 if (get_post('StockLocation') != $all_items) {
 152         $cols[_("Location")] = 'skip';
 153 }
 154 //---------------------------------------------------------------------------------------------------
 155
 156 $table =& new_db_pager('orders_tbl', $sql, $cols);
 157
 158 if (get_post('SearchOrders'))
 159 {
 160         $table->set_sql($sql);
 161         $table->set_columns($cols);
 162         $Ajax->activate('orders_tbl');
 163 }
 164         start_form();
 165         display_db_pager($table);
 166         end_form();
 167 end_page();
 168 ?>