@@ -92,10 +92,10 @@ |
||
92 | 92 | public function getTaxByProduct($idproducto, $rdtaxid, $use = 'venta'): ?ImpuestoProducto |
93 | 93 | { |
94 | 94 | $dataBase = new DataBase(); |
95 | - $sql = "SELECT * FROM impuestosproductos WHERE idproducto = " . |
|
96 | - self::toolBox()->utils()->intval($idproducto) . |
|
97 | - " AND codimpuesto = '" . self::toolBox()->utils()->normalize($rdtaxid) . "'" . |
|
98 | - " AND " . $use . " = true" . ";"; |
|
95 | + $sql = "SELECT * FROM impuestosproductos WHERE idproducto = ". |
|
96 | + self::toolBox()->utils()->intval($idproducto). |
|
97 | + " AND codimpuesto = '".self::toolBox()->utils()->normalize($rdtaxid)."'". |
|
98 | + " AND ".$use." = true".";"; |
|
99 | 99 | $data = $dataBase->select($sql); |
100 | 100 | if (empty($data) === true || in_array($data[0], [null, ''], true)) { |
101 | 101 | return null; |
@@ -33,7 +33,7 @@ |
||
33 | 33 | $sqlType = " INDEX "; |
34 | 34 | $dataBase->exec("set FOREIGN_KEY_CHECKS=0;"); |
35 | 35 | } |
36 | - $result = $dataBase->exec("ALTER TABLE FACTURASPROV DROP " . $sqlType . |
|
36 | + $result = $dataBase->exec("ALTER TABLE FACTURASPROV DROP ".$sqlType. |
|
37 | 37 | " IF EXISTS uniq_empresancf_facturasprov;"); |
38 | 38 | if (strtoupper(FS_DB_TYPE) === 'MYSQL') { |
39 | 39 | $dataBase->exec("set FOREIGN_KEY_CHECKS=1;"); |