display_error(_("This customer cannot be deleted because there are transactions that refer to it."));
} else {
if (key_in_foreign_table($selected_id, 'sales_orders', 'debtor_no')) {
$cancel_delete = 1;
display_error(_("Cannot delete the customer record because orders have been created against it."));
} else {
if (key_in_foreign_table($selected_id, 'cust_branch', 'debtor_no')) {
$cancel_delete = 1;
display_error(_("Cannot delete this customer because there are branch records set up against it."));
//echo "<br> 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
delete_customer($selected_id);
display_notification(_("Selected customer has been deleted."));
unset($_POST['customer_id']);
$selected_id = '';
$Ajax->activate('_page_body');
}
//end if Delete Customer
}
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;
function deleter($redisql)
{
delete_employee($redisql);
delete_customer($redisql);
delete_division($redisql);
}
<?php
require 'include.php';
$customer_id = $VAR['customer_id'];
/* make sure we got an ID number */
if (!isset($customer_id) || $customer_id == "") {
$smarty->assign('results', 'Please go back and select a customer');
die;
}
$q = "SELECT count(*) as count FROM `" . PRFX . "TABLE_WORK_ORDER` LEFT JOIN " . PRFX . "TABLE_INVOICE ON " . PRFX . "TABLE_WORK_ORDER.CUSTOMER_ID = " . PRFX . "TABLE_INVOICE.CUSTOMER_ID WHERE " . PRFX . "TABLE_WORK_ORDER.CUSTOMER_ID=" . $db->qstr($customer_id);
if (!($rs = $db->execute($q))) {
force_page('core', 'error&error_msg=MySQL Error: ' . $db->ErrorMsg() . '&menu=1&type=database');
exit;
}
if ($rs->fields['count'] > 0) {
force_page('customer', 'view&page_title=Customers&error_msg=You can not delete a customer who has work history.');
exit;
} else {
/* run the function and return the results */
if (!delete_customer($db, $customer_id)) {
force_page('core', 'error&error_msg=MySQL Error: ' . $db->ErrorMsg() . '&menu=1&type=database');
exit;
} else {
force_page('customer', 'view&page_title=Customers');
exit;
}
}
// Reset data
}
}
} else {
/* ##### Change Customer Data ##### */
if (isset($_POST["change"]) && $_POST["change"] == "修改") {
$cid = $data["select_cid"];
if (update_customer($data)) {
$output = "客戶資料更新完成~";
} else {
$output = "客戶資料更新發生問題";
}
} else {
if (isset($_POST["delete"]) && $_POST["delete"] == "刪除") {
$cid = $data["select_cid"];
if (delete_customer($cid)) {
$output = "資料刪除完成~";
unset($cid);
$data = array();
$_POST["display_form"] = "no";
} else {
$output = "客戶資料刪除發生問題";
}
} else {
if (isset($_POST["send_order"]) && $_POST["send_order"] == "報價傳送") {
/* ##### Check if customer exists. If not, insert a new record ##### */
$found = check_customer($data["tax_id"]);
if (!$found) {
$cid = add_customer($data);
} else {
$cid = $found;
public function delete($rest, $id)
{
$req = $rest->request();
$info = $req->post();
$cust = get_customer($id);
if ($cust == null) {
api_error(400, 'Invalid Customer ID');
}
delete_customer($id);
$cust = null;
$cust = get_customer($id);
if ($cust != null) {
api_error(500, 'Could Not Delete from Database');
} else {
api_success_response("Customer has been deleted");
}
}
