public function getRewardsByuId($uId)
{
$storeId = VendorRegister::find()->select(['vendor_unique_id'])->where(['uid' => Yii::$app->user->id]);
$userRewards = RewardsMain::find()->where(['storeId' => $storeId, 'uId' => $uId])->one();
return $userRewards;
}
public static function getStoreId($uId)
{
$storeId = VendorRegister::find()->select('vendor_unique_id')->where(['uid' => $uId])->one();
return $storeId['vendor_unique_id'];
}
public function getRewardsRequestsByStoreCustomerId($customerId)
{
$storeId = VendorRegister::find()->select(['vendor_unique_id'])->where(['uid' => Yii::$app->user->id])->one();
$query = new Query();
if (isset($_GET['request'])) {
if ($_GET['request'] == 1) {
$query->from('rewards_details')->where(['storeId' => $storeId->vendor_unique_id, 'rewardsFlag' => 'ADD', 'uId' => $customerId]);
}
if ($_GET['request'] == 2) {
$query->from('rewards_details')->where(['storeId' => $storeId->vendor_unique_id, 'rewardsFlag' => 'CONFIRMED', 'uId' => $customerId]);
}
if ($_GET['request'] == 3) {
$query->from('rewards_details')->where(['storeId' => $storeId->vendor_unique_id, 'rewardsFlag' => 'REEDEEMED', 'uId' => $customerId]);
}
if ($_GET['request'] == 4) {
$query->from('rewards_details')->where("(storeId = '{$storeId->vendor_unique_id}') AND ((rewardsFlag = 'ADD') OR (rewardsFlag = 'CONFIRMED')) AND uId= {$customerId}");
}
} else {
$query->from('rewards_details')->where(['storeId' => $storeId->vendor_unique_id, 'rewardsFlag' => 'ADD', 'uId' => $customerId]);
}
$dataProvider = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 25]]);
return $dataProvider;
}
public function actionVendorupdate()
{
//$this->layout = "@app/views/layouts/vendor";
$this->layout = "@app/views/layouts/vendor_left";
$model = new VendorRegister();
$userData = VendorRegister::find()->where(['uid' => Yii::$app->user->id])->one();
$userMain = UserMaster::find()->where(['id' => Yii::$app->user->id])->one();
$model->countriesList = Countries::getCountriesUS();
if ($userData['country'] == NULL) {
$model->country = 231;
} else {
$model->country = $userData['country'];
}
$model->statesData = Countries::getStatesByCountryDefault($model->country);
if ($userData['state'] == NULL) {
$model->state = 3975;
} else {
$model->state = $userData['state'];
}
if ($model->load(Yii::$app->request->post())) {
$model->uid = Yii::$app->user->id;
//$model->dob = 'NOW()';
$userExist = VendorRegister::find()->where(['uid' => Yii::$app->user->id])->one();
if ($userExist != NULL) {
//echo "00000000000000000";
$userExist->firstName = $model->firstName;
$userExist->lastName = $model->lastName;
$userExist->middleName = $model->middleName;
$userExist->mobile = $model->mobile;
$userExist->mobile2 = $model->mobile2;
$userExist->address2 = $model->address2;
$userExist->city = $model->city;
$userExist->state = $model->state;
$userExist->country = $model->country;
$userExist->zip = $model->zip;
$userExist->businessName2 = $model->businessName2;
$userExist->fax = $model->fax;
$userExist->modifiedDate = 'NOW()';
if ($userMain->roleId == 2) {
$userExist->storeName = $model->storeName;
$userExist->storeAddress = $model->storeAddress;
$model->storeImage = UploadedFile::getInstance($model, 'storeImage');
if ($model->storeImage != '') {
$imageName = rand(1000, 100000) . $model->storeImage->baseName;
$model->storeImage->saveAs(Yii::getAlias('@frontend') . '/web/uploads/storeimages/' . $imageName . '.' . $model->storeImage->extension);
$model->storeImage = 'uploads/storeimages/' . $imageName . '.' . $model->storeImage->extension;
$userExist->storeImage = $model->storeImage;
$model->storeImage;
}
}
$userExist->update();
//print_r($userExist);exit();
Yii::$app->getSession()->setFlash('success', 'You are successfully Updated Your Profile.');
return $this->redirect(['profile']);
} else {
$model->storeImage = UploadedFile::getInstance($model, 'storeImage');
if ($model->storeImage != '') {
$imageName = rand(1000, 100000) . $model->storeImage->baseName;
$model->storeImage->saveAs(Yii::getAlias('@frontend') . '/web/uploads/storeimages/' . $imageName . '.' . $model->storeImage->extension);
$model->storeImage = 'uploads/storeimages/' . $imageName . '.' . $model->storeImage->extension;
$userExist->storeImage = $model->storeImage;
$model->storeImage;
}
$model->email = '*****@*****.**';
$model->save();
Yii::$app->getSession()->setFlash('success', 'You are successfully Updated Your Profile.');
return $this->redirect(['profile']);
}
} else {
$model->email = $userMain->email;
$model->roleId = $userMain->roleId;
$model->firstName = $userData['firstName'];
$model->lastName = $userData['lastName'];
$model->middleName = $userData['middleName'];
$model->mobile = $userData['mobile'];
$model->mobile2 = $userData['mobile2'];
$model->address2 = $userData['address2'];
$model->city = $userData['city'];
$model->state = $userData['state'];
$model->country = $userData['country'];
if ($model->country == '') {
$model->country = 231;
}
$model->zip = $userData['zip'];
$model->storeName = $userData['storeName'];
$model->storeAddress = $userData['storeAddress'];
$model->storeImage = $userData['storeImage'];
$model->businessName2 = $userData['businessName2'];
$model->fax = $userData['fax'];
$model->vendor_unique_id = $userData['vendor_unique_id'];
return $this->render('vendorprofileedit', ['model' => $model]);
}
//end else
}
