/**
* Creates a new Sales model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$sales = new Sales();
if ($sales->load(Yii::$app->request->post())) {
$sales->loadDefaultValues();
$sales->save();
if ($sales->save()) {
$entp = new EntpSales();
$entp->sales_id = $this->id;
$entp->entrepreneur_id = Yii::$app->user->id;
$entp->link('sales', $sales);
}
Yii::$app->session->setFlash('success', 'New Product Add');
$searchModel = new EntpSalesSearch();
$dataProvider = $searchModel->search(Yii::$app->request->queryParams);
return $this->render('index', ['searchModel' => $searchModel, 'dataProvider' => $dataProvider]);
} else {
return $this->render('create', ['model' => $sales]);
}
}
/**
* Creates data provider instance with search query applied
*
* @param array $params
*
* @return ActiveDataProvider
*/
public function search($params)
{
$id = Yii::$app->user->id;
$query = EntpSales::find();
$query->joinWith(['entrepreneur', 'sales'])->where('entp_sales.entrepreneur_user_id=' . $id);
$dataProvider = new ActiveDataProvider(['query' => $query]);
$dataProvider->sort->attributes['total'] = ['asc' => ['sales.total' => SORT_ASC], 'desc' => ['sales.total' => SORT_DESC]];
$dataProvider->sort->attributes['reason'] = ['asc' => ['sales.reason' => SORT_ASC], 'desc' => ['sales.reason' => SORT_DESC]];
$dataProvider->sort->attributes['created_at'] = ['asc' => ['sales.created_at' => SORT_ASC], 'desc' => ['sales.created_at' => SORT_DESC]];
$dataProvider->sort->attributes['updated_at'] = ['asc' => ['sales.updated_at' => SORT_ASC], 'desc' => ['sales.updated_at' => SORT_DESC]];
$this->load($params);
if (!$this->validate()) {
// uncomment the following line if you do not want to return any records when validation fails
// $query->where('0=1');
return $dataProvider;
}
$query->andFilterWhere(['entrepreneur_user_id' => $this->entrepreneur_user_id, 'sales_id' => $this->sales_id]);
$query->andFilterWhere(['like', 'sales.total', $this->total])->andFilterWhere(['like', 'sales.reason', $this->reason])->andFilterWhere(['like', 'sales.created_at', $this->created_at])->andFilterWhere(['like', 'sales.updated_at', $this->updated_at]);
return $dataProvider;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getEntpSales()
{
return $this->hasMany(EntpSales::className(), ['entrepreneur_id' => 'id']);
}
/**
* Finds the EntpSales model based on its primary key value.
* If the model is not found, a 404 HTTP exception will be thrown.
* @param integer $entrepreneur_id
* @param integer $sales_id
* @return EntpSales the loaded model
* @throws NotFoundHttpException if the model cannot be found
*/
protected function findModel($entrepreneur_user_id, $sales_id)
{
if (($model = EntpSales::findOne(['entrepreneur_user_id' => $entrepreneur_user_id, 'sales_id' => $sales_id])) !== null) {
return $model;
} else {
throw new NotFoundHttpException('The requested page does not exist.');
}
}
