/**
* @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]);
}
}
