private function send() { $dataSender = null; $cutter = new GoogleUrlShortener(); $searched = Searched::find()->where(['status' => Searched::STATUS_ACTIVE])->andWhere(['!=', 'plan_id', '1'])->all(); foreach ($searched as $search) { $smsActive = Sms::find()->select('item_id')->where(['search_id' => $search->id])->all(); $data = json_decode($search->url, true); $arr = []; foreach ($smsActive as $item) { $arr[] = $item->item_id; } $data['exclude_id'] = $arr; $count_sms = Yii::$app->db->createCommand('SELECT * FROM sms WHERE search_id = ' . $search->id . ' AND CAST(created_at as DATE) = CAST(NOW() as DATE)')->execute(); $items = Items::search($data)->limit($search->plan->max_allow_sms - $count_sms)->all(); foreach ($items as $item) { $sms = new SmsClient('0676124113', '0673188966'); $smsBody = 'Ваш товар найден: ' . $cutter->shorten($item->url) . ($item->phone ? ' Тел. ' . $item->phone : ''); $id = $sms->sendSMS('Sishik.net', $search->user->phone, $smsBody); if ($sms->hasErrors()) { var_dump($sms->getErrors()); } else { $sms = new Sms(); $sms->search_id = $search->id; $sms->text = $smsBody; $sms->status = Sms::STATUS_DELIVERED; $sms->item_id = $item->id; $sms->save(); } } } }
public function actionSearched() { if (User::isAdmin(Yii::$app->user->identity->username)) { $link = new ActiveDataProvider(['query' => Searched::find(), 'pagination' => ['pageSize' => 10]]); return $this->render('searched', compact('link')); } else { throw new ForbiddenHttpException('У вас нет прав администратора!', 404); } }
public function actionIndex() { $dataSender = null; $searched = Searched::find()->where(['status' => Searched::STATUS_ACTIVE])->andWhere(['!=', 'plan_id', '1'])->all(); foreach ($searched as $search) { $items = Items::search(json_decode($search->url, true))->limit($search->plan->max_allow_sms)->all(); foreach ($items as $item) { $sms = new SmsClient('0676124113', '0673188966'); $id = $sms->sendSMS('Sishik.net', $search->user->phone, 'Ваш товар найден: ' . $item->url); if ($sms->hasErrors()) { var_dump($sms->getErrors()); } else { $sms = new Sms(); $sms->search_id = $search->id; $sms->text = 'Ваш товар найден: ' . $item->url; $sms->status = Sms::STATUS_DELIVERED; $sms->save(); } } } }
/** * Рендер личного кабинета пользователя * @return string */ public function actionProfile() { $data = User::findOne(Yii::$app->user->id); $query = Searched::find()->where(['user_id' => Yii::$app->user->id]); $link = new ActiveDataProvider(['query' => $query, 'pagination' => ['pageSize' => 10]]); return $this->render('profile', compact('data', 'link')); }