/**
* 我的投票
*/
public function actionMy()
{
$uid = Yii::app()->user->id;
$model = new Vote();
//初始化
$criteria = new CDbCriteria();
$criteria->order = 'ctime DESC';
$criteria->condition = "uid=:uid";
$criteria->params = array(':uid' => $uid);
$mini = $model->find($criteria);
$icon_list = Smile::model()->findAll();
$date = Yii::app()->request->getQuery('date');
if (!empty($date)) {
$criteria = $model->fileaway($date, $criteria);
}
//取得数据总数,分页显示
$total = $model->count($criteria);
$pages = new CPagination($total);
$pages->pageSize = self::PAGE_SIZE;
$pages->applyLimit($criteria);
//获取数据集
$list = $model->findAll($criteria);
$data = array('list' => $list, 'pages' => $pages, 'mini' => $mini, 'icon_list' => $icon_list);
$this->render('my', $data);
}
});
Route::get('/test', function () {
// $artist = new Artist;
// $artist->name = 'Eve 6';
// $artist->save();
// $candidate = new Candidate;
// $candidate->cname=$data_array1[0];
// $candidate->job_title=$data_array1[1];
// $candidate->sex=$data_array1[2];
// $candidate->vote_id=42;
// $candidate->total_count=0;
// $account = new Account;
// $account->username;
// $account->vote_id;
// $account->finish_at;
$vote = Vote::find(49);
$account = new Account();
$account->username = '******';
$account->vote_id = 49;
$account->finish_at = "0000-00-00 00:00:00";
$account->vote()->associate($vote);
$account->save();
$account2 = new Account();
$account2->username = '******';
$account2->vote_id = 2;
$account2->finish_at = "0000-00-00 00:00:00";
$account2->vote()->associate($vote);
$account2->save();
$candidate = new Candidate();
$candidate->cname = 'Naruto Uzumaki';
$candidate->job_title = 'yy';
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
//
$vote = Vote::find($id);
$vote->delete();
$arr = ['flash' => ['type' => 'success', 'msg' => '待辦事項已刪除！']];
return Redirect::route('home');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
//
$vote = Vote::find($id);
$candidates = Candidate::where('vote_id', '=', $id)->get();
foreach ($candidates as $candidate) {
$candidate->accounts()->detach();
$candidate->delete();
}
Account::where('vote_id', '=', $id)->delete();
$vote->delete();
$arr = ['flash' => ['type' => 'success', 'msg' => '待辦事項已刪除！']];
return Redirect::route('votes_not_yet');
}
