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 end_form();
  64 //---------------------------------------------------------------------------------------------
  65 if (isset($_POST['order_number']))
  66 {
  67         $order_number = $_POST['order_number'];
  68 }
  69
  70 if (isset($_POST['SelectStockFromList']) &&     ($_POST['SelectStockFromList'] != "") &&
  71         ($_POST['SelectStockFromList'] != reserved_words::get_all()))
  72 {
  73         $selected_stock_item = $_POST['SelectStockFromList'];
  74 }
  75 else
  76 {
  77         unset($selected_stock_item);
  78 }
  79
  80 //---------------------------------------------------------------------------------------------
  81 function trans_view($trans)
  82 {
  83         return get_trans_view_str(systypes::po(), $trans["order_no"]);
  84 }
  85
  86 function prt_link($row)
  87 {
  88         return print_document_link($row['order_no'], _("Print"), true, 18);
  89 }
  90
  91 //---------------------------------------------------------------------------------------------
  92
  93 $sql = "SELECT
  94         porder.order_no,
  95         porder.reference,
  96         supplier.supp_name,
  97         location.location_name,
  98         porder.requisition_no,
  99         porder.ord_date,
 100         supplier.curr_code,
 101         Sum(line.unit_price*line.quantity_ordered) AS OrderValue,
 102         porder.into_stock_location
 103         FROM ".TB_PREF."purch_orders as porder, "
 104                 .TB_PREF."purch_order_details as line, "
 105                 .TB_PREF."suppliers as supplier, "
 106                 .TB_PREF."locations as location
 107         WHERE porder.order_no = line.order_no
 108         AND porder.supplier_id = supplier.supplier_id
 109         AND location.loc_code = porder.into_stock_location ";
 110
 111 if (isset($order_number) && $order_number != "")
 112 {
 113         $sql .= "AND porder.reference LIKE '%". $order_number . "%'";
 114 }
 115 else
 116 {
 117
 118         $data_after = date2sql($_POST['OrdersAfterDate']);
 119         $date_before = date2sql($_POST['OrdersToDate']);
 120
 121         $sql .= " AND porder.ord_date >= '$data_after'";
 122         $sql .= " AND porder.ord_date <= '$date_before'";
 123
 124         if (isset($_POST['StockLocation']) && $_POST['StockLocation'] != reserved_words::get_all())
 125         {
 126                 $sql .= " AND porder.into_stock_location = '". $_POST['StockLocation'] . "' ";
 127         }
 128         if (isset($selected_stock_item))
 129         {
 130                 $sql .= " AND line.item_code='". $selected_stock_item ."' ";
 131         }
 132
 133 } //end not order number selected
 134
 135 $sql .= " GROUP BY porder.order_no";
 136
 137 $cols = array(
 138                 _("#") => array('fun'=>'trans_view', 'ord'=>''),
 139                 _("Reference"),
 140                 _("Supplier") => array('ord'=>''),
 141                 _("Location"),
 142                 _("Supplier's Reference"),
 143                 _("Order Date") => array('type'=>'date', 'ord'=>'desc'),
 144                 _("Currency") => array('align'=>'center'),
 145                 _("Order Total") => 'amount',
 146                 array('insert'=>true, 'fun'=>'prt_link'),
 147 );
 148
 149 if (get_post('StockLocation') != $all_items) {
 150         $cols[_("Location")] = 'skip';
 151 }
 152 //---------------------------------------------------------------------------------------------------
 153
 154 $table =& new_db_pager('orders_tbl', $sql, $cols);
 155
 156 if (get_post('SearchOrders')) {
 157         $table->set_sql($sql);
 158         $table->set_columns($cols);
 159 }
 160 start_form();
 161
 162 display_db_pager($table);
 163
 164 end_form();
 165 end_page();
 166 ?>