/** * @return \yii\db\ActiveQuery */ public function getProductPricelists() { return $this->hasMany(ProductPricelist::className(), ['currency_id' => 'id']); }
<div class="col-md-6"> <?php /*echo $form->field($model, 'tanggal_akhir')->label('End Date')*/ ?> </div> <div class="col-md-12"> <?php echo DatePicker::widget(['model' => $model, 'attribute' => 'tanggal_awal', 'attribute2' => 'tanggal_akhir', 'options' => ['placeholder' => 'Start date'], 'options2' => ['placeholder' => 'End date'], 'type' => DatePicker::TYPE_RANGE, 'form' => $form, 'pluginOptions' => ['format' => 'yyyy-MM-dd', 'autoclose' => true, 'startDate' => '01/07/2014'], 'convertFormat' => true]); ?> </div> <div class="col-md-12"> <?php echo $form->field($model, 'pricelist_id')->dropDownList(ArrayHelper::map(ProductPricelist::find()->where(['type' => 'sale', 'active' => true])->orderBy(['name' => 'ASC'])->all(), 'name', 'name'), ['prompt' => ''])->label('Currency'); ?> </div> <div class="col-md-12"> <?php /*$data = GroupSales::find() ->select(['name as value', 'name as label', 'id as id']) ->asArray() ->all(); echo $form->field($model, 'kelompok_id')->widget(\yii\jui\AutoComplete::classname(), [ 'clientOptions' => [ 'source' => $data, ], ])->textInput()->label('Group')*/
/** * @return \yii\db\ActiveQuery */ public function getPricelist() { return $this->hasOne(ProductPricelist::className(), ['id' => 'pricelist_id']); }
public function actionProductsales($groupBy = null) { $this->layout = 'dashboard'; $model = new ProductSaleReportForm(); $modelsales = new SaleOrder(); $modelsaleine = new SaleOrderLine(); // Data Category Product $category = ProductCategory::find()->all(); $datacetegory = ArrayHelper::map($category, 'id', 'name'); // Data Pricelist $pricelist = ProductPricelist::find()->where(['type' => 'sale'])->all(); $datapricelist = ArrayHelper::map($pricelist, 'id', 'name'); if ($model->load(Yii::$app->request->get())) { $query = $this->getSOLineRelatedQuery($model, $groupBy); } else { $query = $this->getSOLineRelatedQuery($model, $groupBy); $productcategory = null; $pricelist = null; } $dataProvider = new ActiveDataProvider(['query' => $query, 'key' => 'id', 'pagination' => ['pageSize' => 100]]); if ($groupBy) { return $this->render('productsales_form', ['model' => $model, 'type' => 'search', 'dataProvider' => $dataProvider, 'groupBy' => $groupBy, 'datacetegory' => $datacetegory, 'datapricelist' => $datapricelist]); } else { return $this->render('productsales_form', ['model' => $model, 'type' => 'search', 'dataProvider' => $dataProvider, 'groupBy' => 'nogroup', 'datacetegory' => $datacetegory, 'datapricelist' => $datapricelist]); } }