ProgramModel::getProgramsRegistration() - Code Metrics - Inspection of "fix(Registration): Transform template directory to..." - literat/srazvs - Measure and Improve Code Quality continuously with Scrutinizer

Test Failed
Branch — devel (807472)

by Litera
created 2017-03-07 23:00 UTC
ProgramModel::getProgramsRegistration() B

↳ Parent: ProgramModel
Complexity

Conditions	5
Paths	2
Size

Total Lines	42
Code Lines	28
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
cc	5
eloc	28
nc	2
nop	2
dl	0
loc	42
rs	8.439
c	0
b	0
f	0
<?php

namespace App\Models;

use Nette\Database\Context;

/**
 * Program model
 *
 * class for handling programs
 *
 * @created 2012-10-01
 * @author Tomas Litera <[email protected]>
 */
class ProgramModel extends BaseModel
{

	/**
	 * @var array
	 */
	public $columns = [
		'guid',
		'name',
		'block',
		'display_in_reg',
		'description',
		'tutor',
		'email',
		'category',
		'material',
		'capacity',
	];

	/**
	 * Array of form names
	 *
	 * @var array	form_names[]
	 */
	public $formNames = array();

	protected $table = 'kk_programs';

	private static $connection;

	/** Constructor */
	public function __construct(Context $database)
	{
		$this->formNames = array('guid', "name", "description", "material", "tutor", "email", "capacity", "display_in_reg", "block", "category");
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
		$this->setDatabase($database);
		self::$connection = $this->getDatabase();
	}

	/**
	 * Get programs
	 *
	 * @param	int		$block_id	ID of block
/**
 * @param array $germany
 * @param array $island
 * @param array $italy
 */
function finale($germany, $island) {
    return "2:1";
}
	 * @param	int		$visitor_id	ID of visitor
/**
 * @param array $germany
 * @param array $island
 * @param array $italy
 */
function finale($germany, $island) {
    return "2:1";
}
	 * @return	string				html
	 */
	public function getPrograms($blockId, $vid)
	{
		$blocks = $this->database
			->table($this->getTable())
			->where('block ? AND deleted ?', $blockId, '0')
			->limit(10)
			->fetchAll();

		if(!$blocks){

			$html = "";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
		} else {
			/*

			$progSql = "SELECT progs.name AS prog_name
						FROM kk_programs AS progs
						LEFT JOIN `kk_visitor-program` AS visprog ON progs.id = visprog.program
						LEFT JOIN kk_visitors AS vis ON vis.id = visprog.visitor
						WHERE vis.id = '".$id."'";
			*/

			$html = "<div>\n";

			$checked_flag = false;
			$html_input = "";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
			foreach($blocks as $data){
				// full program capacity with visitors
				$fullProgramData = $this->database
					->query('SELECT COUNT(visitor) AS visitors FROM `kk_visitor-program` AS visprog
							LEFT JOIN kk_visitors AS vis ON vis.id = visprog.visitor
							WHERE program = ? AND vis.deleted = ?',
							$data['id'], '0')->fetch();

				// if the program is checked
				$program = $this->database
					->table('kk_visitor-program')
					->where('program ? AND visitor ?', $data['id'], $vid)
					->fetch();

				if($program){
					$checked = "checked='checked'";
					$checked_flag = true;
				} else {
					$checked = "";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
				}
				// if the capacity is full
				if($fullProgramData['visitors'] >= $data['capacity']){
					$html_input .= "<input id='".$data['id'].$blockId."' ".$checked." disabled type='radio' name='blck_".$blockId."' value='".$data['id']."' />\n";
					$fullProgramInfo = " (NELZE ZAPSAT - kapacita programu je již naplněna!)";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
				} else {
					$html_input .= "<input id='".$data['id'].$blockId."' ".$checked." type='radio' name='blck_".$blockId."' value='".$data['id']."' /> \n";
					$fullProgramInfo = "";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
				}
				$html_input .= '<label for="'.$data['id'].$blockId.'">'.$data['name'].'</label>';
				$html_input .= $fullProgramInfo;
				$html_input .= "<br />\n";
			}

			// pokud uz jednou bylo zaskrtnuto, nezaskrtavam znovu
			if(!$checked_flag) $checked = "checked='checked'";
			else $checked = "";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;

			$html .= "<input ".$checked." type='radio' name='blck_".$blockId."' value='0' /> Nebudu přítomen <br />\n";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
			$html .= $html_input;

			$html .= "</div>\n";
		}

		return $html;
	}

