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 customer_settings($selected_id)
{
global $SysPrefs, $path_to_root, $auto_create_branch;
if (!$selected_id) {
if (list_updated('customer_id') || !isset($_POST['CustName'])) {
$_POST['CustName'] = $_POST['cust_ref'] = $_POST['address'] = $_POST['tax_id'] = '';
$_POST['dimension_id'] = 0;
$_POST['dimension2_id'] = 0;
$_POST['sales_type'] = -1;
$_POST['curr_code'] = get_company_currency();
$_POST['credit_status'] = -1;
$_POST['payment_terms'] = $_POST['notes'] = '';
$_POST['discount'] = $_POST['pymt_discount'] = percent_format(0);
$_POST['credit_limit'] = price_format($SysPrefs->default_credit_limit());
}
} else {
$myrow = get_customer($selected_id);
$_POST['CustName'] = $myrow["name"];
$_POST['cust_ref'] = $myrow["debtor_ref"];
$_POST['address'] = $myrow["address"];
$_POST['tax_id'] = $myrow["tax_id"];
$_POST['dimension_id'] = $myrow["dimension_id"];
$_POST['dimension2_id'] = $myrow["dimension2_id"];
$_POST['sales_type'] = $myrow["sales_type"];
$_POST['curr_code'] = $myrow["curr_code"];
$_POST['credit_status'] = $myrow["credit_status"];
$_POST['payment_terms'] = $myrow["payment_terms"];
$_POST['discount'] = percent_format($myrow["discount"] * 100);
$_POST['pymt_discount'] = percent_format($myrow["pymt_discount"] * 100);
$_POST['credit_limit'] = price_format($myrow["credit_limit"]);
$_POST['notes'] = $myrow["notes"];
$_POST['inactive'] = $myrow["inactive"];
}
start_outer_table(TABLESTYLE2);
table_section(1);
table_section_title(_("Name and Address"));
text_row(_("Customer Name:"), 'CustName', $_POST['CustName'], 40, 80);
text_row(_("Customer Short Name:"), 'cust_ref', null, 30, 30);
textarea_row(_("Address:"), 'address', $_POST['address'], 35, 5);
text_row(_("GSTNo:"), 'tax_id', null, 40, 40);
if (!$selected_id || is_new_customer($selected_id)) {
currencies_list_row(_("Customer's Currency:"), 'curr_code', $_POST['curr_code']);
} else {
label_row(_("Customer's Currency:"), $_POST['curr_code']);
hidden('curr_code', $_POST['curr_code']);
}
sales_types_list_row(_("Sales Type/Price List:"), 'sales_type', $_POST['sales_type']);
if ($selected_id) {
record_status_list_row(_("Customer status:"), 'inactive');
} elseif (isset($auto_create_branch) && $auto_create_branch == 1) {
table_section_title(_("Branch"));
text_row(_("Phone:"), '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);
sales_persons_list_row(_("Sales Person:"), 'salesman', null);
}
table_section(2);
table_section_title(_("Sales"));
percent_row(_("Discount Percent:"), 'discount', $_POST['discount']);
percent_row(_("Prompt Payment Discount Percent:"), 'pymt_discount', $_POST['pymt_discount']);
amount_row(_("Credit Limit:"), 'credit_limit', $_POST['credit_limit']);
payment_terms_list_row(_("Payment Terms:"), 'payment_terms', $_POST['payment_terms']);
credit_status_list_row(_("Credit Status:"), 'credit_status', $_POST['credit_status']);
$dim = get_company_pref('use_dimension');
if ($dim >= 1) {
dimensions_list_row(_("Dimension") . " 1:", 'dimension_id', $_POST['dimension_id'], true, " ", false, 1);
}
if ($dim > 1) {
dimensions_list_row(_("Dimension") . " 2:", 'dimension2_id', $_POST['dimension2_id'], true, " ", false, 2);
}
if ($dim < 1) {
hidden('dimension_id', 0);
}
if ($dim < 2) {
hidden('dimension2_id', 0);
}
if ($selected_id) {
start_row();
echo '<td class="label">' . _('Customer branches') . ':</td>';
hyperlink_params_td($path_to_root . "/sales/manage/customer_branches.php", '<b>' . (@$_REQUEST['popup'] ? _("Select or &Add") : _("&Add or Edit ")) . '</b>', "debtor_no=" . $selected_id . (@$_REQUEST['popup'] ? '&popup=1' : ''));
end_row();
}
textarea_row(_("General Notes:"), 'notes', null, 35, 5);
if (!$selected_id && isset($auto_create_branch) && $auto_create_branch == 1) {
table_section_title(_("Branch"));
locations_list_row(_("Default Inventory Location:"), 'location');
shippers_list_row(_("Default Shipping Company:"), 'ship_via');
sales_areas_list_row(_("Sales Area:"), 'area', null);
tax_groups_list_row(_("Tax Group:"), 'tax_group_id', null);
}
end_outer_table(1);
div_start('controls');
if (!$selected_id) {
submit_center('submit', _("Add New Customer"), true, '', 'default');
} else {
submit_center_first('submit', _("Update Customer"), _('Update customer data'), @$_REQUEST['popup'] ? true : 'default');
submit_return('select', $selected_id, _("Select this customer and return to document entry."));
submit_center_last('delete', _("Delete Customer"), _('Delete customer data if have been never used'), true);
}
div_end();
}
//---------------
table_section_title(_("Customers and Sales Defaults"));
// default for customer branch
gl_all_accounts_list_row(_("Receivable Account:"), 'debtors_act');
gl_all_accounts_list_row(_("Sales Account:"), 'default_sales_act', null, false, false, true);
gl_all_accounts_list_row(_("Sales Discount Account:"), 'default_sales_discount_act');
gl_all_accounts_list_row(_("Prompt Payment Discount Account:"), 'default_prompt_payment_act');
text_row(_("Delivery Required By:"), 'default_delivery_required', $_POST['default_delivery_required'], 6, 6, '', "", _("days"));
//----------------
table_section(2);
table_section_title(_("Dimension Defaults"));
text_row(_("Dimension Required By After:"), 'default_dim_required', $_POST['default_dim_required'], 6, 6, '', "", _("days"));
//---------------
table_section_title(_("Suppliers and Purchasing"));
percent_row(_("Delivery Over-Receive Allowance:"), 'po_over_receive');
percent_row(_("Invoice Over-Charge Allowance:"), 'po_over_charge');
table_section_title(_("Suppliers and Purchasing Defaults"));
gl_all_accounts_list_row(_("Payable Account:"), 'creditors_act', $_POST['creditors_act']);
gl_all_accounts_list_row(_("Purchase Discount Account:"), 'pyt_discount_act', $_POST['pyt_discount_act']);
gl_all_accounts_list_row(_("GRN Clearing Account:"), 'grn_clearing_act', get_post('grn_clearing_act'), true, false, _("No postings on GRN"));
table_section_title(_("Inventory"));
check_row(_("Allow Negative Inventory:"), 'allow_negative_stock', null);
label_row(null, _("Warning: This may cause a delay in GL postings"), "", "class='stockmankofg' colspan=2");
table_section_title(_("Items Defaults"));
gl_all_accounts_list_row(_("Sales Account:"), 'default_inv_sales_act', $_POST['default_inv_sales_act']);
gl_all_accounts_list_row(_("Inventory Account:"), 'default_inventory_act', $_POST['default_inventory_act']);
// this one is default for items and suppliers (purchase account)
gl_all_accounts_list_row(_("C.O.G.S. Account:"), 'default_cogs_act', $_POST['default_cogs_act']);
gl_all_accounts_list_row(_("Inventory Adjustments Account:"), 'default_adj_act', $_POST['default_adj_act']);
gl_all_accounts_list_row(_("Item Assembly Costs Account:"), 'default_assembly_act', $_POST['default_assembly_act']);
//----------------
start_table("class='tablestyle_noborder'");
sales_types_list_row(tr("Sales Type/Price List:"), 'sales_type', $_POST['sales_type']);
$dim = get_company_pref('use_dimension');
if ($dim >= 1) {
dimensions_list_row(tr("Dimension") . " 1:", 'dimension_id', $_POST['dimension_id'], true, " ", false, 1);
}
if ($dim > 1) {
dimensions_list_row(tr("Dimension") . " 2:", 'dimension2_id', $_POST['dimension2_id'], true, " ", false, 2);
}
if ($dim < 1) {
hidden('dimension_id', 0);
}
if ($dim < 2) {
hidden('dimension2_id', 0);
}
percent_row(tr("Discount Percent:"), 'discount', $_POST['discount']);
percent_row(tr("Prompt Payment Discount Percent:"), 'pymt_discount', $_POST['pymt_discount']);
amount_row(tr("Credit Limit:"), 'credit_limit', $_POST['credit_limit']);
payment_terms_list_row(tr("Payment Terms:"), 'payment_terms', $_POST['payment_terms']);
credit_status_list_row(tr("Credit Status:"), 'credit_status', $_POST['credit_status']);
end_table();
end_table(1);
// outer table
if (isset($_POST['New'])) {
submit_center('submit', tr("Add New Customer"));
} else {
submit_center_first('submit', tr("Update Customer"));
submit_center_last('delete', tr("Delete Customer"));
}
end_form();
end_page();
$_POST['salesman_email'] = "";
if ($selected_id != -1) {
if ($Mode == 'Edit') {
//editing an existing Sales-person
$myrow = get_salesman($selected_id);
$_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);
} elseif ($Mode != 'ADD_ITEM') {
$_POST['provision'] = percent_format(0);
$_POST['break_pt'] = price_format(0);
$_POST['provision2'] = percent_format(0);
}
start_table(TABLESTYLE2);
text_row_ex(_("Sales person name:"), 'salesman_name', 30);
text_row_ex(_("Telephone number:"), 'salesman_phone', 20);
text_row_ex(_("Fax number:"), 'salesman_fax', 20);
email_row_ex(_("E-mail:"), 'salesman_email', 40);
percent_row(_("Provision") . ':', 'provision');
amount_row(_("Break Pt.:"), 'break_pt');
percent_row(_("Provision") . " 2:", 'provision2');
end_table(1);
submit_add_or_update_center($selected_id == -1, '', 'both');
end_form();
end_page();
}
inactive_control_row($th);
end_table(1);
//-----------------------------------------------------------------------------------
start_table(TABLESTYLE2);
if ($selected_id != -1) {
if ($Mode == 'Edit') {
//editing an existing status code
$myrow = get_asset_type($selected_id);
$_POST['name'] = $myrow["asset_type_name"];
$_POST['rate'] = $myrow["depreciation_rate"];
$_POST['asset_account'] = $myrow["asset_account"];
$_POST['depreciation_account'] = $myrow["depreciation_account"];
$_POST['accumulated_account'] = $myrow["accumulated_account"];
$_POST['valuation_account'] = $myrow["valuation_account"];
$_POST['disposal_account'] = $myrow["disposal_account"];
}
hidden('selected_id', $selected_id);
}
text_row(_("Asset Type:"), 'name', null, 50, 50);
percent_row(_("Depreciation Rate:"), 'rate', null, 50, 50);
gl_all_accounts_list_row(_("Asset Account:"), 'asset_account');
gl_all_accounts_list_row(_("Depreciation Account:"), 'depreciation_account');
gl_all_accounts_list_row(_("Accumulated Depreciation:"), 'accumulated_account');
gl_all_accounts_list_row(_("Asset Revaluation Account:"), 'valuation_account');
gl_all_accounts_list_row(_("Disposal Account:"), 'disposal_account');
end_table(1);
submit_add_or_update_center($selected_id == -1, '', 'both');
end_form();
//------------------------------------------------------------------------------------
end_page();
