/** * 录入 * */ 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; } }