source: OpenPNE/branches/ebihara/prj_dev26_bizfix/webapp_biz/lib/db/group.php @ 1332

<?php
/**
 * @copyright 2005-2006 OpenPNE Project
 * @license   http://www.php.net/license/3_01.txt PHP License 3.01
 */

/**
 * グループを削除する
 * 
 * @param int $biz_group_id
 */
function db_group_delete_biz_group($biz_group_id)
{
    //TODO できればTodo等の削除処理には関数を使う

    $sql = 'DELETE FROM biz_group_member WHERE biz_group_id = ?';
    $params = array(
        intval($biz_group_id),
    );
    $result = db_query($sql, $params);
    $sql = 'DELETE FROM biz_group WHERE biz_group_id = ?';
    $params = array(
        intval($biz_group_id),
    );    $result = db_query($sql, $params);


    $sql = 'UPDATE biz_schedule SET public_flag = "private", biz_group_id = NULL WHERE biz_group_id = ?';
    db_query($sql, array(intval($group_id)));

    $sql = 'DELETE FROM biz_todo WHERE biz_group_id = ?'; 
    db_query($sql, array(intval($biz_group_id))); 

}

/**
 * グループ画像を削除
 * 
 * @param int $biz_group_id
 * @param string $image_filename
 */
function db_group_delete_biz_group_image($biz_group_id, $image_filename)
{
    //TODO db_update関数を使う

    $sql = 'UPDATE `biz_group` SET `image_filename` = \'\' WHERE `biz_group_id` = ?';
    $params = array(
        intval($biz_group_id),
    );
    db_query($sql, $params);
    biz_deleteImage($image_filename);
}

/**
 * グループを編集する
 * 
 * @param int $biz_group_id
 * @param string $name
 * @param int $c_member_id
 * @param string $info
 * @param string $image_filename
 * @param array $members グループに所属しているメンバー
 */
function db_group_update_biz_group($biz_group_id, $name, $c_member_id, $info = '', $image_filename = '', $members = array())
{
    //TODO グループメンバーについては関数を別にする？
    //TODO パラメータの順序をわかりやすくする
    //TODO db_updateを使う

    if (empty($members)) {
        $members = array($c_member_id);
    }

    //biz_groupにデータを追加する

    $sql = 'UPDATE `biz_group` SET `name` = ?,`info` = ?,`image_filename` = ? WHERE `biz_group_id` = ?';
    $params = array(
        $name,
        $info,
        $image_filename,
        intval($biz_group_id),
    );
    db_query($sql, $params);

    $sql = 'DELETE FROM biz_group_member WHERE biz_group_id = ?';
    $params = array(
        intval($biz_group_id),
    );
    $result = db_query($sql, $params);

    foreach ($members as $key => $value) {
        $data = array(
            'c_member_id' => $value,
            'biz_group_id' => intval($biz_group_id),
        );
        db_insert('biz_group_member', $data);
    }
}

/**
 * 所属グループ数を取得
 */
function db_group_count_biz_group4c_member_id($id)
{
    //TODO パラメータ見直し
    //TODO SELECT COUNT(*)を使う
    $sql = 'SELECT * FROM biz_group_member WHERE c_member_id = ?';

    $params = array(
        intval($id),
    );


    return count(db_get_col($sql, $params));
}

/**
 * グループの情報を取得する
 */
function db_group_biz_group4biz_group_id($id)
{
    //TODO パラメータ見直し
    $sql = "SELECT * FROM biz_group WHERE biz_group_id = ?";
    $params = array(
        intval($id),
    );
    if (!$group = db_get_row($sql, $params))
        return array();

    return $group;
}

/**
 * グループを検索
 */
function db_group_serach_biz_group($keyword='', $start=0, $num=20, $order='biz_group_id')
{
    //TODO パラメータ見直し
    //TODO SELECT COUNT(*)を使う
    
    //keywordあり
    if ($keyword) {
        $sql = 'SELECT * FROM biz_group WHERE 1 AND (info LIKE ? OR name LIKE ?) ORDER BY ?';

        $params = array(
            '%'.$keyword.'%',
            '%'.$keyword.'%',
            $order,
        );
        $list = db_get_all_limit($sql, $start, ($start + $num), $params);
    //keywordなし(全件表示)
    } else {
        $sql = 'SELECT * FROM biz_group ORDER BY ?';

        $params = array(
            $order,
        );
        $list = db_get_all_limit($sql, $start, ($start + $num), $params);
    }

    if (!$list) {
        return array();
    }

    foreach ($list as $key => $value) {
        $count = count(db_group_biz_group_member_list4biz_group_id($value['biz_group_id']));
        $list[$key]['count'] = $count;
    }

    return $list;
}

