public function getCategoryOrderedapiArray($data)
{
$db = $this->db;
$db->select('cat_id,cat_image,cat_name,cat_title');
$db->from(CATEGORY);
$db->where(array("cat_active" => "1"));
if (isset($data['lastrequesttime']) && isset($data['isinitialrequest'])) {
$time = $data['lastrequesttime'];
if ($data['isinitialrequest'] == 0) {
$db->where(array("cat_modified_date >" => $time));
}
}
if (isset($data['location']) && $data['location'] != '' && stripos($data['location'], "gujarat") === false) {
$location = $data['location'];
} else {
$location = '';
}
$query = $db->get();
$categories = $query->result_array();
$cat_array = array();
foreach ($categories as $category) {
$category['cat_thumb_image'] = image(category_img_path() . @$category['cat_image'], 'cat_icon');
$category['cat_main_image'] = category_img_path() . @$category['cat_image'];
$cat_id = $category['cat_id'] . "-";
$category['cat_ad_count'] = $this->common_model->getAdscount($cat_id, $location);
$cat_array[$category['cat_id']] = $category;
}
$order = json_decode(getSetting("cat_order", true), true);
return $this->orderCategoriesapi($cat_array, $order, $location);
}
?>
<div class="col-lg-12">
<h3>Sub Categories</h3>
<?php
foreach ($subcategory as $cat) {
if (@$cat['category']['cat_name'] != '') {
?>
<div class="col-lg-3 col-sm-6 col-xs-4 subcategory-grid">
<a href="<?php
echo base_url() . "classified/search?location=" . $_COOKIE['gujjucity'] . "&category=" . urlencode($pagecategory['cat_id'] . "-" . @$cat['category']['cat_id'] . "-") . "&q=" . create_slug(@$cat['category']['cat_name']);
?>
">
<div class="thumbnail">
<img src="<?php
echo image(category_img_path() . @$cat['category']['cat_image'], "cat_icon");
?>
" style="height:80px; width:80px;" />
<div class="caption">
<p class="subcategory-name" style="margin-bottom:2px;"><?php
echo @$cat['category']['cat_name'];
?>
</p>
<p class="subcategory-name"><small><?php
echo @$cat['category']['cat_ad_count'];
?>
Ads</small></p>
</div>
</div>
</a>
<input type="text" placeholder="Enter ..." class="form-control validate[required]" name="cat_name" id="cat_name" value="<?php
echo @$category[0]->cat_name;
?>
" >
</div>
<div class='form-group'>
<label for="username">Category Image: </label>
<input type="file" name="cat_image">
</div>
<div class='form-group'>
<?php
if (file_exists(DOC_ROOT_CATEGORY_IMG . @$category[0]->cat_image) && @$category[0]->cat_image != "") {
?>
<img src="<?php
echo image(category_img_path() . @$category[0]->cat_image, 'cat_icon');
?>
" style="height:80px; width:80px;">
<?php
}
?>
</div>
<div class="form-group">
<label>Category Detail:</label>
<textarea type="text" placeholder="Category detail here" class="form-control validate[required]" name="cat_title" id="cat_title"><?php
echo @$category[0]->cat_title;
?>
</textarea>
</div>
public function search()
{
$post = $this->input->get();
if ($post) {
$cats = array();
if (isset($post["p_id"]) && $post["p_id"] != "") {
$this->common_model->db->select("c.cat_name,c.cat_image", FALSE);
$this->common_model->db->from(CATEGORY_C);
$this->common_model->db->join(CATEGORY_CA, "c.cat_parentid = ca.cat_id", 'left');
$where = array("ca.cat_name" => $post["p_id"]);
$this->common_model->db->where($where);
$where = "c.cat_name LIKE '%" . $post['term'] . "%'";
$this->common_model->db->where($where);
$query = $this->common_model->db->get();
$ret = $query->result();
$query->free_result();
} else {
$where = "cat_name LIKE '%" . $post['term'] . "%' AND cat_parentid = 0";
$ret = $this->common_model->selectData(CATEGORY, "cat_name,cat_image", $where);
}
foreach ($ret as $r) {
//$cats[] = '{"c_id":"te","label":"<img src="'.image(category_img_path().$r->cat_image,'cat_icon').'" width="30" height="30"/> '.$r->cat_name.'","value":"'.$r->cat_name.'"}';
$cats[] = '{"c_id":"te","label":"<img src=\'' . image(category_img_path() . $r->cat_image, 'cat_icon') . '\' width=\'30\' height=\'30\'/> ' . $r->cat_name . '","value":"' . $r->cat_name . '"}';
}
echo '[' . implode(",", $cats) . ']';
exit;
}
}
function displayCategory($categories, $order, $root = true)
{
if ($root) {
$html = "<ol id='categoryList' class='products-list product-list-in-box'>";
} else {
$html = "<ol>";
}
foreach ($order as $o) {
$category = $categories[$o['id']];
$html .= '<li class="item" id ="cat-' . $category['cat_id'] . '"><div class="clearfix" >
<div class="product-img">
<img alt="Product Image" src="' . image(category_img_path() . $category['cat_image'], 'cat_icon') . '">
</div>
<div class="product-info">
<a class="product-title" href="javascript:void(0);">' . $category['cat_name'] . '</a>
<span class="pull-right">
<a href="' . site_url('/admin/category/edit/' . $category['cat_id']) . '" class="fa fa-edit"></a>
<a href="javascript:void(0);" onclick="delete_category(' . $category['cat_id'] . ')" class="fa fa-trash-o"></a>
</span>
<span class="product-description">' . character_limiter($category['cat_title'], 54) . '</span>
</div>
</div>';
if (isset($o['children'])) {
$html .= displayCategory($categories, $o['children'], false);
}
$html .= '</li>';
}
$html .= "</ol>";
return $html;
}
public function getCategoryOrderedArray($active = false, $selectOpt = false, $locFilter = false)
{
$db = $this->db;
$db->select('*');
$db->from(CATEGORY);
if ($active) {
$db->where(array("cat_active" => "1"));
}
$query = $db->get();
$categories = $query->result_array();
$cat_array = array();
if ($locFilter == true && isset($_COOKIE['gujjucity']) && $_COOKIE['gujjucity'] != '' && strtolower($_COOKIE['gujjucity']) != 'all gujarat') {
$location = $_COOKIE['gujjucity'];
} else {
$location = '';
}
foreach ($categories as $category) {
$category['cat_thumb_image'] = image(category_img_path() . @$category['cat_image'], 'cat_icon');
$category['cat_main_image'] = category_img_path() . @$category['cat_image'];
$cat_id = $category['cat_id'] . "-";
$category['cat_ad_count'] = $this->common_model->getAdscount($cat_id, $location);
$cat_array[$category['cat_id']] = $category;
}
$order = json_decode(getSetting("cat_order", true), true);
if (!$selectOpt) {
return $this->orderCategories($cat_array, $order, $location);
} else {
return $this->orderSelectBoxCategories($cat_array, $order);
}
}
