zh_tcwq/inc/web/ddgl.inc.php

<?php
global $_GPC, $_W;
// $action = 'ad';
// $title = $this->actions_titles[$action];
$GLOBALS['frames'] = $this->getMainMenu();
$operation = !empty($_GPC['op']) ? $_GPC['op'] : 'display';
$type = isset($_GPC['type']) ? $_GPC['type'] : 'all';
$status = $_GPC['status'];
load()->func('tpl');
$pageindex = max(1, intval($_GPC['page']));
$pagesize = 10;
$where = ' WHERE  a.uniacid=:uniacid  ';
if ($_GPC['keywords']) {
	$op = $_GPC['keywords'];
	$where .= " and (a.order_num LIKE  concat('%', :order_no,'%') or a.user_name LIKE  concat('%', :order_no,'%'))";
	$data[':order_no'] = $op;
}
if ($status) {
	$op = $_GPC['keywords'];
	$where .= " and a.state=$status";
}
if ($_GPC['time']) {
	$start = strtotime($_GPC['time']['start']);
	$end = strtotime($_GPC['time']['end']);
	$where .= " and a.time >={$start} and a.time<={$end}";

}
$sql = "SELECT a.*,b.store_name as seller_name FROM " . tablename('zhtc_order') . " a" . " left join " . tablename("zhtc_store") . " b on a.store_id=b.id" . $where . " ORDER BY a.time DESC";
$data[':uniacid'] = $_W['uniacid'];
$total = pdo_fetchcolumn("SELECT count(*) FROM " . tablename('zhtc_order') . " a" . " left join " . tablename("zhtc_store") . " b on a.store_id=b.id" . $where . " ORDER BY a.time DESC", $data);

