public function article()
{
App::import('vendor', array('model/board', 'model/article', 'inc/pagination'));
$day = 7;
$title1 = $title2 = $title3 = $author = $o = '';
if (isset($this->params['url']['title1'])) {
$title1 = trim($this->params['url']['title1']);
}
if (isset($this->params['url']['title2'])) {
$title2 = trim($this->params['url']['title2']);
}
if (isset($this->params['url']['titlen'])) {
$title3 = trim($this->params['url']['titlen']);
}
if (isset($this->params['url']['author'])) {
$author = trim($this->params['url']['author']);
}
if (isset($this->params['url']['day'])) {
$day = intval($this->params['url']['day']);
}
$m = isset($this->params['url']['m']) && $this->params['url']['m'] == '1';
$a = isset($this->params['url']['a']) && $this->params['url']['a'] == '1';
$o = isset($this->params['url']['o']) && $this->params['url']['o'] == '1';
$res = array();
if (!isset($this->params['url']['boards'])) {
$this->error(ECode::$BOARD_UNKNOW);
}
$boards = $this->params['url']['boards'];
foreach (explode('|', $boards) as $b) {
try {
$brd = Board::getInstance($b);
$res = array_merge($res, Article::search($brd, $title1, $title2, $title3, $author, $day, $m, $a, $o));
} catch (BoardNullException $e) {
}
}
$count = isset($this->params['url']['count']) ? $this->params['url']['count'] : Configure::read("pagination.threads");
if (($count = intval($count)) <= 0) {
$count = Configure::read("pagination.threads");
}
if ($count > Configure::read('plugins.api.page_item_limit')) {
$count = Configure::read("pagination.threads");
}
$page = isset($this->params['url']['page']) ? $this->params['url']['page'] : 1;
$page = intval($page);
$pagination = new Pagination(new ArrayPageableAdapter($res), $count);
$articles = $pagination->getPage($page);
$wrapper = Wrapper::getInstance();
$data = array();
$data['pagination'] = $wrapper->page($pagination);
foreach ($articles as $v) {
$data['article'][] = $wrapper->article($v, array('threads' => false));
}
$this->set('data', $data);
}
public function actionNew_article() {
$this->pageTitle = 'Новые cтатьи';
$this->active_link = 'new_article';
$model = new Article('search');
$model->unsetAttributes(); // clear any default values
$additionalCriteria = new CDbCriteria;
// $additionalCriteria->select = 't.id, t.title,t.status_org,t.updated_date,t.views_count';
$additionalCriteria->condition = 't.part is null and t.verified is false';
if(isset($_GET['Article']))
$model->attributes=$_GET['Article'];
$model->status_org = null;
$model_search = $model->search(array(),$additionalCriteria);
$this->render('index',array(
'model'=>$model, 'model_search'=>$model_search
));
}
$_SESSION['error'] = "The username and password does not match";
header('Location: index.php?action=login');
}
} else {
$_SESSION['error'] = "The catche does not match";
header('Location: index.php?action=login');
}
} else {
if (isset($_POST['search'])) {
$rawquery = $_POST['query'];
// $rawquery = htmlspecialchars($rawquery);
// $rawquery = mysql_real_escape_string($rawquery);
$query = "SELECT * FROM article\n WHERE `posttitle` LIKE '%" . $rawquery . "%'";
//var_dump($query);die;
$search = new Article();
$result = $search->search($query);
//var_dump($result) ;die;
//var_dump($result);die;
if ($result) {
header('Location: ../index.php?action=search');
} else {
header('Location: ../index.php?action=search');
$_SESSION['error'] = "no result found";
}
} else {
if (isset($_POST['newarticle'])) {
//$_SESSION['pagetitle'] = 'newarticle';
$posttitle = $_POST['posttitle'];
$postdescription = $_POST['postdescription'];
$postcategory = $_POST['postcategory'];
$postmetatag = $_POST['postmetatag'];
<?php $article = new Article(); $li = $article->search(); //var_dump($li);die; ?> <div class="container"> <div class="col-md-4"><h3>search results</h3></div> </div>
public function no_testSearch()
{
$articles = [new Article(), new Article()];
$qb = $this->getMock('\\SimpleAR\\Orm\\Builder', array('count', 'all'));
$qb->expects($this->once())->method('count')->will($this->returnValue(2));
$qb->expects($this->once())->method('all')->will($this->returnValue($articles));
Article::setQueryBuilder($qb);
$res = Article::search([], 1, 10);
$expected = ['count' => 2, 'rows' => $articles];
$this->assertEquals($expected, $res);
}
