1485955957 and $row['datemodified']<>1575638715 and $row['datemodified']<>1383743515 and $row['datemodified']<>1575638825 and $row['notes']<>'Vaimed Sync') {
$yearcode=date("Y",$row['datemodified']);
$monthyearcode=date("Yn",$row['datemodified']);
$daymonthyearcode=date("dnY",$row['datemodified']);
$monthcode=date("n",$row['datemodified']);
$monthlist[$monthcode]= isset($monthlist[$monthcode]) ? $monthlist[$monthcode]+1 : 1;
$yeartotal[$yearcode]= isset($yeartotal[$yearcode]) ? $yeartotal[$yearcode]+1 : 1;
$monthyeartotal[$monthyearcode]= isset($monthyeartotal[$monthyearcode]) ? $monthyeartotal[$monthyearcode]+1 : 1;
$daymonthyeartotal[$daymonthyearcode]= isset($daymonthyeartotal[$daymonthyearcode]) ? $daymonthyeartotal[$daymonthyearcode]+1 : 1;
}
}
// Lets do some numbers
$monthsmessage = "";
$monthsmessage .= "| Year | ";
$month=1;
while ($month < 13) {
$monthsmessage .= "$month | ";
$month++;
}
$monthsmessage .= "Total |
";
foreach ($yeartotal as $year => $yeartot) {
$monthsmessage .= "| $year | ";
$month=1;
$linetotal=0;
while ($month < 13) {
$monthyearcode=$year.$month;
$monthyeartotal[$monthyearcode]= isset($monthyeartotal[$monthyearcode]) ? $monthyeartotal[$monthyearcode] : 0;
$monthsmessage .= "".$monthyeartotal[$monthyearcode]." | ";
$linetotal=$linetotal+$monthyeartotal[$monthyearcode];
$month++;
}
$monthsmessage .= "$linetotal |
";
}
$monthsmessage .= "
";
$monthsmessage .= "";
print "$monthsmessage";
// Dev mode banner: show when amendment log folder or source files are missing
$devBanner = "";
if (!is_dir("/var/www/vmserver10/intranet/amendmentlog")) {
$devBanner .= "";
$devBanner .= "Dev Mode: Amendment log folder does not exist. File copying will be skipped.";
$devBanner .= "
";
}
print $devBanner;
print "";
$s="SELECT id, location, phpfile, datemodified, datecreated FROM phplisting";
$result=sqlquery($s);
$num=mysqli_num_rows($result);
while ($row=mysqli_fetch_array($result))
{
$filelocation="".$row['location']."".$row['phpfile']."";
$filemd5=md5($filelocation);
// limiters
//
if ((isset($lastcre[$filemd5]) && $lastcre[$filemd5]=='' or isset($lastmod[$filemd5]) && $lastmod[$filemd5] != $row['datemodified']) )
{
//print "MD5 THIS : `
$filemd5 $filelocation
`";
//print "$filemd5 ".(isset($lastcre[$filemd5]) ? $lastcre[$filemd5] : '')."=='' or ".(isset($lastmod[$filemd5]) ? $lastmod[$filemd5] : '')." != ".$row['datemodified']."
";
$lastmod[$filemd5]=$row['datemodified'];
$lastcre[$filemd5]=$row['datecreated'];
// need to now copy the file into the Daily Amendment log
$yearmod=date("Y",$row['datemodified']);
$monthmod=date("M",$row['datemodified']);
$daymod=date("d",$row['datemodified']);
// try to make year folder /var/www/vmserver10/intranet/
$folder="/var/www/vmserver10/intranet/amendmentlog/$yearmod";
try {
//print "$folder
";
if (!is_dir($folder)) {
mkdir($folder, 0777, true);
}
$folder .= "/".$monthmod;
//print "$folder
";
if (!is_dir($folder)) {
mkdir($folder, 0777, true);
}
$folder .= "/".$daymod;
//print "$folder
";
if (!is_dir($folder)) {
mkdir($folder, 0777, true);
}
}
catch (Exception $e) {
}
$src=$row['location']."/".$row['phpfile'];
// Skip if source file does not exist (dev machine case)
if (!file_exists($src)) {
// print "Missing source file: $src
";
continue;
}
$filecode=md5_file($src);
if (!isset($filecodelist[$filecode])) {
// Check if file exists before trying to copy it
if (file_exists($src)) {
$folder .= "/".$filecode;
$dst = $folder;
print "Source: $src
Destination: $dst $filecode
";
copy($src, $dst);
$i = "INSERT INTO phplisting_auditlog (location ,phpfile , datemodified , datecreated , filecode )
VALUES ('".$row['location']."','".$row['phpfile']."','".$row['datemodified']."','".$row['datecreated']."','".$filecode."')";
sqlquery($i);
$reload = 1;
} else {
// Optionally log or print a message if the source file is missing
print "Missing source file: $src
";
}
}
// copy the file into folder
}
}
?>
Examine Tables / Files:
Search Table name Path or File
">Update to bring in todays changes
0) {
print "
Required Updates
";
}
?>
Amendment Log
">Complete PDF
">Tabled: last 12 months
| Edit | Date Modified | Location | File | Archive Code | Notes | Verification |
";
$s="SELECT id, location, phpfile, datemodified, filecode, notes, verification FROM phplisting_auditlog where
notes !='Added to Intrastats Amendment Log' and
notes !='Review Only' and
notes !='reviewed' and notes =''
order by
datemodified desc";
$result=sqlquery($s);
$num=mysqli_num_rows($result);
while ($row=mysqli_fetch_array($result))
{
$moddate=date (" h:i:s A d M Y",$row['datemodified']);
$link=date("Y",$row['datemodified'])."/".date("M",$row['datemodified'])."/".date("d",$row['datemodified'])."/";
print "| ";
?>
&fileid=">
| $moddate | ".$row['location']." | ".$row['phpfile']." | ".$row['filecode']." | ".$row['notes']." | ".$row['verification']." | ";
print " |
";
}
if (isset($reload) && $reload==1)
{
?>
";
}
}
echo '
';
print "$lastfile";
?>
find in File
hi