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;
}
