function get_disease_symptom()
{
    $console = Yii::getAlias("@console");
    $file = $console . '/shell/disease_symptom.php';
    $disease_symptom_arr = [];
    if (file_exists($file)) {
        $disease_symptom_str = file_get_contents($file);
        $disease_symptom_arr = unserialize($disease_symptom_str);
    } else {
        $diseases = \common\models\Disease::find()->asArray()->all();
        foreach ($diseases as $disease) {
            $name = $disease['name'];
            $row = array('id' => $disease['id'], 'source_flag' => 1);
            $disease_symptom_arr[$name] = $row;
        }
        $symptoms = \common\models\Symptom::find()->asArray()->all();
        foreach ($symptoms as $symptom) {
            $name = $symptom['name'];
            if (!isset($disease_symptom_arr[$name])) {
                $row = array('id' => $symptom['id'], 'source_flag' => 2);
                $disease_symptom_arr[$name] = $row;
            }
        }
        $disease_symptom_str = serialize($disease_symptom_arr);
        file_put_contents($file, $disease_symptom_str);
    }
    return $disease_symptom_arr;
}
 /**
  * 根据疾病的拼音简写,得到疾病的信息
  * @author gaoqing
  * @date 2016-03-23
  * @param String $pyInitial 疾病的拼音简写
  * @return array 疾病的信息集
  */
 public function getDiseasesByPinyin($pyInitial)
 {
     $disease = [];
     if ($this->isNotNull($pyInitial)) {
         //疾病基本信息
         $diseaseBasic = Disease::find()->where(['pinyin_initial' => $pyInitial])->asArray(true)->one();
         //疾病详细信息
         $diseaseContent = [];
         if ($this->isNotNull($diseaseBasic)) {
             $diseaseContent = DiseaseContent::find()->where(['id' => $diseaseBasic['id']])->asArray(true)->one();
         }
         if ($this->isNotNull($diseaseBasic) && $this->isNotNull($diseaseContent)) {
             $diseaseContentApp = $diseaseContent;
             foreach ($diseaseContentApp as $key => $content) {
                 $diseaseContentApp[$key] = String::cutString($content, 35);
             }
             $disease = array_merge($diseaseBasic, $diseaseContent);
             $disease['content_app'] = $diseaseContentApp;
         }
     }
     if (!isset($disease) || empty($disease)) {
         throw new NotFoundHttpException("当前访问的页面不存在!");
     }
     return $disease;
 }
 /**
  * 根据疾病id, 获取当前疾病相关疾病的图集
  * @author gaoqing
  * @date 2016-05-05
  * @param int $diseaseid 疾病id
  * @param int $size 所需的个数
  * @return array 相关疾病的图集
  */
 public static function getRelDiseaseImages($diseaseid, $size)
 {
     $relDiseaseImages = [];
     //1、得到所有的相关疾病
     $disease = new Disease();
     $relDiseases = $disease->getDiseaseDisByDisid($diseaseid);
     //2、得到相关疾病的图集
     if (isset($relDiseases) && !empty($relDiseases)) {
         $notHasImages = [];
         $inner = [];
         $relDiseaseImagesIndex = 0;
         foreach ($relDiseases as $relDisease) {
             $images = [];
             $inner['disease'] = $relDisease;
             $inner['images'] = $images;
             //2.1、如果当前图集,已经够 $size 了,就停止查询
             if ($relDiseaseImagesIndex == 6) {
                 break;
             }
             //2.2、得到疾病图集
             $icondition = ['flag' => 1, 'relid' => $relDisease['id']];
             $imagesTemp = Image::search($icondition);
             if (isset($imagesTemp['list']) && !empty($imagesTemp['list'])) {
                 $images = $imagesTemp['list'];
                 $inner['images'] = $images;
                 $relDiseaseImages[] = $inner;
                 $relDiseaseImagesIndex++;
             } else {
                 $notHasImages[] = $inner;
             }
         }
         $relDiseaseImagesCount = count($relDiseaseImages);
         /*
          * 3.1、当前 $relDiseaseImages 中不到指定的个数 $size时:
          * 3.2、计算出,距离 $size 所需的个数 $needCount
          * 3.3、从 $notHasImages 中,提前 $needCount 个数据
          */
         if ($relDiseaseImagesCount < $size) {
             $needCount = $size - $relDiseaseImagesCount;
             $needArr = array_slice($notHasImages, 0, $needCount);
             $relDiseaseImages = array_merge($relDiseaseImages, $needArr);
         }
     }
     return $relDiseaseImages;
 }
