/**
* Add a new Term and Condition
* @param int language id
* @param string the content
* @param int term and condition type (0 or 1)
* @param string explain changes
* @return boolean sucess
*/
public static function add($language, $content, $type, $changes)
{
$legal_table = Database::get_main_table(TABLE_MAIN_LEGAL);
$last = self::get_last_condition($language);
$language = Database::escape_string($language);
$content = Database::escape_string($content);
$type = intval($type);
$changes = Database::escape_string($changes);
$time = time();
if ($last['content'] != $content) {
$version = intval(LegalManager::get_last_condition_version($language));
$version++;
$sql = "INSERT INTO {$legal_table}\n\t\t\t\t\t\tSET language_id = '" . Database::escape_string($language) . "',\n\t\t\t\t\t\t\tcontent = '" . $content . "',\n\t\t\t\t\t\t\tchanges= '" . $changes . "',\n\t\t\t\t\t\t\ttype = '" . $type . "',\n\t\t\t\t\t\t\tversion = '" . Database::escape_string($version) . "',\n\t\t\t\t\t\t\tdate = '" . $time . "'";
$result = Database::query($sql);
return true;
} elseif ($last['type'] != $type && $language == $last['language_id']) {
//update
$id = $last['legal_id'];
$sql = "UPDATE {$legal_table}\n\t\t\t\t\tSET changes= '" . $changes . "',\n\t\t\t\t\ttype = '" . $type . "',\n\t\t\t\t\tdate = '" . $time . "'\n\t\t\t\t\tWHERE legal_id= {$id} ";
$result = Database::query($sql);
return true;
} else {
return false;
}
}
/**
* Add a new Term and Condition
* @param int $language language id
* @param string $content content
* @param int $type term and condition type (0 or 1)
* @param string $changes explain changes
* @return boolean success
*/
public static function add($language, $content, $type, $changes)
{
$legal_table = Database::get_main_table(TABLE_MAIN_LEGAL);
$last = self::get_last_condition($language);
$type = intval($type);
$time = time();
if ($last['content'] != $content) {
$version = intval(LegalManager::get_last_condition_version($language));
$version++;
$params = ['language_id' => $language, 'content' => $content, 'changes' => $changes, 'type' => $type, 'version' => intval($version), 'date' => $time];
Database::insert($legal_table, $params);
return true;
} elseif ($last['type'] != $type && $language == $last['language_id']) {
//update
$id = $last['legal_id'];
$params = ['changes' => $changes, 'type' => $type, 'date' => $time];
Database::update($legal_table, $params, ['legal_id => ?' => $id]);
return true;
} else {
return false;
}
}
