Мне нужно отправить SMS всем пользователям, которые не получили его.
Я пробовал использовать сеанс, но результат тот же. Когда я печатаю_r($uid), у меня есть значение.
Контроллер:
public function sendemailsms()
{
$year = $this->db->get_where('settings', array('type' => 'running_year'))->row()->description;
$attendance_report = $this->apply_model->getnosendattendanceemail();//get result
//send sms to each one
foreach ($attendance_report as $sendemail) {
//get each result details
$uid = $sendemail->uid;
$year = $sendemail->schoolyear;
$serial = $sendemail->serial_kit;
$date = $sendemail->date;
$time = $sendemail->time;
$parent_id = $this->db->get_where('student', array('loginlogout_id', $uid))->row()->parent_id;
$parent_email = $this->db->get_where('parent', array('parent_id', $parent_id))->row()->email;
$parent_phone = $this->db->get_where('parent', array('parent_id', $parent_id))->row()->phone;
$name = $this->db->get_where('student', array('loginlogout_id' => $uid))->row()->name;
$first_name = $this->db->get_where('student', array('loginlogout_id' => $uid))->row()->first_name;
if ($serial == '~SerialNumber=AIO9192060065') {
$sms = 'Dear Rousseau International School parent, your child ' . $first_name . ' ' . $name . ' has just logged into school on ' . $date . ' at ' . $time . '';
} elseif ($serial == '~SerialNumber=AIO9192860516') {
$sms = 'Dear Rousseau International School parent, your child ' . $first_name . ' ' . $name . ' has just logged out of school ' . $date . ' at ' . $time . '';
} elseif ($serial == '~SerialNumber=AIO9192860502') {
$sms = 'Dear Rousseau International School parent, your child ' . $first_name . ' ' . $name . ' has just logged into school on ' . $date . ' at ' . $time . '';
} elseif ($serial == '~SerialNumber=3399192800019') {
$sms = 'Dear Rousseau International School parent, your child ' . $first_name . ' ' . $name . ' has just logged out of school ' . $date . ' at ' . $time . '';
} elseif ($serial == '~SerialNumber=AIO9192562080') {
$sms = 'Dear Rousseau International School parent, your child ' . $first_name . ' ' . $name . ' has just logged into school on ' . $date.' at ' . $time . '';
} elseif ($serial == '~SerialNumber=AIO9192860505') {
$sms = 'Dear Rousseau International School parent, your child ' . $first_name . ' ' . $name . ' has just logged out of school ' . $date . ' at ' . $time . '';
} else {
$sms = '';
}
// send sms
$msisdn = ['' . $parent_phone . ''];
//var_dump($msisdn);
$message = $sms;
$campaignTitle = 'Security';
$projectName = 'Rousseau';
if ($this->apply_model->attendanceemailemail($parent_email, $date, $time, $name, $first_name) == true) {
// update parameter
$update_sendemail = $this->apply_model->update_sendemail($uid, $year, $date, $time);
$this->envoi_sms($msisdn, $message, $campaignTitle, $projectName);
$update_sendemail = $this->apply_model->update_sendsms($uid, $year, $date, $time);
}
$this->load->view('backend/zktattendance');
}
}
Модель:
public function getnosendattendanceemail()
{
$this->db->select('*');
$this->db->from('attendance_report');
$this->db->where('sendemail', 0);
$this->db->where('departement_id', 2);
$this->db->where('uid !=', 0, FALSE);
$query = $this->db->get();
return $query->result();
}
Подробнее здесь: https://stackoverflow.com/questions/583 ... y-of-non-o
Сценарий построителя запросов CodeIgniter выдает: ошибка при попытке получить свойство, не являющееся объектом [закрыто] ⇐ Php
Кемеровские программисты php общаются здесь
1766746966
Anonymous
Мне нужно отправить SMS всем пользователям, которые не получили его.
Я пробовал использовать сеанс, но результат тот же. Когда я печатаю_r($uid), у меня есть значение.
Контроллер:
public function sendemailsms()
{
$year = $this->db->get_where('settings', array('type' => 'running_year'))->row()->description;
$attendance_report = $this->apply_model->getnosendattendanceemail();//get result
//send sms to each one
foreach ($attendance_report as $sendemail) {
//get each result details
$uid = $sendemail->uid;
$year = $sendemail->schoolyear;
$serial = $sendemail->serial_kit;
$date = $sendemail->date;
$time = $sendemail->time;
$parent_id = $this->db->get_where('student', array('loginlogout_id', $uid))->row()->parent_id;
$parent_email = $this->db->get_where('parent', array('parent_id', $parent_id))->row()->email;
$parent_phone = $this->db->get_where('parent', array('parent_id', $parent_id))->row()->phone;
$name = $this->db->get_where('student', array('loginlogout_id' => $uid))->row()->name;
$first_name = $this->db->get_where('student', array('loginlogout_id' => $uid))->row()->first_name;
if ($serial == '~SerialNumber=AIO9192060065') {
$sms = 'Dear Rousseau International School parent, your child ' . $first_name . ' ' . $name . ' has just logged into school on ' . $date . ' at ' . $time . '';
} elseif ($serial == '~SerialNumber=AIO9192860516') {
$sms = 'Dear Rousseau International School parent, your child ' . $first_name . ' ' . $name . ' has just logged out of school ' . $date . ' at ' . $time . '';
} elseif ($serial == '~SerialNumber=AIO9192860502') {
$sms = 'Dear Rousseau International School parent, your child ' . $first_name . ' ' . $name . ' has just logged into school on ' . $date . ' at ' . $time . '';
} elseif ($serial == '~SerialNumber=3399192800019') {
$sms = 'Dear Rousseau International School parent, your child ' . $first_name . ' ' . $name . ' has just logged out of school ' . $date . ' at ' . $time . '';
} elseif ($serial == '~SerialNumber=AIO9192562080') {
$sms = 'Dear Rousseau International School parent, your child ' . $first_name . ' ' . $name . ' has just logged into school on ' . $date.' at ' . $time . '';
} elseif ($serial == '~SerialNumber=AIO9192860505') {
$sms = 'Dear Rousseau International School parent, your child ' . $first_name . ' ' . $name . ' has just logged out of school ' . $date . ' at ' . $time . '';
} else {
$sms = '';
}
// send sms
$msisdn = ['' . $parent_phone . ''];
//var_dump($msisdn);
$message = $sms;
$campaignTitle = 'Security';
$projectName = 'Rousseau';
if ($this->apply_model->attendanceemailemail($parent_email, $date, $time, $name, $first_name) == true) {
// update parameter
$update_sendemail = $this->apply_model->update_sendemail($uid, $year, $date, $time);
$this->envoi_sms($msisdn, $message, $campaignTitle, $projectName);
$update_sendemail = $this->apply_model->update_sendsms($uid, $year, $date, $time);
}
$this->load->view('backend/zktattendance');
}
}
Модель:
public function getnosendattendanceemail()
{
$this->db->select('*');
$this->db->from('attendance_report');
$this->db->where('sendemail', 0);
$this->db->where('departement_id', 2);
$this->db->where('uid !=', 0, FALSE);
$query = $this->db->get();
return $query->result();
}
Подробнее здесь: [url]https://stackoverflow.com/questions/58396747/codeigniter-query-builder-scripting-emits-error-trying-to-get-property-of-non-o[/url]
Ответить
1 сообщение
• Страница 1 из 1
Перейти
- Кемерово-IT
- ↳ Javascript
- ↳ C#
- ↳ JAVA
- ↳ Elasticsearch aggregation
- ↳ Python
- ↳ Php
- ↳ Android
- ↳ Html
- ↳ Jquery
- ↳ C++
- ↳ IOS
- ↳ CSS
- ↳ Excel
- ↳ Linux
- ↳ Apache
- ↳ MySql
- Детский мир
- Для души
- ↳ Музыкальные инструменты даром
- ↳ Печатная продукция даром
- Внешняя красота и здоровье
- ↳ Одежда и обувь для взрослых даром
- ↳ Товары для здоровья
- ↳ Физкультура и спорт
- Техника - даром!
- ↳ Автомобилистам
- ↳ Компьютерная техника
- ↳ Плиты: газовые и электрические
- ↳ Холодильники
- ↳ Стиральные машины
- ↳ Телевизоры
- ↳ Телефоны, смартфоны, плашеты
- ↳ Швейные машинки
- ↳ Прочая электроника и техника
- ↳ Фототехника
- Ремонт и интерьер
- ↳ Стройматериалы, инструмент
- ↳ Мебель и предметы интерьера даром
- ↳ Cантехника
- Другие темы
- ↳ Разное даром
- ↳ Давай меняться!
- ↳ Отдам\возьму за копеечку
- ↳ Работа и подработка в Кемерове
- ↳ Давай с тобой поговорим...
Мобильная версия