/** * 重庆时时彩数据包2解析数据 * @return \yii\db\ActiveQuery */ public function getAnalysisCqsscsData2() { return $this->hasOne(AnalysisCqssc::className(), ['cqssc_id' => 'id'])->where(['type' => 2]); }
/** * 记录到 mysql */ private function insert_mysql() { $exists = Cqssc::findOne(['qishu' => $this->data['qihao'], 'code' => $this->data['code']]); if ($exists) { exit("重庆时时彩数据已经采集过了 时间:" . date('Y-m-d H:i:s') . "\r\n"); } //开奖前三 号码 $q3 = $this->data['code'][0] . $this->data['code'][1] . $this->data['code'][2]; //开奖中三 号码 $z3 = $this->data['code'][1] . $this->data['code'][2] . $this->data['code'][3]; //后奖中三 号码 $h3 = $this->data['code'][2] . $this->data['code'][3] . $this->data['code'][4]; $this->analysisCode(); list($q3_data1_lucky, $q3_data1_regert, $q3_data2_lucky, $q3_data2_regert) = $this->isLucky($q3); //前三中奖情况 list($z3_data1_lucky, $z3_data1_regert, $z3_data2_lucky, $z3_data2_regert) = $this->isLucky($z3); //中三是否中奖 list($h3_data1_lucky, $h3_data1_regert, $h3_data2_lucky, $h3_data2_regert) = $this->isLucky($h3); //侯三是否中奖 //前三是组6还是组3 $q3_type = $this->is_type($q3); //中三是组6还是组3 $z3_type = $this->is_type($z3); //后三是组6还是组3 $h3_type = $this->is_type($h3); //开启事物 $innerTransaction = Yii::$app->db->beginTransaction(); try { /* 插入 开奖记录表数据 */ $cqsscModel = new Cqssc(); $cqsscModel->qishu = $this->data['qihao']; $cqsscModel->one = $this->data['code'][0]; $cqsscModel->two = $this->data['code'][1]; $cqsscModel->three = $this->data['code'][2]; $cqsscModel->four = $this->data['code'][3]; $cqsscModel->five = $this->data['code'][4]; $cqsscModel->code = $this->data['code']; $cqsscModel->front_three_type = $q3_type; $cqsscModel->center_three_type = $z3_type; $cqsscModel->after_three_type = $h3_type; $cqsscModel->kj_time = $this->data['kjsj']; $cqsscModel->time = time(); $cqsscModel->save(); /* 插入 开奖记录关联的 数据分析表 数据包1解析的结果 */ $analysisCqsscModel = new AnalysisCqssc(); $analysisCqsscModel->cqssc_id = $cqsscModel->id; $analysisCqsscModel->front_three_lucky_txt = $q3_data1_lucky; $analysisCqsscModel->front_three_regret_txt = $q3_data1_regert; $analysisCqsscModel->center_three_lucky_txt = $z3_data1_lucky; $analysisCqsscModel->center_three_regret_txt = $z3_data1_regert; $analysisCqsscModel->after_three_lucky_txt = $h3_data1_lucky; $analysisCqsscModel->after_three_regret_txt = $h3_data1_regert; $analysisCqsscModel->data_txt = $this->data_packet_txt; $analysisCqsscModel->type = 1; //数据包1解析的数据 $analysisCqsscModel->time = time(); $analysisCqsscModel->save(); /* 插入 开奖记录关联的 数据分析表 数据包2解析的结果 */ $analysisCqsscModel = new AnalysisCqssc(); $analysisCqsscModel->cqssc_id = $cqsscModel->id; $analysisCqsscModel->front_three_lucky_txt = $q3_data2_lucky; $analysisCqsscModel->front_three_regret_txt = $q3_data2_regert; $analysisCqsscModel->center_three_lucky_txt = $z3_data2_lucky; $analysisCqsscModel->center_three_regret_txt = $z3_data2_regert; $analysisCqsscModel->after_three_lucky_txt = $h3_data2_lucky; $analysisCqsscModel->after_three_regret_txt = $h3_data2_regert; $analysisCqsscModel->data_txt = $this->data_packet_txt_2; $analysisCqsscModel->type = 2; //数据包2解析的数据 $analysisCqsscModel->time = time(); $analysisCqsscModel->save(); $innerTransaction->commit(); //事物提交 $this->setLog(true, '重庆时时彩数据抓取成功'); echo "重庆时时彩数据抓取成功 时间:" . date('Y-m-d H:i:s') . "\r\n"; } catch (\Exception $e) { $innerTransaction->rollBack(); $this->setLog(false, '重庆时时彩数据与数据分析存入失败'); exit("重庆时时彩数据分析存入失败 时间:" . date('Y-m-d H:i:s') . "\r\n"); } }