File: /var/www/html/tmpr/../tmpr/../tmpr/../tmpr/../iapi/application/models/Category_model.php
<?php defined('BASEPATH') or exit('No direct script access allowed');
class Category_model extends CI_Model
{
//build query
public function build_query($lang_id, $all_columns = false)
{
if ($all_columns == true) {
$this->db->select('h_categories.*, h_categories.parent_id AS join_parent_id');
} else {
$this->db->select('h_categories.id, h_categories.slug, h_categories.parent_id, h_categories.parent_tree, h_categories.category_order, h_categories.featured_order, h_categories.storage, h_categories.image, h_categories.show_image_on_navigation, h_categories.parent_id AS join_parent_id');
}
$this->db->select('(SELECT name FROM h_categories_lang WHERE h_categories_lang.category_id = h_categories.id AND h_categories_lang.lang_id = ' . clean_number($lang_id) . ' LIMIT 1) AS name');
if (item_count($this->languages) > 1) {
$this->db->select('(SELECT name FROM h_categories_lang WHERE h_categories_lang.category_id = h_categories.id AND h_categories_lang.lang_id != ' . clean_number($lang_id) . ' LIMIT 1) AS second_name');
}
$this->db->select('(SELECT slug FROM h_categories WHERE id = join_parent_id) AS parent_slug');
$this->db->select('(SELECT id FROM h_categories AS sub_categories WHERE sub_categories.parent_id = h_categories.id LIMIT 1) AS has_subcategory');
}
//get categories array
public function get_categories_array()
{
$max_level = 3;
if ($this->general_settings->selected_navigation != 1) {
$max_level = 4;
}
$key = "categories_array_lang_" . $this->selected_lang->id . "_level_" . $max_level;
$array = get_cached_data($this, $key, "st");
if (!empty($array)) {
return $array;
}
$rows = $this->category_model->get_categories_by_level($this->selected_lang->id, $max_level);
if (!empty($rows)) {
$array = array();
foreach ($rows as $row) {
$array[$row->parent_id][] = $row;
}
if ($this->general_settings->sort_parent_categories_by_order == 1 && !empty($array[0])) {
usort($array[0], function ($a, $b) {
if ($a->category_order == $b->category_order) return 0;
return $a->category_order > $b->category_order ? 1 : -1;
});
}
set_cache_data($this, $key, $array, "st");
return $array;
}
return null;
}
//get categories by level
public function get_categories_by_level($lang_id, $max_level)
{
$level1 = $this->db->select('id')->from('h_categories')->where('parent_id', 0)->get_compiled_select();
$this->db->reset_query();
$level2 = $this->db->select('id')->from('h_categories')->where_in('parent_id', $level1, FALSE)->get_compiled_select();
$this->db->reset_query();
$level3 = $this->db->select('id')->from('h_categories')->where_in('parent_id', $level2, FALSE)->get_compiled_select();
$this->db->reset_query();
$level4 = $this->db->select('id')->from('h_categories')->where_in('parent_id', $level3, FALSE)->get_compiled_select();
$this->db->reset_query();
$this->build_query($lang_id);
$this->db->where('visibility', 1);
$this->db->group_start();
if ($max_level <= 1) {
$this->db->where_in('h_categories.id', $level1, FALSE);
} elseif ($max_level == 2) {
$this->db->where_in('h_categories.id', $level1, FALSE);
$this->db->or_where_in('h_categories.id', $level2, FALSE);
} elseif ($max_level == 3) {
$this->db->where_in('h_categories.id', $level1, FALSE);
$this->db->or_where_in('h_categories.id', $level2, FALSE);
$this->db->or_where_in('h_categories.id', $level3, FALSE);
} elseif ($max_level == 4) {
$this->db->where_in('h_categories.id', $level1, FALSE);
$this->db->or_where_in('h_categories.id', $level2, FALSE);
$this->db->or_where_in('h_categories.id', $level3, FALSE);
$this->db->or_where_in('h_categories.id', $level4, FALSE);
}
$this->db->group_end();
$this->order_by_categories();
return $this->db->get('h_categories')->result();
}
//get subcategories
public function get_subcategories($parent_id)
{
$key = "subcategories_lang_" . $this->selected_lang->id;
$result_cache = get_cached_data($this, $key, "st");
if (!empty($result_cache)) {
if (!empty($result_cache[$parent_id])) {
return $result_cache[$parent_id];
}
} else {
$result_cache = array();
}
$this->build_query($this->selected_lang->id, true);
$this->db->where('h_categories.parent_id', clean_number($parent_id))->where('visibility', 1);
$this->order_by_categories();
$result = $this->db->get('h_categories')->result();
$result_cache[$parent_id] = $result;
set_cache_data($this, $key, $result_cache, "st");
return $result;
}
//get category
public function get_category($id)
{
$this->build_query($this->selected_lang->id, true);
$this->db->where('h_categories.id', clean_number($id));
$query = $this->db->get('h_categories');
return $query->row();
}
//get category by slug
public function get_category_by_slug($slug)
{
$this->build_query($this->selected_lang->id, true);
$this->db->where('visibility', 1)->where('h_categories.slug', clean_str($slug))->limit(1);
$query = $this->db->get('h_categories');
return $query->row();
}
//get all categories ordered by name
public function get_categories_ordered_by_name()
{
$key = "categories_ordered_by_name_lang_" . $this->selected_lang->id;
$result = get_cached_data($this, $key, "st");
if (!empty($result)) {
return $result;
}
$this->build_query($this->selected_lang->id);
$this->db->where('visibility', 1);
$this->db->order_by('name');
$result = $this->db->get('h_categories')->result();
set_cache_data($this, $key, $result, "st");
return $result;
}
//get parent category by slug
public function get_parent_category_by_slug($slug)
{
$this->build_query($this->selected_lang->id, true);
$this->db->where('h_categories.slug', clean_str($slug))->where('visibility', 1)->where('parent_id', 0);
$this->db->order_by('id')->limit(1);
$query = $this->db->get('h_categories');
return $query->row();
}
//get featured categories
public function get_featured_categories()
{
$key = "featured_categories_lang_" . $this->selected_lang->id;
$result = get_cached_data($this, $key, "st");
if (!empty($result)) {
return $result;
}
$this->build_query($this->selected_lang->id, true);
$this->db->where('visibility', 1)->where('is_featured', 1);
$this->db->order_by('featured_order');
$result = $this->db->get('h_categories')->result();
set_cache_data($this, $key, $result, "st");
return $result;
}
//get index categories
public function get_index_categories()
{
$key = "index_categories_lang_" . $this->selected_lang->id;
$result = get_cached_data($this, $key, "st");
if (!empty($result)) {
return $result;
}
$this->build_query($this->selected_lang->id, true);
$this->db->where('visibility', 1)->where('show_products_on_index', 1);
$this->db->order_by('homepage_order');
$result = $this->db->get('h_categories')->result();
set_cache_data($this, $key, $result, "st");
return $result;
}
//get product categories
public function get_product_categories($category = null, $vendor_id = null, $only_has_products = true)
{
$categories = array();
$category_ids = array();
$subcategory_ids = array();
if ($only_has_products == true) {
if (!empty($vendor_id)) {
$this->db->where('h_categories.id IN (SELECT category FROM profilepicture WHERE profilepicture.status = 1 AND profilepicture.visibility = 1 AND profilepicture.is_draft = 0 AND profilepicture.is_deleted = 0 AND catalogid = ' . clean_number($vendor_id) . ')');
} else {
$this->db->where('h_categories.id IN (SELECT category FROM profilepicture WHERE profilepicture.status = 1 AND profilepicture.visibility = 1 AND profilepicture.is_draft = 0 AND profilepicture.is_deleted = 0)');
}
}
if (!empty($category)) {
$this->db->where('FIND_IN_SET(' . $category->id . ', h_categories.parent_tree)');
}
$result = $this->db->get('h_categories')->result();
if (!empty($result)) {
foreach ($result as $item) {
if (!in_array($item->id, $category_ids)) {
array_push($category_ids, $item->id);
}
if (!in_array($item->id, $subcategory_ids)) {
array_push($subcategory_ids, $item->id);
}
if (!empty($item->parent_tree)) {
$array = explode(',', $item->parent_tree);
if (!empty($array)) {
foreach ($array as $id) {
$id = intval($id);
if (!in_array($id, $category_ids)) {
array_push($category_ids, $id);
}
}
}
}
}
}
if (!empty($category)) {
array_push($subcategory_ids, $category->id);
}
$parent_id = 0;
if (!empty($category)) {
$parent_id = $category->id;
}
if (!empty($category_ids)) {
$this->build_query($this->selected_lang->id, true);
$this->db->where_in('id', $category_ids, FALSE);
$this->db->where('visibility', 1);
$this->db->where('parent_id', $parent_id);
$categories = $this->db->get('h_categories')->result();
}
if (empty($categories)) {
array_push($categories, $category);
}
return array('categories' => $categories, 'category_ids' => $category_ids, 'subcategory_ids' => $subcategory_ids);
}
//get parent categories tree
public function get_parent_categories_tree($category, $only_visible = true)
{
if (empty($category)) {
return array();
}
//get cached data
$key = "parent_categories_tree_all";
if ($only_visible == true) {
$key = "parent_categories_tree";
}
$key = $key . "_lang_" . $this->selected_lang->id;
$result_cache = get_cached_data($this, $key, "st");
if (!empty($result_cache)) {
if (!empty($result_cache[$category->id])) {
return $result_cache[$category->id];
}
} else {
$result_cache = array();
}
$parent_tree = $category->parent_tree;
$ids = array();
$str_sort = "";
if (!empty($parent_tree)) {
$array = explode(',', $parent_tree);
if (!empty($array)) {
foreach ($array as $item) {
array_push($ids, intval($item));
if ($str_sort == "") {
$str_sort = intval($item);
} else {
$str_sort .= "," . intval($item);
}
}
}
}
if (!in_array($category->id, $ids)) {
array_push($ids, $category->id);
if ($str_sort == "") {
$str_sort = $category->id;
} else {
$str_sort .= "," . $category->id;
}
}
$this->build_query($this->selected_lang->id, true);
$this->db->where_in('h_categories.id', $ids, FALSE);
if ($only_visible == true) {
$this->db->where('h_categories.visibility', 1);
}
$this->db->order_by('FIELD(id, ' . $str_sort . ')');
$result = $this->db->get('h_categories')->result();
$result_cache[$category->id] = $result;
set_cache_data($this, $key, $result_cache, "st");
return $result;
}
//get subcategories tree ids
public function get_subcategories_tree_ids($category_id, $only_visible = false, $cache = true)
{
if ($cache == true) {
$result_cache = get_cached_data($this, "subcategories_tree_ids", "st");
if (!empty($result_cache)) {
if (!empty($result_cache[$category_id])) {
return $result_cache[$category_id];
}
}
if (empty($result_cache)) {
$result_cache = array();
}
}
$sql = "SELECT id FROM h_categories WHERE FIND_IN_SET(?, h_categories.parent_tree)";
if ($only_visible == true) {
$sql .= " AND h_categories.visibility = 1";
}
$result = $this->db->query($sql, clean_number($category_id))->result();
$array = array();
array_push($array, $category_id);
if (!empty($result)) {
foreach ($result as $item) {
array_push($array, $item->id);
}
}
if ($cache == true) {
$result_cache[$category_id] = $array;
set_cache_data($this, "subcategories_tree_ids", $result_cache, "st");
}
return $array;
}
//sort categories
public function order_by_categories()
{
$sort = $this->general_settings->sort_categories;
if ($sort == "date") {
$this->db->order_by('h_categories.created_at');
} elseif ($sort == "date_desc") {
$this->db->order_by('h_categories.created_at', 'DESC');
} elseif ($sort == "alphabetically") {
$this->db->order_by('name');
} else {
$this->db->order_by('category_order, name');
}
}
/*
*-------------------------------------------------------------------------------------------------
* BACK-END
*-------------------------------------------------------------------------------------------------
*/
//input values
public function input_values()
{
$data = array(
'slug' => $this->input->post('slug', true),
'title_meta_tag' => $this->input->post('title_meta_tag', true),
'description' => $this->input->post('description', true),
'keywords' => $this->input->post('keywords', true),
'category_order' => $this->input->post('category_order', true),
'featured_order' => 1,
'visibility' => $this->input->post('visibility', true),
'show_image_on_navigation' => $this->input->post('show_image_on_navigation', true)
);
return $data;
}
//add category
public function add_category()
{
$data = $this->input_values();
//set slug
if (empty($data["slug"])) {
$data["slug"] = str_slug($this->input->post('name_lang_' . $this->general_settings->site_lang, true));
} else {
$data["slug"] = remove_special_characters($data["slug"], true);
}
//set parent id
$data["parent_id"] = 0;
$category_ids_array = $this->input->post('parent_id', true);
if (!empty($category_ids_array)) {
foreach ($category_ids_array as $key => $value) {
if (!empty($value)) {
$data["parent_id"] = $value;
}
}
}
$data["storage"] = "local";
$this->load->model('upload_model');
$temp_path = $this->upload_model->upload_temp_image('file');
$data['image'] = "";
if (!empty($temp_path)) {
$data["image"] = $this->upload_model->category_image_upload($temp_path);
$this->upload_model->delete_temp_image($temp_path);
}
//move to s3
if ($this->storage_settings->storage == "aws_s3") {
$this->load->model("aws_model");
$data["storage"] = "aws_s3";
//move image
if ($data["image"] != "") {
$this->aws_model->put_category_object($data["image"], FCPATH . $data["image"]);
delete_file_from_server($data["image"]);
}
}
$data['is_featured'] = 0;
$data['parent_tree'] = "";
$data['created_at'] = date('Y-m-d H:i:s');
return $this->db->insert('h_categories', $data);
}
//add category name
public function add_category_name($category_id)
{
foreach ($this->languages as $language) {
$data = array(
'category_id' => clean_number($category_id),
'lang_id' => $language->id,
'name' => $this->input->post('name_lang_' . $language->id, true)
);
$this->db->insert('h_categories_lang', $data);
}
}
//update slug
public function update_slug($id)
{
$category = $this->get_category($id);
if (!empty($category)) {
if (empty($category->slug) || $category->slug == "-") {
$data = array(
'slug' => $category->id
);
$this->db->where('id', $category->id);
return $this->db->update('h_categories', $data);
} else {
if (!empty($this->check_category_slug($category->slug, $id))) {
$data = array(
'slug' => $category->slug . "-" . $category->id
);
$this->db->where('id', $category->id);
return $this->db->update('h_categories', $data);
}
}
}
}
//update category parent tree
public function update_category_parent_tree($id)
{
$this->db->select("h_categories.*, h_categories.parent_id AS parent_category_id, (SELECT parent_tree FROM h_categories WHERE id = parent_category_id) AS parent_category_tree");
$category = $this->db->where('id', clean_number($id))->get('h_categories')->row();
if (!empty($category)) {
$parent_tree = "";
if ($category->parent_id != 0) {
if (empty($category->parent_category_tree)) {
$parent_tree = $category->parent_id;
} else {
$parent_tree = $category->parent_category_tree . "," . $category->parent_id;
}
}
$this->db->where('id', $category->id)->update('h_categories', ['parent_tree' => $parent_tree]);
//update all subcategories
$this->update_subcategories_parent_tree($category);
}
}
//recursive update subcategory parent tree
public function update_subcategories_parent_tree($category)
{
if (!empty($category)) {
$this->db->select("h_categories.id, h_categories.parent_id AS parent_category_id, (SELECT parent_tree FROM h_categories WHERE id = parent_category_id) AS parent_category_tree");
$categories = $this->db->where('parent_id', $category->id)->get('h_categories')->result();
if (!empty($categories)) {
foreach ($categories as $item) {
$parent_tree = "";
if ($item->parent_category_id != 0) {
if (empty($item->parent_category_tree)) {
$parent_tree = $item->parent_category_id;
} else {
$parent_tree = $item->parent_category_tree . "," . $item->parent_category_id;
}
}
$this->db->where('id', $item->id)->update('h_categories', ['parent_tree' => $parent_tree]);
$this->update_subcategories_parent_tree($item);
}
}
}
}
//update all categories parent tree
public function update_all_categories_parent_trees()
{
$categories = $this->db->where('parent_id', 0)->get('h_categories')->result();
if (!empty($categories)) {
foreach ($categories as $category) {
//update parent
$this->db->where('id', $category->id)->update('h_categories', ['parent_tree' => '']);
//update all subcategories
$this->update_subcategories_parent_tree($category);
}
}
}
//check category parent trees
public function check_category_parent_trees()
{
$this->db->where('parent_id != ', 0);
$this->db->group_start();
$this->db->where('parent_tree', NULL)->or_where('parent_tree', '');
$this->db->group_end();
$count = $this->db->count_all_results('h_categories');
if ($count > 0) {
$this->update_all_categories_parent_trees();
}
}
//update category
public function update_category($id)
{
$data = $this->input_values();
//set slug
if (empty($data["slug"])) {
$data["slug"] = str_slug($this->input->post('name_lang_' . $this->general_settings->site_lang, true));
} else {
$data["slug"] = remove_special_characters($data["slug"], true);
}
//set parent id
$data["parent_id"] = 0;
$category_ids_array = $this->input->post('parent_id', true);
if (!empty($category_ids_array)) {
foreach ($category_ids_array as $key => $value) {
if (!empty($value)) {
$data["parent_id"] = $value;
}
}
}
$this->load->model('upload_model');
$temp_path = $this->upload_model->upload_temp_image('file');
if (!empty($temp_path)) {
$data["image"] = $this->upload_model->category_image_upload($temp_path);
$this->upload_model->delete_temp_image($temp_path);
$category = $this->get_category($id);
$data["storage"] = "local";
//move to s3
if ($this->storage_settings->storage == "aws_s3") {
$this->load->model("aws_model");
$data["storage"] = "aws_s3";
//move image
$this->aws_model->put_category_object($data["image"], FCPATH . $data["image"]);
delete_file_from_server($data["image"]);
}
//delete old images
if ($category->storage == "aws_s3") {
$this->load->model("aws_model");
$this->aws_model->delete_category_object($category->image);
} else {
delete_file_from_server($category->image);
}
}
$this->db->where('id', clean_number($id));
return $this->db->update('h_categories', $data);
}
//update category name
public function update_category_name($category_id)
{
foreach ($this->languages as $language) {
$data = array(
'category_id' => clean_number($category_id),
'lang_id' => $language->id,
'name' => $this->input->post('name_lang_' . $language->id, true)
);
//check category name exists
$this->db->where('category_id', clean_number($category_id));
$this->db->where('lang_id', $language->id);
$row = $this->db->get('h_categories_lang')->row();
if (empty($row)) {
$this->db->insert('h_categories_lang', $data);
} else {
$this->db->where('category_id', clean_number($category_id));
$this->db->where('lang_id', $language->id);
$this->db->update('h_categories_lang', $data);
}
}
}
//update settings
public function update_settings()
{
$data = array(
'sort_categories' => $this->input->post('sort_categories', true),
'sort_parent_categories_by_order' => $this->input->post('sort_parent_categories_by_order', true)
);
if (empty($data['sort_parent_categories_by_order'])) {
$data['sort_parent_categories_by_order'] = 0;
}
$this->db->where('id', 1);
return $this->db->update('h_general_settings', $data);
}
//check category slug
public function check_category_slug($slug, $id)
{
$sql = "SELECT * FROM h_categories WHERE h_categories.slug = ? AND h_categories.id != ?";
$query = $this->db->query($sql, array(clean_str($slug), clean_number($id)));
return $query->row();
}
//get category back end
public function get_category_back_end($id)
{
$this->build_query($this->selected_lang->id, true);
$this->db->where('h_categories.id', clean_number($id));
$query = $this->db->get('h_categories');
return $query->row();
}
//get category by lang
public function get_category_by_lang($id, $lang_id)
{
$this->db->where('category_id', clean_number($id));
$this->db->where('lang_id', clean_number($lang_id));
$query = $this->db->get('h_categories_lang');
return $query->row();
}
//get subcategories by parent id except one
public function get_subcategories_by_parent_id_except_one($parent_id, $except_id)
{
$this->build_query($this->selected_lang->id, true);
$this->db->where('visibility', 1)->where('h_categories.parent_id', clean_number($parent_id))->where('h_categories.id != ', clean_number($except_id));
$this->db->order_by('category_order');
$query = $this->db->get('h_categories');
return $query->result();
}
//get categories
public function get_categories()
{
$this->build_query($this->selected_lang->id, true);
$this->order_by_categories();
$query = $this->db->get('h_categories');
return $query->result();
}
//get subcategories by parent id
public function get_subcategories_by_parent_id($parent_id)
{
$this->build_query($this->selected_lang->id, true);
$this->db->where('h_categories.parent_id', clean_number($parent_id));
$this->order_by_categories();
$query = $this->db->get('h_categories');
return $query->result();
}
//get parent categories
public function get_parent_categories()
{
$key = "parent_categories_lang_" . $this->selected_lang->id;
$result = get_cached_data($this, $key, "st");
if (!empty($result)) {
return $result;
} else {
$result = array();
}
$this->build_query($this->selected_lang->id, true);
$this->db->where('parent_id', 0)->where('visibility', 1);
$this->order_by_categories();
$result = $this->db->get('h_categories')->result();
set_cache_data($this, $key, $result, "st");
return $result;
}
//get all parent categories
public function get_all_parent_categories()
{
$this->build_query($this->selected_lang->id, true);
$this->db->where('parent_id', 0);
$this->order_by_categories();
return $this->db->get('h_categories')->result();
}
//get all parent categories by lang
public function get_all_parent_categories_by_lang($lang_id)
{
$this->build_query($lang_id, true);
$this->db->where('parent_id', 0);
$this->order_by_categories();
return $this->db->get('h_categories')->result();
}
//get categories array by lang
public function get_categories_array_by_lang($lang_id, $parent_id = null)
{
$ids = array();
if (!empty($parent_id)) {
$ids = $this->get_subcategories_tree_ids($parent_id, false, false);
}
$this->build_query($lang_id, true);
if (!empty($ids)) {
$this->db->where_in('h_categories.id', $ids);
}
$this->order_by_categories();
$query = $this->db->get('h_categories');
$rows = $query->result();
if (!empty($rows)) {
$array = array();
$array_json = array();
foreach ($rows as $row) {
$array[$row->parent_id][] = $row;
$item = array(
'id' => $row->id,
'parent_id' => '',
'index' => ''
);
array_push($array_json, $item);
}
if ($this->general_settings->sort_parent_categories_by_order == 1 && !empty($array[0])) {
usort($array[0], function ($a, $b) {
if ($a->category_order == $b->category_order) return 0;
return $a->category_order > $b->category_order ? 1 : -1;
});
}
return ['array' => $array, 'array_json' => json_encode($array_json)];
}
return null;
}
//get categories count
public function get_categories_count()
{
$this->db->from('h_categories');
return $this->db->count_all_results();
}
//get categories json
public function get_categories_json($lang_id)
{
$key = "categories_json_lang_" . $lang_id;
$result = get_cached_data($this, $key, "st");
if (!empty($result)) {
echo json_encode($result);
} else {
$this->build_query($lang_id, false);
$this->db->order_by('name');
$this->db->where('visibility', 1);
$query = $this->db->get('h_categories');
$categories = $query->result();
$array = array();
if (!empty($categories)) {
foreach ($categories as $category) {
$item = array(
'id' => $category->id,
'parent_id' => $category->parent_id,
'name' => category_name($category),
);
array_push($array, $item);
}
}
set_cache_data($this, $key, $array, "st");
echo json_encode($array);
}
}
//sort categories
public function sort_categories_json()
{
$json_categories = $this->input->post('json_categories', true);
$json_categories = json_decode($json_categories);
foreach ($json_categories as $category) {
$data = array(
'parent_id' => clean_number($category->parent_id),
'category_order' => clean_number($category->index)
);
$this->db->where('id', $category->id);
$this->db->update('h_categories', $data);
}
}
//generate CSV object
public function generate_csv_object($file_path)
{
$array = array();
$fields = array();
$txt_name = uniqid() . ' . txt';
$i = 0;
$handle = fopen($file_path, "r");
if ($handle) {
while (($row = fgetcsv($handle)) !== false) {
if (empty($fields)) {
$fields = $row;
continue;
}
foreach ($row as $k => $value) {
$array[$i][$fields[$k]] = $value;
}
$i++;
}
if (!feof($handle)) {
return false;
}
fclose($handle);
if (!empty($array)) {
$txt_file = fopen(FCPATH . "uploads/temp/" . $txt_name, "w");
fwrite($txt_file, serialize($array));
fclose($txt_file);
$csv_object = new stdClass();
$csv_object->number_of_items = count($array);
$csv_object->txt_file_name = $txt_name;
@unlink($file_path);
return $csv_object;
}
}
return false;
}
//import csv item
public function import_csv_item($txt_file_name, $index)
{
$file_path = FCPATH . 'uploads/temp/' . $txt_file_name;
$file = fopen($file_path, 'r');
$content = fread($file, filesize($file_path));
$array = @unserialize_data($content);
if (!empty($array)) {
$i = 1;
foreach ($array as $item) {
if ($i == $index) {
$data = array();
$name = get_csv_value($item, 'name');
$data['id'] = get_csv_value($item, 'id', 'int');
$data['slug'] = get_csv_value($item, 'slug') ? get_csv_value($item, 'slug') : str_slug($name);
$data['parent_id'] = get_csv_value($item, 'parent_id', 'int');
$data['title_meta_tag'] = "";
$data['description'] = get_csv_value($item, 'description');
$data['keywords'] = get_csv_value($item, 'keywords');
$data['category_order'] = get_csv_value($item, 'category_order', 'int');
$data['featured_order'] = $data['category_order'];
$data['visibility'] = 1;
$data['is_featured'] = 0;
$data['storage'] = "local";
$data['image'] = "";
$data['show_image_on_navigation'] = 0;
$data['created_at'] = date('Y-m-d H:i:s');
@$this->db->close();
@$this->db->initialize();
if ($this->db->insert('h_categories', $data)) {
//last id
$last_id = $this->db->insert_id();
//add category name
$data_name = array(
'category_id' => $last_id,
'lang_id' => $this->selected_lang->id,
'name' => $name
);
$this->db->insert('h_categories_lang', $data_name);
//update slug
$this->category_model->update_slug($last_id);
//update category parent tree
$this->db->select("h_categories.*, h_categories.parent_id AS parent_category_id, (SELECT parent_tree FROM h_categories WHERE id = parent_category_id) AS parent_category_tree");
$category = $this->db->where('id', clean_number($last_id))->get('h_categories')->row();
if (!empty($category)) {
$parent_tree = "";
if ($category->parent_id != 0) {
if (empty($category->parent_category_tree)) {
$parent_tree = $category->parent_id;
} else {
$parent_tree = $category->parent_category_tree . "," . $category->parent_id;
}
}
$this->db->where('id', $category->id)->update('h_categories', ['parent_tree' => $parent_tree]);
}
return $name;
}
}
$i++;
}
}
}
//search categories by name
public function search_categories_by_name($category_name)
{
$this->db->select('h_categories.id, h_categories_lang.name as name');
$this->db->join('h_categories_lang', 'h_categories_lang.category_id = h_categories.id');
$this->db->like('name', clean_str($category_name));
$this->db->where('visibility', 1);
$this->db->order_by('h_categories.parent_id');
$this->db->order_by('name');
$query = $this->db->get('h_categories');
return $query->result();
}
//set unset featured category
public function set_unset_featured_category($category_id)
{
$category = $this->get_category($category_id);
if (!empty($category)) {
if ($this->input->post('is_form') == 1) {
$data['is_featured'] = 1;
} else {
$data['is_featured'] = 0;
}
if ($category->is_featured == 0) {
$data['is_featured'] = 1;
}
$this->db->where('id', $category->id);
return $this->db->update('h_categories', $data);
}
return false;
}
//set unset index category
public function set_unset_index_category($category_id)
{
$category = $this->get_category($category_id);
if (!empty($category)) {
if ($this->input->post('is_form') == 1) {
$data['show_products_on_index'] = 1;
} else {
$data['show_products_on_index'] = 0;
}
if ($category->show_products_on_index == 0) {
$data['show_products_on_index'] = 1;
}
$data['show_subcategory_products'] = $this->input->post('show_subcategory_products');
if (empty($data['show_subcategory_products'])) {
$data['show_subcategory_products'] = 0;
}
$this->db->where('id', $category->id);
return $this->db->update('h_categories', $data);
}
return false;
}
//update featured categories order
public function update_featured_categories_order()
{
$category_id = $this->input->post('category_id', true);
$order = clean_number($this->input->post('order', true));
$category = $this->get_category($category_id);
if (!empty($category) && !empty($order)) {
$data['featured_order'] = $order;
$this->db->where('id', $category->id);
$this->db->update('h_categories', $data);
}
}
//update index categories order
public function update_index_categories_order()
{
$category_id = $this->input->post('category_id', true);
$order = clean_number($this->input->post('order', true));
$category = $this->get_category($category_id);
if (!empty($category) && !empty($order)) {
$data['homepage_order'] = $order;
$this->db->where('id', $category->id);
$this->db->update('h_categories', $data);
}
}
//delete category name
public function delete_category_name($category_id)
{
$this->db->where('category_id', clean_number($category_id));
$query = $this->db->get('h_categories_lang');
$results = $query->result();
if (!empty($results)) {
foreach ($results as $result) {
$this->db->where('id', $result->id);
$this->db->delete('h_categories_lang');
}
}
}
//delete category image
public function delete_category_image($category_id)
{
$category = $this->get_category($category_id);
if (!empty($category)) {
delete_file_from_server($category->image);
$data = array(
'image' => ""
);
$this->db->where('id', $category->id);
return $this->db->update('h_categories', $data);
}
}
//delete category
public function delete_category($id)
{
$category = $this->get_category($id);
if (!empty($category)) {
//delete from s3
if ($category->storage == "aws_s3") {
$this->load->model("aws_model");
if (!empty($category->image)) {
$this->aws_model->delete_category_object($category->image);
}
} else {
delete_file_from_server($category->image);
}
//delete category name
$this->delete_category_name($category->id);
$this->db->where('id', $category->id);
return $this->db->delete('h_categories');
}
return false;
}
}