$attribute->display: 1,
);
$form['ordering'] = array (
'#type' => 'weight',
'#title' => t ('Order'),
'#description' => t ('Multiple attributes on an add to cart form are sorted by this value and then by their name.
May be overridden at the product level.'),
'#default_value' => $attribute->ordering,
);
$form['op'] = array (
'#type' => 'submit',
'#value' => t ('Submit'),
'#suffix' => l (t ('Cancel'), 'admin/store/products/attributes'),
);
return $form;
}
/**
* Submit function for uc_attribute_add_form ().
*/
function uc_attribute_form_submit ($form_id, $form_values) {
if (!empty ($form_values['aid'])) {
db_query («UPDATE {uc_attributes} SET name = '%s', ordering = %d, required = %d, display = %d, description = '%s' WHERE aid = %d», $form_values['name'], $form_values['ordering'], $form_values['required'], $form_values['display'], $form_values['description'], $form_values['aid']);
}
else {
db_query («INSERT INTO {uc_attributes} (name, ordering, required, display, description) VALUES ('%s', %d, %d, %d, '%s')», $form_values['name'], $form_values['ordering'], $form_values['required'], $form_values['display'], $form_values['description']);
}
return 'admin/store/products/attributes';
}
// Confirms the deletion of the given attribute.
function uc_attribute_delete_confirm ($aid) {
$attribute = uc_attribute_load ($aid);
// If we got a bunk attribute ID, kick out an error message.
if (empty ($attribute)) {
drupal_set_message (t ('There is no attribute with that ID.'), 'error');
drupal_goto ('admin/store/products/attributes');
}
$form['aid'] = array ('#type' => 'value', '#value' => $aid);
$form['#redirect'] = 'admin/store/products/attributes';
$count = db_result (db_query («SELECT COUNT (*) FROM {uc_product_attributes} WHERE aid = %d», $aid));
$output = confirm_form ($form, t ('Are you sure you want to delete the attribute %name?', array ('%name' => $attribute->name)),
'admin/store/products/attributes', format_plural ($count, 'There is @count product with this attribute.', 'There are @count products with this attribute.'),
t ('Delete'), t ('Cancel'));
return $output;
}
function uc_attribute_delete_confirm_submit ($form_id, $form_values) {
if ($form_values['confirm']) {
db_query («DELETE FROM co USING {uc_class_attribute_options} AS co, {uc_attribute_options} AS ao WHERE co. oid = ao. oid AND ao. aid = %d», $form_values['aid']);
db_query («DELETE FROM {uc_class_attributes} WHERE aid = %d», $form_values['aid']);
db_query («DELETE FROM po USING {uc_product_options} AS po, {uc_attribute_options} AS ao WHERE po. oid = ao. oid AND ao. aid = %d», $form_values['aid']);
db_query («DELETE FROM pd USING {uc_product_adjustments} AS pd, {uc_product_attributes} AS pa WHERE pd. nid = pa. nid AND pa. aid = %d», $form_values['aid']);
db_query («DELETE FROM {uc_product_attributes} WHERE aid = %d», $form_values['aid']);
db_query («DELETE FROM {uc_attribute_options} WHERE aid = %d», $form_values['aid']);
db_query («DELETE FROM {uc_attributes} WHERE aid = %d», $form_values['aid']);
drupal_set_message (t ('Product attribute deleted.'));
}
}
// Display options and the modifications to products they represent.
function uc_attribute_options ($aid) {
$attribute = uc_attribute_load ($aid);
// If we got a bunk attribute ID, kick out an error message.
if (empty ($attribute)) {
drupal_set_message (t ('There is no attribute with that ID.'), 'error');
drupal_goto ('admin/store/products/attributes');
}
drupal_set_title (t ('Options for %name', array ('%name' => $attribute->name)));
$header = array (t ('Name'), t ('Default cost'), t ('Default price'), t ('Default weight'), t ('Order'), t ('Operations'));
foreach ($attribute->options as $key => $data) {
$ops = array (
l (t ('edit'), 'admin/store/products/attributes/'. $aid .'/options/'. $key .'/edit'),
l (t ('delete'), 'admin/store/products/attributes/'. $aid .'/options/'. $key .'/delete'),
);
$rows[] = array ($data->name, $data->cost, $data->price, $data->weight, $data->ordering, implode (' ', $ops));
}
if (count ($rows) == 0) {
$rows[] = array (
array ('data' => t ('No options for this attribute have been added yet.'), 'colspan' => '6')
);
}
$output .= theme ('table', $header, $rows)
. l (t ('Add an option'), 'admin/store/products/attributes/'. $aid .'/options/add');
return $output;
}
/**
* Form builder for attribute options.
*
* @ingroup forms
* @see uc_attribute_option_form_validate
* @see uc_attribute_option_form_submit
*/
function uc_attribute_option_form ($aid, $oid = NULL) {
$attribute = uc_attribute_load ($aid);
// If we got a bunk attribute ID, kick out an error message.
if (empty ($attribute)) {
drupal_set_message (t ('There is no attribute with that ID.'), 'error');
drupal_goto ('admin/store/products/attributes');
}
$form['aid'] = array ('#type' => 'hidden', '#value' => $aid);
if ($oid) {
$option = $attribute->options[$oid];
if (!empty ($option)) {
$form['oid'] = array ('#type' => 'hidden', '#value' => $oid);
drupal_set_title (t ('Edit option: %name', array ('%name' => $option->name)));
}
}
else {
drupal_set_title (t ('Options for %name', array ('%name' => $attribute->name)));
}
$form['name'] = array (
'#type' => 'textfield',
'#title' => t ('Name'),
'#description' => t ('This name will appear to customers on product add to cart forms.'),
'#default_value' => $option->name,
'#required' => TRUE,
'#weight' => 0,
);
$form['ordering'] = array (
'#type' => 'weight',
'#title' => t ('Order'),
'#description' => t ('Options will be listed sorted by this value and then by their name.
May be overridden at the product level.'),
'#default_value' => $option->ordering,
'#weight' => 4,
);
$form['adjustments'] = array (
'#type' => 'fieldset',
'#title' => t ('Default adjustments'),
'#description' => t ('Enter a positive or negative value for each adjustment applied when this option is selected.
Any of these may be overriden at the product level.'),
'#collapsible' => FALSE,
'#weight' => 8,
);
$form['adjustments']['cost'] = array (
'#type' => 'textfield',
'#title' => t ('Cost'),
'#default_value' => $option->cost,
'#weight' => 1,
);
$form['adjustments']['price'] = array (
'#type' => 'textfield',
'#title' => t ('Price'),
'#default_value' => $option->price,
'#weight' => 2,
);
$form['adjustments']['weight'] = array (
'#type' => 'textfield',
'#title' => t ('Weight'),
'#default_value' => $option->weight,
'#weight' => 3,
);
$form['submit'] = array (
'#type' => 'submit',
'#value' => t ('Submit'),
'#suffix' => l (t ('Cancel'), 'admin/store/products/attributes/'. $aid .'/options'),
'#weight' => 10,
);
return $form;
}
/**
* Validate number formats.
*/
function uc_attribute_option_form_validate ($form_id, $form_values) {
$pattern = '/^-?d*(.d*)?$/';
$price_error = t ('This must be in a valid number format. No commas and only one decimal point.');
if (!is_numeric ($form_values['cost']['#value']) && !preg_match ($pattern, $form_values['cost']['#value'])) {
form_set_error ('cost', $price_error);
}
if (!is_numeric ($form_values['price']['#value']) && !preg_match ($pattern, $form_values['price']['#value'])) {
form_set_error ('price', $price_error);
}
if (!is_numeric ($form_values['weight']['#value']) && !preg_match ($pattern, $form_values['weight']['#value'])) {
form_set_error ('weight', $price_error);
}
}
/**
* Submit function for uc_attribute_option_form ().
*/
function uc_attribute_option_form_submit ($form_id, $form_values) {
if (!isset ($form_values['oid'])) {
db_query («INSERT INTO {uc_attribute_options} (aid, name, cost, price, weight, ordering) VALUES (%d, '%s', %f, %f, %f, %d)» ,
$form_values['aid'], $form_values['name'], $form_values['cost'], $form_values['price'], $form_values['weight'], $form_values['ordering']);
}
else {
db_query («UPDATE {uc_attribute_options} SET name = '%s', cost = %f, price = %f, weight = %f, ordering = %d WHERE aid = %d AND oid = %d» ,
$form_values['name'], $form_values['cost'], $form_values['price'], $form_values['weight'], $form_values['ordering'], $form_values['aid'], $form_values['oid']);
}
return 'admin/store/products/attributes/'. $form_values['aid'] .'/options';
}
// Confirms deletion of the given attribute option.
function uc_attribute_option_delete_confirm ($aid, $oid) {
$attribute = uc_attribute_load ($aid);
$option = $attribute->options[$oid];
if (empty ($option)) {
drupal_set_message (t ('There is no option with that ID.'), 'error');
drupal_goto ('admin/store/products/attributes/'. $aid .'/options');
}
$form['aid'] = array ('#type' => 'value', '#value' => $aid);
$form['oid'] = array ('#type' => 'value', '#value' => $oid);
$output = confirm_form ($form, t ('Are you sure you want to delete the option %name?', array ('%name' => $option->name)),
'admin/store/products/attributes/'. $aid .'/options', '',
t ('Delete'), t ('Cancel'));
return $output;
}
Листинг 4 editNaimеnovanie. php — сценарий для работы с товарами;
