{
global $all_items;
+ default_focus($name);
if ($selected_id == null)
$selected_id = ((!isset($_POST[$name]) || $_POST[$name] == "") ? "" : $_POST[$name]);
- $no_supplier_list = get_company_pref('no_supplier_list');
- if ($no_supplier_list)
+
+
+ $supplier_sql = "SELECT supplier_id, supp_name, curr_code FROM ".TB_PREF."suppliers ";
+ if (get_company_pref('no_supplier_list'))
{
global $search_button;
$edit_name = $name."_edit";
if (isset($_POST[$edit_button]))
{
$selected_id = $_POST[$name] = "";
+ set_focus($name);
}
if ($selected_id != "")
{
$val = DEFVAL;
- $supplier_sql = "SELECT supplier_id, supp_name, curr_code FROM ".TB_PREF."suppliers WHERE supplier_id=$selected_id";
- $supplier_result = db_query($supplier_sql);
+ $supplier_sql .= "WHERE supplier_id=$selected_id";
}
- else
+ elseif ($val != "" && $val != DEFVAL)
{
- if ($val != "" && $val != DEFVAL)
- {
- $supplier_sql = "SELECT supplier_id, supp_name, curr_code FROM ".TB_PREF."suppliers WHERE supp_name LIKE '%{$val}%' ORDER BY supp_name";
- $supplier_result = db_query($supplier_sql);
- }
- else
- $supplier_result = false;
+ $supplier_sql .= "WHERE supp_name LIKE '%{$val}%'";
}
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 = "SELECT supplier_id, supp_name, curr_code FROM ".TB_PREF."suppliers ORDER BY supp_name";
- $supplier_result = db_query($supplier_sql);
- }
+
+ $supplier_result = db_query($supplier_sql." ORDER BY supp_name");
if ($submit_on_change==true)
echo "<select name='$name' onchange='this.form.submit();'>";
{
global $all_items;
+ default_focus($name);
if ($selected_id == null)
$selected_id = ((!isset($_POST[$name]) || $_POST[$name] == "") ? "" : $_POST[$name]);
- $no_customer_list = get_company_pref('no_customer_list');
- if ($no_customer_list)
+
+ $customer_sql = "SELECT debtor_no, name, curr_code FROM ".TB_PREF."debtors_master ";
+ if (get_company_pref('no_customer_list'))
{
global $search_button;
$edit_name = $name."_edit";
{
$selected_id = $_POST[$name] = "";
$_POST['branch_id'] = "";
+ set_focus($name);
}
-
if ($selected_id != "")
{
$val = DEFVAL;
- $customer_sql = "SELECT debtor_no, name, curr_code FROM ".TB_PREF."debtors_master WHERE debtor_no=$selected_id";
- $customer_result = db_query($customer_sql);
+ $customer_sql .= "WHERE debtor_no=$selected_id";
}
- else
- {
- if ($val != "" && $val != DEFVAL)
+ elseif ($val != "" && $val != DEFVAL)
{
- $customer_sql = "SELECT debtor_no, name, curr_code FROM ".TB_PREF."debtors_master WHERE name LIKE '%{$val}%' ORDER BY name";
- $customer_result = db_query($customer_sql);
+ $customer_sql .= "WHERE name LIKE '%{$val}%'";
}
- else
- $customer_result = false;
- }
-
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 = "SELECT debtor_no, name, curr_code FROM ".TB_PREF."debtors_master ORDER BY name";
- $customer_result = db_query($customer_sql);
- }
+
+
+ $customer_result = db_query($customer_sql." ORDER BY name");
+
if ($submit_on_change==true)
echo "<select name='$name' onchange='this.form.submit();'>";
else
{
global $all_items;
+ default_focus($name);
if ($submit_on_change==true)
echo "<select name='$name' onchange='this.form.submit();'>";
else
{
global $all_items;
+ default_focus($name);
if ($submit_on_change == true)
echo "<select name='$name' onchange='this.form.submit();'>";
else
function currencies_list($name, &$selected_id, $submit_on_change=false)
{
+ default_focus($name);
if ($submit_on_change==true)
echo "<select name='$name' onchange='this.form.submit();'>";
else
function fiscalyears_list($name, &$selected_id, $submit_on_change=false)
{
+ default_focus($name);
if ($submit_on_change == true)
echo "<select name='$name' onchange='this.form.submit();'>";
else
{
global $all_items;
+ default_focus($name);
if ($submit_on_change == true)
echo "<select name='$name' onchange='this.form.submit();'>";
else
function dimensions_list($name, &$selected_id, $no_option=false, $showname=null,
$submit_on_change=false, $showclosed=false, $showtype=1)
{
+ default_focus($name);
$sql = "SELECT id, CONCAT(reference,' ',name) FROM ".TB_PREF."dimensions";
if ($showclosed || $showtype)
{
{
global $all_items;
+ default_focus($name);
if ($selected_id == null)
$selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
- $no_item_list = get_company_pref('no_item_list');
- if ($no_item_list)
+
+
+ $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
+ FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id";
+
+ if (get_company_pref('no_item_list'))
{
global $search_button;
$edit_name = $name."_edit";
if (isset($_POST[$edit_button]))
{
$selected_id = $_POST[$name] = "";
+ set_focus($name);
}
-
if ($selected_id != "")
{
$val = DEFVAL;
- $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
- FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id
- AND stock_id='$selected_id'";
- $result = db_query($sql);
+ $sql .= " AND stock_id='$selected_id'";
}
- else
+ elseif ($val != "" && $val != DEFVAL)
{
- if ($val != "" && $val != DEFVAL)
- {
- $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
- FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE "
- .TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id AND
+ $sql .= " AND
(stock_id LIKE '%{$val}%' OR ".TB_PREF."stock_category.description LIKE '%{$val}%' OR "
.TB_PREF."stock_master.description LIKE '%{$val}%')";
- $result = db_query($sql);
- }
- else
- $result = false;
}
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
- {
- $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
- FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id";
- $result = db_query($sql);
- }
+ $result = db_query($sql);
+
if ($submit_on_change==true)
echo "<select name='$name' onchange='this.form.submit();'>";
{
global $all_items;
+ default_focus($name);
if ($submit_on_change==true)
echo "<select name='$name' onchange='this.form.submit();'>";
else
{
global $all_items;
+ default_focus($name);
if ($submit_on_change==true)
echo "<select name='$name' onchange='this.form.submit();'>";
else if ($extra != "")
{
global $all_items;
+ default_focus($name);
if ($selected_id == null)
$selected_id = (!isset($_POST[$name]) ? "" : $_POST[$name]);
- $no_item_list = get_company_pref('no_item_list');
- if ($no_item_list)
+
+ $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
+ FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id
+ AND mb_flag !='M' ";
+ if (get_company_pref('no_item_list'))
{
$edit_name = $name."_edit";
$edit_button = $name."_button";
if (isset($_POST[$edit_button]))
{
$selected_id = $_POST[$name] = "";
+ set_focus($name);
}
if ($selected_id != "")
{
$val = DEFVAL;
- $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
- FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id
- AND mb_flag !='M' AND stock_id='$selected_id'";
- $result = db_query($sql);
+ $sql .= "AND stock_id='$selected_id'";
}
- else
+ elseif ($val != "" && $val != DEFVAL)
{
- if ($val != "" && $val != DEFVAL)
- {
- $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
- FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE "
- .TB_PREF."stock_master.category_id=".TB_PREF."stock_category.category_id AND mb_flag !='M' AND
- (stock_id LIKE '%{$val}%' OR ".TB_PREF."stock_category.description LIKE '%{$val}%' OR "
- .TB_PREF."stock_master.description LIKE '%{$val}%')";
- $result = db_query($sql);
- }
- else
- $result = false;
+ $sql = "AND
+ (stock_id LIKE '%{$val}%' OR ".TB_PREF."stock_category.description LIKE '%{$val}%' OR "
+ .TB_PREF."stock_master.description LIKE '%{$val}%')";
}
echo "<input type='text' name='$edit_name' size='8' maxlength='50' value='$val' > ";
echo "<input type='submit' class='inputsubmit' name='$edit_button' value='?'> ";
}
- else
- {
- $sql = "SELECT stock_id, ".TB_PREF."stock_master.description, ".TB_PREF."stock_category.description
- FROM ".TB_PREF."stock_master,".TB_PREF."stock_category WHERE ".TB_PREF."stock_master.category_id="
- .TB_PREF."stock_category.category_id AND mb_flag !='M'";
- $result = db_query($sql);
- }
+
+ $result = db_query($sql);
if ($submit_on_change==true)
echo "<select name='$name' onchange='this.form.submit();'>";
function stock_item_types_list_row($label, $name, $selected_id, $enabled=true)
{
+ default_focus($name);
echo "<tr>";
if ($label != NULL)
echo "<td>$label</td>\n";
{
global $stock_units;
+ default_focus($name);
+ $result = get_all_item_units();
echo "<tr><td>$label</td>\n";
if ($enabled)
echo "<td><select name='$name'>";
if ($value == null)
$value = (!isset($_POST[$name]) ? "" : $_POST[$name]);
- foreach ($stock_units as $unit)
+
+ while($unit = db_fetch($result))
{
- if ($value == "")
- $_POST[$name] = $value = $unit;
- if ($value==$unit)
+ if ($value == "") {
+ $_POST[$name] = $unit['abbr'];
+ }
+ $descr = $unit['name'];
+ if ($value==$unit['abbr'])
{
- echo "<option selected value='$unit'>$unit</option>\n";
+ echo "<option selected value='".$unit['abbr']."'>$descr</option>\n";
}
else
{
- echo "<option value='$unit'>$unit</option>\n";
+ echo "<option value='".$unit['abbr']."'>$descr</option>\n";
}
}
echo "</select></td></tr>\n";
echo "</td>\n";
}
-function sales_persons_list_row($label, $name, $selected_id)
+function sales_persons_list_row($label, $name, $selected_id, $submit_on_change=false)
{
echo "<tr>\n";
- sales_persons_list_cells($label, $name, $selected_id);
+ sales_persons_list_cells($label, $name, $selected_id, $submit_on_change=false);
echo "</tr>\n";
}
//-----------------------------------------------------------------------------------------------
-function sales_types_list($name, $selected_id)
+function sales_types_list($name, $selected_id, $submit_on_change=false)
{
simple_codeandname_list("SELECT id, sales_type FROM ".TB_PREF."sales_types",
- $name, $selected_id);
+ $name, $selected_id, false, null, false, $submit_on_change);
}
-function sales_types_list_cells($label, $name, $selected_id)
+function sales_types_list_cells($label, $name, $selected_id, $submit_on_change=false)
{
if ($label != null)
echo "<td>$label</td>\n";
echo "<td>";
- sales_types_list($name, $selected_id);
+ sales_types_list($name, $selected_id, $submit_on_change);
echo "</td>\n";
}
-function sales_types_list_row($label, $name, $selected_id)
+function sales_types_list_row($label, $name, $selected_id, $submit_on_change=false)
{
echo "<tr>\n";
- sales_types_list_cells($label, $name, $selected_id);
+ sales_types_list_cells($label, $name, $selected_id, $submit_on_change);
echo "</tr>\n";
}
function workcenter_list($name, $selected_id, $all_option=false)
{
global $all_items;
+
+ default_focus($name);
echo "<select name='$name'>";
$sql = "SELECT id, name FROM ".TB_PREF."workcentres";
function workcenter_list_cells($label, $name, $selected_id, $all_option=false)
{
+ default_focus($name);
if ($label != null)
echo "<td>$label</td>\n";
echo "<td>";
function bank_accounts_list($name, $selected_id, $submit_on_change=false)
{
+ default_focus($name);
if ($submit_on_change==true)
echo "<select name='$name' onchange='this.form.submit();'>";
else
function class_list($name, $selected_id, $submit_on_change=false)
{
+ default_focus($name);
if ($submit_on_change==true)
echo "<select name='$name' onchange='this.form.submit();'>";
else
function gl_all_accounts_list($name, $selected_id, $skip_bank_accounts=false,
$show_group=false, $onchange="")
{
+ default_focus($name);
echo "<select name='$name'";
if ($onchange != "")
echo " onchange='$onchange'";
function yesno_list($name, $selected_id, $name_yes="", $name_no="", $submit_on_change=false)
{
+ default_focus($name);
if ($submit_on_change == true)
echo "<select name='$name' onchange='this.form.submit();'>";
else
{
global $installed_languages;
+ default_focus($name);
echo "<select name='$name'>";
if ($selected_id == null)
{
$bank_account_types = bank_account_types::get_all();
+ default_focus($name);
echo "<select name='$name'>";
if ($selected_id == null)
{
$types = payment_person_types::get_all();
+ default_focus($name);
echo "<select name='$name'";
if ($related)
echo " onchange='this.form.$related.value=\"\"; this.form.submit();' ";
{
$types = wo_types::get_all();
+ default_focus($name);
echo "<select name='$name' onchange='this.form.submit();'>";
if ($selected_id == null)
{
global $dateformats;
+ default_focus($name);
echo "<tr><td>$label</td>\n";
echo "<td><select name='$name'>";
{
global $dateseps;
+ default_focus($name);
echo "<tr><td>$label</td>\n";
echo "<td><select name='$name'>";
{
global $thoseps;
+ default_focus($name);
echo "<tr><td>$label</td>\n";
echo "<td><select name='$name'>";
{
global $decseps;
+ default_focus($name);
echo "<tr><td>$label</td>\n";
echo "<td><select name='$name'>";
function themes_list_row($label, $name, $value)
{
- global $themes;
+ global $path_to_root;
+ default_focus($name);
+ $path = $path_to_root.'/themes/';
+ $themes = array();
+ $themedir = opendir($path);
+ while(false !== ($fname = readdir($themedir))) {
+ if($fname!='.' && $fname!='..' && $fname!='CVS' && is_dir($path.$fname)) {
+ $themes[] = $fname;
+ }
+ }
+ sort($themes);
echo "<tr><td>$label</td>\n";
echo "<td><select name='$name'>";
{
global $pagesizes;
+ default_focus($name);
echo "<tr><td>$label</td>\n";
echo "<td><select name='$name'>";
{
global $security_headings;
+ default_focus($name);
echo "<tr><td>$label</td>\n";
echo "<td><select name='$name'>";
{
global $systypes_array;
+ default_focus($name);
if ($label != null)
echo "<td>$label</td>\n";
echo "<td><select name='$name'";
function cust_allocations_list_cells($label, $name, $selected)
{
global $all_items;
+ default_focus($name);
if ($label != null)
label_cell($label);
if ($selected == null)
function supp_allocations_list_cells($name, $selected)
{
global $all_items;
+
+ default_focus($name);
if ($selected == null)
$selected = (!isset($_POST[$name]) ? "" : $_POST[$name]);
echo "<td><select name='$name'>";
function policy_list_cells($label, $name, $selected)
{
+ default_focus($name);
if ($selected == null)
{
$selected = (!isset($_POST[$name]) ? "" : $_POST[$name]);
function credit_type_list_cells($label, $name, $selected, $submit_on_change=false)
{
+ default_focus($name);
if ($selected == null)
{
$selected = (!isset($_POST[$name]) ? "Return" : $_POST[$name]);
function number_list($name, $selected, $from, $to, $firstlabel="")
{
+ default_focus($name);
if ($selected == null)
{
$selected = (!isset($_POST[$name]) ? $from : $_POST[$name]);