	public function getExportPrograms($blockId)
	{
		$exportPrograms = $this->database
			->table($this->getTable())
			->where('block ? AND deleted ?', $blockId, '0')
			->limit(10)
			->fetchAll();

		if(!$exportPrograms) {

			$html = "";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
		} else {
			$html = "<table>\n";
			foreach($exportPrograms as $data){
				$html .= "<tr>";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
				//// resim kapacitu programu a jeho naplneni navstevniky
				$fullProgramData = $this->database
					->query('SELECT COUNT(visitor) AS visitors
							FROM `kk_visitor-program` AS visprog
							LEFT JOIN `kk_visitors` AS vis ON vis.id = visprog.visitor
							WHERE program = ?
							AND vis.deleted = ?',
							$data['id'], '0')->fetch();

				if($fullProgramData['visitors'] >= $data['capacity']){
					//$html .= "<input disabled type='radio' name='".$id."' value='".$data['id']."' />\n";

					$fullProgramInfo = "<span style='font-size:12px; font-weight:bold;'>".$fullProgramData['visitors']."/".$data['capacity']."</span> (kapacita programu je naplněna!)";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
				}
				else {
					//$html .= "<input type='radio' name='".$id."' value='".$data['id']."' /> \n";

					$fullProgramInfo = "<span style='font-size:12px; font-weight:bold;'>".$fullProgramData['visitors']."/".$data['capacity']."</span>";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
				}
				$html .= "<td style='min-width:270px;'>";
				$html .= "<a rel='programDetail' href='".PRJ_DIR."program/?id=".$data['id']."&cms=edit&page=export' title='".$data['name']."'>".$data['name']."</a>\n";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
				$html .= "</td>";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
				$html .= "<td>";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
				$html .= $fullProgramInfo;
				$html .= "</td>";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
				$html .= "</tr>\n";
			}
			$html .= "</table>\n";
		}
		return $html;
	}

	public function renderExportPrograms()
	{
		$programs = "";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;

		$progSql = $this->database
			->table('kk_blocks')
			->select('
				id,
				day,
				DATE_FORMAT(`from`, "%H:%i") AS `from`,
				DATE_FORMAT(`to`, "%H:%i") AS `to`,
				name,
				program'
			)
			->where('deleted = ? AND program = ? AND meeting = ?', '0', '1', $this->meetingId)
			->order('day ASC, from ASC')
			->fetchAll();

		if(!$progSql){

			$programs .= "<div class='emptyTable' style='width:400px;'>Nejsou žádná aktuální data.</div>\n";
		} else {
			//// prasarnicka kvuli programu raftu - resim obsazenost dohromady u dvou polozek
			//$raftCountSql = "SELECT COUNT(visitor) AS raft FROM `kk_visitor-program` WHERE program='56|57'";


			foreach($progSql as $progData){
				//nemoznost volit predsnemovni dikusi
				if($progData['id'] == 63) $notDisplayed = "style='display:none;'";
				//obsazenost raftu
				/*

				elseif($raftCountData['raft'] >= 18){
					if($progData['id'] == 86) $notDisplayed = "style='display:none;'";
					else $notDisplayed = "";
				}
				*/
				else $notDisplayed = "";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
				$programs .= "<div ".$notDisplayed.">".$progData['day'].", ".$progData['from']." - ".$progData['to']." : ".$progData['name']."</div>\n";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
				if($progData['program'] == 1) $programs .= "<div ".$notDisplayed.">".$this->getExportPrograms($progData['id'])."</div>";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
				$programs .= "<br />";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
			}
		}

		return $programs;
	}

