function getCloths($groupId, $expand) { global $country, $previsionCountry, $clothCountry; $country = isset($previsionCountry) ? $previsionCountry : $country; $country = isset($clothCountry) ? $clothCountry : $country; $condition = ''; if (isset($groupId)) { $condition = ' AND c.groupId = ' . $groupId; } $query = "SELECT * FROM cloths c WHERE c.country = '{$country}' " . $condition . " ORDER BY c.name"; $result = mysql_query($query); if (!$expand == 'FULL') { return fetch_array($result); } // FULL expand => fill also providers and previsions of the cloths $rows = array(); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { $row['providers'] = getProviders($row['id'], $expand); $row['previsions'] = getPrevisions($row['id'], 'false', $expand, null, null, null, null, null); $row['plotters'] = getPlotters($row['id'], 'false', null, null); $row['djais'] = getDjais($row['id'], $expand); if ($expand == 'WITH_ROLLS') { $row['rolls'] = getClothRolls($row['id'], true); } $sumDjais = 0; foreach ($row['djais'] as $value) { $sumDjais += $value['amount']; } $row['sumDjais'] = $sumDjais; $intransit = getInTransit($row['id']); $sumInTransit = 0; foreach ($intransit as $order) { foreach ($order['products'] as $product) { if ($product['clothId'] == $row['id']) { $sumInTransit += $product['amount']; } } } $row['sumInTransit'] = $sumInTransit; $tobuy = getToBuy($row['id']); $sumToBuy = 0; foreach ($tobuy as $order) { foreach ($order['products'] as $product) { if ($product['clothId'] == $row['id']) { $sumToBuy += $product['amount']; } } } $row['sumToBuy'] = $sumToBuy; array_push($rows, $row); } return $rows; }
<?php // Get list of all users or one in particualr if the id is given include_once '../include/headers.php'; include_once '../include/dbutils.php'; include_once '../include/main.php'; include_once 'domain/cloths.php'; db_connect(); $expand = isset($_GET['expand']) ? $_GET['expand'] : null; $clothId = isset($_GET['clothId']) ? $_GET['clothId'] : null; if (isset($_GET['djaiNumber'])) { $value = getDjai($_GET['djaiNumber'], $expand); } else { $value = getDjais($clothId, $expand); } //return JSON array exit(json_encode($value));