protected function show($slug = false)
{
if (isset($sorting)) {
Model_Category::$sorting = $sorting;
}
if ($category = Model_Category::get_by_slug($slug)) {
// TODO delete this
srand($category->id);
$items = null;
$parent_category = null;
if ($category->parent_id == 0) {
$view_file = 'category';
// Categories
$items = Model_Category::find(array('where' => array('parent_id' => $category->id, 'status' => 1), 'order_by' => array('sort' => 'asc')));
} else {
$view_file = 'subcategory';
// Products
$items = $category->products;
$parent_category = Model_Category::find_one_by_id($category->parent_id);
}
\Helper::sorting($items);
// Reset to empty array if there are no result found by query
if (is_null($items)) {
$items = array();
}
// Initiate pagination
$pagination = \Hybrid\Pagination::make(array('total_items' => count($items), 'per_page' => \Input::get('per_page', 15), 'uri_segment' => null));
// Remove unwanted items, and show only required ones
$items = array_slice($items, $pagination->offset, $pagination->per_page);
\Theme::instance()->set_partial('content', $this->view_dir . $view_file)->set('category', $category, false)->set('parent_category', $parent_category, false)->set('items', $items, false)->set('pagination', $pagination, false);
} else {
throw new \HttpNotFoundException();
}
}
protected function show($slug = false)
{
if (isset($sorting)) {
Model_Category::$sorting = $sorting;
}
if ($category = Model_Category::get_by_slug($slug)) {
// TODO delete this
srand($category->id);
$items = null;
$parent_category = null;
if ($category->parent_id == 0) {
$view_file = 'category';
// Categories
$items = Model_Category::find(array('where' => array('parent_id' => $category->id, 'status' => 1), 'order_by' => array('sort' => 'asc')));
if (!$items) {
$view_file = 'subcategory';
$items = $category->products;
}
} else {
$view_file = 'subcategory';
// Products
$items = $category->products;
// echo '<pre>';
// print_r($items);
// echo '</pre>';
$parent_category = Model_Category::find_one_by_id($category->parent_id);
}
\Helper::sorting($items);
// Reset to empty array if there are no result found by query
if (is_null($items)) {
$items = array();
}
// Initiate pagination
$pagination = \Hybrid\Pagination::make(array('total_items' => count($items), 'per_page' => \Input::get('per_page', 15), 'uri_segment' => null));
// Remove unwanted items, and show only required ones
$items = array_slice($items, $pagination->offset, $pagination->per_page);
$category_parents = false;
if ($parent_category) {
$parents = array();
if ($category_parents_id = Model_Category::find_parents($category->parent_id, $parents, true)) {
$category_parents = Model_Category::find(array('where' => array(array('id', 'in', $category_parents_id))));
}
}
$stock_options = \Config::load('stock-option.db');
\Theme::instance()->set_partial('content', $this->view_dir . $view_file)->set('category', $category, false)->set('parent_category', $parent_category, false)->set('items', $items, false)->set('category_parents', $category_parents, false)->set('pagination', $pagination, false)->set('manage_stock', $stock_options['manage_stock'], false)->set('hide_out_of_stock', $stock_options['hide_out_of_stock'], false);
\View::set_global('title', $category->seo->meta_title ?: $category->title);
\View::set_global('meta_description', $category->seo->meta_description ?: '');
\View::set_global('meta_keywords', $category->seo->meta_keywords ?: '');
$robots = array('meta_robots_index' => $category->seo->meta_robots_index == 1 ? 'index' : 'noindex', 'meta_robots_follow' => $category->seo->meta_robots_follow == 1 ? 'follow' : 'nofollow');
\View::set_global('robots', $robots);
\View::set_global('canonical', $category->seo->canonical_links);
\View::set_global('h1_tag', $category->seo->h1_tag);
if ($category->seo->redirect_301) {
\Response::redirect($category->seo->redirect_301);
}
} else {
throw new \HttpNotFoundException();
}
}
public function action_list()
{
\View::set_global('title', 'List groups');
// Get all groups and remove admin groups from array
$items = \Sentry::group()->all('front');
// Reset to empty array if there are no result found by query
if (is_null($items)) {
$items = array();
}
// Initiate pagination
$pagination = \Hybrid\Pagination::make(array('total_items' => count($items), 'per_page' => \Input::get('per_page', 10), 'uri_segment' => null));
// Remove unwanted items, and show only required ones
$items = array_slice($items, $pagination->offset, $pagination->per_page);
\Theme::instance()->set_partial('content', $this->view_dir . 'list')->set('items', $items)->set('pagination', $pagination, false);
}
public function action_myproducts()
{
$products = \Product\Model_Product::filter_by_group();
// Products
$items = array();
if ($products) {
$items = Model_Product::find(array('where' => array(array('id', 'in', array_keys($products['assigned'])))), 'id');
}
$category = null;
$parent_category = null;
// Reset to empty array if there are no result found by query
if (is_null($items)) {
$items = array();
}
// Initiate pagination
$pagination = \Hybrid\Pagination::make(array('total_items' => count($items), 'per_page' => \Input::get('per_page', 15), 'uri_segment' => null));
// Remove unwanted items, and show only required ones
$items = array_slice($items, $pagination->offset, $pagination->per_page);
\Theme::instance()->set_partial('content', $this->view_dir . 'subcategory')->set('page_title', 'My Products', false)->set('category', $category, false)->set('parent_category', $parent_category, false)->set('items', $items, false)->set('pagination', $pagination, false);
}
public function get_search_items()
{
/************ Start generating query ***********/
$items = Model_Team::find(function ($query) {
// Get search filters
foreach (\Input::get() as $key => $value) {
if (!empty($value) || $value == '0') {
switch ($key) {
case 'title':
$query->where('name', 'like', "%{$value}%");
break;
case 'featured':
if (is_numeric($value)) {
$query->where($key, $value);
}
break;
case 'status':
if (is_numeric($value)) {
$query->where($key, $value);
}
break;
case 'active_from':
$date = strtotime($value);
if ($date) {
$query->where($key, '>=', $date);
}
break;
case 'active_to':
$date = strtotime($value);
if ($date) {
$query->where($key, '<=', $date);
}
break;
}
}
}
// Order query
$query->order_by('sort', 'asc');
$query->order_by('id', 'asc');
});
/************ End generating query ***********/
// Reset to empty array if there are no result found by query
if (is_null($items)) {
$items = array();
}
// Initiate pagination
$pagination = \Hybrid\Pagination::make(array('total_items' => count($items), 'per_page' => \Input::get('per_page', 10), 'uri_segment' => null));
// Remove unwanted items, and show only required ones
$items = array_slice($items, $pagination->offset, $pagination->per_page);
$status = array('false' => 'Select', '1' => 'Active', '0' => 'Inactive', '2' => 'Active in period');
return array('items' => $items, 'pagination' => $pagination, 'status' => $status);
}
public function action_products_assigned($id = false)
{
if (!is_numeric($id)) {
\Response::redirect('admin/product/group/list');
}
// Get group to edit
if (!($item = Model_Group::find_one_by_id($id))) {
\Response::redirect('admin/product/group/list');
}
\View::set_global('title', 'Edit Group Products');
// Update group products
if (\Input::post()) {
$add = \Input::post('products.add', array());
$remove = \Input::post('products.remove', array());
$update = \Input::post('products.update', array());
if (\Input::post('add', false)) {
foreach ($add as $value) {
$related = Model_Product_To_Groups::forge(array('group_id' => $item->id, 'product_id' => $value));
$related->save();
// NRB-Gem: Get current Customer Group for this Pricing Group
$product_group_option = \Product\Model_Group_Options::find_one_by(array('active' => 1, 'product_group_id' => $id));
$user_group_id = null;
if ($product_group_option) {
$user_group_id = $product_group_option->user_group_id;
}
// NRB-Gem: add attributes
$a_attributes = \Product\Model_Attribute::find(function ($query) use($value) {
$query->where('product_id', '=', $value);
$query->where('active', '=', 1);
});
$a_attribute_ids = array();
if (count($a_attributes)) {
foreach ($a_attributes as $o_attr) {
$o_attr_price = new Model_Attribute_Price(array('product_attribute_id' => $o_attr->id, 'pricing_group_id' => $item->id, 'user_group_id' => $user_group_id, 'type' => 'sale_price'));
$o_attr_price->save();
}
}
}
\Messages::success('Products successfully added to group.');
} else {
if (\Input::post('remove', false)) {
foreach ($remove as $value) {
$related = Model_Product_To_Groups::find_one_by(array(array('group_id', '=', $item->id), array('product_id', '=', $value)));
if (!is_null($related)) {
$related->delete();
// NRB-Gem: remove attributes
$a_attributes = \Product\Model_Attribute::find(function ($query) use($value) {
$query->where('product_id', '=', $value);
});
$a_attribute_ids = array();
if (count($a_attributes)) {
foreach ($a_attributes as $o_attr) {
$a_attribute_ids[] = $o_attr->id;
}
}
if (count($a_attribute_ids)) {
\DB::delete('product_attribute_price')->where('product_attribute_id', 'IN', \DB::expr('(' . implode(',', $a_attribute_ids) . ')'))->where('pricing_group_id', '=', $item->id)->execute();
}
}
}
\Messages::success('Products successfully removed from group.');
}
}
if (!empty($update)) {
foreach ($update['discount'] as $key => $value) {
if (isset($update['attr_id'][$key])) {
foreach ($update['attr_id'][$key] as $attribute_id) {
$update_sale_price = Model_Attribute_Price::find_one_by(array(array('product_attribute_id', '=', $attribute_id), array('pricing_group_id', '=', $item->id)));
if ($update_sale_price) {
$update_sale_price->set(array('discount' => $update['discount'][$key][$attribute_id], 'able_discount' => $update['able_discount'][$key][$attribute_id], 'price' => $update['price'][$key][$attribute_id]));
$update_sale_price->save();
}
}
} else {
$prod_attributes = \Product\Model_Attribute::find_by_product_id($key);
$attribute_id = $prod_attributes[0]->id;
$o_attr_price_list = Model_Attribute_Price::find_one_by(array(array('product_attribute_id', '=', $attribute_id), array('pricing_group_id', '<>', $item->id)));
if ($o_attr_price_list) {
$o_attr_price_list->delete();
}
$update_sale_price = Model_Attribute_Price::find_one_by(array(array('product_attribute_id', '=', $attribute_id), array('pricing_group_id', '=', $item->id)));
if ($update_sale_price) {
$update_sale_price->set(array('discount' => $update['discount'][$key], 'able_discount' => $update['able_discount'][$key], 'price' => $update['price'][$key]));
$update_sale_price->save();
}
}
}
\Messages::success('Products successfully updated.');
}
// if(\Input::is_ajax())
// {
// echo \Messages::display('left', false);
// exit;
// }
// else
// {
\Response::redirect(\Input::referrer(\Uri::admin('current')));
// }
}
$group = Model_Group::find_one_by_id($id);
/************ Get non related infotabs ***********/
$items = Model_Product::find(function ($query) use($item) {
$product_ids = array();
// NRB-Gem: Comment out, to enable multiple pricing groups for a product
// Products can be in only ONE discounted group
// But can exist in MULTIPLE standard groups
// if($item->type == 'pricing')
// {
// $discounted_products = Model_Product::in_group_type('pricing');
// foreach($discounted_products as $product)
// array_push($product_ids, $product->id);
// }
foreach ($item->products as $product) {
array_push($product_ids, $product->id);
}
if (!empty($product_ids)) {
$product_ids = '(' . implode(',', $product_ids) . ')';
$query->where('id', 'NOT IN', \DB::expr($product_ids));
}
// Filters
foreach (\Input::get() as $key => $value) {
if (!empty($value) || $value == '0') {
switch ($key) {
case 'title':
$query->where($key, 'like', "%{$value}%");
break;
case 'status':
if (is_numeric($value)) {
$query->where($key, $value);
}
break;
case 'category_id':
if (is_numeric($value)) {
$products = Model_Product_To_Categories::find(function ($query) use($value) {
return $query->where('category_id', $value);
}, 'product_id');
if (empty($products)) {
$products = array(0);
}
$query->where('id', 'IN', array_keys($products));
}
break;
}
}
}
// Order query
$query->order_by('sort', 'asc');
$query->order_by('id', 'asc');
});
$group->not_related_products = null;
$not_related_products = $items ? $items : array();
// product_group_options
$customer_groups = Model_Group_Options::find_by(array('active' => 1, 'product_group_id' => $id));
$customer_group = array();
if ($customer_groups) {
$customer_group = Model_Customer_Group::find_one_by_id($customer_groups[0]->user_group_id);
}
// Reset to empty array if there are no result found by query
if (is_null($items)) {
$items = array();
}
// Initiate pagination
$pagination = \Hybrid\Pagination::make(array('total_items' => count($items), 'per_page' => \Input::get('per_page', 10), 'uri_segment' => null));
// Remove unwanted items, and show only required ones
$items = array_slice($items, $pagination->offset, $pagination->per_page);
$status = array('false' => 'Select', '1' => 'Active', '0' => 'Inactive', '2' => 'Active in period');
\Theme::instance()->set_partial('content', $this->view_dir . 'products_assigned')->set('group', $group, false)->set('items', $items, false)->set('pagination', $pagination, false)->set('status', $status, false)->set('customer_group', $customer_group, false);
}
public function get_search_items($group_id = false)
{
// Override group_id if its a search
$group_id = \Input::get('user_group', $group_id);
if ($group_id && \Sentry::group_exists((int) $group_id)) {
// Get only group users
\View::set_global('group', \Sentry::group((int) $group_id));
$items = \Sentry::group((int) $group_id)->users();
} else {
$items = \Sentry::user()->all('admin');
}
// Reset to empty array if there are no result found by query
if (is_null($items)) {
$items = array();
}
// Get user objects
if (!empty($items)) {
foreach ($items as $key => $item) {
$items[$key] = \Sentry::user((int) $item['id']);
}
// Get search filters
foreach (\Input::get() as $key => $value) {
if (!empty($value) || $value == '0') {
switch ($key) {
case 'title':
foreach ($items as $number => $item) {
if (empty($item['metadata'])) {
unset($items[$number]);
continue;
}
$full_name = $item->get('metadata.first_name') . ' ' . $item->get('metadata.last_name');
if (stripos($full_name, $value) === false) {
unset($items[$number]);
}
}
break;
case 'email':
foreach ($items as $number => $item) {
if (stripos($item->email, $value) === false) {
unset($items[$number]);
}
}
break;
case 'country':
if ($value && $value !== 'false') {
foreach ($items as $number => $item) {
if (empty($item['metadata'])) {
unset($items[$number]);
continue;
}
if (stripos($item->get('metadata.country'), $value) === false) {
unset($items[$number]);
}
}
}
break;
case 'postcode_from':
foreach ($items as $number => $item) {
if (empty($item['metadata'])) {
unset($items[$number]);
continue;
}
if ($item->get('metadata.postcode') < $value) {
unset($items[$number]);
}
}
break;
case 'postcode_to':
foreach ($items as $number => $item) {
if (empty($item['metadata'])) {
unset($items[$number]);
continue;
}
if ($item->get('metadata.postcode') > $value) {
unset($items[$number]);
}
}
break;
}
}
}
}
// Reset to empty array if there are no result found by query
if (is_null($items)) {
$items = array();
}
// Initiate pagination
$pagination = \Hybrid\Pagination::make(array('total_items' => count($items), 'per_page' => \Input::get('per_page', 10), 'uri_segment' => null));
// Remove unwanted items, and show only required ones
$items = array_slice($items, $pagination->offset, $pagination->per_page);
return array('items' => $items, 'pagination' => $pagination);
}
public function get_search_items($category_id = false)
{
// Override category_id if its a search
$category_id = \Input::get('category_id', $category_id);
$product_ids = array();
// If we are viewing category products
// We need to find all products from that and child categories
if (is_numeric($category_id)) {
$category = \Product\Model_Category::find_one_by_id($category_id);
if ($category) {
\View::set_global('category', $category);
if ($category->all_products) {
$product_ids = array_keys($category->all_products);
}
}
}
// If we are filtering products by category and there is nothing found
// We return empty array of products without even going to database
if (empty($product_ids) && is_numeric($category_id)) {
$items = array();
} else {
/************ Start generating query ***********/
$items = Model_Product::find(function ($query) use($product_ids) {
if (!empty($product_ids)) {
$query->where('id', 'in', $product_ids);
}
// Get search filters
foreach (\Input::get() as $key => $value) {
if (!empty($value) || $value == '0') {
switch ($key) {
case 'title':
$query->where($key, 'like', "%{$value}%")->or_where('code', 'like', "%{$value}%");
break;
case 'status':
if (is_numeric($value)) {
$query->where($key, $value);
}
break;
case 'active_from':
$date = strtotime($value);
if ($date) {
$query->where($key, '>=', $date);
}
break;
case 'active_to':
$date = strtotime($value);
if ($date) {
$query->where($key, '<=', $date);
}
break;
}
}
}
// Order query
$query->order_by('sort', 'asc');
$query->order_by('id', 'asc');
});
}
/************ End generating query ***********/
// Reset to empty array if there are no result found by query
if (is_null($items)) {
$items = array();
}
// Initiate pagination
$pagination = \Hybrid\Pagination::make(array('total_items' => count($items), 'per_page' => \Input::get('per_page', 10), 'uri_segment' => null));
// Remove unwanted items, and show only required ones
$items = array_slice($items, $pagination->offset, $pagination->per_page);
$status = array('false' => 'Select', '1' => 'Active', '0' => 'Inactive', '2' => 'Active in period');
return array('items' => $items, 'pagination' => $pagination, 'status' => $status);
}
public function get_search_items($user_id = false)
{
// Override group_id if its a search
$user_id = \Input::get('user_id', $user_id);
if ($user_id && \Sentry::user_exists((int) $user_id)) {
$user = \Sentry::user((int) $user_id);
}
$items = \Order\Model_Order::find(function ($query) {
if (isset($user)) {
$query->where('user_id', $user->id);
}
// $query->order_by('main_number', 'desc');
$query->order_by('id', 'asc');
});
foreach (\Input::get() as $key => $value) {
if (!empty($value) || $value == '0') {
switch ($key) {
case 'title':
foreach ($items as $number => $item) {
$full_name = $item->first_name . ' ' . $item->last_name;
if (stripos($item->company, $value) === false) {
if (stripos($full_name, $value) === false) {
unset($items[$number]);
}
}
}
break;
case 'email':
foreach ($items as $number => $item) {
if (stripos($item->email, $value) === false) {
unset($items[$number]);
}
}
break;
case 'custom_order_status':
if (array_key_exists($value, \Config::get('details.status', array()))) {
foreach ($items as $number => $item) {
if ($item->status != $value) {
unset($items[$number]);
}
}
}
break;
case 'order_total_from':
is_numeric($value) or $value = 0;
foreach ($items as $number => $item) {
$item_details = \Order\Model_Order::order_info($item->id);
if ($item_details['total_price'] < $value) {
unset($items[$number]);
}
}
break;
case 'order_total_to':
is_numeric($value) or $value = 0;
foreach ($items as $number => $item) {
$item_details = \Order\Model_Order::order_info($item->id);
if ($item_details['total_price'] > $value) {
unset($items[$number]);
}
}
break;
case 'date_from':
if ($date = strtotime($value)) {
foreach ($items as $number => $item) {
if ($item->created_at < $date) {
unset($items[$number]);
}
}
}
break;
case 'date_to':
if ($date = strtotime($value)) {
foreach ($items as $number => $item) {
if ($item->created_at > $date) {
unset($items[$number]);
}
}
}
break;
case 'sch_from':
if ($date = strtotime($value)) {
foreach ($items as $number => $item) {
if ($item->sch_delivery < $date) {
unset($items[$number]);
}
}
}
break;
case 'sch_to':
if ($date = strtotime($value)) {
foreach ($items as $number => $item) {
if ($item->sch_delivery > $date) {
unset($items[$number]);
}
}
}
break;
case 'status':
foreach ($items as $number => $item) {
if ($value == 'false') {
break;
}
if (stripos($item->status, $value) === false) {
unset($items[$number]);
}
}
break;
case 'invoice_status':
foreach ($items as $number => $item) {
if ($value == 'false') {
break;
}
if (stripos($item->invoice_status, $value) === false) {
unset($items[$number]);
}
}
break;
case 'delivery_status':
foreach ($items as $number => $item) {
if ($value == 'false') {
break;
}
if (stripos($item->delivery_status, $value) === false) {
unset($items[$number]);
}
}
break;
case 'user_group':
foreach ($items as $number => $item) {
if ($value == 'false') {
break;
}
if (!\Sentry::user_exists((int) $item->user_id) || !\Sentry::user((int) $item->user_id)->in_group($value)) {
unset($items[$number]);
}
}
break;
}
}
}
// Reset to empty array if there are no result found by query
if (is_null($items)) {
$items = array();
}
// Initiate pagination
$pagination = \Hybrid\Pagination::make(array('total_items' => count($items), 'per_page' => \Input::get('per_page', 10), 'uri_segment' => null));
// Remove unwanted items, and show only required ones
$items = array_slice($items, $pagination->offset, $pagination->per_page);
return array('items' => $items, 'pagination' => $pagination);
}
public function get_search_items($item)
{
/************ Get non upsell products ***********/
$items = Model_Product::find(function ($query) use($item) {
$upsell_ids = array($item->id);
foreach ($item->upsell_products as $upsell) {
array_push($upsell_ids, $upsell->id);
}
if (!empty($upsell_ids)) {
$upsell_ids = '(' . implode(',', $upsell_ids) . ')';
$query->where('id', 'NOT IN', \DB::expr($upsell_ids));
}
// Order query
$query->order_by('sort', 'asc');
$query->order_by('id', 'asc');
});
$item->not_upsell_products = $items ? $items : array();
/************ End generating query ***********/
foreach ($item->not_upsell_products as $item_key => $item_value) {
foreach (\Input::get() as $key => $value) {
if (!empty($value) || $value == '0') {
switch ($key) {
case 'title':
if (stripos($item_value->title, $value) === false) {
unset($item->not_upsell_products[$item_key]);
}
break;
case 'status':
if (is_numeric($value)) {
if ($item_value->status != $value) {
unset($item->not_upsell_products[$item_key]);
}
}
break;
case 'active_from':
$date = strtotime($value);
if ($date) {
if ($item_value->active_from < $value) {
unset($item->not_upsell_products[$item_key]);
}
}
break;
case 'active_to':
$date = strtotime($value);
if ($date) {
if ($item_value->active_to > $value) {
unset($item->not_upsell_products[$item_key]);
}
}
break;
case 'category_id':
if (is_numeric($value)) {
if (!array_key_exists($value, $item_value->categories)) {
unset($item->not_upsell_products[$item_key]);
}
}
break;
}
}
}
}
// Initiate pagination
$pagination = \Hybrid\Pagination::make(array('total_items' => count($item->not_upsell_products), 'per_page' => \Input::get('per_page', 10), 'uri_segment' => null));
// Remove unwanted items, and show only required ones
$item->not_upsell_products = array_slice($item->not_upsell_products, $pagination->offset, $pagination->per_page);
$status = array('false' => 'Select', '1' => 'Active', '0' => 'Inactive', '2' => 'Active in period');
return array('item' => $item, 'pagination' => $pagination, 'status' => $status);
}
public function action_list()
{
\View::set_global('title', 'List Infotabs');
/************ Start generating query ***********/
$items = Model_Infotab::find(function ($query) {
// Get search filters
foreach (\Input::get() as $key => $value) {
if (!empty($value) || $value == '0') {
switch ($key) {
case 'title':
$query->where($key, 'like', "%{$value}%");
break;
case 'status':
if (is_numeric($value)) {
$query->where($key, $value);
}
break;
}
}
}
// Order query
$query->order_by('sort', 'asc');
$query->order_by('id', 'asc');
});
/************ End generating query ***********/
// Reset to empty array if there are no result found by query
if (is_null($items)) {
$items = array();
}
// Initiate pagination
$pagination = \Hybrid\Pagination::make(array('total_items' => count($items), 'per_page' => \Input::get('per_page', 10), 'uri_segment' => null));
// Remove unwanted items, and show only required ones
$items = array_slice($items, $pagination->offset, $pagination->per_page);
\Theme::instance()->set_partial('content', $this->view_dir . 'list')->set('items', $items)->set('pagination', $pagination, false);
}
public function get_search_items($user_id = false)
{
// Override group_id if its a search
$user_id = \Input::get('user_id', $user_id);
if ($user_id && \Sentry::user_exists((int) $user_id)) {
$user = \Sentry::user((int) $user_id);
}
$items = \Order\Model_Order::find(function ($query) {
if (isset($user)) {
$query->where('user_id', $user->id);
}
$query->where('finished', '1');
$query->order_by('id', 'desc');
});
foreach (\Input::get() as $key => $value) {
if (!empty($value) || $value == '0') {
switch ($key) {
case 'title':
foreach ($items as $number => $item) {
$full_name = $item->first_name . ' ' . $item->last_name;
if (stripos($item->company, $value) === false && stripos($item->id, $value) === false) {
if (stripos($full_name, $value) === false) {
unset($items[$number]);
}
}
}
break;
case 'email':
foreach ($items as $number => $item) {
if (stripos($item->email, $value) === false) {
unset($items[$number]);
}
}
break;
case 'order_total_from':
is_numeric($value) or $value == 0;
foreach ($items as $number => $item) {
$item_details = \Order\Model_Order::order_info($item->id);
if (isset($item_details['total_price']) && $item_details['total_price'] < $value) {
unset($items[$number]);
}
}
break;
case 'order_total_to':
is_numeric($value) or $value == 0;
foreach ($items as $number => $item) {
$item_details = \Order\Model_Order::order_info($item->id);
if (isset($item_details['total_price']) && $item_details['total_price'] > $value) {
unset($items[$number]);
}
}
break;
case 'date_from':
// convert format date to m/d/Y
$parts = explode('/', $value);
$value = $parts[1] . '/' . $parts[0] . '/' . $parts[2];
if ($date = strtotime($value)) {
foreach ($items as $number => $item) {
if ($item->created_at < $date) {
unset($items[$number]);
}
}
}
break;
case 'date_to':
// convert format date to m/d/Y
$parts = explode('/', $value);
$value = $parts[1] . '/' . $parts[0] . '/' . $parts[2];
if ($date = strtotime($value)) {
foreach ($items as $number => $item) {
if ($item->created_at > $date) {
unset($items[$number]);
}
}
}
break;
case 'status':
foreach ($items as $number => $item) {
if ($value == 'false') {
break;
}
if (stripos($item->status, $value) === false) {
unset($items[$number]);
}
}
break;
case 'tracking_no':
foreach ($items as $number => $item) {
if (!$value != '') {
break;
}
if (stripos($item->tracking_no, $value) === false) {
unset($items[$number]);
}
}
break;
case 'payment_method':
foreach ($items as $number => $item) {
if ($value == 'false') {
break;
}
if (!empty($item->last_payment)) {
if ($item->last_payment->method != $value) {
unset($items[$number]);
}
}
}
break;
case 'user_group':
foreach ($items as $number => $item) {
if ($value == 'false') {
break;
}
if ($item->user_id && \Sentry::user_exists((int) $item->user_id)) {
$user = \Sentry::user((int) $item->user_id);
if ($user->in_group($value)) {
unset($items[$number]);
}
}
}
break;
case 'country':
foreach ($items as $number => $item) {
if ($value == 'false') {
break;
}
if (stripos($item->country, $value) === false) {
unset($items[$number]);
}
}
break;
case 'state':
foreach ($items as $number => $item) {
if ($value == 'false') {
break;
}
if (stripos($item->country, $value) === false) {
unset($items[$number]);
}
}
break;
case 'product_category':
foreach ($items as $number => $item) {
if ($value == 'false') {
break;
}
// Get order products
if (!empty($item->products)) {
$exists = array();
foreach ($item->products as $product) {
// Find category
if (\Product\Model_Product_To_Categories::find(array('where' => array('product_id' => $product->product_id, 'category_id' => $value)))) {
$exists[] = $product->id;
}
}
if (empty($exists)) {
unset($items[$number]);
}
}
}
break;
}
}
}
// Reset to empty array if there are no result found by query
if (is_null($items)) {
$items = array();
}
// Initiate pagination
$pagination = \Hybrid\Pagination::make(array('total_items' => count($items), 'per_page' => \Input::get('per_page', 10), 'uri_segment' => null));
// Remove unwanted items, and show only required ones
$items = array_slice($items, $pagination->offset, $pagination->per_page);
return array('items' => $items, 'pagination' => $pagination);
}
public function get_search_items()
{
$filters = array('title' => \Input::get('title'), 'discount_status' => \Input::get('discount_status'), 'discount_type' => \Input::get('discount_type'), 'type' => \Input::get('type'));
$items = Model_Discountcode::find(function ($query) use($filters) {
if ($filters['title']) {
$query = $query->where('code', 'like', '%' . $filters['title'] . '%');
}
if ($filters['discount_status']) {
$query = $query->where('status', $filters['discount_status']);
}
if ($filters['discount_type']) {
$query = $query->where('type', $filters['discount_type']);
}
if ($filters['type']) {
$query = $query->where('use_type', $filters['type']);
}
$query->order_by('code', 'asc');
});
// Reset to empty array if there are no result found by query
if (is_null($items)) {
$items = array();
}
// Initiate pagination
$pagination = \Hybrid\Pagination::make(array('total_items' => count($items), 'per_page' => \Input::get('per_page', 10), 'uri_segment' => null));
// Remove unwanted items, and show only required ones
$items = array_slice($items, $pagination->offset, $pagination->per_page);
return array('items' => $items, 'pagination' => $pagination);
}
public function action_referrals($id = false)
{
\View::set_global('title', 'Referrals');
$user = new \Sentry_User((int) $id);
$items = Model_Referal::find(function ($query) use($id) {
$query->where('user_added', $id);
$query->order_by('id', 'desc');
});
// Reset to empty array if there are no result found by query
if (is_null($items)) {
$items = array();
}
// Initiate pagination
$pagination = \Hybrid\Pagination::make(array('total_items' => count($items), 'per_page' => \Input::get('per_page', 10), 'uri_segment' => null));
// Remove unwanted items, and show only required ones
$items = array_slice($items, $pagination->offset, $pagination->per_page);
\Theme::instance()->set_partial('content', $this->view_dir . 'referrals')->set('user', $user)->set('pagination', $pagination, false)->set('items', $items);
}
/**
* Update product price
*
* @access public
* @return Response
*/
public function action_update($id = false)
{
$flag = true;
if (!is_numeric($id)) {
\Response::redirect('admin/product/list');
}
// Get product item to edit
if (!($item = Model_Product::find_one_by_id($id))) {
\Response::redirect('admin/product/list');
}
// Redirect to attribute group
if (\Input::get('attribute_group', false) === false && !empty($item->attributes)) {
foreach ($item->attributes as $attr_obj) {
if ($attr_obj->attribute_group_id > 0) {
\Response::redirect(\Uri::create(\Uri::admin(), array(), array('attribute_group' => $attr_obj->attribute_group_id)));
}
}
}
// NRB-Gem: Comment out; Logic does not apply anymore
// if(\Input::get('user_group', false) === false)
// {
// \Response::redirect(\Uri::create(\Uri::admin(), array(), array('user_group' => 3) + \Input::get()));
// }
\View::set_global('title', 'Edit Product Price');
\View::set_global('quick_menu_save', 'form.main_form');
// Update
if (\Input::post()) {
$post = \Input::post();
$return_to = is_numeric(\Input::post('return_to')) ? '#' . \Input::post('return_to') : '';
//$val = Model_Attribute::validate();
try {
if (isset($post[$post['price_type']])) {
foreach ($post[$post['price_type']] as $key => $price) {
if ($update_price = Model_Attribute_Price::find_one_by_id($key)) {
if (isset($post['active'][$key])) {
$update_price->active = $post['active'][$key];
}
if (isset($post['product_group_discount_id'][$key])) {
$update_price->product_group_discount_id = $post['product_group_discount_id'][$key];
}
$update_price->save();
}
}
}
$multiple_images = array();
$image_new = false;
foreach ($post['attributes'] as $key => $attribute) {
if (!empty($post['delete_items'])) {
$delete_items = explode(',', $post['delete_items']);
$result1 = \DB::delete('product_attributes')->where('id', 'in', $delete_items)->execute();
$result2 = \DB::delete('product_attribute_price')->where('product_attribute_id', 'in', $delete_items)->execute();
}
// Check existing product attribute group
$existing_attribute_group = Model_Attribute::find(function ($query) use($post) {
$query->where('product_id', $post['product_id']);
$query->and_where_open();
$query->where('attribute_group_id', null, \DB::expr('IS NOT NULL'));
// $query->and_where('attribute_group_id', '!=' , 0);
$query->and_where('attribute_group_id', '!=', $post['attribute_group_id']);
$query->and_where_close();
});
//if($existing_attribute_group && $post['attribute_group_id'] != 0)
if ($existing_attribute_group) {
foreach ($existing_attribute_group as $item) {
$delete_attribute = $item->id;
$item->delete();
$attribute_option = Model_Attribute_Price::find_one_by_product_attribute_id($delete_attribute);
if ($attribute_option) {
$attribute_option->delete();
}
}
}
// Update
if (isset($post['update_items'][$key])) {
// Lightmedia - michael: check if product attribute code is exists on the product
if ($this->check_attr_code_exists($id, $post['update_items'][$key], $post['product_code'][$key])) {
$flag = false;
\Messages::error($post['product_code'][$key] . ' code already used');
continue;
}
$update = Model_Attribute::find_one_by_id($post['update_items'][$key]);
if ($update) {
$item_images = array();
$data = array('product_id' => $post['product_id'], 'attribute_group_id' => $post['attribute_group_id'], 'attributes' => $attribute, 'product_code' => $post['product_code'][$key], 'retail_price' => $post['retail_price'][$key], 'sale_price' => $post['sale_price'][$key], 'stock_quantity' => $post['stock_quantity'][$key], 'active' => isset($post['active']) && $post['active'][$key] ? $post['active'][$key] : $post['active_new'][$key]);
// Default radio
$data['default'] = 0;
if (isset($post['default']) && $post['default'] == $key) {
$this->reset_default($item->id);
$data['default'] = 1;
}
$update->set($data);
$update->save();
$attr_id = $update->id;
// Get combinations for multiple images
if (isset($post['apply_image']) && isset($post['action'])) {
if (in_array($attr_id, $post['action'])) {
$multiple_images['action'][$attr_id] = $attr_id;
}
}
if (isset($_FILES['image_new_' . $attr_id])) {
// Upload image and display errors if there are any
$image = $this->upload_image('image');
if ($image['errors'] && $image['exists']) {
\Messages::error('<strong>There was an error while trying to upload product attribute image</strong>');
foreach ($image['errors'] as $error) {
\Messages::error($error);
}
}
// if($image['is_valid'] && !(!$image['exists'] && \Config::get('details.image.required', false) && empty($item->images)))
if ($image['is_valid'] && !(!$image['exists'] && \Config::get('details.image.required', false))) {
/** IMAGES **/
// Get all alt texts to update if there is no image change
foreach (\Arr::filter_prefixed(\Input::post(), 'alt_text_') as $image_id => $alt_text) {
if (strpos($image_id, 'new_') === false) {
$item_images[$image_id] = array('id' => $image_id, 'data' => array('alt_text' => \Input::post('alt_text_' . $image_id, '')));
if (!empty($item_images)) {
Model_Attribute::bind_images($item_images);
}
}
}
// Save images if new files are submitted
if (isset($this->_image_data) && $image['exists'] !== false) {
foreach ($this->_image_data as $image_data) {
$cover_count = count($update->images);
if (strpos($image_data['field'], 'new_') === false) {
// Update existing image
if (str_replace('image_', '', $image_data['field']) != 0) {
$image_id = (int) str_replace('image_', '', $image_data['field']);
$cover_count--;
$item_images[$image_id] = array('id' => $image_id, 'data' => array('content_id' => $attr_id, 'image' => $image_data['saved_as'], 'alt_text' => \Input::post('alt_text_' . $image_id, '')));
//$this->delete_image(\Input::post('image_db_' . $image_id, ''));
}
if (!empty($item_images)) {
Model_Attribute::bind_images($item_images);
}
} else {
// Save new image
$image_tmp = str_replace('image_new_', '', $image_data['field']);
$image_new = $item_images[0] = array('id' => 0, 'data' => array('content_id' => $attr_id, 'image' => $image_data['saved_as'], 'alt_text' => \Input::post('alt_text_new_' . $image_tmp, ''), 'cover' => $cover_count == 0 ? 1 : 0, 'sort' => $cover_count + 1));
if (!empty($item_images)) {
Model_Attribute::bind_images($item_images);
}
// Multiple images
if (isset($post['apply_image']) && isset($post['action']) && false) {
foreach ($post['action'] as $action_value) {
if ($action_value == $attr_id) {
continue;
}
$item_images = array();
if ($action_value > 0) {
$image_new[0] = array('id' => 0, 'data' => array('content_id' => $action_value, 'image' => $image_data['saved_as'], 'alt_text' => \Input::post('alt_text_new_' . $image_tmp, ''), 'cover' => $cover_count == 0 ? 1 : 0, 'sort' => $cover_count + 1));
}
if (!empty($item_images)) {
Model_Attribute::bind_images($item_images);
}
}
}
}
}
}
/** END OF IMAGES **/
}
}
if (isset($post['active_new'][$key])) {
//NRB-Gem: insert attributes to existing Products added to Pricing Groups
$this->add_attribute_price($post, array('attr_id' => $attr_id, 'key' => $key));
}
}
} else {
if ($this->check_attr_code_exists($post['product_id'], false, $post['product_code_new'][$key])) {
$flag = false;
\Messages::error($post['product_code_new'][$key] . ' code already used');
continue;
}
$item_images = array();
$insert = Model_Attribute::forge(array('product_id' => $post['product_id'], 'attribute_group_id' => $post['attribute_group_id'], 'attributes' => $attribute, 'product_code' => $post['product_code_new'][$key], 'retail_price' => $post['retail_price_new'][$key], 'active' => $post['active_new'][$key], 'sale_price' => $post['sale_price_new'][$key], 'stock_quantity' => $post['stock_quantity'][$key]));
// Default radio
$insert->default = 0;
if (isset($post['default']) && $post['default'] == $key) {
$this->reset_default($item->id);
$insert->default = 1;
}
$insert->save();
$attr_id = $insert->id;
// Get combinations for multiple images
if (isset($post['apply_image']) && isset($post['action_new'][$key]) && $post['action_new'][$key] == 1) {
$multiple_images['action_new'][$attr_id] = $attr_id;
}
if (isset($_FILES['_image_new_' . $key])) {
// Upload image and display errors if there are any
$image = $this->upload_image('image');
if ($image['errors'] && $image['exists']) {
\Messages::error('<strong>There was an error while trying to upload product attribute image</strong>');
foreach ($image['errors'] as $error) {
\Messages::error($error);
}
}
// if($image['is_valid'] && !(!$image['exists'] && \Config::get('details.image.required', false) && empty($item->images)))
if ($image['is_valid'] && !(!$image['exists'] && \Config::get('details.image.required', false))) {
/** IMAGES **/
// Save images if new files are submitted
if (isset($this->_image_data) && $image['exists'] !== false) {
foreach ($this->_image_data as $image_data) {
$cover_count = 0;
// Save new image
$image_tmp = str_replace('_image_new_', '', $image_data['field']);
$image_new = $item_images[0] = array('id' => 0, 'data' => array('content_id' => $attr_id, 'image' => $image_data['saved_as'], 'alt_text' => \Input::post('_alt_text_new_' . $image_tmp, ''), 'cover' => $cover_count == 0 ? 1 : 0, 'sort' => $cover_count + 1));
if (!empty($item_images)) {
Model_Attribute::bind_images($item_images);
}
// Multiple images
if (isset($post['apply_image']) && isset($post['action_new']) && false) {
foreach ($post['action_new'] as $action_key => $action_value) {
if ($action_value == $attr_id) {
continue;
}
$item_images = array();
if ($action_value > 0) {
$image_new[0] = array('id' => 0, 'data' => array('content_id' => $action_value, 'image' => $image_data['saved_as'], 'alt_text' => \Input::post('alt_text_new_' . $image_tmp, ''), 'cover' => $cover_count == 0 ? 1 : 0, 'sort' => $cover_count + 1));
}
if (!empty($item_images)) {
Model_Attribute::bind_images($item_images);
}
}
}
}
}
/** END OF IMAGES **/
}
}
if (isset($post[$post['price_type'] . '_new'][$key])) {
//NRB-Gem: insert attributes to existing Products added to Pricing Groups
$this->add_attribute_price($post, array('attr_id' => $attr_id, 'key' => $key));
}
}
}
// Update/insert multiple images
if (!empty($multiple_images) && !empty($image_new) && isset($image_new['data'])) {
$content_id = $image_new['data']['content_id'];
if (isset($multiple_images['action']) && !empty($multiple_images['action'])) {
foreach ($multiple_images['action'] as $value) {
$item_images = array();
if ($content_id == $value) {
continue;
}
$image_new['data']['content_id'] = $value;
$item_images[0] = $image_new;
Model_Attribute::bind_images($item_images);
}
}
if (isset($multiple_images['action_new']) && !empty($multiple_images['action_new'])) {
foreach ($multiple_images['action_new'] as $value) {
$item_images = array();
if ($content_id == $value) {
continue;
}
$image_new['data']['content_id'] = $value;
$item_images[0] = $image_new;
Model_Attribute::bind_images($item_images);
}
}
}
if ($flag) {
\Messages::success('Product successfully updated.');
}
} catch (\Database_Exception $e) {
// show validation errors
\Messages::error('<strong>There was an error while trying to update product attributes</strong>');
// Uncomment lines below to show database errors
// $errors = $e->getMessage();
// \Messages::error($errors);
\Response::redirect(\Uri::create(\Uri::admin('current'), array(), \Input::get()) . $return_to);
}
\Response::redirect(\Uri::create(\Uri::admin('current'), array(), \Input::get()) . $return_to);
}
// Get current product
$product = Model_Product::find_one_by_id($id);
// Create array for attribute group select
$attribute_groups_select = \Attribute\Model_Attribute_Group::fetch_pair('id', 'title', array(), array('0' => '- No Attributes -'));
// Set user group for lazy load
if (\Input::get('user_group')) {
Model_Attribute::set_user_group();
}
// Set tier price group for lazy load
if (\Input::get('tier_price')) {
Model_Attribute::set_tier_price();
}
$param = \Input::get();
// Find attributes for current product
$items_db = Model_Attribute::find(function ($query) use($id, $param) {
$query->select('product_attributes.*');
$query->join('attribute_groups', 'LEFT')->on('attribute_groups.id', '=', 'product_attributes.attribute_group_id');
$query->where('product_id', $id);
if (isset($param['attribute_group']) && is_numeric($param['attribute_group'])) {
$query->and_where('product_attributes.attribute_group_id', $param['attribute_group']);
}
$query->order_by('attribute_groups.sort', 'asc');
}, 'id');
// Decode attribute json
$combinations_db_arr = $this->decode_attribute_json($items_db);
// Find current attribute group
$attribute_group = array();
if (\Input::get('attribute_group')) {
$attribute_group = \Attribute\Model_Attribute_Group::find_one_by_id(\Input::get('attribute_group'));
}
// Set vars
$combinations = array();
$combinations_data = array();
$combinations_tmp = array();
$attributes_order = array();
$compared = array();
$update_items = array();
$delete_items = '';
// Create attribute combinations
if ($attribute_group && $attribute_group->attributes) {
$i = 0;
foreach ($attribute_group->attributes as $attribute) {
$attributes_order[] = $attribute->id;
if ($attribute->options) {
foreach ($attribute->options as $option) {
$combinations[$i][] = $attribute->title . ': ' . $option->title;
//$combinations[$i][] = array($attribute->title => $option->title);
$combinations_tmp[$i][] = array($attribute->id => $option->id);
}
}
$i++;
}
// Create combinations from current attributes
$combinations = $this->combos($combinations);
$combinations_tmp = $this->combos($combinations_tmp);
// Sort product atributes from database
if ($combinations_db_arr) {
$sorted_db_arr = $this->sort_array(array_keys($attribute_group->attributes), $combinations_db_arr);
if ($sorted_db_arr) {
$compared = $this->compare_array($combinations_tmp, $sorted_db_arr, $combinations_db_arr);
}
}
}
// Something crazy
if (!empty($compared) && !empty($items_db)) {
if (!empty($compared['not_exist_in1'])) {
$delete_items = array_keys($compared['not_exist_in1']);
$delete_items = implode(',', $delete_items);
}
if (!empty($compared['exist_id'])) {
$update_items = $compared['exist_id'];
}
}
// Sort array asc
$combinations_sorted = $this->sort_array_asc($combinations_tmp);
foreach ($combinations_sorted as $key => $value) {
$combinations_data[$key] = json_encode($value);
}
// Select user groups
$user_groups = \Sentry::group()->all('front');
if (!empty($user_groups)) {
$user_groups = \Model_Base::fetch_pair('id', 'name', array(), false, $user_groups);
} else {
$user_groups = array();
}
$price_select = array(3 => 'Sale Price');
$price_select_fields = array(3 => 'sale_price');
// Set default user price type or use selected
$price_field = 'sale_price';
if (isset($price_select_fields[\Input::get('special')])) {
$price_field = $price_select_fields[\Input::get('special')];
}
$listing = true;
if (\Input::get('special') == 2 && !\Input::get('tier_price')) {
$listing = false;
}
// Product pricing group
if ($item->pricing_group) {
$pricing_group = $item->pricing_group->id;
} else {
$pricing_group = false;
}
// NRB-Gem: removed logic
// Find and select tier price
// $tier_price = array();
// if(\Input::get('user_group') && is_numeric(\Input::get('user_group')) && $pricing_group)
// {
// $tier_price = \Product\Model_Group_Discounts::find(array(
// 'where' => array(
// 'user_group_id' => \Input::get('user_group'),
// 'product_group_id' => $pricing_group,
// ),
// 'order_by' => array(
// 'discount' => 'asc'
// )
// ));
// }
// Reset to empty array if there are no result found by query
if (is_null($combinations)) {
$combinations = array();
}
if (is_null($combinations_data)) {
$combinations_data = array();
}
$number_of_combinations = count($combinations);
// Pagination per page default
$per_page = \Input::get('per_page', 'all') == 'all' ? 9999 : \Input::get('per_page');
$show_all = $per_page > $number_of_combinations ? true : false;
// Initiate pagination
$pagination = \Hybrid\Pagination::make(array('total_items' => count($combinations), 'per_page' => $per_page, 'uri_segment' => null));
// Remove unwanted items, and show only required ones
$combinations = array_slice($combinations, $pagination->offset, $pagination->per_page, true);
$combinations_data = array_slice($combinations_data, $pagination->offset, $pagination->per_page, true);
\Theme::instance()->set_partial('content', $this->view_dir . 'attributes')->set('product', $product)->set('price_select', $price_select, false)->set('combinations', $combinations, false)->set('combinations_data', $combinations_data, false)->set('attribute_groups_select', $attribute_groups_select, false)->set('delete_items', $delete_items, false)->set('update_items', $update_items, false)->set('items_db', $items_db, false)->set('price_field', $price_field)->set('listing', $listing)->set('pagination', $pagination, false)->set('number_of_combinations', $number_of_combinations)->set('show_all', $show_all);
}
public function action_referrals()
{
if (strtolower(\Sentry::user()->groups()[0]['name']) != 'club members') {
\Messages::error('Only club members can access this page.');
\Response::redirect('/');
}
\View::set_global('title', 'Referrals');
$id = \Sentry::user()['id'];
$items = Model_Referal::find(function ($query) use($id) {
$query->where('user_added', $id);
$query->order_by('id', 'desc');
});
// Reset to empty array if there are no result found by query
if (is_null($items)) {
$items = array();
}
// Initiate pagination
$pagination = \Hybrid\Pagination::make(array('total_items' => count($items), 'per_page' => \Input::get('per_page', 10), 'uri_segment' => null));
// Remove unwanted items, and show only required ones
$items = array_slice($items, $pagination->offset, $pagination->per_page);
\Theme::instance()->set_partial('content', $this->view_dir . 'referrals')->set('pagination', $pagination, false)->set('items', $items);
}
public function action_list()
{
if (\Input::post('remove', false)) {
$remove = \Input::post('attribute.remove', array());
$is_remove = 0;
foreach ($remove as $value) {
if (is_numeric($value)) {
// Get news item to edit
if ($item = Model_Attribute::find_one_by_id($value)) {
// Delete item
try {
// Delete attribute options
if (!empty($item->options)) {
foreach ($item->options as $option) {
\Request::forge('admin/attribute/option/delete/' . $option->id)->execute()->response();
}
}
$item->delete();
$is_remove = 1;
} catch (\Database_Exception $e) {
\Messages::error('<strong>There was an error while trying to delete attribute</strong>');
}
}
}
}
if ($is_remove) {
\Messages::success('Attribute successfully deleted.');
}
}
\View::set_global('title', 'List Attributes');
/************ Start generating query ***********/
$items = Model_Attribute::find(function ($query) {
// Get search filters
foreach (\Input::get() as $key => $value) {
if (!empty($value) || $value == '0') {
switch ($key) {
case 'title':
$query->where($key, 'like', "%{$value}%");
break;
}
}
}
// Order query
$query->order_by('sort', 'asc');
$query->order_by('id', 'asc');
});
/************ End generating query ***********/
// Reset to empty array if there are no result found by query
if (is_null($items)) {
$items = array();
}
// Initiate pagination
$pagination = \Hybrid\Pagination::make(array('total_items' => count($items), 'per_page' => \Input::get('per_page', 10), 'uri_segment' => null));
// Remove unwanted items, and show only required ones
$items = array_slice($items, $pagination->offset, $pagination->per_page);
\Theme::instance()->set_partial('content', $this->view_dir . 'list')->set('items', $items)->set('pagination', $pagination, false);
}
public function get_search_items($parent_id = 0)
{
// Reset $parent_id if its invalid value
is_numeric($parent_id) or $parent_id = 0;
/************ Start generating query ***********/
$items = Model_Page::find(function ($query) use($parent_id) {
// Select only root pages
// $query->where('parent_id', $parent_id);
// Get search filters
foreach (\Input::get() as $key => $value) {
if (!empty($value) || $value == '0') {
switch ($key) {
case 'title':
$query->where($key, 'like', "%{$value}%");
break;
case 'status':
if (is_numeric($value)) {
$query->where($key, $value);
}
break;
case 'active_from':
$date = strtotime($value);
if ($date) {
$query->where($key, '>=', $date);
}
break;
case 'active_to':
$date = strtotime($value);
if ($date) {
$query->where($key, '<=', $date);
}
break;
}
}
}
// Order query
$query->order_by('sort', 'asc');
$query->order_by('id', 'asc');
});
/************ End generating query ***********/
// Reset to empty array if there are no result found by query
if (is_null($items)) {
$items = array();
}
// start - sort by subpage
$items_sorted = array();
$list_subpages = function ($item) use(&$list_subpages) {
$items_sorted_sub = array();
foreach ($item->children as $child) {
array_push($items_sorted_sub, $child);
if (!empty($child->children)) {
foreach ($list_subpages($child) as $value) {
array_push($items_sorted_sub, $value);
}
}
}
return $items_sorted_sub;
};
$pages = Model_Page::find(function ($query) {
// Order query
$query->order_by('sort', 'asc');
$query->order_by('id', 'asc');
});
foreach ($pages as $page) {
if ($page->parent_id == 0) {
array_push($items_sorted, $page);
foreach ($list_subpages($page) as $value) {
array_push($items_sorted, $value);
}
}
}
$final_items = array();
foreach ($items_sorted as $item_sorted) {
foreach ($items as $item) {
if ($item_sorted->id == $item->id) {
array_push($final_items, $item);
}
}
}
$items = $final_items;
// end - sort by subpage
// Initiate pagination
$pagination = \Hybrid\Pagination::make(array('total_items' => count($items), 'per_page' => \Input::get('per_page', 10), 'uri_segment' => null));
// Remove unwanted items, and show only required ones
$items = array_slice($items, $pagination->offset, $pagination->per_page);
$status = array('false' => 'Select', '1' => 'Active', '0' => 'Inactive', '2' => 'Active in period');
return array('items' => $items, 'pagination' => $pagination, 'status' => $status);
}
