connect_error) { die("Connection failed: " . $mysqli->connect_error); } $mysqli->query('DELETE FROM tempinvpremarpico WHERE 1;'); $mysqli->query('ALTER TABLE tempinvpremarpico AUTO_INCREMENT=1;'); $curl = curl_init(); curl_setopt_array($curl, [ CURLOPT_URL => 'https://marpicoprod.azurewebsites.net/api/inventarios/materialesAPI?Api-Key=kUyXVyyWSLBpZPc2nkaZK9hOeyXHWzPnP6EJaF7zHaijSU523sayzmC2ZDJSi6p4', CURLOPT_RETURNTRANSFER => true, CURLOPT_ENCODING => '', CURLOPT_MAXREDIRS => 10, CURLOPT_TIMEOUT => 0, CURLOPT_FOLLOWLOCATION => true, CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1, CURLOPT_CUSTOMREQUEST => 'GET', CURLOPT_HTTPHEADER => [ 'Authorization: Api-Key kUyXVyyWSLBpZPc2nkaZK9hOeyXHWzPnP6EJaF7zHaijSU523sayzmC2ZDJSi6p4' ], ]); $response = curl_exec($curl); curl_close($curl); $response = substr($response, 50, -1); echo "Codificacion Marpico //"; $HoraInicio = date('h:i:s') . " - "; echo $HoraInicio; $jsonDecoded = json_decode($response, true); $totaldatos = 920; $i = 0; foreach ($jsonDecoded as $data) { $i++; $porcentaje = $i * 100 / $totaldatos; echo ""; flush(); ob_flush(); for ($k = 0; $k <= 20; $k++) { $codigo = $data['materiales'][$k]['codigo']; $raiz = $data['familia']; $variacion = $data['materiales'][$k]['color_nombre']; $proveedor = 'Marpico'; $stock = $data['materiales'][$k]['inventario']; $precio = "Precio de Lista: " . $data['materiales'][$k]['precio']; $preciounitario = $data['materiales'][$k]['precio']; $label = ''; $descuento = ((int)$data['materiales'][$k]['descuento'] * -1) / 100; $idraiz = $raiz . "_08"; $idatributo = $codigo . "_08"; $sql = "INSERT INTO `tempinvpremarpico` (codigo, raiz, variacion, proveedor, stock, precio, preciounitario, descuento, label, idraiz, idatributo) VALUES ('$codigo', '$raiz', '$variacion', '$proveedor', '$stock', '$precio', '$preciounitario', '$descuento', '$label', '$idraiz', '$idatributo')"; $mysqli->query($sql); } } $mysqli->query('DELETE FROM invpremarpico WHERE 1;'); $mysqli->query('ALTER TABLE invpremarpico AUTO_INCREMENT=1;'); $sql = "INSERT INTO `invpremarpico` (codigo, raiz, variacion, proveedor, stock, precio, preciounitario, descuento, label, idraiz, idatributo) SELECT codigo, raiz, variacion, proveedor, stock, precio, preciounitario, descuento, label, idraiz, idatributo FROM tempinvpremarpico WHERE preciounitario > 0"; $mysqli->query($sql); echo $HoraFin; ?>