{"id":255,"date":"2014-09-07T10:05:14","date_gmt":"2014-09-07T08:05:14","guid":{"rendered":"http:\/\/my-opinions.info\/?p=255"},"modified":"2014-09-08T08:35:23","modified_gmt":"2014-09-08T06:35:23","slug":"drobnoe-kolichestvo-ubercart-3","status":"publish","type":"post","link":"https:\/\/uw-t.com\/en\/drupal\/drobnoe-kolichestvo-ubercart-3","title":{"rendered":"\u0414\u0440\u043e\u0431\u043d\u043e\u0435 \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e ubercart 3"},"content":{"rendered":"

ubercard 3.5 \u043d\u0430\u0448\u0435\u043b \u0440\u0435\u0448\u0435\u043d\u0438\u044f \u0441 \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u043c\u0438 \u043a\u043e\u0440\u0435\u043a\u0442\u0438\u0440\u043e\u0432\u043a\u0430\u043c\u0438
\n\/\/ making the product quantities FLOAT instead INTEGER Drupal 7, Ubercart 3.1
\n\/\/\/\/ DATABASE CHANGES Four ubercart tables alterations are made from sql terminal (mysql -u ADMIN_USER -p , use DATABASE_NAME )
\n1) The UC_CART_PRODUCTS table intersect the UC_CARTS table and the UC_PRODUCTS table. The column \u0446\u2552\u0411\u250c\u255b\u0435\u2320qty\u0446\u2552\u0411\u250c\u255b\u0431\u00b2 is the one to ajust. Here is the MySQL statement that will modify the column to a FLOAT data type: <\/p>\n

ALTER TABLE `uc_cart_products` MODIFY COLUMN `qty` FLOAT(6,2) UNSIGNED NOT NULL DEFAULT 0;
\n<\/code><\/strong>
\n2) The UC_ORDERS table holds all the orders created. The column to adjust is \u0446\u2552\u0411\u250c\u255b\u0435\u2320product_count\u0446\u2552\u0411\u250c\u255b\u0431\u00b2.<\/p>\n

ALTER TABLE `uc_orders` MODIFY COLUMN `product_count` FLOAT(6,2) UNSIGNED NOT NULL DEFAULT 0; 3) The UC_PRODUCTS table contains a
\n<\/code><\/strong>
\ndefault_qty field. This value gets inserted into both the product edit page and the product view page (for the customer). I think it would be a good idea to show the customer how many decimal places one may use. <\/p>\n

ALTER TABLE `uc_products` MODIFY COLUMN `default_qty` FLOAT(6,2) UNSIGNED NOT NULL DEFAULT 1.00;<\/code><\/strong> <\/p>\n

4) The UC_ORDER_PRODUCTS table intersects the UC_ORDERS table and the UC_PRODUCTS table. The column to adjust is the \u0446\u2552\u0411\u250c\u255b\u0435\u2320qty\u0446\u2552\u0411\u250c\u255b\u0431\u00b2 column. Here is the MySQL statement that will modify the column to a FLOAT data type: <\/p>\n

ALTER TABLE `uc_order_products` MODIFY COLUMN `qty` FLOAT(6,2) UNSIGNED NOT NULL DEFAULT 0;
\n<\/code><\/strong><\/p>\n

