<?php
/*
Template Name: Single Problem Statements
*/
session_start();
$id = $_GET[ 'id' ];
$problem_statements_info = $wpdb->get_row( "SELECT * FROM problem_statements WHERE id = ".$id );
$parent_meta = get_post_meta( get_the_ID() );
$st_banner = $parent_meta[ 'st_banner' ][ 0 ];
$banner_url = wp_get_attachment_url( $st_banner, 'full' );
if ( $banner_url == '' )
	$banner_url = 'images/banners/subBanner.jpg';
$parent_meta = get_post_meta( get_the_ID());
$summary = $problem_statements_info->summary;
$full_content = $problem_statements_info->full_content;
$statement_title = $problem_statements_info->title;
$brief = $problem_statements_info->challenge_brief;
$link = $problem_statements_info->video_url;
$st_selected_companies = $problem_statements_info->selected_companies;
$filter_technology = $problem_statements_info->filter_technology;
$count = 0;
if($brief != '')
	$count++;
if($link != '')
	$count++;
//Technology
$child_of = 2;
$categories1 = get_categories( array(
    'orderby' => 'name',
    'order'   => 'ASC',
	'hide_empty' => 0,
	'child_of' => $child_of
) );
//Problem Statement
$child_of = 3;
$categories2 = get_categories( array(
    'orderby' => 'name',
    'order'   => 'ASC',
	'hide_empty' => 0,
	'child_of' => $child_of
) );
//functions
$child_of = 4;
$categories3 = get_categories( array(
    'orderby' => 'name',
    'order'   => 'ASC',
	'hide_empty' => 0,
	'child_of' => $child_of
) );
$categories = get_the_category(get_the_ID());



if($st_selected_companies == '')
{
	$filter_technology = explode(',',$filter_technology);
	foreach($filter_technology as $s)
	{
		$find_set[] = " find_in_set('".$s."', meta_value) ";
	}
		$listing = array();
		
		$sql1 = "SELECT * FROM repository_values where meta_name = 'technology' AND (".implode(' AND ',$find_set).")";
		
		
		$listing = $wpdb->get_results($sql1);
		
		foreach($listing as $i)
		{
			$st_selected_companies[] = $i->main_id;
		}
		
			
	
	
	$st_selected_companies = array_unique($st_selected_companies);
	
	
	foreach($st_selected_companies as $ss)
	{
		$company_info = $wpdb->get_row( "SELECT * FROM repository WHERE id = ".$ss);
		$companies[] = $company_info;
		
		
		$company_details = $wpdb->get_row( "SELECT * FROM repository_values WHERE meta_name = 'summary' AND main_id = ".$ss );
		$summary_listing[$ss] = $company_details->meta_value;
		
	}
	
} else {
	$st_selected_companies = explode(',',$st_selected_companies);
	
	foreach($st_selected_companies as $ss)
	{
		$company_info = $wpdb->get_row( "SELECT * FROM repository WHERE id = ".$ss);
		$companies[] = $company_info;
		
		
		$company_details = $wpdb->get_row( "SELECT * FROM repository_values WHERE meta_name = 'summary' AND main_id = ".$ss );
		$summary_listing[$ss] = $company_details->meta_value;
		
	}
}
$member_id = $_SESSION['member_website'];
//bookmarks
$bookmarks_listing = array();
if($member_id != '')
{
	$bookmarks = $wpdb->get_results( "SELECT * FROM bookmarks WHERE type = 2 AND member_id = ".$member_id );
	foreach($bookmarks as $bb)
	{
		$bookmarks_listing[$bb->company_id] = 1;
	}
}
$class2 = 'nonselected_item';
if($bookmarks_listing[get_the_ID()] == 1)
{
	$class2 = 'selected_item';	
	$remove2 = 1;
}
?>
<!DOCTYPE html
	PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
	<meta name="viewport" content="width=device-width, initial-scale=1, minimum-scale=1.0, maximum-scale=1.0"/>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
	<meta prefix="og: http://ogp.me/ns#" property="og:image" content="https://imas.org.sg/banner.jpg"/>
	<meta name="format-detection" content="telephone=no">
	<title></title>
	<base href="<?php echo get_template_directory_uri(); ?>/">
	<link rel="Shortcut Icon" href="images/favicon.ico" type="image/x-icon"/>
	<link rel="Bookmark" href="images/favicon.ico" type="image/x-icon"/>
	<link rel="icon" href="images/favicon.ico" type="image/x-icon"/>
	<link href="css/conferenceFont.css" rel="stylesheet" type="text/css"/>
	<link href="css/iconfont.css" rel="stylesheet" type="text/css"/>
	<link href="css/layout.css" rel="stylesheet" type="text/css"/>
	<link href="css/nav.css" rel="stylesheet" type="text/css"/>
	<link href="css/template.css" rel="stylesheet" type="text/css"/>
	<link href="css/cont.css" rel="stylesheet" type="text/css"/>
	<link href="css/fintech.css" rel="stylesheet" type="text/css"/>
	<link href="https://fonts.googleapis.com/css?family=Philosopher:300i,400,600,700&display=swap" rel="stylesheet">
	<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
	<script type="text/javascript" src="js/jquery-3.4.1.min.js"></script>
	<link rel="stylesheet" href="https://cdn.jsdelivr.net/bxslider/4.2.12/jquery.bxslider.css">
	<link href="js/gallery/jquery.fancybox.css" rel="stylesheet" type="text/css"/>
	<script type="text/javascript" src="js/gallery/jquery.fancybox.min.js"></script>
	<link rel="stylesheet" href="//code.jquery.com/ui/1.12.1/themes/base/jquery-ui.css">
	<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.1/jquery.min.js"></script>
	<script src="https://cdn.jsdelivr.net/bxslider/4.2.12/jquery.bxslider.min.js"></script>
	<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.js"></script>
	<script type="text/javascript" src="js/default.js"></script>
	
	<style>
	.f_image {
		
		min-height:155px;
	}
	</style>
	<?php wp_head(); ?>
	<?php include_once('ga.php'); ?>
