function get_scws_words($disease_article)
{
$keywords_scws = array();
if (empty($keywords_scws) && !empty($disease_article->keywords)) {
$keywords_scws = \librarys\helpers\utils\SearchHelper::scws($disease_article->keywords);
}
if (empty($keywords_scws) && !empty($disease_article->title)) {
$keywords_scws = \librarys\helpers\utils\SearchHelper::scws($disease_article->title);
}
return $keywords_scws;
}
/**
* 分诊
* @param type $askinfo 问答的信息
*/
public function triage($askinfo)
{
$db_v2sns = self::getDB();
$db_jbv2 = \Yii::$app->db_jbv2;
$wd_keshi_ret_default = array('class_level1' => '15', 'class_level2' => '0', 'class_level3' => '0');
$content = $askinfo['content'];
$explain_result = SearchHelper::scws($content);
$callback = array($this, 'filter');
//获取过滤数据
$explain_result = array_filter($explain_result, $callback);
// print_r($explain_result);exit;
//如果无法从用户输入的内容里分出有意义的词，返回默认科室
if (!isset($explain_result[0])) {
return $wd_keshi_ret_default;
}
$all = array();
foreach ($explain_result as $k => $v) {
$all[$v['attr']][] = $v;
}
$wd_keshi_ret['class_level3'] = '0';
//默认三级疾病为0
//
//Ⅰ
//如果有疾病词
if (isset($all['XB'][0])) {
//第一个病的词的名称
$disease_name = $all['XB'][0]['word'];
//通过疾病名查疾病id
$disease_sql = "select id from 9939_disease where name='{$disease_name}'";
$disease_ret = $db_jbv2->createCommand($disease_sql)->queryOne();
$disease_id = $disease_ret['id'];
//9725
//先直接查疾病表是否有该疾病
//如果有直接返回查询结果
//如果没有，通过从症状表查
//通过查wd_disease表得到disease_id
$disease_name_sql = "select id,name from 9939_disease where id={$disease_id}";
$disease_name_ret = $db_jbv2->createCommand($disease_name_sql)->queryOne();
$disease_name = $disease_name_ret['name'];
$class_level3_sql = "select class_level1,class_level2,id from wd_disease where name='{$disease_name}'";
$class_level3 = $db_v2sns->createCommand($class_level3_sql)->queryOne();
if (isset($class_level3['id'])) {
$wd_keshi_ret = $class_level3;
$wd_keshi_ret['class_level3'] = $class_level3['id'];
unset($wd_keshi_ret['id']);
return $wd_keshi_ret;
} else {
//通过疾病id查科室
$disease_condition = 'disease' . $disease_id;
$department_sql = "select depart.name from 9939_department depart,9939_depart_rel_merge merge where merge.source_flag=1 and merge.unique_key='{$disease_condition}' and merge.departmentid=depart.id";
$department_ret = $db_jbv2->createCommand($department_sql)->queryOne();
$department_name = $department_ret['name'];
//通过科室名称进入wd_keshi查询最终的
$wd_keshi_sql = "select class_level1,class_level2 from wd_keshi where name='{$department_name}'";
$wd_keshi_ret = $db_v2sns->createCommand($wd_keshi_sql)->queryOne();
//如果查不到数据放到默认科室里
if (!isset($wd_keshi_ret['class_level1'])) {
$wd_keshi_ret = $wd_keshi_ret_default;
} else {
if (!$wd_keshi_ret['class_level3']) {
$class_level3_sql = "select id from wd_disease where id='{$wd_keshi_ret['class_level3']}'";
$class_level3 = $db_v2sns->createCommand($class_level3_sql)->queryOne();
}
}
return $wd_keshi_ret;
}
}
//Ⅱ
//如果没有疾病词，症状词，只有部位词
if (!isset($all['XZ'][0]) && isset($all['XS'][0])) {
//第一个部位的词的名称
$condition_part_name = $all['XS'][0]['word'];
//通过部位名查部位id
$condition_part_sql = "select id from 9939_part where name='{$condition_part_name}'";
$condition_part_ret = $db_jbv2->createCommand($condition_part_sql)->queryOne();
$condition_part_id = $condition_part_ret['id'];
//39
//通过部位查找所有的疾病
$part_disease_sql = "SELECT unique_key FROM 9939_part_rel_merge WHERE source_flag=1 AND partid={$condition_part_id}";
$part_disease_ret = $db_jbv2->createCommand($part_disease_sql)->queryOne();
$disease_id = str_replace('disease', '', $part_disease_ret['unique_key']);
//7211
//先直接查疾病表是否有该疾病
//如果有直接返回查询结果
//如果没有，通过从症状表查
//通过查wd_disease表得到disease_id
$disease_name_sql = "select id,name from 9939_disease where id={$disease_id}";
$disease_name_ret = $db_jbv2->createCommand($disease_name_sql)->queryOne();
$disease_name = $disease_name_ret['name'];
$class_level3_sql = "select class_level1,class_level2,id from wd_disease where name='{$disease_name}'";
$class_level3 = $db_v2sns->createCommand($class_level3_sql)->queryOne();
if (isset($class_level3['id'])) {
$wd_keshi_ret = $class_level3;
$wd_keshi_ret['class_level3'] = $class_level3['id'];
unset($wd_keshi_ret['id']);
return $wd_keshi_ret;
} else {
//通过疾病id查科室
$disease_condition = 'disease' . $disease_id;
$department_sql = "select depart.name from 9939_department depart,9939_depart_rel_merge merge where merge.source_flag=1 and merge.unique_key='{$disease_condition}' and merge.departmentid=depart.id";
$department_ret = $db_jbv2->createCommand($department_sql)->queryOne();
$department_name = $department_ret['name'];
//通过科室名称进入wd_keshi查询最终的
$wd_keshi_sql = "select class_level1,class_level2 from wd_keshi where name='{$department_name}'";
$wd_keshi_ret = $db_v2sns->createCommand($wd_keshi_sql)->queryOne();
//如果查不到数据放到默认科室里
if (!isset($wd_keshi_ret['class_level1'])) {
$wd_keshi_ret = $wd_keshi_ret_default;
}
return $wd_keshi_ret;
}
}
//Ⅲ
//如果没有疾病词，部位词，只有症状词
if (!isset($all['XS'][0]) && isset($all['XZ'][0])) {
//症状的词的名称
$symtpom_name = $all['XZ'][0]['word'];
//通过症状名查症状id
$symtpom_sql = "select id from 9939_symptom where name='{$symtpom_name}'";
$symtpom_ret = $db_v2jb->createCommand($symtpom_sql)->queryOne();
$symtpom_id = $symtpom_ret['id'];
//6521
//通过症状id查关联疾病,取第一个病
// $rel_disease_sql = "SELECT diseaseid FROM 9939_disease_symptom_rel WHERE symptomid ={$symtpom_id}";
$rel_disease_sql = "SELECT 9939_disease.id,9939_disease.`name`,9939_disease_symptom_rel.diseaseid FROM 9939_disease LEFT JOIN 9939_disease_symptom_rel ON 9939_disease_symptom_rel.diseaseid=9939_disease.id WHERE symptomid = {$symtpom_id}";
$rel_disease_ret = $db_v2jb->createCommand($rel_disease_sql)->queryOne();
//获取所有症状关联的疾病id
$rel_disease_id = $rel_disease_ret['diseaseid'];
//取第一个病
$rel_disease_name = $rel_disease_ret['name'];
//取第一个病
//先直接查疾病表是否有该疾病
//如果有直接返回查询结果
//如果没有，通过从症状表查
//通过查wd_disease表得到disease_id
$class_level3_sql = "select class_level1,class_level2,id from wd_disease where name='{$rel_disease_name}'";
$class_level3 = $db_v2sns->createCommand($class_level3_sql)->queryOne();
if (isset($class_level3['id'])) {
$wd_keshi_ret = $class_level3;
$wd_keshi_ret['class_level3'] = $class_level3['id'];
unset($wd_keshi_ret['id']);
return $wd_keshi_ret;
} else {
//通过疾病id查科室
$disease_condition = 'disease' . $rel_disease_id;
$department_sql = "select depart.name from 9939_department depart,9939_depart_rel_merge merge where merge.source_flag=1 and merge.unique_key='{$disease_condition}' and merge.departmentid=depart.id";
$department_ret = $db_v2jb->createCommand($department_sql)->queryOne();
$department_name = $department_ret['name'];
//通过科室名称进入wd_keshi查询最终的
$wd_keshi_sql = "select class_level1,class_level2 from wd_keshi where name='{$department_name}'";
$wd_keshi_ret = $db_v2sns->createCommand($wd_keshi_sql)->queryOne();
//如果查不到数据放到默认科室里
if (!isset($wd_keshi_ret['class_level1'])) {
$wd_keshi_ret = $wd_keshi_ret_default;
}
return $wd_keshi_ret;
}
}
//Ⅳ
//如果没有疾病词，有症状词和部位词
if (isset($all['XZ'][0]) && isset($all['XS'][0])) {
//**************1、根据症状取出所有的疾病**************
foreach ($all['XZ'] as $k => $v) {
//症状的词的名称
$symtpom_name = $v['word'];
//通过症状名查症状id
$symtpom_sql = "select id from 9939_symptom where name='{$symtpom_name}'";
$symtpom_ret = $db_v2jb->createCommand($symtpom_sql)->queryOne();
$symtpom_id = $symtpom_ret['id'];
//6521
//通过症状id查关联疾病,取第一个病
$rel_disease_sql = "SELECT diseaseid FROM 9939_disease_symptom_rel WHERE symptomid ={$symtpom_id}";
$rel_disease_ret = $db_v2jb->createCommand($rel_disease_sql)->queryAll();
//获取所有症状关联的疾病id
if (isset($rel_disease_ret[0])) {
break;
}
}
foreach ($rel_disease_ret as $k => $v) {
$rel_disease_id_arr[] = $v['diseaseid'];
}
//**************2、根据部位取出所有的疾病**************
//第一个部位的名称
$condition_part_name = $all['XS'][0]['word'];
//通过部位名查部位id
$condition_part_sql = "select id from 9939_part where name='{$condition_part_name}'";
$condition_part_ret = $db_v2jb->createCommand($condition_part_sql)->queryOne();
//3、如果根据部位查不到疾病，设置疾病id为根据症状查出来的第一个疾病
if (!$condition_part_ret) {
$last_disease_id = $rel_disease_id_arr[0];
} else {
$condition_part_id = $condition_part_ret['id'];
//67
//3.1、通过部位查找所有的疾病
$part_disease_sql = "SELECT unique_key FROM 9939_part_rel_merge WHERE source_flag=1 AND partid={$condition_part_id}";
$part_disease_ret = $db_v2jb->createCommand($part_disease_sql)->queryAll();
foreach ($part_disease_ret as $k => $v) {
$part_disease_id_arr[] = str_replace('disease', '', $v['unique_key']);
}
//**************3.2、取二者的交集的第一个疾病作为最终疾病**************
$last_disease_id_arr = array_intersect($rel_disease_id_arr, $part_disease_id_arr);
//如果没有交集时：
if (empty($last_disease_id_arr)) {
if (!empty($rel_disease_id_arr)) {
$last_disease_id_arr[0] = $rel_disease_id_arr[0];
} else {
if (!empty($part_disease_id_arr)) {
$last_disease_id_arr[0] = $part_disease_id_arr[0];
}
}
}
sort($last_disease_id_arr);
$last_disease_id = $last_disease_id_arr[0];
}
//先直接查疾病表是否有该疾病
//如果有直接返回查询结果
//如果没有，通过从症状表查
//通过查wd_disease表得到disease_id
$disease_name_sql = "select id,name from 9939_disease where id={$last_disease_id}";
$disease_name_ret = $db_v2jb->createCommand($disease_name_sql)->queryOne();
$disease_name = $disease_name_ret['name'];
$class_level3_sql = "select class_level1,class_level2,id from wd_disease where name='{$disease_name}'";
$class_level3 = $db_v2sns->createCommand($class_level3_sql)->queryOne();
if (isset($class_level3['id'])) {
$wd_keshi_ret = $class_level3;
$wd_keshi_ret['class_level3'] = $class_level3['id'];
unset($wd_keshi_ret['id']);
return $wd_keshi_ret;
} else {
//通过疾病id查科室
$disease_condition = 'disease' . $last_disease_id;
$department_sql = "select depart.name from 9939_department depart,9939_depart_rel_merge merge where merge.source_flag=1 and merge.unique_key='{$disease_condition}' and merge.departmentid=depart.id";
$department_ret = $db_v2jb->createCommand($department_sql)->queryOne();
$department_name = $department_ret['name'];
//通过科室名称进入wd_keshi查询最终的
$wd_keshi_sql = "select class_level1,class_level2 from wd_keshi where name='{$department_name}'";
$wd_keshi_ret = $db_v2sns->createCommand($wd_keshi_sql)->queryOne();
//如果查不到数据放到默认科室里
if (!isset($wd_keshi_ret['class_level1'])) {
$wd_keshi_ret = $wd_keshi_ret_default;
}
return $wd_keshi_ret;
}
}
//未考虑到的情形，直接返回默认科室
return $wd_keshi_ret_default;
}