/**
 * グループのメンバーリストを取得
 */
function db_group_biz_group_member_list4biz_group_id($id, $limit=null, $start=null)
{
    //TODO パラメータ見直し
    $params = array(
        intval($id),
    );

    $sql = 'SELECT * FROM biz_group_member WHERE biz_group_id = ? ';

    if ($start) {
        $sql .= 'AND c_member_id <= ? ';
        $params[] = $start;
    }

    $sql .= 'ORDER BY c_member_id';

    if ($limit) {
        $list = db_get_all_limit($sql, 0, $limit, $params);
    } else {
        $list = db_get_all($sql, $params);
    }

    return $list;
}

/**
 * グループのメンバーリストを取得
 */
function db_group_biz_group_list4c_member_id_2($id, $limit = null)
{
    $list = array();
    $sql = "SELECT * FROM biz_group_member";
    $sql .= " WHERE c_member_id = ?";
    $sql .= " ORDER BY RAND()";

    $params = array(
        intval($id),
    );

    if (!is_null($limit)) {
        $list = db_get_all_limit($sql, 0, intval($limit), $params);
    } else {
        $list = db_get_all($sql, $params);
    }

    foreach ($list as $key => $value) {
        $list[$key] += db_group_biz_group4biz_group_id($value['biz_group_id']);
        $list[$key]['count'] = count(db_group_biz_group_member_list4biz_group_id($value['biz_group_id']));
    }

    return $list;
}

/**
 * 所属グループリストを取得する
 */
function db_group_biz_group_list4c_member_id($c_member_id, $page = 1, $page_size = 20)
{
    $start = ($page - 1) * $page_size;

    $sql = "SELECT biz_group.*" .
            " FROM biz_group_member , biz_group";
    $sql .= " WHERE biz_group_member.c_member_id = ?";
    $sql .= " AND biz_group.biz_group_id=biz_group_member.biz_group_id";
    $sql .= " ORDER BY biz_group.biz_group_id DESC ";

    $params = array(
        intval($c_member_id),
    );

    $biz_group_list = db_get_all_limit($sql, $start, $page_size, $params);

    foreach ($biz_group_list as $key => $value) {
        $biz_group_list[$key]['count_members'] =
           count(db_group_biz_group_member_list4biz_group_id($value['biz_group_id']));
    }

    $pager = array(
        "total_num" => db_group_count_biz_group4c_member_id($c_member_id),
        "disp_num"  => count($biz_group_list),
        "start_num" => 0,
        "end_num"   => 0,
        "total_page" => 0,
        "prev_page" => 0,
        "next_page" => 0,
    );

    if ($pager['disp_num'] > 0) {
        $pager['start_num'] = $start + 1;
        $pager['end_num'] = $pager['start_num'] + $pager['disp_num'] - 1;
    }

    if ($pager['total_num']) {  
        $pager['total_page'] = ceil($pager['total_num'] / $page_size);

        if ($page < $pager['total_page']) {
            $pager['next_page'] = max($page + 1, 1);
        }
        if ($page > 1) {
            $pager['prev_page'] = min($page - 1, $pager['total_page']);
        }
    }

    return array($biz_group_list, $pager);
}

/**
 * グループの作成
 */
function db_group_insert_biz_group($name, $member_id, $info, $image_name, $members = array())
{   
    //TODO パラメータ見直し
    //TODO $image_name =''に

    if (!$image_name) {
        $image_name = 0;
    }
    if (!$info) {
        $info = "";
    }
    if (empty($members)) {
        $members = array($member_id);
    }

    //biz_groupにデータを追加する
    $data = array(
        'name' => $name,
        'info' => $info,
        'admin_id' => intval($member_id),
        'image_filename' => $image_name,
    );
    $new_group_id = db_insert('biz_group', $data);

    foreach ($members as $key => $value) {
        $data = array(
            'c_member_id' => $value,
            'biz_group_id' => $new_group_id,
        );
        db_insert('biz_group_member', $data);
    }
}

/**
 * グループのメンバーかどうかを判定
 */
function db_group_is_biz_group_member($member_id, $group_id)
{
    $sql = 'SELECT * FROM biz_group_member WHERE c_member_id = ? AND biz_group_id = ?';
    $params = array(
        intval($member_id),
        intval($group_id),
    );

    return db_get_one($sql, $params);
}

/**
 * グループにメンバーを追加
 */
function db_group_insert_biz_group_member($member_id, $group_id)
{
    $data = array(
        'c_member_id' => intval($member_id),
        'biz_group_id' => intval($group_id),
    );
    db_insert('biz_group_member', $data);
}

?>