/** * get or create record for table * @param int $fret_id - ref type (first dimension level) * @param int $ref_id - refernce table record id * @param string $code * @param string $name * @return type */ public static function getDim2Id($fret_id, $ref_id, $code, $name = false) { if (!$name) { $name = $code; } //search existing record $criteria = new CDbCriteria(); $criteria->compare('fdm2_sys_ccmp_id', Yii::app()->sysCompany->getActiveCompany()); $criteria->compare('fdm2_fret_id', $fret_id); $criteria->compare('fdm2_ref_id', $ref_id); if ($fdm2 = Fdm2Dimension2::model()->find($criteria)) { return $fdm2->fdm2_id; } $fret = FretRefType::model()->findByPk($fret_id); //add record $fdm2 = new Fdm2Dimension2(); $fdm2->fdm2_fret_id = $fret_id; $fdm2->fdm2_ref_id = $ref_id; $fdm2->fdm2_fdm1_id = $fret->fret_fdm1_id; $fdm2->fdm2_code = substr($code, 0, 10); $fdm2->fdm2_name = $name; $fdm2->save(); return $fdm2->primaryKey; }
public function beforeSave() { //get all data from dimension 2 $fdm2 = Fdm2Dimension2::model()->findByPk($this->fdm3_fdm2_id); if (empty($this->fdm3_sys_ccmp_id)) { $this->fdm3_sys_ccmp_id = Yii::app()->sysCompany->getActiveCompany(); } if (empty($this->fdm3_fret_id)) { $this->fdm3_fret_id = $fdm2->fdm2_fret_id; } if (empty($this->fdm3_fdm1_id)) { $this->fdm3_fdm1_id = $fdm2->fdm2_fdm1_id; } if (empty($this->fdm3_fdm2_id)) { $this->fdm3_fdm2_id = $fdm2->fdm2_id; } if (!parent::beforeSave()) { return false; } return true; }
public function loadModel($id) { $m = Fdm2Dimension2::model(); // apply scope, if available $scopes = $m->scopes(); if (isset($scopes[$this->scope])) { $m->{$this->scope}(); } $model = $m->findByPk($id); if ($model === null) { throw new CHttpException(404, Yii::t('D2fixrModule.crud', 'The requested page does not exist.')); } return $model; }
<div class='control-label'> <?php echo $form->labelEx($model, 'fdda_fdm2_id'); ?> </div> <div class='controls'> <span class="tooltip-wrapper" data-toggle='tooltip' data-placement="right" title='<?php echo ($t = Yii::t('D2fixrModule.model', 'tooltip.fdda_fdm3_id')) != 'tooltip.fdda_fdm3_id' ? $t : ''; ?> '> <?php //get select fret list $criteria = new CDbCriteria(); $criteria->compare('fdm2_fret_id', $fret_id); $fdm2_list = Fdm2Dimension2::model()->findAll($criteria); //create array for grouped listbox $list_data = array(); foreach ($fdm2_list as $fdm2) { $sublist = array(); foreach ($fdm2->fdm3Dimension3s as $fdm3) { $sublist[$fdm3->fdm3_id] = $fdm3->fdm3_name; } $list_data[$fdm2->fdm2_name] = $sublist; } echo $form->dropDownList($model, 'fdda_fdm3_id', $list_data, array('prompt' => Yii::t('D2fixrModule.model', 'Select position'))); echo $form->error($model, 'fdda_fdm3_id'); ?> </span> </div> </div>
<?php $this->renderPartial('levels_js'); $fdm1 = Fdm1Dimension1::model()->findByPk($fdm1_id); $fdm2 = Fdm2Dimension2::model()->findByPk($fdm2_id); $breadcrumbs[Yii::t('D2fixrModule.model', 'Home')] = array('level1', 'year' => $year); $breadcrumbs[$fdm1->itemLabel] = array('level2', 'year' => $year, 'fdm1_id' => $fdm1_id); $breadcrumbs[] = $fdm2->itemLabel; $this->widget("TbD2Breadcrumbs", array('links' => $breadcrumbs)); ?> <div class="table-header"> <?php echo Yii::t('D2fixrModule.model', 'Dimensions:') . ' '; echo $fdm1->itemLabel . ' > ' . $fdm2->itemLabel . ' / '; echo Yii::t('D2fixrModule.model', 'Year:'); $prev_year = $year - 1; $next_year = $year + 1; $this->widget('bootstrap.widgets.TbButton', array('buttonType' => 'link', 'type' => 'primary', 'size' => 'mini', 'icon' => 'icon-chevron-left', 'url' => array('level3', 'year' => $prev_year, 'fdm1_id' => $fdm1_id, 'fdm2_id' => $fdm2_id), 'htmlOptions' => array('title' => $prev_year, 'data-toggle' => 'tooltip', 'icon_class' => ''))); echo $year; $this->widget('bootstrap.widgets.TbButton', array('buttonType' => 'link', 'type' => 'primary', 'size' => 'mini', 'icon' => 'icon-chevron-right', 'url' => array('level3', 'year' => $next_year, 'fdm1_id' => $fdm1_id, 'fdm2_id' => $fdm2_id), 'htmlOptions' => array('title' => $next_year, 'data-toggle' => 'tooltip', 'icon_class' => ''))); ?> </div> <table class="items table table-striped table-bordered table-hover" id="dim_transactions"> <thead> <tr> <td></td> <?php foreach ($months as $m) {
public function actionAdmin($fdm2_id) { $model = new Fdm3Dimension3('search'); $scopes = $model->scopes(); if (isset($scopes[$this->scope])) { $model->{$this->scope}(); } $model->unsetAttributes(); if (isset($_GET['Fdm3Dimension3'])) { $model->attributes = $_GET['Fdm3Dimension3']; } $model->fdm3_fdm2_id = $fdm2_id; $fdm2 = Fdm2Dimension2::model()->findByPk($fdm2_id); $this->render('admin', array('model' => $model, 'fdm2' => $fdm2)); }
/** * get fdm2_id value and set it * @param int $ref_id fdm2_ref_id value * @param string $code * @param string $name */ public function setFdm2Id($ref_id, $code, $name = false) { if (empty($this->fdda_fret_id)) { exit('Before FddaDimData->setFdm2Id require set fdda_fret_id'); } $this->fdda_fdm2_id = Fdm2Dimension2::getDim2Id($this->fdda_fret_id, $ref_id, $code, $name); }
/** * level 1 month transactions * @param type $fdm1_id * @param type $year * @param type $month */ public function actionLevel2transactions($fdm2_id, $year, $month) { $fdpe_id = FdpeDimPeriod::getIdByYearMonth($year, $month); $data = FdpeDimPeriod::getDimMonthPositions($fdpe_id, false, $fdm2_id); $fdm2 = Fdm2Dimension2::model()->findByPk($fdm2_id); $this->renderPartial('transactions', array('year' => $year, 'month' => $month, 'label' => $fdm2->fdm2_name, 'data' => $data)); }