$sql_data_array['account_maintenance'] = best_acct_guess(34, TEXT_FURNITURE, ''); break; case 'pc': $sql_data_array['account_asset'] = best_acct_guess(8, TEXT_COMPUTER, ''); $sql_data_array['account_depreciation'] = best_acct_guess(10, TEXT_COMPUTER, ''); $sql_data_array['account_maintenance'] = best_acct_guess(34, TEXT_COMPUTER, ''); break; case 'ld': $sql_data_array['account_asset'] = best_acct_guess(8, TEXT_LAND, ''); $sql_data_array['account_depreciation'] = best_acct_guess(10, TEXT_LAND, ''); $sql_data_array['account_maintenance'] = best_acct_guess(34, TEXT_LAND, ''); break; case 'sw': $sql_data_array['account_asset'] = best_acct_guess(8, TEXT_SOFTWARE, ''); $sql_data_array['account_depreciation'] = best_acct_guess(10, TEXT_SOFTWARE, ''); $sql_data_array['account_maintenance'] = best_acct_guess(34, TEXT_SOFTWARE, ''); break; } db_perform(TABLE_ASSETS, $sql_data_array, 'insert'); $id = db_insert_id(); gen_add_audit_log(AESSETS_LOG_ASSETS . TEXT_ADD, 'Type: ' . $asset_type . ' - ' . $asset_id); gen_redirect(html_href_link(FILENAME_DEFAULT, gen_get_all_get_params(array('cID', 'action', 'page')) . 'cID=' . $id . '&action=edit', 'SSL')); break; case 'delete': if ($security_level < 4) { $messageStack->add_session(ERROR_NO_PERMISSION, 'error'); gen_redirect(html_href_link(FILENAME_DEFAULT, gen_get_all_get_params(array('action')), 'SSL')); break; } $id = db_prepare_input($_GET['cID']); $result = $db->Execute("select asset_id, asset_type from " . TABLE_ASSETS . " where id = " . $id);
function smart_acct_list($id, $keyword, $default) { global $db; $best_guess = best_acct_guess($id, $keyword, $default); $result = $db->Execute("select id from " . DB_PREFIX . "chart_of_accounts order by id"); while (!$result->EOF) { $acct = $result->fields['id']; $pulldown .= '<option value="' . $acct . '"' . ($acct == $best_guess ? ' selected' : '') . '>' . urlencode($acct) . '</option>'; $result->MoveNext(); } return $pulldown; }