I just found a problem with my project. It's simply not saving data in database.
I couldn't find where is the problem, so please help to solve this problem.
my controller codes
public function actionCreate()
{
$model = new Ideyalar;
// $this->performAjaxValidation($model);
if(isset($_POST['Ideyalar']))
{
$model->attributes=$_POST['Ideyalar'];
$model->istifade = "1";
$model->idcontact = Yii::app()->user->getId();
if($model->save()){
$command = Yii::app()->db->createCommand();
$command->insert ('mqrup', array(
'idperson'=> Yii::app()->user->getId(),
'idideya'=>$model->idideya)
);
$command->update ('ideyalar',
['status'=>1],
'idideya=:i', [':i'=>$model->idideya]
);
$this->redirect(array('viewm','id'=>$model->idideya));
}
}
$this->render('create',array('model'=>$model));
}
public function actionViewm ($id)
{
$model1 = Ekspertiza::model()->idresult;
$sql = Yii::app()->db->createCommand()
->select ('e.idideya, urey, azerreal, elmireal, resrent')
->from ('exresult e')
->join ('ideyalar i', 'e.idideya=i.idideya')
->where ('e.idideya=:ei', [':ei'=>$id])
->queryAll();
$dataProvider = new CArrayDataProvider($seqele, [
'keyField'=>'idideya',
'sort'=> [
'attributes' => [
'idideya', 'urey', 'azerreal', 'elmireal', 'resrent'
],
],
]);
$this->render('viewm',['model'=>$this->loadModel($id), 'model1'=>$model1, 'dataProvider' => $dataProvider]);
}
create.php (view file)
<br><br>
<h4 style="margin-left:4%;">Yeni ideya</h4>
<div id="ger">
<?php
$form=$this->beginWidget('CActiveForm', array(
'id'=>'ideyalar-form',
));
?>
<p class="note-1"><em><span class="required">*</span> qeyd olunmuş sahələr mütləq doldurulmalıdır.</em></p><br>
<span id="ideya-yerror"><?php echo $form->errorSummary($model); ?></span>
<br>
<div class="ideya-div">
<?php echo $form->labelEx($model,'iddil'); ?>
</div>
<br>
<div class="ideya-div-1">
<?php echo $form->dropDownList($model, 'iddil',
CHtml::listData(Yii::app()->db->createCommand()
->select('iddil, dilad')
->from('diller')->queryAll() ,
'iddil', 'dilad'), array('options' => array($model->iddil =>array('selected'=>true)))); ?>
</div>
<br>
<div class="ideya-div"><?php echo $form->labelEx($model,'ideyaad'); ?></div><br>
<div class="ideya-div-1">
<?php echo $form->textField($model,'ideyaad',array('size'=>60,'maxlength'=>255)); ?>
</div>
<br>
<div class="ideya-div"><?php echo $form->labelEx($model,'idnettip'); ?></div><br>
<div class="ideya-div-1">
<?php echo $form->dropDownList($model, 'idnettip',
CHtml::listData(Yii::app()->db->createCommand()
->select('idnettip, nettip')
->from('nettip')->queryAll() ,
'idnettip', 'nettip'), array('options' => array($model->idnettip =>array('selected'=>true)))); ?>
</div>
<br>
<div class="ideya-div"><?php echo $form->labelEx($model,'mezmunu'); ?></div><br>
<div class="ideya-div-2">
<?php echo $form->textArea($model,'mezmunu',array('rows'=>6, 'cols'=>50)); ?>
</div>
<br>
<div class="ideya-div"><?php echo $form->labelEx($model,'xulase'); ?></div><br />
<div class="ideya-div-2">
<?php echo $form->textArea($model,'xulase'); ?>
</div>
<br>
<div class="ideya-div"><?php echo $form->labelEx($model,'patent'); ?></div><br>
<div class="ideya-div-1">
<?php echo $form->radioButtonList($model, 'patent',
array(1 => 'Var', 0=>'Yoxdur'), array('labelOptions'=>array('style'=>'display:inline'),
)); ?>
</div>
<br>
<div class="ideya-div"><?php echo $form->labelEx($model,'patentm'); ?></div><br>
<div class="ideya-div-2">
<?php echo $form->textArea($model,'patentm',array('rows'=>6, 'cols'=>50)); ?>
</div>
<br>
<div class="ideya-div"><?php echo $form->labelEx($model,'muddet'); ?></div><br>
<div class="ideya-div-1">
<?php echo $form->textField($model,'muddet'); ?>
</div>
<br>
<div class="ideya-div"><?php echo $form->labelEx($model,'vesait'); ?></div><br>
<div class="ideya-div-1">
<?php echo $form->textField($model,'vesait'); ?>
</div>
<br>
<div class="ideya-div"><?php echo $form->labelEx($model,'innova'); ?></div><br>
<div class="ideya-div-2">
<?php echo $form->textArea($model,'innova',array('rows'=>6, 'cols'=>50)); ?>
</div>
<br>
<div class="ideya-div"><?php echo $form->labelEx($model,'rivalry'); ?></div><br>
<div class="ideya-div-2">
<?php echo $form->textArea($model,'rivalry',array('rows'=>6, 'cols'=>50)); ?>
</div>
<br>
<div class="ideya-div"><?php echo $form->labelEx($model,'sosial'); ?></div><br>
<div class="ideya-div-2">
<?php echo $form->textArea($model,'sosial',array('rows'=>6, 'cols'=>50)); ?>
</div>
<br>
<div class="ideya-div"><?php echo $form->labelEx($model,'market'); ?></div><br>
<div class="ideya-div-2">
<?php echo $form->textArea($model,'market',array('rows'=>6, 'cols'=>50)); ?>
</div>
<br>
<div class="ideya-div"><?php echo $form->labelEx($model,'strategy'); ?></div><br>
<div class="ideya-div-2">
<?php echo $form->textArea($model,'strategy',array('rows'=>6, 'cols'=>50)); ?>
</div>
<br>
<div class="ideya-div">
<?php echo $form->labelEx($model,'niye'); ?>
</div><br>
<div class="ideya-div-2">
<?php echo $form->textArea($model,'niye',array('rows'=>6, 'cols'=>50)); ?>
<?php echo $form->error($model,'niye'); ?>
</div>
<br>
<div class="ideya-div-2">
<?php if($reference=="update")
{ ?>
<div class="ideya-div"><?php echo $form->labelEx($model,'texniki'); ?></div><br>
<div class="ideya-div-2">
<?php echo $form->textArea($model,'texniki',array('rows'=>6, 'cols'=>50, 'readonly' => true )); ?>
<?php echo $form->error($model,'texniki'); ?>
</div><br>
<div class="ideya-div"><?php echo $form->labelEx($model,'textarix'); ?></div><br>
<div class="ideya-div-1">
<?php echo $form->dateField($model,'textarix', array('readonly' => true ) ); ?>
<?php echo $form->error($model,'textarix'); ?>
</div><br>
<?php
}
?>
<div class="orta">
<input type="button" class="btn btn-danger" value="İmtina et" onclick="javascript:window.history.go(-1);return false;" />
<?php echo CHtml::submitButton($model->isNewRecord ? 'İdeyanı yarat' : 'Məlumatları yenilə', ['class'=>'btn btn-success']); ?>
</div>
<?php $this->endWidget(); ?>
</div>
viewm.php (another view file)
<?php $baseUrl=Yii::app()->request->baseUrl; ?>
<b><span id="comma"><h5>İdeya haqqında məlumatlar</h5></span></b><br /><br />
<div id="frame-l">
<?php
$this->widget('yiiwheels.widgets.detail.WhDetailView', array(
'data'=>$model,
'attributes'=>array(
'iddil'=> array(
'label' => $model->getAttributeLabel('iddil') ,
'type'=>'raw',
'value' => Yii::app()->db->createCommand()
->select('dilad')
->from('diller')->where('iddil = '.$model->iddil)->queryScalar()
),
'ideyaad',
'idnettip'=> array(
'label' => $model->getAttributeLabel('idnettip') ,
'type'=>'raw',
'value' => Yii::app()->db->createCommand()
->select('nettip')
->from('nettip')->where('idnettip = '.$model->idnettip)->queryScalar()
),
'mezmunu',
'patent'=>array(
'label' =>$model->getAttributeLabel('patent'),
'value'=> $model->idnettip == 0 ?"Yox":"Var",
),
'patentm',
'muddet',
'vesait',
'tarix',
'innova',
'rivalry',
'sosial',
'market',
'strategy',
'niye',
),
));
?>
</div>
<br><br><br><br>
<b><span id="comma"><h5>Ekspertiza qiymətləri</h5></span></b>
<div id="frame-r">
<?php
$this->widget('yiiwheels.widgets.grid.WhGridView', [
'id'=>'ideyalar-grid',
'dataProvider'=> $dataProvider ,
'ajaxUpdate'=>true,
'responsiveTable'=>true,
'fixedHeader'=>true,
'headerOffset'=>40,
'type'=>'striped bordered',
'columns'=>[
[
'name'=>'elmireal',
'header'=>'Elmi reallıq'
],
[
'name'=>'azerreal',
'header'=>'Lokal şəraitə uyğunluq'
],
[
'name'=>'resrent',
'header'=>'Rentabellilik'
],
[
'class'=>'bootstrap.widgets.TbButtonColumn',
'template'=>'{view}',
'viewButtonUrl'=>'Yii::app()->createUrl("/ideyalar/reyler", array("id"=>$data["idideya"]))',
'viewButtonOptions'=>['target'=>'_blank'],
'header'=>'Əməliyyatlar',
'headerHtmlOptions'=>[
'width'=>10,
'style'=>'color: white'
],
],
]
]);
?>
<input type="button" class="btn btn-info" value="Şəxsi səhifə" onclick="javascript:window.history.go(-2);return false;" />
</div>
Ideyalar.php (model)
<?php
/**
* This is the model class for table "ideyalar".
*
* The followings are the available columns in table 'ideyalar':
* @property integer $idideya
* @property integer $iddil
* @property string $ideyaad
* @property integer $idnettip
* @property string $mezmunu
* @property string $xulase
* @property string $patent
* @property string $patentm
* @property integer $muddet
* @property double $vesait
* @property string $tarix
* @property string $innova
* @property string $rivalry
* @property string $sosial
* @property string $market
* @property string $strategy
* @property string $niye
* @property string $istifade
* @property string $status
* @property integer $idtex
* @property string $texniki
* @property string $textarix
* @property integer $idishchi
* @property integer $view_count
* @property integer $idcontact
*/
class Ideyalar extends CActiveRecord
{
public function tableName()
{
return 'ideyalar';
}
public function rules()
{
return array(
array('iddil, ideyaad', 'required'),
array('iddil, idnettip, muddet, idtex, idishchi, view_count, idcontact', 'numerical', 'integerOnly'=>true, 'min'=>0),
array('vesait', 'numerical'),
array('ideyaad', 'length', 'max'=>255),
array('xulase', 'length', 'max'=>NULL),
array('patent, istifade, status', 'length', 'max'=>1),
array('ideyaad', 'unique'),
);
}
public function relations()
{
return array(
);
}
public function attributeLabels()
{
return array(
'iddil' => 'İdeyanın təqdim olunduğu dil',
'ideyaad' => 'İdeya adı',
'idnettip' => 'Gözlənilən nəticənin tipi',
'mezmunu' => 'İdeyanın məzmunu',
'patent' => 'İdeya üzrə patentlər yaxud ixtira şəhadətnamələri varmı?',
'patentm' => 'Əgər ideya üzrə patentlər yaxud ixtira şəhadətnamələri varsa, onlar haqqında məlumat',
'muddet' => 'Müddət (aylarla)',
'xulase' => 'İdeyanın xülasəsi',
'vesait' => 'Tələb olunan ümumi vəsait (min manatla)',
'tarix' => 'Daxil edilmə tarix',
'innova' => 'İdeyanın yeniliyi nədən ibarətdir?',
'rivalry' => 'Rəqabətliliyi (üstünlüyü)',
'sosial' => 'Sosial əhəmiyyəti',
'market' => 'Hansı bazar üçün nəzərdə tutulur?',
'strategy' => 'Marketinq strategiyası',
'niye' => 'Niyə məhz bu kollektiv təklif olunan ideyanı həyata keçirməlidir?',
'idtex' => 'Texniki ekspertizanın gedişi',
'texniki' => 'Texniki ekspertiza rəyi',
'textarix' => 'Textarix',
'view_count' => 'Baxılma sayı',
'idcontact' => 'Əlaqələndirici şəxs',
);
}
public function search()
{
$criteria=new CDbCriteria;
$criteria->compare('idideya',$this->idideya);
$criteria->compare('iddil',$this->iddil);
$criteria->compare('ideyaad',$this->ideyaad,true);
$criteria->compare('idnettip',$this->idnettip);
$criteria->compare('mezmunu',$this->mezmunu);
$criteria->compare('xulase',$this->xulase,true);
$criteria->compare('patent',$this->patent,true);
$criteria->compare('patentm',$this->patentm,true);
$criteria->compare('muddet',$this->muddet);
$criteria->compare('vesait',$this->vesait);
$criteria->compare('tarix',$this->tarix,true);
$criteria->compare('innova',$this->innova,true);
$criteria->compare('rivalry',$this->rivalry,true);
$criteria->compare('sosial',$this->sosial,true);
$criteria->compare('market',$this->market,true);
$criteria->compare('strategy',$this->strategy,true);
$criteria->compare('niye',$this->niye,true);
$criteria->compare('istifade',$this->istifade,true);
$criteria->compare('status',$this->status,true);
$criteria->compare('idtex',$this->idtex);
$criteria->compare('texniki',$this->texniki,true);
$criteria->compare('textarix',$this->textarix,true);
$criteria->compare('idishchi',$this->idishchi);
$criteria->compare('view_count',$this->view_count);
$criteria->compare('idcontact',$this->idcontact);
return new CActiveDataProvider($this, array(
'criteria'=>$criteria,
));
}
public static function model($className=__CLASS__)
{
return parent::model($className);
}
}
These codes must insert data to 2 tables: mqrup and ideyalar, and also updates a column in table ideyalar (which named as status).
With inserting data to mqrup and updating column status I have no problem...
But some of the information of the isn't inserted to ideyalar table.
When the user creates the new idea the following columns should update:
iddil, ideyaad, idnettip, xulase, muddet, vesait, istifade, status
with these columns I don't have any problem. All data'll insert correctly.
But only
mezmunu, patent, patentm, innova, rivalry, sosial, market, strategy, niye
columns are not 'effected'.
I couldn't find where is the problem (with codes and/or program algorithm).
If you know the solution, please help me.
I think I can explain what's my problem and what I actually need... If I couldn't explain, sorry for bad English.
P.S: when I update the existing idea, I again and again fill problematic fields, it's again and again not inserts data to db.
Thanks and best regards.
