public function Save() { $sql = "insert into " . OpenSms::getTableName('sms') . "(bulkSMSId, number, message, sender, refId, Status)\r\n\t\t\t\t value('" . StringMethods::MakeSave($this->BulkSMSId) . "', '" . StringMethods::MakeSave($this->Number) . "', '" . StringMethods::MakeSave($this->Message) . "', '" . StringMethods::MakeSave($this->Sender) . "', '" . StringMethods::MakeSave($this->RefId) . "', '" . StringMethods::MakeSave($this->Status) . "');"; OpenSms_Helper_Db::executeNonQuery($sql); if ($this->Id == -1) { $sql = "select MAX(id) as no from `" . OpenSms::getTableName('sms') . "`"; $result = OpenSms_Helper_Db::executeReader($sql); foreach ($result as $r) { $this->Id = $r->no; return $r->no; } } }
public function getById($id = -1) { $this->Id = $id; if ($id != '') { $sql = "select * from " . OpenSms::getTableName('contact') . " where id = '" . StringMethods::MakeSave($id) . "';"; $result = OpenSms_Helper_Db::executeReader($sql); foreach ($result as $r) { $this->GroupId = $r->groupId; $this->Name = StringMethods::GetRaw($r->name); $this->Number = StringMethods::GetRaw($r->number); $this->Id = $r->id; } } }
public static function GetAll($role = '') { $pageObj = new OpenSms_Model_Page(); $tableName = $pageObj->getTableName(); $sql = "select * from {$tableName}" . (empty($role) ? ';' : " where role = {$role}"); $results = OpenSms_Helper_Db::executeReader($sql); $pages = array(); foreach ($results as $r) { $page = new OpenSms_Model_Page(); $page->copy([$r]); $pages[] = $page; } return $pages; }
public function Save() { if (!empty($this->Id)) { $sql = "update logins set loginId = '" . StringMethods::MakeSave($this->LoginId) . "', token = '" . StringMethods::MakeSave($this->Token) . "', date = now() where id = '{$this->Id}';"; } else { $sql = "insert into logins(loginId, token)\r\n\t\t\t\t value('" . StringMethods::MakeSave($this->LoginId) . "', '" . StringMethods::MakeSave($this->Token) . "');"; } //die($sql); //$this->db->SendQuery($sql); OpenSms_Helper_Db::executeNonQuery($sql); setcookie($this->cookieName, $this->Token, time() + 86400 * 30 * 12 * 10, '/'); if ($this->Id == -1) { $sql = "select MAX(id) as no from `logins`"; $result = OpenSms_Helper_Db::executeReader($sql); return $result[0]->no; } }
public static function getMobileNos() { $sql = "select mobileNo from users where mobileNo <> ''"; $result = OpenSms_Helper_Db::executeReader($sql); $nos = ''; foreach ($result as $r) { $fChar = substr($r->mobileNo, 0, 1); if (trim($r->mobileNo) != '' && ($fChar == '2' || $fChar == '0' || $fChar == '8')) { $nos .= trim($r->mobileNo) . ','; } } return $nos; }
public static function GetCard($offset, $limit) { $sql = "select * from " . OpenSms::getTableName('cards') . " {$offset}, {$limit}"; $result = OpenSms_Helper_Db::executeReader($sql); $cards = array(); foreach ($result as $r) { $card = new OpenSms_Model_Card(); $card->Id = $r->id; $card->Pin = $r->pin; $card->Unit = $r->unit; $card->IsValid = true; $cards[] = $card; } return $cards; }
public static function GetBulkSMS($loginId, $offset, $limit) { $bulkSMSs = array(); $sql = "select * from " . OpenSms::getTableName('bulksms') . " where loginId = '{$loginId}' ORDER BY id DESC LIMIT {$offset}, {$limit};"; $result = OpenSms_Helper_Db::executeReader($sql); foreach ($result as $r) { $bulkSMS = new OpenSms_Model_BulkSms(); $bulkSMS->Id = $r->id; $bulkSMS->LoginId = StringMethods::GetRaw($r->loginId); $bulkSMS->DateCreated = $r->dateCreated; $bulkSMS->Message = StringMethods::GetRaw($r->message); $bulkSMS->Sender = StringMethods::GetRaw($r->sender); $bulkSMS->Status = StringMethods::GetRaw($r->status); $bulkSMS->Count = $r->count; $bulkSMSs[] = $bulkSMS; } return $bulkSMSs; }
public function getById($key) { $sql = "select * from " . $this->getTableName() . " where `key` = '{$key}'"; $result = OpenSms_Helper_Db::executeReader($sql); $this->copy($result); }
public static function GetRange($offset, $limit, $loginId = '') { $trans = array(); $sql = "select * from " . OpenSms::getTableName('transactions') . (empty($loginId) ? "" : "where loginId = '{$loginId}'") . " ORDER BY id DESC LIMIT {$offset}, {$limit};"; $result = OpenSms_Helper_Db::executeReader($sql); foreach ($result as $r) { $tran = new OpenSms_Model_Transaction(); $tran->Id = $r->id; $tran->LoginId = StringMethods::GetRaw($r->loginId); $tran->Date = $r->date; $tran->Amount = StringMethods::GetRaw($r->amount); $tran->Unit = StringMethods::GetRaw($r->unit); $tran->Status = StringMethods::GetRaw($r->status); $tran->Description = StringMethods::GetRaw($r->description); $tran->PaymentMethod = StringMethods::GetRaw($r->paymentMethod); $tran->IsValid = StringMethods::GetRaw(TRUE); $tran->Type = $r->type; $tran->Committed = $r->committed; $trans[] = $tran; } return $trans; }