public function actionModerPhotoFix()
{
$this->layout = '//layouts/header_default';
$model = new Holes('search');
$model->unsetAttributes();
// clear any default values
$model->PREMODERATED = 1;
if (isset($_POST['Holes']) || isset($_GET['Holes'])) {
$model->attributes = isset($_POST['Holes']) ? $_POST['Holes'] : $_GET['Holes'];
}
if ($model->ADR_CITY == "Город") {
$model->ADR_CITY = '';
}
$dataProvider = $model->search(true);
$this->render('index', array('model' => $model, 'dataProvider' => $dataProvider));
}
/**
* Lists all models.
*/
public function actionIndex()
{
$this->layout = '//layouts/header_default';
//Если нет таблиц в базе редиректим на контроллер миграции
if (Holes::getDbConnection()->getSchema()->getTable(Holes::tableName()) === null) {
$this->redirect(array('migration/index'));
}
$model = new Holes('search');
$model->unsetAttributes();
// clear any default values
$model->PREMODERATED = 1;
if (isset($_POST['Holes']) || isset($_GET['Holes'])) {
$model->attributes = isset($_POST['Holes']) ? $_POST['Holes'] : $_GET['Holes'];
}
if ($model->ADR_CITY == "Город") {
$model->ADR_CITY = '';
}
$dataProvider = $model->search();
$this->render('index', array('model' => $model, 'dataProvider' => $dataProvider));
}
/**
* Lists all models.
*/
public function actionIndex()
{
$this->pageTitle = Yii::t('titles', 'HOLES_INDEX');
$this->layout = '//layouts/header_default';
$model = new Holes('search');
$model->unsetAttributes();
// clear any default values
$model->PREMODERATED = 1;
if (isset($_POST['Holes']) || isset($_GET['Holes'])) {
$model->attributes = Yii::app()->request->getParam('Holes');
}
$dataProvider = $model->search();
$this->render('index', array('model' => $model, 'dataProvider' => $dataProvider));
}
public function actionIndex($id = null, $user = null)
{
$model = new Holes('search');
$model->unsetAttributes();
// clear any default values
$model->limit = Yii::app()->request->getParam('limit');
$model->PREMODERATED = 1;
if ($user) {
$model->unsetAttributes(array('PREMODERATED'));
$model->USER_ID = $user->id;
}
if ($id) {
$model->ID = (int) $id;
}
if (Yii::app()->request->getParam('filter_rf_subject_id')) {
$model->ADR_SUBJECTRF = (int) Yii::app()->request->getParam('filter_rf_subject_id');
}
if (Yii::app()->request->getParam('filter_city')) {
$model->ADR_CITY = Yii::app()->request->getParam('filter_city');
}
if (Yii::app()->request->getParam('filter_status')) {
$model->STATE = Yii::app()->request->getParam('filter_status');
}
if (Yii::app()->request->getParam('filter_type')) {
$model->type_alias = Yii::app()->request->getParam('filter_type');
}
if (Yii::app()->request->getParam('archive')) {
$model->archive = Yii::app()->request->getParam('archive');
}
$model->polygons = Yii::app()->request->getParam('polygons') ? Yii::app()->request->getParam('polygons') : array();
$page = Yii::app()->request->getParam('page');
if (!$model->limit) {
$model->limit = 30;
}
$offset = Yii::app()->request->getParam('offset');
if (!$offset) {
$offset = 0;
}
$data = $model->search();
if (!$page) {
$data->pagination->currentPage = (int) ($offset / $model->limit);
} else {
$data->pagination->currentPage = $page;
}
$tags = array();
if (!$model->ID) {
$tags[] = CHtml::tag('sort', array(), false, false);
$tags[] = CHtml::tag('item', array('code' => $data->sort->orderBy), CHtml::encode($data->sort->descTag), true);
$tags[] = CHtml::closeTag('sort');
$tags[] = CHtml::tag('filter', array(), false, false);
$tags[] = CHtml::tag('item', array('code' => 'PREMODERATED'), CHtml::encode($model->PREMODERATED), true);
$tags[] = CHtml::tag('item', array('code' => 'archive'), CHtml::encode($model->archive), true);
$tags[] = CHtml::tag('item', array('code' => 'filter_rf_subject_id'), CHtml::encode($model->ADR_SUBJECTRF), true);
$tags[] = CHtml::tag('item', array('code' => 'filter_city'), CHtml::encode($model->ADR_CITY), true);
$tags[] = CHtml::tag('item', array('code' => 'filter_status'), CHtml::encode($model->STATE), true);
$tags[] = CHtml::tag('item', array('code' => 'filter_type'), CHtml::encode($model->type_alias), true);
$tags[] = CHtml::closeTag('filter');
$tags[] = CHtml::tag('navigation', array(), false, false);
$tags[] = CHtml::tag('item', array('code' => 'limit'), CHtml::encode($model->limit), true);
$tags[] = CHtml::tag('item', array('code' => 'offset'), CHtml::encode($offset / $model->limit), true);
$tags[] = CHtml::tag('item', array('code' => 'totalItemCount'), CHtml::encode($data->totalItemCount), true);
$tags[] = CHtml::closeTag('navigation');
}
$tags[] = CHtml::tag('defectslist', array(), false, false);
foreach ($data->data as $hole) {
$tags[] = CHtml::tag('hole', array('id' => $hole->ID), false, false);
$tags[] = CHtml::tag('id', array(), CHtml::encode($hole->ID), true);
$tags[] = CHtml::tag('archive', array(), CHtml::encode($hole->archive), true);
$tags[] = CHtml::tag('username', array('full' => $hole->user->Fullname, 'user_id' => $hole->user->id), false, false);
$tags[] = CHtml::tag('name', array(), CHtml::encode($hole->user->name), true);
$tags[] = CHtml::tag('secondname', array(), CHtml::encode($hole->user->second_name), true);
$tags[] = CHtml::tag('lastname', array(), CHtml::encode($hole->user->last_name), true);
$tags[] = CHtml::closeTag('username');
$tags[] = CHtml::tag('latitude', array(), CHtml::encode($hole->LATITUDE), true);
$tags[] = CHtml::tag('longitude', array(), CHtml::encode($hole->LONGITUDE), true);
$tags[] = CHtml::tag('address', array('city' => $hole->ADR_CITY, 'subjectrf' => $hole->ADR_SUBJECTRF), CHtml::encode(($hole->subject ? $hole->subject->name_full . ', ' : '') . $hole->ADR_CITY . ', ' . $hole->ADDRESS), true);
$tags[] = CHtml::tag('state', array('code' => $hole->STATE), CHtml::encode($hole->StateName), true);
$tags[] = CHtml::tag('type', array('code' => $hole->type->alias), CHtml::encode($hole->type->name), true);
$tags[] = CHtml::tag('datecreated', array('readable' => date('d.m.Y', $hole->DATE_CREATED)), CHtml::encode($hole->DATE_CREATED), true);
$tags[] = CHtml::tag('datesent', array('readable' => $hole->DATE_SENT ? date('d.m.Y', $hole->DATE_SENT) : ''), CHtml::encode($hole->DATE_SENT), true);
$tags[] = CHtml::tag('datestatus', array('readable' => $hole->DATE_STATUS ? date('d.m.Y', $hole->DATE_STATUS) : ''), CHtml::encode($hole->DATE_STATUS), true);
$tags[] = CHtml::tag('commentfresh', array(), CHtml::encode($hole->COMMENT1), true);
$tags[] = CHtml::tag('commentfixed', array(), CHtml::encode($hole->COMMENT2), true);
$commentgibddre = '';
if ($hole->STATE != 'fresh' && $hole->STATE != 'inprogress' && $hole->STATE != 'achtung' && $hole->requests_with_answer_comment) {
$commentgibddre = $hole->requests_with_answer_comment[0]->answers[0]->comment;
}
$tags[] = CHtml::tag('commentgibddre', array(), CHtml::encode($commentgibddre), true);
$tags[] = CHtml::tag('pictures', array(), false, false);
$tags[] = CHtml::tag('original', array(), false, false);
$tags[] = CHtml::tag('fresh', array(), false, false);
foreach ($hole->pictures_fresh as $pict) {
$tags[] = CHtml::tag('src', array('id' => $pict->id), CHtml::encode($pict->original), true);
}
$tags[] = CHtml::closeTag('fresh');
$tags[] = CHtml::tag('fixed', array(), false, false);
foreach ($hole->pictures_fixed as $pict) {
$tags[] = CHtml::tag('src', array('id' => $pict->id), CHtml::encode($pict->original), true);
}
$tags[] = CHtml::closeTag('fixed');
$tags[] = CHtml::tag('gibddreply', array(), false, false);
$tags[] = CHtml::closeTag('gibddreply');
$tags[] = CHtml::closeTag('original');
$tags[] = CHtml::tag('medium', array(), false, false);
$tags[] = CHtml::tag('fresh', array(), false, false);
foreach ($hole->pictures_fresh as $pict) {
$tags[] = CHtml::tag('src', array('id' => $pict->id), CHtml::encode($pict->medium), true);
}
$tags[] = CHtml::closeTag('fresh');
$tags[] = CHtml::tag('fixed', array(), false, false);
foreach ($hole->pictures_fixed as $pict) {
$tags[] = CHtml::tag('src', array('id' => $pict->id), CHtml::encode($pict->medium), true);
}
$tags[] = CHtml::closeTag('fixed');
$tags[] = CHtml::tag('gibddreply', array(), false, false);
foreach ($hole->requests_gibdd as $request) {
foreach ($request->answers as $answer) {
foreach ($answer->files_img as $pict) {
$tags[] = CHtml::tag('src', array('id' => $pict->id), CHtml::encode($answer->filesFolder . '/' . $pict->file_name), true);
}
}
}
$tags[] = CHtml::closeTag('gibddreply');
$tags[] = CHtml::closeTag('medium');
$tags[] = CHtml::tag('small', array(), false, false);
$tags[] = CHtml::tag('fresh', array(), false, false);
foreach ($hole->pictures_fresh as $pict) {
$tags[] = CHtml::tag('src', array('id' => $pict->id), CHtml::encode($pict->small), true);
}
$tags[] = CHtml::closeTag('fresh');
$tags[] = CHtml::tag('fixed', array(), false, false);
foreach ($hole->pictures_fixed as $pict) {
$tags[] = CHtml::tag('src', array('id' => $pict->id), CHtml::encode($pict->small), true);
}
$tags[] = CHtml::closeTag('fixed');
$tags[] = CHtml::tag('gibddreply', array(), false, false);
foreach ($hole->requests_gibdd as $request) {
foreach ($request->answers as $answer) {
foreach ($answer->files_img as $pict) {
$tags[] = CHtml::tag('src', array('id' => $pict->id), CHtml::encode($answer->filesFolder . '/thumbs/' . $pict->file_name), true);
}
}
}
$tags[] = CHtml::closeTag('gibddreply');
$tags[] = CHtml::closeTag('small');
$tags[] = CHtml::closeTag('pictures');
$tags[] = CHtml::tag('gibddrequests', array(), false, false);
foreach ($hole->requests_gibdd as $request) {
$tags[] = CHtml::tag('request', array('id' => $request->id, 'gibdd_id' => $request->gibdd_id, 'date' => $request->date_sent, 'user_id' => $request->user_id, 'user_name' => $request->user->Fullname), false, false);
foreach ($request->answers as $answer) {
$tags[] = CHtml::tag('answer', array('id' => $answer->id, 'date' => $answer->date), false, false);
$tags[] = CHtml::tag('files', array(), false, false);
foreach ($answer->files as $pict) {
$tags[] = CHtml::tag('file', array('id' => $pict->id, 'type' => $pict->file_type), CHtml::encode($answer->filesFolder . '/' . $pict->file_name), true);
}
$tags[] = CHtml::closeTag('files');
$tags[] = CHtml::closeTag('answer');
}
$tags[] = CHtml::closeTag('request');
}
$tags[] = CHtml::closeTag('gibddrequests');
$tags[] = CHtml::closeTag('hole');
}
$tags[] = CHtml::closeTag('defectslist');
if (!$data->data && $id) {
$this->error('NOT_FOUND');
}
$this->renderXml($tags);
}
