/**
* Get Company Info
*
* todo need to learn relational stat query worst method ever
*/
protected function loadModel(){
/**
* Load All Related Models Of Users
* having userId is logged in dealer user Id
*/
$query= Companies::find()->with([
'user' =>function($query){
$query->andWhere(['id' => Auction::$app->user->id]);
},
'auctions' => function($query){
$query->asArray();
},
'companyUsers' => function($query){
$query->asArray();
}
])->where([
'id' => Auction::$app->session->get('user.company')
]);
$model=$query->one();
if($model === null){
throw new HttpException(400, 'Not a Valid Company');
}
return $model;
}
/**
* Get Company Info
*/
protected function loadModel(){
/**
* Load All Related Models Of Users
* having userId is logged in dealer user Id
*/
$query= Companies::find()->joinWith([
'user' => function($query){
$query->where([
'users.id' => Auction::$app->user->id
]);
}
]);
$model=$query->one();
if($model === null){
throw new HttpException(400, 'Not a Valid Dealer');
}
return $model;
}
public function searchDealerCompany(){
/**
* DealerCompany::find()->joinWith([
'company0',
])->where([
'dealer_company.dealer' => Auction::$app->session->get('user.dealer'),
// 'dealer_company.is_active' => DatabaseHelper::ACTIVE
]);
*/
$query = Companies::find();
return new ActiveDataProvider([
'query' => $query,
]);
}
public function actionListCompanies($term){
$array = Companies::find()->select('id,name,logo_image as image')
->where(['like' , 'name' , $term])
->asArray()->all();
return Json::encode($array);
}
