* @license    GNU General Public License, see http://www.gnu.org/licenses/gpl.html
 * @version    $Revision: 19286 $
 */
CCanDo::checkRead();
$category_id = CValue::get('category_id');
$keywords = CValue::get('keywords');
$selected_product = CValue::get('selected_product');
$product = new CProduct();
$category = new CProductCategory();
$total = null;
$count = null;
$where_or = array();
$order = 'name, code';
//FIXME: changer en seek
if ($keywords) {
    foreach ($product->getSeekables() as $field => $spec) {
        $where_or[] = "`{$field}` LIKE '%{$keywords}%'";
    }
    $where = array();
    $where[] = implode(' OR ', $where_or);
    $where[] = "cancelled IS NULL OR cancelled = '0'";
    $list_products = $product->loadList($where, $order, 20);
    $total = $product->countList($where);
} else {
    if ($category_id == 0) {
        $list_products = $product->loadList(null, $order);
    } else {
        if ($category_id == -1) {
            $list_products = array();
        } else {
            $category->load($category_id);