case 'go_previous': $_GET['page']--; break; case 'go_next': $_GET['page']++; break; case 'go_last': $_GET['page'] = 99999; break; case 'search': case 'search_reset': case 'go_page': break; default: // check to see if the field list is sync'd with the field properties, on first entry inv_sync_inv_field_list(); } /***************** prepare to display templates *************************/ // prepare category drop-down $category_array = inv_get_field_categories(); $include_header = true; $include_footer = true; $include_tabs = false; $include_calendar = false; switch ($action) { case 'edit': case 'update': case 'new': $include_template = 'template_detail.php'; // include display template (required) define('PAGE_TITLE', INV_FIELD_HEADING_TITLE);
case 'go_previous': $_GET['page']--; break; case 'go_next': $_GET['page']++; break; case 'go_last': $_GET['page'] = 99999; break; case 'search': case 'search_reset': case 'go_page': break; default: // check to see if the field list is sync'd with the field properties, on first entry inv_sync_inv_field_list(TABLE_ASSETS, TABLE_ASSETS_FIELDS); } /***************** prepare to display templates *************************/ // prepare category drop-down $category_array = inv_get_field_categories(TABLE_ASSETS_TABS); $include_header = true; // include header flag $include_footer = true; // include footer flag $include_tabs = false; $include_calendar = false; switch ($action) { case 'edit': case 'update': case 'new': $include_template = 'template_detail.php';
function load_startup_table_data($language = 'en_us') { global $db; // set current status to intial levels $db->Execute("INSERT INTO " . TABLE_CURRENT_STATUS . " VALUES (1, 5000, '10000', 20000, 100, '1', 1, 'CM1000', 'VCM1000', 'RFQ1000', 'QU1000', 'C10000', 'V10000')"); // set the project db version require_once DIR_FS_INCLUDES . 'version.php'; $db->Execute("INSERT INTO " . TABLE_PROJECT_VERSION . " VALUES (1, 'PhreeBooks Database', '" . PROJECT_VERSION_MAJOR . "', '" . PROJECT_VERSION_MINOR . "', 'Fresh Installation', '" . date('Y-m-d H:i:s', time()) . "');"); // load the configuration values (config_data.php) require_once DIR_FS_MODULES . 'install/language/' . $language . '/config_data.php'; require_once DIR_FS_MODULES . 'install/includes/config_data.php'; foreach ($config_data as $entry) { db_perform(TABLE_CONFIGURATION, $entry, 'insert'); } // TBD - set the accounting period and period start and end dates // load the chart_of_accounts_types_list require_once DIR_FS_MODULES . 'install/language/' . $language . '/chart_of_accounts_types_list.php'; foreach ($chart_of_accounts_types_list as $entry) { db_perform(TABLE_CHART_OF_ACCOUNTS_TYPES, $entry, 'insert'); } // load the countries_list require_once DIR_FS_MODULES . 'install/language/' . $language . '/countries_list.php'; foreach ($countries_list as $entry) { db_perform(TABLE_COUNTRIES, $entry, 'insert'); } // load the currencies_list require_once DIR_FS_MODULES . 'install/language/' . $language . '/currencies_list.php'; foreach ($currencies_list as $entry) { db_perform(TABLE_CURRENCIES, $entry, 'insert'); } // load the import_export_list require_once DIR_FS_MODULES . 'install/language/' . $language . '/import_export_list.php'; foreach ($import_export_list as $entry) { db_perform(TABLE_IMPORT_EXPORT, $entry, 'insert'); } // load the state_province_list require_once DIR_FS_MODULES . 'install/language/' . $language . '/state_province_list.php'; foreach ($state_province_list as $entry) { db_perform(TABLE_ZONES, $entry, 'insert'); } // load the reports and forms (import from my_files); require_once DIR_FS_MODULES . 'reportwriter/functions/builder_functions.php'; require_once DIR_FS_MODULES . 'reportwriter/language/' . $language . '/language.php'; require_once DIR_FS_MODULES . 'install/report_list.php'; define('DIR_FS_REPORTS', '../../my_files/reports/'); foreach ($report_list as $report) { $_POST['RptFileName'] = $report; // to fake out the import function to load report from my_files if (file_exists(DIR_FS_REPORTS . $report)) { ImportReport($RptName = ''); } } // synchronize the inventory fields before any customization is done to them require DIR_FS_MODULES . 'inventory/functions/inventory.php'; inv_sync_inv_field_list(); return true; }