public function index()
{
$id = I('get.movie_id');
$model = new \Home\Model\MovieModel();
$result = $model->selectOne('movie', 'movie_id=' . $id);
$join = [' join movie on movie.movie_id=schedule.movie_id ', ' join hall on schedule.hall_id=hall.hall_id '];
$where = ' schedule.movie_id=' . $id . ' ';
$dom = $model->select('schedule', $where, '', $join);
foreach ($dom as &$movie) {
$movie['cinema'] = $model->selectOne('cinema', ' cinema_id=' . $movie['cinema_id']);
$movie['cinema'] = $movie['cinema'][0];
}
// var_dump($dom);
// $ticketUrl = ;
$join = ['join hall on hall.hall_id=schedule.hall_id', 'join cinema on hall.cinema_id=cinema.cinema_id'];
$allSchedule = $model->select('schedule', 'movie_id=' . $id, '', $join);
$allComments = $model->select('comment', 'movie_id=' . $id, '', ' user on user.user_id=comment.user_id');
$allMovie = $model->select('movie');
//var_dump($allSchedule);
$this->assign('allSchedule', $allSchedule);
$this->assign('movieurl', U('Movie/index'));
$this->assign('dom', $dom);
$this->assign('ticketUrl', U('ticket/index'));
$this->assign('movie', $result[0]);
$this->assign('allmovie', $allMovie);
$this->assign('allComments', $allComments);
$this->assign('searchurl', U('Search/index'));
// var_dump($allComments );
//$this->assign('allmovie',$allMovie);
$this->display();
}
public function index()
{
$id = I('get.cinema_id');
$model = new \Home\Model\MovieModel();
$result = $model->selectOne('cinema', 'cinema_id=' . $id);
//var_dump($result);
$this->assign('searchurl', U('Search/index'));
$allMovie = $model->select('movie', '', '0,9');
$this->assign('cinema', $result[0]);
$this->assign('allmovie', $allMovie);
$this->assign('movieurl', U('Movie/index'));
$this->display();
}
public function check()
{
//var_dump($_GET);
$model = new \Home\Model\MovieModel();
$result = $model->selectOne('user', " email='" . I('get.email') . "' ");
$result = $result[0];
if ($result) {
if ($result['password'] == I('get.password')) {
$this->setToken($result);
$this->redirect('Home/Index/index', array('cate_id' => 2), 1, '<script>alert("success")</script>');
} else {
$this->redirect('Home/Sign/index', array('cate_id' => 2), 1, '<script>alert("password error")</script>');
}
} else {
$data = ['email' => I('get.email'), 'password' => I('get.password'), 'phone' => '-', 'nickname' => md5(date('Y-m-d h-i-s')), 'headurl' => 'headicon.jpg'];
$user = M('user');
$user->add($data);
$data['user_id'] = $user->getLastInsID();
$this->setToken($data);
$this->redirect('Home/Index/index', array('cate_id' => 2), 1, '<script>alert("register success")</script>');
}
}
