public function EditKuaibkcard()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $authorid = trim($arr_channelinfo['authorid']);
     $bkcardid = trim($arr_body['bkcardid']);
     $bkcardbankcode = trim($arr_body['bkcardbankid']);
     $bkcardbank = trim($arr_body['bkcardbank']);
     $bkcardno = trim($arr_body['bkcardno']);
     $bkcardbankman = trim($arr_body['bkcardbankman']);
     $bkcardbankphone = trim($arr_body['bkcardbankphone']);
     $bkcardyxmonth = trim($arr_body['bkcardyxmonth']);
     $bkcardyxyear = trim($arr_body['bkcardyxyear']);
     $bkcardcvv = trim($arr_body['bkcardcvv']);
     $bkcardidcard = trim($arr_body['bkcardidcard']);
     $bkcardcardtype = trim($arr_body['bkcardcardtype']);
     $bkcardisdefault = trim($arr_body['bkcardisdefault']);
     $bkcardbankid = getbankid(u2g($bkcardbank));
     if ($bkcardisdefault == 1) {
         $query = "UPDATE tb_author_quickpaycard SET fd_bkcardisdefault = 0 WHERE fd_bkauthorid = " . $authorid;
         $db->query($query);
     }
     $query = "UPDATE tb_author_quickpaycard SET fd_bkcardno = '{$bkcardno}',fd_bkcardbankid = '{$bkcardbankid}',fd_bkcardbankcode = '{$bkcardbankcode}',fd_bkcardbank = '{$bkcardbank}',fd_bkcardbankman = '{$bkcardbankman}',fd_bkcardbankphone = '{$bkcardbankphone}',fd_bkcardyxmonth = '{$bkcardyxmonth}',fd_bkcardyxyear = '{$bkcardyxyear}',fd_bkcardcvv = '{$bkcardcvv}',fd_bkcardidcard = '{$bkcardidcard}',fd_bkcardisdefault = '{$bkcardisdefault}',fd_bkcardcardtype = '{$bkcardcardtype}' WHERE fd_bkcardid = " . $bkcardid;
     $db->query(auto_charset($query, 'utf-8', 'gbk'));
     $retcode = "0";
     $arr_message = array("result" => "success", "message" => "修改成功");
     $arr_msg['msgbody']['result'] = $arr_message['result'];
     $arr_msg['msgbody']['message'] = $arr_message['message'];
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }
 public function setAnswer()
 {
     $db = new DB_test();
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $authorid = trim($arr_channelinfo['authorid']);
     $query = "DELETE FROM tb_safeguard_secque_useranswer WHERE fd_author_id = {$authorid} ;";
     $db->query($query);
     if (count($arr_body) > 0) {
         for ($i = 0; $i < count($arr_body); $i++) {
             $itemKey = "msgchild" . ($i + 1);
             $questionid = trim($arr_body[$itemKey]['queid']);
             $answer = u2g(trim($arr_body[$itemKey]['answer']));
             if ($questionid != "" && trim($arr_body[$itemKey]['answer']) != "") {
                 $query = "REPLACE INTO tb_safeguard_secque_useranswer (`fd_question_id`, `fd_author_id`, `fd_answer`) \n\t\t\t\t\t\t\tVALUES ( {$questionid} , {$authorid} , '" . $answer . "');";
                 $db->query($query);
             }
         }
         $arr_message = array("result" => "success", "message" => "设置成功");
     } else {
         $arr_message = array("result" => "fail", "message" => "设置失败");
     }
     $retcode = "0";
     $arr_msg['msgbody']['result'] = $arr_message['result'];
     $arr_msg['msgbody']['message'] = $arr_message['message'];
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }
 static function getcouponSale($xml, $listno, $listid, $paytype = 'coupon', $bkntno)
 {
     $db = new DB_test();
     $Publiccls = new PublicClass();
     //初始化类实例
     $arr_xml = $Publiccls->xml_to_array($xml);
     $arr_channelinfo = $arr_xml['operation_request']['msgheader']['channelinfo'];
     $arr_body = $arr_xml['operation_request']['msgbody'];
     $authorid = $arr_channelinfo['authorid'];
     $couponid = trim($arr_body['couponid']);
     $paymoney = trim($arr_body['couponmoney']);
     $paycardid = trim($arr_body['paycardid']);
     $fucardno = trim($arr_body['creditcardno']);
     $fubank = trim(u2g($arr_body['creditbank']));
     $fucardman = trim(u2g($arr_body['creditcardman']));
     $fucardphone = trim(u2g($arr_body['creditcardphone']));
     $method = 'in';
     $method = u2g($method);
     $query1 = "insert into tb_agentpaymoneylist(\n\t\t\t\t\t\t\tfd_agpm_no\t\t\t,fd_agpm_paycardid\t\t,fd_agpm_authorid\t ,\n\t\t\t\t            fd_agpm_paydate\t    ,fd_agpm_shoucardno\t    ,fd_agpm_fucardno\t ,\n\t\t\t\t            fd_agpm_bkntno\t\t,fd_agpm_payrq          ,fd_agpm_paytype     ,\n\t\t\t\t            fd_agpm_current\t    ,fd_agpm_paymoney\t\t,fd_agpm_payfee\t\t ,\n\t\t\t\t            fd_agpm_money\t\t,fd_agpm_shoucardbank   ,fd_agpm_shoucardman ,\n\t\t\t\t            fd_agpm_shoucardmobile,fd_agpm_fucardbank\t,fd_agpm_fucardmobile,\n\t\t\t\t            fd_agpm_fucardman   ,fd_agpm_feebankid      ,fd_agpm_state       ,\n\t\t\t\t            fd_agpm_listid     , fd_agpm_listno         ,fd_agpm_method ,\n\t\t\t\t            fd_agpm_datetime     )values\n\t\t\t\t\t\t   ('{$listno}'\t\t,'{$paycardid}'\t,'{$authorid}'\t\t,\n\t\t\t\t\t\t   now()\t\t,'{$shoucardno}'\t,'{$fucardno}'\t\t,\n\t\t\t\t\t\t   '{$bkntno}'\t\t,'01'\t\t\t,'{$paytype}'\t\t\t,\n\t\t\t\t\t\t   '{$current}'\t\t,'{$paymoney}'\t,'{$payfee}'\t\t\t,\n\t\t\t\t\t\t   '{$paymoney}'\t\t\t,'{$shoucardbank}','{$shoucardman}'\t\t,\n\t\t\t\t\t\t   '{$shoucardmobile}','{$fucardbank}'\t,'{$fucardphone}'  \t,\n\t\t\t\t\t\t   '{$fucardman}'\t\t,'{$feebankid}'\t,'0'\t            ,\t\t\n\t\t\t\t\t\t   '{$listid}'\t\t,'{$listno}'\t    ,'{$method}'\t,now()        \t\t\t\n\t\t\t\t\t\t  )";
     $db->query($query1);
     $authorid = $authorid + 0;
     $file = "./" . date('Y-m-d') . "-paylist" . ".txt";
     $filehandle = fopen($file, "a");
     fwrite($filehandle, "\r\n======响应内容:\r\n" . $query1 . "\r\n\r\n\r\n\r\n<!--------------结束------------>\r\n\r\n\r\n");
     fclose($filehandle);
     return 1;
 }
 /**
  * get_gpath获取以/开头的虚拟路径,GB2312 用于访问文件系统
  * get_upath获取以/开头的虚拟路径,UTF-8  用于页面输出
  * @param unknown_type $path
  * @param unknown_type $type
  * @return unknown
  */
 function get_gpath($path, $type = 'u')
 {
     if ('r' == $type) {
         $path = str_replace('//', '/', REAL_ROOT_PATH . $path);
     }
     if ('u' == $type) {
         $path = str_replace('//', '/', REAL_USER_PATH . $path);
     }
     $path = SYS_WIN ? u2g($path) : $path;
     return $path;
 }
 public function readBankList()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $activemobilesms = trim($arr_body['activemobilesms']);
     $querysql = trim(u2g(trim($arr_body['querywhere'])));
     //$appversion = trim($arr_body['appversion']);
     $msgstart = $arr_body['msgstart'] + 0;
     $msgdisplay = $arr_body['msgdisplay'] + 0;
     if ($msgstart < 0) {
         $msgstart = 0;
     }
     if ($msgdisplay == 0) {
         $msgdisplay = 40;
     }
     if ($activemobilesms) {
         $querywhere = " and fd_bank_activemobilesms = '1'";
     }
     if ($querysql != "") {
         $querywhere .= " and fd_bank_name like '%{$querysql}%'";
     }
     $query = "select  1 from tb_bank where fd_bank_active = '1' {$querywhere}  ";
     $db->query($query);
     $msgallcount = $db->nf();
     if ($msgstart >= $msgallcount) {
         $msgstart = $msgallcount - $msgdisplay;
         if ($msgstart < 0) {
             $msgstart = 0;
         }
     }
     $query = "select fd_bank_id as bankid,fd_bank_no as bankno,fd_bank_name as bankname from \n\t\t\t       tb_bank where fd_bank_active = '1' {$querywhere} order by fd_bank_no asc limit {$msgstart}, {$msgdisplay} ";
     //只显示激活的银行列表
     $db->query($query);
     $arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8');
     $msgdiscount = $db->nf();
     if (!$arr_msg) {
         $arr_message = array("result" => "failure", "message" => "查询银行列表数据为空!");
         $retcode = "0";
         //反馈状态 0 成功 200 自定义错误
     } else {
         $arr_message = array("result" => "success", "message" => "读取成功!");
         $retcode = "0";
         //反馈状态 0 成功 200 自定义错误
     }
     $arr_msg['msgbody']['result'] = $arr_message['result'];
     $arr_msg['msgbody']['message'] = $arr_message['message'];
     $arr_msg['msgbody']['msgallcount'] = $msgallcount;
     $arr_msg['msgbody']['msgdiscount'] = $msgdiscount + $msgstart;
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }
 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 CreateOrder($requestBody, $authorId, $payChannel)
 {
     $logger = Logger::getLogger("transfermoney");
     $logger->debug("开始创建转账付款订单");
     // 调用外部函数******
     $logger->debug("正在创建转账付款订单 : 调用函数GetPayCalcuInfo::readpaycardid,传入参数(" . $requestBody["cardReaderId"] . ", " . $authorId . ")");
     $agentInfo = GetPayCalcuInfo::readpaycardid($requestBody["cardReaderId"], $authorId);
     $logger->debug("正在创建转账付款订单 : 调用函数GetPayCalcuInfo::readpaycardid,返回的结果" . print_r($agentInfo, true));
     // ******调用外部函数
     $cardReaderId = $agentInfo["paycardid"];
     // 刷卡器ID
     $agentId = $agentInfo["cusid"];
     // 代理商ID
     $payChannelFee = 0;
     switch ($payChannel) {
         case "YiBao":
             $payChannelFee = YiBaoPay::GetPayFee($requestBody['payMoney']);
             break;
     }
     $orderId = "tfbtfs" . date("YmdHiss") . mt_rand(1000, 9999);
     // 调用外部函数******
     $orderListNumber = makeorderno("transfermoneyglist", "tfmglist", "tfs");
     // ******调用外部函数
     $payDate = date("Y-m-d H:i:s");
     $feeMoney = 0;
     // 调用外部函数******
     $logger->debug("正在创建转账付款订单 : 调用函数getbankid,传入参数(" . $requestBody["receiveBankName"] . ")");
     $receiveBankId = getbankid(u2g($requestBody["receiveBankName"]));
     if ($receiveBankId == "") {
         ErrorReponse::reponError(array("retcode" => "200", "retmsg" => "不支持的银行"));
     }
     $logger->debug("正在创建转账付款订单 : 调用函数getbankid,返回的结果" . $receiveBankId);
     $logger->debug("正在创建转账付款订单 : 调用函数GetPayCalcuInfo :: readPayFee,传入参数({$authorId}, {$receiveBankId}, " . $requestBody['transferMoney'] . ", " . $requestBody['arriveId'] . ", 2, " . $requestBody["payType"] . ")");
     $payChannelFeeInfo = GetPayCalcuInfo::readPayFee($authorId, $receiveBankId, $requestBody['transferMoney'], $requestBody['arriveId'], 2, $requestBody["payType"]);
     $logger->debug("正在创建转账付款订单 : 调用函数GetPayCalcuInfo :: readPayFee,返回的结果" . print_r($payChannelFeeInfo, true));
     if (is_array($payChannelFeeInfo)) {
         $feeMoney = $payChannelFeeInfo["feemoney"];
     }
     $arriveDate = GetPayCalcuInfo::getfeedate($payDate, $payChannelFeeInfo['addday']);
     $logger->debug("正在创建转账付款订单 : 调用函数GetPayCalcuInfo :: getfeedate,返回的结果" . $arriveDate);
     // ******调用外部函数
     $query = "INSERT INTO tb_transfermoneyglist (fd_tfmglist_no, fd_tfmglist_bkordernumber, fd_tfmglist_payrq, fd_tfmglist_paycardid, fd_tfmglist_authorid, fd_tfmglist_sdcrid, fd_tfmglist_sdcrpayfeemoney, fd_tfmglist_sdcragentfeemoney, fd_tfmglist_paytype, fd_tfmglist_paydate, fd_tfmglist_payfeedirct, fd_tfmglist_fucardno, fd_tfmglist_fucardbank, \n\t\tfd_tfmglist_fucardmobile, fd_tfmglist_fucardman, \n\t\tfd_tfmglist_shoucardno, fd_tfmglist_shoucardbank, \n\t\tfd_tfmglist_shoucardman, fd_tfmglist_shoucardmobile, fd_tfmglist_sendsms, fd_tfmglist_shoucardmemo, fd_tfmglist_current, fd_tfmglist_paymoney, fd_tfmglist_payfee, fd_tfmglist_money, fd_tfmglist_feebankid, fd_tfmglist_arrivedate, fd_tfmglist_arriveid, fd_tfmglist_state) VALUES \n\t\t('{$orderListNumber}', '{$orderId}', '01', \n\t\t'{$cardReaderId}', {$authorId}, 3, {$payChannelFee}, \n\t\t0.00, '" . $requestBody["payType"] . "', '{$payDate}', 'f', \n\t\t'" . $requestBody["sendBankCardId"] . "', '" . $requestBody["sendBankName"] . "', \n\t\t'" . $requestBody["sendPhone"] . "', '" . $requestBody["sendPersonName"] . "', \n\t\t'" . $requestBody["receiveBankCardId"] . "', '" . $requestBody["receiveBankName"] . "', \n\t\t'" . $requestBody["receivePersonName"] . "', '" . $requestBody["receivePhone"] . "', 0, '', \n\t\t'RMB', " . $requestBody["transferMoney"] . ", {$feeMoney}, " . $requestBody["payMoney"] . ", {$receiveBankId}, \n\t\t'{$arriveDate}', '" . $requestBody['arriveId'] . "', '0')";
     $logger->debug("新增数据进 tb_transfermoneyglist 的sql" . $query);
     $db = new DB_test();
     $db->query(u2g($query));
     return $orderId;
 }
 function authorReg()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $aumobile = trim($arr_body['aumobile']);
     $aupassword = trim(md5($arr_body['aupassword']));
     $autruename = u2g(trim($arr_body['autruename']));
     $auidcard = trim($arr_body['auidcard']);
     $auemail = trim($arr_body['auemail']);
     $query = "select 1 from tb_author  where fd_author_username = '******'";
     $db->query($query);
     if ($db->nf()) {
         $arr_message = array("result" => "failure", "message" => "该手机号码已注册");
         $retcode = "200";
         //反馈状态 0 成功 200 自定义错误
         $havemobile = 1;
     } else {
         $havemobile = 0;
     }
     if ($havemobile != 1) {
         $query = "insert into tb_author (fd_author_password ,fd_author_mobile ,fd_author_truename,\n\t\t\t\t\t\t\t          fd_author_idcard,fd_author_email ,fd_author_username,fd_author_regtime,fd_author_datetime \n\t\t\t\t\t\t\t          )values( '{$aupassword}' ,'{$aumobile}','{$autruename}','{$auidcard}','{$auemail}','{$aumobile}',now(),now())";
         $db->query($query);
         $listid = $db->insert_id();
         $sdcrid = 3;
         $auindustryid = 4;
         $slotpayfsetid = 8;
         $slotscdmsetid = 14;
         $bkcardpayfsetid = 25;
         $bkcardscdmsetid = 9;
         $memid = 3554;
         $shopid = 102;
         $authortypeid = 5;
         $query = "update tb_author set \n\t\t\t\t\t   fd_author_isstop='0'," . "fd_author_state = '9'," . "fd_author_sdcrid = '{$sdcrid}'," . "fd_author_auindustryid = '{$auindustryid}',\n\t\t               fd_author_slotpayfsetid = '{$slotpayfsetid}',\n\t\t               fd_author_slotscdmsetid = '{$slotscdmsetid}',\n\t\t\t\t\t   fd_author_bkcardpayfsetid='{$bkcardpayfsetid}',\n\t\t\t\t\t   fd_author_bkcardscdmsetid='{$bkcardscdmsetid}' ,\n\t\t\t\t\t   fd_author_couponstate      = 0   ," . "fd_author_memid          = '{$memid}'," . "fd_author_shopid         = '{$shopid}'," . "fd_author_authortypeid   = '{$authortypeid}' \n\t\t\t\t\t   \t\t\t\t\t\t\n\t\t\t\t\t   where fd_author_id='{$listid}'";
         $db->query($query);
         $arr_message = array("result" => "success", "message" => "恭喜您,注册成功!");
         $retcode = "0";
         //反馈状态 0 成功 200 自定义错误
     }
     $arr_msg['msgbody']['result'] = $arr_message['result'];
     $arr_msg['msgbody']['message'] = $arr_message['message'];
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }
 public function authorFeedbck()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $authorid = trim($arr_channelinfo['authorid']);
     $fdcontent = u2g(trim($arr_body['fdcontent']));
     $fdlinkmethod = u2g(trim($arr_body['fdlinkmethod']));
     $fdcontent = str_replace("'", "‘", $fdcontent);
     $fdcontent = str_replace("¥", "¥", $fdcontent);
     //addslashes
     $query = "insert into tb_feedback (fd_feedback_authorid ,fd_feedback_content ,fd_feedback_linkman,\n\t          fd_feedback_datetime)values( '{$authorid}' ,'{$fdcontent}','{$fdlinkmethod}',now())";
     $db->query($query);
     $arr_message = array("error_id" => "0", "result" => "success", "message" => "感谢您的宝贵意见!");
     $retcode = "0";
     //反馈状态 0 成功 200 自定义错误
     $arr_msg['msgbody']['result'] = $arr_message['result'];
     $arr_msg['msgbody']['message'] = $arr_message['message'];
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }
 public function modifyAuBkCardInfo()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $authorid = trim($arr_channelinfo['authorid']);
     $shoucardman = u2g(trim($arr_body['aushoucardman']));
     $shoucardphone = trim($arr_body['aushoucardphone']);
     $shoucardno = trim($arr_body['aushoucardno']);
     $shoucardbank = u2g(trim($arr_body['aushoucardbank']));
     $query = "select * from tb_author  where fd_author_id = '{$authorid}'  and fd_author_couponstate='1'";
     $db->query($query);
     if ($db->nf()) {
         $arr_message = array("result" => "failure", "message" => "银行卡资料已经审批,如需修改请联系客服!");
         $retcode = "200";
         //反馈状态 0 成功 200 自定义错误
         $Error = array('result' => 'failure', 'retcode' => '200', 'retmsg' => $arr_message['message']);
         $arr_msg['msgbody'] = array("result" => "failure", "message" => "银行卡资料已经审批,如需修改请联系客服!");
         $retcode = "200";
         //反馈状态 0 成功 200 自定义错误
         $returnvalue = array("msgbody" => $arr_msg['msgbody']);
         $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
         return $returnval;
         //$ErrorReponse->reponError($Error); //出错反馈
         //return false;
     }
     $query = "update tb_author set   fd_author_shoucardman = '{$shoucardman}',\n\t\t\t   fd_author_shoucardphone = '{$shoucardphone}',\n\t\t\t   fd_author_shoucardno='{$shoucardno}',\n\t\t\t   fd_author_shoucardbank='{$shoucardbank}',fd_author_couponstate = '0' where fd_author_id  = '{$authorid}' ";
     $db->query($query);
     $arr_msg['msgbody'] = array("error_id" => "0", "result" => "success", "message" => "恭喜您,我的银行卡修改成功!");
     $retcode = "0";
     //反馈状态 0 成功 200 自定义错误
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }
Beispiel #11
0
        }
        if ($openid) {
            if (!$user && $openid) {
                C::t('#aljwsq#aljwsq_user')->insert(array('nickname' => u2g($wuser['nickname']), 'username' => $_GET['username'], 'openid' => $openid, 'latitude' => $_GET['latitude'], 'longitude' => $_GET['longitude'], 'bindtime' => TIMESTAMP, 'sex' => $wuser['sex'], 'city' => u2g($wuser['city']), 'country' => u2g($wuser['country']), 'province' => u2g($wuser['province']), 'language' => $wuser['language'], 'headimgurl' => $wuser['headimgurl'], 'subscribe_time' => TIMESTAMP));
            } else {
                C::t('#aljwsq#aljwsq_user')->update($openid, array('nickname' => u2g($wuser['nickname']), 'username' => $_GET['username'], 'latitude' => $_GET['latitude'], 'longitude' => $_GET['longitude'], 'bindtime' => TIMESTAMP, 'sex' => $wuser['sex'], 'city' => u2g($wuser['city']), 'country' => u2g($wuser['country']), 'province' => u2g($wuser['province']), 'language' => $wuser['language'], 'headimgurl' => $wuser['headimgurl']));
            }
        }
        showmessage(lang('plugin/aljwsq', 'bind6'), 'forum.php?openid=' . $openid);
    } else {
        $binduser = DB::fetch_first('SELECT * FROM %t WHERE openid=%s', array('aljwsq_user', $openid));
        if ($binduser && $binduser['username']) {
            echo '<script>alert("' . $config['albindtips'] . '");location.href="forum.php?mobile=2&openid=' . $openid . '"</script>';
            exit;
        }
        $_GET['nickname'] = u2g($_GET['nickname']);
        include template('aljwsq:bind');
    }
} else {
    if ($_GET['act'] == 'showqcode') {
        include template('aljwsq:showqcode');
    } else {
        if ($_GET['act'] == 'qrcode') {
            if ($_GET['qid']) {
                DB::query('update %t set num = num+1 where id=%d', array('aljwsq_qrcode', $_GET['qid']));
                $qrcode = C::t('#aljwsq#aljwsq_qrcode')->fetch($_GET['qid']);
                header('Location: ' . $qrcode['url']);
            }
        }
    }
}
<?php