	/**
	 * Render data in a table
	 *
	 * @return	string	html of a table
	 */
	public function getData($program_id = NULL)

	{
		if(isset($program_id)) {
			$data = $this->database
				->table($this->getTable())
				->where('id ? AND deleted ?', $program_id, '0')
				->limit(1)
				->fetch();
		} else {
			$data = $this->database
				->query('SELECT programs.id AS id,
						programs.name AS name,
						programs.description AS description,
						programs.tutor AS tutor,
						programs.email AS email,
						blocks.name AS block,
						programs.capacity AS capacity,
						style,
						cat.name AS cat_name
				FROM kk_programs AS programs
				LEFT JOIN kk_blocks AS blocks ON blocks.id = programs.block
				LEFT JOIN kk_categories AS cat ON cat.id = programs.category
				WHERE blocks.meeting = ? AND programs.deleted = ? AND blocks.deleted = ?
				ORDER BY programs.id ASC',
				$this->meetingId, '0', '0')->fetchAll();
		}

		return $data;
	}

	/**
	 * @return Nette\Database\Table\ActiveRow
	 */
	public function all()
	{
		return $this->getDatabase()
				->query('SELECT programs.id AS id,
						programs.name AS name,
						programs.description AS description,
						programs.tutor AS tutor,
						programs.email AS email,
						blocks.name AS block,
						programs.capacity AS capacity,
						style,
						cat.name AS cat_name
				FROM kk_programs AS programs
				LEFT JOIN kk_blocks AS blocks ON blocks.id = programs.block
				LEFT JOIN kk_categories AS cat ON cat.id = programs.category
				WHERE blocks.meeting = ? AND programs.deleted = ? AND blocks.deleted = ?
				ORDER BY programs.id ASC',
				$this->getMeetingId(), '0', '0')->fetchAll();
	}

	/**
	 * @param  string $guid
	 * @return Nette\Database\Table\ActiveRow
	 */
	public function annotation($guid)
	{
		return $this->getDatabase()
				->table($this->getTable())
				->where('guid ? AND deleted ?', $guid, '0')
				->limit(1)
				->fetch();
	}

	/**
	 * Get programs on registration
	 *
	 * @param	int		ID of program
	 * @param	string	disabled
	 * @return	string	html
	 */
	public function getProgramsRegistration ($id, $disabled)
	{
		$result = $this->database
			->table($this->getTable())
			->where('block ? AND deleted ?', $id, '0')
			->limit(10)
			->fetchAll();

		if(!$result){

			$html = "";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
		}
		else{
			$html = "<div>\n";
			$html .= "<input ".$disabled." checked type='radio' name='".$id."' value='0' /> Nebudu přítomen <br />\n";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
			foreach($result as $data){
				//// resim kapacitu programu a jeho naplneni navstevniky
				$fullProgramData = $this->database
					->query('SELECT COUNT(visitor) AS visitors FROM `kk_visitor-program` AS visprog
							LEFT JOIN kk_visitors AS vis ON vis.id = visprog.visitor
							WHERE program = ? AND vis.deleted = ?',
							$data['id'], '0')->fetch();

				// nezobrazeni programu v registraci, v adminu zaskrtavatko u programu
				if($data['display_in_reg'] == 0) $notDisplayedProg = "style='display:none;'";
				else $notDisplayedProg = "";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;

				if($fullProgramData['visitors'] >= $data['capacity']){
					$html .= "<div ".$notDisplayedProg."><input disabled type='radio' name='".$id."' value='".$data['id']."' />\n";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
					$fullProgramInfo = " (NELZE ZAPSAT - kapacita programu je již naplněna!)";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
				}
				else {
					$html .= "<div ".$notDisplayedProg."><input ".$disabled." type='radio' name='".$id."' value='".$data['id']."' /> \n";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
					$fullProgramInfo = "";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
				}
				$html .= "<a class='programLink' rel='programDetail' href='".HTTP_DIR."srazvs/detail.php?id=".$data['id']."&type=program' title='".file_get_contents(HTTP_DIR.'srazvs/detail.php?id='.$data['id'].'&type=program')."' target='_blank'>".$data['name']."</a>\n";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
				$html .= $fullProgramInfo;
				$html .= "</div>\n";
			}
			$html .= "</div>\n";
		}
		return $html;
	}

