public function get_ProvinceCityList() { try { $List = array(); //{"name":"\u5317\u4eac","citys":[{"10001":"\u5317\u4eac"}]}, $City = array(); $District = array(); $District[] = array('100001' => '海淀'); $District[] = array('100002' => '朝阳'); $City[] = array('100000' => '北京', 'District' => $District); $Province = array('Province' => '北京', 'City' => $City); $List[] = $Province; $City = array(); $District = array(); $District[] = array('200001' => '越秀区'); $District[] = array('200002' => '天河区'); $City[] = array('200000' => '广州', 'District' => $District); $District = array(); $District[] = array('200011' => '南山区'); $District[] = array('200022' => '福田区'); //$City = array(); $City[] = array('200010' => '深圳', 'District' => $District); $Province = array('Province' => '广东', 'City' => $City); $List[] = $Province; /* $List = array(); $List[] = array('ProvinceName' => '北京', 'CityName' => array(array('100001' => 'Haidian', '100002' => 'Chaoyang'))); $List[] = array('ProvinceName' => 'HaiNan', 'CityName' => array(array('200001' => 'Haikou', '200002' => 'Sanya'))); $List[] = array('ProvinceName' => 'Guangdong', 'CityName' => array(array('300001' => 'Guangzhou', '300002' => 'Shenzhen'))); */ //$List[] = array('HaiNan' => array('Haikou', 'Sanya')); //$List[] = array('Guangdong' => array('Guangzhou', 'Shenzhen')); $requestBody = array("Count" => 2, "List" => $List); return json_encode($requestBody); } catch (Exception $ex) { return ExceptionHandler::Response($ex, $this->_app); } }
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 verifySmsCode($SmsCodeId, $UserSmsCode, $Telephone) { try { $producer = R::getRow('SELECT id FROM producersmscode WHERE id=? AND code=? AND telephone=?', array($SmsCodeId, $UserSmsCode, $Telephone)); if (!isset($producer) || empty($producer)) { throw new RecordNotFoundException("SMS code is incorrect, SmsCodeId:" . $SmsCodeId); } //expirationtime > NOW() $producer = R::getRow('SELECT id FROM producersmscode WHERE id=? AND code=? AND telephone=? AND expirationtime > NOW()', array($SmsCodeId, $UserSmsCode, $Telephone)); if (!isset($producer) || empty($producer)) { throw new SmsException("SMS expired."); } echo json_encode(array("msg" => "success")); } catch (Exception $ex) { return ExceptionHandler::Response($ex, $this->_app); } }
public function get_Images($ProductId) { try { /*$product = R::find('product', 'ProductId=?', array($ProductId)); echo json_encode(R::exportAll($product));*/ $records = R::getAll('SELECT id, description, bigportraiturl, smallportraiturl FROM productimage WHERE productid=?', array($ProductId)); if (!isset($records) || empty($records)) { throw new RecordNotFoundException("Record not found, id:" . $ProductId); } /*$Count = count($records); $OrderList = array(); foreach ($records as $record) { $List[] = array('Id' => $record['id'], 'description' => $record['description'], 'bigportraiturl' => $record['bigportraiturl'], 'smallportraiturl' => $record['smallportraiturl']); } sendSuccess(array( 'Count' => $Count, 'List' => $List, ));*/ $response = new ResponseJSON(["id", "description", "bigportraiturl", "smallportraiturl"]); foreach ($records as $record) { $response->appendData($record); } //print json_encode($response2->exportResponse())."\n"; echo $response->exportResponse() . "\n"; } catch (Exception $ex) { return ExceptionHandler::Response($ex, $this->_app); } }
public function delete_Consignee($ConsigneeId) { try { $record = R::findOne('consignee', 'id=?', array($ConsigneeId)); if (!isset($record) || empty($record)) { throw new RecordNotFoundException("Record not found, id:" . $ConsigneeId); } R::trash($record); } catch (Exception $ex) { return ExceptionHandler::Response($ex, $this->_app); } }