[TOC] # 商品---訂單模塊 ## 商鋪后臺查看訂單列表 > 如下圖：   ## 目錄結構 ~~~ ├─admin │ └─themes │ └─simplebootx │ ├─Organ │ │ ├─Goods │ │ create.html 商品添加頁面 │ │ edit.html 商品修改頁面 │ │ index.html 商品查看頁面 │ ├─order │ │ wait.html 訂單頁面 ├─application │ ├─Organ │ │ ├─Common │ │ ├─Conf │ │ ├─Controller │ │ OrderController.class.php 訂單控制器 │ │ GoodsController.class.php 商鋪控制器 │ │ └─Lang ~~~ ## 數據庫結構 >服務 商品表 | 字段名 | 說明 | 類型 | | --- | --- | --- | | service_id | 服務id | int | | cate_id | 服務分類id | int | | province_id | 省id | int | | city_id | 市id | int | | district_id | 區id | int | | service_name | 服務名稱 | varchar（255| | service_img |服務圖片 | varchar（255 | | service_rule | 服務標準 | varchar（255 | | service_price |服務價格 | decimal(10 | | use_device | 使用設備 | varchar（255 | | detection_period | 檢測周期 |varchar（255 | | keywords | 關鍵字 | varchar（255 | | technical_feature | 技術特點 |varchar（255 | | service_scope | 服務領域 | varchar（255 | | service_description | 服務簡介 | varchar（255 | | sample_request | 樣品要求 | varchar（255 | > 訂單表 | 字段名 | 說明 | 類型 | | --- | --- | --- | |order_id | 訂單id | int | | service_id | 檢測服務的id | int | | user_id | 用戶id | int | | total_price | 總價格 | int | | create_time | 創建時間 | int | | status | 1代表已經付款 2代表正在配送 3客戶已經確認 | tinyint | | is_daofu | 是否是貨到付款 | tinyint | | addr_id | 收貨地址id | int | | number | 商品數量 | int | | order_reference | 訂單編號 | varchar | | organ_id |機構id |int | > 聯系人表 | 字段名 | 說明 | 類型 | | --- | --- | --- | |addr_id | 地址id | int | | user_id | 用戶id | int | | province_id |省id | int | | city_id | 市id | int | | district_id | 區id | int | | name | 名字 | varchar | | mobile | 手機 | varchar | | addr | 詳細地址 | varchar | | is_default | 是否默認地址 | tinyint | > 商品分類表 | 字段名 | 說明 | 類型 | | --- | --- | --- | |term_id| 分類id | bigint | | name | 分類名稱 | varchar | | description |描述 | text | | parent |分類父id | bigint | | path | 分類層級關系路徑 | bigint | | listorder | 排序 | int | | stastus | 狀態 | int | > 商戶 機構表 |字段名| 說明 | 類型 | | --- | --- | --- | |id| 機構id | int | |user_id| 用戶id | int | |cate_id| 機構檢測分類id | int | |region_id| 地區id | int | |city_id| 城市id | int | |area_id| 區域id | int | |organ_name| 機構名稱 | varchar | |tel| 電話 | varchar | |addr| 地址 | varchar | |postcode| 郵編 | varchar | |realname| 真實姓名 | varchar | |logo| logo圖片 | varchar | |idphoto| 證件照 | varchar | |qualification| 企業資格證書 | varchar | |create_time| 加入時間 | int | |description| 機構描述 | varchar | |audit| 審核 默認0 1代表審核 | tinyint | ## 訂單控制器 > OrderController.class.php ~~~ <?php namespace Organ\Controller; use Common\Controller\AdminbaseController; class OrderController extends AdminbaseController{ public function wait(){ $order_model = M('order_organ'); $order_arr = $order_model->select(); foreach ($order_arr as &$value) { $statue_name[1] = "已經付款"; $statue_name[2] = "正在配送"; $staue_name[3] = "已經確認"; $value['status'] = $statue_name[$value['status']]; //服務商品ID $service_id = $value['service_id']; $service_model = M('detection_service'); //服務商品詳細信息 $service_arr = $service_model->where("service_id=$service_id")->find(); $value['serviceInfo'] = $service_arr; //用戶信息 $user_model = M('users'); $user_id = $value['user_id']; //$user_arr = $user_model->field('user_nicename')->where("id=$user_id")->find(); $user_arr = $user_model->where("id=$user_id")->find(); $value['userInfo'] = $user_arr; //收貨地址 $addr_model = M('user_addr'); $addr_id = $value['addr_id']; // $addr_arr = $addr_model->field('addr')->where("addr_id=$addr_id")->find(); $addr_arr = $addr_model->where("addr_id=$addr_id")->find(); $value['addrInfo'] = $addr_arr; } $this->assign('order_arr',$order_arr); $this->display(); } } ~~~ ## 商品控制器 > GoodsController.class.php ~~~ <?php namespace Organ\Controller; use Common\Controller\AdminbaseController; header("content-type:text/html;charset=utf-8"); class GoodsController extends AdminbaseController{ //機構產品 public function index(){ $keyword = $_POST['keyword']; $shop_model = M('detection_service'); if ($keyword != "" || $keyword != null) { $where['service_name']= array('like','%'.$keyword.'%'); $where['keywords']= array('like','%'.$keyword.'%'); $shop_arr = $shop_model->where($where)->select(); }else{ $shop_arr = $shop_model->select(); } // echo $shop_model->getLastSql(); // dump($shop_arr);exit; $this->assign("shop_arr",$shop_arr); $this->display(); } //發布檢測服務 public function create(){ // 獲取一級分類 $classify_model = M('testingcate'); $classify_one = $classify_model->where('parent = 0')->select(); $this->assign("classify_one",$classify_one); $this->display(); } public function create_two(){ //二級分類父級id $classify_model = M('testingcate'); $term_id_T = $_GET['id']; $classify_two = $classify_model->where("parent = $term_id_T")->select(); $html = ""; if ($classify_two) { foreach ($classify_two as $h) { $html .= "<option value='{$h['term_id']}'>{$h['name']}</option>"; } } echo $html; } public function create_tree(){ //二級分類父級id $classify_model = M('testingcate'); $term_id_T = $_GET['id']; $classify_tree = $classify_model->where("parent = $term_id_T")->select(); $html = ""; if ($classify_tree) { foreach ($classify_tree as $h) { $html .= "<option value='{$h['term_id']}'>{$h['name']}</option>"; } } echo $html; } //添加商品 public function create_shop(){ $arr = I('post.'); $one_id = $arr['cateOne_id']; $two_id = $arr['cateTwo_id'] ; $tree_id = $arr['cateTree_id']; $data['cate_id'] = "$one_id-$two_id-$tree_id"; $data['service_name'] = $arr['service_name']; $data['service_img'] = $arr['service_img']; $data['service_price'] = $arr['service_price']; $data['use_device'] = $arr['use_device']; $data['detection_period'] = $arr['detection_period']; $data['keywords'] = $arr['keywords']; $data['service_scope'] = $arr['service_scope']; $data['service_rule'] = $arr['service_rule']; $data['technical_feature'] = $arr['technical_feature']; $data['sample_request'] = $arr['sample_request']; $data['service_description'] = $arr['service_description']; $data['datetime'] = date('Y-m-d H:i:s', time()); $shop_model = M('detection_service'); $lastInsId = $shop_model->add($data); if ($lastInsId) { $this->success('新增成功', U('Goods/index')); }else{ $this->error('數據寫入錯誤！'); } } //修改商品 public function edit(){ $service_id = $_GET['goods_id']; $shop_model = M('detection_service'); $shop_arr = $shop_model->where("service_id=$service_id")->find(); $cate = $shop_arr['cate_id']; $cate_arr = explode('-',$cate); $model = M('testingcate'); $one =$model->where("term_id=$cate_arr[0]")->find(); $one_name = $one['name']; $two =$model->where("term_id=$cate_arr[1]")->find(); $two_name = $two['name']; $tree =$model->where("term_id=$cate_arr[2]")->find(); $tree_name = $tree['name']; $shop_arr['one_id'] = $cate_arr[0]; $shop_arr['two_id'] = $cate_arr[1]; $shop_arr['tree_id'] = $cate_arr[2]; $shop_arr['one_name'] = $one_name; $shop_arr['two_name'] = $two_name; $shop_arr['tree_name'] = $tree_name; $classify_model = M('testingcate'); $classify_one = $classify_model->where('parent = 0')->select(); $this->assign("classify_one",$classify_one); $this->assign("shop_arr",$shop_arr); $this->display(); } public function edit_shop(){ $service_id = I('get.goods_id'); $arr = I('post.'); $one_id = $arr['cateOne_id']; $two_id = $arr['cateTwo_id'] ; $tree_id = $arr['cateTree_id']; $data['cate_id'] = "$one_id-$two_id-$tree_id"; $data['service_name'] = $arr['service_name']; $data['service_img'] = $arr['service_img']; $data['service_price'] = $arr['service_price']; $data['use_device'] = $arr['use_device']; $data['detection_period'] = $arr['detection_period']; $data['keywords'] = $arr['keywords']; $data['service_scope'] = $arr['service_scope']; $data['service_rule'] = $arr['service_rule']; $data['technical_feature'] = $arr['technical_feature']; $data['sample_request'] = $arr['sample_request']; $data['service_description'] = $arr['service_description']; $data['datetime'] = date('Y-m-d H:i:s', time()); $shop_model = M('detection_service'); $result = $shop_model->data($data)->where("service_id=$service_id")->save(); if ( false !== $result ){ $this->success('更新成功', U('Goods/index')); }else{ $this->error('更新失敗！'); } } } ~~~