function execute($requests) { $u = $GLOBALS['KTAI_C_MEMBER_ID']; // --- リクエスト変数 $search_word = $requests['search_word']; $target_c_commu_category_id = $requests['target_c_commu_category_id']; $page = $requests['page']; // ---------- //search log do_common_insert_search_log($u, $search_word); $page_size = 10; //ページ $this->set("page", $page); //search_word $this->set("search_word", $search_word); //検索に用いたカテゴリ $this->set("target_c_commu_category_id", $target_c_commu_category_id); //カテゴリのリスト $this->set("c_commu_category_list", db_commu_c_commu_category4null()); //検索結果 $list = db_commu_c_commu_list4c_commu_category_id_search($target_c_commu_category_id, $page_size, $page, $search_word); $this->set("c_commu_search_result", $list[0]); $this->set("count_total", $list[3]); $this->set("is_prev", $list[1]); $this->set("is_next", $list[2]); return 'success'; }
function execute($requests) { $c_commu_category_list = db_commu_c_commu_category4null(); $this->set("c_commu_category_list", $c_commu_category_list); // 表示用データ作成 $date['month'] = create_option_values(1, 12); $date['day'] = create_option_values(1, 31); $this->set("date", $date); return 'success'; }
function execute($requests) { $u = $GLOBALS['KTAI_C_MEMBER_ID']; //最新書き込みコミュニティ5件 $this->set("c_commu_list_lastupdated", db_commu_c_commu_list_lastupdated(5)); //子カテゴリのリスト $this->set("c_commu_category_list", db_commu_c_commu_category4null()); //親カテゴリのリスト $this->set('c_commu_category_parent_list', db_commu_c_commu_category_parent_list4null()); // 作成可能カテゴリリスト $this->set('c_commu_category_is_create_commu', db_commu_c_commu_category4is_create_commu()); return 'success'; }
function _db_c_commu_category4null() { return db_commu_c_commu_category4null(); }
function execute($requests) { $u = $GLOBALS['AUTH']->uid(); // --- リクエスト変数 $name = $requests['name']; $c_commu_category_id = $requests['c_commu_category_id']; $info = $requests['info']; $is_admit = $requests['is_admit']; $is_open = $requests['is_open']; // ---------- $upfile_obj = $_FILES['image_filename']; //Category Check if (!db_commu_c_commu_category4is_create_commu()) { openpne_redirect('pc', 'page_h_err_c_commu_add'); } //TODO: $err_msg = array(); if (db_commu_is_commu4c_commu_name($name)) { $err_msg[] = 'その' . WORD_COMMUNITY . 'はすでに存在します'; } if (!db_commu_c_commu_category_is_create_commu($c_commu_category_id)) { $err_msg[] = '指定されたカテゴリは選択できません'; } if (!empty($upfile_obj) && $upfile_obj['error'] !== UPLOAD_ERR_NO_FILE) { if (!($image = t_check_image($upfile_obj))) { $err_msg[] = '画像は' . IMAGE_MAX_FILESIZE . 'KB以内のGIF・JPEG・PNGにしてください'; } // 画像アップロード可能サイズチェック $filesize = $image['size']; $result = util_image_check_add_image_upload($filesize, $u, 'other'); if ($result) { $err_msg[] = util_image_get_upload_err_msg($result); } } if ($err_msg) { $_REQUEST['err_msg'] = $err_msg; openpne_forward('pc', 'page', "h_com_add"); exit; } //----- $this->set('inc_navi', fetch_inc_navi('h')); $c_commu_category_list = db_commu_c_commu_category4null(); $public_flag_list = array('is_admit' => array('public' => '誰でも参加可能', 'auth' => '管理者の承認が必要'), 'is_open' => array('public' => '全員に公開', 'member' => WORD_COMMUNITY . '参加者にのみ公開')); foreach ($c_commu_category_list as $each_c_commu_categfory) { if ($each_c_commu_categfory['c_commu_category_id'] == $c_commu_category_id) { $c_commu_category_value = $each_c_commu_categfory['name']; } } $is_admit_value = $public_flag_list['is_admit'][$is_admit]; $is_open_value = $public_flag_list['is_open'][$is_open]; $this->set("c_commu_category_value", $c_commu_category_value); $this->set("is_admit_value", $is_admit_value); $this->set("is_open_value", $is_open_value); //画像をvar/tmpフォルダにコピー $sessid = session_id(); t_image_clear_tmp($sessid); if (file_exists($upfile_obj["tmp_name"])) { $tmpfile = t_image_save2tmp($upfile_obj, $sessid, "c"); } $form_val = array('name' => $name, 'c_commu_category_id' => $c_commu_category_id, 'info' => $info, 'is_admit' => $is_admit, 'is_open' => $is_open, 'tmpfile' => $tmpfile, 'image_filename' => $upfile_obj['name']); $this->set("form_val", $form_val); return 'success'; }
function db_commu_c_commu_category_list4null() { $list = db_commu_c_commu_category4null(); // カテゴリごとのコミュニティ数を取得 $sql = 'SELECT c_commu_category_id, COUNT(*) as count FROM c_commu' . ' GROUP BY c_commu_category_id'; $counts = db_get_assoc($sql); $c_commu_category_list = array(); foreach ($list as $item) { $item['count_commu_category'] = intval($counts[$item['c_commu_category_id']]); $c_commu_category_list[$item['c_commu_category_parent_id']][] = $item; } return $c_commu_category_list; }