本文整理汇总了PHP中get_sideview函数的典型用法代码示例。如果您正苦于以下问题:PHP get_sideview函数的具体用法?PHP get_sideview怎么用?PHP get_sideview使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了get_sideview函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: qry
function qry($mb_id)
{
if (!IS_MEMBER) {
alert_close("회원만 이용하실 수 있습니다.");
}
$member = unserialize(MEMBER);
if (!$member['mb_open'] && !SU_ADMIN && $member['mb_id'] != $mb_id) {
alert_close("자신의 정보를 공개하지 않으면 다른분의 정보를 조회할 수 없습니다.\\n\\n정보공개 설정은 회원정보수정에서 하실 수 있습니다.");
}
$mb = $this->Basic_model->get_member($mb_id, "mb_id, mb_level, mb_point, mb_homepage, mb_open, mb_nick, mb_datetime, mb_today_login, mb_profile");
if (!isset($mb['mb_id'])) {
alert_close("회원정보가 존재하지 않습니다.\\n\\n탈퇴하였을 수 있습니다.");
}
if (!$mb['mb_open'] && !SU_ADMIN && $member['mb_id'] != $mb_id) {
alert_close("정보공개를 하지 않았습니다.");
}
$name = $this->config->item('cf_use_nick') && $mb['mb_nick'] ? $mb['mb_nick'] : $mb['mb_name'];
$name = get_sideview($mb['mb_id'], $name);
// 회원가입후 몇일째인지? + 1 은 당일을 포함한다는 뜻
$query = $this->db->query("select (TO_DAYS('" . TIME_YMDHIS . "') - TO_DAYS('" . $mb['mb_datetime'] . "') + 1) as days");
$row = $query->row_array();
$mb_reg_after = $row['days'];
$mb_homepage = prep_url($mb['mb_homepage']);
$mb_profile = $mb['mb_profile'] ? conv_content($mb['mb_profile'], FALSE) : "소개 내용이 없습니다.";
$mb_join_date = $member['mb_level'] >= $mb['mb_level'] ? substr($mb['mb_datetime'], 0, 10) . " (" . $mb_reg_after . " 일)" : "알 수 없음";
$mb_last_login = $member['mb_level'] >= $mb['mb_level'] ? $mb['mb_today_login'] : "알 수 없음";
$head = array('title' => $mb['mb_nick'] . "님의 자기소개");
$data = array('name' => $name, 'profile' => $mb_profile, 'homepage' => $mb_homepage, 'point' => number_format($mb['mb_point']), 'join_date' => $mb_join_date, 'last_login' => $mb_last_login);
widget::run('head', $head);
$this->load->view('member/profile', $data);
widget::run('tail');
}
示例2: lists
function lists($flag, $page)
{
$this->load->helper('sideview');
$this->load->library('pagination');
$member = unserialize(MEMBER);
if (!$flag) {
$flag = 'R';
}
if (!$page) {
$page = 1;
}
// 설정일이 지난 메모 삭제
$this->Member_memo_model->cf_delete($member['mb_id']);
if ($member['mb_memo_call']) {
$this->Member_memo_model->call_delete($member['mb_id']);
}
$config['base_url'] = RT_PATH . '/member/memo/lists/' . $flag . '/';
$total_cnt = $this->Member_memo_model->total_cnt($flag, $member['mb_id']);
$config['total_rows'] = $total_cnt;
$config['per_page'] = 10;
$this->pagination->initialize($config);
$offset = ($page - 1) * $config['per_page'];
$result = $this->Member_memo_model->list_result($flag, $member['mb_id'], $config['per_page'], $offset);
$list = array();
$token = get_token();
foreach ($result as $i => $row) {
$name = $this->config->item('cf_use_nick') && $row['mb_nick'] ? $row['mb_nick'] : $row['mb_name'];
$check = 'X';
$check_time = '아직 읽지 않음';
if (substr($row['me_check'], 0, 1) != '0') {
$check = 'O';
$check_time = substr($row['me_check'], 2, 14);
}
$list[$i] = new stdClass();
$list[$i]->me_no = $row['me_no'];
$list[$i]->check = $check;
$list[$i]->check_time = $check_time;
$list[$i]->name = get_sideview($row['me_mb_id'], $name);
$list[$i]->datetime = substr($row['me_datetime'], 2, 14);
$list[$i]->content = cut_str(get_text($row['me_content']), 40);
$list[$i]->view_href = RT_PATH . '/member/memo/view/' . $flag . '/' . $row['me_no'];
$list[$i]->del_href = '_trans/member/memo_delete';
$list[$i]->del_parm = "{flag:'" . $flag . "',me_no:'" . $row['me_no'] . "',token:'" . $token . "'}";
}
if ($flag == 'R') {
$flag_title = '받은';
$me_subject = '보낸이';
} else {
if ($flag == 'S') {
$flag_title = '보낸';
$me_subject = '받는이';
}
}
$head = array('title' => "내 쪽지함");
$data = array('token' => $token, 'path' => RT_PATH . '/member', 'flag_title' => $flag_title, 'total_cnt' => number_format($total_cnt), 'memo_del_day' => $this->config->item('cf_memo_del'), 'me_subject' => $me_subject, 'list' => $list, 'flag' => $flag, 'paging' => $this->pagination->create_links());
widget::run('head', $head);
$this->load->view('member/memo_list', $data);
widget::run('tail');
}
示例3: get_convert
function get_convert($row, $board, $subject_len = 60, $qstr, $list_view = FALSE)
{
$row['href'] = RT_PATH . '/board/' . BO_TABLE . '/view/wr_id/' . $row['wr_id'] . $qstr;
$row['subject'] = cut_str(get_text($row['wr_subject']), $subject_len);
$tmp_name = cut_str(get_text($row['wr_name']), 14);
$row['name'] = $board['bo_use_sideview'] ? get_sideview($row['mb_id'], $tmp_name) : "<span class='" . ($row['mb_id'] ? 'member' : 'guest') . "'>" . $tmp_name . "</span>";
// 당일인 경우 시간으로 표시함
$row['datetime'] = substr($row['wr_datetime'], 0, 10);
$row['datetime2'] = $row['datetime'] == TIME_YMD ? substr($row['wr_datetime'], 11, 5) : substr($row['wr_datetime'], 5, 5);
if ($list_view) {
// 최근 갱신 시간
$row['last'] = substr($row['wr_last'], 0, 10);
$row['last2'] = $row['last'] == TIME_YMD ? substr($row['wr_last'], 11, 5) : substr($row['wr_last'], 5, 5);
$row['comment_cnt'] = '';
if ($row['wr_comment']) {
$row['comment_cnt'] = '(' . $row['wr_comment'] . ')';
}
// 답변 여백
$reply = strlen($row['wr_reply']);
$row['ico_reply'] = '';
if ($reply > 1) {
for ($k = 1; $k < $reply; $k++) {
$row['ico_reply'] .= ' ';
}
}
if ($reply > 0) {
$row['ico_reply'] .= '<span class="glyphicon glyphicon-expand text-danger" title="답변"></span>';
}
$row['ico_new'] = '';
if ($row['wr_datetime'] >= date("Y-m-d H:i:s", time() - $board['bo_new'] * 3600)) {
$row['ico_new'] = '<span class="glyphicon glyphicon-fire text-danger" title="최신"></span>';
}
$row['ico_hot'] = '';
if ($row['wr_hit'] >= $board['bo_hot']) {
$row['ico_hot'] = '<span class="glyphicon glyphicon-flag text-danger" title="이슈 ' . $board['bo_hot'] . 'Hit!"></span>';
}
$row['ico_secret'] = '';
if (strpos($row['wr_option'], 'secret') !== FALSE) {
$row['ico_secret'] = '<span class="glyphicon glyphicon-lock text-danger" title="비밀"></span>';
}
// 가변 파일 - 첨부파일이 0개 이상일 경우에만 실행
$row['ico_file'] = $row['ico_image'] = $row['ico_movie'] = '';
if ($row['wr_count_file'] > 0) {
$row['ico_file'] = '<span class="glyphicon glyphicon-file text-danger" title="파일"></span>';
}
if ($row['wr_count_image'] > 0) {
$row['ico_image'] = '<span class="glyphicon glyphicon-picture text-danger" title="이미지"></span>';
}
if (stripos($row['wr_content'], '<embed')) {
$row['ico_movie'] = '<span class="glyphicon glyphicon-facetime-video text-danger" title="동영상"></span>';
}
}
return $row;
}
示例4: lists
function lists()
{
$this->load->library(array('pagination', 'querystring'));
$this->load->helper(array('admin', 'sideview'));
$param =& $this->querystring;
$page = $this->uri->segment(5, 1);
$sst = $param->get('sst', 'mb_datetime');
$sod = $param->get('sod', 'desc');
$sfl = $param->get('sfl');
$stx = $param->get('stx');
$config['suffix'] = $param->output();
$config['base_url'] = RT_PATH . '/' . ADM_F . '/member/lists/page/';
$config['per_page'] = 15;
$offset = ($page - 1) * $config['per_page'];
$result = $this->Member_model->list_result($sst, $sod, $sfl, $stx, $config['per_page'], $offset);
$config['total_rows'] = $result['total_cnt'];
$this->pagination->initialize($config);
$list = array();
$token = get_token();
foreach ($result['qry'] as $i => $row) {
$list[$i] = new stdClass();
if ($this->config->item('cf_use_nick')) {
$list[$i]->nick = $row['mb_nick'];
}
if (!$row['mb_leave_date']) {
$mb_id_s = get_sideview($row['mb_id'], $row['mb_id']);
} else {
$mb_id_s = '<font color="crimson">' . $row['mb_id'] . '</font>';
}
$list[$i]->id = $row['mb_id'];
$list[$i]->name = $row['mb_name'];
$list[$i]->id_s = $mb_id_s;
$list[$i]->level_select = get_mb_level_select("mb_levels[" . $row['mb_id'] . "]", $row['mb_level'], TRUE);
$list[$i]->point = number_format($row['mb_point']);
$list[$i]->today_login = substr($row['mb_today_login'], 2, 8);
$list[$i]->mailling_chk = $row['mb_mailling'] ? '√' : ' ';
$list[$i]->open_chk = $row['mb_open'] ? '√' : ' ';
$list[$i]->s_mod = icon('수정', 'member/form/u/' . $row['mb_id']);
$list[$i]->s_del = icon('삭제', "javascript:post_send('" . ADM_F . "/_trans/member/delete', {mb_id:'" . $row['mb_id'] . "', token:'" . $token . "'}, true);");
$list[$i]->email_certify = $row['mb_email_certify'];
$list[$i]->mail_certify_chk = preg_match('/[1-9]/', $row['mb_email_certify']) ? '√' : ' ';
}
$head = array('title' => '회원관리');
$data = array('token' => $token, 'list' => $list, 's_add' => icon('작성', 'member/form'), 'use_nick' => $this->config->item('cf_use_nick'), 'sfl' => $sfl, 'stx' => $stx, 'total_cnt' => number_format($result['total_cnt']), 'leave_cnt' => number_format($result['leave_cnt']), 'paging' => $this->pagination->create_links(), 'sort_mb_id' => $param->sort('mb_id'), 'sort_mb_name' => $param->sort('mb_name'), 'sort_mb_nick' => $param->sort('mb_nick'), 'sort_mb_level' => $param->sort('mb_level', 'desc'), 'sort_mb_point' => $param->sort('mb_point', 'desc'), 'sort_mb_today_login' => $param->sort('mb_today_login', 'desc'), 'sort_mb_mailling' => $param->sort('mb_mailling', 'desc'), 'sort_mb_open' => $param->sort('mb_open', 'desc'), 'sort_mb_email_certify' => $param->sort('mb_email_certify', 'desc'));
widget::run('head', $head);
$this->load->view(ADM_F . '/member_list', $data);
widget::run('tail');
}
示例5: substr
} else {
$datetime2 = substr($datetime2, 5, 5);
}
} else {
// 코멘트
$comment = '[코] ';
$comment_link = '#c_' . $row['wr_id'];
$row2 = sql_fetch(" select * from {$tmp_write_table} where wr_id = '{$row['wr_parent']}' ");
$row3 = sql_fetch(" select mb_id, wr_name, wr_email, wr_homepage, wr_datetime from {$tmp_write_table} where wr_id = '{$row['wr_id']}' ");
$list[$i] = $row2;
$list[$i]['wr_id'] = $row['wr_id'];
$list[$i]['mb_id'] = $row3['mb_id'];
$list[$i]['wr_name'] = $row3['wr_name'];
$list[$i]['wr_email'] = $row3['wr_email'];
$list[$i]['wr_homepage'] = $row3['wr_homepage'];
$name = get_sideview($row3['mb_id'], get_text(cut_str($row3['wr_name'], $config['cf_cut_name'])), $row3['wr_email'], $row3['wr_homepage']);
// 당일인 경우 시간으로 표시함
$datetime = substr($row3['wr_datetime'], 0, 10);
$datetime2 = $row3['wr_datetime'];
if ($datetime == G5_TIME_YMD) {
$datetime2 = substr($datetime2, 11, 5);
} else {
$datetime2 = substr($datetime2, 5, 5);
}
}
$list[$i]['gr_id'] = $row['gr_id'];
$list[$i]['bo_table'] = $row['bo_table'];
$list[$i]['name'] = $name;
$list[$i]['comment'] = $comment;
$list[$i]['href'] = './board.php?bo_table=' . $row['bo_table'] . '&wr_id=' . $row2['wr_id'] . $comment_link;
$list[$i]['datetime'] = $datetime;
示例6: get_member
$pp_tax = $row['pp_tax'];
$pp_pay = $row['pp_pay'];
$pp_shingo = $row['pp_shingo'];
//유형
$pp_type = $row['pp_type'] == "2" ? '개인' : '기업';
$pp_company = $row['pp_company'];
$pp_name = '탈퇴(' . $row['mb_id'] . ')';
$pinfo = get_member($row['mb_id'], 'mb_nick, mb_email, mb_homepage');
if ($pinfo['mb_nick']) {
$pp_name = get_sideview($row['mb_id'], $pinfo['mb_nick'], $pinfo['mb_email'], $pinfo['wr_homepage']);
}
$pp_staff = '';
if ($row['pp_staff']) {
$sinfo = get_member($row['pp_staff'], 'mb_nick, mb_email, mb_homepage');
if ($sinfo['mb_nick']) {
$pp_staff = get_sideview($row['pp_staff'], $sinfo['mb_nick'], $sinfo['mb_email'], $sinfo['wr_homepage']);
}
}
//수정
$pp_mod = '<a href="./apms.inquiry.php?no=' . $row['pp_id'] . '" class="mod-inquiry">수정</a>';
$bg = 'bg' . $i % 2;
?>
<tr class="<?php
echo $bg;
?>
">
<td><?php
echo $pp_num;
?>
</td>
示例7: get_sideview
if ($row['pt_leave']) {
//탈퇴
$p_status = '<span class="mb_leave_msg"><strike>' . $row['pt_leave'] . '</strike></span>';
} else {
if ($row['pt_register']) {
//등록
$p_status = $row['pt_register'];
} else {
//신청
$p_status = '<span class="pt-request">신청</span>';
$is_check = true;
}
}
//유형
$p_type = $row['pt_type'] == "2" ? '개인' : '기업';
$p_id = get_sideview($row['pt_id'], $row['pt_id'], $row['pt_email'], '');
//수정
$p_mod = '<a href="./apms.admin.php?ap=pform&' . $qstr . '&pt_id=' . $row['pt_id'] . '">수정</a>';
$bg = 'bg' . $i % 2;
?>
<tr class="<?php
echo $bg;
?>
">
<td headers="mb_list_chk" class="td_chk">
<input type="hidden" name="pt_id[<?php
echo $i;
?>
]" value="<?php
echo $row['pt_id'];
示例8: strip_tags
if ($read_level[$idx] <= $member['mb_level']) {
//$content = cut_str(get_text(strip_tags($row['wr_content'])), 300, "…");
$content = strip_tags($row['wr_content']);
$content = get_text($content, 1);
$content = strip_tags($content);
$content = str_replace(' ', '', $content);
$content = cut_str($content, 300, "…");
if (strstr($sfl, 'wr_content')) {
$content = search_font($stx, $content);
}
} else {
$content = '';
}
$list[$idx][$i]['subject'] = $subject;
$list[$idx][$i]['content'] = $content;
$list[$idx][$i]['name'] = get_sideview($row['mb_id'], get_text(cut_str($row['wr_name'], $config['cf_cut_name'])), $row['wr_email'], $row['wr_homepage']);
$k++;
if ($k >= $rows) {
break;
}
}
sql_free_result($result);
if ($k >= $rows) {
break;
}
$from_record = 0;
}
$write_pages = get_paging(G5_IS_MOBILE ? $config['cf_mobile_pages'] : $config['cf_write_pages'], $page, $total_page, $_SERVER['SCRIPT_NAME'] . '?' . $search_query . '&gr_id=' . $gr_id . '&srows=' . $srows . '&onetable=' . $onetable . '&page=');
}
$group_select = '<label for="gr_id" class="sound_only">게시판 그룹선택</label><select name="gr_id" id="gr_id" class="select"><option value="">전체 분류';
$sql = " select gr_id, gr_subject from {$g5['group_table']} order by gr_id ";
示例9: array
<?php
include_once './_common.php';
$g5['title'] = '현재접속자';
include_once './_head.php';
$list = array();
$sql = " select a.mb_id,b.mb_name, b.mb_email, b.mb_homepage, b.mb_open, b.mb_point, a.lo_ip, a.lo_location, a.lo_url\n from {$g5['login_table']} a left join {$g5['member_table']} b on (a.mb_id = b.mb_id)\n where a.mb_id <> '{$config['cf_admin']}'\n order by a.lo_datetime desc ";
$result = sql_query($sql);
for ($i = 0; $row = sql_fetch_array($result); $i++) {
$row['lo_url'] = get_text($row['lo_url']);
$list[$i] = $row;
if ($row['mb_id']) {
$list[$i]['name'] = get_sideview($row['mb_id'], cut_str($row['mb_name'], $config['cf_cut_name']), $row['mb_email'], $row['mb_homepage']);
} else {
if ($is_admin) {
$list[$i]['name'] = $row['lo_ip'];
} else {
$list[$i]['name'] = preg_replace("/([0-9]+).([0-9]+).([0-9]+).([0-9]+)/", G5_IP_DISPLAY, $row['lo_ip']);
}
}
$list[$i]['num'] = sprintf('%03d', $i + 1);
}
include_once $connect_skin_path . '/current_connect.skin.php';
include_once './_tail.php';
示例10: get_member
$sell_price = $sum['price'];
$item[$i]['send'] = $sc_type;
$item[$i]['sendcost'] = $sc_price;
$item[$i]['point'] = $point;
$item[$i]['sell_price'] = $sell_price;
$item[$i]['qty'] = $sum['qty'];
$item[$i]['qty'] = $sum['qty'];
$tot_point += $point;
$tot_sell_price += $sell_price;
if (!in_array($row['pt_it'], $g5['apms_automation'])) {
$arr_it_orderform[] = $row['it_id'];
}
}
// for 끝
// 자동처리 주문서인지 체크
$is_delivery = false;
if (is_array($arr_it_orderform) && !empty($arr_it_orderform)) {
$is_delivery = true;
}
$buyer = '';
if ($od['mb_id']) {
$mb = get_member($od['mb_id'], 'mb_nick, mb_email, mb_homepage');
if ($mb['mb_nick']) {
$buyer = ' (' . get_sideview($od['mb_id'], $mb['mb_nick'], $mb['mb_email'], $mb['wr_homepage']) . ')';
}
}
define('G5_IS_ADMIN', true);
$g5['title'] = '주문서';
include_once G5_PATH . '/head.sub.php';
include_once $skin_path . '/inquiryview.skin.php';
include_once G5_PATH . '/tail.sub.php';
示例11: array
$list[$i]['content'] = $poll;
$list[$i]['cnt'] = $po['po_cnt' . $i];
if ($total_po_cnt > 0) {
$list[$i]['rate'] = $list[$i]['cnt'] / $total_po_cnt * 100;
}
$bar = (int) ($list[$i]['cnt'] / $max * 100);
$list[$i]['bar'] = $bar;
$list[$i]['num'] = $i;
}
$list2 = array();
// 기타의견 리스트
$sql = " select a.*, b.mb_open\n from {$g5['poll_etc_table']} a\n left join {$g5['member_table']} b on (a.mb_id = b.mb_id)\n where po_id = '{$po_id}' order by pc_id desc ";
$result = sql_query($sql);
for ($i = 0; $row = sql_fetch_array($result); $i++) {
$list2[$i]['pc_name'] = get_text($row['pc_name']);
$list2[$i]['name'] = get_sideview($row['mb_id'], get_text(cut_str($row['pc_name'], 10)), '', '', $row['mb_open']);
$list2[$i]['idea'] = get_text(cut_str($row['pc_idea'], 255));
$list2[$i]['datetime'] = $row['pc_datetime'];
$list2[$i]['del'] = '';
if ($is_admin == 'super' || $row['mb_id'] == $member['mb_id'] && $row['mb_id']) {
$list2[$i]['del'] = '<a href="' . G5_BBS_URL . '/poll_etc_update.php?w=d&pc_id=' . $row['pc_id'] . '&po_id=' . $po_id . '&skin_dir=' . $skin_dir . '" class="poll_delete">';
}
}
// 기타의견 입력
$is_etc = false;
if ($po['po_etc']) {
$is_etc = true;
$po_etc = $po['po_etc'];
if ($member['mb_id']) {
$name = '<b>' . $member['mb_nick'] . '</b> <input type="hidden" name="pc_name" value="' . $member['mb_nick'] . '">';
} else {
示例12: alert_close
<?php
include_once './_common.php';
if (!$member['mb_id']) {
alert_close('회원만 이용하실 수 있습니다.');
}
if (!$member['mb_open'] && $is_admin != 'super' && $member['mb_id'] != $mb_id) {
alert_close('자신의 정보를 공개하지 않으면 다른분의 정보를 조회할 수 없습니다.\\n\\n정보공개 설정은 회원정보수정에서 하실 수 있습니다.');
}
$mb = get_member($mb_id);
if (!$mb['mb_id']) {
alert_close('회원정보가 존재하지 않습니다.\\n\\n탈퇴하였을 수 있습니다.');
}
if (!$mb['mb_open'] && $is_admin != 'super' && $member['mb_id'] != $mb_id) {
alert_close('정보공개를 하지 않았습니다.');
}
$g5['title'] = $mb['mb_nick'] . '님의 자기소개';
include_once G5_PATH . '/head.sub.php';
$mb_nick = get_sideview($mb['mb_id'], $mb['mb_nick'], $mb['mb_email'], $mb['mb_homepage'], $mb['mb_open']);
// 회원가입후 몇일째인지? + 1 은 당일을 포함한다는 뜻
$sql = " select (TO_DAYS('" . G5_TIME_YMDHIS . "') - TO_DAYS('{$mb['mb_datetime']}') + 1) as days ";
$row = sql_fetch($sql);
$mb_reg_after = $row['days'];
$mb_homepage = set_http(clean_xss_tags($mb['mb_homepage']));
$mb_profile = $mb['mb_profile'] ? conv_content($mb['mb_profile'], 0) : '소개 내용이 없습니다.';
include_once $member_skin_path . '/profile.skin.php';
include_once G5_PATH . '/tail.sub.php';
示例13: sql_query
?>
<tr>
<td colspan="<?php
echo $colspan;
?>
" class="text-center" >
데이터가 없습니다.
</td>
</tr>
<?php
}
$qry = sql_query("select * from {$g5['sms5_member_history_table']} where 1 {$sql_search} order by mh_no desc limit {$page_start}, {$page_size}");
while ($row = sql_fetch_array($qry)) {
//$bg = 'bg'.($line++%2);
$mb = get_member($row['mb_id']);
$mb_id = get_sideview($row['mb_id'], $mb['mb_nick']);
?>
<tr>
<td><?php
echo $vnum--;
?>
</td>
<td><?php
echo $mb_id;
?>
</td>
<td><?php
echo $row['mh_reply'];
?>
</td>
<td><?php
示例14: array
}
$list[$i][content] = $poll;
$list[$i][cnt] = $po["po_cnt" . $i];
if ($total_po_cnt > 0) {
$list[$i][rate] = $list[$i][cnt] / $total_po_cnt * 100;
}
$bar = (int) ($list[$i][cnt] / $max * 100);
$list[$i][bar] = $bar;
$list[$i][num] = $i;
}
$list2 = array();
// 기타의견 리스트
$sql = " select a.*, b.mb_open\n from {$g4['poll_etc_table']} a\n left join {$g4['member_table']} b on (a.mb_id = b.mb_id)\n where po_id = '{$po_id}' order by pc_id desc ";
$result = sql_query($sql);
for ($i = 0; $row = sql_fetch_array($result); $i++) {
$list2[$i][name] = get_sideview($row[mb_id], cut_str($row[pc_name], 10), '', '', $row[mb_open]);
$list2[$i][idea] = get_text(cut_str($row[pc_idea], 255));
$list2[$i][datetime] = $row[pc_datetime];
$list2[$i][del] = "";
if ($is_admin == "super" || $row[mb_id] == $member[mb_id] && $row[mb_id]) {
$list2[$i][del] = "<a href=\"javascript:del('./poll_etc_update.php?w=d&pc_id={$row['pc_id']}&po_id={$po_id}');\">";
}
}
// 기타의견 입력
$is_etc = false;
if ($po[po_etc]) {
$is_etc = true;
$po_etc = $po[po_etc];
if ($member[mb_id]) {
$name = "<b>{$member['mb_nick']}</b> <input type='hidden' name='pc_name' value='{$member['mb_nick']}'>";
} else {
示例15: lists
function lists()
{
$config = array(array('field' => 'mb_id', 'label' => '아이디', 'rules' => 'trim|required|max_length[20]|xss_clean'), array('field' => 'po_content', 'label' => '포인트내용', 'rules' => 'trim|required'), array('field' => 'po_point', 'label' => '포인트', 'rules' => 'trim|required|numeric'));
$this->form_validation->set_rules($config);
if ($this->form_validation->run() == FALSE) {
$param =& $this->querystring;
$page = $this->uri->segment(5, 1);
$sst = $param->get('sst', 'po_id');
$sod = $param->get('sod', 'desc');
$sfl = $param->get('sfl');
$stx = $param->get('stx');
$config['suffix'] = $param->output();
$config['base_url'] = RT_PATH . '/' . ADM_F . '/point/lists/page/';
$config['per_page'] = 15;
$offset = ($page - 1) * $config['per_page'];
$result = $this->Point_model->list_result($sst, $sod, $sfl, $stx, $config['per_page'], $offset);
$config['total_rows'] = $result['total_cnt'];
$this->pagination->initialize($config);
if ($sfl == 'mb_id' && $stx && $result['total_cnt'] > 0) {
$total_pnt = $stx . ' 님 포인트 합계 : ' . number_format($result['total_pnt']) . '점';
$stx_mb_id = TRUE;
} else {
$total_pnt = '전체 포인트 합계 : ' . number_format($result['total_pnt']) . '점';
}
$list = array();
foreach ($result['qry'] as $i => $row) {
$list[$i] = new stdClass();
if ($this->config->item('cf_use_nick')) {
$list[$i]->mb_nick = $row['mb_nick'];
}
$link1 = $link2 = '';
if (!preg_match("/^\\@/", $row['po_rel_table']) && $row['po_rel_table']) {
$po_content = "<a href='" . RT_PATH . "/board/view/tbl/" . $row['po_rel_table'] . "/" . $row['po_rel_id'] . " target=_blank'>" . $row['po_content'] . "</a>";
} else {
$po_content = $row['po_content'];
}
$list[$i]->id = $row['po_id'];
$list[$i]->mb_id = $row['mb_id'];
$list[$i]->datetime = substr($row['po_datetime'], 2, 8);
$list[$i]->content = $po_content;
$list[$i]->point = number_format($row['po_point']);
$list[$i]->mb_name = get_sideview($row['mb_id'], $row['mb_name']);
$list[$i]->mb_point = number_format($row['mb_point']);
}
$head = array('title' => '포인트관리');
$data = array('token' => get_token(), 'list' => $list, 'use_nick' => $this->config->item('cf_use_nick'), 'sfl' => $sfl, 'stx' => $stx, 'stx_mb_id' => isset($stx_mb_id) ? $stx : '', 'total_cnt' => number_format($result['total_cnt']), 'total_pnt' => $total_pnt, 'paging' => $this->pagination->create_links(), 'sort_mb_id' => $param->sort('mb_id'), 'sort_po_datetime' => $param->sort('po_datetime'), 'sort_po_content' => $param->sort('po_content'), 'sort_po_point' => $param->sort('po_point'));
widget::run('head', $head);
$this->load->view(ADM_F . '/point_list', $data);
widget::run('tail');
} else {
check_token();
$member = unserialize(MEMBER);
$mb_id = $this->input->post('mb_id');
$po_point = $this->input->post('po_point');
$mb = $this->Basic_model->get_member($mb_id, 'mb_id,mb_point');
if (!isset($mb['mb_id'])) {
alert('존재하는 회원아이디가 아닙니다.');
}
if ($po_point < 0 && $po_point * -1 > $mb['mb_point']) {
alert('포인트를 깎는 경우 현재 포인트보다 작으면 안됩니다.');
}
$this->load->model('Point_model');
$this->Point_model->insert($mb_id, $po_point, $this->input->post('po_content'), '@passive', $mb_id, $member['mb_id'] . '-' . uniqid(''));
goto_url(ADM_F . '/point/lists');
}
}