public function actionCountRecord()
{
try {
$request = Yii::app()->request;
$data = count(Clinics::model()->findAll());
ResponseHelper::JsonReturnSuccess($data, 'Success');
} catch (Exception $ex) {
var_dump($ex->getMessage());
}
}
public function searchByAddressAndKeywords($province, $district, $ward, $limit, $offset, $keywords)
{
$criteria = new CDbCriteria();
if (!empty($province)) {
$criteria->addCondition("province={$province}");
}
if (!empty($ward)) {
$criteria->addCondition("ward={$ward}");
}
if (!empty($district)) {
$criteria->addCondition("district={$district}");
}
if (!empty($keywords)) {
$criteria->addSearchCondition('name', $keywords, TRUE, 'OR', 'LIKE');
$criteria->addSearchCondition('address', $keywords, TRUE, 'OR', 'LIKE');
}
$criteria->limit = $limit;
$criteria->offset = $offset;
$criteria->order = 'clinic_id DESC';
$data = Clinics::model()->findAll($criteria);
$cnt = count($data);
return array('cnt' => $cnt, 'data' => $data);
}
public function actionGetTreePages()
{
$result = array();
if (isset($_REQUEST['model']) && isset($_REQUEST['page'])) {
$limit = isset($_REQUEST['limit']) ? $_REQUEST['limit'] : 30;
$model = $_REQUEST['model'];
$id = $_REQUEST['id'];
$bid = $_REQUEST['bid'];
$p = isset($_REQUEST['page']) ? $_REQUEST['page'] - 1 : 0;
$items = array();
$isParent = false;
$count = 0;
$criteria = new CDbCriteria();
switch ($model) {
case 'news':
$criteria->addCondition("is_active = 1");
$criteria->limit = $limit;
$criteria->offset = $p * $limit;
$items = News::model()->findAll($criteria);
if (is_array($items) && count($items)) {
foreach ($items as $item) {
$checked = BannersPagesRelation::model()->findByAttributes(array("banner_id" => $bid, "object_id" => $item->id, "model" => $model)) ? true : false;
$result[] = array('name' => $item->name, 'model' => $model, 'id' => $item->id, 'oid' => $item->id, 'isParent' => $isParent, "checked" => $checked);
}
}
break;
case 'articles_categories':
$criteria->addCondition("is_active = 1");
$criteria->limit = $limit;
$criteria->offset = $p * $limit;
$items = ArticlesCategories::model()->findAll($criteria);
if ($id == 0) {
$isParent = true;
$model = 'articles';
}
if (is_array($items) && count($items)) {
foreach ($items as $item) {
$criteria = new CDbCriteria();
$criteria->addCondition("category_id = :cid AND is_active = 1");
$criteria->params = array(":cid" => $item->id);
$count = Articles::model()->count($criteria);
$checked = BannersPagesRelation::model()->findByAttributes(array("banner_id" => $bid, "object_id" => $item->id, "model" => $model)) ? true : false;
$result[] = array('name' => $item->name, 'model' => $model, 'id' => $item->id, 'oid' => $item->id, 'count' => $count, 'page' => $p, 'pageSize' => 30, 'isParent' => $isParent, "checked" => $checked);
}
}
break;
case 'articles':
$criteria->addCondition("category_id = :cid AND is_active = 1");
$criteria->limit = $limit;
$criteria->offset = $p * $limit;
$criteria->params = array(":cid" => $id);
$items = Articles::model()->findAll($criteria);
if (is_array($items) && count($items)) {
foreach ($items as $item) {
$checked = BannersPagesRelation::model()->findByAttributes(array("banner_id" => $bid, "object_id" => $item->id, "model" => $model)) ? true : false;
$result[] = array('name' => $item->name, 'model' => $model, 'id' => $item->id, 'oid' => $item->id, 'isParent' => $isParent, "checked" => $checked);
}
}
break;
case 'clinics':
$criteria->addCondition("is_active = 1");
$criteria->limit = $limit;
$criteria->offset = $p * $limit;
$items = Clinics::model()->findAll($criteria);
if (is_array($items) && count($items)) {
foreach ($items as $item) {
$checked = BannersPagesRelation::model()->findByAttributes(array("banner_id" => $bid, "object_id" => $item->id, "model" => $model)) ? true : false;
$result[] = array('name' => $item->name, 'model' => $model, 'id' => $item->id, 'oid' => $item->id, 'isParent' => $isParent, "checked" => $checked);
}
}
break;
case 'experts':
$criteria->addCondition("is_active = 1");
$criteria->limit = $limit;
$criteria->offset = $p * $limit;
$items = Experts::model()->findAll($criteria);
if (is_array($items) && count($items)) {
foreach ($items as $item) {
$checked = BannersPagesRelation::model()->findByAttributes(array("banner_id" => $bid, "object_id" => $item->id, "model" => $model)) ? true : false;
$result[] = array('name' => $item->name, 'model' => $model, 'id' => $item->id, 'oid' => $item->id, 'isParent' => $isParent, "checked" => $checked);
}
}
break;
case 'book_categories':
$criteria->addCondition("is_active = 1");
$criteria->limit = $limit;
$criteria->offset = $p * $limit;
$items = BookCategories::model()->findAll($criteria);
if ($id == 0) {
$isParent = true;
$model = 'book';
}
if (is_array($items) && count($items)) {
foreach ($items as $item) {
$criteria = new CDbCriteria();
$criteria->addCondition("category_id = :cid AND is_active = 1");
$criteria->params = array(":cid" => $item->id);
$count = BookPages::model()->count($criteria);
$checked = BannersPagesRelation::model()->findByAttributes(array("banner_id" => $bid, "object_id" => $item->id, "model" => $model)) ? true : false;
$result[] = array('name' => $item->name, 'model' => $model, 'id' => $item->id, 'oid' => $item->id, 'count' => $count, 'page' => $p, 'pageSize' => 30, 'isParent' => $isParent, "checked" => $checked);
}
}
break;
case 'book':
$criteria->addCondition("category_id = :cid AND is_active = 1");
$criteria->limit = $limit;
$criteria->offset = $p * $limit;
$criteria->params = array(":cid" => $id);
$items = BookPages::model()->findAll($criteria);
if (is_array($items) && count($items)) {
foreach ($items as $item) {
$checked = BannersPagesRelation::model()->findByAttributes(array("banner_id" => $bid, "object_id" => $item->id, "model" => $model)) ? true : false;
$result[] = array('name' => $item->name, 'model' => $model, 'id' => $item->id, 'oid' => $item->id, 'isParent' => $isParent, "checked" => $checked);
}
}
break;
}
}
echo json_encode($result);
}
