'') { $sql_delete_ok = "DELETE FROM CliPreLin WHERE Id = " . $_POST['idprelindel']; $stmt = $con->prepare($sql_delete_ok); $stmt->execute(); } $_SESSION['Origen_Receptes']="Visites"; ?> "); if ($_POST['idvisitaorg']<>'') { $_SESSION['idvisita'] = $_POST['idvisitaorg']; } //echo ("SESSION idpacient = " . $_SESSION['idpacient'] . "
"); $sql_vis = "SELECT * FROM V_Visites WHERE Id =" . $_SESSION["idvisita"]; //echo $sql_vis . "
"; $stmt_vis = $con->prepare($sql_vis); $stmt_vis->execute(); $row_vis= $stmt_vis->fetch(); $sql_examen = "SELECT * FROM Visites WHERE Id =" . $_SESSION["idvisita"]; //echo $sql_vis . "
"; $stmt_examen = $con->prepare($sql_examen); $stmt_examen->execute(); $row_examen= $stmt_examen->fetch(); //echo ("rowvis = " . $row_vis['Pes'] . "
"); $_SESSION["idpacient"] = $row_vis["Id_Pacient"]; $sql = "SELECT * FROM Pacients WHERE Id =" . $row_vis["Id_Pacient"]; //echo $sql . "
"; $stmt = $con->prepare($sql); $stmt->execute(); $row = $stmt->fetch(); // Carregar dades pes pel gràfic $sql_pes = "SELECT Data, Pes FROM Visites WHERE Id_Pacient =" . $row_vis["Id_Pacient"] . " AND Pes >0"; //echo $sql . "
"; $stmt_pes = $con->prepare($sql_pes); $stmt_pes->execute(); $chart_data = ''; while ($row_pes = $stmt_pes->fetch()) { $chart_data .= "{ data:'".date('Y-m-d', strtotime($row_pes["Data"]))."', pes:".$row_pes["Pes"]."}, "; } $chart_data = substr($chart_data, 0, -2); $sql_pac = "SELECT * FROM V_Pacients WHERE Id =" . $row_vis["Id_Pacient"]; //echo $sql_pac . "
"; $stmt_pac = $con->prepare($sql_pac); $stmt_pac->execute(); $row_pac = $stmt_pac->fetch(); if ($row_pac['Raca2'] <>'') { $Raca = $row_pac['Raca2']; } else { $Raca = $row_pac[$_SESSION['Idioma_Camp']."Rac"]; } $Especie = $row_pac[$_SESSION['Idioma_Camp']."Esp"]; $Sexe = $row_pac[$_SESSION['Idioma_Camp']."Sex"]; $interval = date_diff(date_create(), date_create($row['Data_Naixement'])); if ($_SESSION['Idioma']==1) $Edat = $interval->format("%YA %MM"); if ($_SESSION['Idioma']==2) $Edat = $interval->format("%YA %MM"); if ($_SESSION['Idioma']==3) $Edat = $interval->format("%YY %MM"); ?>

'); echo ('
'. $_SESSION['Trans_258'].'

'); echo ('
'); } else { echo ('
'); echo ('
'. $_SESSION['Trans_258'].'

'.date('d/m/Y', strtotime($row_vis['Data'])). " " . date('H:i', strtotime($row_vis['Hora_Programada'])).'

'); echo ('
'); } ?>

