query($sql_over);
foreach($list_over as $pin_over)
{
M('pin')->where( array('pin_id' => $pin_over['pin_id']) )->save( array('end_time' => time()) );
}
//begin_time
$pin_goods = M('pin_goods')->where( array('goods_id' => $goods_id) )->find();
$begin_time = $pin_goods['begin_time'];
M('pin_goods')->where( array('goods_id' => $goods_id) )->save( array('end_time' => time()) );
$sql = "select p.pin_id from ".C('DB_PREFIX')."pin as p,".C('DB_PREFIX')."pin_order as po,
".C('DB_PREFIX')."order as o,".C('DB_PREFIX')."order_goods as og
where p.state = 1 and p.pin_id = po.pin_id and po.order_id = o.order_id
and o.order_id = og.order_id and og.goods_id and og.goods_id = {$goods_id} and p.begin_time >= {$begin_time}
order by p.pin_id asc ";
$list=M()->query($sql);
//begin_time
foreach($list as $pin)
{
M('pin')->where( array('pin_id' => $pin['pin_id']) )->save( array('lottery_state' => 1) );
}
$lottery_goods = M('lottery_goods')->where( array('goods_id' => $goods_id) )->find();
if($is_auto_open_lottery) {
//自动开奖
$real_win_quantity = $lottery_goods['real_win_quantity'];
$win_quantity = $lottery_goods['win_quantity'];
$auto_jia_order = $win_quantity - $real_win_quantity;
if($real_win_quantity > 0)
{
$sql = "select o.order_id from ".C('DB_PREFIX')."order as o,".C('DB_PREFIX')."order_goods as og
where o.order_id = og.order_id and og.goods_id and o.order_status_id =1 and o.date_added >{$begin_time} and og.goods_id = {$goods_id}
group by o.member_id order by o.order_id desc limit {$win_quantity}";
$list=M()->query($sql);
if(!empty($list)) {
//有订单
$oids_arr = array();
foreach($list as $val)
{
$oids_arr[] = $val['order_id'];
}
$oids_count = count($oids_arr);
if($oids_count < $real_win_quantity)
{
$real_win_quantity = $oids_count;//实际取出的数量=订单数量
$auto_jia_order = $win_quantity - $real_win_quantity;//如果数据库中订单数量小于真实中奖人数
}
shuffle($oids_arr);
$need_order_ids_arr = array_rand($oids_arr, $real_win_quantity);
$need_order_arr = array();//随机出需要的订单id
if($real_win_quantity == 1) {
$need_order_arr[] = $oids_arr[$need_order_ids_arr];
} else {
foreach($need_order_ids_arr as $vv)
{
$need_order_arr[] = $oids_arr[$vv];
}
}
M('order')->where( array('order_id' => array('in', $need_order_arr )) )->save( array('lottery_win' => 1) );
if($auto_jia_order > 0)
{
//作假人数大于0,那么就开假奖
$this->open_jia_lottery($goods_id,$auto_jia_order);
}
}else {
//没有订单,全假开奖
$this->open_jia_lottery($goods_id,$win_quantity);
}
} else {
//全假开奖
$this->open_jia_lottery($goods_id,$win_quantity);
}
} else {
//手动开奖
$win_quantity = $lottery_goods['win_quantity'];
$ids_arr = explode(',',$oids);
if(!empty($ids_arr) && !empty($oids)) {
M('order')->where( array('order_id' => array('in',$oids)) )->save( array('lottery_win' => 1) );
$auto_jia_order = $win_quantity - count($ids_arr);
}else {
$auto_jia_order = $win_quantity;
}
if($auto_jia_order > 0) //作假人数大于0,那么就开假奖
$this->open_jia_lottery($goods_id,$auto_jia_order);
}
M('lottery_goods')->where( array('goods_id' => $goods_id) )->save( array('is_open_lottery' => 1) );
}
/**
* 开假奖励
* @param unknown $goods_id
*/
function open_jia_lottery($goods_id,$need_count)
{
$sql = "select * from ".C('DB_PREFIX')."jiauser order by Rand() desc limit {$need_count}";
$list=M()->query($sql);
$order_no = build_order_no($goods_id);
$mobile_arr = array('31','58','51','52','80','55','32','82','35');
foreach($list as $key => $val)
{
//build_order_no
$order_no = substr($order_no, 0, strlen($order_no) -4).mt_rand(0,9).mt_rand(1,8).mt_rand(0,9).mt_rand(0,9);
$val['order_no'] = $order_no;
if(empty($val['mobile'])) {
$val['mobile'] = '1'.$mobile_arr[array_rand($mobile_arr)].'*****'.mt_rand(0, 9).mt_rand(0, 9).mt_rand(0, 9);
} else {
$val['mobile'] = substr($val['mobile'],0,3).'*****'.substr($val['mobile'],-3,3);
}
$data = array();
$data['goods_id'] = $goods_id;
$data['avatar'] = $val['avatar'];
$data['uname'] = $val['username'];
$data['order_sn'] = $val['order_no'];
$data['mobile'] = $val['mobile'];
$data['addtime'] = time();
M('jiaorder')->add($data);
}
}
function get_all_address($uid){
$list=M('address')->where(array('member_id'=>$uid))->order('address_id desc ')->select();
$hashids = new \Lib\Hashids(C('PWD_KEY'), C('URL_ID'));
if(!empty($list)){
foreach ($list as $k => $v) {
$list[$k]['id']=$v['address_id'];
$list[$k]['address_id']=$hashids->encode($v['address_id']);
}
}
return $list;
}
function order_info($order_id){
//订单信息
$order_sql='select t.title,o.* from '.C('DB_PREFIX').'order o,'.C('DB_PREFIX').'transport t where o.shipping_method=t.id and o.order_id='.$order_id;
$order=M()->query($order_sql);
//收货地址
$address=M('Address')->find($order[0]['address_id']);
//商品详情
$goods=M('OrderGoods')->where(array('order_id'=>$order_id))->select();
//商品选项
//$option=M('OrderOption')->where(array('order_id'=>$order_id))->select();
//总计
$total=M('OrderTotal')->where(array('order_id'=>$order_id))->select();
//订单历史
$history=M('OrderHistory')->where(array('order_id'=>$order_id))->select();
return array(
'order'=>$order,
'address'=>$address,
//'option'=>$option,
'goods'=>$goods,
'total'=>$total,
'history'=>$history
);
}
function show_order_page($member_id){
$count=M('order')->where(array('member_id'=>$member_id))->count();
$Page = new \Think\Page($count,C('FRONT_PAGE_NUM'));
$show = $Page->show();// 分页显示输出
$show=str_replace("/user/order/p/","/order/", $show);
$sql='SELECT o.order_num_alias as alias,o.order_id,o.name,o.date_added,o.total,os.name as status FROM '.C('DB_PREFIX').'order o,'.C('DB_PREFIX')
."order_status os where o.order_status_id=os.order_status_id and o.member_id=".$member_id.' order by o.order_id desc LIMIT '.$Page->firstRow.','.$Page->listRows;
$list=M()->query($sql);
$hashids = new \Lib\Hashids(C('PWD_KEY'), C('URL_ID'));
if(!empty($list)){
foreach ($list as $k => $v) {
$list[$k]['order_id']=$hashids->encode($v['order_id']);
}
}
return array(
'empty'=>'
~~暂无数据 |
',
'list'=>$list,
'page'=>$show
);
}
function addOrder($data) {
$integral_model = D('Seller/Integral');
$order = array();
$order['member_id']=$data['member_id'];
$order['order_num_alias']=$data['order_num_alias'];
$order['name']=$data['name'];
if( isset($data['from_type']) )
{
$order['from_type']=$data['from_type'];
}
if($data['delivery'] == 'pickup')
{
$order['telephone']=$data['ziti_mobile'];
$order['shipping_name']=$data['ziti_name'];
}else{
$order['telephone']=$data['telephone'];
$order['shipping_name']=$data['shipping_name'];
}
$order['type']=$data['type'];
$order['shipping_address']=$data['shipping_address'];
$order['shipping_city_id']=$data['shipping_city_id'];
$order['shipping_country_id']=$data['shipping_country_id'];
$order['shipping_province_id']=$data['shipping_province_id'];
$order['shipping_tel']=$data['shipping_tel'];
$order['order_status_id']=C('default_order_status_id');
$order['voucher_id']=$data['voucher_id'];
$order['voucher_credit']=$data['voucher_credit'];
$order['ip']=get_client_ip();
$order['shipping_fare'] = $data['shipping_fare'];
$order['ip_region'] = '';
if($data['total'] <0)
{
$data['total'] = 0;
}
$order['date_added'] =time();
$order['total'] =$data['total'];
$order['user_agent']=$data['user_agent'];
$order['shipping_method']=0;//快递id
$order['delivery']=$data['delivery'];
//$data['delivery']
$order['payment_code']=$data['payment_method'];
$order['address_id']=$data['address_id'];
$order['comment']=$data['comment'];
$order['store_id'] = $data['store_id'];
$order_id=M('Order')->add($order);
//Model $data['member_id']
$goods_model = D('Home/Goods');
$member_info = M('member')->where( array('member_id' => $data['member_id']) )->find();
$is_pin = 0;
$pin_id = 0;
$hashids = new \Lib\Hashids(C('PWD_KEY'), C('URL_ID'));
$share_model = D('Seller/Fissionsharing');
$kucun_method = C('kucun_method');
$kucun_method = empty($kucun_method) ? 0 : intval($kucun_method);
$free_tuan = 0;
if(isset($data['goodss'])){
foreach ($data['goodss'] as $goods) {
//$goods_id=$hashids->decode($goods['goods_id']);
$goods_id = $goods['goods_id'];
$pin_id = $goods['pin_id'];
$commiss_one_money = 0;
$goods_info = M('goods')->field('points,commiss_fen_one_disc,commiss_fen_two_disc,commiss_fen_three_disc,commiss_three_dan_disc,commiss_two_dan_disc,commiss_one_dan_disc,store_id,type,model,image')->where( array('goods_id' => $goods_id) )->find();
//points buy_send_score type
if( !empty($goods_info['points']) && $goods_info['points'] > 0 && $goods_info['type'] != 'integral')
{
//$goods['quantity']
//integral_model
$score = $goods_info['points'] * $goods['quantity'];
$integral_model->charge_member_score( $data['member_id'] , $score,'in', 'goodsbuy', $order_id);
}else if( C('buy_send_score') > 0 && $goods_info['type'] != 'integral')
{
$score = C('buy_send_score') * $goods['quantity'];
$integral_model->charge_member_score( $data['member_id'] , $score,'in', 'goodsbuy', $order_id);
}
//'is_pin' => $is_pin,
$is_pin = $goods['is_pin'];
//判断是否拼团开始
$commiss_one_money = 0;
$commiss_two_money = 0;
$commiss_three_money = 0;
$commiss_fen_one_money = 0;
$commiss_fen_two_money = 0;
$commiss_fen_three_money = 0;
//= 1
if($is_pin == 1)
{
$pin_goods = M('pin_goods')->field('commiss_one_pin_disc,commiss_two_pin_disc,commiss_three_pin_disc')->where( array('goods_id' => $goods_id) )->find();
//$goods['total']
if(C('opencommiss') == 1)
{
if(C('commiss_level_num') >= 1)
{
$commiss_one_money = round( ($pin_goods['commiss_one_pin_disc'] * $goods['total'])/100 , 2);
}
if(C('commiss_level_num') >= 2)
{
$commiss_two_money = round( ($pin_goods['commiss_two_pin_disc'] * $goods['total'])/100 , 2);
}
if(C('commiss_level_num') >= 3)
{
$commiss_three_money = round( ($pin_goods['commiss_three_pin_disc'] * $goods['total'])/100 , 2);
}
}
if(C('is_open_fissionsharing') == 1)
{
if(C('fissionsharing_level') >= 1)
{
$commiss_fen_one_money = round( ($goods_info['commiss_fen_one_disc'] * $goods['total'])/100 , 2);
}
if(C('fissionsharing_level') >= 2)
{
$commiss_fen_two_money = round( ($goods_info['commiss_fen_two_disc'] * $goods['total'])/100 , 2);
}
if(C('fissionsharing_level') >= 3)
{
$commiss_fen_three_money = round( ($goods_info['commiss_fen_three_disc'] * $goods['total'])/100 , 2);
}
}
$goods_info['type'] = 'pintuan';
$pin_model = D('Home/Pin');
$pin_id = $pin_model->checkPinState($goods['pin_id']);
//addOrder
$is_pin_over = $pin_model->getNowPinState($goods['pin_id']);
if($is_pin_over == 1 || $is_pin_over == 2)
{
$pin_id = 0;
}
if($pin_id ==0) {
//新开团
$pin_id = $pin_model->openNewTuan($order_id,$goods_id,$data['member_id']);
$is_new_tuan = true;
}
//插入拼团订单
$pin_model->insertTuanOrder($pin_id,$order_id);
}else{
if(C('opencommiss') == 1)
{
if(C('commiss_level_num') >= 1)
{
$commiss_one_money = round( ($goods_info['commiss_one_dan_disc'] * $goods['total'])/100 , 2);
}
if(C('commiss_level_num') >= 2)
{
$commiss_two_money = round( ($goods_info['commiss_two_dan_disc'] * $goods['total'])/100 , 2);
}
if(C('commiss_level_num') >= 3)
{
$commiss_three_money = round( ($goods_info['commiss_three_dan_disc'] * $goods['total'])/100 , 2);
}
}
if(C('is_open_fissionsharing') == 1)
{
if(C('fissionsharing_level') >= 1)
{
$commiss_fen_one_money = round( ($goods_info['commiss_fen_one_disc'] * $goods['total'])/100 , 2);
}
if(C('fissionsharing_level') >= 2)
{
$commiss_fen_two_money = round( ($goods_info['commiss_fen_two_disc'] * $goods['total'])/100 , 2);
}
if(C('fissionsharing_level') >= 3)
{
$commiss_fen_three_money = round( ($goods_info['commiss_fen_three_disc'] * $goods['total'])/100 , 2);
}
}
}
//var_dump($goods_info,$goods['total']);die();
$goods['member_disc'] = isset($goods['member_disc']) ? $goods['member_disc'] : 100;
//判断是否拼团结束
$type = ($is_pin == 1) ? 'pintuan': 'normal';
//header_disc
$this->execute("INSERT INTO ".C('DB_PREFIX')."order_goods SET order_id = '" .$order_id
."',goods_id='".$goods_id."'"
.",store_id='".$goods_info['store_id']."'"
.",name='".addslashes($goods['name'])."'"
.",model='".$goods['model']."'"
.",commiss_one_money='".$commiss_one_money."'"
.",commiss_two_money='".$commiss_two_money."'"
.",commiss_three_money='".$commiss_three_money."'"
.",commiss_fen_one_money='".$commiss_fen_one_money."'"
.",commiss_fen_two_money='".$commiss_fen_two_money."'"
.",commiss_fen_three_money='".$commiss_fen_three_money."'"
.",head_disc='".$goods['header_disc']."'"
.",member_disc='".$goods['member_disc']."'"
.",level_name='".$goods['level_name']."'"
.",is_pin='".$is_pin."'"
.",goods_images='".$goods_info['image']."'"
.",goods_type='".$type."'"
.",shipping_fare='".$goods['shipping_fare']."'"
.",quantity='".(int)$goods['quantity']."'"
.",price='".(float)$goods['price']."'"
.",rela_goodsoption_valueid='".$goods['option']."'"
.",comment='".$goods['comment']."'"
.",total='".(float)$goods['total']."'"
);
$order_goods_id=$this->getLastInsID();
//检测是否需要将订单放入分佣里面
if(C('is_open_fissionsharing') == 1)
{
$share_model->add_sharing_order($order_id,$goods_id,$order_goods_id,$data['member_id'],$goods_info['store_id'] );
}
if(!empty($goods['option']))
{
$options_arr = array();
$option_value_id_arr = explode('_',$goods['option']);
foreach($option_value_id_arr as $id_val)
{
$goods_option_value = M('goods_option_value')->where( array('option_value_id' => $id_val,'goods_id' =>$goods_id) )->find();
$options_arr[$goods_option_value['goods_option_id']] = $goods_option_value['goods_option_value_id'];
$goods_option = M('goods_option')->where( array('goods_option_id' =>$goods_option_value['goods_option_id']) )->find();
$option_value = M('option_value')->where( array('option_value_id' =>$goods_option_value['option_value_id']) )->find();
$this->execute("INSERT INTO ".C('DB_PREFIX')."order_option SET order_id = '" .$order_id
."',order_goods_id='".$order_goods_id."'"
.",goods_option_id='".(int)$goods_option_value['goods_option_id']."'"
.",goods_option_value_id='".(int)$goods_option_value['goods_option_value_id']."'"
.",name='".$goods_option['option_name']."'"
.",value='".$option_value['value_name']."'"
);
}
}
if($kucun_method == 0)
{
$goods_model->del_goods_mult_option_quantity($order_id,$goods['option'],$goods_id,$goods['quantity'],1);
}
}
}
//type normal pintuan is_pin
$order_type = $is_pin == 1 ? 'pintuan': 'normal';
M('order')->where( array('order_id' => $order_id) )->save( array('is_pin' => $is_pin, 'order_type' =>$order_type) );
if(isset($data['totals'])){
foreach ($data['totals'] as $total) {
$this->execute("INSERT INTO ".C('DB_PREFIX')."order_total SET order_id = '" .$order_id
."',code='".$total['code']."'"
.",title='".$total['title']."'"
.",text='".$total['text']."'"
.",value='".(float)$total['value']."'");
}
}
$oh = array();
$oh['order_id']=$order_id;
$oh['order_status_id']=C('default_order_status_id');
$oh['comment']='创建订单';
$oh['date_added']=time();
$oh_id=M('OrderHistory')->add($oh);
//storage_user_action(session('user_auth.uid'),session('user_auth.username'),C('FRONTEND_USER'),'下了订单 '.$data['order_num_alias'].' 未支付');
return $order_id;
}
function addOrder2($data) {
$order['member_id']=$data['member_id'];
$order['order_num_alias']=$data['order_num_alias'];
$order['name']=$data['name'];
$order['email']=$data['email'];
$order['telephone']=$data['telephone'];
$order['shipping_name']=$data['shipping_name'];
$order['shipping_address']=$data['shipping_address'];
$order['shipping_city_id']=$data['shipping_city_id'];
$order['shipping_country_id']=$data['shipping_country_id'];
$order['shipping_province_id']=$data['shipping_province_id'];
$order['shipping_tel']=$data['shipping_tel'];
$order['comment']=$data['comment'];
$order['order_status_id']=C('default_order_status_id');
$order['ip']=get_client_ip();
$order['voucher_id']=$data['voucher_id'];
$order['voucher_credit']=$data['voucher_credit'];
$order['shipping_fare'] = $data['shipping_fare'];
$order['ip_region'] = '';
if($data['total'] <0)
{
$data['total'] = 0;
}
$order['date_added'] =time();
$order['total'] =$data['total'];
$order['user_agent']=$data['user_agent'];
$order['shipping_method']=$data['shipping_method'];
$order['delivery']=$data['delivery'];
$order['payment_code']=$data['payment_method'];
$order['address_id']=$data['address_id'];
$order_id=M('Order')->add($order);
//Model $data['member_id']
$goods_model = D('Home/Goods');
$member_info = M('member')->where( array('member_id' => $data['member_id']) )->find();
$is_pin = 0;
$pin_id = 0;
$hashids = new \Lib\Hashids(C('PWD_KEY'), C('URL_ID'));
$kucun_method = C('kucun_method');
$kucun_method = empty($kucun_method) ? 0 : intval($kucun_method);
$free_tuan = 0;
if(isset($data['goodss'])){
foreach ($data['goodss'] as $goods) {
$goods_id=$hashids->decode($goods['goods_id']);
$pin_id = $goods['pin_id'];
$commiss_one_money = 0;
$goods_info = M('goods')->field('type,is_free_in,commiss_one_money,commiss_one_pin_disc,commiss_one_dan_disc,pinprice,danprice')->where( array('goods_id' => $goods_id[0]) )->find();
$is_new_tuan = false;
if($goods['pin_type'] == 'pin'){
$is_pin = 1;
$pin_model = D('Home/Pin');
$pin_id = $pin_model->checkPinState($goods['pin_id']);
if($pin_id ==0) {
//新开团
$pin_id = $pin_model->openNewTuan($order_id,$goods_id,$data['member_id']);
$is_new_tuan = true;
}
//插入拼团订单
$pin_model->insertTuanOrder($pin_id,$order_id);
//is_header_disc 记录团长折扣 header_disc commiss_one_money
$commiss_one_money = round( ($goods_info['pinprice'] * $goods_info['commiss_one_pin_disc'])/100,2);
} else {
$commiss_one_money = round( ($goods_info['danprice'] * $goods_info['commiss_one_dan_disc'])/100,2);
}
if($is_new_tuan && $goods_info['is_free_in'] == 1)
{
//团长可以免单开团,需要判断是否拥有免单券
//$data['member_id']
$voucher_free_info = M('voucher_free')->where( array('user_id' =>$data['member_id'],'state'=>0) )->find();
if(!empty($voucher_free_info))
{
//可以免单开团
M('voucher_free')->where( array('id' =>$voucher_free_info['id']) )->save( array('state' => 1) );
$free_tuan = 1;
}
}
if($free_tuan == 1)
{
$goods['total'] = 0;
}
$this->execute("INSERT INTO ".C('DB_PREFIX')."order_goods SET order_id = '" .$order_id
."',goods_id='".$goods_id[0]."'"
.",store_id='".$goods['store_id']."'"
.",name='".addslashes($goods['name'])."'"
.",model='".$goods['model']."'"
.",is_pin='".$is_pin."'"
.",pin_id='".$pin_id."'"
.",free_tuan='".$free_tuan."'"
.",head_disc='".$goods['header_disc']."'"
.",commiss_one_money='".$commiss_one_money."'"
.",quantity='".(int)$goods['quantity']."'"
.",price='".(float)$goods['price']."'"
.",total='".(float)$goods['total']."'"
);
if($goods_info['type'] =='haitao')
{
$og_haitao_data = array();
$og_haitao_data['order_id'] = $order_id;
$og_haitao_data['real_name'] = $member_info['id_cardreal_name'];
$og_haitao_data['id_card'] = $member_info['id_card'];
$og_haitao_data['add_time'] = time();
M('order_goods_haitao')->add($og_haitao_data);
}
$order_goods_id=$this->getLastInsID();
foreach ($goods['option'] as $option) {
$this->execute("INSERT INTO ".C('DB_PREFIX')."order_option SET order_id = '" .$order_id
."',order_goods_id='".$order_goods_id."'"
.",goods_option_id='".(int)$option['goods_option_id']."'"
.",goods_option_value_id='".(int)$option['goods_option_value_id']."'"
.",name='".$option['name']."'"
.",value='".$option['value']."'"
.",type='".$option['type']."'"
);
}
if($kucun_method == 0)
{
$goods_model->del_goods_mult_option_quantity($order_id,$goods['quantity'],1);
}
}
}
//pintuan
M('order')->where( array('order_id' => $order_id) )->save( array('is_pin' => $is_pin, 'pin_id' =>$pin_id) );
//免单开团
if($free_tuan == 1)
{
M('order')->where( array('order_id' => $order_id) )->save( array('total' => 0) );
}
if(isset($data['totals'])){
foreach ($data['totals'] as $total) {
$this->execute("INSERT INTO ".C('DB_PREFIX')."order_total SET order_id = '" .$order_id
."',code='".$total['code']."'"
.",title='".$total['title']."'"
.",text='".$total['text']."'"
.",value='".(float)$total['value']."'");
}
}
$oh['order_id']=$order_id;
$oh['order_status_id']=C('default_order_status_id');
$oh['comment']=$data['comment'];
$oh['date_added']=time();
$oh_id=M('OrderHistory')->add($oh);
//storage_user_action(session('user_auth.uid'),session('user_auth.username'),C('FRONTEND_USER'),'下了订单 '.$data['order_num_alias'].' 未支付');
return $order_id;
}
/**
* 通用设置订单状态
* 一般拼团成功时使用
*/
function change_order_status($order_id,$order_status_id)
{
//设置订单状态
$this->execute("UPDATE " . C('DB_PREFIX') . "order SET order_status_id = {$order_status_id} where order_id=".$order_id);
}
/**
* 确认收货
* @param unknown $order_id
*/
function receive_order($order_id)
{
//设置订单状态
$this->execute("UPDATE " . C('DB_PREFIX') . "order SET order_status_id = 6 where order_id=".$order_id);
$order_history = array();
$order_history['order_id'] = $order_id;
$order_history['order_status_id'] = 6;
$order_history['notify'] = 0;
$order_history['comment'] = '用户确认收货';
$order_history['date_added']=time();
M('order_history')->add($order_history);
$fenxiao_model = D('Home/Fenxiao');
$fenxiao_model->send_order_commiss_money($order_id);
$share_model = D('Seller/Fissionsharing');
$share_model->send_order_commiss_money_do( $order_id);
$integral_model = D('Seller/Integral');
$integral_model->send_order_score_dr($order_id);
}
function cancel_order($order_id){
//设置订单状态
$this->execute("UPDATE " . C('DB_PREFIX') . "order SET order_status_id = 5 where order_id=".$order_id);
//写人订单历史
$this->execute("INSERT INTO " . C('DB_PREFIX') . 'order_history SET order_status_id = 5,order_id='.$order_id.",comment='用户取消了订单',date_added=".time());
//订单商品
$goods=M('order_goods')->where(array('order_id'=>$order_id))->select();
$goods_model = D('Home/Goods');
$kucun_method = C('kucun_method');
$kucun_method = empty($kucun_method) ? 0 : intval($kucun_method);
if(isset($goods) && $kucun_method == 0 ){
foreach ($goods as $key => $value) {
//$this->execute("UPDATE " . C('DB_PREFIX') . "goods SET quantity = (quantity + " . (int)$value['quantity'] . ") WHERE goods_id = '" . $value['goods_id'] . "' ");
//del_goods_mult_option_quantity($order_id,$option,$goods_id,$quantity,$type='1')
$goods_model->del_goods_mult_option_quantity($order_id,$goods['rela_goodsoption_valueid'],$value['goods_id'],$value['quantity'],2);
//$goods_model->del_goods_mult_option_quantity($order_id,$value['quantity'],2);
//销量回退
//$this->execute("UPDATE " . C('DB_PREFIX') . "goods SET seller_count = (seller_count - " . (int)$value['quantity'] . ") WHERE goods_id = '" . $value['goods_id'] . "' ");
}
}
}
/**
* 订单自动配送操作 同城配送订单预查询运费
* @param unknown $order
*/
public function order_auto_delivery($order){
$presale_result = D('Home/PresaleGoods')->getOrderPresaleInfo( $order['order_id'] );
if( $presale_result['code'] == 0 )
{
//预售订单不自动发货
return false;
}
if($order['delivery'] == 'localtown_delivery'){//同城配送订单
$is_localtown_auto_delivery = D('Home/Front')->get_config_by_name('is_localtown_auto_delivery');
if($is_localtown_auto_delivery == 1){//订单自动确认配送
//同城配送
D('Seller/Order')->do_send_localtown($order['order_id'],'后台自动确认发货,开始配送货物');
}
//同城配送订单预查询运费
$this->third_delivery_query($order);
}else if($order['delivery'] == 'tuanz_send' && $order['type'] != 'pintuan' ){//团长配送订单
$is_communityhead_auto_delivery = D('Home/Front')->get_config_by_name('is_communityhead_auto_delivery');
if($is_communityhead_auto_delivery == 1){//团长订单自动确认配送
D('Seller/Order')->do_send_tuanz($order['order_id'],'后台自动确认发货,开始配送货物');
$is_communityhead_auto_service = D('Home/Front')->get_config_by_name('is_communityhead_auto_service');
if($is_communityhead_auto_service == 1){//团长订单自动确认送达团长
D('Seller/Order')->do_tuanz_over($order['order_id'],'后台自动确认送达团长');
D('Home/Frontorder')->send_order_operate($order['order_id']);
}
}
}else if($order['delivery'] == 'pickup' && $order['type'] != 'pintuan'){//到点自提订单
$is_ziti_auto_delivery = D('Home/Front')->get_config_by_name('is_ziti_auto_delivery');
if($is_ziti_auto_delivery == 1){//到店自提订单自动确认配送
D('Seller/Order')->do_send_tuanz($order['order_id'],'后台自动确认发货,开始配送货物');
$is_ziti_auto_service = D('Home/Front')->get_config_by_name('is_ziti_auto_service');
if($is_ziti_auto_service == 1){//到店自提订单自动确认送达团长
D('Seller/Order')->do_tuanz_over($order['order_id'],'后台自动确认送达团长');
D('Home/Frontorder')->send_order_operate($order['order_id']);
}
}
}
//订单自动推送给第三方配送公司
$this->order_autosend_third_delivery($order);
}
/**
* @author cy 2020-12-29
* @desc 同城配送订单预查询运费
* @param $order_id
*/
public function third_delivery_query($order){
//订单号
$order_id = $order['order_id'];
$is_localtown_imdada_status = D('Home/Front')->get_config_by_name('is_localtown_imdada_status');
$is_imdada_prequery_status = D('Home/Front')->get_config_by_name('is_imdada_prequery_status');
$is_localtown_sf_status = D('Home/Front')->get_config_by_name('is_localtown_sf_status');
$is_sf_prequery_status = D('Home/Front')->get_config_by_name('is_sf_prequery_status');
//是否开启码科配送,
//是否开启预测码科配送 todo
$is_localtown_mk_status = D('Home/Front')->get_config_by_name('is_localtown_mk_status');
$is_make_prequery_status = D('Home/Front')->get_config_by_name('is_make_prequery_status');
$order_info = $order;
//店铺地址
if($order_info['store_id'] > 0) {
$store_data = $this->getOrderStoreAddress($order_info);
$order_info['store_data'] = $store_data;
}
//商品信息
$sql = "select og.goods_id,og.name as goods_name,og.quantity,og.rela_goodsoption_valueid,g.weight as goods_weight from "
. C('DB_PREFIX')."lionfish_comshop_order_goods as og left join ".C('DB_PREFIX')."lionfish_comshop_goods as g on og.goods_id=g.id "
." where og.order_id = ".$order_id;
$goods_list = M()->query($sql);
$goods_count = 0;
$goods_weight = 0;
$goods_type_count = 0;
foreach($goods_list as $k=>$v){
$goods_count = $goods_count + $v['quantity'];
if(!empty($v['rela_goodsoption_valueid'])){
$goods_option_mult_value = M('lionfish_comshop_goods_option_item_value')->where( array('option_item_ids' => $v['rela_goodsoption_valueid'],'goods_id' => $v['goods_id']) )->find();
if(!empty($goods_option_mult_value)){
$v['goods_weight'] = $goods_option_mult_value['weight'];
}
}
$goods_weight = $goods_weight + $v['quantity'] * $v['goods_weight'];
$goods_type_count = $goods_type_count + 1;
}
if(empty($goods_weight)){
$goods_weight = 100;//默认100克
}
$order_info['goods_list'] = $goods_list;
//商品种类
$order_info['goods_type_count'] = $goods_type_count;
//商品数量
$order_info['goods_count'] = $goods_count;
//商品重量
$order_info['goods_weight'] = $goods_weight;
//订单总金额
$order_info['order_total'] = $order_info['total']+$order_info['packing_fare']+$order_info['shipping_fare']-$order_info['voucher_credit']-$order_info['fullreduction_money']-$order_info['score_for_money']+$order_info['localtown_add_shipping_fare']-$order_info['fare_shipping_free'];
//收货人地址
$province_info = D('Home/Front')->get_area_info($order_info['shipping_province_id']);
$city_info = D('Home/Front')->get_area_info($order_info['shipping_city_id']);
$area_info = D('Home/Front')->get_area_info($order_info['shipping_country_id']);
$order_info['shipping_address'] = $province_info['name'].$city_info['name'].$area_info['name'].$order_info['shipping_address'];
//收货人经纬度
$order_distribution_info = M('lionfish_comshop_orderdistribution_order')->where( array('order_id' => $order_id ) )->find();
//收货人地址纬度
$order_info['shipping_lat'] = $order_distribution_info['member_lat'];
//收货人地址经度
$order_info['shipping_lng'] = $order_distribution_info['member_lon'];
//商城名称
$shoname = D('Home/Front')->get_config_by_name('shoname');
$order_info['shoname'] = $shoname;
//达达配送
if($is_localtown_imdada_status == 1 && $is_imdada_prequery_status == 1){
$imdada = new \Lib\Localtown\Imdada();
$result = $imdada->queryDeliverFee($order_info);
$thirth_data = [];
$thirth_data['order_id'] = $order_info['order_id'];
$thirth_data['third_distribution_type'] = "imdada";
if($result['status'] == 1){//成功
$thirth_data['status'] = 1;
//平台订单号
$thirth_data['delivery_no'] = $result['result']['deliveryNo'];
//实际运费(单位:元)
$thirth_data['shipping_fee'] = $result['result']['fee'];
//运费(单位:元)
$thirth_data['shipping_delivery_fee'] = $result['result']['deliverFee'];
//配送距离(单位:米)
$thirth_data['distance'] = $result['result']['distance'];
}else{
$thirth_data['status'] = 0;
//平台订单号
$thirth_data['delivery_no'] = "";
//实际运费(单位:元)
$thirth_data['shipping_fee'] = 0;
//运费(单位:元)
$thirth_data['shipping_delivery_fee'] = 0;
//配送距离(单位:米)
$thirth_data['distance'] = 0;
$thirth_data['message'] = $result['message'];
}
$this->addThirthQuery($thirth_data);
}
//顺丰同城配送
if($is_localtown_sf_status == 1 && $is_sf_prequery_status == 1){
$sfexpress = new \Lib\Localtown\Sfexpress();
$result = $sfexpress->queryDeliverFee($order_info);
$thirth_data = [];
$thirth_data['order_id'] = $order_info['order_id'];
$thirth_data['third_distribution_type'] = "sf";
if($result['status'] == 1){//成功
$thirth_data['status'] = 1;
//平台订单号
$thirth_data['delivery_no'] = "";
//实际运费(单位:元)
$thirth_data['shipping_fee'] = round($result['result']['total_price']/100,2);
//运费(单位:元)
$thirth_data['shipping_delivery_fee'] = round($result['result']['charge_price_list']['shop_pay_price']/100,2);
//配送距离(单位:米)
$thirth_data['distance'] = $result['result']['delivery_distance_meter'];
}else{
$thirth_data['status'] = 0;
//平台订单号
$thirth_data['delivery_no'] = "";
//实际运费(单位:元)
$thirth_data['shipping_fee'] = 0;
//运费(单位:元)
$thirth_data['shipping_delivery_fee'] = 0;
//配送距离(单位:米)
$thirth_data['distance'] = 0;
$thirth_data['message'] = $result['message'];
}
$this->addThirthQuery($thirth_data);
}
//如果是码科配送
if( isset($is_localtown_mk_status) && $is_localtown_mk_status == 1 && isset($is_make_prequery_status) && $is_make_prequery_status == 1 )
{
$make_model = D('Home/Make');
$result = $make_model->queryDeliverFee($order_info);
$thirth_data = [];
$thirth_data['order_id'] = $order_info['order_id'];
$thirth_data['third_distribution_type'] = "mk";
if( !empty($result) && $result['code'] == 0 )
{
$thirth_data['status'] = 1;
//平台订单号
$thirth_data['delivery_no'] = "";
//实际运费(单位:元)
$thirth_data['shipping_fee'] = round($result['total_price'],2);
//运费(单位:元)
$thirth_data['shipping_delivery_fee'] = round($result['total_price'],2);
//配送距离(单位:米)
$thirth_data['distance'] = $result['distance'] * 1000;
}else {
$thirth_data['status'] = 0;
//平台订单号
$thirth_data['delivery_no'] = "";
//实际运费(单位:元)
$thirth_data['shipping_fee'] = 0;
//运费(单位:元)
$thirth_data['shipping_delivery_fee'] = 0;
//配送距离(单位:米)
$thirth_data['distance'] = 0;
$thirth_data['message'] = $result['message'];
}
$this->addThirthQuery($thirth_data);
}
}
/**
* @author cy 2020-12-29
* @desc 保存第三方配送预查询费用信息
* @param $thirth_data
*/
public function addThirthQuery($thirth_data){
$order_id = $thirth_data['order_id'];
$third_distribution_type = $thirth_data['third_distribution_type'];
$thirth_query = M('lionfish_comshop_orderdistribution_thirth_query')->where(array('order_id'=>$order_id,'third_distribution_type'=>$third_distribution_type))->find();
$thirth_data['addtime'] = time();
if(!empty($thirth_query)){
M('lionfish_comshop_orderdistribution_thirth_query')->where(array('id'=>$thirth_query['id']))->save($thirth_data);
}else{
M('lionfish_comshop_orderdistribution_thirth_query')->add($thirth_data);
}
}
/**
* @author cy 2020-12-30
* @desc 获取供应商地址信息
* @param $order_info
* @return array
*/
public function getOrderStoreAddress($order_info){
$store_id = $order_info['store_id'];
$province_id = D('Home/Front')->get_supply_config_by_name('localtown_shop_province_id',$store_id);
$city_id = D('Home/Front')->get_supply_config_by_name('localtown_shop_city_id',$store_id);
$area_id = D('Home/Front')->get_supply_config_by_name('localtown_shop_area_id',$store_id);
$country_id = D('Home/Front')->get_supply_config_by_name('localtown_shop_country_id',$store_id);
$shop_address = D('Home/Front')->get_supply_config_by_name('localtown_shop_address',$store_id);
$shop_lon = D('Home/Front')->get_supply_config_by_name('localtown_shop_lon',$store_id);
$shop_lat = D('Home/Front')->get_supply_config_by_name('localtown_shop_lat',$store_id);
$shop_telephone = D('Home/Front')->get_supply_config_by_name('localtown_shop_telephone',$store_id);
//storename
$lionfish_comshop_supply = M('lionfish_comshop_supply')->where( array('id' => $store_id) )->find();
$store_data = [];
$store_data['address'] = $province_id.$city_id.$area_id.$country_id.$shop_address;
$store_data['city'] = $city_id;
$store_data['shop_lon'] = $shop_lon;
$store_data['shop_lat'] = $shop_lat;
$store_data['shop_telephone'] = $shop_telephone;
$store_data['begin_address'] = $shop_address;
$store_data['begin_detail'] = $province_id.$city_id.$area_id.$country_id;
$store_data['begin_username'] = $lionfish_comshop_supply['storename'];
return $store_data;
}
/**
* 订单自动推送给第三方配送公司
* @param array $order
*/
public function order_autosend_third_delivery($order){
if($order['delivery'] == 'localtown_delivery'){//同城配送订单
//供应商“第三方配送服务” 1、开启,0、关闭
$supply_third_delivery_service = D('Home/Front')->get_config_by_name('supply_third_delivery_service');
$is_order_push_status = D('Home/Front')->get_config_by_name('is_order_push_status');
$order_push_third_distribution_company = D('Home/Front')->get_config_by_name('order_push_third_distribution_company');
if($is_order_push_status == 1){//订单自动确认配送
if($order['store_id'] == 0 || ($order['store_id'] > 0 && $supply_third_delivery_service == 1)){
$this->order_send_third_delivery_company($order,$order_push_third_distribution_company);
}
}
}
}
/**
* @author cy 2021-02-25
* @desc 订单自动发送给第三方配送公司
* @param $order_info
* @param $data_type
*/
public function order_send_third_delivery_company($order_info,$data_type){
$order_id = $order_info['order_id'];
//店铺地址
if($order_info['store_id'] > 0) {
$store_data = D('Home/Order')->getOrderStoreAddress($order_info);
$order_info['store_data'] = $store_data;
}
//商品信息
$sql = "select og.goods_id,og.name as goods_name,og.quantity,og.price,og.total,og.rela_goodsoption_valueid,g.weight as goods_weight from "
. C('DB_PREFIX')."lionfish_comshop_order_goods as og left join ".C('DB_PREFIX')."lionfish_comshop_goods as g on og.goods_id=g.id "
." where og.order_id = ".$order_id;
$goods_list = M()->query($sql);
$goods_count = 0;
$goods_weight = 0;
$goods_type_count = 0;
foreach($goods_list as $k=>$v){
$goods_count = $goods_count + $v['quantity'];
if(!empty($v['rela_goodsoption_valueid'])){
$goods_option_mult_value = M('lionfish_comshop_goods_option_item_value')->where( array('option_item_ids' => $v['rela_goodsoption_valueid'],'goods_id' => $v['goods_id']) )->find();
if(!empty($goods_option_mult_value)){
$v['goods_weight'] = $goods_option_mult_value['weight'];
}
}
$goods_weight = $goods_weight + $v['quantity'] * $v['goods_weight'];
$goods_type_count = $goods_type_count + 1;
}
if(empty($goods_weight)){
$goods_weight = 100;//默认100克
}
$order_info['goods_list'] = $goods_list;
//商品种类
$order_info['goods_type_count'] = $goods_type_count;
//商品数量
$order_info['goods_count'] = $goods_count;
//商品重量
$order_info['goods_weight'] = $goods_weight;
//订单总金额
$order_info['order_total'] = $order_info['total']+$order_info['packing_fare']+$order_info['shipping_fare']-$order_info['voucher_credit']-$order_info['fullreduction_money']-$order_info['score_for_money']+$order_info['localtown_add_shipping_fare']-$order_info['fare_shipping_free'];
//收货人地址
$province_info = D('Home/Front')->get_area_info($order_info['shipping_province_id']);
$city_info = D('Home/Front')->get_area_info($order_info['shipping_city_id']);
$area_info = D('Home/Front')->get_area_info($order_info['shipping_country_id']);
$order_info['shipping_address'] = $province_info['name'].$city_info['name'].$area_info['name'].$order_info['shipping_address'];
//收货人经纬度
$order_distribution_info = M('lionfish_comshop_orderdistribution_order')->where( array('order_id' => $order_id ) )->find();
//收货人地址纬度
$order_info['shipping_lat'] = $order_distribution_info['member_lat'];
//收货人地址经度
$order_info['shipping_lng'] = $order_distribution_info['member_lon'];
//商城名称
$shoname = D('Home/Front')->get_config_by_name('shoname');
$order_info['shoname'] = $shoname;
if($data_type == 'imdada'){
$imdada = new \Lib\Localtown\Imdada();
$result = $imdada->addOrder($order_info);
if($result['status'] == 1){//成功
//配送费用
$delivery_fee = $result['result']['fee'];
$express_info = array();
$express_info['delivery_fee'] = $delivery_fee;
D('Seller/Order')->do_send_localtown_thirth_delivery($order_id,$data_type,$express_info);
$shipping_money = M('lionfish_comshop_orderdistribution_order')->where( array('order_id' => $order_id ) )->find();
D('Seller/Supply')->update_supply_commission($order_id,$shipping_money["shipping_money"]);
}
}else if($data_type == 'sf'){
$sfexpress = new \Lib\Localtown\Sfexpress();
$result = $sfexpress->addOrder($order_info);
if($result['status'] == 1){//成功
//配送费用
$delivery_fee = round($result['result']['total_price']/100,2);
//顺丰订单号
$delivery_order_id = $result['result']['sf_order_id'];
//顺丰运单号
$delivery_bill_id = $result['result']['sf_bill_id'];
$express_info = array();
$express_info['delivery_fee'] = $delivery_fee;
$express_info['delivery_order_id'] = $delivery_order_id;
$express_info['delivery_bill_id'] = $delivery_bill_id;
D('Seller/Order')->do_send_localtown_thirth_delivery($order_id,$data_type,$express_info);
$shipping_money = M('lionfish_comshop_orderdistribution_order')->where( array('order_id' => $order_id ) )->find();
D('Seller/Supply')->update_supply_commission($order_id,$shipping_money["shipping_money"]);
}
}else if( $data_type == 'make' )
{
//$store_data = D('Home/Make')->getOrderStoreAddress($order_info);
$result = D('Home/Make')->addOrder($order_info);
if( $result['code'] == 0 )
{
//码科订单号
$delivery_order_id = $result['order_number'];
$express_info = array();
$express_info['delivery_fee'] = $order_distribution_info['shipping_money'];
$express_info['delivery_order_id'] = $delivery_order_id;
$express_info['delivery_bill_id'] = '';
D('Seller/Order')->do_send_localtown_thirth_delivery($order_id,$data_type,$express_info);
$shipping_money = M('lionfish_comshop_orderdistribution_order')->where( array('order_id' => $order_id ) )->find();
D('Seller/Supply')->update_supply_commission($order_id,$shipping_money["shipping_money"]);
}
}else if($data_type == 'ele'){//蜂鸟即配
$eleDistribution = new \Lib\Localtown\EleDistribution();
$order_code = build_order_no(session('user_auth.uid'));
//保存蜂鸟即配商户订单号
M('lionfish_comshop_orderdistribution_order')->where( array('order_id' => $order_id ) )->save(['order_code'=>$order_code]);
$order_info['order_num_alias'] = $order_code;
$result = $eleDistribution->addOrder($order_info);
if($result['status'] == 1){//成功
//配送费用
$delivery_fee = round($result['result']['total_price']/100,2);
//蜂鸟即配订单号
$delivery_order_id = $result['result']['sf_order_id'];
//蜂鸟即配运单号
$delivery_bill_id = $result['result']['sf_bill_id'];
$express_info = array();
$express_info['delivery_fee'] = $delivery_fee;
$express_info['delivery_order_id'] = $delivery_order_id;
$express_info['delivery_bill_id'] = $delivery_bill_id;
D('Seller/Order')->do_send_localtown_thirth_delivery($order_id,$data_type,$express_info);
$shipping_money = M('lionfish_comshop_orderdistribution_order')->where( array('order_id' => $order_id ) )->find();
D('Seller/Supply')->update_supply_commission($order_id,$shipping_money["shipping_money"]);
}
}
}
}