= 100) || ($_POST['pymt_discount'] < 0))
{
display_error(_("The payment discount is expected to be less than 100% and greater than or equal to 0."));
return false;
}
if (($_POST['discount'] >= 100) || ($_POST['discount'] < 0))
{
display_error(_("The discount percent is expected to be less than 100 and greater than or equal to 0."));
return false;
}
return true;
}
//--------------------------------------------------------------------------------------------
function handle_submit()
{
global $path_to_root;
if (!can_process())
return;
if (!isset($_POST['New']))
{
// Sherifoz 22.06.03 convert percent to fraction
$sql = "UPDATE ".TB_PREF."debtors_master SET name='" . $_POST['CustName'] . "',
address='" . $_POST['address'] . "',
tax_id='" . $_POST['tax_id'] . "',
curr_code='" . $_POST['curr_code'] . "',
email='" . $_POST['email'] . "',
dimension_id=" . $_POST['dimension_id'] . ",
dimension2_id=" . $_POST['dimension2_id'] . ",
credit_status='" . $_POST['credit_status'] . "',
payment_terms='" . $_POST['payment_terms'] . "',
discount=" . ($_POST['discount']) / 100 . ",
pymt_discount=" . ($_POST['pymt_discount']) / 100 . ",
credit_limit=" . $_POST['credit_limit'] . ",
sales_type = '" . $_POST['sales_type'] . "'
WHERE debtor_no = '" . $_POST['customer_id'] . "'";
db_query($sql,"The customer could not be updated");
display_notification(_("Customer has been updated."));
clear_fields();
}
else
{ //it is a new customer
begin_transaction();
$sql = "INSERT INTO ".TB_PREF."debtors_master (name, address, tax_id, email, dimension_id, dimension2_id,
curr_code, credit_status, payment_terms, discount, pymt_discount,credit_limit,
sales_type) VALUES ('" . $_POST['CustName'] ."', '" . $_POST['address'] . "', '" . $_POST['tax_id'] . "',
'" . $_POST['email'] . "', " . $_POST['dimension_id'] . ", " . $_POST['dimension2_id'] . ", '" . $_POST['curr_code'] . "',
" . $_POST['credit_status'] . ", '" . $_POST['payment_terms'] . "', " . ($_POST['discount'])/100 . ",
" . ($_POST['pymt_discount'])/100 . ", " . $_POST['credit_limit'] . ", '" . $_POST['sales_type'] . "')";
db_query($sql,"The customer could not be added");
$new_customer_id = db_insert_id();
commit_transaction();
display_notification(_("A new customer has been added."));
hyperlink_params($path_to_root . "/sales/manage/customer_branches.php", _("Add branches for this customer"), "debtor_no=$new_customer_id");
clear_fields();
}
}
//--------------------------------------------------------------------------------------------
if (isset($_POST['submit']))
{
handle_submit();
}
//--------------------------------------------------------------------------------------------
if (isset($_POST['delete']))
{
//the link to delete a selected record was clicked instead of the submit button
$cancel_delete = 0;
// PREVENT DELETES IF DEPENDENT RECORDS IN 'debtor_trans'
$sql= "SELECT COUNT(*) FROM ".TB_PREF."debtor_trans WHERE debtor_no='" . $_POST['customer_id'] . "'";
$result = db_query($sql,"check failed");
$myrow = db_fetch_row($result);
if ($myrow[0] > 0)
{
$cancel_delete = 1;
display_error(_("This customer cannot be deleted because there are transactions that refer to it."));
}
else
{
$sql= "SELECT COUNT(*) FROM ".TB_PREF."sales_orders WHERE debtor_no='" . $_POST['customer_id'] . "'";
$result = db_query($sql,"check failed");
$myrow = db_fetch_row($result);
if ($myrow[0] > 0)
{
$cancel_delete = 1;
display_error(_("Cannot delete the customer record because orders have been created against it."));
}
else
{
$sql = "SELECT COUNT(*) FROM ".TB_PREF."cust_branch WHERE debtor_no='" . $_POST['customer_id'] . "'";
$result = db_query($sql,"check failed");
$myrow = db_fetch_row($result);
if ($myrow[0] > 0)
{
$cancel_delete = 1;
display_error(_("Cannot delete this customer because there are branch records set up against it."));
//echo "
There are " . $myrow[0] . " branch records relating to this customer";
}
}
}
if ($cancel_delete == 0)
{ //ie not cancelled the delete as a result of above tests
$sql = "DELETE FROM ".TB_PREF."debtors_master WHERE debtor_no='" . $_POST['customer_id'] . "'";
db_query($sql,"cannot delete customer");
meta_forward($_SERVER['PHP_SELF']);
} //end if Delete Customer
}
function clear_fields()
{
unset($_POST['CustName']);
unset($_POST['address']);
unset($_POST['tax_id']);
unset($_POST['email']);
unset($_POST['dimension_id']);
unset($_POST['dimension2_id']);
unset($_POST['credit_status']);
unset($_POST['payment_terms']);
unset($_POST['discount']);
unset($_POST['pymt_discount']);
unset($_POST['credit_limit']);
unset($_POST['sales_type']);
unset($_POST['customer_id']);
$_POST['New'] = 1;
}
check_db_has_sales_types(_("There are no sales types defined. Please define at least one sales type before adding a customer."));
start_form();
if (db_has_customers())
{
start_table("class = 'tablestyle_noborder'");
start_row();
customer_list_cells(_("Select a customer: "), 'customer_id', null);
submit_cells('SelectCustomer', _("Edit Customer"));
end_row();
end_table();
}
else
{
hidden('customer_id', $_POST['customer_id']);
}
hyperlink_params($_SERVER['PHP_SELF'], _("Enter a new customer"), "New=1");
echo "
";
start_table($table_style2, 7, 6);
echo "