	/**
	 * Get visitors registred on program
	 *
	 * @param	int		$programId	ID of program
	 * @return	string	html or null
	 */
	public function getProgramVisitors($programId = NULL)
	{
		if(!isset($programId)) {
			return NULL;
		} else {
			$html = "  <div style='border-bottom:1px solid black;text-align:right;'>účastníci</div>";

			$html .= "<br /><a style='text-decoration:none; display:block; margin-bottom:4px;' href='?cms=export-visitors&id=".$programId."'>
	      	<img style='border:none;' align='absbottom' src='".IMG_DIR."icons/pdf.png' />Účastníci programu</a>";

			$result = $this->database
				->query('SELECT vis.name AS name,
								vis.surname AS surname,
								vis.nick AS nick
						FROM kk_visitors AS vis
						LEFT JOIN `kk_visitor-program` AS visprog ON vis.id = visprog.visitor
						WHERE visprog.program = ? AND vis.deleted = ?',
						$programId, '0')->fetchAll();
			$i = 1;
			foreach($result as $data){
				$html .= $i.". ".$data['name']." ".$data['surname']." - ".$data['nick']."<br />";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
				$i++;
			}

			return $html;
		}
	}

	public function getSelectedPrograms($visitorId) {
		$programs = "  <div style='border-bottom:1px solid black;text-align:right;'>vybrané programy</div>";

		$result = $this->database
			->query('SELECT progs.name AS prog_name,
							day,
							DATE_FORMAT(`from`, "%H:%i") AS `from`,
							DATE_FORMAT(`to`, "%H:%i") AS `to`
					FROM kk_programs AS progs
					LEFT JOIN `kk_visitor-program` AS visprog ON progs.id = visprog.program
					LEFT JOIN kk_visitors AS vis ON vis.id = visprog.visitor
					LEFT JOIN kk_blocks AS blocks ON progs.block = blocks.id
					WHERE vis.id = ?
					ORDER BY `day`, `from` ASC',
					$visitorId)->fetchAll();

		foreach($result as $progData){
			$programs .= $progData['day'].", ".$progData['from']." - ".$progData['to']."";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
			$programs .= "<div style='padding:5px 0px 5px 20px;'>- ".$progData['prog_name']."</div>";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
		}

		return $programs;
	}

	public static function getPdfPrograms($id, $vid, $database){
		$result = $database
			->table('kk_programs')
			->where('block ? AND deleted ?', $id, '0')
			->limit(10)
			->fetchAll();

		if(!$result){
			$html = "";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
		} else {

			$html = "<div class='program'>\n";

			foreach($result as $data){
				$rows = $database
					->table('kk_visitor-program')
					->where('program ? AND visitor ?', $data->id, $vid)
					->fetchAll();
				if($rows) $html .= $data['name'];
			}
			$html .= "</div>\n";
		}

		return $html;
	}

	public function getProgramsLarge($id){
		$result = $this->database
			->query('SELECT progs.name AS name,
						cat.style AS style
				FROM kk_programs AS progs
				LEFT JOIN kk_categories AS cat ON cat.id = progs.category
				WHERE block = ? AND progs.deleted = ?
				LIMIT 10',
				$id, '0')->fetchAll();

		if(!$result) $html = "";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
		else {
			$html = "<table>";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
			$html .= " <tr>";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
			foreach($result as $data){
				$html .= "<td class='category cat-".$data['style']."' >".$data['name']."</td>\n";
			}
			$html .= " </tr>\n";
			$html .= "</table>\n";
		}
		return $html;
	}

