assign('breadcrumb1','销售管理');
$this->assign('breadcrumb2','订单管理');
}
/**
* 首页列表
*
* */
public function index(Model $Model,OrdersProduct $OrdersProduct,Product $Product,Custom $Custom){
// 接受参数
$code = request('order_code','');
$productCode = request('product_code','');
$snowflakeId = request('snowflake_id',0);
$orders_other = request('orders_other',0);
$customCode = request('custom_code','');
$productName = request('product_name','');
$phone = request('phone','');
$contact_area = request('contact_area','');
$contact_school = request('contact_school','');
$contact_grade = request('contact_grade','');
$contact_class = request('contact_class','');
$status = request('status',0);
$startTime = request('start_time','');
$endTime = request('end_time','');
// 编码转ID
$id = $code ? $Model->codeToId($code) : 0;
$productId = $productCode ? $Product->codeToId($productCode) : 0;
$uid = $customCode ? $Custom->codeToId($customCode) : 0;
// 查询条件
$map = [];
// 编码ID
if( $id ) $map[] = ['orders_product.order_id','=',$id];
if( $snowflakeId ) $map[] = ['orders.snowflake_id','=',$snowflakeId];
if( $uid ) $map[] = ['custom.uid','=',$uid];
// 编码ID
if( $orders_other ) $map[] = $orders_other == 1 ? ['orders_product.product_id','>',0] : ['orders_product.product_id','=',0];
if( $productId ) $map[] = ['orders_product.product_id','=',$productId];
if( $productName ) $map[] = ['orders_product.product_name','=',$productName];
if( $phone ) $map[] = ['orders_addr.contact_phone','=',$phone];
if( $contact_area ) $map[] = ['orders_addr.contact_area','LIKE','%'.$contact_area.'%'];
if( $contact_school ) $map[] = ['orders_addr.contact_school','LIKE','%'.$contact_school.'%'];
if( $contact_grade ) $map[] = ['orders_addr.contact_grade','LIKE','%'.$contact_grade.'%'];
if( $contact_class ) $map[] = ['orders_addr.contact_class','LIKE','%'.$contact_class.'%'];
if( $startTime ) $map[] = ['orders_product.insert_time','>=',strtotime($startTime)];
if( $endTime ) $map[] = ['orders_product.insert_time','<=',strtotime($endTime)];
if( $status ) $map[] = ['orders_product.status','=',$status];
// 查询数据
$list = $OrdersProduct->query()
->join('custom','orders_product.custom_uid','=','custom.uid')
->join('orders','orders.id','=','orders_product.order_id')
->join('orders_addr','orders_addr.order_id','=','orders_product.order_id')
->where($map)
->orderByDesc('orders_product.id')
->select([
'orders_product.id as id',
'orders.snowflake_id',
'orders_product.order_id',
'orders_product.product_id',
'orders_product.product_name',
'orders_product.sku_attr_names as product_spec',
'orders_product.product_thumb',
'orders_product.buy_num',
'orders_product.price_total',
'orders_product.coupon_total',
'orders_product.pay_total',
'orders_product.status',
'orders_addr.contact_area',
'orders_addr.contact_school',
'orders_addr.contact_grade',
'orders_addr.contact_class',
'orders_addr.contact_name',
'orders_addr.contact_phone',
'custom.uid as custom_uid',
'custom.username as custom_name',
'custom.external_userid as external_userid',
'orders_product.insert_time',
])->paginate(request('limit',config('page_num',10)))->appends(request()->all());
// 循环处理数据
foreach ($list as $key => $value) {
// id转编号
$value['order_code'] = $Model->idToCode($value['order_id']);
$value['custom_code'] = $Custom->idToCode($value['custom_uid']);
$value['state'] = $Model->getState($value['status'],'state');
// 重组
$list[$key] = $value;
}
// 分配数据
$this->assign('empty', '
~~暂无数据 |
');
$this->assign('list', $list);
// 加载模板
return $this->fetch();
}
/**
* 首页列表
*
* */
public function detail(Model $Model,AdminUser $AdminUser,OrdersProduct $OrdersProduct,Product $Product,Custom $Custom,OrdersAddr $OrdersAddr,Receipt $Receipt){
// 接受参数
$id = request('order_id','');
// 查询数据
$order = $Model->query()->find($id);
// 查询不到订单
if( !$order ) return $this->error('订单数据不存在');
// id转编号
$order['order_code'] = $Model->idToCode($order['id']);
$order['custom_code'] = $Custom->idToCode($order['custom_uid']);
$order['custom_name'] = $Custom->getValue($order['custom_uid'],'username');
$order['state'] = $Model->getState($order['status'],'state');
// 查询子订单数据
$orderItems = $OrdersProduct->query()->where([['order_id','=',$id]])->select(['id as item_id','order_id','product_id','buy_num','pay_total','is_rebate','sku_attr_names as product_spec','product_name','product_thumb'])->get()->toArray();
// 地址
$orderAddr = $OrdersAddr->query()->where([['order_id','=',$id]])->first(['contact_name','contact_phone','contact_province','contact_city','contact_area','contact_addr','contact_shop']);
// 审核记录
$orderReceipt = $Receipt->query()->where([['order_id','=',$id]])->orderByDesc('id')->get()->toArray();
// 循环数据
foreach ($orderItems as $key => $value) {
$value['product_code'] = $Product->idToCode($value['product_id']);
$orderItems[$key] = $value;
}
// 循环数据
foreach ($orderReceipt as $key => $value) {
// 操作人员
$value['admin_name']= $AdminUser->getOne($value['admin_uid'],'username');
$value['image'] = path_compat($value['image']);
$orderReceipt[$key] = $value;
}
// 积分
$score = $orderReceipt ? max(array_column($orderReceipt,'give_score')) : 0;
// 恭喜
$shopName = $orderAddr['contact_shop'] ? $orderAddr['contact_shop'] : $order['custom_name'];
// 结果
$shareImage = $this->getShareImage($shopName,$score);
// 分配数据
$this->assign('empty', '~~暂无数据 |
');
$this->assign('order', $order);
$this->assign('orderAddr', $orderAddr);
$this->assign('orderItems', $orderItems);
$this->assign('orderReceipt', $orderReceipt);
$this->assign('shareImage', $shareImage);
// 加载模板
return $this->fetch();
}
/**
* 状态
*
* */
public function set_status( Request $request, Model $Model,OrdersProduct $OrdersProduct,CustomScore $CustomScore){
// 验证参数
$request->scene('set_status')->validate();
// 接收参数
$id = request('id',0);
$status = request('status',0);
// 获取产品和数量
$oldData = $Model->query()->find($id,['id','order_score','custom_uid','insert_time']);
// 如果用户不存在
if( !$oldData ) return json_send(['code'=>'error','msg'=>'订单不存在']);
// 组合数据,写入订单表,子表
DB::beginTransaction();
try{
// 查询数据
$result = $Model->setOrderStatus($id,$status,$OrdersProduct);
// 提示新增失败
if( isset($result['error']) ) {
// 回退数据
DB::rollBack();
// 提示信息
return json_send(['code'=>'error','msg'=>$result['error'],'data'=>['error'=>$result['error']]]);
}
if( $status == 4 ){
// 取消积分
if( $oldData['order_score'] > 0 ) {
// 如果扣减失败
$result = $CustomScore->trade($oldData['custom_uid'],$oldData['id'],($oldData['order_score']*-1),6,1);
// 提示新增失败
if( isset($result['error']) ) {
// 回退数据
DB::rollBack();
// 提示信息
return json_send(['code'=>'error','msg'=>'取消赠送积分失败','data'=>['error'=>$result['error']]]);
}
}
// 取消关联订单
$result = $Model->cancelRelate($oldData['insert_time'],$oldData['custom_uid'],$OrdersProduct,$CustomScore);
// 提示新增失败
if( isset($result['error']) ) {
// 回退数据
DB::rollBack();
// 提示信息
return json_send(['code'=>'error','msg'=>'取消关联订单失败','data'=>['error'=>$result['error']]]);
}
}
// 提交数据
DB::commit();
// 告知结果
return json_send(['code'=>'success','msg'=>'设置成功','path'=>'']);
// 返回结果
} catch (\Throwable $th) {
// 回退数据
DB::rollBack();
// 下单失败提示
return json_send(['code'=>'error','msg'=>'设置失败','data'=>['error'=>$th->getMessage().$th->getLine()]]);
}
}
/**
* 退款
*
* */
public function refund( Request $request, Model $Model,OrdersProduct $OrdersProduct,CustomScore $CustomScore,Payment $Payment){
// 验证参数
$request->scene('refund')->validate();
// 接收参数
$id = request('id',0);
$orderInfo = $Model->query()->find($id);
if (!$orderInfo) return json_send(['code'=>'error','msg'=>'订单不存在']);
$params['out_trade_no'] = (string)$orderInfo['snowflake_id'];
$Snowflake = new Snowflake();
$out_refund_no = $Snowflake->next();
$params['out_refund_no'] = (string)$out_refund_no;
$params['refund'] = $orderInfo['pay_total'];
$params['total'] = $orderInfo['pay_total'];
$params['reason'] = '用户退款';
$res = $Payment->refund($params);
if (!$res) return json_send(['code'=>'error','msg'=>'退款失败']);
//修改订单状态
$res = $Model->query()->where('snowflake_id','=',$orderInfo['snowflake_id'])->update(['out_refund_no'=>$out_refund_no,'status'=>5]);
// 记录行为
$this->addAdminHistory(admin('uid'),$Model->getTable(),$id,1,[],$orderInfo);
//修改订单产品状态
$res = $OrdersProduct->query()->where('order_id','=',$id)->update(['status'=>5]);
return json_send(['code'=>'success','msg'=>'退款成功']);
}
/**
* 表格导入
*
* */
public function import_execl( Request $request,Model $Model,Custom $Custom,OrdersAddr $OrdersAddr,OrdersProduct $OrdersProduct, FilesManager $FilesManager,CustomAddr $CustomAddr){
// 验证参数
$request->scene('import_execl')->validate();
// 获取表格信息
$file = request()->file('order_file');
// 返回结果
$sheetList = $FilesManager->excelToOrder($file);
// 如果不存在结果
if( isset($sheetList['error']) ) return json_send(['code'=>'error','msg'=>$sheetList['error']]);
// 订单列表
$orderList = [];
// 当前时间
$time = time();
// 循环表格数据
foreach ($sheetList as $value) {
// 状态更改
$value['status'] = $Model->getWeibanStatus($value['status']);
// 客户手机号
$orderList[$value['weizan_orderid']]['custom'] = ['phone'=>$value['contact_phone'],'username'=>$value['buyer_nick']];
// 组合成订单的收件地址
$orderList[$value['weizan_orderid']]['contact'] = [
'contact_name'=>$value['contact_name'],
'contact_phone'=>$value['contact_phone'],
'contact_province'=>$value['contact_province'],
'contact_city'=>$value['contact_city'],
'contact_area'=>$value['contact_area'],
'contact_addr'=>$value['contact_addr']
];
// 组合成订单的收件地址
$orderList[$value['weizan_orderid']]['product'][] = [
'status'=>$value['status'],
'product_name'=>$value['product_name'],
'sku_attr_names'=>$value['sku_attr_names'],
'buy_num'=>$value['buy_num'],
'pay_total'=>$value['pay_total'],
'price_total'=>$value['pay_total'],
'insert_time'=>$value['insert_time'],
'update_time'=>$time,
];
// 组合成订单的需要的数据
if( !isset($orderList[$value['weizan_orderid']]['order']) ) $orderList[$value['weizan_orderid']]['order'] = ['weizan_orderid'=>$value['weizan_orderid'],'status'=>$value['status'],'pay_total'=>0,'price_total'=>0,'insert_time'=>$value['insert_time']];
// 价格
$orderList[$value['weizan_orderid']]['order']['pay_total'] = $orderList[$value['weizan_orderid']]['order']['pay_total'] + $value['pay_total'];
$orderList[$value['weizan_orderid']]['order']['price_total'] = $orderList[$value['weizan_orderid']]['order']['pay_total'];
}
// 新增地址
$newAddrList = [];
// 要更新的订单子表
$orderProduct = [];
// 循环订单列表
foreach ($orderList as $value) {
// 获取手机号,查询是否用客户
$custom = $Custom->getOneByPhone($value['custom']['phone']);
// 如果存在手机号
$uid = $custom ? $custom['uid'] : $Custom->add($value['custom']);
// 如果客户存在
if( !$uid ) return json_send(['code'=>'error','msg'=>$value['custom']['username'].'【'.$value['custom']['phone'].'】'.'无法创建用户']);
// 通过订单号查询是否存在系统订单
$orderId = $Model->query()->where([['weizan_orderid','=',$value['order']['weizan_orderid']]])->value('id');
// 客户ID
$value['order']['custom_uid'] = $uid;
// 存在订单获取订单ID,不存在则新增
$orderId = $orderId ? $Model->edit($orderId,$value['order']) : $Model->add($value['order']);
// 如果客户存在
if( !$orderId ) return json_send(['code'=>'error','msg'=>$orderId.'订单写入失败']);
// 联系地址
$contact = $value['contact'];
// 存在详细地址,才创建地址库
if( $contact['contact_name'] && $contact['contact_phone'] && $contact['contact_province'] && $contact['contact_city'] && $contact['contact_area'] && $contact['contact_addr'] ) {
// 收件地址是否存在
$oldAddr = $CustomAddr->query()->where([['custom_uid','=',$uid]])->first();
// 如果不存在地址
if( !$oldAddr ) $CustomAddr->add(['custom_uid'=>$uid,'contact_name'=>$contact['contact_name'],'contact_phone'=>$contact['contact_phone'],'contact_province'=>$contact['contact_province'],'contact_city'=>$contact['contact_city'],'contact_area'=>$contact['contact_area'],'contact_addr'=>$contact['contact_addr']]);
}
// 订单地址库
$addrId = $OrdersAddr->query()->where([['order_id','=',$orderId]])->value('id');
// 订单ID
$value['contact']['order_id'] = $orderId;
// 订单地址ID
$value['contact']['id'] = (int)$addrId;
// 不存在地址的话
$newAddrList[] = $value['contact'];
// 循环子订单
foreach ( $value['product'] as $product ) {
// 数据结果
$product['order_id'] = $orderId;
$product['custom_uid'] = $uid;
$product['id'] = (int) $OrdersProduct->query()->where([['order_id','=',$orderId],'product_name'=>$product['product_name'],'sku_attr_names'=>$product['sku_attr_names']])->value('id');
$orderProduct[] = $product;
}
}
// 新地址写入
$OrdersProduct->query()->upsert($orderProduct,'id',['product_name','sku_attr_names','buy_num','pay_total','price_total','update_time']);
// 新地址写入
$OrdersAddr->query()->upsert($newAddrList,'id',['contact_name','contact_phone','contact_province','contact_city','contact_area','contact_addr']);
// 提示成功
return json_send(['code'=>'success','msg'=>'订单导入成功','path'=>'']);
}
/**
* 批量修改状态
*
* */
public function import_execl_status( Request $request,Model $Model,OrdersProduct $OrdersProduct,FilesManager $FilesManager){
// 验证参数
$request->scene('import_execl_status')->validate();
// 获取表格信息
$file = request()->file('order_file');
// 返回结果
$sheetList = $FilesManager->excelToOrderStatus($file);
// 如果不存在结果
if( isset($sheetList['error']) ) return json_send(['code'=>'error','msg'=>$sheetList['error']]);
// 循环表格数据
foreach ($sheetList as $key=>$value) {
// 客户ID
$orderId = $Model->codeToId($value['order_code']);
// 如果客户ID有误
if( !$orderId ) return json_send(['code'=>'error','msg'=>$value['order_code'].'编码有误']);
// 订单状态
$status = $Model->getWeibanStatus($value['status']);
// 状态提示
if( $status < 0 ) return json_send(['code'=>'error','msg'=>$value['order_code'].'状态有误']);
// 修改数据
$result = $Model->setOrderStatus($orderId,$status,$OrdersProduct);
// 提示
if( isset($result['error']) ) return json_send(['code'=>'error','msg'=>$value['order_code'].$result['error']]);
}
// 提示成功
return json_send(['code'=>'success','msg'=>'订单导入成功','path'=>'']);
}
/**
* 导出表格导入
*
* */
public function down_excel(Model $Model,OrdersProduct $OrdersProduct,Product $Product,Custom $Custom){
// 接受参数
$code = request('order_code','');
$productCode = request('product_code','');
$snowflakeId = request('snowflake_id',0);
$orders_other = request('orders_other',0);
$customCode = request('custom_code','');
$productName = request('product_name','');
$phone = request('phone','');
$contact_area = request('contact_area','');
$contact_school = request('contact_school','');
$contact_grade = request('contact_grade','');
$contact_class = request('contact_class','');
$status = request('status',0);
$startTime = request('start_time','');
$endTime = request('end_time','');
// 编码转ID
$id = $code ? $Model->codeToId($code) : 0;
$productId = $productCode ? $Product->codeToId($productCode) : 0;
$uid = $customCode ? $Custom->codeToId($customCode) : 0;
// 查询条件
$map = [];
// 编码ID
if( $id ) $map[] = ['orders_product.order_id','=',$id];
if( $snowflakeId ) $map[] = ['orders.snowflake_id','=',$snowflakeId];
if( $uid ) $map[] = ['custom.uid','=',$uid];
// 编码ID
if( $orders_other ) $map[] = $orders_other == 1 ? ['orders_product.product_id','>',0] : ['orders_product.product_id','=',0];
if( $productId ) $map[] = ['orders_product.product_id','=',$productId];
if( $productName ) $map[] = ['orders_product.product_name','=',$productName];
if( $phone ) $map[] = ['orders_addr.contact_phone','=',$phone];
if( $contact_area ) $map[] = ['orders_addr.contact_area','LIKE','%'.$contact_area.'%'];
if( $contact_school ) $map[] = ['orders_addr.contact_school','LIKE','%'.$contact_school.'%'];
if( $contact_grade ) $map[] = ['orders_addr.contact_grade','LIKE','%'.$contact_grade.'%'];
if( $contact_class ) $map[] = ['orders_addr.contact_class','LIKE','%'.$contact_class.'%'];
if( $startTime ) $map[] = ['orders_product.insert_time','>=',strtotime($startTime)];
if( $endTime ) $map[] = ['orders_product.insert_time','<=',strtotime($endTime)];
if( $status ) $map[] = ['orders_product.status','=',$status];
// 查询数据
$data = $OrdersProduct->query()
->join('custom','orders_product.custom_uid','=','custom.uid')
->join('orders','orders.id','=','orders_product.order_id')
->join('orders_addr','orders_addr.order_id','=','orders_product.order_id')
->where($map)
->orderByDesc('orders_product.id')
->select([
'orders_product.id as id',
'orders.snowflake_id',
'orders_product.order_id',
'orders_product.product_id',
'orders_product.product_name',
'orders_product.sku_attr_names as product_spec',
'orders_product.product_thumb',
'orders_product.buy_num',
'orders_product.price_total',
'orders_product.coupon_total',
'orders_product.pay_total',
'orders_product.status',
'orders_addr.contact_area',
'orders_addr.contact_school',
'orders_addr.contact_grade',
'orders_addr.contact_class',
'orders_addr.contact_name',
'orders_addr.contact_phone',
'custom.uid as custom_uid',
'custom.username as custom_name',
'custom.external_userid as external_userid',
'orders_product.insert_time',
])->get()->toArray();
// 循环处理数据
foreach ($data as $key => $value) {
// id转编号
$value['status'] = $Model->getState($value['status'],'state');
$value['custom_uid'] = $Custom->idToCode($value['custom_uid']);
$value['product_id'] = $value['product_id'] ? $Product->idToCode($value['product_id']) : '— —';
$value['product_price'] = $value['buy_num'] ? ($value['price_total'] / $value['buy_num']) : $value['buy_num'];
$value['pay_price'] = $value['buy_num'] ? ($value['pay_total'] / $value['buy_num']) : $value['buy_num'];
// 重组
$data[$key] = [
'order_id' => $Model->idToCode($value['order_id']),
'snowflake_id' => (string)$value['snowflake_id'],
'status' => $value['status'],
'contact_area' => $value['contact_area'],
'contact_school' => $value['contact_school'],
'contact_grade' => $value['contact_grade'],
'contact_class' => $value['contact_class'],
'contact_name' => $value['contact_name'],
'contact_phone' => $value['contact_phone'],
'product_id' => $value['product_id'],
'product_name' => $value['product_name'],
'product_spec' => $value['product_spec'],
'product_price' => $value['product_price'],
'pay_price' => $value['pay_price'],
'buy_num' => $value['buy_num'],
'coupon_total' => $value['coupon_total'],
'pay_total' => $value['pay_total'],
'custom_uid' => $value['custom_uid'],
'custom_name' => $value['custom_name'],
'external_userid' => $value['external_userid'],
'insert_time' => date('Y-m-d H:i:s',$value['insert_time']),
];
}
try {
// 去下载
$this->toDown($data);
} catch (\Throwable $th) {
echo $th->getMessage();
}
}
/**
* 去下载
*/
private function toDown($data){
try {
$config = [
'path' =>public_path().'/uploads/' // xlsx文件保存路径
];
$excel = new \Vtiful\Kernel\Excel($config);
$header = [
'订单ID',
'订单编号',
'订单状态',
'区域',
'学校',
'年级',
'班级',
'学生姓名',
'收货手机',
'产品编码',
'产品名称',
'产品规格',
'产品单价',
'折后单价',
'产品数量',
'优惠金额',
'产品金额',
'客户ID',
'客户昵称',
'企微ID',
'下单时间',
];
$filePath = $excel->fileName(uniqid().'.xlsx', 'sheet1')
->header($header)
->data($data)
->output();
$filename = '订单下载'.date('Y-m-d His').'.xlsx';
header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
header('Content-Disposition: attachment;filename="' . $filename . '"');
header('Content-Length: ' . filesize($filePath));
header('Content-Transfer-Encoding: binary');
header('Cache-Control: must-revalidate');
header('Cache-Control: max-age=0');
header('Pragma: public');
ob_clean();
flush();
if (copy($filePath, 'php://output') === false) {
dd('下载出错');
}
@unlink($filePath);
exit();
}catch (\Throwable $th) {
return $th->getMessage();
}
}
/**
* 分享图片
*
*/
private function getShareImage($shopName,$score=0){
// 尝试执行
try {
// 加载图片
$image = Image::make(public_path('uploads/images/default/').'order_receipt_share.jpg');
// 加载图片
$qrcode = Image::make(public_path('uploads/images/default/').'mp_qrcode.jpg')->resize(100,100);
// 设置文字样式(字体、大小、颜色等)
$fontPath = public_path().'/fonts/msyh14.ttf';// 指定字体文件路径
// 文本
$score = $score ? '即将获得'.$score.'积分' : '';
// 给图片写入文字
$image->text('恭喜 '.$shopName, 240,60,function (Font $font) use ($fontPath) {
$font->file($fontPath); // 字体文件地址
$font->size(24); // 字体大小
$font->color('#FFFFFF');
$font->align('center');
});
// 给图片写入文字
$image->text('完成了一笔订单', 240,100,function (Font $font) use ($fontPath) {
$font->file($fontPath); // 字体文件地址
$font->size(24); // 字体大小
$font->color('#FFFFFF');
$font->align('center');
});
// 是否有积分
if( $score ){
// 给图片写入文字
$image->text($score, 240,140,function (Font $font) use ($fontPath) {
$font->file($fontPath); // 字体文件地址
$font->size(24); // 字体大小
$font->color('#FFFFFF');
$font->align('center');
});
}
// 给图片写入文字
$image->text('你也来试试吧', 240,$score?180:140,function (Font $font) use ($fontPath) {
$font->file($fontPath); // 字体文件地址
$font->size(24); // 字体大小
$font->color('#FFFFFF');
$font->align('center');
});
// 插入图片
$image->insert($qrcode,'bottom-right',10,10);
// 转码成字符串
$image = $image->encode('jpg', 90)->__toString();
// 转base64
$base64 = 'data:image/jpg;base64,' . base64_encode($image);
return $base64;
} catch (\Throwable $th) {
// 返回路径
return '';
}
}
/**
* 设置订单地址
*/
public function set_addr(Request $request,OrdersAddr $OrdersAddr,School $School){
// 接收参数
$orderId = request('order_id','');
// 获取数据
$oldData = $OrdersAddr->getOneByOrderId($orderId);
// 修改
if( request()->isMethod('post') ){
// 验证参数
$request->scene('set_addr')->validate();
// 接收数据
$data['contact_area'] = request('contact_area','');
$data['contact_school'] = request('contact_school','');
$data['contact_grade'] = request('contact_grade','');
$data['contact_class'] = request('contact_class','');
$data['contact_name'] = request('contact_name','');
$data['contact_phone'] = request('contact_phone','');
// 写入数据表
$id = $OrdersAddr->edit($orderId,$data);
// 如果操作失败
if( !$id ) return json_send(['code'=>'error','msg'=>'编辑失败']);
// 告知结果
return json_send(['code'=>'success','msg'=>'编辑成功','action'=>'edit']);
}
// 获取地址
$areaList = $School->getAreaList();
// 年级
$gradeList = $School->getGradeList();
// 班级
$classList = $School->getClassList();
// 学校
$schoolList = $School->query()->where([['area','=',request('contact_area',$oldData['contact_area'])]])->get(['id','name'])->toArray();
// 分配数据
$this->assign('oldData',$oldData);
$this->assign('areaList',$areaList);
$this->assign('gradeList',$gradeList);
$this->assign('classList',$classList);
$this->assign('schoolList',$schoolList);
$this->assign('crumbs','修改地址');
// 加载模板
return $this->fetch();
}
/**
* 设置订单地址
*/
public function get_school(OrdersAddr $OrdersAddr,School $School){
// 接收参数
$orderId = request('order_id',0);
// 获取数据
$oldData = $OrdersAddr->getOneByOrderId($orderId);
// 接收参数
$contactArea = request('contact_area','');
// 学校
$schoolList = $School->query()->where([['area','=',$contactArea]])->get(['id','name'])->toArray();
// 分配数据
$this->assign('oldData',$oldData);
$this->assign('schoolList',$schoolList);
// 加载模板
return $this->fetch();
}
}