<div class="list-group">
<!--<a href="#" class="list-group-item active"> Cras justo odio </a>-->
<?php
$ap_query = $con->prepare("SELECT ap.asso_partner_id, ap.asso_partner_name, ap.asso_partner_details, ap.asso_partner_contact,\r\n\t\t\t\tap.asso_partner_url, ap.asso_partner_status, ap.asso_partner_img, at.asso_name\r\n\t\t\t\tFROM associate_partner AS ap\r\n\t\t\t\tINNER JOIN associate_type AS at ON at.associate_type_id = ap.associate_type_id\r\n\t\t\t\tWHERE ap.asso_partner_status =:asso_partner_status ");
$ap_query->execute(array(':asso_partner_status' => 1));
while ($row = $ap_query->fetch(PDO::FETCH_ASSOC)) {
echo '<a href="' . ASSOCIATE_CLIENT_PAGE . '&AssoName=' . add_underscore_to_str($row['asso_partner_name']) . '" class="list-group-item">
<span class="glyphicon glyphicon glyphicon-ok"></span>
<span class="heading_color"><b>' . $row['asso_partner_name'] . '</b></span>
</a>';
}
?>
</div>
<div class="row" >
<div class="col-md-12">
<?php
$article_query = $con->prepare("SELECT a.article_id, a.a_code, a.a_title, a.a_desc, a.a_img, a.a_status, ac.ac_code\r\n\t\t\t\t\t\t\t\tFROM article_mst AS a\r\n\t\t\t\t\t\t\t\tINNER JOIN article_category AS ac ON ac.art_cat_id = a.art_cat_id\r\n\t\t\t\t\t\t\t\tWHERE a.a_status =:a_status AND ac.ac_code=:ac_code ");
$article_query->execute(array(':a_status' => 1, ':ac_code' => 'ABOUTUS'));
echo '<h5 class="heading_color"><strong>About us</strong></h5>';
echo '<div class="gradient_border" style="width:100%"></div>';
while ($row = $article_query->fetch(PDO::FETCH_ASSOC)) {
echo '<div class="col-sm-6 col-md-4">
<div class="panel panel-info">
<div class="panel-heading"><span class="heading_color"><b>' . $row['a_title'] . '</b></span></div>
<div class="panel-body" style="line-height:25px; font-size:14px;">
<p style="text-align:justify;">
' . substr($row['a_desc'], 0, 150) . '
<p>
<p><a href="' . ABOUTUS_PAGE . '&ArtTitle=' . add_underscore_to_str($row['a_title']) . '" role="button">Read more...</a></p>
</div>
</div>
</div>';
}
/*echo '<ul class="view_all_list">';
while($row = $article_query->fetch(PDO::FETCH_ASSOC)){
echo '<li><a href="'.ABOUTUS_PAGE.'&ArtTitle='.add_underscore_to_str($row['a_title']).'">';
echo ' <div class="view_all_list_details">
<span>'.$row['a_title'].'</span>
<span>'.substr($row['a_desc'],0,200).'</span>
</div>';
if(!empty($row['a_img'])){
echo '<div class="view_all_list_img">
<img src="files/article/'.$row['a_img'].'" alt="">
<div class="img_vticker_view">
<ul id="img_vticker">
<?php
/*$query_asso_part = $con->prepare("SELECT * FROM associate_partner");
$query_asso_part->execute();
while($row = $query_asso_part->fetch()){
echo '<li><a class="popup_img" href="'.ASSOCIATE_CLIENT_PAGE.'&AssoName='.add_underscore_to_str($row['asso_partner_name']).'" target="_blank">';
echo '<img title="'.$row['asso_partner_name'].'" alt="" src="files/associate_partner/'.$row['asso_partner_img'].'">';
echo '<span style="position:absolute; padding:5px 0px 0px 0px; display:block; font-size:12px; bottom:1px; left:0; width:100%; text-align:center;">'.$row['asso_partner_name'].'</span>';
echo '</a></li>';
}*/
$vticker_cp_query = $con->prepare("SELECT a.article_id, a.a_code, a.a_title, a.a_desc, a.a_img, a.a_status, ac.ac_code\r\n\t\t\t\t\t\t\t\tFROM article_mst AS a\r\n\t\t\t\t\t\t\t\tINNER JOIN article_category AS ac ON ac.art_cat_id = a.art_cat_id\r\n\t\t\t\t\t\t\t\tWHERE a.a_status =:a_status AND ac.ac_code=:ac_code ");
$vticker_cp_query->execute(array(':a_status' => 1, ':ac_code' => 'CPROJECT'));
while ($row = $vticker_cp_query->fetch()) {
echo '<li><a class="popup_img" href="' . CURRENT_PROJECT_PAGE . '&ArtTitle=' . add_underscore_to_str($row['a_title']) . '" target="_blank">';
echo '<img title="' . $row['a_title'] . '" alt="" src="files/article/' . $row['a_img'] . '">';
echo '<span style="position:absolute; padding:5px 0px 0px 0px; display:block; font-size:12px; bottom:1px; left:0; width:100%; text-align:center;">' . $row['a_title'] . '</span>';
echo '</a></li>';
}
?>
</ul>
</div>
<div class="img_vticker_view">
<ul id="img_vticker">
<?php
$query_asso_part = $con->prepare("SELECT * FROM associate_partner");
$query_asso_part->execute();
while ($row = $query_asso_part->fetch()) {
echo '<li><a class="popup_img" href="' . ASSOCIATE_CLIENT_PAGE . '&AssoName=' . add_underscore_to_str($row['asso_partner_name']) . '" target="_blank">';
echo '<img title="' . $row['asso_partner_name'] . '" alt="" src="files/associate_partner/' . $row['asso_partner_img'] . '">';
echo '<span style="position:absolute; padding:5px 0px 0px 0px; display:block; font-size:12px; bottom:1px; left:0; width:100%; text-align:center;">' . $row['asso_partner_name'] . '</span>';
echo '</a></li>';
}
?>
</ul>
</div>
</div><?php
//For product category name and switching between list & grid
?>
<!--<div class="row"><div class="well">All Product</div></div>-->
<div class="gradient_border" style="width:100%"></div>
<div class="row" >
<div class="col-md-12">
<?php
/*Query from product_script.php*/
//echo '<div style=" display:block; height:auto; overflow:hidden;">';
echo '<ul class="product_view list">';
while ($row = $query_item->fetch(PDO::FETCH_ASSOC)) {
echo '<li><a style="" href="' . PRODUCT_PAGE . '&ItemName=' . add_underscore_to_str($row['i_name']) . '">';
echo '<div class="row">';
$query_item_img = $con->prepare("SELECT item_id, i_img FROM item_images \r\n\t\t\t\t\t\t\t\t\t\tWHERE item_id=" . $row['item_id'] . " LIMIT 1");
$query_item_img->execute();
while ($row1 = $query_item_img->fetch(PDO::FETCH_ASSOC)) {
echo '<div class="col-md-3 list_left grid_left"><img class="img-thumbnail" src="files/items/' . $row1['i_img'] . '" alt=""></div>';
}
echo ' <div class="col-md-6 list_mid grid_mid" style="color:#000">
<div class="product_name_style" ><h4>' . $row['i_name'] . '</h4></div>
<p>' . $row['i_cat_name'] . ' > ' . $row['sub_category'] . '</p>
<p>';
if ($row['i_available'] == 1) {
echo 'Available';
} else {
echo 'Unavailable';
}
echo '<ul>';
echo '</div>';
//for product category
$item_category_query = $con->prepare("SELECT i_cat_id, i_cat_name AS CatName FROM item_category");
$item_category_query->execute();
echo '<div class="product_filter_row">';
echo '<div class="titel_head" style="background: #FCFCFC;">
<h4>CATEGORY</h4>
<div class="gradient_border" style="width:98%"></div>
</div>';
echo '<ul class="category_list">';
while ($row = $item_category_query->fetch(PDO::FETCH_ASSOC)) {
$ItemCount_for_cat = $con->prepare("SELECT COUNT(i.item_id) AS ItemCount\r\n\t\t\t\t\t\tFROM item_mst AS i\r\n\t\t\t\t\t\tINNER JOIN j_item_sub_cat AS jisc ON jisc.item_id = i.item_id\r\n\t\t\t\t\t\tINNER JOIN item_sub_category AS isc ON isc.i_sub_cat_id = jisc.i_sub_cat_id\r\n\t\t\t\t\t\tINNER JOIN item_category AS ic ON ic.i_cat_id = isc.i_cat_id\r\n\t\t\t\t\t\tWHERE ic.i_cat_id=" . $row['i_cat_id']);
$ItemCount_for_cat->execute();
$ItemCount_for_cat = $ItemCount_for_cat->fetch(PDO::FETCH_ASSOC);
//echo '<li class="category_list_item"><a id="'.add_underscore_to_str($row['CatName']).'" href="#">'.$row['CatName'].' <span style="color:#03b;">('.$ItemCount_for_cat['ItemCount'].')<span></a>';
echo '<li class="category_list_item"><a style="color: #03b;" id="' . add_underscore_to_str($row['CatName']) . '" href="' . PRODUCT_PAGE . '&CatName=' . add_underscore_to_str($row['CatName']) . '" >' . $row['CatName'] . ' <span style="color:#03b;">(' . $ItemCount_for_cat['ItemCount'] . ')</span></a>';
$item_sub_cat_query = $con->prepare("SELECT i_sub_cat_id AS SubCatId, sub_category AS SubCatName FROM item_sub_category WHERE i_cat_id=" . $row['i_cat_id']);
$item_sub_cat_query->execute();
echo '<ul class="sub_cat_list">';
while ($row = $item_sub_cat_query->fetch(PDO::FETCH_ASSOC)) {
$ItemCount_for_sub_cat = $con->prepare("SELECT COUNT(i.item_id) AS ItemCount\r\n\t\t\t\t\t\t\t\t\tFROM item_mst AS i\r\n\t\t\t\t\t\t\t\t\tINNER JOIN j_item_sub_cat AS jisc ON jisc.item_id = i.item_id\r\n\t\t\t\t\t\t\t\t\tINNER JOIN item_sub_category AS isc ON isc.i_sub_cat_id = jisc.i_sub_cat_id\r\n\t\t\t\t\t\t\t\t\tWHERE jisc.i_sub_cat_id=" . $row['SubCatId']);
$ItemCount_for_sub_cat->execute();
$ItemCount_for_sub_cat = $ItemCount_for_sub_cat->fetch(PDO::FETCH_ASSOC);
echo '<li><a class="sub_cat_list_name" style="color: #03b;" id="' . add_underscore_to_str($row['SubCatName']) . '" href="' . PRODUCT_PAGE . '&SubCatName=' . add_underscore_to_str($row['SubCatName']) . '" title=""> <div class="right_arrow_icon"></div> ' . $row['SubCatName'] . ' <span style="color:#03b;">(' . $ItemCount_for_sub_cat['ItemCount'] . ')</span></a></li>';
}
echo '</ul><!--End sub-cat_list-->';
echo '</li><!--End category_list_item-->';
}
echo '</ul><!--End category_list-->';
echo '</div><!--End product_filter_area-->';
<div class="row" >
<div class="col-md-12">
<?php
echo '<h5 class="heading_color"><strong>All the News Here.</strong></h5>';
echo '<div class="gradient_border" style="width:100%"></div>';
$art_year_query = $con->prepare("SELECT a.article_id, year(a.a_pdate) AS OrderYear, ac.ac_code\n\t\t\t\t\t\t\t\tFROM article_mst AS a\n\t\t\t\t\t\t\t\tINNER JOIN article_category AS ac ON ac.art_cat_id = a.art_cat_id\n\t\t\t\t\t\t\t\tWHERE a.a_status =:a_status AND ac.ac_code=:ac_code\n\t\t\t\t\t\t\t\tGROUP BY OrderYear desc");
$art_year_query->execute(array(':a_status' => 1, ':ac_code' => 'NEWS'));
echo '<ul>';
while ($row = $art_year_query->fetch(PDO::FETCH_ASSOC)) {
echo '<li style="list-style:none; margin-left:50px; color:#CD2122;"><h3><small></small> ' . $row['OrderYear'] . '</h3><ul>';
$art_t_query = $con->prepare("SELECT a.article_id, a.a_pdate, a.a_code, a.a_title, a.a_desc, a.a_img, a.a_status, ac.ac_code\n\t\t\t\t\t\t\t\tFROM article_mst AS a\n\t\t\t\t\t\t\t\tINNER JOIN article_category AS ac ON ac.art_cat_id = a.art_cat_id\n\t\t\t\t\t\t\t\tWHERE a.a_status =:a_status AND ac.ac_code=:ac_code AND year(a.a_pdate)=:OrderYear ");
$art_t_query->execute(array(':a_status' => 1, ':ac_code' => 'NEWS', ':OrderYear' => $row['OrderYear']));
while ($row = $art_t_query->fetch(PDO::FETCH_ASSOC)) {
echo '<li style="list-style:none; margin-left:30px; padding:5px; color:#70A9C4;">
<h4><small><span class="glyphicon glyphicon-chevron-right" style="color:#968896;"></span></small>
<a href="' . NEWS_PAGE . '&ArtTitle=' . add_underscore_to_str($row['a_title']) . '" style="text-decoration:none; color:#968896;"> ' . $row['a_title'] . '</a>
</h4>
</li>';
}
echo '</ul></li>';
}
echo '</ul>';
/*$article_query = $con->prepare("SELECT a.article_id, a.a_code, a.a_title, a.a_desc, a.a_img, a.a_status, ac.ac_code
FROM article_mst AS a
INNER JOIN article_category AS ac ON ac.art_cat_id = a.art_cat_id
WHERE a.a_status =:a_status AND ac.ac_code=:ac_code ");
$article_query->execute(array(':a_status'=>1, ':ac_code'=>'NEWS'));
echo '<h5 class="heading_color"><strong>All the News Here.</strong></h5>';
echo '<div class="gradient_border" style="width:100%"></div>';
<div class="list-group">
<!--<a href="#" class="list-group-item active"> Cras justo odio </a>-->
<?php
$article_query = $con->prepare("SELECT a.article_id, a.a_code, a.a_title, a.a_desc, a.a_img, a.a_status, ac.ac_code\r\n\t\t\t\tFROM article_mst AS a\r\n\t\t\t\tINNER JOIN article_category AS ac ON ac.art_cat_id = a.art_cat_id\r\n\t\t\t\tWHERE a.a_status =:a_status AND ac.ac_code=:ac_code ");
$article_query->execute(array(':a_status' => 1, ':ac_code' => 'NEWS'));
while ($row = $article_query->fetch(PDO::FETCH_ASSOC)) {
echo '<a href="' . NEWS_PAGE . '&ArtTitle=' . add_underscore_to_str($row['a_title']) . '" class="list-group-item">
<span class="glyphicon glyphicon-chevron-right"></span>
<span class=""><b>' . ucfirst($row['a_title']) . '</b></span>
</a>';
}
?>
</div>
<div class="img_vticker_area">
<div class="img_vticker_container">
<!--<div class="img_vticker_name">
<h2 style="font-family: arial, helvetica, sans-serif; color:#505050; font-size:22px; padding:20px;">Greentext Clients</h2>
</div>-->
<div class="img_vticker_view">
<ul id="img_vticker" style="">
<?php
$query_item = $con->prepare("SELECT i.item_id, i.i_code, i.i_name, i.i_available, i.i_details, i.adate, ib.brand_name, iut.i_user_type, ic.i_cat_name, isc.sub_category\r\n\t\t\t\t\t\tFROM item_mst AS i\r\n\t\t\t\t\t\tINNER JOIN j_item_sub_cat AS jisc ON jisc.item_id = i.item_id\r\n\t\t\t\t\t\tINNER JOIN item_sub_category AS isc ON isc.i_sub_cat_id = jisc.i_sub_cat_id\r\n\t\t\t\t\t\tINNER JOIN item_category AS ic ON ic.i_cat_id = isc.i_cat_id\r\n\t\t\t\t\t\tLEFT JOIN item_brand AS ib ON ib.brand_id = i.brand_id\r\n\t\t\t\t\t\tLEFT JOIN item_user_type AS iut ON iut.i_user_type_id = i.i_user_type_id\t\t\t\t\t\r\n\t\t\t\t\t\tORDER BY RAND(), i.adate DESC LIMIT 100");
$query_item->execute();
while ($row = $query_item->fetch()) {
echo '<li><a class="popup_img" href="' . PRODUCT_PAGE . '&ItemName=' . add_underscore_to_str($row['i_name']) . '">';
$query_item_img = $con->prepare("SELECT item_id, i_img FROM item_images WHERE item_id=" . $row['item_id'] . " LIMIT 1");
$query_item_img->execute();
while ($row1 = $query_item_img->fetch(PDO::FETCH_ASSOC)) {
echo '<img title="' . $row['i_name'] . '" alt="" src="files/items/' . $row1['i_img'] . '">';
//echo ' <div class="product_list_img"><img src="files/items/'.$row1['i_img'].'" alt=""></div>';
}
echo '<div style="position:absolute; padding:5px 0px 0px 0px; display:block; font-size:12px; bottom:1px; left:0; width:100%; text-align:center;">';
echo '<div>' . $row['i_name'] . '</div>';
echo '<div>' . $row['i_cat_name'] . ' > ' . $row['sub_category'] . '</div>';
echo '</div>';
//echo '<span style="position:absolute; padding:5px 0px 0px 0px; display:block; font-size:12px; bottom:1px; left:0; width:100%; text-align:center;">'.$row['i_name'].'</span>';
//echo '<span style="position:absolute; padding:5px 0px 0px 0px; display:block; font-size:12px; bottom:1px; left:0; width:100%; text-align:center;">'.$row['i_cat_name'].'</span>';
echo '</a></li>';
}
?>
</ul>
</div>
</div>
</div>
echo '<div class="gradient_border" style="width:100%"></div>';
while ($row = $ap_query->fetch(PDO::FETCH_ASSOC)) {
//echo '<div class="row">
echo '<div class="col-sm-6 col-md-4">
<div class="thumbnail">
<img ';
if (!empty($row['asso_partner_img'])) {
echo 'src="files/associate_partner/' . $row['asso_partner_img'] . '"';
} else {
echo 'src="' . NO_IMG . '"';
}
echo ' style="height:80px;">
<div class="caption">
<h3>' . $row['asso_partner_name'] . '</h3>
<p style="height:80px;">' . substr($row['asso_partner_details'], 0, 100) . '</p>
<p><a href="' . ASSOCIATE_CLIENT_PAGE . '&AssoName=' . add_underscore_to_str($row['asso_partner_name']) . '">View details...</a></p>
</div>
</div>
</div>';
//</div>';
}
/*echo '<ul class="view_all_list">';
while($row = $ap_query->fetch(PDO::FETCH_ASSOC)){
echo '<li><a href="'.ASSOCIATE_CLIENT_PAGE.'&AssoName='.add_underscore_to_str($row['asso_partner_name']).'">';
echo '<div class="row">
<div class="col-md-9">
<span>'.$row['asso_partner_name'].'</span>
<span>'.substr($row['asso_partner_details'],0,200).'</span>
</div>';//end col-8
$article_query = $con->prepare("SELECT a.article_id, a.a_code, a.a_title, a.a_desc, a.a_img, a.a_status, ac.ac_code\r\n\t\t\t\t\t\t\t\tFROM article_mst AS a\r\n\t\t\t\t\t\t\t\tINNER JOIN article_category AS ac ON ac.art_cat_id = a.art_cat_id\r\n\t\t\t\t\t\t\t\tWHERE a.a_status =:a_status AND ac.ac_code=:ac_code ");
$article_query->execute(array(':a_status' => 1, ':ac_code' => 'CPROJECT'));
echo '<h5 class="heading_color"><strong>Current Project\'s</strong></h5>';
echo '<div class="gradient_border" style="width:100%"></div>';
while ($row = $article_query->fetch(PDO::FETCH_ASSOC)) {
//echo '<div class="row">
echo '<div class="col-sm-6 col-md-4">
<div class="thumbnail">
<img ';
if (!empty($row['a_img'])) {
echo 'src="files/article/' . $row['a_img'] . '"';
} else {
echo 'src="' . NO_IMG . '"';
}
echo ' style="height:150px; width:80%;">
<div class="caption">
<h4 style="height:40px;">' . $row['a_title'] . '</h4>
<p style="height:80px;">' . substr($row['a_desc'], 0, 80) . '</p>
<p><a href="' . CURRENT_PROJECT_PAGE . '&ArtTitle=' . add_underscore_to_str($row['a_title']) . '">View details...</a></p>
</div>
</div>
</div>';
//</div>';
}
?>
</div>
</div>
</div><!--End Col-->
</div><!--End row-->
</br></br>
<div class="panel-body">
<div class="row">
<div class="col-xs-12">
<ul class="newsbox_vticker">
<?php
$news_art = $con->prepare("SELECT a.article_id, a.a_code, a.a_title, a.a_desc, a.a_img, a.a_status, ac.ac_code\r\n\t\t\t\t\t\t\t\tFROM article_mst AS a\r\n\t\t\t\t\t\t\t\tINNER JOIN article_category AS ac ON ac.art_cat_id = a.art_cat_id\r\n\t\t\t\t\t\t\t\tWHERE a.a_status =:a_status AND ac.ac_code=:ac_code ");
$news_art->execute(array(':a_status' => 1, ':ac_code' => 'NEWS'));
while ($row = $news_art->fetch(PDO::FETCH_ASSOC)) {
echo '<li class="news-item">
<table cellpadding="4">
<tr>
<td><img src="files/article/' . $row['a_img'] . '" width="60" class="img-circle" /></td>
<td>
<Strong>' . $row['a_title'] . '</strong><br>
<p>' . substr($row['a_desc'], 0, 80) . '</p>
<a href="' . NEWS_PAGE . '&News=' . add_underscore_to_str($row['a_title']) . '">Read more...</a>
</td>
</tr>
</table>
</li>';
}
?>
</ul>
</div>
</div>
</div>
<div class="panel-footer"> </div>
</div>
