add form to change season

1 files changed, 46 insertions, 0 deletions

diff --git a/app/helpers.php b/app/helpers.php
index c5a227c..7214626 100644
--- a/app/helpers.php
+++ b/app/helpers.php
@@ -1,4 +1,5 @@
 <?php
+use Illuminate\Support\Facades\DB;
 use Carbon\Carbon;
 
 function replaceSpecialChars($string) {
@@ -105,6 +106,37 @@ function nextSeason( $month = null ){
 	return $next;
 }
 
+function lastSeason( $month = null ){
+	if ( is_null($month) ) {
+		$month = (int)date("m");
+	}
+
+	$last = $month - 3;
+	if ( $last <= 0 ) {
+		$last = $last + 12;
+	}
+
+	return $last;
+}
+
+function getFieldSeasonName() {
+	$first = (int)date("m");
+	$second = lastSeason($first);
+	$third = lastSeason($second);
+	$fourth = lastSeason($third);
+
+	return '"' . getSeason($first) . '", "' . getSeason($second) . '", "' . getSeason($third) . '", "' . getSeason($fourth) . '"';
+}
+
+function getFieldSeasonNameNext() {
+	$first = (int)date("m");
+	$second = nextSeason($first);
+	$third = nextSeason($second);
+	$fourth = nextSeason($third);
+
+	return '"' . getSeason($first) . '", "' . getSeason($second) . '", "' . getSeason($third) . '", "' . getSeason($fourth) . '"';
+}
+
 function escapeLike($string){
 	$search = array('%', '_');
 	$replace   = array('\%', '\_');
@@ -145,3 +177,17 @@ function camo($url) {
 
 	return $url;
 }
+
+function getChangeSeasonOptions() {
+	return DB::select('
+			SELECT DISTINCT season_name,season_year
+				FROM anime
+			WHERE
+				season_name IS NOT NULL
+			AND
+				season_name != ""
+			AND
+				season_year IS NOT NULL
+			ORDER BY season_year DESC, FIELD(season_name, ' . getFieldSeasonName()  . ') ASC'
+	);
+}