php - dual database compare and update inventory value zencart stock function -

-

things lost or broken, basically, want compare actual inventory database against zencart store stock , update zencart stock if greater real inventory database.

i have table 'products' in first database (zencart) , second database (inventory), this: products_id products_model products_quantity

zencart.products : products_id : 3 | products_model : j293-04 | products_quantity : 4 |  [...]  inventory.products : products_id : 15 | products_model : j293-04 | products_quantity : 1 |  [...]

the inventory.products database actual count of products available.

when zencart stock query function tests if goods available, want compare stock quantity inventory database. if zencart stock quantity > inventory stock, update zencart stock quantity = inventory stock.

the zencart stock functions use zencart.products.product_id zencart.products.products_model has used compare 2 databases.

this have come replace zencart stock count function. seems overly complex, , not sure if inventory global $db2; needs put in.

function zen_get_products_stock($products_id) { global $db; $products_id = zen_get_prid($products_id);  $stock_query = "select products_quantity                 " . table_products . "                 products_id = '" . (int)$products_id . "'"; $stock_model_query = "select products_model                 " . table_products . "                 products_id = '" . (int)$products_id . "'";  $inv_stock_query = "select products_quantity                 inventory.products.products_model                 zencart.products.products_model =                       inventory.products.products_model  if $stock_query > $inv_stock_query  {    $stock_query = $inv_stock_query    update     inventory.products,     zencart.products     set     zencart.products.products_quantity = inventory.products.products_quantity        zencart.products.products_model = inventory.products.model }  $stock_values = $db->execute($stock_query);  return $stock_values->fields['products_quantity']; }

original code zencart/includes/functions/functions_lookups.com

/**  * return product's stock count.  *  * @param int product id of product who's stock want */   function zen_get_products_stock($products_id) {     global $db;     $products_id = zen_get_prid($products_id);     $stock_query = "select products_quantity                 " . table_products . "                 products_id = '" . (int)$products_id . "'";  $stock_values = $db->execute($stock_query);  return $stock_values->fields['products_quantity']; }  /**  * check if required stock available.  *  * if insufficent stock available return out of stock message  *  * @param int product id of product whos's stock checked  * @param int amount of stock available  *  * @todo naughty html in function */ function zen_check_stock($products_id, $products_quantity) { $stock_left = zen_get_products_stock($products_id) - $products_quantity; $out_of_stock = '';  if ($stock_left < 0) {   $out_of_stock = '<span class="markproductoutofstock">' . stock_mark_product_out_of_stock . '</span>'; }  return $out_of_stock;   }

thank help.


Comments

Post a Comment

Popular posts from this blog

google chrome - Developer tools - How to inspect the elements which are added momentarily (by JQuery)? -

-
i looking @ how website designed using inspector in chrome. can use firefox developer tools or firefox web developer add-on or chrome web developer extension. so website has slide-show , using jquery it. looking @ markup , css in inspector, i see 2 things constantly changing slides change: one opacity css property understandable, i'd see changing values, changes fast see read anything. second- a div added in div slides change momentarily , moment when appears short notice except div . so question is there way stop slideshow can temporarily rid of blinking sort of effect (by speedy adding , removal , changing of elements , values)? where can inspect div element gets added such short moment , , gets removed? , can see changes in value of opacity takes place? is there way stop slideshow can temporarily rid of blinking sort of effect (by speedy adding , removal , changing of elements , values)? if opacity animated css transition or animation,
Read more

angularjs - Showing an empty as first option in select tag -

-
my app showing empty select field first entry. have read other solution given , tried still not working. my controller code is: .controller('usercreatecontroller', function(user,profile,auth) { alert("hello"); var vm = this; vm.type = 'create'; profile.all() //this service fetch profiles shown in select field .success(function(data){ vm.profile = data; }); vm.userdata.profile = vm.profile[0]; //here have set default value select field and html page is: <label class="col-sm-2 control-label">profile</label> <div class="col-sm-8"> <select ng-model="user.userdata.profile" ng-options="person._id person.profilename person in user.profile"> </select> </div> hierarchy of vm.profile { "_id": 46, "profile": objectid("5516498e95b84548156db754"), "isactive": true, "password": "$2
Read more

php - Cloud9 cloud IDE and CakePHP -

-
i attempting cakephp running on cloud9, cloud based ide. unaware, cloud collaboration ide intermixes services such bitbucket. site gives sudo rights, , installed cakephp using these instructions: https://www.digitalocean.com/community/tutorials/how-to-install-cakephp-on-an-ubuntu-12-04-vps when attempt run database exported machine cakephp installed, error message "url rewriting not configured on server." attempted solve issue using official guide cakephp: http://book.cakephp.org/2.0/en/installation/url-rewriting.html but no cigar, same error message. has gotten cakephp working, or aware of cloud ide free/low cost cloud9 support cakephp? here's how got working now: sudo apt-get update sudo apt-get install php5-intl curl -ss https://getcomposer.org/installer | php -- --filename=composer ./composer create-project --prefer-dist cakephp/app this creates project in /app default. move workspace docroot: mv app/* ./ mv app/.* ./ rm -rf app then de
Read more