public function Delete() { $sql = "delete from " . OpenSms::getTableName('contact') . " where id = '" . StringMethods::MakeSave($this->Id) . "'"; //die($sql); if (OpenSms_Helper_Db::executeNonQuery($sql)) { return 'One number deleted'; } else { return 'Error in deleting number'; } }
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 static function FindUserByEmail($emailId) { $sql = "select * from " . OpenSms::getTableName('users') . " where loginId = '" . StringMethods::MakeSave($emailId) . "';"; $u = new OpenSms_Model_User(); $result = OpenSms_Helper_Db::executeReader($sql); return isset($result[0]) ? self::copyFromPDO($result[0]) : new OpenSms_Model_User(); }
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 getTableName() { return OpenSms::getTableName('content'); }
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; }
protected function getTableName($name) { return OpenSms::getTableName($name); }
public function getTableName() { return OpenSms::getTableName('page'); }