route('code'); $re=Select::where('code',$code)->first(); return $this->success($re); } public function index(Request $request){ $input=$request->all(); $re=CodeTest::select('code')->find(1); dump($re); dd($re); dd(DB::getQuerylog()); for ($k=0;$k<100;$k++){ $p_code=$this->code(); $s=new Select(); $s->level=1; $s->pid=0; $s->security_code=$p_code['sec_code']; $s->code=$p_code['code']; $s->child_num=6; $s->save(); for ($i=0;$i<6;$i++){ $p_code=$this->code(); $ss=new Select(); $ss->level=2; $ss->pid=$s->id; $ss->security_code=$p_code['sec_code']; $ss->code=$p_code['code']; $ss->child_num=6; $ss->save(); for ($j=0;$j<6;$j++){ $p_code=$this->code(); $ss=new Select(); $ss->level=3; $ss->pid=$s->id; $ss->security_code=$p_code['sec_code']; $ss->code=$p_code['code']; $ss->child_num=0; $ss->is_lowest=1; $ss->save(); } } } dd(1); } public function code(){ $str='QWER34TYUIO_2PASDFG+1HJK567LZXC890VBNM'; $code=''; for ($i=0;$i<8;$i++){ $num=rand(0,37); $code.=mb_substr($str,$num,1); } $code1=Str::random(10); $code=date('y',time()).$code1.mb_substr(hash('sha256',$code),1,8).$code.date('md',time()); return ['code'=>$code,'sec_code'=>mb_substr($code,2,8)]; } }