require "../include/common.inc.php";
require "../include/json.php";
header('Content-Type:text/html;charset=utf-8');
$db = new db_test();
$prov = u2g(unescape($prov));
$query = "select fd_china_city as city  from tb_china  where fd_china_prov = '{$prov}'\n                   group by fd_china_city order by fd_china_areacode asc";
$db->query($query);
if ($db->nf()) {
    while ($db->next_record()) {
        $arr_city_code = g2u($db->f(city));
        $arr_city_name = g2u($db->f(city));
        $select[] = array("id" => $arr_city_code, "title" => $arr_city_name);
    }
}
if (empty($select)) {
    $select[] = array("id" => "", "title" => "");
}
echo json_encode($select);
 function payagentOrderRq()
 {
     global $weburl;
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $authorid = trim($arr_channelinfo['authorid']);
     $agentid = trim($arr_channelinfo['agentid']);
     $paytype = 'agentbuy';
     $orderprodureid = trim($arr_body['orderprodureid']);
     //支付类型id
     $ordernum = trim($arr_body['ordernum']);
     //充值金额
     $orderprice = trim(u2g($arr_body['orderprice']));
     //实际支付金额
     $ordermoney = trim(u2g($arr_body['ordermoney']));
     //订单金额
     $orderfucardno = trim(u2g($arr_body['orderfucardno']));
     //认证信息
     $orderfucardbank = trim(u2g($arr_body['orderfucardbank']));
     //认证信息
     $ordermemo = trim(u2g($arr_body['ordermemo']));
     //认证信息
     $agentno = trim(u2g($arr_body['agentno']));
     //认证信息
     $arr_paycard = GetPayCalcuInfo::readpaycardid($arr_body['paycardid'], $authorid);
     //刷卡器设备号
     $paycardid = $arr_paycard['paycardid'];
     //刷卡器id
     $cusid = trim($arr_paycard['cusid']);
     //代理商
     $ordermemo = "自订刷卡器" . $ordernum;
     $bkmoney = $ordermoney;
     //promoney+yunmoney
     $paymoney = $ordermoney;
     $listno = makeorderno("salelist", "selt", "xs");
     $arr_bkinfo = BankPayInfo::bankpayorder($authorid, $paycardid, $bkmoney, $orderfucardno);
     $bkntno = trim($arr_bkinfo['bkntno']);
     $sdcrid = trim($arr_bkinfo['sdcrid']);
     $datetime = date("Y-m-d H:i:s");
     $date = date("Y-m-d");
     $bkorderNumber = trim($arr_bkinfo['bkorderNumber']);
     $type = "app";
     //自订
     $datadetailArray['fd_selt_paytype'] = $paytype;
     $datadetailArray['fd_selt_no'] = $listno;
     $datadetailArray['fd_selt_authorid'] = $authorid;
     $datadetailArray['fd_selt_bkntno'] = $bkntno;
     $datadetailArray['fd_selt_date'] = $date;
     $datadetailArray['fd_selt_payrq'] = '01';
     //刚请求的交易码状态为01
     $datadetailArray['fd_selt_bkordernumber'] = $bkorderNumber;
     $datadetailArray['fd_selt_sdcrid'] = $sdcrid;
     $datadetailArray['fd_selt_produreid'] = $orderprodureid;
     $datadetailArray['fd_selt_allquantity'] = $ordernum;
     $datadetailArray['fd_selt_saleprice'] = $orderprice;
     $datadetailArray['fd_selt_fucardno'] = $orderfucardno;
     $datadetailArray['fd_selt_fucardbank'] = $orderfucardbank;
     $datadetailArray['fd_selt_memo'] = u2g($ordermemo);
     $datadetailArray['fd_selt_datetime'] = $datetime;
     $datadetailArray['fd_selt_cusid'] = $agentid;
     //代理商id
     $datadetailArray['fd_selt_paymoney'] = $paymoney;
     //代理商id
     $datadetailArray['fd_selt_authorid'] = $authorid;
     //代理商id
     $datadetailArray['fd_selt_type'] = $type;
     $datadetailArray['fd_selt_skfs'] = '5';
     //在线支付
     $db->insert("tb_salelist", $datadetailArray);
     $listid = $db->insert_id();
     $arr_message = array("result" => "success", "message" => "请求交易码成功!");
     $retcode = "0";
     //反馈状态 0 成功 200 自定义错误
     $arr_msg['msgbody']['result'] = $arr_message['result'];
     $arr_msg['msgbody']['message'] = $arr_message['message'];
     $arr_msg['msgbody']['bkntno'] = $bkntno;
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }
 function RechaMoneyRq()
 {
     global $weburl;
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $authorid = trim($arr_channelinfo['authorid']);
     $paytype = 'qqrecharge';
     $paycardid = trim($arr_body['paycardid']);
     $paytypeid = trim($arr_body['rechapaytypeid']);
     //支付类型id
     $rechamoney = trim($arr_body['rechamoney']);
     //充值金额
     $rechapaymoney = trim(u2g($arr_body['rechapaymoney']));
     //实际支付金额
     $rechaqq = trim(u2g($arr_body['rechaqq']));
     //充值手机号码
     $qqhasrechamoney = $this->readQQhasRechamoney($rechaqq);
     $allqqremoney = $qqhasrechamoney + $rechamoney;
     if ($allqqremoney > 5000) {
         $retcode = "200";
         $arr_msg['msgbody']['result'] = "failure";
         $arr_msg['msgbody']['message'] = "对不起,每个QQ号码每天累计充值Q币数不能大于5000!";
         $returnvalue = array("msgbody" => $arr_msg['msgbody']);
         $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
         return $returnval;
     }
     $rechaqqprov = trim($arr_body['rechaqqprov']);
     //手机所属地区
     $rechabkcardno = trim(u2g($arr_body['rechabkcardno']));
     //银行卡号
     $rechabkcardid = trim($arr_body['rechabkcardid']);
     //银行卡关联id tb_banckcard.fd_bankcard_id
     $merReserved = trim(u2g($arr_body['merReserved']));
     //认证信息
     // $current = trim($arr_body['current']); //币种
     // $paycardid = trim(GetPayCalcuInfo::readpaycardid($paycardid)); //刷卡器设备号
     $arr_paycard = GetPayCalcuInfo::readpaycardid($arr_body['paycardid'], $authorid);
     //刷卡器设备号
     $paycardid = $arr_paycard['paycardid'];
     //刷卡器id
     $cusid = trim($arr_paycard['cusid']);
     //代理商
     $paycardkey = trim($arr_paycard['paycardkey']);
     //刷卡器key
     //$feebankid = getbankid($shoucardbank); //获得银行id返回string
     $onepayfee = $this->readRechacostmoney($rechamoney);
     $payfee = $onepayfee * $rechamoney;
     //金额也就是数量
     $bkmoney = $rechapaymoney;
     $arr_bkinfo = BankPayInfo::bankpayorder($authorid, $paycardid, $bkmoney, $rechabkcardno);
     $bkntno = trim($arr_bkinfo['bkntno']);
     $sdcrid = trim($arr_bkinfo['sdcrid']);
     $sdcrpayfee = substr($arr_bkinfo['sdcrpayfee'], 0, -1);
     //银联收取明盛浮动费率
     $sdcrpayfeemoney = $bkmoney * $sdcrpayfee / 100 > $arr_bkinfo['minsdcrpayfee'] ? $bkmoney * $sdcrpayfee / 100 : $arr_bkinfo['minsdcrpayfee'];
     $paydate = date("Y-m-d H:i:s");
     $today = date("Ymd");
     //$bkmoney  =
     $bkorderNumber = trim($arr_bkinfo['bkorderNumber']);
     $listno = makeorderno("qqrechargelist", "mrclist", "mrc");
     $datadetailArray['fd_mrclist_no'] = $listno;
     $datadetailArray['fd_mrclist_paycardid'] = $paycardid;
     $datadetailArray['fd_mrclist_authorid'] = $authorid;
     $datadetailArray['fd_mrclist_bkntno'] = $bkntno;
     $datadetailArray['fd_mrclist_paydate'] = $paydate;
     $datadetailArray['fd_mrclist_payrq'] = '01';
     //刚请求的交易码状态为01
     $datadetailArray['fd_mrclist_paytypeid'] = $paytypeid;
     //手机充值支付类型 跟paytype 无任何关系
     $datadetailArray['fd_mrclist_paytype'] = $paytype;
     //业务类型
     $datadetailArray['fd_mrclist_bkordernumber'] = $bkorderNumber;
     $datadetailArray['fd_mrclist_sdcrpayfeemoney'] = $sdcrpayfeemoney;
     $datadetailArray['fd_mrclist_sdcrid'] = $sdcrid;
     $datadetailArray['fd_mrclist_rechamoney'] = $rechamoney;
     $datadetailArray['fd_mrclist_bkmoney'] = $bkmoney;
     $datadetailArray['fd_mrclist_qq'] = $rechaqq;
     $datadetailArray['fd_mrclist_paymoney'] = $rechapaymoney;
     $datadetailArray['fd_mrclist_payfee'] = $payfee;
     $datadetailArray['fd_mrclist_qqprov'] = u2g($rechaqqprov);
     $datadetailArray['fd_mrclist_bankcardno'] = $rechabkcardno;
     $datadetailArray['fd_mrclist_bankcardid'] = $rechabkcardid;
     $datadetailArray['fd_mrclist_bankcardbank'] = $rechabkcardname;
     $datadetailArray['fd_mrclist_date'] = $today;
     $datadetailArray['fd_mrclist_datetime'] = $paydate;
     $datadetailArray['fd_mrclist_cusid'] = $cusid;
     $db->insert("tb_qqrechargelist", $datadetailArray);
     $listid = $db->insert_id();
     //$listid = $db->insert_id();
     // $method = 'in';
     // $method = u2g($method);
     //$gettrue = AgentPayglist :: insertPayglist($this->reqxmlcontext, $bkntno, $listid, $ccgno, $paytype, $method, $arr_feeinfo);
     $arr_message = array("result" => "success", "message" => "请求交易码成功!");
     $retcode = "0";
     //反馈状态 0 成功 200 自定义错误
     $arr_msg['msgbody']['result'] = $arr_message['result'];
     $arr_msg['msgbody']['message'] = $arr_message['message'];
     $arr_msg['msgbody']['bkntno'] = $bkntno;
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }
Beispiel #15
0
$wechatuser = C::t('#wechat#common_member_wechat')->fetch_by_openid($postObj->FromUserName);
$user = C::t('#aljwsq#aljwsq_user')->fetch($postObj->FromUserName);
echo $this->responsetext(123);
exit;
if (empty($wechatuser) && empty($user)) {
    loaducenter();
    $username = '******' . random(5);
    $return = register($username);
    WeChatHook::bindOpenId($return['uid'], $postObj->FromUserName, 1);
    require_once 'source/plugin/aljwsq/function_core.php';
    $wuser = getwuserinfo($postObj, $config['appid'], $config['appsecret']);
    $user = C::t('#aljwsq#aljwsq_user')->fetch($postObj->FromUserName);
    if (!$user) {
        C::t('#aljwsq#aljwsq_user')->insert(array('nickname' => u2g($wuser['nickname']), 'username' => $username, 'openid' => $postObj->FromUserName, 'bindtime' => TIMESTAMP, 'sex' => $wuser['sex'], 'city' => u2g($wuser['city']), 'country' => u2g($wuser['country']), 'province' => u2g($wuser['province']), 'language' => $wuser['language'], 'headimgurl' => $wuser['headimgurl'], 'subscribe_time' => $wuser['subscribe_time']));
    } else {
        C::t('#aljwsq#aljwsq_user')->update($postObj->FromUserName, array('nickname' => u2g($wuser['nickname']), 'username' => $username, 'bindtime' => TIMESTAMP, 'sex' => $wuser['sex'], 'city' => u2g($wuser['city']), 'country' => u2g($wuser['country']), 'province' => u2g($wuser['province']), 'language' => $wuser['language'], 'headimgurl' => $wuser['headimgurl'], 'subscribe_time' => $wuser['subscribe_time']));
    }
    echo $this->responsetext($postObj, '您已成功注册本站帐号,用户名' . $return['username'] . ',密码' . $return['password'] . '.此帐户已与微信帐户成功绑定,并支持微信扫码登录.');
} else {
    if (empty($user)) {
        $user = getuserbyuid($wechatuser['uid']);
    }
    echo $this->responsetext($postObj, '您已成功注册过帐号,用户名' . $user['username']);
}
function g2u($a)
{
    return is_array($a) ? array_map('g2u', $a) : diconv($a, CHARSET, 'UTF-8');
}
function u2g($a)
{
    return is_array($a) ? array_map('u2g', $a) : diconv($a, 'UTF-8', CHARSET);
Beispiel #16
0
{
    $language = 'text';
    $lans = C('EDIT_CONF.EDIT_ALLOW_TYPE');
    foreach ($lans as $lan => $exts) {
        foreach ($exts as $ex) {
            if ($ext == $ex) {
                $language = $lan;
                break 2;
            }
        }
    }
    return $language;
}
$file = array();
$file['file_utf'] = trim($_REQUEST['file']);
$file['file'] = u2g($file['file_utf']);
$file['content'] = file($file['file']);
$file['encode'] = get_encode($file['file']);
$file['line'] = count($file['content']);
$file['size'] = dealsize(filesize($file['file']));
$file['chmod'] = substr(sprintf('%o', @fileperms($file['file'])), -4);
$file['language'] = get_language(get_ext($file['file']));
if ('GB2312' == $file['encode']) {
    $file['encode_selected']['UTF-8'] = '';
    $file['encode_selected']['GB2312'] = 'selected="selected"';
} else {
    $file['encode_selected']['UTF-8'] = 'selected="selected"';
    $file['encode_selected']['GB2312'] = '';
}
//
$textarea = array();
 public function modifyAuthorInfo()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $authorid = trim($arr_channelinfo['authorid']);
     $agentid = trim($arr_channelinfo['agentid']);
     $autruename = u2g(trim($arr_body['autruename']));
     $auidcard = trim($arr_body['auidcard']);
     $auemail = trim($arr_body['auemail']);
     $query = "update tb_author set fd_author_truename = '{$autruename}',fd_author_idcard = '{$auidcard}',\n\t\t\t          fd_author_email = '{$auemail}' where fd_author_id  = '{$authorid}' ";
     $db->query($query);
     $arr_merinfo['fd_cus_allname'] = $arr_body['agentcompany'];
     $arr_merinfo['fd_cus_address'] = $arr_body['agentarea'];
     $arr_merinfo['fd_cus_shaddress'] = $arr_body['agentaddress'];
     $arr_merinfo['fd_cus_manphone'] = $arr_body['agentmanphone'];
     $arr_merinfo['fd_cus_fax'] = $arr_body['agentfax'];
     $wherequery = "fd_cus_id  = '{$agentid}'";
     $db->update("tb_customer", $arr_merinfo, $wherequery);
     $arr_msg['msgbody'] = array("error_id" => "0", "result" => "success", "message" => "恭喜您,用户修改成功!");
     $retcode = "0";
     //反馈状态 0 成功 200 自定义错误
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }
 public function readAccglistdetail()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $acctypeid = trim($arr_body['acctypeid']);
     $authorid = trim($arr_channelinfo['authorid']);
     $msgstart = trim($arr_body['msgstart']) + 0;
     $msgdisplay = trim($arr_body['msgdisplay']) + 0;
     //echo var_dump($arr_body);
     $accyear = substr(trim($arr_body['accmonth']), 0, 4);
     $accmonth = str_replace($accyear, "", $arr_body['accmonth']);
     if ($acctypeid == 'coupon') {
         $wherequery1 = " and 1=2";
     }
     if ($acctypeid == 'recharge') {
         $wherequery2 = " and 1=2";
     }
     if ($msgdisplay == 0) {
         $msgdisplay = 100;
     }
     $paytype = '充值';
     $paytype = u2g($paytype);
     $paytype3 = '订单支付';
     $paytype3 = u2g($paytype);
     $paytype1 = '购买抵用券';
     $paytype1 = u2g($paytype1);
     $paystate = '交易完成';
     $paystate = u2g($paystate);
     $query = "select * from (select fd_accglist_bkordernumber as accglistno," . " case \n        when fd_accglist_paytype ='coupon' then '购买抵用券'\n        when fd_accglist_paytype ='creditcard' then '信用卡还款'" . "when fd_accglist_paytype ='recharge' then   '" . $paytype . "'" . "when fd_accglist_paytype ='pay' then       '还贷款'" . "when fd_accglist_paytype ='order' then '" . $paytype3 . "'" . "when fd_accglist_paytype ='tfmg' then '转账汇款'\n        else '其他业务' END  accgpaymode," . " \n\t\t\t\t                    fd_accglist_datetime as accglistdate , fd_accglist_id as  accglistid ,\n\t\t\t\t                    (fd_accglist_money) as accglistmoney,'" . $paystate . "' as accgstate,'' as accgtype,'' as accgmemo ," . " 'testbank' as accgcardbank,'testno' as accgcardno   \n\t\t\t\t\t\t\t        from tb_authoraccountglist where year(fd_accglist_datetime) = '{$accyear}' and \n\t\t\t\t\t\t\t\t\tmonth(fd_accglist_datetime) = '{$accmonth}' and fd_accglist_authorid='{$authorid}' {$wherequery1} \n\t\t\t\t              " . " union all  select fd_couponsale_bkordernumber as couponno,'" . $paytype1 . "' as accgpaymode ,fd_couponsale_datetime as coupondate," . "fd_couponsale_id as couponid, CONCAT_WS('=',CONCAT_WS('*',(fd_couponsale_money/fd_coupon_money),fd_coupon_money),fd_couponsale_money+0) as couponmoney,'" . $paystate . "','' as accgtype,'' as accgmemo ,'testbank' as accgcardbank,'testno' as accgcardno \n\t\t\t                from \n\t\t\t       tb_couponsale left join tb_coupon on fd_coupon_id =fd_couponsale_couponid where fd_couponsale_authorid = '{$authorid}' and fd_couponsale_payrq = '00' and fd_couponsale_isagentpay = '0'" . " and year(fd_couponsale_datetime) = '{$accyear}' and \n\t\t\t\t\t\t\t\t\tmonth(fd_couponsale_datetime) = '{$accmonth}' {$wherequery2}) as a order by accglistdate desc ";
     $db->query($query);
     $msgallcount = $db->nf();
     //$query = " $query  limit $msgstart,$msgdisplay ";
     //$db->query($query);
     $msgdiscount = $db->nf();
     //  echo $query;
     //  echo $query;
     $arr_msg = auto_charset($db->getData('', 'msgbody'), 'gbk', 'utf-8');
     $arr_message = array("result" => "success", "message" => "读取成功!");
     $retcode = "0";
     //反馈状态 0 成功 200 自定义错误
     $arr_msg['msgbody']['result'] = $arr_message['result'];
     $arr_msg['msgbody']['message'] = $arr_message['message'];
     $arr_msg['msgbody']['msgallcount'] = $msgallcount;
     $arr_msg['msgbody']['msgdiscount'] = $msgdiscount + $msgstart;
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }
Beispiel #19
0
            if ($result) {
                $data['statusCode'] = 200;
                $data['message'] = '<font color="green">新建成功:</font><font color="red">' . g2u(basename($name)) . '</font><br />';
            } else {
                $data['statusCode'] = 300;
                $data['message'] = '<font color="blue">新建失败:</font><font color="red">错误原因未知</font><br />';
            }
        }
    } else {
        $data['statusCode'] = 300;
        $data['message'] = '<font color="blue">操作失败:</font><font color="red">未知操作指令</font><br />';
    }
    $data['message'] .= '<font color="green">执行耗时:</font><font color="red">' . G('_run_start', '_run_end', 6) . ' 秒</font><br />';
    exit(json_encode($data));
} elseif ('imageview' == $action) {
    $file = u2g(trim($_REQUEST['file']));
    require INC_ROOT . 'Image.class.php';
    $Image = new Image();
    $thumbFile = DATA_CACHE_PATH . substr(md5($file), 2, 12) . '.' . get_ext($file);
    if (false !== strpos($file, 'data/Cache/')) {
        $Image->showImg(DATA_CACHE_PATH . basename($file), '', 120, 100);
        //die();
    } else {
        if (!is_file($thumbFile)) {
            $Image->thumb($file, $thumbFile, get_ext($file), 120, 100, true);
        }
        if (!$Image->showImg($thumbFile, '', 120, 100)) {
            $Image->showImg(DATA_PUBLIC_PATH . 'nothumb.png', '', 120, 100);
        }
        if (C('CACHE_DATA_DEL')) {
            unlink($thumbFile);
Beispiel #20
0
<?php

header('Content-Type:text/html;charset=GB2312');
require "../include/common.inc.php";
require "union.php";
$value = u2g($value);
$menufile = "../include/menuarryfile.php";
$menuarry = file($menufile);
//1001±1±地区设置±ico_main_hr.gif±../basic/jxc_area_b.php±0±
//1001代号、1为上级代号、地区设置为名称、ico_main_hr.gif为图片
//../basic/jxc_area_b.php连接地址、0为是否为最底
for ($i = 0; $i < count($menuarry); $i++) {
    $temp_arr1 = $menuarry[$i];
    $temp_arr2 = explode("±", $temp_arr1);
    $a = $temp_arr2[0];
    if ($loginusermenu[$a][item] == 1) {
        // 得出菜单
        if (strstr($temp_arr2[2], $value) and $temp_arr2[4] != "") {
            $arrname[] = $temp_arr2[2];
            $arrprogram[] = $temp_arr2[4];
            $arrunder[] = $temp_arr2[5];
        } else {
            $arrall[$a][code] = $a;
            if (empty($temp_arr2[1])) {
                $arrall[$a][fcode] = 0;
            } else {
                $arrall[$a][fcode] = $temp_arr2[1];
            }
            $arrall[$a][name] = $temp_arr2[2];
            $arrall[$a][icon] = $temp_arr2[3];
            $arrall[$a][program] = $temp_arr2[4];
Beispiel #21
0
if (empty($num) || $_GET['autoact'] == 'reflash') {
    C::t('#aljwsq#aljwsq_citylist')->truncate();
    $apiurl = 'http://mobile.weather.com.cn/js/citylist.xml';
    $ch = curl_init($apiurl);
    curl_setopt($ch, CURLOPT_TIMEOUT, 60);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    $citystr = curl_exec($ch);
    curl_close($ch);
    $cityobj = simplexml_load_string($citystr);
    $len = count($cityobj->c->d);
    for ($i = 0; $i < $len; $i++) {
        if (CHARSET == 'gbk') {
            $d1 = u2g((array) $cityobj->c->d[$i]->attributes()->d1);
            $d2 = u2g((array) $cityobj->c->d[$i]->attributes()->d2);
            $d3 = u2g((array) $cityobj->c->d[$i]->attributes()->d3);
            $d4 = u2g((array) $cityobj->c->d[$i]->attributes()->d4);
        } else {
            $d1 = (array) $cityobj->c->d[$i]->attributes()->d1;
            $d2 = (array) $cityobj->c->d[$i]->attributes()->d2;
            $d3 = (array) $cityobj->c->d[$i]->attributes()->d3;
            $d4 = (array) $cityobj->c->d[$i]->attributes()->d4;
        }
        if ($d1[0]) {
            C::t('#aljwsq#aljwsq_citylist')->insert(array('d1' => $d1[0], 'd2' => $d2[0], 'd3' => $d3[0], 'd4' => $d4[0]));
        }
    }
}
function g2u($a)
{
    return is_array($a) ? array_map('g2u', $a) : diconv($a, CHARSET, 'UTF-8');
}
 static function getrechargeSale($xml, $listno, $listid, $paytype = 'recharge', $bkntno, $arr_feeinfo)
 {
     $db = new DB_test();
     $Publiccls = new PublicClass();
     //初始化类实例
     $arr_xml = $Publiccls->xml_to_array($xml);
     $arr_channelinfo = $arr_xml['operation_request']['msgheader']['channelinfo'];
     $arr_body = $arr_xml['operation_request']['msgbody'];
     $paycardid = trim(GetPayCalcuInfo::readpaycardid($arr_body['paycardid']));
     $authorid = trim($arr_channelinfo['authorid']);
     //操作者
     $paydate = trim(date("Y-m-d"));
     //交易日期
     $fucardbank = u2g(trim($arr_body['bankname']));
     //银行名
     $paymoney = trim($arr_body['paymoney'] + 0);
     //交易摘要
     $fucardno = trim($arr_body['cardno']);
     //银行号
     $banktype = trim($arr_body['banktype']);
     //银行号
     $fucardphone = trim($arr_body['cardmobile']);
     //银行号
     $fucardman = u2g(trim($arr_body['cardman']));
     //银行号
     $arrivedate = $arr_feeinfo['arrivedate'];
     $paydate = $arr_feeinfo['paydate'];
     $bkmoney = $arr_feeinfo['bkmoney'];
     $payfeedirct = $arr_feeinfo['payfeedirct'];
     $bkordernumber = $arr_feeinfo['bkordernumber'];
     $sdcrid = $arr_feeinfo['sdcrid'];
     $sdcrpayfeemoney = $arr_feeinfo['sdcrpayfeemoney'];
     $payfee = $arr_feeinfo['feemoney'];
     $paymoney = $arr_feeinfo['paymoney'];
     $money = round($paymoney + $payfee, 2);
     $method = 'in';
     $method = u2g($method);
     $paytype = 'recharge';
     $query1 = "insert into tb_agentpaymoneylist(\n\t\t\t\t\tfd_agpm_no\t\t\t,fd_agpm_paycardid\t\t,fd_agpm_authorid\t ,\n\t\t\t\t\tfd_agpm_paydate\t    ,fd_agpm_shoucardno\t    ,fd_agpm_fucardno\t ,\n\t\t\t\t\tfd_agpm_bkntno\t\t,fd_agpm_payrq          ,fd_agpm_paytype     ,\n\t\t\t\t\tfd_agpm_current\t    ,fd_agpm_paymoney\t\t,fd_agpm_payfee\t\t ,\n\t\t\t\t\tfd_agpm_money\t\t,fd_agpm_shoucardbank   ,fd_agpm_shoucardman ,\n\t\t\t\t\tfd_agpm_shoucardmobile,fd_agpm_fucardbank\t,fd_agpm_fucardmobile,\n\t\t\t\t\tfd_agpm_fucardman   ,fd_agpm_feebankid      ,fd_agpm_state       ,\n\t\t\t\t\tfd_agpm_listid      ,fd_agpm_listno         ,fd_agpm_method      ,\n\t\t\t\t\tfd_agpm_datetime    ,fd_agpm_payfeedirct    ,fd_agpm_arrivedate  ," . "fd_agpm_bkordernumber,fd_agpm_bkmoney ,fd_agpm_sdcrid      ," . "fd_agpm_sdcrpayfeemoney)values\n\t\t\t\t\t('{$listno}'\t\t,'{$paycardid}'\t,'{$authorid}'\t\t,\n\t\t\t\t\tnow()\t\t,'{$shoucardno}'\t,'{$fucardno}'\t\t,\n\t\t\t\t\t'{$bkntno}'\t\t,'01'\t\t\t,'{$paytype}'\t\t\t,\n\t\t\t\t\t'{$current}'\t\t,'{$paymoney}'\t,'{$payfee}'\t\t\t,\n\t\t\t\t\t'{$paymoney}'\t\t\t,'{$shoucardbank}','{$shoucardman}'\t\t,\n\t\t\t\t\t'{$shoucardmobile}','{$fucardbank}'\t,'{$fucardphone}'  \t,\n\t\t\t\t\t'{$fucardman}'\t\t,'{$feebankid}'\t,'0'\t            ,\t\t\n\t\t\t\t\t'{$listid}'\t\t,'{$listno}'\t    ,'{$method}'\t,now()  ," . "'{$payfeedirct}'   ,'{$arrivedate}'  , '{$bkordernumber}'  , " . "'{$bkmoney}'   ,'{$sdcrid}' ,'{$sdcrpayfeemoney}'   \t\t\t)";
     $db->query($query1);
     return 1;
 }
 public function couponSale()
 {
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $authorid = $arr_channelinfo['authorid'];
     $couponid = trim($arr_body['couponid']);
     $paymoney = trim($arr_body['couponmoney']);
     //$paycardid = trim(GetPayCalcuInfo::readpaycardid($arr_body['paycardid']));
     $arr_paycard = GetPayCalcuInfo::readpaycardid($arr_body['paycardid'], $authorid);
     //刷卡器设备号
     $paycardid = $arr_paycard['paycardid'];
     //刷卡器id
     $cusid = trim($arr_paycard['cusid']);
     //代理商
     $paycardkey = trim($arr_paycard['paycardkey']);
     //刷卡器key
     $fucardno = trim($arr_body['creditcardno']);
     $fubank = trim(u2g($arr_body['creditbank']));
     $fucardman = trim(u2g($arr_body['creditcardman']));
     $fucardphone = trim(u2g($arr_body['creditcardphone']));
     $paytype = 'coupon';
     $req_appenv = trim($arr_header['req_appenv']);
     // echo "fdf";
     $checkbankinfo = $this->checkshoubankinfo($authorid, $req_appenv);
     //检测我的银行卡信息有没填写
     $arr_feeinfo = GetPayCalcuInfo::readPayFee($authorid, "", $paymoney, "", 5);
     //获取手续费信息返回array
     if (is_array($arr_feeinfo)) {
         $feemoney = $arr_feeinfo['feemoney'];
     }
     $allmoney = round($paymoney + $feemoney, 2);
     $arr_arrive = GetPayCalcuInfo::readarrive($arr_feeinfo['arriveid']);
     $paydate = date("Y-m-d H:i:s");
     $arrivedate = GetPayCalcuInfo::getfeedate($paydate, $arr_feeinfo['addday']);
     $payfeedirct = $arr_feeinfo['defeedirct'];
     if ($arr_feeinfo['defeedirct'] == 's') {
         $bkmoney = $paymoney;
     } else {
         $bkmoney = $allmoney;
     }
     $arr_feeinfo['arrivedate'] = $arrivedate;
     $arr_feeinfo['paydate'] = $paydate;
     $arr_feeinfo['bkmoney'] = $bkmoney;
     $arr_feeinfo['payfeedirct'] = $payfeedirct;
     $payfee = $feemoney;
     $arr_bkinfo = BankPayInfo::bankpayorder($authorid, $paycardid, $paymoney, $fucardno);
     $arr_authorinfo = AuToken::getauthorusername($authorid);
     $arr_feeinfo['shoucardno'] = $shoucardno = $arr_authorinfo['shoucardno'];
     $arr_feeinfo['shoucardmobile'] = $shoucardmobile = $arr_authorinfo['shoucardmobile'];
     $arr_feeinfo['shoucardbank'] = $shoucardbank = $arr_authorinfo['shoucardbank'];
     $arr_feeinfo['shoucardman'] = $shoucardman = $arr_authorinfo['shoucardman'];
     $bkntno = trim($arr_bkinfo['bkntno']);
     $arr_feeinfo['bkordernumber'] = $bkordernumber = $arr_bkinfo['bkorderNumber'];
     $arr_feeinfo['bkmoney'] = $bkmoney = $paymoney;
     $arr_feeinfo['sdcrid'] = $sdcrid = trim($arr_bkinfo['sdcrid']);
     $sdcrpayfee = substr($arr_bkinfo['sdcrpayfee'], 0, -1);
     //银联收取明盛浮动费率
     $arr_feeinfo['sdcrpayfeemoney'] = $sdcrpayfeemoney = $bkmoney * $sdcrpayfee / 100 > $arr_bkinfo['minsdcrpayfee'] ? $bkmoney * $sdcrpayfee / 100 : $arr_bkinfo['minsdcrpayfee'];
     $ccgno = makeorderno("couponsale", "couponsale", "cps");
     $query = "insert into tb_couponsale\n\t\t\t\t\t(fd_couponsale_no\t,\tfd_couponsale_bkntno\t,\tfd_couponsale_couponno\t,\n\t\t\t\t\tfd_couponsale_paycardid,fd_couponsale_authorid  ,\tfd_couponsale_money,\n\t\t\t\t\tfd_couponsale_rebuy,\tfd_couponsale_state,\t\tfd_couponsale_datetime,\n\t\t            fd_couponsale_couponid,\tfd_couponsale_payrq,\t\tfd_couponsale_creditcardno,\n\t\t            fd_couponsale_creditcardbank,fd_couponsale_creditcardman,fd_couponsale_creditcardphone," . "fd_couponsale_bkordernumber,fd_couponsale_sdcrid,   fd_couponsale_sdcrpayfeemoney," . "fd_couponsale_paymoney , fd_couponsale_payfee   ,   fd_couponsale_bkmoney  ," . "fd_couponsale_shoucardno,fd_couponsale_shoucardman,fd_couponsale_shoucardbank," . "fd_couponsale_shoucardmobile\n\t\t            )values\n\t\t\t\t\t('{$ccgno}'\t\t\t,\t'{$bkntno}'\t\t\t\t,\t'{$bkorderNumber}',\n\t\t\t\t\t'{$paycardid}'\t\t,\t'{$authorid}'\t\t\t\t,\t'{$paymoney}',\n\t\t\t\t\t'0'\t\t\t\t\t,\t'0'\t\t\t\t\t\t,\t now()\t\t ,\n\t\t\t\t\t'{$couponid}'\t\t\t,\t'01'  \t\t\t\t\t,    '{$fucardno}',\n\t\t\t\t\t'{$fubank}'           ,   '{$fucardman}'            ,   '{$fucardphone}' , " . "'{$bkordernumber}'   ,   '{$sdcrid}'               ,   '{$sdcrpayfeemoney}'," . "'{$paymoney}'        ,   '{$payfee}'               ,   '{$bkmoney}'        ," . "'{$shoucardno}'      ,   '{$shoucardman}'          ,   '{$shoucardbank}'    ," . "'{$shoucardmobile}'    ) ";
     $db->query($query);
     $listid = $db->insert_id();
     $method = 'in';
     $method = u2g($method);
     $gettrue = AgentPayglist::insertPayglist($this->reqxmlcontext, $bkntno, $listid, $ccgno, $paytype, $method, $arr_feeinfo);
     $arr_message = array("result" => "success", "message" => "获取交易码成功,可以去刷卡支付了!");
     $retcode = "0";
     //反馈状态 0 成功 200 自定义错误
     $arr_msg['msgbody']['result'] = $arr_message['result'];
     $arr_msg['msgbody']['message'] = $arr_message['message'];
     $arr_msg['msgbody']['bkntno'] = trim($bkntno);
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }
Beispiel #24
0
								}
							}else{
								$returnaccess = $token['access_token'];
							}
						}
						
						if($returnaccess){
							$wxuser = getwuserinfo($openid, $returnaccess);
							if($wxuser['nickname']){
								$upuserdata = array();
								$upuserdata['nickname']= addslashes(u2g($wxuser['nickname']));
								$upuserdata['sex']= intval($wxuser['sex']);
								$upuserdata['city']= addslashes(u2g($wxuser['city']));
								$upuserdata['country']= addslashes(u2g($wxuser['country']));
								$upuserdata['province']= addslashes(u2g($wxuser['province']));
								$upuserdata['headimgurl']= addslashes(u2g($wxuser['headimgurl']));
								$upuser = C::t('#hejin_box#hjbox_users')->update_by_id($userinfo['id'],$upuserdata);
								if($upuser){
									$url = 'action=plugins&operation=config&do=' . $_GET['do'] . '&identifier=hejin_toupiao&pmod=toupiao&model=tpjles&zid='.$zid.'&page='.$page;
									cpmsg(lang('plugin/hejin_box', 'getcg'), $url, 'succeed');	
									exit;	
								}else{
									$url = 'action=plugins&operation=config&do=' . $_GET['do'] . '&identifier=hejin_toupiao&pmod=toupiao&model=tpjles&zid='.$zid.'&page='.$page;
									cpmsg(lang('plugin/hejin_box', 'getsb'), $url, 'error');	
									exit;	
								}
							}else{
								$url = 'action=plugins&operation=config&do=' . $_GET['do'] . '&identifier=hejin_toupiao&pmod=toupiao&model=tpjles&zid='.$zid.'&page='.$page;
								cpmsg(lang('plugin/hejin_box', 'getsb'), $url, 'error');
								exit;		
							}
 function payOrderRq()
 {
     global $weburl;
     $db = new DB_test();
     $arr_header = $this->arr_header;
     $arr_body = $this->arr_body;
     $arr_channelinfo = $this->arr_channelinfo;
     $authorid = trim($arr_channelinfo['authorid']);
     $paytype = 'orderbuy';
     $orderpaytypeid = trim($arr_body['orderpaytypeid']);
     $orderprodureid = trim($arr_body['orderprodureid']);
     //支付类型id
     $ordernum = trim($arr_body['ordernum']);
     //充值金额
     $orderprice = trim(u2g($arr_body['orderprice']));
     //实际支付金额
     $ordermoney = trim(u2g($arr_body['ordermoney']));
     //订单金额
     $ordershaddressid = trim($arr_body['ordershaddressid']);
     //手机所属地区
     $oredershaddress = trim(u2g($arr_body['oredershaddress']));
     //银行卡号
     $ordershman = trim(u2g($arr_body['ordershman']));
     //银行卡关联id tb_banckcard.fd_bankcard_id
     $ordershphone = trim(u2g($arr_body['ordershphone']));
     //认证信息
     $orderfucardno = trim(u2g($arr_body['orderfucardno']));
     //认证信息
     $orderfucardbank = trim(u2g($arr_body['orderfucardbank']));
     //认证信息
     $ordermemo = trim(u2g($arr_body['ordermemo']));
     //认证信息
     $agentno = trim(u2g($arr_body['agentno']));
     //认证信息
     $orderpaytype = trim($arr_body['paytype']);
     $promoney = trim(u2g($arr_body['promoney']));
     //认证信息
     $yunmoney = trim(u2g($arr_body['yunmoney']));
     //认证信息
     $produrename = trim(u2g($arr_body['produrename']));
     $bkmoney = $ordermoney;
     //promoney+yunmoney
     $rechabkcardno = makeorderno("orderglist", "orderlist", "orl");
     $arr_bkinfo = BankPayInfo::bankpayorder($authorid, $paycardid, $bkmoney, $orderfucardno);
     $bkntno = trim($arr_bkinfo['bkntno']);
     $sdcrid = trim($arr_bkinfo['sdcrid']);
     if ($agentno != "") {
         // $cusid =$this->checkcusagentno($agentno);
         $query = "select fd_cus_id as cusid from tb_customer where fd_cus_no = '{$agentno}'";
         if ($db->execute($query)) {
             $arr_cusinfo = $db->get_one($query);
             $cusid = $arr_cusinfo['cusid'];
         } else {
             $arr_message = array("result" => "failure", "message" => "对不起,您填写的代理商代号错误,请重新填写!");
             $retcode = "200";
             //反馈状态 0 成功 200 自定义错误
             $arr_msg['msgbody']['result'] = $arr_message['result'];
             $arr_msg['msgbody']['message'] = $arr_message['message'];
             $arr_msg['msgbody']['bkntno'] = $bkntno;
             $returnvalue = array("msgbody" => $arr_msg['msgbody']);
             $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
             return $returnval;
             exit;
         }
     }
     $datetime = date("Y-m-d H:i:s");
     $date = date("Y-m-d");
     //$bkmoney  =
     $bkorderNumber = trim($arr_bkinfo['bkorderNumber']);
     $datadetailArray['fd_orderlist_paytype'] = $paytype;
     $datadetailArray['fd_orderlist_no'] = $listno;
     $datadetailArray['fd_orderlist_authorid'] = $authorid;
     $datadetailArray['fd_orderlist_bkntno'] = $bkntno;
     $datadetailArray['fd_orderlist_date'] = $date;
     $datadetailArray['fd_orderlist_payrq'] = '01';
     //刚请求的交易码状态为01
     $datadetailArray['fd_orderlist_bkordernumber'] = $bkorderNumber;
     $datadetailArray['fd_orderlist_sdcrid'] = $sdcrid;
     $datadetailArray['fd_orderlist_produreid'] = $orderprodureid;
     $datadetailArray['fd_orderlist_produrename'] = $produrename;
     $datadetailArray['fd_orderlist_cusid'] = $cusid;
     //分润代理商
     $datadetailArray['fd_orderlist_num'] = $ordernum;
     $datadetailArray['fd_orderlist_price'] = $orderprice;
     $datadetailArray['fd_orderlist_promoney'] = $promoney;
     $datadetailArray['fd_orderlist_yunmoney'] = $yunmoney;
     $datadetailArray['fd_orderlist_ordermoney'] = $ordermoney;
     $datadetailArray['fd_orderlist_shaddressid'] = $ordershaddressid;
     $datadetailArray['fd_orderlist_shaddress'] = $oredershaddress;
     $datadetailArray['fd_orderlist_shman'] = $ordershman;
     $datadetailArray['fd_orderlist_shphone'] = $ordershphone;
     $datadetailArray['fd_orderlist_fucardno'] = $orderfucardno;
     $datadetailArray['fd_orderlist_fucardbank'] = $orderfucardbank;
     $datadetailArray['fd_orderlist_memo'] = $ordermemo;
     $datadetailArray['fd_orderlist_datetime'] = $datetime;
     $datadetailArray['fd_orderlist_agentno'] = $agentno;
     $db->insert("tb_orderglist", $datadetailArray);
     $listid = $db->insert_id();
     $arr_message = array("result" => "success", "message" => "请求交易码成功!");
     $retcode = "0";
     //反馈状态 0 成功 200 自定义错误
     $arr_msg['msgbody']['result'] = $arr_message['result'];
     $arr_msg['msgbody']['message'] = $arr_message['message'];
     $arr_msg['msgbody']['bkntno'] = $bkntno;
     $returnvalue = array("msgbody" => $arr_msg['msgbody']);
     $returnval = TfbxmlResponse::ResponsetoApp($retcode, $returnvalue);
     return $returnval;
 }
Beispiel #26
0
<?php

/*
 * ×÷ÕߣºÁÁ½£
 * ÁªÏµQQ:578933760
 *
 */
if (!defined('IN_DISCUZ')) {
    exit('Access Denied');
}
$config = $_G['cache']['plugin']['aljwsq'];
$openid = u2g($postObj->FromUserName);
$lasttime = DB::result_first('select lasttime from %t where openid = %s', array('aljwsq_user', $openid));
$lasttime = intval($lasttime);
if ($lasttime + $config['time'] < TIMESTAMP) {
    $news = C::t('#aljwsq#aljwsq_autoreply')->fetch_by_mykeyword($location['bindkeyword']);
    DB::query('update %t set lasttime = %d where openid = %s', array('aljwsq_user', TIMESTAMP, $openid));
} else {
    exit;
}
function g2u($a)
{
    return is_array($a) ? array_map('g2u', $a) : diconv($a, CHARSET, 'UTF-8');
}
function u2g($a)
{
    return is_array($a) ? array_map('u2g', $a) : diconv($a, 'UTF-8', CHARSET);
}
header('Content-Type: application/x-www-form-urlencoded');
header('Content-Type: text/html;charset=utf-8');
require "../include/common.inc.php";
require_once '../include/json.php';
$db = new db_test();
$query = "select fd_paycard_salerid,count(*) as counts from tb_paycard  group by fd_paycard_salerid  ";
$db->query($query);
if ($db->nf()) {
    while ($db->next_record()) {
        $id = $db->f(fd_paycard_salerid);
        //id号
        $arr_membercounts[$id] = g2u($db->f(counts));
    }
}
$aColumns = array("", "a.fd_saler_truename", "a.fd_saler_username", "a.fd_saler_phone", "b.fd_saler_truename", 'a.fd_saler_zjl');
$sSearch = u2g($sSearch);
$sWhere = "";
if ($sSearch != "") {
    $sWhere = "and  (";
    for ($i = 1; $i < count($aColumns); $i++) {
        $sWhere .= $aColumns[$i] . " LIKE '%" . trim($sSearch) . "%' OR ";
    }
    $sWhere = substr_replace($sWhere, "", -3);
    $sWhere .= ')';
}
/* Individual column filtering */
for ($i = 1; $i < count($aColumns); $i++) {
    $b_s = "bSearchable_" . $i;
    $s_s = "sSearch_" . $i;
    if (${$b_s} == "true" && ${$s_s} != '') {
        if ($sWhere == "") {
$query = "select * from  web_salerrewards where fd_rewards_type  = '2'";
//销售提成
$db->query($query);
$count = 0;
//记录数
$vallquantity = 0;
//总价
if ($db->nf()) {
    while ($db->next_record()) {
        $ordermoney = $db->f(fd_rewards_selfmoney);
        $orderbmonth = $db->f(fd_rewards_bmonth);
        $orderemonth = $db->f(fd_rewards_emonth);
    }
}
$state = "已发货";
$state = u2g($state);
//开卡数有效记录
$query = "select fd_salercard_salerid,count(*) as counts,month(fd_salercard_opendate) as monthdate from web_salercard where \nfd_salercard_memberid >0 and fd_salercard_state='1' and fd_salercard_opendate like '%{$beginmonth}%'  \nand fd_salercard_opendate >='{$cardbmonth}' and fd_salercard_opendate <='{$cardemonth}'\ngroup by fd_salercard_salerid,monthdate  ";
$db->query($query);
if ($db->nf()) {
    while ($db->next_record()) {
        $id = $db->f(fd_salercard_salerid);
        //id号
        $month = $db->f(monthdate);
        $arr_membercounts[$id][$month] = g2u($db->f(counts));
    }
}
$query = "select fd_salercard_salerid ,sum(fd_order_alldunshu) as allquantity  ,month(fd_order_date) as monthdate \n          from web_order\n          left join web_salercard on fd_salercard_memberid = fd_order_memeberid \n\t\t  and fd_order_state='{$state}' \n\t\t  and fd_order_date >='{$orderbmonth}' and fd_order_date <='{$orderemonth}'  \n\t\t  where fd_order_alldunshu>'0' and fd_order_date  like '%{$beginmonth}%' group by fd_salercard_salerid,monthdate ";
$db->query($query);
if ($db->nf()) {
    while ($db->next_record()) {
Beispiel #29
0
<?php

/*
 *	DreamArticle Version3.0
 *	Copyright 2007-2008, iDreamSoft
 *	http://www.idreamsoft.cn
 *	By:coolmoo<*****@*****.**>
*/
!defined('DCPATH') && exit('What are you doing?');
if (in_array($action, array('message', 'comment'))) {
    $id = intval($_POST['id']);
    $reply = 'admin||' . u2g(htmlspecialchars($_POST['replytext']));
    $DreamCMS->db->update($action, compact('reply'), compact('id')) && exit('1');
}
Beispiel #30
0
    loaducenter();
    $nickname = u2g($wuser['nickname']);
    if ($config['isname'] && $nickname) {
        $username = $nickname;
    } else {
        $username = random(5);
    }
    while (DB::result_first('select count(*) from %t where username = %s', array('common_member', $username))) {
        $username = random(5);
    }
    $defaultpassword = $config['password'];
    $return = register($username, '', $config['autogroup'], $defaultpassword);
    if (empty($user) && $openid) {
        C::t('#aljwsq#aljwsq_user')->insert(array('nickname' => u2g($wuser['nickname']), 'username' => $username, 'openid' => $openid, 'bindtime' => TIMESTAMP, 'sex' => $wuser['sex'], 'city' => u2g($wuser['city']), 'country' => u2g($wuser['country']), 'province' => u2g($wuser['province']), 'language' => $wuser['language'], 'headimgurl' => $wuser['headimgurl'], 'subscribe_time' => TIMESTAMP));
    } else {
        C::t('#aljwsq#aljwsq_user')->update($openid, array('nickname' => u2g($wuser['nickname']), 'username' => $username, 'bindtime' => TIMESTAMP, 'sex' => $wuser['sex'], 'city' => u2g($wuser['city']), 'country' => u2g($wuser['country']), 'province' => u2g($wuser['province']), 'language' => $wuser['language'], 'headimgurl' => $wuser['headimgurl']));
    }
    $tpl = str_replace('{username}', $return['username'], $config['tpl']);
    $tpl = str_replace('{password}', $return['password'], $tpl);
    $tpl = str_replace('{openid}', $openid, $tpl);
    echo $this->responsetext($postObj, $tpl);
} else {
    $tpl = str_replace('{username}', $user['username'], $config['altpl']);
    echo $this->responsetext($postObj, $tpl);
}
function g2u($a)
{
    return is_array($a) ? array_map('g2u', $a) : diconv($a, CHARSET, 'UTF-8');
}
function u2g($a)
{