exec_query('farms', ["*"], '', '', '', '', $whereFarm); if ($whereFarm == "1") { $farm_list = ''; } else { $farm_list = ''; } while ($farm = $farms_res->fetch_assoc()) { $farm_list = $farm_list . ""; $sections_res = $db->exec_query('farm_sections', ['*'], '', '', '', '', "farm_id = {$farm['record_id']}", '', false); $farm_blocks_res = $db->exec_query('farm_blocks', ["*"], '', '', '', '', "name = '{$cluster[0]}'", '', false); $blocks = $farm_blocks_res->fetch_assoc(); $sections_selects = $sections_selects . ""; $sections_selects = $sections_selects . ""; } while ($sections = $sections_res->fetch_assoc()) { $sections_selects = $sections_selects . ""; $mananagement_res = $db->exec_query('management', ['*']); while ($data = $mananagement_res->fetch_assoc()) { $cluster = explode(', ', $data['cluster_ids']); } $block_res = $db->exec_query('farm_blocks', ['*'], '', '', '', '', "section_id = {$sections['record_id']}"); $table_blocks = $table_blocks . ""; $block_arr = []; while ($block = $block_res->fetch_assoc()) { $block_arr[] = $block['name']; } $mananagement_res = $db->exec_query('management', ['*']); $data = $mananagement_res->fetch_assoc(); $cluster_array = $block_arr; $cluster_count = count($cluster_array); $cluster_per_col = ceil($cluster_count / 3); for ($i = 0; $i < $cluster_per_col; $i++) { $table_blocks = $table_blocks . ""; for ($j = 0; $j < 3; $j++) { $index = $i + ($j * $cluster_per_col); $cluster = explode(', ', $data['cluster_ids']); if (isset($cluster_array[$index])) { if (in_array($cluster_array[$index], $cluster)) { $table_blocks = $table_blocks . ""; } else { $table_blocks = $table_blocks . ""; } } } $table_blocks = $table_blocks . ""; } $table_blocks = $table_blocks . ""; } $sections_selects = $sections_selects . ""; } $farm_list = $farm_list . ""; $farming_name = ""; $farming_type_options = ""; $mananagement_res = $db->exec_query('management', ['*'], '', '', '', '', "record_id = {$_GET['errand_id']}", '', false); $manage_data = $mananagement_res->fetch_assoc(); $farming_type_res = $db->exec_query('farming_types', ['*']); while ($farming_type = $farming_type_res->fetch_assoc()) { $farming_type_options = $farming_type_options . ""; $farming_name = $farming_name . ""; } $user_res = $db->exec_query('users', ['*'], '', '', '', '', "user_type = 'MANAGER' AND $whereFarmUser"); $user_list = ''; while ($users = $user_res->fetch_assoc()) { $user_list = $user_list . ""; } $cluster_res = $db->exec_query('clusters', ['*']); $errand_info_res = $db->exec_query('management', ['*'], '', '', '', '', "record_id = {$_GET['errand_id']}", '', false); $errand_info = $errand_info_res->fetch_assoc(); ?>
















exec_query('farm_blocks', ["*"], '', '', '', '', "name = '{$cluster[0]}'", '', false); $blocks = $farm_blocks_res->fetch_assoc(); $blocks['section_id']; $table_blocks = $table_blocks . ""; $farm_blocks_res = $db->exec_query('farm_blocks', ['*'], '', '', '', '', "section_id = {$blocks['section_id']}", '', false); while ($farm_blocks = $farm_blocks_res->fetch_assoc()) { if (in_array($farm_blocks['name'], $cluster)) { echo ""; } else { echo ""; } } $table_blocks = $table_blocks . "
"; ?>











exec_query('management', ["*"], '', '', '', '', "record_id = '{$_GET['errand_id']}'", '', false); while ($image = $image_res->fetch_assoc()) { $imgArray = explode(',', $image['image']); foreach ($imgArray as $imgFile) { if ($imgFile == '') { continue; } else { echo "

"; } } } ?>