public function actionIndex() { $this->pageTitle = $this->dataSystem->title; // Dang ky Internet $criInternet = new CDBCriteria(); $criInternet->addCondition("category_news_id = 1"); $criInternet->order = "id DESC"; $criInternet->limit = 3; $arrInternet = News::model()->findAll($criInternet); //Dang ky cap quang $criOptical = new CDBCriteria(); $criOptical->addCondition("category_news_id = 2"); $criOptical->order = "id DESC"; $criOptical->limit = 3; $arrOptical = News::model()->findAll($criOptical); //Store $criStore = new CDBCriteria(); $criStore->addCondition("category_news_id = 6"); $criStore->order = "id DESC"; $criStore->limit = 3; $arrStore = News::model()->findAll($criStore); //CA $criCa = new CDBCriteria(); $criCa->addCondition("category_news_id = 3"); $criCa->order = "id DESC"; $criCa->limit = 3; $arrCa = News::model()->findAll($criCa); //Sim - Card $criSimCard = new CDBCriteria(); $criSimCard->addCondition("category_news_id = 4"); $criSimCard->order = "id DESC"; $criSimCard->limit = 3; $arrSimCard = News::model()->findAll($criSimCard); //TV $criTv = new CDBCriteria(); $criTv->addCondition("category_news_id = 7"); $criTv->order = "id DESC"; $criTv->limit = 3; $arrTv = News::model()->findAll($criTv); /*Pictures*/ $criPic = new CDbCriteria(); $criPic->addCondition("album_id = 2"); $criPic->order = "id DESC"; $criPic->limit = 10; $arrPic = Images::model()->findAll($criPic); /*Slider*/ $criBanner = new CDbCriteria(); $criBanner->order = "id DESC"; $criBanner->limit = 5; $arrBanner = Slides::model()->findAll($criBanner); /*Links web*/ $arrLink = Links::model()->find(); $this->render("index", array('arrBanner' => $arrBanner, 'arrInternet' => $arrInternet, 'arrOptical' => $arrOptical, 'arrStore' => $arrStore, 'arrCa' => $arrCa, 'arrSimCard' => $arrSimCard, 'arrTv' => $arrTv, 'arrLink' => $arrLink)); }
public function actionIndex() { $model = Links::model()->find(); if (!empty($_POST['Links'])) { $model->attributes = $_POST['Links']; if ($model->save()) { Yii::app()->user->setFlash('success', translate('Cập nhật thành công.')); $this->redirect(PIUrl::createUrl('/admin/links')); } } $this->render('index', array('model' => $model)); }
public static function toArray() { $arr = array(); //Coloca os nomes $links = Links::model()->findAll(); foreach ($links as $link) { $arr[] = $link->nome; foreach (explode(', ', $link->tags) as $tag) { if (!in_array($tag, $arr)) { $arr[] = $tag; } } } //Coloca as tags return $arr; }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer $id the ID of the model to be loaded * @return Links the loaded model * @throws CHttpException */ public function loadModel($id) { $model = Links::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
private function doTb($tid, $cid = 0) { if ($tid == 2610) { //彩票部分 $cacheId = 'doTb_' . $tid; $fcurl = cacheGet($cacheId); if (empty($fcurl)) { $url = 'http://www.114la.com/icai.json'; $fcurl = XUtils::fcurl($url); cacheSet($cacheId, $fcurl, 3600); } $fcurl = substr($fcurl, 17, -1); $data_arr = json_decode($fcurl, TRUE); if (!empty($data_arr)) { //对应关系 $dy = array('ssq' => array(220, 221, 222), 'dlt' => array(223, 224, 225), 'fc3d' => array(226, 227, 228), 'jx_11x5' => array(229, 230, 231)); foreach ($data_arr as $tp => $v) { $va = $v[0]; $fdata[$dy[$tp][0]] = array(0 => array('title' => '上期开奖号码', 'link' => $va['url'][0], 'opt_a' => implode(',', $va['result']), 'opt_b' => $va['phase'], 'opt_c' => $va['date'])); $fdata[$dy[$tp][1]] = array(0 => array('title' => '立即投注', 'link' => $va['url'][1]), 1 => array('title' => $va['chain'][0], 'link' => $va['chain'][1])); foreach ($va['link'] as $vl => $tu) { $tu['link'] = $tu['url']; unset($tu['url']); $va['link'][$vl] = $tu; } $fdata[$dy[$tp][2]] = $va['link']; } } if (!empty($fdata)) { foreach ($fdata as $cid => $cinfo) { Links::model()->deleteAll("catalog_id=:cid", array(':cid' => $cid)); foreach ($cinfo as $info) { try { $model = new Links(); $info['catalog_id'] = $cid; $info['title'] = empty($info['title']) ? '待定' : $info['title']; $info['link'] = empty($info['link']) || $info['link'] == '#' ? 'http://www.114la.com/' : $info['link']; $info['mix'] = empty($info['mix']) ? null : base64_decode($info['mix']); $info = array_filter($info); $model->attributes = $this->_form($info); // ppr($model->attributes); $model->save(); } catch (Exception $exc) { return 'error1caipiao'; } } } } return 'ok'; // ppr($fdata,1); } elseif ($tid == 1114) { //实时热点部分 $cacheId = 'doTb_' . $tid; $fcurl = cacheGet($cacheId); if (empty($fcurl)) { $url = 'http://api4.114la.com/1114_2.json'; $fcurl = XUtils::fcurl($url); cacheSet($cacheId, $fcurl, 3600); } $fcurl = substr($fcurl, 20, -1); // ppr($fcurl,1); if (!empty($fcurl) && ($fcurl = json_decode($fcurl, 1))) { //先将对应的旧数据处理 $old = reqPost('old'); if (empty($old)) { Links::model()->updateAll(array('status_is' => 'N'), "`catalog_id`='{$cid}'"); } else { Links::model()->deleteAll("catalog_id=:cid", array(':cid' => $cid)); } // ppr(Links::model()->findAll("`catalog_id`='$cid'")); foreach ($fcurl as $info) { try { $model = new Links(); $info['catalog_id'] = $cid; $info['title'] = empty($info['title']) ? '待定' : $info['title']; $info['link'] = empty($info['url']) || $info['url'] == '#' ? 'http://www.114la.com/' : $info['url']; unset($info['url']); $info = array_filter($info); $model->attributes = $this->_form($info); // ppr($model->attributes); $model->save(); } catch (Exception $exc) { return 'error1'; } } $cacheId = '_catalogAllNum'; $catalogAllNum = XXcache::refresh($cacheId); return empty($catalogAllNum[$cid]) ? 0 : $catalogAllNum[$cid] . ' ok'; } else { return 'error2'; } ppr($data_arr, 1); } elseif ($tid > 1000 && $tid < 10000) { $tid = (int) $tid; $data = $re = 0; $cacheId = 'doTb_' . $tid; $fcurl = cacheGet($cacheId); if (empty($fcurl)) { $url = 'http://www.114la.com/api/ky.php?id=' . $tid . '&' . time(); // $url = 'http://www.114la.com/api/ky.php?id='.$tid; $fcurl = XUtils::fcurl($url); cacheSet($cacheId, $fcurl, 3600); } if (!empty($fcurl) && ($fcurl = json_decode($fcurl, 1))) { //先将对应的旧数据处理 $old = reqPost('old'); if (empty($old)) { Links::model()->updateAll(array('status_is' => 'N'), "`catalog_id`='{$cid}'"); } else { Links::model()->deleteAll("catalog_id=:cid", array(':cid' => $cid)); } // ppr(Links::model()->findAll("`catalog_id`='$cid'")); foreach ($fcurl as $info) { try { $model = new Links(); $info['catalog_id'] = $cid; $info['title'] = empty($info['title']) ? '待定' : $info['title']; $info['link'] = empty($info['link']) || $info['link'] == '#' ? 'http://www.114la.com/' : $info['link']; $info['mix'] = empty($info['mix']) ? null : base64_decode($info['mix']); $info = array_filter($info); $model->attributes = $this->_form($info); // ppr($model->attributes); $model->save(); } catch (Exception $exc) { return 'error1'; } } $cacheId = '_catalogAllNum'; $catalogAllNum = XXcache::refresh($cacheId); return empty($catalogAllNum[$cid]) ? 0 : $catalogAllNum[$cid] . ' ok'; } else { return 'error2'; } } else { return 'error3'; } }
/** * * @param type $cid */ private function _getDataCid($cid, $count) { $theTime = $this->_thetime; $re = null; empty($count) && ($count = 1000); // 状态可用 在期限内 $params = array(':cid' => $cid); $sql = "\n SELECT *\n FROM {{links}}\n WHERE `status_is`='Y'\n AND `catalog_id` = :cid\n AND (`begin_time`='0' OR `begin_time` IS NULL OR `begin_time` < '{$theTime}')\n AND (`end_time`='0' OR `end_time` IS NULL OR `end_time` > '{$theTime}')\n ORDER BY sort_order ASC\n LIMIT {$count}\n "; $data = Links::model()->findAllBySql($sql, $params); if (!empty($data)) { foreach ($data as $key => $value) { if (empty($value->id)) { continue; } $re[$key]['title'] = $value->title; $re[$key]['title_color'] = $value->title_color; $re[$key]['id'] = $value->id; $re[$key]['link'] = empty($value->link) ? null : $value->link; $re[$key]['image_link'] = empty($value->image_link) ? null : $value->image_link; $re[$key]['opt_a'] = empty($value->opt_a) ? null : $value->opt_a; $re[$key]['opt_b'] = empty($value->opt_b) ? null : $value->opt_b; $re[$key]['opt_c'] = empty($value->opt_c) ? null : $value->opt_c; $re[$key]['mix'] = empty($value->mix) ? null : $value->mix; } } // ppr($re); return $re; }
echo $form->textArea($model, 'link_to', array('rows' => 6, 'cols' => 50)); ?> <?php echo $form->error($model, 'link_to'); ?> </div> <div class="row"> <?php echo $form->labelEx($model, 'idLinks.name'); ?> <?php //echo $form->textField($model,'id_links'); ?> <?php echo $form->dropDownList($model, 'id_links', CHtml::listData(Links::model()->findAll(), 'id_links', 'name'), array('disabled' => $model->id_links != '' ? 'disabled' : '')); ?> <?php echo $form->error($model, 'id_links'); ?> </div> <div class="row"> <?php echo $form->labelEx($model, 'idLanguage.name'); ?> <?php //echo $form->textField($model,'id_language'); ?> <?php echo $form->dropDownList($model, 'id_language', CHtml::listData(Language::model()->findAll(), 'id_language', 'name'));
public function actionDelete() { parent::_acl(); $catalogId = reqGet('catalogId', null); // ppr($_REQUEST,1); if (!empty($catalogId)) { $catalogId = intval($catalogId); $model = Catalog::model()->findByPk($catalogId); $name = $model->catalog_name; $model->delete(); XXcache::refresh('_catalog'); XXcache::refresh('_catalogAll'); $model = Links::model()->deleteAll('catalog_id=:cid', array(':cid' => $catalogId)); parent::_backendLogger(array('catalog' => 'delete', 'intro' => '删除分类 ' . $name . '(' . $catalogId . ') 及该分类所有链接')); XUtils::message('success', '已删除分类 ' . $name . ' 及该分类所有链接'); } $this->redirect(Yii::app()->request->urlReferrer); }
public function actionDelete_link() { if (!empty($_GET['link_id'])) { Links::model()->deleteByPk($_GET['link_id']); } }
protected static function _getCatalogAllNum() { $re = null; $data = Links::model()->findAllBySql("\n SELECT t.catalog_id,COUNT(*) mix \n FROM {{links}} t\n WHERE t.status_is = 'Y' \n AND (t.begin_time=0 OR begin_time<:thetime)\n AND (t.end_time=0 OR end_time>:thetime)\n GROUP BY t.catalog_id", array(':thetime' => time())); if (!empty($data)) { foreach ($data as $value) { $re[$value->catalog_id] = $value->mix; } } unset($data); return $re; }