public function getFriend($userid)
{
$sql = "select u.name,u.id from __USERS__ as u,(select user2 from __FRIEND__ where user1 = {$userid} \r\n UNION select user1 from __FRIEND__ where user2 = {$userid}) as f where u.id = f.user2";
$model = new Model();
$data = $model->query($sql);
return $data;
}
public function header_city()
{
$city1 = new \Think\Model();
$sql = "select r.* from __PREFIX__store_shipping_region as ssr left join __PREFIX__region as r on ssr.city=r.region_id where ssr.city>0 group by ssr.city";
$rs = $city1->query($sql);
var_dump($rs);
}
public function listView($cate)
{
$cate_atc = M('cate_atc');
$count = $cate_atc->where(['status' => 1, 'cate' => $cate])->count();
$Page = new \Think\Page($count, 16);
// 实例化分页类 传入总记录数和每页显示的记录数
$show = $Page->show();
// 分页显示输出
$list = $cate_atc->where(['cate' => $cate])->order('createtime')->limit($Page->firstRow . ',' . $Page->listRows)->select();
$model = new Model();
foreach ($list as $k => $v) {
$modelInfo = get_model_info($v['model_id']);
//获每条数据的模型信息
//echo $modelInfo['identity'];
$raw = $model->query("select author from {$modelInfo['identity']} where id = {$v['atc_id']}");
$list[$k]['author'] = $raw[0]['author'];
$d = strtotime($v['createtime']);
$list[$k]['createtime'] = '<div>' . date("Y/m/d", $d) . '</div>' . '<div>' . date("H:i:s", $d) . '</div>';
//编辑时间格式
}
//var_dump($show);
/* $Page->setConfig('f_decorate','<li>');
$Page->setConfig('b_decorate','</li>');*/
$this->assign('page', $show);
$this->assign('list', $list);
$this->assign('model_list', get_cate_Model($cate));
//$this->assign("cate_id",1);
$this->assign("cate", $cate);
$this->display();
}
/**
* 登录验证
* @param $loginArr
* @return $arr
*/
public function loginCheck($loginArr)
{
$User = new Model('user');
$array['US_name'] = $loginArr['US_name'];
//设置用户等级为管理员
$array['Us_level'] = 2;
$result = $User->where($array)->select();
$arr = array();
$arr['status'] = 0;
if ($result != null && count($result) == 1) {
if (strcmp(md5($loginArr['password']), $result[0]['password']) == 0) {
//登陆成功
$arr['status'] = 1;
$arr['content'] = '验证成功！';
return $arr;
} else {
//登陆失败（密码错误）
$arr['content'] = '密码错误！';
return $arr;
}
} else {
$arr['content'] = '用户名不存在！';
return $arr;
}
}
public function getCitiesByProvince($province)
{
$sql = "select a.city as city from t_cities a, t_provinces b\r\n where b.province like '" . $province . "%' and b.provinceid = a.provinceid";
$m = new \Think\Model();
$result = $m->query($sql);
return $result;
}
public function detail()
{
$Form = new Model();
$result = $Form->query('select admin_articles.*, admin_nickname from admin_articles
inner join admin_personal on admin_articles.admin_id = admin_personal.admin_id
where article_id="%s"', $_GET['p']);
if ($result) {
$result[0]['article_type'] = C('MODULE_CODE')[$result[0]['article_type']];
//dump($result[0]);
if ($result[0]['article_about'] == C(PROJECT_CODE)) {
$object = $Form->query('select project_name as name, project_logo as portrait from project_info
where project_id = "%s"', $result[0]['article_object']);
//dump($object);
$this->obj = $object[0];
} else {
if ($result[0]['article_about'] == C(INVESTOR_CODE)) {
$object = $Form->query('select name, portrait from investor_personal
where user_id = "%s"', $result[0]['article_object']);
//dump($object);
$this->obj = $object[0];
} else {
if ($result[0]['article_about'] == C(INNOVATOR_CODE)) {
$object = $Form->query('select name, portrait from entrepreneur_personal
where user_id = "%s"', $result[0]['article_object']);
//dump($object);
$this->obj = $object[0];
}
}
}
$this->p = $result[0];
}
$update = $Form->execute('update admin_articles set article_visits=%d where article_id="%s"', $result[0]['article_visits'] + 1, $_GET['p']);
$this->display();
}
public function doLogin()
{
// 参数非法，则重新登录
if (empty($_POST["name"]) || empty($_POST["password"]) || empty($_POST["code"])) {
$this->ajaxReturn(array("content" => null, "info" => "输入不能为空", "status" => false));
exit(1);
}
//验证码生成
$code = $_POST['code'];
$Ver = new CodeController();
if (!$Ver->check_verify($code)) {
// 验证码错误
$this->ajaxReturn(array("content" => null, "info" => "验证码错误", "status" => false));
$this->error("验证码错误", "index");
exit(1);
}
//获取用户名
$username = $_POST['name'];
//获取密码
$password = $_POST["password"];
//创建systemmanager 的Model
$m = new Model("systemmanager");
//$res = $m->field ( "sys_password,sys_id" )->where ( "sys_username='******'" )->select ();
$res = $m->field("sys_password,sys_id")->where("sys_username='******'", $username)->select();
// 防注入 查找
if ($res[0]['sys_password'] == md5($password)) {
//若账号和密码都正确则登录成功，并存入相关session
$_SESSION['systemmanager'] = $username;
$_SESSION['sys_id'] = $res[0]['sys_id'];
$this->ajaxReturn(array("content" => null, "info" => "登录成功！", "status" => true));
}
//用户名或者密码错误，则登录失败
$this->ajaxReturn(array("content" => null, "info" => "用户名或者密码错误！", "status" => false));
}
function getCategory()
{
/* $data['slug'] <> 'uncategorized';
return $this->where($data)->select();*/
$Model = new Model();
return $Model->query("select * from wp_terms where wp_terms.slug <> 'uncategorized'");
}
function checkVerfiyCode()
{
$param = json_decode(file_get_contents('php://input'), true);
$phone = $param['phone'];
$verfiycode = $param['verfiycode'];
if (empty($phone)) {
err_ret(-205, 'lack of param', '缺少参数');
}
if (empty($verfiycode)) {
err_ret(-205, 'lack of param', '缺少参数');
}
//万能验证码
if ($verfiycode == '0228') {
http_ret(0, 'verify code is correct', '验证码正确');
}
$model = new Model('verify_tmp');
$condition['phone'] = $phone;
$condition['verifycode'] = $verfiycode;
$result = $model->where($condition)->select();
if (count($result) <= 0) {
err_ret(-307, 'verfiy code is incorrect', '验证码不正确');
}
$time = time() - $result[0]['gen_time'];
if ($time > 5 * 60) {
err_ret(-308, 'verify code is invalid', '验证码已过期');
}
if ($verfiycode == $result[0]['verifycode']) {
http_ret(0, 'verify code is correct', '验证码正确');
} else {
err_ret(-307, 'verfiy code is incorrect', '验证码不正确');
}
}
public function login()
{
$Form = new Model();
$user = $Form->query("select * from admin_personal where admin_id = '%s'", $_POST['loginuser']);
//echo json_encode($user[0]);
if ($user[0]['admin_pwd'] === $_POST['loginpwd']) {
$_SESSION['userid'] = $user[0]['admin_id'];
//session(array('name'=>'userid','expire'=>2),$user[0]['admin_id']);
$_SESSION['usertype'] = $user[0]['admin_type'];
if ($_SESSION['usertype'] == 1) {
echo 201;
} else {
if ($_SESSION['usertype'] == 2) {
echo 202;
} else {
if ($_SESSION['usertype'] == 3) {
echo 203;
} else {
echo 404;
}
}
}
} else {
echo 409;
}
}
public function check($para)
{
$user = $para['user'];
$type = $para['type'];
$pwd = md5($para['pwd']);
$vcode = $para['verifycode'];
//首先验证验证码
if ($this->check_verify($vcode)) {
//验证账号密码
switch ($type) {
case '3':
$tb = 'user_admin';
$tb2 = 'user_admin';
break;
case '2':
$tb = 'user_teacher_pwd';
$tb2 = 'user_teacher';
break;
case '1':
$tb = 'user_student_pwd';
$tb2 = 'user_student';
}
$Model = new \Think\Model();
$sql = "select * from {$tb2} B left join {$tb} A on A.user=B.user where A.user='******' and A.pwd='{$pwd}' and B.status=1";
//var_dump($sql);
if (count($Model->query($sql))) {
return 1;
} else {
return 0;
}
} else {
return -1;
}
}
public function db()
{
$m = new Model('Post');
$list = $m->select();
dump($list);
echo $m->getLastSql();
}
public function myUpdate($data)
{
$id = (int) $data['id'];
if ($id <= 0) {
$this->error = '请先选择要更新的分类';
return false;
}
unset($data['id']);
if ($id == $data['parent_id']) {
$data['parent_id'] = 0;
}
//所属分类等于自己时, 更正为顶级分类
//验证数据
if (false === $this->create($data, self::MODEL_UPDATE)) {
return false;
}
//验证 parent_id合法性
if ($this->parent_id > 0) {
$model = new Model('Category');
//避免 model 混淆
$parent = $model->find($this->parent_id);
if (false === $parent || empty($parent)) {
$this->error = '父级分类不存在';
return false;
}
$orginfo = $model->find($id);
if ($orginfo['store_id'] != $parent['store_id']) {
$this->error = '父级分类不存在当前店铺';
return false;
}
}
return $this->where('`id`=' . $id)->save();
}
/**
* 列表显示
*/
public function index()
{
if (!IS_AJAX) {
$this->error(L('_ERROR_ACTION_'));
}
$Model = new Model();
$islang = $Model->query('Describe __' . strtoupper(CONTROLLER_NAME) . '__ lang');
if ($islang[0]['field'] == 'lang') {
if (I('get.lang')) {
$wl = 'lang=\'' . I('get.lang') . '\'';
} elseif ($this->clang) {
$wl = 'lang=\'' . $this->clang . '\'';
} else {
$wl = 'lang=\'' . LANG_SET . '\'';
}
} else {
$wl = '1';
}
$isorder = $Model->query('Describe __' . strtoupper(CONTROLLER_NAME) . '__ listorder');
$ol = $isorder == 'listorder' ? 'listorder,' : '';
$name = M(CONTROLLER_NAME);
$list = $name->where($wl)->order($ol, 'id')->select();
$this->assign('list', $list);
$this->display();
}
public function comment($id)
{
$model = new Model('Article');
$article = $model->find(array('articleId' => $id));
if (empty($article)) {
$this->error('文章不存在');
}
$key = get_client_ip() . '-view-article-' . $id;
$cache = S($key);
if (!empty($cache)) {
$this->error('评论间隔必须大于1分钟');
}
$nickname = I('nickname');
$content = I('content');
if (empty($nickname)) {
$this->error('昵称不能为空');
}
if (empty($content)) {
$this->error('评论内容不能为空');
}
$data = array('nickname' => $nickname, 'content' => $content, 'createdAt' => time(), 'createdIp' => get_client_ip(), 'articleId' => $id);
$commentModel = new Model('Comment');
if (!$commentModel->data($data)->add()) {
$this->error('评论失败');
}
S($key, 1, 60);
$data['createdAt'] = date('m-d H:i', $data['createdAt']);
$this->ajaxReturn($data);
}
public function index($cate)
{
$cate_atc = M('cate_atc');
$count = $cate_atc->where(['status' => 1, 'cate' => $cate])->count();
$Page = new \Think\Page($count, 16);
// 实例化分页类 传入总记录数和每页显示的记录数
$show = $Page->show();
// 分页显示输出
$list = $cate_atc->where(['cate' => $cate])->order('createtime')->limit($Page->firstRow . ',' . $Page->listRows)->select();
$model = new Model();
foreach ($list as $k => $v) {
$modelInfo = get_model_info($v['model_id']);
//获每条数据的模型信息
$raw = $model->query("select author from {$modelInfo['identity']} where id = {$v['atc_id']}");
$list[$k]['author'] = $raw[0]['author'];
$d = strtotime($v['createtime']);
$list[$k]['createtime'] = '<h6>' . date("m/d", $d) . '</h6>';
//编辑时间格式
}
$this->assign('page', $show);
$this->assign('list', $list);
$this->assign('model_list', get_cate_Model($cate));
$this->assign("cate", $cate);
$this->display('News/index');
}
function checkCoachMaxUsers()
{
$param = json_decode(file_get_contents('php://input'), true);
$token = $param['xtoken'];
// init_verify_token($token);
$coachid = $param['coachid'];
// $coachid = 53;
if (empty($coachid)) {
err_ret(-205, 'lack of param', '缺少参数');
}
//判断教练的客户是否超过10个
$model = new Model();
$sql_user = '******' . $coachid;
$result_user = $model->query($sql_user);
$studentNums = M("user_info")->where("type=1 and id={$coachid}")->getField("studentnums");
if (count($result_user) >= $studentNums) {
$model_user = new Model('user_info');
$save_data['status'] = 1;
$where_data['id'] = $coachid;
$where_data['type'] = 1;
$model_user->where($where_data)->save($save_data);
$data['errno'] = 0;
$data['is_max'] = 1;
$data['coachid'] = $coachid;
echo json_encode($data);
} else {
$data['errno'] = 0;
$data['is_max'] = 0;
$data['coachid'] = $coachid;
echo json_encode($data);
}
}
public function edit($id)
{
$model = new Model('Link');
$data = $model->find($id);
if (empty($data)) {
$this->error('链接不存在');
}
if (IS_POST) {
$name = I('name');
$link = I('link');
$status = I('status', 1);
$sort = I('sort', 0);
if (empty($name)) {
$this->error('网站名称不能为空');
}
if (empty($link)) {
$this->error('网站链接不能为空');
}
$data = array('name' => $name, 'link' => $link, 'status' => $status, 'sort' => $sort);
if (false === $model->where(array('linkId' => $id))->save($data)) {
$this->error('编辑失败');
} else {
$this->success('编辑成功', U('admin/link/index'));
}
} else {
$this->assign('data', $data);
$this->display('post');
}
}
public function search($para)
{
$k = "bs_kt.name like '%" . $para['k'] . "%'";
//根据实验室分类
if ($para['d'] == '0') {
$d = '1=1';
} else {
$dep = $para['d'];
$d = "user_teacher.dep='{$dep}'";
}
/**查询sql语句
select bs_kt.id,bs_kt.name as bname,bs_kt.snum,user_teacher.name as tname,user_teacher.dep,count(bs_xt.bid) from bs_kt left join user_teacher on user_teacher.user=bs_kt.teacher left join bs_xt on bs_xt.bid=bs_kt.id group by bs_kt.id
select bs_kt.id,bs_kt.name as bname,bs_kt.snum,user_teacher.name as tname,user_teacher.dep,count(bs_xt.bid) from bs_kt left join user_teacher on user_teacher.user=bs_kt.teacher left join bs_xt on bs_xt.bid=bs_kt.id where bs_kt.status=1 and bs_kt.name like '%安%' group by bs_kt.id
*/
$np = 10;
//每页数
$cp = (int) $para['p'];
//当前页
$sql1 = "select count(*) from bs_kt inner join user_teacher on bs_kt.teacher=user_teacher.user where " . $d . " and " . $k . " and bs_kt.status=3";
$sql2 = "select bs_kt.id,bs_kt.name as bname,bs_kt.teacher as tuser,user_teacher.name as tname,user_teacher.dep,user_student.user as suser,user_student.name as sname from bs_kt" . " left join user_teacher on bs_kt.teacher=user_teacher.user" . " left join user_student on user_student.user in (select sid from bs_xt where bs_xt.bid = bs_kt.id)" . " where " . $d . " and " . $k . " and bs_kt.status=3 group by bs_kt.id limit " . $np * ($cp - 1) . ',' . $np . '';
//自定义执行sql语句
$Model = new \Think\Model();
$tp = $Model->query($sql1)[0]['count(*)'];
$rs_kt = $Model->query($sql2);
$rs = array('page' => array('sql' => $sql2, 'tp' => $tp, 'c_p' => $cp, 't_p' => ceil(1.0 * $tp / $np)), 'r' => $rs_kt ? $rs_kt : array());
return $rs;
}
/**
* 店主信息
*/
public function onwerInfo()
{
$model = new Model('Store');
$info = $model->find(STID);
$this->assign('info', $info);
cookie(C('CURRENT_URL_NAME'), $_SERVER['REQUEST_URI']);
$this->display();
}
public function searching()
{
$model = new Model();
$sql = "use " . $_SESSION['dbName'];
$model->query($sql);
$shop_id = trim($_GET['shopid']);
if ($shop_id == "") {
$shop_id = $_SESSION["shop_id"];
}
if ($shop_id == "") {
$this->error("请先点击具体的店铺，再回来点此");
}
$this->assign("shopid", $shop_id);
$shopName = $_SESSION["shop_name"];
$this->assign("shopName", $shopName);
$this->assign("shop", U('Retailer/index', array('shopid' => $shop_id)));
if (!IS_GET) {
$this->display();
} else {
$man = trim($_GET['man']);
$date = trim($_GET['date']);
if ($man != "") {
$where['realName'] = array('like', "%{$man}%");
$this->assign("man", $man);
}
$start = trim($_GET['start']);
$end = trim($_GET['end']);
if ($end != "") {
$where['saledate'] = array('between', array($start . " 00:00:00", $end . " 59:59:59"));
$this->assign("date", $people);
}
$where['belong'] = $_SESSION['auth'];
$everypage = "10";
//$res = $out->field("id,outtime,outprice,outamount")->relation(true)->order("outtime desc")->select();
// $tbName = D("RetailerView"); // 实例化Data数据对象
$tbName = new RetailerViewModel("RetailerViewModel", $tablePrefix = $shop_id);
/*
* 使用视图子查询
*/
$subQuery = $tbName->group('name')->where($where)->order('sum(amount) desc')->select(false);
$count = $tbName->table($subQuery . 'xc')->count('name');
//$count = $tbName->count('barcode'); // 查询满足要求的总记录数
$Page = new Page($count, $everypage);
// 实例化分页类 传入总记录数和每页显示的记录数(25)
$show = $Page->show();
// 分页显示输出// 进行分页数据查询 注意limit方法的参数要使用Page类的属性
$list = $tbName->field("sum(amount) as total,name,realName")->where($where)->order("sum(amount) desc")->limit($Page->firstRow . ',' . $Page->listRows)->group("name")->select();
$this->assign('list', $list);
// 赋值数据集
$this->assign('page', $show);
// 赋值分页输出
// $tbName = D('RetailerView');
$sumSQL = $tbName->field('sum(amount) as total')->where($where)->order("sum(amount) desc")->group("name")->select(FALSE);
$outsum = $tbName->table($sumSQL . 'cc')->sum('total');
$this->assign("outsum", $outsum);
$this->display();
}
}
public function editPresident()
{
$president = M('president')->join('join school on president.school_id = school.id')->field('president, president.id, school_name')->select();
$model = new Model();
$presidentData = $model->query('SELECT president, praise, count(*) as comment from president join user_president on president.id = user_president.president_id GROUP BY president_id');
$this->assign('president', $president);
$this->assign('presidentdata', $presidentData);
$this->display();
}
public function getNews()
{
//$model_news = M('home_news');
//$rs_news = $model_news->limit(0,5)->select();
$model_news = new \Think\Model();
$sql = "select * from home_news order by publishtime desc limit 0,5";
$rs_news = $model_news->query($sql);
return $rs_news;
}
function get_num_odr($oid)
{
$model = new Model('OrderGoods');
$list = $model->where('order_id=' . $oid)->select();
$num = 0;
foreach ($list as $row) {
$num += $row['quantity'];
}
return $num;
}
public function checkAccount($account)
{
$model = new Model('Admin');
$status = $model->where('account="' . trim($account) . '"')->getField('id');
if (intval($status) > 0) {
return false;
} else {
return true;
}
}
/**
* 检查该QQ是否已被注册
* @param string qq 用户提交的qq字段
* @access protected
* */
protected function checkQq($qq)
{
$mo = new Model();
$mo->table('__USERS__');
if (empty($mo->where(array('qq' => $qq))->find())) {
return true;
} else {
return false;
}
}
public function checkST($sid, $tid)
{
$model = new \Think\Model();
$sql = "select * from bs_xt where sid='{$sid}' and bid in(select id from bs_kt where teacher='{$tid}')";
$rs = $model->query($sql);
if (!count($rs)) {
return 0;
} else {
return 1;
}
}
public function cancel($user, $list)
{
$model = new \Think\Model();
$list_s = join(',', $list);
$sql = "update bs_kt set status=0 where status=1 and teacher='{$user}' and id in (" . $list_s . ")";
if ($model->query($sql)) {
return 1;
} else {
return 0;
}
}
public function queryKtNum($t)
{
if ($t == 1) {
$sql = "select count(*) from bs_kt where status=2";
} else {
$sql = "select count(*) from bs_kt where status=1";
}
$model = new \Think\Model();
$rs = $model->query($sql);
return $rs[0]['count(*)'];
}
function init_verify_token($token)
{
if ($token == '') {
err_ret(-205, 'lack of param xtoken', '缺少xtoken参数');
}
$model = new Model('user_info');
$condition['xtoken'] = $token;
$result = $model->where($condition)->select();
if (count($result) <= 0) {
err_ret(-505, 'tokan is invalid', 'token 失效');
}
}
