Esempio n. 1
0
<div class="peoples-index">
        
    <?php 
echo GridView::widget(['dataProvider' => $dataProvider, 'filterModel' => $searchModel, 'columns' => [['class' => 'yii\\grid\\SerialColumn'], 'peopleFIO', ['attribute' => 'peopleBirthday', 'format' => 'raw', 'value' => function ($data) {
    return date('d.m.Y', strtotime($data->peopleBirthday));
}], ['attribute' => 'peopleWorking', 'value' => 'peopleWorking0.workingName'], ['attribute' => 'fluInfo', 'format' => 'raw', 'value' => function ($data) {
    $res = "";
    if ($data->peopleFluResult == 0) {
        $res = '<span class="label label-danger">Патологія</span>';
    } else {
        $res = '<span class="label label-success">Норма</span>';
    }
    return $data->peopleFluNumber . "<br/>" . date('d.m.Y', strtotime($data->peopleFluDate)) . "<br/>" . $res;
}], ['attribute' => 'graft', 'format' => 'raw', 'value' => function ($data) {
    $r = "";
    $findRes = graftsPeoples::find()->where(['peopleId' => $data->peopleId])->all();
    foreach ($findRes as $f) {
        $graftName = Grafts::find()->where(['graftId' => $f['graftId']])->all();
        $r .= '<span class="label label-primary">' . $graftName[0]['graftName'] . '</span>&nbsp;';
    }
    return $r;
}], ['attribute' => 'chronic', 'format' => 'raw', 'value' => function ($data) {
    $r = "";
    $findRes = chronicDiseasesPeoples::find()->where(['peopleId' => $data->peopleId])->all();
    foreach ($findRes as $f) {
        $chronicDiseasesName = chronicDiseases::find()->where(['chronicDiseasesId' => $f['chronicDiseasesId']])->all();
        $r .= '<span class="label label-primary">' . $chronicDiseasesName[0]['chronicDiseasesName'] . '</span>&nbsp;';
    }
    return $r;
}], ['attribute' => 'peopleStreet', 'value' => 'peopleStreet0.streetName', 'filter' => ArrayHelper::map(Streets::find()->all(), 'streetId', 'streetName')], 'peopleAdress', ['class' => 'yii\\grid\\ActionColumn']]]);
?>
Esempio n. 2
0
 /**
  * Экшн вывода формы для поиска людей по улице и сроку флюры.
  * @return mixed
  */
 public function actionBackup()
 {
     /*$model = new Peoples;
       
       if ($model->load(Yii::$app->request->post())) {
           return $this->redirect(['pprintfind', 'streetId' => $model->streetId]);
       } else {
           return $this->render('pprint', [
               'model' => $model,
           ]);
       }*/
     $file = fopen("c://backup.sql", "x+");
     $text = "\n-- phpMyAdmin SQL Dump\n-- version 4.0.10.10\n-- http://www.phpmyadmin.net\n--\n-- Хост: 127.0.0.1:3306\n-- Время создания: Мар 07 2016 г., 19:18\n-- Версия сервера: 5.5.45\n-- Версия PHP: 5.4.44\n\nSET SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO';\nSET time_zone = '+00:00';\n\n\n/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;\n/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;\n/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;\n/*!40101 SET NAMES utf8 */;\n\n--\n-- База данных: `medSys`\n--\n\n-- --------------------------------------------------------\n\n--\n-- Структура таблицы `chronicDiseases`\n--\n\nCREATE TABLE IF NOT EXISTS `chronicDiseases` (\n  `chronicDiseasesId` int(5) NOT NULL AUTO_INCREMENT,\n  `chronicDiseasesName` varchar(255) NOT NULL,\n  PRIMARY KEY (`chronicDiseasesId`)\n) ENGINE=InnoDB  DEFAULT CHARSET=utf8;\n\n--\n-- Дамп данных таблицы `chronicDiseases`\n--\nINSERT INTO `chronicDiseases` (`chronicDiseasesId`, `chronicDiseasesName`) VALUES\n";
     $chronicDiseases = chronicDiseases::find()->all();
     foreach ($chronicDiseases as $key => $cd) {
         if ($key + 1 == count($chronicDiseases)) {
             $text .= "(" . $cd['chronicDiseasesId'] . ", '" . $cd['chronicDiseasesName'] . "');\n";
         } else {
             $text .= "(" . $cd['chronicDiseasesId'] . ", '" . $cd['chronicDiseasesName'] . "'),\n";
         }
     }
     $text .= "\n-- --------------------------------------------------------\n\n--\n-- Структура таблицы `chronicDiseasesPeoples`\n--\n\nCREATE TABLE IF NOT EXISTS `chronicDiseasesPeoples` (\n  `chronicDiseasesId` int(5) NOT NULL,\n  `peopleId` int(5) NOT NULL,\n  KEY `chronicDiseasesId` (`chronicDiseasesId`),\n  KEY `peopleId` (`peopleId`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\n--\n-- Дамп данных таблицы `chronicDiseasesPeoples`\n--\n\nINSERT INTO `chronicDiseasesPeoples` (`chronicDiseasesId`, `peopleId`) VALUES";
     $chronicDiseasesPeople = chronicDiseasesPeoples::find()->all();
     foreach ($chronicDiseasesPeople as $key => $cd) {
         if ($key + 1 == count($chronicDiseasesPeople)) {
             $text .= "(" . $cd['chronicDiseasesId'] . ", " . $cd['peopleId'] . ");\n";
         } else {
             $text .= "(" . $cd['chronicDiseasesId'] . ", " . $cd['peopleId'] . "),\n";
         }
     }
     $text .= "\n-- --------------------------------------------------------\n\n--\n-- Структура таблицы `grafts`\n--\n\nCREATE TABLE IF NOT EXISTS `grafts` (\n  `graftId` int(5) NOT NULL AUTO_INCREMENT,\n  `graftName` varchar(255) NOT NULL,\n  PRIMARY KEY (`graftId`)\n) ENGINE=InnoDB  DEFAULT CHARSET=utf8;\n\n--\n-- Дамп данных таблицы `grafts`\n--\n\nINSERT INTO `grafts` (`graftId`, `graftName`) VALUES";
     $grafts = grafts::find()->all();
     foreach ($grafts as $key => $cd) {
         if ($key + 1 == count($grafts)) {
             $text .= "(" . $cd['graftId'] . ", '" . $cd['graftName'] . "');\n";
         } else {
             $text .= "(" . $cd['graftId'] . ", '" . $cd['graftName'] . "'),\n";
         }
     }
     $text .= "\n-- --------------------------------------------------------\n\n--\n-- Структура таблицы `graftsPeoples`\n--\n\nCREATE TABLE IF NOT EXISTS `graftsPeoples` (\n  `graftId` int(5) NOT NULL,\n  `peopleId` int(5) NOT NULL,\n  KEY `graftId` (`graftId`),\n  KEY `peopleId` (`peopleId`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\n\n--\n-- Дамп данных таблицы `graftsPeoples`\n--\n\nINSERT INTO `graftsPeoples` (`graftId`, `peopleId`) VALUES";
     $graftsP = graftsPeoples::find()->all();
     foreach ($graftsP as $key => $cd) {
         if ($key + 1 == count($graftsP)) {
             $text .= "(" . $cd['graftId'] . ", " . $cd['peopleId'] . ");\n";
         } else {
             $text .= "(" . $cd['graftId'] . ", " . $cd['peopleId'] . "),\n";
         }
     }
     $text .= "\n-- --------------------------------------------------------\n\n--\n-- Структура таблицы `peoples`\n--\n\nCREATE TABLE IF NOT EXISTS `peoples` (\n  `peopleId` int(5) NOT NULL AUTO_INCREMENT,\n  `peopleFIO` varchar(255) NOT NULL,\n  `peopleBirthday` date NOT NULL,\n  `peopleWorking` int(5) NOT NULL,\n  `peopleFluNumber` varchar(255) NOT NULL,\n  `peopleFluDate` date NOT NULL,\n  `peopleFluResult` int(1) NOT NULL,\n  `peopleFluTerm` int(2) NOT NULL,\n  `peopleStreet` int(5) NOT NULL,\n  `peopleAdress` varchar(255) NOT NULL,\n  PRIMARY KEY (`peopleId`),\n  KEY `peopleWorking` (`peopleWorking`),\n  KEY `peopleFlu` (`peopleFluNumber`),\n  KEY `peopleStreet` (`peopleStreet`)\n) ENGINE=InnoDB  DEFAULT CHARSET=utf8;\n\n--\n-- Дамп данных таблицы `peoples`\n--\n\nINSERT INTO `peoples` (`peopleId`, `peopleFIO`, `peopleBirthday`, `peopleWorking`, `peopleFluNumber`, `peopleFluDate`, `peopleFluResult`, `peopleFluTerm`, `peopleStreet`, `peopleAdress`) VALUES";
     $peoples = peoples::find()->all();
     foreach ($peoples as $key => $cd) {
         if ($key + 1 == count($peoples)) {
             $text .= "(" . $cd['peopleId'] . ", '" . $cd['peopleFIO'] . "', '" . $cd['peopleBirthday'] . "', " . $cd['peopleWorking'] . ", '" . $cd['peopleFluNumber'] . "', '" . $cd['peopleFluDate'] . "', " . $cd['peopleFluResult'] . ", " . $cd['peopleFluTerm'] . ", " . $cd['peopleStreet'] . ", '" . $cd['peopleAdress'] . "');\n";
         } else {
             $text .= "(" . $cd['peopleId'] . ", '" . $cd['peopleFIO'] . "', '" . $cd['peopleBirthday'] . "', " . $cd['peopleWorking'] . ", '" . $cd['peopleFluNumber'] . "', '" . $cd['peopleFluDate'] . "', " . $cd['peopleFluResult'] . ", " . $cd['peopleFluTerm'] . ", " . $cd['peopleStreet'] . ", '" . $cd['peopleAdress'] . "'),\n";
         }
     }
     $text .= "\n-- --------------------------------------------------------\n\n--\n-- Структура таблицы `streets`\n--\n\nCREATE TABLE IF NOT EXISTS `streets` (\n  `streetId` int(2) NOT NULL AUTO_INCREMENT,\n  `streetName` varchar(255) NOT NULL,\n  PRIMARY KEY (`streetId`)\n) ENGINE=InnoDB  DEFAULT CHARSET=utf8;\n\n--\n-- Дамп данных таблицы `streets`\n--\n\nINSERT INTO `streets` (`streetId`, `streetName`) VALUES";
     $streets = streets::find()->all();
     foreach ($streets as $key => $cd) {
         if ($key + 1 == count($streets)) {
             $text .= "(" . $cd['streetId'] . ", '" . $cd['streetName'] . "');\n";
         } else {
             $text .= "(" . $cd['streetId'] . ", '" . $cd['streetName'] . "'),\n";
         }
     }
     $text .= "\n-- --------------------------------------------------------\n\n--\n-- Структура таблицы `working`\n--\n\nCREATE TABLE IF NOT EXISTS `working` (\n  `workingId` int(5) NOT NULL AUTO_INCREMENT,\n  `workingName` varchar(255) NOT NULL,\n  PRIMARY KEY (`workingId`)\n) ENGINE=InnoDB  DEFAULT CHARSET=utf8;\n\n--\n-- Дамп данных таблицы `working`\n--\n\nINSERT INTO `working` (`workingId`, `workingName`) VALUES";
     $working = working::find()->all();
     foreach ($working as $key => $cd) {
         if ($key + 1 == count($working)) {
             $text .= "(" . $cd['workingId'] . ", '" . $cd['workingName'] . "');\n";
         } else {
             $text .= "(" . $cd['workingId'] . ", '" . $cd['workingName'] . "'),\n";
         }
     }
     $text .= "\n--\n-- Ограничения внешнего ключа сохраненных таблиц\n--\n\n--\n-- Ограничения внешнего ключа таблицы `chronicDiseasesPeoples`\n--\nALTER TABLE `chronicDiseasesPeoples`\n  ADD CONSTRAINT `chd` FOREIGN KEY (`chronicDiseasesId`) REFERENCES `chronicDiseases` (`chronicDiseasesId`) ON UPDATE CASCADE,\n  ADD CONSTRAINT `chp` FOREIGN KEY (`peopleId`) REFERENCES `peoples` (`peopleId`) ON UPDATE CASCADE;\n\n--\n-- Ограничения внешнего ключа таблицы `graftsPeoples`\n--\nALTER TABLE `graftsPeoples`\n  ADD CONSTRAINT `gg` FOREIGN KEY (`graftId`) REFERENCES `grafts` (`graftId`) ON UPDATE CASCADE,\n  ADD CONSTRAINT `gp` FOREIGN KEY (`peopleId`) REFERENCES `peoples` (`peopleId`) ON UPDATE CASCADE;\n\n--\n-- Ограничения внешнего ключа таблицы `peoples`\n--\nALTER TABLE `peoples`\n  ADD CONSTRAINT `ws` FOREIGN KEY (`peopleStreet`) REFERENCES `streets` (`streetId`) ON UPDATE CASCADE,\n  ADD CONSTRAINT `www` FOREIGN KEY (`peopleWorking`) REFERENCES `working` (`workingId`) ON UPDATE CASCADE;\n\n/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;\n/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;\n/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;\n";
     fwrite($file, $text);
     fclose($file);
     echo "Базу даних збережено за адресою C://backup.sql<br>" . "<a href='http://medik/web/index.php'>Назад</a>";
 }