Example #1
0
 function edit_param()
 {
     $_POST['data_filter'] = $this->data_filter;
     $_POST['days_future'] = $this->days_future;
     text_row_ex(_("Days in future:"), 'days_future', 2);
     text_row_ex(_("Filter:"), 'data_filter', 50);
 }
 function edit_param()
 {
     global $top, $sequences, $asc_desc;
     $graph_types = array('LineChart' => _("Line Chart"), 'ColumnChart' => _("Column Chart"), 'Table' => _("Table"));
     $_POST['top'] = $this->top;
     $_POST['graph_type'] = $this->graph_type;
     $_POST['data_filter'] = $this->data_filter;
     text_row_ex(_("Number of weeks:"), 'top', 2);
     text_row_ex(_("Filter:"), 'data_filter', 50);
     select_row(_("Graph Type:"), "graph_type", null, $graph_types, null);
 }
Example #3
0
    end_row();
}
end_table(1);
start_table(TABLESTYLE2);
if ($selected_id != -1) {
    if ($Mode == 'Edit') {
        $result = fetchAuthors($selected_id);
        while ($myrow = db_fetch($result)) {
            $_POST['fname'] = $myrow['author_fname'];
            $_POST['mname'] = $myrow['author_mname'];
            $_POST['lname'] = $myrow['author_lname'];
            $_POST['bdate'] = sql2date($myrow["author_birthdate"]);
            $_POST['address'] = $myrow['author_address'];
            $_POST['contact_number'] = $myrow['author_contact_number'];
            $_POST['email_address'] = $myrow['author_email'];
            $_POST['selected_id'] = $myrow['id'];
        }
    }
    hidden('selected_id', $selected_id);
}
text_row_ex(_("First Name:"), 'fname', 25);
text_row_ex(_("Middle Name:"), 'mname', 25);
text_row_ex(_("Last Name:"), 'lname', 25);
date_row(_("Birth Date:"), 'bdate');
text_row_ex(_("Address:"), 'address', 25);
text_row_ex(_("Contact Number:"), 'contact_number', 25);
text_row_ex(_("Email Address:"), 'email_address', 25);
end_table(1);
submit_add_or_update_center($selected_id == -1, '', 'both');
end_form();
end_page();
Example #4
0
$th = array(_("ID"), _("Group Name"), "", "");
inactive_control_column($th);
table_header($th);
$k = 0;
while ($myrow = db_fetch($result)) {
    alt_table_row_color($k);
    label_cell($myrow["id"]);
    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(1);
//-------------------------------------------------------------------------------------------------
start_table(TABLESTYLE2);
if ($selected_id != -1) {
    if ($Mode == 'Edit') {
        //editing an existing group
        $myrow = get_sales_group($selected_id);
        $_POST['description'] = $myrow["description"];
    }
    hidden("selected_id", $selected_id);
    label_row(_("ID"), $myrow["id"]);
}
text_row_ex(_("Group Name:"), 'description', 30);
end_table(1);
submit_add_or_update_center($selected_id == -1, '', 'both');
end_form();
end_page();
Example #5
0
end_table();
//------------------------------------------------------------------------------------------------
hyperlink_no_params($_SERVER['PHP_SELF'], tr("New Sales Person"));
//------------------------------------------------------------------------------------------------
start_form();
if (isset($selected_id)) {
    //editing an existing Sales-person
    $sql = "SELECT *  FROM salesman WHERE salesman_code='{$selected_id}'";
    $result = db_query($sql, "could not get sales person");
    $myrow = db_fetch($result);
    $_POST['salesman_name'] = $myrow["salesman_name"];
    $_POST['salesman_phone'] = $myrow["salesman_phone"];
    $_POST['salesman_fax'] = $myrow["salesman_fax"];
    $_POST['salesman_email'] = $myrow["salesman_email"];
    $_POST['provision'] = percent_format($myrow["provision"]);
    $_POST['break_pt'] = price_format($myrow["break_pt"]);
    $_POST['provision2'] = percent_format($myrow["provision2"]);
    hidden('selected_id', $selected_id);
}
start_table("{$table_style2} width=60%");
text_row_ex(tr("Sales person name:"), 'salesman_name', 30);
text_row_ex(tr("Telephone number:"), 'salesman_phone', 20);
text_row_ex(tr("Fax number:"), 'salesman_fax', 20);
text_row_ex(tr("Email:"), 'salesman_email', 40);
percent_row(tr("Provision"), 'provision');
amount_row(tr("Break Pt.:"), 'break_pt');
percent_row(tr("Provision") . " 2", 'provision2');
end_table(1);
submit_add_or_update_center(!isset($selected_id));
end_form();
end_page();
inactive_control_row($th);
end_table(1);
//-----------------------------------------------------------------------------------
start_table(TABLESTYLE2);
if ($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:"), 'class_id', null);
end_table(1);
submit_add_or_update_center($selected_id == "", '', 'both');
end_form();
//------------------------------------------------------------------------------------
end_page();
Example #7
0
     break;
 case '5':
     if (!isset($_POST['name'])) {
         foreach ($_SESSION['inst_set'] as $name => $val) {
             $_POST[$name] = $val;
         }
         set_focus('name');
     }
     if (!isset($installed_extensions)) {
         $installed_extensions = array();
         update_extensions($installed_extensions);
     }
     subpage_title(_('Company Settings'));
     start_table(TABLESTYLE);
     text_row_ex(_("Company Name:"), 'name', 30);
     text_row_ex(_("Admin Login:"), 'admin', 30);
     password_row(_("Admin Password:"), 'pass', @$_POST['pass']);
     password_row(_("Reenter Password:"), 'repass', @$_POST['repass']);
     coa_list_row(_("Select Chart of Accounts:"), 'coa');
     languages_list_row(_("Select Default Language:"), 'lang');
     end_table(1);
     submit_center_first('back', _('<< Back'));
     submit_center_last('set_admin', _('Continue >>'));
     break;
 case '6':
     // final screen
     subpage_title(_('SerbizHub Suite ERP has been installed successsfully.'));
     display_note(_('Please do not forget to remove install wizard folder.'));
     session_unset();
     session_destroy();
     hyperlink_no_params($path_to_root . '/index.php', _('Click here to start.'));
    label_cell($myrow["address"]);
    inactive_control_cell($myrow["shipper_id"], $myrow["inactive"], 'shippers', 'shipper_id');
    edit_button_cell("Edit" . $myrow["shipper_id"], _("Edit"));
    delete_button_cell("Delete" . $myrow["shipper_id"], _("Delete"));
    end_row();
}
inactive_control_row($th);
end_table(1);
//----------------------------------------------------------------------------------------------
start_table(TABLESTYLE2);
if ($selected_id != -1) {
    if ($Mode == 'Edit') {
        //editing an existing Shipper
        $myrow = get_shipper($selected_id);
        $_POST['shipper_name'] = $myrow["shipper_name"];
        $_POST['contact'] = $myrow["contact"];
        $_POST['phone'] = $myrow["phone"];
        $_POST['phone2'] = $myrow["phone2"];
        $_POST['address'] = $myrow["address"];
    }
    hidden('selected_id', $selected_id);
}
text_row_ex(_("Name:"), 'shipper_name', 40);
text_row_ex(_("Contact Person:"), 'contact', 30);
text_row_ex(_("Phone Number:"), 'phone', 32, 30);
text_row_ex(_("Secondary Phone Number:"), 'phone2', 32, 30);
text_row_ex(_("Address:"), 'address', 50);
end_table(1);
submit_add_or_update_center($selected_id == -1, '', 'both');
end_form();
end_page();
Example #9
0
 function edit_param()
 {
     $_POST['data_filter'] = $this->data_filter;
     text_row_ex(_("Filter:"), 'data_filter', 50);
 }
Example #10
0
    //editing an existing status code
    if (!isset($_POST['name'])) {
        $group = get_tax_group($selected_id);
        $_POST['name'] = $group["name"];
        $_POST['tax_shipping'] = $group["tax_shipping"];
        $items = get_tax_group_items($selected_id);
        $i = 0;
        while ($tax_item = db_fetch($items)) {
            $_POST['tax_type_id' . $i] = $tax_item["tax_type_id"];
            $_POST['rate' . $i] = percent_format($tax_item["rate"]);
            $i++;
        }
    }
    hidden('selected_id', $selected_id);
}
text_row_ex(tr("Description:"), 'name', 40);
yesno_list_row(tr("Tax Shipping:"), 'tax_shipping', null, "", "", true);
end_table();
display_note(tr("Select the taxes that are included in this group."), 1);
start_table($table_style2);
$th = array(tr("Tax"), tr("Default Rate (%)"), tr("Rate (%)"));
table_header($th);
for ($i = 0; $i < 5; $i++) {
    start_row();
    if (!isset($_POST['tax_type_id' . $i])) {
        $_POST['tax_type_id' . $i] = 0;
    }
    tax_types_list_cells(null, 'tax_type_id' . $i, $_POST['tax_type_id' . $i], true, tr("None"), true);
    if ($_POST['tax_type_id' . $i] != 0 && $_POST['tax_type_id' . $i] != reserved_words::get_all_numeric()) {
        $default_rate = get_tax_type_default_rate($_POST['tax_type_id' . $i]);
        label_cell(percent_format($default_rate), "nowrap align=right");
    }
    hidden('selected_id', $selected_id);
}
text_row_ex(_("Description") . ':', 'description', 50, 60);
quick_entry_types_list_row(_("Entry Type") . ':', 'type', null, true);
if (get_post('type') == QE_JOURNAL) {
    yesno_list_row(_("Balance Based"), 'bal_type', null, _("Yes"), _("No"), true);
}
if (list_updated('bal_type') || list_updated('type')) {
    $Ajax->activate('qe');
}
if (get_post('type') == QE_JOURNAL && get_post('bal_type') == 1) {
    yesno_list_row(_("Period"), 'base_amount', null, _("Monthly"), _("Yearly"));
    gl_all_accounts_list_row(_("Account"), 'base_desc', null, true);
} else {
    text_row_ex(_("Base Amount Description") . ':', 'base_desc', 50, 60, '');
    amount_row(_("Default Base Amount") . ':', 'base_amount', price_format(0));
}
end_table(1);
submit_add_or_update_center($selected_id == -1, '', 'both');
div_end();
if ($selected_id != -1) {
    display_heading(_("Quick Entry Lines") . " - " . $_POST['description']);
    $result = get_quick_entry_lines($selected_id);
    start_table(TABLESTYLE2);
    $dim = get_company_pref('use_dimension');
    if ($dim == 2) {
        $th = array(_("Post"), _("Account/Tax Type"), _("Amount"), _("Dimension"), _("Dimension") . " 2", "", "");
    } elseif ($dim == 1) {
        $th = array(_("Post"), _("Account/Tax Type"), _("Amount"), _("Dimension"), "", "");
    } else {
 function edit_param()
 {
     global $top;
     $item_types = array('stock' => _("Stock"), 'manuf' => _("Manufactured"));
     $graph_types = array('PieChart' => _("Pie Chart"), 'Table' => _("Table"));
     $_POST['top'] = $this->top;
     $_POST['item_type'] = $this->item_type;
     $_POST['graph_type'] = $this->graph_type;
     $_POST['data_filter'] = $this->data_filter;
     text_row_ex(_("Number of items:"), 'top', 2);
     text_row_ex(_("Filter:"), 'data_filter', 50);
     select_row(_("Graph Type"), "graph_type", null, $graph_types, null);
     select_row(_("Item Type"), "item_type", null, $item_types, null);
 }
Example #13
0
    }
    label_cell($myrow["cid"]);
    label_cell($myrow['class_name']);
    label_cell($bs_text);
    edit_link_cell("selected_id=" . $myrow["cid"]);
    delete_link_cell("selected_id=" . $myrow["cid"] . "&delete=1");
    end_row();
}
end_table();
//-----------------------------------------------------------------------------------
hyperlink_no_params($_SERVER['PHP_SELF'], tr("New Account Class"));
start_form();
start_table($table_style2);
if ($selected_id != -1) {
    //editing an existing status code
    $myrow = get_account_class($selected_id);
    $_POST['id'] = $myrow["cid"];
    $_POST['name'] = $myrow["class_name"];
    $_POST['Balance'] = $myrow["balance_sheet"];
    hidden('selected_id', $selected_id);
    label_row(tr("Class ID:"), $_POST['id']);
} else {
    text_row_ex(tr("Class ID:"), 'id', 3);
}
text_row_ex(tr("Class Name:"), 'name', 50);
yesno_list_row(tr("Balance Sheet:"), 'Balance', null, "", "", false);
end_table(1);
submit_add_or_update_center($selected_id == -1);
end_form();
//------------------------------------------------------------------------------------
end_page();
Example #14
0
hyperlink_no_params($_SERVER['PHP_SELF'], tr("New Location"));
start_form();
start_table($table_style2);
if (isset($selected_id)) {
    //editing an existing Location
    $myrow = get_item_location($selected_id);
    $_POST['loc_code'] = $myrow["loc_code"];
    $_POST['location_name'] = $myrow["location_name"];
    $_POST['delivery_address'] = $myrow["delivery_address"];
    $_POST['contact'] = $myrow["contact"];
    $_POST['phone'] = $myrow["phone"];
    $_POST['fax'] = $myrow["fax"];
    $_POST['email'] = $myrow["email"];
    hidden("selected_id", $selected_id);
    hidden("loc_code", $_POST['loc_code']);
    label_row(tr("Location Code:"), $_POST['loc_code']);
} else {
    //end of if $selected_id only do the else when a new record is being entered
    text_row(tr("Location Code:"), 'loc_code', null, 5, 5);
}
text_row_ex(tr("Location Name:"), 'location_name', 50, 50);
text_row_ex(tr("Contact for deliveries:"), 'contact', 30, 30);
textarea_row(tr("Address:"), 'delivery_address', null, 35, 5);
text_row_ex(tr("Telephone No:"), 'phone', 30, 30);
text_row_ex(tr("Facsimile No:"), 'fax', 30, 30);
text_row_ex(tr("Email:"), 'email', 30, 30);
end_table(1);
submit_add_or_update_center(!isset($selected_id));
end_form();
//end if record deleted no point displaying form to add record
end_page();
Example #15
0
possible separators can be added by modifying the array definition by editing that file */
if (!isset($_POST['language'])) {
    $_POST['language'] = $_SESSION['language']->code;
}
table_section_title(_("Language"));
languages_list_row(_("Language:"), 'language', $_POST['language']);
table_section(2);
table_section_title(_("Miscellaneous"));
check_row(_("Show hints for new users:"), 'show_hints', user_hints());
check_row(_("Show GL Information:"), 'show_gl', user_show_gl_info());
check_row(_("Show Item Codes:"), 'show_codes', user_show_codes());
themes_list_row(_("Theme:"), "theme", user_theme());
/* The array $themes is set up in config.php for modifications
possible separators can be added by modifying the array definition by editing that file */
pagesizes_list_row(_("Page Size:"), "page_size", user_pagesize());
tab_list_row(_("Start-up Tab"), 'startup_tab', user_startup_tab());
/* The array $pagesizes is set up in config.php for modifications
possible separators can be added by modifying the array definition by editing that file */
if (!isset($_POST['print_profile'])) {
    $_POST['print_profile'] = user_print_profile();
}
print_profiles_list_row(_("Printing profile") . ':', 'print_profile', null, _('Browser printing support'));
check_row(_("Use popup window to display reports:"), 'rep_popup', user_rep_popup(), false, _('Set this option to on if your browser directly supports pdf files'));
check_row(_("Use icons instead of text links:"), 'graphic_links', user_graphic_links(), false, _('Set this option to on for using icons instead of text links'));
text_row_ex(_("Query page size:"), 'query_size', 5, 5, '', user_query_size());
check_row(_("Remember last document date:"), 'sticky_doc_date', sticky_doc_date(), false, _('If set document date is remembered on subsequent documents, otherwise default is current date'));
end_outer_table(1);
submit_center('setprefs', _("Update"), true, '', 'default');
end_form(2);
//-------------------------------------------------------------------------------------------------
end_page();
Example #16
0
function display_module_edit($selected_id)
{
    global $installed_modules, $table_style2;
    if ($selected_id != -1) {
        $n = $selected_id;
    } else {
        $n = count($installed_modules);
    }
    start_form(true, true);
    echo "\n\t\t<script language='javascript'>\n\t\tfunction updateModule() {\n\t\t\tdocument.forms[0].action='inst_module.php?c=u&id=" . $n . "'\n\t\t\tdocument.forms[0].submit()\n\t\t}\n\t\t</script>";
    start_table($table_style2);
    if ($selected_id != -1) {
        $mod = $installed_modules[$selected_id];
        $_POST['tab'] = $mod['tab'];
        $_POST['name'] = $mod['name'];
        $_POST['path'] = $mod['path'];
        $_POST['filename'] = $mod['filename'];
        hidden('selected_id', $selected_id);
        hidden('filename', $_POST['filename']);
    }
    tab_list_row(tr("Menu Tab"), 'tab', null);
    text_row_ex(tr("Name"), 'name', 30);
    text_row_ex(tr("Folder"), 'path', 20);
    label_row(tr("Module File"), "<input name='uploadfile' type='file'>");
    label_row(tr("SQL File"), "<input name='uploadfile2' type='file'>");
    end_table(0);
    display_note(tr("Select your module PHP file from your local harddisk."), 0, 1);
    echo "<center><input onclick='javascript:updateModule()' type='button' style='width:150' value='" . tr("Save") . "'>";
    end_form();
}
Example #17
0
//END WHILE LIST LOOP
end_table();
hyperlink_no_params($_SERVER['PHP_SELF'], tr("New Payment Term"));
//-------------------------------------------------------------------------------------------------
start_form();
start_table($table_style2);
$day_in_following_month = $days_before_due = 0;
if (isset($selected_id)) {
    //editing an existing payment terms
    $sql = "SELECT * FROM payment_terms\n\t\tWHERE terms_indicator='{$selected_id}'";
    $result = db_query($sql, "could not get payment term");
    $myrow = db_fetch($result);
    $_POST['terms'] = $myrow["terms"];
    $days_before_due = $myrow["days_before_due"];
    $day_in_following_month = $myrow["day_in_following_month"];
    hidden('selected_id', $selected_id);
}
text_row(tr("Terms Description:"), 'terms', null, 40, 40);
check_row(tr("Due After A Given No. Of Days:"), 'DaysOrFoll', $day_in_following_month == 0);
if (!isset($_POST['DayNumber'])) {
    if ($days_before_due != 0) {
        $_POST['DayNumber'] = $days_before_due;
    } else {
        $_POST['DayNumber'] = $day_in_following_month;
    }
}
text_row_ex(tr("Days (Or Day In Following Month):"), 'DayNumber', 3);
end_table(1);
submit_add_or_update_center(!isset($selected_id));
end_form();
end_page();
Example #18
0
function display_company_edit($selected_id)
{
    global $def_coy, $db_connections, $tb_pref_counter, $table_style2;
    if ($selected_id != -1) {
        $n = $selected_id;
    } else {
        $n = count($db_connections);
    }
    start_form(true, true);
    echo "\n\t\t<script language='javascript'>\n\t\tfunction updateCompany() {\n\t\t\tif (document.forms[0].uploadfile.value!='' && document.forms[0].dbname.value!='') {\n\t\t\t\tdocument.forms[0].action='create_coy.php?c=u&ul=1&id=" . $n . "&fn=' + document.forms[0].uploadfile.value\n\t\t\t}\n\t\t\telse {\n\t\t\t\tdocument.forms[0].action='create_coy.php?c=u&id=" . $n . "&fn=' + document.forms[0].uploadfile.value\n\t\t\t}\n\t\t\tdocument.forms[0].submit()\n\t\t}\n\t\t</script>";
    start_table($table_style2);
    if ($selected_id != -1) {
        $conn = $db_connections[$selected_id];
        $_POST['name'] = $conn['name'];
        $_POST['host'] = $conn['host'];
        $_POST['dbuser'] = $conn['dbuser'];
        $_POST['dbpassword'] = $conn['dbpassword'];
        $_POST['dbname'] = $conn['dbname'];
        if ($selected_id == $def_coy) {
            $_POST['def'] = true;
        } else {
            $_POST['def'] = false;
        }
        $_POST['dbcreate'] = false;
        hidden('selected_id', $selected_id);
        hidden('dbpassword', $_POST['dbpassword']);
    } else {
        text_row_ex(tr("Company"), 'name', 30);
    }
    text_row_ex(tr("Host"), 'host', 30);
    text_row_ex(tr("Database User"), 'dbuser', 30);
    if ($selected_id == -1) {
        text_row_ex(tr("Database Password"), 'dbpassword', 30);
    }
    text_row_ex(tr("Database Name"), 'dbname', 30);
    yesno_list_row(tr("Default"), 'def', null, "", "", false);
    start_row();
    label_cell(tr("Database Script"));
    label_cell("<input name='uploadfile' type='file'>");
    end_row();
    text_row_ex(tr("New script Admin Password"), 'admpassword', 20);
    end_table();
    display_note(tr("Choose from Database scripts in SQL folder. No Datase is created without a script."), 0, 1);
    echo "<center><input onclick='javascript:updateCompany()' type='button' style='width:150' value='" . tr("Save") . "'>";
    end_form();
}
Example #19
0
    } else {
        $disallow_text = "<b>" . _("NO INVOICING") . "</b>";
    }
    label_cell($myrow["reason_description"]);
    label_cell($disallow_text);
    inactive_control_cell($myrow["id"], $myrow["inactive"], 'credit_status', 'id');
    edit_button_cell("Edit" . $myrow['id'], _("Edit"));
    delete_button_cell("Delete" . $myrow['id'], _("Delete"));
    end_row();
}
inactive_control_row($th);
end_table();
echo '<br>';
//-----------------------------------------------------------------------------------
start_table(TABLESTYLE2);
if ($selected_id != -1) {
    if ($Mode == 'Edit') {
        //editing an existing status code
        $myrow = get_credit_status($selected_id);
        $_POST['reason_description'] = $myrow["reason_description"];
        $_POST['DisallowInvoices'] = $myrow["dissallow_invoices"];
    }
    hidden('selected_id', $selected_id);
}
text_row_ex(_("Description:"), 'reason_description', 50);
yesno_list_row(_("Dissallow invoicing ?"), 'DisallowInvoices', null);
end_table(1);
submit_add_or_update_center($selected_id == -1, '', 'both');
end_form();
//------------------------------------------------------------------------------------
end_page();
//-----------------------------------------------------------------------------------
start_table(TABLESTYLE2);
if ($selected_id != "") {
    if ($Mode == 'Edit') {
        //editing an existing status code
        $myrow = get_account_class($selected_id);
        $_POST['id'] = $myrow["cid"];
        $_POST['name'] = $myrow["class_name"];
        if (isset($use_oldstyle_convert) && $use_oldstyle_convert == 1) {
            $_POST['ctype'] = $myrow["ctype"] >= CL_ASSETS && $myrow["ctype"] < CL_INCOME ? 1 : 0;
        } else {
            $_POST['ctype'] = $myrow["ctype"];
        }
        hidden('selected_id', $selected_id);
    }
    hidden('id');
    label_row(_("Class ID:"), $_POST['id']);
} else {
    text_row_ex(_("Class ID:"), 'id', 3);
}
text_row_ex(_("Class Name:"), 'name', 50, 60);
if (isset($use_oldstyle_convert) && $use_oldstyle_convert == 1) {
    check_row(_("Balance Sheet"), 'ctype', null);
} else {
    class_types_list_row(_("Class Type:"), 'ctype', null);
}
end_table(1);
submit_add_or_update_center($selected_id == "", '', 'both');
end_form();
//------------------------------------------------------------------------------------
end_page();
function display_company_edit($selected_id)
{
    global $def_coy, $db_connections, $tb_pref_counter;
    start_form();
    start_table(TABLESTYLE2);
    if ($selected_id != -1) {
        $conn = $db_connections[$selected_id];
        $_POST['name'] = $conn['name'];
        $_POST['host'] = $conn['host'];
        $_POST['dbuser'] = $conn['dbuser'];
        $_POST['dbpassword'] = $conn['dbpassword'];
        $_POST['dbname'] = $conn['dbname'];
        $_POST['tbpref'] = $conn['tbpref'];
        if ($selected_id == $def_coy) {
            $_POST['def'] = true;
        } else {
            $_POST['def'] = false;
        }
        $_POST['dbcreate'] = false;
        hidden('selected_id', $selected_id);
        hidden('tbpref', $_POST['tbpref']);
        hidden('dbpassword', $_POST['dbpassword']);
    } else {
        $_POST['tbpref'] = $tb_pref_counter . "_";
        // Insert the current settings as default
        $conn = $db_connections[user_company()];
        $_POST['name'] = '';
        $_POST['host'] = $conn['host'];
        $_POST['dbuser'] = $conn['dbuser'];
        $_POST['dbpassword'] = $conn['dbpassword'];
        $_POST['dbname'] = $conn['dbname'];
    }
    text_row_ex(_("Company"), 'name', 50);
    if ($selected_id == -1) {
        text_row_ex(_("Host"), 'host', 30, 60);
        text_row_ex(_("Database User"), 'dbuser', 30);
        text_row_ex(_("Database Password"), 'dbpassword', 30);
        text_row_ex(_("Database Name"), 'dbname', 30);
        yesno_list_row(_("Table Pref"), 'tbpref', 1, $_POST['tbpref'], _("None"), false);
    } else {
        label_row(_("Host"), $_POST['host']);
        label_row(_("Database User"), $_POST['dbuser']);
        label_row(_("Database Name"), $_POST['dbname']);
        label_row(_("Table Pref"), $_POST['tbpref']);
    }
    yesno_list_row(_("Default"), 'def', null, "", "", false);
    if ($selected_id == -1) {
        coa_list_row(_("Database Script"), 'coa');
        text_row_ex(_("New script Admin Password"), 'admpassword', 20);
    }
    end_table(1);
    submit_center('save', _("Save"));
    end_form();
}
Example #22
0
function display_currency_edit($selected_id)
{
    global $Mode;
    start_table(TABLESTYLE2);
    if ($selected_id != '') {
        if ($Mode == 'Edit') {
            //editing an existing currency
            $myrow = get_currency($selected_id);
            $_POST['Abbreviation'] = $myrow["curr_abrev"];
            $_POST['Symbol'] = $myrow["curr_symbol"];
            $_POST['CurrencyName'] = $myrow["currency"];
            $_POST['country'] = $myrow["country"];
            $_POST['hundreds_name'] = $myrow["hundreds_name"];
            $_POST['auto_update'] = $myrow["auto_update"];
        }
        hidden('Abbreviation');
        hidden('selected_id', $selected_id);
        label_row(_("Currency Abbreviation:"), $_POST['Abbreviation']);
    } else {
        $_POST['auto_update'] = 1;
        text_row_ex(_("Currency Abbreviation:"), 'Abbreviation', 4, 3);
    }
    text_row_ex(_("Currency Symbol:"), 'Symbol', 10);
    text_row_ex(_("Currency Name:"), 'CurrencyName', 20);
    text_row_ex(_("Hundredths Name:"), 'hundreds_name', 15);
    text_row_ex(_("Country:"), 'country', 40);
    check_row(_("Automatic exchange rate update:"), 'auto_update', get_post('auto_update'));
    end_table(1);
    submit_add_or_update_center($selected_id == '', '', 'both');
}
    end_row();
}
inactive_control_row($th);
end_table(1);
//-------------------------------------------------------------------------------------------------
start_table(TABLESTYLE2);
if ($selected_id != -1) {
    if ($Mode == 'Edit') {
        //editing an existing area
        $myrow = get_crm_category($selected_id);
        $_POST['name'] = $myrow["name"];
        $_POST['type'] = $myrow["type"];
        $_POST['subtype'] = $myrow["action"];
        $_POST['description'] = $myrow["description"];
    }
    hidden("selected_id", $selected_id);
}
if ($Mode == 'Edit' && $myrow['system']) {
    label_row(_("Contact Category Type:"), $_POST['type']);
    label_row(_("Contact Category Subtype:"), $_POST['subtype']);
} else {
    //	crm_category_type_list_row(_("Contact Category Type:"), 'type', null, _('Other'));
    text_row_ex(_("Contact Category Type:"), 'type', 30);
    text_row_ex(_("Contact Category Subtype:"), 'subtype', 30);
}
text_row_ex(_("Category Short Name:"), 'name', 30);
textarea_row(_("Category Description:"), 'description', null, 60, 4);
end_table(1);
submit_add_or_update_center($selected_id == -1, '', 'both');
end_form();
end_page();
 function edit_param()
 {
     global $top;
     $graph_types = array('ColumnChart' => _("Column Chart"), 'Table' => _("Table"));
     $_POST['top'] = $this->top;
     $_POST['data_filter'] = $this->data_filter;
     text_row_ex(_("Number of Suppliers:"), 'top', 2);
     text_row_ex(_("Filter:"), 'data_filter', 50);
     select_row(_("Graph Type:"), "graph_type", null, $graph_types, null);
 }
    if ($Mode == 'Edit') {
        //editing an existing area
        $myrow = get_recurrent_invoice($selected_id);
        $_POST['description'] = $myrow["description"];
        $_POST['order_no'] = $myrow["order_no"];
        $_POST['debtor_no'] = $myrow["debtor_no"];
        $_POST['group_no'] = $myrow["group_no"];
        $_POST['days'] = $myrow["days"];
        $_POST['monthly'] = $myrow["monthly"];
        $_POST['begin'] = sql2date($myrow["begin"]);
        $_POST['end'] = sql2date($myrow["end"]);
        $_POST['last_sent'] = $myrow['last_sent'] == "0000-00-00" ? "" : sql2date($myrow["last_sent"]);
    }
    hidden("selected_id", $selected_id);
}
text_row_ex(_("Description:"), 'description', 50);
templates_list_row(_("Template:"), 'order_no');
customer_list_row(_("Customer:"), 'debtor_no', null, " ", true);
if ($_POST['debtor_no'] > 0) {
    customer_branches_list_row(_("Branch:"), $_POST['debtor_no'], 'group_no', null, false);
} else {
    sales_groups_list_row(_("Sales Group:"), 'group_no', null, " ");
}
small_amount_row(_("Days:"), 'days', 0, null, null, 0);
small_amount_row(_("Monthly:"), 'monthly', 0, null, null, 0);
date_row(_("Begin:"), 'begin');
date_row(_("End:"), 'end', null, null, 0, 0, 5);
if ($selected_id != -1 && $_POST['last_sent'] != "") {
    date_row(_("Last Created"), 'last_sent');
}
end_table(1);
Example #26
0
if ($selected_id != -1) {
    //editing an existing Location
    if ($Mode == 'Edit') {
        $myrow = get_item_location($selected_id);
        $_POST['loc_code'] = $myrow["loc_code"];
        $_POST['location_name'] = $myrow["location_name"];
        $_POST['delivery_address'] = $myrow["delivery_address"];
        $_POST['contact'] = $myrow["contact"];
        $_POST['phone'] = $myrow["phone"];
        $_POST['phone2'] = $myrow["phone2"];
        $_POST['fax'] = $myrow["fax"];
        $_POST['email'] = $myrow["email"];
    }
    hidden("selected_id", $selected_id);
    hidden("loc_code");
    label_row(_("Location Code:"), $_POST['loc_code']);
} else {
    //end of if $selected_id only do the else when a new record is being entered
    text_row(_("Location Code:"), 'loc_code', null, 5, 5);
}
text_row_ex(_("Location Name:"), 'location_name', 50, 50);
text_row_ex(_("Contact for deliveries:"), 'contact', 30, 30);
textarea_row(_("Address:"), 'delivery_address', null, 35, 5);
text_row_ex(_("Telephone No:"), 'phone', 32, 30);
text_row_ex(_("Secondary Phone Number:"), 'phone2', 32, 30);
text_row_ex(_("Facsimile No:"), 'fax', 32, 30);
email_row_ex(_("E-mail:"), 'email', 30);
end_table(1);
submit_add_or_update_center($selected_id == -1, '', 'both');
end_form();
end_page();
Example #27
0
            foreach ($db_connections as $id => $conn) {
                $conn['dbuser'] = $_POST['user'];
                $conn['dbpassword'] = $_POST['passwd'];
                if (!($db = db_open($conn))) {
                    display_error("Wrong user name or password - " . mysql_error());
                } else {
                    if (!db_import($_FILES['uploadfile']['tmp_name'], $conn)) {
                        display_error("Bad SQL file or you have already updated the company: " . $id . " " . $conn['name'] . " - " . mysql_error());
                    } else {
                        display_notification("Database has been updated for company: " . $id . " " . $conn['name']);
                    }
                }
            }
        }
    }
}
if (!isset($_POST['passwd'])) {
    $_POST['passwd'] = "";
}
echo "<form enctype='multipart/form-data' method='post' action='" . $_SERVER['PHP_SELF'] . "'>\n";
echo "<table align='center' width='50%' cellpadding=3 border=1 bordercolor='#cccccc' style='border-collapse: collapse'>\n";
text_row_ex("Database User", "user", 20);
label_row("Password", "<input name='passwd' type='password' value='" . $_POST['passwd'] . "' />");
label_row("Upload Script", "<input name='uploadfile' type='file'>");
submit_row("submit", "Update");
echo "</table>\n";
echo "<br><br>";
echo "<center><span>Choose from Database update scripts in SQL folder. No Datase is updated without a script.</span></center>\n";
echo "<br>";
echo "</form>\n";
echo "</body></html>\n";
Example #28
0
        $_POST['pos'] = $myrow["pos"];
    }
    hidden('selected_id', $selected_id);
    hidden('user_id');
    start_row();
    label_row(_("User login:"), $_POST['user_id']);
} else {
    //end of if $selected_id only do the else when a new record is being entered
    text_row(_("User Login:"), "user_id", null, 22, 20);
    $_POST['language'] = user_language();
    $_POST['print_profile'] = user_print_profile();
    $_POST['rep_popup'] = user_rep_popup();
    $_POST['pos'] = user_pos();
}
$_POST['password'] = "";
password_row(_("Password:"), 'password', $_POST['password']);
if ($selected_id != -1) {
    table_section_title(_("Enter a new password to change, leave empty to keep current."));
}
text_row_ex(_("Full Name") . ":", 'real_name', 50);
text_row_ex(_("Telephone No.:"), 'phone', 30);
email_row_ex(_("Email Address:"), 'email', 50);
security_roles_list_row(_("Access Level:"), 'role_id', null);
languages_list_row(_("Language:"), 'language', null);
pos_list_row(_("User's POS") . ':', 'pos', null);
print_profiles_list_row(_("Printing profile") . ':', 'print_profile', null, _('Browser printing support'));
check_row(_("Use popup window for reports:"), 'rep_popup', $_POST['rep_popup'], false, _('Set this option to on if your browser directly supports pdf files'));
end_table(1);
submit_add_or_update_center($selected_id == -1, '', 'both');
end_form();
end_page();
 function edit_param()
 {
     $_POST['data_filter'] = $this->data_filter;
     $_POST['days_past'] = $this->days_past;
     $_POST['days_future'] = $this->days_future;
     $_POST['bank_act'] = $this->bank_act;
     text_row_ex(_("Days in past:"), 'days_past', 2);
     text_row_ex(_("Days in future:"), 'days_future', 2);
     bank_accounts_list_cells(_("Account:"), 'bank_act', null);
     text_row_ex(_("Filter:"), 'data_filter', 50);
 }
