コード例 #1
0
    $_POST['store_email'] = load_config_value('COMPANY_EMAIL');
}
if (!isset($_POST['store_website'])) {
    $_POST['store_website'] = load_config_value('COMPANY_WEBSITE');
}
if (!isset($_POST['store_telephone1'])) {
    $_POST['store_telephone1'] = load_config_value('COMPANY_TELEPHONE1');
}
if (!isset($_POST['store_telephone2'])) {
    $_POST['store_telephone2'] = load_config_value('COMPANY_TELEPHONE2');
}
if (!isset($_POST['store_fax'])) {
    $_POST['store_fax'] = load_config_value('COMPANY_FAX');
}
if (!isset($_POST['store_default_currency'])) {
    $_POST['store_default_currency'] = load_config_value('DEFAULT_CURRENCY');
}
if (isset($_POST['submit'])) {
    $store_id = db_prepare_input($_POST['store_id']);
    $store_name = db_prepare_input($_POST['store_name']);
    $store_address1 = db_prepare_input($_POST['store_address1']);
    $store_address2 = db_prepare_input($_POST['store_address2']);
    $store_city_town = db_prepare_input($_POST['store_city_town']);
    $store_zone = db_prepare_input($_POST['store_zone']);
    $store_postal_code = db_prepare_input($_POST['store_postal_code']);
    $store_country = db_prepare_input($_POST['store_country']);
    $store_email = db_prepare_input($_POST['store_email']);
    $store_website = db_prepare_input($_POST['store_website']);
    $store_telephone1 = db_prepare_input($_POST['store_telephone1']);
    $store_telephone2 = db_prepare_input($_POST['store_telephone2']);
    $store_fax = db_prepare_input($_POST['store_fax']);
コード例 #2
0
function best_acct_guess($id, $keyword, $default)
{
    global $db;
    $pulldown = '';
    $best_guess = load_config_value($default);
    if (!$best_guess) {
        $sql = "select c.id \r\n\t\tfrom " . DB_PREFIX . "chart_of_accounts c inner join " . DB_PREFIX . "chart_of_accounts_types t on c.account_type = t.id\r\n\t\twhere t.id = " . $id . " and c.description like '%" . $keyword . "%' limit 1";
        $result = $db->Execute($sql);
        if ($result->RecordCount() == 0) {
            // no record found, fetch at first account of specified type
            $result = $db->Execute("select id from " . DB_PREFIX . "chart_of_accounts where account_type = " . $id . " order by id");
        }
        $best_guess = $result->fields['id'];
    }
    return $best_guess;
}