public static function insertArtist($name, $bio, $twitter_id, $facebook_id, $google_id, $url, $instagram_id, $tumblr_id, $img_url, $img_file_path, $area, $is_active)
{
if (!is_string($name) || strlen($name) <= 0) {
return MyUtil::fnOk(false, "Name must be at least 1 character", null);
}
$stm = "INSERT INTO " . self::$table_name . "(is_active,name,bio,twitter_id,facebook_id,google_id,url," . "instagram_id,tumblr_id,img_url,img_file_path,updated_ts,updated_by, area) VALUES (" . "('{$is_active}' = '1'), " . "nullIf('" . MyUtil::prepareSqlString(MyUtil::nvl($name, "")) . "', ''), " . "nullIf('" . MyUtil::prepareSqlString(MyUtil::nvl($bio, "")) . "', ''), " . "nullIf('" . MyUtil::nvl($twitter_id, "") . "', ''), " . "nullIf('" . MyUtil::nvl($facebook_id, "") . "', ''), " . "nullIf('" . MyUtil::nvl($google_id, "") . "', ''), " . "nullIf('" . MyUtil::nvl($url, "") . "', ''), " . "nullIf('" . MyUtil::nvl($instagram_id, "") . "', ''), " . "nullIf('" . MyUtil::nvl($tumblr_id, "") . "', ''), " . "nullIf('" . MyUtil::nvl($img_url, "") . "', ''), " . "nullIf('" . MyUtil::nvl($img_file_path, "") . "', ''), " . "CURRENT_TIMESTAMP, " . "'" . $_SESSION['user'] . "', " . "nullIf('" . MyUtil::nvl($area, '') . "','') " . ")";
$result = ConnDB::query_db($stm);
if (!$result) {
return MyUtil::fnOk(false, "SQL Error", null);
}
return MyUtil::fnOk(true, "Artist Inserted", $result);
}
public static function insertUser($email, $password, $first_name, $last_name, $phone_nbr, $facebook_id, $twitter_id, $google_id, $tumblr_id, $instagram_id, $img_url, $img_file_path)
{
if ((!is_string($email) || strlen($email) <= 0) && (!is_string($facebook_id) || strlen($facebook_id) <= 0)) {
return MyUtil::fnOk(false, "email or facebook id must be valid - email:{$email}, fb:{$facebook_ids}", null);
}
$stm = "INSERT INTO " . self::$table_name . "(email,password,first_name,last_name,phone_nbr,facebook_id," . "twitter_id,google_id,tumblr_id,instagram_id,img_url,img_file_path,updated_ts) VALUES (" . "nullIf('" . MyUtil::nvl($email, "") . "', ''), " . "nullIf('" . MyUtil::nvl(MyUtil::myCrypt($password), "") . "', ''), " . "nullIf('" . MyUtil::nvl($first_name, "") . "', ''), " . "nullIf('" . MyUtil::nvl($last_name, "") . "', ''), " . "nullIf('" . MyUtil::nvl($phone_nbr, "") . "', ''), " . "nullIf('" . MyUtil::nvl($facebook_id, "") . "', ''), " . "nullIf('" . MyUtil::nvl($twitter_id, "") . "', ''), " . "nullIf('" . MyUtil::nvl($google_id, "") . "', ''), " . "nullIf('" . MyUtil::nvl($tumblr_id, "") . "', ''), " . "nullIf('" . MyUtil::nvl($instagram_id, "") . "', ''), " . "nullIf('" . MyUtil::nvl($img_url, "") . "', ''), " . "nullIf('" . MyUtil::nvl($img_file_path, "") . "', ''), " . "CURRENT_TIMESTAMP " . ")";
$result = ConnDB::query_db($stm);
if (!$result) {
return MyUtil::fnOk(false, "SQL Error", null);
}
return MyUtil::fnOk(true, "User Inserted", $result);
}
public static function insertVote($session_id, $user_id, $video_id)
{
//id must be an integer
$orig_sess_id = $session_id;
$orig_user_id = $user_id;
$orig_video_id = $video_id;
//get parsed integers
$session_id = MyUtil::parseInt($session_id);
$video_id = MyUtil::parseInt($video_id);
$user_id = MyUtil::parseInt($user_id);
//check
if ($session_id == null || $video_id == null || $user_id == null) {
return MyUtil::fnOk(false, "Must be valid ids - session:{$orig_sess_id}, video:{$orig_video_id}, user:{$orig_user_id}", null);
}
$stm = "INSERT INTO " . self::$table_name . "(session_id, user_id, video_id, updated_ts) VALUES (" . "nullIf(" . MyUtil::nvl($session_id, -1) . ", -1), " . "nullIf(" . MyUtil::nvl($user_id, -1) . ", -1), " . "nullIf(" . MyUtil::nvl($video_id, -1) . ", -1), " . "CURRENT_TIMESTAMP " . ")";
$result = ConnDB::query_db($stm);
if (!$result) {
return MyUtil::fnOk(false, pg_error(), null);
}
return MyUtil::fnOk(true, "", $result);
}
public static function insertVideo($artist_id, $session_id, $name, $description, $youtube_id, $iframe_url, $votes, $upload_status_nbr, $video_status_nbr, $file, $is_active)
{
if (!is_string($name) || strlen($name) <= 0) {
return MyUtil::fnOk(false, "Name must be at least 1 character", null);
}
$orig_artist_id = $artist_id;
$artist_id = MyUtil::parseInt($artist_id);
if ($artist_id == null) {
return MyUtil::fnOk(false, "Must be a valid artist id: {$orig_artist_id}", null);
}
$orig_session_id = $session_id;
$session_id = MyUtil::parseInt($session_id);
if ($session_id == null) {
return MyUtil::fnOk(false, "Must be a valid session id: {$orig_session_id}", null);
}
$stm = "INSERT INTO " . self::$table_name . "(artist_id,session_id,name,description,youtube_id,iframe_url," . "votes,upload_status_nbr,video_status_nbr,updated_ts,updated_by,file,is_active) VALUES ( " . "nullIf('" . MyUtil::nvl($artist_id, -1) . "', -1), " . "nullIf('" . MyUtil::nvl($session_id, -1) . "', -1), " . "nullIf('" . MyUtil::prepareSqlString(MyUtil::nvl($name, "")) . "', ''), " . "nullIf('" . MyUtil::prepareSqlString(MyUtil::nvl($description, "")) . "', ''), " . "nullIf('" . MyUtil::nvl($youtube_id, "") . "', ''), " . "nullIf('" . MyUtil::nvl($iframe_url, "") . "', ''), " . "nullIf('" . MyUtil::nvl(MyUtil::null_if($votes, ''), 0) . "', -1), " . "nullIf('" . MyUtil::nvl($upload_status_nbr, 0) . "', -1), " . "nullIf('" . MyUtil::nvl($video_status_nbr, 0) . "', -1), " . "CURRENT_TIMESTAMP, " . "'" . $_SESSION['user'] . "', " . "nullIf('" . MyUtil::nvl($file, "") . "', ''), " . "'" . MyUtil::nvl($is_active, "false") . "' " . ")";
$result = ConnDB::query_db($stm);
if (!$result) {
return MyUtil::fnOk(false, "SQL Error", null);
}
return MyUtil::fnOk(true, "Inserted Video", $result);
}
public static function insertSession($name, $description, $start_ts, $end_ts, $winner_video_id, $area, $is_active, $img_url)
{
if (!is_string($name) || strlen($name) <= 0) {
return MyUtil::fnOk(false, "Name must be at least 1 character", null);
} else {
if (!is_string($start_ts) || !MyUtil::isDateFormat($start_ts)) {
return MyUtil::fnOk(false, "start_ts must be in yyyy-mm-dd format: {$start_ts}", null);
} else {
if (!is_string($end_ts) || !MyUtil::isDateFormat($end_ts)) {
return MyUtil::fnOk(false, "end_ts must be in yyyy-mm-dd format: {$end_ts}", null);
}
}
}
$stm = "INSERT INTO " . self::$table_name . "(name, description, start_ts, end_ts, area, updated_ts, updated_by, is_active, img_url) VALUES (" . "nullIf('" . MyUtil::prepareSqlString(MyUtil::nvl($name, "")) . "', ''), " . "nullIf('" . MyUtil::prepareSqlString(MyUtil::nvl($description, "")) . "', ''), " . "to_timestamp('{$start_ts}','yyyy-mm-dd'), " . "to_timestamp('{$end_ts}','yyyy-mm-dd'), " . "nullIf('" . MyUtil::nvl($area, '') . "',''), " . "CURRENT_TIMESTAMP, " . "'" . $_SESSION['user'] . "', " . "('{$is_active}' = '1'), " . "'{$img_url}'" . ")";
$result = ConnDB::query_db($stm);
if (!$result) {
return MyUtil::fnOk(false, "SQL Error", null);
}
return MyUtil::fnOk(true, "Session Inserted", $result);
}
