$_POST['loc_code'] = $myrow["loc_code"];
$_POST['component'] = $myrow["component"];
// by Tom Moulton
$_POST['workcentre_added'] = $myrow["workcentre_added"];
$_POST['quantity'] = number_format2($myrow["quantity"], get_qty_dec($myrow["component"]));
label_row(_("Component:"), $myrow["component"] . " - " . $myrow["description"]);
}
hidden('selected_id', $selected_id);
} else {
start_row();
label_cell(_("Component:"), "class='label'");
echo "<td>";
echo stock_component_items_list('component', $selected_parent, null, false, true);
if (get_post('_component_update')) {
$Ajax->activate('quantity');
}
echo "</td>";
end_row();
}
hidden('stock_id', $selected_parent);
locations_list_row(_("Location to Draw From:"), 'loc_code', null);
workcenter_list_row(_("Work Centre Added:"), 'workcentre_added', null);
$dec = get_qty_dec(get_post('component'));
$_POST['quantity'] = number_format2(input_num('quantity', 1), $dec);
qty_row(_("Quantity:"), 'quantity', null, null, null, $dec);
end_table(1);
submit_add_or_update_center($selected_id == -1, '', 'both');
end_form();
}
// ----------------------------------------------------------------------------------
end_page();
echo "</table>";
echo "</td><td class='tableseparator'>";
// outer table
echo "<table>";
table_section_title(tr("GL Accounts"));
gl_all_accounts_list_row(tr("Sales Account:"), 'sales_account', $_POST['sales_account']);
gl_all_accounts_list_row(tr("Sales Discount Account:"), 'sales_discount_account', $_POST['sales_discount_account']);
gl_all_accounts_list_row(tr("Accounts Receivable Account:"), 'receivables_account', $_POST['receivables_account']);
gl_all_accounts_list_row(tr("Prompt Payment Discount Account:"), 'payment_discount_account', $_POST['payment_discount_account']);
table_section_title(tr("Addresses"));
textarea_row(tr("Mailing Address:"), 'br_post_address', $_POST['br_post_address'], 35, 5);
textarea_row(tr("Billing Address:"), 'br_address', $_POST['br_address'], 35, 5);
end_table();
end_table(1);
// outer table
submit_add_or_update_center(isset($_POST['New']));
end_form();
end_page();
function check_branches()
{
$cust = $_POST['customer_id'];
$branch = $_POST['branch_code'];
if ($cust != "" && $branch != "") {
$sql = "SELECT branch_code from cust_branch WHERE debtor_no={$cust} AND " . "branch_code={$branch} ORDER BY branch_code ASC";
$result = db_query($sql);
$myrow = db_fetch_row($result);
if ($myrow[0] == 0) {
$branch = '';
}
}
if ($cust != "" && $branch == '') {
end_table();
//------------------------------------------------------------------------------------------------
hyperlink_no_params($_SERVER['PHP_SELF'], tr("New Sales Person"));
//------------------------------------------------------------------------------------------------
start_form();
if (isset($selected_id)) {
//editing an existing Sales-person
$sql = "SELECT * FROM salesman WHERE salesman_code='{$selected_id}'";
$result = db_query($sql, "could not get sales person");
$myrow = db_fetch($result);
$_POST['salesman_name'] = $myrow["salesman_name"];
$_POST['salesman_phone'] = $myrow["salesman_phone"];
$_POST['salesman_fax'] = $myrow["salesman_fax"];
$_POST['salesman_email'] = $myrow["salesman_email"];
$_POST['provision'] = percent_format($myrow["provision"]);
$_POST['break_pt'] = price_format($myrow["break_pt"]);
$_POST['provision2'] = percent_format($myrow["provision2"]);
hidden('selected_id', $selected_id);
}
start_table("{$table_style2} width=60%");
text_row_ex(tr("Sales person name:"), 'salesman_name', 30);
text_row_ex(tr("Telephone number:"), 'salesman_phone', 20);
text_row_ex(tr("Fax number:"), 'salesman_fax', 20);
text_row_ex(tr("Email:"), 'salesman_email', 40);
percent_row(tr("Provision"), 'provision');
amount_row(tr("Break Pt.:"), 'break_pt');
percent_row(tr("Provision") . " 2", 'provision2');
end_table(1);
submit_add_or_update_center(!isset($selected_id));
end_form();
end_page();
function display_fiscalyear_edit($selected_id)
{
global $Mode;
start_form();
start_table(TABLESTYLE2);
$company_year = get_company_pref('f_year');
$result = get_all_fiscalyears();
$row_cnt = db_num_rows($result);
if ($selected_id != -1) {
if ($Mode == 'Edit') {
$myrow = get_fiscalyear($selected_id);
$_POST['from_date'] = sql2date($myrow["begin"]);
$_POST['to_date'] = sql2date($myrow["end"]);
$_POST['closed'] = $myrow["closed"];
}
if ($row_cnt == 1) {
date_row(_("Fiscal Year Begin:"), 'from_date', '', null, 0, 0, 1001);
} else {
hidden('from_date');
label_row(_("Fiscal Year Begin:"), $_POST['from_date']);
}
hidden('to_date');
label_row(_("Fiscal Year End:"), $_POST['to_date']);
if ($myrow["id"] != $company_year) {
yesno_list_row(_("Is Closed:"), 'closed', null, "", "", false);
} else {
hidden('closed');
label_row(_("Is Closed:"), yesno_value($_POST['closed']));
}
} else {
$begin = next_begin_date();
if ($begin && $Mode != 'ADD_ITEM') {
$_POST['from_date'] = $begin;
$_POST['to_date'] = end_month(add_months($begin, 11));
$_POST['closed'] = 0;
}
hidden('from_date');
hidden('to_date');
hidden('closed');
}
hidden('selected_id', $selected_id);
end_table(1);
submit_add_or_update_center($selected_id == -1, '', 'both');
end_form();
}
function display_currency_edit($selected_id)
{
global $Mode;
start_table(TABLESTYLE2);
if ($selected_id != '') {
if ($Mode == 'Edit') {
//editing an existing currency
$myrow = get_currency($selected_id);
$_POST['Abbreviation'] = $myrow["curr_abrev"];
$_POST['Symbol'] = $myrow["curr_symbol"];
$_POST['CurrencyName'] = $myrow["currency"];
$_POST['country'] = $myrow["country"];
$_POST['hundreds_name'] = $myrow["hundreds_name"];
$_POST['auto_update'] = $myrow["auto_update"];
}
hidden('Abbreviation');
hidden('selected_id', $selected_id);
label_row(_("Currency Abbreviation:"), $_POST['Abbreviation']);
} else {
$_POST['auto_update'] = 1;
text_row_ex(_("Currency Abbreviation:"), 'Abbreviation', 4, 3);
}
text_row_ex(_("Currency Symbol:"), 'Symbol', 10);
text_row_ex(_("Currency Name:"), 'CurrencyName', 20);
text_row_ex(_("Hundredths Name:"), 'hundreds_name', 15);
text_row_ex(_("Country:"), 'country', 40);
check_row(_("Automatic exchange rate update:"), 'auto_update', get_post('auto_update'));
end_table(1);
submit_add_or_update_center($selected_id == '', '', 'both');
}
function display_fiscalyear_edit($selected_id)
{
global $Mode;
start_form();
start_table(TABLESTYLE2);
if ($selected_id != -1) {
if ($Mode == 'Edit') {
$myrow = get_fiscalyear($selected_id);
$_POST['from_date'] = sql2date($myrow["begin"]);
$_POST['to_date'] = sql2date($myrow["end"]);
$_POST['closed'] = $myrow["closed"];
}
hidden('from_date');
hidden('to_date');
label_row(_("Fiscal Year Begin:"), $_POST['from_date']);
label_row(_("Fiscal Year End:"), $_POST['to_date']);
} else {
$begin = next_begin_date();
if ($begin && $Mode != 'ADD_ITEM') {
$_POST['from_date'] = $begin;
$_POST['to_date'] = end_month(add_months($begin, 11));
}
date_row(_("Fiscal Year Begin:"), 'from_date', '', null, 0, 0, 1001);
date_row(_("Fiscal Year End:"), 'to_date', '', null, 0, 0, 1001);
}
hidden('selected_id', $selected_id);
yesno_list_row(_("Is Closed:"), 'closed', null, "", "", false);
end_table(1);
submit_add_or_update_center($selected_id == -1, '', 'both');
end_form();
}
}
label_cell($myrow["cid"]);
label_cell($myrow['class_name']);
label_cell($bs_text);
edit_link_cell("selected_id=" . $myrow["cid"]);
delete_link_cell("selected_id=" . $myrow["cid"] . "&delete=1");
end_row();
}
end_table();
//-----------------------------------------------------------------------------------
hyperlink_no_params($_SERVER['PHP_SELF'], tr("New Account Class"));
start_form();
start_table($table_style2);
if ($selected_id != -1) {
//editing an existing status code
$myrow = get_account_class($selected_id);
$_POST['id'] = $myrow["cid"];
$_POST['name'] = $myrow["class_name"];
$_POST['Balance'] = $myrow["balance_sheet"];
hidden('selected_id', $selected_id);
label_row(tr("Class ID:"), $_POST['id']);
} else {
text_row_ex(tr("Class ID:"), 'id', 3);
}
text_row_ex(tr("Class Name:"), 'name', 50);
yesno_list_row(tr("Balance Sheet:"), 'Balance', null, "", "", false);
end_table(1);
submit_add_or_update_center($selected_id == -1);
end_form();
//------------------------------------------------------------------------------------
end_page();
function display_rate_edit()
{
global $selected_id, $Ajax, $xr_providers, $dflt_xr_provider;
$xchg_rate_provider = isset($xr_providers) && isset($dflt_xr_provider) ? $xr_providers[$dflt_xr_provider] : 'ECB';
start_table(TABLESTYLE2);
if ($selected_id != "") {
//editing an existing exchange rate
$myrow = get_exchange_rate($selected_id);
$_POST['date_'] = sql2date($myrow["date_"]);
$_POST['BuyRate'] = maxprec_format($myrow["rate_buy"]);
hidden('selected_id', $selected_id);
hidden('date_', $_POST['date_']);
label_row(_("Date to Use From:"), $_POST['date_']);
} else {
$_POST['date_'] = Today();
$_POST['BuyRate'] = '';
date_row(_("Date to Use From:"), 'date_');
}
if (isset($_POST['get_rate'])) {
$_POST['BuyRate'] = maxprec_format(retrieve_exrate($_POST['curr_abrev'], $_POST['date_']));
$Ajax->activate('BuyRate');
}
amount_row(_("Exchange Rate:"), 'BuyRate', null, '', submit('get_rate', _("Get"), false, _('Get current rate from') . ' ' . $xchg_rate_provider, true), 'max');
end_table(1);
submit_add_or_update_center($selected_id == '', '', 'both');
display_note(_("Exchange rates are entered against the company currency."), 1);
}
function display_rate_edit()
{
global $selected_id, $table_style2;
start_table($table_style2);
if (isset($_POST['get_rate'])) {
$_POST['BuyRate'] = exrate_format(get_ecb_rate($_POST['curr_abrev']));
}
if ($selected_id != "") {
//editing an existing exchange rate
$myrow = get_exchange_rate($selected_id);
$_POST['date_'] = sql2date($myrow["date_"]);
$_POST['BuyRate'] = exrate_format($myrow["rate_buy"]);
hidden('selected_id', $selected_id);
hidden('date_', $_POST['date_']);
hidden('curr_abrev', $_POST['curr_abrev']);
label_row(tr("Date to Use From:"), $_POST['date_']);
} else {
date_row(tr("Date to Use From:"), 'date_');
}
small_amount_row(tr("Exchange Rate:"), 'BuyRate', null, '', submit('get_rate', tr("Get")), user_exrate_dec());
end_table(1);
submit_add_or_update_center($selected_id == "");
display_note(tr("Exchange rates are entered against the company currency."), 1);
}
function display_language_edit($selected_id)
{
global $installed_languages, $dflt_lang;
if ($selected_id == -1) {
$n = count($installed_languages);
} else {
$n = $selected_id;
}
start_form(true);
start_table(TABLESTYLE2);
if ($selected_id != -1) {
$lang = $installed_languages[$n];
$_POST['code'] = $lang['code'];
$_POST['name'] = $lang['name'];
$_POST['encoding'] = $lang['encoding'];
if (isset($lang['rtl']) && $lang['rtl'] === true) {
$_POST['rtl'] = $lang['rtl'];
} else {
$_POST['rtl'] = false;
}
$_POST['dflt'] = $dflt_lang == $lang['code'];
hidden('selected_id', $selected_id);
}
text_row_ex(_("Language Code"), 'code', 20);
text_row_ex(_("Language Name"), 'name', 20);
text_row_ex(_("Encoding"), 'encoding', 20);
yesno_list_row(_("Right To Left"), 'rtl', null, "", "", false);
yesno_list_row(_("Default Language"), 'dflt', null, "", "", false);
file_row(_("Language File") . " (PO)", 'uploadfile');
file_row(_("Language File") . " (MO)", 'uploadfile2');
end_table(0);
display_note(_("Select your language files from your local harddisk."), 0, 1);
submit_add_or_update_center(false, '', 'both');
end_form();
}
$sql = get_sql_for_attached_documents($type);
$cols = array(_("#") => array('fun' => 'trans_view', 'ord' => ''), _("Description") => array('name' => 'description'), _("Filename") => array('name' => 'filename'), _("Size") => array('name' => 'filesize'), _("Filetype") => array('name' => 'filetype'), _("Date Uploaded") => array('name' => 'tran_date', 'type' => 'date'), array('insert' => true, 'fun' => 'edit_link'), array('insert' => true, 'fun' => 'view_link'), array('insert' => true, 'fun' => 'download_link'), array('insert' => true, 'fun' => 'delete_link'));
$table =& new_db_pager('trans_tbl', $sql, $cols);
$table->width = "60%";
display_db_pager($table);
}
//----------------------------------------------------------------------------------------
start_form(true);
viewing_controls();
display_rows($_POST['filterType']);
br(2);
start_table(TABLESTYLE2);
if ($selected_id != -1) {
if ($Mode == 'Edit') {
$row = get_attachment($selected_id);
$_POST['trans_no'] = $row["trans_no"];
$_POST['description'] = $row["description"];
hidden('trans_no', $row['trans_no']);
hidden('unique_name', $row['unique_name']);
label_row(_("Transaction #"), $row['trans_no']);
}
hidden('selected_id', $selected_id);
} else {
text_row_ex(_("Transaction #") . ':', 'trans_no', 10);
}
text_row_ex(_("Description") . ':', 'description', 40);
file_row(_("Attached File") . ":", 'filename', 'filename');
end_table(1);
submit_add_or_update_center($selected_id == -1, '', 'process');
end_form();
end_page();
function display_fiscalyear_edit($selected_id)
{
global $table_style2;
start_form();
start_table($table_style2);
if ($selected_id) {
$myrow = get_fiscalyear($selected_id);
$_POST['from_date'] = sql2date($myrow["begin"]);
$_POST['to_date'] = sql2date($myrow["end"]);
$_POST['closed'] = $myrow["closed"];
hidden('selected_id', $selected_id);
hidden('from_date', $_POST['from_date']);
hidden('to_date', $_POST['to_date']);
label_row(tr("Fiscal Year Begin:"), $_POST['from_date']);
label_row(tr("Fiscal Year End:"), $_POST['to_date']);
} else {
date_row(tr("Fiscal Year Begin:"), 'from_date', null, 0, 0, 1001);
date_row(tr("Fiscal Year End:"), 'to_date', null, 0, 0, 1001);
}
yesno_list_row(tr("Is Closed:"), 'closed', null, "", "", false);
end_table(1);
submit_add_or_update_center(!isset($selected_id));
end_form();
}
function display_currency_edit($selected_id)
{
global $table_style2;
start_form();
start_table($table_style2);
if ($selected_id != "") {
//editing an existing currency
$myrow = get_currency($selected_id);
$_POST['Abbreviation'] = $myrow["curr_abrev"];
$_POST['Symbol'] = $myrow["curr_symbol"];
$_POST['CurrencyName'] = $myrow["currency"];
$_POST['country'] = $myrow["country"];
$_POST['hundreds_name'] = $myrow["hundreds_name"];
hidden('selected_id', $selected_id);
hidden('Abbreviation', $_POST['Abbreviation']);
label_row(tr("Currency Abbreviation:"), $_POST['Abbreviation']);
} else {
text_row_ex(tr("Currency Abbreviation:"), 'Abbreviation', 4, 3);
}
text_row_ex(tr("Currency Symbol:"), 'Symbol', 10);
text_row_ex(tr("Currency Name:"), 'CurrencyName', 20);
text_row_ex(tr("Hundredths Name:"), 'hundreds_name', 15);
text_row_ex(tr("Country:"), 'country', 40);
end_table(1);
submit_add_or_update_center($selected_id == "");
end_form();
}
function branch_settings($selected_id)
{
global $Mode, $num_branches;
start_outer_table(TABLESTYLE2);
table_section(1);
$_POST['email'] = "";
if ($selected_id != -1) {
if ($Mode == 'Edit' || !isset($_POST['br_name'])) {
//editing an existing branch
$myrow = get_cust_branch($_POST['customer_id'], $_POST['branch_code']);
set_focus('br_name');
$_POST['branch_code'] = $myrow["branch_code"];
$_POST['br_name'] = $myrow["br_name"];
$_POST['br_ref'] = $myrow["branch_ref"];
$_POST['br_address'] = $myrow["br_address"];
$_POST['br_post_address'] = $myrow["br_post_address"];
// $_POST['contact_name'] = $myrow["contact_name"];
$_POST['salesman'] = $myrow["salesman"];
$_POST['area'] = $myrow["area"];
// $_POST['rep_lang'] =$myrow["rep_lang"];
// $_POST['phone'] =$myrow["phone"];
// $_POST['phone2'] =$myrow["phone2"];
// $_POST['fax'] =$myrow["fax"];
// $_POST['email'] =$myrow["email"];
$_POST['tax_group_id'] = $myrow["tax_group_id"];
$_POST['disable_trans'] = $myrow['disable_trans'];
$_POST['default_location'] = $myrow["default_location"];
$_POST['default_ship_via'] = $myrow['default_ship_via'];
$_POST['sales_account'] = $myrow["sales_account"];
$_POST['sales_discount_account'] = $myrow['sales_discount_account'];
$_POST['receivables_account'] = $myrow['receivables_account'];
$_POST['payment_discount_account'] = $myrow['payment_discount_account'];
$_POST['group_no'] = $myrow["group_no"];
$_POST['notes'] = $myrow["notes"];
}
} elseif ($Mode != 'ADD_ITEM') {
//end of if $SelectedBranch only do the else when a new record is being entered
$myrow = get_default_info_for_branch($_POST['customer_id']);
// $_POST['rep_lang'] = $myrow['rep_lang'];
if (!$num_branches) {
$_POST['br_name'] = $myrow["name"];
$_POST['br_ref'] = $myrow["debtor_ref"];
$_POST['contact_name'] = _('Main Branch');
$_POST['br_address'] = $_POST['br_post_address'] = $myrow["address"];
}
$_POST['branch_code'] = "";
if (!isset($_POST['sales_account']) || !isset($_POST['sales_discount_account'])) {
$company_record = get_company_prefs();
// We use the Item Sales Account as default!
// $_POST['sales_account'] = $company_record["default_sales_act"];
$_POST['sales_account'] = $_POST['notes'] = '';
$_POST['sales_discount_account'] = $company_record['default_sales_discount_act'];
$_POST['receivables_account'] = $company_record['debtors_act'];
$_POST['payment_discount_account'] = $company_record['default_prompt_payment_act'];
}
}
hidden('popup', @$_REQUEST['popup']);
table_section_title(_("Name and Contact"));
text_row(_("Branch Name:"), 'br_name', null, 35, 40);
text_row(_("Branch Short Name:"), 'br_ref', null, 30, 30);
table_section_title(_("Sales"));
sales_persons_list_row(_("Sales Person:"), 'salesman', null);
sales_areas_list_row(_("Sales Area:"), 'area', null);
sales_groups_list_row(_("Sales Group:"), 'group_no', null, true);
locations_list_row(_("Default Inventory Location:"), 'default_location', null);
shippers_list_row(_("Default Shipping Company:"), 'default_ship_via', null);
tax_groups_list_row(_("Tax Group:"), 'tax_group_id', null);
table_section_title(_("GL Accounts"));
// 2006-06-14. Changed gl_al_accounts_list to have an optional all_option 'Use Item Sales Accounts'
gl_all_accounts_list_row(_("Sales Account:"), 'sales_account', null, false, false, true);
gl_all_accounts_list_row(_("Sales Discount Account:"), 'sales_discount_account');
gl_all_accounts_list_row(_("Accounts Receivable Account:"), 'receivables_account', null, true);
gl_all_accounts_list_row(_("Prompt Payment Discount Account:"), 'payment_discount_account');
table_section(2);
if ($selected_id == -1) {
table_section_title(_("General contact data"));
text_row(_("Contact Person:"), 'contact_name', null, 35, 40);
text_row(_("Phone Number:"), 'phone', null, 32, 30);
text_row(_("Secondary Phone Number:"), 'phone2', null, 32, 30);
text_row(_("Fax Number:"), 'fax', null, 32, 30);
email_row(_("E-mail:"), 'email', null, 35, 55);
languages_list_row(_("Document Language:"), 'rep_lang', null, _("Customer default"));
}
table_section_title(_("Addresses"));
textarea_row(_("Mailing Address:"), 'br_post_address', null, 35, 4);
textarea_row(_("Billing Address:"), 'br_address', null, 35, 4);
textarea_row(_("General Notes:"), 'notes', null, 35, 4);
if ($selected_id != -1) {
yesno_list_row(_("Disable this Branch:"), 'disable_trans', null);
}
end_outer_table(1);
submit_add_or_update_center($selected_id == -1, '', 'both');
}
