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