/**
* create record with default values
* @param type $fiit_id
* @return boolean
* @throws CHttpException
*/
public function addRecord($fiit_id)
{
$fiit = FiitInvoiceItem::model()->findByPk($fiit_id);
if (!$fiit) {
throw new CHttpException(400, 'Invalid fiit_id value: ' . $fiit_id);
}
//calculate amt
$sql = " \n SELECT \n SUM(fixr_amt) as amt_sum \n FROM \n fixr_fiit_x_ref \n WHERE \n fixr_fiit_id = " . $fiit_id;
$fixr_sum = Yii::app()->db->createCommand($sql)->queryScalar();
//create fixr record
$model = new FixrFiitXRef();
$model->fixr_fiit_id = $fiit_id;
$model->fixr_fcrn_date = $fiit->fiitFinv->finv_date;
$model->fixr_fcrn_id = $fiit->fiitFinv->finv_fcrn_id;
$model->fixr_base_fcrn_id = $fiit->fiitFinv->finv_basic_fcrn_id;
$model->fixr_amt = $fiit->fiit_amt - $fixr_sum;
//save
try {
if ($model->save()) {
return TRUE;
} else {
throw new CHttpException(500, var_export($model->getErrors()));
}
} catch (Exception $e) {
throw new CHttpException(500, $e->getMessage());
}
}
');
}
if (!$ajax || $ajax == 'fixr-fiit-xref-grid') {
Yii::beginProfile('fixr_fret_id.view.grid');
?>
<h3 class="rel_grid">
<?php
echo Yii::t('D2finvModule.model', 'Fixr Fiit Xref');
?>
<?php
$this->widget('bootstrap.widgets.TbButton', array('buttonType' => 'ajaxButton', 'type' => 'primary', 'size' => 'mini', 'icon' => 'icon-plus', 'url' => array('//d2finv/fixrFiitXRef/ajaxCreate', 'field' => 'fixr_fret_id', 'value' => $modelMain->primaryKey, 'ajax' => 'fixr-fiit-xref-grid'), 'ajaxOptions' => array('success' => 'function(html) {$.fn.yiiGridView.update(\'fixr-fiit-xref-grid\');}'), 'htmlOptions' => array('title' => Yii::t('D2finvModule.crud', 'Add new record'), 'data-toggle' => 'tooltip')));
?>
</h3>
<?php
if (empty($modelMain->fixrFiitXRefs)) {
$model = new FixrFiitXRef();
$model->fixr_fret_id = $modelMain->primaryKey;
$model->save();
unset($model);
}
$model = new FixrFiitXRef();
$model->fixr_fret_id = $modelMain->primaryKey;
// render grid view
$this->widget('TbGridView', array('id' => 'fixr-fiit-xref-grid', 'dataProvider' => $model->search(), 'template' => '{summary}{items}', 'summaryText' => ' ', 'htmlOptions' => array('class' => 'rel-grid-view'), 'columns' => array(array('class' => 'editable.EditableColumn', 'name' => 'fixr_fiit_id', 'editable' => array('type' => 'select', 'url' => $this->createUrl('//d2finv/fixrFiitXRef/editableSaver'), 'source' => CHtml::listData(FiitInvoiceItem::model()->findAll(array('limit' => 1000)), 'fiit_id', 'itemLabel'))), array('class' => 'editable.EditableColumn', 'name' => 'fixr_ref_id', 'editable' => array('url' => $this->createUrl('//d2finv/fixrFiitXRef/editableSaver'))), array('class' => 'editable.EditableColumn', 'name' => 'fuxr_fcrn_date', 'editable' => array('type' => 'date', 'url' => $this->createUrl('//d2finv/fixrFiitXRef/editableSaver'))), array('class' => 'editable.EditableColumn', 'name' => 'fuxr_fcrn_id', 'editable' => array('type' => 'select', 'url' => $this->createUrl('//d2finv/fixrFiitXRef/editableSaver'), 'source' => CHtml::listData(FcrnCurrency::model()->findAll(array('limit' => 1000)), 'fcrn_id', 'itemLabel'))), array('class' => 'editable.EditableColumn', 'name' => 'fuxr_amt', 'editable' => array('url' => $this->createUrl('//d2finv/fixrFiitXRef/editableSaver'))), array('class' => 'editable.EditableColumn', 'name' => 'fuxr_base_fcrn_id', 'editable' => array('type' => 'select', 'url' => $this->createUrl('//d2finv/fixrFiitXRef/editableSaver'), 'source' => CHtml::listData(FcrnCurrency::model()->findAll(array('limit' => 1000)), 'fcrn_id', 'itemLabel'))), array('class' => 'editable.EditableColumn', 'name' => 'fixr_base_amt', 'editable' => array('url' => $this->createUrl('//d2finv/fixrFiitXRef/editableSaver'))), array('class' => 'editable.EditableColumn', 'name' => 'fixr_start_date', 'editable' => array('type' => 'date', 'url' => $this->createUrl('//d2finv/fixrFiitXRef/editableSaver'))), array('class' => 'TbButtonColumn', 'buttons' => array('view' => array('visible' => 'FALSE'), 'update' => array('visible' => 'FALSE'), 'delete' => array('visible' => 'Yii::app()->user->checkAccess("D2finv.FretRefType.DeletefixrFiitXRefs")')), 'deleteButtonUrl' => 'Yii::app()->controller->createUrl("/d2finv/fixrFiitXRef/delete", array("fixr_id" => $data->fixr_id))', 'deleteButtonOptions' => array('data-toggle' => 'tooltip')))));
?>
<?php
Yii::endProfile('FixrFiitXRef.view.grid');
}
