function get_items_manage_table($items, $controller)
{
$CI =& get_instance();
$table = '<table class="tablesorter" id="sortable_table">';
$headers = array('<input type="checkbox" id="select_all" />', $CI->lang->line('items_name'), $CI->lang->line('items_category'), $CI->lang->line('items_cost_price'), $CI->lang->line('items_unit_price'), $CI->lang->line('items_tax_percents'), $CI->lang->line('items_quantity'), ' ');
$table .= '<thead><tr>';
foreach ($headers as $header) {
$table .= "<th>{$header}</th>";
}
$table .= '</tr></thead><tbody>';
$table .= get_items_manage_table_data_rows($items, $controller);
$table .= '</tbody></table>';
return $table;
}
function search()
{
$search = $this->input->post('search');
$this->item_lib->set_item_location($this->input->post('stock_location'));
$stock_location = $this->item_lib->get_item_location();
$data['search_section_state'] = $this->input->post('search_section_state');
$low_inventory = $this->input->post('low_inventory');
$is_serialized = $this->input->post('is_serialized');
$no_description = $this->input->post('no_description');
$search_custom = $this->input->post('search_custom');
$is_deleted = $this->input->post('is_deleted');
// Parq 131215
$limit_from = $this->input->post('limit_from');
$lines_per_page = $this->Appconfig->get('lines_per_page');
$items = $this->Item->search($search, $stock_location, $low_inventory, $is_serialized, $no_description, $search_custom, $is_deleted, $lines_per_page, $limit_from);
$data_rows = get_items_manage_table_data_rows($items, $this);
$total_rows = $this->Item->get_found_rows($search, $stock_location, $low_inventory, $is_serialized, $no_description, $search_custom, $is_deleted);
$links = $this->_initialize_pagination($this->Item, $lines_per_page, $limit_from, $total_rows, 'search');
$data_rows = get_items_manage_table_data_rows($items, $this);
$this->_remove_duplicate_cookies();
echo json_encode(array('total_rows' => $total_rows, 'rows' => $data_rows, 'pagination' => $links));
}
function search()
{
$search = $this->input->post('search');
$this->item_lib->set_item_location($this->input->post('stock_location'));
$data['search_section_state'] = $this->input->post('search_section_state');
$limit_from = $this->input->post('limit_from');
$lines_per_page = $this->Appconfig->get('lines_per_page');
// assume year 2010 as starting date for OSPOS
$start_of_time = date($this->config->item('dateformat'), mktime(0, 0, 0, 1, 1, 2010));
$today = date($this->config->item('dateformat'));
$start_date = $this->input->post('start_date') != NULL ? $this->input->post('start_date', TRUE) : $start_of_time;
$start_date_formatter = date_create_from_format($this->config->item('dateformat'), $start_date);
$end_date = $this->input->post('end_date') != NULL ? $this->input->post('end_date', TRUE) : $today;
$end_date_formatter = date_create_from_format($this->config->item('dateformat'), $end_date);
$filters = array('start_date' => $start_date_formatter->format('Y-m-d'), 'end_date' => $end_date_formatter->format('Y-m-d'), 'stock_location_id' => $this->item_lib->get_item_location(), 'empty_upc' => $this->input->post('empty_upc'), 'low_inventory' => $this->input->post('low_inventory'), 'is_serialized' => $this->input->post('is_serialized'), 'no_description' => $this->input->post('no_description'), 'search_custom' => $this->input->post('search_custom'), 'is_deleted' => $this->input->post('is_deleted'));
$items = $this->Item->search($search, $filters, $lines_per_page, $limit_from);
$data_rows = get_items_manage_table_data_rows($items, $this);
$total_rows = $this->Item->get_found_rows($search, $filters);
$links = $this->_initialize_pagination($this->Item, $lines_per_page, $limit_from, $total_rows, 'search');
$data_rows = get_items_manage_table_data_rows($items, $this);
$this->_remove_duplicate_cookies();
echo json_encode(array('total_rows' => $total_rows, 'rows' => $data_rows, 'pagination' => $links));
}
function search()
{
$search = $this->input->post('search');
$stock_location = $this->item_lib->get_item_location();
$data_rows = get_items_manage_table_data_rows($this->Item->search($search, $stock_location), $this);
echo $data_rows;
}
function search()
{
$search = $this->input->post('search');
$data_rows = get_items_manage_table_data_rows($this->Item->search($search), $this);
echo $data_rows;
}
function get_items_manage_table($items, $controller)
{
$CI =& get_instance();
$has_cost_price_permission = $CI->Employee->has_module_action_permission('items', 'see_cost_price', $CI->Employee->get_logged_in_employee_info()->person_id);
$table = '<table class="table tablesorter table-bordered table-striped table-hover" id="sortable_table">';
if ($has_cost_price_permission) {
$headers = array('<input type="checkbox" id="select_all" />', $CI->lang->line('items_item_id'), $CI->lang->line('items_item_number'), $CI->lang->line('items_name'), $CI->lang->line('items_category'), $CI->lang->line('items_size'), $CI->lang->line('items_cost_price'), $CI->lang->line('items_unit_price'), $CI->lang->line('items_quantity'), $CI->lang->line('items_inventory'), $CI->lang->line('items_clone'), $CI->lang->line('common_edit'), ' ');
} else {
$headers = array('<input type="checkbox" id="select_all" />', $CI->lang->line('items_item_id'), $CI->lang->line('items_item_number'), $CI->lang->line('items_name'), $CI->lang->line('items_category'), $CI->lang->line('items_size'), $CI->lang->line('items_unit_price'), $CI->lang->line('items_quantity'), $CI->lang->line('items_inventory'), $CI->lang->line('items_clone'), $CI->lang->line('common_edit'), ' ');
}
$table .= '<thead><tr>';
$count = 0;
foreach ($headers as $header) {
$count++;
if ($count == 1) {
$table .= "<th class='leftmost'>{$header}</th>";
} elseif ($count == count($headers)) {
$table .= "<th class='rightmost'>{$header}</th>";
} else {
$table .= "<th>{$header}</th>";
}
}
$table .= '</tr></thead><tbody>';
$table .= get_items_manage_table_data_rows($items, $controller);
$table .= '</tbody></table>';
return $table;
}
function search()
{
$this->check_action_permission('search');
$search = $this->input->post('search');
$category = $this->input->post('category');
$offset = $this->input->post('offset') ? $this->input->post('offset') : 0;
$order_col = $this->input->post('order_col') ? $this->input->post('order_col') : 'name';
$order_dir = $this->input->post('order_dir') ? $this->input->post('order_dir') : 'asc';
$item_search_data = array('offset' => $offset, 'order_col' => $order_col, 'order_dir' => $order_dir, 'search' => $search, 'category' => $category);
$this->session->set_userdata("item_search_data", $item_search_data);
$per_page = $this->config->item('number_of_items_per_page') ? (int) $this->config->item('number_of_items_per_page') : 20;
$search_data = $this->Item->search($search, $category, $per_page, $this->input->post('offset') ? $this->input->post('offset') : 0, $this->input->post('order_col') ? $this->input->post('order_col') : 'name', $this->input->post('order_dir') ? $this->input->post('order_dir') : 'asc');
$config['base_url'] = site_url('items/search');
$config['total_rows'] = $this->Item->search_count_all($search, $category);
$config['per_page'] = $per_page;
$this->pagination->initialize($config);
$data['pagination'] = $this->pagination->create_links();
$data['manage_table'] = get_items_manage_table_data_rows($search_data, $this);
echo json_encode(array('manage_table' => $data['manage_table'], 'pagination' => $data['pagination']));
}
