private static function buildDBPrd($dpPrd, $pdo) { $db = DB::get(); $stmt = $pdo->prepare("SELECT * FROM PRODUCTS_CAT WHERE PRODUCT = :id"); $stmt->execute(array(':id' => $dpPrd['ID'])); $prdCat = $stmt->fetch(); $visible = $prdCat !== false; $dispOrder = null; if ($visible) { $dispOrder = $prdCat['CATORDER']; } return Product::__build($dpPrd['ID'], $dpPrd['REFERENCE'], $dpPrd['NAME'], $dpPrd['PRICESELL'], $dpPrd['CATEGORY'], $dpPrd['PROVIDER'], $dispOrder, $dpPrd['TAXCAT'], $visible, $db->readBool($dpPrd['ISSCALE']), $dpPrd['PRICEBUY'], $dpPrd['ATTRIBUTESET_ID'], $dpPrd['CODE'], $dpPrd['IMAGE'] !== null, $db->readBool($dpPrd['DISCOUNTENABLED']), $dpPrd['DISCOUNTRATE']); }