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'];
//最新書き込みコミュニティ５件
$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;
}
