public function getorderinfo($querywhere, $start, $display)
{
$dbmsale = new DB_mssale();
if ($start < 0) {
$start = 0;
}
$start = $start + 0;
$display = $display + 0;
$query = "select 1 from web_order where 1=1 {$querywhere} ";
$dbmsale->query($query);
$msgallcount = $dbmsale->nf();
$wfstate = '未付款';
$wfstate = u2g($wfstate);
$yfstate = '已付款';
$yfstate = u2g($yfstate);
$qfstate = '其他';
$qfstate = u2g($qfstate);
$query = "select case \n\t when fd_order_state ='6' then '" . $wfstate . "'\n\t when fd_order_state ='7' then '" . $yfstate . "'\n\t else '" . $qfstate . "' END orderstate,fd_order_id as orderid,fd_order_no as orderno ,\n\t\t fd_order_date as ordertime ,fd_order_allmoney as ordermoney,fd_order_alldunshu as orderpronum,\n\t\t fd_order_type as orderpaytype,fd_order_shman as shman,fd_order_comnpany as shcmpyname,\n\t\t fd_order_receiveadderss as shaddress , '' as fhstorage,'' as fhwltype,\n\t\t fd_order_memo as ordermemo,'' as allpromoney,'' as fhwlmoney\n\t\t from web_order " . "where 1=1 {$querywhere} limit {$start} ,{$display}";
$dbmsale->query($query);
//echo $query;
$msgdiscount = $dbmsale->nf();
$arr_value = $dbmsale->getData('', 'msorder');
//$arr_orderinfo = $dbmsale->get_all($query);
foreach ($arr_value as $key => $value) {
foreach ($value as $k => $v) {
$orderid = $v['orderid'];
$query = "select fd_orderdetail_quantity as pronum,fd_orderdetail_productname as proname,\n\t\t\t\t\t fd_orderdetail_price as proprice \n\t\t\t\t\t ,(fd_orderdetail_price*fd_orderdetail_quantity) as promoney from web_orderdetail \n\t\t\t\t\t where fd_orderdetail_orderid ='{$orderid}'";
$dbmsale->query($query);
//echo $query;
if ($dbmsale->nf()) {
$arr_value[$key][$k]['msproinfo'] = $dbmsale->getFiledData('msgchild');
}
}
}
if (!$arr_value) {
$arr_message = array("result" => "failure", "message" => "很抱歉，没有找到相关的订单信息!");
} else {
$arr_message = array("result" => "success", "message" => "读取成功");
}
//echo var_dump($arr_value);
$arr_message = auto_charset($arr_message, 'utf-8', 'gbk');
$arr_msg['msgbody'] = $arr_value;
$arr_msg['msgbody']['result'] = $arr_message['result'];
$arr_msg['msgbody']['message'] = $arr_message['message'];
$arr_msg['msgbody']['msgallcount'] = $msgallcount;
$arr_msg['msgbody']['msgdiscount'] = $msgdiscount + $start;
return $arr_msg['msgbody'];
}
public function changePayTranstatus($bkordernumber, $transStatus, $paytype)
{
$dbmsale = new DB_mssale();
$nowdate = date("Y-m-d H:i:s");
switch (trim($paytype)) {
case "coupon":
//购买抵用券
$query = "update tb_couponsale set fd_couponsale_payrq = '{$transStatus}' where fd_couponsale_bkordernumber = '{$bkordernumber}' ";
$this->DB_test->query($query);
$query = "update tb_agentpaymoneylist set fd_agpm_payrq ='{$transStatus}',fd_agpm_datetime = now() where fd_agpm_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
break;
case "creditcard":
//信用卡还款
$query = "update tb_creditcardglist set fd_ccglist_payrq ='{$transStatus}',fd_ccglist_paydate = '{$nowdate}' where fd_ccglist_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
$query = "update tb_agentpaymoneylist set fd_agpm_payrq ='{$transStatus}',fd_agpm_datetime = now() where fd_agpm_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
break;
case "recharge":
//充值
$query = "update tb_rechargeglist set fd_rechargelist_payrq ='{$transStatus}' where fd_rechargelist_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
$query = "update tb_agentpaymoneylist set fd_agpm_payrq ='{$transStatus}',fd_agpm_datetime = now() where fd_agpm_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
$rechange = 'account';
break;
case "repay":
//还贷款
$query = "update tb_repaymoneyglist set fd_repmglist_payrq ='{$transStatus}' ,fd_repmglist_paydate ='{$nowdate}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t where fd_repmglist_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
$query = "update tb_agentpaymoneylist set fd_agpm_payrq ='{$transStatus}',fd_agpm_datetime = now() where fd_agpm_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
break;
case "order":
//订单付款
$query = "update tb_orderpayglist set fd_oplist_payrq ='{$transStatus}',fd_oplist_paydate = '{$nowdate}' where fd_oplist_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
$query = "update tb_agentpaymoneylist set fd_agpm_payrq ='{$transStatus}',fd_agpm_datetime = now() where fd_agpm_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
$rechange = 'order';
break;
case "tfmg":
//转账汇款
$query = "update tb_transfermoneyglist set fd_tfmglist_payrq ='{$transStatus}' ,fd_tfmglist_paydate ='{$nowdate}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t where fd_tfmglist_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
$query = "update tb_agentpaymoneylist set fd_agpm_payrq ='{$transStatus}',fd_agpm_datetime = now() where fd_agpm_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
break;
case "suptfmg":
//转账汇款
$query = "update tb_transfermoneyglist set fd_tfmglist_payrq ='{$transStatus}' ,fd_tfmglist_paydate ='{$nowdate}'\n\t\t\t\t\t\t where fd_tfmglist_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
$query = "update tb_agentpaymoneylist set fd_agpm_payrq ='{$transStatus}',fd_agpm_datetime = now() where fd_agpm_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
break;
case "mobilerecharge":
//手机充值
MobileRecharge::UpmpPayFeedback($transStatus, $bkordernumber);
break;
case "qqrecharge":
//手机充值
$query = "update tb_qqrechargelist set fd_mrclist_payrq ='{$transStatus}' where fd_mrclist_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
if ($transStatus == '00') {
// echo "<br>这是调用欧飞接口：".$query;
$return = $this->Tfb_ThirdApi->qqrecharge($bkordernumber, $transStatus);
return $return;
// exit;
//return
}
break;
case "utility":
if ($transStatus == '00') {
return true;
} else {
return false;
}
case "gamerecharge":
if ($transStatus == '00') {
return true;
} else {
return false;
}
default:
break;
}
switch ($rechange) {
case "account":
$query = "select fd_agpm_paycardid as paycardid,fd_agpm_authorid as authorid , fd_agpm_bkmoney as bkmoney," . "fd_agpm_paytype as paytype , fd_agpm_bkordernumber as bkordernumber \n\t\t\t\t\t\t\t\t\t\t from tb_agentpaymoneylist where fd_agpm_bkordernumber = '{$bkordernumber}' and fd_agpm_payrq = '00' \n\t\t\t\t\t\t\t\t\t\t limit 1";
//交易成功的才执行
if ($this->DB_test->execute($query)) {
$arr_payinfo = $this->DB_test->get_one($query);
if ($this->TfbAccount->changeAccountglist($arr_payinfo)) {
$getacc = $this->TfbAccount->changeAccount($arr_payinfo);
}
}
break;
case "order":
/* $query = "select fd_oplist_paycardid as paycardid,fd_oplist_authorid as authorid , fd_oplist_paymoney as bkmoney," .
"fd_oplist_paytype as paytype , fd_oplist_bkordernumber as bkordernumber
from tb_orderpayglist where fd_oplist_bkordernumber = '$bkordernumber' and fd_oplist_payrq = '00'
limit 1"; //交易成功的才执行
if ($this->DB_test->execute($query)) {
$arr_payinfo = $this->DB_test->get_one($query);
if ($this->TfbAccount->changeAccountglist($arr_payinfo)) //如果账户流水改变，则修改账户金额
{
$getacc = $this->TfbAccount->changeAccount($arr_payinfo);
}
}*/
$query = "select fd_oplist_orderid as orderid from tb_orderpayglist where fd_oplist_payrq ='00' " . "and fd_oplist_bkordernumber = '{$bkordernumber}'";
$arr_oporderinfo = $this->DB_test->get_one($query);
$orderid = $arr_oporderinfo['orderid'];
$query = "update web_order set fd_order_state = '7' where fd_order_id = '{$orderid}'";
$dbmsale->query($query);
break;
}
return true;
}
public function changePayTranstatus($bkordernumber, $transStatus, $paytype, $cusfee)
{
$dbmsale = new DB_mssale();
$nowdate = date("Y-m-d H:i:s");
switch (trim($paytype)) {
case "coupon":
//购买抵用券
$query = "update tb_couponsale set fd_couponsale_payrq = '{$transStatus}' where fd_couponsale_bkordernumber = '{$bkordernumber}' ";
$this->DB_test->query($query);
$query = "update tb_agentpaymoneylist set fd_agpm_payrq ='{$transStatus}',fd_agpm_datetime = now(),fd_agpm_cusfenrun= '{$cusfee}' where fd_agpm_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
break;
case "creditcard":
//信用卡还款
$query = "update tb_creditcardglist set fd_ccglist_payrq ='{$transStatus}',fd_ccglist_paydate = '{$nowdate}' where fd_ccglist_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
$query = "update tb_agentpaymoneylist set fd_agpm_payrq ='{$transStatus}',fd_agpm_datetime = now(),fd_agpm_cusfenrun = '{$cusfee}' where fd_agpm_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
break;
case "recharge":
//充值
$query = "update tb_rechargeglist set fd_rechargelist_payrq ='{$transStatus}' where fd_rechargelist_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
$query = "update tb_agentpaymoneylist set fd_agpm_payrq ='{$transStatus}',fd_agpm_datetime = now(),fd_agpm_cusfenrun = '{$cusfee}' where fd_agpm_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
$rechange = 'account';
break;
case "repay":
//还贷款
$query = "update tb_repaymoneyglist set fd_repmglist_payrq ='{$transStatus}' ,fd_repmglist_paydate ='{$nowdate}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t where fd_repmglist_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
$query = "update tb_agentpaymoneylist set fd_agpm_payrq ='{$transStatus}',fd_agpm_datetime = now() ,fd_agpm_cusfenrun = '{$cusfee}' where fd_agpm_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
break;
case "order":
//明盛商城订单付款
$query = "update tb_orderpayglist set fd_oplist_payrq ='{$transStatus}',fd_oplist_paydate = '{$nowdate}' where fd_oplist_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
$query = "update tb_agentpaymoneylist set fd_agpm_payrq ='{$transStatus}',fd_agpm_datetime = now() ,fd_agpm_cusfenrun = '{$cusfee}' where fd_agpm_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
$rechange = 'order';
break;
case "tfmg":
//转账汇款
$query = "update tb_transfermoneyglist set fd_tfmglist_payrq ='{$transStatus}' ,fd_tfmglist_paydate ='{$nowdate}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t where fd_tfmglist_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
$query = "update tb_agentpaymoneylist set fd_agpm_payrq ='{$transStatus}',fd_agpm_datetime = now() ,fd_agpm_cusfenrun = '{$cusfee}' where fd_agpm_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
break;
case "suptfmg":
//转账汇款
$query = "update tb_transfermoneyglist set fd_tfmglist_payrq ='{$transStatus}' ,fd_tfmglist_paydate ='{$nowdate}'\n\t\t\t\t\t\t where fd_tfmglist_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
$query = "update tb_agentpaymoneylist set fd_agpm_payrq ='{$transStatus}',fd_agpm_datetime = now() ,fd_agpm_cusfenrun = '{$cusfee}' where fd_agpm_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
break;
case "orderbuy":
//购买刷卡器
$query = "update tb_orderglist set fd_orderlist_payrq ='{$transStatus}' ,\n fd_orderlist_paydate ='{$nowdate}',fd_orderlist_cusfee = '{$cusfee}'\n\t\t\t\t\t\t where fd_orderlist_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
break;
case "mobilerecharge":
//手机充值
$query = "update tb_mobilerechargelist set fd_mrclist_payrq ='{$transStatus}',fd_mrclist_paydate = '{$nowdate}',fd_mrclist_cusfee = '{$cusfee}' where fd_mrclist_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
if ($transStatus == '00') {
// echo "<br>这是调用欧飞接口：".$query;
$return = $this->Tfb_ThirdApi->mobilerecharge($bkordernumber, $transStatus);
return $return;
}
break;
case "qqrecharge":
//手机充值
$query = "update tb_qqrechargelist set fd_mrclist_payrq ='{$transStatus}',fd_mrclist_paydate ='{$nowdate}',fd_mrclist_cusfenrun = '{$cusfee}' where fd_mrclist_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
if ($transStatus == '00') {
// echo "<br>这是调用欧飞接口：".$query;
$return = $this->Tfb_ThirdApi->qqrecharge($bkordernumber, $transStatus);
return $return;
}
break;
case "agentbuy":
//代理商补货
if ($transStatus == '00') {
$cwstate = 1;
} else {
$cwstate = 0;
}
$query = "update tb_salelist set fd_selt_payrq ='{$transStatus}',fd_selt_cwstate = '{$cwstate}',\n fd_selt_paydate = now() where fd_selt_bkordernumber = '{$bkordernumber}'";
$this->DB_test->query($query);
// if ($transStatus == '00') {
// // echo "<br>这是调用欧飞接口：".$query;
// $return = $this->Tfb_ThirdApi->qqrecharge($bkordernumber, $transStatus);
// return $return;
//
// }
break;
default:
break;
}
switch ($rechange) {
case "account":
$query = "select fd_agpm_paycardid as paycardid,fd_agpm_authorid as authorid , fd_agpm_bkmoney as bkmoney," . "fd_agpm_paytype as paytype , fd_agpm_bkordernumber as bkordernumber\n\t\t\t\t\t\t\t\t\t\t from tb_agentpaymoneylist where fd_agpm_bkordernumber = '{$bkordernumber}' and fd_agpm_payrq = '00' \n\t\t\t\t\t\t\t\t\t\t limit 1";
//交易成功的才执行
if ($this->DB_test->execute($query)) {
$arr_payinfo = $this->DB_test->get_one($query);
if ($this->TfbAccount->changeAccountglist($arr_payinfo)) {
$getacc = $this->TfbAccount->changeAccount($arr_payinfo);
}
}
break;
case "order":
$query = "select fd_oplist_orderid as orderid from tb_orderpayglist where fd_oplist_payrq ='00' " . "and fd_oplist_bkordernumber = '{$bkordernumber}'";
$arr_oporderinfo = $this->DB_test->get_one($query);
$orderid = $arr_oporderinfo['orderid'];
$query = "update web_order set fd_order_state = '7' where fd_order_id = '{$orderid}'";
$dbmsale->query($query);
break;
}
return true;
}
