private function changeitta($pid)
{
$uid = $this->viewer_info['uid'];
$uname = Model_Members_Userinfo::getUsername($uid);
$result = Model_Members_General2::checkitta($uid, $pid);
if (count($result) == 0) {
Model_Members_General2::setitta($uid, $pid);
$this->msg = $uname . "さんが行きました。";
} else {
$this->msg = "削除しました";
Model_Members_General2::deleteitta($uid, $pid);
}
}
public function action_change()
{
$uid = $this->viewer_info['uid'];
$uname = $this->viewer_info['name'];
$data = array();
if (isset($_POST['ch_name'])) {
//ユーザ名変更を試みる
//Validationオブジェクト生成
$val = Validation::forge();
//フォームのルール設定
$val->add('uname', 'ユーザ名')->add_rule('valid_string', array('alpha', 'numeric', 'dashes', 'dots', 'punctuation', 'utf8'));
//Validationチェック
if ($val->run()) {
$newname = Input::post('uname');
$data['newname'] = $newname;
Model_Members_General2::setUname($uid, $newname);
$uname = $newname;
}
//Validationオブジェクトをviewに渡す
$data['val'] = $val;
}
if (isset($_POST['ch_image'])) {
//アイコン画像変更を試みる
if (Input::file('upload.name')) {
//アップロードされてるか
//アップロード用初期設定
$config = array('path' => DOCROOT . DS . '/assets/img/uimg', 'ext_whitelist' => array('img', 'jpg', 'jpeg', 'gif', 'png'));
//アップロード基本プロセス
Upload::process($config);
//検証
if (Upload::is_valid()) {
//設定を元に保存
Upload::save();
//保存されたファイル名を変数に入れる
$getfile = Upload::get_files();
$upload_file = $getfile[0]['name'];
} else {
//ファイルがアップロードできなかったとき、
//エラーメッセージをセット
$upload_err = 'ファイルが正しくアップできませんでした。';
$data['upload_err'] = $upload_err;
$this->template = View::forge('members/userpg/userpg_myself_template');
$this->template->title = "旅ログ - " . $uname . "さんのユーザ情報変更";
$this->template->username = $uname;
$this->template->icon = Model_Members_Userinfo::getIcon($uid);
$this->template->uid = $uid;
$this->template->pagename = $uname . "さんのユーザ情報変更";
$this->template->page_num = 5;
$data['name'] = $uid;
$data['pagename'] = $uname . "さんのユーザ情報変更";
$data['info'] = Model_Members_Userinfo::getInfo($uid);
$this->template->content = View::forge('members/userpg/change', $data);
return;
//var_dump($upload_err); exit;
}
//データベースに保存
Model_Members_General2::setProfile($uname, $upload_file);
}
}
$this->template = View::forge('members/userpg/userpg_myself_template');
$this->template->title = "旅ログ - " . $uname . "さんのユーザ情報変更";
$this->template->username = $uname;
$this->template->icon = Model_Members_Userinfo::getIcon($uid);
$this->template->uid = $uid;
$this->template->pagename = $uname . "さんのユーザ情報変更";
$this->template->page_num = 5;
$data['name'] = $uid;
$data['pagename'] = $uname . "さんのユーザ情報変更";
$data['info'] = Model_Members_Userinfo::getInfo($uid);
$this->template->content = View::forge('members/userpg/change', $data);
}
public function action_search($lex)
{
$table = array('prefposts' => "都道府県", 'cate' => "カテゴリ", 't1' => "タグ", 't2' => "タグ", 'rate' => "評価値", 'ikitai' => "行きたい人数", 'itta' => "行った人数", 'usr' => "投稿ユーザ");
$sentence = "";
$jouken = "";
$from = "";
if (isset($lex['prefposts'])) {
$jouken = $jouken . " and p.pref_num = " . $lex['prefposts'];
$pref_name = Model_Members_General::getPrefname($lex['prefposts']);
$sentence = $sentence . $table['prefposts'] . "「" . $pref_name . "」";
}
if (isset($lex['cate'])) {
$jouken = $jouken . " and p.category = " . $lex['cate'];
$cate_name = Model_Members_General::getCatename($lex['cate']);
$sentence = $sentence . $table['cate'] . "「" . $cate_name . "」";
}
if (isset($lex['t1']) xor isset($lex['t2'])) {
if (isset($lex['t1'])) {
$jouken = $jouken . " and (p.tag1 = " . $lex['t1'] . " or p.tag2 = " . $lex['t1'] . ")";
$tag_name = Model_Members_General::getTagname($lex['t1']);
$sentence = $sentence . $table['t1'] . "「" . $tag_name . "」";
} else {
$jouken = $jouken . " and (p.tag1 = " . $lex['t2'] . " or p.tag2 = " . $lex['t2'] . ")";
$tag_name = Model_Members_General::getTagname($lex['t2']);
$sentence = $sentence . $table['t2'] . "「" . $tag_name . "」";
}
}
if (isset($lex['t1']) && isset($lex['t2'])) {
$tmp = " and ((p.tag1 = " . $lex['t1'] . " and p.tag2 = " . $lex['t2'] . ") or (p.tag2 = " . $lex['t1'] . " and p.tag1 = " . $lex['t2'] . "))";
$jouken = $jouken . $tmp;
$tag_name3 = Model_Members_General::getTagname($lex['t1']);
$tag_name4 = Model_Members_General::getTagname($lex['t2']);
$sentence = $sentence . $table['t1'] . "「" . $tag_name3 . "」「" . $tag_name4 . "」";
}
if (isset($lex['rate'])) {
$jouken = $jouken . " and p.rating >= " . $lex['rate'];
$sentence = $sentence . $table['rate'] . "「" . $lex['rate'] . "以上」";
}
if (isset($lex['ikitai'])) {
$jouken = $jouken . " and (select count(*) from ikitai where p.pid = ikitai.pid) >=" . $lex['ikitai'];
$sentence = $sentence . $table['ikitai'] . "「" . $lex['ikitai'] . "以上」";
}
if (isset($lex['itta'])) {
$jouken = $jouken . " and (select count(*) from itta where p.pid = itta.pid) >=" . $lex['itta'];
$sentence = $sentence . $table['itta'] . "「" . $lex['itta'] . "以上」";
}
if (isset($lex['usr'])) {
$jouken = $jouken . " and p.uid = " . $lex['usr'];
$sentence = $sentence . $table['usr'] . "「" . Model_Members_Userinfo::getUsername($lex['usr']) . "」";
}
$this->template = View::forge('members/result_template');
$this->template->title = "旅ログ - 検索結果";
$data = array();
$data['sentence'] = $sentence;
$data['count'] = 0;
$data['posts'] = Model_Members_General2::getPostHeaderJoken($jouken);
$this->template->jouken = $jouken;
$ret = $this->make_option();
$this->template->prefs = $ret['prefs'];
$this->template->cates = $ret['cates'];
$this->template->tags = $ret['tags'];
$this->template->users = $ret['users'];
$this->template->lex = $lex;
$this->template->content = View::forge('members/result', $data);
}
public function action_reviews($wanted_uid)
{
$wanted_username = Model_Members_Userinfo::getUsername($wanted_uid);
$this->template = View::forge('members/userpg/userpg_template');
$this->template->title = "旅ログ - " . $wanted_username . "さんのレビュー一覧";
$this->template->username = $wanted_username;
$this->template->uid = $wanted_uid;
$this->template->icon = Model_Members_Userinfo::getIcon($wanted_uid);
$this->template->pagename = $wanted_username . "さんのレビュー一覧";
$this->template->page_num = 4;
$data = array();
$data['name'] = $wanted_username;
$data['count'] = 0;
$data['pagename'] = $wanted_username . "さんのレビュー一覧";
$data['reviews'] = Model_Members_Userinfo::getReviewHeader($wanted_uid);
$this->template->content = View::forge('members/userpg/reviewlist', $data);
}
