<?php
include_once($path_to_root . "/includes/banking.inc");
+include_once($path_to_root . "/includes/reserved.inc");
+include_once($path_to_root . "/includes/types.inc");
define("DEFVAL", "--");
$search_button = "<input type='submit' class='combo_submit' style='border:0;background:url($path_to_root/themes/default/images/locate.png) no-repeat;' name='%s' value='?' title='"._("Search")."'> ";
}
elseif ($val != "" && $val != DEFVAL)
{
- $supplier_sql .= "WHERE supp_name LIKE '%{$val}%'";
+ $supplier_sql .= "WHERE supp_name LIKE '%{$val}%' ORDER BY supp_name";
}
+ else
+ $supplier_sql .= "ORDER BY supp_name LIMIT 1";
echo "<input type='text' name='$edit_name' size='8' maxlength='50' value='$val' onblur='this.form.$edit_button.click();'> ";
echo sprintf($search_button, $edit_button);
}
+ else
+ $supplier_sql .= "ORDER BY supp_name";
- $supplier_result = db_query($supplier_sql." ORDER BY supp_name");
+ $supplier_result = db_query($supplier_sql);
if ($submit_on_change==true)
echo "<select name='$name' onchange='this.form.submit();'>";
$customer_sql .= "WHERE debtor_no=$selected_id";
}
elseif ($val != "" && $val != DEFVAL)
- {
- $customer_sql .= "WHERE name LIKE '%{$val}%'";
- }
+ {
+ $customer_sql .= "WHERE name LIKE '%{$val}%' ORDER BY name";
+ }
+ else
+ $customer_sql .= "ORDER BY name LIMIT 1";
echo "<input type='text' name='$edit_name' size='8' maxlength='50' value='$val' onblur='this.form.$edit_button.click();'> ";
echo sprintf($search_button, $edit_button);
}
+ else
+ $customer_sql .= "ORDER BY name";
-
- $customer_result = db_query($customer_sql." ORDER BY name");
+ $customer_result = db_query($customer_sql);
if ($submit_on_change==true)
echo "<select name='$name' onchange='this.form.submit();'>";
}
elseif ($val != "" && $val != DEFVAL)
{
- $sql .= " AND
- (stock_id LIKE '%{$val}%' OR ".TB_PREF."stock_category.description LIKE '%{$val}%' OR "
- .TB_PREF."stock_master.description LIKE '%{$val}%')";
+ $sql .= " AND
+ (stock_id LIKE '%{$val}%' OR ".TB_PREF."stock_category.description LIKE '%{$val}%' OR "
+ .TB_PREF."stock_master.description LIKE '%{$val}%')";
}
-
+ else
+ $sql .= " LIMIT 1";
echo "<input type='text' name='$edit_name' size='8' maxlength='50' value='$val' onblur='this.form.$edit_button.click();'> ";
echo sprintf($search_button, $edit_button);
$result = db_query($sql);
- if ($submit_on_change==true)
- echo "<select name='$name' onchange='this.form.submit();'>";
- else if ($extra != "")
- echo "<select name='$name' $extra>";
- else
- echo "<select name='$name'>";
+ echo "<select name='$name'".
+ ($submit_on_change ? " onchange='this.form.submit();'" : '').
+ ($extra=='' ? '' : " $extra").
+ ">";
if (($all_option == true))
{
AND mb_flag !='M' ";
if (get_company_pref('no_item_list'))
{
+ global $search_button;
$edit_name = $name."_edit";
$edit_button = $name."_button";
(stock_id LIKE '%{$val}%' OR ".TB_PREF."stock_category.description LIKE '%{$val}%' OR "
.TB_PREF."stock_master.description LIKE '%{$val}%')";
}
+ else
+ $sql .= "LIMIT 1";
+ echo "<input type='text' name='$edit_name' size='8' maxlength='50' value='$val' onblur='this.form.$edit_button.click();'> ";
- echo "<input type='text' name='$edit_name' size='8' maxlength='50' value='$val' > ";
-
- echo "<input type='submit' class='inputsubmit' name='$edit_button' value='?'> ";
+ echo sprintf($search_button, $edit_button);
}
$result = db_query($sql);
//-----------------------------------------------------------------------------------------------
-function sales_types_list($name, $selected_id, $submit_on_change=false)
+function sales_types_list($name, $selected_id, $submit_on_change=false, $special_option=null)
{
simple_codeandname_list("SELECT id, sales_type FROM ".TB_PREF."sales_types",
- $name, $selected_id, false, null, false, $submit_on_change);
+ $name, $selected_id,
+ isset($special_option), $special_option, true, $submit_on_change);
}
-function sales_types_list_cells($label, $name, $selected_id, $submit_on_change=false)
+function sales_types_list_cells($label, $name, $selected_id, $submit_on_change=false, $special_option=null)
{
if ($label != null)
echo "<td>$label</td>\n";
echo "<td>";
- sales_types_list($name, $selected_id, $submit_on_change);
+ sales_types_list($name, $selected_id, $submit_on_change, $special_option);
echo "</td>\n";
}
-function sales_types_list_row($label, $name, $selected_id, $submit_on_change=false)
+function sales_types_list_row($label, $name, $selected_id, $submit_on_change=false, $special_option=null)
{
echo "<tr>\n";
- sales_types_list_cells($label, $name, $selected_id, $submit_on_change);
+ sales_types_list_cells($label, $name, $selected_id, $submit_on_change, $special_option);
echo "</tr>\n";
}