Example #4
0
 /**
  * 查询科室下的对应疾病集
  * @author gaoqing
  * @date 2016-04-08
  * @param int $columns 在页面中,显示的列数
  * @return array 科室下的对应疾病集
  */
 private static function getDepartmentDis($columns)
 {
     $departmentDis = array();
     $department = new Department();
     $disease = new Disease();
     //get the first level departments
     $firstLevel = $department->getDepartmentLevel1(1);
     if (self::isNotNull($firstLevel)) {
         foreach ($firstLevel as $level1) {
             //select diseases that all belong current first level department
             $inner = array();
             $inner['department'] = $level1;
             $size = count($firstLevel) * $columns;
             $inner['disease'] = $disease->getDiseaseByDepartment($level1['id'], 'class_level1', 0, $size);
             $departmentDis[] = $inner;
         }
         return $departmentDis;
     }
     return $departmentDis;
 }
 public static function createAllDiseaseSymptomCache4Redis()
 {
     $redis = \Yii::$app->redis;
     $redis_expired = 24 * 60 * 60;
     //秒
     $cache_all_disease_symptom_link_key = APP_CACHE_PREFIX . 'CACHE_ALL_DISEASE_SYMPTOM_LINK';
     $cache_all_disease_symptom_link_data = array();
     $all_disease = Disease::find()->select(['name', 'pinyin_initial'])->asArray()->all();
     foreach ($all_disease as $k => $v) {
         $cache_all_disease_symptom_link_data[$v['name']] = \Yii::getAlias('@jb_domain') . '/' . $v['pinyin_initial'] . '/';
     }
     $all_symptom = Symptom::find()->select(['name', 'pinyin_initial'])->asArray()->all();
     foreach ($all_symptom as $k => $v) {
         $cache_all_disease_symptom_link_data[$v['name']] = \Yii::getAlias('@jb_domain') . '/zhengzhuang/' . $v['pinyin_initial'] . '/';
     }
     $redis->hMset($cache_all_disease_symptom_link_key, $cache_all_disease_symptom_link_data, $redis_expired);
     return $cache_all_disease_symptom_link_data;
 }
 public function actionRedirect()
 {
     $diseaseid = $this->helpGquery('disid', 0);
     if ($diseaseid > 0) {
         $oldDisease = new oldDisease();
         $disInfo = $oldDisease->getDiseaseByContentid($diseaseid);
         $url = \Yii::getAlias("@jb_domain");
         //        var_dump($url);exit;
         if ($disInfo) {
             $disname = $disInfo['title'];
             $newDisInfo = Disease::find()->where('name=:name', [':name' => $disname])->one();
             $pinyin_initial = $newDisInfo ? $newDisInfo->pinyin_initial : '';
             $url .= '/' . $pinyin_initial . '/';
             header("Location:{$url}", true, 301);
             exit;
         } else {
             $this->actionDispatch();
         }
     }
 }
