public function actionIndex() { $identity = Yii::app()->user->identity; $OrganID = Yii::app()->user->getOrganID(); $model = User::model()->with('organ')->findByPk(Yii::app()->user->id); if ($identity == 3) { $modelname = "jpd_llegal_record_service"; } else { $modelname = "jpd_llegal_record_dealer"; } $sql = "SELECT a.*, c.Behavior, b.OrganName, b.Identity, d.`Name` FROM " . $modelname . " AS a \n LEFT JOIN jpd_organ AS b ON a.OrganID = b.ID LEFT JOIN jpd_irregular AS c on a.SettingsID = c.ID \n LEFT JOIN jpd_irregular_item AS d ON c.ItemID = d.ID\n WHERE a.IsDelete = 0 AND a.Status = 1 AND c.`Status` = 1 AND a.OrganID = '{$OrganID}' Order By a.CreateTime DESC"; $data = Yii::app()->jpdb->createCommand($sql)->queryAll(); foreach ($data as $key => $val) { $data[$key]['ListNumber'] = "第" . $val['ListNumber'] . "次"; } $dataProvider = self::getdataprovider($data); $totalmodel = LlegalRecord::model()->find("OrganID = '{$OrganID}'"); if (empty($totalmodel)) { $totalmodel = new LlegalRecord(); $totalmodel->OrganID = $OrganID; $totalmodel->save(); } $TotalScore = $totalmodel->TotalScore; $this->render('index', array("model" => $model, "dataProvider" => $dataProvider, "TotalScore" => $TotalScore)); }
public static function getrecord($OrganID) { $recordmodel = LlegalRecord::model()->find("OrganID = '{$OrganID}'"); if (empty($recordmodel)) { $recordmodel = new LlegalRecord(); $recordmodel->OrganID = $OrganID; $recordmodel->save(); } return $recordmodel->TotalScore; }