<?php
// +----------------------------------------------------------------------
// | OneThink [ WE CAN DO IT JUST THINK IT ]
// +----------------------------------------------------------------------
// | Copyright (c) 2013 http://www.onethink.cn All rights reserved.
// +----------------------------------------------------------------------
// | Author: ewangtx <www@ewangtx.com>
// +----------------------------------------------------------------------
namespace Weixin\Controller;
use OSS\OssClient;
use OT\DataDictionary;
use Think;
/**
* 前台首页控制器
* 主要获取首页聚合数据
* $url= $_SERVER[HTTP_HOST]; //获取当前域名
*/
class SchoolController extends HomeController
{
/*初始化*/
public function _initialize(){
parent::_initialize();
// $this->checkLogin();
}
/*检查用户是否登录*/
protected function checkLogin() {
if(!is_login()){
$url = U('Index/notFound');
header("Location: {$url}");
exit;
}
}
//学校页
public function school()
{
$location = M("location");
$area = $location->where(array(array("type" => 'country')))->select();
$list = M("school")->LIMIT('5')->order("id asc")->select();
$this->assign('area', $area);
$this->assign('list', $list);
$this->meta_title = '学校列表';
$this->display();
}
public function videoUpload(){
//求出文件格式
exec('pwd',$b); // 查询当前位置
$dirname = $b['0']."/Uploads/Download/2016/"; //绝对路径
if(!file_exists($dirname)){
mkdir($dirname,0777,true);
}
move_uploaded_file($_FILES['file']['tmp_name'],$dirname.$_FILES['file']['name']);
$extension = pathinfo($_FILES['file']['name']);
$filename = time().rand(100,999).".".$extension['extension'];
// 加载阿里云
exec('pwd',$b); // 查询当前位置
require_once $b[0].'/ThinkPHP/Library/Think/aliyun/autoload.php';
$accessKeyId = "LTAIMU8fyORQ9qwd";
$accessKeySecret = "8gv5s5IUttHyyo3kma3uM0n7yw4yPr";
$endpoint = "oss-cn-beijing.aliyuncs.com";
$bucket= "ewangtx";
$object = $filename;
$file = $dirname.$_FILES['file']['name'];
try {
$ossClient = new OssClient($accessKeyId, $accessKeySecret, $endpoint);
$res = $ossClient->uploadFile($bucket, $object, $file);
if($res==null){
@unlink($dirname.$_FILES['file']['name']);
if($_POST['type']=='2'){
$data['did'] = $_POST['sid'];
$info = M("department")->where(array('id'=>$_POST['sid']))->find();
$data['sid'] = $info['sid'];
}else{
$data['sid'] = $_POST['sid'];
}
$data['uid'] = $_SESSION['ewtp_home']['user_auth']['uid'];
$data['review_type'] = '2';
$data['review_url'] = $object;
$data['time'] = floor($_FILES['file']['size']/1024/1024);
$data['review_time'] = time();
$result = M("comment")->add($data);
if($result){
$list['init'] = 1;
echo json_encode($list);die;
} else{
$list['init'] = 0;
echo json_encode($list);die;
}
};
} catch (OssException $e) {
// print $e->getMessage();
// return 0;
$list['init'] = 0;
echo json_encode($list);die;
}
}
/**
* @param $name // 在本服务器上的名称
* @param $aname // 在阿里云上的名称
* @throws \OSS\Core\OssException
*/
function upload($name,$aname){
}
//加载更多
public function More()
{
$where = array();
$num = 5;
$p = $_POST['now'];
if ($_POST['job'] == 'school') {
if ($_POST['cid']) {
$where['cid'] = $_POST['cid'];
}
if ($_POST['rid']) {
$where['rid'] = $_POST['rid'];
}
}
if ($_POST['job'] == 'department') {
}
$list = M($_POST['job'])->where($where)->order("id asc")->limit($p * $num, $num)->select();
if ($list) {
foreach ($list as $k => $v) {
$list[$k]['logo_url'] = get_cover($v['logo_url'], 'path');
$list[$k]['synopsis'] = msubstr($v['synopsis'], 0, 50);
}
}
if ($list) {
$json['init'] = 1;
$json['res'] = $list;
echo json_encode($json);
} else {
$json['init'] = 0;
$json['res'] = '';
echo json_encode($json);
}
}
//加载更多
public function commentMore()
{
$num = 5;
$p = $_POST['now'];
$sid = $_POST['sid'];
$start = $p * $num;
$list = M("comment")->query("SELECT a.*, b.nickname, b.sid AS bsid, b.did, b.head_url, c.department_name, d.school_name FROM ewshop_comment AS a,
ewshop_member AS b, ewshop_department AS c, ewshop_school AS d WHERE a.sid = '{$sid}' AND b.uid = a.uid and b.sid = d.id
and b.did = c.id order by a.id desc LIMIT {$start},{$num};");
$uid2 = $_SESSION['ewtp_home']['user_auth']['uid'];
foreach ($list as $k => $v) {
//该问题的提问者或回答者是否是当前登录用户
if($v['uid']==$uid2){
$list[$k]['isSelfA'] = 1;
}
//对于偷听该答案,
$list[$k]['isPay'] = M('Eavesdrop')->where(array ('aid' => $v['id'] , 'listen_type'=>'2','listenid' => $uid2))->find();
if ($v['id'] > 0) {
} else {
unset($list[$k]);
}
}
if ($list) {
$json['init'] = 1;
$json['res'] = $list;
echo json_encode($json);
} else {
$json['init'] = 0;
$json['res'] = '';
echo json_encode($json);
}
}
//学校详情页
public function schoolDetails()
{
if(IS_POST){
$num = 5;
$p = $_POST['now'];
$sid = $_POST['sid'];
$start = $p * $num;
$list = M("department")->where(array("sid" =>$sid))->limit($start,$num)->select();
foreach($list as $k=>$v){
if($list[$k]['info']){
$list[$k]['info'] = msubstr($list[$k]['info'],0,30);
}else{
$list[$k]['info'] = ' ';
}
}
if ($list) {
$json['init'] = 1;
$json['res'] = $list;
echo json_encode($json); die;
} else {
$json['init'] = 0;
$json['res'] = '';
echo json_encode($json); die;
}
}
$data = M("school")->where(array("id" => $_GET['sid']))->find();
$list = M("department")->where(array("sid" => $_GET['sid']))->limit('5')->select();
$this->assign('data', $data);
$this->assign('list', $list);
$this->meta_title = "学校详情";
$this->display();
}
//学校详情-点评页
public function schoolComment()
{
//支付处理
// $paymentInfo = R('Wxpay/getPayment',array(1,4));//获取预支付信息
// $jsApiParameters = $paymentInfo['jsApiParameters'];
// $out_trade_no = $paymentInfo['out_trade_no'];
//