" disabled class="form-control pull-left" placeholder="" required/>
/>
0 AND Id_Pacient = " . $_SESSION['idpacient'] . " ORDER BY Data DESC LIMIT 0,1"; //echo $sql_pes . "
"; $stmt_pes = $con->prepare($sql_pes); $stmt_pes->execute(); if ($stmt_pes->rowCount()==1) { $row_pes=$stmt_pes->fetch(); $Pes = number_format($row_pes['Pes'],1,",","."); } else { $Pes = "---"; } ?>
prepare($sql_pes); $stmt_pes->execute(); if ($stmt_pes->rowCount()==1) { $row_pes=$stmt_pes->fetch(); $Data = date('d/m/Y', strtotime($row_pes['Data'])); } else { $Data = "---"; } ?>
prepare($sql_pes); $stmt_pes->execute(); if ($stmt_pes->rowCount()==1) { $row_pes=$stmt_pes->fetch(); $sql_vet = "SELECT Nom FROM Usuarios WHERE Id = " . $row_pes['Id_Veterinari_Visita']; $stmt_vet = $con->prepare($sql_vet); $stmt_vet->execute(); $row_vet=$stmt_vet->fetch(); $Nom_Vet = $row_vet['Nom']; } else { $Nom_Vet = "---"; } ?>
"") { //echo (''); echo(''); echo('Image'); echo(''); } ?>
+'); } ?>
'); ?>
prepare($sql_docs); $stmt_docs->execute(); while ($row_docs = $stmt_docs->fetch()) { $sql_user = "SELECT Nom FROM Usuarios WHERE Id = " . $row_docs['User_Upload']; $stmt_user = $con->prepare($sql_user); $stmt_user->execute(); $row_user = $stmt_user->fetch(); ?>
Mb '); if (strtolower(substr($row_docs['Filename'],-3))=='png' or strtolower(substr($row_docs['Filename'],-3))=='jpg') echo (''); if (strtolower(substr($row_docs['Filename'],-4))=='xlsx' or strtolower(substr($row_docs['Filename'],-3))=='xls') echo (''); if (strtolower(substr($row_docs['Filename'],-4))=='docx' or strtolower(substr($row_docs['Filename'],-3))=='doc') echo (''); ?>
+'); } ?>
'); ?>
prepare($sql_docs); $stmt_docs->execute(); while ($row_docs = $stmt_docs->fetch()) { ?>
'); ?>
'); } ?> '); } else { echo (''); } ?>
'); ?>
prepare($sql_docs); $stmt_docs->execute(); while ($row_docs = $stmt_docs->fetch()) { $Autors = ""; $Keywords = ""; $sql_autors = "SELECT * FROM Usuari_Articles_Autors WHERE Id_Article = " . $row_docs["Id"] . " ORDER BY Nom ASC"; $stmt_autors = $con->prepare($sql_autors); $stmt_autors->execute(); while ($row_autors = $stmt_autors->fetch()) { if ($Autors == "") { $Autors = $row_autors['Nom']; } else { $Autors = $Autors . "; " . $row_autors['Nom']; } } $sql_keywords = "SELECT * FROM Usuari_Articles_Keywords WHERE Id_Article = " . $row_docs["Id"] . " ORDER BY Nom ASC"; $stmt_keywords = $con->prepare($sql_keywords); $stmt_keywords->execute(); while ($row_keywords = $stmt_keywords->fetch()) { if ($Keywords == "") { $Keywords = $row_keywords['Nom']; } else { $Keywords = $Keywords . "; " . $row_keywords['Nom']; } } if ($row_docs['Any_Publicacio']=="" AND $row_docs['Data_Article']<>"") { $Any_Publicacio = date('Y', strtotime($row_docs['Data_Article'])); } else { $Any_Publicacio = $row_docs['Any_Publicacio']; } ?>
> '); if (strtolower(substr($row_docs['Arxiu'],-3))=='png' or strtolower(substr($row_docs['Arxiu'],-3))=='jpg') echo (''); if (strtolower(substr($row_docs['Arxiu'],-4))=='xlsx' or strtolower(substr($row_docs['Arxiu'],-3))=='xls') echo (''); if (strtolower(substr($row_docs['Arxiu'],-4))=='docx' or strtolower(substr($row_docs['Arxiu'],-3))=='doc') echo (''); ?>
"; $stmt_cap = $con->prepare($sql_cap); $stmt_cap->execute(); $_SESSION['idpre'] = ""; if ($stmt_cap->rowCount() == 1) { $row_cap = $stmt_cap->fetch(); $_SESSION['Id_Client'] = $row_cap['Id_Client']; $_SESSION['Id_Tipus_Client'] = $row_cap['Id_Tipus_Client']; $_SESSION['Client_Dte'] = $row_cap['Dte']; $_SESSION['idpacient'] = $row_cap['Id_Pacient']; $_SESSION['datadoc'] = $row_cap['Data']; $_SESSION['idpre'] = $row_cap['Id']; $sql_sum = "SELECT SUM(Import+(Import*Pc_Iva/100)-(Import*" . $row_cap['Pc_Irpf'] . "/100)) AS Total FROM CliPreLin WHERE CliPre =" . $_SESSION['idpre']; $stmt_sum = $con->prepare($sql_sum); $stmt_sum->execute(); $row_sum = $stmt_sum->fetch(); $Total_Pressupost = $row_sum['Total']; $sql_entregat = "SELECT SUM(Import) AS Entregat FROM CliPreEnt WHERE Id_Pressupost = " . $_SESSION['idpre']; $stmt_entregat = $con->prepare($sql_entregat); $stmt_entregat->execute(); $row_entregat = $stmt_entregat->fetch(); $Total_Entregat = $row_entregat['Entregat']; $Pendent = $Total_Pressupost - $Total_Entregat; if (($Total_Pressupost - $Total_Entregat) > 0) { $_SESSION['Pendent'] = ($Total_Pressupost - $Total_Entregat); } else { $_SESSION['Pendent'] = 0; } $_SESSION['Pendent'] = number_format($_SESSION['Pendent'], 2, ".", ","); } ?>
'); } ?>

". $row_cap[$_SESSION['Idioma_Camp']."Sta"] . ""; ?>

=1 and $row_cap['Status']==1) // Està Pendent { echo(''); echo(''); } if($_SESSION['Permis']>=1 and $row_cap['Status']==2) // Està Aprovat { echo(''); echo(''); // Sinó hi ja creat ja cap albarà. No en deixo crear 2 perquè sinó podria donar-se el cas que per tots els albarans s'hi apliqués les entregues a compte del pressupost // Si es vol crear de nou, s'ha de borrar l'albarà i tornar-lo a fer. $sql_alb = "SELECT Id FROM CliAlb WHERE Id_Pressupost = " . $row_cap['Id']; $stmt=$con->prepare($sql_alb); $stmt->execute(); if ($stmt->rowCount()==0 AND $row_vis['Status']==3) { echo(''); } } if($_SESSION['Permis']>=1 and $row_cap['Status']==3) // Està Rebutjat { echo(''); echo(''); } echo(''); echo(''); ?>
€
€
€
"") { $sql = "SELECT * FROM V_CliPreLin WHERE CliPre = " . $_SESSION['idpre'] . " ORDER BY Id ASC"; $stmt = $con->prepare($sql); $stmt->execute(); $Total = 0; $Total_Unitats = 0; while ($row = $stmt->fetch()) { $Total = $Total + $row['Import']; $Total_Unitats = $Total_Unitats + $row['Quantitat']; ?>

'> '); echo (''); } ?>

