|
Server : Apache/2.2.17 (Unix) mod_ssl/2.2.17 OpenSSL/0.9.8e-fips-rhel5 DAV/2 PHP/5.2.17 System : Linux localhost 2.6.18-419.el5 #1 SMP Fri Feb 24 22:47:42 UTC 2017 x86_64 User : nobody ( 99) PHP Version : 5.2.17 Disable Function : NONE Directory : /home/queenjbs/xe/modules/poll/ |
Upload File : |
<?php
/**
* @class pollController
* @author zero (zero@nzeo.com)
* @brief poll모듈의 Controller class
**/
class pollController extends poll {
/**
* @brief 초기화
**/
function init() {
}
/**
* @brief 팝업창에서 설문 작성 완료후 저장을 누를때 설문 등록
**/
function procInsert() {
$stop_date = Context::get('stop_date');
if($stop_date < date("Ymd")) $stop_date = date("YmdHis", time()+60*60*24*365);
$vars = Context::getRequestVars();
foreach($vars as $key => $val) {
if(strpos($key,'tidx')) continue;
if(!preg_match("/^(title|checkcount|item)_/i", $key)) continue;
if(!trim($val)) continue;
$tmp_arr = explode('_',$key);
$poll_index = $tmp_arr[1];
if(Context::get('is_logged')) {
$logged_info = Context::get('logged_info');
// 세션에서 최고 관리자가 아니면 태그 제거
if($logged_info->is_admin != 'Y') $val = htmlspecialchars($val);
}
if($tmp_arr[0]=='title') $tmp_args[$poll_index]->title = $val;
else if($tmp_arr[0]=='checkcount') $tmp_args[$poll_index]->checkcount = $val;
else if($tmp_arr[0]=='item') $tmp_args[$poll_index]->item[] = $val;
}
foreach($tmp_args as $key => $val) {
if(!$val->checkcount) $val->checkcount = 1;
if($val->title && count($val->item)) $args->poll[] = $val;
}
if(!count($args->poll)) return new Object(-1, 'cmd_null_item');
$args->stop_date = $stop_date;
// 변수 설정
$poll_srl = getNextSequence();
$logged_info = Context::get('logged_info');
$member_srl = $logged_info->member_srl?$logged_info->member_srl:0;
$oDB = &DB::getInstance();
$oDB->begin();
// 설문의 등록
unset($poll_args);
$poll_args->poll_srl = $poll_srl;
$poll_args->member_srl = $member_srl;
$poll_args->list_order = $poll_srl*-1;
$poll_args->stop_date = $args->stop_date;
$poll_args->poll_count = 0;
$output = executeQuery('poll.insertPoll', $poll_args);
if(!$output->toBool()) {
$oDB->rollback();
return $output;
}
// 개별 설문 등록
foreach($args->poll as $key => $val) {
unset($title_args);
$title_args->poll_srl = $poll_srl;
$title_args->poll_index_srl = getNextSequence();
$title_args->title = $val->title;
$title_args->checkcount = $val->checkcount;
$title_args->poll_count = 0;
$title_args->list_order = $title_args->poll_index_srl * -1;
$title_args->member_srl = $member_srl;
$title_args->upload_target_srl = $upload_target_srl;
$output = executeQuery('poll.insertPollTitle', $title_args);
if(!$output->toBool()) {
$oDB->rollback();
return $output;
}
// 개별 설문의 항목 추가
foreach($val->item as $k => $v) {
unset($item_args);
$item_args->poll_srl = $poll_srl;
$item_args->poll_index_srl = $title_args->poll_index_srl;
$item_args->title = $v;
$item_args->poll_count = 0;
$item_args->upload_target_srl = $upload_target_srl;
$output = executeQuery('poll.insertPollItem', $item_args);
if(!$output->toBool()) {
$oDB->rollback();
return $output;
}
}
}
$oDB->commit();
$this->add('poll_srl', $poll_srl);
$this->setMessage('success_registed');
}
/**
* @brief 설문 조사에 응함
**/
function procPoll() {
$poll_srl = Context::get('poll_srl');
$poll_srl_indexes = Context::get('poll_srl_indexes');
$tmp_item_srls = explode(',',$poll_srl_indexes);
for($i=0;$i<count($tmp_item_srls);$i++) {
$srl = (int)trim($tmp_item_srls[$i]);
if(!$srl) continue;
$item_srls[] = $srl;
}
// 응답항목이 없으면 오류
if(!count($item_srls)) return new Object(-1, 'msg_check_poll_item');
// 이미 설문하였는지 조사
$oPollModel = &getModel('poll');
if($oPollModel->isPolled($poll_srl)) return new Object(-1, 'msg_already_poll');
$oDB = &DB::getInstance();
$oDB->begin();
$args->poll_srl = $poll_srl;
// 해당 글의 모든 설문조사의 응답수 올림
$output = executeQuery('poll.updatePoll', $args);
$output = executeQuery('poll.updatePollTitle', $args);
if(!$output->toBool()) {
$oDB->rollback();
return $output;
}
// 각 설문조사의 선택된 항목을 기록
$args->poll_item_srl = implode(',',$item_srls);
$output = executeQuery('poll.updatePollItems', $args);
if(!$output->toBool()) {
$oDB->rollback();
return $output;
}
// 응답자 정보를 로그로 남김
$log_args->poll_srl = $poll_srl;
$logged_info = Context::get('logged_info');
$member_srl = $logged_info->member_srl?$logged_info->member_srl:0;
$log_args->member_srl = $member_srl;
$log_args->ipaddress = $_SERVER['REMOTE_ADDR'];
$output = executeQuery('poll.insertPollLog', $log_args);
if(!$output->toBool()) {
$oDB->rollback();
return $output;
}
$oDB->commit();
$skin = Context::get('skin');
if(!$skin || !is_dir('./modules/poll/skins/'.$skin)) $skin = 'default';
// tpl 가져오기
$tpl = $oPollModel->getPollHtml($poll_srl, '', $skin);
$this->add('poll_srl', $poll_srl);
$this->add('tpl',$tpl);
$this->setMessage('success_poll');
}
/**
* @brief 결과 미리 보기
**/
function procPollViewResult() {
$poll_srl = Context::get('poll_srl');
$skin = Context::get('skin');
if(!$skin || !is_dir('./modules/poll/skins/'.$skin)) $skin = 'default';
$oPollModel = &getModel('poll');
$tpl = $oPollModel->getPollResultHtml($poll_srl, $skin);
$this->add('poll_srl', $poll_srl);
$this->add('tpl',$tpl);
}
/**
* @brief 게시글 등록시 poll 연결하는 trigger
**/
function triggerInsertDocumentPoll(&$obj) {
$this->syncPoll($obj->document_srl, $obj->content);
return new Object();
}
/**
* @brief 댓글 등록시 poll 연결하는 trigger
**/
function triggerInsertCommentPoll(&$obj) {
$this->syncPoll($obj->comment_srl, $obj->content);
return new Object();
}
/**
* @brief 게시글 수정시 poll 연결하는 trigger
**/
function triggerUpdateDocumentPoll(&$obj) {
$this->syncPoll($obj->document_srl, $obj->content);
return new Object();
}
/**
* @brief 댓글 등록시 poll 연결하는 trigger
**/
function triggerUpdateCommentPoll(&$obj) {
$this->syncPoll($obj->comment_srl, $obj->content);
return new Object();
}
/**
* @brief 게시글 삭제시 poll 삭제하는 trigger
**/
function triggerDeleteDocumentPoll(&$obj) {
$document_srl = $obj->document_srl;
if(!$document_srl) return new Object();
// 설문조사를 구함
$args->upload_target_srl = $document_srl;
$output = executeQuery('poll.getPollByTargetSrl', $args);
if(!$output->data) return new Object();
$poll_srl = $output->data->poll_srl;
if(!$poll_srl) return new Object();
$args->poll_srl = $poll_srl;
$output = executeQuery('poll.deletePoll', $args);
if(!$output->toBool()) return $output;
$output = executeQuery('poll.deletePollItem', $args);
if(!$output->toBool()) return $output;
$output = executeQuery('poll.deletePollTitle', $args);
if(!$output->toBool()) return $output;
$output = executeQuery('poll.deletePollLog', $args);
if(!$output->toBool()) return $output;
return new Object();
}
/**
* @brief 댓글 삭제시 poll 삭제하는 trigger
**/
function triggerDeleteCommentPoll(&$obj) {
$comment_srl = $obj->comment_srl;
if(!$comment_srl) return new Object();
// 설문조사를 구함
$args->upload_target_srl = $comment_srl;
$output = executeQuery('poll.getPollByTargetSrl', $args);
if(!$output->data) return new Object();
$poll_srl = $output->data->poll_srl;
if(!$poll_srl) return new Object();
$args->poll_srl = $poll_srl;
$output = executeQuery('poll.deletePoll', $args);
if(!$output->toBool()) return $output;
$output = executeQuery('poll.deletePollItem', $args);
if(!$output->toBool()) return $output;
$output = executeQuery('poll.deletePollTitle', $args);
if(!$output->toBool()) return $output;
$output = executeQuery('poll.deletePollLog', $args);
if(!$output->toBool()) return $output;
return new Object();
}
/**
* @brief 게시글 내용의 설문조사를 구해와서 문서 번호와 연결
**/
function syncPoll($upload_target_srl, $content) {
$match_cnt = preg_match_all('!<img([^\>]*)poll_srl=(["\']?)([0-9]*)(["\']?)([^\>]*?)\>!is',$content, $matches);
for($i=0;$i<$match_cnt;$i++) {
$poll_srl = $matches[3][$i];
$args = null;
$args->poll_srl = $poll_srl;
$output = executeQuery('poll.getPoll', $args);
$poll = $output->data;
if($poll->upload_target_srl) continue;
$args->upload_target_srl = $upload_target_srl;
$output = executeQuery('poll.updatePollTarget', $args);
$output = executeQuery('poll.updatePollTitleTarget', $args);
$output = executeQuery('poll.updatePollItemTarget', $args);
}
}
}
?>