$select_sql = $sql . " LIMIT " . ($pageindex - 1) * $pagesize . "," . $pagesize;
$list = pdo_fetchall($select_sql, $data);
$pager = pagination($total, $pageindex, $pagesize);
if ($operation == 'delete') {
	$res = pdo_delete('zhtc_order', array('id' => $_GPC['id']));
	//$res=pdo_update('zhtc_order',array('is_delete'=>1),array('id'=>$_GPC['id']));
	if ($res) {
		message('删除成功', $this->createWebUrl('ddgl', array()), 'success');
	} else {
		message('删除失败', '', 'error');
	}
}
if ($operation == 'delivery') {

	$res = pdo_update('zhtc_order', array('state' => 3, 'fh_time' => time()), array('id' => $_GPC['id']));
	if ($res) {
		message('操作成功', $this->createWebUrl('ddgl', array()), 'success');
	} else {
		message('操作失败', '', 'error');
	}
}
if ($operation == 'receipt') {
	$order = pdo_get('zhtc_order', array('id' => $_GPC['id']));
	$res = pdo_update('zhtc_order', array('state' => 4, 'complete_time' => time()), array('id' => $_GPC['id']));
	if ($res) {
		pdo_update('zhtc_store', array('wallet +=' => $order['money']), array('id' => $order['store_id']));
		$data3['store_id'] = $order['store_id'];
		$data3['money'] = $order['money'];
		$data3['note'] = '商品订单';
		$data3['type'] = 1;
		$data3['time'] = date("Y-m-d H:i:s");
		pdo_insert('zhtc_store_wallet', $data3);
		$system = pdo_get('zhtc_system', array('uniacid' => $_W['uniacid']));
		if ($system['good_jf'] > 0) {
			pdo_update('zhtc_user', array('total_score +=' => $system['good_jf']), array('id' => $order['user_id']));
			$data2['score'] = $system['good_jf'];
			$data2['user_id'] = $order['user_id'];
			$data2['tid'] = $order['id'];
			$data2['note'] = '商品订单';
			$data2['type'] = 1;
			$data2['cerated_time'] = date('Y-m-d H:i:s');
			$data2['uniacid'] = $_W['uniacid']; //小程序id
			pdo_insert('zhtc_integral', $data2); //添加积分明细
		}
// ///////////////////////////城市佣金
		//          include IA_ROOT.'/addons/zh_tcwq/yj.php';
		//          $cityname=Yj::getStoreCity($order['store_id']);
		//          $yjset=Yj::getYjSet($_W['uniacid']);
		//          if($yjset['type']==1){
		//           $money=$_GPC['money']*$yjset['typer']/100;
		//         }else{
		//          $money=$_GPC['money']*$yjset['sjper']/100;
		//        }
		//        pdo_update('zhtc_account',array('money +='=>$money),array('cityname'=>$cityname));
		// /////////////////分销/////////////////

//         $set=pdo_get('zhtc_fxset',array('uniacid'=>$_W['uniacid']));
		//         $order=pdo_get('zhtc_order',array('id'=>$_GPC['id']));
		//         if($set['is_open']==1){
		//             if($set['is_ej']==2){//不开启二级分销
		//        $user=pdo_get('zhtc_fxuser',array('fx_user'=>$order['user_id']));
		//        if($user){
		//             $userid=$user['user_id'];//上线id
		//             $money=$order['money']*($set['commission']/100);//一级佣金
		//             pdo_update('zhtc_user',array('commission +='=>$money),array('id'=>$userid));
		//             $data6['user_id']=$userid;//上线id
		//             $data6['son_id']=$order['user_id'];//下线id
		//             $data6['money']=$money;//金额
		//             $data6['time']=time();//时间
		//             $data6['uniacid']=$_W['uniacid'];
		//             pdo_insert('zhtc_earnings',$data6);
		//           }
		//       }else{//开启二级
		//        $user=pdo_get('zhtc_fxuser',array('fx_user'=>$order['user_id']));
		//           $user2=pdo_get('zhtc_fxuser',array('fx_user'=>$user['user_id']));//上线的上线
		//           if($user){
		//             $userid=$user['user_id'];//上线id
		//             $money=$order['money']*($set['commission']/100);//一级佣金
		//             pdo_update('zhtc_user',array('commission +='=>$money),array('id'=>$userid));
		//             $data6['user_id']=$userid;//上线id
		//             $data6['son_id']=$order['user_id'];//下线id
		//             $data6['money']=$money;//金额
		//             $data6['time']=time();//时间
		//             $data6['uniacid']=$_W['uniacid'];
		//             pdo_insert('zhtc_earnings',$data6);
		//           }
		//           if($user2){
		//             $userid2=$user2['user_id'];//上线的上线id
		//             $money=$order['money']*($set['commission2']/100);//二级佣金
		//             pdo_update('zhtc_user',array('commission +='=>$money),array('id'=>$userid2));
		//             $data7['user_id']=$userid2;//上线id
		//             $data7['son_id']=$order['user_id'];//下线id
		//             $data7['money']=$money;//金额
		//             $data7['time']=time();//时间
		//             $data7['uniacid']=$_W['uniacid'];
		//             pdo_insert('zhtc_earnings',$data7);
		//           }
		//         }
		//         }

// /////////////////分销/////////////////

		message('操作成功', $this->createWebUrl('ddgl', array()), 'success');
	} else {
		message('操作失败', '', 'error');
	}
}
if ($operation == 'refund') {
	$id = $_GPC['id'];
	include_once IA_ROOT . '/addons/zh_tcwq/cert/WxPay.Api.php';
	load()->model('account');
	load()->func('communication');
	$WxPayApi = new WxPayApi();
	$input = new WxPayRefund();
	$path_cert = IA_ROOT . "/addons/zh_tcwq/cert/" . 'apiclient_cert_' . $_W['uniacid'] . '.pem';
	$path_key = IA_ROOT . "/addons/zh_tcwq/cert/" . 'apiclient_key_' . $_W['uniacid'] . '.pem';
	$account_info = $_W['account'];
	$refund_order = pdo_get('zhtc_order', array('id' => $id));
	$res = pdo_get('zhtc_system', array('uniacid' => $_W['uniacid']));
	$appid = $res['appid'];
	$key = $res['wxkey'];
	$mchid = $res['mchid'];
	$out_trade_no = $refund_order['out_trade_no'];
	$fee = $refund_order['money'] * 100;
	$input->SetAppid($appid);
	$input->SetMch_id($mchid);
	$input->SetOp_user_id($mchid);
	$input->SetRefund_fee($fee);
	$input->SetTotal_fee($fee);
	// $input->SetTransaction_id($refundid);
	$input->SetOut_refund_no($id);

	$input->SetOut_trade_no($out_trade_no);

	$result = $WxPayApi->refund($input, 6, $path_cert, $path_key, $key);
	if ($result['result_code'] == 'SUCCESS') {
//退款成功
		//更改订单操作
		pdo_update('zhtc_order', array('state' => 6), array('id' => $id));
		message('退款成功', $this->createWebUrl('ddgl', array()), 'success');
	} else {
		message($result['return_msg'], '', 'error');
	}
}
if ($operation == 'jj') {
	$id = $_GPC['id'];
	$res = pdo_update('zhtc_order', array('state' => 7), array('id' => $id));
	if ($res) {
		message('拒绝成功', $this->createWebUrl('ddgl', array()), 'success');
	} else {
		message('拒绝失败', '', 'error');
	}
}

include $this->template('web/ddgl');