wxapp2/Home/Controller/PublicController.class.php

<?php

namespace Home\Controller;

use Think\Controller;

include '../Common/function.php';

class PublicController extends Controller
{

    public function index()
    {
        $this->display();
    }

    public function comway()
    {
        $Data = I('cate_text');
        $this->assign('ResData', $Data);
        $this->display('Public/success');
    }

    public function Mainfback()
    {
        $Data = I('');
        if (IS_POST) {
            $Data['datetime'] = date('Y-m-d H:i:s');
            $Res = M('wx_suggest')->add($Data);
            if ($Res) {
                $Text = '非常感谢您对我们的关注和支持，我们将认真对待您提出的宝贵建议，如我们公司采纳了您的建议，将会给予您快递一份小礼品';
                $this->redirect('Public/comway', array('cate_text' => $Text));
            }
        } else {
            $this->assign('openid', $_SESSION['useropenid']);
            $this->assign('action', '/home/Public/Mainfback');

        }

        $this->display('Public/mainfback');
    }

    public function Profback()
    {
        $Data = I('');
        if (IS_POST) {
            $Data['datetime'] = date('Y-m-d H:i:s');
            $Res = M('wx_complaint')->add($Data);
            if ($Res) {
                $Text = '感谢您的投诉，我们将尽快给予您的答复';
                $this->redirect('Public/comway', array('cate_text' => $Text));
                //$this->display('Public/success');
            }
        } else {
            $this->assign('openid', $_SESSION['useropenid']);
            $this->assign('action', '/home/Public/Profback');

        }
        $this->display('Public/Profback');
    }

    public function change()
    {
//         $Data    = I('');
//         $company = $Data['companyid'];
//         $type    = $Data['type'];
//         $ResData = indexTwo($company,$type);
//         $this->assign('ResData',$ResData);
//         $this->display('Index/water-list');
        $Data = I('');
        $Map['company'] = $Data['companyid'];
        $page = $Data['page'];
        $size = 20;
        $startpage = ($page - 1) * 20;
        $limit = $startpage . ',' . $size;
//        $Map['dwtype']='2';
        switch ($Data['type']) {
            case 'untreated':
                $Map['clzt'] = 0;
                break;
            case 'treated':
                $Map['clzt'] = 1;
                break;
            default:
                break;
        }
        $ResData = M('v_sj2017_2')->where($Map)->order("time desc")->limit($limit)->select();
        //print_r($ResData);exit();
//        $this->assign('ResData', $ResData);
//        $this->display('Index/water-list');
        echo json_encode($ResData);
    }

    public function change1()
    {
//         $Data    = I('');
//         $company = $Data['companyid'];
//         $type    = $Data['type'];
//         $ResData = indexTwo($company,$type);
//         $this->assign('ResData',$ResData);
//         $this->display('Index/water-list');
        $Data = I('');
        $page = $Data['page'];
        $size = 20;
        $startpage = ($page - 1) * 20;
        $Map['company'] = $Data['companyid'];
        switch ($Data['type']) {
            case 'untreated':
                $Map['clzt'] = 0;
                $ResData = M()->query("select a.id,a.time,a.data4,b.owner_name,a.clzt from sp_lifter2017 as a  join sp_owner as b on a.device_code=b.owner_code where b.company=" . $Data['companyid'] . " and a.clzt=0 order by a.time desc limit " . $startpage . "," . $size);
                break;
            case 'treated':
                $Map['clzt'] = 1;
                $ResData = M()->query("select a.id,a.time,a.data4,b.owner_name,a.clzt from sp_lifter2017 as a  join sp_owner as b on a.device_code=b.owner_code where b.company=" . $Data['companyid'] . " and a.clzt=1 order by a.time desc limit " . $startpage . "," . $size);
                break;
            default:
                $ResData = M()->query("select a.id,a.time,a.data4,b.owner_name,a.clzt from sp_lifter2017 as a  join sp_owner as b on a.device_code=b.owner_code where b.company=" . $Data['companyid'] . " order by a.time desc limit " . $startpage . "," . $size);
//                print_r("select * from sp_lifter2017 as a  join sp_owner as b on a.device_code=b.owner_code where b.company=".$Data['companyid']." order by a.time desc limit 1000");
                break;
        }
//        $ResData=M('lifter2017')->where($Map)->order("time desc")->limit(1000)->select();

//        print_r($ResData);
//        $this->assign('ResData',$ResData);
//        $this->display('Index/lifter-list');
        echo json_encode($ResData);
    }

}