[SOLVED] Admin product list limit

Code: Select all

$this->config->get('config_limit_admin')

Code: Select all

<div class="col-sm-1 text-left">

	<select onchange="custom_list_limits(this.value)" class="form-control">
		<option value="*"></option>
			  {% for list_limit in list_limits %}
				  {% if list_limit ==  list_limit_value  %}
				  	<option value="{{ list_limit }}" selected="selected">{{ list_limit }}</option>
				  {% else %}
					<option value="{{ list_limit }}">{{ list_limit }}</option>
				  {% endif %}
			 {% endfor %}
	</select>

</div>

Code: Select all

<script>//Set the product list limit within the product list (this will also set the limit for all other lists in the admin). 
		//Come back to this at some point to make it only for the product list

	function custom_list_limits(str) {

		var xmlhttp = new XMLHttpRequest();

		//Send the limit count to the function to update the database
		xmlhttp.open("GET","index.php?route=catalog/product/custom_pass_new_limit&user_token={{ user_token }}&q="+str,true);
		xmlhttp.send();

		//Sleep so the database has time to update
		wait(250);  //.25 seconds in milliseconds

		//Reset the window with the new limit set
		window.location = ('/admin/index.php?route=catalog/product&user_token={{ user_token }}')

	}

	//Sleep
	function wait(ms){
		var start = new Date().getTime();
		var end = start;
		while(end < start + ms) {
			end = new Date().getTime();
		}
	}
</script>

Code: Select all

		$data['list_limits'] = array();
		$data['list_limits'] = array(
			'25'	=> "25",
			'50' 	=> "50",
			'75'	=> "75",
			'100'	=> "100",
			'150'	=> "150",
			'200' 	=> "200",
			'250'	=> "250",
			'300'	=> "300"
		);

		$data['list_limit_value'] = $this->config->get('config_limit_admin');

Code: Select all

public function custom_pass_new_limit() {

	$q = intval($_GET['q']);

	if (isset($q) && $q > 1) {
		$newlimit = $q;
	} else {
		$newlimit = $this->config->get('config_limit_admin');
	}

	$this->load->model('catalog/product');

	$this->model_catalog_product->custom_set_new_limit($newlimit);

//$this->getList();
}

Code: Select all

public function custom_set_new_limit($str_limit) {

	$this->db->query("UPDATE " . DB_PREFIX . "setting SET VALUE = '" . (int)$str_limit . "' WHERE `key` = 'config_limit_admin'");

}