</head>
<body class="subPage">
	<?php include_once('h.php'); ?>
	<div class="subBanner" style="background-image: url(<?php echo $banner_url; ?>);">
		<div class="bannerShadow"></div>
		<div class="wideContainer">
			<div class="container">
				<div class="content">
					<h3>
						About IMAS					</h3>
				
				</div>
			</div>
		</div>
	</div>
	<div class="subPageWrap">
		<div class="subPageColumnWrap container">
			<div class="column left">
			<a href="<?php echo home_url();?>/fintech-solution/" class="btn btnSmall btn3 gray_btn icon-arrow-right"><span>BROWSE FINTECH<BR>SOLUTIONS</span></a>
			<br>
				
			<a href="<?php echo home_url();?>/problem-statements/" class="btn btnSmall btn3 icon-arrow-right"><span>BROWSE PROBLEM<BR>STATEMENTS</span></a>
			
			</div>
			<div class="column main">
				<div class="column left3">
					<h2><?php echo getlanguage_text('title1');?></h2>
					<div class="searchbar">
						<form action="<?php echo home_url();?>/search.php" method="post">
						<strong><?php echo getlanguage_text('text2');?></strong> <input type="text" name="search" class="search_input2" value="<?php echo $_SESSION['search_key'] ?>"><input type="image" src="images/search1.jpg" class="searchimg">
						</form>
					</div>
					<br>
					<div align="center" id="statement_info">
						<h4>PROBLEM STATEMENTS:</h4>
						<span class="statement_title">
							<?php echo $statement_title;?>
						</span>
					</div>
					<p>
					<?php echo $full_content; ?>
					</p>
					<br>
					<div class="problem_action <?php echo ($count == 1) ? 'problem_actiont': ''?>">
					
						<?php if($brief != ''): ?>
							<a href="<?php echo $brief; ?>" target="_blank" class="btn btnSmall icon-arrow-right">CHALLENGE BRIEF</a>
							<?php endif; ?>
						<?php if($link != ''): ?>
							<a href="<?php echo $link; ?>" target="_blank" class="btn btnSmall icon-arrow-right">VIEW VIDEO</a>
							<?php endif; ?>
							<?php if($_SESSION['member_website'] != ''): ?>
						<?php if($remove2 == 1): ?>
							<a href="<?php echo home_url();?>/add_bookmarks.php?type=2&id=<?php echo get_the_ID();?>&remove=<?php echo $remove2; ?>" onClick="return confirm('Are you sure you want to delete?')"><strong class="<?php echo $class2; ?>"><i class="fa fa-bookmark"></i> Bookmark</strong></a>
							<?php else: ?>
							<a href="<?php echo home_url();?>/add_bookmarks.php?type=2&id=<?php echo get_the_ID();?>&remove=<?php echo $remove2; ?>"><strong class="<?php echo $class2; ?>"><i class="fa fa-bookmark"></i> Bookmark</strong></a>
							<?php endif; ?>
							<?php endif; ?>
					</div>
					<br>
					
					
					<?php if(empty($companies)): ?>
						<div class="company_row"></div>
					<?php endif; ?>
					
					
					<?php if(!empty($companies)): ?>
					
					<a name="list_companies"></a>
					<div class="company_row">
						<?php foreach($companies as $ccc): ?>
						<?php
						
							$company_thumbnail = $ccc->company_logo;
							if($company_thumbnail == '')
							{
								$company_thumbnail = home_url().'/placeholder.png';
								
							} else {
								$company_thumbnail = home_url().'/admin/upload/'.$company_thumbnail;
							}
						
						
							$parent_meta = get_post_meta( $ccc->ID );
						
						
						$remove = '';
						$class = 'nonselected_item';
							if($_SESSION['compare'][$ccc->ID] == 1)
							{
								$class = 'selected_item';
								$remove = 1;
							}
							
							$class2 = 'nonselected_item';
							if($bookmarks_listing[$pp->ID] == 1)
							{
								$class2 = 'selected_item';	
								$remove2 = 1;
							}
							
							$company_name = strtolower($ccc->post_title);
							$company_name = str_replace(' ','-',$company_name);
							
							$company_url = home_url().'/company/?id='.$ccc->short_url;
	
						?>
						<div class="company_item slide_item  margin2">
							<div class="f_image">
							<a href="<?php echo $company_url; ?>"><img src="<?php echo $company_thumbnail; ?>"></a>
							</div>
							<h3><a href="<?php echo $company_url; ?>"><?php echo $ccc->company_name; ?></a></h3>
							<p class="summary">
							<?php if($summary_listing[$ccc->id] != ''): ?>
							<?php echo substr($summary_listing[$ccc->id], 0, 200) ; ?>...
							<?php endif; ?>
							</p>
						
							<div class="action">
								<div class="action1 "><a href="<?php echo home_url();?>/compare.php?id=<?php echo $ccc->id;?>&remove=<?php echo $remove;?>"><strong class="<?php echo $class; ?>" onClick="return check_compare();"><i class="fa fa-check"></i> Compare</strong></a></div>
								<div class="action1">
								<?php if($_SESSION['member_website'] != ''): ?>
							<?php if($remove2 == 1): ?>
							<a href="<?php echo home_url();?>/add_bookmarks.php?type=2&id=<?php echo $ccc->id;?>&remove=<?php echo $remove2; ?>" onClick="return confirm('Are you sure you want to delete?')"><strong class="<?php echo $class2; ?>"><i class="fa fa-bookmark"></i> Bookmark</strong></a>
							<?php else: ?>
							<a href="<?php echo home_url();?>/add_bookmarks.php?type=2&id=<?php echo $ccc->id;?>&remove=<?php echo $remove2; ?>"><strong class="<?php echo $class2; ?>"><i class="fa fa-bookmark"></i> Bookmark</strong></a>
							<?php endif; ?>
							<?php endif; ?>
								
								</div>
							</div>
						</div>
					<?php endforeach; ?>	
					</div>
					<?php endif; ?>	
					
					
					</div>
					<br>
				</div>
			</div>
		</div>
		<div id="footerWrap">
			<div class="wideContainer">
				<div class="linksWrap">
					<div class="container">
						<div class="row">
							<div class="col-lg-2 col-md-12">
								<div class="logo">
									<a href="http://www.imas.org.sg" target="_blank">
									<img src="images/imaslogo.png" />
								</a>
								
								</div>
							</div>
							<div class="col-lg-2 col-md-6 footer_link">
								<section id="nav_menu-2" class="widget widget_nav_menu">
									<h5><span>Quick Links</span></h5>
									<nav class="menu-quick-links-container" aria-label="Quick Links">
										<ul id="menu-quick-links" class="menu">
											<li id="menu-item-3098" class="menu-item menu-item-type-post_type menu-item-object-page current-page-ancestor menu-item-3098"><a href="https://imas.org.sg/about-imas/">About Us</a>
											</li>
											<li id="menu-item-3100" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3100"><a href="https://imas.org.sg/membership/join-imas/">Membership</a>
											</li>
											<li id="menu-item-3628" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3628"><a href="https://imas.org.sg/advocacy/advocacy/">Advocacy</a>
											</li>
											<li id="menu-item-3629" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3629"><a href="https://imas.org.sg/setting-standards/setting-standards/">Setting Standards</a>
											</li>
											<li id="menu-item-3630" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3630"><a href="https://imas.org.sg/industry-insights/industry-insights/">Industry Insights</a>
											</li>
											<li id="menu-item-3103" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3103"><a href="https://imas.org.sg/digitisation/digitisation/">Digitalisation</a>
											</li>
											<li id="menu-item-3104" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3104"><a href="https://imas.org.sg/education/">Education</a>
											</li>
											<li id="menu-item-3106" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3106"><a href="https://imas.org.sg/events/networking/">Events</a>
											</li>
										</ul>
									</nav>
								</section>
							</div>
							<div class="col-lg-2 col-md-6 footer_link">
								<section id="nav_menu-3" class="widget widget_nav_menu">
									<h5><span>Microsites</span></h5>
									<nav class="menu-microsites-container" aria-label="Microsites">
										<ul id="menu-microsites" class="menu">
											<li id="menu-item-3671" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-3671"><a href="https://www.fundsingapore.com/">FundSingapore</a>
											</li>
											<li id="menu-item-3088" class="menu-item menu-item-type-post_type menu-item-object-page menu-item-3088"><a href="https://imas.org.sg/education/ilearn/">iLearn</a>
											</li>
											<li id="menu-item-3089" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-3089"><a href="https://imasdap.com/">Digital Accelerator Programme</a>
											</li>
											<li id="menu-item-3090" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-3090"><a href="https://imas.org.sg/imasconference2024/">Annual Conference</a>
											</li>
										</ul>
									</nav>
								</section>
							</div>
							<div class="col-lg-2 col-md-6 footer_link">
								<section id="custom_html-2" class="widget_text widget widget_custom_html">
									<h5><span>Follow Us</span></h5>
									<div class="textwidget custom-html-widget"><a href="https://sg.linkedin.com/company/imassgp" target="_blank" rel="noopener"><i class="icon-linkedin"></i></a>
										<!--
