Card-Sleeves/game_total.php at master · thedeviousdev/Card-Sleeves · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
<?php
// Tally cards in cart
include_once('directory.php');

include_once('game.php');
include_once('card.php');
include_once('sleeve.php');
include_once('new_game_object.php');

if (session_status() == PHP_SESSION_NONE) {
    session_start();
}

if(isset($_POST['total'])) {
	get_total_sleeves();
}

function set_sleeve($company_ID) {

	$db = new PDO('sqlite:' . dir_path() . '/data/games_db.sqlite');
  $result = $db->query("SELECT * FROM Sleeve WHERE CompanyID = '" . $company_ID . "'");

  $sleeve_arr = array();

  foreach($result as $card) {
  	$sleeve_arr[] = new sleeve($card['SleeveName'], $card['Width'], $card['Height']);
  }
  return $sleeve_arr;
}

function get_sleeve_name($card) {

	$card_width = $card->get_width();
	$card_height = $card->get_height();

	$sleeve_arr = set_sleeve('1');

	$best_sleeve = NULL;
	$best_sleeve_name = NULL;
	$best_difference = -1;
	$temp_difference = -1;

	foreach($sleeve_arr as $sleeve) {

		$sleeve_name = $sleeve->get_name();
		$sleeve_width = $sleeve->get_width();
		$sleeve_height = $sleeve->get_height();

		if($card_width <= $sleeve_width && $card_height <= $sleeve_height) {
			$temp_difference = ($sleeve_width - $card_width) + ($sleeve_height - $card_height);
			$temp_difference = (int)$temp_difference;
		}

		if($temp_difference == 0) {
			$best_sleeve = $sleeve;
			$best_difference = $temp_difference;
			break;

		}
		if($best_difference == -1 || $temp_difference < $best_difference) {
			$best_sleeve = $sleeve;
			$best_difference = $temp_difference;
		}

	}

	return $best_sleeve;
}

function get_total_sleeves() {
	if(isset($_SESSION['add_games'])) {
		$game_arr = $_SESSION['add_games'];
		$sleeve_arr = array();


		foreach($game_arr as $key => $game) {
			$cart_sleeves = $game->get_cart_sleeve();
			$card_arr = $game->get_cards();

			foreach($card_arr as $key => $card) {
				$sleeves = $card->get_sleeves();
				$card_number = $card->get_nb_cards();

				foreach($cart_sleeves as $sleeve_id) {
					foreach($sleeves as $key => $sleeve) {

				  	if($sleeve->get_id() === $sleeve_id) {
							// $sleeve_brand = $sleeve->get_brand();
							$sleeve_name = $sleeve->get_name();
							$sleeve_id = $sleeve->get_id();

							if (array_key_exists($sleeve_id, $sleeve_arr)) {
								$sleeve_arr[$sleeve_id]['quantity'] += $card_number;
							}
							else {
								$sleeve_arr[$sleeve_id]['quantity'] = $card_number;
							}

							$sleeve_arr[$sleeve_id]['name'] = $sleeve->get_name();
							$sleeve_arr[$sleeve_id]['brand'] = $sleeve->get_brand();
						}
					}
				}
			}
		}
		?>

	  <div class="wrapper_cards">
	  	<ul>
	  		<?php
				foreach($sleeve_arr as $sleeve_name => $sleeve) {
				?>
		  	<li>
			  	<div class="cards_size"><!-- <div class="color_box" style="background-color: green;"></div> --><p><?php echo $sleeve['brand'] . " - " . $sleeve['name']; ?></p></div>
			  	<div class="cards_number"><p><strong><?php echo $sleeve['quantity']; ?></strong></p></div>
		  	</li>
			  <?php
				}
				?>
			</ul>
		</div>
		<?php
	}
}
?>