public function statusUpdate($rdId) { $RequestDetails = RewardsDetails::find()->where(['rdId' => $rdId])->one(); $vendorId = Yii::$app->user->id; $getRewardAmount = StoresMaster::find()->where("vendorId = {$vendorId} and offerStartDate <='{$RequestDetails->purchaseDate}' and offerEndDate >= '{$RequestDetails->purchaseDate}' and \tofferType = 'Cash Back'")->one(); $amountCount = count($getRewardAmount); //print_r($amountCount);exit(); if ($amountCount == 1) { $RequestDetails->rewardsFlag = 'CONFIRMED'; $RequestDetails->newRewards = $getRewardAmount->offer; $requestUpdate = $RequestDetails->update(); if ($requestUpdate) { $rewardsMain = RewardsMain::find()->where(['rdId' => $rdId])->one(); $rewardsCount = count($rewardsMain); if ($rewardsCount != 0) { $rewardsMain->rewards = $RequestDetails->newRewards + $rewardsMain->rewards; $rewardsMain->rdId = $RequestDetails->rdId; $rewardsMain->storeId = $RequestDetails->storeId; $rewardsMain->uId = $RequestDetails->uId; $response = $rewardsMain->update(); } else { $model = new RewardsMain(); $model->rewards = $RequestDetails->newRewards; $model->rdId = $RequestDetails->rdId; $model->storeId = $RequestDetails->storeId; $model->uId = $RequestDetails->uId; $response = $model->save(); } } } else { $response = 0; } return $response; }
public function actionUpload() { $this->layout = "@app/views/layouts/vendor_left"; $model = new Vendorproducts(); $model->scenario = 'fileup'; if ($model->load(Yii::$app->request->post())) { $model->FileUpload = UploadedFile::getInstance($model, 'FileUpload'); if ($model->FileUpload) { $time = time(); $model->FileUpload->saveAs(realpath(Yii::$app->basePath) . '/csv/' . $time . '.' . $model->FileUpload->extension); $model->FileUpload = realpath(Yii::$app->basePath) . '/csv/' . $time . '.' . $model->FileUpload->extension; $handle = fopen($model->FileUpload, "r"); $i = 0; while (($fileop = fgetcsv($handle, 1000, ",")) !== false) { if ($i >= 1) { $userInfo = Yii::$app->db->createCommand()->insert('saleitems', ['vendorId' => Yii::$app->user->id, 'productId' => $fileop[0], 'Brand' => $fileop[1], 'Quantity' => $fileop[2], 'uom' => $fileop[3], 'AltQty' => $fileop[4], 'AltUom' => $fileop[5], 'UnitPrice' => $fileop[6], 'SalePrice' => $fileop[7], 'PriceUnit' => $fileop[8], 'StartDate' => $fileop[9], 'EndDate' => $fileop[10], 'ReserveCount' => $fileop[11], 'SaleInd' => $fileop[12], 'categoryName' => $fileop[13]])->execute(); } $i++; } $storeMain = new StoresMaster(); $storeMain->vendorId = Yii::$app->user->id; $storeMain->totalSaleItems = $i - 1; $storeMain->offerType = $model->offerType; $storeMain->offer = $model->offer; $storeMain->offerStartDate = $model->offerStartDate; $storeMain->offerEndDate = $model->offerEndDate; $storeMain->save(); Yii::$app->getSession()->setFlash('success', ' Your Products are successfully Updated '); return $this->redirect(['upload']); Yii::$app->getSession()->setFlash('success', ' Only Xlsheets are available '); } } else { return $this->render('vendor_view', ['model' => $model]); } }