public function actionRequestresult()
{
$app = new app();
$data = $app->findBySql("select * from app order by id desc limit 1")->all();
echo $data[0]['id'];
}
/**
* Creates a new app model.
* If creation is successful, the browser will be redirected to the 'view' page.
*
* @return mixed
*/
public function actionCreate()
{
if (Yii::$app->session['var'] === 'admin') {
$model = new app();
$data = Yii::$app->request->post();
// echo var_dump($data);
$allkind2 = (new \yii\db\Query())->distinct(true)->from('tag')->where(['>', 'second', ''])->all();
//$checkbox1=array();
$checkbox2 = array();
// foreach($allkind1 as $name)
// {
// $checkbox1[$name['kind']]=$name['kind'];
// }
foreach ($allkind2 as $name) {
$checkbox2[$name['first']][$name['second']] = $name['second'];
}
if ($data != false) {
// echo var_dump ( $data );
// $model->name = $data ['app'] ['name'];
// $model->version = $data ['app'] ['version'];
// $model->profile = $data ['app'] ['profile'];
// $model->android_url = $data ['android_url'];
// $model->ios_url = $data ['ios_url'];
// $model->stars = $data ['app'] ['stars'];
// $model->downloadcount = $data ['app'] ['downloadcount'];
// $model->commentscount = $data ['app'] ['commentscount'];
// $model->introduction = $data ['app'] ['introduction'];
// $model->updated_at = time ();
// $model->updated_log = $data ['app'] ['updated_log'];
// $model->size = $data ['app'] ['size'];
//$model->kind=$data ['app'] ['kind'];
$model->load($data);
$model->android_url = $data['android_url'];
$model->icon = $data['icon'];
$model->updated_at = time();
// foreach ( $data['kind1array'] as $kind ) {
// $model->kind.=$kind." ";
// }
foreach ($data['app']['kind2array'] as $kind) {
$model->kind .= $kind . " ";
}
if ($model->save()) {
$appdata = $model->findBySql("select * from app order by id desc limit 1")->all();
foreach ($data['pic'] as $pic) {
$apptpic = new Apptopicture();
$apptpic->appid = $model->id;
$apptpic->picture = $pic;
$apptpic->save();
}
// foreach ( $data['kind1array'] as $kind ) {
// $appkind=new Appofkind();
// $appkind->appid=$model->id;
// $appkind->status =1;
// $appkind->kind=$kind;
// $appkind->save();
// }
foreach ($data['app']['kind2array'] as $kind) {
$appkind = new Appofkind();
$appkind->appid = $model->id;
//$appkind->status =2;
$appkind->kind = $kind;
$appkind->save();
}
return $this->redirect(['view', 'id' => $model->id]);
}
} else {
//$allkind1 = (new \yii\db\Query ())->select ('kind')->distinct(true)->from('appofkind')->where('status=1')->all();
return $this->render('create', ['model' => $model, 'allkind2' => $checkbox2]);
}
return $this->render('create', ['model' => $model, 'allkind2' => $checkbox2]);
} else {
return $this->redirect(['login']);
}
}
