PHP Loader::model方法代码示例

 public function index(HttpRequest $request)
 {
     print_r($request->getParameter());
     ////----DB 操作
     //DB:  原生query操作
     $model = Loader::model('user');
     $result = $model->query("select * from user");
     $rowArr = $result->fetchAll();
     print_r($rowArr);
     //DB: 查询
     //DB: 插入
     /*
             $data = array(
                 "id" => "",
                 "name" => "xm"
             );
             $model->insert($data);
     */
     //DB: 更新
     $data = array("id" => "12", "name" => "yy");
     $id = 2;
     $model->update($data, $id);
     //DB: 删除
     $id = 1;
     $model->delete($id);
     //DB: 事物
     $items = array("id" => 1, "title" => "hello title2");
     $this->assign('items', $items);
     $this->assign('var1', "yu");
     //$this->display('index_test2');//这里不要用display这个方法，流程不对，用view
     $this->setView('index_test');
     //die();
 }

 public function run()
 {
     tprintOk("Hello, world!");
     $model = Loader::model('article');
     $conditions = array("id" => ">300");
     $items = $model->getItems($conditions, "id, url, title", null, 1, 20);
     tprintOk($items[0]['title']);
 }

 /**
  * @param HttpRequest $request
  */
 public function delete(HttpRequest $request)
 {
     $id = $request->getParameter('id', 'intval');
     $model = Loader::model('article');
     if ($id > 0) {
         var_dump($model->delete($id));
     }
     die;
 }

 public function run()
 {
     //            $lock = SynLockFactory::getFileSynLock(0x1234);
     //            tprintError("try to get the lock....");
     //            $lock->tryLock();
     //            tprintOk("get the lock.");
     //            sleep(10);
     //            tprintWarning("release the lock.");
     //            $lock->unlock();
     $model = Loader::model("news");
     $timer = timer();
     for ($i = 0; $i < 1000000; $i++) {
         $data = array('name' => 'xiaoming', 'pass' => 'xiaoming_pass', 'address' => 'china ShenZhen');
         $model->insert($data);
     }
     tprintOk("插入完成，耗时：" . (timer() - $timer) . " 秒");
 }

 public function html(HttpRequest $request)
 {
     $CACHER = CacheFactory::create('html');
     $CACHER->baseKey('article')->ftype('detail')->factor('299');
     $item = $CACHER->get(null);
     if (!$item) {
         $model = Loader::model('article');
         $item = $model->getItem(299);
         $this->assign('item', $item);
         $html = $this->getExecutedHtml();
         if ($CACHER->set(null, $html)) {
             __print("生成静态缓存成功！");
         }
     } else {
         echo $item;
     }
     die;
 }

 /**
  * 首页方法
  * @param HttpRequest $request
  */
 public function index(HttpRequest $request)
 {
     $page = $request->getParameter('page', 'intval');
     $pagesize = 10;
     if ($page <= 0) {
         $page = 1;
     }
     $model = Loader::model('article');
     $conditions = array("id" => ">300");
     $total = $model->count($conditions);
     $items = $model->getItems($conditions, "id, url, title", null, $page, $pagesize);
     //初始化分页类
     $pageHandler = new Page($total, $pagesize, $page);
     //获取分页数据
     $pageData = $pageHandler->getPageData(DEFAULT_PAGE_STYLE);
     //组合分页HTML代码
     if ($pageData) {
         $pagemenu = '<ul class="pagination">';
         $pagemenu .= '<li><a href="' . $pageData['prev'] . '" aria-label="Previous"><span aria-hidden="true">&laquo;</span></a></li>';
         foreach ($pageData['list'] as $key => $value) {
             if ($key == $page) {
                 $pagemenu .= '<li class="active"><a href="#fakelink">' . $key . '</a></li> ';
             } else {
                 $pagemenu .= '<li><a href="' . $value . '">' . $key . '</a></li> ';
             }
         }
         $pagemenu .= '<li><a href="' . $pageData['next'] . '" aria-label="Next"><span aria-hidden="true">&raquo;</span></a></li>';
         $pagemenu .= '</ul>';
         $pagemenu .= '<div class="page-input"><input type="text" class="form-control input-sm" value="' . $this->page . '"> ';
         $pagemenu .= '<a href="javascript:void(0);" class="btn btn-primary btn-sm" url="' . $pageData['url'] . '" id="page-goto">确定</a></div> ';
     }
     $this->assign('pagemenu', $pagemenu);
     $this->assign('items', $items);
     //设置视图
     $this->setView('article_page');
 }

 public function __construct($articleModel, $dataModel)
 {
     $this->setModelDao(Loader::model($articleModel));
     $this->dataDao = Loader::model($dataModel);
 }

 /**
  * 构造函数，初始化modelDao
  * @param $model
  */
 public function __construct($model)
 {
     $this->setModelDao(Loader::model($model));
 }

 public function mongo()
 {
     $model = Loader::model("news");
     //添加数据 C_Model::insert();
     //        $address = array('东莞','深圳','广州','北京','上海','杭州');
     //        for ( $i = 0; $i < 100; $i++ ) {
     //            $data = array(
     //                "id" => StringUtils::genGlobalUid(true),
     //                "name" => "user_{$i}",
     //                "age" => $i,
     //                "address" => $address[mt_rand(0,5)]);
     //
     //            __print($model->insert($data));
     //        }
     //C_Model::query();
     //        $list = $model->query("select * from fiidee_user order by id desc limit 20");
     //        __print($list);
     $id = 'B21A-57B319E4-0269D8C0-D5CB-8295ECE2';
     //C_Model::getItem()
     //        $one = $model->getItem($id);
     //        __print($one);
     //C_Model::delete()
     //        $model->delete($id);
     //        __print($model->getItem($id));
     //C_Model::deletes()
     //        $conditions = array(
     //            'name' => 'user_1',
     //            '$or' => array('id' => array('$in' => array('B21A-57B319E4-026B4D68-F5E5-9DF9281A', 'B21A-57B319E4-026C46A0-248C-1907B7D3')))
     //        );
     //        var_dump($model->deletes($conditions));
     //C_Model::find
     //        $gets = array('id', 'name', 'address');
     //        $sort = array('name' => 1);
     //        $list = $model->where()
     //            ->field($gets)
     //            ->sort($sort)
     //            ->limit(0, 20)
     //            ->find();
     //        __print($list);
     //C_Model::update
     //        $data = array(
     //            'name' => 'xiaoming',
     //            'age' => 30,
     //            'address' => '我爱北京天安门'
     //        );
     //        $conditions = array('id' => 'B21A-57B319E4-026D4230-E18D-817D454C');
     //        $model->updates($data, $conditions);
     //        __print($model->where($conditions)->findOne());
     //C_Model::count
     //        $conditions = array('id' => '>B21A-57B30872-01655B98-538F-FBED5277');
     //        var_dump($model->count($conditions));
     //C_Model::increase
     //        $condition = array('id' => array('$in' => array('B21A-57B319E4-026DA5CC-79FC-091DB526', 'B21A-57B319E4-026BC748-7837-42B51E30')));
     //        $model->batchIncrease('age', 10, $condition);
     //        //$model->batchReduce('age', 10, $condition);
     //        __print($model->getItems($condition));
     //C_Model::set
     //        $condition = array('id' => array('$in' => array('B21A-57B319E4-026DA5CC-79FC-091DB526', 'B21A-57B319E4-026BC748-7837-42B51E30')));
     //        $model->sets('age', 200, $condition);
     //        $model->sets('name', "超级无敌美少女", $condition);
     //        __print($model->getItems($condition));
     //        $conditions = array('name' => array('$like' => 'user_1'));
     //        __print($model->getItems($conditions));
     //分组查询
     $keys = array("address" => 1);
     $initial = array("items" => array());
     $reduce = "function (obj, prev) { prev.items.push({id:obj.id, name:obj.name, age:obj.age}); }";
     $conditions = array('age' => '>30');
     $items = $model->findByGroup($keys, $initial, $reduce, $conditions);
     __print($items);
     AjaxResult::ajaxSuccessResult();
 }

 /**
  * @param $tagModel
  * @param $tagAssoc
  */
 public function __construct($tagModel, $tagAssoc)
 {
     $this->setModelDao(Loader::model($tagModel));
     $this->tagAssocDao = Loader::model($tagAssoc);
 }

 public function __construct($financeModel, $commentAssoc = null)
 {
     $this->setModelDao(Loader::model($financeModel));
 }

 public function __construct($mediaModel, $mediaDataModel)
 {
     $this->mediaDataDao = Loader::model($mediaDataModel);
     $this->setModelDao(Loader::model($mediaModel));
 }

 public function __construct($userModel, $userDataModel)
 {
     $this->userDataDao = Loader::model($userDataModel);
     $this->setModelDao(Loader::model($userModel));
 }

 /**
  * 获取文章内容表的dao实例
  * @param int $aid 文章ID
  * @return \herosphp\model\C_Model
  */
 public function getDataDao($aid)
 {
     //获取文章数据表的节点
     $node = $aid % self::DATA_TABLE_NODES;
     $this->dataDao = Loader::model('ArticleData');
     $tableMapping = $this->dataDao->getTableMapping();
     //加载数据表配置
     $dbConfigPath = 'db';
     if (DB_CFG_PATH != false) {
         $dbConfigPath = DB_CFG_PATH;
     }
     $tableConfig = Loader::config('table', $dbConfigPath);
     $this->dataDao->setTable($tableConfig[$tableMapping[$node]]);
     return $this->dataDao;
 }