public function addratingAction() { $this->_helper->layout->disableLayout(); $ratingID = $this->_getParam("ratingid"); $rating = null; if ($ratingID != '') { $ratings = new Default_Model_AppRatings(); $ratings->filter->id->equals($ratingID); $ratings->refresh(); if (count($ratings->items) > 0) { $rating = $ratings->items[0]; } } else { $rating = new Default_Model_AppRating(); } $rating->appid = $this->_getParam("appid"); $rating->rating = $this->_getParam("rating"); if ($rating->rating == "0") { $rating->rating = null; } $rating->comment = trim($this->_getParam("comment")); if ($rating->comment == '' || $rating->comment == "undefined") { $rating->comment = null; } else { $rating->comment = substr($rating->comment, 0, 512); } $rating->submittedOn = date("Y-m-d H:i:s"); if ($this->_getParam("submitterid") != "") { $rating->submitterid = $this->_getParam("submitterid"); } else { $rating->submittername = $this->_getParam("submittername"); $rating->submitteremail = $this->_getParam("submittemail"); } if ($rating !== null) { $rating->save(); $apps = new Default_Model_Applications(); $apps->filter->id = $this->_getParam("appid"); echo '{"id":"' . $rating->id . '","average":"' . $apps->items[0]->rating . '"}'; } }
public function save(Default_Model_AppRating $value) { global $application; $data = array(); if (!isnull($value->getId())) { $data['id'] = $value->getId(); } if (!isnull($value->getAppID())) { $data['appid'] = $value->getAppID(); } if (!isnull($value->getRating())) { $data['rating'] = $value->getRating(); } if (!isnull($value->getComment())) { $data['comment'] = $value->getComment(); } if (!isnull($value->getSubmittedOn())) { $data['submittedon'] = $value->getSubmittedOn(); } if (!isnull($value->getSubmitterID())) { $data['submitterid'] = $value->getSubmitterID(); } if (!isnull($value->getSubmitterName())) { $data['submittername'] = $value->getSubmitterName(); } if (!isnull($value->getSubmitterEmail())) { $data['submitteremail'] = $value->getSubmitterEmail(); } if (!isnull($value->getGuID())) { $data['guid'] = $value->getGuID(); } if (!isnull($value->getModerated())) { $data['moderated'] = $this->pgBool($value->getModerated()); } $q1 = 'id = ?'; $q2 = $value->id; if (null === ($id = $value->id)) { unset($data['id']); $value->id = $this->getDbTable()->insert($data); } else { $s = $this->getDbTable()->getAdapter()->quoteInto($q1, $q2); $this->getDbTable()->update($data, $s); } }