Example #7
0
 /**
  * 
  * @param type $sphinx_data sphinx查询结果
  * @return type
  */
 public static function search_disease_data($sphinx_data)
 {
     $total = 0;
     $ret_list = array();
     if (!empty($sphinx_data['matches'])) {
         $arr_ids = array();
         foreach ($sphinx_data['matches'] as $k => $v) {
             $arr_ids[] = $k;
         }
         $disease_list = Disease::List_ByIds($arr_ids);
         if ($disease_list) {
             foreach ($disease_list as $k => $v) {
                 $v['tmp_source_id'] = 1;
                 $v['source_flag'] = 1;
                 $v['url'] = sprintf('%s/%s/', Yii::getAlias('@jb_domain'), $v['pinyin_initial']);
                 $v['wap_url'] = sprintf('%s/%s/', Yii::getAlias('@mjb_domain'), $v['pinyin_initial']);
                 $ret_list[] = $v;
             }
         }
         $total = $sphinx_data['total'];
     }
     $explain_words = $sphinx_data['explain_words'];
     return array('list' => $ret_list, 'total' => $total, 'explain_words' => $explain_words);
 }
 /**
  * 根据疾病的拼音简写,得到疾病的信息
  * @author gaoqing
  * @date 2016-03-23
  * @param String $pyInitial 疾病的拼音简写
  * @param boolean $isRelDis 是否获取其 相关疾病
  * @param boolean $isRelSym 是否获取其 典型症状
  * @param boolean $isRelPart 是否获取其相关 部位
  * @param boolean $isRelDep 是否获取其 就诊科室
  * @return array 疾病的信息集
  */
 public function getDiseasesByPinyin($pyInitial, $isRelDis = false, $isRelSym = false, $isRelPart = false, $isRelDep = false)
 {
     $disease = [];
     //1、得到疾病的疾病信息
     $disease = $this->disease->getDiseasesByPinyin($pyInitial);
     if ($this->isNotNull($disease)) {
         $disease['chuanranxing'] = '无';
         if ($disease['chuanranflag'] == 1) {
             $disease['chuanranxing'] = '有';
         }
         //2、获取科室信息
         if ($isRelDep) {
             $treatDepNames = $this->explodeStr($disease['treat_department']);
             $disease['department'] = $this->department->getDepsByName($treatDepNames);
             $disease['medicine'] = $this->explodeStr($disease['medicine']);
         }
         //3、获取典型症状信息
         if ($isRelSym) {
             $typicalSymptomNames = $this->explodeStr($disease['typical_symptom']);
             $disease['tsymptom'] = $this->symptom->getSymptomsByName($typicalSymptomNames);
         }
         //4、得到疾病对应的所有部位
         if ($isRelPart) {
             $disease['part'] = Relate::getPartsByDisid($disease['id']);
         }
         //5、得到相关疾病
         if ($isRelDis) {
             $relDiseaseNames = $this->explodeStr($disease['rel_disease']);
             $values = Disease::search(['name' => $relDiseaseNames]);
             if ($this->isNotNull($values)) {
                 $disease['reldis'] = $values['list'];
             }
         }
     }
     return $disease;
 }
 /**
  * 找医院
  * @return type
  */
 public function actionHospital()
 {
     $this->setLayout('disease_without_bottom');
     $data = [];
     $obj_disease = new Disease();
     $temp = $this->params;
     $disease = $obj_disease->getDiseasesByPinyin($temp['dname']);
     $data['disease'] = $disease;
     return $this->render('hospital', $data);
 }
 /**
  * 疾病缓存
  */
 public function diseaseCache($param = [], $offset)
 {
     //        $disease = new Disease();
     //        $res = $disease->getAllDisease();
     $disease = new Disease();
     $length = self::$length;
     $offset = ($offset - 1) * $length;
     //        $res = $symptom->getAllSymptom();
     $res = $disease->getDiseaseLimit([], $offset, $length);
     $i = 0;
     foreach ($res as $k => $v) {
         if (CacheHelper::$param['function']($param['key_prefix'], $v, true)) {
             $i++;
         }
     }
     return $i;
 }
 /**
  * 文章页
  * @author gaoqing
  * @date 2016-03-25
  * @return string 视图
  */
 public function actionDetail()
 {
     $view = "detail";
     $aid = $this->helpGparam("aid", "-1");
     //获取文章的信息
     $condition = ['id' => $aid];
     $article = Article::search($condition, 0, 1);
     $article = $article['list'];
     if (!isset($article) || empty($article)) {
         throw new NotFoundHttpException('当前访问的页面不存在!');
     }
     if ($this->isNotNull($article)) {
         $article = $article[0];
         $article['inputtime'] = date('Y-m-d H:i:s', $article['inputtime']);
         $article['keywords_init'] = $article['keywords'];
         $article['keywords'] = explode(' ', $article['keywords']);
     }
     //文章内容添加疾病、症状词的链接
     //lc@2016-5-24
     $cache_all = Article::getAllDiseaseSymptom2Redis();
     $content = $article['content'];
     $link_num = 5;
     //每页内链个数
     $single_link_num = 1;
     //单个词链接个数
     $i = 1;
     $str = '';
     $count = 0;
     foreach ($cache_all as $k => $v) {
         $searchArr = '(' . $k . ')';
         $replaceArr = '<a href="' . $v . '" title="' . $k . '" target="_blank">' . $k . '</a>';
         if ($i > $link_num) {
             break;
         }
         if (stripos($str, $k) === false) {
             $content = preg_replace($searchArr, $replaceArr, $content, $single_link_num, $count);
             if ($count > 0) {
                 $str .= $k;
                 $i++;
             }
         }
     }
     $article['content'] = $content;
     //获取当前文章对应的疾病信息
     $isSymptom = 0;
     if ($article['diseaseid'] > 0) {
         $disease_obj = new Disease();
         $res = $disease_obj->getDiseaseById($article['diseaseid']);
         $disease = $res['disease'];
         $disease['inspect'] = $res['diseaseContent']['inspect'];
     } elseif ($article['symptomid'] > 0) {
         $symptom = Symptom::getSymptomByid($article['symptomid'], true);
         $disease = $symptom;
         $disease['inspect'] = $symptom['examine'];
         $isSymptom = 1;
     }
     //上一篇
     $preCondition = ['<', 'id', $aid];
     $preArticle = Article::search($preCondition, 0, 1, 'id DESC');
     $preArticle = $preArticle['list'];
     if ($this->isNotNull($preArticle)) {
         $preArticle = $preArticle[0];
     }
     //下一篇
     $nextCondition = ['>', 'id', $aid];
     $nextArticle = Article::search($nextCondition, 0, 1, 'id ASC');
     $nextArticle = $nextArticle['list'];
     if ($this->isNotNull($nextArticle)) {
         $nextArticle = $nextArticle[0];
     }
     $relArtsAndAsks = CacheHelper::getCache('frontend_article_detail_xgwz', ['title' => $article['title'], 'id' => $aid, 'diseaseid' => $article['diseaseid'], 'symptomid' => $article['symptomid']]);
     $relArticles = $relArtsAndAsks['relArticles'];
     //相关问答
     $asks = $relArtsAndAsks['relAsks'];
     //hot words part
     $letter_list = range('A', 'Z');
     $randwords = $this->rand_words();
     $hotWords = ['letter' => $letter_list, 'words' => $randwords];
     //common diseases and hot departments part
     $commonDisDep = CacheHelper::getCache('frontend_article_detail_rmksbw', []);
     //大家还在找部分
     $stillFind = $this->getStillFindDatas($disease['name']);
     //右侧:最新文章
     $lastestArticles = $this->getLatestArticles();
     $params = ['article' => $article, 'preArticle' => $preArticle, 'nextArticle' => $nextArticle, 'relArticles' => $relArticles, 'asks' => $asks, 'isSymptom' => $isSymptom, 'disease' => $disease, 'hotWords' => $hotWords, 'commonDisDep' => $commonDisDep, 'stillFind' => $stillFind, 'lastestArticles' => $lastestArticles];
     return $this->render($view, $params);
 }
 private function disSymColSitemap()
 {
     /**
      * <urlset>
      *  <url>
      *  <loc>http://jb.9939.com/gm/jianjie/</loc>
      *  <lastmod>2009-03-27</lastmod>
      *  <changefreq>always</changefreq>
      *  <priority>0.6</priority>
      *  </url>
      * </urlset>
      */
     $this->_changefreq = 'always';
     $this->_priority = '0.6';
     $where = $this->_ownership;
     $flag = 1;
     //目录
     if ($where == 'pc') {
         $frontend = \Yii::getAlias("@frontend");
         $frontDomain = \Yii::getAlias("@frontdomain");
     } elseif ($where == 'wap') {
         $frontend = \Yii::getAlias("@wapjb");
         $frontDomain = \Yii::getAlias("@mjb_domain");
     }
     $sitemapFolder = $this->_baidu ? 'sitemap/sitemapbaidudissymcolindex' : 'sitemap/sitemapdissymcolindex';
     $fileFolder = $frontend . '/web/' . $sitemapFolder;
     if (!file_exists($fileFolder) || !is_dir($fileFolder)) {
         mkdir($fileFolder, 0755, true);
     }
     $type = '';
     // 疾病 | 症状
     $sitemap_site = $this->getSitemapCount($fileFolder, ['dis_offset' => 0, 'sym_offset' => 0, 'max_file_tail' => 0]);
     $dis_offset = $sitemap_site['dis_offset'];
     $dis_obj = new Disease();
     $dis_count = $dis_obj->getCount();
     if ($dis_offset < $dis_count) {
         $type = 'disease';
         $data = $dis_obj->getDiseaseLimit(['status' => 2], $dis_offset, 1000);
         $sitemap_site['dis_offset'] = (int) $dis_offset + count($data);
     } else {
         $type = 'symptom';
         $sym_offset = $sitemap_site['sym_offset'];
         $dis_obj = new Symptom();
         $sym_count = $dis_obj->getCount();
         if ($sym_offset < $sym_count) {
             $data = $dis_obj->getSymptomLimit(['status' => 3], $sym_offset, 2000);
             $sitemap_site['sym_offset'] = (int) $sym_offset + count($data);
             $flag = $sitemap_site['sym_offset'] == $sym_count ? 2 : 1;
         } else {
             //无需生成新的数据,返回索引的url
             $res = $this->generateSitemapIndex($fileFolder, $sitemapFolder, 'dissym');
             return ['flag' => 2, 'siteindex' => $res['url']];
         }
     }
     //xml
     $sitemap = '<?xml version="1.0" encoding="UTF-8"?>';
     $sitemap .= $this->_baidu ? '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:mobile="http://www.baidu.com/schemas/sitemap-mobile/1/">' : '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">';
     $sitemap .= $this->setDiseaseSymptomSubURL($data, $type);
     $sitemap .= '</urlset>';
     $sitemap_site['max_file_tail']++;
     $name_tail = $sitemap_site['max_file_tail'];
     //写入计数文件
     $this->setSitemapCount($sitemap_site, $fileFolder);
     $fileName = 'sitemap' . $name_tail . '.xml';
     if (file_put_contents($fileFolder . '/' . $fileName, $sitemap)) {
         $res = $this->generateSitemapIndex($fileFolder, $sitemapFolder, 'dissym');
         return ['flag' => $flag, 'url' => $frontDomain . '/' . $sitemapFolder . '/' . $fileName, 'name' => $fileName, 'siteindex' => $res['url']];
     }
     return [];
 }
 /**
  * 根据分类id获取该分类下的疾病内容
  * lc 2016-4-11
  * @param type $optionMap 分类id数组
  * @param type $contain_article 是否包含文章
  * @return type
  */
 public function getCategoryData($optionMap, $disease_length = 10, $contain_article = false, $article_length = 4)
 {
     $data = [];
     foreach ($optionMap as $k => $v) {
         $catId[] = $k;
     }
     $obj_disease = new Disease();
     $tmp = $obj_disease->batGetDiseaseByCategoryId($catId);
     $obj_article = new Article();
     //
     $disid = [];
     foreach ($tmp as $k => $v) {
         $data[$v['categoryid']]['disease'][] = $v;
         $disid[$v['categoryid']][] = $v['id'];
     }
     $new_data = [];
     foreach ($disid as $kk => $vv) {
         $new_data[$kk]['disease'] = array_slice($data[$kk]['disease'], 0, $disease_length);
         if ($contain_article) {
             $dis_str = implode(',', $vv);
             $res = $obj_article->getListByGroup($dis_str);
             $new_data[$kk]['article'] = array_slice($res, 0, $article_length);
         }
     }
     ksort($new_data);
     return $new_data;
 }
