X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Fmanage%2Fsales_groups.php;h=73b4467a3d5382c3efec42d88beafbf2a8b0ec77;hb=231addc23887aa8b906dca18ea0b2a6fe63c3c39;hp=f2c4126f35d708625f0c78602d4dc8aeaa961dfc;hpb=b61fe995e432d77ff3ff0b5850bb921920f3befb;p=fa-stable.git diff --git a/sales/manage/sales_groups.php b/sales/manage/sales_groups.php index f2c4126f..73b4467a 100644 --- a/sales/manage/sales_groups.php +++ b/sales/manage/sales_groups.php @@ -1,13 +1,13 @@ . + See the License here . ***********************************************************************/ $page_security = 3; $path_to_root="../.."; @@ -57,7 +57,7 @@ if ($Mode == 'Delete') // PREVENT DELETES IF DEPENDENT RECORDS IN 'debtors_master' - $sql= "SELECT COUNT(*) FROM ".TB_PREF."debtors_master WHERE group_no='$selected_id'"; + $sql= "SELECT COUNT(*) FROM ".TB_PREF."cust_branch WHERE group_no='$selected_id'"; $result = db_query($sql,"check failed"); $myrow = db_fetch_row($result); if ($myrow[0] > 0) @@ -78,16 +78,22 @@ if ($Mode == 'Delete') if ($Mode == 'RESET') { $selected_id = -1; + $sav = get_post('show_inactive'); unset($_POST); + if ($sav) $_POST['show_inactive'] = 1; } //------------------------------------------------------------------------------------------------- -$sql = "SELECT * FROM ".TB_PREF."groups ORDER BY description"; +$sql = "SELECT * FROM ".TB_PREF."groups"; +if (!check_value('show_inactive')) $sql .= " WHERE !inactive"; +$sql .= " ORDER BY description"; $result = db_query($sql,"could not get groups"); start_form(); start_table("$table_style width=30%"); $th = array(_("Group Name"), "", ""); +inactive_control_column($th); + table_header($th); $k = 0; @@ -97,20 +103,19 @@ while ($myrow = db_fetch($result)) alt_table_row_color($k); label_cell($myrow["description"]); + inactive_control_cell($myrow["id"], $myrow["inactive"], 'groups', 'id'); edit_button_cell("Edit".$myrow["id"], _("Edit")); delete_button_cell("Delete".$myrow["id"], _("Delete")); end_row(); } - +inactive_control_row($th); end_table(); -end_form(); + echo '
'; //------------------------------------------------------------------------------------------------- -start_form(); - start_table($table_style2); if ($selected_id != -1) @@ -131,7 +136,7 @@ text_row_ex(_("Group Name:"), 'description', 30); end_table(1); -submit_add_or_update_center($selected_id == -1, '', true); +submit_add_or_update_center($selected_id == -1, '', 'both'); end_form();