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