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; }