email_row_ex(_("BCC Address for all outgoing mails:"), 'bcc_email', 25, 55);
text_row_ex(_("Official Company Number:"), 'coy_no', 25);
text_row_ex(_("GSTNo:"), 'gst_no', 25);
currencies_list_row(_("Home Currency:"), 'curr_default', $_POST['curr_default']);
fiscalyears_list_row(_("Fiscal Year:"), 'f_year', $_POST['f_year']);
text_row_ex(_("Tax Periods:"), 'tax_prd', 10, 10, '', null, null, _('Months.'));
text_row_ex(_("Tax Last Period:"), 'tax_last', 10, 10, '', null, null, _('Months back.'));
table_section(2);
label_row(_("Company Logo:"), $_POST['coy_logo']);
file_row(_("New Company Logo (.jpg)") . ":", 'pic', 'pic');
check_row(_("Delete Company Logo:"), 'del_coy_logo', $_POST['del_coy_logo']);
number_list_row(_("Use Dimensions:"), 'use_dimension', null, 0, 2);
sales_types_list_row(_("Base for auto price calculations:"), 'base_sales', $_POST['base_sales'], false, _('No base price list'));
text_row_ex(_("Add Price from Std Cost:"), 'add_pct', 10, 10, '', null, null, "%");
$curr = get_currency($_POST['curr_default']);
text_row_ex(_("Round to nearest:"), 'round_to', 10, 10, '', null, null, $curr['hundreds_name']);
label_row("", "&nbsp;");
check_row(_("Search Item List"), 'no_item_list', null);
check_row(_("Search Customer List"), 'no_customer_list', null);
check_row(_("Search Supplier List"), 'no_supplier_list', null);
label_row("", "&nbsp;");
check_row(_("Automatic Revaluation Currency Accounts"), 'auto_curr_reval', $_POST['auto_curr_reval']);
check_row(_("Time Zone on Reports"), 'time_zone', $_POST['time_zone']);
text_row_ex(_("Login Timeout:"), 'login_tout', 10, 10, '', null, null, _('seconds'));
label_row(_("Version Id"), $_POST['version_id']);
end_outer_table(1);
hidden('coy_logo', $_POST['coy_logo']);
submit_center('update', _("Update"), true, '', 'default');
end_form(2);
//-------------------------------------------------------------------------------------------------
end_page();