'https://gestorvr.qualitat.cl/api/auth/token',
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => '',
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 0,
CURLOPT_FOLLOWLOCATION => true,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => 'POST',
CURLOPT_POSTFIELDS =>'{
"username":"araucocurricular",
"password":"arauco@2021",
"grant_type":"password",
"client_id":"client_araucocurricular",
"client_secret":"Wah4FAbLr6q4HZuB"
}',
CURLOPT_HTTPHEADER => array(
'Content-Type: application/json',
'Cookie: PHPSESSID=ik02k081o6b8n31n5a4p76b5ba'
),
));
$response = curl_exec($curl);
$json=json_decode($response);
$mData=$json->token;//obtengo el token para conexion
//echo $mData;
curl_close($curl);
$curl = curl_init();
$pagina=1;
$verdadero=false;
while ($pagina<=500)
{
curl_setopt_array($curl, array(
CURLOPT_URL => 'https://gestorvr.qualitat.cl/api/v1/araucocurricular?page='.$pagina,
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 => array(
'Authorization: Bearer '.$mData
),
));
$response = curl_exec($curl);
$json=json_decode($response, true);
if ($json==$guarda)
{
$verdadero=true;
$pagina=501;
}
else
{
$guarda=$json;
}
if ($verdadero == false)
{
foreach ($json as $record) {
$id = $record['data']['trab_rut'];
$conduc = $record['data']['con_nota'];
$dec = $record['data']['dec_nota'];
$id1 = $record['id'];
$cadena=str_replace(' ', '', $id);
// echo "'".$id1."' = '".$cadena."'
";
// echo "'".$conduc."'
";
// echo "'".$dec."'
";
$sql4="UPDATE trabajador_prueba2 SET ev_conducta='".$conduc."',ev_percepcion='".$dec."' WHERE rut='".$id."' and cod_empresa=7";
$result4= mysql_query($sql4, $link);
}
}
$pagina=$pagina+1;
}
curl_close($curl);
$total=3;
return($total);
}
?>