/** * rate_21,22,33 620 rate_21,22,43 620 rate_21,33,43 620 rate_22,33,43 620 sum_lm_1 6 rate_30,31,32 21,90 sum_lm_0 3 need update tbl_stat,tbl_ltr_type[win,bet] A B C ? 实货虚货? bhuser bx999 * @return unknown_type */ public function actionTz() { $this->layout = false; header('Content-type: application/json'); //$posts=CommonUtil::getBetRateSum($_POST); /*$openStatus=0; if($termStatus['status']!=2){ if(strpos("'tm','tmds','tmdx','tmhsds','tmsb','tmwsdx','tmqs','tx','bbds','bbdx','mx'","'{$btc['btc']}'")!==false){ if($teAutoRemainTime>0){ $openStatus=intval($btc['defaultopen']); } }else{ if($notTeAutoRemainTime>0){ $openStatus=intval($btc['defaultopen']); } } }*/ $msg = ''; $conn = Yii::app()->db; $userid = Yii::app()->user->id; $roleid = Yii::app()->user->role; $lei = isset($_POST['lei']) ? intval($_POST['lei']) : Yii::app()->user->getState('lei'); $vNull = NULL; $findRateCmd = $conn->createCommand("select t.*,(SELECT IF(r.open=0,0,t.open) FROM tbl_default_rate r WHERE r.id=t.type OR (r.id='txbx' AND t.type='tx' AND t.id='tx_1') OR (r.id='txfbx' AND t.type='tx' AND t.id<>'tx_1') OR (r.id='sxbx' AND t.type='sx' AND t.id='sx_1') OR (r.id='sxfbx' AND t.type='sx' AND t.id<>'sx_1') OR (r.id='ws0' AND t.type='ws' AND t.id='ws_0') OR (r.id='wsf0' AND t.type='ws' AND t.id<>'ws_0')) AS defaultopen from tbl_ltr_type t where t.`id`=:id"); $ltrRec = $conn->createCommand("select resultDate,notTeAutoCloseTime,teAutoCloseTime from tbl_ltr where term='" . $this->term . "'")->queryRow(); $notTeAutoRemainTime = strtotime($ltrRec['resultDate'] . ' ' . $ltrRec['notTeAutoCloseTime']) - time(); $teAutoRemainTime = strtotime($ltrRec['resultDate'] . ' ' . $ltrRec['teAutoCloseTime']) - time(); $openStatus = 0; $termStatus = CommonUtil::getCachedTermStatus(); $typeRecs = array(); $posts = array(); if ($termStatus['status'] != 2) { $rates = array(); $sums = array(); $head = ''; $isMulti = false; $totleSum = 0; foreach ($_POST as $key => $value) { $head = substr($key, 0, 4); if ($head == 'sum_') { if ($value != '') { $value = intval($value); if ($value <= 0) { continue; } $sKey = substr($key, 4); $totleSum += $value; $typeRec = $findRateCmd->queryRow(true, array(":id" => $sKey)); if ($typeRec === null || $typeRec === false) { continue; } $typeRecs[$sKey] = $typeRec; if (strpos("'tm','tmds','tmdx','tmhsds','tmsb','tmwsdx','tmqs','tx','bbds','bbdx','mx'", "'{$typeRec['btc']}'") !== false) { if ($teAutoRemainTime > 0) { $openStatus = intval($typeRec['defaultopen']); } } else { if ($notTeAutoRemainTime > 0) { $openStatus = intval($typeRec['defaultopen']); } } if ($openStatus == 0) { $msg = "{$typeRec['name']} 已关盘"; break; } else { $openStatus = 0; } $sums[$sKey] = $value; } } elseif ($head == 'rate') { $rates[substr($key, 5)] = $value; $isMulti = $isMulti || strpos($key, ',') !== false; } } $isMulti = $isMulti && count($sums) == 1; $posts = array('rates' => $rates, 'sums' => $sums, 'isMulti' => $isMulti, 'totleSum' => $totleSum); } else { echo CJSON::encode(array("msg" => "已结账,不能下注", "success" => false)); Yii::app()->end(); } if ($posts['totleSum'] > Yii::app()->user->creditSum - Yii::app()->user->usedSum) { echo CJSON::encode(array("msg" => "信用额度不够", "success" => false)); Yii::app()->end(); } $autoBhMap = array('tm' => 0, 'zm' => 1, 'zhds' => 1, 'zhdx' => 1, 'zt' => 2, 'tmds' => 3, 'tmdx' => 3, 'tmhsds' => 3, 'tmwsdx' => 3, 'tmqs' => 3, 'ztds' => 3, 'ztdx' => 3, 'zthsds' => 3, 'ztwsdx' => 3, 'ztqs' => 3, 'tmsb' => 4, 'ztsb' => 4, 'lm_0' => 5, 'lm_1' => 6, 'lm_2' => 7, 'lm_3' => 8, 'lm_4' => 9, 'tx' => 10, 'sx' => 11, 'ws' => 12, 'bbds' => 13, 'bbdx' => 13, 'mx' => 14, 'sxl' => 15, 'wsl' => 15, 'bz' => 16, 'dzy' => 17, 'qsb' => 18, 'zx_0' => 19, 'zx_1' => 19, 'zx_2' => 19, 'zx_3' => 19, 'zx_4' => 20, 'zx_5' => 20, 'qm_0' => 21, 'qm_1' => 21, 'qm_2' => 21, 'qm_3' => 21, 'qm_4' => 21, 'qm_5' => 21, 'qm_6' => 21, 'qm_7' => 21); if ($roleid > 0) { $sumLimitCmd = $conn->createCommand("select termLimit,betLimit,termUsed from tbl_sumlimit where idx=:idx and userid=:userid"); $updatesumLimitCmd = $conn->createCommand("update tbl_sumlimit set termUsed=termUsed+:termUsed where idx=:idx and userid=:userid"); $sumLimitMap = array(); foreach ($posts['sums'] as $key => $value) { $typeRec = $typeRecs[$key]; $rates = array(); $termLimit = -1; $betLimit = -1; $termUsed = -1; $btcid = $typeRec['btc']; $abhIdx = $btcid == 'lm' || $btcid == 'zx' ? $autoBhMap[$key] : (substr($btcid, 0, 2) == 'zt' ? $autoBhMap[preg_replace('/[\\d\\_]/i', '', $btcid)] : $autoBhMap[$btcid]); if ($roleid == 5) { if (!isset($sumLimitMap[$abhIdx])) { $sumLimitRec = $sumLimitCmd->queryRow(true, array(":idx" => $abhIdx, ":userid" => $userid)); if ($sumLimitRec != false) { $termLimit = floatval($sumLimitRec['termLimit']); $betLimit = floatval($sumLimitRec['betLimit']); $termUsed = floatval($sumLimitRec['termUsed']); $sumLimitMap[$abhIdx] = $sumLimitRec; } } else { $termLimit = $sumLimitMap[$abhIdx]['termLimit']; $betLimit = $sumLimitMap[$abhIdx]['betLimit']; $termUsed = $sumLimitMap[$abhIdx]['termUsed']; } } if (CommonUtil::isCb($typeRec['btc'])) { $cbCodeMap = array('lm_0' => 3, 'lm_1' => 3, 'lm_2' => 2, 'lm_3' => 2, 'lm_4' => 2, 'dzy_0' => 3, 'dzy_1' => 4, 'dzy_2' => 5, 'dzy_3' => 6, 'mx_0' => 6, 'bz_0' => 5, 'sxl_0' => 2, 'sxl_1' => 2, 'sxl_2' => 3, 'sxl_3' => 3, 'sxl_4' => 4, 'sxl_5' => 4, 'wsl_0' => 2, 'wsl_1' => 2, 'wsl_2' => 3, 'wsl_3' => 3, 'wsl_4' => 4, 'wsl_5' => 4); $cdCodeNum = array('lm' => 49, 'dzy' => 49, 'mx' => 12, 'bz' => 49, 'sxl' => 12, 'wsl' => 10); foreach ($posts['rates'] as $rName => $rValue) { $cbCodes = split(',', $rName); //$a == "lm" || $a == "bz" || $a == "mx" || $a == "sxl" || $a == "wsl" || $a == "dzy"; //Ltr.lmNames = [ "三中二", "三全中", "二全中", "二中特", "特串" ]; /*Ltr.dzyNames = [ "三中一", "四中一", "五中一", "六中一" ]; mx : [ "六肖" ], bz : [ "五不中" ], sxl : [ "二肖连-中", "二肖连-不中", "三肖连-中", "三肖连-不中", "四肖连-中", "四肖连-不中" ], wsl : [ "二尾连-中", "二尾连-不中", "三尾连-中", "三尾连-不中", "四尾连-中", "四尾连-不中" ], */ if (count($cbCodes) != $cbCodeMap[$key] || count(array_unique($cbCodes)) != count($cbCodes)) { $msg = "{$typeRec['name']} 下注项目有误"; break; } $isCbCode = true; foreach ($cbCodes as $cbCode) { if (!is_numeric($cbCode) || strpos($cbCode, '.') !== false || intval($cbCode) >= $cdCodeNum[$typeRec['btc']]) { $isCbCode = false; break; } } if (!$isCbCode) { $msg = "{$typeRec['name']} 下注项目有误"; break; } $rates = split(',', $rValue); if (floatval($typeRec['rate0' . $lei]) != floatval($rates[0])) { $msg = "{$typeRec['name']} 赔率已变动"; break; } if (count($rates) == 2) { if (floatval($typeRec['rate1' . $lei]) != floatval($rates[1])) { $msg = "{$typeRec['name']} 赔率已变动"; break; } } if ($betLimit != -1) { if ($value > $betLimit) { $msg = "{$typeRec['name']} 单注金额不能超过 {$betLimit}"; break; } } if ($termLimit != -1) { if ($value > $termLimit - $termUsed) { $msg = "{$typeRec['name']} 本期单场金额不能超过 {$termLimit}"; break; } $termUsed = $termUsed + $value; $sumLimitMap[$abhIdx]['termUsed'] = $termUsed; } } } else { if (isset($posts['rates'][$key])) { $rates = split(',', $posts['rates'][$key]); if (floatval($typeRec['rate0' . $lei]) != floatval($rates[0])) { $msg = "{$typeRec['name']} 赔率已变动"; break; } if (count($rates) == 2) { if (floatval($typeRec['rate1' . $lei]) != floatval($rates[1])) { $msg = "{$typeRec['name']} 赔率已变动"; break; } } if ($betLimit != -1) { if ($value > $betLimit) { $msg = "{$typeRec['name']} 单注金额不能超过 {$betLimit}"; break; } } if ($termLimit != -1) { if ($value > $termLimit - $termUsed) { $msg = "{$typeRec['name']} 本期单场金额不能超过 {$termLimit}"; break; } $termUsed = $termUsed + $value; $sumLimitMap[$abhIdx]['termUsed'] = $termUsed; } } } } } if ($msg != '') { echo CJSON::encode(array("msg" => $msg, "success" => false)); Yii::app()->end(); } $checkAutoBhCmd = $conn->createCommand("select id,sumLimit from tbl_autobh where auto=1 and idx=:idx and userid=:userid"); $checkAutoBhTypeCmd = $conn->createCommand("select usedSum from tbl_abh_type where abhid=:abhid and ltrtypecode=:betCode"); $checkAutoBhTypeUpdateCmd = $conn->createCommand("replace into tbl_abh_type(abhid,ltrtypecode,usedSum) values (:abhid,:ltrtypecode,:usedSum)"); $sql = "insert into tbl_bet(betType,betCode,rebate,betUserId,betUserName,betSum,betTime,bhUserId,bhUserName,ltrTypeId,ltrTypeName,ltrBtcId,ltrType,prorate_0,prorate_1,prorate_2,prorate_3,prorate_4,statUser_0,statUser_1,statUser_2,statUser_3,statUser_4,rate,rate0,rate1,role,termid,lei)" . "values (:betType,:betCode,:rebate,:betUserId,:betUserName,:betSum,sysdate(),:bhUserId,:bhUserName,:ltrTypeId,:ltrTypeName,:ltrBtcId,:ltrType,:prorate_0,:prorate_1,:prorate_2,:prorate_3,:prorate_4,:statUser_0,:statUser_1,:statUser_2,:statUser_3,:statUser_4,:rate,:rate0,:rate1,:role,:termid,:lei)"; $command = $conn->createCommand($sql); $updateUserCmd = $conn->createCommand("update tbl_user set usedSum=usedSum+:betSum where id=:id"); //$prorates=$conn->createCommand("select `prorate_0`,`prorate_1`,`prorate_2`,`prorate_3`,`prorate_4` from tbl_user_prorate where userid=:userid")->queryRow(true,array(":userid"=>Yii::app()->user->id)); $prorateUserCmd = $conn->createCommand("select parentProrate,parentId,role from tbl_user where id=:id"); $prorateUser = array("parentId" => $userid); $prorateUsers = array(); $bhuser = array(); if (isset($_POST['bhuser'])) { $bhuser = $conn->createCommand("select id,name from tbl_bhuser where id='{$_POST['bhuser']}'")->queryRow(); } if ($roleid < 5) { $bhRemainCmd = $conn->createCommand("select sum(if(betUserId='{$userid}',-betSum,betSum*prorate_{$roleid})) from tbl_bet where statUser_{$roleid}='{$userid}' and ltrTypeId=:ltrTypeId and termid='{$this->term}'"); } //0 parentProrate 0,parentId 0, 1 股东 parentProrate 公司,parentId 公司, 2 小股东 parentProrate parentId 2 while ($prorateUser['parentId'] != '') { $prorateUser = $prorateUserCmd->queryRow(true, array(":id" => $prorateUser['parentId'])); if ($prorateUser['parentId'] != '') { //echo $prorateUsers['role']-1; if (count($prorateUsers) == $roleid - 1) { $totalProrate = 0; foreach ($prorateUsers as $tmp_prorateUser) { $totalProrate += $tmp_prorateUser['parentProrate']; } $prorateUser['parentProrate'] = 1 - $totalProrate; } array_unshift($prorateUsers, $prorateUser); } } $siteInfo = $conn->createCommand("select * from tbl_site")->queryRow(); $brs = array(); $i = 0; $rebates = array(); //must check sum foreach ($posts['sums'] as $key => $value) { //if($posts['isMulti']){ if ($value == '') { continue; } //$typeRec=$findRateCmd->queryRow(true,array(":id"=>$key)); $typeRec = $typeRecs[$key]; if ($typeRec === null || $typeRec === false) { continue; } if (substr($key, 0, 2) != 'zx') { //zx_0...5 $rebateKey = substr($key, 0, strrpos($key, '_')); //zt_2_hsds_0 zt_2_23 -> zt_2_hsds zt_2 -> zthsds zt if (substr($rebateKey, 0, 2) == 'zt') { $rebateKey = preg_replace('/[\\d\\_]/i', '', $rebateKey); } } else { if ($key == 'zx_4' || $key == 'zx_5') { $rebateKey = 'zxds'; } else { $rebateKey = 'zx'; } } if (!isset($rebates[$rebateKey])) { if (!isset($_POST['bhuser'])) { $rebateRec = $conn->createCommand("select rebate{$lei} from tbl_default_rebate where LOCATE('{$rebateKey},',concat(btcs,','))>0")->queryRow(false); } else { $rebateRec = $conn->createCommand("select rebate0 from tbl_default_rebate_bh where LOCATE('{$rebateKey},',concat(btcs,','))>0 and userid='{$bhuser['id']}'")->queryRow(false); } $rebates[$rebateKey] = $rebateRec[0]; } $rates = array(); if ($roleid == 5 || $roleid == 0) { if ($posts['isMulti'] === true) { $rates = $posts['rates']; } else { $rates[$key] = $posts['rates'][$key]; } } else { if ($typeRec['rate1' . $lei] > 0) { $rates = $typeRec['rate0' . $lei] . ',' . $typeRec['rate1' . $lei]; } else { $rates[$key] = $typeRec['rate0' . $lei]; } } $abhIdx = $btcid == 'lm' || $btcid == 'zx' ? $autoBhMap[$key] : (substr($btcid, 0, 2) == 'zt' ? $autoBhMap[preg_replace('/[\\d\\_]/i', '', $btcid)] : $autoBhMap[$btcid]); foreach ($rates as $rName => $rValue) { $typeName = $typeRec['name']; $code = 0; $btcid = ''; if (strpos($key, 'qm_') !== false || strpos($key, 'zt_') !== false) { $btcid = substr($key, 0, strrpos($key, '_')); } else { $btcid = substr($key, 0, strpos($key, '_')); } if ($posts['isMulti'] === true) { $typeName = $typeName . '(' . $this->getItemCodeName($btcid, $rName) . ')'; $code = $rName; } else { $code = substr($rName, strrpos($rName, '_') + 1); } $rValue = split(',', $rValue); $rateName = $rValue[0]; if (isset($rValue[1]) && $rValue[1] > 0) { $rateName .= '/' . $rValue[1]; } if ($roleid < 5) { //补货 $bhRemain = $bhRemainCmd->queryRow(false, array(':ltrTypeId' => $key)); //print_r($bhRemain); if ($bhRemain !== false && $bhRemain[0] < $value) { array_push($brs, array($i++, $typeName, $value, $rateName, 0, "失败")); $msg .= "{$typeName} 补货金额超过了当前下注金额;\n"; continue; } $command->bindParam(":betType", $typeName, PDO::PARAM_STR); $command->bindParam(":betCode", $code, PDO::PARAM_INT); $command->bindParam(":rebate", $rebates[$rebateKey], PDO::PARAM_INT); $command->bindParam(":betUserId", $userid, PDO::PARAM_STR); $command->bindParam(":betUserName", Yii::app()->user->getState('username'), PDO::PARAM_STR); $command->bindParam(":betSum", $value, PDO::PARAM_INT); if (isset($_POST['bhuser'])) { $command->bindParam(":bhUserId", $bhuser['id'], PDO::PARAM_STR); $command->bindParam(":bhUserName", $bhuser['name'], PDO::PARAM_STR); } else { $command->bindParam(":bhUserId", $vNull, PDO::PARAM_NULL); $command->bindParam(":bhUserName", $vNull, PDO::PARAM_NULL); } //$command->bindParam(":hyResult",0,PDO::PARAM_INT); $command->bindParam(":ltrTypeId", $key, PDO::PARAM_STR); $command->bindParam(":ltrTypeName", $typeRec['name'], PDO::PARAM_STR); $command->bindParam(":ltrBtcId", $btcid, PDO::PARAM_STR); $command->bindParam(":ltrType", $typeRec['typeid'], PDO::PARAM_INT); $bhProp0 = 1; $bhProp1 = 0; $bhStatUserNull = NULL; $command->bindParam(":prorate_0", $bhProp0, PDO::PARAM_INT); //公司占成 $command->bindParam(":prorate_1", $bhProp1, PDO::PARAM_INT); // $command->bindParam(":prorate_2", $bhProp1, PDO::PARAM_INT); $command->bindParam(":prorate_3", $bhProp1, PDO::PARAM_INT); $command->bindParam(":prorate_4", $bhProp1, PDO::PARAM_INT); for ($bhI = 0; $bhI < $roleid; $bhI++) { $command->bindParam(":statUser_{$bhI}", $prorateUsers[$bhI]['parentId'], PDO::PARAM_STR); } $command->bindParam(":statUser_{$roleid}", $userid, PDO::PARAM_STR); for ($bhI = $roleid + 1; $bhI <= 4; $bhI++) { $command->bindParam(":statUser_{$bhI}", $bhStatUserNull, PDO::PARAM_NULL); } $command->bindParam(":rate", $rateName, PDO::PARAM_STR); $command->bindParam(":rate0", $rValue[0], PDO::PARAM_INT); $command->bindParam(":rate1", $rValue[1], PDO::PARAM_INT); $command->bindParam(":role", $roleid, PDO::PARAM_INT); $command->bindParam(":termid", $this->term, PDO::PARAM_STR); $command->bindParam(":lei", $lei, PDO::PARAM_INT); $command->execute(); array_push($brs, array($i++, $typeName, $value, $rateName, 0, "成功")); continue; } foreach ($prorateUsers as $prorateRole => $prorateUser) { $checkAutoBhRec = $checkAutoBhCmd->queryRow(true, array(":idx" => $abhIdx, ":userid" => $prorateUser['parentId'])); if ($checkAutoBhRec != false) { //echo 'has begin autobh\n'; $sumLimit = floatval($checkAutoBhRec['sumLimit']); $checkAutoBhTypeRec = $checkAutoBhTypeCmd->queryRow(true, array(":abhid" => $checkAutoBhRec['id'], ":betCode" => $code)); $abhUsedSum = 0; if ($checkAutoBhTypeRec != false) { $abhUsedSum = $checkAutoBhTypeRec['usedSum']; } $leftSum = $sumLimit - $abhUsedSum; //10-0 $bhBetSum = 0; $prorBetSum = $value * $prorateUser['parentProrate']; //1000*0.2=200 //echo "leftSum:$leftSum,prorBetSum:$prorBetSum\n"; if ($leftSum < $prorBetSum) { //echo 'has insert autobh'; //bh $bhBetSum = $prorBetSum - $leftSum; $command->bindParam(":betType", $typeName, PDO::PARAM_STR); $command->bindParam(":betCode", $code, PDO::PARAM_INT); $command->bindParam(":rebate", $rebates[$rebateKey], PDO::PARAM_INT); $command->bindParam(":betUserId", $prorateUser['parentId'], PDO::PARAM_STR); $command->bindParam(":betUserName", Yii::app()->user->getState('username'), PDO::PARAM_STR); $command->bindParam(":betSum", $bhBetSum, PDO::PARAM_INT); $command->bindParam(":bhUserId", $vNull, PDO::PARAM_NULL); $command->bindParam(":bhUserName", $vNull, PDO::PARAM_NULL); //$command->bindParam(":hyResult",0,PDO::PARAM_INT); $command->bindParam(":ltrTypeId", $key, PDO::PARAM_STR); $command->bindParam(":ltrTypeName", $typeRec['name'], PDO::PARAM_STR); $command->bindParam(":ltrBtcId", $btcid, PDO::PARAM_STR); $command->bindParam(":ltrType", $typeRec['typeid'], PDO::PARAM_INT); $bhProp0 = 1; $bhProp1 = 0; $bhStatUserNull = NULL; $command->bindParam(":prorate_0", $bhProp0, PDO::PARAM_INT); //公司占成 $command->bindParam(":prorate_1", $bhProp1, PDO::PARAM_INT); // $command->bindParam(":prorate_2", $bhProp1, PDO::PARAM_INT); $command->bindParam(":prorate_3", $bhProp1, PDO::PARAM_INT); $command->bindParam(":prorate_4", $bhProp1, PDO::PARAM_INT); for ($bhI = 0; $bhI <= $prorateRole; $bhI++) { $command->bindParam(":statUser_{$bhI}", $prorateUsers[$bhI]['parentId'], PDO::PARAM_STR); } for ($bhI = $prorateRole + 1; $bhI <= 4; $bhI++) { $command->bindParam(":statUser_{$bhI}", $bhStatUserNull, PDO::PARAM_NULL); } $command->bindParam(":rate", $rateName, PDO::PARAM_STR); $command->bindParam(":rate0", $rValue[0], PDO::PARAM_INT); $command->bindParam(":rate1", $rValue[1], PDO::PARAM_INT); $command->bindParam(":role", $prorateRole, PDO::PARAM_INT); $command->bindParam(":termid", $this->term, PDO::PARAM_STR); $command->bindParam(":lei", Yii::app()->user->getState('lei'), PDO::PARAM_INT); $command->execute(); } // 50 10 bet 40 $checkAutoBhTypeUpdateCmd->execute(array(":abhid" => $checkAutoBhRec['id'], ":ltrtypecode" => $code, ":usedSum" => $abhUsedSum + min($leftSum, $prorBetSum))); } } $command->bindParam(":betType", $typeName, PDO::PARAM_STR); $command->bindParam(":betCode", $code, PDO::PARAM_INT); $command->bindParam(":rebate", $rebates[$rebateKey], PDO::PARAM_INT); $command->bindParam(":betUserId", $userid, PDO::PARAM_STR); $command->bindParam(":betUserName", Yii::app()->user->getState('username'), PDO::PARAM_STR); $command->bindParam(":betSum", $value, PDO::PARAM_INT); $command->bindParam(":bhUserId", $vNull, PDO::PARAM_NULL); $command->bindParam(":bhUserName", $vNull, PDO::PARAM_NULL); //$command->bindParam(":hyResult",0,PDO::PARAM_INT); $command->bindParam(":ltrTypeId", $key, PDO::PARAM_STR); $command->bindParam(":ltrTypeName", $typeRec['name'], PDO::PARAM_STR); $command->bindParam(":ltrBtcId", $btcid, PDO::PARAM_STR); $command->bindParam(":ltrType", $typeRec['typeid'], PDO::PARAM_INT); $command->bindParam(":prorate_0", $prorateUsers[0]['parentProrate'], PDO::PARAM_INT); //公司占成 $command->bindParam(":prorate_1", $prorateUsers[1]['parentProrate'], PDO::PARAM_INT); // $command->bindParam(":prorate_2", $prorateUsers[2]['parentProrate'], PDO::PARAM_INT); $command->bindParam(":prorate_3", $prorateUsers[3]['parentProrate'], PDO::PARAM_INT); $command->bindParam(":prorate_4", $prorateUsers[4]['parentProrate'], PDO::PARAM_INT); $command->bindParam(":statUser_0", $prorateUsers[0]['parentId'], PDO::PARAM_STR); $command->bindParam(":statUser_1", $prorateUsers[1]['parentId'], PDO::PARAM_STR); $command->bindParam(":statUser_2", $prorateUsers[2]['parentId'], PDO::PARAM_STR); $command->bindParam(":statUser_3", $prorateUsers[3]['parentId'], PDO::PARAM_STR); $command->bindParam(":statUser_4", $prorateUsers[4]['parentId'], PDO::PARAM_STR); $command->bindParam(":rate", $rateName, PDO::PARAM_STR); $command->bindParam(":rate0", $rValue[0], PDO::PARAM_INT); $command->bindParam(":rate1", $rValue[1], PDO::PARAM_INT); $command->bindParam(":role", Yii::app()->user->getState('role'), PDO::PARAM_INT); $command->bindParam(":termid", $this->term, PDO::PARAM_STR); $command->bindParam(":lei", Yii::app()->user->getState('lei'), PDO::PARAM_INT); $command->execute(); Yii::app()->user->setState('usedSum', Yii::app()->user->usedSum + $value); $updateUserCmd->execute(array(":betSum" => $value, ":id" => $userid)); $updatesumLimitCmd->execute(array(":idx" => $abhIdx, ":userid" => $userid, ":termUsed" => $value)); /* if (h.get("result") == 7) { a[a.length] = [ h.get("rcId"), h.get("betType"), h.get("betSum"), h.get("rate"), h.get("newRate"), true ] } [ "id", "betType", "betSum", "rate", "result", "cause", "rcId", "newRate" ] */ array_push($brs, array($i++, $typeName, $value, $rateName, 0, "成功")); } } echo CJSON::encode(array("brs" => $brs, "success" => $msg == '', "msg" => $msg)); //echo '{"brs":[[0,"特码A02",20.0,"42.38",0,"成功"],[1,"特码A03",30.0,"42.38",0,"成功"]],"success":true}'; Yii::app()->end(); }