Example #14
0
 /**
  * 症状首页可能疾病缓存数据
  * lc 2016-4-15
  * @param type $cacheKey 缓存的唯一标识
  * @param type $parms 单条症状所有字段内容数组
  * @param type $forceCache 是否强制缓存,默认不强制缓存
  * @return type
  */
 public static function cacheSymptomRelateDisease($cacheKey, $parms, $forceCache = false)
 {
     $symptomid = $parms['id'];
     $cache = \Yii::$app->cache_data_file;
     $key = $cacheKey . '_' . $symptomid;
     $data = $cache->get($key);
     if ($forceCache) {
         $data = false;
     }
     if (!isset($data) || empty($data)) {
         $relate = new Relate();
         $disease = new Disease();
         $department = new Department();
         $diseaseList = $relate->getRelateDiseases($symptomid);
         //根据关联表查询出疾病id,该症状对应的疾病下的所有疾病信息
         //            print_r($diseaseList);exit;
         if (!empty($diseaseList)) {
             $diseaseId = [];
             foreach ($diseaseList as $k => $v) {
                 $diseaseId[] = $v['diseaseid'];
             }
             $diseaseMap = $disease->batchGetDiseaseById($diseaseId);
             //该症状对应的疾病下的所有疾病信息
             $symptomMap = $relate->batchGetSymptomsByDisid($diseaseId);
             //该症状对应的疾病下对应的所有相关症状
             $diseaseIdStr = implode(',', $diseaseId);
             $departmentMap = $department->batchGetDepartmentsByDisid($diseaseIdStr);
             //该症状对应的疾病对应的所有科室
             //                print_r($departmentMap);exit;
             foreach ($symptomMap as $k => $v) {
                 $disId = $v['diseaseid'];
                 $symId = $v['symptomid'];
                 foreach ($diseaseMap as $kk => $vv) {
                     $pinyin = $vv['pinyin_initial'];
                     if ($vv['id'] == $disId) {
                         $tmp[$pinyin][] = $v;
                     }
                 }
             }
             $diseaseTmp['relDisease'] = $diseaseMap;
             $diseaseTmp['relSymptom'] = $tmp;
             $disTmp = ['diseaseMap' => $diseaseMap, 'symptomMap' => $symptomMap, 'departmentMap' => $departmentMap, 'diseaseTmp' => $diseaseTmp, 'diseaseId' => $diseaseId];
             $cache->set($key, $disTmp);
             return $disTmp;
         }
         return array();
     } else {
         return $data;
     }
 }
