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