public function Load($loginId)
{
$success = TRUE;
$sql = "select * from " . OpenSms::getTableName('usedCards') . " where cardId = '" . StringMethods::MakeSave($this->Id) . "';";
$result = OpenSms_Helper_Db::executeReader($sql);
foreach ($result as $r) {
$success = FALSE;
if ($loginId == $r->loginId) {
$message = 'This card has already been used by you';
} else {
$message = 'This card has already been used';
}
}
if ($success) {
$sql = 'insert into ' . OpenSms::getTableName('usedCards') . ' (loginId, cardId) value("' . $loginId . '", "' . $this->Id . '");';
//die($sql);
$inserted = OpenSms_Helper_Db::executeNonQuery($sql);
if ($inserted) {
$user = OpenSms::loadModel("OpenSms_Model_User", [0 => $loginId]);
$user->Balance += $this->Unit;
$user->Save();
$message = 'Your account has been credited with ' . $this->Unit . ' SMS unit';
}
}
return array('success' => $success, 'message' => $message);
}
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()
{
$content = new OpenSms_Model_Content([0 => $this->Key]);
if ($content->Id > 0) {
$this->Id = $content->Id;
}
$sql = !$this->Id > 0 ? "insert into " . $this->getTableName() . "(`key`, `type`, `body`, `host`) value('" . StringMethods::MakeSave($this->Key) . "', '" . StringMethods::MakeSave($this->Type) . "', '" . StringMethods::MakeSave($this->Body) . "', '" . StringMethods::MakeSave($this->Host) . "');" : "update " . $this->getTableName() . " set `body` = '" . StringMethods::MakeSave($this->Body) . "'\r\n where `key` = '" . StringMethods::MakeSave($this->Key) . "';";
//die($sql);
return OpenSms_Helper_Db::executeNonQuery($sql);
}
public function Save()
{
$content = new OpenSms_Model_Page([0 => $this->Permalink]);
if ($content->Id > 0) {
return 'A page with the same permalink already exist';
}
$sql = !$this->Id > 0 ? "insert into " . $this->getTableName() . "(`permalink`, `title`, `layout`, `role`, `description`) value('" . StringMethods::MakeSave($this->Permalink) . "', '" . StringMethods::MakeSave($this->Title) . "', '" . StringMethods::MakeSave($this->Layout) . "'\n , '" . StringMethods::MakeSave($this->Role) . "', '" . StringMethods::MakeSave($this->Description) . "');" : "update " . $this->getTableName() . " set `title` = '" . StringMethods::MakeSave($this->Title) . "',\n layout = '" . StringMethods::MakeSave($this->Layout) . "', description = '" . StringMethods::MakeSave($this->Description) . "\n where `permalink` = '" . StringMethods::MakeSave($this->Permalink) . "';";
//die($sql);
return OpenSms_Helper_Db::executeNonQuery($sql);
}
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 SaveMessages($messages)
{
$sql = 'insert into ' . OpenSms::getTableName('sms') . '(bulkSMSId, number, message, sender, refId, status) value';
$i = 0;
foreach ($messages as $message) {
$i += 1;
$count = count($messages);
$sql .= "('" . StringMethods::MakeSave($message->BulkSMSId) . "', '" . StringMethods::MakeSave($message->Number) . "', '" . StringMethods::MakeSave($message->Message) . "', '" . StringMethods::MakeSave($message->Sender) . "', '" . StringMethods::MakeSave($message->RefId) . "', '" . StringMethods::MakeSave($message->Status) . "')";
if ($i == $count) {
$sql .= ';';
} else {
$sql .= ',';
}
}
OpenSms_Helper_Db::executeNonQuery($sql);
}
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 function Delete()
{
unset($_COOKIE[$this->cookieName]);
$sql = "delete from logins where id = '" . StringMethods::MakeSave($this->Id) . "'";
return OpenSms_Helper_Db::executeNonQuery($sql);
}
public static function Encode($string)
{
return md5(StringMethods::MakeSave($string));
}
public function Delete()
{
$sql = "delete from draft where id = '" . StringMethods::MakeSave($this->Id) . "'";
return $this->db->SendQuery($sql);
}
