php实现签到功能

 控制器的写

$date=yii::$app->request->get('date');

        if(isset($date)){             $user_id=1;             $model=new SignIn();             if(!$model->show($user_id,$date)){                 $dated=$date-3600*24;                 $yesterday=$model->show($user_id,$dated);                 $sign_num=!empty($yesterday)?$yesterday[0]['sign_num']:0;                 if($sign_num+1==5){                     $data=['user_id'=>$user_id,'sign_date'=>intval($date),'sign'=>1];                 }else{                     $data=['user_id'=>$user_id,'sign_date'=>intval($date),'sign'=>1,'sign_num'=>$sign_num+1];                 }                     if($model->add($data)){                         $model->sign_total($data['user_id']);                         return "<script>alert('签到成功');location.href='".URl::to(['sign-in/sign'])."';</script>";                     }             }else{                 return "<script>alert('今天已签到');location.href='".URl::to(['sign-in/sign'])."'</script>";             } //            $data=['user_id'=>1,'sign_date'=>$date]; // //            $model->sign($data);         }else{             return $this->render('sign');

        }

model层的一些写法

class SignIn extends \yii\db\ActiveRecord {     public function sign_total($userId){         $sql='update user set sign_total=sign_total+10 WHERE id='.$userId;         return Yii::$app->db->createCommand($sql)->query();     }     public function add($data){         $value='';         foreach($data as $val){             $value.=",'$val'";         }         $k='';         foreach($data as $key=>$val){             $k.=",$key";         }         $value=substr($value,1);         $k=substr($k,1);     return    Yii::$app->db->createCommand("insert into sign_in($k) VALUES($value)")->query();     }     public function show($id,$dated){     return    $rows = (new \yii\db\Query())->from('sign_in')             ->where(['user_id' => $id])             ->andWhere(['sign_date'=>$dated])             ->all();     }