X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fmanage%2Fgl_account_types.php;h=a906f3e8b1c62a0c574f65f854d8ae24148b5ce9;hb=107a22ab168c1102f3f534a22cd5b8290331f17d;hp=4e2ce39ffed85b7616aaeca0dacfe04224cdee5a;hpb=c09be0dad6b05131e240349a375af7a4b7bf3444;p=fa-stable.git diff --git a/gl/manage/gl_account_types.php b/gl/manage/gl_account_types.php index 4e2ce39f..a906f3e8 100644 --- a/gl/manage/gl_account_types.php +++ b/gl/manage/gl_account_types.php @@ -1,10 +1,19 @@ . +***********************************************************************/ +$page_security = 'SA_GLACCOUNTGROUP'; +$path_to_root = "../.."; include($path_to_root . "/includes/session.inc"); -page(_("GL Account Groups")); +page(_($help_context = "GL Account Groups")); include($path_to_root . "/gl/includes/gl_db.inc"); @@ -13,18 +22,30 @@ include($path_to_root . "/includes/ui.inc"); simple_page_mode(false); //----------------------------------------------------------------------------------- -function can_process() +function can_process($selected_id) { - global $selected_id; - - if (strlen($_POST['name']) == 0) + if (strlen(trim($_POST['id'])) == 0) + { + display_error( _("The account group id cannot be empty.")); + set_focus('id'); + return false; + } + if (strlen(trim($_POST['name'])) == 0) { display_error( _("The account group name cannot be empty.")); set_focus('name'); return false; } + $type = get_account_type(trim($_POST['id'])); + if ($type && ($type['id'] != $selected_id)) + { + display_error( _("This account group id is already in use.")); + set_focus('id'); + return false; + } - if (isset($selected_id) && ($selected_id == $_POST['parent'])) + //if (strcmp($_POST['id'], $_POST['parent']) == 0) + if ($_POST['id'] === $_POST['parent']) { display_error(_("You cannot set an account group to be a subgroup of itself.")); return false; @@ -38,18 +59,19 @@ function can_process() if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM') { - if (can_process()) + if (can_process($selected_id)) { if ($selected_id != "") { - update_account_type($selected_id, $_POST['name'], $_POST['class_id'], $_POST['parent']); - display_notification(_('Selected account type has been updated')); + if (update_account_type($_POST['id'], $_POST['name'], $_POST['class_id'], $_POST['parent'], $_POST['old_id'])) + display_notification(_('Selected account type has been updated')); } else { - add_account_type($_POST['name'], $_POST['class_id'], $_POST['parent']); - display_notification(_('New account type has been added')); + if (add_account_type($_POST['id'], $_POST['name'], $_POST['class_id'], $_POST['parent'])) { + display_notification(_('New account type has been added')); + } } $Mode = 'RESET'; } @@ -57,25 +79,18 @@ if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM') //----------------------------------------------------------------------------------- -function can_delete($selected_id) +function can_delete($type) { - if ($selected_id == "") + if ($type == "") return false; - $sql= "SELECT COUNT(*) FROM ".TB_PREF."chart_master - WHERE account_type=$selected_id"; - $result = db_query($sql, "could not query chart master"); - $myrow = db_fetch_row($result); - if ($myrow[0] > 0) + + if (key_in_foreign_table($type, 'chart_master', 'account_type')) { display_error(_("Cannot delete this account group because GL accounts have been created referring to it.")); return false; } - $sql= "SELECT COUNT(*) FROM ".TB_PREF."chart_types - WHERE parent=$selected_id"; - $result = db_query($sql, "could not query chart types"); - $myrow = db_fetch_row($result); - if ($myrow[0] > 0) + if (key_in_foreign_table($type, 'chart_types', 'parent')) { display_error(_("Cannot delete this account group because GL account groups have been created referring to it.")); return false; @@ -93,23 +108,25 @@ if ($Mode == 'Delete') if (can_delete($selected_id)) { delete_account_type($selected_id); - display_notification(_('Selected currency has been deleted')); + display_notification(_('Selected account group has been deleted')); } $Mode = 'RESET'; } if ($Mode == 'RESET') { - $selected_id = ''; - $_POST['name'] = ''; + $selected_id = ""; + $_POST['id'] = $_POST['name'] = ''; unset($_POST['parent']); unset($_POST['class_id']); } //----------------------------------------------------------------------------------- -$result = get_account_types(); +$result = get_account_types(check_value('show_inactive')); + start_form(); -start_table($table_style); -$th = array(_("Name"), _("Subgroup Of"), _("Class Type"), "", ""); +start_table(TABLESTYLE); +$th = array(_("Group ID"), _("Group Name"), _("Subgroup Of"), _("Class"), "", ""); +inactive_control_column($th); table_header($th); $k = 0; @@ -120,7 +137,7 @@ while ($myrow = db_fetch($result)) $bs_text = get_account_class_name($myrow["class_id"]); - if ($myrow["parent"] == reserved_words::get_any_numeric()) + if ($myrow["parent"] == '-1') { $parent_text = ""; } @@ -129,43 +146,54 @@ while ($myrow = db_fetch($result)) $parent_text = get_account_type_name($myrow["parent"]); } + label_cell($myrow["id"]); label_cell($myrow["name"]); label_cell($parent_text); label_cell($bs_text); + inactive_control_cell($myrow["id"], $myrow["inactive"], 'chart_types', 'id'); edit_button_cell("Edit".$myrow["id"], _("Edit")); - edit_button_cell("Delete".$myrow["id"], _("Delete")); + delete_button_cell("Delete".$myrow["id"], _("Delete")); end_row(); } -end_table(); -end_form(); -echo '
'; +inactive_control_row($th); +end_table(1); //----------------------------------------------------------------------------------- -start_form(); - -start_table($table_style2); +start_table(TABLESTYLE2); -if ($Mode == 'Edit') +if ($selected_id != "") { - //editing an existing status code - $myrow = get_account_type($selected_id); - - $_POST['name'] = $myrow["name"]; - $_POST['parent'] = $myrow["parent"]; - $_POST['class_id'] = $myrow["class_id"]; - } - hidden('selected_id', $selected_id); - + if ($Mode == 'Edit') + { + //editing an existing status code + $myrow = get_account_type($selected_id); + + $_POST['id'] = $myrow["id"]; + $_POST['name'] = $myrow["name"]; + $_POST['parent'] = $myrow["parent"]; + if ($_POST['parent'] == '-1') + $_POST['parent'] == ""; + $_POST['class_id'] = $myrow["class_id"]; + hidden('selected_id', $myrow['id']); + hidden('old_id', $myrow["id"]); + } + else + { + hidden('selected_id', $selected_id); + hidden('old_id', $_POST["old_id"]); + } +} +text_row_ex(_("ID:"), 'id', 10); text_row_ex(_("Name:"), 'name', 50); gl_account_types_list_row(_("Subgroup Of:"), 'parent', null, _("None"), true); -class_list_row(_("Class Type:"), 'class_id', null); +class_list_row(_("Class:"), 'class_id', null); end_table(1); -submit_add_or_update_center($selected_id == '', '', true); +submit_add_or_update_center($selected_id == "", '', 'both'); end_form();