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">«</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">»</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;
}