	public static function getProgramNames($block_id)

	{
		$result = self::$connection
			->table('kk_programs')
			->select('name')
			->where('block ? AND deleted ?', $block_id, '0')
			->limit(10)
			->fetchAll();

		$html = '';

		if(!$result) $html = "";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
		else {
			foreach($result as $data){
				$html .= $data['name'].",\n";
			}
		}
		return $html;
	}

	public function getDetail($id, $type, $httpEncoding)
	{
		$data = $this->database
			->table('kk_' . $type . 's')
			->where('id ? AND deleted ?', $id, '0')
			->limit(1)
			->fetch();

		$name = $data['name'];
		$description = $data['description'];
		$tutor = $data['tutor'];
		$email = $data['email'];

		if($type == "program"){
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
			$capacity = $data['capacity'];

			$countData = $this->database
				->query('SELECT COUNT(visitor) AS visitors
						 FROM `kk_visitor-program` AS visprog
						 LEFT JOIN kk_visitors AS vis ON vis.id = visprog.visitor
						 WHERE program = ? AND vis.deleted = ?',
						 $data->id, '0')->fetch();

			$inner_html = "<tr>\n";
			$inner_html .= " <td class=\"label\">Obsazenost programu:</td>\n";
			$inner_html .= " <td class=\"text\">".$countData['visitors']."/".$capacity."</td>\n";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;
		    $inner_html .= "</tr>\n";
		}
		else $inner_html = "";
<?php

$singleQuoted = 'Value';
$doubleQuoted = "\tSingle is $singleQuoted";

print $doubleQuoted;

		$html = '<html><head><meta http-equiv="Content-Type" content="text/html; charset='.$httpEncoding.'" /></head><body><style>td.text {text-align:left;}</style><table class="form"><tr><td class="label">Program:</td><td class="text">'.$name.'</td></tr><tr><td class="label">Popis:</td><td class="text">'.$description.'</td></tr><tr><td class="label">Lektor:</td><td class="text">'.$tutor.'</td></tr><tr><td class="label">E-mail:</td><td class="text"><a href="mailto:'.$email.'" title="e-mail">'.$email.'</a></td></tr>'.$inner_html.'</table></body></html>';

		return $html;
	}

	/**
	 * Get tutor e-mail address
	 *
	 * @param int $id id of block item
	 * @return Nette\Database\Table\ActiveRow object with e-mail address
	 */
	public function getTutor($id)
	{
		return $this->database
			->table($this->getTable())
			->select('guid, email, tutor')
			->where('id ? AND deleted ?', $id, '0')
			->limit(1)
			->fetch();
	}

	/**
	 * @param  integer $blockId
	 * @return Row
	 */
	public function findByBlockId($blockId = null)
	{
		return $this->getDatabase()
			->query('SELECT	progs.id AS id,
						progs.name AS name,
						style
				FROM kk_programs AS progs
				LEFT JOIN kk_categories AS cat ON cat.id = progs.category
				WHERE block = ? AND progs.deleted = ?
				LIMIT 10',
				$blockId, '0')
			->fetchAll();
	}

}

1			<?php
2
3			namespace App\Models;
4
5			use Nette\Database\Context;
6
7			/**
8			* Program model
9			*
10			* class for handling programs
11			*
12			* @created 2012-10-01
13			* @author Tomas Litera <[email protected]>
14			*/
15			class ProgramModel extends BaseModel
16			{
17
18			/**
19			* @var array
20			*/
21			public $columns = [
22			'guid',
23			'name',
24			'block',
25			'display_in_reg',
26			'description',
27			'tutor',
28			'email',
29			'category',
30			'material',
31			'capacity',
32			];
33
34			/**
35			* Array of form names
36			*
37			* @var array form_names[]
38			*/
39			public $formNames = array();
40
literat / srazvs

Branch — devel (807472)

ProgramModel::getProgramsRegistration() B

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
