Random PHP file

gistfile1.php

<?php

	// This is how mixed up the tables get in even the simpler projects
	// If you change the structure of the database, life sudden

			$query .= '
				SELECT
					summary.recordlabel AS recordid,
					summary.artist AS artistid,
					summary.album AS albumid,
					summary.song AS songid,
					summary.video AS videoid,
					users.recordlabelname AS recordlabelname,
					artists.name AS artistname,
					albums.name AS albumname,
					songs.name AS songname,
					videos.name AS videoname,
			';
			$query .= ' summary.date, summary.' . $group . ' AS f';
			$query_generic = 'SELECT * ';

			if($type == 'sales') {
				$query .= ' , SUM(summary.amount) AS total, SUM(summary.amount_admin) AS total_admin, SUM(summary.amount_label) AS total_label ';
				if($perms == 1) {
					$query_generic .= ' , SUM(summary.amount) AS total ';
				} else if($perms == 5) {
					$query_generic .= ' , SUM(summary.amount_label) AS total';
				} else if($perms == 10) {
					$query_generic .= ' , SUM(summary.amount_admin) AS total';
				}
			} else {
				$query .= ' , COUNT(summary.id) AS total ';
				$query_generic .= ' , COUNT(summary.id) AS total ';
			}

			$query .= '
				FROM
				(
					(
						(
							(
								summary LEFT JOIN users ON users.id = summary.recordlabel
							)
							LEFT JOIN artists ON artists.id = summary.artist
						)
						LEFT JOIN albums ON albums.id = summary.album
					)
					LEFT JOIN songs ON songs.id = summary.song
				)
				LEFT JOIN videos ON videos.id = summary.video
			';
			$query_generic .= ' FROM summary ';

?>