1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: 132: 133: 134: 135: 136: 137: 138: 139: 140: 141: 142: 143: 144: 145: 146: 147: 148: 149: 150: 151: 152: 153: 154: 155: 156: 157: 158: 159: 160: 161: 162: 163: 164: 165: 166: 167: 168: 169: 170: 171: 172: 173: 174: 175: 176: 177: 178: 179: 180: 181: 182: 183: 184: 185: 186: 187: 188: 189: 190: 191: 192: 193: 194: 195: 196: 197: 198: 199: 200: 201: 202: 203: 204: 205: 206: 207: 208: 209: 210: 211: 212: 213: 214: 215: 216: 217: 218: 219: 220: 221: 222: 223: 224: 225: 226: 227: 228: 229: 230: 231: 232: 233: 234: 235: 236: 237: 238: 239: 240: 241: 242: 243: 244: 245: 246: 247: 248: 249: 250: 251: 252: 253: 254: 255: 256: 257: 258: 259: 260: 261: 262: 263: 264: 265: 266: 267: 268: 269: 270: 271: 272: 273: 274: 275: 276: 277: 278: 279: 280: 281: 282: 283: 284: 285: 286: 287: 288: 289: 290: 291: 292: 293: 294: 295: 296: 297: 298: 299: 300: 301: 302: 303: 304: 305: 306: 307: 308: 309: 310: 311: 312: 313: 314: 315: 316: 317: 318: 319: 320: 321: 322: 323: 324: 325: 326: 327: 328: 329: 330: 331: 332: 333: 334: 335: 336: 337: 338: 339: 340: 341: 342: 343: 344: 345: 346: 347: 348: 349: 350: 351: 352: 353: 354: 355: 356: 357: 358: 359: 360: 361: 362: 363: 364: 365: 366: 367: 368: 369: 370: 371: 372: 373: 374: 375: 376: 377: 378: 379: 380: 381: 382: 383: 384: 385: 386: 387: 388: 389: 390: 391: 392: 393: 394: 395: 396: 397: 398: 399: 400: 401: 402: 403: 404: 405: 406: 407: 408: 409: 410: 411: 412: 413: 414: 415: 416: 417: 418: 419: 420: 421: 422: 423: 424: 425: 426: 427: 428: 429: 430: 431: 432: 433: 434: 435: 436: 437: 438: 439: 440: 441: 442: 443: 444: 445: 446:
<?php
if (!defined("OBJENABLED")) {
require_once(dirname(__FILE__) . "/array.class.php");
require_once(dirname(__FILE__) . "/category.class.php");
}
class PHPShopSort {
var $debug = false;
var $disp;
function __construct($category = null, $sort = null, $direct = true, $template = null, $vendor = false, $filter = true, $goodoption = true, $cache_enabled = true, $cattemplate = null, $getall = false) {
global $PHPShopSystem;
$sql_add = null;
if ($direct)
$this->direct();
if (!empty($sort))
$sort = unserialize($sort);
elseif (!empty($category)) {
$PHPShopCategory = new PHPShopCategory($category);
$sort = $PHPShopCategory->unserializeParam('sort');
}
if (!empty($category)) {
$PHPShopOrm = new PHPShopOrm($GLOBALS['SysValue']['base']['categories']);
$cache = $PHPShopOrm->select(array('sort_cache'), array('id=' => $category));
$this->sort_cache = unserialize($cache['sort_cache']);
}
if ($cache_enabled) {
$this->filter_cache_enabled = $PHPShopSystem->ifSerilizeParam('admoption.filter_cache_enabled');
$this->count_products = $PHPShopSystem->ifSerilizeParam('admoption.filter_products_count');
}
else
$this->filter_cache_enabled = $this->count_products = false;
if ($filter)
$sql_add.=" and filtr='1' ";
if (empty($goodoption))
$sql_add.=" and goodoption!='1' ";
$sortList = null;
if (is_array($sort)) {
foreach ($sort as $value) {
$sortList.=' id=' . trim($value) . ' OR';
}
$sortList = substr($sortList, 0, strlen($sortList) - 2);
if (defined("HostID"))
$sql_add .= " and servers REGEXP 'i" . HostID . "i'";
elseif (defined("HostMain"))
$sql_add .= ' and (servers ="" or servers REGEXP "i1000i")';
$PHPShopOrm = new PHPShopOrm();
$PHPShopOrm->debug = $this->debug;
$PHPShopOrm->comment = __CLASS__ . '.' . __FUNCTION__;
$result = $PHPShopOrm->query("select * from " . $GLOBALS['SysValue']['base']['sort_categories'] . " where ($sortList) " . $sql_add . " order by num, name");
while (@$row = mysqli_fetch_array($result)) {
$id = $row['id'];
$name = $row['name'];
if (empty($row['virtual']) or !empty($getall))
$this->disp.=$this->value($id, $name, true, $template, $vendor, $row['description']);
if (!empty($row['virtual']))
$this->catdisp.=$this->value($id, $name, true, $cattemplate);
}
}
}
function direct() {
global $SysValue;
switch (@$_GET['f']) {
case(1):
$SysValue['other']['productSortNext'] = 2;
$SysValue['other']['productSortImg'] = 1;
$SysValue['other']['productSortTo'] = 1;
break;
case(2):
$SysValue['other']['productSortNext'] = 1;
$SysValue['other']['productSortImg'] = 2;
$SysValue['other']['productSortTo'] = 2;
break;
default:
$SysValue['other']['productSortNext'] = 2;
$SysValue['other']['productSortTo'] = 1;
}
switch (@$_GET['s']) {
case(1):
$SysValue['other']['productSortA'] = "sortActiv";
$SysValue['other']['productSort'] = 1;
break;
case(2):
$SysValue['other']['productSortB'] = "sortActiv";
$SysValue['other']['productSort'] = 2;
break;
case(3):
$SysValue['other']['productSortC'] = "sortActiv";
$SysValue['other']['productSort'] = 3;
break;
case(4):
$SysValue['other']['productSortD'] = "sortActiv";
$SysValue['other']['productSort'] = 4;
break;
default:
$SysValue['other']['productSort'] = 1;
}
if (empty($_GET['v'])) {
$SysValue['other']['productVendor'] = "";
} else {
$productVendor = null;
if (is_array($_GET['v'])) {
foreach ($_GET['v'] as $k => $v)
if (is_array($v))
foreach ($v as $vs)
$productVendor.='v[' . intval($k) . '][]=' . intval($vs) . '&';
$productVendor = substr($productVendor, 0, strlen($productVendor) - 1);
}
$SysValue['other']['productVendor'] = $productVendor;
}
$SysValue['other']['productRriceOT'] = PHPShopSecurity::TotalClean(@$_POST['priceOT'], 1);
$SysValue['other']['productRriceDO'] = PHPShopSecurity::TotalClean(@$_POST['priceDO'], 1);
}
function value($n, $title, $all = false, $template = null, $vendor = false, $help = null) {
global $SysValue;
$disp = null;
$i = 1;
if (empty($vendor)) {
if (empty($_POST['v']))
$vendor = @$SysValue['nav']['query']['v'];
else
$vendor = $_POST['v'];
}
if (!empty($all) and empty($template)) {
$value[] = array($title, '', $all_sel);
}
$all_sel = 'selected';
$PHPShopOrm = new PHPShopOrm();
$PHPShopOrm->debug = $this->debug;
$PHPShopOrm->comment = __CLASS__ . '.' . __FUNCTION__;
$result = $PHPShopOrm->query("select * from " . $SysValue['base']['sort'] . " where category=" . intval($n) . " order by num,name");
while ($row = mysqli_fetch_array($result)) {
$id = $row['id'];
$name = substr($row['name'], 0, 35);
$sel = null;
if (is_array($vendor))
foreach ($vendor as $v) {
if ($id == $v) {
$sel = "selected";
$all_sel = null;
}
}
if (is_array($this->sort_cache['filter_cache'][$n]) && $this->filter_cache_enabled) {
if (!in_array($id, $this->sort_cache['filter_cache'][$n])) {
if (!empty($this->sort_cache['products'][$n][$id]) && $this->count_products) {
$value[$i] = array($name, $id, $sel, $this->sort_cache['products'][$n][$id], $row['icon']);
$i++;
} else {
$value[$i] = array($name, $id, $sel, null, $row['icon']);
$i++;
}
}
} else {
if (!empty($this->sort_cache['products'][$n][$id]) && $this->count_products) {
$value[$i] = array($name, $id, $sel, $this->sort_cache['products'][$n][$id], $row['icon']);
$i++;
} else {
$value[$i] = array($name, $id, $sel, null, $row['icon']);
$i++;
}
}
}
$SysValue['sort'][] = $n;
if (empty($template) && !empty($value)) {
$size = (strlen($title) + 7) * 6;
$disp = PHPShopText::select('v[' . $n . ']', $value, $size, false, false, false, false, false, $n);
} elseif (function_exists($template)) {
$disp = call_user_func_array($template, array($value, $n, $title, $vendor, $help));
}
$this->value_array = $value;
return $disp;
}
function categories() {
return $this->catdisp;
}
function display() {
global $SysValue;
$v_ids = null;
if (!empty($this->disp)) {
if (is_array($SysValue['sort']))
foreach ($SysValue['sort'] as $value)
$v_ids.=$value . ",";
$len = strlen($v_ids);
$v_ids = substr($v_ids, 0, $len - 1);
$SysValue['other']['vendorSelectDisp'] = PHPShopText::button($SysValue['lang']['sort_apply'], $onclick = 'GetSortAll(' . $SysValue['nav']['id'] . ',' . $v_ids . ')', 'ok', 'vendorActionButton');
$SysValue['other']['vendorSelectDisp'].=' ' . PHPShopText::button($SysValue['lang']['sort_reset'], $onclick = 'window.location.replace(\'?\')');
$SysValue['other']['vendorDispTitle'] = PHPShopText::div(PHPShopText::b($SysValue['lang']['sort_title']));
}
return PHPShopText::td($this->disp);
}
function getContent() {
return $this->disp;
}
}
function sorttemplateexample($value, $n, $title, $vendor) {
$disp = null;
if (is_array($value)) {
foreach ($value as $p) {
if (is_array($vendor[$n])) {
foreach ($vendor[$n] as $value) {
if ($value == $p[1])
$text = PHPShopText::b($p[0]);
else
$text = $p[0];
$disp.=PHPShopText::br() . PHPShopText::a('?v[' . $n . ']=' . $p[1], $text, $p[0], $color = false, $size = false, $target = false, $class = false);
}
}else {
if ($vendor[$n] == $p[1])
$text = PHPShopText::b($p[0]);
else
$text = $p[0];
$disp.=PHPShopText::br() . PHPShopText::a('?v[' . $n . ']=' . $p[1], $text, $p[0], $color = false, $size = false, $target = false, $class = false);
}
}
}
return $disp;
}
class PHPShopSortArray extends PHPShopArray {
function __construct($sql = false, $debug = false) {
$this->objSQL = $sql;
$this->debug = $debug;
$this->objBase = $GLOBALS['SysValue']['base']['sort'];
parent::__construct('id', 'name', 'page');
}
}
class PHPShopSortCategoryArray extends PHPShopArray {
function __construct($sql = false, $debug = false) {
$this->objSQL = $sql;
$this->debug = $debug;
$this->order = array('order' => 'num desc, name');
$this->objBase = $GLOBALS['SysValue']['base']['sort_categories'];
parent::__construct('id', 'name', 'category', 'filtr', 'page', 'optionname', 'goodoption');
}
}
class PHPShopParentNameArray extends PHPShopArray {
function __construct($sql = false, $debug = false) {
$this->objSQL = $sql;
$this->debug = $debug;
$this->order = array('order' => 'name');
$this->objBase = $GLOBALS['SysValue']['base']['parent_name'];
parent::__construct('id', 'name','color');
}
}
class PHPShopSortSearch {
function __construct($name) {
$PHPShopOrm = new PHPShopOrm($GLOBALS['SysValue']['base']['sort_categories']);
$PHPShopOrm->debug = false;
$data = $PHPShopOrm->select(array('id'), array('name' => '="' . $name . '"'), false, array('limit' => 1));
if (is_array($data)) {
$this->sort_category = $data['id'];
$PHPShopOrm = new PHPShopOrm($GLOBALS['SysValue']['base']['sort']);
$PHPShopOrm->debug = false;
$data = $PHPShopOrm->select(array('id,name'), array('category' => '=' . $this->sort_category), false, array('limit' => 100));
if (is_array($data)) {
foreach ($data as $val)
$this->sort_array[$val['id']] = $val['name'];
}
}
}
function search($row) {
if (is_array($row))
foreach ($row as $val) {
if (!empty($this->sort_array[$val[0]])) {
return $this->sort_array[$val[0]];
}
}
}
}
?>