\/\/\/\/ CODE CHANGES \/\/ FIRST uc_order -> uc_order.install \/\/Change array elements in function to: \/** * Increase maximum order item quantity. *\/<\/p>\n

\r\nfunction uc_order_update_7003() {\r\ndb_change_field('uc_order_products', 'qty', 'qty', array(\r\n'description' => 'The number of the same product ordered.',\r\n'type' => 'float',\r\n'precision' => 6,\r\n'scale' => 1,\r\n'unsigned' => TRUE,\r\n'not null' => TRUE,\r\n'default' => 1.0,\r\n));\r\n}\r\n\r\n<\/pre>\n
\/\/ SECOND<\/p>\n
\r\n\r\nuc_order\r\n->\r\nuc_order.install\r\n\r\nIn $schema['uc_order_products'] change:\r\n\r\n'qty' => array(\r\n'description' => 'The number of the same product ordered.',\r\n'type' => 'int',\r\n'size' => 'small',\r\n'unsigned' => TRUE,\r\n'not null' => TRUE,\r\n'default' => 0,\r\n),\r\n\r\n<\/pre>\n
To:<\/p>\n
\r\n\r\n'qty' => array(\r\n'description' => 'The number of the same product ordered.',\r\n'type' => 'float',\r\n'precision' => 6,\r\n'scale' => 1,\r\n'unsigned' => TRUE,\r\n'not null' => TRUE,\r\n'default' => 1.0,\r\n),\r\n\r\n<\/pre>\n
\/\/ THIRD uc_product -> uc_product.module \/\/For possibility of using 0.00 to 1.00 quantites in function uc_product_uc_update_cart_item change: (string 1052) p.s. \u0421 \u043d\u043e\u0432\u044b\u043c\u0438 \u0432\u0435\u0440\u0441\u0438\u044f\u043c\u0438 \u0444\u0443\u043d\u043a\u0446\u0438\u044f \u043f\u043e\u043c\u0435\u043d\u044f\u043b\u0430\u0441\u044c, \u044f \u0441\u043c\u0435\u043d\u0438\u043b \u043d\u0430 \u0444\u0443\u043d\u043a\u0446\u0438\u044e \u043d\u0430 \u0441\u0442\u0430\u0440\u0443\u044e \u0432\u0435\u0440\u0441\u0438\u044e, \u043f\u043e\u043a\u0430 \u0432\u0441\u0435 \u043e\u043a \ud83d\ude42<\/p>\n
<\/pre>\r\n<pre class="php"><code><span class="php-keyword">function<\/span> <span class="php-function-or-constant"><a class="local active" title="Implements hook_uc_update_cart_item()." href="http:\/\/drupalcontrib.org\/api\/drupal\/contributions%21ubercart%21uc_product%21uc_product.module\/function\/uc_product_uc_update_cart_item\/7">uc_product_uc_update_cart_item<\/a><\/span>(<span class="php-variable">$nid<\/span>, <span class="php-variable">$data<\/span> = <span class="php-keyword">array<\/span>(), <span class="php-variable">$qty<\/span>, <span class="php-variable">$cid<\/span> = <span class="php-function-or-constant">NULL<\/span>) {\r\n  <span class="php-keyword">if<\/span> (!<span class="php-variable">$nid<\/span>) {\r\n    <span class="php-keyword">return<\/span> <span class="php-function-or-constant">NULL<\/span>;\r\n  }\r\n  <span class="php-variable">$cid<\/span> = !(<span class="php-function-or-constant">is_null<\/span>(<span class="php-variable">$cid<\/span>) || <span class="php-keyword">empty<\/span>(<span class="php-variable">$cid<\/span>)) ? <span class="php-variable">$cid<\/span> : <span class="php-function-or-constant"><a class="local" title="Returns the unique cart_id of the user." href="http:\/\/drupalcontrib.org\/api\/drupal\/contributions%21ubercart%21uc_cart%21uc_cart.module\/function\/uc_cart_get_id\/7">uc_cart_get_id<\/a><\/span>();\r\n  <span class="php-keyword">if<\/span> (<span class="php-variable">$qty<\/span> < <span class="php-constant">1<\/span>) {\r\n    <span class="php-function-or-constant"><a class="local" title="Removes an item from the cart." href="http:\/\/drupalcontrib.org\/api\/drupal\/contributions%21ubercart%21uc_cart%21uc_cart.module\/function\/uc_cart_remove_item\/7">uc_cart_remove_item<\/a><\/span>(<span class="php-variable">$nid<\/span>, <span class="php-variable">$cid<\/span>, <span class="php-variable">$data<\/span>);\r\n  }\r\n  <span class="php-keyword">else<\/span> {\r\n    <span class="php-function-or-constant"><a class="local" title="Returns a new UpdateQuery object for the active database." href="http:\/\/drupalcontrib.org\/api\/drupal\/drupal%21includes%21database%21database.inc\/function\/db_update\/7">db_update<\/a><\/span>(<span class="php-string">'uc_cart_products'<\/span>)\r\n      -><span class="php-function-or-constant"><a class="local" title="Multiple implementations exist." href="http:\/\/drupalcontrib.org\/api\/search\/7\/fields">fields<\/a><\/span>(<span class="php-keyword">array<\/span>(\r\n      <span class="php-string">'qty'<\/span> => <span class="php-variable">$qty<\/span>, \r\n      <span class="php-string">'changed'<\/span> => <span class="php-function-or-constant"><a class="local" title="Time of the current request in seconds elapsed since the Unix Epoch." href="http:\/\/drupalcontrib.org\/api\/drupal\/drupal%21includes%21bootstrap.inc\/constant\/REQUEST_TIME\/7">REQUEST_TIME<\/a><\/span>,\r\n    ))\r\n      -><span class="php-function-or-constant"><a class="local" title="Multiple implementations exist." href="http:\/\/drupalcontrib.org\/api\/search\/7\/condition">condition<\/a><\/span>(<span class="php-string">'nid'<\/span>, <span class="php-variable">$nid<\/span>)\r\n      -><span class="php-function-or-constant"><a class="local" title="Multiple implementations exist." href="http:\/\/drupalcontrib.org\/api\/search\/7\/condition">condition<\/a><\/span>(<span class="php-string">'cart_id'<\/span>, <span class="php-variable">$cid<\/span>)\r\n      -><span class="php-function-or-constant"><a class="local" title="Multiple implementations exist." href="http:\/\/drupalcontrib.org\/api\/search\/7\/condition">condition<\/a><\/span>(<span class="php-string">'data'<\/span>, <span class="php-function-or-constant">serialize<\/span>(<span class="php-variable">$data<\/span>))\r\n      -><span class="php-function-or-constant"><a class="local" title="Multiple implementations exist." href="http:\/\/drupalcontrib.org\/api\/search\/7\/execute">execute<\/a><\/span>();\r\n  }\r\n}\r\n<\/pre>\n
<\/code>
\n <\/p>\n
\r\n\r\nif ($qty < 1) {\r\n\r\n\u00a0\r\n\r\n<\/pre>\n
CHANGE TO:<\/p>\n
\r\n\r\nif ($qty == 0) {\r\n\r\n<\/pre>\n
\/\/ FOURTH uc_order -> uc_order.admin.inc \/\/Not sure if it's necessary but just in case (string 1125)<\/p>\n
\r\nif (!isset($product['remove']) && intval($product['qty']) > 0) {\r\n<\/pre>\n
CHANGE TO:<\/p>\n
\r\n\r\nif (!isset($product['remove']) && ($product['qty']) > 0) {\r\n\r\n<\/pre>\n
\/\/FIFTH uc_cart -> uc_cart.install \/\/Not sure if it's necessary but just in case CHANGE TO FLOATS: (string 37)<\/p>\n
\r\n\r\n'qty' => array(\r\n'description' => 'The number of this product in the cart.',\r\n'type' => 'float',\r\n'precision' => 6,\r\n'scale' => 1,\r\n'unsigned' => TRUE,\r\n'not null' => TRUE,\r\n'default' => 1.0,\r\n\r\n<\/pre>\n
AND (string 126)<\/p>\n
\r\n\r\nfunction uc_cart_update_7001() {\r\ndb_change_field('uc_cart_products', 'qty', 'qty', array(\r\n'description' => 'The number of this product in the cart.',\r\n'type' => 'float',\r\n'precision' => 6,\r\n'scale' => 1,\r\n'unsigned' => TRUE,\r\n'not null' => TRUE,\r\n'default' => 1.0,\r\n));\r\n}\r\n\r\n<\/pre>\n
\/*uc_store\\uc_store.module*\/ \/*chenge *\/<\/p>\n
\r\n\r\nfunction uc_store_validate_uc_quantity(&$element, &$form_state) {\r\nif (!preg_match('\/^\\d+$\/', $element['#value'])) {\r\nform_error($element, t('The quantity must be a number.'));\r\n}\r\nelseif (empty($element['#allow_zero']) && !$element['#value']) {\r\nform_error($element, t('The quantity cannot be zero.'));\r\n}\r\n}\r\n\r\n<\/pre>\n
\/*on*\/<\/p>\n
\r\n\r\nfunction uc_store_validate_uc_quantity(&$element, &$form_state) {\r\nif (!preg_match("\/([0-9\\.-]+)\/", $element['#value'])) {\r\nform_error($element, t('The quantity must be a number.'));\r\n}\r\nelseif (empty($element['#allow_zero']) && !$element['#value']) {\r\nform_error($element, t('The quantity cannot be zero.'));\r\n}\r\n}\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
ubercard 3.5 \u043d\u0430\u0448\u0435\u043b \u0440\u0435\u0448\u0435\u043d\u0438\u044f \u0441 \u043d\u0435\u043a\u043e\u0442\u043e\u0440\u044b\u043c\u0438 \u043a\u043e\u0440\u0435\u043a\u0442\u0438\u0440\u043e\u0432\u043a\u0430\u043c\u0438 \/\/ making the product quantities FLOAT instead INTEGER Drupal 7, Ubercart 3.1 \/\/\/\/ DATABASE CHANGES Four ubercart tables alterations are made from sql terminal (mysql -u ADMIN_USER -p , use DATABASE_NAME ) 1) The UC_CART_PRODUCTS table intersect the UC_CARTS table and the UC_PRODUCTS table. The column \u0446\u2552\u0411\u250c\u255b\u0435\u2320qty\u0446\u2552\u0411\u250c\u255b\u0431\u00b2 is … Continue reading \u0414\u0440\u043e\u0431\u043d\u043e\u0435 \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e ubercart 3<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[15],"tags":[],"class_list":["post-255","post","type-post","status-publish","format-standard","hentry","category-drupal"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/uw-t.com\/en\/wp-json\/wp\/v2\/posts\/255","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/uw-t.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/uw-t.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/uw-t.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/uw-t.com\/en\/wp-json\/wp\/v2\/comments?post=255"}],"version-history":[{"count":5,"href":"https:\/\/uw-t.com\/en\/wp-json\/wp\/v2\/posts\/255\/revisions"}],"predecessor-version":[{"id":264,"href":"https:\/\/uw-t.com\/en\/wp-json\/wp\/v2\/posts\/255\/revisions\/264"}],"wp:attachment":[{"href":"https:\/\/uw-t.com\/en\/wp-json\/wp\/v2\/media?parent=255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/uw-t.com\/en\/wp-json\/wp\/v2\/categories?post=255"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/uw-t.com\/en\/wp-json\/wp\/v2\/tags?post=255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}