✏️ Editing: graficaclick.php

<?php
require('diag.php');
include("../conex.php");
$fecha= date("Y-m-d");
$id= isset($_GET['id']) ? $_GET['id'] : '' ;

$clickabrir=0;   
                   $sql=$conex->query ("SELECT * FROM solicitud WHERE  id='$id'") or die(mysqli_error());   
                   if($row_cnt = $sql->num_rows>0) {       
                   while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) {                       
                       $titulo=$row['titulo'];   
                            }
                      }
                   $clickvera=0;   
                   $sql=$conex->query ("SELECT * FROM clicks WHERE  solicitud='$id' and tipo='2' ") or die(mysqli_error());   
                   if($row_cnt = $sql->num_rows>0) {       
                   while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) {                       
                       $clickvera++;
                            }
                      }
                   $clickaceptar=0;   
                   $sql=$conex->query ("SELECT * FROM clicks WHERE  solicitud='$id' and tipo='3' ") or die(mysqli_error());   
                   if($row_cnt = $sql->num_rows>0) {       
                   while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) {                       
                       $clickaceptar++;
                            }
                      }
                   $clickrechazar=0;   
                   $sql=$conex->query ("SELECT * FROM clicks WHERE  solicitud='$id' and tipo='4' ") or die(mysqli_error());   
                   if($row_cnt = $sql->num_rows>0) {       
                   while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) {                       
                       $clickrechazar++;
                            }
                      }
                   $clickverificar=0;   
                   $sql=$conex->query ("SELECT * FROM clicks WHERE  solicitud='$id' and tipo='5' ") or die(mysqli_error());   
                   if($row_cnt = $sql->num_rows>0) {       
                   while ($row = $sql->fetch_array(MYSQLI_ASSOC) ) {                       
                       $clickverificar++;
                            }
                      }

$pdf = new PDF_Diag();
$pdf->AddPage();

$data = array('Ver Ahora' => $clickvera,  'Rechazar Solicitud' => $clickrechazar,'Verificar' => $clickverificar);

//Pie chart
$pdf->Cell(10, 10, '', 0);
$pdf->Image('upload/red.PNG' ,15 ,15, 30 , 30,'PNG');
//$pdf->Image('../static/images/dac.jpg' , 300 ,22, 20 , 20,'jpg');

$pdf->Ln(20);
$pdf->SetFont('Arial', '', 12);
$pdf->Cell(70, 10, '', 0);
$pdf->Cell(10, 10, 'InRed Reporte Clicks en la Solicitud', 0);
$pdf->Ln(10);
$pdf->Cell(55, 10, '', 0);
$pdf->Cell(10, 10, $titulo, 0);

$pdf->Ln(20);
$pdf->SetFont('Arial', 'BIU', 12);
$pdf->Cell(0, 5, 'GRAFICA DE TORTA', 0, 1);
$pdf->Ln(8);

$pdf->SetFont('Arial', '', 10);
$valX = $pdf->GetX();
$valY = $pdf->GetY();
$pdf->Cell(30, 5, '');
$pdf->Cell(15, 5, '', 0, 0, 'R');
$pdf->Ln();
$pdf->Cell(30, 5, '');
$pdf->Cell(15, 5, '', 0, 0, 'R');
$pdf->Ln();
$pdf->Cell(30, 5, '');
$pdf->Cell(15, 5, '', 0, 0, 'R');
$pdf->Ln();
$pdf->Ln(8);

$pdf->SetXY(90, $valY);
$col1=array(100,100,255);
$col2=array(255,100,100);
$col3=array(255,255,100);
$col4=array(0, 128, 0);
$col5=array(128, 0, 128);
$col6=array(128, 0, 0);
$col7=array(128, 128, 128);
$pdf->PieChart(100, 35, $data, '%l (%p)', array($col1,$col2,$col3,$col4));
$pdf->SetXY($valX, $valY + 40);

//Bar diagram
$pdf->SetFont('Arial', 'BIU', 12);
$pdf->Cell(0, 5, 'GRAFICA DE BARRAS', 0, 1);
$pdf->Ln(8);
$valX = $pdf->GetX();
$valY = $pdf->GetY();
$pdf->BarDiagram(190, 70, $data, '%l : %v (%p)', array(255,175,100));
$pdf->SetXY($valX, $valY + 80);

$pdf->Output();
?>

Ubuntu

Sid Gifari From Gifari Industries - BD Cyber Security Team



Ubuntu

Sid Gifari From Gifari Industries - BD Cyber Security Team