/**
* 录入
*
*/
public function actionCreate()
{
parent::_acl('consult_create');
$model = new Consult();
if (isset($_POST['Consult'])) {
$model->attributes = $_POST['Consult'];
if ($model->save()) {
AdminLogger::_create(array('catalog' => 'create', 'intro' => '录入QQ号,ID:' . $model->id));
$this->redirect(array('index'));
}
}
$this->render('create', array('model' => $model));
}
public function QpageAction($id)
{
$qpage = new Consult($this->context);
$qdate = new ConsQue($this->context, 'id = "' . $id . '"');
$cat = new ConsultUser($this->context, 'uid = "' . $_SESSION['auth']['id'] . '"');
if (!empty($_SESSION['auth']['id'])) {
if ($qdate->uid == 0 && $qdate->cid == $cat->cid) {
$this->db->prepare('update consult_questions set uid =' . $_SESSION['auth']['id'] . ' where id =' . $id)->execute();
return AddAlertMessage('success', 'Вопрос стал личным.', '/consult/q-' . $qdate->id);
}
if (!empty($_POST)) {
$ans_wer = Tools::getValue('body');
$time = date("Y-m-d H:i:s", time());
$email = $qdate->email;
$uri = $qdate->pid == 0 ? $uri = 'http://dev.karapuz/consult/ask/?cn=' . $qdate->cid . '&ex=' . $qdate->uid . '&q=' . $qdate->id : ($uri = 'http://dev.karapuz/consult/ask/?cn=' . $qdate->cid . '&ex=' . $qdate->uid . '&q=' . $qdate->pid);
$content = array('title' => 'Вы получили ответ', 'template' => 'expert_answer', 'data' => array('year' => date("Y,M,D", time()), 'name' => $qdate->name, 'answer' => $ans_wer, 'uri' => $uri));
$this->db->prepare('update consult_questions set answer = "' . $ans_wer . '", isAnswer = 0, answerdate = "' . $time . '" where id =' . $id)->execute();
//$sendAnswer = SendEmailSMTP('', '', $email, $content);
//if ($sendAnswer !== true) return AddAlertMessage('danger', 'Ошибка при отправке письма!', '/');
return AddAlertMessage('success', 'Ответ был успешно добавлен.', '/consult/cn-' . $qdate->cid . '/ex-' . $qdate->uid);
}
}
$qdate->pid != 0 ? $pid = $qdate->pid : ($pid = $qdate->id);
$qdate->uid > 0 ? $qpuid = $qdate->uid : ($qpuid = 1);
$disquz = $this->db->query('
select CQ.id, CQ.title, CQ.body, CQ.name, CQ.answer, CQ.isAnswer, CQ.pid pid, CQ.questiondate, CQ.answerdate, CQ.uid, CQ.cid, UD.FirstName, UD.LastName, CC.name cname
from consult_questions CQ, userdata UD, consult_category CC
where CQ.isActive = 1 and CQ.pid=' . $pid . ' and UD.UserID = ' . $qpuid . ' and CQ.cid=CC.id
order by CQ.id ASC
')->fetchall();
$disquzz = $this->db->query('
select CQ.id, CQ.title, CQ.body, CQ.name, CQ.answer, CQ.isAnswer, CQ.pid pid, CQ.questiondate, CQ.answerdate, CQ.uid, CQ.cid, UD.FirstName, UD.LastName, CC.name cname
from consult_questions CQ, userdata UD, consult_category CC
where CQ.isActive = 1 and CQ.id=' . $pid . ' and UD.UserID = ' . $qpuid . ' and CQ.cid=CC.id
order by CQ.id ASC
')->fetch();
$qpage->getPOST();
$category = $this->db->query('select id, name, alt_name, small_img from consult_category')->fetchall();
$questions = $this->db->query('select id, title, body, answer from consult_questions where isActive = 1 ORDER BY id DESC ')->fetchall();
$expert = $this->db->query('
SELECT cc.id, cc.name, cc.alt_name, ud.FirstName, ud.LastName, ud.UserID
FROM UserData as ud, consult_category as cc, consult_user_category as cu
WHERE ud.UserID=cu.uid and cc.id=cu.cid
')->fetchall();
$this->view->breadcrumbs = array(array('url' => '/', 'title' => 'Главная'), array('url' => '/consult/', 'title' => 'Консультации'), array('url' => '../consult/q-' . $id, 'title' => $qdate->title));
$this->view->setVars(array('category' => $category, 'expert' => $expert, 'questions' => $questions, 'qdate' => $qdate, 'disquz' => $disquz, 'disquzz' => $disquzz));
$this->view->generate();
}
} else {
$fila = $array;
}
} catch (Exception $e) {
echo 'Excepción capturada: ', $e->getMessage(), "\n";
}
return $fila;
}
}
$usuario = $_POST['data_usuario'];
$password = $_POST['data_password'];
$respuesta = null;
if ($usuario && !empty($password)) {
$obj_consult = null;
$action = $_POST['action'];
if ($action == 'searchUser') {
$obj_consult = new Consult($usuario, $password);
$row = $obj_consult->searchUser();
if (count($row) > 0) {
$row2 = $obj_consult->descargaApk($row);
if ($row2) {
$respuesta = $row2[0];
} else {
$respuesta = '';
}
} else {
$respuesta = '';
}
echo $respuesta;
}
}
