|
Server : Apache/2.4.18 (Ubuntu) System : Linux canvaswebdesign 3.13.0-71-generic #114-Ubuntu SMP Tue Dec 1 02:34:22 UTC 2015 x86_64 User : oppastar ( 1041) PHP Version : 7.0.33-0ubuntu0.16.04.15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, Directory : /var/www/symphony-solusi.co.id/public_html/application/helpers/ |
Upload File : |
<?php
function count_child_menus($parent_id) {
$ci = & get_instance();
$ci->db->select('id_menus')->from('menus')->where('status', '1')->where('parent_id', $parent_id);
$count_child_menus = $ci->db->get()->num_rows();
return $count_child_menus;
}
function get_child_menus($parent_id, $limit = NULL, $start = NULL) {
$ci = & get_instance();
if($ci->session->userdata('site_lang') == 'english') {
$ci->db->select('*');
$ci->db->from('menus');
$ci->db->where('status', '1');
$ci->db->where('parent_id', $parent_id);
if($limit != NULL) {
$ci->db->limit($limit, $start);
}
$ci->db->order_by('priority', 'ASC');
} else {
$ci->db->select('*');
$ci->db->from('menus');
$ci->db->where('status', '1');
$ci->db->where('parent_id', $parent_id);
if($limit != NULL) {
$ci->db->limit($limit, $start);
}
$ci->db->order_by('priority', 'ASC');
}
$child_menus = $ci->db->get()->result();
return $child_menus;
}
function getProjectByCategory($id) {
$ci = & get_instance();
$productCategory = $ci->db->select('image1')->from('products')->join('category_product','products.id_products=category_product.id_product')->join('categories','category_product.id_category=categories.id_categories')->where('categories.id_categories',$id)->where('products.product_status',1)->order_by('products.priority','ASC')->get()->row()->image1;
if($productCategory == NULL) {
$productCategory = 'no-image.jpg';
}
return $productCategory;
}