alxarafe / alixar

Dolibarr/Code/Product/Api/Products.php

Spacing +37 added lines, -37 removed lines

@@ -339,7 +339,7 @@ 
 
         // Select products of given category
         if ($category > 0) {
-            $sql .= " AND c.fk_categorie = " . ((int)$category);
+            $sql .= " AND c.fk_categorie = " . ((int) $category);
             $sql .= " AND c.fk_product = t.rowid";
         }
         if ($mode == 1) {
@@ -418,9 +418,9 @@ 
 
             $obj_ret['data'] = $tmp;
             $obj_ret['pagination'] = array(
-                'total' => (int)$total,
+                'total' => (int) $total,
                 'page' => $page, //count starts from 0
-                'page_count' => ceil((int)$total / $limit),
+                'page_count' => ceil((int) $total / $limit),
                 'limit' => $limit
             );
         }
@@ -999,7 +999,7 @@ 
         if ($result <= 0) {
             throw new RestException(500, "Error updating buy price : " . $this->db->lasterror());
         }
-        return (int)$this->productsupplier->product_fourn_price_id;
+        return (int) $this->productsupplier->product_fourn_price_id;
     }
 
     /**
@@ -1082,15 +1082,15 @@ 
         $sql .= ' WHERE t.entity IN (' . getEntity('product') . ')';
 
         if ($supplier > 0) {
-            $sql .= " AND s.fk_soc = " . ((int)$supplier);
+            $sql .= " AND s.fk_soc = " . ((int) $supplier);
         }
         if ($socid > 0) {   // if external user
-            $sql .= " AND s.fk_soc = " . ((int)$socid);
+            $sql .= " AND s.fk_soc = " . ((int) $socid);
         }
         $sql .= " AND s.fk_product = t.rowid";
         // Select products of given category
         if ($category > 0) {
-            $sql .= " AND c.fk_categorie = " . ((int)$category);
+            $sql .= " AND c.fk_categorie = " . ((int) $category);
             $sql .= " AND c.fk_product = t.rowid";
         }
         if ($mode == 1) {
@@ -1285,7 +1285,7 @@ 
         }
 
         $prodattr = new ProductAttribute($this->db);
-        $result = $prodattr->fetch((int)$id);
+        $result = $prodattr->fetch((int) $id);
 
         if ($result < 0) {
             throw new RestException(404, "Product attribute not found");
@@ -1301,11 +1301,11 @@ 
 
         $sql = "SELECT COUNT(*) as nb FROM " . $this->db->prefix() . "product_attribute_combination2val as pac2v";
         $sql .= " JOIN " . $this->db->prefix() . "product_attribute_combination as pac ON pac2v.fk_prod_combination = pac.rowid";
-        $sql .= " WHERE pac2v.fk_prod_attr = " . ((int)$prodattr->id) . " AND pac.entity IN (" . getEntity('product') . ")";
+        $sql .= " WHERE pac2v.fk_prod_attr = " . ((int) $prodattr->id) . " AND pac.entity IN (" . getEntity('product') . ")";
 
         $resql = $this->db->query($sql);
         $obj = $this->db->fetch_object($resql);
-        $prodattr->is_used_by_products = (int)$obj->nb;
+        $prodattr->is_used_by_products = (int) $obj->nb;
 
         return $this->_cleanObjectDatas($prodattr);
     }
@@ -1350,12 +1350,12 @@ 
 
         $sql = "SELECT COUNT(*) as nb FROM " . $this->db->prefix() . "product_attribute_combination2val as pac2v";
         $sql .= " JOIN " . $this->db->prefix() . "product_attribute_combination as pac ON pac2v.fk_prod_combination = pac.rowid";
-        $sql .= " WHERE pac2v.fk_prod_attr = " . ((int)$result->rowid) . " AND pac.entity IN (" . getEntity('product') . ")";
+        $sql .= " WHERE pac2v.fk_prod_attr = " . ((int) $result->rowid) . " AND pac.entity IN (" . getEntity('product') . ")";
 
         $resql = $this->db->query($sql);
         $obj = $this->db->fetch_object($resql);
 
-        $attr["is_used_by_products"] = (int)$obj->nb;
+        $attr["is_used_by_products"] = (int) $obj->nb;
 
         return $attr;
     }
@@ -1400,12 +1400,12 @@ 
 
         $sql = "SELECT COUNT(*) as nb FROM " . $this->db->prefix() . "product_attribute_combination2val as pac2v";
         $sql .= " JOIN " . $this->db->prefix() . "product_attribute_combination as pac ON pac2v.fk_prod_combination = pac.rowid";
-        $sql .= " WHERE pac2v.fk_prod_attr = " . ((int)$result->rowid) . " AND pac.entity IN (" . getEntity('product') . ")";
+        $sql .= " WHERE pac2v.fk_prod_attr = " . ((int) $result->rowid) . " AND pac.entity IN (" . getEntity('product') . ")";
 
         $resql = $this->db->query($sql);
         $obj = $this->db->fetch_object($resql);
 
-        $attr["is_used_by_products"] = (int)$obj->nb;
+        $attr["is_used_by_products"] = (int) $obj->nb;
 
         return $attr;
     }
@@ -1463,7 +1463,7 @@ 
 
         $prodattr = new ProductAttribute($this->db);
 
-        $result = $prodattr->fetch((int)$id);
+        $result = $prodattr->fetch((int) $id);
         if ($result == 0) {
             throw new RestException(404, 'Attribute not found');
         } elseif ($result < 0) {
@@ -1484,7 +1484,7 @@ 
         }
 
         if ($prodattr->update(DolibarrApiAccess::$user) > 0) {
-            $result = $prodattr->fetch((int)$id);
+            $result = $prodattr->fetch((int) $id);
             if ($result == 0) {
                 throw new RestException(404, 'Attribute not found');
             } elseif ($result < 0) {
@@ -1514,7 +1514,7 @@ 
         }
 
         $prodattr = new ProductAttribute($this->db);
-        $prodattr->id = (int)$id;
+        $prodattr->id = (int) $id;
         $result = $prodattr->delete(DolibarrApiAccess::$user);
 
         if ($result <= 0) {
@@ -1580,7 +1580,7 @@ 
             throw new RestException(403);
         }
 
-        $sql = "SELECT rowid, fk_product_attribute, ref, value FROM " . $this->db->prefix() . "product_attribute_value WHERE rowid = " . (int)$id . " AND entity IN (" . getEntity('product') . ")";
+        $sql = "SELECT rowid, fk_product_attribute, ref, value FROM " . $this->db->prefix() . "product_attribute_value WHERE rowid = " . (int) $id . " AND entity IN (" . getEntity('product') . ")";
 
         $query = $this->db->query($sql);
 
@@ -1624,7 +1624,7 @@ 
         $ref = trim($ref);
 
         $sql = "SELECT rowid, fk_product_attribute, ref, value FROM " . $this->db->prefix() . "product_attribute_value";
-        $sql .= " WHERE ref LIKE '" . $this->db->escape($ref) . "' AND fk_product_attribute = " . ((int)$id) . " AND entity IN (" . getEntity('product') . ")";
+        $sql .= " WHERE ref LIKE '" . $this->db->escape($ref) . "' AND fk_product_attribute = " . ((int) $id) . " AND entity IN (" . getEntity('product') . ")";
 
         $query = $this->db->query($sql);
 
@@ -1667,7 +1667,7 @@ 
         $ref = trim($ref);
 
         $sql = "SELECT rowid FROM " . $this->db->prefix() . "product_attribute_value";
-        $sql .= " WHERE ref LIKE '" . $this->db->escape($ref) . "' AND fk_product_attribute = " . ((int)$id) . " AND entity IN (" . getEntity('product') . ")";
+        $sql .= " WHERE ref LIKE '" . $this->db->escape($ref) . "' AND fk_product_attribute = " . ((int) $id) . " AND entity IN (" . getEntity('product') . ")";
         $query = $this->db->query($sql);
 
         if (!$query) {
@@ -1709,7 +1709,7 @@ 
 
         $objectval = new ProductAttributeValue($this->db);
 
-        $return = $objectval->fetchAllByProductAttribute((int)$id);
+        $return = $objectval->fetchAllByProductAttribute((int) $id);
 
         if (count($return) == 0) {
             throw new RestException(404, 'Attribute values not found');
@@ -1785,7 +1785,7 @@ 
         }
 
         $objectval = new ProductAttributeValue($this->db);
-        $objectval->fk_product_attribute = ((int)$id);
+        $objectval->fk_product_attribute = ((int) $id);
         $objectval->ref = $ref;
         $objectval->value = $value;
 
@@ -1814,7 +1814,7 @@ 
         }
 
         $objectval = new ProductAttributeValue($this->db);
-        $result = $objectval->fetch((int)$id);
+        $result = $objectval->fetch((int) $id);
 
         if ($result == 0) {
             throw new RestException(404, 'Attribute value not found');
@@ -1836,7 +1836,7 @@ 
         }
 
         if ($objectval->update(DolibarrApiAccess::$user) > 0) {
-            $result = $objectval->fetch((int)$id);
+            $result = $objectval->fetch((int) $id);
             if ($result == 0) {
                 throw new RestException(404, 'Attribute not found');
             } elseif ($result < 0) {
@@ -1866,7 +1866,7 @@ 
         }
 
         $objectval = new ProductAttributeValue($this->db);
-        $objectval->id = (int)$id;
+        $objectval->id = (int) $id;
 
         if ($objectval->delete(DolibarrApiAccess::$user) > 0) {
             return 1;
@@ -1893,16 +1893,16 @@ 
         }
 
         $prodcomb = new ProductAttributeCombination($this->db);
-        $combinations = $prodcomb->fetchAllByFkProductParent((int)$id);
+        $combinations = $prodcomb->fetchAllByFkProductParent((int) $id);
 
         foreach ($combinations as $key => $combination) {
             $prodc2vp = new ProductCombination2ValuePair($this->db);
-            $combinations[$key]->attributes = $prodc2vp->fetchByFkCombination((int)$combination->id);
+            $combinations[$key]->attributes = $prodc2vp->fetchByFkCombination((int) $combination->id);
             $combinations[$key] = $this->_cleanObjectDatas($combinations[$key]);
 
             if (!empty($includestock) && DolibarrApiAccess::$user->hasRight('stock', 'lire')) {
                 $productModel = new Product($this->db);
-                $productModel->fetch((int)$combination->fk_product_child);
+                $productModel->fetch((int) $combination->fk_product_child);
                 $productModel->load_stock($includestock);
                 $combinations[$key]->stock_warehouse = $this->_cleanObjectDatas($productModel)->stock_warehouse;
             }
@@ -1934,11 +1934,11 @@ 
         }
 
         $prodcomb = new ProductAttributeCombination($this->db);
-        $combinations = $prodcomb->fetchAllByFkProductParent((int)$this->product->id);
+        $combinations = $prodcomb->fetchAllByFkProductParent((int) $this->product->id);
 
         foreach ($combinations as $key => $combination) {
             $prodc2vp = new ProductCombination2ValuePair($this->db);
-            $combinations[$key]->attributes = $prodc2vp->fetchByFkCombination((int)$combination->id);
+            $combinations[$key]->attributes = $prodc2vp->fetchByFkCombination((int) $combination->id);
             $combinations[$key] = $this->_cleanObjectDatas($combinations[$key]);
         }
 
@@ -1985,15 +1985,15 @@ 
         $prodattr = new ProductAttribute($this->db);
         $prodattr_val = new ProductAttributeValue($this->db);
         foreach ($features as $id_attr => $id_value) {
-            if ($prodattr->fetch((int)$id_attr) < 0) {
+            if ($prodattr->fetch((int) $id_attr) < 0) {
                 throw new RestException(400, 'Invalid attribute ID: ' . $id_attr);
             }
-            if ($prodattr_val->fetch((int)$id_value) < 0) {
+            if ($prodattr_val->fetch((int) $id_value) < 0) {
                 throw new RestException(400, 'Invalid attribute value ID: ' . $id_value);
             }
         }
 
-        $result = $this->product->fetch((int)$id);
+        $result = $this->product->fetch((int) $id);
         if (!$result) {
             throw new RestException(404, 'Product not found');
         }
@@ -2042,10 +2042,10 @@ 
         $prodattr = new ProductAttribute($this->db);
         $prodattr_val = new ProductAttributeValue($this->db);
         foreach ($features as $id_attr => $id_value) {
-            if ($prodattr->fetch((int)$id_attr) < 0) {
+            if ($prodattr->fetch((int) $id_attr) < 0) {
                 throw new RestException(404);
             }
-            if ($prodattr_val->fetch((int)$id_value) < 0) {
+            if ($prodattr_val->fetch((int) $id_value) < 0) {
                 throw new RestException(404);
             }
         }
@@ -2089,7 +2089,7 @@ 
         }
 
         $prodcomb = new ProductAttributeCombination($this->db);
-        $prodcomb->fetch((int)$id);
+        $prodcomb->fetch((int) $id);
 
         foreach ($request_data as $field => $value) {
             if ($field == 'rowid') {
@@ -2129,7 +2129,7 @@ 
         }
 
         $prodcomb = new ProductAttributeCombination($this->db);
-        $prodcomb->id = (int)$id;
+        $prodcomb->id = (int) $id;
         $result = $prodcomb->delete(DolibarrApiAccess::$user);
         if ($result <= 0) {
             throw new RestException(500, "Error deleting variant");