'') { $base = 0; $import_iva = 0; $import_irpf = 0; $import = 0; $sql_totals = "SELECT Pc_Iva, SUM(Import) AS Base, SUM(Import_Iva) AS Import_Iva, SUM(Import_Irpf) AS Import_Irpf, SUM(Import)+SUM(Import_Iva)-SUM(Import_Irpf) AS Total FROM qabx227.V_CliPreLin WHERE CliPre = " . $_SESSION['idpre'] . " GROUP BY Pc_Iva"; $stmt_totals = $con->prepare($sql_totals); $stmt_totals->execute(); while ($row_totals = $stmt_totals->fetch()) { ?>
€ € € €
€ € € €

'') { $total_entregues = 0; $sql_entregues = "SELECT * FROM V_CliPreEnt WHERE Id_Pressupost = " . $_SESSION['idpre'] . " ORDER BY Data ASC"; $stmt_entregues = $con->prepare($sql_entregues); $stmt_entregues->execute(); while ($row_entregues = $stmt_entregues->fetch()) { ?>
€
€

'') { $DataInforme = date('Y-m-d', strtotime($row_vis['DataInforme'])); } else { $DataInforme = ""; } ?> " name="DataInforme" tabindex="0">
'); echo(''); echo(''); echo(''); ?>

+'); } ?>
'); ?>
prepare($sql_docs); $stmt_docs->execute(); while ($row_docs = $stmt_docs->fetch()) { $sql_user = "SELECT Nom FROM Usuarios WHERE Id = " . $row_docs['User_Upload']; $stmt_user = $con->prepare($sql_user); $stmt_user->execute(); $row_user = $stmt_user->fetch(); ?>
Mb '); if (strtolower(substr($row_docs['Filename'],-3))=='png' or strtolower(substr($row_docs['Filename'],-3))=='jpg') echo (''); if (strtolower(substr($row_docs['Filename'],-4))=='xlsx' or strtolower(substr($row_docs['Filename'],-3))=='xls') echo (''); if (strtolower(substr($row_docs['Filename'],-4))=='docx' or strtolower(substr($row_docs['Filename'],-3))=='doc') echo (''); ?>
prepare($sql_docs); $stmt_docs->execute(); while ($row_docs = $stmt_docs->fetch()) { ?>
user

+'); } ?>
'); ?>
prepare($sql_docs); $stmt_docs->execute(); while ($row_docs = $stmt_docs->fetch()) { ?>
'); ?>
+'); } ?>
'); ?>
prepare($sql_docs); $stmt_docs->execute(); while ($row_docs = $stmt_docs->fetch()) { ?>
'0000-00-00') echo date('d/m/Y', strtotime($row_docs['Data'])); ?> '0000-00-00') echo date('d/m/Y', strtotime($row_docs['Data_Seguent'])); ?>
prepare($sql_docs); $stmt_docs->execute(); while ($row_docs = $stmt_docs->fetch()) { ?>
'0000-00-00') echo date('d/m/Y', strtotime($row_docs['Data'])); ?> '0000-00-00') echo date('d/m/Y', strtotime($row_docs['Data_Seguent'])); ?>
prepare($sql_docs); $stmt_docs->execute(); while ($row_docs = $stmt_docs->fetch()) { ?>

(Kg)

prepare($sql_docs); $stmt_docs->execute(); while ($row_docs = $stmt_docs->fetch()) { ?>

prepare($sql_docs); $stmt_docs->execute(); while ($row_docs = $stmt_docs->fetch()) { if ($row_docs['Medicament'] <>"0") { $Medicament = substr($row_docs['NomMedicament'],0,60); } else { $Medicament = $row_docs['Medicament2']; } if ($row_docs['Data_Fi']=="0000-00-00") { $Data_Fi = ""; } else { $Data_Fi = date('d/m/Y', strtotime($row_docs['Data_Fi'])); } ?>

/>

prepare($sql_docs); $stmt_docs->execute(); while ($row_docs = $stmt_docs->fetch()) { ?>
'0000-00-00') echo date('d/m/Y', strtotime($row_docs['Data'])); ?> '0000-00-00') echo date('d/m/Y', strtotime($row_docs['Data_Seguent'])); ?>

2) $col=6; ?>
'); echo(''); echo('
'); $Status = 4; echo('
'); echo(''); echo('
'); $Status = 5; echo('
'); echo(''); echo('
'); } if ($row_vis['Status']==2) { $Status = 3; echo('
'); echo(''); echo('
'); } ?>