<a href="https://twitter.com/imas_sgp?lang=en" target="_blank" rel="noopener"><i class="icon-twitter"></i></a>-->
									</div>
								</section>
							</div>
							<div class="col-lg-2 col-md-6">
								<h5><span>Contact Us</span></h5> 3 Phillip Street<br/> Royal Group Building #07-01<br/> Singapore 048693<br/><br><b>Email:</b> <a href="mailto:enquiries@imas.org.sg">enquiries@imas.org.sg</a><br>
								<b>Tel:</b> +65 6223 9353<br/>
								<b>Fax:</b> +65 6223 9352
							</div>
						</div>
					</div>
				</div>
				<div class="copyright">
					<div class="txt">© 2021 Investment Management Association of Singapore</div>
					<div class="floatRight ">
						<section id="custom_html-3" class="widget_text widget widget_custom_html">
							<div class="textwidget custom-html-widget"><a href="https://imas.org.sg/terms-of-use/" class="link">Terms of use</a> | <a href="https://imas.org.sg/privacy-pdpa-policy/" class="link">Privacy & PDPA Policy</a> </div>
						</section>
					</div>
				</div>
			</div>
		</div>
		<link href="css/custom.css" rel="stylesheet" type="text/css"/>
		<script>
			
			<?php if($_SESSION['add_bookmark'] == 1): ?>
				
				$(document).ready(function(){
						 alert('Added to your bookmark list.');
				});
				<?php unset($_SESSION['add_bookmark']); ?>
			<?php endif; ?>
			
			
			<?php if($_SESSION['delete_bookmark'] == 1): ?>
				
				$(document).ready(function(){
						 alert('Removed from your bookmark list.');
				});
				<?php unset($_SESSION['delete_bookmark']); ?>
			<?php endif; ?>
			
			<?php if($_SESSION['exceed'] == 1): ?>
				
	$(document).ready(function(){
			 alert('Maximum Comparsion is 3 items');
		
	});
			<?php endif; ?>
		
		  $( function() {
				function split( val ) {
				  return val.split( /,\s*/ );
				}
				function extractLast( term ) {
				  return split( term ).pop();
				}
				$( ".search_input2" )
				  // don't navigate away from the field on tab when selecting an item
				  .on( "keydown", function( event ) {
					if ( event.keyCode === $.ui.keyCode.TAB &&
						$( this ).autocomplete( "instance" ).menu.active ) {
					  event.preventDefault();
					}
				  })
				  .autocomplete({
					source: function( request, response ) {
					  $.getJSON( "<?php echo home_url();?>/search_ajax.php", {
						term: extractLast( request.term )
					  }, response );
					},
					search: function() {
					  // custom minLength
					  var term = extractLast( this.value );
					  if ( term.length < 2 ) {
						return false;
					  }
					},
					focus: function() {
					  // prevent value inserted on focus
					  return false;
					},
					select: function( event, ui ) {
					  var terms = split( this.value );
					  // remove the current input
					  terms.pop();
					  // add the selected item
					  terms.push( ui.item.value );
						
					  // add placeholder to get the comma-and-space at the end
					  terms.push( "" );
					  this.value = ui.item.value;
					  return false;
					}
				  });
			  } );
		</script>
		<?php wp_footer(); ?>
</body>
</html>