实例介绍
【实例简介】此实例为小程序的后端api接口，前端程序在这里 http://www.haolizi.net/example/view_14959.html
appid 数据库名称修改成自己的 就可以了
【实例截图】
【核心代码】
orders.php
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
use \QCloud_WeApp_SDK\Auth\LoginService as LoginService;
use QCloud_WeApp_SDK\Constants as Constants;
class Orders extends MY_Controller {
public function __construct() {
parent::__construct();
$this->load->driver('cache', array('adapter' => 'file'));
}
/**
* orders
*/
public function index() {
$get = $this->input->get(NULL, TRUE);
$act = isset($get['act']) ? $get['act'] : '';
if ($act == 'list') {
$this->get_list();
} else if ($act == 'add') {
$this->add();
} else if ($act == 'info') {
$this->info();
} else {
$this->json([
'code' => -1,
'msg' => '参数异常!',
'data' => []
]);
}
}
/**
* 订单列表
*/
public function get_list() {
$get = $this->input->get(NULL, TRUE);
$session3rd = isset($get['session3rd']) ? $get['session3rd'] : '';
$sessionid = $this->cache->get($session3rd);
$page = isset($get['page']) ? $get['page'] : 1;
$status = isset($get['status']) ? $get['status'] : 'all';
$limit = isset($get['limit']) ? $get['limit'] : 10;
if ($sessionid) {
$dat = explode('-', $sessionid);
$openid = $dat[0];
switch ($status){
case 'submitted': //已提交
$map=array('openid' => $openid,'status'=>1);
break;
case 'confirmed': //已确认,
$map=array('openid' => $openid,'status'=>2);
break;
case 'finished': //已完成
$map=array('openid' => $openid,'status'=>3);
break;
case 'canceled': //已取消
$map=array('openid' => $openid,'status'=>4);
break;
default:
$map=array('openid' => $openid);
}
$this->db->where($map);
$result['total'] = $this->db->count_all_results('orders');
if ($limit > 0) {
$this->db->limit($limit, ($page - 1) * $limit);
}
$result['items']=array();
$items= $this->db->get('orders')->result_array();
$result['totalPage'] = ceil($result['total'] / $limit);
foreach($items as $key=>$v){
$result['items'][$key]=$v;
$result['items'][$key]['goods']=$this->getOrderGood($v['orderid']);
}
$this->json([
'code' => 0,
'msg' => '成功！',
'data' => $result
]);
} else {
$this->json([
'code' => -4,
'msg' => '登录过期！',
'data' => []
]);
}
}
/**
* 提交订单
* @return booleant
*/
public function add() {
$get = $this->input->get(NULL, TRUE);
$address_id = isset($get['address_id']) ? $get['address_id'] : '';
$session3rd = isset($get['session3rd']) ? $get['session3rd'] : '';
$sessionid = $this->cache->get($session3rd);
if ($sessionid) {
$totalprice = 0;
$dat = explode('-', $sessionid);
$params = $this->db->where(array('openid' => $dat[0], 'selected' => 1))->get('cart')->result_array();
if ($params) {
foreach ($params as $v) {
$totalprice = abs($v['price'] * $v['num']);
$result = $this->db->where(array('id' => $v['good_id']))->get('product')->row_array();
if (empty($result)) {
$this->json([ 'code' => -1, 'msg' => '产品不存在！', 'data' => []]);
return false;
}
}
$address = $this->getAddress($address_id, $dat[0]);
$order = array(
'ordersn' => time() . rand(10000, 99999),
'openid' => $dat[0],
'username' => $dat[0],
'totalprice' => $totalprice,
'address_id' => $address_id,
'address' => $address,
'status' =>1,
'addtime' => time()
);
$insert=$this->db->insert('orders', $order);
$insertid=$this->db->insert_id();
if ($insert) {
$this->addGoods($insertid,$params);
$this->json([
'code' => 0,
'msg' => '成功！',
'data' => array('id' =>$insertid)
]);
} else {
$this->json([
'code' => -1,
'msg' => '失败！',
'data' => []
]);
}
} else {
$this->json([
'code' => -1,
'msg' => '失败！',
'data' => []
]);
}
} else {
$this->json([
'code' => -4,
'msg' => '登录过期！',
'data' => []
]);
}
}
/**
* 订单详情
*/
public function info() {
$get = $this->input->get(NULL, TRUE);
$orderid = isset($get['id']) ? $get['id'] : '';
$session3rd = isset($get['session3rd']) ? $get['session3rd'] : '';
$sessionid = $this->cache->get($session3rd);
if ($sessionid) {
$dat = explode('-', $sessionid);
$result = $this->db->where(array('openid' => $dat[0], 'orderid' => $orderid))->get('orders')->row_array();
if ($result) {
$address = $this->db->where(array('openid' => $dat[0], 'id' => $result['address_id']))->get('address')->row_array();
$result['address'] = $address;
$result['items'] = $this->getOrderGood($orderid);
$this->json([
'code' => 0,
'msg' => '成功！',
'data' => $result
]);
} else {
$this->json([
'code' => -1,
'msg' => '失败！',
'data' => []
]);
}
} else {
$this->json([
'code' => -4,
'msg' => '登录过期！',
'data' => []
]);
}
}
/**
* 收货地址
* @param type $address_id
* @param type $openid
* @return type
*/
protected function getAddress($address_id,$openid) {
$data = $this->db->where(array('id' => $address_id,'openid'=>$openid))->get('address')->row_array();
if($data){
return $data['name'].'---'.$data['tel'].'---'.$data['address'];
}else{
return '';
}
}
/**
* 订单商品
* @param type $address_id
* @param type $openid
* @return type
*/
protected function getOrderGood($orderid) {
$data = $this->db->where(array('orderid' => $orderid))->get('order_info')->result_array();
return $data;
}
/**
* 订单商品添加
* @param type $orderid 订单id
* @param type $params 订单商品
*/
protected function addGoods($orderid, $params) {
foreach ($params as $v) {
$data = array(
'orderid' => $orderid,
'good_id' => $v['good_id'],
'good_name' => $v['good_name'],
'image' => $v['image'],
'price' => $v['price'],
'num' => $v['num'],
'totalprice' => abs($v['price'] * $v['num'])
);
$this->db->insert('order_info', $data);
$this->db->where(array('openid' => $v['openid'], 'good_id' => $v['good_id']))->delete('cart');
}
}
}
cart.php
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
use \QCloud_WeApp_SDK\Auth\LoginService as LoginService;
use QCloud_WeApp_SDK\Constants as Constants;
class Cart extends MY_Controller {
public function __construct() {
parent::__construct();
$this->load->driver('cache', array('adapter' => 'file'));
}
/**
* 购物车
*/
public function index() {
$get = $this->input->get(NULL, TRUE);
$act = isset($get['act']) ? $get['act'] : '';
if($act=='list'){
$this->get_list();
}else if($act=='add'){
$this->add();
}else if($act=='update'){
$this->edit();
}else if($act=='updates'){
$this->updates();
}else if($act=='del'){
$this->del();
}else{
$this->json([
'code' => -1,
'msg' => '参数异常!',
'data' => []
]);
}
}
public function get_list(){
$get = $this->input->get(NULL, TRUE);
$session3rd = isset($get['session3rd']) ? $get['session3rd'] : '';
$sessionid=$this->cache->get($session3rd);
$page=isset($get['page']) ? $get['page'] : 1;
$limit=isset($get['limit']) ? $get['limit'] : 5;
if($sessionid){
$dat= explode('-', $sessionid);
$openid=$dat[0];
$this->db->where(array('openid'=>$openid));
$result['total']=$this->db->count_all_results('cart');
if ($limit > 0) {
$this->db->limit($limit, ($page-1)*$limit);
}
$result['items'] = $this->db->get('cart')->result_array();
$result['params']=array('page'=>$page);
$result['totalPage']= ceil($result['total']/$limit);
$this->json([
'code' => 0,
'msg' => '成功！',
'data' => $result
]);
}else{
$this->json([
'code' => -4,
'msg' => '登录过期！',
'data' => []
]);
}
}
public function add(){
$get = $this->input->get(NULL, TRUE);
$id= isset($get['id']) ? $get['id'] : ''; //产品id
$session3rd = isset($get['session3rd']) ? $get['session3rd'] : '';
$sessionid=$this->cache->get($session3rd);
if($sessionid){
$dat= explode('-', $sessionid);
if($id){
$result=$this->db->where(array('id'=>$id))->get('product')->row_array();
if(!$result){
$this->json([
'code' => -1,
'msg' => '产品不存在！',
'data' => []
]);
return false;
}
$data=array(
'openid'=>$dat[0],
'good_id'=>$id,
'good_name'=>$result['product_name'],
'image'=>$result['product_img'],
'num'=>1,
'price'=>$result['product_price'],
'selected'=>1,
'addtime'=>time()
);
$cartdata=$this->db->where(array('openid'=>$dat[0],'good_id'=>$id))->get('cart')->row_array();
if($cartdata){
$this->db->where(array('openid'=>$dat[0],'good_id'=>$id));
$this->db->set('num','num 1',FALSE);
$this->db->update('cart');
$this->json([
'code' => 0,
'msg' => '添加成功！',
'data' => []
]);
}else{
$insert=$this->db->insert('cart',$data);
if($insert){
$this->json([
'code' => 0,
'msg' => '成功！',
'data' => $data
]);
}else{
$this->json([
'code' => -1,
'msg' => '失败！',
'data' => []
]);
}
}
}else{
$this->json([
'code' => -1,
'msg' => '失败！',
'data' => []
]);
}
}else{
$this->json([
'code' => -4,
'msg' => '登录过期！',
'data' => []
]);
}
}
public function edit(){
$get = $this->input->get(NULL, TRUE);
$id= isset($get['id']) ? $get['id'] : ''; //产品id
$num= isset($get['total']) ? $get['total'] : ''; //产品数量
$session3rd = isset($get['session3rd']) ? $get['session3rd'] : '';
$sessionid=$this->cache->get($session3rd);
if($sessionid){
$dat= explode('-', $sessionid);
if($id){
$result=$this->db->where(array('id'=>$id))->get('product')->row_array();
if(!$result){
$this->json([
'code' => -1,
'msg' => '商品不存在！',
'data' => []
]);
return false;
}
$data=array('num'=>$num);
$cartdata=$this->db->where(array('openid'=>$dat[0],'good_id'=>$id))->get('cart')->row_array();
if($cartdata){
$this->db->where(array('openid'=>$dat[0],'good_id'=>$id));
$this->db->update('cart',$data);
$this->json([
'code' => 0,
'msg' => '更新成功！',
'data' => []
]);
}else{
$this->json([
'code' => -1,
'msg' => '失败！',
'data' => []
]);
}
}else{
$this->json([
'code' => -1,
'msg' => '商品不存在！',
'data' => []
]);
}
}else{
$this->json([
'code' => -4,
'msg' => '登录过期！',
'data' => []
]);
}
}
public function updates(){
$get = $this->input->get(NULL, TRUE);
$cartids= isset($get['cartid']) ? json_decode($get['cartid'],true) : ''; //产品id
$session3rd = isset($get['session3rd']) ? $get['session3rd'] : '';
$sessionid=$this->cache->get($session3rd);
if($sessionid){
$dat= explode('-', $sessionid);
if($cartids){
foreach($cartids as $v){
$data=array('num'=>$v['num']);
$this->db->where(array('openid'=>$dat[0],'good_id'=>$v['good_id']));
$this->db->update('cart',$data);
}
$this->json([
'code' => 0,
'msg' => '成功！',
'data' => $cartids
]);
}else{
$this->json([
'code' => -1,
'msg' => '商品不存在！',
'data' => []
]);
}
}else{
$this->json([
'code' => -4,
'msg' => '登录过期！',
'data' => []
]);
}
}
public function del(){
$get = $this->input->get(NULL, TRUE);
$id= isset($get['id']) ? $get['id'] : ''; //产品id
$session3rd = isset($get['session3rd']) ? $get['session3rd'] : '';
$sessionid=$this->cache->get($session3rd);
if($sessionid){
$dat= explode('-', $sessionid);
if($id){
$result=$this->db->where(array('id'=>$id))->get('product')->row_array();
if(!$result){
$this->json([
'code' => -1,
'msg' => '商品不存在！',
'data' => []
]);
return false;
}
$cartdata=$this->db->where(array('openid'=>$dat[0],'good_id'=>$id))->get('cart')->row_array();
if($cartdata){
$this->db->where(array('openid'=>$dat[0],'good_id'=>$id));
$this->db->delete('cart');
$this->json([
'code' => 0,
'msg' => '删除成功！',
'data' =>[]
]);
}else{
$this->json([
'code' => -1,
'msg' => '失败！',
'data' => []
]);
}
}else{
$this->json([
'code' => -1,
'msg' => '商品不存在！',
'data' => []
]);
}
}else{
$this->json([
'code' => -4,
'msg' => '登录过期！',
'data' => []
]);
}
}
}
相关软件
网友评论
小贴士
感谢您为本站写下的评论，您的评论对其它用户来说具有重要的参考价值，所以请认真填写。
- 类似“顶”、“沙发”之类没有营养的文字，对勤劳贡献的楼主来说是令人沮丧的反馈信息。
- 相信您也不想看到一排文字/表情墙，所以请不要反馈意义不大的重复字符，也请尽量不要纯表情的回复。
- 提问之前请再仔细看一遍楼主的说明，或许是您遗漏了。
- 请勿到处挖坑绊人、招贴广告。既占空间让人厌烦，又没人会搭理，于人于己都无利。
关于好例子网
本站旨在为广大IT学习爱好者提供一个非营利性互相学习交流分享平台。本站所有资源都可以被免费获取学习研究。本站资源来自网友分享，对搜索内容的合法性不具有预见性、识别性、控制性，仅供学习研究，请务必在下载后24小时内给予删除，不得用于其他任何用途，否则后果自负。基于互联网的特殊性，平台无法对用户传输的作品、信息、内容的权属或合法性、安全性、合规性、真实性、科学性、完整权、有效性等进行实质审查；无论平台是否已进行审查，用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。本站所有资源不代表本站的观点或立场，基于网友分享，根据中国法律《信息网络传播权保护条例》第二十二与二十三条之规定，若资源存在侵权或相关问题请联系本站客服人员，点此联系我们。关于更多版权及免责申明参见 版权及免责申明
支持(0) 盖楼(回复)