public function getConsumerFavoriteCount($ConsumerId) { try { $OrderCount = R::getRow('SELECT COUNT(id) AS totalCount FROM consumerfavoriteproduct WHERE consumerid=?', [$ConsumerId]); echo ResponseJsonHandler::normalizeJsonResponse($OrderCount); } catch (Exception $ex) { return ExceptionHandler::Response($ex, $this->_app); } }
public function get_Image($ProductId) { try { $result = R::getRow('SELECT id, description, bigportraiturl, smallportraiturl FROM productimage WHERE productid=? LIMIT 1', array($ProductId)); if (!isset($result) || empty($result)) { throw new RecordNotFoundException("Record not found, id:" . $ProductId); } //echo json_encode($result, ); echo ResponseJsonHandler::normalizeJsonResponse($result); } catch (Exception $ex) { return ExceptionHandler::Response($ex, $this->_app); } }
public function postSmsCode() { try { $requestJson = RequestBodyHandler::getJsonBody($this->_app); RequestBodyHandler::verifyJsonBody($requestJson, array("Telephone")); $randomCode = rand(1000, 9999); $expireInMins = "1"; $tempId = "46556"; //发送短信验证码 $reponseArray = SMS::SendTemplateSMS($requestJson->Telephone, array($randomCode, $expireInMins), $tempId); $rdb = R::dispense('producersmscode'); $rdb->telephone = $requestJson->Telephone; $rdb->code = $randomCode; $rdb->expirationtime = date('Y-m-d H:i:s', strtotime("+1 minute")); $rdb->statuscode = $reponseArray[0]; $rdb->smsmessagesid = $reponseArray[1]; $rdb->datecreated = $reponseArray[2]; $rdb->lastmodifiedtime = now(); $id = R::store($rdb); echo ResponseJsonHandler::normalizeJsonResponse(array("id" => $id, "smsCode" => $randomCode, "telephone" => $requestJson->Telephone)); } catch (Exception $ex) { return ExceptionHandler::Response($ex, $this->_app); } }
public function get_Consignee($ConsigneeId) { try { $response = R::findOne('consignee', 'id=?', array($ConsigneeId)); if (!isset($response) || empty($response)) { throw new RecordNotFoundException("Record not found, id:" . $ConsigneeId); } echo ResponseJsonHandler::normalizeJsonResponse(R::exportAll($response)); } catch (Exception $ex) { return ExceptionHandler::Response($ex, $this->_app); } }