<?php

use yii\helpers\Url;
use common\models\Disease;
$obj_disease = new Disease();
$catId = [25];
$res = $obj_disease->batGetDiseaseByCategoryId($catId);
$tmp = array_slice($res, 0, 8);
?>
<h2>健康助手</h2>
<nav class="asdc">
    <a href="http://wapask.9939.com/ask/goAskDoctor"><span></span><p>问医生</p></a><a href="http://m.jb.9939.com/"><span></span><p>查疾病</p></a><a href="javascript:;"><span></span><p>找医院</p></a><a href="http://m.9939.com/drug/"><span></span><p>找药品</p></a>
</nav>

<article class="prot">
    <?php 
if (!empty($tmp)) {
    foreach ($tmp as $k => $v) {
        $url = Url::to('/' . $v['pinyin_initial'] . '/');
        if ($k % 4 == 0) {
            echo '<p>';
        }
        echo '<a href="' . $url . '">' . $v['name'] . '</a>';
        if ($k % 4 == 3) {
            echo '</p>';
        }
    }
}
?>
</article>
Example #16
0
 public function init()
 {
     parent::init();
 }
Example #17
0
 public function getDiseaseLimit($where = [], $offset = 0, $length = 10, $orderBy = 'id DESC')
 {
     return Disease::find()->where($where)->orderBy($orderBy)->offset($offset)->limit($length)->asArray()->all();
 }