【YII】常用代码积累

1. YII 使用原生SQL


1.1查询单个表

//查表得到 svn path        $connection = Yii::app()->db;        $sql = "SELECT * FROM code_coverage_project WHERE id = $code_id   LIMIT  1 ";        $command = $connection->createCommand($sql);        $rows = $command->queryAll();        $count_rows = count($rows);        //异常处理        if (0 == $count_rows)        {            $msg = Yii::t('TOAST', 'No Result  For The Code Id!');            header('Content-type: text/html; charset=UTF-8');            echo json_encode(array('error' => 1, 'message' => $msg));            exit;        }        $svn_path = $rows[0]['path']; //异常检测

1.2查询多个表

/*         *@根据类名，查找对应版本的覆盖率         *          *@$code_id   = 393;         *@$version_1 = 119577;         *@$version_2 = 120046;         *@$classname = $array_filtered_calsses[0][0];         *@print_r($classname);         *@return;         *          */        $connection = Yii::app()->db;        $sql_class_and_versions = "SELECT code_coverage.reversion_id,                                          code_qulity_class_covery.id,                                          code_qulity_class_covery.classname,                                          code_qulity_class_covery.linecoverd,                                          code_qulity_class_covery.linemissed,                                          code_qulity_class_covery.coverdrate                                  FROM                                          code_qulity_class_covery                                  LEFT JOIN code_coverage                                  ON                                         code_qulity_class_covery.code_covery_id = code_coverage.id                                  WHERE                                         code_coverage.code_project_id = $code_id AND                                         code_coverage.reversion_id IN ($version_1, $version_2) AND                                         code_qulity_class_covery.classname IN ($classname_for_sql_in); ";                $command_for_calss_and_versions=$connection->createCommand($sql_class_and_versions);        $rows_for_calss_and_versions = $command_for_calss_and_versions->queryAll();        $count_rows = count($rows_for_calss_and_versions);                if (0 == count($rows_for_calss_and_versions))        {            $msg = Yii::t('TOAST', "Sorry,no record matches in the database!");            header('Content-type: text/html; charset=UTF-8');            echo json_encode(array('error' => 1, 'message' => $msg));            exit;        }

2. 有关正则

 /*         * 从变动的文件列表提取类名         */         $count = 0;        $array_dot_java = array();        $array_change_classname = array();        $pattern_java = '/.*java$/';        $pattern_for_calss ='/cn\/com.*\/[A-z]*/';                foreach ($arr_change_files as $values)        {            if(preg_match($pattern_java,$values)) //过滤得到.java结尾的记录            {                $array_dot_java[] = $values;                if(preg_match($pattern_for_calss,$values,$matchs)) //过滤得到类名                {                    $matchs[0]=preg_replace('/\//', '.', $matchs[0]); // 替换类名中的 “/"                    $array_change_classname[] = $matchs;                }            }                }                if (0 == count($array_change_classname))        {            $msg = Yii::t('TOAST', "No class changes between the tow versions!");            header('Content-type: text/html; charset=UTF-8');            echo json_encode(array('error' => 1, 'message' => $msg));            exit;        }                //根据package name 过滤 classname        $array_filtered_calsses = array();        $pattern_to_filter_class = "/.*$package_name.*/"; // cn.com.autofans.user.service.imp        foreach($array_change_classname as $valus_to_filter_class)        {            if(preg_match($pattern_to_filter_class,$valus_to_filter_class[0]))            {                $array_filtered_calsses[] = $valus_to_filter_class;            }                }        if (0 == count($array_filtered_calsses))        {            $msg = Yii::t('TOAST', "No classes matches the packet that post from pages!");            header('Content-type: text/html; charset=UTF-8');            echo json_encode(array('error' => 1, 'message' => $msg));            exit;        }        

3. array()处理

          /*         * 查询结果解析转换为 符合json的形式         * $version_1 = 119577;         * $version_2 = 120046;         */               $r_version_1 = "r".$version_1;       $r_version_2 = "r".$version_2;       $arr_json_classname = array();       $arr_json_rate      = array();       $arr_just_rate      = array();       $arr_json_rate[$r_version_1] = array();       $arr_json_rate[$r_version_2] = array();              foreach($array_filtered_calsses as $values_switch_to_json)       {           $arr_json_classname [] = $values_switch_to_json[0];  //类名处理           $arr_just_rate[$version_1] [$values_switch_to_json[0]] = 0;           $arr_just_rate[$version_2] [$values_switch_to_json[0]] = 0;       }              foreach ($arr_json_classname as  $values_calssname)       {           foreach($rows_for_calss_and_versions as $values_switch_to_json_rate)           {               if($version_1 == $values_switch_to_json_rate['reversion_id'])               {                   if ($values_calssname == $values_switch_to_json_rate ['classname'])                   {                       $arr_just_rate [$version_1][$values_calssname] = $values_switch_to_json_rate['coverdrate'];                   }               }                              if($version_2 == $values_switch_to_json_rate['reversion_id'])               {                   if ($values_calssname == $values_switch_to_json_rate ['classname'])                   {                       $arr_just_rate [$version_2][$values_calssname] = $values_switch_to_json_rate['coverdrate'];                   }               }           }       }              foreach ($arr_just_rate [$version_1] as $value_last)       {           $arr_version_1 []= floatval($value_last);       }       foreach ($arr_just_rate [$version_2] as $value_last)       {           $arr_version_2 []= floatval($value_last);       }              foreach($arr_json_classname as $value_to_cut_classname)       {           $pattern = "/".$package_name."./";           $replacement = '';           $temp_classname = preg_replace($pattern,$replacement,$value_to_cut_classname);           $array_just_classname [] = $temp_classname;       }              $data_temp = array($r_version_1 => $arr_version_1,$r_version_2 =>$arr_version_2 );       $xaxis = $array_just_classname;       $data = $data_temp;//     $xaxis = array(  'class A', 'class B', 'class C', 'Class D', 'Class E' );//     $data = array( 'r12345'=>array(48.9, 38.8, 39.3, 41.4, 47.0), 'r67890'=>array(62.4, 53.2, 54.5, 59.7, 72.6));    echo json_encode(array('xaxis'=>$xaxis, 'coverdata'=>$data));