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);
}
}
