public function getBalance($_stitem_id = '', $_location_id = '', $_bin_id = '') { // Function called by Ajax Request to return balance for selected item, location, bin if (isset($this->_data['ajax'])) { if (!empty($this->_data['stitem_id'])) { $_stitem_id = $this->_data['stitem_id']; } if (!empty($this->_data['whlocation_id'])) { $_location_id = $this->_data['whlocation_id']; } if (!empty($this->_data['whbin_id'])) { $_bin_id = $this->_data['whbin_id']; } } $balance = new STBalance(); $cc = new ConstraintChain(); $cc->add(new Constraint('stitem_id', '=', $_stitem_id)); $cc->add(new Constraint('whlocation_id', '=', $_location_id)); if (!empty($_bin_id) && $_bin_id != "null") { $cc->add(new Constraint('whbin_id', '=', $_bin_id)); } $balance->loadBy($cc); $balances = $balance->isLoaded() ? $balance->balance : 0; if (isset($this->_data['ajax'])) { $this->view->set('value', $balances); $this->setTemplateName('text_inner'); } else { return $balances; } }