导航API 后台管理

导航API 后台管理

环境要求

php5.6 phalcon3.3 redis mysql mongodb

REDIS的做缓存

$di->setShared('cache', function () {
    $frontCache = new Phalcon\Cache\Frontend\Data([
            "lifetime" => 172800,
        ]);
    $cache=new Phalcon\Cache\Backend\Redis(
        $frontCache,[
            "host"       => "localhost",
            "port"       => 6379,
            "persistent" => false,
            "index"      => 0,
        ]
    );
    return $cache;
});

数据库的跟踪

$di->set('profiler', function(){
    return
        new  \Phalcon\Db\Profiler();
}, true);

$di->setShared('db', function () use ($di){
    //新建一个事件管理器
    $eventsManager = new \Phalcon\Events\Manager();
    //从di中获取共享的profiler实例
    $profiler = $di->getProfiler();
    //监听所有的db事件
    $eventsManager->attach('db', function($event, $connection) use
    ($profiler) {
        //一条语句查询之前事件，profiler开始记录sql语句
        if ($event->getType() == 'beforeQuery') {
            $profiler->startProfile($connection->getSQLStatement());
        }
        //一条语句查询结束，结束本次记录，记录结果会保存在profiler对象中
        if ($event->getType() == 'afterQuery') {
            $profiler->stopProfile();
        }
    });

    $config = $this->getConfig();
    $class = 'Phalcon\Db\Adapter\Pdo\\' . $config->database->adapter;
    $params = [
        'host'     => $config->database->host,
        'username' => $config->database->username,
        'password' => $config->database->password,
        'dbname'   => $config->database->dbname,
        'charset'  => $config->database->charset
    ];

    if ($config->database->adapter == 'Postgresql') {
        unset($params['charset']);
    }
    $connection = new $class($params);
    $connection->setEventsManager($eventsManager);
    return $connection;
});

       date_default_timezone_set ("Asia/Chongqing");
       $date=$this->request->get('data');
       $y=date("Y");
       $m=date("m");
       $d=date("d");
       $datestring=$y."-".$m."-".$d;
       $date=$date!=""?$date:$datestring;

       $builder = new QueryBuilder();
       $builder -> from(['begin_workersign'=> '\Dldh\Models\WorkerSignBack']);
       $builder -> innerJoin('Dldh\Models\WorkerSignBack', 'begin_workersign.worker_id = end_workersign.worker_id','end_workersign');
       $builder -> innerJoin('Dldh\Models\Worker', 'worker.id = end_workersign.worker_id','worker');
       $builder -> where('begin_workersign.id<>end_workersign.id  and begin_workersign.type=1 and   end_workersign.type=0  and  begin_workersign.dateflag =end_workersign.dateflag and begin_workersign.dateflag=:dateflag: ',array('dateflag' =>$datestring));

       $builder -> columns([
                 'begin_workersign.worker_id',
                'begin_workersign.dateflag as begin_date',
                'end_workersign.dateflag as end_date',
                'worker.realname as realname',
                'end_workersign.type as end_type',
                'begin_workersign.type  as begin_type',
                'begin_workersign.creat_at  as begin_create',
                'end_workersign.creat_at as end_create'
             ]);

        $query = $builder->getQuery();
       $list = $query->execute();
       $this->view->setVars(array('list'=>$list,'date'=>$date));

use Phalcon\Mvc\Model\Query\Builder as QueryBuilder;
public function indexAction()
    {
   



        $builder = new QueryBuilder();
        //确定查询表
        $builder -> from(['poles'=>'\Dldh\Models\Pole']);
        //关联表
        $builder -> innerJoin('Dldh\Models\Worker', 'poles.worker_id = workers.id','workers');
        $builder -> innerJoin('Dldh\Models\Area', 'area.id = poles.area_id','area');
        // 需要查询的字段，这里两个表的字段都可以
       $builder -> columns([
            'poles.id',
            'poles.id',
            'area.area_name',
            'count(parts.id) as count',  //当数据很大时，统计数据时用
        ]);
        // where条件
        $builder -> where('parts.id = :id:',array('id' =>1));
 
       $builder -> andWhere('robots.name = :name:',array('name' => '你好'));


        //执行搜索
        if (isset($params['conditions'])) {
            foreach ($params['conditions'] as $field => $val) {
                if (!preg_match('/^\s*$/', $val)) {
                    //执行模糊搜索
                    $builder->andWhere("providers.$field like :$field:", array($field => '%' . trim($val) . '%'));
                }
            }
        }
        // 设置limit条件，order什么的都可以往后加$builder->order()
       $builder->limit(5,5);
         $builder->limit($rows, ($currentPage - 1) * $rows);    注意:这里的limit条件和原始sql语句中的limit语句刚好相反

        //获取查询对象
        $query = $builder->getQuery();
        //执行并返回结果
        $result = $query->execute();
        var_dump($result -> toArray());die;
        $this->view->setVar('list',$list);
}