6 include($path_to_root . "/includes/session.inc");
8 page(_("Sales Areas"));
10 include($path_to_root . "/includes/ui.inc");
12 if (isset($_GET['selected_id']))
14 $selected_id = strtoupper($_GET['selected_id']);
16 elseif (isset($_POST['selected_id']))
18 $selected_id = strtoupper($_POST['selected_id']);
21 if (isset($_POST['ADD_ITEM']) || isset($_POST['UPDATE_ITEM']))
26 if (strlen($_POST['description']) == 0)
29 display_error(_("The area description cannot be empty."));
32 if ($input_error != 1)
34 if (isset($selected_id))
36 $sql = "UPDATE ".TB_PREF."areas SET description=".db_escape($_POST['description'])." WHERE area_code = '$selected_id'";
41 $sql = "INSERT INTO ".TB_PREF."areas (description) VALUES (".db_escape($_POST['description']) . ")";
44 db_query($sql,"The sales area could not be updated or added");
46 meta_forward($_SERVER['PHP_SELF']);
50 if (isset($_GET['delete']))
55 // PREVENT DELETES IF DEPENDENT RECORDS IN 'debtors_master'
57 $sql= "SELECT COUNT(*) FROM ".TB_PREF."cust_branch WHERE area='$selected_id'";
58 $result = db_query($sql,"check failed");
59 $myrow = db_fetch_row($result);
63 display_error(_("Cannot delete this area because customer branches have been created using this area."));
65 if ($cancel_delete == 0)
67 $sql="DELETE FROM ".TB_PREF."areas WHERE area_code='" . $selected_id . "'";
68 db_query($sql,"could not delete sales area");
70 meta_forward($_SERVER['PHP_SELF']);
71 } //end if Delete area
74 //-------------------------------------------------------------------------------------------------
76 $sql = "SELECT * FROM ".TB_PREF."areas";
77 $result = db_query($sql,"could not get areas");
79 start_table("$table_style width=40%");
80 $th = array(_("Area Name"), "", "");
84 while ($myrow = db_fetch($result))
87 alt_table_row_color($k);
89 label_cell($myrow["description"]);
90 edit_link_cell("selected_id=" . $myrow["area_code"]);
91 delete_link_cell("selected_id=" . $myrow["area_code"]. "&delete=1");
97 hyperlink_no_params($_SERVER['PHP_SELF'], _("New Sales Area"));
99 //-------------------------------------------------------------------------------------------------
103 start_table("$table_style2 width=40%");
105 if (isset($selected_id))
107 //editing an existing area
108 $sql = "SELECT * FROM ".TB_PREF."areas WHERE area_code='$selected_id'";
110 $result = db_query($sql,"could not get area");
111 $myrow = db_fetch($result);
113 $_POST['description'] = $myrow["description"];
114 hidden("selected_id", $selected_id);
117 text_row_ex(_("Area Name:"), 'description', 30);
121 submit_add_or_update_center(!isset($selected_id));