public function Get_Now_update()
{
$bookinfo_query = bookinfo::find();
$bookinfo = $bookinfo_query->limit(30)->orderBy('article_last_updatetime desc')->asArray()->all();
//var_dump($bookinfo);
return $bookinfo;
}
public function actionIndex()
{
$keywords = $_GET['keyword'];
$array = bookinfo::find()->andFilterWhere(['like', 'bookname', $keywords])->orwhere(['like', 'author', $keywords])->orwhere(['like', 'bookname_pinyin', $keywords])->asArray()->all();
//var_dump($array);exit;
//$this->redirect('http://www.baidu.com'); 可跳转
return $this->render('index', ['keywords' => $keywords, 'search_result' => $array]);
}
public function Class_Recommendation($class)
{
$bookinfo = new bookinfo();
$Class_Recommendation = $bookinfo->find()->andwhere(['Class_Recommendation' => 1, 'Class' => $class])->asArray()->all();
return $Class_Recommendation;
}
public function insert_Book_Info($class, $bookname, $author, $Description, $update_time)
{
$bookinfo = new bookinfo();
$Pinyin = new TransPinyin();
$bookname_pinyin = $Pinyin->Pinyin($bookname);
$status = 1;
$return_status = $bookinfo->find()->createCommand()->insert('bookinfo', ['class' => $class, 'bookname' => $bookname, 'bookname_pinyin' => $bookname_pinyin, 'author' => $author, 'Description' => $Description, 'updatetime' => $update_time, 'status' => $status])->execute();
//echo '插入bookinfo'.'<br>';
return $return_status;
}
public function Get_Book_Id($bookname)
{
$bookinfo = new bookinfo();
$bookid = $bookinfo->find()->where(['bookname' => $bookname])->asArray()->One();
return $bookid['id'];
}
